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

Hydrants

5bgh-vtsnEnvironment8 columns
NYCDEP Citywide Hydrants
View on NYC Open Data↗

Quality

B86.2 / 100

From a 500-row sample across 8 columns.

completeness100/ 25% weight
consistency63/ 20% weight
accuracy98/ 20% weight
timeliness74/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • NYCDEP Citywide Catch Basins0.43
    joins onunitidpoint_xpoint_y+3
  • New York City's Flood Vulnerability Index0.29
    joins onthe_geom
  • Water and Sewer Permits0.28
  • DSNY Special Waste Drop-off Sites0.27
    joins onboro
  • DSNY Litter Basket Inventory0.27
    joins onlatitudelongitude
  • Sidewalk Weekly Construction Schedule

Geography

Mappable — Socrata point column `the_geom`.

Open on the map →

Sample rows

the_geomborounitidpoint_xpoint_ycblatitudelongitude
40.77222, -73.794574H425919a1041150.586220683.27340740.7722168-73.79457092
40.64435, -73.912893H3254491008423.396174041.24531840.64434814-73.9128952
40.72506, -73.95304

Columns

8 queryable · 8 profiled

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

FieldTypeDescriptionNullValues
the_geomcoordinate—0%{'coordinates': [-73.934…{'coordinates': [-73.920…{'coordinates': [-73.938…
borocategorical—0%432of 6
unitidtext—0%H206048H429526H503917
point_xfloat—0%1012048.5841011260.741003996.527

Query this from your own app

GET /api/datasets/5bgh-vtsn
GET /api/datasets/5bgh-vtsn/quality
GET /api/datasets/5bgh-vtsn/related
GET /api/columns?dataset=5bgh-vtsn
0.27
joins oncb
  • Water and Sewer Permits (Historic)0.27
  • New York City Climate Projections: Temperature and Precipitation0.27
    • 3
    H307276
    997266.219
    203437.906
    301
    40.72505569
    -73.95304108
    40.69399, -73.994633H301843985738.421192115.37330240.6939888-73.99462891
    40.73529, -73.935694H4394101002071.97207168.643540240.73529053-73.93569183
    40.63403, -73.911473H3284761008821.144170281.91831840.63402557-73.91147614
    40.67739, -73.944003H315750999782.669186073.70430840.67739105-73.94400024
    40.56425, -74.143975H509011944249.62625144882.0782550340.56425476-74.14396667
    40.75378, -73.724854H4177301060481.036214017.84141140.75377655-73.72485352
    40.69567, -73.728884H4034651059430.365192845.79641340.6956749-73.72888184
    point_yfloat—0%167506.06198697.859172446.243
    cbtext—0%503501413
    latitudefloat—0%40.6764984140.6960601840.60956192
    longitudefloat—0%-73.94019318-73.90210724-73.89430237