Air_Quality_Readings Air_Quality_Readings
Logo

Corporate Production GIS Metadata

Layer Name: Air_Quality_Readings

General Information

Layer Name: Air_Quality_Readings
# of Features: 404483
Status: ACTIVE
Layer Source: GIS_DATA.AIR_QUALITY_READING
Layer Quality: Good
Feature Accuracy: +/- 3m
Type:
Description: Air Quality Reading
Projection: NAD 83 UTM Zone 17N (EPSG 26917)
Disclaimer: The City of Kitchener assumes no responsibility for the accuracy of the provided data. Any use of this information is done so at the users risk. Good survey practices must be applied when utilizing this information. The City of Kitchener and its partners have created this data for information purposes on an as-is and as available basis and is under no circumstances a substitute for a Legal Survey. The City does not make any representations or warranty, express or implied, concerning the accuracy, quality, likely results, or reliability of the use of the data. The City of Kitchener assumes no responsibility for any errors and is not liable for any damages of any kind resulting from the use of, or reliance on, the information and material contained in this layer. All information should be verified independently before being used or relied on. Users are encouraged to contact the City of Kitchener to ensure the accuracy of the information provided by Kitchener.

Source and Contraints

Source Map Label: Air Quality Reading: Corporate Services - Technology Innovation and Services - GDA (Current)
History:
Original Source: TIS - GeoSpatial Data and Analytics
Original Source Process:
Maintenance:
Current Info Source:
Outstanding Issues:
Update Frequency: ON DEMAND

Data Fields & Domain Information

Air_Quality_Readings

