Name: Transformer_Assets_AGOL

Display Field: AssetDescription

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

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 )
• AssetID ( type: esriFieldTypeInteger, alias: Asset ID, editable: true, nullable: true, defaultValue: null, modelName: AssetID )
• AssetDescription ( type: esriFieldTypeString, alias: KVA, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AssetDescription , Coded Values: [1: 1] , [15: 15] , [25: 25] , ...17 more... )
• AssetCategoryID ( type: esriFieldTypeInteger, alias: Asset Category ID, editable: true, nullable: true, defaultValue: null, modelName: AssetCategoryID , Coded Values: [5: Conventional] , [6: Pad Mount] , [9: Recloser] , ...4 more... )
• Status ( type: esriFieldTypeInteger, alias: Status, editable: true, nullable: true, defaultValue: null, modelName: Status , Coded Values: [2: Warehouse] , [6: In Service] , [7: Repair] , ...3 more... )
• Manufacturer ( type: esriFieldTypeInteger, alias: Manufacturer, editable: true, nullable: true, defaultValue: null, modelName: Manufacturer , Coded Values: [7: ABB] , [8: KUHLMAN] , [9: HOWARD] , ...55 more... )
• Vendor ( type: esriFieldTypeInteger, alias: Vendor, editable: true, nullable: true, defaultValue: null, modelName: Vendor , Coded Values: [1: SUNBELT SOLOMON] , [3: Priester Supply] , [4: KBS] , ...62 more... )
• PrimaryVoltage ( type: esriFieldTypeString, alias: Primary Voltage, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PrimaryVoltage , Coded Values: [1: 7200] , [2: 7200/12400] , [3: 7200/12470] , ...2 more... )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• SecondaryVoltage ( type: esriFieldTypeString, alias: Secondary Voltage, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SecondaryVoltage , Coded Values: [1: 120/240] , [2: 120/208] , [3: 277/480] , ...7 more... )
• PurchaseOrderNumber ( type: esriFieldTypeInteger, alias: PO Number, editable: true, nullable: true, defaultValue: null, modelName: PurchaseOrderNumber )
• ReceivedBy ( type: esriFieldTypeString, alias: Received By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReceivedBy )
• DateAcquired ( type: esriFieldTypeDate, alias: Date Acquired, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateAcquired )
• DateSold ( type: esriFieldTypeDate, alias: Date Sold, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateSold )
• PurchasePrice ( type: esriFieldTypeDouble, alias: Purchase Price, editable: true, nullable: true, defaultValue: null, modelName: PurchasePrice )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Notes )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Description )
• Phase ( type: esriFieldTypeString, alias: Phase, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Phase )
• DateCreated ( type: esriFieldTypeDate, alias: Date Created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateCreated )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location )
• created_user ( type: esriFieldTypeString, alias: Created User, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Created Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edit User, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• OldAssetID ( type: esriFieldTypeInteger, alias: OldAssetID, editable: true, nullable: true, defaultValue: null, modelName: OldAssetID )

Templates:

• Name: Transformer_Assets_AGOL
  Description:
  Prototype:
  last_edited_date: null
  OldAssetID: null
  AssetID: null
  AssetDescription: null
  AssetCategoryID: null
  Status: null
  Manufacturer: null
  Vendor: null
  PrimaryVoltage: null
  SerialNumber: null
  SecondaryVoltage: null
  PurchaseOrderNumber: null
  ReceivedBy: null
  DateAcquired: null
  DateSold: null
  PurchasePrice: null
  Notes: null
  Description: null
  Phase: null
  DateCreated: null
  Location: null
  created_user: null
  created_date: null
  last_edited_user: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata