I'm new to ArcGIS, or at least anything beyond the basics, especially ArcToolBox. so the answer might be extremely simple.
Basically I have one layer of building footprints, and another layer of parcel data.
Many residential parcels contain multiple buildings, one of which is the house (coded in field BTYPE as 401) and one or more accessory buildings (BTYPE 999). each building footprint has a height attribute.
What I'd like to do is highlight parcels that contain a 401 footprint and a 999 footprint, but only the parcels where the height of the 999 footprint is higher than the height of the 401 footprint.
I have no idea how to do this.. I have tried a spatial join between the two layers but all that gets me is a count of the footprints on the parcel. I don't need the exact answer but a rough outline of steps that I need to take to accomplish this would be welcome.