I have a series of line segments that I would like to use to find the count of points within 200 meters of each segment. Im having issues with the loop i have generated and I feel stumped on this one... ClassLoc_Events_Lyr = arcpy . MakeFeatureLayer_management ( ClassLoc_Events_Sort , "ClassLoc_Events_Lyr" ) Point_ClassLoc_FC_Lyr = arcpy . MakeFeatureLayer_management ( Poly_ClassLoc_FC , "Point_ClassLoc_FC_Lyr" ) with arcpy . da . UpdateCursor ( ClassLoc_Events_Lyr , [ "OID@" , "DWELLINGS_COUNT" ] ) as ClassLoc_Segments : for Segment in ClassLoc_Segments : Seg = arcpy . SelectLayerByAttribute_management ( ClassLoc_Events_Lyr , "NEW_SELECTION" , "OBJECTID = {}" . format ( Segment [ 0 ] ) ) Sel = arcpy . SelectLayerByLocation_management ( Point_ClassLoc_FC_Lyr , "WITHIN_A_DISTANCE" , Seg , "200 Meters" , "NEW_SELECTION" ) Out = arcpy . MakeFeatureLayer_management ( Sel , "ID_Points_Lyr" ) Point_Count = arcpy . GetCount_management ( Out ) Segment . setValue ( "DWELLINGS_COUNT" , Point_Count ) ClassLoc_Segments . updateRow ( Segment ) arcpy . Delete_management ( "ID_Points_Lyr" ) So the loop is supposed to update the line segments. First supposed to select the first row. Next it should then search within 200 meters of the selected row and make a new selection including only the points within the proximity. Then it makes a a seperate feature layer out of the selection in order to do the next step. Next step is to get a count of the selected points. Then it is supposed to update the row "DWELLINGS_COUNT" with the counted points. Finally the loop goes to the next row and the process repeats. Getting an error on line 10: AttributeError: 'list' object has no attribute 'setValue'

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

Update Cursor Help. To Iterate through line segments and get a count of points surrounding each segment.

ConnorMcivor

I have a series of line segments that I would like to use to find the count of points within 200 meters of each segment. Im having issues with the loop i have generated and I feel stumped on this one...

ClassLoc_Events_Lyr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>ClassLoc_Events_Sort<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ClassLoc_Events_Lyr"</SPAN><SPAN class="punctuation token">)</SPAN>
Point_ClassLoc_FC_Lyr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>Poly_ClassLoc_FC<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Point_ClassLoc_FC_Lyr"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>ClassLoc_Events_Lyr<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OID@"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DWELLINGS_COUNT"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> ClassLoc_Segments<SPAN class="punctuation token">:</SPAN>
     <SPAN class="keyword token">for</SPAN> Segment <SPAN class="keyword token">in</SPAN> ClassLoc_Segments<SPAN class="punctuation token">:</SPAN>
          Seg <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>ClassLoc_Events_Lyr<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"OBJECTID = {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>Segment<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
          Sel <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByLocation_management<SPAN class="punctuation token">(</SPAN>Point_ClassLoc_FC_Lyr<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"WITHIN_A_DISTANCE"</SPAN><SPAN class="punctuation token">,</SPAN> Seg<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"200 Meters"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">)</SPAN>
          Out <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>Sel<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ID_Points_Lyr"</SPAN><SPAN class="punctuation token">)</SPAN>
          Point_Count <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>Out<SPAN class="punctuation token">)</SPAN>
          Segment<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"DWELLINGS_COUNT"</SPAN><SPAN class="punctuation token">,</SPAN> Point_Count<SPAN class="punctuation token">)</SPAN>
          ClassLoc_Segments<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>Segment<SPAN class="punctuation token">)</SPAN>
          arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"ID_Points_Lyr"</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>

