I used Webfocus Developer Studio 7.6.10 created a focexec program that will be used in the layers in the google map. The focexec program can generate an xml file without issue, but it does not generate markers in the google map. I know all the image files are in the same folder as the focexec and htm file. I know the output format used in the layers must be xml file, and it must have a field LATITUDE, LONGITUDE and MARKER, and an optional field TOOLTIP.

I can use other data to create google map and webFOCUS to communicate each other without issues.

The table (AIRPORT table) I am working on contains duplicated LATITUDE and LOGITUDE rows, as we don’t have the exact address for all airports, so many airports in the same city or even state may have same LATITUDE and LONGITUDE. I am just wandering if the duplicates will cause the problem.

In addition, this table does not contain numeric fields (like CENTURYSALE.FOC provided by IBI which can generate different MARKER based on the data ranges), so I only can generate markers based on if the airport code is an origin airport, or destination airport, and none of them. I think this should not create problem, but not 100% sure.

This message has been edited. Last edited by: Kerry,

The latitude and longitude must be defined as double-precision with 7 decimal positions. Is that what you have?

As a pilot, I can tell you that every airport on the planet has a unique latitude and longitude published somewhere. In North America you can get the info from the FAA or Transport Canada, as well as dozens of online services - many of them free. Try aopa.org or fltplan.com.

Thank you David and George for your help!

The airport table was created long time ago for other projects, and the fields latitude and longitue were defined as A30 format, and that format works with Flex and google map.

Well it seems we have to create new table to handle the request in webFOCUS and google map.

In fact all you have to do go to Google Earth and type in the identifier for any airport you want and the latitude and longitude are displayed at the bottom of the screen.