Newer
Older
osmCoverage / src / osmCoverage.style
yuu on 30 Mar 2019 9 KB 2019-03-30
# 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   abandoned:amenity   text  linear
node,way   demolished:amenity  text  linear
node,way   disused:amenity     text  linear
node,way   removed:amenity     text  linear
node,way   historic:amenity    text  linear
node,way   no:amenity   text         linear
node,way   was:amenity  text         linear
#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,way   bus          text         linear
#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   fixme        text         linear
#node,way   foot         text         linear
#node,way   generator:source    text  linear
#node,way   harbour      text         polygon
node   highway      text         linear
node   abandoned:highway   text  linear
node   demolished:highway  text  linear
node   disused:highway     text  linear
node   removed:highway     text  linear
node   no: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         linear
#node,way   place        text         polygon
#node,way   population   text         linear
#node,way   power        text         polygon
#node,way   power_source text         linear
node   public_transport text         linear
node   disused:public_transport   text   linear
node   abandoned:public_transport text   linear
node   demolished:public_transport text  linear
node   no:public_transport        text   linear
#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 # 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: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