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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26101 | N/A | Point | - | - | - | - | S106090 | NORIEGA ST: 24TH AVE | - | F | F | - | F | 27382000 | 27382000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 24TH AVE | NORIEGA ST | 2010 | 2010 | 37.75400423 | -122.48183185 | NORIEGA ST \ 24TH AVE | 24TH AVE \ NORIEGA ST | 1710539427000 | MTA | STOP | NORIEGA ST intersection | - | 0 / 0 | - | - | - | - | - | 43180 | 120960000000 | -122.48183185 | 37.75400423 | - | 1511740800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373569440000 | 24TH AVE | - | - | - | - | - | - |
| 26102 | N/A | Point | - | - | - | - | S106091 | NORIEGA ST: 24TH AVE | - | F | F | - | F | 27382000 | 27382000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 24TH AVE | NORIEGA ST | 2011 | 2011 | 37.75400423 | -122.48183185 | NORIEGA ST \ 24TH AVE | 24TH AVE \ NORIEGA ST | 1710539427000 | MTA | STOP | NORIEGA ST intersection | - | 0 / 0 | - | - | - | - | - | 43181 | 120960000000 | -122.48183185 | 37.75400423 | - | 1509494400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569440000 | 24TH AVE | - | - | - | - | - | - |
| 26103 | N/A | Point | - | - | - | - | S106092 | 21ST AVE: VICENTE ST | - | F | F | - | F | 23170000 | 23170000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VICENTE ST | 21ST AVE | 2012 | 2012 | 37.7393285777539 | -122.47765962034 | 21ST AVE \ VICENTE ST | VICENTE ST \ 21ST AVE | 1748978288000 | middleware_editor | STOP | 21ST AVE intersection | - | 0 / 0 | - | - | - | - | - | 43182 | 121075200000 | -122.47757391 | 37.73923019 | - | 1464246000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | VICENTE ST | - | - | - | - | - | - |
| 26104 | N/A | Point | - | - | - | - | S106138 | FOLSOM ST: TOMPKINS AVE | - | F | F | - | F | 21055000 | 21055000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | FOLSOM ST | 2017 | 2017 | 37.73706991 | -122.4134776 | FOLSOM ST \ TOMPKINS AVE | TOMPKINS AVE \ FOLSOM ST | 1746473591000 | middleware_editor | STOP | FOLSOM ST intersection | - | 0 / 00 | - | - | - | - | - | 43183 | 124617600000 | -122.4134776 | 37.73706991 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569440000 | TOMPKINS AVE | - | - | - | - | - | - |
| 26105 | N/A | Point | - | - | - | - | S106139 | FOLSOM ST: TOMPKINS AVE | - | F | F | - | F | 21055000 | 21055000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | FOLSOM ST | 2018 | 2018 | 37.73706991 | -122.4134776 | FOLSOM ST \ TOMPKINS AVE | TOMPKINS AVE \ FOLSOM ST | 1752158649000 | middleware_editor | STOP | FOLSOM ST intersection | - | - | - | - | - | - | - | 43184 | 124617600000 | -122.4134776 | 37.73706991 | - | 1597820400000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | TOMPKINS AVE | - | - | - | - | - | - |
| 26106 | N/A | Point | - | - | - | - | S106141 | TOMPKINS AVE: FOLSOM ST | - | F | F | - | F | 21055000 | 21055000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | FOLSOM ST | 2020 | 2020 | 37.73706991 | -122.4134776 | FOLSOM ST \ TOMPKINS AVE | TOMPKINS AVE \ FOLSOM ST | 1747153990000 | middleware_editor | STOP | FOLSOM ST intersection | - | - | - | - | - | - | - | 43185 | 124617600000 | -122.4134776 | 37.73706991 | - | 1747075020000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | TOMPKINS AVE | - | - | - | - | - | - |
| 26107 | N/A | Point | - | - | - | - | S105296 | 22ND ST: EUREKA ST | - | F | F | - | F | 25766000 | 25766000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 22ND ST | EUREKA ST | 2028 | 2028 | 37.75429555 | -122.43764854 | EUREKA ST \ 22ND ST | 22ND ST \ EUREKA ST | 1710539427000 | MTA | STOP | EUREKA ST intersection | - | 0 / 0 | - | - | - | - | - | 43186 | 66700800000 | -122.43764854 | 37.75429555 | - | 1590710400000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569200000 | 22ND ST | - | - | - | - | - | - |
| 26108 | N/A | Point | - | - | - | - | S105594 | MARY ST: NATOMA ST | - | F | F | - | F | 24283000 | 24283000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | NATOMA ST | NATOMA ST | 2511 | 2511 | 37.78130585 | -122.40624778 | MARY ST \ NATOMA ST | MARY ST \ NATOMA ST | 1738964749000 | middleware_editor | STOP | NATOMA ST intersection | - | 0 / 0 | - | - | - | - | - | 43187 | 86572800000 | -122.40624778 | 37.78130585 | - | 1645574400000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569260000 | MARY ST | - | - | - | - | - | - |
| 26109 | N/A | Point | - | - | - | - | S105596 | 21ST AVE: LAWTON ST | - | F | F | - | F | 27346000 | 27346000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LAWTON ST | 21ST AVE | 2513 | 2513 | 37.7578726 | -122.47887452 | 21ST AVE \ LAWTON ST | LAWTON ST \ 21ST AVE | 1744744185000 | middleware_editor | STOP | 21ST AVE intersection | - | 0 / 0 | - | - | - | - | - | 43188 | 86943600000 | -122.47887452 | 37.7578726 | - | 1467097200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | LAWTON ST | - | - | - | - | - | - |
| 26110 | N/A | Point | - | - | - | - | S105600 | 28TH AVE: IRVING ST | - | F | F | - | F | 27437000 | 27437000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 28TH AVE | 28TH AVE | 2514 | 2514 | 37.76313687 | -122.48677043 | IRVING ST \ 28TH AVE | IRVING ST \ 28TH AVE | 1737581272000 | middleware_editor | STOP | 28TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43189 | 87523200000 | -122.48677043 | 37.76313687 | - | 1465430400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | IRVING ST | - | - | - | - | - | - |
| 26111 | N/A | Point | - | - | - | - | S105601 | 28TH AVE: IRVING ST | - | F | F | - | F | 27437000 | 27437000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 28TH AVE | 28TH AVE | 2515 | 2515 | 37.76313687 | -122.48677043 | IRVING ST \ 28TH AVE | IRVING ST \ 28TH AVE | 1737580404000 | middleware_editor | STOP | 28TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43190 | 87523200000 | -122.48677043 | 37.76313687 | - | 1465430400000 | 1737551460000 | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | RETD | 1373569260000 | IRVING ST | - | - | - | - | - | - |
| 26112 | N/A | Point | - | - | - | - | S105603 | CABRILLO ST: 40TH AVE | - | F | F | - | F | 27873000 | 27873000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 40TH AVE | CABRILLO ST | 2516 | 2516 | 37.77370199 | -122.50038632 | CABRILLO ST \ 40TH AVE | 40TH AVE \ CABRILLO ST | 1710539427000 | MTA | STOP | CABRILLO ST intersection | - | 0 / 0 | - | - | - | - | - | 43191 | 87523200000 | -122.50038632 | 37.77370199 | - | 1597017600000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | 40TH AVE | - | - | - | - | - | - |
| 26113 | N/A | Point | - | - | - | - | S105604 | CABRILLO ST: 40TH AVE | - | F | F | - | F | 27873000 | 27873000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 40TH AVE | CABRILLO ST | 2517 | 2517 | 37.77370199 | -122.50038632 | CABRILLO ST \ 40TH AVE | 40TH AVE \ CABRILLO ST | 1710539427000 | MTA | STOP | CABRILLO ST intersection | - | 0 / 0 | - | - | - | - | - | 43192 | 87523200000 | -122.50038632 | 37.77370199 | - | 1707137700000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | 40TH AVE | - | - | - | - | - | - |
| 26114 | N/A | Point | - | - | - | - | S105605 | 40TH AVE: CABRILLO ST | - | F | F | - | F | 27873000 | 27873000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 40TH AVE | CABRILLO ST | 2518 | 2518 | 37.77370199 | -122.50038632 | CABRILLO ST \ 40TH AVE | 40TH AVE \ CABRILLO ST | 1710539427000 | MTA | STOP | CABRILLO ST intersection | - | 0 / 0 | - | - | - | - | - | 43193 | 87523200000 | -122.50038632 | 37.77370199 | - | 1707137280000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | 40TH AVE | - | - | - | - | - | - |
| 26115 | N/A | Point | - | - | - | - | S105606 | 40TH AVE: CABRILLO ST | - | F | F | - | F | 27873000 | 27873000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 40TH AVE | CABRILLO ST | 2519 | 2519 | 37.77370199 | -122.50038632 | CABRILLO ST \ 40TH AVE | 40TH AVE \ CABRILLO ST | 1710539427000 | MTA | STOP | CABRILLO ST intersection | - | 0 / 0 | - | - | - | - | - | 43194 | 87523200000 | -122.50038632 | 37.77370199 | - | 1707313800000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | 40TH AVE | - | - | - | - | - | - |
| 26116 | N/A | Point | - | - | - | - | S105607 | 14TH AVE: IRVING ST | - | F | F | - | F | 27174000 | 27174000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 14TH AVE | 14TH AVE | 2520 | 2520 | 37.76380165 | -122.4716678 | IRVING ST \ 14TH AVE | IRVING ST \ 14TH AVE | 1744130667000 | middleware_editor | STOP | 14TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43195 | 87548400000 | -122.4716678 | 37.76380165 | - | 1478592000000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569260000 | IRVING ST | - | - | - | - | - | - |
| 26117 | N/A | Point | - | - | - | - | S105609 | VICKSBURG ST: ELIZABETH ST | - | F | F | - | F | 25650000 | 25650000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ELIZABETH ST | ELIZABETH ST | 2522 | 2522 | 37.75238229 | -122.42861457 | VICKSBURG ST \ ELIZABETH ST | VICKSBURG ST \ ELIZABETH ST | 1710539427000 | MTA | STOP | ELIZABETH ST intersection | - | 0 / 0 | - | - | - | - | - | 43196 | 87696000000 | -122.42861457 | 37.75238229 | - | 1511222400000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569260000 | VICKSBURG ST | - | - | - | - | - | - |
| 26118 | N/A | Point | - | - | - | - | S104238 | ULLOA ST: 40TH AVE | - | F | F | - | F | 23438000 | 23438000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 40TH AVE | 40TH AVE | 2535 | 2535 | 37.74019087 | -122.49805904 | ULLOA ST \ 40TH AVE | ULLOA ST \ 40TH AVE | 1710539427000 | MTA | STOP | 40TH AVE intersection | - | 00 / 00 | - | - | - | - | - | 43197 | -35164800000 | -122.49805904 | 37.74019087 | - | 1507852800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568840000 | ULLOA ST | - | - | - | - | - | - |
| 26119 | N/A | Point | - | - | - | - | S104239 | 22ND AVE: KIRKHAM ST | - | F | F | - | F | 27409000 | 27409000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 22ND AVE | 22ND AVE | 2536 | 2536 | 37.75969027 | -122.48007567 | KIRKHAM ST \ 22ND AVE | KIRKHAM ST \ 22ND AVE | 1710539427000 | MTA | STOP | 22ND AVE intersection | - | 0 / 00 | - | - | - | - | - | 43198 | -35078400000 | -122.48007567 | 37.75969027 | - | 1467158400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1373568840000 | KIRKHAM ST | - | - | - | - | - | - |
| 26120 | N/A | Point | - | - | - | - | S104240 | 22ND AVE: KIRKHAM ST | - | F | F | - | F | 27409000 | 27409000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 22ND AVE | 22ND AVE | 2537 | 2537 | 37.75969027 | -122.48007567 | KIRKHAM ST \ 22ND AVE | KIRKHAM ST \ 22ND AVE | 1710539427000 | MTA | STOP | 22ND AVE intersection | - | 0 / 00 | - | - | - | - | - | 43199 | -35078400000 | -122.48007567 | 37.75969027 | - | 1467158400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568840000 | KIRKHAM ST | - | - | - | - | - | - |
| 26121 | N/A | Point | - | - | - | - | S104241 | LEAVENWORTH ST: NORTH POINT ST | - | F | F | - | F | 25575000 | 25575000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | NORTH POINT ST | NORTH POINT ST | 2538 | 2538 | 37.80593152 | -122.41871827 | LEAVENWORTH ST \ NORTH POINT ST | LEAVENWORTH ST \ NORTH POINT ST | 1710539427000 | MTA | STOP | NORTH POINT ST intersection | - | - | - | - | - | - | - | 43200 | -35078400000 | -122.41871827 | 37.80593152 | - | 1462492800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568840000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 26122 | N/A | Point | - | - | - | - | S105015 | FRANCISCO ST: POWELL ST | - | F | F | - | F | 25458000 | 25458000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | POWELL ST | FRANCISCO ST | 2539 | 2539 | 37.80489601 | -122.41176648 | FRANCISCO ST \ POWELL ST | POWELL ST \ FRANCISCO ST | 1712095954000 | middleware_editor | STOP | FRANCISCO ST intersection | - | 0 / 0 | - | - | - | - | - | 43201 | 41126400000 | -122.41176648 | 37.80489601 | - | 1554940800000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569080000 | POWELL ST | - | - | - | - | - | - |
| 26123 | N/A | Point | - | - | - | - | S105016 | 9TH AVE: LINCOLN WAY | - | F | F | - | F | 27156000 | 27156000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 09TH AVE | 09TH AVE | 2540 | 2540 | 37.7660115937463 | -122.466565201384 | LINCOLN WAY \ 09TH AVE | LINCOLN WAY \ 09TH AVE | 1753373867000 | middleware_editor | NO LEFT TURN (SYM) | 09TH AVE intersection | - | - | - | - | - | - | - | 43202 | 41151600000 | -122.46644249 | 37.76592466 | - | 1753372800000 | - | D5 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1373569080000 | LINCOLN WAY | - | - | - | - | - | - |
| 26124 | N/A | Point | - | - | - | - | S105017 | GREEN ST: HYDE ST | - | F | F | - | F | 25311000 | 25311000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HYDE ST | GREEN ST | 2541 | 2541 | 37.79826458 | -122.41885988 | GREEN ST \ HYDE ST | HYDE ST \ GREEN ST | 1710539427000 | MTA | STOP | GREEN ST intersection | - | 0 / 0 | - | - | - | - | - | 43203 | 41212800000 | -122.41885988 | 37.79826458 | - | 1116288000000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569080000 | HYDE ST | - | - | - | - | - | - |
| 26125 | N/A | Point | - | - | - | - | S105018 | GREEN ST: HYDE ST | - | F | F | - | F | 25311000 | 25311000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HYDE ST | GREEN ST | 2542 | 2542 | 37.79826458 | -122.41885988 | GREEN ST \ HYDE ST | HYDE ST \ GREEN ST | 1710539427000 | MTA | STOP | GREEN ST intersection | - | 0 / 0 | - | - | - | - | - | 43204 | 41212800000 | -122.41885988 | 37.79826458 | - | 1116288000000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569080000 | HYDE ST | - | - | - | - | - | - |
| 26126 | N/A | Point | - | - | - | - | S105019 | GRANADA AVE: GRAFTON AVE | - | F | F | - | F | 22578000 | 22578000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GRANADA AVE | GRANADA AVE | 2543 | 2543 | 37.72003024 | -122.45715834 | GRAFTON AVE \ GRANADA AVE | GRAFTON AVE \ GRANADA AVE | 1718327531000 | middleware_editor | STOP | GRANADA AVE intersection | - | - | - | - | - | - | - | 43205 | 41472000000 | -122.45715834 | 37.72003024 | - | 1534723200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1373569080000 | GRAFTON AVE | - | - | - | - | - | - |
| 26127 | N/A | Point | - | - | - | - | S105020 | GRANADA AVE: GRAFTON AVE | - | F | F | - | F | 22578000 | 22578000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GRANADA AVE | GRANADA AVE | 2544 | 2544 | 37.72003024 | -122.45715834 | GRAFTON AVE \ GRANADA AVE | GRAFTON AVE \ GRANADA AVE | 1718327533000 | middleware_editor | STOP | GRANADA AVE intersection | - | 0 / 0 | - | - | - | - | - | 43206 | 41472000000 | -122.45715834 | 37.72003024 | - | 1534723200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569080000 | GRAFTON AVE | - | - | - | - | - | - |
| 26128 | N/A | Point | 1 | 1 | 442 - 499 | - | S282381 | 442-499 OFARRELL ST | 442-499 OFARRELL ST | F | F | - | F | 9728000 | 9728000 | - | - | SOUTH SIDE | - | - | - | - | SHANNON ST | SHANNON ST | 89734 | 89734 | 37.78584126 | -122.41255859 | - | - | 1710539427000 | MTA | BIKE RACK RAPID | SHANNON ST to JONES ST (442 - 499) | - | 1' E OF EPL 477/5.5' IN FROM CURB | - | - | - | - | - | 43207 | 1654646400000 | -122.41255859 | 37.78584126 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0353 | 02X36 | SUP1 | BIKE RACK | IS | 1650536940000 | OFARRELL ST | 442 - 499 OFARRELL ST | 442 - 499 OFARRELL ST | 442 OFARRELL ST | - | JONES ST | JONES ST |
| 26129 | N/A | Point | 1 | 1 | 800 - 865 | - | S269553 | 800-865 SILVER AVE | 800-865 SILVER AVE | F | F | - | F | 11906000 | 11906000 | - | - | SOUTH SIDE | - | - | - | - | CAMBRIDGE ST | CAMBRIDGE ST | 89737 | 89737 | 37.7290727 | -122.41893331 | - | - | 1727918137000 | middleware_editor | BIKE RACK | CAMBRIDGE ST to YALE ST (800 - 865) | 250402 | 84' E OF WPL 810/3' IN FROM CURB | - | - | - | - | - | 43208 | 1604314800000 | -122.41893331 | 37.7290727 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1603809120000 | SILVER AVE | 800 - 865 SILVER AVE | 800 - 865 SILVER AVE | 800 SILVER AVE | - | YALE ST | YALE ST |
| 26130 | N/A | Point | 1 | 1 | 800 - 865 | - | S269554 | 800-865 SILVER AVE | 800-865 SILVER AVE | F | F | - | F | 11906000 | 11906000 | - | - | SOUTH SIDE | - | - | - | - | CAMBRIDGE ST | CAMBRIDGE ST | 89738 | 89738 | 37.7290727 | -122.41893331 | - | - | 1727918166000 | middleware_editor | BIKE RACK | CAMBRIDGE ST to YALE ST (800 - 865) | 250402 | 122' E OF WPL 810/3' IN FROM CURB | - | - | - | - | - | 43209 | 1604316300000 | -122.41893331 | 37.7290727 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1603809180000 | SILVER AVE | 800 - 865 SILVER AVE | 800 - 865 SILVER AVE | 800 SILVER AVE | - | YALE ST | YALE ST |
| 26131 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S269243 | 1600-1699 20TH ST | 1600-1699 20TH ST | F | F | - | F | 1035000 | 1035000 | - | - | NORTH SIDE | - | - | - | - | CONNECTICUT ST | CONNECTICUT ST | 89740 | 89740 | 37.7600070037202 | -122.397679220557 | - | - | 1744931599000 | middleware_editor | BIKE RACK | CONNECTICUT ST to ARKANSAS ST (1600 - 1699) | 156256 | 14'E OF WPL 1616/4' IN FROM CURB | - | - | - | - | - | 43210 | 1603749420000 | -122.39773224 | 37.75993818 | - | - | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1602842340000 | 20TH ST | 1600 - 1699 20TH ST | 1600 - 1699 20TH ST | 1600 20TH ST | - | ARKANSAS ST | ARKANSAS ST |
| 26132 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S269244 | 1600-1699 20TH ST | 1600-1699 20TH ST | F | F | - | F | 1035000 | 1035000 | - | - | NORTH SIDE | - | - | - | - | CONNECTICUT ST | CONNECTICUT ST | 89741 | 89741 | 37.760009416369 | -122.397638359011 | - | - | 1744931539000 | middleware_editor | BIKE RACK | CONNECTICUT ST to ARKANSAS ST (1600 - 1699) | 156256 | 58'E OF WPL 1616/3.5' IN FROM CURB | - | - | - | - | - | 43211 | 1603747620000 | -122.39773224 | 37.75993818 | - | - | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1602842340000 | 20TH ST | 1600 - 1699 20TH ST | 1600 - 1699 20TH ST | 1600 20TH ST | - | ARKANSAS ST | ARKANSAS ST |
| 26133 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S269245 | 1000-1099 8TH ST | 1000-1099 08TH ST | F | F | - | F | 419000 | 419000 | - | - | EAST SIDE | - | - | - | - | 15TH ST \ CAROLINA ST | 15TH ST \ CAROLINA ST | 89742 | 89742 | 37.76743516 | -122.40063412 | - | - | 1710539427000 | MTA | BIKE RACK | 15TH ST \ CAROLINA ST to HOOPER ST (1000 - 1099) | 222053 | 11' N OF HOOPER/3.5' IN FROM CURB | - | - | - | - | - | 43212 | 1603708320000 | -122.40063412 | 37.76743516 | - | - | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1602842520000 | 08TH ST | 1000 - 1099 8TH ST | 1000 - 1099 08TH ST | 1000 8TH ST | - | HOOPER ST | HOOPER ST |
| 26134 | N/A | Point | - | - | - | - | S100448 | MCALLISTER ST: HYDE ST | - | F | F | - | F | 24333000 | 24333000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HYDE ST | MCALLISTER ST | 469 | 469 | 37.78071918 | -122.41531562 | MCALLISTER ST \ HYDE ST | HYDE ST \ MCALLISTER ST | 1710539427000 | MTA | ONE WAY (LA) | MCALLISTER ST intersection | - | 0 / 0 | - | - | - | - | - | 43213 | -404092800000 | -122.41531562 | 37.78071918 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373566440000 | HYDE ST | - | - | - | - | - | - |
| 26135 | N/A | Point | - | - | - | - | S100381 | 27TH AVE: LINCOLN WAY | - | F | F | - | F | 27436000 | 27436000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 27TH AVE | LINCOLN WAY | 475 | 475 | 37.76506861 | -122.48583103 | LINCOLN WAY \ 27TH AVE | 27TH AVE \ LINCOLN WAY | 1742233359000 | middleware_editor | STOP | LINCOLN WAY intersection | - | 00 / 00 | - | - | - | - | - | 43214 | -404496000000 | -122.48583103 | 37.76506861 | - | 1465282800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373566440000 | 27TH AVE | - | - | - | - | - | - |
| 26136 | N/A | Point | - | - | - | - | S100387 | 22ND AVE: JUDAH ST | - | F | F | - | F | 27411000 | 27411000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 22ND AVE | 22ND AVE | 480 | 480 | 37.76155883 | -122.48020654 | JUDAH ST \ 22ND AVE | JUDAH ST \ 22ND AVE | 1728404094000 | middleware_editor | STOP | 22ND AVE intersection | - | 0 / 00 | - | - | - | - | - | 43215 | -404524800000 | -122.48020654 | 37.76155883 | - | 1467158400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566440000 | JUDAH ST | - | - | - | - | - | - |
| 26137 | N/A | Point | - | - | - | - | S100388 | 23RD AVE: JUDAH ST | - | F | F | - | F | 1219000 | 27412000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | IRVING ST | 23RD AVE | 481 | 481 | 37.76151167 | -122.48127843 | - | JUDAH ST \ 23RD AVE | 1729621573000 | middleware_editor | STOP | 23RD AVE intersection | - | 0 / 00 | - | - | - | - | - | 43216 | -404524800000 | -122.48127843 | 37.76151167 | - | 1415318400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566440000 | JUDAH ST | 1300 - 1399 23RD AVE | - | - | - | JUDAH ST | - |
| 26138 | N/A | Point | - | - | - | - | S104439 | GREENWICH ST: SCOTT ST | - | F | F | - | F | 26966000 | 26966000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SCOTT ST | GREENWICH ST | 989 | 989 | 37.7982626751547 | -122.440888881678 | GREENWICH ST \ SCOTT ST | SCOTT ST \ GREENWICH ST | 1736805265000 | middleware_editor | STOP | GREENWICH ST intersection | - | 0 / REMOVE "YIELD" SIGN | - | - | - | - | - | 43217 | -1900800000 | -122.44079815 | 37.79832442 | - | 1597968000000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568900000 | SCOTT ST | - | - | - | - | - | - |
| 26139 | N/A | Point | - | - | - | - | S104748 | GRANT AVE: SUTTER ST | - | F | F | - | F | 24662000 | 24662000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GRANT AVE | GRANT AVE | 1090 | 1090 | 37.7896316 | -122.40539867 | SUTTER ST \ GRANT AVE | SUTTER ST \ GRANT AVE | 1746134582000 | middleware_editor | NO LEFT TURN (SYM) | GRANT AVE intersection | - | 0 / MADE SUTTER 1-WAY WB BET MARKET..... | - | - | - | - | - | 43218 | 28108800000 | -122.40539867 | 37.7896316 | - | - | 1727474280000 | D3 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | UNKNOWN | RETD | 1373569020000 | SUTTER ST | - | - | - | - | - | - |
| 26140 | N/A | Point | - | - | - | - | S104749 | GRANT AVE: SUTTER ST | - | F | F | - | F | 24662000 | 24662000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GRANT AVE | GRANT AVE | 1091 | 1091 | 37.7896316 | -122.40539867 | SUTTER ST \ GRANT AVE | SUTTER ST \ GRANT AVE | 1746134587000 | middleware_editor | NO LEFT TURN (SYM) | GRANT AVE intersection | - | 0 / MADE SUTTER 1-WAY WB BET MARKET..... | - | - | - | - | - | 43219 | 28108800000 | -122.40539867 | 37.7896316 | - | - | 1727474040000 | D3 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | UNKNOWN | RETD | 1373569020000 | SUTTER ST | - | - | - | - | - | - |
| 26141 | N/A | Point | - | - | - | - | S104751 | POWELL ST: POST ST | - | F | F | - | F | 24918000 | 24918000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POST ST | POST ST | 1092 | 1092 | 37.78829319 | -122.40840155 | POWELL ST \ POST ST | POWELL ST \ POST ST | 1729098494000 | middleware_editor | NO LEFT TURN (SYM) | POST ST intersection | - | 0 / REVERSED POST 1-WAY FROM WB TO EB | - | - | - | - | - | 43220 | 28080000000 | -122.40840155 | 37.78829319 | - | - | 1729073220000 | D3 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | UNKNOWN | RETD | 1373569020000 | POWELL ST | - | - | - | - | - | - |
| 26142 | N/A | Point | - | - | - | - | S104756 | MONTGOMERY ST: POST ST | - | F | F | - | F | 24623000 | 24623000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MONTGOMERY ST | MONTGOMERY ST | 1097 | 1097 | 37.78910265 | -122.40199747 | POST ST \ MONTGOMERY ST | POST ST \ MONTGOMERY ST | 1710539427000 | MTA | DO NOT ENTER | MONTGOMERY ST intersection | - | 0 / REVERSED POST 1-WAY FROM WB TO EB | - | - | - | - | - | 43221 | 28080000000 | -122.40199747 | 37.78910265 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373569020000 | POST ST | - | - | - | - | - | - |
| 26143 | N/A | Point | - | - | - | - | S101100 | OPHIR ALY: POST ST | - | F | F | - | F | 24964000 | 24964000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POST ST | OPHIR ALY | 1109 | 1109 | 37.78774114 | -122.41273585 | OPHIR ALY \ POST ST | POST ST \ OPHIR ALY | 1754948506000 | middleware_editor | STOP | OPHIR ALY intersection | - | 0 / 0 | - | - | - | - | - | 43222 | -400608000000 | -122.41273585 | 37.78774114 | - | 1306479600000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566680000 | POST ST | - | - | - | - | - | - |
| 26144 | N/A | Point | - | - | - | - | S101642 | AUSTIN ST: FRANKLIN ST | - | F | F | - | F | 26499000 | 26499000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | AUSTIN ST | 1255 | 1255 | 37.78874578 | -122.42368846 | AUSTIN ST \ FRANKLIN ST | FRANKLIN ST \ AUSTIN ST | 1710539427000 | MTA | DO NOT ENTER | AUSTIN ST intersection | - | 0 / 0 | - | - | - | - | - | 43223 | -395539200000 | -122.42368846 | 37.78874578 | - | - | - | D2 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373566860000 | FRANKLIN ST | - | - | - | - | - | - |
| 26145 | N/A | Point | - | - | - | - | S106037 | HOFFMAN AVE: ALVARADO ST | - | F | F | - | F | 26098000 | 26098000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ALVARADO ST | ALVARADO ST | 2037 | 2037 | 37.75330419 | -122.44085323 | HOFFMAN AVE \ ALVARADO ST | HOFFMAN AVE \ ALVARADO ST | 1755180179000 | middleware_editor | STOP | ALVARADO ST intersection | - | 0 / 00 | - | - | - | - | - | 43224 | 118393200000 | -122.44085323 | 37.75330419 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569440000 | HOFFMAN AVE | - | - | - | - | - | - |
| 26146 | N/A | Point | - | - | - | - | S106038 | FLOOD AVE: GENNESSEE ST | - | F | F | - | F | 22239000 | 22239000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GENNESSEE ST | GENNESSEE ST | 2038 | 2038 | 37.72987219 | -122.45113528 | FLOOD AVE \ GENNESSEE ST | FLOOD AVE \ GENNESSEE ST | 1710539427000 | MTA | STOP | GENNESSEE ST intersection | - | 0 / 0 | - | - | - | - | - | 43225 | 118368000000 | -122.45113528 | 37.72987219 | - | 1162684800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569440000 | FLOOD AVE | - | - | - | - | - | - |
| 26147 | N/A | Point | - | - | - | - | S106039 | FLOOD AVE: GENNESSEE ST | - | F | F | - | F | 22239000 | 22239000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GENNESSEE ST | GENNESSEE ST | 2039 | 2039 | 37.72987219 | -122.45113528 | FLOOD AVE \ GENNESSEE ST | FLOOD AVE \ GENNESSEE ST | 1710539427000 | MTA | STOP | GENNESSEE ST intersection | - | 0 / 0 | - | - | - | - | - | 43226 | 118368000000 | -122.45113528 | 37.72987219 | - | 1162684800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569440000 | FLOOD AVE | - | - | - | - | - | - |
| 26148 | N/A | Point | - | - | - | - | S106040 | MANGELS AVE: HAZELWOOD AVE | - | F | F | - | F | 22798000 | 22798000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MANGELS AVE | HAZELWOOD AVE | 2040 | 2040 | 37.73292362 | -122.45526051 | HAZELWOOD AVE \ MANGELS AVE | MANGELS AVE \ HAZELWOOD AVE | 1710539427000 | MTA | STOP | HAZELWOOD AVE intersection | - | 0 / 0 | - | - | - | - | - | 43227 | 118368000000 | -122.45526051 | 37.73292362 | - | 1232496000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569440000 | MANGELS AVE | - | - | - | - | - | - |
| 26149 | N/A | Point | - | - | - | - | S106041 | MANGELS AVE: HAZELWOOD AVE | - | F | F | - | F | 22798000 | 22798000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MANGELS AVE | HAZELWOOD AVE | 2041 | 2041 | 37.73292362 | -122.45526051 | HAZELWOOD AVE \ MANGELS AVE | MANGELS AVE \ HAZELWOOD AVE | 1710539427000 | MTA | STOP | HAZELWOOD AVE intersection | - | 0 / 0 | - | - | - | - | - | 43228 | 118368000000 | -122.45526051 | 37.73292362 | - | 1232496000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | MANGELS AVE | - | - | - | - | - | - |
| 26150 | N/A | Point | - | - | - | - | S105055 | LAKE ST: 22ND AVE | - | F | F | - | F | 27646000 | 27646000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 22ND AVE | 22ND AVE | 2043 | 2043 | 37.78588444 | -122.4819292 | LAKE ST \ 22ND AVE | LAKE ST \ 22ND AVE | 1726103492000 | middleware_editor | STOP | 22ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 43229 | 43545600000 | -122.4819292 | 37.78588444 | - | - | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373569080000 | LAKE ST | - | - | - | - | - | - |
| 26151 | N/A | Point | - | - | - | - | S105056 | LAKE ST: 22ND AVE | - | F | F | - | F | 27646000 | 27646000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 22ND AVE | 22ND AVE | 2044 | 2044 | 37.78588444 | -122.4819292 | LAKE ST \ 22ND AVE | LAKE ST \ 22ND AVE | 1726103493000 | middleware_editor | STOP | 22ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 43230 | 43545600000 | -122.4819292 | 37.78588444 | - | 1557878400000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373569080000 | LAKE ST | - | - | - | - | - | - |
| 26152 | N/A | Point | - | - | - | - | S105057 | LAKE ST: 4TH AVE | - | F | F | - | F | 27588000 | 27588000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 4TH AVE | 04TH AVE | 2045 | 2045 | 37.78676805 | -122.46254656 | LAKE ST \ 4TH AVE | LAKE ST \ 04TH AVE | 1750975257000 | middleware_editor | STOP | 04TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43231 | 43570800000 | -122.46254656 | 37.78676805 | - | 1680850800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569080000 | LAKE ST | - | - | - | - | - | - |
| 26153 | N/A | Point | - | - | - | - | S105058 | LAKE ST: 9TH AVE | - | F | F | - | F | 27608000 | 27608000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LAKE ST | 09TH AVE | 2046 | 2046 | 37.786611355604 | -122.467796131963 | 09TH AVE \ LAKE ST | LAKE ST \ 09TH AVE | 1750791532000 | middleware_editor | STOP | 09TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43232 | 43570800000 | -122.46789846 | 37.78653345 | - | 1301382000000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569080000 | LAKE ST | - | - | - | - | - | - |
| 26154 | N/A | Point | - | - | - | - | S105059 | LAKE ST: 9TH AVE | - | F | F | - | F | 27608000 | 27608000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LAKE ST | 09TH AVE | 2047 | 2047 | 37.7864576739324 | -122.467991262669 | 09TH AVE \ LAKE ST | LAKE ST \ 09TH AVE | 1750791534000 | middleware_editor | STOP | 09TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43233 | 43570800000 | -122.46789846 | 37.78653345 | - | 1301382000000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569140000 | LAKE ST | - | - | - | - | - | - |
| 26155 | N/A | Point | - | - | - | - | S105060 | 12TH AVE: LAKE ST | - | F | F | - | F | 27613000 | 27613000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LAKE ST | 12TH AVE | 2048 | 2048 | 37.78638724 | -122.4711146 | 12TH AVE \ LAKE ST | LAKE ST \ 12TH AVE | 1725391281000 | middleware_editor | STOP | 12TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43234 | 43545600000 | -122.4711146 | 37.78638724 | - | - | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569140000 | LAKE ST | - | - | - | - | - | - |
| 26156 | N/A | Point | - | - | - | - | S105061 | 12TH AVE: LAKE ST | - | F | F | - | F | 27613000 | 27613000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LAKE ST | 12TH AVE | 2049 | 2049 | 37.78638724 | -122.4711146 | 12TH AVE \ LAKE ST | LAKE ST \ 12TH AVE | 1726179625000 | middleware_editor | STOP | 12TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43235 | 43545600000 | -122.4711146 | 37.78638724 | - | 1726064100000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569140000 | LAKE ST | - | - | - | - | - | - |
| 26157 | N/A | Point | - | - | - | - | S105062 | 15TH AVE: LAKE ST | - | F | F | - | F | 27625000 | 27625000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LAKE ST | 15TH AVE | 2050 | 2050 | 37.78623802 | -122.47438284 | 15TH AVE \ LAKE ST | LAKE ST \ 15TH AVE | 1714754775000 | middleware_editor | STOP | 15TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43236 | 43545600000 | -122.47438284 | 37.78623802 | - | 1172620800000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569140000 | LAKE ST | - | - | - | - | - | - |
| 26158 | N/A | Point | - | - | - | - | S105063 | 15TH AVE: LAKE ST | - | F | F | - | F | 27625000 | 27625000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAKE ST | 15TH AVE | 2051 | 2051 | 37.78623802 | -122.47438284 | 15TH AVE \ LAKE ST | LAKE ST \ 15TH AVE | 1714785250000 | middleware_editor | STOP | 15TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43237 | 43545600000 | -122.47438284 | 37.78623802 | - | 1212624000000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569140000 | LAKE ST | - | - | - | - | - | - |
| 26159 | N/A | Point | - | - | - | - | S105064 | 15TH AVE: LAKE ST | - | F | F | - | F | 27625000 | 27625000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAKE ST | 15TH AVE | 2052 | 2052 | 37.78623802 | -122.47438284 | 15TH AVE \ LAKE ST | LAKE ST \ 15TH AVE | 1714754884000 | middleware_editor | STOP | 15TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43238 | 43545600000 | -122.47438284 | 37.78623802 | - | 1212624000000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569140000 | LAKE ST | - | - | - | - | - | - |
| 26160 | N/A | Point | - | - | - | - | S105065 | 19TH AVE: LAKE ST | - | F | F | - | F | 27637000 | 27637000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LAKE ST | 19TH AVE | 2053 | 2053 | 37.78603127 | -122.47871357 | 19TH AVE \ LAKE ST | LAKE ST \ 19TH AVE | 1721396121000 | middleware_editor | STOP | 19TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43239 | 43545600000 | -122.47871357 | 37.78603127 | - | 1520899200000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569140000 | LAKE ST | - | - | - | - | - | - |
| 26161 | N/A | Point | - | - | - | - | S105075 | BAKER ST: GREENWICH ST | - | F | F | - | F | 26899000 | 26899000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BAKER ST | GREENWICH ST | 2060 | 2060 | 37.79768975 | -122.44578544 | GREENWICH ST \ BAKER ST | BAKER ST \ GREENWICH ST | 1710539427000 | MTA | STOP | GREENWICH ST intersection | - | 0 / 0 | - | - | - | - | - | 43240 | 45273600000 | -122.44578544 | 37.79768975 | - | 1015804800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569140000 | BAKER ST | - | - | - | - | - | - |
| 26162 | N/A | Point | - | - | - | - | S105815 | MADRONE AVE: ULLOA ST | - | F | F | - | F | 22948000 | 22948000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ULLOA ST | MADRONE AVE | 2547 | 2547 | 37.74150309 | -122.46763054 | MADRONE AVE \ ULLOA ST | ULLOA ST \ MADRONE AVE | 1726017612000 | middleware_editor | STOP | MADRONE AVE intersection | - | - | - | - | - | - | - | 43241 | 103939200000 | -122.46763054 | 37.74150309 | - | 1189728000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569320000 | ULLOA ST | - | - | - | - | - | - |
| 26163 | N/A | Point | - | - | - | - | S105816 | MADRONE AVE: ULLOA ST | - | F | F | - | F | 22948000 | 22948000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ULLOA ST | MADRONE AVE | 2548 | 2548 | 37.74150309 | -122.46763054 | MADRONE AVE \ ULLOA ST | ULLOA ST \ MADRONE AVE | 1726017643000 | middleware_editor | STOP | MADRONE AVE intersection | - | - | - | - | - | - | - | 43242 | 103939200000 | -122.46763054 | 37.74150309 | - | 1665705600000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569320000 | ULLOA ST | - | - | - | - | - | - |
| 26164 | N/A | Point | - | - | - | - | S105817 | CONNECTICUT ST: 25TH ST | - | F | F | - | F | 23634000 | 23634000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CONNECTICUT ST | 25TH ST | 2549 | 2549 | 37.75231076 | -122.3965135 | 25TH ST \ CONNECTICUT ST | CONNECTICUT ST \ 25TH ST | 1710539427000 | MTA | STOP | 25TH ST intersection | - | 0 / 00 | - | - | - | - | - | 43243 | 104371200000 | -122.3965135 | 37.75231076 | - | 897868800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569320000 | CONNECTICUT ST | - | - | - | - | - | - |
| 26165 | N/A | Point | - | - | - | - | S104528 | 18TH AVE: NORIEGA ST | - | F | F | - | F | 840000 | 27320000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | NORIEGA ST | 18TH AVE | 2550 | 2550 | 37.7541263454027 | -122.475330769989 | - | NORIEGA ST \ 18TH AVE | 1745353575000 | middleware_editor | STOP | 18TH AVE intersection | 122054537 | 25' S OF NORIEGA | - | - | - | - | - | 43244 | 5986800000 | -122.47540591 | 37.75428693 | - | 1745344380000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568960000 | NORIEGA ST | 1800 - 1899 18TH AVE | - | - | - | ORTEGA ST | - |
| 26166 | N/A | Point | - | - | - | - | S104531 | ALABAMA ST: 21ST ST | - | F | F | - | F | 23996000 | 23996000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ALABAMA ST | 21ST ST | 2553 | 2553 | 37.7574849 | -122.41142437 | 21ST ST \ ALABAMA ST | ALABAMA ST \ 21ST ST | 1726017644000 | middleware_editor | STOP | 21ST ST intersection | - | 0 / 0 | - | - | - | - | - | 43245 | 6393600000 | -122.41142437 | 37.7574849 | - | 1582675200000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568960000 | ALABAMA ST | - | - | - | - | - | - |
| 26167 | N/A | Point | - | - | - | - | S104532 | ALABAMA ST: 21ST ST | - | F | F | - | F | 23996000 | 23996000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ALABAMA ST | 21ST ST | 2554 | 2554 | 37.7574849 | -122.41142437 | 21ST ST \ ALABAMA ST | ALABAMA ST \ 21ST ST | 1726017674000 | middleware_editor | STOP | 21ST ST intersection | - | 0 / 0 | - | - | - | - | - | 43246 | 6393600000 | -122.41142437 | 37.7574849 | - | 914889600000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568960000 | ALABAMA ST | - | - | - | - | - | - |
| 26168 | N/A | Point | - | - | - | - | S104810 | GEARY ST: POWELL ST | - | F | F | - | F | 24903000 | 24903000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POWELL ST | GEARY ST | 2562 | 2562 | 37.78735926 | -122.40822673 | GEARY ST \ POWELL ST | POWELL ST \ GEARY ST | 1752860723000 | middleware_editor | ONE WAY (RA) | GEARY ST intersection | - | 0 / MADE GEARY ONE-WAY WB | - | - | - | - | - | 43247 | 28108800000 | -122.40822673 | 37.78735926 | - | 1752859800000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569020000 | POWELL ST | - | - | - | - | - | - |
| 26169 | N/A | Point | - | - | - | - | S104811 | SUTTER ST: GRANT AVE | - | F | F | - | F | 24662000 | 24662000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GRANT AVE | GRANT AVE | 2563 | 2563 | 37.7896316 | -122.40539867 | SUTTER ST \ GRANT AVE | SUTTER ST \ GRANT AVE | 1733182206000 | middleware_editor | ONE WAY (RA) | GRANT AVE intersection | - | 0 / MADE SUTTER ONE-WAY WB MARKET-GOUGH | - | - | - | - | - | 43248 | 28080000000 | -122.40539867 | 37.7896316 | - | 1727706900000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569020000 | SUTTER ST | - | - | - | - | - | - |
| 26170 | N/A | Point | - | - | - | - | S104796 | GEARY ST: GRANT AVE | - | F | F | - | F | 24655000 | 24655000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GEARY ST | GRANT AVE | 2567 | 2567 | 37.7877655 | -122.4050414 | GRANT AVE \ GEARY ST | GEARY ST \ GRANT AVE | 1726707947000 | middleware_editor | ONE WAY (RA) | GRANT AVE intersection | - | 0 / MADE GEARY ONE-WAY WB | - | - | - | - | - | 43249 | 28080000000 | -122.4050414 | 37.7877655 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569020000 | GEARY ST | - | - | - | - | - | - |
| 26171 | N/A | Point | - | - | - | - | S100389 | 23RD AVE: JUDAH ST | - | F | F | - | F | 27412000 | 27412000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | JUDAH ST | 23RD AVE | 482 | 482 | 37.76151167 | -122.48127843 | 23RD AVE \ JUDAH ST | JUDAH ST \ 23RD AVE | 1729621598000 | middleware_editor | STOP | 23RD AVE intersection | - | 0 / 00 | - | - | - | - | - | 43250 | -404524800000 | -122.48127843 | 37.76151167 | - | 1421193600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566440000 | JUDAH ST | - | - | - | - | - | - |
| 26172 | N/A | Point | - | - | - | - | S100390 | 24TH AVE: JUDAH ST | - | F | F | - | F | 27415000 | 27415000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 24TH AVE | 24TH AVE | 483 | 483 | 37.76146442 | -122.4823521 | JUDAH ST \ 24TH AVE | JUDAH ST \ 24TH AVE | 1710539427000 | MTA | STOP | 24TH AVE intersection | - | 0 / 00 | - | - | - | - | - | 43251 | -404524800000 | -122.4823521 | 37.76146442 | - | 1465257600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566440000 | JUDAH ST | - | - | - | - | - | - |
| 26173 | N/A | Point | - | - | - | - | S100391 | 24TH AVE: JUDAH ST | - | F | F | - | F | 27415000 | 27415000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH AVE | 24TH AVE | 484 | 484 | 37.76146442 | -122.4823521 | JUDAH ST \ 24TH AVE | JUDAH ST \ 24TH AVE | 1710539427000 | MTA | STOP | 24TH AVE intersection | - | 0 / 00 | - | - | - | - | - | 43252 | -404524800000 | -122.4823521 | 37.76146442 | - | 1666569600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566440000 | JUDAH ST | - | - | - | - | - | - |
| 26174 | N/A | Point | - | - | - | - | S100394 | 26TH AVE: JUDAH ST | - | F | F | - | F | 27427000 | 27427000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 26TH AVE | 26TH AVE | 486 | 486 | 37.76137004 | -122.48449617 | JUDAH ST \ 26TH AVE | JUDAH ST \ 26TH AVE | 1710539427000 | MTA | STOP | 26TH AVE intersection | - | 00 / 0 | - | - | - | - | - | 43253 | -404524800000 | -122.48449617 | 37.76137004 | - | 1465171200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566440000 | JUDAH ST | - | - | - | - | - | - |
| 26175 | N/A | Point | - | - | - | - | S100395 | 26TH AVE: JUDAH ST | - | F | F | - | F | 27427000 | 27427000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 26TH AVE | 26TH AVE | 487 | 487 | 37.76137004 | -122.48449617 | JUDAH ST \ 26TH AVE | JUDAH ST \ 26TH AVE | 1710539427000 | MTA | STOP | 26TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43254 | -404524800000 | -122.48449617 | 37.76137004 | - | 1465171200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566440000 | JUDAH ST | - | - | - | - | - | - |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in meters