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

[Sebastian E. Ovide]

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", 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", 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
>
>
>
>
>


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