topic Re: Downloading data in ArcGIS Business Analyst Questions

Downloading data

SilverstonePartners — Mon, 16 Jan 2023 20:22:21 GMT

I'm using ArcGIS Business Analyst, and noticed that I can see, and manually download data for color-coded maps. For example, if I have Median Income at the Block Group level, I can see and download all the data that are displayed on the map (Block group number and median income). Is there a way to automatically query this data? Perhaps through an API? I'm just finding it tedious to move and re-center the map, then download - there has to be an easier way.

Thank you!

Re: Downloading data

CherylHagevik — Tue, 17 Jan 2023 15:58:18 GMT

Hello @SilverstonePartners, thank you for reaching out with your question. With Business Analyst, we have a few different options for querying demographic data for the purpose of exporting/downloading the data. To help provide options, can you please confirm for me if you are working with Business Analyst Web App or Business Analyst Pro? If using the Web App, which license type you are working with, Advanced or Standard?

Re: Downloading data

SilverstonePartners — Tue, 17 Jan 2023 16:13:49 GMT

Hi Cheryl, I believe it's Standard. Under the "License" area of Settings, I have:

Essential Apps

Field Apps

Office Apps

ArcGIS Business Analyst Web and Mobile Apps Standard

ArcGIS Runtime Standard

Re: Downloading data

HelenThompson — Tue, 17 Jan 2023 17:12:30 GMT

Hi @SilverstonePartners

There is an API for Business Analyst which is part of the broader developer tools. Data fro Business Analyst Web is hosted in ArcGIS Online and Living Atlas, and is accessible via data collections. This is an example of how to discover those collections for any of the 170+ counties worldwide using the geoenrichment engine:
https://developers.arcgis.com/documentation/mapping-apis-and-services/demographics/

If you don't want to use the API you can use geoenrichment or the analysis tools in Map Viewer Classic to snip out your data.

Hope this helps

Helen

Re: Downloading data

CherylHagevik — Tue, 17 Jan 2023 17:14:36 GMT

Thank you for confirming @SilverstonePartners. Here are a couple options to consider for downloading data using BA Web App. Please let me know if these details help to answer your question, or feel free to explain your goal further.

Create sites to use for running reports
- You can create sites based on a point, based on standard geographies (like block groups), or hand draw an area. Please see the Create sites resource for details.
- Example: Use Select Geography workflow to create sites for each census tract in a specific county.

Create Comparison reports
- After creating your sites, go to Comparison reports to display data for the areas. Use the drop down for Esri report templates. You can also export the data to Excel immediately.
- With Comparison reports, you have the ability to create your own custom list of variables to include in the report. Just use the option for +Create new report and use the Data Browser to create your custom list.

Create infographics and reports
- With a Standard license, you can also use premade templates that are available for infographics and reports. Classic reports are helpful for exporting larger amounts of data to excel for a particular site or area.

Re: Downloading data

SilverstonePartners — Tue, 17 Jan 2023 20:17:42 GMT

Thank you @CherylHagevik and @HelenThompson for your replies! I will do my best to figure this out - greatly appreciated.

Re: Downloading data

DonnaBuhr — Thu, 26 Jan 2023 03:37:07 GMT

Hello @SilverstonePartners You might also find viewing the available videos for each of the feature workflows helpful. Most features include a workflow video that provides a good overview of how to use the feature.

The Guided tours are also a great way to familiarize yourself with Business Analyst functionalities and workflows. To take a guided tour, click on your user name in the upper right hand corner of the app to expand the Account details drop-down menu and click Guided tours. Follow the tour instructions that walk you through each step, and be sure to click Tip to view additional helpful information.

Thank you for using Business Analyst!

Best regards,

Donna

Re: Downloading data

SilverstonePartners — Mon, 27 Mar 2023 20:19:49 GMT

HI Cheryl,

You replied to this awhile ago but I've just had a chance more recently to fully explore. What you suggested worked, however am I limited to 100 records, i.e. 100 Census Block groups? Is there any way to expand this? I tried this with Travis County in Texas, and there were 700+ block groups but the downloaded excel only had 100 records.

Re: Downloading data

SilverstonePartners — Mon, 27 Mar 2023 21:07:23 GMT

Hi Helen,

Thank you for the response here. Apologies for my late reply! It looks like this will provide me data about a specific lat/long, correct? Is there any way to ping the API for information about a specific census block group?

Re: Downloading data

CherylHagevik — Tue, 28 Mar 2023 14:37:18 GMT

Hi @SilverstonePartners With the Comparison Reports workflow, you should be able to add up to 1000 sites and then export the data to Excel. Canyou please confirm if you were working with Comparison Reports and if so, how many variables did you add to the report with your 700+ sites?

Re: Downloading data

SilverstonePartners — Fri, 31 Mar 2023 00:51:46 GMT

@CherylHagevik - thank you for reply. You are correct. I had not selected the right sites. Problem solved - all good from my end!