Hi,

I am new to OSM. For my requirement, I need to read Airport locations (IATA codes) from the database - SQLServer (from all over the world)and show a world map with markers on the Airport locations. Does OSM support it? I need this for a commercial application.

I have googled a lot on the subject and find GoogleMaps to be a bit expensive - Hence searching for solutions from other Map services. Can somebody in the know advise?

Thanks in advance!! Indira

asked 03 Jan '11, 11:17

indira's gravatar image

indira
0112
accept rate: 0%

1

Are you wanting to read the locations from your own SQLServer database and display them on your web site (on an OSM map)?

(04 Jan '11, 05:40) Ebenezer

Thanks for the information / queries. Yes, I have the data of Airport destinations (of PNRs) in our own database. Once the webpage is loaded, these Airport locations have to be read and markers have to be shown for these locations on a world map ( include major Airports from all over the world). We have them in the database as 3 letter IATA Codes.

(05 Jan '11, 05:29) indira

I'm not sure what "SQLServer" is or how it ended up in the question, but in principle this is possible. You can query the XAPI for all objects tagged with the key iata and display them on to of Openstreetmap based tiles using openlayers i.e. a marker layer.

permanent link

answered 03 Jan '11, 19:10

petschge's gravatar image

petschge
8.0k207196
accept rate: 21%

I understand that I can query the XAPI for all the objects tagged with the key iata. But I need to show markers only for the Airport locations from my own database and not for all the Airports. Is there a way out with XAPI?

Thanks, Indira

(04 Jan '11, 06:44) indira

Sure. Instead of querying XAPI for locations you can query your own SQLServer and display them. But that is so far outside of the scope of Openstreetmap that we wont support that. Especially as you get payed for your job and we are all volunteers.

(04 Jan '11, 07:27) petschge
Your answer
toggle preview

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:

×13
×13

question asked: 03 Jan '11, 11:17

question was seen: 4,584 times

last updated: 22 Mar '16, 16:44

powered by OSQA