I would recommend a trigger on your Salesforce object. As soon as that record is being inserted, or updated, or deleted we add, or update the Base Element, Physical location based on the location name.
All related fields can be part of the mapping.
You could achieve something similar with process builders or flow. All depends on expertise/skills.
Hope this helps.