Importing data from Local Government Information Model to a PostgreSQL geodatabase returns the error, "XML Import Error: Column already exist"
上次发布: April 4, 2015ArcGIS for Desktop
漏洞 ID 编号
BUG-000086278
已提交
March 20, 2015
上次修改时间
June 5, 2024
适用范围
ArcGIS for Desktop
找到的版本
10.2
状态
Known Limit
经开发团队审核,已确定此问题与不受 Esri 控制的软件的已知限制有关。 问题的“其他信息”部分可能包含进一步说明。
附加信息
This is a known limitation of working with the Local Government Information Model in PostgreSQL because the US National Grid feature class is based on the FGDC standard.
Workaround: Prior to importing the Local Government Information Model into your PostgreSQL geodatabase remove the reserve system (XMIN) field and replace it with a field called XMIN_1.
1. Import Local Government XML workspace to a file geodatabase.
2. Delete the XMIN field from the US National Grid feature class.
3. In the US National feature class create a new field and name it something other than XMIN, for example XMIN_1.
4. Export to a new XML workspace, then import it into PostgreSQL geodatabase.
解决办法
- Import XML to file geodatabase.
- Rename XMIN to XMIN _1 for feature class USNationalGrid under feature dataset EmergencyOperations.
- Copy and paste, or import data to SDE geodatabase.