Skip to content

Instantly share code, notes, and snippets.

@hampelm
Created May 15, 2015 02:55
Show Gist options
  • Save hampelm/ddd3fb6871546abfe398 to your computer and use it in GitHub Desktop.
Save hampelm/ddd3fb6871546abfe398 to your computer and use it in GitHub Desktop.
pluto.setSQL("SELECT pluto.the_geom_webmercator,pluto.cartodb_id,pluto.sbs_s,sum(schools.grade_code) * " + indicator1 + " as score FROM pluto as pluto JOIN schools ON ST_INTERSECTS(pluto.the_geom_webmercator,schools.the_geom_webmercator) GROUP BY pluto.cartodb_id")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment