Re: [postgis-users] AsKML() how to create kml from postgis data

2007-09-17 Thread Maciej Skorczewski
thx Kevin for replay! great help. :) maciek Kevin Neufeld pisze: Absolutely. See attached, a simple plpgsql function that adds header info around the current askml function. I do this in psql: -- Set output to unaligned \a -- Show only tuples \t -- Dump query to a file \o

Re: [postgis-users] AsKML() how to create kml from postgis data

2007-09-16 Thread Milo van der Linden
Hold it, stop, take a look at this first! This post was sent on the mapserver list last friday, please check if this will your demands! http://www.itopen.it/soluzioni/kml-map-server/ Dylan Beaudette schreef: On Friday 14 September 2007, John Smith wrote: as_kml()?! there's another

Re: [postgis-users] AsKML() how to create kml from postgis data

2007-09-14 Thread Maciej Skorczewski
Hi Jose ! how sql should looks like? I use PHP. so i want to use it whit PostgreSql... is there any doc. about this function? Question about Python class...i am not python programer can you describe my how i can use it? thx :) Hi, On 9/14/07, Maciej Skorczewski [EMAIL PROTECTED]

Re: [postgis-users] AsKML() how to create kml from postgis data

2007-09-14 Thread John Smith
as_kml()?! there's another askml() in line with asgml(). why this alias/name change/confusion? anyway how does it really work? getting a Must contain 'geometry_column from table_name' or 'geom from (subselect) as foo' (couldnt find ' from '). what do i do after passing bbox=... and type=kml to

Re: [postgis-users] AsKML() how to create kml from postgis data

2007-09-14 Thread Dylan Beaudette
On Friday 14 September 2007, John Smith wrote: as_kml()?! there's another askml() in line with asgml(). why this alias/name change/confusion? anyway how does it really work? getting a Must contain 'geometry_column from table_name' or 'geom from (subselect) as foo' (couldnt find ' from ').

Re: [postgis-users] AsKML() how to create kml from postgis data

2007-09-14 Thread Shane Spencer
http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet I use ogr2ogr for doing that.. however sometimes its best to write the KML using your own structure, descriptions, and element names. http://www.gdal.org/ogr/drv_kml.html will describe the options that let you name the

Re: [postgis-users] AsKML() how to create kml from postgis data

2007-09-14 Thread Shane Spencer
Thats so cool it hurts.. I love offloading processing to the big bad server while the little wimpy sql clients request the data. Good find! On 9/14/07, Kevin Neufeld [EMAIL PROTECTED] wrote: Absolutely. See attached, a simple plpgsql function that adds header info around the current askml