NOAA Weather Station Index

Snowflake table name : CYBERSYN.NOAA_WEATHER_STATION_INDEX

View data source documentation here.

Name	Description	Type	Example
NOAA_WEATHER_STATION_ID	Unique identifier for land surface weather stations in the Global Historical Climatology Network daily (GHCNd), comprised of the FIPS country code (first 2 characters), a network code (third character), and the actual station ID (the remaining 8 characters).	VARCHAR	USC00330279
NOAA_WEATHER_STATION_NAME	Full name of the weather station.	VARCHAR	FITTSTOWN 6SW MESONET
COUNTRY_GEO_ID	Cybersyn's unique identifier for a country, joinable to other datasets.	VARCHAR	country/USA
COUNTRY_NAME	Full name of the country.	VARCHAR	United States
STATE_GEO_ID	Cybersyn's unique identifier for a state, joinable to other datasets.	VARCHAR	geoId/40
STATE_NAME	Full name of the state.	VARCHAR	Alabama
ZIP_GEO_ID	Cybersyn's unique identifier for a zip code, joinable to other datasets.	VARCHAR	zip/74865
ZIP_NAME	Full name of the zip code.	VARCHAR	74865
LATITUDE	Latitude of the land surface weather station (in decimal degrees).	FLOAT	34.5519
LONGITUDE	Longitude of the land surface weather station (in decimal degrees).	FLOAT	-85.8369
ELEVATION	Elevation of the land surface weather station (in meters).	FLOAT	138.7
WEATHER_STATION_NETWORK	Source of the station ID, represented by the network code in that ID.	VARCHAR	U.S. Cooperative Network ID
ASSOCIATED_NETWORKS	Array of networks the land surface weather station is part of.	ARRAY	[ "HCN" ]
WORLD_METEOROLOGICAL_ORGANIZATION_ID	World Meteorological Organization (WMO) number for the land surface weather station, if available.	VARCHAR	93420
SOURCE_DATA	Array of sources for data points associated with the land surface weather station.	ARRAY	[ "U.S. Cooperative Summary of the Day (NCDC DSI-3200)", "U....