| Bug ID Number |
BUG-000168153 |
| Submitted | June 7, 2024 |
| Last Modified | December 28, 2025 |
| Applies to | ArcGIS Pro |
| Version found | 3.3 |
| Operating System | Windows OS |
| Operating System Version | 10.0 |
| Status | Will Not Be Addressed
The development team has considered the issue or request and concluded it will not be addressed. The issue's Additional Information section may contain further explanation.
|
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