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)

list_tables_sudoeel.xlsx (23.4 KB) - added by maria 7 years ago.
Summary of the tables compiled for the SUDOEEL project

Download all attachments as: .zip

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

Summary of the tables compiled for the SUDOEEL project

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
Note: See TracTickets for help on using tickets.