load GNIS into sqlite3

gnis.sql

sqlite3 GNIS

create table national (feature_id int, 
                       feature_name varchar(120), 
                       feature_class varchar(50), 
                       state_alpha varchar(2), 
                       state_numeric varchar(2), 
                       county_name varchar(100), 
                       county_numeric varchar(3), 
                       primary_lat_dms varchar(7), 
                       primary_lon_dms varchar(8), 
                       primary_lat_dec real, 
                       primary_lon_dec real, 
                       source_lat_dms varchar(7), 
                       source_lon_dms varchar(8), 
                       source_lat_dec real, 
                       source_lon_dec real, 
                       elevation_meters integer, 
                       elevation_feet integer, 
                       map_name varchar(100),
                       date_created date, 
                       date_edited date);

.import ./NationalFile_20120416.txt national