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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64351 | N/A | Point | - | - | - | - | S225145 | LAKE ST: HWY 1 NORTHBOUND \ HW | - | F | F | - | F | 27628000 | 27628000 | - | - | NORTH EAST CORNER | - | - | - | - | HWY 1 NORTHBOUND \ HWY 1 SOUTHBOUND \ PARK PRESIDIO BLVD | HWY 1 SOUTHBOUND \ LAKE ST \ PARK PRESIDIO BLVD | 128918 | 128918 | 37.78631481 | -122.47262579 | LAKE ST \ HWY 1 NORTHBOUND \ HWY 1 SOUTHBOUND \ PARK PRESIDIO BLVD | HWY 1 NORTHBOUND \ HWY 1 SOUTHBOUND \ LAKE ST \ PARK PRESIDIO BLVD | 1722390321000 | middleware_editor | NPRK ANY TIME | HWY 1 SOUTHBOUND \ LAKE ST \ PARK PRESIDIO BLVD intersection | - | - | - | - | - | - | - | 81463 | - | -122.47262579 | 37.78631481 | - | - | - | D1 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP2 | 2IN IRON POST | IS | 1461686580000 | HWY 1 NORTHBOUND | - | - | - | - | - | - |
| 64352 | N/A | Point | - | - | - | - | S129261 | 21ST ST: CAPP ST | - | F | F | - | F | 24084000 | 24084000 | - | - | SOUTH EAST CORNER | - | - | - | - | CAPP ST | 21ST ST | 128919 | 128919 | 37.75710093 | -122.4178119 | 21ST ST \ CAPP ST | CAPP ST \ 21ST ST | 1718224904000 | middleware_editor | 2 HR PRK 9AM-6PM MON-SAT EXC "I" PERMITS | 21ST ST intersection | - | - | - | - | - | - | - | 81464 | 1213660800000 | -122.4178119 | 37.75710093 | - | - | - | D9 | - | PARKING:RPP | REG | R32C(CA).0175 | 18X21 | SUP2 | LIGHT POLE | IS | 1373576700000 | CAPP ST | - | - | - | - | - | - |
| 64353 | N/A | Point | 1 | 1 | 1400 - 1499 | DOWN ARROW | S212738 | 1400-1499 UTAH ST | 1400-1499 UTAH ST | F | F | - | F | 13046000 | 13046000 | - | - | WEST SIDE | - | - | - | - | 25TH ST | 25TH ST | 129155 | 129155 | 37.75133784 | -122.405261044 | - | - | 1710539427000 | MTA | TANP ANY TIME | 25TH ST to END: 1400-1499 BLOCK (1400 - 1499) | - | (DA)SIGN 155FT. SOUTH OF 25TH ST. | - | - | - | - | - | 81465 | 1423755120000 | -122.40518326 | 37.75153401 | - | 1423699200000 | - | D10 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | 2IN IRON POST | IS | 1421839080000 | UTAH ST | 1400 - 1499 UTAH ST | 1400 - 1499 UTAH ST | 1400 UTAH ST | - | END: 1400-1499 BLOCK | END: 1400-1499 BLOCK |
| 64354 | N/A | Point | 1 | 1 | 2100 - 2299 | - | S234105 | 2100-2299 SUNNYDALE AVE | 2100-2299 SUNNYDALE AVE | F | F | - | F | 12268000 | 12268000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SANTOS ST | SANTOS ST | 129422 | 129422 | 37.71325065 | -122.42097728 | - | - | 1710539427000 | MTA | PEDESTRIAN (SYM) | SANTOS ST to SUNNYDALE AVE (2100 - 2299) | - | 0 / AT WEST LINE OF PED CROSSWALK A..... | - | - | - | - | - | 81466 | 1363564800000 | -122.42097728 | 37.71325065 | - | 1489104000000 | - | D10 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1488789780000 | SUNNYDALE AVE | 2100 - 2299 SUNNYDALE AVE | 2100 - 2299 SUNNYDALE AVE | 2100 SUNNYDALE AVE | - | SUNNYDALE AVE | SUNNYDALE AVE |
| 64355 | N/A | Point | 1 | 1 | 400 - 499 | - | S237340 | 400-499 ALABAMA ST | 400-499 ALABAMA ST | F | F | - | F | 2110000 | 2110000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 129425 | 129425 | 37.76355464 | -122.41223334 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM FRI STCL | 17TH ST to MARIPOSA ST (400 - 499) | - | INFO# 445 | - | - | - | - | - | 81467 | 1286323200000 | -122.41223334 | 37.76355464 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0046 | 18X18 | SUP2 | 2IN IRON POST | IS | 1499441700000 | ALABAMA ST | 400 - 499 ALABAMA ST | 400 - 499 ALABAMA ST | 400 ALABAMA ST | - | MARIPOSA ST | MARIPOSA ST |
| 64356 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S237329 | 1200-1299 SAN BRUNO AVE | 1200-1299 SAN BRUNO AVE | F | F | - | F | 11360000 | 11360000 | - | - | EAST SIDE | - | - | - | - | 23RD ST | 23RD ST | 129426 | 129426 | 37.75375861 | -122.40442377 | - | - | 1710539427000 | MTA | NPRK 6AM-7AM MON STCL | 23RD ST to 24TH ST (1200 - 1299) | - | SPL# 1225 | - | - | - | - | - | 81468 | 1405468800000 | -122.40442377 | 37.75375861 | - | 1517875200000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0172 | 18X18 | SUP1 | 2IN IRON POST | IS | 1499422320000 | SAN BRUNO AVE | 1200 - 1299 SAN BRUNO AVE | 1200 - 1299 SAN BRUNO AVE | 1200 SAN BRUNO AVE | - | 24TH ST | 24TH ST |
| 64357 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S235815 | 1200-1299 VALENCIA ST | 1200-1299 VALENCIA ST | F | F | - | F | 13072000 | 13072000 | - | - | EAST SIDE | - | - | - | - | 23RD ST | 23RD ST | 129427 | 129427 | 37.75290337 | -122.42073847 | - | - | 1710539427000 | MTA | DELINEATOR (W) (SAFE HIT) | 23RD ST to 24TH ST (1200 - 1299) | - | 3FT. NORTH OF NPL# 1245(AT PAINT MARK) | - | - | - | - | - | 81469 | 1494583860000 | -122.42073847 | 37.75290337 | - | 1494547200000 | - | D9 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1493737200000 | VALENCIA ST | 1200 - 1299 VALENCIA ST | 1200 - 1299 VALENCIA ST | 1200 VALENCIA ST | - | 24TH ST | 24TH ST |
| 64358 | N/A | Point | - | 1 | 90 - 198 | - | S282107 | 90-198 THE EMBARCADERO | 90-198 THE EMBARCADERO | F | F | - | F | 12553201 | 12553201 | - | - | EAST SIDE, EASTBOUND TRAFFIC | - | - | - | - | MISSION ST | MISSION ST | 129428 | 129428 | 37.79527839 | -122.39389252 | - | - | 1723669045000 | middleware_editor | FG 300 UR DELINEATOR (W) | MISSION ST to WASHINGTON ST (90 - 198) -- EAST -- | - | IN FERRY BUILD X-WALK, 20' S OF N-LINE | - | - | - | - | - | 81470 | 1654646400000 | -122.39389252 | 37.79527839 | - | - | - | D3 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | TURNPIKE BASE | IS | 1649243940000 | THE EMBARCADERO | 90 - 198 THE EMBARCADERO | 90 - 198 THE EMBARCADERO | 90 THE EMBARCADERO | - | WASHINGTON ST | WASHINGTON ST |
| 64359 | N/A | Point | 1 | 1 | 400 - 499 | - | S129242 | 400-499 JERSEY ST | 400-499 JERSEY ST | F | F | - | F | 7513000 | 7513000 | - | - | SOUTH SIDE | - | - | - | - | CASTRO ST | CASTRO ST | 129429 | 129429 | 37.75042774 | -122.43511448 | - | - | 1710539427000 | MTA | 10 MIN PRK 9AM-6PM EXC SUN | CASTRO ST to DIAMOND ST (400 - 499) | - | IFO #451 | - | - | - | - | - | 81471 | 1213228800000 | -122.43511448 | 37.75042774 | - | - | - | D8 | - | PARKING | REG | R32(CA).0046 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373576700000 | JERSEY ST | 400 - 499 JERSEY ST | 400 - 499 JERSEY ST | 400 JERSEY ST | - | DIAMOND ST | DIAMOND ST |
| 64360 | N/A | Point | - | - | - | - | S230305 | BRIDGEVIEW DR: SCOTIA AVE \ TH | - | F | F | - | F | 20614000 | 20614000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BRIDGEVIEW DR \ SCOTIA AVE | BRIDGEVIEW DR \ THORNTON AVE | 129431 | 129431 | 37.7317031 | -122.39942325 | THORNTON AVE \ BRIDGEVIEW DR \ SCOTIA AVE | SCOTIA AVE \ BRIDGEVIEW DR \ THORNTON AVE | 1710539427000 | MTA | STOP | BRIDGEVIEW DR \ THORNTON AVE intersection | - | @SCOTIA AVE | - | - | - | - | - | 81472 | 1478563200000 | -122.39942325 | 37.7317031 | - | 1478563200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1477573020000 | SCOTIA AVE | - | - | - | - | - | - |
| 64361 | N/A | Point | - | - | - | - | S106275 | 34TH AVE: CRESTLAKE DR \ WAWON | - | F | F | - | F | 23342000 | 23342000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CRESTLAKE DR \ WAWONA ST | 34TH AVE \ CRESTLAKE DR | 129432 | 129432 | 37.73729302 | -122.4913349 | 34TH AVE \ CRESTLAKE DR \ WAWONA ST | WAWONA ST \ 34TH AVE \ CRESTLAKE DR | 1733167997000 | middleware_editor | STOP | 34TH AVE \ CRESTLAKE DR intersection | - | 0 / 0 | - | - | - | - | - | 81473 | 132451200000 | -122.4913349 | 37.73729302 | - | 1475539200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569500000 | WAWONA ST | - | - | - | - | - | - |
| 64362 | N/A | Point | - | - | - | - | S106107 | TRINITY ST: SUTTER ST | - | F | F | - | F | 24718000 | 24718000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | TRINITY ST | TRINITY ST | 129433 | 129433 | 37.78999554 | -122.40253268 | SUTTER ST \ TRINITY ST | SUTTER ST \ TRINITY ST | 1733182800000 | middleware_editor | STOP | TRINITY ST intersection | - | 0 / 00 | - | - | - | - | - | 81474 | 123292800000 | -122.40253268 | 37.78999554 | - | 1728052500000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569440000 | SUTTER ST | - | - | - | - | - | - |
| 64363 | N/A | Point | - | - | - | - | S106175 | MADRID ST: BRAZIL AVE | - | F | F | - | F | 21685000 | 21685000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MADRID ST | BRAZIL AVE | 129434 | 129434 | 37.72327544 | -122.431658164 | BRAZIL AVE \ MADRID ST | MADRID ST \ BRAZIL AVE | 1710539427000 | MTA | STOP | BRAZIL AVE intersection | - | 0 / 0 | - | - | - | - | - | 81475 | 127440000000 | -122.43163313 | 37.72316724 | - | 1177027200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | MADRID ST | - | - | - | - | - | - |
| 64364 | N/A | Point | - | - | - | - | S104520 | SPRUCE ST: SACRAMENTO ST | - | F | F | - | F | 26945000 | 26945000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | SPRUCE ST | SACRAMENTO ST | 129435 | 129435 | 37.78734411 | -122.45359285 | SACRAMENTO ST \ SPRUCE ST | SPRUCE ST \ SACRAMENTO ST | 1710539427000 | MTA | STOP | SACRAMENTO ST intersection | - | 10`SOUTH | - | - | - | - | - | 81476 | 5875200000 | -122.45359285 | 37.78734411 | - | - | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568960000 | SPRUCE ST | - | - | - | - | - | - |
| 64365 | N/A | Point | - | - | - | - | S129208 | RACCOON DR: MOUNTAIN SPRING AV | - | F | F | - | F | 32952000 | 32952000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RACCOON DR \ TWIN PEAKS BLVD | RACCOON DR \ TWIN PEAKS BLVD | 129436 | 129436 | 37.75784999 | -122.44818237 | MOUNTAIN SPRING AVE \ RACCOON DR \ TWIN PEAKS BLVD | MOUNTAIN SPRING AVE \ RACCOON DR \ TWIN PEAKS BLVD | 1710539427000 | MTA | CROWN COURT (LA) | RACCOON DR \ TWIN PEAKS BLVD intersection | - | BELOW DEAD END(LA) SIGN | - | - | - | - | - | 81477 | 1212624000000 | -122.44818237 | 37.75784999 | - | 1510099200000 | - | D8 | - | OTHER GUIDE | GUIDE | G-C(SF).0074 | 24X18 | SUP2 | 2IN IRON POST | IS | 1373576700000 | MOUNTAIN SPRING AVE | - | - | - | - | - | - |
| 64366 | N/A | Point | - | - | - | - | S127875 | DETROIT ST: STAPLES AVE | - | F | F | - | F | 22153000 | 22153000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | STAPLES AVE | DETROIT ST | 129437 | 129437 | 37.72909364 | -122.44428427 | DETROIT ST \ STAPLES AVE | STAPLES AVE \ DETROIT ST | 1718312433000 | middleware_editor | ALL WAY | DETROIT ST intersection | - | - | - | - | - | - | - | 81478 | 1185321600000 | -122.44428427 | 37.72909364 | - | 1556236800000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576280000 | STAPLES AVE | - | - | - | - | - | - |
| 64367 | N/A | Point | - | - | - | - | S125562 | LANE ST: MCKINNON AVE | - | F | F | - | F | 20205000 | 20205000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LANE ST | LANE ST | 129438 | 129438 | 37.73482338 | -122.38738174 | MCKINNON AVE \ LANE ST | MCKINNON AVE \ LANE ST | 1736360213000 | middleware_editor | STOP | LANE ST intersection | - | - | - | - | - | - | - | 81479 | 1158105600000 | -122.38738174 | 37.73482338 | - | 1736326200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373575560000 | MCKINNON AVE | - | - | - | - | - | - |
| 64368 | N/A | Point | - | - | - | - | S224663 | PACIFIC AVE: STOCKTON ST | - | F | F | - | F | 25053000 | 25053000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | STOCKTON ST | STOCKTON ST | 130019 | 130019 | 37.7967039 | -122.40843089 | PACIFIC AVE \ STOCKTON ST | PACIFIC AVE \ STOCKTON ST | 1710539427000 | MTA | START CROSSING ONLY ON (PED SYM)SIGNAL/CHINESE SAME MESSAGE | STOCKTON ST intersection | - | ABOVE PED SIGNAL FOR DIAGONAL PED T..... | - | - | - | - | - | 81480 | 1023926400000 | -122.40843089 | 37.7967039 | - | - | - | D3 | - | PEDESTRIAN | REG | R62(SF).0002 | 24X18 | SUP1 | LIGHT POLE | IS | 1460112180000 | PACIFIC AVE | - | - | - | - | - | - |
| 64369 | N/A | Point | - | - | - | - | S224667 | INNES AVE: INGALLS ST \ MIDDLE | - | F | F | - | F | 20175000 | 20175000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | INGALLS ST \ MIDDLE POINT RD | INGALLS ST \ MIDDLE POINT RD | 130020 | 130020 | 37.73408162 | -122.37943074 | INNES AVE \ INGALLS ST \ MIDDLE POINT RD | INNES AVE \ INGALLS ST \ MIDDLE POINT RD | 1741730237000 | middleware_editor | ALL WAY | INGALLS ST \ MIDDLE POINT RD intersection | - | CROSS ST IS INGALLS/MIDDLE POINT RD | - | - | - | - | - | 81481 | - | -122.37943074 | 37.73408162 | - | 1741726800000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1460123280000 | INNES AVE | - | - | - | - | - | - |
| 64370 | N/A | Point | - | - | - | - | S226444 | JACKSON ST: SANSOME ST | - | T | T | - | F | 24712000 | 24712000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JACKSON ST | JACKSON ST | 130021 | 130021 | 37.79662617 | -122.40185339 | SANSOME ST \ JACKSON ST | SANSOME ST \ JACKSON ST | 1727210516000 | middleware_editor | EXC TRUCKS BUSES TAXI (SYM) | JACKSON ST intersection | - | - | - | - | - | - | - | 81482 | - | -122.40185339 | 37.79662617 | - | - | - | D3 | - | OTHER REGULATORY | REG | R(SF).0354 | 30X30 | SUP1 | LIGHT POLE | IS | 1465480440000 | SANSOME ST | - | - | - | - | - | - |
| 64371 | N/A | Point | - | - | - | - | S227585 | CHESTER AVE: RANDOLPH ST | - | F | F | - | F | 22546000 | 22546000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CHESTER AVE | CHESTER AVE | 130024 | 130024 | 37.71427724 | -122.47046372 | RANDOLPH ST \ CHESTER AVE | RANDOLPH ST \ CHESTER AVE | 1710539427000 | MTA | STOP | CHESTER AVE intersection | - | - | - | - | - | - | - | 81483 | 1470236580000 | -122.47046372 | 37.71427724 | - | 1470182400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1469781420000 | RANDOLPH ST | - | - | - | - | - | - |
| 64372 | N/A | Point | - | - | - | - | S226344 | OCEAN AVE: LAKEWOOD AVE | - | F | F | - | F | 22743000 | 22743000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | OCEAN AVE | OCEAN AVE | 130025 | 130025 | 37.72613179 | -122.46457258 | LAKEWOOD AVE \ OCEAN AVE | LAKEWOOD AVE \ OCEAN AVE | 1727141642000 | middleware_editor | SPEED LIMIT 10 WHEN BUS OR STREETCAR STOPPED AT SAFETY ZONE | OCEAN AVE intersection | - | 45`WEST (WEST TIP OF ISLAND) | - | - | - | - | - | 81484 | - | -122.46457258 | 37.72613179 | - | - | - | D7 | - | OTHER REGULATORY | REG | R(SF).0245 | 24X36 | SUP2 | 2IN IRON POST | IS | 1465376940000 | LAKEWOOD AVE | - | - | - | - | - | - |
| 64373 | N/A | Point | - | - | - | - | S225757 | MINNESOTA ST: 20TH ST | - | F | F | - | F | 23644000 | 23644000 | - | - | SOUTH WEST CORNER | - | - | - | - | 20TH ST | 20TH ST | 130026 | 130026 | 37.76042435 | -122.39045425 | MINNESOTA ST \ 20TH ST | MINNESOTA ST \ 20TH ST | 1720534091000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "X" PERMITS | 20TH ST intersection | - | - | - | - | - | - | - | 81485 | 1464001980000 | -122.39045425 | 37.76042435 | - | 1463961600000 | - | D10 | - | PARKING:RPP | REG | R32C(CA).0106 | 18X21 | SUP1 | LIGHT POLE | IS | 1463574780000 | MINNESOTA ST | - | - | - | - | - | - |
| 64374 | N/A | Point | - | - | - | - | S226471 | SANSOME ST: BROADWAY | - | F | F | - | F | 3146000 | 30039000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SANSOME ST | BROADWAY | 130027 | 130027 | 37.7984297 | -122.40222864 | - | SANSOME ST \ BROADWAY | 1727208883000 | middleware_editor | NO RIGHT TURN (SYM) 7AM-8PM EVERYDAY | BROADWAY intersection | - | 45' WEST OF SANSOME | - | - | - | - | - | 81486 | - | -122.40222864 | 37.7984297 | - | - | 1727183640000 | D3 | - | NO RIGHT TURN | REG | R33(SF).0011 | 30X42 | SUP1 | LIGHT POLE | RETD | 1465553700000 | SANSOME ST | 300 - 351 BROADWAY | - | - | - | OSGOOD PL | - |
| 64375 | N/A | Point | - | - | - | - | S224469 | TAYLOR ST: CALIFORNIA ST | - | F | F | - | F | 25088000 | 25088000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | TAYLOR ST | 130028 | 130028 | 37.79162708 | -122.41246088 | TAYLOR ST \ CALIFORNIA ST | CALIFORNIA ST \ TAYLOR ST | 1710539427000 | MTA | RIGHT LANE MUST TURN RIGHT | TAYLOR ST intersection | - | - | - | - | - | - | - | 81487 | - | -122.41246088 | 37.79162708 | - | - | - | D3 | - | OTHER REGULATORY | REG | R3-7.0005 | 30X30 | SUP1 | 2IN IRON POST | IS | 1459328100000 | CALIFORNIA ST | - | - | - | - | - | - |
| 64376 | N/A | Point | 1 | 1 | 1652 - 1699 | - | S272011 | 1652-1699 16TH AVE | 1652-1699 16TH AVE | F | F | - | F | 683000 | 683000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | LOMITA AVE | LOMITA AVE | 130030 | 130030 | 37.75654217 | -122.47356859 | - | - | 1752255758000 | middleware_editor | AHEAD | LOMITA AVE to MORAGA ST (1652 - 1699) | - | SPL 1678 | - | - | - | - | - | 81488 | 1224226800000 | -122.47356859 | 37.75654217 | - | - | - | D7 | - | OTHER WARNING | WARNING | W(SF).0106 | 18X06 | SUP2 | 2IN IRON POST | IS | 1611917820000 | 16TH AVE | 1652 - 1699 16TH AVE | 1652 - 1699 16TH AVE | 1652 16TH AVE | - | MORAGA ST | MORAGA ST |
| 64377 | N/A | Point | 1 | 1 | 1 - 200 | - | S283606 | 1-200 ROBINHOOD DR | 1-200 ROBINHOOD DR | F | F | - | F | 11097000 | 11097000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | LANSDALE AVE | LANSDALE AVE | 130032 | 130032 | 37.7368829 | -122.45707315 | - | - | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | LANSDALE AVE to LANSDALE AVE (1 - 200) | - | EPL 90 | - | - | - | - | - | 81489 | 1657238400000 | -122.45707315 | 37.7368829 | - | - | - | D7 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | LIGHT POLE | IS | 1655894280000 | ROBINHOOD DR | 1 - 200 ROBINHOOD DR | 1 - 200 ROBINHOOD DR | 1 ROBINHOOD DR | - | LANSDALE AVE | LANSDALE AVE |
| 64378 | N/A | Point | - | - | - | - | S127476 | 18TH AVE: TARAVAL ST | - | F | F | - | F | 23182000 | 23182000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 18TH AVE | 130084 | 130084 | 37.74309662 | -122.47462383 | 18TH AVE \ TARAVAL ST | TARAVAL ST \ 18TH AVE | 1721944678000 | middleware_editor | ALL WAY | 18TH AVE intersection | - | - | - | - | - | - | - | 81490 | 1177545600000 | -122.47462383 | 37.74309662 | - | - | 1721902920000 | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | RETD | 1373576160000 | TARAVAL ST | - | - | - | - | - | - |
| 64379 | N/A | Point | - | - | - | - | S126556 | CESAR CHAVEZ ST: SANCHEZ ST | - | F | F | - | F | 21921000 | 21921000 | - | - | NORTH WEST CORNER | - | - | - | - | CESAR CHAVEZ ST | CESAR CHAVEZ ST | 130085 | 130085 | 37.74756447 | -122.42927003 | SANCHEZ ST \ CESAR CHAVEZ ST | SANCHEZ ST \ CESAR CHAVEZ ST | 1754919435000 | middleware_editor | NPRK 9AM-11AM TUE STCL | CESAR CHAVEZ ST intersection | - | 5FT.WEST OF SANCHEZ | - | - | - | - | - | 81491 | 1169539200000 | -122.42927003 | 37.74756447 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0308 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373575860000 | SANCHEZ ST | - | - | - | - | - | - |
| 64380 | N/A | Point | - | - | - | - | S207983 | - | - | F | F | - | F | 8775000 | - | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131904 | 131904 | 37.75803459 | -122.44345273 | - | - | 1710539427000 | MTA | DELINEATOR (Y) (SAFE HIT) | - | - | TIP OF ISLAND IN RIGHT TURN LANE | - | - | - | - | - | 81492 | 1428586620000 | - | - | - | 1428537600000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0002 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | - | - | 3335 - 3399 MARKET ST | - | - | - | - | - |
| 64381 | N/A | Point | - | - | - | - | S201131 | - | - | F | F | - | F | 6128000 | - | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131905 | 131905 | 37.72188461 | -122.44972686 | - | - | 1710539427000 | MTA | SCHOOL (SYM) | - | - | W-LINE | - | - | - | - | - | 81493 | - | - | - | - | - | - | D11 | - | SCHOOL | WARNING | S1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | - | - | 100 - 198 GENEVA AVE | - | - | - | - | - |
| 64382 | N/A | Point | - | - | - | - | S205661 | - | - | F | F | - | F | 2481000 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | - | - | 131906 | 131906 | 37.7483972 | -122.4083015 | - | - | 1715290753000 | middleware_editor | NPRK 9AM-11AM TUE THUR STCL | - | - | INFO #2924 | - | - | - | - | - | 81494 | 1400511000000 | - | - | - | 1400457600000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0309 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 2900 - 2952 CESAR CHAVEZ ST | - | - | - | - | - |
| 64383 | N/A | Point | - | - | - | - | S205977 | - | - | F | F | - | F | 2486000 | - | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131907 | 131907 | 37.74827878 | -122.41429738 | - | - | 1710539427000 | MTA | FOLSOM ST | - | - | OPP C-LINE OF TREAT ST OPP #3145 | - | - | - | - | - | 81495 | 1403740800000 | - | - | - | 1403740800000 | - | D9 | - | STREET NAME | GUIDE | D3-2.0156 | 72X18 | SUP2 | LIGHT POLE | IS | - | - | 3200 - 3224 CESAR CHAVEZ ST | - | - | - | - | - |
| 64384 | N/A | Point | - | - | - | - | S204509 | - | - | F | F | - | F | 548000 | - | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131908 | 131908 | 37.76945025 | -122.41215854 | - | - | 1731625551000 | middleware_editor | LEFT TURN YIELD ON GREEN (SYM) | - | - | CROSS ST IS HARRISON | - | - | - | - | - | 81496 | 1396879140000 | - | - | - | 1396828800000 | - | D6 | - | OTHER REGULATORY | REG | R10-12.0001 | 30X36 | SUP1 | FREEWAY COLUMN | IS | - | - | 1 - 21 13TH ST | - | - | - | - | - |
| 64385 | N/A | Point | - | - | - | - | S206856 | - | - | F | F | - | F | 2486000 | - | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131909 | 131909 | 37.74827878 | -122.41429738 | - | - | 1710539427000 | MTA | FOLSOM ST | - | - | 100FT.WEST OF FOLSOM ST | - | - | - | - | - | 81497 | 1403654400000 | - | - | - | 1403654400000 | - | D9 | - | STREET NAME | GUIDE | D3-2.0156 | 72X18 | SUP2 | LIGHT POLE | IS | - | - | 3200 - 3224 CESAR CHAVEZ ST | - | - | - | - | - |
| 64386 | N/A | Point | - | - | - | - | S247755 | - | - | F | F | - | F | 155270050 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 131910 | 131910 | 37.72597244 | -122.3952049 | - | - | 1748540244000 | middleware_editor | NPRK 2AM-6AM WED STCL | - | - | 635' W OF 3RD ST (NEXT TO CAL TRAIN) | - | - | - | - | - | 81498 | 1536699120000 | - | - | - | - | 1748540220000 | D10 | - | STREET CLEANING | REG | R30B(CA).0135 | 18X18 | SUP1 | LIGHT POLE | RETD | - | - | 1700 - 1799 CARROLL AVE | - | - | - | - | - |
| 64387 | N/A | Point | - | - | - | - | S275385 | - | - | F | F | - | F | 11962201 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | 43RD AVE | - | 131911 | 131911 | 37.7355437779923 | -122.501803099968 | - | - | 1738356285000 | middleware_editor | NPRK 7AM-8AM MON STCL | - | - | WPL 2556 | - | - | - | - | - | 81499 | 1625657160000 | - | - | - | 1625616000000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0211 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 2500 - 2598 SLOAT BLVD | - | - | - | 44TH AVE | - |
| 64388 | N/A | Point | - | - | - | - | S277036 | - | - | T | T | - | F | 5716000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131912 | 131912 | 37.7145967 | -122.47237555 | - | - | 1721754192000 | middleware_editor | SPEED LIMIT 25 | - | - | 80 FEET WEST OF JUNIPERO SERRA | - | - | - | - | - | 81500 | 1225065600000 | - | - | - | 1628726400000 | - | D7 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP2 | LIGHT POLE | IS | - | - | 1 - 99 FONT BLVD | - | - | - | - | - |
| 64389 | N/A | Point | - | - | - | - | S262744 | - | - | F | F | - | F | 8665000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131913 | 131913 | 37.72130816 | -122.40153107 | - | - | 1716427557000 | middleware_editor | BIKE WAYFINDING SIGN | - | 1472 | 15' E OF GIRARD | - | - | - | - | - | 81501 | 1591192080000 | - | - | - | - | - | D10 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | LIGHT POLE | IS | - | - | 1 - 99 MANSELL ST | - | - | - | - | - |
| 64390 | N/A | Point | - | - | - | - | S260689 | - | - | F | F | - | F | 8749000 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | - | - | 131914 | 131914 | 37.78273169 | -122.40958718 | - | - | 1756154884000 | middleware_editor | TA (SYM) PARATRANSIT & TAXI LOADING AT ALL TIMES | - | - | IFO# 980 | - | - | - | - | - | 81502 | 1580512080000 | - | - | - | 1644566400000 | 1756154700000 | D6 | - | OTHER REGULATORY | REG | R38(SF)5.0005 | 14X21 | SUP1 | 2IN IRON POST | RETD | - | - | 943 - 999 MARKET ST | - | - | - | - | - |
| 64391 | N/A | Point | - | - | - | - | S207672 | - | - | F | F | - | F | 9173000 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 131915 | 131915 | 37.71967616 | -122.43862356 | - | - | 1735942288000 | middleware_editor | NPRK 5AM-7AM EVERYDAY INCL HOLIDAY STCL | - | - | OPP.SE CORNOR | - | - | - | - | - | 81503 | - | - | - | - | 1735812300000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0154 | 18X18 | SUP2 | MUNI POLE | IS | - | - | 4900 - 4950 MISSION ST | - | - | - | - | - |
| 64392 | N/A | Point | - | - | - | - | S209562 | - | - | F | F | - | F | 9282000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131916 | 131916 | 37.73130444 | -122.45619612 | - | - | 1720817793000 | middleware_editor | YIELD HERE TO PED (SYM) (LA) | - | - | 25`EAST ( SEE PAINT) | - | - | - | - | - | 81504 | 1224806400000 | - | - | - | 1417392000000 | - | D7 | - | PEDESTRIAN | REG | R1-5.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | - | - | 900 - 928 MONTEREY BLVD | - | - | - | - | - |
| 64393 | N/A | Point | - | - | - | - | S202980 | - | - | F | F | - | F | 8775000 | - | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131917 | 131917 | 37.75803459 | -122.44345273 | - | - | 1710539427000 | MTA | LEFT TURN (SYM) ON GREEN ARROW ONLY | - | - | NORTH-LINE | - | - | - | - | - | 81505 | - | - | - | - | - | - | D8 | - | OTHER REGULATORY | REG | R(SF).0113 | 30X36 | SUP2 | SIGNAL POLE | IS | - | - | 3335 - 3399 MARKET ST | - | - | - | - | - |
| 64394 | N/A | Point | - | - | - | - | S123780 | - | - | F | F | - | F | 155270006 | - | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131918 | 131918 | 37.73440355 | -122.48391354 | - | - | 1710539427000 | MTA | STATE LAW YIELD TO PEDS (SYM) | - | - | W-LINE | - | - | - | - | - | 81506 | 1147910400000 | - | - | - | - | - | D7 | - | OTHER REGULATORY | REG | R1-6.0001 | 12X36 | SUP2 | UNKNOWN | IS | - | - | 1150 - 1198 SLOAT BLVD | - | - | - | - | - |
| 64395 | N/A | Point | - | - | - | - | S263264 | - | - | F | F | - | F | 9810000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131919 | 131919 | 37.72338829 | -122.44044794 | - | - | 1714786494000 | middleware_editor | SCHOOL (SYM) AHEAD | - | 096030 | WPL #180 | - | - | - | - | - | 81507 | 1086912000000 | - | - | - | 1570406400000 | - | D11 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | - | - | 145 - 199 OCEAN AVE | - | - | - | - | - |
| 64396 | N/A | Point | - | - | - | - | S132352 | - | - | F | F | - | F | 928000 | - | - | - | EAST SIDE | 1689201376000 | MTA | - | - | - | - | 131920 | 131920 | 37.72335661 | -122.47523299 | - | - | 1710539427000 | MTA | TANSAT | - | - | 100`SOUTH | - | - | - | - | - | 81508 | 1273795200000 | - | - | - | - | - | D7 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | 2IN IRON POST | IS | - | - | 3501 - 3699 19TH AVE | - | - | - | - | - |
| 64397 | N/A | Point | - | - | - | - | S145182 | - | - | F | F | - | F | 13124000 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 131921 | 131921 | 37.73662453 | -122.44464906 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM 2ND & 4TH THUR OF MONTH STCL | - | - | 3 VALLETTA | - | - | - | - | - | 81509 | 1222819200000 | - | - | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0073 | 18X18 | SUP2 | LIGHT POLE | IS | - | - | 1 - 99 VALLETTA CT | - | - | - | - | - |
| 64398 | N/A | Point | - | - | - | RIGHT ARROW | S281622 | - | - | F | F | - | F | 2175000 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 131922 | 131922 | 37.71300192 | -122.45047758 | - | - | 1727312900000 | middleware_editor | 4 HR PRK 8AM-6PM EVERYDAY | - | - | NPL 2800 NEXT TO WALKWAY | - | - | - | - | - | 81510 | 1648684800000 | - | - | - | - | - | D11 | - | PARKING | REG | R32(CA).0126 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 2701 - 2899 ALEMANY BLVD | - | - | - | - | - |
| 64399 | N/A | Point | - | - | - | - | S212018 | - | - | F | F | - | F | 10669000 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 131923 | 131923 | 37.75536319 | -122.40661026 | - | - | 1745965529000 | middleware_editor | NPRK 8AM-10AM MON WED FRI STCL | - | - | INFO #1078 | - | - | - | - | - | 81511 | - | - | - | - | - | 1745873160000 | D9 | - | STREET CLEANING | REG | R30B(CA).0265 | 18X18 | SUP2 | MUNI POLE | RETD | - | - | 1000 - 1098 POTRERO AVE | - | - | - | - | - |
| 64400 | N/A | Point | - | - | - | - | S218590 | - | - | F | F | - | F | 549030 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | - | - | 131924 | 131924 | 37.76957448 | -122.41519907 | - | - | 1710539427000 | MTA | S F BIKE ROUTE (RED SYM) 30 | - | - | 30' WEST OF ISIS | - | - | - | - | - | 81512 | - | - | - | - | - | - | D6 | - | BIKE GUIDE | GUIDE | SG45R(30).0003 | 12X22 | SUP1 | 2IN IRON POST | IS | - | - | 70 - 98 13TH ST | - | - | - | - | - |
| 64401 | N/A | Point | - | - | - | - | S215319 | - | - | F | F | - | F | 2480000 | - | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131925 | 131925 | 37.7485344 | -122.40729584 | - | - | 1756146210000 | middleware_editor | SPEED LIMIT 25 | - | - | OPP 2869 | - | - | - | - | - | 81513 | 1442944560000 | - | - | - | 1442905200000 | - | D9 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP2 | LIGHT POLE | IS | - | - | 2853 - 2899 CESAR CHAVEZ ST | - | - | - | - | - |
| 64402 | N/A | Point | - | - | - | - | S256755 | - | - | F | F | - | F | 6997000 | - | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131926 | 131926 | 37.72088915 | -122.47828066 | - | - | 1747244946000 | middleware_editor | (45 RA-DN) | - | - | E-LINE | - | - | - | - | - | 81514 | 1076572800000 | - | - | - | 1578038400000 | - | D7 | - | OTHER WARNING | WARNING | W16-7P.0006 | 24X12 | SUP2 | 2IN IRON POST | IS | - | - | 1600 - 1720 HOLLOWAY AVE | - | - | - | - | - |
| 64403 | N/A | Point | - | - | - | - | S135437 | - | - | F | F | - | F | 155270024 | - | - | - | EAST SIDE | 1689201376000 | MTA | - | - | - | - | 131929 | 131929 | 37.78497733 | -122.42129758 | - | - | 1710539427000 | MTA | BIKE RACK | - | - | 10S / OF MYRTLE/ BIKE RACKS LIST# 2..... | - | - | - | - | - | 81515 | 1322611200000 | - | - | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BARRICADE | IS | - | - | 1001 - 1013 VAN NESS AVE | - | - | - | - | - |
| 64404 | N/A | Point | 1 | 1 | 300 - 399 | - | S270733 | 300-399 JUDSON AVE | 300-399 JUDSON AVE | T | T | - | F | 7689000 | 7689000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | FOERSTER ST | FOERSTER ST | 108792 | 108792 | 37.72836325 | -122.4499786 | - | - | 1719883012000 | middleware_editor | SPEED HUMPS AHEAD | FOERSTER ST to GENNESSEE ST (300 - 399) | - | OPP NEC. | - | - | - | - | - | 81516 | 1519689600000 | -122.4499786 | 37.72836325 | - | 1618358400000 | - | D7 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1607598540000 | JUDSON AVE | 300 - 399 JUDSON AVE | 300 - 399 JUDSON AVE | 300 JUDSON AVE | - | GENNESSEE ST | GENNESSEE ST |
| 64405 | N/A | Point | - | - | - | - | S267241 | GOUGH ST: SACRAMENTO ST | - | F | F | - | F | 26542000 | 26542000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | GOUGH ST | 108821 | 108821 | 37.79087443 | -122.42580214 | GOUGH ST \ SACRAMENTO ST | SACRAMENTO ST \ GOUGH ST | 1749077433000 | middleware_editor | TREE TOP 6FT SPEED BUMP | GOUGH ST intersection | - | 2 TREE TOP INSIDE CHEVRON PAINT | - | - | - | - | - | 81517 | 1598391660000 | -122.42580214 | 37.79087443 | - | 1749067740000 | - | D2 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1597764720000 | SACRAMENTO ST | - | - | - | - | - | - |
| 64406 | N/A | Point | - | - | - | - | S107300 | BRAZIL AVE: MUNICH ST | - | F | F | - | F | 21618000 | 21618000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | BRAZIL AVE | 108879 | 108879 | 37.720886307 | -122.42670561 | MUNICH ST \ BRAZIL AVE | MUNICH ST \ BRAZIL AVE | 1750714129000 | middleware_editor | STOP | BRAZIL AVE intersection | - | 0 / 0 | - | - | - | - | - | 81518 | 215679600000 | -122.42683078 | 37.72086792 | - | 1750700400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569800000 | MUNICH ST | - | - | - | - | - | - |
| 64407 | N/A | Point | 1 | 1 | 2600 - 2699 | - | S278897 | 2600-2699 20TH AVE | 2600-2699 20TH AVE | F | F | - | F | 1019000 | 1019000 | - | - | EAST SIDE | - | - | - | - | VICENTE ST | VICENTE ST | 108889 | 108889 | 37.73834235 | -122.47642712 | - | - | 1710539427000 | MTA | SPEED HUMP | VICENTE ST to WAWONA ST (2600 - 2699) | - | 0PP TO NPL 2671 | - | - | - | - | - | 81519 | 1228780800000 | -122.47642712 | 37.73834235 | - | - | - | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | UTILITY POLE | IS | 1637148840000 | 20TH AVE | 2600 - 2699 20TH AVE | 2600 - 2699 20TH AVE | 2600 20TH AVE | - | WAWONA ST | WAWONA ST |
| 64408 | N/A | Point | 1 | 1 | 700 - 799 | - | S279163 | 700-799 HAMPSHIRE ST | 700-799 HAMPSHIRE ST | F | F | - | F | 6652000 | 6652000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 108901 | 108901 | 37.75995312 | -122.40800207 | - | - | 1710539427000 | MTA | SPEED HUMP | 19TH ST to 20TH ST (700 - 799) | - | IFO #793 | - | - | - | - | - | 81520 | 1641340800000 | -122.40800207 | 37.75995312 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1638199200000 | HAMPSHIRE ST | 700 - 799 HAMPSHIRE ST | 700 - 799 HAMPSHIRE ST | 700 HAMPSHIRE ST | - | 20TH ST | 20TH ST |
| 64409 | N/A | Point | - | - | - | - | S279164 | HAMPSHIRE ST: 19TH ST | - | F | F | - | F | 24005000 | 24005000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HAMPSHIRE ST | 19TH ST | 108902 | 108902 | 37.76060107 | -122.40806412 | 19TH ST \ HAMPSHIRE ST | HAMPSHIRE ST \ 19TH ST | 1710539427000 | MTA | SPEED HUMP | 19TH ST intersection | - | - | - | - | - | - | - | 81521 | 1641772800000 | -122.40806412 | 37.76060107 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 3IN IRON POST | IS | 1638199320000 | HAMPSHIRE ST | - | - | - | - | - | - |
| 64410 | N/A | Point | - | - | - | - | S115963 | MADRID ST: BRAZIL AVE | - | F | F | - | F | 21685000 | 21685000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MADRID ST | BRAZIL AVE | 108912 | 108912 | 37.723272611 | -122.431653694 | BRAZIL AVE \ MADRID ST | MADRID ST \ BRAZIL AVE | 1710539427000 | MTA | ALL WAY | BRAZIL AVE intersection | - | - | - | - | - | - | - | 81522 | 1043798400000 | -122.43163313 | 37.72316724 | - | 1685664000000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1373572500000 | MADRID ST | - | - | - | - | - | - |
| 64411 | N/A | Point | 1 | 1 | 4600 - 4613 | - | S277298 | 4600-4613 19TH ST | 4600-4613 19TH ST | F | F | - | F | 991000 | 991000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | SEWARD ST | SEWARD ST | 109048 | 109048 | 37.75901721 | -122.44091592 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | SEWARD ST to CLOVER LN (4600 - 4613) | - | EPL #4600 ABOVE ONE WAY SIGN | - | - | - | - | - | 81523 | 1017792000000 | -122.44091592 | 37.75901721 | - | 1631491200000 | - | D8 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1630490400000 | 19TH ST | 4600 - 4613 19TH ST | 4600 - 4613 19TH ST | 4600 19TH ST | - | CLOVER LN | CLOVER LN |
| 64412 | N/A | Point | 1 | 1 | 500 - 599 | - | S275361 | 500-599 VALENCIA ST | 500-599 VALENCIA ST | F | F | - | F | 13060000 | 13060000 | - | - | WEST SIDE | - | - | - | - | 16TH ST | 16TH ST | 109084 | 109084 | 37.763448429 | -122.421842955 | - | - | 1710539427000 | MTA | BIKE RACK | 16TH ST to 17TH ST (500 - 599) | - | IFO 594 | - | - | - | - | - | 81524 | 1505260800000 | -122.42180898 | 37.76410858 | - | 1505260800000 | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1623161880000 | VALENCIA ST | 500 - 599 VALENCIA ST | 500 - 599 VALENCIA ST | 500 VALENCIA ST | - | 17TH ST | 17TH ST |
| 64413 | N/A | Point | - | - | - | - | S100040 | GOETHE ST: SAN JOSE AVE | - | F | F | - | F | 22464000 | 22464000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GOETHE ST | GOETHE ST | 109107 | 109107 | 37.70839276 | -122.458659857 | SAN JOSE AVE \ GOETHE ST | SAN JOSE AVE \ GOETHE ST | 1710539427000 | MTA | STOP | GOETHE ST intersection | - | - | - | - | - | - | - | 81525 | -406944000000 | -122.45882474 | 37.70844468 | - | 1525305600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373566320000 | SAN JOSE AVE | - | - | - | - | - | - |
| 64414 | N/A | Point | - | - | - | - | S110073 | ALEMANY BLVD: NIAGARA AVE | - | F | F | - | F | 21487000 | 21487000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | ALEMANY BLVD | 109129 | 109129 | 37.716843623 | -122.443375838 | NIAGARA AVE \ ALEMANY BLVD | NIAGARA AVE \ ALEMANY BLVD | 1710539427000 | MTA | ONE WAY (RA) | ALEMANY BLVD intersection | - | BACK TO BACK WITH R16 NO RIGHT TURN SIGN | - | - | - | - | - | 81526 | 588297600000 | -122.44343127 | 37.71697022 | - | 1570492800000 | - | D11 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | SIGNAL POLE | IS | 1373570700000 | NIAGARA AVE | - | - | - | - | - | - |
| 64415 | N/A | Point | 1 | 1 | 13 - 97 | - | S256568 | 13-97 LISBON ST | 13-97 LISBON ST | F | F | - | F | 8404000 | 8404000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | PERU AVE | PERU AVE | 109148 | 109148 | 37.72744249 | -122.42949128 | - | - | 1715304648000 | middleware_editor | SPEED HUMPS | PERU AVE to AVALON AVE (13 - 97) | - | NPL#95 | - | - | - | - | - | 81527 | 1182297600000 | -122.42949128 | 37.72744249 | - | 1564617600000 | - | D11 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1564485360000 | LISBON ST | 13 - 97 LISBON ST | 13 - 97 LISBON ST | 13 LISBON ST | - | AVALON AVE | AVALON AVE |
| 64416 | N/A | Point | - | 1 | 500 - 599 | DOWN ARROW | S257309 | 500-599 TERRY A FRANCOIS BLVD | 500-599 TERRY A FRANCOIS BLVD | F | F | - | F | 12532004 | 12532004 | - | - | EAST SIDE | - | - | - | - | MISSION BAY BLVD | MISSION BAY BLVD | 109153 | 109153 | 37.770225652 | -122.386630622 | - | - | 1744387177000 | middleware_editor | PIER52 BOAT LAUNCH..ETC...ETC | MISSION BAY BLVD to WARRIORS WAY (500 - 599) | - | PIER 52 LOT, BETWEEN SPACES #61 & 62 BOT | - | - | - | - | - | 81528 | - | -122.38637313 | 37.76992034 | - | - | - | D6 | - | OTHER REGULATORY | REG | R(SF).0536 | 30X42 | SUP1 | LIGHT POLE | IS | 1566554520000 | TERRY A FRANCOIS BLVD | 500 - 599 TERRY A FRANCOIS BLVD | 500 - 599 TERRY A FRANCOIS BLVD | 500 TERRY A FRANCOIS BLVD | - | WARRIORS WAY | WARRIORS WAY |
| 64417 | N/A | Point | - | - | - | - | S105035 | STEVENSON ST: 7TH ST | - | F | F | - | F | 24319000 | 24319000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ODD FELLOWS WAY \ STEVENSON ST | 07TH ST \ STEVENSON ST | 109170 | 109170 | 37.78000587 | -122.41193341 | 07TH ST \ ODD FELLOWS WAY \ STEVENSON ST | ODD FELLOWS WAY \ 07TH ST \ STEVENSON ST | 1710539427000 | MTA | STOP | 07TH ST \ STEVENSON ST intersection | - | - | - | - | - | - | - | 81529 | 42422400000 | -122.41193341 | 37.78000587 | - | 1708683300000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569080000 | ODD FELLOWS WAY | - | - | - | - | - | - |
| 64418 | N/A | Point | - | - | - | - | S274062 | EUREKA ST: 21ST ST | - | F | F | - | F | 25776000 | 25776000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 21ST ST | EUREKA ST | 109299 | 109299 | 37.75554069 | -122.43776923 | EUREKA ST \ 21ST ST | 21ST ST \ EUREKA ST | 1723760327000 | middleware_editor | SPEED HUMPS AHEAD | EUREKA ST intersection | - | SPL 395 | - | - | - | - | - | 81530 | 1595376000000 | -122.43776923 | 37.75554069 | - | 1621468800000 | - | D8 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1618824840000 | 21ST ST | - | - | - | - | - | - |
| 64419 | N/A | Point | - | - | - | - | S274063 | EUREKA ST: 20TH ST | - | F | F | - | F | 25781000 | 25781000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 20TH ST | EUREKA ST | 109300 | 109300 | 37.75749072 | -122.43795912 | EUREKA ST \ 20TH ST | 20TH ST \ EUREKA ST | 1710539427000 | MTA | SPEED HUMPS AHEAD | EUREKA ST intersection | - | - | - | - | - | - | - | 81531 | 1595376000000 | -122.43795912 | 37.75749072 | - | 1621900800000 | - | D8 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1618825080000 | 20TH ST | - | - | - | - | - | - |
| 64420 | N/A | Point | - | - | - | - | S261303 | CESAR CHAVEZ ST: BAY SHORE BLV | - | F | F | - | F | 33283000 | 33283000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CESAR CHAVEZ ST | CESAR CHAVEZ ST | 110492 | 110492 | 37.74897105 | -122.40562695 | BAY SHORE BLVD \ CESAR CHAVEZ ST | BAY SHORE BLVD \ CESAR CHAVEZ ST | 1710539427000 | MTA | DO NOT ENTER | CESAR CHAVEZ ST intersection | - | WEST END OF BIKE BRIDGE | - | - | - | - | - | 81532 | 1590746400000 | -122.40562695 | 37.74897105 | - | - | - | D9 | - | OTHER REGULATORY | REG | R5-1.0004 | 12X12 | SUP2 | 2IN IRON POST | IS | 1581344340000 | BAY SHORE BLVD | - | - | - | - | - | - |
| 64421 | N/A | Point | - | - | - | - | S261047 | DOLORES ST: 29TH ST | - | F | F | - | F | 21893000 | 21893000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 29TH ST | DOLORES ST | 110568 | 110568 | 37.74383822 | -122.42438486 | DOLORES ST \ 29TH ST | 29TH ST \ DOLORES ST | 1745940561000 | middleware_editor | (RA) WHITE ON GREEN | DOLORES ST intersection | 1328 | ABOVE STREET NAME | - | - | - | - | - | 81533 | 1091689200000 | -122.42438486 | 37.74383822 | - | 1581494400000 | - | D8 | - | OTHER GUIDE | GUIDE | M7-1.0001 | 12X09 | SUP2 | LIGHT POLE | IS | 1580895900000 | 29TH ST | - | - | - | - | - | - |
| 64422 | N/A | Point | 1 | 1 | 2501 - 2599 | - | S261237 | 201-2599 OFARRELL ST | 2501-2599 OFARRELL ST | T | T | - | F | 9746000 | 9746000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | ANZAVISTA AVE | ANZAVISTA AVE | 110573 | 110573 | 37.7811951 | -122.4465509 | - | - | 1720662716000 | middleware_editor | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | ANZAVISTA AVE to ANZA ST \ MASONIC AVE (2501 - 2599) | 134733 | 65' WEST OF ANZA VISTA | - | - | - | - | - | 81534 | 1330041600000 | -122.4465509 | 37.7811951 | - | - | - | D2 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP1 | LIGHT POLE | IS | 1581088140000 | OFARRELL ST | 2501 - 2599 OFARRELL ST | 2501 - 2599 OFARRELL ST | 2501 OFARRELL ST | - | ANZA ST \ MASONIC AVE | ANZA ST \ MASONIC AVE |
| 64423 | N/A | Point | - | - | - | - | S286820 | POLK ST: GEARY ST | - | T | T | - | F | 25182000 | 25182000 | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | - | - | - | - | POLK ST | GEARY ST | 110620 | 110620 | 37.7858929 | -122.41973873 | GEARY ST \ POLK ST | POLK ST \ GEARY ST | 1710539427000 | MTA | TREE TOP 6FT SPEED BUMP | GEARY ST intersection | - | - | - | - | - | - | - | 81535 | 1675900800000 | -122.41973873 | 37.7858929 | - | - | - | D6 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1672223460000 | POLK ST | - | - | - | - | - | - |
| 64424 | N/A | Point | 1 | 1 | 500 - 530 | - | S287628 | 500-530 LAUREL ST | 500-530 LAUREL ST | F | F | - | F | 8174000 | 8174000 | - | - | EAST SIDE | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 110625 | 110625 | 37.78648629 | -122.4500493 | - | - | 1710539427000 | MTA | BIKE RACK | CALIFORNIA ST to MAYFAIR DR (500 - 530) | 681654 | 16' S OF CALIFORNIA ST/ 3' IN FROM CURB | - | - | - | - | - | 81536 | 1677628800000 | -122.4500493 | 37.78648629 | - | - | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1677071340000 | LAUREL ST | 500 - 530 LAUREL ST | 500 - 530 LAUREL ST | 500 LAUREL ST | - | MAYFAIR DR | MAYFAIR DR |
| 64425 | N/A | Point | 1 | 1 | 2001 - 2199 | - | S263636 | 2001-2199 SILVER AVE | 2001-2199 SILVER AVE | F | F | - | F | 11935000 | 11935000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | THOMAS AVE | THOMAS AVE | 110636 | 110636 | 37.73600695 | -122.39945662 | - | - | 1752171284000 | middleware_editor | SCHOOL (SYM)/SCHOOL | THOMAS AVE to REVERE AVE (2001 - 2199) | 213829 | EPL# 2021 | - | - | - | - | - | 81537 | 1188198000000 | -122.39945662 | 37.73600695 | - | - | - | D10 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | SIGNAL POLE | IS | 1588154400000 | SILVER AVE | 2001 - 2199 SILVER AVE | 2001 - 2199 SILVER AVE | 2001 SILVER AVE | - | REVERE AVE | REVERE AVE |
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.