Latest Contributions by ConnorMcivor

***I have corrected both issues mentioned earlier*** ... View more

Sorry Joe for the late response. To clarify, I was stuck on one portion of the presented code snippet then got stuck on the next. I have both issues mentioned earlier. I am not sure if I should start a new thread or not for a new error I have though. I figured out how to populate the table with the values i needed. The next step was to "Make Route Events" out of them. The results are interesting: The table population works like I said, containing all values required. However when I attempt to make them into route events, the result shows only 1001 records if between 0 - 2002, and will show 2002 of the records if between 2002 and 4008 records. Simply, I have a table that includes the RouteID field and measure/chainage values from 0 - 2768, when the script runs, it will only show up to the 2002nd measure/chainages. When I run the "Make Route Events" tool outside of the script, everything runs fine, and shows all 2768 records. I have attempted a "Table to table" conversion prior to running the "Make Route Events" however that did not solve my problem. If this requires a new thread please correct me. ... View more

Max_Value is supposed to represent the value stored in the single only row of a polyline feature shape length. To better articulate my point:  Polyline feature class attribute table reads value "4263.344" in shape length field. I want to store that value in a variable so that in the next loop I can make a table that populates rows with 2 fields: "RouteID" and "Chainage" RouteID will be used in order to make route events and match the routeID from the original polyline. The Chainage should start at value 0 then append a new row containing the next consecutive integer until it reaches the rounded down version of the stored "Max_Value" (Called_"Max_Round", my variables may not be descriptive enough). Then I want to append the final row with just the "Max_Value". Output table should look like: ROUTEID            CHAINAGE Centerline            0 Centerline            1 Centerline            2 Centerline            3 .....continues...... Centerline            4263 Centerline            4263.344 Basically am making meter by meter points along a route, adding coordinates, extracting the elevation from the DEM, resorting and renaming the fields (through "Add XY" tool, automatically calls the fields "POINT X" and "POINT Y"  etc. so i just want them renamed for the final step) and final export into an excel worksheet. I have all the other parts working fine, because I stripped them from another tool i made last year. Always getting hung up on the cursors. I'm stuck again trying to determine how to get the code in the table populating loop to work. ... View more

I got it now guys, I am stuck on another part now but I am certain Ill be able to troubleshoot the rest. I was never great at the Cursors in school and it has now been a while since I have scripted. I am slowly relearning these things. Thank you all for your guidance. The fixed code: # Store value in SHAPE_LENGTH from Route with arcpy.da.SearchCursor(Route, ['Shape_Length']) as Cursor: for row in Cursor: Max_Value = row[0] del row del Cursor‍‍‍‍‍‍ ... View more

To answer what Dan had said, I originally had it in that specific format. However I was faced with a different error: AttributeError: 'float' object has no attribute 'getValue' I understand that the Shape_Length field is a 'float' format data type but i am unsure as to why it wont let me store the value to be used later. To respond to Joshua, I believe that your comment aligns with Dan's?  To answer Joe, I am aware that the 'row' in a search cursor is returned as a tuple and that it is indexed, hence the approach of what Joe had mentioned. For clarification in regard to your final statement "I'll let you you work on getting the max value...", the prerequisite for the tool I'm developing is a poly-line feature class with 1 row/feature of data, so the Max_Value is just the variable I store it as in order to append it to the table in line 17.  Thanks for the feedback guys I really appreciate it. ... View more

This was correct. I am just beginning to better familiarize myself with various string manipulation methods, and your comment makes sense although I don't fully understand it. I will research more into working with string methods. Thank you Randy! ... View more

I just need the required fields for file geodatabases. All non-required fields need to be gone. I now realise that i cannot delete Shape either and that is fine. So keep OID and SHAPE fields. All else needs to be removed. I dont want to hard code it because the input will not be the same fields each time. ... View more

Ok so yes I only work with file geodatabases when working on anything related to custom built tools. I am aware that the OID and Shape fields are required. I just need to strip away any tabular data and keep the essentials. Did I miss something in what you had suggested?  ... View more

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

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 ... View more