NationalWeatherService

Table alerts
Text name National Weather Service Alerts
Schema nationalweatherservice
Description Each row is one alert.
Source organization National Weather Service
Source organization webpage http://www.weather.gov/
Data source url https://alerts.weather.gov/
Update frequency every minute
Columns data type
areadesc text
category character varying
certainty character varying
effective timestamp with time zone
event text
expires timestamp with time zone
fips6 text
id character varying
link character varying
msgtype character varying
published timestamp with time zone
samecodes text
severity character varying
status character varying
summary text
target_areas text
title text
ugc text
updated timestamp with time zone
urgency character varying
vtec text
wkb_geometry USER-DEFINED
Table alertscurrent
Text name National Weather Service Current Alerts
Schema nationalweatherservice
Description Each row is one current alert.
Source organization National Weather Service
Source organization webpage http://www.weather.gov/
Data source url https://alerts.weather.gov/
Update frequency every minute
Columns data type
areadesc text
category character varying
certainty character varying
effective text
event text
expires text
fips6 text
id character varying
link character varying
msgtype character varying
published text
samecodes text
severity character varying
status character varying
summary text
target_areas text
title text
ugc text
updated text
urgency character varying
vtec text
wkb_geometry USER-DEFINED
Table alertzones
Text name National Weather Service Public Forecast Zones
Schema nationalweatherservice
Description Each row contains an alert id and forecast zone id.
Source organization National Weather Service
Source organization webpage http://www.weather.gov/
Data source url https://alerts.weather.gov/
Update frequency every five minutes
Columns data type
id character varying
zone character varying
Table z_05de17
Text name National Weather Service Public Forecast Zones
Schema nationalweatherservice
Description Pubnlic Forecast Zones used by the National Weather Service for weather alerts.
Source organization USGS
Source organization webpage http://www.weather.gov/
Data source url http://www.nws.noaa.gov/geodata/catalog/wsom/html/pubzone.htm
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
state character varying
zone character varying
cwa character varying
name character varying
state_zone character varying
time_zone character varying
fe_area character varying
lon numeric
lat numeric
shortname character varying