KDOT PMS Replacement Project

R-PMS Subsystem - AECOM : Package . AECOM-EPMS System : Package

Entity - GEOM link

Properties
Name Value
Data Model Physical
Stereotypes AECOMSystem
Schema AECOMSchema
Primary Key Clustered Unspecified
Unlogged false
Temporal false
Domain
 AECOM : Entity Domain

Columns Summary
Column Name Data Type PK / FK Nullable Description
AADT number(0) Yes

Average annual daily traffic (vehicles) per direction. Values less than zero indicate that the quantity is unknown.

CODE number(0) Yes

Route suffix. A value of 9 indicates turnpike

COUNTY number(0) Yes

Code that uniquely identifies the county.

<<Assumed a FK into a lookup table>>

EAL number(0) Yes

Average daily loading in the same units as those defined in EPMS for the second road category variable.

Values less than zero indicate that the quantity is unknown.

HVYCOMM number(0) Yes

Average daily heavy-commercial vehicle (i.e. truck) traffic (vehicles) per direction.

ID varchar2(255) PK No

Character string that uniquely identifies the road segment.

LANE number(0) Yes

Code that uniquely identifies the lane designation.

A value of zero indicates the road is undivided.

Otherwise, the road is divided.

MPBEG float(0) Yes

Start log point of segment (miles).

MPEND float(0) Yes

End log point of segment (miles)

RTNO number(0) Yes

Code that uniquely identifies the route.

RTTY number(0) Yes

Route class.

a value of 1 indicates a functional class of "Interstate",

values of 2 or 3 indicate a functional class of "Other"

SCHACT number(0) Yes

Number that uniquely identifies the scheduled action for the segment.

Foreign key to ACTION column in REHAB table

SCHYEAR number(0) Yes

Calendar year of scheduled action for the segment

SECLGT float(0) Yes

Length of segment (miles)

SHWDTL float(0) Yes

Width of left shoulder

SHWDTR float(0) Yes

Width of right shoulder

TYPEP number(0) Yes

Predominant pavement type as classified in the PMIS database.

Foreign key to PVMTNO column in PAVEMENT table

WDTP float(0) Yes

Paved width of segment (feet)

Relationships Summary
Name Begin End
  : Entity Domain Relationship
 GEOM : Entity
 AECOM : Entity Domain
  : Relationship
 GEOM : Entity
 FDIST : Entity
  : Relationship
 GEOM : Entity
 FWDGEOM : Entity
  : Relationship
 GEOM : Entity
 LMA : Entity
  : Relationship
 GEOM : Entity
 RDIST : Entity
  : Relationship
 GEOM : Entity
 REMLIFE : Entity
  : Relationship
 GEOM : Entity
 ROUGH : Entity
  : Relationship
 GEOM : Entity
 TRAFFIC : Entity

Columns Detail
Name Value
Name AADT
Description

Average annual daily traffic (vehicles) per direction. Values less than zero indicate that the quantity is unknown.

Default Value null
Type number
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name CODE
Description

Route suffix. A value of 9 indicates turnpike

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name COUNTY
Description

Code that uniquely identifies the county.

<<Assumed a FK into a lookup table>>

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name EAL
Description

Average daily loading in the same units as those defined in EPMS for the second road category variable.

Values less than zero indicate that the quantity is unknown.

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name HVYCOMM
Description

Average daily heavy-commercial vehicle (i.e. truck) traffic (vehicles) per direction.

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name ID
Description

Character string that uniquely identifies the road segment.

Type varchar2
Nullable false
Unique true
Primary Key true
Index true
Length 255
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name LANE
Description

Code that uniquely identifies the lane designation.

A value of zero indicates the road is undivided.

Otherwise, the road is divided.

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name MPBEG
Description

Start log point of segment (miles).

Type float
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name MPEND
Description

End log point of segment (miles)

Type float
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name RTNO
Description

Code that uniquely identifies the route.

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name RTTY
Description

Route class.

a value of 1 indicates a functional class of "Interstate",

values of 2 or 3 indicate a functional class of "Other"

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name SCHACT
Description

Number that uniquely identifies the scheduled action for the segment.

Foreign key to ACTION column in REHAB table

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name SCHYEAR
Description

Calendar year of scheduled action for the segment

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name SECLGT
Description

Length of segment (miles)

Type float
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name SHWDTL
Description

Width of left shoulder

Type float
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name SHWDTR
Description

Width of right shoulder

Type float
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name TYPEP
Description

Predominant pavement type as classified in the PMIS database.

Foreign key to PVMTNO column in PAVEMENT table

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name WDTP
Description

Paved width of segment (feet)

Type float
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Relationships Detail
Name Value
Name
From
 GEOM : Entity
To
 AECOM : Entity Domain

Name Value
Name
Foreign Key
FDIST
 ID : Column
Primary Key
GEOM
 ID : Column
To Multiplicity 1
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name
Foreign Key
FWDGEOM
 ID : Column
Primary Key
GEOM
 ID : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name
Foreign Key
LMA
 ID : Column
Primary Key
GEOM
 ID : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name
Foreign Key
RDIST
 ID : Column
Primary Key
GEOM
 ID : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name
Foreign Key
REMLIFE
 ID : Column
Primary Key
GEOM
 ID : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name
Foreign Key
ROUGH
 ID : Column
Primary Key
GEOM
 ID : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name
Foreign Key
TRAFFIC
 ID : Column
Primary Key
GEOM
 ID : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Appears In
Diagram
 KDOT_RPMS_EPMS(AECOM) : Entity Relationship Diagram
KDOT PMS Replacement Project