View In:   ArcGIS Online Map Viewer

Name: Heavy Vehicles

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: bf11e13ec97443e09f9eb4d79b552590

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -1.77913E7
YMin: -4.16454E7
XMax: 5.6837687313577235E7
YMax: 4.889713884369397E7
Spatial Reference: 102658  (2236)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

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

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssetID ( type: esriFieldTypeString, alias: Last 8 of VIN, editable: false, nullable: true, length: 8, defaultValue: null, modelName: AssetID )
• VIN ( type: esriFieldTypeString, alias: VIN, editable: true, nullable: true, length: 17, defaultValue: null, modelName: VIN )
• CVNum ( type: esriFieldTypeString, alias: CV #, editable: true, nullable: false, length: 5, defaultValue: 0000, modelName: CVNum )
• Category ( type: esriFieldTypeString, alias: General Category, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Category , Coded Values: [Ambulance: Ambulance] , [Bus: Bus] , [Dump Truck: Dump Truck] , ...19 more... )
• ModelYear ( type: esriFieldTypeSmallInteger, alias: Model Year, editable: true, nullable: true, defaultValue: null, modelName: ModelYear )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location )
• AgencyDesc ( type: esriFieldTypeString, alias: Agency, editable: true, nullable: true, length: 5, defaultValue: BCC, modelName: AgencyDesc , Coded Values: [ARC: ARC] , [BCC: BCC] , [COA: COA] , ...3 more... )
• DeptCode ( type: esriFieldTypeString, alias: Dept Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DeptCode , Coded Values: [0004: 0004-County Administration] , [0005: 0005-Construction Administration] , [0007: 0007-Risk Management] , ...80 more... )
• VehClass ( type: esriFieldTypeString, alias: VehClass, editable: true, nullable: true, length: 5, defaultValue: null, modelName: VehClass , Coded Values: [Light: Light] , [Heavy: Heavy] )
• Shop ( type: esriFieldTypeString, alias: Shop, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Shop , Coded Values: [Light: Light Shop] , [Heavy: Heavy Shop] )
• MeterDesc ( type: esriFieldTypeString, alias: Meter Description, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MeterDesc , Coded Values: [Miles: Miles] , [Hours: Hours] , [Both: Both] , ...1 more... )
• FuelTypePrimary ( type: esriFieldTypeString, alias: FuelTypePrimary, editable: true, nullable: true, length: 71, defaultValue: null, modelName: FuelTypePrimary , Coded Values: [GASOLINE: Gasoline] , [DIESEL: Diesel] , [NONE: None] )
• FuelTankGal ( type: esriFieldTypeSmallInteger, alias: FuelTankGal, editable: true, nullable: true, defaultValue: null, modelName: FuelTankGal )
• CntyAssetID ( type: esriFieldTypeString, alias: County AssetID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CntyAssetID )
• LicNum ( type: esriFieldTypeString, alias: Lic Num (Tag #), editable: true, nullable: true, length: 20, defaultValue: null, modelName: LicNum )
• PurchaseDate ( type: esriFieldTypeDate, alias: Purchase Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PurchaseDate )
• PurchasePrice ( type: esriFieldTypeDouble, alias: Purchase Price, editable: true, nullable: true, defaultValue: null, modelName: PurchasePrice )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyDate )
• PowertrainWarrantyDate ( type: esriFieldTypeDate, alias: Powertrain Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PowertrainWarrantyDate )
• OtherWarrantyDate ( type: esriFieldTypeDate, alias: Other Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OtherWarrantyDate )
• EstLife ( type: esriFieldTypeSmallInteger, alias: Estimated Life, editable: true, nullable: true, defaultValue: null, modelName: EstLife )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 225, defaultValue: null, modelName: Notes )
• Make ( type: esriFieldTypeString, alias: Make*, editable: false, nullable: true, length: 125, defaultValue: null, modelName: Make , Coded Values: [AMERICAN SIGNAL COMPANY: AMERICAN SIGNAL COMPANY] , [ANVIL: ANVIL] , [BIG TEX TRAILER MANUFACTURING BIG TEX TRAILER MANUFACTURING: BIG TEX TRAILER MANUFACTURING] , ...58 more... )
• Model ( type: esriFieldTypeString, alias: Model*, editable: false, nullable: true, length: 150, defaultValue: null, modelName: Model )
• DriveTrain ( type: esriFieldTypeString, alias: DriveTrain*, editable: false, nullable: true, length: 30, defaultValue: null, modelName: DriveTrain )
• Series ( type: esriFieldTypeString, alias: Series*, editable: false, nullable: true, length: 250, defaultValue: null, modelName: Series )
• VehicleType ( type: esriFieldTypeString, alias: VehicleType*, editable: false, nullable: true, length: 50, defaultValue: null, modelName: VehicleType )
• DriveType ( type: esriFieldTypeString, alias: DriveType*, editable: false, nullable: true, length: 50, defaultValue: null, modelName: DriveType )
• BodyClass ( type: esriFieldTypeString, alias: BodyClass*, editable: false, nullable: true, length: 80, defaultValue: null, modelName: BodyClass )
• CabType ( type: esriFieldTypeString, alias: CabType*, editable: false, nullable: true, length: 80, defaultValue: null, modelName: CabType )
• BrakeSystem ( type: esriFieldTypeString, alias: BrakeSystem*, editable: false, nullable: true, length: 50, defaultValue: null, modelName: BrakeSystem )
• EngineMake ( type: esriFieldTypeString, alias: EngineMake*, editable: false, nullable: true, length: 100, defaultValue: null, modelName: EngineMake )
• EngineModel ( type: esriFieldTypeString, alias: EngineModel*, editable: false, nullable: true, length: 250, defaultValue: null, modelName: EngineModel )
• EngineConfig ( type: esriFieldTypeString, alias: EngineConfig*, editable: false, nullable: true, length: 100, defaultValue: null, modelName: EngineConfig )
• EngineHP ( type: esriFieldTypeInteger, alias: EngineHP*, editable: false, nullable: true, defaultValue: null, modelName: EngineHP )
• EnginePower ( type: esriFieldTypeDouble, alias: EnginePower*, editable: false, nullable: true, defaultValue: null, modelName: EnginePower )
• OtherEngineInfo ( type: esriFieldTypeString, alias: OtherEngineInfo*, editable: false, nullable: true, length: 100, defaultValue: null, modelName: OtherEngineInfo )
• FuelInjectionType ( type: esriFieldTypeString, alias: FuelInjectionType*, editable: false, nullable: true, length: 50, defaultValue: null, modelName: FuelInjectionType )
• TransmissionStyle ( type: esriFieldTypeString, alias: TransmissionStyle*, editable: false, nullable: true, length: 50, defaultValue: null, modelName: TransmissionStyle )
• GrossWeight ( type: esriFieldTypeString, alias: GrossWeight*, editable: false, nullable: true, length: 50, defaultValue: null, modelName: GrossWeight )
• NumCylinders ( type: esriFieldTypeSmallInteger, alias: NumCylinders*, editable: false, nullable: true, defaultValue: null, modelName: NumCylinders )
• Trim ( type: esriFieldTypeString, alias: Trim*, editable: false, nullable: true, length: 50, defaultValue: null, modelName: Trim )
• NumAxels ( type: esriFieldTypeSmallInteger, alias: NumAxels*, editable: false, nullable: true, defaultValue: null, modelName: NumAxels )
• WheelBasesShort ( type: esriFieldTypeString, alias: WheelBasesShort*, editable: false, nullable: true, length: 50, defaultValue: null, modelName: WheelBasesShort )
• WheelSizeFront ( type: esriFieldTypeString, alias: WheelSizeFront*, editable: false, nullable: true, length: 20, defaultValue: null, modelName: WheelSizeFront )
• WheelSizeRear ( type: esriFieldTypeString, alias: WheelSizeRear*, editable: false, nullable: true, length: 20, defaultValue: null, modelName: WheelSizeRear )
• AxleConfiguration ( type: esriFieldTypeString, alias: AxleConfiguration*, editable: false, nullable: true, length: 100, defaultValue: null, modelName: AxleConfiguration )
• TrailerLength ( type: esriFieldTypeDouble, alias: TrailerLength*, editable: false, nullable: true, defaultValue: null, modelName: TrailerLength )
• TrailerType ( type: esriFieldTypeString, alias: TrailerType*, editable: false, nullable: true, length: 50, defaultValue: null, modelName: TrailerType )
• TrailerBodyType ( type: esriFieldTypeString, alias: TrailerBodyType*, editable: false, nullable: true, length: 50, defaultValue: null, modelName: TrailerBodyType )
• OtherTrailerInfo ( type: esriFieldTypeString, alias: OtherTrailerInfo*, editable: false, nullable: true, length: 250, defaultValue: null, modelName: OtherTrailerInfo )
• ValveTrainDesign ( type: esriFieldTypeString, alias: ValveTrainDesign*, editable: false, nullable: true, length: 50, defaultValue: null, modelName: ValveTrainDesign )
• Displacement_CI ( type: esriFieldTypeString, alias: Displacement_CI*, editable: false, nullable: true, length: 250, defaultValue: null, modelName: Displacement_CI )
• Displacement_CC ( type: esriFieldTypeString, alias: Displacement_CC*, editable: false, nullable: true, length: 250, defaultValue: null, modelName: Displacement_CC )
• Displacement_L ( type: esriFieldTypeString, alias: Displacement_L*, editable: false, nullable: true, length: 250, defaultValue: null, modelName: Displacement_L )
• VIN_Note ( type: esriFieldTypeString, alias: VIN_Note*, editable: false, nullable: true, length: 256, defaultValue: null, modelName: VIN_Note )
• LastServDate ( type: esriFieldTypeDate, alias: Last Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastServDate )
• LastServMtrRead ( type: esriFieldTypeDouble, alias: Last Service Meter Read, editable: true, nullable: true, defaultValue: null, modelName: LastServMtrRead_km )
• LastFuelDate ( type: esriFieldTypeDate, alias: Last Fuel Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastFuelDate )
• LastFuelMtrRead ( type: esriFieldTypeDouble, alias: Last Fuel Meter Read, editable: true, nullable: true, defaultValue: null, modelName: LastFuelMtrRead_km )
• LastPMServDate ( type: esriFieldTypeDate, alias: Last PM Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastPMServDate )
• LastPMMtrRead ( type: esriFieldTypeDouble, alias: Last PM Service Meter Read, editable: true, nullable: true, defaultValue: null, modelName: LastPMMtrRead_km )
• EstNextPMDate ( type: esriFieldTypeDate, alias: Next PM Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EstNextPMDate )
• EstNextPMMtrRead ( type: esriFieldTypeDouble, alias: Next PM Meter Read, editable: true, nullable: true, defaultValue: null, modelName: EstNextPMMtrRead_km )
• LastCNGServDate ( type: esriFieldTypeDate, alias: Last CNG Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastCNGServDate )
• LastCNGMtrRead ( type: esriFieldTypeDouble, alias: Last CNG Meter Read, editable: true, nullable: true, defaultValue: null, modelName: LastCNGMtrRead_km )
• EstNextCNGServDate ( type: esriFieldTypeDate, alias: Next CNG Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EstNextCNGServDate )
• EstNextCNGMtrRead ( type: esriFieldTypeDouble, alias: Next CNG Mtr Read, editable: true, nullable: true, defaultValue: null, modelName: EstNextCNGMtrRead_km )
• VehPrepWODate ( type: esriFieldTypeDate, alias: Vehicle Prep WO Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: VehPrepWODate )
• AVL_ESN ( type: esriFieldTypeString, alias: AVL_ESN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AVL_ESN , Coded Values: [Yes: Yes] , [No: No] )
• CNGID ( type: esriFieldTypeString, alias: CNGID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CNGID )
• ConditionDate ( type: esriFieldTypeDate, alias: ConditionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ConditionDate )
• ConditionScore ( type: esriFieldTypeInteger, alias: ConditionScore, editable: true, nullable: true, defaultValue: null, modelName: ConditionScore )
• ImageFile ( type: esriFieldTypeString, alias: ImageFile, editable: true, nullable: true, length: 225, defaultValue: null, modelName: ImageFile )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Address )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LegacyID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• RequiresPM ( type: esriFieldTypeString, alias: Requires PM?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: RequiresPM , Coded Values: [Yes: Yes] , [No: No] )
• PMDueFlag ( type: esriFieldTypeString, alias: PM Due Flag, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PMDueFlag , Coded Values: [Yes: Yes] , [No: No] )
• VehCNG ( type: esriFieldTypeString, alias: Vehicle CNG?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: VehCNG , Coded Values: [Yes: Yes] , [No: No] )
• CNGDueFlag ( type: esriFieldTypeString, alias: CNGDueFlag, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CNGDueFlag , Coded Values: [Yes: Yes] , [No: No] )
• VehRetired ( type: esriFieldTypeString, alias: VehRetired, editable: true, nullable: true, length: 3, defaultValue: No, modelName: VehRetired , Coded Values: [Yes: Yes] , [No: No] )
• VehRetiredDate ( type: esriFieldTypeDate, alias: VehRetiredDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: VehRetiredDate )
• LastServNote ( type: esriFieldTypeString, alias: Last Service Note, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LastServNote )
• NewVehicleIntake ( type: esriFieldTypeString, alias: New Vehicle Intake?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NewVehicleIntake , Coded Values: [Yes: Yes] , [No: No] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• CondScore_InspScore ( type: esriFieldTypeInteger, alias: VR Cond Score, editable: true, nullable: true, defaultValue: null, modelName: CondScore_InspScore )
• AgeScore ( type: esriFieldTypeInteger, alias: VR Age Score, editable: true, nullable: true, defaultValue: null, modelName: AgeScore )
• RepairCostTotalScore ( type: esriFieldTypeInteger, alias: VR Total Repair Cost Score, editable: true, nullable: true, defaultValue: null, modelName: RepairCostTotalScore )
• MileageScore ( type: esriFieldTypeInteger, alias: VR Mileage Score, editable: true, nullable: true, defaultValue: null, modelName: MileageScore )
• VehicleUseScore ( type: esriFieldTypeInteger, alias: VR Vehicle Use Score, editable: true, nullable: true, defaultValue: null, modelName: VehicleUseScore )
• DepreciationScore ( type: esriFieldTypeInteger, alias: VR Depreciation Score, editable: true, nullable: true, defaultValue: null, modelName: DepreciationScore )
• TotalScore ( type: esriFieldTypeInteger, alias: VR Total Score, editable: true, nullable: true, defaultValue: null, modelName: TotalScore )
• ReplacementProgram ( type: esriFieldTypeString, alias: Replacement Program, editable: true, nullable: true, length: 3, defaultValue: Yes, modelName: ReplacementProgram , Coded Values: [Yes: Yes] , [No: No] )
• ReplacementYear ( type: esriFieldTypeSmallInteger, alias: Replacement Program Year, editable: true, nullable: true, defaultValue: null, modelName: ReplacementYear , Coded Values: [0: 0] , [2015: 2015] , [2016: 2016] , ...14 more... )
• ScheduledPMDate ( type: esriFieldTypeDate, alias: ScheduledPMDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ScheduledPMDate )
• Has_AVL ( type: esriFieldTypeString, alias: Has_AVL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Has_AVL , Coded Values: [Yes: Yes] , [No: No] )
• AVL_MtrRead ( type: esriFieldTypeDouble, alias: AVL_MtrRead, editable: true, nullable: true, defaultValue: null, modelName: AVL_MtrRead )
• AVL_MtrRead_Date ( type: esriFieldTypeDate, alias: AVL_MtrRead_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AVL_MtrRead_Date )

Templates:

• Name: Heavy Vehicles
  Description:
  Prototype:
  VIN: null
  CNGDueFlag: null
  AVL_MtrRead: null
  Has_AVL: null
  CVNum: 0000
  Category: null
  ModelYear: null
  Location: null
  AgencyDesc: BCC
  DeptCode: null
  VehClass: null
  Shop: null
  MeterDesc: null
  FuelTypePrimary: null
  FuelTankGal: null
  CntyAssetID: null
  LicNum: null
  PurchaseDate: null
  PurchasePrice: null
  WarrantyDate: null
  PowertrainWarrantyDate: null
  OtherWarrantyDate: null
  EstLife: null
  Notes: null
  ScheduledPMDate: null
  ReplacementYear: null
  ReplacementProgram: Yes
  TotalScore: null
  DepreciationScore: null
  VehicleUseScore: null
  MileageScore: null
  RepairCostTotalScore: null
  AgeScore: null
  CondScore_InspScore: null
  AVL_MtrRead_Date: null
  NewVehicleIntake: null
  LastServNote: null
  VehRetiredDate: null
  VehRetired: No
  VehCNG: null
  PMDueFlag: null
  RequiresPM: null
  LastPMServDate: null
  LastPMMtrRead: null
  EstNextPMDate: null
  EstNextPMMtrRead: null
  LegacyID: null
  Address: null
  ImageFile: null
  ConditionScore: null
  ConditionDate: null
  CNGID: null
  AVL_ESN: null
  VehPrepWODate: null
  EstNextCNGMtrRead: null
  EstNextCNGServDate: null
  LastCNGMtrRead: null
  LastCNGServDate: null
  LastServDate: null
  LastServMtrRead: null
  LastFuelDate: null
  LastFuelMtrRead: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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