Latest Contributions by SimonJackson

I have a fairly large points layer in a hosted feature service - Lets call this incidents This layer is frequently changing every couple of minutes with new records, deletes and updated locations. I have a polygon layer as a hosted feature service - lets call this districts A static layer that never changes shape. This is all in ArcGIS Online.  No ArcGIS Enterprise in the mix. As a user, I want to have a count of how many points there are in each polygon, along with perhaps some summary stats on the numerical fields from the incidents layer. With a DBMS + ArcGIS Enterprise, I could create a nice Query layer and leverage ST_Intersects to have the polygons dynamically count how many features there are within them.  But, I don't have access to these for this project. I was looking at Arcade, but does not look like this is possible to reference a separate layer.  I was also looking at the Geometry Engine and the Contains method on a polygon in the Esri Javascript API (custom front-end logic is fine).  This sounds client-heavy.  I would have to send all incidents to the browser and then loop through each incident that is contained in each district to tally up scores, and then render.  But, could be an option here.  Could do with a sample snippet or pseudocode as a headstart... There is the Spatial Join analysis tool, but the frequency this would need to be run (every couple of minutes) going to burn through my credits allowance fairly quick. Anyone want to brainstorm this a little and offer a better suggestion I might not have thought of? A Python funtion running every couple of minutes on AWS Lambda every with some non-arcpy libraries that perform the counts/summary stats? ... View more

Polling a GTFS-Realtime feed.  Have some logic in Node to decode the Protocol Buffer and manually massage into a format suitable for pushing into an ArcGIS Online Hosted feature service. Two example messages from my source back-end shown below.  (typically around 3000-4000 messages in each packet) Created logic to push this into an destination ArcGIS Online Hosted Feature Service with same schema, currently using ApplyEdits.   This push would happen every 30 seconds - (we need to be as efficient as possible) We only require the current location of each unique transit vehicle in the hosted feature service i.e. We do not care about its previous history/breadcrumb trail. We are trying to push the real time vehicle  locations from the GTFS-Realtime feed into a hosted feature service. Problem is, we keep creating duplicate points, when we need to: Create new feature if the vehicle_id does not exist in destination feature service Update existing features if the vehicle_id does exist   I was initially looking at ApplyEdits, but then stumbled across Append Upsert capability on the root REST endpoint for a feature service. But, struggling to get it to work. The unique ID is going to be the vehicle_id on both sides. Problem: Getting duplicate records every time we push the JSON using ApplyEdits.  The Append Upsert endpoint sounded like it was a better operation to use: "Upsert is used to add new features and updating existing features at the same time.  It is a high performance API capable of handling large volume of data." "The destination objectId or globalId fields do not need to be mapped to source fields of the same type. Source featureId can come from different field type as long as the values are acceptable destination featureId value." However, we have tried a few different approacheswe are struggling to get this to work. It sounds like we can push our response to a hosted feature service and use our source ID of   vehicle_id (string), and potentially push this into a GlobalID (string)?  We have  a GlobalID on the destination feature service.   What would the params looks like for an Append Upsert with a foreign ID on the source?   A copy of the test service is here with the Append operation available and fully open: https://services9.arcgis.com/M6PRFWHKXSvV72Qg/ArcGIS/rest/services/Transit_Vehicle_Locations/FeatureServer/append  {      "adds": [           {                "geometry": {                     "x": 151.20631408691407,                     "y": -33.882198333740237                },                "attributes": {                     "vehicle_id": "4205062-10795-DN-91",                     "trip_id": "4205062-10795-DN-91",                     "route_id": "IWLR-191",                     "bearing": 20,                     "start_time": null,                     "start_date": null,                     "speed": null,                     "congestion_level": "UNKNOWN_CONGESTION_LEVEL",                     "TransitType": "lightrail"                }           },           {                "geometry": {                     "x": 151.19384765625,                     "y": -33.8746337890625                },                "attributes": {                     "vehicle_id": "4205063-10795-DN-90",                     "trip_id": "4205063-10795-DN-90",                     "route_id": "IWLR-191",                     "bearing": 221.6636657714844,                     "start_time": null,                     "start_date": null,                     "speed": null,                     "congestion_level": "UNKNOWN_CONGESTION_LEVEL",                     "TransitType": "lightrail"                }           }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ We have also been pondering if we should be looking at leveraging ArcGIS-REST-JS?  This does not appear to have an append function, but the updatefeatures approach might be a better approach to deal with responses, especially when we move this to using a secure hosted feature service. Any tips or suggestions would be really appreciated. This service will later be available for all to use via a view layer. ... View more

I am trying to tweak the prevent self-intersecting lines sample for polygons. I want to avoid the user creating any self-intersecting polygons, making similar use of the client-side GeometryEngine package. I have tried a variety of combinations, but struggling to massage this sample to work for polygons.  Can someone help put me out of my misery? This is one of my attempts: https://jsfiddle.net/jobvt523/ Still not catching all cases of self-intersecting polygons. ... View more

As an open data admin, I want to create a script that will identify any open data enabled groups within my organisation and then apply a creative commons license to all of the items in it so that these will flow through to the items on the open data site. Is there a property to distinguish which groups are open data enabled?   ... View more