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 |