topic Re: Multiple features (e.g., sampling events) represented by one point? in ArcGIS Online Questions

Multiple features (e.g., sampling events) represented by one point?

deleted-user-LNABNwA5CZcD — Fri, 09 Feb 2018 05:23:03 GMT

I've looked probably too hard at this point but am sure there must be an easy way to do this.

I do a lot of sampling. Our sampling locations are the same. What I would like to display in ArcGIS Online (be it a map or Web App) is a single point where you can click, and in the pop-up is a table of past results for the site.

It's almost like collector, but I want to see the history displayed, too. Let me know if you have any questions. Thanks!

Re: Multiple features (e.g., sampling events) represented by one point?

KellyGerrow — Tue, 20 Feb 2018 23:33:46 GMT

Hi Sam,

You can approach this one of two ways.

1. create a field for each sample date so the data is stored as multiple attributes for a given dataset.

2. If you have multiple fields that need to added for each dataset, try using related records to record the sample and relate the tables to a single location.

Create Relationship Class—Data Management toolbox | ArcGIS Desktop

Pop-ups can be constructed to display the values in related tables from one location:

Configure pop-ups—ArcGIS Online Help | ArcGIS

-Kelly

Re: Multiple features (e.g., sampling events) represented by one point?

deleted-user-LNABNwA5CZcD — Wed, 21 Feb 2018 21:35:11 GMT

Kelly, I'd really rather not create additional fields with each sampling. I'd like to be able to simply fill out a form for each sampling site/event and have it populate a table like this:

Site	Date	Nitrogen (mg/L)	Phosphorous (mg/L)
1T	1/1/18	0.2	0.1
2T	1/1/18	0.4	0.35
1T	2/1/18	0.15	0.4
2T	2/1/18	0.3	0.7
1T	3/1/18	0.6	1.0
2T	3/1/18	1.1	1.5

The map would have a single point for 1T and for 2T. Upon clicking, a pop-up would show something like the above table or perhaps even a chart of change over time.

My ideal is to manage data in a Google Spreadsheet, then have the sampling events at least listed (and perhaps charted or statistically summarized) in a single pop-up (rather than clicking through the pop-up windows for each event/feature).

One point, one pop-up compiling multiple features with a common site name.

Let me know if there are any other questions. I feel like this must exist somewhere somehow and I'm missing it.

I thought of another way to say it after playing with clustering, which I figured might be a pathway to a solution but does not appear to be (yet). Let's say this was achievable through clustering. When clicking on a cluster point that might have clustered three points, I want the pop-up to list out (ideally in a table and/or chart, but I'm open to other options) all the fields for all the features (same Site, multiple sampling events). I might also want summary info (e.g., average), too, but we'll really want to see how data changes over time.

Re: Multiple features (e.g., sampling events) represented by one point?

KellyGerrow — Thu, 22 Feb 2018 23:17:55 GMT

Thanks Sam,

Check out using related records (Option 2 above). This should accomplish what you are looking to do.

This web map should have a similar data structure to what you have described:

http://arcg.is/1zy1mz

Try clicking at the B13-9193 station for an item with corresponding related records

-Kelly