Opened 12 years ago
Last modified 12 years ago
#4654 closed defect
ogr2ogr not handling null column name values in CSV — at Version 1
Reported by: | andrewxhill | Owned by: | warmerdam |
---|---|---|---|
Priority: | normal | Milestone: | 1.9.1 |
Component: | OGR_SF | Version: | unspecified |
Severity: | normal | Keywords: | csv |
Cc: |
Description (last modified by )
Data exported from R (and others I'm sure), will often contain a null column name over an ID column. Something like,
"", "Name","Species", "Geom"
1, "Boxelder", "Acer negundo", "some geom"
2, "Juneberry", "Amelanchier arborea", "some geom"
These files are imported to PostgreSQL (via -f "PostgreSQL") incorrectly. The data are shifted over one column, and one column is dropped. Alternatively, in the quoted example above, even a space will make the file work correctly,
" ", "Name","Species", "Geom"
1, "Boxelder", "Acer negundo", "some geom"
2, "Juneberry", "Amelanchier arborea", "some geom"