PostGIS Geometry Rows → GeoJSON FeatureCollection

Use this skill when your data already has a PostGIS geometry column (typically geom) and you need to serve it to a web map as GeoJSON.

This is the canonical pattern:

• output WGS84 (EPSG:4326) for clients
• return a FeatureCollection
• keep properties as “all columns minus geom” (or explicitly selected fields)

When to use

• You have a table with geom (geometry) and other columns
• You are building or updating an API endpoint that returns map layers
• You want consistent GeoJSON structure and coordinate system

Core rules