EFK Portfolio

Esad Kopru

Geospatial Data Engineering, GIS Software Development & Spatial Data Science

10+ years connecting spatial data, analytical methods, and GIS applications to support practical decisions.

  • Python
  • SQL
  • GIS applications
  • ETL pipelines
  • Spatial optimization
All projects

Highlighted work

Three projects across geospatial analysis, data delivery, and public-facing software.

Data engineering

Structure Inspection Data Pipeline

Flight tracks identify nearby structure candidatesIllustration with invented geometry. Ordered GPS points form a flight line with a shaded proximity band. Solid squares represent nearby structure candidates; hollow squares lie outside the band. Proximity does not confirm an inspection. No geographic distance is shown. Flight path Nearby structures
Illustration · Candidate coverage

Automating flight-track processing and structure inspection data updates in enterprise GIS.

80% less refresh processing time per run

  • Python
  • Selenium
  • ArcPy
Read case study: Structure Inspection Data Pipeline

Data science

Measuring Access to Community Amenities

Street connections shape access to an amenityIllustration with invented geometry. Highlighted routes and a shaded area show connected streets around an amenity. The separate street network on the right has no crossing over the barrier in this simplified example. This is illustrative topology, not measured accessibility, a travel time, or a score. Amenity Less connected Reachable streets
Illustration · Street-network reach

A study of which neighborhoods have limited access to community amenities.

$750K federal award supported by the analysis

  • Network analysis
  • Isochrones
  • Spatial aggregation
Read case study: Measuring Access to Community Amenities

All projects

Start with selected case studies in each area. Expand a collection to browse more projects and historical examples.

Spatial & Data Analysis

  1. Historical Property Value Analysis

    Compare nearby and surrounding home-value growth, with sensitivity checks for sample composition.

  2. Measuring Access to Community Amenities

    Use street-network access to identify neighborhoods underserved by community amenities.

  3. Crime Analysis

    Connect GIS dashboards to automated record updates and address enrichment.

More projects (5) in Spatial & Data Analysis
  1. Ground Patrol Analytics and Inspection Priorities

    Turn inspection records into consistent work priorities and reporting views.

  2. ArcGIS Enterprise and Online

    Migrate map services and modernize enterprise GIS delivery.

  3. Spatial Analysis

    Explore historical terrain, land-cover, parcel, and accessibility analyses.

  4. QGIS

    Retrieve OpenStreetMap data and compare shortest and fastest routes.

  5. Code Enforcement Violations

    Compare recorded code violations at rental and non-rental properties.

ML / Optimization

  1. Building Footprints Comparison: SAM 3 vs ESRI

    Compare two building-footprint models using shared cleanup and evaluation rules.

  2. Traveling Salesman

    Compare routing algorithms and the tradeoff between solution quality and runtime.

  3. Lead Pipe Prediction Prototype

    Test model evaluation and review queues using synthetic service-line records.

More projects (2) in ML / Optimization
  1. Water Conservation Routes

    Plan shorter inspection routes for commercial, industrial, and multifamily water meters.

  2. Income Level Prediction Using R

    Compare R classification models for predicting income categories.

Development & ETL

  1. Structure Inspection Data Pipeline

    Automate flight-track processing and structure inspection data updates in enterprise GIS.

  2. SQL Server to ArcGIS Online

    Prepare spatial data contracts and publish private ArcGIS Online snapshots.

  3. Work Order Mapping and GIS Integration

    Link maintenance work orders to GIS assets and shared reporting data.

More projects (5) in Development & ETL
  1. Python Scripts & Notebooks

    Browse historical automation examples and selected current application views.

  2. SQL Server and GIS Data Integration

    Prepare synthetic address, parcel, and reporting data through documented SQL workflows.

  3. Road Network Building with PostGIS and pgRouting

    Build synthetic directed road graphs for shortest paths and time-budget reachability.

  4. Automated Parcel Integration and Publishing

    Automate parcel updates with checks before publishing shared GIS data.

  5. Web AppBuilder Migration Assistant

    Inspect legacy web apps and prepare migration plans for human review.

Applications

  1. Public Web GIS and Application Modernization

    Build public mapping tools and modernize the browser interface.

  2. Coordinate Fetcher

    Reuse known address coordinates and identify unresolved CSV matches.

  3. Interactive Workforce Atlas

    Compare U.S. state labor-market patterns through linked maps and monthly trends.

More projects (4) in Applications
  1. Geospatial Web Applications

    Explore standalone JavaScript mapping applications using synthetic demonstration data.

  2. ArcGIS Pro Cartography Add-Ins

    Automate cartographic tasks with ArcGIS Pro add-ins.

  3. School-Zone Sign Evidence Explorer

    Organize candidate sign imagery and location evidence for field review.

  4. Worksite Coordinate Engine

    Convert geographic positions into local worksite coordinates and calibrate site grids.

Image viewer

100%