[gdal-dev] GDAL with OGDI

Malm Paul paul.malm at saabgroup.com
Wed Jun 30 01:06:26 EDT 2010


Hi,
I have:
- downloaded GDAL v 1.7.2
- installed postgresql-devel (8.3.8)

- downloaded and compiled/installed proj-4.7.0

- downloaded ogdi-3.1.5 and later on ogdi-3.2.0-beta
- configured ogdi to use proj-4.7.0
- compiled and installed ogdi

- configured GDAL: --with-ogdi=/usr/local --with-pg=/usr/bin/pg_config
- compiled/installed GDAL

- ogr2ogr --formats, repordt bouth postgis and ogdi driver

running ogr2ogr:
ogr2ogr -f PostgreSQL PG:"dbname=a1316120 host=127.0.0.1 port=5432 user=postgres password=postgrespwd"
gltp:/vrf/home/naval/gemaps/mapdata/Approach/a1316120/dnc13/a1316120 -t_srs "EPSG:4326" -lco OVERWRITE=YES -segmentize 0.5 -nln soundp soundp at hyd(*)_point'

but when I try to import a DNC (VPF) chart I get the following error message:
ERROR 1: INSERT command for new feature failed.
ERROR:  column "nan" does not exist
LINE 1: ...5263)'::TEXT) , 1, 'BE020', 1, 26, 1,             nan,      ...
                                                            ^
Command: INSERT INTO "soundp" ("wkb_geometry" , "id", "f_code", "acc",
"dat", "exs", "hdh", "hdp", "snd", "svc", "val", "tile_id", "end_id")
VALUES (GeomFromEWKT('SRID=4326;POINT (-119.614990234375114
34.420528411865263)'::TEXT) , 1, 'BE020', 1, 26, 1,             nan,
3.600000, 10, 5, 0, 1, 1)
ERROR 1: Terminating translation prematurely
after failed translation of layer soundp at hyd(*)_point (use
-skipfailures to skip errors)

It is the same with ogdi-3.1.5 and ogdi-3.2.0-beta.
why is hdh = nan (the corresponding hdp is correct), it works when importing with ogr2ogr from FWTOOLS.

What am I doing wrong, it worked before when I used an prebuild FWTOOLS?

I need GDAL 1.7.2 because the version in FWTOOLS has another bug (S-57 ignores names starting with ÅÄÖ).
Is there some one that could tell me what i'm doing wrong, please?

I'm using postgresql 8.3.8 on linux redhat 5.x.
Kind regards,
Paul


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20100630/6d07ac28/attachment-0001.html


More information about the gdal-dev mailing list