ADA Compliance Application
In 2008, FHWA requested that RIDOT create a project-specific reporting database to provide historic data regarding the Department’s past ADA initiatives. Turino worked closely with RIDOT to create two such databases: one captures ADA improvements identified within the scope of engineering design projects; the second catalogues ADA compliance information relevant to construction projects.
The Engineering Design Database identified specific ADA improvements (sidewalk alterations, curb ramp installations, APS modifications, etc.) within the scope of engineering design projects on a case-by-case basis and provided historic information and details for projects initiated between 2006 and 2013. The Construction Project Database provided the number of curb ramps installed and linear feet of sidewalks improved on in every construction project awarded between FY 2000 and FY 2013 (5,388 curb ramps and improved approximately 1,037,397 linear feet of sidewalk).
The project implementation process used by Turino was as follows:
- Geocode Quality Control
- Development of the New ADA Compliance Application
- Data Conversion from Access to SQL Server
- Integration with RIDOT’s GIS and PMP
- Testing, Training and Production Release
- Hosting and Migration to RIDOT/DoIT
The ADA Compliance information was stored in various Access databases amongst three consultants. Each consultant had their own version of the ADA Compliance database that allowed them to customize the data for their own reporting purposes. Although the data collection may have been the same across all three consultants, the fact that they were able to customize their own databases resulted in an inconsistent data repository. Moreover, the disparate databases did not allow RIDOT to generate statewide reporting with consolidated data from the three databases.
To ensure consistency in data entry and provide RIDOT the ability to generate statewide ADA reporting, Turino exported the data from these disparate access databases and consolidated them into a single SQL Server database. Once converted and stored in SQL Server, the data could be accessed by RIDOT and consultants through the web interface of ADA Compliance Application.
RIDOT now has a scalable system that will not require extensive technical support to maintain. Benefits include longer product life, minimal technical support, flexibility, accurate data, ease of data entry, and dynamic reporting. Specific functions on the new site include but are not limited to:
- Ability to add/edit new instance data
- Ability to status any legacy instance data
- Ability to edit geo data using Google Maps
- Ability to run statewide reports
- Ability to manage end-user information (system permissions, contact information, etc.)
- Ability to define ADA compliance requirements