Latest Contributions by SarahAmbrose

Hi Charlie Ware‌, You can complete a spatial join this this tool: arcgis.features.summarize_data module — arcgis 1.8.2 documentation  This is the one available in the map viewer in ArcGIS Online. You can read about the tool here: Join Features—ArcGIS Online Help | Documentation  Thanks, Sarah ... View more

Naomi Begg‌, The Join Features tool through GeoAnalytics Server is not available in ArcGIS Online. It is currently only available in ArcGIS Enterprise when you have a GeoAnalytics Server set up.  The Join Features tool that uses the Standard Analysis tools (same tools you see in Map Viewer in ArcGIS Online) is available. You can access it through the features.summarize_data module. It looks like for your operation you might want to complete the following workflow: 1. Join the survey table to the survey feature layers (one time operation) 2. Join the result from 1 (using a hosted view) to another layer. This step isn't through the features module - and will have to be done using an update to the service. There is a blog about this process here.  I hope that clarifies what's availble, Sarah ... View more

Hey Thomas Rutterford - you'll need to be the owner of both layers. See the documentation here: Join Features—ArcGIS Online Help | Documentation. Also make sure you are publishing the CSV as a hosted layer.  If that doesn't solve or clarify, please reach out to Esri technical support. They will be able to do a screen share and quickly troubleshoot the issue.  ... View more

Thanks Jan, sorry for the delay, we have the UC going on. At 10.8.1 there is a known issue that zookeeper always say "unknown" - even when it's fine. Since there might be a bit of back and forth on this - can you email the GeoAnalytics product engineer alias directly at geoanalytics-pes@esri.com?  The first two things I'll want to confirm are: 1. Can you successfully create a big data file share? I want to see if Spark starts up fir this task which is in a different toolbox. 2. What is shown when you check the health of spark? 3. Have you had any tool run, or has it been in this state since you deployed? Thanks, Sarah ... View more

Hi Jan Tschada‌, what version of Enterprise are you on?  Thanks, Sarah GeoAnalytics Product Engineer.  ... View more

Hey Jay Johnson , Sorry about that - focused on the technical part of your question (the query itself) and not the actual over-arching question. I do not expect that you would be able to add that to your map. When you summarize the data you now have a table - so there isn't really a geometry associated with it. You might be able to try joining the data to itself to calculate the count value in the tool (instead of the REST endpoint). - Sarah ... View more

Hi Jay Johnson , If you perform the query in REST (just like you did) - you just need to look at the URL that's generated. For example, I did the same thing you did and this was the resulting URL: https://services.arcgis.com/iCGWaR7ZHc5saRIl/ArcGIS/rest/services/Join_PatientZip_to_ZipCodes_Centroid/FeatureServer/0/query?where=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&resultType=none&distance=0.0&units=esriSRUnit_Meter&returnGeodetic=false&outFields=&returnGeometry=true&featureEncoding=esriDefault&multipatchOption=xyFootprint&maxAllowableOffset=&geometryPrecision=&outSR=&datumTransformation=&applyVCSProjection=false&returnIdsOnly=false&returnUniqueIdsOnly=false&returnCountOnly=false&returnExtentOnly=false&returnQueryGeometry=false&returnDistinctValues=false&cacheHint=false&orderByFields=&groupByFieldsForStatistics=zipcode_text&outStatistics=%5B%7B%22statisticType%22%3A%22count%22%2C%0D%0A%22onStatisticField%22%3A%22Case__%22%2C%0D%0A%22outStatisticsFieldName%22%3A%22Total%22%7D%5D&having=&resultOffset=&resultRecordCount=&returnZ=false&returnM=false&returnExceededLimitFeatures=true&quantizationParameters=&sqlFormat=none&f=html&token= So it's already done the work for you - and completed the query. I will also sometimes use a URL decode/encode. If you copy the URL I pasted above above in this first box here URL Decode and Encode - Online  and decode it, it will look like you expect: https://services.arcgis.com/iCGWaR7ZHc5saRIl/ArcGIS/rest/services/Join_PatientZip_to_ZipCodes_Centroid/FeatureServer/0/query?where=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&resultType=none&distance=0.0&units=esriSRUnit_Meter&returnGeodetic=false&outFields=&returnGeometry=true&featureEncoding=esriDefault&multipatchOption=xyFootprint&maxAllowableOffset=&geometryPrecision=&outSR=&datumTransformation=&applyVCSProjection=false&returnIdsOnly=false&returnUniqueIdsOnly=false&returnCountOnly=false&returnExtentOnly=false&returnQueryGeometry=false&returnDistinctValues=false&cacheHint=false&orderByFields=&groupByFieldsForStatistics=zipcode_text&outStatistics=[{"statisticType":"count", "onStatisticField":"Case__", "outStatisticsFieldName":"Total"}]&having=&resultOffset=&resultRecordCount=&returnZ=false&returnM=false&returnExceededLimitFeatures=true&quantizationParameters=&sqlFormat=none&f=html&token= So you can do the opposite to figure out how to encode something! I'm not 100% sure on the official "rules" if something needs to be encoded or not - but the above two strategies have worked for me - Sarah Ambrose Product Engineer, Esri ... View more

Hi Lebogang Mashishi‌, Sorry for the delayed reply. In this case I think you can use the tool Join Features to find where people are in the same room at the same time. For example, with Join Features you could do something like this: Target layer and join layer are the same layer of features. The layer has a feature for each person (employee ID), the room (room ID - generated from the door name + entry/exit) they are in and the start and end time they entered and exited that room. An attribute join to match the room ID Temporal join to see when the times overlap. For the temporal join, if you had a field for the time they entered the room, and the time they exited the room you could do a intersect temporal join operation (). Do a join condition like so: $target[“userID”] != $join[“userID”] to make sure the same individual doesn’t join to themselves – only others. I realize this might not fit your data exactly as is, so there will need to be some tweaks made to join correctly or some data prep (Jon Feature might be helpful in this step as well!). Here is a previous example using Join Features that might be helpful to understand the parameters . This example used GeoAnalytics Server, but that same tool is available in Pro and doesn’t require a Server. - Sarah ... View more

Hi Jean-Sebastien Lauzon, Thanks for following up. The development team has looked at this issue and it will be fixed in the upcoming release of ArcGIS Online, targeted for July 2020. Thanks again for reporting this, Sarah ... View more

Hi Lebogang Mashishi‌, This tool probably won’t work exactly for your use case, but I’m interested in a few questions to see if there is similar analysis we can look at to find when people are in the same room. Is the data you have spatial, or tabular? Based on what values you have, I think I can suggest some workflows. I’m interested to know what of the following is included in the tagging data: Employee id or identifier? Door ID (how much information is returned – do doors tag both ways, so you might not know which room someone is in, or do you know the room)? Does the door location data get plotted on a map, or is it just an ID?  Do you have room exit information, or only entrance? Time – does this have entrance and exit, or only entrance? Please let me know if you any of the questions don't make sense Sarah ... View more

Hey Isaiah Freedman‌, There are two ways you can join features in ArcGIS Online using the Join Features tool: Creating a new layer result. This is the default. The new layer doesn't update based on changes in the input. Creating a hosted layer view. This option is only for joins based on attribute values, and is picked by selecting this option. You must also be the owner of the layer. If you are trying 1 - that won't work for you case - since it doesn't ever update. For 2, I'll have to reach out to someone else that knows more about the hosted view to ensure it works for CSV inputs - is that what you're currently trying?  Please let me know! Sarah Ambrose Product Engineer, Esri ... View more