State O3, NO2, SO2, PB, VRP
State area designations reflect data from the prior three-year period as compared with the State ambient air quality standard for each pollutant. They are consistent with the designation criteria contained in the California Code of Regulations, title 17, sections 70300 through 70306, and Appendices 1 through 3, thereof.
The State O3_NO2_SO2_PB_VRP designations layer is a polygon coverage showing area designations as required under Health and Safety Code section 39608 for ozone, nitrogen dioxide, sulfur dioxide, lead, and visibility reducing particles. The designations are consistent with the criteria established in the California Code of Regulations, title 17, sections 70300 through 70306, and Appendices 1 through 3, thereof. There are three possible designation categories for lead (attainment, nonattainment, and unclassified), and there are four possible designation categories for ozone, nitrogen dioxide, sulfur dioxide, and visibility reducing particles (attainment, nonattainment, nonattainment-transitional, and unclassified). In addition, ozone nonattainment areas have been assigned a classification, commensurate with the severity of their air quality problem, under Health and Safety Code section 40921.5. The State area designations are reviewed annually and approved by the State Air Resources Board.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"bayareametro-gov/state-o3-no2-so2-pb-vrp-8ypi-wma6\".\"state_o3_no2_so2_pb_vrp\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
