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_current_weather

Get the current weather conditions for the specified location.

The weatherkit_current_weather table can be used to query the current weather for the requested location. You must specify location in the where or join clause using the latitude and longitude columns.

Examples

Get the current weather for Ann Arbor, MI

select
  *
from
  weatherkit_current_weather
where
  latitude = '42.281'
  and longitude = '-83.743';

Get the temperature, humidity, and dew point

select
  temperature,
  humidity,
  temperature_dew_point
from
  weatherkit_current_weather
where
  latitude = '42.281'
  and longitude = '-83.743';

Get the temperature in degrees Fahrenheit

select
  temperature * 9 / 5 + 32.from weatherkit_current_weather
where
  latitude = '42.281'
  and longitude = '-83.743';

Get the wind direction, gust, and speed

select
  wind_direction,
  wind_gust,
  wind_speed
from
  weatherkit_current_weather
where
  latitude = '42.281'
  and longitude = '-83.743';

Schema for weatherkit_current_weather

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
as_of	timestamp with time zone		The date and time.
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		A Boolean value indicating whether there is daylight.
humidity	double precision		The relative humidity, 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_intensity	double precision		The precipitation intensity, in millimeters per hour.
pressure	double precision		The sea level air pressure, in millibars.
pressure_trend	text		The direction of change of the sea-level air pressure.
temperature	double precision		The current temperature, in degrees Celsius.
temperature_apparent	double precision		The feels-like temperature when factoring wind and humidity, in degrees Celsius.
temperature_dew_point	double precision		The temperature at which relative humidity is 100%, in Celsius.
uv_index	bigint		The level of ultraviolet radiation.
visibility	double precision		The distance at which terrain is visible, in meters.
wind_direction	bigint		The direction of the wind, in degrees.
wind_gust	double precision		The maximum wind gust speed, in kilometers per hour.
wind_speed	double precision		The wind speed, in kilometers per hour.