topic insert records in Python Questions https://community.esri.com/t5/python-questions/insert-records/m-p/404089#M31827 <HTML><HEAD></HEAD><BODY><P>The following code returns records from polygon shape file. The shape is returned as object.<BR />How this object can be converted to array or list of coordinates so that it can be inserted into <BR />oracle spatial table in MDSYS.SDO_ORDINATE_ARRAY</P><P><BR />import arcpy<BR />fc = "C:\\roads.shp"<BR />fields = ["idnumber", "shape@"]</P><P>with arcpy.da.SearchCursor(fc, fields) as cursor:<BR /> for row in cursor:<BR /> print ("{0},{1}".format(row[0], row[1]))</P><P></P><P>pms,&lt;geoprocessing describe geometry object object at 0x028D1FC0&gt;<BR />xrz,&lt;geoprocessing describe geometry object object at 0x028D4100&gt;<BR />avx,&lt;geoprocessing describe geometry object object at 0x028D1FC0&gt;<BR />cbm,&lt;geoprocessing describe geometry object object at 0x028D4100&gt;</P></BODY></HTML> Tue, 20 Dec 2016 08:27:03 GMT jayasudha 2016-12-20T08:27:03Z insert records https://community.esri.com/t5/python-questions/insert-records/m-p/404089#M31827 <HTML><HEAD></HEAD><BODY><P>The following code returns records from polygon shape file. The shape is returned as object.<BR />How this object can be converted to array or list of coordinates so that it can be inserted into <BR />oracle spatial table in MDSYS.SDO_ORDINATE_ARRAY</P><P><BR />import arcpy<BR />fc = "C:\\roads.shp"<BR />fields = ["idnumber", "shape@"]</P><P>with arcpy.da.SearchCursor(fc, fields) as cursor:<BR /> for row in cursor:<BR /> print ("{0},{1}".format(row[0], row[1]))</P><P></P><P>pms,&lt;geoprocessing describe geometry object object at 0x028D1FC0&gt;<BR />xrz,&lt;geoprocessing describe geometry object object at 0x028D4100&gt;<BR />avx,&lt;geoprocessing describe geometry object object at 0x028D1FC0&gt;<BR />cbm,&lt;geoprocessing describe geometry object object at 0x028D4100&gt;</P></BODY></HTML> Tue, 20 Dec 2016 08:27:03 GMT https://community.esri.com/t5/python-questions/insert-records/m-p/404089#M31827 jayasudha 2016-12-20T08:27:03Z Re: insert records https://community.esri.com/t5/python-questions/insert-records/m-p/404090#M31828 <HTML><HEAD></HEAD><BODY><P>The <A href="http://desktop.arcgis.com/en/arcmap/latest/analyze/arcpy-classes/geometry.htm">ArcPy Geometry </A>class supports several data interchange formats (WKT, WKB, JSON/GeoJSON), and the <A href="https://docs.oracle.com/database/121/SPATL/GUID-7A79F1C4-FABF-432A-AF94-9E9CB23BBFBA.htm#SPATL180">SDO_UTIL Package </A>also works with some of those formats.&nbsp; Instead of trying to dump coordinates and build arrays, I would explore dumping WKT/WKB and importing it that way into Oracle.</P></BODY></HTML> Tue, 20 Dec 2016 13:20:48 GMT https://community.esri.com/t5/python-questions/insert-records/m-p/404090#M31828 JoshuaBixby 2016-12-20T13:20:48Z