Collect fountain data

Before you can analyze the equitable distribution of drinking fountains across Berkeley, you need to know where they are and whether they are clean or dirty. You'll acquire this information through ArcGIS Collector, an ArcGIS app that allows users to capture data in the field using a smartphone or other mobile device.

Create a layer

First, you'll create the feature layer that will be used to add fountains in ArcGIS Collector. You'll create this layer on ArcGIS Online (or ArcGIS Enterprise).

  1. Sign in to your ArcGIS organizational account or into ArcGIS Enterprise using a named user account.
    Note:

    If you don't have an organizational account, you can sign up for an ArcGIS free trial.

  2. On the ribbon, click Content.

    Content option on ribbon

  3. On the Content page, click Create and choose Feature Layer.

    Feature Layer option in Create menu

    The Create a feature layer window appears.

  4. For What do you want to do, click Build a layer.

    Build a layer option

    A list of feature layer templates appears. You can create a point, line, or polygon feature layer. Drinking fountains would be best displayed as points.

  5. Click the Points template and click Create.

    The default name of the new layer is Point layer.

  6. Click Point layer (don't uncheck the box), change the name to Fountains, and press Enter.

    Renamed point layer

  7. Click Next.

    Next, you'll choose the default extent of the layer. Because your area of interest is Berkeley, California, you'll adjust the extent accordingly.

  8. Pan and zoom to the California coast, near San Francisco.

    Location of San Francisco in the United States

  9. Continue to zoom until you see Berkeley (northeast of San Francisco). Center the map on Berkeley.

    Location of Berkeley

  10. Click Next.

    Next, you'll add metadata for your new layer, such as its name, search tags, and description.

  11. For Title, type Berkeley Fountains. To make the layer name unique, add your name or initials to the end of the name.
    Note:

    If the layer name is not unique in your organization, you won't be able to create the layer.

  12. For Tags, type Fountains and press Enter. For Summary, type A layer to collect the locations and conditions of drinking fountains in Berkeley, California.
  13. Click Done.

    The feature layer is created. Its details page, which contains metadata and other information, opens.

Configure fields

You've created the layer, but you still need to create a way to track whether fountains are functional or nonfunctional and dirty or clean. To do so, you'll configure the layer's fields. These fields can contain additional information about features. You'll create two fields: one to track whether fountains are functioning, and one to track whether they are dirty.

  1. On the details page, click the Data tab. Click Fields.

    Fields option on Data tab

    A list of the layer's fields appears. By default, the layer already has a few fields. Some of these are ID fields, while others track the dates when features were created or edited. One field, Photos And Files, can have images or other files attached to it.

  2. Click the Add button.

    Add button

    The Add Field window appears.

  3. For Field Name, type Functioning. For Display Name, type Functioning.

    You don't need to change the field's type or give it a default value. You'll make sure users don't leave this field blank.

  4. Uncheck Allow Null Values.

    Allow Null Values option unchecked

  5. Click Add New Field.

    The Functioning field is added to the list. Next, you'll add one more field.

  6. Click the Add button. In the Add Field window, for both Field Name and Display Name, type Condition.
  7. Uncheck Allow Null Values and click Add New Field.

    The Condition field is added to the list. Now that you've created both fields, you'll create a list of possible options users can choose for each field. For the Functioning field, you want to make sure responses are either yes or no.

  8. In the list of fields, under Display Name, click Functioning.

    Functioning field display name

    Information about the field appears.

  9. Click Create List.

    Create List button

  10. For Label, type Yes. For Code, type Yes.
  11. Click Add. In the new list value, for both Label and Code, type No.

    Label and Code options for list values

  12. Click Save.

    With these list values, users will only be able to answer yes or no for the Functioning field. For the Condition field, you'll create list values so that users can only answer that the fountain is clean or dirty.

  13. In the list of fields, click Condition. Click Create List.
  14. Create a list value with a label and code of Clean. Create a second list value with a label and code of Dirty.
  15. Click Save.

Add the layer to a map

Your layer is finished. You'll add it to a map and share the map with a group. Members of that group will be able to access the map in ArcGIS Collector.

  1. On the ribbon, click the Overview tab.

    Overview tab

  2. Click the arrow next to Open in Map Viewer and choose Add to new map with full editing control.

    Add to new map with full editing control option

    The layer is added to a new map with an extent centered on Berkeley. The layer currently has no data, so no features appear on the map. That's fine; later, you'll add features using ArcGIS Collector.

  3. On the ribbon, click Save and choose Save As.

    Save As option

  4. In the Save Map window, for Title, type Berkeley Fountains. For Tags, type Drinking Fountains and press Enter. For Summary, type This map contains public drinking fountains in Berkeley, California.
  5. Click Save Map.

    The map is saved. Next, you'll share it. To access a map in ArcGIS Collector, it must be either a map that you created or a map shared with a group of which you are a member.

    You created this map, so you'll be able to access it in ArcGIS Collector, but in a real-world scenario you may have multiple users collecting data who need to have access to the map. To share the map with other users, you'll create a group.

    Note:

    In a real-world scenario, your organization may have already created a group for sharing utilities data. In that instance, you can skip the steps for creating a new group (steps 6 through 10) and share your content with the group that is already made. You will only be able to share content with a group if you are a member of the group.

  6. On the ribbon, next to the map title, click Home and choose Groups.

    Groups option

    A list of your groups appears. It contains both groups you created and groups you have joined.

  7. Click Create group.

    Create group button

  8. For Group Name, type Berkeley Fountains. For Summary, type A group for collecting the locations and conditions of public drinking fountains in Berkeley, California. For Tags, type Drinking Fountains and press Enter.

    You'll also limit who can view the group.

  9. For Who can view this group, choose Only group members.

    By choosing this option, it also limits who can join the group. Users can only become members of the group if you invite them.

  10. Click Create Group.

    The group is created and the group's details page appears. On this page, you can edit the group's description, thumbnail, and other metadata. You can also invite users.

    Next, you'll share your map with the group.

  11. Under No Items Yet, click View My Content.

    View my content button

    Your Content page appears. It contains all of the content, including maps and layers, you have saved in your account.

  12. In your list of content, check your Berkeley Fountains map and your Berkeley Fountains feature layer.
    Note:

    Unless you specified otherwise, both the map and the layer were saved in your default folder. If you have difficulty finding the map and layer, you can search for them using the search bar.

    Web map and feature layer

  13. Click Share.

    Share button

  14. In the Share window, under Set group sharing, click Edit group sharing.

    Edit group sharing

  15. Check the Berkeley Fountains group and click OK.
  16. Click Save.

    The map and layer are now shared with the group. Members of the group can access the map using ArcGIS Collector.

Collect data on a mobile device

Next, you'll collect a fictitious drinking fountain record using ArcGIS Collector.

  1. Open ArcGIS Collector on either your Android or iOS mobile device or on your Windows 10 operating system.
    Note:

    If you don't have ArcGIS Collector, you can download it for free as a mobile app from the App Store or Google Play. Alternatively, you can download it for free as a Windows 10 desktop app from Microsoft.

  2. Click Sign In with ArcGIS Online or Sign In with ArcGIS Enterprise. Sign in with the appropriate credentials.

    After you sign in, a gallery of web maps appears. These are all the maps to which you have access that have editable data.

    Note:

    Depending on the device you use to access Collector, your interface may differ from the example images.

  3. Tap the Berkeley Fountains map icon.

    Berkeley Fountains map

  4. If you receive a notification asking you to allow ArcGIS Collector to access your location, click Allow.

    The map opens to your current location. This location is probably not Berkeley, California (in the example images, the location is Esri headquarters in Redlands, California).

    Because the fountain you're collecting is fictitious and your goal is simply to test the functionality, it doesn't matter where you add a feature. In a real-world scenario, users would travel around the city and add features wherever they found a fountain.

  5. Tap the plus button.

    Plus button

    The Fountains form appears. If your phone's GPS accuracy is sufficient, your location is used as the location of the new fountain feature. (You can choose to change the location by dragging the point on the map and clicking Update Point.)

    Note:

    You can also collect data at a location other than where your GPS is locating the phone. Click the search button (the magnifying glass) and type the address. Click the correct search result to navigate to the address's location and click Collect here.

  6. If your phone's GPS has low accuracy and your location wasn't used, tap Add Point and click Use Poor Location.

    The Fountains form contains the latitude and longitude of your new fountain feature, the option to update the feature's location, and options to take a photograph of the fountain or attach a file with more information.

    Fountains form

    Additionally, you can add information for the fields you previously created. When you made these fields, you disallowed null values, so both fields are required.

  7. In the form, tap Functioning. Choose Yes.
  8. Scroll the form and tap Condition. Choose Dirty.
  9. If you want, tap Take Photo and take a photograph of any nearby object.
    Note:

    You may need to give Collector access to your mobile camera. Tap OK to allow.

  10. Tap Submit.

    Submit button

    The fountain is collected. You'll check your original web map to confirm that the fountain feature was added to it.

  11. On your computer, on your Content page, click the Berkeley Fountains web map. On the details page, click Open in Map Viewer.

    Open in Map Viewer

    The web map is still centered on Berkeley.

  12. On the web map, navigate to the location where you added your fountain.
    Tip:

    To navigate quickly, you can search for the location in the search bar. Alternatively, in the Contents pane, point to the Berkeley Fountains layer and click the More Options button. Choose Zoom to.

    The fountain point is displayed as a red circle.

  13. Click the fountain.

    Fountains pop-up

    The fountain's pop-up opens. It contains the values you chose for the Functioning and Condition field. These values also appear in the layer's table.

  14. Close the pop-up. Close the web map without saving.

In this lesson, you created a layer to collect information about drinking water fountains in Berkeley, California. You added mandatory fields to track the condition of the fountains and added the layer to a new web map. In ArcGIS Collector, you added a fictitious fountain to test your layer's functionality.

In a real-world scenario, users would use your layer to collect information about actual fountains throughout the city. In the next lesson, you'll use the results those users collected to analyze whether fountains (and by extension, access to clean drinking water) are distributed equitably across the city.


Analyze fountain distribution

In the previous lesson, you collected information about the location and condition of public drinking fountains in Berkeley, California. In this lesson, you'll analyze the distribution of fountains. In particular, you'll determine if fountains are distributed equitably.

The concept of environmental justice implies that resources (parks, fountains, fire stations) and burdens (incinerators, wastewater treatment plants, landfills) are equally distributed, regardless of the social vulnerability of the community or demographic factors such as household income or race.

You'll answer the following questions: Is the location and condition of fountains in Berkeley an environmental justice issue? Do some census blocks have more dirty fountains than others? Are differences in the number of dirty fountains related to the social vulnerability of the census block?

Add demographic and fountain data

To perform your analysis, you'll need data about the demographics in Berkeley and the fountains in Berkeley. While you previously created a layer for collecting fountain information, without extensive fieldwork you won't have a complete Berkeley fountain dataset. For the purposes of this exercise, you'll add fountain data that was collected by students at the University of California, Berkeley.

First, you'll add demographic data that shows the social vulnerability of areas around Berkeley. You'll add this data from ArcGIS Living Atlas of the World, Esri's collection of authoritative data.

  1. Open your Berkeley Fountains web map. If your map is still open from the previous lesson, navigate back to Berkeley, California.
  2. On the ribbon, click Add and choose Browse Living Atlas Layers.

    Browse Living Atlas Layers option

    The Contents pane changes to include a search bar and a list of ArcGIS Living Atlas layers.

  3. Click Search for layers, type CDC's Social Vulnerability Index, and press Enter.

    The Centers for Disease Control and Prevention (CDC) is the United States government's health protection agency. Its Social Vulnerability Index (SVI) measures how well a community can withstand disasters or health hazards. It is based on demographic variables collected by the United States Census Bureau.

  4. In the search results, identify the most recently available CDC's Social Vulnerability Index (SVI) by data_cdc and click the Add button.

    Add button

  5. Click the Back button.

    Back button

    Darker blue census tracts are those with the highest SVI, while yellow census tracts have the lowest SVI. The dataset covers the entire United States, but you're only interested in Berkeley. You'll add a layer showing the Berkeley city limits to narrow your focus area.

    CDC's SVI layer

    Tip:

    To check a layer's legend, click its name in the Contents pane. Alternatively, at the top of the Contents pane, click Legend.

  6. On the ribbon, click Add and choose Search for Layers.

    The pane for searching for layers reappears. By default, you'll search for layers in your Content page. The layer that you'll add is owned by the Learn ArcGIS administrator account.

  7. Click My Content and choose ArcGIS Online. Clear the existing search text, type Berkeley City Limits owner:Learn_ArcGIS, and press Enter.

    Search for Berkeley City Limits layer

  8. For the Berkeley City Limits layer, click the Add button.

    The layer is added to the map. Next, you'll add three fountains layers. One contains all of the fountain data collected in Berkeley, while one contains only dirty fountains and one contains only clean fountains.

  9. Replace the existing search text with Berkeley Fountains owner:Learn_ArcGIS and press Enter.
  10. Add the Berkeley Fountains, Berkeley Fountains (Clean), and Berkeley Fountains (Dirty) layers.
  11. If necessary, zoom closer to the Berkeley city limits.

    Berkeley with fountains

    On the map, red fountains are those that were found to be clean, while blue fountains are those that were found to be dirty, littered, or rusted. Are clean fountains located primarily in census tracts with low SVI? Are dirty fountains located primarily in census tracts with high SVI? It can be difficult to make a conclusion with certainty unless you perform analysis.

    Before you continue, you'll save this map as a new map to keep your analysis separate from your data collection.

  12. Click the Back button.
  13. On the ribbon, click Save and choose Save As. The Save Map window appears.
  14. Change Title to Berkeley Fountains Analysis and click Save Map.

    Save Map as Berkeley Fountains Analysis

Determine if fountains are equitably distributed

Next, you'll analyze patterns in the distribution of fountains. You'll answer the question of whether there's a connection between fountain location or condition and the socioeconomic status of a community. In particular, you'll calculate the density of clean and dirty fountains and compare that density to the SVI layer.

  1. In the Contents pane, point to the Berkeley Fountains (Clean) layer and click the Perform Analysis button.

    Perform Analysis button

  2. Click Analyze Patterns and click Calculate Density.

    Calculate Density tool

    The Calculate Density tool opens. This tool creates a layer that shows the density of point features (such as your fountains layer) in a given area.

  3. For Choose point or line layer from which to calculate density, confirm that Berkeley Fountains (Clean) is chosen. For Use a count field, confirm that No count field is chosen.

    Calculate Density tool parameters

    You'll limit the extent of the layer that the tool creates so that it does not extend past the Berkeley city limits.

  4. Click Options. For Clip output to, choose Berkeley City Limits.

    Set Clip output to Berkeley City Limits

    You can also change the statistical method by which density is classified. By default, the result layer will display 10 different classes of density and each class will contain an equal interval of values. Ten classes is probably too many for your relatively small dataset. Additionally, it would make more sense to classify by standard deviation, so that you can better pinpoint areas that differ significantly from the average.

  5. For Classify by, choose Standard Deviation. For Number of classes, choose 5.

    Calculate Density tool options

  6. For Result layer name, add your name or initials to the end of the default name, Berkeley Fountains (Clean) Density.
  7. Click Run Analysis.

    After a few seconds, the new layer is created and added to the map. The darker purple areas are those with a higher density of clean fountains.

    Density of clean fountains in Berkeley, California

    Based on the highest-density areas, it does not seem that the location of clean fountains is related to the socioeconomic status of the census block. Clean fountains are found in both neighborhoods with a high SVI (darker blue census tracts) and neighborhoods with a low SVI (light green or yellow census tracts).

    The high density of clean fountains in the westernmost census block may be due to its location in the Berkeley Marina, a tourist and recreational area. While your analysis doesn't indicate an inequitable distribution of clean fountains, it still highlights areas where access to clean fountains is lacking.

    Next, you'll repeat the density analysis for dirty fountains.

  8. In the Contents pane, uncheck the Berkeley Fountains (Clean) Density layer. Point to the Berkeley Fountains (Dirty) layer and click the Perform Analysis button.
  9. Expand Analyze Patterns and click Calculate Density.
  10. For Choose point or line layer from which to calculate density, confirm that Berkeley Fountains (Dirty) is chosen. For Use a count field, confirm that No count field is chosen.
  11. Expand Options. For Clip output to, choose Berkeley City Limits.
  12. Change Classify by to Standard Deviation and change Number of classes to 5.
  13. For Result layer name, add your name or initials to the end of the default name, Berkeley Fountains (Dirty) Density. Click Run Analysis.

    After a few seconds, the new layer is added to the map.

    Density of dirty fountains in Berkeley, California

    There are two areas with high densities of dirty fountains. The first is in the Berkeley Marina, and likely affects tourism more than residential conditions. The second is in the center of the city, bridging four census blocks with a wide range of SVIs.

    As with clean fountains, it does not seem as though the condition of drinking fountains corresponds with the socioeconomic status of the area. However, that does not mean that your analysis didn't have value. By determining areas with the highest density of dirty fountains, you pinpoint locations that the city can target to improve fountain conditions.

  14. Save the map.

In these lessons, you created an editable feature layer that users can use to collect information about drinking water fountains in Berkeley, California. You then analyzed the condition of drinking fountains and compared the results to the social vulnerability of the area.

Ultimately, you were not able to conclude that clean or dirty fountains are distributed inequitably across the city. However, your results indicated areas where fountains could be cleaned up or more fountains could be added to increase equitable access to fountains.

You can find more lessons in the Learn ArcGIS Lesson Gallery.