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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65926 | N/A | Point | - | - | - | - | S100953 | 4TH AVE: CALIFORNIA ST | - | F | F | - | F | 27587000 | 27587000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 213 | 213 | 37.78526613 | -122.46244144 | 4TH AVE \ CALIFORNIA ST | 04TH AVE \ CALIFORNIA ST | 1710539427000 | MTA | STOP | CALIFORNIA ST intersection | - | 0 / 0 | - | - | - | - | - | 83040 | -401760000000 | -122.46244144 | 37.78526613 | - | 698889600000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373566620000 | 04TH AVE | - | - | - | - | - | - |
| 65927 | N/A | Point | - | - | - | - | S100955 | 5TH AVE: CALIFORNIA ST | - | F | F | - | F | 27594000 | 27594000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 5TH AVE | CALIFORNIA ST | 214 | 214 | 37.78513054 | -122.46350301 | CALIFORNIA ST \ 5TH AVE | 05TH AVE \ CALIFORNIA ST | 1710539427000 | MTA | STOP | CALIFORNIA ST intersection | - | 0 / 0 | - | - | - | - | - | 83041 | -401760000000 | -122.46350301 | 37.78513054 | - | 835747200000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1373566620000 | 05TH AVE | - | - | - | - | - | - |
| 65928 | N/A | Point | - | - | - | - | S100956 | 14TH AVE: CALIFORNIA ST | - | F | F | - | F | 27621000 | 27621000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 215 | 215 | 37.78442147 | -122.47311981 | 14TH AVE \ CALIFORNIA ST | 14TH AVE \ CALIFORNIA ST | 1747332179000 | middleware_editor | STOP | CALIFORNIA ST intersection | - | 0 / 00 | - | - | - | - | - | 83042 | -401734800000 | -122.47311981 | 37.78442147 | - | 1396335600000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566620000 | 14TH AVE | - | - | - | - | - | - |
| 65929 | N/A | Point | - | - | - | - | S106121 | SCOTT ST: NORTH POINT ST | - | F | F | - | F | 26993000 | 26993000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | NORTH POINT ST | NORTH POINT ST | 2128 | 2128 | 37.8029853 | -122.44175395 | SCOTT ST \ NORTH POINT ST | SCOTT ST \ NORTH POINT ST | 1710539427000 | MTA | STOP | NORTH POINT ST intersection | - | - | - | - | - | - | - | 83043 | 123897600000 | -122.44175395 | 37.8029853 | - | 1707406080000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569440000 | SCOTT ST | - | - | - | - | - | - |
| 65930 | N/A | Point | - | - | - | - | S105577 | PARIS ST: BRAZIL AVE | - | F | F | - | F | 21717000 | 21717000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PARIS ST | BRAZIL AVE | 2159 | 2159 | 37.724028616 | -122.433265465 | BRAZIL AVE \ PARIS ST | PARIS ST \ BRAZIL AVE | 1710539427000 | MTA | STOP | BRAZIL AVE intersection | - | - | - | - | - | - | - | 83044 | 86227200000 | -122.43323149 | 37.72393244 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373569260000 | PARIS ST | - | - | - | - | - | - |
| 65931 | N/A | Point | - | - | - | - | S105578 | DELLBROOK AVE: PANORAMA DR | - | F | F | - | F | 26246000 | 26246000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DELLBROOK AVE | DELLBROOK AVE | 2160 | 2160 | 37.753590139 | -122.452738365 | PANORAMA DR \ DELLBROOK AVE | PANORAMA DR \ DELLBROOK AVE | 1710539427000 | MTA | STOP | DELLBROOK AVE intersection | - | 0 / 0 | - | - | - | - | - | 83045 | 86227200000 | -122.45257028 | 37.75354207 | - | - | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569260000 | PANORAMA DR | - | - | - | - | - | - |
| 65932 | N/A | Point | - | - | - | - | S105579 | DELLBROOK AVE: PANORAMA DR | - | F | F | - | F | 26246000 | 26246000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DELLBROOK AVE | DELLBROOK AVE | 2161 | 2161 | 37.753492587 | -122.452405772 | PANORAMA DR \ DELLBROOK AVE | PANORAMA DR \ DELLBROOK AVE | 1710539427000 | MTA | STOP | DELLBROOK AVE intersection | - | 0 / 0 | - | - | - | - | - | 83046 | 86227200000 | -122.45257028 | 37.75354207 | - | - | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569260000 | PANORAMA DR | - | - | - | - | - | - |
| 65933 | N/A | Point | - | - | - | - | S105003 | SAN BRUNO AVE: BACON ST | - | F | F | - | F | 33647000 | 33647000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SAN BRUNO AVE | BACON ST | 2192 | 2192 | 37.727694591 | -122.403716272 | BACON ST \ SAN BRUNO AVE | SAN BRUNO AVE \ BACON ST | 1710539427000 | MTA | STOP | BACON ST intersection | - | 0 / 0 | - | - | - | - | - | 83047 | 40435200000 | -122.40359289 | 37.72763413 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569080000 | SAN BRUNO AVE | - | - | - | - | - | - |
| 65934 | N/A | Point | - | - | - | - | S106127 | BRAZIL AVE: VIENNA ST | - | F | F | - | F | 21639000 | 21639000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | VIENNA ST | 2198 | 2198 | 37.72203095 | -122.429105495 | VIENNA ST \ BRAZIL AVE | BRAZIL AVE \ VIENNA ST | 1710539427000 | MTA | STOP | VIENNA ST intersection | - | 0 / 0 | - | - | - | - | - | 83048 | 124416000000 | -122.42924944 | 37.722026 | - | 1439769600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | BRAZIL AVE | - | - | - | - | - | - |
| 65935 | N/A | Point | - | - | - | - | S106128 | BRAZIL AVE: VIENNA ST | - | F | F | - | F | 21639000 | 21639000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | VIENNA ST | 2199 | 2199 | 37.722025293 | -122.429351364 | VIENNA ST \ BRAZIL AVE | BRAZIL AVE \ VIENNA ST | 1710539427000 | MTA | STOP | VIENNA ST intersection | - | 0 / 0 | - | - | - | - | - | 83049 | 124416000000 | -122.42924944 | 37.722026 | - | 1175817600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | BRAZIL AVE | - | - | - | - | - | - |
| 65936 | N/A | Point | - | - | - | - | S106176 | BRAZIL AVE: ATHENS ST | - | F | F | - | F | 21635000 | 21635000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ATHENS ST | BRAZIL AVE | 2205 | 2205 | 37.721645278 | -122.428299808 | BRAZIL AVE \ ATHENS ST | ATHENS ST \ BRAZIL AVE | 1710539427000 | MTA | STOP | BRAZIL AVE intersection | - | 0 / 0 | - | - | - | - | - | 83050 | 127440000000 | -122.42843213 | 37.72163467 | - | 1504656000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569440000 | ATHENS ST | - | - | - | - | - | - |
| 65937 | N/A | Point | - | - | - | - | S106177 | LONDON ST: BRAZIL AVE | - | F | F | - | F | 21723000 | 21723000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | BRAZIL AVE | 2206 | 2206 | 37.724224437 | -122.434015599 | LONDON ST \ BRAZIL AVE | LONDON ST \ BRAZIL AVE | 1710539427000 | MTA | STOP | BRAZIL AVE intersection | - | 0 / 0 | - | - | - | - | - | 83051 | 127440000000 | -122.43403348 | 37.72431637 | - | 1351036800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569440000 | LONDON ST | - | - | - | - | - | - |
| 65938 | N/A | Point | - | - | - | - | S106178 | LONDON ST: BRAZIL AVE | - | F | F | - | F | 21723000 | 21723000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | BRAZIL AVE | 2207 | 2207 | 37.724221608 | -122.434015599 | LONDON ST \ BRAZIL AVE | LONDON ST \ BRAZIL AVE | 1710539427000 | MTA | STOP | BRAZIL AVE intersection | - | 0 / 0 | - | - | - | - | - | 83052 | 127440000000 | -122.43403348 | 37.72431637 | - | 1417737600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | LONDON ST | - | - | - | - | - | - |
| 65939 | N/A | Point | - | - | - | - | S105517 | HARTFORD ST: 19TH ST | - | F | F | - | F | 25788000 | 25788000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 2229 | 2229 | 37.759279876 | -122.433691844 | HARTFORD ST \ 19TH ST | HARTFORD ST \ 19TH ST | 1710539427000 | MTA | STOP | 19TH ST intersection | - | - | - | - | - | - | - | 83053 | 80499600000 | -122.43374455 | 37.75935631 | - | 1493191620000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | HARTFORD ST | - | - | - | - | - | - |
| 65940 | N/A | Point | - | - | - | - | S105526 | LOMA VISTA TER: MASONIC AVE | - | F | F | - | F | 26208000 | 26208000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LOMA VISTA TER | LOMA VISTA TER | 2236 | 2236 | 37.7653328 | -122.44334728 | MASONIC AVE \ LOMA VISTA TER | MASONIC AVE \ LOMA VISTA TER | 1741013566000 | middleware_editor | STOP | LOMA VISTA TER intersection | - | - | - | - | - | - | - | 83054 | 80870400000 | -122.44334728 | 37.7653328 | - | 1584106800000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | MASONIC AVE | - | - | - | - | - | - |
| 65941 | N/A | Point | - | - | - | - | S103871 | COMMERCIAL ST: MONTGOMERY ST | - | F | F | - | F | 24755000 | 24755000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MONTGOMERY ST | COMMERCIAL ST | 2241 | 2241 | 37.79421604 | -122.40304688 | COMMERCIAL ST \ MONTGOMERY ST | MONTGOMERY ST \ COMMERCIAL ST | 1722349332000 | middleware_editor | STOP | COMMERCIAL ST intersection | - | - | - | - | - | - | - | 83055 | -75020400000 | -122.40304688 | 37.79421604 | - | - | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568720000 | MONTGOMERY ST | - | - | - | - | - | - |
| 65942 | N/A | Point | - | - | - | - | S106046 | HARRISON ST: PRECITA AVE | - | F | F | - | F | 21171000 | 21171000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PRECITA AVE | HARRISON ST | 2248 | 2248 | 37.747354769 | -122.411256642 | HARRISON ST \ PRECITA AVE | PRECITA AVE \ HARRISON ST | 1710539427000 | MTA | STOP | HARRISON ST intersection | - | (NORTHERN INTERSECTION) | - | - | - | - | - | 83056 | 118454400000 | -122.41138807 | 37.74730104 | - | 1540857600000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569440000 | PRECITA AVE | - | - | - | - | - | - |
| 65943 | N/A | Point | - | - | - | - | S106050 | 35TH AVE: QUINTARA ST | - | F | F | - | F | 23414000 | 23414000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 35TH AVE | 35TH AVE | 2250 | 2250 | 37.747801678 | -122.49315443 | QUINTARA ST \ 35TH AVE | QUINTARA ST \ 35TH AVE | 1710539427000 | MTA | STOP | 35TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 83057 | 118540800000 | -122.49322819 | 37.74788828 | - | 1484611200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | QUINTARA ST | - | - | - | - | - | - |
| 65944 | N/A | Point | - | - | - | - | S105681 | MENDELL ST: HUDSON AVE | - | F | F | - | F | 20215000 | 20215000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | HUDSON AVE | HUDSON AVE | 2274 | 2274 | 37.73898305 | -122.38639891 | MENDELL ST \ HUDSON AVE | MENDELL ST \ HUDSON AVE | 1710539427000 | MTA | STOP | HUDSON AVE intersection | - | - | - | - | - | - | - | 83058 | 95011200000 | -122.38639891 | 37.73898305 | - | 879696000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569320000 | MENDELL ST | - | - | - | - | - | - |
| 65945 | N/A | Point | - | - | - | - | S105687 | DE HARO ST: MARIPOSA ST | - | F | F | - | F | 23752000 | 23752000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DE HARO ST | DE HARO ST | 2279 | 2279 | 37.76356146 | -122.40147894 | MARIPOSA ST \ DE HARO ST | MARIPOSA ST \ DE HARO ST | 1710539427000 | MTA | STOP | DE HARO ST intersection | - | - | - | - | - | - | - | 83059 | 96220800000 | -122.40147894 | 37.76356146 | - | 1684108800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569320000 | MARIPOSA ST | - | - | - | - | - | - |
| 65946 | N/A | Point | - | - | - | - | S101588 | PACIFIC AVE: FILLMORE ST | - | F | F | - | F | 26657000 | 26657000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PACIFIC AVE | FILLMORE ST | 6150 | 6150 | 37.793288515 | -122.434845753 | FILLMORE ST \ PACIFIC AVE | PACIFIC AVE \ FILLMORE ST | 1746536943000 | middleware_editor | STOP | FILLMORE ST intersection | - | 0 / 00 | - | - | - | - | - | 83060 | -395686800000 | -122.43473366 | 37.79334729 | - | 1156316400000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566800000 | PACIFIC AVE | - | - | - | - | - | - |
| 65947 | N/A | Point | - | - | - | - | S106311 | HOLYOKE ST: BACON ST | - | F | F | - | F | 20890000 | 20890000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BACON ST | BACON ST | 6208 | 6208 | 37.726270047 | -122.408432563 | HOLYOKE ST \ BACON ST | HOLYOKE ST \ BACON ST | 1710539427000 | MTA | STOP | BACON ST intersection | - | 0 / 0 | - | - | - | - | - | 83061 | 136944000000 | -122.40854164 | 37.72634147 | - | 1525132800000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569500000 | HOLYOKE ST | - | - | - | - | - | - |
| 65948 | N/A | Point | - | - | - | - | S101593 | FILLMORE ST: PACIFIC AVE | - | F | F | - | F | 26657000 | 26657000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PACIFIC AVE | FILLMORE ST | 6215 | 6215 | 37.793443685 | -122.43482396 | FILLMORE ST \ PACIFIC AVE | PACIFIC AVE \ FILLMORE ST | 1710539427000 | MTA | STOP | FILLMORE ST intersection | - | 0 / 0 | - | - | - | - | - | 83062 | -395712000000 | -122.43473366 | 37.79334729 | - | 1156291200000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566800000 | PACIFIC AVE | - | - | - | - | - | - |
| 65949 | N/A | Point | - | - | - | - | S101594 | FILLMORE ST: PACIFIC AVE | - | F | F | - | F | 26657000 | 26657000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PACIFIC AVE | FILLMORE ST | 6216 | 6216 | 37.793262816 | -122.434655987 | FILLMORE ST \ PACIFIC AVE | PACIFIC AVE \ FILLMORE ST | 1710539427000 | MTA | STOP | FILLMORE ST intersection | - | 0 / 0 | - | - | - | - | - | 83063 | -395712000000 | -122.43473366 | 37.79334729 | - | 1423612800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373566800000 | PACIFIC AVE | - | - | - | - | - | - |
| 65950 | N/A | Point | - | - | - | - | S109667 | MADRID ST: ITALY AVE | - | F | F | - | F | 21727000 | 21727000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ITALY AVE | ITALY AVE | 6258 | 6258 | 37.717047891 | -122.436350809 | MADRID ST \ ITALY AVE | MADRID ST \ ITALY AVE | 1710539427000 | MTA | STOP | ITALY AVE intersection | - | 0 / 00 | - | - | - | - | - | 83064 | 534470400000 | -122.43633114 | 37.71695312 | - | 1357516800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570580000 | MADRID ST | - | - | - | - | - | - |
| 65951 | N/A | Point | - | - | - | - | S108406 | IRVING ST: 18TH AVE | - | F | F | - | F | 27371000 | 27371000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 18TH AVE | 18TH AVE | 6339 | 6339 | 37.763682974 | -122.475950445 | IRVING ST \ 18TH AVE | IRVING ST \ 18TH AVE | 1710539427000 | MTA | STOP | 18TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 83065 | 303955200000 | -122.47605438 | 37.76360876 | - | 1578355200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373570160000 | IRVING ST | - | - | - | - | - | - |
| 65952 | N/A | Point | - | - | - | - | S107558 | ATHENS ST: ROLPH ST | - | F | F | - | F | 21403000 | 21403000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ROLPH ST | ATHENS ST | 6353 | 6353 | 37.712903663 | -122.43502777 | ATHENS ST \ ROLPH ST | ROLPH ST \ ATHENS ST | 1710539427000 | MTA | STOP | ATHENS ST intersection | - | 0 / 0 | - | - | - | - | - | 83066 | 235872000000 | -122.43499916 | 37.71281313 | - | 1425427200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569920000 | ROLPH ST | - | - | - | - | - | - |
| 65953 | N/A | Point | - | - | - | - | S107559 | ATHENS ST: ROLPH ST | - | F | F | - | F | 21403000 | 21403000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ROLPH ST | ATHENS ST | 6354 | 6354 | 37.712732499 | -122.434983067 | ATHENS ST \ ROLPH ST | ROLPH ST \ ATHENS ST | 1718115695000 | middleware_editor | STOP | ATHENS ST intersection | - | 0 / 0 | - | - | - | - | - | 83067 | 235872000000 | -122.43499916 | 37.71281313 | - | 1397606400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569920000 | ROLPH ST | - | - | - | - | - | - |
| 65954 | N/A | Point | - | - | - | - | S113330 | 15TH AVE: ORTEGA ST \ ORTEGA W | - | F | F | - | F | 27308000 | 27308000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ORTEGA ST \ ORTEGA WAY | 15TH AVE \ ORTEGA WAY | 6838 | 6838 | 37.752484108 | -122.471955612 | 15TH AVE \ ORTEGA ST \ ORTEGA WAY | ORTEGA ST \ 15TH AVE \ ORTEGA WAY | 1710539427000 | MTA | STOP | 15TH AVE \ ORTEGA WAY intersection | - | - | - | - | - | - | - | 83068 | 987552000000 | -122.47200758 | 37.75256982 | - | - | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571720000 | ORTEGA ST | - | - | - | - | - | - |
| 65955 | N/A | Point | - | - | - | - | S108632 | DOWNEY ST: FREDERICK ST | - | F | F | - | F | 26404000 | 26404000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DOWNEY ST | DOWNEY ST | 6847 | 6847 | 37.767189541 | -122.447252834 | FREDERICK ST \ DOWNEY ST | FREDERICK ST \ DOWNEY ST | 1710539427000 | MTA | STOP | DOWNEY ST intersection | - | 0 / 0 | - | - | - | - | - | 83069 | 323308800000 | -122.44719919 | 37.76711056 | - | - | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373570220000 | FREDERICK ST | - | - | - | - | - | - |
| 65956 | N/A | Point | - | - | - | - | S108684 | PANORAMA DR: MARVIEW WAY | - | F | F | - | F | 26231000 | 26231000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MARVIEW WAY | MARVIEW WAY | 6853 | 6853 | 37.753689181 | -122.450830454 | PANORAMA DR \ MARVIEW WAY | PANORAMA DR \ MARVIEW WAY | 1710539427000 | MTA | STOP | MARVIEW WAY intersection | - | 0 / 0 | - | - | - | - | - | 83070 | 332380800000 | -122.45070886 | 37.75361637 | - | 1462320000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570280000 | PANORAMA DR | - | - | - | - | - | - |
| 65957 | N/A | Point | - | - | - | - | S108685 | PANORAMA DR: MARVIEW WAY | - | F | F | - | F | 26231000 | 26231000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MARVIEW WAY | MARVIEW WAY | 6854 | 6854 | 37.753562646 | -122.450604254 | PANORAMA DR \ MARVIEW WAY | PANORAMA DR \ MARVIEW WAY | 1710539427000 | MTA | STOP | MARVIEW WAY intersection | - | 0 / 0 | - | - | - | - | - | 83071 | 332380800000 | -122.45070886 | 37.75361637 | - | 1479859200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570280000 | PANORAMA DR | - | - | - | - | - | - |
| 65958 | N/A | Point | - | - | - | - | S108688 | MARVIEW WAY: PANORAMA DR | - | F | F | - | F | 26231000 | 26231000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MARVIEW WAY | MARVIEW WAY | 6857 | 6857 | 37.753717456 | -122.450630182 | PANORAMA DR \ MARVIEW WAY | PANORAMA DR \ MARVIEW WAY | 1710539427000 | MTA | STOP | MARVIEW WAY intersection | - | 0 / 0 | - | - | - | - | - | 83072 | 332467200000 | -122.45070886 | 37.75361637 | - | 1483920000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570280000 | PANORAMA DR | - | - | - | - | - | - |
| 65959 | N/A | Point | 1 | 1 | 0 - 0 | - | S113490 | 1-17 SAN PABLO AVE | 0-0 SAN PABLO AVE | F | F | - | F | 11500000 | 11500000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | GRANVILLE WAY \ PORTOLA DR | GRANVILLE WAY \ PORTOLA DR | 6962 | 6962 | 37.74018118 | -122.46106958 | - | - | 1729635944000 | middleware_editor | SPEED HUMP | GRANVILLE WAY \ PORTOLA DR to SAN PABLO AVE (0 - 0) | - | IFO#97 | - | - | - | - | - | 83073 | 989539200000 | -122.46106958 | 37.74018118 | - | - | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571780000 | SAN PABLO AVE | 0 - 0 SAN PABLO AVE | 0 - 0 SAN PABLO AVE | 0 SAN PABLO AVE | - | SAN PABLO AVE | SAN PABLO AVE |
| 65960 | N/A | Point | 1 | 1 | 200 - 299 | - | S113491 | 200-299 SANTA CLARA AVE | 200-299 SANTA CLARA AVE | F | F | - | F | 11571000 | 11571000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | SAN ANSELMO AVE | SAN ANSELMO AVE | 6963 | 6963 | 37.73582211 | -122.46626993 | - | - | 1710539427000 | MTA | SPEED HUMP | SAN ANSELMO AVE to SAINT FRANCIS BLVD (200 - 299) | - | IFO#240 | - | - | - | - | - | 83074 | 989539200000 | -122.46626993 | 37.73582211 | - | - | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1373571780000 | SANTA CLARA AVE | 200 - 299 SANTA CLARA AVE | 200 - 299 SANTA CLARA AVE | 200 SANTA CLARA AVE | - | SAINT FRANCIS BLVD | SAINT FRANCIS BLVD |
| 65961 | N/A | Point | 1 | 1 | 0 - 0 | - | S110314 | 5300-5303 MISSION ST | 0-0 MISSION ST | F | F | - | F | 9182000 | 9182000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | ALLISON ST | ALLISON ST | 7033 | 7033 | 37.714446994 | -122.442391521 | - | - | 1710539427000 | MTA | STOP | ALLISON ST to MOUNT VERNON AVE (0 - 0) | - | 0 / REMOVE 2 R8'S & EB TYPE N | - | - | - | - | - | 83075 | 619747200000 | -122.44261325 | 37.71461391 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570760000 | MISSION ST | 0 - 0 MISSION ST | 0 - 0 MISSION ST | 0 MISSION ST | - | MOUNT VERNON AVE | MOUNT VERNON AVE |
| 65962 | N/A | Point | - | - | - | - | S110315 | MISSION ST: ALLISON ST | - | F | F | - | F | 21480000 | 21480000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MISSION ST | ALLISON ST | 7034 | 7034 | 37.714544628 | -122.442425485 | ALLISON ST \ MISSION ST | MISSION ST \ ALLISON ST | 1710539427000 | MTA | STOP | ALLISON ST intersection | - | 0 / 000 | - | - | - | - | - | 83076 | 619747200000 | -122.44256496 | 37.71466062 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570760000 | MISSION ST | - | - | - | - | - | - |
| 65963 | N/A | Point | - | - | - | - | S118108 | ALPHA ST: TEDDY AVE | - | F | F | - | F | 2216000 | 20322000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TEDDY AVE | ALPHA ST | 12610 | 12610 | 37.713776776 | -122.404450963 | - | TEDDY AVE \ ALPHA ST | 1710539427000 | MTA | ALL WAY | ALPHA ST intersection | - | - | - | - | - | - | - | 83077 | 1072742400000 | -122.40445834 | 37.71383937 | - | 1686700800000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373573220000 | TEDDY AVE | 200 - 299 ALPHA ST | - | - | - | ARLETA AVE | - |
| 65964 | N/A | Point | - | - | - | - | S115798 | JERROLD AVE: MENDELL ST | - | F | F | - | F | 20218000 | 20218000 | - | - | NORTH WEST CORNER | - | - | - | - | JERROLD AVE | JERROLD AVE | 12625 | 12625 | 37.73773066 | -122.38752802 | MENDELL ST \ JERROLD AVE | MENDELL ST \ JERROLD AVE | 1710973627000 | middleware_editor | PARK AT 90 DEGREES (SYM) | JERROLD AVE intersection | - | - | - | - | - | - | - | 83078 | 1039478400000 | -122.38752802 | 37.73773066 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | LIGHT POLE | IS | 1373572500000 | MENDELL ST | - | - | - | - | - | - |
| 65965 | N/A | Point | - | - | - | - | S115734 | ALPINE TER: DUBOCE AVE | - | F | F | - | F | 26009000 | 26009000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ALPINE TER | DUBOCE AVE | 12677 | 12677 | 37.76904336 | -122.43755641 | DUBOCE AVE \ ALPINE TER | ALPINE TER \ DUBOCE AVE | 1710539427000 | MTA | ALL WAY | DUBOCE AVE intersection | - | NWCORNER | - | - | - | - | - | 83079 | 1038182400000 | -122.43755641 | 37.76904336 | - | - | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572440000 | ALPINE TER | - | - | - | - | - | - |
| 65966 | N/A | Point | - | - | - | - | S117854 | WOODSIDE AVE: IDORA AVE | - | T | T | - | F | - | 22448000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | - | WOODSIDE AVE | 12854 | 12854 | 37.74609265 | -122.454619843 | - | IDORA AVE \ WOODSIDE AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) | WOODSIDE AVE intersection | - | - | - | - | - | - | - | 83080 | 1066867200000 | -122.4546641 | 37.74610617 | - | - | - | D7 | - | NO LEFT TURN | REG | R3-2.0003 | 36X36 | SUP2 | SIGNAL POLE | IS | 1373573100000 | IDORA AVE | - | - | - | - | - | - |
| 65967 | N/A | Point | - | - | - | - | S118939 | EXCELSIOR AVE: VIENNA ST | - | F | F | - | F | 21640000 | 21640000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | VIENNA ST | EXCELSIOR AVE | 13710 | 13710 | 37.723557155 | -122.428095468 | EXCELSIOR AVE \ VIENNA ST | VIENNA ST \ EXCELSIOR AVE | 1710539427000 | MTA | ROUNDABOUT ARROWS | EXCELSIOR AVE intersection | - | C-LINE | - | - | - | - | - | 83081 | 1085097600000 | -122.42807401 | 37.7235911 | - | 1684972800000 | - | D11 | - | OTHER REGULATORY | REG | R7(SF).0001 | 18X24 | SUP2 | 2IN IRON POST | IS | 1373573460000 | VIENNA ST | - | - | - | - | - | - |
| 65968 | N/A | Point | - | - | - | - | S118940 | EXCELSIOR AVE: VIENNA ST | - | F | F | - | F | 21640000 | 21640000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | VIENNA ST | EXCELSIOR AVE | 13711 | 13711 | 37.723620802 | -122.4280454 | EXCELSIOR AVE \ VIENNA ST | VIENNA ST \ EXCELSIOR AVE | 1710539427000 | MTA | ROUNDABOUT ARROWS | EXCELSIOR AVE intersection | - | - | - | - | - | - | - | 83082 | 1085097600000 | -122.42807401 | 37.7235911 | - | 1683763200000 | - | D11 | - | OTHER REGULATORY | REG | R7(SF).0001 | 18X24 | SUP2 | 2IN IRON POST | IS | 1373573460000 | VIENNA ST | - | - | - | - | - | - |
| 65969 | N/A | Point | - | - | - | - | S115289 | AMAZON AVE: LONDON ST | - | F | F | - | F | 21732000 | 21732000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | AMAZON AVE | AMAZON AVE | 13843 | 13843 | 37.716983991 | -122.439538386 | LONDON ST \ AMAZON AVE | LONDON ST \ AMAZON AVE | 1710539427000 | MTA | STOP | AMAZON AVE intersection | - | - | - | - | - | - | - | 83083 | 1025481600000 | -122.43964031 | 37.71695853 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373572320000 | LONDON ST | - | - | - | - | - | - |
| 65970 | N/A | Point | - | - | - | - | S115290 | AMAZON AVE: LONDON ST | - | F | F | - | F | 21732000 | 21732000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | AMAZON AVE | AMAZON AVE | 13844 | 13844 | 37.716932716 | -122.439731505 | LONDON ST \ AMAZON AVE | LONDON ST \ AMAZON AVE | 1710539427000 | MTA | STOP | AMAZON AVE intersection | - | - | - | - | - | - | - | 83084 | 1025481600000 | -122.43964031 | 37.71695853 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373572320000 | LONDON ST | - | - | - | - | - | - |
| 65971 | N/A | Point | - | - | - | - | S111749 | NAPLES ST: FRANCE AVE | - | F | F | - | F | 21713000 | 21713000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | NAPLES ST | FRANCE AVE | 13938 | 13938 | 37.717833132 | -122.433587536 | FRANCE AVE \ NAPLES ST | NAPLES ST \ FRANCE AVE | 1710539427000 | MTA | STOP | FRANCE AVE intersection | - | - | - | - | - | - | - | 83085 | 848880000000 | -122.43355535 | 37.71774402 | - | 1603670400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571240000 | NAPLES ST | - | - | - | - | - | - |
| 65972 | N/A | Point | - | - | - | - | S111750 | NAPLES ST: FRANCE AVE | - | F | F | - | F | 21713000 | 21713000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | NAPLES ST | FRANCE AVE | 13939 | 13939 | 37.717650664 | -122.433553562 | FRANCE AVE \ NAPLES ST | NAPLES ST \ FRANCE AVE | 1710539427000 | MTA | STOP | FRANCE AVE intersection | - | - | - | - | - | - | - | 83086 | 848880000000 | -122.43355535 | 37.71774402 | - | 1578528000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571240000 | NAPLES ST | - | - | - | - | - | - |
| 65973 | N/A | Point | - | - | - | - | S111753 | UTAH ST: 25TH ST | - | F | F | - | F | 23722000 | 23722000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | UTAH ST | 25TH ST | 13941 | 13941 | 37.75187178 | -122.405290848 | 25TH ST \ UTAH ST | UTAH ST \ 25TH ST | 1710539427000 | MTA | STOP | 25TH ST intersection | - | SEE PAINT | - | - | - | - | - | 83087 | 849052800000 | -122.4052077 | 37.75178695 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571240000 | UTAH ST | - | - | - | - | - | - |
| 65974 | N/A | Point | - | - | - | - | S111754 | UTAH ST: 25TH ST | - | F | F | - | F | 23722000 | 23722000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | UTAH ST | 25TH ST | 13942 | 13942 | 37.751705301 | -122.405124552 | 25TH ST \ UTAH ST | UTAH ST \ 25TH ST | 1710539427000 | MTA | STOP | 25TH ST intersection | - | 9' SOUTH OF 25TH ST | - | - | - | - | - | 83088 | 849052800000 | -122.4052077 | 37.75178695 | - | 1421884800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571240000 | UTAH ST | - | - | - | - | - | - |
| 65975 | N/A | Point | 1 | 1 | 3560 - 3599 | - | S112037 | 3560-3599 MISSION ST | 3560-3599 MISSION ST | F | F | - | F | 9142000 | 9142000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | RANDALL ST | RANDALL ST | 13947 | 13947 | 37.739118156 | -122.424120861 | - | - | 1710539427000 | MTA | STOP | RANDALL ST to APPLETON AVE (3560 - 3599) | - | - | - | - | - | - | - | 83089 | 903398400000 | -122.4238285 | 37.73937693 | - | 1662681600000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571300000 | MISSION ST | 3560 - 3599 MISSION ST | 3560 - 3599 MISSION ST | 3560 MISSION ST | - | APPLETON AVE | APPLETON AVE |
| 65976 | N/A | Point | 1 | 1 | 1400 - 1449 | - | S121960 | 1400-1425 SANCHEZ ST | 1400-1449 SANCHEZ ST | F | F | - | F | 11535000 | 11535000 | - | - | WEST SIDE | - | - | - | - | 27TH ST | 27TH ST | 14132 | 14132 | 37.74636149 | -122.42915472 | - | - | 1718069092000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "Z" PERMITS | 27TH ST to DUNCAN ST (1400 - 1449) | - | 30' S OF 27TH ST | - | - | - | - | - | 83090 | 1130889600000 | -122.42915472 | 37.74636149 | - | - | - | D8 | - | PARKING:RPP | REG | R32C(CA).0107 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373574420000 | SANCHEZ ST | 1400 - 1449 SANCHEZ ST | 1400 - 1449 SANCHEZ ST | 1400 SANCHEZ ST | - | DUNCAN ST | DUNCAN ST |
| 65977 | N/A | Point | - | - | - | - | S116406 | BRAZIL AVE: PRAGUE ST | - | F | F | - | F | 21616000 | 21616000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PRAGUE ST | BRAZIL AVE | 15499 | 15499 | 37.720493143 | -122.42614791 | BRAZIL AVE \ PRAGUE ST | PRAGUE ST \ BRAZIL AVE | 1750777719000 | middleware_editor | ALL WAY | BRAZIL AVE intersection | - | - | - | - | - | - | - | 83091 | 1049266800000 | -122.42602274 | 37.72049385 | - | 1750715820000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572680000 | PRAGUE ST | - | - | - | - | - | - |
| 65978 | N/A | Point | 1 | 1 | 33 - 70 | - | S120392 | 33-70 OCEAN AVE | 33-70 OCEAN AVE | F | F | - | F | 9805000 | 9805000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | PERSIA AVE | PERSIA AVE | 15536 | 15536 | 37.723667569 | -122.437170906 | - | - | 1715823285000 | middleware_editor | PEDESTRIAN (SYM) | PERSIA AVE to WATTSON PL (33 - 70) | - | 15' EAST OF WATTSON | - | - | - | - | - | 83092 | 1109030400000 | -122.4367346 | 37.72375526 | - | 1601251200000 | - | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373573940000 | OCEAN AVE | 33 - 70 OCEAN AVE | 33 - 70 OCEAN AVE | 33 OCEAN AVE | - | WATTSON PL | WATTSON PL |
| 65979 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S120402 | 1100-1199 PERSIA AVE | 1100-1199 PERSIA AVE | F | F | - | F | 10374000 | 10374000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | PRAGUE ST | PRAGUE ST | 15545 | 15545 | 37.718610514 | -122.42663766 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | PRAGUE ST to DUBLIN ST (1100 - 1199) | 097741 | WPL#1144 | - | - | - | - | - | 83093 | 1109116800000 | -122.42679144 | 37.71875196 | - | - | - | D11 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1373573940000 | PERSIA AVE | 1100 - 1199 PERSIA AVE | 1100 - 1199 PERSIA AVE | 1100 PERSIA AVE | - | DUBLIN ST | DUBLIN ST |
| 65980 | N/A | Point | - | - | - | - | S116677 | GOUGH ST: GOLDEN GATE AVE | - | F | F | - | F | 25942000 | 25942000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GOUGH ST | GOUGH ST | 15567 | 15567 | 37.780716026 | -122.423667958 | GOLDEN GATE AVE \ GOUGH ST | GOLDEN GATE AVE \ GOUGH ST | 1710539427000 | MTA | FREEWAY (LA) | GOUGH ST intersection | - | - | - | - | - | - | - | 83094 | 1051747200000 | -122.42373099 | 37.78061162 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-F(SF).0052 | 48X16 | SUP1 | LIGHT POLE | IS | 1373572740000 | GOLDEN GATE AVE | - | - | - | - | - | - |
| 65981 | N/A | Point | 1 | 1 | 1 - 99 | - | S116678 | 1-99 GOLDEN GATE AVE | 1-99 GOLDEN GATE AVE | F | F | - | F | - | 6259000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | - | 06TH ST \ MARKET ST \ TAYLOR ST | 15568 | 15568 | 37.78218719 | -122.411232569 | - | - | 1710539427000 | MTA | I-280 US 101 45DEG RA | 06TH ST \ MARKET ST \ TAYLOR ST to JONES ST (1 - 99) | - | 100W | - | - | - | - | - | 83095 | 1051747200000 | -122.41125738 | 37.78218666 | - | - | - | D6 | - | OTHER GUIDE | GUIDE | G-I(SF).0055 | 36X36 | SUP1 | LIGHT POLE | IS | 1373572740000 | GOLDEN GATE AVE | - | 1 - 99 GOLDEN GATE AVE | 1 GOLDEN GATE AVE | - | - | JONES ST |
| 65982 | N/A | Point | - | - | - | - | S121587 | 24TH ST: YORK ST | - | F | F | - | F | 23957000 | 23957000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 15589 | 15589 | 37.7528524 | -122.40818897 | YORK ST \ 24TH ST | YORK ST \ 24TH ST | 1714775233000 | middleware_editor | STOP | 24TH ST intersection | - | - | - | - | - | - | - | 83096 | 1125532800000 | -122.40818897 | 37.7528524 | - | 1689206400000 | - | D9 | - | STOP | REG | R1-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373574300000 | YORK ST | - | - | - | - | - | - |
| 65983 | N/A | Point | - | - | - | - | S115961 | BRAZIL AVE: MADRID ST | - | F | F | - | F | 21685000 | 21685000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MADRID ST | BRAZIL AVE | 15618 | 15618 | 37.723179262 | -122.431502596 | BRAZIL AVE \ MADRID ST | MADRID ST \ BRAZIL AVE | 1710539427000 | MTA | ALL WAY | BRAZIL AVE intersection | - | - | - | - | - | - | - | 83097 | 1043798400000 | -122.43163313 | 37.72316724 | - | - | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572500000 | MADRID ST | - | - | - | - | - | - |
| 65984 | N/A | Point | - | - | - | - | S115964 | MADRID ST: BRAZIL AVE | - | F | F | - | F | 21685000 | 21685000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MADRID ST | BRAZIL AVE | 15619 | 15619 | 37.723080256 | -122.431620613 | BRAZIL AVE \ MADRID ST | MADRID ST \ BRAZIL AVE | 1710539427000 | MTA | ALL WAY | BRAZIL AVE intersection | - | - | - | - | - | - | - | 83098 | 1043798400000 | -122.43163313 | 37.72316724 | - | 1685664000000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572500000 | MADRID ST | - | - | - | - | - | - |
| 65985 | N/A | Point | - | - | - | - | S115972 | SAN JOSE AVE: 23RD ST | - | F | F | - | F | 24110000 | 24110000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 23RD ST | 23RD ST | 15686 | 15686 | 37.753585176 | -122.421432039 | SAN JOSE AVE \ 23RD ST | SAN JOSE AVE \ 23RD ST | 1710539427000 | MTA | STOP | 23RD ST intersection | - | - | - | - | - | - | - | 83099 | 1043884800000 | -122.42151787 | 37.75366046 | - | 1578441600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373572560000 | SAN JOSE AVE | - | - | - | - | - | - |
| 65986 | N/A | Point | - | - | - | - | S115973 | 23RD ST: SAN JOSE AVE | - | F | F | - | F | 24110000 | 24110000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 23RD ST | 23RD ST | 15687 | 15687 | 37.7537209 | -122.421398512 | SAN JOSE AVE \ 23RD ST | SAN JOSE AVE \ 23RD ST | 1710539427000 | MTA | STOP | 23RD ST intersection | 120400656 | WOODEN POLE TO IFO TREE ON NEW 2IN | - | - | - | - | - | 83100 | 1043884800000 | -122.42151787 | 37.75366046 | - | 1629849600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373572560000 | SAN JOSE AVE | - | - | - | - | - | - |
| 65987 | N/A | Point | - | - | - | - | S115974 | 23RD ST: SAN JOSE AVE | - | F | F | - | F | 24110000 | 24110000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 23RD ST | 23RD ST | 15688 | 15688 | 37.753614865 | -122.421601018 | SAN JOSE AVE \ 23RD ST | SAN JOSE AVE \ 23RD ST | 1710539427000 | MTA | STOP | 23RD ST intersection | - | SWCORNER | - | - | - | - | - | 83101 | 1043884800000 | -122.42151787 | 37.75366046 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373572560000 | SAN JOSE AVE | - | - | - | - | - | - |
| 65988 | N/A | Point | - | - | - | - | S115976 | SAN JOSE AVE: 23RD ST | - | F | F | - | F | 24110000 | 24110000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 23RD ST | 23RD ST | 15689 | 15689 | 37.753614865 | -122.421596995 | SAN JOSE AVE \ 23RD ST | SAN JOSE AVE \ 23RD ST | 1710539427000 | MTA | ALL WAY | 23RD ST intersection | - | SECORNER | - | - | - | - | - | 83102 | 1043884800000 | -122.42151787 | 37.75366046 | - | 1574121600000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572560000 | SAN JOSE AVE | - | - | - | - | - | - |
| 65989 | N/A | Point | - | - | - | - | S120519 | BACON ST: GOETTINGEN ST | - | F | F | - | F | 20887000 | 20887000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GOETTINGEN ST | BACON ST | 15693 | 15693 | 37.726803362 | -122.406669092 | BACON ST \ GOETTINGEN ST | GOETTINGEN ST \ BACON ST | 1736968534000 | middleware_editor | ALL WAY | BACON ST intersection | - | - | - | - | - | - | - | 83103 | 1110153600000 | -122.40656538 | 37.72685852 | - | 1736862300000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1373574000000 | GOETTINGEN ST | - | - | - | - | - | - |
| 65990 | N/A | Point | - | - | - | - | S120520 | GOETTINGEN ST: BACON ST | - | F | F | - | F | 20887000 | 20887000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GOETTINGEN ST | BACON ST | 15694 | 15694 | 37.726929383 | -122.406654502 | BACON ST \ GOETTINGEN ST | GOETTINGEN ST \ BACON ST | 1736968555000 | middleware_editor | ALL WAY | BACON ST intersection | - | - | - | - | - | - | - | 83104 | 1110153600000 | -122.40656538 | 37.72685852 | - | 1736864100000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373574000000 | GOETTINGEN ST | - | - | - | - | - | - |
| 65991 | N/A | Point | 1 | 1 | 400 - 499 | - | S118532 | 400-499 RIVERA ST | 400-499 RIVERA ST | F | F | - | F | 11047000 | 11047000 | - | - | EAST SIDE | - | - | - | - | 14TH AVE | 14TH AVE | 15762 | 15762 | 37.747132101 | -122.469985617 | - | - | 1710539427000 | MTA | TANP ANY TIME (RA) | 14TH AVE to 15TH AVE (400 - 499) | - | INFO#324/ @ END OF STREET | - | - | - | - | - | 83105 | 1079308800000 | -122.47091545 | 37.74700202 | - | 1635984000000 | - | D7 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0043 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373573340000 | RIVERA ST | 400 - 499 RIVERA ST | 400 - 499 RIVERA ST | 400 RIVERA ST | - | 15TH AVE | 15TH AVE |
| 65992 | N/A | Point | 1 | 1 | 300 - 398 | - | S118544 | 300-398 LOS PALMOS DR | 300-398 LOS PALMOS DR | F | F | - | F | 8494000 | 8494000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | STANFORD HEIGHTS AVE | STANFORD HEIGHTS AVE | 15826 | 15826 | 37.73536268 | -122.45057522 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | STANFORD HEIGHTS AVE to BELLA VISTA WAY (300 - 398) | - | WPL#333 | - | - | - | - | - | 83106 | 1079481600000 | -122.45057522 | 37.73536268 | - | - | - | D7 | - | OTHER WARNING | WARNING | W3-1.0003 | 36X36 | SUP2 | 2IN IRON POST | IS | 1373573340000 | LOS PALMOS DR | 300 - 398 LOS PALMOS DR | 300 - 398 LOS PALMOS DR | 300 LOS PALMOS DR | - | BELLA VISTA WAY | BELLA VISTA WAY |
| 65993 | N/A | Point | 1 | 1 | 400 - 499 | - | S120486 | 400-499 EXCELSIOR AVE | 400-499 EXCELSIOR AVE | F | F | - | F | 5363000 | 5363000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | MADRID ST | MADRID ST | 15880 | 15880 | 37.724619091 | -122.430084797 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | MADRID ST to EDINBURGH ST (400 - 499) | 097770 | IFO#427 | - | - | - | - | - | 83107 | 1109721600000 | -122.43005261 | 37.72453423 | - | 1558396800000 | - | D11 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1373573940000 | EXCELSIOR AVE | 400 - 499 EXCELSIOR AVE | 400 - 499 EXCELSIOR AVE | 400 EXCELSIOR AVE | - | EDINBURGH ST | EDINBURGH ST |
| 65994 | N/A | Point | - | - | - | - | S123167 | UNION ST: STEINER ST | - | F | F | - | F | 26682000 | 26682000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | UNION ST | STEINER ST | 17307 | 17307 | 37.79687934 | -122.4371377 | STEINER ST \ UNION ST | UNION ST \ STEINER ST | 1730127499000 | middleware_editor | ALL WAY | STEINER ST intersection | - | - | - | - | - | - | - | 83108 | 1143504000000 | -122.4371377 | 37.79687934 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574780000 | UNION ST | - | - | - | - | - | - |
| 65995 | N/A | Point | - | - | - | - | S127092 | FRANCE AVE: MADRID ST | - | F | F | - | F | 21722000 | 21722000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FRANCE AVE | FRANCE AVE | 17312 | 17312 | 37.718509922 | -122.435038593 | MADRID ST \ FRANCE AVE | MADRID ST \ FRANCE AVE | 1710539427000 | MTA | STOP | FRANCE AVE intersection | - | - | - | - | - | - | - | 83109 | 1173744000000 | -122.43515661 | 37.7185078 | - | 1570665600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373576040000 | MADRID ST | - | - | - | - | - | - |
| 65996 | N/A | Point | - | - | - | - | S127093 | FRANCE AVE: MADRID ST | - | F | F | - | F | 21722000 | 21722000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FRANCE AVE | FRANCE AVE | 17313 | 17313 | 37.718499313 | -122.435279992 | MADRID ST \ FRANCE AVE | MADRID ST \ FRANCE AVE | 1710539427000 | MTA | STOP | FRANCE AVE intersection | - | - | - | - | - | - | - | 83110 | 1173744000000 | -122.43515661 | 37.7185078 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373576040000 | MADRID ST | - | - | - | - | - | - |
| 65997 | N/A | Point | - | - | - | - | S120592 | LA SALLE AVE: INGALLS ST | - | F | F | - | F | 20126000 | 20126000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LA SALLE AVE | INGALLS ST | 17351 | 17351 | 37.73058172 | -122.38143939 | INGALLS ST \ LA SALLE AVE | LA SALLE AVE \ INGALLS ST | 1710539427000 | MTA | SCHOOL (SYM) | INGALLS ST intersection | - | - | - | - | - | - | - | 83111 | 1110499200000 | -122.38143939 | 37.73058172 | - | - | - | D10 | - | SCHOOL | WARNING | S1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373574000000 | LA SALLE AVE | - | - | - | - | - | - |
| 65998 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S126697 | 1500-1599 MCKINNON AVE | 1500-1599 MCKINNON AVE | F | F | - | F | 8922000 | 8922000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | LANE ST | LANE ST | 17379 | 17379 | 37.73533986 | -122.38830079 | - | - | 1710539427000 | MTA | SPEED HUMP | LANE ST to MENDELL ST (1500 - 1599) | - | INFO #1506 | - | - | - | - | - | 83112 | 1171497600000 | -122.38830079 | 37.73533986 | - | 1469491200000 | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373575920000 | MCKINNON AVE | 1500 - 1599 MCKINNON AVE | 1500 - 1599 MCKINNON AVE | 1500 MCKINNON AVE | - | MENDELL ST | MENDELL ST |
| 65999 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S126698 | 1500-1599 MCKINNON AVE | 1500-1599 MCKINNON AVE | F | F | - | F | 8922000 | 8922000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | LANE ST | LANE ST | 17380 | 17380 | 37.73533986 | -122.38830079 | - | - | 1710539427000 | MTA | SPEED HUMP | LANE ST to MENDELL ST (1500 - 1599) | - | 0 / INSTALL SPEED HUMP SIGN ON SOUT..... | - | - | - | - | - | 83113 | 1171497600000 | -122.38830079 | 37.73533986 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373575920000 | MCKINNON AVE | 1500 - 1599 MCKINNON AVE | 1500 - 1599 MCKINNON AVE | 1500 MCKINNON AVE | - | MENDELL ST | MENDELL ST |
| 66000 | N/A | Point | 1 | 1 | 3350 - 3375 | - | S124234 | 3350-3375 24TH ST | 3350-3375 24TH ST | F | F | - | F | 1348000 | 1348000 | - | - | NORTH SIDE | - | - | - | - | BARTLETT ST | BARTLETT ST | 17383 | 17383 | 37.752197184 | -122.420033325 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | BARTLETT ST to ORANGE ALY (3350 - 3375) | - | IFO#3380 | - | - | - | - | - | 83114 | 1150934400000 | -122.41982076 | 37.7521553 | - | - | - | D9 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373575140000 | 24TH ST | 3350 - 3375 24TH ST | 3350 - 3375 24TH ST | 3350 24TH ST | - | ORANGE ALY | ORANGE ALY |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in meters