steampipe plugin install ellisvalentiner/weatherkitsteampipe plugin install ellisvalentiner/weatherkit

weatherkit_availability weatherkit_current_weather weatherkit_daily_forecast weatherkit_daily_forecast_weather weatherkit_hourly_forecast weatherkit_hourly_forecast_weather weatherkit_next_hour_forecast weatherkit_next_hour_forecast_weather weatherkit_weather_alert

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.