2 # Configuration file for OSM import
5 # put here the name of keys for ways that are assumed to be polygons if they are closed
6 # see http://wiki.openstreetmap.org/wiki/Map_Features
7 closed_ways_are_polygons=aeroway,amenity,boundary,building,craft,geological,historic,landuse,leisure,military,natural,office,place,shop,sport,tourism
9 # comment to avoid laundering of keys ( ':' turned into '_' )
10 attribute_name_laundering=yes
12 # uncomment to report all nodes, including the ones without any (significant) tag
15 # uncomment to report all ways, including the ones without any (significant) tag
27 # keys to report as OGR fields
28 attributes=name,barrier,highway,ref,address,is_in,place,man_made
29 # keys that, alone, are not significant enough to report a node as a OGR point
30 unsignificant=created_by,converted_by,source,time,ele,attribution
31 # keys that should NOT be reported in the "other_tags" field
32 ignore=created_by,converted_by,source,time,ele,note,openGeoDB:,fixme,FIXME
33 # uncomment to avoid creation of "other_tags" field
35 # uncomment to create "all_tags" field. "all_tags" and "other_tags" are exclusive
47 # keys to report as OGR fields
48 attributes=name,highway,waterway,aerialway,barrier,man_made
50 # type of attribute 'foo' can be changed with something like
51 #foo_type=Integer/Real/String/DateTime
53 # keys that should NOT be reported in the "other_tags" field
54 ignore=created_by,converted_by,source,time,ele,note,openGeoDB:,fixme,FIXME
55 # uncomment to avoid creation of "other_tags" field
57 # uncomment to create "all_tags" field. "all_tags" and "other_tags" are exclusive
60 #computed_attributes must appear before the keywords _type and _sql
61 computed_attributes=z_order
63 # Formula based on https://github.com/openstreetmap/osm2pgsql/blob/master/style.lua#L13
64 # [foo] is substituted by value of tag foo. When substitution is not wished, the [ character can be escaped with \[ in literals
65 z_order_sql="SELECT (CASE [highway] WHEN 'minor' THEN 3 WHEN 'road' THEN 3 WHEN 'unclassified' THEN 3 WHEN 'residential' THEN 3 WHEN 'tertiary_link' THEN 4 WHEN 'tertiary' THEN 4 WHEN 'secondary_link' THEN 6 WHEN 'secondary' THEN 6 WHEN 'primary_link' THEN 7 WHEN 'primary' THEN 7 WHEN 'trunk_link' THEN 8 WHEN 'trunk' THEN 8 WHEN 'motorway_link' THEN 9 WHEN 'motorway' THEN 9 ELSE 0 END) + (CASE WHEN [bridge] IN ('yes', 'true', '1') THEN 10 ELSE 0 END) + (CASE WHEN [tunnel] IN ('yes', 'true', '1') THEN -10 ELSE 0 END) + (CASE WHEN [railway] IS NOT NULL THEN 5 ELSE 0 END) + (CASE WHEN [layer] IS NOT NULL THEN 10 * CAST([layer] AS INTEGER) ELSE 0 END)"
69 # note: for multipolygons, osm_id=yes instantiates a osm_id field for the id of relations
70 # and a osm_way_id field for the id of closed ways. Both fields are exclusively set.
78 # keys to report as OGR fields
79 attributes=name,type,aeroway,amenity,admin_level,barrier,boundary,building,craft,geological,historic,land_area,landuse,leisure,man_made,military,natural,office,place,shop,sport,tourism
80 # keys that should NOT be reported in the "other_tags" field
81 ignore=area,created_by,converted_by,source,time,ele,note,openGeoDB:,fixme,FIXME
82 # uncomment to avoid creation of "other_tags" field
84 # uncomment to create "all_tags" field. "all_tags" and "other_tags" are exclusive
96 # keys to report as OGR fields
98 # keys that should NOT be reported in the "other_tags" field
99 ignore=area,created_by,converted_by,source,time,ele,note,openGeoDB:,fixme,FIXME
100 # uncomment to avoid creation of "other_tags" field
102 # uncomment to create "all_tags" field. "all_tags" and "other_tags" are exclusive
114 # keys to report as OGR fields
116 # keys that should NOT be reported in the "other_tags" field
117 ignore=area,created_by,converted_by,source,time,ele,note,openGeoDB:,fixme,FIXME
118 # uncomment to avoid creation of "other_tags" field
120 # uncomment to create "all_tags" field. "all_tags" and "other_tags" are exclusive