Skip to content

Instantly share code, notes, and snippets.

@jqtrde

jqtrde/select-points-in-polygon.sql

Created February 28, 2015 20:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jqtrde/20e0d1b59be9fc222ba8 to your computer and use it in GitHub Desktop.
Save jqtrde/20e0d1b59be9fc222ba8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select-points-in-polygon.sql
```
SELECT *
FROM (SELECT the_geom FROM incidents WHERE incidents.major_category = 'Fire') as f, (SELECT geom FROM neighborhoods_wa WHERE neighborhoods_wa.name = 'Broadmoor') as n
WHERE ST_Within(f.the_geom, n.geom);
```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment