Executable SQL, spatial functions, and automated data pipelines — no manual coding
Over 25k locations analysed
Extract data from PostgreSQL, open sources or files (shp, json and csv)
"Extract the entire street network of Bilbao from OSM."
"Categorize all elements in my SHP by main categories."
Run catchment area analysis by radius or by travel time (walking, biking, or driving)
"Find all private schools within a 15-minute walking distance from metro stations"
"Build 500 m, 1,000 m, and 2,000 m buffers around my restaurants and map all competitors"
Run PostGIS functions for layer transformation
"Clip the streets layer using the city administrative boundary polygon."
"Merge my commercial and residential area layers into a single dataset, preserving all attributes"
Execute statistical & urban analysis
"Calculate the median income for all census blocks in the Bronx, NYC"
"Compute the Floor Area Ratio (FAR) for a given site area, assuming an average building height of 3 meters"