About this Dataset

Healthy Ride Stations (archive)

Healthy Ride station locations, names, id numbers, and dock capacities.

The Healthy Ride system was replaced by POGOH in May 2022. Data for the POGOH system may be found here: https://data.wprdc.org/organization/pogoh
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:07:37.780157
Tags: bike-share, return, station

Tables

Stations 2015 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2015_q3

6.37 KB
50 rows
5 columns


CREATE TABLE stations_2015_q3 (
  "stationnum" BIGINT,
  "stationname" VARCHAR,
  "rackqnty" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2015 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2015_q4

6.37 KB
50 rows
5 columns


CREATE TABLE stations_2015_q4 (
  "stationnum" BIGINT,
  "stationname" VARCHAR,
  "rackqnty" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2016 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2016_q1

6.37 KB
50 rows
5 columns


CREATE TABLE stations_2016_q1 (
  "stationnum" BIGINT,
  "stationname" VARCHAR,
  "rackqnty" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2016 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2016_q2

6.37 KB
50 rows
5 columns


CREATE TABLE stations_2016_q2 (
  "stationnum" BIGINT,
  "stationname" VARCHAR,
  "rackqnty" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2016 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2016_q3

6.67 KB
50 rows
5 columns


CREATE TABLE stations_2016_q3 (
  "station" BIGINT,
  "station_name" VARCHAR,
  "n__of_racks" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2016 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2016_q4

6.67 KB
50 rows
5 columns


CREATE TABLE stations_2016_q4 (
  "station" BIGINT,
  "station_name" VARCHAR,
  "n__of_racks" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2017 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2017_q1

6.79 KB
52 rows
5 columns


CREATE TABLE stations_2017_q1 (
  "station" BIGINT,
  "station_name" VARCHAR,
  "n__of_racks" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2018 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2018_q4

8.92 KB
105 rows
5 columns


CREATE TABLE stations_2018_q4 (
  "station" BIGINT,
  "station_name" VARCHAR,
  "n__of_racks" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2019 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2019_q1

9.01 KB
108 rows
5 columns


CREATE TABLE stations_2019_q1 (
  "station" BIGINT,
  "station_name" VARCHAR,
  "n__of_racks" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2019 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2019_q2

9.16 KB
112 rows
5 columns


CREATE TABLE stations_2019_q2 (
  "station" BIGINT,
  "station_name" VARCHAR,
  "n__of_racks" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2019 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2019_q3

10.19 KB
1002 rows
7 columns


CREATE TABLE stations_2019_q3 (
  "station" DOUBLE,
  "station_name" VARCHAR,
  "n__of_racks" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

Stations 2019 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2019_q4

8.7 KB
100 rows
5 columns


CREATE TABLE stations_2019_q4 (
  "station" BIGINT,
  "station_name" VARCHAR,
  "n__of_racks" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2020 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2020_q1

8.7 KB
100 rows
5 columns


CREATE TABLE stations_2020_q1 (
  "station" BIGINT,
  "station_name" VARCHAR,
  "n__of_racks" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2020 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2020_q2

8.7 KB
100 rows
5 columns


CREATE TABLE stations_2020_q2 (
  "station" BIGINT,
  "station_name" VARCHAR,
  "n__of_racks" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2020 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2020_q3

8.7 KB
100 rows
5 columns


CREATE TABLE stations_2020_q3 (
  "station" BIGINT,
  "station_name" VARCHAR,
  "n__of_racks" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2020 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2020_q4

8.7 KB
100 rows
5 columns


CREATE TABLE stations_2020_q4 (
  "station" BIGINT,
  "station_name" VARCHAR,
  "n__of_racks" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2021 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2021_q1

8.7 KB
100 rows
5 columns


CREATE TABLE stations_2021_q1 (
  "station" BIGINT,
  "station_name" VARCHAR,
  "n__of_racks" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2021 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2021_q2

22.63 KB
192 rows
18 columns


CREATE TABLE stations_2021_q2 (
  "uid" BIGINT,
  "city" VARCHAR,
  "place_name" VARCHAR,
  "official_station" BIGINT,
  "station_number" DOUBLE,
  "free_bikes" BIGINT,
  "total_bikes" BIGINT,
  "place_type" VARCHAR,
  "comment" VARCHAR,
  "setpoint_bikes" DOUBLE,
  "bike_racks" DOUBLE,
  "show_in_maps" DOUBLE,
  "battery_voltage" DOUBLE,
  "solar_voltage" VARCHAR,
  "terminal_type" VARCHAR,
  "online" DOUBLE,
  "time_stamp" TIMESTAMP,
  "creation_date" VARCHAR
);

Stations 2021 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2021_q3

8.75 KB
105 rows
5 columns


CREATE TABLE stations_2021_q3 (
  "station" BIGINT,
  "station_name" VARCHAR,
  "n__of_racks" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Stations 2021 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_stations_archive.stations_2021_q4

7.66 KB
76 rows
5 columns


CREATE TABLE stations_2021_q4 (
  "station" BIGINT,
  "station_name" VARCHAR,
  "n__of_racks" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);