[gdal-dev] Re: ogr2ogr OCI: problem loading shapes

[Sebastian E. Ovide]

You are right...

aften done it, still getting the oringinal error due to errors in the
geometries...

now, If I import the same data using shp2sdo, I do NOT get any error
creating the index... the shape get imported and the index is created...
even if there are errors in the geometries...

any ideas ?

I know that I could use shp2sdo as it is working... but it requires extra
work (something like 5 command lines)... and as I'm using gdal for importing
rasters, I'd like to use it also for shapes...

thanks again


On Mon, Jul 26, 2010 at 1:37 PM, Michael Smith <michael.smith at usace.army.mil
> wrote:

>  Sebastian,
>
> Looks like you didn’t commit the change. There still is a duplicate entry
> in the user_sdo_geom_metadata.
>
> Delete From User_Sdo_Geom_Metadata Where Table_Name Like 'FLU%';
> Commit;
>
> Mike
>
>
> --
> Michael Smith
> US Army Corps of Engineers
> Remote Sensing/GIS Center
> Hanover, NH
>
>
>
>
> On 7/26/10 11:08 AM, "Sebastian E. Ovide" <sebastian.ovide at gmail.com>
> wrote:
>
> ok... I have deleted that extra line manually (should not it be handled by
> ogr2ogr in some way?)
>
> Delete From User_Sdo_Geom_Metadata Where Table_Name Like 'FLU%';
>
> now I'm getting another error:
>
>
> sebas at SeansPC:~/gdal$ time ogr2ogr -f OCI
> OCI:geoserver/geoserver at MFproduk_11g../shapes/Fluvial_Extents/FluvialUD04Q200Outline.shp -lco srid=81989 -lco
> PRECISION=NO -progress -lco DIM=2
> 0...10...20...30...40...50...60...70...80...90...100 - done.
> ERROR 1: ORA-13223: duplicate entry for FLUVIALUD04Q200OUTLINE.ORA_GEOMETRY
> in SDO_GEOM_METADATA
> ORA-06512: at "MDSYS.MD <http://MDSYS.MD> ", line 1723
>
> ORA-06512: at "MDSYS.MDERR", line 17
> ORA-06512: at "MDSYS.SDO_GEOM_TRIG_INS1", line 48
> ORA-04088: error during execution of trigger 'MDSYS.SDO_GEOM_TRIG_INS1'
>  in INSERT INTO USER_SDO_GEOM_METADATA VALUES ('FLUVIALUD04Q200OUTLINE',
> 'ORA_GEOMETRY',
> MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',138874.997,654690.003,0.001),MDSYS.SDO_DIM_ELEMENT('Y',15619.997,814145.0030999999,0.001)),
> 81989)
>
> real    0m42.801s
> user    0m20.090s
> sys     0m0.360s
>
>
> On Mon, Jul 26, 2010 at 4:00 PM, Sebastian E. Ovide <
> sebastian.ovide at gmail.com> wrote:
>
> thanks for that... I'm getting closer ....
>
> sebas at SeansPC:~/gdal$ time ogr2ogr -f OCI
> OCI:geoserver/geoserver at MFproduk_11g../shapes/Fluvial_Extents/FluvialUD04Q200Outline.shp -lco srid=81989 -lco
> PRECISION=NO -progress -lco DIM=2
>
> 0...10...20...30...40...50...60...70...80...90...100 - done.
> ERROR 1: ORA-13223: duplicate entry for FLUVIALUD04Q200OUTLINE.ORA_GEOMETRY
> in SDO_GEOM_METADATA
> ORA-06512: at "MDSYS.MD <http://MDSYS.MD> ", line 1723
>
> ORA-06512: at "MDSYS.MDERR", line 17
> ORA-06512: at "MDSYS.SDO_GEOM_TRIG_INS1", line 48
> ORA-04088: error during execution of trigger 'MDSYS.SDO_GEOM_TRIG_INS1'
>  in INSERT INTO USER_SDO_GEOM_METADATA VALUES ('FLUVIALUD04Q200OUTLINE',
> 'ORA_GEOMETRY',
> MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',138874.997,654690.003,0.001),MDSYS.SDO_DIM_ELEMENT('Y',15619.997,814145.0030999999,0.001)),
> 81989)
>
> real    0m42.414s
> user    0m19.900s
> sys     0m0.440s
>
>
>
> On Mon, Jul 26, 2010 at 1:11 PM, Rahkonen Jukka <Jukka.Rahkonen at mmmtike.fi>
> wrote:
>
> Hi,
>
> http://gdal.org/ogr/drv_oci.html says:
> Layer Creation Options
> DIM: This may be set to 2 or 3 to force the dimension of the created layer.
> If not set 3 is used by default.
>
> Have you tried that?
>
> -Jukka-
>
> Sebastian E. Ovide wrote:
>
>
> On Fri, Jul 23, 2010 at 7:38 PM, Jukka Rahkonen
> <jukka.rahkonen at mmmtike.fi>wrote:
>
> > Validate geometries
>
> validating geometries it came out: ORA-54668: a 2D SRID cannot be used with
> a 3D geometry
>
> therefore I've used the option -nlt POINT as suggested
>
> http://osgeo-org.1803224.n2.nabble.com/howto-flattening-of-3D-shapefiles-td3038433.html
>
> but I still get the same ORA-54668 validation error...
>
> any ideas ?
>
>
> --
> Sebastian E. Ovide
>
>
>
>


-- 
Sebastian E. Ovide
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20100726/0ebf991d/attachment.html