Skip to content

Instantly share code, notes, and snippets.

@caged
Created September 14, 2013 00:43
Show Gist options
  • Save caged/6557769 to your computer and use it in GitHub Desktop.
Save caged/6557769 to your computer and use it in GitHub Desktop.
Tilemill PostGIS layer subquery showing layer clipping via polygon intersection.
(select buildings.*, neighborhoods.wkb_geometry as bounding_area from buildings INNER JOIN neighborhoods ON ST_Intersects(neighborhoods.wkb_geometry, buildings.wkb_geometry) WHERE neighborhoods.name IN('LAURELHURST')) as buildings
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment