View In:   ArcGIS Online Map Viewer

Name: Splice Closure

Display Field: splicenumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: A device, usually a weatherproof encasement commonly made of tough plactic used to protect the exposed area between spliced cables or fibers.

Service Item Id: c52654c359a04654b2444d1e3c47c568

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -8932425.1446
YMin: 4815866.445500001
XMax: 566960.2857000008
YMax: 5394375.4108000025
Spatial Reference: 26917  (26917)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• creationuser ( type: esriFieldTypeString, alias: Creation User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CREATIONUSER )
• datecreated ( type: esriFieldTypeDate, alias: Date Created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• lastuser ( type: esriFieldTypeString, alias: Last User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTUSER )
• datemodified ( type: esriFieldTypeDate, alias: Date Modified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEMODIFIED )
• clli ( type: esriFieldTypeString, alias: CLLI, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CLLI )
• structure_name ( type: esriFieldTypeString, alias: Structure Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STRUCTURE_NAME )
• ancillaryrole ( type: esriFieldTypeInteger, alias: Ancillary Role, editable: true, nullable: true, defaultValue: null, modelName: ANCILLARYROLE )
• inventory_status_code ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 150, defaultValue: Planned, modelName: INVENTORY_STATUS_CODE , Coded Values: [Planned: Planned] , [Installed: Installed] , [Abandoned: Abandoned] )
• splicenumber ( type: esriFieldTypeString, alias: Splice Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SPLICENUMBER )
• placementtype ( type: esriFieldTypeString, alias: Placement Type, editable: true, nullable: true, length: 50, defaultValue: Underground, modelName: PLACEMENTTYPE , Coded Values: [Aerial: Aerial] , [Underground: Underground] , [Bridge Span: Bridge Span] )
• installationdate ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATIONDATE )
• manufacturer ( type: esriFieldTypeString, alias: Installation Contractor, editable: true, nullable: true, length: 100, defaultValue: CCC, modelName: MANUFACTURER , Coded Values: [ACP: ACP] , [Acronym: Acronym] , [CCC: CCC] , ...4 more... )
• modelnumber ( type: esriFieldTypeString, alias: Model Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MODELNUMBER )
• partnumber ( type: esriFieldTypeString, alias: Part Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PARTNUMBER )
• serialnumber ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SERIALNUMBER )
• cost ( type: esriFieldTypeDouble, alias: Cost, editable: true, nullable: true, defaultValue: null, modelName: COST )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• ipid ( type: esriFieldTypeString, alias: IPID, editable: true, nullable: true, length: 90, defaultValue: null, modelName: IPID )
• id ( type: esriFieldTypeGUID, alias: ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ID )
• rotation ( type: esriFieldTypeDouble, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• threegisid ( type: esriFieldTypeGUID, alias: 3-GIS ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: THREEGISID )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• edittrackinguser ( type: esriFieldTypeString, alias: EDITTRACKINGUSER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: EDITTRACKINGUSER )
• edittrackingdate ( type: esriFieldTypeDate, alias: EDITTRACKINGDATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EDITTRACKINGDATE )
• mounttype ( type: esriFieldTypeString, alias: MOUNTTYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MOUNTTYPE )
• attenuation ( type: esriFieldTypeDouble, alias: ATTENUATION, editable: true, nullable: true, defaultValue: null, modelName: ATTENUATION )
• splicelocation ( type: esriFieldTypeString, alias: Splice Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SPLICELOCATION )
• contract_id ( type: esriFieldTypeString, alias: Contract Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: contract_id )
• spliceenclosuretype ( type: esriFieldTypeString, alias: Splice Enclosure Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: spliceenclosuretype , Coded Values: [400D: 400D] , [PLP Regular: PLP Regular] , [PLP Stubby: PLP Stubby] , ...4 more... )
• level_begin ( type: esriFieldTypeInteger, alias: level_begin, editable: true, nullable: true, defaultValue: null, modelName: level_begin )
• level_end ( type: esriFieldTypeInteger, alias: level_end, editable: true, nullable: true, defaultValue: null, modelName: level_end )
• floor ( type: esriFieldTypeSmallInteger, alias: floor, editable: true, nullable: true, defaultValue: null, modelName: floor )
• ConsultantReference ( type: esriFieldTypeString, alias: Consultant Reference, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ConsultantReference )
• UsageType ( type: esriFieldTypeSmallInteger, alias: Usage Type, editable: true, nullable: true, defaultValue: 1, modelName: UsageType , Coded Values: [1: Fiber] , [2: Composite] )
• CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreatedBy )
• CreatedDate ( type: esriFieldTypeDate, alias: CreatedDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )
• cable_category ( type: esriFieldTypeString, alias: Cabel Category, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cable_category , Coded Values: [BB: Backbone Fiber] , [DIST: Distribution Fiber] , [DRP: Drop Fiber] )

Templates:

