Celebrating linguistic diversity workflow

Workflow using ArcGIS Online

Note:

The steps below are based on the November 2015 update of ArcGIS Online, but should work fine for subsequent software releases as well. You will need Administrator privileges in order to perform the analyses outlined below. Keep in mind that storing and analyzing data consumes credits.

Get the data for your analysis

1. Sign in to your ArcGIS Online account.
2. Search for Edmonton Mother Tongue Data. When it displays, select Open in map viewer.

   

   .

Note:

The default search is within your organization. If you aren't finding the data, ensure this default is unchecked.

You will need to publish your own copy of the data before proceeding with the workflow below.
3. Click the Content tab. Hover over the Edmonton Neighborhood Mother Tongue layer in the Contents pane to reveal the layer operations available to you. Click on More options () and select Copy.

   

4. Hover over the new layer (Edmonton Neighborhood Mother Tongue - Copy), click on More options () and select Save Layer.
5. Fill out the Create Item dialog. Set the Title to Edmonton Data, and save the item in a folder associated with your account. When you click on the Create Item button, it may take a few minutes to finish.

   

6. Locate the new data layer in your My Content (click Home and My Content). View the item details.

   

7. Click Publish and start the publishing process. It may take a minute for the feature service to be created.
8. Once the service has been created, open it in a new map (click Open and select Add layer to new map). You now have your own copy of the data to use in the workflow below.
The workflow below begins with neighborhoods containing complete data. You will use the mother tongue data to calculate a diversity index for each neighborhood and then create a hot spot map.

Calculate the diversity index

1. Hover over the Edmonton Data layer in the Contents pane and click the Show table button. Scroll right in the table to see the mother tongue language variables.
You will add a new field to hold the Linguistic Diversity Index (LDI).
2. Click on Table Options and select Add Field.

   

3. Provide the parameters below, and click the Add New Field button:
   • Name: LDI
   • Alias: Diversity Index
   • Type: Double
You will use the Calculate table tool to compute the LDI values for each neighborhood.
4. Click the gear symbol on the Diversity Index field and select Calculate.

   

5. Provide the formula below (copy and paste) into the box just below LDI =, and click the Calculate button.
   • 1 - ( POWER((ECYMTENGL / ECYMTTOT),2) + POWER((ECYMTFREN/ECYMTTOT),2) + POWER((ECYMTITAL/ECYMTTOT),2) + POWER((ECYMTGERM/ECYMTTOT),2) + POWER((ECYMTPUNJ/ECYMTTOT),2) + POWER((ECYMTCANT/ECYMTTOT),2) + POWER((ECYMTSPAN/ECYMTTOT),2) + POWER((ECYMTARAB/ECYMTTOT),2) + POWER((ECYMTTAGA/ECYMTTOT),2) + POWER((ECYMTPORT/ECYMTTOT),2) + POWER((ECYMTPOLI/ECYMTTOT),2) + POWER((ECYMTMAND/ECYMTTOT),2) + POWER((ECYMTCHIO/ECYMTTOT),2) + POWER((ECYMTURDU/ECYMTTOT),2) + POWER((ECYMTVIET/ECYMTTOT),2) + POWER((ECYMTUKRA/ECYMTTOT),2) + POWER((ECYMTPERS/ECYMTTOT),2) + POWER((ECYMTRUSS/ECYMTTOT),2) + POWER((ECYMTDUTC/ECYMTTOT),2) + POWER((ECYMTKORE/ECYMTTOT),2) + POWER((ECYMTGREE/ECYMTTOT),2) + POWER((ECYMTTAMI/ECYMTTOT),2) + POWER((ECYMTGUJA/ECYMTTOT),2) + POWER((ECYMTROMA/ECYMTTOT),2) + POWER((ECYMTHIND/ECYMTTOT),2) + POWER((ECYMTHUNG/ECYMTTOT),2) + POWER((ECYMTCROA/ECYMTTOT),2) + POWER((ECYMTCREO/ECYMTTOT),2) + POWER((ECYMTSERB/ECYMTTOT),2) + POWER((ECYMTBENG/ECYMTTOT),2) + POWER((ECYMTJAPA/ECYMTTOT),2) + POWER((ECYMTTURK/ECYMTTOT),2) + POWER((ECYMTCZEC/ECYMTTOT),2) + POWER((ECYMTSOMA/ECYMTTOT),2) + POWER((ECYMTABOR/ECYMTTOT),2) + POWER((ECYMTOTH/ECYMTTOT),2))
6. Click on the Diversity Index field and select Sort Ascending. Notice the smallest diversity index is 0.16 (low diversity). Click on the Diversity Index field again and select Sort Descending. Notice the largest index is 0.93 (high diversity).

Create a hot spot map of linguistic diversity

1. Hover over the Edmonton Data layer in the Contents pane to reveal the layer operations available to you. Click the Perform Analysis button.
2. Expand Analyze Patterns, select Find Hot Spots, and run the tool with the parameters below:
   • Choose layer for which hot spots will be calculated: Edmonton Data
   • Find clusters of high and low: Diversity Index
   • Divide by: None
   • Result layer name: an output layer name such as DiversityHotSpots
   • Use current map extent: No

     



High diversity areas are shown in red; low diversity areas are shown in blue.

Other applications

This case study evaluated linguistic diversity but similar steps could be employed to look at diversity for other categorical variables such as race/ethnicity, land use, occupations, age categories, home value categories, crop varieties, and so forth.

• Celebrating Linguistic Diversity - Analysis Overview
• References and resources for learning more