I have a dataset containing GPS points I store in a table with a geometry column. I use the following code to populate my table.
CREATE TABLE STOPS_GEO (stop_id TEXT PRIMARY KEY,stop_desc TEXT,stop_place TEXT,pole_key TEXT,stop_operator TEXT,stop_lat DOUBLE,stop_lon DOUBLE);SELECT...