258 lines
9.8 KiB
Plaintext
258 lines
9.8 KiB
Plaintext
# 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
|