Nathan Sturgill

Department of Public Utilities Internship (GIS)

October 8th, 2021

Week 5

To start out week 5 I was instructed to continue my ongoing work from last week, which included making a base map of my own through ArcGIS that I can work out of to help Janelle and the Public Utilities Department mitigate ongoing problems. In the ArcGIS base map, I have been using I have now learned how to properly create a definition query that can be used to find missing data in the City of Delaware GIS data sets. I was guided through this process by Janelle and have begun to create my own definition queries to find missing data and solve these problems with new values. The definition queries I have created and use are to find the missing data such as missing information about water valves, meters, and pipes located across the city of Delaware. This data is vital to maintaining the quality of water and drainage systems in the city of Delaware. I have also used definition queries to identify which record drawings created by engineers have missing values when placed into Delaware’s ArcGIS maps and also which record drawings contain a broken link that can help GIS technicians such as Janelle when identifying the problems associated with missing data in the record drawings.

I have begun working on an attribute audit for the different record drawings representing the different sections making up the city of Delaware. As of now the attribute audit only concerns the water and storm systems located throughout the city of Delaware and this missing data is the primary goal of the attribute audit. While creating the attribute audit I use a definition query to see what missing data lies in the attribute table for each water system and storm system. Creating this attribute audit has been a difficult task because all of the variables involved along with creating a definition query that is specific to finding a certain type of missing data and this can be very time-consuming. For the coming week, I will continue to work on this attribute audit that will help Janelle and others work within the department. I will also soon be instructed how the City Works GIS system is used by the city of Delaware by Janelle.