Latest Contributions by JustinWolff

‎08-06-2025

Thank you, Laura, I think that's the route I'm going to have to go.

‎08-04-2025

We have a hosted feature layer in AGO containing one (1) polygon feature class, and three (3) tables with multiple relationships: Tracts (Polygon) -> 1:Many -> Tract Notes (Table), relationship fields OBJECTID -> TractGUID Project (Table) -> 1:Many -> ProjectNotes (Table), relationship fields OBJECTID -> ProjectGUID Project (Table) -> 1:Many -> Tracts (Polygon), relationship fields OBJECTID -> ProjectGUID So one Tract may have multiple TractNotes records, one Project may have multiple ProjectNotes records, and one Project may have multiple Tract features. In Experience Builder, I would like to filter the Project table on the 'Project Name' field, and have it also work against the Tracts polygons in the map. Ideall, the Edit widgets configured to add records to Tracts, TractNotes and ProjectNotes would default the ProjectGUID values in Tracts and ProjectNotes. We are currently using a Survey widget to add polygon features, pulling geometry and some attributes from another map layer, and an Edit widget to add records to the TractNotes and ProjectNotes tables. I'm hung up on the initial Project filter - how do I configure a Filter to work against related records? Based on what I'm finding elsewhere in Community this may not be an option? Thanks

‎03-06-2025

Thanks Glen, that works well. As a follow-on, my test data only has one layer [0]. I'll have other situations where there are multiple sublayers. I'm a bit confused how to use gis.content to return the separate layers. Any help pointing me in the right direction is appreciated. Thanks again.

‎03-05-2025

and if I use field_to_add outside of any brackets it completes without any errors but doesn't add any fields feature_layer.manager.add_to_definition({"fields":field_to_add}) with the print statements as they currently are: Field 'newfield1' will be added. Field 'newfield2' will be added. Field 'newfield3' will be added. [{'name': 'newfield1', 'alias': 'New Field 1', 'type': 'esriFieldTypeInteger'}, {'name': 'newfield2', 'alias': 'New Field 2', 'type': 'esriFieldtypeInteger'}, {'name': 'newfield3', 'alias': 'New Field 3', 'type': 'esriFieldtypeInteger'}] {'name': 'newfield1', 'alias': 'New Field 1', 'type': 'esriFieldTypeInteger'} {'name': 'newfield2', 'alias': 'New Field 2', 'type': 'esriFieldtypeInteger'} {'name': 'newfield3', 'alias': 'New Field 3', 'type': 'esriFieldtypeInteger'} Am I missing something in the field definition?

‎03-05-2025

That gives the same error, except it doesn't add the first field, when left out of brackets: feature_layer.manager.add_to_definition({"fields":fields_to_add_list}) And does not create the first field when placed in brackets: feature_layer.manager.add_to_definition({"fields":[fields_to_add_list]}) but gives a bit different error: Exception: Unable to add feature service layer definition. Invalid definition for System.Collections.Generic.List`1[ESRI.ArcGIS.SDS.FieldInfo] Unable to cast object of type 'System.Object[]' to type 'System.Collections.Generic.IDictionary`2[System.String,System.Object]'. (Error Code: 400)

‎03-05-2025

I'm attempting to add new fields to a hosted feature layer if they don't already exist. Currently my code will add the first field in the list (dictionary), but then fails with the message: Exception: Unable to add feature service layer definition. Invalid definition for System.Collections.Generic.List`1[ESRI.ArcGIS.SDS.FieldInfo] Object reference not set to an instance of an object. (Error Code: 400) If it's run a second time it does not add the second field and gives the same error. I added the sleep thinking it may help but it doesn't. Any suggestions appreciated. Thanks. from arcgis.gis import GIS from arcgis.features import FeatureLayer import time username = '' password = '' gis = GIS("<url>", username, password, verify_cert=False) item_id = "<item_id>" feature_layer_item = gis.content.get(item_id) feature_layer = FeatureLayer.fromitem(feature_layer_item) #feature_layer = FeatureLayer.fromitem(feature_url) fields = feature_layer.properties.fields existing_field_names = [field.name for field in fields] new_fields = [ {"name":"newfield1", "alias": "New Field 1","type": "esriFieldTypeInteger"}, {"name":"newfield2", "alias": "New Field 2","type":"esriFieldtypeInteger"}, {"name":"newfield3", "alias": "New Field 3","type":"esriFieldtypeInteger"} ] fields_to_add_list = [] # this is named 'list' but is actually a dictionary for new_field in new_fields: if new_field["name"] not in existing_field_names: fields_to_add_list.append(new_field) print(f"Field '{new_field['name']}' will be added.") else: print(f"Field '{new_field['name']}' already exists.") for field_to_add in fields_to_add_list: print(field_to_add) feature_layer.manager.add_to_definition({"fields":[field_to_add]}) time.sleep(20)

