使用ST_Transform时报“ORA-20603: Spatial References are not compatible”
来源:互联网 发布:数据质量管理平台方案 编辑:程序博客网 时间:2024/05/22 09:02
接到一用户的问题,再使用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信息
我们进行相关测试
56 GCS_Beijing_1954
30 Xian_1980_3_Degree_GK_CM_105E
椭球体不一致
7 Unknown_CoordSys
8 GCS_WGS_1984
------------------------------
59 GCS_Xian_1980
椭球体不一致
凡是出现该错误的都是相关的椭球体(datum)不一致造成的
- 使用ST_Transform时报“ORA-20603: Spatial References are not compatible”
- The AssetBundle could not be loaded because it references scripts that are not compatible ...
- Error: The spatial references do not match
- php_lang_ref:Language Reference >> References Explained >> What References Are Not
- Item 05. 引用(References Are Aliases, Not Pointers)
- Log and data area are not compatible because 'Restart position not found
- 使用sqlplus连接数据库时报"ORA-12154:TNS:could not resolve the connect identifier specified"解决办法
- 安装Oracle10g CRS时报The specified nodes are not clusterable
- Ubuntu 12.04 : “The system network services are not compatible with this version”
- ValueError: Shapes (40, 4, 4, 1) and (?, 8, 8, 1) are not compatible
- Can't process attribute android:fillColor="@color/text_gray": references to other resources are not
- ORA-00401: the value for parameter compatible is not supported by this release
- ORA-15238: 11.2 is not a valid value for attribute compatible.advm 处理方法
- ORA-39358: Export Dump File Version 12.2.0 Not Compatible With Target Version 11.2.0
- 在使用dblink时报错:ORA-01017、ORA-02063解决
- keil55.24打开一个工程出现the project references devices,files or libraries that are not installed
- php_lang_ref:Language Reference >> References Explained >> What References Are
- Spatial references, coordinate systems, projections, datums, ellipsoids – confusing?
- VS2005 SP1 安装时候,提示“无法使用此产品的安装源,请确认安装源存在,并且您可以访问它”的错误
- memset函数详细讲解
- 创建状态栏
- python笔记
- Extjs--HelloWorld(转载)
- 使用ST_Transform时报“ORA-20603: Spatial References are not compatible”
- MFC中菜单的简单用法
- QT常用类
- 国嵌 linux 常用命令
- 测试用例实例
- 弹出子窗口并刷新父窗口(子窗口中打开子窗口)
- Hadoop学习笔记一 简要介绍
- ExtJs学习笔记(2)_Basic GridPanel[基本网格]
- HDU 3081 Marriage Match II 并查集加网络流