openmaptiles/layers/landuse/mapping.yaml

generalized_tables:
  # etldoc: osm_landuse_polygon_gen_z7 -> osm_landuse_polygon_gen_z6
  landuse_polygon_gen_z6:
    source: landuse_polygon_gen_z7
    tolerance: ZRES6
    sql_filter: area>power(ZRES6,2)
  # etldoc: osm_landuse_polygon_gen_z8 -> osm_landuse_polygon_gen_z7
  landuse_polygon_gen_z7:
    source: landuse_polygon_gen_z8
    tolerance: ZRES7
    sql_filter: area>power(ZRES6,2)
  # etldoc: osm_landuse_polygon_gen_z9 -> osm_landuse_polygon_gen_z8
  landuse_polygon_gen_z8:
    source: landuse_polygon_gen_z9
    sql_filter: area>power(ZRES6,2) AND (landuse='residential' OR place='suburb' OR place='quarter' OR place='neighbourhood')
    tolerance: ZRES8
  # etldoc: osm_landuse_polygon_gen_z10 -> osm_landuse_polygon_gen_z9
  landuse_polygon_gen_z9:
    source: landuse_polygon_gen_z10
    sql_filter: area>power(ZRES7,2)
    tolerance: ZRES9
  # etldoc: osm_landuse_polygon_gen_z11 -> osm_landuse_polygon_gen_z10
  landuse_polygon_gen_z10:
    source: landuse_polygon_gen_z11
    sql_filter: area>power(ZRES8,2)
    tolerance: ZRES10
  # etldoc: osm_landuse_polygon_gen_z12 -> osm_landuse_polygon_gen_z11
  landuse_polygon_gen_z11:
    source: landuse_polygon_gen_z12
    sql_filter: area>power(ZRES9,2)
    tolerance: ZRES11
  # etldoc: osm_landuse_polygon_gen_z13 -> osm_landuse_polygon_gen_z12
  landuse_polygon_gen_z12:
    source: landuse_polygon_gen_z13
    sql_filter: area>power(ZRES10,2)
    tolerance: ZRES12
  # etldoc: osm_landuse_polygon -> osm_landuse_polygon_gen_z13
  landuse_polygon_gen_z13:
    source: landuse_polygon
    sql_filter: area>power(ZRES11,2) AND ST_IsValid(geometry)
    tolerance: ZRES13

tables:
  # etldoc: imposm3 -> osm_landuse_polygon
  landuse_polygon:
    type: polygon
    columns:
    - name: osm_id
      type: id
    - name: geometry
      type: validated_geometry
    - name: landuse
      key: landuse
      type: string
    - name: amenity
      key: amenity
      type: string
    - name: leisure
      key: leisure
      type: string
    - name: tourism
      key: tourism
      type: string
    - name: place
      key: place
      type: string
    - name: waterway
      key: waterway
      type: string
    - name: area
      type: area
    mapping:
      landuse:
      - railway
      - cemetery
      - military
      - quarry
      # zoning
      - residential
      - commercial
      - industrial
      - garages
      - retail
      amenity:
      - bus_station
      - school
      - university
      - kindergarten
      - college
      - library
      - hospital
      - grave_yard
      leisure:
      - stadium
      - pitch
      - playground
      - track
      tourism:
      - theme_park
      - zoo
      place:
      - suburb
      - quarter
      - neighbourhood
      waterway:
      - dam
