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

110.48 MB
844,435 rows
124 columns

CREATE TABLE table_1 (
  "lotid" BIGINT,
  "n__inspectionrequestid" BIGINT  -- InspectionRequestId,
  "n__lotno" BIGINT  -- LotNo,
  "n__privateind" BIGINT  -- PrivateInd,
  "n__areaid" BIGINT  -- AreaId,
  "n__lotstatusid" BIGINT  -- LotStatusId,
  "n__lotstatusdate" VARCHAR  -- LotStatusDate,
  "n__lotstatusreason" DOUBLE  -- LotStatusReason,
  "n__operid" BIGINT  -- OperId,
  "n__lotentrydate" VARCHAR  -- LotEntryDate,
  "n__billingdate" VARCHAR  -- BillingDate,
  "n__lotbllingtotal" DOUBLE  -- LotBllingTotal,
  "n__overriteind" DOUBLE  -- OverriteInd,
  "n__perimeter_ind" DOUBLE  -- Perimeter Ind,
  "n__fivedayletterno" DOUBLE  -- FiveDayLetterNo,
  "n__notes" VARCHAR  -- Notes,
  "n__psid" DOUBLE  -- PSId,
  "n__dupccu" VARCHAR  -- DupCCU,
  "n__activityid" BIGINT  -- ActivityId,
  "n__noofaddresses" DOUBLE  -- NoOfAddresses,
  "n__refno" VARCHAR  -- RefNo,
  "n__lotnjinspectionrequestid" VARCHAR  -- LotNJInspectionRequestId,
  "n__lotdupinspectionrequestid" DOUBLE  -- LotDupInspectionRequestId,
  "n__lotissysflageddupoverridden" DOUBLE  -- LotIsSysFlagedDupOverridden,
  "n__lotissysflagednjoverridden" DOUBLE  -- LotIsSysFlagedNJOverridden,
  "n__lotprevstatusidbfrdupornj" VARCHAR  -- LotPrevStatusIdBfrDupOrNJ,
  "n__legalnotes" VARCHAR  -- LegalNotes,
  "n__fieldnotes" VARCHAR  -- FieldNotes,
  "n__supp_ind" VARCHAR  -- Supp Ind,
  "n__old_lot_id" VARCHAR  -- Old Lot Id,
  "n__old_status_dd" VARCHAR  -- Old Status Dd,
  "n__old_status_rea_dd" VARCHAR  -- Old Status Rea Dd,
  "n__lotconversion_notes" VARCHAR  -- LotConversion Notes,
  "n__ownerlotlcd" VARCHAR  -- OwnerLotLCD,
  "n__logno" VARCHAR  -- Logno,
  "n__indexno" VARCHAR  -- Indexno,
  "n__refferedtodohmhdate" VARCHAR  -- RefferedToDOHMHDate,
  "n__structure" BIGINT  -- Structure,
  "n__activitydetailid" BIGINT  -- ActivityDetailId,
  "n__titleid" DOUBLE  -- TitleId,
  "n__hours" DOUBLE  -- Hours,
  "n__operatorid_detail" DOUBLE  -- OperatorId Detail,
  "n__detailentrydate" VARCHAR  -- DetailEntryDate,
  "n__dumpsiteid" DOUBLE  -- DumpSiteId,
  "n__vehicleno" VARCHAR  -- VehicleNo,
  "n__act_date" VARCHAR  -- Act Date,
  "n__activityentrydate" VARCHAR  -- ActivityEntryDate,
  "n__abandonedcars" DOUBLE  -- AbandonedCars,
  "n__activitystatusid" BIGINT  -- ActivityStatusID,
  "n__enddate" VARCHAR  -- EndDate,
  "n__activitybllingtotal" DOUBLE  -- ActivityBllingTotal,
  "n__activitystatusdate" VARCHAR  -- ActivityStatusDate,
  "n__total_hrs" DOUBLE  -- Total Hrs,
  "n__total_tonnage" DOUBLE  -- Total Tonnage,
  "n__total_loads" DOUBLE  -- Total Loads,
  "n__s_tires" BIGINT  -- S Tires,
  "n__l_tires" BIGINT  -- L Tires,
  "n__civilian_hrs" BIGINT  -- Civilian Hrs,
  "n__fel_tires" BIGINT  -- Fel Tires,
  "n__uniform_hrs" BIGINT  -- Uniform Hrs,
  "n__old_main_lot_id" VARCHAR  -- Old Main Lot Id,
  "n__startdate" VARCHAR  -- StartDate,
  "n__act_old_lot_id" VARCHAR  -- Act Old Lot Id,
  "n__lotcleaningtotal" DOUBLE  -- LotCleaningTotal,
  "n__salestax" DOUBLE  -- SalesTax,
  "n__isbillgenerated" BIGINT  -- IsBillGenerated,
  "n__prefix" DOUBLE  -- Prefix,
  "n__house1" VARCHAR  -- House1,
  "n__house2" VARCHAR  -- House2,
  "n__streetaddress" VARCHAR  -- StreetAddress,
  "n__requestdate" TIMESTAMP  -- RequestDate,
  "n__lastname" VARCHAR  -- LastName,
  "n__firstname" VARCHAR  -- FirstName,
  "n__boroid" BIGINT  -- BoroId,
  "n__districtid" BIGINT  -- DistrictId,
  "n__note" VARCHAR  -- Note,
  "n__ccuyear" BIGINT  -- CCUYear,
  "n__ccuno" BIGINT  -- CCUNo,
  "n__userid" DOUBLE  -- UserId,
  "n__requestentrydate" VARCHAR  -- RequestEntryDate,
  "n__refid" DOUBLE  -- RefId,
  "n__requestsourceid" BIGINT  -- RequestSourceId,
  "n__scanno" VARCHAR  -- ScanNo,
  "n__isdeleted" BIGINT  -- IsDeleted,
  "n__assignedtoinspector" VARCHAR  -- AssignedToInspector,
  "n__crossstreetone" VARCHAR  -- CrossStreetOne,
  "n__crossstreettwo" VARCHAR  -- CrossStreettwo,
  "n__channel" BIGINT  -- Channel,
  "n__program" DOUBLE  -- Program,
  "n__area" DOUBLE  -- Area,
  "n__crmno" VARCHAR  -- CRMNo,
  "n__phone" VARCHAR  -- Phone,
  "n__coordinatex" DOUBLE  -- CoordinateX,
  "n__coordinatey" DOUBLE  -- CoordinateY,
  "n__segmentid" DOUBLE  -- SegmentId,
  "n__bin" DOUBLE  -- Bin,
  "n__block" BIGINT  -- Block,
  "n__requeststatusid" BIGINT  -- RequestStatusID,
  "n__requeststatusreason" DOUBLE  -- RequestStatusReason,
  "n__requeststatusdate" VARCHAR  -- RequestStatusDate
);