Example Spatial SQL Post

spatial_sql.sql

-- written for PostGIS
-- table states is US State Polygons
-- table capitals are US State Capital points

select
a.name,
a.id,

-- create a centroid of the state polygon

st_centroid(a.geom) as centroid,

-- measure the distance from the state centroid to the capital

st_distance(st_centroid(a.geom), b.geom)
from states a
join capitals b using (abbreviation)