Name: Fairgrounds Fleet Table

Display Field: fleet_name

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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 )
• fleet_id ( type: esriFieldTypeInteger, alias: Fleet ID, editable: true, nullable: true, defaultValue: null, modelName: fleet_id )
• fleet_name ( type: esriFieldTypeString, alias: Fleet Name, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: fleet_name )
• 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 )
• rating ( type: esriFieldTypeDouble, alias: Rating, editable: true, nullable: true, defaultValue: null, modelName: rating )
• original_purchase_date ( type: esriFieldTypeDate, alias: Original Purchase Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: original_purchase_date )
• original_purchase_price ( type: esriFieldTypeDouble, alias: Original Purchase Price, editable: true, nullable: true, defaultValue: null, modelName: original_purchase_price )
• fleet_class ( type: esriFieldTypeString, alias: Fleet Class, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: fleet_class )
• condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: condition )
• description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: description )
• year ( type: esriFieldTypeInteger, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: year )
• make ( type: esriFieldTypeString, alias: Make, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: make )
• model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: model )
• vehicle_type ( type: esriFieldTypeString, alias: Vehicle Type, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: vehicle_type )
• license_plate ( type: esriFieldTypeString, alias: License Plate, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: license_plate )
• vin ( type: esriFieldTypeString, alias: VIN, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: vin )
• body_style ( type: esriFieldTypeString, alias: Body Style, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: body_style )
• color ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: color )
• fuel ( type: esriFieldTypeString, alias: Fuel Type, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: fuel )
• fuel_card_number ( type: esriFieldTypeDouble, alias: Fuel Card Number, editable: true, nullable: true, defaultValue: null, modelName: fuel_card_number )
• department ( type: esriFieldTypeString, alias: Department, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: department )
• status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: status )
• insurance ( type: esriFieldTypeString, alias: Insurance, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: insurance )
• yearly_inspection_needed ( type: esriFieldTypeString, alias: Yearly Inspection Needed, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: yearly_inspection_needed )
• yearly_emissions_needed ( type: esriFieldTypeString, alias: Yearly Emissions Needed, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: yearly_emissions_needed )
• oil_filter ( type: esriFieldTypeInteger, alias: Oil Filter, editable: true, nullable: true, defaultValue: null, modelName: oil_filter )
• hydralic_filter ( type: esriFieldTypeInteger, alias: Hydralic Filter, editable: true, nullable: true, defaultValue: null, modelName: hydralic_filter )
• primary_air_filter ( type: esriFieldTypeInteger, alias: Primary Air Filter, editable: true, nullable: true, defaultValue: null, modelName: primary_air_filter )
• secondary_air_filter ( type: esriFieldTypeInteger, alias: Secondary Air Filter, editable: true, nullable: true, defaultValue: null, modelName: secondary_air_filter )
• fuel_filter ( type: esriFieldTypeInteger, alias: Fuel Filter, editable: true, nullable: true, defaultValue: null, modelName: fuel_filter )
• part_cost ( type: esriFieldTypeString, alias: Part Cost, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: part_cost )
• po_cost ( type: esriFieldTypeString, alias: PO Cost, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: po_cost )
• total_cost ( type: esriFieldTypeString, alias: Total Cost, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: total_cost )
• 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 )

Templates:

• Name: Fairgrounds Fleet Table
  Description:
  Prototype:
  total_cost: null
  po_cost: null
  fleet_id: null
  fleet_name: null
  mileage: null
  hours: null
  rating: null
  original_purchase_date: null
  original_purchase_price: null
  fleet_class: null
  condition: null
  description: null
  year: null
  make: null
  model: null
  vehicle_type: null
  license_plate: null
  vin: null
  body_style: null
  color: null
  fuel: null
  fuel_card_number: null
  department: null
  status: null
  insurance: null
  yearly_inspection_needed: null
  yearly_emissions_needed: null
  oil_filter: null
  hydralic_filter: null
  primary_air_filter: null
  secondary_air_filter: null
  fuel_filter: null
  part_cost: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

Supported Operations:   Query   Query Attachments   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata