I need label expression in python to stack labels for points present at same geometry

Question

I have a data set that has stacked points. I need to display the labels as one. The dataset has locations that only have 1 point and some that have 2 or 3 stacked points. I’d also like to be able to change the color of the number on the background based upon a threshold exceedance of the value in the fourth row [GeoMean]. I’m thinking some kind of arcpy script within the label manager is the way to go.

This is how I want

This is how I am getting

This is VBScript I am using but I need in python.

[LocationID] only needs to be displayed once for the stacked points while [MediumSub], [n] and [GeoMean] need to be displayed for each stacked point.

Answer 1

You appear to be showing screen shots from ArcMap. I don't believe what you are asking is possible and the expression would need to do some sort of spatial analysis to determine if a point is part of a stack of points.

This might be something you could achieve in an ArcGIS Pro Pop-up using Arcade but then that's not a label, nor the same software.

I think your solution here is to pre-process your dataset so that there is only 1 point (when there was a stack of points) and ensure all the information you require to create the label is passed over in appropriate fields. You would then build your label from that.