VT Data - Broadband RDS 2021
This layer is based on the Vermont E911 Road Centerline layer and depicts associated broadband deployment for each road feature. For each road feature the BB_TYPE field depicts the presence of Cable or FTTH deployment. The layer consists of three component parts: the 2021 FTTH layer, the 2021 Cable layer, and the E-911 Road Centerline layer. The FTTH and Cable layers themselves are also comprised primarily of features copied from the E-911 Road Centerline layer. Note that deployment does not always extend to to the complete extent of road segments so the layers include many clipped road segments and thus care must be taken in performing analysis using just road segment IDs in this layer as it includes duplicate segment IDs.The following procedures were employed in the creation of this layer.Step 1: The FTTH and Cable layers are primarily comprised of road segments with the ten (10) AOT CLASS entries listed below. However, the layers also include some segments from other AOT classes where service was reported and some features from the E-911 Driveways layer where service was reported. These features were removed from this layer, which only includes the features with the 10 AOTCLASS entries.Town Highway Class 1 (code 1)Town Highway Class 2 (code 2)Town Highway Class 3 (code 3)Town Highway Class 4 (code 4)State Forest Highway (code 5)National Forest Highway (code 6)Private Road (code 8)Private Road (code 9)State Highway (code 30)US Highway (Code 40)Step 2: Use the Erase tool (the opposite of the Clip tool) to remove from the Cable layer lines that overlap with the FTTH layer.Step 3. Combine the FTTH and Erased Cable layersStep 4: Use the Erase tool to remove from the E-911 RDS layer the lines that overlap with the combined Cable and FTTH layer.Step 5: Add BB_Miles field, calculate milesStep 6: Add BB_TYPE field, populate Cable, FTTH, NoCableOrFTTHStep 7: Merge FTTH, Erased Cable, and Erased E-911 Centerline layer to create Broadband_RDS layer Step 8: Run statistics on Broadband Status layer, Count ESITEID by SegmentIDStep 9: Join statistics results to Broadband RDS layerStep 10: Select features where BB_TYPE= NoCableOrFTTH and Count of ESITEID is null, populate BB_TYPE= NoCableOrFTTH_NoLocStep 11: Join based on MCODE to add fields from BNDHASH, including TOWNNAME, TOWNGEOID and CUD, as MCODE is a naming convention used by Vermont E-911 and does not completely align with naming convention in BNDHASH
[]
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'domain': None}, {'name': 'SEGMENTID', 'type': 'esriFieldTypeInteger', 'alias': 'SEGMENTID', 'domain': None}, {'name': 'ARCID', 'type': 'esriFieldTypeInteger', 'alias': 'ARCID', 'domain': None}, {'name': 'PD', 'type': 'esriFieldTypeString', 'alias': 'PD', 'length': 10, 'domain': None}, {'name': 'PT', 'type': 'esriFieldTypeString', 'alias': 'PT', 'length': 10, 'domain': None}, {'name': 'SN', 'type': 'esriFieldTypeString', 'alias': 'SN', 'length': 80, 'domain': None}, {'name': 'ST', 'type': 'esriFieldTypeString', 'alias': 'ST', 'length': 10, 'domain': None}, {'name': 'SD', 'type': 'esriFieldTypeString', 'alias': 'SD', 'length': 10, 'domain': None}, {'name': 'GEONAMEID', 'type': 'esriFieldTypeInteger', 'alias': 'GEONAMEID', 'domain': None}, {'name': 'PRIMARYNAME', 'type': 'esriFieldTypeString', 'alias': 'PRIMARYNAME', 'length': 100, 'domain': None}, {'name': 'ALIAS1', 'type': 'esriFieldTypeString', 'alias': 'ALIAS1', 'length': 60, 'domain': None}, {'name': 'ALIAS2', 'type': 'esriFieldTypeString', 'alias': 'ALIAS2', 'length': 60, 'domain': None}, {'name': 'ALIAS3', 'type': 'esriFieldTypeString', 'alias': 'ALIAS3', 'length': 60, 'domain': None}, {'name': 'ALIAS4', 'type': 'esriFieldTypeString', 'alias': 'ALIAS4', 'length': 60, 'domain': None}, {'name': 'ALIAS5', 'type': 'esriFieldTypeString', 'alias': 'ALIAS5', 'length': 60, 'domain': None}, {'name': 'COMMENTS', 'type': 'esriFieldTypeString', 'alias': 'COMMENTS', 'length': 255, 'domain': None}, {'name': 'SURFACETYPE', 'type': 'esriFieldTypeSmallInteger', 'alias': 'SURFACETYPE', 'domain': {'type': 'codedValue', 'name': 'SurfaceType', 'description': '', 'codedValues': [{'name': 'Paved', 'code': 1}, {'name': 'Gravel', 'code': 2}, {'name': 'Unknown', 'code': 9}, {'name': 'Soil or graded and drained earth', 'code': 3}, {'name': 'Unimproved/Primitive', 'code': 5}, {'name': 'Impassable or untravelled', 'code': 6}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'ONEWAY', 'type': 'esriFieldTypeString', 'alias': 'ONEWAY', 'length': 1, 'domain': {'type': 'codedValue', 'name': 'Oneway', 'description': '', 'codedValues': [{'name': 'No', 'code': 'N'}, {'name': 'Yes - Direction of arc', 'code': 'Y'}, {'name': 'Yes - Opposite direction of arc', 'code': 'X'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'ADDRESSLOCK', 'type': 'esriFieldTypeInteger', 'alias': 'ADDRESSLOCK', 'domain': {'type': 'codedValue', 'name': 'YesNo', 'description': '', 'codedValues': [{'name': 'Yes', 'code': 1}, {'name': 'No', 'code': 0}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'NO_MSAG', 'type': 'esriFieldTypeInteger', 'alias': 'NO_MSAG', 'domain': None}, {'name': 'MCODE', 'type': 'esriFieldTypeInteger', 'alias': 'MCODE', 'domain': None}, {'name': 'LESN', 'type': 'esriFieldTypeInteger', 'alias': 'LESN', 'domain': None}, {'name': 'RESN', 'type': 'esriFieldTypeInteger', 'alias': 'RESN', 'domain': None}, {'name': 'LTWN', 'type': 'esriFieldTypeString', 'alias': 'LTWN', 'length': 50, 'domain': None}, {'name': 'RTWN', 'type': 'esriFieldTypeString', 'alias': 'RTWN', 'length': 50, 'domain': None}, {'name': 'LLO_A', 'type': 'esriFieldTypeInteger', 'alias': 'LLO_A', 'domain': None}, {'name': 'RLO_A', 'type': 'esriFieldTypeInteger', 'alias': 'RLO_A', 'domain': None}, {'name': 'LHI_A', 'type': 'esriFieldTypeInteger', 'alias': 'LHI_A', 'domain': None}, {'name': 'RHI_A', 'type': 'esriFieldTypeInteger', 'alias': 'RHI_A', 'domain': None}, {'name': 'LZIP', 'type': 'esriFieldTypeString', 'alias': 'LZIP', 'length': 10, 'domain': None}, {'name': 'RZIP', 'type': 'esriFieldTypeString', 'alias': 'RZIP', 'length': 10, 'domain': None}, {'name': 'LLO_T', 'type': 'esriFieldTypeInteger', 'alias': 'LLO_T', 'domain': None}, {'name': 'RLO_T', 'type': 'esriFieldTypeInteger', 'alias': 'RLO_T', 'domain': None}, {'name': 'LHI_T', 'type': 'esriFieldTypeInteger', 'alias': 'LHI_T', 'domain': None}, {'name': 'RHI_T', 'type': 'esriFieldTypeInteger', 'alias': 'RHI_T', 'domain': None}, {'name': 'RTNAME', 'type': 'esriFieldTypeString', 'alias': 'RTNAME', 'length': 12, 'domain': None}, {'name': 'RTNUMBER', 'type': 'esriFieldTypeString', 'alias': 'RTNUMBER', 'length': 4, 'domain': None}, {'name': 'HWYSIGN', 'type': 'esriFieldTypeString', 'alias': 'HWYSIGN', 'length': 12, 'domain': None}, {'name': 'RPCCLASS', 'type': 'esriFieldTypeSmallInteger', 'alias': 'RPCCLASS', 'domain': None}, {'name': 'AOTCLASS', 'type': 'esriFieldTypeSmallInteger', 'alias': 'AOTCLASS', 'domain': {'type': 'codedValue', 'name': 'AOTClass', 'description': '', 'codedValues': [{'name': 'Town Highway Class 1', 'code': 1}, {'name': 'Town Highway Class 2', 'code': 2}, {'name': 'Town Highway Class 3', 'code': 3}, {'name': 'Town Highway Class 4', 'code': 4}, {'name': 'State Forest Highway', 'code': 5}, {'name': 'National Forest Highway', 'code': 6}, {'name': 'Legal Trail', 'code': 7}, {'name': 'Private Road - No Show', 'code': 8}, {'name': 'Private  Road', 'code': 9}, {'name': 'Driveway (put in driveway)', 'code': 10}, {'name': 'Town Highway Class 1 - North Bound', 'code': 11}, {'name': 'Town Highway Class 1 - South Bound', 'code': 12}, {'name': 'Town Highway Class 1 - East Bound', 'code': 13}, {'name': 'Town Highway Class 1 - West Bound', 'code': 14}, {'name': 'Town Highway Class 1 - On/Off Ramp', 'code': 15}, {'name': 'Town Highway Class 1 - Emergency U-Turn', 'code': 16}, {'name': 'County Highway', 'code': 20}, {'name': 'Town Highway Class 2 - North Bound', 'code': 21}, {'name': 'Town Highway Class 2 - South Bound', 'code': 22}, {'name': 'Town Highway Class 2 - East Bound', 'code': 23}, {'name': 'Town Highway Class 2 - West Bound', 'code': 24}, {'name': 'Town Highway Class 2 - On/Off Ramp', 'code': 25}, {'name': 'State Highway', 'code': 30}, {'name': 'State Highway - North Bound', 'code': 31}, {'name': 'State Highway - South Bound', 'code': 32}, {'name': 'State Highway - East Bound', 'code': 33}, {'name': 'State Highway - West Bound', 'code': 34}, {'name': 'State Highway - On/Off Ramp', 'code': 35}, {'name': 'US Highway', 'code': 40}, {'name': 'US Highway - North Bound', 'code': 41}, {'name': 'US Highway - South Bound', 'code': 42}, {'name': 'US Highway - East Bound', 'code': 43}, {'name': 'US Highway - West Bound', 'code': 44}, {'name': 'US Highway - On/Off Ramp', 'code': 45}, {'name': 'US Highway - Emergency U-Turn', 'code': 46}, {'name': 'US Highway - Rest Area', 'code': 47}, {'name': 'Interstate Highway', 'code': 50}, {'name': 'Interstate Highway - North Bound', 'code': 51}, {'name': 'Interstate Highway - South Bound', 'code': 52}, {'name': 'Interstate Highway - East Bound', 'code': 53}, {'name': 'Interstate Highway - West Bound', 'code': 54}, {'name': 'Interstate Highway - On/Off Ramp', 'code': 55}, {'name': 'Interstate Highway - Emergency U-Turn', 'code': 56}, {'name': 'Interstate Highway - Rest Area', 'code': 57}, {'name': 'Interstate Highway - Other', 'code': 59}, {'name': 'Ferry', 'code': 65}, {'name': 'Unconfirmed Legal Trail', 'code': 70}, {'name': 'Unidentified Corridor', 'code': 71}, {'name': 'Proposed Highway Unknown Class', 'code': 80}, {'name': 'Proposed Town Highway Class 1', 'code': 81}, {'name': 'Proposed Town Highway Class 2', 'code': 82}, {'name': 'Proposed Town Highway Class 3', 'code': 83}, {'name': 'Proposed State Highway', 'code': 84}, {'name': 'Proposed US Highway', 'code': 85}, {'name': 'Proposed Interstate Highway', 'code': 86}, {'name': 'Proposed Interstate Highway - Ramp', 'code': 87}, {'name': 'Proposed Non-Interstate Highway - Ramp', 'code': 88}, {'name': 'Proposed Private Road', 'code': 89}, {'name': 'New - Class Unknown', 'code': 91}, {'name': 'Military - no public access', 'code': 92}, {'name': 'Public - Class Unknown', 'code': 93}, {'name': 'Class Under Review', 'code': 95}, {'name': 'Discontinued Road', 'code': 96}, {'name': 'Discontinued Now Private', 'code': 97}, {'name': 'Not a Road', 'code': 98}, {'name': 'Unknown', 'code': 99}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'NUTS', 'type': 'esriFieldTypeString', 'alias': 'NUTS', 'length': 1, 'domain': None}, {'name': 'NHS', 'type': 'esriFieldTypeSmallInteger', 'alias': 'NHS', 'domain': None}, {'name': 'FUNCL', 'type': 'esriFieldTypeSmallInteger', 'alias': 'FUNCL', 'domain': None}, {'name': 'TWN_LR', 'type': 'esriFieldTypeString', 'alias': 'TWN_LR', 'length': 15, 'domain': None}, {'name': 'ETE_LR', 'type': 'esriFieldTypeString', 'alias': 'ETE_LR', 'length': 11, 'domain': None}, {'name': 'CTCODE', 'type': 'esriFieldTypeString', 'alias': 'CTCODE', 'length': 4, 'domain': None}, {'name': 'UA', 'type': 'esriFieldTypeSmallInteger', 'alias': 'UA', 'domain': None}, {'name': 'CTUA', 'type': 'esriFieldTypeString', 'alias': 'CTUA', 'length': 6, 'domain': None}, {'name': 'CERTCODE', 'type': 'esriFieldTypeString', 'alias': 'CERTCODE', 'length': 6, 'domain': None}, {'name': 'ARCMILES', 'type': 'esriFieldTypeDouble', 'alias': 'ARCMILES', 'domain': None}, {'name': 'AOTMILES', 'type': 'esriFieldTypeDouble', 'alias': 'AOTMILES', 'domain': None}, {'name': 'AOTMILES_CALC', 'type': 'esriFieldTypeDouble', 'alias': 'AOTMILES_CALC', 'domain': None}, {'name': 'UPDACT', 'type': 'esriFieldTypeString', 'alias': 'UPDACT', 'length': 1, 'domain': None}, {'name': 'LOCMETH', 'type': 'esriFieldTypeSmallInteger', 'alias': 'LOCMETH', 'domain': None}, {'name': 'SRCORG', 'type': 'esriFieldTypeSmallInteger', 'alias': 'SRCORG', 'domain': None}, {'name': 'SCENICHWY', 'type': 'esriFieldTypeSmallInteger', 'alias': 'SCENICHWY', 'domain': None}, {'name': 'SCENICBYWAY', 'type': 'esriFieldTypeSmallInteger', 'alias': 'SCENICBYWAY', 'domain': None}, {'name': 'FORMER_RTNAME', 'type': 'esriFieldTypeString', 'alias': 'FORMER_RTNAME', 'length': 12, 'domain': None}, {'name': 'PROVISIONALYEAR', 'type': 'esriFieldTypeSmallInteger', 'alias': 'PROVISIONALYEAR', 'domain': None}, {'name': 'ANCIENTROADYEAR', 'type': 'esriFieldTypeSmallInteger', 'alias': 'ANCIENTROADYEAR', 'domain': None}, {'name': 'TRUCKROUTE', 'type': 'esriFieldTypeSmallInteger', 'alias': 'TRUCKROUTE', 'domain': None}, {'name': 'ROADCLOSED', 'type': 'esriFieldTypeString', 'alias': 'ROADCLOSED', 'length': 15, 'domain': {'type': 'codedValue', 'name': 'Road_Closed', 'description': '', 'codedValues': [{'name': 'Closed', 'code': 'Closed'}, {'name': 'Closed-Winter', 'code': 'Closed_W'}, {'name': 'Closed-Authorized Vehicles Only', 'code': 'Closed_AVO'}, {'name': 'Closed-Local Trafic Only', 'code': 'Closed_LTO'}, {'name': 'Normal Service Requested', 'code': 'Normal_SR'}, {'name': 'Open', 'code': 'Open'}, {'name': 'Open with Construction Delays', 'code': 'Open_CD'}, {'name': 'Open with Restrictions', 'code': 'Open_R'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'INSET', 'type': 'esriFieldTypeString', 'alias': 'INSET', 'length': 1, 'domain': None}, {'name': 'ISVISIBLE', 'type': 'esriFieldTypeInteger', 'alias': 'ISVISIBLE', 'domain': None}, {'name': 'CERTYEAR', 'type': 'esriFieldTypeSmallInteger', 'alias': 'CERTYEAR', 'domain': None}, {'name': 'MAPYEAR', 'type': 'esriFieldTypeDate', 'alias': 'MAPYEAR', 'length': 8, 'domain': None}, {'name': 'UPDATESOURCE', 'type': 'esriFieldTypeString', 'alias': 'UPDATESOURCE', 'length': 30, 'domain': None}, {'name': 'UPDATEDATE', 'type': 'esriFieldTypeDate', 'alias': 'UPDATEDATE', 'length': 8, 'domain': None}, {'name': 'GPSUPDATE', 'type': 'esriFieldTypeString', 'alias': 'GPSUPDATE', 'length': 1, 'domain': {'type': 'codedValue', 'name': 'GPSUpdate', 'description': '', 'codedValues': [{'name': 'Yes - Needs GPS Update', 'code': 'Y'}, {'name': 'No - Does not need GPS Update', 'code': 'N'}, {'name': 'GPS Update Complete', 'code': 'G'}, {'name': 'GPS Update Complete - New Road', 'code': 'V'}, {'name': 'Unresolved Segment', 'code': 'X'}], 'mergePolicy': 'esriMPTDefaultValue', 'splitPolicy': 'esriSPTDefaultValue'}}, {'name': 'GlobalID', 'type': 'esriFieldTypeGlobalID', 'alias': 'GlobalID', 'length': 38, 'domain': None}, {'name': 'STATE', 'type': 'esriFieldTypeString', 'alias': 'STATE', 'length': 2, 'domain': None}, {'name': 'GAP', 'type': 'esriFieldTypeInteger', 'alias': 'GAP', 'domain': None}, {'name': 'GAPMILES', 'type': 'esriFieldTypeDouble', 'alias': 'GAPMILES', 'domain': None}, {'name': 'GAPSTREETID', 'type': 'esriFieldTypeInteger', 'alias': 'GAPSTREETID', 'domain': None}, {'name': 'FIPS8', 'type': 'esriFieldTypeInteger', 'alias': 'FIPS8', 'domain': None}, {'name': 'FAID_S', 'type': 'esriFieldTypeDouble', 'alias': 'FAID_S', 'domain': None}, {'name': 'RTNUMBER_N', 'type': 'esriFieldTypeDouble', 'alias': 'RTNUMBER_N', 'domain': None}, {'name': 'LCOUNTY', 'type': 'esriFieldTypeString', 'alias': 'LCOUNTY', 'length': 25, 'domain': None}, {'name': 'RCOUNTY', 'type': 'esriFieldTypeString', 'alias': 'RCOUNTY', 'length': 25, 'domain': None}, {'name': 'PRIMARYNAME1', 'type': 'esriFieldTypeString', 'alias': 'PRIMARYNAME1', 'length': 256, 'domain': None}, {'name': 'SOURCEOFDATA', 'type': 'esriFieldTypeString', 'alias': 'SOURCEOFDATA', 'length': 75, 'domain': None}, {'name': 'COUNTRY', 'type': 'esriFieldTypeString', 'alias': 'COUNTRY', 'length': 2, 'domain': None}, {'name': 'PARITYLEFT', 'type': 'esriFieldTypeString', 'alias': 'PARITYLEFT', 'length': 1, 'domain': None}, {'name': 'PARITYRIGHT', 'type': 'esriFieldTypeString', 'alias': 'PARITYRIGHT', 'length': 1, 'domain': None}, {'name': 'GC_EXCEPTION', 'type': 'esriFieldTypeString', 'alias': 'GC_EXCEPTION', 'length': 75, 'domain': None}, {'name': 'LFIPS', 'type': 'esriFieldTypeString', 'alias': 'LFIPS', 'length': 4, 'domain': None}, {'name': 'RFIPS', 'type': 'esriFieldTypeString', 'alias': 'RFIPS', 'length': 4, 'domain': None}, {'name': 'LSTATE', 'type': 'esriFieldTypeString', 'alias': 'LSTATE', 'length': 2, 'domain': None}, {'name': 'RSTATE', 'type': 'esriFieldTypeString', 'alias': 'RSTATE', 'length': 2, 'domain': None}, {'name': 'LESZ', 'type': 'esriFieldTypeString', 'alias': 'LESZ', 'length': 5, 'domain': None}, {'name': 'RESZ', 'type': 'esriFieldTypeString', 'alias': 'RESZ', 'length': 5, 'domain': None}, {'name': 'SPEED_SOURCE', 'type': 'esriFieldTypeInteger', 'alias': 'SPEED_SOURCE', 'domain': None}, {'name': 'INVISIBLE_UC', 'type': 'esriFieldTypeSmallInteger', 'alias': 'INVISIBLE_UC', 'domain': None}, {'name': 'URBAN_CODE', 'type': 'esriFieldTypeInteger', 'alias': 'URBAN_CODE', 'domain': None}, {'name': 'FAID_N', 'type': 'esriFieldTypeDouble', 'alias': 'FAID_N', 'domain': None}, {'name': 'SPEEDLIMIT', 'type': 'esriFieldTypeInteger', 'alias': 'SPEEDLIMIT', 'domain': None}, {'name': 'MILES', 'type': 'esriFieldTypeDouble', 'alias': 'MILES', 'domain': None}, {'name': 'MINUTES', 'type': 'esriFieldTypeInteger', 'alias': 'MINUTES', 'domain': None}, {'name': 'BB_Miles', 'type': 'esriFieldTypeDouble', 'alias': 'BB_Miles', 'domain': None}, {'name': 'BB_TYPE', 'type': 'esriFieldTypeString', 'alias': 'BB_TYPE', 'length': 50, 'domain': None}, {'name': 'COUNT_ESITEID', 'type': 'esriFieldTypeInteger', 'alias': 'COUNT_ESITEID', 'domain': None}, {'name': 'TOWNNAME', 'type': 'esriFieldTypeString', 'alias': 'TOWNNAME', 'length': 1073741822, 'domain': None}, {'name': 'TOWNGEOID', 'type': 'esriFieldTypeDouble', 'alias': 'TOWNGEOID', 'domain': None}, {'name': 'CUD', 'type': 'esriFieldTypeString', 'alias': 'CUD', 'length': 1073741822, 'domain': None}, {'name': 'Shape', 'type': 'esriFieldTypeGeometry', 'alias': 'Shape', 'domain': None}, {'name': 'Shape.STLength()', 'type': 'esriFieldTypeDouble', 'alias': 'Shape.STLength()', 'domain': None}]
[{'name': 'R84_pk', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': ''}, {'name': 'UUID_84', 'fields': 'GlobalID', 'isAscending': True, 'isUnique': False, 'description': ''}, {'name': 'S61_idx', 'fields': 'Shape', 'isAscending': True, 'isUnique': True, 'description': ''}]
[]
{'renderer': {'type': 'simple', 'symbol': {'type': 'esriSLS', 'style': 'esriSLSSolid', 'color': [155, 161, 0, 255], 'width': 1}, 'label': '', 'description': ''}, 'transparency': 0, 'labelingInfo': None}
nan
nan