Untitled › Forums › International Hydrometry Network › Hydrometric Data › Discharge measurements meta data in the data base › Reply To: Discharge measurements meta data in the data base
2023-07-04 at 10:05
#384
Hi. We store those below in our database. Not all items apply to all instruments. Most values are imported automatically from data files (QrevInt, Sommer TQ) and/or read from our database (station name, for instance, is already in the database, but linked to the discharge measurement page when station number is read from data file)
- Station name, number (id), owner
- Date, start time, end time
- Stage before and after and representative
- Location relative to control section/profile (upstream/downstream/at) + Distance from control section/profile
- Ice condition (at meas. location and contol/profile)
- Instrument and software info (type, version, firmware) for data collection and postprocessing
- Deployment method
- Measured Q and final Q (after adjusting if measurement location is far from gauging station)
- Quality (discharge, stage, total. Total = min(discharge, stage))
- Area, widht, max and mean depth, max and mean velocity, num verticals/transects
In addidion the xml-files are stored as xml in the database so that we can query for even more summary/meta data.