On Mon, Dec 15, 2014 at 2:13 AM, Richard Reitmeyer <[email protected]> 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 _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
