I am trying to insert a new feature in Oracle Spatial through WFS-T
service, but I get an error related to projection ("Layer SRID does not
match geometry SRID"), is there something wrong with my request?
These are my request and error response:
REQUEST:
<!--
YOU PROBABLY DO NOT WANT TO RUN THIS QUERY SINCE
IT WILL MODIFY YOUR SOURCE DATA FILES
It will add a simple line to the tasmania_roads dataset.
-->
<wfs:Transaction service="WFS" version="1.0.0"
xmlns:wfs="http://www.opengis.net/wfs"
xmlns:topp="http://www.openplans.org/topp"
xmlns:gml="http://www.opengis.net/gml"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd
http://www.openplans.org/topp
http://10.10.10.57/geoserver/wfs/DescribeFeatureType?typename=topp:CARRE
TERAS_CAM">
<wfs:Insert>
<topp:CARRETERAS_CAM>
<topp:GEOMETRY1>
<gml:MultiLineString srsName="epsg:32630">
<gml:lineStringMember>
<gml:LineString>
<gml:coordinates decimal="." cs="," ts=" ">
450000,4500000 450000,4540000
</gml:coordinates>
</gml:LineString>
</gml:lineStringMember>
</gml:MultiLineString>
</topp:GEOMETRY1>
<topp:CD_CARRETERA>1000</topp:CD_CARRETERA>
<topp:CD_TIPO_CARRETERA>1</topp:CD_TIPO_CARRETERA>
<topp:CD_TIPO_ADMON_CARRETERA>1</topp:CD_TIPO_ADMON_CARRETERA>
</topp:CARRETERAS_CAM>
</wfs:Insert>
</wfs:Transaction>
ERROR RESPONSE:
org.geotools.data.DataSourceException: SQL Exception writing geometry
columnORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-13365: Layer SRID does not match geometry SRID
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 319
ORA-06512: at line 1 at
org.geotools.data.oracle.OracleFeatureWriter.doInsert(
_____
De: Wim Blanken [mailto:w.blanken@anonymised.com]
Enviado el: lunes, 12 de febrero de 2007 18:02
Para: geoserver-users@lists.sourceforge.net
Asunto: [Geoserver-users] FW: Dutch projection problem
_____
Van: Wim Blanken [mailto:w.blanken@anonymised.com]
Verzonden: maandag 12 februari 2007 17:58
Aan: 'geoserver-users@lists.sourceforge.net'
Onderwerp: Dutch projection problem
Hello list,
I am using Geoserver 1.4.0 to serve KML. There is however a bug in the
reprojection from epsg:28992 to WGS84.
The map is about 30-50 meters wrong mostly to the north.
In Mapserver I could simply repair the parameters in the proj. tekstfile
(sterea instead of stere). In Geoserver however I do not see this
parameter.
It has something to do with the Oublique_stereographic projection. It
should be Double_stereographic I believe but that option is not valid in
the epgs.properties file I believe.
Anybody any ideas how to fix this in Geoserver?
With regards,
Wim Blanken
The Netherlands