[GRASS-user] Error importing NOAA enc file with v.in.ogr (?)

[Markus Neteler]

On Mon, Dec 15, 2014 at 2:13 AM, Richard Reitmeyer
<rareitmeyer at gmail.com> wrote:
> Hello, all.
>
> I'm sure this is user error, but I'm not having much success importing NOAA ENC charts into GRASS. I'm missing a column, or something, and would welcome a suggestion.

For a test I have downloaded
http://www.charts.noaa.gov/ENCs/ENCs.shtml
--> http://www.charts.noaa.gov/ENCs/IL_ENCs.zip   (random choice)

and also run into troubles:

GRASS 7.0.0svn (latlong):~/ENC_ROOT > v.in.ogr
ENC_ROOT/US5IN11M/US5IN11M.000 out=s57
[...]
Importing 15 features (OGR layer <BCNLAT>)...
DBMI-SQLite driver error:
Error in sqlite3_prepare():
table s57_2 has 44 columns but 43 values were supplied

DBMI-SQLite driver error:
Error in sqlite3_prepare():
table s57_2 has 44 columns but 43 values were supplied

ERROR: Cannot insert new row: insert into s57_2 values ( 1, 1, 1, 2, 7, 2,
       550, 395184755, 3480, '0226178E0A730D98', '(1:2)', 1, 1, '4', '',
       NULL, NULL, NULL, '', '', NULL, NULL, NULL, '', '', 'Buffington
       Harbor Inner Breakwater West Light 1', '', '', '8', NULL, NULL,
       NULL, '', '', '', '', NULL, 89999, '', '', '', '19960820',
       'US,US,reprt,9thCGD,LNM 23/96' )

I suspect that the comma in the last string entry is not parsed
properly. I came across a similar issue recently with v.in.ascii,
perhaps we get it solved. I'll discuss with Markus Metz who improved
the tokenizer recently for other issues.
More hopefully soon.

Markus