[Gdal-dev] Re: trouble loading s57 into postgis

[Frank Warmerdam]

Tore Halset wrote:
> Hello.
> 
> I have upgraded my database and gis tools to postgresql-8.0.0b4, 
> postgis-0.9.0 and gdal-1.2.4.
> 
> I get a sql error when I try to import a NOAA ENC into postgis using 
> ogr2ogr. Here is the output from postgresql log:
> 
> LOG:  statement: INSERT INTO "bcnlat" (wkb_geometry , "rcid", "prim", 
> "grup", "objl", "rver", "agen", "fidn", "fids", "lnam", "lnam_refs", 
> "ffpt_rind", "bcnshp", "catlam", "colour", "objnam", "status", "scamin", 
> "sordat", "sorind") VALUES (GeometryFromText('POINT (-97.49502700 
> 27.83072200)'::TEXT,1) , 2, 1, 2, 7, 1, 550, 262591846, 1161, 
> '02260FA6D5660489', '(2:02260FA6D6040', '{', 4, 2, '', 'Viola Channel 
> Light 2', '1', 120000, '19980407', 'US,US,reprt,8thCGD,LNM 14/98')
> ERROR:  malformed array literal: "{"
> 
> looks like ogr2ogr tries to put '{' into a integer[].

Tore,

Hmm, funky.  Could you submit this into the GDAL bugzilla and I will try to
deal with it.  You may need to provide the dataset in question if it is
a peculiarity of the dataset in question.  I can keep the data private and
delete it once the bug fixing is done if required as is often the case for
copyrighted S-57 datasets.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent