[postgis-users] Postgis geometries to KML

[Nicolas Ribot]

> Hi,
> Does anyone know of a way to generate a KML file directly from postgis
> geometries? I have open street map road geometries stored in a
> table which I would like to dump out as a KML to visualise on Google Earth.
> Would love to hear if someone has already done something
> like this in the past.
>

Hi,

st_asKml() will do that.
Maybe storing a KML header and footer somewhere in postgis and
concatenate header + asKml + footer could generate a valid KML
directly from a query ?

Nicolas