Name: PoliceVehicleMaintenance

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId2

Unique ID Field:

Name : ObjectId2

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• FVMaintID (type: esriFieldTypeInteger, alias: FVMaintID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• FVMainID (type: esriFieldTypeInteger, alias: FVMainID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• EquipmentID (type: esriFieldTypeString, alias: EquipmentID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• OfficerID (type: esriFieldTypeInteger, alias: OfficerID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• VehicleYear (type: esriFieldTypeInteger, alias: VehicleYear, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Make (type: esriFieldTypeString, alias: Make, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Model (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MakeModel (type: esriFieldTypeString, alias: MakeModel, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• VehicleType (type: esriFieldTypeString, alias: VehicleType, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Color (type: esriFieldTypeString, alias: Color, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• LicensePlateID (type: esriFieldTypeString, alias: LicensePlateID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DatePurchased (type: esriFieldTypeDate, alias: DatePurchased, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• CostToPurchas (type: esriFieldTypeString, alias: CostToPurchas, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CostAfterAddOns (type: esriFieldTypeString, alias: CostAfterAddOns, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• TotalMileage (type: esriFieldTypeInteger, alias: TotalMileage, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• DateRetired (type: esriFieldTypeDate, alias: DateRetired, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• VehicleCategory (type: esriFieldTypeString, alias: VehicleCategory, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MarkedOrUnmarked (type: esriFieldTypeString, alias: MarkedOrUnmarked, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• AssignmentType (type: esriFieldTypeString, alias: AssignmentType, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DateOfMaintenance (type: esriFieldTypeDate, alias: DateOfMaintenance, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• YearOfMaintenance (type: esriFieldTypeInteger, alias: YearOfMaintenance, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• AutoShopName (type: esriFieldTypeString, alias: AutoShopName, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• VehicleMileage (type: esriFieldTypeInteger, alias: VehicleMileage, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• MaintenanceType (type: esriFieldTypeString, alias: MaintenanceType, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ObjectId2 (type: esriFieldTypeOID, alias: ObjectId2, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• MaintenanceCost (type: esriFieldTypeDouble, alias: Maintenance Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/26/2025 10:00:45 AM

Schema Last Edit Date: 7/26/2025 10:00:42 AM

Data Last Edit Date: 7/26/2025 10:00:45 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat