Bike share open data schema

This page needs to be cleaned up

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"

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."

TBL