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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6676 | N/A | Point | - | - | - | - | S247964 | FREMONT ST: MISSION ST | - | T | T | - | F | 24560000 | 24560000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MISSION ST | FREMONT ST | 76640 | 76640 | 37.79046107 | -122.39668969 | FREMONT ST \ MISSION ST | MISSION ST \ FREMONT ST | 1731964084000 | middleware_editor | DO NOT BLOCK INTERSECTION | FREMONT ST intersection | - | - | - | - | - | - | - | 23749 | - | -122.39668969 | 37.79046107 | - | - | - | D6 | - | OTHER REGULATORY | REG | R10-7.0002 | 30X42 | SUP1 | LIGHT POLE | IS | 1535195700000 | MISSION ST | - | - | - | - | - | - |
| 6677 | N/A | Point | - | - | - | - | S247965 | MISSION ST: FREMONT ST | - | F | F | - | F | 24560000 | 24560000 | - | - | SOUTH EAST CORNER | - | - | - | - | MISSION ST | FREMONT ST | 76641 | 76641 | 37.79046107 | -122.39668969 | FREMONT ST \ MISSION ST | MISSION ST \ FREMONT ST | 1728349484000 | middleware_editor | FREMONT ST | FREMONT ST intersection | - | - | - | - | - | - | - | 23750 | 1555428900000 | -122.39668969 | 37.79046107 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.0695 | 36X08 | SUP1 | LIGHT POLE | IS | 1535197260000 | MISSION ST | - | - | - | - | - | - |
| 6678 | N/A | Point | - | - | - | - | S247966 | MISSION ST: FREMONT ST | - | F | F | - | F | 24560000 | 24560000 | - | - | NORTH WEST CORNER | - | - | - | - | MISSION ST | FREMONT ST | 76642 | 76642 | 37.79046107 | -122.39668969 | FREMONT ST \ MISSION ST | MISSION ST \ FREMONT ST | 1728349488000 | middleware_editor | FREMONT ST | FREMONT ST intersection | - | - | - | - | - | - | - | 23751 | 1541761680000 | -122.39668969 | 37.79046107 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.0695 | 36X08 | SUP1 | SIGNAL POLE | IS | 1535197320000 | MISSION ST | - | - | - | - | - | - |
| 6679 | N/A | Point | - | - | - | - | S248509 | ULLOA ST: WEST PORTAL AVE | - | F | F | - | F | 22928000 | 22928000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ULLOA ST | ULLOA ST | 76653 | 76653 | 37.74089198 | -122.46582902 | WEST PORTAL AVE \ ULLOA ST | WEST PORTAL AVE \ ULLOA ST | 1727469751000 | middleware_editor | MUNI SIGNAL | ULLOA ST intersection | - | - | - | - | - | - | - | 23752 | 1204156800000 | -122.46582902 | 37.74089198 | - | - | - | D7 | - | OTHER REGULATORY | REG | R(SF).0135 | 18X18 | SUP2 | SIGNAL POLE | IS | 1537534740000 | WEST PORTAL AVE | - | - | - | - | - | - |
| 6680 | N/A | Point | - | - | - | - | S248510 | ULLOA ST: WEST PORTAL AVE | - | F | F | - | F | 22928000 | 22928000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ULLOA ST | ULLOA ST | 76654 | 76654 | 37.74089198 | -122.46582902 | WEST PORTAL AVE \ ULLOA ST | WEST PORTAL AVE \ ULLOA ST | 1727744336000 | middleware_editor | TRANSIT SIGNAL | ULLOA ST intersection | - | - | - | - | - | - | - | 23753 | 1204156800000 | -122.46582902 | 37.74089198 | - | 1553212800000 | - | D7 | - | OTHER REGULATORY | REG | R(SF).0370 | 24X18 | SUP2 | SIGNAL POLE | IS | 1537534800000 | WEST PORTAL AVE | - | - | - | - | - | - |
| 6681 | N/A | Point | - | - | - | - | S123848 | CHENERY ST: FAIRMOUNT ST | - | F | F | - | F | 21847000 | 21847000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CHENERY ST | FAIRMOUNT ST | 76666 | 76666 | 37.73895155 | -122.42581519 | FAIRMOUNT ST \ CHENERY ST | CHENERY ST \ FAIRMOUNT ST | 1710539427000 | MTA | STOP | FAIRMOUNT ST intersection | - | - | - | - | - | - | - | 23754 | 1148428800000 | -122.42581519 | 37.73895155 | - | 1549411200000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373575020000 | CHENERY ST | - | - | - | - | - | - |
| 6682 | N/A | Point | - | - | - | - | S123881 | 3RD AVE: BALBOA ST | - | F | F | - | F | 27235000 | 27235000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 3RD AVE | BALBOA ST | 76668 | 76668 | 37.77738033 | -122.46079634 | BALBOA ST \ 3RD AVE | 03RD AVE \ BALBOA ST | 1710539427000 | MTA | ALL WAY | BALBOA ST intersection | - | - | - | - | - | - | - | 23755 | 1148515200000 | -122.46079634 | 37.77738033 | - | - | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575020000 | 03RD AVE | - | - | - | - | - | - |
| 6683 | N/A | Point | - | - | - | - | S250831 | POLK ST: ELLIS ST | - | T | T | - | F | 25178000 | 25178000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POLK ST | ELLIS ST | 76669 | 76669 | 37.78402912 | -122.41936417 | ELLIS ST \ POLK ST | POLK ST \ ELLIS ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED ARROW | ELLIS ST intersection | - | - | - | - | - | - | - | 23756 | 1551278640000 | -122.41936417 | 37.78402912 | - | - | - | D6 | - | NO RIGHT TURN | REG | R13A(SF).0006 | 24X30 | SUP1 | OVERHEAD MAST ARM | IS | 1547555820000 | POLK ST | - | - | - | - | - | - |
| 6684 | N/A | Point | 1 | 1 | 700 - 729 | - | S250835 | 700-729 POLK ST | 700-729 POLK ST | F | F | - | F | 25177000 | 10555000 | - | - | WEST SIDE | - | - | - | - | POLK ST | EDDY ST | 76671 | 76671 | 37.78333459 | -122.41922757 | WILLOW ST \ POLK ST | - | 1710539427000 | MTA | NEW TRAFFIC PATTERN AHEAD | EDDY ST to WILLOW ST (700 - 729) | - | 25' SOUTH OF WILLOW | - | - | - | - | - | 23757 | 1429574400000 | -122.41922757 | 37.78333459 | - | 1551312000000 | - | D6 | - | OTHER WARNING | WARNING | W23-2.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1547557020000 | POLK ST | - | 700 - 729 POLK ST | 700 POLK ST | - | - | WILLOW ST |
| 6685 | N/A | Point | - | - | - | - | S250837 | POLK ST: EDDY ST | - | T | T | - | F | 25176000 | 25176000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | EDDY ST | POLK ST | 76672 | 76672 | 37.7831014 | -122.4191817 | POLK ST \ EDDY ST | EDDY ST \ POLK ST | 1733333635000 | middleware_editor | EXC BICYCLES | POLK ST intersection | - | - | - | - | - | - | - | 23758 | 1551365700000 | -122.4191817 | 37.7831014 | - | - | - | D6 | - | OTHER REGULATORY | REG | R(SF).0058 | 24X18 | SUP1 | OVERHEAD MAST ARM | IS | 1547558280000 | EDDY ST | - | - | - | - | - | - |
| 6686 | N/A | Point | 1 | 1 | 1 - 99 | - | S252636 | 1-99 CRANLEIGH DR | 1-99 CRANLEIGH DR | F | F | - | F | 4480000 | 4480000 | - | - | EAST SIDE | - | - | - | - | SLOAT BLVD | SLOAT BLVD | 77694 | 77694 | 37.73400708 | -122.47252905 | - | - | 1727830689000 | middleware_editor | 2 HR PRK 7AM-6PM EXC SUN | SLOAT BLVD to LAGUNITAS DR (1 - 99) | - | OPP 35 | - | - | - | - | - | 23759 | 1225065600000 | -122.47252905 | 37.73400708 | - | - | - | D7 | - | PARKING | REG | R32(CA).0071 | 18X18 | SUP2 | LIGHT POLE | IS | 1552993560000 | CRANLEIGH DR | 1 - 99 CRANLEIGH DR | 1 - 99 CRANLEIGH DR | 1 CRANLEIGH DR | - | LAGUNITAS DR | LAGUNITAS DR |
| 6687 | N/A | Point | 1 | 1 | 1 - 99 | - | S252637 | 1-99 CRANLEIGH DR | 1-99 CRANLEIGH DR | F | F | - | F | 4480000 | 4480000 | - | - | EAST SIDE | - | - | - | - | SLOAT BLVD | SLOAT BLVD | 77695 | 77695 | 37.73400708 | -122.47252905 | - | - | 1727830719000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "H" PERMITS | SLOAT BLVD to LAGUNITAS DR (1 - 99) | - | OPP 35 | - | - | - | - | - | 23760 | 1225065600000 | -122.47252905 | 37.73400708 | - | 1554768000000 | - | D7 | - | PARKING:RPP | REG | R32C(CA).0088 | 18X21 | SUP2 | LIGHT POLE | IS | 1552993680000 | CRANLEIGH DR | 1 - 99 CRANLEIGH DR | 1 - 99 CRANLEIGH DR | 1 CRANLEIGH DR | - | LAGUNITAS DR | LAGUNITAS DR |
| 6688 | N/A | Point | - | 1 | 200 - 299 | - | S254255 | 200 - 299 COLEMAN ST | 200-299 COLEMAN ST | T | T | - | F | 19068001 | 19068001 | - | - | WEST SIDE | - | - | - | - | INNES AVE \ INNES CT | INNES AVE \ INNES CT | 77713 | 77713 | 37.72753446 | -122.36870963 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM TUE STCL | INNES AVE \ INNES CT to JERROLD AVE \ KENNEDY PL \ KIRKWOOD AVE (200 - 299) | - | 43' SOUTH OF INNES AVE. | - | - | - | - | - | 23761 | - | -122.36870963 | 37.72753446 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0270 | 18X18 | SUP1 | LIGHT POLE | IS | 1557482640000 | COLEMAN ST | 200 - 299 COLEMAN ST | 200 - 299 COLEMAN ST | 200 COLEMAN ST | - | JERROLD AVE \ KENNEDY PL \ KIRKWOOD AVE | JERROLD AVE \ KENNEDY PL \ KIRKWOOD AVE |
| 6689 | N/A | Point | - | - | - | - | S254256 | COLEMAN ST: HUDSON AVE | - | F | F | - | F | 35033000 | 35033000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HUDSON AVE | COLEMAN ST | 77714 | 77714 | 37.72846587 | -122.36787067 | COLEMAN ST \ HUDSON AVE | HUDSON AVE \ COLEMAN ST | 1710539427000 | MTA | STOP | COLEMAN ST intersection | - | - | - | - | - | - | - | 23762 | 1558618200000 | -122.36787067 | 37.72846587 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1557482820000 | HUDSON AVE | - | - | - | - | - | - |
| 6690 | N/A | Point | - | - | - | LEFT ARROW | S248070 | SANTA MONICA WAY: SANTA CLARA | - | F | F | - | F | 22916000 | 22916000 | - | - | NORTH SIDE | - | - | - | - | SANTA MONICA WAY \ YERBA BUENA AVE | SANTA MONICA WAY \ YERBA BUENA AVE | 77895 | 77895 | 37.73849364 | -122.46584491 | SANTA CLARA AVE \ SANTA MONICA WAY \ YERBA BUENA AVE | SANTA CLARA AVE \ SANTA MONICA WAY \ YERBA BUENA AVE | 1714066391000 | middleware_editor | NPRK ANY TIME | SANTA MONICA WAY \ YERBA BUENA AVE intersection | - | 50'E OF SANTA CLARA AVE(AT PAINT MARK) | - | - | - | - | - | 23763 | 1536157800000 | -122.46584491 | 37.73849364 | - | 1713954600000 | - | D7 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP2 | 2IN IRON POST | IS | 1535698080000 | SANTA CLARA AVE | - | - | - | - | - | - |
| 6691 | N/A | Point | - | - | - | - | S248307 | POPE ST: MISSION ST | - | T | T | - | F | 21483000 | 21483000 | - | - | SOUTH EAST CORNER | - | - | - | - | POPE ST | POPE ST | 77896 | 77896 | 37.71542968 | -122.44179947 | MISSION ST \ POPE ST | MISSION ST \ POPE ST | 1710539427000 | MTA | POPE ST | POPE ST intersection | - | - | - | - | - | - | - | 23764 | 274579200000 | -122.44179947 | 37.71542968 | - | 1538006400000 | - | D11 | - | STREET NAME | GUIDE | D3-1.1408 | 36X08 | SUP2 | LIGHT POLE | IS | 1536831420000 | MISSION ST | - | - | - | - | - | - |
| 6692 | N/A | Point | - | - | - | - | S248308 | POPE ST: MISSION ST | - | F | F | - | F | 21483000 | 21483000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POPE ST | POPE ST | 77897 | 77897 | 37.71542968 | -122.44179947 | MISSION ST \ POPE ST | MISSION ST \ POPE ST | 1710539427000 | MTA | ONE WAY (RA) | POPE ST intersection | - | - | - | - | - | - | - | 23765 | 274579200000 | -122.44179947 | 37.71542968 | - | 1537228800000 | - | D11 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | SIGNAL POLE | IS | 1536831540000 | MISSION ST | - | - | - | - | - | - |
| 6693 | N/A | Point | - | - | - | - | S248309 | MISSION ST: POPE ST | - | T | T | - | F | 21483000 | 21483000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POPE ST | POPE ST | 77898 | 77898 | 37.71542968 | -122.44179947 | MISSION ST \ POPE ST | MISSION ST \ POPE ST | 1710539427000 | MTA | (LA) NIAGARA / POPE (RA) | POPE ST intersection | - | - | - | - | - | - | - | 23766 | 1419379200000 | -122.44179947 | 37.71542968 | - | 1548288000000 | - | D11 | - | STREET NAME | GUIDE | D3-2.0457 | 72X30 | SUP2 | UTILITY POLE | IS | 1536832020000 | MISSION ST | - | - | - | - | - | - |
| 6694 | N/A | Point | - | - | - | - | S248310 | MISSION ST: POPE ST | - | T | T | - | F | 21483000 | 21483000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POPE ST | POPE ST | 77899 | 77899 | 37.71542968 | -122.44179947 | MISSION ST \ POPE ST | MISSION ST \ POPE ST | 1710539427000 | MTA | NO U TURN (SYM) | POPE ST intersection | - | - | - | - | - | - | - | 23767 | 1419379200000 | -122.44179947 | 37.71542968 | - | 1537228800000 | - | D11 | - | OTHER REGULATORY | REG | R3-4.0002 | 30X30 | SUP2 | OVERHEAD MAST ARM | IS | 1536832080000 | MISSION ST | - | - | - | - | - | - |
| 6695 | N/A | Point | - | - | - | - | S248311 | MISSION ST: ROLPH ST | - | T | T | - | F | 21485000 | 21485000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ROLPH ST | MISSION ST | 77900 | 77900 | 37.71575345 | -122.44155428 | MISSION ST \ ROLPH ST | ROLPH ST \ MISSION ST | 1710539427000 | MTA | NO U TURN (SYM) | MISSION ST intersection | - | - | - | - | - | - | - | 23768 | 1445904000000 | -122.44155428 | 37.71575345 | - | 1537228800000 | - | D11 | - | OTHER REGULATORY | REG | R3-4.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1536832500000 | ROLPH ST | - | - | - | - | - | - |
| 6696 | N/A | Point | - | - | - | - | S248313 | ROLPH ST: MISSION ST | - | F | F | - | F | 21485000 | 21485000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ROLPH ST | MISSION ST | 77901 | 77901 | 37.71575345 | -122.44155428 | MISSION ST \ ROLPH ST | ROLPH ST \ MISSION ST | 1710539427000 | MTA | ROLPH ST | MISSION ST intersection | - | - | - | - | - | - | - | 23769 | 120700800000 | -122.44155428 | 37.71575345 | - | 1538006400000 | - | D11 | - | STREET NAME | GUIDE | D3-1.1506 | 36X08 | SUP2 | SIGNAL POLE | IS | 1536833340000 | ROLPH ST | - | - | - | - | - | - |
| 6697 | N/A | Point | - | - | - | - | S248316 | MISSION ST: ROLPH ST | - | T | T | - | F | 21485000 | 21485000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ROLPH ST | MISSION ST | 77903 | 77903 | 37.71575345 | -122.44155428 | MISSION ST \ ROLPH ST | ROLPH ST \ MISSION ST | 1710539427000 | MTA | MISSION ST | MISSION ST intersection | - | - | - | - | - | - | - | 23770 | 1445904000000 | -122.44155428 | 37.71575345 | - | 1548288000000 | - | D11 | - | STREET NAME | GUIDE | D3-2.0247 | 72X18 | SUP2 | SIGNAL POLE | IS | 1536834120000 | ROLPH ST | - | - | - | - | - | - |
| 6698 | N/A | Point | - | - | - | - | S248317 | MISSION ST: ROLPH ST | - | F | F | - | F | 21485000 | 21485000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ROLPH ST | MISSION ST | 77904 | 77904 | 37.71575345 | -122.44155428 | MISSION ST \ ROLPH ST | ROLPH ST \ MISSION ST | 1710539427000 | MTA | NO U TURN (SYM) | MISSION ST intersection | - | - | - | - | - | - | - | 23771 | 1445904000000 | -122.44155428 | 37.71575345 | - | 1537228800000 | - | D11 | - | OTHER REGULATORY | REG | R3-4.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1536834240000 | ROLPH ST | - | - | - | - | - | - |
| 6699 | N/A | Point | - | - | - | - | S248318 | MISSION ST: POPE ST | - | T | T | - | F | 21483000 | 21483000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POPE ST | POPE ST | 77905 | 77905 | 37.71542968 | -122.44179947 | MISSION ST \ POPE ST | MISSION ST \ POPE ST | 1710539427000 | MTA | NO U TURN (SYM) | POPE ST intersection | - | - | - | - | - | - | - | 23772 | 1419379200000 | -122.44179947 | 37.71542968 | - | 1537228800000 | - | D11 | - | OTHER REGULATORY | REG | R3-4.0002 | 30X30 | SUP2 | SIGNAL POLE | IS | 1536834780000 | MISSION ST | - | - | - | - | - | - |
| 6700 | N/A | Point | - | - | - | - | S247844 | CALIFORNIA ST: PRESIDIO AVE | - | F | F | - | F | 26846000 | 26846000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 77906 | 77906 | 37.78726185 | -122.44679278 | PRESIDIO AVE \ CALIFORNIA ST | PRESIDIO AVE \ CALIFORNIA ST | 1710539427000 | MTA | YIELD (SYM) | CALIFORNIA ST intersection | - | AT WEST LINE OF COSSWALK | - | - | - | - | - | 23773 | 1537799700000 | -122.44679278 | 37.78726185 | - | - | - | D2 | - | OTHER REGULATORY | REG | R1-2.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1534778400000 | PRESIDIO AVE | - | - | - | - | - | - |
| 6701 | N/A | Point | - | - | - | - | S247845 | 23RD ST: TREAT AVE | - | F | F | - | F | 23988000 | 23988000 | - | - | SOUTH WEST CORNER | - | - | - | - | TREAT AVE | 23RD ST | 77907 | 77907 | 37.75416458 | -122.41314089 | 23RD ST \ TREAT AVE | TREAT AVE \ 23RD ST | 1710539427000 | MTA | 23RD ST | 23RD ST intersection | - | - | - | - | - | - | - | 23774 | 1541376000000 | -122.41314089 | 37.75416458 | - | 1583107200000 | - | D9 | - | STREET NAME | GUIDE | D3-1.0017 | 36X08 | SUP2 | 3IN IRON POST | IS | 1534778760000 | TREAT AVE | - | - | - | - | - | - |
| 6702 | N/A | Point | - | - | - | - | S247846 | 23RD ST: TREAT AVE | - | F | F | - | F | 23988000 | 23988000 | - | - | SOUTH WEST CORNER | - | - | - | - | TREAT AVE | 23RD ST | 77908 | 77908 | 37.75416458 | -122.41314089 | 23RD ST \ TREAT AVE | TREAT AVE \ 23RD ST | 1710539427000 | MTA | TREAT AVE | 23RD ST intersection | - | - | - | - | - | - | - | 23775 | 1541376000000 | -122.41314089 | 37.75416458 | - | 1583107200000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1745 | 36X08 | SUP2 | 3IN IRON POST | IS | 1534778940000 | TREAT AVE | - | - | - | - | - | - |
| 6703 | N/A | Point | 1 | 1 | 900 - 999 | - | S247847 | 900-999 SHOTWELL ST | 900-999 SHOTWELL ST | F | F | - | F | 11841000 | 11841000 | - | - | EAST SIDE | - | - | - | - | 23RD ST | 23RD ST | 77909 | 77909 | 37.75323659 | -122.41524621 | - | - | 1710539427000 | MTA | 1 HR PRK 9AM-6PM MON-FRI EXC "I" PERMITS | 23RD ST to 24TH ST (900 - 999) | - | NPL# 957 | - | - | - | - | - | 23776 | 1536969600000 | -122.41524621 | 37.75323659 | - | 1615420800000 | - | D9 | - | PARKING:RPP | REG | R32C(CA).0017 | 18X21 | SUP2 | 2IN IRON POST | IS | 1534779960000 | SHOTWELL ST | 900 - 999 SHOTWELL ST | 900 - 999 SHOTWELL ST | 900 SHOTWELL ST | - | 24TH ST | 24TH ST |
| 6704 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S150382 | 1300-1399 LOWER GREAT HWY | 1300-1399 GREAT HWY | F | F | - | F | 8509000 | 8509000 | - | - | WEST SIDE | - | - | - | - | IRVING ST | IRVING ST | 77910 | 77910 | 37.76119949 | -122.5095019 | - | - | 1752535421000 | middleware_editor | NPRK 1PM-3PM 1ST & 3RD TUE OF MONTH STCL | IRVING ST to JUDAH ST (1300 - 1399) | - | 250 FEET SOUTH OF IRVING | - | - | - | - | - | 23777 | 1228464000000 | -122.5095019 | 37.76119949 | - | - | 1752522000000 | D4 | - | STREET CLEANING | REG | R30B(CA).0096 | 18X18 | SUP2 | 2IN IRON POST | RETD | 1375729740000 | GREAT HWY | 1300 - 1399 GREAT HWY | 1300 - 1399 GREAT HWY | 1300 GREAT HWY | - | JUDAH ST | JUDAH ST |
| 6705 | N/A | Point | 1 | 1 | 2000 - 2035 | - | S205556 | 2000-2035 FOLSOM ST | 2000-2035 FOLSOM ST | F | F | - | F | 5690000 | 5690000 | - | - | WEST SIDE | - | - | - | - | 16TH ST | 16TH ST | 80808 | 80808 | 37.76500997 | -122.41527952 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM MON WED FRI STCL | 16TH ST to ENTERPRISE ST (2000 - 2035) | - | IFO #2000 | - | - | - | - | - | 23778 | 1462184820000 | -122.41527952 | 37.76500997 | - | 1462147200000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0051 | 18X18 | SUP2 | LIGHT POLE | IS | 1399544820000 | FOLSOM ST | 2000 - 2035 FOLSOM ST | 2000 - 2035 FOLSOM ST | 2000 FOLSOM ST | - | ENTERPRISE ST | ENTERPRISE ST |
| 6706 | N/A | Point | 1 | 1 | 3100 - 3199 | - | S205959 | 3100-3199 LAGUNA ST | 3100-3199 LAGUNA ST | F | F | - | F | 7981000 | 7981000 | - | - | WEST SIDE | - | - | - | - | GREENWICH ST | GREENWICH ST | 80810 | 80810 | 37.8000241 | -122.43102521 | - | - | 1747242249000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "KM" PERMITS | GREENWICH ST to LOMBARD ST (3100 - 3199) | - | 3101 LAGUNA | - | - | - | - | - | 23779 | 1219734000000 | -122.43102521 | 37.8000241 | - | 1624863600000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0094 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1400664960000 | LAGUNA ST | 3100 - 3199 LAGUNA ST | 3100 - 3199 LAGUNA ST | 3100 LAGUNA ST | - | LOMBARD ST | LOMBARD ST |
| 6707 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S205964 | 1200-1299 SAN BRUNO AVE | 1200-1299 SAN BRUNO AVE | F | F | - | F | 11360000 | 11360000 | - | - | EAST SIDE | - | - | - | - | 23RD ST | 23RD ST | 80813 | 80813 | 37.75375861 | -122.40442377 | - | - | 1742509028000 | middleware_editor | 1 HR PRK 8AM-6PM MON-FRI EXC "W" PERMITS | 23RD ST to 24TH ST (1200 - 1299) | - | @DEAD END/CENTER LINE OF SAN BRUNO | - | - | - | - | - | 23780 | 1405544400000 | -122.40442377 | 37.75375861 | - | 1405494000000 | - | D10 | - | PARKING:RPP | REG | R32C(CA).0012 | 18X21 | SUP1 | 2IN IRON POST | IS | 1400667540000 | SAN BRUNO AVE | 1200 - 1299 SAN BRUNO AVE | 1200 - 1299 SAN BRUNO AVE | 1200 SAN BRUNO AVE | - | 24TH ST | 24TH ST |
| 6708 | N/A | Point | 1 | 1 | 1900 - 1999 | - | S251096 | 1900-1999 34TH AVE | 1900-1999 34TH AVE | F | F | - | F | 1753000 | 1753000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | ORTEGA ST | ORTEGA ST | 80815 | 80815 | 37.75073128 | -122.49235119 | - | - | 1713994491000 | middleware_editor | BIKE WAYFINDING SIGN | ORTEGA ST to PACHECO ST (1900 - 1999) | 0276 | IFO 1918 | - | - | - | - | - | 23781 | 1548495600000 | -122.49235119 | 37.75073128 | - | 1713954300000 | - | D4 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | 2IN IRON POST | IS | 1548425400000 | 34TH AVE | 1900 - 1999 34TH AVE | 1900 - 1999 34TH AVE | 1900 34TH AVE | - | PACHECO ST | PACHECO ST |
| 6709 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S251098 | 2200-2299 34TH AVE | 2200-2299 34TH AVE | F | F | - | F | 1756000 | 1756000 | - | - | WEST SIDE | - | - | - | - | RIVERA ST | RIVERA ST | 80816 | 80816 | 37.74513981 | -122.4919638 | - | - | 1711658222000 | middleware_editor | BIKE WAYFINDING SIGN | RIVERA ST to SANTIAGO ST (2200 - 2299) | 0277 | IFO 2231 | - | - | - | - | - | 23782 | 1548498000000 | -122.4919638 | 37.74513981 | - | - | - | D4 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | LIGHT POLE | IS | 1548425880000 | 34TH AVE | 2200 - 2299 34TH AVE | 2200 - 2299 34TH AVE | 2200 34TH AVE | - | SANTIAGO ST | SANTIAGO ST |
| 6710 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S251099 | 2300-2399 34TH AVE | 2300-2399 34TH AVE | F | F | - | F | 1757000 | 1757000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | SANTIAGO ST | SANTIAGO ST | 80817 | 80817 | 37.74327625 | -122.49183432 | - | - | 1711657809000 | middleware_editor | BIKE WAYFINDING SIGN | SANTIAGO ST to TARAVAL ST (2300 - 2399) | 0278 | IFO 2230 | - | - | - | - | - | 23783 | 1548499200000 | -122.49183432 | 37.74327625 | - | - | - | D4 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | 2IN IRON POST | IS | 1548426000000 | 34TH AVE | 2300 - 2399 34TH AVE | 2300 - 2399 34TH AVE | 2300 34TH AVE | - | TARAVAL ST | TARAVAL ST |
| 6711 | N/A | Point | 1 | 1 | 100 - 199 | - | S251688 | 100-199 LUNDYS LN | 100-199 LUNDYS LN | F | F | - | F | 8542000 | 8542000 | - | - | WEST SIDE | - | - | - | - | ESMERALDA AVE | ESMERALDA AVE | 80820 | 80820 | 37.74313495 | -122.41935935 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "AA" PERMITS | ESMERALDA AVE to VIRGINIA AVE (100 - 199) | - | SPL#100 | - | - | - | - | - | 23784 | 975283200000 | -122.41935935 | 37.74313495 | - | 1555027200000 | - | D9 | - | PARKING:RPP | REG | R32C(CA).0239 | 18X21 | SUP2 | 2 POST ALUMINUM | IS | 1550567520000 | LUNDYS LN | 100 - 199 LUNDYS LN | 100 - 199 LUNDYS LN | 100 LUNDYS LN | - | VIRGINIA AVE | VIRGINIA AVE |
| 6712 | N/A | Point | 1 | 1 | 100 - 199 | - | S251689 | 100-199 LUNDYS LN | 100-199 LUNDYS LN | F | F | - | F | 8542000 | 8542000 | - | - | WEST SIDE | - | - | - | - | ESMERALDA AVE | ESMERALDA AVE | 80821 | 80821 | 37.74313495 | -122.41935935 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "AA" PERMITS | ESMERALDA AVE to VIRGINIA AVE (100 - 199) | - | SPL#124 | - | - | - | - | - | 23785 | 975283200000 | -122.41935935 | 37.74313495 | - | 1555027200000 | - | D9 | - | PARKING:RPP | REG | R32C(CA).0239 | 18X21 | SUP2 | 2IN IRON POST | IS | 1550567880000 | LUNDYS LN | 100 - 199 LUNDYS LN | 100 - 199 LUNDYS LN | 100 LUNDYS LN | - | VIRGINIA AVE | VIRGINIA AVE |
| 6713 | N/A | Point | 1 | 1 | 100 - 199 | - | S251690 | 100-199 LUNDYS LN | 100-199 LUNDYS LN | F | F | - | F | 8542000 | 8542000 | - | - | WEST SIDE | - | - | - | - | ESMERALDA AVE | ESMERALDA AVE | 80822 | 80822 | 37.74313495 | -122.41935935 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "AA" PERMITS | ESMERALDA AVE to VIRGINIA AVE (100 - 199) | - | SPL#152 | - | - | - | - | - | 23786 | 975283200000 | -122.41935935 | 37.74313495 | - | 1555027200000 | - | D9 | - | PARKING:RPP | REG | R32C(CA).0239 | 18X21 | SUP2 | LIGHT POLE | IS | 1550568120000 | LUNDYS LN | 100 - 199 LUNDYS LN | 100 - 199 LUNDYS LN | 100 LUNDYS LN | - | VIRGINIA AVE | VIRGINIA AVE |
| 6714 | N/A | Point | 1 | 1 | 100 - 199 | - | S251691 | 100-199 LUNDYS LN | 100-199 LUNDYS LN | F | F | - | F | 8542000 | 8542000 | - | - | WEST SIDE | - | - | - | - | ESMERALDA AVE | ESMERALDA AVE | 80823 | 80823 | 37.74313495 | -122.41935935 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "AA" PERMITS | ESMERALDA AVE to VIRGINIA AVE (100 - 199) | - | 20 FEET SOUTH FROM SPL 170 | - | - | - | - | - | 23787 | 975283200000 | -122.41935935 | 37.74313495 | - | 1555459200000 | - | D9 | - | PARKING:RPP | REG | R32C(CA).0239 | 18X21 | SUP2 | 2IN IRON POST | IS | 1550568540000 | LUNDYS LN | 100 - 199 LUNDYS LN | 100 - 199 LUNDYS LN | 100 LUNDYS LN | - | VIRGINIA AVE | VIRGINIA AVE |
| 6715 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S251697 | 1700-1799 CLEMENT ST | 1700-1799 CLEMENT ST | F | F | - | F | 4168000 | 4168000 | - | - | SOUTH SIDE | - | - | - | - | 18TH AVE | 18TH AVE | 80824 | 80824 | 37.78233447 | -122.47790891 | - | - | 1710539427000 | MTA | TA (SYM) PLO 4PM-11PM DAILY (5 MIN) | 18TH AVE to 19TH AVE (1700 - 1799) | - | WPL 1745 AT PAINT MARK | - | - | - | - | - | 23788 | 1426550400000 | -122.47790891 | 37.78233447 | - | 1426550400000 | - | D1 | - | OTHER REGULATORY | REG | R38(SF)1.0161 | 14X21 | SUP2 | 2 POST ALUMINUM | IS | 1550574900000 | CLEMENT ST | 1700 - 1799 CLEMENT ST | 1700 - 1799 CLEMENT ST | 1700 CLEMENT ST | - | 19TH AVE | 19TH AVE |
| 6716 | N/A | Point | - | - | - | - | S251698 | 24TH AVE: BALBOA ST | - | F | F | - | F | 27534000 | 27534000 | - | - | SOUTH WEST CORNER | - | - | - | - | 24TH AVE | 24TH AVE | 80825 | 80825 | 37.77635101 | -122.48339012 | BALBOA ST \ 24TH AVE | BALBOA ST \ 24TH AVE | 1718759107000 | middleware_editor | NO PED XING-USE CROSSWALK (DA) | 24TH AVE intersection | - | - | - | - | - | - | - | 23789 | - | -122.48339012 | 37.77635101 | - | - | - | D1 | - | PEDESTRIAN | REG | R49(CA).0003 | 36X18 | SUP2 | PED BARRICADE | IS | 1550581740000 | BALBOA ST | - | - | - | - | - | - |
| 6717 | N/A | Point | 1 | 1 | 100 - 199 | - | S239330 | 100-199 JONES ST | 100-199 JONES ST | F | F | - | F | 7564000 | 7564000 | - | - | CENTER ISLAND | - | - | - | - | GOLDEN GATE AVE | GOLDEN GATE AVE | 85290 | 85290 | 37.78253858 | -122.41231624 | - | - | 1738695774000 | middleware_editor | FG 300 UR DELINEATOR (W) | GOLDEN GATE AVE to TURK ST (100 - 199) | - | N-CROSSWALK 5FT O.C. | - | - | - | - | - | 23790 | 1513690200000 | -122.41231624 | 37.78253858 | - | 1513641600000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1507197000000 | JONES ST | 100 - 199 JONES ST | 100 - 199 JONES ST | 100 JONES ST | - | TURK ST | TURK ST |
| 6718 | N/A | Point | - | - | - | - | S259304 | INDIANA ST: 26TH ST | - | F | F | - | F | 23608000 | 23608000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | INDIANA ST | 26TH ST | 87887 | 87887 | 37.75139048 | -122.39056358 | 26TH ST \ INDIANA ST | INDIANA ST \ 26TH ST | 1710539427000 | MTA | EXCEPT BIKE (SYM) | 26TH ST intersection | - | - | - | - | - | - | - | 23791 | 824342400000 | -122.39056358 | 37.75139048 | - | 1574121600000 | - | D10 | - | OTHER REGULATORY | REG | R(SF).0362 | 24X18 | SUP1 | 2IN IRON POST | IS | 1574076840000 | INDIANA ST | - | - | - | - | - | - |
| 6719 | N/A | Point | - | - | - | - | S251136 | POLK ST: ELLIS ST | - | T | T | - | F | 25178000 | 25178000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POLK ST | ELLIS ST | 88594 | 88594 | 37.78402912 | -122.41936417 | ELLIS ST \ POLK ST | POLK ST \ ELLIS ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | ELLIS ST intersection | - | - | - | - | - | - | - | 23792 | 1551279120000 | -122.41936417 | 37.78402912 | - | - | - | D6 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | OVERHEAD MAST ARM | IS | 1548765660000 | POLK ST | - | - | - | - | - | - |
| 6720 | N/A | Point | 1 | 1 | 1000 - 1199 | - | S256965 | 1000-1199 EDDY ST | 1000-1199 EDDY ST | T | T | - | F | 5068000 | 5068000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | GOUGH ST | GOUGH ST | 88596 | 88596 | 37.782267 | -122.4257523 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | GOUGH ST to LAGUNA ST (1000 - 1199) | 133604 | 105' W OF GOUGH ST | - | - | - | - | - | 23793 | 1320278400000 | -122.4257523 | 37.782267 | - | - | - | D5 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP1 | LIGHT POLE | IS | 1565346840000 | EDDY ST | 1000 - 1199 EDDY ST | 1000 - 1199 EDDY ST | 1000 EDDY ST | - | LAGUNA ST | LAGUNA ST |
| 6721 | N/A | Point | - | - | - | - | S256970 | PIERCE ST: ELLIS ST | - | F | F | - | F | 26612000 | 26612000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 88597 | 88597 | 37.78194033 | -122.43581374 | PIERCE ST \ ELLIS ST | PIERCE ST \ ELLIS ST | 1710539427000 | MTA | (90 RA) REVERSE CURVE (SYM) | ELLIS ST intersection | - | 15' S ELLIS ST/ INSTALL ABOVE STOP | - | - | - | - | - | 23794 | 1567598160000 | -122.43581374 | 37.78194033 | - | - | 1641772800000 | D5 | - | OTHER WARNING | WARNING | W1-3.0001 | 36X36 | SUP1 | 2IN IRON POST | RETD | 1565353260000 | PIERCE ST | - | - | - | - | - | - |
| 6722 | N/A | Point | - | - | - | - | S257151 | RHODE ISLAND ST: 23RD ST | - | F | F | - | F | 23710000 | 23710000 | - | - | SOUTH WEST CORNER | - | - | - | - | RHODE ISLAND ST | RHODE ISLAND ST | 88598 | 88598 | 37.75457056 | -122.40158939 | 23RD ST \ RHODE ISLAND ST | 23RD ST \ RHODE ISLAND ST | 1710539427000 | MTA | RHODE ISLAND ST | RHODE ISLAND ST intersection | - | - | - | - | - | - | - | 23795 | 1566994440000 | -122.40158939 | 37.75457056 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.1474 | 36X08 | SUP1 | 3IN IRON POST | IS | 1566207960000 | 23RD ST | - | - | - | - | - | - |
| 6723 | N/A | Point | - | - | - | - | S257152 | RHODE ISLAND ST: 23RD ST | - | F | F | - | F | 23710000 | 23710000 | - | - | SOUTH WEST CORNER | - | - | - | - | RHODE ISLAND ST | RHODE ISLAND ST | 88599 | 88599 | 37.75457056 | -122.40158939 | 23RD ST \ RHODE ISLAND ST | 23RD ST \ RHODE ISLAND ST | 1710539427000 | MTA | 23RD ST | RHODE ISLAND ST intersection | - | - | - | - | - | - | - | 23796 | 1566994500000 | -122.40158939 | 37.75457056 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.0017 | 36X08 | SUP1 | 3IN IRON POST | IS | 1566208020000 | 23RD ST | - | - | - | - | - | - |
| 6724 | N/A | Point | - | - | - | - | S257478 | NEWHALL ST: TOPEKA AVE \ VENUS | - | F | F | - | F | 20532000 | 20532000 | - | - | NORTH WEST CORNER | - | - | - | - | TOPEKA AVE \ VENUS ST | NEWHALL ST \ VENUS ST | 88600 | 88600 | 37.73191177 | -122.39572617 | NEWHALL ST \ TOPEKA AVE \ VENUS ST | TOPEKA AVE \ NEWHALL ST \ VENUS ST | 1710539427000 | MTA | NEWHALL ST | NEWHALL ST \ VENUS ST intersection | - | X-STREET IS TOPEKA ST, 1900---> SOUTH | - | - | - | - | - | 23797 | 1570094640000 | -122.39572617 | 37.73191177 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.1272 | 36X08 | SUP1 | 3IN IRON POST | IS | 1567153320000 | TOPEKA AVE | - | - | - | - | - | - |
| 6725 | N/A | Point | - | - | - | - | S257479 | NEWHALL ST: TOPEKA AVE \ VENUS | - | F | F | - | F | 20532000 | 20532000 | - | - | NORTH WEST CORNER | - | - | - | - | TOPEKA AVE \ VENUS ST | NEWHALL ST \ VENUS ST | 88601 | 88601 | 37.73191177 | -122.39572617 | NEWHALL ST \ TOPEKA AVE \ VENUS ST | TOPEKA AVE \ NEWHALL ST \ VENUS ST | 1710539427000 | MTA | TOPEKA AVE | NEWHALL ST \ VENUS ST intersection | - | X-STREET IS TOPEKA ST, 300--->EAST | - | - | - | - | - | 23798 | 1570094700000 | -122.39572617 | 37.73191177 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.1738 | 36X08 | SUP1 | 3IN IRON POST | IS | 1567153500000 | TOPEKA AVE | - | - | - | - | - | - |
| 6726 | N/A | Point | - | - | - | - | S257480 | VENUS ST: NEWHALL ST \ TOPEKA | - | F | F | - | F | 20532000 | 20532000 | - | - | NORTH WEST CORNER | - | - | - | - | NEWHALL ST \ VENUS ST | NEWHALL ST \ VENUS ST | 88602 | 88602 | 37.73191177 | -122.39572617 | TOPEKA AVE \ NEWHALL ST \ VENUS ST | TOPEKA AVE \ NEWHALL ST \ VENUS ST | 1710539427000 | MTA | TOPEKA AVE | NEWHALL ST \ VENUS ST intersection | - | 300--->SOUTH | - | - | - | - | - | 23799 | 1569327720000 | -122.39572617 | 37.73191177 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.1738 | 36X08 | SUP1 | 3IN IRON POST | IS | 1567153800000 | TOPEKA AVE | - | - | - | - | - | - |
| 6727 | N/A | Point | 1 | 1 | 400 - 499 | - | S257482 | 400-499 CHESTNUT ST | 400-499 CHESTNUT ST | F | F | - | F | 3956000 | 3956000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | STOCKTON ST | STOCKTON ST | 88603 | 88603 | 37.80406554 | -122.41075871 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | STOCKTON ST to POWELL ST (400 - 499) | - | 45' WEST OF STOCKTON ST. | - | - | - | - | - | 23800 | - | -122.41075871 | 37.80406554 | - | - | - | D3 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | 2IN IRON POST | IS | 1567155540000 | CHESTNUT ST | 400 - 499 CHESTNUT ST | 400 - 499 CHESTNUT ST | 400 CHESTNUT ST | - | POWELL ST | POWELL ST |
| 6728 | N/A | Point | - | - | - | - | S257484 | SILVER AVE: BAY SHORE BLVD | - | T | T | - | F | 20656000 | 20656000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BAY SHORE BLVD | BAY SHORE BLVD | 88604 | 88604 | 37.73294878 | -122.4046571 | SILVER AVE \ BAY SHORE BLVD | SILVER AVE \ BAY SHORE BLVD | 1732199450000 | middleware_editor | (LA) ONLY (VA-RA) | BAY SHORE BLVD intersection | - | - | - | - | - | - | - | 23801 | 1569233700000 | -122.4046571 | 37.73294878 | - | - | - | D10 | - | OTHER REGULATORY | REG | R61-5(CA).0001 | 36X30 | SUP1 | LIGHT POLE | IS | 1567157640000 | SILVER AVE | - | - | - | - | - | - |
| 6729 | N/A | Point | - | - | - | - | S103735 | PAGE ST: CENTRAL AVE | - | F | F | - | F | 26324000 | 26324000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PAGE ST | CENTRAL AVE | 5654 | 5654 | 37.77135811 | -122.44383615 | CENTRAL AVE \ PAGE ST | PAGE ST \ CENTRAL AVE | 1710539427000 | MTA | STOP | CENTRAL AVE intersection | - | 0 / 0 | - | - | - | - | - | 23802 | -111542400000 | -122.44383615 | 37.77135811 | - | 1084233600000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568720000 | PAGE ST | - | - | - | - | - | - |
| 6730 | N/A | Point | - | - | - | - | S103738 | NEWHALL ST: INNES AVE | - | F | F | - | F | 20228000 | 20228000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | INNES AVE | INNES AVE | 5657 | 5657 | 37.73942194 | -122.38883452 | NEWHALL ST \ INNES AVE | NEWHALL ST \ INNES AVE | 1710539427000 | MTA | STOP | INNES AVE intersection | - | 0 / 0 | - | - | - | - | - | 23803 | -111456000000 | -122.38883452 | 37.73942194 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568720000 | NEWHALL ST | - | - | - | - | - | - |
| 6731 | N/A | Point | - | - | - | - | S103739 | POWELL ST: FILBERT ST | - | F | F | - | F | 25425000 | 25425000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FILBERT ST | FILBERT ST | 5658 | 5658 | 37.80116975 | -122.41101852 | POWELL ST \ FILBERT ST | POWELL ST \ FILBERT ST | 1712106029000 | middleware_editor | STOP | FILBERT ST intersection | - | 00 / 00 | - | - | - | - | - | 23804 | -111456000000 | -122.41101852 | 37.80116975 | - | 1704240000000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | MUNI POLE | IS | 1373568720000 | POWELL ST | - | - | - | - | - | - |
| 6732 | N/A | Point | - | - | - | - | S109427 | MASON ST: WASHINGTON ST | - | F | F | - | F | 25098000 | 25098000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 7302 | 7302 | 37.79452665 | -122.41136404 | MASON ST \ WASHINGTON ST | MASON ST \ WASHINGTON ST | 1750975362000 | middleware_editor | DO NOT ENTER | WASHINGTON ST intersection | - | 0 / STREET CHANGED TO ONE WAY/NORTHBOUND | - | - | - | - | - | 23805 | 488530800000 | -122.41136404 | 37.79452665 | - | 1750973400000 | - | D3 | - | OTHER REGULATORY | REG | R5-1.0002 | 24X24 | SUP1 | SIGNAL POLE | IS | 1373570520000 | MASON ST | - | - | - | - | - | - |
| 6733 | N/A | Point | - | - | - | - | S110411 | 41ST AVE: SANTIAGO ST | - | F | F | - | F | 23468000 | 23468000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 41ST AVE | 41ST AVE | 8571 | 8571 | 37.74387941 | -122.49939324 | SANTIAGO ST \ 41ST AVE | SANTIAGO ST \ 41ST AVE | 1710539427000 | MTA | STOP | 41ST AVE intersection | - | - | - | - | - | - | - | 23806 | 634262400000 | -122.49939324 | 37.74387941 | - | 1490054400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570820000 | SANTIAGO ST | - | - | - | - | - | - |
| 6734 | N/A | Point | - | - | - | - | S110412 | 41ST AVE: SANTIAGO ST | - | F | F | - | F | 23468000 | 23468000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 41ST AVE | 41ST AVE | 8572 | 8572 | 37.74387941 | -122.49939324 | SANTIAGO ST \ 41ST AVE | SANTIAGO ST \ 41ST AVE | 1710539427000 | MTA | STOP | 41ST AVE intersection | - | - | - | - | - | - | - | 23807 | 634262400000 | -122.49939324 | 37.74387941 | - | 1490054400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570820000 | SANTIAGO ST | - | - | - | - | - | - |
| 6735 | N/A | Point | - | - | - | - | S110413 | 25TH AVE: VICENTE ST | - | F | F | - | F | 23236000 | 23236000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 25TH AVE | 25TH AVE | 8573 | 8573 | 37.73904155 | -122.48185874 | VICENTE ST \ 25TH AVE | VICENTE ST \ 25TH AVE | 1720746250000 | middleware_editor | STOP | 25TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 23808 | 634262400000 | -122.48185874 | 37.73904155 | - | 1464912000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373570820000 | VICENTE ST | - | - | - | - | - | - |
| 6736 | N/A | Point | - | - | - | - | S110415 | PACHECO ST: 30TH AVE | - | F | F | - | F | 23399000 | 23399000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 30TH AVE | PACHECO ST | 8574 | 8574 | 37.74999008 | -122.48799608 | PACHECO ST \ 30TH AVE | 30TH AVE \ PACHECO ST | 1751308604000 | middleware_editor | STOP | PACHECO ST intersection | - | - | - | - | - | - | - | 23809 | 634291200000 | -122.48799608 | 37.74999008 | - | 1512374400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570820000 | 30TH AVE | - | - | - | - | - | - |
| 6737 | N/A | Point | - | - | - | - | S110416 | PACHECO ST: 30TH AVE | - | F | F | - | F | 23399000 | 23399000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 30TH AVE | PACHECO ST | 8575 | 8575 | 37.74999008 | -122.48799608 | PACHECO ST \ 30TH AVE | 30TH AVE \ PACHECO ST | 1752876291000 | middleware_editor | STOP | PACHECO ST intersection | - | 00 / 0 | - | - | - | - | - | 23810 | 634291200000 | -122.48799608 | 37.74999008 | - | 1509087600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570820000 | 30TH AVE | - | - | - | - | - | - |
| 6738 | N/A | Point | - | - | - | - | S110417 | HIGHLAND AVE: HOLLY PARK CIR | - | F | F | - | F | 21242000 | 21242000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HOLLY PARK CIR | HOLLY PARK CIR | 8576 | 8576 | 37.73714808 | -122.41880023 | HIGHLAND AVE \ HOLLY PARK CIR | HIGHLAND AVE \ HOLLY PARK CIR | 1746111953000 | middleware_editor | STOP | HOLLY PARK CIR intersection | - | 6W / 0 | - | - | - | - | - | 23811 | 634291200000 | -122.41880023 | 37.73714808 | - | 790934400000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570820000 | HIGHLAND AVE | - | - | - | - | - | - |
| 6739 | N/A | Point | - | - | - | - | S110418 | BADEN ST: JOOST AVE | - | F | F | - | F | 22141000 | 22141000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JOOST AVE | JOOST AVE | 8577 | 8577 | 37.73236806 | -122.43974776 | BADEN ST \ JOOST AVE | BADEN ST \ JOOST AVE | 1710539427000 | MTA | STOP | JOOST AVE intersection | - | 10N | - | - | - | - | - | 23812 | 634262400000 | -122.43974776 | 37.73236806 | - | 1166659200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570820000 | BADEN ST | - | - | - | - | - | - |
| 6740 | N/A | Point | - | - | - | - | S110419 | BADEN ST: JOOST AVE | - | F | F | - | F | 22141000 | 22141000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | JOOST AVE | JOOST AVE | 8578 | 8578 | 37.73236806 | -122.43974776 | BADEN ST \ JOOST AVE | BADEN ST \ JOOST AVE | 1710539427000 | MTA | STOP | JOOST AVE intersection | - | 0 / 0 | - | - | - | - | - | 23813 | 634262400000 | -122.43974776 | 37.73236806 | - | 1417651200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570820000 | BADEN ST | - | - | - | - | - | - |
| 6741 | N/A | Point | - | - | - | - | S110421 | UNION ST: JONES ST | - | F | F | - | F | 25490000 | 25490000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | UNION ST | UNION ST | 8579 | 8579 | 37.79961647 | -122.41576151 | JONES ST \ UNION ST | JONES ST \ UNION ST | 1710539427000 | MTA | STOP | UNION ST intersection | - | 0 / 0 | - | - | - | - | - | 23814 | 635644800000 | -122.41576151 | 37.79961647 | - | 1506297600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373570820000 | JONES ST | - | - | - | - | - | - |
| 6742 | N/A | Point | - | - | - | - | S111930 | 23RD ST: HOFFMAN AVE | - | F | F | - | F | 26085000 | 26085000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HOFFMAN AVE | 23RD ST | 8581 | 8581 | 37.75249826 | -122.44077351 | 23RD ST \ HOFFMAN AVE | HOFFMAN AVE \ 23RD ST | 1710539427000 | MTA | STOP | 23RD ST intersection | - | 6E | - | - | - | - | - | 23815 | 878083200000 | -122.44077351 | 37.75249826 | - | 1403049600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571300000 | HOFFMAN AVE | - | - | - | - | - | - |
| 6743 | N/A | Point | - | - | - | - | S111931 | 23RD ST: HOFFMAN AVE | - | F | F | - | F | 26085000 | 26085000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HOFFMAN AVE | 23RD ST | 8582 | 8582 | 37.75249826 | -122.44077351 | 23RD ST \ HOFFMAN AVE | HOFFMAN AVE \ 23RD ST | 1710539427000 | MTA | STOP | 23RD ST intersection | - | 6'E OF R99 RAMP | - | - | - | - | - | 23816 | 878083200000 | -122.44077351 | 37.75249826 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571300000 | HOFFMAN AVE | - | - | - | - | - | - |
| 6744 | N/A | Point | 1 | 1 | 0 - 0 | - | S111932 | PNDG VIDAL DR | 0-0 VIDAL DR | F | F | - | F | 13005000 | 13005000 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | ACEVEDO AVE | ACEVEDO AVE | 8583 | 8583 | 37.71920408 | -122.48463547 | - | - | 1710539427000 | MTA | DO NOT ENTER | ACEVEDO AVE to HIGUERA AVE (0 - 0) | - | S-LINE / ON EAST CENTER ISLAND | - | - | - | - | - | 23817 | 878169600000 | -122.48463547 | 37.71920408 | - | - | - | D7 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571300000 | VIDAL DR | PNDG VIDAL DR | 0 - 0 VIDAL DR | - | - | HIGUERA AVE | HIGUERA AVE |
| 6745 | N/A | Point | - | - | - | - | S111935 | 4TH ST: KING ST | - | F | F | - | F | 23798000 | 23798000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 4TH ST | 04TH ST | 8586 | 8586 | 37.77633298 | -122.39403507 | KING ST \ 4TH ST | KING ST \ 04TH ST | 1737674843000 | middleware_editor | DO NOT ENTER | 04TH ST intersection | - | NEW LARGER SIZE SGN | - | - | - | - | - | 23818 | 879811200000 | -122.39403507 | 37.77633298 | - | - | - | D6 | - | OTHER REGULATORY | REG | R5-1.0002 | 24X24 | SUP1 | LIGHT POLE | IS | 1373571300000 | KING ST | - | - | - | - | - | - |
| 6746 | N/A | Point | 1 | 1 | 300 - 341 | - | S116983 | 300-341 8TH ST | 300-341 08TH ST | F | F | - | F | 412000 | 412000 | - | - | WEST SIDE | - | - | - | - | FOLSOM ST | FOLSOM ST | 14708 | 14708 | 37.77477198 | -122.40979115 | - | - | 1750270505000 | middleware_editor | TANSAT | FOLSOM ST to RINGOLD ST (300 - 341) | - | 150'NORTH OF HARRISON NORTH LINE OF..... | - | - | - | - | - | 23819 | 1054710000000 | -122.40979115 | 37.77477198 | - | - | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373572860000 | 08TH ST | 300 - 341 8TH ST | 300 - 341 08TH ST | 300 8TH ST | - | RINGOLD ST | RINGOLD ST |
| 6747 | N/A | Point | - | - | - | - | S116717 | ANKENY ST: SPARTA ST \ WARD ST | - | F | F | - | F | 20582000 | 20582000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ANKENY ST \ WARD ST | ANKENY ST \ WARD ST | 14721 | 14721 | 37.71833665 | -122.40355492 | SPARTA ST \ ANKENY ST \ WARD ST | SPARTA ST \ ANKENY ST \ WARD ST | 1710539427000 | MTA | DO NOT ENTER | ANKENY ST \ WARD ST intersection | - | - | - | - | - | - | - | 23820 | 1052179200000 | -122.40355492 | 37.71833665 | - | - | - | D10 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | 3IN IRON POST | IS | 1373572740000 | SPARTA ST | - | - | - | - | - | - |
| 6748 | N/A | Point | - | - | - | - | S116718 | ANKENY ST: SPARTA ST \ WARD ST | - | F | F | - | F | 20582000 | 20582000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ANKENY ST \ WARD ST | ANKENY ST \ WARD ST | 14722 | 14722 | 37.71833665 | -122.40355492 | SPARTA ST \ ANKENY ST \ WARD ST | SPARTA ST \ ANKENY ST \ WARD ST | 1710539427000 | MTA | DO NOT ENTER | ANKENY ST \ WARD ST intersection | - | SPL # 5 | - | - | - | - | - | 23821 | 1052179200000 | -122.40355492 | 37.71833665 | - | 1413849600000 | - | D10 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373572740000 | SPARTA ST | - | - | - | - | - | - |
| 6749 | N/A | Point | 1 | 1 | 50 - 99 | - | S116719 | 50-99 ANKENY ST | 50-99 ANKENY ST | F | F | - | F | 2292000 | 2292000 | - | - | NORTH SIDE | - | - | - | - | BISHOP ST | BISHOP ST | 14723 | 14723 | 37.71911843 | -122.40442125 | - | - | 1710539427000 | MTA | ONE WAY (RA) | BISHOP ST to ALDER ST \ ORDWAY ST (50 - 99) | - | EPL #38 | - | - | - | - | - | 23822 | 1052179200000 | -122.40442125 | 37.71911843 | - | - | - | D10 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | 2IN IRON POST | IS | 1373572740000 | ANKENY ST | 50 - 99 ANKENY ST | 50 - 99 ANKENY ST | 50 ANKENY ST | - | ALDER ST \ ORDWAY ST | ALDER ST \ ORDWAY ST |
| 6750 | N/A | Point | - | - | - | - | S116720 | LAGUNA ST: HERMANN ST | - | T | T | - | F | 25863000 | 25863000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HERMANN ST | HERMANN ST | 14724 | 14724 | 37.77086855 | -122.42513551 | LAGUNA ST \ HERMANN ST | LAGUNA ST \ HERMANN ST | 1710539427000 | MTA | (LA) ONLY (VA) (RA) ONLY | HERMANN ST intersection | - | 0 / SEE PHOTO ATTACHED | - | - | - | - | - | 23823 | 1052179200000 | -122.42513551 | 37.77086855 | - | - | - | D8 | - | OTHER REGULATORY | REG | R61(SF).0043 | 48X36 | SUP2 | LIGHT POLE | IS | 1373572740000 | LAGUNA 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