MECHENG401
Database solution for the Auckland City Council
Group Members
| Mark | — | mgar059 |
| Nick | — | nirv002 |
| Shaun | — | sseo004 |
Timetable
Project and deliverables Timetable
Project Proposal
Presentation
Code Repository
Project Management
Current Key Task
- Mid year report!
- Complete IEP Forms.
Description
From the EPICS webpage, projects for 2008:
New Project: Software development for seismic assessment of Auckland buildings:
Client: Auckland City Council
Aim:To write software that can store the details of each building - address, age, type of construction etc. It will then run an existing algorithm (currently done via desk top paper, pen and calculator) to check the building and determine if it requires a more comprehensive seismic assessment.
Further development: The ability to sort the data - i.e. how many of the total building set are of a given age, or of a certain risk category. Aim: better data about the characteristics of NZ's earthquake risk buildings.
Longer term: to interface program with GIS software: cross-check geotechnical ground conditions, seismic maps, water mains. ACC are interested in sharing it around NZ so that we could perhaps eventually have a digital capture of all the earthquake risk buildings in NZ.
Academic staff mentors
Assoc. Prof. Jason Ingham
Department of Civil and Environmental Engineering
j.ingham AT auckland.ac.nz
Dr Gerald Weber, Software Engineering
gerald AT cs.auckland.ac.nz
More details:
The Auckland City Council (ACC) requires a database system designed and developed, in which to store photographs, plans, numerical data and text for assessment of the earthquake safety of buildings in the Auckland city area.
This project will investigate various open-source/free database solutions to determine the most suitable. An application and database will be designed and developed to record this information and carry out analysis of it to generate reports. Investigation will be conducted into the future needs of such a system in terms of expansion and integration with other systems. Eventually the system could be used by all the councils in New Zealand
Tasks
| Week | Task | % Completed |
| 2 | Research on AIR,Gears and Lotus notes | 100 |
| 3 | Research on databases and web frameworks | 80 |
| 19 | Final implementation tasks | 0 |
Requirements
Meetings
| Date | Title |
| Initial student+mentor meeting | |
| 11 March | 11 March |
| 19 March | 19 March |
| 31 March | Second plenary meeting |
| 3 April | SE technology meeting |
| 7 April | group meeting |
Stuff worth reading
Research on Gears and SQLite as given in Research on databases and web frameworks
Comparison of Google Gears and AIR
Summary of the software decisions made to date
Using Google Gears to synch data with a server DB. Uses Ajax, html, php and gears