Hyperlocal Temperature Monitoring
City of New York
@usgov.city_of_new_york_hyperlocal_temperature_monitoring
City of New York
@usgov.city_of_new_york_hyperlocal_temperature_monitoring
CREATE TABLE table_1 (
"sensor_id" VARCHAR,
"airtemp" DOUBLE,
"day" TIMESTAMP,
"hour" BIGINT,
"latitude" DOUBLE,
"longitude" DOUBLE,
"year" BIGINT,
"install_type" VARCHAR,
"borough" VARCHAR,
"ntacode" VARCHAR
);
Anyone who has the link will be able to view this.