project.mml

changeset 5
63cfc4b10f9c
parent 4
34a84c0a427c
child 6
0575190fa5fc
equal deleted inserted replaced
4:34a84c0a427c 5:63cfc4b10f9c
298 Datasource: 298 Datasource:
299 <<: *osm2pgsql 299 <<: *osm2pgsql
300 table: *road_sql 300 table: *road_sql
301 properties: 301 properties:
302 minzoom: 10 302 minzoom: 10
303 - id: bus-route-layer-n1
304 geometry: linestring
305 <<: *extents
306 Datasource:
307 <<: *osm2pgsql
308 table: &bus_routes_sql |-
309 (SELECT DISTINCT
310 way,
311 COALESCE(layer::integer, 0) AS layer
312 FROM planet_osm_routes
313 WHERE "route" = 'bus'
314 ) AS bus_routes
315 properties:
316 minzoom: 15
303 - id: rail-layer-n1 317 - id: rail-layer-n1
304 geometry: linestring 318 geometry: linestring
305 Datasource: 319 Datasource:
306 <<: *osm2pgsql 320 <<: *osm2pgsql
307 table: &rail_sql |- 321 table: &rail_sql |-
341 Datasource: 355 Datasource:
342 <<: *osm2pgsql 356 <<: *osm2pgsql
343 table: *road_sql 357 table: *road_sql
344 properties: 358 properties:
345 minzoom: 12 359 minzoom: 12
360 - id: bus-route
361 geometry: linestring
362 <<: *extents
363 Datasource:
364 <<: *osm2pgsql
365 table: *bus_routes_sql
366 properties:
367 minzoom: 15
346 - id: rail 368 - id: rail
347 geometry: linestring 369 geometry: linestring
348 Datasource: 370 Datasource:
349 <<: *osm2pgsql 371 <<: *osm2pgsql
350 table: *rail_sql 372 table: *rail_sql
383 Datasource: 405 Datasource:
384 <<: *osm2pgsql 406 <<: *osm2pgsql
385 table: *road_sql 407 table: *road_sql
386 properties: 408 properties:
387 minzoom: 12 409 minzoom: 12
410 - id: bus-route-layer-1
411 geometry: linestring
412 <<: *extents
413 Datasource:
414 <<: *osm2pgsql
415 table: *bus_routes_sql
416 properties:
417 minzoom: 15
388 - id: rail-layer-1 418 - id: rail-layer-1
389 geometry: linestring 419 geometry: linestring
390 Datasource: 420 Datasource:
391 <<: *osm2pgsql 421 <<: *osm2pgsql
392 table: *rail_sql 422 table: *rail_sql
886 WHERE "route" = 'train' AND length(ref) = 1 AND network = 'HSL' 916 WHERE "route" = 'train' AND length(ref) = 1 AND network = 'HSL'
887 ORDER BY ref 917 ORDER BY ref
888 ) AS commuter_trains 918 ) AS commuter_trains
889 properties: 919 properties:
890 minzoom: 15 920 minzoom: 15
921 - id: bus-ref
922 geometry: linestring
923 <<: *extents
924 Datasource:
925 <<: *osm2pgsql
926 table: |-
927 (SELECT
928 way,
929 ref
930 FROM planet_osm_routes
931 WHERE "route" = 'bus' AND ref IS NOT NULL
932 ORDER BY ref
933 ) AS commuter_trains
934 properties:
935 minzoom: 17

mercurial