Loading...
Loading...
Found 6 Skills
Convert JSON rows with latitude/longitude fields into a GeoJSON FeatureCollection using raw PostGIS SQL.
Use when asked to convert between KML and GeoJSON formats, or convert geo data for mapping applications.
Index points into a hexagonal grid
Find nearest features efficiently using PostGIS KNN (<->) and distance ordering (with SRID/unit guidance).
MANDATORY when working with geographic data, spatial queries, geometry operations, or location-based features - enforces PostGIS 3.6.1 best practices including ST_CoverageClean, SFCGAL 3D functions, and bigint topology
Use when "GeoPandas", "geospatial", "GIS", "shapefile", "GeoJSON", or asking about "spatial analysis", "coordinate transformation", "spatial join", "choropleth map", "buffer analysis", "geographic data", "map visualization"