Skip to main content
  • EN

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?

 

You can just test for ADDRESS_TYPE = Building

@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.

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.

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.

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

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!

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


Community Stats

31,818
Posts
120,841
Replies
39,446
Members

Latest FME

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