Joost_R Posted January 27, 2017 Share Posted January 27, 2017 I have a model with mass models and a landscape. For the mass model I've made an entire worksheet that gives me a lot of information instantly. Now I'm trying to find a way to do kind of the same thing for the landscape. I have made several classes ( private green, public green, water, hard surface,...) all in the same layer (landscape). I was wondering of it's possible to make a worksheet that gives me in one column the name of the class and in the other column the entire surface of all the polygons in that class? Thanks in advance! Quote Link to comment
Pat Stanford Posted January 27, 2017 Share Posted January 27, 2017 What kind of objects do you have in your different classes? If they are just polygons then what you want is relatively easy. If these instructions are not enough post a small sample file and I will see if I can send you back a working worksheet. In a blank worksheet, right click in a row header (1 ,2 ,3, etc. I usually start with 3 in case I want to go back and add information above later) and set it to be a Database Row. When the criteria dialog opens, Set the criteria to be Layer Is landscape and a second Criteria of Type is Polygon. Select cell A3 and type a formula of =C This will give you the name of the Class of each object in the database. Select Cell B3 and type a formula of =Area() This will give you the area of each object. Select any row in the database (3.1, 3.2, etc.) and then drag the SUM tile down to the Column A column Header. The database should now compact and you should have one row for each Class. Next to it in column B should be the total area. Hope this gets you started. 1 Quote Link to comment
Joost_R Posted January 30, 2017 Author Share Posted January 30, 2017 This works perfectly, thanks!:) Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.