WaMDaM Controlled Vocabularies                        WaMDaM.org Admin Login

Master Controlled Vocabulary Registry for the
Water Management Data Model (WaMDaM)

This online moderated registry aims to promote consistent terminology (i.e., Controlled Vocabularies-(CVs)) to describe water system components and their attributes across datasets, models, and users, while still retaining the native terms. Registering your model's native terms against these CVs will allow you to relate, query, and compare all of your water management data within a single database.

Click on a collection of terms, then click New in the top left to suggest a new term. Once submitted, we will receive an email of the submission and decide to accept and add as a new vocabulary, or reject it in case it is similar to an existing one. Scroll to the bottom for more info on how to the registry works.


Adel Abdallah, PhD Water Data Exchange Program Manager Western States Water Council adelabdallah@wswc.utah.gov

Controlled Vocabularies

A term for describing the statistical action used to calculate over recorded time series values within a time interval. For example, 100 cfs of delivery target to a demand site is a "cumulative" aggregation statistic calculated over a time interval like a month.

A term for describing the supported types of data that an attribute in WaMDaM can take based on logical and physical groupings like numeric, text, time stamped values, and parried categorical values. For example, numeric values, descriptor value, electronic files, time series, and multi attribute series.

A Term describing the name of quantitate or qualitative property of a water system component (e.g., reservoir).

A term for describing descriptive values (characters as numeric or strings) for an attribute. The descriptor values can be shared across attributes of systems components like land use "Grass_Pasture" or irrigation type "Flood", or site code as "10000010"

A term for describing the supported physical format of files loaded into WaMDaM as values to attributes(e.g., csv, jpg, NETCDF).

A term for describing vertical datums. Vertical datums are used in WaMDaM to specify the origin for elevations associated with node instance in networks.

A term for describing the name of a specific node or link system component in a specific location which can related synonymous native instance terms (e.g., Hyrum = Hrm & Hyrum Reservoir).

A term for describing types of Methods associated with recording or generating data values to attributes. Example method types are like "expert opinion", "field procedure", "model simulation".

A term for describing a built or natural water system component .

A term for describing the category of an Object Type as either: Node, link, network.

A term for describing types of systems models. Example resource types are WEAP, RiverWare, EPANET

A term for describing a categorical value that may correspond to numeric values of an attribute. The CategoricalValue represents steps in time (e.g., Winter, Summer, March, April) or space (e.g., categorical levels of reservoir levels (e.g., inactive, conservation, flood)

A term for describing a geographic reference to all the node instances that belong to the same Master Network.

A term for describing the name of the Unit of data value of an attribute.


How does it work to add new terms to the WaMDaM CVs?

In this registry, you may view and download existing controlled vocabularies for each table in WaMDaM or submit new terms to be added to the registry. Click on each vocabulary table below. The "Download" button will provide a CSV file of the entire vocabulary table. The "New" button allows you to submit a request to add a new term, after which you will receive a confirmation email. The registry moderator will approve or rejects the submitted term, and afterward, the term will become part of the registry and be available to the public.



How to use WaMDaM CVs?

The WaMDaM Wizard (download it from http://docs.wamdam.org/GetStarted/Steps/) reads water management datasets that are prepared into the WaMDaM Excel Workbook template. In the “HomePage” tab in the Workbook, the button "Update Controlled Vocabulary" calls this entire repository and updates the "ControlledVocabulary" tab. The “ControlledVocabulary" tab lists the "name" field in each table as a CV term. Then you may use the CV terms through built-in look-up menus to help you register or relate your native terms to the controlled terms.

Next, when you use the WaMDaM Wizard to load your prepared input data in the Workbook, the Wizard seamlessly calls this registry and downloads or updates all the content in your local SQLite database. Finally, all the datasets that have native terms registered against these CVs will be related together for querying and comparisons.



Credit and source code

We adapted the design of this registry from the source code of the ODM2 ControlledVocabularies available on GitHub @ https://github.com/ODM2/ODM2ControlledVocabularies. Thanks to Dr. Jeff Horsburgh and the ODM2 team for promoting #OpenScience by publishing their source code.

This server of the WaMDaM registry is deployed on Amazon Web Services (AWS) thanks to AWS Educate for their support. The adapted source code is available on GitHub @ https://github.com/WamdamProject/WaMDaM_ControlledVocabularies. The adapted source code include detailed instructions on the changes made to the original repository and how to deploy, access, and populate the repository on Amazon Web Services.