Hi everyone,
I do a lot of catchment area analysis with ArcMap to calculate demand overlaps for a given resource given the known production capacity of various facilities and the known resources needed for that capacity.
With the method I currently use I give the main facility I'm analysing in a region a buffer of, for example, 250km and then its surrounding/competing facilities buffers of, for example, 200km. I then take intersects of each of the buffers of the competing facilities with the buffer of the main facility and calculate the area of the intersect compared to that area of the competing facility buffer to work out a percentage overlap by using the measuring tool.
Obviously this is slow and tedious especially when I have 50 or more points that I need to calculate intersects for and I'm sure there must be a quicker way of doing it.
My first thought was to use VBA. I recently went on a VBA course for use with MS Office so I know how VBA itself works but am unfamiliar with any of the specific code that works with ArcMap. I was wondering if it would be possible to have a piece of code that takes all the buffers within a group layer with a preset name (e.g. "CompBuffers") and one by one calculate their overlaps with the buffer of the main facility in its own group layer, also with a preset name (e.g. "MainBuffer"), and then take those overlap percentages and display them as a table.
Would this be relatively easy to do and if so how would I get started with the VBA code? or is there an even easier solution to my problem?
Any help is greatly appreciated,
John