About this Dataset

DOB NOW: Build – Limited Alteration Applications

The Limited Alteration Application (LAA) is used for plumbing work, fire suppression piping replacement and repairs, and oil burner installations that do not include construction work. Generally, with the exception of some new installations, LAAs are restricted to repair and/or replacement work for existing appliances and piping systems that do not require a Professional Engineer (PE) or a Registered Architect (RA). https://www1.nyc.gov/site/buildings/industry/limited-alteration-application.page
Organization: City of New York
Last updated: 2022-01-25T01:56:43.958439
Tags: alteration, alterations, buildings, dob, laa, limited

Tables

Table 1

@usgov.city_of_new_york_dob_now_build_limited_alteration_applications.table_1

42.1 MB
192,103 rows
26 columns

CREATE TABLE table_1 (
  "job_number" VARCHAR,
  "filing_type_name" VARCHAR,
  "filing_number" VARCHAR,
  "filing_status_name" VARCHAR,
  "permit_number" VARCHAR,
  "filing_date" TIMESTAMP,
  "permit_issued_date" TIMESTAMP,
  "permit_expiration_date" TIMESTAMP,
  "laasign_off_date" TIMESTAMP,
  "work_type_name" VARCHAR,
  "location_bin" BIGINT,
  "location_house_no" VARCHAR,
  "location_street_name" VARCHAR,
  "location_borough_name" VARCHAR,
  "proposed_work_summary" VARCHAR,
  "building_type_name" VARCHAR,
  "inspection_type_name" VARCHAR,
  "inspection_date" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "zip_code" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "bbl" DOUBLE,
  "census_tract_2020" DOUBLE  -- Census Tract (2020),
  "neighborhood_tabulation_area_nta_2020" VARCHAR  -- Neighborhood Tabulation Area (NTA) (2020)
);