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

The tutorial can be completed with a sample dataset (provided via a Google Drive link within the document) or with your own time-series data from multiple field sites.

Part 1 covers how to make interactive graphs in Google Data Studio and Part 2 covers how to link data pages to an interactive map with ArcGIS Online. The tutorial will take 1-2 hours to complete.

An example interactive map and data portal can be found at: https://temple.maps.arcgis.com/apps/View/index.html?appid=a259e4ec88c94ddfbf3528dc8a5d77e8

Use the Chart Viewer template to display bar charts, line charts, pie charts, histograms, and scatterplots to complement a map. Include multiple charts to view with a map or side by side with other charts for comparison. Up to three charts can be viewed side by side or stacked, but you can access and view all the charts that are authored in the map. Examples: Present a bar chart representing average property value by county for a given area. Compare charts based on multiple population statistics in your dataset. Display an interactive scatterplot based on two values in your dataset along with an essential set of map exploration tools. Data requirements The Chart Viewer template requires a map with at least one chart configured. Key app capabilities Multiple layout options - Choose Stack to display charts stacked with the map, or choose Side by side to display charts side by side with the map. Manage chart - Reorder, rename, or turn charts on and off in the app. Multiselect chart - Compare two charts in the panel at the same time. Bookmarks - Allow users to zoom and pan to a collection of preset extents that are saved in the map. Home, Zoom controls, Legend, Layer List, Search Supportability This web app is designed responsively to be used in browsers on desktops, mobile phones, and tablets. We are committed to ongoing efforts towards making our apps as accessible as possible. Please feel free to leave a comment on how we can improve the accessibility of our apps for those who use assistive technologies.

Check out the Year to Date Dashboard or the Year End Dashboard for this dataset. You can also use the data download tool to choose the topic of interest (i.e. arrests), the geography level (i.e. police district), and time frame to export as a csv or json dataset.View metadata for key information about this dataset.Philadelphia’s District Attorney’s Office (DAO) releases interactive data reports on the their work, including incidents (from the Philadelphia Police Department), arrests, charges, bail, outcomes, case length, future years of incarceration, future years of supervision, summary arrests, summary charges, summary case outcomes, and summary case lengths. Dashboards are organized into final year-end data (updated at the end of each year) and year-to-date data (updated daily). Each dashboard displays one or more interactive graphs showing trends, a table of data, and, optionally, an interactive map displaying the data by police districts. The dashboard does not provide for downloading data.See this data at different boundary levels:SUM_CASE_OUTCOMES_CENSUSSUM_CASE_OUTCOMES_PDSUM_CASE_OUTCOMES_ZIPCODEFor questions about this dataset, contact nathaniel.lownes@phila.gov. For technical assistance, email maps@phila.gov.

This project aims to identify areas in Los Angeles that are at high risk of crime in the future and to propose optimal locations for new police stations in those areas. By applying machine learning to post-COVID-19 crime data and various socioeconomic indicators, we predict crime risk at the ZIP Code level. Using a location-allocation model, we then determine suitable locations for new police stations to improve coverage of high-risk zones. The results of our analysis can support the efficient allocation of public safety resources in response to growing demand and budget constraints, helping city officials optimize law enforcement services. The content of the archive- Jupyter Notebook- Data (GeoJSON, CSV)- Summary report PDF FileThe platform on which the notebook should be run.This notebook is designed to run on Datahub.Project materials - Project Material we created on AGOL 1 Los Angeles Crime Hotspothttps://ucsdonline.maps.arcgis.com/home/item.html?id=4bddbae65c164f2d9b0285e09cb2820e 2 Choropleth Map of Predicted Crime Levels by ZIP Codehttps://ucsdonline.maps.arcgis.com/home/item.html?id=e47abb448f0a411ab77c6ac754ba0c34 3. Optimizing LA Police Station: A Location Allocation Analysishttps://ucsdonline.maps.arcgis.com/home/item.html?id=2409da85c3fe410e9578a0eaaed8471e - ArcGIS StoryMaphttps://ucsdonline.maps.arcgis.com/home/item.html?id=cfbd4fc27a3b400296e4e31555951d27 Software dependencies - pandas: Used for loading, formatting, and performing matrix operations on tabular data.- geopandas: Used for loading and processing spatial data, including spatial joins and coordinate transformations.- shapely.geometry.Point: Used to create spatial point objects from latitude and longitude coordinates.- arcgis.gis, arcgis.features, arcgis.geometry, arcgis.geoenrichment: Used to retrieve and manipulate geographic data from ArcGIS Online and to extract population statistics using the GeoEnrichment module.- numpy: Used for feature matrix formatting and numerical computations prior to model training.- IPython.display (display, Markdown, Image): Used to format and display Markdown text, data tables, and images within Jupyter Notebooks.- scikit-learn: Used for building and evaluating machine learning models. Specifically, it was used for data preprocessing (StandardScaler), splitting data (train_test_split), model selection and tuning (GridSearchCV, cross_val_score), training various regressors (e.g.,LinearRegression, RandomForestRegressor, KNeighborsRegressor), and assessing performance using metrics such as R², RMSE, and MAE.Other Components we used - ArcGIS Online: Used to create and host interactive web maps for spatial visualization and public presentation purposes.- Flourish: Used to create interactive graphs and charts for visualizing trends and supporting the analysis.

An ArcGIS Blog tutorial that guides you through creating your first dashboard using ArcGIS Dashboards.ArcGIS Dashboards is a configurable web app available in ArcGIS Online that enables users to convey information by presenting interactive charts, gauges, maps, and other visual elements that work together on a single screen.In this tutorial you will create a simple dashboard using ArcGIS Dashboards. The dashboard uses a map of medical facilities in Los Angeles County (sample data only) and includes interactive chart and list elements._Communities around the world are taking strides in mitigating the threat that COVID-19 (coronavirus) poses. Geography and location analysis have a crucial role in better understanding this evolving pandemic.When you need help quickly, Esri can provide data, software, configurable applications, and technical support for your emergency GIS operations. Use GIS to rapidly access and visualize mission-critical information. Get the information you need quickly, in a way that’s easy to understand, to make better decisions during a crisis.Esri’s Disaster Response Program (DRP) assists with disasters worldwide as part of our corporate citizenship. We support response and relief efforts with GIS technology and expertise.More information...

The interactive charts, created for 33N, displays trends in total, opioid, and prescription opioid overdose death rates for each of the 10 counties in the ARC planning area, the planing areas as a whole, and State of Georgia from 1999 to 2016. In Georgia in 2016, their were 996 overdose deaths caused by opioids, representing 68.8% of all drug overdose deaths in the state and a 61% increase since 2013. Of the overdose deaths statewide in 2016, 595 involved prescription opioids, a more than tenfold increase since 1999. The 10-county Atlanta metro region reports higher prescription opioid overdose rates in most years than the state as a whole, but has followed a similar trend to the state, with the problem of prescription opioid overdose deaths increasing over time. Since 1999 in the 10-county Atlanta metro region, the number of prescription opioid overdose deaths has increased at more than 5 times the rate of deaths overall, at 2.5 times the rate of overdose deaths, and at more than 1.5 times the rate of all opioid overdose deaths.Data Source:Georgia Department of Public Health (GA DPH), OASIS, Mortality/Morbidity Data, 1999-2016

Check out the Year to Date Dashboard or the Year End Dashboard for this dataset. You can also use the data download tool to choose the topic of interest (i.e. arrests), the geography level (i.e. police district), and time frame to export as a csv or json dataset.View metadata for key information about this dataset.Philadelphia’s District Attorney’s Office (DAO) releases interactive data reports on the their work, including incidents (from the Philadelphia Police Department), arrests, charges, bail, outcomes, case length, future years of incarceration, future years of supervision, summary arrests, summary charges, summary case outcomes, and summary case lengths. Dashboards are organized into final year-end data (updated at the end of each year) and year-to-date data (updated daily). Each dashboard displays one or more interactive graphs showing trends, a table of data, and, optionally, an interactive map displaying the data by police districts. The dashboard does not provide for downloading data.See this data at different boundary levels:SUM_CASE_OUTCOMES_CENSUSSUM_CASE_OUTCOMES_CITYWIDESUM_CASE_OUTCOMES_PDFor questions about this dataset, contact nathaniel.lownes@phila.gov. For technical assistance, email maps@phila.gov.

Check out the Year to Date Dashboard or the Year End Dashboard for this dataset. You can also use the data download tool to choose the topic of interest (i.e. arrests), the geography level (i.e. police district), and time frame to export as a csv or json dataset.View metadata for key information about this dataset.Philadelphia’s District Attorney’s Office (DAO) releases interactive data reports on the their work, including incidents (from the Philadelphia Police Department), arrests, charges, bail, outcomes, case length, future years of incarceration, future years of supervision, summary arrests, summary charges, summary case outcomes, and summary case lengths. Dashboards are organized into final year-end data (updated at the end of each year) and year-to-date data (updated daily). Each dashboard displays one or more interactive graphs showing trends, a table of data, and, optionally, an interactive map displaying the data by police districts. The dashboard does not provide for downloading data.See this data at different boundary levels:FUTURE_SUPERVISION_CENSUSFUTURE_SUPERVISION_CITYWIDEFUTURE_SUPERVISION_PDFor questions about this dataset, contact nathaniel.lownes@phila.gov. For technical assistance, email maps@phila.gov.

This map supports an interactive app of transect locations with static graphs of the change in cross sectional profile in years 2010, 2014, 2016, and 2021. The layers displayed on this map include base imagery from 2010, a polygon showing the channel extent from 2021, and the locations of the four transects. The user is able to navigate to each of the locations using the app, and the graphs showing the cross section updates according the the location shown. This item supports the 2022 StoryMap Habitat Changes in the Tijuana River Valley, which can be found here: https://storymaps.arcgis.com/collections/bf7945934d4e4dd1a9259fde1e1f6e22

Check out the Year to Date Dashboard or the Year End Dashboard for this dataset. You can also use the data download tool to choose the topic of interest (i.e. arrests), the geography level (i.e. police district), and time frame to export as a csv or json dataset.View metadata for key information about this dataset.Philadelphia’s District Attorney’s Office (DAO) releases interactive data reports on the their work, including incidents (from the Philadelphia Police Department), arrests, charges, bail, outcomes, case length, future years of incarceration, future years of supervision, summary arrests, summary charges, summary case outcomes, and summary case lengths. Dashboards are organized into final year-end data (updated at the end of each year) and year-to-date data (updated daily). Each dashboard displays one or more interactive graphs showing trends, a table of data, and, optionally, an interactive map displaying the data by police districts. The dashboard does not provide for downloading data.See this data at different boundary levels:CASE_OUTCOMES_CITYWIDECASE_OUTCOMES_PDCASE_OUTCOMES_ZIPCODEFor questions about this dataset, contact nathaniel.lownes@phila.gov. For technical assistance, email maps@phila.gov.

Check out the Year to Date Dashboard or the Year End Dashboard for this dataset. You can also use the data download tool to choose the topic of interest (i.e. arrests), the geography level (i.e. police district), and time frame to export as a csv or json dataset.View metadata for key information about this dataset.Philadelphia’s District Attorney’s Office (DAO) releases interactive data reports on the their work, including incidents (from the Philadelphia Police Department), arrests, charges, bail, outcomes, case length, future years of incarceration, future years of supervision, summary arrests, summary charges, summary case outcomes, and summary case lengths. Dashboards are organized into final year-end data (updated at the end of each year) and year-to-date data (updated daily). Each dashboard displays one or more interactive graphs showing trends, a table of data, and, optionally, an interactive map displaying the data by police districts. The dashboard does not provide for downloading data.See this data at different boundary levels:SUM_CHARGES_CENSUSSUM_CHARGES_PDSUM_CHARGES_ZIPCODEFor questions about this dataset, contact nathaniel.lownes@phila.gov. For technical assistance, email maps@phila.gov.

Check out the Year to Date Dashboard or the Year End Dashboard for this dataset. You can also use the data download tool to choose the topic of interest (i.e. arrests), the geography level (i.e. police district), and time frame to export as a csv or json dataset.View metadata for key information about this dataset.Philadelphia’s District Attorney’s Office (DAO) releases interactive data reports on the their work, including incidents (from the Philadelphia Police Department), arrests, charges, bail, outcomes, case length, future years of incarceration, future years of supervision, summary arrests, summary charges, summary case outcomes, and summary case lengths. Dashboards are organized into final year-end data (updated at the end of each year) and year-to-date data (updated daily). Each dashboard displays one or more interactive graphs showing trends, a table of data, and, optionally, an interactive map displaying the data by police districts. The dashboard does not provide for downloading data.See this data at different boundary levels:CASE_LENGTH_CITYWIDECASE_LENGTH_PDCASE_LENGTH_ZIPCODEFor questions about this dataset, contact nathaniel.lownes@phila.gov. For technical assistance, email maps@phila.gov.

Check out the Year to Date Dashboard or the Year End Dashboard for this dataset. You can also use the data download tool to choose the topic of interest (i.e. arrests), the geography level (i.e. police district), and time frame to export as a csv or json dataset.View metadata for key information about this dataset.Philadelphia’s District Attorney’s Office (DAO) releases interactive data reports on the their work, including incidents (from the Philadelphia Police Department), arrests, charges, bail, outcomes, case length, future years of incarceration, future years of supervision, summary arrests, summary charges, summary case outcomes, and summary case lengths. Dashboards are organized into final year-end data (updated at the end of each year) and year-to-date data (updated daily). Each dashboard displays one or more interactive graphs showing trends, a table of data, and, optionally, an interactive map displaying the data by police districts. The dashboard does not provide for downloading data.See this data at different boundary levels:FUTURE_INCARCERATION_CENSUSFUTURE_INCARCERATION_CITYWIDEFUTURE_INCARCERATION_PDFor questions about this dataset, contact nathaniel.lownes@phila.gov. For technical assistance, email maps@phila.gov.

Check out the Year to Date Dashboard or the Year End Dashboard for this dataset. You can also use the data download tool to choose the topic of interest (i.e. arrests), the geography level (i.e. police district), and time frame to export as a csv or json dataset.View metadata for key information about this dataset.Philadelphia’s District Attorney’s Office (DAO) releases interactive data reports on the their work, including incidents (from the Philadelphia Police Department), arrests, charges, bail, outcomes, case length, future years of incarceration, future years of supervision, summary arrests, summary charges, summary case outcomes, and summary case lengths. Dashboards are organized into final year-end data (updated at the end of each year) and year-to-date data (updated daily). Each dashboard displays one or more interactive graphs showing trends, a table of data, and, optionally, an interactive map displaying the data by police districts. The dashboard does not provide for downloading data.See this data at different boundary levels:FUTURE_SUPERVISION_CITYWIDEFUTURE_SUPERVISION_PDFUTURE_SUPERVISION_ZIPCODEFor questions about this dataset, contact nathaniel.lownes@phila.gov. For technical assistance, email maps@phila.gov.

Check out the Year to Date Dashboard or the Year End Dashboard for this dataset. You can also use the data download tool to choose the topic of interest (i.e. arrests), the geography level (i.e. police district), and time frame to export as a csv or json dataset.View metadata for key information about this dataset.Philadelphia’s District Attorney’s Office (DAO) releases interactive data reports on the their work, including incidents (from the Philadelphia Police Department), arrests, charges, bail, outcomes, case length, future years of incarceration, future years of supervision, summary arrests, summary charges, summary case outcomes, and summary case lengths. Dashboards are organized into final year-end data (updated at the end of each year) and year-to-date data (updated daily). Each dashboard displays one or more interactive graphs showing trends, a table of data, and, optionally, an interactive map displaying the data by police districts. The dashboard does not provide for downloading data.See this data at different boundary levels:CASE_LENGTH_CENSUSCASE_LENGTH_CITYWIDECASE_LENGTH_PDFor questions about this dataset, contact nathaniel.lownes@phila.gov. For technical assistance, email maps@phila.gov.

Check out the Year to Date Dashboard or the Year End Dashboard for this dataset. You can also use the data download tool to choose the topic of interest (i.e. arrests), the geography level (i.e. police district), and time frame to export as a csv or json dataset.View metadata for key information about this dataset.Philadelphia’s District Attorney’s Office (DAO) releases interactive data reports on the their work, including incidents (from the Philadelphia Police Department), arrests, charges, bail, outcomes, case length, future years of incarceration, future years of supervision, summary arrests, summary charges, summary case outcomes, and summary case lengths. Dashboards are organized into final year-end data (updated at the end of each year) and year-to-date data (updated daily). Each dashboard displays one or more interactive graphs showing trends, a table of data, and, optionally, an interactive map displaying the data by police districts. The dashboard does not provide for downloading data.See this data at different boundary levels:FUTURE_SUPERVISION_CENSUSFUTURE_SUPERVISION_PDFUTURE_SUPERVISION_ZIPCODEFor questions about this dataset, contact nathaniel.lownes@phila.gov. For technical assistance, email maps@phila.gov.

Check out the Year to Date Dashboard or the Year End Dashboard for this dataset. You can also use the data download tool to choose the topic of interest (i.e. arrests), the geography level (i.e. police district), and time frame to export as a csv or json dataset.View metadata for key information about this dataset.Philadelphia’s District Attorney’s Office (DAO) releases interactive data reports on the their work, including incidents (from the Philadelphia Police Department), arrests, charges, bail, outcomes, case length, future years of incarceration, future years of supervision, summary arrests, summary charges, summary case outcomes, and summary case lengths. Dashboards are organized into final year-end data (updated at the end of each year) and year-to-date data (updated daily). Each dashboard displays one or more interactive graphs showing trends, a table of data, and, optionally, an interactive map displaying the data by police districts. The dashboard does not provide for downloading data.See this data at different boundary levels:FUTURE_INCARCERATION_CENSUSFUTURE_INCARCERATION_PDFUTURE_INCARCERATION_ZIPCODEFor questions about this dataset, contact nathaniel.lownes@phila.gov. For technical assistance, email maps@phila.gov.

Check out the Year to Date Dashboard or the Year End Dashboard for this dataset. You can also use the data download tool to choose the topic of interest (i.e. arrests), the geography level (i.e. police district), and time frame to export as a csv or json dataset.View metadata for key information about this dataset.Philadelphia’s District Attorney’s Office (DAO) releases interactive data reports on the their work, including incidents (from the Philadelphia Police Department), arrests, charges, bail, outcomes, case length, future years of incarceration, future years of supervision, summary arrests, summary charges, summary case outcomes, and summary case lengths. Dashboards are organized into final year-end data (updated at the end of each year) and year-to-date data (updated daily). Each dashboard displays one or more interactive graphs showing trends, a table of data, and, optionally, an interactive map displaying the data by police districts. The dashboard does not provide for downloading data.See this data at different boundary levels:SUM_ARRESTS_CENSUSSUM_ARRESTS_CITYWIDESUM_ARRESTS_PDFor questions about this dataset, contact nathaniel.lownes@phila.gov. For technical assistance, email maps@phila.gov.

Check out the Year to Date Dashboard or the Year End Dashboard for this dataset. You can also use the data download tool to choose the topic of interest (i.e. arrests), the geography level (i.e. police district), and time frame to export as a csv or json dataset.View metadata for key information about this dataset.Philadelphia’s District Attorney’s Office (DAO) releases interactive data reports on the their work, including incidents (from the Philadelphia Police Department), arrests, charges, bail, outcomes, case length, future years of incarceration, future years of supervision, summary arrests, summary charges, summary case outcomes, and summary case lengths. Dashboards are organized into final year-end data (updated at the end of each year) and year-to-date data (updated daily). Each dashboard displays one or more interactive graphs showing trends, a table of data, and, optionally, an interactive map displaying the data by police districts. The dashboard does not provide for downloading data.See this data at different boundary levels:SUM_ARRESTS_CENSUSSUM_ARRESTS_CITYWIDESUM_ARRESTS_ZIPCODEFor questions about this dataset, contact nathaniel.lownes@phila.gov. For technical assistance, email maps@phila.gov.

Check out the Year to Date Dashboard or the Year End Dashboard for this dataset. You can also use the data download tool to choose the topic of interest (i.e. arrests), the geography level (i.e. police district), and time frame to export as a csv or json dataset.View metadata for key information about this dataset.Philadelphia’s District Attorney’s Office (DAO) releases interactive data reports on the their work, including incidents (from the Philadelphia Police Department), arrests, charges, bail, outcomes, case length, future years of incarceration, future years of supervision, summary arrests, summary charges, summary case outcomes, and summary case lengths. Dashboards are organized into final year-end data (updated at the end of each year) and year-to-date data (updated daily). Each dashboard displays one or more interactive graphs showing trends, a table of data, and, optionally, an interactive map displaying the data by police districts. The dashboard does not provide for downloading data.See this data at different boundary levels:BAIL_CENSUSBAIL_CITYWIDEBAIL_PDFor questions about this dataset, contact nathaniel.lownes@phila.gov. For technical assistance, email maps@phila.gov.