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 <[email protected] > 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" <[email protected]> > 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: > > > se...@seanspc:~/gdal$ time ogr2ogr -f OCI > OCI:geoserver/geoser...@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 < > [email protected]> wrote: > > thanks for that... I'm getting closer .... > > se...@seanspc:~/gdal$ time ogr2ogr -f OCI > OCI:geoserver/geoser...@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 <[email protected]> > 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 > <[email protected]>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
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
