areas:
  area_tags: [buildings, landuse, leisure, natural, aeroway, boundary]
  linear_tags: [highway, barrier]
tags:
  load_all: true
  exclude: [created_by, source, "tiger:*"]
tables:
  building_polygons:
    columns:
      - name: osm_id
        type: id
      - name: geometry
        type: validated_geometry
      - name: building
        key: building
        type: string
      - name: tags
        type: hstore_tags
    mapping:
      building:part:
        - __any__
      building:
        - __any__
      aeroway:
        - terminal
        - hangar
    filters:
      reject:
        building: ["no", "none", "No", "bridge", "pier", "road", "dam", "ruins", "ruin",
                   "construction", "roof", "collapsed", "foundation", "wall"]
        building:part: ["no", "none", "No"]
        man_made: ["bridge", "pier", "dam"]
    type: polygon
  building_relations:
    columns:
      - name: osm_id
        type: id
      - name: geometry
        type: validated_geometry
      - name: building
        key: building
        type: string
        from_member: true
      - name: member
        type: member_id
      - name: index
        type: member_index
      - name: role
        type: member_role
        from_member: true
      - name: type
        type: member_type
      - name: tags
        type: hstore_tags
    mapping:
      type: [building]
    type: relation_member
  lands:
    columns:
      - name: osm_id
        type: id
      - name: geometry
        type: validated_geometry
      - key: name
        name: name
        type: string
      - name: type
        type: mapping_value
      - name: key
        type: mapping_key
    filters:
      reject:
        building: [__any__]
    mapping:
      amenity:
        - university
        - school
        - college
        - library
        - fuel
        - parking
        - cinema
        - theatre
        - place_of_worship
        - hospital
      landuse:
        - allotments
        - animal_keeping
        - brownfield
        - cemetery
        - commercial
        - education
        - farm
        - farmland
        - farmyard
        - forest
        - garages
        - government
        - grass
        - grassland
        - greenhouse
        - greenhouse_horticulture
        - landfill
        - leisure
        - industrial
        - meadow
        - mine
        - military
        - orchard
        - park
        - plant_nursery
        - quarry
        - railway
        - recreation_ground
        - religious
        - reservoir
        - residential
        - retail
        - school
        - village_green
        - vineyard
        - wood
        - winter_sports
      leisure:
        - common
        - dog_park
        - escape_game
        - garden
        - golf_course
        - ice_rink
        - hackerspace
        - marina
        - miniature_golf
        - nature_reserve
        - park
        - pitch
        - playground
        - sports_centre
        - stadium
        - swimming_area
        - swimming_pool
        - water_park
      natural:
        - beach
        - bare_rock
        - dune
        - fell
        - glacier
        - grassland
        - heath
        - land
        - mud
        - scrub
        - scree
        - sand
        - tundra
        - wetland
        - wood
      place:
        - neighbourhood
        - quarter
        - suburb
      tourism:
        - theme_park
        - zoo
      wetland:
        - bog
        - swamp
        - wet_meadow
        - marsh
        - reedbed
        - saltern
        - tidalflat
        - saltmarsh
        - mangrove
    type: polygon
  roads:
    columns:
      - name: osm_id
        type: id
      - name: geometry
        type: geometry
      - name: type
        type: mapping_value
      - name: class
        type: mapping_key
    filters:
      reject:
        area: ["yes"]
    mappings:
      roads:
        mapping:
          highway:
            - motorway
            - motorway_link
            - trunk
            - trunk_link
            - primary
            - primary_link
            - secondary
            - secondary_link
            - tertiary
            - tertiary_link
            - road
            - path
            - track
            - service
            - footway
            - bridleway
            - cycleway
            - steps
            - pedestrian
            - living_street
            - unclassified
            - residential
            - raceway
            - bridleway
            - corridor
            - raceway
            - construction
          man_made:
            - pier
            - groyne
    type: linestring
  spots:
    columns:
      - name: osm_id
        type: id
      - name: geometry
        type: geometry
      - key: name
        name: name
        type: string
      - name: type
        type: mapping_value
      - name: key
        type: mapping_key
    mapping:
      aerialway:
        - station
      amenity:
        - arts_centre
        - bank
        - bar
        - bbq
        - bicycle_rental
        - biergarten
        - bureau_de_change
        - bus_station
        - cafe
        - car_rental
        - childcare
        - cinema
        - clinic
        - college
        - community_centre
        - courthouse
        - dentist
        - doctors
        - driving_school
        - embassy
        - events_venue
        - fast_food
        - ferry_terminal
        - fire_station
        - food_court
        - fuel
        - grave_yard
        - hospital
        - ice_cream
        - internet_cafe
        - kindergarten
        - library
        - marketplace
        - mobile_money_agent
        - nightclub
        - nursing_home
        - parking
        - pharmacy
        - place_of_worship
        - police
        - post_office
        - prison
        - pub
        - public_building
        - recycling
        - restaurant
        - school
        - shelter
        - social_facility
        - studio
        - swimming_pool
        - taxi
        - telephone
        - theatre
        - toilets
        - townhall
        - university
        - veterinary
      building:
        - dormitory
      historic:
        - monument
        - castle
        - ruins
      landuse:
        - allotments
        - brownfield
        - cemetery
        - commercial
        - farm
        - farmland
        - farmyard
        - forest
        - garages
        - grass
        - grassland
        - landfill
        - industrial
        - meadow
        - mine
        - military
        - orchard
        - park
        - plant_nursery
        - quarry
        - railway
        - recreation_ground
        - reservoir
        - residential
        - retail
        - village_green
        - vineyard
        - wood
        - winter_sports
      leisure:
        - common
        - dog_park
        - escape_game
        - garden
        - golf_course
        - ice_rink
        - hackerspace
        - marina
        - miniature_golf
        - nature_reserve
        - park
        - pitch
        - playground
        - sports_centre
        - stadium
        - swimming_area
        - swimming_pool
        - water_park
      office:
        - __any__
      shop:
        - __any__
    type: point
  boundary:
    columns:
      - name: osm_id
        type: id
      - name: geometry
        type: validated_geometry
      - name: boundary
        type: mapping_value
      - name: name
        key: name:en
        type: string
      - name: admin_level
        key: admin_level
        type: integer
      - name: tags
        type: hstore_tags
    mapping:
      boundary:
        - administrative
        - historic
    type: polygon
  waterbody_polygons:
    type: polygon
    columns:
     - name: osm_id
       type: id
     - name: geometry
       type: validated_geometry
     - name: name
       key: name
       type: string
     - name: tags
       type: hstore_tags
    mapping:
      natural: [water]
      water: [__any__]
      landuse: [reservoir]

