laptop and a wrench

Bug

Importing data from Local Government Information Model to a PostgreSQL geodatabase returns the error, "XML Import Error: Column already exist"

Zuletzt veröffentlicht: April 4, 2015 ArcGIS for Desktop
Bug-ID-Nummer BUG-000086278
EingereichtMarch 20, 2015
Zuletzt geändertJune 5, 2024
Gilt fürArcGIS for Desktop
Gefunden in Version10.2
StatusKnown Limit

Zusätzliche Informationen

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.

Workaround

- 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.

Schritte zur Reproduzierung

Bug-ID: BUG-000086278

Software:

  • ArcGIS for Desktop

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln