postgis

Naming

• Spell PostGIS functions as they appear in the manual (st_segmentize -> ST_Segmentize).
• Call geometry columns geom; call geography columns geog.

Checks

• Check select postgis_full_version(); to confirm the installed PostGIS, GEOS, PROJ, GDAL, and SFCGAL versions when debugging extension behavior.

Raster

• Do not work with GDAL on the filesystem. Import things into database and deal with data there.

Gotchas