Latest Contributions by KenMorefield

Hi Jake - thanks for the tip.  Here is what I REALLY NEED to figure out soon!  How do I filter a layer in a web map to show only the most recent feature in the layer?  For example, think of a "track log" of locations - and then the "last known location" of the tracklog.  How would I filter the layer to only display the last known location?  I know how to depict locations in the last few days or hours, but I really only want the very last location.  Any ideas?  Ultimately, I'd like to be able to filter out the last known locations for each unique individual within a dataset.  My real world example deals with collared animals.  The GPS collars don't always reliably upload at a regular, specified interval.  I will have many individual animals collared.  I want to display just the most recent for each collar. Thanks, Ken ... View more

Hi Kelly, I think the original request was how to "flatten" a 1-many-many relationship into a single flat table.  It sounds like Javier created a Survey123 survey with a layer (parent) which then had a repeat table (child) and the repeat table had a nested repeat table (grandchild).  So you end up with relationships 3 layers deep.  Now he wants to flatten it all out into a single layer that can be used in Operations Dashboard, while updating dynamically if any of the underlying data changes.  I too, would be very curious to know if this is possible.  I can't seem to figure it out.  It would be TREMENDOUS if ESRI could ever implement this functionality, because there are so many people that have requested this. ... View more

Ismael Chivite‌ Hi Ismael, I'm wondering if you can help me out with a similar workflow.  Here is a description of what I have set up.  I am accessing a 3rd party Wildlife Telemetry Collar API which allows me to get collar locations in near real-time.  I'm using the HTTP module in Integromat to access that collar API.  I then parse the response with the JSON module.  Using another HTTP module, I run a spatial intersect query with the JSON results against a hexagon grid feature service (in ArcGIS Online) in order to get the intersecting hexagon grid ID.  These query results are then passed to another JSON module (for parsing) and then I add one more HTTP module which takes collar data (CollarID, CollarDateTime, Latitude, Longitude) and coupled with the Hexagon Grid ID - I append this data to a point layer residing in ArcGIS Online.  This all works great!  In ArcGIS Online, I then "join" this resulting point layer back to the hexagon layer and create a view layer from that (resulting in hexagons with the added collar data).  In a web map, I filter the hexagons to only show those from the last 24 hours.  All of this works great, and what I'm left with is an "almost" real-time web map that shows the location of my collared animal (a wolf in this case) represented by a 10 square mile hexagon.  The wolf was somewhere within that hexagon at that date/time.  The intent is to make this a public facing web app - where ranchers, farmers, and other members of the public can go and see a general location (hexagon) of where the wolf was in the last 24 hours.  This all works very well right now.  Currently, none of the services, web maps, or web apps have been set to public.  Now for my issues: The two HTTP modules that call my feature services in ArcGIS Online (one to perform the spatial intersect and one to perform the "add features" append) require tokens to access the services.  These tokens time out after about two weeks.  I have had to go into the REST API for these services and get a new token and paste the new tokens into my Integromat scenario.  Do you have any ideas or advice on how I might be able to automatically generate a new ArcGIS Online token everytime the scenario is run, so that the scenario doesn't break every two weeks when the token expires? Thanks so much! Ken ... View more

Hi Xander, I'm wondering if your suggested Arcade solution could be expanded to include 3 relationships deep?  Your example shows a "Parent - Child" relationship.  I'm wondering if Arcade can handle a "Grandparent - Parent - Child" relationship?  Any idea on how to code that?  My example consists of a Site Inpection (Grandparent), where multiple instances of Pollution can be found (Parent), and for each Pollution instance - multiple Violations can occur.  Site Inspection>Pollution>Violation Any ideas?  I'm working on modifying your code provided above, but I'm not quite getting there! ... View more

Thanks for chiming in Nick.  Realistically, there will probably be fewer than 100 survey entries.  So maybe I'm overthinking the chances of having to random numbers come out the same.  Using your rounding and/or a tiebreaker field would probably insure that I never have a problem (with so few entries).  I'll try a few approaches and see what I find. ... View more

Hi Joe - I guess I just don't really know how random a Global ID is.  I know they are unique - but if you use that number and sort ascending or descending, assuming it to be random - Is it truly random?  Would a person receive preferential ranking if they submitted their survey first, or last?  I don't really know.  It seems that I have read that they are not random... ... View more

Hi Xander, I don't mean to hijack this thread, but I thought maybe you could help me with an Arcade example that I'm working on.  I have a linear stream layer that represents all streams within the state of California.  This layer does not change at all.  I also have a point layer representing pollution.  These points are collected on iPads in the field and are constantly changing.  I'm trying to set up an Arcade FeatureSet to buffer the selected feature by 150 feet, and then if that buffer intersects one or more of the streams, to return the stream name(s).  I have this working just fine using this Arcade code: var bufferPt = Buffer($feature, 150, 'feet'); var intersectStream = Intersects(bufferPt, FeatureSetByName($map, "California Streams"));     for (var f in intersectStream){         return f.DFGWATERID     } There are a couple of issues.  This seems to work when only one stream is within 150 feet.  But if there are two or more, it returns blank.  The more concerning issue is that it takes right at 60 seconds to calculate and then populate the popup.  I'm sure this has to do with the fact that there are 740,662 streams in the stream layer.  So I think the calculation might be running through all streams, checking to see if they intersect the 150 foot buffer of the pollution point.  Do you have any guidance on how to first filter the streams layer so that it doesn't take 60 seconds to run?  Or any other suggestions for speeding up the Arcade calculation?  Thanks, Ken ... View more

Hi all, This is exciting stuff!  I'm still fairly new to Arcade.  Can anyone tell me if these Arcade Expressions with FeatureSets will work in Collector?  If they will work in Collector, will they work in an offline Collector application that has syncing enabled? I have some end users that could really use some of this functionality to quickly determine some summary info while "disconnected" in the field. Thanks! Ken  ... View more

Hi John, I was able to get it successfully working using your tutorial.  The only slight difference was on the first "HTTP" module, where you replace the objectId with feature: result: objectId - I did not have that parameter available.  I did have response: addResults: objectId.  This parameter worked for me.  I believe the problem that I was encountering with the integromat scenario not working when sending a survey on my iPad had to do with needing to re-download the survey once my scenario was completely finished in integromat.  I don't think the downloaded survey on my iPad was seeing the webhook.  Consider this case closed!  Thanks so much for your help!  I look forward to seeing additional tutorials on different integromat scenarios - especially working with related records! Ken ... View more

Hi John, I seem to be stuck at this point in your tutorial: On page 7 you state - "In the same way delete the objectid value and replace it with feature: result: objected (from the Custom webhook)" I don't have a feature result parameter.  Any idea why that is? Thanks for all of your help! Ken ... View more

John, Thanks so much for this tutorial!  I will work through this and see how far I get.  I look forward to additional tutorial scenarios - especially for related records.  I'll post back soon with my results. Ken ... View more