Skip to content

Instantly share code, notes, and snippets.

@ashaw

ashaw/greenpoint.sql

Created April 13, 2011 02:39
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ashaw/916865 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ashaw/916865 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
greenpoint.sql
select z.zonedist,st_asgeojson(z.the_geom) from zones as z join districts as d on st_contains(d.the_geom, z.the_geom) or st_overlaps(d.the_geom,z.the_geom) where d.cd = 301;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment