DIASPARA - Habitat database

versions

Version 0.0.1-beta  (mid fébruary 2025)

• Beta release for view and test by DIASPARA
• work here : Git issue using the hydrosheds

Version 0.0.1-alpha  (August 2025)

• Alpha release for view and test by DIASPARA and WORKING GROUPS.
• Integration with migdb vocabulary.
• Starting the integration of specific tables.
• Integration of EU-Hydro

Download 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 diaspara
psql -U postgres diaspara
# this will open a command with # where you can launch the following SQL command
CREATE 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.pgc

pg_restore -U postgres -f h_med_central.pgc 

Download Arrow format 

You can use the files straight from R or Qgis

hydrosheds :

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-6

EU-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