PostGIS Developer

PostGIS turns PostgreSQL into a powerful geo database. I use PostGIS for location search, routing computations, spatial aggregations, and processing of OpenStreetMap or Overture Maps data. Data modeling, spatial indexing, and query performance are among my core focus areas — from smaller applications to databases with millions of geo records.

PostGIS — the Standard for Spatial Data

PostGIS extends PostgreSQL with the ability to store, index, and query geo data directly in the database. Radius searches, routing computations, spatial aggregations, point-in-polygon checks, and buffer analyses become standard SQL queries.

For mobility and map applications, PostGIS is the central layer between data source (OSM, Overture, your own data) and frontend (MapLibre, your own APIs).

Performance With Large Datasets

With spatial data, the right indexing makes the difference between seconds and hours of response time. I take care of GIST indexes, partitioning, query optimization, and choosing the right data types — up to databases with millions of geometries.

PostGIS Services

Database design for geo applications, ETL pipelines for OpenStreetMap (osm2pgsql, Imposm) and Overture Maps, building spatial APIs, migration of existing geo databases, and performance audits. Including the switch from proprietary geo databases to PostGIS.