Accepted Solutions
Thanks for the screen capture. I am going to make one assumption: the field "Name" is in the "DBOPlotOccJoin" table. If that is the case, then here is a simplified example of the labels and data I used for my testing.
The following code gets pasted in the expression section of the Label Expression window. Be sure to check 'Advanced' and select Python as the 'Parser' before pasting.
# Initialize a global dictionary for a related feature class/table
relateDict = {}
def FindLabel ( [GIS_ID] ):
# 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 (GIS_ID),
# followed by sort field(s) (Name), then label field(s) (...)
relateFieldsList = ["UserField4", "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 = [GIS_ID]
# 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>Name 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])
expression += '\n{0}'.format(fieldValues[0])
# clean up the list variables after completing the for loop
del sortedList, fieldValues
else:
# expression += '\n<FNT name="Arial" size="10"><BOL>Name Count = 0</BOL></FNT>'
pass
# return the label expression to display
return expressionLine 3 is the field in the feature that we are using for labeling and linking to the related table: GIS_ID.
Line 12 contains the linking field in the related table along with the related data used for the labels: UserField4 and Name
Line 41 is sorting the dictionary values, in this case the "Names". You may wish to comment this line out if you do not want the names sorted.
I commented out line 43 as this adds a line to the label indicating how many names are associated with the feature.
Line 47 was also commented out, as there is only one field value being used, in this case "Name".
The else block, lines 51-53, was left in, but the name count is not added to the label.
Hope this helps.
Thanks for the screen capture. I am going to make one assumption: the field "Name" is in the "DBOPlotOccJoin" table. If that is the case, then here is a simplified example of the labels and data I used for my testing.
The following code gets pasted in the expression section of the Label Expression window. Be sure to check 'Advanced' and select Python as the 'Parser' before pasting.
# Initialize a global dictionary for a related feature class/table
relateDict = {}
def FindLabel ( [GIS_ID] ):
# 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 (GIS_ID),
# followed by sort field(s) (Name), then label field(s) (...)
relateFieldsList = ["UserField4", "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 = [GIS_ID]
# 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>Name 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])
expression += '\n{0}'.format(fieldValues[0])
# clean up the list variables after completing the for loop
del sortedList, fieldValues
else:
# expression += '\n<FNT name="Arial" size="10"><BOL>Name Count = 0</BOL></FNT>'
pass
# return the label expression to display
return expressionLine 3 is the field in the feature that we are using for labeling and linking to the related table: GIS_ID.
Line 12 contains the linking field in the related table along with the related data used for the labels: UserField4 and Name
Line 41 is sorting the dictionary values, in this case the "Names". You may wish to comment this line out if you do not want the names sorted.
I commented out line 43 as this adds a line to the label indicating how many names are associated with the feature.
Line 47 was also commented out, as there is only one field value being used, in this case "Name".
The else block, lines 51-53, was left in, but the name count is not added to the label.
Hope this helps.
I know this is a bit old at this point but I have a question about this code.
First off, thank you so much for posting it. It works beautifully most of the time. However, every now and then I get something like this happening:
This point only has 6 things related to it all of which are on the first two lines:
You can see the related features in the table here:
It's like the label is repeating features for some reason. Is there a way I can fix this?
I used your code exactly as it is above, just changed field names and table location.
