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+38
  • 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+38
  • 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,327
Posts
118,852
Replies
38,954
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.