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!
... View more