Count point that have matching attribute

Question

I'm working with an asset with data that consist of polylines and points. There are a lot of points that are created after work orders from field workers. These point have the same Uid as the specific Line segment. Relationship between line and point are One-to-Many. They are not necessarily intersecting. I would to add a field to the polyline attribute table to show total count of these points are matching with the line Uid.

Lines

object IdUid173100027310013731002473100357220006723000

Points

object IddateUid16/4/202073100026/4/202073100236/12/202073100046/12/202073100356/12/202072200066/19/202073100076/19/202073100386/19/202072200096/27/2020731000106/27/2020722000

Goal:

object IdUidcount173100042731001037310021473100325722000367230000

danretired · Answer

That workflow is fine.  If you were scripting you could exploit numpy to get the unique UID s and their counts and use

ExtendTable—Data Access module | Documentation

to add the results back into the polyline featureclass as a permanent join.

KennyYue · Answer

Hi Dan, Thank you for your reply.

The UID data is in numeric.

I'm looking for option out here. because the point features are actually from a feature service sourced from another platform. I checked your recommendation for using Summarize Attribute, it works well to generate a table and join back with the line feature using the UID.

Do you other suggestion in such situation?

danretired · Answer

Summarize Attributes—Help | Documentation

are your UID data text (that look like numbers) or numbers?

Summary Statistics—Help | Documentation

Counts for summaries.

Are you coding for this? or just looking for associated tools? since there are many other options that don't require an advanced license or limited output capabilities