Table of U.S. Counties, Cities, Zips

863
1
Jump to solution
01-10-2020 11:04 AM
by Anonymous User
Not applicable

I need a table of Untied States counties, cities, and zip codes via Business Analytics Online. 

esriBAO doesn't allow selecting more than 1,000 geographies. Any solutions?

1 Solution

Accepted Solutions
FasilTiru
Esri Regular Contributor

Hello Kevin,

The Select Geography workflow is limited to 1000 geographies for performance reasons in the app. Here are some alternative options that might help you:

  1. In the Business Analyst Web App (BAO), go to Create Maps > Color-Coded Maps > select any variable > zoom to the desired map extent > select the desired geography level as shown below. Notice some detailed geography levels are not available at large extents for the same performance reason. Now, click on the Data tab and you will see the Export to Excel option at the bottom. The exported file will contains all the geographies in visible map extent and it's not limited to 1000. 
  2. If you have access to ArcGIS Business Analyst Desktop/Pro, all the geography boundaries are included with the data and you can export them to an excel table.
  3. Some of these geographic boundaries are available in ArcGIS Online (arcgis.com) and some of them allow exporting to a file. For example, you can export this USA counties layer to excel if you are signed in using the same credentials you use for business analyst. https://www.arcgis.com/home/item.html?id=48f9af87daa241c4b267c5931ad3b226 
  4. The ArcGIS Living Atlas is a really good resource when you are signed in to your ArcGIS Online account. 
  5. You can also contact Esri technical support team and they might be able to help you with this further.

Thanks,

Fasil T.

Business Analyst Team

View solution in original post

1 Reply
FasilTiru
Esri Regular Contributor

Hello Kevin,

The Select Geography workflow is limited to 1000 geographies for performance reasons in the app. Here are some alternative options that might help you:

  1. In the Business Analyst Web App (BAO), go to Create Maps > Color-Coded Maps > select any variable > zoom to the desired map extent > select the desired geography level as shown below. Notice some detailed geography levels are not available at large extents for the same performance reason. Now, click on the Data tab and you will see the Export to Excel option at the bottom. The exported file will contains all the geographies in visible map extent and it's not limited to 1000. 
  2. If you have access to ArcGIS Business Analyst Desktop/Pro, all the geography boundaries are included with the data and you can export them to an excel table.
  3. Some of these geographic boundaries are available in ArcGIS Online (arcgis.com) and some of them allow exporting to a file. For example, you can export this USA counties layer to excel if you are signed in using the same credentials you use for business analyst. https://www.arcgis.com/home/item.html?id=48f9af87daa241c4b267c5931ad3b226 
  4. The ArcGIS Living Atlas is a really good resource when you are signed in to your ArcGIS Online account. 
  5. You can also contact Esri technical support team and they might be able to help you with this further.

Thanks,

Fasil T.

Business Analyst Team