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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77251 | N/A | Point | - | - | - | - | S215322 | - | - | F | F | - | F | 2481000 | - | - | - | SOUTH SIDE | 1689201376000 | MTA | - | - | - | - | 131364 | 131364 | 37.7483972 | -122.4083015 | - | - | 1714747768000 | middleware_editor | (VA) ONLY/ (45RA) 101 S ONLY | - | - | 15FT.EAST OF YORK ST / POLE EXISTING | - | - | - | - | - | 94369 | 1442919300000 | - | - | - | 1442880000000 | - | D9 | - | OTHER REGULATORY | REG | R61(SF).0153 | 36X36 | SUP2 | LIGHT POLE | IS | - | - | 2900 - 2952 CESAR CHAVEZ ST | - | - | - | - | - |
| 77252 | N/A | Point | - | - | - | - | S221573 | - | - | F | F | - | F | 6128000 | - | - | - | SOUTH SIDE | 1689201376000 | MTA | - | - | - | - | 131365 | 131365 | 37.72188461 | -122.44972686 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "V" PERMITS | - | - | IFO#124 | - | - | - | - | - | 94370 | 1454068980000 | - | - | - | 1454025600000 | - | D11 | - | PARKING:RPP | REG | R32C(CA).0102 | 18X21 | SUP2 | 2IN IRON POST | IS | - | - | 100 - 198 GENEVA AVE | - | - | - | - | - |
| 77253 | N/A | Point | - | - | - | - | S233187 | - | - | F | F | - | F | 6437000 | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131366 | 131366 | 37.74817974 | -122.50781822 | - | - | 1713298945000 | middleware_editor | DO NOT PASS | - | - | 2ND LP SOUTH | - | - | - | - | - | 94371 | 1485945000000 | - | - | - | 1485907200000 | - | D7 | - | OTHER REGULATORY | REG | R4-1.0001 | 24X30 | SUP2 | LIGHT POLE | IS | - | - | 2000 - 2099 GREAT HWY | - | - | - | - | - |
| 77254 | N/A | Point | - | - | - | - | S209469 | - | - | F | F | - | F | 9173000 | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131367 | 131367 | 37.71967616 | -122.43862356 | - | - | 1726762188000 | middleware_editor | YIELD HERE TO PED (SYM) (LA) | - | - | OPP.NEW SHARK TEETH (#26 ON LIST) | - | - | - | - | - | 94372 | 1125532800000 | - | - | - | - | 1726572000000 | D11 | - | PEDESTRIAN | REG | R1-5.0002 | 30X30 | SUP2 | 2IN IRON POST | RETD | - | - | 4900 - 4950 MISSION ST | - | - | - | - | - |
| 77255 | N/A | Point | - | - | - | - | S239000 | - | - | F | F | - | F | 11436000 | - | - | - | EAST SIDE | 1689201376000 | MTA | - | - | - | - | 131368 | 131368 | 37.74474799 | -122.42232885 | - | - | 1734619898000 | middleware_editor | FG 300 UR DELINEATOR (W) | - | - | S-LINE OF 28TH ST TO 30' SOUTH(10' OC) | - | - | - | - | - | 94373 | 1506087240000 | - | - | - | 1506038400000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | - | - | 651 - 699 SAN JOSE AVE | - | - | - | - | - |
| 77256 | N/A | Point | - | - | - | - | S111995 | - | - | F | F | - | F | - | - | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131374 | 131374 | 37.71833993 | -122.41288351 | - | - | 1710539427000 | MTA | ONE WAY (RA) | - | - | OPP S/W CORNER (SEE PAINT) (WITH R1) | - | - | - | - | - | 94374 | 893116800000 | - | - | - | - | - | D10 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | 2IN IRON POST | IS | - | - | 0 - 0 MANSELL ST | - | - | - | - | - |
| 77257 | N/A | Point | - | - | - | - | S204296 | - | - | F | F | - | F | 8843000 | - | - | - | WEST SIDE, EASTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131377 | 131377 | 37.78173382 | -122.4475608 | - | - | 1710539427000 | MTA | NO PED XING-USE CROSSWALK (RA) | - | - | 225FT. NORTH OF GEARY | - | - | - | - | - | 94375 | - | - | - | - | - | - | D1 | - | PEDESTRIAN | REG | R49(CA).0006 | 36X18 | SUP2 | 2 POST ALUMINUM | IS | - | - | 5 - 99 MASONIC AVE | - | - | - | - | - |
| 77258 | N/A | Point | - | - | - | - | S210358 | - | - | T | T | - | F | 548000 | - | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131378 | 131378 | 37.76945025 | -122.41215854 | - | - | 1710539427000 | MTA | HARRISON ST | - | - | AT WEST LINE OF HARRISON | - | - | - | - | - | 94376 | 1427699100000 | - | - | - | 1427673600000 | - | D6 | - | STREET NAME | GUIDE | D3-2.0180 | 72X18 | SUP1 | FREEWAY COLUMN | IS | - | - | 1 - 21 13TH ST | - | - | - | - | - |
| 77259 | N/A | Point | - | - | - | - | S203281 | - | - | F | F | - | F | 12561000 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | - | - | 131379 | 131379 | 37.80773312 | -122.40818257 | - | - | 1710539427000 | MTA | FISHERMAN'S WHARF (LOGO)/PARKING(LA) | - | - | 150FT. EAST OF GRANT AVE | - | - | - | - | - | 94377 | - | - | - | - | - | - | D3 | - | PARKING | REG | G-F(SF).0034 | 30X42 | SUP1 | LIGHT POLE | IS | - | - | 1501 - 1599 THE EMBARCADERO | - | - | - | - | - |
| 77260 | N/A | Point | - | - | - | - | S203728 | - | - | F | F | - | F | 6574000 | - | - | - | EAST SIDE | 1689201376000 | MTA | - | - | - | - | 131380 | 131380 | 37.77029532 | -122.42460753 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | - | - | INFO #57-59 | - | - | - | - | - | 94378 | 1403277120000 | - | - | - | 1403222400000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | LIGHT POLE | IS | - | - | 1 - 99 GUERRERO ST | - | - | - | - | - |
| 77261 | N/A | Point | - | - | - | - | S280025 | - | - | F | F | - | F | 155270019 | - | - | - | EAST SIDE | 1689201376000 | MTA | - | - | - | - | 131381 | 131381 | 37.78545158 | -122.42140517 | - | - | 1710539427000 | MTA | TANSAT | - | - | 25' N OF ALICE B TOKLAS (MYRTLE) | - | - | - | - | - | 94379 | 1643241600000 | - | - | - | - | - | D5 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | - | - | 1015 - 1099 VAN NESS AVE | - | - | - | - | - |
| 77262 | N/A | Point | - | - | - | - | S210551 | - | - | F | F | - | F | 8843000 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 131383 | 131383 | 37.78173382 | -122.4475608 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "L" PERMITS | - | - | 2`NORTH OF ANZA | - | - | - | - | - | 94380 | - | - | - | - | - | - | D1 | - | PARKING:RPP | REG | R32C(CA).0095 | 18X21 | SUP2 | LIGHT POLE | IS | - | - | 5 - 99 MASONIC AVE | - | - | - | - | - |
| 77263 | N/A | Point | - | - | - | - | S211048 | - | - | F | F | - | F | 549000 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | - | - | 131384 | 131384 | 37.76955547 | -122.41503693 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM MON WED FRI STCL | - | - | 25'E OF BERNICE | - | - | - | - | - | 94381 | - | - | - | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0051 | 18X18 | SUP1 | 2IN IRON POST | IS | - | - | 51 - 99 13TH ST | - | - | - | - | - |
| 77264 | N/A | Point | - | - | - | - | S211198 | - | - | F | F | - | F | 12561000 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 131385 | 131385 | 37.80773312 | -122.40818257 | - | - | 1710539427000 | MTA | TANSAT | - | - | 110' NORTH OF NORTH POINT | - | - | - | - | - | 94382 | 1419588720000 | - | - | - | 1419552000000 | - | D3 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | - | - | 1501 - 1599 THE EMBARCADERO | - | - | - | - | - |
| 77265 | N/A | Point | - | - | - | - | S247381 | - | - | F | F | - | F | 12561000 | - | - | - | EAST SIDE, EASTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131386 | 131386 | 37.80773312 | -122.40818257 | - | - | 1710539427000 | MTA | NO TURN ON RED | - | - | 70FT SOUTH OF CROSSWALK | - | - | - | - | - | 94383 | 1532786400000 | - | - | - | - | - | D3 | - | OTHER REGULATORY | REG | R10-11A.0001 | 24X30 | SUP1 | SIGNAL POLE | IS | - | - | 1501 - 1599 THE EMBARCADERO | - | - | - | - | - |
| 77266 | N/A | Point | - | - | - | - | S248923 | - | - | F | F | - | F | 13712000 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | - | - | 131387 | 131387 | 37.74682532 | -122.4579544 | - | - | 1756334015000 | middleware_editor | NPRK 5AM-7AM SUN STCL | - | - | 140FT. WEST OF VASQUEZ AVE. | - | - | - | - | - | 94384 | 1540932240000 | - | - | - | 1756317600000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0163 | 18X18 | SUP2 | LIGHT POLE | IS | - | - | 1 - 99 WOODSIDE AVE | - | - | - | - | - |
| 77267 | N/A | Point | - | - | - | - | S106183 | PARIS ST: EXCELSIOR AVE | - | F | F | - | F | 21759000 | 21759000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 1466 | 1466 | 37.725575769 | -122.432087795 | PARIS ST \ EXCELSIOR AVE | PARIS ST \ EXCELSIOR AVE | 1710539427000 | MTA | STOP | EXCELSIOR AVE intersection | - | 0 / 0 | - | - | - | - | - | 94386 | 127699200000 | -122.43205382 | 37.72548808 | - | 1057968000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569440000 | PARIS ST | - | - | - | - | - | - |
| 77268 | N/A | Point | - | - | - | - | S106184 | PARIS ST: EXCELSIOR AVE | - | F | F | - | F | 21759000 | 21759000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 1467 | 1467 | 37.725396148 | -122.432026998 | PARIS ST \ EXCELSIOR AVE | PARIS ST \ EXCELSIOR AVE | 1710539427000 | MTA | STOP | EXCELSIOR AVE intersection | - | 0 / 0 | - | - | - | - | - | 94387 | 127699200000 | -122.43205382 | 37.72548808 | - | 1540771200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569440000 | PARIS ST | - | - | - | - | - | - |
| 77269 | N/A | Point | - | - | - | - | S106185 | HANOVER ST: LOWELL ST | - | F | F | - | F | 21493000 | 21493000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LOWELL ST | LOWELL ST | 1468 | 1468 | 37.708632576 | -122.444949381 | HANOVER ST \ LOWELL ST | HANOVER ST \ LOWELL ST | 1710539427000 | MTA | STOP | LOWELL ST intersection | - | 0 / 0 | - | - | - | - | - | 94388 | 127699200000 | -122.44483941 | 37.70858377 | - | 1190073600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | HANOVER ST | - | - | - | - | - | - |
| 77270 | N/A | Point | - | - | - | - | S106189 | BRAZIL AVE: MOSCOW ST | - | F | F | - | F | 21633000 | 21633000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | BRAZIL AVE | 1471 | 1471 | 37.721264692 | -122.427500705 | MOSCOW ST \ BRAZIL AVE | MOSCOW ST \ BRAZIL AVE | 1730239925000 | middleware_editor | STOP | BRAZIL AVE intersection | - | 0 / 0 | - | - | - | - | - | 94389 | 127958400000 | -122.42764465 | 37.72125762 | - | 1730125980000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | MOSCOW ST | - | - | - | - | - | - |
| 77271 | N/A | Point | - | - | - | - | S106190 | BRAZIL AVE: MOSCOW ST | - | F | F | - | F | 21633000 | 21633000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | BRAZIL AVE | 1472 | 1472 | 37.721263278 | -122.42775015 | MOSCOW ST \ BRAZIL AVE | MOSCOW ST \ BRAZIL AVE | 1710539427000 | MTA | STOP | BRAZIL AVE intersection | - | 0 / 0 | - | - | - | - | - | 94390 | 127958400000 | -122.42764465 | 37.72125762 | - | 1586736000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | MOSCOW ST | - | - | - | - | - | - |
| 77272 | N/A | Point | - | - | - | - | S104939 | FOLSOM ST: 9TH ST | - | F | F | - | F | 24246000 | 24246000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 9TH ST | FOLSOM ST | 1485 | 1485 | 37.773750269 | -122.411801228 | FOLSOM ST \ 9TH ST | 09TH ST \ FOLSOM ST | 1715023814000 | middleware_editor | ONE WAY (RA) | FOLSOM ST intersection | - | 0 / MADE FOLSOM 1-WAY EB 11THST-EMB..... | - | - | - | - | - | 94391 | 38102400000 | -122.41161012 | 37.77376935 | - | 1714998600000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373569080000 | 09TH ST | - | - | - | - | - | - |
| 77273 | N/A | Point | - | - | - | - | S105623 | HURON AVE: FARRAGUT AVE | - | F | F | - | F | 21554000 | 21554000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FARRAGUT AVE | FARRAGUT AVE | 1499 | 1499 | 37.71111757 | -122.45077403 | HURON AVE \ FARRAGUT AVE | HURON AVE \ FARRAGUT AVE | 1754495727000 | middleware_editor | STOP | FARRAGUT AVE intersection | - | 0 / 00 | - | - | - | - | - | 94392 | 90662400000 | -122.45077403 | 37.71111757 | - | 1037692800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569260000 | HURON AVE | - | - | - | - | - | - |
| 77274 | N/A | Point | - | - | - | - | S105835 | VALLEJO ST: MASON ST | - | F | F | - | F | 25116000 | 25116000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VALLEJO ST | VALLEJO ST | 1524 | 1524 | 37.79816524 | -122.41209588 | MASON ST \ VALLEJO ST | MASON ST \ VALLEJO ST | 1710539427000 | MTA | STOP | VALLEJO ST intersection | - | - | - | - | - | - | - | 94393 | 104691600000 | -122.41209588 | 37.79816524 | - | 1304269200000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569380000 | MASON ST | - | - | - | - | - | - |
| 77275 | N/A | Point | - | - | - | - | S105836 | VALLEJO ST: MASON ST | - | F | F | - | F | 25116000 | 25116000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VALLEJO ST | VALLEJO ST | 1525 | 1525 | 37.79816524 | -122.41209588 | MASON ST \ VALLEJO ST | MASON ST \ VALLEJO ST | 1710539427000 | MTA | STOP | VALLEJO ST intersection | - | - | - | - | - | - | - | 94394 | 104691600000 | -122.41209588 | 37.79816524 | - | 1413961380000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569380000 | MASON ST | - | - | - | - | - | - |
| 77276 | N/A | Point | - | - | - | - | S105848 | 28TH ST: CHURCH ST | - | F | F | - | F | 21906000 | 21906000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 28TH ST | CHURCH ST | 1533 | 1533 | 37.7452985 | -122.4268223 | CHURCH ST \ 28TH ST | 28TH ST \ CHURCH ST | 1716222219000 | middleware_editor | STOP | CHURCH ST intersection | 101827721 | FROM W POLE TO NEW 2IN | - | - | - | - | - | 94395 | 105148800000 | -122.4268223 | 37.7452985 | - | 1576454400000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373569380000 | 28TH ST | - | - | - | - | - | - |
| 77277 | N/A | Point | 1 | 1 | 841 - 891 | - | S103891 | 0-891 SAN JOSE AVE | 841-891 SAN JOSE AVE | F | F | - | F | 11438102 | 11438102 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | KINGSTON ST | KINGSTON ST | 1553 | 1553 | 37.74117195 | -122.42363834 | - | - | 1710539427000 | MTA | ONE WAY (RA) | KINGSTON ST to BROOK ST (841 - 891) -- WEST -- | - | C LINE / 0 | - | - | - | - | - | 94396 | -73699200000 | -122.42363834 | 37.74117195 | - | - | - | D9 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | UNKNOWN | IS | 1373568780000 | SAN JOSE AVE | 841 - 891 SAN JOSE AVE | 841 - 891 SAN JOSE AVE | 841 SAN JOSE AVE | - | BROOK ST | BROOK ST |
| 77278 | N/A | Point | - | - | - | - | S106240 | ATHENS ST: AMAZON AVE | - | F | F | - | F | 21406000 | 21406000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | AMAZON AVE | ATHENS ST | 1581 | 1581 | 37.714840308 | -122.433665932 | ATHENS ST \ AMAZON AVE | AMAZON AVE \ ATHENS ST | 1710539427000 | MTA | STOP | ATHENS ST intersection | - | 0 / 0 | - | - | - | - | - | 94397 | 130982400000 | -122.43363911 | 37.7147519 | - | 932342400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569500000 | AMAZON AVE | - | - | - | - | - | - |
| 77279 | N/A | Point | - | - | - | - | S106243 | EXCELSIOR AVE: PARIS ST | - | F | F | - | F | 21759000 | 21759000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 1582 | 1582 | 37.725490909 | -122.432168261 | PARIS ST \ EXCELSIOR AVE | PARIS ST \ EXCELSIOR AVE | 1710539427000 | MTA | STOP | EXCELSIOR AVE intersection | - | 0 / 0 | - | - | - | - | - | 94398 | 130982400000 | -122.43205382 | 37.72548808 | - | 1540771200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569500000 | PARIS ST | - | - | - | - | - | - |
| 77280 | N/A | Point | - | - | - | - | S106244 | MADRID ST: EXCELSIOR AVE | - | F | F | - | F | 21686000 | 21686000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MADRID ST | EXCELSIOR AVE | 1583 | 1583 | 37.72482271 | -122.430483498 | EXCELSIOR AVE \ MADRID ST | MADRID ST \ EXCELSIOR AVE | 1710539427000 | MTA | STOP | EXCELSIOR AVE intersection | - | 0 / 0 | - | - | - | - | - | 94399 | 130982400000 | -122.4304531 | 37.72472512 | - | 1684108800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569500000 | MADRID ST | - | - | - | - | - | - |
| 77281 | N/A | Point | - | - | - | - | S106249 | JACKSON ST: FRONT ST | - | F | F | - | F | 24697000 | 24697000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FRONT ST | FRONT ST | 1586 | 1586 | 37.79692643 | -122.3995075 | JACKSON ST \ FRONT ST | JACKSON ST \ FRONT ST | 1710539427000 | MTA | DO NOT ENTER | FRONT ST intersection | - | 0 / MADE EASTBOUND ONE WAY | - | - | - | - | - | 94400 | 131155200000 | -122.3995075 | 37.79692643 | - | 1496188800000 | - | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569500000 | JACKSON ST | - | - | - | - | - | - |
| 77282 | N/A | Point | - | - | - | - | S106251 | TREAT AVE: 19TH ST | - | F | F | - | F | 24042000 | 24042000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | TREAT AVE | 19TH ST | 1587 | 1587 | 37.76056445 | -122.41375548 | 19TH ST \ TREAT AVE | TREAT AVE \ 19TH ST | 1740062142000 | middleware_editor | STOP | 19TH ST intersection | - | 0 / 0 | - | - | - | - | - | 94401 | 131760000000 | -122.41375548 | 37.76056445 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569500000 | TREAT AVE | - | - | - | - | - | - |
| 77283 | N/A | Point | - | - | - | - | S105536 | GREENWICH ST: JONES ST | - | F | F | - | F | 25504000 | 25504000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JONES ST | GREENWICH ST | 1594 | 1594 | 37.80148086 | -122.416133 | GREENWICH ST \ JONES ST | JONES ST \ GREENWICH ST | 1710539427000 | MTA | STOP | GREENWICH ST intersection | - | 0 / 0 | - | - | - | - | - | 94402 | 82252800000 | -122.416133 | 37.80148086 | - | 1153699200000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569260000 | JONES ST | - | - | - | - | - | - |
| 77284 | N/A | Point | - | - | - | - | S105148 | GRANADA AVE: HOLLOWAY AVE | - | F | F | - | F | 22584000 | 22584000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GRANADA AVE | GRANADA AVE | 1607 | 1607 | 37.72184308 | -122.45716309 | HOLLOWAY AVE \ GRANADA AVE | HOLLOWAY AVE \ GRANADA AVE | 1721050775000 | middleware_editor | STOP | GRANADA AVE intersection | - | - | - | - | - | - | - | 94403 | 55616400000 | -122.45716309 | 37.72184308 | - | 1720774200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569140000 | HOLLOWAY AVE | - | - | - | - | - | - |
| 77285 | N/A | Point | 1 | 1 | 3350 - 3399 | - | S127772 | 3350-3399 23RD ST | 3350-3399 23RD ST | F | F | - | F | 1266000 | 1266000 | - | - | SOUTH SIDE | - | - | - | - | BARTLETT ST | BARTLETT ST | 21420 | 21420 | 37.753689745 | -122.420382172 | - | - | 1754067280000 | middleware_editor | BUS STOP NO STOPPING 7AM-4PM SCHL DAYS | BARTLETT ST to VALENCIA ST (3350 - 3399) | - | 140FT.EAST OF VALENCIA OPP #3368 | - | - | - | - | - | 94404 | 1183359600000 | -122.42025879 | 37.7537364 | - | - | 1753978200000 | D9 | - | OTHER REGULATORY | REG | R30F(SF).0030 | 18X30 | SUP2 | 2IN IRON POST | RETD | 1373576220000 | 23RD ST | 3350 - 3399 23RD ST | 3350 - 3399 23RD ST | 3350 23RD ST | - | VALENCIA ST | VALENCIA ST |
| 77286 | N/A | Point | - | - | - | - | S121828 | BACON ST: HAMILTON ST | - | F | F | - | F | 20891000 | 20891000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BACON ST | BACON ST | 21481 | 21481 | 37.726008731 | -122.409627006 | HAMILTON ST \ BACON ST | HAMILTON ST \ BACON ST | 1736289463000 | middleware_editor | STOP | BACON ST intersection | - | - | - | - | - | - | - | 94405 | 1129593600000 | -122.40952687 | 37.72608369 | - | 1736173800000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373574360000 | HAMILTON ST | - | - | - | - | - | - |
| 77287 | N/A | Point | - | - | - | - | S121829 | HAMILTON ST: BACON ST | - | F | F | - | F | 20891000 | 20891000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BACON ST | BACON ST | 21482 | 21482 | 37.72615582 | -122.40963237 | HAMILTON ST \ BACON ST | HAMILTON ST \ BACON ST | 1710539427000 | MTA | ALL WAY | BACON ST intersection | - | - | - | - | - | - | - | 94406 | 1129593600000 | -122.40952687 | 37.72608369 | - | 1684972800000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373574360000 | HAMILTON ST | - | - | - | - | - | - |
| 77288 | N/A | Point | - | - | - | - | S129834 | 35TH AVE: QUINTARA ST | - | F | F | - | F | 23414000 | 23414000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 35TH AVE | 35TH AVE | 21598 | 21598 | 37.747992555 | -122.493308656 | QUINTARA ST \ 35TH AVE | QUINTARA ST \ 35TH AVE | 1710539427000 | MTA | ALL WAY | 35TH AVE intersection | - | - | - | - | - | - | - | 94407 | 1227052800000 | -122.49322819 | 37.74788828 | - | 1647820800000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576880000 | QUINTARA ST | - | - | - | - | - | - |
| 77289 | N/A | Point | - | - | - | - | S129835 | 35TH AVE: QUINTARA ST | - | F | F | - | F | 23414000 | 23414000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 35TH AVE | 35TH AVE | 21599 | 21599 | 37.74779991 | -122.493156664 | QUINTARA ST \ 35TH AVE | QUINTARA ST \ 35TH AVE | 1710539427000 | MTA | ALL WAY | 35TH AVE intersection | - | - | - | - | - | - | - | 94408 | 1227052800000 | -122.49322819 | 37.74788828 | - | 1685577600000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576880000 | QUINTARA ST | - | - | - | - | - | - |
| 77290 | N/A | Point | - | - | - | - | S129836 | QUINTARA ST: 35TH AVE | - | F | F | - | F | 23414000 | 23414000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 35TH AVE | 35TH AVE | 21600 | 21600 | 37.747980184 | -122.493125372 | QUINTARA ST \ 35TH AVE | QUINTARA ST \ 35TH AVE | 1710539427000 | MTA | ALL WAY | 35TH AVE intersection | - | - | - | - | - | - | - | 94409 | 1227052800000 | -122.49322819 | 37.74788828 | - | 1687824000000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576880000 | QUINTARA ST | - | - | - | - | - | - |
| 77291 | N/A | Point | - | - | - | - | S130009 | 18TH AVE: IRVING ST | - | F | F | - | F | 27371000 | 27371000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 18TH AVE | 18TH AVE | 21635 | 21635 | 37.763713014 | -122.476135964 | IRVING ST \ 18TH AVE | IRVING ST \ 18TH AVE | 1710539427000 | MTA | ALL WAY | 18TH AVE intersection | - | - | - | - | - | - | - | 94410 | 1231286400000 | -122.47605438 | 37.76360876 | - | 1496361600000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1373576940000 | IRVING ST | - | - | - | - | - | - |
| 77292 | N/A | Point | - | - | - | - | S130010 | 18TH AVE: IRVING ST | - | F | F | - | F | 27371000 | 27371000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 18TH AVE | 18TH AVE | 21636 | 21636 | 37.763511575 | -122.476002971 | IRVING ST \ 18TH AVE | IRVING ST \ 18TH AVE | 1710539427000 | MTA | ALL WAY | 18TH AVE intersection | - | - | - | - | - | - | - | 94411 | 1231286400000 | -122.47605438 | 37.76360876 | - | 1496361600000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576940000 | IRVING ST | - | - | - | - | - | - |
| 77293 | N/A | Point | - | - | - | - | S128828 | ELIZABETH ST: SANCHEZ ST | - | F | F | - | F | 25654000 | 25654000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ELIZABETH ST | ELIZABETH ST | 22994 | 22994 | 37.752362 | -122.4297313 | SANCHEZ ST \ ELIZABETH ST | SANCHEZ ST \ ELIZABETH ST | 1711491637000 | middleware_editor | SPEED HUMP | ELIZABETH ST intersection | - | - | - | - | - | - | - | 94412 | 1205366400000 | -122.4297313 | 37.752362 | - | - | - | D8 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373576580000 | SANCHEZ ST | - | - | - | - | - | - |
| 77294 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S127964 | 1200-1299 OAKDALE AVE | 1200-1299 OAKDALE AVE | F | F | - | F | 9783000 | 9783000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | INGALLS ST | INGALLS ST | 23070 | 23070 | 37.73050406 | -122.38311809 | - | - | 1710539427000 | MTA | SPEED HUMP | INGALLS ST to END: 1200-1299 BLOCK (1200 - 1299) | - | 25E / INSTALL SIGN ABOVE EXISTING "..... | - | - | - | - | - | 94413 | 1189382400000 | -122.38311809 | 37.73050406 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1373576280000 | OAKDALE AVE | 1200 - 1299 OAKDALE AVE | 1200 - 1299 OAKDALE AVE | 1200 OAKDALE AVE | - | END: 1200-1299 BLOCK | END: 1200-1299 BLOCK |
| 77295 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S127955 | 1000-1099 OAKDALE AVE | 1000-1099 OAKDALE AVE | F | F | - | F | 9781000 | 9781000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | GRIFFITH ST | GRIFFITH ST | 23133 | 23133 | 37.72886032 | -122.38028693 | - | - | 1722967610000 | middleware_editor | SPEED HUMP | GRIFFITH ST to BALDWIN CT (1000 - 1099) | - | 40W / INSTALL SIGN ABOVE EXISTING "..... | - | - | - | - | - | 94414 | 1188518400000 | -122.38028693 | 37.72886032 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373576280000 | OAKDALE AVE | 1000 - 1099 OAKDALE AVE | 1000 - 1099 OAKDALE AVE | 1000 OAKDALE AVE | - | BALDWIN CT | BALDWIN CT |
| 77296 | N/A | Point | 1 | 1 | 200 - 299 | - | S134118 | 200-299 BUENA VISTA EAST AVE | 200-299 BUENA VISTA AVE EAST | F | F | - | F | 3364000 | 3364000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | BUENA VISTA AVE \ BUENA VISTA TER \ DUBOCE AVE | BUENA VISTA AVE \ BUENA VISTA TER \ DUBOCE AVE | 23412 | 23412 | 37.76854189 | -122.43876439 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | BUENA VISTA AVE \ BUENA VISTA TER \ DUBOCE AVE to BUENA VISTA AVE \ PARK HILL AVE (200 - 299) | - | OPP #123 | - | - | - | - | - | 94415 | 1301443200000 | -122.43876439 | 37.76854189 | - | - | - | D8 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373578200000 | BUENA VISTA AVE EAST | 200 - 299 BUENA VISTA AVE EAST | 200 - 299 BUENA VISTA AVE EAST | 200 BUENA VISTA AVE EAST | - | BUENA VISTA AVE \ PARK HILL AVE | BUENA VISTA AVE \ PARK HILL AVE |
| 77297 | N/A | Point | 1 | 1 | 1900 - 1998 | - | S127442 | 1900-1998 SAN JOSE AVE | 1900-1998 SAN JOSE AVE | F | F | - | F | 11452000 | 11452000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | HAVELOCK ST | HAVELOCK ST | 23441 | 23441 | 37.72627578 | -122.44198455 | - | - | 1714786618000 | middleware_editor | STOP AHEAD (SYM) | HAVELOCK ST to SANTA YNEZ AVE (1900 - 1998) | - | OPP#1937 | - | - | - | - | - | 94416 | 1177286400000 | -122.44198455 | 37.72627578 | - | - | - | D11 | - | OTHER WARNING | WARNING | W3-1.0003 | 36X36 | SUP2 | LIGHT POLE | IS | 1373576160000 | SAN JOSE AVE | 1900 - 1998 SAN JOSE AVE | 1900 - 1998 SAN JOSE AVE | 1900 SAN JOSE AVE | - | SANTA YNEZ AVE | SANTA YNEZ AVE |
| 77298 | N/A | Point | 1 | 1 | 200 - 299 | - | S129501 | 200-299 RICHLAND AVE | 200-299 RICHLAND AVE | F | F | - | F | 11013000 | 11013000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | LEESE ST | LEESE ST | 23642 | 23642 | 37.73585244 | -122.42165767 | - | - | 1710539427000 | MTA | SPEED HUMP | LEESE ST to MURRAY ST (200 - 299) | - | OPP #203 15FT.EAST OF LEESE | - | - | - | - | - | 94417 | 1217980800000 | -122.42165767 | 37.73585244 | - | - | - | D9 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373576760000 | RICHLAND AVE | 200 - 299 RICHLAND AVE | 200 - 299 RICHLAND AVE | 200 RICHLAND AVE | - | MURRAY ST | MURRAY ST |
| 77299 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S204402 | 1100-1199 BUSH ST | 1100-1199 BUSH ST | F | F | - | F | 3441000 | 3441000 | - | - | SOUTH SIDE | - | - | - | - | LEAVENWORTH ST | LEAVENWORTH ST | 45650 | 45650 | 37.78921501 | -122.4161944 | - | - | 1710539427000 | MTA | NPRK 6AM-7AM WED STCL | LEAVENWORTH ST to HYDE ST (1100 - 1199) | - | EPL#1137 | - | - | - | - | - | 94418 | 1523362380000 | -122.4161944 | 37.78921501 | - | 1523318400000 | - | D3 | - | STREET CLEANING | REG | R30B(CA).0179 | 18X18 | SUP1 | LIGHT POLE | IS | 1396128720000 | BUSH ST | 1100 - 1199 BUSH ST | 1100 - 1199 BUSH ST | 1100 BUSH ST | - | HYDE ST | HYDE ST |
| 77300 | N/A | Point | 1 | 1 | 2700 - 2799 | - | S204319 | 2700-2799 16TH ST | 2700-2799 16TH ST | F | F | - | F | 720000 | 720000 | - | - | SOUTH SIDE | - | - | - | - | HARRISON ST \ TREAT AVE | HARRISON ST \ TREAT AVE | 45676 | 45676 | 37.765236936 | -122.415097314 | - | - | 1710539427000 | MTA | NPPZ 7AM-5PM EVERYDAY | HARRISON ST \ TREAT AVE to FOLSOM ST (2700 - 2799) | - | WPL #2791 | - | - | - | - | - | 94419 | - | -122.41420682 | 37.76538112 | - | - | - | D9 | - | OTHER REGULATORY | REG | R30(SF).0285 | 12X18 | SUP2 | 2IN IRON POST | IS | 1395916620000 | 16TH ST | 2700 - 2799 16TH ST | 2700 - 2799 16TH ST | 2700 16TH ST | - | FOLSOM ST | FOLSOM ST |
| 77301 | N/A | Point | 1 | 1 | 1100 - 1111 | - | S204329 | 1100-1111 BAYSHORE BLVD | 1100-1111 BAY SHORE BLVD | F | F | - | F | 2806000 | 2806000 | - | - | EAST SIDE | - | - | - | - | CARROLL AVE \ THORNTON AVE | CARROLL AVE \ THORNTON AVE | 45679 | 45679 | 37.73028013 | -122.40321104 | - | - | 1710539427000 | MTA | NPPZ 8AM-4PM MON-FRI | CARROLL AVE \ THORNTON AVE to QUINT ST (1100 - 1111) | - | 79' SOUTH OF SILVER/FOR RECORDS ONLY | - | - | - | - | - | 94420 | - | -122.40321104 | 37.73028013 | - | - | - | D10 | - | OTHER REGULATORY | REG | R30(SF).0384 | 12X18 | SUP1 | 2IN IRON POST | IS | 1395924660000 | BAY SHORE BLVD | 1100 - 1111 BAY SHORE BLVD | 1100 - 1111 BAY SHORE BLVD | 1100 BAY SHORE BLVD | - | QUINT ST | QUINT ST |
| 77302 | N/A | Point | 1 | 1 | 3100 - 3149 | - | S202253 | 3100-3149 19TH ST | 3100-3149 19TH ST | F | F | - | F | 966000 | 966000 | - | - | SOUTH SIDE | - | - | - | - | HARRISON ST | HARRISON ST | 45687 | 45687 | 37.76059686 | -122.41321843 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM FRI STCL | HARRISON ST to TREAT AVE (3100 - 3149) | - | 100 FT EAST FROM TREAT | - | - | - | - | - | 94421 | 1592990520000 | -122.41321843 | 37.76059686 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0046 | 18X18 | SUP2 | 2IN IRON POST | IS | 1389950820000 | 19TH ST | 3100 - 3149 19TH ST | 3100 - 3149 19TH ST | 3100 19TH ST | - | TREAT AVE | TREAT AVE |
| 77303 | N/A | Point | 1 | 1 | 2100 - 2199 | - | S204563 | 1250-2199 WASHINGTON ST | 2100-2199 WASHINGTON ST | F | F | - | F | 13436000 | 13436000 | - | - | SOUTH SIDE | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 45701 | 45701 | 37.79232099 | -122.42862571 | - | - | 1710539427000 | MTA | TANS BUS ONLY 5AM-7PM MON-FRI | OCTAVIA ST to LAGUNA ST (2100 - 2199) | - | (RA)SIGN 80FT. EAST OF LAGUNA ST | - | - | - | - | - | 94422 | 1397208480000 | -122.42862571 | 37.79232099 | - | 1397174400000 | - | D2 | - | OTHER REGULATORY | REG | R37(SF).0438 | 18X21 | SUP1 | 2IN IRON POST | IS | 1396597080000 | WASHINGTON ST | 2100 - 2199 WASHINGTON ST | 2100 - 2199 WASHINGTON ST | 2100 WASHINGTON ST | - | LAGUNA ST | LAGUNA ST |
| 77304 | N/A | Point | 1 | 1 | 200 - 299 | - | S200199 | 200-299 PENINSULA AVE | 200-299 PENINSULA AVE | F | F | - | F | 10326000 | 10326000 | - | - | WEST SIDE | - | - | - | - | HESTER AVE | HESTER AVE | 45717 | 45717 | 37.712674759 | -122.398736305 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM FRI STCL | HESTER AVE to BLANKEN AVE (200 - 299) | - | SPL #208 | - | - | - | - | - | 94423 | - | -122.39880336 | 37.71230131 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0259 | 18X18 | SUP1 | 2IN IRON POST | IS | 1383318900000 | PENINSULA AVE | 200 - 299 PENINSULA AVE | 200 - 299 PENINSULA AVE | 200 PENINSULA AVE | - | BLANKEN AVE | BLANKEN AVE |
| 77305 | N/A | Point | 1 | 1 | 600 - 699 | - | S200815 | 600-699 9TH ST | 600-699 09TH ST | F | F | - | F | 460000 | 460000 | - | - | EAST SIDE | - | - | - | - | BRANNAN ST | BRANNAN ST | 45746 | 45746 | 37.76975616 | -122.40660743 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM TUE THUR STCL | BRANNAN ST to DIVISION ST (600 - 699) | - | 50FT NORTH OF DIVISION | - | - | - | - | - | 94424 | 1397054760000 | -122.40660743 | 37.76975616 | - | 1397001600000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0058 | 18X18 | SUP1 | LIGHT POLE | IS | 1386328320000 | 09TH ST | 600 - 699 9TH ST | 600 - 699 09TH ST | 600 9TH ST | - | DIVISION ST | DIVISION ST |
| 77306 | N/A | Point | - | - | - | - | S201281 | TAYLOR ST: GEARY ST | - | T | T | - | F | 24941000 | 24941000 | - | - | NORTH EAST CORNER | - | - | - | - | TAYLOR ST | GEARY ST | 45776 | 45776 | 37.78693971 | -122.41151577 | GEARY ST \ TAYLOR ST | TAYLOR ST \ GEARY ST | 1710539427000 | MTA | GEARY ST | GEARY ST intersection | - | - | - | - | - | - | - | 94425 | 1398066060000 | -122.41151577 | 37.78693971 | - | 1398038400000 | - | D3 | - | STREET NAME | GUIDE | D3-1.0718 | 36X08 | SUP1 | LIGHT POLE | IS | 1387469100000 | TAYLOR ST | - | - | - | - | - | - |
| 77307 | N/A | Point | - | - | - | - | S205430 | WEBSTER ST: GEARY BLVD | - | F | F | - | F | 26587000 | 26587000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GEARY BLVD | GEARY BLVD | 45798 | 45798 | 37.78456824 | -122.43120495 | WEBSTER ST \ GEARY BLVD | WEBSTER ST \ GEARY BLVD | 1710539427000 | MTA | NO PED XING-USE OVERPASS (LA) | GEARY BLVD intersection | - | - | - | - | - | - | - | 94426 | 1460111640000 | -122.43120495 | 37.78456824 | - | 1499644800000 | - | D5 | - | PEDESTRIAN | REG | R49(SF).0003 | 36X18 | SUP1 | PED BARRICADE | IS | 1399288560000 | WEBSTER ST | - | - | - | - | - | - |
| 77308 | N/A | Point | - | - | - | - | S200170 | CAPISTRANO AVE: SANTA ROSA AVE | - | F | F | - | F | 21802000 | 21802000 | - | SHOULD BE RETIRED | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CAPISTRANO AVE | CAPISTRANO AVE | 45836 | 45836 | 37.72786053 | -122.43808473 | SANTA ROSA AVE \ CAPISTRANO AVE | SANTA ROSA AVE \ CAPISTRANO AVE | 1746134815000 | middleware_editor | STOP | CAPISTRANO AVE intersection | - | - | - | - | - | - | - | 94427 | - | -122.43808473 | 37.72786053 | - | 1357545600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | RETD | 1380029580000 | SANTA ROSA AVE | - | - | - | - | - | - |
| 77309 | N/A | Point | 1 | 1 | 1 - 99 | - | S204915 | 1-99 BARTLETT ST | 1-99 BARTLETT ST | F | F | - | F | 2742000 | 2742000 | - | - | WEST SIDE | - | - | - | - | 21ST ST | 21ST ST | 45859 | 45859 | 37.756776021 | -122.420068034 | - | - | 1710539427000 | MTA | NPRK 4AM-6AM MON WED FRI SAT SUN STCL | 21ST ST to 22ND ST (1 - 99) | - | 40FT.SOUTH OF 21ST ST | - | - | - | - | - | 94428 | 1458745320000 | -122.41993452 | 37.75616717 | - | 1458691200000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0143 | 18X18 | SUP2 | LIGHT POLE | IS | 1397636640000 | BARTLETT ST | 1 - 99 BARTLETT ST | 1 - 99 BARTLETT ST | 1 BARTLETT ST | - | 22ND ST | 22ND ST |
| 77310 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S201099 | 1300-1399 CLAY ST | 1300-1399 CLAY ST | F | F | - | F | 4102000 | 4102000 | - | - | NORTH SIDE | - | - | - | - | JONES ST | JONES ST | 45862 | 45862 | 37.79311838 | -122.41529155 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM TUE STCL | JONES ST to LEAVENWORTH ST (1300 - 1399) | - | IFO #1340 | - | - | - | - | - | 94429 | 1389189540000 | -122.41529155 | 37.79311838 | - | 1389139200000 | - | D3 | - | STREET CLEANING | REG | R30B(CA).0243 | 18X18 | SUP1 | MUNI POLE | IS | 1387195200000 | CLAY ST | 1300 - 1399 CLAY ST | 1300 - 1399 CLAY ST | 1300 CLAY ST | - | LEAVENWORTH ST | LEAVENWORTH ST |
| 77311 | N/A | Point | 1 | 1 | 400 - 499 | - | S204198 | 400-499 CASTRO ST | 400-499 CASTRO ST | F | F | - | F | 3790000 | 3790000 | - | - | WEST SIDE | - | - | - | - | 17TH ST \ MARKET ST | 17TH ST \ MARKET ST | 45937 | 45937 | 37.76178068 | -122.43508436 | - | - | 1723669051000 | middleware_editor | BIKE RACK | 17TH ST \ MARKET ST to 18TH ST (400 - 499) | - | IFO #468 | - | - | - | - | - | 94430 | - | -122.43508436 | 37.76178068 | - | - | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | 2IN FLANGE POST | IS | 1395744120000 | CASTRO ST | 400 - 499 CASTRO ST | 400 - 499 CASTRO ST | 400 CASTRO ST | - | 18TH ST | 18TH ST |
| 77312 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S204675 | 1700-1799 PALOU AVE | 1700-1799 PALOU AVE | F | F | - | F | 10224000 | 10224000 | - | - | SOUTH SIDE | - | - | - | - | NEWHALL ST | NEWHALL ST | 45970 | 45970 | 37.73557231 | -122.393719 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM THUR STCL | NEWHALL ST to PHELPS ST (1700 - 1799) | - | EPL #1759 | - | - | - | - | - | 94431 | - | -122.393719 | 37.73557231 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0304 | 18X18 | SUP1 | LIGHT POLE | IS | 1396946700000 | PALOU AVE | 1700 - 1799 PALOU AVE | 1700 - 1799 PALOU AVE | 1700 PALOU AVE | - | PHELPS ST | PHELPS ST |
| 77313 | N/A | Point | - | - | - | - | S215821 | CLARENDON AVE: OAK PARK DR | - | F | F | - | F | 26253000 | 26253000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | CLARENDON AVE | CLARENDON AVE | 56880 | 56880 | 37.755246256 | -122.454999983 | OAK PARK DR \ CLARENDON AVE | CLARENDON AVE intersection | 1710539427000 | MTA | NO U TURN (SYM) | CLARENDON AVE intersection | - | - | - | - | - | - | - | 94432 | 1430994960000 | -122.45505239 | 37.75511629 | - | 1430956800000 | - | D7 | - | OTHER REGULATORY | REG | R3-4.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1430488260000 | OAK PARK DR | - | - | - | - | - | - |
| 77314 | N/A | Point | - | - | - | - | S215822 | CLARENDON AVE: OAK PARK DR | - | F | F | - | F | 26253000 | 26253000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | CLARENDON AVE | CLARENDON AVE | 56881 | 56881 | 37.755244942 | -122.454992487 | OAK PARK DR \ CLARENDON AVE | CLARENDON AVE intersection | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 25/WHEN CHILDREN ARE PRESENT | CLARENDON AVE intersection | - | - | - | - | - | - | - | 94433 | 1431524220000 | -122.45505239 | 37.75511629 | - | 1431475200000 | - | D7 | - | OTHER REGULATORY | REG | SR4-1(CA).0002 | 24X48 | SUP2 | LIGHT POLE | IS | 1430488440000 | OAK PARK DR | - | - | - | - | - | - |
| 77315 | N/A | Point | - | - | - | - | S215823 | CLARENDON AVE: OAK PARK DR | - | F | F | - | F | 26253000 | 26253000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CLARENDON AVE | CLARENDON AVE | 56882 | 56882 | 37.755253425 | -122.455114975 | OAK PARK DR \ CLARENDON AVE | CLARENDON AVE intersection | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 25/WHEN CHILDREN ARE PRESENT | CLARENDON AVE intersection | - | - | - | - | - | - | - | 94434 | - | -122.45505239 | 37.75511629 | - | - | - | D7 | - | OTHER REGULATORY | REG | SR4-1(CA).0002 | 24X48 | SUP2 | SIGNAL POLE | IS | 1430488620000 | OAK PARK DR | - | - | - | - | - | - |
| 77316 | N/A | Point | - | - | - | - | S217009 | 5TH AVE: CABRILLO ST | - | T | T | - | F | - | 27240000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | - | CABRILLO ST | 56899 | 56899 | 37.7751873526419 | -122.462806091072 | - | 05TH AVE \ CABRILLO ST | 1747752284000 | middleware_editor | STOP AHEAD (SYM) | CABRILLO ST intersection | - | @ 736 5TH AVE | - | - | - | - | - | 94435 | - | -122.46280475 | 37.77541791 | - | 1641283200000 | - | D1 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1434034560000 | 05TH AVE | - | - | - | - | - | - |
| 77317 | N/A | Point | 1 | 1 | 400 - 499 | - | S217946 | 400-499 BRAZIL AVE | 400-499 BRAZIL AVE | F | F | - | F | 3097000 | 3097000 | - | - | SOUTH SIDE | - | - | - | - | MADRID ST | MADRID ST | 57096 | 57096 | 37.72304857 | -122.431486142 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | MADRID ST to EDINBURGH ST (400 - 499) | - | OPP#407 | - | - | - | - | - | 94436 | - | -122.43123312 | 37.72297573 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP2 | 2IN IRON POST | IS | 1437123180000 | BRAZIL AVE | 400 - 499 BRAZIL AVE | 400 - 499 BRAZIL AVE | 400 BRAZIL AVE | - | EDINBURGH ST | EDINBURGH ST |
| 77318 | N/A | Point | - | - | - | - | S221492 | SUSSEX ST: DIAMOND ST | - | F | F | - | F | 21948000 | 21948000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SUSSEX ST | DIAMOND ST | 57159 | 57159 | 37.73725632 | -122.43469728 | DIAMOND ST \ SUSSEX ST | SUSSEX ST \ DIAMOND ST | 1755100589000 | middleware_editor | STOP AHEAD (SYM) | DIAMOND ST intersection | - | 150FT WEST OF DIAMOND ST | - | - | - | - | - | 94437 | 300524400000 | -122.43469728 | 37.73725632 | - | 1451376000000 | - | D8 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1450795800000 | SUSSEX ST | - | - | - | - | - | - |
| 77319 | N/A | Point | - | - | - | - | S214863 | GREEN ST: TAYLOR ST | - | F | F | - | F | 50311000 | 25433000 | - | - | NORTH SIDE | - | - | - | - | END: WEST | GREEN ST | 57206 | 57206 | 37.798880216 | -122.414679093 | - | TAYLOR ST \ GREEN ST | 1710539427000 | MTA | 2 HR PRK 8AM-7PM MON-FRI EXC "AC" PERMITS | GREEN ST intersection | 1 | IFO# 940 GREEN ST | - | - | - | - | - | 94438 | 1432648620000 | -122.41393102 | 37.79888755 | - | 1432598400000 | - | D3 | - | PARKING:RPP | REG | R32C(CA).0113 | 18X21 | SUP1 | LIGHT POLE | IS | 1427890140000 | TAYLOR ST | - | - | - | - | - | - |
| 77320 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S216752 | 1200-1299 FELL ST | 1200-1299 FELL ST | F | F | - | F | 5451000 | 5451000 | - | - | NORTH SIDE | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 57218 | 57218 | 37.774104908 | -122.437905927 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM TUE STCL | DIVISADERO ST to BRODERICK ST (1200 - 1299) | - | 40' WEST OF DIVISADERO | - | - | - | - | - | 94439 | 1439649660000 | -122.43844371 | 37.77395438 | - | 1439596800000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0083 | 18X18 | SUP1 | 2IN IRON POST | IS | 1433254500000 | FELL ST | 1200 - 1299 FELL ST | 1200 - 1299 FELL ST | 1200 FELL ST | - | BRODERICK ST | BRODERICK ST |
| 77321 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S216753 | 1200-1299 FELL ST | 1200-1299 FELL ST | F | F | - | F | 5451000 | 5451000 | - | - | NORTH SIDE | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 57219 | 57219 | 37.774104862 | -122.437894195 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-8PM MON-FRI EXC "Q' PERMITS | DIVISADERO ST to BRODERICK ST (1200 - 1299) | - | 40' WEST OF DIVISADERO | - | - | - | - | - | 94440 | 1439649780000 | -122.43844371 | 37.77395438 | - | 1439596800000 | - | D5 | - | PARKING:RPP | REG | R32C(CA).0216 | 18X21 | SUP1 | 2IN IRON POST | IS | 1433254560000 | FELL ST | 1200 - 1299 FELL ST | 1200 - 1299 FELL ST | 1200 FELL ST | - | BRODERICK ST | BRODERICK ST |
| 77322 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S216754 | 1200-1299 FELL ST | 1200-1299 FELL ST | F | F | - | F | 5451000 | 5451000 | - | - | NORTH SIDE | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 57220 | 57220 | 37.774041928 | -122.438383627 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM TUE STCL | DIVISADERO ST to BRODERICK ST (1200 - 1299) | - | INFO #1216 | - | - | - | - | - | 94441 | 1439649840000 | -122.43844371 | 37.77395438 | - | 1608595200000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0083 | 18X18 | SUP1 | 2IN IRON POST | IS | 1433254560000 | FELL ST | 1200 - 1299 FELL ST | 1200 - 1299 FELL ST | 1200 FELL ST | - | BRODERICK ST | BRODERICK ST |
| 77323 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S216756 | 1200-1299 FELL ST | 1200-1299 FELL ST | F | F | - | F | 5451000 | 5451000 | - | - | NORTH SIDE | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 57221 | 57221 | 37.773996404 | -122.438741152 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM TUE STCL | DIVISADERO ST to BRODERICK ST (1200 - 1299) | - | EPL #1272 | - | - | - | - | - | 94442 | 1439650140000 | -122.43844371 | 37.77395438 | - | 1439596800000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0083 | 18X18 | SUP1 | LIGHT POLE | IS | 1433254680000 | FELL ST | 1200 - 1299 FELL ST | 1200 - 1299 FELL ST | 1200 FELL ST | - | BRODERICK ST | BRODERICK ST |
| 77324 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S216757 | 1200-1299 FELL ST | 1200-1299 FELL ST | F | F | - | F | 5451000 | 5451000 | - | - | NORTH SIDE | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 57222 | 57222 | 37.773996783 | -122.438744788 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-8PM MON-FRI EXC "Q' PERMITS | DIVISADERO ST to BRODERICK ST (1200 - 1299) | - | EPL #1272 | - | - | - | - | - | 94443 | 1439650200000 | -122.43844371 | 37.77395438 | - | 1439596800000 | - | D5 | - | PARKING:RPP | REG | R32C(CA).0216 | 18X21 | SUP1 | LIGHT POLE | IS | 1433254680000 | FELL ST | 1200 - 1299 FELL ST | 1200 - 1299 FELL ST | 1200 FELL ST | - | BRODERICK ST | BRODERICK ST |
| 77325 | N/A | Point | 1 | 1 | 500 - 599 | - | S219227 | 500-599 CORBETT AVE | 500-599 CORBETT AVE | F | F | - | F | 4385000 | 4385000 | - | - | EAST SIDE | - | - | - | - | IRON ALY | IRON ALY | 57646 | 57646 | 37.757444054 | -122.444193185 | - | - | 1710539427000 | MTA | (45 RA) CURVE (SYM)/15 MPH | IRON ALY to COPPER ALY (500 - 599) | - | IFO 527 | - | - | - | - | - | 94444 | 1241568000000 | -122.44410199 | 37.75742921 | - | - | - | D8 | - | SPEED LIMIT | WARNING | W1-2A.0011 | 30X30 | SUP2 | 2IN IRON POST | IS | 1441978680000 | CORBETT AVE | 500 - 599 CORBETT AVE | 500 - 599 CORBETT AVE | 500 CORBETT AVE | - | COPPER ALY | COPPER ALY |
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