Weird behavior appending data with ogr2ogr (spatial)
- Dominant language
- Go
- Stars
- 24.4k
- Forks
- 873
- Avg merge
- 1d 9h
- Merged PRs (30d)
- 121
Description
Hi all.
This issue can be checked from this comment: https://github.com/dolthub/dolt/issues/5948#issuecomment-1549143042
There is all the data and tests.
As a summary, when we append data to a spatial data that is not 4326, something fails between ogr2ogr and Dolt causing this insert statement:
```
INSERT INTO `aeropuertos` (`geom` , `objectid_1`, `cod_comuna`, `categoría`, `cod_oaci`, `cod_iata`, `aerodromo`, `region`, `provincia`, `comuna`) VALUES (ST_GeomFromText('POINT (-7860125.2396 -3040341.3372)',-2) , 39, 3201, 'Aeródromo', 'SCRA', 'CNR', 'Aeródromo Chañaral', 'Región de Atacama', 'Chañaral', 'Chañaral')
```
CRS -2 means the CRS is not initialized, this does not happens when we have data in 4326.
I don't know if this issue is from Dolt or GDAL, so here the related issue: https://github.com/OSGeo/gdal/issues/7781
Thx!
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.