[gdal-dev] gml to Oracle

Gill, Olivia olivia.gill at sepa.org.uk
Mon Feb 3 05:15:46 PST 2020


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





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20200203/6ea250db/attachment.html>


More information about the gdal-dev mailing list