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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26026 | N/A | Point | - | - | - | - | S104140 | TAYLOR ST: BAY ST | - | F | F | - | F | 25524000 | 25524000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | TAYLOR ST | BAY ST | 918 | 918 | 37.80541717 | -122.41524149 | BAY ST \ TAYLOR ST | TAYLOR ST \ BAY ST | 1714179604000 | middleware_editor | DO NOT ENTER | BAY ST intersection | - | 0 / MADE TAYLOR 1-WAY | - | - | - | - | - | 43105 | -43632000000 | -122.41524149 | 37.80541717 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373568840000 | TAYLOR ST | - | - | - | - | - | - |
| 26027 | N/A | Point | - | - | - | - | S104141 | TAYLOR ST: BAY ST | - | F | F | - | F | 25524000 | 25524000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | TAYLOR ST | BAY ST | 919 | 919 | 37.80541717 | -122.41524149 | BAY ST \ TAYLOR ST | TAYLOR ST \ BAY ST | 1714149872000 | middleware_editor | DO NOT ENTER | BAY ST intersection | - | 0 / MADE TAYLOR 1-WAY | - | - | - | - | - | 43106 | -43632000000 | -122.41524149 | 37.80541717 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373568840000 | TAYLOR ST | - | - | - | - | - | - |
| 26028 | N/A | Point | - | - | - | - | S104146 | ELLSWORTH ST: CORTLAND AVE | - | F | F | - | F | 21084000 | 21084000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CORTLAND AVE | CORTLAND AVE | 924 | 924 | 37.73888149 | -122.41455886 | ELLSWORTH ST \ CORTLAND AVE | ELLSWORTH ST \ CORTLAND AVE | 1710539427000 | MTA | DO NOT ENTER | CORTLAND AVE intersection | - | 0 / ONE WAY SOUTH | - | - | - | - | - | 43107 | -43113600000 | -122.41455886 | 37.73888149 | - | - | - | D9 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP2 | UNKNOWN | IS | 1373568840000 | ELLSWORTH ST | - | - | - | - | - | - |
| 26029 | N/A | Point | - | - | - | - | S104421 | SONOMA ST: GREEN ST | - | F | F | - | F | 25328000 | 25328000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SONOMA ST | GREEN ST | 925 | 925 | 37.79985228 | -122.40621867 | GREEN ST \ SONOMA ST | SONOMA ST \ GREEN ST | 1710539427000 | MTA | STOP | GREEN ST intersection | - | 0 / 0 | - | - | - | - | - | 43108 | -3888000000 | -122.40621867 | 37.79985228 | - | - | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568900000 | SONOMA ST | - | - | - | - | - | - |
| 26030 | N/A | Point | - | - | - | - | S104424 | CASTLE ST: GREEN ST | - | F | F | - | F | 24853000 | 24853000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GREEN ST | CASTLE ST | 926 | 926 | 37.80000082 | -122.40505102 | CASTLE ST \ GREEN ST | GREEN ST \ CASTLE ST | 1710539427000 | MTA | STOP | CASTLE ST intersection | - | 0 / 0 | - | - | - | - | - | 43109 | -3801600000 | -122.40505102 | 37.80000082 | - | - | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568900000 | GREEN ST | - | - | - | - | - | - |
| 26031 | N/A | Point | - | - | - | - | S105673 | WAWONA ST: 14TH AVE | - | F | F | - | F | 22944000 | 22944000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 14TH AVE | WAWONA ST | 1934 | 1934 | 37.73850527 | -122.46966702 | WAWONA ST \ 14TH AVE | 14TH AVE \ WAWONA ST | 1726017764000 | middleware_editor | STOP | WAWONA ST intersection | - | 0 / 0 | - | - | - | - | - | 43110 | 94867200000 | -122.46966702 | 37.73850527 | - | 1520208000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569320000 | 14TH AVE | - | - | - | - | - | - |
| 26032 | N/A | Point | - | - | - | - | S104566 | IRVING ST: 46TH AVE | - | F | F | - | F | 27949000 | 27949000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 46TH AVE | 46TH AVE | 1935 | 1935 | 37.762285 | -122.50605908 | IRVING ST \ 46TH AVE | IRVING ST \ 46TH AVE | 1710539427000 | MTA | STOP | 46TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43111 | 9849600000 | -122.50605908 | 37.762285 | - | 1511913600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568960000 | IRVING ST | - | - | - | - | - | - |
| 26033 | N/A | Point | - | - | - | - | S104567 | IRVING ST: 46TH AVE | - | F | F | - | F | 27949000 | 27949000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 46TH AVE | 46TH AVE | 1936 | 1936 | 37.762285 | -122.50605908 | IRVING ST \ 46TH AVE | IRVING ST \ 46TH AVE | 1710539427000 | MTA | STOP | 46TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43112 | 9849600000 | -122.50605908 | 37.762285 | - | 1511913600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373568960000 | IRVING ST | - | - | - | - | - | - |
| 26034 | N/A | Point | - | - | - | - | S104568 | ALAMEDA ST: HENRY ADAMS ST | - | F | F | - | F | 23862000 | 23862000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HENRY ADAMS ST | ALAMEDA ST | 1937 | 1937 | 37.76859109 | -122.40387382 | ALAMEDA ST \ HENRY ADAMS ST | HENRY ADAMS ST \ ALAMEDA ST | 1753723028000 | middleware_editor | STOP | ALAMEDA ST intersection | - | 0 / 0 | - | - | - | - | - | 43113 | 10134000000 | -122.40387382 | 37.76859109 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373568960000 | HENRY ADAMS ST | - | - | - | - | - | - |
| 26035 | N/A | Point | - | - | - | - | S104569 | ALAMEDA ST: HENRY ADAMS ST | - | F | F | - | F | 23862000 | 23862000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HENRY ADAMS ST | ALAMEDA ST | 1938 | 1938 | 37.76859109 | -122.40387382 | ALAMEDA ST \ HENRY ADAMS ST | HENRY ADAMS ST \ ALAMEDA ST | 1753723031000 | middleware_editor | STOP | ALAMEDA ST intersection | - | 0 / 0 | - | - | - | - | - | 43114 | 10134000000 | -122.40387382 | 37.76859109 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568960000 | HENRY ADAMS ST | - | - | - | - | - | - |
| 26036 | N/A | Point | - | - | - | - | S104206 | BARTLETT ST: 25TH ST | - | F | F | - | F | 24087000 | 24087000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 25TH ST | BARTLETT ST | 1981 | 1981 | 37.75057261 | -122.41939968 | BARTLETT ST \ 25TH ST | 25TH ST \ BARTLETT ST | 1714767573000 | middleware_editor | ONE WAY (RA) | BARTLETT ST intersection | - | 0 / 0 | - | - | - | - | - | 43115 | -42422400000 | -122.41939968 | 37.75057261 | - | - | - | D9 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | UNKNOWN | IS | 1373568840000 | 25TH ST | - | - | - | - | - | - |
| 26037 | N/A | Point | - | - | - | - | S104207 | BEACH ST: CERVANTES BLVD \ MAL | - | F | F | - | F | 26980000 | 26980000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BEACH ST \ CERVANTES BLVD | CERVANTES BLVD \ MALLORCA WAY | 1982 | 1982 | 37.80408109 | -122.43925502 | MALLORCA WAY \ BEACH ST \ CERVANTES BLVD | BEACH ST \ CERVANTES BLVD \ MALLORCA WAY | 1710539427000 | MTA | STOP | CERVANTES BLVD \ MALLORCA WAY intersection | - | 0 / 0 | - | - | - | - | - | 43116 | -42336000000 | -122.43925502 | 37.80408109 | - | - | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568840000 | BEACH ST | - | - | - | - | - | - |
| 26038 | N/A | Point | - | - | - | - | S104208 | BEACH ST: CERVANTES BLVD \ MAL | - | F | F | - | F | 26980000 | 26980000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BEACH ST \ CERVANTES BLVD | CERVANTES BLVD \ MALLORCA WAY | 1983 | 1983 | 37.80408109 | -122.43925502 | MALLORCA WAY \ BEACH ST \ CERVANTES BLVD | BEACH ST \ CERVANTES BLVD \ MALLORCA WAY | 1710539427000 | MTA | STOP | CERVANTES BLVD \ MALLORCA WAY intersection | - | 0 / 0 | - | - | - | - | - | 43117 | -42336000000 | -122.43925502 | 37.80408109 | - | 702172800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568840000 | BEACH ST | - | - | - | - | - | - |
| 26039 | N/A | Point | - | - | - | - | S104209 | OSAGE ALY: 25TH ST | - | F | F | - | F | 24085000 | 24085000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 25TH ST | 25TH ST | 1984 | 1984 | 37.75060507 | -122.41886139 | OSAGE ALY \ 25TH ST | OSAGE ALY \ 25TH ST | 1731449439000 | middleware_editor | ONE WAY (LA) | 25TH ST intersection | - | - | - | - | - | - | - | 43118 | -42336000000 | -122.41886139 | 37.75060507 | - | 1731056400000 | - | D9 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | 3IN IRON POST | IS | 1373568840000 | OSAGE ALY | - | - | - | - | - | - |
| 26040 | N/A | Point | - | - | - | - | S104339 | FILBERT ST: BATTERY ST | - | F | F | - | F | 30719000 | 30719000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FILBERT ST | FILBERT ST | 1989 | 1989 | 37.80231058 | -122.40179365 | BATTERY ST \ FILBERT ST | BATTERY ST \ FILBERT ST | 1710539427000 | MTA | STOP | FILBERT ST intersection | - | 0 / 0 | - | - | - | - | - | 43119 | -18316800000 | -122.40179365 | 37.80231058 | - | - | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568900000 | BATTERY ST | - | - | - | - | - | - |
| 26041 | N/A | Point | - | - | - | - | S104618 | CHARLES ST: CHENERY ST | - | F | F | - | F | 21846000 | 21846000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CHARLES ST | CHENERY ST | 1991 | 1991 | 37.73835774 | -122.42607558 | CHENERY ST \ CHARLES ST | CHARLES ST \ CHENERY ST | 1710539427000 | MTA | ONE WAY (RA) | CHENERY ST intersection | - | 0 / 0 | - | - | - | - | - | 43120 | 15033600000 | -122.42607558 | 37.73835774 | - | - | - | D8 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | UNKNOWN | IS | 1373568960000 | CHARLES ST | - | - | - | - | - | - |
| 26042 | N/A | Point | 1 | 1 | 1 - 99 | - | S104619 | 1-99 EWING TER | 1-99 EWING TER | F | F | - | F | 5356000 | 5356000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MASONIC AVE | MASONIC AVE | 1992 | 1992 | 37.78009979 | -122.44776572 | - | - | 1711579172000 | middleware_editor | DEAD END | MASONIC AVE to EWING TER (1 - 99) | - | 11' W OF MASONIC | - | - | - | - | 1 | 43121 | 15120000000 | -122.44776572 | 37.78009979 | - | 1711552740000 | - | D1 | - | OTHER WARNING | WARNING | W14-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373568960000 | EWING TER | 1 - 99 EWING TER | 1 - 99 EWING TER | 1 EWING TER | - | EWING TER | EWING TER |
| 26043 | N/A | Point | - | - | - | - | S104620 | DUBOCE AVE: DIVISADERO ST | - | F | F | - | F | 26010000 | 26010000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DIVISADERO ST | 1993 | 1993 | 37.7690008 | -122.43658827 | DIVISADERO ST \ DUBOCE AVE | DUBOCE AVE \ DIVISADERO ST | 1743012707000 | middleware_editor | STOP | DIVISADERO ST intersection | - | - | - | - | - | - | - | 43122 | 15490800000 | -122.43658827 | 37.7690008 | - | 709455600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568960000 | DUBOCE AVE | - | - | - | - | - | - |
| 26044 | N/A | Point | - | - | - | - | S104622 | DIVISADERO ST: DUBOCE AVE | - | F | F | - | F | 26010000 | 26010000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DIVISADERO ST | 1994 | 1994 | 37.7690008 | -122.43658827 | DIVISADERO ST \ DUBOCE AVE | DUBOCE AVE \ DIVISADERO ST | 1743012780000 | middleware_editor | STOP | DIVISADERO ST intersection | - | 0 / AT CASTRO | - | - | - | - | - | 43123 | 15577200000 | -122.43658827 | 37.7690008 | - | 834735600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1373568960000 | DUBOCE AVE | - | - | - | - | - | - |
| 26045 | N/A | Point | - | - | - | - | S104780 | GEARY ST: TAYLOR ST | - | F | F | - | F | 24941000 | 24941000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TAYLOR ST | GEARY ST | 2489 | 2489 | 37.78693971 | -122.41151577 | GEARY ST \ TAYLOR ST | TAYLOR ST \ GEARY ST | 1710539427000 | MTA | ONE WAY (LA) | GEARY ST intersection | - | 0 / MADE GEARY ONE-WAY WB | - | - | - | - | - | 43124 | 28080000000 | -122.41151577 | 37.78693971 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | 3IN IRON POST | IS | 1373569020000 | TAYLOR ST | - | - | - | - | - | - |
| 26046 | N/A | Point | - | - | - | - | S104781 | POST ST: MASON ST | - | F | F | - | F | 24919000 | 24919000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MASON ST | POST ST | 2490 | 2490 | 37.78808219 | -122.41005693 | POST ST \ MASON ST | MASON ST \ POST ST | 1710539427000 | MTA | ONE WAY (LA) | POST ST intersection | - | 0 / MADE POST ONE WAY EB BET GOUGH-..... | - | - | - | - | - | 43125 | 28080000000 | -122.41005693 | 37.78808219 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373569020000 | MASON ST | - | - | - | - | - | - |
| 26047 | N/A | Point | - | - | - | - | S104783 | GEARY ST: SHANNON ST | - | F | F | - | F | 24962000 | 24962000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SHANNON ST | GEARY ST | 2492 | 2492 | 37.78683451 | -122.4123403 | GEARY ST \ SHANNON ST | SHANNON ST \ GEARY ST | 1710539427000 | MTA | ONE WAY (LA) | GEARY ST intersection | - | 0 / MADE GEARY ONE-WAY WB | - | - | - | - | - | 43126 | 28080000000 | -122.4123403 | 37.78683451 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373569020000 | SHANNON ST | - | - | - | - | - | - |
| 26048 | N/A | Point | - | - | - | - | S104787 | POST ST: LEAVENWORTH ST | - | T | T | - | F | 25157000 | 25157000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | POST ST | LEAVENWORTH ST | 2493 | 2493 | 37.78745384 | -122.41499542 | LEAVENWORTH ST \ POST ST | POST ST \ LEAVENWORTH ST | 1710539427000 | MTA | ONE WAY (LA) | LEAVENWORTH ST intersection | - | - | - | - | - | - | - | 43127 | 28080000000 | -122.41499542 | 37.78745384 | - | 1586995200000 | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | MUNI POLE | IS | 1373569020000 | POST ST | - | - | - | - | - | - |
| 26049 | N/A | Point | - | - | - | - | S104788 | POST ST: JONES ST | - | T | T | - | F | 24965000 | 24965000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JONES ST | JONES ST | 2494 | 2494 | 37.7876636 | -122.41335396 | POST ST \ JONES ST | POST ST \ JONES ST | 1710539427000 | MTA | ONE WAY (LA) | JONES ST intersection | - | - | - | - | - | - | - | 43128 | 28080000000 | -122.41335396 | 37.7876636 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569020000 | POST ST | - | - | - | - | - | - |
| 26050 | N/A | Point | - | - | - | - | S104789 | SUTTER ST: TAYLOR ST | - | F | F | - | F | 24958000 | 24958000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TAYLOR ST | TAYLOR ST | 2495 | 2495 | 37.78880754 | -122.41188566 | SUTTER ST \ TAYLOR ST | SUTTER ST \ TAYLOR ST | 1710539427000 | MTA | ONE WAY (LA) | TAYLOR ST intersection | - | - | - | - | - | - | - | 43129 | 28080000000 | -122.41188566 | 37.78880754 | - | 1476748800000 | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373569020000 | SUTTER ST | - | - | - | - | - | - |
| 26051 | N/A | Point | - | - | - | - | S104790 | POST ST: HYDE ST | - | F | F | - | F | 25156000 | 25156000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HYDE ST | HYDE ST | 2496 | 2496 | 37.78724521 | -122.4166387 | POST ST \ HYDE ST | POST ST \ HYDE ST | 1710539427000 | MTA | ONE WAY (LA) | HYDE ST intersection | - | 15 FT WEST OF HYDE | - | - | - | - | - | 43130 | 28080000000 | -122.4166387 | 37.78724521 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569020000 | POST ST | - | - | - | - | - | - |
| 26052 | N/A | Point | - | - | - | - | S104791 | GEARY ST: LARKIN ST | - | F | T | - | F | 25170000 | 25170000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GEARY ST | GEARY ST | 2497 | 2497 | 37.78610104 | -122.4180881 | LARKIN ST \ GEARY ST | LARKIN ST \ GEARY ST | 1750874784000 | middleware_editor | ONE WAY (LA) | GEARY ST intersection | - | - | - | - | - | - | - | 43131 | 28108800000 | -122.4180881 | 37.78610104 | - | 1750874400000 | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569020000 | LARKIN ST | - | - | - | - | - | - |
| 26053 | N/A | Point | - | - | - | - | S104792 | LEAVENWORTH ST: SUTTER ST | - | T | T | - | F | 25164000 | 25164000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SUTTER ST | SUTTER ST | 2498 | 2498 | 37.78838793 | -122.41518527 | LEAVENWORTH ST \ SUTTER ST | LEAVENWORTH ST \ SUTTER ST | 1710539427000 | MTA | ONE WAY (LA) | SUTTER ST intersection | - | - | - | - | - | - | - | 43132 | 28080000000 | -122.41518527 | 37.78838793 | - | 1586908800000 | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373569020000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 26054 | N/A | Point | - | - | - | - | S104793 | MONTGOMERY ST: POST ST | - | F | F | - | F | 24623000 | 24623000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MONTGOMERY ST | MONTGOMERY ST | 2499 | 2499 | 37.78910265 | -122.40199747 | POST ST \ MONTGOMERY ST | POST ST \ MONTGOMERY ST | 1710539427000 | MTA | ONE WAY (RA) | MONTGOMERY ST intersection | - | 0 / MADE POST ONE-WAY EB BET GOUGH-..... | - | - | - | - | - | 43133 | 28080000000 | -122.40199747 | 37.78910265 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373569020000 | POST ST | - | - | - | - | - | - |
| 26055 | N/A | Point | - | - | - | - | S104794 | SUTTER ST: MONTGOMERY ST | - | T | T | - | F | 24678000 | 24678000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SUTTER ST | SUTTER ST | 2500 | 2500 | 37.7900391 | -122.40218965 | MONTGOMERY ST \ SUTTER ST | MONTGOMERY ST \ SUTTER ST | 1722389354000 | middleware_editor | ONE WAY (RA) | SUTTER ST intersection | - | C LINE / MADE SUTTER ONE-WAY WB MAR..... | - | - | - | - | - | 43134 | 28080000000 | -122.40218965 | 37.7900391 | - | 1572998400000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569020000 | MONTGOMERY ST | - | - | - | - | - | - |
| 26056 | N/A | Point | - | - | - | - | S104795 | POST ST: KEARNY ST | - | F | F | - | F | 24644000 | 24644000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | KEARNY ST | POST ST | 2501 | 2501 | 37.78889443 | -122.40366068 | POST ST \ KEARNY ST | KEARNY ST \ POST ST | 1753723271000 | middleware_editor | ONE WAY (RA) | POST ST intersection | - | 00 / MADE POST ONE-WAY EB BET GOUGH..... | - | - | - | - | - | 43135 | 28108800000 | -122.40366068 | 37.78889443 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569020000 | KEARNY ST | - | - | - | - | - | - |
| 26057 | N/A | Point | - | - | - | - | S105582 | GIRARD ST: OLMSTEAD ST | - | F | F | - | F | 20577000 | 20577000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | OLMSTEAD ST | GIRARD ST | 2502 | 2502 | 37.72257408 | -122.40260482 | GIRARD ST \ OLMSTEAD ST | OLMSTEAD ST \ GIRARD ST | 1710539427000 | MTA | STOP | GIRARD ST intersection | - | 0 / 0 | - | - | - | - | - | 43136 | 86227200000 | -122.40260482 | 37.72257408 | - | 922233600000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569260000 | OLMSTEAD ST | - | - | - | - | - | - |
| 26058 | N/A | Point | - | - | - | - | S105584 | PEABODY ST: VISITACION AVE | - | F | F | - | F | 20344000 | 20344000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PEABODY ST | VISITACION AVE | 2503 | 2503 | 37.71119011 | -122.40701331 | VISITACION AVE \ PEABODY ST | PEABODY ST \ VISITACION AVE | 1710539427000 | MTA | STOP | VISITACION AVE intersection | - | 0 / 0 | - | - | - | - | - | 43137 | 86227200000 | -122.40701331 | 37.71119011 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569260000 | PEABODY ST | - | - | - | - | - | - |
| 26059 | N/A | Point | - | - | - | - | S105466 | MASONIC AVE: PIEDMONT ST | - | F | F | - | F | 26329000 | 26329000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MASONIC AVE | MASONIC AVE | 2505 | 2505 | 37.76595947 | -122.44417211 | PIEDMONT ST \ MASONIC AVE | PIEDMONT ST \ MASONIC AVE | 1710539427000 | MTA | STOP | MASONIC AVE intersection | - | 0 / 0 | - | - | - | - | - | 43138 | 76118400000 | -122.44417211 | 37.76595947 | - | 1666051200000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | PIEDMONT ST | - | - | - | - | - | - |
| 26060 | N/A | Point | - | - | - | - | S105588 | GIRARD ST: OLMSTEAD ST | - | F | F | - | F | 20577000 | 20577000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | OLMSTEAD ST | GIRARD ST | 2507 | 2507 | 37.72257408 | -122.40260482 | GIRARD ST \ OLMSTEAD ST | OLMSTEAD ST \ GIRARD ST | 1710539427000 | MTA | STOP | GIRARD ST intersection | - | 0 / 0 | - | - | - | - | - | 43139 | 86227200000 | -122.40260482 | 37.72257408 | - | 564796800000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569260000 | OLMSTEAD ST | - | - | - | - | - | - |
| 26061 | N/A | Point | - | - | - | - | S105589 | ALABAMA ST: 18TH ST | - | F | F | - | F | 24033000 | 24033000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 18TH ST | 18TH ST | 2508 | 2508 | 37.76164305 | -122.41205031 | ALABAMA ST \ 18TH ST | ALABAMA ST \ 18TH ST | 1736890385000 | middleware_editor | STOP | 18TH ST intersection | - | 0 / 0 | - | - | - | - | - | 43140 | 86400000000 | -122.41205031 | 37.76164305 | - | 890787600000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569260000 | ALABAMA ST | - | - | - | - | - | - |
| 26062 | N/A | Point | - | - | - | - | S105591 | LOMBARD ST: LYON ST | - | F | F | - | F | 27022000 | 27022000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LOMBARD ST | LOMBARD ST | 2509 | 2509 | 37.79845923 | -122.44730304 | LYON ST \ LOMBARD ST | LYON ST \ LOMBARD ST | 1736448965000 | middleware_editor | STOP | LOMBARD ST intersection | - | X ST IS LYON | - | - | - | - | - | 43141 | 86486400000 | -122.44730304 | 37.79845923 | - | - | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373569260000 | LYON ST | - | - | - | - | - | - |
| 26063 | N/A | Point | - | - | - | - | S105593 | NATOMA ST: MARY ST | - | F | F | - | F | 24283000 | 24283000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | NATOMA ST | NATOMA ST | 2510 | 2510 | 37.78130585 | -122.40624778 | MARY ST \ NATOMA ST | MARY ST \ NATOMA ST | 1738964751000 | middleware_editor | STOP | NATOMA ST intersection | - | 0 / 0 | - | - | - | - | - | 43142 | 86572800000 | -122.40624778 | 37.78130585 | - | 1645574400000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569260000 | MARY ST | - | - | - | - | - | - |
| 26064 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S269812 | 1000-1099 JAMESTOWN AVE | 1000-1099 JAMESTOWN AVE | F | F | - | F | 7432000 | 7432000 | - | - | SOUTH SIDE | - | - | - | - | INGALLS ST | INGALLS ST | 89705 | 89705 | 37.71902274 | -122.39448814 | - | - | 1753736045000 | middleware_editor | SPEED LIMIT 25 | INGALLS ST to JENNINGS ST (1000 - 1099) | - | 40' E OF JENNINGS | - | - | - | - | - | 43143 | 1610662320000 | -122.39448814 | 37.71902274 | - | - | - | D10 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP1 | 2IN IRON POST | IS | 1604396520000 | JAMESTOWN AVE | 1000 - 1099 JAMESTOWN AVE | 1000 - 1099 JAMESTOWN AVE | 1000 JAMESTOWN AVE | - | JENNINGS ST | JENNINGS ST |
| 26065 | N/A | Point | - | - | - | - | S269815 | JAMESTOWN AVE: IGNACIO AVE | - | F | F | - | F | 28144000 | 28144000 | - | - | CENTER ISLAND, N LINE, WESTBOUND | - | - | - | - | IGNACIO AVE | IGNACIO AVE | 89706 | 89706 | 37.71466372 | -122.3887592 | JAMESTOWN AVE \ IGNACIO AVE | JAMESTOWN AVE \ IGNACIO AVE | 1722896080000 | middleware_editor | SPEED LIMIT 25 | IGNACIO AVE intersection | - | 85' W OF OLD ENTRANCE TO CANDLE STICK | - | - | - | - | - | 43144 | 1610633640000 | -122.3887592 | 37.71466372 | - | 1682380800000 | - | D10 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP1 | 2IN IRON POST | IS | 1604398260000 | JAMESTOWN AVE | - | - | - | - | - | - |
| 26066 | N/A | Point | 1 | 1 | 3200 - 3299 | - | S269824 | 3200-3299 GOUGH ST | 3200-3299 GOUGH ST | F | F | - | F | 6352000 | 6352000 | - | - | WEST SIDE | - | - | - | - | FRANCISCO ST | FRANCISCO ST | 89707 | 89707 | 37.80325891 | -122.42830529 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 1ST & 3RD MON OF MONTH STCL | FRANCISCO ST to BAY ST (3200 - 3299) | - | NPL # 3241 | - | - | - | - | - | 43145 | - | -122.42830529 | 37.80325891 | - | - | - | D2 | - | STREET CLEANING | REG | R30B(CA).0248 | 18X18 | SUP1 | 2IN IRON POST | IS | 1604400960000 | GOUGH ST | 3200 - 3299 GOUGH ST | 3200 - 3299 GOUGH ST | 3200 GOUGH ST | - | BAY ST | BAY ST |
| 26067 | N/A | Point | 1 | 1 | 3200 - 3299 | - | S269827 | 3200-3299 GOUGH ST | 3200-3299 GOUGH ST | F | F | - | F | 6352000 | 6352000 | - | - | WEST SIDE | - | - | - | - | FRANCISCO ST | FRANCISCO ST | 89708 | 89708 | 37.80325891 | -122.42830529 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "M" PERMITS | FRANCISCO ST to BAY ST (3200 - 3299) | - | NPL #3241 GOUGH | - | - | - | - | - | 43146 | - | -122.42830529 | 37.80325891 | - | - | - | D2 | - | PARKING:RPP | REG | R32C(CA).0096 | 18X21 | SUP1 | 2IN IRON POST | IS | 1604401500000 | GOUGH ST | 3200 - 3299 GOUGH ST | 3200 - 3299 GOUGH ST | 3200 GOUGH ST | - | BAY ST | BAY ST |
| 26068 | N/A | Point | 1 | 1 | 2900 - 2999 | - | S269830 | 2900-2999 GOUGH ST | 2900-2999 GOUGH ST | F | F | - | F | 6349000 | 6349000 | - | - | WEST SIDE | - | - | - | - | GREENWICH ST | GREENWICH ST | 89709 | 89709 | 37.80044201 | -122.42773517 | - | - | 1731011106000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "KM" PERMITS | GREENWICH ST to LOMBARD ST (2900 - 2999) | - | IFO # 2901 GOUGH | - | - | - | - | - | 43147 | - | -122.42773517 | 37.80044201 | - | - | - | D2 | - | PARKING:RPP | REG | R32C(CA).0094 | 18X21 | SUP1 | 2IN IRON POST | IS | 1604404500000 | GOUGH ST | 2900 - 2999 GOUGH ST | 2900 - 2999 GOUGH ST | 2900 GOUGH ST | - | LOMBARD ST | LOMBARD ST |
| 26069 | N/A | Point | - | - | - | - | S130348 | JUDAH ST: 38TH AVE | - | F | F | - | F | 27782000 | 27782000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 38TH AVE | 38TH AVE | 89710 | 89710 | 37.76080323 | -122.49735323 | JUDAH ST \ 38TH AVE | JUDAH ST \ 38TH AVE | 1710539427000 | MTA | LEFT LANE TRAINS LEFT TURNS ONLY AT ALL TIMES | 38TH AVE intersection | - | - | - | - | - | - | - | 43148 | 1236211200000 | -122.49735323 | 37.76080323 | - | - | - | D4 | - | OTHER REGULATORY | REG | SR60-6(CA).0001 | 30X42 | SUP2 | LIGHT POLE | IS | 1373577060000 | JUDAH ST | - | - | - | - | - | - |
| 26070 | N/A | Point | 1 | 1 | 400 - 499 | - | S133668 | 400-499 GEARY ST | 400-499 GEARY ST | F | F | - | F | 6111000 | 6111000 | - | - | NORTH SIDE | - | - | - | - | MASON ST | MASON ST | 89711 | 89711 | 37.78704443 | -122.41069489 | - | - | 1726794862000 | middleware_editor | (H/C SYM) PARK ONLY/MIN FINE $250 | MASON ST to TAYLOR ST (400 - 499) | - | - | - | - | - | - | - | 43149 | 1295481600000 | -122.41069489 | 37.78704443 | - | 1467849600000 | - | D3 | - | OTHER REGULATORY | REG | R99C(CA).0001 | 12X24 | SUP1 | 2IN FLANGE POST | IS | 1373578080000 | GEARY ST | 400 - 499 GEARY ST | 400 - 499 GEARY ST | 400 GEARY ST | - | TAYLOR ST | TAYLOR ST |
| 26071 | N/A | Point | 1 | 1 | 2900 - 2999 | - | S134377 | 2900-2999 18TH ST | 2900-2999 18TH ST | F | F | - | F | 870000 | 870000 | - | - | NORTH SIDE | - | - | - | - | FLORIDA ST | FLORIDA ST | 89712 | 89712 | 37.76167196 | -122.41157026 | - | - | 1710539427000 | MTA | NPRK VEH OVER 6 FT HIGH (LA) | FLORIDA ST to ALABAMA ST (2900 - 2999) | - | 100FT.EAST OF ALABAMA | - | - | - | - | - | 43150 | 1306368000000 | -122.41157026 | 37.76167196 | - | - | - | D9 | - | PARKING | REG | R28D(CA).0009 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373578320000 | 18TH ST | 2900 - 2999 18TH ST | 2900 - 2999 18TH ST | 2900 18TH ST | - | ALABAMA ST | ALABAMA ST |
| 26072 | N/A | Point | - | - | - | - | S259257 | HAYES ST: OCTAVIA ST | - | F | F | - | F | 6817000 | 25925000 | - | - | SOUTH WEST CORNER | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 89721 | 89721 | 37.77668756 | -122.4245137 | - | HAYES ST \ OCTAVIA ST | 1754403868000 | middleware_editor | FG 300 UR DELINEATOR (W) | OCTAVIA ST intersection | - | START 10' WEST OF W-LINE, X-WALK | - | - | - | - | - | 43151 | 1576275660000 | -122.4245137 | 37.77668756 | - | 1661842800000 | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1573816560000 | HAYES ST | 500 - 599 HAYES ST | - | - | - | LAGUNA ST | - |
| 26073 | N/A | Point | - | - | - | - | S259263 | HAYES ST: OCTAVIA ST | - | T | T | - | F | 25925000 | 25925000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HAYES ST | OCTAVIA ST | 89722 | 89722 | 37.77668756 | -122.4245137 | OCTAVIA ST \ HAYES ST | HAYES ST \ OCTAVIA ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) | OCTAVIA ST intersection | - | - | - | - | - | - | - | 43152 | 1575504000000 | -122.4245137 | 37.77668756 | - | - | - | D5 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1573818180000 | HAYES ST | - | - | - | - | - | - |
| 26074 | N/A | Point | - | - | - | - | S259264 | HAYES ST: OCTAVIA ST | - | T | T | - | F | 6817000 | 25925000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 89723 | 89723 | 37.77668756 | -122.4245137 | - | HAYES ST \ OCTAVIA ST | 1710539427000 | MTA | EXCEPT BIKE (SYM) & EMERGENCY VEHICLES | OCTAVIA ST intersection | - | BELOW NO RIGHT TURN | - | - | - | - | - | 43153 | 1575504000000 | -122.4245137 | 37.77668756 | - | - | - | D5 | - | OTHER REGULATORY | REG | R(SF).0401 | 30X24 | SUP1 | LIGHT POLE | IS | 1573818300000 | HAYES ST | 500 - 599 HAYES ST | - | - | - | LAGUNA ST | - |
| 26075 | N/A | Point | - | - | - | - | S259265 | HAYES ST: OCTAVIA ST | - | T | T | - | F | 25925000 | 25925000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HAYES ST | OCTAVIA ST | 89724 | 89724 | 37.77668756 | -122.4245137 | OCTAVIA ST \ HAYES ST | HAYES ST \ OCTAVIA ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | OCTAVIA ST intersection | - | - | - | - | - | - | - | 43154 | 1575504000000 | -122.4245137 | 37.77668756 | - | - | - | D5 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1573818420000 | HAYES ST | - | - | - | - | - | - |
| 26076 | N/A | Point | - | - | - | - | S259268 | HAYES ST: OCTAVIA ST | - | T | T | - | F | 25925000 | 25925000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HAYES ST | OCTAVIA ST | 89725 | 89725 | 37.77668756 | -122.4245137 | OCTAVIA ST \ HAYES ST | HAYES ST \ OCTAVIA ST | 1710539427000 | MTA | EXCEPT BIKE (SYM) & EMERGENCY VEHICLES | OCTAVIA ST intersection | - | BELOW NO LEFT TURN | - | - | - | - | - | 43155 | 1575504000000 | -122.4245137 | 37.77668756 | - | - | - | D5 | - | OTHER REGULATORY | REG | R(SF).0401 | 30X24 | SUP1 | LIGHT POLE | IS | 1573819560000 | HAYES ST | - | - | - | - | - | - |
| 26077 | N/A | Point | 1 | 1 | 450 - 498 | - | S259271 | PNDG OCTAVIA ST | 450-498 OCTAVIA ST | T | T | - | F | 9883201 | 9883201 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LINDEN ST | LINDEN ST | 89726 | 89726 | 37.77649636 | -122.42434368 | - | - | 1710539427000 | MTA | DO NOT ENTER | LINDEN ST to HAYES ST (450 - 498) -- NORTH -- | - | 10' SOUTH OF HAYES ST. | - | - | - | - | - | 43156 | 1575627480000 | -122.42434368 | 37.77649636 | - | - | - | D5 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1573820400000 | OCTAVIA ST | PNDG OCTAVIA ST | 450 - 498 OCTAVIA ST | - | - | HAYES ST | HAYES ST |
| 26078 | N/A | Point | 1 | 1 | 450 - 498 | - | S259272 | PNDG OCTAVIA ST | 450-498 OCTAVIA ST | T | T | - | F | 9883201 | 9883201 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LINDEN ST | LINDEN ST | 89727 | 89727 | 37.77649636 | -122.42434368 | - | - | 1710539427000 | MTA | EXCEPT BIKE (SYM) & EMERGENCY VEHICLES | LINDEN ST to HAYES ST (450 - 498) -- NORTH -- | - | 10' SOUTH OF HAYES ST. | - | - | - | - | - | 43157 | 1575627540000 | -122.42434368 | 37.77649636 | - | - | - | D5 | - | OTHER REGULATORY | REG | R(SF).0401 | 30X24 | SUP1 | LIGHT POLE | IS | 1573820520000 | OCTAVIA ST | PNDG OCTAVIA ST | 450 - 498 OCTAVIA ST | - | - | HAYES ST | HAYES ST |
| 26079 | N/A | Point | - | - | - | - | S259273 | OCTAVIA ST: LINDEN ST | - | F | F | - | F | 35011000 | 35011000 | - | - | CENTER ISLAND, W LINE, SOUTHBOUND | - | - | - | - | OCTAVIA ST | LINDEN ST | 89728 | 89728 | 37.7762386 | -122.42427319 | LINDEN ST \ OCTAVIA ST | OCTAVIA ST \ LINDEN ST | 1710539427000 | MTA | PLAYGROUND (SYM) | LINDEN ST intersection | - | OPPO SWC OCTAVIA ST & LINDEN ST. | - | - | - | - | - | 43158 | 1126137600000 | -122.42427319 | 37.7762386 | - | - | - | D5 | - | OTHER WARNING | WARNING | W15-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1573824900000 | OCTAVIA ST | - | - | - | - | - | - |
| 26080 | N/A | Point | - | - | - | - | S259276 | OCTAVIA ST: LINDEN ST | - | F | F | - | F | 35011000 | 35011000 | - | - | CENTER ISLAND, W LINE, SOUTHBOUND | - | - | - | - | OCTAVIA ST | LINDEN ST | 89729 | 89729 | 37.7762386 | -122.42427319 | LINDEN ST \ OCTAVIA ST | OCTAVIA ST \ LINDEN ST | 1710539427000 | MTA | SPEED LIMIT 15 | LINDEN ST intersection | - | OPPO SWC OCTAVIA & LINDEN ST. | - | - | - | - | - | 43159 | 1126137600000 | -122.42427319 | 37.7762386 | - | - | - | D5 | - | SPEED LIMIT | REG | R2-1.0003 | 24X30 | SUP1 | LIGHT POLE | IS | 1573823820000 | OCTAVIA ST | - | - | - | - | - | - |
| 26081 | N/A | Point | - | - | - | - | S282345 | CASTRO ST: 18TH ST | - | T | T | - | F | 25813000 | 25813000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CASTRO ST | 18TH ST | 89730 | 89730 | 37.76088893 | -122.4350007 | 18TH ST \ CASTRO ST | CASTRO ST \ 18TH ST | 1710539427000 | MTA | SPEED LIMIT 20 | 18TH ST intersection | - | - | - | - | - | - | - | 43160 | 1650412800000 | -122.4350007 | 37.76088893 | - | - | - | D8 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | SIGNAL POLE | IS | 1650452280000 | CASTRO ST | - | - | - | - | - | - |
| 26082 | N/A | Point | - | - | - | - | S104427 | IRVING ST: 30TH AVE | - | F | F | - | F | 27717000 | 27717000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 30TH AVE | 30TH AVE | 929 | 929 | 37.76304254 | -122.48890973 | IRVING ST \ 30TH AVE | IRVING ST \ 30TH AVE | 1739917014000 | middleware_editor | STOP | 30TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43161 | -2678400000 | -122.48890973 | 37.76304254 | - | 1510704000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568900000 | IRVING ST | - | - | - | - | - | - |
| 26083 | N/A | Point | - | - | - | - | S104428 | IRVING ST: 30TH AVE | - | F | F | - | F | 27717000 | 27717000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 30TH AVE | 30TH AVE | 930 | 930 | 37.76304254 | -122.48890973 | IRVING ST \ 30TH AVE | IRVING ST \ 30TH AVE | 1739916998000 | middleware_editor | STOP | 30TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43162 | -2678400000 | -122.48890973 | 37.76304254 | - | 1510617600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373568900000 | IRVING ST | - | - | - | - | - | - |
| 26084 | N/A | Point | - | - | - | - | S104429 | TARAVAL ST: 24TH AVE | - | F | F | - | F | 23261000 | 23261000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 24TH AVE | 24TH AVE | 931 | 931 | 37.7428144 | -122.48104954 | TARAVAL ST \ 24TH AVE | TARAVAL ST \ 24TH AVE | 1722291040000 | middleware_editor | STOP | 24TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43163 | -2505600000 | -122.48104954 | 37.7428144 | - | - | 1721992020000 | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | RETD | 1373568900000 | TARAVAL ST | - | - | - | - | - | - |
| 26085 | N/A | Point | - | - | - | - | S104430 | TARAVAL ST: 24TH AVE | - | F | F | - | F | 23261000 | 23261000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 24TH AVE | 24TH AVE | 932 | 932 | 37.7428144 | -122.48104954 | TARAVAL ST \ 24TH AVE | TARAVAL ST \ 24TH AVE | 1722291030000 | middleware_editor | STOP | 24TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43164 | -2505600000 | -122.48104954 | 37.7428144 | - | - | 1721987520000 | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | RETD | 1373568900000 | TARAVAL ST | - | - | - | - | - | - |
| 26086 | N/A | Point | - | - | - | - | S100852 | EL CAMINO DEL MAR: 25TH AVE | - | F | F | - | F | 27662000 | 27662000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 25TH AVE | EL CAMINO DEL MAR | 934 | 934 | 37.78761184 | -122.48528346 | EL CAMINO DEL MAR \ 25TH AVE | 25TH AVE \ EL CAMINO DEL MAR | 1749236077000 | middleware_editor | STOP | EL CAMINO DEL MAR intersection | - | 0 / 0 | - | - | - | - | - | 43165 | -402163200000 | -122.48528346 | 37.78761184 | - | - | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566560000 | 25TH AVE | - | - | - | - | - | - |
| 26087 | N/A | Point | - | - | - | - | S100853 | EL CAMINO DEL MAR: 25TH AVE | - | F | F | - | F | 27662000 | 27662000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 25TH AVE | EL CAMINO DEL MAR | 935 | 935 | 37.78761184 | -122.48528346 | EL CAMINO DEL MAR \ 25TH AVE | 25TH AVE \ EL CAMINO DEL MAR | 1749236143000 | middleware_editor | STOP | EL CAMINO DEL MAR intersection | - | 0 / 0 | - | - | - | - | - | 43166 | -402163200000 | -122.48528346 | 37.78761184 | - | - | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566560000 | 25TH AVE | - | - | - | - | - | - |
| 26088 | N/A | Point | - | - | - | - | S100854 | 28TH AVE: CALIFORNIA ST | - | F | F | - | F | 28017000 | 28017000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 936 | 936 | 37.78373715 | -122.48821745 | 28TH AVE \ CALIFORNIA ST | 28TH AVE \ CALIFORNIA ST | 1720055654000 | middleware_editor | STOP | CALIFORNIA ST intersection | - | 00 / 00 | - | - | - | - | - | 43167 | -402192000000 | -122.48821745 | 37.78373715 | - | 1479859200000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | 28TH AVE | - | - | - | - | - | - |
| 26089 | N/A | Point | - | - | - | - | S100183 | SAN FERNANDO WAY: DARIEN WAY | - | F | F | - | F | 22792000 | 22792000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DARIEN WAY | DARIEN WAY | 937 | 937 | 37.73187808 | -122.46962477 | SAN FERNANDO WAY \ DARIEN WAY | SAN FERNANDO WAY \ DARIEN WAY | 1756400609000 | middleware_editor | ONE WAY (LA) | DARIEN WAY intersection | - | 0 / 0 | - | - | - | - | - | 43168 | -405100800000 | -122.46962477 | 37.73187808 | - | - | - | D7 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | UNKNOWN | IS | 1373566380000 | SAN FERNANDO WAY | - | - | - | - | - | - |
| 26090 | N/A | Point | - | - | - | - | S100188 | DARIEN WAY: SAN FERNANDO WAY | - | F | F | - | F | 22792000 | 22792000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DARIEN WAY | DARIEN WAY | 938 | 938 | 37.73187808 | -122.46962477 | SAN FERNANDO WAY \ DARIEN WAY | SAN FERNANDO WAY \ DARIEN WAY | 1756401455000 | middleware_editor | ONE WAY (RA) | DARIEN WAY intersection | - | - | - | - | - | - | - | 43169 | -405100800000 | -122.46962477 | 37.73187808 | - | - | - | D7 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | 2IN IRON POST | IS | 1373566380000 | SAN FERNANDO WAY | - | - | - | - | - | - |
| 26091 | N/A | Point | - | - | - | - | S100189 | SAN FERNANDO WAY: DARIEN WAY | - | F | F | - | F | 22792000 | 22792000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DARIEN WAY | DARIEN WAY | 939 | 939 | 37.73187808 | -122.46962477 | SAN FERNANDO WAY \ DARIEN WAY | SAN FERNANDO WAY \ DARIEN WAY | 1710539427000 | MTA | ONE WAY (RA) | DARIEN WAY intersection | - | 0 / 0 | - | - | - | - | - | 43170 | -405129600000 | -122.46962477 | 37.73187808 | - | 1594598400000 | - | D7 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | 2IN IRON POST | IS | 1373566380000 | SAN FERNANDO WAY | - | - | - | - | - | - |
| 26092 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S100190 | 1800-1899 POWELL ST | 1800-1899 POWELL ST | F | F | - | F | 10698000 | 10698000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | FILBERT ST | FILBERT ST | 940 | 940 | 37.80163524 | -122.41111056 | - | - | 1710539427000 | MTA | DO NOT ENTER | FILBERT ST to GREENWICH ST (1800 - 1899) | - | S LINE / MADE NORTHBOUND ONE WAY | - | - | - | - | - | 43171 | -404956800000 | -122.41111056 | 37.80163524 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373566380000 | POWELL ST | 1800 - 1899 POWELL ST | 1800 - 1899 POWELL ST | 1800 POWELL ST | - | GREENWICH ST | GREENWICH ST |
| 26093 | N/A | Point | - | - | - | - | S100191 | MONTECITO AVE: MONTEREY BLVD | - | F | F | - | F | 22257000 | 22257000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MONTEREY BLVD | MONTEREY BLVD | 941 | 941 | 37.73148841 | -122.45359091 | MONTECITO AVE \ MONTEREY BLVD | MONTECITO AVE \ MONTEREY BLVD | 1726085094000 | middleware_editor | STOP | MONTEREY BLVD intersection | - | 0 / 0 | - | - | - | - | - | 43172 | -404870400000 | -122.45359091 | 37.73148841 | - | 1418601600000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373566380000 | MONTECITO AVE | - | - | - | - | - | - |
| 26094 | N/A | Point | - | - | - | - | S101303 | INNES AVE: 3RD ST | - | F | F | - | F | 20229000 | 20229000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | INNES AVE | INNES AVE | 982 | 982 | 37.73953345 | -122.38903097 | 3RD ST \ INNES AVE | 03RD ST \ INNES AVE | 1710539427000 | MTA | STOP | INNES AVE intersection | - | 0 / 0 | - | - | - | - | - | 43173 | -398822400000 | -122.38903097 | 37.73953345 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566740000 | 03RD ST | - | - | - | - | - | - |
| 26095 | N/A | Point | - | - | - | - | S104623 | DIVISADERO ST: DUBOCE AVE | - | F | F | - | F | 26010000 | 26010000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DIVISADERO ST | 1995 | 1995 | 37.7690008 | -122.43658827 | DIVISADERO ST \ DUBOCE AVE | DUBOCE AVE \ DIVISADERO ST | 1743012783000 | middleware_editor | STOP | DIVISADERO ST intersection | - | 0 / 0 | - | - | - | - | - | 43174 | 15577200000 | -122.43658827 | 37.7690008 | - | 685695600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373568960000 | DUBOCE AVE | - | - | - | - | - | - |
| 26096 | N/A | Point | - | - | - | - | S104624 | BAKER ST: TURK BLVD \ TURK ST | - | F | F | - | F | 26362000 | 26362000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BAKER ST \ TURK BLVD | BAKER ST \ TURK BLVD | 1996 | 1996 | 37.77924403 | -122.44205331 | TURK ST \ BAKER ST \ TURK BLVD | TURK ST \ BAKER ST \ TURK BLVD | 1710539427000 | MTA | STOP | BAKER ST \ TURK BLVD intersection | - | 0 / 0 | - | - | - | - | - | 43175 | 15552000000 | -122.44205331 | 37.77924403 | - | 1202428800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568960000 | TURK ST | - | - | - | - | - | - |
| 26097 | N/A | Point | - | - | - | - | S106082 | ROLPH ST: MISSION ST | - | F | F | - | F | 21485000 | 21485000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ROLPH ST | MISSION ST | 2002 | 2002 | 37.71575345 | -122.44155428 | MISSION ST \ ROLPH ST | ROLPH ST \ MISSION ST | 1710539427000 | MTA | DO NOT ENTER | MISSION ST intersection | - | 0 / MADE ROLPH 1-WAY EB BET MISSION..... | - | - | - | - | - | 43176 | 120700800000 | -122.44155428 | 37.71575345 | - | 1537228800000 | - | D11 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP2 | UTILITY POLE | IS | 1373569440000 | ROLPH ST | - | - | - | - | - | - |
| 26098 | N/A | Point | - | - | - | - | S106084 | ROLPH ST: MISSION ST | - | F | F | - | F | 21485000 | 21485000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ROLPH ST | MISSION ST | 2004 | 2004 | 37.71575345 | -122.44155428 | MISSION ST \ ROLPH ST | ROLPH ST \ MISSION ST | 1710539427000 | MTA | ONE WAY (LA) | MISSION ST intersection | - | - | - | - | - | - | - | 43177 | 120700800000 | -122.44155428 | 37.71575345 | - | 1537228800000 | - | D11 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP2 | SIGNAL POLE | IS | 1373569440000 | ROLPH ST | - | - | - | - | - | - |
| 26099 | N/A | Point | 1 | 1 | 272 - 299 | - | S106086 | 272-299 ROLPH ST | 272-299 ROLPH ST | F | F | - | F | 11121000 | 11121000 | - | - | NORTH SIDE, NORTHBOUND TRAFFIC | - | - | - | - | MORSE ST | MORSE ST | 2006 | 2006 | 37.71360643 | -122.4367681 | - | - | 1756135404000 | middleware_editor | ONE WAY (LA) | MORSE ST to NAPLES ST (272 - 299) | - | 287 EPL/MADE ROLPH ONE-WAY WB BET M..... | - | - | - | - | - | 43178 | 120729600000 | -122.4367681 | 37.71360643 | - | - | - | D11 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | 2IN IRON POST | IS | 1373569440000 | ROLPH ST | 272 - 299 ROLPH ST | 272 - 299 ROLPH ST | 272 ROLPH ST | - | NAPLES ST | NAPLES ST |
| 26100 | N/A | Point | - | - | - | - | S106087 | ROLPH ST: MISSION ST | - | F | F | - | F | 21485000 | 21485000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ROLPH ST | MISSION ST | 2007 | 2007 | 37.71575345 | -122.44155428 | MISSION ST \ ROLPH ST | ROLPH ST \ MISSION ST | 1710539427000 | MTA | ONE WAY (RA) | MISSION ST intersection | - | - | - | - | - | - | - | 43179 | 120700800000 | -122.44155428 | 37.71575345 | - | 1537228800000 | - | D11 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | UTILITY POLE | IS | 1373569440000 | ROLPH 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