Turning legacy into useable reality
Thesis Data (Tables Summary)
The Tables Summary was done before any other mapping could take place. This table
lists all known Thesis dBase tables (.dbf) and the columns within those tables. The
worksheet also notes if a specific Thesis table has any information relevant to migration.
Each individual table and column that was mapped (translated) to UADMS is noted in the
Comments Field of this worksheet. A sample of this worksheet (Table 1) is shown
below.
(Table 1)
| Thesis tableName |
column name |
data type |
width |
|
Comments |
| MANHOLE |
Manhole Details( Holds the core data relating to Manholes.) |
| MANHOLE |
ACCESSTYPE |
VARCHAR2 |
1 |
|
Mapped |
| MANHOLE |
CHAM_SIZE1 |
VARCHAR2 |
4 |
|
Mapped |
| MANHOLE |
CHAM_SIZE2 |
VARCHAR2 |
4 |
|
Mapped |
| MANHOLE |
COVERLEVE L |
VARCHAR2 |
7 |
|
Mapped |
| MANHOLE |
COVERSHAPE |
VARCHAR2 |
1 |
|
Mapped |
| MANHOLE |
COVER_DUTY |
VARCHAR2 |
1 |
|
Mapped |
| MANHOLE |
ENTRY_TYPE |
VARCHAR2 |
1 |
|
Mapped |
| MANHOLE |
GEN_NUMBER |
VARCHAR2 |
10 |
|
link to graphics and connected pipes |
| MANHOLE |
MANHOLENO_ |
VARCHAR2 |
10 |
| Mapped |
| MANHOLE |
MANHOLEUSE |
VARCHAR2 |
1 |
|
Mapped |
| MANHOLE |
MANSTATUS_ |
VARCHAR2 |
2 |
|
Mapped |
| MANHOLE |
MATERIAL__ |
VARCHAR2 |
1 |
|
Mapped |
| MANHOLE |
OPEN_SIZE1 |
VARCHAR2 |
4 |
|
Mapped |
| MANHOLE |
OTHER_TYPE |
VARCHAR2 |
4 |
|
Mapped |
| MANHOLE |
OTHER_TYPE |
VARCHAR2 |
7 |
|
not used |
| MANHOLE |
QUALITY___ |
VARCHAR2 |
1 |
|
not used |
| MANHOLE |
SHAF_SIZE2 |
VARCHAR2 |
4 |
|
Mapped |
| MANHOLE |
SLAB_TYPE_ |
VARCHAR2 |
1 |
| Mapped |
| MANHOLE |
STATUS____ |
VARCHAR2 |
1 |
|
Mapped |
| MANHOLE |
TYPE______ |
VARCHAR2 |
2 |
|
used to determine feature type---mapped |
| MANHOLE |
YEAR_BUILT |
VARCHAR2 |
4 |
|
Mapped |
| MANHSURV |
Manhole Survey Details( Holds manhole condition details) |
| MANHSURV |
BENCHING__ |
VARCHAR2 |
1 |
|
Mapped |
| MANHSURV |
CHAMB_COND |
VARCHAR2 |
1 |
|
Mapped |
| MANHSURV |
COVER_COND |
VARCHAR2 |
1 |
| Mapped |
| MANHSURV |
DEPTHSILT |
VARCHAR2 |
3 |
|
Mapped |
| MANHSURV |
DIST1_____ |
VARCHAR2 |
10 |
|
not used |
| MANHSURV |
DIST2_____ |
VARCHAR2 |
10 |
|
not used |
| MANHSURV |
DIST3_____ |
VARCHAR2 |
10 |
|
not used |
| MANHSURV |
GEN_NUMBER |
VARCHAR2 |
10 |
|
link to graphics
and connected pipes |
Attribute Data Mapping
As stated in the PDM discussion, the target data model was built with Thesis in mind and
most Thesis features have a one-to-one correspondence with UADMS tables. Where
UADMS has separate tables for each feature, Thesis does not. As stated, Thesis is a
manhole-based system and, as such, stores all node features as manholes. Manholes in
Thesis hold attributes defining what type of node feature they really are. Within the data
mapping effort, this meant that one Thesis table "manhole" could be mapped to several
UADMS tables.
