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.
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.
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
------------------------------------------------------------------------------
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 Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
which speaks to your needs. It isn't yet a standard and I'm not aware of any publicly-available tools that instantiate it (if anyone does, I'd love to hear about them) but it seems to represent some part of the OGC's thinking on this important question.
---
A. Soroka / Digital Scholarship Services R & D
the University of Virginia Library
On Mar 20, 2009, at 10:01 AM, David Winslow wrote:
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.
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
------------------------------------------------------------------------------
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 Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
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
Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
