Changes between Version 19 and Version 20 of SIBIC database
- Timestamp:
- Oct 26, 2018 9:10:53 AM (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
SIBIC database
v19 v20 1 1 back to first page [[..]] 2 [[PageOutline]] 3 * [#CONNEXION Connexion scripts] 4 * [#STRUCTURE SIBIC data structure] 5 2 6 = The SIBIC database = 3 7 http://www.sibic.org/ 4 8 5 == related tickets ==9 == Related tickets == 6 10 7 #86 , #93and #9411 #86 and #94 8 12 9 = Connexion scripts = 13 == Connexion scripts == 14 [=#CONNEXION] 10 15 11 ODBC connexions have been set up to connect to the SIBIC. This require R 32bits to run via Rterm in eclipse, and setting up and ODBC link in C:\Windows\System32 (not the 64 bit version), they are different https://robertoschiabel.wordpress.com/2008/02/28/windows-x64-32bit-odbc-vs-64bit-odbc/ 16 ODBC connexions have been set up to connect to the SIBIC. [[BR]] 17 This require R 32bits to run via Rterm in eclipse, and setting up and ODBC link in C:\Windows\System32 (not the 64 bit version).[[BR]] 18 They are different: https://robertoschiabel.wordpress.com/2008/02/28/windows-x64-32bit-odbc-vs-64bit-odbc/ 12 19 20 You can find the code in: source:/eda/sudoang/SIBIC.R 13 21 22 == SIBIC data structure == 23 [=#STRUCTURE] 14 24 15 source:/eda/sudoang/SIBIC.R 25 [[Image(source:eda/data/Docs/trac/sudoang/location_diagram.png,500px)]] 16 26 17 = SIBIC data structure = 18 19 [[Image(source:eda/data/Docs/trac/sudoang/location_diagram.png,600px)]] 20 21 == Location == 27 === Location === 22 28 ||codhb|| 23 29 ||subbassin|| … … 43 49 ||s_GUID|| 44 50 45 == Hydrobass==51 === Hydrobass === 46 52 47 53 ||codhb|| … … 53 59 ||PT|| 54 60 55 == Species_Location==61 === Species_Location === 56 62 57 63 ||locationid||