How to create an interactive data portal
Part 2: ArcGIS Online
This tutorial will teach you how to take time-series data from many
field sites and create a shareable online map, where clicking on a field
location brings you to a page with interactive graph(s). Part 2 covers
how to link data pages to an interactive map with ArcGIS Online.
How to cite:
Beganskas, S. (2020). Tutorial: How to use Google Data Studio and ArcGIS Online to create an
1 interactive data portal, HydroShare, DOI: 10.4211/hs.9edae0ef99224e0b85303c6d45797d56
What you need to get started
Whether you are working with your own data or the example dataset,
for Part 2 you will need:
1. Links to web pages with data, preferably with a distinct page for each
field site (generated in Part 1 of this tutorial)
2. Latitude and longitude for each field site ([Link])
3. A Google account and an ArcGIS Online account. If ArcGIS is available
through your organization, you likely have an account (see next slide)
2
Step 1: Sign into your ArcGIS Online account
Go to [Link] and click Sign in.
Choose “Your ArcGIS organization’s URL”.
Type the name of your organization.
e.g., temple for Temple University
Click Continue and sign in using your
credentials.
3
Step 2: Create a Sheet with data for all sites
Go to [Link] and create a new Google Sheets document.
Click here
4
Step 2: Create a Sheet with data for all sites
Give the Sheet a name. For this tutorial, you can directly copy and paste data
from [Link] into the new Sheets document.
If you are using your own data, enter each site’s name, longitude, and latitude.
Then include any other data, followed by an empty column titled View data.
5
Step 2: Create a Sheet with data for all sites
If you are using Google Data Studio reports, 3. Click Copy and then Save.
set sharing settings and copy the link
If you do not click Save, the sharing
for each site. settings will not take effect.
1. Click Share in the upper right.
2. Click Manage access.
Then choose the most
appropriate sharing settings.
Check the Disable downloading…
box to prevent others from 4. Paste this link into the
downloading your data. “View data” column for this
site. Repeat for every site.
6
Step 2: Create a Sheet with data for all sites
Now your Sheet should look something like this:
7
Step 3: Link the Sheet to a map interface
Click on File -> Publish to the web
Under the Link tab, select
Comma-separated
values (.csv). Then click Copy and save the link,
Publish and OK. we’ll need it in a minute!
8
Step 3: Link the Sheet to a map interface
In ArcGIS Online, click Map on the top of the page to create a new map.
Click Add.
9
Step 3: Link the Sheet to a map interface
1. Choose Add 2. Select CSV file from the drop-down menu. Then paste
Layer from Web. the link you saved from a few slides back. Click Add Layer.
3. Save the map by clicking Save.
Step 4: Format the map
Under Change
Style on the Left,
select Site as the
attribute to show.
Up to you if you
want the same or
different symbols
for each site.
Then click Done.
11
Step 4: Format the map
Add site name labels to
each point:
Click the three dots
under layer pub. The
click Create Labels.
There are many other
display options to play with.
You can also add other
shapefiles by clicking
Add -> Add layer from File.
Don’t forget to Save!
12
Step 4: Format the map
Note that when
you click on a
point, a pop-up
window appears.
Clicking on the
More info link will
bring you to the
page you created
for that site.
13
Step 5: Share the map
When you are happy with how the map
looks, click Share.
In the Share window, check the
appropriate boxes to decide who can view
the map.
From here, you can share the map using
the link provided here, by embedding it in
a website, or by creating a Web App.
14
Step 5: Share the map
Creating a Web App is easy and
a great way to share your map
and data.
After you Click Create a Web App
from the Sharing window:
Click Showcase a Map,
then Basic Viewer,
then Create Web Map,
then Done.
Share the Web App by copying
the link at the top of the page.
15
Wrapping up
This tutorial just covers the basics! Google Data Studio and ArcGIS Online
have many additional capabilities, and there are resources available online for
how to use specific tools not covered here.
For an example interactive map and data portal for a citizen science project,
go to [Link] or click the button below:
Example data portal
This project is led by Temple University and funded by the William Penn Foundation.
16