Latest Contributions by JeffDavis7

Hello, Randy Burton was kind enough to assist me by providing some wonderful Python code for creating labels using data from related tables specific for use in ArcGIS Desktop. I am hoping to take this a step further and provide my AGO users with same great labeling.  Randy suggested I post this question within the confines of AGO with the hope of obtaining some wise advice and direction. Can someone please assist me in this venture? Thank you. Jeff ... View more

Hello, I've tried to utilize the code I found posted by Richard Fairhurst that allows you to create labels based on data contained within a related table to no avail.  I keep getting the veritable "No features found. Could not verify expression".  Everyone's favorite error message.  BTW...a big shout out to Richard for posting this code and doing all he can to help others with this quest. I am attempting to add the information contained under the Table field "Name" to individual polygons. Any insight on what I am doing wrong would be most appreciated. Thank you. Jeff Here is the logistics of my relationship class setup: Origin Table: DBOPlotOccJoin Primary Key: UserField4 Foreign Key: GIS_ID Destination Table: BSACemeteriesCopy Table Label Field: Name Here is Richard's python code that I have augmented: # Initialize a global dictionary for a related feature class/table relateDict = {} def FindLabel ( [UserField4] 😞   # declare the dictionary global so it can be built once and used for all labels   global relateDict   # only populate the dictionary if it has no keys   if len(relateDict) == 0:     # Provide the path and table name to the relate feature class/table     relateFC = r"R:\Jeff\City_Projects\Cemetery\CemeteryMgmt.gdb\DBOPlotOccJoin"     # create a field list with the relate field first (POLYID),     # followed by sort field(s) (SCHOOLID), then label field(s) (CROSS_STREET)     relateFieldsList = ["GIS_ID", "Name"]    # process a da search cursor to transfer the data to the dictionary     with arcpy.da.SearchCursor(relateFC, relateFieldsList) as relateRows:       for relateRow in relateRows:         # store the key value in a variable so the relate value         # is only read from the row once, improving speed         relateKey = relateRow[0]         # if the relate key of the current row isn't found         # create the key and make it's value a list of a list of field values         if not relateKey in relateDict:           # [searchRow[1:]] is a list containing           # a list of the field values after the key.           relateDict[relateKey] = [relateRow[1:]]         else:           # if the relate key is already in the dictionary           # append the next list of field values to the           # existing list associated with the key           relateDict[relateKey].append(relateRow[1:])     # delete the cursor, and row to make sure all locks release     del relateRows, relateRow   # store the current label feature's relate key field value   # so that it is only read once, improving speed   labelKey = [UserField4]   # start building a label expression.   # My label has a bold key value header in a larger font   expression = '<FNT name="Arial" size="12"><BOL>{}</BOL></FNT>'.format(labelKey)   # determine if the label key is in the dictionary   if labelKey in relateDict:     # sort the list of the list of fields     sortedList = sorted(relateDict[labelKey])     # add a record count to the label header in bold regular font     expression += '\n<FNT name="Arial" size="10"><BOL>School Count = {}</BOL></FNT>'.format(len(sortedList))     # process the sorted list     for fieldValues in sortedList:        # append related data to the label expression        expression += '\n{0} - {1} - {2} - {3}'.format(fieldValues[0], fieldValues[1], fieldValues[2], fieldValues[3])     # clean up the list variables after completing the for loop     del sortedList, fieldValues   else:     expression += '\n<FNT name="Arial" size="10"><BOL>School Count = 0</BOL></FNT>'   # return the label expression to display   return expression ... View more

Hello, We have had great success with using Survey123 on our Android devices.  However, we have not had the same result when switching to our Surface pads. The download from ESRI resources goes smoothly but upon trying to open our form we receive and error box that says "Unable to connect--Position source closed error". Our Surface pads are running Windows 10 Intel i7 64 bit OS and we downloaded the x64 Windows version from ESRI resources. Can someone please offer some guidance regarding this issue? Thank you. Jeff ... View more