--   export-sqlite-2x-tblGeoStateCA.sql
--   sqlite script to "export" data from MySQL into SQlite
--   n6lhv@arrl.net (Wayne Smith)
--   created:  28-December-2004
--   updated:  27-June-2010



--  Import all of the data

---CREATE TABLE tblGeoStateCA ( frequency_assigned, call_sign, license_status, radio_service_code, class_station_code, location_state, location_county, location_city, location_address, location_name, contact_licensee, entity_name, state, city, street_address, state_code, control_county, control_city, control_address, control_phone, units_temp_fixed, units_mobile );
CREATE TABLE tblGeoStateCA ( frequency_assigned, call_sign, license_status, radio_service_code, class_station_code, location_state, location_county, location_city, location_address, location_name, contact_licensee, entity_name, state, city, street_address, state_code, control_county, control_city, control_address, control_phone, cnt_mobile_units, grant_date, expired_date, cancellation_date, effective_date, last_action_date, unique_system_identifier, ULS_File_Number, ground_elevation, lat_degrees, lat_minutes, lat_seconds, lat_direction, long_degrees, long_minutes, long_seconds, long_direction, frequency_upper_band, frequency_carrier, db_id );
--COPY tblGeoStateCA FROM 'tblGeoStateCA-commadelimited-sqlite.txt' USING DELIMITERS ',';
COPY tblGeoStateCA FROM 'tblGeoStateCA-tabdelimited.txt';
--.import tblGeoStateCA 'tblGeoStateCA-commadelimited.txt' USING DELIMITERS ',';