[postgis-users] KML Export

[Kevin Neufeld]

As you've seen, there is the ST_AsKML command (http://postgis.refractions.net/documentation/manual-svn/ST_AsKML.html) 
that will convert a single geometry to KML.

All you need to do is add some xml tags before the export geometry tag and again after, closing the document.

Here's an example of a simple wrapper that does this inside the database, though you'd probably want to do this in PHP:
http://lists.refractions.net/pipermail/postgis-users/attachments/20070914/7a02d424/askml.sql

Example use case:
SELECT askml('my_title', 'description', collect(the_geom))
FROM my_spatial_table
WHERE ....

yields something like:
<?xml version='1.0' encoding='UTF-8'?>
<kml xmlns='http://earth.google.com/kml/2.1'>
<Document>
<name>'my_title'</name>
<description>'description'</description>

<Style id='defaultStyle'>
   <LineStyle>
     <color>ff00ff00</color>
     <width>1</width>
   </LineStyle>
   <PolyStyle>
     <color>5f00ff00</color>
   </PolyStyle>
</Style>

<Placemark>
   <styleUrl>#defaultStyle</styleUrl>
   <MultiGeometry>
     <Point>
       <coordinates>-122.319,47.164</coordinates>
     </Point>
     <Point>
       <coordinates>-122.272,47.067</coordinates>
     </Point>
   </MultiGeometry>
</Placemark>

</Document>
</kml>

Cheers,
Kevin



Stefan Schwarzer wrote:
> Hi there,
> 
> I made a tour on Google to look around if there exist some KML export 
> tool. I've seen the Set_AsKML command; I've seen this 
> <http://postgis.refractions.net/pipermail/postgis-users/2007-September/017070.html> dicussion; 
> and have found that someone wrote a script 
> <http://postgis3d.blogspot.com/2007/12/googleearth-export.html> for 
> postgis; and a phyton script 
> <http://dev.riverchange.org/google_earth/genshi_template.kml>. 
> 
> But it seems that there is no easy-way-to-go export/wrapper script, 
> enabling for example the execution of pgsql2kml...
> 
> Or can someone give be a hint how to develop a KML export for a PHP 
> based Data Portal?
> 
> Thanks for any help,
> 
> Stef
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users