The National Academies Press

Currently Skimming:

Pages 21-27

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 21... ... 21 C h a p t e r 4 4.1 Database Design This section discusses the general design approach without reference to specific details. Refer to Appendix C for the details of the database design. Read the entire page →
From page 22... ... 22 denormalized data warehouse (storing individual roadway attributes in their native extents) designed to improve data query and retrieval speeds. Read the entire page →
From page 23... ... 23 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 PositionID Polyline length Table Alignment Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls Alignment OBJECTID Object ID AlignmentID GUID No 0 0 38 Unique identiﬁer GUID No 0 0 38 Identiﬁer for LRMPosition Tangent Short integer No 0 TrueFalse 0 Tangent Radius Long integer No 0 Curve radius CurveDirectionID Short integer No Direction 0 Curve direction SuperElevation Double Yes 0 0 Super elevation Comment String Yes 255 Comment SourceID String Yes 32 Source of the data DataSourceID Short integer No DataSource 0 ID of the source record DataDate Date Yes 0 0 8 Date of the source record LRMPositionID Figure 4.1. S04A alignment data model. Read the entire page →
From page 24... ... 24 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 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 4.2. Read the entire page →
From page 25... ... 25 Coded value domain AspectTypes Description Field type Split policy Merge policy Name Short integer Default value Default value DescriptionCode 1 Route Name 2 AADT 3 Functional Class 4 Lighting 5 Median Strip 6 Rumble Strip 7 IRI 8 Speed Limit Coded value domain Datums Description Field type Split policy Merge policy Short integer Duplicate Default value DescriptionCode 1 State Plane 2 WGS 84 0 Unknown Coded value domain Direction Description Field type Split policy Merge policy Short integer Duplicate Default value DescriptionCode 1 Left 0 None 1 Right Coded value domain DomainTypes Description Field type Split policy Merge policy Domain Types Short integer Default value Default value DescriptionCode 0 None 1 Range 2 Coded Value Coded value domain GeometryTypeID Description Field type Split policy Merge policy Short integer Default value Default value DescriptionCode 1 Point 2 Polyline Range domain InterectionNumApproaches Description Field type Split policy Merge policy Short integer Default value Default value Maximum valueMinimum value 0 10 Coded value domain LocationMethod Description Field type Split policy Merge policy Method used for locating the polyline Short integer Default value Default value DescriptionCode 1 End points on same route 2 End point on adjacent routes 3 Shortest path 1 Original and Conﬂated polyline length diﬀer by more than20% 2 End point(s) failed to snap tonetwork within tolerance 3 Failed to ﬁnd shortest path betweenend points Coded value domain OﬀsetDirections Description Field type Split policy Merge policy Short integer Duplicate Default value DescriptionCode 0 None 1 In 2 Out 3 North 4 East 5 South 6 West 7 Toward 8 Away From Figure 4.3. Read the entire page →
From page 26... ... 26 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 4.3. Fixed S04A domains. Read the entire page →
From page 27... ... 27 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 SignMUTCDName 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 SignMUTCDCategory Description Field type Split policy Merge policy BarrierTreatmentType Short integer Default value Default value DescriptionCode 1 Unknown Figure 4.4. Dynamic S04A domains. Read the entire page →

From page 21...

... 21 C h a p t e r 4 4.1 Database Design This section discusses the general design approach without reference to specific details. Refer to Appendix C for the details of the database design.

Read the entire page →

From page 22...

... 22 denormalized data warehouse (storing individual roadway attributes in their native extents) designed to improve data query and retrieval speeds.

Read the entire page →

From page 23...

... 23 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 PositionID Polyline length Table Alignment Data typeField name Prec ision Scale LengthDomainDefault value Allow nulls Alignment OBJECTID Object ID AlignmentID GUID No 0 0 38 Unique identiﬁer GUID No 0 0 38 Identiﬁer for LRMPosition Tangent Short integer No 0 TrueFalse 0 Tangent Radius Long integer No 0 Curve radius CurveDirectionID Short integer No Direction 0 Curve direction SuperElevation Double Yes 0 0 Super elevation Comment String Yes 255 Comment SourceID String Yes 32 Source of the data DataSourceID Short integer No DataSource 0 ID of the source record DataDate Date Yes 0 0 8 Date of the source record LRMPositionID Figure 4.1. S04A alignment data model.

Read the entire page →

From page 24...

... 24 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 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 4.2.

Read the entire page →

From page 25...

... 25 Coded value domain AspectTypes Description Field type Split policy Merge policy Name Short integer Default value Default value DescriptionCode 1 Route Name 2 AADT 3 Functional Class 4 Lighting 5 Median Strip 6 Rumble Strip 7 IRI 8 Speed Limit Coded value domain Datums Description Field type Split policy Merge policy Short integer Duplicate Default value DescriptionCode 1 State Plane 2 WGS 84 0 Unknown Coded value domain Direction Description Field type Split policy Merge policy Short integer Duplicate Default value DescriptionCode 1 Left 0 None 1 Right Coded value domain DomainTypes Description Field type Split policy Merge policy Domain Types Short integer Default value Default value DescriptionCode 0 None 1 Range 2 Coded Value Coded value domain GeometryTypeID Description Field type Split policy Merge policy Short integer Default value Default value DescriptionCode 1 Point 2 Polyline Range domain InterectionNumApproaches Description Field type Split policy Merge policy Short integer Default value Default value Maximum valueMinimum value 0 10 Coded value domain LocationMethod Description Field type Split policy Merge policy Method used for locating the polyline Short integer Default value Default value DescriptionCode 1 End points on same route 2 End point on adjacent routes 3 Shortest path 1 Original and Conﬂated polyline length diﬀer by more than20% 2 End point(s) failed to snap tonetwork within tolerance 3 Failed to ﬁnd shortest path betweenend points Coded value domain OﬀsetDirections Description Field type Split policy Merge policy Short integer Duplicate Default value DescriptionCode 0 None 1 In 2 Out 3 North 4 East 5 South 6 West 7 Toward 8 Away From Figure 4.3.

Read the entire page →

From page 26...

... 26 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 4.3. Fixed S04A domains.

Read the entire page →

From page 27...

... 27 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 SignMUTCDName 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 SignMUTCDCategory Description Field type Split policy Merge policy BarrierTreatmentType Short integer Default value Default value DescriptionCode 1 Unknown Figure 4.4. Dynamic S04A domains.

Read the entire page →

Key Terms

← Previous Chapter Skim

Next Chapter Skim →

This material may be derived from roughly machine-read images, and so is provided only to facilitate research.
More information on Chapter Skim is available.