Ok, got it. Problem was that if you create a spatial index on a layer that is way out of whack with reality (1000000 units square spatial index grid tiles) then sde's spatial index-based queries (which the calculateResultCount method relies on) will not return good results. Unfortunately when I loaded the data in using shp2sde the grid size was set (by default) at a number with way too many zeroes. I re-loaded with a much more reasonable scale, and therefore grid size, and now everything is working just fine. I'll update the README.txt file in that directory, and chalk it up to more SDE knowledge to be forgotten before the next time it bites me. --saul
________________________________ From: [EMAIL PROTECTED] on behalf of Farber, Saul (EEA) Sent: Wed 6/20/2007 8:00 PM To: geotools-devel@lists.sourceforge.net Subject: Re: [Geotools-devel] Strange ArcSDE failures and daily recap Hmm, replying to my own emails now. Anyway, feel free to hop on IRC with me tomorrow gabriel (if you get the time!) I've got some more info on that problem. Short overview: ArcSDEQuery.calculateResultCount(bboxfilter) is returning five, while actually going and fetching the features is returning 6 features. Blech. --saul ________________________________ From: [EMAIL PROTECTED] on behalf of Farber, Saul (EEA) Sent: Wed 6/20/2007 7:34 PM To: geotools-devel@lists.sourceforge.net Subject: [Geotools-devel] Strange ArcSDE failures and daily recap Hey interested ArcSDE-ers (meaning: Hi Gabriel) I committed the work we talked about on IRC today. Mostly it was bugfixes to support configuration keywords other than "DEFAULTS" on table creation, and a mini fix to support the actual creation of nil shapes. However, I'm still failing one test, and I'm having trouble figuring it out. I'll keep poking to try and figure out why, but the symptoms are that when I start up geoserver 1.6.x using the freshly compiled 2.4.x-SNAPSHOT geotools (with all my ArcSDE changes) and then I run the following wfs request: http://localhost:8080/geoserver/wfs?request=getfeature&service=WFS&version=1.0.0&typeName=massgis:SFARBER.TEST_POINT&BBOX=-60,-55,-40,-20 I get back exactly 6 points. Just as would be expected. However, when I run the testBBoxFilterPoints() test in ArcSDEDataStoreTest, I only get back 5 points as results. The testBBoxFilterPoints() method just calls: filter = ff.bbox(name, -60,-55,-40,-20, srs); FeatureCollection fc = fsource.getFeatures(filter); And this returns 5 points! I'm not sure what's going on, but udig is also having weird troubles with one point in that set when I use it as a WFS client to my running geoserver, so I'm going to look into it further. So that test is failing, but everything else should be all set. --saul ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
