Name: FleetManagmentList

Display Field: Name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 705af854c76f4fba99fd86e51b3c7218

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 )
• Name ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Name )
• Equip_Num ( type: esriFieldTypeString, alias: Equip_Num, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Equip_Num )
• Desc_ ( type: esriFieldTypeString, alias: Desc_, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Desc_ )
• Year ( type: esriFieldTypeDouble, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: Year )
• Make ( type: esriFieldTypeString, alias: Make, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Make )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Model )
• Vin ( type: esriFieldTypeString, alias: Vin, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Vin )
• License_Pl ( type: esriFieldTypeString, alias: License_Pl, editable: true, nullable: true, length: 255, defaultValue: null, modelName: License_Pl )
• Acquisitio ( type: esriFieldTypeDouble, alias: Acquisitio, editable: true, nullable: true, defaultValue: null, modelName: Acquisitio )
• ExpectedLi ( type: esriFieldTypeDouble, alias: ExpectedLi, editable: true, nullable: true, defaultValue: null, modelName: ExpectedLi )
• Replacement_Year ( type: esriFieldTypeDouble, alias: Replacement_Year, editable: true, nullable: true, defaultValue: null, modelName: Replacement_Year )
• Budgeted_in_5_year ( type: esriFieldTypeString, alias: Budgeted_in_5_year, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Budgeted_in_5_year )
• Radio_Liscence ( type: esriFieldTypeString, alias: Radio_Liscence, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Radio_Liscence )
• HoursMeter ( type: esriFieldTypeString, alias: HoursMeter, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HoursMeter )
• Odometer ( type: esriFieldTypeString, alias: Odometer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Odometer )
• UnitCost ( type: esriFieldTypeDouble, alias: UnitCost, editable: true, nullable: true, defaultValue: null, modelName: UnitCost )
• Curr_Replac_Cost ( type: esriFieldTypeDouble, alias: Curr_Replac_Cost, editable: true, nullable: true, defaultValue: null, modelName: Replacement_Cost )
• Review_Date ( type: esriFieldTypeDouble, alias: Review_Date, editable: true, nullable: true, defaultValue: null, modelName: YearofUpdate_ReplacementCost )
• Status ( type: esriFieldTypeSmallInteger, alias: Status, editable: true, nullable: true, defaultValue: null, modelName: Status , Coded Values: [1: ACTIVE] , [2: INACTIVE] )
• NotesonCost ( type: esriFieldTypeString, alias: NotesonCost, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NotesonCost )
• PreventativeMaint_HRS_5yrAvg ( type: esriFieldTypeDouble, alias: Preventative Maintenance Labour (HRS) 5 year avg, editable: true, nullable: true, defaultValue: null, modelName: PreventativeMaint_HRS_5yrAvg )
• Condition ( type: esriFieldTypeSmallInteger, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: Condition , Coded Values: [1: 1: Very Good, only planned maintenance required] , [2: 2: Good, minor maintenance required plus planned maintenance] , [3: 3: Fair, significant maintenance required] , ...2 more... )
• Capacity ( type: esriFieldTypeSmallInteger, alias: Capacity, editable: true, nullable: true, defaultValue: null, modelName: Capacity , Coded Values: [1: 1: Under-used, is greatly oversized for its purpose and is inefficient] , [2: 2: Somewhat Under-used, has some additional capacity for its purpose] , [3: 3: Acceptable, is sized appropriately for its purpose] , ...2 more... )
• Risk ( type: esriFieldTypeSmallInteger, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk , Coded Values: [1: 1: Rare, may occur only in exceptional circumstances (>20 years)] , [2: 2: Unlikely, could occur at some time (10-20 years)] , [3: 3: Possbile, might occur at some point (3-5 years)] , ...2 more... )
• Function_ ( type: esriFieldTypeSmallInteger, alias: Function_, editable: true, nullable: true, defaultValue: null, modelName: Function_ , Coded Values: [1: 1: Very Suitable, is always used for its intended purpose] , [2: 2: Somewhat Suitable, is often used for its intended purpose] , [3: 3: Acceptable, is used occasionally] , ...2 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )
• Department ( type: esriFieldTypeString, alias: Department, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Department , Coded Values: [BLS: Bylaw Services] , [IT: Information Technology] , [PW: Public Works] , ...3 more... )
• Annual_InsuranceCost ( type: esriFieldTypeDouble, alias: Annual_InsuranceCost, editable: true, nullable: true, defaultValue: null, modelName: Annual_InsuranceCost )
• Annual_FuelCost ( type: esriFieldTypeDouble, alias: Annual_FuelCost, editable: true, nullable: true, defaultValue: null, modelName: Annual_FuelCost )
• Annual_AmortizedCost ( type: esriFieldTypeDouble, alias: Annual_AmortizedCost, editable: true, nullable: true, defaultValue: null, modelName: Annual_AmortizedCost )
• Annual_MaintenanceCost ( type: esriFieldTypeDouble, alias: Annual_MaintenanceCost, editable: true, nullable: true, defaultValue: null, modelName: Annual_MaintenanceCost )
• Service_Life ( type: esriFieldTypeInteger, alias: Service_Life, editable: true, nullable: true, defaultValue: null, modelName: Service_Life )
• Life_Remaining ( type: esriFieldTypeInteger, alias: Life_Remaining, editable: true, nullable: true, defaultValue: null, modelName: Life_Remaining )
• Updated_Useful_Life ( type: esriFieldTypeInteger, alias: Updated_Useful_Life, editable: true, nullable: true, defaultValue: null, modelName: Updated_Useful_Life )
• Projected_Renewal_Cost ( type: esriFieldTypeInteger, alias: Projected_Renewal_Cost, editable: true, nullable: true, defaultValue: null, modelName: Projected_Renewal_Cost )
• Next_Review ( type: esriFieldTypeInteger, alias: Next_Review, editable: true, nullable: true, defaultValue: null, modelName: Next_Review )

Templates:

• Name: FleetManagmentList
  Description:
  Prototype:
  Projected_Renewal_Cost: null
  Name: null
  Equip_Num: null
  Desc_: null
  Year: null
  Make: null
  Model: null
  Vin: null
  License_Pl: null
  Acquisitio: null
  ExpectedLi: null
  Replacement_Year: null
  Budgeted_in_5_year: null
  Radio_Liscence: null
  HoursMeter: null
  Odometer: null
  UnitCost: null
  Curr_Replac_Cost: null
  Review_Date: null
  Status: null
  NotesonCost: null
  PreventativeMaint_HRS_5yrAvg: null
  Condition: null
  Capacity: null
  Risk: null
  Function_: null
  Notes: null
  Department: null
  Annual_InsuranceCost: null
  Annual_FuelCost: null
  Annual_AmortizedCost: null
  Annual_MaintenanceCost: null
  Service_Life: null
  Life_Remaining: null
  Updated_Useful_Life: null
  Next_Review: null
  
  Drawing Tool: esriFeatureEditToolNone

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

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