Wikipedia Diskussion:WikiProjekt Georeferenzierung/Hauptseite/Wikipedia-World/en

aus Wikipedia, der freien Enzyklopädie
Zur Navigation springen Zur Suche springen

Extension to which languages ?[Quelltext bearbeiten]

5. extension of the database for more than 11 languages. Which ones?

May I suggest dawiki. We have just launched a project that aims to add coordinates to our articles. --C960657@dawiki
Ok, your language is registered for the next extension. Kolossos 08:24, 16. Mär. 2007 (CET)
itwiki? We are one of the +100.000 articles wiki :) 12:26, 1. Aug. 2007 (CEST)
At itwiki we have a statistic: [1] so because we can not read italiano, we only see with 49398 usages for really interesting, unfourtunally this looks old, not linked to geohack and so not proved. This was the reason for not reading itwiki. Now we could also read Template:Geobox_coordinate_comuni, but will this give us enough new informations in relation to the work? Or do you have other templates we should use? Kolossos 14:58, 1. Aug. 2007 (CEST)
Actually they had left the old Geobox for the Coord template. See here.Rufus T. Firefly 18:47, 4. Aug. 2007 (CEST)
Is there any way to add ukwiki to the list of processed wikis? We might have a bit of georeferenced articles. Thanks--Victor Anyakin 10:41, 28. Feb. 2010 (CET)

I hope so that I can do it in the next weeks but we will see how the database react with so many languages. Do you know the locateCoord-Tool from dispenser? It work's in uk-wikipedia. --Kolossos 23:10, 28. Feb. 2010 (CET)

Vielen Dank! I hope that the ukwiki contribution will not be that large to make a DB server cry. I did not know about locateCoord tool, thanks.--Victor Anyakin 13:59, 1. Mär. 2010 (CET)

Commons images layer[Quelltext bearbeiten]

Could a layer be made out of Commons images in the style Google Earth is doing with Panoramio images? There are now thousands of files in Commons:Category:Media with locations, tagged with the usual templates. --Para 16:17, 17. Mär. 2007 (CET)

Do you know commons:Commons:Geotraging? There is a visualisation tool. We have a problem to ranking images, on articles we can count the letters, but what can we do on images? An other problem is to handle the images. Kolossos 19:55, 17. Mär. 2007 (CET)
You probably mean Commons:Commons:Geocoding, featuring Dschwen's WikiMiniAtlas? As great an example as it is of a project built from scratch using free material, I prefer the Google Earth interface. I think all images deserve to be plotted. With Google Earth, the program takes care of busy areas and doesn't show everything from further away. The criteria for which images are shown at first seems to be rather random though. If it can be controlled and if it's really necessary, Commons images could be ranked by things like inclusion in Commons:Category:Featured pictures, Commons:Category:Quality Images, Commons:Category:Pictures of the day, by having been chosen in a Commons gallery, or maybe even by date of upload. Would it be possible to make a quick and simple kml from the dumps to see how much ranking is needed?
Handling images shouldn't be a problem: they can be plotted as icons such as Commons-logo.svg, and the description can link to the images inline using thumb.php. Credit and license could be mentioned in the description if we choose to parse that from the data as well, or the page could be thought of as just another Wikimedia project, where credit and license can be seen by clicking on the image. --Para 21:28, 17. Mär. 2007 (CET)

Of course, I mean Ceocoding. You can ask Benutzer:Dschwen for the datas. My problem in Google Earth is, that when I use:


it works fine, but if I use:


I get a mistake. So I think I must encrypt the path to the thumb-file and thats not so easy. You can try your luck and take the SQL-file from this project, there we also save the name of the first image in each article. So I also what a solution in the past but without luke.... Kolossos 23:16, 17. Mär. 2007 (CET)

