POST
|
I'm prepping our LRS for transitioning over to R&H, and I'd like to know if I should change the default M tolerance and resolution. Our current LRS specs are below: Our events are only measured to thousandths of a mile (3 decimal places) and there is no exception to this, so what is the point of having a more precise tolerance/resolution? What do other organizations set as their defaults? It just seems like it would keep the data "cleaner" to not allow measures more precise than the event data, but I would love to hear other thoughts on this...TIA!
... View more
10-17-2023
11:53 AM
|
0
|
2
|
506
|
POST
|
I'm using ModelBuilder to perform a set of queries on a feature class, and count the number of records output from those queries using the "Get Count" tool, then write the counts to a table. This is my current model: How do I get ModelBuilder to write "0" when Get Count returns empty, and also make the model continue running through the rest of the queries? I feel like there is a very simple solution that I'm completely missing...TIA for any help!
... View more
06-29-2023
09:37 AM
|
0
|
0
|
296
|
POST
|
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
04-17-2023
09:12 AM
|
0
|
0
|
628
|
POST
|
Are you making any additional changes to the web map after configuring the Field Maps form? I was having a problem where I would set up and save my form, then go back to my Portal homepage and open the web map to tinker with the feature symbology, then save the map and log out for the day without checking the form again. Then I'd come back to my computer in the morning and see my form had magically disappeared overnight. Turns out... If you need to make any changes to the web map (adding new layers, changing pop-ups/feature symbology, etc.) you have to go through the Field Maps website to preserve the form settings. Like this: Another helpful thread. Hope this answers your question!
... View more
01-04-2023
06:40 AM
|
2
|
0
|
817
|
POST
|
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
12-29-2022
07:15 AM
|
0
|
0
|
726
|
POST
|
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
12-28-2022
10:50 AM
|
0
|
2
|
735
|
POST
|
Is there a way to round all m-values in an LRS to a specific number of decimal places? To be clear, I don't mean changing the display options; I'm talking about permanently rounding these values. I'd also like to do it in a way where I don't have to create a new feature class with a reduced M Resolution/Tolerance, because that will cause a lot of disruptions to our organization (we would basically have to reset data sources for hundreds of online services and route event layers). Note: I do not have the Roads and Highways extension. Hopefully we'll get it eventually, but I'm still on ArcMap 10.8.1 with an Advanced License and I just use the Editor and Route Editing toolbars when LRS adjustments need to be made. Within these confines, I'm hoping there's a button somewhere that allows me to apply Field Calculator to all of the m-values at once. We use the State Plane Coordinate System, and this is the existing resolution and tolerance of our LRS: I'm not sure how our organization landed on these values, because (unless I'm mistaken) they aren't even the defaults that ArcMap assigns. Regardless, our associated data only ever goes to the fourth decimal place, so I see no reason why we need anything more precise than that. Thanks in advance for any help or insight provided!
... View more
08-23-2022
12:38 PM
|
0
|
0
|
311
|
POST
|
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
06-01-2022
07:20 AM
|
2
|
0
|
3613
|
POST
|
Hi everyone! I have another question regarding one of my data expressions in ArcGIS Dashboards. I have four layers published to a feature service, which I'm trying to combine by their common field 'team name' and use in a Pie Chart to show total length surveyed by each team. Ideally, the expression will return a feature set that I can use in the Pie Chart function like this: I think I have to use the GroupBy() function somewhere in my data expression, and maybe also add another line to my dictionary, but I'm not sure how I would do that/incorporate all of that with more than one feature set. Here is my data expression so far: var sql = "EXEMPT_COD IS NULL Or EXEMPT_COD = 2 Or EXEMPT_COD = 4"
var fs_flexible = FeatureSetByPortalItem(Portal('https://xxxxx.xx.gov/portal'), 'xxx', 0, ['Length', 'SURV_CREW', 'EXEMPT_COD'], false);
var sum_flexible = Sum(Filter(fs_flexible, sql), 'Length')
var fs_rigid = FeatureSetByPortalItem(Portal('https://xxxxx.xx.gov/portal'), 'xxx', 1, ['Length', 'SURV_CREW', 'EXEMPT_COD'], false);
var sum_rigid = Sum(Filter(fs_rigid, sql), 'Length')
var fs_concrete = FeatureSetByPortalItem(Portal('https://xxxxx.xx.gov/portal'), 'xxx', 2, ['Length', 'SURV_CREW', 'EXEMPT_COD'], false);
var sum_concrete = Sum(Filter(fs_concrete, sql), 'Length')
var fs_gravel = FeatureSetByPortalItem(Portal('https://xxxxx.xx.gov/portal'), 'xxx', 3, ['Length', 'SURV_CREW', 'EXEMPT_COD'], false);
var sum_gravel = Sum(Filter(fs_gravel, sql), 'Length')
var sumDict = {
'fields': [{'name':'Length_Miles', 'type':'esriFieldTypeDouble'}],
'geometryType': '',
'features':
[{'attributes':
{'Length_Miles': GroupBy((sum_flexible + sum_rigid + sum_concrete + sum_gravel), ['SURV_CREW'], [ { name: 'lengthbyteamname', expression: 'sumlengthbyteamname', statistic: 'SUM' } ])
}}]};
return FeatureSet(Text(sumDict)); Do I need to 'flip' my order of operations so that the GroupBy() function occurs up in lines 4, 7, 10, and 13 and the Sum() function from those lines occurs down in my dictionary attributes? If so, how would I alter my script to achieve this? Additionally, how can I change it to get the results I want? Thanks for any help!
... View more
05-10-2022
02:53 PM
|
1
|
2
|
3881
|
POST
|
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
05-10-2022
01:58 PM
|
0
|
0
|
1148
|
POST
|
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
05-06-2022
12:15 PM
|
0
|
6
|
833
|
POST
|
Hello! I'm looking for some help with one of my data expressions in ArcGIS Dashboards. I have four layers published to a feature service, which I'm trying to combine. The catch is that I only want the output feature set to include records from 'the past week.' Is there a way to do this using the Filter() function in a data expression? My understanding is that the Arcade Filter() function uses SQL language for the query, and I can't figure out how to make a SQL query that parses the week number from my date field and compares it to the current week number. Below is an example of a successful script I'm using. I want to change the portion of line 1 where it says SURV_DATE IS NULL to essentially say WEEK(SURV_DATE) = WEEK(CURRENTDATE()). Is this even possible? If so, what's the correct translation? If not, how would I alter my script to achieve this? var sql = "SURV_DATE IS NULL And (EXEMPT_COD IS NULL Or EXEMPT_COD = 2 Or EXEMPT_COD = 4)"
var fs_flexible = FeatureSetByPortalItem(Portal('https://xxxxx.xx.gov/portal'), 'xxx', 0, ['Length', 'SURV_DATE', 'EXEMPT_COD'], false);
var sum_flexible = Sum(Filter(fs_flexible, sql), 'Length')
var fs_rigid = FeatureSetByPortalItem(Portal('https://xxxxx.xx.gov/portal'), 'xxx', 1, ['Length', 'SURV_DATE', 'EXEMPT_COD'], false);
var sum_rigid = Sum(Filter(fs_rigid, sql), 'Length')
var fs_concrete = FeatureSetByPortalItem(Portal('https://xxxxx.xx.gov/portal'), 'xxx', 2, ['Length', 'SURV_DATE', 'EXEMPT_COD'], false);
var sum_concrete = Sum(Filter(fs_concrete, sql), 'Length')
var fs_gravel = FeatureSetByPortalItem(Portal('https://xxxxx.xx.gov/portal'), 'xxx', 3, ['Length', 'SURV_DATE', 'EXEMPT_COD'], false);
var sum_gravel = Sum(Filter(fs_gravel, sql), 'Length')
var sumDict = {
'fields': [{'name':'Completed_Miles', 'type':'esriFieldTypeDouble'}],
'geometryType': '',
'features':
[{'attributes':
{'Completed_Miles': (sum_flexible + sum_rigid + sum_concrete + sum_gravel)
}}]};
return FeatureSet(Text(sumDict)); Thanks in advance!
... View more
05-06-2022
08:19 AM
|
0
|
2
|
1323
|
POST
|
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
04-06-2022
12:20 PM
|
0
|
0
|
2096
|
POST
|
So simple, and yet, I didn't even think to do this! Thank you. It worked like a charm!
... View more
04-06-2022
12:14 PM
|
1
|
1
|
2097
|
Title | Kudos | Posted |
---|---|---|
2 | 01-04-2023 06:40 AM | |
1 | 05-10-2022 02:53 PM | |
2 | 06-01-2022 07:20 AM | |
1 | 04-06-2022 12:14 PM | |
1 | 12-04-2020 12:19 PM |
Online Status |
Offline
|
Date Last Visited |
Monday
|