Hey guys,
I've been trying to get GeoTools to use the PostGIS ST_AREA function
when doing a SELECT query for some time so that fewer results are returned,
e.g. "SELECT * FROM table WHERE ST_AREA(the_geom) > 200;", but have
had no luck so far.
FilterFactory.function("ST_AREA", ...) gives an exception saying "St_area
cannot be found". If I replace "ST_AREA" with "AREA", it does post-fetching
filtering instead which is not what I wanted (I verified this by having
PostgreSQL
log all queries - ST_AREA never shows up in the where clause).
I've searched through the sources and google but can't find mention of using
ST_AREA with GeoTools anywhere.
Was hoping to get some ideas on how this could be done.
Cheers,
riverfullofgood------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
