DIASPARA - Habitat database

versionsVersion 0.0.1-alpha (mid February 2025)Alpha release for view and test by DIASPARAwork here : Git issue using the hydroshedsVersion 0.0.1-pre-beta (mid June 2025)Adding referential tables for hierarchical structureStructure for WGBAST and WGNASVersion 0.0.1-beta (June 2025)Beta release for view and test by DIASPARA and WORKING GROUPS.Integration with migdb vocabulary.Starting the integration of specific tables.Adding names to rivers corresponding to ICES vocabulariesDownload postgres database#If you don't have postgres, download it, make sure to use the stackbuilder program to download postgis.# open a shell with command CMD# Move to the place where you have downloaded the file using the following command cd c:/path/to/my/folder# note psql must be accessible, in windows you can add the path to the postgres #bin folder, otherwise you need to add the full path to the postgres bin folder see link to instructions below #below I assume that the user you are using to postgres createdb -U postgres diasparapsql -U postgres diaspara# this will open a command with # where you can launch the following SQL commandCREATE EXTENSION postgis;# You will need this because we only restore part of the database : the schema corresponding to different locations.# Type \q to quit the psql program.Now you will have saved the files in the c:/path/to/my/folder location where you are currently working.You need to use pg_restore to restore the files, for instance if you want to use h_med_central.pgcpg_restore -U postgres -f h_med_central.pgc Download Arrow format You can use the files straight from R or Qgishydrosheds :Linke, S., Lehner, B., Ouellet Dallaire, C., Ariwi, J., Grill, G., Anand, M., Beames, P., Burchard-Levine, V., Maxwell, S., Moidu, H., Tan, F., Thieme, M. (2019). Global hydro-environmental sub-basin and river reach characteristics at high spatial resolution. Scientific Data 6: 283. doi: https://doi.org/10.1038/s41597-019-0300-6EU-hydro:European Environment Agency (2020).EU-Hydro River Network Database 2006-2012 (vector), Europe - version 1.3, Nov. 2020.https://doi.org/10.2909/393359a7-7ebd-4a52-80ac-1a18d5f3db9c