View In:   ArcGIS Online Map Viewer

Name: Substation

Display Field: substation_name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

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: 2112918.0627441406
YMin: 230784.21447753906
XMax: 2160424.067565918
YMax: 259114.82550048828
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: esriSFSSolid
Color: [130, 130, 130, 255]
Outline:
Style: esriSLSSolid
Color: [225, 225, 225, 255]
Width: 0
Default Label: <all other values>
UniqueValueInfos:
• Value: 1
  Label: Substation
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [252, 250, 192, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 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: true
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: true, editable: true, defaultValue: COE, length: 5, alias: Ownership, type: esriFieldTypeString , Coded Values: [COE: City of Edmond] )
• substation_name ( modelName: SUBSTATION_NAME, nullable: true, editable: true, defaultValue: null, length: 20, alias: Substation Name, type: esriFieldTypeString , Coded Values: [DANFORTH: Danforth] , [EASTERN: Eastern] , [FAIRFIELD: Fairfield] , ...6 more... )
• substation_number ( modelName: SUBSTATION_NUMBER, nullable: true, editable: true, defaultValue: null, length: 20, alias: Substation Number, type: esriFieldTypeString )
• layer ( modelName: LAYER, nullable: true, editable: true, defaultValue: null, length: 20, alias: LAYER, type: esriFieldTypeString )
• image ( modelName: IMAGE, nullable: true, editable: true, defaultValue: null, length: 50, alias: IMAGE, type: esriFieldTypeString )
• condition ( modelName: CONDITION, nullable: true, editable: true, defaultValue: null, length: 10, alias: CONDITION, 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 )
• serialno ( modelName: serialno, nullable: true, editable: true, defaultValue: null, length: 255, alias: Serial Number, type: esriFieldTypeString )
• primaryimage ( modelName: primaryimage, nullable: true, editable: true, defaultValue: Substation.bmp, length: 255, alias: PrimaryImage, type: esriFieldTypeString )
• workdone ( modelName: workdone, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: WorkDone, type: esriFieldTypeDate )
• expirationdate ( modelName: expirationdate, 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 )
• 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 )
• icalcdate ( modelName: icalcdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: iCalcDate, type: esriFieldTypeDate )
• date_modified ( modelName: date_modified, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Updated, type: esriFieldTypeDate )
• installation_date ( modelName: installation_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Installation Date, type: esriFieldTypeDate )
• date_created ( modelName: date_created, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Creation Date, type: esriFieldTypeDate )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )

Types:

ID: 1
Name: Substation
Domains:
• owner:
  Inherited
• subtype_cd:
  Coded Values: [1: Substation]
• construction_status:
  Inherited
• substation_name:
  Inherited
Templates:
• Name: Substation
  Description:
  Prototype:
  inspcondition: null
  icof: null
  facilityid: null
  creation_user: null
  workdone: null
  substation_number: null
  layer: null
  ipof: null
  serialno: null
  last_user: null
  subtype_cd: 1
  warrantydate: null
  substation_name: null
  conditiondate: null
  owner: COE
  image: null
  installcost: null
  comments: null
  icalcdate: null
  date_created: null
  expreplacedate: null
  replacecost: null
  expirationdate: null
  imspu: null
  condition: null
  installation_date: null
  date_modified: null
  imspo: null
  work_order_id: null
  construction_status: null
  primaryimage: null
  location: null
  ibre: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

Relationships:

• E_BUS_BAR (3) -- Related To: Bus Bar (17)
• E_SWITCH (1) -- Related To: Switch (7)

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