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

[Michael Smith]

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),MDS
> YS.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),MD
>> SYS.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-td3
>>> 038433.html
>>> 
>>> but I still get the same ORA-54668 validation error...
>>> 
>>> any ideas ?
>>> 
>>> 
>>> --
>>> Sebastian E. Ovide
>>> 
>> 
>> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20100726/a081a757/attachment.html