[Geomoose-users] (More) trouble with query service on parcel data

[Basques, Bob (CI-StPaul)]

I haven't done many queries against SHP files, but if you can, try flipping the query around, so the TOWN is used first to localize the query, then hit the Parcel/Lot search.

This should increase performance somewhat.

Bobb



From: geomoose-users-bounces at lists.osgeo.org [mailto:geomoose-users-bounces at lists.osgeo.org] On Behalf Of Eli Adam
Sent: Monday, December 03, 2012 12:54 PM
To: Bistrais, Bob
Cc: geomoose-users at lists.osgeo.org
Subject: Re: [Geomoose-users] (More) trouble with query service on parcel data


On Mon, Dec 3, 2012 at 10:31 AM, Bistrais, Bob <Bob.Bistrais at maine.gov<mailto:Bob.Bistrais at maine.gov>> wrote:
I'm still managing to crash the standard GM query service with my statewide parcel layer.  First, I'll disclose that the parcel data is a shapefile.  This actually turned out to be the most reliable.  I've tried FileGDB, and this actually choked more readily than shape.  PostGIS, unfortunately, is not an option to my shop.
So, using the standard query service, I type in two parameters (map_bk_lot and town).  I get the timeout error.

You might be able to adjust your php settings (or other aspects) to allow for longer running queries.

Eli


If I take a subset of the data, such as a town or county, it'll work with the shapefile.
Furthermore, I experimented using layer->queryByAttributes, and this works very well with the statewide shapefile.  (and again, the FileGDB croaked) Problem here is, I'd like to use the standard highlighting and zoom to that come with GM, but I've gotten lost in that part of the code.
Any guidance/suggestions?


_______________________________________________
Geomoose-users mailing list
Geomoose-users at lists.osgeo.org<mailto:Geomoose-users at lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/geomoose-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20121203/4827755f/attachment-0001.html>