I'm trying to work with the 2016 esri_dm authored zip code file zip_poly located here:
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!