Skip to content

Instantly share code, notes, and snippets.

@pnorman

pnorman/gist:6983476

Created October 14, 2013 22:40
Show Gist options
  • Save pnorman/6983476 to your computer and use it in GitHub Desktop.
Save pnorman/6983476 to your computer and use it in GitHub Desktop.
Download ZIP
query for node in building analysis
Raw
gistfile1.sql
SELECT COUNT(*)
FROM planet_osm_point AS pt
JOIN planet_osm_polygon AS pl ON ST_Intersects(pt.way, pl.way)
WHERE pt.amenity='fast_food'
AND pl.building IS NOT NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment