weatherCodes

This database includes all of the city codes used on weather.com and is perfect for use with tools similar to The Weather Channel®'s "weather magnet". More than 38,800 location codes are included and most cities and towns are classified at the state or province level, including 100% of the United States' records.

The location (or station) codes are 8-character long (for instance, BEXX0005 for Brussels, Belgium) and are very easily integrated into your weather magnet or any other similar plug-in.

All data is encoded in UTF-8 and distributed in compressed CSV (Comma Separated Value) files, so you can use it with your database of choice.

weatherCodes files available for purchase

Name Delivery License Last update Price
(without updates)
weatherCodes Standard - World download single April 05, 2008 € 159.99 EUR
All of our databases include free unlimited e-mail support.

The default license includes the right to use the data on one (1) server (website, intranet...), and does not authorize redistribution or integration into products to be distributed (CMS, software application,...)

Please contact us if you need to use the data on multiple projects (discounts available), want redistributing rights or simply have questions about our License Agreement and the authorized uses.

weatherCodes database structure

Having comprehensive and accurate data is good, but if it's not well structured, it might not be very useful. That's why not only weatherCodes, but all of our databases are structured in a very efficient way, which is a compromise between usability and database normalization (which do not always meet the same requirements). This results in very easy to use data, and the possibility to retrieve all the details for specific records with very simple and fast queries.

For easier maintenance, we also assigned a unique identification number to each feature. It is thus possible to store that number to refer to a particular feature, no matter the language used to display the name.

Click here to view the full structure of each table and detailed descriptions of their fields.

Requirements and files information

The weatherCodes data is available in text files (tab delimited) encoded in Unicode (UTF-8). It can therefore be imported in virtually any database, including MySQL, Microsoft SQL Server, PostgreSQL, Oracle, etc... The only requirements are that you have enough free space on you hard drive to store the files and that you can import those files into your database.

For faster download, files are compressed in ZIP format.