SHOW:
|
|
- or go back to the newest paste.
| 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)
|
| 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 |
