[Geoserver-users] How to use the postgis functions via sending WFS

Kevin_Yang · June 12, 2007, 8:13am

Hello dear Justin,
I find in postgis there are many practical spatial analyse functions buffer() geomunion() ect. I guess the Geoserver request postgis via jdbc.Can we use the spatial analyse functions of postgis via send WFS-GML?Like the follows:

Use SQL(jdbc->postgis): select asewkt(buffer(GeomFromText(‘LINESTRING(2 3,4 5,6 5,7 8)’, -1),2));
Use WFS(wfs->geoserver->postgis): ?

I have try some times.But it didn’t return the result I thought using the follow code.
<wfs:GetFeature service=“WFS” version=“1.0.0”
outputFormat=“GML2”
xmlns:topp=“http://www.openplans.org/topp”
xmlns:wfs=“http://www.opengis.net/wfs”
xmlns:ogc=“http://www.opengis.net/ogc”
xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”
xsi:schemaLocation=“http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd”>
<wfs:Query typeName=“topp:myrivertable”>

geom
width

</wfs:Query>
</wfs:GetFeature>
Thank you very much!
Sincerely your,
Yang

150 万人同时在玩的网游，你不试试吗？

Justin_Deoliveira · June 13, 2007, 2:37am

Hi Yang,

The wfs protocol does not support selecting "derived" attributes in this
manner. You can only apply a function to the filter ( where clause ) of
a query.

This sort of thing falls into the realm of WPS (Web Processing Service).

-Justin

yangzhaohui wrote:

Hello dear Justin,
   I find in postgis there are many practical spatial analyse functions
buffer() geomunion() ect. I guess the Geoserver request postgis via
jdbc.Can we use the spatial analyse functions of postgis via send
WFS-GML?Like the follows:

     Use SQL(jdbc->postgis): select
asewkt(buffer(GeomFromText('LINESTRING(2 3,4 5,6 5,7 8)', -1),2));
     Use WFS(wfs->geoserver->postgis): ?

I have try some times.But it didn't return the result I thought using
the follow code.
      <wfs:GetFeature service="WFS" version="1.0.0"
       outputFormat="GML2"
       xmlns:topp="http://www.openplans.org/topp"
       xmlns:wfs="http://www.opengis.net/wfs"
       xmlns:ogc="http://www.opengis.net/ogc"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.opengis.net/wfs
       http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd
<http://schemas.opengis.net/wfs/10.0/WFS-basic.xsd>">
      <wfs:Query typeName="topp:myrivertable">
          <Function name="buffer">
             <PropertyName>geom</PropertyName>
             <PropertyName>width</PropertyName>
          </Function>
      </wfs:Query>
     </wfs:GetFeature>
Thank you very much!
                                                        Sincerely your,
                                                           Yang

------------------------------------------------------------------------
150 万人同时在玩的网游，你不试试吗？
<http://event.mail.163.com/chanel/xyq.htm?from=163_NO1>
!DSPAM:4007,466f465f74727180515871!

------------------------------------------------------------------------

-------------------------------------------------------------------------
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/

!DSPAM:4007,466f465f74727180515871!

------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,466f465f74727180515871!

--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com