Re: [Geoserver-users] Querying statistical data

[David W. <dwi...@op...>]

GeoServer does support date fields in WFS queries, you can use
PropertyIsBetween to get data from a date range, etc.  Joining is not
supported in GeoServer, however.  The typical workaround is to create a
view in the database itself and use GeoServer to publish the view.

Hope this helps.

-- 
David Winslow
OpenGeo - http://opengeo.org/


On Fri, 2009-03-20 at 14:15 +0100, Stefan Schwarzer wrote:
> Hi there,
> 
> 
> I have a large database with data about GDP, population, health,
> environment etc., covering the world on a national level; many of them
> do have data for the last 10, 20 or 30 years.
> 
> 
> How do I develop a WFS webservice with Geoserver, which enables the
> query for years? Even worse, the data tables have to be JOINed with
> the country table, based on an ID field, before it spits out country
> names.
> 
> 
> I have no idea how this would work with Geoserver. Or if it works at
> all.
> 
> 
> Thanks for any advice,
> 
> 
> Stef
> 
> 
> UNEP/DEWA/GRID-Logo
> stefan schwarzer
> GIS & Data Management
> 
> me: 
> Tel. (+41) 22.917.83.49 
> Mail: ste...@gr... 
> office: 
> UNEP/DEWA/GRID-Europe 
> Chemin des Anémones 11 
> CH - 1219 Châtelaine
> Tel: (+41) 22.917.82.94
> Fax: (+41) 22.917.80.29 
> links: 
> GRID Homepage 
> UNEP GEO Data Portal 
> TREIC 
> 
> 
> 
> ------------------------------------------------------------------------------
> Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
> powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
> easily build your RIAs with Flex Builder, the Eclipse(TM)based development
> software that enables intelligent coding and step-through debugging.
> Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
> _______________________________________________ Geoserver-users mailing list Geo...@li... https://lists.sourceforge.net/lists/listinfo/geoserver-users