Latest posts for the topic "Location vs wiki article for german locations"

Location vs wiki article for german locations

kominstitute — GMT

Hey folks, I stumbled upon your project looking for a way to find Wikipedia Articles for german cities and places which are given by lat/long - so your findNearbyWikipedia service seems perfect for the job. However, as some users before me, I ran into the following problem: When I enter the coordinates for Frankfurt, the service gives me all kinds of articles about things IN Frankfurt, but the main wiki article "Frankfurt am Main" doesn't show up. http://ws.geonames.org/findNearbyWikipedia?lat=50.11678&lng=8.68333&country=de&radius=10&maxRows=20 Now, when I simply search for Frankfurt in the full text search: http://ws.geonames.org/search?name=Frankfurt&maxRows=50&style=full&country=de it does give me (first entry) the geolocation of what I am looking for - unfortunately, without the wiki article URL. There is, however, the geonameID (2925533). Now, at last, my question: Is there a way to infer the wiki article url from that geoNameID? I did see the dump that you uploaded 2 years ago, however, I am not sure if that's going to help. When I search in the ds.dmp file for the above mentioned geoNameID 2925535, it does show up and is connected with another id 526 of type "nameorid". But what is that nameorid field? Any help is appreciated! Thanks! Best Ken

Re:Location vs wiki article for german locations

Coldplay — GMT

The coordinates you are using aren't the ones that Wikipedia has. Not sure if this is the reason, because the server is unavailable at the moment, but when it comes back on (hopefully soon) try using the coordinates as they are specified in the wiki page. 50.110278, 8.682222

Re:Location vs wiki article for german locations

Coldplay — GMT

now that it's up again I checked with the wiki coordinates and he still doesn't give you what u wanted. It happened to me with a differnet page and I got an answer here that the page is probably built a little different than what the parser expects and because of that isn't in their database. sadly...

Location vs wiki article for german locations

marc — GMT

kominstitute wrote:

When I enter the coordinates for Frankfurt, the service gives me all kinds of articles about things IN Frankfurt, but the main wiki article "Frankfurt am Main" doesn't show up. http://ws.geonames.org/findNearbyWikipedia?lat=50.11678&lng=8.68333&country=de&radius=10&maxRows=20

It is record 6 in the returned xml list.

kominstitute wrote:

Now, when I simply search for Frankfurt in the full text search: http://ws.geonames.org/search?name=Frankfurt&maxRows=50&style=full&country=de it does give me (first entry) the geolocation of what I am looking for - unfortunately, without the wiki article URL.

The wikipedia url is there: http://en.wikipedia.org/wiki/Frankfurt Marc

Re:Location vs wiki article for german locations

kominstitute — GMT

Thank you for your replies. I see that the coordinates I am using (I got them from the opengeodb project, because they are quite accurate and easy to use) differ from those given in the wiki articles. I must admit that I am at a loss concerning the best approach. I came up with the following workaround, to describe it I need to add a little more context: My goal is to identify given tags as locations/places/areas. So what I do first is run them through a location database - the opengeodb. From that database, I get possible candidates for the location that the user might refer to, for instance, "Frankfurt" could be "Frankfurt am Main" or "Frankfurt (Oder)" - so I get a list with those candidates, including their lat/long values. Then, my plan was to get the wiki articles of those candidates to compare them (using tf/idf) to the article, that was tagged with the mentioned tags in the first place. However, getting those wiki articles has proven more difficult than I thought: My current workaround does the following: Using the dbpedia lookup service I look for the fulltext name of that place/location that the opengeodb database returns, check the results for all place/location/area types, get the dbpedia site, compare those lat/long values with the ones from opengeodb, if it's a match, I get the wiki URL. However, as mentioned, those coordinates hardly match. Thus, If I could have used the findNearbyWikipedia service, it would have helped a lot - but the coord mismatch problem remains. Using that opengeodb seems to be a bad idea now that I see that problem, however, it offers the most reliable data (Rationale: What's not in the opengeodb is not a location - finito), whereas Wikipedia/dbpedia offer articles about things/persons that have the same name, but are not locations (e.g. offenbach (location) vs. jacques offenbach (classic musician etc). I am absolutely open to any suggestions - In fact, I'd be very grateful! Best Ken