Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ( SELECT way,boundary,name,admin_level
- FROM planet_osm_polygon
- WHERE way && !bbox! and boundary IN ('administrative','national_park') AND osm_id NOT IN (-60189,-60199)
- UNION
- SELECT ST_Union(way) AS way,'administrative' AS boundary,MIN(name),'2' AS admin_level
- FROM planet_osm_polygon
- WHERE way && !bbox! AND osm_id IN (-60189,-72639)
- UNION
- SELECT ST_Difference(a.way,b.way) AS way,'administrative' AS boundary,a.name,'2' AS admin_level
- FROM planet_osm_polygon a,planet_osm_polygon b
- WHERE a.way && !bbox! AND b.way && !bbox! AND a.osm_id=-60199 AND b.osm_id=-72639) AS adm_f
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement