View In:   ArcGIS Online Map Viewer

Name: Bus Bar

Display Field: creation_user

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 1e985200e16545c397c1ff4585474561

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.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

Extent:

XMin: 2112932.0631713867
YMin: 230841.11975097656
XMax: 2160407.726501465
YMax: 259105.67578125
Spatial Reference: 102724  (2267)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: subtype_cd
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 1
Default Label: <all other values>
UniqueValueInfos:
• Value: 1
  Label: Switchgear Bus Bar
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [252, 250, 192, 255]
  Width: 1
• Value: 2
  Label: Substation Distribution Bus Bar
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [216, 182, 252, 255]
  Width: 1
• Value: 3
  Label: Substation Transmission Bus Bar
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [187, 239, 252, 255]
  Width: 1
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: true
Supports Query With LOD Spatial Reference: true
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: subtype_cd

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• enabled ( modelName: Enabled, nullable: true, editable: true, defaultValue: 1, alias: Enabled, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• creation_user ( modelName: CREATION_USER, nullable: true, editable: true, defaultValue: null, length: 50, alias: Created By, type: esriFieldTypeString )
• last_user ( modelName: LAST_USER, nullable: true, editable: true, defaultValue: null, length: 50, alias: Updated By, type: esriFieldTypeString )
• subtype_cd ( modelName: SUBTYPE_CD, nullable: false, editable: true, defaultValue: 2, alias: Subtype, type: esriFieldTypeInteger )
• measured_length ( modelName: MEASURED_LENGTH, nullable: false, editable: true, defaultValue: null, alias: Calculated Length, type: esriFieldTypeDouble , Range: [1, 999999] )
• length_source ( modelName: LENGTH_SOURCE, nullable: false, editable: true, defaultValue: MS, length: 5, alias: Length Source, type: esriFieldTypeString , Coded Values: [MS: Mapping System] , [FM: Field Measurement] )
• construction_status ( modelName: CONSTRUCTION_STATUS, nullable: true, editable: true, defaultValue: null, alias: Construction Status, type: esriFieldTypeInteger , Coded Values: [0: Proposed] , [5: Existing] , [10: Waiting For Staking] , ...6 more... )
• work_order_id ( modelName: WORK_ORDER_ID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Work Order Number, type: esriFieldTypeString )
• phase_designation ( modelName: PHASE_DESIGNATION, nullable: false, editable: true, defaultValue: null, alias: Phase Designation, type: esriFieldTypeInteger )
• nominal_voltage ( modelName: NOMINAL_VOLTAGE, nullable: false, editable: true, defaultValue: null, alias: Nominal Voltage, type: esriFieldTypeInteger )
• operating_voltage ( modelName: OPERATING_VOLTAGE, nullable: false, editable: true, defaultValue: null, alias: Operating Voltage, type: esriFieldTypeInteger )
• feeder_id ( modelName: FEEDER_ID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Feeder ID, type: esriFieldTypeString )
• feeder_id2 ( modelName: FEEDER_ID2, nullable: true, editable: true, defaultValue: null, length: 20, alias: Feeder ID 2, type: esriFieldTypeString )
• feederinfo ( modelName: FEEDERINFO, nullable: true, editable: true, defaultValue: null, alias: Feeder Information, type: esriFieldTypeInteger )
• electrictraceweight ( modelName: ELECTRICTRACEWEIGHT, nullable: true, editable: true, defaultValue: null, alias: Electric Trace Weight, type: esriFieldTypeInteger )
• facilityid ( modelName: FACILITYID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Facility ID, type: esriFieldTypeString )
• location ( modelName: LOCATION, nullable: true, editable: true, defaultValue: null, length: 100, alias: Location, type: esriFieldTypeString )
• gis_id ( modelName: GIS_ID, nullable: true, editable: true, defaultValue: null, alias: GIS ID, type: esriFieldTypeInteger )
• conductor_description ( modelName: CONDUCTOR_DESCRIPTION, nullable: true, editable: true, defaultValue: null, length: 20, alias: MILSOFT Conductor Description, type: esriFieldTypeString )
• construction_description ( modelName: CONSTRUCTION_DESCRIPTION, nullable: true, editable: true, defaultValue: null, length: 20, alias: MILSOFT Construction Description, type: esriFieldTypeString )
• fdrmgrnontraceable ( modelName: FDRMGRNONTRACEABLE, nullable: true, editable: true, defaultValue: null, alias: Feeder Manager Non-Traceable, type: esriFieldTypeInteger )
• bus_bar_shape ( modelName: BUS_BAR_SHAPE, nullable: true, editable: true, defaultValue: null, length: 20, alias: Bus Bar Shape, type: esriFieldTypeString )
• loading ( modelName: LOADING, nullable: true, editable: true, defaultValue: null, length: 20, alias: Loading, type: esriFieldTypeString )
• spacing ( modelName: SPACING, nullable: true, editable: true, defaultValue: null, length: 20, alias: Spacing, type: esriFieldTypeString )
• rel_sw_facility_facid ( modelName: REL_SW_FACILITY_FACID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Related Switching Facility Facility ID, type: esriFieldTypeString )
• rel_substation_facid ( modelName: REL_SUBSTATION_FACID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Related Substation Facility ID, type: esriFieldTypeString )
• layer ( modelName: LAYER, nullable: true, editable: true, defaultValue: null, length: 20, alias: LAYER, type: esriFieldTypeString )
• inspcondition ( modelName: InspCondition, nullable: true, editable: true, defaultValue: null, alias: InspCondition, type: esriFieldTypeSmallInteger )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• installcost ( modelName: installcost, nullable: true, editable: true, defaultValue: null, alias: INSTALLCOST, type: esriFieldTypeDouble )
• replacecost ( modelName: replacecost, nullable: true, editable: true, defaultValue: null, alias: REPLACECOST, type: esriFieldTypeDouble )
• ipof ( modelName: ipof, nullable: true, editable: true, defaultValue: null, alias: iPOF, type: esriFieldTypeDouble )
• icof ( modelName: icof, nullable: true, editable: true, defaultValue: null, alias: iCOF, type: esriFieldTypeDouble )
• ibre ( modelName: ibre, nullable: true, editable: true, defaultValue: null, alias: iBRE, type: esriFieldTypeDouble )
• imspu ( modelName: imspu, nullable: true, editable: true, defaultValue: null, alias: iMSPU, type: esriFieldTypeDouble )
• imspo ( modelName: imspo, nullable: true, editable: true, defaultValue: null, alias: iMSPO, type: esriFieldTypeDouble )
• serno ( modelName: serno, nullable: true, editable: true, defaultValue: null, length: 255, alias: Serial Number, type: esriFieldTypeString )
• serialno ( modelName: serialno, nullable: true, editable: true, defaultValue: null, length: 255, alias: Serial Number, type: esriFieldTypeString )
• expirationdate ( modelName: expirationdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Expiration Date, type: esriFieldTypeDate )
• date_modified ( modelName: date_modified, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Updated, type: esriFieldTypeDate )
• warrantydate ( modelName: warrantydate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Warranty Date, type: esriFieldTypeDate )
• expdate ( modelName: expdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Expiration Date, type: esriFieldTypeDate )
• expreplacedate ( modelName: expreplacedate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: EXPREPLACEDATE, type: esriFieldTypeDate )
• conditiondate ( modelName: conditiondate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: ConditionDate, type: esriFieldTypeDate )
• date_created ( modelName: date_created, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Creation Date, type: esriFieldTypeDate )
• icalcdate ( modelName: icalcdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: iCalcDate, type: esriFieldTypeDate )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Types:

ID: 1
Name: Switchgear Bus Bar
Domains:
• phase_designation:
  Coded Values: [4: A] , [6: AB] , [5: AC] , ...4 more...
• measured_length:
  Inherited
• operating_voltage:
  Coded Values: [155: 7200 V] , [225: 12470/7200] , [465: 138000]
• subtype_cd:
  Coded Values: [1: Switchgear Bus Bar] , [2: Substation Distribution Bus Bar] , [3: Substation Transmission Bus Bar]
• construction_status:
  Inherited
• fdrmgrnontraceable:
  Coded Values: [1: Non-Traceable] , [0: Traceable]
• nominal_voltage:
  Coded Values: [220: 12470Y/7200]
• enabled:
  Inherited
• length_source:
  Inherited
Templates:
• Name: Switchgear Bus Bar
  Description:
  Prototype:
  inspcondition: null
  icof: null
  facilityid: null
  construction_description: null
  conductor_description: null
  creation_user: null
  gis_id: null
  rel_sw_facility_facid: null
  enabled: 1
  layer: null
  ipof: null
  serialno: null
  electrictraceweight: null
  spacing: null
  last_user: null
  feeder_id: null
  feeder_id2: null
  subtype_cd: 1
  rel_substation_facid: null
  warrantydate: null
  conditiondate: null
  installcost: null
  icalcdate: null
  feederinfo: null
  serno: null
  date_created: null
  nominal_voltage: 220
  expreplacedate: null
  replacecost: null
  loading: null
  expirationdate: null
  imspu: null
  phase_designation: 0
  measured_length: 0
  bus_bar_shape: null
  imspo: null
  date_modified: null
  work_order_id: null
  operating_voltage: 0
  construction_status: null
  fdrmgrnontraceable: 0
  location: null
  ibre: null
  length_source: MS
  expdate: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Substation Distribution Bus Bar
Domains:
• phase_designation:
  Coded Values: [7: ABC]
• measured_length:
  Inherited
• operating_voltage:
  Coded Values: [155: 7200 V] , [225: 12470/7200] , [465: 138000]
• subtype_cd:
  Coded Values: [1: Switchgear Bus Bar] , [2: Substation Distribution Bus Bar] , [3: Substation Transmission Bus Bar]
• construction_status:
  Inherited
• fdrmgrnontraceable:
  Coded Values: [1: Non-Traceable] , [0: Traceable]
• nominal_voltage:
  Coded Values: [220: 12470Y/7200]
• enabled:
  Inherited
• length_source:
  Inherited
Templates:
• Name: Substation Distribution Bus Bar
  Description:
  Prototype:
  inspcondition: null
  icof: null
  facilityid: null
  construction_description: null
  conductor_description: null
  creation_user: null
  gis_id: null
  rel_sw_facility_facid: null
  enabled: 1
  layer: null
  ipof: null
  serialno: null
  electrictraceweight: null
  spacing: null
  last_user: null
  feeder_id: null
  feeder_id2: null
  subtype_cd: 2
  rel_substation_facid: null
  warrantydate: null
  conditiondate: null
  installcost: null
  icalcdate: null
  feederinfo: null
  serno: null
  date_created: null
  nominal_voltage: 220
  expreplacedate: null
  replacecost: null
  loading: null
  expirationdate: null
  imspu: null
  phase_designation: 7
  measured_length: 0
  bus_bar_shape: null
  imspo: null
  date_modified: null
  work_order_id: null
  operating_voltage: 225
  construction_status: null
  fdrmgrnontraceable: 0
  location: null
  ibre: null
  length_source: MS
  expdate: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: Substation Transmission Bus Bar
Domains:
• phase_designation:
  Coded Values: [7: ABC]
• measured_length:
  Inherited
• operating_voltage:
  Coded Values: [465: 138000 V]
• subtype_cd:
  Coded Values: [1: Switchgear Bus Bar] , [2: Substation Distribution Bus Bar] , [3: Substation Transmission Bus Bar]
• construction_status:
  Inherited
• fdrmgrnontraceable:
  Coded Values: [1: Non-Traceable] , [0: Traceable]
• nominal_voltage:
  Coded Values: [465: 138000 V]
• enabled:
  Inherited
• length_source:
  Inherited
Templates:
• Name: Substation Transmission Bus Bar
  Description:
  Prototype:
  inspcondition: null
  icof: null
  facilityid: null
  construction_description: null
  conductor_description: null
  creation_user: null
  gis_id: null
  rel_sw_facility_facid: null
  enabled: 1
  layer: null
  ipof: null
  serialno: null
  electrictraceweight: null
  spacing: null
  last_user: null
  feeder_id: null
  feeder_id2: null
  subtype_cd: 3
  rel_substation_facid: null
  warrantydate: null
  conditiondate: null
  installcost: null
  icalcdate: null
  feederinfo: null
  serno: null
  date_created: null
  nominal_voltage: 465
  expreplacedate: null
  replacecost: null
  loading: null
  expirationdate: null
  imspu: null
  phase_designation: 7
  measured_length: 0
  bus_bar_shape: null
  imspo: null
  date_modified: null
  work_order_id: null
  operating_voltage: 465
  construction_status: null
  fdrmgrnontraceable: 1
  location: null
  ibre: null
  length_source: MS
  expdate: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Relationships:

• E_SUBSTATION (3) -- Related To: Substation (23)

Capabilities: Query,Create,Update,Delete,Editing,Uploads

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata