GIS Analyst / Developer / Founder

June 19, 2022 – Present (32 hours/week)
Spatial Markets NC
Mocksville, North Carolina 27028


DUTIES

  • Design, develop and deploy ESRI based GIS solutions to support SpatialMarketsNC and SurfaceGIS programs.

  • Administer ESRI ArcGIS Online account to develop and host apps, dashboards, feature layers and manage user base.

  • Database administration, file management, metadata and documentation for all aspects of projects and deliverables.

  • Develop python scripts and ESRI model builder strategies to automate analysis workflows and ETL routines.

  • Attend training and professional development related to lidar analysis, ESRI Business Analyst, geoprocessing automation and AGOL administration.

PROJECTS

www.SpatialMarketsNC.com

  • Residential Action Database / Dashboard – A custom built GIS platform I developedto facilitate strategic and operational outreach for business, environmental campaigns and electoral politics.  The geodatabase behind this system contains analysis ready, operational feature classes and tables that represent statewide geocoded voter registration, parcel ownership fabric, 12 years of voter history for general and primary elections and more.  The python scripts I developed for the ETL portion of the program brings the voter registration data (9 million records) and voter history data (17 million records) from a public server in chunks of 1 million records and prepares tables for geocoding in a comprehensive ESRI model builder.  Analysis, weekly updates and publishing key results to hosted feature layers for use in associated ESRI AGOL web applications all takes place within the model builder project.  Deliverables include strategic phone lists, mail lists, door to door routing and shapefile exports for google ads campaigns.  This product builds heavily from my expertise as lead GIS on numerous federal emergency GIS responses and utilizes my skills in ESRI Business Analyst, Network Analyst, geocoding, AGOL web applications, field maps, and more.

www.SurfaceGIS.com

  • Erosion Potential Model – The hydrologic and landscape analysis captured within this ESRI ArcPro model resolves the intersection angle between a lidar derived watershed and the linear feature it intersects, this is a key metric for erosion planning, management and control along a linear asset.  This angle and more are delivered to clients via an ESRI Operations Dashboard toprovide strategic and actionable intelligence to land managers.  This tool facilitates the assessment of any length of linear asset for water pooling, water flow along, or over a linear asset network, such as road, trail, or infrastructure.  My advanced ESRI Model Builder skills, an extensive background in Spatial Analyst, 3D Analyst and Hydrologic Analyst tools within ESRI ArcPro were essential to develop this program. 

  • Rooftop Lidar 3D – This tool provides high-precision, 3D metrics for infrastructure, biomass, land surface expressions, stream order, and other facets of the built and natural landscape.  This ESRI ArcPro Model Builder based tool excels where tree cover, or shadow renders imagery-based infrastructure assessments invalid.  My comprehensive background in lidar point analysis, 3D visualization, feature extraction, and point cloud to raster conversion were required to make this semi automated tool a success.  Deliverables range from CAD files and PDFs to ArcGIS Online Web Applications.  Several examples can be viewed in the YouTube playlist HERE

  • Global Slope Hazard Map– This interactive ESRI web application provides users with a strategic slope classification scheme rendered as a scalable mesh of pixels from 1 sq meter to 100+ sq meters throughout the globe.  The custom slope ranges have been thoroughly field tested and define risk and opportunity of human movement, not geologic hazards.  The slope classes were prepared as a hosted map layer for use in the ESRI AGOL web application.  A key feature of the application is the lens widget offering a seamless interface between imagery and slope data.  The slope classification scheme I developed constrains the highest hazard pixels (red/purple) to only the steep, cliff, rocky terrain where the risk is physical present to human travel.  For offline, phone-based use I offer an ESRI AGOL field map where users can be a GPS location as they move about remote terrain.  Additionally, once the web map is opened within desktop ArcPro I simply export a geoTIFF for use in Avenza PDF maps application.