Colin Marquardt schrieb:
2009/8/13 Aude <aude.wiki(a)gmail.com>om>:
The osm planet needs to be re-imported into the
mapnik PostgresSQL database,
with the intarray (_int.sql) module enabled on the gis database before doing
the import.
Right, this is already necessary because the hourly osc files don't
reach back so far into the past, even if it wasn't for the intarray
module.
I have mentioned this before but do it again to prevent hours of
importing time being wasted:
please bear in mind that in order to support alternative map styles,
osm2pgsql's default.style file will need to be extended. I.e. this is
the one needed for the hike & bike map:
http://mapnik-utils.googlecode.com/svn/sandbox/cascadenik/hike_n_bike/defau…
alt_name/old_name etc. would need to be in there as well.
Thanks for working on this.
Cheers
Colin
Hi Colin
i combined the wikimedia.style with your hike_n_bike.style and some of
the alternatice name-tags and attached it. I think that the more of the
existing data of osm is in the db, the more useful will it be for
experiments, trying new things etc.
Peter
# This is the style file that matches the old version of osm2pgsql, which
# did not make distinctions between tags for nodes and for ways. There are a
# number of optimisations that can be applied here. Firstly, certain tags
# only apply to only nodes or only ways. By fixing this we reduce the amount
# of useless data loaded into the DB, which is a good thing. Possible
# optimisations for the future:
# 1. Generate this file directly from the mapnik XML config, so it's always
# optimal
# 2. Extend it so it can understand that highway=tertiary is for ways and
# highway=bus_stop is for nodes
# Flags field isn't used much yet, expect if it contains the text
"polygon"
# it indicates the shape is candidate for the polygon table. In the future I
# would like to be able to add directives like "nocache" which tells
# osm2pgsql that it is unlikely this node will be used by a way and so it
# doesn't need to be stored (eg coastline nodes). While in essence an
# optimisation hack, for --slim mode it doesn't matter if you're wrong, but
# in non-slim you might break something!
# Also possibly an ignore flag, for things like "note" and "source"
which
# can simply be deleted. (In slim mode this is, does not apply to non-slim
# obviously)
# OsmType Tag DataType Flags
node,way note text delete # These tags can be long but are useless for
rendering
node,way source text delete # This indicates that we shouldn't store
them
node,way access text linear
node,way addr:flats text polygon
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 nocache,polygon
node,way area text # hard coded support for area=1/yes => polygon is
in osm2pgsql
node,way barrier text linear
node,way bicycle text nocache
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 cutting text linear
node,way disused text linear
node ele text linear
node,way embankment text linear
node,way foot text linear
node,way highway text linear
node,way historic text polygon
node,way horse text linear
node,way junction text linear
node,way landuse text polygon
node,way layer text linear
node,way learning 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
##################################################################################
# This is a list of 278 languages for which we want to gather the name:lang tags #
##################################################################################
# name= is the generic fallback
node,way name text linear
# aa (Qafár af)
node,way name:aa text linear
# ab (Аҧсуа)
node,way name:ab text linear
# af (Afrikaans)
node,way name:af text linear
# ak (Akan)
node,way name:ak text linear
# als (Alemannisch)
node,way name:als text linear
# am (አማርኛ)
node,way name:am text linear
# an (Aragonés)
node,way name:an text linear
# ang (Anglo-Saxon)
node,way name:ang text linear
# ar (العربية)
node,way name:ar text linear
# arc (ܐܪܡܝܐ)
node,way name:arc text linear
# arz (مصرى)
node,way name:arz text linear
# as (অসমীয়া)
node,way name:as text linear
# ast (Asturianu)
node,way name:ast text linear
# av (Авар)
node,way name:av text linear
# ay (Aymar aru)
node,way name:ay text linear
# az (Azərbaycan)
node,way name:az text linear
# ba (Башҡорт)
node,way name:ba text linear
# bar (Boarisch)
node,way name:bar text linear
# bat-smg (Žemaitėška)
node,way name:bat-smg text linear
# bcl (Bikol Central)
node,way name:bcl text linear
# be (Беларуская)
node,way name:be text linear
# be-x-old (Беларуская (тарашкевіца))
node,way name:be-x-old text linear
# bg (Български)
node,way name:bg text linear
# bh (भोजपुरी)
node,way name:bh text linear
# bi (Bislama)
node,way name:bi text linear
# bm (Bamanankan)
node,way name:bm text linear
# bn (বাংলা)
node,way name:bn text linear
# bo (བོད་ཡིག)
node,way name:bo text linear
# bpy (ইমার ঠার/বিষ্ণুপ্রিয়া মণিপুরী)
node,way name:bpy text linear
# br (Brezhoneg)
node,way name:br text linear
# bs (Bosanski)
node,way name:bs text linear
# bug (ᨅᨔ ᨕᨘᨁᨗ)
node,way name:bug text linear
# bxr (Буряад)
node,way name:bxr text linear
# ca (Català)
node,way name:ca text linear
# cbk-zam (Chavacano de Zamboanga)
node,way name:cbk-zam text linear
# cdo (Mìng-dĕ̤ng-ngṳ̄)
node,way name:cdo text linear
# ce (Нохчийн)
node,way name:ce text linear
# ceb (Cebuano)
node,way name:ceb text linear
# ch (Chamoru)
node,way name:ch text linear
# cho (Choctaw)
node,way name:cho text linear
# chr (ᏣᎳᎩ)
node,way name:chr text linear
# chy (Tsetsêhestâhese)
node,way name:chy text linear
# closed-zh-tw ()
node,way name:closed-zh-tw text linear
# co (Corsu)
node,way name:co text linear
# cr (Nēhiyawēwin / ᓀᐦᐃᔭᐍᐏᐣ)
node,way name:cr text linear
# crh (Qırımtatarca)
node,way name:crh text linear
# cs (Česky)
node,way name:cs text linear
# csb (Kaszëbsczi)
node,way name:csb text linear
# cu (Словѣ́ньскъ / ⰔⰎⰑⰂⰡⰐⰠⰔⰍⰟ)
node,way name:cu text linear
# cv (Чӑвашла)
node,way name:cv text linear
# cy (Cymraeg)
node,way name:cy text linear
# cz ()
node,way name:cz text linear
# da (Dansk)
node,way name:da text linear
# de (Deutsch)
node,way name:de text linear
# diq (Zazaki)
node,way name:diq text linear
# dk (Dansk (deprecated:da))
node,way name:dk text linear
# dsb (Dolnoserbski)
node,way name:dsb text linear
# dv (ދިވެހިބަސް)
node,way name:dv text linear
# dz (ཇོང་ཁ)
node,way name:dz text linear
# ee (Eʋegbe)
node,way name:ee text linear
# el (Ελληνικά)
node,way name:el text linear
# eml (Emiliàn e rumagnòl)
node,way name:eml text linear
# en (English)
node,way name:en text linear
# eo (Esperanto)
node,way name:eo text linear
# epo ()
node,way name:epo text linear
# es (Español)
node,way name:es text linear
# et (Eesti)
node,way name:et text linear
# eu (Euskara)
node,way name:eu text linear
# ext (Estremeñu)
node,way name:ext text linear
# fa (فارسی)
node,way name:fa text linear
# ff (Fulfulde)
node,way name:ff text linear
# fi (Suomi)
node,way name:fi text linear
# fiu-vro (Võro)
node,way name:fiu-vro text linear
# fj (Na Vosa Vakaviti)
node,way name:fj text linear
# fo (Føroyskt)
node,way name:fo text linear
# fr (Français)
node,way name:fr text linear
# frp (Arpetan)
node,way name:frp text linear
# fur (Furlan)
node,way name:fur text linear
# fy (Frysk)
node,way name:fy text linear
# ga (Gaeilge)
node,way name:ga text linear
# gan (贛語)
node,way name:gan text linear
# gd (Gàidhlig)
node,way name:gd text linear
# gl (Galego)
node,way name:gl text linear
# glk (گیلکی)
node,way name:glk text linear
# gn (Avañe'ẽ)
node,way name:gn text linear
# got (𐌲𐌿𐍄𐌹𐍃𐌺)
node,way name:got text linear
# gu (ગુજરાતી)
node,way name:gu text linear
# gv (Gaelg)
node,way name:gv text linear
# ha (هَوُسَ)
node,way name:ha text linear
# hak (Hak-kâ-fa)
node,way name:hak text linear
# haw (Hawai`i)
node,way name:haw text linear
# he (עברית)
node,way name:he text linear
# hi (हिन्दी)
node,way name:hi text linear
# hif (Fiji Hindi)
node,way name:hif text linear
# ho (Hiri Motu)
node,way name:ho text linear
# hr (Hrvatski)
node,way name:hr text linear
# hsb (Hornjoserbsce)
node,way name:hsb text linear
# ht (Kreyòl ayisyen)
node,way name:ht text linear
# hu (Magyar)
node,way name:hu text linear
# hy (Հայերեն)
node,way name:hy text linear
# hz (Otsiherero)
node,way name:hz text linear
# ia (Interlingua)
node,way name:ia text linear
# id (Bahasa Indonesia)
node,way name:id text linear
# ie (Interlingue)
node,way name:ie text linear
# ig (Igbo)
node,way name:ig text linear
# ii (ꆇꉙ)
node,way name:ii text linear
# ik (Iñupiak)
node,way name:ik text linear
# ilo (Ilokano)
node,way name:ilo text linear
# io (Ido)
node,way name:io text linear
# is (Íslenska)
node,way name:is text linear
# it (Italiano)
node,way name:it text linear
# iu (ᐃᓄᒃᑎᑐᑦ/inuktitut)
node,way name:iu text linear
# ja (日本語)
node,way name:ja text linear
# jbo (Lojban)
node,way name:jbo text linear
# jp ()
node,way name:jp text linear
# jv (Basa Jawa)
node,way name:jv text linear
# ka (ქართული)
node,way name:ka text linear
# kaa (Qaraqalpaqsha)
node,way name:kaa text linear
# kab (Taqbaylit)
node,way name:kab text linear
# kg (Kongo)
node,way name:kg text linear
# ki (Gĩkũyũ)
node,way name:ki text linear
# kj (Kwanyama)
node,way name:kj text linear
# kk (Қазақша)
node,way name:kk text linear
# kl (Kalaallisut)
node,way name:kl text linear
# km (ភាសាខ្មែរ)
node,way name:km text linear
# kn (ಕನ್ನಡ)
node,way name:kn text linear
# ko (한국어)
node,way name:ko text linear
# kr (Kanuri)
node,way name:kr text linear
# ks (कश्मीरी - (كشميري))
node,way name:ks text linear
# ksh (Ripoarisch)
node,way name:ksh text linear
# ku (Kurdî / كوردی)
node,way name:ku text linear
# kv (Коми)
node,way name:kv text linear
# kw (Kernewek)
node,way name:kw text linear
# ky (Кыргызча)
node,way name:ky text linear
# la (Latina)
node,way name:la text linear
# lad (Ladino)
node,way name:lad text linear
# lb (Lëtzebuergesch)
node,way name:lb text linear
# lbe (Лакку)
node,way name:lbe text linear
# lg (Luganda)
node,way name:lg text linear
# li (Limburgs)
node,way name:li text linear
# lij (Líguru)
node,way name:lij text linear
# lmo (Lumbaart)
node,way name:lmo text linear
# ln (Lingála)
node,way name:ln text linear
# lo (ລາວ)
node,way name:lo text linear
# lt (Lietuvių)
node,way name:lt text linear
# lv (Latviešu)
node,way name:lv text linear
# map-bms (Basa Banyumasan)
node,way name:map-bms text linear
# mdf (Мокшень)
node,way name:mdf text linear
# mg (Malagasy)
node,way name:mg text linear
# mh (Ebon)
node,way name:mh text linear
# mhr (Олык Марий)
node,way name:mhr text linear
# mi (Māori)
node,way name:mi text linear
# minnan ()
node,way name:minnan text linear
# mk (Македонски)
node,way name:mk text linear
# ml (മലയാളം)
node,way name:ml text linear
# mn (Монгол)
node,way name:mn text linear
# mo (Молдовеняскэ)
node,way name:mo text linear
# mr (मराठी)
node,way name:mr text linear
# ms (Bahasa Melayu)
node,way name:ms text linear
# mt (Malti)
node,way name:mt text linear
# mus (Mvskoke)
node,way name:mus text linear
# my (မြန်မာဘာသာ)
node,way name:my text linear
# myv (Эрзянь)
node,way name:myv text linear
# mzn (مَزِروني)
node,way name:mzn text linear
# na (Dorerin Naoero)
node,way name:na text linear
# nah (Nāhuatl)
node,way name:nah text linear
# nan (Bân-lâm-gú)
node,way name:nan text linear
# nap (Nnapulitano)
node,way name:nap text linear
# nb (Norsk (bokmål))
node,way name:nb text linear
# nds (Plattdüütsch)
node,way name:nds text linear
# nds-nl (Nedersaksisch)
node,way name:nds-nl text linear
# ne (नेपाली)
node,way name:ne text linear
# new (नेपाल भाषा)
node,way name:new text linear
# ng (Oshiwambo)
node,way name:ng text linear
# nl (Nederlands)
node,way name:nl text linear
# nn (Norsk (nynorsk))
node,way name:nn text linear
# no (Norsk (bokmål))
node,way name:no text linear
# nomcom ()
node,way name:nomcom text linear
# nov (Novial)
node,way name:nov text linear
# nrm (Nouormand)
node,way name:nrm text linear
# nv (Diné bizaad)
node,way name:nv text linear
# ny (Chi-Chewa)
node,way name:ny text linear
# oc (Occitan)
node,way name:oc text linear
# om (Oromoo)
node,way name:om text linear
# or (ଓଡ଼ିଆ)
node,way name:or text linear
# os (Иронау)
node,way name:os text linear
# pa (ਪੰਜਾਬੀ)
node,way name:pa text linear
# pag (Pangasinan)
node,way name:pag text linear
# pam (Kapampangan)
node,way name:pam text linear
# pap (Papiamentu)
node,way name:pap text linear
# pdc (Deitsch)
node,way name:pdc text linear
# pi (पािऴ)
node,way name:pi text linear
# pih (Norfuk / Pitkern)
node,way name:pih text linear
# pl (Polski)
node,way name:pl text linear
# pms (Piemontèis)
node,way name:pms text linear
# pnt (Ποντιακά)
node,way name:pnt text linear
# ps (پښتو)
node,way name:ps text linear
# pt (Português)
node,way name:pt text linear
# qu (Runa Simi)
node,way name:qu text linear
# rm (Rumantsch)
node,way name:rm text linear
# rmy (Romani)
node,way name:rmy text linear
# rn (Kirundi)
node,way name:rn text linear
# ro (Română)
node,way name:ro text linear
# roa-rup (Armãneashce)
node,way name:roa-rup text linear
# roa-tara (Tarandíne)
node,way name:roa-tara text linear
# ru (Русский)
node,way name:ru text linear
# rw (Kinyarwanda)
node,way name:rw text linear
# sa (संस्कृत)
node,way name:sa text linear
# sah (Саха тыла)
node,way name:sah text linear
# sc (Sardu)
node,way name:sc text linear
# scn (Sicilianu)
node,way name:scn text linear
# sco (Scots)
node,way name:sco text linear
# sd (سنڌي)
node,way name:sd text linear
# se (Sámegiella)
node,way name:se text linear
# sg (Sängö)
node,way name:sg text linear
# sh (Srpskohrvatski / Српскохрватски)
node,way name:sh text linear
# si (සිංහල)
node,way name:si text linear
# simple (Simple English)
node,way name:simple text linear
# sk (Slovenčina)
node,way name:sk text linear
# sl (Slovenščina)
node,way name:sl text linear
# sm (Gagana Samoa)
node,way name:sm text linear
# sn (chiShona)
node,way name:sn text linear
# so (Soomaaliga)
node,way name:so text linear
# sq (Shqip)
node,way name:sq text linear
# sr (Српски / Srpski)
node,way name:sr text linear
# srn (Sranantongo)
node,way name:srn text linear
# ss (SiSwati)
node,way name:ss text linear
# st (Sesotho)
node,way name:st text linear
# stq (Seeltersk)
node,way name:stq text linear
# su (Basa Sunda)
node,way name:su text linear
# sv (Svenska)
node,way name:sv text linear
# sw (Kiswahili)
node,way name:sw text linear
# szl (Ślůnski)
node,way name:szl text linear
# ta (தமிழ்)
node,way name:ta text linear
# te (తెలుగు)
node,way name:te text linear
# tet (Tetun)
node,way name:tet text linear
# tg (Тоҷикӣ)
node,way name:tg text linear
# th (ไทย)
node,way name:th text linear
# ti (ትግርኛ)
node,way name:ti text linear
# tk (Türkmençe)
node,way name:tk text linear
# tl (Tagalog)
node,way name:tl text linear
# tn (Setswana)
node,way name:tn text linear
# to (lea faka-Tonga)
node,way name:to text linear
# tokipona (Toki Pona)
node,way name:tokipona text linear
# tp (Toki Pona (deprecated:tokipona))
node,way name:tp text linear
# tpi (Tok Pisin)
node,way name:tpi text linear
# tr (Türkçe)
node,way name:tr text linear
# ts (Xitsonga)
node,way name:ts text linear
# tt (Tatarça/Татарча)
node,way name:tt text linear
# tum (chiTumbuka)
node,way name:tum text linear
# tw (Twi)
node,way name:tw text linear
# ty (Reo Mā`ohi)
node,way name:ty text linear
# udm (Удмурт)
node,way name:udm text linear
# ug (Uyghurche / ئۇيغۇرچە)
node,way name:ug text linear
# uk (Українська)
node,way name:uk text linear
# ur (اردو)
node,way name:ur text linear
# uz (O'zbek)
node,way name:uz text linear
# ve (Tshivenda)
node,way name:ve text linear
# vec (Vèneto)
node,way name:vec text linear
# vi (Tiếng Việt)
node,way name:vi text linear
# vls (West-Vlams)
node,way name:vls text linear
# vo (Volapük)
node,way name:vo text linear
# wa (Walon)
node,way name:wa text linear
# war (Winaray)
node,way name:war text linear
# wo (Wolof)
node,way name:wo text linear
# wuu (吴语)
node,way name:wuu text linear
# xal (Хальмг)
node,way name:xal text linear
# xh (isiXhosa)
node,way name:xh text linear
# yi (ייִדיש)
node,way name:yi text linear
# yo (Yorùbá)
node,way name:yo text linear
# za (Vahcuengh)
node,way name:za text linear
# zea (Zeêuws)
node,way name:zea text linear
# zh (中文)
node,way name:zh text linear
# zh-cfr ()
node,way name:zh-cfr text linear
# zh-classical (文言)
node,way name:zh-classical text linear
# zh-min-nan (Bân-lâm-gú)
node,way name:zh-min-nan text linear
# zh-yue (粵語)
node,way name:zh-yue text linear
# zu (isiZulu)
node,way name:zu text linear
node,way natural text polygon # natural=coastline tags are discarded by a
hard coded rule in osm2pgsql
node,way oneway text linear
node poi text
node,way power text polygon
node,way power_source text linear
node,way place text linear
node,way railway text linear
node,way ref text linear
node,way religion text nocache
node,way residence text linear
node,way route text linear
node,way service text linear
node,way sport text polygon
node,way tourism text polygon
way tracktype text linear
node,way tunnel text linear
node,way waterway 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 # This is calculated during import
# If you're interested in bicycle routes, you may want the following fields
# To make these work you need slim mode or the necessary data won't be 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 symbol text linear
way osmc:symbol text linear
way marked_trail text linear
way network text linear
way surface text linear
node,way importance real
node,way fee text linear
way lanes int4 linear
node,way information text linear
node,way shop text linear
node,way path text linear
node,way tower text linear
node,way lit text linear
# some more names that could be used for localized rendering and other experiments
node,way alt_name text linear
node,way old_name text linear
node,way official_name text linear
node,way loc_name text linear
node,way nick_name text linear