laptop and a wrench

Bogue

Importing the SpatiaLite dataset from the SQLite database with negative values into ArcGIS Pro does not allow for negative values to show up.

ArcGIS Pro
Numéro d’ID de bogue BUG-000168153
EnvoiJune 7, 2024
Dernière modificationDecember 28, 2025
S’applique àArcGIS Pro
Version trouvée3.3
Système d’exploitationWindows OS
Version du système d’exploitation10.0
StatutWill Not Be Addressed

Informations supplémentaires

The feature class has an unknown spatial reference with an SRID of 5973. This SRID is not present in the spatial_ref_sys table (a SpatiaLite table). SpatiaLite databases created by ArcGIS Pro include this SRID, but the SRID is missing from the client database for unknown reasons. This issue is resolved using the following procedure with sqlite3.exe or a SQLite UI tool: 1. Create a SpatiaLite database named base.sqlite using ArcGIS Pro (the name is not important; note the chosen name). 2. Open the original SpatiaLite database. 3. At the SQLite prompt, enter: ATTACH DATABASE 'C:\temp\BUG-000168153\base.sqlite' AS esridb; 4. Run the following command: INSERT INTO main.spatial_ref_sys (srid,auth_name,auth_srid,ref_sys_name,proj4text,srtext) SELECT srid,auth_name,auth_srid,ref_sys_name,proj4text,srtext FROM esridb.spatial_ref_sys WHERE srid=5973; 5. Verify the addition: SELECT * FROM spatial_ref_sys WHERE srid = 5973; 6. Exit sqlite3.exe or the SQLite UI tool. The data draws correctly after completing these steps.

Solution de contournement

When using the Create SQlite Database tool, geometry with negative x-values can be created in the ST_Geometry feature class.

Étapes pour reproduire

ID de bogue: BUG-000168153

Logiciel:

  • ArcGIS Pro

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