I have a PostGIS database that has OSM data imported into it using osm2pgsql and I'm using GeoServer to plot the points into a networked KML file for Google Earth.
What I'd like to do is make the nodes that Geoserver pulls from PostGIS interactive. I'd like to be able to search for an element and have Google Earth query the PostGIS db for results.
I'd also like the ability to click on a POI and have it pop up a dialog with all the attributes from PostGIS.
So far I have a bunch of red points in Google Earth that the KML file added but they are not interactive.
Any suggestions?