Develop an algorithm/script that processes buildings in an area into a meaningful object

[SirPolaris]

For gameplay, we require an algorithm/script that is capable of compiling all the relevant data surrounding a building, into a complete summarized table.

This summary table should be filled with ‘objects’. These objects should be designed in such a way that it is easy to process and query this format. This process will run once per major map update, or on demand by analysis tools.

Expected Results
The desired result is to have the SQL database produce an result set that summarizes the area of selection for all its buildings. A compound table should be built, simulating a building object. The object may not be complete – and defaults will need to be designed. These tables will be pushed to the client for offline rendering and cached for clipping in part when needed by the client.