View In:   ArcGIS Online Map Viewer

Name: Switching Facility

Display Field: creation_user

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 1e985200e16545c397c1ff4585474561

Copyright Text:

Default Visibility: true

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: 2103241.146850586
YMin: 222321.98779296875
XMax: 2170667.3604125977
YMax: 264456.5891723633
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: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 255, 255] Width: 0
Default Label: <all other values>
UniqueValueInfos:
• Value: 1
  Label: JUNC-CAN-3P
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [252, 250, 192, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 2
  Label: JUNC-CAN-1P
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [216, 182, 252, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 3
  Label: SWITCH-CUBE
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [187, 239, 252, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
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 )
• 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: 1, alias: Subtype, type: esriFieldTypeInteger )
• 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 )
• comments ( modelName: COMMENTS, nullable: true, editable: true, defaultValue: null, length: 100, alias: Comments, type: esriFieldTypeString )
• 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 )
• owner ( modelName: OWNER, nullable: false, editable: true, defaultValue: null, length: 5, alias: Owner, type: esriFieldTypeString )
• alternate_x ( modelName: ALTERNATE_X, nullable: true, editable: true, defaultValue: null, alias: Alternate - X, type: esriFieldTypeDouble )
• alternate_y ( modelName: ALTERNATE_Y, nullable: true, editable: true, defaultValue: null, alias: Alternate - Y, type: esriFieldTypeDouble )
• alternate_z ( modelName: ALTERNATE_Z, nullable: true, editable: true, defaultValue: null, alias: Alternate - Z, type: esriFieldTypeDouble )
• alternate_coordinate_source ( modelName: ALTERNATE_COORDINATE_SOURCE, nullable: true, editable: true, defaultValue: null, length: 5, alias: Alternate Coordinate Source, type: esriFieldTypeString , Coded Values: )
• symbol_rotation ( modelName: SYMBOL_ROTATION, nullable: false, editable: true, defaultValue: 0, alias: Symbol Rotation, type: esriFieldTypeDouble )
• nominal_voltage ( modelName: NOMINAL_VOLTAGE, nullable: false, editable: true, defaultValue: null, alias: Nominal Voltage, type: esriFieldTypeInteger , Coded Values: [220: 12470Y/7200] )
• configuration ( modelName: CONFIGURATION, nullable: true, editable: true, defaultValue: null, length: 20, alias: Configuration, type: esriFieldTypeString )
• manufacturer ( modelName: MANUFACTURER, nullable: true, editable: true, defaultValue: null, length: 20, alias: Manufacturer, type: esriFieldTypeString )
• model ( modelName: MODEL, nullable: true, editable: true, defaultValue: null, length: 20, alias: Model, type: esriFieldTypeString )
• gis_id ( modelName: GIS_ID, nullable: true, editable: true, defaultValue: null, alias: GIS ID, type: esriFieldTypeInteger )
• pole_id ( modelName: POLE_ID, nullable: true, editable: true, defaultValue: null, length: 7, alias: Pole ID, type: esriFieldTypeString )
• split_point ( modelName: SPLIT_POINT, nullable: true, editable: true, defaultValue: null, length: 3, alias: Split Point?, type: esriFieldTypeString , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• switch_facility_type ( modelName: SWITCH_FACILITY_TYPE, nullable: true, editable: true, defaultValue: null, length: 10, alias: Type, type: esriFieldTypeString , Coded Values: [PRIM: Primary] , [SEC: Secondary] , [PRI-SEC: Primary-Secondary] , ...2 more... )
• split_point_direction ( modelName: SPLIT_POINT_DIRECTION, nullable: true, editable: true, defaultValue: null, length: 5, alias: Split Point Direction, type: esriFieldTypeString , Coded Values: [E: E] , [E;W: E;W] , [N: N] , ...11 more... )
• layer ( modelName: LAYER, nullable: true, editable: true, defaultValue: null, length: 20, alias: LAYER, type: esriFieldTypeString )
• enabled ( modelName: Enabled, nullable: true, editable: true, defaultValue: 1, alias: Enabled, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• 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 )
• 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 )
• installation_date ( modelName: installation_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Installation Date, type: esriFieldTypeDate )
• date_modified ( modelName: date_modified, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Updated, type: esriFieldTypeDate )
• expreplacedate ( modelName: expreplacedate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: EXPREPLACEDATE, type: esriFieldTypeDate )
• icalcdate ( modelName: icalcdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: iCalcDate, type: esriFieldTypeDate )
• warrantydate ( modelName: warrantydate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Warranty Date, 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 )

