Skip to content

Instantly share code, notes, and snippets.

@knutole

knutole/gist:f4c7ee406072af88f5e6

Created January 30, 2015 13:57
Show Gist options
  • Save knutole/f4c7ee406072af88f5e6 to your computer and use it in GitHub Desktop.
Save knutole/f4c7ee406072af88f5e6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT ST_Transform(ST_Intersection(lg.geometry, bbox.geom), 4326) As geometry,
SELECT "name","type","area","z_order" 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);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment