Mailing labels remove duplicate addresses

John Nerge

January 11, 2016 20:59

 

I saw a few posts on this that are a bit dated, so I thought I'd start fresh to look at the latest GE capabilities.

 

I'm trying to figure out the best way to make all of my property addresses searchable but limit mailing labels made from them to only unique addresses. It's not a problem for the property addresses since they're already unique. The problem arises when working with mailing addresses for the property owner/taxpayer, since one person can own multiple properties etc.

 

How are people currently handling making all addresses searchable while also filtering duplicates when pulling those addresses for mailings? I've played around with spatial views and data links, and they each have their own issues.

0

• 

  Tom Neer

  January 11, 2016 23:24

  We use a workflow for pulling owner addresses. The workflow runs generally like: ?

  1. Execute spatial query based on source parcel against the parcel feature layer. 
  2. Create an empty list to store the name, address, city, state, zip.
  3. Loop through the results, append if they are not already in the list.
  4. Use the list to create the mailing list.

  It's a little slower but generally more accurate. It won't handle garbage in, garbage out. You could compare only the mailing address concatenated but several owners may be at the same notification address.

   

  Example at https://maps.pitkincounty.com/

   

   

  0
• 

  John Nerge

  January 13, 2016 16:15

  That's a very nicely designed workflow. The hiccup for me would be that I'm using a standard Report activity to output the results to rtf format, and that activity only accepts a map layers queried with a geometry or a where clause.

   

  Are you using a template report to output the results to PDF? Would you be willing to share the workflow?

  0

Please sign in to leave a comment.