Baselight

Bicycle & Pedestrian Counts

City of Somerville

@usgov.city_of_somerville_bicycle_pedestrian_counts

Table 1
@usgov.city_of_somerville_bicycle_pedestrian_counts.table_1

  • 13.45 KB
  • 2364 rows
  • 8 columns
year

Year

location

Location #

location_name

Location Name

latitude

Latitude

longitude

Longitude

am_pm

AM/PM

mode

Mode

count

Count

20241Webster Ave & Prospect St42.377-71.0956AMBike77
20241Webster Ave & Prospect St42.377-71.0956AMPed204
20241Webster Ave & Prospect St42.377-71.0956PMBike245
20241Webster Ave & Prospect St42.377-71.0956PMPed377
20242Washington St & Somerville Ave42.3796-71.0964AMBike214
20242Washington St & Somerville Ave42.3796-71.0964AMPed544
20242Washington St & Somerville Ave42.3796-71.0964PMBike236
20242Washington St & Somerville Ave42.3796-71.0964PMPed723
20243Somerville Ave & Prospect St42.3791-71.0941AMBike160
20243Somerville Ave & Prospect St42.3791-71.0941AMPed275

CREATE TABLE table_1 (
  "year" BIGINT,
  "location" BIGINT,
  "location_name" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "am_pm" VARCHAR,
  "mode" VARCHAR,
  "count" BIGINT
);

Share link

Anyone who has the link will be able to view this.