使用ST_Transform时报“ORA-20603: Spatial References are not compatible”

接到一用户的问题，再使用ST_Transform时报“ORA-20603: Spatial References are not compatible”。

查看ST_Transform时有一个关键的地方：

 

“SRIDs 102 and 105 have to exist in the ST_SPATIAL_REFERENCES view, and both must have the same geographic datum.”

也就是说，在实现转换的过程中，两个投影文件必须要有一样的椭球体。

我们查看st_spatial_references表中的SRID信息

SQL> select srid,sr_name from sde.st_spatial_references order by srid;<br /> SRID SR_NAME<br /> ———- ————————————————————<br /> 0 GCS_WGS_1984<br /> 2 GCS_Abidjan_1987<br /> 3 NAD_1927_StatePlane_Alabama_East_FIPS_0101<br /> 4 Unknown_CoordSys<br /> 5 Xian_1980_3_Degree_GK_CM_102E<br /> 6 Unknown_CoordSys<br /> 7 Unknown_CoordSys<br /> 8 GCS_WGS_1984<br /> 9 GCS_WGS_1984<br /> 10 Unknown_CoordSys<br /> 11 Unknown_CoordSys<br /> SRID SR_NAME<br /> ———- ————————————————————<br /> 12 Unknown_CoordSys<br /> 13 NAD_1983_StatePlane_Ohio_South_FIPS_3402_Feet<br /> 14 Pulkovo_1942_GK_Zone_18<br /> 15 Xian_1980_3_Degree_GK_Zone_39<br /> 16 GCS_WGS_1984<br /> 17 Xian_1980_3_Degree_GK_CM_111E<br /> 18 Xian_1980_3_Degree_GK_CM_120E<br /> 19 Xian_1980_3_Degree_GK_Zone_39<br /> 20 NAD_1983_StatePlane_California_II_FIPS_0402_Feet<br /> 21 NAD_1983_StatePlane_California_II_FIPS_0402_Feet<br /> 22 NTF_Lambert_II<br /> SRID SR_NAME<br /> ———- ————————————————————<br /> 23 Deutsches_Hauptdreiecksnetz_Transverse_Mercator<br /> 24 GCS_Beijing_1954<br /> 25 Beijing_1954_GK_Zone_20N<br /> 26 Beijing_1954_GK_Zone_20N<br /> 27 NAD_1983_StatePlane_North_Carolina_FIPS_3200_Feet<br /> 28 Xian_1980_3_Degree_GK_CM_114E<br /> 29 Xian_1980_3_Degree_GK_CM_102E<br /> 30 Xian_1980_3_Degree_GK_CM_105E<br /> 31 Unknown_CoordSys<br /> 32 Xian_1980_3_Degree_GK_CM_87E<br /> 33 Xian_1980_3_Degree_GK_CM_84E<br /> SRID SR_NAME<br /> ———- ————————————————————<br /> 34 NAD_1927_StatePlane_Alabama_East_FIPS_0101<br /> 35 Africa_Albers_Equal_Area_Conic<br /> 36 GCS_Batavia<br /> 37 GCS_Krasovsky_1940<br /> 38 Beijing_1954_3_Degree_GK_CM_114E<br /> 39 Unknown_CoordSys<br /> 40 Unknown_CoordSys<br /> 41 Suzhou_1954_3_Degree_GK_CM_120E<br /> 42 NAD_1983_StatePlane_Vermont_FIPS_4400<br /> 43 Xian_1980_3_Degree_GK_CM_111E<br /> 44 Lat Long WGS84<br /> SRID SR_NAME<br /> ———- ————————————————————<br /> 45 Xian_1980_3_Degree_GK_CM_117E<br /> 46 Unknown_CoordSys<br /> 47 Xian_1980_3_Degree_GK_CM_117E<br /> 48 Unknown_CoordSys<br /> 49 Unknown_CoordSys<br /> 50 Unknown_CoordSys<br /> 51 GCS_North_American_1983<br /> 52 NAD_1983_Texas_Statewide_Mapping_System<br /> 53 Unknown_CoordSys<br /> 54 Unknown_CoordSys<br /> 55 GCS_Xian_1980<br /> SRID SR_NAME<br /> ———- ————————————————————<br /> 56 GCS_Beijing_1954<br /> 57 Xian_1980_3_Degree_GK_Zone_29<br /> 58 NAD_1983_HARN_Adj_MN_Beltrami_North_Meters<br /> 59 GCS_Xian_1980<br /> 已选择59行。 

 

