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@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 > [email protected] > https://lists.osgeo.org/mailman/listinfo/gdal-dev -- Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html _______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
