AnsweredAssumed Answered

zip codes 2016

Question asked by ltbran on Dec 7, 2017
Latest reply on Dec 9, 2017 by jborgion

I'm trying to work with the 2016 esri_dm authored zip code file zip_poly located here:

 

https://services.arcgis.com/P3ePLMYs2RVChkJx/arcgis/rest/services/USA_ZIP_Codes_2016/FeatureServer 

 

I'd like to subset this file to the 48 states plus DC, and, join an excel table that contains information about the zip codes. The information is a categorical variable indicating 184 unique "catchment" areas that are defined in terms of sets of zip codes.

 

I am using ArcMap 10.5 on Windows 7 professional, and also ArcGIS Pro ... in both programs, if I join the excel file to the zip_poly layer, the attribute table indicates there are 30+k records.  If I try to export the join so that I can create a hosted feature layer on ArcGIS Online, it exports only 11,000 records (the bottom southeast quandrant of the US plus Alaska & Hawaii).  I thought it might be something with my Excel file, but I see nothing around record 11,000 different from any of the other records. So I tried to make a copy of the original zip_poly file prior to the join, using the Data Management Tool - Copy Features on the zip_poly file.  That too results in only 11,000 records being copied. 

Any tips/advice/experience using this file for zip codes or thoughts about why only 11k records would be saved would be greatly appreciated!

Outcomes