CaBi XML feed location and information
- This topic has 3 replies, 3 voices, and was last updated 12 years, 3 months ago by .
-
Topic
-
Capital Bikeshare uses an XML feed to publish data station data. The feed is located at http://www.capitalbikeshare.com/data/stations/bikeStations.xml (updated 1/31/12, old location now redirects)
This feed contains data as outlined below:
[HTML]
1
20th & Bell St
31000
38.8561
-77.0512
true
false
1316059200000
false
3
8
1328287786738
… additional stations removed …
[/HTML]where:
stations: lastUpdate: a timestamp* of when the XML file was updated
station:
[B]id[/B]: a numeric identifier of the station
[B]name[/B]: the station’s name
[B]terminalName[/B]: the terminal #
[B]lat[/B]: geographic Latitudinal coordinate
[B]long[/B]: geographic Longitudinal coordinate
[B]installed[/B]: true or false
[B]locked[/B]: true or false, A station can be locked administratively. I think this makes the station inoperable, but it may just prevent bikes from being checked out while still allowing bikes to be checked in.
[B]installDate[/B]: a timestamp* of when the station was installed, can be null.
[B]removalDate[/B]: a timestamp* of when the station was removed, can be null.
[B]temporary[/B]: true or false
[B]nbBikes[/B]: the number of bicycles currently docked at this station. I believe it only displays working bicycles (bicycles not marked as needing service).
[B]nbEmptyDocks[/B]: the number of currently available docks. I believe it only displays working docks.
[B]latestUpdateTime[/B]: This appears to be a timestamp* of when the station last saw activity. This field was added sometime mid-2011. The description has not been officially confirmed**.[B]* [/B]timestamps are 13-digit timestamp (10-digit UNIX timestamp + 3 digit millisecond value)
[B]** [/B]The evidence that supports the definition of LatestUpdateTime: The sample data above was captured shortly after 12:22:34 PM on Friday, February 03, 2012 (lastUpdate: 1328289754676). Station 1 contained 3 bikes and 8 docks. The latestUpdateTime for this station was 1328287786738 which equals Friday, February 03, 2012 11:49:46 AM. A look at cabitracker.com on the page for[URL=”www.cabitracker.com/station.php?id=1&s=2012-02-03&e=2012-02-03″] Station 1 at February 3, 2012[/URL] yields a graph that showed that station’s status throughout the day. At 11:49 AM the station was reporting 4 bikes and 7 docks, but at 11:50 AM the station was reporting 3 bikes and 8 docks. This time corresponds perfectly with the latestUpdateTime above.[/CODE][CODE]stations: lastUpdate: a timestamp* of when the XML file was updated
station:
id: a numeric identifier of the station
name: the station’s name
terminalName: the terminal #
lat: geographic Latitudinal coordinate
long: geographic Longitudinal coordinate
installed: true or false
locked: true or false, A station can be locked administratively. I think this makes the station inoperable, but it may just prevent bikes from being checked out while still allowing bikes to be checked in.
installDate: a timestamp* of when the station was installed, can be null.
removalDate: a timestamp* of when the station was removed, can be null.
temporary: true or false
nbBikes: the number of bicycles currently docked at this station. I believe it only displays working bicycles (bicycles not marked as needing service).
nbEmptyDocks: the number of currently available docks. I believe it only displays working docks.
latestUpdateTime: This appears to be a timestamp* of when the station last saw activity. This field was added sometime mid-2011. The description has not been officially confirmed**.* timestamps are 13-digit timestamp (10-digit UNIX timestamp + 3 digit millisecond value)
** The evidence that supports the definition of LatestUpdateTime: The sample data above was captured shortly after 12:22:34 PM on Friday, February 03, 2012 (lastUpdate: 1328289754676). Station 1 contained 3 bikes and 8 docks. The latestUpdateTime for this station was 1328287786738 which equals Friday, February 03, 2012 11:49:46 AM. A look at cabitracker.com on the page for Station 1 at February 3, 2012 yields a graph that showed that station’s status throughout the day. At 11:49 AM the station was reporting 4 bikes and 7 docks, but at 11:50 AM the station was reporting 3 bikes and 8 docks. This time corresponds perfectly with the latestUpdateTime above.[/CODE]
- You must be logged in to reply to this topic.