ReferencePosts
<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>
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'sqlType': 'sqlTypeOther', 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'EventID', 'type': 'esriFieldTypeString', 'alias': 'EventID', 'sqlType': 'sqlTypeOther', 'length': 38, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'RouteID', 'type': 'esriFieldTypeString', 'alias': 'RouteID', 'sqlType': 'sqlTypeOther', 'length': 38, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'Measure', 'type': 'esriFieldTypeDouble', 'alias': 'Measure', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'ReferencePost', 'type': 'esriFieldTypeSmallInteger', 'alias': 'ReferencePost', 'sqlType': 'sqlTypeOther', 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'ReferenceDirection', 'type': 'esriFieldTypeString', 'alias': 'ReferenceDirection', 'sqlType': 'sqlTypeOther', 'length': 2, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'MeasuredLatitude', 'type': 'esriFieldTypeDouble', 'alias': 'MeasuredLatitude', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'MeasuredLongitude', 'type': 'esriFieldTypeDouble', 'alias': 'MeasuredLongitude', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'MeasuredAltitude', 'type': 'esriFieldTypeSmallInteger', 'alias': 'MeasuredAltitude', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'InventoryStartDate', 'type': 'esriFieldTypeDate', 'alias': 'InventoryStartDate', 'sqlType': 'sqlTypeOther', 'length': 8, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'precision': 1}, {'name': 'LRSFromDate', 'type': 'esriFieldTypeDate', 'alias': 'LRSFromDate', 'sqlType': 'sqlTypeOther', 'length': 8, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None, 'precision': 1}, {'name': 'LRSToDate', 'type': 'esriFieldTypeDate', 'alias': 'LRSToDate', 'sqlType': 'sqlTypeOther', 'length': 8, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'precision': 1}, {'name': 'CreatedUser', 'type': 'esriFieldTypeString', 'alias': 'CreatedUser', 'sqlType': 'sqlTypeOther', 'length': 20, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'LastEditedUser', 'type': 'esriFieldTypeString', 'alias': 'LastEditedUser', 'sqlType': 'sqlTypeOther', 'length': 20, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'CreatedDate', 'type': 'esriFieldTypeDate', 'alias': 'CreatedDate', 'sqlType': 'sqlTypeOther', 'length': 8, 'nullable': False, 'editable': True, 'domain': None, 'defaultValue': None, 'precision': 1}, {'name': 'LastEditedDate', 'type': 'esriFieldTypeDate', 'alias': 'LastEditedDate', 'sqlType': 'sqlTypeOther', 'length': 8, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'precision': 1}, {'name': 'SourceCIT', 'type': 'esriFieldTypeString', 'alias': 'SourceCIT', 'sqlType': 'sqlTypeOther', 'length': 20, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'LocError', 'type': 'esriFieldTypeString', 'alias': 'LocError', 'sqlType': 'sqlTypeOther', 'length': 100, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}]
[{'name': 'PK__MILE_MAR__F4B70D8585CFA140', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': '', 'indexType': 'Attribute'}, {'name': 'user_16245.MILE_MARKER_TEST_REFERENCEPOSTS_Shape_sidx', 'fields': 'SHAPE', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Spatial'}]
nan
[]
{'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\xa0 return 0\n\n} else {\n\n\xa0 if (leng==2){\n\n\xa0 return 0\n\n\xa0 } else {\n\n\xa0 \xa0 return Left($feature["ReferencePost"], 1)\n\n\xa0 }\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': None, 'borderLineColor': None, 'borderLineSize': None, 'verticalAlignment': 'bottom', 'horizontalAlignment': 'left', 'rightToLeft': False, 'angle': 0, 'xoffset': 0, 'yoffset': 16, 'kerning': True, 'haloColor': None, 'haloSize': None, '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\xa0 return 0\n\n} else {\n\n\xa0 if (leng==2){\n\n\xa0 return Left($feature["ReferencePost"], 1)\n\n\xa0 } else {\n\n\xa0 \xa0 return Mid($feature["ReferencePost"], 1,1)\n\n\xa0 }\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': None, 'borderLineColor': None, 'borderLineSize': None, 'verticalAlignment': 'bottom', 'horizontalAlignment': 'left', 'rightToLeft': False, 'angle': 0, 'xoffset': 0, 'yoffset': 0, 'kerning': True, 'haloColor': None, 'haloSize': None, '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\xa0 return Left($feature["ReferencePost"], 1)\n\n} else {\n\n\xa0 if (leng==2){\n\n\xa0 return Mid($feature["ReferencePost"], 1,1)\n\n\xa0 } else {\n\n\xa0 \xa0 return Mid($feature["ReferencePost"], 2,1)\n\n\xa0 }\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': None, 'borderLineColor': None, 'borderLineSize': None, 'verticalAlignment': 'bottom', 'horizontalAlignment': 'left', 'rightToLeft': False, 'angle': 0, 'xoffset': 0, 'yoffset': -16, 'kerning': True, 'haloColor': None, 'haloSize': None, 'font': {'family': 'Arial', 'size': 12, 'style': 'normal', 'weight': 'bold', 'decoration': 'none'}}}]}
[]
[{'name': 'ReferencePosts', 'description': '', 'drawingTool': 'esriFeatureEditToolPoint', 'prototype': {'attributes': {'SourceCIT': None, 'LocError': None, 'EventID': ' ', 'RouteID': None, 'Measure': None, 'ReferencePost': 0, 'ReferenceDirection': None, 'MeasuredLatitude': None, 'MeasuredLongitude': None, 'MeasuredAltitude': None, 'InventoryStartDate': None, 'LRSFromDate': -2209161600000, 'LRSToDate': None, 'CreatedUser': ' ', 'LastEditedUser': None, 'CreatedDate': -2209161600000, 'LastEditedDate': None}}}]