NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Moved from https://help.openstreetmap.org/questions/1989/load-data-from-sqlserver-and-display-markers-on-map:

Hello! How can I request the API marked IATA? I need a base: Airport name in Russian, English , IATA- Code . Can I help with your service obtain the necessary information ?

asked 22 Mar '16, 10:54

Evgeniya_VN's gravatar image

Evgeniya_VN
16111
accept rate: 0%

converted to question 22 Mar '16, 16:44

stephan75's gravatar image

stephan75
12.6k556210


Overpass API is one way to retrieve such data. Overpass Turbo is a nice front end for working out a query, here I've used the Overpass Turbo Wizard to find all the airports inside the current map view:

http://overpass-turbo.eu/s/fbO

And then here I've used the wizard again, this time further limiting the results to airports with an iata tag:

http://overpass-turbo.eu/s/fbP

Whether you get Russian and English names will of course depend on what is present in the data. Here I've edited the second query to output a delimited file with just the chosen tags:

http://overpass-turbo.eu/s/fbQ

Consult the documentation to see about changing the area that results are pulled from:

wiki.openstreetmap.org/wiki/Overpass_API/Overpass_QL

There can also be no bounding box, a global bounding box, or there is support for selecting an area from the OSM database and restricting the results to be inside that area. Queries that need a lot of resources may time out, restricting the are of the query helps avoid this.

permanent link

answered 22 Mar '16, 19:31

maxerickson's gravatar image

maxerickson
12.7k1083176
accept rate: 32%

edited 22 Mar '16, 19:39

2

For the last query (CSV output), I'd recommend to replace out; by out center;, otherwise there will be no lat/lon values for ways and relations in the response.

(25 Mar '16, 11:34) mmd

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×290
×1

question asked: 22 Mar '16, 10:54

question was seen: 2,740 times

last updated: 25 Mar '16, 11:34

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum