Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

parcel map with book valuesI've got a shapefile I would like to extract distinct values from an attribute field and have the output as tables based on those values.

The shapefile is made of polygons representing parcels and each parcel is categorized by a "book" value. I can extract a table for each book using the Table Select tool in Model Builder, however, I need to produce a table for each of the dozens of "book" values that make up this shapefile. This is basically a "select by attribute" problem but I will need to sort and produce output in the form of tables. I've attached a pdf of the Layer view and contents to help illustrate the problem.

My question is, what sql expression can I use in the Model Builder Table Select tool that will:

  1. Select and sort values based on an attribute field (in this case, by "book")
  2. Auto create tables for each category of values (i.e., 200, 209, 235)

I'm open to other model builder tools or methods but the "Table Select" method is the most direct approach, however, I can only create one table at a time - I need to create many in one shot.

Any help is greatly appreciated.

Galindo37

share|improve this question
    
Can you give a better example of what you want your end result to be? Do you essentially want to end up with one row that has the Book ID and another that has all of the values that correspond to that book ID separated by a comma? –  Craig Apr 2 '13 at 18:16
    
The end result should be a Table with the Book ID and all values associated with that book. For example, a table called "Book200" would contain all record values assoicated with "200", to include book page, number, sub-number and so forth like this: Book200, pg103,no 123,subno 005. Each color in the image I provided represents a region or "book" whereby hundreds of listing are represented within each region. I just need a way to automate my table selection based on the attribute value, in this case, on the attribute field "book" –  galindo Apr 2 '13 at 19:04

2 Answers 2

You can use Iterate Feature Selection option to loop through book classes and make a feature layer, from which you can export your table against.

share|improve this answer

You may want to look into creating a model using iterators. It looks like you can set up the tool to loop through all of the available book ids that you have and then build a model that exports each of those results to a table.

share|improve this answer
    
Do you have an example of the model export to table? –  galindo Apr 2 '13 at 20:29

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.