Latest Contributions by KathrynWesson

This is awesome, thank you very much! ... View more

Hi Sam, I must have missed the notification for your message all those months ago. Sorry! I have a map package for you which shows the labeling error situation. If I could send it to you directly, that would be great; please let me know you best contact method. Thanks! ... View more

Ah, sorry, guess you're in the same-ish boat as me! Sounds like it's just buggy, but I've never created a map series, so maybe there's an elusive setting you have to use to filter the labels. Try creating a new community thread and see if any Esri folks bite. Good luck! ... View more

No solution to my original post, however... I work mostly with ArcMap still, so I have no idea if this will also apply in ArcGIS Pro, but I've had phantom labels appear for features whose values aren't included in a category-based symbology schema. So, if you've removed a certain value from the feature's symbology (and unchecked the <all other values> class), make sure to also apply that omission to the labeling SQL query, too. This is because an omitted symbology class is essentially still on the map as an "invisible" feature; if you want to fully hide a feature from the map, including its labels, using a Definition Query would accomplish this. Hope that helps! ... View more

Thank you very much! That put me on the right path. I was able to match my expression to your example (the GitHub link also helped) and get what I needed. I've pasted my working expression below, in case anyone in the same situation stumbles across this post.   var sql = "EXEMPT_COD IS NULL Or EXEMPT_COD = 2 Or EXEMPT_COD = 4" var portal = Portal('https://xxxxx.xx.gov/portal'); // Create a FeatureSet for each pavement type Feature Layer. // Group the features by the team name var flexible = GroupBy( Filter(FeatureSetByPortalItem(portal,'xxx',0,['Length', 'SURV_CREW', 'EXEMPT_COD'],false), sql), ['SURV_CREW'], [{ name: 'flexible', expression: 'Length', statistic: 'SUM' }] ); var rigid = GroupBy( Filter(FeatureSetByPortalItem(portal,'xxx',1,['Length', 'SURV_CREW', 'EXEMPT_COD'],false), sql), ['SURV_CREW'], [{ name: 'rigid', expression: 'Length', statistic: 'SUM' }] ); var concrete = GroupBy( Filter(FeatureSetByPortalItem(portal,'xxx',2,['Length', 'SURV_CREW', 'EXEMPT_COD'],false), sql), ['SURV_CREW'], [{ name: 'concrete', expression: 'Length', statistic: 'SUM' }] ); var gravel = GroupBy( Filter(FeatureSetByPortalItem(portal,'xxx',3,['Length', 'SURV_CREW', 'EXEMPT_COD'],false), sql), ['SURV_CREW'], [{ name: 'gravel', expression: 'Length', statistic: 'SUM' }] ); // Create empty array for features, feat object to populate array var features = []; var feat; // Loop through each of the four FeatureSets and populate feature array. for (var f in flexible) { feat = { attributes: { team_name: f['SURV_CREW'], length_by_team: f['flexible'], }, }; Push(features, feat); } for (var r in rigid) { feat = { attributes: { team_name: r['SURV_CREW'], length_by_team: r['rigid'], }, }; Push(features, feat); } for (var c in concrete) { feat = { attributes: { team_name: c['SURV_CREW'], length_by_team: c['concrete'], }, }; Push(features, feat); } for (var g in gravel) { feat = { attributes: { team_name: g['SURV_CREW'], length_by_team: g['gravel'], }, }; Push(features, feat); } var combinedDict = { fields: [ { name: 'team_name', type: 'esriFieldTypeString' }, { name: 'length_by_team', type: 'esriFieldTypeDouble' }, ], geometryType: '', features: features, }; // Return dictionary cast as a feature set return FeatureSet(Text(combinedDict));     ... View more

Fantastic, you're awesome! I simply replaced line 1 and line 2 with the following expressions: var wkday = Weekday(Today()) var sql = "(SURV_DATE > CURRENT_DATE - @wkday) And (EXEMPT_COD IS NULL Or EXEMPT_COD = 2 Or EXEMPT_COD = 4)"  Didn't have to change anything else from the original script, and it worked perfectly! Thank you so much! ... View more

Hi! Sorry for the late reply; the issue occurs when I use "Clip to shape" on the data frame and then utilize the "Exclude Layers" option. Like this: Maybe it's a software bug? You can download the public version of our local roads data here, and the county boundary data here if you have time to test out my theory. I used Ziebach County in my example. Thanks so much! ... View more

Wow, my Google-ing never led me to _EVW but your advice worked perfectly! In case anyone else stumbles across this post, here is my working View Definition, which also incorporates @TanuHoque's suggestion:   (SELECT OBJECTID + 1000000 as OBJECTID, Length, SURV_DATE, SURV_CREW, EXEMPT_COD FROM TR.TR_ADMIN.CRCP_EVW UNION SELECT OBJECTID + 2000000 as OBJECTID, Length, SURV_DATE, SURV_CREW, EXEMPT_COD FROM TR.TR_ADMIN.Flexible_EVW UNION SELECT OBJECTID + 3000000 as OBJECTID, Length, SURV_DATE, SURV_CREW, EXEMPT_COD FROM TR.TR_ADMIN.Gravel_EVW UNION SELECT OBJECTID + 4000000 as OBJECTID, Length, SURV_DATE, SURV_CREW, EXEMPT_COD FROM TR.TR_ADMIN.Rigid_EVW)   Thanks for your help! ... View more

So simple, and yet, I didn't even think to do this! Thank you. It worked like a charm! ... View more