Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

USGeoCoder CensusId and USZip9Coder Z9_Census_id



The US GeoCoder and US Zip9Coder both generate CensusId information, but they are not the same all the time. Does anyone know what that piece of information is based on and why it is different in some cases?



Alteryx Partner

Hi there!

The Censusid is based on US Census geography - specifically census tract / block info.  That geography doesn't map one to one to postal geography (such as zip9).  So, sometimes the relationship will be the same, and sometimes not.  The zip9 relationship is less likely to be accurate of course.


You can think of it this way:  If you assign an address the default zip code for a city, sometimes it will be the same as the true address zip code, and sometimes it won't be since the city likely has multiple zip codes.  


So, CensusId is based on the actual door address and Zii9_Census_id is based on the Zip9 that address resides, right?

There were so many cases where the 2 were exactly same and I was not sure if Alteryx returns the actual Census_Id for the address or not.