[gdal-dev] GDAL with OGDI

[Chaitanya kumar CH]

Paul,


I think that the problem is with the SQL command built by the PostgreSQL
driver.
In the INSERT command a numeric field with the value NaN should be mentioned
in quotes.

Please file a ticket at http://trac.osgeo.org/gdal/newticket
Mention the output for the command
ogrinfo -al -so
gltp:/vrf/home/naval/gemaps/mapdata/Approach/a1316120/dnc13/a1316120
soundp at hyd(*)_point'
to describe the field types (especially 'hdh') of the source features.

On Wed, Jun 30, 2010 at 10:36 AM, Malm Paul <paul.malm at saabgroup.com> wrote:

>  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
>
>
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>



-- 
Best regards,
Chaitanya kumar CH.
/tʃaɪθənjə/ /kʊmɑr/
+91-9494447584
17.2416N 80.1426E
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20100630/6974b79d/attachment.html