Skip to content

Instantly share code, notes, and snippets.

@knutole
Created January 30, 2015 13:46
Show Gist options
  • Save knutole/472da807de087eeca047 to your computer and use it in GitHub Desktop.
Save knutole/472da807de087eeca047 to your computer and use it in GitHub Desktop.
SELECT row_to_json(fc) FROM (
SELECT ST_AsGeoJSON(ST_Transform(ST_Intersection(lg.geometry, bbox.geom), 4326))::json As geometry, (
SELECT row_to_json(t) FROM (
SELECT "name","type","area","z_order") t ) As properties FROM osm_landusages As lg, (
SELECT ST_Transform(ST_MakeEnvelope(-2.8125,38.82259097617711,25.312499999999986,57.326521225217064, 4326),3857) as geom) as bbox
WHERE ST_Intersects(lg.geometry, bbox.geom)
AND (area > 200000000) ) fc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment