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 and functioning. You'll acquire this information through ArcGIS Field Maps, 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 Field Maps. 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 New item.

    New item button

  4. In the New item window, click Feature layer.

    Feature layer

    The Create a feature layer window appears.

  5. Under Select an option to create a feature layer, click Create a blank layer and click Next.

    Build a layer option

    You're prompted to specify the name and type of the feature layer. You can create a point, line, or polygon feature layer. Drinking fountains are best displayed as points.

  6. For name, delete the existing text, type Fountains, followed by your name or initials (for example Fountains (Your Name)). For the type, confirm that Point layer is selected.

    Note:

    You cannot create two layers in an ArcGIS organization with the same name. Adding your initials to a layer name ensures that other people in your organization can also complete this lesson. Once a layer has been created, you can rename it in the map to remove your initials, which will not affect the name of the underlying data layer.

    Point layer

    You can also enable other options, such as GPS metadata fields and Z-values (3D). You won't need either of these options, so you'll leave them unchecked.

  7. Click Next.

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

  8. For Title, type Berkeley Fountains, followed by your name or initials (for example Berkeley Fountains (Your Name)).
    Note:

    You cannot create two layers in an ArcGIS organization with the same name. Adding your initials to a layer name ensures that other people in your organization can also complete this lesson. Once a layer has been created, you can rename it in the map to remove your initials, which will not affect the name of the underlying data layer.

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

    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 functioning and 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 clean or dirty.

  1. On the items 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. The Photos And Files field 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 by not allowing empty or null values.

  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 a field to track whether the fountain is clean or dirty.

  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 and click Add. 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 Field Maps.

  1. On the ribbon, click the Overview tab.

    Overview tab

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

    Add to Map Viewer Classic with full editing control option

    The layer is added to a new map. The layer currently has no data, so no features appear on the map. That's fine; later, you'll add features using ArcGIS Field Maps.

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

    Location of San Francisco in the United States

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

    Location of Berkeley

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

    Save As option

    The Save Map window appears.

  6. In the Save Map window, set the following parameters:

    • 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.

    Save map window

  7. Click Save Map.

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

    For the purposes of this lesson, you created this map, so you'll be able to access it in ArcGIS Field Maps. However, in a real-world scenario you may have multiple users collecting data who need to have access to a map. To share a map with other users, you need to create a group. (See the following note.)

    Note:

    In a real-world scenario, your organization or teacher may have already created a group for sharing 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 has already been made. You will only be able to share content with a group if you are a member of the group.

  8. 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.

  9. Click Create group.

    Create group button

    The Create a group window appears.

  10. In the Create a group window, under Group overview, set the following parameters:

    • For 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.

    Group overview

    You'll also limit who can view the group.

  11. Under Group membership, for Who can view this group, choose Only group members.

    Choosing this option limits who can join the group. Users can only become members of the group if you invite them.

  12. Click Save.

    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.

  13. 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.

  14. 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

  15. Click Share.

    Share button

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

    Edit group sharing

  17. Check the Berkeley Fountains group and click OK.
  18. Click Save.

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

Collect data on a mobile device

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

  1. Open ArcGIS Field Maps on either your Android or iOS mobile device.
    Note:

    If you don't have ArcGIS Field Maps, you can download it for free as a mobile app from the App Store or Google Play.

  2. Click Sign In with ArcGIS Online or Sign In with ArcGIS Enterprise. Sign in with your ArcGIS account credentials.

    After you sign in, the maps list appears. These are all the maps that have editable data to which you have access.

    Note:

    Depending on the device you use to access Field Maps, 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 Field Maps 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 whether everything was set up correctly, 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 blue 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 change the location by dragging the point on the map.)

    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. Click Add Point.
    Note:

    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

    Now 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. (You may have to scroll up.)
  8. Scroll up on 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 Field Maps access to your mobile device's camera. Tap OK to allow.

  10. Tap Submit.

    Submit button

    The fountain's data has been 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 Classic.
    Note:

    If the Open map window appears, telling you the current map has unsaved changes, click Yes, open the map.

    Map Viewer Classic opens to the City of Berkeley.

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

    Depending on where you added your point, it may not appear in the map's default extent. To navigate quickly, you can search for the location in the search bar.

    The fountain point is displayed as a red circle.

  13. Click the fountain point.

    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 attribute table.

  14. Close the pop-up. Close the web map without saving, or leave it open if you intend to continue the lesson.

In this section, 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 Field Maps, 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 module, you'll use the results those users collected to determine whether fountains (and by extension, access to clean drinking water) are distributed equitably across the city.


Analyze fountain distribution

Previously, you collected information about the location and condition of public drinking fountains in Berkeley, California. Next, 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 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 tracts have more dirty fountains than others? Are differences in the number of dirty fountains related to the social vulnerability of the census tract?

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 actual 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. If you closed your Berkeley Fountains web map in the previous section, open it in Map Viewer Classic. If your map is still open from the previous section, navigate back to Berkeley, California.
  2. Click the fountain point you added. In the pop-up, click Edit. and Delete.

    Edit the fountain point.

    The Berkeley Fountains pop-up appears.

  3. In the Berkeley Fountains pop up, click Delete.
  4. 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.

  5. Click Search for layers, type CDC 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. Read more about SVI.

  6. In the search results, identify the most recently available CDC Social Vulnerability Index layer by data_cdc and click the Add button.

    Add button

  7. 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 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.

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

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

  9. 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

  10. 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.

  11. Replace the existing search text with Berkeley Fountains owner:Learn_ArcGIS and press Enter.
  12. Add the Berkeley Fountains (Clean) and Berkeley Fountains (Dirty) layers.
  13. 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.

  14. Save the map.

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 social vulnerability 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. Expand 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. Uncheck Use current map extent.
    Note:

    You cannot create two layers in an ArcGIS organization with the same name. Adding your initials to a layer name ensures that other people in your organization can also complete this lesson. Once a layer has been created, you can rename it in the map to remove your initials, which will not affect the name of the underlying data layer.

  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 social vulnerability status of the census tract. 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 social vulnerability 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 this lesson, you created an editable feature layer that users can use in Field Maps 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.

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.