Monitor Data Queries

Definitions--Entity/Attributes Entity-Attribute Definitions and Associations--help the user to more effectively navigate through the system to the desired information. It contains a list of the Air Quality Entity names which are stored in the Air Quality database, as well as links them with their attribute relationships. In this way, the user can ensure that they are asking for and receiving the information they are specifically looking for. (**This version does not include the attribute relationships, this information is forth coming.) ENTITY   ENTITY DESCRIPTION 1 HR DV   One Hour Design values. 8 HR DV   Eight Hour Design Values.   A ACC MO SUMMARY   ACC RO SUMMARY   Air quality reporting organization summary data on the number of approved analyzers in the network and their accuracy limits. ACC SUM METHOD   Methods used in the accuracy summary data. ACCURACY   Information about accuracy audits. ACCURACY LEVEL   Accuracy audit data. ACTION TYPE   An indication of the kind of administrative action. ACTION TYPE REASON   A code indicating why a particular action. AEROSOL   Aerosol data is a type of visibility data that has one sample for each day with a duration of 24 hours. AGENCY   The agency responsible for the operation of the monitoring site. AGENCY TYPE   The type of agency responsible for the operation of the monitoring site. AIR BASIN   The geographical area of air districts in the state of California. ANALYSIS LAB   A code, when combined with the state code, that uniquely identifies the laboratory responsible for the analysis of air quality measurement samples. ANNUAL SUMMARY   Calculated values of concentrations of a parameter sampled at a site which have been summarized for a year. AQCR   A group of counties within a state, or counties from multiple states that share common geographical or pollutant concentration characteristics. AQCR COUNTY   Intersection entity for AQCR and county. AQCR TYPE   The type codes for a group of counties within a state, or counties from multiple states that share common geographical or pollutant concentration characteristics. ARITH MEAN   Arithmetic Mean - Measure of central tendency obtained from the sum of the observed pollutant data values over a specified interval divided by the number of values that comprise the sum for the monitor year. ARITH STD DEV   Arithmetic Standard Deviation - A measure of the dispersion about the central tendency of a pollutant that is the square root of the arithmetic mean of the squares of the variation for each data value from the arithmetic mean of the data values for the monitor year. AUDIT   Information describing an audit. AUDIT CLASS   Class of audit taken at the monitor.   B/C CERTIFICATION   A record of data certification. CITY   The city in which a site is located. CITY ZIP   Intersection entity for CITY and ZIP CODE. CLASS 1 AREA   Class 1 Area. CLASS 1 TYPE   Class 1 type. CMSA   Consolidated Metropolitan Statistical Area. COLLECTING LAB   A code (when combined with the state) that uniquely identifies the laboratory responsible for the collection of air quality measurement samples. COLLOCATED MONITOR   Historical record of a monitor's collocated status. COMPASS SECTOR   The true (as opposed to magnetic) direction of the site from the central business district. COMPOSITE   Composite data are concentration values derived from two or more air samples obtained at different times and combined and analyzed as one sample. COMPOSITE PERIOD   The time period over which samples are composited or the frequency of submitting composite samples. COMPOSITE TYPE   1=Quarterly, 2=Seasonal, 3=Monthly, 4=Weekly CONVERSION   Conversion of reported to standard units. COUNTY   A county or the equivalent geo political entity, such as a parish or independent city COUNTY CITY   Intersection entity between COUNTY and CITY. COUNTY MONITOR SEASON   Description of the county ozone monitoring season. CR AIR QUALITY   Air quality data to be used for the critical review report. CR AQ REASON   Reason that a piece of data has been flagged to appear on the CR. CR MONITOR CHANGE   Monitor data that appears on the critical review report. CR PA REASON   Reason that data appears on the critical review report. CR PRECISION ACCURACY   Precision and accuracy data for the critical review report.   D/E/F DAILY SUMMARY   Daily summary of hourly data. DATE LAST UPDATE   The date on which the Monitor record for the SITE was updated through the ARIS AQS Update program. DATE SITE CRITERIA   The date on which EPA approved a site as MET meeting the siting criteria. DATE SITE ESTABLISHED   The date on which the monitoring site was established. DATE SITE TERMINATED   The date on which ceased to operate. DAY   Day of the month. DATUM   Indicates the year of the reference datum. DOMINANT SOURCE   The primary source of the pollutant being monitored. DP IND   The number of Decimal Positions (DP) the data was submitted with. DP MEAN   The decimal position indicator of the Arithmetic and Geometric means from the summary records. DIFFERENCE FROM GMT   The difference (in hours) between standard time at the site and Greenwich Mean Time (GMT). DISTANCE to CITY   The distance (in kilometers) of the site from the center of the downtown Central Business District (CBD) of the city in which the site is located. ELEVATION ABOVE MSL   The elevation (in meters) above the Mean Sea Level (MSL) of the site. EPA REGION   The EPA Region in which the site is located. ERROR CODE   Codes and descriptions for screening files errors. EST DAYS GR STD   Value computed for ozone and PM10 and is utilized to determine whether the standard is attained. It is computed whenever a measured value exceeds the standard value for the monitor year. The assumption is made that the missing data values are just as likely to exceed the standard as the reported values. EST DAYS GR STD EPA   Value computed for PM10 and is utilized to determine whether the standard is attained. It is computed whenever a measured value exceeds the standard value for the monitor year. The assumption is made that the missing data values are just as likely to exceed the standard as the reported values. This value will be equal to EST DAYS GR STD unless FIRST EXCEED CORRECTION and FIRST EXCEED CORRECTION-EPA are not equal. ESTIMATE OF ACCURACY   Estimate of how accurate the values of latitude and longitude have been located. This is used in conjunction with "LDP Unit Code", which expresses the unit of the accuracy estimate. EVENT   Descriptive information for an abnormal observation. EVENT FLAG   Flag that signifies an abnormal observation EVENT TYPE   Description of the type of event. EXCEED ALERT   Count of the number of times a monitor has measured values exceeding the EPA-established alert level for criteria pollutants. EXCEED STD PRI   Count of the number of times a monitor has measured values exceeding the primary National Ambient Air Quality Standards (NAAQS). EXCEED STD SEC   Count of the number of times a monitor has measured values exceeding the secondary National Ambient Air Quality Standards (NAAQS). EXCEPTIONAL DATA FLAG   Flag indicating whether or not exceptional event data is included in the transaction. FIRST EXCEED CORRECT   A code indicating whether or not a correction is needed to the calculation of estimated state exceedances. FIRST PM10 VIOL DATE   The first date on which raw data values exceeded standards for the PM10 monitor. FLAGGED VALUES   Count of the number of values that have been flagged as "special events" for the year.   G/H/I GEO ZIP   Intersection entity between ZIP CODE and CITY COUNTY. GEOM MEAN   Geometric Mean of the pollutant data values for the monitor year. GEOM STD DEV   Geometric Standard Deviation of the pollutant data values for the monitor year. HORIZONTAL DISTANCE   Distance (in meters) from the monitor?s probe to the probe?s support structure. HOURLY DAILY   The concentrations of various air pollutants as measured by air monitoring equipment. Hourly values are derived from air samples collected for time periods of less than 24 hours. daily values are collected for 24 hours or more. HOURLY DAILY HIST   Historical hourly data. HQ EVAL DATE   The date of the most recent headquarters evaluation of the site. INTERVAL   The sampling interval used for the monitoring activities. (A.k.a., Sampling Interval)   L/M/N LAND USE   The prevalent land use within 1/4 mile of the site. LATITUDE   The monitoring site's angular distance north or south of the equator measured in degrees. North latitude is coded as positive and south latitude is coded as negative. LDP LOCATION CODE   Code indicating where on the site latitude and longitude coordinates were obtained from. For air monitoring sites, this code will always be "M". LDP UNIT CODE   Code indicating the units of measure for "Estimate Of Accuracy" field. These codes were obtained from EPA?s Locational Data Policy (LDP). LOCATION DESCRIPTION   Textual description of the location on the site where the latitude or longitude coordinates were obtained. LOCATION SETTING   The type of environment in which the site is located LONGITUDE   The monitoring site's angular distance east or west of the prime meridian at Greenwich, England measured in degrees. West longitude is coded as a negative value. East longitude is coded as a positive value. MAX1 VALUE   The highest reading recorded for the year by a given monitor. MAX1 COLLECTION DATE   The date in which the "MAX1 VALUE" was measured. MAX1 COLLECTION HOUR   The hour of the day in which the "MAX1 VALUE" was measured. MAX2 VALUE   The second highest reading recorded for the year by a given monitor. MAX2 COLLECTION DATE   The date in which the "MAX2 VALUE" was measured. MAX2 COLLECTION HOUR   The hour of the day in which the "MAX2 VALUE" was measured. MAX3 VALUE   The third highest reading recorded for the year by a given monitor. MAX4 VALUE   The fourth highest reading recorded for the year by a given monitor. MAX4 VALUE   The fourth highest reading recorded for the year by a given monitor. MAX5 VALUE   The fifth highest reading recorded for the year by a given monitor. MEAS DATA GROUP   Measurements for precision and accuracy reporting. MEASUREMENT SCALE   The geographic scope of the measurements of air quality. MESSAGE   Information about screening file error messages. MET SITE TYPE   The type of meteorological station identified for the monitor. METHOD   A particular method for collecting and analyzing samples for the time period. METHOD COUNT   Count of the number of different methods used by a monitor for a given year. METHOD OF DETERMINATION   This is a code or acronym that identifies the method used to determine the latitude/longitude coordinates for the site. MIN SAMPLING FREQ   The minimum sampling frequency for PM10. MINIMUM   The lowest value measured by a monitor in a given year. MISS VALS ASSUM   The number of missing values that were assumed to be less than the National Ambient Air Quality Standards (NAAQS). MONITOR   The monitor to which the data applies. MONITOR AUDIT   Intersection entity between MONITOR and AUDIT. MONITOR COMMENT   Text of any comments the operators may have describing the monitor. MONITOR DESIGN VALUE   Design values stored by monitor and year. MONITOR OBJECTIVE   The primary reason for measuring air quality at the monitor. MONITOR OBJECTIVE CODE   A code indicating the primary reason for measuring air quality at the monitor. MONITOR TYPE   The administrative classification of the monitor. MONITOR TYPE CODE   The administrative classification of the monitor. MONITORING AREA   A geographic code that describes the geographic monitoring area for PM10 monitors. MONTH   Month of the year. MONTHLY SAMPLING SCHEDULE   Specifies the number of samples required within an indicated month. MSA   The Metropolitan Statistical Area in which the site is located. MSA COUNTY   Intersection between MSA and county. NON OVERLAP AVG   The number of Carbon Monoxide 8-hour running average violations with eight or more hours between violations for the monitor year. NUM SUB HALF MIN   Number of values that were at or below the detection limit of the monitor. Consequently, one-half the minimum detection limit value for the instrument was used in place of the reported values when calculating the summary statistics.   O/P OBS CNT   Number of observations recorded by a monitor in a given year. OBSTRUCTION TYPE   The type of obstruction responsible for the restricted air flow of a monitor. OPEN PATH   Description of open paths that are associated with a site. PARAMETER   A specific parameter being measured and/or analyzed. PCNT OBS   Percent of actual data values that were reported compared to the number of data values that could have been reported for the monitor year. PCNTILE   A value at the xth percentile level on a scale of 100 indicating that x percent of the raw data record data values are less than or equal to it for the monitor year. PERIOD   The time period within year to which an observation applies. PHOTOGRAPH   Descriptive information for any photograph/video that is stored in the system. POC   The Parameter Occurance Code (POC) is used to distinguish between two or more instruments or monitoring techniques measuring the same parameter at the same site. PREC GROUP   Raw data values reflect the precision of the measurement. PREC MO SUMMARY   Summary data about the precision audit results for one monitor for one year. PREC RO SUMMARY   Air quality reporting organization precision summary information. PREC SUM METHOD   PRECISION   Precision audit results for monitors for a pollutant. PROBE HEIGHT   Height (in meters) of a monitoring probe. PROBE LOCATION   The location of the monitor's probe . PROBE OBSTRUCTION   The type of obstruction at a monitor. PROJECT CLASSIFICATION   The type of sampling (population oriented, source oriented, etc.).   Q/R/S QA PLAN APPROVED IND   A code indicating whether or not an approved Quality Assurance (QA) plan has been implemented for this monitor. QA PLAN EFFECTIVE DATE   Date on which an approved QA plan was implemented. RAW DATA   The sample values reported by a monitor. RAW HISTORY SET   Stored raw data. REF METHOD USED DATE   Date on which a monitoring site began using an EPA-approved reference or equivalent sampling methodology. REF METHOD USED IND   An indicator describing whether or not a site uses an EPA-approved reference or equivalent sampling methodology. REGION EVALUATION DATE   The date of the most recent regional elevation of the site. REPORT   Codes and descriptions for standard reports. REPORT SELECTION   Storage of user's report selection criteria. REPORTING ORGANIZATION   The state organization that generates the precision and accuracy data and reports the data to EPA. REQ MON TIME   The number of required monitoring days for Oxidants or Ozone for the monitor ozone season, or the number of scheduled samples for PM10 for the monitor year. RSF EFF DATE STATE   Date on which the monitor began using the state defined Required Sampling Frequency (RSF). REQ SAMPLING FREQ STATE   A code indicating how often the state has determined a 24-hour sample will be taken to meet the regulatory requirements. ROAD TYPE   The type of road being described e.g. "arterial", "freeway", etc. ROAD DESCRIPTION   A description of the monitor's relationship to nearby streets. SAMPLING FREQUENCY   The amount of time that elapses between observations. SAMPLING INTERVAL   The sampling interval used for the monitoring activities. SAMPLING PERIOD   The time period during which sampling took place. SCALE   The ratio of the map or cartographic product to the true location. SCREEN FILE ACCESS   The type of access that a user has to a screening file. SCREEN FILE ERROR   Information about screening file errors. SCREEN TRANSACTION   Transactions from the batch update. SCREENING FILE   Information about a screening file. SCREENING GROUP   The group to which a user belongs. SHORT TERM COMP DATE   The date on which the state?s short term schedule was met. SHORT TERM SCH SAT   A code indicating whether the PM10 monitor and monitoring area have not yet satisfied the state?s short-term sampling schedule. SITE   The specific physical location and descriptive information for an air monitoring site. SITE COMMENTS   Text of any comments the operators may have about a monitoring site. SITE CRITERIA   The siting criteria as prescribed in the EPA monitoring regulations. SITE CRITERIA MET   A code indicating whether the EPA Siting Criteria has been met for a given monitor. STATE   The group of 50 states, U S territories, or foreign countries. STATE MONITOR SEASON   Describes a state's ozone monitoring season. STATE or LOCAL ID   A Site-ID used by the state or local air quality data system, if it does not use AIRS. STATUS 1 HR   One hour status design values. STATUS 8 HR   Eight hour status design values. STATUS CLASS CODE   Status class code. STATUS DESIGN VALUE   Design values that document status (non attainment). STATUS FILE   Information on the status area. STATUS XREF   Status cross reference file. STREET CODE   A code assigned to a street near the site. STREET NAME   Name of a street at or near a monitoring site. SUB HOURLY   The concentrations of various air pollutants as measured by air monitoring equipment. The values are measured on a less than 1 hour basis. SUB HOURLY HIST   Historical sub hourly data. SUMMARY METHOD   Method and units for an annual summary record. SURROGATE FLAG   Flag indicating whether a Total Suspended Particulate (TSP) monitor serves as a surrogate monitor for PM10.   T/U/V TANGENT STREET   Streets near the monitoring site. THRESHOLD   Maximum and minimum values that have been established for parameters. TRAFFIC SOURCE   Source of the traffic count. TRAFFIC FLOW   Estimated traffic flow (in vehicles per day). TRANS NEPHEL   Transmissometer/nephelometer data is a type of visibility data. UNIT   The dimensional system in which a pollutant concentration is expressed. UNRESTRICTED AIR FLOW   A code indicating whether or not the flow of air in the vicinity of the monitor?s probe is unrestricted by physical obstructions. URBAN AREA   The urban area in which a site is located. USAGE STATISTIC   Information used to provide statistics about the number of AQS users. USER PROFILE   Information about each registered user of the system. UTM EASTING   The horizontal distance (in meters) from the reference edge of the UTM zone for the site. UTM NORTHING   The vertical distance (in meters)from the equator. UTM ZONE   The Universal Transverse Mercator System zone in which a site is located. VALID DAYS   The number of valid days with raw data record data values for the year (for ozone, the monitoring season-year). VALIDITY FLAG   The reason for an abnormal observation. VERTICAL DISTANCE   The distance (in meters) from the probe?s inlet to the probe?s support structure.   W/X/Y/Z WORST SITE   For PM10 monitors, indicates whether or not it is a "worst site". YEAR   Year YEAR OF TRAFFIC FLOW   Year in which the "Traffic Flow" was obtained. YR WTD ARITH MEAN   The yearly weighted arithmetic mean of PM10 data values. ZIP CODE   Postal zip code

EPA Home | Privacy and Security Notice | Contact Us