Thanks Andrea,
I did what you suggested but the rendering is very very slow and
sometimes is even not showing anything.
Here is the query I am using to build the sqlview:
*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*
Are you seeing anything wrong with the query?
Do you think I would have good results using the app-schema?
Thanks a lot,
Jacinto
On 04/13/2014 04:28 PM, Andrea Aime wrote:
On Sun, Apr 13, 2014 at 1:21 PM, Jacinto Estima
<jacinto.est...@gmail.com <mailto:jacinto.est...@gmail.com>> wrote:
Hi everyone,
I have a shapefile with measurement points and for each point a
list of
time-series measurements. My question is what is the best way to
publish
these data in a Geoserver? These data are stored in a PostGIS database
where I have one point table to represent the measurement stations and
another table that has all the measurements for each station (they are
related through a stationID). Apparently the only possibility is
to use
complex features through application schemas.
I just wanted to check with the list if there are other
possibilities/solutions.
I would create a sql view
(http://docs.geoserver.org/stable/en/user/data/database/sqlview.html)
that joins the two, then publish it as a single layer,
and enable the time dimension in the layer
This will work fine as long as all the measurement stations are performing
their sampling at the same times (which is normally true, at least
in the ground weather station case I'm familiar with).
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:
• 3 signs your SCM is hindering your productivity
• Requirements for releasing software faster
• 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
