| Version 22 (modified by maria, 7 years ago) (diff) |
|---|
back to first page ..
The SIBIC database
Related tickets
Connexion scripts
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/
You can find the code in: source:/eda/sudoang/SIBIC.R
SIBIC data structure
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.
