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