[mapserver-users] join table to shape file before query

[Steve Lime]

You have to use OGR to do this and not MapServer JOINs.

Steve

>>> On 12/3/2008 at 10:00 AM, in message
<5863BC6EA0494C498F8C7A389EF32E491CA785F2AF at BannerExg.banner.bannerbkgs.com>,
Jim Hagedorn <jhagedorn at bannerbkgs.com> wrote:
> I need to join a table with a shape file before I do a query.  I have a shape 
> file with polygons and the table has info on the polys but the table could 
> have multiple entries for each polygon.  I need to search on the table and 
> then be able to zoom to the polygon for that entry in the table.  I have done 
> the join but that is after the query and can only query the polygon but it 
> doesn't have the info I need to search on.  is it possible to do the join 
> first or somehow query the table and then relate back to the shapefile?
> 
> thanks
> 
> 
> Jim Hagedorn
> GIS Specialist
> 
> 
> [cid:image001.gif at 01C9552E.0806A6C0] 
> 
> Banner Associates, Inc.
> 409 22nd Avenue South * PO Box 298 * Brookings, South Dakota 57006
> (605) 692-6342  *  Fax (605) 692-5714
> www.bannerassociates.com<http://www.bannerassociates.com/>