postgis - Imposm：从标签属性导入值
问题描述
我使用 imposm 将 OpenStreetMap 数据导入 PostGIS 数据库。这很好用。
但我想包括一些存储在 OSM 数据的标签列中的值。例如，我想从highway=footway位于名为lit. 注意我不想在新的 hstore 列中导入所有标签，只是选择的标签，它们的键应该成为 imposm 导入中的新列。
我不知道如何格式化映射文件（json）来实现这个目标。谢谢你的帮助。
我当前的 mapping.json 如下所示：
{
"generalized_tables": {
"waterareas_gen1": {
"source": "waterareas",
"sql_filter": "ST_Area(geometry)>50000.000000",
"tolerance": 50.0
},
"waterareas_gen0": {
"source": "waterareas_gen1",
"sql_filter": "ST_Area(geometry)>500000.000000",
"tolerance": 200.0
},
"roads_gen0": {
"source": "roads_gen1",
"sql_filter": null,
"tolerance": 200.0
},
"roads_gen1": {
"source": "roads",
"sql_filter": "type IN ('motorway', 'motorway_link', 'trunk', 'trunk_link', 'primary', 'primary_link', 'secondary', 'secondary_link', 'tertiary', 'tertiary_link')",
"tolerance": 50.0
},
"railways": {
"source": "roads",
"sql_filter": "type IN ('rail', 'tram', 'light_rail', 'subway', 'narrow_gauge', 'preserved', 'funicular', 'monorail')"
},
"railways_gen1": {
"source": "railways",
"sql_filter": null,
"tolerance": 50.0
},
"railways_gen0": {
"source": "railways_gen1",
"sql_filter": null,
"tolerance": 200.0
},
"waterways_gen0": {
"source": "waterways_gen1",
"sql_filter": "type IN ('river', 'canal')",
"tolerance": 200
},
"waterways_gen1": {
"source": "waterways",
"sql_filter": "type IN ('river', 'canal', 'stream')",
"tolerance": 50.0
},
"landusages_gen1": {
"source": "landusages",
"sql_filter": "ST_Area(geometry)>50000.000000",
"tolerance": 50.0
},
"landusages_gen0": {
"source": "landusages_gen1",
"sql_filter": "type IN ('forest', 'wood') AND ST_Area(geometry)>500000.000000",
"tolerance": 200.0
},
"landusages_gen00": {
"source": "landusages_gen0",
"sql_filter": "type IN ('forest', 'wood') AND ST_Area(geometry)>1000000.000000",
"tolerance": 500.0
}
},
"tables": {
"landusages": {
"columns": [
{
"type": "id",
"name": "osm_id",
"key": null
},
{
"type": "geometry",
"name": "geometry",
"key": null
},
{
"type": "string",
"name": "name",
"key": "name"
},
{
"type": "mapping_value",
"name": "type",
"key": null
},
{
"type": "webmerc_area",
"name": "area",
"key": null
},
{
"args": {
"values": [
"land",
"island",
"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"
]
},
"type": "enumerate",
"name": "z_order"
}
],
"type": "polygon",
"mapping": {
"landuse": [
"park",
"forest",
"residential",
"retail",
"commercial",
"industrial",
"railway",
"cemetery",
"grass",
"farmyard",
"farm",
"farmland",
"orchard",
"vineyard",
"wood",
"meadow",
"village_green",
"recreation_ground",
"allotments",
"quarry"
],
"leisure": [
"park",
"garden",
"playground",
"golf_course",
"sports_centre",
"pitch",
"stadium",
"common",
"nature_reserve"
],
"natural": [
"wood",
"land",
"scrub",
"wetland",
"heath",
"bare_rock",
"glacier",
"scree",
"fell",
"shingle"
],
"highway": [
"pedestrian",
"footway"
],
"amenity": [
"university",
"school",
"college",
"library",
"fuel",
"parking",
"cinema",
"theatre",
"place_of_worship",
"hospital"
],
"barrier": [
"hedge"
],
"tourism": [
"zoo"
],
"man_made": [
"pier"
],
"aeroway": [
"runway",
"taxiway"
],
"place": [
"island"
],
"military": [
"barracks"
]
}
},
"buildings": {
"columns": [
{
"type": "id",
"name": "osm_id",
"key": null
},
{
"type": "geometry",
"name": "geometry",
"key": null
},
{
"type": "string",
"name": "name",
"key": "name"
},
{
"type": "mapping_value",
"name": "type",
"key": null
}
],
"type": "polygon",
"mapping": {
"building": [
"__any__"
]
}
},
"places": {
"columns": [
{
"type": "id",
"name": "osm_id",
"key": null
},
{
"type": "geometry",
"name": "geometry",
"key": null
},
{
"type": "string",
"name": "name",
"key": "name"
},
{
"type": "mapping_value",
"name": "type",
"key": null
},
{
"args": {
"values": [
"locality",
"suburb",
"hamlet",
"village",
"town",
"city",
"county",
"region",
"state",
"country"
]
},
"type": "enumerate",
"name": "z_order"
},
{
"type": "integer",
"name": "population",
"key": "population"
}
],
"type": "point",
"mapping": {
"place": [
"country",
"state",
"region",
"county",
"city",
"town",
"village",
"hamlet",
"suburb",
"locality"
],
"natural": [
"peak"
]
}
},
"transport_areas": {
"columns": [
{
"type": "id",
"name": "osm_id",
"key": null
},
{
"type": "geometry",
"name": "geometry",
"key": null
},
{
"type": "string",
"name": "name",
"key": "name"
},
{
"type": "mapping_value",
"name": "type",
"key": null
}
],
"type": "polygon",
"mapping": {
"railway": [
"station",
"platform"
],
"aeroway": [
"aerodrome",
"terminal",
"helipad",
"apron"
]
}
},
"admin": {
"columns": [
{
"type": "id",
"name": "osm_id",
"key": null
},
{
"type": "geometry",
"name": "geometry",
"key": null
},
{
"type": "string",
"name": "name",
"key": "name"
},
{
"type": "mapping_value",
"name": "type",
"key": null
},
{
"type": "integer",
"name": "admin_level",
"key": "admin_level"
}
],
"type": "polygon",
"mapping": {
"boundary": [
"administrative"
]
}
},
"aeroways": {
"columns": [
{
"type": "id",
"name": "osm_id",
"key": null
},
{
"type": "geometry",
"name": "geometry",
"key": null
},
{
"type": "string",
"name": "name",
"key": "name"
},
{
"type": "mapping_value",
"name": "type",
"key": null
}
],
"type": "linestring",
"mapping": {
"aeroway": [
"runway",
"taxiway"
]
}
},
"waterways": {
"columns": [
{
"type": "id",
"name": "osm_id",
"key": null
},
{
"type": "geometry",
"name": "geometry",
"key": null
},
{
"type": "string",
"name": "name",
"key": "name"
},
{
"type": "string",
"name": "tunnel",
"key": "tunnel"
},
{
"type": "mapping_value",
"name": "type",
"key": null
}
],
"type": "linestring",
"mapping": {
"waterway": [
"stream",
"river",
"canal",
"drain",
"ditch"
],
"barrier": [
"ditch"
]
}
},
"barrierways": {
"columns": [
{
"type": "id",
"name": "osm_id",
"key": null
},
{
"type": "geometry",
"name": "geometry",
"key": null
},
{
"type": "string",
"name": "name",
"key": "name"
},
{
"type": "mapping_value",
"name": "type",
"key": null
}
],
"type": "linestring",
"mapping": {
"barrier": [
"city_wall",
"fence",
"hedge",
"retaining_wall",
"wall",
"bollard",
"gate",
"spikes",
"lift_gate",
"kissing_gate",
"embankment",
"yes",
"wire_fence"
]
}
},
"transport_points": {
"columns": [
{
"type": "id",
"name": "osm_id",
"key": null
},
{
"type": "geometry",
"name": "geometry",
"key": null
},
{
"type": "string",
"name": "name",
"key": "name"
},
{
"type": "mapping_value",
"name": "type",
"key": null
},
{
"type": "string",
"name": "ref",
"key": "ref"
}
],
"type": "point",
"mapping": {
"railway": [
"station",
"halt",
"tram_stop",
"crossing",
"level_crossing",
"subway_entrance"
],
"aeroway": [
"aerodrome",
"terminal",
"helipad",
"gate"
],
"highway": [
"motorway_junction",
"turning_circle",
"bus_stop"
]
}
},
"amenities": {
"columns": [
{
"type": "id",
"name": "osm_id",
"key": null
},
{
"type": "geometry",
"name": "geometry",
"key": null
},
{
"type": "string",
"name": "name",
"key": "name"
},
{
"type": "mapping_value",
"name": "type",
"key": null
}
],
"type": "point",
"mapping": {
"amenity": [
"university",
"school",
"library",
"fuel",
"hospital",
"fire_station",
"police",
"townhall"
]
}
},
"barrierpoints": {
"columns": [
{
"type": "id",
"name": "osm_id",
"key": null
},
{
"type": "geometry",
"name": "geometry",
"key": null
},
{
"type": "string",
"name": "name",
"key": "name"
},
{
"type": "mapping_value",
"name": "type",
"key": null
}
],
"type": "point",
"mapping": {
"barrier": [
"block",
"bollard",
"cattle_grid",
"chain",
"cycle_barrier",
"entrance",
"horse_stile",
"gate",
"spikes",
"lift_gate",
"kissing_gate",
"fence",
"yes",
"wire_fence",
"toll_booth",
"stile"
]
}
},
"housenumbers_interpolated": {
"columns": [
{
"type": "id",
"name": "osm_id",
"key": null
},
{
"type": "geometry",
"name": "geometry",
"key": null
},
{
"type": "string",
"name": "name",
"key": "name"
},
{
"type": "mapping_value",
"name": "type",
"key": null
},
{
"type": "string",
"name": "addr:street",
"key": "addr:street"
},
{
"type": "string",
"name": "addr:postcode",
"key": "addr:postcode"
},
{
"type": "string",
"name": "addr:city",
"key": "addr:city"
},
{
"type": "string",
"name": "addr:inclusion",
"key": "addr:inclusion"
}
],
"type": "linestring",
"mapping": {
"addr:interpolation": [
"__any__"
]
}
},
"roads": {
"columns": [
{
"type": "id",
"name": "osm_id",
"key": null
},
{
"type": "geometry",
"name": "geometry",
"key": null
},
{
"type": "mapping_value",
"name": "type",
"key": null
},
{
"type": "string",
"name": "name",
"key": "name"
},
{
"type": "boolint",
"name": "tunnel",
"key": "tunnel"
},
{
"type": "boolint",
"name": "bridge",
"key": "bridge"
},
{
"type": "direction",
"name": "oneway",
"key": "oneway"
},
{
"type": "string",
"name": "ref",
"key": "ref"
},
{
"type": "wayzorder",
"name": "z_order",
"key": "layer"
},
{
"type": "string",
"name": "access",
"key": "access"
},
{
"type": "string",
"name": "service",
"key": "service"
},
{
"type": "mapping_key",
"name": "class",
"key": null
}
],
"type": "linestring",
"filters": {
"reject": {
"area": [ "yes" ]
}
},
"mappings": {
"railway": {
"mapping": {
"railway": [
"rail",
"tram",
"light_rail",
"subway",
"narrow_gauge",
"preserved",
"funicular",
"monorail",
"disused"
]
}
},
"roads": {
"mapping": {
"man_made": [
"pier",
"groyne"
],
"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"
]
}
}
}
},
"housenumbers": {
"columns": [
{
"type": "id",
"name": "osm_id",
"key": null
},
{
"type": "geometry",
"name": "geometry",
"key": null
},
{
"type": "string",
"name": "name",
"key": "name"
},
{
"type": "mapping_value",
"name": "type",
"key": null
},
{
"type": "string",
"name": "addr:street",
"key": "addr:street"
},
{
"type": "string",
"name": "addr:postcode",
"key": "addr:postcode"
},
{
"type": "string",
"name": "addr:city",
"key": "addr:city"
}
],
"type": "point",
"mapping": {
"addr:housenumber": [
"__any__"
]
}
},
"waterareas": {
"columns": [
{
"type": "id",
"name": "osm_id",
"key": null
},
{
"type": "geometry",
"name": "geometry",
"key": null
},
{
"type": "string",
"name": "name",
"key": "name"
},
{
"type": "mapping_value",
"name": "type",
"key": null
},
{
"type": "webmerc_area",
"name": "area",
"key": null
}
],
"type": "polygon",
"mapping": {
"waterway": [
"riverbank",
"dock"
],
"landuse": [
"basin",
"reservoir"
],
"natural": [
"water"
],
"amenity": [
"swimming_pool"
],
"leisure": [
"swimming_pool"
]
}
}
}
}
解决方案
推荐阅读
- java - Java 字符串由 \\s+ 和字符串数组拆分
- ruby - 带有 if 条件的除法
- javascript - 生成页面的 Javascript 范围
- javascript - JSTree CSS 设置
- c# - 是否有一种内置方法可以有效地查找向量是否在向量数组中，如果是，它是什么#变量
- ruby-on-rails - 正则表达式和 Rails 验证
- graph - 如何使用 rust 和 petgraph 解决旅行商问题？
- python - BeautifulSoup .text 方法错误：ResultSet 对象没有属性“文本”
- reactjs - 如何在 Docker 上导入@react-pdf/renderer？
- html - 如何在顶部和底部的div内溢出图像，而不仅仅是在左右？