yes, updating the metadata worked. <div><br></div><div>Is there anyway to do it through ogr2ogr ?</div><div><br></div><div>We are trying to replace shp2do with ogr2ogr as shp2do requires multiple steps (create do, import it and then create the index by hand)... and for what I've seen with PostGIS, ogr2ogr is a single line operation.... How can be done in Oracle ?(single line without modifying shapes) </div>
<div><br></div><div><br></div><div>thanks</div><div><br><div class="gmail_quote">On Mon, Oct 11, 2010 at 11:29 AM, Michael Shishcu <span dir="ltr"><<a href="mailto:micklesh@gmail.com">micklesh@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">I mean, you have points in your shape(s) too close to each other.<br>When you are importing them, oracle "interprets" them as the same point (ORA-13356) or overlapping ones (ORA-13349).<br>
ways to escape <br>- "simplify" your shapes - delete adjacent points (too close ones)<br>
- change your metadata for the layer (insert or update)<br><br>insert into USER_SDO_GEOM_METADATA<br>
values ('LAYER','COLUMN',<br>
mdsys.sdo_dim_array(<br>
mdsys.sdo_dim_element('X',minX,maxX, toleranceX),<br>
mdsys.sdo_dim_element('Y',minY,maxY, toleranceY)<br>
), <br>
SRID), so that toleranceX and toleranceY are small enough to serve your shapes<br><br>regards, michael<br>
</blockquote></div><br><br clear="all"><br>-- <br>Sebastian E. Ovide<br><br><br><br><br>
</div>