Latest Contributions by SarahHartholt

‎03-02-2022

Hi Kim, Thanks for bringing this to my attention. My append tool was missing the Query to only append Where IssueLicense is equal to 'yes', which is now honored when I run the model. I am wondering if it is possible to only append features if they don't fall within a distance of an existing point? i.e. if I run my model multiple times, address points are appended even though they already exist in the dataset. I've tried to use the If Spatial Relationship Is tool as a precondition to append but it hasn't worked with my current set up. Or is there another way to achieve this?

‎03-01-2022

I'm attempting to use the If Field Value Is logical tool to append an AddressPoint to an ApprovedLicense feature class only if the IssueLicense field is 'yes'. My current workflow includes reading in the AddressPoint feature class and iterating over the ID field. I perform some calculations on the feature including populating the IssueLicense with 'yes' if a series of conditions are met. I run my model and stop it after a few iterations to see if it is performing as expected. The field calculations return correct values but I can see that the first 6 address points are appended to my ApprovedLicense feature class even though only 3 have 'yes' values in the IssueLicense field. Can someone tell me why this is happening?

‎02-25-2022

I'm wondering if it's possible to re-map the source of my location feature class when errors pop-up in an excel sheet that contains an embedded ArcGIS for office map. I recently had to establish a connection between my excel table and location feature class from scratch (I had 2 polygon layers on ArcGIS Online and I think deleted the one that was connected to my excel sheet). Each time I do this I have to manually update my layer style including the attribute that I want the features to symbolize on and the symbol fill/outline. Is there a way to re-map the feature class source like we can do in ArcGIS Pro? i.e. go to the layer properties and Set Data Source. After re-establishing the connection to my AGOL layer and updating the symbology, I attempted to fix some of my map errors by adding missing polygons to my feature class on ArcGIS Online. I've added 1 new feature to AGOL but still see the error in my excel sheet! Does this mean that I have to re-map my connection again?! Can someone please let me know if there is a better way to updated my location source layer? I would like to establish a more efficient way to update my excel sheet/AGOL features.

‎02-24-2022

Wondering if you have successfully implemented this in a model? I'm attempting to use the If Spatial Relationship Is and If Field Value Is tools to append an AddressPoint to an ApprovedLicense feature class only if the AddressPoint is more than 5 meters from an existing ApprovedLicense and the IssueLicense field contains the value 'yes'. Any pointers would be appreciated. I would like to see the the process did not execute because the precondition is false error message but I can see that the processes are being executed (they change from yellow to red in the ModelBuilder window) when they should evaluate to False. More details on my issue here: If Spatial Relationship and If Field Value Is tool... - Esri Community

‎02-24-2022

Does anyone have examples of successfully using the If Spatial Relationship is and If Field Value Is tools that they can share? They do not seem to be working as expected. My current workflow: -use the If Spatial Relationship is tool to read in a feature that is being iterated (AddressPoint) where AddressPoint is Within a Distance (5m) of ApprovedLicense. If True do nothing. If False: - use as a precondition to the If Field Value Is tool. Use the If Field Value Is tool to read in the feature that is being iterated (AddressPoint) Where IssueLicense is equal to 'yes'. If False do nothing. If True: - use as a precondition to Append the AddressPoint to the ApprovedLicense feature class If I run my model multiple times I see that multiple address points at the same location are appended to my ApprovedLicense feature class. Why does this occur? My If Spatial Relationship Is tool should prevent the same address from appending multiple times because it is within 5m of an existing record (i.e. 10 main st. should be appended the first time the model is run, but never again as it would be within 5m of 10 main st. that now exists in the feature class).

‎02-23-2022

Solved my own problem using a combination of Logical tools (If Spatial Relationship Is, If Field Value Is) Examples of using logical tools in ModelBuilder—ArcGIS Pro | Documentation

‎02-23-2022

The process needs to be created within my current model since its existence in my LicenseApproved feature class is directly related to the value assigned to the IssueLicense attribute (yes, no) of the other points in my AddressPoint feature class. This is how my model currently works: 1. iterate AddressPoint feature class 2. calculate the number of licenses (LicenseApproved feature class) that already exist within the neighbouhood and populate the LicenseCount attribute field 3. calculate the IssueLicense field (if more than 20% of homes in the neighbourhood already have a license IssueLicense = 'no', if less than 20% of homes already have a license IssueLicense = 'yes') 4. append the point to my LicenseApproved feature class if IssuedLicense = 'yes' and is not within 5m of an existing point in the LicenseApproved feature class If I don't include step 4, licenses will be approved for too many addresses. i.e. in a neighborhood of 10 homes, home A is approved for a license (1/10 = 10%). If home B applies for a license they should be denied (home A & B = 2/10 homes in the neighborhood with a license = 20%). BUT if home A has not been appended to the LicenseApproved feature class the calculation in step 3 will not know that the license for home A exists and will give one to home B.

