IP2Location™ Weather Station Code

For customer only

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

 

Product Features
Last Update 01/10/2014
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 entity on Earth.
icao_code VARCHAR(4) Four-character alphanumeric code defined by the International Civil Aviation Organization (ICAO) designating 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

IP2Location™ is a registered trademark of HEXASOFT. All other trademarks are the property of their respective owners.

 

Thank you for downloading

Sharing this great stuff to your friends!

Or share it on your blog or web page:

Free IP2Location geolocation resources available at <a href="http://www.ip2location.com">http://www.ip2location.com</a>
Copy & paste this text as HTML.