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

Self-Reported Drinking Water Tank Inspection Results

gjm4-k24gHealth47 columns
This is an official DOHMH dataset. The Health Department does not endorse datasets using these data that may be created by others. The dataset contains the self-inspections of drinking water tanks that have been reported to the DOHMH through the NYC Drinking Water Tank Inspection Reporting Site [https://www.nyc.gov/site/doh/business/permits-and-licenses/drinking-water-tank-inspection-reporting.page] by a certified water tank inspector on behalf of the building owner. Submissions of 0 Drinking Water Tanks are not displayed in this dataset.
View on NYC Open Data↗

Quality

A94.4 / 100

From a 500-row sample across 47 columns.

completeness98/ 25% weight
consistency85/ 20% weight
accuracy89/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • NYC Drinking Water Tank Inspections and Audits Compliance Results0.52
    joins oncensus_tractcommunity_boardlongitude+6
  • NYC Cooling Tower System Inspection Results0.41
    joins oncensus_tractcommunity_boardlongitude+6
  • DOHMH School Cafeteria Inspections (2020-Present)0.39
    joins onlongitudebblbin+3
  • Rodent Inspection0.38
    joins oncensus_tractcommunity_boardlongitude+10

Geography

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

Open on the map →

Sample rows

binboroughziphouse_numstreet_nameblocklotreporting_yeartank_numinspection_by_firminspection_performedinspection_date
1029959MANHATTAN10023160West 73rd Street01144005620221Rosenwach Tank Co. LLCY12/12/2022
1035455MANHATTAN

Columns

47 queryable · 47 profiled

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

FieldTypeDescriptionNullValues
bintextDepartment of Buildings Building Identification Number0%108478110263181083346
boroughcategoricalBorough of Water tank location0%MANHATTANBROOKLYNBRONXof 5
ziptextZip of Water tank location0%100221001610019
house_numtextHouse number of the physical location of the drinking water tank(s)0%120010

Query this from your own app

GET /api/datasets/gjm4-k24g
GET /api/datasets/gjm4-k24g/quality
GET /api/datasets/gjm4-k24g/related
GET /api/columns?dataset=gjm4-k24g
  • NYC Condom Availability Program - HIV condom distribution locations0.37
    joins oncensus_tractcommunity_boardlongitude+6
  • Beach Water Samples0.36
  • DOHMH Indoor Environmental Complaints0.35
    joins oncensus_tractcommunity_boardlongitude+5
  • Active NYC Health Code Regulated Child Care Programs0.35
    joins oncensus_tractcommunity_boardlongitude+5
    • 10022
    437
    Madison Avenue
    01285
    0021
    2018
    2
    Rosenwach Tank Co. LLC
    Y
    12/29/2018
    1014985MANHATTAN10001108WEST 25 STREET800750220191Rosenwach Tank Co. LLCY09/05/2019
    1087119MANHATTAN100361095Sixth Avenue00994750120221Rosenwach Tank Co. LLCY09/09/2022
    1069581MANHATTAN10036120West 45th Street00997004120231Rosenwach Tank Co. LLCY03/11/2023
    1024649MANHATTAN10036200West 41st Street01012750220261American Pipe and TankY03/26/2026
    1063351MANHATTAN10032600West 161st Street02137001420191Rosenwach Tank Co. LLCY08/15/2019
    1085873MANHATTAN1003645West 44th Street01260001420212Rosenwach Tank Co. LLCY07/21/2021
    1083921MANHATTAN100291180FIFTH AVE01604000620226Atlantank, LLCY10/28/2022
    1008513MANHATTAN1000328EAST 4 STREET00531002720171ISSEKS BROS INCY08/25/2017

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

    street_name
    text
    Street name of the physical location of the drinking water tank(s)
    0%
    BroadwayPark AvenueFifth Avenue
    blocktextDOB block number of water tank location0%000160126101263
    lottextDOB lot number of water tank location0%000175017502
    reporting_yearcategoricalReporting inspection year0%202020252023of 13
    tank_numcategoricalSerial listing for multiple tanks ('first' tank = 1, etc.)0%123of 13
    inspection_by_firmtextCertifying inspection performed0%Rosenwach Tank Co. LLCISSEKS BROS INCAmerican Pipe and Tank
    inspection_performedcategoricalName of professional inspecting firm0%YNof 2
    inspection_datedateDate of inspection0%12/30/201506/27/202006/11/2020
    gi_req_internal_structurecategoricalcertifying inspection of tank internal structure0%YNof 2
    gi_result_internal_structurecategoricalCertifying fitness of tank internal structure0%NAof 2
    gi_req_external_structurecategoricalcertifying inspection of tank internal structure0%YNof 2
    gi_result_external_structurecategoricalCertifying fitness of tank external structure0%NAof 2
    gi_req_overflow_pipescategoricalcertifying inspection of connected pipes0%YNof 2
    gi_result_overflow_pipescategoricalCertifying fitness of connected pipes0%NAof 2
    gi_req_access_ladderscategoricalcertifying inspection of access ladders0%YNof 2
    gi_result_access_ladderscategoricalCertifying fitness of access ladders0%NAof 2
    gi_req_air_ventscategoricalcertifying inspection of air vents0%YNof 2
    gi_result_air_ventscategoricalCertifying fitness of air vents0%NAof 2
    gi_req_roof_accesscategoricalCertifying inspection of roof access0%YNof 2
    gi_result_roof_accesscategoricalCertifying roof access0%NAof 2
    si_req_sedimentcategoricalCertifying inspection of tank for sediment0%YNof 2
    si_result_sedimentcategoricalCertifying condition of sediment0%NAof 2
    si_req_biological_growthcategoricalCertifying inspection for biological growth0%YNof 2
    si_result_biological_growthcategoricalCertifying condition of biological growth0%NAof 2
    si_req_debris_insectscategoricalCertifying inspection for tank debris0%YNof 2
    si_result_debris_insectscategoricalCertifying condition re tank debris0%NAof 2
    si_req_rodent_birdcategoricalCertifying inspection of evidence of rodents or birds0%YNof 2
    si_result_rodent_birdcategoricalCertifying condition for rodents or birds0%NAof 2
    sample_collectedcategoricalCertifying water sample was collected0%YNof 2
    lab_nametextLab analyzing sample for this inspection0%EMSLENVIRONMENTAL BUILDING S…EBS
    nys_certifiedcategoricalConfirming lab certifications0%YDNof 3
    analytestextdescribing analysis performed0%Bof 1
    coliformcategoricalcertifying total coliform analysis results0%APof 2
    ecolicategoricalcertifying ecoli analysis results0%APof 2
    meet_standardscategoricalCertifying other analysis meets health standards.82%YNof 2
    latitudefloatLatitude of the location of the building with the drinking water tank0%40.76414940.70360840.768244
    longitudefloatLongitude of the location of the building with the drinking water tank0%-73.955251-74.009691-74.009378
    community_boardtextCommunity Board of the location of the building with the drinking water tank0%586
    council_districttextCouncil District of the location of the building with the drinking water tank0%431
    census_tracttextThe Census Tract of the location of the building with the drinking water tank0%996113
    bbltextBorough Block Lot of the building with the drinking water tank0%101480000110005800011010497501
    ntatextNTA code of the location of the building with the drinking water tank0%Midtown-Midtown SouthUpper East Side-Carnegie…Hudson Yards-Chelsea-Fla…
    batch_datedatetimeDate the OpenData IT updates the dataset?0%2026-10-12T12:15:06.0002026-10-12T12:15:47.0002026-10-12T12:15:24.000