Name: Fleet Assets

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 23722d296d0f4c79b8229a91e27e8ede

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: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• assetid ( modelName: assetid, nullable: false, editable: true, defaultValue: null, length: 50, alias: AssetID, type: esriFieldTypeString )
• equiptype ( modelName: equiptype, nullable: true, editable: true, defaultValue: null, length: 255, alias: EquipType, type: esriFieldTypeString , Coded Values: [Vehicle: Vehicle] , [Trailer: Trailer] , [Equipment: Equipment] , ...4 more... )
• make ( modelName: make, nullable: true, editable: true, defaultValue: null, length: 255, alias: Make, type: esriFieldTypeString )
• model ( modelName: model, nullable: true, editable: true, defaultValue: null, length: 255, alias: Model, type: esriFieldTypeString )
• year ( modelName: year, nullable: true, editable: true, defaultValue: null, length: 255, alias: Year, type: esriFieldTypeString )
• license ( modelName: license, nullable: true, editable: true, defaultValue: null, length: 255, alias: License, type: esriFieldTypeString )
• vin ( modelName: vin, nullable: true, editable: true, defaultValue: null, length: 255, alias: VIN, type: esriFieldTypeString )
• serialnumber ( modelName: serialnumber, nullable: true, editable: true, defaultValue: null, length: 255, alias: Serial Number, type: esriFieldTypeString )
• odometerreading ( modelName: odometerreading, nullable: true, editable: true, defaultValue: null, alias: Odometer Reading, type: esriFieldTypeInteger )
• hours ( modelName: hours, nullable: true, editable: true, defaultValue: null, alias: Hours, type: esriFieldTypeSmallInteger )
• comments ( modelName: comments, nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments, type: esriFieldTypeString )
• department ( modelName: department, nullable: true, editable: true, defaultValue: null, length: 255, alias: Department, type: esriFieldTypeString , Coded Values: [PW: Public Works] , [Parks: Parks] , [Police: Police] , ...5 more... )
• division ( modelName: division, nullable: true, editable: true, defaultValue: null, length: 255, alias: Division, type: esriFieldTypeString , Coded Values: [SWM: Surface Water Maintenance] , [SWI: Surface Water Inspection] , [WQ: Water Quality] , ...14 more... )
• location ( modelName: location, nullable: true, editable: true, defaultValue: null, length: 255, alias: Location, type: esriFieldTypeString )
• driver ( modelName: driver, nullable: true, editable: true, defaultValue: null, length: 255, alias: Driver, type: esriFieldTypeString )
• gps_tm ( modelName: gps_tm, nullable: true, editable: true, defaultValue: null, length: 255, alias: GPS Telematics, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Verify: Verify] , ...1 more... )
• gps_tmmakemodel ( modelName: gps_tmmakemodel, nullable: true, editable: true, defaultValue: null, length: 255, alias: GPS_TMMakeModel, type: esriFieldTypeString )
• gps_tmserialnum ( modelName: gps_tmserialnum, nullable: true, editable: true, defaultValue: null, length: 255, alias: GPS_TMSerialNumber, type: esriFieldTypeString )
• dateacquired ( modelName: dateacquired, nullable: true, editable: true, defaultValue: null, length: 29, alias: DateAcquired, type: esriFieldTypeDate )
• purchaseprice ( modelName: purchaseprice, nullable: true, editable: true, defaultValue: null, alias: PurchasePrice, type: esriFieldTypeDouble )
• expectedlifecycle ( modelName: expectedlifecycle, nullable: true, editable: true, defaultValue: null, length: 255, alias: ExpectedLifeCycle, type: esriFieldTypeString )
• datesold_disposed ( modelName: datesold_disposed, nullable: true, editable: true, defaultValue: null, length: 29, alias: Date Sold or Disposed, type: esriFieldTypeDate )
• status ( modelName: status, nullable: true, editable: true, defaultValue: null, length: 255, alias: Status, type: esriFieldTypeString , Coded Values: [Active: Active] , [Inactive: Inactive] , [Unknown: Unknown] , ...5 more... )
• statusdesc ( modelName: statusdesc, nullable: true, editable: true, defaultValue: null, length: 255, alias: Status Description, type: esriFieldTypeString , Coded Values: [Active: Active] , [Inactive: Inactive] , [Unknown: Unknown] , ...5 more... )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Templates:

• Name: Fleet Assets
  Description:
  Prototype:
  equiptype: null
  expectedlifecycle: null
  hours: null
  comments: null
  serialnumber: null
  year: null
  gps_tmserialnum: null
  statusdesc: null
  gps_tm: null
  purchaseprice: null
  division: null
  license: null
  driver: null
  assetid:
  gps_tmmakemodel: null
  dateacquired: null
  model: null
  vin: null
  location: null
  odometerreading: null
  department: null
  make: null
  datesold_disposed: null
  status: null
  
  Drawing Tool: esriFeatureEditToolNone

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: 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

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