Types:

ID: 1
Name: JUNC-CAN-3P
Domains:
• owner:
  Coded Values: [COE: City of Edmond]
• alternate_coordinate_source:
  Inherited
• switch_facility_type:
  Inherited
• subtype_cd:
  Coded Values: [1: JUNC-CAN-3P] , [2: JUNC-CAN-1P] , [3: SWITCH-CUBE]
• construction_status:
  Inherited
• split_point_direction:
  Inherited
• nominal_voltage:
  Inherited
• split_point:
  Inherited
• enabled:
  Inherited
Templates:
• Name: JUNC-CAN-3P
  Description:
  Prototype:
  inspcondition: null
  icof: null
  facilityid: null
  configuration: null
  creation_user: null
  pole_id: null
  gis_id: null
  split_point: null
  layer: null
  enabled: 1
  manufacturer: null
  ipof: null
  serialno: null
  alternate_coordinate_source: null
  last_user: null
  symbol_rotation: 0
  switch_facility_type: null
  subtype_cd: 1
  warrantydate: null
  model: null
  conditiondate: null
  owner: COE
  installcost: null
  comments: null
  icalcdate: null
  date_created: null
  nominal_voltage: 0
  expreplacedate: null
  replacecost: null
  expirationdate: null
  imspu: null
  alternate_z: null
  alternate_y: null
  installation_date: null
  imspo: null
  date_modified: null
  work_order_id: null
  alternate_x: null
  construction_status: null
  split_point_direction: null
  location: null
  ibre: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: JUNC-CAN-1P
Domains:
• owner:
  Coded Values: [COE: City of Edmond]
• alternate_coordinate_source:
  Inherited
• switch_facility_type:
  Inherited
• subtype_cd:
  Coded Values: [1: JUNC-CAN-3P] , [2: JUNC-CAN-1P] , [3: SWITCH-CUBE]
• construction_status:
  Inherited
• split_point_direction:
  Inherited
• nominal_voltage:
  Inherited
• split_point:
  Inherited
• enabled:
  Inherited
Templates:
• Name: JUNC-CAN-1P
  Description:
  Prototype:
  inspcondition: null
  icof: null
  facilityid: null
  configuration: null
  creation_user: null
  pole_id: null
  gis_id: null
  split_point: null
  layer: null
  enabled: 1
  manufacturer: null
  ipof: null
  serialno: null
  alternate_coordinate_source: null
  last_user: null
  symbol_rotation: 0
  switch_facility_type: null
  subtype_cd: 2
  warrantydate: null
  model: null
  conditiondate: null
  owner: COE
  installcost: null
  comments: null
  icalcdate: null
  date_created: null
  nominal_voltage: 0
  expreplacedate: null
  replacecost: null
  expirationdate: null
  imspu: null
  alternate_z: null
  alternate_y: null
  installation_date: null
  imspo: null
  date_modified: null
  work_order_id: null
  alternate_x: null
  construction_status: null
  split_point_direction: null
  location: null
  ibre: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: SWITCH-CUBE
Domains:
• owner:
  Coded Values: [COE: City of Edmond]
• alternate_coordinate_source:
  Inherited
• switch_facility_type:
  Inherited
• subtype_cd:
  Coded Values: [1: JUNC-CAN-3P] , [2: JUNC-CAN-1P] , [3: SWITCH-CUBE]
• construction_status:
  Inherited
• split_point_direction:
  Inherited
• nominal_voltage:
  Inherited
• split_point:
  Inherited
• enabled:
  Inherited
Templates:
• Name: SWITCH-CUBE
  Description:
  Prototype:
  inspcondition: null
  icof: null
  facilityid: null
  configuration: null
  creation_user: null
  pole_id: null
  gis_id: null
  split_point: null
  layer: null
  enabled: 1
  manufacturer: null
  ipof: null
  serialno: null
  alternate_coordinate_source: null
  last_user: null
  symbol_rotation: 0
  switch_facility_type: null
  subtype_cd: 3
  warrantydate: null
  model: null
  conditiondate: null
  owner: COE
  installcost: null
  comments: null
  icalcdate: null
  date_created: null
  nominal_voltage: 0
  expreplacedate: null
  replacecost: null
  expirationdate: null
  imspu: null
  alternate_z: null
  alternate_y: null
  installation_date: null
  imspo: null
  date_modified: null
  work_order_id: null
  alternate_x: null
  construction_status: null
  split_point_direction: null
  location: null
  ibre: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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 Bins   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata