Re: [Geoserver-users] geoserver time support for vector data

[Andrea Aime]

On Tue, May 6, 2014 at 3:35 PM, Jacinto Estima <jacinto.est...@gmail.com>wrote:

> 2014-05-06 17:12:32,145 DEBUG [geotools.jdbc] -
>
>
>
> *SELECT encode(ST_AsBinary(ST_Simplify(ST_Force_2D("geom"),
> 0.04539062499999318)),'base64') as "geom" FROM (select a.id_number, a.geom,
> b.id_station, b.measure_time, b.wind_direction, b.wind_speed from
> test.mesurement_stations as a left join test.mesurements as b on
> a.id_number=b.id_station order by b.measure_time ) as "vtable" WHERE
> ("measure_time" = '2012-12-31T19:00:00Z' AND "measure_time" IS NOT NULL
> AND "geom" && ST_GeomFromText('POLYGON ((75.98650390625001 37.81123046875,
> 75.98650390625001 56.98876953125, 131.70349609375 56.98876953125,
> 131.70349609375 37.81123046875, 75.98650390625001 37.81123046875))', 2))*
> 2014-05-06 17:12:38,531 DEBUG [geotools.jdbc] - CLOSE CONNECTION


Have you tried the query manually? Does it return anything? Can you fit it
to make it return stuff?

About performance, you have indexes both on the geometry column, and the
time one, yes?

Also, is all of your server setup to work in GMT (postgres, geoserver and
so on)?

Cheers
Andrea

-- 
==
Meet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aK
for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------

------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
&#149; 3 signs your SCM is hindering your productivity
&#149; Requirements for releasing software faster
&#149; Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users