[GIS] Using Google Earth as view with SQL Server or Postgres Database

google earthpostgresqlsql server

How do I connect Google Earth with any relation database? I have live database containing spatial co-ordinates i.e latitude and longitude. User should be able to view these live data on google earth.

Best Answer

If you want to serve the data as static KML, the easiest option is to use ST_AsKML function in PostGIS. However if you want to use live KML data, one option could be using GeoServer and get the output in KML format.

Related Question