So the loop is supposed to update the line segments. First supposed to select the first row. Next it should then search within 200 meters of the selected row and make a new selection including only the points within the proximity. Then it makes a a seperate feature layer out of the selection in order to do the next step. Next step is to get a count of the selected points. Then it is supposed to update the row "DWELLINGS_COUNT" with the counted points. Finally the loop goes to the next row and the process repeats.

Getting an error on line 10:

AttributeError: 'list' object has no attribute 'setValue'

Find more posts tagged with

Accepted answers

JoshuaBixby

Even if your current approach will technically work, it will be slow/inefficient. ArcGIS geoprocessing tools are designed to work on sets of data, and since they are compiled code, they will generally outperform Python loops. I suggest looking at Generate Near Table—Help | ArcGIS Desktop and consider having it create the table for you, and then you can iterate through it to extract the results.

All comments

ConnorMcivor

So i have got the loop to start to function however the results are incorrect. The "DWELLINGS_COUNT" field is now populated with "3" in each row. The following is my revised code:

ClassLoc_Events_Lyr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>ClassLoc_Events_Sort<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ClassLoc_Events_Lyr"</SPAN><SPAN class="punctuation token">)</SPAN>
Point_ClassLoc_FC_Lyr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>Poly_ClassLoc_FC<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Point_ClassLoc_FC_Lyr"</SPAN><SPAN class="punctuation token">)</SPAN>
row <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>ClassLoc_Events_Lyr<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OID@"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DWELLINGS_COUNT"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> ClassLoc_Segments<SPAN class="punctuation token">:</SPAN>
	<SPAN class="keyword token">for</SPAN> Segment <SPAN class="keyword token">in</SPAN> ClassLoc_Segments<SPAN class="punctuation token">:</SPAN>
		Seg <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>ClassLoc_Events_Lyr<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Segment_Lyr"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"OBJECTID = "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
		Sel <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByLocation_management<SPAN class="punctuation token">(</SPAN>Point_ClassLoc_FC_Lyr<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"WITHIN_A_DISTANCE"</SPAN><SPAN class="punctuation token">,</SPAN> ClassLoc_Events_Lyr<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"200 Meters"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">)</SPAN>
		Out <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>Sel<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ID_Points_Lyr"</SPAN><SPAN class="punctuation token">)</SPAN>
		Point_Count <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>Out<SPAN class="punctuation token">)</SPAN>
		Segment<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>Point_Count<SPAN class="punctuation token">)</SPAN>
		ClassLoc_Segments<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>Segment<SPAN class="punctuation token">)</SPAN>
		arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Segment_Lyr"</SPAN><SPAN class="punctuation token">)</SPAN>
		arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"ID_Points_Lyr"</SPAN><SPAN class="punctuation token">)</SPAN>
		row <SPAN class="operator token">=</SPAN> row <SPAN class="operator token">+</SPAN> <SPAN class="number token">1</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>

JoshuaBixby

ConnorMcivor

So this process is way faster than my loop however the results are showing only the closest point to the line segment. Im not sure how i can manipulate this process to give me the answers I need but I will keep trying... Attached are some screenshots.

Note:

Line segments are overlapping features 100m meters apart (See in image 1, and 2, how there is slight overlap)

Image 3 shows the result table called "DWELLINGS_COUNT" and shows the corresponding features selected in the row. (One point seen selected to the right side near the line)

I need all points within my search radius listed (to be counted after the fact)

Image 4 shows what should be identified and counted

ConnorMcivor

Hey Joshua thanks for the suggestion, I went through it and found that you were indeed correct! Thanks for the help!

JoshuaBixby

Looking at the summary for Generate Near Table—Help | ArcGIS Desktop

Summary
Calculates distances and other proximity information between features in one or more feature class or layer. Unlike the Neartool, which modifies the input, Generate Near Table writes results to a new stand-alone table and supports finding more than one near feature.

The tool is designed specially to give "more than one near feature." Looking at the syntax for the tool, the default is for closest parameter to be CLOSEST, you should be passing ALL with a search radius.

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.