Latest Contributions by HeatherWidlund

Me, too. ... View more

This was extremely helpful and I was able to modify it for my purposes. However, there is an error in the script posted. When you loop through the "for i in range" part, you have to put in [i] as the index. I am reposting the script with my fix. ## f1 is temporary feature class with todays date, output by other processes. f1 = "RSE20190328" fields = ['L_StName','L_StDir','L_StTypP','L_StTypS','L_PlName'] ## street name, street direction, street type prefix, street type suffix and place name with arcpy.da.SearchCursor(f1,fields, sql_clause=('DISTINCT','ORDER BY L_PlName, L_StName, L_StTypS')) as cursor1: for row1 in cursor1: street_name = row1[0] street_direction = row1[1] street_prefix = row1[2] street_suffix = row1[3] street_place_name = row1[4] ## some street names have apostrophes in them - make the search replace that with a % because no combination I tried of escaping or backslashing the quote seemed to work correctly where2 = "L_StName = '" + street_name.replace("'","%") + "'" if street_direction is not None: where2 += " and L_StDir = '" + street_direction + "' " if street_prefix is not None: where2 += " and L_StTypP = '" + street_prefix + "'" if street_suffix is not None: where2 += " and L_StTypS = '" + street_suffix + "'" ## some place names have apostrophes in them - make the search replace that with a % because no combination I tried of escaping or backslashing the quote seemed to work correctly if street_place_name is not None: where2 += " and L_PlName = '" + street_place_name.replace("'","%") + "'" ## work with left and right sides separately as they may have 0,0 ranges in different spots. fields2 = ['L_LADD','L_HADD','ID'] ## left low address and left high address list2 = [] ## put results into list so we can easily compare each row to the previous row -- hard to do in a cursor with arcpy.da.SearchCursor(f1, fields2, where2, sql_clause=(None,'ORDER BY L_LADD, L_HADD')) as cursor2: for row2 in cursor2: if row2[0] == 0 and row2[1] == 0: ## ignore 0,0 ranges for my purposes continue list2.append([row2[0], row2[1], row2[2]]) for i in range (0, len(list2)-1): if list2[i][1] == list2[i+1][0] - 2: ## if there is a gap of exactly 2 there is no gap or overlap ##print "1: Good" continue elif list2[i][1] <= list2[i+1][0]: print "2:Gap" ## print results for now - eventually I will put the results into a separate list, and do an update cursor on them to print street_name + " " + street_suffix + " " + street_place_name + ": " + str(list2) continue elif list2[i][1] > list2[i+1][0] - 2 : print "3:Overlap" print street_name + " " + street_suffix + " " + street_place_name + ": " + str(list2) continue fields3 = ['R_LADD','R_HADD','ID'] ## right low address and right high address list3 = [] with arcpy.da.SearchCursor(f1, fields3, where2, sql_clause=(None,'ORDER BY R_LADD, R_HADD')) as cursor3: for row3 in cursor3: if row3[0] == 0 and row3[1] == 0: ## ignore 0,0 ranges for my purposes continue list3.append([row3[0], row3[1], row3[2]]) for i in range (0, len(list3)-1): if list3[i][1] == list3[i+1][0] - 2: ##print "1: Good" continue elif list3[i][1] <= list3[i+1][0]: print "2:Gap" print street_name + " " + street_suffix + " " + street_place_name + ": " + str(list3) continue elif list3[i][1] > list3[i+1][0] - 2 : print "3:Overlap" print street_name + " " + street_suffix + " " + street_place_name + ": " + str(list3) continue ... View more

I am struggling with this, too. I have an open support case with no resolution after weeks and weeks (includes the non-updating of Field Maps data when the data is updated using this method). I started doing the delete and append in Notebook on AGOL to try to avoid connection errors, but it still fails sometimes. I was hoping to automate it with Notebook when that functionality comes online next week but if it's still going to fail half the time that won't work either. ... View more

Thanks for the response, @ColinLawrence. When I follow the pull-down menus on support, under Apps and Mobile Apps, there is no option for Field Maps. I will try to call or choose Online. It happens on other map areas, too. When I went back to my device just now after a day, it showed an update available for the map area I've been working with, which I downloaded. But the data are still stale. The map doesn't show up in Collector as an option. ... View more

Still not available? I want another user to be able to add records to a table that updates a dashboard without logging in as me and uploading a new excel file. I set up edit views with limited permissions for the tables but can't add a new record so I'm stymied in my workflow. ... View more

Any update on COGO Report/Calculator/Measure now that we're at 2.5? ... View more

Thanks for the response, John. I see in reading your original answer more carefully that you had specified the collection of continuous points. As you note, it doesn't make any sense to have that variable for a line/polygon. I will mull things over as I start testing and let you know if I have any questions. Another option for my use case is simply to collect points at the surface change locations and manipulate my existing lines (generally from aerial photos) instead of trying to collect centerlines at the same time. ... View more

Hi JHasthorpe-esristaff I'm interested in the Direction of Travel variable you reference. In the documentation, I only see direction of travel as a variable for point features. The only ones listed for lines and polygons are  Variable Description Compatible field type username Currently signed in user name. Text positionSourceType Category of the position source. Potential results are Unknown (0), User (1), System Location (2), External Device(3), and Network Device (4). Integer startTime Date and time the button is activated. Date endTime Date and time the button is deactivated. Date Can you confirm that having a field for Direction in a polyline layer will record a direction? It seems like you might have to collect continuous points instead? How would this work? My use case is collecting road centerlines. The driver could be in the right lane fully, or for some of the narrow back roads, actually on the centerline. We would be using QC buttons to distinguish surface types for lines and I was thinking I could specify whether there is an offset. Thanks, Heather ... View more

Chris, can you give an update on radial curve support in the Parcel Drafter? I'm looking at implementing this and I'm not sure I can get what I need without it. Thanks! ... View more

I can confirm that I see the Attribute Transfer tool in the Tools Gallery at 2.4 and you can transfer attributes between feature types. Thank you! ... View more

I think this is a great idea. It has a name that could be used in a dynamic text tag. Please implement. ... View more

That's the error I got when I tried to use a source that was not a hosted feature layer (it was a map image layer published from ArcGIS Server). It doesn't have an object $map because it's not the right kind of source. ... View more