EAN offers over 350,000 geography definitions, including points of interest, train & metro stations, high airport resolution and detailed polygon mapping in key areas. Definitions are granular and include many thousands of manually drawn polygons, ensuring a strong alignment with the other Expedia brands. The RegionEANHotelIDMapping file provides accurate and up-to-date region information for each hotel offered by EAN.

If you integrated these files prior to April 2017, the files in the default folder are no longer maintained. The latest data exists in the /new/ directories detailed below.

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.
  • PointsOfInterestCoordinatesList – 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.
  • TrainMetroStationCoordinatesList - List of train stations and metro stations and their latitude/longitude coordinates.
  • 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.

Region Types

Type

Description

Continent Large landmasses such as Europe, Asia, South America.
Country Nation states such as United States of America, Australia, Germany. Countries are defined in the geographical sense, not necessarily in the political sense. For example, Guadeloupe is a French department in the Carribean. It is politically France but geographically its own entity.
Province (State) Administrative areas within a country such as the state of California or the county of Orange County within California. They represent up to four levels of provinces, states, counties, departments and other administrative designations within a country.
High Level Region Touristic regions such as High Rhine in Germany or Wine Country in California.
Multi-City (Vicinity) Larger metropolitan areas containing a primary city and its surrounding suburbs such as Cairo and its vicinity. Their polygon boundaries are loosely defined based on touristic value.
City Urban areas such as Bellevue, Washington. A city may exist for larger metropolitans such as London. In this case, the city will cover a smaller area than the equivalent multi-city called London and vincity. Every hotel which is contracted by Expedia must be linked to a city since this is our fundamental unit of geographical coverage. Their polygon boundaries are defined based on official administrative sources.
Neighborhood Geographical areas smaller than a city such as Old Town in Bonn, Germany. Their polygon boundaries are based on touristic value rather than administratively defined.
Point of Interest Locations such as museums, convention centers, beaches and parks. This list goes beyond the obvious tourist attractions to cover a very wide range of different places such as Shanghai Exhibition Center, Texas State Capitol or Prague Zoo.
Train Station Train stations such as Grand Central Station in New York.
Metro Station Metro stations such as Avtovo Station in St. Petersburg, Russia.
Airport Airports such as London Heathrow (LHR).

Region Types Included in Geography Files

Contained Region Types

Geography File

Continent Country Province (State) 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                    
PointsOfInterestCoordinatesList                    
AirportCoordinatesList                    
TrainMetroStationCoordinatesList                  
RegionCenterCoordinates              
RegionEANHotelIDMapping          

ParentRegionList

File Name: ParentRegionList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/new/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 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 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/new/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 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/new/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 64-bit integer
LanguageCode nvarchar(5)
CountryName nvarchar(256)
CountryCode nvarchar(2)
Transliteration nvarchar(256)
ContinentID 64-bit integer

CountryList Multi-Language

File Name: CountryList_xx_XX.txt
Zip File Name:https://www.ian.com/affiliatecenter/include/V2/new/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 64-bit integer
LanguageCode nvarchar(5)
CountryName nvarchar(256)

CityCoordinatesList

File Name: CityCoordinatesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/new/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 64-bit integer
RegionName nvarchar(255)
Coordinates varchar(max)

NeighborhoodCoordinatesList

File Name: NeighborhoodCoordinatesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/new/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 64-bit integer
RegionName nvarchar(255)
Coordinates varchar(max)

PointsOfInterestCoordinatesList

File Name: PointsOfInterestCoordinatesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/new/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 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/new/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 or multi-city the airport serves.

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

TrainMetroStationCoordinatesList

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

This file contains a list of all train stations and metro stations by latitude and longitude.

Attribute Name Base Data Type (Length)
RegionID 64-bit integer
RegionName nvarchar(255)
RegionType nvarchar(50)
Latitude numeric(9,6)
Longitude numeric(9,6)

RegionCenterCoordinatesList

File Name: RegionCenterCoordinatesList.txt
Zip File Name: https://www.ian.com/affiliatecenter/include/V2/new/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 64-bit integer
RegionName nvarchar(255)
CenterLatitude numeric(9,6)
CenterLongitude numeric(9,6)

RegionEANHotelIDMapping

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

This file links EAN properties to province/state, high level region, multi-city, city, neighborhood, point of interest and select country regions by EANHotelID.

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