Want to create interactive content? It’s easy in Genially!

Get started free

MnGeo Reflection

Greg

Created on October 10, 2025

Start designing with a free template

Discover more than 1500 professional designs like these:

Terrazzo Presentation

Visual Presentation

Relaxing Presentation

Modern Presentation

Colorful Presentation

Modular Structure Presentation

Chromatic Presentation

Transcript

MnGeo Reflection

Greg Kohler

go

Agenda

18

3-8

27

DCYF Access Equity Areas

Background

OCM Social Equity 1

19

28

10

OSA Rewrite

Parcels

OCM Social Equity 2

29

20

11

DCYF Community Action Agencies

DEED Broadband

Duplicate County Boundaries

30

21

12

Presentations

Closed Landfills

Government Owned Lands

22-25

13-16

31-34

Geospatial Commons Modernization

Reflection

Executive Map Portfolio

Introduction

This presentation walks through my time at the Minnesota Geospatial Information Office (MnGeo) and the skills I have gained. MnGeo is an office within Minnesota IT Services that provides state agencies with GIS support. The office maintains the Minnesota Geospatial Commons, manages GIS systems, and creates GIS applications for state agencies.

Position

The position allows student workers to take part in several different projects to improve their education. This includes:

The responsibilities of the Student GIS Technician position were broad. While many MnGeo employees focus on large projects, student workers are tasked with working on a wide array of projects, both big and small. This includes:

  • Python
  • SQL
  • Cartography
  • QA/QC
  • Data Processing
  • Creating datasets for the Minnesota Geospatial Commons
  • Preparing maps and applications for other agencies
  • Statewide parcel data maintenance
  • Updating existing datasets

There is always something new to work on at MnGeo

Timeline

December 2023

Started at MnGeo

December 2023

Introducted to Parcels

Over my time at MnGeo, my work evolved from attribute editing and QA/QC to data automation and web cartography.

January 2024

Started on Executive Map Portfolio

March 2024

Started on PCA Closed Landfills

June 2024

Created OCM Social Equity Map

July 2024

Introduced to OSA Rewrite

July 2024

Introduced to Geospatial Commons Modernization

Standout projects have developed skillsets and opened new opportunities for me.

September 2024

New County Boundaries

December 2024

Government Owned Lands tool

March 2025

Started on DCYF Web Maps

Executive Summary

Throughout my time at MnGeo, I’ve taken on a wide range of projects that have strengthened my technical foundation and professional skillset. Exposure to statewide datasets helped build my confidence in data management, attribute analysis, and QA/QC. Contributing to the Executive Map Portfolio increased my experience in web cartography and communication. Additional projects helped deepen my experience in mapping applications, SQL, and dataset creation. Involvement in the Minnesota Geospatial Commons Modernization project further advanced my abilities in Python scripting, GIS development, automation, and collaboration. This experience taught me how to create efficient workflows and communicate complex information clearly to internal and external partners. Additional initiatives challenged me to create more interactive applications. These experiences also improved my ability to translate technical work into accessible products for different audiences. Overall, my time at MnGeo has helped me grow as a GIS professional. I have become more confident, adaptable, and capable of taking on projects and responsibilities. I look forward to continuing to build on these skills in future work.

Skills

Before beginning at MnGeo, I had developed a set of skills from prior employment and the MGIS program, but I knew I had room to grow.

Foundations

Starting out at MnGeo

Parcels from all counties are aggregated quarterly

County Parcels

One of the first projects I worked on was modifying the script for county parcel aggregation. I later worked on reviewing county parcel data before aggregation.

  • Python Scripting
  • Exploring data sources
  • QA/QC
  • Attribute consistency

Counties can decide whether to make their data public

+ info

DEED Broadband

Another early project was working with the Department of Employment and Economic Development (DEED) on broadband access. This project utilized satellite imagery and parcel data to identify buildings that may need broadband access. Building points were added or modified based on the FCC's guidelines.

  • Visual inspection
  • Attribute editing
  • QGIS
  • Critical thinking

Landfill elements were carefully digitized

Closed Landfills

This project involved working with the Minnesota Pollution Control Agency (MPCA) to update and digitize their closed landfill dataset.

  • PLSS
  • Coordinate geometry (COGO)
  • Attribute editing
  • Digitization
  • Legal documents

+ info

Executive Map Portfolio

A Foundational Project

Background

This project began with a generic portfolio of maps curated by Esri for the State of Minnesota. I was tasked with taking this portfolio and customizing it to suit our state better. Our team was unsure if this would be utilized. We experimented with different ideas, such as combining several layers into one web application for interactivity, but it didn't stick.

Lessons in Cartography

After some experimentation, interest in the project picked up. The Governor's Office and Esri offered their support to have the portfolio ready for the Governor's Presentation at the Esri User Conference. I learned new cartographic lessons while creating and customizing the maps.

Effective at all zoom levels

Informative pop-ups

