I have an AGOL hosted view of Covid-19 case data that includes a zipcode polygon layer with a one to many join to a patient data table. This hosted view was created using the AGOL Analysis, Summarize Data, Join Features tool. The patient data table has one row for each patient and a field for their ZIPCode.
https://services.arcgis.com/iCGWaR7ZHc5saRIl/arcgis/rest/services/Join_PatientZip_to_ZipCodes_Centro...
I'd like to tally how many cases are in each ZIPCode polygon and add this to a webmap. The data changes daily, so I'd like to do this as a view, not as a static layer.
I can successfully return summary numbers in the REST API Query as shown below. The question is, how do I translate this into a URL string I can add as a data source to a webmap, where each zip code polygon has a count of total cases?
![](/legacyfs/online/493500_pastedImage_6.png)
It seems like I should be able to append a URL string to the REST endpoint given above (yes?). Something along the lines of:
&groupByFieldsForStatistics="zipcode_text"&outStatistics="somethingelse" Apparently I don't know how to construct the "somethingelse" portion of the string properly.
Is this the right approach?
Thanks,
Jay
Jay
Washoe County GIS