Latest Contributions by SarahAmbrose

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

Thanks for the update Jean-Sebastien Lauzon‌, I've been testing and able to reproduce this issue. The team is looking into what's going on now. In the mean time, if you create a new layer (default option) instead of a view result, you should see the correct sum results.  Thank you for reporting this! Sarah Ambrose Product Engineer, Esri ... View more

Hi Mike Cuenca‌, Thanks for the datasets I've tried it out and I understand what's going on.  Currently, the Join Features tool only joins when features have a match, and target features that don't have a match aren't included in the result. If you are familiar with ArcGIS Pro or ArcMap there is a setting to "Keep all Target Features" - this isn't currently an option in Join Feature in ArcGIS Online.  So for an example with your data: You have a point layer with 2737 features A polygon layer with 3220 features It looks like there is only ever one point per polygon, but some polygons do not have a point. For example, here are the points (I made the points very big and purple) with the green polygons: You can see that some polygons don't contain a point. When I run Join Features, I only see polygons returned where there are points. This image shows the original points and the Join Features result (blue polygons): I have submitted and enhancement request to the team, and we'll work to add the option to keep target all features in a future release.  In the meantime, I was able to complete the workflow you intended to do (or I assume you were working towards) by chaining a few tools together: 1. Run Join Features with target layer: polygons, join layer: points, and the spatial relationship completely contains. In this case I did a one to one join. 2. Overlay Layers - Erase. I ran Erase on the original polygon layers and the Join Result. This results in the original polygons that did not have points: 3. Merge Layers: Merge the Joined results (polygons where points existed) with the Erase results (polygons where points didn't exist). I removed the Area in Square <Units> field since I didn't need it and it should be recalculated when I run the tool. All other fields automatically matched: And that should result in a layer with all polygons and their joined point values. Field values will be null for the polygons that don't have any intersecting points. Then when you do the symbology - make sure to check the value "Draw features with no value" so your map shows the joined polygons but notes there was no point data for those counties.  The other way - but you might end up with some weird field names is to run Aggregate Points instead of Join Features. In that tool you can specify "Keep areas with no points". Since this tool will summarize point values, you'll need to calculate statistics for the single point value. So for example, the "sum of Deaths" will result in the single death value (so if the value was 5 for a point, the polygon will say sum_deaths = 5). So it will keep the value you are interested in, and just end up with an unexpected column name.  Either workflow should work for this case though. Please let me know if you have any questions! - Sarah ... View more

Hi Mike Cuenca‌, Are you able to share your layers and parameters (a screen shot works) that you are using? If yes, can you please share the URLs and I can try and reproduce this?  Has this tool worked as expected before? Or is this the first time you're running into this? Thanks, Sarah Ambrose Product Engineer, Esri ... View more

This is not yet supported at 10.7.1 or 10.8. When support is added it will be listed in the What's New GeoAnalytics topic here: What's new in ArcGIS GeoAnalytics Server—GeoAnalytics (Windows) Deployment Guide | Documentation for ArcGIS Enterprise  ... View more

Hey -  The bin size is the area you are aggregating your raw points into. From the documentation: The distance interval that represents the bin size and units into which the point_layer will be aggregated. The distance interval must be a linear unit. So from the image in the topic - the image on the right would have 36 bins: The neighborhood size is used to compare a bin to it's neighboring bins: The spatial extent of the analysis neighborhood. This value determines which features are analyzed together to assess local clustering. The neighborhood size must be greater than the bin size. This is similar to the distance band parameter in the Hot Spot Analysis (Getis-Ord Gi*) tool works.  So with a bit of an adaptation of the Hot Spot Analysis (Getis-Ord Gi*) doc - this should help explain it:  Each feature (bin!) will be analyzed within the context of neighboring features (bins). Neighboring features inside the specified neighborhood size will receive a weight of one and exert influence on computations for the target feature. Neighboring features outside the critical distance will receive a weight of zero and have no influence on a target feature's computations. Let me know if that help clarify it, and I'll modify the GeoAnalytics tool doc to be more clear for the next release.  Thanks, Sarah Ambrose GeoAnalytics Team ... View more

Thanks Zakaria Douiri‌, GeoAnalytics does not currently support integrated authentication with Hadoop. If this is something you are interested in seeing, please don't hesitate to create an ENH through support.  Sarah Ambrose Product Engineer, GeoAnalytics ... View more

Hi Giacomo Joggerst‌, Lauren Bennett‌ wrote a great blog post on Machine Learning, and what is meant by the term. I think this might sort out some of your question .  Hope that's helpful, Sarah Ambrose Product Engineer, GeoAnalytics ... View more

Hi Zakaria Douiri‌, No, there isn't a way to update the existing layer.  Depending on what type of results you are looking for, you could use the Append tool to append a new result to the existing one. Another potential workflow is using the ArcGIS API for Python to automate deletion of the existing layer before rerunning analysis - but you won't be able to maintain your feature service URL or portal ID - but could update with the new one using the ArcGIS API for Python.  We are looking into ways to support this updating an existing layer in the future. For this workflow, is it important that the portal item is the same as before, the feature service URL, or both? Thanks, Sarah Product Engineer, GeoAnalytics ... View more

Hi Zakaria Douiri‌, Can you please clarify your question. Are you trying to run a tool with a big data file share as input? And running into issues?  Thank you for updating the question. Since you question is different than the original, can you please ask a separate question so it gets it's own thread. Thanks, Sarah ... View more