areas: area_tags: [buildings, landuse, leisure, natural, aeroway, amenity] linear_tags: [highway, barrier] tags: load_all: true exclude: [note, "note:*", source, source_ref, "source:*", attribution, comment, fixme, created_by, odbl, "odbl:note", "SK53_bulk:load", "tiger:*", "NHD:*", "nhd:*", "gnis:*", "geobase:*", "accuracy:meters", "sub_sea:type", "waterway:type", "KSJ2:*", "yh:*", "osak:*", "kms:*", "ngbe:*", "naptan:*", "CLC:*", "3dshapes:ggmodelk", AND_nosr_r, import, "it:fvg:*"] generalized_tables: # landuse planet_osm_polygon_landuse_gen_z6: source: planet_osm_polygon_landuse_gen_z7 tolerance: 2445.98490513 sql_filter: area>power(2445.98490513,2) planet_osm_polygon_landuse_gen_z7: source: planet_osm_polygon_landuse_gen_z8 tolerance: 1222.99245256 sql_filter: area>power(2445.98490513,2) planet_osm_polygon_landuse_gen_z8: source: planet_osm_polygon_landuse_gen_z9 sql_filter: area>power(2445.98490513,2) tolerance: 611.496226281 planet_osm_polygon_landuse_gen_z9: source: planet_osm_polygon_landuse_gen_z10 sql_filter: area>power(1222.99245256,2) tolerance: 305.748113141 planet_osm_polygon_landuse_gen_z10: source: planet_osm_polygon_landuse_gen_z11 sql_filter: area>power(611.496226281,2) tolerance: 152.87405657 planet_osm_polygon_landuse_gen_z11: source: planet_osm_polygon_landuse_gen_z12 sql_filter: area>power(305.748113141,2) tolerance: 76.4370282852 planet_osm_polygon_landuse_gen_z12: source: planet_osm_polygon_landuse_gen_z13 sql_filter: area>power(152.87405657,2) tolerance: 38.2185141426 planet_osm_polygon_landuse_gen_z13: source: planet_osm_polygon_landuse sql_filter: area>power(76.4370282852,2) AND ST_IsValid(way) tolerance: 19.1092570713 tables: planet_osm_point: type: point mapping: __any__: [__any__] columns: - name: osm_id type: id - key: amenity name: amenity type: string - key: highway name: highway type: string - key: name name: name type: string - key: place name: place type: string - key: population name: population type: string - key: public_transport name: public_transport type: string - key: railway name: railway type: string - key: tags name: tags type: hstore_tags - name: way type: geometry planet_osm_polygon: type: polygon mapping: __any__: [__any__] columns: - name: osm_id type: id - key: aeroway name: aeroway type: string - key: amenity name: amenity type: string - key: area name: area type: string - key: building name: building type: string - key: boundary name: boundary type: string - key: highway name: highway type: string - key: landuse name: landuse type: string - key: leisure name: leisure type: string - key: name name: name type: string - key: natural name: natural type: string - key: public_transport name: public_transport type: string - key: railway name: railway type: string - key: waterway name: waterway type: string - name: z_order type: enumerate args: values: - land - island - lan - heath - railway - industrial - commercial - retail - residential - quarry - zoo - vineyard - orchard - scrub - hospital - place_of_worship - theatre - cinema - nature_reserve - parking - fuel - baracks - library - college - school - university - golf_course - allotments - common - pitch - sports_centre - garden - recreation_ground - village_green - wetland - grass - meadow - wood - farmland - farm - farmyard - cemetery - forest - park - playground - footway - pedestrian - water - key: way_area name: way_area type: area - key: tags name: tags type: hstore_tags - name: way type: validated_geometry planet_osm_polygon_landuse: type: polygon columns: - name: osm_id type: id - key: aeroway name: aeroway type: string - key: amenity name: amenity type: string - key: area name: area type: area - key: boundary name: boundary type: string - key: landuse name: landuse type: string - key: leisure name: leisure type: string - key: name name: name type: string - key: natural name: natural type: string - name: z_order type: enumerate args: values: - land - island - lan - heath - railway - industrial - commercial - retail - residential - quarry - zoo - vineyard - orchard - scrub - hospital - place_of_worship - theatre - cinema - nature_reserve - parking - fuel - baracks - library - college - school - university - golf_course - allotments - common - pitch - sports_centre - garden - recreation_ground - village_green - wetland - grass - meadow - wood - farmland - farm - farmyard - cemetery - forest - park - playground - footway - pedestrian - water - name: way type: validated_geometry mapping: natural: - wood leisure: - national_reserve - nature_reserve - golf_course - park - playground aeroway: [__any__] landuse: - wood - forest - cemetery - industrial - village_green amenity: - school - university - hospital boundary: - national_park planet_osm_line: type: linestring mapping: __any__: [__any__] columns: - name: osm_id type: id - key: tags name: tags type: hstore_tags - name: way type: geometry - key: aeroway name: aeroway type: string - key: access name: access type: string - key: bridge name: bridge type: string - key: highway name: highway type: string - key: name name: name type: string - key: railway name: railway type: string - key: ref name: ref type: string - key: tunnel name: tunnel type: string - key: waterway name: waterway type: string - key: z_order name: z_order type: wayzorder admin: type: relation_member mapping: __any__: [__any__] columns: - name: relation_id type: id - name: osm_id type: id from_member: true - name: way type: geometry - key: name name: name type: string - key: boundary name: boundary type: string - key: admin_level name: admin_level type: string - key: claimed_by name: claimed_by type: string - key: disputed_by name: disputed_by type: string - key: maritime name: maritime type: bool from_member: true - key: tags name: tags type: hstore_tags filters: require: admin_level: ['2', '4'] boundary: ['administrative'] water: type: polygon mapping: natural: [ "water" ] waterway: [ __any__ ] landuse: [ "reservoir", "pond" ] columns: - name: osm_id type: id - key: landuse name: landuse type: string - key: leisure name: leisure type: string - key: natural name: natural type: string - key: waterway name: waterway type: string - key: way_area name: way_area type: area - name: way type: geometry wikidata_relation_members: type: relation_member columns: - name: osm_id type: id - name: geometry type: geometry - key: wikidata name: wikidata type: string relation_types: - multipolygon - route - route_master - restriction - boundary - public_transport - destination_sign - waterway - enforcement - connectivity mapping: wikidata: [__any__] wikidata_relation_polygon: type: polygon mapping: wikidata: [__any__] columns: - name: osm_id type: id - key: wikidata name: wikidata type: string - name: geometry type: geometry