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; } } }

Arcpy for loop gives n-1 results

Nicole_Ueberschär

I have a problem with my for loop.

In an array profile_nrs all the numbers are stored I want to create points for in an existing feature class. When I print these values I get the expected nr of values (and also the correct values). Now I am creating points with an insertCursor and print in the end which point nr was added. I get all the (in this case) 18 points printed. But when I look into my file I receive only 17 points. Any advise is highly appreciated. I don't see any potential cause for this "misbehavior". My feeling tells me that it must not be looping through the numbers itself but through the index but then I wouldn't get nr 18 printed, would I?

Here the main part of the module:

<SPAN class="keyword token">for</SPAN> profile <SPAN class="keyword token">in</SPAN> profile_nrs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; newPoint<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>points<SPAN class="punctuation token">,</SPAN> fillnames<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; newPoint<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>fillValues<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"point "</SPAN><SPAN class="operator token">+</SPAN>str<SPAN class="punctuation token">(</SPAN>profile<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN><SPAN class="string token">" added to All_points"</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Inside the for loop I have a couple of other loops to get the fillnames and fillvalues but I don't see anywhere how this could influence the output. Especially if it says it added nr 18 but obviously it didn't...

Thanks in advance for helping me with this.

Trouver plus de publications taguées avec

Accepted answers

RichardFairhurst

Your code is using far too many cursors. It is faster to blast through a complete table than it is to use expressions to limit the result most of the time, especially since you have to blast through the whole table to build your expression for the second cursor on that table. Don't bother trying to find the first records, just use it when going through the whole table and it meet your criteria and keep track of the fact you have already used it or break out of the loop. Anyway, I think the code below does what you are trying to do and is far less confusing.

I could make the code more efficient if I knew exactly what each input table contained. I did not assume that the table_name tables contained data for only one station. If that is actually the case then the second dictionary, the last for loop and the last two if clauses can be replaced with pfieldvalues = next(pCursor).

None of this may solve your original problem, since there are too many points of failure that could have happened in your prior script or in your input tables. Are you positive that all fields of the Test1 table correctly point to all of the tables created by your previous script? Did you verify your previous script created all of the expected tables? Are you sure there are no misspellings of any of the input table names or field values? If the script I wrote has the same failure as every other script you have tried I would say the cause of the failure is in the inputs to this script.

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> os

<SPAN class="comment token">#Workspace settings</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace<SPAN class="operator token">=</SPAN>r<SPAN class="string token">"C:\data\2017\LakeKivu\Kivu_python.gdb"</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">#input file</SPAN>
table <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\data\2017\LakeKivu\Kivu_python.gdb\Test1"</SPAN>
points<SPAN class="operator token">=</SPAN>r<SPAN class="string token">"C:\data\2017\LakeKivu\Kivu_python.gdb\Campaigns\All_points"</SPAN>

dsc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">)</SPAN>
fields <SPAN class="operator token">=</SPAN> dsc<SPAN class="punctuation token">.</SPAN>fields
<SPAN class="comment token"># List all field names except the OID field</SPAN>
fieldnames <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Station"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> fields <SPAN class="keyword token">if</SPAN> field<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">!=</SPAN> dsc<SPAN class="punctuation token">.</SPAN>OIDFieldName<SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># create a dictionary of stations</SPAN>
stationDict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN> fieldnames<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; station <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> station <SPAN class="keyword token">in</SPAN> stationDict<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stationDict<SPAN class="punctuation token">[</SPAN>station<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"_"</SPAN><SPAN class="operator token">+</SPAN>str<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

pfieldnames<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Cruise'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Station'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Type'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Date'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Longitude'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Latitude'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'UPI'</SPAN><SPAN class="punctuation token">]</SPAN>

pfields<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>points<SPAN class="punctuation token">)</SPAN>
fillnames<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN>pfield<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> pfield <SPAN class="keyword token">in</SPAN> pfields <SPAN class="keyword token">if</SPAN> pfield<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">!=</SPAN> dsc<SPAN class="punctuation token">.</SPAN>OIDFieldName<SPAN class="punctuation token">]</SPAN>&nbsp; <SPAN class="comment token">#names for point feature class</SPAN>

