View In:   ArcGIS Online Map Viewer

Name: PRPP Vehicles Equipment List Source

Display Field: id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;font-size:12pt"><P><SPAN>List of Vehicles and Equipment owned and maintained by the City of Omaha PRPP department.</SPAN></P></DIV>

Service Item Id: d2739f6f37a242dab83275ffdd991b4f

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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

Extent:

XMin: 2673309.579869047
YMin: 521230.6398704797
XMax: 2759865.240090728
YMax: 572114.9199914783
Spatial Reference: 102704  (26852)  LatestVCSWkid(0)

Drawing Info:

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

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: true
Supports Query With LOD Spatial Reference: true
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• type ( nullable: true, editable: true, defaultValue: null, length: 50, description: {"fieldValueType":"","value":"This identifies the general type of vehicle or equipment that is entered. The idea behind this field is to be able to easily breakout the different types of Vehicles/Equipment in any dashboards or reports that get created."}, type: esriFieldTypeString, modelName: type, isViewOverride: true, alias: TYPE , Coded Values: [Blower: Blower] , [Chainsaw: Chainsaw] , [Chipper: Chipper] , ...13 more... )
• id ( nullable: true, editable: true, defaultValue: null, length: 10, description: {"fieldValueType":"","value":"This is the unique identifier number for each vehicle and piece of equipment. (Note: since this field can be edited and human error is a possibility, the UNIQUEID field was set up as a backup to this field. If it does not mirror this field, someone changed this field for some reason)."}, type: esriFieldTypeString, modelName: ID, alias: Vehicle/Equipment ID )
• manufacturer ( nullable: true, editable: true, defaultValue: null, length: 50, description: {"fieldValueType":"","value":"Identifies the company that built the vehicle or piece of equipment."}, type: esriFieldTypeString, modelName: MANUFACTURER, isViewOverride: true, alias: Manufacturer , Coded Values: [ABI: ABI] , [Aerway: Aerway] , [Ardisam: Ardisam] , ...145 more... )
• model ( nullable: true, editable: true, defaultValue: null, length: 50, description: {"fieldValueType":"","value":"Identifies the model type of the vehicle or equipment."}, type: esriFieldTypeString, modelName: MODEL, isViewOverride: true, alias: Model )
• description ( nullable: true, editable: true, defaultValue: null, length: 60, description: {"fieldValueType":"","value":"A brief description of the vehicle or equipment. This will usually be a combination of the \"Vehicle/Equip. Year\", \"Manufacturer\" and \"Model\" fields."}, type: esriFieldTypeString, modelName: DESCRIPTION, isViewOverride: true, alias: Description )
• year ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"","value":"Year the vehicle or equipment was made."}, type: esriFieldTypeSmallInteger, modelName: YEAR, isViewOverride: true, alias: Vehicle/Equp. Year )
• datepurchased ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, description: {"fieldValueType":"","value":"Specific date the vehicle or equipment was purchased by the PRPP department."}, type: esriFieldTypeDate, modelName: datepurchased, isViewOverride: true, alias: Date Purchased )
• newused ( nullable: true, editable: true, defaultValue: null, length: 5, description: {"fieldValueType":"","value":"Identifies if the vehicle or equipment was purchased new or used."}, type: esriFieldTypeString, modelName: NEWUSED, isViewOverride: true, alias: Purchased New or Used? , Coded Values: [New: New] , [Used: Used] )
• isactive ( nullable: true, editable: true, defaultValue: Yes, length: 3, description: {"fieldValueType":"","value":"Identifies if the vehicle or equipment is still in use, or if it's been retired."}, type: esriFieldTypeString, modelName: ISACTIVE, isViewOverride: true, alias: Is Active? , Coded Values: [Yes: Yes] , [No: No] )
• location ( nullable: true, editable: true, defaultValue: null, length: 50, description: {"fieldValueType":"","value":"This is where the vehicle or equipment is stored."}, type: esriFieldTypeString, modelName: LOCATION, isViewOverride: true, alias: Location , Coded Values: [1819FARNAMST: 1819 Farnam St] , [24THANDHICKORY: 24th & Hickory] , [24THANDHICKORYCE: 24th & Hickory - Code Enf.] , ...30 more... )
• serialvin ( nullable: true, editable: true, defaultValue: null, length: 50, description: {"fieldValueType":"","value":"The Serial Number (for equipment) or Vehicle Identification Number (VIN) (for vehicles) that is unique to each vehicle or piece of equipment."}, type: esriFieldTypeString, modelName: SERIALVIN, isViewOverride: true, alias: Serial/VIN # )
• division ( nullable: true, editable: true, defaultValue: null, length: 20, description: {"fieldValueType":"","value":"This is the division within the Parks, Recreation & Public Property (PRPP) department that the vehicle or equipment belongs to."}, type: esriFieldTypeString, modelName: DIVISION, isViewOverride: true, alias: Division , Coded Values: [Code Enforcement: Code Enforcement] , [Park Maintenance: Park Maintenance] , [Recreation: Recreation] , ...3 more... )
• licenseplatenum ( nullable: true, editable: true, defaultValue: null, length: 10, description: {"fieldValueType":"","value":"License plate number of the vehicle, tractor, trailer, etc... This field will be left blank for equipment."}, type: esriFieldTypeString, modelName: LICENSEPLATENUM, isViewOverride: true, alias: License Plate # )
• mileagehours ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"","value":"The last recorded Odometer Mileage (for vehicles) or Hours (for equipment)."}, type: esriFieldTypeDouble, modelName: MILEAGEHOURS, alias: Mileage or Hours )
• mileagehoursdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, description: {"fieldValueType":"","value":"This is the date the last recorded Mileage or Hours were recorded."}, type: esriFieldTypeDate, modelName: mileagehoursdate, alias: Mileage or Hours Date )
• plowvehicle ( nullable: true, editable: true, defaultValue: null, length: 3, description: {"fieldValueType":"","value":"Identifies if the vehicle is set up to plow snow."}, type: esriFieldTypeString, modelName: PLOWVEHICLE, isViewOverride: true, alias: Plow Vehicle , Coded Values: [Yes: Yes] , [No: No] )
• lastservicedate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, description: {"fieldValueType":"","value":"This is the date the last time the vehicle or equipment had general services done (ex. oil change, fluid change, etc...)."}, type: esriFieldTypeDate, modelName: lastservicedate, alias: Last Service Date )
• lastservicedatemileagehours ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"","value":"This is the Odometer Mileage (for vehicles) or Hours (for equipment) the last time the vehicle/equipment had general services performed (ex. oil change, fluids changed, etc...)."}, type: esriFieldTypeDouble, modelName: LASTSERVICEDATEMILEAGEHOURS, alias: Last Service Date Mileage/Hours )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• uniqueid ( nullable: true, editable: true, defaultValue: null, length: 50, description: {"fieldValueType":"","value":"This is strictly a backup field of the \"id\" field. Since we have to make the \"id\" (Vehicle/Equipment ID) field editable so people can add the number, people will have the opportunity to change the equipment number by mistake. This field will allow the GIS administrator to identify if a Vehicle/Equipment number is changed."}, type: esriFieldTypeString, modelName: uniqueid, isViewOverride: true, alias: UNIQUEID )
• comments ( nullable: true, editable: true, defaultValue: null, length: 255, description: {"fieldValueType":"","value":"Any additional information that is needed to be associated with the vehicle or equipment."}, type: esriFieldTypeString, modelName: comments, isViewOverride: true, alias: COMMENTS )
• assigneddriver ( nullable: true, editable: true, defaultValue: null, length: 50, description: {"fieldValueType":"","value":"The specific person who drives the vehicle on a daily basis. If it's a pool vehicle, or if multiple people drive the vehicle throughout the week, this field will be left blank. This field will be left blank for equipment."}, type: esriFieldTypeString, modelName: assigneddriver, isViewOverride: true, alias: ASSIGNEDDRIVER , Coded Values: [Aaron Cumerford: Aaron Cumerford] , [Aaron Gdanov: Aaron Gdanov] , [Aaron R Pfeifer: Aaron R Pfeifer] , ...262 more... )
• age ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"","value":"Age of the vehicle or equipment. This field will be calculated from the \"Vehicle/Equip. Year\" field and the current date."}, type: esriFieldTypeInteger, isViewOverride: true, alias: Age )
• agescore ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"","value":"The Vehicle/Equipment age score based on the Replacement program that is set up. There will be several category breakdowns based on the whether it's a vehicle or equipment, and also the types of vehicles or equipment. The score breakdown will be stored in another location (add link here)."}, type: esriFieldTypeInteger, isViewOverride: true, alias: Age Score )
• mileagescore ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"","value":"The Vehicle/Equipment Mileage/Hours score based on the Replacement program that is set up. There will be several category breakdowns based on the whether it's a vehicle or equipment, and also the types of vehicles or equipment. The score breakdown will be stored in another location (add link here)."}, type: esriFieldTypeInteger, isViewOverride: true, alias: Mileage Score )
• repaircost ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"","value":"Cumulative cost to repair the vehicle or equipment. This cost will come from Cityworks work orders."}, type: esriFieldTypeDouble, alias: Repair Cost )
• repaircostscore ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"","value":"This field compares the \"Repair Cost\" field to the \"Purchase Price\" field and assigns a score based on the Replacement program that is set up. There will be several category breakdowns based on the whether it's a vehicle or equipment, and also the types of vehicles or equipment. The score breakdown will be stored in another location (add link here)."}, type: esriFieldTypeInteger, alias: Repair Cost Score )
• conditionscore ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"","value":"This is an overall score rating of the condition of the vehicle or equipment based on the Replacement program that is set up. This score comes from a Cityworks Inspection that takes the answers in the inspection and calculates the score. There will be several category breakdowns based on the whether it's a vehicle or equipment, and also the types of vehicles or equipment. The score breakdown will be stored in another location (add link here)."}, type: esriFieldTypeInteger, alias: Condition Score )
• conditionscoredate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, description: {"fieldValueType":"","value":"This is the date the last Condition Score Inspection was performed."}, type: esriFieldTypeDate, alias: Condition Score Date )
• totalscore ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"","value":"The total combined score of the \"Age Score\", \"Mileage Score\", \"Repair Cost Score\" and \"Condition Score\" fields. The total possible score is 100. A failing score is anything below 60."}, type: esriFieldTypeInteger, isViewOverride: true, alias: Total Score )
• purchaseprice ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"","value":"The amount of money paid to purchase the vehicle or equipment."}, type: esriFieldTypeDouble, isViewOverride: true, alias: Purchase Price )
• mileagehourstext ( nullable: true, editable: true, defaultValue: null, length: 10, description: {"fieldValueType":"","value":"This field is used to push Mileage/Hours from Cityworks work orders and inspections. Cityworks does not allow us to push Custom Field values from work orders, or Observation values from inspections to Number or Date fields. So we have to push them to a text field, and then write a script to convert that text to a numeric format."}, type: esriFieldTypeString, alias: Mileage Hours Text )
• mileshourssincelastservice ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"","value":"This will show how many miles have been driven or hours used since the last time the vehicle/equipment was used. This field will be used in Cityworks to show when the vehicle/equipment needs to be serviced next."}, type: esriFieldTypeDouble, isViewOverride: true, alias: Miles/Hours Since Last Service )
• submitto ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Submit To, type: esriFieldTypeString )
• requestedby ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Requested By, type: esriFieldTypeString )

Templates:

• Name: PRPP Vehicles Equipment List Source
  Description:
  Prototype:
  year: null
  datepurchased: null
  lastservicedate: null
  isactive: Yes
  totalscore: null
  description: null
  conditionscoredate: null
  type: null
  repaircost: null
  plowvehicle: null
  manufacturer: null
  division: null
  newused: null
  mileagehourstext: null
  model: null
  id: null
  uniqueid: null
  conditionscore: null
  assigneddriver: null
  mileagehours: null
  comments: null
  agescore: null
  lastservicedatemileagehours: null
  mileagehoursdate: null
  repaircostscore: null
  purchaseprice: null
  mileshourssincelastservice: null
  mileagescore: null
  serialvin: null
  licenseplatenum: null
  location: null
  age: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Update,Editing,Uploads

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

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Apply Edits   Update Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata