Query used in Padme Arabia (Access) to create temporary table before running PadmeFielRexCapacityFixQuery.SQL gist (& hence query from script_dataGrabFullLatLonOrGazLatLon_Socotra.R) to get around capacity issues with sqlQuery ODBC drivers

PadmeFieldRexTempCreate.SQL

CREATE TABLE FieldRexTemp
(
id AUTOINCREMENT PRIMARY KEY , 
recID TEXT(10), 
expdID TEXT, 
collector TEXT,
collNumFull TEXT, 
lnamID INTEGER, 
acceptDetAs TEXT,
acceptDetNoAuth TEXT, 
detAs TEXT, 
lat1Dir TEXT(1), 
lat1Deg INTEGER, 
lat1Min INTEGER, 
lat1Sec INTEGER, 
lat1Dec DOUBLE, 
anyLat DOUBLE, 
lon1Dir TEXT(1), 
lon1Deg INTEGER, 
lon1Min INTEGER, 
lon1Sec INTEGER, 
lon1Dec DOUBLE, 
anyLon DOUBLE, 
coordSource INTEGER,
coordAccuracy INTEGER, 
coordAccuracyUnits TEXT, 
coordSourcePlus TEXT, 
dateDD INTEGER, 
dateMM INTEGER, 
dateYYYY INTEGER, 
fullLocation TEXT(255)
)
;