[Chameleon] Postgis, queries and ROI

[Paul Spencer]

Hi,

On 24-Jan-06, at 5:32 AM, Panayiotis Gotsis wrote:

> Hi all
>
> I have successfully set up a chameleon app connecting to postgis  
> data and
> I have to tell you I am thrilled about the result. However I have a  
> couple
> of questions on the way I should move forward...
>
> Using the query widget I can get a standard template for the results.
> Where can I customize the template? If I want to add up fields from  
> other
> tables (no postgis data) on the results, do I have to setup the  
> data for
> the layer in the map file like this?
>
> the_geom from (select table_a.the_geom, table_b.data from table_a,  
> table_b
> where table_a.some_id=table_b=someother_id) as table_source
>
> or is there a better solution?
>

There are probably many ways to do this.  To use mapserver, you will  
need to do the join in the data attribute as you suggest above.  You  
can also do a separate query based on the appropriate attribute.  In  
either case, to customize the query results requires a bit of work on  
your part.  There are instructions in the chameleon wiki for this.

http://chameleon-tiki.maptools.org/tiki-index.php? 
page=QueryWidgetCustomizingResults

> Also, about the ROI widget set, I can't seem to find who I can use the
> resulting selection to do something useful such as popping up a window
> with info on the selected geographical features
>

They are used in conjunction with a couple of specialized extraction  
and query widgets (WFS related) but could be easily adapted to the  
custom query stuff above.

Cheers

Paul

> -- 
> Panayiotis Gotsis <panos at ath.hcmr.gr>
> IT Engineer - System & Network Administrator
> NOC
> Hellenic Centre for Marine Research
>
> _______________________________________________
> Chameleon mailing list
> Chameleon at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/chameleon
>

+-----------------------------------------------------------------+
|Paul Spencer                           pspencer at dmsolutions.ca   |
+-----------------------------------------------------------------+
|Applications & Software Development                              |
|DM Solutions Group Inc                 http://www.dmsolutions.ca/|
+-----------------------------------------------------------------+