The National Academies Press

Currently Skimming:

Pages 59-73

The Chapter Skim interface presents what we've algorithmically identified as the most significant single chunk of text within every page in the chapter.
Select key terms on the right to highlight them within pages of the chapter.

From page 59... ... 59 A p p e n d i x C This appendix documents the activities completed under SHRP 2 Project S04A for Task 5 (Database Design and Specification) , which is aimed at developing the technical specifications and supporting management components for the SHRP 2 Roadway Information Database (RID) Read the entire page →
From page 60... ... 60 I-95, US-1) are then stored as linear events of the framework route. Read the entire page →
From page 61... ... 61 Simple feature class nodes Contains Z values Contains M values Geometry Point No No Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls Nodes OBJECTID Object ID Shape Geometry Yes Long integer Yes 0 Unique Identiﬁer Simple feature class Routes Contains Z values Contains M values Geometry Polyline Yes No Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls Routes OBJECTID Object ID Shape Geometry Yes Long integer Yes 0 Unique identiﬁer Long integer Yes 0 Parent Route identiﬁer ROUTENAME String Yes 64 Route Name ROUTEBASE String Yes 64 Base Route Name LENGTH Double Yes 0 0 Length of the route FRMEASURE Double Yes 0 0 From Measure TOMEASURE Double Yes 0 0 To Measure ONEWAY Short integer Yes 0 Is the route one way? Simple feature class links Contains Z values Contains M values Geometry Polyline No No Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls Links OBJECTID Object ID Shape Geometry Yes LINKID Double Yes 0 0 Unique Identiﬁer Double Yes 0 0 From Node ID Double Yes 0 0 To Node ID NAME String Yes 64 Road Name DIR_TRAVEL String Yes 2 Travel Direction (F, T or B) Read the entire page →
From page 62... ... 62 Table LRMPosition Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls LRM Positions on Routes OBJECTID Object ID GUID No 0 0 38 Unique identiﬁer RouteID Long integer No 0 Route identiﬁer FrMeasure Double No 0 0 From measure ToMeasure Double No 0 0 To measure SideOfRoad String No SideCode 1 Side of Road OﬀsetReferent Short integer No 0 Referents 0 Lateral Oﬀset Referent OﬀsetDir Short integer No 0 0 Oﬀset direction OﬀsetDistance Double No 0 0 0 Oﬀset distance Length Double Yes 0 0 0 FrX Double Yes 0 0 Point or start of polyline x coordinate FrY Double Yes 0 0 Point or start of polyline y coordinate ToX Double Yes 0 0 End of polyline x coordinate ToY Double Yes 0 0 End of polyline y coordinate LocationMethod Short integer Yes LocationMethod 0 Data locationmethod PositionID Polyline length Figure C.2. S04A LRMPosition table. Read the entire page →
From page 63... ... 63 Table LRMPosition Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls LRM Positions on Routes OBJECTID Object ID GUID No 0 0 38 Unique identiﬁer RouteID Long integer No 0 Route identiﬁer FrMeasure Double No 0 0 From measure ToMeasure Double No 0 0 To measure SideOfRoad String No SideCode 1 Side of Road OﬀsetReferent Short integer No 0 Referents 0 Lateral Oﬀset Referent OﬀsetDir Short integer No 0 0 Oﬀset direction OﬀsetDistance Double No 0 0 0 Oﬀset distance Length Double Yes 0 0 0 FrX Double Yes 0 0 Point or start of polyline x coordinate FrY Double Yes 0 0 Point or start of polyline y coordinate ToX Double Yes 0 0 End of polyline x coordinate ToY Double Yes 0 0 End of polyline y coordinate LocationMethod Short integer Yes LocationMethod 0 Data location method PositionID Polyline length Table AspectType Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls Aspect Type OBJECTID Object ID Short integer No 1 0 Unique identiﬁer Name String No 32 Name of the Aspect FieldTypeID Short integer No 1 FieldTypes 0 Aspect data ﬁeld type GeometryTypeID Short integer No 1 GeometryTypeID 0 Aspect geometry type DomainTypeID Short integer Yes DomainTypes 0 Aspect domain RangeMin Double Yes 0 0 Minimum range value RangeMax Double Yes 0 0 Maximum range value CodedValueTable String Yes 128 Coded Value Domain table name UseOﬀset Short integer Yes TrueFalse 0 Use LRM oﬀset? Table Aspect Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls Aspect OBJECTID Object ID AspectID GUID No 0 0 38 Unique identiﬁer GUID No 0 0 38 Identiﬁer of the LRMPosition Short integer No AspectTypes 0 Aspect Type ID ValueNumeric Double No 0 0 Aspect numeric value ValueText String No 32 Aspect text value ValueDate Date No 0 0 8 Aspect date value Comment String Yes 255 Comment SourceID String Yes 32 Source of the data DataSourceID Short integer No 1 DataSource 0 ID of the source record DataDate Date Yes 0 0 8 Date of the source record AspectTypeID LRMPositionID AspectTypeID Figure C.4. Read the entire page →
From page 64... ... 64 Table LRMPosition Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls LRM Positions on Routes OBJECTID Object ID GUID No 0 0 38 Unique identiﬁer RouteID Long integer No 0 Route identiﬁer FrMeasure Double No 0 0 From measure ToMeasure Double No 0 0 To measure SideOfRoad String No SideCode 1 Side of Road OffsetReferent Short integer No 0 Referents 0 Lateral Oﬀset Referent OﬀsetDir Short integer No 0 0 Oﬀset direction OffsetDistance Double No 0 0 0 Oﬀset distance Length Double Yes 0 0 0 FrX Double Yes 0 0 Point or start of polyline x coordinate FrY Double Yes 0 0 Point or start of polyline y coordinate ToX Double Yes 0 0 End of polyline x coordinate ToY Double Yes 0 0 End of polyline y coordinate LocationMethod Short integer Yes LocationMethod 0 Data location method PositionID Polyline length Table Barrier Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls Barrier OBJECTID Object ID BarrierID No 0 0 38 Unique Identiﬁer No 0 0 38 Identiﬁer of the LRMPosition BarrierTypeID Short integer No 1 BarrierType 0 Barrier Type StartTreatmentTypeID Short integer Yes 1 BarrierTreatmentType 0 Treatment Type at the start of the Barrier EndTreatmentTypeID Short integer Yes 1 BarrierTreatmentType 0 Treatment Type at the end of the Barrier PostMaterialID Short integer No BarrierPostMaterial 0 Post Material RubrailPresent Short integer Yes 1 TrueFalse 0 Is a Rub Rail present? Comment String Yes 255 Comment SourceID String Yes 32 Source of the data DataSourceID Short integer No 1 DataSource 0 ID of the source record DataDate Date Yes 0 0 8 Date of the source record LRMPositionID Figure C.5. Read the entire page →
From page 65... ... 65 Table LRMPosition Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls LRM Positions on Routes OBJECTID Object ID GUID No 0 0 38 Unique identiﬁer RouteID Long integer No 0 Route identiﬁer FrMeasure Double No 0 0 From measure ToMeasure Double No 0 0 Tomeasure SideOfRoad String No SideCode 1 Side of Road OﬀsetReferent Short integer No 0 Referents 0 Lateral Oﬀset Referent OﬀsetDir Short integer No 0 0 Oﬀset direction OﬀsetDistance Double No 0 0 0 Oﬀset distance Length Double Yes 0 0 0 FrX Double Yes 0 0 Point or start of polyline x coordinate FrY Double Yes 0 0 Point or start of polyline y coordinate ToX Double Yes 0 0 End of polyline x coordinate ToY Double Yes 0 0 End of polyline y coordinate LocationMethod Short integer Yes LocationMethod 0 Data location method Table Intersection Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls Intersection OBJECTID Object ID GUID No 0 0 38 Unique identiﬁer ControlTypeID Short integer No 1 IntersectionControlType 0 Intersection Control Type Approaches Short integer No 4 0 Number of approaches to the Intersection Comment String Yes 255 Comment SourceID String Yes 32 Source of the data DataSourceID Short integer No 1 DataSource 0 ID of the source record DataDate Date Yes 0 0 8 Date of the source record Table RouteIntersection Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls Route Intersection RouteIntersectionID GUID No 0 0 38 Unique identiﬁer GUID No 0 0 38 Identiﬁer for Intersection GUID No 0 0 38 Identiﬁer for LRMPosition OBJECTID Object ID IntersectionID LRMPositionID PositionID IntersectionID Polyline length InterectionNumApproaches Figure C.6. S04A intersections data model. Read the entire page →
From page 66... ... 66 Table LRMPosition Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls LRM Positions on Routes OBJECTID Object ID GUID No 0 0 38 Unique identiﬁer RouteID Long integer No 0 Route identiﬁer FrMeasure Double No 0 0 From measure ToMeasure Double No 0 0 To measure SideOfRoad String No SideCode 1 Side of Road OﬀsetReferent Short integer No 0 Referents 0 Lateral Offset Referent OﬀsetDir Short integer No 0 0 Oﬀset direction OﬀsetDistance Double No 0 0 0 Oﬀset distance Length Double Yes 0 0 0 FrX Double Yes 0 0 Point or start of polyline x coordinate FrY Double Yes 0 0 Point or start of polyline y coordinate ToX Double Yes 0 0 End of polyline x coordinate ToY Double Yes 0 0 End of polyline y coordinate LocationMethod Short integer Yes LocationMethod 0 Data locationmethod PositionID Polyline length Table Lane Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls Lanes OBJECTID Object ID LaneID GUID No 0 0 38 Unique identiﬁer GUID No 0 0 38 Identiﬁer for the LRMPosition Width Double No 0 0 Lane width ThroughLanes Short integer Yes 0 0 Number of Through Lanes LeftTurnLanes Short integer Yes 0 0 Number of Left Turn Lanes RightTurnLanes Short integer Yes 0 0 Number of Right Turn Lanes CenterTurnLane Short integer No 0 0 Number of Center Turn Lanes AccelerationLane Short integer No 0 0 Number of Acceleration Lanes DecelerationLane Short integer No 0 0 Number of Deceleration Lanes AccelDecelLane Short integer No 0 0 Number of Acceleration/Deceleration Lanes Comment String Yes 255 Comment SourceID String Yes 32 Source of the data DataSourceID Short integer No 1 DataSource 0 ID of the source record DataDate Date Yes 0 0 8 Date of the source record BikeLane Short integer Yes 0 Number of Bike Lanes LRMPositionID Figure C.7. S04A lanes data model. Read the entire page →
From page 67... ... 67 Table LRMPosition Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls LRM Positions on Routes OBJECTID Object ID GUID No 0 0 38 Unique identiﬁer RouteID Long integer No 0 Route identiﬁer FrMeasure Double No 0 0 From measure ToMeasure Double No 0 0 To measure SideOfRoad String No SideCode 1 Side of Road OﬀsetReferent Short integer No 0 Referents 0 Lateral Oﬀset Referent OffsetDir Short integer No 0 0 Oﬀset direction OﬀsetDistance Double No 0 0 0 Oﬀset distance Length Double Yes 0 0 0 FrX Double Yes 0 0 Point or start of polyline x coordinate FrY Double Yes 0 0 Point or start of polyline y coordinate ToX Double Yes 0 0 End of polyline x coordinate ToY Double Yes 0 0 End of polyline y coordinate LocationMethod Short integer Yes LocationMethod 0 Data locationmethod PositionID Polyline length Table Location Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls Location OBJECTID Object ID LocationID No 0 0 38 Unique Identiﬁer No 0 0 38 Identiﬁer of the LRMPosition Grade Double Yes 0 0 Road grade CrossSlope Double Yes 0 0 Road cross slope Comment String Yes 255 Comment SourceID String Yes 32 Source of the data DataSourceID Short integer No 1 0 ID of the source record DataDate Date Yes 0 0 8 Date of the source record LRMPositionID Figure C.8. S04A locations data model. Read the entire page →
From page 68... ... 68 Table LRMPosition Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls LRM Positions on Routes OBJECTID Object ID GUID No 0 0 38 Unique identiﬁer RouteID Long integer No 0 Route identiﬁer FrMeasure Double No 0 0 From measure ToMeasure Double No 0 0 Tomeasure SideOfRoad String No SideCode 1 Side of Road OﬀsetReferent Short integer No 0 Referents 0 Lateral Offset Referent OffsetDir Short integer No 0 0 Oﬀset direction OﬀsetDistance Double No 0 0 0 Oﬀset distance Length Double Yes 0 0 0 FrX Double Yes 0 0 Point or start of polyline x coordinate FrY Double Yes 0 0 Point or start of polyline y coordinate ToX Double Yes 0 0 End of polyline x coordinate ToY Double Yes 0 0 End of polyline y coordinate LocationMethod Short integer Yes LocationMethod 0 Data location method PositionID Polyline length Table Shoulder Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls Shoulder OBJECTID Object ID ShoulderID GUID No 0 0 38 Unique identiﬁer GUID No 0 0 38 Identiﬁer of the LRMPosition ShoulderTypeID Short integer No 1 ShoulderType 0 Shoulder Type Width Double No 0 0 ShoulderWidth Comment String Yes 255 Comment SourceID String Yes 32 Source of the data DataSourceID Short integer No 1 DataSource 0 ID of the source record DataDate Date Yes 0 0 8 Date of the source record LRMPositionID Figure C.9. S04A shoulders data model. Read the entire page →
From page 69... ... 69 Table LRMPosition Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls LRM Positions on Routes OBJECTID Object ID GUID No 0 0 38 Unique identiﬁer RouteID Long integer No 0 Route identiﬁer FrMeasure Double No 0 0 From measure ToMeasure Double No 0 0 To measure SideOfRoad String No SideCode 1 Side of Road OﬀsetReferent Short integer No 0 Referents 0 Lateral Oﬀset Referent OﬀsetDir Short integer No 0 0 Oﬀset direction OﬀsetDistance Double No 0 0 0 Oﬀset distance Length Double Yes 0 0 0 FrX Double Yes 0 0 Point or start of polyline x coordinate FrY Double Yes 0 0 Point or start of polyline y coordinate ToX Double Yes 0 0 End of polyline x coordinate ToY Double Yes 0 0 End of polyline y coordinate LocationMethod Short integer Yes LocationMethod 0 Data locationmethod PositionID Polyline length Table SignAssembly Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls Sign Assembly OBJECTID Object ID GUID No 0 0 38 Unique identiﬁer GUID No 0 0 38 Identiﬁer of the LRMPosition NumSigns Short integer No 1 0 Number of Signs on the Assembly SourceID String Yes 32 Source of the data DataSourceID Short integer No 1 DataSource 0 ID of the source record DataDate Date Yes 0 0 8 Date of the source record LRMPositionID Table Sign Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls Sign OBJECTID Object ID SignID GUID No 0 0 38 Unique Identiﬁer GUID No 0 0 38 Identiﬁer for Sign Assembly MUTCDCodeID Short integer No SignMUTCDCode 0 MUTCD Code MUTCDNameID Short integer No SignMUTCDName 0 MUTCD Name MUTCDCategoryID Short integer No SignMUTCDCategory 0 MUTCD Category Message String No 32 Message on the Sign Comment String Yes 255 Comment SourceID String Yes 32 Source of the data DataSourceID Short integer No 1 DataSource 0 ID of the source record DataDate Date Yes 0 0 8 Date of the source record SignAssemblyID SignAssemID Figure C.10. S04A signs data model. Read the entire page →
From page 70... ... 70 Figure C.11. Fixed S04A domains. Read the entire page →
From page 71... ... 71 Coded value domain FieldTypes Description Field type Split policy Merge policy Short integer Duplicate Default value DescriptionCode 1 Short Integer 2 Integer 3 Long Integer 5 String 6 Float 7 Double 8 ObjectID 9 DateTime 10 GUID 11 XML 12 Blob Coded value domain Referents Description Field type Split policy Merge policy Short integer Duplicate Default value DescriptionCode 0 None 1 Edge of Pavement 2 Face of Curb 3 Back of Curb 4 Back of Sidewalk 5 Edge of Right of Way 6 Centerline of Road 7 Centerline of Ditch Coded value domain SideCode Description Field type Split policy Merge policy String Duplicate Default value DescriptionCode L Left Side Only R Right Side Only B Both Sides & Street S Street Only N Both Sides & Not Street U Unknown C Center Coded value domain TrueFalse Description Field type Split policy Merge policy Short integer Default value Default value DescriptionCode 1 True 0 False 1 True Figure C.11. Fixed S04A domains. Read the entire page →
From page 72... ... 72 Coded value domain BarrierPostMaterial Description Field type Split policy Merge policy BarrierTreatmentType Short integer Default value Default value DescriptionCode 1 Unknown Coded value domain BarrierTreatmentType Description Field type Split policy Merge policy BarrierTreatmentType Short integer Default value Default value DescriptionCode 1 Unknown Coded value domain BarrierType Description Field type Split policy Merge policy BarrierTreatmentType Short integer Default value Default value DescriptionCode 1 Unknown Coded value domain IntersectionControlType Description Field type Split policy Merge policy BarrierTreatmentType Short integer Default value Default value DescriptionCode 1 Unknown Coded value domain MedianType Description Field type Split policy Merge policy BarrierTreatmentType Short integer Default value Default value DescriptionCode 1 Unknown Coded value domain ShoulderType Description Field type Split policy Merge policy BarrierTreatmentType Short integer Default value Default value DescriptionCode 1 Unknown Coded value domain SignMUTCDCategory Description Field type Split policy Merge policy BarrierTreatmentType Short integer Default value Default value DescriptionCode 1 Unknown Coded value domain SignMUTCDCode Description Field type Split policy Merge policy BarrierTreatmentType Short integer Default value Default value DescriptionCode 1 Unknown Coded value domain SignMUTCDName Description Field type Split policy Merge policy BarrierTreatmentType Short integer Default value Default value DescriptionCode 1 Unknown Figure C.12. Dynamic S04A domains. Read the entire page →
From page 73... ... 73 Figure C.13. SHRP 2 SQL server. Read the entire page →

From page 59...

... 59 A p p e n d i x C This appendix documents the activities completed under SHRP 2 Project S04A for Task 5 (Database Design and Specification) , which is aimed at developing the technical specifications and supporting management components for the SHRP 2 Roadway Information Database (RID)