Latest Contributions by KenBuja

Is there a way that a post won't show in the Latest Activity feed for each group it's been shared with? For example, this post shows up 18 other times. There's been a few times where other posts get lost in the blizzard of share notifications.       ... View more

You can replace all your if statements by looping through an array of the possible agencies function FormatName(name, split_pt) { var frontend = Left(name, split_pt); var backend = Right(name, Count(name) - (split_pt + 1)); var front_len = Count(frontend); var back_len = Count(backend); var spacing = ""; var adjust = 1.3; if (front_len < back_len) { spacing = Concatenate(Array(Ceil(((back_len - front_len) / 2) * adjust), " ")); return spacing + frontend + TextFormatting.NewLine + backend; } else { if (back_len < front_len) { spacing = Concatenate(Array(Ceil(((back_len - front_len) / 2) * adjust), " ")); return frontend + TextFormatting.NewLine + spacing + backend; } else { return frontend + TextFormatting.NewLine + backend; } } } var Agency = $feature.AgencyName2; var names = [ " Water Service Area", " Riverside Public Utilities (RPU)", " San Bernardino", " Mutual Water Company", ]; for (var i in names) { var sb = Find(names[i], Agency) if (sb > -1) return FormatName(Agency, sb) } return "Agency not found" ... View more

Nice write-up! You can open the Command Console in a specific directory by opening the File Explorer and navigating to that directory above it. Right click on the directory and select "Open in Terminal" ... View more

In your if statements, you have misplaced parenthesis for the Count functions on bld_result (lines 1, 7, and 13). And you should have a return if both counts are zero. if(Count(parcel_inside_ez) > 0 && Count(bld_result) > 0){ return "This residential property is within the enterprise zone." } // Check to see if the selected Tax Parcel buffered feature intersected the Enterprise Zone FeatureSet // Check to see if the filtered Buildings did not intersect the Tax Parcel buffered feature else if(Count(parcel_inside_ez) > 0 && Count(bld_result) == 0){ return "This is not a residential property." } // Check to see if the selected Tax Parcel buffered feature intersected the Enterprise Zone FeatureSet // Check to see if the filtered Buildings intersected the Tax Parcel buffered feature else if(Count(parcel_inside_ez) == 0 && Count(bld_result) > 0){ return "This residential property is not within the enterprise zone." } // If both counts are zero else { return "This property is not residential and is not within the enterprise zone." }   ... View more

If your ultimate goal is to create a app where the items can be toggled on and off through the legend, you can use the Interactive Legend instant app. ... View more

I noticed that your code doesn't show the field aliases (if they are present). Here's a modification that shows them. var fieldInfos = [] var attributes = {} var fields = Schema($feature).fields for (var att in $feature) { if (!IsEmpty($feature[att])) { var alias = att; for (var i in fields){ if (fields[i].name == att) alias = fields[i].alias } Push(fieldInfos, {fieldName: alias}) attributes[alias] = $feature[att] } } return { type: 'fields', title: 'An Expression to Skip Nulls', fieldInfos, attributes }   ... View more

Would the Interactive Legend instant app be a viable alternative? https://www.esri.com/arcgis-blog/products/instant-apps/mapping/interactive-legend/ ... View more

Take a look at this blog post by @jcarlson about how to "memorize" a FeatureSet. You should be able to use the same logic to loop through both FeatureSets to combine them into one. ... View more

The next step it to to see what the ubRecordsSorted FS contains. Put in a return statment on line 11 and see if you're getting the same records multiple times. ... View more

Can you run it in the code editor? This will show the returned FeatureSet and the console items that Josh also suggested editor.png You might have to put in a specific parcelPID to test it var parcelPID = "01824000034"   ... View more

What do you see if you put in "return ubRecordsSorted" at line 8 and run this in the editor? Do you get the expected records? ... View more

Showing that other table makes it a little more understandable. In that case, leave off that second GroupBy expression and use your original version. What is the error you're getting on line 7? ... View more

If you have a field in your table that contains the mileage for each road, you would add that to the GroupBy function. Or you could use the "SHAPE__Length" field. However, since that won't be in miles, you would have to convert that in the Expression. Here, I'm making the conversion from meters to miles   var stats = groupby(sourceTable, 'RoadNumber', [ {name: 'Total_Score', expression: 'Individual_Removal_Score', statistic: 'SUM'}, {name: 'Total_Miles', expression: 'SHAPE__Length * 0.000621371', statistic: 'SUM'} ] );   Then in the final line, you would use that summarized length   return iif(Lookup == null, null, ((Lookup.Total_Score)/Lookup.Total_Miles));     ... View more