GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Wikipedia association with geonames id  XML
Forum Index -> General Go to Page: 1, 2 Next 
Author Message
round-planet



Joined: 27/07/2006 13:51:26
Messages: 4
Offline

Do you maintain an association between wikipedia articles and GEONames unique ids? Is that something that one can download? If not, can we download the wikipedia articles DB in the same fashion as the placelist database?

Thanks for your great site

visit round-planet: http://www.round-planet.com/fr/diaporama.php3
[WWW]
marc



Joined: 08/12/2005 07:39:47
Messages: 3909
Offline

Hi Round-Planet

Yes, we keep a relation between most of the geo referenced wikipedia articles and the geonames entries. This relation, however, is not available for download. If you need it I can send it to you in an email. You are the first to ask for it and as long as not many others would like to have it, it is less work to send it via email rather than writing code for a daily dump.

Regards,

Marc

[WWW]
Anonymous



Thanks Marc;
yes I'm interested to receive it in eMail, at pascal@round-planet.com.

Regards,
Pascal
Anonymous



Thanks Marc,

I'm interested to receive it in eMail too, at proffnet@proffnet.com.

Regards,
Mariusz
geekeasy



Joined: 13/08/2006 16:27:26
Messages: 11
Offline


I think that had people known such a list existed there would have been a great demand for it.

I'd like a copy too.

Maybe as a compromise to writing a daily dump you could just post a link to what you have now and update it monthly.

Thanks for the great work.
[WWW]
marc



Joined: 08/12/2005 07:39:47
Messages: 3909
Offline

Yes lets try this. The url is here :
http://www.geonames.org/export/wikipedia/wikipedia.zip

Marc

[WWW]
Anonymous



Just wanted to drop in and say that this is useful for me also
samokk



Joined: 13/10/2006 21:56:39
Messages: 82
Offline

Hi,

Hmm, this is a great database ! Not sure what I can use it for, but it's definitely very nice information to have ! Thanks for the dump !

Sami Dalouche
marc



Joined: 08/12/2005 07:39:47
Messages: 3909
Offline

The newest dump is available here:
http://www.geonames.org/export/wikipedia/wikipedia-200803.zip


Marc

[WWW]
AFKYBD



Joined: 19/02/2009 02:10:03
Messages: 6
Offline

Is this updated on a regular basis now? This looks great!
ugo



Joined: 10/06/2008 22:36:21
Messages: 6
Offline

Hello,

Excellent ! I was really looking for something similar.
Would it be possible to obtain a fresh dump please if that's possible ?
Your last one is about 1 year old.

Thanks a lot !

Ugo
ugo



Joined: 10/06/2008 22:36:21
Messages: 6
Offline

Is there relation between a geoname_id and a wikipedia_id ?

From the dump I can see an id linked to an ID from Wikipedia in each available language.
I also can see an id linked to another database with some data like coordinates....

But I can't seem to find a geoname_id.

Is it okay or did I make a mistake ?

Thanks a lot,

Ugo
marc



Joined: 08/12/2005 07:39:47
Messages: 3909
Offline

The geonameid is in the file ds.dmp

Marc

[WWW]
ragrawal



Joined: 08/01/2009 19:55:03
Messages: 7
Offline

how about mapping between gnis and geonames
ugo



Joined: 10/06/2008 22:36:21
Messages: 6
Offline

marc wrote:
The geonameid is in the file ds.dmp

Marc 


Ok thanks, I was confused with the name of the fields !

Would it be possible by any chance to have a fresh dump please ?

Thanks a lot,

Ugo
jellings


[Avatar]

Joined: 01/04/2009 01:55:57
Messages: 1
Offline

Marc

I second the request for an update of the dump. Is this something that others can assist with to make it happen on a regular basis?


Thanks.

John
marc



Joined: 08/12/2005 07:39:47
Messages: 3909
Offline

John

I do it as often as I manage to find the time. Unfortunately it is a real pain as the wikipedia geo-templates are extremely volatile and the wikipedia-contributors cannot agree on a common template. At the contrary, with every run of the parser a great number of articles disappear from the result because the template it has been using has been changed into something new and the parser needs to be adapted to the changed templates. There are literally hundreds or even thousands of competing templates how coordinates can be included in a wikipedia article. It is a real mess.

Marc

[WWW]
tripmondo


[Avatar]

Joined: 19/12/2008 18:53:11
Messages: 7
Offline

Hi there,

I would also be interested in the wiki table. I do use the commercial webservices, but I need to cut down on requests

Not because of credits, but I mash up quite a lot of APIs and it just takes too long to recieve all of them in an acceptable time for the user (even when I try to cache a lot of it).

It is definitely not due to the speed of the commercial geoname webservice (I am very happy with them), but I am looking for ways to replace the one or another webservice with something DB driven.

So, any chance to get a more or less fresh dump?

Thanks in advance
Nils

edit:
@Marc: I can imagine the pain. I am working on an api aggregator, and this can be frustrating sometimes. Parsing that much more or less "unstructured" data must be really hard. From what files to you try to parse the contents. I am interested in a solution to this and want to dig a little deeper into the problem.
jimmyjingers



Joined: 27/10/2009 10:00:56
Messages: 1
Offline

Hi Marc, I'm afraid it's another bump for an update

Quick Q: how come the wiki entries aren't included in the main country data files?

Jimbo.
basovink



Joined: 16/02/2010 22:16:03
Messages: 1
Offline

Another request for the dump. I might even contribute to your favorite 'charity' or help you in some other way, since it will save me some work!
 
Forum Index -> General Go to Page: 1, 2 Next 
Go to:   
Powered by JForum 2.1.5 © JForum Team