GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register /  [Login] Login 
Messages posted by: akreider  XML
Profile for akreider -> Messages posted by akreider [1]
Author Message
FAQ - frequently asked questions -> Importing the GeoNames Dump into mysql -> Go to message
If you want to save some disk space:

geonameid - can be mediumint (at least I think so, this allows for 8 million ids, or 16 million if you make it positive, whereas geonames is more around 4.5 million)

population - mediumint
altitude - smallint
gtopo30 - smallint

latitude/longitude - probably can be float for most uses (the geonames database isn't that precise)
 
Profile for akreider -> Messages posted by akreider [1]
Go to:   
Powered by JForum 2.1.5 © JForum Team