• Name: AER
  Description:
  Prototype:
  floor: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  ancillaryrole: null
  inventory_status_code: Planned
  splicenumber: null
  placementtype: Underground
  installationdate: null
  manufacturer: CCC
  modelnumber: null
  partnumber: null
  serialnumber: null
  cost: null
  comments: null
  ipid: null
  id: null
  rotation: null
  threegisid: null
  cable_category: null
  ConsultantReference: null
  UsageType: 1
  mounttype: null
  attenuation: null
  splicelocation: null
  contract_id: null
  spliceenclosuretype: null
  level_begin: null
  level_end: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: AER_SHR
  Description:
  Prototype:
  floor: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  ancillaryrole: null
  inventory_status_code: Planned
  splicenumber: null
  placementtype: Underground
  installationdate: null
  manufacturer: CCC
  modelnumber: null
  partnumber: null
  serialnumber: null
  cost: null
  comments: null
  ipid: null
  id: null
  rotation: null
  threegisid: null
  cable_category: null
  ConsultantReference: null
  UsageType: 1
  mounttype: null
  attenuation: null
  splicelocation: null
  contract_id: null
  spliceenclosuretype: null
  level_begin: null
  level_end: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: AER_SHR_RE
  Description:
  Prototype:
  floor: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  ancillaryrole: null
  inventory_status_code: Planned
  splicenumber: null
  placementtype: Underground
  installationdate: null
  manufacturer: CCC
  modelnumber: null
  partnumber: null
  serialnumber: null
  cost: null
  comments: null
  ipid: null
  id: null
  rotation: null
  threegisid: null
  cable_category: null
  ConsultantReference: null
  UsageType: 1
  mounttype: null
  attenuation: null
  splicelocation: null
  contract_id: null
  spliceenclosuretype: null
  level_begin: null
  level_end: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: MCA
  Description:
  Prototype:
  floor: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  ancillaryrole: null
  inventory_status_code: Planned
  splicenumber: null
  placementtype: Underground
  installationdate: null
  manufacturer: CCC
  modelnumber: null
  partnumber: null
  serialnumber: null
  cost: null
  comments: null
  ipid: null
  id: null
  rotation: null
  threegisid: null
  cable_category: null
  ConsultantReference: null
  UsageType: 1
  mounttype: null
  attenuation: null
  splicelocation: null
  contract_id: null
  spliceenclosuretype: null
  level_begin: null
  level_end: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: SPL
  Description:
  Prototype:
  floor: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  ancillaryrole: null
  inventory_status_code: Planned
  splicenumber: null
  placementtype: Underground
  installationdate: null
  manufacturer: CCC
  modelnumber: null
  partnumber: null
  serialnumber: null
  cost: null
  comments: null
  ipid: null
  id: null
  rotation: null
  threegisid: null
  cable_category: null
  ConsultantReference: null
  UsageType: 1
  mounttype: null
  attenuation: null
  splicelocation: null
  contract_id: null
  spliceenclosuretype: null
  level_begin: null
  level_end: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: UG
  Description:
  Prototype:
  floor: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  ancillaryrole: null
  inventory_status_code: Planned
  splicenumber: null
  placementtype: Underground
  installationdate: null
  manufacturer: CCC
  modelnumber: null
  partnumber: null
  serialnumber: null
  cost: null
  comments: null
  ipid: null
  id: null
  rotation: null
  threegisid: null
  cable_category: null
  ConsultantReference: null
  UsageType: 1
  mounttype: null
  attenuation: null
  splicelocation: null
  contract_id: null
  spliceenclosuretype: null
  level_begin: null
  level_end: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: UG_SHR
  Description:
  Prototype:
  floor: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  ancillaryrole: null
  inventory_status_code: Planned
  splicenumber: null
  placementtype: Underground
  installationdate: null
  manufacturer: CCC
  modelnumber: null
  partnumber: null
  serialnumber: null
  cost: null
  comments: null
  ipid: null
  id: null
  rotation: null
  threegisid: null
  cable_category: null
  ConsultantReference: null
  UsageType: 1
  mounttype: null
  attenuation: null
  splicelocation: null
  contract_id: null
  spliceenclosuretype: null
  level_begin: null
  level_end: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: UG_SHR_RE
  Description:
  Prototype:
  floor: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  ancillaryrole: null
  inventory_status_code: Planned
  splicenumber: null
  placementtype: Underground
  installationdate: null
  manufacturer: CCC
  modelnumber: null
  partnumber: null
  serialnumber: null
  cost: null
  comments: null
  ipid: null
  id: null
  rotation: null
  threegisid: null
  cable_category: null
  ConsultantReference: null
  UsageType: 1
  mounttype: null
  attenuation: null
  splicelocation: null
  contract_id: null
  spliceenclosuretype: null
  level_begin: null
  level_end: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: RIS
  Description:
  Prototype:
  floor: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  ancillaryrole: null
  inventory_status_code: Planned
  splicenumber: null
  placementtype: Underground
  installationdate: null
  manufacturer: CCC
  modelnumber: null
  partnumber: null
  serialnumber: null
  cost: null
  comments: null
  ipid: null
  id: null
  rotation: null
  threegisid: null
  cable_category: null
  ConsultantReference: null
  UsageType: 1
  mounttype: null
  attenuation: null
  splicelocation: null
  contract_id: null
  spliceenclosuretype: null
  level_begin: null
  level_end: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• structure (0) -- Related To: Structure (3)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CreatedDate
• Creator Field: CreatedBy
• Edit Date Field: edittrackingdate
• Editor Field: edittrackinguser

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata