MECHENG401

EPICS

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

• https://genoupe.se.auckland.ac.nz/svn/opensource/Archivista

Project Management

• PM outline and description

Current Key Task

Member Tasks

• Mid year report!
• Complete IEP Forms.

Design Notes

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

• Things to do

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

Mailing List

Current Mailing list

References

JavaScript libraries used

Development notes

Development Notes

Installer

Notes on Installer