# This is the default osm2pgsql .style file that comes with osm2pgsql. # # A .style file has 4 columns that define how OSM objects end up in tables in # the database and what columns are created. It interacts with the command-line # hstore options. # # Columns # ======= # # OsmType: This is either "node", "way" or "node,way" and indicates if this tag # applies to nodes, ways, or both. # # Tag: The tag # # DataType: The type of the column to be created. Normally "text" # # Flags: Flags that indicate what table the OSM object is moved into. # # There are 6 possible flags. These flags are used both to indicate if a column # should be created, and if ways with the tag are assumed to be areas. The area # assumptions can be overridden with an area=yes/no tag # # polygon - Create a column for this tag, and objects with the tag are areas # # linear - Create a column for this tag # # nocolumn - Override the above and don't create a column for the tag, but do # include objects with this tag # # phstore - Same as polygon,nocolumn for backward compatibility # # delete - Drop this tag completely and don't create a column for it. This also # prevents the tag from being added to hstore columns # # nocache - Deprecated and does nothing # # If an object has a tag that indicates it is an area or has area=yes/1, # osm2pgsql will try to turn it into an area. If it succeeds, it places it in # the polygon table. If it fails (e.g. not a closed way) it places it in the # line table. # # Nodes are never placed into the polygon or line table and are always placed in # the point table. # # Hstore # ====== # # The options --hstore, --hstore-match-only, and --hstore-all interact with # the .style file. # # With --hstore any tags without a column will be added to the hstore column. # This will also cause all objects to be kept. # # With --hstore-match-only the behavior for tags is the same, but objects are # only kept if they have a non-NULL value in one of the columns. # # With --hstore-all all tags are added to the hstore column unless they appear # in the style file with a delete flag, causing duplication between the normal # columns and the hstore column. # # Special database columns # ======================== # # There are some special database columns that if present in the .style file # will be populated by osm2pgsql. # # These are # # z_order - datatype int4 # # way_area - datatype real. The area of the way, in the units of the projection # (e.g. square mercator meters). Only applies to areas # # osm_user - datatype text # osm_uid - datatype integer # osm_version - datatype integer # osm_changeset - datatype integer # osm_timestamp - datatype timestamptz(0). # Used with the --extra-attributes option to include metadata in the database. # If importing with both --hstore and --extra-attributes the meta-data will # end up in the tags hstore column regardless of the style file. # 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 for area=1/yes => polygon is 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 are discarded by a hard coded rule in osm2pgsql node,way office text polygon node,way oneway text linear node,way operator 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 # This is calculated during import way way_area real linear # This is calculated during import # Area tags # We don't make columns for these tags, but objects with them are areas. # Mainly for use with hstore way abandoned:aeroway text polygon,nocolumn way abandoned:amenity text polygon,nocolumn way abandoned:building text polygon,nocolumn way abandoned:landuse text polygon,nocolumn way abandoned:power text polygon,nocolumn way area:highway text polygon,nocolumn # Deleted tags # These are tags that are generally regarded as useless for most rendering. # Most of them are from imports or intended as internal information for mappers # Some of them are automatically deleted by editors. # If you want some of them, perhaps for a debugging layer, just delete the lines. # These tags are used by mappers to keep track of data. # They aren't very useful for 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 generally dropped by 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 also note:ja and 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 also note:es and 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 # from vbn/poi # do not use buildings still in planing phase node,way proposed text linear # consider for bus_stop and railway station comparison node,way railway text linear node,way network text linear # consider for park&ride or bike&ride comparison node,way park_ride text linear node,way bike_ride text linear # consider for ticket office and machine comparison node,way tickets:public_transport text linear node,way vending text linear # consider for poi node,way attraction text polygon node,way healthcare text polygon node,way craft text polygon node,way microbrewery text polygon node,way wikipedia text linear node,way url text polygon #attribut fuer Fahrplaner node,way usage text linear #attribut fuer Fahrplaner node,way information text linear node,way recycling_type text linear node,way phone text linear node,way sport text polygon node,way shop text polygon node,way tourism text polygon node,way addr:city text linear node,way addr:country text linear node,way addr:postcode text linear node,way addr:street text linear node,way website text linear node,way opening_hours text linear node,way contact:phone text linear node,way contact:website text linear node,way social_facility text linear