Derelict Vehicle Dispositions - Vehicles

data.cityofnewyork.us | Last Updated 13 Jun 2019

"Data for removing derelict vehicle operations from city streets. Gives disposition (complaints) of derelict vehicles reported to DSNY from 311. For information on how to report an abandoned vehicle, go to: http://www1.nyc.gov/nyc-resources/service/989/abandoned-vehicle. Related datasets: - https://data.cityofnewyork.us/City-Government/Derelict-Vehicle-Dispositions-Tow/vr8p-8shw - https://data.cityofnewyork.us/City-Government/Derelict-Vehicles-Dispositions-Complaints/pq5i-thsu

Tags: derelict, vehicle, dsny, sanitation, complaints, status, disposition

This dataset has the following 22 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
ISNisnnumberInitial sequence number Initial sequence numbers (ISN) refers to the unique32-bit sequence number assigned to each new connection on a Transmission Control Protocol (TCP)-based data communication. It helps with the allocation of a sequence number that does not conflict with other data bytes transmitted over a TCP connection.
DVV_DISTRICT_CDdvv_district_cdtextDistrict Code Two to three-letter district code for Borough is followed by two-digit community board number for the Borough. BKE, BKN, BKW = Brooklyn East, Brooklyn North, Brooklyn West; BXE, BXW = Bronx East, Bronx West; MNE, MNW - Manhattan East , Manhattan West; QN, QS, QW = Queens North, Queens, South, Queens West; SI - Staten Island.
DVV_TAG_LOC1dvv_tag_loc1textTag Location Line 1
DVV_TAG_LOC2dvv_tag_loc2textTag Location Line 2
DVV_YEARdvv_yearnumberVehicle Year
DVV_MAKEdvv_maketextVehicle Make
DVV_TYPEdvv_typetextVehicle Type "2D 2 door vehicle 4D 4 door vehicle BS bus BX box truck HE heavy truck MC motorcycle NV non-vehicle (boat house trailer, large container 10 - 40 yards, small container 1 to 2 yards) PT pickup or panel truck SV step van SW station wagon TL trailer TR truck VN van "
DVV_COLORdvv_colortextVehicle Color
DVV_TAG_REMARKSdvv_tag_remarkstextTag Remarks
DVV_TAG_NOdvv_tag_nonumberTag Vehicle Identification Number A seven digit number which matches the tag attached to the vehicle
DVV_TAG_DATEdvv_tag_datenumberTag Date (Format: YYYYMMDD)
DVV_TAG_TIMEdvv_tag_timenumberTag Time (Format: HHMM)
DVV_TIMESTMPdvv_timestmpnumberTimestamp (Format: YYYYMMDDHHMM)
DVV_CHECKED_DATEdvv_checked_datenumberDate vehicle was checked (Format: YYYYMMDD)
DVV_TIMESTMP_UPDdvv_timestmp_updnumberUpdate Timestamp (Format: YYYYMMDDHHMMSS)
DVV_FINAL_DISP_DATEdvv_final_disp_datenumberFinal Disposition Date (Format: YYYYMMDD)
DVV_FINAL_DISP_CDdvv_final_disp_cdtextFinal Disposition Code "AAA pending HLD on hold LP license plate NOL not on location OC owner claim RTC release to contractor RTI release to insurance RTO release to owner RTP release to Police RTS release to Sanitation VOI void "
DVV_SE_STATUSdvv_se_statustextFinal Status Code "A open B pending C closed N no owner S stolen V summons blanks none "
DVV_CITYdvv_citytextLOR City LOR = Last Owner of Record
DVV_STATEdvv_statetextLOR State LOR = Last Owner of Record
DVV_STOLEN_INDICdvv_stolen_indictextStolen Indicator (Y or N)
DVV_DOTdvv_dotnumberDate of Vehicle's theft (Format: YYYYMMDD)