Roads and Maritime Services (RMS) is a NSW State Government agency established on 1st November 2011. It is a delivery agency responsible for implementing strategy and delivering customer focused services in a cost effective manner. RMS aims to build and maintain roads; conduct driving tests; issue licences and registrations; and oversee harbours and waterways, to create a streamlined customer focused organisation to deliver essential frontline services to people who use roads, harbours and waterways.
Under the Intelligent Access Program (IAP) framework, certified service providers are responsible for monitoring heavy vehicles and mobile cranes against their condition of access to the road network in NSW. If a monitored vehicle breaches their condition of access, the certified services provider must generate what is known as an NCR (non-compliance report) and forward to RMS for assessment, investigation and enforcement action.
Intergy built a web based tool to analyse the Non Compliance Reports (NCRs) for heavy vehicles, with data coming from the Intelligent Access Compliance Database (IACD). Intergy used Google Maps API to show vehicle routes, approved routes and restricted bridges, and trend analysis, with appropriate colour coding for easy visual analysis of the data. The new system provided a significant increase in processing speeds, an automated workflow and trend analysis capabilities.
Intergy developed web based application for internal users to login and analyse various NCRs. NCRs plotted using Google Maps and Google Chrome were very effective for client analysis and reporting. The application has various functionalities such as:
- NCR Data – All the NCR data is extracted from the existing Intelligent Access Compliance Oracle Database. A custom package was built to export the data from the Oracle database, transform and store it in local MySQL tables for reporting purposes.
- Management of valid routes and vulnerable assets – The NCRs need to be analysed against valid routes and vulnerable assets information. This information was available in various file formats. The user has the ability to upload these files into the web application, and illustrating the NCR which contains routes and vulnerable assets layers on a Google map platform.
- NCR Report – This particular reporting interface renders the NCR detail and position records into Google maps enabling the review of the non-compliant route travelled by the vehicle. This report has various search categories such as vehicle plates, schemas, operators, NCR Id, Status, and time period.
- Density Report – It illustrates the trend analysis of NCRs for a given period of time using the combination of categories such as vehicle plates, schemas, operators, Status and time period.
- Printing – A Print function allows the user to print NCRs and Density reports in a pre-defined template directly from the browser.
The Google Maps API was used for NCR and Density Reporting.