newPoint<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>points<SPAN class="punctuation token">,</SPAN> fillnames<SPAN class="punctuation token">)</SPAN>

stationpointDict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">for</SPAN> station <SPAN class="keyword token">in</SPAN> sorted<SPAN class="punctuation token">(</SPAN>stationDict<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; table_name <SPAN class="operator token">=</SPAN> stationDict<SPAN class="punctuation token">[</SPAN>station<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>table_name<SPAN class="punctuation token">,</SPAN> pfieldnames<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> pCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> pRow <SPAN class="keyword token">in</SPAN> pCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> station <SPAN class="operator token">==</SPAN> pRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> station <SPAN class="keyword token">in</SPAN> stationpointDict<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stationpointDict<SPAN class="punctuation token">[</SPAN>station<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> pRow
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pfieldsvalues <SPAN class="operator token">=</SPAN> pRow
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ShapeVal <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fillValues <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>ShapeVal<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> list<SPAN class="punctuation token">(</SPAN>pfieldsvalues<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>fillValues<SPAN class="punctuation token">)</SPAN> ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; newPoint<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>fillValues<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"point "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>station<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" added to All_points"</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>‍</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><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

Nicole_Ueberschär

Thank you Joshua, understanding what the script is doing was the intention of my last comment.

JoshuaBixby

Line #4 will generate a StopIteration error if the cursor has been exhausted, i.e., iterated over and not reset, or the cursor has no records in the first place. Given the code, I am thinking your cursor isn't returning any records.

I know Python is new to you, but you have to learn to walk before you can run. At some point, you need to understand why people are making specific suggestions and how the code they offer works. In terms of Python, there is nothing special about ArcPy. When some ArcPy code generates an error, such as StopIteration, that error likely isn't unique to ArcPy. ArcPy cursors are iterables, so the question to ask yourself is why does a Python iterable generate a StopIteration error? The answer to that question will lead you to the answer to why your search cursor is generating that error.

Copying someone's code and using it without understanding why it works is bound to cause problems, if not immediately than definitely down the road. I understand that dissecting other's code to learn why it works takes time, but it is one of those pay now or pay later situations. I have always preferred to pay now because I never seem to have more time available later.

The GeoNet community wants to help, as evidenced by the 18 replies and growing, but I know personally that I am burned out on this thread. I feel there are too many methodology and technical issues colliding with each other, and I don't know where to start commenting any more. My suggestion for now is to take a step back and break your code into smaller functional groups. Get each group or block of code working, and understand why it works, and then start stacking the blocks of code on top of each other.

Best of luck, and keep at it. Python is a wonderful language and ArcPy can be a very powerful tool.

RichardFairhurst

Nicole:

Line 15 adds the station field as the first field in the list, because this is field holding the unique dictionary key value used match records between each table per your description of what you wanted to do. The field list includes the station twice, once for the dictionary key and once for the value of the field for a given row, which is important later when the station field has to be in the position it exists relative to other fields to hold all the values of a row object that is passed to the insert cursor.

Line 19 reads the records of the search table that contains the table names.

Lines 18-23 - you are correct that the dictionary is adding each station only the first time it is encountered to the dictionary and the key value is the concatenation of the two fields that make up your table names, per your description of what you had set up.

For the modification of the code, I did not test using the next method. Go back to using the for loop and break out of it once you have created a feature for the table. I.e.:

for station in sorted(stationDict):
&nbsp;&nbsp;&nbsp; table_name = stationDict[station]
&nbsp;&nbsp;&nbsp; with arcpy.da.SearchCursor(table_name, pfieldnames) as pCursor:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for pRow in pCursor:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stationpointDict[station] = pRow
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pfieldsvalues = pRow
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ShapeVal = [pfieldsvalues[4], pfieldsvalues[5]]
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fillValues = [ShapeVal] + list(pfieldsvalues)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print(fillValues) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; newPoint.insertRow(fillValues)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print("point " + str(station) + " added to All_points")
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; break
&nbsp;&nbsp; del pCursor<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>

Nicole_Ueberschär

I'm trying now to combine my scripts but I fail to understand what you are doing Richard

Let me try to explain what I understand (or what I think to understand) and where I am struggling...

line 15:

fieldnames = ["Station"] + [field.name for field in fields if field.name != dsc.OIDFieldName]

plus line 19:

with arcpy.da.SearchCursor(table, fieldnames) as cursor:

Did you choose the additional field name "Station" by purpose because you saw in my pfieldnames that there is already a field called Station? Because, if I would choose a random name it would not find this column in my table when applying the SearchCursor, isn't it?

lines 18-23:

stationDict = {} with arcpy.da.SearchCursor(table, fieldnames) as cursor:     for row in cursor:         station = row[0]         if not station in stationDict:             stationDict[station] = str(row[1])+"_"+str(row[2])

This daSearchCursor goes through my input table including all fieldnames (including your defined "Station", excluding OID). The variable station gets the value of the attribute "Station" (because this is mentioned as the first field name). If the number does not exist yet the dictionary stationDict receives a new entry for the entry with the station x concatenating the values of the attributes 2 and 3 of the row of the current cursor. So, this dictionary contains only the concatenated name (the table_name) per row x. Right?

When I try now to follow your description which lines to replace I have instead of lines 32-45:

<SPAN class="keyword token">for</SPAN> station <SPAN class="keyword token">in</SPAN> sorted<SPAN class="punctuation token">(</SPAN>stationDict<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; table_name <SPAN class="operator token">=</SPAN> stationDict<SPAN class="punctuation token">[</SPAN>station<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>table_name<SPAN class="punctuation token">,</SPAN> pfieldnames<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> pCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pfieldsvalues <SPAN class="operator token">=</SPAN> next<SPAN class="punctuation token">(</SPAN>pCursor<SPAN class="punctuation token">)</SPAN>‍‍‍‍
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ShapeVal <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fillValues <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>ShapeVal<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> list<SPAN class="punctuation token">(</SPAN>pfieldsvalues<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>fillValues<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; newPoint<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>fillValues<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"point "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>station<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" added to All_points"</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

This goes through my sorted stationDict, retrieves the table_name, and "opens" the table_name with my pfieldnames. Then it should write all values from the first row into pfieldsvalues, adds the Shape and the pfieldsvalues to the fillValues and inserts a new row into my point feature. Unfortunately it gives me the error "StopIteration" at my line 4. #

When I want to combine this part now with what I attempt to achieve with https://community.esri.com/thread/190087-nested-searchinsertcursors I get totally stranded. I will try to continue at this other posting to describe better what I want to do in consideration what I learned here.

RebeccaStrauch__GISP

I unmarked this thread as being answered since it appears it is still very active (sorry Dan Patterson )

n.ueberschaeresri-rw-esridist make sure to mark the correct answer once resolved, and to mark all those comments that were helpful.

Nicole_Ueberschär

Ok, it works! Great job! Thanks a lot!

Just trying to get the differences now...

Why did you put the "Station" additionally as a field into fieldnames?

I don't have to delete the inputCursor in the end? Does this apply only for searchCursors (and UpdateCursors?) when NOT used with the "with"?

As I said in my last comment the table_name tables in fact only contain one station each. Those were already extracted in a previous script from a bigger file (as I tried to explain here: Nested Search/InsertCursors). The optimum would be to combine these two steps, so this will be my next attempt... I tried to replace as you said "the last for loop and the last two if clauses can be replaced with pfieldvalues = next(pCursor)" but I am still confused about what is happening where so I just left it for now. As long as it's working 😉

Thanks to all of you!

Nicole_Ueberschär

Thank you very much Richard for taking so much effort to work through (and obviously improve) my script!

I have to admit that I didn't take the time yet to read carefully through your blog posting Dan referred to before.

Actually, each table_name contains only the data for one station while the point feature class is supposed to contain all points taken from the input table(s). Additionally each table (each table_name as well as the corresponding point feature class) should receive an UID (the same as the table_name, incorrectly named UPI before) to be able to relate them later again.

At the moment the script doesn't write any points but I think I have to look through it again carefully... Thanks so far again! Will give you an update soon!

RichardFairhurst

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> os

<SPAN class="comment token">#Workspace settings</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace<SPAN class="operator token">=</SPAN>r<SPAN class="string token">"C:\data\2017\LakeKivu\Kivu_python.gdb"</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">#input file</SPAN>
table <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\data\2017\LakeKivu\Kivu_python.gdb\Test1"</SPAN>
points<SPAN class="operator token">=</SPAN>r<SPAN class="string token">"C:\data\2017\LakeKivu\Kivu_python.gdb\Campaigns\All_points"</SPAN>

dsc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">)</SPAN>
fields <SPAN class="operator token">=</SPAN> dsc<SPAN class="punctuation token">.</SPAN>fields
<SPAN class="comment token"># List all field names except the OID field</SPAN>
fieldnames <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Station"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> fields <SPAN class="keyword token">if</SPAN> field<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">!=</SPAN> dsc<SPAN class="punctuation token">.</SPAN>OIDFieldName<SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># create a dictionary of stations</SPAN>
stationDict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN> fieldnames<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; station <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> station <SPAN class="keyword token">in</SPAN> stationDict<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stationDict<SPAN class="punctuation token">[</SPAN>station<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"_"</SPAN><SPAN class="operator token">+</SPAN>str<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

pfieldnames<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Cruise'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Station'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Type'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Date'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Longitude'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Latitude'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'UPI'</SPAN><SPAN class="punctuation token">]</SPAN>

pfields<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>points<SPAN class="punctuation token">)</SPAN>
fillnames<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN>pfield<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> pfield <SPAN class="keyword token">in</SPAN> pfields <SPAN class="keyword token">if</SPAN> pfield<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">!=</SPAN> dsc<SPAN class="punctuation token">.</SPAN>OIDFieldName<SPAN class="punctuation token">]</SPAN>&nbsp; <SPAN class="comment token">#names for point feature class</SPAN>

newPoint<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>points<SPAN class="punctuation token">,</SPAN> fillnames<SPAN class="punctuation token">)</SPAN>

stationpointDict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">for</SPAN> station <SPAN class="keyword token">in</SPAN> sorted<SPAN class="punctuation token">(</SPAN>stationDict<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; table_name <SPAN class="operator token">=</SPAN> stationDict<SPAN class="punctuation token">[</SPAN>station<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>table_name<SPAN class="punctuation token">,</SPAN> pfieldnames<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> pCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> pRow <SPAN class="keyword token">in</SPAN> pCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> station <SPAN class="operator token">==</SPAN> pRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> station <SPAN class="keyword token">in</SPAN> stationpointDict<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stationpointDict<SPAN class="punctuation token">[</SPAN>station<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> pRow
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pfieldsvalues <SPAN class="operator token">=</SPAN> pRow
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ShapeVal <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fillValues <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>ShapeVal<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> list<SPAN class="punctuation token">(</SPAN>pfieldsvalues<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>fillValues<SPAN class="punctuation token">)</SPAN> ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; newPoint<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>fillValues<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"point "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>station<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" added to All_points"</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>‍</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><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RichardFairhurst

As Dan, Joshua and others have pointed out, the creation of an InsertCursor should never happen within a loop. You only want to declare the InsertCursor once for any given table/fc (typically before any loops that involve it). Only the insertion of rows should be done within a loop:

points<SPAN class="operator token">=</SPAN>r<SPAN class="string token">"C:\data\2017\LakeKivu\Kivu_python.gdb\Campaigns\All_points"</SPAN>
pfields<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>points<SPAN class="punctuation token">)</SPAN>
fillnames<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN>pfield<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> pfield <SPAN class="keyword token">in</SPAN> pfields <SPAN class="keyword token">if</SPAN> pfield<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">!=</SPAN> dsc<SPAN class="punctuation token">.</SPAN>OIDFieldName<SPAN class="punctuation token">]</SPAN>&nbsp; <SPAN class="comment token">#names for point feature class</SPAN>
newPoint<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>points<SPAN class="punctuation token">,</SPAN> fillnames<SPAN class="punctuation token">)</SPAN>‍
<SPAN class="keyword token">for</SPAN> profile <SPAN class="keyword token">in</SPAN> profile_nrs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># get a list of fillValues using some sort of method</SPAN>
&nbsp;&nbsp;&nbsp; newPoint<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>fillValues<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Nicole_Ueberschär

