IP2Location™ Weather Station Code Database

IP2Location™ Weather Station Code is a free mapping table that enables you to easily map the Weather Station Code to various station/entity codes, such as Yahoo! WOEID, ICAO airport code and IATA code.

Download

For Customers Only

Features

Last Update	28 February, 2020
Database Format	CSV Text File (Comma Delimited)

Database Fields

Name	Type	Description
weather_station_code	VARCHAR(10)	The special code to identify the nearest weather observation station.
woeid	INT(10)	Unique 32-bit reference identifier assigned by Yahoo! to identify an entity on Earth. (Deprecated by Yahoo)
icao_code	VARCHAR(4)	Four-character alphanumeric code defined by the International Civil Aviation Organization (ICAO) designation for each airport around the world.
iata_code	VARCHAR(10)	Abbreviations that the International Air Transport Association (IATA) publishes to facilitate air travel

Sample Database

"weather_station_code","woeid","icao_code","iata_code"
"AAXX0001","56069","LFVP","FVP"
"AAXX0002","12510298","LFVP","FVP"
"ACXX0001","23397089","LFVP","FVP"
"ACXX0002","1533","LFVP","FVP"
"AEXX0001","1940330","LIBL",""

MySQL Statement

CREATE TABLE `ip2location_weather_station_code`(
	`weather_station_code` VARCHAR(10),
	`woeid` INT(10),
	`icao_code` VARCHAR(4),
	`iata_code` VARCHAR(10),
	INDEX `idx_country_alpha2_code` (`weather_station_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOAD DATA LOCAL
INFILE 'IP2LOCATION-WEATHER-STATION-CODE.CSV' INTO TABLE `ip2location_weather_station_code`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' IGNORE 1 LINES;

License Information

Attribution is required by mentioning the use of this data as follows, "The IP geolocation data is provided by https://www.ip2location.com", on your webpage and in the documentation or advertising.

IP2Location™ and IP2Proxy™ are registered trademarks of HEXASOFT. All other trademarks are the properties of their respective owners.