Created
February 4, 2016 14:51
-
-
Save FlicAnderson/ad44350a62eb017387b6 to your computer and use it in GitHub Desktop.
Show details of FieldRexTemp table information from Padme
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
# open test connection | |
source("O://CMEP\ Projects/Scriptbox/database_connections/function_TESTPadmeArabiaCon.R") | |
TESTPadmeArabiaCon() | |
# get column details for FieldRexTemp table | |
tableDetails <- sqlColumns(con_TESTPadmeArabia, sqtable="FieldRexTemp", errors = FALSE, as.is = TRUE, | |
special = FALSE, catalog = NULL, schema = NULL, | |
literal = FALSE) | |
# show relevant columns | |
tableDetails[,c(4, 5, 6, 7, 8, 12)] | |
# output of table info | |
# COLUMN_NAME DATA_TYPE TYPE_NAME COLUMN_SIZE BUFFER_LENGTH | |
# 1 id 4 COUNTER 10 4 | |
# 2 recID 12 VARCHAR 255 510 | |
# 3 collector 12 VARCHAR 255 510 | |
# 4 collNumFull 12 VARCHAR 50 100 | |
# 5 lnamID 4 INTEGER 10 4 | |
# 6 acceptDetAs 12 VARCHAR 255 510 | |
# 7 acceptDetNoAuth 12 VARCHAR 255 510 | |
# 8 detAs 12 VARCHAR 255 510 | |
# 9 lat1Dir 12 VARCHAR 1 2 | |
# 10 lat1Deg 5 SMALLINT 5 2 | |
# 11 lat1Min 4 INTEGER 10 4 | |
# 12 lat1Sec 4 INTEGER 10 4 | |
# 13 lat1Dec 8 DOUBLE 53 8 | |
# 14 anyLat 4 INTEGER 10 4 | |
# 15 lon1Dir 12 VARCHAR 1 2 | |
# 16 lon1Deg 5 SMALLINT 5 2 | |
# 17 lon1Min 4 INTEGER 10 4 | |
# 18 lon1Sec 4 INTEGER 10 4 | |
# 19 lon1Dec 8 DOUBLE 53 8 | |
# 20 anyLon 4 INTEGER 10 4 | |
# 21 coordSource 4 INTEGER 10 4 | |
# 22 coordAccuracy 4 INTEGER 10 4 | |
# 23 coordAccuracyUnits 12 VARCHAR 50 100 | |
# 24 coordSourcePlus 12 VARCHAR 255 510 | |
# 25 dateDD -6 BYTE 3 1 | |
# 26 dateMM -6 BYTE 3 1 | |
# 27 dateYYYY 4 INTEGER 10 4 | |
# 28 fullLocation -1 LONGCHAR 1073741823 2147483646 | |
# REMARKS | |
# 1 Autroincremented record key | |
# 2 concat of letter determining record source & that table ID | |
# 3 String of collector name | |
# 4 Concatenation of the prefix, collection number and postfix | |
# 5 Foreign key pointing to a record key in the Latin Names table showing the determination of the field note [LnSy].[id] | |
# 6 Accepted Determination with authority [LnSy].[Full Name] | |
# 7 Accepted Determination [LnSy].[sortName] | |
# 8 Original determination string [Lnam].[Full Name] | |
# 9 N or S of the equator | |
# 10 Degrees latitude of the collecting location | |
# 11 Minutes latitude of the collection location | |
# 12 Seconds latitude of the collection location | |
# 13 Decimal representation of the latitude of collection | |
# 14 <NA> | |
# 15 E or W of the Greenwich meridian | |
# 16 Degrees longitude of the collecting location | |
# 17 Minutes longitude of the collecting location | |
# 18 Seconds longitude of the collecting location | |
# 19 Decimal representation of the longitude of collection | |
# 20 <NA> | |
# 21 Foreign key pointing pointing to type of source for the coordinates of the field note | |
# 22 Indication of the accuracy of the coordinates | |
# 23 Units of the accuracy measure | |
# 24 <NA> | |
# 25 Calendar day of the collecting date | |
# 26 Calendar month of the collecting date | |
# 27 Calendar year of the collecting date | |
# 28 The full string of the location chain - [Geog].[fullName] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment