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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26176 | N/A | Point | - | - | - | - | S100396 | 27TH AVE: JUDAH ST | - | F | F | - | F | 27428000 | 27428000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 27TH AVE | 27TH AVE | 488 | 488 | 37.76132282 | -122.48556839 | JUDAH ST \ 27TH AVE | JUDAH ST \ 27TH AVE | 1738851273000 | middleware_editor | STOP | 27TH AVE intersection | - | 00 / 00 | - | - | - | - | - | 43255 | -404524800000 | -122.48556839 | 37.76132282 | - | 1465257600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373566440000 | JUDAH ST | - | - | - | - | - | - |
| 26177 | N/A | Point | - | - | - | - | S100635 | TRINITY ST: SUTTER ST | - | F | F | - | F | 24718000 | 24718000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TRINITY ST | TRINITY ST | 489 | 489 | 37.78999554 | -122.40253268 | SUTTER ST \ TRINITY ST | SUTTER ST \ TRINITY ST | 1728503823000 | middleware_editor | ONE WAY (LA) | TRINITY ST intersection | - | 0 / 0 | - | - | - | - | - | 43256 | -403056000000 | -122.40253268 | 37.78999554 | - | 1728478500000 | - | D3 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP1 | 2IN IRON POST | IS | 1373566500000 | SUTTER ST | - | - | - | - | - | - |
| 26178 | N/A | Point | - | - | - | - | S100637 | LARKIN ST: SUTTER ST | - | F | F | - | F | 25202000 | 25202000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SUTTER ST | SUTTER ST | 491 | 491 | 37.78796629 | -122.41846503 | LARKIN ST \ SUTTER ST | LARKIN ST \ SUTTER ST | 1746125000000 | middleware_editor | ONE WAY (LA) | SUTTER ST intersection | - | 0 / 0 | - | - | - | - | - | 43257 | - | -122.41846503 | 37.78796629 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | RETD | 1373566500000 | LARKIN ST | - | - | - | - | - | - |
| 26179 | N/A | Point | - | - | - | - | S100640 | HYDE ST: SUTTER ST | - | F | F | - | F | 25163000 | 25163000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SUTTER ST | SUTTER ST | 493 | 493 | 37.78817789 | -122.41682715 | HYDE ST \ SUTTER ST | HYDE ST \ SUTTER ST | 1710539427000 | MTA | ONE WAY (LA) | SUTTER ST intersection | - | 0 / 0 | - | - | - | - | - | 43258 | -403056000000 | -122.41682715 | 37.78817789 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373566500000 | HYDE ST | - | - | - | - | - | - |
| 26180 | N/A | Point | - | - | - | - | S100641 | CLAUDE LN: SUTTER ST | - | F | F | - | F | 24665000 | 24665000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SUTTER ST | CLAUDE LN | 494 | 494 | 37.78978278 | -122.40420819 | CLAUDE LN \ SUTTER ST | SUTTER ST \ CLAUDE LN | 1710539427000 | MTA | ONE WAY (RA) | CLAUDE LN intersection | - | 0 / 0 | - | - | - | - | - | 43259 | -403056000000 | -122.40420819 | 37.78978278 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373566500000 | SUTTER ST | - | - | - | - | - | - |
| 26181 | N/A | Point | - | - | - | - | S100643 | MONTGOMERY ST: SUTTER ST | - | F | F | - | F | 24678000 | 24678000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SUTTER ST | SUTTER ST | 495 | 495 | 37.7900391 | -122.40218965 | MONTGOMERY ST \ SUTTER ST | MONTGOMERY ST \ SUTTER ST | 1722389351000 | middleware_editor | ONE WAY (RA) | SUTTER ST intersection | - | 0 / 0 | - | - | - | - | - | 43260 | -403056000000 | -122.40218965 | 37.7900391 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373566500000 | MONTGOMERY ST | - | - | - | - | - | - |
| 26182 | N/A | Point | - | - | - | - | S100644 | LARKIN ST: SUTTER ST | - | F | F | - | F | 25202000 | 25202000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SUTTER ST | SUTTER ST | 496 | 496 | 37.78796629 | -122.41846503 | LARKIN ST \ SUTTER ST | LARKIN ST \ SUTTER ST | 1737584429000 | middleware_editor | ONE WAY (RA) | SUTTER ST intersection | - | 0 / 0 | - | - | - | - | - | 43261 | -403056000000 | -122.41846503 | 37.78796629 | - | 1737553500000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373566500000 | LARKIN ST | - | - | - | - | - | - |
| 26183 | N/A | Point | - | - | - | - | S100646 | TAYLOR ST: SUTTER ST | - | F | F | - | F | 24958000 | 24958000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TAYLOR ST | TAYLOR ST | 498 | 498 | 37.78880754 | -122.41188566 | SUTTER ST \ TAYLOR ST | SUTTER ST \ TAYLOR ST | 1751997921000 | middleware_editor | ONE WAY (RA) | TAYLOR ST intersection | - | 0 / 0 | - | - | - | - | - | 43262 | -403027200000 | -122.41188566 | 37.78880754 | - | 1751995800000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | LIGHT POLE | IS | 1373566500000 | SUTTER ST | - | - | - | - | - | - |
| 26184 | N/A | Point | - | - | - | - | S100648 | ELM ST: POLK ST | - | F | F | - | F | - | 24465000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | - | ELM ST | 499 | 499 | 37.78170479 | -122.41890131 | - | POLK ST \ ELM ST | 1719606003000 | middleware_editor | STOP | ELM ST intersection | - | 0 / 0 | - | - | - | - | - | 43263 | -402969600000 | -122.41890131 | 37.78170479 | - | - | 1719580740000 | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | RETD | 1373566500000 | POLK ST | - | - | - | - | - | - |
| 26185 | N/A | Point | - | - | - | - | S100650 | WILLARD ST: FREDERICK ST | - | F | F | - | F | 26431000 | 26431000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FREDERICK ST | WILLARD ST | 500 | 500 | 37.7660925561344 | -122.454513162369 | WILLARD ST \ FREDERICK ST | FREDERICK ST \ WILLARD ST | 1732651805000 | middleware_editor | STOP | WILLARD ST intersection | - | 0 / 0 | - | - | - | - | - | 43264 | -402969600000 | -122.45459292 | 37.76616547 | - | - | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566500000 | FREDERICK ST | - | - | - | - | - | - |
| 26186 | N/A | Point | - | - | - | - | S100652 | 2ND AVE: LINCOLN WAY | - | F | F | - | F | 27181000 | 27181000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LINCOLN WAY | 02ND AVE | 501 | 501 | 37.76625561 | -122.45894689 | 02ND AVE \ LINCOLN WAY | LINCOLN WAY \ 02ND AVE | 1710539427000 | MTA | STOP | 02ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 43265 | -402969600000 | -122.45894689 | 37.76625561 | - | 1505952000000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566500000 | LINCOLN WAY | - | - | - | - | - | - |
| 26187 | N/A | Point | - | - | - | - | S100655 | WILLOW ST: POLK ST | - | F | F | - | F | 25177000 | 25177000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WILLOW ST | WILLOW ST | 503 | 503 | 37.78356779 | -122.41927343 | POLK ST \ WILLOW ST | POLK ST \ WILLOW ST | 1710539427000 | MTA | DO NOT ENTER | WILLOW ST intersection | - | 0 / MADE EASTBOUND ONE WAY | - | - | - | - | - | 43266 | -402969600000 | -122.41927343 | 37.78356779 | - | - | - | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373566500000 | POLK ST | - | - | - | - | - | - |
| 26188 | N/A | Point | - | - | - | - | S100656 | TURK ST: VAN NESS AVE | - | F | F | - | F | 25184000 | 25184000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | TURK ST | 504 | 504 | 37.78196077 | -122.42063825 | TURK ST \ VAN NESS AVE | VAN NESS AVE \ TURK ST | 1710539427000 | MTA | DO NOT ENTER | TURK ST intersection | - | 0 / MADE TURK 1-WAY | - | - | - | - | - | 43267 | -402969600000 | -122.42063825 | 37.78196077 | - | - | - | D5 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373566500000 | VAN NESS AVE | - | - | - | - | - | - |
| 26189 | N/A | Point | - | - | - | - | S104366 | 18TH AVE: LAWTON ST | - | F | F | - | F | 27332000 | 27332000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 18TH AVE | 18TH AVE | 1263 | 1263 | 37.75801378 | -122.47566587 | LAWTON ST \ 18TH AVE | LAWTON ST \ 18TH AVE | 1729795635000 | middleware_editor | STOP | 18TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43268 | -13910400000 | -122.47566587 | 37.75801378 | - | 1202774400000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568900000 | LAWTON ST | - | - | - | - | - | - |
| 26190 | N/A | Point | - | - | - | - | S104368 | ULLOA ST: 24TH AVE | - | F | F | - | F | 23233000 | 23233000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 24TH AVE | 24TH AVE | 1264 | 1264 | 37.7410376347596 | -122.480847090478 | ULLOA ST \ 24TH AVE | ULLOA ST \ 24TH AVE | 1738357390000 | middleware_editor | STOP | 24TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43269 | -13910400000 | -122.48091787 | 37.74094773 | - | 1679443200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373568900000 | ULLOA ST | - | - | - | - | - | - |
| 26191 | N/A | Point | - | - | - | - | S104370 | JENNINGS ST: CARROLL AVE | - | F | F | - | F | 20452000 | 20452000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CARROLL AVE | JENNINGS ST | 1266 | 1266 | 37.72391411 | -122.39149191 | JENNINGS ST \ CARROLL AVE | CARROLL AVE \ JENNINGS ST | 1734994918000 | middleware_editor | STOP | JENNINGS ST intersection | - | 0 / 00 | - | - | - | - | - | 43270 | -13824000000 | -122.39149191 | 37.72391411 | - | 1734959700000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568900000 | CARROLL AVE | - | - | - | - | - | - |
| 26192 | N/A | Point | - | - | - | - | S105989 | 19TH ST: SANCHEZ ST | - | F | F | - | F | 25718000 | 25718000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SANCHEZ ST | 19TH ST | 1268 | 1268 | 37.75955746 | -122.43042034 | 19TH ST \ SANCHEZ ST | SANCHEZ ST \ 19TH ST | 1745864192000 | middleware_editor | STOP | 19TH ST intersection | - | 0 / 0 | - | - | - | - | - | 43271 | 113641200000 | -122.43042034 | 37.75955746 | - | 696672000000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569380000 | SANCHEZ ST | - | - | - | - | - | - |
| 26193 | N/A | Point | - | - | - | - | S105990 | 19TH ST: SANCHEZ ST | - | F | F | - | F | 25718000 | 25718000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SANCHEZ ST | 19TH ST | 1269 | 1269 | 37.75955746 | -122.43042034 | 19TH ST \ SANCHEZ ST | SANCHEZ ST \ 19TH ST | 1745864198000 | middleware_editor | STOP | 19TH ST intersection | - | - | - | - | - | - | - | 43272 | 113641200000 | -122.43042034 | 37.75955746 | - | 599817600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569380000 | SANCHEZ ST | - | - | - | - | - | - |
| 26194 | N/A | Point | - | - | - | - | S105992 | 19TH ST: NOE ST | - | F | F | - | F | 25787000 | 25787000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 1270 | 1270 | 37.75942329 | -122.43263777 | NOE ST \ 19TH ST | NOE ST \ 19TH ST | 1712885088000 | middleware_editor | STOP | 19TH ST intersection | - | 0 / 0 | - | - | - | - | - | 43273 | 113616000000 | -122.43263777 | 37.75942329 | - | 1579564800000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569380000 | NOE ST | - | - | - | - | - | - |
| 26195 | N/A | Point | - | - | - | - | S104821 | POST ST: LEAVENWORTH ST | - | F | F | - | F | 25157000 | 25157000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POST ST | LEAVENWORTH ST | 1273 | 1273 | 37.78745384 | -122.41499542 | LEAVENWORTH ST \ POST ST | POST ST \ LEAVENWORTH ST | 1750185232000 | middleware_editor | ONE WAY (RA) | LEAVENWORTH ST intersection | - | - | - | - | - | - | - | 43274 | 28108800000 | -122.41499542 | 37.78745384 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569020000 | POST ST | - | - | - | - | - | - |
| 26196 | N/A | Point | - | - | - | - | S104822 | SUTTER ST: JONES ST | - | F | F | - | F | 24959000 | 24959000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SUTTER ST | SUTTER ST | 1274 | 1274 | 37.7885982 | -122.41354144 | JONES ST \ SUTTER ST | JONES ST \ SUTTER ST | 1710539427000 | MTA | ONE WAY (RA) | SUTTER ST intersection | - | 0 / MADE SUTTER ONE-WAY WB MARKET-GOUGH | - | - | - | - | - | 43275 | 28080000000 | -122.41354144 | 37.7885982 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569020000 | JONES ST | - | - | - | - | - | - |
| 26197 | N/A | Point | - | - | - | - | S104824 | MISSION ST: 6TH ST | - | F | F | - | F | 24293000 | 24293000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 6TH ST | 06TH ST | 1276 | 1276 | 37.78097118 | -122.40870867 | MISSION ST \ 6TH ST | MISSION ST \ 06TH ST | 1752786272000 | middleware_editor | NO LEFT TURN (SYM) | 06TH ST intersection | - | 0 / 0 | - | - | - | - | - | 43276 | 28627200000 | -122.40870867 | 37.78097118 | - | - | 1752786240000 | D6 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | UNKNOWN | RETD | 1373569020000 | MISSION ST | - | - | - | - | - | - |
| 26198 | N/A | Point | - | - | - | - | S103957 | WASHINGTON ST: STOCKTON ST | - | F | F | - | F | 25026000 | 25026000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | STOCKTON ST | WASHINGTON ST | 1278 | 1278 | 37.79494069 | -122.4080791 | WASHINGTON ST \ STOCKTON ST | STOCKTON ST \ WASHINGTON ST | 1721159013000 | middleware_editor | ONE WAY (RA) | WASHINGTON ST intersection | - | S LINE / 0 | - | - | - | - | - | 43277 | -70156800000 | -122.4080791 | 37.79494069 | - | 1719567900000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373568780000 | STOCKTON ST | - | - | - | - | - | - |
| 26199 | N/A | Point | - | - | - | - | S103958 | ROSS ALY: WASHINGTON ST | - | F | F | - | F | 25018000 | 25018000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 1279 | 1279 | 37.79504367 | -122.40726674 | ROSS ALY \ WASHINGTON ST | ROSS ALY \ WASHINGTON ST | 1710539427000 | MTA | ONE WAY (LA) | WASHINGTON ST intersection | - | 0 / 0 | - | - | - | - | - | 43278 | -70070400000 | -122.40726674 | 37.79504367 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373568780000 | ROSS ALY | - | - | - | - | - | - |
| 26200 | N/A | Point | - | - | - | - | S104941 | FOLSOM ST: 11TH ST | - | F | F | - | F | 24238000 | 24238000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FOLSOM ST | FOLSOM ST | 1281 | 1281 | 37.77186371 | -122.41402671 | 11TH ST \ FOLSOM ST | 11TH ST \ FOLSOM ST | 1710539427000 | MTA | ONE WAY (RA) | FOLSOM ST intersection | - | 0 / MADE FOLSOM 1-WAY EB 11THST-EMB..... | - | - | - | - | - | 43279 | 38102400000 | -122.41402671 | 37.77186371 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569080000 | 11TH ST | - | - | - | - | - | - |
| 26201 | N/A | Point | - | - | - | - | S104942 | FOLSOM ST: MAIN ST | - | F | F | - | F | 24503000 | 24503000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MAIN ST | FOLSOM ST | 1282 | 1282 | 37.78936927 | -122.39185829 | FOLSOM ST \ MAIN ST | MAIN ST \ FOLSOM ST | 1710539427000 | MTA | ONE WAY (RA) | FOLSOM ST intersection | - | 0 / MADE FOLSOM 1-WAY EB 11THST-EMB..... | - | - | - | - | - | 43280 | 38102400000 | -122.39185829 | 37.78936927 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569080000 | MAIN ST | - | - | - | - | - | - |
| 26202 | N/A | Point | - | - | - | - | S105076 | BAKER ST: GREENWICH ST | - | F | F | - | F | 26899000 | 26899000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BAKER ST | GREENWICH ST | 2061 | 2061 | 37.79768975 | -122.44578544 | GREENWICH ST \ BAKER ST | BAKER ST \ GREENWICH ST | 1710539427000 | MTA | STOP | GREENWICH ST intersection | - | 0 / 0 | - | - | - | - | - | 43281 | 45273600000 | -122.44578544 | 37.79768975 | - | - | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569140000 | BAKER ST | - | - | - | - | - | - |
| 26203 | N/A | Point | - | - | - | - | S105181 | VICTORIA ST: GARFIELD ST | - | F | F | - | F | 22696000 | 22696000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GARFIELD ST | GARFIELD ST | 2062 | 2062 | 37.71968541 | -122.4653571 | VICTORIA ST \ GARFIELD ST | VICTORIA ST \ GARFIELD ST | 1719323116000 | middleware_editor | STOP | GARFIELD ST intersection | - | 0 / 0 | - | - | - | - | - | 43282 | 58060800000 | -122.4653571 | 37.71968541 | - | 1719240300000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569140000 | VICTORIA ST | - | - | - | - | - | - |
| 26204 | N/A | Point | - | - | - | - | S105185 | EDNA ST: MONTEREY BLVD | - | F | F | - | F | 22162000 | 22162000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MONTEREY BLVD | EDNA ST | 2064 | 2064 | 37.73154905 | -122.4465784 | EDNA ST \ MONTEREY BLVD | MONTEREY BLVD \ EDNA ST | 1756391215000 | middleware_editor | ONE WAY (LA) | EDNA ST intersection | - | 0 / MADE EDNA ONE-WAY NB | - | - | - | - | - | 43283 | 58435200000 | -122.4465784 | 37.73154905 | - | - | - | D7 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | 2IN IRON POST | IS | 1373569140000 | MONTEREY BLVD | - | - | - | - | - | - |
| 26205 | N/A | Point | - | - | - | - | S104629 | CHATTANOOGA ST: 23RD ST | - | F | F | - | F | 25620000 | 25620000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 23RD ST | CHATTANOOGA ST | 2065 | 2065 | 37.75335955 | -122.42647785 | CHATTANOOGA ST \ 23RD ST | 23RD ST \ CHATTANOOGA ST | 1710539427000 | MTA | STOP | CHATTANOOGA ST intersection | - | 0 / 0 | - | - | - | - | - | 43284 | 17971200000 | -122.42647785 | 37.75335955 | - | 704419200000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568960000 | 23RD ST | - | - | - | - | - | - |
| 26206 | N/A | Point | - | - | - | - | S104630 | ANZA ST: 20TH AVE | - | F | F | - | F | 27499000 | 27499000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 20TH AVE | ANZA ST | 2066 | 2066 | 37.77840833 | -122.47924079 | ANZA ST \ 20TH AVE | 20TH AVE \ ANZA ST | 1710539427000 | MTA | STOP | ANZA ST intersection | - | 0 / 0 | - | - | - | - | - | 43285 | 17971200000 | -122.47924079 | 37.77840833 | - | 1681084800000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568960000 | 20TH AVE | - | - | - | - | - | - |
| 26207 | N/A | Point | - | - | - | - | S104631 | ANZA ST: 20TH AVE | - | F | F | - | F | 27499000 | 27499000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 20TH AVE | ANZA ST | 2067 | 2067 | 37.77840833 | -122.47924079 | ANZA ST \ 20TH AVE | 20TH AVE \ ANZA ST | 1739888468000 | middleware_editor | STOP | ANZA ST intersection | - | 0 / 0 | - | - | - | - | - | 43286 | 17971200000 | -122.47924079 | 37.77840833 | - | 1739550540000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568960000 | 20TH AVE | - | - | - | - | - | - |
| 26208 | N/A | Point | - | - | - | - | S104632 | TAYLOR ST: BAY ST | - | F | F | - | F | 25524000 | 25524000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TAYLOR ST | BAY ST | 2068 | 2068 | 37.80541717 | -122.41524149 | BAY ST \ TAYLOR ST | TAYLOR ST \ BAY ST | 1714179568000 | middleware_editor | ONE WAY (RA) | BAY ST intersection | - | 0 / ADDITIONAL SIGN | - | - | - | - | - | 43287 | 17971200000 | -122.41524149 | 37.80541717 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | SIGNAL POLE | IS | 1373568960000 | TAYLOR ST | - | - | - | - | - | - |
| 26209 | N/A | Point | - | - | - | - | S104633 | TARAVAL ST: 32ND AVE | - | F | F | - | F | 23389000 | 23389000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 32ND AVE | 2069 | 2069 | 37.74243744 | -122.48962024 | 32ND AVE \ TARAVAL ST | TARAVAL ST \ 32ND AVE | 1724171537000 | middleware_editor | STOP | 32ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 43288 | 18057600000 | -122.48962024 | 37.74243744 | - | 1512691200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373568960000 | TARAVAL ST | - | - | - | - | - | - |
| 26210 | N/A | Point | - | - | - | - | S104634 | TARAVAL ST: 32ND AVE | - | F | F | - | F | 23389000 | 23389000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 32ND AVE | 2070 | 2070 | 37.74243744 | -122.48962024 | 32ND AVE \ TARAVAL ST | TARAVAL ST \ 32ND AVE | 1723821426000 | middleware_editor | STOP | 32ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 43289 | 18057600000 | -122.48962024 | 37.74243744 | - | 1723722960000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373568960000 | TARAVAL ST | - | - | - | - | - | - |
| 26211 | N/A | Point | - | - | - | - | S104636 | BAY ST: TAYLOR ST | - | F | F | - | F | 25524000 | 25524000 | - | - | NORTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TAYLOR ST | BAY ST | 2071 | 2071 | 37.80541717 | -122.41524149 | BAY ST \ TAYLOR ST | TAYLOR ST \ BAY ST | 1714179601000 | middleware_editor | NO LEFT TURN (SYM) | BAY ST intersection | - | 0 / 0 | - | - | - | - | - | 43290 | 18230400000 | -122.41524149 | 37.80541717 | - | - | - | D3 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | UNKNOWN | IS | 1373568960000 | TAYLOR ST | - | - | - | - | - | - |
| 26212 | N/A | Point | - | - | - | - | S104638 | VARENNES ST: UNION ST | - | F | F | - | F | 25342000 | 25342000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VARENNES ST | VARENNES ST | 2072 | 2072 | 37.80073684 | -122.40680105 | UNION ST \ VARENNES ST | UNION ST \ VARENNES ST | 1755637810000 | middleware_editor | ONE WAY (LA) | VARENNES ST intersection | - | 0 / 0 | - | - | - | - | - | 43291 | 19983600000 | -122.40680105 | 37.80073684 | - | 1755629100000 | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373568960000 | UNION ST | - | - | - | - | - | - |
| 26213 | N/A | Point | - | - | - | - | S104639 | VARENNES ST: UNION ST | - | F | F | - | F | 25342000 | 25342000 | - | - | NORTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VARENNES ST | VARENNES ST | 2073 | 2073 | 37.8008038640068 | -122.40683960721 | UNION ST \ VARENNES ST | UNION ST \ VARENNES ST | 1755629891000 | middleware_editor | ONE WAY (RA) | VARENNES ST intersection | - | 0 / 0 | - | - | - | - | - | 43292 | 19983600000 | -122.40680105 | 37.80073684 | - | 1755627300000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373568960000 | UNION ST | - | - | - | - | - | - |
| 26214 | N/A | Point | - | - | - | - | S105551 | WOOLSEY ST: HAMILTON ST | - | F | F | - | F | 20863000 | 20863000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HAMILTON ST | WOOLSEY ST | 2074 | 2074 | 37.72368801 | -122.4085287 | WOOLSEY ST \ HAMILTON ST | HAMILTON ST \ WOOLSEY ST | 1754683065000 | middleware_editor | STOP | WOOLSEY ST intersection | - | 0 / 0 | - | - | - | - | - | 43293 | 82364400000 | -122.4085287 | 37.72368801 | - | 1236582000000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | HAMILTON ST | - | - | - | - | - | - |
| 26215 | N/A | Point | - | - | - | - | S105561 | RUTLAND ST: WILDE AVE | - | F | F | - | F | 20591000 | 20591000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RUTLAND ST | RUTLAND ST | 2081 | 2081 | 37.71728125 | -122.40531016 | WILDE AVE \ RUTLAND ST | WILDE AVE \ RUTLAND ST | 1710539427000 | MTA | STOP | RUTLAND ST intersection | - | 0 / 0 | - | - | - | - | - | 43294 | 82684800000 | -122.40531016 | 37.71728125 | - | 843091200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569260000 | WILDE AVE | - | - | - | - | - | - |
| 26216 | N/A | Point | - | - | - | - | S105562 | 45TH AVE: IRVING ST | - | F | F | - | F | 27948000 | 27948000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 45TH AVE | 45TH AVE | 2082 | 2082 | 37.76243171 | -122.50507012 | IRVING ST \ 45TH AVE | IRVING ST \ 45TH AVE | 1755789224000 | middleware_editor | STOP | 45TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43295 | 82710000000 | -122.50498766 | 37.7623324 | - | 1493967600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1373569260000 | IRVING ST | - | - | - | - | - | - |
| 26217 | N/A | Point | - | - | - | - | S105563 | 45TH AVE: IRVING ST | - | F | F | - | F | 27948000 | 27948000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 45TH AVE | 45TH AVE | 2083 | 2083 | 37.762237159 | -122.504915893 | IRVING ST \ 45TH AVE | IRVING ST \ 45TH AVE | 1755789227000 | middleware_editor | STOP | 45TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43296 | 82710000000 | -122.50498766 | 37.7623324 | - | 1493967600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | IRVING ST | - | - | - | - | - | - |
| 26218 | N/A | Point | - | - | - | - | S105564 | 18TH AVE: ULLOA ST | - | F | F | - | F | 23160000 | 23160000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 18TH AVE | ULLOA ST | 2084 | 2084 | 37.74123427 | -122.47449422 | ULLOA ST \ 18TH AVE | 18TH AVE \ ULLOA ST | 1732666663000 | middleware_editor | STOP | ULLOA ST intersection | - | 0 / 00 | - | - | - | - | - | 43297 | 82684800000 | -122.47449422 | 37.74123427 | - | 1732618200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569260000 | 18TH AVE | - | - | - | - | - | - |
| 26219 | N/A | Point | - | - | - | - | S105565 | 18TH AVE: ULLOA ST | - | F | F | - | F | 23160000 | 23160000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 18TH AVE | ULLOA ST | 2085 | 2085 | 37.74123427 | -122.47449422 | ULLOA ST \ 18TH AVE | 18TH AVE \ ULLOA ST | 1732666667000 | middleware_editor | STOP | ULLOA ST intersection | - | 0 / 00 | - | - | - | - | - | 43298 | 82684800000 | -122.47449422 | 37.74123427 | - | 1732623300000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | 18TH AVE | - | - | - | - | - | - |
| 26220 | N/A | Point | - | - | - | - | S106142 | TOMPKINS AVE: FOLSOM ST | - | F | F | - | F | 21055000 | 21055000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | FOLSOM ST | 2087 | 2087 | 37.73706991 | -122.4134776 | FOLSOM ST \ TOMPKINS AVE | TOMPKINS AVE \ FOLSOM ST | 1752158708000 | middleware_editor | STOP | FOLSOM ST intersection | - | - | - | - | - | - | - | 43299 | 124617600000 | -122.4134776 | 37.73706991 | - | 737190000000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373569440000 | TOMPKINS AVE | - | - | - | - | - | - |
| 26221 | N/A | Point | - | - | - | - | S104294 | DOUGLASS ST: 18TH ST | - | F | F | - | F | 26144000 | 26144000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DOUGLASS ST | DOUGLASS ST | 2089 | 2089 | 37.76062672 | -122.43933681 | 18TH ST \ DOUGLASS ST | 18TH ST \ DOUGLASS ST | 1719243946000 | middleware_editor | STOP | DOUGLASS ST intersection | - | - | - | - | - | - | - | 43300 | -24796800000 | -122.43933681 | 37.76062672 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568900000 | 18TH ST | - | - | - | - | - | - |
| 26222 | N/A | Point | - | - | - | - | S104797 | GEARY ST: POLK ST | - | F | F | - | F | 25182000 | 25182000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POLK ST | GEARY ST | 2568 | 2568 | 37.7858929 | -122.41973873 | GEARY ST \ POLK ST | POLK ST \ GEARY ST | 1749762487000 | middleware_editor | ONE WAY (RA) | GEARY ST intersection | - | 8FT EAST OF POLK | - | - | - | - | - | 43301 | 28108800000 | -122.41973873 | 37.7858929 | - | 1749755700000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | 2IN FLANGE POST | IS | 1373569020000 | POLK ST | - | - | - | - | - | - |
| 26223 | N/A | Point | - | - | - | - | S104799 | POST ST: LARKIN ST | - | F | F | - | F | 25167000 | 25167000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POST ST | POST ST | 2570 | 2570 | 37.78703795 | -122.41827098 | LARKIN ST \ POST ST | LARKIN ST \ POST ST | 1710539427000 | MTA | ONE WAY (RA) | POST ST intersection | - | 0 / MADE POST ONE-WAY EB BET GOUGH ..... | - | - | - | - | - | 43302 | 28080000000 | -122.41827098 | 37.78703795 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373569020000 | LARKIN ST | - | - | - | - | - | - |
| 26224 | N/A | Point | - | - | - | - | S104800 | SUTTER ST: HYDE ST | - | F | F | - | F | 25163000 | 25163000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SUTTER ST | SUTTER ST | 2571 | 2571 | 37.78817789 | -122.41682715 | HYDE ST \ SUTTER ST | HYDE ST \ SUTTER ST | 1750805494000 | middleware_editor | ONE WAY (RA) | SUTTER ST intersection | - | - | - | - | - | - | - | 43303 | 28108800000 | -122.41682715 | 37.78817789 | - | 1750791600000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | LIGHT POLE | IS | 1373569020000 | HYDE ST | - | - | - | - | - | - |
| 26225 | N/A | Point | 1 | - | - | - | S104801 | 108-199 SUTTER ST | - | F | F | - | F | 12318000 | 12318000 | - | - | SOUTH SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | - | - | 2572 | 2572 | 37.78991244 | -122.40318712 | - | - | 1710539427000 | MTA | ONE WAY (RA) | - | - | C LINE / MADE SUTTER ONE-WAY WB MAR..... | - | - | - | - | - | 43304 | 28080000000 | -122.40318712 | 37.78991244 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373569020000 | SUTTER ST | 108-199 SUTTER ST | SUTTER ST | - | - | - | - |
| 26226 | N/A | Point | - | - | - | - | S104802 | LEAVENWORTH ST: CALIFORNIA ST | - | F | F | - | F | 25231000 | 25231000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 2573 | 2573 | 37.79120631 | -122.4157502 | LEAVENWORTH ST \ CALIFORNIA ST | LEAVENWORTH ST \ CALIFORNIA ST | 1710539427000 | MTA | ONE WAY (RA) | CALIFORNIA ST intersection | - | 0 / MADE LEAVENWORTH ONE-WAY NB BUS..... | - | - | - | - | - | 43305 | 28080000000 | -122.4157502 | 37.79120631 | - | 1588204800000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373569020000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 26227 | N/A | Point | - | - | - | - | S104804 | SUTTER ST: VAN NESS AVE | - | F | F | - | F | 25219000 | 25219000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SUTTER ST | VAN NESS AVE | 2574 | 2574 | 37.78754814 | -122.4217581 | VAN NESS AVE \ SUTTER ST | SUTTER ST \ VAN NESS AVE | 1710539427000 | MTA | ONE WAY (RA) | VAN NESS AVE intersection | - | 0 / MADE SUTTER ONE-WAY WB MARKET-GOUGH | - | - | - | - | - | 43306 | 28080000000 | -122.4217581 | 37.78754814 | - | - | - | D2 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373569020000 | SUTTER ST | - | - | - | - | - | - |
| 26228 | N/A | Point | - | - | - | - | S104981 | HOWARD ST: RUSS ST | - | F | F | - | F | 24287000 | 24287000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HOWARD ST | HOWARD ST | 2632 | 2632 | 37.77886069 | -122.40827159 | RUSS ST \ HOWARD ST | RUSS ST \ HOWARD ST | 1710539427000 | MTA | ONE WAY (RA) | HOWARD ST intersection | - | C LINE / MADE HOWARD 1-WAY WB BET B..... | - | - | - | - | - | 43307 | 38966400000 | -122.40827159 | 37.77886069 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569080000 | RUSS ST | - | - | - | - | - | - |
| 26229 | N/A | Point | - | - | - | - | S104984 | HOWARD ST: 10TH ST | - | F | F | - | F | 24248000 | 24248000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HOWARD ST | 10TH ST | 2634 | 2634 | 37.77404333 | -122.41436769 | 10TH ST \ HOWARD ST | HOWARD ST \ 10TH ST | 1711767984000 | middleware_editor | ONE WAY (RA) | 10TH ST intersection | - | - | - | - | - | - | - | 43308 | 38966400000 | -122.41436769 | 37.77404333 | - | 1412294400000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | SIGNAL POLE | IS | 1373569080000 | HOWARD ST | - | - | - | - | - | - |
| 26230 | N/A | Point | - | - | - | - | S104985 | HOWARD ST: 11TH ST | - | F | F | - | F | 24353000 | 24353000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HOWARD ST | HOWARD ST | 2635 | 2635 | 37.77310059 | -122.41556139 | 11TH ST \ HOWARD ST | 11TH ST \ HOWARD ST | 1710539427000 | MTA | ONE WAY (RA) | HOWARD ST intersection | - | 0 / MADE HOWARD 1-WAY WB BET BEALE ..... | - | - | - | - | - | 43309 | 38966400000 | -122.41556139 | 37.77310059 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373569080000 | 11TH ST | - | - | - | - | - | - |
| 26231 | N/A | Point | - | - | - | - | S104986 | HOWARD ST: BEALE ST | - | F | F | - | F | 24506000 | 24506000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BEALE ST | BEALE ST | 2636 | 2636 | 37.78992623 | -122.39427623 | HOWARD ST \ BEALE ST | HOWARD ST \ BEALE ST | 1710539427000 | MTA | ONE WAY (RA) | BEALE ST intersection | - | 0 / MADE HOWARD 1-WAY WB BET BEALE ..... | - | - | - | - | - | 43310 | 38966400000 | -122.39427623 | 37.78992623 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373569080000 | HOWARD ST | - | - | - | - | - | - |
| 26232 | N/A | Point | - | - | - | - | S104987 | HOWARD ST: 1ST ST | - | F | F | - | F | 24532000 | 24532000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 1ST ST | 01ST ST | 2637 | 2637 | 37.78853593 | -122.39603477 | HOWARD ST \ 1ST ST | HOWARD ST \ 01ST ST | 1710539427000 | MTA | ONE WAY (RA) | 01ST ST intersection | - | 0 / MADE HOWARD 1-WAY WB BET BEALE ..... | - | - | - | - | - | 43311 | 38966400000 | -122.39603477 | 37.78853593 | - | 1539043200000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569080000 | HOWARD ST | - | - | - | - | - | - |
| 26233 | N/A | Point | - | - | - | - | S107290 | COTTER ST: CAYUGA AVE | - | F | F | - | F | 21798000 | 21798000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | COTTER ST | COTTER ST | 2711 | 2711 | 37.72867091 | -122.43574963 | CAYUGA AVE \ COTTER ST | CAYUGA AVE \ COTTER ST | 1720746703000 | middleware_editor | ONE WAY (RA) | COTTER ST intersection | - | 0 / MAKE ONE WAY EASTBOUND | - | - | - | - | - | 43312 | 213235200000 | -122.43574963 | 37.72867091 | - | - | - | D11 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | 3IN IRON POST | IS | 1373569800000 | CAYUGA AVE | - | - | - | - | - | - |
| 26234 | N/A | Point | - | - | - | - | S107291 | 12TH AVE: LAWTON ST | - | F | F | - | F | 27130000 | 27130000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LAWTON ST | 12TH AVE | 2712 | 2712 | 37.75830399 | -122.46913102 | 12TH AVE \ LAWTON ST | LAWTON ST \ 12TH AVE | 1733526824000 | middleware_editor | STOP | 12TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43313 | 214531200000 | -122.46913102 | 37.75830399 | - | 1733494800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569800000 | LAWTON ST | - | - | - | - | - | - |
| 26235 | N/A | Point | - | - | - | - | S107292 | 12TH AVE: LAWTON ST | - | F | F | - | F | 27130000 | 27130000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAWTON ST | 12TH AVE | 2713 | 2713 | 37.75830399 | -122.46913102 | 12TH AVE \ LAWTON ST | LAWTON ST \ 12TH AVE | 1733526842000 | middleware_editor | STOP | 12TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43314 | 214531200000 | -122.46913102 | 37.75830399 | - | 1733496000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569800000 | LAWTON ST | - | - | - | - | - | - |
| 26236 | N/A | Point | - | - | - | - | S107771 | 33RD AVE: VICENTE ST | - | F | F | - | F | 23349000 | 23349000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 33RD AVE | 33RD AVE | 2714 | 2714 | 37.73866262 | -122.49043223 | VICENTE ST \ 33RD AVE | VICENTE ST \ 33RD AVE | 1710539427000 | MTA | STOP | 33RD AVE intersection | - | 0 / 0 | - | - | - | - | - | 43315 | 253756800000 | -122.49043223 | 37.73866262 | - | 1475107200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | VICENTE ST | - | - | - | - | - | - |
| 26237 | N/A | Point | - | - | - | - | S107772 | 33RD AVE: VICENTE ST | - | F | F | - | F | 23349000 | 23349000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 33RD AVE | 33RD AVE | 2715 | 2715 | 37.73866262 | -122.49043223 | VICENTE ST \ 33RD AVE | VICENTE ST \ 33RD AVE | 1710539427000 | MTA | STOP | 33RD AVE intersection | - | 0 / 0 | - | - | - | - | - | 43316 | 253756800000 | -122.49043223 | 37.73866262 | - | 1475107200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | VICENTE ST | - | - | - | - | - | - |
| 26238 | N/A | Point | - | - | - | - | S107774 | HEARST AVE: GENNESSEE ST | - | F | F | - | F | 22244000 | 22244000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HEARST AVE | GENNESSEE ST | 2716 | 2716 | 37.73068111 | -122.45114081 | GENNESSEE ST \ HEARST AVE | HEARST AVE \ GENNESSEE ST | 1710539427000 | MTA | STOP | GENNESSEE ST intersection | - | - | - | - | - | - | - | 43317 | 253843200000 | -122.45114081 | 37.73068111 | - | 1504742400000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | HEARST AVE | - | - | - | - | - | - |
| 26239 | N/A | Point | - | - | - | - | S107778 | TARAVAL ST: 46TH AVE | - | F | F | - | F | 23502000 | 23502000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 46TH AVE | 2718 | 2718 | 37.74176468 | -122.50462045 | 46TH AVE \ TARAVAL ST | TARAVAL ST \ 46TH AVE | 1727271204000 | middleware_editor | STOP | 46TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43318 | 254534400000 | -122.50462045 | 37.74176468 | - | 1512691200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1373569980000 | TARAVAL ST | - | - | - | - | - | - |
| 26240 | N/A | Point | - | - | - | - | S107779 | TARAVAL ST: 46TH AVE | - | F | F | - | F | 23502000 | 23502000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 46TH AVE | 2719 | 2719 | 37.74176468 | -122.50462045 | 46TH AVE \ TARAVAL ST | TARAVAL ST \ 46TH AVE | 1756493561000 | middleware_editor | STOP | 46TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43319 | 254563200000 | -122.50462045 | 37.74176468 | - | 1674028800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | TARAVAL ST | - | - | - | - | - | - |
| 26241 | N/A | Point | 1 | 1 | 629 - 699 | - | S100660 | 629-699 LARKIN ST | 629-699 LARKIN ST | F | F | - | F | 8127000 | 8127000 | - | - | UNKNOWN | - | - | - | - | WILLOW ST | WILLOW ST | 507 | 507 | 37.78400663 | -122.41766266 | - | - | 1710539427000 | MTA | ONE WAY (LA) | WILLOW ST to ELLIS ST (629 - 699) | - | E LINE / 0 | - | - | - | - | - | 43320 | -402969600000 | -122.41766266 | 37.78400663 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373566500000 | LARKIN ST | 629 - 699 LARKIN ST | 629 - 699 LARKIN ST | 629 LARKIN ST | - | ELLIS ST | ELLIS ST |
| 26242 | N/A | Point | - | - | - | - | S100661 | FELL ACCESS RD: FELL ST \ STAN | - | F | F | - | F | 26445000 | 26445000 | - | - | CENTER ISLAND, E LINE, NORTHBOUND | - | - | - | - | FELL ACCESS RD \ STANYAN ST | FELL ACCESS RD \ FELL ST | 508 | 508 | 37.7719304 | -122.45408322 | FELL ST \ FELL ACCESS RD \ STANYAN ST | STANYAN ST \ FELL ACCESS RD \ FELL ST | 1726167450000 | middleware_editor | ONE WAY (RA) | FELL ACCESS RD \ FELL ST intersection | - | BELOW STOP | - | - | - | - | - | 43321 | -402969600000 | -122.45408322 | 37.7719304 | - | - | - | D1 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | 2IN IRON POST | IS | 1373566500000 | STANYAN ST | - | - | - | - | - | - |
| 26243 | N/A | Point | - | - | - | - | S100662 | OLIVE ST: LARKIN ST | - | F | F | - | F | 25151000 | 25151000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | OLIVE ST | OLIVE ST | 509 | 509 | 37.7847098 | -122.41780582 | LARKIN ST \ OLIVE ST | LARKIN ST \ OLIVE ST | 1749676613000 | middleware_editor | ONE WAY (RA) | OLIVE ST intersection | - | 0 / 0 | - | - | - | - | - | 43322 | -402944400000 | -122.41780582 | 37.7847098 | - | 1735670700000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | LIGHT POLE | IS | 1373566500000 | LARKIN ST | - | - | - | - | - | - |
| 26244 | N/A | Point | - | - | - | - | S100665 | TAYLOR ST: TURK ST | - | F | F | - | F | 24924000 | 24924000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TURK ST | TURK ST | 510 | 510 | 37.78321431 | -122.41076483 | TAYLOR ST \ TURK ST | TAYLOR ST \ TURK ST | 1731085090000 | middleware_editor | ONE WAY (RA) | TURK ST intersection | - | 0 / 0 | - | - | - | - | - | 43323 | -402969600000 | -122.41076483 | 37.78321431 | - | 1582675200000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373566500000 | TAYLOR ST | - | - | - | - | - | - |
| 26245 | N/A | Point | - | - | - | - | S100667 | OAK ST: SHRADER ST | - | F | F | - | F | 26436000 | 26436000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | OAK ST | OAK ST | 512 | 512 | 37.77122983 | -122.45224178 | SHRADER ST \ OAK ST | SHRADER ST \ OAK ST | 1710539427000 | MTA | ONE WAY (RA) | OAK ST intersection | - | 0 / 0 | - | - | - | - | - | 43324 | -402969600000 | -122.45224178 | 37.77122983 | - | - | - | D5 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373566500000 | SHRADER ST | - | - | - | - | - | - |
| 26246 | N/A | Point | - | - | - | - | S100669 | OFARRELL ST: LARKIN ST | - | F | F | - | F | 25152000 | 25152000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LARKIN ST | OFARRELL ST | 514 | 514 | 37.78516722 | -122.41790141 | OFARRELL ST \ LARKIN ST | LARKIN ST \ OFARRELL ST | 1710539427000 | MTA | ONE WAY (RA) | OFARRELL ST intersection | - | 0 / 0 | - | - | - | - | - | 43325 | -402969600000 | -122.41790141 | 37.78516722 | - | 1595289600000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373566500000 | LARKIN ST | - | - | - | - | - | - |
| 26247 | N/A | Point | - | - | - | - | S100671 | ALLISON ST: MORSE ST | - | F | F | - | F | 21467000 | 21467000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ALLISON ST | ALLISON ST | 516 | 516 | 37.71238078 | -122.44158509 | MORSE ST \ ALLISON ST | MORSE ST \ ALLISON ST | 1739222560000 | middleware_editor | STOP | ALLISON ST intersection | - | 0 / 00 | - | - | - | - | - | 43326 | -402879600000 | -122.44158509 | 37.71238078 | - | 1553558400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566500000 | MORSE ST | - | - | - | - | - | - |
| 26248 | N/A | Point | - | - | - | - | S100002 | OCTAVIA ST: CALIFORNIA ST | - | F | F | - | F | 26529000 | 26529000 | - | - | SOUTH EAST CORNER | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 521 | 521 | 37.78974286 | -122.42726041 | OCTAVIA ST \ CALIFORNIA ST | OCTAVIA ST \ CALIFORNIA ST | 1741967838000 | middleware_editor | STOP | CALIFORNIA ST intersection | - | OF OCTAVIA & SACRAMENTO ST. | - | - | - | - | - | 43327 | -426618000000 | -122.42726041 | 37.78974286 | - | 1551686400000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373566320000 | OCTAVIA ST | - | - | - | - | - | - |
| 26249 | N/A | Point | - | - | - | - | S100003 | MCALLISTER ST: HYDE ST | - | F | F | - | F | 24333000 | 24333000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HYDE ST | MCALLISTER ST | 522 | 522 | 37.78071918 | -122.41531562 | MCALLISTER ST \ HYDE ST | HYDE ST \ MCALLISTER ST | 1710539427000 | MTA | DO NOT ENTER | MCALLISTER ST intersection | - | 0 / 0 | - | - | - | - | - | 43328 | -410054400000 | -122.41531562 | 37.78071918 | - | - | - | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373566320000 | HYDE ST | - | - | - | - | - | - |
| 26250 | N/A | Point | - | - | - | - | S100004 | MCALLISTER ST: HYDE ST | - | F | F | - | F | 24333000 | 24333000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HYDE ST | MCALLISTER ST | 523 | 523 | 37.78071918 | -122.41531562 | MCALLISTER ST \ HYDE ST | HYDE ST \ MCALLISTER ST | 1710539427000 | MTA | DO NOT ENTER | MCALLISTER ST intersection | - | 0 / 0 | - | - | - | - | - | 43329 | -410054400000 | -122.41531562 | 37.78071918 | - | - | - | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373566320000 | HYDE 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