Name: FleetEquipment

Display Field: ASSETID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 6bfb677752f64a949b705b790e98607d

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
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:

Fields:

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

Templates:

• Name: FleetEquipment
  Description:
  Prototype:
  MONTHLYRATE: null
  ASSETID: null
  UNITNO: null
  MAKE: null
  MODEL: null
  MODELYEAR: null
  VIN: null
  DESCRIPTION: null
  EQUIPMENTTYPE: null
  FUELTYPE: null
  METERTYPE: null
  FLEETSTATUS: null
  NSCCLASSIFICATION: null
  LINKEDUNITNO: null
  AXELCOUNT: null
  LICENSEPLATE: null
  GVW: null
  LICENSEDGVW: null
  ACQUIREDATE: null
  ASSETSTATUS: null
  ACQUIRECOST: null
  DEPARTMENT: null
  DIVISION: null
  SUBDIVISION: null
  LOCATION: null
  ADDRESS: null
  WARRANTYDATE: null
  WARRANTYODOMETERHRS: null
  WARRANTYNOTES: null
  CONDITION: null
  CONDITIONDATE: null
  CONDITIONCOMMENT: null
  SECURELINK: null
  DOCUMENTATIONLINK: null
  ODOMETER: null
  HOURSMETER: null
  AGE: null
  USEFULLIFE: null
  REMAININGLIFE: null
  DISPOSALDATE: null
  DISPOSALVALUE: null
  CRC: null
  DEPRECIATIONLIFE: null
  REPLACEMENTYEAR: null
  CURRENTREPLACEMENTCOST: null
  SEASONFLAG: null
  RATEGROUP: null
  BUSINESSUNIT: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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