Skip to main content
Question

Split dataset into two streams. One, where points at shared locations. Two, where points are the only ones there.

  • January 23, 2024
  • 6 replies
  • 35 views

scarter
Contributor
Forum|alt.badge.img+10

Hello Community,

 

I have a points dataset containing 17 records. Some at stacked at shared locations. Some are isolated in one location…

 SwkPoints1 

I need to separate this into two different streams.

 

Stream one: all records that are at shared locations (i.e: sharing an XY co-ordinate pair)…

SwkPoints2_2 

Stream two: all records that are the only records at that location…

 SwkPoints3 

 How is this achievable?

 

Thanks,

6 replies

geomancer
Evangelist
Forum|alt.badge.img+58
  • Evangelist
  • 932 replies
  • January 23, 2024

I assume you determine uniqueness by the value of 'House'.

Use a StatisticsCalculator to count the number of times 'House' occurs, followed by a TestFilter to differentiate between features where 'House' occurs one time (stream two) and features where 'House' occurs more than once (stream one).

image


scarter
Contributor
Forum|alt.badge.img+10
  • Author
  • Contributor
  • 125 replies
  • January 23, 2024

I assume you determine uniqueness by the value of 'House'.

Use a StatisticsCalculator to count the number of times 'House' occurs, followed by a TestFilter to differentiate between features where 'House' occurs one time (stream two) and features where 'House' occurs more than once (stream one).

image

Sorry, no, I should have stated in my post. The uniqueness is the location. So, it would be based on the X and Y co-ordinates pair. Thanks, Stuart

geomancer
Evangelist
Forum|alt.badge.img+58
  • Evangelist
  • 932 replies
  • January 23, 2024

I assume you determine uniqueness by the value of 'House'.

Use a StatisticsCalculator to count the number of times 'House' occurs, followed by a TestFilter to differentiate between features where 'House' occurs one time (stream two) and features where 'House' occurs more than once (stream one).

image

Create a new attribute (X_Y), and use that attribute in the StatisticsCalculator (both 'Group By' and 'Statistics to Calculate').

Unique


scarter
Contributor
Forum|alt.badge.img+10
  • Author
  • Contributor
  • 125 replies
  • January 23, 2024

Create a new attribute (X_Y), and use that attribute in the StatisticsCalculator (both 'Group By' and 'Statistics to Calculate').

Unique

Thanks for that. I'll give it a go.


scarter
Contributor
Forum|alt.badge.img+10
  • Author
  • Contributor
  • 125 replies
  • January 23, 2024

Create a new attribute (X_Y), and use that attribute in the StatisticsCalculator (both 'Group By' and 'Statistics to Calculate').

Unique

Hi geomancer, That has worked perfectly. I can now apply this to the real data and connect to the rest of the workspace. Thank so much. Regards.


geomancer
Evangelist
Forum|alt.badge.img+58
  • Evangelist
  • 932 replies
  • January 23, 2024

Create a new attribute (X_Y), and use that attribute in the StatisticsCalculator (both 'Group By' and 'Statistics to Calculate').

Unique

Hi Stuart, you're welcome. Good luck!