laptop and a wrench

Bug

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
Bug ID Number BUG-000168153
SubmittedJune 7, 2024
Last ModifiedDecember 28, 2025
Applies toArcGIS Pro
Version found3.3
Operating SystemWindows OS
Operating System Version10.0
StatusWill Not Be Addressed

Additional Information

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.

Workaround

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

Steps to Reproduce

Bug ID: BUG-000168153

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options