Stephen C. Sanders

A systematic review of the city's centerline (road) GIS layer in relation to other datasets (e.g., Right of Way, parcels, County road data, aerial imagery) to flag issues or areas that need additional clarification. The main issues that needed to be marked are those concerning spatial accuracy, topology, dangles/gaps, missing data, and attribution. Any issue or anomaly was marked up using the provided mark-up layers with an issue type and comment, or they are identified in other output layers that would necessitate looking at certain attribution values to determine which features have certain issues (e.g., dangles/gaps, address continuity issues, railroad intersection points). The final deliverables will help the city assess the QA/QC after it has been delivered and make appropriate data changes to the Centerline layer.

Included is a Python script called Intersect_By_Attribute_Merge.py. The script allows the user to intersect an input layer based on a specified field and field values with a polygon layer. An example usage is to figure out which City Local or Private roads intersect with the parcel data as a means of pinpointing issues pertaining to "Maintained By" attribution issues in the Centerline master layer. This is a fairly limited script that requires specifying the field (e.g., MAINTAS) and target values of the field (e.g., City Local, Private) from the input layer (e.g., the Centerline layer) that are to be intersected in relation to a polygon layer (e.g., Parcels). If more than 1 field value is targeted, then the script will merge the resulting intersect layers into a single merge layer. You can then change the symbology of the merge layer to a graduated color scheme to visualize the feature based on the targeted field values. This script may be converted into an ArcGIS Pro toolbox at some point in the future.

This was my capstone experience/internship through Monroe Community College in collaboration with the City of Traverse City, Michigan.

Search Twitter for Tweets containing a particular keyword from the command line, then write results to a csv file and/or map the results using ArcGIS Pro or GeoPandas. It allows for counting the number of Tweets in each state using data from a csv file without having to map the results. You can append your count results to shapefiles (ArcGIS Pro & GeoPandas) and feature classes within geodatabases (ArcGIS Pro). Written entirely in Python (ArcPy, Pandas/GeoPandas, Matplotlib).

Explores food insecurity in the City of Buffalo based on each census tract's poverty level and walking distance proximity to a grocery or corner store. Includes a chloropleth map that showcases the relationship between the above variables. Used a color scheme generated by Paletton.com. Data obtained, analyzed, and displayed using QGIS, Google Sheets, Google Earth Pro, and Google Maps.

Investigates any vegetation changes between 1989 and 2019 around the Western Aral Sea that have occurred due to the shrinkage of the Aral Sea, and how past and present restoration projects may have influenced these changes since they began. Also displays the extent of the shrinkage that the Aral Sea has undergone. Uses Landsat data from GLOVIS. Data analyzed in ArcGIS Pro.

Determines potential sites for new public WiFi locations in the City of Rochester based on which census tracts are most in need. Considers percentage of households without internet access, proximity to a preexisting free WiFi location, and population density of school-aged people. Data analyzed in ArcGIS Pro.

Investigates if there is a correlation between homicide rate, median household income level, and the number of parks, playgrounds, and other publicly accessible areas within census tracts of the City of Rochester. Data analyzed using ArcGIS Pro and Google Sheets.

Command line program written in Python that collects precipitation data from user, then graphs the data using the Plotly library. More features are in the works.

Pig command line game written in Python. User plays against the computer in a game to 100. Keeps track of the number of turns.

Simple command line number guessing game written in Python. Keeps track of and calculates a few statistics relevant to each session.

The Baesick WordPress theme is a responsive, customizable starter theme that is forked from wycks' WP Skeleton Theme. Originally only developed with support for the Skeleton CSS framework, I added support Bootstrap and completely overhauled the design to make it look more modern and stylish.

The website for the Buffalo Firefighters (Local 282) was developed by me in mid-to-late-2017 in collaboration with e3communications, and is still used by them as their main source of communication with matters that concern the general public. The website was built using WordPress and is hosted by GoDaddy.