Perceptual Model Database

Perceptual model is defined as:

An expert summary of the watershed and its runoff processes often supported by field observations. Perceptual models are often presented as a schematic figure, although such a figure will necessarily simplify the hydrologist's complex mental model (McMillan et al., 2022)

This repo contains a released version of the perceptual data model database from https://doi.org/10.1002/hyp.14845. Currently our database holds 400 models in both text (269) and figure (131) format collected from hydrologic literature.

Visit the perceptual model interactive map for the visualization 🗺️

Installation/Getting Started

1. Create your environment Use Conda to create an environment

conda env create -f environment.yml

Or use the environment_minimal.yml if it fails.

2. Building the perceptual model database
src/ contains scripts to build the PostgreSQL database based on the raw data in the data directory.
Run the following code in order:

• 0-debug_excelsheets.ipynb
• 1-build_database.ipynb

Create webmap

src/webmap contains example scripts that are used to create the ArcGIS interactive webmap.
To initiate the webmap after building the SQL database:

• Run init_create_webmap.ipynb to initiate a webmap
• Or, run update_webmap.ipynb to update an existing webmap

Other utilities

src/utils contains other utilities:

• calc_stats.sql holds query scripts to calculate statistics used in the paper
• Use debug_built_database.sql to debug the database if the SQL database or code (1-build_database.ipynb) are not working as expected

Resources

• The database design (ER diagram)
• The hydrologic process taxonomy used in the analysis

Contact

We are looking to add more perceptual models to our database and develop better design codes for perceptual models through community effort! Both texts and illustrations are welcome.

• If you find perceptual models to be included in the map or want to discuss the model, contact:
  • Hilary McMillan (hmcmillan (at) sdsu (dot) edu)
• If you have questions about the technical details of the map, contact:
  • Ryoko Araki (raraki8159 (at) sdsu (dot) edu)

Acknowledgement

I appreciate Jessica, Atsushi, and Kyle for helping me with the coding!

Citation

@ARTICLE{McMillan2022,
  title   = {How do hydrologists perceive watersheds? A survey and analysis of perceptual model figures for experimental watersheds},
  author  = {Hilary McMillan and Ryoko Araki and Sebastian Gnann and Ross Woods and Thorsten Wagener},
  journal = {Hydrological Processes},
  doi     = {10.1002/hyp.14845},
  year    = {2022},
  volume  = {37},
  number  = {3},
  pages   = {e14845},
  url     = {https://doi.org/10.1002/hyp.14845}
}