Name: Transformer_Assets_AGOL

Display Field: AssetDescription

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

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: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

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

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata