Skip to main content
Question

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

scarter
Contributor
Forum|alt.badge.img+9

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+47
  • geomancerEvangelist
  • Evangelist
  • 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+9
  • scarterContributor
  • Author
  • Contributor
  • January 23, 2024
geomancer wrote:

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+47
  • geomancerEvangelist
  • Evangelist
  • January 23, 2024
geomancer wrote:

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+9
  • scarterContributor
  • Author
  • Contributor
  • January 23, 2024
geomancer wrote:

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+9
  • scarterContributor
  • Author
  • Contributor
  • January 23, 2024
geomancer wrote:

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+47
  • geomancerEvangelist
  • Evangelist
  • January 23, 2024
geomancer wrote:

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!

Reply


Helpful Members This Week

Community Stats

31,105
Posts
117,920
Replies
38,856
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.