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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70426 | N/A | Point | - | 1 | 400 - 598 | - | S210423 | 400-599 CROSS OVER DR (GGP) | 400-598 CROSSOVER DR | T | T | - | F | 4538101 | 4538101 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | PARK PRESIDIO BYPASS DR | PARK PRESIDIO BYPASS DR | 51447 | 51447 | 37.768679939 | -122.478326606 | - | - | 1734978678000 | middleware_editor | VA MEDICAL CENTER | PARK PRESIDIO BYPASS DR to MARTIN LUTHER KING JR DR (400 - 598) -- EAST -- | - | 772 FT SOUTH OF CROSSOVER | - | - | - | - | - | 87542 | - | -122.47832303 | 37.76868842 | - | 1651708800000 | - | D1 | - | OTHER GUIDE | GUIDE | G-VA(SF).0001 | 36X30 | SUP2 | LIGHT POLE | IS | 1414580940000 | CROSSOVER DR | 400 - 598 CROSSOVER DR | 400 - 598 CROSSOVER DR | 400 CROSSOVER DR | - | MARTIN LUTHER KING JR DR | MARTIN LUTHER KING JR DR |
| 70427 | N/A | Point | - | - | - | - | S213274 | LEXINGTON ST: SYCAMORE ST | - | F | F | - | F | 24166000 | 24166000 | - | - | SOUTH WEST CORNER | - | - | - | - | LEXINGTON ST | SYCAMORE ST | 51467 | 51467 | 37.762571849 | -122.420934148 | SYCAMORE ST \ LEXINGTON ST | LEXINGTON ST \ SYCAMORE ST | 1710539427000 | MTA | LEXINGTON ST | SYCAMORE ST intersection | - | - | - | - | - | - | - | 87543 | - | -122.42090062 | 37.76262486 | - | - | - | D9 | - | STREET NAME | GUIDE | D3-1.1038 | 36X08 | SUP2 | 3IN IRON POST | IS | 1423140960000 | LEXINGTON ST | - | - | - | - | - | - |
| 70428 | N/A | Point | 1 | 1 | 100 - 299 | - | S212828 | 100-299 32ND AVE | 100-299 32ND AVE | T | T | - | F | 1699000 | 1699000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | EL CAMINO DEL MAR | EL CAMINO DEL MAR | 51478 | 51478 | 37.78507492 | -122.49275793 | - | - | 1710539427000 | MTA | SPEED HUMPS | EL CAMINO DEL MAR to CALIFORNIA ST (100 - 299) | - | 75`SOUTH OF EL CAMINO DEL MAR | - | - | - | - | - | 87544 | 1423180800000 | -122.49275793 | 37.78507492 | - | 1423180800000 | - | D2 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1422008700000 | 32ND AVE | 100 - 299 32ND AVE | 100 - 299 32ND AVE | 100 32ND AVE | - | CALIFORNIA ST | CALIFORNIA ST |
| 70429 | N/A | Point | - | - | - | - | S212829 | 32ND AVE: EL CAMINO DEL MAR | - | T | T | - | F | 28036000 | 28036000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | EL CAMINO DEL MAR | 32ND AVE | 51479 | 51479 | 37.78657966 | -122.49311487 | 32ND AVE \ EL CAMINO DEL MAR | EL CAMINO DEL MAR \ 32ND AVE | 1710539427000 | MTA | SPEED HUMPS | 32ND AVE intersection | - | - | - | - | - | - | - | 87545 | 1468845840000 | -122.49311487 | 37.78657966 | - | 1468800000000 | - | D2 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1422009000000 | EL CAMINO DEL MAR | - | - | - | - | - | - |
| 70430 | N/A | Point | 1 | 1 | 56 - 99 | - | S213239 | 56-99 STONEMAN ST | 56-99 STONEMAN ST | F | F | - | F | 4457000 | 4457000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SHOTWELL ST | SHOTWELL ST | 51524 | 51524 | 37.74501909 | -122.41531313 | - | - | 1710539427000 | MTA | SPEED HUMP | SHOTWELL ST to BONVIEW ST \ COSO AVE (56 - 99) | - | 20FT.EAST OF SHOTWELL | - | - | - | - | - | 87546 | 1276732800000 | -122.41531313 | 37.74501909 | - | 1424217600000 | - | D9 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1423127760000 | STONEMAN ST | 56 - 99 STONEMAN ST | 56 - 99 STONEMAN ST | 56 STONEMAN ST | - | BONVIEW ST \ COSO AVE | BONVIEW ST \ COSO AVE |
| 70431 | N/A | Point | - | - | - | - | S213091 | BAY SHORE BLVD: OAKDALE AVE | - | F | F | - | F | 2799106 | 20816000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | BAY SHORE BLVD | BAY SHORE BLVD | 51563 | 51563 | 37.743184567 | -122.405134766 | - | OAKDALE AVE \ BAY SHORE BLVD | 1731103414000 | middleware_editor | NO LEFT TURN (SYM)/NO U TURN (SYM) | BAY SHORE BLVD intersection | - | SOUTH LINE | - | - | - | - | - | 87547 | 1141776000000 | -122.40524239 | 37.74305121 | - | 1731067200000 | - | D10 | - | NO LEFT TURN | REG | R3-18.0001 | 24X24 | SUP1 | SIGNAL POLE | IS | 1422616980000 | OAKDALE AVE | 185 - 299 BAY SHORE BLVD | - | - | - | OAKDALE AVE | - |
| 70432 | N/A | Point | 1 | 1 | 301 - 339 | - | S213092 | PNDG BAYSHORE BLVD | 301-339 BAY SHORE BLVD | F | F | - | F | 2800101 | 2800101 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | OAKDALE AVE | OAKDALE AVE | 51564 | 51564 | 37.742954198 | -122.405309495 | - | - | 1731103536000 | middleware_editor | NO LEFT TURN (SYM) | OAKDALE AVE to FLOWER ST (301 - 339) -- EAST -- | - | SOUTH LINE | - | - | - | - | - | 87548 | 1141776000000 | -122.40537655 | 37.74274634 | - | 1731071700000 | - | D10 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1422617040000 | BAY SHORE BLVD | 301 - 339 BAY SHORE BLVD | 301 - 339 BAY SHORE BLVD | - | - | FLOWER ST | FLOWER ST |
| 70433 | N/A | Point | - | - | - | - | S222120 | KANSAS ST: 16TH ST | - | F | F | - | F | 23775000 | 23775000 | - | - | NORTH WEST CORNER | - | - | - | - | KANSAS ST | KANSAS ST | 62690 | 62690 | 37.76601707 | -122.40364306 | 16TH ST \ KANSAS ST | 16TH ST \ KANSAS ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | KANSAS ST intersection | - | SEE NOTES | - | - | - | - | - | 87549 | 1455723180000 | -122.40364306 | 37.76601707 | - | 1511827200000 | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1452685740000 | 16TH ST | - | - | - | - | - | - |
| 70434 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S221132 | 1800-1899 BUCHANAN ST | 1800-1899 BUCHANAN ST | F | F | - | F | 3337000 | 3337000 | - | - | EAST SIDE | - | - | - | - | SUTTER ST | SUTTER ST | 62713 | 62713 | 37.78697234 | -122.43007366 | - | - | 1721437664000 | middleware_editor | PARKING METER POST | SUTTER ST to BUSH ST (1800 - 1899) | 334-18140 | METER #1814 | - | - | - | - | - | 87550 | - | -122.43007366 | 37.78697234 | - | - | - | D5 | - | PARKING | REG | R(SF).0351 | 02X36 | SUP1 | PARKING METER | IS | 1449324060000 | BUCHANAN ST | 1800 - 1899 BUCHANAN ST | 1800 - 1899 BUCHANAN ST | 1800 BUCHANAN ST | - | BUSH ST | BUSH ST |
| 70435 | N/A | Point | 1 | 1 | 557 - 599 | - | S227399 | 557-599 CALIFORNIA ST | 557-599 CALIFORNIA ST | F | F | - | F | 3531000 | 3531000 | - | - | NORTH SIDE | - | - | - | - | SPRING ST | SPRING ST | 62734 | 62734 | 37.7926779 | -122.40412321 | - | - | 1710539427000 | MTA | BIKE RACK | SPRING ST to KEARNY ST (557 - 599) | 20154909 | 53FT. WEST OF SPRING ST. | - | - | - | - | - | 87551 | 1470408240000 | -122.40412321 | 37.7926779 | - | 1470355200000 | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1469030700000 | CALIFORNIA ST | 557 - 599 CALIFORNIA ST | 557 - 599 CALIFORNIA ST | 557 CALIFORNIA ST | - | KEARNY ST | KEARNY ST |
| 70436 | N/A | Point | 1 | 1 | 100 - 199 | - | S222177 | 100-199 LAKESHORE DR | 100-199 LAKESHORE DR | F | F | - | F | 8056000 | 8056000 | - | - | NORTH SIDE | - | - | - | - | COUNTRY CLUB DR | COUNTRY CLUB DR | 62751 | 62751 | 37.72947504 | -122.49551185 | - | - | 1722390326000 | middleware_editor | NPRK 8AM-10AM 2ND & 4TH TUE OF MONTH STCL | COUNTRY CLUB DR to BONNIE BRAE LN (100 - 199) | - | IFO#191 | - | - | - | - | - | 87552 | 1225152000000 | -122.49551185 | 37.72947504 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0257 | 18X18 | SUP2 | LIGHT POLE | IS | 1452777480000 | LAKESHORE DR | 100 - 199 LAKESHORE DR | 100 - 199 LAKESHORE DR | 100 LAKESHORE DR | - | BONNIE BRAE LN | BONNIE BRAE LN |
| 70437 | N/A | Point | 1 | 1 | 2400 - 2499 | - | S221612 | 2400-2499 OCTAVIA ST | 2400-2499 OCTAVIA ST | F | F | - | F | 9896000 | 9896000 | - | - | EAST SIDE | - | - | - | - | PACIFIC AVE | PACIFIC AVE | 62782 | 62782 | 37.79464651 | -122.42825177 | - | - | 1742564244000 | middleware_editor | NPRK ANY TIME | PACIFIC AVE to BROADWAY (2400 - 2499) | - | 75FT. SOUTH OF BROADWAY | - | - | - | - | - | 87553 | 1552582860000 | -122.42825177 | 37.79464651 | - | - | - | D2 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1451320560000 | OCTAVIA ST | 2400 - 2499 OCTAVIA ST | 2400 - 2499 OCTAVIA ST | 2400 OCTAVIA ST | - | BROADWAY | BROADWAY |
| 70438 | N/A | Point | - | - | - | - | S224437 | VICENTE ST: 18TH AVE | - | F | F | - | F | 23158000 | 23158000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 18TH AVE | 18TH AVE | 62801 | 62801 | 37.73937137 | -122.47436459 | VICENTE ST \ 18TH AVE | VICENTE ST \ 18TH AVE | 1710539427000 | MTA | NO U TURN (SYM) | 18TH AVE intersection | - | - | - | - | - | - | - | 87554 | - | -122.47436459 | 37.73937137 | - | - | - | D7 | - | OTHER REGULATORY | REG | R3-4.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1459170780000 | VICENTE ST | - | - | - | - | - | - |
| 70439 | N/A | Point | 1 | 1 | 500 - 599 | - | S228035 | 500-599 TURK ST | 500-599 TURK ST | T | T | - | F | 12722000 | 12722000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | LARKIN ST | LARKIN ST | 62829 | 62829 | 37.782310147 | -122.418428936 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | LARKIN ST to POLK ST (500 - 599) | - | WPL# 550 | - | - | - | - | - | 87555 | 1135209600000 | -122.41816608 | 37.78227411 | - | 1471478400000 | - | D6 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP1 | LIGHT POLE | IS | 1470999600000 | TURK ST | 500 - 599 TURK ST | 500 - 599 TURK ST | 500 TURK ST | - | POLK ST | POLK ST |
| 70440 | N/A | Point | - | - | - | - | S228065 | 17TH ST: KANSAS ST | - | F | F | - | F | 23774000 | 23774000 | - | - | SOUTH EAST CORNER | - | - | - | - | KANSAS ST | 17TH ST | 62892 | 62892 | 37.764665488 | -122.403437511 | 17TH ST \ KANSAS ST | KANSAS ST \ 17TH ST | 1713810088000 | middleware_editor | DELINEATOR (W) (SAFE HIT) | 17TH ST intersection | - | SEE NOTES | - | - | - | - | - | 87556 | 1472219940000 | -122.40352703 | 37.76472287 | - | 1472169600000 | 1713784860000 | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | RETD | 1471257540000 | KANSAS ST | - | - | - | - | - | - |
| 70441 | N/A | Point | - | - | - | - | S228069 | 17TH ST: KANSAS ST | - | F | F | - | F | 23774000 | 23774000 | - | - | SOUTH EAST CORNER | - | - | - | - | KANSAS ST | 17TH ST | 62893 | 62893 | 37.764667873 | -122.403434159 | 17TH ST \ KANSAS ST | KANSAS ST \ 17TH ST | 1713810114000 | middleware_editor | DELINEATOR (W) (SAFE HIT) | 17TH ST intersection | - | SEE NOTES (4 TOTAL) | - | - | - | - | - | 87557 | 1475742900000 | -122.40352703 | 37.76472287 | - | 1475712000000 | 1713784860000 | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | RETD | 1471330380000 | KANSAS ST | - | - | - | - | - | - |
| 70442 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S226105 | 1400-1458 SAN BRUNO AVE | 1400-1499 SAN BRUNO AVE | F | F | - | F | 11362000 | 11362000 | - | - | EAST SIDE | - | - | - | - | 25TH ST | 25TH ST | 62906 | 62906 | 37.750055672 | -122.404000535 | - | - | 1726782703000 | middleware_editor | NPRK 6AM-7AM MON STCL | 25TH ST to SAN BRUNO AVE (1400 - 1499) | - | 50' FT NORTH FROM END OF BLOCK OPP 1462 | - | - | - | - | - | 87558 | 1014854400000 | -122.40415208 | 37.75091671 | - | 1465516800000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0172 | 18X18 | SUP1 | 2IN IRON POST | IS | 1464768780000 | SAN BRUNO AVE | 1400 - 1499 SAN BRUNO AVE | 1400 - 1499 SAN BRUNO AVE | 1400 SAN BRUNO AVE | - | SAN BRUNO AVE | SAN BRUNO AVE |
| 70443 | N/A | Point | - | - | - | - | S222627 | MISSION ST: CAPP ST \ CESAR CH | - | F | F | - | F | 21304000 | 21304000 | - | - | CENTER ISLAND, E LINE, NORTHBOUND | - | - | - | - | CESAR CHAVEZ ST \ MISSION ST | CAPP ST \ CESAR CHAVEZ ST | 63010 | 63010 | 37.74811585 | -122.418129975 | CAPP ST \ CESAR CHAVEZ ST \ MISSION ST | MISSION ST \ CAPP ST \ CESAR CHAVEZ ST | 1710539427000 | MTA | EXC BUSES BICYCLES TAXIS AND TRUCKS (SYM) | CAPP ST \ CESAR CHAVEZ ST intersection | - | - | - | - | - | - | - | 87559 | - | -122.41822117 | 37.74816569 | - | - | - | D9 | - | OTHER REGULATORY | REG | R(SF).0347 | 30X30 | SUP2 | LIGHT POLE | IS | 1453555620000 | MISSION ST | - | - | - | - | - | - |
| 70444 | N/A | Point | - | - | - | - | S227101 | MISSION ST: 18TH ST | - | F | F | - | F | 24149000 | 24149000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | MISSION ST | 18TH ST | 63036 | 63036 | 37.761854591 | -122.419463429 | 18TH ST \ MISSION ST | MISSION ST \ 18TH ST | 1710539427000 | MTA | SKATBRD & BICYCLE RIDING PROH ON SWALK SEC 96 & 100 TC | 18TH ST intersection | - | OPP#NE CORNOR | - | - | - | - | - | 87560 | - | -122.41935927 | 37.76183586 | - | - | - | D9 | - | OTHER REGULATORY | REG | R(SF).0312 | 18X24 | SUP2 | LIGHT POLE | IS | 1467794700000 | MISSION ST | - | - | - | - | - | - |
| 70445 | N/A | Point | - | - | - | - | S227103 | MISSION ST: 18TH ST | - | F | F | - | F | 24149000 | 24149000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | MISSION ST | 18TH ST | 63037 | 63037 | 37.761855651 | -122.419359717 | 18TH ST \ MISSION ST | MISSION ST \ 18TH ST | 1710539427000 | MTA | SKATBRD & BICYCLE RIDING PROH ON SWALK SEC 96 & 100 TC | 18TH ST intersection | - | 15`NORTH | - | - | - | - | - | 87561 | - | -122.41935927 | 37.76183586 | - | - | - | D9 | - | OTHER REGULATORY | REG | R(SF).0312 | 18X24 | SUP2 | MUNI POLE | IS | 1467795240000 | MISSION ST | - | - | - | - | - | - |
| 70446 | N/A | Point | - | - | - | - | S227104 | MISSION ST: 18TH ST | - | F | F | - | F | 24149000 | 24149000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MISSION ST | 18TH ST | 63038 | 63038 | 37.761837627 | -122.419293556 | 18TH ST \ MISSION ST | MISSION ST \ 18TH ST | 1710539427000 | MTA | SKATBRD & BICYCLE RIDING PROH ON SWALK SEC 96 & 100 TC | 18TH ST intersection | - | - | - | - | - | - | - | 87562 | - | -122.41935927 | 37.76183586 | - | - | - | D9 | - | OTHER REGULATORY | REG | R(SF).0312 | 18X24 | SUP2 | MUNI POLE | IS | 1467795360000 | MISSION ST | - | - | - | - | - | - |
| 70447 | N/A | Point | 1 | 1 | 900 - 951 | - | S239489 | 900-951 VALENCIA ST | 900-951 VALENCIA ST | F | F | - | F | 13067000 | 13067000 | - | - | WEST SIDE | - | - | - | - | 20TH ST | 20TH ST | 72376 | 72376 | 37.757998173 | -122.421350817 | - | - | 1710539427000 | MTA | BIKE RACK | 20TH ST to LIBERTY ST (900 - 951) | 04806 | 56'10" NORTH OF SPL#934(BACK TO THE PIC) | - | - | - | - | - | 87563 | 1508164020000 | -122.4212328 | 37.75809996 | - | 1508112000000 | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1507902060000 | VALENCIA ST | 900 - 951 VALENCIA ST | 900 - 951 VALENCIA ST | 900 VALENCIA ST | - | LIBERTY ST | LIBERTY ST |
| 70448 | N/A | Point | 1 | 1 | 700 - 799 | - | S239490 | 700-799 VALENCIA ST | 700-799 VALENCIA ST | F | F | - | F | 13064000 | 13064000 | - | - | WEST SIDE | - | - | - | - | 18TH ST | 18TH ST | 72377 | 72377 | 37.760412337 | -122.421557466 | - | - | 1710539427000 | MTA | BIKE RACK | 18TH ST to 19TH ST (700 - 799) | 04808 | 57'9" NORTH OF SPL#790(PROJ. JUICE) | - | - | - | - | - | 87564 | 1508166840000 | -122.42150181 | 37.76090111 | - | 1508112000000 | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1507902540000 | VALENCIA ST | 700 - 799 VALENCIA ST | 700 - 799 VALENCIA ST | 700 VALENCIA ST | - | 19TH ST | 19TH ST |
| 70449 | N/A | Point | - | - | - | - | S238226 | LAUSSAT ST: WEBSTER ST | - | F | F | - | F | 25896000 | 25896000 | - | - | SOUTH EAST CORNER | - | - | - | - | WEBSTER ST | WEBSTER ST | 72401 | 72401 | 37.77184975 | -122.42870811 | LAUSSAT ST \ WEBSTER ST | LAUSSAT ST \ WEBSTER ST | 1710539427000 | MTA | LAUSSAT ST | WEBSTER ST intersection | - | OF LAUSSAT ST & WEBSTER ST | - | - | - | - | - | 87565 | - | -122.42870811 | 37.77184975 | - | - | - | D5 | - | STREET NAME | GUIDE | D3-1.1020 | 36X08 | SUP1 | BUILDING | IS | 1502450940000 | LAUSSAT ST | - | - | - | - | - | - |
| 70450 | N/A | Point | - | - | - | - | S238339 | DOLORES ST: 19TH ST | - | F | F | - | F | 25683000 | 25683000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | - | - | - | - | DOLORES ST | 19TH ST | 72403 | 72403 | 37.759799393 | -122.425916277 | 19TH ST \ DOLORES ST | DOLORES ST \ 19TH ST | 1710539427000 | MTA | YIELD HERE TO PED (SYM) (RA) | 19TH ST intersection | - | - | - | - | - | - | - | 87566 | - | -122.4259203 | 37.75982961 | - | - | - | D8 | - | PEDESTRIAN | REG | R1-5.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1503048780000 | DOLORES ST | - | - | - | - | - | - |
| 70451 | N/A | Point | 1 | 1 | 100 - 199 | - | S236349 | 100-199 PERSIA AVE | 100-199 PERSIA AVE | F | F | - | F | 10364000 | 10364000 | - | - | SOUTH SIDE | - | - | - | - | LONDON ST | LONDON ST | 72419 | 72419 | 37.722428432 | -122.434628736 | - | - | 1710539427000 | MTA | BUS STOP NPPZ 8AM-9AM/2:30PM-4:00PM SCHL DAYS (LA) | LONDON ST to PARIS ST (100 - 199) | - | WPL#142 | - | - | - | - | - | 87567 | - | -122.43480755 | 37.7225727 | - | - | - | D11 | - | OTHER REGULATORY | REG | R30(SF).0001 | 10X15 | SUP2 | 2IN IRON POST | IS | 1495628820000 | PERSIA AVE | 100 - 199 PERSIA AVE | 100 - 199 PERSIA AVE | 100 PERSIA AVE | - | PARIS ST | PARIS ST |
| 70452 | N/A | Point | - | - | - | - | S236352 | PARIS ST: FRANCE AVE | - | F | F | - | F | 21730000 | 21730000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FRANCE AVE | FRANCE AVE | 72421 | 72421 | 37.71926881 | -122.43675633 | PARIS ST \ FRANCE AVE | PARIS ST \ FRANCE AVE | 1748551554000 | middleware_editor | ALL WAY | FRANCE AVE intersection | - | - | - | - | - | - | - | 87568 | 1173855600000 | -122.43675633 | 37.71926881 | - | 1499842800000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1495629300000 | PARIS ST | - | - | - | - | - | - |
| 70453 | N/A | Point | - | - | - | - | S238773 | LINCOLN WAY: 2ND AVE | - | F | F | - | F | 8341201 | 27181000 | - | - | CENTER ISLAND | - | - | - | - | ARGUELLO BLVD \ FREDERICK ST | 02ND AVE | 72456 | 72456 | 37.76625561 | -122.45894689 | - | LINCOLN WAY \ 02ND AVE | 1710539427000 | MTA | STATE LAW YIELD TO PEDS (SYM) | 02ND AVE intersection | - | E-LINE | - | - | - | - | - | 87569 | 1514505600000 | -122.45894689 | 37.76625561 | - | 1514505600000 | - | D5 | - | OTHER REGULATORY | REG | R1-6.0001 | 12X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1504706220000 | LINCOLN WAY | 2 - 98 LINCOLN WAY | - | - | - | 02ND AVE | - |
| 70454 | N/A | Point | - | - | - | - | S238342 | DOLORES ST: 19TH ST | - | T | T | - | F | 25683000 | 25683000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DOLORES ST | 19TH ST | 72459 | 72459 | 37.759760439 | -122.425788045 | 19TH ST \ DOLORES ST | DOLORES ST \ 19TH ST | 1710539427000 | MTA | 19TH ST | 19TH ST intersection | - | - | - | - | - | - | - | 87570 | 1511263980000 | -122.4259203 | 37.75982961 | - | 1511222400000 | - | D8 | - | STREET NAME | GUIDE | D3-2.0019 | 72X18 | SUP2 | LIGHT POLE | IS | 1503051600000 | DOLORES ST | - | - | - | - | - | - |
| 70455 | N/A | Point | - | - | - | - | S236503 | VERMONT ST: BAY SHORE BLVD \ C | - | T | T | - | F | 33729000 | 33729000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | CESAR CHAVEZ ST \ VERMONT ST | CESAR CHAVEZ ST \ VERMONT ST | 72487 | 72487 | 37.74947846 | -122.40286631 | BAY SHORE BLVD \ CESAR CHAVEZ ST \ VERMONT ST | BAY SHORE BLVD \ CESAR CHAVEZ ST \ VERMONT ST | 1721672100000 | middleware_editor | RIGHT TURN ONLY(SYM) | CESAR CHAVEZ ST \ VERMONT ST intersection | 0122 | CESAR CHAVEZ/101 FREEWAY ENTRANCE | - | - | - | - | - | 87571 | 1489968000000 | -122.40286631 | 37.74947846 | - | 1721646840000 | - | D10 | - | OTHER REGULATORY | REG | R3-5.0002 | 30X36 | SUP1 | LIGHT POLE | IS | 1496223480000 | BAY SHORE BLVD | - | - | - | - | - | - |
| 70456 | N/A | Point | 1 | 1 | 1 - 99 | - | S235942 | 1-99 PUTNAM ST | 1-99 PUTNAM ST | F | F | - | F | 10798000 | 10798000 | - | - | WEST SIDE | - | - | - | - | CORTLAND AVE | CORTLAND AVE | 72532 | 72532 | 37.73897401 | -122.41080614 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM FRI STCL | CORTLAND AVE to JARBOE AVE (1 - 99) | - | @ 8 PUTNAM ST. | - | - | - | - | - | 87572 | - | -122.41080614 | 37.73897401 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0076 | 18X18 | SUP2 | 2IN IRON POST | IS | 1494323700000 | PUTNAM ST | 1 - 99 PUTNAM ST | 1 - 99 PUTNAM ST | 1 PUTNAM ST | - | JARBOE AVE | JARBOE AVE |
| 70457 | N/A | Point | 1 | 1 | 800 - 899 | - | S236357 | 800-899 LONDON ST | 800-899 LONDON ST | F | F | - | F | 8478000 | 8478000 | - | - | WEST SIDE | - | - | - | - | AMAZON AVE | AMAZON AVE | 72535 | 72535 | 37.716818938 | -122.439796208 | - | - | 1718115714000 | middleware_editor | NPRK 8AM-10AM MON STCL | AMAZON AVE to GENEVA AVE (800 - 899) | - | NPL#808 | - | - | - | - | - | 87573 | - | -122.43993166 | 37.71649431 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0261 | 18X18 | SUP2 | 2IN IRON POST | IS | 1495630080000 | LONDON ST | 800 - 899 LONDON ST | 800 - 899 LONDON ST | 800 LONDON ST | - | GENEVA AVE | GENEVA AVE |
| 70458 | N/A | Point | - | - | - | - | S237601 | 19TH ST: DOLORES ST | - | F | F | - | F | 25683000 | 25683000 | - | - | CENTER ISLAND | - | - | - | - | DOLORES ST | 19TH ST | 72756 | 72756 | 37.759780322 | -122.425932452 | 19TH ST \ DOLORES ST | DOLORES ST \ 19TH ST | 1710539427000 | MTA | DOLORES ST | 19TH ST intersection | - | <600| SOUTH @ SOUTH LINE | - | - | - | - | - | 87574 | 1504108920000 | -122.4259203 | 37.75982961 | - | 1537833600000 | - | D8 | - | STREET NAME | GUIDE | D3-1.0541 | 36X08 | SUP2 | SIGNAL POLE | IS | 1500463140000 | DOLORES ST | - | - | - | - | - | - |
| 70459 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S237073 | 1400-1499 36TH AVE | 1400-1499 36TH AVE | F | F | - | F | 1804000 | 1804000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | JUDAH ST | JUDAH ST | 72840 | 72840 | 37.75996291 | -122.49514786 | - | - | 1710539427000 | MTA | SPEED HUMPS | JUDAH ST to KIRKHAM ST (1400 - 1499) | - | OPP# 1416 | - | - | - | - | - | 87575 | 1503400620000 | -122.49514786 | 37.75996291 | - | 1503360000000 | - | D4 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1498555500000 | 36TH AVE | 1400 - 1499 36TH AVE | 1400 - 1499 36TH AVE | 1400 36TH AVE | - | KIRKHAM ST | KIRKHAM ST |
| 70460 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S237074 | 1400-1499 36TH AVE | 1400-1499 36TH AVE | F | F | - | F | 1804000 | 1804000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | JUDAH ST | JUDAH ST | 72841 | 72841 | 37.75996291 | -122.49514786 | - | - | 1710539427000 | MTA | SPEED HUMPS | JUDAH ST to KIRKHAM ST (1400 - 1499) | - | SPL# 1480 36TH AVE | - | - | - | - | - | 87576 | 1228176000000 | -122.49514786 | 37.75996291 | - | 1503360000000 | - | D4 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1498555800000 | 36TH AVE | 1400 - 1499 36TH AVE | 1400 - 1499 36TH AVE | 1400 36TH AVE | - | KIRKHAM ST | KIRKHAM ST |
| 70461 | N/A | Point | - | - | - | - | S244859 | BERNAL HEIGHTS BLVD: ANDERSON | - | F | F | - | F | 33740000 | 33740000 | - | - | SOUTH EAST CORNER | - | - | - | - | BERNAL HEIGHTS BLVD | ANDERSON ST | 81791 | 81791 | 37.74218217 | -122.41501363 | ANDERSON ST \ BERNAL HEIGHTS BLVD | BERNAL HEIGHTS BLVD \ ANDERSON ST | 1710539427000 | MTA | BERNAL HEIGHTS BLVD | ANDERSON ST intersection | - | - | - | - | - | - | - | 87577 | 1559174400000 | -122.41501363 | 37.74218217 | - | - | - | D9 | - | STREET NAME | GUIDE | D3-1.0209 | 36X08 | SUP2 | 3IN IRON POST | IS | 1524131640000 | BERNAL HEIGHTS BLVD | - | - | - | - | - | - |
| 70462 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S244260 | 1700-1799 NEWCOMB AVE | 1700-1799 NEWCOMB AVE | F | F | - | F | 9554000 | 9554000 | - | - | SOUTH SIDE | - | - | - | - | NEWHALL ST | NEWHALL ST | 81805 | 81805 | 37.7368194 | -122.3925856 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM THUR STCL | NEWHALL ST to PHELPS ST (1700 - 1799) | - | 30`EAST OF PHELPS | - | - | - | - | - | 87578 | 1324425600000 | -122.3925856 | 37.7368194 | - | 1527120000000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0267 | 18X18 | SUP1 | LIGHT POLE | IS | 1522408860000 | NEWCOMB AVE | 1700 - 1799 NEWCOMB AVE | 1700 - 1799 NEWCOMB AVE | 1700 NEWCOMB AVE | - | PHELPS ST | PHELPS ST |
| 70463 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S247823 | 2200-2299 GOUGH ST | 2200-2299 GOUGH ST | F | F | - | F | 6342000 | 6342000 | - | - | WEST SIDE | - | - | - | - | JACKSON ST | JACKSON ST | 81817 | 81817 | 37.79395737 | -122.42642463 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM TUE STCL | JACKSON ST to PACIFIC AVE (2200 - 2299) | - | SPL #2225 | - | - | - | - | - | 87579 | 1542201600000 | -122.42642463 | 37.79395737 | - | - | - | D2 | - | STREET CLEANING | REG | R30B(CA).0308 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1534511460000 | GOUGH ST | 2200 - 2299 GOUGH ST | 2200 - 2299 GOUGH ST | 2200 GOUGH ST | - | PACIFIC AVE | PACIFIC AVE |
| 70464 | N/A | Point | 1 | 1 | 500 - 599 | - | S245960 | 500-599 MINNESOTA ST | 500-599 MINNESOTA ST | F | F | - | F | 9053000 | 9053000 | - | - | EAST SIDE | - | - | - | - | 4TH ST \ MARIPOSA ST | 04TH ST \ MARIPOSA ST | 81825 | 81825 | 37.76356326 | -122.39075789 | - | - | 1746740436000 | middleware_editor | NPRK 2AM-6AM WED STCL | 04TH ST \ MARIPOSA ST to 18TH ST (500 - 599) | - | 167' NORTH OF 18TH ST. | - | - | - | - | - | 87580 | - | -122.39075789 | 37.76356326 | - | 1746738300000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0135 | 18X18 | SUP1 | 2IN IRON POST | IS | 1527775860000 | MINNESOTA ST | 500 - 599 MINNESOTA ST | 500 - 599 MINNESOTA ST | 500 MINNESOTA ST | - | 18TH ST | 18TH ST |
| 70465 | N/A | Point | - | - | - | - | S245226 | PANORAMA DR: MARVIEW WAY | - | F | F | - | F | 26231000 | 26231000 | - | - | NORTH WEST CORNER | - | - | - | - | MARVIEW WAY | MARVIEW WAY | 81847 | 81847 | 37.753688473 | -122.450832242 | PANORAMA DR \ MARVIEW WAY | PANORAMA DR \ MARVIEW WAY | 1710539427000 | MTA | PANORAMA DR | MARVIEW WAY intersection | - | - | - | - | - | - | - | 87581 | 1465257600000 | -122.45070886 | 37.75361637 | - | 1465257600000 | - | D7 | - | STREET NAME | GUIDE | D3-1.1345 | 36X08 | SUP2 | 3IN IRON POST | IS | 1525187940000 | PANORAMA DR | - | - | - | - | - | - |
| 70466 | N/A | Point | 1 | 1 | 1400 - 1499 | RIGHT ARROW | S249658 | 1400-1499 HOWARD ST | 1400-1499 HOWARD ST | F | F | - | F | 7056000 | 7056000 | - | - | NORTH SIDE | - | - | - | - | 10TH ST | 10TH ST | 81849 | 81849 | 37.77357196 | -122.41496454 | - | - | 1710539427000 | MTA | TANP ANY TIME | 10TH ST to 11TH ST (1400 - 1499) | - | 60 FT WEST OF TENTH | - | - | - | - | - | 87582 | 1545052020000 | -122.41496454 | 37.77357196 | - | 1562112000000 | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | 2IN IRON POST | IS | 1542371940000 | HOWARD ST | 1400 - 1499 HOWARD ST | 1400 - 1499 HOWARD ST | 1400 HOWARD ST | - | 11TH ST | 11TH ST |
| 70467 | N/A | Point | - | - | - | - | S249313 | HANCOCK ST: SANCHEZ ST | - | F | F | - | F | 25719000 | 25719000 | - | - | SOUTH WEST CORNER | - | - | - | - | HANCOCK ST | HANCOCK ST | 81857 | 81857 | 37.76035731 | -122.43049703 | SANCHEZ ST \ HANCOCK ST | SANCHEZ ST \ HANCOCK ST | 1732303196000 | middleware_editor | HANCOCK ST | HANCOCK ST intersection | - | - | - | - | - | - | - | 87583 | 1552657860000 | -122.43049703 | 37.76035731 | - | - | - | D8 | - | STREET NAME | GUIDE | D3-1.0792 | 36X08 | SUP2 | 3IN IRON POST | IS | 1540907460000 | SANCHEZ ST | - | - | - | - | - | - |
| 70468 | N/A | Point | 1 | 1 | 4100 - 4199 | - | S247113 | 4100-4199 ULLOA ST | 4100-4199 ULLOA ST | F | F | - | F | 12820000 | 12820000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 42ND AVE | 42ND AVE | 81884 | 81884 | 37.739999883 | -122.501092983 | - | - | 1710539427000 | MTA | SCHOOL (SYM) | 42ND AVE to 43RD AVE (4100 - 4199) | - | 15' FT EAST OF 43RD | - | - | - | - | - | 87584 | 1228867200000 | -122.50073692 | 37.74007253 | - | 1532304000000 | - | D4 | - | SCHOOL | WARNING | S1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1532006220000 | ULLOA ST | 4100 - 4199 ULLOA ST | 4100 - 4199 ULLOA ST | 4100 ULLOA ST | - | 43RD AVE | 43RD AVE |
| 70469 | N/A | Point | 1 | 1 | 4100 - 4199 | - | S247114 | 4100-4199 ULLOA ST | 4100-4199 ULLOA ST | F | F | - | F | 12820000 | 12820000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 42ND AVE | 42ND AVE | 81885 | 81885 | 37.739996171 | -122.501092983 | - | - | 1710539427000 | MTA | AHEAD | 42ND AVE to 43RD AVE (4100 - 4199) | - | 15' FT EAST OF 43RD | - | - | - | - | - | 87585 | 1228867200000 | -122.50073692 | 37.74007253 | - | 1532304000000 | - | D4 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP2 | 2IN IRON POST | IS | 1532006220000 | ULLOA ST | 4100 - 4199 ULLOA ST | 4100 - 4199 ULLOA ST | 4100 ULLOA ST | - | 43RD AVE | 43RD AVE |
| 70470 | N/A | Point | - | - | - | - | S249222 | 3RD ST: DAVIDSON AVE | - | F | F | - | F | 20244000 | 20244000 | - | - | CENTER ISLAND, W LINE, SOUTHBOUND | - | - | - | - | 3RD ST | 03RD ST | 81890 | 81890 | 37.74352793 | -122.38762945 | DAVIDSON AVE \ 3RD ST | DAVIDSON AVE \ 03RD ST | 1732132204000 | middleware_editor | FG 300 EFX DELINEATOR (Y) | 03RD ST intersection | - | GOES ON THE END SOUTH | - | - | - | - | - | 87586 | 1167696000000 | -122.38762945 | 37.74352793 | - | 1732095900000 | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | INTERSTATE BASE | IS | 1540803000000 | DAVIDSON AVE | - | - | - | - | - | - |
| 70471 | N/A | Point | - | 1 | 1900 - 1999 | - | S240897 | 1891-1999 EVANS AVE | 1900-1999 EVANS AVE | F | F | - | F | 5339000 | 5339000 | - | - | SOUTH SIDE | - | - | - | - | SELBY ST | SELBY ST | 81902 | 81902 | 37.74671265 | -122.39502878 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM THUR STCL | SELBY ST to NAPOLEON ST \ TOLAND ST (1900 - 1999) | - | 200' E OF TOLAND | - | - | - | - | - | 87587 | 1511955360000 | -122.39502878 | 37.74671265 | - | 1511913600000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0054 | 18X18 | SUP1 | UTILITY POLE | IS | 1511860620000 | EVANS AVE | 1900 - 1999 EVANS AVE | 1900 - 1999 EVANS AVE | 1900 EVANS AVE | - | NAPOLEON ST \ TOLAND ST | NAPOLEON ST \ TOLAND ST |
| 70472 | N/A | Point | - | - | - | - | S240609 | NEWCOMB AVE: MENDELL ST | - | F | F | - | F | 20661000 | 20661000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | NEWCOMB AVE | NEWCOMB AVE | 81911 | 81911 | 37.73522488 | -122.38977084 | MENDELL ST \ NEWCOMB AVE | MENDELL ST \ NEWCOMB AVE | 1724684074000 | middleware_editor | ALL WAY | NEWCOMB AVE intersection | - | - | - | - | - | - | - | 87588 | 892598400000 | -122.38977084 | 37.73522488 | - | 1724410800000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1510845000000 | MENDELL ST | - | - | - | - | - | - |
| 70473 | N/A | Point | 1 | 1 | 900 - 999 | - | S245403 | 900-999 PERSIA AVE | 900-999 PERSIA AVE | F | F | - | F | 10372000 | 10372000 | - | - | SOUTH SIDE | - | - | - | - | MOSCOW ST | MOSCOW ST | 81913 | 81913 | 37.719368339 | -122.428220226 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM WED STCL | MOSCOW ST to MUNICH ST (900 - 999) | - | 40 WEST OF MUNICH | - | - | - | - | - | 87589 | 1109116800000 | -122.42839904 | 37.71951827 | - | 1525996800000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0086 | 18X18 | SUP2 | 2IN IRON POST | IS | 1525784160000 | PERSIA AVE | 900 - 999 PERSIA AVE | 900 - 999 PERSIA AVE | 900 PERSIA AVE | - | MUNICH ST | MUNICH ST |
| 70474 | N/A | Point | 1 | 1 | 1 - 15 | - | S245732 | 1-99 SOUTH PARK | 1-15 SOUTH PARK | F | F | - | F | 12008000 | 12008000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 2ND ST | 02ND ST | 81944 | 81944 | 37.78229709 | -122.3930437 | - | - | 1710539427000 | MTA | (45 LA-DN) | 02ND ST to SOUTH PARK (1 - 15) | - | N-LINE OF CROSSWALK (IFO#164) | - | - | - | - | - | 87590 | 1527772140000 | -122.3930437 | 37.78229709 | - | - | - | D6 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP1 | 2IN IRON POST | IS | 1527072360000 | SOUTH PARK | 1 - 15 SOUTH PARK | 1 - 15 SOUTH PARK | 1 SOUTH PARK | - | SOUTH PARK | SOUTH PARK |
| 70475 | N/A | Point | - | - | - | - | S242888 | BAY ST: BRODERICK ST | - | F | F | - | F | 27006000 | 27006000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BAY ST | BRODERICK ST | 81951 | 81951 | 37.80162598 | -122.44489255 | BRODERICK ST \ BAY ST | BAY ST \ BRODERICK ST | 1718638674000 | middleware_editor | ALL WAY | BRODERICK ST intersection | - | - | - | - | - | - | - | 87591 | 1434585600000 | -122.44489255 | 37.80162598 | - | 1518739200000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1518003120000 | BAY ST | - | - | - | - | - | - |
| 70476 | N/A | Point | - | - | - | - | S111804 | MCKINNON AVE: MENDELL ST | - | F | F | - | F | 20212000 | 20212000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MCKINNON AVE | MCKINNON AVE | 89157 | 89157 | 37.73585632 | -122.38921985 | MENDELL ST \ MCKINNON AVE | MENDELL ST \ MCKINNON AVE | 1710539427000 | MTA | STOP | MCKINNON AVE intersection | - | - | - | - | - | - | - | 87592 | 858556800000 | -122.38921985 | 37.73585632 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571240000 | MENDELL ST | - | - | - | - | - | - |
| 70477 | N/A | Point | - | 1 | 400 - 499 | - | S254347 | 414-499 MOUNT VERNON AVE | 400-499 MOUNT VERNON AVE | F | F | - | F | 9431000 | 9431000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 89175 | 89175 | 37.7185454 | -122.4488816 | - | - | 1710539427000 | MTA | SPEED HUMP | SAN JOSE AVE to SAN MIGUEL ST (400 - 499) | - | 5FT WEST OF SAN JOSE | - | - | - | - | - | 87593 | 1560938220000 | -122.4488816 | 37.7185454 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1557994920000 | MOUNT VERNON AVE | 400 - 499 MOUNT VERNON AVE | 400 - 499 MOUNT VERNON AVE | 400 MOUNT VERNON AVE | - | SAN MIGUEL ST | SAN MIGUEL ST |
| 70478 | N/A | Point | - | - | - | - | S254841 | JOHN F KENNEDY DR: 30TH AVE | - | F | F | - | F | 27524000 | 27524000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 30TH AVE | 30TH AVE | 89227 | 89227 | 37.77089457 | -122.48980436 | JOHN F KENNEDY DR \ 30TH AVE | JOHN F KENNEDY DR \ 30TH AVE | 1710539427000 | MTA | REMOVE (SF BIKE ROUTE) GREEN (SYM) # | 30TH AVE intersection | - | 35 FT EAST OF 30TH AVE ABOVE SIGN | - | - | - | - | - | 87594 | 1512432000000 | -122.48980436 | 37.77089457 | - | 1512432000000 | - | D1 | - | BIKE REG | REG | R(SF).0388 | 12X24 | SUP2 | LIGHT POLE | IS | 1559385120000 | JOHN F KENNEDY DR | - | - | - | - | - | - |
| 70479 | N/A | Point | - | - | - | - | S258699 | CASTRO ST: 28TH ST | - | F | F | - | F | 22012000 | 22012000 | - | - | SOUTH EAST CORNER | - | - | - | - | 28TH ST | CASTRO ST | 89245 | 89245 | 37.74488092 | -122.43346593 | CASTRO ST \ 28TH ST | 28TH ST \ CASTRO ST | 1710539427000 | MTA | 2100 BLOCK PLATE (RA) | CASTRO ST intersection | - | 2100 | - | - | - | - | - | 87595 | 1462838400000 | -122.43346593 | 37.74488092 | - | 1578268800000 | - | D8 | - | STREET NAME | GUIDE | D3-1(SF).0032 | 12X05 | SUP2 | 3IN IRON POST | IS | 1572257280000 | 28TH ST | - | - | - | - | - | - |
| 70480 | N/A | Point | 1 | 1 | 100 - 199 | - | S257695 | 100-199 TAYLOR ST | 100-199 TAYLOR ST | T | T | - | F | 12427000 | 12427000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | TURK ST | TURK ST | 89268 | 89268 | 37.78367766 | -122.41085822 | - | - | 1731527011000 | middleware_editor | (VA) ONLY (RA) ONLY | TURK ST to EDDY ST (100 - 199) | - | 90' S OF EDDY ST. | - | - | - | - | - | 87596 | 1571307300000 | -122.41085822 | 37.78367766 | - | - | - | D6 | - | OTHER REGULATORY | REG | R61(SF).0103 | 36X30 | SUP1 | LIGHT POLE | IS | 1568207280000 | TAYLOR ST | 100 - 199 TAYLOR ST | 100 - 199 TAYLOR ST | 100 TAYLOR ST | - | EDDY ST | EDDY ST |
| 70481 | N/A | Point | 1 | 1 | 1 - 99 | - | S256295 | 1-99 WALTER ST | 1-99 WALTER ST | F | F | - | F | 13386000 | 13386000 | - | - | WEST SIDE | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 89282 | 89282 | 37.76838905 | -122.43238179 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | DUBOCE AVE to 14TH ST (1 - 99) | 120019442 | NPL #24 | - | - | - | - | - | 87597 | 1538524800000 | -122.43238179 | 37.76838905 | - | 1565827200000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | 2IN IRON POST | IS | 1563624360000 | WALTER ST | 1 - 99 WALTER ST | 1 - 99 WALTER ST | 1 WALTER ST | - | 14TH ST | 14TH ST |
| 70482 | N/A | Point | - | - | - | - | S257566 | INDIANA ST: 25TH ST \ I-280 N | - | F | F | - | F | 23609000 | 23609000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 25TH ST \ I-280 N ON RAMP | 25TH ST \ I-280 N ON RAMP | 89301 | 89301 | 37.75266307 | -122.39068286 | INDIANA ST \ 25TH ST \ I-280 N ON RAMP | INDIANA ST \ 25TH ST \ I-280 N ON RAMP | 1715094874000 | middleware_editor | SPEED HUMPS | 25TH ST \ I-280 N ON RAMP intersection | - | - | - | - | - | - | - | 87598 | 1574086200000 | -122.39068286 | 37.75266307 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1567694700000 | INDIANA ST | - | - | - | - | - | - |
| 70483 | N/A | Point | - | 1 | 900 - 999 | - | S256957 | 900-999 BRANNAN ST | 900-999 BRANNAN ST | F | F | - | F | 3089000 | 3089000 | - | - | NORTH SIDE | - | - | - | - | 8TH ST | 08TH ST | 89309 | 89309 | 37.77067307 | -122.40621311 | - | - | 1721945475000 | middleware_editor | NPRK 12MN-6AM MON WED FRI STCL | 08TH ST to 09TH ST (900 - 999) | - | 220 EAST OF 9TH | - | - | - | - | - | 87599 | 992044800000 | -122.40621311 | 37.77067307 | - | 1721901600000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0051 | 18X18 | SUP1 | 2IN IRON POST | IS | 1565345040000 | BRANNAN ST | 900 - 999 BRANNAN ST | 900 - 999 BRANNAN ST | 900 BRANNAN ST | - | 09TH ST | 09TH ST |
| 70484 | N/A | Point | - | - | - | - | S110673 | HAYES ST: LYON ST | - | F | F | - | F | 26356000 | 26356000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LYON ST | HAYES ST | 89318 | 89318 | 37.774459181 | -122.44285143 | HAYES ST \ LYON ST | LYON ST \ HAYES ST | 1743618933000 | middleware_editor | STOP | HAYES ST intersection | - | - | - | - | - | - | - | 87600 | 682758000000 | -122.44275487 | 37.77435883 | - | 1743615900000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373570880000 | LYON ST | - | - | - | - | - | - |
| 70485 | N/A | Point | - | - | - | - | S110818 | AMAZON AVE: VIENNA ST | - | F | F | - | F | 21408000 | 21408000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | AMAZON AVE | AMAZON AVE | 89322 | 89322 | 37.715042598 | -122.434615112 | VIENNA ST \ AMAZON AVE | VIENNA ST \ AMAZON AVE | 1710539427000 | MTA | STOP | AMAZON AVE intersection | - | IFO 1ST TREE | - | - | - | - | - | 87601 | 707443200000 | -122.43449173 | 37.71506523 | - | 1587340800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570940000 | VIENNA ST | - | - | - | - | - | - |
| 70486 | N/A | Point | 1 | 1 | 200 - 299 | - | S110859 | 200-299 FRANCE AVE | 200-299 FRANCE AVE | F | F | - | F | 5745000 | 5745000 | - | - | NORTH SIDE | - | - | - | - | PARIS ST | PARIS ST | 89324 | 89324 | 37.7191271892625 | -122.436336529355 | - | - | 1756333967000 | middleware_editor | NPRK 8AM-10AM WED STCL | PARIS ST to LISBON ST (200 - 299) | - | 100` FT WEST OF LISBON | - | - | - | - | - | 87602 | 712998000000 | -122.43635759 | 37.71907953 | - | 1756310400000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP2 | LIGHT POLE | IS | 1373570940000 | FRANCE AVE | 200 - 299 FRANCE AVE | 200 - 299 FRANCE AVE | 200 FRANCE AVE | - | LISBON ST | LISBON ST |
| 70487 | N/A | Point | - | - | - | - | S252336 | BAKER ST: BEACH ST | - | F | F | - | F | 27018000 | 27018000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BEACH ST | BAKER ST | 89345 | 89345 | 37.803284 | -122.44691012 | BAKER ST \ BEACH ST | BEACH ST \ BAKER ST | 1736367001000 | middleware_editor | STOP | BAKER ST intersection | - | - | - | - | - | - | - | 87603 | 1465257600000 | -122.44691012 | 37.803284 | - | 1552435200000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1552396200000 | BEACH ST | - | - | - | - | - | - |
| 70488 | N/A | Point | 1 | 1 | 300 - 399 | - | S257721 | 300-399 MADRID ST | 300-399 MADRID ST | F | F | - | F | 8606000 | 8606000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 89357 | 89357 | 37.723572798 | -122.431250544 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | EXCELSIOR AVE to BRAZIL AVE (300 - 399) | - | NPL 375 | - | - | - | - | - | 87604 | 1319155200000 | -122.43104312 | 37.72394619 | - | 1568592000000 | - | D11 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1568282220000 | MADRID ST | 300 - 399 MADRID ST | 300 - 399 MADRID ST | 300 MADRID ST | - | BRAZIL AVE | BRAZIL AVE |
| 70489 | N/A | Point | 1 | 1 | 700 - 799 | - | S272150 | 700-799 VALENCIA ST | 700-799 VALENCIA ST | F | F | - | F | 13064000 | 13064000 | - | - | WEST SIDE | - | - | - | - | 18TH ST | 18TH ST | 99212 | 99212 | 37.761584432 | -122.42169627 | - | - | 1710539427000 | MTA | BIKE RACK | 18TH ST to 19TH ST (700 - 799) | - | 20' S OF 18TH ST | - | - | - | - | - | 87605 | - | -122.42150181 | 37.76090111 | - | - | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1612353840000 | VALENCIA ST | 700 - 799 VALENCIA ST | 700 - 799 VALENCIA ST | 700 VALENCIA ST | - | 19TH ST | 19TH ST |
| 70490 | N/A | Point | - | - | - | - | S272199 | COOK ST: GEARY BLVD | - | F | F | - | F | 26924000 | 26924000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GEARY BLVD | GEARY BLVD | 99213 | 99213 | 37.781883675 | -122.452168601 | COOK ST \ GEARY BLVD | COOK ST \ GEARY BLVD | 1710539427000 | MTA | ONE WAY (LA) | GEARY BLVD intersection | - | - | - | - | - | - | - | 87606 | - | -122.45214312 | 37.78185329 | - | - | - | D1 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | SIGNAL POLE | IS | 1612515840000 | COOK ST | - | - | - | - | - | - |
| 70491 | N/A | Point | - | - | - | - | S266178 | 19TH AVE: CLEMENT ST | - | F | F | - | F | 27506000 | 27506000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 99234 | 99234 | 37.78230838 | -122.47844351 | 19TH AVE \ CLEMENT ST | 19TH AVE \ CLEMENT ST | 1715356390000 | middleware_editor | SPEED HUMPS | CLEMENT ST intersection | - | - | - | - | - | - | - | 87607 | -74908800000 | -122.47844351 | 37.78230838 | - | 1594771200000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1594644420000 | 19TH AVE | - | - | - | - | - | - |
| 70492 | N/A | Point | 1 | 1 | 1 - 99 | - | S286144 | 1-99 EXCELSIOR AVE | 1-99 EXCELSIOR AVE | F | F | - | F | 5359000 | 5359000 | - | - | NORTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 99257 | 99257 | 37.726227541 | -122.433438813 | - | - | 1710539427000 | MTA | BIKE RACK | MISSION ST to LONDON ST (1 - 99) | 663428 | 20' E OF MISSION/3.5' IN FROM CURB | - | - | - | - | - | 87608 | 1669680000000 | -122.43324033 | 37.72605358 | - | - | - | D11 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1669202820000 | EXCELSIOR AVE | 1 - 99 EXCELSIOR AVE | 1 - 99 EXCELSIOR AVE | 1 EXCELSIOR AVE | - | LONDON ST | LONDON ST |
| 70493 | N/A | Point | - | - | - | - | S289120 | VALENCIA ST: 18TH ST | - | F | F | - | F | 24160000 | 24160000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | 18TH ST | 99430 | 99430 | 37.761779897 | -122.421668925 | 18TH ST \ VALENCIA ST | VALENCIA ST \ 18TH ST | 1753201920000 | middleware_editor | NO LEFT TURN (SYM)/NO U TURN (SYM) | 18TH ST intersection | - | - | - | - | - | - | - | 87609 | 1682924400000 | -122.4215784 | 37.76170091 | - | - | 1753201380000 | D8 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | SIGNAL POLE | RETD | 1682679900000 | VALENCIA ST | - | - | - | - | - | - |
| 70494 | N/A | Point | - | - | - | - | S289121 | VALENCIA ST: 18TH ST | - | T | T | - | F | 24160000 | 24160000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | 18TH ST | 99431 | 99431 | 37.761616622 | -122.421676301 | 18TH ST \ VALENCIA ST | VALENCIA ST \ 18TH ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | 18TH ST intersection | - | NEXT TO LIGHT | - | - | - | - | - | 87610 | 1682899200000 | -122.4215784 | 37.76170091 | - | - | - | D8 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | OVERHEAD MAST ARM | IS | 1682679960000 | VALENCIA ST | - | - | - | - | - | - |
| 70495 | N/A | Point | - | - | - | - | S289122 | VALENCIA ST: 18TH ST | - | T | T | - | F | 24160000 | 24160000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | 18TH ST | 99432 | 99432 | 37.761616092 | -122.42167563 | 18TH ST \ VALENCIA ST | VALENCIA ST \ 18TH ST | 1710539427000 | MTA | NEW | 18TH ST intersection | - | NEXT TO LIGHT | - | - | - | - | - | 87611 | - | -122.4215784 | 37.76170091 | - | - | 1709813700000 | D8 | - | OTHER WARNING | WARNING | W(SF).0079 | 30X12 | SUP2 | OVERHEAD MAST ARM | RETD | 1682680080000 | VALENCIA ST | - | - | - | - | - | - |
| 70496 | N/A | Point | - | - | - | - | S289159 | VALENCIA ST: 17TH ST | - | T | T | - | F | 24174000 | 24174000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 17TH ST | 17TH ST | 99438 | 99438 | 37.763378932 | -122.421610821 | VALENCIA ST \ 17TH ST | VALENCIA ST \ 17TH ST | 1710539427000 | MTA | NEW | 17TH ST intersection | - | - | - | - | - | - | - | 87612 | - | -122.42173152 | 37.76329977 | - | - | 1709905800000 | D8 | - | OTHER WARNING | WARNING | W(SF).0079 | 30X12 | SUP2 | OVERHEAD MAST ARM | RETD | 1682946960000 | VALENCIA ST | - | - | - | - | - | - |
| 70497 | N/A | Point | - | - | - | - | S289160 | VALENCIA ST: 17TH ST | - | T | T | - | F | 24174000 | 24174000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 17TH ST | 17TH ST | 99439 | 99439 | 37.763382467 | -122.421580422 | VALENCIA ST \ 17TH ST | VALENCIA ST \ 17TH ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | 17TH ST intersection | - | - | - | - | - | - | - | 87613 | 1682985600000 | -122.42173152 | 37.76329977 | - | 1683244800000 | - | D8 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | OVERHEAD MAST ARM | IS | 1682947080000 | VALENCIA ST | - | - | - | - | - | - |
| 70498 | N/A | Point | - | - | - | - | S289161 | VALENCIA ST: 17TH ST | - | F | F | - | F | 24174000 | 24174000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 17TH ST | 17TH ST | 99440 | 99440 | 37.76324888 | -122.421585787 | VALENCIA ST \ 17TH ST | VALENCIA ST \ 17TH ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | 17TH ST intersection | - | - | - | - | - | - | - | 87614 | 1682985600000 | -122.42173152 | 37.76329977 | - | - | - | D8 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1682947200000 | VALENCIA ST | - | - | - | - | - | - |
| 70499 | N/A | Point | - | - | - | - | S289164 | VALENCIA ST: 17TH ST | - | T | T | - | F | 24174000 | 24174000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 17TH ST | 17TH ST | 99442 | 99442 | 37.763202938 | -122.421833444 | VALENCIA ST \ 17TH ST | VALENCIA ST \ 17TH ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | 17TH ST intersection | - | NEXT TO LIGHT | - | - | - | - | - | 87615 | 1682985600000 | -122.42173152 | 37.76329977 | - | 1683244800000 | - | D8 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | OVERHEAD MAST ARM | IS | 1682947440000 | VALENCIA ST | - | - | - | - | - | - |
| 70500 | N/A | Point | - | - | - | - | S289169 | VALENCIA ST: 16TH ST | - | T | T | - | F | 24183000 | 24183000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | 16TH ST | 99443 | 99443 | 37.765037181 | -122.421810007 | 16TH ST \ VALENCIA ST | VALENCIA ST \ 16TH ST | 1753130198000 | middleware_editor | NO LEFT TURN (SYM)/NO U TURN (SYM) | 16TH ST intersection | - | NEXT TO LIGHT | - | - | - | - | - | 87616 | 1683097200000 | -122.42188645 | 37.76491738 | - | - | - | D8 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | OVERHEAD MAST ARM | IS | 1682948340000 | VALENCIA 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