laptop and a wrench

Error

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
Número de ID del error BUG-000168153
EnviadoJune 7, 2024
Última modificaciónDecember 28, 2025
Relacionado conArcGIS Pro
Versión encontrada3.3
Sistema operativoWindows OS
Versión de sistema operativo10.0
EstadoWill Not Be Addressed

Información adicional

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.

Solución alternativa

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

Pasos para reproducir

ID del error: BUG-000168153

Software:

  • ArcGIS Pro

Recibir notificaciones cuando cambie el estado de un error

Descargar la aplicación de soporte de Esri

Descubrir más sobre este tema

Obtener ayuda de expertos en ArcGIS

Contactar con el soporte técnico

Descargar la aplicación de soporte de Esri

Ir a opciones de descarga