Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

DOB NOW: Build – Limited Alteration Applications

xxbr-ypigHousing & Development26 columns
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
View on NYC Open Data↗

Quality

A91.2 / 100

From a 500-row sample across 26 columns.

completeness90/ 25% weight
consistency73/ 20% weight
accuracy95/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • DOB NOW: Certificate of Occupancy0.39
    joins onlongitudezip_codebbl+2
  • DOB Safety Violations0.39
    joins onlongitudecouncil_districtbbl+2
  • Open Market Order (OMO) Charges0.38
    joins onlongitudecouncil_districtbbl+4
  • Housing Litigations0.38
    joins onlongitudecouncil_districtbbl+3

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

job_numberfiling_type_namefiling_numberfiling_status_namefiling_datepermit_expiration_datelocation_binlocation_house_nolocation_street_namelocation_borough_nameproposed_work_summarylatitude
S-00100798New Job FilingEWNExpired2018-11-16T00:00:00.0002018-11-20T00:00:00.0005122289931WEST FINGERBOARD ROADStaten IslandDue to a gas shutdown by the utility company will test gas to appliances (Furnace, HWH & residential stove) & make any gas repairs as necessary. Will register/replace Furnace & HWH.

Columns

26 queryable · 26 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
job_numbertextThe job number(s) assigned when the applicant begins the application0%Q00947505Q00862536Q01030633
filing_type_namecategoricalThe filing type of the application0%New Job FilingPAASubsequent Filingof 3
filing_numbertextThe filing sequence indicator0%I1P1EWN
filing_status_namecategoricalThe overall status of the filing0%Signed offApproved

Query this from your own app

