Continental and marine habitat for diadromous Fishes in Europe, United States and Canadian East coast. These files contain the referentials for river, lakes and catchments from hydrosheds, plus referentials based on hydroshed and ICES and GFCM referentials in the marine area to describe a hierarchy of habitats, for ICES diadromous fish working groups WGNAS, WGBAST and WGEEL. The main product is table ref.tr_area_area which contains the code for all working groups. It can be downloaded as excel, shapefile, parquet file (in refnas, refbast, refeel.zip) or best postgres file. The table contains two geometry columns as the reference area can be a stock unit, or country, or EMU (eel management unit), or basin and in this case it is a polygon (column geom_polygon), but it can correpond to a river segment, and in that case it's a line (column geom_line). For that reason, parquet file is incomplete (no rivers) and we have downloaded two shapefile, ref_tr_area_are_geom_polyon_shp.zip exports the polygons, ref_tr_area_are_geom_line_shp.zip it export the line. Otherwise the two tables are identicaL. Finally the content of the file without geometry can be downloaded as an excel file ref.tr_area_are.xlsx .Please have a look in our report to understand what we have done.VersionsVersion 0.0.5 (March 2026) (THIS RELEASE)Added shapefile with both polygon and linesAdded excel table of ref.tr_area_area the common vocab for the three working groupsVersion 0.0.4 (March 2026) Added excel file with named rivers (WGNAS, WGBAST)Version 0.0.3 (March 2026)fixed issue of corrupted format when trying to restore files (for gpc files) tested on server postgres 17.0Version 0.0.2 (January 2026)  fixed geometry format in parquet for lakesVersion 0.0.1 (December 2025)Eventual structural modifications depending on feedback from WGNAS and WGBASTAdding referential table for WGEELVersion 0.0.1-beta (July 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 vocabulariesVersion 0.0.1-pre-beta (mid June 2025)Adding referential tables for hierarchical structureStructure for WGBAST and WGNASVersion 0.0.1-alpha (mid February 2025)Alpha release for view and test by DIASPARAwork here : Git issue using the hydroshedsDownload postgres databaseIf 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 we assume that the user you are using to postgrescreatedb -U postgres diasparapsql -U postgres diasparaThis 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.You will probably want to create roles, if not it's not a problem you'll get some warnings that grants were not created for this userCREATE ROLE diaspara_admin;CREATE ROLE diaspara_read;You need to have these schema ready to restore the content of some tablesCREATE SCHEMA ref;CREATE SCHEMA refeel;CREATE SCHEMA refnas;CREATE SCHEMA refbast;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 filesIf you want to restore everything in one go use :pg_restore -U postgres -f all_habitat.pgc This will restore all schemas for different ICES areas plus the habitat tables in schema ref, refbast, refnas and refeelIf you are just interested in a limited set of areas :The first file to restore is habitat. This is necessary as all tables inherit from habitat.pg_restore -U postgres -f habitat.pgc Then if for instance if you want to use h_med_central.pgc use :pg_restore -U postgres -f h_med_central.pgc all_ref.gpc contains the code for schema ref, refnas, refeel, refbast (habitats for the three working groups) :Download Parquet format You can use the files straight from R or Qgis. To use with R you will need Arrow and DuckDB packages.TutorialsIf you need any help to use those, please see the webinar videos and presentation documents that can be found here.Project pagehttps://diaspara.bordeaux-aquitaine.inrae.frSpecific work done by WP3 can be found here.Description and details about the creation of the Habitat Database can be found here.Acknowlegmenthydrosheds :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

