Import ISO
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 103576 | N/A | Point | - | - | - | - | S250401 | SLOAT BLVD: 19TH AVE | - | F | F | - | F | 23149000 | 23149000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | SLOAT BLVD | 19TH AVE | 85701 | 85701 | 37.73462557 | -122.47510247 | 19TH AVE \ SLOAT BLVD | SLOAT BLVD \ 19TH AVE | 1710539427000 | MTA | BIKE WAYFINDING SIGN | 19TH AVE intersection | 0345 | W/S OF 19TH/SLOAT ON SIGNAL POLE | - | - | - | - | - | 120871 | 1545307560000 | -122.47510247 | 37.73462557 | - | - | - | D7 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | LIGHT POLE | IS | 1545231720000 | SLOAT BLVD | - | - | - | - | - | - |
| 103577 | N/A | Point | - | - | - | RIGHT ARROW | S228542 | SLOAT BLVD: 19TH AVE | - | F | F | - | F | - | 23149000 | - | - | NORTH SIDE | - | - | - | - | - | 19TH AVE | 65694 | 65694 | 37.73462557 | -122.47510247 | - | SLOAT BLVD \ 19TH AVE | 1710539427000 | MTA | TA (SYM) PLO 8AM-9AM/2:30PM-4PM SCHOOL DAYS (5 MIN) | 19TH AVE intersection | - | 49`EAST OF WPL#200 X ST IS 19TH AVE | - | - | - | - | - | 120872 | 1475751600000 | -122.47510247 | 37.73462557 | - | 1475712000000 | - | D7 | - | OTHER REGULATORY | REG | R38(SF)6.0033 | 14X21 | SUP2 | 2IN IRON POST | IS | 1472640120000 | SLOAT BLVD | - | - | - | - | - | - |
| 103578 | N/A | Point | - | - | - | RIGHT ARROW | S228544 | SLOAT BLVD: 19TH AVE | - | F | F | - | F | 11950203 | 23149000 | - | - | NORTH SIDE | - | - | - | - | ARDENWOOD WAY | 19TH AVE | 129281 | 129281 | 37.73462557 | -122.47510247 | - | SLOAT BLVD \ 19TH AVE | 1717204212000 | middleware_editor | TA (SYM) PLO 8AM-9AM/2:30PM-4PM SCHOOL DAYS (5 MIN) | 19TH AVE intersection | - | E-LINE OF DRIVEWAY OF AVON WAY | - | - | - | - | - | 120873 | 1475751660000 | -122.47510247 | 37.73462557 | - | 1475712000000 | - | D7 | - | OTHER REGULATORY | REG | R38(SF)6.0033 | 14X21 | SUP2 | 2IN IRON POST | IS | 1472640300000 | SLOAT BLVD | 38 - 198 SLOAT BLVD | - | - | - | AVON WAY | - |
| 103579 | N/A | Point | - | - | - | LEFT ARROW | S228540 | SLOAT BLVD: 19TH AVE | - | F | F | - | F | 11950204 | 23149000 | - | - | NORTH SIDE | - | - | - | - | AVON WAY | 19TH AVE | 65693 | 65693 | 37.73462557 | -122.47510247 | - | SLOAT BLVD \ 19TH AVE | 1710539427000 | MTA | TA (SYM) PLO 8AM-9AM/2:30PM-4PM SCHOOL DAYS (5 MIN) | 19TH AVE intersection | - | 34`EAST OF WPL#200 X ST IS 19TH AVE | - | - | - | - | - | 120874 | 1475751600000 | -122.47510247 | 37.73462557 | - | 1475712000000 | - | D7 | - | OTHER REGULATORY | REG | R38(SF)6.0033 | 14X21 | SUP2 | 2IN IRON POST | IS | 1472639760000 | SLOAT BLVD | 200 - 298 SLOAT BLVD | - | - | - | 19TH AVE | - |
| 103580 | N/A | Point | 1 | - | - | - | S281069 | 700-768 BROADWAY | - | F | F | - | F | 3155001 | 3155000 | - | - | NORTH SIDE | - | - | - | - | STOCKTON ST | - | 91645 | 91645 | 37.79756036 | -122.40915395 | - | - | 1710539427000 | MTA | BIKE RACK | - | 480337 | 34' E OF WPL 700/3.5' IN FROM CURB | - | - | - | - | - | 120875 | 1652227200000 | -122.40915395 | 37.79756036 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1645604460000 | BROADWAY | 700 - 720 BROADWAY | BROADWAY | - | - | CORDELIA ST | - |
| 103581 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S253516 | 1300-1399 STOCKTON ST | 1300-1399 STOCKTON ST | F | F | - | F | 12210000 | 12210000 | - | - | WEST SIDE | - | - | - | - | BROADWAY | BROADWAY | 85993 | 85993 | 37.79809945 | -122.40871349 | - | - | 1710539427000 | MTA | TANS 4PM-6PM EXC SAT & SUN | BROADWAY to VALLEJO ST (1300 - 1399) | - | NPL 1355 | - | - | - | - | - | 120876 | 1558004940000 | -122.40871349 | 37.79809945 | - | - | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0026 | 18X21 | SUP1 | LIGHT POLE | IS | 1555146240000 | STOCKTON ST | 1300 - 1399 STOCKTON ST | 1300 - 1399 STOCKTON ST | 1300 STOCKTON ST | - | VALLEJO ST | VALLEJO ST |
| 103582 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S131097 | 1300-1399 STOCKTON ST | 1300-1399 STOCKTON ST | F | F | - | F | 12210000 | 12210000 | - | - | WEST SIDE | - | - | - | - | BROADWAY | BROADWAY | 108778 | 108778 | 37.79809945 | -122.40871349 | - | - | 1710539427000 | MTA | NO DBL PKG ANY TIME COMMERCIAL VEH INCLUDED | BROADWAY to VALLEJO ST (1300 - 1399) | - | 0 / INSTALL SIGN ON LP IFO# 1331 | - | - | - | - | - | 120877 | 1247529600000 | -122.40871349 | 37.79809945 | - | - | 1653004800000 | D3 | - | OTHER REGULATORY | REG | R39-2(CA).0001 | 18X18 | SUP1 | LIGHT POLE | RETD | 1373577300000 | STOCKTON ST | 1300 - 1399 STOCKTON ST | 1300 - 1399 STOCKTON ST | 1300 STOCKTON ST | - | VALLEJO ST | VALLEJO ST |
| 103583 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S131096 | 1300-1399 STOCKTON ST | 1300-1399 STOCKTON ST | F | F | - | F | 12210000 | 12210000 | - | - | EAST SIDE | - | - | - | - | BROADWAY | BROADWAY | 28050 | 28050 | 37.79809945 | -122.40871349 | - | - | 1710539427000 | MTA | NO DBL PKG ANY TIME COMMERCIAL VEH INCLUDED | BROADWAY to VALLEJO ST (1300 - 1399) | - | 0 / INSTALL SIGN ON 2IN POST AT NPL..... | - | - | - | - | - | 120878 | 1247529600000 | -122.40871349 | 37.79809945 | - | - | - | D3 | - | OTHER REGULATORY | REG | R39-2(CA).0001 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373577300000 | STOCKTON ST | 1300 - 1399 STOCKTON ST | 1300 - 1399 STOCKTON ST | 1300 STOCKTON ST | - | VALLEJO ST | VALLEJO ST |
| 103584 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S131098 | 1300-1399 STOCKTON ST | 1300-1399 STOCKTON ST | F | F | - | F | 12210000 | 12210000 | - | - | EAST SIDE | - | - | - | - | BROADWAY | BROADWAY | 28051 | 28051 | 37.79809945 | -122.40871349 | - | - | 1710539427000 | MTA | NO DBL PKG ANY TIME COMMERCIAL VEH INCLUDED | BROADWAY to VALLEJO ST (1300 - 1399) | - | 0 / INSTALL SIGN ON LP IFO# 1352-1356 | - | - | - | - | - | 120879 | 1247529600000 | -122.40871349 | 37.79809945 | - | - | 1653004800000 | D3 | - | OTHER REGULATORY | REG | R39-2(CA).0001 | 18X18 | SUP1 | LIGHT POLE | RETD | 1373577300000 | STOCKTON ST | 1300 - 1399 STOCKTON ST | 1300 - 1399 STOCKTON ST | 1300 STOCKTON ST | - | VALLEJO ST | VALLEJO ST |
| 103585 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S276418 | 1300-1399 STOCKTON ST | 1300-1399 STOCKTON ST | F | F | - | F | 12210000 | 12210000 | - | - | WEST SIDE | - | - | - | - | BROADWAY | BROADWAY | 123562 | 123562 | 37.79809945 | -122.40871349 | - | - | 1710539427000 | MTA | BIKE RACK | BROADWAY to VALLEJO ST (1300 - 1399) | 383932 | 43' N OF SPL 1301/3.5' IN FROM CURB | - | - | - | - | - | 120880 | 1628768400000 | -122.40871349 | 37.79809945 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1626959520000 | STOCKTON ST | 1300 - 1399 STOCKTON ST | 1300 - 1399 STOCKTON ST | 1300 STOCKTON ST | - | VALLEJO ST | VALLEJO ST |
| 103586 | N/A | Point | - | - | - | RIGHT ARROW | S221804 | STOCKTON ST: BROADWAY | - | F | F | - | F | - | 25057000 | R(SF).0011-2009-04-09 00:00:00-37.79762756--122.40861885 | - | SOUTH SIDE | - | - | - | - | - | BROADWAY | 60928 | 60928 | 37.79762756 | -122.40861885 | - | STOCKTON ST \ BROADWAY | 1710539427000 | MTA | BIKE (SYM) PRK | BROADWAY intersection | - | 65' EAST OF UTAH | - | - | - | - | - | 120881 | 1239235200000 | -122.40861885 | 37.79762756 | - | 1458000000000 | - | D3 | - | PARKING | REG | R(SF).0011 | 18X24 | SUP1 | LIGHT POLE | IS | 1451980740000 | STOCKTON ST | - | - | - | - | - | - |
| 103587 | N/A | Point | - | - | - | - | S284244 | TURK MURPHY LN: BROADWAY | - | F | F | - | F | 12753000 | 25066000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | - | BROADWAY | 128967 | 128967 | 37.79749315 | -122.40968904 | - | TURK MURPHY LN \ BROADWAY | 1710539427000 | MTA | TURK MURPHY LN | BROADWAY intersection | - | END. | - | - | - | - | - | 120882 | - | -122.40968904 | 37.79749315 | - | 1659657600000 | - | D3 | - | STREET NAME | GUIDE | D3-1.1757 | 36X08 | SUP1 | LIGHT POLE | IS | 1659349980000 | TURK MURPHY LN | - | - | - | - | - | - |
| 103588 | N/A | Point | - | - | - | - | S203151 | BROADWAY: TURK MURPHY LN | - | F | F | - | F | - | 25066000 | - | - | NORTH WEST CORNER | - | - | - | - | - | BROADWAY | 42816 | 42816 | 37.79749315 | -122.40968904 | - | TURK MURPHY LN \ BROADWAY | 1710539427000 | MTA | TANS 3PM-7PM EXC SAT & SUN | BROADWAY intersection | - | AT EPL# 778 | - | - | - | - | - | 120883 | 1393599900000 | -122.40968904 | 37.79749315 | - | 1393545600000 | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | LIGHT POLE | IS | 1392878820000 | TURK MURPHY LN | - | - | - | - | - | - |
| 103589 | N/A | Point | - | - | - | DOUBLE ARROW | 25831 | - | - | - | - | - | - | 4799201 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1702322375000 | jsanfel | - | - | HAIGHT ST | - | 174801 | 174801 | 37.7718010150241 | -122.437052709014 | - | - | 1720559397000 | middleware_editor | PAGE SLOW ST FAMILY,H/C,PED,SKATEBOARD,BIKE (SYM) (COMBO) | - | - | IFO #280 | - | - | - | - | - | 120884 | 1702393680000 | - | - | - | - | - | 05 | - | OTHER REGULATORY | REG | R(SF).0515 | 24X30 | SUP2 | MUNI POLE | IS | - | DIVISADERO ST | 250 - 298 DIVISADERO ST | - | - | - | PAGE ST | - |
| 103590 | N/A | Point | - | - | - | - | S101289 | PALOU AVE: INDUSTRIAL ST | - | F | F | - | F | 20755000 | 20755000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | INDUSTRIAL ST | PALOU AVE | 968 | 968 | 37.73965912 | -122.40089902 | PALOU AVE \ INDUSTRIAL ST | INDUSTRIAL ST \ PALOU AVE | 1754432897000 | middleware_editor | STOP | PALOU AVE intersection | - | 0 / 00 | - | - | - | - | - | 120885 | -399315600000 | -122.40089902 | 37.73965912 | - | 1524466800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566740000 | INDUSTRIAL ST | - | - | - | - | - | - |
| 103591 | N/A | Point | - | - | - | DOUBLE ARROW | 25815 | - | - | - | - | - | - | 3862000 | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1702317457000 | jsanfel | - | - | PAGE ST | - | 174769 | 174769 | 37.7716123197318 | -122.443954033052 | - | - | 1710539427000 | MTA | PAGE SLOW ST FAMILY,H/C,PED,SKATEBOARD,BIKE (SYM) (COMBO) | - | - | 60' NORTH OF PAGE | - | - | - | - | - | 120886 | 1702389960000 | - | - | - | - | - | 05 | - | OTHER REGULATORY | REG | R(SF).0515 | 24X30 | SUP2 | 2IN IRON POST | IS | - | CENTRAL AVE | 200 - 299 CENTRAL AVE | - | - | - | OAK ST | - |
| 103592 | N/A | Point | 1 | 1 | 1 - 45 | - | S148665 | 1-45 SANTA CLARA AVE | 1-45 SANTA CLARA AVE | F | F | - | F | 11568000 | 11568000 | - | - | EAST SIDE | - | - | - | - | PORTOLA DR \ VICENTE ST | PORTOLA DR \ VICENTE ST | 40716 | 40716 | 37.73886474 | -122.46600112 | - | - | 1710539427000 | MTA | NPRK 1PM-3PM 2ND & 4TH MON OF MONTH STCL | PORTOLA DR \ VICENTE ST to SANTA MONICA WAY \ YERBA BUENA AVE (1 - 45) | - | 15 SANTA CLARA | - | - | - | - | - | 120887 | 1224806400000 | -122.46600112 | 37.73886474 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0099 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1375728960000 | SANTA CLARA AVE | 1 - 45 SANTA CLARA AVE | 1 - 45 SANTA CLARA AVE | 1 SANTA CLARA AVE | - | SANTA MONICA WAY \ YERBA BUENA AVE | SANTA MONICA WAY \ YERBA BUENA AVE |
| 103593 | N/A | Point | 1 | 1 | 100 - 149 | - | S208637 | 100-149 KEARNY ST | 100-149 KEARNY ST | F | F | - | F | 7749000 | 7749000 | - | - | WEST SIDE | - | - | - | - | POST ST | POST ST | 50959 | 50959 | 37.78912885 | -122.40370376 | - | - | 1719450574000 | middleware_editor | NPRK 2AM-6AM EVERYDAY INCLUDING HOLIDAY STCL | POST ST to VER MEHR PL (100 - 149) | - | INFO #153 | - | - | - | - | - | 120888 | - | -122.40370376 | 37.78912885 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0113 | 18X18 | SUP1 | 2IN FLANGE POST | IS | 1409314680000 | KEARNY ST | 100 - 149 KEARNY ST | 100 - 149 KEARNY ST | 100 KEARNY ST | - | VER MEHR PL | VER MEHR PL |
| 103594 | N/A | Point | 1 | 1 | 100 - 149 | - | S135367 | 100-149 KEARNY ST | 100-149 KEARNY ST | F | F | - | F | 7749000 | 7749000 | - | - | WEST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | POST ST | POST ST | 25859 | 25859 | 37.78912885 | -122.40370376 | - | - | 1719450581000 | middleware_editor | SUTTER-STOCKTON (LA) UNION SQUARE (LA) | POST ST to VER MEHR PL (100 - 149) | - | NPL #153 | - | - | - | - | - | 120889 | 1321488000000 | -122.40370376 | 37.78912885 | - | - | - | D3 | - | OTHER GUIDE | GUIDE | G-S(SF).0040 | 30X30 | SUP1 | LIGHT POLE | IS | 1373578620000 | KEARNY ST | 100 - 149 KEARNY ST | 100 - 149 KEARNY ST | 100 KEARNY ST | - | VER MEHR PL | VER MEHR PL |
| 103595 | N/A | Point | 1 | 1 | 1 - 45 | - | S213754 | 1-45 SANTA CLARA AVE | 1-45 SANTA CLARA AVE | F | F | - | F | 11568000 | 11568000 | - | - | WEST SIDE | - | - | - | - | PORTOLA DR \ VICENTE ST | PORTOLA DR \ VICENTE ST | 50682 | 50682 | 37.73886474 | -122.46600112 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "O" PERMITS | PORTOLA DR \ VICENTE ST to SANTA MONICA WAY \ YERBA BUENA AVE (1 - 45) | - | 14 SANTA CLARA | - | - | - | - | - | 120890 | 1225065600000 | -122.46600112 | 37.73886474 | - | - | - | D7 | - | PARKING:RPP | REG | R32C(CA).0097 | 18X21 | SUP2 | LIGHT POLE | IS | 1424786280000 | SANTA CLARA AVE | 1 - 45 SANTA CLARA AVE | 1 - 45 SANTA CLARA AVE | 1 SANTA CLARA AVE | - | SANTA MONICA WAY \ YERBA BUENA AVE | SANTA MONICA WAY \ YERBA BUENA AVE |
| 103596 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S262453 | 1500-1599 YOSEMITE AVE | 1500-1599 YOSEMITE AVE | F | F | - | F | 13781000 | 13781000 | - | - | NORTH SIDE | - | - | - | - | JENNINGS ST | JENNINGS ST | 110628 | 110628 | 37.72632094 | -122.39073526 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM MON STCL | JENNINGS ST to KEITH ST (1500 - 1599) | - | EPL 1552 | - | - | - | - | - | 120891 | 1585747140000 | -122.39073526 | 37.72632094 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0048 | 18X18 | SUP1 | 2IN IRON POST | IS | 1583918460000 | YOSEMITE AVE | 1500 - 1599 YOSEMITE AVE | 1500 - 1599 YOSEMITE AVE | 1500 YOSEMITE AVE | - | KEITH ST | KEITH ST |
| 103597 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S225988 | 1500-1599 YOSEMITE AVE | 1500-1599 YOSEMITE AVE | F | F | - | F | 13781000 | 13781000 | - | - | NORTH SIDE | - | - | - | - | JENNINGS ST | JENNINGS ST | 60942 | 60942 | 37.72632094 | -122.39073526 | - | - | 1756130424000 | middleware_editor | BIKE RACK | JENNINGS ST to KEITH ST (1500 - 1599) | 20154705 | IFO #1598 (1) SEE NOTES | - | - | - | - | - | 120892 | 1464730560000 | -122.39073526 | 37.72632094 | - | 1464678000000 | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1464251400000 | YOSEMITE AVE | 1500 - 1599 YOSEMITE AVE | 1500 - 1599 YOSEMITE AVE | 1500 YOSEMITE AVE | - | KEITH ST | KEITH ST |
| 103598 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S261914 | 1500-1599 YOSEMITE AVE | 1500-1599 YOSEMITE AVE | F | F | - | F | 13781000 | 13781000 | - | - | NORTH SIDE | - | - | - | - | JENNINGS ST | JENNINGS ST | 107877 | 107877 | 37.72632094 | -122.39073526 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM MON STCL | JENNINGS ST to KEITH ST (1500 - 1599) | - | 25FT WEST OF JENNINGS | - | - | - | - | - | 120893 | 1589546100000 | -122.39073526 | 37.72632094 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0048 | 18X18 | SUP1 | 2IN IRON POST | IS | 1582709400000 | YOSEMITE AVE | 1500 - 1599 YOSEMITE AVE | 1500 - 1599 YOSEMITE AVE | 1500 YOSEMITE AVE | - | KEITH ST | KEITH ST |
| 103599 | N/A | Point | - | - | - | - | 24569 | - | - | F | F | - | F | 2341000 | - | - | - | CENTER ISLAND, E LINE, EASTBOUND | 1696960440000 | malopez | - | - | 23RD AVE | - | 161346 | 161346 | 37.7782272841508 | -122.483403394553 | - | - | 1710539427000 | MTA | TYPE Q DELINEATOR (IPR) | - | - | CNTR ISLAND END OF 3200 BLK | - | - | - | - | 1 | 120894 | 1698164280000 | - | - | - | - | - | 01 | - | DELINEATOR 5 | WARNING | TYPE-Q(CA).0001 | 02X24 | SUP2 | DELINEATOR BASE SAFE HIT | IS | - | - | 3200 - 3299 ANZA ST | - | - | - | 24TH AVE | - |
| 103600 | N/A | Point | - | - | - | - | 25633 | - | - | F | F | - | F | 9119000 | - | - | - | WEST SIDE | 1701459437000 | jrasmuss | - | - | SYCAMORE ST | - | 172501 | 172501 | 37.7625260074702 | -122.419525697856 | - | - | 1722531702000 | middleware_editor | BIKE RACK | - | - | 17' N OF SPL 2152/3.5' IN FROM CURB | - | - | - | - | - | 120895 | - | - | - | - | - | - | 09 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP3 | BIKE RACK | IS | - | MISSION ST | 2141 - 2199 MISSION ST | - | - | - | 18TH ST | - |
| 103601 | N/A | Point | - | - | - | - | S110399 | PRENTISS ST: JARBOE AVE | - | F | F | - | F | 21064000 | 21064000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | JARBOE AVE | PRENTISS ST | 8502 | 8502 | 37.73824446 | -122.4121252 | PRENTISS ST \ JARBOE AVE | JARBOE AVE \ PRENTISS ST | 1747763157000 | middleware_editor | STOP | PRENTISS ST intersection | - | 00 / 0 | - | - | - | - | - | 120896 | 631958400000 | -122.4121252 | 37.73824446 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570820000 | JARBOE AVE | - | - | - | - | - | - |
| 103602 | N/A | Point | - | - | - | - | S230766 | ILLINOIS ST: AMADOR ST | - | T | T | - | F | 54330000 | 54330000 | - | - | WEST SIDE | - | - | - | - | ILLINOIS ST | AMADOR ST | 129703 | 129703 | 37.74575699 | -122.38606019 | AMADOR ST \ ILLINOIS ST | ILLINOIS ST \ AMADOR ST | 1710539427000 | MTA | LA (WHITE ON BLUE) TSUNAMI | AMADOR ST intersection | - | IFO #600 | - | - | - | - | - | 120897 | 1489500300000 | -122.38606019 | 37.74575699 | - | 1489449600000 | - | 10 | - | OTHER GUIDE | GUIDE | M5-1.0001 | 21X15 | SUP1 | LIGHT POLE | IS | 1478683800000 | ILLINOIS ST | - | - | - | - | - | - |
| 103603 | N/A | Point | - | - | - | - | S246402 | MCALLISTER ST: LYON ST | - | F | F | - | F | 26374000 | 26374000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | LYON ST | LYON ST | 81707 | 81707 | 37.77716445 | -122.44332106 | MCALLISTER ST \ LYON ST | MCALLISTER ST \ LYON ST | 1710539427000 | MTA | FG 300 EFX DELINEATOR (Y) | LYON ST intersection | - | - | - | - | - | - | - | 120898 | 1524441600000 | -122.44332106 | 37.77716445 | - | 1529020800000 | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1528970880000 | MCALLISTER ST | - | - | - | - | - | - |
| 103604 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S202451 | 2200-2299 MARIPOSA ST | 2200-2299 MARIPOSA ST | F | F | - | F | 8728000 | 8728000 | - | - | EAST SIDE, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | SAN BRUNO AVE | SAN BRUNO AVE | 42130 | 42130 | 37.76327832 | -122.40593604 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | SAN BRUNO AVE to UTAH ST (2200 - 2299) | - | CENTER LINE END OF MARIPOSA | - | - | - | - | - | 120899 | - | -122.40593604 | 37.76327832 | - | - | - | D10 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP1 | 2IN IRON POST | IS | 1390477740000 | MARIPOSA ST | 2200 - 2299 MARIPOSA ST | 2200 - 2299 MARIPOSA ST | 2200 MARIPOSA ST | - | UTAH ST | UTAH ST |
| 103605 | N/A | Point | 1 | 1 | 100 - 199 | - | S204980 | 100-199 ROOSEVELT WAY | 100-199 ROOSEVELT WAY | F | F | - | F | 11141000 | 11141000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | BUENA VISTA TER | BUENA VISTA TER | 45131 | 45131 | 37.76669587 | -122.43889804 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | BUENA VISTA TER to 15TH ST \ PARK HILL AVE (100 - 199) | - | 22FT,EAST OF BUENA VISTA | - | - | - | - | - | 120900 | 1473169620000 | -122.43889804 | 37.76669587 | - | 1473120000000 | - | D8 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP2 | 2IN IRON POST | IS | 1397737920000 | ROOSEVELT WAY | 100 - 199 ROOSEVELT WAY | 100 - 199 ROOSEVELT WAY | 100 ROOSEVELT WAY | - | 15TH ST \ PARK HILL AVE | 15TH ST \ PARK HILL AVE |
| 103606 | N/A | Point | - | - | - | - | S225156 | IRVING ST: 2ND AVE | - | F | F | - | F | 27068000 | 27068000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | IRVING ST | 02ND AVE | 62367 | 62367 | 37.76436586 | -122.45881507 | 2ND AVE \ IRVING ST | IRVING ST \ 02ND AVE | 1723770183000 | middleware_editor | OBJECT MARKER - YELLOW | 02ND AVE intersection | - | ON MUNI PLATFORM | - | - | - | - | - | 120901 | - | -122.45881507 | 37.76436586 | - | - | - | D5 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP1 | BARRICADE | IS | 1461751320000 | IRVING ST | - | - | - | - | - | - |
| 103607 | N/A | Point | 1 | 1 | 400 - 499 | - | S113357 | 400-499 POTRERO AVE | 400-499 POTRERO AVE | F | F | - | F | 10662000 | 10662000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | 17TH ST | 17TH ST | 6625 | 6625 | 37.76383782 | -122.40736229 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | 17TH ST to MARIPOSA ST (400 - 499) | - | BACK TO BACK | - | - | - | - | - | 120902 | 987811200000 | -122.40736229 | 37.76383782 | - | - | - | D10 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP1 | 2IN IRON POST | IS | 1373571720000 | POTRERO AVE | 400 - 499 POTRERO AVE | 400 - 499 POTRERO AVE | 400 POTRERO AVE | - | MARIPOSA ST | MARIPOSA ST |
| 103608 | N/A | Point | 1 | 1 | 400 - 499 | RIGHT ARROW | S283511 | 400-499 WINSTON DR | 400-499 WINSTON DR | F | F | - | F | 13689000 | 13689000 | - | - | SOUTH SIDE | - | - | - | - | BUCKINGHAM WAY | BUCKINGHAM WAY | 95213 | 95213 | 37.72771589 | -122.48118078 | - | - | 1748641594000 | middleware_editor | TANSAT | BUCKINGHAM WAY to LAKE MERCED BLVD (400 - 499) | - | AT MIDBLOCK CROSSWALK | - | - | - | - | - | 120903 | - | -122.48118078 | 37.72771589 | - | 1655881200000 | - | D7 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | 1655370060000 | WINSTON DR | 400 - 499 WINSTON DR | 400 - 499 WINSTON DR | 400 WINSTON DR | - | LAKE MERCED BLVD | LAKE MERCED BLVD |
| 103609 | N/A | Point | - | - | - | INBOUND | S240789 | MISSION ST: 20TH ST | - | F | F | - | F | 24144000 | 24144000 | - | - | EAST SIDE | - | - | - | - | MISSION ST | 20TH ST | 75830 | 75830 | 37.75863257 | -122.41905261 | 20TH ST \ MISSION ST | MISSION ST \ 20TH ST | 1710539427000 | MTA | BIKE RACK RAPID | 20TH ST intersection | 15557 | INFO 2369/ PAINT MARK | - | - | - | - | - | 120904 | 1518188820000 | -122.41905261 | 37.75863257 | - | 1518134400000 | - | D9 | - | BIKE RACK | REG | R(SF).0353 | 02X36 | SUP2 | BIKE RACK | IS | 1511291700000 | MISSION ST | - | - | - | - | - | - |
| 103610 | N/A | Point | - | - | - | INBOUND | S240798 | MISSION ST: 20TH ST | - | F | F | - | F | 24144000 | 24144000 | - | - | EAST SIDE | - | - | - | - | MISSION ST | 20TH ST | 75896 | 75896 | 37.75863257 | -122.41905261 | 20TH ST \ MISSION ST | MISSION ST \ 20TH ST | 1710539427000 | MTA | BIKE RACK RAPID | 20TH ST intersection | 15557 | 11 FT SOUTH OF 20TH/ PAINT MARK | - | - | - | - | - | 120905 | 1518007980000 | -122.41905261 | 37.75863257 | - | 1517961600000 | - | D9 | - | BIKE RACK | REG | R(SF).0353 | 02X36 | SUP2 | BIKE RACK | IS | 1511291820000 | MISSION ST | - | - | - | - | - | - |
| 103611 | N/A | Point | - | - | - | - | S111622 | IDORA AVE: LAGUNA HONDA BLVD | - | F | F | - | F | 7158101 | 22841000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LAGUNA HONDA BLVD | IDORA AVE | 6694 | 6694 | 37.74405759 | -122.45652506 | - | LAGUNA HONDA BLVD \ IDORA AVE | 1710539427000 | MTA | STOP | IDORA AVE intersection | - | - | - | - | - | - | - | 120906 | 830217600000 | -122.45652506 | 37.74405759 | - | - | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571180000 | LAGUNA HONDA BLVD | 101 - 181 IDORA AVE | - | - | - | ROCK ALY | - |
| 103612 | N/A | Point | - | - | - | - | S229833 | HAYES ST: COLE ST | - | F | F | - | F | 26423000 | 26423000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HAYES ST | COLE ST | 114651 | 114651 | 37.77331565 | -122.45097375 | COLE ST \ HAYES ST | HAYES ST \ COLE ST | 1743197304000 | middleware_editor | ALL WAY | COLE ST intersection | - | 9E / 5E OF TELEPHONE POLE | - | - | - | - | - | 120907 | 691833600000 | -122.45097375 | 37.77331565 | - | 1743188400000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1476435660000 | HAYES ST | - | - | - | - | - | - |
| 103613 | N/A | Point | - | - | - | - | S241569 | HAYES ST: COLE ST | - | T | T | - | F | 26423000 | 26423000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | HAYES ST | COLE ST | 72635 | 72635 | 37.77331565 | -122.45097375 | COLE ST \ HAYES ST | HAYES ST \ COLE ST | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | COLE ST intersection | 135886 | 35`WEST OF COLE | - | - | - | - | - | 120908 | 1329868800000 | -122.45097375 | 37.77331565 | - | - | - | D5 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP1 | LIGHT POLE | IS | 1580728860000 | HAYES ST | - | - | - | - | - | - |
| 103614 | N/A | Point | - | - | - | DOUBLE ARROW | 25536 | - | - | - | - | - | - | 11855000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1701280993000 | jsanfel | - | - | PAGE ST | - | 171862 | 171862 | 37.7701074295477 | -122.451950452093 | - | - | 1711063520000 | middleware_editor | PAGE SLOW ST FAMILY,H/C,PED,SKATEBOARD,BIKE (SYM) (COMBO) | - | - | 50' SOUTH OF PAGE | - | - | - | - | - | 120909 | 1701957600000 | - | - | - | - | - | 05 | - | OTHER REGULATORY | REG | R(SF).0515 | 24X30 | SUP2 | 2IN IRON POST | IS | - | SHRADER ST | 500 - 599 SHRADER ST | - | - | - | HAIGHT ST | - |
| 103615 | N/A | Point | - | - | - | LEFT ARROW | 25531 | - | - | - | T | - | - | 12089000 | - | - | - | WEST SIDE | 1701280272000 | jsanfel | - | - | OAK ACCESS RD \ OAK ST | - | 171859 | 171859 | 37.7703099101013 | -122.453866890761 | - | - | 1710539427000 | MTA | PAGE SLOW ST FAMILY,H/C,PED,SKATEBOARD,BIKE (SYM) (COMBO) | - | - | 44' north of page. 0 | - | - | - | - | - | 120910 | 1707400800000 | - | - | - | - | - | 05 | - | OTHER REGULATORY | REG | R(SF).0515 | 24X30 | SUP2 | MUNI POLE | IS | - | - | 600 - 649 STANYAN ST | - | - | - | PAGE ST | - |
| 103616 | N/A | Point | - | - | - | - | S223448 | SLOAT BLVD: 19TH AVE | - | T | T | - | F | - | 23149000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | - | 19TH AVE | 59336 | 59336 | 37.73462557 | -122.47510247 | - | SLOAT BLVD \ 19TH AVE | 1710539427000 | MTA | BICYCLE (SYM) ALLOWED USE OF FULL LANE CVC 21202 | 19TH AVE intersection | - | W-LINE (X ST IS 19TH AVE) | - | - | - | - | - | 120911 | 1080864000000 | -122.47510247 | 37.73462557 | - | - | - | D7 | - | OTHER WARNING | WARNING | W11-1(SF).0001 | 30X30 | SUP2 | SIGNAL POLE | IS | 1455619860000 | SLOAT BLVD | - | - | - | - | - | - |
| 103617 | N/A | Point | - | - | - | - | S289936 | 19TH AVE: SLOAT BLVD | - | T | T | - | F | 924201 | 23149000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WAWONA ST | 19TH AVE | 121771 | 121771 | 37.73462557 | -122.47510247 | - | SLOAT BLVD \ 19TH AVE | 1710539427000 | MTA | 19TH AVE | 19TH AVE intersection | - | - | - | - | - | - | - | 120912 | - | -122.47510247 | 37.73462557 | - | - | - | D7 | - | STREET NAME | GUIDE | D3-2.0018 | 72X18 | SUP2 | OVERHEAD MAST ARM | IS | 1685618340000 | SLOAT BLVD | 2701 - 2899 19TH AVE | - | - | - | SLOAT BLVD | - |
| 103618 | N/A | Point | - | - | - | - | S286173 | 19TH AVE: SLOAT BLVD | - | T | T | - | F | 925101 | 23149000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SLOAT BLVD | 19TH AVE | 100473 | 100473 | 37.73462557 | -122.47510247 | - | SLOAT BLVD \ 19TH AVE | 1710539427000 | MTA | 19TH AVE | 19TH AVE intersection | - | - | - | - | - | - | - | 120913 | 1297123200000 | -122.47510247 | 37.73462557 | - | 1669593600000 | - | D7 | - | STREET NAME | GUIDE | D3-2.0018 | 72X18 | SUP2 | LIGHT POLE | IS | 1669635600000 | SLOAT BLVD | 2900 - 2998 19TH AVE | - | - | - | OCEAN AVE | - |
| 103619 | N/A | Point | - | - | - | - | S106532 | CHERRY ST: CLAY ST | - | F | F | - | F | 27571000 | 27571000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CLAY ST | CHERRY ST | 112629 | 112629 | 37.78780934 | -122.45705805 | CHERRY ST \ CLAY ST | CLAY ST \ CHERRY ST | 1710539427000 | MTA | STOP | CHERRY ST intersection | - | 0 / 0 | - | - | - | - | - | 120914 | 147398400000 | -122.45705805 | 37.78780934 | - | 1545004800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373569560000 | CLAY ST | - | - | - | - | - | - |
| 103620 | N/A | Point | - | - | - | - | S252838 | CHERRY ST: CLAY ST | - | F | F | - | F | 27571000 | 27571000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CLAY ST | CHERRY ST | 79381 | 79381 | 37.78780934 | -122.45705805 | CHERRY ST \ CLAY ST | CLAY ST \ CHERRY ST | 1710539427000 | MTA | BIKE WAYFINDING SIGN | CHERRY ST intersection | 0798 | ABOVE STOP SIGN | - | - | - | - | - | 120915 | 1157932800000 | -122.45705805 | 37.78780934 | - | 1557273600000 | - | D2 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | LIGHT POLE | IS | 1553772120000 | CLAY ST | - | - | - | - | - | - |
| 103621 | N/A | Point | - | - | - | - | S276468 | CLAY ST: ARGUELLO BLVD | - | F | F | - | F | 27574000 | 27574000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CLAY ST | CLAY ST | 124226 | 124226 | 37.78752072 | -122.45932351 | ARGUELLO BLVD \ CLAY ST | ARGUELLO BLVD \ CLAY ST | 1712179502000 | middleware_editor | SLOW STREETS FAMILY, H/C, PED, SKATEBOARD, BIKE (SYM)(COMBO) | CLAY ST intersection | - | 9FT AND 14 " 9 FROM CURB X IS ARGUELLO | - | - | - | - | - | 120916 | 1583884800000 | -122.45932351 | 37.78752072 | - | 1628640000000 | 1712144880000 | D2 | - | OTHER REGULATORY | REG | R(SF).0451 | 12X36 | SUP1 | CITY POST EMBEDDED ACHOR CUP 4 | RETD | 1627298520000 | ARGUELLO BLVD | - | - | - | - | - | - |
| 103622 | N/A | Point | - | - | - | - | S247459 | BROADWAY: TURK MURPHY LN | - | T | T | - | F | 12753000 | 25066000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | - | BROADWAY | 80299 | 80299 | 37.79749315 | -122.40968904 | - | TURK MURPHY LN \ BROADWAY | 1710539427000 | MTA | "P" (WHITE-BLUE) | BROADWAY intersection | - | - | - | - | - | - | - | 120917 | 1534335000000 | -122.40968904 | 37.79749315 | - | - | - | D3 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1533120780000 | TURK MURPHY LN | - | - | - | - | - | - |
| 103623 | N/A | Point | - | - | - | - | S253005 | BROADWAY: POWELL ST \ ROBERT C | - | F | F | - | F | 3186201 | 25111000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | BROADWAY \ POWELL ST | BROADWAY \ POWELL ST | 78252 | 78252 | 37.79742019 | -122.41026353 | - | ROBERT C LEVY TUNL \ BROADWAY \ POWELL ST | 1710539427000 | MTA | BIKE WAYFINDING SIGN | BROADWAY \ POWELL ST intersection | 0851 | 30 FEET WEST OF POWELL 1 | - | - | - | - | - | 120918 | 1557187200000 | -122.41026353 | 37.79742019 | - | - | - | D3 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | LIGHT POLE | IS | 1554123300000 | ROBERT C LEVY TUNL | 0 - 0 ROBERT C LEVY TUNL | - | - | - | BROADWAY \ LARKIN ST | - |
| 103624 | N/A | Point | - | - | - | - | S253004 | BROADWAY: POWELL ST \ ROBERT C | - | F | F | - | F | 3186201 | 25111000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | BROADWAY \ POWELL ST | BROADWAY \ POWELL ST | 77978 | 77978 | 37.79742019 | -122.41026353 | - | ROBERT C LEVY TUNL \ BROADWAY \ POWELL ST | 1710539427000 | MTA | BIKE WAYFINDING SIGN | BROADWAY \ POWELL ST intersection | 0850 | 30 FEET WEST OF POWELL | - | - | - | - | - | 120919 | 1557187200000 | -122.41026353 | 37.79742019 | - | - | - | D3 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | LIGHT POLE | IS | 1554122820000 | ROBERT C LEVY TUNL | 0 - 0 ROBERT C LEVY TUNL | - | - | - | BROADWAY \ LARKIN ST | - |
| 103625 | N/A | Point | - | - | - | - | S238381 | BROADWAY: POWELL ST \ ROBERT C | - | F | F | - | F | 25111000 | 25111000 | - | - | NORTH WEST CORNER | - | - | - | - | BROADWAY \ ROBERT C LEVY TUNL | BROADWAY \ POWELL ST | 105292 | 105292 | 37.79742019 | -122.41026353 | POWELL ST \ BROADWAY \ ROBERT C LEVY TUNL | ROBERT C LEVY TUNL \ BROADWAY \ POWELL ST | 1710539427000 | MTA | NPRK ANY TIME | BROADWAY \ POWELL ST intersection | - | @ POWELL | - | - | - | - | - | 120920 | 1503360000000 | -122.41026353 | 37.79742019 | - | 1503360000000 | - | D3 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0002 | 18X18 | SUP1 | LIGHT POLE | IS | 1503321000000 | ROBERT C LEVY TUNL | - | - | - | - | - | - |
| 103626 | N/A | Point | - | - | - | - | S236076 | BROADWAY: POWELL ST \ ROBERT C | - | T | T | - | F | 25111000 | 25111000 | - | - | NORTH WEST CORNER | - | - | - | - | BROADWAY \ ROBERT C LEVY TUNL | BROADWAY \ POWELL ST | 68689 | 68689 | 37.79742019 | -122.41026353 | POWELL ST \ BROADWAY \ ROBERT C LEVY TUNL | ROBERT C LEVY TUNL \ BROADWAY \ POWELL ST | 1744145701000 | middleware_editor | POWELL ST | BROADWAY \ POWELL ST intersection | - | OF BROADWAY & POWELL ST. | - | - | - | - | - | 120921 | - | -122.41026353 | 37.79742019 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-2.0285 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1494582840000 | ROBERT C LEVY TUNL | - | - | - | - | - | - |
| 103627 | N/A | Point | - | - | - | - | 25720 | - | - | F | F | - | F | 26950000 | - | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | 1701813153000 | elclark | - | - | SPRUCE ST | - | 173332 | 173332 | 37.7890289683149 | -122.453867555792 | WASHINGTON ST \ SPRUCE ST | - | 1710539427000 | MTA | ALL WAY | - | - | - | - | - | - | - | - | 120922 | - | - | - | - | 1702390500000 | - | 02 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | - | WASHINGTON ST | - | - | - | - | - | - |
| 103628 | N/A | Point | - | - | - | - | S102298 | WASHINGTON ST: JONES ST | - | F | F | - | F | 25119000 | 25119000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 125604 | 125604 | 37.79410981 | -122.41464763 | JONES ST \ WASHINGTON ST | JONES ST \ WASHINGTON ST | 1710539427000 | MTA | ONE WAY (LA) | WASHINGTON ST intersection | - | 0 / 0 | - | - | - | - | - | 120923 | -389404800000 | -122.41464763 | 37.79410981 | - | 1598918400000 | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373568240000 | JONES ST | - | - | - | - | - | - |
| 103629 | N/A | Point | - | - | - | - | S211596 | WASHINGTON ST: JONES ST | - | F | F | - | F | 25119000 | 25119000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 53186 | 53186 | 37.79410981 | -122.41464763 | JONES ST \ WASHINGTON ST | JONES ST \ WASHINGTON ST | 1710539427000 | MTA | TANSAT (RA) | WASHINGTON ST intersection | - | - | - | - | - | - | - | 120924 | 1138147200000 | -122.41464763 | 37.79410981 | - | 1598918400000 | - | D3 | - | TOW (TANSAT) | REG | R37(CA).0094 | 18X21 | SUP1 | 2IN IRON POST | IS | 1418198820000 | JONES ST | - | - | - | - | - | - |
| 103630 | N/A | Point | 1 | 1 | 400 - 489 | - | S141285 | 400-489 42ND AVE | 400-489 42ND AVE | F | F | - | F | 1926000 | 1926000 | - | - | EAST SIDE | - | - | - | - | CLEMENT ST \ VETERANS DR | CLEMENT ST \ VETERANS DR | 33436 | 33436 | 37.78039326 | -122.50302936 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM 2ND & 4TH FRI OF MONTH STCL | CLEMENT ST \ VETERANS DR to GEARY BLVD \ POINT LOBOS AVE (400 - 489) | - | 20`NORTH OF POINT LOBOS (SEE PAINT) | - | - | - | - | - | 120925 | 1221177600000 | -122.50302936 | 37.78039326 | - | 1702392840000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0071 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375725720000 | 42ND AVE | 400 - 489 42ND AVE | 400 - 489 42ND AVE | 400 42ND AVE | - | GEARY BLVD \ POINT LOBOS AVE | GEARY BLVD \ POINT LOBOS AVE |
| 103631 | N/A | Point | - | - | - | - | S255468 | JONES ST: WASHINGTON ST | - | F | F | - | F | 25119000 | 25119000 | - | - | SOUTH EAST CORNER | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 88452 | 88452 | 37.79410981 | -122.41464763 | JONES ST \ WASHINGTON ST | JONES ST \ WASHINGTON ST | 1710539427000 | MTA | WASHINGTON ST | WASHINGTON ST intersection | - | - | - | - | - | - | - | 120926 | 1563548280000 | -122.41464763 | 37.79410981 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-1.1833 | 36X08 | SUP1 | 3IN IRON POST | IS | 1561025520000 | JONES ST | - | - | - | - | - | - |
| 103632 | N/A | Point | - | - | - | - | S255469 | JONES ST: WASHINGTON ST | - | F | F | - | F | 25119000 | 25119000 | - | - | SOUTH EAST CORNER | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 115810 | 115810 | 37.79410981 | -122.41464763 | JONES ST \ WASHINGTON ST | JONES ST \ WASHINGTON ST | 1710539427000 | MTA | JONES ST | WASHINGTON ST intersection | - | - | - | - | - | - | - | 120927 | 1563548340000 | -122.41464763 | 37.79410981 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-1.0935 | 36X08 | SUP1 | 3IN IRON POST | IS | 1561025580000 | JONES ST | - | - | - | - | - | - |
| 103633 | N/A | Point | 1 | 1 | 700 - 799 | - | S234760 | 700-799 7TH AVE | 700-799 07TH AVE | F | F | - | F | 356000 | 356000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CABRILLO ST | CABRILLO ST | 69051 | 69051 | 37.77440485 | -122.46487688 | - | - | 1710539427000 | MTA | SPEED HUMPS | CABRILLO ST to FULTON ST (700 - 799) | - | @ SPL# 776-7TH AVE. | - | - | - | - | - | 120928 | 1491826080000 | -122.46487688 | 37.77440485 | - | 1491782400000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1490875080000 | 07TH AVE | 700 - 799 7TH AVE | 700 - 799 07TH AVE | 700 7TH AVE | - | FULTON ST | FULTON ST |
| 103634 | N/A | Point | 1 | 1 | 700 - 799 | - | S234762 | 700-799 7TH AVE | 700-799 07TH AVE | F | F | - | F | 356000 | 356000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | CABRILLO ST | CABRILLO ST | 118581 | 118581 | 37.77440485 | -122.46487688 | - | - | 1710539427000 | MTA | SPEED HUMPS | CABRILLO ST to FULTON ST (700 - 799) | - | 40FT. SOUTH OF CABRILLO ST(AT PAINT MARK | - | - | - | - | - | 120929 | 1491826200000 | -122.46487688 | 37.77440485 | - | 1491782400000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1490875680000 | 07TH AVE | 700 - 799 7TH AVE | 700 - 799 07TH AVE | 700 7TH AVE | - | FULTON ST | FULTON ST |
| 103635 | N/A | Point | 1 | 1 | 100 - 199 | - | S231577 | 100-199 EDINBURG ST | 100-199 EDINBURGH ST | F | F | - | F | 5086000 | 5086000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | PERU AVE | PERU AVE | 67821 | 67821 | 37.72667915 | -122.4278922 | - | - | 1710539427000 | MTA | SPEED HUMPS | PERU AVE to AVALON AVE (100 - 199) | - | IFO#191 | - | - | - | - | - | 120930 | 1482317160000 | -122.4278922 | 37.72667915 | - | 1482278400000 | - | D11 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1481103600000 | EDINBURGH ST | 100 - 199 EDINBURGH ST | 100 - 199 EDINBURGH ST | 100 EDINBURGH ST | - | AVALON AVE | AVALON AVE |
| 103636 | N/A | Point | - | - | - | - | S226730 | 12TH AVE: CABRILLO ST | - | F | F | - | F | 27267000 | 27267000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 12TH AVE | 65166 | 65166 | 37.77507657 | -122.4702979 | 12TH AVE \ CABRILLO ST | CABRILLO ST \ 12TH AVE | 1719945608000 | middleware_editor | SPEED HUMPS | 12TH AVE intersection | - | - | - | - | - | - | - | 120931 | 1466508900000 | -122.4702979 | 37.77507657 | - | 1466467200000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1466167980000 | CABRILLO ST | - | - | - | - | - | - |
| 103637 | N/A | Point | - | - | - | - | S231087 | 12TH AVE: LAKE ST | - | F | F | - | F | 27613000 | 27613000 | - | - | WEST SIDE | - | - | - | - | LAKE ST | 12TH AVE | 66379 | 66379 | 37.78638724 | -122.4711146 | 12TH AVE \ LAKE ST | LAKE ST \ 12TH AVE | 1725457294000 | middleware_editor | SPEED HUMPS | 12TH AVE intersection | - | @25FT. SOUTH OF LAKE ST. | - | - | - | - | - | 120932 | 1482236280000 | -122.4711146 | 37.78638724 | - | 1482192000000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1479367500000 | LAKE ST | - | - | - | - | - | - |
| 103638 | N/A | Point | 1 | 1 | 500 - 599 | - | S231085 | 500-599 15TH AVE | 500-599 15TH AVE | F | F | - | F | 610000 | 610000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | ANZA ST | ANZA ST | 66320 | 66320 | 37.77772287 | -122.47376553 | - | - | 1731510071000 | middleware_editor | SPEED HUMPS | ANZA ST to BALBOA ST (500 - 599) | - | ABOVE ST.CL SIGN @NPL#505 15TH AVE. | - | - | - | - | - | 120933 | 1482146460000 | -122.47376553 | 37.77772287 | - | 1482105600000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1479366780000 | 15TH AVE | 500 - 599 15TH AVE | 500 - 599 15TH AVE | 500 15TH AVE | - | BALBOA ST | BALBOA ST |
| 103639 | N/A | Point | - | - | - | - | 24572 | - | - | F | F | - | F | 2342000 | - | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | 1696960741000 | malopez | - | - | 24TH AVE | - | 161300 | 161300 | 37.7782175675286 | -122.483655522201 | - | - | 1710539427000 | MTA | TYPE Q DELINEATOR (IPR) | - | - | CNTR ISLAND BEGINNING OF 3300 BLK | - | - | - | - | 1 | 120934 | 1698164274000 | - | - | - | - | - | 01 | - | DELINEATOR 5 | WARNING | TYPE-Q(CA).0001 | 02X24 | SUP2 | DELINEATOR BASE SAFE HIT | IS | - | - | 3300 - 3399 ANZA ST | - | - | - | 25TH AVE | - |
| 103640 | N/A | Point | - | - | - | - | 24943 | - | - | F | F | - | F | 24954000 | - | - | - | EAST SIDE | 1698682980000 | elclark | - | - | COSMO PL | - | 165765 | 165765 | 37.7880679630737 | -122.412384338274 | TRADER VIC ALY \ COSMO PL | - | 1753809178000 | middleware_editor | TRADER VIC ALLEY | - | - | SEC TRADER VIC ALLEY (END) / COSMO PL | - | - | - | - | - | 120935 | - | - | - | - | - | - | 03 | - | PROVISIONAL | MISC | d3-1.2069 | - | SUP1 | BUILDING | IS | - | - | - | - | - | - | - | - |
| 103641 | N/A | Point | - | - | - | - | 22210 | - | - | - | - | - | - | 27519000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1692218519000 | evillan | - | - | 25TH AVE \ CROSSOVER DR | - | 147017 | 147017 | 37.7724872052008 | -122.484077811236 | FULTON ST \ 25TH AVE \ CROSSOVER DR | - | 1745417796000 | middleware_editor | YIELD HERE TO PED (SYM) (LA) | - | - | @ SHARK TEETH / TRANSVERSE DR/ CROSSOVER DR | - | - | - | - | - | 120936 | 1693518480000 | - | - | - | - | - | 01 | - | PEDESTRIAN | REG | R1-5.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | - | - | - | - | - | - | - | - |
| 103642 | N/A | Point | 1 | 1 | 200 - 299 | - | S275753 | 200-299 TARAVAL ST | 200-299 TARAVAL ST | F | F | - | F | 12388000 | 12388000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 12TH AVE | 12TH AVE | 119718 | 119718 | 37.74336001 | -122.46861917 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/ 45 LEFT DN ARROW (COMBO) | 12TH AVE to FUNSTON AVE (200 - 299) | - | OPP.NW CORNOR | - | - | - | - | - | 120937 | 1129593600000 | -122.46861917 | 37.74336001 | - | 1632268800000 | - | D7 | - | SCHOOL | WARNING | SW24-2(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1624614840000 | TARAVAL ST | 200 - 299 TARAVAL ST | 200 - 299 TARAVAL ST | 200 TARAVAL ST | - | FUNSTON AVE | FUNSTON AVE |
| 103643 | N/A | Point | - | - | - | RIGHT ARROW | S235788 | ILLINOIS ST: AMADOR ST | - | T | T | - | F | 54330000 | 54330000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | ILLINOIS ST | AMADOR ST | 70038 | 70038 | 37.74575699 | -122.38606019 | AMADOR ST \ ILLINOIS ST | ILLINOIS ST \ AMADOR ST | 1710539427000 | MTA | CARGO WY | AMADOR ST intersection | - | 151`WEST OF CARGO | - | - | - | - | - | 120938 | 1495122060000 | -122.38606019 | 37.74575699 | - | 1495065600000 | - | 10 | - | STREET NAME | GUIDE | D3-2.0101 | 72X18 | SUP1 | LIGHT POLE | IS | 1493717280000 | ILLINOIS ST | - | - | - | - | - | - |
| 103644 | N/A | Point | - | - | - | LEFT ARROW | S235787 | ILLINOIS ST: AMADOR ST | - | T | T | - | F | 54330000 | 54330000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | ILLINOIS ST | AMADOR ST | 129574 | 129574 | 37.74575699 | -122.38606019 | AMADOR ST \ ILLINOIS ST | ILLINOIS ST \ AMADOR ST | 1710539427000 | MTA | AMADOR | AMADOR ST intersection | - | 150`WEST OF CARGO | - | - | - | - | - | 120939 | 1495121880000 | -122.38606019 | 37.74575699 | - | 1495065600000 | - | 10 | - | STREET NAME | GUIDE | D3-2.0412 | 72X18 | SUP1 | LIGHT POLE | IS | 1493717040000 | ILLINOIS ST | - | - | - | - | - | - |
| 103645 | N/A | Point | - | - | - | - | S105226 | 9TH AVE: CLEMENT ST | - | F | F | - | F | 27291000 | 27291000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | 09TH AVE | 1227 | 1227 | 37.78280225 | -122.4676291 | 9TH AVE \ CLEMENT ST | CLEMENT ST \ 09TH AVE | 1710539427000 | MTA | STOP | 09TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 120940 | 60220800000 | -122.4676291 | 37.78280225 | - | 1173916800000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569140000 | CLEMENT ST | - | - | - | - | - | - |
| 103646 | N/A | Point | - | - | - | - | S119225 | LELAND AVE: CORA ST | - | F | F | - | F | 20355000 | 20355000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LELAND AVE | CORA ST | 13382 | 13382 | 37.71281361 | -122.40833406 | CORA ST \ LELAND AVE | LELAND AVE \ CORA ST | 1722375963000 | middleware_editor | ALL WAY | CORA ST intersection | - | @ PM | - | - | - | - | - | 120941 | 1089849600000 | -122.40833406 | 37.71281361 | - | 1722348000000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373573580000 | LELAND AVE | - | - | - | - | - | - |
| 103647 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S116591 | 1000-1099 YORK ST | 1000-1099 YORK ST | F | F | - | F | 13771000 | 13771000 | - | - | EAST SIDE | - | - | - | - | 22ND ST | 22ND ST | 16360 | 16360 | 37.7552538 | -122.40842101 | - | - | 1710539427000 | MTA | 1 HR PRK 8AM-6PM MON-FRI EXC "W" PERMITS | 22ND ST to 23RD ST (1000 - 1099) | - | SPL #1085 | - | - | - | - | - | 120942 | 1050969600000 | -122.40842101 | 37.7552538 | - | - | - | D9 | - | PARKING:RPP | REG | R32C(CA).0012 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373572740000 | YORK ST | 1000 - 1099 YORK ST | 1000 - 1099 YORK ST | 1000 YORK ST | - | 23RD ST | 23RD ST |
| 103648 | N/A | Point | 1 | 1 | 100 - 199 | - | S267802 | 100-199 LAURA ST | 100-199 LAURA ST | F | F | - | F | 8168000 | 8168000 | - | - | NORTH SIDE | - | - | - | - | HURON AVE | HURON AVE | 103787 | 103787 | 37.71113169 | -122.45190558 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM THUR STCL | HURON AVE to ALEMANY BLVD (100 - 199) | - | EPL 174 | - | - | - | - | - | 120946 | 1598227200000 | -122.45190558 | 37.71113169 | - | 1611532800000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0267 | 18X18 | SUP2 | 2IN IRON POST | IS | 1598974620000 | LAURA ST | 100 - 199 LAURA ST | 100 - 199 LAURA ST | 100 LAURA ST | - | ALEMANY BLVD | ALEMANY BLVD |
| 103649 | N/A | Point | 1 | 1 | 100 - 199 | - | S267803 | 100-199 LAURA ST | 100-199 LAURA ST | F | F | - | F | - | 8168000 | - | - | NORTH SIDE | - | - | - | - | - | HURON AVE | 103788 | 103788 | 37.71113169 | -122.45190558 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM THUR STCL | HURON AVE to ALEMANY BLVD (100 - 199) | - | WPL 136 | - | - | - | - | - | 120947 | 1598227200000 | -122.45190558 | 37.71113169 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0267 | 18X18 | SUP2 | 2IN IRON POST | IS | 1598974860000 | LAURA ST | - | 100 - 199 LAURA ST | 100 LAURA ST | - | - | ALEMANY BLVD |
| 103650 | N/A | Point | - | - | - | - | S220593 | - | - | F | F | - | F | 2177201 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | LAWRENCE AVE | - | 132125 | 132125 | 37.71058004 | -122.45442134 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM THUR STCL | - | - | IFO 3034 | - | - | - | - | - | 120948 | - | - | - | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0241 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 3000 - 3080 ALEMANY BLVD | - | - | - | DE WOLF 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 metersMetadata automatically harvested from the ESRI service during import.