Skip to content

Bike share open data schema

Noel Hidalgo edited this page Jul 28, 2013 · 12 revisions

This page needs to be cleaned up

Trip Duration Data

Based off of Hubway Data Visualization Challenge, this is a proposed version of the trip duration schema.

  • XML Lead - "Ride"
  • Trip ID - "ID"
  • Start date and time - "start_date: start date of trip with date and time"
  • Start station location - "start_station: station id of start station"
  • End date and time - "end_date: end date of trip with date and time"
  • End station location - "end_station_id: station id of end station"
  • Bike number - "bike_nr: id of bicycle used"
  • Membership type - "subscription_type: (should be cognizant of varying membership types)"
  • Zipcode of member (of registered user) - "zip_code: zipcode of user"
  • age of member (of registered user) - "birth_date: birth year of user"
  • gender of member (of registered user) - "gender: gender of user"

Station Information

Based off of Hubway XML feed and JCDecaux Developer Portal this is a proposed schema for station information, status, and capacity.

  • XML Lead - "Station"
  • Station ID / Number - "ID"
  • Station Name - "terminalName"
  • Station Address - "terminalAddress"
  • Station Position (lat) - "lat: station latitude"
  • Station Position (Lng) - "lng: station longitude"
  • Station Payment Terminal Availability - "terminalBanking: Indicates if there is a 'banking' terminal"
  • Station Payment Terminal Status - "terminalLocked: indicates whether station's payment terminal is locked."
  • Station Status - "terminalStatus: open or closed."
  • Installed Date - "installDate: when the bike terminal was installed."
  • Installed Status - "installed: Logical, Yes/No."
  • Installed Type - "temporary: Logical, indicates whether station is temporary."
  • Station Removal Date - "removalDate"
  • Station Availability - "public: yes or no. indicated if the station is available to the general public or if is located behind an access controlled checkpoint, i.e. industrial, police, or military installation."
  • Station Stands Total - "nbCapacity: Number of stands at station."
  • Station Stands, Available - "nbEmptyDocks: Number of empty docks at station."
  • Station Stands, with Bikes Available for rental - "nbBikes: Number of bikes at station."
  • Number of broken bikes at station - "nbBroken: Number of bikes indicated broken at station."
  • Last communication with central server - "lastCommWithServer: Last communication with central server."
  • Last update received from station. - "latestUpdateTime: Last update received from station."

Bike Hire Fare

TBD

Bike Rack Location

  • XML Lead - "CycleRack"
  • Rack ID / Number - "ID"
  • Rack Name - "rackName"
  • Rack Address - "rackAddress"
  • Rack Position (lat) - "lat: station latitude"
  • Rack Position (Lng) - "lng: station longitude"
  • Rack Installed Date - "installDate: when the bike terminal was installed."
  • Rack Status - "installed: Logical, Yes/No."
  • Rack Type - "temporary: Logical, indicates whether station is temporary."
  • Rack Removal Date - "removalDate"
  • Rack Total - "nbCapacity: Number of stands at station."
Clone this wiki locally