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

Asbestos Control Program (ACP7)

vq35-j9qmEnvironment35 columns
ACP7 form is an asbestos project notification. Any time asbestos abatement is perform on quantities greater than a minor project amount, the applicant has to file this form with DEP Asbestos Control Program (ACP). All asbestos documents are filed through the Asbestos Reporting and Tracking System (ARTS) E-file system. This system is web based and entirely paperless. All information on the ACP7 is essential to meet the requirements setforth in the asbestos rules and regulations Title15, Chapter 1 (RCNY). ACP enforcement staff utilizes this form for inspection of asbestos abatement activities.
View on NYC Open Data↗

Quality

A92.3 / 100

From a 500-row sample across 35 columns.

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

Related datasets

  • Clean Air Tracking System (CATS) Permits0.35
    joins onboroughlotbin+1
  • Forestry Tree Points0.33
  • Electronics Drop Off Locations in NYC0.31
    joins onlongitudeboroughbbl+2
  • Forestry Work Orders0.31
    joins onlongitudecensus_tractbbl+3
  • Food Scrap Drop-Off Locations in NYC0.31
    joins on

Geography

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

Open on the map →

Sample rows

trustart_dateend_datestatus_descriptionstreet_activitypremise_nostreet_nameboroughzip_codefacility_akafacility_typebin
TRU0976MN252025-05-28T00:00:00.0002026-04-28T00:00:00.000SubmittedNo16West 16th StreetManhattan10011The Chelsea LaneResidence1078651
TRU1483MN19

Columns

35 queryable · 35 profiled

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

FieldTypeDescriptionNullValues
trutextUnique project number issued when the ACP7 is submitted0%TRU2441BK24TRU1125BK26TRU0975BK25
start_datedatetimeProject start date0%2026-03-02T00:00:00.0002026-07-20T00:00:00.0002026-08-24T00:00:00.000
end_datedatetimeProject end date; Date filed + 364 days0%2027-06-11T00:00:00.0002026-06-04T00:00:00.0002025-12-09T00:00:00.000
status_descriptioncategoricalDescription of the current status of ACP70%

Query this from your own app

GET /api/datasets/vq35-j9qm
GET /api/datasets/vq35-j9qm/quality
GET /api/datasets/vq35-j9qm/related
GET /api/columns?dataset=vq35-j9qm
longitude
borough
bbl
+2
  • Urban Park Ranger Animal Condition Response0.31
    joins onborough
  • Rodent Inspection0.30
    joins onlongitudecouncil_districtcensus_tract+10
  • Drinking Water Quality Distribution Monitoring Data0.29
    • 2019-06-22T00:00:00.000
    2020-06-08T00:00:00.000
    Closed
    No
    223-233
    West 132 Street
    Manhattan
    10027
    M484
    School
    1058776
    TRU7217MN182018-09-04T00:00:00.0002019-08-21T00:00:00.000ClosedNo272Sherman AvenueManhattan10034—Residence1064866
    TRU1674BX222022-12-21T00:00:00.0002023-12-21T00:00:00.000ClosedNo489East 169th StreetBronx10456Morris Houses Bldg#06Residence2092082
    TRU0787BK262026-04-28T00:00:00.0002027-04-22T00:00:00.000ClosedNo330Bushwick AveBrooklyn11206Borinquen Plaza Houses Bldg#14Residence3071359
    TRU5435QN182018-05-25T00:00:00.0002019-05-03T00:00:00.000ClosedNo85-05144th StreetQueens11435I.S. 217(Q) @Q217School4208124
    TRU0516BK192019-06-07T00:00:00.0002020-04-09T00:00:00.000ClosedNo1390WILLOUGHBY AVENUEBrooklyn11237IS 162 KSchool3073018
    TRU2353MN222022-09-27T00:00:00.0002023-09-19T00:00:00.000ClosedNo24East 10th StreetManhattan10003—Residence1009237
    TRU2797MN222022-11-28T00:00:00.0002023-11-14T00:00:00.000ClosedNo110BLEECKER STREETManhattan10012SILVER TOWERSResidence1083218
    TRU0946QN252025-10-22T00:00:00.0002026-10-06T00:00:00.000ClosedNo103-02101 AvenueQueens11416—Other4198392

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

    Closed
    Submitted
    Postponed
    of 3
    street_activitycategoricalA flag that indicates if the project is on the street or in a facility0%NoYesof 2
    premise_notextPremise number of the facility where the abatement project is taking place Null if street activity = Yes0%675200760
    street_nametextStreet name of the facility where the abatement project is taking place Null if street activity = Yes0%West 131st StreetBroadwayEldert Lane
    boroughcategoricalBorough of the facility where the abatement project is taking place Null if street activity = Yes0%ManhattanBrooklynBronxof 5
    zip_codetextZip code of the facility where the abatement project is taking place Null if street activity = Yes0%100271121711208
    facility_akatextOther name of the facility where the abatement project is taking place Null if street activity = Yes37%Bldg 2Bldg 1NYCHA GR2413474 Wyckoff …
    facility_typecategoricalType of the facility where the abatement project is taking place Null if street activity = Yes2%ResidenceSchoolCommercialof 5
    bintextUnique building identification number of the facility where the abatement project is taking place Null if street activity= Yes0%309588933432533343250
    blocktextBlock number of the facility where the abatement project is taking place Null if street activity= Yes0%042710193300394
    lottextLot number of the facility where the abatement project is taking place Null if street activity= Yes0%000100507501
    cross_street_ontextThe street where the abatement project is taking place Null if street activity= No100%Broadway BridgeIntersectionEast 52 Street
    cross_street_betweentextThe intersecting street at one end where the abatement project is located Null if street activity= No100%234th Street2 Avenue8 Avenue
    cross_street_andtextThe intersecting street at the other end where the abatement project is located Null if street activity= No100%9th Avenue3 AvenueLexington Avenue
    building_owner_nametextThe name of the building owner of the facility0%New York City Housing Au…NYC School Construction …Linden Plaza Preservatio…
    contractor_nametextThe name of the asbestos contractor who will conduct the abatement project0%ESG, Inc.New York Insulation, Inc…T L D Services Inc
    air_monitor_nametextThe name of the third party air monitor on the project0%Genesis Environmental Co…Environmental Code Consu…Airtek Environmental, LL…
    entire_floorcategoricalA flag that indicates if the abatement covers the entire floor or not 1-Yes, 0-No0%NoYesof 2
    floortextThe name of the floor where the abatement project is located0%RoofBasement1st
    sectiontextThe section of the floor where the abatement project is located Null if EntireFloor= Yes5%Main RoofBoiler RoomNorth Elevation
    acm_typetextThe type of the asbestos contained material0%VATPipe InsulationVAT & Mastic
    acm_amountintegerThe amount of the asbestos contained material0%1102
    acm_unitcategoricalThe unit of the asbestos contained material (Square feet of Linear feet)0%Square FeetLinear Feetof 2
    abatement_typecategoricalThe name of the abatement type0%RemovalRepairCleanupof 5
    procedure_namecategoricalThe name of the asbestos abatement procedure0%DEP VarianceExterior Vertical Surfac…Tentof 17
    latitudefloat—2%40.67267540.67055440.671675
    longitudefloat—2%-73.866436-73.863105-73.863381
    community_boardtext—2%156
    council_districttext—2%4338
    census_tracttext—2%1208224127
    bbltext—2%300394000110193300503042719001
    ntatext—2%DUMBO-Vinegar Hill-Downt…Midtown-Midtown SouthEast New York