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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27076 | N/A | Point | - | - | - | - | S109040 | CALIFORNIA ST: JONES ST | - | F | F | - | F | 25091000 | 25091000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 5713 | 5713 | 37.79141648 | -122.4141073 | JONES ST \ CALIFORNIA ST | JONES ST \ CALIFORNIA ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | CALIFORNIA ST intersection | - | 0 / 0 | - | - | - | - | - | 44156 | 396403200000 | -122.4141073 | 37.79141648 | - | - | - | D3 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373570400000 | JONES ST | - | - | - | - | - | - |
| 27077 | N/A | Point | - | - | - | - | S109041 | CALIFORNIA ST: JONES ST | - | F | F | - | F | 25091000 | 25091000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 5714 | 5714 | 37.79141648 | -122.4141073 | JONES ST \ CALIFORNIA ST | JONES ST \ CALIFORNIA ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | CALIFORNIA ST intersection | - | 0 / 0 | - | - | - | - | - | 44157 | 396403200000 | -122.4141073 | 37.79141648 | - | - | - | D3 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373570400000 | JONES ST | - | - | - | - | - | - |
| 27078 | N/A | Point | - | - | - | - | S109045 | 18TH ST: COLLINGWOOD ST | - | F | F | - | F | 25815000 | 25815000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 18TH ST | COLLINGWOOD ST | 5717 | 5717 | 37.760824 | -122.43611411 | COLLINGWOOD ST \ 18TH ST | 18TH ST \ COLLINGWOOD ST | 1755880649000 | middleware_editor | STOP | COLLINGWOOD ST intersection | - | 0 / 00 | - | - | - | - | - | 44158 | 398674800000 | -122.43611411 | 37.760824 | - | 1755805500000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | MUNI POLE | IS | 1373570400000 | 18TH ST | - | - | - | - | - | - |
| 27079 | N/A | Point | - | - | - | - | S109046 | MIDDLEFIELD DR: OCEAN AVE | - | F | F | - | F | 23133000 | 23133000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MIDDLEFIELD DR | OCEAN AVE | 5718 | 5718 | 37.73223799 | -122.48627419 | OCEAN AVE \ MIDDLEFIELD DR | MIDDLEFIELD DR \ OCEAN AVE | 1737657878000 | middleware_editor | STOP | OCEAN AVE intersection | - | 0 / 0 | - | - | - | - | - | 44159 | 398908800000 | -122.48627419 | 37.73223799 | - | 1533081600000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570400000 | MIDDLEFIELD DR | - | - | - | - | - | - |
| 27080 | N/A | Point | - | - | - | - | S109047 | MIDDLEFIELD DR: OCEAN AVE | - | F | F | - | F | 23133000 | 23133000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MIDDLEFIELD DR | OCEAN AVE | 5719 | 5719 | 37.73223799 | -122.48627419 | OCEAN AVE \ MIDDLEFIELD DR | MIDDLEFIELD DR \ OCEAN AVE | 1738192505000 | middleware_editor | STOP | OCEAN AVE intersection | - | 0 / 0 | - | - | - | - | - | 44160 | 398908800000 | -122.48627419 | 37.73223799 | - | 1738145340000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570400000 | MIDDLEFIELD DR | - | - | - | - | - | - |
| 27081 | N/A | Point | - | - | - | - | S109050 | GOLDEN GATE AVE: BRODERICK ST | - | F | F | - | F | 26073000 | 26073000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BRODERICK ST | BRODERICK ST | 5722 | 5722 | 37.77851146 | -122.44021334 | GOLDEN GATE AVE \ BRODERICK ST | GOLDEN GATE AVE \ BRODERICK ST | 1720634694000 | middleware_editor | STOP | BRODERICK ST intersection | - | 0 / 00 | - | - | - | - | - | 44161 | 398908800000 | -122.44021334 | 37.77851146 | - | - | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570400000 | GOLDEN GATE AVE | - | - | - | - | - | - |
| 27082 | N/A | Point | - | - | - | - | S109051 | GOLDEN GATE AVE: BRODERICK ST | - | F | F | - | F | 26073000 | 26073000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BRODERICK ST | BRODERICK ST | 5723 | 5723 | 37.77851146 | -122.44021334 | GOLDEN GATE AVE \ BRODERICK ST | GOLDEN GATE AVE \ BRODERICK ST | 1720634705000 | middleware_editor | STOP | BRODERICK ST intersection | - | 0 / 00 | - | - | - | - | - | 44162 | 398908800000 | -122.44021334 | 37.77851146 | - | 1585785600000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570400000 | GOLDEN GATE AVE | - | - | - | - | - | - |
| 27083 | N/A | Point | - | - | - | - | S109052 | RAMSELL ST: GARFIELD ST | - | F | F | - | F | 22700000 | 22700000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RAMSELL ST | GARFIELD ST | 5724 | 5724 | 37.71967859 | -122.46625434 | GARFIELD ST \ RAMSELL ST | RAMSELL ST \ GARFIELD ST | 1710539427000 | MTA | STOP | GARFIELD ST intersection | - | 0 / 0 | - | - | - | - | - | 44163 | 398908800000 | -122.46625434 | 37.71967859 | - | 1602720000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570400000 | RAMSELL ST | - | - | - | - | - | - |
| 27084 | N/A | Point | - | - | - | - | S109053 | RAMSELL ST: GARFIELD ST | - | F | F | - | F | 22700000 | 22700000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | RAMSELL ST | GARFIELD ST | 5725 | 5725 | 37.71967859 | -122.46625434 | GARFIELD ST \ RAMSELL ST | RAMSELL ST \ GARFIELD ST | 1710539427000 | MTA | STOP | GARFIELD ST intersection | - | 0 / 0 | - | - | - | - | - | 44164 | 398908800000 | -122.46625434 | 37.71967859 | - | 1602720000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570400000 | RAMSELL ST | - | - | - | - | - | - |
| 27085 | N/A | Point | - | 1 | 200 - 249 | - | S109447 | 200-249 LOMBARD ST | 200-249 LOMBARD ST | F | F | - | F | 8433000 | 8433000 | - | - | NORTH SIDE, NORTHBOUND TRAFFIC | - | - | - | - | MONTGOMERY ST | MONTGOMERY ST | 8078 | 8078 | 37.80374479 | -122.405339 | - | - | 1710539427000 | MTA | ONE WAY (RA) | MONTGOMERY ST to WINTHROP ST (200 - 249) | - | 50E / MAKE ONE WAY EAST BOUND | - | - | - | - | - | 44165 | 488678400000 | -122.405339 | 37.80374479 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | 2IN IRON POST | IS | 1373570520000 | LOMBARD ST | 200 - 249 LOMBARD ST | 200 - 249 LOMBARD ST | 200 LOMBARD ST | - | WINTHROP ST | WINTHROP ST |
| 27086 | N/A | Point | - | - | - | - | S109451 | LOMBARD ST: SANSOME ST | - | F | F | - | F | 24870000 | 24870000 | - | - | NORTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SANSOME ST | SANSOME ST | 8082 | 8082 | 37.80403013 | -122.40334871 | LOMBARD ST \ SANSOME ST | LOMBARD ST \ SANSOME ST | 1710539427000 | MTA | STOP | SANSOME ST intersection | - | 0 / MAKE ONE WAY EAST BOUND | - | - | - | - | - | 44166 | 489024000000 | -122.40334871 | 37.80403013 | - | 1683849600000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373570520000 | LOMBARD ST | - | - | - | - | - | - |
| 27087 | N/A | Point | - | - | - | - | S110929 | 20TH ST: VERMONT ST | - | F | F | - | F | 23757000 | 23757000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VERMONT ST | 20TH ST | 8132 | 8132 | 37.75955913 | -122.4040106 | 20TH ST \ VERMONT ST | VERMONT ST \ 20TH ST | 1710539427000 | MTA | STOP | 20TH ST intersection | - | - | - | - | - | - | - | 44167 | 718329600000 | -122.4040106 | 37.75955913 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570940000 | VERMONT ST | - | - | - | - | - | - |
| 27088 | N/A | Point | - | - | - | - | S110930 | 20TH ST: VERMONT ST | - | F | F | - | F | 23757000 | 23757000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VERMONT ST | 20TH ST | 8133 | 8133 | 37.75955913 | -122.4040106 | 20TH ST \ VERMONT ST | VERMONT ST \ 20TH ST | 1710539427000 | MTA | STOP | 20TH ST intersection | - | MADE ALL-WAY STOP | - | - | - | - | - | 44168 | 718329600000 | -122.4040106 | 37.75955913 | - | 1490832000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570940000 | VERMONT ST | - | - | - | - | - | - |
| 27089 | N/A | Point | - | - | - | - | S110931 | VERMONT ST: 20TH ST | - | F | F | - | F | 23757000 | 23757000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VERMONT ST | 20TH ST | 8134 | 8134 | 37.75955913 | -122.4040106 | 20TH ST \ VERMONT ST | VERMONT ST \ 20TH ST | 1710539427000 | MTA | STOP | 20TH ST intersection | - | MADE ALL-WAY STOP | - | - | - | - | - | 44169 | 718329600000 | -122.4040106 | 37.75955913 | - | 890870400000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570940000 | VERMONT ST | - | - | - | - | - | - |
| 27090 | N/A | Point | - | - | - | - | S110935 | LARKIN ST: FRANK NORRIS ST | - | F | F | - | F | 25205000 | 25205000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FRANK NORRIS ST | FRANK NORRIS ST | 8136 | 8136 | 37.78937563 | -122.41875045 | LARKIN ST \ FRANK NORRIS ST | LARKIN ST \ FRANK NORRIS ST | 1710539427000 | MTA | ONE WAY (LA) | FRANK NORRIS ST intersection | - | - | - | - | - | - | - | 44170 | 718502400000 | -122.41875045 | 37.78937563 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373570940000 | LARKIN ST | - | - | - | - | - | - |
| 27091 | N/A | Point | - | - | - | - | S110937 | BALBOA ST: 39TH AVE | - | F | F | - | F | 27887000 | 27887000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BALBOA ST | BALBOA ST | 8137 | 8137 | 37.77561787 | -122.49945481 | 39TH AVE \ BALBOA ST | 39TH AVE \ BALBOA ST | 1731939989000 | middleware_editor | STOP | BALBOA ST intersection | - | - | - | - | - | - | - | 44171 | 719625600000 | -122.49945481 | 37.77561787 | - | 1731679740000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373570940000 | 39TH AVE | - | - | - | - | - | - |
| 27092 | N/A | Point | - | - | - | - | S110940 | RICHLAND AVE: MURRAY ST | - | F | F | - | F | 21232000 | 21232000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MURRAY ST | MURRAY ST | 8139 | 8139 | 37.73577688 | -122.42016347 | RICHLAND AVE \ MURRAY ST | RICHLAND AVE \ MURRAY ST | 1713298856000 | middleware_editor | STOP | MURRAY ST intersection | - | - | - | - | - | - | - | 44172 | 720835200000 | -122.42016347 | 37.73577688 | - | 857520000000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570940000 | RICHLAND AVE | - | - | - | - | - | - |
| 27093 | N/A | Point | - | - | - | - | S109599 | WASHINGTON ST: MAPLE ST | - | F | F | - | F | 26949000 | 26949000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 8141 | 8141 | 37.78888837 | -122.45559514 | MAPLE ST \ WASHINGTON ST | MAPLE ST \ WASHINGTON ST | 1710539427000 | MTA | STOP | WASHINGTON ST intersection | - | 0 / 00 | - | - | - | - | - | 44173 | 525484800000 | -122.45559514 | 37.78888837 | - | 1516233600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570520000 | MAPLE ST | - | - | - | - | - | - |
| 27094 | N/A | Point | - | - | - | - | S109600 | BALBOA ST: 48TH AVE | - | F | F | - | F | 28006000 | 28006000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BALBOA ST | 48TH AVE | 8142 | 8142 | 37.77517682 | -122.50909196 | 48TH AVE \ BALBOA ST | BALBOA ST \ 48TH AVE | 1746727052000 | middleware_editor | STOP | 48TH AVE intersection | - | 0 / 00 | - | - | - | - | - | 44174 | 525510000000 | -122.50909196 | 37.77517682 | - | 1684911600000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1373570520000 | BALBOA ST | - | - | - | - | - | - |
| 27095 | N/A | Point | - | - | - | - | S108879 | ROUSSEAU ST: BOSWORTH ST | - | F | F | - | F | 21859000 | 21859000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ROUSSEAU ST | BOSWORTH ST | 8144 | 8144 | 37.73331313 | -122.43027782 | BOSWORTH ST \ ROUSSEAU ST | ROUSSEAU ST \ BOSWORTH ST | 1710539427000 | MTA | DO NOT ENTER | BOSWORTH ST intersection | - | 0 / REVERSE 1-WAY FROM WB TO EB BOS..... | - | - | - | - | - | 44175 | 362534400000 | -122.43027782 | 37.73331313 | - | - | - | D8 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP2 | UNKNOWN | IS | 1373570340000 | ROUSSEAU ST | - | - | - | - | - | - |
| 27096 | N/A | Point | - | - | - | - | S108881 | ROUSSEAU ST: BOSWORTH ST | - | F | F | - | F | 21859000 | 21859000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ROUSSEAU ST | BOSWORTH ST | 8145 | 8145 | 37.73331313 | -122.43027782 | BOSWORTH ST \ ROUSSEAU ST | ROUSSEAU ST \ BOSWORTH ST | 1710539427000 | MTA | ONE WAY (LA) | BOSWORTH ST intersection | - | 0 / REVERSED 1-WAY WB-EB SAN JOSE-B..... | - | - | - | - | - | 44176 | 362534400000 | -122.43027782 | 37.73331313 | - | - | - | D8 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | UNKNOWN | IS | 1373570340000 | ROUSSEAU ST | - | - | - | - | - | - |
| 27097 | N/A | Point | 1 | 1 | 200 - 299 | - | S113756 | 200-299 GEARY ST | 200-299 GEARY ST | F | F | - | F | 6109000 | 6109000 | - | - | SOUTH SIDE | - | - | - | - | STOCKTON ST | STOCKTON ST | 15271 | 15271 | 37.78746364 | -122.40740831 | - | - | 1710539427000 | MTA | TANS EXC 30 MIN TL 7AM-6PM MON-SAT | STOCKTON ST to POWELL ST (200 - 299) | - | PM#231 | - | - | - | - | - | 44177 | 995932800000 | -122.40740831 | 37.78746364 | - | - | - | D3 | - | OTHER REGULATORY | REG | R37(SF).0208 | 10X15 | SUP1 | PARKING METER | IS | 1373571840000 | GEARY ST | 200 - 299 GEARY ST | 200 - 299 GEARY ST | 200 GEARY ST | - | POWELL ST | POWELL ST |
| 27098 | N/A | Point | 1 | 1 | 200 - 299 | - | S113757 | 200-299 GEARY ST | 200-299 GEARY ST | F | F | - | F | 6109000 | 6109000 | - | - | SOUTH SIDE | - | - | - | - | STOCKTON ST | STOCKTON ST | 15272 | 15272 | 37.78746364 | -122.40740831 | - | - | 1710539427000 | MTA | TANS EXC 30 MIN TL 7AM-6PM MON-SAT | STOCKTON ST to POWELL ST (200 - 299) | - | PM#233 | - | - | - | - | - | 44178 | 995932800000 | -122.40740831 | 37.78746364 | - | - | - | D3 | - | OTHER REGULATORY | REG | R37(SF).0208 | 10X15 | SUP1 | PARKING METER | IS | 1373571840000 | GEARY ST | 200 - 299 GEARY ST | 200 - 299 GEARY ST | 200 GEARY ST | - | POWELL ST | POWELL ST |
| 27099 | N/A | Point | - | - | - | - | S113758 | CLAY ST: DAVIS ST | - | F | T | - | F | 30050000 | 30050000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLAY ST | DAVIS ST | 15273 | 15273 | 37.7953892413649 | -122.397914064546 | DAVIS ST \ CLAY ST | CLAY ST \ DAVIS ST | 1748468744000 | middleware_editor | CLAY ST | DAVIS ST intersection | - | - | - | - | - | - | - | 44179 | 996044400000 | -122.39797475 | 37.79531294 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-2.0114 | 72X18 | SUP1 | LIGHT POLE | IS | 1373571840000 | CLAY ST | - | - | - | - | - | - |
| 27100 | N/A | Point | - | - | - | - | S118469 | DARTMOUTH ST: SILLIMAN ST | - | F | F | - | F | 20918000 | 20918000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DARTMOUTH ST | DARTMOUTH ST | 15274 | 15274 | 37.72917262 | -122.41298549 | SILLIMAN ST \ DARTMOUTH ST | SILLIMAN ST \ DARTMOUTH ST | 1718050358000 | middleware_editor | ALL WAY | DARTMOUTH ST intersection | - | - | - | - | - | - | - | 44180 | 1078444800000 | -122.41298549 | 37.72917262 | - | - | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573340000 | SILLIMAN ST | - | - | - | - | - | - |
| 27101 | N/A | Point | - | - | - | - | S118470 | HAMILTON ST: BURROWS ST | - | F | F | - | F | 20914000 | 20914000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BURROWS ST | BURROWS ST | 15275 | 15275 | 37.72728415 | -122.41002238 | HAMILTON ST \ BURROWS ST | HAMILTON ST \ BURROWS ST | 1726154220000 | middleware_editor | ALL WAY | BURROWS ST intersection | - | - | - | - | - | - | - | 44181 | 1078444800000 | -122.41002238 | 37.72728415 | - | - | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573340000 | HAMILTON ST | - | - | - | - | - | - |
| 27102 | N/A | Point | - | - | - | - | S118471 | HAMILTON ST: BURROWS ST | - | F | F | - | F | 20914000 | 20914000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BURROWS ST | BURROWS ST | 15276 | 15276 | 37.72728415 | -122.41002238 | HAMILTON ST \ BURROWS ST | HAMILTON ST \ BURROWS ST | 1734101080000 | middleware_editor | ALL WAY | BURROWS ST intersection | - | - | - | - | - | - | - | 44182 | 1078444800000 | -122.41002238 | 37.72728415 | - | - | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573340000 | HAMILTON ST | - | - | - | - | - | - |
| 27103 | N/A | Point | - | - | - | - | S118472 | ILLINOIS ST: CESAR CHAVEZ ST | - | F | F | - | F | 23534000 | 23534000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CESAR CHAVEZ ST | CESAR CHAVEZ ST | 15277 | 15277 | 37.75032504 | -122.3865683 | ILLINOIS ST \ CESAR CHAVEZ ST | ILLINOIS ST \ CESAR CHAVEZ ST | 1710539427000 | MTA | ALL WAY | CESAR CHAVEZ ST intersection | - | - | - | - | - | - | - | 44183 | 1078444800000 | -122.3865683 | 37.75032504 | - | - | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373573340000 | ILLINOIS ST | - | - | - | - | - | - |
| 27104 | N/A | Point | - | - | - | - | S118473 | ILLINOIS ST: CESAR CHAVEZ ST | - | F | F | - | F | 23534000 | 23534000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CESAR CHAVEZ ST | CESAR CHAVEZ ST | 15278 | 15278 | 37.75032504 | -122.3865683 | ILLINOIS ST \ CESAR CHAVEZ ST | ILLINOIS ST \ CESAR CHAVEZ ST | 1710539427000 | MTA | ALL WAY | CESAR CHAVEZ ST intersection | - | - | - | - | - | - | - | 44184 | 1078444800000 | -122.3865683 | 37.75032504 | - | - | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373573340000 | ILLINOIS ST | - | - | - | - | - | - |
| 27105 | N/A | Point | - | - | - | - | S118474 | BURROWS ST: HAMILTON ST | - | F | F | - | F | 20914000 | 20914000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BURROWS ST | BURROWS ST | 15279 | 15279 | 37.72728415 | -122.41002238 | HAMILTON ST \ BURROWS ST | HAMILTON ST \ BURROWS ST | 1734101076000 | middleware_editor | ALL WAY | BURROWS ST intersection | - | - | - | - | - | - | - | 44185 | 1078444800000 | -122.41002238 | 37.72728415 | - | - | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573340000 | HAMILTON ST | - | - | - | - | - | - |
| 27106 | N/A | Point | - | - | - | - | S120231 | IRVING ST: 30TH AVE | - | F | F | - | F | 27717000 | 27717000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 30TH AVE | 30TH AVE | 15315 | 15315 | 37.76304254 | -122.48890973 | IRVING ST \ 30TH AVE | IRVING ST \ 30TH AVE | 1739917004000 | middleware_editor | ALL WAY | 30TH AVE intersection | - | - | - | - | - | - | - | 44186 | 1107129600000 | -122.48890973 | 37.76304254 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1373573880000 | IRVING ST | - | - | - | - | - | - |
| 27107 | N/A | Point | - | - | - | - | S120232 | IRVING ST: 30TH AVE | - | F | F | - | F | 27717000 | 27717000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 30TH AVE | 30TH AVE | 15316 | 15316 | 37.76304254 | -122.48890973 | IRVING ST \ 30TH AVE | IRVING ST \ 30TH AVE | 1739916996000 | middleware_editor | ALL WAY | 30TH AVE intersection | - | - | - | - | - | - | - | 44187 | 1107129600000 | -122.48890973 | 37.76304254 | - | 1680048000000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1373573880000 | IRVING ST | - | - | - | - | - | - |
| 27108 | N/A | Point | 1 | 1 | 374 - 433 | - | S120233 | 374-433 PANORAMA DR | 374-433 PANORAMA DR | F | F | - | F | 10240000 | 10240000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | OLYMPIA WAY | OLYMPIA WAY | 15317 | 15317 | 37.75179563 | -122.45201208 | - | - | 1710539427000 | MTA | ALL WAY | OLYMPIA WAY to STARVIEW WAY (374 - 433) | - | OPPOSITE EPL #1 OLYMPIA | - | - | - | - | - | 44188 | 1107129600000 | -122.45201208 | 37.75179563 | - | 1635206400000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573880000 | PANORAMA DR | 374 - 433 PANORAMA DR | 374 - 433 PANORAMA DR | 374 PANORAMA DR | - | STARVIEW WAY | STARVIEW WAY |
| 27109 | N/A | Point | - | - | - | - | S122120 | STEVENSON ST: ECKER ST | - | F | F | - | F | 24607000 | 24607000 | - | - | NORTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ECKER ST | STEVENSON ST | 15318 | 15318 | 37.78997051 | -122.39935006 | STEVENSON ST \ ECKER ST | ECKER ST \ STEVENSON ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | STEVENSON ST intersection | - | - | - | - | - | - | - | 44189 | 1133568000000 | -122.39935006 | 37.78997051 | - | 1628812800000 | - | D6 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | LIGHT POLE | IS | 1373574480000 | ECKER ST | - | - | - | - | - | - |
| 27110 | N/A | Point | - | - | - | - | S122121 | STEVENSON ST: ECKER ST | - | F | F | - | F | 24607000 | 24607000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ECKER ST | STEVENSON ST | 15319 | 15319 | 37.78997051 | -122.39935006 | STEVENSON ST \ ECKER ST | ECKER ST \ STEVENSON ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | STEVENSON ST intersection | - | - | - | - | - | - | - | 44190 | 1133568000000 | -122.39935006 | 37.78997051 | - | 1628812800000 | - | D6 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373574480000 | ECKER ST | - | - | - | - | - | - |
| 27111 | N/A | Point | - | - | - | - | S122122 | 2ND ST: STILLMAN ST | - | F | F | - | F | 24492000 | 24492000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | STILLMAN ST | 02ND ST | 15320 | 15320 | 37.78350351 | -122.39415052 | 2ND ST \ STILLMAN ST | STILLMAN ST \ 02ND ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | 02ND ST intersection | - | ON PED BEACON POLE | - | - | - | - | - | 44191 | 1133568000000 | -122.39415052 | 37.78350351 | - | 1629158400000 | - | D6 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373574480000 | STILLMAN ST | - | - | - | - | - | - |
| 27112 | N/A | Point | - | - | - | - | S122125 | EUCALYPTUS DR: SYLVAN DR | - | F | F | - | F | 23131000 | 23131000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SYLVAN DR | EUCALYPTUS DR | 15321 | 15321 | 37.7310149878222 | -122.485207021231 | EUCALYPTUS DR \ SYLVAN DR | SYLVAN DR \ EUCALYPTUS DR | 1750771335000 | middleware_editor | STOP | EUCALYPTUS DR intersection | - | - | - | - | - | - | - | 44192 | 1133769600000 | -122.4853015 | 37.73094609 | - | 1738190280000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373574480000 | SYLVAN DR | - | - | - | - | - | - |
| 27113 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S122126 | 1300-1399 EUCALYPTUS DR | 1300-1399 EUCALYPTUS DR | F | F | - | F | 5281000 | 5281000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SYLVAN DR | SYLVAN DR | 15322 | 15322 | 37.73091264 | -122.48574042 | - | - | 1736892871000 | middleware_editor | STOP | SYLVAN DR to MIDDLEFIELD DR (1300 - 1399) | - | OPP.NW CORNOR | - | - | - | - | - | 44193 | 1133740800000 | -122.48574042 | 37.73091264 | - | 1402444800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373574480000 | EUCALYPTUS DR | 1300 - 1399 EUCALYPTUS DR | 1300 - 1399 EUCALYPTUS DR | 1300 EUCALYPTUS DR | - | MIDDLEFIELD DR | MIDDLEFIELD DR |
| 27114 | N/A | Point | - | - | - | - | S122127 | EUCALYPTUS DR: SYLVAN DR | - | F | F | - | F | 23131000 | 23131000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SYLVAN DR | EUCALYPTUS DR | 15323 | 15323 | 37.731014988 | -122.485207021 | EUCALYPTUS DR \ SYLVAN DR | SYLVAN DR \ EUCALYPTUS DR | 1738192519000 | middleware_editor | ALL WAY | EUCALYPTUS DR intersection | - | - | - | - | - | - | - | 44194 | 1133740800000 | -122.4853015 | 37.73094609 | - | 1738160340000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373574480000 | SYLVAN DR | - | - | - | - | - | - |
| 27115 | N/A | Point | 1 | 1 | 1 - 99 | - | S122129 | 1-99 HARRIET ST | 1-99 HARRIET ST | F | F | - | F | 6699000 | 6699000 | - | - | EAST SIDE | - | - | - | - | HOWARD ST | HOWARD ST | 15325 | 15325 | 37.7783494145517 | -122.406407103401 | - | - | 1743734205000 | middleware_editor | NPPZ 3PM-6PM MON-FRI | HOWARD ST to FOLSOM ST (1 - 99) | - | 135FT NORTH OF FOLSOM | - | - | - | - | - | 44195 | 1133769600000 | -122.40692075 | 37.77870042 | - | - | - | D6 | - | OTHER REGULATORY | REG | R30(SF).0084 | 12X18 | SUP1 | 2IN IRON POST | IS | 1373574480000 | HARRIET ST | 1 - 99 HARRIET ST | 1 - 99 HARRIET ST | 1 HARRIET ST | - | FOLSOM ST | FOLSOM ST |
| 27116 | N/A | Point | - | - | - | - | S108119 | HAZELWOOD AVE: BRENTWOOD AVE | - | F | F | - | F | 22799000 | 22799000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BRENTWOOD AVE | BRENTWOOD AVE | 4402 | 4402 | 37.73426736 | -122.45651636 | HAZELWOOD AVE \ BRENTWOOD AVE | HAZELWOOD AVE \ BRENTWOOD AVE | 1710539427000 | MTA | STOP | BRENTWOOD AVE intersection | - | 0 / 0 | - | - | - | - | - | 44196 | 282182400000 | -122.45651636 | 37.73426736 | - | 1191196800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373570100000 | HAZELWOOD AVE | - | - | - | - | - | - |
| 27117 | N/A | Point | - | - | - | - | S101897 | 23RD ST: DIAMOND ST | - | F | F | - | F | 25762000 | 25762000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DIAMOND ST | DIAMOND ST | 4403 | 4403 | 37.75275957 | -122.43645427 | 23RD ST \ DIAMOND ST | 23RD ST \ DIAMOND ST | 1710539427000 | MTA | STOP | DIAMOND ST intersection | - | 0 / 00 | - | - | - | - | - | 44197 | -394588800000 | -122.43645427 | 37.75275957 | - | 944784000000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566920000 | 23RD ST | - | - | - | - | - | - |
| 27118 | N/A | Point | - | - | - | - | S101898 | DIAMOND ST: 23RD ST | - | F | F | - | F | 25762000 | 25762000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DIAMOND ST | DIAMOND ST | 4404 | 4404 | 37.75275957 | -122.43645427 | 23RD ST \ DIAMOND ST | 23RD ST \ DIAMOND ST | 1710539427000 | MTA | STOP | DIAMOND ST intersection | - | 0 / 0 | - | - | - | - | - | 44198 | -394588800000 | -122.43645427 | 37.75275957 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373566920000 | 23RD ST | - | - | - | - | - | - |
| 27119 | N/A | Point | - | - | - | - | S101899 | DIAMOND ST: 24TH ST | - | F | F | - | F | 25760000 | 25760000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DIAMOND ST | DIAMOND ST | 4405 | 4405 | 37.75115322 | -122.43629871 | 24TH ST \ DIAMOND ST | 24TH ST \ DIAMOND ST | 1710539427000 | MTA | STOP | DIAMOND ST intersection | - | 0 / 0 | - | - | - | - | - | 44199 | -394588800000 | -122.43629871 | 37.75115322 | - | 1589241600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566920000 | 24TH ST | - | - | - | - | - | - |
| 27120 | N/A | Point | - | - | - | - | S102186 | MONTGOMERY ST: CALIFORNIA ST | - | F | F | - | F | 24729000 | 24729000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MONTGOMERY ST | CALIFORNIA ST | 4410 | 4410 | 37.79285122 | -122.40276677 | CALIFORNIA ST \ MONTGOMERY ST | MONTGOMERY ST \ CALIFORNIA ST | 1710775985000 | middleware_editor | ONE WAY (LA) | CALIFORNIA ST intersection | - | 0 / 0 | - | - | - | - | - | 44200 | -390096000000 | -122.40276677 | 37.79285122 | - | - | 1710750720000 | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | RETD | 1373568240000 | MONTGOMERY ST | - | - | - | - | - | - |
| 27121 | N/A | Point | - | - | - | - | S106608 | WAWONA ST: VICENTE ST | - | F | F | - | F | 22945000 | 22945000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WAWONA ST | VICENTE ST | 4414 | 4414 | 37.74000565 | -122.46799697 | VICENTE ST \ WAWONA ST | WAWONA ST \ VICENTE ST | 1710539427000 | MTA | STOP | VICENTE ST intersection | - | 0 / 0 | - | - | - | - | - | 44201 | 153446400000 | -122.46799697 | 37.74000565 | - | 1520208000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569620000 | WAWONA ST | - | - | - | - | - | - |
| 27122 | N/A | Point | - | - | - | - | S106609 | FILBERT ST: BRODERICK ST | - | F | F | - | F | 26880000 | 26880000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FILBERT ST | BRODERICK ST | 4415 | 4415 | 37.79696859 | -122.44394996 | BRODERICK ST \ FILBERT ST | FILBERT ST \ BRODERICK ST | 1710539427000 | MTA | STOP | BRODERICK ST intersection | - | 0 / 0 | - | - | - | - | - | 44202 | 153446400000 | -122.44394996 | 37.79696859 | - | 1142812800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569620000 | FILBERT ST | - | - | - | - | - | - |
| 27123 | N/A | Point | - | - | - | - | S106610 | FILBERT ST: BRODERICK ST | - | F | F | - | F | 26880000 | 26880000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FILBERT ST | BRODERICK ST | 4416 | 4416 | 37.79696859 | -122.44394996 | BRODERICK ST \ FILBERT ST | FILBERT ST \ BRODERICK ST | 1710539427000 | MTA | STOP | BRODERICK ST intersection | - | 0 / 0 | - | - | - | - | - | 44203 | 153446400000 | -122.44394996 | 37.79696859 | - | 1142812800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569620000 | FILBERT ST | - | - | - | - | - | - |
| 27124 | N/A | Point | - | - | - | - | S106902 | HAYES ST: PIERCE ST | - | F | F | - | F | 26043000 | 26043000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HAYES ST | PIERCE ST | 4429 | 4429 | 37.77541686 | -122.43448332 | PIERCE ST \ HAYES ST | HAYES ST \ PIERCE ST | 1743721208000 | middleware_editor | STOP | PIERCE ST intersection | - | . | - | - | - | - | - | 44204 | 180169200000 | -122.43448332 | 37.77541686 | - | 1743716100000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569680000 | HAYES ST | - | - | - | - | - | - |
| 27125 | N/A | Point | - | - | - | - | S106903 | HAYES ST: PIERCE ST | - | F | F | - | F | 26043000 | 26043000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HAYES ST | PIERCE ST | 4430 | 4430 | 37.77541686 | -122.43448332 | PIERCE ST \ HAYES ST | HAYES ST \ PIERCE ST | 1743721389000 | middleware_editor | STOP | PIERCE ST intersection | - | 0 / 00 | - | - | - | - | - | 44205 | 180169200000 | -122.43448332 | 37.77541686 | - | 1743717900000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569680000 | HAYES ST | - | - | - | - | - | - |
| 27126 | N/A | Point | - | - | - | - | S106906 | HARRISON ST: 22ND ST | - | F | F | - | F | 23994000 | 23994000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 22ND ST | 22ND ST | 4431 | 4431 | 37.75583251 | -122.41219789 | HARRISON ST \ 22ND ST | HARRISON ST \ 22ND ST | 1731539404000 | middleware_editor | STOP | 22ND ST intersection | - | 0 / 0 | - | - | - | - | - | 44206 | 180144000000 | -122.41219789 | 37.75583251 | - | 1675987200000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569680000 | HARRISON ST | - | - | - | - | - | - |
| 27127 | N/A | Point | - | - | - | - | S106907 | HARRISON ST: 22ND ST | - | F | F | - | F | 23994000 | 23994000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 22ND ST | 22ND ST | 4432 | 4432 | 37.75583251 | -122.41219789 | HARRISON ST \ 22ND ST | HARRISON ST \ 22ND ST | 1731006343000 | middleware_editor | STOP | 22ND ST intersection | - | 0 / 0 | - | - | - | - | - | 44207 | 180144000000 | -122.41219789 | 37.75583251 | - | 651283200000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569680000 | HARRISON ST | - | - | - | - | - | - |
| 27128 | N/A | Point | - | - | - | - | S108126 | SUNNYDALE AVE: REY ST | - | F | F | - | F | 20370000 | 20370000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | REY ST | REY ST | 4433 | 4433 | 37.71086606 | -122.41228115 | SUNNYDALE AVE \ REY ST | SUNNYDALE AVE \ REY ST | 1710539427000 | MTA | STOP | REY ST intersection | - | 0 / 0 | - | - | - | - | - | 44208 | 282268800000 | -122.41228115 | 37.71086606 | - | 882403200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373570100000 | SUNNYDALE AVE | - | - | - | - | - | - |
| 27129 | N/A | Point | - | - | - | - | S109054 | SARGENT ST: ARCH ST | - | F | F | - | F | 22695000 | 22695000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SARGENT ST | SARGENT ST | 5726 | 5726 | 37.71610778 | -122.46711576 | ARCH ST \ SARGENT ST | ARCH ST \ SARGENT ST | 1710539427000 | MTA | STOP | SARGENT ST intersection | - | 0 / 0 | - | - | - | - | - | 44209 | 398908800000 | -122.46711576 | 37.71610778 | - | 1680220800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570400000 | ARCH ST | - | - | - | - | - | - |
| 27130 | N/A | Point | - | - | - | - | S109056 | 33RD AVE: CLEMENT ST | - | F | F | - | F | 27856000 | 27856000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | 33RD AVE | 5727 | 5727 | 37.78162724 | -122.49344635 | 33RD AVE \ CLEMENT ST | CLEMENT ST \ 33RD AVE | 1710539427000 | MTA | STOP | 33RD AVE intersection | - | 0 / 00 | - | - | - | - | - | 44210 | 398908800000 | -122.49344635 | 37.78162724 | - | 1641168000000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570400000 | CLEMENT ST | - | - | - | - | - | - |
| 27131 | N/A | Point | - | - | - | - | S109057 | GIRARD ST: ORDWAY ST | - | F | F | - | F | 20563000 | 20563000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GIRARD ST | GIRARD ST | 5728 | 5728 | 37.72018168 | -122.40159992 | ORDWAY ST \ GIRARD ST | ORDWAY ST \ GIRARD ST | 1710539427000 | MTA | STOP | GIRARD ST intersection | - | 0 / 0 | - | - | - | - | - | 44211 | 398995200000 | -122.40159992 | 37.72018168 | - | 1680566400000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373570400000 | ORDWAY ST | - | - | - | - | - | - |
| 27132 | N/A | Point | - | - | - | - | S107026 | PACIFIC AVE: TAYLOR ST | - | F | F | - | F | 10138000 | 25130000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HIMMELMANN PL | TAYLOR ST | 5831 | 5831 | 37.796141644 | -122.413253412 | - | PACIFIC AVE \ TAYLOR ST | 1743712867000 | middleware_editor | STOP | TAYLOR ST intersection | - | 0 / 0 | - | - | - | - | - | 44212 | 185529600000 | -122.41336618 | 37.79608355 | - | 1154588400000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569740000 | PACIFIC AVE | 1067 - 1099 PACIFIC AVE | - | - | - | TAYLOR ST | - |
| 27133 | N/A | Point | - | - | - | - | S107027 | PACIFIC AVE: TAYLOR ST | - | F | F | - | F | 10139000 | 25130000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TAYLOR ST | TAYLOR ST | 5832 | 5832 | 37.79603726 | -122.413465306 | - | PACIFIC AVE \ TAYLOR ST | 1743712869000 | middleware_editor | STOP | TAYLOR ST intersection | - | 0 / 0 | - | - | - | - | - | 44213 | 185529600000 | -122.41336618 | 37.79608355 | - | 1154588400000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569740000 | PACIFIC AVE | 1100 - 1155 PACIFIC AVE | - | - | - | PHOENIX TER | - |
| 27134 | N/A | Point | - | - | - | - | S107030 | 17TH AVE: VICENTE ST | - | F | F | - | F | 23154000 | 23154000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VICENTE ST | 17TH AVE | 5833 | 5833 | 37.73941853 | -122.47329229 | 17TH AVE \ VICENTE ST | VICENTE ST \ 17TH AVE | 1710539427000 | MTA | STOP | 17TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 44214 | 185587200000 | -122.47329229 | 37.73941853 | - | 1577404800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569740000 | VICENTE ST | - | - | - | - | - | - |
| 27135 | N/A | Point | - | - | - | - | S111105 | 22ND ST: PENNSYLVANIA AVE | - | F | F | - | F | 23625000 | 23625000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 22ND ST | 22ND ST | 5842 | 5842 | 37.75765079 | -122.39312263 | PENNSYLVANIA AVE \ 22ND ST | PENNSYLVANIA AVE \ 22ND ST | 1710539427000 | MTA | STOP | 22ND ST intersection | - | - | - | - | - | - | - | 44215 | 748569600000 | -122.39312263 | 37.75765079 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571000000 | PENNSYLVANIA AVE | - | - | - | - | - | - |
| 27136 | N/A | Point | - | - | - | - | S111108 | 19TH ST: CAPP ST | - | F | F | - | F | 24131000 | 24131000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 5844 | 5844 | 37.76030106 | -122.41811812 | CAPP ST \ 19TH ST | CAPP ST \ 19TH ST | 1745515994000 | middleware_editor | STOP | 19TH ST intersection | - | - | - | - | - | - | - | 44216 | 748594800000 | -122.41811812 | 37.76030106 | - | 1583222400000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571000000 | CAPP ST | - | - | - | - | - | - |
| 27137 | N/A | Point | - | - | - | - | S109363 | POWELL ST: BAY ST | - | F | F | - | F | 25461000 | 25461000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BAY ST | BAY ST | 5845 | 5845 | 37.80582493 | -122.41195009 | POWELL ST \ BAY ST | POWELL ST \ BAY ST | 1753206318000 | middleware_editor | ONE WAY (RA) | BAY ST intersection | - | 0 / MAKE POWELL ONE WAY NORTHBOUND | - | - | - | - | - | 44217 | 465462000000 | -122.41195009 | 37.80582493 | - | - | 1753206240000 | D3 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | SIGNAL POLE | RETD | 1373570460000 | POWELL ST | - | - | - | - | - | - |
| 27138 | N/A | Point | - | - | - | - | S109364 | POWELL ST: NORTH POINT ST | - | F | F | - | F | 25480000 | 25480000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | POWELL ST | POWELL ST | 5846 | 5846 | 37.80675808 | -122.41214142 | NORTH POINT ST \ POWELL ST | NORTH POINT ST \ POWELL ST | 1753206789000 | middleware_editor | ONE WAY (RA) | POWELL ST intersection | - | 0 / MAKE POWELL ST. ONE WAY NORTHBOUND | - | - | - | - | - | 44218 | 465462000000 | -122.41214142 | 37.80675808 | - | - | 1753206720000 | D3 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | 2IN IRON POST | RETD | 1373570460000 | NORTH POINT ST | - | - | - | - | - | - |
| 27139 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S109367 | 2300-2399 POWELL ST | 2300-2399 POWELL ST | F | F | - | F | 10704000 | 10704000 | - | - | WEST SIDE, WESTBOUND TRAFFIC | - | - | - | - | BAY ST | BAY ST | 5848 | 5848 | 37.80629151 | -122.41204576 | - | - | 1753206456000 | middleware_editor | ONE WAY (RA) | BAY ST to NORTH POINT ST (2300 - 2399) | - | 0 / 2351 3 FT. SOUTH OF ENTRANCE TO | - | - | - | - | - | 44219 | 466844400000 | -122.41204576 | 37.80629151 | - | - | 1753206360000 | D3 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | 2IN IRON POST | RETD | 1373570460000 | POWELL ST | 2300 - 2399 POWELL ST | 2300 - 2399 POWELL ST | 2300 POWELL ST | - | NORTH POINT ST | NORTH POINT ST |
| 27140 | N/A | Point | - | - | - | - | S109368 | DAVIS ST: DAVIS CT \ JACKSON S | - | F | F | - | F | 24577000 | 24577000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DAVIS CT \ DAVIS ST | DAVIS CT \ DAVIS ST | 5849 | 5849 | 37.79709205 | -122.39833315 | JACKSON ST \ DAVIS CT \ DAVIS ST | JACKSON ST \ DAVIS CT \ DAVIS ST | 1710539427000 | MTA | STOP | DAVIS CT \ DAVIS ST intersection | - | 0 / 0 | - | - | - | - | - | 44220 | 467251200000 | -122.39833315 | 37.79709205 | - | 1597104000000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570460000 | JACKSON ST | - | - | - | - | - | - |
| 27141 | N/A | Point | - | - | - | - | S109369 | DAVIS ST: DAVIS CT \ JACKSON S | - | F | F | - | F | 24577000 | 24577000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DAVIS CT \ DAVIS ST | DAVIS CT \ DAVIS ST | 5850 | 5850 | 37.79709205 | -122.39833315 | JACKSON ST \ DAVIS CT \ DAVIS ST | JACKSON ST \ DAVIS CT \ DAVIS ST | 1721158919000 | middleware_editor | STOP | DAVIS CT \ DAVIS ST intersection | - | 0 / 0 | - | - | - | - | - | 44221 | 467251200000 | -122.39833315 | 37.79709205 | - | 1597190400000 | - | D3 | - | STOP | REG | R1-1.0001 | 24X24 | SUP1 | 2IN IRON POST | IS | 1373570460000 | JACKSON ST | - | - | - | - | - | - |
| 27142 | N/A | Point | - | - | - | - | S110166 | ROSE ST: GOUGH ST | - | F | F | - | F | 24453000 | 24453000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GOUGH ST | GOUGH ST | 6372 | 6372 | 37.77361913 | -122.42231207 | ROSE ST \ GOUGH ST | ROSE ST \ GOUGH ST | 1726240166000 | middleware_editor | STOP | GOUGH ST intersection | - | - | - | - | - | - | - | 44222 | 601084800000 | -122.42231207 | 37.77361913 | - | - | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570700000 | ROSE ST | - | - | - | - | - | - |
| 27143 | N/A | Point | - | - | - | - | S110167 | 19TH ST: HARRISON ST | - | F | F | - | F | 24039000 | 24039000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 6373 | 6373 | 37.76062927 | -122.41268139 | HARRISON ST \ 19TH ST | HARRISON ST \ 19TH ST | 1741281531000 | middleware_editor | STOP | 19TH ST intersection | - | SOUTH INTERSECTION | - | - | - | - | - | 44223 | 601113600000 | -122.41268139 | 37.76062927 | - | 1592982000000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570700000 | HARRISON ST | - | - | - | - | - | - |
| 27144 | N/A | Point | - | - | - | - | S110169 | LINDEN ST: OCTAVIA ST | - | F | F | - | F | 35011000 | 35011000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | LINDEN ST | 6374 | 6374 | 37.7762386 | -122.42427319 | LINDEN ST \ OCTAVIA ST | OCTAVIA ST \ LINDEN ST | 1710539427000 | MTA | STOP | LINDEN ST intersection | - | - | - | - | - | - | - | 44224 | 601084800000 | -122.42427319 | 37.7762386 | - | - | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570700000 | OCTAVIA ST | - | - | - | - | - | - |
| 27145 | N/A | Point | - | - | - | - | S110170 | LINDEN ST: OCTAVIA ST | - | F | F | - | F | 35011000 | 35011000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | LINDEN ST | 6375 | 6375 | 37.7762386 | -122.42427319 | LINDEN ST \ OCTAVIA ST | OCTAVIA ST \ LINDEN ST | 1728608245000 | middleware_editor | STOP | LINDEN ST intersection | - | - | - | - | - | - | - | 44225 | 601084800000 | -122.42427319 | 37.7762386 | - | - | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570700000 | OCTAVIA ST | - | - | - | - | - | - |
| 27146 | N/A | Point | - | - | - | - | S111109 | 19TH ST: CAPP ST | - | F | F | - | F | 24131000 | 24131000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 6376 | 6376 | 37.76030106 | -122.41811812 | CAPP ST \ 19TH ST | CAPP ST \ 19TH ST | 1745515991000 | middleware_editor | STOP | 19TH ST intersection | - | - | - | - | - | - | - | 44226 | 748594800000 | -122.41811812 | 37.76030106 | - | 1583222400000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571000000 | CAPP ST | - | - | - | - | - | - |
| 27147 | N/A | Point | - | - | - | - | S108884 | ROUSSEAU ST: BOSWORTH ST | - | F | F | - | F | 21859000 | 21859000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ROUSSEAU ST | BOSWORTH ST | 8147 | 8147 | 37.73331313 | -122.43027782 | BOSWORTH ST \ ROUSSEAU ST | ROUSSEAU ST \ BOSWORTH ST | 1710539427000 | MTA | ONE WAY (RA) | BOSWORTH ST intersection | - | 0 / REVERSED 1-WAY WB-EB SAN JOSE-B..... | - | - | - | - | - | 44227 | 362534400000 | -122.43027782 | 37.73331313 | - | - | - | D8 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | UNKNOWN | IS | 1373570340000 | ROUSSEAU ST | - | - | - | - | - | - |
| 27148 | N/A | Point | - | 1 | 1 - 99 | - | S111174 | 1-99 RESERVOIR ST | 1-99 RESERVOIR ST | F | F | - | F | 10965000 | 10965000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | MARKET ST | MARKET ST | 8148 | 8148 | 37.76872255 | -122.42825792 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | MARKET ST to CHURCH ST (1 - 99) | - | W-LINE / OF RESERVOIR ON ISLAND | - | - | - | - | - | 44228 | 756950400000 | -122.42825792 | 37.76872255 | - | - | - | D8 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571060000 | RESERVOIR ST | 1 - 99 RESERVOIR ST | 1 - 99 RESERVOIR ST | 1 RESERVOIR ST | - | CHURCH ST | CHURCH ST |
| 27149 | N/A | Point | - | - | - | - | S111176 | 43RD AVE: IRVING ST | - | F | F | - | F | 27802000 | 27802000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | IRVING ST | IRVING ST | 8149 | 8149 | 37.76242722 | -122.50284388 | 43RD AVE \ IRVING ST | 43RD AVE \ IRVING ST | 1737572152000 | middleware_editor | STOP | IRVING ST intersection | - | - | - | - | - | - | - | 44229 | 759456000000 | -122.50284388 | 37.76242722 | - | 1493683200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571060000 | 43RD AVE | - | - | - | - | - | - |
| 27150 | N/A | Point | - | - | - | - | S111177 | 43RD AVE: IRVING ST | - | F | F | - | F | 27802000 | 27802000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | IRVING ST | IRVING ST | 8150 | 8150 | 37.76242722 | -122.50284388 | 43RD AVE \ IRVING ST | 43RD AVE \ IRVING ST | 1756505651000 | middleware_editor | STOP | IRVING ST intersection | - | - | - | - | - | - | - | 44230 | 759484800000 | -122.50284388 | 37.76242722 | - | 1493708400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571060000 | 43RD AVE | - | - | - | - | - | - |
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