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_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.