Releases: datastreamapp/schema
Releases · datastreamapp/schema
v2.0
- Rewrite build process to:
- Pull the latest version of WQX values and simplify future updates
- Improve maintainability and audit control
MonitoringLocationID
is now requiredMonitoringLocationWaterbody
is now deprecatedMedodSpeciation
has new conditional requirementsActivityMediaName
has new allowed values:Ambient Air
,Surface Water Sediment
,Pore Water
,Ocean Water
- Additional checks to prevent the common issues people run into surrounding Dissolved Oxygen, Hardness, and others. See
src/logic/ResultValue-*.json
v1.7
ResultAnalyticalMethodContext
addEN
- remove or condition on
ResultAnalyticalMethodID
andResultAnalyticalMethodName
- Fix logic bug for enforcing sample fraction requirement for subset of characteristic names
v1.6
- Add in new column;
ResultValueType
- Add in
as CN
toMethodSpeciation
- Add in
L/mg-m
toResultUnit
v1.5
- Removed all characteristic names with
Retired
- Added
Filtered
as an allowed value for Sample Fraction - ActivityStartTime' color lightened on glossary page to denote optionality
- Revised
ResultDetectionQuantitationLimitMeasure
description in glossary to new allowed values for above/below detection limits - Changed Grouping for
C23-C32 Hydrocarbons
andC24-C36 Hydrocarbons
toOrganics, Other
- Removed
ResultSampleFraction
requirement from2,4-D
- Added
C10-C16 Hydrocarbons
,C16-C34 Hydrocarbons
,C10-C19 Hydrocarbons
,C34-C50 Hydrocarbons
,Purgeable hydrocarbons
,Extractable hydrocarbons
,Didecyl dimethyl ammonium chloride
,Diisopropanolamine
,Monochlorobenzene
,Sulfolane
,Triphenyltin
,3-Iodo-2-propynyl butyl carbamate
, andpheophytin
toCharacteristicName
- Removed
Gasoline range organics (C6-C12 GRO)
,Extractable fuel hydrocarbons (C13-C22 DRO)
, andTetrachloroethene
fromCharacteristicName
- Added
#/yr
anduATM
toResultUnit
andResultDetectionQuantitationLimitUnit
- Removed duplicate names for
Shannon & Wiener Macroinvert Taxonomic Diversity Index
,Escherichia coli
, andEnterococcusin
allowed values forCharteristicName
v1.4
- Removed
µ
from unit values due to formatting issues with non-UTF-8 encoded characters in .csv files - Replaced sample fraction
Non-Filterable
withNon-Filterable (Particle)
to align with WQX - Changed Analysis Start Time Zone from conditional to optional
v1.3
- Added
C4-Fluorenes
,Total Phosphorus, mixed forms
,Total Nitrogen, mixed forms
,Silica, reactive
,Residue
, andThorium
toCharacteristicName
allowed values - Changed
Result Fraction Requirement
for(1R,2S,5R)-Menthol
,(3-Bromopropyl)benzene
,.Alpha.-Pinene
,Ammonia
,Inorganic nitrogen (nitrate and nitrite)
,Kjeldahl nitrogen
,Nitrate
,Nitrite
,Nitrogen ion
,Organic Nitrogen
,Orthophosphate
,Phosphate-phosphorus
,Phosphorus
,Polyphosphate
,Sodium nitrite
,Soluble Reactive Phosphorus (SRP)
, andZinc
fromNo
toYes
- Changed
Result Fraction Requirement
forAnion/cation ratio
,Bacillus thuringiensis (Berliner)
,Bacillus thuringiensis aizawai
,Bacillus thuringiensis aizawai GC-91
,Bacillus thuringiensis israelensis
,Bacillus thuringiensis kurstaki
,Bacillus thuringiensis kurstaki BMP123
,Bacillus thuringiensis kurstaki EG2348
,Bacillus thuringiensis kurstaki EG2371
,Bacillus thuringiensis kurstaki EG2424
,Bacillus thuringiensis kurstaki HD1
,D-endotoxin
,cry1A(b)
,Bacillus thuringiensis morrisoni
,lepidopteran active
,Bacillus thuringiensis NB357M
,Bacillus thuringiensis tenebrionis
,Bacitracin
,Bacteria
,Sulfate reducing
,BOD
,Sediment Load
,Carbon-13/Carbon-12 ratio
,Colored dissolved organic matter (CDOM)
,Gran acid neutralizing capacity
,Gravimetric water content
,Ionic strength
,Oxygen 18/oxygen 16 ratio in sulfate
,Oxygen-18/Oxygen-16 ratio
,Pseudomonas cepacia type Wisconsin
,Pseudomonas fluorescens 112-12, (MON 11740)
,Pseudomonas fluorescens 112-12, (MON 11750)
,Pseudomonas fluorescens 112-12, (MON 11760)
,Pseudomonas fluorescens NCIB 12089
,Pseudomonas fluorescens PS 3732-3-7, (MON 11710)
,Pseudomonas fluorescens PS 3732-3-7, (MON 11720)
,Pseudomonas fluorescens PS 3732-3-7, (MON 11730)
,Radioactivity, gross, RBP2
,Habitat type, other (%)
,Secondary productivity
,Stream Cross-Sectional Area
,Temperature difference
, andTrue color
fromYes
toNo
- Added
TCU
to units allowed values - Added:
Below Detection/Quantification Limit
(replacesPresent Below Quantification Limit
),Above Detection/Quantification Limit
(replacesPresent Above Quantification Limit
), andNot Reported
toResultDetectionCondition
. - Added
Acid soluble
toResultSampleFraction
allowed values. - Changed all
u
units denotingmicro
toµ
for the allowedResultUnit
values (u
remains accepted as equivalent)
v1.2
- Added
Ocean
andEstuary
toMonitoringLocationType
- changed
LabratorySampleID
toLaboratorySampleID
(spelling) - removed list of allowed values from
ResultAnalyticalMethodName
- added
Unfiltered
,Filtered, Lab
, andFiltered, Field
to allowed values inResultSampleFraction
- added
Silver Dioxide
andApparent Colour
to the list of allowed values inCharacteristicName
- added
REL
,CTU
,HZN
as allowed values under ResultUnit - updated
CharacterisitcName
list (additional allowed values to match WQX) - updated
ResultUnit
andResultDetectionQuantificationLimitUnit
list (additional allowed values to match WQX)
v1.1
- Update allowed values in
MonitoringLocationType
andActivityType
. - Improve TimeZone formatting
- Add in logic around
ResultValue
andResultDetectionQuantitationLimitMeasure
v1.0
Starting from US EPA WQX:
ProjectName
->DatasetName
to be more genericActivityDepthHeightMeasure
- Added maximum restriction due to only recording water samples.ResultAnalyticalMethodName
- Added for readabilityResultAnalyticalMethodID
- Removed allowed valuesLabratorySampleID
- Added to improve MetadataAnalysisStartTimeZone
- Changed format to follow ISO 8601 ex-0600
ActivityStartTimeZone
/ActivityEndTimeZone
removed because they can be inferred from the locationState
andCounty
->MonitoringLocationRegion
to allow for a broader meaning that can be applied internationally.