@ElaineCollinson
The Frequency geoprocessing tool might be useful. https://pro.arcgis.com/en/pro-app/latest/tool-reference/analysis/frequency.htm
You'll get a derivative table containing the number of records per type/criteria.
This can then be run through a copy cursor to create a new table with the number of points matching the number of occurrences of each instance.
Below was something I used a while ago. I'm not a coder and you can probs do it many other ways. This runs in a Notebook.
Points_A = points dataset with output of Frequency added to a field called Frequency.
It creates a new table, then adds points to it based on the count from Frequency.
You'll need to find a way to join up your records table with the resulting points so you can do the various thematics but this should give you a nice rabbit hole to explore.
import arcpy
import os
# Inputs
input_fc = r"C:\Data.gdb\Points_A"
output_fc = r"C:\Data.gdb\Points_A_Count"
frequency_field = "Frequency" # count field
# Split path and name correctly because had issues
out_path, out_name = os.path.split(output_fc)
# Create output feature class using input schema
arcpy.management.CreateFeatureclass(
out_path=out_path, #issues
out_name=out_name, #issues
geometry_type="POINT",
template=input_fc,
spatial_reference=input_fc
)
# Get needed fields
fields = [f.name for f in arcpy.ListFields(input_fc) if f.type not in ("OID", "Geometry")]
# Add geometry
fields.append("SHAPE@XY")
with arcpy.da.SearchCursor(input_fc, fields + [frequency_field]) as search_cursor, \
arcpy.da.InsertCursor(output_fc, fields) as insert_cursor:
for row in search_cursor:
freq = row[-1] # Frequency is the last field in the cursor
freq = int(freq) if freq else 1 # sanity check input freq, 1 if dodgy
insert_row = row[:-1]
for _ in range(freq):
insert_cursor.insertRow(insert_row)
print(f"Dunny: {output_fc}")
