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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25276 | N/A | Point | - | - | - | - | S104955 | 2ND ST: HOWARD ST | - | T | T | - | F | 24540000 | 24540000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | HOWARD ST | 02ND ST | 1356 | 1356 | 37.78677895 | -122.39825696 | 2ND ST \ HOWARD ST | HOWARD ST \ 02ND ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | 02ND ST intersection | - | - | - | - | - | - | - | 42354 | 38966400000 | -122.39825696 | 37.78677895 | - | 1547769600000 | - | D6 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | OVERHEAD MAST ARM | IS | 1373569080000 | HOWARD ST | - | - | - | - | - | - |
| 25277 | N/A | Point | - | - | - | - | S104029 | CABRILLO ST: 36TH AVE | - | F | F | - | F | 27831000 | 27831000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 36TH AVE | 1357 | 1357 | 37.77389758 | -122.49611536 | 36TH AVE \ CABRILLO ST | CABRILLO ST \ 36TH AVE | 1737495743000 | middleware_editor | STOP | 36TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 42355 | -58752000000 | -122.49611536 | 37.77389758 | - | 1737121860000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373568780000 | CABRILLO ST | - | - | - | - | - | - |
| 25278 | N/A | Point | - | - | - | - | S104031 | CORBETT AVE: CLAYTON ST | - | F | F | - | F | 26193000 | 26193000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLAYTON ST | CORBETT AVE | 1358 | 1358 | 37.75872233 | -122.44602058 | CORBETT AVE \ CLAYTON ST | CLAYTON ST \ CORBETT AVE | 1710539427000 | MTA | STOP | CORBETT AVE intersection | - | 0 / 0 | - | - | - | - | - | 42356 | -58752000000 | -122.44602058 | 37.75872233 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568780000 | CLAYTON ST | - | - | - | - | - | - |
| 25279 | N/A | Point | - | - | - | - | S104032 | 36TH AVE: CABRILLO ST | - | F | F | - | F | 27831000 | 27831000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 36TH AVE | 1359 | 1359 | 37.77389758 | -122.49611536 | 36TH AVE \ CABRILLO ST | CABRILLO ST \ 36TH AVE | 1737495753000 | middleware_editor | STOP | 36TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 42357 | -58752000000 | -122.49611536 | 37.77389758 | - | 1737124020000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568780000 | CABRILLO ST | - | - | - | - | - | - |
| 25280 | N/A | Point | - | - | - | - | S104295 | DOUGLASS ST: 18TH ST | - | F | F | - | F | 26144000 | 26144000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DOUGLASS ST | DOUGLASS ST | 2090 | 2090 | 37.76062672 | -122.43933681 | 18TH ST \ DOUGLASS ST | 18TH ST \ DOUGLASS ST | 1719243954000 | middleware_editor | STOP | DOUGLASS ST intersection | - | - | - | - | - | - | - | 42358 | -24796800000 | -122.43933681 | 37.76062672 | - | 1582502400000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568900000 | 18TH ST | - | - | - | - | - | - |
| 25281 | N/A | Point | - | - | - | - | S104296 | 17TH AVE: KIRKHAM ST | - | F | F | - | F | 27354000 | 27354000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | KIRKHAM ST | 17TH AVE | 2091 | 2091 | 37.75992738 | -122.47472432 | 17TH AVE \ KIRKHAM ST | KIRKHAM ST \ 17TH AVE | 1719874642000 | middleware_editor | STOP | 17TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 42359 | -24793200000 | -122.47472432 | 37.75992738 | - | 1357603200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568900000 | KIRKHAM ST | - | - | - | - | - | - |
| 25282 | N/A | Point | - | - | - | - | S104298 | LANE ST: SHAFTER AVE | - | F | F | - | F | 20501000 | 20501000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SHAFTER AVE | SHAFTER AVE | 2092 | 2092 | 37.73103715 | -122.39072708 | LANE ST \ SHAFTER AVE | LANE ST \ SHAFTER AVE | 1710539427000 | MTA | STOP | SHAFTER AVE intersection | - | - | - | - | - | - | - | 42360 | -24710400000 | -122.39072708 | 37.73103715 | - | 1046649600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373568900000 | LANE ST | - | - | - | - | - | - |
| 25283 | N/A | Point | - | - | - | - | S104583 | EGBERT AVE: INGALLS ST | - | F | F | - | F | 20447000 | 20447000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | EGBERT AVE | EGBERT AVE | 2098 | 2098 | 37.72159985 | -122.39074534 | INGALLS ST \ EGBERT AVE | INGALLS ST \ EGBERT AVE | 1751469601000 | middleware_editor | STOP | EGBERT AVE intersection | - | - | - | - | - | - | - | 42361 | 10652400000 | -122.39074534 | 37.72159985 | - | 1651474800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568960000 | INGALLS ST | - | - | - | - | - | - |
| 25284 | N/A | Point | - | - | - | - | S104586 | DONNER AVE: INGALLS ST | - | F | F | - | F | 20449000 | 20449000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | INGALLS ST | DONNER AVE | 2100 | 2100 | 37.72222495 | -122.39018308 | DONNER AVE \ INGALLS ST | INGALLS ST \ DONNER AVE | 1721664043000 | middleware_editor | STOP | DONNER AVE intersection | - | 0 / 0 | - | - | - | - | - | 42362 | 10627200000 | -122.39018308 | 37.72222495 | - | 1721637900000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568960000 | INGALLS ST | - | - | - | - | - | - |
| 25285 | N/A | Point | - | - | - | - | S103925 | 24TH AVE: QUINTARA ST | - | F | F | - | F | 23269000 | 23269000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | QUINTARA ST | 24TH AVE | 2101 | 2101 | 37.74840903 | -122.48144024 | 24TH AVE \ QUINTARA ST | QUINTARA ST \ 24TH AVE | 1735579643000 | middleware_editor | STOP | 24TH AVE intersection | - | 0 / 00 | - | - | - | - | - | 42363 | -70934400000 | -122.48144024 | 37.74840903 | - | 1472169600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1373568780000 | QUINTARA ST | - | - | - | - | - | - |
| 25286 | N/A | Point | - | 1 | 1501 - 1599 | - | S103928 | 1501-1599 SAN JOSE AVE | 1501-1599 SAN JOSE AVE | F | F | - | T | 11439106 | 11439106 | - | - | WEST SIDE, WESTBOUND TRAFFIC | - | - | - | - | TINGLEY ST | TINGLEY ST | 2104 | 2104 | 37.73052066 | -122.43607554 | - | - | 1711562943000 | middleware_editor | NO LEFT TURN (SYM) | TINGLEY ST to THERESA ST (1501 - 1599) -- SOUTH -- | - | CENTER LINE OF TINGLEY | - | - | - | - | - | 42364 | -70416000000 | -122.43607554 | 37.73052066 | - | 1586736000000 | - | D11 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568780000 | SAN JOSE AVE | 1501 - 1599 SAN JOSE AVE | 1501 - 1599 SAN JOSE AVE | 1501 SAN JOSE AVE | - | THERESA ST | THERESA ST |
| 25287 | N/A | Point | - | - | - | - | S105776 | 16TH AVE: CABRILLO ST | - | F | F | - | F | 27454000 | 27454000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CABRILLO ST | CABRILLO ST | 2117 | 2117 | 37.77487657 | -122.47468611 | 16TH AVE \ CABRILLO ST | 16TH AVE \ CABRILLO ST | 1745434297000 | middleware_editor | STOP | CABRILLO ST intersection | - | 0 / 0 | - | - | - | - | - | 42365 | 101030400000 | -122.47468611 | 37.77487657 | - | 1060758000000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569320000 | 16TH AVE | - | - | - | - | - | - |
| 25288 | N/A | Point | - | - | - | - | S105480 | BRODERICK ST: GREENWICH ST | - | F | F | - | F | 26975000 | 26975000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GREENWICH ST | BRODERICK ST | 2138 | 2138 | 37.79789938 | -122.44413833 | BRODERICK ST \ GREENWICH ST | GREENWICH ST \ BRODERICK ST | 1710539427000 | MTA | STOP | BRODERICK ST intersection | - | 0 / 0 | - | - | - | - | - | 42366 | 78969600000 | -122.44413833 | 37.79789938 | - | 1135209600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569260000 | GREENWICH ST | - | - | - | - | - | - |
| 25289 | N/A | Point | - | - | - | - | S105486 | FUNSTON AVE: LAWTON ST | - | F | F | - | F | 27162000 | 27162000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FUNSTON AVE | LAWTON ST | 2139 | 2139 | 37.75825698 | -122.47020417 | LAWTON ST \ FUNSTON AVE | FUNSTON AVE \ LAWTON ST | 1710539427000 | MTA | STOP | LAWTON ST intersection | - | 0 / 0 | - | - | - | - | - | 42367 | 79315200000 | -122.47020417 | 37.75825698 | - | 1235088000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569260000 | FUNSTON AVE | - | - | - | - | - | - |
| 25290 | N/A | Point | - | - | - | - | S105487 | ORTEGA ST: 32ND AVE | - | F | F | - | F | 27677000 | 27677000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 32ND AVE | 32ND AVE | 2140 | 2140 | 37.7517585 | -122.49027038 | ORTEGA ST \ 32ND AVE | ORTEGA ST \ 32ND AVE | 1710539427000 | MTA | STOP | 32ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 42368 | 79315200000 | -122.49027038 | 37.7517585 | - | 1509062400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569260000 | ORTEGA ST | - | - | - | - | - | - |
| 25291 | N/A | Point | - | - | - | - | S105488 | LAWTON ST: FUNSTON AVE | - | F | F | - | F | 27162000 | 27162000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FUNSTON AVE | LAWTON ST | 2141 | 2141 | 37.75825698 | -122.47020417 | LAWTON ST \ FUNSTON AVE | FUNSTON AVE \ LAWTON ST | 1754585066000 | middleware_editor | STOP | LAWTON ST intersection | - | - | - | - | - | - | - | 42369 | 79340400000 | -122.47020417 | 37.75825698 | - | - | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569260000 | FUNSTON AVE | - | - | - | - | - | - |
| 25292 | N/A | Point | - | - | - | - | S105489 | LAWTON ST: FUNSTON AVE | - | F | F | - | F | 27162000 | 27162000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FUNSTON AVE | LAWTON ST | 2142 | 2142 | 37.75825698 | -122.47020417 | LAWTON ST \ FUNSTON AVE | FUNSTON AVE \ LAWTON ST | 1710539427000 | MTA | STOP | LAWTON ST intersection | - | 0 / 0 | - | - | - | - | - | 42370 | 79315200000 | -122.47020417 | 37.75825698 | - | 1208390400000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | FUNSTON AVE | - | - | - | - | - | - |
| 25293 | N/A | Point | - | - | - | - | S105490 | 18TH AVE: RIVERA ST | - | F | F | - | F | 23192000 | 23192000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RIVERA ST | 18TH AVE | 2143 | 2143 | 37.74682682 | -122.4748873 | 18TH AVE \ RIVERA ST | RIVERA ST \ 18TH AVE | 1710539427000 | MTA | STOP | 18TH AVE intersection | - | 5 FT FROM CURB IN STREET | - | - | - | - | - | 42371 | 80179200000 | -122.4748873 | 37.74682682 | - | 1669766400000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN BREAK-AWAY SYSTEM | IS | 1373569260000 | RIVERA ST | - | - | - | - | - | - |
| 25294 | N/A | Point | - | - | - | - | S105491 | 18TH AVE: RIVERA ST | - | F | F | - | F | 23192000 | 23192000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | RIVERA ST | 18TH AVE | 2144 | 2144 | 37.74682682 | -122.4748873 | 18TH AVE \ RIVERA ST | RIVERA ST \ 18TH AVE | 1710539427000 | MTA | STOP | 18TH AVE intersection | - | 0 / 00 | - | - | - | - | - | 42372 | 80179200000 | -122.4748873 | 37.74682682 | - | 610156800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | RIVERA ST | - | - | - | - | - | - |
| 25295 | N/A | Point | - | - | - | - | S105492 | MASON ST: CLAY ST | - | F | F | - | F | 25080000 | 25080000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLAY ST | CLAY ST | 2145 | 2145 | 37.79364256 | -122.41118648 | MASON ST \ CLAY ST | MASON ST \ CLAY ST | 1710539427000 | MTA | STOP | CLAY ST intersection | - | 0 / 0 | - | - | - | - | - | 42373 | 80352000000 | -122.41118648 | 37.79364256 | - | - | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569260000 | MASON ST | - | - | - | - | - | - |
| 25296 | N/A | Point | - | - | - | - | S107781 | 24TH AVE: ORTEGA ST | - | F | F | - | F | 27380000 | 27380000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ORTEGA ST | 24TH AVE | 2721 | 2721 | 37.752050376 | -122.481628954 | 24TH AVE \ ORTEGA ST | ORTEGA ST \ 24TH AVE | 1740499640000 | middleware_editor | STOP | 24TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 42374 | 254707200000 | -122.48170211 | 37.75214 | - | 1449619200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | ORTEGA ST | - | - | - | - | - | - |
| 25297 | N/A | Point | - | - | - | - | S107782 | 22ND AVE: IRVING ST | - | F | F | - | F | 27417000 | 27417000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | IRVING ST | 22ND AVE | 2722 | 2722 | 37.76342029 | -122.48033693 | 22ND AVE \ IRVING ST | IRVING ST \ 22ND AVE | 1710539427000 | MTA | STOP | 22ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 42375 | 255571200000 | -122.48033693 | 37.76342029 | - | 1710237780000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373569980000 | IRVING ST | - | - | - | - | - | - |
| 25298 | N/A | Point | - | - | - | - | S107784 | VALE AVE: CRESTLAKE DR | - | F | F | - | F | 23234000 | 23234000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VALE AVE | CRESTLAKE DR | 2723 | 2723 | 37.73527534 | -122.48412728 | CRESTLAKE DR \ VALE AVE | VALE AVE \ CRESTLAKE DR | 1752776800000 | middleware_editor | STOP | CRESTLAKE DR intersection | - | 0 / 0 | - | - | - | - | - | 42376 | 255772800000 | -122.48412728 | 37.73527534 | - | 1516348800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569980000 | VALE AVE | - | - | - | - | - | - |
| 25299 | N/A | Point | - | - | - | - | S106631 | VIRGINIA AVE: PROSPECT AVE | - | F | F | - | F | 21317000 | 21317000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VIRGINIA AVE | VIRGINIA AVE | 2725 | 2725 | 37.74231754 | -122.41949107 | PROSPECT AVE \ VIRGINIA AVE | PROSPECT AVE \ VIRGINIA AVE | 1710539427000 | MTA | STOP | VIRGINIA AVE intersection | - | 0 / 0 | - | - | - | - | - | 42377 | 154224000000 | -122.41949107 | 37.74231754 | - | 1678924800000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569620000 | PROSPECT AVE | - | - | - | - | - | - |
| 25300 | N/A | Point | 1 | 1 | 137 - 199 | - | S104772 | 137-199 POST ST | 137-199 POST ST | F | F | - | F | 10626000 | 10626000 | - | - | SOUTH SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | ROBERT KIRK LN | ROBERT KIRK LN | 2747 | 2747 | 37.78875033 | -122.40478258 | - | - | 1710539427000 | MTA | ONE WAY (LA) | ROBERT KIRK LN to GRANT AVE (137 - 199) | - | C LINE / MADE POST ONE-WAY EB BET G..... | - | - | - | - | - | 42378 | 28080000000 | -122.40478258 | 37.78875033 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373569020000 | POST ST | 137 - 199 POST ST | 137 - 199 POST ST | 137 POST ST | - | GRANT AVE | GRANT AVE |
| 25301 | N/A | Point | - | - | - | - | S104774 | GEARY ST: KEARNY ST | - | F | F | - | F | 24645000 | 24645000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | KEARNY ST | GEARY ST | 2748 | 2748 | 37.78796309 | -122.40349178 | GEARY ST \ KEARNY ST | KEARNY ST \ GEARY ST | 1710539427000 | MTA | ONE WAY (LA) | GEARY ST intersection | - | 30W / MADE GEARY ONE-WAY WB | - | - | - | - | - | 42379 | 28080000000 | -122.40349178 | 37.78796309 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569020000 | KEARNY ST | - | - | - | - | - | - |
| 25302 | N/A | Point | - | - | - | - | S104777 | POST ST: MONTGOMERY ST | - | F | F | - | F | 24623000 | 24623000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MONTGOMERY ST | MONTGOMERY ST | 2750 | 2750 | 37.78910265 | -122.40199747 | POST ST \ MONTGOMERY ST | POST ST \ MONTGOMERY ST | 1710539427000 | MTA | ONE WAY (LA) | MONTGOMERY ST intersection | - | 0 / MADE POST ONE-WAY EB BET GOUGH-..... | - | - | - | - | - | 42380 | 28080000000 | -122.40199747 | 37.78910265 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373569020000 | POST ST | - | - | - | - | - | - |
| 25303 | N/A | Point | - | - | - | - | S104778 | GEARY ST: POWELL ST | - | F | F | - | F | 24903000 | 24903000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POWELL ST | GEARY ST | 2751 | 2751 | 37.78735926 | -122.40822673 | GEARY ST \ POWELL ST | POWELL ST \ GEARY ST | 1720185875000 | middleware_editor | ONE WAY (LA) | GEARY ST intersection | - | 0 / MADE GEARY ONE-WAY WB | - | - | - | - | - | 42381 | 28080000000 | -122.40822673 | 37.78735926 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | 3IN IRON POST | IS | 1373569020000 | POWELL ST | - | - | - | - | - | - |
| 25304 | N/A | Point | - | - | - | - | S104779 | SUTTER ST: GRANT AVE | - | F | F | - | F | 24662000 | 24662000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GRANT AVE | GRANT AVE | 2752 | 2752 | 37.7896316 | -122.40539867 | SUTTER ST \ GRANT AVE | SUTTER ST \ GRANT AVE | 1733182211000 | middleware_editor | ONE WAY (LA) | GRANT AVE intersection | - | 0 / MADE SUTTER ONE-WAY WB MARKET-GOUGH | - | - | - | - | - | 42382 | 28080000000 | -122.40539867 | 37.7896316 | - | 1727685000000 | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373569020000 | SUTTER ST | - | - | - | - | - | - |
| 25305 | N/A | Point | - | - | - | - | S104902 | FOLSOM ST: THE EMBARCADERO | - | F | F | - | F | 24545000 | 24545000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | THE EMBARCADERO | FOLSOM ST | 2753 | 2753 | 37.79082695 | -122.39001235 | FOLSOM ST \ THE EMBARCADERO | THE EMBARCADERO \ FOLSOM ST | 1756240489000 | middleware_editor | STOP | FOLSOM ST intersection | - | 0 / MADE FOLSOM 1-WAY EB BET 11TH&E..... | - | - | - | - | - | 42383 | 38131200000 | -122.39001235 | 37.79082695 | - | - | 1756240440000 | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | RETD | 1373569080000 | THE EMBARCADERO | - | - | - | - | - | - |
| 25306 | N/A | Point | - | - | - | - | S104903 | 6TH ST: FOLSOM ST | - | F | F | - | F | 23941000 | 23941000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 06TH ST | FOLSOM ST | 2754 | 2754 | 37.77850511 | -122.40561527 | FOLSOM ST \ 06TH ST | 06TH ST \ FOLSOM ST | 1746552528000 | middleware_editor | NO LEFT TURN (SYM) | FOLSOM ST intersection | - | 0 / MADE FOLSOM 1-WAY EB BET 11TH&E..... | - | - | - | - | - | 42384 | 38131200000 | -122.40561527 | 37.77850511 | - | - | 1746552503000 | D6 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | UNKNOWN | RETD | 1373569080000 | 06TH ST | - | - | - | - | - | - |
| 25307 | N/A | Point | - | - | - | - | S104904 | 7TH ST: FOLSOM ST | - | F | F | - | F | 24262000 | 24262000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FOLSOM ST | FOLSOM ST | 2755 | 2755 | 37.77674611 | -122.40784206 | 7TH ST \ FOLSOM ST | 07TH ST \ FOLSOM ST | 1735673185000 | middleware_editor | NO LEFT TURN (SYM) | FOLSOM ST intersection | - | 0 / MADE FOLSOM 1-WAY EB BET 11TH&E..... | - | - | - | - | - | 42385 | 38102400000 | -122.40784206 | 37.77674611 | - | 1735639200000 | - | D6 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | UNKNOWN | IS | 1373569080000 | 07TH ST | - | - | - | - | - | - |
| 25308 | N/A | Point | - | - | - | - | S102588 | BRYANT ST: BEALE ST | - | F | F | - | F | 23599000 | 23599000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BEALE ST \ BRYANT ST | BEALE ST \ DELANCEY ST | 2756 | 2756 | 37.78622378 | -122.38963664 | DELANCEY ST \ BEALE ST \ BRYANT ST | BRYANT ST \ BEALE ST \ DELANCEY ST | 1710539427000 | MTA | DO NOT ENTER | BEALE ST \ DELANCEY ST intersection | - | 0 / 0 | - | - | - | - | - | 42386 | -387331200000 | -122.38963664 | 37.78622378 | - | - | - | D6 | - | OTHER REGULATORY | REG | R5-1.0002 | 24X24 | SUP1 | UNKNOWN | IS | 1373568360000 | BRYANT ST | - | - | - | - | - | - |
| 25309 | N/A | Point | - | - | - | - | S102590 | BRYANT ST: OAK GROVE ST | - | F | F | - | F | 23900000 | 23900000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BRYANT ST | BRYANT ST | 2758 | 2758 | 37.77692041 | -122.40140938 | OAK GROVE ST \ BRYANT ST | OAK GROVE ST \ BRYANT ST | 1710539427000 | MTA | ONE WAY (LA) | BRYANT ST intersection | - | 0 / 0 | - | - | - | - | - | 42387 | -387331200000 | -122.40140938 | 37.77692041 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373568360000 | OAK GROVE ST | - | - | - | - | - | - |
| 25310 | N/A | Point | - | - | - | - | S102591 | BRYANT ST: MORRIS ST | - | F | F | - | F | 23898000 | 23898000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MORRIS ST | BRYANT ST | 2759 | 2759 | 37.77647007 | -122.40197914 | BRYANT ST \ MORRIS ST | MORRIS ST \ BRYANT ST | 1710539427000 | MTA | ONE WAY (LA) | BRYANT ST intersection | - | 0 / 0 | - | - | - | - | - | 42388 | -387331200000 | -122.40197914 | 37.77647007 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373568360000 | MORRIS ST | - | - | - | - | - | - |
| 25311 | N/A | Point | - | - | - | - | S102592 | BRYANT ST: MORRIS ST | - | F | F | - | F | 23898000 | 23898000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MORRIS ST | BRYANT ST | 2760 | 2760 | 37.77647007 | -122.40197914 | BRYANT ST \ MORRIS ST | MORRIS ST \ BRYANT ST | 1710539427000 | MTA | ONE WAY (RA) | BRYANT ST intersection | - | 0 / 0 | - | - | - | - | - | 42389 | -387331200000 | -122.40197914 | 37.77647007 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568360000 | MORRIS ST | - | - | - | - | - | - |
| 25312 | N/A | Point | - | - | - | - | S101198 | HEMLOCK ST: POLK ST | - | F | F | - | F | 25201000 | 25201000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POLK ST | POLK ST | 531 | 531 | 37.78728003 | -122.42001957 | HEMLOCK ST \ POLK ST | HEMLOCK ST \ POLK ST | 1710539427000 | MTA | ONE WAY (RA) | POLK ST intersection | - | 0 / 0 | - | - | - | - | - | 42390 | -400032000000 | -122.42001957 | 37.78728003 | - | 1443398400000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373566680000 | HEMLOCK ST | - | - | - | - | - | - |
| 25313 | N/A | Point | - | - | - | - | S101199 | BUSH ST: LEAVENWORTH ST | - | F | F | - | F | 25165000 | 25165000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LEAVENWORTH ST | BUSH ST | 532 | 532 | 37.78931985 | -122.41537192 | BUSH ST \ LEAVENWORTH ST | LEAVENWORTH ST \ BUSH ST | 1752009277000 | middleware_editor | ONE WAY (RA) | BUSH ST intersection | - | 0 / 0 | - | - | - | - | - | 42391 | -400006800000 | -122.41537192 | 37.78931985 | - | 1752006600000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373566680000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 25314 | N/A | Point | - | - | - | - | S101200 | SUTTER ST: LARKIN ST | - | F | F | - | F | 25202000 | 25202000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SUTTER ST | SUTTER ST | 533 | 533 | 37.78796629 | -122.41846503 | LARKIN ST \ SUTTER ST | LARKIN ST \ SUTTER ST | 1746134362000 | middleware_editor | ONE WAY (RA) | SUTTER ST intersection | - | 0 / 0 | - | - | - | - | - | 42392 | - | -122.41846503 | 37.78796629 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | RETD | 1373566680000 | LARKIN ST | - | - | - | - | - | - |
| 25315 | N/A | Point | - | - | - | - | S101206 | GRIFFITH ST: PALOU AVE | - | F | F | - | F | 20073000 | 20073000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PALOU AVE | PALOU AVE | 538 | 538 | 37.72761779 | -122.37969656 | GRIFFITH ST \ PALOU AVE | GRIFFITH ST \ PALOU AVE | 1710539427000 | MTA | STOP | PALOU AVE intersection | - | 0 / 0 | - | - | - | - | - | 42393 | -399859200000 | -122.37969656 | 37.72761779 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566680000 | GRIFFITH ST | - | - | - | - | - | - |
| 25316 | N/A | Point | - | - | - | - | S101207 | KIRKWOOD AVE: EARL ST | - | F | F | - | F | 33128000 | 33128000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | EARL ST | EARL ST | 539 | 539 | 37.72863854 | -122.37315791 | KIRKWOOD AVE \ EARL ST | KIRKWOOD AVE \ EARL ST | 1710539427000 | MTA | STOP | EARL ST intersection | - | 0 / PRE-EXISTING SIGN/STREET DEEDED..... | - | - | - | - | - | 42394 | -399859200000 | -122.37315791 | 37.72863854 | - | 861235200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566680000 | KIRKWOOD AVE | - | - | - | - | - | - |
| 25317 | N/A | Point | 1 | 1 | 840 - 868 | - | S101021 | PNDG SAN JOSE AVE | 840-868 SAN JOSE AVE | F | F | - | F | 11438202 | 11438202 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | DOLORES ST | DOLORES ST | 600 | 600 | 37.74061379 | -122.42404649 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | DOLORES ST to DOLORES ST (840 - 868) -- WEST -- | - | N LINE / 00 | - | - | - | - | - | 42395 | -401241600000 | -122.42404649 | 37.74061379 | - | - | - | D8 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP2 | UNKNOWN | IS | 1373566620000 | SAN JOSE AVE | PNDG SAN JOSE AVE | 840 - 868 SAN JOSE AVE | - | - | DOLORES ST | DOLORES ST |
| 25318 | N/A | Point | - | - | - | - | S101024 | DUBLIN ST: PERSIA AVE | - | F | F | - | F | 21608000 | 21608000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PERSIA AVE | DUBLIN ST | 602 | 602 | 37.71856073 | -122.42639027 | DUBLIN ST \ PERSIA AVE | PERSIA AVE \ DUBLIN ST | 1721050781000 | middleware_editor | STOP | DUBLIN ST intersection | - | - | - | - | - | - | - | 42396 | -401155200000 | -122.42639027 | 37.71856073 | - | 1720775700000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566620000 | PERSIA AVE | - | - | - | - | - | - |
| 25319 | N/A | Point | - | - | - | - | S101025 | ACADIA ST: MONTEREY BLVD | - | F | F | - | F | 21815000 | 21815000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ACADIA ST | ACADIA ST | 603 | 603 | 37.7315898 | -122.43745754 | MONTEREY BLVD \ ACADIA ST | MONTEREY BLVD \ ACADIA ST | 1727918107000 | middleware_editor | STOP | ACADIA ST intersection | - | 0 / 0 | - | - | - | - | - | 42397 | -401155200000 | -122.43745754 | 37.7315898 | - | 1677542400000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566620000 | MONTEREY BLVD | - | - | - | - | - | - |
| 25320 | N/A | Point | - | - | - | - | S101027 | PERSIA AVE: DUBLIN ST | - | F | F | - | F | 21608000 | 21608000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PERSIA AVE | DUBLIN ST | 604 | 604 | 37.71856073 | -122.42639027 | DUBLIN ST \ PERSIA AVE | PERSIA AVE \ DUBLIN ST | 1720661266000 | middleware_editor | STOP | DUBLIN ST intersection | - | 0 / 0 | - | - | - | - | - | 42398 | -401155200000 | -122.42639027 | 37.71856073 | - | 1348099200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373566620000 | PERSIA AVE | - | - | - | - | - | - |
| 25321 | N/A | Point | - | - | - | - | S100513 | GOLDEN GATE AVE: JONES ST | - | T | T | - | F | 24326000 | 24326000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GOLDEN GATE AVE | GOLDEN GATE AVE | 605 | 605 | 37.78207307 | -122.41222074 | JONES ST \ GOLDEN GATE AVE | JONES ST \ GOLDEN GATE AVE | 1710539427000 | MTA | ONE WAY (RA) | GOLDEN GATE AVE intersection | - | 0 / 0 | - | - | - | - | - | 42399 | -404006400000 | -122.41222074 | 37.78207307 | - | 1620000000000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373566500000 | JONES ST | - | - | - | - | - | - |
| 25322 | N/A | Point | - | - | - | - | S100515 | GOLDEN GATE AVE: LARKIN ST | - | F | F | - | F | 24440000 | 24440000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GOLDEN GATE AVE | GOLDEN GATE AVE | 607 | 607 | 37.7814475 | -122.41714561 | LARKIN ST \ GOLDEN GATE AVE | LARKIN ST \ GOLDEN GATE AVE | 1750194770000 | middleware_editor | ONE WAY (RA) | GOLDEN GATE AVE intersection | - | 0 / 0 | - | - | - | - | - | 42400 | -403977600000 | -122.41714561 | 37.7814475 | - | 1750186800000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | LIGHT POLE | IS | 1373566500000 | LARKIN ST | - | - | - | - | - | - |
| 25323 | N/A | Point | - | - | - | - | S100752 | 20TH AVE: WINSTON DR | - | F | F | - | F | 33719000 | 33719000 | - | SHOULD BE RETIRED | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 20TH AVE | 20TH AVE | 608 | 608 | 37.72694991 | -122.47603947 | WINSTON DR \ 20TH AVE | WINSTON DR \ 20TH AVE | 1746135013000 | middleware_editor | STOP | 20TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 42401 | -402685200000 | -122.47603947 | 37.72694991 | - | 1396594800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | RETD | 1373566560000 | WINSTON DR | - | - | - | - | - | - |
| 25324 | N/A | Point | 1 | 1 | 10 - 13 | - | S100755 | 10-43 JUAN BAUTISTA CIR | 10-13 JUAN BAUTISTA CIR | F | F | - | F | 7623000 | 7623000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | CRESPI DR | CRESPI DR | 611 | 611 | 37.7186354 | -122.47791467 | - | - | 1721747479000 | middleware_editor | ONE WAY (RA) | CRESPI DR to FUENTE AVE (10 - 13) | - | OPP.C-LINE | - | - | - | - | - | 42402 | -402706800000 | -122.47791467 | 37.7186354 | - | 1721657700000 | - | D7 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | UNKNOWN | IS | 1373566560000 | JUAN BAUTISTA CIR | 10 - 13 JUAN BAUTISTA CIR | 10 - 13 JUAN BAUTISTA CIR | 10 JUAN BAUTISTA CIR | - | FUENTE AVE | FUENTE AVE |
| 25325 | N/A | Point | - | - | - | - | S104033 | 36TH AVE: CABRILLO ST | - | F | F | - | F | 27831000 | 27831000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 36TH AVE | 1360 | 1360 | 37.77389758 | -122.49611536 | 36TH AVE \ CABRILLO ST | CABRILLO ST \ 36TH AVE | 1737062888000 | middleware_editor | STOP | 36TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 42403 | -58752000000 | -122.49611536 | 37.77389758 | - | 1714401060000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568780000 | CABRILLO ST | - | - | - | - | - | - |
| 25326 | N/A | Point | - | - | - | - | S104034 | CLAYTON ST: CORBETT AVE | - | F | F | - | F | 26193000 | 26193000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CLAYTON ST | CORBETT AVE | 1361 | 1361 | 37.75872233 | -122.44602058 | CORBETT AVE \ CLAYTON ST | CLAYTON ST \ CORBETT AVE | 1710539427000 | MTA | STOP | CORBETT AVE intersection | - | 0 / 00 | - | - | - | - | - | 42404 | -57715200000 | -122.44602058 | 37.75872233 | - | 1171238400000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568780000 | CLAYTON ST | - | - | - | - | - | - |
| 25327 | N/A | Point | - | - | - | - | S104035 | CLAYTON ST: CORBETT AVE | - | F | F | - | F | 26193000 | 26193000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CLAYTON ST | CORBETT AVE | 1362 | 1362 | 37.75872233 | -122.44602058 | CORBETT AVE \ CLAYTON ST | CLAYTON ST \ CORBETT AVE | 1710539427000 | MTA | STOP | CORBETT AVE intersection | - | 0 / 00 | - | - | - | - | - | 42405 | -57715200000 | -122.44602058 | 37.75872233 | - | 1560211200000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | MUNI POLE | IS | 1373568780000 | CLAYTON ST | - | - | - | - | - | - |
| 25328 | N/A | Point | - | - | - | - | S104036 | SHRADER ST: PARNASSUS AVE | - | F | F | - | F | 26299000 | 26299000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SHRADER ST | SHRADER ST | 1363 | 1363 | 37.76468236 | -122.45121306 | PARNASSUS AVE \ SHRADER ST | PARNASSUS AVE \ SHRADER ST | 1710539427000 | MTA | STOP | SHRADER ST intersection | - | 0 / 0 | - | - | - | - | - | 42406 | -57628800000 | -122.45121306 | 37.76468236 | - | 1476921600000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373568780000 | PARNASSUS AVE | - | - | - | - | - | - |
| 25329 | N/A | Point | - | - | - | - | S104037 | SHRADER ST: PARNASSUS AVE | - | F | F | - | F | 26299000 | 26299000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SHRADER ST | SHRADER ST | 1364 | 1364 | 37.76468236 | -122.45121306 | PARNASSUS AVE \ SHRADER ST | PARNASSUS AVE \ SHRADER ST | 1710539427000 | MTA | STOP | SHRADER ST intersection | - | 0 / 0 | - | - | - | - | - | 42407 | -57628800000 | -122.45121306 | 37.76468236 | - | 1476921600000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UTILITY POLE | IS | 1373568780000 | PARNASSUS AVE | - | - | - | - | - | - |
| 25330 | N/A | Point | - | - | - | - | S105338 | MOUNT VERNON AVE: CAYUGA AVE | - | F | F | - | F | 22091000 | 22091000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CAYUGA AVE | CAYUGA AVE | 1365 | 1365 | 37.71708023 | -122.44580754 | MOUNT VERNON AVE \ CAYUGA AVE | MOUNT VERNON AVE \ CAYUGA AVE | 1726762171000 | middleware_editor | STOP | CAYUGA AVE intersection | - | 0 / 0 | - | - | - | - | - | 42408 | 67910400000 | -122.44580754 | 37.71708023 | - | 1726485600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569200000 | MOUNT VERNON AVE | - | - | - | - | - | - |
| 25331 | N/A | Point | - | - | - | - | S105339 | BUCHANAN ST: VALLEJO ST | - | F | F | - | F | 26579000 | 26579000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BUCHANAN ST | VALLEJO ST | 1366 | 1366 | 37.79564412 | -122.43182783 | VALLEJO ST \ BUCHANAN ST | BUCHANAN ST \ VALLEJO ST | 1710539427000 | MTA | STOP | VALLEJO ST intersection | - | 0 / 0 | - | - | - | - | - | 42409 | 67910400000 | -122.43182783 | 37.79564412 | - | 1556841600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569200000 | BUCHANAN ST | - | - | - | - | - | - |
| 25332 | N/A | Point | - | - | - | - | S105340 | JACKSON ST: WALNUT ST | - | F | F | - | F | 26955000 | 26955000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JACKSON ST | WALNUT ST | 1367 | 1367 | 37.79060811 | -122.44918958 | WALNUT ST \ JACKSON ST | JACKSON ST \ WALNUT ST | 1710539427000 | MTA | STOP | WALNUT ST intersection | - | 0 / 0 | - | - | - | - | - | 42410 | 67910400000 | -122.44918958 | 37.79060811 | - | 1704886740000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569200000 | JACKSON ST | - | - | - | - | - | - |
| 25333 | N/A | Point | - | - | - | - | S105341 | JACKSON ST: SPRUCE ST | - | F | F | - | F | 7415000 | 26951000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LOCUST ST | JACKSON ST | 1368 | 1368 | 37.78998032 | -122.45412091 | - | SPRUCE ST \ JACKSON ST | 1713574969000 | middleware_editor | STOP | JACKSON ST intersection | - | 0 / 00 | - | - | - | - | - | 42411 | 67910400000 | -122.45412091 | 37.78998032 | - | 1681344000000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569200000 | SPRUCE ST | 3500 - 3599 JACKSON ST | - | - | - | SPRUCE ST | - |
| 25334 | N/A | Point | - | - | - | - | S105342 | 26TH ST: SANCHEZ ST | - | F | F | - | F | 21922000 | 21922000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 26TH ST | 26TH ST | 1369 | 1369 | 37.74836226 | -122.4293465 | SANCHEZ ST \ 26TH ST | SANCHEZ ST \ 26TH ST | 1711491215000 | middleware_editor | STOP | 26TH ST intersection | - | 0 / 0 | - | - | - | - | - | 42412 | 67910400000 | -122.4293465 | 37.74836226 | - | 1590019200000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569200000 | SANCHEZ ST | - | - | - | - | - | - |
| 25335 | N/A | Point | - | - | - | - | S105343 | 26TH ST: SANCHEZ ST | - | F | F | - | F | 21922000 | 21922000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 26TH ST | 26TH ST | 1370 | 1370 | 37.74836226 | -122.4293465 | SANCHEZ ST \ 26TH ST | SANCHEZ ST \ 26TH ST | 1711491212000 | middleware_editor | STOP | 26TH ST intersection | - | 0 / 0 | - | - | - | - | - | 42413 | 67910400000 | -122.4293465 | 37.74836226 | - | 1590019200000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569200000 | SANCHEZ ST | - | - | - | - | - | - |
| 25336 | N/A | Point | - | - | - | - | S105344 | VICTORIA ST: URBANO DR | - | F | F | - | F | 22704000 | 22704000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VICTORIA ST | URBANO DR | 1371 | 1371 | 37.72314268 | -122.46463423 | URBANO DR \ VICTORIA ST | VICTORIA ST \ URBANO DR | 1717610826000 | middleware_editor | STOP | URBANO DR intersection | - | N-END OF BLOCK | - | - | - | - | - | 42414 | 67910400000 | -122.46463423 | 37.72314268 | - | 1434412800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569200000 | VICTORIA ST | - | - | - | - | - | - |
| 25337 | N/A | Point | - | - | - | - | S105345 | VICTORIA ST: URBANO DR | - | F | F | - | F | 22704000 | 22704000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VICTORIA ST | URBANO DR | 1372 | 1372 | 37.72314268 | -122.46463423 | URBANO DR \ VICTORIA ST | VICTORIA ST \ URBANO DR | 1717610855000 | middleware_editor | STOP | URBANO DR intersection | - | NORTH INTERSECTION | - | - | - | - | - | 42415 | 67910400000 | -122.46463423 | 37.72314268 | - | 1485302400000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569200000 | VICTORIA ST | - | - | - | - | - | - |
| 25338 | N/A | Point | - | - | - | - | S105348 | SELBY ST: PALOU AVE | - | F | F | - | F | 20754000 | 20754000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PALOU AVE | SELBY ST | 1374 | 1374 | 37.7392759 | -122.40024641 | SELBY ST \ PALOU AVE | PALOU AVE \ SELBY ST | 1721158473000 | middleware_editor | STOP | SELBY ST intersection | - | - | - | - | - | - | - | 42416 | 67910400000 | -122.40024641 | 37.7392759 | - | 1720516020000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569200000 | PALOU AVE | - | - | - | - | - | - |
| 25339 | N/A | Point | - | - | - | - | S105971 | 26TH AVE: EL CAMINO DEL MAR | - | F | F | - | F | 27668000 | 27668000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | EL CAMINO DEL MAR | EL CAMINO DEL MAR | 1396 | 1396 | 37.7875617 | -122.48635896 | 26TH AVE \ EL CAMINO DEL MAR | 26TH AVE \ EL CAMINO DEL MAR | 1739888481000 | middleware_editor | STOP | EL CAMINO DEL MAR intersection | - | 0 / 0 | - | - | - | - | - | 42417 | 111369600000 | -122.48635896 | 37.7875617 | - | 1739540580000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569380000 | 26TH AVE | - | - | - | - | - | - |
| 25340 | N/A | Point | - | - | - | - | S105972 | 26TH AVE: EL CAMINO DEL MAR | - | F | F | - | F | 27668000 | 27668000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | EL CAMINO DEL MAR | EL CAMINO DEL MAR | 1397 | 1397 | 37.7875617 | -122.48635896 | 26TH AVE \ EL CAMINO DEL MAR | 26TH AVE \ EL CAMINO DEL MAR | 1739888487000 | middleware_editor | STOP | EL CAMINO DEL MAR intersection | - | 0 / 0 | - | - | - | - | - | 42418 | 111369600000 | -122.48635896 | 37.7875617 | - | 1739540400000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569380000 | 26TH AVE | - | - | - | - | - | - |
| 25341 | N/A | Point | - | - | - | - | S105973 | EL CAMINO DEL MAR: 26TH AVE | - | F | F | - | F | 27668000 | 27668000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | EL CAMINO DEL MAR | EL CAMINO DEL MAR | 1398 | 1398 | 37.7875617 | -122.48635896 | 26TH AVE \ EL CAMINO DEL MAR | 26TH AVE \ EL CAMINO DEL MAR | 1739888478000 | middleware_editor | STOP | EL CAMINO DEL MAR intersection | - | 0 / 0 | - | - | - | - | - | 42419 | 111369600000 | -122.48635896 | 37.7875617 | - | 1739540520000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569380000 | 26TH AVE | - | - | - | - | - | - |
| 25342 | N/A | Point | 1 | 1 | 100 - 199 | - | S103976 | 100-199 WASHINGTON ST | 100-199 WASHINGTON ST | F | F | - | F | 13404000 | 13404000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | DRUMM ST | DRUMM ST | 1399 | 1399 | 37.79626647 | -122.39755495 | - | - | 1710539427000 | MTA | STOP | DRUMM ST to DAVIS ST (100 - 199) | - | E LINE / 0 | - | - | - | - | - | 42420 | -67305600000 | -122.39755495 | 37.79626647 | - | - | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568780000 | WASHINGTON ST | 100 - 199 WASHINGTON ST | 100 - 199 WASHINGTON ST | 100 WASHINGTON ST | - | DAVIS ST | DAVIS ST |
| 25343 | N/A | Point | - | - | - | - | S103977 | WASHINGTON ST: DRUMM ST | - | F | F | - | F | 24571000 | 24571000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | DRUMM ST | 1400 | 1400 | 37.79634686 | -122.39695784 | DRUMM ST \ WASHINGTON ST | WASHINGTON ST \ DRUMM ST | 1710539427000 | MTA | STOP | DRUMM ST intersection | - | 00 / 0 | - | - | - | - | - | 42421 | -67305600000 | -122.39695784 | 37.79634686 | - | - | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568780000 | WASHINGTON ST | - | - | - | - | - | - |
| 25344 | N/A | Point | - | - | - | - | S105567 | 21ST AVE: ULLOA ST | - | F | F | - | F | 23172000 | 23172000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ULLOA ST | 21ST AVE | 2151 | 2151 | 37.74109056 | -122.47770325 | 21ST AVE \ ULLOA ST | ULLOA ST \ 21ST AVE | 1730393946000 | middleware_editor | STOP | 21ST AVE intersection | - | 0 / 0 | - | - | - | - | - | 42422 | 82684800000 | -122.47770325 | 37.74109056 | - | 1215648000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | ULLOA ST | - | - | - | - | - | - |
| 25345 | N/A | Point | - | - | - | - | S105568 | 37TH AVE: WAWONA ST | - | F | F | - | F | 23369000 | 23369000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WAWONA ST | 37TH AVE | 2152 | 2152 | 37.73660493 | -122.49459081 | 37TH AVE \ WAWONA ST | WAWONA ST \ 37TH AVE | 1710539427000 | MTA | STOP | 37TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 42423 | 82684800000 | -122.49459081 | 37.73660493 | - | 1491436800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | WAWONA ST | - | - | - | - | - | - |
| 25346 | N/A | Point | - | - | - | - | S105569 | 37TH AVE: WAWONA ST | - | F | F | - | F | 23369000 | 23369000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WAWONA ST | 37TH AVE | 2153 | 2153 | 37.73660493 | -122.49459081 | 37TH AVE \ WAWONA ST | WAWONA ST \ 37TH AVE | 1710539427000 | MTA | STOP | 37TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 42424 | 82684800000 | -122.49459081 | 37.73660493 | - | 1491436800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | WAWONA ST | - | - | - | - | - | - |
| 25347 | N/A | Point | - | - | - | - | S105574 | TINGLEY ST: MISSION ST | - | F | F | - | F | 21764000 | 21764000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MISSION ST | TINGLEY ST | 2156 | 2156 | 37.72824947 | -122.4318008 | TINGLEY ST \ MISSION ST | MISSION ST \ TINGLEY ST | 1710539427000 | MTA | STOP | TINGLEY ST intersection | - | 0 / 0 | - | - | - | - | - | 42425 | 86227200000 | -122.4318008 | 37.72824947 | - | 1553212800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | MISSION ST | - | - | - | - | - | - |
| 25348 | N/A | Point | - | - | - | - | S105575 | ALPHA ST: ARLETA AVE | - | F | F | - | F | 20319000 | 20319000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ALPHA ST | ARLETA AVE | 2157 | 2157 | 37.71321573 | -122.40484243 | ARLETA AVE \ ALPHA ST | ALPHA ST \ ARLETA AVE | 1710539427000 | MTA | STOP | ARLETA AVE intersection | - | 0 / 0 | - | - | - | - | - | 42426 | 86227200000 | -122.40484243 | 37.71321573 | - | 1184889600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569260000 | ALPHA ST | - | - | - | - | - | - |
| 25349 | N/A | Point | - | - | - | - | S105576 | ALPHA ST: ARLETA AVE | - | F | F | - | F | 20319000 | 20319000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ALPHA ST | ARLETA AVE | 2158 | 2158 | 37.71321573 | -122.40484243 | ARLETA AVE \ ALPHA ST | ALPHA ST \ ARLETA AVE | 1710539427000 | MTA | STOP | ARLETA AVE intersection | - | 0 / 0 | - | - | - | - | - | 42427 | 86227200000 | -122.40484243 | 37.71321573 | - | 1184889600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569260000 | ALPHA ST | - | - | - | - | - | - |
| 25350 | N/A | Point | - | - | - | - | S105580 | ANZA ST: 43RD AVE | - | F | F | - | F | 27910000 | 27910000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 43RD AVE | ANZA ST | 2162 | 2162 | 37.777366233 | -122.503770695 | ANZA ST \ 43RD AVE | 43RD AVE \ ANZA ST | 1753114953000 | middleware_editor | STOP | ANZA ST intersection | - | 0 / 0 | - | - | - | - | - | 42428 | 86252400000 | -122.50388062 | 37.77728731 | - | 1218610800000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569260000 | 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