Download Auckland Transport

Auckland Transport – Database Operations Manual
4.7.7
64
•
Pocket RAMM or similar device if this is your preferred method of data capture.
•
RAMM data collection forms (or equivalent).
How is the Database Updated?
The Pavement Layer Data Dictionary (appended) provides additional guidance to database
managers who have read/write access to the RAMM Pavement Layer Table. The database
can be updated using 2 methods:
•
Importing data from spreadsheets, validating and moving to the Carriageway
Surfacing Table (preferred method for loading large amounts of data on new road
construction where the new pavement layers have no effect on existing data as
typically there is no existing data).
•
Manual addition, updating and deleting of Pavement Layer records in RAMM for
Windows (preferred method as most new pavement layers on existing roads will
affect existing layers in some way).
In addition to the above two methods there is a tool called the Pavement Builder. Before
using this tool you should be totally familiar with what it does and be prepared to do a
check at the end to see that the outcome was what was expected. Also be aware that no
other database administrators can touch the Pavement Layer Table while you are using the
tool as it locks the table.
Updating existing pavement layer records as a result of pavement layer reconstruction
projects can be complicated. The preferred way to undertake this work is in RAMM for
Windows, viewing the pavement layer data for each affected record in grid view, than
updating in detail view. When the pavement layer records are updated, always view the
data again in grid view to ensure there are no overlaps or gaps in the pavement layer data.
It is important that a clear understanding and knowledge of how the pavement was built,
including the sequence of activities is known prior to updating the Pavement Layer Table.
4.7.8
How Can This Database Operations Manual Help You?
Accompanying this Table Overview are the following sections:
|
•
RAMM Pavement Layer Data Collection Guide Notes and FAQ’s (Section 4.7.9) includes diagrams and illustrations around standard pavement layer data collection
conventions to ensure the data is collected consistently in the field. Some typical
FAQ’s are also provided.
•
Pavement Layer Data Dictionary (appended) - provides a column by column
description of the Pavement Layer Table including what data is required, how it is
collected, entered and managed, and what are the allowable values.
Auckland Transport