WFS for advanced queries ?

[korakas koarkis]

To setup database views is an option BUT has several limitations:
1) I must know in advance the queries that the user will issue
2) I dont know what happens with db perfomance: Consider that there will be a great volume of data in terms of tables and content of the tables.

My goal is to act as a content provider with an API for visualazation and querying.
I consider OGC through WMS and WFS but if understood correctly WFS cannot fullfill my needs... (right??)

For example lets say that I have two tables Cities and Roads
and I want to find :"The Road with name X which Cities crosses ?"

and then HighLight these cities!

This query can be supported in MapServer ?



"Bart van den Eijnden (OSGIS)" <bartvde at OSGIS.NL> έγραψε: WFS won't allow you currently to do advanced queries.

If your queries are known beforehand, you can setup database views and use
those views as a typename in WFS.

If that's not possible, you need a more direct way of controlling your
queries, Mapscript could be an option then (setting the DATA statement
dynamically on a LAYER).

Best regards,
Bart

--
Bart van den Eijnden
OSGIS, Open Source GIS
http://www.osgis.nl


--------- Oorspronkelijk bericht --------
Van: korakas koarkis 
Naar: MAPSERVER-USERS at LISTS.UMN.EDU 
Onderwerp: [UMN_MAPSERVER-USERS] WFS for advanced queries ?
Datum: 16/02/07 12:15

> Hi all,I have a PostGIS installed, and I want to setup above a Framework
for  visualization and advanced querying the of data. (By the term
advanced I mean inner/outer join etc)I was thinking to use UMN Mapserver
with OCG standards:*) WMS for visualization and*) WFS for quering the
dataDoes MapServer handles advanced querying through WFS, or do I have to
consider some other API (MapScript) ?ThxKio  
>    
> Χρησιμοποιείτε Yahoo! 
> Βαρεθήκατε τα ενοχλητικά μηνύ ματα (spam); Το Yahoo! Mail διαθέτει την
καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων  
> http://login.yahoo.com/config/mail?.intl=gr 

 
 		
---------------------------------
 Χρησιμοποιείτε Yahoo!
 Βαρεθήκατε τα ενοχλητικά μηνύ ματα (spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων 
 http://login.yahoo.com/config/mail?.intl=gr 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070216/408f095e/attachment.htm>