Latest Contributions by KenBuja

The problem you're running into is the comments attribute in your feature is a text string and not JSON text. "[{'date': '2025-12-29', 'comment': 'Code Enforcement has received your service request (#CRM-25001496).', 'visibility': 'Public'}, {'date': '2025-12-29', 'comment': 'This issue was recategorized from Unsafe Sidewalks or Rights-Of-Way to Encampment Activity.', 'visibility': 'Public'}, {'date': '2025-12-29', 'comment': '7 day notice posted. Reporting party has been notified. ', 'visibility': 'Public'}, {'date': '2025-12-29', 'comment': 'CRM-25001496 on CentralSquare Community Development abandoned and now managed on SeeClickFix due to recategorization.', 'visibility': 'Internal'}, {'date': '2025-12-30', 'comment': 'CWB Street Outreach was able to make contact and provide resources and information to individuals', 'visibility': 'Public'}, {'date': '2025-12-30', 'comment': 'CWB Street Outreach was able to make contact and provide resources and information to individuals ', 'visibility': 'Internal'}, {'date': '2026-01-06', 'comment': 'We have completed your request. Thank you for your submission.', 'visibility': 'Public'}]" Regular JavaScript has the JSON.parse() method, which allows you to convert a string like that into JSON, but Arcade doesn't have that functionality. Could you create a table from the API call and use that in a one-to-many relationship to get the related records for that feature? ... View more

Just a warning that line 7 will crash the code. You'd have to return something like the count of the FeatureSet or get the first feature to get the Locationname attribute like you have in line 8. ... View more

In this case, you'd want to use AND instead of OR. I think the confusing part for this query is that it uses NOT in conjunction with the OR. That will result in only filtering out the features that have "Canal" and are of ftype of 460 or 428. A feature of ftype 460 will be returned if it doesn't contain "Canal". To illustrate that, I have a sample dataset where I'm filtering by Region and Field_ID. The original data looks like this 2025-12-17_14-08-06.PNG If I apply a query like you have to remove records that don't have 1 in the region name or are not 6563, 6564, or 6565, then the only record removed is the one with PRICO1 and 6564. 2025-12-17_14-12-15.PNG If I use AND in that query, then the three records are removed that meet either criteria 2025-12-17_14-15-26.PNG ... View more

The quotes are incorrect on the SQL Statement within the Filter function. It should like this: "Encroachment_Type_1 = 'Mowing (turf grass)' OR Encroachment_Type_2 = 'Mowing (turf grass)' OR Encroachment_Type_3 = 'Mowing (turf grass)'" Since the Filters appear to be the same except for the layerID, you can use a loop to simplify things. var ids = [0, 1, 2]; var MowingCount = 0; for (var id of ids) { MowingCount += Count( Filter( FeatureSetByPortalItem( Portal("https://www.arcgis.com"), "itemID", id, ["Encroachment_Type_1", "Encroachment_Type_2", "Encroachment_Type_3"], false ), "Encroachment_Type_1 = 'Mowing (turf grass)' OR Encroachment_Type_2 = 'Mowing (turf grass)' OR Encroachment_Type_3 = 'Mowing (turf grass)'" ) ); } return MowingCount;   ... View more

And as an aside, didn't the sample pages used to have a feedback mechanism, similar to the "Was this page helpful?" link in the lower right corner in the API reference pages? Clicking Yes or No provided a dialog so you could send an email about an issue on the page. ... View more

Have you checked the distance attribute for those other features? You'll only get returns if the values exactly match 200, 400, or 600. ... View more

When posting code, please use the "Insert/edit code sample" button. This makes it easier to read or copy your code.  You can create a single feature from the roadlessIntersect FeatureSet and using that in the intersection with the speciesRanges FeatureSet. To do this, loop through the FeatureSet and add the features to an array. Use the Union function to create the single feature from that array. var roadlessIntersect = Intersects(RoadlessRule, $feature) var features = [] for (var f in roadlessIntersect) { Push(features, f) } var roadlessFeature = Union(features) var speciesIntersect = Intersects(speciesRanges, roadlessFeature) ... View more

Esri can be frustrating like that sometimes! What was the final solution? You should click the "Accept as Solution" button in the post with the correct solution (even it was yours!). This will help others search for the same sort of answer. ... View more

You can use the GroupBy function to calculate this var fs = FeatureSetByPortalItem( Portal("https://www.arcgis.com"), "yourID", 0, ['County','Year', 'curr_enr','prev_enr'], false ) GroupBy(fs, ['County','Year','curr_enr','prev_enr'], {name: 'Change', expression: '(curr_enr - prev_enr)/prev_enr', statistic: 'Max'}) ... View more

Also note that you can make the When statement more concise var tod = When(hour >= 0 && hour <= 5, "Night", hour <= 8, "Morning", hour <= 15, "Day", hour <= 23, "Evening", Null ); ... View more

Are you viewing this in Firefox? There have been reports of some issues with Firefox v145.0 That said, I'm seeing the Preview button on my machine using ExB DE 1.18 in both Firefox and Chrome. ... View more

You can write a function that returns the color for the attribute passed in as a parameter. function bgColor(attribute) { when (attribute <= 70, "red", attribute <= 80, "orange", attribute <= 90, "yellow", attribute <= 95, "green", "blue") } //in use var theColor = bgColor($feature.attribute)   ... View more