8 # let's factorize default values used by layers
12 srs: "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over"
19 srs: "+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs"
26 extent: -20037508,-20037508,20037508,20037508
36 srs: +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over
47 file: ./data/simplified-land-polygons-complete-3857/simplified_land_polygons.shp
56 file: ./data/land-polygons-split-3857/land_polygons.shp
68 way, way_area AS area, COALESCE(landuse, leisure, "natural", highway, amenity, tourism) AS type, tags->'landfill:type' as landfill_type
72 way_area > 100000 ORDER BY way_area DESC
75 extent_from_subquery: 'true'
82 ( SELECT way, way_area AS area, COALESCE(landuse, leisure, "natural",
83 highway, amenity, tourism) AS type, tags->'landfill:type' as
84 landfill_type FROM planet_osm_polygon WHERE way_area > 10000 AND
85 COALESCE(landuse, leisure, "natural", highway, amenity, tourism) IS NOT NULL
86 ORDER BY way_area DESC
89 extent_from_subquery: 'true'
96 ( SELECT way, way_area AS area, COALESCE(landuse, leisure, "natural", highway, amenity, tourism) AS type, tags->'landfill:type' as landfill_type
97 FROM planet_osm_polygon
98 WHERE COALESCE(landuse, leisure, "natural", highway, amenity, tourism) IS NOT NULL
99 ORDER BY way_area DESC) AS data
101 extent_from_subquery: 'true'
107 file: DEM/data/hillshade.vrt
110 srs: +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over
113 - geometry: linestring
117 file: DEM/data/contour-25m.shp
120 srs: +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over
128 ( SELECT way, waterway AS type,
130 CASE WHEN intermittent IN ('yes') OR tags@> hstore('seasonal','yes') THEN
133 ELSE 'no' END AS seasonal
137 WHERE waterway IN ('river', 'canal')) as h2olow
139 extent_from_subquery: 'true'
145 ( SELECT way, waterway AS type,
147 CASE WHEN intermittent IN ('yes') OR tags@> hstore('seasonal','yes') THEN
150 ELSE 'no' END AS seasonal
154 WHERE waterway IN ('river', 'canal', 'stream')) as h2o
161 ( SELECT way, waterway AS type,
163 CASE WHEN intermittent IN ('yes') OR tags@> hstore('seasonal','yes') THEN
166 ELSE 'no' END AS seasonal
170 WHERE waterway IN ('river', 'canal', 'stream', 'ditch', 'drain')) as h2o
172 extent_from_subquery: 'true'
179 ( SELECT way, "natural" AS type, way_area AS area
180 FROM planet_osm_polygon
181 WHERE ("natural" IN ('water', 'pond')
182 OR waterway IN ('basin', 'canal', 'mill_pond', 'pond', 'riverbank'))
186 extent_from_subquery: 'true'
193 ( SELECT way, "natural" AS type, way_area AS area
194 FROM planet_osm_polygon
195 WHERE ("natural" IN ('water', 'pond')
196 OR waterway IN ('basin', 'canal', 'mill_pond', 'pond', 'riverbank'))
200 extent_from_subquery: 'true'
207 ( SELECT way, way_area AS area
208 FROM planet_osm_polygon
209 WHERE "natural" IN ('water', 'pond')
210 OR waterway IN ('basin', 'canal', 'mill_pond', 'pond', 'riverbank', 'dock')
213 extent_from_subquery: 'true'
215 - id: landuse_overlays
220 ( SELECT way, way_area AS area, COALESCE(leisure) AS type
221 FROM planet_osm_polygon
222 WHERE leisure = 'nature_reserve'
223 ORDER BY way_area DESC
226 extent_from_subquery: 'true'
234 ST_Intersection(way, !bbox!) AS way, admin_level::integer,
235 CASE WHEN tags->'maritime'='yes' THEN 'yes' ELSE 'no' END AS maritime
239 "boundary" = 'administrative'
240 AND admin_level IN ('1','2','3','4', '5', '6', '7', '8', '9', '10')
241 AND "boundary" IS NOT NULL
247 extent_from_subquery: 'true'
255 ST_Intersection(way, !bbox!) AS way, admin_level::integer,
256 CASE WHEN tags->'maritime'='yes' THEN 'yes' ELSE 'no' END AS maritime
260 "boundary" = 'administrative'
261 AND admin_level IN ('1','2','3','4', '5', '6', '7', '8')
262 AND "boundary" IS NOT NULL
268 extent_from_subquery: 'true'
276 way, admin_level::integer,
277 CASE WHEN tags->'maritime'='yes' THEN 'yes' ELSE 'no' END AS maritime
281 "boundary" = 'administrative'
282 AND admin_level IN ('1','2','3','4')
283 AND "boundary" IS NOT NULL
288 extent_from_subquery: 'true'
296 way, CASE WHEN amenity IS NOT NULL or shop IS NOT NULL THEN 'yes' ELSE 'no' END AS poi, building AS type
300 building NOT IN ('0','false', 'no')
303 extent_from_subquery: 'true'
309 table: "( SELECT way, aeroway AS type, tunnel FROM planet_osm_polygon WHERE aeroway IN ('apron', 'runway', 'taxiway')) AS data"
311 extent_from_subquery: 'true'
318 ( SELECT way, aeroway AS type, tunnel FROM planet_osm_line
319 WHERE aeroway IN ('apron', 'runway', 'taxiway')
322 extent_from_subquery: 'true'
324 - id: turning_circle_case
328 table: "( SELECT way \n FROM planet_osm_point \n WHERE highway = 'turning_circle'\n) AS data"
330 extent_from_subquery: 'true'
338 way, name, access, construction, stratum, type,
340 WHEN smoothness IN ('bad', 'very_bad', 'horrible', 'very_horrible') THEN 'bad'
344 WHEN surface IN ('paved', 'paving_stones', 'asphalt', 'concrete') THEN 'paved'
345 WHEN (surface IS NULL AND type IN ('trunk', 'trunk_link', 'motorway', 'motorway_link', 'primary', 'primary_link', 'secondary', 'secondary_link', 'tertiary', 'tertiary_link')) THEN 'paved'
349 WHEN tunnel IS NOT NULL AND tunnel!='no' THEN 'tunnel'
350 WHEN bridge IS NOT NULL AND bridge!='no' THEN 'bridge'
351 WHEN ford IS NOT NULL AND ford!='no' THEN 'ford'
355 WHEN type IN ('motorway', 'trunk', 'trunk_link') THEN 'motorway'
356 WHEN type ~ E'\\w+_link$' THEN regexp_replace(type, '_link', '')
357 WHEN type IN ('unclassified', 'road', 'service') THEN 'standard'
358 WHEN type IN ('residential', 'living_street') THEN 'urban'
359 WHEN type IN ('path', 'cycleway', 'footway', 'pedestrian', 'steps', 'bridleway') THEN 'noauto'
364 way, name, bridge, access, surface, tunnel, tags->'smoothness' AS smoothness, tags->'ford' AS ford, layer, tags->'narrow' AS narrow, construction,
366 WHEN true THEN layer::integer
370 WHEN highway='construction' AND construction IS NOT NULL THEN construction
374 WHEN highway IN ('trunk', 'motorway') THEN 1
375 WHEN highway IN ('primary', 'secondary', 'tertiary') THEN 10
376 WHEN highway IN ('tertiary') THEN 100
385 stratum, prio DESC, z_order
388 a.type!='construction' and (a.construction!='yes' OR a.construction IS NULL)
391 extent_from_subquery: 'true'
397 table: "( SELECT way, route, name, z_order FROM planet_osm_line WHERE route IS NOT NULL AND route='ferry' ORDER BY z_order) as ferry"
399 extent_from_subquery: 'true'
405 table: "( SELECT way, tunnel, bridge, railway, service, CASE WHEN railway in ('spur','siding') or (railway='rail' and service in ('spur','siding','yard')) THEN 'yard' WHEN railway='disused' THEN 'disused' WHEN railway='rail' THEN 'main' ELSE 'other' END AS type FROM planet_osm_line WHERE railway IS NOT NULL AND railway!='abandoned' AND railway!='dismantled' AND railway!='razed' AND railway!='historic' ORDER BY z_order) as rail"
407 extent_from_subquery: 'true'
414 ( SELECT way, highway AS type
416 FROM planet_osm_roads
418 WHERE highway IN ('motorway', 'trunk', 'primary', 'secondary',
419 'motorway_link', 'trunk_link')
423 extent_from_subquery: 'true'
430 ( SELECT way, highway AS type, bridge, tunnel
431 FROM planet_osm_roads
432 WHERE highway IN ('motorway', 'trunk')
435 extent_from_subquery: 'true'
437 - id: turning_circle_fill
441 table: "( SELECT way \n FROM planet_osm_point\n WHERE highway = 'turning_circle'\n) AS data"
443 extent_from_subquery: 'true'
450 table: '(select way, barrier from planet_osm_line where barrier is not null) as data'
452 extent_from_subquery: 'true'
461 way,barrier,"natural"
465 barrier IS NOT NULL OR "natural"='hedge'
468 extent_from_subquery: 'true'
475 table: "(SELECT way, power AS type, tags->'generator:source' AS source, name FROM planet_osm_polygon WHERE power IS NOT NULL) as data"
477 extent_from_subquery: 'true'
483 table: "(SELECT way, power AS type, tags->'generator:source' AS source, name FROM planet_osm_line WHERE power IS NOT NULL) as data"
485 extent_from_subquery: 'true'
492 table: "(SELECT way, power AS type, tags->'generator:source' AS source, name FROM planet_osm_point WHERE power IS NOT NULL) as data"
494 extent_from_subquery: 'true'
501 table: "(select way,name,CASE WHEN tags ? 'iata' THEN 'airport' WHEN aeroway='aerodrome' THEN 'airfield' ELSE null END AS aeroway FROM planet_osm_point WHERE aeroway='aerodrome') as data"
503 extent_from_subquery: 'true'
510 table: "(select way,name,CASE WHEN tags ? 'iata' THEN 'airport' WHEN aeroway='aerodrome' THEN 'airfield' ELSE null END AS aeroway FROM planet_osm_polygon WHERE aeroway='aerodrome') as data"
512 extent_from_subquery: 'true'
521 way, name, COALESCE(amenity, leisure, tags->'healthcare', shop, tourism, highway, tags->'emergency', barrier) AS main, man_made, religion,
522 CASE WHEN shop IS NOT NULL AND shop!='no' THEN shop ELSE NULL END AS shop,
523 tags->'craft' as craft, tags->'pump' as pump, tags->'drinking_water' as drinking_water, power, tags->'content' AS content
527 amenity IS NOT NULL OR shop IS NOT NULL OR tags ? 'craft' OR tags ? 'healthcare'
528 OR tourism IN ('alpine_hut','camp_site','caravan_site','guest_house','hostel','hotel','motel','museum','viewpoint','bed_and_breakfast','information','chalet')
529 OR highway IN ('bus_stop','traffic_signals','ford', 'street_lamp')
530 OR man_made IN ('mast','water_tower', 'tower', 'water_well', 'watermill', 'storage_tank')
531 OR historic IN ('memorial','archaeological_site')
532 OR leisure IN ('playground','slipway', 'beach_resort')
533 OR tags @> hstore ('emergency', 'fire_hydrant')
534 OR power IN ('generator', 'sub_station', 'tower', 'pole') OR barrier IN ('border_control')
537 extent_from_subquery: 'true'
546 way, name, COALESCE(amenity, leisure, tags->'healthcare', shop, tourism, highway, tags->'emergency', barrier) AS main, man_made, religion,
547 CASE WHEN shop IS NOT NULL AND shop!='no' THEN shop ELSE NULL END AS shop,
548 tags->'craft' as craft, tags->'pump' as pump, tags->'drinking_water' as drinking_water,
549 power, tags->'content' AS content
553 amenity IS NOT NULL OR shop IS NOT NULL OR tags ? 'healthcare'
554 OR tourism IN ('alpine_hut','camp_site','caravan_site','guest_house','hostel','hotel','motel','museum','viewpoint','bed_and_breakfast','information','chalet')
555 OR highway IN ('bus_stop','traffic_signals') OR historic in ('memorial','archaeological_site') OR leisure='playground'
556 OR power IN ('plant', 'sub_station')
559 extent_from_subquery: 'true'
565 table: "( SELECT way, CASE WHEN place='country' THEN 1 WHEN capital='yes' AND admin_level='2' THEN 10 WHEN place='state' THEN 20 WHEN place='city' THEN 21 WHEN place='town' THEN 30 ELSE 100 END as prio, place AS type, name, z_order, CASE WHEN population ~ E'^\\d{1,9}$' THEN population::integer ELSE NULL END AS population, CASE WHEN capital='yes' AND admin_level='2' THEN 'country' ELSE NULL END AS is_capital FROM planet_osm_point WHERE place in ('country', 'state', 'city', 'town') AND place IS NOT NULL ORDER BY prio, population DESC NULLS LAST) AS data"
567 extent_from_subquery: 'true'
573 table: "( SELECT way, CASE WHEN place='country' THEN 1 WHEN capital='yes' AND admin_level='2' THEN 10 WHEN place='state' THEN 20 WHEN place='town' THEN 30 WHEN place='village' THEN 40 ELSE 100 END as prio, place AS type, name, z_order, CASE WHEN population ~ E'^\\d{1,9}$' THEN population::integer ELSE NULL END AS population, CASE WHEN capital='yes' AND admin_level='2' THEN 'country' ELSE NULL END AS is_capital FROM planet_osm_point WHERE place in ('country', 'state', 'city', 'town', 'village', 'hamlet', 'suburb', 'neighbourhood', 'locality') AND place IS NOT NULL ORDER BY prio, population DESC NULLS LAST) AS data"
575 extent_from_subquery: 'true'
581 table: '( SELECT COALESCE(landuse, leisure, "natural", highway, amenity, tourism) AS type, name, way_area AS area, ST_PointOnSurface(way) AS way FROM planet_osm_polygon WHERE name IS NOT NULL AND (landuse IS NOT NULL OR leisure IS NOT NULL OR "natural" IS NOT NULL) AND way && !bbox! AND ST_IsValid(way) ORDER BY area DESC) AS data'
583 extent_from_subquery: 'true'
589 table: "( SELECT way, highway AS type, name, ref, CASE WHEN oneway IN ('yes', '-1') THEN oneway ELSE 'no' END AS oneway, CHAR_LENGTH(ref) AS reflen FROM planet_osm_line WHERE highway IN ('motorway', 'trunk') AND (name IS NOT NULL OR ref IS NOT NULL)) AS data"
591 extent_from_subquery: 'true'
597 table: "( SELECT way, highway AS type, name, CASE WHEN oneway IN ('yes', '-1') THEN oneway ELSE 'no' END AS oneway FROM planet_osm_line WHERE (name IS NOT NULL OR oneway IN ('yes', '-1')) AND highway IN ('primary', 'secondary', 'tertiary')) AS data"
599 extent_from_subquery: 'true'
601 - id: minorroad_label
606 ( SELECT way, highway AS type, name, CASE WHEN oneway IN ('yes', '-1')
607 THEN oneway ELSE 'no' END AS oneway FROM planet_osm_line WHERE (name IS
608 NOT NULL OR oneway IN ('yes', '-1')) AND highway IN ('residential',
609 'unclassified', 'road', 'living_street', 'unknown')
613 extent_from_subquery: 'true'
615 - id: admin-label-5-10
621 ST_Intersection(p.way, !bbox!) AS way, name, cast(regexp_replace(admin_level,'[^0-9]','','g') AS integer) AS admin_level
625 ST_Intersects(p.way,!bbox!) AND not ST_Covers(p.way, !bbox!)
626 AND boundary='administrative' AND admin_level IN ('5', '6', '7', '8', '9', '10')
631 extent_from_subquery: 'true'
633 - id: admin-label-1-4
639 ST_Intersection(p.way, !bbox!) AS way, name, cast(regexp_replace(admin_level,'[^0-9]','','g') AS integer) AS admin_level
643 ST_Intersects(p.way, !bbox!) AND not ST_Covers(p.way, !bbox!)
644 AND boundary='administrative' AND admin_level IN ('0', '2', '3', '4')
649 extent_from_subquery: 'true'
655 table: "( SELECT way, waterway AS type, name\n FROM planet_osm_line\n WHERE waterway IN ('canal', 'river', 'stream') \n AND name IS NOT NULL\n) AS data"
657 extent_from_subquery: 'true'
659 - id: natural_point_label
665 way, "natural" AS type, name,
666 CASE WHEN ele ~ E'^\\d{1,5}$' THEN ele::integer ELSE null END as ele
670 "natural" IS NOT NULL AND "natural" IN ('peak', 'bay', 'volcano')
671 ORDER BY ele DESC NULLS LAST
674 extent_from_subquery: 'true'
680 table: " (select way,\"addr:housenumber\" AS housenumber, CASE WHEN \"addr:housenumber\" ~ E'^\\d+$' AND mod(\"addr:housenumber\"::bigint, 5) IN (0, 1) THEN 'yes' ELSE 'no' END AS mod5 FROM planet_osm_polygon WHERE \"addr:housenumber\" IS NOT NULL AND building IS NOT NULL UNION SELECT way,\"addr:housenumber\" AS housenumber, CASE WHEN \"addr:housenumber\" ~ E'^\\d+$' AND mod(\"addr:housenumber\"::bigint, 5) IN (0, 1) THEN 'yes' ELSE 'no' END AS mod5 FROM planet_osm_point WHERE \"addr:housenumber\" IS NOT NULL) as data"
682 extent_from_subquery: 'true'
686 attribution: 'Data © OpenStreetMap (and) contributors under ODbL 1.0'
689 compareUrl: 'http://{s}.tile.openstreetmap.fr/hot/{z}/{x}/{y}.png'