‎02-04-2025

Thanks @AndreasHall - I've have an indicator to give me total attachments (see below), but I just need a list with a count for every feature/record. I'm drawing a blank today... var portal = Portal('https://------.maps.arcgis.com'); var assets = FeatureSetByPortalItem( portal, 'item_id', 0, ['*'], false ) var photo_count = 0 for(var feat in assets){ photo_count += Count(Attachments(feat)) } return photo_count

‎02-03-2025

I've discovered the hard way that the Arcade function Count(Attachments($feature)) cannot be used in a Field Maps Calculated Expression to automatically update and return a count of the attachments, because the attachments can't be counted until the record is submitted. Fine. Is there a way to display the number of attachments per record in a Dashboard List? I cannot figure out how to make this work. I'm doing all of this in AGO using hosted data. Any chance @jcarlson has done something like this? Thanks

‎11-12-2024

Thank you erica_poisson. I am attempting to use this in a survey to collect new features for an internal 'GeoGuessr' style game for GIS Day. When I enter a duplicate value, it does not identify it as being duplicate until the very end of the survey, not at the beginning as anticipated. Everything else is working, but it doesn't provide an error message until the end of the survey. Attached is a sanitized .xlsx to remove our URLs/IDs, etc. and a screenshot of the data for reference and the messages we receive during (after!) entry. I think I'm missing something small/basic somewhere... Thanks for any help! /* * JavaScript functions for Survey123 */ function returnFeatures(map_user, token, debugmode) { // Output value. Initially set to an empty string (XLSForm null) let outValue = ""; let layerURL = "https://<our service url>"; let response =""; // Set up query parameters let f = "f=json"; let where = `where=map_user='${map_user}'`; let outFields = "outFields=*"; let returnGeometry = "returnGeometry=false"; let returnCount = "returnCount=1"; let parameters = [f,where,outFields,returnGeometry,returnCount].join("&"); let url = `${layerURL}/query?${parameters}`; if (token){ url = url + "&token=" + token; } // Create the request object let xhr = new XMLHttpRequest(); // Make the request. Note the 3rd parameter, which makes this a synchronous request xhr.open("GET", url, false); xhr.send(); // Process the result if (xhr.readyState === xhr.DONE) { if (xhr.status !== 200) { // The http request did not succeed return "bad request: " + url } else { // Parse the response into an object response = JSON.parse(xhr.responseText); if (response.error) { return (debugmode? JSON.stringify(response.error):""); } else { if (response.features[0]) { return "That Player name is already taken, please enter a different name." //JSON.stringify(response.features[0]); } else { if (map_user !== "") { return "Player name entered."} //(debugmode? "No Features Found":""); } } } } }

‎06-12-2023

Is there a way to create a point symbol callout with a leader tangent to the point symbol, in my case a circle? In the attached image I'd like to display the callout leader like the markup in red. Thanks

‎06-12-2023

jschuckert - This was a while ago, and under a previous employer, but I believe I used the output .csv from the code above as input to arcpy.conversion.TableToTable, and specified a field map which contained all the necessary fields. -Justin

‎05-01-2023

Thanks GK. I was trying this earlier, but $map isn't recognized, and I'm not sure how to define it as a variable, if it's possible. I no longer have access to ArcGIS Assistant but would be curious to look at the .json of the Dashboard List element in ArcGIS Assistant Beta. Maybe that would have a clue how a 'default' Dashboard element is referencing the $map.

‎05-01-2023

Hello, I have an Arcade expression put together for a Dashboard List, using FeatureSetByPortalItem to reference a Portal feature service. The purpose is to create a list that sorts tracts by the latest date in any of three date type fields. Because this is directly referencing the source feature service, and not the web map in the Dashboard, several Actions are unavailable, including 'Show Popup' and 'Zoom'. Instead of using FeatureSetByPortalItem(<Portal>,<Portal Item ID>), is there a way to reference the layer from a web map, or otherwise define the popup so that can be displayed as an action? Below is the Expression referencing the Portal feature service item and layer directly. I just can't use this to zoom or display a pop-up. var portal = Portal(<portal>); var fs = FeatureSetByPortalItem(portal,"<id>",<layer>,['*'],false); var date_dict = { fields: [{name: "MaxDate", type: "esriFieldTypeString"},{name: "Tract", type: "esriFieldTypeString"}], geometryType: "esriGeometryPolygon", features: [], }; var acq_sql = "Appraisal IS NOT NULL and Survey IS NOT NULL and Opinion IS NOT NULL"; var acq_filter = Filter(fs, acq_sql); for (var feature in acq_filter){ var max_appr = Number(feature['Appraisal']) var max_surv = Number(feature['Survey']) var max_titl = Number(feature['Opinion']) var tract_num = (feature['tracts']) var max_date = Text(Max(max_appr, max_surv, max_titl)); Push(date_dict.features, {"attributes": {"MaxDate": max_date,"Tract": tract_num},geometry: Geometry(feature)}) }; var newFeature = FeatureSet(Text(date_dict)); var orderFS = OrderBy(newFeature, 'MaxDate desc') return orderFS A temporary workaround I have set is an action from this data expression list to filter another list using the same filter criteria but sorted by 'tracts'. Users have to click twice, but that's not a huge deal - would be nice to be one click though.

‎04-18-2023

Using ArcGIS Pro 2.9.5 Advanced and file geodatabase for all data workspaces. I have a model built using an iterator to perform various geoprocessing on input polygon geometry*, where the goal is output in a table where each row contains beginning and end x/y coordinate pairs, which will be used elsewhere outside of the model to create line features. Following geoprocessing of the input shapes, I'm perform four Sort functions on a table to get the minimum or maximum value for a specific field, then a Get Field Value to capture that first record from the sort for each of the four Sorts. This is where I get stuck: I'm currently using the Get Field Value results, followed by Collect Values and exporting those results to separate tables, then merging the four tables together. The result is close to what I need, but I need to dissolve the records together but am not sure how with a standalone table. Because this is within an iterate, ideally I could just use the four Get Field Values and use those to calculate fields in another table (where each iteration calculates on the same record) - but I cannot figure out how to do that. Perhaps I'm approaching this wrong altogether, or perhaps there's a way to use Pandas to dissolve/melt the merged table output...I'm stuck. Any help would be appreciated. Thanks *I am manually merging parcel data together by PLSS section, and then using this model builder process to create PLSS quarter section lines based on the geometry of the merged parcels. The model builder iteration is to perform the various geoprocessing section-by-section. The desired result is for cleaner cartographic displays where at least the section lines and parcel boundaries are coincident. So far this model is only focused on the West-East quarter section lines. If I can get it working I'll expand it to also create South-North lines as well.

‎03-10-2023

I'm not great with Arcade and stumped. I'm trying to create a pie chart in a Dashboard based on two date fields, 'Ordered' and 'Received'. Records are either null or populated with the date ordered or received. I'd like the pie chart to show counts of Ordered and Received. I think I need to use the GroupBy function, but I'm not sure what I'm doing. Thanks. var p = <portal>; var tracts = FeatureSetByPortalItem(Portal(p),<item>, <id>, [ 'OBJECTID', 'Name', ‘Ordered', 'Received', ], false ); var count = GroupBy(tracts, [ // fields/expressions to group statistics by { name: ‘Ordered', expression: 'Received IS NOT NULL'}, { name: ‘Received', expression: 'Received IS NULL'} ], [ {name: 'Ordered', expression: '1', statistic: 'COUNT'} ]); return(count)

Online Status	Offline
Date Last Visited	‎08-06-2025 06:29 AM

My Ideas

Latest Contributions by JustinWolff

Re: Filter map layer and related tables

Filter map layer and related tables

Re: Adding multiple fields to hosted feature layer

Re: Adding multiple fields to hosted feature layer

Re: Adding multiple fields to hosted feature layer

Adding multiple fields to hosted feature layer

Re: Show Attachment Count per Record in Dashboard List

Show Attachment Count per Record in Dashboard List

Re: Stop Survey123 Entry if Duplicate Project ID Entered

Tangent point symbol callout leader?

Re: replace commas from .csv

Re: Arcade expression Feature Set from Map

Arcade expression Feature Set from Map

collapse records in standalone table (Model Builder)

GroupBy null Date and not null Date pie chart

Re: replace commas from .csv

MAX Date GROUP BY id in Model Builder

Re: error handling and cursors

Re: arcpy.da.UpdateCursor too few parameters

Re: new users unable to login to Portal after 10.7...