Do you also provide an API?

ch-aviation can provide the data feeds to you directly via file transfer protocol (FTP), safe file transfer protocol (SFTP) or a shared Amazon Web Services (AWS) S3 bucket.

Which delivery formats you support?

The data is provided as Comma-separated values (.csv) flat files. Optionally we can provide them as Microsoft Excel (.xlsx) or XML (.xml)

How often does data get updated?

The ch-aviation database is updated in batches to ensure all data flows through ch-aviation’s semi-automated quality assurance process built to maximise data integrity. As a result, the data set remains relatively static in the ch-aviation production database, for most data sets for a week or month at a time. Therefore, the most efficient integration option is the transfer of flat files provided for integration into your own applications in various formats.

Metro Groups - ch-aviation

Metro Groups

Column	Data Type	Data description	Package required	Key	Data Set	Join On
ID	int(11)	Unique ch-aviation created metro group ID	Airports	Primary
Metro_Group	char(3)	Metro Group IATA three-character code	Airports	Unique
Description	varchar(255)	Metro Group description	Airports
State Name	varchar(255)	State name	Airports
State ISO	char(2)	ISO 3166-2 Alpha-2 subdivision code (used for states)	Airports	Foreign	States	State ISO
Country Name	varchar(255)	Country name	Airports
Country ISO	char(2)	ISO 3166-1 Alpha-2 country code	Airports	Foreign	Countries	Country ISO
Airport Count	int(11)	Number of airports located in the metro group	Airports