postgis-transform

Installation
SKILL.md

Reproject Geometry with ST_Transform

Use this skill when you need to reproject geometry between coordinate systems (SRIDs) in PostGIS.

This documents the canonical, safe patterns for using ST_Transform.

When to use

  • You need planar distance, buffering, or area calculations
  • You are comparing geometries from different SRIDs
  • You are preparing geometry for web maps (EPSG:4326)

Core rules

  • Geometry must have a valid SRID before transforming
  • Use projected SRIDs for distance/buffer math
  • Serve web maps in EPSG:4326
  • Avoid transforming large tables inside WHERE clauses
Installs
7
First Seen
Feb 9, 2026
postgis-transform — mmbmf1/geospatial-skills