City Bench Locations (Historical)
City of New York
@usgov.city_of_new_york_city_bench_locations_3903f
City of New York
@usgov.city_of_new_york_city_bench_locations_3903f
CityBench is an initiative to increase the amount of public seating on New York City’s streets. Department of Transportation (DOT) installs attractive and durable benches around the city, particularly at bus stops, retail corridors, and in areas with high concentrations of senior citizens.
Organization: City of New York
Last updated: 2021-08-07T17:18:20.427950
Tags: bench, bus, route, seat
CREATE TABLE table_1 (
"the_geom" VARCHAR,
"borocode" BIGINT,
"boroname" VARCHAR,
"borocd" BIGINT,
"coundist" BIGINT,
"assemdist" BIGINT,
"stsendist" BIGINT,
"congdist" BIGINT,
"siteid" BIGINT,
"benchid" BIGINT,
"category" VARCHAR,
"benchtype" VARCHAR,
"installati" TIMESTAMP,
"address" VARCHAR,
"geocodeadd" VARCHAR,
"street" VARCHAR,
"crossstree" VARCHAR,
"borough" VARCHAR,
"comdist" BIGINT,
"busroute" VARCHAR,
"bid" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"femafldz" VARCHAR,
"femafldt" VARCHAR,
"hrcevac" DOUBLE
);Anyone who has the link will be able to view this.