Hi,
sorry for writing again. I hope i did not made it onto your ignorelist :-)
Ok, because i can not solve my troubles with the wfs i decided to switch to
postgis. So good, so fine.
Unfortunately my bbox-query provides some trouble.
This is my db-connection and feature-aggregation code:
DataStore dataStore = null;
try {
dataStore = DataStoreFinder.getDataStore(m);
Filter bbox = ff.bbox("the_geom", env.getMinX(),
env.getMinY(), env.getMaxX(), env.getMaxY(), null);
FeatureSource featureSource =
dataStore.getFeatureSource(dataStore.getTypeNames()[i]);
FeatureCollection fc = DataUtilities.collection(
featureSource.getFeatures( bbox ));
Unfortunately this gives the following error:
03.09.2009 15:57:00 org.geotools.data.jdbc.JDBC1DataStore executeQuery
SCHWERWIEGEND: Error Performing SQL query: SELECT "osm_id", "name", "type",
asText("the_geom") FROM "public"."naturals" WHERE "the_geom" &&
GeometryFromText('POLYGON ((7.07 50.72, 7.07 50.75, 7.12 50.75, 7.12 50.72,
7.07 50.72))', 4326) AND intersects("the_geom", GeometryFromText('POLYGON
((7.07 50.72, 7.07 50.75, 7.12 50.75, 7.12 50.72, 7.07 50.72))', 4326))
org.postgresql.util.PSQLException: ERROR: GEOS intersects() threw an error!
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:239)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:923)
at
org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:651)
at
org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:88)
at
org.geotools.data.store.DataFeatureCollection.openIterator(DataFeatureCollection.java:229)
at
org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCollection.java:199)
at
org.geotools.feature.DefaultFeatureCollection.addAll(DefaultFeatureCollection.java:270)
at
org.geotools.feature.DefaultFeatureCollection.<init>(DefaultFeatureCollection.java:88)
at org.geotools.data.DataUtilities.collection(DataUtilities.java:1012)
at MyProg.loadFeaturesFromDB(MyProg.java:176)
For debbuging i directly made the sql-query with pgadmin on my database:
SELECT "osm_id", "name", "type", asText("the_geom") FROM "public"."naturals"
WHERE "the_geom" && GeometryFromText('POLYGON ((7.07 50.72, 7.07 50.75, 7.12
50.75, 7.12 50.72, 7.07 50.72))', 4326) AND intersects("the_geom",
GeometryFromText('POLYGON ((7.07 50.72, 7.07 50.75, 7.12 50.75, 7.12 50.72,
7.07 50.72))', 4326))
Result is:
NOTICE: TopologyException: side location conflict (6.19793,50.5361,50.5361)
ERROR: GEOS intersects() threw an error!
********** Fehler **********
ERROR: GEOS intersects() threw an error!
SQL Status:XX000
If i remove the second intersects after the "AND" everything works fine. So,
why does geotools use an AND-Statement, if it is not really necessary? Any
hint, how i can solve my problem?
Thank you,
Julian
--
Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3 -
sicherer, schneller und einfacher! http://portal.gmx.net/de/go/chbrowser
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
