I have no idea where to send this and after signing up for the another list server, I thought I might try here. Let me first say that I have been using the heck out of ogr2ogr and postgis for a few days now to generate kml files with relative ease, using commands like:

ogr2ogr -f kml himom.kml PG:"host=localhost dbname=$1" -sql "select st_transform(boundary,4326), blah, blah, blah from my table"

While this is awsome, I need to export a timestamp/timespan into the kml file as well so I can make use of the time slider in google earth. I'm a relative newbie to kml and have no idea if ogr2ogr/postgis can do this. Is this possible from within the SQL query, or will I need to post process the generated kml file and manipulate the file/entries myself using another tool?

Thanks for a great tool!

Jeff Hamann, PhD
Forest Informatics
begin:vcard
fn:Jeff Hamann
n:Hamann;Jeff
org:Forest Informatics
adr:;;PO Box 1421;Corvallis;Oregon;97339-1421;United States
email;internet:[email protected]
title:President
tel;work:15417542457
x-mozilla-html:FALSE
url:www.forestinformatics.com
version:2.1
end:vcard

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to