Name: VT Data - Broadband RDS 2021

Display Field: PRIMARYNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: 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

Copyright Text: Vermont Public Service Department

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 425571.7717000004
YMin: 25219.205800000578
XMax: 581485.2801000001
YMax: 279802.3222000003
Spatial Reference: 32145  (32145)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [155, 161, 0, 255]
Width: 1
Label:
Description:
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SEGMENTID ( type: esriFieldTypeInteger, alias: SEGMENTID )
• ARCID ( type: esriFieldTypeInteger, alias: ARCID )
• PD ( type: esriFieldTypeString, alias: PD, length: 10 )
• PT ( type: esriFieldTypeString, alias: PT, length: 10 )
• SN ( type: esriFieldTypeString, alias: SN, length: 80 )
• ST ( type: esriFieldTypeString, alias: ST, length: 10 )
• SD ( type: esriFieldTypeString, alias: SD, length: 10 )
• GEONAMEID ( type: esriFieldTypeInteger, alias: GEONAMEID )
• PRIMARYNAME ( type: esriFieldTypeString, alias: PRIMARYNAME, length: 100 )
• ALIAS1 ( type: esriFieldTypeString, alias: ALIAS1, length: 60 )
• ALIAS2 ( type: esriFieldTypeString, alias: ALIAS2, length: 60 )
• ALIAS3 ( type: esriFieldTypeString, alias: ALIAS3, length: 60 )
• ALIAS4 ( type: esriFieldTypeString, alias: ALIAS4, length: 60 )
• ALIAS5 ( type: esriFieldTypeString, alias: ALIAS5, length: 60 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• SURFACETYPE ( type: esriFieldTypeSmallInteger, alias: SURFACETYPE , Coded Values: [1: Paved] , [2: Gravel] , [9: Unknown] , ...3 more... )
• ONEWAY ( type: esriFieldTypeString, alias: ONEWAY, length: 1 , Coded Values: [N: No] , [Y: Yes - Direction of arc] , [X: Yes - Opposite direction of arc] )
• ADDRESSLOCK ( type: esriFieldTypeInteger, alias: ADDRESSLOCK , Coded Values: [1: Yes] , [0: No] )
• NO_MSAG ( type: esriFieldTypeInteger, alias: NO_MSAG )
• MCODE ( type: esriFieldTypeInteger, alias: MCODE )
• LESN ( type: esriFieldTypeInteger, alias: LESN )
• RESN ( type: esriFieldTypeInteger, alias: RESN )
• LTWN ( type: esriFieldTypeString, alias: LTWN, length: 50 )
• RTWN ( type: esriFieldTypeString, alias: RTWN, length: 50 )
• LLO_A ( type: esriFieldTypeInteger, alias: LLO_A )
• RLO_A ( type: esriFieldTypeInteger, alias: RLO_A )
• LHI_A ( type: esriFieldTypeInteger, alias: LHI_A )
• RHI_A ( type: esriFieldTypeInteger, alias: RHI_A )
• LZIP ( type: esriFieldTypeString, alias: LZIP, length: 10 )
• RZIP ( type: esriFieldTypeString, alias: RZIP, length: 10 )
• LLO_T ( type: esriFieldTypeInteger, alias: LLO_T )
• RLO_T ( type: esriFieldTypeInteger, alias: RLO_T )
• LHI_T ( type: esriFieldTypeInteger, alias: LHI_T )
• RHI_T ( type: esriFieldTypeInteger, alias: RHI_T )
• RTNAME ( type: esriFieldTypeString, alias: RTNAME, length: 12 )
• RTNUMBER ( type: esriFieldTypeString, alias: RTNUMBER, length: 4 )
• HWYSIGN ( type: esriFieldTypeString, alias: HWYSIGN, length: 12 )
• RPCCLASS ( type: esriFieldTypeSmallInteger, alias: RPCCLASS )
• AOTCLASS ( type: esriFieldTypeSmallInteger, alias: AOTCLASS , Coded Values: [1: Town Highway Class 1] , [2: Town Highway Class 2] , [3: Town Highway Class 3] , ...63 more... )
• NUTS ( type: esriFieldTypeString, alias: NUTS, length: 1 )
• NHS ( type: esriFieldTypeSmallInteger, alias: NHS )
• FUNCL ( type: esriFieldTypeSmallInteger, alias: FUNCL )
• TWN_LR ( type: esriFieldTypeString, alias: TWN_LR, length: 15 )
• ETE_LR ( type: esriFieldTypeString, alias: ETE_LR, length: 11 )
• CTCODE ( type: esriFieldTypeString, alias: CTCODE, length: 4 )
• UA ( type: esriFieldTypeSmallInteger, alias: UA )
• CTUA ( type: esriFieldTypeString, alias: CTUA, length: 6 )
• CERTCODE ( type: esriFieldTypeString, alias: CERTCODE, length: 6 )
• ARCMILES ( type: esriFieldTypeDouble, alias: ARCMILES )
• AOTMILES ( type: esriFieldTypeDouble, alias: AOTMILES )
• AOTMILES_CALC ( type: esriFieldTypeDouble, alias: AOTMILES_CALC )
• UPDACT ( type: esriFieldTypeString, alias: UPDACT, length: 1 )
• LOCMETH ( type: esriFieldTypeSmallInteger, alias: LOCMETH )
• SRCORG ( type: esriFieldTypeSmallInteger, alias: SRCORG )
• SCENICHWY ( type: esriFieldTypeSmallInteger, alias: SCENICHWY )
• SCENICBYWAY ( type: esriFieldTypeSmallInteger, alias: SCENICBYWAY )
• FORMER_RTNAME ( type: esriFieldTypeString, alias: FORMER_RTNAME, length: 12 )
• PROVISIONALYEAR ( type: esriFieldTypeSmallInteger, alias: PROVISIONALYEAR )
• ANCIENTROADYEAR ( type: esriFieldTypeSmallInteger, alias: ANCIENTROADYEAR )
• TRUCKROUTE ( type: esriFieldTypeSmallInteger, alias: TRUCKROUTE )
• ROADCLOSED ( type: esriFieldTypeString, alias: ROADCLOSED, length: 15 , Coded Values: [Closed: Closed] , [Closed_W: Closed-Winter] , [Closed_AVO: Closed-Authorized Vehicles Only] , ...5 more... )
• INSET ( type: esriFieldTypeString, alias: INSET, length: 1 )
• ISVISIBLE ( type: esriFieldTypeInteger, alias: ISVISIBLE )
• CERTYEAR ( type: esriFieldTypeSmallInteger, alias: CERTYEAR )
• MAPYEAR ( type: esriFieldTypeDate, alias: MAPYEAR, length: 8 )
• UPDATESOURCE ( type: esriFieldTypeString, alias: UPDATESOURCE, length: 30 )
• UPDATEDATE ( type: esriFieldTypeDate, alias: UPDATEDATE, length: 8 )
• GPSUPDATE ( type: esriFieldTypeString, alias: GPSUPDATE, length: 1 , Coded Values: [Y: Yes - Needs GPS Update] , [N: No - Does not need GPS Update] , [G: GPS Update Complete] , ...2 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• STATE ( type: esriFieldTypeString, alias: STATE, length: 2 )
• GAP ( type: esriFieldTypeInteger, alias: GAP )
• GAPMILES ( type: esriFieldTypeDouble, alias: GAPMILES )
• GAPSTREETID ( type: esriFieldTypeInteger, alias: GAPSTREETID )
• FIPS8 ( type: esriFieldTypeInteger, alias: FIPS8 )
• FAID_S ( type: esriFieldTypeDouble, alias: FAID_S )
• RTNUMBER_N ( type: esriFieldTypeDouble, alias: RTNUMBER_N )
• LCOUNTY ( type: esriFieldTypeString, alias: LCOUNTY, length: 25 )
• RCOUNTY ( type: esriFieldTypeString, alias: RCOUNTY, length: 25 )
• PRIMARYNAME1 ( type: esriFieldTypeString, alias: PRIMARYNAME1, length: 256 )
• SOURCEOFDATA ( type: esriFieldTypeString, alias: SOURCEOFDATA, length: 75 )
• COUNTRY ( type: esriFieldTypeString, alias: COUNTRY, length: 2 )
• PARITYLEFT ( type: esriFieldTypeString, alias: PARITYLEFT, length: 1 )
• PARITYRIGHT ( type: esriFieldTypeString, alias: PARITYRIGHT, length: 1 )
• GC_EXCEPTION ( type: esriFieldTypeString, alias: GC_EXCEPTION, length: 75 )
• LFIPS ( type: esriFieldTypeString, alias: LFIPS, length: 4 )
• RFIPS ( type: esriFieldTypeString, alias: RFIPS, length: 4 )
• LSTATE ( type: esriFieldTypeString, alias: LSTATE, length: 2 )
• RSTATE ( type: esriFieldTypeString, alias: RSTATE, length: 2 )
• LESZ ( type: esriFieldTypeString, alias: LESZ, length: 5 )
• RESZ ( type: esriFieldTypeString, alias: RESZ, length: 5 )
• SPEED_SOURCE ( type: esriFieldTypeInteger, alias: SPEED_SOURCE )
• INVISIBLE_UC ( type: esriFieldTypeSmallInteger, alias: INVISIBLE_UC )
• URBAN_CODE ( type: esriFieldTypeInteger, alias: URBAN_CODE )
• FAID_N ( type: esriFieldTypeDouble, alias: FAID_N )
• SPEEDLIMIT ( type: esriFieldTypeInteger, alias: SPEEDLIMIT )
• MILES ( type: esriFieldTypeDouble, alias: MILES )
• MINUTES ( type: esriFieldTypeInteger, alias: MINUTES )
• BB_Miles ( type: esriFieldTypeDouble, alias: BB_Miles )
• BB_TYPE ( type: esriFieldTypeString, alias: BB_TYPE, length: 50 )
• COUNT_ESITEID ( type: esriFieldTypeInteger, alias: COUNT_ESITEID )
• TOWNNAME ( type: esriFieldTypeString, alias: TOWNNAME, length: 1073741822 )
• TOWNGEOID ( type: esriFieldTypeDouble, alias: TOWNGEOID )
• CUD ( type: esriFieldTypeString, alias: CUD, length: 1073741822 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata