Part 5 - Generating Reports¶

1 Generating Reports
2 Conclusion

In [7]:

# Import Libraries
from arcgis.gis import GIS
from arcgis.geoenrichment import Country

In [8]:

# Create a GIS Connection
gis = GIS(profile='your_online_profile')

Generating Reports¶

GeoEnrichment also enables you to create many types of high quality reports for a variety of use cases describing the input area. These reports can be generated in PDF or Excel formats containing relevant information on demographics, consumer spending, tapestry market, etc. for the area. You can find a sample PDF report here.

Find details about a wide variety of existing reports here.

Available Reports¶

The reports property of a Country object lists its available reports as a Pandas DataFrame. Let's look at available reports for some countires. The report id you see below is used as an input in the create_report() method to create reports.

Reports Available for U.S.¶

In [9]:

# Get Country
usa = Country.get('USA')

In [10]:

# print a sample of the reports available for USA
usa.reports.head(10)

Out[10]:

	id	title	categories	formats
0	census2010_profile	2010 Census Profile	[Demographics]	[pdf, xlsx]
1	acs_housing	ACS Housing Summary	[Demographics]	[pdf, xlsx]
2	acs_population	ACS Population Summary	[Demographics]	[pdf, xlsx]
3	55plus	Age 50+ Profile	[Demographics]	[pdf, xlsx]
4	agesexrace	Age by Sex by Race Profile	[Demographics]	[pdf, xlsx]
5	agesex	Age by Sex Profile	[Demographics]	[pdf, xlsx]
6	cex_auto	Automotive Aftermarket Expenditures	[Consumer Spending]	[pdf, xlsx]
7	business_loc	Business Locator	[Business]	[pdf, xlsx]
8	business_summary	Business Summary	[Business]	[pdf, xlsx]
9	laborforce_profile	Civilian Labor Force Profile	[Demographics]	[pdf, xlsx]

In [11]:

# total number of reports available
usa.reports.shape

Out[11]:

(53, 4)

We can see that there are 53 reports available for United States along with their title, categoriies and the available formats.

Reports Available for Another Country¶

Let's look at the reports available for Australia.

In [12]:

# Get Country
aus = Country.get('Australia')

In [13]:

# print a sample of the reports available for USA
aus.reports.head(20)

Out[13]:

	id	title	categories	formats
0	AustraliaClothingAndFootwearSpendingMDS	Australia Clothing and Footwear Spending (MDS)	[Summary Reports]	[pdf, xlsx]
1	AustraliaEntertainmentSpendingMDS	Australia Entertainment Spending (MDS)	[Summary Reports]	[pdf, xlsx]
2	AustraliaFoodAndBeverageSpendingMDS	Australia Food and Beverage Spending (MDS)	[Summary Reports]	[pdf, xlsx]
3	AustraliaHealthAndBeautySpendingMDS	Australia Health and Beauty Spending (MDS)	[Summary Reports]	[pdf, xlsx]
4	MapDataServices_Households	Australia Household Summary (MapData Services)	[Summary Reports]	[pdf, xlsx]
5	AustraliaHousingAndHomeSpendingMDS	Australia Housing and Home Spending (MDS)	[Summary Reports]	[pdf, xlsx]
6	MapDataServices_Population	Australia Population Summary (MapData Services)	[Summary Reports]	[pdf, xlsx]
7	AustraliaSummaryReport	Australia Summary Report	[Summary Reports]	[pdf, xlsx]
8	AustraliaTransportationSpendingMDS	Australia Transportation Spending (MDS)	[Summary Reports]	[pdf, xlsx]
9	Custom_Map_Landscape	Custom Map Landscape	[Maps]	[pdf]
10	Custom_Map_Portrait	Custom Map Portrait	[Maps]	[pdf]
11	site_map_imagery04	Site Map on Satellite Imagery - 0.4 Miles Wide	[Maps]	[pdf]
12	site_map_imagery08	Site Map on Satellite Imagery - 0.8 Miles Wide	[Maps]	[pdf]
13	site_map_imagery16	Site Map on Satellite Imagery - 1.6 Miles Wide	[Maps]	[pdf]
14	site_map	Site Map	[Maps]	[pdf]

In [14]:

# total number of reports available
aus.reports.shape

Out[14]:

(15, 4)

Here we see that Australia has 15 reports available along with their title, categoriies and the available formats. Details about different categories of reports can be found here.

Creating Reports¶

The create_report method allows you to create many types of high quality reports for a variety of use cases describing the input area. Let's look at some examples of creating reports for some study areas. To learn more about Study Areas, refer to Enriching Study Areas guide.

Note: The report id must be used as an input in the create_report() method to create reports.

Report for Single Line Address¶

Let's create a report for an address using the Business Summary business_summary report id.

In [15]:

address_report = create_report(study_areas=["380 New York Street, Redlands, CA"],
                     report="business_summary",
                     export_format="PDF", 
                     out_folder=r"reports", 
                     out_name="esri_add_business_summary.pdf")
address_report

Out[15]:

'reports/esri_add_business_summary.pdf'

You can view the pdf report in reports folder on your disk. Here is a snapshot of how part of your report will look like in Pdf.

Report for Buffered Locations¶

