POST
|
I need to populate a field in an AGOL point feature service by grabbing the most recent record from a related table also hosted in AGOL (Sites and InspectionReports). I can do this in AGOL data view using an Arcade expression but I want to automate it in Model Builder and schedule it in ArcGIS Pro. Right now I can sort the records in InspectionReports to upend the most recent inspection into Sites using the following Arcade expression in AGOL data view but I'm curious if I can translate this to Calculate Field in Model Builder: var ordered = OrderBy(FeatureSetByRelationshipName($feature, "InspectionReports"), "i_site_date DES") var site = $feature.DBID var related = Filter(ordered, "DBID = @site") var relatedfeatures = Filter(related,"Report_type LIKE '%Inspection'") var last = First(relatedfeatures) var result; if(last == null) { result = Text("") } else { result = last.i_site_date } return result Can I reference an AGOL table as I did with FeatureSetByRelationshipName($feature, "InspectionReports"), "i_site_date DES") in a Calculate Field Arcade script?
... View more
Thursday
|
1
|
0
|
94
|
POST
|
I have a point layer "sites" and a related table "inspections" running for Field Maps data collection and a Dashboard visualization of what's going on (based on this workflow). In the webmap popup I can use Arcade to find the most recent inspection (or no inspection) in the related table based on each site point, etc. Now I need to populate fields in the parent point "sites" layer with a daily update for "next inspection" (a straightforward calculation based on data in "sites" attribute table), "last inspection" (a query of the related records for each site), and a third field where an arcade script decides if an inspection is due. I can calculate these manually in the Data view at ArcGIS.com with arcade. Is there a way to automate this to run daily via ArcGIS.com or ArcPro desktop? I can't figure out how to reference, sort, select most recent inspection, etc from the related table data in model builder for Pro desktop (to schedule a task) or how to use Calculate/Notebooks with Arcade to schedule a task online.
... View more
01-23-2024
12:03 PM
|
0
|
2
|
253
|
POST
|
It seems that the order in which you add in Parse Path matters. If you add in Parse Path to a blank Model Builder and then add in your layer(s) it seems to exclude the file extension and give you a clean "%Name%". Whereas if you add in Parse Path to an existing Model Builder that already has operations and layers in it then the outputs will include "_path".
... View more
11-30-2023
02:05 PM
|
0
|
0
|
140
|
POST
|
I'm using the one available in the Model Builder "Utilities" drop down. I just did another test, if I have "test.tif" as my input and 1) use %Name% in the output function without Parse Path the output is literally "%Name%.tif" and 2) when I use Parse Path I get "test_tif" even with the "Format Name, Extension and Workspace" selected. Using %Name% works in the ArcPro batch function but I need to run multiple steps for 3000 rasters and have to ultimately add the file name as a field name to a zonal statistics table (<13 characters, which it won't be with the "_tif").
... View more
11-16-2023
12:57 PM
|
0
|
0
|
209
|
POST
|
I'm trying to use the Parse Path utility in Arc Pro 3.1.3 Model Builder but the tool is including the extension in the Name output. I've tried selected or unselecting the "Format Name, Extension and Workplace" option but I'm still getting the "_asc" which is causing an error when I try to use this for a field name: Input: .../raster2010apr.asc Parse Path Name: raster2010apr_asc In ArcMap the Parse Path utility gives the correct "raster2010apr" as the Name out put but not in Pro.
... View more
11-16-2023
10:26 AM
|
0
|
3
|
282
|
IDEA
|
@NaicongLi, Thank you for your thoughts. I think my suggestion boils down to this: the only option (now) when creating a new ArcGIS Pro project is to save all ArcGIS Pro project files (*.gdb, *.aprx, \ImportLog, etc) into one folder (either one directory as shown below, or each project into its own folder if "Create a new folder..." option is checked). I want an options where the *.APRX can be saved into a different location than (*.gdb, \ImportLog, etc). It's totally possible to SaveAS the *.aprx into another directory than where it was originally create, I just want this option at the start. Why should I have to litter my folders with all of the (*.gdb, \ImportLog, etc) for every project, or have all of my *.aprx buried in a million project folders (if "Create a new..." is checked) when the *.aprx is all I need to open ArcGIS Pro?
... View more
06-13-2023
03:41 PM
|
0
|
0
|
497
|
IDEA
|
We have dozens of client folders, each containing gis data for multiple projects for that client. In the past we could save the .mxd files in each client folder, search by date, etc. But now with Pro multiple files are necessary for each .aprx. I can’t designate one folder in Options because we have multiple client folders, and I can’t keep filling client folders with ArcPro .aprx and everything else. Seems like “save aprx in project folder” check box and/or a new .aprx location dialog box would be a solution.
... View more
05-19-2023
09:19 AM
|
0
|
0
|
533
|
IDEA
|
This is still a BIG problem. The ability to add hatching to a selected polygon has been implemented but highlighted points are still dim and not at all visible compared to other points. Especially when sharing a screen on TEAMs or Zoom.
... View more
04-27-2023
03:27 PM
|
0
|
0
|
1123
|
IDEA
|
Neither 1) hiding each APRX in a project folder or 2) filling a directory with different project geodatabases, tool boxes, etc are great options when creating a new ArcPro project. We were able to sort and find ArcGIS MXDs by date or at least see all of the different MXDs in one place, and these option could be possible if in the Create a New Project dialog box there was the option to save the APRX in a different location than the default project folder. The work around is to create a new project, saveas the APRX someplace else, and delete the original in the newly created folder, but this is cumbersome and not necessary. Quickly searching through all the project APRXs in one place would be ideal for many workflows.
... View more
04-24-2023
09:12 AM
|
0
|
6
|
617
|
POST
|
Have you found a solution? It seems like it's not possible to have both 1) Attached photos appearing in popup, and 2) configure popups in New Map Viewer. Which is another insane incompatibility that ESRI should have fixed before they launched New Map Viewer. Right now it seems like most (all?) Instant Apps require Map Viewer Classic to honor the popup configuration, but Map View Classic won't show attached photos, it only shows them as links.
... View more
03-24-2023
11:14 AM
|
0
|
0
|
105
|
IDEA
|
Should be available in My Content so we can sort by size and manage the content all in one place.
... View more
03-23-2023
03:10 PM
|
0
|
0
|
873
|
IDEA
|
ArcGIS.com consumes credits to store our data but we have no way of managing layers by size in My Content. There should be a disk usage or size column in the Table view. Edit (thank you magisian): Allow users to sort and filter content in by additional categories, such as credits, to better allow management of content through the My Content interface. This would allow our Creators to identify their larger items readily without requiring navigating to other parts of the ESRI universe to access to reporting, credit/storage usage, and status tools.
... View more
03-23-2023
02:35 PM
|
2
|
3
|
928
|
POST
|
Thank you. I think this is working. For anything with %Inspection it looks up last inspection, for anything 'maintenance' it adds the inspection frequency to 1/1/2023.
... View more
03-20-2023
03:42 PM
|
1
|
0
|
330
|
POST
|
Here is my code...I'm hung up on creating a large if structure when there could be a simple solution: //pulls inspection frequency in days var last = $feature.InspectFre var adddays = Decode(last,"Annual", 365, "3 years", 1095, "Weekly", 7,0) //establishes a start date for anything that doesn't have a previous inspection var start = Date(2023,0,1) //Pulls all inspection reports for this site var ordered = OrderBy(FeatureSetByRelationshipName($feature, "InspectionReports"), "i_site_date DES") var site = $feature.DBID var related = Filter(ordered, "DBID = @site") //there are three options, 'maintenance', 'septic inspection', and 'holding inspection'. The same calculation happens below, but I want to update from the singular 'Inspection' to either 'septic inspection' or 'holding inspection' so we pull just the inspection reports, order them, and count them. var type = "Inspection" var relatedfeatures = Filter(related,"Report_type = @type") //calculates next inspection date var info = First(relatedfeatures) var cnt = Count(relatedfeatures) var relatedinfo = iif(cnt > 0, Text(DateAdd(info.i_site_date,adddays,'days'), "MM/DD/Y"), Text(DateAdd(start,adddays,'days'), "MM/DD/Y")) return relatedinfo
... View more
03-20-2023
01:43 PM
|
0
|
0
|
340
|
Title | Kudos | Posted |
---|---|---|
1 | Thursday | |
2 | 03-23-2023 02:35 PM | |
1 | 03-20-2023 03:42 PM | |
6 | 04-26-2022 10:42 AM |
Online Status |
Offline
|
Date Last Visited |
Thursday
|