How to assign Mosaic type to a ZIP plus 4

[mike_psaris]

If I have a column with zip plus 4's, is there a way to get the mosaic type for each zip plus 4?

Thanks,

~Mike

[AndrewL · Accepted solution]

Mike,
Great question. It is fairly simple to get the mosaic type for each ZIP+4. The way to do it is to pull the Dominant cluster for each ZIP code, and then join that back to the ZIP+4 file. Each ZIP+4 would receive the same dominant cluster as the main ZIP code. The process would look like this:

Note that if you don’t want to select individual ZIP codes, you can just select the top level ZIP Code check box to pull all ZIP codes and the Join tool will sort out which ones actually match your ZIP+4 data. This will add processing time, but the Join tool will do all the work for you.
Also, if you have all of your ZIP+4’s in one field without a separate 5 digit ZIP code field, you can create a new field with just the 5 digit ZIP code with a simple formula. For any ZIP code 12345-6789, the formula would look like this: Left([ZIP+4 Field Name],5).