View Full Document

9 views

Unformatted text preview:

Problem solved w JOIN The Problem In the Nature study I suggested that the Schools would prefer a 50 50 split between Forest and Ag cover The solution to this common problem That is how to compute percentages of cover elevation values slope values for polys in a FC like Tax Parcels Assumptions This works best with data in GDB but as long as you are willing to keep calculating Areas it will work with standalone Shapefiles There are scripts for area calculation GDB is the better option however How to do it To solve the problem of cover types in parcels you need to Intersect Cover input and Tax Parcels intersect features could use Union as well Aside If you are working with FCs that have large attribute tables you need to do the following Copy the FC into a new GDB Review the fields properties Get rid of those you do not need by unchecking their check boxes actually easier to un check all and then check the ones you want o keep This just makes life easier How to do it To solve the problem of cover types in parcels you need to Intersect Cover and Tax Parcels Result is that each Parcel is broken into 1 or more polys based on Cover Like this Parcel 91294 is selected The intersection created one multipart poly of 5 parts But did not include the poly with the same code at the lower right Multipart Poly Intersection table Total area Stats So far So good How do we calculate what each intersect poly is on a per parcel basis Remember you can t calculate BETWEEN records Where is the parcel area Its is the Tax Parcel FC Duh Parcel Area Its in the Tax Parcel data OK how to get it into the Intersect table JOIN the Attribute table of the Intersection layer with the Table of Tax Parcel data based on Parcel id This is a one to many join Which means that the parcel record is joined to every record in the intersect layer that has the same ID Now Oops minor detail You have to create a new float field to the intersect table BEFORE you do the join You can t be in edit mode to create the



Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view PROBLEM SOLVED WITH JOIN and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view PROBLEM SOLVED WITH JOIN and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?