Archive for the ‘Ministry of Transport’ Category

Fuel consumption database

Wednesday, February 10th, 2010

Business view: MoT, in conjuction with NZTA, required a Fuel Consumption Database to allow analysis of fuel consumption characteristics of the New Zealand vehicle (car) fleet, to increase public awareness of vehicle fuel consumption, and to provide a platform for tools that will encourage changes in vehicle choices.

Technical view: Creation of a SQL Server database containing fuel consumption test results, matched to NZ vehicles via LANDATA. Sourcing, extraction and cleaning of fuel consumption data (including from certificate images in Japanese) to populate the database.

Posted in 2004, Analysis, Architecture, Custom build, Data cleaning, Database, Formal project description, Government, Ministry of Transport, Service/Maintenance, Support | No Comments »

Fuelsaver for MoT

Saturday, January 30th, 2010

Business view: MoT, in conjuction with NZTA, required a site to help drivers understand how various factors – not least driving habits and the fuel efficiency of their vehicles contribute to their fuel costs.

Technical view: Design, usability testing, and creation of a PHP-based public website and ‘cost calculator’ application, retrieving data from the existing SQL Server Fuel Consumption Database via web services. Sourcing, cleaning and merging of data to support lookup and retrieval of information on new and used vehicles first registered in New Zealand after 2000.

Posted in 2006, Analysis, Architecture, Bartlett Projects, Custom build, Data cleaning, Database, Design, Formal project description, Government, HTML/CSS, Incremental improvement, Javascript, Ministry of Transport, Optimal Usability, PHP, Service/Maintenance, Support, Usability | No Comments »