Fleet Inventory

data.cincinnati-oh.gov | Last Updated 29 Jan 2020

This dataset contains all basic information on the City of Cincinnati’s fleet. This includes but is not limited to asset types, original costs, maintenance classes, current meter and fueling information, maintenance schedules, owning departments, asset status codes, and estimate replacement information. The City’s fleet and this dataset are maintained by the Fleet Services Division in the Department of Public Services. You can find more information on the Fleet Services Division here: https://www.cincinnati-oh.gov/public-services/about-public-services/fleet-services/ This dataset is updated: Daily

Tags: fleet, vehicles, assets, equipment, dps

This dataset has the following 140 columns:

Column NameAPI Column NameData TypeSample Values
ANY_FUEL_TYPEany_fuel_typetext
ASSET_TYPEasset_typetext
AUTHORIZATION_NOauthorization_notext
BUY_BACKbuy_backtext
CAPITALIZED_DATEcapitalized_datecalendar_date
CAPITAL_COST_POSTEDcapital_cost_postedtext
CLASS_CLASS_BENCHclass_class_benchtext
CLASS_CLASS_MAINTclass_class_mainttext
CLASS_CLASS_METERclass_class_metertext
CLASS_CLASS_PMclass_class_pmtext
CLASS_CLASS_RENTALclass_class_rentaltext
CLASS_CLASS_SHOP_SCHclass_class_shop_schtext
CLASS_CLASS_STDSclass_class_stdstext
COLORcolortext
COST_CENTERcost_centertext
COST_RPT_EXCL_SWITCHcost_rpt_excl_switchtext
DATE_ADDEDdate_addedcalendar_date
DELIVERY_DATEdelivery_datecalendar_date
DEPRECIATION_METHODdepreciation_methodtext
DEPREC_MONTHS_LIFEdeprec_months_lifenumber
DEPR_CUR_DECLINE_BALdepr_cur_decline_balnumber
DEPR_MTHS_REMAININGdepr_mths_remainingnumber
DEPT_DEPT_CODEdept_dept_codetext
DEPARTMENT_NAMEdepartment_nametext
DEPT_PM_NOTIFY_DEPTdept_pm_notify_depttext
DESCRIPTIONdescriptiontext
DISPOSAL_METHODdisposal_methodtext
DISPOSAL_REASONdisposal_reasontext
EQTYP_EQUIP_TYPEeqtyp_equip_typetext
EQ_EQUIP_NOeq_equip_notext
EQ_REPLACED_BY_UNITeq_replaced_by_unittext
EQ_REPLACING_UNITeq_replacing_unittext
EST_METER_AT_REPLACEest_meter_at_replacenumber
EST_REPLACE_COSTest_replace_costnumber
EST_REPLACE_MOest_replace_monumber
EST_REPLACE_YRest_replace_yrnumber
EXCP_RPT_EXCL_SWITCHexcp_rpt_excl_switchtext
FUEL_TICKETS_OKfuel_tickets_oktext
HAS_TACHOGRAPHhas_tachographtext
INV_LIST_EXCL_SWITCHinv_list_excl_switchtext
IN_SERVICE_DATEin_service_datecalendar_date
IS_ASSETis_assettext
LAST_FUEL_DATElast_fuel_datecalendar_date
LAST_METER_1_DATElast_meter_1_datecalendar_date
LAST_METER_1_READINGlast_meter_1_readingnumber
LAST_METER_2_DATElast_meter_2_datecalendar_date
LAST_METER_2_READINGlast_meter_2_readingnumber
LAST_METER_SOURCElast_meter_sourcetext
LAST_PM_METER_1last_pm_meter_1number
LAST_PM_METER_2last_pm_meter_2number
LAST_PM_SCHED_DATElast_pm_sched_datecalendar_date
LAST_PM_SLOTlast_pm_slotnumber
LAST_PM_START_DATElast_pm_start_datecalendar_date
LAST_PM_START_METER_1last_pm_start_meter_1number
LAST_PM_START_METER_2last_pm_start_meter_2number
LAST_REGULAR_INSP_DTlast_regular_insp_dtcalendar_date
LAST_RESERV_DATE_INlast_reserv_date_incalendar_date
LAST_RESERV_DATE_OUTlast_reserv_date_outcalendar_date
LAST_RESERV_METER_INlast_reserv_meter_innumber
LAST_RESERV_MTR_OUTlast_reserv_mtr_outnumber
LEASE_EXPIRATION_DTlease_expiration_dtcalendar_date
LIFE_TOTAL_METER_1life_total_meter_1number
LIFE_TOTAL_METER_2life_total_meter_2number
LOC_ASSIGN_PM_LOCloc_assign_pm_loctext
LOC_ASSIGN_PM_LOC_NAMEloc_assign_pm_loc_nametext
LOC_ASSIGN_REPR_LOCloc_assign_repr_loctext
LOC_ASSIGN_REPR_LOC_NAMEloc_assign_repr_loc_nametext
LOC_CURRENT_LOCloc_current_loctext
LOC_CURRENT_LOC_NAMEloc_current_loc_nametext
LOC_LAST_FUEL_LOCloc_last_fuel_loctext
LOC_LAST_FUEL_LOC_NAMEloc_last_fuel_loc_nametext
LOC_RESERV_LOCloc_reserv_loctext
LOC_RESERV_LOC_NAMEloc_reserv_loc_nametext
LOC_STORED_LOCloc_stored_loctext
LOC_STORED_LOC_NAMEloc_stored_loc_nametext
MANUFACTURERmanufacturertext
MAX_METER_1_VALUEmax_meter_1_valuenumber
MAX_METER_2_VALUEmax_meter_2_valuenumber
METER_1_AT_DELIVERYmeter_1_at_deliverynumber
METER_1_TYPEmeter_1_typetext
METER_2_AT_DELIVERYmeter_2_at_deliverynumber
METER_2_TYPEmeter_2_typetext
METER_POSTING_FLAGmeter_posting_flagtext
MODELmodeltext
NEXT_PM_SCHED_DATEnext_pm_sched_datecalendar_date
NEXT_PM_SLOTnext_pm_slotnumber
OFF_ROAD_PCToff_road_pctnumber
OFF_ROAD_USEoff_road_usetext
ON_TEMP_LOANon_temp_loantext
ORIGINAL_COSToriginal_costnumber
ORIG_REGIST_DATEorig_regist_datecalendar_date
OWN_LEASE_CUSTOMERown_lease_customertext
PARENT_LIFE_METER_1parent_life_meter_1number
PARKING_STALLparking_stalltext
PLANNED_RETIR_DATEplanned_retir_datecalendar_date
PM_FUEL_SINCE_LASTpm_fuel_since_lastnumber
PM_PREF_SHIFTpm_pref_shifttext
PM_PROG_TYPEpm_prog_typetext
POOLTYP_VEH_TYPEpooltyp_veh_typetext
PRI_SHOP_PRIORITYpri_shop_prioritytext
PROCST_PROC_STATUSprocst_proc_statustext
QTY_OPEN_WORK_ORDERSqty_open_work_ordersnumber
RADIO_NOradio_notext
READY_DISPOSITIONready_dispositiontext
REPL_COST_COMPUTEDrepl_cost_computednumber
RESERV_STATUSreserv_statustext
RETIRE_DATEretire_datecalendar_date
SALE_DATEsale_datecalendar_date
SALE_PRICEsale_pricenumber
SALVAGE_VALUEsalvage_valuenumber
SALVAGE_VALUE_PCTsalvage_value_pctnumber
SLA_STATUSsla_statustext
STATUS_CODESstatus_codestext
TRACK_PARENT_METERtrack_parent_metertext
USAGE_TICKETS_OKusage_tickets_oktext
USER_STATUS_1user_status_1text
USER_STATUS_2user_status_2text
USER_STATUS_3user_status_3text
WORK_ORDERS_OKwork_orders_oktext
EQ_MAIN_DATETIMEeq_main_datetimecalendar_date
YARDCK_AVAIL_REPAIRyardck_avail_repairtext
YEARyearnumber
CAB_AXLE_LENcab_axle_lennumber
CAPY_COOLING_SYSTEMcapy_cooling_systemtext
CAPY_COOLING_UNITcapy_cooling_unittext
CAPY_DIFFERENTIALcapy_differentialtext
CAPY_DIFF_UNITcapy_diff_unittext
CAPY_FUELcapy_fueltext
CAPY_FUEL_UNITcapy_fuel_unittext
CAPY_OILcapy_oiltext
CAPY_OIL_UNITcapy_oil_unittext
CAPY_TRANSFER_CASEcapy_transfer_casetext
CAPY_TRANSMISSIONcapy_transmissiontext
CAPY_TRANS_UNITcapy_trans_unittext
CAPY_TRF_CASE_UNITcapy_trf_case_unittext
QTY_AXLESqty_axlesnumber
WEIGHT_GROSSweight_grossnumber
WHEELBASEwheelbasenumber
BC_SPEC_DATETIMEbc_spec_datetimecalendar_date
EMG_CLASS_IDemg_class_idtext