Table: weatherkit_daily_forecast
WeatherKit Daily Forecast.
Examples
List all
select *from weatherkit_daily_forecast;Schema for weatherkit_daily_forecast
| Name | Type | Operators | Description |
|---|---|---|---|
| _ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
| condition_code | text | An enumeration value indicating the condition at the time. | |
| daytime_forecast | jsonb | The forecast between 7 AM and 7 PM for the day. | |
| forecast_end | timestamp with time zone | The ending date and time of the day. | |
| forecast_start | timestamp with time zone | The starting date and time of the day. | |
| 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. |
| max_uv_index | bigint | The maximum ultraviolet index value during the day. | |
| metadata | jsonb | Descriptive information about the weather data. | |
| moon_phase | text | The phase of the moon on the specified day. | |
| moonrise | timestamp with time zone | The time of moonrise on the specified day. | |
| moonset | timestamp with time zone | The time of moonset on the specified day. | |
| overnight_forecast | jsonb | The day part forecast between 7 PM and 7 AM for the overnight. | |
| precipitation_amount | double precision | The amount of precipitation forecasted to occur during the day, in millimeters. | |
| precipitation_chance | double precision | The chance of precipitation forecasted to occur during the day. | |
| precipitation_type | text | The type of precipitation forecasted to occur during the day. | |
| snowfall_amount | double precision | The depth of snow as ice crystals forecasted to occur during the day, in millimeters. | |
| solar_midnight | text | The time when the sun is lowest in the sky. | |
| solar_noon | text | The time when the sun is highest in the sky. | |
| sunrise | text | The time when the top edge of the sun reaches the horizon in the morning. | |
| sunrise_astronomical | text | The time when the sun is 18 degrees below the horizon in the morning. | |
| sunrise_civil | text | The time when the sun is 6 degrees below the horizon in the morning. | |
| sunrise_nautical | text | The time when the sun is 12 degrees below the horizon in the morning. | |
| sunset | text | The time when the top edge of the sun reaches the horizon in the evening. | |
| sunset_astronomical | text | The time when the sun is 18 degrees below the horizon in the evening. | |
| sunset_civil | text | The time when the sun is 6 degrees below the horizon in the evening. | |
| sunset_nautical | text | The time when the sun is 12 degrees below the horizon in the evening. | |
| temperature_max | double precision | The maximum temperature forecasted to occur during the day, in degrees Celsius. | |
| temperature_min | double precision | The minimum temperature forecasted to occur during the day, in degrees Celsius. |