The University of Washington, Bothell- Cascadia Community College campus is home to a vibrant 58-acre restored freshwater wetland and stream ecosystem. At the outset of the project in 1998, this was one of the largest and most complex floodplain restorations ever undertaken in the Pacific Northwest. The Geodatabase Working Group is developing a comprehensive UWB/CCC Geodatabase for research and teaching purposes that students, staff and faculty can use for independent, class and community-based projects that utilize the campus wetlands. Using Geographic Information Systems (GIS) technology and protocols, they are developing the initial layer by mapping baseline boundaries of plant (vegetation communities), topographic and geomorphologic characteristics, and hydrological features of the UWB/CCC Wetlands.
The purpose of Geodatabase project is to provide the University of Washington Bothell an effective and efficient mobile tool and database system for the purposes of collecting, storing, and retrieving geographical and environmental data about the North Creek wetlands and other surrounding areas. Data about plant and species coverage, biodiversity of plants, community structures, bird densities, water quality, vegetation studies, soil nutrients, GPS and geographical waypoints, vegetation communities, crow-related research, and many other areas of research are collected by the department’s researchers and assistants. Working to consolidate, organize, and manage all of these various types of data from all of these different research groups within the department, an effective and robust database system and data collection tool is necessary in order to gather important, useful, and valuable data and to aid researchers in building a comprehensive and substantial database for access and use by the UWB community and the general public. . One important aspect of data management is data provenance. In computer science, provenance describes the source and derivation of data. From it, one can ascertain the quality of the data based on its ancestral data and derivations, track back sources of errors, allow automated reenactment of derivations to update a data, and provide attribution of data sources. In this project, provenance can help researchers analyze relationships between data and observe the changes between different periods.
For students who are interested in this project, we use the following technologies: iOS, Android, SQL Server, Tomcat, JAVA, JSON, Solr, ArcGIS, RESTFUL API, HTML, CSS.
Qi Zhang, Jonathan Mason, Morteza Chini, Karen Potts, Nathan Duncan, Hazeline U. Asuncion. WIP: Provenance Support for Interdisciplinary Research on the North Creek Wetlands. 1st International Workshop on Interoperable Infrastructures for Interdisciplinary Big Data Sciences, in conjuction with e-Science Conference, September 2015.
This work is based upon work supported by the US National Science Foundation under Grant No. ACI 1350724. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the NSF.