On the 19th April 2017, EAN will roll out new and improved geography definitions. See below for more information.

Relational Data Files

The RegionID field in each of the geography files we create is used to link the files together, where applicable. The RegionID for the AirportcoordinatesList file is actually called AirportID, and the CountryList file lists the field as CountryID.

ParentRegionList and RegionList Multi-Language are two of the main files used. The ParentRegionList is used to map a given region to the next larger or next smaller region. For instance, the RegionID of Springfield, MO, USA would have a ParentRegionID that points to the state Missouri, USA. Missouri, USA would have a ParentRegionID that points to the country USA and so forth. ParentRegionIDs can also be determined in descending region size. For example, the RegionID of Springfield, MO, USA would be the ParentRegionID of Hammons Field Baseball Stadium.

  • ParentRegionList – Master list of all regions and the hierarchical relationship between regions.
  • RegionList Multi-Language – Localized names of the regions in the ParentRegionList file.
  • CountryList – List of countries and their country code.
  • CountryList Multi-Language – Localized names of the countries in the CountryList file.
  • CityCoordinatesList – List of cities and their bounding coordinates.
  • NeighborhoodCoordinatesList – List of neighborhoods and their bounding coordinates.
  • PointsOfInterestCoordinates – List of point of interest locations and their latitude/longitude coordinates.
  • AirportCoordinatesList – List of airport codes, their latitude/longitude coordinates, and the region ID of the nearest main city.
  • RegionCenterCoordinates – Latitude and longitude of the centroid of multi-city, city and neighborhood regions.
  • RegionEANHotelIDMapping – Mapping between of EANHotelID and RegionID. A region is typically mapped to a city, but when the exact city is not found it may be a larger metropolitan area.

Action Required:

From now until 19th April 2017, you will have access to both the old and the new version of geography definitions. It is important that you plan for any changes required as a result of the new geography files.
Please review the roll out plan where you can find details on temporary file locations and recommended implementation strategies. After April 19th 2017, EAN will default the geography files to the new version and the old files will no longer be available.


Region Types Included in Geography Files

Contained Region Types

Geography File

Continent Country Province (State) Multi-Region (within a country) High Level Region Multi-City (Vicinity) City Neighborhood Point of Interest Train Station Metro Station Airport
ParentRegionList  
RegionList Multi-Language  
CountryList                      
CountryList Multi-Language                      
CityCoordinatesList                      
NeighborhoodCoordinatesList                      
PointsOfInterestCoordinates                      
AirportCoordinatesList                      
RegionCenterCoordinates                
RegionEANHotelIDMapping              

ParentRegionList

File Name: ParentRegionList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/ParentRegionList.zip

This file is the main list of region data. It can be used to hierarchically search regions from city all the way up to the continent using the ParentRegion data.

Attribute Name Base Data Type (Length)
RegionID long long as a 64-bit integer
RegionType nvarchar(50)
RelativeSignificance (no longer applicable; returns blank space) nvarchar(3)
SubClass nvarchar(50)
RegionName nvarchar(255)
RegionNameLong nvarchar(510)
ParentRegionID long long as a 64-bit integer
ParentRegionType nvarchar(50)
ParentRegionName nvarchar(255)
ParentRegionNameLong nvarchar(510)

RegionList Multi-Language

File Name: RegionList_xx_XX.txt
Zip File Name:https://www.ian.com/affiliatecenter/include/V2/RegionList_xx_XX.zip

This file holds all language translations for each region including English language.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
RegionID long long as a 64-bit integer
LanguageCode nvarchar(5)
RegionName nvarchar(255)
RegionNameLong nvarchar(510)

CountryList

File Name: CountryList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/CountryList.zip

This file contains a list of valid countries around the world. The CountryID is a link back to the region parent table. The ContinentID is also a link to the continent name in the region parent table. CountryCode is the two character designation for the country. Transliteration is the "clean" version of the country name.

Attribute Name Base Data Type (Length)
CountryID long long as a 64-bit integer
LanguageCode nvarchar(5)
CountryName nvarchar(256)
CountryCode nvarchar(2)
Transliteration nvarchar(256)
ContinentID long long as a 64-bit integer

CountryList Multi-Language

File Name: CountryList_xx_XX.txt
Zip File Name:https://www.ian.com/affiliatecenter/include/V2/CountryList_xx_XX.zip

This file holds all non-English language translations for the records located in the CountryList file.

Use the URL format provided above, substituting the _xx_XX suffix with your desired language code.

Attribute Name Base Data Type (Length)
CountryID long long as a 64-bit integer
LanguageCode nvarchar(5)
CountryName nvarchar(256)

CityCoordinatesList

File Name: CityCoordinatesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/CityCoordinatesList.zip

This file contains a list of cities and their matching RegionID. The Coordinates field is a colon delimited list of Latitude;Longitude values.

Attribute Name Base Data Type (Length)
RegionID long long as a 64-bit integer
RegionName nvarchar(255)
Coordinates TEXT

NeighborhoodCoordinatesList

File Name: NeighborhoodCoordinatesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/NeighborhoodCoordinatesList.zip

This file contains a list of neighborhood and their matching RegionID. The Coordinates field is a colon delimited list of Latitude;Longitude values.

Attribute Name Base Data Type (Length)
RegionID long long as a 64-bit integer
RegionName nvarchar(255)
Coordinates TEXT

PointsOfInterestCoordinatesList

File Name: PointsOfInterestCoordinatesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/PointsOfInterestCoordinatesList.zip

This file is a listing of all points of interest by latitude and longitude. The SubClassification shows what type of POI it is.

Attribute Name Base Data Type (Length)
RegionID long long as a 64-bit integer
RegionName nvarchar(255)
RegionNameLong nvarchar(510)
Latitude numeric(9,6)
Longitude numeric(9,6)
SubClassification nvarchar(20)

AirportCoordinatesList

File Name: AirportCoordinatesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/AirportCoordinatesList.zip

This file contains a list of airports and their matching RegionID (MainCityID). AirportCode is the three letter airport abbreviation. Latitude and Longitude show the geographic coordinates of the airport. MainCityID is the RegionID of the major city the airport serves.

Attribute Name Base Data Type (Length)
AirportID long long as a 64-bit integer
AirportCode nvarchar(3)
AirportName nvarchar(70)
Latitude numeric(9,6)
Longitude numeric(9,6)
MainCityID long long as a 64-bit integer
CountryCode nvarchar(2)

RegionCenterCoordinatesList

File Name: RegionCenterCoordinatesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/RegionCenterCoordinatesList.zip

This file lists the center point of high level regions, multi-city, city and neighborhood regions.

Attribute Name Base Data Type (Length)
RegionID long long as a 64-bit integer
RegionName nvarchar(255)
CenterLatitude numeric(9,6)
CenterLongitude numeric(9,6)

RegionEANHotelIDMapping

Note: Due to improvements to this file's geography data, the typical download size has increased to > 300MB.

File Name: RegionEANHotelIDMapping.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/RegionEANHotelIDMapping.zip

This file links EAN properties to high level regions, multi-city, city, neighborhood and point of interest regions by EANHotelID.

Attribute Name Base Data Type (Length)
RegionID long long as a 64-bit integer
EANHotelID int