Column Name Alias Data Type Comments Domain Name Default value Domain Values
OBJECTID OBJECTID NUMBER ESRI system maintained integer field used to uniquely identify rows in tables in a geodatabase. Note that OBJECTIID values change upon export or import of the data and should not be used as a primary field for searching or identifying records.
SHAPE SHAPE ST_GEOMETRY ESRI system maintained field. Stores the geometry type and geometry of the feature.
LOCATION Location VARCHAR2 Open text field that describes the location of the feature in more detail.
LOCATION_NUMBER Location number VARCHAR2
LOCATION_OWNER_NUMBER Location owner number NUMBER
LOCATION_NAME Location name VARCHAR2
LOCATION_NOTES Location notes VARCHAR2
LOCATION_LATITUDE Location latitude NUMBER
LOCATION_LONGITUDE Location longitude NUMBER
LOCATION_ALTITUDE Location altitude NUMBER
POD_NUMBER Pod number NUMBER
POD_SERIAL_NUMBER Pod serial number VARCHAR2
POD_PART_NUMBER Pod part number VARCHAR2
POD_HEATED_INLET Pod heated inlet VARCHAR2
POD_OWNER_NUMBER Pod owner number NUMBER
POD_LATITUDE Pod latitude NUMBER
POD_LONGITUDE Pod longitude NUMBER
POD_ALTITUDE Pod altitude NUMBER
POD_AML_DATA_SERVICE Pod AML data service VARCHAR2
POD_FIRMWARE_VERSION Pod firmware version VARCHAR2
FAST_TRANSMISSION Fast transmission VARCHAR2
LAST_CONNECTION Last connection TIMESTAMP(6)
SIM_NUMBER SIM number VARCHAR2
GPS_PRESENT GPS present NUMBER
GPS_STATUS GPS status NUMBER
GPS_STATUS_DESCRIPTION GPS status description VARCHAR2
GAS_PROTOCOL_VERSION Gas protocol version VARCHAR2
GAS_P1 Gas sample frequency in seconds NUMBER
GAS_P2 Gas reading interval in seconds NUMBER
GAS_P3 Gas transmission frequency in seconds NUMBER
RE_READ_GAS_REQUEST Reread gas request VARCHAR2
LAST_GAS_READING_NUMBER Last gas reading number VARCHAR2
NEXT_GAS_REQUEST Next gas request VARCHAR2
PARTICLE_PROTOCOL_VERSION Particle protocol version VARCHAR2
PARTICLE_P1 Particle pump run time in seconds NUMBER
PARTICLE_P2 Particl reading interval time in seconds NUMBER
PARTICLE_P3 Particle transmission frequency in seconds NUMBER
RE_READ_PARTICLE_REQUEST Reread particle request VARCHAR2
LAST_PARTICLE_READING_NUMBER Last particle reading number VARCHAR2
NEXT_PARTICLE_REQUEST Next particle request VARCHAR2
PROJECT_NUMBER Project number NUMBER
PROJECT_NAME Project name VARCHAR2
PROJECT_NOTES Project notes VARCHAR2
CUSTOMER_NUMBER Customer number NUMBER
CUSTOMER_NAME Customer name VARCHAR2
OWNER_NUMBER Owner number NUMBER
OWNER_NAME Owner name VARCHAR2
READING_DATESTAMP_UTC UTC date time TIMESTAMP(6)
TEMPERATURE_C Temperature in celcius NUMBER
PRESSURE_MBAR Pressure in millibars NUMBER
HUMIDITY_RH Percent relative humidity NUMBER
NOISE_LEVEL_DB Noise level in decibels NUMBER
PEAK_NOISE_DB Peak noise level in decibels NUMBER
GAS_READING_NUMBER Gas reading number VARCHAR2
GAS_BATTERY_VOLTAGE Gas battery voltage NUMBER
CO_SENSOR_SERIAL_NUMBER CO sensor serial number VARCHAR2
CO_STATE CO state VARCHAR2
CO_PRESCALED_PPB Prescaled CO ppb NUMBER
CO_SLOPE CO slope NUMBER
CO_OFFSET CO offset NUMBER
CO_SCALED_PPB Scaled CO ppb NUMBER
CO_UNITS CO units VARCHAR2
NO_SENSOR_SERIAL_NUMBER NO sensor serial number VARCHAR2
NO_STATE NO state VARCHAR2
NO_PRESCALED_PPB Prescaled NO ppb NUMBER
NO_SLOPE NO slope NUMBER
NO_OFFSET NO offset NUMBER
NO_SCALED_PPB Scaled NO ppb NUMBER
NO_UNITS NO units VARCHAR2
SO2_SENSOR_SERIAL_NUMBER SO2 sensor serial number VARCHAR2
SO2_STATE SO2 state VARCHAR2
SO2_PRESCALED_PPB Prescaled SO2 ppb NUMBER
SO2_SLOPE SO2 slope NUMBER
SO2_OFFSET SO2 offset NUMBER
SO2_SCALED_PPB Scaled SO2 ppb NUMBER
SO2_UNITS SO2 units VARCHAR2
NO2_SENSOR_SERIAL_NUMBER NO2 sensor serial number VARCHAR2
NO2_STATE NO2 state VARCHAR2
NO2_PRESCALED_PPB Prescaled NO2 ppb NUMBER
NO2_SLOPE NO2 slope NUMBER
NO2_OFFSET NO2 offset NUMBER
NO2_SCALED_PPB Scaled NO2 ppb NUMBER
NO2_UNITS NO2 units VARCHAR2
O3_SENSOR_SERIAL_NUMBER O3 sensor serial number VARCHAR2
O3_STATE O3 state VARCHAR2
O3_PRESCALED_PPB Prescaled O3 ppb NUMBER
O3_SLOPE O3 slope NUMBER
O3_OFFSET O3 offset NUMBER
O3_SCALED_PPB Scaled O3 ppb NUMBER
O3_UNITS O3 units VARCHAR2
H2S_SENSOR_SERIAL_NUMBER H2S sensor serial number VARCHAR2
H2S_STATE H2S state VARCHAR2
H2S_PRESCALED_PPB Prescaled H2S ppb NUMBER
H2S_SLOPE H2S slope NUMBER
H2S_OFFSET H2S offset NUMBER
H2S_SCALED_PPB Scaled H2S ppb NUMBER
H2S_UNITS H2S units VARCHAR2
EO_SENSOR_SERIAL_NUMBER EO sensor serial number VARCHAR2
EO_STATE EO state VARCHAR2
EO_PRESCALED_PPM Prescaled EO ppm NUMBER
EO_SLOPE EO slope NUMBER
EO_OFFSET EO offset NUMBER
EO_SCALED_PPM Scaled EO ppm NUMBER
EO_UNITS EO units VARCHAR2
CO2_SENSOR_SERIAL_NUMBER CO2 sensor serial number VARCHAR2
CO2_STATE CO2 state VARCHAR2
CO2_PRESCALED_PPM Prescaled CO2 ppm NUMBER
CO2_SLOPE CO2 slope NUMBER
CO2_OFFSET CO2 offset NUMBER
CO2_SCALED_PPM Scaled CO2 ppm NUMBER
CO2_UNITS CO2 units VARCHAR2
PARTICLE_READING_NUMBER Particle reading number VARCHAR2
PARTICLE_READING_STATUS Particle reading status VARCHAR2
PARTICLE_BATTERY_VOLTAGE Particle battery voltage NUMBER
PARTICLE_BATTERY_LOW Particle battery low VARCHAR2
PARTICLE_SUPER_CAP_VOLTAGE Particle super capacity voltage NUMBER
PARTICLE_MODEM_OVERLAP Particle modem overlap VARCHAR2
PM10_PRESCALED_UGM3 Prescaled particles less than or equal to 10 um (microns) in diameter in ug/m3 (microgram per cubic metre) NUMBER
PM10_SLOPE Particles less than or equal to 10 um (microns) in diameter in ug/m3 (microgram per cubic metre) slope NUMBER
PM10_OFFSET Particles less than or equal to 10 um (microns) in diameter in ug/m3 (microgram per cubic metre) offset NUMBER
PM10_SCALED_UGM3 Scaled particles less than or equal to 10 um (microns) in diameter in ug/m3 (microgram per cubic metre) NUMBER
PM4_PRESCALED_UGM3 Prescaled particles less than or equal to 4 um (microns in diameter) in ug/m3 (microgram per cubic metre) NUMBER
PM4_SLOPE Particles less than or equal to 4 um (microns) in diameter in ug/m3 (microgram per cubic metre) slope NUMBER
PM4_OFFSET Particles less than or equal to 4 um (microns) in diameter in ug/m3 (microgram per cubic metre) offset NUMBER
PM4_SCALED_UGM3 Scaled particles less than or equal to 4 um (microns) in diameter in ug/m3 (microgram per cubic metre) NUMBER
PM2_5_PRESCALED_UGM3 Prescaled particles less than or equal to 2.5 um (microns) in diameter in ug/m3 (microgram per cubic metre) NUMBER
PM2_5_SLOPE Particles less than or equal to 2.5 um (microns) in diameter in ug/m3 (microgram per cubic metre) slope NUMBER
PM2_5_OFFSET Particles less than or equal to 2.5 um (microns) in diameter in ug/m3 (microgram per cubic metre) offset NUMBER
PM2_5_SCALED_UGM3 Scaled particles less than or equal to 2.5 um (microns) in diameter in ug/m3 (microgram per cubic metre) NUMBER
PM1_PRESCALED_UGM3 Prescaled particles less than or equal to 1 um (microns in diameter) in ug/m3 (microgram per cubic metre) NUMBER
PM1_SLOPE Particles less than or equal to 1 um (microns) in diameter in ug/m3 (microgram per cubic metre) slope NUMBER
PM1_OFFSET Particles less than or equal to 1 um (microns) in diameter in ug/m3 (microgram per cubic metre) offset NUMBER
PM1_SCALED_UGM3 Scaled particles less than or equal to 1 um (microns) in diameter in ug/m3 (microgram per cubic metre) NUMBER
PM_TPC_SLOPE Particles TPC ug/m3 (microgram per cubic metre) slope NUMBER
PM_TPC_OFFSET Particles TPC ug/m3 (microgram per cubic metre) offset NUMBER
PM_TOTAL_PRESCALED_UGM3 Prescaled particles total ug/m3 (microgram per cubic metre) NUMBER
PM_TOTAL_SLOPE Particles total ug/m3 (microgram per cubic metre) slope NUMBER
PM_TOTAL_OFFSET Particles total ug/m3 (microgram per cubic metre) offset NUMBER
PM_TOTAL_SCALED_UGM3 Scaled particles total ug/m3 (microgram per cubic metre) NUMBER
AQHI Air quality health index NUMBER
QUERY_FIELD Query field VARCHAR2
IN_DASHBOARD Reading used in dashboard VARCHAR2
PM_TPC_PRESCALED_COUNTM3 Prescaled particle count/m3 (particle count per cubic metre) NUMBER
PM_TPC_SCALED_COUNTM3 Scaled particle count/m3 (particle count per cubic metre) NUMBER
NOX_PPB Total NO and NO2 in ppb NUMBER