Name: BV FIBERCABLE

Display Field: cable_name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

Min Scale: 500000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Extent:

XMin: 313026.47250000015
YMin: 4403618.9536
XMax: 356287.2608000003
YMax: 4474997.2507
Spatial Reference: 32617  (32617)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: cable_category
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [0, 166, 116, 255]
Width: 1
Default Label:
UniqueValueInfos:
• Value: Backhaul
  Label: Core
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [250, 52, 17, 255]
  Width: 3
• Value: Fronthaul
  Label: Core
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [250, 52, 17, 255]
  Width: 3
• Value: Cancelled
  Label: Cancelled
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [156, 156, 156, 255]
  Width: 3
• Value: ODN
  Label: ODN
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [115, 178, 255, 255]
  Width: 3
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• objectid ( type: esriFieldTypeOID , alias: OBJECTID )
• creationuser ( type: esriFieldTypeString , alias: Creation User , length: 50 )
• datecreated ( type: esriFieldTypeDate , alias: Date Created , length: 36 )
• lastuser ( type: esriFieldTypeString , alias: Last User , length: 50 )
• datemodified ( type: esriFieldTypeDate , alias: Date Modified , length: 36 )
• enabled ( type: esriFieldTypeInteger , alias: Enabled )
• clli ( type: esriFieldTypeString , alias: CLLI , length: 100 )
• cable_name ( type: esriFieldTypeString , alias: Cable Name , length: 50 )
• cable_category ( type: esriFieldTypeString , alias: Hierarchy , length: 255 , Coded Values: [Fronthaul: Fronthaul] , [Backhaul: Backhaul] , [ODN: ODN] , ...1 more... )
• used_for ( type: esriFieldTypeString , alias: Used For , length: 150 , Coded Values: [BACKBONE: Backbone] , [LATERAL: Lateral] , [ENTRANCELATERAL: Entrance Lateral] , ...4 more... )
• inventory_status_code ( type: esriFieldTypeString , alias: Inventory Status Code , length: 150 , Coded Values: [Abandoned: Abandoned] , [Proposed: Proposed] , [Do Not Build: Do Not Build] , ...18 more... )
• from_sequential ( type: esriFieldTypeSmallInteger , alias: FromSequentialNOUSE )
• to_sequential ( type: esriFieldTypeSmallInteger , alias: ToSequential_NOUSE )
• calculatedlength ( type: esriFieldTypeDouble , alias: Calculated Length )
• measuredlength ( type: esriFieldTypeDouble , alias: Measured Length )
• placementtype ( type: esriFieldTypeString , alias: Placement Type , length: 50 , Coded Values: [Aerial: Aerial] , [Underground: Underground] , [TVI (Trench Vault Intercept): TVI (Trench Vault Intercept)] )
• from_structure ( type: esriFieldTypeString , alias: From Structure , length: 255 )
• to_structure ( type: esriFieldTypeString , alias: To Structure , length: 255 )
• reelid ( type: esriFieldTypeString , alias: Reel ID , length: 100 )
• cabletype ( type: esriFieldTypeString , alias: Cable Type , length: 100 , Coded Values: [RIBBON: Ribbon] , [LOOSE_TUBE: Loose Tube] )
• sheathtype ( type: esriFieldTypeString , alias: Sheath Type , length: 100 , Coded Values: [Armored: Armored] , [Dielectric: Dielectric] )
• coretype ( type: esriFieldTypeInteger , alias: Core Type , Coded Values: [1: Metallic] , [2: Non-Metallic] )
• diameter ( type: esriFieldTypeDouble , alias: Diameter )
• colorscheme ( type: esriFieldTypeInteger , alias: Color Scheme )
• buffercount ( type: esriFieldTypeInteger , alias: Buffer Count , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...37 more... )
• fibersperbuffer ( type: esriFieldTypeInteger , alias: Fibers Per Buffer )
• fibercount ( type: esriFieldTypeInteger , alias: Fiber Count , Coded Values: [1: 1] , [2: 2] , [4: 4] , ...36 more... )
• ribboncount ( type: esriFieldTypeInteger , alias: Ribbon Count )
• assignedfibercount ( type: esriFieldTypeInteger , alias: OLD - FiberCountAssigned )
• freefibercount ( type: esriFieldTypeInteger , alias: Fiber Count - Free )
• sparefibercount ( type: esriFieldTypeInteger , alias: Fiber Count - Spare )
• strandedfibercount ( type: esriFieldTypeInteger , alias: Fiber Count - Stranded )
• unknownfibercount ( type: esriFieldTypeInteger , alias: Fiber Count - Unknown )
• isoddcountfront ( type: esriFieldTypeString , alias: Is Odd Count Front , length: 5 )
• installationdate ( type: esriFieldTypeDate , alias: Installation Date , length: 36 )
• manufacturer ( type: esriFieldTypeString , alias: Manufacturer , length: 100 , Coded Values: [3M: 3M] , [ACT: ACT] , [ADC: ADC COMMUNICATIONS] , ...38 more... )
• partnumber ( type: esriFieldTypeString , alias: Part Number , length: 100 )
• materialcost ( type: esriFieldTypeDouble , alias: Material Cost )
• accountcode ( type: esriFieldTypeString , alias: Account Code , length: 100 )
• owner ( type: esriFieldTypeString , alias: OwnerNOTUSE , length: 255 )
• owner_contact_number ( type: esriFieldTypeString , alias: Cable Owner Contact Number , length: 100 )
• locate_vendor ( type: esriFieldTypeString , alias: Locate Vendor , length: 255 )
• locate_vendor_contact_number ( type: esriFieldTypeString , alias: Locate Vendor Contact Number , length: 100 )
• splice_vendor ( type: esriFieldTypeString , alias: Splice Vendor , length: 255 )
• splice_vendor_contact_number ( type: esriFieldTypeString , alias: Splice Vendor Contact Number , length: 100 )
• comments ( type: esriFieldTypeString , alias: Comments , length: 255 )
• ipid ( type: esriFieldTypeString , alias: IPID , length: 90 )
• segmentid ( type: esriFieldTypeString , alias: Segment ID , length: 90 )
• spanipid ( type: esriFieldTypeString , alias: Span IPID , length: 90 )
• conduitipid ( type: esriFieldTypeString , alias: Conduit IPID , length: 90 )
• ductipid ( type: esriFieldTypeString , alias: Duct IPID , length: 90 )
• innerductipid ( type: esriFieldTypeString , alias: Inner Duct IPID , length: 90 )
• hyperlink ( type: esriFieldTypeString , alias: Hyperlink , length: 255 )
• id ( type: esriFieldTypeGUID , alias: ID , length: 38 )
• threegisid ( type: esriFieldTypeGUID , alias: 3-GIS ID , length: 38 )
• globalid ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 )
• edittrackinguser ( type: esriFieldTypeString , alias: EDITTRACKINGUSER , length: 255 )
• edittrackingdate ( type: esriFieldTypeDate , alias: EDITTRACKINGDATE , length: 36 )
• attenuation ( type: esriFieldTypeDouble , alias: ATTENUATION )
• bv_capital_project_number ( type: esriFieldTypeString , alias: CAPITAL_PROJECT_NUMBER , length: 50 )
• bv_projectname ( type: esriFieldTypeString , alias: PROJECTNAME , length: 30 )
• bv_category_name ( type: esriFieldTypeString , alias: ODN_Category_Name , length: 20 , Coded Values: [TAIL: TAIL] , [FEEDER: FEEDER] , [DISTRIBUTION: DISTRIBUTION] , ...2 more... )
• bv_to_equipment_name ( type: esriFieldTypeString , alias: TO_EQUIPMENT_NAME , length: 35 )
• bv_from_equipment_name ( type: esriFieldTypeString , alias: FROM_EQUIPMENT_NAME , length: 30 )
• bv_to_splice_closure_name ( type: esriFieldTypeString , alias: TO_SPLICE_CLOSURE_NAME , length: 30 )
• bv_from_splice_closure_name ( type: esriFieldTypeString , alias: FROM_SPLICE_CLOSURE_NAME , length: 30 )
• bv_label_id_text ( type: esriFieldTypeString , alias: LABEL_ID_TEXT , length: 20 )
• bv_field_verified ( type: esriFieldTypeString , alias: FIELD_VERIFIED , length: 2 , Coded Values: [Y: Y] , [N: N] )
• bv_protected ( type: esriFieldTypeString , alias: PROTECTED , length: 2 , Coded Values: [Y: Y] , [N: N] )
• bv_fqn_id ( type: esriFieldTypeString , alias: FQN ID , length: 50 )
• bv_field_verification_method ( type: esriFieldTypeString , alias: FIELD VERIFICATION METHOD , length: 150 , Coded Values: [Records: Records] , [Field Visit: Field Visit] )
• bv_turfarea ( type: esriFieldTypeString , alias: TURFAREA , length: 20 )
• bv_workorderid ( type: esriFieldTypeString , alias: WorkOrderID , length: 50 )
• bv_status ( type: esriFieldTypeString , alias: BV Status , length: 50 , Coded Values: [Abandoned: Abandoned] , [Proposed: Proposed] , [Do Not Build: Do Not Build] , ...18 more... )
• bv_id ( type: esriFieldTypeInteger , alias: BV ID )
• bv_cipid ( type: esriFieldTypeInteger , alias: CIPID )
• bv_to ( type: esriFieldTypeString , alias: Fibercable To , length: 255 )
• bv_from ( type: esriFieldTypeString , alias: Fibercable From , length: 255 )
• bv_ringid ( type: esriFieldTypeString , alias: NORTHERN RING , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• bv_assignedfibercount ( type: esriFieldTypeString , alias: Fiber Count - Assigned , length: 250 )
• bv_deadfibercount ( type: esriFieldTypeInteger , alias: Fiber Count - Dead )
• bv_parallel ( type: esriFieldTypeString , alias: Is Parallel , length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• bv_first_fibercable ( type: esriFieldTypeSmallInteger , alias: First Fiber )
• bv_owner ( type: esriFieldTypeString , alias: Fiber Cable Owner , length: 50 , Coded Values: [XO: XO] , [LEGACY: LEGACY] , [QUEST: QUEST] , ...8 more... )
• bv_category ( type: esriFieldTypeString , alias: Category Use , length: 50 , Coded Values: [Fronthaul: Fronthaul] , [Backhaul: Backhaul] , [ODN: ODN] , ...1 more... )
• bv_batch_number ( type: esriFieldTypeString , alias: Batch Number , length: 100 )
• bv_serial_number ( type: esriFieldTypeString , alias: Serial Number , length: 100 )
• bv_fibercable_direction ( type: esriFieldTypeString , alias: Fiber - Direction , length: 50 , Coded Values: [bi: Bi-directional] , [uni: Uni-directional] )
• bv_fibercable_ribbionizing ( type: esriFieldTypeDouble , alias: Fiber - Ribbionizing )
• bv_ringid2 ( type: esriFieldTypeString , alias: CENTRAL RING , length: 15 , Coded Values: [Yes: Yes] , [No: No] )
• bv_ringid3 ( type: esriFieldTypeString , alias: SOUTHERN RING , length: 15 , Coded Values: [Yes: Yes] , [No: No] )
• bv_ringid4 ( type: esriFieldTypeString , alias: CORE RING , length: 15 , Coded Values: [Yes: Yes] , [No: No] )
• bv_overlash ( type: esriFieldTypeString , alias: Overlash , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• bv_special_crossing ( type: esriFieldTypeSmallInteger , alias: Special Crossing , Coded Values: [1: UG Railroad (Uncased Bore)] , [2: UG Waterway (Cased Bore)] , [3: UG Waterway (Uncased Bore)] , ...10 more... )
• bv_ringid5 ( type: esriFieldTypeString , alias: bv_ringid5 , length: 50 )
• bv_ringid6 ( type: esriFieldTypeString , alias: bv_ringid6 , length: 50 )
• bv_ringid7 ( type: esriFieldTypeString , alias: bv_ringid7 , length: 50 )
• bv_cran_hub ( type: esriFieldTypeString , alias: CRAN HUB , length: 50 , Coded Values: [OH COLUMBUS MTSO: OH COLUMBUS MTSO] , [OH EAST COLUMBUS: OH EAST COLUMBUS] , [OH GAHANNA: OH GAHANNA] , ...9 more... )
• bv_to_name ( type: esriFieldTypeString , alias: Fibercable To , length: 255 , Coded Values: [OH AEP RIVERSIDE: OH AEP RIVERSIDE] , [OH ALPINE: OH ALPINE] , [OH ALTON WALKER: OH ALTON WALKER] , ...357 more... )
• bv_from_name ( type: esriFieldTypeString , alias: Fibercable From , length: 255 , Coded Values: [OH COLUMBUS MTSO: OH COLUMBUS MTSO] , [OH EAST COLUMBUS: OH EAST COLUMBUS] , [OH GAHANNA: OH GAHANNA] , ...9 more... )
• bv_sitepriority ( type: esriFieldTypeInteger , alias: Priority , Coded Values: [1: 2017] , [3: 2018] , [2: Non OneFiber Build] )
• bv_specialnotes ( type: esriFieldTypeString , alias: special notes , length: 225 )
• bv_path ( type: esriFieldTypeString , alias: bv_path , length: 50 )
• bv_islateral ( type: esriFieldTypeString , alias: bv_isLateral_NOTuSE , length: 50 , Coded Values: [Y: Y] , [N: N] )
• bv_lateral_use ( type: esriFieldTypeString , alias: LATERAL , length: 50 , Coded Values: [A: LATERAL A] , [B: LATERAL B] , [C: LATERAL C] , ...14 more... )
• bv_leg ( type: esriFieldTypeString , alias: bv_leg , length: 50 , Coded Values: [1: LEG 1] , [2: LEG 2] , [3: LEG 3] , ...11 more... )
• bv_vzb_business ( type: esriFieldTypeString , alias: bv_vzb_business , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• bv_permit_status ( type: esriFieldTypeString , alias: PERMIT STATUS , length: 50 , Coded Values: [Issued for Permit: Issued for Permit] , [Permit Approved: Permit Approved] , [Permit Rejected: Permit Rejected] , ...2 more... )
• bv_assigned_designer ( type: esriFieldTypeString , alias: Assigned Designer , length: 50 )
• bv_quality_inspector ( type: esriFieldTypeString , alias: Quality Inspector , length: 50 , Coded Values: [Records: Records] , [Field Visit: Field Visit] )
• bv_cm_name ( type: esriFieldTypeString , alias: CM Name , length: 50 , Coded Values: [David Renyer: David Renyer] , [Bryan K Davis: Bryan K Davis] , [Rod Davis: Rod Davis] , ...9 more... )
• bv_contractor_name ( type: esriFieldTypeString , alias: Contractor Name , length: 50 , Coded Values: [ABS: ABS] , [Harris & Heavener: Harris & Heavener] , [Haas: Haas] , ...16 more... )
• bv_to_seqeuntial ( type: esriFieldTypeDouble , alias: To Sequential )
• bv_from_sequential ( type: esriFieldTypeDouble , alias: From Sequential )
• bv_asbuilt_length ( type: esriFieldTypeDouble , alias: As-Built Length )
• bv_cable_owner ( type: esriFieldTypeString , alias: Cable Owner , length: 50 , Coded Values: [Legacy: Legacy] , [OneFiber: OneFiber] )
• bv_networktype ( type: esriFieldTypeString , alias: Network Type , length: 50 )
• bv_complements ( type: esriFieldTypeString , alias: Complements , length: 255 )
• bv_vz_segments ( type: esriFieldTypeString , alias: VZ Segments , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• bv_old_fqn_id ( type: esriFieldTypeString , alias: bv_old_fqn_ID , length: 50 )
• bv_sitespan_name ( type: esriFieldTypeString , alias: Site-Span Name , length: 100 , Coded Values: [LeVeque Tower: LeVeque Tower] , [OH 2019185 COL_LAZELLE_SANCUS_3_W1 (D3-5GNR - B: OH 2019185 COL_LAZELLE_SANCUS_3_W1 (D3-5GNR - B] , [OH 2019186 COL_LAZELLE_SANCUS_4_W1 (D2-5GNR - B: OH 2019186 COL_LAZELLE_SANCUS_4_W1 (D2-5GNR - B] , ...682 more... )
• bv_nfid ( type: esriFieldTypeString , alias: Cluster Ring NFID , length: 100 , Coded Values: [1706BIZO: 1706BIZO] , [1706BIZP: 1706BIZP] , [1706BIZQ: 1706BIZQ] , ...13 more... )
• bv_reallength ( type: esriFieldTypeDouble , alias: As-Built Length w/ Slack )
• bv_site_span_nfid ( type: esriFieldTypeString , alias: Site Span NFID , length: 50 , Coded Values: [1706BIZO.002: 1706BIZO.002] , [1706BIZO.003: 1706BIZO.003] , [1706BIZO.004: 1706BIZO.004] , ...643 more... )
• bv_mre_permit_status ( type: esriFieldTypeString , alias: MRE Permit Status , length: 50 , Coded Values: [Application Submitted: Application Submitted] , [MRE Complete: MRE Complete] , [MRE Only Payments: MRE Only Payments] , ...3 more... )
• bv_mre_appid ( type: esriFieldTypeString , alias: Pole Application ID , length: 150 )
• bv_oldwo_id ( type: esriFieldTypeString , alias: Old Workorder ID , length: 100 )
• cad_label_1 ( type: esriFieldTypeString , alias: CAD_Label_1 , length: 255 )
• bv_assigned_vendor ( type: esriFieldTypeString , alias: Vendor Assigned , length: 50 , Coded Values: [B&V: B&V] , [Other: Other] , [V: V] , ...9 more... )
• bv_material_cd ( type: esriFieldTypeString , alias: Material CD , length: 100 )
• admincounts ( type: esriFieldTypeString , alias: Admin Counts , length: 1000 )
• bv_cx_start_planned ( type: esriFieldTypeDate , alias: Construction Start Planned , length: 36 )
• bv_cx_start_actual ( type: esriFieldTypeDate , alias: Construction Start Actual , length: 36 )
• bv_cable_placed_planned ( type: esriFieldTypeDate , alias: Cabled Placed Planned , length: 36 )
• bv_cable_placed_actual ( type: esriFieldTypeDate , alias: Cabled Placed Actual , length: 36 )
• bv_spliced_tested_planned ( type: esriFieldTypeDate , alias: Spliced Tested Planned , length: 36 )
• bv_spliced_tested_actual ( type: esriFieldTypeDate , alias: Spliced Tested Actual , length: 36 )
• bv_project_type ( type: esriFieldTypeString , alias: Project Type , length: 255 , Coded Values: [Core: Core] , [ODN: ODN] , [5G: 5G] )
• bv_asbuilt_gdb_uploaded ( type: esriFieldTypeString , alias: As-Built GDB Uploaded , length: 10 , Coded Values: [Y: Y] , [N: N] )
• bv_type_name ( type: esriFieldTypeString , alias: Type Name , length: 50 )
• bv_sub_combo_scenario ( type: esriFieldTypeString , alias: bv_sub_combo_scenario , length: 150 , Coded Values: [BV ENG/SUB CONDUIT/SUB FIBER: BV ENG/SUB CONDUIT/SUB FIBER] , [BV ENG/SUB CONDUIT/BV FIBER: BV ENG/SUB CONDUIT/BV FIBER] , [BV ENG/BV CONDUIT/SUB FIBER: BV ENG/BV CONDUIT/SUB FIBER] , ...2 more... )
• shape ( type: esriFieldTypeGeometry , alias: SHAPE )
• shape.STLength() ( type: esriFieldTypeDouble , alias: shape.STLength() )

Relationships:

• BV_PERMIT_POLYGONS (2) -- Related To: BV PERMIT POLYGONS (36)
• BV_SITES (0) -- Related To: Sites (6)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates