Name: Fleet

Display Field: NEW_NO

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FLEETID ( type: esriFieldTypeInteger, alias: FLEET ID )
• NEW_NO ( type: esriFieldTypeString, alias: NEW #, length: 10 )
• Description ( type: esriFieldTypeString, alias: Description, length: 80 )
• Serial_NO ( type: esriFieldTypeString, alias: Serial_NO, length: 30 )
• Year ( type: esriFieldTypeInteger, alias: Purchase Year )
• Location ( type: esriFieldTypeString, alias: Location, length: 40 , Coded Values: [AlexArena: Alex Arena] , [Bylaw: Bylaw] , [DirectorPS: Director - PS] , ...15 more... )
• Object_CL ( type: esriFieldTypeDouble, alias: Object Class , Coded Values: [1: Equipment] , [2: PSS] , [3: Vehicle] )
• Supplier ( type: esriFieldTypeString, alias: Supplier, length: 40 , Coded Values: [FourWayEqu: 4-Way Equipment Rentals] , [ARWilliams: AR Williams] , [ABTraffic: Alberta Traffic Supply Ltd.] , ...74 more... )
• License ( type: esriFieldTypeString, alias: License Number, length: 30 )
• GISID ( type: esriFieldTypeString, alias: GISID, length: 25 )
• Expired ( type: esriFieldTypeString, alias: Expired, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• PurchasePrice ( type: esriFieldTypeDouble, alias: Purchase Price )
• WarrantyEndDate ( type: esriFieldTypeDate, alias: WarrantyEndDate, length: 8 )
• WarrantyEndKM ( type: esriFieldTypeDouble, alias: WarrantyEndKM )
• WarrantyEndHrs ( type: esriFieldTypeDouble, alias: WarrantyEndHrs )
• DriveTrainWarrantyEndDate ( type: esriFieldTypeDate, alias: DriveTrainWarrantyEndDate, length: 8 )
• DriveTrainWarrantyEndKM ( type: esriFieldTypeDouble, alias: DriveTrainWarrantyEndKM )
• DriveTrainWarrantyEndHrs ( type: esriFieldTypeDouble, alias: DriveTrainWarrantyEndHrs )
• CurrentKMs ( type: esriFieldTypeDouble, alias: CurrentKMs )
• CurrentHRs ( type: esriFieldTypeDouble, alias: CurrentHRs )
• GL1Name ( type: esriFieldTypeString, alias: GL1Name , length: 50 )
• GL1Percent ( type: esriFieldTypeDouble, alias: GL1Percent )
• GL2Name ( type: esriFieldTypeString, alias: GL2Name , length: 50 )
• GL2Percent ( type: esriFieldTypeDouble, alias: GL2Percent )
• Lifespan ( type: esriFieldTypeSmallInteger, alias: Lifespan )
• Condition ( type: esriFieldTypeSmallInteger, alias: Condition )
• ACCEvaporatorFilter ( type: esriFieldTypeString, alias: ACCEvaporatorFilter, length: 25 )
• AerialHydraulicFilterPressure ( type: esriFieldTypeString, alias: Aerial Hydraulic Filter (Pressure), length: 25 )
• AerialHydraulicFilterReturn ( type: esriFieldTypeString, alias: Aerial Hydraulic Filter (Return), length: 25 )
• AftertreatmentDieselExhaustFDUF ( type: esriFieldTypeString, alias: Aftertreatment Diesel Exhaust Fluid Dosing Unit Filter, length: 50 )
• AirCompressorFilter ( type: esriFieldTypeString, alias: Air Compressor Filter , length: 25 )
• AirFilterPrimary ( type: esriFieldTypeString, alias: Air Filter (Primary), length: 50 )
• AirFilterSecondary ( type: esriFieldTypeString, alias: Air Filter (Secondary), length: 25 )
• AuxiliaryEngineAirFilterPrimary ( type: esriFieldTypeString, alias: Auxiliary Engine Air Filter (Primary), length: 25 )
• AuxiliaryEngineAirFilterSeconda ( type: esriFieldTypeString, alias: Auxiliary Engine Air Filter (Secondary), length: 25 )
• AuxiliaryEngineFuelFilter ( type: esriFieldTypeString, alias: Auxiliary Engine Fuel Filter, length: 70 )
• AuxiliaryEngineOilFilter ( type: esriFieldTypeString, alias: Auxiliary Engine Oil Filter, length: 25 )
• AxleOilFilters ( type: esriFieldTypeString, alias: Axle Oil Filters, length: 25 )
• BlowerFilter ( type: esriFieldTypeString, alias: Blower Filter, length: 25 )
• BurnerFuelFilter ( type: esriFieldTypeString, alias: Burner Fuel Filter, length: 25 )
• CabinAirFilter ( type: esriFieldTypeString, alias: Cabin Air Filter, length: 50 )
• CabinAirFilterInsideFilter ( type: esriFieldTypeString, alias: Cabin Air Filter (Inside Filter), length: 25 )
• CabinAirFilterOutsideFilter ( type: esriFieldTypeString, alias: Cabin Air Filter (Outside Filter), length: 25 )
• CabinFreshAirFilter ( type: esriFieldTypeString, alias: Cabin Fresh Air Filter, length: 25 )
• CabinRecirculationFilter ( type: esriFieldTypeString, alias: Cabin Recirculation Filter, length: 25 )
• CoolantFilter ( type: esriFieldTypeString, alias: Coolant Filter, length: 25 )
• CrankcaseBreatherFilter ( type: esriFieldTypeString, alias: Crankcase Breather Filter, length: 25 )
• EngineOilFilter ( type: esriFieldTypeString, alias: Engine Oil Filter, length: 50 )
• FoamPro3012FoamSystemHydraulicF ( type: esriFieldTypeString, alias: Foam Pro 3012 Foam System Hydraulic Filter, length: 25 )
• FuelBreatherFilter ( type: esriFieldTypeString, alias: Fuel Breather Filter, length: 50 )
• FuelFilter ( type: esriFieldTypeString, alias: Fuel Filter, length: 50 )
• FuelFilterFinal ( type: esriFieldTypeString, alias: Fuel Filter (Final), length: 25 )
• FuelFilterPrimary ( type: esriFieldTypeString, alias: Fuel Filter (Primary), length: 25 )
• FuelFilterSecondary ( type: esriFieldTypeString, alias: Fuel Filter (Secondary), length: 25 )
• FuelPumpScreenKit ( type: esriFieldTypeString, alias: Fuel Pump Screen Kit, length: 25 )
• FuelTankBreatherFilter ( type: esriFieldTypeString, alias: Fuel Tank Breather Filter, length: 25 )
• FuelWaterSeparator ( type: esriFieldTypeString, alias: Fuel/Water Separator, length: 50 )
• HarrisonHydraulicGHF ( type: esriFieldTypeString, alias: Harrison Hydraulic Generator Hydraulic Filter, length: 25 )
• Husky3FoamSystemHydraulicFilter ( type: esriFieldTypeString, alias: Husky 3 Foam System Hydraulic Filter, length: 25 )
• HuskyFoamSystemHydraulicFilter ( type: esriFieldTypeString, alias: Husky Foam System Hydraulic Filter, length: 120 )
• HydraulicBreatherFilter ( type: esriFieldTypeString, alias: Hydraulic Breather Filter, length: 25 )
• HydraulicCaseDrainFilter ( type: esriFieldTypeString, alias: Hydraulic Case Drain Filter, length: 25 )
• HydraulicChargeFilter ( type: esriFieldTypeString, alias: Hydraulic Charge Filter, length: 50 )
• HydraulicFilter ( type: esriFieldTypeString, alias: Hydraulic Filter, length: 90 )
• HydraulicFilterAccessory ( type: esriFieldTypeString, alias: Hydraulic Filter (Accessory), length: 25 )
• HydraulicFilterBreatherSet ( type: esriFieldTypeString, alias: Hydraulic Filter & Breather Set, length: 25 )
• HydraulicFilterHydrostatic ( type: esriFieldTypeString, alias: Hydraulic Filter (Hydrostatic), length: 25 )
• HydraulicOilFilter ( type: esriFieldTypeString, alias: Hydraulic Oil Filter, length: 60 )
• HydraulicPowertrainOilFilter ( type: esriFieldTypeString, alias: Hydraulic/ Powertrain Oil Filter, length: 25 )
• HydraulicPressureFilter ( type: esriFieldTypeString, alias: Hydraulic Pressure Filter, length: 25 )
• HydraulicReserviorBreatherFilte ( type: esriFieldTypeString, alias: Hydraulic Reservior Breather Filter, length: 25 )
• HydraulicReturnFilter ( type: esriFieldTypeString, alias: Hydraulic Return Filter, length: 25 )
• HydraulicSuctionFilter ( type: esriFieldTypeString, alias: Hydraulic Suction Filter, length: 25 )
• HydraulicSystemReturnFilter ( type: esriFieldTypeString, alias: Hydraulic System Return Filter, length: 25 )
• PowerDividerFilter ( type: esriFieldTypeString, alias: Power Divider Filter, length: 25 )
• PowerSteeringFilter ( type: esriFieldTypeString, alias: Power Steering Filter, length: 50 )
• PowerSteeringFilter00 ( type: esriFieldTypeString, alias: Power Steering Filter00, length: 50 )
• PVCBreatherFilter ( type: esriFieldTypeString, alias: PVC Breather Filter, length: 25 )
• RearAxleBreather ( type: esriFieldTypeString, alias: Rear Axle Breather, length: 25 )
• SpherosFuelFilter ( type: esriFieldTypeString, alias: Spheros Fuel Filter, length: 25 )
• TransmissionBreatherFilter ( type: esriFieldTypeString, alias: Transmission Breather Filter, length: 25 )
• TransmissionFilterKit ( type: esriFieldTypeString, alias: Transmission Filter Kit, length: 25 )
• TransmissionHydraulicOilFilter ( type: esriFieldTypeString, alias: Transmission/Hydraulic Oil Filter, length: 25 )
• TransmissionOilFilter ( type: esriFieldTypeString, alias: Transmission Oil Filter, length: 25 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• AssetStatus ( type: esriFieldTypeString, alias: AssetStatus, length: 15 , Coded Values: [Active: Active] , [Retired: Retired] )
• LASTINSPHR ( type: esriFieldTypeInteger, alias: Last inspection Hrs )
• LASTINSPKM ( type: esriFieldTypeInteger, alias: Last inspection Kms )
• SERVINTHR ( type: esriFieldTypeInteger, alias: Service interval Hrs )
• SERVINTKM ( type: esriFieldTypeInteger, alias: Service interval Kms )
• UNITCOST ( type: esriFieldTypeDouble, alias: UNITCOST )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata