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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22501 | N/A | Point | - | - | - | - | S232973 | TARAVAL ST: 46TH AVE | - | F | F | - | F | 23502000 | 23502000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 46TH AVE | 68496 | 68496 | 37.74176468 | -122.50462045 | 46TH AVE \ TARAVAL ST | TARAVAL ST \ 46TH AVE | 1727271971000 | middleware_editor | LEFT LANE TRAINS LEFT TURNS ONLY 24 HOURS | 46TH AVE intersection | - | 12`EAST | - | - | - | - | - | 39579 | 1486215840000 | -122.50462045 | 37.74176468 | - | 1486166400000 | - | D4 | - | OTHER REGULATORY | REG | SR60-4(SF).0002 | 30X42 | SUP2 | MUNI POLE | IS | 1485349260000 | TARAVAL ST | - | - | - | - | - | - |
| 22502 | N/A | Point | - | - | - | - | S232975 | TARAVAL ST: 45TH AVE | - | F | F | - | F | 23463000 | 23463000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 45TH AVE | 68498 | 68498 | 37.74181319 | -122.50354896 | 45TH AVE \ TARAVAL ST | TARAVAL ST \ 45TH AVE | 1710539427000 | MTA | LEFT LANE TRAINS LEFT TURNS ONLY 24 HOURS | 45TH AVE intersection | - | - | - | - | - | - | - | 39580 | 1486215840000 | -122.50354896 | 37.74181319 | - | 1629244800000 | - | D4 | - | OTHER REGULATORY | REG | SR60-4(SF).0002 | 30X42 | SUP2 | MUNI POLE | IS | 1485349860000 | TARAVAL ST | - | - | - | - | - | - |
| 22503 | N/A | Point | - | - | - | - | S232977 | TARAVAL ST: 45TH AVE | - | F | F | - | F | 23463000 | 23463000 | - | - | NORTH SIDE | - | - | - | - | TARAVAL ST | 45TH AVE | 68499 | 68499 | 37.74181319 | -122.50354896 | 45TH AVE \ TARAVAL ST | TARAVAL ST \ 45TH AVE | 1710539427000 | MTA | NPRK 7AM-8AM TUE FRI STCL | 45TH AVE intersection | - | 30`WEST OF 44TH AVE | - | - | - | - | - | 39581 | 1630504500000 | -122.50354896 | 37.74181319 | - | - | - | D4 | - | STREET CLEANING | REG | R30B(CA).0219 | 18X18 | SUP2 | MUNI POLE | IS | 1485350460000 | TARAVAL ST | - | - | - | - | - | - |
| 22504 | N/A | Point | - | - | - | - | S232978 | TARAVAL ST: 45TH AVE | - | F | F | - | F | 23463000 | 23463000 | - | - | NORTH SIDE | - | - | - | - | TARAVAL ST | 45TH AVE | 68500 | 68500 | 37.74181319 | -122.50354896 | 45TH AVE \ TARAVAL ST | TARAVAL ST \ 45TH AVE | 1710539427000 | MTA | NPRK 7AM-8AM TUE FRI STCL | 45TH AVE intersection | - | 100 FT WEST | - | - | - | - | - | 39582 | - | -122.50354896 | 37.74181319 | - | - | - | D4 | - | STREET CLEANING | REG | R30B(CA).0219 | 18X18 | SUP2 | MUNI POLE | IS | 1485350700000 | TARAVAL ST | - | - | - | - | - | - |
| 22505 | N/A | Point | - | - | - | - | S232981 | TARAVAL ST: 45TH AVE | - | F | F | - | F | 23463000 | 23463000 | - | - | SOUTH SIDE | - | - | - | - | TARAVAL ST | 45TH AVE | 68501 | 68501 | 37.74181319 | -122.50354896 | 45TH AVE \ TARAVAL ST | TARAVAL ST \ 45TH AVE | 1710539427000 | MTA | TANSAT | 45TH AVE intersection | - | 20 FT WEST OF 44TH AVE | - | - | - | - | - | 39583 | 1485531660000 | -122.50354896 | 37.74181319 | - | 1485475200000 | - | D4 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | LIGHT POLE | IS | 1485351240000 | TARAVAL ST | - | - | - | - | - | - |
| 22506 | N/A | Point | - | - | - | - | S232983 | TARAVAL ST: 44TH AVE | - | T | T | - | F | 23462000 | 23462000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 44TH AVE | 44TH AVE | 68502 | 68502 | 37.74186172 | -122.50247674 | TARAVAL ST \ 44TH AVE | TARAVAL ST \ 44TH AVE | 1710539427000 | MTA | LEFT LANE TRAINS LEFT TURNS ONLY 24 HOURS | 44TH AVE intersection | - | - | - | - | - | - | - | 39584 | 1486215900000 | -122.50247674 | 37.74186172 | - | 1629244800000 | - | D4 | - | OTHER REGULATORY | REG | SR60-4(SF).0002 | 30X42 | SUP2 | MUNI POLE | IS | 1485351600000 | TARAVAL ST | - | - | - | - | - | - |
| 22507 | N/A | Point | - | - | - | - | S232984 | TARAVAL ST: 43RD AVE | - | T | T | - | F | 23459000 | 23459000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 43RD AVE | 68503 | 68503 | 37.74191028 | -122.50140363 | 43RD AVE \ TARAVAL ST | TARAVAL ST \ 43RD AVE | 1710539427000 | MTA | LEFT LANE TRAINS LEFT TURNS ONLY 24 HOURS | 43RD AVE intersection | - | - | - | - | - | - | - | 39585 | 1486215960000 | -122.50140363 | 37.74191028 | - | 1629244800000 | - | D4 | - | OTHER REGULATORY | REG | SR60-4(SF).0002 | 30X42 | SUP2 | MUNI POLE | IS | 1485351840000 | TARAVAL ST | - | - | - | - | - | - |
| 22508 | N/A | Point | - | - | - | - | S232985 | TARAVAL ST: 43RD AVE | - | T | T | - | F | 23459000 | 23459000 | - | - | SOUTH SIDE | - | - | - | - | TARAVAL ST | 43RD AVE | 68504 | 68504 | 37.74191028 | -122.50140363 | 43RD AVE \ TARAVAL ST | TARAVAL ST \ 43RD AVE | 1710539427000 | MTA | TANSAT | 43RD AVE intersection | - | 80`EAST (SEE PAINT) | - | - | - | - | - | 39586 | 1485939000000 | -122.50140363 | 37.74191028 | - | 1485907200000 | - | D4 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | 2IN IRON POST | IS | 1485352260000 | TARAVAL ST | - | - | - | - | - | - |
| 22509 | N/A | Point | - | - | - | - | S232986 | TARAVAL ST: 42ND AVE | - | T | T | - | F | 23458000 | 23458000 | - | - | SOUTH SIDE | - | - | - | - | TARAVAL ST | 42ND AVE | 68505 | 68505 | 37.74195875 | -122.50033242 | 42ND AVE \ TARAVAL ST | TARAVAL ST \ 42ND AVE | 1740420618000 | middleware_editor | TANSAT | 42ND AVE intersection | - | 80`WEST (SEE PAINT) | - | - | - | - | - | 39587 | 1485528840000 | -122.50033242 | 37.74195875 | - | 1485475200000 | - | D4 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | 2IN IRON POST | IS | 1485352440000 | TARAVAL ST | - | - | - | - | - | - |
| 22510 | N/A | Point | - | - | - | - | S232988 | TARAVAL ST: 42ND AVE | - | T | T | - | F | 23458000 | 23458000 | - | - | SOUTH SIDE | - | - | - | - | TARAVAL ST | 42ND AVE | 68506 | 68506 | 37.74195875 | -122.50033242 | 42ND AVE \ TARAVAL ST | TARAVAL ST \ 42ND AVE | 1740420639000 | middleware_editor | NPRK 7AM-8AM MON THUR STCL | 42ND AVE intersection | - | IFO#3231 | - | - | - | - | - | 39588 | - | -122.50033242 | 37.74195875 | - | 1736160600000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0212 | 18X18 | SUP2 | MUNI POLE | IS | 1485352740000 | TARAVAL ST | - | - | - | - | - | - |
| 22511 | N/A | Point | - | - | - | - | S232989 | TARAVAL ST: 42ND AVE | - | T | T | - | F | 23458000 | 23458000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 42ND AVE | 68507 | 68507 | 37.74195875 | -122.50033242 | 42ND AVE \ TARAVAL ST | TARAVAL ST \ 42ND AVE | 1740420644000 | middleware_editor | LEFT LANE TRAINS LEFT TURNS ONLY 24 HOURS | 42ND AVE intersection | - | - | - | - | - | - | - | 39589 | 1486216020000 | -122.50033242 | 37.74195875 | - | 1629244800000 | - | D4 | - | OTHER REGULATORY | REG | SR60-4(SF).0002 | 30X42 | SUP2 | MUNI POLE | IS | 1485352980000 | TARAVAL ST | - | - | - | - | - | - |
| 22512 | N/A | Point | - | - | - | - | S232991 | TARAVAL ST: 41ST AVE | - | T | T | - | F | 23444000 | 23444000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 41ST AVE | 41ST AVE | 68508 | 68508 | 37.7419397020881 | -122.499149214646 | TARAVAL ST \ 41ST AVE | TARAVAL ST \ 41ST AVE | 1740420641000 | middleware_editor | LEFT LANE TRAINS LEFT TURNS ONLY 24 HOURS | 41ST AVE intersection | - | - | - | - | - | - | - | 39590 | 1486216080000 | -122.49926207 | 37.74200717 | - | 1629244800000 | - | D4 | - | OTHER REGULATORY | REG | SR60-4(SF).0002 | 30X42 | SUP2 | MUNI POLE | IS | 1485353580000 | TARAVAL ST | - | - | - | - | - | - |
| 22513 | N/A | Point | - | - | - | - | S231718 | CLAY ST: LAUREL ST | - | F | F | - | F | 26921000 | 26921000 | - | - | NORTH WEST CORNER | - | - | - | - | LAUREL ST | CLAY ST | 68529 | 68529 | 37.7886987450017 | -122.450584396715 | CLAY ST \ LAUREL ST | LAUREL ST \ CLAY ST | 1734037802000 | middleware_editor | CLAY ST | CLAY ST intersection | - | 3500 | - | - | - | - | - | 39591 | 1484659320000 | -122.45048025 | 37.78864713 | - | 1484611200000 | - | D2 | - | STREET NAME | GUIDE | D3-1.0391 | 36X08 | SUP1 | 3IN IRON POST | IS | 1481545200000 | LAUREL ST | - | - | - | - | - | - |
| 22514 | N/A | Point | 1 | 1 | 1900 - 1998 | RIGHT ARROW | S228351 | 1900-1998 SAN JOSE AVE | 1900-1998 SAN JOSE AVE | F | F | - | F | 11452000 | 11452000 | - | - | WEST SIDE | - | - | - | - | HAVELOCK ST | HAVELOCK ST | 65573 | 65573 | 37.72627578 | -122.44198455 | - | - | 1714785042000 | middleware_editor | NPRK 8AM-10AM WED STCL | HAVELOCK ST to SANTA YNEZ AVE (1900 - 1998) | - | 45`SOUTH | - | - | - | - | - | 39592 | 1473427440000 | -122.44198455 | 37.72627578 | - | 1473379200000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP2 | MUNI POLE | IS | 1471959720000 | SAN JOSE AVE | 1900 - 1998 SAN JOSE AVE | 1900 - 1998 SAN JOSE AVE | 1900 SAN JOSE AVE | - | SANTA YNEZ AVE | SANTA YNEZ AVE |
| 22515 | N/A | Point | 1 | 1 | 300 - 399 | - | S228489 | 300-399 PARKER AVE | 300-399 PARKER AVE | F | F | - | F | 10276000 | 10276000 | - | - | EAST SIDE | - | - | - | - | ANZA ST | ANZA ST | 65574 | 65574 | 37.77964579 | -122.45378413 | - | - | 1730909837000 | middleware_editor | 4HR PRK 8AM-6PM MON-FRI EXC "L" PERMITS | ANZA ST to LONE MOUNTAIN TER (300 - 399) | - | OPP.# 355/BELOW ST.CL. MON.6-7AM SIGN | - | - | - | - | - | 39593 | 1472557200000 | -122.45378413 | 37.77964579 | - | 1730808780000 | - | D1 | - | PARKING:RPP | REG | R32C(CA).0234 | 18X21 | SUP2 | 2IN IRON POST | IS | 1472538060000 | PARKER AVE | 300 - 399 PARKER AVE | 300 - 399 PARKER AVE | 300 PARKER AVE | - | LONE MOUNTAIN TER | LONE MOUNTAIN TER |
| 22516 | N/A | Point | 1 | 1 | 31 - 99 | - | S228492 | 31-99 7TH ST | 31-99 07TH ST | F | F | - | F | 366001 | 366001 | - | - | EAST SIDE | - | - | - | - | ODD FELLOWS WAY \ STEVENSON ST | ODD FELLOWS WAY \ STEVENSON ST | 65575 | 65575 | 37.77960878 | -122.41143499 | - | - | 1752504763000 | middleware_editor | TANSAT | ODD FELLOWS WAY \ STEVENSON ST to MISSION ST (31 - 99) | - | 30' NORTH OF MISSION | - | - | - | - | - | 39594 | 1473351840000 | -122.41143499 | 37.77960878 | - | 1473318000000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1472548620000 | 07TH ST | 31 - 99 7TH ST | 31 - 99 07TH ST | 31 7TH ST | - | MISSION ST | MISSION ST |
| 22517 | N/A | Point | 1 | 1 | 1 - 79 | - | S228495 | 7-79 TAYLOR ST | 1-79 TAYLOR ST | F | F | - | F | 12425000 | 12425000 | - | - | WEST SIDE | - | - | - | - | 6TH ST \ GOLDEN GATE AVE \ MARKET ST | 06TH ST \ GOLDEN GATE AVE \ MARKET ST | 65576 | 65576 | 37.78251464 | -122.41057973 | - | - | 1739488439000 | middleware_editor | NPRK 6AM-8AM MON WED FRI SAT STCL | 06TH ST \ GOLDEN GATE AVE \ MARKET ST to OPAL PL (1 - 79) | - | 10' SOUTH OF #37 | - | - | - | - | - | 39595 | 1473934080000 | -122.41057973 | 37.78251464 | - | 1473897600000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0189 | 18X18 | SUP1 | LIGHT POLE | IS | 1472550180000 | TAYLOR ST | 1 - 79 TAYLOR ST | 1 - 79 TAYLOR ST | 1 TAYLOR ST | - | OPAL PL | OPAL PL |
| 22518 | N/A | Point | 1 | 1 | 200 - 299 | - | S228501 | 200-299 LEAVENWORTH ST | 200-299 LEAVENWORTH ST | F | F | - | F | 8240000 | 8240000 | - | - | EAST SIDE | - | - | - | - | TURK ST | TURK ST | 65577 | 65577 | 37.78325912 | -122.41414767 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM TUE THUR SUN STCL | TURK ST to EDDY ST (200 - 299) | - | NPL #222 / MOVE T0 NPL 240 | - | - | - | - | - | 39596 | 1173312000000 | -122.41414767 | 37.78325912 | - | 1472601600000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0196 | 18X18 | SUP1 | LIGHT POLE | IS | 1472551800000 | LEAVENWORTH ST | 200 - 299 LEAVENWORTH ST | 200 - 299 LEAVENWORTH ST | 200 LEAVENWORTH ST | - | EDDY ST | EDDY ST |
| 22519 | N/A | Point | - | - | - | - | S228505 | LARKIN ST: VALLEJO ST | - | F | F | - | F | 25312000 | 25312000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LARKIN ST | VALLEJO ST | 65578 | 65578 | 37.79710888 | -122.42031688 | VALLEJO ST \ LARKIN ST | LARKIN ST \ VALLEJO ST | 1710539427000 | MTA | NO TRUCKS (SYM) OVER 3 TONS | VALLEJO ST intersection | - | - | - | - | - | - | - | 39597 | 1472651040000 | -122.42031688 | 37.79710888 | - | 1472601600000 | - | D3 | - | OTHER REGULATORY | REG | R5-2.0005 | 30X30 | SUP1 | 2IN IRON POST | IS | 1472554380000 | LARKIN ST | - | - | - | - | - | - |
| 22520 | N/A | Point | - | - | - | - | S228506 | LARKIN ST: VALLEJO ST | - | F | F | - | F | 25312000 | 25312000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LARKIN ST | VALLEJO ST | 65579 | 65579 | 37.79710888 | -122.42031688 | VALLEJO ST \ LARKIN ST | LARKIN ST \ VALLEJO ST | 1710539427000 | MTA | TOUR BUSES & VANS (SEAT CAP 8 OR MORE PASSGRS) PROHIBITED | VALLEJO ST intersection | - | - | - | - | - | - | - | 39598 | - | -122.42031688 | 37.79710888 | - | - | - | D3 | - | OTHER REGULATORY | REG | R(SF).0272 | 36X30 | SUP1 | 2IN IRON POST | IS | 1472554500000 | LARKIN ST | - | - | - | - | - | - |
| 22521 | N/A | Point | - | - | - | - | S228509 | BAY ST: POLK ST | - | F | F | - | F | 26701000 | 26701000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BAY ST | POLK ST | 65580 | 65580 | 37.80435493 | -122.42346605 | POLK ST \ BAY ST | BAY ST \ POLK ST | 1710539427000 | MTA | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EX SAT & SUN | POLK ST intersection | - | - | - | - | - | - | - | 39599 | 1473160260000 | -122.42346605 | 37.80435493 | - | 1658361600000 | - | D2 | - | NO LEFT TURN | REG | R33A(CA).0026 | 30X42 | SUP1 | 2IN IRON POST | IS | 1472556660000 | BAY ST | - | - | - | - | - | - |
| 22522 | N/A | Point | - | - | - | - | S228617 | DARIEN WAY: MANOR DR | - | F | F | - | F | 22684000 | 22684000 | - | - | SOUTH EAST CORNER | - | - | - | - | MANOR DR | MANOR DR | 65581 | 65581 | 37.72989829 | -122.46341784 | DARIEN WAY \ MANOR DR | DARIEN WAY \ MANOR DR | 1710539427000 | MTA | MANOR DR | MANOR DR intersection | - | - | - | - | - | - | - | 39600 | 1473954120000 | -122.46341784 | 37.72989829 | - | 1473897600000 | - | D7 | - | STREET NAME | GUIDE | D3-1.1109 | 36X08 | SUP2 | 3IN IRON POST | IS | 1472807340000 | DARIEN WAY | - | - | - | - | - | - |
| 22523 | N/A | Point | 1 | 1 | 1 - 299 | - | S228620 | 1-299 DALEWOOD WAY | 1-299 DALEWOOD WAY | F | F | - | F | 4577000 | 4577000 | - | - | NORTH SIDE | - | - | - | - | LANSDALE AVE \ MYRA WAY \ SHERWOOD CT | LANSDALE AVE \ MYRA WAY \ SHERWOOD CT | 65582 | 65582 | 37.73781701 | -122.45658458 | - | - | 1710539427000 | MTA | CITY PROPERTY NO DUMPING POLICE CODE 33 NPRK | LANSDALE AVE \ MYRA WAY \ SHERWOOD CT to LANSDALE AVE \ LUDLOW ALY (1 - 299) | - | E-LINE OF ENTRANCE TO MT DAVIDSON PARK | - | - | - | - | - | 39601 | - | -122.45658458 | 37.73781701 | - | - | - | D7 | - | PARKING | REG | R(SF).0033 | 30X24 | SUP2 | 2IN IRON POST | IS | 1472808900000 | DALEWOOD WAY | 1 - 299 DALEWOOD WAY | 1 - 299 DALEWOOD WAY | 1 DALEWOOD WAY | - | LANSDALE AVE \ LUDLOW ALY | LANSDALE AVE \ LUDLOW ALY |
| 22524 | N/A | Point | - | - | - | - | S229960 | 40TH AVE: RIVERA ST | - | F | F | - | F | 23469000 | 23469000 | - | - | NORTH WEST CORNER | - | - | - | - | RIVERA ST | 40TH AVE | 65583 | 65583 | 37.74578604 | -122.49845283 | 40TH AVE \ RIVERA ST | RIVERA ST \ 40TH AVE | 1710539427000 | MTA | RIVERA ST | 40TH AVE intersection | - | - | - | - | - | - | - | 39602 | 1479815820000 | -122.49845283 | 37.74578604 | - | 1479772800000 | - | D4 | - | STREET NAME | GUIDE | D3-1.1490 | 36X08 | SUP2 | 3IN IRON POST | IS | 1476884460000 | RIVERA ST | - | - | - | - | - | - |
| 22525 | N/A | Point | 1 | 1 | 100 - 199 | - | S230092 | 100-199 SHANNON ST | 100-199 SHANNON ST | F | F | - | F | 11794000 | 11794000 | - | - | WEST SIDE | - | - | - | - | GEARY ST | GEARY ST | 65584 | 65584 | 37.78730066 | -122.41243575 | - | - | 1710539427000 | MTA | TANP ANY TIME | GEARY ST to POST ST (100 - 199) | - | 21' SOUTH OF POST ST | - | - | - | - | - | 39603 | 1478000220000 | -122.41243575 | 37.78730066 | - | 1477958400000 | - | D3 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0037 | 14X21 | SUP1 | 2IN IRON POST | IS | 1477301940000 | SHANNON ST | 100 - 199 SHANNON ST | 100 - 199 SHANNON ST | 100 SHANNON ST | - | POST ST | POST ST |
| 22526 | N/A | Point | - | - | - | - | S230461 | HAMILTON ST: DWIGHT ST | - | F | F | - | F | 20867000 | 20867000 | - | - | NORTH EAST CORNER | - | - | - | - | DWIGHT ST | DWIGHT ST | 65585 | 65585 | 37.7224851 | -122.40803412 | HAMILTON ST \ DWIGHT ST | HAMILTON ST \ DWIGHT ST | 1754682876000 | middleware_editor | ALL WAY | DWIGHT ST intersection | - | OF HAMILTON & DWIGHT BELOW STOP SIGN | - | - | - | - | - | 39604 | 1494108000000 | -122.40803412 | 37.7224851 | - | 1494054000000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477913280000 | HAMILTON ST | - | - | - | - | - | - |
| 22527 | N/A | Point | - | - | - | - | S230587 | HUNTERS POINT EXPY: CANDLESTIC | - | F | F | - | F | 33646000 | 33646000 | - | - | SOUTH SIDE | - | - | - | - | UNNAMED #047 | UNNAMED #047 | 65586 | 65586 | 37.71271765 | -122.3815908 | CANDLESTICK POINT SRA \ UNNAMED #047 | CANDLESTICK POINT SRA \ UNNAMED #047 | 1710539427000 | MTA | (90 RA) CURVE (SYM)/20 MPH | UNNAMED #047 intersection | - | 100' WEST OF JAMESTOWN | - | - | - | - | - | 39605 | - | -122.3815908 | 37.71271765 | - | - | - | D10 | - | SPEED LIMIT | WARNING | W1-1A.0021 | 36X36 | SUP1 | LIGHT POLE | IS | 1478080380000 | CANDLESTICK POINT SRA | - | - | - | - | - | - |
| 22528 | N/A | Point | - | - | - | - | S230596 | HUNTERS POINT EXPY: CANDLESTIC | - | F | F | - | F | 33646000 | 33646000 | - | - | NORTH SIDE | - | - | - | - | UNNAMED #047 | UNNAMED #047 | 65588 | 65588 | 37.71271765 | -122.3815908 | CANDLESTICK POINT SRA \ UNNAMED #047 | CANDLESTICK POINT SRA \ UNNAMED #047 | 1710539427000 | MTA | AHEAD | UNNAMED #047 intersection | - | 400' EAST OF EXECUYIVE | - | - | - | - | - | 39606 | - | -122.3815908 | 37.71271765 | - | - | - | D10 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP1 | 3IN IRON POST | IS | 1478082360000 | CANDLESTICK POINT SRA | - | - | - | - | - | - |
| 22529 | N/A | Point | - | - | - | - | S230972 | THE EMBARCADERO: KING ST \ TOW | - | T | T | - | F | 23592000 | 23592000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | THE EMBARCADERO \ TOWNSEND ST | THE EMBARCADERO \ TOWNSEND ST | 65589 | 65589 | 37.78179824 | -122.38830607 | KING ST \ THE EMBARCADERO \ TOWNSEND ST | THE EMBARCADERO \ TOWNSEND ST intersection | 1710539427000 | MTA | TSUNAMI EVACUATION ROUTE | THE EMBARCADERO \ TOWNSEND ST intersection | - | - | - | - | - | - | - | 39607 | 1333411200000 | -122.38830607 | 37.78179824 | - | - | - | D6 | - | OTHER GUIDE | GUIDE | G-T(SF).0034 | 24X24 | SUP1 | SIGNAL POLE | IS | 1479202380000 | KING ST | - | - | - | - | - | - |
| 22530 | N/A | Point | - | - | - | - | S230973 | VICENTE ST: 14TH AVE | - | F | F | - | F | 22949000 | 22949000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 14TH AVE | 14TH AVE | 65590 | 65590 | 37.73956433 | -122.4699752 | VICENTE ST \ 14TH AVE | VICENTE ST \ 14TH AVE | 1731083198000 | middleware_editor | ALL WAY | 14TH AVE intersection | - | 00 / 00 | - | - | - | - | - | 39608 | -403660800000 | -122.4699752 | 37.73956433 | - | 1483660800000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479202380000 | VICENTE ST | - | - | - | - | - | - |
| 22531 | N/A | Point | - | - | - | - | S236609 | 3RD ST: HARRISON ST | - | T | T | - | F | 24513000 | 24513000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 3RD ST | 03RD ST | 74200 | 74200 | 37.78255359 | -122.39738554 | HARRISON ST \ 3RD ST | HARRISON ST \ 03RD ST | 1710539427000 | MTA | 3RD ST CLOSED AT HOWARD USE VAN NESS OR EMBARCADERO(DATES) | 03RD ST intersection | - | - | - | - | - | - | - | 39609 | 1466380800000 | -122.39738554 | 37.78255359 | - | 1529452800000 | - | D6 | - | OTHER GUIDE | GUIDE | G-X(SF).0044 | 48X48 | SUP1 | MUNI POLE | IS | 1496479920000 | HARRISON ST | - | - | - | - | - | - |
| 22532 | N/A | Point | - | - | - | - | S236611 | 3RD ST: HARRISON ST | - | T | T | - | F | 24513000 | 24513000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 3RD ST | 03RD ST | 74201 | 74201 | 37.78255359 | -122.39738554 | HARRISON ST \ 3RD ST | HARRISON ST \ 03RD ST | 1710539427000 | MTA | 3RD ST CLOSED AT HOWARD USE VAN NESS OR EMBARCADERO(DATES) | 03RD ST intersection | - | 2FT NORTH | - | - | - | - | - | 39610 | 1466380800000 | -122.39738554 | 37.78255359 | - | 1466380800000 | - | D6 | - | OTHER GUIDE | GUIDE | G-X(SF).0044 | 48X48 | SUP1 | MUNI POLE | IS | 1496480100000 | HARRISON ST | - | - | - | - | - | - |
| 22533 | N/A | Point | 1 | 1 | 35 - 99 | LEFT ARROW | S239538 | 35-99 MISSION ST | 35-99 MISSION ST | F | F | - | F | 9083000 | 9083000 | - | - | NORTH SIDE | - | - | - | - | STEUART ST | STEUART ST | 74204 | 74204 | 37.79288386 | -122.39362048 | - | - | 1710539427000 | MTA | TANS 3PM-7PM MON-FRI EXC MUNI | STEUART ST to SPEAR ST (35 - 99) | - | 85' WEST OF STEUART ST | - | - | - | - | - | 39611 | 1455148800000 | -122.39362048 | 37.79288386 | - | 1455148800000 | - | D6 | - | OTHER REGULATORY | REG | R37(SF).0317 | 14X21 | SUP1 | 2IN IRON POST | IS | 1508237220000 | MISSION ST | 35 - 99 MISSION ST | 35 - 99 MISSION ST | 35 MISSION ST | - | SPEAR ST | SPEAR ST |
| 22534 | N/A | Point | 1 | 1 | 35 - 99 | - | S239541 | 35-99 MISSION ST | 35-99 MISSION ST | F | F | - | F | 9083000 | 9083000 | - | - | NORTH SIDE | - | - | - | - | STEUART ST | STEUART ST | 74205 | 74205 | 37.79288386 | -122.39362048 | - | - | 1710539427000 | MTA | TANS 3PM-7PM MON-FRI EXC MUNI | STEUART ST to SPEAR ST (35 - 99) | - | 18' EAST OF SPEAR ST | - | - | - | - | - | 39612 | 1455148800000 | -122.39362048 | 37.79288386 | - | 1602201600000 | - | D6 | - | OTHER REGULATORY | REG | R37(SF).0317 | 14X21 | SUP1 | 2IN IRON POST | IS | 1508237400000 | MISSION ST | 35 - 99 MISSION ST | 35 - 99 MISSION ST | 35 MISSION ST | - | SPEAR ST | SPEAR ST |
| 22535 | N/A | Point | - | - | - | - | S239544 | MISSION ST: SPEAR ST | - | F | F | - | F | 24555000 | 24555000 | - | - | NORTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 74206 | 74206 | 37.79253722 | -122.39405962 | SPEAR ST \ MISSION ST | SPEAR ST \ MISSION ST | 1710539427000 | MTA | TANS 3PM-7PM MON-FRI EXC MUNI | MISSION ST intersection | - | 16FT EAT OF SPEAR | - | - | - | - | - | 39613 | 1455148800000 | -122.39405962 | 37.79253722 | - | 1508803200000 | - | D6 | - | OTHER REGULATORY | REG | R37(SF).0317 | 14X21 | SUP1 | 2IN FLANGE POST | IS | 1508237760000 | SPEAR ST | - | - | - | - | - | - |
| 22536 | N/A | Point | 1 | 1 | 1300 - 1399 | RIGHT ARROW | S239553 | 1300-1399 TURK ST | 1300-1399 TURK ST | F | F | - | F | 12728000 | 12728000 | - | - | SOUTH SIDE | - | - | - | - | WEBSTER ST | WEBSTER ST | 74209 | 74209 | 37.78060592 | -122.4312824 | - | - | 1710539427000 | MTA | NPRK ANY TIME | WEBSTER ST to FILLMORE ST (1300 - 1399) | - | IFO#1251 (E-TIP OF NEW RED ZONE) | - | - | - | - | - | 39614 | 1509031320000 | -122.4312824 | 37.78060592 | - | 1508976000000 | - | D5 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0002 | 18X18 | SUP1 | 2IN IRON POST | IS | 1508246220000 | TURK ST | 1300 - 1399 TURK ST | 1300 - 1399 TURK ST | 1300 TURK ST | - | FILLMORE ST | FILLMORE ST |
| 22537 | N/A | Point | - | - | - | - | S242456 | STILLMAN ST: 3RD ST | - | F | F | - | F | 23838000 | 23838000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | STILLMAN ST | 03RD ST | 74210 | 74210 | 37.78175028 | -122.39637952 | 3RD ST \ STILLMAN ST | STILLMAN ST \ 03RD ST | 1710539427000 | MTA | DO NOT ENTER | 03RD ST intersection | - | - | - | - | - | - | - | 39615 | -289180800000 | -122.39637952 | 37.78175028 | - | 1516838400000 | - | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1516634940000 | STILLMAN ST | - | - | - | - | - | - |
| 22538 | N/A | Point | - | - | - | LEFT ARROW | S242654 | FOLSOM ST: 14TH ST | - | F | F | - | F | 24336000 | 24336000 | - | - | NORTH EAST CORNER | - | - | - | - | 14TH ST | FOLSOM ST | 74211 | 74211 | 37.76853739 | -122.41561378 | FOLSOM ST \ 14TH ST | 14TH ST \ FOLSOM ST | 1724202545000 | middleware_editor | TANS EXC 30 MIN 6 WHEEL TL 7AM-3PM MON-FRI | FOLSOM ST intersection | - | - | - | - | - | - | - | 39616 | 1518690000000 | -122.41561378 | 37.76853739 | - | 1518652800000 | - | D9 | - | OTHER REGULATORY | REG | R37(SF).0144 | 10X15 | SUP2 | SIGNAL POLE | IS | 1517312460000 | 14TH ST | - | - | - | - | - | - |
| 22539 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S245376 | 2300-2399 BAKER ST | 2300-2399 BAKER ST | F | F | - | F | 2626000 | 2626000 | - | - | WEST SIDE | - | - | - | - | PACIFIC AVE | PACIFIC AVE | 74284 | 74284 | 37.79255113 | -122.44474957 | - | - | 1710539427000 | MTA | NPRK ANY TIME | PACIFIC AVE to BROADWAY (2300 - 2399) | - | 130' N OF PACIFIC | - | - | - | - | - | 39617 | 1525778460000 | -122.44474957 | 37.79255113 | - | - | - | D2 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | LIGHT POLE | IS | 1525698180000 | BAKER ST | 2300 - 2399 BAKER ST | 2300 - 2399 BAKER ST | 2300 BAKER ST | - | BROADWAY | BROADWAY |
| 22540 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S245377 | 2300-2399 BAKER ST | 2300-2399 BAKER ST | F | F | - | F | 2626000 | 2626000 | - | - | WEST SIDE | - | - | - | - | PACIFIC AVE | PACIFIC AVE | 74285 | 74285 | 37.79255113 | -122.44474957 | - | - | 1710539427000 | MTA | NPRK ANY TIME | PACIFIC AVE to BROADWAY (2300 - 2399) | - | 5' S OF BROADWAY | - | - | - | - | - | 39618 | - | -122.44474957 | 37.79255113 | - | - | - | D2 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | LIGHT POLE | IS | 1525698240000 | BAKER ST | 2300 - 2399 BAKER ST | 2300 - 2399 BAKER ST | 2300 BAKER ST | - | BROADWAY | BROADWAY |
| 22541 | N/A | Point | - | - | - | - | S245674 | JONES ST: PACIFIC AVE | - | T | T | - | F | 25132000 | 25132000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | JONES ST | PACIFIC AVE | 74286 | 74286 | 37.79587732 | -122.41500546 | PACIFIC AVE \ JONES ST | JONES ST \ PACIFIC AVE | 1710539427000 | MTA | NO TRUCKS (SYM) OVER 3 TONS | PACIFIC AVE intersection | - | - | - | - | - | - | - | 39619 | 1275609600000 | -122.41500546 | 37.79587732 | - | 1536883200000 | - | D3 | - | OTHER REGULATORY | REG | R5-2.0006 | 30X36 | SUP1 | LIGHT POLE | IS | 1526900580000 | JONES ST | - | - | - | - | - | - |
| 22542 | N/A | Point | 1 | 1 | 600 - 699 | RIGHT ARROW | S237626 | 600-699 9TH ST | 600-699 09TH ST | F | F | - | F | 460000 | 460000 | - | - | EAST SIDE | - | - | - | - | BRANNAN ST | BRANNAN ST | 74370 | 74370 | 37.76975616 | -122.40660743 | - | - | 1730928553000 | middleware_editor | TA (SYM) PLO 7AM-7PM MON-FRI (5 MIN) | BRANNAN ST to DIVISION ST (600 - 699) | - | 10`SOUTH | - | - | - | - | - | 39620 | 1500997320000 | -122.40660743 | 37.76975616 | - | - | 1730881800000 | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0102 | 14X21 | SUP1 | 2IN IRON POST | RETD | 1500540600000 | 09TH ST | 600 - 699 9TH ST | 600 - 699 09TH ST | 600 9TH ST | - | DIVISION ST | DIVISION ST |
| 22543 | N/A | Point | 1 | 1 | 600 - 699 | LEFT ARROW | S237627 | 600-699 9TH ST | 600-699 09TH ST | F | F | - | F | 460000 | 460000 | - | - | EAST SIDE | - | - | - | - | BRANNAN ST | BRANNAN ST | 74371 | 74371 | 37.76975616 | -122.40660743 | - | - | 1730928674000 | middleware_editor | TA (SYM) PLO 7AM-7PM MON-FRI (5 MIN) | BRANNAN ST to DIVISION ST (600 - 699) | - | 50`SOUTH | - | - | - | - | - | 39621 | 1500997500000 | -122.40660743 | 37.76975616 | - | - | 1730883600000 | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0102 | 14X21 | SUP1 | 2IN IRON POST | RETD | 1500540780000 | 09TH ST | 600 - 699 9TH ST | 600 - 699 09TH ST | 600 9TH ST | - | DIVISION ST | DIVISION ST |
| 22544 | N/A | Point | 1 | 1 | 750 - 823 | - | S241364 | 750-823 STANYAN ST | 750-823 STANYAN ST | T | T | - | F | 12092000 | 12092000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | WALLER ST | WALLER ST | 74372 | 74372 | 37.76777646 | -122.45325854 | - | - | 1710539427000 | MTA | 49 MILE SCENIC DRIVE ARROW (VA) | WALLER ST to BEULAH ST (750 - 823) | 85 | 160' SOUTH OF WALLER ST | - | - | - | - | - | 39622 | 1583452800000 | -122.45325854 | 37.76777646 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-X(SF).0046 | 18X18 | SUP1 | LIGHT POLE | IS | 1512730740000 | STANYAN ST | 750 - 823 STANYAN ST | 750 - 823 STANYAN ST | 750 STANYAN ST | - | BEULAH ST | BEULAH ST |
| 22545 | N/A | Point | - | - | - | - | S240954 | WEST PORTAL AVE: VICENTE ST | - | F | F | - | F | 22927000 | 22927000 | - | - | NORTH WEST CORNER | - | - | - | - | WEST PORTAL AVE | VICENTE ST | 75851 | 75851 | 37.7397235 | -122.46699101 | VICENTE ST \ WEST PORTAL AVE | WEST PORTAL AVE \ VICENTE ST | 1710539427000 | MTA | PREVENT THEFT REMOVE VALUABLES LOCK YOUR CAR | VICENTE ST intersection | - | AT 174 PARKING LOT ( ANGLE OUT) | - | - | - | - | - | 39623 | 1512567000000 | -122.46699101 | 37.7397235 | - | 1512518400000 | - | D7 | - | OTHER REGULATORY | REG | SR(SF).0052 | 18X21 | SUP2 | LIGHT POLE | IS | 1511950260000 | WEST PORTAL AVE | - | - | - | - | - | - |
| 22546 | N/A | Point | - | - | - | - | S246637 | 2701-2899 ALEMANY BLVD | - | T | T | - | F | 2175000 | - | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | - | - | 75855 | 75855 | 37.713506 | -122.449851 | - | - | 1734717382000 | middleware_editor | SPEED LIMIT 35 | - | - | 200 FT SOUTH OF NAGLEE | - | - | - | - | - | 39624 | 1485388800000 | -122.449851 | 37.713506 | - | - | 1734612540000 | D11 | - | SPEED LIMIT | REG | R2-1.0010 | 36X45 | SUP2 | LIGHT POLE | RETD | 1530182280000 | - | 2701-2899 ALEMANY BLVD | - | - | - | - | - |
| 22547 | N/A | Point | - | - | - | - | S236435 | IRVING ST: 45TH AVE | - | F | F | - | F | 27948000 | 27948000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 45TH AVE | 45TH AVE | 75860 | 75860 | 37.762265255 | -122.505092919 | IRVING ST \ 45TH AVE | IRVING ST \ 45TH AVE | 1755789237000 | middleware_editor | STOP | 45TH AVE intersection | - | - | - | - | - | - | - | 39625 | 1502304540000 | -122.50498766 | 37.7623324 | - | 1502262000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1495793460000 | IRVING ST | - | - | - | - | - | - |
| 22548 | N/A | Point | - | - | - | - | S236439 | IRVING ST: 45TH AVE | - | F | F | - | F | 27948000 | 27948000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 45TH AVE | 45TH AVE | 75861 | 75861 | 37.7624126259579 | -122.504889070983 | IRVING ST \ 45TH AVE | IRVING ST \ 45TH AVE | 1755789232000 | middleware_editor | ALL WAY | 45TH AVE intersection | - | 11' EAST OF 45TH AVE | - | - | - | - | - | 39626 | 1502304660000 | -122.50498766 | 37.7623324 | - | 1502262000000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1495793820000 | IRVING ST | - | - | - | - | - | - |
| 22549 | N/A | Point | - | - | - | - | S236440 | 45TH AVE: IRVING ST | - | F | F | - | F | 27948000 | 27948000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 45TH AVE | 45TH AVE | 75862 | 75862 | 37.7622371594302 | -122.504915893073 | IRVING ST \ 45TH AVE | IRVING ST \ 45TH AVE | 1755789230000 | middleware_editor | ALL WAY | 45TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 39627 | 82710000000 | -122.50498766 | 37.7623324 | - | 1502262000000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1495793880000 | IRVING ST | - | - | - | - | - | - |
| 22550 | N/A | Point | - | - | - | - | S236450 | IRVING ST: 23RD AVE | - | F | F | - | F | 27418000 | 27418000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 23RD AVE | IRVING ST | 75863 | 75863 | 37.76337309 | -122.48140884 | IRVING ST \ 23RD AVE | 23RD AVE \ IRVING ST | 1710539427000 | MTA | NO LITTERING (SYM)-IT SHALL BE UNLAWFUL¿ | IRVING ST intersection | - | IFO#2237 | - | - | - | - | - | 39628 | - | -122.48140884 | 37.76337309 | - | - | - | D4 | - | OTHER REGULATORY | REG | SR(SF).0035 | 18X24 | SUP2 | LIGHT POLE | IS | 1495803720000 | 23RD AVE | - | - | - | - | - | - |
| 22551 | N/A | Point | - | - | - | - | S236749 | MIGUEL ST: ARLINGTON ST | - | F | F | - | F | 21855000 | 21855000 | - | - | NORTH WEST CORNER | - | - | - | - | MIGUEL ST | ARLINGTON ST | 75864 | 75864 | 37.73668495 | -122.42715551 | ARLINGTON ST \ MIGUEL ST | MIGUEL ST \ ARLINGTON ST | 1716472087000 | middleware_editor | MIGUEL ST | ARLINGTON ST intersection | - | 400 (@ARLINGTON) | - | - | - | - | - | 39629 | 1509023040000 | -122.42715551 | 37.73668495 | - | 1638748800000 | - | D8 | - | STREET NAME | GUIDE | D3-1.1185 | 36X08 | SUP2 | 3IN IRON POST | IS | 1497000840000 | MIGUEL ST | - | - | - | - | - | - |
| 22552 | N/A | Point | - | - | - | - | S236751 | ARLINGTON ST: MIGUEL ST | - | F | F | - | F | 21855000 | 21855000 | - | - | NORTH WEST CORNER | - | - | - | - | MIGUEL ST | ARLINGTON ST | 75865 | 75865 | 37.73668495 | -122.42715551 | ARLINGTON ST \ MIGUEL ST | MIGUEL ST \ ARLINGTON ST | 1716472090000 | middleware_editor | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | ARLINGTON ST intersection | - | 300 (@MIGUEL) | - | - | - | - | - | 39630 | 1509022860000 | -122.42715551 | 37.73668495 | - | 1508976000000 | - | D8 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | 3IN IRON POST | IS | 1497001020000 | MIGUEL ST | - | - | - | - | - | - |
| 22553 | N/A | Point | 1 | 1 | 400 - 499 | - | S236779 | 400-499 SHOTWELL ST | 400-499 SHOTWELL ST | F | F | - | F | 11836000 | 11836000 | - | - | EAST SIDE | - | - | - | - | 18TH ST | 18TH ST | 75866 | 75866 | 37.76123364 | -122.41600337 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM THUR STCL | 18TH ST to 19TH ST (400 - 499) | - | 65' NORTH OF 19TH ST | - | - | - | - | - | 39631 | - | -122.41600337 | 37.76123364 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0080 | 18X18 | SUP2 | 2IN IRON POST | IS | 1497015360000 | SHOTWELL ST | 400 - 499 SHOTWELL ST | 400 - 499 SHOTWELL ST | 400 SHOTWELL ST | - | 19TH ST | 19TH ST |
| 22554 | N/A | Point | 1 | 1 | 200 - 299 | - | S236781 | 200-299 SHOTWELL ST | 200-299 SHOTWELL ST | F | F | - | F | 11834000 | 11834000 | - | - | WEST SIDE | - | - | - | - | 16TH ST | 16TH ST | 75867 | 75867 | 37.76444232 | -122.4163074 | - | - | 1755720535000 | middleware_editor | NPRK 8AM-10AM TUE FRI STCL | 16TH ST to 17TH ST (200 - 299) | - | 77' SOUTH OF 16TH ST | - | - | - | - | - | 39632 | 1415001600000 | -122.4163074 | 37.76444232 | - | 1415001600000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0268 | 18X18 | SUP2 | 2IN IRON POST | IS | 1497016560000 | SHOTWELL ST | 200 - 299 SHOTWELL ST | 200 - 299 SHOTWELL ST | 200 SHOTWELL ST | - | 17TH ST | 17TH ST |
| 22555 | N/A | Point | 1 | 1 | 100 - 199 | LEFT ARROW | S242301 | 100-199 OTIS ST | 100-199 OTIS ST | F | F | - | F | 10048000 | 10048000 | - | - | WEST SIDE | - | - | - | - | GOUGH ST \ MCCOPPIN ST | GOUGH ST \ MCCOPPIN ST | 75876 | 75876 | 37.77092026 | -122.42022847 | - | - | 1710539427000 | MTA | TANSAT | GOUGH ST \ MCCOPPIN ST to 13TH ST \ DUBOCE AVE \ HWY 101 NORTHBOUND RAMP \ MISSION ST (100 - 199) | - | 75' N OF DUBOCE | - | - | - | - | - | 39633 | 1516887480000 | -122.42022847 | 37.77092026 | - | 1516838400000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1516108980000 | OTIS ST | 100 - 199 OTIS ST | 100 - 199 OTIS ST | 100 OTIS ST | - | 13TH ST \ DUBOCE AVE \ HWY 101 NORTHBOUND RAMP \ MISSION ST | 13TH ST \ DUBOCE AVE \ HWY 101 NORTHBOUND RAMP \ MISSION ST |
| 22556 | N/A | Point | - | - | - | - | S242722 | BRIDGEVIEW WAY: MISSION BAY BL | - | F | F | - | F | 34185000 | 34185000 | - | - | NORTH WEST CORNER | - | - | - | - | BRIDGEVIEW WAY \ MISSION BAY BLVD | BRIDGEVIEW WAY \ MISSION BAY BLVD \ VARA ST | 75879 | 75879 | 37.77076204 | -122.38773465 | VARA ST \ BRIDGEVIEW WAY \ MISSION BAY BLVD | MISSION BAY BLVD SOUTH \ BRIDGEVIEW WAY \ MISSION BAY BLVD \ VARA ST | 1710539427000 | MTA | BRIDGEVIEW WAY | BRIDGEVIEW WAY \ MISSION BAY BLVD \ VARA ST intersection | - | PRIVATE (MISSION BAY NORTH) | - | - | - | - | - | 39634 | 1523373240000 | -122.38773465 | 37.77076204 | - | 1677456000000 | - | D6 | - | STREET NAME | GUIDE | D3-1.1930 | 36X08 | SUP1 | LIGHT POLE | IS | 1517486100000 | MISSION BAY BLVD SOUTH | - | - | - | - | - | - |
| 22557 | N/A | Point | - | - | - | - | S242724 | 3RD ST: NELSON RISING LN | - | F | F | - | F | 54090000 | 54090000 | - | - | NORTH WEST CORNER | - | - | - | - | 3RD ST | 03RD ST | 75881 | 75881 | 37.76975714 | -122.38946669 | NELSON RISING LN \ 3RD ST | NELSON RISING LN \ 03RD ST | 1710539427000 | MTA | NELSON RISING LN | 03RD ST intersection | - | PRIVATE | - | - | - | - | - | 39635 | 1410134400000 | -122.38946669 | 37.76975714 | - | 1521590400000 | - | D6 | - | STREET NAME | GUIDE | D3-1.1265 | 36X08 | SUP1 | LIGHT POLE | IS | 1517488080000 | NELSON RISING LN | - | - | - | - | - | - |
| 22558 | N/A | Point | 1 | 1 | 1800 - 1899 | RIGHT ARROW | S250660 | 1800-1899 EGBERT AVE | 1800-1899 EGBERT AVE | F | F | - | F | 5118000 | 5118000 | - | - | NORTH SIDE | - | - | - | - | NEWHALL ST | NEWHALL ST | 77012 | 77012 | 37.72728431 | -122.40066462 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM DAILY | NEWHALL ST to PHELPS ST (1800 - 1899) | - | 265' WEST OF EAST TERMINUS | - | - | - | - | - | 39636 | 1050451200000 | -122.40066462 | 37.72728431 | - | 1550707200000 | - | D10 | - | PARKING | REG | R30(CA).0045 | 18X18 | SUP1 | 2IN IRON POST | IS | 1546957080000 | EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 EGBERT AVE | - | PHELPS ST | PHELPS ST |
| 22559 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S250661 | 1800-1899 EGBERT AVE | 1800-1899 EGBERT AVE | F | F | - | F | 5118000 | 5118000 | - | - | NORTH SIDE | - | - | - | - | NEWHALL ST | NEWHALL ST | 77013 | 77013 | 37.72728431 | -122.40066462 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | NEWHALL ST to PHELPS ST (1800 - 1899) | - | 265' WEST OF EAST TERMINUS | - | - | - | - | - | 39637 | 1050451200000 | -122.40066462 | 37.72728431 | - | 1550707200000 | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | 2IN IRON POST | IS | 1546957200000 | EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 EGBERT AVE | - | PHELPS ST | PHELPS ST |
| 22560 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S250664 | 1800-1899 EGBERT AVE | 1800-1899 EGBERT AVE | F | F | - | F | 5118000 | 5118000 | - | - | NORTH SIDE | - | - | - | - | NEWHALL ST | NEWHALL ST | 77014 | 77014 | 37.72728431 | -122.40066462 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM DAILY | NEWHALL ST to PHELPS ST (1800 - 1899) | - | 155' WEST OF EAST TERMINUS | - | - | - | - | - | 39638 | 1050451200000 | -122.40066462 | 37.72728431 | - | 1550707200000 | - | D10 | - | PARKING | REG | R30(CA).0045 | 18X18 | SUP1 | 2IN IRON POST | IS | 1546957440000 | EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 EGBERT AVE | - | PHELPS ST | PHELPS ST |
| 22561 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S250665 | 1800-1899 EGBERT AVE | 1800-1899 EGBERT AVE | F | F | - | F | 5118000 | 5118000 | - | - | NORTH SIDE | - | - | - | - | NEWHALL ST | NEWHALL ST | 77015 | 77015 | 37.72728431 | -122.40066462 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM DAILY | NEWHALL ST to PHELPS ST (1800 - 1899) | - | 50' WEST OF EAST TERMINUS | - | - | - | - | - | 39639 | 1050451200000 | -122.40066462 | 37.72728431 | - | 1550707200000 | - | D10 | - | PARKING | REG | R30(CA).0045 | 18X18 | SUP1 | 2IN IRON POST | IS | 1546957440000 | EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 EGBERT AVE | - | PHELPS ST | PHELPS ST |
| 22562 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S250670 | 1800-1899 EGBERT AVE | 1800-1899 EGBERT AVE | F | F | - | F | 5118000 | 5118000 | - | - | SOUTH SIDE | - | - | - | - | NEWHALL ST | NEWHALL ST | 77016 | 77016 | 37.72728431 | -122.40066462 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM DAILY | NEWHALL ST to PHELPS ST (1800 - 1899) | - | 350' EAST OF NEWHALL ST. | - | - | - | - | - | 39640 | 1050451200000 | -122.40066462 | 37.72728431 | - | - | - | D10 | - | PARKING | REG | R30(CA).0045 | 18X18 | SUP1 | 2IN IRON POST | IS | 1546959060000 | EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 EGBERT AVE | - | PHELPS ST | PHELPS ST |
| 22563 | N/A | Point | - | 1 | 300 - 399 | - | S117834 | 300-399 SAINT CHARLES AVE | 300-399 SAINT CHARLES AVE | F | F | - | F | 11291000 | 11291000 | - | - | EAST SIDE | - | - | - | - | BELLE AVE \ NIANTIC AVE | BELLE AVE \ NIANTIC AVE | 77019 | 77019 | 37.70842096 | -122.46918875 | - | - | 1710539427000 | MTA | TANSAT | BELLE AVE \ NIANTIC AVE to COUNTY LINE (300 - 399) | - | OPP.N-LINE OF PARKING GARAGE | - | - | - | - | - | 39641 | 1066348800000 | -122.46918875 | 37.70842096 | - | - | - | D7 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | 2IN IRON POST | IS | 1373573100000 | SAINT CHARLES AVE | 300 - 399 SAINT CHARLES AVE | 300 - 399 SAINT CHARLES AVE | 300 SAINT CHARLES AVE | - | COUNTY LINE | COUNTY LINE |
| 22564 | N/A | Point | 1 | 1 | 2100 - 2550 | - | S117875 | 1900-2550 CESAR CHAVEZ ST | 2100-2550 CESAR CHAVEZ ST | F | F | - | F | 2477000 | 2477000 | - | - | SOUTH SIDE | - | - | - | - | EVANS AVE | EVANS AVE | 77020 | 77020 | 37.74954065 | -122.39967353 | - | - | 1710539427000 | MTA | TANP ANY TIME | EVANS AVE to KANSAS ST (2100 - 2550) | - | 545' EAST OF KANSAS @ PM | - | - | - | - | - | 39642 | 1067299200000 | -122.39967353 | 37.74954065 | - | - | - | D10 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373573100000 | CESAR CHAVEZ ST | 2100 - 2550 CESAR CHAVEZ ST | 2100 - 2550 CESAR CHAVEZ ST | 2100 CESAR CHAVEZ ST | - | KANSAS ST | KANSAS ST |
| 22565 | N/A | Point | - | - | - | - | S117907 | 26TH ST: CHURCH ST | - | F | F | - | F | 21917000 | 21917000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CHURCH ST | CHURCH ST | 77021 | 77021 | 37.74849583 | -122.42712276 | 26TH ST \ CHURCH ST | 26TH ST \ CHURCH ST | 1733945988000 | middleware_editor | ALL WAY | CHURCH ST intersection | - | - | - | - | - | - | - | 39643 | 1067558400000 | -122.42712276 | 37.74849583 | - | 1733840100000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573160000 | 26TH ST | - | - | - | - | - | - |
| 22566 | N/A | Point | 1 | 1 | 250 - 299 | - | S117983 | 250-299 GUTTENBERG ST | 250-299 GUTTENBERG ST | F | F | - | F | 6595000 | 6595000 | - | - | SOUTH SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | PRETOR WAY | PRETOR WAY | 77022 | 77022 | 37.70962761 | -122.44283455 | - | - | 1710539427000 | MTA | ONE WAY (RA) | PRETOR WAY to HANOVER ST (250 - 299) | - | SOUTHBOUND ON PRETOR | - | - | - | - | - | 39644 | 1069286400000 | -122.44283455 | 37.70962761 | - | - | - | D11 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | 2IN IRON POST | IS | 1373573160000 | GUTTENBERG ST | 250 - 299 GUTTENBERG ST | 250 - 299 GUTTENBERG ST | 250 GUTTENBERG ST | - | HANOVER ST | HANOVER ST |
| 22567 | N/A | Point | 1 | 1 | 100 - 199 | - | S118013 | 100-199 LYON ST | 100-199 LYON ST | F | F | - | F | 8555000 | 8555000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | PAGE ST | PAGE ST | 77023 | 77023 | 37.77203768 | -122.44228293 | - | - | 1710539427000 | MTA | ROUNDABOUT ARROWS | PAGE ST to OAK ST (100 - 199) | - | NORTH LINE OF TURN AROUND | - | - | - | - | - | 39645 | 1070323200000 | -122.44228293 | 37.77203768 | - | - | - | D5 | - | OTHER REGULATORY | REG | R7(SF).0001 | 18X24 | SUP1 | 2IN IRON POST | IS | 1373573160000 | LYON ST | 100 - 199 LYON ST | 100 - 199 LYON ST | 100 LYON ST | - | OAK ST | OAK ST |
| 22568 | N/A | Point | 1 | 1 | 1900 - 1999 | - | S118235 | 1900-1999 35TH AVE | 1900-1999 35TH AVE | F | F | - | F | 1776000 | 1776000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | ORTEGA ST | ORTEGA ST | 77025 | 77025 | 37.75068348 | -122.49342315 | - | - | 1739923909000 | middleware_editor | SCHOOL (SYM) AHEAD | ORTEGA ST to PACHECO ST (1900 - 1999) | - | 125`SOUTH | - | - | - | - | - | 39646 | 1074902400000 | -122.49342315 | 37.75068348 | - | 1739886420000 | - | D4 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1373573220000 | 35TH AVE | 1900 - 1999 35TH AVE | 1900 - 1999 35TH AVE | 1900 35TH AVE | - | PACHECO ST | PACHECO ST |
| 22569 | N/A | Point | 1 | 1 | 1800 - 1849 | LEFT ARROW | S251835 | 1800-1849 OAKDALE AVE | 1800-1849 OAKDALE AVE | F | F | - | F | 9790000 | 9790000 | - | - | NORTH SIDE | - | - | - | - | PHELPS ST | PHELPS ST | 77026 | 77026 | 37.73702114 | -122.39460608 | - | - | 1710539427000 | MTA | TA (SYM) PLO 8AM-5PM MON-FRI (5 MIN) | PHELPS ST to DUNSHEE ST (1800 - 1849) | - | 27' WEST OF PHELPS ST. | - | - | - | - | - | 39647 | 1552401900000 | -122.39460608 | 37.73702114 | - | - | - | D10 | - | OTHER REGULATORY | REG | R38(SF)1.0031 | 14X21 | SUP1 | 2IN IRON POST | IS | 1551173460000 | OAKDALE AVE | 1800 - 1849 OAKDALE AVE | 1800 - 1849 OAKDALE AVE | 1800 OAKDALE AVE | - | DUNSHEE ST | DUNSHEE ST |
| 22570 | N/A | Point | 1 | 1 | 1800 - 1849 | RIGHT ARROW | S251836 | 1800-1849 OAKDALE AVE | 1800-1849 OAKDALE AVE | F | F | - | F | 9790000 | 9790000 | - | - | NORTH SIDE | - | - | - | - | PHELPS ST | PHELPS ST | 77027 | 77027 | 37.73702114 | -122.39460608 | - | - | 1710539427000 | MTA | TA (SYM) PLO 8AM-5PM MON-FRI (5 MIN) | PHELPS ST to DUNSHEE ST (1800 - 1849) | - | 70' WEST OF PHELPS ST. | - | - | - | - | - | 39648 | 1552401960000 | -122.39460608 | 37.73702114 | - | - | - | D10 | - | OTHER REGULATORY | REG | R38(SF)1.0031 | 14X21 | SUP1 | 2IN IRON POST | IS | 1551173580000 | OAKDALE AVE | 1800 - 1849 OAKDALE AVE | 1800 - 1849 OAKDALE AVE | 1800 OAKDALE AVE | - | DUNSHEE ST | DUNSHEE ST |
| 22571 | N/A | Point | 1 | 1 | 300 - 336 | - | S251842 | 300-336 1ST ST | 300-336 01ST ST | F | F | - | F | 111000 | 111000 | - | - | EAST SIDE | - | - | - | - | FOLSOM ST | FOLSOM ST | 77028 | 77028 | 37.78707499 | -122.39420111 | - | - | 1710539427000 | MTA | ONE WAY (RA) | FOLSOM ST to GUY PL (300 - 336) | - | SPL# 355, SIGN FACING EASTBOUND/ LANSING | - | - | - | - | - | 39649 | 1551277740000 | -122.39420111 | 37.78707499 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | LIGHT POLE | IS | 1551177060000 | 01ST ST | 300 - 336 1ST ST | 300 - 336 01ST ST | 300 1ST ST | - | GUY PL | GUY PL |
| 22572 | N/A | Point | 1 | 1 | 500 - 599 | - | S252231 | 500 - 599 UNIVERSITY ST | 500-599 UNIVERSITY ST | F | F | - | F | 12885000 | 12885000 | - | - | EAST SIDE | - | - | - | - | WAYLAND ST | WAYLAND ST | 77032 | 77032 | 37.72325834 | -122.41271868 | - | - | 1754682752000 | middleware_editor | NPRK ANY TIME VEH OVER 22' LONG OR 7' HIGH 12AM-6AM EVERYDAY | WAYLAND ST to WOOLSEY ST (500 - 599) | - | 30 FEET NORTH OF WOOLSEY | - | - | - | - | - | 39650 | 1553204700000 | -122.41271868 | 37.72325834 | - | - | - | D9 | - | PARKING:NPRK ANY TIME | REG | R30(SF).0572 | 18X18 | SUP2 | 2IN IRON POST | IS | 1551962100000 | UNIVERSITY ST | 500 - 599 UNIVERSITY ST | 500 - 599 UNIVERSITY ST | 500 UNIVERSITY ST | - | WOOLSEY ST | WOOLSEY ST |
| 22573 | N/A | Point | - | - | - | - | S230423 | BURROWS ST: GIRARD ST | - | F | F | - | F | 20652000 | 20652000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GIRARD ST | BURROWS ST | 66460 | 66460 | 37.72857432 | -122.40509102 | BURROWS ST \ GIRARD ST | GIRARD ST \ BURROWS ST | 1726154103000 | middleware_editor | ALL WAY | BURROWS ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 39651 | 137289600000 | -122.40509102 | 37.72857432 | - | 1494201600000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1477898520000 | GIRARD ST | - | - | - | - | - | - |
| 22574 | N/A | Point | - | - | - | - | S230424 | BURROWS ST: GIRARD ST | - | F | F | - | F | 20652000 | 20652000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GIRARD ST | BURROWS ST | 66461 | 66461 | 37.72857432 | -122.40509102 | BURROWS ST \ GIRARD ST | GIRARD ST \ BURROWS ST | 1726154105000 | middleware_editor | ALL WAY | BURROWS ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 39652 | 137289600000 | -122.40509102 | 37.72857432 | - | 1494201600000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | UTILITY POLE | IS | 1477898820000 | GIRARD ST | - | - | - | - | - | - |
| 22575 | N/A | Point | - | - | - | - | S230433 | GIRARD ST: DWIGHT ST | - | F | F | - | F | 20599000 | 20599000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GIRARD ST | DWIGHT ST | 66467 | 66467 | 37.72377503 | -122.40310583 | DWIGHT ST \ GIRARD ST | GIRARD ST \ DWIGHT ST | 1742259283000 | middleware_editor | ALL WAY | DWIGHT ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 39653 | 137919600000 | -122.40310583 | 37.72377503 | - | 1491030000000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477901160000 | GIRARD ST | - | - | - | - | - | - |
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