Beach Weather Stations 🏖️🌊👓

Exploring Beach weather Stations

@kaggle.sanjanchaudhari_beach_weather_stations

Table List

1 table(3.67 MB)

Beach Weather Stations Automated Sensors

Beach Weather Stations Automated Sensors

@kaggle.sanjanchaudhari_beach_weather_stations.beach_weather_stations_automated_sensors

3.67 MB
156051 rows
18 columns

station_name Station Name	measurement_timestamp Measurement Timestamp	air_temperature Air Temperature	wet_bulb_temperature Wet Bulb Temperature	humidity Humidity	total_rain Total Rain	wind_direction Wind Direction	wind_speed Wind Speed	maximum_wind_speed Maximum Wind Speed	barometric_pressure Barometric Pressure	solar_radiation Solar Radiation	heading Heading	battery_life Battery Life	measurement_timestamp_label Measurement Timestamp Label	measurement_id Measurement ID
63rd Street Weather Station	09/27/2018 10:00:00 AM	16.4	12.2	61	260.3	231	2.5	4.7	996.3	484	356	11.9	09/27/2018 10:00 AM	63rdStreetWeatherStation201809271000
63rd Street Weather Station	09/27/2018 11:00:00 AM	17.1	11.5	51	260.3	244	3.6	5.7	995.4	468	356	11.9	09/27/2018 11:00 AM	63rdStreetWeatherStation201809271100
63rd Street Weather Station	09/27/2018 01:00:00 PM	18.2	12.4	51	260.3	248	3.1	5.3	994.8	377	355	11.9	09/27/2018 1:00 PM	63rdStreetWeatherStation201809271300
Foster Weather Station	09/27/2018 01:00:00 PM	17.89		39		249	1.4	2.3	993.6			15.1	09/27/2018 1:00 PM	FosterWeatherStation201809271300
63rd Street Weather Station	09/27/2018 03:00:00 PM	19.5	13	47	260.3	249	3.1	5.7	992.9	461	355	11.9	09/27/2018 3:00 PM	63rdStreetWeatherStation201809271500
Foster Weather Station	09/27/2018 03:00:00 PM	19.39		37		209	4	4.6	991.9			15	09/27/2018 3:00 PM	FosterWeatherStation201809271500
63rd Street Weather Station	09/27/2018 04:00:00 PM	20.2	12.2	38	260.3	212	4.1	9.2	992.3	412	355	11.9	09/27/2018 4:00 PM	63rdStreetWeatherStation201809271600
Foster Weather Station	09/27/2018 04:00:00 PM	19.78		33		178	2.4	4.4	991.5			15.1	09/27/2018 4:00 PM	FosterWeatherStation201809271600
63rd Street Weather Station	09/27/2018 05:00:00 PM	20.4	12.4	38	260.3	212	2.7	6	991.7	37	355	11.9	09/27/2018 5:00 PM	63rdStreetWeatherStation201809271700
Foster Weather Station	09/27/2018 05:00:00 PM	20		33		200	2.5	3.1	990.9			15.1	09/27/2018 5:00 PM	FosterWeatherStation201809271700


CREATE TABLE beach_weather_stations_automated_sensors (
  "station_name" VARCHAR,
  "measurement_timestamp" VARCHAR,
  "air_temperature" DOUBLE,
  "wet_bulb_temperature" DOUBLE,
  "humidity" BIGINT,
  "rain_intensity" DOUBLE,
  "interval_rain" DOUBLE,
  "total_rain" DOUBLE,
  "precipitation_type" DOUBLE,
  "wind_direction" BIGINT,
  "wind_speed" DOUBLE,
  "maximum_wind_speed" DOUBLE,
  "barometric_pressure" DOUBLE,
  "solar_radiation" BIGINT,
  "heading" DOUBLE,
  "battery_life" DOUBLE,
  "measurement_timestamp_label" VARCHAR,
  "measurement_id" VARCHAR
);