[postgis-users] Write out KML for each database record?
mchapman at texelinc.com
Tue Oct 23 18:52:31 PDT 2007
Use a database cursor and loop through the records you want. See
Chief Software Architect
Fortified Datacom Inc.
mchapman at fortifieddatacom.com
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Dane
Sent: Tuesday, October 23, 2007 4:37 PM
To: PostGIS Users Discussion
Subject: [postgis-users] Write out KML for each database record?
I have been using the PostgreSQL COPY command and the Postgis AsKml()
function to write out a KML file for a single database record that
matches a WHERE clause, which is very handy.
Here is the generalized SQL query:
Copy (SELECT 'XML HEADER HERE' || askml(the_geom) || 'XML FOOTER
HERE' from mytable where name = unique record) TO '/recordname.kml';
I would like to do this for every database record, therefore creating
a single, independent KML file for every geometry row. I think this
undoubtedly requires a bit of scripting to loop through every
database record and save to a new .kml file by running an individual
SQL query as many times are there are rows.
I am learning PHP, but at this point turning query results into
arrays and then passing those back to another query is beyond my
Has anyone else used PHP, PL/PGSQL, or other approaches to try
something like this?
postgis-users mailing list
postgis-users at postgis.refractions.net
More information about the postgis-users