comparison: project.mml
project.mml
- changeset 2
- 8d4148a8ded4
- parent 0
- b0eb3af2f9ee
- child 3
- 89b6a7562889
equal
deleted
inserted
replaced
| 1:959dc869b765 | 2:8d4148a8ded4 |
|---|---|
| 61 THEN 'water' | 61 THEN 'water' |
| 62 ELSE CASE WHEN ("landuse" IN ('religious', 'cemetery') OR "amenity" = 'grave_yard') | 62 ELSE CASE WHEN ("landuse" IN ('religious', 'cemetery') OR "amenity" = 'grave_yard') |
| 63 THEN 'religious' | 63 THEN 'religious' |
| 64 ELSE CASE WHEN ("landuse" = 'railway') | 64 ELSE CASE WHEN ("landuse" = 'railway') |
| 65 THEN 'industrial' | 65 THEN 'industrial' |
| 66 ELSE "landuse" | 66 ELSE CASE WHEN ("natural" = 'wetland') |
| 67 THEN 'wetland' | |
| 68 ELSE "landuse" | |
| 69 END | |
| 67 END | 70 END |
| 68 END | 71 END |
| 69 END | 72 END |
| 70 END | 73 END |
| 71 END | 74 END |
| 212 <<: *osm2pgsql | 215 <<: *osm2pgsql |
| 213 table: *road_low_zoom_sql | 216 table: *road_low_zoom_sql |
| 214 properties: | 217 properties: |
| 215 minzoom: 4 | 218 minzoom: 4 |
| 216 maxzoom: 9 | 219 maxzoom: 9 |
| 220 - id: foot-routes-layer-n1 | |
| 221 geometry: linestring | |
| 222 <<: *extents | |
| 223 Datasource: | |
| 224 <<: *osm2pgsql | |
| 225 table: &foot_routes_sql |- | |
| 226 (SELECT | |
| 227 way, | |
| 228 osm_way_id, | |
| 229 route, | |
| 230 COALESCE(layer::integer, 0) AS layer | |
| 231 FROM planet_osm_routes | |
| 232 WHERE "route" IN ('hiking', 'foot', 'bicycle_lcn', 'bicycle_rcn', 'bicycle_ncn', 'bicycle_icn') | |
| 233 ORDER BY | |
| 234 CASE | |
| 235 WHEN route = 'bicycle_icn' THEN 30 | |
| 236 WHEN route = 'bicycle_ncn' THEN 31 | |
| 237 WHEN route = 'bicycle_rcn' THEN 32 | |
| 238 WHEN route = 'bicycle_lcn' THEN 33 | |
| 239 WHEN route = 'foot' THEN 34 | |
| 240 WHEN route = 'hiking' THEN 35 | |
| 241 END DESC NULLS LAST | |
| 242 ) AS foot_routes | |
| 243 properties: | |
| 244 minzoom: 14 | |
| 217 - id: road-casing-layer-n1 | 245 - id: road-casing-layer-n1 |
| 218 geometry: line | 246 geometry: line |
| 219 Datasource: | 247 Datasource: |
| 220 <<: *osm2pgsql | 248 <<: *osm2pgsql |
| 221 table: &road_sql |- | 249 table: &road_sql |- |
| 298 Datasource: | 326 Datasource: |
| 299 <<: *osm2pgsql | 327 <<: *osm2pgsql |
| 300 table: *road_sql | 328 table: *road_sql |
| 301 properties: | 329 properties: |
| 302 minzoom: 12 | 330 minzoom: 12 |
| 331 - id: foot-routes | |
| 332 geometry: linestring | |
| 333 <<: *extents | |
| 334 Datasource: | |
| 335 <<: *osm2pgsql | |
| 336 table: *foot_routes_sql | |
| 337 properties: | |
| 338 minzoom: 14 | |
| 303 - id: road | 339 - id: road |
| 304 geometry: line | 340 geometry: line |
| 305 Datasource: | 341 Datasource: |
| 306 <<: *osm2pgsql | 342 <<: *osm2pgsql |
| 307 table: *road_sql | 343 table: *road_sql |
| 325 FROM planet_osm_polygon | 361 FROM planet_osm_polygon |
| 326 WHERE "man_made" = 'bridge' | 362 WHERE "man_made" = 'bridge' |
| 327 ) AS bridge_area | 363 ) AS bridge_area |
| 328 properties: | 364 properties: |
| 329 minzoom: 12 | 365 minzoom: 12 |
| 366 - id: foot-routes-layer-1 | |
| 367 geometry: linestring | |
| 368 <<: *extents | |
| 369 Datasource: | |
| 370 <<: *osm2pgsql | |
| 371 table: *foot_routes_sql | |
| 372 properties: | |
| 373 minzoom: 14 | |
| 330 - id: road-casing-layer-1 | 374 - id: road-casing-layer-1 |
| 331 geometry: line | 375 geometry: line |
| 332 Datasource: | 376 Datasource: |
| 333 <<: *osm2pgsql | 377 <<: *osm2pgsql |
| 334 table: *road_sql | 378 table: *road_sql |
| 667 Datasource: | 711 Datasource: |
| 668 <<: *osm2pgsql | 712 <<: *osm2pgsql |
| 669 table: *road_sql | 713 table: *road_sql |
| 670 properties: | 714 properties: |
| 671 minzoom: 14 | 715 minzoom: 14 |
| 716 - id: foot-routes-text | |
| 717 geometry: linestring | |
| 718 <<: *extents | |
| 719 Datasource: | |
| 720 <<: *osm2pgsql | |
| 721 table: |- | |
| 722 (SELECT | |
| 723 way, | |
| 724 name, | |
| 725 ref, | |
| 726 route | |
| 727 FROM planet_osm_routes | |
| 728 WHERE "route" IN ('hiking', 'foot', 'bicycle_lcn', 'bicycle_rcn', 'bicycle_ncn', 'bicycle_icn') | |
| 729 ORDER BY | |
| 730 CASE | |
| 731 WHEN route = 'bicycle_icn' THEN 30 | |
| 732 WHEN route = 'bicycle_ncn' THEN 31 | |
| 733 WHEN route = 'bicycle_rcn' THEN 32 | |
| 734 WHEN route = 'bicycle_lcn' THEN 33 | |
| 735 WHEN route = 'foot' THEN 34 | |
| 736 WHEN route = 'hiking' THEN 35 | |
| 737 END DESC NULLS LAST | |
| 738 ) AS foot_routes | |
| 739 properties: | |
| 740 minzoom: 15 | |
| 672 - id: roads-text-ref | 741 - id: roads-text-ref |
| 673 geometry: linestring | 742 geometry: linestring |
| 674 <<: *extents | 743 <<: *extents |
| 675 Datasource: | 744 Datasource: |
| 676 <<: *osm2pgsql | 745 <<: *osm2pgsql |
