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 required
• MonitoringLocationWaterbody is now deprecated
• MedodSpeciation has new conditional requirements
• ActivityMediaName 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 add EN
• remove or condition on ResultAnalyticalMethodID and ResultAnalyticalMethodName
• Fix logic bug for enforcing sample fraction requirement for subset of characteristic names

v1.6

• Add in new column; ResultValueType
• Add in as CN to MethodSpeciation
• Add in L/mg-m to ResultUnit

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 and C24-C36 Hydrocarbons to Organics, Other
• Removed ResultSampleFraction requirement from 2,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, and pheophytin to CharacteristicName
• Removed Gasoline range organics (C6-C12 GRO), Extractable fuel hydrocarbons (C13-C22 DRO), and Tetrachloroethene from CharacteristicName
• Added #/yr and uATM to ResultUnit and ResultDetectionQuantitationLimitUnit
• Removed duplicate names for Shannon & Wiener Macroinvert Taxonomic Diversity Index, Escherichia coli, and Enterococcusin allowed values for CharteristicName

v1.4

• Removed µ from unit values due to formatting issues with non-UTF-8 encoded characters in .csv files
• Replaced sample fraction Non-Filterable with Non-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, and Thorium to CharacteristicName 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), and Zinc from No to Yes
• Changed Result Fraction Requirement for Anion/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, and True color from Yes to No
• Added TCU to units allowed values
• Added: Below Detection/Quantification Limit (replaces Present Below Quantification Limit), Above Detection/Quantification Limit (replaces Present Above Quantification Limit), and Not Reported to ResultDetectionCondition.
• Added Acid soluble to ResultSampleFraction allowed values.
• Changed all u units denoting micro to µ for the allowed ResultUnit values (u remains accepted as equivalent)

v1.2

• Added Ocean and Estuary to MonitoringLocationType
• changed LabratorySampleID to LaboratorySampleID (spelling)
• removed list of allowed values from ResultAnalyticalMethodName
• added Unfiltered, Filtered, Lab, and Filtered, Field to allowed values in ResultSampleFraction
• added Silver Dioxide and Apparent Colour to the list of allowed values in CharacteristicName
• added REL, CTU, HZN as allowed values under ResultUnit
• updated CharacterisitcName list (additional allowed values to match WQX)
• updated ResultUnit and ResultDetectionQuantificationLimitUnit list (additional allowed values to match WQX)

v1.1

• Update allowed values in MonitoringLocationType and ActivityType .
• Improve TimeZone formatting
• Add in logic around ResultValue and ResultDetectionQuantitationLimitMeasure

v1.0

Starting from US EPA WQX:

• ProjectName -> DatasetName to be more generic
• ActivityDepthHeightMeasure - Added maximum restriction due to only recording water samples.
• ResultAnalyticalMethodName - Added for readability
• ResultAnalyticalMethodID - Removed allowed values
• LabratorySampleID - Added to improve Metadata
• AnalysisStartTimeZone - Changed format to follow ISO 8601 ex -0600
• ActivityStartTimeZone / ActivityEndTimeZone removed because they can be inferred from the location
• State and County-> MonitoringLocationRegion to allow for a broader meaning that can be applied internationally.