The hydromosaic database stores metadata about modeled stream flow, stream temperature, and oxygen content. The data is in netCDF files, each of which contains multiple timeseries calculated for different stream outlets. This database supports a data server to locate and stream available data for each stream outlet.
It has no geographical data on the locations or upstream/downstream relationships of stream outlets; geography and mapping are handled by a separate database.
Database design is handled with sqlalchemy and alembic. In order to initialize or upgrade a database:
- Install the ORM with
poetry install - Edit the
sqlalchemy.urlline in alembic.ini to a connection string for the database you wish to update - Type
poetry run alembic update headto initialize the database