postgresql - OSM: Import ways without tag using osm2pgsql -
i have special problem when importing osm data osm2pgsql. searching days on how import ways not have tag part of relation (which has tags) postgresdb. take following way example: http://www.openstreetmap.org/way/50126690 can see not have tags part of relation http://www.openstreetmap.org/relation/2 … 81/12.3246 tagged cross country slope. when import data postgresql, way 50126690 not imported. when use --hstore option should keep objects if believe documentation on http://www.volkerschatz.com/net/osm/osm2pgsql-usage.htm way not imported planet_osm_line table. default.style looks that:
# osmtype tag datatype flags node,way access text linear node,way addr:housename text linear node,way addr:housenumber text linear node,way addr:interpolation text linear node,way admin_level text linear node,way aerialway text linear node,way aeroway text polygon node,way amenity text polygon node,way area text polygon # hard coded support area=1/yes => polygon in osm2pgsql node,way barrier text linear node,way bicycle text linear node,way brand text linear node,way bridge text linear node,way boundary text linear node,way building text polygon node capital text linear node,way construction text linear node,way covered text linear node,way culvert text linear node,way cutting text linear node,way denomination text linear node,way disused text linear node ele text linear node,way embankment text linear node,way foot text linear node,way generator:source text linear node,way harbour text polygon node,way highway text linear node,way historic text polygon node,way horse text linear node,way intermittent text linear node,way junction text linear node,way landuse text polygon node,way layer text linear node,way leisure text polygon node,way lock text linear node,way man_made text polygon node,way military text polygon node,way motorcar text linear node,way name text linear node,way natural text polygon # natural=coastline tags discarded hard coded rule in osm2pgsql node,way office text polygon node,way oneway text linear node,way operator text linear node,way place text polygon node poi text linear node,way population text linear node,way power text polygon node,way power_source text linear node,way public_transport text polygon node,way railway text linear node,way ref text linear node,way religion text linear node,way route text linear node,way service text linear node,way shop text polygon node,way sport text polygon node,way surface text linear node,way toll text linear node,way tourism text polygon node,way tower:type text linear way tracktype text linear node,way tunnel text linear node,way water text polygon node,way waterway text polygon node,way wetland text polygon node,way width text linear node,way wood text linear node,way z_order int4 linear # calculated during import way way_area real linear # calculated during import # area tags # don't make columns these tags, objects them areas. # use hstore way abandoned:aeroway text phstore way abandoned:amenity text phstore way abandoned:building text phstore way abandoned:landuse text phstore way abandoned:power text phstore way area:highway text phstore # deleted tags # these tags regarded useless rendering. # of them imports or intended internal information mappers # of them automatically deleted editors. # if want of them, perhaps debugging layer, delete lines. # these tags used mappers keep track of data. # aren't useful rendering. node,way note text delete node,way note:* text delete node,way source text delete node,way source_ref text delete node,way source:* text delete node,way attribution text delete node,way comment text delete node,way fixme text delete # tags dropped editors, not otherwise covered node,way created_by text delete node,way odbl text delete node,way odbl:note text delete node,way sk53_bulk:load text delete # lots of import tags # tiger (us) node,way tiger:* text delete # nhd (us) # nhd has been converted every way imaginable node,way nhd:* text delete node,way nhd:* text delete # gnis (us) node,way gnis:* text delete # geobase (ca) node,way geobase:* text delete # nhn (ca) node,way accuracy:meters text delete node,way sub_sea:type text delete node,way waterway:type text delete # ksj2 (ja) # see note:ja , source_ref above node,way ksj2:* text delete # yahoo/alps (ja) node,way yh:* text delete # osak (dk) node,way osak:* text delete # kms (dk) node,way kms:* text delete # ngbe (es) # see note:es , source:file above node,way ngbe:* text delete # naptan (uk) node,way naptan:* text delete # corine (clc) (europe) node,way clc:* text delete # misc node,way 3dshapes:ggmodelk text delete node,way and_nosr_r text delete node,way import text delete node,way it:fvg:* text delete #openpistemap data activated way piste:lift text linear way piste:lift:occupancy text linear way piste:lift:capacity text linear way piste:lift:duration text linear way piste:type text linear way piste:difficulty text linear way piste:grooming text linear way piste:ref text linear way lit text linear way aerialway:capacity text linear way aerialway:duration text linear way aerialway:heating text linear way aerialway:bubble text linear way aerialway:occupancy text linear node,way information text linear way sac_scale text linear # if you're interested in bicycle routes, may want following fields # make these work need slim mode or necessary data won't remembered. way lcn_ref text linear way rcn_ref text linear way ncn_ref text linear way lcn text linear way rcn text linear way ncn text linear way lwn_ref text linear way rwn_ref text linear way nwn_ref text linear way lwn text linear way rwn text linear way nwn text linear way route_pref_color text linear way route_name text linear way loc_ref text linear way usage text linearcan point me right direction on how import ways??? helping martin
Comments
Post a Comment