Reference Posts
<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', 'domain': None}, {'name': 'EventID', 'type': 'esriFieldTypeString', 'alias': 'EventID', 'length': 38, 'domain': None}, {'name': 'RouteID', 'type': 'esriFieldTypeString', 'alias': 'RouteID', 'length': 38, 'domain': None}, {'name': 'Measure', 'type': 'esriFieldTypeDouble', 'alias': 'Measure', 'domain': None}, {'name': 'ReferencePost', 'type': 'esriFieldTypeSmallInteger', 'alias': 'ReferencePost', 'domain': None}, {'name': 'ReferenceDirection', 'type': 'esriFieldTypeString', 'alias': 'ReferenceDirection', 'length': 2, 'domain': {'type': 'codedValue', 'name': 'dReferenceDirection', 'description': 'ReferenceDirectionDesc', 'codedValues': [{'name': 'East-West', 'code': '0'}, {'name': 'North', 'code': '1'}, {'name': 'Northeast', 'code': '2'}, {'name': 'East', 'code': '3'}, {'name': 'Southeast', 'code': '4'}, {'name': 'South', 'code': '5'}, {'name': 'Southwest', 'code': '6'}, {'name': 'West', 'code': '7'}, {'name': 'Northwest', 'code': '8'}, {'name': 'North-South', 'code': '9'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'MeasuredLatitude', 'type': 'esriFieldTypeDouble', 'alias': 'MeasuredLatitude', 'domain': None}, {'name': 'MeasuredLongitude', 'type': 'esriFieldTypeDouble', 'alias': 'MeasuredLongitude', 'domain': None}, {'name': 'MeasuredAltitude', 'type': 'esriFieldTypeSmallInteger', 'alias': 'MeasuredAltitude', 'domain': None}, {'name': 'InventoryStartDate', 'type': 'esriFieldTypeDate', 'alias': 'InventoryStartDate', 'length': 8, 'domain': None}, {'name': 'LRSFromDate', 'type': 'esriFieldTypeDate', 'alias': 'LRSFromDate', 'length': 8, 'domain': None}, {'name': 'LRSToDate', 'type': 'esriFieldTypeDate', 'alias': 'LRSToDate', 'length': 8, 'domain': None}, {'name': 'CreatedUser', 'type': 'esriFieldTypeString', 'alias': 'CreatedUser', 'length': 20, 'domain': None}, {'name': 'LastEditedUser', 'type': 'esriFieldTypeString', 'alias': 'LastEditedUser', 'length': 20, 'domain': None}, {'name': 'CreatedDate', 'type': 'esriFieldTypeDate', 'alias': 'CreatedDate', 'length': 8, 'domain': None}, {'name': 'LastEditedDate', 'type': 'esriFieldTypeDate', 'alias': 'LastEditedDate', 'length': 8, 'domain': None}, {'name': 'SourceCIT', 'type': 'esriFieldTypeString', 'alias': 'SourceCIT', 'length': 20, 'domain': {'type': 'codedValue', 'name': 'dSourceCIT_4', 'description': 'SourceCITDesc', 'codedValues': [{'name': 'Assumed', 'code': 'ASD'}, {'name': 'CANSYS II Legacy, Migrated', 'code': 'CLM'}, {'name': 'Design Standards Shoulder Width \\\\CANSYSTEST\\CANSYS\\KDOT\\DOCUMENTATION\\KDOT USER DOCUMENTATION\\METADATA\\STANDARDSHOULDERWIDTHTABLE.PDF', 'code': 'DSSW'}, {'name': 'Unknown', 'code': 'NA'}, {'name': 'No Best Fit Obtained', 'code': 'NBFO'}, {'name': 'Non-State Section, Migrated', 'code': 'NSSect'}, {'name': 'Notified', 'code': 'NTF'}, {'name': 'Project', 'code': 'PR'}, {'name': 'Interchange Ramp for Migration', 'code': 'RAMP'}, {'name': 'Construction Plans', 'code': 'Y'}, {'name': 'HPMS Data for Migration', 'code': 'HPMS'}, {'name': 'Aerial Photography - Unknown Spec', 'code': 'AP'}, {'name': 'Aerial Photography - ASPRS II or higher spec', 'code': 'AP2'}, {'name': 'Aerial Photography - DOQQ imagery', 'code': 'AP3'}, {'name': 'Aerial Photography - USDA FSA NAIP Imagery', 'code': 'AP4'}, {'name': 'Apple Device', 'code': 'APL'}, {'name': 'URS Curve Application', 'code': 'C2'}, {'name': 'Curve Tool', 'code': 'C3'}, {'name': 'Digital Elevation Model, 10M or equivalent', 'code': 'DEM'}, {'name': 'Design Plan', 'code': 'DTD'}, {'name': 'KDOT Surveyor', 'code': 'DTS'}, {'name': 'Estimated', 'code': 'Est'}, {'name': 'NAIP 2012', 'code': 'FS12'}, {'name': 'NAIP 2015', 'code': 'FS15'}, {'name': 'GNIS', 'code': 'GN'}, {'name': 'Google', 'code': 'GOOG'}, {'name': 'Other Handheld GPS', 'code': 'GPS1'}, {'name': 'KDOT Data Owner', 'code': 'KDO'}, {'name': 'KDOT Official Notification or Contract', 'code': 'KOC'}, {'name': 'Aerial Imagery', 'code': 'KP15'}, {'name': 'Project Plans', 'code': 'KPP'}, {'name': 'KDOT Notification, Field Verified', 'code': 'KUC'}, {'name': 'LiDAR Derived, High Altitude USGS Spec', 'code': 'Li'}, {'name': 'LiDAR Derived, Low Altitude, Manned, Transportation Spec', 'code': 'LiM'}, {'name': 'LiDAR Derived, Low Altitude, UAS, Transportation Spec', 'code': 'LiU'}, {'name': 'Local Agency Data Steward', 'code': 'LPA'}, {'name': 'NG911 Data Steward', 'code': 'NG'}, {'name': 'Other Video or Photo Source', 'code': 'PHO'}, {'name': 'Other State Agency Data Steward', 'code': 'SA'}, {'name': 'Samsung Device', 'code': 'SAM'}, {'name': 'Aerial Imagery', 'code': 'SDX15'}, {'name': 'KDOT Videolog', 'code': 'VL'}, {'name': 'AADT Flowmap', 'code': 'FLOW'}, {'name': 'AADT City with Factor Applied', 'code': 'CITY'}, {'name': 'AADT Portable Counters', 'code': 'CVRG'}, {'name': 'AADT Portable Counters with Factor Applied', 'code': 'CVRGFCT'}, {'name': 'AADT Major-Minor Collectors', 'code': 'MAJMIN'}, {'name': 'AADT Non-State Urban', 'code': 'NUSYS'}, {'name': 'AADT Ramp Data', 'code': 'RAMPS'}, {'name': 'AADT Route Average', 'code': 'AVG'}, {'name': 'Derived', 'code': 'DER'}, {'name': 'PMS  videolog http://dtpml004.ksdot.org/npcve/', 'code': 'VLPMS'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'LocError', 'type': 'esriFieldTypeString', 'alias': 'LocError', 'length': 100, 'domain': None}, {'name': 'Shape', 'type': 'esriFieldTypeGeometry', 'alias': 'Shape', 'domain': None}]
[{'name': 'R164049_pk', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': ''}, {'name': 'ix_rte_fromdate_', 'fields': 'RouteID,LRSFromDate,LRSToDate', 'isAscending': True, 'isUnique': False, 'description': ''}, {'name': 'S158825_idx', 'fields': 'Shape', 'isAscending': True, 'isUnique': True, 'description': ''}]
[]
{'renderer': {'type': 'simple', 'symbol': {'type': 'esriSMS', 'style': 'esriSMSCircle', 'color': [0, 0, 0, 255], 'size': 3, 'angle': 0, 'xoffset': 0, 'yoffset': 0, 'outline': {'color': [0, 0, 0, 255], 'width': 0.7}}}, 'scaleSymbols': True, 'transparency': 0, 'labelingInfo': None}
nan
nan
nan