Colin Marquardt schrieb:
2009/8/13 Aude aude.wiki@gmail.com:
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/defaul...
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