FREE
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 | 06 April, 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.