[postgis-users] Postgis geometries to KML

Nicolas Ribot nicolas.ribot at gmail.com
Mon Apr 2 00:59:51 PDT 2012

> 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.


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 ?


More information about the postgis-users mailing list