topic Re: Count point that have matching attribute in Python Questions

Count point that have matching attribute

KennyYue — Wed, 15 Jul 2020 23:10:07 GMT

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

Re: Count point that have matching attribute

DanPatterson — Thu, 16 Jul 2020 01:27:30 GMT

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

Re: Count point that have matching attribute

KennyYue — Thu, 16 Jul 2020 03:10:58 GMT

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?

Re: Count point that have matching attribute

DanPatterson — Thu, 16 Jul 2020 08:30:06 GMT

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.