cincinnati-oh-gov/fleet-procurement-ucjy-ykv4

  • assets
  • dps
  • equipment
  • fleet
  • spending
  • + 1

Fleet Procurement

Fleet Procurement

Data Description: This data set contains procurement data related to the city’s fleet of vehicles

Data Creation: Data is generated for procurement requests and purchases

Data Created By: Fleet Services Division of the Department of Public Services

Refresh Frequency: Daily

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
REQUEST_IDrequest_idrequest_idNumber
REQUEST_STATUSrequest_statusrequest_statusText
FUNDING_SOURCEfunding_sourcefunding_sourceText
REQUEST_TYPErequest_typerequest_typeText
DEPARTMENT_NAMEdepartment_namedepartment_nameText
FISCAL_YEARfiscal_yearfiscal_yearNumber
REPLACEMENT_BODY_STYLEreplacement_body_stylereplacement_body_styleText
EQUIPMENT_CLASSequipment_classequipment_classText
EQUIP_ID_TO_REPLACEequip_id_to_replaceequip_id_to_replaceText
REPLACEMENT_MAKEreplacement_makereplacement_makeText
REPLACEMENT_MODELreplacement_modelreplacement_modelText
DATE_FLEET_DOC_ENTEREDdate_fleet_doc_entereddate_fleet_doc_enteredCalendar date
FLEET_DOCUMENT_TYPEfleet_document_typefleet_document_typeText
PURCHASING_BID_DATEpurchasing_bid_datepurchasing_bid_dateCalendar date
EST_UNIT_COSTest_unit_costest_unit_costNumber
DATE_BID_CLOSEDdate_bid_closeddate_bid_closedCalendar date
DATE_PO_AWARDEDdate_po_awardeddate_po_awardedCalendar date
ACTUAL_UNIT_COSTactual_unit_costactual_unit_costNumber
PROCUREMENT_PLANprocurement_planprocurement_planText