Importing geonames data into Firebird
Created by: Lester Caine, Last modification: 21 Aug 2014 (13:04 UTC)
First cut at schema for geonames table
GEONAMEID BIGINT NOT NULL,
NAME VARCHAR(200) NOT NULL,
ASCIINAME VARCHAR(200),
ALTERNATENAMES BLOB SUB_TYPE 1,
LATITUDE DOUBLE PRECISION,
LONGITUDE DOUBLE PRECISION,
FEATURE_CLASS CHAR(1),
FEATURE_CODE VARCHAR(10),
COUNTRY_CODE CHAR(2),
CC2 VARCHAR(60),
ADMIN1_CODE VARCHAR(20),
ADMIN2_CODE VARCHAR(80),
ADMIN3_CODE VARCHAR(20),
ADMIN4_CODE VARCHAR(20),
POPULATION BIGINT,
ELEVATION INTEGER,
DEM INTEGER,
TIMEZONE VARCHAR(40),
MOD_DATE DATE,
CONSTRAINT PK_GEONAMES PRIMARY KEY (GEONAMEID)
Import via XMLWizard works fine, but need to improve speed when applying updates.