Continental and marine habitat for diadromous Fishes in Europe, United States and Canadian East coast. These files contain the referentials for river, lakes and catchments from hydrosheds, plus referentials based on hydroshed and ICES and GFCM referentials in the marine area to describe a hierarchy of habitats, for ICES diadromous fish working groups WGNAS, WGBAST and WGEEL. VersionsVersion 0.0.2 (January 2026) (THIS RELEASE)  fixed geometry format in parquet for lakesVersion 0.0.1 (December 2025)Eventual structural modifications depending on feedback from WGNAS and WGBASTAdding referential table for WGEELVersion 0.0.1-beta (July 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 vocabulariesVersion 0.0.1-pre-beta (mid June 2025)Adding referential tables for hierarchical structureStructure for WGBAST and WGNASVersion 0.0.1-alpha (mid February 2025)Alpha release for view and test by DIASPARAwork here : Git issue using the hydrosheds 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 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 Parquet format You can use the files straight from R or Qgis. To use with R you will need Arrow and DuckDB packages.TutorialsIf you need any help to use those, please see the webinar videos and presentation documents that can be found here.Project pagehttps://diaspara.bordeaux-aquitaine.inrae.frSpecific work done by WP3 can be found here.Description and details about the creation of the Habitat Database can be found here.Acknowlegmenthydrosheds :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

Continental and marine habitat for diadromous Fishes in Europe, United States and Canadian East coast. These files contain the referentials for river, lakes and catchments from hydrosheds, plus referentials based on hydroshed and ICES and GFCM referentials in the marine area to describe a hierarchy of habitats, for ICES diadromous fish working groups WGNAS, WGBAST and WGEEL.VersionsVersion 0.0.3 (march 2026) (THIS RELEASE)fixed issue of corrupted format when trying to restore files (for gpc files) tested on server postgres 17.0Version 0.0.2 (January 2026)  fixed geometry format in parquet for lakesVersion 0.0.1 (December 2025)Eventual structural modifications depending on feedback from WGNAS and WGBASTAdding referential table for WGEELVersion 0.0.1-beta (July 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 vocabulariesVersion 0.0.1-pre-beta (mid June 2025)Adding referential tables for hierarchical structureStructure for WGBAST and WGNASVersion 0.0.1-alpha (mid February 2025)Alpha release for view and test by DIASPARAwork here : Git issue using the hydroshedsDownload postgres databaseIf 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 we assume that the user you are using to postgrescreatedb -U postgres diasparapsql -U postgres diasparaThis 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.You will probably want to create roles, if not it's not a problem you'll get some warnings that grants were not created for this userCREATE ROLE diaspara_admin;CREATE ROLE diaspara_read;You need to have these schema ready to restore the content of some tablesCREATE SCHEMA ref;CREATE SCHEMA refeel;CREATE SCHEMA refnas;CREATE SCHEMA refbast;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 filesIf you want to restore everything in one go use :pg_restore -U postgres -f all_habitat.pgc This will restore all schemas for different ICES areas plus the habitat tables in schema ref, refbast, refnas and refeelIf you are just interested in a limited set of areas :The first file to restore is habitat. This is necessary as all tables inherit from habitat.pg_restore -U postgres -f habitat.pgc Then if for instance if you want to use h_med_central.pgc use :pg_restore -U postgres -f h_med_central.pgc all_ref.gpc contains the code for schema ref, refnas, refeel, refbast (habitats for the three working groups) :Download Parquet format You can use the files straight from R or Qgis. To use with R you will need Arrow and DuckDB packages.TutorialsIf you need any help to use those, please see the webinar videos and presentation documents that can be found here.Project pagehttps://diaspara.bordeaux-aquitaine.inrae.frSpecific work done by WP3 can be found here.Description and details about the creation of the Habitat Database can be found here.Acknowlegmenthydrosheds :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

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 (July 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 vocabulariesVersion 0.0.1 (November 2025)Eventual structural modifications depending on feedback from WGNAS and WGBASTAdding referential table for WGEELDownload 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 Parquet format You can use the files straight from R or Qgis. To use with R you will need Arrow and DuckDB packages.TutorialsIf you need any help to use those, please see the webinar videos and presentation documents that can be found here.Project pagehttps://diaspara.bordeaux-aquitaine.inrae.frSpecific work done by WP3 can be found here.Acknowlegmenthydrosheds :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

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 (July 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 vocabulariesVersion 0.0.1 (November 2025)Eventual structural modifications depending on feedback from WGNAS and WGBASTAdding referential table for WGEELDownload 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 Parquet format You can use the files straight from R or Qgis. To use with R you will need Arrow and DuckDB packages.TutorialsIf you need any help to use those, please see the webinar videos and presentation documents that can be found here.Project pagehttps://diaspara.bordeaux-aquitaine.inrae.frSpecific work done by WP3 can be found here.Acknowlegmenthydrosheds :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

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

versionsVersion 0.0.1-beta  (mid fébruary 2025)Beta release for view and test by DIASPARAwork here : Git issue using the hydroshedsVersion 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-HydroDownload 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

VersionsVersion 0.0.1 (December 2025) (THIS RELEASE)Eventual structural modifications depending on feedback from WGNAS and WGBASTAdding referential table for WGEELVersion 0.0.1-beta (July 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 vocabulariesVersion 0.0.1-pre-beta (mid June 2025)Adding referential tables for hierarchical structureStructure for WGBAST and WGNASVersion 0.0.1-alpha (mid February 2025)Alpha release for view and test by DIASPARAwork here : Git issue using the hydrosheds 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 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 Parquet format You can use the files straight from R or Qgis. To use with R you will need Arrow and DuckDB packages.TutorialsIf you need any help to use those, please see the webinar videos and presentation documents that can be found here.Project pagehttps://diaspara.bordeaux-aquitaine.inrae.frSpecific work done by WP3 can be found here.Description and details about the creation of the Habitat Database can be found here.Acknowlegmenthydrosheds :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