POST
|
Hello, I do a lot of proximity analysis using "select by location" and would like to cut down on the effort spent each time doing this! I have put together a model using model builder that iterates over features in a feature layer (source layer), selects features in a separate target layer based on the set parameters, and then uses summary statistics to summarize over a certain field. Where I'm getting caught up is in making this as general/customizable as possible. I've attached a screen shot of my model thus far. I have two issues I'm running into: 1) I've set the "statistics field" of the Summary Statistics tool as a model parameter. However, when I go to run this model through ArcToolbox, I set the target layer right after the source layer, but the statistics field isn't then populated with the list of potential fields from the target layer. The drop down menu remains blank. Is there a way to make all the target layer fields populate similarly to how they would if you were using the Summary Statistics tool alone and set an input layer? 2) Get Field Value gets the value of the first row of the specified field, but I do not know how to tell it to get the value of the field of what I just summarized on. So, in Summary Statistics, if I told it to get the SUM of a field called POPTOTAL, then I want the Get Field Value tool to grab the value from the new field called "SUM_POPTOT" in the output statistics. There should only be one row of data, so I don't need to worry about getting the correct row. I have "Field" set as a model parameter currently, but I don't think it needs to be. Any help would be much appreciated! I'm using ArcMap 10.1. I'm still new to model builder...I have some background in programming, so Python script would be fine (or maybe even better). Thanks!
... View more
03-05-2013
09:47 PM
|
0
|
0
|
504
|
POST
|
Hello, I'm sorry I didn't get back to you on this. I never got a notification that someone responded, and I had to move on to a different project for a while. I actually did end up finding something that works, but it's a little complicated (I don't quite understand all the parts yet), so I'm still wondering if there's an easy way to create a table from an iterative model where the the result of the analysis is stored along with the feature ID that the analysis was performed on each time. I'm using ArcMap 10.1, and the latest SP, I believe. I've included my model and some sample data. The target layer data ("residents per acre") was too large to attach. I was just using some simple population by block data from the 2010 Census. Hope this helps. Thanks!
... View more
03-05-2013
09:10 PM
|
0
|
1
|
2518
|
POST
|
Hello, I want to do something very similar to this, but I can't seem to get it working. My model selects a feature in a source layer, then uses "select layer by location" to select features from a target layer that have their centroid within 0.5 miles of the source layer. I then use "summary statistics" to sum over one field (in this case population) and "get field value" to grab that value. The problem I'm running into is creating a table from these values. I want to ensure that the calculated value is added to the correct record. So I created a dBASE table from the "PhaseICorridorsSplitTesting" layer and named it "LandUseAnalysis". I'd like to select the same record in the "LandUseAnalysis" table as was queried in the "iterate feature" function (using the FID/OID fields). I'm then using "Value (2)" as an in-line variable into the "calculate field" (though I'm not sure if this part is working since the tool stops before it reaches this point). It looks like that is what you are doing here, but I keep getting an "invalid SQL expression" at the "Select Layer by Attribute" tool. I've tried pretty much every combination: "OID" = '%Value%', "OID" = %Value%, no percent signs, etc. So, I guess my question is, what am I doing incorrectly, and what's going on behind the scenes of the model that you eventually got working? I have some programming experience but am pretty new to model builder. Thanks!
... View more
11-14-2012
08:45 AM
|
0
|
0
|
2518
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|