GET /api/datasets/xxbr-ypig
GET /api/datasets/xxbr-ypig/quality
GET /api/datasets/xxbr-ypig/related
GET /api/columns?dataset=xxbr-ypig
DOB NOW: Build – Approved Permits
0.37
joins onlongitudezip_codecouncil_district+5
  • DOB Certificate Of Occupancy0.36
    joins onlongitudecouncil_districtbbl+5
  • Housing Maintenance Code Complaints and Problems0.36
    joins onlongitudecouncil_districtbbl+4
  • Buildings Selected for the Alternative Enforcement Program (AEP)0.36
    joins onlongitudecouncil_districtbbl+4
    • 40.601171
    M01002460New Job FilingI1Signed off2024-02-14T00:00:00.0001899-12-30T00:00:00.0001082859510EAST 20 STREETManhattan8th Floor apt 7F at bathroom; replacing shower body, replacing lavatory sink and faucet, floor mounted toilet, to existing waste and water piping; at kitchen: replacing kitchen sink and faucet to existing rough; installing dishwasher to existing sink trap and water supply40.733824
    M-00090195New Job FilingEWNExpired2018-10-19T00:00:00.0002018-10-23T00:00:00.0001005563104FORSYTH STREETManhattanFiling in conjunction w/ EWN # 17380 & EWN M-00088941. Due to leak & gas shutdown replace approx 100 feet of 2 inches & 20 feet of 1 1/4 inches gas pipe in cellar for existing boiler and water heater (102707288).40.718546
    B00893987New Job FilingI1Signed off2023-06-21T00:00:00.0002024-06-21T00:00:00.0003024849815CARROLL STREETBrooklynNAT GRID HAS SHUT & LOCKED GAS SERVICE TO A 6 FAMILY BUILDING DUE TO LEAKS ON PIPING ON OUTLET OF METER.1 EXISTING GAS METER IN CELLAR FOR BOILER & WTR HTR IN CELLAR. REPLACED LEAKING PIPING TO EXISTING BOILER (NYC BOILER REGISTRATION #150687) & WTR HEATER. APPROX 15FT 1.5 inches, 6FT 1 inches & 6FT 3/4 inches BLK PIPE REPLACED. NAT GRID TESTED & RESTORED GAS UNDER EWN PROCESS.40.671967
    B00961223New Job FilingI1Permitted2024-01-02T00:00:00.0002025-01-02T00:00:00.0003052186435JEFFERSON AVENUEBrooklynDirectly replace the existing gas boiler(Weil Mclain boiler No 154124) with a new gas boiler (CROWN) after the existing gas roughing and control vale, there is no change of egress or occupancy, no change of c/o, there is no fire stopping is compromised.40.68441
    M01114440PAAP2Approved2024-12-13T00:00:00.000—1013318322WEST 22 STREETManhattanIN APT. 3/1ST FL OF DUPLEX, REPL. APPROX. 25FT OF 1/2 inches COPPER PIPE FOR KITCHEN H/C WTR LINES & APPROX. 20FT OF 2 inches NO HUB PIPE FOR WASTE/VENT LINES FOR EXISTG. ISLAND SINK. REPL. (1) SINK, (1) GARBAGE DISPOSAL, (1) D/W & (1) GAS RGE.ON EXISTG. APPL.VLV. MSTR GAS MTR EXISTG IN CEL.GAS AUTHO. REQD. LWR LVL BATHRM, REPL. APPROX. 15FT OF 2 inches NO HUB PIPE FOR WASTE/VENT LINES & APPROX. 50FT OF 1/2 inches COPPER PIPE FOR H/C WTR LINES. REPL.(1)LAV, (1)SHOWER, (1)WTR CLOSET. CAP/REMOVE (1)LAV IN LWR LVL BATHRM.40.744989
    S01104187New Job FilingI1Permitted2024-08-29T00:00:00.0002024-12-31T00:00:00.0005134905642SEAVIEW AVENUEStaten IslandDUE TO GAS SHUT OFF, PERFORM GAS INTEGRITY TEST ON ALL EXISTING GAS PIPE ON FLOORS OSP,CEL-001 FOR UTILITY CO TO RESTORE SERVICE. EXISTING GAS EQUIPMENT FILED DOB# 500590684; AT CELLAR LEVEL: (1) FURNACE, (1) DRYER, (1) HOT WATER HEATER: STOVE ON FIRST FLOOR USED FOR COOKING.40.581225
    B08001506New Job FilingI1Permitted2022-09-09T00:00:00.0002023-09-09T00:00:00.000315270311985 STREETBrooklynON THE 1ST FL, REPLACE ON EXISTING ROUGHING (1) STOVE & FLEX (METER IS EXISTING) GAS VALVE NOT TO BE TOUCHED. FIRESTOPS WILL NOT BE COMPROMISED.40.625432
    X01290561New Job FilingI1Pre-Filing—2025-10-23T00:00:00.00020185373150DECATUR AVENUEBronxIn Apt ___ on the ___ floor. Direct replacement of one (1) gas range on existing roughing. Existing appliance valve to remain. No piping to be replaced. Firestopping will not be compromised. Meter location: CELLAR. Riser location: CELLAR - __ FL (Apt __). End use: Residential cooking only.40.872583
    M01274157New Job FilingI1Signed off2025-08-19T00:00:00.0002026-08-19T00:00:00.000100102514WALL STREETManhattanNEW INSTALLATION OF (2) PENDENT TYPE SPRINKLER HEADS & INSTALLING OF 20 FEET OF 1 feetPIPE ON THE 2ND FLOOR. NO CHANGE, EGRESS OR OCCUPANCY. THE SYSTEM WILL BE DOWN FOR (2) DAYS, (7) HOURS PER DAY.40.707552

    Showing 12 of 26 columns. All of them are listed below.

    Permitted
    of 17
    permit_numbertextThe LAA permit number32%B00095156-I1-LAB00103763-I1-LAB00093683-I1-LA
    filing_datedatetimeThe date the application was submitted4%2021-02-10T00:00:00.0002021-01-06T00:00:00.0002020-01-13T00:00:00.000
    permit_issued_datedatetimeThe date of permit issuance32%2021-02-10T00:00:00.0002019-12-06T00:00:00.0002025-12-16T00:00:00.000
    permit_expiration_datedatetimeThe date of permit expiration19%2026-12-31T00:00:00.0002026-10-23T00:00:00.0002026-05-01T00:00:00.000
    laasign_off_datedatetimeThe date of LAA signoff51%2020-07-08T00:00:00.0002021-01-11T00:00:00.0002019-03-25T00:00:00.000
    work_type_namecategoricalThe type of work included in the application10%Gas Plumbing WorkWater Plumbing WorkFire Suppression Workof 4
    location_bintextBuilding Identification Number assigned by Department of City Planning0%400001910197311044862
    location_house_notextThe house number for the building owner's address.0%2003001
    location_street_nametextThe street name for the building owner's address.0%BROADWAYPARK AVENUE5 AVENUE
    location_borough_namecategoricalA number to indicate the NYC borough where the proposed work will take place0%ManhattanBrooklynQueensof 5
    proposed_work_summarytextFreeform text description of work to be performed0%ON THE 1ST FL, REPLACE O…ON THE 2ND FL, REPLACE O…On the 1ST floor. Direct…
    building_type_namecategoricalThe building occupancy type9%Other2 Family1 Familyof 4
    inspection_type_nametextThe outcome of the inspection52%Pass-Finalof 1
    inspection_datedatetimeThe date of inspection51%2024-01-16T00:00:00.0002024-11-15T00:00:00.0002026-03-31T00:00:00.000
    latitudefloatThe Building's latitude coordinates0%40.75928940.74439640.737857
    longitudefloatThe Building's longitude coordinates0%-73.713493-73.956041-73.982874
    zip_codetextThe Building's Zipcode0%100231002410003
    community_boardtextThe Building's Community Board0%108107106
    council_districttextThe Building's Council District0%040603
    bblintegerThe BBL (Borough, Block, and Lot) is a combination of three numeric codes -- a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits) - designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes0%100972000140848900011000940001
    census_tracttextThe Census Tract (Census 2020) is a small, relatively permanent statistical subdivisions of a county uniquely numbered in each county with a numeric code. Note: as part of the geocoding process, leading and trailing zeros are dropped.0%157159134
    ntatextThe Neighborhood Tabulation Area (Census 2020) are small area boundaries, created by the Department of City Planning (DCP) to aggregate population projections in a small area. Each NTA approximates a minimum population of 15,000. While NTAs were initially created to support PlaNYC, the thirty-year (2000-2030) sustainability plan for NYC, NTAs are now also being used to present data from the Decennial Census and American Community Survey. NTA boundaries and their associated names do not definitiv0%Upper West Side (Central…Upper East Side-Carnegie…Upper West Side-Lincoln …