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

Pedestrian Ramp - Program Progress

e7gc-ub6zTransportation13 columns
New York City Department of Transportation (NYC DOT) has developed a program dedicated to upgrading and installing pedestrian ramps and is committed to making our pedestrian space safe and accessible for all road users. The term corner refers to intersection corners (space on the sidewalk at the intersection of two streets), midblocks (a crossing that is not at an intersection, usually in between two streets), tops of T-shaped intersections, medians or islands (a small section of raised concrete in the street). A corner can have one or more ramps. Dataset used to generate the Program Progress Map on the Pedestrian Ramp Program Website: https://www.nycpedramps.info/program-progress
View on NYC Open Data↗

Quality

A91.5 / 100

From a 500-row sample across 13 columns.

completeness93/ 25% weight
consistency77/ 20% weight
accuracy99/ 20% weight
timeliness100/ 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

  • Sidewalk Management Database - All Tree Damage (ATD)0.39
  • Sidewalk Management Database - Built0.38
  • Pedestrian Ramp Locations0.36
    joins oncorneridthe_geomborough+4
  • Dining Out NYC Locations0.35
    joins onborough:@computed_region_92fq_4b7q:@computed_region_sbqj_enih+2
  • Sidewalk Management Database - Lot Info0.35
  • Sidewalk Management Database - ReInspection

Geography

Mappable — Socrata point column `the_geom`.

Open on the map →

Sample rows

the_geomobjectidcorneridstreet_namstreet_n_1boroughconstructiconstruc_1construc_2:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q:@computed_region_sbqj_enih
40.75425, -73.9092032572103926851 STREETBROADWAYQUEENSUpgrade2024/12/17Constructed39372
40.71524, -73.83919

Columns

9 queryable · 9 profiled

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

FieldTypeDescriptionNullValues
the_geomcoordinateGeometry column used for mapping0%{'coordinates': [-73.896…{'coordinates': [-73.966…{'coordinates': [-73.754…
objectidintegerA system-managed value that uniquely identifies a record or feature0%171123187518117562
corneridintegerUnique numeric identifier assigned to a corner point. A corner may contain more than one ramp.0%102679710308211090787
street_namtextThe first street name where the corner is located.0%

Query this from your own app

GET /api/datasets/e7gc-ub6z
GET /api/datasets/e7gc-ub6z/quality
GET /api/datasets/e7gc-ub6z/related
GET /api/columns?dataset=e7gc-ub6z
0.34
  • Parking Meters Locations and Status0.33
    joins onboroughobjectid:@computed_region_92fq_4b7q+3
  • TLC Driver Exam Testing Center Locations0.33
    joins onborough:@computed_region_92fq_4b7q:@computed_region_sbqj_enih+2
  • 29177
    1035640
    75 ROAD
    BEECHKNOLL ROAD
    QUEENS
    —
    —
    Not Required
    40
    3
    70
    40.83434, -73.82751142221018904DEAD ENDMEYERS STREETBRONXNew Install—Planned Construction43528
    40.83247, -73.8187221641003765LAFAYETTE AVENUEWILCOX AVENUEBRONXUpgrade—Complex Planned Construction43528
    40.90425, -73.9063486081011794NETHERLAND AVENUEWEST 256 STREETBRONXUpgrade2022/07/06Constructed48533
    40.72261, -73.8938325696103191759 ROAD69 STREETQUEENSUpgrade2025/03/08Constructed54362
    40.71502, -73.816356461001455COOLIDGE AVENUEMAIN STREETQUEENSNew Install2024/08/13Constructed25365
    40.83811, -73.82234139511018543THROGMORTON AVENUEWATERBURY AVENUEBRONX——Planned Construction43528
    40.75215, -73.9427531844103851822 STREETQUEENS PLAZAQUEENSNew Install2020/06/30Constructed39372
    40.74229, -73.8587820874102680651 AVENUE103 STREETQUEENS——Planned Construction66368

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

    BENDBROADWAY3 AVENUE
    street_n_1textThe second street name where the corner is located.0%NYCTA SUBWAYLINDEN BOULEVARDBEND
    boroughcategoricalBorough where the corner is located.0%QUEENSBROOKLYNSTATEN ISLANDof 5
    constructicategoricalIf the construction type is a pedestrian ramp upgrade or new installation.39%UpgradeNew Installof 2
    construc_1textThe date the corner construction was completed.68%2026/06/302026/06/292020/06/05
    construc_2categoricalThe status for the corner.0%Planned ConstructionConstructedNot Assignedof 6