Advertisement
Guest User

Untitled

a guest
Mar 25th, 2014
217
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ( SELECT way,boundary,name,admin_level
  2.   FROM planet_osm_polygon
  3.   WHERE way && !bbox! and boundary IN ('administrative','national_park') AND osm_id NOT IN (-60189,-60199)
  4.   UNION
  5.   SELECT ST_Union(way) AS way,'administrative' AS boundary,MIN(name),'2' AS admin_level
  6.   FROM planet_osm_polygon
  7.   WHERE way && !bbox! AND osm_id IN (-60189,-72639)
  8.   UNION
  9.   SELECT ST_Difference(a.way,b.way) AS way,'administrative' AS boundary,a.name,'2' AS admin_level
  10.   FROM planet_osm_polygon a,planet_osm_polygon b
  11.   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