Timothy McKenna   •   over 8 years ago

TimePointCrossings MBTA data

Hi, Does anyone have a data key for TimePointCrossings.csv? How could I do a lookup to translate crossingid to some location for example. Servicedate is 00:00:00 so I would need to get that from tripid and maybe run.

I have looked a little at GTFS realtime and NextBus without success.

• 3 comments
• 

  Dave Barker   •   over 8 years ago

  Crossingid just uniquely identifies the row. What you want is the stop. Compare that to stop_id in the GTFS stops.txt file for a description of the location as well as latitude and longitude.

• 

  Tom Schwartzman   •   over 8 years ago

  The stops.txt file has been published to Boston's spatial open data site, so you can grab it there via geoJSON or Esri JSON, kml, shapefile ready-to-go.

  http://bostonopendata.boston.opendata.arcgis.com/datasets/ceca400600f542a3b8dc42542c8c27d1_0

• 

  Tom Schwartzman   •   over 8 years ago

  Also posted is the "shapes.txt" file from GTFS. This is a csv of the vertices of lines and has been published as lines assembled from the vertices. Available here and accessible via Esri REST, geoJSON REST, kml, shape.

  http://bostonopendata.boston.opendata.arcgis.com/datasets/88c1bc1e109d420ebc02224155935add_0

Comments are closed.