Data.md

Data

Generated on 2024-05-22 for data in range 2024-05-14 00:00:00 to 2024-05-20 07:00:00.

The schema for the raw data is as follows:

• device_id (varchar): Unique identifier for the device.
• timestamp (bigint): Timestamp (unix milliseconds).
• temperature (double): Temperature (Celsius).
• humidity (double): Relative humidity reading (%).
• precipitation_accumulated (double): Total precipitation (millimeters).
• wind_speed (double): Wind speed (meters per second).
• wind_gust (double): Wind gust (meters per second).
• wind_direction (double): Wind direction (degrees).
• illuminance (double): Illuminance (lux).
• solar_irradiance (double): Solar irradiance (watts per square meter).
• fo_uv (double): UV-related index value.
• uv_index (double): UV index.
• precipitation_rate (double): Precipitation rate (millimeters per hour).
• pressure (double): Pressure (HectoPascals).
• name (varchar): Name of the device.
• utc_datetime (varchar): Timestamp from the raw data in UTC.
• model (varchar): Model of the device (either WXM WS1000 or WXM WS2000).
• cell_id (varchar): Cell ID of the device.
• lat (double): Latitude of the cell.
• lon (double): Longitude of the cell.

Most of the columns above are included in the mean calculations, and there are three additional columns for aggregates:

• total_precipitation (double): Total precipitation_accumulated (millimeters).
• number_of_devices (int): Count of unique device_id values.
• cell_id_mode (varchar): Most common cell_id value.

And three additional columns for run metadata:

• job_date (varchar): Date the job was run.
• range_start (bigint): Start of the query range (unix milliseconds).
• range_end (bigint): End of the query range (unix milliseconds).

Averages & cumulative metrics

Job Date	Range Start	Range End	Number Of Devices	Cell Id Mode	Total Precipitation	Temperature	Humidity	Precipitation Accumulated
2024-05-22	1715644800000	1716188400000	5162	871eda743ffffff	131338642797.459	18.646	73.016	1194.026

Wind Speed	Wind Gust	Wind Direction	Illuminance	Solar Irradiance	Fo Uv	Uv Index	Precipitation Rate	Pressure
0.721	1.001	176.864	347615.420	2738.184	772.305	1.144	0.082	989.723

Precipitation accumulated maps

North America

South America

Africa

Europe

Asia

Australia

Historical plots

Number Of Devices

Total Precipitation

Temperature

Humidity

Precipitation Accumulated

Wind Speed

Wind Gust

Wind Direction

Illuminance

Solar Irradiance

Fo Uv

Uv Index

Precipitation Rate

Pressure