Skip to content

Instantly share code, notes, and snippets.

@knutole
Created January 13, 2015 14:25
Show Gist options
  • Save knutole/1384583fc3f30290d710 to your computer and use it in GitHub Desktop.
Save knutole/1384583fc3f30290d710 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, admin_level
) t
)
As properties
FROM
osm_admin As lg,
(SELECT ST_Transform(ST_MakeEnvelope(10.735445022583008, 59.913428634991995,
10.776472091674805, 59.933989460416115, 4326),3857) as geom) as bbox
WHERE ST_Intersects(lg.geometry, bbox.geom)
) fc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment