Hi,
I'm new to geoserver and have a question about using filters in sld.
I've set up geoserver with a PostGIS database with several tables. For example, one is lat/lon gps data with timestamps, etc, another with US zip code areas and their boundaries. Is it possible to filter and display data based on, say, all the points that lie within a certain zip code using the style descriptors? Right now I have a view set up in the database to use as a featuretype, but is it possible without using the view? Does sld filters support queries that needs a join between tables?
Thank you.
Hi,
Unfortunately no you cannot do joins with sld filters...setting up the view as you have is probably the most viable approach.
dlamoris@anonymised.com wrote:
Hi,
I'm new to geoserver and have a question about using filters in sld.
I've set up geoserver with a PostGIS database with several tables. For example, one is lat/lon gps data with timestamps, etc, another with US zip code areas and their boundaries. Is it possible to filter and display data based on, say, all the points that lie within a certain zip code using the style descriptors? Right now I have a view set up in the database to use as a featuretype, but is it possible without using the view? Does sld filters support queries that needs a join between tables?
Thank you.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
!DSPAM:4007,4695227c21302143011171!
--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org
I see, thanks.
So does that mean this applies to wfs requests also?
Quoting Justin Deoliveira <jdeolive@anonymised.com>:
Hi,
Unfortunately no you cannot do joins with sld filters...setting up the
view as you have is probably the most viable approach.
dlamoris@anonymised.com wrote:
Hi,
I'm new to geoserver and have a question about using filters in sld.
I've set up geoserver with a PostGIS database with several tables. For example, one is lat/lon gps data with timestamps, etc, another with US zip code areas and their boundaries. Is it possible to filter and display data based on, say, all the points that lie within a certain zip code using the style descriptors? Right now I have a view set up in the database to use as a featuretype, but is it possible without using the view? Does sld filters support queries that needs a join between tables?
Thank you.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
!DSPAM:4007,4695227c21302143011171!
--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org
Yes... although there is some ongoing work that is an experimental stage that is meant to support wfs types which are made up of multiple simple datasources (tables). Its called the "complex feautres" project but is far from being supported in mainstream geoserver.
-Justin
dlamoris@anonymised.com wrote:
I see, thanks.
So does that mean this applies to wfs requests also?
Quoting Justin Deoliveira <jdeolive@anonymised.com>:
Hi,
Unfortunately no you cannot do joins with sld filters...setting up the
view as you have is probably the most viable approach.
dlamoris@anonymised.com wrote:
Hi,
I'm new to geoserver and have a question about using filters in sld.
I've set up geoserver with a PostGIS database with several tables. For example, one is lat/lon gps data with timestamps, etc, another with US zip code areas and their boundaries. Is it possible to filter and display data based on, say, all the points that lie within a certain zip code using the style descriptors? Right now I have a view set up in the database to use as a featuretype, but is it possible without using the view? Does sld filters support queries that needs a join between tables?
Thank you.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org
!DSPAM:4007,469567e384331961014482!
--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org