Air Monitoring Station Locations & Attributes
State of New York
@usgov.state_of_new_york_air_monitoring_station_locations_attributes
State of New York
@usgov.state_of_new_york_air_monitoring_station_locations_attributes
CREATE TABLE table_1 (
"region" BIGINT,
"site_id" VARCHAR,
"monitor_type" VARCHAR,
"county" VARCHAR,
"site_name" VARCHAR,
"air_quality_system_id" BIGINT,
"latitude" DOUBLE,
"longitude" DOUBLE,
"ozone" VARCHAR,
"so2" VARCHAR,
"nox" VARCHAR,
"co" VARCHAR,
"pm_2_5" VARCHAR,
"cpm_2_5" VARCHAR,
"pm_10" VARCHAR,
"cpm_10" VARCHAR,
"lead" VARCHAR,
"speciation" VARCHAR,
"continuous_speciation" VARCHAR,
"metals" VARCHAR,
"toxics" VARCHAR,
"carbonyls" VARCHAR,
"acid_rain" VARCHAR,
"pams" VARCHAR,
"mercury" VARCHAR,
"location" VARCHAR,
"georeference" VARCHAR
);
Anyone who has the link will be able to view this.