← All datasets

# curated.env_air_sensor_summary
Harris County community air sensors (CAMP), one row per sensor with a year of PM2.5/PM10/VOC summary stats (30 rows; category: Environment; geometry column `geom` (Point, EPSG:4326))
Notes: 24 fixed sensors (fixed_site = true), mostly in county parks near the Ship Channel, east side, Katy and Hockley, plus mobile/emergency/collocated units (fixed_site = false; exclude them when comparing places). pm25_readings_over_35 = number of 15-minute readings above 35.4 ug/m3 (divide by 4 for hours). Raw low-cost sensor values: PM2.5 is not humidity-corrected and maxima include fireworks, fires and glitches, so prefer averages and exceedance counts over single maxima. VOC is total VOCs (photoionization), not any specific chemical. Only a yearly summary for now: no time series, so questions about specific days or wind can't be answered yet. Pair with curated.env_tri_release (industrial emitters), curated.env_concrete_batch_plant, 311 case_type 'Air Pollution', curated.census_tract_health (casthma, copd) and curated.census_tract_svi.

Fields (expression | type | filled/distinct in a sample | values or examples):
- sensor_name | text | 30/30 | e.g.: Bayport Pump Station; Boyce-Dorian Park; Little Cedar Bayou Park
- readings | integer | 30/30 | e.g.: 33905; 569; 5285
- first_reading | timestamp with time zone | 30/8 | values: 2025-09-15 17:15:00+00; 2025-09-16 19:00:00+00; 2026-02-25 16:30:00+00; 2026-02-25 16:15:00+00; 2026-02-25 16:00:00+00; 2026-08-10 17:15:00+00; 2025-10-09 14:15:00+00; 2026-03-06 17:30:00+00
- last_reading | timestamp with time zone | 30/10 | values: 2026-09-15 16:15:00+00; 2026-09-15 06:00:00+00; 2026-09-15 16:00:00+00; 2026-03-03 16:15:00+00; 2025-12-09 19:15:00+00; 2026-03-03 15:45:00+00; 2026-05-22 06:30:00+00; 2026-09-15 05:45:00+00; 2025-10-13 17:45:00+00; 2026-03-03 15:30:00+00
- pm25_avg | double precision | 28/28 | e.g.: 10.498568528814605; 14.798656237230647; 11.26950846472424
- pm25_max | double precision | 28/28 | e.g.: 129; 96.37; 381.99
- pm25_readings_over_35 | integer | 30/29 | e.g.: 0; 523; 493
- pm10_avg | double precision | 27/27 | e.g.: 8.202765012877691; 7.590441458110194; 11.036627865752898
- voc_avg | double precision | 29/29 | e.g.: 5.371160746066787; 53.39613074204945; 26.275548211508575
- voc_max | double precision | 29/29 | e.g.: 866.39; 805.68; 1207.07
- voc_nonzero_readings | integer | 30/29 | e.g.: 0; 13769; 20154
- fixed_site | boolean | 30/2 | values: true; false