Hi list,
I have two point tables (A,B) in postgis. I would like to do query below using a GetFeature request with the filter option. Is it possible???
The query is:
select A.the_geom from A,B where
intersects(A.the_geom,buffer(B.the_geom,10000));
If it’s possible any help with the sintax??? I’ve tried to use the buffer function but it doesn’t work, I think it’s a syntax problem.
Thanks in advance.
–
Manel Gimeno
Hi Manel,
Unfortunatley our data store infrastructure doesn't yet support the
notion of joins directly.
The only way you may be able to pull something like this off is with the
use of a view. So you could in postgis:
create view C as select A.the_geom from A,B where
intersects(A.the_geom,buffer(B.the_geom,10000));
Then just add C as a feature type normally in geoserver and it should work.
I dont know if this works for your requirements, but people has used
this strategy to pull off join like functionality with geoserver in the
past.
-Justin
Manel Gimeno wrote:
Hi list,
I have two point tables (A,B) in postgis. I would like to do query
below using a GetFeature request with the filter option. Is it possible???The query is:
select A.the_geom from A,B where
intersects(A.the_geom,buffer(B.the_geom,10000));If it's possible any help with the sintax??? I've tried to use the
buffer function but it doesn't work, I think it's a syntax problem.Thanks in advance.
--
Manel Gimeno
!DSPAM:1004,450d6672132092051017194!------------------------------------------------------------------------
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642!DSPAM:1004,450d6672132092051017194!
------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users!DSPAM:1004,450d6672132092051017194!
--
Justin Deoliveira
jdeolive@anonymised.com
The Open Planning Project
http://topp.openplans.org