I am trying to read a FC geometry which has one record in it Grab this geometry and use it in an INSERT cursor with specific attributes Think I am close but cant get the geometry of the FCs feature...the FC has only one.... geometries = arcpy . CopyFeatures_management ( 'Counties_3_dissolved' , arcpy . Geometry ( ) ) length = sum ( [ g . length for g in geometries ] ) print ( 'Total length: {}' . format ( length ) ) arcpy . env . overwriteOutput = True # Create a feature class result1 = arcpy . management . CreateFeatureclass ( arcpy . env . scratchGDB , "esri_square" , "POLYGON" , spatial_reference = 26917 ) feature_class = result1 [ 0 ] inputFeatureclass = "C:\Data\SelectCounties.gdb\Counties_4_final_append" # Write feature to new feature class with arcpy . da . InsertCursor ( inputFeatureclass , [ 'SHAPE@' , 'ADDRESS' , 'DISTANCE' , 'UNIQUEID' , 'COUNTYLIST' ] ) as cursor : cursor . insertRow ( [ geometries , searchAddress , searchDistance , searchid , txt_list ] ) # Delete cursor object del cursor

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

read Geometry pass to insert cursor

jaykapalczynski

I am trying to read a FC geometry which has one record in it

Grab this geometry and use it in an INSERT cursor with specific attributes

Think I am close but cant get the geometry of the FCs feature...the FC has only one....

geometries <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>CopyFeatures_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Counties_3_dissolved'</SPAN><SPAN class="punctuation token">,</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Geometry<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
length <SPAN class="operator token">=</SPAN> sum<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>g<SPAN class="punctuation token">.</SPAN>length <SPAN class="keyword token">for</SPAN> g <SPAN class="keyword token">in</SPAN> geometries<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Total length: {}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>length<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>


<SPAN class="comment token"># Create a feature class </SPAN>
result1 <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>management<SPAN class="punctuation token">.</SPAN>CreateFeatureclass<SPAN class="punctuation token">(</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>scratchGDB<SPAN class="punctuation token">,</SPAN> 
    <SPAN class="string token">"esri_square"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"POLYGON"</SPAN><SPAN class="punctuation token">,</SPAN> spatial_reference<SPAN class="operator token">=</SPAN><SPAN class="number token">26917</SPAN><SPAN class="punctuation token">)</SPAN>
feature_class <SPAN class="operator token">=</SPAN> result1<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>

inputFeatureclass <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:\Data\SelectCounties.gdb\Counties_4_final_append"</SPAN>
<SPAN class="comment token"># Write feature to new feature class</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>inputFeatureclass<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'SHAPE@'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ADDRESS'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'DISTANCE'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'UNIQUEID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'COUNTYLIST'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    cursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>geometries<SPAN class="punctuation token">,</SPAN> searchAddress<SPAN class="punctuation token">,</SPAN> searchDistance<SPAN class="punctuation token">,</SPAN> searchid<SPAN class="punctuation token">,</SPAN> txt_list<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Delete cursor object</SPAN>
<SPAN class="keyword token">del</SPAN> cursor<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

bixb0012

Taking what Dan said about a list being returned, what about changing the update line:

cursor.insertRow([geometries[0], searchAddress, searchDistance, searchid, txt_list])

All comments

jaykapalczynski

think I fixed it....delete the old one and created globalIDs again and it seems to be working....weird

jaykapalczynski

Yea I figured when I add a new row the GlobalID would be populated automatically

bixb0012

So you have a field of GlobalID type in<SPAN class=""> </SPAN>inputFeatureclass <SPAN class=""></SPAN>and nothing is getting populated when you insert a record using the cursor?

jaykapalczynski

I get this to work BUT i have a GlobalID in my feature class that does not get written too....how do I create the globalID

<SPAN class="comment token"># GET THE GEOMETRY FROM THE DISSOLVED FC and PASS THAT TO THE INSERT CURSOR BELOW ALONG WITH THE ATTRIBUTE VALUES</SPAN>
geometries <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>CopyFeatures_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Counties_3_dissolved'</SPAN><SPAN class="punctuation token">,</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Geometry<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

inputFeatureclass <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:\Work\CountySelection\Data\SelectCounties.gdb\Counties_4_final_append"</SPAN>

<SPAN class="comment token">## Write feature to new feature class</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>inputFeatureclass<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'SHAPE@'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ADDRESS'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'DISTANCE'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'UNIQUEID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'COUNTYLIST'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
cursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>geometries<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> searchAddress<SPAN class="punctuation token">,</SPAN> searchDistance<SPAN class="punctuation token">,</SPAN> searchid<SPAN class="punctuation token">,</SPAN> txt_list<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token"># Delete cursor object</SPAN>
<SPAN class="keyword token">del</SPAN> cursor<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

jskinner

Not sure if you're getting all the variables you're trying to insert to the new feature class from the Counties_3_dissolved feature class, but if you are you could use something like below:

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Counties_3_dissolved'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"SHAPE@"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"address"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"distance"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"id"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"txt_list"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
            geom <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
            searchAddress <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
            searchDistance <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
            searchid <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN>
            txt_list <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">del</SPAN> cursor

<SPAN class="comment token"># Write feature to new feature class</SPAN>
inputFeatureclass <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Data\SelectCounties.gdb\Counties_4_final_append"</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>inputFeatureclass<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'SHAPE@'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ADDRESS'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'DISTANCE'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'UNIQUEID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'COUNTYLIST'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    cursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>geom<SPAN class="punctuation token">,</SPAN> searchAddress<SPAN class="punctuation token">,</SPAN> searchDistance<SPAN class="punctuation token">,</SPAN> searchid<SPAN class="punctuation token">,</SPAN> txt_list<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">del</SPAN> cursor<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

bixb0012

Taking what Dan said about a list being returned, what about changing the update line:

cursor.insertRow([geometries[0], searchAddress, searchDistance, searchid, txt_list])

DanPatterson_Retired

it returns a list even if there is one. Did you try adding them in the insertRow one at a time?

jaykapalczynski

Using geometry objects with geoprocessing tools—ArcPy Get Started | Documentation

DanPatterson_Retired

which help topic did you get this line from?

geometries <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>CopyFeatures_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Counties_3_dissolved'</SPAN><SPAN class="punctuation token">,</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Geometry<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

is it specific to the arcgis api for python?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.