AnsweredAssumed Answered

ST_TRANSFORM: ORA-20603: Spatial References are not compatible

Question asked by on Sep 7, 2016
Latest reply on Nov 28, 2018 by

Hi GIS USers,


I am attempting to transform a point:
From: GSC_WGS_1984 (SRID 0 or 4326)
To: NAD_1983_StatePlane_California_III_FIPS_0403_Feet (SRID 2227).


My workflow is that the user identifies create a point in 4326. This point is then transformed to 2227 to use in a SQL spatial query against other 2227 projected data.


So I use the SQL below and get "ORA-20603: Spatial References are not compatible." Well... I can definitely transform in ArcGIS Desktop between the two systems so.. yeah they can be made compatible.


I used KWID 108190 as the transformation NAD_1984_(ITRF00)_To_NAD_1983. I have also tried without a transform. In which table are the transform ID's listed?


What am I doing wrong here or this a bug?


BTW, I have setup PEDATAHOME and this is an Oracle 11g geodatabase that has ST_GEOMETRY enabled and configured.


select sde.ST_astext (sde.st_transform (sde.st_pointfromtext ('point (37.988675 -122.086967)', 0), 2227, 108190))
from dual;




Contra Costa County
Public Works Dept.