Automating City Parcel Updates

Eden Prairie uses Hennepin County's parcel data to ensure data quality between the city and county.  Hennepin County sends updated parcel shapefiles to Eden Prairie, the downfall is that the data is for the entire county, and in Eden Prairie's case any data outside of the city is irrelevant.

The code create from model builder automates the process of updating the city parcels, deleting the unnecessary data, adds relevant fields to comply with Eden Prairie's data and correctly stores to files. The process of updating this information is rather tedious but is a reoccurring update to the database every couple months.

The model builder and a few custom codes completely automated the process to save time and energy on mundane tasks.

View Entire Code bit.ly/2OO7GYq

Section 1 

Create new feature class

 Append Hennepin county parcels to new feature class

Clip the parcels to include only Eden Prairie city limits

Erase Hennepin County river valley parcels (At the time requested to stay the same for GIS database).  

Merge current river valley parcels to the new parcels 

Section 2
Copy Rows from existing city file to new parcel shapefile
Join field data from update Hennepin County parcels to new parcel shapefile
Calculate each field to pull data from Hennepin County file to new parcel attribute table
 

Section 3
Complete row calculations
Notify user of the completion
Delete unnecessary files to clean up database
Rename the edited shapefile for clarity on the most recently updated file
Notify user of the successful update! 

View Entire Code bit.ly/2OO7GYq

Eden Prairie Snow Removal Route

A snow removal map created for the Public Works Department of Eden Prairie and residents for the snow removal routes the city will follow during winter months.

View Map bit.ly/2JmDcHa

Mapbook Creation

One of my first projects working for Eden Prairie was to create a mapbook for the Assessing Department of Eden Prairie. The team used it as a reference tool for the neighborhoods located in the city limits. Check out a few pages below or go to bit.ly/2D2xytv for the full book!
 

View complete mapbook at bit.ly/2D2xytv

During the creation of  the mapbook I was able to add a few fun python codes to my toolbox in order to manipulate lovely PDF documents. Check out the codes below!

This code exported the completed mapbook pages into a PDF format. 

To complete the document I appended the title page, index, and map pages together to create a final PDF of the project. 

Automating Workflow For Processing New Data

This project was completed for my Programming GIS course. The purpose of the code is to automate processing of new GPS data by merging the imported shapefile to a specific basefile.

The code is useful when the collection of new data is being undergone. From my experience as GIS Intern at the City of Edina collecting new GPS data could have been more efficient and less time consuming if we would have automated the process of processing trimble data after the data had be collected.

The project was a cure for mundane tasks I performed while working for the city. Now if I'm ever an intern again I can quickly slide past the task of processing data manually. :)

File Structure Python Code is Based Off

New trimble data gets dump to this file
Base File is where active files are used
Backup fold is to add a copy of data collected

Python Code to Automate Workflow for Newly Imported Trimble Data

Variables used: 

in_data = "base shapefile located in the Base File folder"

temp = "this is a temporary shapefile created in order for the merge to run"

in_new = "newly imported GPS data from trimble"

output_copy = "this becomes an the output path/name to back up the trimble data to a backup folder" 

out_data = "this is the merged shapefile of the trimble data with the base shapefile"

The rename management is necessary because a merge can't have the same input and output. The rename of the basefile becomes a work abound that the user will never see. 

The merge tool merges the imported GPS data file (chosen by user) and the temporary shapefile (actually basefile) together outputing an updated Basefile.shp

The copy management tool moves the imported GPS shapefile to a backup folder for safe keeping.

The delete management tool deletes the imported GPS shapefile once it has been merged and copied to backup folder and it also deletes the temp.shp that was created for the purpose of running the merge tool. 

City of Edina Internship

My first internship with the City of Edina I worked on a variety of projects including collecting GPS data points for Edina's city infrastructure, hyperlinking deeds and easements for public record, georeferenced historical aerial photos, map creation and MS4 inspections. Check out a few of my maps and projects!

The map shows the market value for each parcel in the city normalized per acre.

This project I brought Deeds and Easements from Autotcad to ArcMap for the purpose of hyperlinking each archived document to the appropriate location on the map for the purpose of sharing the information with the public.

View Complete Project bit.ly/2Pq2F7Z

For this project I collected GPS information and photos for new/updated signs. After I collected the trimbe data I then processed the data from the trimble through  updating sign data in ArcSDE.

This map is a visual of phone calls received from residence during the flooding that happened in 2014. The dots correlate to the calls from residence broken down into three categories, if they need sandbags, if there is sanitary sewer backup, or storm water backup at their location. From these maps Public Works could then respond efficiently to the flooding.