Air Quality Monitoring From EcoCity
Air Quality Monitoring in Vinnytsia city and region
@kaggle.vbmokin_air_quality_monitoring_from_ecocity
Air Quality Monitoring in Vinnytsia city and region
@kaggle.vbmokin_air_quality_monitoring_from_ecocity
CREATE TABLE ecocity_1172_20211128160501_2020_11_28_2021_11_28 (
"id_station" BIGINT,
"indicator_code" VARCHAR,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE,
"datetime" TIMESTAMP,
"source" VARCHAR
);
CREATE TABLE ecocity_1183_20211127092801_2020_11_27_2021_11_27 (
"id_station" BIGINT,
"indicator_code" VARCHAR,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE,
"datetime" TIMESTAMP,
"source" VARCHAR
);
CREATE TABLE ecocity_1315_20211127092901_2020_11_27_2021_11_27 (
"id_station" BIGINT,
"indicator_code" VARCHAR,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE,
"datetime" TIMESTAMP,
"source" VARCHAR
);
CREATE TABLE ecocity_1315_20220211200901_2021_11_11_2022_02_11 (
"id_station" BIGINT,
"indicator_code" VARCHAR,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE,
"datetime" TIMESTAMP,
"source" VARCHAR
);
CREATE TABLE ecocity_337_20211127092201_2020_11_27_2021_11_27 (
"id_station" BIGINT,
"indicator_code" VARCHAR,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE,
"datetime" TIMESTAMP,
"source" VARCHAR
);
CREATE TABLE ecocity_650_20211128160601_2020_11_28_2021_11_28 (
"id_station" BIGINT,
"indicator_code" VARCHAR,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE,
"datetime" TIMESTAMP,
"source" VARCHAR
);
CREATE TABLE ecocity_761_20211127092301_2020_11_27_2021_11_27 (
"id_station" BIGINT,
"indicator_code" VARCHAR,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE,
"datetime" TIMESTAMP,
"source" VARCHAR
);
CREATE TABLE ecocity_767_20211127092401_2020_11_27_2021_11_27 (
"id_station" BIGINT,
"indicator_code" VARCHAR,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE,
"datetime" TIMESTAMP,
"source" VARCHAR
);
CREATE TABLE ecocity_774_20211127092501_2020_11_27_2021_11_27 (
"id_station" BIGINT,
"indicator_code" VARCHAR,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE,
"datetime" TIMESTAMP,
"source" VARCHAR
);
CREATE TABLE ecocity_790_20211127092601_2020_11_27_2021_11_27 (
"id_station" BIGINT,
"indicator_code" VARCHAR,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE,
"datetime" TIMESTAMP,
"source" VARCHAR
);
CREATE TABLE ecocity_848_20211127092701_2020_11_27_2021_11_27 (
"id_station" BIGINT,
"indicator_code" VARCHAR,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE,
"datetime" TIMESTAMP,
"source" VARCHAR
);
CREATE TABLE ecocity_20_minute_1172_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1172_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1315_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1315_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1434_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1434_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1488_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1523_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1523_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_154_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_154_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1596_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1596_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1612_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1612_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1769_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1769_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1811_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1811_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1813_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1813_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1825_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1825_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1830_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1830_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1834_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1834_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1864_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1864_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1866_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1866_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1872_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1872_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1874_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1874_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1876_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_1876_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_197_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_197_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_337_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_337_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_400_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_400_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_564_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_564_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_566_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_566_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_611_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_611_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_650_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_650_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_767_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_767_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_774_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_774_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_790_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_790_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_848_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_20_minute_848_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_about_stations_2021 (
"id_saveecobot" DOUBLE,
"id_ecocity" BIGINT,
"network" VARCHAR,
"locality" VARCHAR,
"address" VARCHAR,
"start_date" VARCHAR,
"lat" DOUBLE,
"lng" DOUBLE,
"notes" VARCHAR,
"source" VARCHAR
);
CREATE TABLE ecocity_archive_651_561_2024_03_25_2024_05_10 (
"n_1315" BIGINT,
"n_49_23327_28_409161" VARCHAR,
"n_2024_03_25" TIMESTAMP,
"n_01" BIGINT,
"n_18" BIGINT,
"pm1_0" VARCHAR,
"ug_m3" VARCHAR,
"n_26_8422" DOUBLE
);
CREATE TABLE ecocity_daily_1172_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1172_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1315_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1315_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1434_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1434_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1488_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1523_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1523_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_154_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_154_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1596_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1596_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1612_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1612_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1769_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1769_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1811_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1811_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1813_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1813_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1825_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1825_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1830_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1830_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1834_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1834_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1864_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1864_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1866_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1866_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1872_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1872_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1874_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1874_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1876_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_1876_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_197_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_197_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_337_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_337_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_400_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_400_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_564_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_564_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_566_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_566_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_611_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_611_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_650_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_650_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_767_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_767_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_774_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_774_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_790_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_790_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_848_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_daily_848_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1172_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1172_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1315_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1315_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1434_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1434_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1488_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1523_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1523_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_154_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_154_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1596_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1596_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1612_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1612_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1769_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1769_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1811_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1811_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1813_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1813_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1825_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1825_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1830_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1830_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1834_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1834_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1864_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1864_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1866_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1866_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1872_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1872_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1874_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1874_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1876_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_1876_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_197_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_197_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_337_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_337_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_400_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_400_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_564_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_564_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_566_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_566_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_611_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_611_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_650_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_650_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_767_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_767_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_774_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_774_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_790_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_790_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_848_2023 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_hourly_848_2024 (
"id_station" BIGINT,
"datetime" TIMESTAMP,
"indicator_name" VARCHAR,
"indicator_dimension" VARCHAR,
"value" DOUBLE
);
CREATE TABLE ecocity_stations_2023 (
"id" BIGINT,
"location" VARCHAR,
"address" VARCHAR,
"lat" DOUBLE,
"lng" DOUBLE,
"notes" VARCHAR,
"source" VARCHAR
);
CREATE TABLE ecocity_stations_2024 (
"id" BIGINT,
"location" VARCHAR,
"address" VARCHAR,
"lat" DOUBLE,
"lng" DOUBLE,
"notes" VARCHAR,
"source" VARCHAR
);
Anyone who has the link will be able to view this.