Tables:

Table: Vehicles/Equipment (310)

Name: Vehicles/Equipment

Display Field: AssetID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 33a035a927874c5fa106d27cecc2c436

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


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: 255, defaultValue: null, modelName: AssetID )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LegacyID )
• Category ( type: esriFieldTypeString, alias: Category, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Category )
• Subcategory ( type: esriFieldTypeString, alias: Subcategory, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Subcategory )
• UnitNumber ( type: esriFieldTypeString, alias: UnitNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UnitNumber )
• LegacyUnitNumber ( type: esriFieldTypeString, alias: LegacyUnitNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LegacyUnitNumber )
• Year ( type: esriFieldTypeInteger, 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 )
• ModelDescription ( type: esriFieldTypeString, alias: ModelDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ModelDescription )
• ModelNumber ( type: esriFieldTypeString, alias: ModelNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ModelNumber )
• VIN_Serial ( type: esriFieldTypeString, alias: VIN_Serial, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VIN_Serial )
• Plate ( type: esriFieldTypeInteger, alias: Plate, editable: true, nullable: true, defaultValue: null, modelName: Plate )
• FuelType ( type: esriFieldTypeString, alias: FuelType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FuelType )
• Assigned ( type: esriFieldTypeString, alias: Assigned, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Assigned )
• Comment ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comment )
• Building ( type: esriFieldTypeString, alias: Building, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Building )
• Rate_Type ( type: esriFieldTypeString, alias: Rate Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Rate_Type )
• Unit_Cost ( type: esriFieldTypeString, alias: Unit Cost, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Unit_Cost )
• Warranty_Date ( type: esriFieldTypeString, alias: Warranty Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty_Date )
• Original_Order ( type: esriFieldTypeInteger, alias: Original_Order, editable: true, nullable: true, defaultValue: null, modelName: Original_Order )
• Condition ( type: esriFieldTypeString, alias: Conditon Rating, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Condition , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• CondDate ( type: esriFieldTypeDate, alias: CondDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CondDate )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Active: Active Asset] , [Planned: Planned Asset] , [Abandoned: Abandoned Asset] , ...2 more... )
• DOP ( type: esriFieldTypeDate, alias: Date of Purchase, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DOP )
• FEMA_Code ( type: esriFieldTypeString, alias: FEMA_Code, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FEMA_Code )
• FEMA_Rate ( type: esriFieldTypeDouble, alias: FEMA_Rate, editable: true, nullable: true, defaultValue: null, modelName: FEMA_Rate )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Owner , Coded Values: [Carmel: Carmel] , [Other Municipality: Other Municipality] , [County: County] , ...8 more... )
• MaintOwner ( type: esriFieldTypeString, alias: MaintOwner, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MaintOwner , Coded Values: [Carmel: Carmel] , [Carmel City Hall: Carmel City Hall] , [Carmel Communications Dept: Carmel Communications Dept] , ...20 more... )
• Value ( type: esriFieldTypeDouble, alias: Value, editable: true, nullable: true, defaultValue: null, modelName: Value )
• FuelCard ( type: esriFieldTypeString, alias: FuelCard, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FuelCard )
• TakeHome ( type: esriFieldTypeString, alias: TakeHome, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TakeHome )
• Mileage ( type: esriFieldTypeDouble, alias: Mileage, editable: true, nullable: true, defaultValue: null, modelName: Mileage )
• Hours ( type: esriFieldTypeDouble, alias: Hours, editable: true, nullable: true, defaultValue: null, modelName: Hours )
• ServicePeriod ( type: esriFieldTypeString, alias: ServicePeriod, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ServicePeriod )
• Mandatory ( type: esriFieldTypeString, alias: Mandatory, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Mandatory )
• EquipID ( type: esriFieldTypeString, alias: Equipment ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: EquipID )
• InCityworks ( type: esriFieldTypeString, alias: In Cityworks, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InCityworks )
• EquipDescription ( type: esriFieldTypeString, alias: Equipment Description, editable: true, nullable: true, length: 56, defaultValue: null, modelName: EquipDescription )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Location )
• eol ( type: esriFieldTypeDouble, alias: Engine Oil Life, editable: true, nullable: true, defaultValue: null, modelName: eol )
• GT_Status_Date ( type: esriFieldTypeDate, alias: GeoTab Status Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GT_Status_Date )
Templates:
• Name: Vehicles/Equipment
  Description:
  Prototype:
  eol: null
  GT_Status_Date: null
  AssetID: null
  LegacyID: null
  Category: null
  Subcategory: null
  UnitNumber: null
  LegacyUnitNumber: null
  Year: null
  Make: null
  ModelDescription: null
  ModelNumber: null
  VIN_Serial: null
  Plate: null
  FuelType: null
  Assigned: null
  Comment: null
  Building: null
  Rate_Type: null
  Unit_Cost: null
  Warranty_Date: null
  Original_Order: null
  Condition: null
  CondDate: null
  Status: null
  DOP: null
  FEMA_Code: null
  FEMA_Rate: null
  Owner: null
  MaintOwner: null
  Value: null
  FuelCard: null
  TakeHome: null
  Mileage: null
  Hours: null
  ServicePeriod: null
  Mandatory: null
  EquipID: null
  InCityworks: null
  EquipDescription: null
  Location: null
  
  Drawing Tool: esriFeatureEditToolNone