I made a shapefile into 1,040,000 grids by the tool, create fishnet. This shapefile has an attribute table including 7 fields and 1,040,000 rows. What I want to do is to make a model which can let me get some "values" that I would like to extract.( I am sorry that I don't know how to describe these "values" in a sentence. I will explain it in the following description.)
Its fields are like this:
Aspect (Long): 1, 2, 3, 4, 5
Slope (Long): 1, 2, 3, 4, 5, 6, 7, 8, 9, 10
Curvature (Long): 1, 2, 3, 4, 5, 6, 7
Rainfall 1hr (Double): 89.9, 100, 120, 140, 160, 160.1
Geology (Text): RockA, RockB, RockC, RockD, RockE
Distance (Long): 0, 1000, 2000, 3000, 4000, 5000
Rainfall 3hr (Double): 239.9, 320, 400, 480, 560, 640, 720, 800, 800.1
I am trying to fill in the tables below(this picture does not include all the tables that I want to fill in. It is just part of all the tables):
For the yellow cell in the first table. I should fill in the row number,or you can say the grid number, with attribute "Aspect = 1" and "Slope = 1". For other cells in those tables, they have the same meaning.
I will do this search for all the 7 fields two by two. So, I will need to complete [(6+1)*6]/2 = 21 tables.
Up to now, I have built a simple model that uses tool Select Layer by Attribute, Get Count, and Collect Values. By using this simple model, I can get the values of a column in one search. But I think it is still too time-consuming.
The below pictures indicates the values extract from one of my model. After running my model I will type these numbers into my table by hands.
I am also curious if one can extract these values into .txt or excel files. Then, it will be much easier and convenient for me. I know there is a similar question here(Exporting data from Collect Values output in ArcGIS ModelBuilder?). I have tried it successfully. However, I can only get the values for "one column" written for each search, similarly.
I hope someone could teach me how to do this search more efficiently, such as getting the values for two fields in one search.
I hope my explanation is clear enough. Any suggestions are welcome.
أكثر...
Its fields are like this:
Aspect (Long): 1, 2, 3, 4, 5
Slope (Long): 1, 2, 3, 4, 5, 6, 7, 8, 9, 10
Curvature (Long): 1, 2, 3, 4, 5, 6, 7
Rainfall 1hr (Double): 89.9, 100, 120, 140, 160, 160.1
Geology (Text): RockA, RockB, RockC, RockD, RockE
Distance (Long): 0, 1000, 2000, 3000, 4000, 5000
Rainfall 3hr (Double): 239.9, 320, 400, 480, 560, 640, 720, 800, 800.1
I am trying to fill in the tables below(this picture does not include all the tables that I want to fill in. It is just part of all the tables):
For the yellow cell in the first table. I should fill in the row number,or you can say the grid number, with attribute "Aspect = 1" and "Slope = 1". For other cells in those tables, they have the same meaning.
I will do this search for all the 7 fields two by two. So, I will need to complete [(6+1)*6]/2 = 21 tables.
Up to now, I have built a simple model that uses tool Select Layer by Attribute, Get Count, and Collect Values. By using this simple model, I can get the values of a column in one search. But I think it is still too time-consuming.
The below pictures indicates the values extract from one of my model. After running my model I will type these numbers into my table by hands.
I am also curious if one can extract these values into .txt or excel files. Then, it will be much easier and convenient for me. I know there is a similar question here(Exporting data from Collect Values output in ArcGIS ModelBuilder?). I have tried it successfully. However, I can only get the values for "one column" written for each search, similarly.
I hope someone could teach me how to do this search more efficiently, such as getting the values for two fields in one search.
I hope my explanation is clear enough. Any suggestions are welcome.
أكثر...