laptop and a wrench

Erro

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 do Erro BUG-000168153
EnviadoJune 7, 2024
Última ModificaçãoDecember 28, 2025
Aplica-se àArcGIS Pro
Versão encontrada3.3
Sistema OperacionalWindows OS
Versão do Sistema Operacional10.0
StatusWill Not Be Addressed

Informações Adicionais

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.

Solução Provisória

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

Etapas para Reproduzir

ID do Erro: BUG-000168153

Software:

  • ArcGIS Pro

Seja notificado quando o status de um erro mudar

Baixe o Aplicativo de Suporte da Esri

Descubra mais sobre este tema

Obtenha ajuda de especialistas do ArcGIS

Entre em contato com Suporte Técnico

Baixe o Aplicativo de Suporte da Esri

Ir para as opções de download