Lot Cleaning Dispositions (No Longer Maintained) by US Government | Demographics and Population Studies

About this Dataset

Lot Cleaning Dispositions (No Longer Maintained)

This dataset is based on a legacy system that is no longer maintained by the NYC Department of Sanitation (DSNY). It contains information about the cleaning requests associated with different vacant lots. Some current data related to vacant lots can be found in the 311 Service Requests dataset at (https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9), and filtering the "Complaint Type" field for "Vacant Lot".
Organization: City of New York
Last updated: 2020-11-10T17:04:51.623359

Tables

Table 1

@usgov.city_of_new_york_lot_cleaning_dispositions.table_1

105.36 MB
844435 rows
124 columns


CREATE TABLE table_1 (
  "lotid" BIGINT,
  "n__inspectionrequestid" BIGINT,
  "n__lotno" BIGINT,
  "n__privateind" BIGINT,
  "n__areaid" BIGINT,
  "n__lotstatusid" BIGINT,
  "n__lotstatusdate" VARCHAR,
  "n__lotstatusreason" DOUBLE,
  "n__operid" BIGINT,
  "n__lotentrydate" VARCHAR,
  "n__billingdate" VARCHAR,
  "n__lotbllingtotal" DOUBLE,
  "n__overriteind" DOUBLE,
  "n__perimeter_ind" DOUBLE,
  "n__fivedayletterno" DOUBLE,
  "n__notes" VARCHAR,
  "n__psid" DOUBLE,
  "n__dupccu" VARCHAR,
  "n__activityid" BIGINT,
  "n__noofaddresses" DOUBLE,
  "n__refno" VARCHAR,
  "n__lotnjinspectionrequestid" VARCHAR,
  "n__lotdupinspectionrequestid" DOUBLE,
  "n__lotissysflageddupoverridden" DOUBLE,
  "n__lotissysflagednjoverridden" DOUBLE,
  "n__lotprevstatusidbfrdupornj" VARCHAR,
  "n__legalnotes" VARCHAR,
  "n__fieldnotes" VARCHAR,
  "n__supp_ind" VARCHAR,
  "n__old_lot_id" VARCHAR,
  "n__old_status_dd" VARCHAR,
  "n__old_status_rea_dd" VARCHAR,
  "n__lotconversion_notes" VARCHAR,
  "n__ownerlotlcd" VARCHAR,
  "n__logno" VARCHAR,
  "n__indexno" VARCHAR,
  "n__refferedtodohmhdate" VARCHAR,
  "n__structure" BIGINT,
  "n__activitydetailid" BIGINT,
  "n__titleid" DOUBLE,
  "n__hours" DOUBLE,
  "n__operatorid_detail" DOUBLE,
  "n__detailentrydate" VARCHAR,
  "n__dumpsiteid" DOUBLE,
  "n__vehicleno" VARCHAR,
  "n__act_date" VARCHAR,
  "n__activityentrydate" VARCHAR,
  "n__abandonedcars" DOUBLE,
  "n__activitystatusid" BIGINT,
  "n__enddate" VARCHAR,
  "n__activitybllingtotal" DOUBLE,
  "n__activitystatusdate" VARCHAR,
  "n__total_hrs" DOUBLE,
  "n__total_tonnage" DOUBLE,
  "n__total_loads" DOUBLE,
  "n__s_tires" BIGINT,
  "n__l_tires" BIGINT,
  "n__civilian_hrs" BIGINT,
  "n__fel_tires" BIGINT,
  "n__uniform_hrs" BIGINT,
  "n__old_main_lot_id" VARCHAR,
  "n__startdate" VARCHAR,
  "n__act_old_lot_id" VARCHAR,
  "n__lotcleaningtotal" DOUBLE,
  "n__salestax" DOUBLE,
  "n__isbillgenerated" BIGINT,
  "n__prefix" DOUBLE,
  "n__house1" VARCHAR,
  "n__house2" VARCHAR,
  "n__streetaddress" VARCHAR,
  "n__requestdate" TIMESTAMP,
  "n__lastname" VARCHAR,
  "n__firstname" VARCHAR,
  "n__boroid" BIGINT,
  "n__districtid" BIGINT,
  "n__note" VARCHAR,
  "n__ccuyear" BIGINT,
  "n__ccuno" BIGINT,
  "n__userid" DOUBLE,
  "n__requestentrydate" VARCHAR,
  "n__refid" DOUBLE,
  "n__requestsourceid" BIGINT,
  "n__scanno" VARCHAR,
  "n__isdeleted" BIGINT,
  "n__assignedtoinspector" VARCHAR,
  "n__crossstreetone" VARCHAR,
  "n__crossstreettwo" VARCHAR,
  "n__channel" BIGINT,
  "n__program" DOUBLE,
  "n__area" DOUBLE,
  "n__crmno" VARCHAR,
  "n__phone" VARCHAR,
  "n__coordinatex" DOUBLE,
  "n__coordinatey" DOUBLE,
  "n__segmentid" DOUBLE,
  "n__bin" DOUBLE,
  "n__block" BIGINT,
  "n__requeststatusid" BIGINT,
  "n__requeststatusreason" DOUBLE,
  "n__requeststatusdate" VARCHAR
);