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 Id | Uid |
---|---|
1 | 731000 |
2 | 731001 |
3 | 731002 |
4 | 731003 |
5 | 722000 |
6 | 723000 |
Points
object Id | date | Uid |
---|---|---|
1 | 6/4/2020 | 731000 |
2 | 6/4/2020 | 731002 |
3 | 6/12/2020 | 731000 |
4 | 6/12/2020 | 731003 |
5 | 6/12/2020 | 722000 |
6 | 6/19/2020 | 731000 |
7 | 6/19/2020 | 731003 |
8 | 6/19/2020 | 722000 |
9 | 6/27/2020 | 731000 |
10 | 6/27/2020 | 722000 |
Goal:
object Id | Uid | count |
---|---|---|
1 | 731000 | 4 |
2 | 731001 | 0 |
3 | 731002 | 1 |
4 | 731003 | 2 |
5 | 722000 | 3 |
6 | 723000 | 0 |
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
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?
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.