Latest Contributions by DavidSolari

What Profile are you running this Arcade code in? If this was for a map popup, you'd be better off using FeatureSetByName with the $map global to reference the other layers. For anything more complex, the Playground is the only way I know to test your expressions. Unfortunately the Playground can only access public data, so you'll either have to hunt down a set of public data that's close enough to your data, or create test data from scratch using the FeatureSet function. For what it's worth, I get the same "Verify test data" error in the playground so there might be a chance everything's working except accessing the data from AGOL, replacing that with test feature sets will help you isolate that issue. ... View more

To call the function "pdf" in the file "ExportPDF.py" in the folder "//spatialfiles2.bcgov/work/FOR/RNI/DPG/!Tenures/Templates/ExhibitA.Pro/Python" the technique is: import sys sys.path.append(r"\\spatialfiles2.bcgov\work\FOR\RNI\DPG\!Tenures\Templates\ExhibitA.Pro\Python") from ExportPDF import pdf   ... View more

You can run Excel to Table to an intermediate table, then tweak the schema as needed, then copy that to the final location ... View more

Getting data from another layer or table like that isn't allowed in label expressions to avoid performance issues. If you have access to Attribute Rules you can calculate a color every time the call sign changes and store it in a field, or even calculate the entire label ahead of time. If not, you can write a lookup table into the label expression and update it by hand as new data comes in. Something like: var color = "red='128' green='128' blue='128'"; var color_red = "red='255' green='0' blue='0'"; var color_white = "red='255' green='255' blue='255'"; var lookup = { "A1": color_red, "A2": color_red, "B1": color_white, "B2": color_red }; var cs = $feature.call_sign; if (HasKey(lookup, cs)) { color = lookup[cs]; } return `<CLR ${color}>${cs}</CLR>` ... View more

I'll admit I didn't test this thoroughly but everything seemed to work in the ArcGIS Online map viewer. Field Maps has its own rendering engine so you'll have to do your own testing in there. Unless I've missed something, there's no way to configure this without Pro so you'll have to avoid symbology edits outside of there, so make sure everyone's happy with the rest of the symbols before you hit production. Good luck! ... View more

What version of Pro are you using? Manually created relationships that use GUID types used to be flaky but I'm on Pro 3.1 and I've created dozens of them with zero issues. Simply ensure the origin/parent item has GlobalIDs enabled and the destination/child item has a GUID type field. Then create the relationship class and pick the appropriate fields. Note that GlobalID to GlobalID won't work as the relationship can't override any existing values here. ... View more

I'm on the same version of Chrome and I can't get the AGOL Map Viewer to trigger that error. More concerningly, the bug referenced in that message has been fixed a decade ago. Try some other maps (even if it's jsut a basemap) and try using other computers, I have a feeling your old Quadro is bugging out a bit. ... View more

If you're already querying every web map in your org, why not build a comprehensive table? from arcgis.gis import GIS, Item def build_layer_lookup(portal: GIS, query: str = "*") -> dict[Item, list[tuple[str | None, str | None]]]: retval = {} for web_map in portal.content.search(query, item_type="Web Map", max_items=10000): retval[web_map] = [] data = web_map.get_data() for layer in data.get("operationalLayers", []) + data.get("tables", []): retval[web_map].append((layer.get("itemId", None), layer.get("url", None))) return retval portal = GIS("Pro") lookup = build_layer_lookup(portal) table = [] for web_map, layers in lookup.items(): for layer_id, layer_url in layers: table.append((layer_id, layer_url, web_map.id)) ... View more

That function returns a FeatureSet object which the popup appears to have trouble with. There's probably a way to turn that into popup friendly data, but chances are you just want one address's data or an aggregate of address data based on the feature selected. Try something like this: var addresses = FeatureSetByName($map,"Civic Addresses",['full_address'], false); var filter_value = $feature.my_field; var address = First(Filter(addresses, "full_address = @filter_value")); // Replace with a proper SQL statement return address.full_address ... View more

Does the tool work better if you add that feature class to a map as a layer, then use the layer specifically? I've found using Select By Attribute/Location on feature class paths is flaky. ... View more

Ah, you want to convert a database to an Enterprise Geodatabase, this built-in tool should be what you need. ... View more

For a single feature, you can open the Edit Vertices tool, select one vertex in the list, hit Ctrl+A to select them all, then use the Z button to set the height for every vertex at once: DavidSolari_0-1738082396400.png If you have to do this for a ton of features I can't find an obvious tool for you. There's probably a way to use arcpy with Cursors and Geometry objects to write your own. ... View more

If it's not a method listed in the documentation I doubt you can get a connection going. ... View more