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

Andy Cagle (Owner)
303.994.7327
spatialmarketsnc@gmail.com


DUTIES

  • Design, Develop and deploy ESRI based GIS solutions across multiple disciplines.

  • Utilize expertise in ESRI AGOL platforms, desktop ArcPro and Python scripting to design, develop and maintain a suite of geospatial solutions.

  • Consistent use of the following ESRI extensions: Business Analyst, Network Analyst, 3D Analyst, Model Builder.

  • Prepare data visualizations and presentation quality digital media to promote the geospatial solutions I develop.

PROJECTS

  • Spatial Markets NC – A GIS platform I developed to identify high impact geographies and the precise individuals within them to support strategic outreach for, Nonprofits, Business growth, and Election campaigns.  The core of this GIS solution relies on a python script I wrote to acquire a 9 million record .csv file from a state server on a weekly basis, and an ArcPro Model Builder project that geocodes 7.8 million rooftop address points using a local locator tool.  High impact geographies are defined through strategic use of ESRI Business Analyst and Network Analyst service area mapping.

  • Erosion Potential Model – This ArcPro model builder based project resolves the intersection angle between a lidar derived watershed and the linear feature it connects with, a key metric for erosion planning.  Model results are delivered via ESRI Operations Dashboard. and for erosion control along a linear asset, such as road, trail or cutline.  This product provides actionable intelligence for land managers to assess any length of linear asset for water pooling, water flow along, or over a linear asset network, such as road, trail, or infrastructure.  Advanced 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 – Using ESRI ArcPro model builder I developed a rooftop calculator tool that provides high precision 3D measurements in areas where tree cover, or shadow renders optical roof scans obsolete.  This tool is used beyond its original purpose for landscape wide analysis of biomass, land surface, and other facets of the built and natural landscape.

  • Global Slope Hazard Map - A simple and robust ESRI web mapping application where users can interact with our strategically defined slope classification color ramp, multiple basemaps, add data, measure, and use of the lense tool for ultimate landscape assessment. Rapid detection of slope hazards, or opportunities across the landscape is the key question answered by this application. I developed the slope classification scheme over years of field trials and decades of complex digital slope analysis.