Didn't want to "overload" the code but here is the whole snipplet:

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> os
<SPAN class="comment token">#Workspace settings</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace<SPAN class="operator token">=</SPAN>r<SPAN class="string token">"C:\data\2017\LakeKivu\Kivu_python.gdb"</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="keyword token">def</SPAN> <SPAN class="token function">unique_values</SPAN><SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> sorted<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">{</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token">#input file</SPAN>
table <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\data\2017\LakeKivu\Kivu_python.gdb\Test1"</SPAN>

<SPAN class="comment token">#Output files</SPAN>
DirOutProfiles<SPAN class="operator token">=</SPAN>r<SPAN class="string token">"C:\data\2017\LakeKivu\Kivu_python.gdb\Profiles"</SPAN>
DirOutCampaign<SPAN class="operator token">=</SPAN>r<SPAN class="string token">"C:\data\2017\LakeKivu\Kivu_python.gdb\Campaigns"</SPAN>
DirOutTables<SPAN class="operator token">=</SPAN>r<SPAN class="string token">"C:\data\2017\LakeKivu\Kivu_python.gdb"</SPAN>
points<SPAN class="operator token">=</SPAN>r<SPAN class="string token">"C:\data\2017\LakeKivu\Kivu_python.gdb\Campaigns\All_points"</SPAN>

