[mapserver-users] followup - q. combining mapscript and PostGIS

[Alex Rice]

It appears that the filter on a layer objects only decides the 
content, not the extent of the layer. Is that correct? Also, is 
it even possible to use Perl DBI from Mapscript? My script dies 
when I attempt it:

% ./mapscript.cgi
dyld: perl multiple definitions of symbol _DLAddHead
/Library/Perl/darwin/auto/mapscript/mapscript.bundle definition 
of _DLAddHead
/Library/Perl/darwin/auto/DBD/Pg/Pg.bundle definition of _DLAddHead

Thanks for any suggestions,
Alex

Begin forwarded message:

> From: Alex Rice <alex_rice at arc.to>
> Date: Tue Aug 13, 2002  09:32:12  AM US/Mountain
> To: vinko at cprsig.cl
> Subject: Re: [mapserver-users] q. combining mapscript and PostGIS
>
>
> On Tuesday, August 13, 2002, at 03:07  AM, Vinko Vrsalovic wrote:
>>
>> I didn't get if you actually do a query in your mapscript code or not.
>
> So far I am only doing the queries by setting the filter on my 
> layer objects using mapscript, not doing a query with DBI.
>
> This is my first mapscript app and I'm kind of getting a feel for 
> the design issues involved.
>
>> If not, and the queries are done by mapserver libraries and you 
>> wish to
>> avoid doing an extra query, my guess is that you can't, because, 
>> AFAIU,
>> FILTER is used to determine what is shown, not how... but I may 
>> be wrong.
>
> OK, thanks for confirming. At least two pairs of eyes think so.
>
>> If you do a query, you could extract the extent in that same query, as
>> in:
>>
>> select name, zipcode, extent(the_geom) as extent from streets where
>> <...> group by name,zipcode;
>>
>
> Yes, I guess I'll just do this. I may need to use DBI for other 
> purposes in this app as well. Not sure.
>
> Thanks,
>
> Alex Rice, Software Developer
> Architectural Research Consultants, Inc.
> alex_rice at arc.to
> alrice at swcp.com
>
>