Integrating google earth api with oracle sql

[Cheeseontaoist]

Hi there,

apologies for this probably fairly basic question but I am just
getting my head around google earth api and I'm not finding it
particularity easy.

I have a number of points in my Oracle APEX database that each have a
lat long co-ordinate associated with them looking something like this:

Latitude Longitude Date Time Species Count
-44.227 -178.999 14/11/1980 01:00:00 Daption capensis 1
-44.227 -178.999 14/11/1980 01:00:00 Diomedea chrysostoma 3
-49.703 -172.975 14/11/1980 00:30:00 Macronectes giganteus 5

Etcetera…


I would like to pull these lat longs from a query I have written and
display them in the google earth plugin. Ideally these points would be
generated as queries are submitted. Does anyone have any tips to get
me started on this?

Thanks

[Roman N]

Hi,

You'll probably want to start by deciding on a server-side/client-side
exchange data format.. that is, how do you transfer data from a server-
side script to your client-side JavaScript. Some options for this are
KML, XML, or JSON. KML can be natively handled by the plugin using
fetchKml or by creating network links. XML and JSON require more
processing on the client-side before displaying the data in the
plugin, but they might allow for more flexibility in your application.

I'd suggest reading the following for more information:

KML approach:

http://code.google.com/apis/kml/articles/phpmysqlkml.html (not exactly
Oracle, but the same concepts can be applied)

http://code.google.com/apis/earth/articles/earthapikml.html

XML approach:

http://code.google.com/apis/maps/articles/phpsqlajax.html (Maps, not
Earth, but the same concepts can be applied)

Hope these links help you get a basic understanding of the steps
involved.

- Roman