laptop and a wrench

Bogue

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

Dernière publication: April 4, 2015 ArcGIS for Desktop
Numéro d’ID de bogue BUG-000086278
EnvoiMarch 20, 2015
Dernière modificationJune 5, 2024
S’applique àArcGIS for Desktop
Version trouvée10.2
StatutKnown Limit

Informations supplémentaires

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.

Solution de contournement

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

Étapes pour reproduire

ID de bogue: BUG-000086278

Logiciel:

  • ArcGIS for Desktop

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement