Creating database using geonames dump

mdhaman — GMT

I am creating GeoNames database using database dump. I have gone thru quite a few post regarding using database dump as well. Our database is SQL SERVER 2005. I want to confirm the format of Admin1 code, Admin2 code and feature code used in the dump files so that I can setup primary keys and foriegn keys in my database Admin1 Code: Format is :. CountryCode - is same as CountryCode field in the Geoname dump file and Iso Field in the CountryInfo.txt file Admin1Code - this code is unique for a country Admin2 Code: Format:.. CountryCode - is same as CountryCode field in the Geoname table and Iso Field in the CountryInfo.txt file Admin1Code - this code is unique for a country Admin2Code - this code is unique for a Admin1Code Are there any dump files for Admin3Code and Admin4Code?

Re:Creating database using geonames dump

marc — GMT

You don't need any dump files for adm codes. All information is included in the main dump file (including adm3 and adm4 codes). If you want to use fk's for the admin codes you will first have to delete the orphaned codes. We have preferred to not deleted the orphaned codes as they still contain valuable information, even if it is obsolete and refers to a previous adm division, but as long as the new and correct adm code has not been determined we keep the old one as a reference. Marc

Latest posts for the topic "Creating database using geonames dump"

Creating database using geonames dump

Re:Creating database using geonames dump