I believe what you want is a way to link a geometric object with data.
Click on an object, a geometric shape representing a cage, cab or rack, then a row within a table is highlighted, where the row contains information such as square footage occupied. You also want the capability to go in the opposite direction, click on a row in the table and the geometric object is highlighted in modelspace, where modelspace is a 'map' of the Data Center. The ability to link data, more specifically attribute data, with a geometric entity, more specifically an entity geospatially referenced against the real world, is the core of GIS.
Object-to-Data OR Data-to-Object.
Each Row represents a record or a geometric entity--each individual cage, cab or rack would have its own row. Each Column represents a piece of data, e.g. ID number, square feet occupied, owner, date installed, last service date, date to be replaced, etc., etc., etc.
Once your data is established you can maintain it. This involves knowhow and labor hours, but keep in mind, whoever 'maintains it' is in control. (You want to control the data, not let the data control you.)
The Data Table is powerful and should never be ignored. You can run queries which will allow you to perform analyses. Examples:
- You create a list based on square footage each object occupies. You compare the list with lease agreements of your customers to find out if you are overcharging or undercharging rent, since rent is based on square footage. You can even take it further by finding out whether certain 'areas' within the data center commands a higher price--the high rent neighborhood.
- You create a list based on the date equipment is to be replaced. You can plan major hardware replacement and avoid untimely shutdowns which may cost you and your clients money.
- You create a list that collects the locations of equipment that require service calls. You may isolate the area(s) and look at room temperature to see whether it is air flow related.
- You look at trends and upticks. You make predictions. You make plans for the cages, cabs and racks. You make plans for your plans.
Data is golden. While your effort is admirable, you can't replicate this in vanilla Cad. You need more horsepower. Using a hyperlink is like using a wheelbarrow when you really need a dump truck. Sure, you can move dirt using a wheelbarrow, but is it efficient? Will your clients notice a difference in efficiency? Will a colleague down the hall from you, or a competitor, create a comparable drawing using more eloquent commands and be able to achieve the same or better results?
Chicagolooper
