topic Re: Model Builder Tool that..... in Geoprocessing Questions

Model Builder Tool that.....

ShikoNjuno — Wed, 31 Jul 2013 16:50:58 GMT

Hi folks. I think this is an easy task but I'm not sure how to go about it.
I have a shapefile made up of polygons, and I'm trying to use just one of the fields from its attribute table.
Below is a copy of the attribute table:
[ATTACH=CONFIG]26355[/ATTACH]
And I need to know what tool would list the Field_Acre on Model Builder. This field will then be joined to another output table. I'm thinking something similar to the Get Field Value tool except instead of reporting just the first row value, the tool would output the entire field, just as shown in the attribute table.
Any suggestion welcome.
Thanks

Re: Model Builder Tool that.....

ShikoNjuno — Wed, 31 Jul 2013 20:13:10 GMT

Well, what I ended up doing is creating a raster file of the information held in that attribute table and then, using the Zonal Statistics as Table tool, I was able to get an output table with this (field area in acres) information.
If anyone knows a more direct way of listing field information from an attribute table using Model Builder, please let me know.
Cheers.

Re: Model Builder Tool that.....

ChristopherThompson — Thu, 01 Aug 2013 10:05:23 GMT

Well, what I ended up doing is creating a raster file of the information held in that attribute table and then, using the Zonal Statistics as Table tool, I was able to get an output table with this (field area in acres) information.
If anyone knows a more direct way of listing field information from an attribute table using Model Builder, please let me know.
Cheers.

Is there a reason you cannot simply use the Add_Join or Join Field tools (in toolbox these are under the DataManagement\Joins toolset) to join the table containing Field_Acre to the table you want this associated with? Creating a raster and generating a table as you have seems like a lot of additional steps and potentially extra storage costs depending on how big the dataset is.

Re: Model Builder Tool that.....

ShikoNjuno — Thu, 01 Aug 2013 14:57:07 GMT

When I try the Add Join tool, for some reason it deactivates the other Zonal Statistics as Table tools that are attached to the Shapefile.

The table to which the "Field_Acre" attribute field is to be joined will not join as the input and so therefore, the Selection Feature set shapefile must be the input. In doing so however, the other zonal tools lose the info. required to run.

Re: Model Builder Tool that.....

AliciaMein — Thu, 01 Aug 2013 18:14:09 GMT

When I try the Add Join tool, for some reason it deactivates the other Zonal Statistics as Table tools that are attached to the Shapefile.

The table to which the "Field_Acre" attribute field is to be joined will not join as the input and so therefore, the Selection Feature set shapefile must be the input. In doing so however, the other zonal tools lose the info. required to run.

I used the <Make Feature Layer> tool to get my feature class to a layer file for input into the <Add Join> tool. An extra step which seem ridiculous. If anyone knows a better workflow I would love to hear. The <Make Feature Layer> did work for me.

Re: Model Builder Tool that.....

ChristopherThompson — Thu, 01 Aug 2013 18:31:57 GMT

I used the <Make Feature Layer> tool to get my feature class to a layer file for input into the <Add Join> tool. An extra step which seem ridiculous. If anyone knows a better workflow I would love to hear. The <Make Feature Layer> did work for me.

This is a good point - there are many tools that require a feature layer rather than a feature class on disk in order to work. If you read the help for the Joins tools these specifically mention using a layer as opposed to a feature class. Its less clear to me about a stand alone table; if both your input datasets are feature classes try making feature layers out of them and see if that works for you.