Last active
June 8, 2016 10:18
-
-
Save FlicAnderson/9d3790ac037de0d98df8bc634318dacc to your computer and use it in GitHub Desktop.
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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) | |
) | |
; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment