Points → GeoJSON (PostGIS)

Use this skill when you have tabular data (rows or JSON) that include latitude/longitude fields and you need a GeoJSON FeatureCollection for map display.

This skill documents the canonical raw SQL pattern for building GeoJSON from point data in PostGIS.

When to use

• You have rows like { id, lat, lng, ... }
• You want GeoJSON directly from Postgres
• You want predictable geometry and property handling

Input assumptions

• Latitude and longitude are stored as numeric or castable to numeric
• Longitude comes first in point construction
• Geometry is output in WGS84 (EPSG:4326)

Canonical SQL pattern