Arguments

Name	Description	Default
location R	The location from which to retrieve the current weather (state/city, US Zip Code, country/city, lat,long, airport code, pws:PWS id

SQL Call

SELECT * FROM weather.almanac WHERE location = 'FL/boca raton'
exec weather.almanac 'FL/boca raton' -- by US state/city
exec weather.almanac '33414' -- by US zip code
exec weather.almanac 'KORD' -- by airport code
exec weather.almanac '41.87208,-87.65784' -- by lat/long

Http Call

/bsc/weather/almanac

Output Columns

String airport_code
String temp_high_normal_F
String temp_high_normal_C
String temp_high_record_F
String temp_high_record_C
String temp_high_recordyear
String temp_low_normal_F
String temp_low_normal_C
String temp_low_record_F
String temp_low_record_C
String temp_low_recordyear

Arguments

Name	Description	Default
location R	The location from which to retrieve the current weather (country/city, US Zip Code, country/city, lat,long, airport code, pws:PWS id

SQL Call

SELECT * FROM weather.astronomy WHERE location = 'United States/boca raton'
exec weather.astronomy 'United States/boca raton' -- by US state/city

Http Call

/bsc/weather/astronomy

Output Columns

String moon_phase_precentIlluminated
String moon_phase_ageOfMoon
String moon_phase_current_time_hour
String moon_phase_current_time_minute
String moon_phase_sunrise_hour
String moon_phase_sunrise_minute
String moon_phase_sunset_hour
String moon_phase_sunset_minute
String sun_phase_sunrise_hour
String sun_phase_sunrise_minute
String sun_phase_sunset_hour
String sun_phase_sunset_minute

Arguments

Name	Description	Default
location R	The location from which to retrieve the current weather (state/city, US Zip Code, country/city, lat,long, airport code, pws:PWS id

SQL Call

SELECT * FROM weather.current_conditions WHERE location = 'FL/boca raton'
exec weather.current_conditions 'FL/boca raton' -- by US state/city
exec weather.current_conditions 'Monaco/Monte Carlo' -- by country/city
exec weather.current_conditions '33414' -- by US zip code
exec weather.current_conditions 'KORD' -- by airport code
exec weather.current_conditions '41.87208,-87.65784' -- by lat/long

Http Call

/bsc/weather/current_conditions

Output Columns

String current_observation_id
String estimated
String station_id
String observation_time
String observation_time_rfc822
String observation_epoch
String local_time_rfc822
String local_epoch
String local_tz_short
String local_tz_long
String local_tz_offset
String weather
String temperature_string
String temp_f
String temp_c
String relative_humidity
String wind_string
String wind_dir
String wind_degrees
String wind_mph
String wind_gust_mph
String wind_kph
String wind_gust_kph
String pressure_mb
String pressure_in
String dewpoint_string
String dewpoint_f
String dewpoint_c
String heat_index_string
String heat_index_f
String heat_index_c
String windchill_string
String windchill_f
String windchill_c
String feelslike_string
String feelslike_f
String feelslike_c
String visibility_mi
String visibility_km
String solarradiation
String UV
String precip_1hr_string
String precip_1hr_in
String precip_1hr_metric
String precip_today_string
String precip_today_in
String precip_today_metric
String icon
String icon_url
String forecast_url
String history_url
String ob_url
String response_id

Arguments

Name	Description	Default
location R	The location from which to retrieve the current weather (state/city, US Zip Code, country/city, lat,long, airport code, pws:PWS id

SQL Call

SELECT * FROM weather.current_conditions_light WHERE location = 'Fort Lauderdale'

Http Call

/bsc/weather/current_conditions_light

Output Columns

String weather
String temperature_string
String icon_url

Arguments

Name	Description	Default
location R	The location from which to retrieve the current weather (state/city, US Zip Code, country/city, lat,long, airport code, pws:PWS id

SQL Call

SELECT * FROM weather.forecast WHERE location = 'FL/boca raton' -- by US state/city
exec weather.forecast 'FL/boca raton' -- by US state/city
exec weather.forecast '33414' -- by US zip code
exec weather.forecast 'KORD' -- by airport code
exec weather.forecast '41.87208,-87.65784' -- by lat/long

Http Call

/bsc/weather/forecast

Output Columns

String period
String date_epoch
String date_pretty_short
String date_pretty
String date_day
String date_month
String date_year
String date_yday
String date_hour
String date_min
String date_sec
String date_isdst
String date_monthname
String date_monthname_short
String date_weekday_short
String date_weekday
String date_ampm
String date_tz_short
String date_tz_long
String high_fahrenheit
String high_celsius
String low_fahrenheit
String low_celsius
String icon
String icon_url
String skyicon
String qpf_allday_in
String qpf_allday_mm
String qpf_day_in
String qpf_day_mm
String qpf_night_in
String qpf_night_mm
String snow_allday_in
String snow_allday_cm
String snow_day_in
String snow_day_cm
String snow_night_in
String snow_night_cm
String maxwind_mph
String maxwind_kph
String maxwind_dir
String maxwind_degrees
String avewind_mph
String avewind_kph
String avewind_dir
String avewind_degrees
String avehumidity
String maxhumidity
String minhumidity

Arguments

Name	Description	Default
location R	The location from which to retrieve the current weather (state/city, US Zip Code, country/city, lat,long, airport code, pws:PWS id

SQL Call

SELECT * FROM weather.forecast_10_days WHERE location = 'Fort Lauderdale'

Http Call

/bsc/weather/forecast_10_days

Output Columns

String date_epoch
String date_pretty_short
String date_pretty
String date_day
String date_month
String date_year
String date_yday
String date_hour
String date_min
String date_sec
String date_isdst
String date_monthname
String date_monthname_short
String date_weekday_short
String date_weekday
String date_ampm
String date_tz_short
String date_tz_long
String period
String high_fahrenheit
String high_celsius
String low_fahrenheit
String low_celsius
String conditions
String icon
String icon_url
String skyicon
String qpf_allday_in
String qpf_allday_mm
String qpf_day_in
String qpf_day_mm
String qpf_night_in
String qpf_night_mm
String snow_allday_in
String snow_allday_cm
String snow_day_in
String snow_day_cm
String snow_night_in
String snow_night_cm
String maxwind_mph
String maxwind_kph
String maxwind_dir
String maxwind_degrees
String avewind_mph
String avewind_kph
String avewind_dir
String avewind_degrees
String avehumidity
String maxhumidity
String minhumidity

Arguments

Name	Description	Default
location R	The location from which to retrieve the current weather (state/city, US Zip Code, country/city, lat,long, airport code, pws:PWS id

SQL Call

SELECT * FROM weather.forecast_10_days_txt WHERE location = 'Fort Lauderdale'

Http Call

/bsc/weather/forecast_10_days_txt

Output Columns

String date
String period
String icon
String icon_url
String title
String fcttext
String fcttext_metric
String pop

Arguments

Name	Description	Default
location R	The location from which to retrieve the current weather (state/city, US Zip Code, country/city, lat,long, airport code, pws:PWS id

SQL Call

SELECT * FROM weather.hourly_10_forecast WHERE location = 'FL/boca raton' -- by US state/city

Http Call

/bsc/weather/hourly_10_forecast

Output Columns

String FCTTIME_hour
String FCTTIME_hour_padded
String FCTTIME_min
String FCTTIME_sec
String FCTTIME_year
String FCTTIME_mon
String FCTTIME_mon_padded
String FCTTIME_mon_abbrev
String FCTTIME_mday
String FCTTIME_yday
String FCTTIME_isdst
String FCTTIME_epoch
String FCTTIME_pretty
String FCTTIME_civil
String FCTTIME_month_name
String FCTTIME_month_name_abbrev
String FCTTIME_weekday_name
String FCTTIME_weekday_name_night
String FCTTIME_weekday_name_abbrev
String FCTTIME_weekday_name_unlang
String FCTTIME_weekday_name_night_unlang
String FCTTIME_ampm
String FCTTIME_tz
String FCTTIME_age
String temp_english
String temp_metric
String dewpoint_english
String dewpoint_metric
String condition
String icon
String icon_url
String fctcode
String sky
String wspd_english
String wspd_metric
String wdir_dir
String wdir_degrees
String wx
String uvi
String humidity
String windchill_english
String windchill_metric
String heatindex_english
String heatindex_metric
String feelslike_english
String feelslike_metric
String qpf_english
String qpf_metric
String snow_english
String snow_metric
String pop
String mslp_english
String mslp_metric

Arguments

Name	Description	Default
location R	The location from which to retrieve the current weather (state/city, US Zip Code, country/city, lat,long, airport code, pws:PWS id

SQL Call

SELECT * FROM weather.hourly_forecast WHERE location = 'FL/boca raton' -- by US state/city
exec weather.hourly_forecast 'FL/boca raton' -- by US state/city
exec weather.hourly_forecast '33414' -- by US zip code
exec weather.hourly_forecast 'KORD' -- by airport code
exec weather.hourly_forecast '41.87208,-87.65784' -- by lat/long

Http Call

/bsc/weather/hourly_forecast

Output Columns

String FCTTIME_hour
String FCTTIME_hour_padded
String FCTTIME_min
String FCTTIME_sec
String FCTTIME_year
String FCTTIME_mon
String FCTTIME_mon_padded
String FCTTIME_mon_abbrev
String FCTTIME_mday
String FCTTIME_yday
String FCTTIME_isdst
String FCTTIME_epoch
String FCTTIME_pretty
String FCTTIME_civil
String FCTTIME_month_name
String FCTTIME_month_name_abbrev
String FCTTIME_weekday_name
String FCTTIME_weekday_name_night
String FCTTIME_weekday_name_abbrev
String FCTTIME_weekday_name_unlang
String FCTTIME_weekday_name_night_unlang
String FCTTIME_ampm
String FCTTIME_tz
String FCTTIME_age
String temp_english
String temp_metric
String dewpoint_english
String dewpoint_metric
String condition
String icon
String icon_url
String fctcode
String sky
String wspd_english
String wspd_metric
String wdir_dir
String wdir_degrees
String wx
String uvi
String humidity
String windchill_english
String windchill_metric
String heatindex_english
String heatindex_metric
String feelslike_english
String feelslike_metric
String qpf_english
String qpf_metric
String snow_english
String snow_metric
String pop
String mslp_english
String mslp_metric

Arguments

Name	Description	Default
location R	The location from which to retrieve the current weather (state/city)
daterange R	The date range (30 days max) to fetch [MMDDMMDD]

SQL Call

SELECT * FROM weather.planner WHERE location = 'FL/boca raton' and daterange = '04010430'

Http Call

/bsc/weather/planner

Output Columns

String title
String airport_code
String date_start_epoch
String date_start_pretty_short
String date_start_pretty
String date_start_day
String date_start_month
String date_start_year
String date_start_yday
String date_start_hour
String date_start_min
String date_start_sec
String date_start_isdst
String date_start_monthname
String date_start_monthname_short
String date_start_weekday_short
String date_start_weekday
String date_start_ampm
String date_start_tz_short
String date_start_tz_long
String date_end_epoch
String date_end_pretty_short
String date_end_pretty
String date_end_day
String date_end_month
String date_end_year
String date_end_yday
String date_end_hour
String date_end_min
String date_end_sec
String date_end_isdst
String date_end_monthname
String date_end_monthname_short
String date_end_weekday_short
String date_end_weekday
String date_end_ampm
String date_end_tz_short
String date_end_tz_long
String temp_high_min_f
String temp_high_min_c
String temp_high_avg_f
String temp_high_avg_c
String temp_high_max_f
String temp_high_max_c
String temp_low_min_f
String temp_low_min_c
String temp_low_avg_f
String temp_low_avg_c
String temp_low_max_f
String temp_low_max_c
String precip_min_in
String precip_min_cm
String precip_avg_in
String precip_avg_cm
String precip_max_in
String precip_max_cm
String dewpoint_high_min_f
String dewpoint_high_min_c
String dewpoint_high_avg_f
String dewpoint_high_avg_c
String dewpoint_high_max_f
String dewpoint_high_max_c
String dewpoint_low_min_f
String dewpoint_low_min_c
String dewpoint_low_avg_f
String dewpoint_low_avg_c
String dewpoint_low_max_f
String dewpoint_low_max_c
String cloud_cover
String chance_of_tempoversixty_name
String chance_of_tempoversixty_description
String chance_of_tempoversixty_percentage
String chance_of_chanceofsunnycloudyday_name
String chance_of_chanceofsunnycloudyday_description
String chance_of_chanceofsunnycloudyday_percentage
String chance_of_chanceofhumidday_name
String chance_of_chanceofhumidday_description
String chance_of_chanceofhumidday_percentage
String chance_of_chanceofwindyday_name
String chance_of_chanceofwindyday_description
String chance_of_chanceofwindyday_percentage
String chance_of_chanceofsultryday_name
String chance_of_chanceofsultryday_description
String chance_of_chanceofsultryday_percentage
String chance_of_chanceofpartlycloudyday_name
String chance_of_chanceofpartlycloudyday_description
String chance_of_chanceofpartlycloudyday_percentage
String chance_of_chanceofprecip_name
String chance_of_chanceofprecip_description
String chance_of_chanceofprecip_percentage
String chance_of_chanceofrainday_name
String chance_of_chanceofrainday_description
String chance_of_chanceofrainday_percentage
String chance_of_chanceofthunderday_name
String chance_of_chanceofthunderday_description
String chance_of_chanceofthunderday_percentage
String chance_of_chanceofcloudyday_name
String chance_of_chanceofcloudyday_description
String chance_of_chanceofcloudyday_percentage
String chance_of_tempoverninety_name
String chance_of_tempoverninety_description
String chance_of_tempoverninety_percentage
String chance_of_chanceoftornadoday_name
String chance_of_chanceoftornadoday_description
String chance_of_chanceoftornadoday_percentage
String chance_of_tempbelowfreezing_name
String chance_of_tempbelowfreezing_description
String chance_of_tempbelowfreezing_percentage
String chance_of_tempoverfreezing_name
String chance_of_tempoverfreezing_description
String chance_of_tempoverfreezing_percentage
String chance_of_chanceofhailday_name
String chance_of_chanceofhailday_description
String chance_of_chanceofhailday_percentage
String chance_of_chanceofsnowday_name
String chance_of_chanceofsnowday_description
String chance_of_chanceofsnowday_percentage
String chance_of_chanceoffogday_name
String chance_of_chanceoffogday_description
String chance_of_chanceoffogday_percentage

Arguments

Name	Description	Default
location R	The location from which to retrieve the current weather (state/city)

SQL Call

SELECT * FROM weather.rawtide WHERE location = 'FL/boca raton'

Http Call

/bsc/weather/rawtide

Output Columns

String tideSite
String lat
String lon
String units
String type
String tzname
String maxheight
String minheight
String epoch
String height

Arguments

Name	Description	Default
location R	The location from which to retrieve the current weather (country/city, US Zip Code, country/city, lat,long, airport code, pws:PWS id

SQL Call

SELECT * FROM weather.satellite WHERE location = 'FL/boca raton'

Http Call

/bsc/weather/satellite

Output Columns

String image_url
String image_url_ir4
String image_url_vis

Arguments

Name	Description	Default
location R	The location from which to retrieve the current weather (state/city)

SQL Call

SELECT * FROM weather.tide WHERE location = 'FL/boca raton'

Http Call

/bsc/weather/tide

Output Columns

String tideSite
String lat
String lon
String units
String type
String tzname
String maxheight
String minheight
String date_pretty
String date_year
String date_mon
String date_mday
String date_hour
String date_min
String date_tzname
String date_epoch
String utcdate_pretty
String utcdate_year
String utcdate_mon
String utcdate_mday
String utcdate_hour
String utcdate_min
String utcdate_tzname
String utcdate_epoch
String data_height
String data_type

Arguments

Name	Description	Default
location R	The location from which to retrieve the current weather (state/city)

SQL Call

SELECT * FROM weather.webcams WHERE location = 'FL/boca raton'

Http Call

/bsc/weather/webcams

Output Columns

String handle
String camid
String camindex
String assoc_station_id
String link
String linktext
String cameratype
String organization
String neighborhood
String zip
String city
String state
String country
String tzname
String lat
String lon
String updated
String downloaded
String isrecent
String CURRENTIMAGEURL
String WIDGETCURRENTIMAGEURL
String CAMURL

Arguments

Name	Description	Default
location R	The location from which to retrieve the current weather (state/city, US Zip Code, country/city, lat,long, airport code, pws:PWS id

SQL Call

SELECT * FROM weather.yesterday WHERE location = 'FL/boca raton'
exec weather.yesterday 'FL/boca raton' -- by US state/city
exec weather.yesterday 'Monaco/Monte Carlo' -- by country/city
exec weather.yesterday '33414' -- by US zip code
exec weather.yesterday 'KORD' -- by airport code
exec weather.yesterday '41.87208,-87.65784' -- by lat/long

Http Call

/bsc/weather/yesterday

Output Columns

String date_pretty
String date_year
String date_mon
String date_mday
String date_hour
String date_min
String date_tzname
String utcdate_pretty
String utcdate_year
String utcdate_mon
String utcdate_mday
String utcdate_hour
String utcdate_min
String utcdate_tzname
String observation_date_pretty
String observation_date_year
String observation_date_mon
String observation_date_mday
String observation_date_hour
String observation_date_min
String observation_date_tzname
String observation_utcdate_pretty
String observation_utcdate_year
String observation_utcdate_mon
String observation_utcdate_mday
String observation_utcdate_hour
String observation_utcdate_min
String observation_utcdate_tzname
String observation_tempm
String observation_tempi
String observation_dewptm
String observation_dewpti
String observation_hum
String observation_wspdm
String observation_wspti
String observation_wgustm
String observation_wgusti
String observation_wdird
String observation_wdire
String observation_vism
String observation_visi
String observation_pressurem
String observation_pressurei
String observation_windchillm
String observation_windchilli
String observation_heatindexm
String observation_heatindexi
String observation_precipm
String observation_precipi
String observation_conds
String observation_icon
String observation_fog
String observation_rain
String observation_snow
String observation_hail
String observation_thunder
String observation_tornado
String observation_metar
String summary_date_pretty
String summary_date_year
String summary_date_mon
String summary_date_mday
String summary_date_hour
String summary_date_min
String summary_date_tzname
String summary_date_fog
String summary_rain
String summary_snow
String summary_snowfallm
String summary_snowfalli
String summary_monthtodatesnowfallm
String summary_monthtodatesnowfalli
String summary_since1julsnowfallm
String summary_since1julsnowfalli
String summary_snowdepthm
String summary_snowdepthi
String summary_hail
String summary_thunder
String summary_tornado
String summary_meantempm
String summary_meantempi
String summary_meandewptm
String summary_meandewpti
String summary_meanpressurem
String summary_meanpressurei
String summary_meanwindspdm
String summary_meanwindspdi
String summary_meanwdire
String summary_meanwdird
String summary_meanvism
String summary_meanvisi
String summary_humidity
String summary_maxtempm
String summary_maxtempi
String summary_mintempm
String summary_mintempi
String summary_maxhumidity
String summary_minhumidity
String summary_maxdewptm
String summary_maxdewpti
String summary_mindewptm
String summary_mindewpti
String summary_maxpressurem
String summary_maxpressurei
String summary_minpressurem
String summary_minpressurei
String summary_maxwspdm
String summary_maxwspdi
String summary_minwspdm
String summary_minwspdi
String summary_maxvism
String summary_maxvisi
String summary_minvism
String summary_minvisi
String summary_gdegreedays
String summary_heatingdegreedays
String summary_coolingdegreedays
String summary_precipm
String summary_precipi
String summary_precipsource
String summary_heatingdegreedaysnormal
String summary_monthtodateheatingdegreedays
String summary_monthtodateheatingdegreedaysnormal
String summary_since1sepheatingdegreedays
String summary_since1sepheatingdegreedaysnormal
String summary_since1julheatingdegreedays
String summary_since1julheatingdegreedaysnormal
String summary_coolingdegreedaysnormal
String summary_monthtodatecoolingdegreedays
String summary_monthtodatecoolingdegreedaysnormal
String summary_since1sepcoolingdegreedays
String summary_since1sepcoolingdegreedaysnormal
String summary_since1jancoolingdegreedays
String summary_since1jancoolingdegreedaysnormal