Skip to content

Instantly share code, notes, and snippets.

@sfkeller

sfkeller/Building within Mellingen (AG)

Created December 10, 2017 14:14
Show Gist options
  • Save sfkeller/14db2b1595b28b3aa5f2b89ee080f088 to your computer and use it in GitHub Desktop.
Save sfkeller/14db2b1595b28b3aa5f2b89ee080f088 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Building within Mellingen (AG)
SELECT ST_AsText(way) geom,
COALESCE(name, '')||' '||osm_id AS label
FROM osm_polygon
WHERE tags->'building' > ''
AND ST_Intersects(way,
(SELECT way
FROM osm_polygon
WHERE osm_id=-1684362))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment