Newer
Older
osmCoverage / src / default.style
@hayashi hayashi on 21 Mar 2018 8 KB add: fuel test
  1. # This is the default osm2pgsql .style file that comes with osm2pgsql.
  2. #
  3. # A .style file has 4 columns that define how OSM objects end up in tables in
  4. # the database and what columns are created. It interacts with the command-line
  5. # hstore options.
  6. #
  7. # Columns
  8. # =======
  9. #
  10. # OsmType: This is either "node", "way" or "node,way" and indicates if this tag
  11. # applies to nodes, ways, or both.
  12. #
  13. # Tag: The tag
  14. #
  15. # DataType: The type of the column to be created. Normally "text"
  16. #
  17. # Flags: Flags that indicate what table the OSM object is moved into.
  18. #
  19. # There are 6 possible flags. These flags are used both to indicate if a column
  20. # should be created, and if ways with the tag are assumed to be areas. The area
  21. # assumptions can be overridden with an area=yes/no tag
  22. #
  23. # polygon - Create a column for this tag, and objects with the tag are areas
  24. #
  25. # linear - Create a column for this tag
  26. #
  27. # nocolumn - Override the above and don't create a column for the tag, but do
  28. # include objects with this tag
  29. #
  30. # phstore - Same as polygon,nocolumn for backward compatibility
  31. #
  32. # delete - Drop this tag completely and don't create a column for it. This also
  33. # prevents the tag from being added to hstore columns
  34. #
  35. # nocache - Deprecated and does nothing
  36. #
  37. # If an object has a tag that indicates it is an area or has area=yes/1,
  38. # osm2pgsql will try to turn it into an area. If it succeeds, it places it in
  39. # the polygon table. If it fails (e.g. not a closed way) it places it in the
  40. # line table.
  41. #
  42. # Nodes are never placed into the polygon or line table and are always placed in
  43. # the point table.
  44. #
  45. # Hstore
  46. # ======
  47. #
  48. # The options --hstore, --hstore-match-only, and --hstore-all interact with
  49. # the .style file.
  50. #
  51. # With --hstore any tags without a column will be added to the hstore column.
  52. # This will also cause all objects to be kept.
  53. #
  54. # With --hstore-match-only the behavior for tags is the same, but objects are
  55. # only kept if they have a non-NULL value in one of the columns.
  56. #
  57. # With --hstore-all all tags are added to the hstore column unless they appear
  58. # in the style file with a delete flag, causing duplication between the normal
  59. # columns and the hstore column.
  60. #
  61. # Special database columns
  62. # ========================
  63. #
  64. # There are some special database columns that if present in the .style file
  65. # will be populated by osm2pgsql.
  66. #
  67. # These are
  68. #
  69. # z_order - datatype int4
  70. #
  71. # way_area - datatype real. The area of the way, in the units of the projection
  72. # (e.g. square mercator meters). Only applies to areas
  73. #
  74. # osm_user - datatype text
  75. # osm_uid - datatype integer
  76. # osm_version - datatype integer
  77. # osm_changeset - datatype integer
  78. # osm_timestamp - datatype timestamptz(0).
  79. # Used with the --extra-attributes option to include metadata in the database.
  80. # If importing with both --hstore and --extra-attributes the meta-data will
  81. # end up in the tags hstore column regardless of the style file.
  82.  
  83. # OsmType Tag DataType Flags
  84. node,way access text linear
  85. node,way addr:housename text linear
  86. node,way addr:housenumber text linear
  87. node,way addr:interpolation text linear
  88. node,way admin_level text linear
  89. node,way aerialway text linear
  90. node,way aeroway text polygon
  91. node,way amenity text polygon
  92. node,way area text polygon # hard coded support for area=1/yes => polygon is in osm2pgsql
  93. node,way barrier text linear
  94. node,way bicycle text linear
  95. node,way brand text linear
  96. node,way bridge text linear
  97. node,way boundary text linear
  98. node,way building text polygon
  99. node capital text linear
  100. node,way construction text linear
  101. node,way covered text linear
  102. node,way culvert text linear
  103. node,way cutting text linear
  104. node,way denomination text linear
  105. node,way disused text linear
  106. node ele text linear
  107. node,way embankment text linear
  108. node,way foot text linear
  109. node,way generator:source text linear
  110. node,way harbour text polygon
  111. node,way highway text linear
  112. node,way historic text polygon
  113. node,way horse text linear
  114. node,way intermittent text linear
  115. node,way junction text linear
  116. node,way landuse text polygon
  117. node,way layer text linear
  118. node,way leisure text polygon
  119. node,way lock text linear
  120. node,way man_made text polygon
  121. node,way military text polygon
  122. node,way motorcar text linear
  123. node,way name text linear
  124. node,way natural text polygon # natural=coastline tags are discarded by a hard coded rule in osm2pgsql
  125. node,way office text polygon
  126. node,way oneway text linear
  127. node,way operator text linear
  128. node,way place text polygon
  129. node,way population text linear
  130. node,way power text polygon
  131. node,way power_source text linear
  132. node,way public_transport text polygon
  133. node,way railway text linear
  134. node,way ref text linear
  135. node,way religion text linear
  136. node,way route text linear
  137. node,way service text linear
  138. node,way shop text polygon
  139. node,way sport text polygon
  140. node,way surface text linear
  141. node,way toll text linear
  142. node,way tourism text polygon
  143. node,way tower:type text linear
  144. way tracktype text linear
  145. node,way tunnel text linear
  146. node,way water text polygon
  147. node,way waterway text polygon
  148. node,way wetland text polygon
  149. node,way width text linear
  150. node,way wood text linear
  151. node,way z_order int4 linear # This is calculated during import
  152. way way_area real linear # This is calculated during import
  153.  
  154. # Area tags
  155. # We don't make columns for these tags, but objects with them are areas.
  156. # Mainly for use with hstore
  157. way abandoned:aeroway text polygon,nocolumn
  158. way abandoned:amenity text polygon,nocolumn
  159. way abandoned:building text polygon,nocolumn
  160. way abandoned:landuse text polygon,nocolumn
  161. way abandoned:power text polygon,nocolumn
  162. way area:highway text polygon,nocolumn
  163.  
  164. # Deleted tags
  165. # These are tags that are generally regarded as useless for most rendering.
  166. # Most of them are from imports or intended as internal information for mappers
  167. # Some of them are automatically deleted by editors.
  168. # If you want some of them, perhaps for a debugging layer, just delete the lines.
  169.  
  170. # These tags are used by mappers to keep track of data.
  171. # They aren't very useful for rendering.
  172. node,way note text delete
  173. node,way note:* text delete
  174. node,way source text delete
  175. node,way source_ref text delete
  176. node,way source:* text delete
  177. node,way attribution text delete
  178. node,way comment text delete
  179. node,way fixme text delete
  180.  
  181. # Tags generally dropped by editors, not otherwise covered
  182. node,way created_by text delete
  183. node,way odbl text delete
  184. node,way odbl:note text delete
  185. node,way SK53_bulk:load text delete
  186.  
  187. # Lots of import tags
  188. # TIGER (US)
  189. node,way tiger:* text delete
  190.  
  191. # NHD (US)
  192. # NHD has been converted every way imaginable
  193. node,way NHD:* text delete
  194. node,way nhd:* text delete
  195.  
  196. # GNIS (US)
  197. node,way gnis:* text delete
  198.  
  199. # Geobase (CA)
  200. node,way geobase:* text delete
  201. # NHN (CA)
  202. node,way accuracy:meters text delete
  203. node,way sub_sea:type text delete
  204. node,way waterway:type text delete
  205.  
  206. # KSJ2 (JA)
  207. # See also note:ja and source_ref above
  208. node,way KSJ2:* text delete
  209. # Yahoo/ALPS (JA)
  210. node,way yh:* text delete
  211.  
  212. # osak (DK)
  213. node,way osak:* text delete
  214.  
  215. # kms (DK)
  216. node,way kms:* text delete
  217.  
  218. # ngbe (ES)
  219. # See also note:es and source:file above
  220. node,way ngbe:* text delete
  221.  
  222. # naptan (UK)
  223. node,way naptan:* text delete
  224.  
  225. # Corine (CLC) (Europe)
  226. node,way CLC:* text delete
  227.  
  228. # misc
  229. node,way 3dshapes:ggmodelk text delete
  230. node,way AND_nosr_r text delete
  231. node,way import text delete
  232. node,way it:fvg:* text delete