You are right...<br><br>aften done it, still getting the oringinal error due to errors in the geometries...<br><br>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...<br>
<br>any ideas ?<br><br>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...<br>
<br>thanks again<br><br><br><div class="gmail_quote">On Mon, Jul 26, 2010 at 1:37 PM, Michael Smith <span dir="ltr"><<a href="mailto:michael.smith@usace.army.mil">michael.smith@usace.army.mil</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
<font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;">Sebastian,<br>
<br>
Looks like you didn’t commit the change. There still is a duplicate entry in the user_sdo_geom_metadata. <br><div class="im">
<br>
Delete From User_Sdo_Geom_Metadata Where Table_Name Like 'FLU%';<br></div>
Commit;<br>
<br>
Mike<br>
<br>
<br>
-- <br>
Michael Smith<br>
US Army Corps of Engineers<br>
Remote Sensing/GIS Center<br>
Hanover, NH <br><div class="im">
<br>
<br>
<br>
<br>
On 7/26/10 11:08 AM, "Sebastian E. Ovide" <<a href="http://sebastian.ovide@gmail.com" target="_blank">sebastian.ovide@gmail.com</a>> wrote:<br>
<br>
</div></span></font><blockquote><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;"><div class="im">ok... I have deleted that extra line manually (should not it be handled by ogr2ogr in some way?)<br>
<br>
Delete From User_Sdo_Geom_Metadata Where Table_Name Like 'FLU%';<br>
<br>
now I'm getting another error:<br>
<br>
<br>
sebas@SeansPC:~/gdal$ time ogr2ogr -f OCI OCI:geoserver/geoserver@MFproduk_11g ../shapes/Fluvial_Extents/FluvialUD04Q200Outline.shp -lco srid=81989 -lco PRECISION=NO -progress -lco DIM=2<br>
0...10...20...30...40...50...60...70...80...90...100 - done.<br>
ERROR 1: ORA-13223: duplicate entry for FLUVIALUD04Q200OUTLINE.ORA_GEOMETRY in SDO_GEOM_METADATA<br></div>
ORA-06512: at "<a href="http://MDSYS.MD" target="_blank">MDSYS.MD</a> <<a href="http://MDSYS.MD" target="_blank">http://MDSYS.MD</a>> ", line 1723<div class="im"><br>
ORA-06512: at "MDSYS.MDERR", line 17<br>
ORA-06512: at "MDSYS.SDO_GEOM_TRIG_INS1", line 48<br>
ORA-04088: error during execution of trigger 'MDSYS.SDO_GEOM_TRIG_INS1'<br>
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)<br>
<br>
real 0m42.801s<br>
user 0m20.090s<br>
sys 0m0.360s<br>
<br>
<br>
On Mon, Jul 26, 2010 at 4:00 PM, Sebastian E. Ovide <<a href="http://sebastian.ovide@gmail.com" target="_blank">sebastian.ovide@gmail.com</a>> wrote:<br>
</div></span></font><blockquote><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;"><div class="im">thanks for that... I'm getting closer ....<br>
<br>
sebas@SeansPC:~/gdal$ time ogr2ogr -f OCI OCI:geoserver/geoserver@MFproduk_11g ../shapes/Fluvial_Extents/FluvialUD04Q200Outline.shp -lco srid=81989 -lco PRECISION=NO -progress -lco DIM=2<br>
<br>
0...10...20...30...40...50...60...70...80...90...100 - done.<br>
ERROR 1: ORA-13223: duplicate entry for FLUVIALUD04Q200OUTLINE.ORA_GEOMETRY in SDO_GEOM_METADATA<br></div>
ORA-06512: at "<a href="http://MDSYS.MD" target="_blank">MDSYS.MD</a> <<a href="http://MDSYS.MD" target="_blank">http://MDSYS.MD</a>> ", line 1723<div><div></div><div class="h5"><br>
ORA-06512: at "MDSYS.MDERR", line 17<br>
ORA-06512: at "MDSYS.SDO_GEOM_TRIG_INS1", line 48<br>
ORA-04088: error during execution of trigger 'MDSYS.SDO_GEOM_TRIG_INS1'<br>
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)<br>
<br>
real 0m42.414s<br>
user 0m19.900s<br>
sys 0m0.440s<br>
<br>
<br>
<br>
On Mon, Jul 26, 2010 at 1:11 PM, Rahkonen Jukka <<a href="http://Jukka.Rahkonen@mmmtike.fi" target="_blank">Jukka.Rahkonen@mmmtike.fi</a>> wrote:<br>
</div></div></span></font><div><div></div><div class="h5"><blockquote><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;">Hi,<br>
<br>
<a href="http://gdal.org/ogr/drv_oci.html" target="_blank">http://gdal.org/ogr/drv_oci.html</a> says:<br>
Layer Creation Options<br>
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.<br>
<br>
Have you tried that?<br>
<font color="#888888"><br>
-Jukka-<br>
</font><br>
Sebastian E. Ovide wrote:<br>
<br>
<br>
On Fri, Jul 23, 2010 at 7:38 PM, Jukka Rahkonen<br>
<<a>jukka.rahkonen@mmmtike.fi>wrote</a>:<br>
<br>
> Validate geometries<br>
<br>
validating geometries it came out: ORA-54668: a 2D SRID cannot be used with<br>
a 3D geometry<br>
<br>
therefore I've used the option -nlt POINT as suggested<br>
<a href="http://osgeo-org.1803224.n2.nabble.com/howto-flattening-of-3D-shapefiles-td3038433.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/howto-flattening-of-3D-shapefiles-td3038433.html</a><br>
<br>
but I still get the same ORA-54668 validation error...<br>
<br>
any ideas ?<br>
<br>
<br>
--<br>
Sebastian E. Ovide<br>
<br>
</span></font></blockquote><font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size: 11pt;"><br>
<br>
</span></font></div></div></blockquote></blockquote>
</div>
</blockquote></div><br><br clear="all"><br>-- <br>Sebastian E. Ovide<br><br><br><br><br>