GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Database dump format  XML
Forum Index -> FAQ - frequently asked questions
Author Message
michael.couck



Joined: 26/04/2011 21:48:39
Messages: 2
Offline

Hello,

I am trying to import the database dump(dump_postgres_openstreetmap_allcountries_v2, dump_localhost_street.sql) into the database but I can't make out what the 'location' field is. Please could someone post the database schema(preferably in sql format) and or tell me what the location field is, looks like hex with a leading padding of some kind. I am guessing that this is the lat long no? My db is db2 as an aside and I am using Java.

Thanks in advance,
Cheers,
Michael
marc



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

It doesn't seem those files are related with geonames.

Marc

[WWW]
michael.couck



Joined: 26/04/2011 21:48:39
Messages: 2
Offline

Hi Marc,

Thanks for that, yes, I think that they are from the GisGraphy database, but they are much larger, 45 gig, which is nice. I think I'll just stick with the allCountries.txt and related data for now.

Thanks again,
Have a fantastic day,
Cheers,
Michael
 
Forum Index -> FAQ - frequently asked questions
Go to:   
Powered by JForum 2.1.5 © JForum Team