topic SDE.ST_TRANSFORM ERROR in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/sde-st-transform-error/m-p/237348#M9124 <HTML><HEAD></HEAD><BODY><SPAN>I get the following error when trying to transform points stored in ST_GEOMETRY EPSG 32198 into WGS 84 EPSG 4326:</SPAN><BR /><BR /><SPAN>ORA-20603: Spatial References are not compatible.</SPAN><BR /><SPAN>ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 720</SPAN><BR /><SPAN>ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 2623</SPAN><BR /><BR /><SPAN>All our data is stored in EPSG 32198 and according to spatialreference.org (</SPAN><A class="jive-link-external-small" href="http://spatialreference.org/ref/epsg/32198/prettywkt/" rel="nofollow" target="_blank">http://spatialreference.org/ref/epsg/32198/prettywkt/</A><SPAN>) this projection is based on datum NAD83 ESPG 4269.</SPAN><BR /><BR /><SPAN>It looks like ST_TRANSFORM is having a hard time to convert NAD 83 EPSG 4269 based projection (like 32198) into WGS 84 EPSG 4326. Which I believe to be a very simple task for any GIS software. The conversion between them, at least in North America should be straight forward. </SPAN><BR /><BR /><SPAN>Weird isn't it?</SPAN><BR /><BR /><SPAN>The work around I found was to use NAD 83 EPSG 4269.</SPAN><BR /><SPAN>sde.st_x(sde.st_transform(a.SHAPE,4269)) </SPAN><BR /><SPAN>sde.st_Y(sde.st_transform(a.shape,4269)) </SPAN><BR /><BR /><SPAN>And it worked!</SPAN><BR /><BR /><SPAN>Hope this can help someone!</SPAN></BODY></HTML> Tue, 19 Feb 2013 13:16:28 GMT Jean-BernardGariépy 2013-02-19T13:16:28Z SDE.ST_TRANSFORM ERROR https://community.esri.com/t5/arcgis-enterprise-questions/sde-st-transform-error/m-p/237348#M9124 <HTML><HEAD></HEAD><BODY><SPAN>I get the following error when trying to transform points stored in ST_GEOMETRY EPSG 32198 into WGS 84 EPSG 4326:</SPAN><BR /><BR /><SPAN>ORA-20603: Spatial References are not compatible.</SPAN><BR /><SPAN>ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 720</SPAN><BR /><SPAN>ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 2623</SPAN><BR /><BR /><SPAN>All our data is stored in EPSG 32198 and according to spatialreference.org (</SPAN><A class="jive-link-external-small" href="http://spatialreference.org/ref/epsg/32198/prettywkt/" rel="nofollow" target="_blank">http://spatialreference.org/ref/epsg/32198/prettywkt/</A><SPAN>) this projection is based on datum NAD83 ESPG 4269.</SPAN><BR /><BR /><SPAN>It looks like ST_TRANSFORM is having a hard time to convert NAD 83 EPSG 4269 based projection (like 32198) into WGS 84 EPSG 4326. Which I believe to be a very simple task for any GIS software. The conversion between them, at least in North America should be straight forward. </SPAN><BR /><BR /><SPAN>Weird isn't it?</SPAN><BR /><BR /><SPAN>The work around I found was to use NAD 83 EPSG 4269.</SPAN><BR /><SPAN>sde.st_x(sde.st_transform(a.SHAPE,4269)) </SPAN><BR /><SPAN>sde.st_Y(sde.st_transform(a.shape,4269)) </SPAN><BR /><BR /><SPAN>And it worked!</SPAN><BR /><BR /><SPAN>Hope this can help someone!</SPAN></BODY></HTML> Tue, 19 Feb 2013 13:16:28 GMT https://community.esri.com/t5/arcgis-enterprise-questions/sde-st-transform-error/m-p/237348#M9124 Jean-BernardGariépy 2013-02-19T13:16:28Z