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

[Bistrais, Bob]

Yes, giving that some thought too.  Haven't successfully done the join between shapefiles, that's not to say it can't be done, though.

From: Basques, Bob (CI-StPaul) [mailto:bob.basques at ci.stpaul.mn.us]
Sent: Monday, December 03, 2012 2:30 PM
To: Bistrais, Bob; eadam at co.lincoln.or.us
Cc: geomoose-users at lists.osgeo.org
Subject: RE: [Geomoose-users] (More) trouble with query service on parcel data

All,

Well the error seems to indicate that the attempt is trying to load more data than can be handled.

Have you thought about using a separate layer for the towns and joining that with the parcels?  Can joins occur between SHP files?  I think you can do that.

Anyway, you would use the Town polygon to get a smaller Parcel dataset return and then look for the Parcel.

Bobb



From: Bistrais, Bob [mailto:Bob.Bistrais at maine.gov]
Sent: Monday, December 03, 2012 1:19 PM
To: Basques, Bob (CI-StPaul); eadam at co.lincoln.or.us<mailto:eadam at co.lincoln.or.us>
Cc: geomoose-users at lists.osgeo.org<mailto:geomoose-users at lists.osgeo.org>
Subject: RE: [Geomoose-users] (More) trouble with query service on parcel data

Here's an error message that I'm finding in Firebug:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 40 bytes) in C:\ms4w\apps\geoparcels\htdocs\php\query.php on line 340

-That was with Town as first parameter and map_bk_lot second, but I remember it happening with the parameters the other way around too.



...OK, I got that error, but then I rearranged the query parameters in Mapbook.xml, so that town would come first.  Query time on a test was about 20 seconds, but did return a proper result.  In comparison, using the layer->queryByAttributes method got a proper result in about 7 seconds, but again without the highlight.

From: Basques, Bob (CI-StPaul) [mailto:bob.basques at ci.stpaul.mn.us]<mailto:[mailto:bob.basques at ci.stpaul.mn.us]>
Sent: Monday, December 03, 2012 1:57 PM
To: eadam at co.lincoln.or.us<mailto:eadam at co.lincoln.or.us>; Bistrais, Bob
Cc: geomoose-users at lists.osgeo.org<mailto:geomoose-users at lists.osgeo.org>
Subject: RE: [Geomoose-users] (More) trouble with query service on parcel data

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> [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<mailto: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/a3432a12/attachment.html>