Latest Contributions by BrianWade

When attempting to get a simple record count on 500+ processed features the GET COUNT tool works great as a quicker version of the SUMMERIZE tool, however it does not allow for a simple output to a table or a text file. I assume that through major gyrations of a combo of tools, this can be made this happen but I at this point have found a half work around. After the tools completion, I copy the results from the detail history pane into a text editor, delete the top few lines until I can run a macro that leaves me with:   filename.dbf count: 1000000 run a macro to bring the count onto the same line as the filename:   filename.dbf count: 1000000   and it’s ready to bring into Excel using the “:” as a delimiter.   Admittedly I don’t know much python however I assume this all can be accomplished with a couple lines of code.   Keep in mind my processed features each have thousands to millions of records so the summarize tool takes "forever" vs my workaround takes 5 minutes.   So, I think a count output to table or text at the completion of the GET COUNT Tool is an idea whose time has come. ... View more

Hi All At the end of a geoprocess, I have 25+ shapefiles with various large record counts. I would like to be able to get a quick listing of said counts (with filename for reference) into a database or csv for verification of what I am expecting during the processing.   I looked at Get Count, but I don’t understand how to get the results into a table that I can look at outside of ArcMap.   Preferably I would like to run it as a model or tool and the end of my processing and spit it out in the same place as my output shapefiles.   any help is appreciated   Thanks   Brian ... View more

Hi All   I'm looking for what I believe is a very simple process, but my brain block is getting in the way of my solution.   I would like to merge counties from a gdb filled with 2015 US Census County features into individual State features based on the State fips field within each county feature, i.e. 01,02,04 etc. into individual state features 01_counties, 02_counties etc.   I realize I can do this 54 times using geoprocessing tools, but I would like to do this in model builder so as to be able to use this process tool for future use with different variables.   I assume I can Iterate through the gdb to parse out or group by filename state fips and merge into new state files. each feature has a st fips as part of its filename i.e.   tl_2015_60010_counties, tl_2015_60010_counties, tl_2015_60010_counties tl_2015_69085_counties, tl_2015_69100_counties, tl_2015_69110_counties, tl_2015_69120_counties tl_2015_78010_counties, tl_2015_78020_counties, tl_2015_78030_counties   into state features:   tl_2015_60_counties tl_2015_69_counties tl_2015_78_counties   Ultimately, I’m looking to merge files based on a like portion of the filename via model builder. I’m sure it’s right in front of me but its Monday so I’m temporarily blind!   I understand Iteration tools, but the maybe collect values? I don’t understand if that fits into my question or not.   Thanks for any help   Brian. ... View more