|
Here's one way to do it that is pretty easy, though SQL could automate it further. - Make sure your powerline is in a separate drawing and create a buffer around it. Or put the buffer in a separate drawing. Doesn't matter how you do this really, just make sure that you have a drawing where the only "area" object in it is the buffer around your powerline.
- Make sure the transfer rules for your property drawing are set. Presumably, each property has a taxlot ID number or some other unique identifier. Set the transfer rules on that column to "Copy" for "1 to N" and to "Sample" for "N to 1" (we won't need the latter, but you have to set it to something). This will ensure the column doesn't get zero'd out when you transform the drawing. I'll assume this is a taxlot ID.
- Now, duplicate the property drawing. Rename this to "Overlap".
- Create a map component. Add to that map the "overlap" drawing and your buffer.
- Use the transform toolbar to create intersections: [All objects in Overlap] Clip with (intersect) [All objects in Buffer]
- You now have little areas where the buffers and the properties overlap. If your transfer rules were set up properly, these areas should still have their original taxlot IDs (or what ever unique identifier was set up for them).
- Now, the unintuitive part. Property lines aren't perfect rectangles so you might have L- or U- shaped properties where the buffer intersects the property multiple times. You need to group these discontinuous areas by taxlot ID. Go to "Drawing -> Dissolve" and select the taxlot ID column. Your little intersection areas are now multi-branched areas (grouped by taxlot ID).
Now you have a drawing called Overlap with just the overlap portions, and your original drawing of the properties. There are a number of ways you can get area percentages from this. You can use SQL to join the two drawings on taxlot ID and divide the area of "Overlap" by the area of the original property column. Or you can open the "Overlap" table and create a relationship between it and the original property table on the taxlot ID column, then create an active column to divide the two areas. I think the SQL approach is better. Something like this: SELECT O.LotID, O.[Area (I)]/L.[Area (I)]*100 FROM [Overlap Drawing] AS O INNER JOIN [Lots Drawing] AS L ON O.LotID=L.LotID See attached. Attachments: powerlinebuffers.map
|