route_id,agency_id,route_short_name,route_long_name,route_desc,route_type,route_url,route_color,route_text_color
11839,SFMTA,1,CALIFORNIA, ,3, , , 
1033,SFMTA,1AX ,CALIFORNIA A EXPRESS, ,3, , , 
1034,SFMTA,1BX ,CALIFORNIA B EXPRESS, ,3, , , 
1031,SFMTA,31AX,BALBOA A EXPRESS, ,3, , , 
1032,SFMTA,31BX,BALBOA B EXPRESS, ,3, , , 
1038,SFMTA,38AX,GEARY A EXPRESS, ,3, , , 
1039,SFMTA,38BX,GEARY B EXPRESS, ,3, , , 
11841,SFMTA,2,CLEMENT, ,3, , , 
11842,SFMTA,3,JACKSON, ,3, , , 
1005,SFMTA,5,FULTON , ,3, , , 
1055,SFMTA,5R  ,FULTON  RAPID, ,3, , , 
11844,SFMTA,6,HAIGHT-PARNASSUS, ,3, , , 
1071,SFMTA,7,HAIGHT-NORIEGA,,3,,,
1072,SFMTA,7R  ,HAIGHT-NORIEGA RAPID, ,3, , , 
11846,SFMTA,7X,NORIEGA EXPRESS, ,3, , , 
1110,SFMTA,8,BAYSHORE, ,3, , , 
1108,SFMTA,8AX ,Bayshore A Express, ,3, , , 
1109,SFMTA,8BX ,Bayshore B Express, ,3, , , 
1900,SFMTA,9,SAN Bruno , ,3, , , 
1901,SFMTA,9R  ,SAN BRUNO RAPID, ,3, , , 
11849,SFMTA,10,TOWNSEND, ,3, , , 
11850,SFMTA,12,FOLSOM-PACIFIC, ,3, , , 
11851,SFMTA,14,MISSION, ,3, , , 
11852,SFMTA,14R,MISSION RAPID, ,3, , , 
11853,SFMTA,14X,MISSION EXPRESS, ,3, , , 
11854,SFMTA,18,46TH AVENUE, ,3, , , 
11855,SFMTA,19,POLK, ,3, , , 
11856,SFMTA,21,HAYES, ,3, , , 
11857,SFMTA,22,FILLMORE, ,3, , , 
11858,SFMTA,23,MONTEREY, ,3, , , 
11859,SFMTA,24,DIVISADERO, ,3, , , 
11860,SFMTA,25,TREASURE ISLAND, ,3, , , 
11861,SFMTA,27,BRYANT, ,3, , , 
11862,SFMTA,28,19TH AVENUE, ,3, , , 
11863,SFMTA,28R,19TH AVENUE, ,3, , , 
11864,SFMTA,29,SUNSET, ,3, , , 
11865,SFMTA,30,STOCKTON, ,3, , , 
11866,SFMTA,30X,MARINA EXPRESS, ,3, , , 
11867,SFMTA,31,BALBOA, ,3, , , 
11868,SFMTA,33,ASHBURY-18TH ST, ,3, , , 
11869,SFMTA,35,EUREKA, ,3, , , 
11870,SFMTA,36,TERESITA, ,3, , , 
11871,SFMTA,37,CORBETT, ,3, , , 
11872,SFMTA,38,GEARY, ,3, , , 
11873,SFMTA,38R,GEARY RAPID, ,3, , , 
11874,SFMTA,39,COIT, ,3, , , 
11875,SFMTA,41,UNION, ,3, , , 
11876,SFMTA,43,MASONIC, ,3, , , 
11877,SFMTA,44,O'SHAUGHNESSY, ,3, , , 
11878,SFMTA,45,UNION-STOCKTON, ,3, , , 
11879,SFMTA,47,VAN NESS, ,3, , , 
11880,SFMTA,48,QUINTARA-24TH STREET, ,3, , , 
11881,SFMTA,49,VAN NESS-MISSION, ,3, , , 
11882,SFMTA,52,EXCELSIOR, ,3, , , 
11883,SFMTA,54,FELTON, ,3, , , 
11884,SFMTA,55,16TH STREET, ,3, , , 
11885,SFMTA,56,RUTLAND, ,3, , , 
11886,SFMTA,57,PARKMERCED, ,3, , , 
1059,SFMTA,Powell-Mason,CABLE CAR, ,5, , , 
1060,SFMTA,Powell-Hyde,CABLE CAR, ,5, , , 
11889,SFMTA,CALIFORNIA ,CABLE CAR, ,5, , , 
11890,SFMTA,66,QUINTARA, ,3, , , 
11891,SFMTA,67,BERNAL HEIGHTS, ,3, , , 
11892,SFMTA,76X,MARIN HEADLANDS EXPRESS, ,3, , , 
1081,SFMTA,81X ,CALTRAIN EXPRESS, ,3, , , 
1082,SFMTA,82X ,LEVI PLAZA EXPRESS, ,3, , , 
11894,SFMTA,83X,MID-MARKET EXPRESS, ,3, , , 
11895,SFMTA,88,BART SHUTTLE, ,3, , , 
11896,SFMTA,90,SAN BRUNO OWL, ,3, , , 
11897,SFMTA,91,3RD-19TH AVE OWL, ,3, , , 
1102,SFMTA,K-OWL,, ,3, , , 
1103,SFMTA,L-OWL,, ,3, , , 
1104,SFMTA,M-OWL,, ,3, , , 
1105,SFMTA,N-OWL,, ,3, , , 
1106,SFMTA,T-OWL,, ,3, , , 
11902,SFMTA,E,EMBARCADERO, ,0, , , 
11904,SFMTA,F,MARKET & WHARVES, ,0, , , 
11910,SFMTA,J,CHURCH, ,0, , , 
11911,SFMTA,KT,INGLESIDETHIRD, ,0, , , 
11912,SFMTA,L,TARAVAL, ,0, , , 
11913,SFMTA,M,OCEANVIEW, ,0, , , 
11914,SFMTA,N,JUDAH, ,0, , , 
11915,SFMTA,NX,N EXPRESS, ,3, , ,