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 | 18 December, 2018 |
|---|---|
| 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. |
| 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 |
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.
