Roads and Maritime Services – Intelligent Access Compliance Database (IACD) Project – Analysis of NCRs Tool

Roads and Maritime Services – Intelligent Access Compliance Database (IACD) Project – Analysis of NCRs Tool Case StudyRoads 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.

The Solution

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 user interface and reporting was developed in Java J2EE with JSP/Javascript/JQuery. A MySQL database was used for data storage and retrieval with a batch module accessing an Oracle 10g database.

The Google Maps API was used for NCR and Density Reporting.

Book Free Consultation

Please leave this field empty.

  • Intergy was able to exceed our expectations and provide us with a significantly improved web...Read more..

    The Australasian College of DermatologyJacqueline SciancaleporeInformation Systems Officer
  • The College began working with Intergy at a stage when an earlier developer had reached the ...Read more..

    The Australasian College of DermatologyDr R M CorderoyDirector: Educational Development, Planning and Innovation
  • James and the team at Intergy partnered with TD to deliver successful e-Learning solutions f...Read more..

    Tactical DirectionsSamAccount Director
  • Intergy and Relief Software have developed a software application that has changed the way w...Read more..

    Ace Car FreightersPaul DolbyOperations Manager
  • Intergy did an amazing Job and we recommend them 100% as the full package deal. They are rea...Read more..

    Wholesale PumpsGabManager
  • Intergy Consulting has assisted in the development of a web based program customised for AFE...Read more..

    AFEA Pty LtdFreya TClient Services Manager
  • We would highly recommend Intergy to assist clients with quality, user-friendly web page des...Read more..

    Easy Care GardeningLyn GAdministration Officer
  • Southern Phone has found the responsiveness and speed of Intergy’s work refreshing. With t...Read more..

    Southern Phone CompanyPhil HGeneral Manager
  • Intergy ensures our IT systems advance and keep pace with our business growth.

    Picture Media Pty LtdJo TDirector
  • Intergy provides critical support and development services for Speed-E-Gas. In particular In...Read more..

    SPEED-E-GAS (NSW) Pty LtdShane BOffice Manager
  • Intergy Consulting has helped develop the Purchase Order Management System for KONE Elevator...Read more..

    KONE Elevators Pty LtdKabirul HNEB Supply Manager
  • Our new platform is straight forward to use, the communication and training has been superio...Read more..

    Thalgo Australia (BLC Cosmetics)Fiona ColesMarketing & Communications Manager
Intergy Menu