Table: weatherkit_hourly_forecast
WeatherKit Hourly Forecast.
Examples
List all
select *from weatherkit_hourly_forecast;Schema for weatherkit_hourly_forecast
| Name | Type | Operators | Description |
|---|---|---|---|
| _ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
| cloud_cover | double precision | The percentage of the sky covered with clouds during the period, from 0 to 1. | |
| condition_code | text | An enumeration value indicating the condition at the time. | |
| daylight | boolean | Indicates whether the hour starts during the day or night. | |
| forecast_start | timestamp with time zone | The starting date and time of the forecast. | |
| humidity | double precision | The relative humidity at the start of the hour, from 0 to 1. | |
| latitude | text | = | A numeric value indicating the latitude of the coordinate between -90 and 90. |
| longitude | text | = | A numeric value indicating the longitude of the coordinate between -180 and 180. |
| metadata | jsonb | Descriptive information about the weather data. | |
| precipitation_amount | double precision | The amount of precipitation forecasted to occur during period, in millimeters. | |
| precipitation_chance | double precision | The chance of precipitation forecasted to occur during the hour, from 0 to 1. | |
| precipitation_type | text | The type of precipitation forecasted to occur during the period. | |
| pressure | double precision | The sea-level air pressure, in millibars. | |
| pressure_trend | text | The direction of change of the sea-level air pressure. | |
| snowfall_intensity | double precision | The rate at which snow crystals are falling, in millimeters per hour. | |
| temperature | double precision | The temperature at the start of the hour, in degrees Celsius. | |
| temperature_apparent | double precision | The feels-like temperature when considering wind and humidity, at the start of the hour, in degrees Celsius. | |
| temperature_dew_point | double precision | The temperature at which relative humidity is 100% at the top of the hour, in degrees Celsius. | |
| uv_index | bigint | The level of ultraviolet radiation at the start of the hour. | |
| visibility | double precision | The distance at which terrain is visible at the start of the hour, in meters. | |
| wind_direction | bigint | The direction of the wind at the start of the hour, in degrees. | |
| wind_gust | double precision | The maximum wind gust speed during the hour, in kilometers per hour. | |
| wind_speed | double precision | The wind speed at the start of the hour, in kilometers per hour. |