Opened 7 years ago
Closed 5 years ago
#93 closed enhancement (fixed)
Import SIBIC database
Reported by: | cedric | Owned by: | maria |
---|---|---|---|
Priority: | blocker | Milestone: | GT1 Build spatial database |
Component: | GT1 EDA datatool | Version: | EDA2.0 |
Keywords: | Cc: |
Description
Analyse the SIBIC and create a roadmap to integrate it into the dbeel, the code should include components for update/ correction
- station script
- operation scripts
- fish script
Attachments (1)
Change History (5)
comment:1 Changed 7 years ago by cedric
- Owner changed from Maria to maria
- Status changed from new to assigned
Changed 7 years ago by maria
comment:2 Changed 7 years ago by maria
After checking the SIBIC database, there is a lack of information about the identifier that makes the correspondence between the station and the fish operation, as well as the size and the silvering of eels. We are waiting for the databases used to create the SIBIC database.
Meanwhile, we have reviewed several tables that were compiled for the SUDOEEL project, there is no one that can be used as an example because they are lists of available data, but the data is missing. "list_tables_sudoeel" that is attached, has been created to summarize the information of these tables.
comment:3 Changed 7 years ago by maria
We started to integrate electrofishing information of the SIBIC database into the dbeel.
You can find our progress in Import to dbeel
And the code is in the file: source:eda/EDAcommun/sql/sudoang/dbeel_sudoang.sql
comment:4 Changed 5 years ago by cedric
- Resolution set to fixed
- Status changed from assigned to closed
Summary of the tables compiled for the SUDOEEL project