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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 73051 | N/A | Point | 1 | 1 | 3560 - 3599 | - | S206221 | 3560-3599 MISSION ST | 3560-3599 MISSION ST | F | F | - | F | 9142000 | 9142000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | RANDALL ST | RANDALL ST | 79759 | 79759 | 37.739659036 | -122.423820453 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | RANDALL ST to APPLETON AVE (3560 - 3599) | - | 2`SOUTH | - | - | - | - | - | 90168 | - | -122.4238285 | 37.73937693 | - | - | - | D9 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | MUNI POLE | IS | 1401291300000 | MISSION ST | 3560 - 3599 MISSION ST | 3560 - 3599 MISSION ST | 3560 MISSION ST | - | APPLETON AVE | APPLETON AVE |
| 73052 | N/A | Point | - | - | - | - | S104677 | WASHINGTON ST: LAGUNA ST | - | F | F | - | F | 26558000 | 26558000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LAGUNA ST | WASHINGTON ST | 79787 | 79787 | 37.792293644 | -122.429376841 | WASHINGTON ST \ LAGUNA ST | LAGUNA ST \ WASHINGTON ST | 1710539427000 | MTA | STOP | WASHINGTON ST intersection | - | 0 / 0 | - | - | - | - | - | 90169 | 22896000000 | -122.42944719 | 37.7922169 | - | 1423612800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569020000 | LAGUNA ST | - | - | - | - | - | - |
| 73053 | N/A | Point | - | - | - | - | S105004 | SAN BRUNO AVE: BACON ST | - | F | F | - | F | 33647000 | 33647000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SAN BRUNO AVE | BACON ST | 79793 | 79793 | 37.727566951 | -122.403496777 | BACON ST \ SAN BRUNO AVE | SAN BRUNO AVE \ BACON ST | 1710539427000 | MTA | STOP | BACON ST intersection | - | 0 / 0 | - | - | - | - | - | 90170 | 40435200000 | -122.40359289 | 37.72763413 | - | 769219200000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569080000 | SAN BRUNO AVE | - | - | - | - | - | - |
| 73054 | N/A | Point | - | - | - | - | S252499 | 4TH TI ST: AVENUE M | - | F | F | - | F | 34050000 | 34050000 | - | - | SOUTH WEST CORNER | - | - | - | - | 4TH TI ST | 04TH TI ST | 79940 | 79940 | 37.82287666 | -122.36535265 | AVENUE M \ 4TH TI ST | AVENUE M \ 04TH TI ST | 1710539427000 | MTA | 4TH ST (TI) | 04TH TI ST intersection | - | - | - | - | - | - | - | 90171 | 1561637820000 | -122.36535265 | 37.82287666 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.1969 | 36X08 | SUP1 | 2IN IRON POST | IS | 1552725900000 | AVENUE M | - | - | - | - | - | - |
| 73055 | N/A | Point | - | - | - | - | S257792 | COTTER ST: CAYUGA AVE | - | F | F | - | F | 21798000 | 21798000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | COTTER ST | COTTER ST | 88357 | 88357 | 37.72867091 | -122.43574963 | CAYUGA AVE \ COTTER ST | CAYUGA AVE \ COTTER ST | 1720747335000 | middleware_editor | SPEED HUMPS | COTTER ST intersection | - | EPL 204 | - | - | - | - | - | 90172 | 213235200000 | -122.43574963 | 37.72867091 | - | 1569196800000 | - | D11 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1568712120000 | CAYUGA AVE | - | - | - | - | - | - |
| 73056 | N/A | Point | - | - | - | - | S257793 | COTTER ST: SAN JOSE AVE | - | T | T | - | F | 21811000 | 21811000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | COTTER ST | COTTER ST | 88358 | 88358 | 37.73025234 | -122.43748575 | SAN JOSE AVE \ COTTER ST | SAN JOSE AVE \ COTTER ST | 1710539427000 | MTA | SPEED HUMPS | COTTER ST intersection | - | CROSS STREET IS SAN JOSE | - | - | - | - | - | 90173 | 213235200000 | -122.43748575 | 37.73025234 | - | 1569542400000 | - | D11 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1568712900000 | SAN JOSE AVE | - | - | - | - | - | - |
| 73057 | N/A | Point | - | - | - | - | S268362 | KANSAS ST: 17TH ST | - | F | F | - | F | 7728000 | 23774000 | - | - | SOUTH WEST CORNER | - | - | - | - | 17TH ST | 17TH ST | 88369 | 88369 | 37.764631163 | -122.403618895 | - | KANSAS ST \ 17TH ST | 1710539427000 | MTA | PARK AT 90 DEGREES | 17TH ST intersection | - | - | - | - | - | - | - | 90174 | 1618841520000 | -122.40352703 | 37.76472287 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0372 | 18X18 | SUP1 | MUNI POLE | IS | 1600785960000 | KANSAS ST | 400 - 499 KANSAS ST | - | - | - | MARIPOSA ST | - |
| 73058 | N/A | Point | - | - | - | - | S268363 | KANSAS ST: 17TH ST | - | F | F | - | F | 7728000 | 23774000 | - | - | SOUTH WEST CORNER | - | - | - | - | 17TH ST | 17TH ST | 88370 | 88370 | 37.764631031 | -122.403618896 | - | KANSAS ST \ 17TH ST | 1710539427000 | MTA | NPRK 9AM-11AM MON STCL | 17TH ST intersection | - | 10' SOUTH OF 17TH ST. | - | - | - | - | - | 90175 | 1618838460000 | -122.40352703 | 37.76472287 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0300 | 18X18 | SUP1 | MUNI POLE | IS | 1600786020000 | KANSAS ST | 400 - 499 KANSAS ST | - | - | - | MARIPOSA ST | - |
| 73059 | N/A | Point | 1 | 1 | 400 - 499 | - | S268364 | 400-499 KANSAS ST | 400-499 KANSAS ST | F | F | - | F | 7728000 | 7728000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 88371 | 88371 | 37.764595032 | -122.403436243 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM WED STCL | 17TH ST to MARIPOSA ST (400 - 499) | - | 13' SOUTH OF 17TH ST. | - | - | - | - | - | 90176 | 1618489320000 | -122.40346977 | 37.76408402 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0312 | 18X18 | SUP1 | MUNI POLE | IS | 1600786320000 | KANSAS ST | 400 - 499 KANSAS ST | 400 - 499 KANSAS ST | 400 KANSAS ST | - | MARIPOSA ST | MARIPOSA ST |
| 73060 | N/A | Point | 1 | 1 | 400 - 499 | - | S268365 | 400-499 KANSAS ST | 400-499 KANSAS ST | F | F | - | F | 7728000 | 7728000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 88372 | 88372 | 37.764001325 | -122.403385281 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM WED STCL | 17TH ST to MARIPOSA ST (400 - 499) | - | 165' NORTH OF MARIPOSA ST. | - | - | - | - | - | 90177 | - | -122.40346977 | 37.76408402 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0312 | 18X18 | SUP1 | LIGHT POLE | IS | 1600786440000 | KANSAS ST | 400 - 499 KANSAS ST | 400 - 499 KANSAS ST | 400 KANSAS ST | - | MARIPOSA ST | MARIPOSA ST |
| 73061 | N/A | Point | 1 | 1 | 400 - 499 | - | S268366 | 400-499 KANSAS ST | 400-499 KANSAS ST | F | F | - | F | 7728000 | 7728000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 88373 | 88373 | 37.763633435 | -122.403345047 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM WED STCL | 17TH ST to MARIPOSA ST (400 - 499) | - | 30' NORTH OF MARIPOSA ST. | - | - | - | - | - | 90178 | - | -122.40346977 | 37.76408402 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0312 | 18X18 | SUP1 | LIGHT POLE | IS | 1600786440000 | KANSAS ST | 400 - 499 KANSAS ST | 400 - 499 KANSAS ST | 400 KANSAS ST | - | MARIPOSA ST | MARIPOSA ST |
| 73062 | N/A | Point | 1 | 1 | 500 - 599 | - | S255576 | 500-599 VALENCIA ST | 500-599 VALENCIA ST | F | F | - | F | 13060000 | 13060000 | - | - | WEST SIDE | - | - | - | - | 16TH ST | 16TH ST | 88560 | 88560 | 37.764682497 | -122.421978853 | - | - | 1710539427000 | MTA | GETAROUND | 16TH ST to 17TH ST (500 - 599) | - | 10' N OF 17TH ST | - | - | - | - | - | 90179 | 1562926140000 | -122.42180898 | 37.76410858 | - | 1588550400000 | - | D9 | - | OTHER GUIDE | GUIDE | G-G(SF).0037 | 05X12 | SUP2 | 2IN IRON POST | IS | 1561370820000 | VALENCIA ST | 500 - 599 VALENCIA ST | 500 - 599 VALENCIA ST | 500 VALENCIA ST | - | 17TH ST | 17TH ST |
| 73063 | N/A | Point | 1 | 1 | 500 - 599 | - | S255577 | 500-599 VALENCIA ST | 500-599 VALENCIA ST | F | F | - | F | 13060000 | 13060000 | - | - | WEST SIDE | - | - | - | - | 16TH ST | 16TH ST | 88561 | 88561 | 37.764722077 | -122.421977065 | - | - | 1710539427000 | MTA | TA (SYM) NO STOPPING EXC PERMITTEDÂ CSV-GETAROUND | 16TH ST to 17TH ST (500 - 599) | - | 10' N OF 17TH ST | - | - | - | - | - | 90180 | 1562926140000 | -122.42180898 | 37.76410858 | - | 1604448000000 | - | D9 | - | OTHER REGULATORY | REG | R37(SF).0293 | 05X12 | SUP2 | 2IN IRON POST | IS | 1561371000000 | VALENCIA ST | 500 - 599 VALENCIA ST | 500 - 599 VALENCIA ST | 500 VALENCIA ST | - | 17TH ST | 17TH ST |
| 73064 | N/A | Point | - | - | - | - | S258133 | HYDE ST: TURK ST | - | T | T | - | F | 24933000 | 24933000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HYDE ST | TURK ST | 88642 | 88642 | 37.782480917 | -122.415758595 | TURK ST \ HYDE ST | HYDE ST \ TURK ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | TURK ST intersection | - | - | - | - | - | - | - | 90181 | 1315526400000 | -122.41569387 | 37.78258503 | - | 1571356800000 | - | D6 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | 1570113840000 | HYDE ST | - | - | - | - | - | - |
| 73065 | N/A | Point | - | - | - | - | S258134 | HYDE ST: TURK ST | - | T | T | - | F | 24933000 | 24933000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HYDE ST | TURK ST | 88643 | 88643 | 37.782491756 | -122.415762937 | TURK ST \ HYDE ST | HYDE ST \ TURK ST | 1710539427000 | MTA | TURK ST | TURK ST intersection | - | - | - | - | - | - | - | 90182 | 1315526400000 | -122.41569387 | 37.78258503 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-2.0340 | 72X18 | SUP1 | LIGHT POLE | IS | 1570113960000 | HYDE ST | - | - | - | - | - | - |
| 73066 | N/A | Point | - | - | - | - | S257795 | SAN JUAN AVE: CAYUGA AVE | - | F | F | - | F | 21800000 | 21800000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CAYUGA AVE | CAYUGA AVE | 88675 | 88675 | 37.72509446 | -122.43793363 | SAN JUAN AVE \ CAYUGA AVE | SAN JUAN AVE \ CAYUGA AVE | 1726190641000 | middleware_editor | SPEED HUMP | CAYUGA AVE intersection | - | - | - | - | - | - | - | 90183 | 1102291200000 | -122.43793363 | 37.72509446 | - | 1569283200000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1568713500000 | SAN JUAN AVE | - | - | - | - | - | - |
| 73067 | N/A | Point | 1 | 1 | 1500 - 1699 | - | S253366 | 1500-1699 MARIPOSA ST | 1500-1699 MARIPOSA ST | F | F | - | F | 8722000 | 8722000 | - | - | NORTH SIDE | - | - | - | - | ARKANSAS ST | ARKANSAS ST | 90139 | 90139 | 37.76367744 | -122.39954733 | - | - | 1710539427000 | MTA | SPEED HUMP | ARKANSAS ST to CAROLINA ST (1500 - 1699) | - | 60' WEST OF ARKANSAS ST. | - | - | - | - | - | 90184 | 1566382260000 | -122.39954733 | 37.76367744 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1554810000000 | MARIPOSA ST | 1500 - 1699 MARIPOSA ST | 1500 - 1699 MARIPOSA ST | 1500 MARIPOSA ST | - | CAROLINA ST | CAROLINA ST |
| 73068 | N/A | Point | 1 | 1 | 500 - 630 | - | S253369 | 500-630 MISSOURI ST | 500-630 MISSOURI ST | F | F | - | F | 9212000 | 9212000 | - | - | EAST SIDE | - | - | - | - | 20TH ST | 20TH ST | 90142 | 90142 | 37.75916315 | -122.39617031 | - | - | 1710539427000 | MTA | SPEED HUMP | 20TH ST to SIERRA ST (500 - 630) | - | 40' NORTH OF SIERRA ST. | - | - | - | - | - | 90185 | 1566345600000 | -122.39617031 | 37.75916315 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1554811920000 | MISSOURI ST | 500 - 630 MISSOURI ST | 500 - 630 MISSOURI ST | 500 MISSOURI ST | - | SIERRA ST | SIERRA ST |
| 73069 | N/A | Point | 1 | 1 | 800 - 847 | - | S242786 | 800-847 VALENCIA ST | 800-847 VALENCIA ST | F | F | - | F | 13065000 | 13065000 | - | - | WEST SIDE | - | - | - | - | 19TH ST | 19TH ST | 90153 | 90153 | 37.758955466 | -122.421434576 | - | - | 1710539427000 | MTA | BIKE RACK | 19TH ST to CUNNINGHAM PL (800 - 847) | 04899 | 16FT. 8IN. NORTH OF SPL#870(BORDERLANDS) | - | - | - | - | - | 90186 | 1520343780000 | -122.42139032 | 37.75973688 | - | 1520294400000 | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1517826360000 | VALENCIA ST | 800 - 847 VALENCIA ST | 800 - 847 VALENCIA ST | 800 VALENCIA ST | - | CUNNINGHAM PL | CUNNINGHAM PL |
| 73070 | N/A | Point | - | - | - | - | S270870 | CHENERY ST: BURNSIDE AVE | - | T | T | - | F | 21974000 | 21974000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BURNSIDE AVE | BURNSIDE AVE | 90170 | 90170 | 37.73541625 | -122.43807771 | CHENERY ST \ BURNSIDE AVE | CHENERY ST \ BURNSIDE AVE | 1748634563000 | middleware_editor | SPEED HUMPS AHEAD | BURNSIDE AVE intersection | - | NECORNER, WPL #954 ABOVE SIGNS | - | - | - | - | - | 90187 | 1082703600000 | -122.43807771 | 37.73541625 | - | 1616396400000 | - | D8 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1608196020000 | CHENERY ST | - | - | - | - | - | - |
| 73071 | N/A | Point | 1 | 1 | 3800 - 3899 | - | S270881 | 3800-3899 21ST ST | 3800-3899 21ST ST | F | F | - | F | 1123000 | 1123000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | NOE ST | NOE ST | 90171 | 90171 | 37.75615974 | -122.43343859 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | NOE ST to CASTRO ST (3800 - 3899) | - | 50 FT EAST OF CASTRO | - | - | - | - | - | 90188 | 1222128000000 | -122.43343859 | 37.75615974 | - | 1609804800000 | - | D8 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1608208800000 | 21ST ST | 3800 - 3899 21ST ST | 3800 - 3899 21ST ST | 3800 21ST ST | - | CASTRO ST | CASTRO ST |
| 73072 | N/A | Point | 1 | 1 | 4100 - 4199 | - | S270885 | 4100-4199 23RD ST | 4100-4199 23RD ST | F | F | - | F | 1283000 | 1283000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | CASTRO ST | CASTRO ST | 90172 | 90172 | 37.75282543 | -122.43534701 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | CASTRO ST to DIAMOND ST (4100 - 4199) | - | 15 FT WEST OF CASTRO | - | - | - | - | - | 90189 | 1222214400000 | -122.43534701 | 37.75282543 | - | 1615161600000 | - | D8 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1608210120000 | 23RD ST | 4100 - 4199 23RD ST | 4100 - 4199 23RD ST | 4100 23RD ST | - | DIAMOND ST | DIAMOND ST |
| 73073 | N/A | Point | - | - | - | - | S254692 | 16TH ST: VALENCIA ST | - | F | F | - | F | 24183000 | 24183000 | - | - | SOUTH EAST CORNER | - | - | - | - | VALENCIA ST | 16TH ST | 90180 | 90180 | 37.764894056 | -122.421710765 | 16TH ST \ VALENCIA ST | VALENCIA ST \ 16TH ST | 1721920301000 | middleware_editor | FG 300 UR DELINEATOR (W) | 16TH ST intersection | - | - | - | - | - | - | - | 90190 | 1317340800000 | -122.42188645 | 37.76491738 | - | 1721829900000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1559204820000 | VALENCIA ST | - | - | - | - | - | - |
| 73074 | N/A | Point | 1 | 1 | 200 - 299 | - | S255999 | 200-299 9TH AVE | 200-299 09TH AVE | F | F | - | F | 424000 | 424000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 90196 | 90196 | 37.78373545 | -122.46769668 | - | - | 1742244013000 | middleware_editor | SPEED HUMPS | CALIFORNIA ST to CLEMENT ST (200 - 299) | - | NPL 298 | - | - | - | - | - | 90191 | 1565728740000 | -122.46769668 | 37.78373545 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1562831220000 | 09TH AVE | 200 - 299 9TH AVE | 200 - 299 09TH AVE | 200 9TH AVE | - | CLEMENT ST | CLEMENT ST |
| 73075 | N/A | Point | 1 | 1 | 200 - 299 | - | S256000 | 200-299 9TH AVE | 200-299 09TH AVE | F | F | - | F | 424000 | 424000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 90197 | 90197 | 37.78373545 | -122.46769668 | - | - | 1741971636000 | middleware_editor | SPEED HUMPS | CALIFORNIA ST to CLEMENT ST (200 - 299) | - | 5FT SO OF CALIF | - | - | - | - | - | 90192 | 1565728860000 | -122.46769668 | 37.78373545 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1562831400000 | 09TH AVE | 200 - 299 9TH AVE | 200 - 299 09TH AVE | 200 9TH AVE | - | CLEMENT ST | CLEMENT ST |
| 73076 | N/A | Point | - | - | - | - | S259458 | CALIFORNIA ST: 21ST AVE | - | F | F | - | F | 27643000 | 27643000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 90200 | 90200 | 37.784065716 | -122.480734251 | 21ST AVE \ CALIFORNIA ST | 21ST AVE \ CALIFORNIA ST | 1710539427000 | MTA | STATE LAW YIELD TO PEDS (SYM) | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 90193 | 1444780800000 | -122.48072531 | 37.78407661 | - | 1574726400000 | - | D1 | - | OTHER REGULATORY | REG | R1-6.0001 | 12X36 | SUP2 | 2IN IRON POST | IS | 1574504280000 | 21ST AVE | - | - | - | - | - | - |
| 73077 | N/A | Point | - | - | - | - | S256556 | AMAZON AVE: MOSCOW ST | - | F | F | - | F | 21399000 | 21399000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | AMAZON AVE | AMAZON AVE | 90248 | 90248 | 37.714425834 | -122.432929132 | MOSCOW ST \ AMAZON AVE | MOSCOW ST \ AMAZON AVE | 1710539427000 | MTA | STOP | AMAZON AVE intersection | - | AT MOSCOW | - | - | - | - | - | 90194 | 130982400000 | -122.43277714 | 37.71443715 | - | 1564358400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1564481400000 | MOSCOW ST | - | - | - | - | - | - |
| 73078 | N/A | Point | 1 | 1 | 5 - 40 | - | S266848 | 5-40 SOUTH HILL BLVD | 5-40 SOUTH HILL BLVD | F | F | - | F | 12001000 | 12001000 | - | - | EAST SIDE | - | - | - | - | MUNICH ST | MUNICH ST | 92079 | 92079 | 37.712025155 | -122.432091473 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM THUR STCL | MUNICH ST to PRAGUE ST (5 - 40) | - | NPL 15 | - | - | - | - | - | 90195 | 1431043200000 | -122.43262255 | 37.71250187 | - | 1597017600000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0080 | 18X18 | SUP2 | 2IN IRON POST | IS | 1596549540000 | SOUTH HILL BLVD | 5 - 40 SOUTH HILL BLVD | 5 - 40 SOUTH HILL BLVD | 5 SOUTH HILL BLVD | - | PRAGUE ST | PRAGUE ST |
| 73079 | N/A | Point | 1 | 1 | 400 - 499 | - | S284003 | 400-499 KANSAS ST | 400-499 KANSAS ST | F | F | - | F | 7728000 | 7728000 | - | - | WEST SIDE | - | - | - | - | 17TH ST | 17TH ST | 92123 | 92123 | 37.764443425 | -122.403597175 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "X" PERMITS | 17TH ST to MARIPOSA ST (400 - 499) | - | 70' SOUTH OF 17TH ST. | - | - | - | - | - | 90196 | 1658102400000 | -122.40346977 | 37.76408402 | - | - | - | D10 | - | PARKING: RPP | REG | R32C(CA).0106 | 18X21 | SUP1 | 2IN IRON POST | IS | 1657701720000 | KANSAS ST | 400 - 499 KANSAS ST | 400 - 499 KANSAS ST | 400 KANSAS ST | - | MARIPOSA ST | MARIPOSA ST |
| 73080 | N/A | Point | 1 | 1 | 548 - 586 | - | S254553 | 548-586 3RD ST | 548-586 03RD ST | F | F | - | F | 177000 | 177000 | - | - | EAST SIDE | - | - | - | - | SOUTH PARK | SOUTH PARK | 92153 | 92153 | 37.780496565 | -122.394659337 | - | - | 1710539427000 | MTA | SPECIAL EVENT AREA CHECK YOUR METER (SFPARK) | SOUTH PARK to VARNEY PL (548 - 586) | - | 30' NORTH OF VARNEY | - | - | - | - | - | 90197 | 1167782400000 | -122.39484821 | 37.78052748 | - | 1690366980000 | - | D6 | - | OTHER GUIDE | GUIDE | G-S(SF).0058 | 18X18 | SUP1 | LIGHT POLE | IS | 1558520760000 | 03RD ST | 548 - 586 03RD ST | 548 - 586 03RD ST | 548 3RD ST | - | VARNEY PL | VARNEY PL |
| 73081 | N/A | Point | - | - | - | - | S271384 | OAKDALE AVE: BAY SHORE BLVD | - | F | F | - | F | 20816000 | 20816000 | - | - | NORTH EAST CORNER | - | - | - | - | OAKDALE AVE | BAY SHORE BLVD | 92207 | 92207 | 37.743057573 | -122.405286646 | BAY SHORE BLVD \ OAKDALE AVE | OAKDALE AVE \ BAY SHORE BLVD | 1710539427000 | MTA | REMOVE (SF BIKE ROUTE) GREEN (SYM) # | BAY SHORE BLVD intersection | 1117 | '170' | - | - | - | - | - | 90198 | - | -122.40524239 | 37.74305121 | - | - | - | D10 | - | BIKE REG | REG | R(SF).0388 | 12X24 | SUP1 | 2IN IRON POST | IS | 1610105520000 | OAKDALE AVE | - | - | - | - | - | - |
| 73082 | N/A | Point | - | - | - | - | S271385 | OAKDALE AVE: BAY SHORE BLVD | - | F | F | - | F | 20816000 | 20816000 | - | - | NORTH EAST CORNER | - | - | - | - | OAKDALE AVE | BAY SHORE BLVD | 92208 | 92208 | 37.743060754 | -122.405287988 | BAY SHORE BLVD \ OAKDALE AVE | OAKDALE AVE \ BAY SHORE BLVD | 1710539427000 | MTA | REMOVE (SF BIKE ROUTE) GREEN (SYM) # | BAY SHORE BLVD intersection | 1117 | 25 | - | - | - | - | - | 90199 | - | -122.40524239 | 37.74305121 | - | - | - | D10 | - | BIKE REG | REG | R(SF).0388 | 12X24 | SUP1 | 2IN IRON POST | IS | 1610105520000 | OAKDALE AVE | - | - | - | - | - | - |
| 73083 | N/A | Point | - | - | - | - | S271386 | OAKDALE AVE: BAY SHORE BLVD | - | F | F | - | F | 20816000 | 20816000 | - | - | NORTH EAST CORNER | - | - | - | - | OAKDALE AVE | BAY SHORE BLVD | 92209 | 92209 | 37.74303 | -122.405022449 | BAY SHORE BLVD \ OAKDALE AVE | OAKDALE AVE \ BAY SHORE BLVD | 1710539427000 | MTA | BIKE (SYM) BIKE ROUTE | BAY SHORE BLVD intersection | 1117 | '170' | - | - | - | - | - | 90200 | 1610364420000 | -122.40524239 | 37.74305121 | - | - | - | D10 | - | BIKE GUIDE | GUIDE | D11-1C.0002 | 24X18 | SUP1 | 2IN IRON POST | IS | 1610105580000 | OAKDALE AVE | - | - | - | - | - | - |
| 73084 | N/A | Point | - | - | - | - | S271387 | OAKDALE AVE: BAY SHORE BLVD | - | F | F | - | F | 20816000 | 20816000 | - | - | NORTH EAST CORNER | - | - | - | - | OAKDALE AVE | BAY SHORE BLVD | 92210 | 92210 | 37.74303 | -122.405018426 | BAY SHORE BLVD \ OAKDALE AVE | OAKDALE AVE \ BAY SHORE BLVD | 1710539427000 | MTA | (LA) WHITE ON GREEN | BAY SHORE BLVD intersection | 1117 | '170' | - | - | - | - | - | 90201 | 1610371200000 | -122.40524239 | 37.74305121 | - | - | - | D10 | - | OTHER GUIDE | GUIDE | M7-1.0002 | 12X09 | SUP1 | 2IN IRON POST | IS | 1610105640000 | OAKDALE AVE | - | - | - | - | - | - |
| 73085 | N/A | Point | 1 | 1 | 100 - 199 | - | S271466 | 100-199 DEL VALE AVE | 100-199 DEL VALE AVE | F | F | - | F | 4672000 | 4672000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | ENCLINE CT | ENCLINE CT | 92211 | 92211 | 37.74120093 | -122.44699363 | - | - | 1710539427000 | MTA | SPEED HUMP | ENCLINE CT to OSHAUGHNESSY BLVD (100 - 199) | - | 100 FT WEST OF OSHOUGHNESSY | - | - | - | - | - | 90202 | 1358985600000 | -122.44699363 | 37.74120093 | - | - | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1610532180000 | DEL VALE AVE | 100 - 199 DEL VALE AVE | 100 - 199 DEL VALE AVE | 100 DEL VALE AVE | - | OSHAUGHNESSY BLVD | OSHAUGHNESSY BLVD |
| 73086 | N/A | Point | - | - | - | - | S284059 | FOLSOM ST: 20TH ST | - | F | F | - | F | 24122000 | 24122000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | 20TH ST | FOLSOM ST | 92229 | 92229 | 37.75889599 | -122.41469003 | FOLSOM ST \ 20TH ST | 20TH ST \ FOLSOM ST | 1745857824000 | mmadsen | TREE TOP 6FT SPEED BUMP | FOLSOM ST intersection | - | MIDDLE OF CROSSWALK | - | - | - | - | - | 90203 | 1679641200000 | -122.41469003 | 37.75889599 | - | - | - | D9 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP2 | ANCHORS | IS | 1658224200000 | 20TH ST | - | - | - | - | - | - |
| 73087 | N/A | Point | - | - | - | - | S284060 | FOLSOM ST: 20TH ST | - | F | F | - | F | 24122000 | 24122000 | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | - | - | - | - | 20TH ST | FOLSOM ST | 92230 | 92230 | 37.75889599 | -122.41469003 | FOLSOM ST \ 20TH ST | 20TH ST \ FOLSOM ST | 1745866376000 | middleware_editor | TREE TOP 6FT SPEED BUMP | FOLSOM ST intersection | - | MIDDLE OF CROSSWALK | - | - | - | - | - | 90204 | 1679641200000 | -122.41469003 | 37.75889599 | - | - | - | D9 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP2 | ANCHORS | IS | 1658224260000 | 20TH ST | - | - | - | - | - | - |
| 73088 | N/A | Point | - | - | - | - | S284061 | 20TH ST: FOLSOM ST | - | F | F | - | F | 24122000 | 24122000 | - | - | CENTER ISLAND, W LINE, WESTBOUND | - | - | - | - | 20TH ST | FOLSOM ST | 92231 | 92231 | 37.75889599 | -122.41469003 | FOLSOM ST \ 20TH ST | 20TH ST \ FOLSOM ST | 1745863167000 | elclark | TREE TOP 6FT SPEED BUMP | FOLSOM ST intersection | - | MIDDLE OF CROSSWALK | - | - | - | - | - | 90205 | 1679641200000 | -122.41469003 | 37.75889599 | - | - | - | D9 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP2 | ANCHORS | IS | 1658224440000 | 20TH ST | - | - | - | - | - | - |
| 73089 | N/A | Point | - | - | - | - | S284062 | 20TH ST: FOLSOM ST | - | F | F | - | F | 24122000 | 24122000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | 20TH ST | FOLSOM ST | 92232 | 92232 | 37.75889599 | -122.41469003 | FOLSOM ST \ 20TH ST | 20TH ST \ FOLSOM ST | 1745866368000 | middleware_editor | TREE TOP 6FT SPEED BUMP | FOLSOM ST intersection | - | MIDDLE OF CROSSWALK | - | - | - | - | - | 90206 | 1679641200000 | -122.41469003 | 37.75889599 | - | - | - | D9 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP2 | ANCHORS | IS | 1658224440000 | 20TH ST | - | - | - | - | - | - |
| 73090 | N/A | Point | 1 | 1 | 3264 - 3299 | - | S283325 | 3264-3299 21ST ST | 3264-3299 21ST ST | F | F | - | F | 1112000 | 1112000 | - | - | NORTH SIDE | - | - | - | - | LEXINGTON ST | LEXINGTON ST | 93958 | 93958 | 37.756982716 | -122.420951234 | - | - | 1710539427000 | MTA | BIKE RACK | LEXINGTON ST to VALENCIA ST (3264 - 3299) | 527448 | 20' E OF WPL 3298/3.5' IN FROM CURB | - | - | - | - | - | 90207 | 1656374400000 | -122.42072794 | 37.75692546 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1654766460000 | 21ST ST | 3264 - 3299 21ST ST | 3264 - 3299 21ST ST | 3264 21ST ST | - | VALENCIA ST | VALENCIA ST |
| 73091 | N/A | Point | - | - | - | - | S265263 | ANZAVISTA AVE: VEGA ST | - | F | F | - | F | 26397000 | 26397000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VEGA ST | ANZAVISTA AVE | 94032 | 94032 | 37.78012504 | -122.44544023 | ANZAVISTA AVE \ VEGA ST | VEGA ST \ ANZAVISTA AVE | 1710539427000 | MTA | SPEED HUMPS | ANZAVISTA AVE intersection | - | - | - | - | - | - | - | 90208 | 1592870400000 | -122.44544023 | 37.78012504 | - | - | - | D2 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1592483160000 | VEGA ST | - | - | - | - | - | - |
| 73092 | N/A | Point | 1 | 1 | 150 - 249 | - | S265265 | 150-249 ANZAVISTA AVE | 150-249 ANZAVISTA AVE | F | F | - | F | 2368000 | 2368000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | BARCELONA AVE | BARCELONA AVE | 94034 | 94034 | 37.77958236 | -122.44516207 | - | - | 1710539427000 | MTA | SPEED HUMPS | BARCELONA AVE to VEGA ST (150 - 249) | - | 20' WEST OF BARCELONA AVE | - | - | - | - | - | 90209 | 1592870400000 | -122.44516207 | 37.77958236 | - | - | - | D2 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1592484120000 | ANZAVISTA AVE | 150 - 249 ANZAVISTA AVE | 150 - 249 ANZAVISTA AVE | 150 ANZAVISTA AVE | - | VEGA ST | VEGA ST |
| 73093 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S265275 | 1100-1199 FITZGERALD AVE | 1100-1199 FITZGERALD AVE | T | T | - | F | 5599000 | 5599000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | HAWES ST | HAWES ST | 94036 | 94036 | 37.72045171 | -122.39038277 | - | - | 1710539427000 | MTA | SPEED HUMPS | HAWES ST to INGALLS ST (1100 - 1199) | - | WPL# 1108 | - | - | - | - | - | 90210 | 1593076980000 | -122.39038277 | 37.72045171 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1592491920000 | FITZGERALD AVE | 1100 - 1199 FITZGERALD AVE | 1100 - 1199 FITZGERALD AVE | 1100 FITZGERALD AVE | - | INGALLS ST | INGALLS ST |
| 73094 | N/A | Point | - | - | - | - | S280968 | VALENCIA ST: BROSNAN ST | - | F | F | - | F | 24382000 | 24382000 | - | - | CENTER ISLAND | - | - | - | - | BROSNAN ST | BROSNAN ST | 94081 | 94081 | 37.76875414 | -122.42225816 | VALENCIA ST \ BROSNAN ST | VALENCIA ST \ BROSNAN ST | 1721059500000 | middleware_editor | TREE TOP 6FT SPEED BUMP | BROSNAN ST intersection | - | AT INTERSECTION IN FRONT OF SHARK TEETH | - | - | - | - | - | 90211 | 1657065600000 | -122.42225816 | 37.76875414 | - | - | - | D8 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP2 | ANCHORS | IS | 1645090980000 | VALENCIA ST | - | - | - | - | - | - |
| 73095 | N/A | Point | 1 | 1 | 1600 - 1799 | - | S272061 | 1600-1799 18TH ST | 1600-1799 18TH ST | F | F | - | F | 858000 | 858000 | - | - | SOUTH SIDE | - | - | - | - | ARKANSAS ST | ARKANSAS ST | 94093 | 94093 | 37.76240466 | -122.39942518 | - | - | 1737496850000 | middleware_editor | SPEED HUMPS AHEAD | ARKANSAS ST to CAROLINA ST (1600 - 1799) | - | 30' E OF CAROLINA | - | - | - | - | - | 90212 | 1613121720000 | -122.39942518 | 37.76240466 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1612190160000 | 18TH ST | 1600 - 1799 18TH ST | 1600 - 1799 18TH ST | 1600 18TH ST | - | CAROLINA ST | CAROLINA ST |
| 73096 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S269158 | 1200-1299 FELL ST | 1200-1299 FELL ST | F | F | - | F | 5451000 | 5451000 | - | - | SOUTH SIDE | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 94127 | 94127 | 37.773920458 | -122.438878228 | - | - | 1710539427000 | MTA | BIKE RACK | DIVISADERO ST to BRODERICK ST (1200 - 1299) | 154334 | 11' E OF WPL 1221/2.5' IN FROM CURB | - | - | - | - | - | 90213 | 1602774960000 | -122.43844371 | 37.77395438 | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1602746220000 | FELL ST | 1200 - 1299 FELL ST | 1200 - 1299 FELL ST | 1200 FELL ST | - | BRODERICK ST | BRODERICK ST |
| 73097 | N/A | Point | 1 | 1 | 400 - 499 | - | S284008 | 400-499 KANSAS ST | 400-499 KANSAS ST | F | F | - | F | 7728000 | 7728000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 94146 | 94146 | 37.764308782 | -122.403410761 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "X" PERMITS | 17TH ST to MARIPOSA ST (400 - 499) | - | 125' SOUTH OF 17TH ST. | - | - | - | - | - | 90214 | 1658102400000 | -122.40346977 | 37.76408402 | - | - | - | D10 | - | PARKING: RPP | REG | R32C(CA).0106 | 18X21 | SUP1 | LIGHT POLE | IS | 1657702440000 | KANSAS ST | 400 - 499 KANSAS ST | 400 - 499 KANSAS ST | 400 KANSAS ST | - | MARIPOSA ST | MARIPOSA ST |
| 73098 | N/A | Point | 1 | 1 | 400 - 499 | - | S284009 | 400-499 KANSAS ST | 400-499 KANSAS ST | F | F | - | F | 7728000 | 7728000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 94147 | 94147 | 37.764606694 | -122.403437583 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "X" PERMITS | 17TH ST to MARIPOSA ST (400 - 499) | - | 13' SOUTH OF 17TH ST. | - | - | - | - | - | 90215 | 1658102400000 | -122.40346977 | 37.76408402 | - | - | - | D10 | - | PARKING:RPP | REG | R32C(CA).0106 | 18X21 | SUP1 | MUNI POLE | IS | 1657702500000 | KANSAS ST | 400 - 499 KANSAS ST | 400 - 499 KANSAS ST | 400 KANSAS ST | - | MARIPOSA ST | MARIPOSA ST |
| 73099 | N/A | Point | 1 | 1 | 0 - 0 | - | S269506 | 1-4 MASONIC AVE | 0-0 MASONIC AVE | T | T | - | F | 8841000 | 8841000 | - | - | WEST SIDE | - | - | - | - | PINE ST \ PRESIDIO AVE | PINE ST \ PRESIDIO AVE | 94150 | 94150 | 37.785334993 | -122.447742374 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM WED STCL | PINE ST \ PRESIDIO AVE to EUCLID AVE (0 - 0) | - | 50' N OF EUCLID | - | - | - | - | - | 90216 | 1603985580000 | -122.44721532 | 37.78574093 | - | - | - | D2 | - | STREET CLEANING | REG | R30B(CA).0199 | 18X18 | SUP1 | LIGHT POLE | IS | 1603724580000 | MASONIC AVE | 0 - 0 MASONIC AVE | 0 - 0 MASONIC AVE | 0 MASONIC AVE | - | EUCLID AVE | EUCLID AVE |
| 73100 | N/A | Point | 1 | 1 | 0 - 0 | - | S269507 | 1-4 MASONIC AVE | 0-0 MASONIC AVE | T | T | - | F | 8841000 | 8841000 | - | - | WEST SIDE | - | - | - | - | PINE ST \ PRESIDIO AVE | PINE ST \ PRESIDIO AVE | 94151 | 94151 | 37.785841619 | -122.447277011 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM WED STCL | PINE ST \ PRESIDIO AVE to EUCLID AVE (0 - 0) | - | 100' S OF PRESIDIO | - | - | - | - | - | 90217 | - | -122.44721532 | 37.78574093 | - | 1690276500000 | - | D2 | - | STREET CLEANING | REG | R30B(CA).0199 | 18X18 | SUP1 | LIGHT POLE | IS | 1603724640000 | MASONIC AVE | 0 - 0 MASONIC AVE | 0 - 0 MASONIC AVE | 0 MASONIC AVE | - | EUCLID AVE | EUCLID AVE |
| 73101 | N/A | Point | - | - | - | - | S269822 | ALBION ST: CAMP ST | - | F | F | - | F | 25693000 | 25693000 | - | - | NORTH WEST CORNER | - | - | - | - | CAMP ST | ALBION ST | 94152 | 94152 | 37.764012062 | -122.423280913 | ALBION ST \ CAMP ST | CAMP ST \ ALBION ST | 1742584611000 | middleware_editor | ALBION ST | ALBION ST intersection | - | 100 | - | - | - | - | - | 90218 | 1605201600000 | -122.42277487 | 37.76403892 | - | - | - | D8 | - | STREET NAME | GUIDE | D3-1.0073 | 36X08 | SUP2 | UTILITY POLE | IS | 1604400720000 | CAMP ST | - | - | - | - | - | - |
| 73102 | N/A | Point | - | - | - | - | S269823 | ALBION ST: CAMP ST | - | F | F | - | F | 25693000 | 25693000 | - | - | NORTH WEST CORNER | - | - | - | - | CAMP ST | ALBION ST | 94153 | 94153 | 37.764009235 | -122.423295219 | ALBION ST \ CAMP ST | CAMP ST \ ALBION ST | 1742584613000 | middleware_editor | 16TH ST | ALBION ST intersection | - | 100 | - | - | - | - | - | 90219 | 1605203700000 | -122.42277487 | 37.76403892 | - | - | - | D8 | - | STREET NAME | GUIDE | D3-1.0007 | 36X08 | SUP2 | UTILITY POLE | IS | 1604400900000 | CAMP ST | - | - | - | - | - | - |
| 73103 | N/A | Point | 1 | 1 | 100 - 148 | - | S261991 | 100-148 STEVENSON ST | 100-148 STEVENSON ST | F | F | - | F | 12166000 | 12166000 | - | - | SOUTH SIDE | - | - | - | - | 02ND ST | 02ND ST | 98145 | 98145 | 37.788413078 | -122.401373743 | - | - | 1714772043000 | middleware_editor | TANSAT | 02ND ST to NEW MONTGOMERY ST (100 - 148) | - | 30' EAST OF NEW MONTGOMERY ST. | - | - | - | - | - | 90220 | 1583843580000 | -122.4011611 | 37.78854238 | - | 1690329600000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1582809300000 | STEVENSON ST | 100 - 148 STEVENSON ST | 100 - 148 STEVENSON ST | 100 STEVENSON ST | - | NEW MONTGOMERY ST | NEW MONTGOMERY ST |
| 73104 | N/A | Point | 1 | 1 | 400 - 440 | - | S288133 | 400-440 MURRAY ST | 400-440 MURRAY ST | F | F | - | F | 9461000 | 9461000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | CRESCENT AVE | CRESCENT AVE | 98223 | 98223 | 37.73541751 | -122.42019361 | - | - | 1710539427000 | MTA | SPEED HUMP | CRESCENT AVE to RICHLAND AVE (400 - 440) | - | 23' SOUTH OF RICHLAND @ PAINT MARK. | - | - | - | - | - | 90221 | 1680134400000 | -122.42019361 | 37.73541751 | - | - | - | D9 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1678955580000 | MURRAY ST | 400 - 440 MURRAY ST | 400 - 440 MURRAY ST | 400 MURRAY ST | - | RICHLAND AVE | RICHLAND AVE |
| 73105 | N/A | Point | - | - | - | - | S286942 | MISSION ST: 8TH ST | - | F | F | - | F | 24311000 | 24311000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | 8TH ST | 08TH ST | 98246 | 98246 | 37.77745742 | -122.41315769 | MISSION ST \ 8TH ST | MISSION ST \ 08TH ST | 1756309641000 | middleware_editor | TREE TOP 6FT SPEED BUMP | 08TH ST intersection | - | INSTALL BETWEEN X-WALK AND LIMIT LINE | - | - | - | - | - | 90222 | 1675065600000 | -122.41315769 | 37.77745742 | - | - | - | D6 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1673339340000 | MISSION ST | - | - | - | - | - | - |
| 73106 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S261121 | 1600-1699 IRVING ST | 1600-1699 IRVING ST | F | F | - | F | 7294000 | 7294000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 17TH AVE | 17TH AVE | 98371 | 98371 | 37.763543046 | -122.475792481 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | 17TH AVE to 18TH AVE (1600 - 1699) | 135930 | IFO 1635 | - | - | - | - | - | 90223 | 1567036800000 | -122.47551979 | 37.76363228 | - | - | - | D4 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP2 | BIKE RACK | IS | 1580911500000 | IRVING ST | 1600 - 1699 IRVING ST | 1600 - 1699 IRVING ST | 1600 IRVING ST | - | 18TH AVE | 18TH AVE |
| 73107 | N/A | Point | - | - | - | - | S261861 | MARKET ST: 12TH ST \ PAGE ST | - | T | T | - | F | 30749000 | 30749000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 12TH ST \ MARKET ST | 12TH ST \ PAGE ST | 98410 | 98410 | 37.774193396 | -122.420271179 | PAGE ST \ 12TH ST \ MARKET ST | MARKET ST \ 12TH ST \ PAGE ST | 1710539427000 | MTA | LEFT LANE MUNI, AC TRANSIT & TAXIS ONLY AT ALL TIMES | 12TH ST \ PAGE ST intersection | - | X ST IS 12TH ST, | - | - | - | - | - | 90224 | 1583932560000 | -122.42025428 | 37.77435868 | - | - | - | D5 | - | TRANSIT ONLY(LEFT LANE) | REG | SR60-5(SF).0006 | 30X42 | SUP1 | SIGNAL POLE | IS | 1582635360000 | MARKET ST | - | - | - | - | - | - |
| 73108 | N/A | Point | 1 | 1 | 3500 - 3538 | - | S289592 | 3500-3538 19TH ST | 3500-3538 19TH ST | F | F | - | F | 975000 | 975000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | VALENCIA ST | VALENCIA ST | 98476 | 98476 | 37.760110058 | -122.422100116 | - | - | 1718042709000 | middleware_editor | PLAYGROUND (SYM) | VALENCIA ST to LAPIDGE ST (3500 - 3538) | - | INFO#3524/3526 @ PAINT MARK. | - | - | - | - | - | 90225 | 1684454400000 | -122.42184173 | 37.76007613 | - | - | - | D8 | - | OTHER WARNING | WARNING | W15-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1684329000000 | 19TH ST | 3500 - 3538 19TH ST | 3500 - 3538 19TH ST | 3500 19TH ST | - | LAPIDGE ST | LAPIDGE ST |
| 73109 | N/A | Point | - | - | - | - | S265726 | TUNNEL AVE: BAY SHORE BLVD | - | F | F | - | F | 20296000 | 20296000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TUNNEL AVE | TUNNEL AVE | 98534 | 98534 | 37.713038873 | -122.400531966 | BAY SHORE BLVD \ TUNNEL AVE | BAY SHORE BLVD \ TUNNEL AVE | 1710539427000 | MTA | STOP | TUNNEL AVE intersection | - | 00 / 00 | - | - | - | - | - | 90226 | -400982400000 | -122.40065803 | 37.71305797 | - | 1596412800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1593591480000 | BAY SHORE BLVD | - | - | - | - | - | - |
| 73110 | N/A | Point | - | - | - | - | S267244 | LEAVENWORTH ST: SUTTER ST | - | F | F | - | F | 25164000 | 25164000 | - | - | SOUTH WEST CORNER | - | - | - | - | SUTTER ST | SUTTER ST | 98682 | 98682 | 37.78838793 | -122.41518527 | LEAVENWORTH ST \ SUTTER ST | LEAVENWORTH ST \ SUTTER ST | 1710539427000 | MTA | TREE TOP 6FT SPEED BUMP | SUTTER ST intersection | - | 2 TREE TOP INSIDE CHEVRON PAINT | - | - | - | - | - | 90227 | 1598278860000 | -122.41518527 | 37.78838793 | - | 1598227200000 | - | D3 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1597793520000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 73111 | N/A | Point | 1 | 1 | 3200 - 3299 | - | S259722 | 3200-3299 BAKER ST | 3200-3299 BAKER ST | F | F | - | F | 2638000 | 2638000 | - | - | WEST SIDE | - | - | - | - | FRANCISCO ST | FRANCISCO ST | 98726 | 98726 | 37.80095214 | -122.44643933 | - | - | 1738002751000 | middleware_editor | SPEED HUMPS | FRANCISCO ST to BAY ST (3200 - 3299) | - | 10' S OF BAY ST | - | - | - | - | - | 90228 | 1576145220000 | -122.44643933 | 37.80095214 | - | - | - | D2 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1576061460000 | BAKER ST | 3200 - 3299 BAKER ST | 3200 - 3299 BAKER ST | 3200 BAKER ST | - | BAY ST | BAY ST |
| 73112 | N/A | Point | 1 | 1 | 3200 - 3299 | - | S259723 | 3200-3299 BAKER ST | 3200-3299 BAKER ST | F | F | - | F | 2638000 | 2638000 | - | - | EAST SIDE | - | - | - | - | FRANCISCO ST | FRANCISCO ST | 98727 | 98727 | 37.80095214 | -122.44643933 | - | - | 1738002739000 | middleware_editor | SPEED HUMPS | FRANCISCO ST to BAY ST (3200 - 3299) | - | 100' N OF FRANCISCO | - | - | - | - | - | 90229 | 1576145640000 | -122.44643933 | 37.80095214 | - | - | - | D2 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1576061520000 | BAKER ST | 3200 - 3299 BAKER ST | 3200 - 3299 BAKER ST | 3200 BAKER ST | - | BAY ST | BAY ST |
| 73113 | N/A | Point | - | - | - | - | S267234 | ELLIS ST: LEAVENWORTH ST | - | F | F | - | F | 25139000 | 25139000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 98740 | 98740 | 37.78465714 | -122.4144302 | LEAVENWORTH ST \ ELLIS ST | LEAVENWORTH ST \ ELLIS ST | 1710539427000 | MTA | TREE TOP 6FT SPEED BUMP | ELLIS ST intersection | - | START W-LINE, X-WALK, INSIDE DOUBLE YELL | - | - | - | - | - | 90230 | 1598018340000 | -122.4144302 | 37.78465714 | - | - | - | D6 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1597762440000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 73114 | N/A | Point | - | - | - | - | S267235 | ELLIS ST: LEAVENWORTH ST | - | F | F | - | F | 25139000 | 25139000 | - | - | SOUTH WEST CORNER | - | - | - | - | ELLIS ST | ELLIS ST | 98741 | 98741 | 37.78465714 | -122.4144302 | LEAVENWORTH ST \ ELLIS ST | LEAVENWORTH ST \ ELLIS ST | 1710539427000 | MTA | TREE TOP 6FT SPEED BUMP | ELLIS ST intersection | - | 2 TREE TOP INSIDE CHEVRON PAINT | - | - | - | - | - | 90231 | 1598021340000 | -122.4144302 | 37.78465714 | - | - | - | D6 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1597762620000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 73115 | N/A | Point | - | - | - | - | S285461 | CECILIA AVE: RIVERA ST | - | T | T | - | F | 23187000 | 23187000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CECILIA AVE | CECILIA AVE | 100409 | 100409 | 37.74695166 | -122.47205752 | RIVERA ST \ CECILIA AVE | RIVERA ST \ CECILIA AVE | 1710539427000 | MTA | SPEED HUMPS AHEAD | CECILIA AVE intersection | - | NPL 2207 ABOVE SIGNS | - | - | - | - | - | 90232 | 1667779200000 | -122.47205752 | 37.74695166 | - | - | - | D7 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1665655260000 | RIVERA ST | - | - | - | - | - | - |
| 73116 | N/A | Point | - | - | - | - | S285467 | GRANVILLE WAY: CLAREMONT BLVD | - | F | F | - | F | 22878000 | 22878000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CLAREMONT BLVD | CLAREMONT BLVD | 100413 | 100413 | 37.74292726 | -122.46380396 | GRANVILLE WAY \ CLAREMONT BLVD | GRANVILLE WAY \ CLAREMONT BLVD | 1754329958000 | middleware_editor | SPEED HUMPS AHEAD | CLAREMONT BLVD intersection | - | - | - | - | - | - | - | 90233 | 1671091200000 | -122.46380396 | 37.74292726 | - | - | - | D7 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1665659340000 | GRANVILLE WAY | - | - | - | - | - | - |
| 73117 | N/A | Point | - | - | - | - | S285468 | GRANVILLE WAY: ULLOA ST | - | F | F | - | F | 22868000 | 22868000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ULLOA ST | GRANVILLE WAY | 100414 | 100414 | 37.74089539 | -122.46106994 | GRANVILLE WAY \ ULLOA ST | ULLOA ST \ GRANVILLE WAY | 1710539427000 | MTA | SPEED HUMPS AHEAD | GRANVILLE WAY intersection | - | - | - | - | - | - | - | 90234 | 1671062400000 | -122.46106994 | 37.74089539 | - | - | - | D7 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1665659700000 | ULLOA ST | - | - | - | - | - | - |
| 73118 | N/A | Point | - | - | - | - | S285422 | GENEVA AVE: LONDON ST | - | T | T | - | F | 21475000 | 21475000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LONDON ST | GENEVA AVE | 100488 | 100488 | 37.716184515 | -122.440260504 | GENEVA AVE \ LONDON ST | LONDON ST \ GENEVA AVE | 1710539427000 | MTA | LONDON | GENEVA AVE intersection | - | - | - | - | - | - | - | 90235 | 1678060800000 | -122.44025514 | 37.71603882 | - | - | - | D11 | - | STREET NAME | GUIDE | D3-2.0497 | 72X18 | SUP2 | OVERHEAD MAST ARM | IS | 1665136980000 | LONDON ST | - | - | - | - | - | - |
| 73119 | N/A | Point | - | - | - | - | S285423 | LONDON ST: GENEVA AVE | - | T | T | - | F | 21475000 | 21475000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LONDON ST | GENEVA AVE | 100489 | 100489 | 37.716106717 | -122.440103148 | GENEVA AVE \ LONDON ST | LONDON ST \ GENEVA AVE | 1710539427000 | MTA | GENEVA AVE | GENEVA AVE intersection | - | - | - | - | - | - | - | 90236 | 1678060800000 | -122.44025514 | 37.71603882 | - | - | - | D11 | - | STREET NAME | GUIDE | D3-2.0168 | 72X18 | SUP2 | LIGHT POLE | IS | 1665137160000 | LONDON ST | - | - | - | - | - | - |
| 73120 | N/A | Point | - | - | - | - | S286419 | VICENTE ST: 38TH AVE | - | F | F | - | F | 23381000 | 23381000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VICENTE ST | VICENTE ST | 100496 | 100496 | 37.73842612 | -122.49578916 | 38TH AVE \ VICENTE ST | 38TH AVE \ VICENTE ST | 1710539427000 | MTA | SPEED HUMP | VICENTE ST intersection | - | - | - | - | - | - | - | 90237 | 1671667200000 | -122.49578916 | 37.73842612 | - | - | - | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1670500440000 | 38TH AVE | - | - | - | - | - | - |
| 73121 | N/A | Point | 1 | 1 | 3300 - 3349 | - | S253452 | 3300-3349 16TH ST | 3300-3349 16TH ST | T | T | - | F | 737000 | 737000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | DOLORES ST | DOLORES ST | 100594 | 100594 | 37.764505444 | -122.427688124 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | DOLORES ST to LANDERS ST (3300 - 3349) | 184890 | WPL #3322 | - | - | - | - | - | 90238 | 1116460800000 | -122.42697108 | 37.76461005 | - | 1560211200000 | - | D8 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | LIGHT POLE | IS | 1554978120000 | 16TH ST | 3300 - 3349 16TH ST | 3300 - 3349 16TH ST | 3300 16TH ST | - | LANDERS ST | LANDERS ST |
| 73122 | N/A | Point | 1 | 1 | 700 - 999 | - | S257033 | 700-999 ELLSWORTH ST | 700-999 ELLSWORTH ST | F | F | - | F | 5201000 | 5201000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | CRESCENT AVE | CRESCENT AVE | 100656 | 100656 | 37.73322801 | -122.4166609 | - | - | 1710539427000 | MTA | SPEED HUMP | CRESCENT AVE to ALEMANY BLVD \ I-280 S OFF RAMP \ I-280 S ON RAMP (700 - 999) | - | EPL 944 @PM | - | - | - | - | - | 90239 | 1179792000000 | -122.4166609 | 37.73322801 | - | 1577923200000 | - | D9 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1565860980000 | ELLSWORTH ST | 700 - 999 ELLSWORTH ST | 700 - 999 ELLSWORTH ST | 700 ELLSWORTH ST | - | ALEMANY BLVD \ I-280 S OFF RAMP \ I-280 S ON RAMP | ALEMANY BLVD \ I-280 S OFF RAMP \ I-280 S ON RAMP |
| 73123 | N/A | Point | 1 | 1 | 1000 - 1049 | - | S266504 | 1000-1049 MUNICH ST | 1000-1049 MUNICH ST | F | F | - | F | 9453000 | 9453000 | - | - | EAST SIDE | - | - | - | - | ROLPH ST | ROLPH ST | 100736 | 100736 | 37.711680788 | -122.433728958 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM THUR STCL | ROLPH ST to NAYLOR ST (1000 - 1049) | - | SPL 1021 | - | - | - | - | - | 90240 | 1416787200000 | -122.43378439 | 37.71172464 | - | 1596067200000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0080 | 18X18 | SUP2 | LIGHT POLE | IS | 1595501760000 | MUNICH ST | 1000 - 1049 MUNICH ST | 1000 - 1049 MUNICH ST | 1000 MUNICH ST | - | NAYLOR ST | NAYLOR ST |
| 73124 | N/A | Point | - | - | - | - | S262300 | GENEVA AVE: ALEMANY BLVD | - | F | F | - | F | 22052000 | 22052000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | GENEVA AVE | 100740 | 100740 | 37.717871641 | -122.442544525 | GENEVA AVE \ ALEMANY BLVD | ALEMANY BLVD \ GENEVA AVE | 1710539427000 | MTA | BIKE WAYFINDING SIGN | GENEVA AVE intersection | 1431 | - | - | - | - | - | - | 90241 | 1465257600000 | -122.44232816 | 37.71783345 | - | 1583971200000 | - | D11 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | SIGNAL POLE | IS | 1583493300000 | ALEMANY BLVD | - | - | - | - | - | - |
| 73125 | N/A | Point | - | - | - | - | S262301 | GENEVA AVE: ALEMANY BLVD | - | F | F | - | F | 22052000 | 22052000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | GENEVA AVE | 100741 | 100741 | 37.717665127 | -122.442337101 | GENEVA AVE \ ALEMANY BLVD | ALEMANY BLVD \ GENEVA AVE | 1710539427000 | MTA | BIKE WAYFINDING SIGN | GENEVA AVE intersection | 1432 | - | - | - | - | - | - | 90242 | 1465257600000 | -122.44232816 | 37.71783345 | - | 1583971200000 | - | D11 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | SIGNAL POLE | IS | 1583493540000 | ALEMANY BLVD | - | - | - | - | - | - |
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