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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25951 | N/A | Point | 1 | 1 | 2 - 95 | - | S229852 | 2-95 CASA WAY | 2-95 CASA WAY | F | F | - | F | 3750000 | 3750000 | - | - | NORTH SIDE | - | - | - | - | RETIRO WAY | RETIRO WAY | 89676 | 89676 | 37.8055785187306 | -122.43905961513 | - | - | 1751301657000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "M" PERMITS | RETIRO WAY to AVILA ST \ MARINA BLVD (2 - 95) | - | 217 FEET EAST OF MARINA/WPL # 55 | - | - | - | - | - | 43030 | 1219906800000 | -122.43908452 | 37.80562951 | - | 1476687600000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0096 | 18X21 | SUP1 | LIGHT POLE | IS | 1476452040000 | CASA WAY | 2 - 95 CASA WAY | 2 - 95 CASA WAY | 2 CASA WAY | - | AVILA ST \ MARINA BLVD | AVILA ST \ MARINA BLVD |
| 25952 | N/A | Point | 1 | 1 | 400 - 498 | - | S231632 | 400-499 MISSION BAY BLVD NORTH | 400-498 MISSION BAY BLVD NORTH | F | F | - | F | 15018201 | 15018201 | - | - | NORTH SIDE | - | - | - | - | MISSION BAY BLVD \ VARA ST | MISSION BAY BLVD \ VARA ST | 89678 | 89678 | 37.77116261 | -122.38865228 | - | - | 1710539427000 | MTA | SPECIAL EVENT AREA CHECK YOUR METER (SFPARK) | MISSION BAY BLVD \ VARA ST to 03RD ST \ MISSION BAY BLVD (400 - 498) | - | 100' WEST OF BRIDGEVIEW WAY | - | - | - | - | - | 43031 | 1481208540000 | -122.38865228 | 37.77116261 | - | 1481155200000 | - | D6 | - | OTHER GUIDE | GUIDE | G-S(SF).0058 | 18X18 | SUP1 | LIGHT POLE | IS | 1481197740000 | MISSION BAY BLVD NORTH | 400 - 498 MISSION BAY BLVD NORTH | 400 - 498 MISSION BAY BLVD NORTH | 400 MISSION BAY BLVD NORTH | - | 03RD ST \ MISSION BAY BLVD | 03RD ST \ MISSION BAY BLVD |
| 25953 | N/A | Point | 1 | 1 | 100 - 134 | - | S231406 | 100-134 YUKON ST | 100-134 YUKON ST | F | F | - | F | 13789000 | 13789000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | EAGLE ST | EAGLE ST | 89679 | 89679 | 37.75782694 | -122.44226362 | - | - | 1755532804000 | middleware_editor | ALL WAY | EAGLE ST to SHORT ST (100 - 134) | - | OPP S/W | - | - | - | - | - | 43032 | 748076400000 | -122.44226362 | 37.75782694 | - | 1755274500000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1480516140000 | YUKON ST | 100 - 134 YUKON ST | 100 - 134 YUKON ST | 100 YUKON ST | - | SHORT ST | SHORT ST |
| 25954 | N/A | Point | 1 | 1 | 34 - 75 | - | S100835 | 34-75 SYCAMORE ST | 34-75 SYCAMORE ST | F | F | - | F | 12360000 | 12360000 | - | - | UNKNOWN | - | - | - | - | SAN CARLOS ST | SAN CARLOS ST | 879 | 879 | 37.76264559 | -122.42055751 | - | - | 1717636567000 | middleware_editor | ONE WAY (RA) | SAN CARLOS ST to LEXINGTON ST (34 - 75) | - | N LINE / 0 | - | - | - | - | - | 43033 | -402451200000 | -122.42055751 | 37.76264559 | - | - | - | D9 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | UNKNOWN | IS | 1373566560000 | SYCAMORE ST | 34 - 75 SYCAMORE ST | 34 - 75 SYCAMORE ST | 34 SYCAMORE ST | - | LEXINGTON ST | LEXINGTON ST |
| 25955 | N/A | Point | - | - | - | - | S100837 | TURK ST: POLK ST | - | F | F | - | F | 25175000 | 25175000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POLK ST | TURK ST | 881 | 881 | 37.78216927 | -122.41899327 | TURK ST \ POLK ST | POLK ST \ TURK ST | 1710539427000 | MTA | ONE WAY (RA) | TURK ST intersection | - | 0 / 0 | - | - | - | - | - | 43034 | -402451200000 | -122.41899327 | 37.78216927 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | LIGHT POLE | IS | 1373566560000 | POLK ST | - | - | - | - | - | - |
| 25956 | N/A | Point | - | - | - | - | S100838 | LARKIN ST: GEARY ST | - | F | F | - | F | 25170000 | 25170000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GEARY ST | GEARY ST | 882 | 882 | 37.78610104 | -122.4180881 | LARKIN ST \ GEARY ST | LARKIN ST \ GEARY ST | 1750201363000 | middleware_editor | ONE WAY (RA) | GEARY ST intersection | - | 0 / 0 | - | - | - | - | - | 43035 | -402422400000 | -122.4180881 | 37.78610104 | - | 1750191300000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | LIGHT POLE | IS | 1373566560000 | LARKIN ST | - | - | - | - | - | - |
| 25957 | N/A | Point | - | - | - | - | S100839 | OFARRELL ST: POLK ST | - | F | F | - | F | 25179000 | 25179000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POLK ST | OFARRELL ST | 883 | 883 | 37.78496026 | -122.41954785 | OFARRELL ST \ POLK ST | POLK ST \ OFARRELL ST | 1710539427000 | MTA | ONE WAY (RA) | OFARRELL ST intersection | - | 0 / 0 | - | - | - | - | - | 43036 | -402451200000 | -122.41954785 | 37.78496026 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373566560000 | POLK ST | - | - | - | - | - | - |
| 25958 | N/A | Point | - | - | - | - | S100843 | 44TH AVE: POINT LOBOS AVE | - | F | F | - | F | 27997000 | 27997000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 44TH AVE | POINT LOBOS AVE | 886 | 886 | 37.77979987 | -122.50513508 | POINT LOBOS AVE \ 44TH AVE | 44TH AVE \ POINT LOBOS AVE | 1710539427000 | MTA | STOP | POINT LOBOS AVE intersection | - | 0 / 0 | - | - | - | - | - | 43037 | -402364800000 | -122.50513508 | 37.77979987 | - | 1414627200000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | 44TH AVE | - | - | - | - | - | - |
| 25959 | N/A | Point | - | - | - | - | S100844 | 44TH AVE: POINT LOBOS AVE | - | F | F | - | F | 27997000 | 27997000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 44TH AVE | POINT LOBOS AVE | 887 | 887 | 37.77979987 | -122.50513508 | POINT LOBOS AVE \ 44TH AVE | 44TH AVE \ POINT LOBOS AVE | 1710539427000 | MTA | STOP | POINT LOBOS AVE intersection | - | 0 / 00 | - | - | - | - | - | 43038 | -402364800000 | -122.50513508 | 37.77979987 | - | 1415750400000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | 44TH AVE | - | - | - | - | - | - |
| 25960 | N/A | Point | - | - | - | - | S100847 | 47TH AVE: POINT LOBOS AVE | - | F | F | - | F | 28003000 | 28003000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POINT LOBOS AVE | 47TH AVE | 888 | 888 | 37.77992279 | -122.50836698 | 47TH AVE \ POINT LOBOS AVE | POINT LOBOS AVE \ 47TH AVE | 1711391338000 | middleware_editor | STOP | 47TH AVE intersection | - | 0 / 00 | - | - | - | - | - | 43039 | -402364800000 | -122.50836698 | 37.77992279 | - | 1683158400000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373566560000 | POINT LOBOS AVE | - | - | - | - | - | - |
| 25961 | N/A | Point | - | - | - | - | S100861 | OLIVE ST: POLK ST | - | F | F | - | F | 25180000 | 25180000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | POLK ST | POLK ST | 890 | 890 | 37.78450084 | -122.41945454 | OLIVE ST \ POLK ST | OLIVE ST \ POLK ST | 1749152387000 | middleware_editor | STOP | POLK ST intersection | - | 0 / 00 | - | - | - | - | - | 43040 | -402076800000 | -122.41945454 | 37.78450084 | - | 1749142500000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373566560000 | OLIVE ST | - | - | - | - | - | - |
| 25962 | N/A | Point | - | - | - | - | S100863 | 16TH AVE: LINCOLN WAY | - | F | F | - | F | 27361000 | 27361000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 892 | 892 | 37.76559292 | -122.47404532 | 16TH AVE \ LINCOLN WAY | 16TH AVE \ LINCOLN WAY | 1711141396000 | middleware_editor | STOP | LINCOLN WAY intersection | - | 0 / 0 | - | - | - | - | - | 43041 | -402105600000 | -122.47404532 | 37.76559292 | - | 847843200000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566560000 | 16TH AVE | - | - | - | - | - | - |
| 25963 | N/A | Point | - | - | - | - | S100864 | 10TH AVE: BALBOA ST | - | F | F | - | F | 27293000 | 27293000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 10TH AVE | BALBOA ST | 893 | 893 | 37.77703901 | -122.46829259 | BALBOA ST \ 10TH AVE | 10TH AVE \ BALBOA ST | 1733841120000 | middleware_editor | STOP | BALBOA ST intersection | - | 0 / 0 | - | - | - | - | - | 43042 | -402102000000 | -122.46829259 | 37.77703901 | - | 1733483040000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | 10TH AVE | - | - | - | - | - | - |
| 25964 | N/A | Point | - | - | - | - | S100865 | 10TH AVE: BALBOA ST | - | F | F | - | F | 27293000 | 27293000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 10TH AVE | BALBOA ST | 894 | 894 | 37.77703901 | -122.46829259 | BALBOA ST \ 10TH AVE | 10TH AVE \ BALBOA ST | 1733867625000 | middleware_editor | STOP | BALBOA ST intersection | - | 0 / 0 | - | - | - | - | - | 43043 | -402102000000 | -122.46829259 | 37.77703901 | - | 1733829240000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | 10TH AVE | - | - | - | - | - | - |
| 25965 | N/A | Point | - | - | - | - | S100866 | 11TH AVE: BALBOA ST | - | F | F | - | F | 27294000 | 27294000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | 11TH AVE | 895 | 895 | 37.77699033 | -122.46936101 | 11TH AVE \ BALBOA ST | BALBOA ST \ 11TH AVE | 1733841128000 | middleware_editor | STOP | 11TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43044 | -402102000000 | -122.46936101 | 37.77699033 | - | 1733483940000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373566560000 | BALBOA ST | - | - | - | - | - | - |
| 25966 | N/A | Point | - | - | - | - | S100867 | 11TH AVE: BALBOA ST | - | F | F | - | F | 27294000 | 27294000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | 11TH AVE | 896 | 896 | 37.77699033 | -122.46936101 | 11TH AVE \ BALBOA ST | BALBOA ST \ 11TH AVE | 1733841131000 | middleware_editor | STOP | 11TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43045 | -402102000000 | -122.46936101 | 37.77699033 | - | 1733484120000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | BALBOA ST | - | - | - | - | - | - |
| 25967 | N/A | Point | - | - | - | - | S104112 | 39TH AVE: VICENTE ST | - | F | F | - | F | 23435000 | 23435000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 39TH AVE | VICENTE ST | 898 | 898 | 37.7383795 | -122.49685477 | VICENTE ST \ 39TH AVE | 39TH AVE \ VICENTE ST | 1710539427000 | MTA | STOP | VICENTE ST intersection | - | 0 / 00 | - | - | - | - | - | 43046 | -46224000000 | -122.49685477 | 37.7383795 | - | 1489536000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568840000 | 39TH AVE | - | - | - | - | - | - |
| 25968 | N/A | Point | - | - | - | - | S104113 | 39TH AVE: VICENTE ST | - | F | F | - | F | 23435000 | 23435000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 39TH AVE | VICENTE ST | 899 | 899 | 37.7383795 | -122.49685477 | VICENTE ST \ 39TH AVE | 39TH AVE \ VICENTE ST | 1710539427000 | MTA | STOP | VICENTE ST intersection | - | 0 / 00 | - | - | - | - | - | 43047 | -46224000000 | -122.49685477 | 37.7383795 | - | 1489536000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568840000 | 39TH AVE | - | - | - | - | - | - |
| 25969 | N/A | Point | - | - | - | - | S104123 | 26TH ST: NOE ST | - | F | F | - | F | 22020000 | 22020000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | NOE ST | 26TH ST | 904 | 904 | 37.74822948 | -122.43155665 | 26TH ST \ NOE ST | NOE ST \ 26TH ST | 1717635691000 | middleware_editor | STOP | 26TH ST intersection | - | 00 / 00 | - | - | - | - | - | 43048 | -45964800000 | -122.43155665 | 37.74822948 | - | 1531353600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568840000 | NOE ST | - | - | - | - | - | - |
| 25970 | N/A | Point | - | - | - | - | S105868 | ULLOA ST: 46TH AVE | - | F | F | - | F | 23499000 | 23499000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 46TH AVE | ULLOA ST | 1711 | 1711 | 37.73990658 | -122.50448974 | ULLOA ST \ 46TH AVE | 46TH AVE \ ULLOA ST | 1710539427000 | MTA | STOP | ULLOA ST intersection | - | 0 / 0 | - | - | - | - | - | 43049 | 105321600000 | -122.50448974 | 37.73990658 | - | 1512950400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569380000 | 46TH AVE | - | - | - | - | - | - |
| 25971 | N/A | Point | - | - | - | - | S105869 | ULLOA ST: 46TH AVE | - | F | F | - | F | 23499000 | 23499000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 46TH AVE | ULLOA ST | 1712 | 1712 | 37.73990658 | -122.50448974 | ULLOA ST \ 46TH AVE | 46TH AVE \ ULLOA ST | 1710539427000 | MTA | STOP | ULLOA ST intersection | - | 0 / 0 | - | - | - | - | - | 43050 | 105321600000 | -122.50448974 | 37.73990658 | - | 1508112000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569380000 | 46TH AVE | - | - | - | - | - | - |
| 25972 | N/A | Point | - | - | - | - | S105870 | ORIZABA AVE: RANDOLPH ST | - | F | F | - | F | 22497000 | 22497000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ORIZABA AVE | RANDOLPH ST | 1713 | 1713 | 37.71430765 | -122.46260204 | RANDOLPH ST \ ORIZABA AVE | ORIZABA AVE \ RANDOLPH ST | 1740504918000 | middleware_editor | STOP | RANDOLPH ST intersection | - | 0 / 0 | - | - | - | - | - | 43051 | 105321600000 | -122.46260204 | 37.71430765 | - | 1667952000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569380000 | ORIZABA AVE | - | - | - | - | - | - |
| 25973 | N/A | Point | - | - | - | - | S105871 | RALSTON ST: RANDOLPH ST | - | F | F | - | F | 22544000 | 22544000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | RALSTON ST | RALSTON ST | 1714 | 1714 | 37.71425618 | -122.46889627 | RANDOLPH ST \ RALSTON ST | RANDOLPH ST \ RALSTON ST | 1710539427000 | MTA | STOP | RALSTON ST intersection | - | 0 / 0 | - | - | - | - | - | 43052 | 105580800000 | -122.46889627 | 37.71425618 | - | 1455580800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569380000 | RANDOLPH ST | - | - | - | - | - | - |
| 25974 | N/A | Point | - | - | - | - | S105873 | TAYLOR ST: WASHINGTON ST | - | F | F | - | F | 25120000 | 25120000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 1715 | 1715 | 37.7943206 | -122.41301108 | TAYLOR ST \ WASHINGTON ST | TAYLOR ST \ WASHINGTON ST | 1711130054000 | middleware_editor | STOP | WASHINGTON ST intersection | - | 0 / 0 | - | - | - | - | - | 43053 | 105580800000 | -122.41301108 | 37.7943206 | - | 781401600000 | 1711104780000 | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | RETD | 1373569380000 | TAYLOR ST | - | - | - | - | - | - |
| 25975 | N/A | Point | - | - | - | - | S105874 | 19TH AVE: BYXBEE ST \ RANDOLPH | - | F | F | - | F | 22543000 | 22543000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 19TH AVE \ BYXBEE ST | 19TH AVE \ BYXBEE ST | 1716 | 1716 | 37.71428168 | -122.46979824 | RANDOLPH ST \ 19TH AVE \ BYXBEE ST | RANDOLPH ST \ 19TH AVE \ BYXBEE ST | 1710539427000 | MTA | STOP | 19TH AVE \ BYXBEE ST intersection | - | 0 / 0 | - | - | - | - | - | 43054 | 105580800000 | -122.46979824 | 37.71428168 | - | 1548892800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569380000 | RANDOLPH ST | - | - | - | - | - | - |
| 25976 | N/A | Point | - | - | - | - | S105875 | RALSTON ST: RANDOLPH ST | - | F | F | - | F | 22544000 | 22544000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RALSTON ST | RALSTON ST | 1717 | 1717 | 37.71425618 | -122.46889627 | RANDOLPH ST \ RALSTON ST | RANDOLPH ST \ RALSTON ST | 1710539427000 | MTA | STOP | RALSTON ST intersection | - | 0 / 0 | - | - | - | - | - | 43055 | 105580800000 | -122.46889627 | 37.71425618 | - | 1253491200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569380000 | RANDOLPH ST | - | - | - | - | - | - |
| 25977 | N/A | Point | - | - | - | - | S105876 | ORIZABA AVE: BROAD ST | - | F | F | - | F | 22494000 | 22494000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ORIZABA AVE | BROAD ST | 1718 | 1718 | 37.71315017 | -122.462569 | BROAD ST \ ORIZABA AVE | ORIZABA AVE \ BROAD ST | 1753717786000 | middleware_editor | STOP | BROAD ST intersection | - | 0 / 0 | - | - | - | - | - | 43056 | 105606000000 | -122.462569 | 37.71315017 | - | 1753468620000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569380000 | ORIZABA AVE | - | - | - | - | - | - |
| 25978 | N/A | Point | - | - | - | - | S105877 | VERNON ST: RANDOLPH ST | - | F | F | - | F | 22539000 | 22539000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RANDOLPH ST | VERNON ST | 1719 | 1719 | 37.71426625 | -122.46799614 | VERNON ST \ RANDOLPH ST | RANDOLPH ST \ VERNON ST | 1710539427000 | MTA | STOP | VERNON ST intersection | - | 0 / 0 | - | - | - | - | - | 43057 | 105753600000 | -122.46799614 | 37.71426625 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569380000 | RANDOLPH ST | - | - | - | - | - | - |
| 25979 | N/A | Point | - | - | - | - | S105736 | MISSION ST: 7TH ST | - | F | F | - | F | 24315000 | 24315000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 7TH ST | 07TH ST | 1720 | 1720 | 37.77921169 | -122.41093657 | MISSION ST \ 7TH ST | MISSION ST \ 07TH ST | 1752850109000 | middleware_editor | NO LEFT TURN (SYM) | 07TH ST intersection | - | 0 / 0 | - | - | - | - | - | 43058 | 100166400000 | -122.41093657 | 37.77921169 | - | - | 1752850020000 | D6 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | LIGHT POLE | RETD | 1373569320000 | MISSION ST | - | - | - | - | - | - |
| 25980 | N/A | Point | - | - | - | - | S105742 | OFARRELL ST: SAINT JOSEPHS AVE | - | F | F | - | F | 26812000 | 26812000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SAINT JOSEPHS AVE | SAINT JOSEPHS AVE | 1721 | 1721 | 37.78223395 | -122.44167164 | OFARRELL ST \ SAINT JOSEPHS AVE | OFARRELL ST \ SAINT JOSEPHS AVE | 1710539427000 | MTA | DO NOT ENTER | SAINT JOSEPHS AVE intersection | - | 0 / ADDITIONAL SIGN | - | - | - | - | - | 43059 | 100224000000 | -122.44167164 | 37.78223395 | - | - | - | D2 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1373569320000 | OFARRELL ST | - | - | - | - | - | - |
| 25981 | N/A | Point | - | - | - | - | S105743 | GOUGH ST: ELLIS ST | - | F | F | - | F | 26492000 | 26492000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ELLIS ST | GOUGH ST | 1722 | 1722 | 37.78339986 | -122.42429481 | GOUGH ST \ ELLIS ST | ELLIS ST \ GOUGH ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | GOUGH ST intersection | - | 0 / MADE ELLIS 1-WAY WB BET MARKET ..... | - | - | - | - | - | 43060 | 100310400000 | -122.42429481 | 37.78339986 | - | - | - | D5 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | LIGHT POLE | IS | 1373569320000 | ELLIS ST | - | - | - | - | - | - |
| 25982 | N/A | Point | - | - | - | - | S105757 | ELLIS ST: VAN NESS AVE | - | F | F | - | F | 25190000 | 25190000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 1734 | 1734 | 37.78382412 | -122.42100836 | VAN NESS AVE \ ELLIS ST | VAN NESS AVE \ ELLIS ST | 1710539427000 | MTA | ONE WAY (RA) | ELLIS ST intersection | - | 0 / MADE ELLIS ONE-WAY WB BETMARKET..... | - | - | - | - | - | 43061 | 100310400000 | -122.42100836 | 37.78382412 | - | - | - | D5 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | MUNI POLE | IS | 1373569320000 | VAN NESS AVE | - | - | - | - | - | - |
| 25983 | N/A | Point | - | - | - | - | S105759 | KIRKHAM ST: 24TH AVE | - | F | F | - | F | 27413000 | 27413000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 24TH AVE | 24TH AVE | 1735 | 1735 | 37.75959572 | -122.48222116 | KIRKHAM ST \ 24TH AVE | KIRKHAM ST \ 24TH AVE | 1710539427000 | MTA | STOP | 24TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 43062 | 100742400000 | -122.48222116 | 37.75959572 | - | 1510185600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569320000 | KIRKHAM ST | - | - | - | - | - | - |
| 25984 | N/A | Point | - | - | - | - | S105661 | OCTAVIA ST: PACIFIC AVE | - | F | F | - | F | 26570000 | 26570000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | PACIFIC AVE | 1927 | 1927 | 37.7941874 | -122.42815905 | PACIFIC AVE \ OCTAVIA ST | OCTAVIA ST \ PACIFIC AVE | 1710539427000 | MTA | STOP | PACIFIC AVE intersection | - | 0 / 0 | - | - | - | - | - | 43063 | 93225600000 | -122.42815905 | 37.7941874 | - | 1556668800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569320000 | OCTAVIA ST | - | - | - | - | - | - |
| 25985 | N/A | Point | - | - | - | - | S105662 | OCTAVIA ST: PACIFIC AVE | - | F | F | - | F | 26570000 | 26570000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | PACIFIC AVE | 1928 | 1928 | 37.7941874 | -122.42815905 | PACIFIC AVE \ OCTAVIA ST | OCTAVIA ST \ PACIFIC AVE | 1710539427000 | MTA | STOP | PACIFIC AVE intersection | - | 0 / 0 | - | - | - | - | - | 43064 | 93225600000 | -122.42815905 | 37.7941874 | - | 1556668800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569320000 | OCTAVIA ST | - | - | - | - | - | - |
| 25986 | N/A | Point | - | - | - | - | S105668 | HEARST AVE: CONGO ST | - | F | F | - | F | 22139000 | 22139000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HEARST AVE | CONGO ST | 1932 | 1932 | 37.73072177 | -122.44201566 | CONGO ST \ HEARST AVE | HEARST AVE \ CONGO ST | 1710539427000 | MTA | STOP | CONGO ST intersection | - | 0 / 0 | - | - | - | - | - | 43065 | 94780800000 | -122.44201566 | 37.73072177 | - | 1553212800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569320000 | HEARST AVE | - | - | - | - | - | - |
| 25987 | N/A | Point | - | - | - | - | S105670 | LOWELL ST: MORSE ST | - | F | F | - | F | 21501000 | 21501000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MORSE ST | LOWELL ST | 1933 | 1933 | 37.71103928 | -122.44616814 | LOWELL ST \ MORSE ST | MORSE ST \ LOWELL ST | 1710539427000 | MTA | STOP | LOWELL ST intersection | - | 0 / 0 | - | - | - | - | - | 43066 | 94867200000 | -122.44616814 | 37.71103928 | - | 933033600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | MUNI POLE | IS | 1373569320000 | MORSE ST | - | - | - | - | - | - |
| 25988 | N/A | Point | - | - | - | - | S105791 | RANKIN ST: PALOU AVE | - | F | F | - | F | 20749000 | 20749000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | RANKIN ST | PALOU AVE | 2463 | 2463 | 37.73821473 | -122.39837847 | PALOU AVE \ RANKIN ST | RANKIN ST \ PALOU AVE | 1753816785000 | middleware_editor | STOP | PALOU AVE intersection | - | 0 / 0 | - | - | - | - | - | 43067 | 102153600000 | -122.39837847 | 37.73821473 | - | 1453363200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569320000 | RANKIN ST | - | - | - | - | - | - |
| 25989 | N/A | Point | - | - | - | - | S105794 | SOUTHWOOD DR: MIRAMAR AVE | - | F | F | - | F | 22630000 | 22630000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MIRAMAR AVE | MIRAMAR AVE | 2466 | 2466 | 37.72507223 | -122.45819376 | SOUTHWOOD DR \ MIRAMAR AVE | SOUTHWOOD DR \ MIRAMAR AVE | 1710539427000 | MTA | STOP | MIRAMAR AVE intersection | - | - | - | - | - | - | - | 43068 | 102211200000 | -122.45819376 | 37.72507223 | - | - | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569320000 | SOUTHWOOD DR | - | - | - | - | - | - |
| 25990 | N/A | Point | - | - | - | - | S105798 | BRIGHT ST: RANDOLPH ST | - | F | F | - | F | 22496000 | 22496000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | RANDOLPH ST | BRIGHT ST | 2467 | 2467 | 37.71430078 | -122.4634997 | BRIGHT ST \ RANDOLPH ST | RANDOLPH ST \ BRIGHT ST | 1710539427000 | MTA | STOP | BRIGHT ST intersection | - | 0 / 00 | - | - | - | - | - | 43069 | 102902400000 | -122.4634997 | 37.71430078 | - | 904003200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569320000 | RANDOLPH ST | - | - | - | - | - | - |
| 25991 | N/A | Point | - | - | - | - | S105799 | JERSEY ST: CHURCH ST | - | F | F | - | F | 25638000 | 25638000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | JERSEY ST | CHURCH ST | 2468 | 2468 | 37.7508959 | -122.42735464 | CHURCH ST \ JERSEY ST | JERSEY ST \ CHURCH ST | 1713976621000 | middleware_editor | STOP | CHURCH ST intersection | - | 0 / 00 | - | - | - | - | - | 43070 | 102902400000 | -122.42735464 | 37.7508959 | - | 1182988800000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569320000 | JERSEY ST | - | - | - | - | - | - |
| 25992 | N/A | Point | - | - | - | - | S105800 | JERSEY ST: CHURCH ST | - | F | F | - | F | 25638000 | 25638000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JERSEY ST | CHURCH ST | 2469 | 2469 | 37.7508959 | -122.42735464 | CHURCH ST \ JERSEY ST | JERSEY ST \ CHURCH ST | 1713976633000 | middleware_editor | STOP | CHURCH ST intersection | - | 0 / 00 | - | - | - | - | - | 43071 | 102902400000 | -122.42735464 | 37.7508959 | - | 1140134400000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569320000 | JERSEY ST | - | - | - | - | - | - |
| 25993 | N/A | Point | - | - | - | - | S105801 | ELIZABETH ST: CHURCH ST | - | F | F | - | F | 25640000 | 25640000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ELIZABETH ST | CHURCH ST | 2470 | 2470 | 37.75244983 | -122.42750332 | CHURCH ST \ ELIZABETH ST | ELIZABETH ST \ CHURCH ST | 1710539427000 | MTA | STOP | CHURCH ST intersection | - | 0 / 0 | - | - | - | - | - | 43072 | 102902400000 | -122.42750332 | 37.75244983 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569320000 | ELIZABETH ST | - | - | - | - | - | - |
| 25994 | N/A | Point | - | - | - | - | S105802 | DUNCAN ST: CHURCH ST | - | F | F | - | F | 21899000 | 21899000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CHURCH ST | CHURCH ST | 2471 | 2471 | 37.74616692903 | -122.426768635871 | DUNCAN ST \ CHURCH ST | DUNCAN ST \ CHURCH ST | 1745448938000 | middleware_editor | STOP | CHURCH ST intersection | 119937527 | FROM UP TO 2INCH | - | - | - | - | - | 43073 | 103190400000 | -122.42689119 | 37.74609877 | - | 1745435700000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373569320000 | DUNCAN ST | - | - | - | - | - | - |
| 25995 | N/A | Point | - | - | - | - | S105804 | CUTLER AVE: 47TH AVE | - | F | F | - | F | 23494000 | 23494000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CUTLER AVE | CUTLER AVE | 2473 | 2473 | 37.73706786 | -122.50536251 | 47TH AVE \ CUTLER AVE | 47TH AVE \ CUTLER AVE | 1737125153000 | middleware_editor | STOP | CUTLER AVE intersection | - | 0 / 0 | - | - | - | - | - | 43074 | 103251600000 | -122.50536251 | 37.73706786 | - | 1431475200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569320000 | 47TH AVE | - | - | - | - | - | - |
| 25996 | N/A | Point | - | - | - | - | S105806 | FILLMORE ST: DUBOCE AVE | - | F | F | - | F | 25893000 | 25893000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 2474 | 2474 | 37.76940792 | -122.42990564 | FILLMORE ST \ DUBOCE AVE | FILLMORE ST \ DUBOCE AVE | 1710539427000 | MTA | STOP | DUBOCE AVE intersection | - | 0 / 0 | - | - | - | - | - | 43075 | 103420800000 | -122.42990564 | 37.76940792 | - | 1341273600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569320000 | FILLMORE ST | - | - | - | - | - | - |
| 25997 | N/A | Point | - | - | - | - | S105807 | BELCHER ST: DUBOCE AVE | - | F | F | - | F | 25892000 | 25892000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 2475 | 2475 | 37.76939226 | -122.43024736 | BELCHER ST \ DUBOCE AVE | BELCHER ST \ DUBOCE AVE | 1710539427000 | MTA | STOP | DUBOCE AVE intersection | - | 0 / 00 | - | - | - | - | - | 43076 | 103420800000 | -122.43024736 | 37.76939226 | - | 1575504000000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569320000 | BELCHER ST | - | - | - | - | - | - |
| 25998 | N/A | Point | - | - | - | - | S105808 | HILLWAY AVE: CARL ST | - | F | F | - | F | 27061000 | 27061000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CARL ST | CARL ST | 2476 | 2476 | 37.76493246 | -122.45675901 | HILLWAY AVE \ CARL ST | HILLWAY AVE \ CARL ST | 1710539427000 | MTA | STOP | CARL ST intersection | - | 0 / 0 | - | - | - | - | - | 43077 | 103852800000 | -122.45675901 | 37.76493246 | - | 629078400000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569320000 | HILLWAY AVE | - | - | - | - | - | - |
| 25999 | N/A | Point | - | - | - | - | S105173 | 26TH AVE: ANZA ST | - | F | F | - | F | 27548000 | 27548000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ANZA ST | ANZA ST | 2482 | 2482 | 37.7780216497736 | -122.485595270986 | 26TH AVE \ ANZA ST | 26TH AVE \ ANZA ST | 1752780212000 | middleware_editor | STOP | ANZA ST intersection | - | 0 / 0 | - | - | - | - | - | 43078 | 57394800000 | -122.4856674 | 37.77811725 | - | 1638345600000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1373569140000 | 26TH AVE | - | - | - | - | - | - |
| 26000 | N/A | Point | - | - | - | - | S105177 | LAGUNA ST: FELL ST | - | F | F | - | F | 25913000 | 25913000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FELL ST | FELL ST | 2486 | 2486 | 37.77552455 | -122.42607032 | LAGUNA ST \ FELL ST | LAGUNA ST \ FELL ST | 1710539427000 | MTA | DO NOT ENTER | FELL ST intersection | - | 0 / 00 | - | - | - | - | - | 43079 | 57369600000 | -122.42607032 | 37.77552455 | - | - | - | D5 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373569140000 | LAGUNA ST | - | - | - | - | - | - |
| 26001 | N/A | Point | - | - | - | - | S231262 | GENNESSEE ST: JUDSON AVE | - | F | F | - | F | - | 22235000 | - | SHOULD BE RETIRED | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | - | GENNESSEE ST | 89680 | 89680 | 37.72835755 | -122.45111256 | - | JUDSON AVE \ GENNESSEE ST | 1746135205000 | middleware_editor | ALL WAY | GENNESSEE ST intersection | - | - | - | - | - | - | - | 43080 | 300438000000 | -122.45111256 | 37.72835755 | - | 1486540800000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | RETD | 1479819060000 | JUDSON AVE | - | - | - | - | - | - |
| 26002 | N/A | Point | 1 | 1 | 1 - 90 | - | S253317 | 1-90 TEHAMA ST | 1-90 TEHAMA ST | F | F | - | F | 12471000 | 12471000 | - | - | SOUTH SIDE | - | - | - | - | 1ST ST | 01ST ST | 89681 | 89681 | 37.78734299 | -122.39642922 | - | - | 1710539427000 | MTA | TANP ANY TIME | 01ST ST to MALDEN ALY (1 - 90) | - | 248' WEST OF 1ST ST. | - | - | - | - | - | 43081 | 1007424000000 | -122.39642922 | 37.78734299 | - | 1554768000000 | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | LIGHT POLE | IS | 1554721200000 | TEHAMA ST | 1 - 90 TEHAMA ST | 1 - 90 TEHAMA ST | 1 TEHAMA ST | - | MALDEN ALY | MALDEN ALY |
| 26003 | N/A | Point | 1 | 1 | 880 - 899 | - | S253327 | 880-899 BRYANT ST | 880-899 BRYANT ST | F | F | - | F | 3292000 | 3292000 | - | - | NORTH SIDE | - | - | - | - | JEFF ADACHI WAY | JEFF ADACHI WAY | 89682 | 89682 | 37.77449242 | -122.40448109 | - | - | 1710539427000 | MTA | TANS EXCEPT PERMITTED HSOC VEHICLES | JEFF ADACHI WAY to 07TH ST (880 - 899) | - | 38' EAST OF 7TH ST | - | - | - | - | - | 43082 | 1507766400000 | -122.40448109 | 37.77449242 | - | 1555459200000 | - | D6 | - | OTHER REGULATORY | REG | R37(SF).0378 | 18X21 | SUP1 | LIGHT POLE | IS | 1554724680000 | BRYANT ST | 880 - 899 BRYANT ST | 880 - 899 BRYANT ST | 880 BRYANT ST | - | 07TH ST | 07TH ST |
| 26004 | N/A | Point | 1 | 1 | 880 - 899 | - | S253328 | 880-899 BRYANT ST | 880-899 BRYANT ST | F | F | - | F | 3292000 | 3292000 | - | - | NORTH SIDE | - | - | - | - | JEFF ADACHI WAY | JEFF ADACHI WAY | 89683 | 89683 | 37.77449242 | -122.40448109 | - | - | 1710539427000 | MTA | TANS EXCEPT PERMITTED HSOC VEHICLES | JEFF ADACHI WAY to 07TH ST (880 - 899) | - | 98' EAST OF 7TH ST | - | - | - | - | - | 43083 | 1507766400000 | -122.40448109 | 37.77449242 | - | 1555459200000 | - | D6 | - | OTHER REGULATORY | REG | R37(SF).0378 | 18X21 | SUP1 | 2IN IRON POST | IS | 1554725340000 | BRYANT ST | 880 - 899 BRYANT ST | 880 - 899 BRYANT ST | 880 BRYANT ST | - | 07TH ST | 07TH ST |
| 26005 | N/A | Point | 1 | 1 | 880 - 899 | - | S253329 | 880-899 BRYANT ST | 880-899 BRYANT ST | F | F | - | F | 3292000 | 3292000 | - | - | NORTH SIDE | - | - | - | - | JEFF ADACHI WAY | JEFF ADACHI WAY | 89684 | 89684 | 37.77449242 | -122.40448109 | - | - | 1710539427000 | MTA | TANS EXCEPT PERMITTED HSOC VEHICLES | JEFF ADACHI WAY to 07TH ST (880 - 899) | - | 148' EAST OF 7TH ST | - | - | - | - | - | 43084 | 1507852800000 | -122.40448109 | 37.77449242 | - | 1555459200000 | - | D6 | - | OTHER REGULATORY | REG | R37(SF).0378 | 18X21 | SUP1 | LIGHT POLE | IS | 1554725640000 | BRYANT ST | 880 - 899 BRYANT ST | 880 - 899 BRYANT ST | 880 BRYANT ST | - | 07TH ST | 07TH ST |
| 26006 | N/A | Point | - | - | - | - | S251193 | POTRERO AVE: 22ND ST | - | F | F | - | F | 23964000 | 23964000 | - | - | SOUTH WEST CORNER | - | - | - | - | 22ND ST | POTRERO AVE | 89692 | 89692 | 37.75616698 | -122.4066358 | POTRERO AVE \ 22ND ST | 22ND ST \ POTRERO AVE | 1716920356000 | middleware_editor | 22ND ST | POTRERO AVE intersection | - | (NORTHERN INTERSECTION) | - | - | - | - | - | 43085 | 1119830400000 | -122.4066358 | 37.75616698 | - | 1555891200000 | - | D9 | - | STREET NAME | GUIDE | D3-1.0015 | 36X08 | SUP2 | SIGNAL POLE | IS | 1548848460000 | 22ND ST | - | - | - | - | - | - |
| 26007 | N/A | Point | - | - | - | - | S251194 | POTRERO AVE: 22ND ST | - | T | T | - | F | 23964000 | 23964000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 22ND ST | POTRERO AVE | 89693 | 89693 | 37.75616698 | -122.4066358 | POTRERO AVE \ 22ND ST | 22ND ST \ POTRERO AVE | 1716920393000 | middleware_editor | 22ND ST | POTRERO AVE intersection | - | (NORTHERN INTERSECTION) | - | - | - | - | - | 43086 | 1119830400000 | -122.4066358 | 37.75616698 | - | 1598313600000 | - | D9 | - | STREET NAME | GUIDE | D3-2.0026 | 72X18 | SUP2 | SIGNAL POLE | IS | 1548848640000 | 22ND ST | - | - | - | - | - | - |
| 26008 | N/A | Point | - | - | - | - | S217255 | TARAVAL ST: 19TH AVE | - | T | T | - | F | 23183000 | 23183000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 19TH AVE | 89694 | 89694 | 37.74305181 | -122.47564447 | 19TH AVE \ TARAVAL ST | TARAVAL ST \ 19TH AVE | 1722962985000 | middleware_editor | NO LEFT TURN (SYM) | 19TH AVE intersection | - | 2OF4 | - | - | - | - | - | 43087 | 1435228920000 | -122.47564447 | 37.74305181 | - | 1435190400000 | - | D4 | - | NO LEFT TURN | REG | R3-2.0003 | 36X36 | SUP2 | MUNI POLE | IS | 1434717360000 | TARAVAL ST | - | - | - | - | - | - |
| 26009 | N/A | Point | - | - | - | - | S217695 | CHINA BASIN ST: MERRIMAC ST | - | F | F | - | F | 34181000 | 34181000 | - | - | NORTH SIDE | - | - | - | - | CHINA BASIN ST | CHINA BASIN ST | 89695 | 89695 | 37.77179715 | -122.3929445 | MERRIMAC ST \ CHINA BASIN ST | MERRIMAC ST \ CHINA BASIN ST | 1710539427000 | MTA | CHINA BASIN ST | CHINA BASIN ST intersection | - | OPP. SEC | - | - | - | - | - | 43088 | 1436536500000 | -122.3929445 | 37.77179715 | - | 1436486400000 | - | D6 | - | STREET NAME | GUIDE | D3-1.0375 | 36X08 | SUP1 | LIGHT POLE | IS | 1436277720000 | MERRIMAC ST | - | - | - | - | - | - |
| 26010 | N/A | Point | 1 | 1 | 1200 - 1248 | - | S217636 | 1200-1248 5TH AVE | 1200-1248 05TH AVE | F | F | - | F | 284000 | 284000 | - | - | EAST SIDE | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 89696 | 89696 | 37.76563584 | -122.46212903 | - | - | 1710539427000 | MTA | GETAROUND | LINCOLN WAY to HUGO ST (1200 - 1248) | - | 16' NORTH OF HUGO | - | - | - | - | - | 43089 | 1436434440000 | -122.46212903 | 37.76563584 | - | 1436400000000 | - | D5 | - | OTHER GUIDE | GUIDE | G-G(SF).0037 | 05X12 | SUP1 | 2IN IRON POST | IS | 1436181540000 | 05TH AVE | 1200 - 1248 5TH AVE | 1200 - 1248 05TH AVE | 1200 5TH AVE | - | HUGO ST | HUGO ST |
| 26011 | N/A | Point | 1 | 1 | 2400 - 2499 | - | S217731 | 2400-2499 GOUGH ST | 2400-2499 GOUGH ST | F | F | - | F | 6344000 | 6344000 | - | - | EAST SIDE | - | - | - | - | BROADWAY | BROADWAY | 89697 | 89697 | 37.79579426 | -122.42679617 | - | - | 1731962020000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "KG" PERMITS | BROADWAY to VALLEJO ST (2400 - 2499) | - | NPL #2412 | - | - | - | - | - | 43090 | 1219881600000 | -122.42679617 | 37.79579426 | - | 1436832000000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0093 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1436357880000 | GOUGH ST | 2400 - 2499 GOUGH ST | 2400 - 2499 GOUGH ST | 2400 GOUGH ST | - | VALLEJO ST | VALLEJO ST |
| 26012 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S216388 | 1500-1599 HAYES ST | 1500-1599 HAYES ST | F | F | - | F | 6827000 | 6827000 | - | - | SOUTH SIDE | - | - | - | - | BAKER ST | BAKER ST | 89698 | 89698 | 37.77446316 | -122.44193264 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "Q" PERMITS | BAKER ST to LYON ST (1500 - 1599) | - | OPP #1530 | - | - | - | - | - | 43091 | 1439047440000 | -122.44193264 | 37.77446316 | - | 1438992000000 | - | D5 | - | PARKING:RPP | REG | R32C(CA).0215 | 18X21 | SUP1 | MUNI POLE | IS | 1432205520000 | HAYES ST | 1500 - 1599 HAYES ST | 1500 - 1599 HAYES ST | 1500 HAYES ST | - | LYON ST | LYON ST |
| 26013 | N/A | Point | - | 1 | 101 - 199 | - | S283463 | 101 - 199 THE EMBARCADERO | 101-199 THE EMBARCADERO | F | F | - | F | 12553103 | 12553103 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | DON CHEE WAY | DON CHEE WAY | 89700 | 89700 | 37.79537677 | -122.39451599 | - | - | 1710539427000 | MTA | BIKE WAYFINDING SIGN | DON CHEE WAY to WASHINGTON ST (101 - 199) -- WEST -- | 1607 | POLE #16 | - | - | - | - | - | 43092 | 1657756800000 | -122.39451599 | 37.79537677 | - | - | - | D3 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | LIGHT POLE | IS | 1655292240000 | THE EMBARCADERO | 101 - 199 THE EMBARCADERO | 101 - 199 THE EMBARCADERO | 101 THE EMBARCADERO | - | WASHINGTON ST | WASHINGTON ST |
| 26014 | N/A | Point | - | 1 | 101 - 199 | - | S283464 | 101 - 199 THE EMBARCADERO | 101-199 THE EMBARCADERO | F | F | - | F | 12553103 | 12553103 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | DON CHEE WAY | DON CHEE WAY | 89701 | 89701 | 37.79537677 | -122.39451599 | - | - | 1710539427000 | MTA | WHEELCHAIR-PED YIELD (SYM) YIELD TO PEDESTRIANS | DON CHEE WAY to WASHINGTON ST (101 - 199) -- WEST -- | - | POLE #12 | - | - | - | - | - | 43093 | 1657756800000 | -122.39451599 | 37.79537677 | - | - | - | D3 | - | PEDESTRIAN | GUIDE | G-Y(SF).0002 | 24X24 | SUP1 | LIGHT POLE | IS | 1655292540000 | THE EMBARCADERO | 101 - 199 THE EMBARCADERO | 101 - 199 THE EMBARCADERO | 101 THE EMBARCADERO | - | WASHINGTON ST | WASHINGTON ST |
| 26015 | N/A | Point | 1 | 1 | 300 - 399 | - | S270304 | PNDG GEARY BLVD | 300-399 SAINT JOSEPHS AVE | F | F | - | F | 11309000 | 11309000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | OFARRELL ST | OFARRELL ST | 89702 | 89702 | 37.7825142 | -122.44230251 | - | - | 1710539427000 | MTA | SENIOR ZONE | OFARRELL ST to BAKER ST \ GEARY BLVD (300 - 399) | - | 140FT EAST OF LYON | - | - | - | - | - | 43094 | 1606312260000 | -122.44230251 | 37.7825142 | - | - | - | D2 | - | OTHER WARNING | WARNING | SW50(CA).0001 | 24X18 | SUP1 | 2IN IRON POST | IS | 1605870000000 | SAINT JOSEPHS AVE | PNDG GEARY BLVD | 300 - 399 SAINT JOSEPHS AVE | - | - | BAKER ST \ GEARY BLVD | BAKER ST \ GEARY BLVD |
| 26016 | N/A | Point | - | - | - | - | S104124 | 26TH ST: NOE ST | - | F | F | - | F | 22020000 | 22020000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | NOE ST | 26TH ST | 905 | 905 | 37.74822948 | -122.43155665 | 26TH ST \ NOE ST | NOE ST \ 26TH ST | 1717599462000 | middleware_editor | STOP | 26TH ST intersection | - | 00 / 00 | - | - | - | - | - | 43095 | -45964800000 | -122.43155665 | 37.74822948 | - | 1531353600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568840000 | NOE ST | - | - | - | - | - | - |
| 26017 | N/A | Point | - | - | - | - | S104125 | SHANNON ST: OFARRELL ST | - | F | F | - | F | 24944000 | 24944000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SHANNON ST | SHANNON ST | 906 | 906 | 37.78589293 | -122.41214751 | OFARRELL ST \ SHANNON ST | OFARRELL ST \ SHANNON ST | 1710539427000 | MTA | DO NOT ENTER | SHANNON ST intersection | - | 0 / 00 | - | - | - | - | - | 43096 | -45878400000 | -122.41214751 | 37.78589293 | - | - | - | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373568840000 | OFARRELL ST | - | - | - | - | - | - |
| 26018 | N/A | Point | - | - | - | - | S104126 | SHANNON ST: OFARRELL ST | - | F | F | - | F | 24944000 | 24944000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SHANNON ST | SHANNON ST | 907 | 907 | 37.78589293 | -122.41214751 | OFARRELL ST \ SHANNON ST | OFARRELL ST \ SHANNON ST | 1710539427000 | MTA | ONE WAY (RA) | SHANNON ST intersection | - | 0 / 0 | - | - | - | - | - | 43097 | -45878400000 | -122.41214751 | 37.78589293 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568840000 | OFARRELL ST | - | - | - | - | - | - |
| 26019 | N/A | Point | - | - | - | - | S104128 | PARIS ST: FRANCE AVE | - | F | F | - | F | 21730000 | 21730000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FRANCE AVE | FRANCE AVE | 908 | 908 | 37.71926881 | -122.43675633 | PARIS ST \ FRANCE AVE | PARIS ST \ FRANCE AVE | 1748551447000 | middleware_editor | DO NOT ENTER | FRANCE AVE intersection | - | 0 / MADE NORTHBOUND ONE WAY | - | - | - | - | - | 43098 | -45248400000 | -122.43675633 | 37.71926881 | - | - | - | D11 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP2 | UNKNOWN | IS | 1373568840000 | PARIS ST | - | - | - | - | - | - |
| 26020 | N/A | Point | - | - | - | - | S104129 | PARIS ST: FRANCE AVE | - | F | F | - | F | 21730000 | 21730000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FRANCE AVE | FRANCE AVE | 909 | 909 | 37.71926881 | -122.43675633 | PARIS ST \ FRANCE AVE | PARIS ST \ FRANCE AVE | 1748551300000 | middleware_editor | ONE WAY (LA) | FRANCE AVE intersection | - | 30N / 0 | - | - | - | - | - | 43099 | -45248400000 | -122.43675633 | 37.71926881 | - | - | - | D11 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | UNKNOWN | IS | 1373568840000 | PARIS ST | - | - | - | - | - | - |
| 26021 | N/A | Point | - | - | - | - | S104131 | PARIS ST: FRANCE AVE | - | F | F | - | F | 21730000 | 21730000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FRANCE AVE | FRANCE AVE | 911 | 911 | 37.71926881 | -122.43675633 | PARIS ST \ FRANCE AVE | PARIS ST \ FRANCE AVE | 1748550781000 | middleware_editor | ONE WAY (RA) | FRANCE AVE intersection | - | 30N / 0 | - | - | - | - | - | 43100 | -45248400000 | -122.43675633 | 37.71926881 | - | - | - | D11 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | UNKNOWN | IS | 1373568840000 | PARIS ST | - | - | - | - | - | - |
| 26022 | N/A | Point | - | - | - | - | S104133 | 26TH ST: CASTRO ST | - | F | F | - | F | 22024000 | 22024000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 26TH ST | CASTRO ST | 913 | 913 | 37.74809651 | -122.43376908 | CASTRO ST \ 26TH ST | 26TH ST \ CASTRO ST | 1756240931000 | middleware_editor | STOP | CASTRO ST intersection | - | 00 / 00 | - | - | - | - | - | 43101 | -44816400000 | -122.43376908 | 37.74809651 | - | 1756230000000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568840000 | 26TH ST | - | - | - | - | - | - |
| 26023 | N/A | Point | - | - | - | - | S104134 | 26TH ST: CASTRO ST | - | F | F | - | F | 22024000 | 22024000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 26TH ST | CASTRO ST | 914 | 914 | 37.74809651 | -122.43376908 | CASTRO ST \ 26TH ST | 26TH ST \ CASTRO ST | 1745415151000 | middleware_editor | STOP | CASTRO ST intersection | - | 00 / 00 | - | - | - | - | - | 43102 | -44816400000 | -122.43376908 | 37.74809651 | - | 916732800000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568840000 | 26TH ST | - | - | - | - | - | - |
| 26024 | N/A | Point | - | - | - | - | S104137 | CHILTON AVE: BOSWORTH ST | - | F | F | - | F | 21972000 | 21972000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BOSWORTH ST | CHILTON AVE | 916 | 916 | 37.73404017 | -122.43667289 | CHILTON AVE \ BOSWORTH ST | BOSWORTH ST \ CHILTON AVE | 1755205879000 | middleware_editor | STOP | CHILTON AVE intersection | - | 0 / 0 | - | - | - | - | - | 43103 | -44384400000 | -122.43667289 | 37.73404017 | - | 1755196200000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568840000 | BOSWORTH ST | - | - | - | - | - | - |
| 26025 | N/A | Point | - | - | - | - | S104139 | LYELL ST: CAYUGA AVE | - | F | F | - | F | 21784000 | 21784000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CAYUGA AVE | CAYUGA AVE | 917 | 917 | 37.7310095 | -122.43139297 | LYELL ST \ CAYUGA AVE | LYELL ST \ CAYUGA AVE | 1710539427000 | MTA | STOP | CAYUGA AVE intersection | - | 0 / 0 | - | - | - | - | - | 43104 | -44409600000 | -122.43139297 | 37.7310095 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568840000 | LYELL 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