AnsweredAssumed Answered

Splitting groups of points by common field values

Question asked by riamuyabu on Sep 29, 2013
Latest reply on Oct 1, 2013 by riamuyabu
Hi,

I am trying to split groups of points that intersect polylines, but I cannot seem to find a tool that can perform the task. I have performed a spatial join with a one-to-many relationship so that all of the points now have the [Roads.ID] value stored in [Points.RoadsID] field where they intersect.

Here is a sample of my data: -

[Roads]
[Roads.ID]
[Roads.Name]
[Roads.Shape_Length]

[Points]
[Points.ID]
[Points.RoadsID]
[Points.Speed]

What I would like to do is split the [Points] table up into groups of points that all have the same [Points.RoadsID] value so I can perform statistical analysis on them on a road-by-road level.

Any help would be appreciated,

Thanks,

Liam.

Outcomes