deegree CRS mapping postgis SRID -Problem-

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

deegree CRS mapping postgis SRID -Problem-

niels@lat/lon

Hello mailing list members!

 

First of all, thanks to Jukka for his qick Response last time.

Changing the Version from 1.1.0 to 1.0.0 solve the Problem with gdal.

 

I'm trying to configure a deegree WFS and there I'm in Trouble with configuring the database SRID.

It must be configured manually.

 

I'm using:

 

deegree 3.3.18 stable

postgres 9.5 with postgis 2.2

 

The Geometry SRID on the database is EPSG:4326

 

 The following happend to me:

 

Get Request with bbox:

 

<ServiceException code="NoApplicableCode">Error performing query by operator filter: FEHLER: Operation on mixed SRID geometries</ServiceException>

 

deegree log while reloading Workspace or restarting tomcat:

 

[12:33:33]  WARN: [MappedSchemaBuilderTable] Unable to determine geometry column details: The specified CRS 'EPSG:0' is not known. . Using defaults.
org.deegree.cs.exceptions.UnknownCRSException: The specified CRS 'EPSG:0' is not known.
        at org.deegree.cs.persistence.CRSManager.lookup(CRSManager.java:535)
        at org.deegree.cs.persistence.CRSManager.lookup(CRSManager.java:462)
        at org.deegree.feature.persistence.sql.config.MappedSchemaBuilderTable.getColumns(MappedSchemaBuilderTable.java:504)
        at org.deegree.feature.persistence.sql.config.MappedSchemaBuilderTable.process(MappedSchemaBuilderTable.java:185)
        at org.deegree.feature.persistence.sql.config.MappedSchemaBuilderTable.<init>(MappedSchemaBuilderTable.java:148)
        at org.deegree.feature.persistence.sql.config.AbstractMappedSchemaBuilder.build(AbstractMappedSchemaBuilder.java:112)
        at org.deegree.feature.persistence.sql.SQLFeatureStore.init(SQLFeatureStore.java:261)
        at org.deegree.commons.config.AbstractResourceManager.processResourceConfig(AbstractResourceManager.java:264)
        at org.deegree.commons.config.AbstractResourceManager.startup(AbstractResourceManager.java:181)
        at org.deegree.feature.persistence.FeatureStoreManager.startup(FeatureStoreManager.java:112)
        at org.deegree.commons.config.DeegreeWorkspace.initAll(DeegreeWorkspace.java:403)
        at org.deegree.services.controller.OGCFrontController.initWorkspace(OGCFrontController.java:1133)
        at org.deegree.services.controller.OGCFrontController.reload(OGCFrontController.java:1196)
        at org.deegree.console.WorkspaceBean.applyChanges(WorkspaceBean.java:231)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.apache.el.parser.AstValue.invoke(AstValue.java:279)
        at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:273)
        at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
        at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:87)
        at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:101)
        at javax.faces.component.UICommand.broadcast(UICommand.java:315)
        at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:786)
        at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1251)
        at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
        at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
        at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.deegree.client.core.filter.InputFileFilter.doFilter(InputFileFilter.java:75)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

 

Exception while performing Request:

 

      [12:37:11] ERROR: [SQLFeatureStore] Error performing query by operator filter: FEHLER: Operation on mixed SRID geometries
org.postgresql.util.PSQLException: FEHLER: Operation on mixed SRID geometries
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.deegree.feature.persistence.sql.SQLFeatureStore.queryByOperatorFilter(SQLFeatureStore.java:1421)
        at org.deegree.feature.persistence.sql.SQLFeatureStore.query(SQLFeatureStore.java:963)
        at org.deegree.feature.persistence.sql.SQLFeatureStore$1.next(SQLFeatureStore.java:1013)
        at org.deegree.feature.persistence.sql.SQLFeatureStore$1.next(SQLFeatureStore.java:998)
        at org.deegree.feature.stream.CombinedFeatureInputStream$1.hasNext(CombinedFeatureInputStream.java:106)
        at org.deegree.services.wfs.format.gml.request.GmlGetFeatureHandler.writeFeatureMembersStream(GmlGetFeatureHandler.java:424)
        at org.deegree.services.wfs.format.gml.request.GmlGetFeatureHandler.doGetFeatureResults(GmlGetFeatureHandler.java:275)
        at org.deegree.services.wfs.format.gml.GmlFormat.doGetFeature(GmlFormat.java:221)
        at org.deegree.services.wfs.WebFeatureService.doKVP(WebFeatureService.java:595)
        at org.deegree.services.controller.OGCFrontController.dispatchKVPRequest(OGCFrontController.java:807)
        at org.deegree.services.controller.OGCFrontController.doGet(OGCFrontController.java:373)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.deegree.client.core.filter.InputFileFilter.doFilter(InputFileFilter.java:75)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:745)

 

 

My Feature Store Configuration is as followed:

 

 

<SQLFeatureStore xmlns="http://www.deegree.org/datasource/feature/sql" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" configVersion="3.2.0" xsi:schemaLocation="http://www.deegree.org/datasource/feature/sql http://schemas.deegree.org/datasource/feature/sql/3.2.0/sql.xsd">

  <!-- [1] Identifier of JDBC connection -->
  <JDBCConnId>Test_DB</JDBCConnId>
<!-- Map table country to Feature Type -->
  <!--  [1] Identifier of JDBC connection -->
  <FeatureTypeMapping table="mview_gafgdi_sss_irs_r2_lis3">
   <FIDMapping>
     <Column name="id"/>
  </FIDMapping>
  <Geometry mapping="shape">  
   <StorageCRS srid="4326">EPSG:4326</StorageCRS> 

##I also tried "srid="-1" and "srid ="EPSG:4326" as well as srid="4326" and without Geometry tags. All results in the same error##
  </Geometry>
</FeatureTypeMapping>
</SQLFeatureStore>

 

 

It would be more than nice, if someone could help me to get the CRS ton The Geometry configured in a right way.
 
 
Best regards
 
Niels

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
deegree-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/deegree-users