back to first page [[..]]
[[PageOutline]]
* [#CONNEXION Connexion scripts]
* [#STRUCTURE SIBIC data structure]

= The SIBIC database =
http://www.sibic.org/

== Related tickets ==
#86 and #94

== Connexion scripts ==
[=#CONNEXION]
ODBC connexions have been set up to connect to the SIBIC. [[BR]]
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]] 
They are different:  https://robertoschiabel.wordpress.com/2008/02/28/windows-x64-32bit-odbc-vs-64bit-odbc/

You can find the code in: source:/eda/sudoang/SIBIC.R​ 

== SIBIC data structure ==
[=#STRUCTURE]
[[Image(source:eda/data/Docs/trac/sudoang/location_diagram.png,500px)]]


=== Location ===
||codhb||
||subbassin||
||stretch_place||
||place_classification||
||responsible_entity||
||regional_delegation||
||human_intervention_pt||
||human_intervention_es||
||fishing_level||
||coordenadasXX||
||coordenadasYY||
||locationid||
||ES||
||PT||
||Gen_fishing_level||
||medium_number_of_eggs||
||Gen_place_classification||
||idref||
||spec_loc_id||
||Observaciones||
||s_Generation||
||s_GUID||

Notes: "place_classification" indicates the code of the station inherited from the primary resources.


=== Hydrobass ===
||codhb||
||HydrographicBasin_PT||
||HydrographicBasin_ES||
||s_Generation||
||s_GUID||
||ES||
||PT||

Notes: there is a problem with the assignment of the country (HydrographicBasin_PT and HydrographicBasin_ES).


=== Species_Location ===
||locationid||
||codspecies||
||capture_date||
||capture_year||
||abundance_order||
||Time1||
||Time2||
||Time3||
||Run1||
||Run2||
||Run3||
||length||
||width||
||Area||
||ind/ha||
||ind/hour||
||abundance_CPUE||
||unit_CPUE||
||efficiency||
||methods||
||s_Generation||
||population_tendencies||
||s_GUID||
||reproduction_season||
||MatSex_male||
||MatSex_female||
||medium_number_of_eggs||
||idref||
||spec_loc_id||

Notes: the format of the most of parameters have to be standardized.