450 likes | 610 Views
Team Arundo del Norte Weed Data Collection, Aggregation, and Sharing from the Ground Up Deanne DiPietro Sonoma Ecology Center. State-Level Aggregation Site. Field. Desktop. Multi-Partner DB. A story of data management and aggregation. Team Arundo del Norte Project Needs.
E N D
Team Arundo del Norte Weed Data Collection, Aggregation, and Sharing from the Ground Up Deanne DiPietro Sonoma Ecology Center
State-Level Aggregation Site Field Desktop Multi-Partner DB A story of data management and aggregation
Team Arundo del Norte Project Needs • Assist 9 orgs with mapping and data management • Monitor treatments eradication, and change in vegetation • Aggregate data, display and analyze together • Share data at state level
The Search for a Data Management System Trade-Offs of Low-Tech vs High-Tech • Costs of equipment • Learning curveOR • Data standardization and quality control Lots of experience with the heartbreak of bad data
TNC’s WIMS… • MS Access desktop with handheld & ArcPad • Good field data model: Occurrences, Assessments, Treatments • Field tested and many things figured out
Modifications to WIMS • Data safe-guarding • Additional and extended data elements • Tighten up semantics and usage ambiguities • User interface • Data quality management
Announcing Supports quality data capture, error detection, and aggregation http://geoweed.org
Step 1: Enter Admin Data and Field Data Forms Step 2: GIS Export and Background layers GeoWeed Desktop Database Step 4: GIS Import GeoWeed Work Flow Step 3: Field Data Collection
GeoWeed Schema • Referential integrity rules enforce important dependencies Assessment Occurrence Assessment Assessment
GeoWeed Schema • Referential integrity rules enforce important dependencies • Prevents data from becoming corrupted Assessment ? Assessment Assessment
New Data Elements • Survey (vegetation monitoring and absence data) • Work Session and Project metadata • Contacts • Photo Monitoring and photo file management • Revegetation log
Clarification of “OAT” data elements Occurrence • Occurrences, Assessments, & Treatments tied together like a string of beads Assessment Treated Assessment Time Assessment Assessment
Occurrences Surveys Sessions Patch 2A Patch 2B Patch 3A Patch 1B Patch 1A March 13, 2007 Oct. 10, 2007 June 3, 2008 Aug. 13, 2008
Powerful and Intuitive Desktop Use Interface • Record summary displays tell you what you’ve got • Jump directly to all your data by type
Desktop User Interface, cont’d • Related records available from every record • Filters (instant queries)let you rapidly explore your data and get summaries
Data Navigation: Stacks Examples: • Assessments for a given Occurrence • Treatments done in a given Work Session • All Surveys in a Region User views/edits a “stack” of related records with each Form, rather than just one record. Can step thru the stack, without returning to a previous form and going forward again.
The GeoWeed Navigation Bar: the same navigation functions on every form Record type Scroll buttons and number of records in stack
Navigation Bar: History Go! History list: Has the name of the stack and the time viewed
Data Quality Management • Tools for immediate problem-flagging and fixing Something wrong here! Check, clean, and calculate
Internal documentation: Use of the Treatment Polygon You can use the polygon tool to: • define the area actually treated • “lasso” the infestations being treated GeoWeed tracks which you mean so the treated area can be calculated and reported correctly later
Hoping to find funding to complete: • Web-based drill-down reports and diagnostics • On-board maps • Data import wizard (from WIMS or any source) • Automation of data feeds to aggregation servers (both rich-set and NAWMA)
Data Aggregation and Online Map Displays TAdN Map Server BIOS CRISIS Maps
Multi-Partner Database Aggregation Utility (GeoWeed Plus)
Static Maps Posted Online http://teamarundo.org
Use Cases and Issues Use Cases- • Present the collective work and progress of the 9-partner project • Allow for a visual overview of the whole project • Analyze efficacy, statistics across partners Issues- • How much to show the public?
State Level Aggregation and Data Sharing • Exhaustive search for No. Cal. Arundo data • Data compiled from 24 organizations • Consolidated into one simplified NAWMA-compliant layer • Metadata created for each original dataset and for consol. layer
DFG BIOS Use Cases- • Share data at state level • Provide display with other enviro. data Agreement with Cal-IPC to host invasive plant data
Data Model- NAWMA Some NAWMA Fields had to be generated Gross Area and Infested Area were calculated if polygons or area measurement available, left blank if point only Metadata for source dataset linked in every record
Metadata:CEIC • Facilitates discovery and sharing of data by download or contacting owner • Official state environmental data catalog • Run by CERES
CEIC • The Team Arundo del Norte Catalog on CEIC http://gis.ca.gov/catalog
NBII CRISIS Maps • National level data sharing • Multiple aggregators • WFS (Open GIS) services
State Level Aggregation Use Cases • Evaluation of weed distribution • Support requests for funding • Index to available data sources • Early detection and alert system • Analysis and modeling (?)
Issues • Absence of data vs. Absence of weeds • Tracking treatments • Incremental updates of assessments and treatments • Different semantics in source data • Moving data quickly- automated data feeds
Needs • A working content and format standard • Determine your use cases! One size does not fit all • Regional aggregators • Training • Field data collection protocols • Metadata at every level of data management
Sonoma Ecology Center Services • GeoWeed training and support • Software development • Help with data management and aggregation • Working with ICE and NBII on data networking issues….”WeedNet”
Thank you! Deanne DiPietro deanne@sonomaecologycenter.org (707) 996-0712 Ext. 114