United States Department of Agriculture
US Forest Service
Natural Resource Manager (NRM)
Air v3.0.0 User Guide Appendix E: VIEWS
November 2016
Table of Contents
VIEWS 2
Fact Data Schema 2
Dataset Schema 3
Site Schema 4
Parameter Schema 5
Sampling Method Schema 6
Analysis Method Schema 7
Calculation Method Schema 8
Noting and Coding Key 8
Reference (Lookup) Tables 9
Example Submission Files (Excerpts) 20
Fact Data (Schema Code “FS”) File Excerpt 20
Site Data (Schema Code “SS”) File Excerpt 21
NRM Air v3.0.0 User Guide 19 Appendix E: VIEWS
VIEWS
The formatting requirements for each type of element are given below. These “Data Submission Schemas” specify the name, order, data type, meaning, and any special requirements for each field (column) within a single record of a given element type. An unlimited number of records for each element type can be included in a submission. “Notation and Coding Key” describes the simple notation and highlighting scheme that has been used to concisely indicate various characteristics about each schema and/or schema field. “Reference Tables” contains a series of reference (or “lookup”) tables to assist the data provider in assigning values to certain fields which require their values to come from a predefined list. Example Submission Files contains selected excerpts from example submission files.
Fact Data Schema
Table 1: Fact data schema
Field Name / Field Description /SchemaCode I U D / Schema Code: Value must be “FS” for this schema
ActionCode I U D / Action Code: Value must be “I,” “U,” or “D” (for Insert, Update, or Delete)
DatasetCode I U D → / Dataset Code: A unique, concise code that identifies the dataset (i.e., network or program) to which this record belongs; values must exist in the Dataset table
SiteCode I U D → / Site Code: A unique, concise code that identifies the site where the data was collected; value must exist in the Site table
Date I U D / Collection Date: The data and time (if applicable) of collection
ParamCode I U D → / Parameter Code: A unique, concise code that identifies the variable being measured; value must exist in the Parameter table
POC I U D / Parameter Occurrence Code: A code (usually a single digit) that indicates the “instance” of a given parameter measurement; used primarily to indicate co-located samples of a given substance without necessitating the use of an “instrument ID”—usually “1,” since a given parameter is usually sampled only once at a given site
MethodCode I U D → / Method Code: A unique, concise code that identifies the method used to collect the sample; value must exist in the Method table
FactValue I / Reported Value: A floating point number representing the actual reported data value
StatusFlag I → / Status Flag: The quality control “status” indicator for this data record; value must exist in the StatusFlag table
MDL / Method Detection Limit: A floating point number representing the method detection limit for the parameter value being reported
Unc / Uncertainty: A floating point number representing the uncertainty of the measurements
Duration / Sample Duration: A floating point number representing the duration of the sampling period
Flag1 / Flag1: A generic data flag for provider use (≤3 characters)
Flag2 / Flag2: A generic data flag for provider use (≤3 characters)
Flag3 / Flag3: A generic data flag for provider use (≤3 characters)
Flag4 / Flag4: A generic data flag for provider use (≤3 characters)
Flag5 / Flag5: A generic data flag for provider use (≤3 characters)
Tag / Record Tag: An alphanumeric “tag” that can be assigned to a record or group of records as an informal (non-key) identifier; values must be ≤10 characters
Dataset Schema
Table 2: Dataset schema
Field Name / Field Description /SchemaCode I U D / Schema Code: Value must be “DS” for this schema
ActionCode I U D / Action Code: Value must be “I,” “U,” or “D” (for Insert, Update or Delete)
DatasetCode I U D / Dataset Code: A unique, concise code that identifies the dataset (i.e,. network or program) to which this record belongs; value must exist in the Dataset table
DatasetName I / Dataset Name: The full name of the Dataset; values must be ≤100 characters
Objective I / Monitoring Objective: A description of why this dataset is collected (e.g., what environmental or other issue provides motivation for operating the monitoring network?), values must be ≤4000 characters
Description I / Description: A description of this dataset; values must be ≤8000 characters
Organization I / Administrative Organization: The organization or entity primarily responsible for the administration of the network or program that produces this dataset
ContactName I / Contact Name: The name of the primary contact for this dataset
ContactEmail I / Contact Email: The email address of the primary contact for this dataset
URL / URL: The “home” Internet address for detailed information about this Dataset; values must be ≤255 characters
Site Schema
Table 3: Site schema
Field Name / Field Description /SchemaCode I U D / Schema Code: Value must be “SS” for this schema
ActionCode I U D / Action Code: Value must be “I,” “U,” or “D” (for Insert, Update, or Delete)
DatasetCode I U D → / Dataset Code: A unique, concise code that identifies the dataset (i.e., network or program) to which this site belongs; values must exist in the Dataset table
SiteCode I U D / Site Code: A unique, concise code that identifies the site; values must be ≤16 characters
Name I / Site Name: The full name of the site; values must be ≤100 characters
Latitude I / Latitude: The latitude of this site in decimal degrees
Longitude I / Longitude: The longitude of this site in decimal degrees
Elevation I / Elevation: the elevation of the site in meters above mean sea level
CountryFIPS / Country: The two-digit FIPS code for the site’s country
StateFIPS / State: The two-digit FIPS code for the site’s state
CountyFIPS / County: The three-digit FIPS code for the site’s county
StartDate / Start Date: The date that data collection began at this site
EndDate / End Date: The date that data collection ended at this site
EPACode / EPA Site Code: The EPA code for this site; values must be 9 characters
EPARegion / EPA Region: The site’s EPA Region; integer
LandUseCode → / Land Use Code: A unique, concise code that identifies the “land use” at or near the site; value must exist in the LandUse table; values must be ≤20 characters
Address / Street Address: The address (if any) with which this site is associated; values must ≤255 characters
LocDesc / Location Description: A text description of the site’s location; values must be ≤255 characters
Sponsor / Sponsor: The organization which sponsors the site’s operation; values must be ≤50 characters
URL / URL: The Internet address for detailed information about this site; values must be ≤255 characters
Parameter Schema
Table 4: Parameter schema
Field Name / Field Description /SchemaCode I U D / Schema Code: Value must be “PA” for this schema
ActionCode I U D / Action Code: Value must be “I,” “U,” or “D” (for Insert, Update or Delete)
DatasetCode I U D → / Dataset Code: A unique, concise code that identifies the dataset (i.e., network or program) to which this site belongs; value must exist in the Dataset table
ParamCode I U D / Parameter Code: A unique, concise code that identifies the variable being measured; values must ≤50 characters
Name I / Parameter Name: A unique, concise name for the site
TypeCode I I → / Type Code: A unique, concise code that identifies the “type” of parameter’ value must exist in the ParameterType table
UnitCode I → / Unit Code: The units used within this Dataset for reporting values for this parameter; value must exist in the Unit table
SMethodCode I → / Sampling Method Code: A unique code that identifies the sampling method; value must 1) exist in the SamplingMethod table, 2) be “SampleSpecific,” and 3) be “N/A”
AMethodCode I → / Analysis Method Code: A unique code that identifies the analysis method; value must 1) exist in the AnalysisMethod table, 2) be “SampleSpecific,” and 3) be “N/A”
CMethodCode I → / Calculation Method Code: A unique code that identifies the calculation (or derivation, processing, etc.) method; value must 1) exist in the CalculationMethod table; 2) be “SampleSpecific,” and 3) be “N/A”
SigDigits / Significant Digits: The number of significant digits in the floating point values reported for this parameter
Sampling Method Schema
Table 5: Sampling method schema
Field Name / Field Description /SchemaCode I U D / Schema Code: Value must be “MS” for this schema
ActionCode I U D / Action Code: Value must be “I,” “U,” or “D” (for Insert, Update or Delete)
DatasetCode I U D → / Dataset Code: A unique, concise code that identifies the dataset (i.e., network or program) to which this site belongs; value must exist in the Dataset tables
SMethodCode I U D / Sampling Method Code: A unique, concise code that identifies the sampling method within this Dataset; values must be ≤20 characters
Instrument I / Sampling Instrument: A description of the instrument used to collect samples; values must be ≤200 characters
FreqCode I → / Sampling Frequency Code: A unique, concise code that identifies the sampling frequency; value must exist in the SamplingFrequency table
DurCode I → / Sampling Duration Code: A unique, concise code that identifies the duration of each sampling period; value must exist in the SamplingDuration table
Media / Sampling Media: The media used by the instrument for collecting samples, if applicable; values must be ≤100 characters
Description / Description: A description of (or further comments about) this sampling method; values must be ≤4000 characters
Analysis Method Schema
Table 6: Analysis method schema
Field Name / Field Description /SchemaCode I U D / Schema Code: Value must be “MA” for this schema
ActionCode I U D / Action Code: Value must be “I,” “U,” or “D” (for Insert, Update, or Delete)
DatasetCode I U D → / Dataset Code: A unique, concise code that identifies the dataset (i.e., network or program) to which this site belongs; value must exist in the Dataset table
AMethodCode I U D / Analysis Method Code: A unique, concise code that identifies the analysis method within this Dataset; values must be ≤20 characters
Description / Description: A description of (or further comments about) this sampling method; values must be ≤4000 characters
Calculation Method Schema
Table 7: Calculation method schema
Field Name / Field Description /SchemaCode I U D / Schema Code: Value must be “MC” for this schema
ActionCode I U D / Action Code: Value must be “I,” “U,” or “D” (for Insert, Update, or Delete)
DatasetCode I U D → / Dataset Code: A unique, concise code that identifies the dataset (i.e., network or program) to which this site belongs; value must exist in the Dataset table
CMethodCode I U D / Calculation Method Code: A unique, concise code that identifies the calculation method within this Dataset; values must be ≤20 characters
Algorithm / Algorithm: A description (as rigorous as possible) of the algorithm used when applying this method; values must be ≤200 characters
Description / Description: A description of (or further comments about) this sampling method; values must be ≤4000 characters
Noting and Coding Key
Table 8: Noting and coding key
Notation / Description /<light gray highlight> / Import Directive Field (used only during processing)
I / Required Field for “I” (Insert) Action Records
U / Required Field for “U” (Update) Action Records
D / Required Field for “D” (Delete) Action Records
/ Key field
→ / Foreign Key Field (a key to a record in another table)
Reference (Lookup) Tables
Table 9: Sampling Duration
Duration Code / Duration Description /A1H / Averaged duration of 1 hour
A5M / Averaged duration of 5 minutes
D7 / 7 days
H023 / 24 hours, starting at 0:00 and ending at 23:00
H1 / 1 hour
H10 / 10 hours
H11 / 11 hours
H12 / 12 hours
H2 / 2 hours
H24 / 24 hours
H3 / 3 hours
H4 / 4 hours
H5 / 5 hours
H6 / 6 hours
H7 / 7 hours
H72 / 72 hours
H8 / 8 hours
H9 / 9 hours
M1 / 1 min
M10 / 10 mins
M15 / 15 mins
M2 / 2 mins
M30 / 30 mins
M5 / 5 mins
M53 / 53 mins
M54 / 54 min
S0 / Instaneous
S1 / 1 sec
S10 / 10 secs
S15 / 15 secs
S28 / 28 secs
S4 / 4 secs (3.6 secs rounded up)
S5 / 5 secs
VA / Variable
UNS / Unspecified
Table 10: Sampling Frequency
Frequency Code / Frequency Description /2DA / Twice daily
2WE / Twice weekly
3N7 / Three days in seven
A15 / Sampled every minute, averaged to every 5 minutes
A16 / Sampled every minute, averaged to every 60 minutes
A26 / Sampled every 2 minutes, averaged to every 60 minutes
A56 / Sampled every 5 minutes, averaged to every 60 minutes
A60 / Sampled every 15 minutes, averaged to every 60 minutes
A65 / Averaged to 60 minutes from 5 minute average
A7D / AIRS Code Interval 7, every 6th day or so, frequency varies down to every day, 0-23 PST
AS5 / Sampled every second, averaged to every 5 seconds
AT6 / Sampled every 10 minutes averaged to every 60 minutes
CON / Continuous
D1 / Every day, 0000-2300 PST
D3 / Every third day, 0000-2300 PST
D6 / Every sixth day, EPA schedule, 0000-2300 PST
D63 / Twice-a-day, 6AM, 3PM
DA / Every day
E1 / 15 Episode Days, 0000-2400 PST
E2 / 15 Episode Days, 1600-0500, 0500-1600 PST
E4 / 15 Episode Days, 0000-0500, 0500-1000, 1000-1600, 1600-2400 PST
E5 / 15 Episode Days, 0000-0500, 0500-1000, 1000-1300, 1300-1600, 1600-2400 PST
EC3 / Episode Days, 3-hour Canister Sampling Schedule (0000-0300), (0600-0900), (1300-1600), (1700-2000)
EHC / Episode Days, Hourly Sampling except two hours for calibration runs and blank runs
EV / 15 Episode Days, ES with one skip and two skip
H1 / Every hour
H2 / Every other hour: 1, 3, 5, 7, 9, 11, 13. 15. 17. 19. 21.23
H3 / Every 3 hours
HD / Every hour, every day, 0000-2300 PST
INT / Intermittent
L6 / Every sixth day, 3-day lag, 000-2300 PST
M10 / Every 10 minutes
M15 / Every 15 minutes
M30 / Every 30 minutes
MIN / Every minute
MN2 / Every 2 minutes
MN5 / Every 5 minutes
S10 / Every 10 seconds
S15 / Every 15 seconds
S4 / Every 4 seconds (actually every 3.6 secs rounded up to 4 secs)
SC2 / Every 2 seconds
SC5 / Every 5 seconds
SEC / Every second
Table 11: Schema