About this Dataset

Locations Of Docked Bikeshare Stations By System And Year

Latitude and longitude for docked bikeshare stations by system and year. Data can be used to see the changes in the locations of docked bikeshare stations over time within a system. Only docked bikeshare systems open to the general public are included in the count. College, employer, and resident docked bikeshare systems are not counted.
Organization: Department of Transportation
Last updated: 2020-11-12T12:39:08.243223
Tags: bikeshare, docked-bikeshare

Tables

Table 1

@usgov.dot_gov_locations_of_docked_bikeshare_stations_by_syst_7e577338.table_1

3.62 MB
78,394 rows
19 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "id" BIGINT,
  "fac_id" VARCHAR,
  "bike_id" VARCHAR,
  "system_id" BIGINT,
  "system_name" VARCHAR,
  "year" BIGINT,
  "asofdate" BIGINT,
  "fac_name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" VARCHAR,
  "cbsa_code" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "station_type" VARCHAR,
  "launchdate" VARCHAR,
  "enddate" VARCHAR
);