All Layers and Tables (Mile_Marker

Layers:

Layer: ReferencePosts (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

The reference direction codes come from the standard FHWA rosette: 1=N, 2=NE (not used here), 3=E, 5=S, 7=W

ReferencePost (Mile Marker) is the number on the green sign. There is a RefPost_Tenths field available in the source data (oracle database, shared schema) for the enhanced centerline posts found on the interstates, but it is not currently available in the khub data.

Attributes in KHub are: [ReferencePost],[ReferenceDirection], ,[MeasuredLatitude], ,[MeasuredLongitude], ,[MeasuredAltitude]

The measured Lat,Long attributes would be helpful to create point locations based on the spatial coordinates (Lat, Long) rather than county LRS logmile

The attribute ReferenceDirection uses the domain dReferenceDirection

name	Code	Value
dReferenceDirection	0	East-West
dReferenceDirection	1	North
dReferenceDirection	2	Northeast
dReferenceDirection	3	East
dReferenceDirection	4	Southeast
dReferenceDirection	5	South
dReferenceDirection	6	Southwest
dReferenceDirection	7	West
dReferenceDirection	8	Northwest
dReferenceDirection	9	North-South

HISTORY

From CANSYS Metadata Master Report:

STRP - (State Reference Post)

State reference posts are the green mile marker signs along the roadway. Note that the number reflected on the mile marker will not always match the route milepost of the location of the sign. When a roadway is changed the sign doesnt always gets moved in the field.

(STRP) - Altitude -- IIT_NUM_ATTRIB19

Comes from Videolog

(STRP) - Cycle -- IIT_NUM_ATTRIB21

Come from Videolog - TFO use only

(STRP) - Disk -- IIT_CHR_ATTRIB30

Come from Videolog TFO use only

(STRP) - Frame -- IIT_NUM_ATTRIB20

Come from Videolog TFO use only

(STRP) - Latitude -- IIT_NUM_ATTRIB17

Latitude of sign

(STRP) - Longitude -- IIT_NUM_ATTRIB18

Longitude of sign

(STRP) - Ref Post Route -- IIT_CHR_ATTRIB26

Route that the reference post exists on

(STRP) - Reference Post -- IIT_NUM_ATTRIB16

Number on sign

(STRP) - Route in city -- IIT_CHR_ATTRIB29

Identifies if route in city limits -

Code Y - Yes
Code N - No

(STRP) - Virtual -- IIT_CHR_ATTRIB28

Identifies if a point was created to emulate a sign.

Code Y - Yes
Code N - No

(STRP) - Visible -- IIT_CHR_ATTRIB27

Identifies if the sign is visible or not.

Code Y - Yes
Code N - No

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"88b52c7f878fa4111be79378255a4058","imageData":"iVBORw0KGgoAAAANSUhEUgAAACIAAAB4CAYAAACXUiBTAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABDklEQVR4nO3asU3DYBiE4dfSTcMW6WGJFJBhGCC4YAnSswUS0zhNgpQrLGFZ9hX3tH/xnd76FyFECBFChBAhRAgRQoQQIUQIEUKEECFECBFChBAhRAgRQoQQIUQIEUKkDZmm6RX42Pj+2zAM48OQvWnu8fvnsuqxw9PzsiGnz5dVh/y+T8uGbKlDXIu4FnEt4lrEtYhrEdcirkVci7gWcS3iWsS1iGsR1yKuRVyLuBZxLeJaxLWIaxHXIq5FXIu4FnEt4lrEtYhrEdci/ypyPn4RMeQw8ydo0yFb+hty+w827j5kbyKECCFCiBAihAghQogQIoQIIUKIECKECCFCiBAihAghQogQIoT2HnB3BcL7ETOVojwpAAAAAElFTkSuQmCC","contentType":"image/png","width":25,"height":90,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"var marker = Text($feature[\"ReferencePost\"]);\n\nvar leng = Count(marker);\n\nif (leng==1){\n\n return 0\n\n} else {\n\n if (leng==2){\n\n return 0\n\n } else {\n\n return Left($feature[\"ReferencePost\"], 1)\n\n }\n\n}","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"none","stackLabel":false,"removeDuplicates":"all","removeDuplicatesDistance":5,"useCodedValues":true,"maxScale":0,"minScale":0,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[255,255,255,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":16,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Arial","size":12,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpressionInfo":{"expression":"var marker = Text($feature[\"ReferencePost\"]);\n\nvar leng = Count(marker);\n\nif (leng==1){\n\n return 0\n\n} else {\n\n if (leng==2){\n\n return Left($feature[\"ReferencePost\"], 1)\n\n } else {\n\n return Mid($feature[\"ReferencePost\"], 1,1)\n\n }\n\n}","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"none","stackLabel":false,"removeDuplicates":"all","removeDuplicatesDistance":5,"useCodedValues":true,"maxScale":0,"minScale":0,"name":"Middle","priority":-1,"symbol":{"type":"esriTS","color":[255,255,255,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Arial","size":12,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpressionInfo":{"expression":"var marker = Text($feature[\"ReferencePost\"]);\n\nvar leng = Count(marker);\n\nif (leng==1){\n\n return Left($feature[\"ReferencePost\"], 1)\n\n} else {\n\n if (leng==2){\n\n return Mid($feature[\"ReferencePost\"], 1,1)\n\n } else {\n\n return Mid($feature[\"ReferencePost\"], 2,1)\n\n }\n\n}","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"none","stackLabel":false,"removeDuplicates":"all","removeDuplicatesDistance":5,"useCodedValues":true,"maxScale":0,"minScale":0,"name":"Bottom","priority":-1,"symbol":{"type":"esriTS","color":[255,255,255,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":-16,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Arial","size":12,"style":"normal","weight":"bold","decoration":"none"}}}]}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
EventID (type: esriFieldTypeString, alias: EventID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: true)
RouteID (type: esriFieldTypeString, alias: RouteID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
Measure (type: esriFieldTypeDouble, alias: Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
ReferencePost (type: esriFieldTypeSmallInteger, alias: ReferencePost, SQL Type: sqlTypeOther, nullable: false, editable: true)
ReferenceDirection (type: esriFieldTypeString, alias: ReferenceDirection, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
MeasuredLatitude (type: esriFieldTypeDouble, alias: MeasuredLatitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
MeasuredLongitude (type: esriFieldTypeDouble, alias: MeasuredLongitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
MeasuredAltitude (type: esriFieldTypeSmallInteger, alias: MeasuredAltitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
InventoryStartDate (type: esriFieldTypeDate, alias: InventoryStartDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LRSFromDate (type: esriFieldTypeDate, alias: LRSFromDate, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
LRSToDate (type: esriFieldTypeDate, alias: LRSToDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CreatedUser (type: esriFieldTypeString, alias: CreatedUser, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
LastEditedUser (type: esriFieldTypeString, alias: LastEditedUser, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
CreatedDate (type: esriFieldTypeDate, alias: CreatedDate, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
LastEditedDate (type: esriFieldTypeDate, alias: LastEditedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SourceCIT (type: esriFieldTypeString, alias: SourceCIT, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
LocError (type: esriFieldTypeString, alias: LocError, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)

Templates:

EventID:
ReferencePost: 0
LRSFromDate: -2209161600000
CreatedUser:
CreatedDate: -2209161600000

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (Mile_Marker_Test)

Layers:

Layer: ReferencePosts (0)