Integrate urban into landuse 2016-10-24 10:02:33 +00:00			`generalized_tables:`
Refactor schema, one _gen_z view per zoom. (#1045) * Refactor layer aeroway. * Refactor layer boundary. * Refactor layer landcover. * Refactor layer landuse. * Refactor layer park. * Refactor layer transportation. * Refactor layer water. * Refactor layer waterway. * Re-generate water* layers etl_diagrams. * Regenerate etl_diagrams for waterway. * Cast NULL to text. 2020-11-26 12:54:00 +00:00			`# etldoc: osm_landuse_polygon_gen_z7 -> osm_landuse_polygon_gen_z6`
			`landuse_polygon_gen_z6:`
			`source: landuse_polygon_gen_z7`
			`tolerance: ZRES6`
			`sql_filter: area>power(ZRES6,2)`
			`# etldoc: osm_landuse_polygon_gen_z8 -> osm_landuse_polygon_gen_z7`
			`landuse_polygon_gen_z7:`
			`source: landuse_polygon_gen_z8`
removing ne_10m source 2019-11-27 10:51:15 +00:00			`tolerance: ZRES7`
Refactor schema, one _gen_z view per zoom. (#1045) * Refactor layer aeroway. * Refactor layer boundary. * Refactor layer landcover. * Refactor layer landuse. * Refactor layer park. * Refactor layer transportation. * Refactor layer water. * Refactor layer waterway. * Re-generate water* layers etl_diagrams. * Regenerate etl_diagrams for waterway. * Cast NULL to text. 2020-11-26 12:54:00 +00:00			`sql_filter: area>power(ZRES6,2)`
			`# etldoc: osm_landuse_polygon_gen_z9 -> osm_landuse_polygon_gen_z8`
			`landuse_polygon_gen_z8:`
			`source: landuse_polygon_gen_z9`
Add place=quarter to city subdivisions (#1065) This adds `place=quarter` which was introduced in 2011 as a subdivision of villages/towns/cities as a value that sits between `place=suburb` and `place=neighbourhood`. It has by now been used over 40,000 times and is rendered in the OSM-Carto. 2021-01-18 13:47:25 +00:00			`sql_filter: area>power(ZRES6,2) AND (landuse='residential' OR place='suburb' OR place='quarter' OR place='neighbourhood')`
removing ne_10m source 2019-11-27 10:51:15 +00:00			`tolerance: ZRES8`
Refactor schema, one _gen_z view per zoom. (#1045) * Refactor layer aeroway. * Refactor layer boundary. * Refactor layer landcover. * Refactor layer landuse. * Refactor layer park. * Refactor layer transportation. * Refactor layer water. * Refactor layer waterway. * Re-generate water* layers etl_diagrams. * Regenerate etl_diagrams for waterway. * Cast NULL to text. 2020-11-26 12:54:00 +00:00			`# etldoc: osm_landuse_polygon_gen_z10 -> osm_landuse_polygon_gen_z9`
			`landuse_polygon_gen_z9:`
			`source: landuse_polygon_gen_z10`
Adjust zres values for buildings,landcover and landuse Decrease size of Belgium Z0-12 mbtiles from 63 MB to 38 MB 2017-05-19 14:30:52 +00:00			`sql_filter: area>power(ZRES7,2)`
Switch to ZRes (#214) 2017-04-25 22:03:29 +00:00			`tolerance: ZRES9`
Refactor schema, one _gen_z view per zoom. (#1045) * Refactor layer aeroway. * Refactor layer boundary. * Refactor layer landcover. * Refactor layer landuse. * Refactor layer park. * Refactor layer transportation. * Refactor layer water. * Refactor layer waterway. * Re-generate water* layers etl_diagrams. * Regenerate etl_diagrams for waterway. * Cast NULL to text. 2020-11-26 12:54:00 +00:00			`# etldoc: osm_landuse_polygon_gen_z11 -> osm_landuse_polygon_gen_z10`
			`landuse_polygon_gen_z10:`
			`source: landuse_polygon_gen_z11`
Adjust zres values for buildings,landcover and landuse Decrease size of Belgium Z0-12 mbtiles from 63 MB to 38 MB 2017-05-19 14:30:52 +00:00			`sql_filter: area>power(ZRES8,2)`
Switch to ZRes (#214) 2017-04-25 22:03:29 +00:00			`tolerance: ZRES10`
Refactor schema, one _gen_z view per zoom. (#1045) * Refactor layer aeroway. * Refactor layer boundary. * Refactor layer landcover. * Refactor layer landuse. * Refactor layer park. * Refactor layer transportation. * Refactor layer water. * Refactor layer waterway. * Re-generate water* layers etl_diagrams. * Regenerate etl_diagrams for waterway. * Cast NULL to text. 2020-11-26 12:54:00 +00:00			`# etldoc: osm_landuse_polygon_gen_z12 -> osm_landuse_polygon_gen_z11`
			`landuse_polygon_gen_z11:`
			`source: landuse_polygon_gen_z12`
Adjust zres values for buildings,landcover and landuse Decrease size of Belgium Z0-12 mbtiles from 63 MB to 38 MB 2017-05-19 14:30:52 +00:00			`sql_filter: area>power(ZRES9,2)`
Switch to ZRes (#214) 2017-04-25 22:03:29 +00:00			`tolerance: ZRES11`
Refactor schema, one _gen_z view per zoom. (#1045) * Refactor layer aeroway. * Refactor layer boundary. * Refactor layer landcover. * Refactor layer landuse. * Refactor layer park. * Refactor layer transportation. * Refactor layer water. * Refactor layer waterway. * Re-generate water* layers etl_diagrams. * Regenerate etl_diagrams for waterway. * Cast NULL to text. 2020-11-26 12:54:00 +00:00			`# etldoc: osm_landuse_polygon_gen_z13 -> osm_landuse_polygon_gen_z12`
			`landuse_polygon_gen_z12:`
			`source: landuse_polygon_gen_z13`
Adjust zres values for buildings,landcover and landuse Decrease size of Belgium Z0-12 mbtiles from 63 MB to 38 MB 2017-05-19 14:30:52 +00:00			`sql_filter: area>power(ZRES10,2)`
Switch to ZRes (#214) 2017-04-25 22:03:29 +00:00			`tolerance: ZRES12`
Refactor schema, one _gen_z view per zoom. (#1045) * Refactor layer aeroway. * Refactor layer boundary. * Refactor layer landcover. * Refactor layer landuse. * Refactor layer park. * Refactor layer transportation. * Refactor layer water. * Refactor layer waterway. * Re-generate water* layers etl_diagrams. * Regenerate etl_diagrams for waterway. * Cast NULL to text. 2020-11-26 12:54:00 +00:00			`# etldoc: osm_landuse_polygon -> osm_landuse_polygon_gen_z13`
			`landuse_polygon_gen_z13:`
Integrate urban into landuse 2016-10-24 10:02:33 +00:00			`source: landuse_polygon`
Add st_isvalid check to imposm3 generalized tables Fix #386 2018-01-31 15:51:46 +00:00			`sql_filter: area>power(ZRES11,2) AND ST_IsValid(geometry)`
Switch to ZRes (#214) 2017-04-25 22:03:29 +00:00			`tolerance: ZRES13`
add etldoc to layer_landuse 2016-11-10 01:12:39 +00:00
Integrate urban into landuse 2016-10-24 10:02:33 +00:00			`tables:`
add etldoc to layer_landuse 2016-11-10 01:12:39 +00:00			`# etldoc: imposm3 -> osm_landuse_polygon`
Integrate urban into landuse 2016-10-24 10:02:33 +00:00			`landuse_polygon:`
			`type: polygon`
Use one pass docs image generation (#751) quicker and cleaner diagram image generation. Remove etl-graph and mapping-graph targets - redundant Also, the obsolete "fields" is still in Imposm's code and both names are accepted, but "fields" is not documented anywhere (PR submitted), and could be removed at any moment. Our docs were not supporting it until this PR, so renaming it at the same time. Several images have been updated due to a more inclusive mapping scan Requires https://github.com/openmaptiles/openmaptiles-tools/pull/147 (merged) 2020-01-23 02:55:22 +00:00			`columns:`
Integrate urban into landuse 2016-10-24 10:02:33 +00:00			`- name: osm_id`
			`type: id`
			`- name: geometry`
			`type: validated_geometry`
			`- name: landuse`
Introduce landuse classes 2016-10-24 12:28:09 +00:00			`key: landuse`
			`type: string`
			`- name: amenity`
			`key: amenity`
			`type: string`
Add national parks 2016-10-24 19:49:03 +00:00			`- name: leisure`
			`key: leisure`
			`type: string`
Handle theme_park as a landuse 2017-12-07 15:54:37 +00:00			`- name: tourism`
			`key: tourism`
			`type: string`
place=suburb and place=neighbourhood added 2019-04-11 09:57:07 +00:00			`- name: place`
			`key: place`
			`type: string`
adding waterway=dam 2019-11-20 17:05:07 +00:00			`- name: waterway`
			`key: waterway`
			`type: string`
Integrate urban into landuse 2016-10-24 10:02:33 +00:00			`- name: area`
Import both area and webmerc_area, use area for filtering (#198) 2017-03-24 15:46:21 +00:00			`type: area`
Integrate urban into landuse 2016-10-24 10:02:33 +00:00			`mapping:`
			`landuse:`
			`- railway`
Introduce landuse classes 2016-10-24 12:28:09 +00:00			`- cemetery`
Integrate urban into landuse 2016-10-24 10:02:33 +00:00			`- military`
Added quarry to landuse list (#1404) This includes quarry in the list of landuse features Co-authored-by: Tomas Pohanka <TomPohys@gmail.com> 2022-09-08 09:43:48 +00:00			`- quarry`
Remove mappings from landcover and landuse 2016-11-28 19:16:00 +00:00			`# zoning`
			`- residential`
			`- commercial`
			`- industrial`
layers/landuse/mapping.yaml: add 'garages' 2019-09-20 10:00:21 +00:00			`- garages`
Remove mappings from landcover and landuse 2016-11-28 19:16:00 +00:00			`- retail`
place=suburb and place=neighbourhood added 2019-04-11 09:57:07 +00:00			`amenity:`
			`- bus_station`
			`- school`
			`- university`
			`- kindergarten`
			`- college`
			`- library`
			`- hospital`
Add support for cemetery tagged as grave_yard (#1175) Fixes #1057 This PR adds `amenity=grave_yard` to the `landuse` layer. A unification function was implemented which encodes all `class=grave_yard` as `class=cemetery` in the tiles, which adds these features for existing users of `class=cemetery` with no change. The unification function can serve as a basis for any other tags that we might want to unify in the `landuse` layer. Tile rendering for an `amenity=grave_yard`. ([Location](https://www.openstreetmap.org/way/857383420)) ![image](https://user-images.githubusercontent.com/3254090/129456504-187d307a-2a20-4b13-af0a-a2850503bb4f.png) Tile rendering for a `landuse=cemetery`. ([Location](https://www.openstreetmap.org/way/385779531)) ![image](https://user-images.githubusercontent.com/3254090/129456654-494c0eb4-9785-467c-b1a0-44abb7f9d5e9.png) 2021-08-18 07:09:51 +00:00			`- grave_yard`
Add national parks 2016-10-24 19:49:03 +00:00			`leisure:`
Remove mappings from landcover and landuse 2016-11-28 19:16:00 +00:00			`- stadium`
Add pitches and playgrounds to landuse 2017-11-08 13:03:50 +00:00			`- pitch`
			`- playground`
add leisure=track 2019-05-15 16:05:44 +00:00			`- track`
Handle theme_park as a landuse 2017-12-07 15:54:37 +00:00			`tourism:`
			`- theme_park`
Add bus_station and zoo in landuse 2018-01-12 13:36:55 +00:00			`- zoo`
place=suburb and place=neighbourhood added 2019-04-11 09:57:07 +00:00			`place:`
			`- suburb`
Add place=quarter to city subdivisions (#1065) This adds `place=quarter` which was introduced in 2011 as a subdivision of villages/towns/cities as a value that sits between `place=suburb` and `place=neighbourhood`. It has by now been used over 40,000 times and is rendered in the OSM-Carto. 2021-01-18 13:47:25 +00:00			`- quarter`
place=suburb and place=neighbourhood added 2019-04-11 09:57:07 +00:00			`- neighbourhood`
adding waterway=dam 2019-11-20 17:05:07 +00:00			`waterway:`
			`- dam`