Hi, i have tried to use a time template with this time.ftl:
${utc_date_time.value?
datetime(“y?M%d&H:m:s”)}
My postgres colum looks like this:
“2008-11-18 01:01:39”
The time slider doesn’t show up in Google Earth. I tried using just ${utc_date_time.value} and then it it just shows a subset of the dataset.
Any ideas ?
Martin
Hi Martin,
What version of geoserver are you using? I can't remember when, but i know there were some issues a while back with time templates with postgis not working correctly. Are you using a relatively recent version?
Any chance you could supply a quick sql script that creates some data with which you can replicate the issue with. With it I could quickly load it up into my postgis db and debug the problem.
-Justin
Martin Jensen wrote:
Hi, i have tried to use a time template with this time.ftl:
${utc_date_time.value?
datetime("y?M%d&H:m:s")}My postgres colum looks like this:
"2008-11-18 01:01:39"
The time slider doesn't show up in Google Earth. I tried using just ${utc_date_time.value} and then it it just shows a subset of the dataset.
Any ideas ?
Martin
------------------------------------------------------------------------
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
Hi Martin,
Thanks for sending me the data to reproduce. So with recent version of GeoServer 1.7.x the function in the template is unnecessary, you can just reference the temporal column directly with timestamp values. So if you change the template to simply:
${utc_date_time.value}
The rationale being that since the column is already a datetime, there should be no need to to convert it.
Hope that helps.
-Justin
Martin Jensen wrote:
Hi Justin, I use 1.7.5-SNAPSHOT. I had problems with earlier versions as well.
Using the description and title ftl's has also changed. Earlier versions showed all the features in the menu in GE but now it is just endless trees without a list of features
.Attached is a sql with inserts.
Martin
2009/5/21 Justin Deoliveira <jdeolive@anonymised.com <mailto:jdeolive@anonymised.com>>
Hi Martin,
What version of geoserver are you using? I can't remember when, but
i know there were some issues a while back with time templates with
postgis not working correctly. Are you using a relatively recent
version?Any chance you could supply a quick sql script that creates some
data with which you can replicate the issue with. With it I could
quickly load it up into my postgis db and debug the problem.-Justin
Martin Jensen wrote:
Hi, i have tried to use a time template with this time.ftl:
${utc_date_time.value?
datetime("y?M%d&H:m:s")}My postgres colum looks like this:
"2008-11-18 01:01:39"
The time slider doesn't show up in Google Earth. I tried using
just ${utc_date_time.value} and then it it just shows a subset
of the dataset.Any ideas ?
Martin
------------------------------------------------------------------------
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables
unlimited royalty-free distribution of the report engine for
externally facing server and web deployment.
http://p.sf.net/sfu/businessobjects------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users-- Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.