Skip to main content
Solved

Looking at the output from the Matcher, features with the same match_id, filter features by a different attribute

  • March 25, 2020
  • 7 replies
  • 38 views
juliarozema
Contributor
Forum|alt.badge.img+9

I hope you are doing well during these different times.

 

I have some point data that represents addresses. Sometimes one address (123 Main St) can have more than one feature because one represents the building and one the parcel.

 

I have used the Matcher, matching on the address string field. Now, I have a _match_id that is unique for each different address. Now I want to filter the data. Ex: For each unique _match_id value, filter out features that are an address_type of Building. How do you suggest doing this?

 

Best answer by ebygomm

In that case I'd assign a value based on the attribute type - so suite 1, building 2, parcel 3 etc. Then sort by this number, and then use a duplicate filter to return only the first occurrence of each address

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

7 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3427 replies
  • March 25, 2020

You can just test for ADDRESS_TYPE = Building

M
Forum|alt.badge.img+2
  • markatsafe
  • 1891 replies
  • March 25, 2020

@juliarozema - you might take a different tack and use the FeatureMerger instead of Matcher. Use a TestFilter to split your data based on Address_Type. Use BUILDING as the requestor and PARCEL as the Supplier. Join On the LVAPT_ADDRESS_STRING.

If you need to keep some of the Parcel attributes you can create a list.

juliarozema
Contributor
Forum|alt.badge.img+9
  • juliarozemaContributor
  • Author
  • Contributor
  • 45 replies
  • March 25, 2020

I should mention that sometimes there is three address types. so I could have 3 features with the same address, but I want to select a particular type only. If a SUITE exists, then I want a SUITE. If no SUITE, then I want the BUILDING. If no suite or building, then I want the PARCEL.

juliarozema
Contributor
Forum|alt.badge.img+9
  • juliarozemaContributor
  • Author
  • Contributor
  • 45 replies
  • March 25, 2020

You can just test for ADDRESS_TYPE = Building

I should mention that sometimes there is three address types. so I could have 3 features with the same address, but I want to select a particular type only. If a SUITE exists, then I want a SUITE. If no SUITE, then I want the BUILDING. If no suite or building, then I want the PARCEL.

ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3427 replies
  • Best Answer
  • March 25, 2020

In that case I'd assign a value based on the attribute type - so suite 1, building 2, parcel 3 etc. Then sort by this number, and then use a duplicate filter to return only the first occurrence of each address

juliarozema
Contributor
Forum|alt.badge.img+9
  • juliarozemaContributor
  • Author
  • Contributor
  • 45 replies
  • March 25, 2020

In that case I'd assign a value based on the attribute type - so suite 1, building 2, parcel 3 etc. Then sort by this number, and then use a duplicate filter to return only the first occurrence of each address

oooh! That could work! Let me give this a whirl!

bwn
Evangelist
Forum|alt.badge.img+26
  • bwnEvangelist
  • Evangelist
  • 562 replies
  • March 25, 2020

In that case I'd assign a value based on the attribute type - so suite 1, building 2, parcel 3 etc. Then sort by this number, and then use a duplicate filter to return only the first occurrence of each address

Yep, Sorter + DuplicateFilter is how I always select the Top result out of Groups based on a Priority too

Community Stats

32,076
Posts
121,797
Replies
39,707
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.