Simple layers

Telling a story

Other tips and tricks

Color as a tool

Click on each icon for more information

Executive Portfolio Maps

After completing the portfolio, the Governor showcased the maps at the 2024 Esri User Conference, and it is now publicly available. The portfolio currently has 59 maps.

Growth and Collaborations

Continuing to Develop
I also created web maps that went beyond visualization. I helped create an application for the Office of Cannabis Management (OCM) that utilized Arcade expressions and census tract data to show users if they lived in an eligible neighborhood. This application was cartographically simply, but a powerful tool for users to understand their eligibility status.

OCM Social Equity

Users simply search for their address and the application brings up their census tract and criteria.

The information relevant to the user is stored in the pop-up.

  • Arcade
  • Census Data
  • Instant App
  • Web Mapping

OSA Rewrite

I started to get involved in the technical side of MnGeo. I was onboarded to the rewrite of the Office of the State Archaeologist (OSA) Portal. I was tasked with creating SQL scripts for table creation and data migration. Through this project, I learned about the iterative approach to developing and the importance of the Development, Testing, and Production environments.

  • PostgreSQL
  • Enterprise Database
  • Development
  • ArcGIS Server

The interational border had to be adjusted to match International Boundary Commision.

Duplicate County Boundaries

Creating open data is an important role of MnGeo. I worked with MnGeo's surveyor to create a new county boundary dataset using existing data. This task involved geoprocessing, manual editing, and survey data.

  • Geoprocessing
  • Feature editing
  • QA/QC
  • Survey maps

The Metropolitan Council's boundaries were used for the Twin Cities metro area.

+ info

Government Owned Lands

The government owned lands dataset is created alongside the quarterly parcel aggregation. Inherited from DNR, I modified the script and was tasked with updating the dataset every quarter. This task utilized a Python script and a list of queries to find government owned lands in Minnesota. I quickly learned the importance of quality control, as small changes in the parcel data can impact the output of the script.

  • Python
  • Custom ArcGIS Pro Tools
  • QA/QC
  • Field Attributes

Minnesota Geospatial Commons Modernization

Becoming a Developer

Background

Another formative project has been working on the Geospatial Commons Modernization project. This project aims to move from the legacy system to an Esri-based system. The Geospatial Commons is an important resource for GIS users across the state to easily access open data from many publishers.I began the project as support, but soon took over the scripting tasks. The scripts aimed to validate that items meet criteria and move the item to the new site. Most of the criteria were connected to metadata.

Development

Through development and scripting, I learned several new skills:

  • Azure Function Apps - Scripted 3 function apps that run on timer and blob triggers.
  • ArcGIS API for Python - Managing items, sharing to groups, and publishing.
  • Worked with Azure Blob Storage and file management.
  • Built custom metadata parsers and validation processes.
  • Improved my Python coding structure.
  • Created and updated SQL tables.
  • Learned about developer testing and bug fixing.
  • Gained comfort with GitHub repositories.

Collaboration

Beyond technical skills, this project also contributed to my communication skills through:

  • Collaboration with colleagues to review scripts and database design.
  • Working with colleagues to develop script testing plans.
  • Onboarding partner organizations to the new system.
  • Learning the importance of documentation (diagrams, workflow descriptions, etc).
  • Frequent calls and meetings with the team to solve roadblocks.

This project took me from a casual coder to a collaborative developer.

Continued Growth

Additional Projects and Skills

DCYF Access Equity Areas

This simple web application was made for the Department of Children, Youth, and Families (DCYF). The application allows users to search for an address and see if it is within an Access Equity Area. This was important for planning and directing funding. This map was created using data provided by DCYF and joining it to census tract data. The map itself is simple, displaying access equity areas as blue and other areas as gray.

  • Instant Apps
  • Census Data
  • Agency Partners

OCM Social Equity 2

Darker red areas met the most criteria. While there were 6 criteria, a score of 5 was the darkest color.

I was asked to create an expanded version of the first OCM Social Equity Map. This map added Veteran Status and Farmers' Income as criteria. In addition to displaying the criteria in pop-ups, I also created a choropleth map using a criteria score. This application allowed the OCM team to focus their efforts on areas with the most criteria met.

The application allowed users to zoom into the Twin Cities metro due to the small size of the tracts.

  • Experience Builder
  • Arcade
  • Chloropleth Mapping
  • Census Data

+ info

DCYF Community Action Agencies

To demonstrate the abilities of web mapping, I also created an Experience Builder application for DCYF. This application showcased Community Action Agencies and Diaper Distribution Partners. The addresses were provided, and I geocoded them. This map utilized bright, distinct symbology to differentiate the different distribution partners and agencies. A fun challenge was adding the ability to highlight the counties each agency serves when selected.

  • Experience Builder
  • Geocoding
  • Web Cartography
  • Agency Partners

Presentations

GIS is about collaboration!

