MTA.signshop_assets
No additional information has been provided for this dataset.
Between for ranges (e.g., 10,100)Regex for pattern matchingCase sensitive for exact matches
| ID | Feature ID | Geometry Type | ACCEPTED | ACTIVE | ADDRANGE | ARROW DIR | ASSET ID | ASSET NAME | ASSET NAME 1 | BAPA | BOOM TRUCK | CANCEL | CLEARANCE PERMIT | CNN | CNN 1 | COMBOKEY | CONDITION | CORNER SIDE FACING | CREATED DATE | CREATED USER | CURLYIDS | ETL | FROM ST | FROM ST 1 | GISOBJID | GLOBALID UDFCHAR44 | GPS LATITUDE | GPS LONGITUDE | INTERSECTION | INTERSECTION 1 | LAST EDITED DATE | LAST EDITED USER | LEGEND | LIMITS | LOCATION TRACK ID | LOC SPEC | NEW PURPOSE | NEW SIGN CODE | NEW SIGN LEGEND | NEW SIGN SIZE | NUM OF ASSETS | OBJECTID 1 | ORIG INSTALL DATE | POINT X | POINT Y | PURPOSE | REPLACEMENT DATE | RETIREMENT DATE | SF SUP DISTRICT | SHEETING | SIGN CATEGORY | SIGN CLASS | SIGN CODE | SIGN SIZE | SIGN SUPERVISOR | SIGN SUPPORT | STATUS CODE | STATUS DATE | STREETNAME | STREET ADDRESS RANGE | STREET ADDRESS RANGE 1 | STREET BLOCK | STREET VIEW | TO ST | TO ST 1 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23326 | N/A | Point | - | - | - | - | S232485 | JUDAH ST: 18TH AVE | - | T | T | - | F | 27365000 | 27365000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JUDAH ST | JUDAH ST | 69890 | 69890 | 37.76174715 | -122.47592409 | 18TH AVE \ JUDAH ST | 18TH AVE \ JUDAH ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | JUDAH ST intersection | - | - | - | - | - | - | - | 40404 | 1485951960000 | -122.47592409 | 37.76174715 | - | 1485907200000 | - | D4 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1484044740000 | 18TH AVE | - | - | - | - | - | - |
| 23327 | N/A | Point | - | - | - | - | S232486 | JUDAH ST: 18TH AVE | - | T | T | - | F | 27365000 | 27365000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JUDAH ST | JUDAH ST | 69891 | 69891 | 37.76174715 | -122.47592409 | 18TH AVE \ JUDAH ST | 18TH AVE \ JUDAH ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | JUDAH ST intersection | - | - | - | - | - | - | - | 40405 | 526262400000 | -122.47592409 | 37.76174715 | - | - | - | D4 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1484045460000 | 18TH AVE | - | - | - | - | - | - |
| 23328 | N/A | Point | - | - | - | - | S235738 | DE MONTFORT AVE: CAPITOL AVE | - | F | F | - | F | 22592000 | 22592000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DE MONTFORT AVE | DE MONTFORT AVE | 70178 | 70178 | 37.72365245 | -122.45921 | CAPITOL AVE \ DE MONTFORT AVE | CAPITOL AVE \ DE MONTFORT AVE | 1710539427000 | MTA | ALL WAY | DE MONTFORT AVE intersection | - | 0 / 0 | - | - | - | - | - | 40406 | 14515200000 | -122.45921 | 37.72365245 | - | 1494028800000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1493302800000 | CAPITOL AVE | - | - | - | - | - | - |
| 23329 | N/A | Point | - | - | - | - | S235739 | DE MONTFORT AVE: CAPITOL AVE | - | F | F | - | F | 22592000 | 22592000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DE MONTFORT AVE | DE MONTFORT AVE | 70179 | 70179 | 37.72365245 | -122.45921 | CAPITOL AVE \ DE MONTFORT AVE | CAPITOL AVE \ DE MONTFORT AVE | 1710539427000 | MTA | ALL WAY | DE MONTFORT AVE intersection | - | - | - | - | - | - | - | 40407 | 14515200000 | -122.45921 | 37.72365245 | - | 1494028800000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1493302860000 | CAPITOL AVE | - | - | - | - | - | - |
| 23330 | N/A | Point | 1 | 1 | 1400 - 1448 | - | S235138 | 1400-1448 FOLSOM ST | 1400-1448 FOLSOM ST | F | F | - | F | 5681000 | 5681000 | - | - | SOUTH SIDE | - | - | - | - | 10TH ST | 10TH ST | 65912 | 65912 | 37.77257736 | -122.41312192 | - | - | 1710539427000 | MTA | BIKE RACK | 10TH ST to JUNIPER ST (1400 - 1448) | 20165452 | 13FT EAST OF EPL#1425 (2FT6" FROM CRUB) | - | - | - | - | - | 40408 | 1492440900000 | -122.41312192 | 37.77257736 | - | 1492387200000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1491990480000 | FOLSOM ST | 1400 - 1448 FOLSOM ST | 1400 - 1448 FOLSOM ST | 1400 FOLSOM ST | - | JUNIPER ST | JUNIPER ST |
| 23331 | N/A | Point | 1 | 1 | 900 - 935 | - | S235140 | 900-935 HOWARD ST | 900-935 HOWARD ST | F | F | - | F | 7041000 | 7041000 | - | - | NORTH SIDE | - | - | - | - | 5TH ST | 05TH ST | 65913 | 65913 | 37.78118894 | -122.40532604 | - | - | 1753133484000 | middleware_editor | BIKE RACK | 05TH ST to MARY ST (900 - 935) | 20165401 | 8FT WEST OF EPL#926 (3FT FROM CRUB) | - | - | - | - | - | 40409 | 1492463700000 | -122.40532604 | 37.78118894 | - | 1492412400000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1491991920000 | HOWARD ST | 900 - 935 HOWARD ST | 900 - 935 HOWARD ST | 900 HOWARD ST | - | MARY ST | MARY ST |
| 23332 | N/A | Point | 1 | 1 | 900 - 935 | - | S235141 | 900-935 HOWARD ST | 900-935 HOWARD ST | F | F | - | F | 7041000 | 7041000 | - | - | NORTH SIDE | - | - | - | - | 5TH ST | 05TH ST | 65914 | 65914 | 37.78118894 | -122.40532604 | - | - | 1753133473000 | middleware_editor | BIKE RACK | 05TH ST to MARY ST (900 - 935) | 20165401 | 13FT6" WEST OF EPL#926 (3FT FROM CRUB) | - | - | - | - | - | 40410 | 1492463760000 | -122.40532604 | 37.78118894 | - | 1492412400000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1491992040000 | HOWARD ST | 900 - 935 HOWARD ST | 900 - 935 HOWARD ST | 900 HOWARD ST | - | MARY ST | MARY ST |
| 23333 | N/A | Point | - | - | - | - | S231123 | BLANKEN AVE: TUNNEL AVE | - | F | F | - | F | 20289000 | 20289000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TUNNEL AVE | BLANKEN AVE | 65948 | 65948 | 37.71201631 | -122.4007892 | BLANKEN AVE \ TUNNEL AVE | TUNNEL AVE \ BLANKEN AVE | 1710539427000 | MTA | ALL WAY | BLANKEN AVE intersection | - | 00 / 00 | - | - | - | - | - | 40411 | -400982400000 | -122.4007892 | 37.71201631 | - | 1496188800000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1479389580000 | TUNNEL AVE | - | - | - | - | - | - |
| 23334 | N/A | Point | - | - | - | - | S231126 | WHEELER AVE: LATHROP AVE | - | F | F | - | F | 20284000 | 20284000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WHEELER AVE | WHEELER AVE | 65949 | 65949 | 37.71086499 | -122.40028427 | LATHROP AVE \ WHEELER AVE | LATHROP AVE \ WHEELER AVE | 1710539427000 | MTA | ALL WAY | WHEELER AVE intersection | - | 0 / 0 | - | - | - | - | - | 40412 | 256867200000 | -122.40028427 | 37.71086499 | - | 1480377600000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 3IN IRON POST | IS | 1479390000000 | LATHROP AVE | - | - | - | - | - | - |
| 23335 | N/A | Point | - | - | - | - | S231128 | LATHROP AVE: WHEELER AVE | - | F | F | - | F | 20284000 | 20284000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | WHEELER AVE | WHEELER AVE | 65951 | 65951 | 37.71086499 | -122.40028427 | LATHROP AVE \ WHEELER AVE | LATHROP AVE \ WHEELER AVE | 1710539427000 | MTA | ALL WAY | WHEELER AVE intersection | - | 0 / 00 | - | - | - | - | - | 40413 | 283046400000 | -122.40028427 | 37.71086499 | - | 1480377600000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1479390240000 | LATHROP AVE | - | - | - | - | - | - |
| 23336 | N/A | Point | - | - | - | - | S231132 | BLANKEN AVE: PENINSULA AVE | - | F | F | - | F | 20282000 | 20282000 | - | - | SOUTH EAST CORNER | - | - | - | - | PENINSULA AVE | BLANKEN AVE | 65952 | 65952 | 37.71160893 | -122.39906445 | BLANKEN AVE \ PENINSULA AVE | PENINSULA AVE \ BLANKEN AVE | 1710539427000 | MTA | ALL WAY | BLANKEN AVE intersection | - | - | - | - | - | - | - | 40414 | 932342400000 | -122.39906445 | 37.71160893 | - | 1482364800000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1479390780000 | PENINSULA AVE | - | - | - | - | - | - |
| 23337 | N/A | Point | - | - | - | - | S231134 | BLANKEN AVE: PENINSULA AVE | - | F | F | - | F | 20282000 | 20282000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PENINSULA AVE | BLANKEN AVE | 65953 | 65953 | 37.71160893 | -122.39906445 | BLANKEN AVE \ PENINSULA AVE | PENINSULA AVE \ BLANKEN AVE | 1710539427000 | MTA | ALL WAY | BLANKEN AVE intersection | - | - | - | - | - | - | - | 40415 | 932342400000 | -122.39906445 | 37.71160893 | - | 1481846400000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1479390900000 | PENINSULA AVE | - | - | - | - | - | - |
| 23338 | N/A | Point | - | - | - | - | S231135 | PENINSULA AVE: BLANKEN AVE | - | F | F | - | F | 20282000 | 20282000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PENINSULA AVE | BLANKEN AVE | 65954 | 65954 | 37.71160893 | -122.39906445 | BLANKEN AVE \ PENINSULA AVE | PENINSULA AVE \ BLANKEN AVE | 1710539427000 | MTA | ALL WAY | BLANKEN AVE intersection | - | - | - | - | - | - | - | 40416 | 932342400000 | -122.39906445 | 37.71160893 | - | - | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1479391020000 | PENINSULA AVE | - | - | - | - | - | - |
| 23339 | N/A | Point | - | - | - | - | S230392 | OAKDALE AVE: PHELPS ST | - | F | F | - | F | 20679000 | 20679000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PHELPS ST | OAKDALE AVE | 65957 | 65957 | 37.73672865 | -122.39409283 | OAKDALE AVE \ PHELPS ST | PHELPS ST \ OAKDALE AVE | 1732141605000 | middleware_editor | ALL WAY | OAKDALE AVE intersection | - | 0 / 0 | - | - | - | - | - | 40417 | 132537600000 | -122.39409283 | 37.73672865 | - | 1732101600000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1477655400000 | PHELPS ST | - | - | - | - | - | - |
| 23340 | N/A | Point | - | - | - | - | S230395 | PHELPS ST: OAKDALE AVE | - | F | F | - | F | 20679000 | 20679000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PHELPS ST | OAKDALE AVE | 65958 | 65958 | 37.73672865 | -122.39409283 | OAKDALE AVE \ PHELPS ST | PHELPS ST \ OAKDALE AVE | 1732141912000 | middleware_editor | ALL WAY | OAKDALE AVE intersection | - | 0 / 0 | - | - | - | - | - | 40418 | -399340800000 | -122.39409283 | 37.73672865 | - | 1732104600000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1477655460000 | PHELPS ST | - | - | - | - | - | - |
| 23341 | N/A | Point | - | - | - | - | S230396 | PHELPS ST: OAKDALE AVE | - | F | F | - | F | 20679000 | 20679000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PHELPS ST | OAKDALE AVE | 65959 | 65959 | 37.73672865 | -122.39409283 | OAKDALE AVE \ PHELPS ST | PHELPS ST \ OAKDALE AVE | 1732140815000 | middleware_editor | ALL WAY | OAKDALE AVE intersection | - | 0 / 0 | - | - | - | - | - | 40419 | -399340800000 | -122.39409283 | 37.73672865 | - | 1732095600000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1477655460000 | PHELPS ST | - | - | - | - | - | - |
| 23342 | N/A | Point | - | - | - | - | S230653 | FOOTE AVE: HURON AVE | - | F | F | - | F | 21525000 | 21525000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HURON AVE | FOOTE AVE | 65960 | 65960 | 37.71425565 | -122.44677907 | FOOTE AVE \ HURON AVE | HURON AVE \ FOOTE AVE | 1732557923000 | middleware_editor | STOP | FOOTE AVE intersection | - | 0 / 00 | - | - | - | - | - | 40420 | -405475200000 | -122.44677907 | 37.71425565 | - | 1478736000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1478252760000 | HURON AVE | - | - | - | - | - | - |
| 23343 | N/A | Point | - | - | - | - | S230654 | FOOTE AVE: HURON AVE | - | F | F | - | F | 21525000 | 21525000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HURON AVE | FOOTE AVE | 65961 | 65961 | 37.71425565 | -122.44677907 | FOOTE AVE \ HURON AVE | HURON AVE \ FOOTE AVE | 1732557935000 | middleware_editor | ALL WAY | FOOTE AVE intersection | - | - | - | - | - | - | - | 40421 | 1268179200000 | -122.44677907 | 37.71425565 | - | 1478736000000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | UTILITY POLE | IS | 1478252880000 | HURON AVE | - | - | - | - | - | - |
| 23344 | N/A | Point | - | - | - | - | S230655 | VICENTE ST: 18TH AVE | - | F | F | - | F | 23158000 | 23158000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 18TH AVE | 18TH AVE | 65962 | 65962 | 37.73937137 | -122.47436459 | VICENTE ST \ 18TH AVE | VICENTE ST \ 18TH AVE | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | 18TH AVE intersection | - | - | - | - | - | - | - | 40422 | - | -122.47436459 | 37.73937137 | - | - | - | D7 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | 2IN IRON POST | IS | 1478255820000 | VICENTE ST | - | - | - | - | - | - |
| 23345 | N/A | Point | - | - | - | - | S228774 | 16TH AVE: WAWONA ST | - | F | F | - | F | 23151000 | 23151000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WAWONA ST | WAWONA ST | 65963 | 65963 | 37.73759848 | -122.47208883 | 16TH AVE \ WAWONA ST | 16TH AVE \ WAWONA ST | 1710539427000 | MTA | STOP | WAWONA ST intersection | - | X ST IS WAWONA | - | - | - | - | - | 40423 | 1474543500000 | -122.47208883 | 37.73759848 | - | 1474502400000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1473331500000 | 16TH AVE | - | - | - | - | - | - |
| 23346 | N/A | Point | - | - | - | - | S228779 | PORTOLA DR: SANTA PAULA AVE | - | F | F | - | F | 22836000 | 22836000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | SANTA PAULA AVE | SANTA PAULA AVE | 65964 | 65964 | 37.74004426 | -122.46282395 | PORTOLA DR \ SANTA PAULA AVE | PORTOLA DR \ SANTA PAULA AVE | 1710539427000 | MTA | PEDESTRIAN (SYM) | SANTA PAULA AVE intersection | - | - | - | - | - | - | - | 40424 | - | -122.46282395 | 37.74004426 | - | - | - | D7 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | LIGHT POLE | IS | 1473333240000 | PORTOLA DR | - | - | - | - | - | - |
| 23347 | N/A | Point | 1 | 1 | 3750 - 3799 | - | S242356 | 3750-3798 CALIFORNIA ST | 3750-3799 CALIFORNIA ST | T | T | - | F | 3573000 | 3573000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | COMMONWEALTH AVE | COMMONWEALTH AVE | 75466 | 75466 | 37.78605237 | -122.45627514 | - | - | 1710539427000 | MTA | (45 LA-DN) | COMMONWEALTH AVE to CHERRY ST (3750 - 3799) | - | AT CROSSWALK | - | - | - | - | - | 40425 | 1081814400000 | -122.45627514 | 37.78605237 | - | 1516924800000 | - | D2 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP1 | LIGHT POLE | IS | 1516270860000 | CALIFORNIA ST | 3750 - 3799 CALIFORNIA ST | 3750 - 3799 CALIFORNIA ST | 3750 CALIFORNIA ST | - | CHERRY ST | CHERRY ST |
| 23348 | N/A | Point | 1 | 1 | 3750 - 3799 | - | S242357 | 3750-3798 CALIFORNIA ST | 3750-3799 CALIFORNIA ST | T | T | - | F | 3573000 | 3573000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | COMMONWEALTH AVE | COMMONWEALTH AVE | 75467 | 75467 | 37.78605237 | -122.45627514 | - | - | 1710539427000 | MTA | PEDESTRIAN (SYM) | COMMONWEALTH AVE to CHERRY ST (3750 - 3799) | - | AT CROSSWALK | - | - | - | - | - | 40426 | 1081814400000 | -122.45627514 | 37.78605237 | - | 1516924800000 | - | D2 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | LIGHT POLE | IS | 1516270980000 | CALIFORNIA ST | 3750 - 3799 CALIFORNIA ST | 3750 - 3799 CALIFORNIA ST | 3750 CALIFORNIA ST | - | CHERRY ST | CHERRY ST |
| 23349 | N/A | Point | 1 | 1 | 3750 - 3799 | - | S242358 | 3750-3798 CALIFORNIA ST | 3750-3799 CALIFORNIA ST | T | T | - | F | 3573000 | 3573000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | COMMONWEALTH AVE | COMMONWEALTH AVE | 75468 | 75468 | 37.78605237 | -122.45627514 | - | - | 1710539427000 | MTA | (45 LA-DN) | COMMONWEALTH AVE to CHERRY ST (3750 - 3799) | - | AT CROSSWALK | - | - | - | - | - | 40427 | 1081814400000 | -122.45627514 | 37.78605237 | - | 1516924800000 | - | D2 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP1 | LIGHT POLE | IS | 1516271340000 | CALIFORNIA ST | 3750 - 3799 CALIFORNIA ST | 3750 - 3799 CALIFORNIA ST | 3750 CALIFORNIA ST | - | CHERRY ST | CHERRY ST |
| 23350 | N/A | Point | - | - | - | - | S242359 | CALIFORNIA ST: COMMONWEALTH AV | - | F | F | - | F | 3572000 | 27560000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | MAPLE ST | COMMONWEALTH AVE | 75469 | 75469 | 37.78610471 | -122.45586512 | - | CALIFORNIA ST \ COMMONWEALTH AVE | 1710539427000 | MTA | YIELD HERE TO PED (SYM) (LA) | COMMONWEALTH AVE intersection | - | IFO NEW SHARK TEETH PAINT | - | - | - | - | - | 40428 | 1291334400000 | -122.45586512 | 37.78610471 | - | 1516924800000 | - | D2 | - | PEDESTRIAN | REG | R1-5.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1516272180000 | CALIFORNIA ST | 3700 - 3749 CALIFORNIA ST | - | - | - | COMMONWEALTH AVE | - |
| 23351 | N/A | Point | 1 | 1 | 3750 - 3799 | - | S242360 | 3750-3798 CALIFORNIA ST | 3750-3799 CALIFORNIA ST | T | T | - | F | 3573000 | 3573000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | COMMONWEALTH AVE | COMMONWEALTH AVE | 75470 | 75470 | 37.78605237 | -122.45627514 | - | - | 1710539427000 | MTA | PEDESTRIAN (SYM) | COMMONWEALTH AVE to CHERRY ST (3750 - 3799) | - | AT CROSSWALK | - | - | - | - | - | 40429 | 1081814400000 | -122.45627514 | 37.78605237 | - | 1516924800000 | - | D2 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | LIGHT POLE | IS | 1516272300000 | CALIFORNIA ST | 3750 - 3799 CALIFORNIA ST | 3750 - 3799 CALIFORNIA ST | 3750 CALIFORNIA ST | - | CHERRY ST | CHERRY ST |
| 23352 | N/A | Point | 1 | 1 | 1 - 99 | - | S245519 | 1-99 LAKEVIEW AVE | 1-99 LAKEVIEW AVE | F | F | - | F | 8061000 | 8061000 | - | - | NORTH SIDE | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 75471 | 75471 | 37.71637609 | -122.45076687 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "V" PERMITS | SAN JOSE AVE to CAINE AVE (1 - 99) | - | 20 FT WEST OF SAN JOSE AVE | - | - | - | - | - | 40430 | 1587119700000 | -122.45076687 | 37.71637609 | - | 1598227200000 | - | D11 | - | PARKING:RPP | REG | R32C(CA).0102 | 18X21 | SUP2 | 2IN IRON POST | IS | 1526369700000 | LAKEVIEW AVE | 1 - 99 LAKEVIEW AVE | 1 - 99 LAKEVIEW AVE | 1 LAKEVIEW AVE | - | CAINE AVE | CAINE AVE |
| 23353 | N/A | Point | - | - | - | - | S245520 | SAN JOSE AVE: LAKEVIEW AVE | - | F | F | - | F | 21575000 | 21575000 | - | - | SOUTH WEST CORNER | - | - | - | - | LAKEVIEW AVE | SAN JOSE AVE | 75472 | 75472 | 37.71616897 | -122.45037835 | SAN JOSE AVE \ LAKEVIEW AVE | LAKEVIEW AVE \ SAN JOSE AVE | 1727445628000 | middleware_editor | SAN JOSE AVE | SAN JOSE AVE intersection | - | - | - | - | - | - | - | 40431 | 1531299120000 | -122.45037835 | 37.71616897 | - | - | - | D11 | - | STREET NAME | GUIDE | D3-1.1564 | 36X08 | SUP2 | 3IN IRON POST | IS | 1526370180000 | LAKEVIEW AVE | - | - | - | - | - | - |
| 23354 | N/A | Point | - | - | - | - | S245521 | LAKEVIEW AVE: SAN JOSE AVE | - | F | F | - | F | 21575000 | 21575000 | - | - | SOUTH WEST CORNER | - | - | - | - | LAKEVIEW AVE | SAN JOSE AVE | 75473 | 75473 | 37.71616897 | -122.45037835 | SAN JOSE AVE \ LAKEVIEW AVE | LAKEVIEW AVE \ SAN JOSE AVE | 1727485237000 | middleware_editor | LAKEVIEW AVE | SAN JOSE AVE intersection | - | - | - | - | - | - | - | 40432 | 1531299360000 | -122.45037835 | 37.71616897 | - | - | - | D11 | - | STREET NAME | GUIDE | D3-1.1001 | 36X08 | SUP2 | 3IN IRON POST | IS | 1526370480000 | LAKEVIEW AVE | - | - | - | - | - | - |
| 23355 | N/A | Point | - | - | - | - | S245523 | MONTECITO AVE: NORTHWOOD DR | - | F | F | - | F | 22641000 | 22641000 | - | - | SOUTH WEST CORNER | - | - | - | - | NORTHWOOD DR | NORTHWOOD DR | 75474 | 75474 | 37.72956803 | -122.45682532 | MONTECITO AVE \ NORTHWOOD DR | MONTECITO AVE \ NORTHWOOD DR | 1710539427000 | MTA | MONTECITO AVE | NORTHWOOD DR intersection | - | - | - | - | - | - | - | 40433 | 1531300680000 | -122.45682532 | 37.72956803 | - | - | - | D7 | - | STREET NAME | GUIDE | D3-1.1226 | 36X08 | SUP2 | 3IN IRON POST | IS | 1526371680000 | MONTECITO AVE | - | - | - | - | - | - |
| 23356 | N/A | Point | 1 | 1 | 700 - 799 | - | S245806 | 700-799 PARNASSUS AVE | 700-799 PARNASSUS AVE | T | T | - | F | 10295000 | 10295000 | - | - | NORTH SIDE | - | - | - | - | 4TH AVE | 04TH AVE | 75475 | 75475 | 37.76249519 | -122.46137177 | - | - | 1710539427000 | MTA | SPEED LIMIT 25 | 04TH AVE to 05TH AVE \ JUDAH ST (700 - 799) | - | 115' W OF 4TH AVE | - | - | - | - | - | 40434 | 1513123200000 | -122.46137177 | 37.76249519 | - | 1513123200000 | - | D5 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP1 | MUNI POLE | IS | 1527245580000 | PARNASSUS AVE | 700 - 799 PARNASSUS AVE | 700 - 799 PARNASSUS AVE | 700 PARNASSUS AVE | - | 05TH AVE \ JUDAH ST | 05TH AVE \ JUDAH ST |
| 23357 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S245808 | 1600-1699 POST ST | 1600-1699 POST ST | F | F | - | F | 10644000 | 10644000 | - | - | NORTH SIDE | - | - | - | - | LAGUNA ST | LAGUNA ST | 75476 | 75476 | 37.78567417 | -122.42896539 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM TUE THUR SUN STCL | LAGUNA ST to BUCHANAN ST (1600 - 1699) | - | EPL #1672 | - | - | - | - | - | 40435 | - | -122.42896539 | 37.78567417 | - | - | - | D5 | - | STREET CLEANING | REG | R30B(CA).0196 | 18X18 | SUP1 | LIGHT POLE | IS | 1527247680000 | POST ST | 1600 - 1699 POST ST | 1600 - 1699 POST ST | 1600 POST ST | - | BUCHANAN ST | BUCHANAN ST |
| 23358 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S245813 | 1800-1899 BUCHANAN ST | 1800-1899 BUCHANAN ST | F | F | - | F | 3337000 | 3337000 | - | - | WEST SIDE | - | - | - | - | SUTTER ST | SUTTER ST | 75479 | 75479 | 37.78697234 | -122.43007366 | - | - | 1721437423000 | middleware_editor | NPRK 6AM-8AM TUE STCL | SUTTER ST to BUSH ST (1800 - 1899) | - | 45' SOUTH OF BUSH | - | - | - | - | - | 40436 | 1456704000000 | -122.43007366 | 37.78697234 | - | 1667952000000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0191 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1527253740000 | BUCHANAN ST | 1800 - 1899 BUCHANAN ST | 1800 - 1899 BUCHANAN ST | 1800 BUCHANAN ST | - | BUSH ST | BUSH ST |
| 23359 | N/A | Point | 1 | 1 | 2501 - 2599 | - | S246519 | 201-2599 OFARRELL ST | 2501-2599 OFARRELL ST | F | F | - | F | 9746000 | 9746000 | - | - | SOUTH SIDE | - | - | - | - | ANZAVISTA AVE | ANZAVISTA AVE | 75480 | 75480 | 37.7811951 | -122.4465509 | - | - | 1722291100000 | middleware_editor | NPRK 9AM-11AM TUE STCL | ANZAVISTA AVE to ANZA ST \ MASONIC AVE (2501 - 2599) | - | 100' W OF ANZA VISTA | - | - | - | - | - | 40437 | - | -122.4465509 | 37.7811951 | - | 1722264300000 | - | D2 | - | STREET CLEANING | REG | R30B(CA).0308 | 18X18 | SUP1 | 2IN IRON POST | IS | 1529680740000 | OFARRELL ST | 2501 - 2599 OFARRELL ST | 2501 - 2599 OFARRELL ST | 2501 OFARRELL ST | - | ANZA ST \ MASONIC AVE | ANZA ST \ MASONIC AVE |
| 23360 | N/A | Point | - | - | - | LEFT ARROW | S240548 | FOLSOM ST: RODGERS ST | - | F | F | - | F | 24269000 | 24269000 | - | - | SOUTH SIDE | - | - | - | - | FOLSOM ST | FOLSOM ST | 75684 | 75684 | 37.77545101 | -122.40948149 | RODGERS ST \ FOLSOM ST | RODGERS ST \ FOLSOM ST | 1710539427000 | MTA | TANP ANY TIME | FOLSOM ST intersection | - | 22FT WEST | - | - | - | - | - | 40438 | 1512198540000 | -122.40948149 | 37.77545101 | - | 1512172800000 | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | 2IN IRON POST | IS | 1510756740000 | RODGERS ST | - | - | - | - | - | - |
| 23361 | N/A | Point | - | - | - | - | S240549 | FOLSOM ST: RODGERS ST | - | F | F | - | F | 24269000 | 24269000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | FOLSOM ST | 75685 | 75685 | 37.77545101 | -122.40948149 | RODGERS ST \ FOLSOM ST | RODGERS ST \ FOLSOM ST | 1710539427000 | MTA | (RA) TURNING VEHICLES YIELD (SYM) TO PED & BIKE (SYM) | FOLSOM ST intersection | - | SEE MAP | - | - | - | - | - | 40439 | 1512198360000 | -122.40948149 | 37.77545101 | - | 1512172800000 | - | D6 | - | PEDESTRIAN | REG | R10-15.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1510756860000 | RODGERS ST | - | - | - | - | - | - |
| 23362 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S246671 | 1400-1499 SUTTER ST | 1400-1499 SUTTER ST | T | T | - | F | 12332000 | 12332000 | - | - | SOUTH SIDE | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 76124 | 76124 | 37.7872348 | -122.42422527 | - | - | 1738600999000 | middleware_editor | TWO WAY TRAFFIC AHEAD | FRANKLIN ST to GOUGH ST (1400 - 1499) | - | IFO #1483 / TO WPL OF 1405 | - | - | - | - | - | 40440 | 1409184000000 | -122.42422527 | 37.7872348 | - | 1409184000000 | - | D2 | - | OTHER REGULATORY | REG | R40(CA).0001 | 24X30 | SUP1 | MUNI POLE | IS | 1530789060000 | SUTTER ST | 1400 - 1499 SUTTER ST | 1400 - 1499 SUTTER ST | 1400 SUTTER ST | - | GOUGH ST | GOUGH ST |
| 23363 | N/A | Point | 1 | 1 | 1 - 34 | - | S242302 | 1-34 4TH ST | 1-34 04TH ST | F | F | - | F | 249000 | 249000 | - | - | WEST SIDE | - | - | - | - | ELLIS ST \ MARKET ST \ STOCKTON ST | ELLIS ST \ MARKET ST \ STOCKTON ST | 76283 | 76283 | 37.78550454 | -122.40553336 | - | - | 1710539427000 | MTA | BIKE RACK | ELLIS ST \ MARKET ST \ STOCKTON ST to STEVENSON ST (1 - 34) | 04894 | IFO#12 (6FT FROM CURB) | - | - | - | - | - | 40441 | 1516272360000 | -122.40553336 | 37.78550454 | - | 1516233600000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1516109160000 | 04TH ST | 1 - 34 4TH ST | 1 - 34 04TH ST | 1 4TH ST | - | STEVENSON ST | STEVENSON ST |
| 23364 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S150927 | 2300-2399 KIRKHAM ST | 2300-2399 KIRKHAM ST | F | F | - | F | 7865000 | 7865000 | - | - | NORTH SIDE | - | - | - | - | 27TH AVE | 27TH AVE | 76284 | 76284 | 37.75943023 | -122.4859745 | - | - | 1721075138000 | middleware_editor | NPRK 8AM-10AM 1ST & 3RD FRI OF MONTH STCL | 27TH AVE to 28TH AVE (2300 - 2399) | - | 2332 KIRKHAM | - | - | - | - | - | 40442 | 1228435200000 | -122.4859745 | 37.75943023 | - | 1721048460000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0247 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375729980000 | KIRKHAM ST | 2300 - 2399 KIRKHAM ST | 2300 - 2399 KIRKHAM ST | 2300 KIRKHAM ST | - | 28TH AVE | 28TH AVE |
| 23365 | N/A | Point | - | - | - | - | S248402 | COSO AVE: BONVIEW ST \ STONEMA | - | F | F | - | F | 21272000 | 21272000 | - | - | SOUTH WEST CORNER | - | - | - | - | BONVIEW ST \ STONEMAN ST | BONVIEW ST \ COSO AVE | 76286 | 76286 | 37.74510347 | -122.41569297 | COSO AVE \ BONVIEW ST \ STONEMAN ST | STONEMAN ST \ BONVIEW ST \ COSO AVE | 1710539427000 | MTA | STOP | BONVIEW ST \ COSO AVE intersection | - | OF COSO AVE & BONVIEW-F/E/B/T | - | - | - | - | - | 40443 | 1538480700000 | -122.41569297 | 37.74510347 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1537358940000 | STONEMAN ST | - | - | - | - | - | - |
| 23366 | N/A | Point | - | - | - | - | S248864 | POLK ST: JACKSON ST | - | F | F | - | F | 25304000 | 25304000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JACKSON ST | JACKSON ST | 76288 | 76288 | 37.79414398 | -122.42140436 | POLK ST \ JACKSON ST | POLK ST \ JACKSON ST | 1710539427000 | MTA | JACKSON ST | JACKSON ST intersection | - | - | - | - | - | - | - | 40444 | 1552654500000 | -122.42140436 | 37.79414398 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-2.0198 | 72X18 | SUP1 | LIGHT POLE | IS | 1539177780000 | POLK ST | - | - | - | - | - | - |
| 23367 | N/A | Point | - | - | - | - | S248865 | JACKSON ST: POLK ST | - | F | F | - | F | 25304000 | 25304000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | JACKSON ST | JACKSON ST | 76289 | 76289 | 37.79414398 | -122.42140436 | POLK ST \ JACKSON ST | POLK ST \ JACKSON ST | 1710539427000 | MTA | POLK ST | JACKSON ST intersection | - | - | - | - | - | - | - | 40445 | 1552649520000 | -122.42140436 | 37.79414398 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-2.0281 | 72X18 | SUP1 | LIGHT POLE | IS | 1539178080000 | POLK ST | - | - | - | - | - | - |
| 23368 | N/A | Point | - | - | - | - | S248868 | JUDAH ST: 20TH AVE | - | F | F | - | F | 27369000 | 27369000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | JUDAH ST | 20TH AVE | 76290 | 76290 | 37.76165316 | -122.47806198 | 20TH AVE \ JUDAH ST | JUDAH ST \ 20TH AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EXC SAT & SUN | 20TH AVE intersection | - | - | - | - | - | - | - | 40446 | 1236124800000 | -122.47806198 | 37.76165316 | - | 1545264000000 | - | D4 | - | NO LEFT TURN | REG | R33A(CA).0014 | 30X48 | SUP2 | 2IN IRON POST | IS | 1539182580000 | JUDAH ST | - | - | - | - | - | - |
| 23369 | N/A | Point | - | - | - | - | S248869 | JUDAH ST: 21ST AVE | - | F | F | - | F | 27370000 | 27370000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 21ST AVE | 21ST AVE | 76291 | 76291 | 37.76160592 | -122.47913616 | JUDAH ST \ 21ST AVE | JUDAH ST \ 21ST AVE | 1712797543000 | middleware_editor | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EXC SAT & SUN | 21ST AVE intersection | - | - | - | - | - | - | - | 40447 | 1545304080000 | -122.47913616 | 37.76160592 | - | 1545264000000 | - | D4 | - | NO LEFT TURN | REG | R33A(CA).0014 | 30X48 | SUP2 | LIGHT POLE | IS | 1539183060000 | JUDAH ST | - | - | - | - | - | - |
| 23370 | N/A | Point | - | - | - | - | S248870 | JUDAH ST: 21ST AVE | - | F | F | - | F | 27370000 | 27370000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 21ST AVE | 21ST AVE | 76292 | 76292 | 37.76160592 | -122.47913616 | JUDAH ST \ 21ST AVE | JUDAH ST \ 21ST AVE | 1712797569000 | middleware_editor | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EXC SAT & SUN | 21ST AVE intersection | - | - | - | - | - | - | - | 40448 | - | -122.47913616 | 37.76160592 | - | - | - | D4 | - | NO LEFT TURN | REG | R33A(CA).0014 | 30X48 | SUP2 | 2IN IRON POST | IS | 1539183240000 | JUDAH ST | - | - | - | - | - | - |
| 23371 | N/A | Point | - | - | - | - | S248871 | JUDAH ST: 23RD AVE | - | T | T | - | F | 27412000 | 27412000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | JUDAH ST | 23RD AVE | 76293 | 76293 | 37.76151167 | -122.48127843 | 23RD AVE \ JUDAH ST | JUDAH ST \ 23RD AVE | 1729621749000 | middleware_editor | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EXC SAT & SUN | 23RD AVE intersection | - | - | - | - | - | - | - | 40449 | 1545308940000 | -122.48127843 | 37.76151167 | - | - | - | D4 | - | NO LEFT TURN | REG | R33A(CA).0014 | 30X48 | SUP2 | LIGHT POLE | IS | 1539183720000 | JUDAH ST | - | - | - | - | - | - |
| 23372 | N/A | Point | - | - | - | - | S248872 | JUDAH ST: 23RD AVE | - | F | F | - | F | 27412000 | 27412000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JUDAH ST | 23RD AVE | 76294 | 76294 | 37.76151167 | -122.48127843 | 23RD AVE \ JUDAH ST | JUDAH ST \ 23RD AVE | 1729621784000 | middleware_editor | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EXC SAT & SUN | 23RD AVE intersection | - | - | - | - | - | - | - | 40450 | 1545313440000 | -122.48127843 | 37.76151167 | - | - | - | D4 | - | NO LEFT TURN | REG | R33A(CA).0014 | 30X48 | SUP2 | LIGHT POLE | IS | 1539183960000 | JUDAH ST | - | - | - | - | - | - |
| 23373 | N/A | Point | - | - | - | - | S248874 | JUDAH ST: 27TH AVE | - | F | F | - | F | 27428000 | 27428000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 27TH AVE | 27TH AVE | 76296 | 76296 | 37.76132282 | -122.48556839 | JUDAH ST \ 27TH AVE | JUDAH ST \ 27TH AVE | 1738851270000 | middleware_editor | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EXC SAT & SUN | 27TH AVE intersection | - | - | - | - | - | - | - | 40451 | 1557318540000 | -122.48556839 | 37.76132282 | - | - | - | D4 | - | NO LEFT TURN | REG | R33A(CA).0014 | 30X48 | SUP2 | LIGHT POLE | IS | 1539184680000 | JUDAH ST | - | - | - | - | - | - |
| 23374 | N/A | Point | - | - | - | - | S248875 | JUDAH ST: 29TH AVE | - | F | F | - | F | 27432000 | 27432000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 29TH AVE | JUDAH ST | 76297 | 76297 | 37.76122857 | -122.48770816 | JUDAH ST \ 29TH AVE | 29TH AVE \ JUDAH ST | 1710539427000 | MTA | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EXC SAT & SUN | JUDAH ST intersection | - | - | - | - | - | - | - | 40452 | 1544624640000 | -122.48770816 | 37.76122857 | - | - | - | D4 | - | NO LEFT TURN | REG | R33A(CA).0014 | 30X48 | SUP2 | 2IN IRON POST | IS | 1539184980000 | 29TH AVE | - | - | - | - | - | - |
| 23375 | N/A | Point | - | - | - | - | S248876 | JUDAH ST: 27TH AVE | - | T | T | - | F | 27428000 | 27428000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 27TH AVE | 27TH AVE | 76298 | 76298 | 37.76132282 | -122.48556839 | JUDAH ST \ 27TH AVE | JUDAH ST \ 27TH AVE | 1738851498000 | middleware_editor | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EXC SAT & SUN | 27TH AVE intersection | - | - | - | - | - | - | - | 40453 | 1544624400000 | -122.48556839 | 37.76132282 | - | - | - | D4 | - | NO LEFT TURN | REG | R33A(CA).0014 | 30X48 | SUP2 | LIGHT POLE | IS | 1539185280000 | JUDAH ST | - | - | - | - | - | - |
| 23376 | N/A | Point | - | - | - | - | S248877 | JUDAH ST: 33RD AVE | - | F | F | - | F | 27716000 | 27716000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 33RD AVE | 33RD AVE | 76299 | 76299 | 37.76103951 | -122.49199747 | JUDAH ST \ 33RD AVE | JUDAH ST \ 33RD AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EXC SAT & SUN | 33RD AVE intersection | - | - | - | - | - | - | - | 40454 | 1544624160000 | -122.49199747 | 37.76103951 | - | - | - | D4 | - | NO LEFT TURN | REG | R33A(CA).0014 | 30X48 | SUP2 | LIGHT POLE | IS | 1539185520000 | JUDAH ST | - | - | - | - | - | - |
| 23377 | N/A | Point | - | - | - | - | S248878 | JUDAH ST: 33RD AVE | - | F | F | - | F | 27716000 | 27716000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 33RD AVE | 33RD AVE | 76300 | 76300 | 37.76103951 | -122.49199747 | JUDAH ST \ 33RD AVE | JUDAH ST \ 33RD AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EXC SAT & SUN | 33RD AVE intersection | - | - | - | - | - | - | - | 40455 | 1544624280000 | -122.49199747 | 37.76103951 | - | - | - | D4 | - | NO LEFT TURN | REG | R33A(CA).0014 | 30X48 | SUP2 | LIGHT POLE | IS | 1539185700000 | JUDAH ST | - | - | - | - | - | - |
| 23378 | N/A | Point | 1 | 1 | 3456 - 3481 | - | S256021 | 3456-3481 25TH ST | 3456-3481 25TH ST | F | F | - | F | 1443000 | 1443000 | - | - | SOUTH SIDE | - | - | - | - | BARTLETT ST | BARTLETT ST | 77394 | 77394 | 37.75055651 | -122.41966667 | - | - | 1714766873000 | middleware_editor | NPRK 6AM-8AM TUE THUR STCL | BARTLETT ST to ORANGE ALY (3456 - 3481) | - | EPL 3465 | - | - | - | - | - | 40456 | 1530144000000 | -122.41966667 | 37.75055651 | - | 1571097600000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0195 | 18X18 | SUP2 | 2IN IRON POST | IS | 1562850600000 | 25TH ST | 3456 - 3481 25TH ST | 3456 - 3481 25TH ST | 3456 25TH ST | - | ORANGE ALY | ORANGE ALY |
| 23379 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S256022 | 1200-1299 HAMPSHIRE ST | 1200-1299 HAMPSHIRE ST | F | F | - | F | 6657000 | 6657000 | - | - | EAST SIDE | - | - | - | - | 24TH ST | 24TH ST | 77395 | 77395 | 37.75210843 | -122.4072151 | - | - | 1714774965000 | middleware_editor | NPRK 9AM-11AM THUR STCL | 24TH ST to 25TH ST (1200 - 1299) | - | IFO 1295 | - | - | - | - | - | 40457 | 1444089600000 | -122.4072151 | 37.75210843 | - | 1570406400000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0304 | 18X18 | SUP2 | 2IN IRON POST | IS | 1562851260000 | HAMPSHIRE ST | 1200 - 1299 HAMPSHIRE ST | 1200 - 1299 HAMPSHIRE ST | 1200 HAMPSHIRE ST | - | 25TH ST | 25TH ST |
| 23380 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S256025 | 1200-1299 HAMPSHIRE ST | 1200-1299 HAMPSHIRE ST | F | F | - | F | 6657000 | 6657000 | - | - | EAST SIDE | - | - | - | - | 24TH ST | 24TH ST | 77396 | 77396 | 37.75210843 | -122.4072151 | - | - | 1714774933000 | middleware_editor | 1 HR PRK 8AM-6PM MON-FRI EXC "W" PERMITS | 24TH ST to 25TH ST (1200 - 1299) | - | IFO 1295 | - | - | - | - | - | 40458 | - | -122.4072151 | 37.75210843 | - | - | - | D9 | - | PARKING:RPP | REG | R32C(CA).0012 | 18X21 | SUP2 | 2IN IRON POST | IS | 1562851380000 | HAMPSHIRE ST | 1200 - 1299 HAMPSHIRE ST | 1200 - 1299 HAMPSHIRE ST | 1200 HAMPSHIRE ST | - | 25TH ST | 25TH ST |
| 23381 | N/A | Point | - | - | - | - | S254527 | MISSION ST: RICHLAND AVE | - | F | F | - | F | 21827000 | 21827000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MISSION ST | MISSION ST | 77397 | 77397 | 37.73606117 | -122.42446626 | RICHLAND AVE \ MISSION ST | RICHLAND AVE \ MISSION ST | 1710539427000 | MTA | NO TURN ON RED | MISSION ST intersection | 05702 | - | - | - | - | - | - | 40459 | 1523059200000 | -122.42446626 | 37.73606117 | - | 1589241600000 | - | D9 | - | OTHER REGULATORY | REG | R10-11A.0001 | 24X30 | SUP2 | SIGNAL POLE | IS | 1558445100000 | RICHLAND AVE | - | - | - | - | - | - |
| 23382 | N/A | Point | 1 | 1 | 200 - 299 | - | S254533 | 200-299 9TH AVE | 200-299 09TH AVE | F | F | - | F | 424000 | 424000 | - | - | EAST SIDE | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 77398 | 77398 | 37.78373545 | -122.46769668 | - | - | 1742340170000 | middleware_editor | 2 HR PRK 9AM-6PM MON-FRI EXC "N" PERMITS | CALIFORNIA ST to CLEMENT ST (200 - 299) | - | 25 FEET SOUTH FROM CALIFORNIA | - | - | - | - | - | 40460 | 1220338800000 | -122.46769668 | 37.78373545 | - | 1742246280000 | - | D1 | - | PARKING:RPP | REG | R32C(CA).0169 | 18X21 | SUP2 | 2 POST ALUMINUM | IS | 1558446660000 | 09TH AVE | 200 - 299 9TH AVE | 200 - 299 09TH AVE | 200 9TH AVE | - | CLEMENT ST | CLEMENT ST |
| 23383 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S255146 | 1200-1299 PACIFIC AVE | 1200-1299 PACIFIC AVE | F | F | - | F | 10141000 | 10141000 | - | - | NORTH SIDE | - | - | - | - | JONES ST | JONES ST | 77399 | 77399 | 37.79577369 | -122.41582911 | - | - | 1710539427000 | MTA | BIKE RACK | JONES ST to LEAVENWORTH ST (1200 - 1299) | 62483 | 15'E OF WPL 1200 PACIFIC/3' IN FROM CURB | - | - | - | - | - | 40461 | 1560262440000 | -122.41582911 | 37.79577369 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1560166260000 | PACIFIC AVE | 1200 - 1299 PACIFIC AVE | 1200 - 1299 PACIFIC AVE | 1200 PACIFIC AVE | - | LEAVENWORTH ST | LEAVENWORTH ST |
| 23384 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S255167 | 2300-2399 POLK ST | 2300-2399 POLK ST | F | F | - | F | 10579000 | 10579000 | - | - | WEST SIDE | - | - | - | - | GREEN ST | GREEN ST | 77400 | 77400 | 37.79829327 | -122.42224236 | - | - | 1710539427000 | MTA | BIKE RACK | GREEN ST to UNION ST (2300 - 2399) | 55263 | - | - | - | - | - | - | 40462 | 1560263700000 | -122.42224236 | 37.79829327 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1560178920000 | POLK ST | 2300 - 2399 POLK ST | 2300 - 2399 POLK ST | 2300 POLK ST | - | UNION ST | UNION ST |
| 23385 | N/A | Point | 1 | 1 | 2600 - 2699 | - | S255168 | 2600-2699 POLK ST | 2600-2699 POLK ST | F | F | - | F | 10582000 | 10582000 | - | - | EAST SIDE | - | - | - | - | GREENWICH ST | GREENWICH ST | 77401 | 77401 | 37.8010911 | -122.42280748 | - | - | 1710539427000 | MTA | BIKE RACK | GREENWICH ST to LOMBARD ST (2600 - 2699) | 62428 | 1' S FROM NPL 2652/3' IN FORM CURB | - | - | - | - | - | 40463 | 1560343320000 | -122.42280748 | 37.8010911 | - | - | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1560179100000 | POLK ST | 2600 - 2699 POLK ST | 2600 - 2699 POLK ST | 2600 POLK ST | - | LOMBARD ST | LOMBARD ST |
| 23386 | N/A | Point | 1 | 1 | 917 - 999 | - | S255169 | 917-999 POST ST | 917-999 POST ST | F | F | - | F | 10638000 | 10638000 | - | - | NORTH SIDE | - | - | - | - | MEACHAM PL | MEACHAM PL | 77402 | 77402 | 37.78711929 | -122.41763041 | - | - | 1710539427000 | MTA | BIKE RACK | MEACHAM PL to LARKIN ST (917 - 999) | 67475 | 6' E OF WPL #982/2.5' IN FROM CURB | - | - | - | - | - | 40464 | 1560259380000 | -122.41763041 | 37.78711929 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1560179340000 | POST ST | 917 - 999 POST ST | 917 - 999 POST ST | 917 POST ST | - | LARKIN ST | LARKIN ST |
| 23387 | N/A | Point | 1 | 1 | 917 - 999 | - | S255170 | 917-999 POST ST | 917-999 POST ST | F | F | - | F | 10638000 | 10638000 | - | - | NORTH SIDE | - | - | - | - | MEACHAM PL | MEACHAM PL | 77403 | 77403 | 37.78711929 | -122.41763041 | - | - | 1710539427000 | MTA | BIKE RACK | MEACHAM PL to LARKIN ST (917 - 999) | 67475 | 19' E OF WPL #982/2.5' IN FROM CURB | - | - | - | - | - | 40465 | 1560259260000 | -122.41763041 | 37.78711929 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1560179340000 | POST ST | 917 - 999 POST ST | 917 - 999 POST ST | 917 POST ST | - | LARKIN ST | LARKIN ST |
| 23388 | N/A | Point | 1 | 1 | 500 - 599 | - | S255172 | 500-599 FRANCISCO ST | 500-599 FRANCISCO ST | F | F | - | F | 5762000 | 5762000 | - | - | SOUTH SIDE | - | - | - | - | MASON ST | MASON ST | 77404 | 77404 | 37.80458257 | -122.41424041 | - | - | 1710539427000 | MTA | BIKE RACK | MASON ST to TAYLOR ST (500 - 599) | 55371 | 28' EAST OF WPL#521 | - | - | - | - | - | 40466 | 1560342060000 | -122.41424041 | 37.80458257 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1560179640000 | FRANCISCO ST | 500 - 599 FRANCISCO ST | 500 - 599 FRANCISCO ST | 500 FRANCISCO ST | - | TAYLOR ST | TAYLOR ST |
| 23389 | N/A | Point | 1 | 1 | 500 - 599 | - | S255173 | 500-599 FRANCISCO ST | 500-599 FRANCISCO ST | F | F | - | F | 5762000 | 5762000 | - | - | SOUTH SIDE | - | - | - | - | MASON ST | MASON ST | 77405 | 77405 | 37.80458257 | -122.41424041 | - | - | 1710539427000 | MTA | BIKE RACK | MASON ST to TAYLOR ST (500 - 599) | 55371 | 38' EAST OF WPL#521 | - | - | - | - | - | 40467 | 1560342000000 | -122.41424041 | 37.80458257 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1560179700000 | FRANCISCO ST | 500 - 599 FRANCISCO ST | 500 - 599 FRANCISCO ST | 500 FRANCISCO ST | - | TAYLOR ST | TAYLOR ST |
| 23390 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S255174 | 1300-1399 FULTON ST | 1300-1399 FULTON ST | F | F | - | F | 5891000 | 5891000 | - | - | NORTH SIDE | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 77406 | 77406 | 37.77674995 | -122.43901064 | - | - | 1710539427000 | MTA | BIKE RACK | DIVISADERO ST to BRODERICK ST (1300 - 1399) | 65894 | 10' E OF WPL #1335/2.5' IN FROM CURB | - | - | - | - | - | 40468 | 1560247920000 | -122.43901064 | 37.77674995 | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1560180180000 | FULTON ST | 1300 - 1399 FULTON ST | 1300 - 1399 FULTON ST | 1300 FULTON ST | - | BRODERICK ST | BRODERICK ST |
| 23391 | N/A | Point | 1 | 1 | 2600 - 2649 | - | S255714 | 2600-2699 LOWER GREAT HWY | 2600-2649 GREAT HWY | F | F | - | F | 23504000 | 8522000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | GREAT HWY | VICENTE ST | 77407 | 77407 | 37.73749129 | -122.50637487 | VICENTE ST \ GREAT HWY | - | 1710539427000 | MTA | ALL WAY | VICENTE ST to CUTLER AVE (2600 - 2649) | - | - | - | - | - | - | - | 40469 | 1576108800000 | -122.50637487 | 37.73749129 | - | 1684108800000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1561636560000 | GREAT HWY | - | 2600 - 2649 GREAT HWY | 2600 GREAT HWY | - | - | CUTLER AVE |
| 23392 | N/A | Point | - | - | - | - | S255768 | 20TH ST: ILLINOIS ST | - | F | F | - | F | 23562000 | 23562000 | - | - | NORTH EAST CORNER | - | - | - | - | ILLINOIS ST | 20TH ST | 77408 | 77408 | 37.76055022 | -122.38756878 | 20TH ST \ ILLINOIS ST | ILLINOIS ST \ 20TH ST | 1710539427000 | MTA | MISCELLANEOUS SIGNS | 20TH ST intersection | - | - | - | - | - | - | - | 40470 | - | -122.38756878 | 37.76055022 | - | - | - | D10 | - | OTHER GUIDE | GUIDE | G-M(SF).0038 | N/A | SUP1 | 2IN FLANGE POST | IS | 1561992720000 | ILLINOIS ST | - | - | - | - | - | - |
| 23393 | N/A | Point | - | - | - | - | S255786 | TEXAS ST: 25TH ST \ DAKOTA ST | - | F | F | - | F | 23627000 | 23627000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | 25TH ST \ DAKOTA ST | 25TH ST \ DAKOTA ST | 77409 | 77409 | 37.7524268 | -122.39458698 | TEXAS ST \ 25TH ST \ DAKOTA ST | TEXAS ST \ 25TH ST \ DAKOTA ST | 1710539427000 | MTA | STOP | 25TH ST \ DAKOTA ST intersection | - | X IS DAKOTA AND 25TH STREETS | - | - | - | - | - | 40471 | 1563276540000 | -122.39458698 | 37.7524268 | - | 1679875200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1562060280000 | TEXAS ST | - | - | - | - | - | - |
| 23394 | N/A | Point | 1 | 1 | 600 - 699 | - | S229669 | 600-699 3RD AVE | 600-699 03RD AVE | F | F | - | F | 156000 | 157000 | - | - | EAST SIDE | - | - | - | - | ANZA ST | BALBOA ST | 66981 | 66981 | 37.77644864 | -122.46072855 | - | - | 1710539427000 | MTA | BIKE RACK | BALBOA ST to CABRILLO ST (600 - 699) | 201600221 | 13 FT6" NORTH 4 FT FROM CRUB | - | - | - | - | - | 40472 | 1476316800000 | -122.46072855 | 37.77644864 | - | 1704366900000 | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1475840580000 | 03RD AVE | 500 - 599 03RD AVE | 600 - 699 03RD AVE | 600 3RD AVE | - | BALBOA ST | CABRILLO ST |
| 23395 | N/A | Point | 1 | 1 | 2400 - 2499 | - | S229673 | 2400-2499 BALBOA ST | 2400-2499 BALBOA ST | F | F | - | F | 2670000 | 2670000 | - | - | SOUTH SIDE | - | - | - | - | 25TH AVE | 25TH AVE | 66982 | 66982 | 37.77627731 | -122.48499649 | - | - | 1710539427000 | MTA | BIKE RACK | 25TH AVE to 26TH AVE (2400 - 2499) | 201600213 | 4 FT EAST OF WPL#700 4FT FROM CRUB | - | - | - | - | - | 40473 | 1486732560000 | -122.48499649 | 37.77627731 | - | 1486684800000 | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1475841660000 | BALBOA ST | 2400 - 2499 BALBOA ST | 2400 - 2499 BALBOA ST | 2400 BALBOA ST | - | 26TH AVE | 26TH AVE |
| 23396 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S229674 | 1100-1199 CLEMENT ST | 1100-1199 CLEMENT ST | F | F | - | F | 4161000 | 4161000 | - | - | NORTH SIDE | - | - | - | - | 12TH AVE | 12TH AVE | 66983 | 66983 | 37.78262431 | -122.47138051 | - | - | 1732126195000 | middleware_editor | BIKE RACK | 12TH AVE to FUNSTON AVE (1100 - 1199) | 201600278 | 2 FT WEST OF EPL#1136 3FT FROM CRUB | - | - | - | - | - | 40474 | 1476883620000 | -122.47138051 | 37.78262431 | - | 1476835200000 | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1475847060000 | CLEMENT ST | 1100 - 1199 CLEMENT ST | 1100 - 1199 CLEMENT ST | 1100 CLEMENT ST | - | FUNSTON AVE | FUNSTON AVE |
| 23397 | N/A | Point | - | - | - | - | S230405 | HUNTERS POINT EXPY: CANDLESTIC | - | F | F | - | F | 33646000 | 33646000 | - | - | SOUTH SIDE | - | - | - | - | UNNAMED #047 | UNNAMED #047 | 66987 | 66987 | 37.71271765 | -122.3815908 | CANDLESTICK POINT SRA \ UNNAMED #047 | CANDLESTICK POINT SRA \ UNNAMED #047 | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | UNNAMED #047 intersection | - | 40'W OFTHOMAS MELLON- ROAD WORKS AHEAD | - | - | - | - | - | 40475 | 1478181120000 | -122.3815908 | 37.71271765 | - | 1478131200000 | - | D10 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP1 | 2IN IRON POST | IS | 1477659000000 | CANDLESTICK POINT SRA | - | - | - | - | - | - |
| 23398 | N/A | Point | - | - | - | - | S230407 | HUNTERS POINT EXPY: CANDLESTIC | - | F | F | - | F | 33646000 | 33646000 | - | - | SOUTH SIDE | - | - | - | - | UNNAMED #047 | UNNAMED #047 | 66988 | 66988 | 37.71271765 | -122.3815908 | CANDLESTICK POINT SRA \ UNNAMED #047 | CANDLESTICK POINT SRA \ UNNAMED #047 | 1710539427000 | MTA | SPEED LIMIT 40 | UNNAMED #047 intersection | - | OPP NEC OF THOMAS MELLON | - | - | - | - | - | 40476 | - | -122.3815908 | 37.71271765 | - | - | - | D10 | - | SPEED LIMIT | REG | R2-1.0011 | 24X30 | SUP1 | 2IN IRON POST | IS | 1477659180000 | CANDLESTICK POINT SRA | - | - | - | - | - | - |
| 23399 | N/A | Point | - | - | - | - | S230409 | HUNTERS POINT EXPY: CANDLESTIC | - | F | F | - | F | 33646000 | 33646000 | - | - | SOUTH SIDE | - | - | - | - | UNNAMED #047 | UNNAMED #047 | 66989 | 66989 | 37.71271765 | -122.3815908 | CANDLESTICK POINT SRA \ UNNAMED #047 | CANDLESTICK POINT SRA \ UNNAMED #047 | 1710539427000 | MTA | THRU TAFFIC MERGE RIGHT | UNNAMED #047 intersection | - | OPP NEC OF THOMAS MELLON | - | - | - | - | - | 40477 | 1478183640000 | -122.3815908 | 37.71271765 | - | 1478131200000 | - | D10 | - | OTHER WARNING | WARNING | W4-7.0004 | 36X36 | SUP1 | 2IN IRON POST | IS | 1477659420000 | CANDLESTICK POINT SRA | - | - | - | - | - | - |
| 23400 | N/A | Point | - | - | - | - | S230410 | HUNTERS POINT EXPY: CANDLESTIC | - | F | F | - | F | 33646000 | 33646000 | - | - | SOUTH SIDE | - | - | - | - | UNNAMED #047 | UNNAMED #047 | 66990 | 66990 | 37.71271765 | -122.3815908 | CANDLESTICK POINT SRA \ UNNAMED #047 | CANDLESTICK POINT SRA \ UNNAMED #047 | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | UNNAMED #047 intersection | - | OPP C/L OF THOMAS MELLON-SEE NOTES | - | - | - | - | - | 40478 | 1478181240000 | -122.3815908 | 37.71271765 | - | 1478131200000 | - | D10 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP1 | 2IN IRON POST | IS | 1477659600000 | CANDLESTICK POINT SRA | - | - | - | - | - | - |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in meters