‎02-23-2022

I've been mulling over some ideas about how to add another process to a model I've created that contains an iterator. My model currently uses a series of arcade expressions to calculate attribute values in a point feature class. Next, I would like to do the following: 1. see if the value in the IssueLicense field is 'yes' 2. if IssueLicense == 'yes', see if the point falls within 5m of a point in another point feature class (LicenseApproved) 3. append the point to a new feature class if there are no LicenseApproved points within 5m Any advice on tools/calculations that I could potentially use would be appreciated!

‎02-18-2022

I'm trying to create a similar model. I would like to iterate through a table of address points, select all addresses that fall within x distance of that address point, sum the number of dwellings (this is different than the total number of address points as some may be a duplex, triplex etc.) and write this back to the address point that is currently selected in my iteration. My model fails on the calculate tool. I'm not sure if my arcade expression is incorrect or if it's even possible to write to the selected address. My understanding is that the selected address is a view of the layer and not the layer itself..? (the tool help page states: Selected Rows is a table view that can be used in other geoprocessing tools that accept a table view in ModelBuilder) Here's my arcade expression (the error I receive is invalid expression Table not found ParcelinBuffer which definitely exists in my test.gdb): var ParcelinBuffer = FeatureSetByName($datastore,"ParcelinBuffer",["NumRU_RDU_FRU"], True); Return SUM(ParcelinBuffer.NumRU_RDU_FRU);

‎02-17-2022

I'm using ArcPro 2.9.0 and am trying to use the "memory\mydata" format to join 2 layers in ModelBuilder. The documentation clearly states that I should not add a file extension. However, when I enter "memory\JoinParcelstoTable" to the Output Dataset box and click away ".shp" is automatically added to the end of my in memory folder path. When I try to run my model it fails on this tool. Any insights would be appreciated.

‎02-17-2022

Hi there, I'm using ArcPro 2.9.0 and am trying to use the "memory\mydata" format to join 2 layers in ModelBuilder. The documentation clearly states that I should not add a file extension. However, when I enter "memory\JoinParcelstoTable" to the Output Dataset box and click away ".shp" is automatically added to the end of my in memory folder path. When I try to run my model it fails on this tool. Any insights would be appreciated.

‎02-17-2022

Hi there, Not sure if this applies to you, but I know that models that I have created to run on a schedule only execute when I am logged into my computer so you may need to schedule it for a time that you are signed. In my screen capture you can see that my model is scheduled to run at noon everyday but does not run on weekends when I am not signed into my work computer.

‎02-16-2022

Can someone let me know which arcade global variable to use for accessing in memory features and attributes? I'm creating a model in ArcPro 10.9.0 that will select address points within a buffer poylgon that I have stored in memory. I would like to transfer a field from my buffer polygon to my address point field.

‎02-16-2022

Thank you, this is very close! I've added the "Get Field Value" utility to access my buffer distance but now I can't seem to reference it in the "Select Layer by Location" tool. Perhaps I need to iterate through my address feature class first so that it will create the selection using a single address point.

‎02-15-2022

I'm in the process of building a model using ArcPro 2.9.0 to run some analysis on a number of features (address points, parcels & zoning). What I would like to do is iterate through each of the points in my address layer, calculate a search radius based on the zoning, and then select all address points within that buffer distance to perform additional analysis. I've created an arcade expression to add the buffer distance to my attribute table based on the zoning layer (i.e. residential = 500m, commercial = 1000m). My next step is to select the surrounding address points that fall within the buffer. How would I accomplish this using my buffer attribute field? I am trying to avoid unnecessarily writing tens of thousands of buffer polygons to a feature class in my geodatabase.

Online Status	Offline
Date Last Visited	‎09-09-2022 04:36 PM

My Ideas

Latest Contributions by SarahHartholt

Re: Modelbuilder If Falue Field Is

Modelbuilder If Falue Field Is

re-map feature source

Re: The model is Running a false statement with empty values while the correct statement is running as it should

If Spatial Relationship and If Field Value Is tool help

Re: iterate feature selection and determine whether to append it to another feature class

Re: iterate feature selection and determine whether to append it to another feature class

iterate feature selection and determine whether to append it to another feature class

Re: How to iterate through attribute table, perform geoprocess, then add data to new table

Re: In memory workspace

Re: In memory workspace

Re: ArcGIS Pro - Task Schedule on ModelBuilder not running

arcade global to access in memory feature attribute

Re: Modelbuilder - select features within a buffer distance using arcade

Modelbuilder - select features within a buffer distance using arcade

Re: ESRI World Locator Service URL

Re: How to ensure transparent background when expo...

Re: Modify/Update Feature Geometry

Re: Utilities Symbology in ArcGIS Online

Re: FROM and TO information for line segment