Skip to content

Instantly share code, notes, and snippets.

@knutole

knutole/gist:e3bb5b4ffdbcb54bee70

Created January 30, 2015 12:39
Show Gist options
  • Save knutole/e3bb5b4ffdbcb54bee70 to your computer and use it in GitHub Desktop.
Save knutole/e3bb5b4ffdbcb54bee70 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
EXPLAIN ANALYZE VERBOSE SELECT ST_AsGeoJSON(ST_Intersection(lg.geometry, bbox.geom)) As geometry, ( SELECT rowea","z_order") t ) As properties FROM osm_landusages As lg, (SELECT ST_Transform(ST_MakeEnvelope(-2.8125,38.822590974, 4326),3857) as geom) as bbox WHERE ST_Intersects(lg.geometry, bbox.geom) AND (area > 200000000) ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment