mmbmf1
@mmbmf1
Public Skills
postgis-distance
by mmbmf1
Compute numeric distances safely with ST_Distance (geometry vs geography units) and pair with ST_DWithin for performance.
postgis-nearest
by mmbmf1
Find nearest features efficiently using PostGIS KNN (<->) and distance ordering (with SRID/unit guidance).
postgis-extract-xy
by mmbmf1
Extract longitude and latitude from PostGIS geometries using ST_X and ST_Y safely.
postgis-dwithin
by mmbmf1
Distance-based spatial filtering with ST_DWithin, using index-friendly and unit-safe patterns.
postgis-buffer
by mmbmf1
Create buffer geometries with ST_Buffer, with correct units and safe patterns for geometry vs geography.
postgis-transform
by mmbmf1
Reproject PostGIS geometry using ST_Transform with correct SRID handling and safe usage patterns.
geojson-postgis
by mmbmf1
Serialize PostGIS geometry rows into a GeoJSON FeatureCollection for map display (4326, Feature + properties).
geojson-wkt
by mmbmf1
Convert JSON rows with WKT geometry strings into a GeoJSON FeatureCollection using raw PostGIS SQL.
geojson-points
by mmbmf1
Convert JSON rows with latitude/longitude fields into a GeoJSON FeatureCollection using raw PostGIS SQL.