Thanks, you bring me to an idea to use wget and thumb.php to solve the problem. So I can use an other server and don't loading the Commons-Server too much. Kolossos 11:13, 18. Mär. 2007 (CET)
I parsed the commons dump myself and made a quick KML from the decimal coordinates: commons-20070224-geoloc-dec.kmz. It seems to work alright, though there are many maps which I doubt many people are interested of, plus I didn't bother converting the other coordinate types. To make this useful for photo traveling, we'd have to split them in folders based on some categories. Have to talk to Dschwen about that then.
There seems to indeed be a problem with using the & character in KML files; I tried to replace it with different entities but nothing worked. That's not a problem in the descriptions however, since they are just HTML.
If we can make this work, it's probably best to make the feeds on the toolserver, since then the filepath of the files can be found from the toolserver database and we won't need thumb.php anymore. --Para 13:26, 18. Mär. 2007 (CET)
It looks nice. I hope you have more time from experiments than I in the moment. I think the problem is not so the "&" its more the "*.php" so I believe Google Earth see this and think that it couldn't be a picture (security risk). For more than 10.000 entries I believe, it's better to use database and networklinks, should I send you some source-code of my Networklink-solution? Than you should send me a short E-Mail. Kolossos 17:03, 18. Mär. 2007 (CET)
I just parsed the rest of the templates using Geohack, and there's only about 3000 placemarks in the last Commons dump (commons-20070224-geoloc.kmz). But when tagging gets popular, there will no doubt be much more than there are geocoded Wikipedia articles. I can start looking at the dynamic version, alright. The category separation especially is intriguing; I was browsing the images through Google Earth and there are some that in my opinion should not by tagged, but you never know, there's always someone who wants to see them there. --Para 23:01, 18. Mär. 2007 (CET)

There we go, the above issues have been solved and everything's working fine. Geocoded Commons images are now visible on GeoCommons. Thanks for all your help! --Para 03:16, 1. Mai 2007 (CEST)

Dynamic layer is out[Quelltext bearbeiten]

Since 2 days the php for the dynamic layer is out. Can you fix it, please? Thanks 14:09, 27. Mär. 2007 (CEST)

It works on my computer, please try: and open it in Google Earth, then you have thumbnails and you can change the language. I will check it. Kolossos 15:44, 27. Mär. 2007 (CEST)

Yeah, this works also in other languages, but removing the thumbs no yet. 18:39, 27. Mär. 2007 (CEST)
is not running? I tested it under Linux and Windows, on Google Earth 4 and it works. Whats your GoogleEarth version? Or do you get a error-message, which could help? Kolossos 21:01, 27. Mär. 2007 (CEST)

Excuse me, but it seems that the problem was due by an external advise blocker program. Now it works. Thanks for the fast reply, BTW

No, problem. Kolossos 08:33, 28. Mär. 2007 (CEST)

Geo microformat[Quelltext bearbeiten]


Are you going to be using the geo microformat? Please see Project Microformats for details of how it is being deployed on on Wikipedia-EN. I'm happy to advise further if needed. Pigsonthewing 17:01, 31. Mär. 2007 (CEST)

Co-ordinate templates[Quelltext bearbeiten]

Can someone confirm which templates are used to extract co-ordinate information from the dumps. I presume that {{coor}} is used, but are any other templates extracted? Apologies for my lack of Deutsch. 19:56, 10. Apr. 2007 (CEST)

A similar question: How/when is the database updated from Wikipedia? In other words, if I add a {{coor}} tag to an article, when can I expect it to turn up in Google Earth? 15:19, 24. Jun. 2007 (CEST)

Lists of coordinate templates in each wiki is available from en:Category:Coordinates templates and its interwiki links. The supported and recommended ones are mentioned in geographical coordinate project pages or style manuals.
Databases for services outside Wikipedia are updated using the database dumps at, which are updated every few months. The services update their data from those when they notice a new dump available and parse it into their systems. With Google Earth for example, the previous update was in January-Februray this year, according to tests on the English Wikipedia. Google themselves say it's one to three months. --Para 15:41, 24. Jun. 2007 (CEST)

Icons/Colors/Font size[Quelltext bearbeiten]

