dolthub / dolthub/dolt

Weird behavior appending data with ogr2ogr (spatial)

Open
#5,959 0 comments 0 reactions 1 assignee Claimed by @jycor View on GitHub
customer issue spatial types
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.