Overview
A comprehensive suite of tools for managing environmental observational data using the Observation Data Model 2 (ODM2) standard. This ecosystem includes multiple interconnected projects that provide data management, API access, and web services for critical zone science and environmental monitoring.
Key Projects
CZ Manager (ODM2 Admin)
An application for site-level data management of environmental observations. Originally called ODM2 Admin, it provides a user-friendly interface for researchers to manage time-series sensor data, spatial observations, and related metadata.
Repository: github.com/ODM2/CZ-Manager
ODM2 Python API
A Python-based application programmer's interface for ODM2 databases, enabling programmatic access to environmental observation data with full support for the ODM2 data model.
Repository: github.com/ODM2/ODM2PythonAPI
ODM2 RESTful Web Services
A Python RESTful web service interface using Django REST Framework that provides standardized API access to ODM2 databases with automatic API documentation via Swagger.
Repository: github.com/ODM2/ODM2RESTfulWebServices
Features
- Standardized Data Model: Based on ODM2, a community information model for environmental observations
- Web-Based Management: Admin interface for CRUD operations on observational data
- RESTful APIs: Programmatic access to data through well-documented REST endpoints
- Spatial Support: PostGIS integration for geospatial queries and analysis
- Time-Series Management: Specialized tools for sensor data and time-series observations
- Multi-tenancy: Support for multiple sites and research projects
Technical Stack
- Backend: Django framework with Django REST Framework
- Database: PostgreSQL with PostGIS extension for spatial data
- ORM: SQLAlchemy for the Python API layer
- Deployment: Docker containers for consistent deployment
- Documentation: Automated API documentation with Swagger
Development Contributions
During my time at UW Applied Physics Laboratory (2016-2018), I:
- Developed the admin map dashboard for managing time-series sensor data (BiG-CZ project)
- Created data integration pipelines for water quality data
- Implemented geospatial analysis tools for critical zone science
- Collaborated with multi-institutional teams on data standards
Impact & Recognition
- Award Recognition: Recognized for outstanding work in design and implementation of the Admin map dashboard
- Multi-Project Integration: Integrated with the BiG-CZ (Biological and Geological Critical Zone) project
- Community Adoption: Used by critical zone observatories and environmental monitoring networks
- Educational Impact: Delivered tutorials at BiG-CZ/ODM2 Hands-On Workshop (UC Riverside, 2017)
Workshops & Training
BiG-CZ/ODM2 Hands-On Workshop (2017)
University of California, Riverside
Role: Infrastructure Engineer and ODM2 Tools Instructor
- Set up JupyterHub instance for workshop participants
- Delivered tutorials on ODM2 Python tools and APIs
- Demonstrated data integration workflows
Publications
Mayorga, E., Setiawan, L., et al. (2017). Cross-site soil and microbial ecology cyberinfrastructure for the CZIMEA project. EarthCube All-Hands Meeting, Seattle, WA.
Leon, M., McDowell, W. H., Mayorga, E., Setiawan, L., & Hooper, R. P. (2017). ODM2 Admin Pilot Project- a Data Management Application for Observations of the Critical Zone. AGU Fall Meeting Abstracts.