Problem The problem faced by Dorset County Council was not that their system was not capable of storing the vast amount of drainage data but much of the data had not been added to the current asset management system and was simply in hard copy format (paper maps, CAD drawings). A second problem was that this data was not stored centrally but spread amongst stakeholders such as Private companies, Local Authorities, and Dorset County Council itself. Dorset County Council required one central database containing all of the information which could be shared across a network using Dorset Explorer and their current EXOR system. Solution After consultation between Dorset County Council and Wilson Pym May a new database structure was created in line with the needs of the client. It

Join for free to read