A couple of projects I worked on were complemented by a presentation, including the OCM Social Equity Map. Presented as a GIS Bytes for the State of Minnesota, I showed colleagues the power of Arcade and Instant Apps. I also presented at MN GIS/LIS 2025. My team showcased the Executive Map Portfolio and gave guidance for users to make their own.

  • Communication
  • Public Speaking

Reflection

Skills Learned & Conclusion

Gained Skills

With almost 2 years at MnGeo and in the MGIS program, I have leveled up my skills and gained new ones. There is always room to grow, but I feel more competent as a GIS professional.

Reflection

Collaboration
Technical Growth
Cartography
  • Understood the importance of documenting work
  • Gained confidence in presentations and meetings
  • Learned how to work with people involved at all levels of a project
  • Transitioned to writing and maintaining scripts
  • Gained skills in code formatting and readability
  • Learned the power of automation
  • Became comfortable using ecosystems with multiple parts
  • Importance of the map's purpose
  • Learned about the hierarchy of design elements
  • Understanding of how to design maps for different audiences
  • Built confidence designing maps

Conclusion

At MnGeo, I learned more than GIS and Cartography, I learned how to be a professional in the field. I plan to continue:

  • Fusing cartography with interactivity and technical elements
  • Building the skillset of a GIS developer
  • Improving collaboration skills with colleagues and agency partners

I hope to have a long career in GIS built on the foundations from my time at MnGeo

Thank you to my colleauges at MnGeo and the faculty of the MGIS program!

OCM Social Equity 2

The second iteration of this application was more interactive, as it was intended for internal use. Users could select census tracts based on the criteria they met. They could also export the information as a CSV for further investigation.

Closed Landfills

Working with land agreements

Digitizing the closed landfills relied on information from several land agreement documents. These documents would provide descriptions of the land in PLSS or in precise coordinate measurements. These documents include:

  • Easements
  • Cleanup Agreements
  • Convenants
  • State Bonds

These land agreements have precise language, often down to less than half a foot. Several had conflicting information, which required careful investigation to find the most current information.

Zoom Levels

Web maps are not static. Users can zoom in and out to view areas of interest. I learned the importance of the map being informative at every zoom level. County level data needs to change to the tract level or even the block group level as the zoom level changes. The data needs to become more fine-grained to continue telling the story of the map.

Burdensome Housing Costs

Other Tips and Tricks

I also learned miscellaneous tips to make web maps look better. These include:

  • Subtle gray boundaries
  • Color-blind friendly ramps
  • Filtering data
  • Changing default scale

For example, the map on the left shows broadband speed at the census tract level. It tells a more engaging story than displaying at the county level.

Broadband Speed

Parcel Aggregation

An essential task

Parcels for Minnesota's 87 counties are aggregated quarterly. Counties are expected to provide updated parcel data due to state statute. However, not all counties update their data this often. Sometimes, counties also change their data structure. Parcel data is obtained from several sources, including web services, cloud storage, or via email. If the data structure changes, the aggregation script must be updated to accurately standardize the data.

All parcel data is standardized to meet the Geospatial Advisory Committee (GAC) standards. This standard includes 91 fields, but many of them are optional.

Simple Layers

While working through these maps, I quickly learned the power of simple layers. Simplistic layers tell an easy to understand story for all audiences. Instead of overburdening the map with data, it can be more effective to choose 1 or 2 informational layers.

For example, showcasing each county's manufacturing share tells an effective story without needing additional data points.

Manufacturing Share of Economy

Color

While working with the Esri team, I learned the power of color. Certain colors, like red or green, come with positive or negative connotations. When trying to tell a positive story, it is important to avoid certain colors. I also learned the importance of lighter versus darker colors. Users tend to assume darker colors are 'larger' or carry more importance.

Burdensome Housing Costs

Informative Pop-ups

Pop-ups are a powerful part of web cartography. I learned they can help support the information on the map without a visual overload. It allows users to get additional data on the areas they care about.

The pop-up on the left is from the Free School Meals map. It provides both a numerical and visual extension to the information provided on the map.

Pop-up for Free School Meals

County Boundaries

Combining datasets

The Minnesota Geospatial Commons had several county boundary datasets from different sources. The Minnesota State Agency GIS Collaborative wanted to create a single, authoritative dataset. To do this, I utilized data from the Metropolitan Council, MnDOT, DNR, and the International Boundary Commission to create a new county boundary dataset. This process involved unionizing and merging the datasets and manually selecting which overlapping boundaries belong to which county.

This project provided insight into the importance of surveying and documentation. Several boundaries were ambiguous and required survey records to determine their county ownership.

Telling a Story

One of my most valuable lessons was the importance of telling a story with the map. When making a map, it is important to ask, "What am I trying to show my audience?"

For example, the map on the left shows wind speed and wind turbines. By aggregating the wind turbines, the map shows users that the southwest of the state has a high number of wind turbines and higher wind speeds.

Wind Power