View In:   ArcGIS Online Map Viewer

Name: Substations

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 2d36fc242bd94460aed3f3cbcb3ad9f5

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: -9423189.934145674
YMin: 3986817.3062037453
XMax: -9398603.817898955
YMax: 4068596.366899468
Spatial Reference: 102100  (3857)  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: 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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• created_by ( modelName: Created_By, nullable: true, editable: false, defaultValue: null, length: 255, alias: Created_By, type: esriFieldTypeString )
• lastmodified_by ( modelName: LastModified_By, nullable: true, editable: false, defaultValue: null, length: 255, alias: LastModified_By, type: esriFieldTypeString )
• created_at ( modelName: Created_At, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Created_At, type: esriFieldTypeDate )
• lastmodified_at ( modelName: LastModified_At, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: LastModified_At, type: esriFieldTypeDate )
• editprocessed ( modelName: editprocessed, nullable: true, editable: true, defaultValue: null, alias: EditProcessed, type: esriFieldTypeInteger )
• squareid ( modelName: SquareId, nullable: false, editable: true, defaultValue: null, alias: SquareId, type: esriFieldTypeInteger )
• id ( modelName: Id, nullable: false, editable: true, defaultValue: null, alias: Id, type: esriFieldTypeInteger )
• classid ( modelName: ClassId, nullable: false, editable: true, defaultValue: 10, alias: ClassId, type: esriFieldTypeInteger , Coded Values: [10: Substation] , [40: AutoTranStation] )
• fatherid ( modelName: FatherId, nullable: false, editable: true, defaultValue: null, alias: FatherId, type: esriFieldTypeInteger )
• x ( modelName: x, nullable: false, editable: true, defaultValue: null, alias: Y-coord, type: esriFieldTypeDouble )
• y ( modelName: y, nullable: false, editable: true, defaultValue: null, alias: X-coord, type: esriFieldTypeDouble )
• z ( modelName: z, nullable: false, editable: true, defaultValue: null, alias: z, type: esriFieldTypeDouble )
• direction ( modelName: Direction, nullable: false, editable: true, defaultValue: null, alias: Direction, type: esriFieldTypeDouble )
• state ( modelName: State, nullable: false, editable: true, defaultValue: null, alias: State, type: esriFieldTypeInteger )
• label ( modelName: Label, nullable: true, editable: true, defaultValue: null, length: 31, alias: Substation #, type: esriFieldTypeString )
• labelx ( modelName: LabelX, nullable: false, editable: true, defaultValue: null, alias: LabelX, type: esriFieldTypeDouble )
• labely ( modelName: LabelY, nullable: false, editable: true, defaultValue: null, alias: LabelY, type: esriFieldTypeDouble )
• labeldirection ( modelName: LabelDirection, nullable: false, editable: true, defaultValue: null, alias: LabelDirection, type: esriFieldTypeDouble )
• planid ( modelName: planid, nullable: true, editable: true, defaultValue: null, length: 15, alias: PlanId, type: esriFieldTypeString )
• username ( modelName: username, nullable: true, editable: true, defaultValue: null, length: 11, alias: UserName, type: esriFieldTypeString )
• status ( modelName: Status, nullable: false, editable: true, defaultValue: null, alias: Status, type: esriFieldTypeInteger )
• operationalareaid ( modelName: OperationalAreaId, nullable: false, editable: true, defaultValue: null, alias: OperationalAreaId, type: esriFieldTypeInteger )
• operationstatus ( modelName: OperationStatus, nullable: false, editable: true, defaultValue: null, alias: OperationStatus, type: esriFieldTypeInteger )
• workid ( modelName: WorkId, nullable: false, editable: true, defaultValue: null, alias: WorkId, type: esriFieldTypeInteger )
• statistic ( modelName: Statistic, nullable: false, editable: true, defaultValue: null, alias: Statistic, type: esriFieldTypeInteger )
• batchid ( modelName: BatchId, nullable: false, editable: true, defaultValue: null, alias: BatchId, type: esriFieldTypeInteger )
• phase ( modelName: Phase, nullable: false, editable: true, defaultValue: 0, alias: Phase, type: esriFieldTypeInteger , Coded Values: [0: Undefined] , [1: X] , [2: Y] , ...13 more... )
• calcconnectionyear ( modelName: CalcConnectionYear, nullable: false, editable: true, defaultValue: null, alias: Connection year for calculation, type: esriFieldTypeInteger )
• region ( modelName: Region, nullable: false, editable: true, defaultValue: null, alias: Area, type: esriFieldTypeInteger )
• owner ( modelName: Owner, nullable: false, editable: true, defaultValue: 0, alias: Owner, type: esriFieldTypeInteger , Coded Values: [0: Undefined] , [1: ABB] , [2: S&C Electric] , ...6 more... )
• dso ( modelName: DSO, nullable: false, editable: true, defaultValue: 0, alias: DSO, type: esriFieldTypeInteger , Coded Values: [0: Undefined] )
• extid ( modelName: ExtId, nullable: false, editable: true, defaultValue: null, alias: UC Prikey, type: esriFieldTypeInteger )
• extareaid ( modelName: ExtAreaId, nullable: false, editable: true, defaultValue: null, alias: ExtAreaId, type: esriFieldTypeInteger )
• offsetbottom ( modelName: OffsetBottom, nullable: false, editable: true, defaultValue: null, alias: Lower, type: esriFieldTypeInteger )
• offsetleft ( modelName: OffsetLeft, nullable: false, editable: true, defaultValue: null, alias: Left, type: esriFieldTypeInteger )
• offsettop ( modelName: OffsetTop, nullable: false, editable: true, defaultValue: null, alias: Upper, type: esriFieldTypeInteger )
• offsetright ( modelName: OffsetRight, nullable: false, editable: true, defaultValue: null, alias: Right, type: esriFieldTypeInteger )
• name ( modelName: Name, nullable: true, editable: true, defaultValue: null, length: 50, alias: Name, type: esriFieldTypeString )
• address ( modelName: Address, nullable: true, editable: true, defaultValue: null, length: 103, alias: Address, type: esriFieldTypeString )
• earthinggroup ( modelName: EarthingGroup, nullable: false, editable: true, defaultValue: null, alias: Grounding group, type: esriFieldTypeInteger )
• eqearthingmeas ( modelName: EqEarthingMeas, nullable: true, editable: true, defaultValue: null, length: 31, alias: Protection, type: esriFieldTypeString )
• opearthingmeas ( modelName: OpEarthingMeas, nullable: true, editable: true, defaultValue: null, length: 31, alias: Operational, type: esriFieldTypeString )
• comearthingmeas ( modelName: ComEarthingMeas, nullable: true, editable: true, defaultValue: null, length: 31, alias: Combined, type: esriFieldTypeString )
• sitetype ( modelName: SiteType, nullable: false, editable: true, defaultValue: null, alias: Site type, type: esriFieldTypeInteger )
• sitearea ( modelName: SiteArea, nullable: false, editable: true, defaultValue: null, alias: Site area, type: esriFieldTypeDouble )
• fat_287 ( modelName: Fat_287, nullable: true, editable: true, defaultValue: null, alias: Min_Fault_Current, type: esriFieldTypeInteger )
• fat_288 ( modelName: Fat_288, nullable: true, editable: true, defaultValue: null, alias: Number_of_Breakers, type: esriFieldTypeInteger )
• fat_54 ( modelName: Fat_54, nullable: true, editable: true, defaultValue: 0, alias: Substat_Name, type: esriFieldTypeInteger , Coded Values: [0: Undefined] , [1: 00] , [2: 1] , ...32 more... )
• fat_292 ( modelName: Fat_292, nullable: true, editable: true, defaultValue: null, alias: Transformer_Size, type: esriFieldTypeInteger )
• fat_294 ( modelName: Fat_294, nullable: true, editable: true, defaultValue: null, length: 250, alias: URL, type: esriFieldTypeString )
• fat_289 ( modelName: Fat_289, nullable: true, editable: true, defaultValue: null, alias: Voltage, type: esriFieldTypeDouble )
• moddate ( modelName: moddate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: ModDate, type: esriFieldTypeDate )
• connectiondate ( modelName: connectiondate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Connection date, type: esriFieldTypeDate )

Templates:

• Name: Substations
  Description:
  Prototype:
  squareid: 0
  labeldirection: 0
  eqearthingmeas: null
  workid: 0
  sitearea: 0
  moddate: null
  extareaid: 0
  id: 0
  state: 0
  comearthingmeas: null
  fat_54: 0
  phase: 0
  offsetbottom: 0
  statistic: 0
  connectiondate: null
  offsetleft: 0
  fatherid: 0
  name: null
  planid: null
  extid: 0
  region: 0
  status: 0
  offsettop: 0
  calcconnectionyear: 0
  dso: 0
  sitetype: 0
  operationstatus: 0
  labelx: 0
  labely: 0
  operationalareaid: 0
  fat_287: null
  fat_288: null
  fat_289: null
  direction: 0
  owner: 0
  address: null
  label: null
  batchid: 0
  opearthingmeas: null
  editprocessed: null
  classid: 10
  fat_292: null
  fat_294: null
  x: 0
  y: 0
  z: 0
  earthinggroup: 0
  offsetright: 0
  username: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_at
• Creator Field: created_by
• Edit Date Field: lastmodified_at
• Editor Field: lastmodified_by

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata