Last modified: 2009-07-22 19:52:38 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T21668, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 19668 - Support local names in our PostGIS schema
Support local names in our PostGIS schema
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
SlippyMaps (Other open bugs)
unspecified
All All
: Normal enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
http://wiki.openstreetmap.org/wiki/Re...
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-07-11 23:14 UTC by Ævar Arnfjörð Bjarmason
Modified: 2009-07-22 19:52 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments
Presumably this is the sort of change we need to make to default.style, untested (641 bytes, patch)
2009-07-11 23:15 UTC, Ævar Arnfjörð Bjarmason
Details

Description Ævar Arnfjörð Bjarmason 2009-07-11 23:14:36 UTC
When we render maps with mapnik it's going to be neat to render them in the local language depending on what wiki we're on.

To do this we need to make the required changes at the PostGIS level (see URL).

By default the PostGIS schema only imports one tag as "name". This gives most priority to the name=* tag which will override any name tag that has an attached language code, e.g. name:de=* or name:is=*

So before we do a PostGIS import we need to edit the default.style file with the name tags we want to have added, and then create views for the planet for each language (see URL again).
Comment 1 Ævar Arnfjörð Bjarmason 2009-07-11 23:15:40 UTC
Created attachment 6324 [details]
Presumably this is the sort of change we need to make to default.style, untested

Untested patch with the changes I *guess* are needed to default.style to make this happen.
Comment 2 Ævar Arnfjörð Bjarmason 2009-07-12 22:06:00 UTC
(In reply to comment #1)
> Created an attachment (id=6324) [details]
> Presumably this is the sort of change we need to make to default.style,
> untested
> 
> Untested patch with the changes I *guess* are needed to default.style to make
> this happen.

This works:

gis=> select name, "name:is", "name:de", "name:zh" from planet_osm_point where "name:de" != '' limit 1;
  name  | name:is | name:de | name:zh
--------+---------+---------+---------
 Ísland | Ísland  | Island  | 冰岛
(1 row)
Comment 3 Ævar Arnfjörð Bjarmason 2009-07-21 11:38:55 UTC
There's now a script to create all these views: http://svn.wikimedia.org/viewvc/mediawiki/trunk/tools/osm-tools/osm2pgsql-style/create-language-views.pl?view=markup
Comment 4 Ævar Arnfjörð Bjarmason 2009-07-22 19:52:38 UTC
This is now live and all the software to create the database views / mapnik stylesheets has been written, see the osm-tools directory:

http://svn.wikimedia.org/viewvc/mediawiki/trunk/tools/osm-tools/

And this blawg post:

http://www.openstreetmap.org/user/%C3%86var%20Arnfj%C3%B6r%C3%B0%20Bjarmason/diary/7180

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links