Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT name, ST_Intersection(table_name.geom, bbox.geom) as dest_geom
- FROM table_name
- JOIN (select ST_MakeEnvelope(?, ?, ?, ?, 4326) as geom) bbox
- ON st_intersects(table_name.geom, bbox.geom)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement