topic Creating a visual representation tied with multiple data points tied to one geographic value in ArcGIS Online Questions

Creating a visual representation tied with multiple data points tied to one geographic value

MayaAlmoussa — Thu, 30 Jan 2025 01:50:27 GMT

Hi all! I want to create multiple data points over time on a map (like Sliding Timer Effect). One of the columns in the data table has location "codes" that correspond to a specific location on the map. The other columns are "Percent illness" for the years 2017, 2018, 2019 and "Years" . Each location code corresponds to a "percent illness" and "Year" value from 2017, 2018, 2019. How can I tie data points from percent illness 2017 to the Year 2017, and then to the location code, data points from percent illness 2018 to Year 2018 and to the location codes, etc, then visualize changes over time? . For example: How can I create an animation on a map that shows the change from 52% in 2017 to 32% in 2018 in Location 1 (and the other locations simultaneously)?

Location code	Percent Illness 2017	Year	Percent Illness 2018	Year
1	52%	2017	32%	2018
2	45%	2017	47%	2018
3	63%	2017	75%	2018

Re: Creating a visual representation tied with multiple data points tied to one geographic value

DavidPike — Thu, 30 Jan 2025 13:10:16 GMT

It's not in quite the right format to be time-enabled yet.

Each year and location/area will need its own row in the table. as below.

Something like Transpose Fields https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/transpose-fields.htm or wrangle it in Excel, Pandas etc.

You'll also need to join a geometry or X and Y to each location field.

Location Code Year Percent Illness

1	2017	52%
1	2018	32%
2	2017	45%
2	2018	47%
3	2017	63%
3	2018	75%

Re: Creating a visual representation tied with multiple data points tied to one geographic value

MayaAlmoussa — Thu, 30 Jan 2025 18:23:26 GMT

Thank you! I am going to try that!