Pedestrian Space Added

Pedestrian space added is former roadway that has been repurposed to accommodate pedestrians and to be free of vehicles. Pedestrian space can be constructed in concrete or demarcated by colored paint. Typical pedestrian spaces added include pedestrian refuge islands, medians or median extensions, plazas, sidewalk extensions, and neckdowns. 

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/pedestrian-space-added-uebm-cmjr\".\"pedestrian_space_added\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.