Steve -
David Maidment (at UT-Austin) has been leading an NSF funded project
to develop a Water Data Service system. The ODM (Observation Data
Model) component would be a good candidate for your needs.
from our website(his.cuashi.org):
The CUAHSI Hydrologic Information System project is developing
information technology infrastructure to support hydrologic science.
One aspect of this is a data model for the storage and retrieval of
hydrologic observations in a relational database. The purpose for such
a database is to store hydrologic observations data in a system
designed to optimize data retrieval for integrated analysis of
information collected by multiple investigators. It is intended to
provide a standard format to aid in the effective sharing of
information between investigators and to allow analysis of information
from disparate sources both within a single study area or hydrologic
observatory and across hydrologic observatories and regions. The
observations data model is designed to store hydrologic observations
and sufficient ancillary information (metadata) about the data values
to provide traceable heritage from raw measurements to usable
information allowing them to be unambiguously interpreted and used. A
relational database format is used to provide querying capability to
allow data retrieval supporting diverse analyses. A generic template
for the observations database is presented. This is referred to as the
Observations Data Model (ODM).
ODM has been used at the WATERS testbed sites and Critical Zone
Observatories.
The CUAHSI-HIS suite includes other tools for data storage publication
and retrieval - including hydroseek, hydroExcel and WaterML webservices.
Data partners includes: USGS, EPA, NOAA, NASA
regards.
David
==========================================
David Kirschtel, Ph.D. - Sr Program Manager
CUAHSI
2000 Florida Ave, NW
Washington, DC 20009
202.777.7309
[EMAIL PROTECTED]
On Oct 24, 2008, at 8:43 AM, [EMAIL PROTECTED] wrote:
Hello everyone,
I am looking for recommendations for a database management system or
data
archiving system that can handle longitudinal daily data records. For
example, we have a hydrological monitoring program that maintains
records
since 2000, records represent the daily mean water stage at several
hundred
monitoring sites, that have been interpolated and assigned to a grid
with
405 rows and 287 columns. Each cell in this grid represent a 400 x
400
meter area.
Our modeling goals are to use these data along with a much larger and
broader suite of environmental data to conduct vegetation and wildlife
simulations that are being designed to address adaptive management
decisions.
So I am looking to see if there are any substantial data management
systems
available that can handle this kind of volume of data. Currently the
hydrological data is stored in netCDF, however it requires advanced
users
to ensure access to the data.
Are there alternatives?
Thanks
Steve
Steve Friedman Ph. D.
Spatial Statistical Analyst
Everglades and Dry Tortugas National Park
950 N Krome Ave (3rd Floor)
Homestead, Florida 33034
Office (305) 224 - 4282
[EMAIL PROTECTED]
