[postgis-users] PostGIS, Mapserver and itemquery question from a newbie

[coldwell at csptexas.com]

Good Morning,

I have a Mapserver application I'd like to move to PostGIS from shapefiles. Most of it works fine, indeed, better than with shapefiles. But in a couple of places, it is necessary to launch the Mapserver with an itemqery via a URL like this:

http://127.0.0.1/cgi-bin/mapserv?mode=itemquery&mapxy=shapes&buffer=1000&qlayer=Parcels&qitem=PROP_ID&qstring=253068&map=/var/www....

or, an itemNquery like this:

...&qitem=PROP_ID&qstring=('[PROP_ID]'+IN+'111444,253068,2507350')&map=/var/www/html/collin/collin.map

These examples work fine with a shape file, but crash with PostGIS.

By examining the error message, it appears that the qstring parameter should be a SQL where clause.

If I change the first example to look like this:

qlayer=Parcels&qitem=PROP_ID&qstring=(prop_id=253068)&map=/var/www....

it has worked, but very, very slowly. The PostgreSQL table has not only a spatial index, but prop_id and oid as well.

I've read a thread in the archives some time ago that seems related, but I seem to be missing some context. I don't understand what I'm reading.

Any advice or help would be greatly appreciated.

Thanks in advance,