Name: FleetEquipment

Display Field: ASSETID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 4db373c9dff64965b529c616a48b21be

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
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 )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, length: 12 )
• UNITNO ( type: esriFieldTypeString, alias: UNITNO, length: 12 )
• MAKE ( type: esriFieldTypeString, alias: MAKE, length: 30 )
• MODEL ( type: esriFieldTypeString, alias: MODEL, length: 30 )
• MODELYEAR ( type: esriFieldTypeString, alias: MODELYEAR, length: 4 )
• VIN ( type: esriFieldTypeString, alias: VIN, length: 30 )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, length: 50 )
• EQUIPMENTTYPE ( type: esriFieldTypeString, alias: EQUIPMENTTYPE, length: 30 , Coded Values: [GENERATOR: Generator] , [PASSENGER VEHICLE: Passenger Vehicle] , [LIGHT DUTY TRUCK/VAN: Light Duty Truck/Van] , ...11 more... )
• FUELTYPE ( type: esriFieldTypeString, alias: FUELTYPE, length: 30 , Coded Values: [GASOLINE: Gasoline] , [DIESEL: Diesel] , [PROPANE: Propane] , ...3 more... )
• METERTYPE ( type: esriFieldTypeString, alias: METERTYPE, length: 30 , Coded Values: [KILOMETERS: Kilometers] , [HOURS: Hours] , [N/A: Not Applicable] )
• FLEETSTATUS ( type: esriFieldTypeString, alias: FLEETSTATUS, length: 30 )
• NSCCLASSIFICATION ( type: esriFieldTypeString, alias: NSCCLASSIFICATION, length: 30 , Coded Values: [NSC: NSC] , [NON NSC: Non NSC] , [NSC CVIP: NSC CVIP] )
• LINKEDUNITNO ( type: esriFieldTypeString, alias: LINKEDUNITNO, length: 12 )
• AXELCOUNT ( type: esriFieldTypeSmallInteger, alias: AXELCOUNT )
• LICENSEPLATE ( type: esriFieldTypeString, alias: LICENSEPLATE, length: 12 )
• GVW ( type: esriFieldTypeInteger, alias: GVW )
• LICENSEDGVW ( type: esriFieldTypeInteger, alias: LICENSEDGVW )
• ACQUIREDATE ( type: esriFieldTypeDate, alias: ACQUIREDATE, length: 8 )
• ASSETSTATUS ( type: esriFieldTypeString, alias: ASSETSTATUS, length: 50 , Coded Values: [IN SERVICE: In Service] , [OUT OF SERVICE: Out of Service] , [DISPOSED: Disposed] , ...3 more... )
• ACQUIRECOST ( type: esriFieldTypeInteger, alias: ACQUIRECOST )
• DEPARTMENT ( type: esriFieldTypeString, alias: DEPARTMENT, length: 50 , Coded Values: [CITY ADMINISTRATION: City Administration] , [CIVIC OPERATIONS: Civic Operations] , [COMMUNITY & PROTECTIVE SERVICES: Community & Protective Services] , ...3 more... )
• DIVISION ( type: esriFieldTypeString, alias: DIVISION, length: 50 , Coded Values: [ADMINISTRATION: Administration] , [CAPITAL PROJECTS: Capital Projects] , [COMMUNITY SERVICES: Community Services] , ...19 more... )
• SUBDIVISION ( type: esriFieldTypeString, alias: SUBDIVISION, length: 60 , Coded Values: [ARENAS: Arenas] , [BUILDING INSPECTION: Building Inspection] , [CARPENTRY: Carpentry] , ...41 more... )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 50 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 50 )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: WARRANTYDATE, length: 8 )
• WARRANTYODOMETERHRS ( type: esriFieldTypeInteger, alias: WARRANTYODOMETERHRS )
• WARRANTYNOTES ( type: esriFieldTypeString, alias: WARRANTYNOTES, length: 255 )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, length: 10 , Coded Values: [1: Good] , [2: Satisfactory] , [3: Fair] , ...4 more... )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: CONDITIONDATE, length: 8 )
• CONDITIONCOMMENT ( type: esriFieldTypeString, alias: CONDITIONCOMMENT, length: 255 )
• SECURELINK ( type: esriFieldTypeString, alias: SECURELINK, length: 255 )
• DOCUMENTATIONLINK ( type: esriFieldTypeString, alias: DOCUMENTATIONLINK, length: 255 )
• ODOMETER ( type: esriFieldTypeInteger, alias: ODOMETER )
• HOURSMETER ( type: esriFieldTypeInteger, alias: HOURSMETER )
• AGE ( type: esriFieldTypeSmallInteger, alias: AGE )
• USEFULLIFE ( type: esriFieldTypeSmallInteger, alias: USEFULLIFE )
• REMAININGLIFE ( type: esriFieldTypeSmallInteger, alias: REMAININGLIFE )
• DISPOSALDATE ( type: esriFieldTypeDate, alias: DISPOSALDATE, length: 8 )
• DISPOSALVALUE ( type: esriFieldTypeInteger, alias: DISPOSALVALUE )
• CRC ( type: esriFieldTypeInteger, alias: CRC )
• DEPRECIATIONLIFE ( type: esriFieldTypeSmallInteger, alias: DEPRECIATIONLIFE , Coded Values: [2: 2] , [3: 3] , [4: 4] , ...7 more... )
• REPLACEMENTYEAR ( type: esriFieldTypeSmallInteger, alias: REPLACEMENTYEAR )
• CURRENTREPLACEMENTCOST ( type: esriFieldTypeInteger, alias: CURRENTREPLACEMENTCOST )
• SEASONFLAG ( type: esriFieldTypeString, alias: SEASONFLAG, length: 15 , Coded Values: [SUMMER: Summer] , [WINTER: Winter] , [UNKNOWN: Unknown] , ...1 more... )
• RATEGROUP ( type: esriFieldTypeString, alias: RateGroup, length: 120 )
• MONTHLYRATE ( type: esriFieldTypeInteger, alias: MonthlyRate )
• BUSINESSUNIT ( type: esriFieldTypeString, alias: Business Unit, length: 15 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata