NOAA Weather Station Index

Snowflake table name : CYBERSYN.NOAA_WEATHER_STATION_INDEX

View data sources, attributes, and sample queries 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	USW00024048
NOAA_WEATHER_STATION_NAME	Full name of the weather station.	VARCHAR	REESE RVR - IONE 13NE
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/06
STATE_NAME	Full name of the state.	VARCHAR	Wyoming
ZIP_GEO_ID	Cybersyn's unique identifier for a zip code, joinable to other datasets.	VARCHAR	zip/89310
ZIP_NAME	Full name of the zip code.	VARCHAR	76844
LATITUDE	Latitude of the land surface weather station (in decimal degrees).	FLOAT	36.2547
LONGITUDE	Longitude of the land surface weather station (in decimal degrees).	FLOAT	-108.3814
ELEVATION	Elevation of the land surface weather station (in meters).	FLOAT	1485.9
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	[ "GSN" ]
WORLD_METEOROLOGICAL_ORGANIZATION_ID	World Meteorological Organization (WMO) number for the land surface weather station, if available.	VARCHAR	27066
SOURCE_DATA	Array of sources for data points associated with the land surface weather station.	ARRAY	[ "Environment Canada", "Global Summary of the Day (NCDC DSI...