我们进行相关测试

 

SQL> select sde.st_astext(sde.st_transform(sde.st_point(‘point(1 1)’,59), 30) ) from dual ;<br /> SDE.ST_ASTEXT(SDE.ST_TRANSFORM(SDE.ST_POINT(‘POINT(11)’,59),30))<br /> ——————————————————————————–<br /> EMPTY<br /> SQL> select sde.st_astext(sde.st_transform(sde.st_point(‘point(1 1)’,30), 59) ) from dual ;<br /> SDE.ST_ASTEXT(SDE.ST_TRANSFORM(SDE.ST_POINT(‘POINT(11)’,30),59))<br /> ——————————————————————————–<br /> POINT ( 100.51305898 0.00000902)<br /> SQL> select sde.st_astext(sde.st_transform(sde.st_point(‘point(1 1)’,30), 56) ) from dual ;<br /> ERROR:<br /> ORA-20603: Spatial References are not compatible.<br /> ORA-06512: 在 “SDE.ST_GEOMETRY_SHAPELIB_PKG”, line 788<br /> ORA-06512: 在 “SDE.ST_GEOMETRY_OPERATORS”, line 2577<br /> 未选定行 

56 GCS_Beijing_1954

30 Xian_1980_3_Degree_GK_CM_105E

椭球体不一致

 

SQL> select sde.st_astext(sde.st_transform(sde.st_point(‘point(109.51305898 0.00000902)’,59), 28) ) from dual;<br /> SDE.ST_ASTEXT(SDE.ST_TRANSFORM(SDE.ST_POINT(‘POINT(109.513058980.00000902)’,59),<br /> ——————————————————————————–<br /> POINT ( 1.00019519 1.00046738) 

 

SQL> select sde.st_astext(sde.st_transform(sde.st_point(‘point(1 1)’,18), 59) ) from dual<br /> SDE.ST_ASTEXT(SDE.ST_TRANSFORM(SDE.ST_POINT(‘POINT(11)’,18),59))<br /> ——————————————————————————–<br /> POINT ( 115.51305898 0.00000902)<br /> SQL> select sde.st_astext(sde.st_transform(sde.st_point(‘point(1 1)’,59), 59) ) from dual<br /> SDE.ST_ASTEXT(SDE.ST_TRANSFORM(SDE.ST_POINT(‘POINT(11)’,59),59))<br /> ——————————————————————————–<br /> POINT ( 1.00000000 1.00000000)<br /> SQL> select sde.st_astext(sde.st_transform(sde.st_point(‘point(1 1)’,55), 59) ) from dual<br /> SDE.ST_ASTEXT(SDE.ST_TRANSFORM(SDE.ST_POINT(‘POINT(11)’,55),59))<br /> ——————————————————————————–<br /> POINT ( 1.00000000 1.00000000)<br /> SQL> select sde.st_astext(sde.st_transform(sde.st_point(‘point(1 1)’,8), 59) ) from dual ;<br /> ERROR:<br /> ORA-20603: Spatial References are not compatible.<br /> ORA-06512: 在 “SDE.ST_GEOMETRY_SHAPELIB_PKG”, line 788<br /> ORA-06512: 在 “SDE.ST_GEOMETRY_OPERATORS”, line 2577<br /> 未选定行<br /> SQL> select sde.st_astext(sde.st_transform(sde.st_point(‘point(1 1)’,7), 59) ) from dual ;<br /> ERROR:<br /> ORA-20603: Spatial References are not compatible.<br /> ORA-06512: 在 “SDE.ST_GEOMETRY_SHAPELIB_PKG”, line 788<br /> ORA-06512: 在 “SDE.ST_GEOMETRY_OPERATORS”, line 2577<br /> 未选定行 

 7 Unknown_CoordSys

 8 GCS_WGS_1984

——————————

 59 GCS_Xian_1980

椭球体不一致

 

 

凡是出现该错误的都是相关的椭球体（datum)不一致造成的

转载自：https://blog.csdn.net/linghe301/article/details/6409135