Reports can also be created for one or more buffered rings, or drive time service areas around the points of interest. Let's create a report for a street address with non-overlapping disks of radii 1, 3 and 5 Miles respectively using the Business Summary report template report="business_summary".

We will export this report as a Microsoft Excel file using the XLSX export format.

In [16]:

buffered = BufferStudyArea(area='380 New York St Redlands CA 92373',
                           radii=[1,3,5], units='Miles', overlap=False)

In [17]:

buffered_report = create_report(study_areas=[buffered],
                     report="business_summary",
                     export_format="XLSX", 
                     out_folder=r"reports", 
                     out_name="esri_buffered_business_summary.xlsx")
buffered_report

Out[17]:

'reports/esri_buffered_business_summary.xlsx'

Here is a snapshot of how part of your report will look like in Excel.

Using `options`¶

options parameter can be specified for the study area buffer. Let's look at an example.

Note: By default a 1 mile radius buffer will be applied to points and address locations to define a study area.

In [238]:

# Define options
area_options={"areaType":"RingBuffer","bufferUnits":"esriMiles","bufferRadii":[1,3,5]}

In [239]:

# Create report
areaOptions_report = create_report(study_areas=["380 New York Street, Redlands, CA"],
                     report="business_summary",
                     export_format="XLSX",
                     options= area_options,
                     out_folder=r"reports", 
                     out_name="studyAreaOptions_business_summary.xlsx")
areaOptions_report

Out[239]:

'reports/buffered_business_summary.xlsx'

Report for a Point Feature¶

When a point is used as a study area, the service will automatically create a 1 mile ring buffer around the point to collect and append enrichment data. We will use the Business Location business_loc report to enrich() our point feature.

In [5]:

# Create point geometry
from arcgis.geometry import Point
pt = Point({"x" : -118.15, "y" : 33.80, "spatialReference" : {"wkid" : 4326}})

In [6]:

# Create report
pt_report = create_report(study_areas=[pt],
                     report="business_loc",
                     export_format="PDF", 
                     out_folder=r"reports", 
                     out_name="esri_pt_business_profile.pdf")
pt_report

Out[6]:

'reports/esri_pt_business_profile.pdf'

Report for a Polygon Study Area¶

Let's create a polygon and use the Laborforce Profile business_loc report to enrich() our polygon.

In [23]:

# Create polygon geometry
from arcgis.geometry import Polygon
poly = Polygon({"rings":[[[-117.26,32.81],[-117.40,32.92],[-117.12,32.80],[-117.26,32.81]]],
                "spatialReference":{"wkid":4326}})

In [24]:

# Create report
poly_report = create_report(study_areas=[poly],
                     report="business_loc",
                     export_format="PDF", 
                     out_folder=r"reports", 
                     out_name="esri_poly_business_profile.pdf")
poly_report

Out[24]:

'reports/esri_poly_business_profile.pdf'

Customizing Reports¶

Reports can be customized by specifying optional paramaters. Report header can be customzied to include title, subtitle and logo etc. Parameters can also be specified to explicitly call the country or dataset to query. Let's look at some examples of customizing reports.

Using `report_fields`¶

Optional parameter report_fields specifies additional choices to customize reports. For example, the title, subtitle, logo, etc., which appear in the header of a report can be customized with this parameter. Let's look at an example by customizing report title, subtitle and logo.

In [26]:

# Define report fields
custom_fields={"title": "My Report",
               "subtitle": "Produced by My Company"}

In [27]:

# Create report
customFields_report = create_report(study_areas=["380 New York Street, Redlands, CA"],
                     report="business_summary",
                     export_format="PDF",
                     report_fields= custom_fields,
                     out_folder=r"reports", 
                     out_name="customFields_business_summary.pdf")
customFields_report

Out[27]:

'reports/customFields_business_summary.pdf'

Here is a snapshot of how custom fields (highlighted in red boxes) look like in a report.

Using `use_data`¶

In order to explicitly call the country or dataset to query, the use_data parameter can be specified. This parameter can be specified to provide an additional "performance hint" to the service.

By default, the service will automatically determine the country or dataset that is associated with each location or area submitted in the study_areas parameter. Narrowing down the query to a specific dataset or country through this parameter will potentially improve response time.

Let's look at an example of how use_data is used to indicate to the service that all input features in the study_areas parameter describe locations or areas only discoverable in the U.S. USA_ESRI_2019 dataset.

In [249]:

# Define data
useData={"sourceCountry":"US","dataset":"USA_ESRI_2019"}

In [250]:

# Create report
useData_report = create_report(study_areas=["380 New York Street, Redlands, CA"],
                     report="business_summary",
                     export_format="XLSX",
                     use_data= useData,
                     out_folder=r"reports", 
                     out_name="useData_business_summary.xlsx")
useData_report

Out[250]:

'reports/useData_business_summary.xlsx'

Conclusion¶

In this part of the arcgis.geoenrichment module guide series, you saw how GeoEnrichment also enables you to create different types of high quality reports. You explored the reports property of a Country object to list available reports. You experienced, in detail, how create_report method allows you to create rich reports for various study areas. Towards the end, you saw how these reports can be customized as well.

In the next and final page, you will learn about Standard Geography Queries.

Feedback on this topic?

ArcGIS API for Python Guide