profile_nrs<SPAN class="operator token">=</SPAN>unique_values<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Station"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>profile_nrs<SPAN class="punctuation token">)</SPAN>

dsc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">)</SPAN>
fields <SPAN class="operator token">=</SPAN> dsc<SPAN class="punctuation token">.</SPAN>fields
<SPAN class="comment token"># List all field names except the OID field</SPAN>
fieldnames <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> fields <SPAN class="keyword token">if</SPAN> field<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">!=</SPAN> dsc<SPAN class="punctuation token">.</SPAN>OIDFieldName<SPAN class="punctuation token">]</SPAN>

pfields<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>points<SPAN class="punctuation token">)</SPAN>
fillnames<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN>pfield<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> pfield <SPAN class="keyword token">in</SPAN> pfields <SPAN class="keyword token">if</SPAN> pfield<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">!=</SPAN> dsc<SPAN class="punctuation token">.</SPAN>OIDFieldName<SPAN class="punctuation token">]</SPAN>&nbsp; <SPAN class="comment token">#names for point feature class</SPAN>

<SPAN class="comment token"># get tables</SPAN>
<SPAN class="keyword token">for</SPAN> profile <SPAN class="keyword token">in</SPAN> profile_nrs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; expression<SPAN class="operator token">=</SPAN><SPAN class="string token">"Station="</SPAN><SPAN class="operator token">+</SPAN>str<SPAN class="punctuation token">(</SPAN>profile<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>expression<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN>fieldnames<SPAN class="punctuation token">,</SPAN>expression<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> sCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> sRow <SPAN class="keyword token">in</SPAN> sCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; table_name<SPAN class="operator token">=</SPAN>str<SPAN class="punctuation token">(</SPAN>sRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"_"</SPAN><SPAN class="operator token">+</SPAN>str<SPAN class="punctuation token">(</SPAN>sRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> sRow


<SPAN class="comment token"># Create point feature</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#Identify first OBJECTID used in new table</SPAN>
&nbsp;&nbsp;&nbsp; oid_nrs<SPAN class="operator token">=</SPAN>unique_values<SPAN class="punctuation token">(</SPAN>table_name<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; FirstObject<SPAN class="operator token">=</SPAN>oid_nrs<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>FirstObject<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#Define expression to limit the extracted rows to the first row</SPAN>
&nbsp;&nbsp;&nbsp; pexpression<SPAN class="operator token">=</SPAN><SPAN class="string token">"OBJECTID="</SPAN><SPAN class="operator token">+</SPAN>str<SPAN class="punctuation token">(</SPAN>oid_nrs<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#Define field names used for point table</SPAN>
&nbsp;&nbsp;&nbsp; pfieldnames<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Cruise'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Station'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Type'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Date'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Longitude'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Latitude'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'UPI'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>pfieldnames<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#get values from table table_name</SPAN>
&nbsp;&nbsp;&nbsp; pfieldsvalues<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> pname <SPAN class="keyword token">in</SPAN> pfieldnames<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>table_name<SPAN class="punctuation token">,</SPAN> pname<SPAN class="punctuation token">,</SPAN> pexpression<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> pCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> pRow <SPAN class="keyword token">in</SPAN> pCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fillvalue<SPAN class="operator token">=</SPAN>pRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pfieldsvalues<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>fillvalue<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; ShapeVal<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN>pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>fillnames<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; fillValues<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN>ShapeVal<SPAN class="punctuation token">,</SPAN> pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>fillValues<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; newPoint<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>points<SPAN class="punctuation token">,</SPAN> fillnames<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; newPoint<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>fillValues<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; station_nr<SPAN class="operator token">=</SPAN>pfieldsvalues<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"point "</SPAN><SPAN class="operator token">+</SPAN>str<SPAN class="punctuation token">(</SPAN>station_nr<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN><SPAN class="string token">" added to All_points"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> pRow
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> pCursor
<SPAN class="keyword token">del</SPAN> sCursor‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>‍</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><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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I'm pretty sure that there is a better/simpler way of creating my points but I didn't find it yet.

Maybe I miss somewhere a point in these Cursor methodologies. I couldn't figure out how to take only a certain number of attributes from the input table for my point feature PLUS adding somehow the shape values that's why it might look a bit irritating...

In short what I do here:

- profile_nrs takes all unique numbers in the attribute station (1-18) from input table Table1 (rows 21)

- I created in a different script tables based on these unique numbers. This way I got 18 tables with the according names (concatenating attributes 1 and 2, resulting into something like bla_1, bla_2,...) (rows 33-39)

- take only the first row of each table for creating the point (->pexpression, row 48+58)

- write in pfieldvalues the values from the input table (in this case one of the new 18 tables).(rows 54-61)

- fillnames includes the SHAPE attribute

- fillvalues takes the created SHAPE attribute value (ShapeVal) plus the values written in pfieldvalues. (row 64)

- then insert a row into points with fillvalues. (row 66/67).

Let's hope this makes it somehow clearer...

Nicole_Ueberschär

Here we go... (I hope it works with just copy-paste...)

Nicole_Ueberschär

Yes, correct. Didn't want to mix up the issues. I separated now both parts - creating first the tables and then the points but now I am stuck here...

DanPatterson_Retired

I think this thread is related to this thread, which isn't closed

JoshuaBixby

It helps to err on the side of giving more code than less. You have provided what you think is the functional and broken part of the code, but it could be the issue is upstream on how some of the variables are created/defined.

Also, just a comment on using an insert cursor, create it outside of the loop where you insert records.

DanPatterson_Retired

just in case looping through 18 objects would be the sequence 0 through 17 inclusive... for a total of 18

DarrenWiens2

Can you quickly post a screenshot of the attribute table showing the 17 points?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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