[mapserver-users] queryByFeatures not working in 5.6.6?

[Lime, Steve D (DNR)]

queryByFeatures uses a query against one layer to select features that are used against other layers. For example, select a county by name and then use it to select lakes or whatever. It's probably a stupid name for the method but that's what it does. It's a two-stage query and a pretty specific use case.

As for why things would stop working, not sure without more information. With some of the query processing speedups added in the 5.4 and 5.6 versions we used the various indexes in a result object to store information necessary for fast access. I see you're not passing the result tileindex:

  $oShape = $oLayer_lurc_parcels->getFeature($oResult->shapeindex,-1);

That may be the source of the problem. What happens if you do:

  $oShape = $oLayer_lurc_parcels->getFeature($oResult->shapeindex, $oResult->tileindex);

instead?

Steve

________________________________________
From: mapserver-users-bounces at lists.osgeo.org [mapserver-users-bounces at lists.osgeo.org] On Behalf Of Bistrais, Bob [Bob.Bistrais at maine.gov]
Sent: Tuesday, March 01, 2011 2:01 PM
To: Mathieu Kouri; mapserver-users
Subject: RE: [mapserver-users] queryByFeatures not working in 5.6.6?

I think I’ve found a workaround.  I actually replaced my queryByFeatures with a queryByShape.  This works in my application.  But, I’m afraid I can’t explain why the queryByShape is not working for Mathieu.  Maybe you should try queryByFeatures and see if it works for you!

________________________________
From: Mathieu Kouri [mailto:mkouri at dbxgeomatics.com]
Sent: Tuesday, March 01, 2011 2:33 PM
To: Bistrais, Bob; mapserver-users
Subject: RE: [mapserver-users] queryByFeatures not working in 5.6.6?

Hi,
I would like to mention  that we have been also having problem in using queryByShape(...).
We were on 5.6.4 and everything was working fine but when updating to 5.6.6 this is no longer seems to be working.

Thanks

From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Bistrais, Bob
Sent: March-01-11 11:56 AM
To: mapserver-users
Subject: [mapserver-users] queryByFeatures not working in 5.6.6?

We are upgrading our MapServer installation to 5.6.6, and now are finding a problem with queries that were previously working.

I’m tracing the problem to a queryByFeatures operation.  We are taking a selected parcel and querying a zoning layer to see what zones are intersected by the parcel.  We are able to successfully select the parcel by a queryByAttributes.  We get the shape from the selected parcel, then attempt a queryByFeatures.  But no results are returned for the zoning layer.

As I mentioned earlier, this was functioning properly in the previous version of MapServer.  Is there a change in syntax or something else that I’m not aware of?

Here is some of the code to perform the query:

-At this point, a parcel has been selected…

// Loop through the results set (there should only be one), get the shape, and save the
// shape attributes.
for ($i=0; $i<=($oLayer_lurc_parcels->getNumResults() - 1); $i++) {
            $oResult = $oLayer_lurc_parcels->getResult($i);
            $oLayer_lurc_parcels->open();
            $oShape = $oLayer_lurc_parcels->getFeature($oResult->shapeindex,-1);
            $TPL = $oShape->getValue($oLayer_lurc_parcels,"TPL");
            $_SESSION['results']['TPL'][$_SESSION['nresults']] = substr($TPL,0,5);
            $oLayer_lurc_parcels->close();
}

// Perform the intersection; query the zones layer with the parcel feature.  Again, should
// only be one parcel.
$oLayer_lurc_zones->queryByFeatures($oLayer_lurc_parcels->index);