[mapserver-users] PostGIS query

[Carlos Ruiz]

Hi Julien,


> I usually use a view, but in this case there are a lot of tables 
> involved and I would like to avoid dozens of unnecessary JOIN


I think that you have a database design problem.

You can have a lot of tables which concerns to a different objects, but you need to show some information on a map which involves many of those tables. That's why you have to create different views or in the worst case, a super view as a spreadsheet.

I guess that's why you're talking about unnecessary JOINs, but in the end, you'll need to use them to create the multiple data sources or the super data source of your layers in the .MAP file.



IC Carlos Ruiz



________________________________
 From: Julien Cigar <jcigar at ulb.ac.be>
To: Carlos Ruiz <boolean10001 at yahoo.com> 
Cc: "mapserver-users at lists.osgeo.org" <mapserver-users at lists.osgeo.org> 
Sent: Wednesday, February 1, 2012 2:59 AM
Subject: Re: [mapserver-users] PostGIS query
 
On 01/31/2012 17:05, Carlos Ruiz wrote:
> Julien,

Hi Carlos,

>
> Have you tried with views ? When I need to map complex queries I build a
> view to just handle the where clauses.
>

I usually use a view, but in this case there are a lot of tables 
involved and I would like to avoid dozens of unnecessary JOIN

> Cheers from México
> IC Carlos Ruiz
>
> ------------------------------------------------------------------------
> *From:* Julien Cigar <jcigar at ulb.ac.be>
> *To:* "mapserver-users at lists.osgeo.org" <mapserver-users at lists.osgeo.org>
> *Sent:* Tuesday, January 31, 2012 6:38 AM
> *Subject:* [mapserver-users] PostGIS query
>
> Hello,
>
> Is there a way to (deeply) modify the SQL query in a PostGIS layer?
> I would like to add some JOIN, additional WHERE clauses, etc
> As I'm afraid that "Run-time Substitution" isn't flexible enough for
> this case ... is there any other possibility, other than mapscript?
>
> I guess there is no possibility to define variables, conditions, etc in
> a .map file .. ?
>
> Thanks,
> Julien
>
> -- No trees were killed in the creation of this message.
> However, many electrons were terribly inconvenienced.
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org <mailto:mapserver-users at lists.osgeo.org>
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>


-- 
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120203/83da82fa/attachment.html