2015-05-28 16:33 GMT+02:00 Andrea Aime <andrea.a...@geo-solutions.it>:
> On Thu, May 28, 2015 at 4:08 PM, Mark Prins <mc.pr...@gmail.com> wrote:
>>
>> I've been experimenting with a RELATE + DE-9IM matrix query and the
>> setMaxFeatures method on postgis and it appears that setting the max
>> features prevents returning proper results because the query to the
>> database sets a limit, but the filter is executed locally...(so only
>> run on the retrieved features) which leads to some unexpected results,
>> eg. no faatures returned, but count says there should be.
>
>
> Looks like a bug, if the filter is not completely encodable, we should not
> encode
> limit and offset either.
OK
>>
>>
>>
>> Q: is there any way to force geotools to send the complete query to
>> the database? which would be something like:
>> select * from editable where ST_relate(
>> begrenzing_perceel,
>> st_geomfromtext('LINESTRING(63712 553056,100576 556640,146912
>> 555360,190176 557664)',28992),
>> '1F20F1102'
>> );
>
>
> I believe you are using the relate filter function right? You can modify the
> PostgisFilterToSql to encode it.
so adding a public Object visit(FilterFunction_relatePattern filter,
Object extraData) {} in PostgisFilterToSql that writes the SQL should
do the trick? or would I need to add a filter capability as well?
-m
------------------------------------------------------------------------------
_______________________________________________
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