It is not better if we have different colors and placemarks for different sectors? I mean, landmarks have still the same color (orange) and icon (flag) also if they are taken from different sectors (military, cave...). I suggest to differentiate them more (ie. military landmarks could have swords or similar).

Another strange thing is having the states' name which are smaller than cities' name: it is against the standard cartography style... 12:26, 1. Aug. 2007 (CEST)

I know that we can better in this part of the work, but we are a little bit dependent from the google earth icons, which are more useful for commercial usage (no swords). Free icons are rare. At the end of (it needs a little bit time to load) you can see which types we extract with the help of categories and so on. If you really want to help us, I can give you my styles and you can try to create a new skin. --Kolossos 14:58, 1. Aug. 2007 (CEST)
Yeah, I supposed this. But I remember are the famfamfam icons ( and . If you give to me also some instructions for schema, I can try something but I don`t promise any result :) I can try to change something on standard GE icons, but we can modify and use them? 16:10, 1. Aug. 2007 (CEST)
I'm looking for some thing like commons:Category:Simple_map_icons but in better quality. With Inkscape and much time it shouldn't be a problem to create such. To change GE-icons and use them on toolserver is absolute not allowed on meta:toolserver. --Kolossos 17:14, 2. Aug. 2007 (CEST)
What about font symbols (like Windows Wingding?). Probably on there is some useful one. 17:39, 2. Aug. 2007 (CEST)

Another thing that I don't understand is how the articles are shown: I mean that several times there are first cities ones and after country/administrative divisions ones. And this is incoherent, IMHO. (As you can see, I had made an account!)Rufus T. Firefly 16:05, 3. Aug. 2007 (CEST)

The articles are filtered according to the articles length, this is neccessary because 2 reasons: in english it is difficult to extract good populations values and it is difficult to decide what's a important landmark, for instance a airport or a church? So the base of the used method is, that about a important thing the people write more than about unimportant thing and it is easy because I have only look at one value with is easy to extract. Incoherent is the result, but I don't see a big problem there. (Thanks for your account, it is better than to talk with IP.) --Kolossos 17:16, 3. Aug. 2007 (CEST)
Another one could be the linked pages to the article, I think. In this way things like Germany will probably be more important than Berlin. Now if you take articles' lenght you will have more articles on german related thing, instead a more normalized parameter.Rufus T. Firefly 17:47, 3. Aug. 2007 (CEST)

I tested different ways of sorting on persons:

and you can also testing it on which works with links, against my, perhaps you have right. But it is also nice effect that a user get the bgger articles, so he think that Wikipedia is greater than it is. ;-) --Kolossos 20:59, 3. Aug. 2007 (CEST)

With speedblue (on enwiki) Germany has 67939, Berlin 10568; Italy 50373, Rome 13347 and Verona 803. It seems that it works. And important articles are usually divided on subpages, and then their lenght is less than other. :p Ah, I'm still waiting for style experiment and a reply about itwiki enclousure.Rufus T. Firefly 23:44, 3. Aug. 2007 (CEST)

The new version of GoogleEarth changed the icons' template, and now more of the placemarks are wrong. It's time to update the style (and probably make it better :) )Rufus T. Firefly 21:28, 22. Aug. 2007 (CEST)

Thank you for this information. It's real google bullshit. So it makes real work, I must do the next days. It would be a good moment for using free icons. But we have not enouth. --Kolossos 23:19, 22. Aug. 2007 (CEST)
  1. If you demand a contribution on deviantart or similar site? I think that there are more persons which can made them in very less time.
  2. seems to be a good resource in order to have the inline article preview. I had not take a look inside the rules/functions, but it should be under CC.
  3. It's time to put itwiki on the database: it uses the standard Coord template ;)
  4. If you want to give to me the style in order to take a look on it, I will be happy. If you want some contacts (email, chat) I'm here. Rufus T. Firefly 10:40, 23. Aug. 2007 (CEST)

Possible icons link[Quelltext bearbeiten]

for 4. you can read the styles: Landmarks and buildings are the bigest problems in the moment, I think. --Kolossos 19:41, 23. Aug. 2007 (CEST)

Balloons[Quelltext bearbeiten]

I found this really interesting, in order to have the image thumbnail and a better visualization. 16:10, 1. Aug. 2007 (CEST)

How about the Wikimedia Commons images in Google Earth layer? --Para 22:16, 1. Aug. 2007 (CEST)
I think, the ballons would make my program much more complex. So I love the internal browser, one click away. But ok in my ballon have some points (types and images), which only interesting for develeper, I will remove this and add some "Follow the link to the hole article:". Would this be ok? --Kolossos 17:21, 2. Aug. 2007 (CEST)
(@ IP: Do you have tested: Thumbs-expert-mode ? )

Yeah, I had tried it but having much images is too hurting, IMHO. Then having them on balloons should be a better solution, I think. And having the category of article is a good thing, do not remove it. 17:36, 2. Aug. 2007 (CEST)

Thanks for the idea with the ballons, now I integrate a thumb, which was really easy, with complex I mean a short abstact like in googles wikipedia layer. --Kolossos 21:47, 2. Aug. 2007 (CEST)
Well, I suspect that is not really simple :) 10:28, 3. Aug. 2007 (CEST)

.kml translation[Quelltext bearbeiten]

In Viquiprojecte Coordenades geogràfiques (code written there) we are wondering if .kml file could be uploaded with the few English text translated to the different languages (Wikimedia server doesn't let us upload files with this extension). Llull 16:43, 4. Aug. 2007 (CEST)

Update from French Wikipedia[Quelltext bearbeiten]


On the French Wikipedia, we have recently re-worked the coordinate system by using a new unified template, fr:Template:Coord. It is now used on more than 50000 articles, and a few thousand articles still use the old templates, which are being replaced.

I'm wondering if this has any effect on Wikipedia-World ? Currently the box on top-right says only 894 articles are being indexed on the French Wikipedia or 67768 "with duplicates" (what does it mean ?). I would be interested to know if this has changed. Thanks ! fr:User:Korrigan 23:19, 18. Sep. 2007 (CEST)

At the next update in November we will try to use your coordinates. In the moment Stefan Kühn has much to work do. The "with duplicates" comes from the interwikilinks so we use german or english coordinates with french articles. --Kolossos 21:21, 26. Sep. 2007 (CEST)
Thanks for your answer. I thought coordinates were regularly pulled from the database (like the search engine which uses "incremental index updating". But I understand this is not easy task. Thanks for developing all these tools, by the way :-) (fr:User:Korrigan) 01:17, 27. Sep. 2007 (CEST)

itwiki![Quelltext bearbeiten]

itWiki has reached 350,000 articles and its coordinates database is still out from this project. Since it use the last Coord template, it's time to include it. Rufus T. Firefly 17:27, 23. Sep. 2007 (CEST)

At the next update in November we will try to integrate your coordinates. Sorry for the late answer. --Kolossos 21:22, 26. Sep. 2007 (CEST)

Deum gratias! :p Rufus T. Firefly 21:39, 28. Sep. 2007 (CEST)

Postcodes / Zip Codes[Quelltext bearbeiten]

I notice that many locations on wikipedia include postcodes or zip codes. Though these vary in approach. For instance, articles for Australian and US locations use the full codes, while UK locations use the area parts of the postcode which link to other wiki pages detailing the members of that area part, so this request may not be that feasible for all instances. But as geocodes for postcodes are sought after data, would it be possible to include postcodes that a location is within in the sql output file, assuming that the data is available? Benutzer:

Postcodes are not part of this project. But you can look at Wikipedia:WikiProjekt_Vorlagenauswertung/en whre we extracted the datas of Infoboxes and all templates, i.e. --Kolossos 11:21, 5. Jan. 2008 (CET)

Parser source code[Quelltext bearbeiten]

I would like to have the source code for the parser that does the data extraction from the dumps and static layer. Is this available somewhere? Thanks. --en:User:Drh08 16:00, 18 Feb. 2008 (CET)

Let choose the icons[Quelltext bearbeiten]

The code should let choose the icons. It could be very useful, for example for marking the underground stations with a different icon each line. 12:28, 22. Mär. 2008 (CET)

The first problem I see that we have not saved the diferent underground lines in the database. What to do with station with more than one line? The last question would be, how to save the customers label styles? But if you want you can downloads the data and try our luck and develop such an interesting application. --Kolossos 14:21, 22. Mär. 2008 (CET)
A station with more than one line could use an image made for this station that include the two icons. I have no idea about software development but I think this feature could be great. 20:17, 7. Apr. 2008 (CEST)

Updates to the sql dump files?[Quelltext bearbeiten]

I apologize if I'm not doing this correctly, I only speak english but I can't seem to edit this page on a non-german wikipedia site =]

I was wondering if the data for the sql database is regularly updated and if so, are the dump files available on the article page also updated regularly?

Secondly, I see there are a lot of KMZ files available, however, there doesn't seem to be a way to simply query for articles near a given lat/long and recieve a geo-rss feed of results (say the closest 25). Does anyone know of something like this that is publicly available? If not, im considering working on it as a project which is why I was wondering if there the database is regularly updated.

Thanks! Aroon aroon at nospam pure imaginary dot com

Sorry for the late answer. Yes the SQL dump is also updating regularly. For a simple output you can look at umkreis.php -table. Or you write a little bit more in which format you want the export(example) and for what usage. You can get also get access to the database over a toolserver account. --Kolossos 20:40, 4. Mai 2008 (CEST)

Template:GeoGroupTemplate[Quelltext bearbeiten]

I am trying to use the en:Template:GeoGroupTemplate and it works just fine on the article page with the coordinate listing. I asked a query on the talk page about using the list on one article, and the maps on a different article, and was replied to but I don't understand still. Usage of geogroup template on one page, listing on separate page The article North Sea is very long. I would like a geographical features map on the page using coordinates so the places are rather precise on the map of the North Sea, so the coordinates are all listed at Geography of the North Sea and the geogroup template there is awesome. Just need it at North Sea as well. Also asked at Wikipedia:Village pump (technical) Thank you SriMesh 03:37, 6. Dez. 2008 (CET)

I don't believe that we could help you. --Kolossos 09:53, 6. Dez. 2008 (CET)
Thank you. It has now been resolve. On the talk page of the template, it refers here. Kind Regards SriMesh 05:43, 7. Dez. 2008 (CET)

Suggestion for a new tool: Misplaced coordinates spotter[Quelltext bearbeiten]

Thanks to the interwiki links, this tool would take the coordinates of an object as described on several wikipedias, calculate the center of mass, and compare each point to check whether it is completely out (more than X kilometers from the center of mass).

100 kilometers might be a good value for X. One may argue that for instance Brazil is such a large object that 100 kilometers is not enough. Let's say there are 1000 such large objects, and now compare with the 100000 or so geolocalized objects: that's 0.1% of all. I bet the proportion of false positives will be low. Does not matter much anyway because the potentially misplaced articles will be checked and fixed by humans.

What do you think about it ? Thanks! Nicolas1981 12:16, 27. Dez. 2008 (CET)

It would also help spot erroneous interwikis, like when two different villages with the same name are erroneously interwikied. Nicolas1981 08:52, 28. Dez. 2008 (CET)

Data license[Quelltext bearbeiten]

I would like to use the database dump for creating a data set used in an application I am writting. What is the license for this data? MochDove 06:02, 10. Okt. 2009 (CEST)

Surely they are now CC-BY-SA so you could use it like OpenStreetMap datas. If this not possible in your application please call me again. --Kolossos 09:52, 10. Okt. 2009 (CEST)
Thank you for answering my question. MochDove 17:02, 10. Okt. 2009 (CEST)

Search problem[Quelltext bearbeiten]

Any idea why the search tool doesn't work for a search for 'Bristol'? Its coordinates are in place. I just want Bristol, the city, and with the exact page name as I typed, to be at the top of the list.

Where does the database data come from?[Quelltext bearbeiten]

I'm sorry, I don't understand. I can see lots of locations in the SQL dump files.

1) But where do they come from?

2) Is this related to DBpedia?

3) Is it related to this page?:,-0.933838&spn=2.709621,8.453979&z=8 (If not, then where does data in that page come from?)

English page on German Wikipedia?[Quelltext bearbeiten]

Why is the English page here and not on en:Wikipedia:WikiProject Geographical coordinates. Matthias 18:39, 11. Jul. 2010 (CEST) Because I can have it on my watchlist and can gibe you a faster response. --Kolossos 09:37, 12. Jul. 2010 (CEST)

Database dumps[Quelltext bearbeiten]

1) What is the different between the two files pub_C_geo_id.csv.gz and wp_coords_red0.csv.gz ? 2) How will it be created, and when?

Higher definition image[Quelltext bearbeiten]

Hey! Thanks for this project! It's really useful to see where are all the coordinates we have in wikipedia in a map. (this one). But the problem is that it has no definition. Where could I find a better one with more definition? Thank you! --Catalaalatac 11:54, 26. Jan. 2011 (CET)

The pixel is lit if there are any coordinates in the area. You can see the effect by changing fa. The highest I've been able to get was fa=26 (9360x 4860). Dispenser 17:57, 5. Aug. 2011 (CEST)

wikifa[Quelltext bearbeiten]

Hi, according to this wikifa has 13626 pages that they used coord template but in your chart wikifa has 3712 used coord template. which one is correct?Reza1615 23:40, 2. Jun. 2011 (CEST)

Coordinates from ro.wp[Quelltext bearbeiten]

Hi Kolossos. Would it be possible to obtain acces to the database for wikipedia world, or at least an sql dump with coordinates extracted from ro.wp? Also, in what whay is this different from pub_C_geo_id, in u_kolossos_geo_p? Thanks.--Strainu 00:11, 10. Dez. 2011 (CET)

Hi Kolossus. Thanks for running the wikipedia-world service: it's very useful as a source of data for cross-language geotagging, and I appreciate your work on it greatly. Can you tell me if there is any prospect of another SQL dump in the near future? Ideally, to save on people asking you for dumps repeatedly, could there be some way this could be provided via the web as an automated service from the toolserver, without needing to get a toolserver account? -- The Anome 15:21, 15. Feb. 2012 (CET)

Google Maps Wikipedia masking[Quelltext bearbeiten]

I don't understand this. Does it mean that we can somehow see geocordinates from non-en wikis (ex de or pl) on Google Maps? If so, how? All I get at [2] is a German language google serch box that I have no idea how to use further. PS. Please copy any reply to my talk, I am not watching this page - thanks. --Piotrus (Diskussion) 15:17, 22. Jul. 2013 (CEST)

Licence of OpenStreetMap[Quelltext bearbeiten]


on OpenStreetMap hosted on toolserver is mentioned CC0 licence (public domain). But the OpenStreetMap is licenced by ODbL licence. Can someone please repair this? Thanks! :-) Xkomczax (Diskussion) 22:47, 25. Nov. 2013 (CET)

Rendering of objects on toolserver's version of OpenStreetMap[Quelltext bearbeiten]

One more thing: on OpenStreetMap hosted on toolserver are some important things missing. A lot of landuse=forest is missing (for instance here - but are present on "normal" OSM) as well as some other elements, which are on the map for a very long time (= there is no problem with fresh data). Can somebody have a look?

Thank you

Xkomczax (Diskussion) 22:54, 25. Nov. 2013 (CET)

Procedure for adding more wikipedias as sources[Quelltext bearbeiten]

There are more wikipedias than the ones listed as sources here. Some of these have will have templates with coordinates as well. What procedure is in place to add the information in these wikipedias? In my particualr case: How will the information in make it to the map? Mysha (Diskussion)

Mistakes[Quelltext bearbeiten]

When mistakes are encountered in the represented data - most likely incorrectly placed links on maps - what's the procedure for getting them corrected? Mysha (Diskussion)