[gdal-dev] gml to Oracle

[jratike80]

Hi,

Some generic ogr2ogr options do not work with Oracle OCI driver. Read
https://gdal.org/drivers/vector/oci.html#vector-oci and have a try with

-lco DIM=3 -lco SRID=27700

Writing output of a small test data set into LOADER_FILE can help with
debugging and reporting if something still goes wrong.

-Jukka Rahkonen-


Gill, Olivia wrote
> Hi
> I'm having trouble importing a gml file to Oracle using ogr2ogr. The
> import works but ignores 3d points. I am using a .gfs template and the
> following script:
> 
> C:\OSGeo4W64\OSGeo4W.bat for /R %%f in (*.gml) do ogr2ogr -f OCI
> OCI:schema/password at owner:TABLE "%%~dpnf.gml" --config GML_GFS_TEMPLATE
> template.gfs -append -addfields -relaxedFieldNameMatch
> 
> An extract of the gml:
>       
> <net:geometry>
>         
> <gml:Point srsName="urn:ogc:def:crs:EPSG::7405"
> gml:id="osgb5000005143866540_geom">
>           
> <gml:pos>
> 457436.880 1200753.970 92.854
> </gml:pos>
>         
> </gml:Point>
>       
> </net:geometry>
> My template includes the following, to set the point geometry to
> <ElementPath>
> HydroNode
> </ElementPath>
>     
> <GeometryType>
> -2147483647
> </GeometryType>
>     
> <SRSName>
> EPSG:27700
> </SRSName>
> The resulting row in oracle MDSYS_SDO_GEOMETRY:
> MDSYS.SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(418363.37, 1157184.19,
> NULL), NULL, NULL)
> 
> So that the SRID is set to NULL, and the coordinates set the Z type to
> null also.
> Hoping someone can help.
> Olivia Gill
> 
> 
> 
> 
> 
> 
> _______________________________________________
> gdal-dev mailing list

> gdal-dev at .osgeo

> https://lists.osgeo.org/mailman/listinfo/gdal-dev





--
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html