The City and County of San Francisco has a new open data site: Data.SFGov.org.
Please follow the link to the site to search, browse and view San Francisco data.


Description: Transit schedule data published by SFMTA in GTFS format for developers to use.

The zip file contains the following datasets:
agency.txt | basic SFMTA information
calendar_dates.txt | Lists exceptions for the service IDs defined in the calendar.txt file.
calendar.txt | Defines dates for service IDs using a weekly schedule. Specify when service starts and ends, as well as days of the week where service is available.
fare_attributes.txt | Defines SFMTA fare information.
fare_rules.txt | Defines SFMTA fare information.
routes.txt | Contains information about SFMTA routes. A route is a group of trips that are displayed to riders as a single service.
shapes.txt | Defines the rules for drawing lines on a map to represent SFMTA routes.
stops_times.txt | Lists the times that a vehicle arrives at and departs from individual stops for each trip.
stops.txt | Contains information about individual locations where vehicles pick up or drop off passengers.
trips.txt | Lists all trips and their routes. A trip is a sequence of two or more stops that occurs at specific time.
Agency Name: SFMTA
Date Released: 6/10/2009
Time Period: 6-13-09 to prior day
Frequency: Signup cycle
Format: CSV
Location of Data Dictionary: http://code.google.com/transit/spec/transit_feed_specification.html#Google_Transit_Feed_Field_Definitions

Comments


Written by ataruc
test
Has anyone ever noticed that the times that you get for public transportation are way off anyway when you use google maps?



Written by charlesbelov
test
The SFMTA strives to provide accurate information. Please provide a few specific examples in which the times are off.

Hope this helps,

Charles Belov

SFMTA webmaster

http://www.sfmta.com/webmaster



Written by Ajay
test
I don't see realtime data here. Why can't I get realtime data about arrival times of the MUNI fleet? That would make this site really useful. A static list of routes, schedules and stops has marginal use without realtime data.



Written by charlesbelov
test
Realtime data is at http://www.datasf.org/story.php?title=nextmuni-xml-data

Hope this helps,

Charles Belov

SFMTA Webmaster



Written by jamison
test
Charles,

Are you saying that you are aware SFMTA is publishing arrival time information in GTFS, but are not aware what you're publishing isn't realtime predictions using NextBus data?

While it should be obvious that Google Transit's predictions are based on data in the Google Trasnit Feed Specification, just in case it's actually spelled out right there:

"stops_times.txt | Lists the times that a vehicle arrives at and departs from individual stops for each trip."

By publishing out of data schedule information, you are not providing "accurate information" to users of Google Transit and any other app which uses SFMTA's GTFS feed information, this includes the iPhone as well.



Written by charlesbelov
test
The SFMTA is publishing schedule data in GTFS.

Realtime data is at http://www.datasf.org/story.php?title=nextmuni-xml-data

Hope this helps,

Charles Belov

SFMTA Webmaster



Written by chadsalinas
test
Chad Salinas says: Hey Jamison! I didn't see "Google Transit" as an iPhone app. Which iPhone app are you using to get SFMTA's GTFS feed?

Cheers,

Chad



Written by chadsalinas
test
Chad Salinas says: Exposing a real-time Transit dataset requires changing Http Post from Add to Upsert for idempotent incremental changes.



Written by marcos
test
How does the idempotency of DB write operations impact on providing a live feed of vehicle position information? What side effects would a GET on RT data have?

I'd like to see a real time dataset which describes the current state of all vehicles in the form of:

(veh_number, line_number, direction, last_stop, xpos, ypos)

It would be nice to query using line_number and direction to prune the response.



Written by chadsalinas
test
Hey Marcos! As you rightly mentioned, not an issue for the GET. Curious about incremental UPDATEs and new POSTs.

Cheers,

Chad Salinas



Written by kimbrel
test
Are there plans to export scheduled route headways in the GTFS data?



Written by lmz
test
Hi - This link appears to be broken at the moment; on the web page http://www.sfmta.com/cms/asystem/transitdata.php, the download link is this:

I agree to the SFMTA Transit Data License Agreement and want to download the file.

thanks,

-Lisa



Written by lmz
test
Hmm I'll try that again; the html was stripped:

<a href="file:///H|/0undercon/transitdata/google_transit.zip">I agree to the SFMTA Transit Data License Agreement and want to download the file.</a>



Log in to comment or register here.
DataSF is a clearinghouse of datasets available from the City & County of San Francisco. Our goal in releasing this site is:
(1) improve access to data
(2) help our community create innovative apps
(3) understand what datasets you'd like to see
(4) get feedback on the quality of our datasets.