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

[Richard Reitmeyer]

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.

I'm following the steps at http://grasswiki.osgeo.org/wiki/S-57_data and have plausible (to me, anyway) output for ogrinfo US3NY01M.000, but I cannot import with v.in.ogr:


GRASS 7.0.0beta3 (NOAA_ENC_CA):~/Downloads/GIS/ENC > v.in.ogr dsn=NY/ENC_ROOT/US3NY01M/US3NY01M.000 out=NY

... many warnings ...

Importing 1 features (OGR layer <ADMARE>)...
DBMI-SQLite driver error:
Error in sqlite3_prepare():
table NY_2 has 27 columns but 26 values were supplied

DBMI-SQLite driver error:
Error in sqlite3_prepare():
table NY_2 has 27 columns but 26 values were supplied

ERROR: Cannot insert new row: insert into NY_2 values ( 1, 3989, 3, 2, 1,
       5, 550, 17794626, 50, '0226010F86420032', '', 2, '', '', '', '', '',
       '', '', NULL, 1499999, 'US3NY01A.TXT', '', '', '20111121',
       'US,US,reprt,L-1461/11' )

I'm on Linux Mint; I see this with both GRASS 7.0 beta 3 built from source, and with the GRASS 6.4.3 OS packages. I've also tried other NOAA ENCs from http://www.charts.noaa.gov/ENCs/ENCsIndv.shtml, but while the column counts vary, import is always off-by-one.

Any suggestions?


Richard