Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>The reference direction codes come from the standard FHWA rosette: 1=N, 2=NE (not used here), 3=E, 5=S, 7=W</SPAN></SPAN></P><P STYLE="margin:0 0 0 0;"><SPAN /></P><P STYLE="margin:0 0 0 0;"><SPAN>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.</SPAN></P><P STYLE="margin:0 0 0 0;"><SPAN /></P><P STYLE="margin:0 0 0 0;"><SPAN>Attributes in KHub are: [ReferencePost],</SPAN><SPAN>[ReferenceDirection], </SPAN><SPAN><SPAN>,</SPAN></SPAN><SPAN>[MeasuredLatitude], </SPAN><SPAN><SPAN>,</SPAN></SPAN><SPAN>[MeasuredLongitude], </SPAN><SPAN><SPAN>,</SPAN></SPAN><SPAN><SPAN>[MeasuredAltitude]</SPAN></SPAN></P><P STYLE="margin:0 0 0 0;"><SPAN>The measured Lat,Long attributes would be helpful to create point locations based on the spatial coordinates (Lat, Long) rather than county LRS logmile</SPAN></P><P><SPAN>The attribute ReferenceDirection uses the domain dReferenceDirection</SPAN></P><TABLE><TBODY><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>name</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;margin:0 0 0 0;"><SPAN><SPAN>Code</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Value</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>dReferenceDirection</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;margin:0 0 0 0;"><SPAN><SPAN>0</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>East-West</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>dReferenceDirection</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;margin:0 0 0 0;"><SPAN><SPAN>1</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>North</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>dReferenceDirection</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;margin:0 0 0 0;"><SPAN><SPAN>2</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Northeast</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>dReferenceDirection</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;margin:0 0 0 0;"><SPAN><SPAN>3</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>East</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>dReferenceDirection</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;margin:0 0 0 0;"><SPAN><SPAN>4</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Southeast</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>dReferenceDirection</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;margin:0 0 0 0;"><SPAN><SPAN>5</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>South</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>dReferenceDirection</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;margin:0 0 0 0;"><SPAN><SPAN>6</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Southwest</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>dReferenceDirection</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;margin:0 0 0 0;"><SPAN><SPAN>7</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>West</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>dReferenceDirection</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;margin:0 0 0 0;"><SPAN><SPAN>8</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Northwest</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>dReferenceDirection</SPAN></SPAN></P></TD><TD><P STYLE="text-align:Center;margin:0 0 0 0;"><SPAN><SPAN>9</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>North-South</SPAN></SPAN></P></TD></TR></TBODY></TABLE><P><SPAN /></P><P><SPAN STYLE="font-weight:bold;">HISTORY</SPAN></P><P><SPAN STYLE="font-weight:bold;">From CANSYS Metadata Master Report:</SPAN></P><P><SPAN STYLE="font-weight:bold;">STRP - (State Reference Post) </SPAN></P><P><SPAN>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.</SPAN></P><P><SPAN STYLE="font-weight:bold;">(STRP) - Altitude -- IIT_NUM_ATTRIB19 </SPAN></P><P><SPAN>Comes from Videolog </SPAN></P><P><SPAN STYLE="font-weight:bold;">(STRP) - Cycle -- IIT_NUM_ATTRIB21 </SPAN></P><P><SPAN>Come from Videolog - TFO use only </SPAN></P><P><SPAN STYLE="font-weight:bold;">(STRP) - Disk -- IIT_CHR_ATTRIB30 </SPAN></P><P><SPAN>Come from Videolog TFO use only </SPAN></P><P><SPAN STYLE="font-weight:bold;">(STRP) - Frame -- IIT_NUM_ATTRIB20 </SPAN></P><P><SPAN>Come from Videolog TFO use only </SPAN></P><P><SPAN STYLE="font-weight:bold;">(STRP) - Latitude -- IIT_NUM_ATTRIB17 </SPAN></P><P><SPAN>Latitude of sign </SPAN></P><P><SPAN STYLE="font-weight:bold;">(STRP) - Longitude -- IIT_NUM_ATTRIB18 </SPAN></P><P><SPAN>Longitude of sign </SPAN></P><P><SPAN STYLE="font-weight:bold;">(STRP) - Ref Post Route -- IIT_CHR_ATTRIB26 </SPAN></P><P><SPAN>Route that the reference post exists on </SPAN></P><P><SPAN STYLE="font-weight:bold;">(STRP) - Reference Post -- IIT_NUM_ATTRIB16 </SPAN></P><P><SPAN>Number on sign </SPAN></P><P><SPAN STYLE="font-weight:bold;">(STRP) - Route in city -- IIT_CHR_ATTRIB29 </SPAN></P><P><SPAN>Identifies if route in city limits - </SPAN></P><UL><LI><P><SPAN>Code Y - Yes</SPAN></P></LI><LI><P><SPAN>Code N - No</SPAN></P></LI></UL><P><SPAN STYLE="font-weight:bold;">(STRP) - Virtual -- IIT_CHR_ATTRIB28 </SPAN></P><P><SPAN>Identifies if a point was created to emulate a sign. </SPAN></P><UL><LI><P><SPAN>Code Y - Yes </SPAN></P></LI><LI><P><SPAN>Code N - No </SPAN></P></LI></UL><P><SPAN STYLE="font-weight:bold;">(STRP) - Visible -- IIT_CHR_ATTRIB27 </SPAN></P><P><SPAN>Identifies if the sign is visible or not. </SPAN></P><UL><LI><P><SPAN>Code Y - Yes</SPAN></P></LI><LI><P><SPAN>Code N - No </SPAN></P></LI></UL><P /></DIV></DIV></DIV>
Color: [255, 255, 255, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: left Right to Left: false Angle: 0 XOffset: 0 YOffset: -16 Size: 12 Font Family: Arial Rounded MT Bold Font Style: normal Font Weight: normal Font Decoration: none
Min. Scale: 0.0 Max. Scale: 0.0 Label Placement: esriServerPointLabelPlacementCenterCenter Label Expression: N/A Use Coded Values: true Symbol:
Color: [255, 255, 255, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: left Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 12 Font Family: Arial Rounded MT Bold Font Style: normal Font Weight: normal Font Decoration: none
Min. Scale: 0.0 Max. Scale: 0.0 Label Placement: esriServerPointLabelPlacementBelowCenter Label Expression: N/A Use Coded Values: true Symbol:
Color: [255, 255, 255, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: left Right to Left: false Angle: 0 XOffset: 0 YOffset: 16 Size: 12 Font Family: Arial Rounded MT Bold Font Style: normal Font Weight: normal Font Decoration: none