> 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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
