Skip to main content
Solved

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

juliarozema
Contributor
Forum|alt.badge.img+7

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

View original
Did this help you find an answer to your question?

7 replies

ebygomm
Influencer
Forum|alt.badge.img+39
  • ebygommInfluencer
  • Influencer
  • March 25, 2020

You can just test for ADDRESS_TYPE = Building

M
Forum|alt.badge.img+2

@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+7
  • juliarozemaContributor
  • Author
  • Contributor
  • 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+7
  • juliarozemaContributor
  • Author
  • Contributor
  • March 25, 2020
ebygomm wrote:

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+39
  • ebygommInfluencer
  • Influencer
  • 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+7
  • juliarozemaContributor
  • Author
  • Contributor
  • March 25, 2020
ebygomm wrote:

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
  • March 25, 2020
ebygomm wrote:

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

Reply


Helpful Members This Week

Community Stats

31,525
Posts
119,505
Replies
39,151
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

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.