Integrated Sign Management System ADOT Maintenance Group;Final rept. Apr 02-Jul 03

摘要

The Arizona Department of Transportation maintains and manages an inventory of roadway signs. Before the implementation of this project, sign technicians maintained inventory records on individual laptops to track their daily sign maintenance activities. Each individual laptop contains sign file data that pertained only to the installed signs within the area in which the sign technical worked. It was difficult to share information and generate management reports. In addition, some sign regions did not even use their laptops to maintain the inventory records for their signs, but used paper forms to complete their daily work. To meet this challenge, ADOT has developed an application to: Track the installation, maintenance and replacement of all ADOT roadway signs; Provide for the maintenance of data pertaining to the attributes of all ADOT roadway signs statewide; Satisfy the dynamic business requirements, especially in the area of predicting sign replacement by allowing the database design to easily incorporate other factors into the prediction formula.