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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25576 | N/A | Point | - | - | - | - | S101060 | RUTLAND ST: VISITACION AVE | - | F | F | - | F | 20349000 | 20349000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | RUTLAND ST | VISITACION AVE | 680 | 680 | 37.71144776 | -122.40792715 | VISITACION AVE \ RUTLAND ST | RUTLAND ST \ VISITACION AVE | 1710539427000 | MTA | STOP | VISITACION AVE intersection | - | 0 / 0 | - | - | - | - | - | 42654 | -401068800000 | -122.40792715 | 37.71144776 | - | 1707388200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566620000 | RUTLAND ST | - | - | - | - | - | - |
| 25577 | N/A | Point | - | - | - | - | S101061 | HAHN ST: VISITACION AVE | - | F | F | - | F | 20416000 | 20416000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MRS. JACKSON WAY \ VISITACION AVE | HAHN ST \ VISITACION AVE | 681 | 681 | 37.71350428 | -122.41529084 | HAHN ST \ MRS. JACKSON WAY \ VISITACION AVE | MRS. JACKSON WAY \ HAHN ST \ VISITACION AVE | 1738879220000 | middleware_editor | STOP | HAHN ST \ VISITACION AVE intersection | - | 0 / 0 | - | - | - | - | - | 42655 | -401065200000 | -122.41529084 | 37.71350428 | - | 1738834800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566620000 | MRS. JACKSON WAY | - | - | - | - | - | - |
| 25578 | N/A | Point | - | - | - | - | S101063 | SCHWERIN ST: VISITACION AVE | - | F | F | - | F | 20372000 | 20372000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VISITACION AVE | VISITACION AVE | 682 | 682 | 37.71220622 | -122.4106408 | SCHWERIN ST \ VISITACION AVE | SCHWERIN ST \ VISITACION AVE | 1710539427000 | MTA | STOP | VISITACION AVE intersection | - | 0 / 00 | - | - | - | - | - | 42656 | -401068800000 | -122.4106408 | 37.71220622 | - | 737683200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566620000 | SCHWERIN ST | - | - | - | - | - | - |
| 25579 | N/A | Point | - | - | - | - | S101064 | VISITACION AVE: SCHWERIN ST | - | F | F | - | F | 20372000 | 20372000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VISITACION AVE | VISITACION AVE | 683 | 683 | 37.71220622 | -122.4106408 | SCHWERIN ST \ VISITACION AVE | SCHWERIN ST \ VISITACION AVE | 1710539427000 | MTA | STOP | VISITACION AVE intersection | - | 00 / 00 | - | - | - | - | - | 42657 | -401068800000 | -122.4106408 | 37.71220622 | - | 937353600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566620000 | SCHWERIN ST | - | - | - | - | - | - |
| 25580 | N/A | Point | - | - | - | - | S101065 | VISITACION AVE: SCHWERIN ST | - | F | F | - | F | 20372000 | 20372000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VISITACION AVE | VISITACION AVE | 684 | 684 | 37.71220622 | -122.4106408 | SCHWERIN ST \ VISITACION AVE | SCHWERIN ST \ VISITACION AVE | 1710539427000 | MTA | STOP | VISITACION AVE intersection | - | 00 / 00 | - | - | - | - | - | 42658 | -401068800000 | -122.4106408 | 37.71220622 | - | 1585699200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566620000 | SCHWERIN ST | - | - | - | - | - | - |
| 25581 | N/A | Point | - | - | - | - | S101067 | SUNNYDALE AVE: HAHN ST | - | F | F | - | F | 20409000 | 20409000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HAHN ST \ SUNNYDALE AVE | MRS. JACKSON WAY \ SUNNYDALE AVE | 685 | 685 | 37.71191456 | -122.41600028 | MRS. JACKSON WAY \ HAHN ST \ SUNNYDALE AVE | HAHN ST \ MRS. JACKSON WAY \ SUNNYDALE AVE | 1710539427000 | MTA | STOP | MRS. JACKSON WAY \ SUNNYDALE AVE intersection | - | 0 / 0 | - | - | - | - | - | 42659 | -401068800000 | -122.41600028 | 37.71191456 | - | 727056000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566620000 | HAHN ST | - | - | - | - | - | - |
| 25582 | N/A | Point | - | - | - | - | S101068 | VISITACION AVE: HAHN ST | - | F | F | - | F | 20416000 | 20416000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MRS. JACKSON WAY \ VISITACION AVE | HAHN ST \ VISITACION AVE | 686 | 686 | 37.71350428 | -122.41529084 | HAHN ST \ MRS. JACKSON WAY \ VISITACION AVE | MRS. JACKSON WAY \ HAHN ST \ VISITACION AVE | 1738879604000 | middleware_editor | STOP | HAHN ST \ VISITACION AVE intersection | - | 00 / 00 | - | - | - | - | - | 42660 | -401065200000 | -122.41529084 | 37.71350428 | - | 1738840800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566620000 | MRS. JACKSON WAY | - | - | - | - | - | - |
| 25583 | N/A | Point | - | - | - | - | S101069 | RAYMOND AVE: RUTLAND ST | - | F | F | - | F | 20357000 | 20357000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | RAYMOND AVE | RUTLAND ST | 687 | 687 | 37.71322568 | -122.40705644 | RUTLAND ST \ RAYMOND AVE | RAYMOND AVE \ RUTLAND ST | 1710539427000 | MTA | STOP | RUTLAND ST intersection | - | 0 / 00 | - | - | - | - | - | 42661 | -401068800000 | -122.40705644 | 37.71322568 | - | 1585699200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566620000 | RAYMOND AVE | - | - | - | - | - | - |
| 25584 | N/A | Point | - | - | - | - | S101070 | RAYMOND AVE: RUTLAND ST | - | F | F | - | F | 20357000 | 20357000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | RAYMOND AVE | RUTLAND ST | 688 | 688 | 37.71322568 | -122.40705644 | RUTLAND ST \ RAYMOND AVE | RAYMOND AVE \ RUTLAND ST | 1710539427000 | MTA | STOP | RUTLAND ST intersection | - | 0 / 00 | - | - | - | - | - | 42662 | -401068800000 | -122.40705644 | 37.71322568 | - | 884217600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566680000 | RAYMOND AVE | - | - | - | - | - | - |
| 25585 | N/A | Point | - | - | - | - | S100082 | CAPISTRANO AVE: SANTA ROSA AVE | - | F | F | - | F | 21802000 | 21802000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CAPISTRANO AVE | CAPISTRANO AVE | 689 | 689 | 37.72786053 | -122.43808473 | SANTA ROSA AVE \ CAPISTRANO AVE | SANTA ROSA AVE \ CAPISTRANO AVE | 1718241176000 | middleware_editor | STOP | CAPISTRANO AVE intersection | - | 0 / 0 | - | - | - | - | - | 42663 | -406425600000 | -122.43808473 | 37.72786053 | - | 1357516800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566320000 | SANTA ROSA AVE | - | - | - | - | - | - |
| 25586 | N/A | Point | - | - | - | - | S100088 | ROUSSEAU ST: CAYUGA AVE | - | F | F | - | F | 21706000 | 21706000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CAYUGA AVE | CAYUGA AVE | 691 | 691 | 37.73145973 | -122.42976635 | ROUSSEAU ST \ CAYUGA AVE | ROUSSEAU ST \ CAYUGA AVE | 1710539427000 | MTA | ONE WAY (LA) | CAYUGA AVE intersection | - | 150W / 0 | - | - | - | - | - | 42664 | -406425600000 | -122.42976635 | 37.73145973 | - | - | - | D8 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | UNKNOWN | IS | 1373566320000 | ROUSSEAU ST | - | - | - | - | - | - |
| 25587 | N/A | Point | - | - | - | - | S100812 | OFARRELL ST: GRANT AVE \ MARKE | - | F | F | - | F | 30768000 | 30768000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MARKET ST \ OFARRELL ST | GRANT AVE \ MARKET ST | 697 | 697 | 37.78673057 | -122.40458332 | GRANT AVE \ MARKET ST \ OFARRELL ST | OFARRELL ST \ GRANT AVE \ MARKET ST | 1710539427000 | MTA | DO NOT ENTER | GRANT AVE \ MARKET ST intersection | - | 0 / MADE EASTBOUND ONE WAY | - | - | - | - | - | 42665 | -402451200000 | -122.40458332 | 37.78673057 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373566560000 | OFARRELL ST | - | - | - | - | - | - |
| 25588 | N/A | Point | - | - | - | - | S100814 | ELM ST: POLK ST | - | F | F | - | F | 24465000 | 24465000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POLK ST | ELM ST | 698 | 698 | 37.78170479 | -122.41890131 | ELM ST \ POLK ST | POLK ST \ ELM ST | 1719623443000 | middleware_editor | ONE WAY (LA) | ELM ST intersection | - | NWC | - | - | - | - | - | 42666 | -402451200000 | -122.41890131 | 37.78170479 | - | 1471478400000 | - | D6 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP1 | 2IN IRON POST | IS | 1373566560000 | POLK ST | - | - | - | - | - | - |
| 25589 | N/A | Point | - | - | - | - | S100815 | CEDAR ST: POLK ST | - | F | F | - | F | 25199000 | 25199000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POLK ST | CEDAR ST | 699 | 699 | 37.78635895 | -122.41983309 | CEDAR ST \ POLK ST | POLK ST \ CEDAR ST | 1710539427000 | MTA | ONE WAY (LA) | CEDAR ST intersection | - | 0 / 0 | - | - | - | - | - | 42667 | -402451200000 | -122.41983309 | 37.78635895 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373566560000 | POLK ST | - | - | - | - | - | - |
| 25590 | N/A | Point | - | 1 | 200 - 299 | - | S104255 | 1700-1799 JOHN F KENNEDY DR (G | 200-299 CHAIN OF LAKES DR | F | F | - | F | 3883000 | 3883000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | JOHN F KENNEDY DR | JOHN F KENNEDY DR | 1511 | 1511 | 37.76716112 | -122.50019662 | - | - | 1710539427000 | MTA | STOP | JOHN F KENNEDY DR to GGP ACCESS ROAD (200 - 299) | - | 0 / 0 | - | - | - | - | - | 42668 | -32918400000 | -122.50019662 | 37.76716112 | - | - | - | D1 | - | STOP | REG | R1-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373568840000 | CHAIN OF LAKES DR | 1700-1799 JOHN F KENNEDY DR (G | 200 - 299 CHAIN OF LAKES DR | - | - | GGP ACCESS ROAD | GGP ACCESS ROAD |
| 25591 | N/A | Point | - | 1 | 200 - 299 | - | S104256 | 1700-1799 JOHN F KENNEDY DR (G | 200-299 CHAIN OF LAKES DR | F | F | - | F | 3883000 | 3883000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JOHN F KENNEDY DR | JOHN F KENNEDY DR | 1512 | 1512 | 37.76716112 | -122.50019662 | - | - | 1710539427000 | MTA | STOP | JOHN F KENNEDY DR to GGP ACCESS ROAD (200 - 299) | - | 0 / 0 | - | - | - | - | - | 42669 | -32918400000 | -122.50019662 | 37.76716112 | - | - | - | D1 | - | STOP | REG | R1-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373568840000 | CHAIN OF LAKES DR | 1700-1799 JOHN F KENNEDY DR (G | 200 - 299 CHAIN OF LAKES DR | - | - | GGP ACCESS ROAD | GGP ACCESS ROAD |
| 25592 | N/A | Point | 1 | 1 | 13 - 99 | - | S104257 | 13-99 COLLINGWOOD ST | 13-99 COLLINGWOOD ST | F | F | - | F | 4269000 | 4269000 | - | - | EAST SIDE, WESTBOUND TRAFFIC | - | - | - | - | MARKET ST | MARKET ST | 1513 | 1513 | 37.76148081 | -122.43617796 | - | - | 1710539427000 | MTA | STOP | MARKET ST to 18TH ST (13 - 99) | - | 0 / FOR CITY PARKING LOT | - | - | - | - | - | 42670 | -32832000000 | -122.43617796 | 37.76148081 | - | 1472169600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568840000 | COLLINGWOOD ST | 13 - 99 COLLINGWOOD ST | 13 - 99 COLLINGWOOD ST | 13 COLLINGWOOD ST | - | 18TH ST | 18TH ST |
| 25593 | N/A | Point | - | - | - | - | S104258 | 16TH AVE: CLEMENT ST | - | F | F | - | F | 27491000 | 27491000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 16TH AVE | CLEMENT ST | 1514 | 1514 | 37.7823648544553 | -122.475159466262 | CLEMENT ST \ 16TH AVE | 16TH AVE \ CLEMENT ST | 1753811126000 | middleware_editor | STOP | CLEMENT ST intersection | - | 0 / 0 | - | - | - | - | - | 42671 | -32025600000 | -122.47523562 | 37.78245727 | - | 1740087960000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1373568840000 | 16TH AVE | - | - | - | - | - | - |
| 25594 | N/A | Point | - | - | - | - | S104259 | 17TH AVE: CLEMENT ST | - | F | F | - | F | 27502000 | 27502000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 1515 | 1515 | 37.78240596 | -122.47630655 | 17TH AVE \ CLEMENT ST | 17TH AVE \ CLEMENT ST | 1740092026000 | middleware_editor | STOP | CLEMENT ST intersection | - | - | - | - | - | - | - | 42672 | -32054400000 | -122.47630655 | 37.78240596 | - | 1740060660000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568840000 | 17TH AVE | - | - | - | - | - | - |
| 25595 | N/A | Point | - | - | - | - | S104260 | 17TH AVE: CLEMENT ST | - | F | F | - | F | 27502000 | 27502000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 1516 | 1516 | 37.78240596 | -122.47630655 | 17TH AVE \ CLEMENT ST | 17TH AVE \ CLEMENT ST | 1734559717000 | middleware_editor | STOP | CLEMENT ST intersection | - | - | - | - | - | - | - | 42673 | -32054400000 | -122.47630655 | 37.78240596 | - | 1734518100000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568840000 | 17TH AVE | - | - | - | - | - | - |
| 25596 | N/A | Point | 1 | 1 | 1 - 99 | - | S104541 | 1-99 EWING TER | 1-99 EWING TER | F | F | - | F | 5356000 | 5356000 | - | - | WEST SIDE, WESTBOUND TRAFFIC | - | - | - | - | MASONIC AVE | MASONIC AVE | 1518 | 1518 | 37.78009979 | -122.44776572 | - | - | 1711569992000 | middleware_editor | ONE WAY (RA) | MASONIC AVE to EWING TER (1 - 99) | - | 0 / 7S OF 385 NPL | - | - | - | - | - | 42674 | 7174800000 | -122.44776572 | 37.78009979 | - | - | - | D1 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | UNKNOWN | IS | 1373568960000 | EWING TER | 1 - 99 EWING TER | 1 - 99 EWING TER | 1 EWING TER | - | EWING TER | EWING TER |
| 25597 | N/A | Point | - | - | - | - | S104542 | OCEAN AVE: HAROLD AVE | - | F | F | - | F | 22217000 | 22217000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | OCEAN AVE | OCEAN AVE | 1519 | 1519 | 37.72324404 | -122.4531072 | HAROLD AVE \ OCEAN AVE | HAROLD AVE \ OCEAN AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) | OCEAN AVE intersection | - | 0 / 0 | - | - | - | - | - | 42675 | 7257600000 | -122.4531072 | 37.72324404 | - | - | - | D7 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP2 | 3IN IRON POST | IS | 1373568960000 | HAROLD AVE | - | - | - | - | - | - |
| 25598 | N/A | Point | - | - | - | - | S105833 | SUTTER ST: SCOTT ST | - | F | F | - | F | 26625000 | 26625000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SUTTER ST | SCOTT ST | 1522 | 1522 | 37.78545934 | -122.43820638 | SCOTT ST \ SUTTER ST | SUTTER ST \ SCOTT ST | 1754407885000 | middleware_editor | STOP | SCOTT ST intersection | - | 0 / 00 | - | - | - | - | - | 42676 | 104745600000 | -122.43820638 | 37.78545934 | - | 1457424000000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | MUNI POLE | IS | 1373569380000 | SUTTER ST | - | - | - | - | - | - |
| 25599 | N/A | Point | - | - | - | - | S105834 | SUTTER ST: SCOTT ST | - | F | F | - | F | 26625000 | 26625000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SUTTER ST | SCOTT ST | 1523 | 1523 | 37.78545934 | -122.43820638 | SCOTT ST \ SUTTER ST | SUTTER ST \ SCOTT ST | 1754778488000 | middleware_editor | STOP | SCOTT ST intersection | - | 0 / 00 | - | - | - | - | - | 42677 | 104745600000 | -122.43820638 | 37.78545934 | - | 1754679240000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | GUIDE POLE | IS | 1373569380000 | SUTTER ST | - | - | - | - | - | - |
| 25600 | N/A | Point | - | - | - | - | S105837 | VALLEJO ST: HYDE ST | - | F | F | - | F | 25286000 | 25286000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HYDE ST | HYDE ST | 1526 | 1526 | 37.79733383 | -122.41867167 | VALLEJO ST \ HYDE ST | VALLEJO ST \ HYDE ST | 1710539427000 | MTA | STOP | HYDE ST intersection | - | 0 / 00 | - | - | - | - | - | 42678 | 104716800000 | -122.41867167 | 37.79733383 | - | 1555632000000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569380000 | VALLEJO ST | - | - | - | - | - | - |
| 25601 | N/A | Point | - | - | - | - | S105839 | FOREST SIDE AVE: ULLOA ST | - | T | T | - | F | 22950000 | 22950000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ULLOA ST | ULLOA ST | 1527 | 1527 | 37.74150335 | -122.4685611 | FOREST SIDE AVE \ ULLOA ST | FOREST SIDE AVE \ ULLOA ST | 1718907712000 | middleware_editor | STOP | ULLOA ST intersection | - | - | - | - | - | - | - | 42679 | 104976000000 | -122.4685611 | 37.74150335 | - | 1130803200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373569380000 | FOREST SIDE AVE | - | - | - | - | - | - |
| 25602 | N/A | Point | - | - | - | - | S105840 | WAWONA ST: ULLOA ST | - | F | F | - | F | 22964000 | 22964000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WAWONA ST | ULLOA ST | 1528 | 1528 | 37.74132373 | -122.46671474 | ULLOA ST \ WAWONA ST | WAWONA ST \ ULLOA ST | 1726017704000 | middleware_editor | STOP | ULLOA ST intersection | - | 0 / 0 | - | - | - | - | - | 42680 | 104976000000 | -122.46671474 | 37.74132373 | - | 1520208000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569380000 | WAWONA ST | - | - | - | - | - | - |
| 25603 | N/A | Point | - | - | - | - | S105841 | WAWONA ST: ULLOA ST | - | F | F | - | F | 22964000 | 22964000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WAWONA ST | ULLOA ST | 1529 | 1529 | 37.74132373 | -122.46671474 | ULLOA ST \ WAWONA ST | WAWONA ST \ ULLOA ST | 1726017703000 | middleware_editor | STOP | ULLOA ST intersection | - | 0 / 0 | - | - | - | - | - | 42681 | 104976000000 | -122.46671474 | 37.74132373 | - | 1520208000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569380000 | WAWONA ST | - | - | - | - | - | - |
| 25604 | N/A | Point | - | - | - | - | S105842 | ULLOA ST: WEST PORTAL AVE | - | F | F | - | F | 22928000 | 22928000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ULLOA ST | ULLOA ST | 1530 | 1530 | 37.74089198 | -122.46582902 | WEST PORTAL AVE \ ULLOA ST | WEST PORTAL AVE \ ULLOA ST | 1727476154000 | middleware_editor | STOP | ULLOA ST intersection | - | - | - | - | - | - | - | 42682 | 104976000000 | -122.46582902 | 37.74089198 | - | 1520899200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | MUNI POLE | IS | 1373569380000 | WEST PORTAL AVE | - | - | - | - | - | - |
| 25605 | N/A | Point | - | - | - | - | S105683 | HAYES ST: SCOTT ST | - | F | F | - | F | 26052000 | 26052000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SCOTT ST | HAYES ST | 2276 | 2276 | 37.77520593 | -122.43612896 | HAYES ST \ SCOTT ST | SCOTT ST \ HAYES ST | 1743199088000 | middleware_editor | STOP | HAYES ST intersection | - | 0 / 00 | - | - | - | - | - | 42683 | 96105600000 | -122.43612896 | 37.77520593 | - | 1743196500000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569320000 | SCOTT ST | - | - | - | - | - | - |
| 25606 | N/A | Point | - | - | - | - | S105684 | NORTH POINT ST: WEBSTER ST | - | F | F | - | F | 26778000 | 26778000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | NORTH POINT ST | WEBSTER ST | 2277 | 2277 | 37.80382305 | -122.43516916 | WEBSTER ST \ NORTH POINT ST | NORTH POINT ST \ WEBSTER ST | 1710539427000 | MTA | STOP | WEBSTER ST intersection | - | 00 / 00 | - | - | - | - | - | 42684 | 96249600000 | -122.43516916 | 37.80382305 | - | - | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569320000 | NORTH POINT ST | - | - | - | - | - | - |
| 25607 | N/A | Point | - | - | - | - | S105686 | DE HARO ST: MARIPOSA ST | - | F | F | - | F | 23752000 | 23752000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DE HARO ST | DE HARO ST | 2278 | 2278 | 37.76356146 | -122.40147894 | MARIPOSA ST \ DE HARO ST | MARIPOSA ST \ DE HARO ST | 1710539427000 | MTA | STOP | DE HARO ST intersection | - | 0 / 0 | - | - | - | - | - | 42685 | 96249600000 | -122.40147894 | 37.76356146 | - | 1684108800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569320000 | MARIPOSA ST | - | - | - | - | - | - |
| 25608 | N/A | Point | - | - | - | - | S105688 | KEITH ST: NEWCOMB AVE | - | F | F | - | F | 20197000 | 20197000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | KEITH ST | KEITH ST | 2280 | 2280 | 37.73310348 | -122.38604554 | NEWCOMB AVE \ KEITH ST | NEWCOMB AVE \ KEITH ST | 1753822359000 | middleware_editor | STOP | KEITH ST intersection | - | 0 / 0 | - | - | - | - | - | 42686 | 96883200000 | -122.38604554 | 37.73310348 | - | 1460444400000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569320000 | NEWCOMB AVE | - | - | - | - | - | - |
| 25609 | N/A | Point | - | - | - | - | S105690 | BEACH ST: SCOTT ST | - | F | F | - | F | 26995000 | 26995000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BEACH ST | BEACH ST | 2281 | 2281 | 37.80391653 | -122.44193961 | SCOTT ST \ BEACH ST | SCOTT ST \ BEACH ST | 1710539427000 | MTA | STOP | BEACH ST intersection | - | 0 / 00 | - | - | - | - | - | 42687 | 97200000000 | -122.44193961 | 37.80391653 | - | 1531440000000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569320000 | SCOTT ST | - | - | - | - | - | - |
| 25610 | N/A | Point | - | - | - | - | S105691 | BEACH ST: SCOTT ST | - | F | F | - | F | 26995000 | 26995000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BEACH ST | BEACH ST | 2282 | 2282 | 37.80391653 | -122.44193961 | SCOTT ST \ BEACH ST | SCOTT ST \ BEACH ST | 1710539427000 | MTA | STOP | BEACH ST intersection | - | 0 / 00 | - | - | - | - | - | 42688 | 97200000000 | -122.44193961 | 37.80391653 | - | 711936000000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569320000 | SCOTT ST | - | - | - | - | - | - |
| 25611 | N/A | Point | - | - | - | - | S104856 | INDIANA ST: 23RD ST | - | F | F | - | F | 23617000 | 23617000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | INDIANA ST | 23RD ST | 2284 | 2284 | 37.7552139 | -122.39092194 | 23RD ST \ INDIANA ST | INDIANA ST \ 23RD ST | 1710539427000 | MTA | STOP | 23RD ST intersection | - | 00 / 00 | - | - | - | - | - | 42689 | 33091200000 | -122.39092194 | 37.7552139 | - | 995932800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373569080000 | INDIANA ST | - | - | - | - | - | - |
| 25612 | N/A | Point | - | - | - | - | S104862 | 21ST ST: CAPP ST | - | F | F | - | F | 24084000 | 24084000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CAPP ST | 21ST ST | 2288 | 2288 | 37.75710093 | -122.4178119 | 21ST ST \ CAPP ST | CAPP ST \ 21ST ST | 1718224719000 | middleware_editor | STOP | 21ST ST intersection | - | 0 / 0 | - | - | - | - | - | 42690 | 33350400000 | -122.4178119 | 37.75710093 | - | 1512000000000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569080000 | CAPP ST | - | - | - | - | - | - |
| 25613 | N/A | Point | - | - | - | - | S104863 | 21ST ST: CAPP ST | - | F | F | - | F | 24084000 | 24084000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CAPP ST | 21ST ST | 2289 | 2289 | 37.75710093 | -122.4178119 | 21ST ST \ CAPP ST | CAPP ST \ 21ST ST | 1756158293000 | middleware_editor | STOP | 21ST ST intersection | - | 0 / 0 | - | - | - | - | - | 42691 | 33379200000 | -122.4178119 | 37.75710093 | - | 1755896100000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569080000 | CAPP ST | - | - | - | - | - | - |
| 25614 | N/A | Point | - | - | - | - | S104872 | 20TH AVE: PACHECO ST | - | F | F | - | F | 23207000 | 23207000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 20TH AVE | PACHECO ST | 2293 | 2293 | 37.7504629 | -122.47728325 | PACHECO ST \ 20TH AVE | 20TH AVE \ PACHECO ST | 1747933312000 | MALOPEZ | STOP | PACHECO ST intersection | - | 0 / 0 | - | - | - | - | - | 42692 | 34588800000 | -122.47728325 | 37.7504629 | - | 1464850800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569080000 | 20TH AVE | - | - | - | - | - | - |
| 25615 | N/A | Point | - | - | - | - | S104873 | 20TH AVE: PACHECO ST | - | F | F | - | F | 23207000 | 23207000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 20TH AVE | PACHECO ST | 2294 | 2294 | 37.7504629 | -122.47728325 | PACHECO ST \ 20TH AVE | 20TH AVE \ PACHECO ST | 1747926890000 | evillan | STOP | PACHECO ST intersection | - | 0 / 0 | - | - | - | - | - | 42693 | 34588800000 | -122.47728325 | 37.7504629 | - | 1464850800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569080000 | 20TH AVE | - | - | - | - | - | - |
| 25616 | N/A | Point | - | - | - | - | S104874 | DE HARO ST: 17TH ST | - | F | F | - | F | 23753000 | 23753000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DE HARO ST | DE HARO ST | 2295 | 2295 | 37.76483924 | -122.401599 | 17TH ST \ DE HARO ST | 17TH ST \ DE HARO ST | 1710539427000 | MTA | STOP | DE HARO ST intersection | - | 0 / 0 | - | - | - | - | - | 42694 | 34560000000 | -122.401599 | 37.76483924 | - | 883353600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569080000 | 17TH ST | - | - | - | - | - | - |
| 25617 | N/A | Point | - | - | - | - | S104882 | SANCHEZ ST: 18TH ST | - | F | F | - | F | 25720000 | 25720000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SANCHEZ ST | 18TH ST | 2300 | 2300 | 37.76115548 | -122.43057357 | 18TH ST \ SANCHEZ ST | SANCHEZ ST \ 18TH ST | 1710539427000 | MTA | STOP | 18TH ST intersection | - | 0 / 0 | - | - | - | - | - | 42695 | 35510400000 | -122.43057357 | 37.76115548 | - | 1466121600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569080000 | SANCHEZ ST | - | - | - | - | - | - |
| 25618 | N/A | Point | - | - | - | - | S103952 | WASHINGTON ST: STOCKTON ST | - | F | F | - | F | 25026000 | 25026000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | STOCKTON ST | WASHINGTON ST | 2301 | 2301 | 37.79494069 | -122.4080791 | WASHINGTON ST \ STOCKTON ST | STOCKTON ST \ WASHINGTON ST | 1726103492000 | middleware_editor | ONE WAY (LA) | WASHINGTON ST intersection | - | S LINE / 0 | - | - | - | - | - | 42696 | -70156800000 | -122.4080791 | 37.79494069 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373568780000 | STOCKTON ST | - | - | - | - | - | - |
| 25619 | N/A | Point | - | - | - | - | S103954 | JACKSON ST: GRANT AVE | - | F | F | - | F | 25030000 | 25030000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GRANT AVE | JACKSON ST | 2303 | 2303 | 37.79602475 | -122.40665235 | JACKSON ST \ GRANT AVE | GRANT AVE \ JACKSON ST | 1727803486000 | middleware_editor | ONE WAY (RA) | JACKSON ST intersection | - | 0 / 0 | - | - | - | - | - | 42697 | -70156800000 | -122.40665235 | 37.79602475 | - | 1510617600000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | SIGNAL POLE | IS | 1373568780000 | GRANT AVE | - | - | - | - | - | - |
| 25620 | N/A | Point | - | - | - | - | S107954 | BLANKEN AVE: TUNNEL AVE | - | F | F | - | F | 20289000 | 20289000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TUNNEL AVE | BLANKEN AVE | 3637 | 3637 | 37.71201631 | -122.4007892 | BLANKEN AVE \ TUNNEL AVE | TUNNEL AVE \ BLANKEN AVE | 1710539427000 | MTA | STOP | BLANKEN AVE intersection | - | 0 / 0 | - | - | - | - | - | 42698 | 267753600000 | -122.4007892 | 37.71201631 | - | 1707470700000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570040000 | TUNNEL AVE | - | - | - | - | - | - |
| 25621 | N/A | Point | - | - | - | - | S107957 | TUNNEL AVE: BLANKEN AVE | - | F | F | - | F | 20289000 | 20289000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TUNNEL AVE | BLANKEN AVE | 3638 | 3638 | 37.71201631 | -122.4007892 | BLANKEN AVE \ TUNNEL AVE | TUNNEL AVE \ BLANKEN AVE | 1710539427000 | MTA | STOP | BLANKEN AVE intersection | - | 0 / 0 | - | - | - | - | - | 42699 | 267753600000 | -122.4007892 | 37.71201631 | - | 701481600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570040000 | TUNNEL AVE | - | - | - | - | - | - |
| 25622 | N/A | Point | - | - | - | - | S107842 | 28TH AVE: VICENTE ST | - | F | F | - | F | 23250000 | 23250000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VICENTE ST | 28TH AVE | 3641 | 3641 | 37.73889987 | -122.48507449 | 28TH AVE \ VICENTE ST | VICENTE ST \ 28TH AVE | 1738171915000 | middleware_editor | STOP | 28TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 42700 | 257990400000 | -122.48507449 | 37.73889987 | - | 1465862400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | VICENTE ST | - | - | - | - | - | - |
| 25623 | N/A | Point | - | - | - | - | S107962 | SACRAMENTO ST: WEBSTER ST | - | F | F | - | F | 26647000 | 26647000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | WEBSTER ST | 3642 | 3642 | 37.790117597 | -122.432284984 | WEBSTER ST \ SACRAMENTO ST | SACRAMENTO ST \ WEBSTER ST | 1746834138000 | middleware_editor | STOP | WEBSTER ST intersection | - | 0 / 0 | - | - | - | - | - | 42701 | 268470000000 | -122.43238454 | 37.7900442 | - | 1519113600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570040000 | SACRAMENTO ST | - | - | - | - | - | - |
| 25624 | N/A | Point | - | - | - | - | S107963 | SACRAMENTO ST: WEBSTER ST | - | F | F | - | F | 26647000 | 26647000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | WEBSTER ST | 3643 | 3643 | 37.7899827331045 | -122.432472780342 | WEBSTER ST \ SACRAMENTO ST | SACRAMENTO ST \ WEBSTER ST | 1746834130000 | middleware_editor | STOP | WEBSTER ST intersection | - | 0 / 0 | - | - | - | - | - | 42702 | 268470000000 | -122.43238454 | 37.7900442 | - | 1592204400000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570040000 | SACRAMENTO ST | - | - | - | - | - | - |
| 25625 | N/A | Point | - | - | - | - | S104967 | HOWARD ST: 11TH ST | - | F | F | - | F | 24353000 | 24353000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HOWARD ST | HOWARD ST | 3645 | 3645 | 37.77310059 | -122.41556139 | 11TH ST \ HOWARD ST | 11TH ST \ HOWARD ST | 1710539427000 | MTA | DO NOT ENTER | HOWARD ST intersection | - | 0 / MADE HOWARD 1-WAY WB BET BEALE ..... | - | - | - | - | - | 42703 | 38966400000 | -122.41556139 | 37.77310059 | - | - | - | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373569080000 | 11TH ST | - | - | - | - | - | - |
| 25626 | N/A | Point | - | - | - | - | S102268 | FRONT ST: SACRAMENTO ST | - | F | F | - | F | 24691000 | 24691000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FRONT ST | FRONT ST | 3691 | 3691 | 37.79428442 | -122.39897025 | SACRAMENTO ST \ FRONT ST | SACRAMENTO ST \ FRONT ST | 1747850734000 | middleware_editor | ONE WAY (RA) | FRONT ST intersection | - | - | - | - | - | - | - | 42704 | -389466000000 | -122.39897025 | 37.79428442 | - | 1747848600000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | LIGHT POLE | IS | 1373568240000 | SACRAMENTO ST | - | - | - | - | - | - |
| 25627 | N/A | Point | - | - | - | - | S102269 | SANSOME ST: SACRAMENTO ST | - | F | F | - | F | 24701000 | 24701000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | SACRAMENTO ST | 3692 | 3692 | 37.79398706 | -122.4013145 | SANSOME ST \ SACRAMENTO ST | SANSOME ST \ SACRAMENTO ST | 1727215657000 | middleware_editor | ONE WAY (RA) | SACRAMENTO ST intersection | - | 0 / 0 | - | - | - | - | - | 42705 | -389491200000 | -122.4013145 | 37.79398706 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568240000 | SANSOME ST | - | - | - | - | - | - |
| 25628 | N/A | Point | - | - | - | - | S102270 | SACRAMENTO ST: MONTGOMERY ST | - | F | F | - | F | 24734000 | 24734000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | SACRAMENTO ST | 3693 | 3693 | 37.79377986 | -122.40295736 | MONTGOMERY ST \ SACRAMENTO ST | MONTGOMERY ST \ SACRAMENTO ST | 1722349542000 | middleware_editor | ONE WAY (RA) | SACRAMENTO ST intersection | - | 0 / 0 | - | - | - | - | - | 42706 | -389491200000 | -122.40295736 | 37.79377986 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568240000 | MONTGOMERY ST | - | - | - | - | - | - |
| 25629 | N/A | Point | - | - | - | - | S102271 | COMMERCIAL ST: MONTGOMERY ST | - | F | F | - | F | 24755000 | 24755000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MONTGOMERY ST | COMMERCIAL ST | 3694 | 3694 | 37.79421604 | -122.40304688 | COMMERCIAL ST \ MONTGOMERY ST | MONTGOMERY ST \ COMMERCIAL ST | 1733183427000 | middleware_editor | ONE WAY (RA) | COMMERCIAL ST intersection | - | 0 / 0 | - | - | - | - | - | 42707 | -389491200000 | -122.40304688 | 37.79421604 | - | 1724151300000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568240000 | MONTGOMERY ST | - | - | - | - | - | - |
| 25630 | N/A | Point | - | - | - | - | S102273 | WASHINGTON ST: COLUMBUS AVE \ | - | F | F | - | F | 24710000 | 24710000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 3695 | 3695 | 37.79559753 | -122.40274216 | \WASHINGTON ST: COLUMBUS AVE \ | HOTALING PL \ WASHINGTON ST | 1733183289000 | middleware_editor | ONE WAY (RA) | WASHINGTON ST intersection | - | 0 / 0 | - | - | - | - | - | 42708 | -389491200000 | -122.40274216 | 37.79559753 | - | 1723552200000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568240000 | HOTALING PL | - | - | - | - | - | - |
| 25631 | N/A | Point | - | - | - | - | S102276 | COMMERCIAL ST: KEARNY ST | - | F | F | - | F | 24750000 | 24750000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | COMMERCIAL ST | COMMERCIAL ST | 3696 | 3696 | 37.79402138 | -122.40471058 | KEARNY ST \ COMMERCIAL ST | KEARNY ST \ COMMERCIAL ST | 1726696068000 | middleware_editor | ONE WAY (RA) | COMMERCIAL ST intersection | - | 0 / 0 | - | - | - | - | - | 42709 | -389491200000 | -122.40471058 | 37.79402138 | - | - | 1726670820000 | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | RETD | 1373568240000 | KEARNY ST | - | - | - | - | - | - |
| 25632 | N/A | Point | - | - | - | - | S102397 | CLAY ST: STOCKTON ST | - | F | F | - | F | 24995000 | 24995000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CLAY ST | CLAY ST | 3748 | 3748 | 37.7940603 | -122.4079033 | STOCKTON ST \ CLAY ST | STOCKTON ST \ CLAY ST | 1721159016000 | middleware_editor | ONE WAY (RA) | CLAY ST intersection | - | S LINE / 0 | - | - | - | - | - | 42710 | -388972800000 | -122.4079033 | 37.7940603 | - | 1719564300000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373568300000 | STOCKTON ST | - | - | - | - | - | - |
| 25633 | N/A | Point | - | - | - | - | S102398 | SACRAMENTO ST: JOICE ST | - | F | F | - | F | 24997000 | 24997000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | JOICE ST | 3749 | 3749 | 37.79307444 | -122.40854506 | JOICE ST \ SACRAMENTO ST | SACRAMENTO ST \ JOICE ST | 1742845948000 | middleware_editor | ONE WAY (RA) | JOICE ST intersection | - | 0 / 0 | - | - | - | - | - | 42711 | -388947600000 | -122.40854506 | 37.79307444 | - | 1742576400000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | LIGHT POLE | IS | 1373568300000 | SACRAMENTO ST | - | - | - | - | - | - |
| 25634 | N/A | Point | - | - | - | - | S102400 | BROADWAY: THE EMBARCADERO | - | F | F | - | F | 24570000 | 24570000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BROADWAY | BROADWAY | 3750 | 3750 | 37.79923448 | -122.39766995 | THE EMBARCADERO \ BROADWAY | THE EMBARCADERO \ BROADWAY | 1741972909000 | middleware_editor | STOP | BROADWAY intersection | - | 0 / 0 | - | - | - | - | - | 42712 | -388861200000 | -122.39766995 | 37.79923448 | - | 690019200000 | 1741972620000 | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | RETD | 1373568300000 | THE EMBARCADERO | - | - | - | - | - | - |
| 25635 | N/A | Point | - | - | - | - | S102401 | HOTALING PL: WASHINGTON ST | - | F | F | - | F | 24710000 | 24710000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 3751 | 3751 | 37.79559753 | -122.40274216 | HOTALING PL \ WASHINGTON ST | HOTALING PL \ WASHINGTON ST | 1710539427000 | MTA | DO NOT ENTER | WASHINGTON ST intersection | - | 0 / MADE SOUTHBOUND ONE WAY0 | - | - | - | - | - | 42713 | -388886400000 | -122.40274216 | 37.79559753 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373568300000 | HOTALING PL | - | - | - | - | - | - |
| 25636 | N/A | Point | - | - | - | - | S102402 | SANSOME ST: BROADWAY | - | F | F | - | F | 30039000 | 30039000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BROADWAY | BROADWAY | 3752 | 3752 | 37.7984297 | -122.40222864 | SANSOME ST \ BROADWAY | SANSOME ST \ BROADWAY | 1727209064000 | middleware_editor | DO NOT ENTER | BROADWAY intersection | - | 0 / 00 | - | - | - | - | - | 42714 | -388886400000 | -122.40222864 | 37.7984297 | - | - | 1727183820000 | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | RETD | 1373568300000 | SANSOME ST | - | - | - | - | - | - |
| 25637 | N/A | Point | - | - | - | - | S104471 | BATTERY ST: UNION ST | - | F | F | - | F | 24815000 | 24815000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | UNION ST | UNION ST | 3753 | 3753 | 37.80138108 | -122.40161549 | BATTERY ST \ UNION ST | BATTERY ST \ UNION ST | 1753370090000 | elclark | ONE WAY (RA) | UNION ST intersection | - | - | - | - | - | - | - | 42715 | 1238400000 | -122.40161549 | 37.80138108 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 36X12 | SUP1 | 2IN IRON POST | IS | 1373568960000 | BATTERY ST | - | - | - | - | - | - |
| 25638 | N/A | Point | - | - | - | - | S100818 | WILLOW ST: POLK ST | - | F | F | - | F | 25177000 | 25177000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WILLOW ST | WILLOW ST | 702 | 702 | 37.78356779 | -122.41927343 | POLK ST \ WILLOW ST | POLK ST \ WILLOW ST | 1749668371000 | middleware_editor | ONE WAY (LA) | WILLOW ST intersection | - | 0 / 0 | - | - | - | - | - | 42716 | -402422400000 | -122.41927343 | 37.78356779 | - | 1748990700000 | - | D6 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP1 | 2IN IRON POST | IS | 1373566560000 | POLK ST | - | - | - | - | - | - |
| 25639 | N/A | Point | - | - | - | - | S100819 | GEARY ST: POLK ST | - | F | F | - | F | 25182000 | 25182000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POLK ST | GEARY ST | 703 | 703 | 37.7858929 | -122.41973873 | GEARY ST \ POLK ST | POLK ST \ GEARY ST | 1710539427000 | MTA | ONE WAY (LA) | GEARY ST intersection | - | 0 / 0 | - | - | - | - | - | 42717 | -402451200000 | -122.41973873 | 37.7858929 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373566560000 | POLK ST | - | - | - | - | - | - |
| 25640 | N/A | Point | 1 | 1 | 442 - 499 | - | S100823 | 442-499 OFARRELL ST | 442-499 OFARRELL ST | F | F | - | F | 9728000 | 9728000 | - | - | UNKNOWN | - | - | - | - | SHANNON ST | SHANNON ST | 706 | 706 | 37.78584126 | -122.41255859 | - | - | 1710539427000 | MTA | ONE WAY (LA) | SHANNON ST to JONES ST (442 - 499) | - | S LINE / 0 | - | - | - | - | - | 42718 | -402451200000 | -122.41255859 | 37.78584126 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373566560000 | OFARRELL ST | 442 - 499 OFARRELL ST | 442 - 499 OFARRELL ST | 442 OFARRELL ST | - | JONES ST | JONES ST |
| 25641 | N/A | Point | - | - | - | - | S100825 | TURK ST: POLK ST | - | F | F | - | F | 25175000 | 25175000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POLK ST | TURK ST | 708 | 708 | 37.78216927 | -122.41899327 | TURK ST \ POLK ST | POLK ST \ TURK ST | 1710539427000 | MTA | ONE WAY (LA) | TURK ST intersection | - | 0 / 0 | - | - | - | - | - | 42719 | -402451200000 | -122.41899327 | 37.78216927 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373566560000 | POLK ST | - | - | - | - | - | - |
| 25642 | N/A | Point | - | - | - | - | S100768 | 27TH AVE: BALBOA ST | - | F | F | - | F | 27549000 | 27549000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 27TH AVE | 27TH AVE | 709 | 709 | 37.77620375 | -122.48660308 | BALBOA ST \ 27TH AVE | BALBOA ST \ 27TH AVE | 1731454668000 | middleware_editor | STOP | 27TH AVE intersection | - | 00 / 00 | - | - | - | - | - | 42720 | -402447600000 | -122.48660308 | 37.77620375 | - | 1731077460000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | BALBOA ST | - | - | - | - | - | - |
| 25643 | N/A | Point | - | - | - | - | S100769 | 27TH AVE: BALBOA ST | - | F | F | - | F | 27549000 | 27549000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 27TH AVE | 27TH AVE | 710 | 710 | 37.77620375 | -122.48660308 | BALBOA ST \ 27TH AVE | BALBOA ST \ 27TH AVE | 1731454683000 | middleware_editor | STOP | 27TH AVE intersection | - | 00 / 00 | - | - | - | - | - | 42721 | -402447600000 | -122.48660308 | 37.77620375 | - | 1731423120000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | BALBOA ST | - | - | - | - | - | - |
| 25644 | N/A | Point | - | - | - | - | S100770 | 28TH AVE: BALBOA ST | - | F | F | - | F | 27550000 | 27550000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | BALBOA ST | 711 | 711 | 37.77615524 | -122.48766944 | 28TH AVE \ BALBOA ST | 28TH AVE \ BALBOA ST | 1710539427000 | MTA | STOP | BALBOA ST intersection | - | 00 / 00 | - | - | - | - | - | 42722 | -402451200000 | -122.48766944 | 37.77615524 | - | 1099267200000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | 28TH AVE | - | - | - | - | - | - |
| 25645 | N/A | Point | - | - | - | - | S100771 | 28TH AVE: BALBOA ST | - | F | F | - | F | 27550000 | 27550000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | BALBOA ST | 712 | 712 | 37.77615524 | -122.48766944 | 28TH AVE \ BALBOA ST | 28TH AVE \ BALBOA ST | 1732232721000 | middleware_editor | STOP | BALBOA ST intersection | - | 00 / 00 | - | - | - | - | - | 42723 | -402447600000 | -122.48766944 | 37.77615524 | - | 1732190760000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | 28TH AVE | - | - | - | - | - | - |
| 25646 | N/A | Point | - | - | - | - | S100772 | 29TH AVE: BALBOA ST | - | F | F | - | F | 27832000 | 27832000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 29TH AVE | 29TH AVE | 713 | 713 | 37.7761068 | -122.48874085 | BALBOA ST \ 29TH AVE | BALBOA ST \ 29TH AVE | 1732232719000 | middleware_editor | STOP | 29TH AVE intersection | - | 00 / 00 | - | - | - | - | - | 42724 | -402451200000 | -122.48874085 | 37.7761068 | - | 1732190820000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | BALBOA ST | - | - | - | - | - | - |
| 25647 | N/A | Point | - | - | - | - | S100773 | 29TH AVE: BALBOA ST | - | F | F | - | F | 27832000 | 27832000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 29TH AVE | 29TH AVE | 714 | 714 | 37.7761068 | -122.48874085 | BALBOA ST \ 29TH AVE | BALBOA ST \ 29TH AVE | 1732232714000 | middleware_editor | STOP | 29TH AVE intersection | - | 00 / 00 | - | - | - | - | - | 42725 | -402451200000 | -122.48874085 | 37.7761068 | - | 1732196460000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | BALBOA ST | - | - | - | - | - | - |
| 25648 | N/A | Point | - | - | - | - | S100777 | 32ND AVE: BALBOA ST | - | F | F | - | F | 27837000 | 27837000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | 32ND AVE | 717 | 717 | 37.77596006 | -122.49195945 | 32ND AVE \ BALBOA ST | BALBOA ST \ 32ND AVE | 1738882805000 | middleware_editor | STOP | 32ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 42726 | -402447600000 | -122.49195945 | 37.77596006 | - | 1738839960000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | BALBOA ST | - | - | - | - | - | - |
| 25649 | N/A | Point | - | - | - | - | S100778 | 32ND AVE: BALBOA ST | - | F | F | - | F | 27837000 | 27837000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | 32ND AVE | 718 | 718 | 37.77596006 | -122.49195945 | 32ND AVE \ BALBOA ST | BALBOA ST \ 32ND AVE | 1738882749000 | middleware_editor | STOP | 32ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 42727 | -402447600000 | -122.49195945 | 37.77596006 | - | 1738840560000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | BALBOA ST | - | - | - | - | - | - |
| 25650 | N/A | Point | - | - | - | - | S100781 | 35TH AVE: BALBOA ST | - | F | F | - | F | 27850000 | 27850000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | 35TH AVE | 720 | 720 | 37.77581328 | -122.49517485 | 35TH AVE \ BALBOA ST | BALBOA ST \ 35TH AVE | 1737495804000 | middleware_editor | STOP | 35TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 42728 | -402447600000 | -122.49517485 | 37.77581328 | - | 1737464400000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373566560000 | BALBOA 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