On Sun, Apr 13, 2014 at 1:21 PM, Jacinto Estima <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
-------------------------------------------------------
------------------------------------------------------------------------------
Put Bad Developers to Shame
Dominate Development with Jenkins Continuous Integration
Continuously Automate Build, Test & Deployment
Start a new project now. Try Jenkins in the cloud.
http://p.sf.net/sfu/13600_Cloudbees
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
