Skip to content

Instantly share code, notes, and snippets.

@wboykinm

wboykinm/spatialjoin.sql

Created April 17, 2013 02:36
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 wboykinm/5401371 to your computer and use it in GitHub Desktop.
Save wboykinm/5401371 to your computer and use it in GitHub Desktop.
Download ZIP
PostGIS FTW, spatial join edition
Raw
spatialjoin.sql
UPDATE btv_prints_041513f SET height = btv_prints_011813.height_real FROM btv_prints_011813 WHERE ST_Intersects(btv_prints_041513f.the_geom, btv_prints_011813.the_geom) AND btv_prints_041513f.height=0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment