MTA.signshop_assets
No additional information has been provided for this dataset.
Between for ranges (e.g., 10,100)Regex for pattern matchingCase sensitive for exact matches
| ID | Feature ID | Geometry Type | ACCEPTED | ACTIVE | ADDRANGE | ARROW DIR | ASSET ID | ASSET NAME | ASSET NAME 1 | BAPA | BOOM TRUCK | CANCEL | CLEARANCE PERMIT | CNN | CNN 1 | COMBOKEY | CONDITION | CORNER SIDE FACING | CREATED DATE | CREATED USER | CURLYIDS | ETL | FROM ST | FROM ST 1 | GISOBJID | GLOBALID UDFCHAR44 | GPS LATITUDE | GPS LONGITUDE | INTERSECTION | INTERSECTION 1 | LAST EDITED DATE | LAST EDITED USER | LEGEND | LIMITS | LOCATION TRACK ID | LOC SPEC | NEW PURPOSE | NEW SIGN CODE | NEW SIGN LEGEND | NEW SIGN SIZE | NUM OF ASSETS | OBJECTID 1 | ORIG INSTALL DATE | POINT X | POINT Y | PURPOSE | REPLACEMENT DATE | RETIREMENT DATE | SF SUP DISTRICT | SHEETING | SIGN CATEGORY | SIGN CLASS | SIGN CODE | SIGN SIZE | SIGN SUPERVISOR | SIGN SUPPORT | STATUS CODE | STATUS DATE | STREETNAME | STREET ADDRESS RANGE | STREET ADDRESS RANGE 1 | STREET BLOCK | STREET VIEW | TO ST | TO ST 1 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 112801 | N/A | Point | - | - | - | - | S223615 | - | - | T | T | - | F | 6153000 | - | SR56(CA).0001-None-37.736671--122.359657 | - | NORTH SIDE | 1689201652000 | MTA | - | - | - | - | 140460 | 140460 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | PHOTO ENFORCED (SYM) | - | - | 50' WEST OF SANTOS | - | - | - | - | - | 130109 | - | - | - | - | - | - | D10 | - | OTHER REGULATORY | REG | SR56(CA).0001 | 30X42 | SUP1 | LIGHT POLE | IS | - | - | 2100-2199 GENEVA AVE | - | - | - | - | - |
| 112802 | N/A | Point | - | - | - | - | S152913 | - | - | F | F | - | F | - | - | R30B(CA).0102-2008-10-30 00:00:00-37.736671--122.359657 | - | SOUTH SIDE | 1689201652000 | MTA | - | - | - | - | 140461 | 140461 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NPRK 1PM-3PM 2ND & 4TH WED OF MONTH STCL | - | - | 1039 PORTOLA | - | - | - | - | - | 130110 | 1225324800000 | - | - | - | 1678924800000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0102 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | PNDG PORTOLA DR | - | - | - | - | - |
| 112803 | N/A | Point | - | - | - | - | S200710 | - | - | F | F | - | F | 926000 | - | R30B(CA).0179-None-37.736671--122.359657 | - | EAST SIDE | 1689201652000 | MTA | - | - | - | - | 140462 | 140462 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NPRK 6AM-7AM WED STCL | - | - | OPP#3017 | - | - | - | - | - | 130111 | - | - | - | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0179 | 18X18 | SUP2 | LIGHT POLE | IS | - | - | 3000-3099 19TH AVE | - | - | - | - | - |
| 112804 | N/A | Point | - | - | - | - | S152687 | - | - | F | F | - | F | - | - | R30B(CA).0255-2009-04-06 00:00:00-37.736671--122.359657 | - | EAST SIDE | 1689201652000 | MTA | - | - | - | - | 140463 | 140463 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 2ND & 4TH MON OF MONTH STCL | - | - | INFO #123 | - | - | - | - | - | 130112 | 1238976000000 | - | - | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0255 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | PENDING ADDRESS RANGE | - | - | - | - | - |
| 112805 | N/A | Point | - | - | - | - | S148409 | - | - | F | F | - | F | - | - | R30B(CA).0294-2008-10-28 00:00:00-37.736671--122.359657 | - | EAST SIDE | 1689201652000 | MTA | - | - | - | - | 140464 | 140464 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM 2ND & 4TH MON OF MONTH STCL | - | - | 10FT SOUTH OF HOLLOWAY | - | - | - | - | - | 130113 | 1225152000000 | - | - | - | 1680566400000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0294 | 18X18 | SUP2 | LIGHT POLE | IS | - | - | PENDING ADDRESS RANGE | - | - | - | - | - |
| 112806 | N/A | Point | - | - | - | - | S284601 | - | - | F | F | - | F | - | - | R3-2.0002-None-37.736671--122.359657 | - | NORTH SIDE, EASTBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140465 | 140465 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | - | - | 20 FT EAST OF MIDDLE DR WEST | - | - | - | - | - | 130114 | 1660867200000 | - | - | - | - | - | D1 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | IS | - | - | 1650-1699 MARTIN LUTHER KING J | - | - | - | - | - |
| 112807 | N/A | Point | - | - | - | - | S288303 | - | - | F | F | - | F | 155270009 | - | R30B(CA).0273-2010-10-25 00:00:00-37.736671--122.359657 | - | NORTH SIDE | 1689201652000 | MTA | - | - | - | - | 140466 | 140466 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM WED STCL | - | - | WPL 1600 | - | - | - | - | - | 130115 | 1287964800000 | - | - | - | 1680739200000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP2 | LIGHT POLE | IS | - | - | 1500-1599 SLOAT BLVD | - | - | - | - | - |
| 112808 | N/A | Point | - | - | - | LEFT ARROW | S287718 | - | - | F | F | - | F | 13160000 | - | R38(SF)1.0001-None-37.736671--122.359657 | - | WEST SIDE | 1689201652000 | MTA | - | - | - | - | 140467 | 140467 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | TA (SYM) PLO AT ALL TIMES (5 MIN) | - | - | 24' SOUTH OF WASHINGTON ST. | - | - | - | - | - | 130116 | 1677715200000 | - | - | - | - | - | D3 | - | OTHER REGULATORY | REG | R38(SF)1.0001 | 14X21 | SUP1 | 2IN IRON POST | IS | - | - | 1800-1899 VAN NESS AVE | - | - | - | - | - |
| 112809 | N/A | Point | - | - | - | - | S259921 | - | - | F | F | - | F | 11458000 | - | R30B(CA).0259-2014-09-11 00:00:00-37.736671--122.359657 | - | EAST SIDE | 1689201652000 | MTA | - | - | - | - | 140452 | 140452 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM FRI STCL | - | - | 50 FT NORTH OF NIAGARA ABOVE STRET CLEN | - | - | - | - | - | 130117 | 1410393600000 | - | - | - | 1578355200000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0259 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 2300-2399 SAN JOSE AVE | - | - | - | - | - |
| 112810 | N/A | Point | - | - | - | - | S261860 | - | - | F | F | - | F | 8756000 | - | SR60-1(SF).0009-None-37.736671--122.359657 | - | SOUTH SIDE, EASTBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140468 | 140468 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | LEFT LANE MUNI, AC TRANSIT & TAXIS ONLY AHEAD | - | - | X ST IS 12TH ST, 160' EAST OF 12TH ST. | - | - | - | - | - | 130118 | - | - | - | - | - | - | D6 | - | TRANSIT ONLY(LEFT LANE) | REG | SR60-1(SF).0009 | 30X42 | SUP1 | LIGHT POLE | IS | - | - | 1590-1615 MARKET ST | - | - | - | - | - |
| 112811 | N/A | Point | - | - | - | - | S229376 | - | - | F | F | - | F | 99991654 | - | TYPE-DL.0011-2016-09-30 09:11:00-37.736671--122.359657 | - | NORTH SIDE | 1689201652000 | MTA | - | - | - | - | 140469 | 140469 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | - | - | 15'/50' W OF BERNICE ST/CRSS-ST BERNICE | - | - | - | - | - | 130119 | 1475226660000 | - | - | - | 1504828800000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | - | - | PENDING 13TH ST | - | - | - | - | - |
| 112812 | N/A | Point | - | - | - | - | S229512 | - | - | F | F | - | F | 189000 | - | TYPE-DL.0002-None-37.736671--122.359657 | - | CENTER ISLAND | 1689201652000 | MTA | - | - | - | - | 140470 | 140470 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | DELINEATOR (Y) (SAFE HIT) | - | - | SEE NOTES | - | - | - | - | - | 130120 | - | - | - | - | - | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0002 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | - | - | 2200-2299 3RD ST | - | - | - | - | - |
| 112813 | N/A | Point | - | - | - | - | S203918 | - | - | F | F | - | F | 8750010 | - | R37(CA).0090-None-37.736671--122.359657 | - | NORTH SIDE | 1689201652000 | MTA | - | - | - | - | 140471 | 140471 | 37.736671 | -122.359657 | - | - | 1756147923000 | middleware_editor | TANSAT | - | - | OPP #1025 | - | - | - | - | - | 130121 | - | - | - | - | - | 1756145700000 | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | RETD | - | - | 1000-1059 MARKET ST | - | - | - | - | - |
| 112814 | N/A | Point | - | - | - | - | S207818 | - | - | F | F | - | F | 6372020 | - | R30B(CA).0078-2014-09-08 12:31:00-37.736671--122.359657 | - | WEST SIDE | 1689201652000 | MTA | - | - | - | - | 140472 | 140472 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM MON STCL | - | - | IFO #272 RAISE SIGN NEED EXT. | - | - | - | - | - | 130122 | 1410179460000 | - | - | - | 1410134400000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0078 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 200-249 GRAND VIEW AVE | - | - | - | - | - |
| 112815 | N/A | Point | - | - | - | - | S206376 | - | - | F | F | - | F | 8049000 | - | R30B(CA).0225-2018-07-26 13:45:00-37.736671--122.359657 | - | WEST SIDE | 1689201652000 | MTA | - | - | - | - | 140473 | 140473 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NPRK 7AM-8AM WED STCL | - | - | 300`SOUTH(3RD 2IN SOUTH) | - | - | - | - | - | 130123 | 1532612700000 | - | - | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0225 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 724-749 LAKE MERCED BLVD | - | - | - | - | - |
| 112816 | N/A | Point | - | - | - | DOWN ARROW | S262529 | - | - | F | F | - | F | - | - | R38(SF)3.0008-None-37.736671--122.359657 | - | NORTH SIDE | 1689201652000 | MTA | - | - | - | - | 140474 | 140474 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | TA (SYM) TOUR BUS ONLY 9AM-7PM SAT AND SUN (20 MIN) | - | - | 100 FT EAST OF 10TH AVE | - | - | - | - | - | 130124 | - | - | - | - | - | - | D5 | - | OTHER REGULATORY | REG | R38(SF)3.0008 | 14X21 | SUP1 | 2IN IRON POST | IS | - | - | PNDG LINCOLN WAY | - | - | - | - | - |
| 112817 | N/A | Point | - | - | - | - | S211224 | - | - | F | F | - | F | 8702000 | - | R2-1.0005-2008-08-28 00:00:00-37.736671--122.359657 | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140475 | 140475 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | SPEED LIMIT 25 | - | - | OPP.# 145 MARINA BLVD. | - | - | - | - | - | 130125 | 1219881600000 | - | - | - | - | - | D2 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP1 | LIGHT POLE | IS | - | - | 100-199 MARINA BLVD | - | - | - | - | - |
| 112818 | N/A | Point | - | - | - | - | S281845 | - | - | F | F | - | F | 10270000 | - | R3-11A.0001-2022-02-18 00:00:00-37.736671--122.359657 | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140856 | 140856 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | RIGHT TURN OK | - | - | 195 FT SOUTH OF | - | - | - | - | - | 130126 | 1645142400000 | - | - | - | - | - | D1 | - | OTHER REGULATORY | REG | R3-11A.0001 | 30X08 | SUP2 | 2IN IRON POST | IS | - | - | 600-699 PARK PRESIDIO BLVD | - | - | - | - | - |
| 112819 | N/A | Point | - | - | - | VERTICAL ARROW | S123947 | - | - | T | T | - | F | 192000 | - | G-OC(SF).0001-2006-06-02 00:00:00-37.736671--122.359657 | - | EAST SIDE, NORTHBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140857 | 140857 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | ORACLE PARK (TEMPORARY DECAL) | - | 7 | 100' SOUTH | - | - | - | - | - | 130127 | 1149206400000 | - | - | - | 1553904000000 | - | D10 | - | OTHER GUIDE | GUIDE | G-OC(SF).0001 | 42X18 | SUP1 | LIGHT POLE | IS | - | - | 2700-2799 3RD ST | - | - | - | - | - |
| 112820 | N/A | Point | - | - | - | - | S121154 | - | - | F | F | - | F | 192000 | - | R37(CA).0090-2005-06-18 00:00:00-37.736671--122.359657 | - | EAST SIDE | 1689201652000 | MTA | - | - | - | - | 140858 | 140858 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | TANSAT | - | - | 100'SOUTH | - | - | - | - | - | 130128 | 1119052800000 | - | - | - | - | - | D10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | - | - | 2700-2799 3RD ST | - | - | - | - | - |
| 112821 | N/A | Point | - | - | - | - | S251694 | - | - | F | F | - | F | 4867000 | - | R(SF).0020-2017-04-17 00:00:00-37.736671--122.359657 | - | WEST SIDE | 1689201652000 | MTA | - | - | - | - | 140859 | 140859 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | BIKE RACK | - | - | IFO 392 | - | - | - | - | - | 130129 | 1492387200000 | - | - | - | 1550620800000 | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BARRICADE | IS | - | - | 340-399 DOLORES ST | - | - | - | - | - |
| 112822 | N/A | Point | - | - | - | - | S251285 | - | - | F | F | - | F | 8045000 | - | TYPE-K(CA).0001-2016-11-18 00:00:00-37.736671--122.359657 | - | CENTER ISLAND | 1689201652000 | MTA | - | - | - | - | 140860 | 140860 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | TYPE K | - | - | NORTH ISLAND / NWC OF ISLAND | - | - | - | - | - | 130130 | 1479427200000 | - | - | - | 1557878400000 | - | D7 | - | OTHER WARNING | WARNING | TYPE-K(CA).0001 | 05X12 | SUP2 | DELINEATOR BASE SAFE HIT | IS | - | - | 300-399 LAKE MERCED BLVD | - | - | - | - | - |
| 112823 | N/A | Point | - | - | - | - | S246653 | - | - | F | F | - | F | 8708000 | - | R32C(CA).0096-2011-11-02 00:00:00-37.736671--122.359657 | - | SOUTH SIDE | 1689201652000 | MTA | - | - | - | - | 140863 | 140863 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "M" PERMITS | - | - | WPL #755 | - | - | - | - | - | 130131 | 1320192000000 | - | - | - | 1513728000000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0096 | 18X21 | SUP1 | LIGHT POLE | IS | - | - | 700-799 MARINA BLVD | - | - | - | - | - |
| 112824 | N/A | Point | - | - | - | - | S102966 | - | - | F | F | - | F | 921000 | - | R3-2.0002-1958-09-19 00:00:00-37.736671--122.359657 | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140864 | 140864 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | - | - | S LINE / 00 | - | - | - | - | - | 130132 | -356140800000 | - | - | - | - | - | D7 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | UNKNOWN | IS | - | - | 2400-2499 19TH AVE | - | - | - | - | - |
| 112825 | N/A | Point | - | - | - | - | S109655 | - | - | F | F | - | F | 6994000 | - | R3-2.0002-1986-11-13 00:00:00-37.736671--122.359657 | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140865 | 140865 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | - | - | 0 / REINFORCE EXISTING ONE-WAY STREET | - | - | - | - | - | 130133 | 532224000000 | - | - | - | - | - | D7 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | - | - | 1450-1485 HOLLOWAY AVE | - | - | - | - | - |
| 112826 | N/A | Point | - | - | - | - | S102948 | - | - | F | F | - | F | 912000 | - | R3-2.0002-1958-09-17 00:00:00-37.736671--122.359657 | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140866 | 140866 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | - | - | N LINE / 00 | - | - | - | - | - | 130134 | -356313600000 | - | - | - | - | - | D7 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | UNKNOWN | IS | - | - | 1500-1599 19TH AVE | - | - | - | - | - |
| 112827 | N/A | Point | - | - | - | - | S224878 | - | - | F | F | - | F | 6585010 | - | R30B(CA).0238-None-37.736671--122.359657 | - | WEST SIDE | 1689201652000 | MTA | - | - | - | - | 140867 | 140867 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM MON THUR STCL | - | - | 75'S OF 23RD ST | - | - | - | - | - | 130135 | - | - | - | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0238 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | - | - | 1100-1150 GUERRERO ST | - | - | - | - | - |
| 112828 | N/A | Point | - | - | - | - | S224907 | - | - | F | F | - | F | 927030 | - | R30B(CA).0179-2001-04-09 00:00:00-37.736671--122.359657 | - | WEST SIDE | 1689201652000 | MTA | - | - | - | - | 140869 | 140869 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NPRK 6AM-7AM WED STCL | - | - | 250S | - | - | - | - | - | 130136 | 986774400000 | - | - | - | 1462233600000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0179 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 3300-3399 19TH AVE | - | - | - | - | - |
| 112829 | N/A | Point | - | - | - | - | S234091 | - | - | F | F | - | F | 8776030 | - | R26(CA).0001-2017-03-16 14:33:00-37.736671--122.359657 | - | WEST SIDE | 1689201652000 | MTA | - | - | - | - | 140871 | 140871 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NPRK ANY TIME | - | - | 200FT. SOUTH OF GLENDALE ST. | - | - | - | - | - | 130137 | 1489674780000 | - | - | - | 1489622400000 | - | D8 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP2 | LIGHT POLE | IS | - | - | 3600-3649 MARKET ST | - | - | - | - | - |
| 112830 | N/A | Point | - | - | - | - | S100148 | - | - | F | F | - | F | 927020 | - | R3-2.0002-1957-02-27 00:00:00-37.736671--122.359657 | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140872 | 140872 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | - | - | N LINE / 00 | - | - | - | - | - | 130138 | -405302400000 | - | - | - | - | - | D7 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | UNKNOWN | IS | - | - | 3200-3299 19TH AVE | - | - | - | - | - |
| 112831 | N/A | Point | - | - | - | - | S104492 | - | - | F | F | - | F | 4802000 | - | R3-2.0001-1970-01-26 00:00:00-37.736671--122.359657 | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140873 | 140873 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | - | - | N LINE / 0 | - | - | - | - | - | 130139 | 2160000000 | - | - | - | - | - | D5 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | LIGHT POLE | IS | - | - | 500-599 DIVISADERO ST | - | - | - | - | - |
| 112832 | N/A | Point | - | - | - | - | S101968 | - | - | F | F | - | F | 13169000 | - | R3-2.0002-1957-07-02 00:00:00-37.736671--122.359657 | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140874 | 140874 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | - | - | N LINE / 00 | - | - | - | - | - | 130140 | -394502400000 | - | - | - | - | - | D2 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | UNKNOWN | IS | - | - | 2700-2799 VAN NESS AVE | - | - | - | - | - |
| 112833 | N/A | Point | - | - | - | - | S119150 | - | - | F | F | - | F | 2825000 | - | R37(CA).0090-2004-07-08 00:00:00-37.736671--122.359657 | - | EAST SIDE | 1689201652000 | MTA | - | - | - | - | 140875 | 140875 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | TANSAT | - | - | 100' SOUTH | - | - | - | - | - | 130141 | 1089244800000 | - | - | - | - | - | D10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | - | - | 2400-2499 BAYSHORE BLVD | - | - | - | - | - |
| 112834 | N/A | Point | - | - | - | - | S119125 | - | - | F | F | - | F | 2826000 | - | R5-1(SF).0007-2004-06-30 00:00:00-37.736671--122.359657 | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140876 | 140876 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | DO NOT ENTER EXC MUNI | - | - | NCI | - | - | - | - | - | 130142 | 1088553600000 | - | - | - | - | - | D10 | - | OTHER REGULATORY | REG | R5-1(SF).0007 | 18X24 | SUP1 | SIGNAL POLE | IS | - | - | 2500-2599 BAYSHORE BLVD | - | - | - | - | - |
| 112835 | N/A | Point | - | - | - | - | S109389 | - | - | F | F | - | F | 13172000 | - | R3-2.0001-1985-01-16 00:00:00-37.736671--122.359657 | - | UNKNOWN | 1689201652000 | MTA | - | - | - | - | 140877 | 140877 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | - | - | S LINE / ADDITIONAL SGN | - | - | - | - | - | 130143 | 474681600000 | - | - | - | - | - | D2 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | SIGNAL POLE | IS | - | - | 3000-3099 VAN NESS AVE | - | - | - | - | - |
| 112836 | N/A | Point | - | - | - | - | S109024 | - | - | F | F | - | F | 12554000 | - | R1-1.0002-1982-04-23 00:00:00-37.736671--122.359657 | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140878 | 140878 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | STOP | - | - | 00 / NORTH LINE | - | - | - | - | - | 130144 | 388368000000 | - | - | - | - | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | FREEWAY COLUMN | IS | - | - | 200-499 THE EMBARCADERO | - | - | - | - | - |
| 112837 | N/A | Point | - | - | - | - | S109554 | - | - | F | F | - | F | 9820000 | - | R3-2.0001-1986-04-22 00:00:00-37.736671--122.359657 | - | UNKNOWN | 1689201652000 | MTA | - | - | - | - | 140879 | 140879 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | - | - | E LINE / OF LEE | - | - | - | - | - | 130145 | 514512000000 | - | - | - | - | - | D7 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | - | - | 1100-1199 OCEAN AVE | - | - | - | - | - |
| 112838 | N/A | Point | - | - | - | - | S118933 | - | - | F | F | - | F | 7991000 | - | R5-2.0009-2004-05-20 00:00:00-37.736671--122.359657 | - | CENTER ISLAND, WESTBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140880 | 140880 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NO TRUCKS (SYM) OVER 3 TONS ON DEWEY BLVD | - | - | E-LINE | - | - | - | - | - | 130146 | 1085011200000 | - | - | - | - | - | D7 | - | OTHER REGULATORY | REG | R5-2.0009 | 30X54 | SUP2 | LIGHT POLE | IS | - | - | 400-499 LAGUNA HONDA BLVD | - | - | - | - | - |
| 112839 | N/A | Point | - | - | - | - | S120475 | - | - | F | F | - | F | 229000 | - | R37(CA).0090-2005-03-02 00:00:00-37.736671--122.359657 | - | WEST SIDE | 1689201652000 | MTA | - | - | - | - | 140881 | 140881 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | TANSAT | - | - | INFO # 6242 | - | - | - | - | - | 130147 | 1109721600000 | - | - | - | - | - | D10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | - | - | 6238-6299 3RD ST | - | - | - | - | - |
| 112840 | N/A | Point | - | - | - | - | S133860 | - | - | F | F | - | F | 12287000 | - | R1-5.0002-2011-02-15 00:00:00-37.736671--122.359657 | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140882 | 140882 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | YIELD HERE TO PED (SYM) (LA) | - | - | 25`NORTH | - | - | - | - | - | 130148 | 1297728000000 | - | - | - | - | - | D4 | - | PEDESTRIAN | REG | R1-5.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | - | - | 2500-2599 SUNSET BLVD | - | - | - | - | - |
| 112841 | N/A | Point | - | - | - | - | S289801 | - | - | F | F | - | F | 6090000 | - | PROVISIONAL CODE-None-37.736671--122.359657 | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 141309 | 141309 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | - | IFO 6940 LEGION OF HONOR (RA) SIGN | - | - | - | - | - | 130149 | - | - | - | - | - | - | D1 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | 2IN IRON POST | IS | - | - | 6900-6999 GEARY BLVD | - | - | - | - | - |
| 112842 | N/A | Point | - | - | - | - | S244436 | - | - | T | T | - | F | 4871000 | - | R(SF).0377-2016-02-08 00:00:00-37.736671--122.359657 | - | WEST SIDE | 1689201652000 | MTA | - | - | - | - | 141310 | 141310 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | PARK SMART | - | - | 30`NORTH OF WALK WAY INTO PARK | - | - | - | - | - | 130150 | 1454889600000 | - | - | - | 1523232000000 | - | D8 | - | OTHER REGULATORY | REG | R(SF).0377 | 18X21 | SUP2 | LIGHT POLE | IS | - | - | 566-649 DOLORES ST | - | - | - | - | - |
| 112843 | N/A | Point | - | - | - | - | S275376 | - | - | T | T | - | F | 8744010 | - | R2-1.0004-2021-07-06 13:26:00-37.736671--122.359657 | - | SOUTH SIDE, EASTBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 141311 | 141311 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | - | - | 35' WEST OF WPL# 653 | - | - | - | - | - | 130151 | 1625577960000 | - | - | - | - | - | D3 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | - | - | 600-683 MARKET ST | - | - | - | - | - |
| 112844 | N/A | Point | 1 | - | - | - | S112837 | 301-399 JEFFERSON ST | - | F | F | - | F | 7458000 | 7458000 | R10-6.0002-2000-09-19 00:00:00-37.80790822--122.418266 | - | SOUTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | - | - | 9704 | 9704 | 37.80790822 | -122.418266 | - | - | 1710539427000 | MTA | STOP HERE ON RED (45LA) | - | - | 45E ON MASTARM FWBT (WRITTEN TAG HA..... | - | - | - | - | - | 130152 | 969321600000 | -122.418266 | 37.80790822 | - | - | - | D3 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP1 | LIGHT POLE | IS | 1373571540000 | JEFFERSON ST | 301-399 JEFFERSON ST | JEFFERSON ST | - | - | - | - |
| 112845 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S203939 | 1800-1899 POLK ST | 1800-1899 POLK ST | F | F | - | F | 10573000 | 10573000 | R30B(CA).0195-2014-09-24 13:11:00-37.79370093--122.42131717 | - | EAST SIDE | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 46440 | 46440 | 37.79370093 | -122.42131717 | - | - | 1711570023000 | middleware_editor | NPRK 6AM-8AM TUE THUR STCL | WASHINGTON ST to JACKSON ST (1800 - 1899) | - | 48' S OF JACKSON | - | - | - | - | - | 130153 | 1411564260000 | -122.42131717 | 37.79370093 | - | 1711459860000 | - | D3 | - | STREET CLEANING | REG | R30B(CA).0195 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1395062700000 | POLK ST | 1800 - 1899 POLK ST | 1800 - 1899 POLK ST | 1800 POLK ST | - | JACKSON ST | JACKSON ST |
| 112846 | N/A | Point | - | - | - | - | S208173 | GARFIELD ST: BEVERLY ST | - | F | F | - | F | 6014000 | 22728000 | W17-1.0001-2014-08-21 07:08:00-37.7196402--122.47165211 | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | MONTICELLO ST | GARFIELD ST | 47834 | 47834 | 37.7196402 | -122.47165211 | - | BEVERLY ST \ GARFIELD ST | 1728523142000 | middleware_editor | SPEED HUMP | GARFIELD ST intersection | - | 15FT EAST OF BEVERLEY | - | - | - | - | - | 130154 | 1408604880000 | -122.47165211 | 37.7196402 | - | 1408579200000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1407835740000 | BEVERLY ST | 900 - 999 GARFIELD ST | - | - | - | BEVERLY ST | - |
| 112847 | N/A | Point | 1 | 1 | 100 - 199 | - | S231339 | 100-199 ROOSEVELT WAY | 100-199 ROOSEVELT WAY | F | F | - | F | 11141000 | 11141000 | W3-1.0002-2017-02-15 12:42:00-37.76669587--122.43889804 | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | BUENA VISTA TER | BUENA VISTA TER | 65753 | 65753 | 37.76669587 | -122.43889804 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | BUENA VISTA TER to 15TH ST \ PARK HILL AVE (100 - 199) | - | 130FT. WEST OF BUENA VISTA TER. | - | - | - | - | - | 130155 | 1487162520000 | -122.43889804 | 37.76669587 | - | 1487116800000 | - | D8 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1479910080000 | ROOSEVELT WAY | 100 - 199 ROOSEVELT WAY | 100 - 199 ROOSEVELT WAY | 100 ROOSEVELT WAY | - | 15TH ST \ PARK HILL AVE | 15TH ST \ PARK HILL AVE |
| 112848 | N/A | Point | - | - | - | - | S230157 | TRUMBULL ST: CONGDON ST | - | F | F | - | F | 21669000 | 21669000 | W17-1A.0001-2016-11-09 15:36:00-37.73088141--122.42614366 | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TRUMBULL ST | CONGDON ST | 65870 | 65870 | 37.73088141 | -122.42614366 | CONGDON ST \ TRUMBULL ST | TRUMBULL ST \ CONGDON ST | 1718154857000 | middleware_editor | SPEED HUMPS | CONGDON ST intersection | - | - | - | - | - | - | - | 130156 | 1478705760000 | -122.42614366 | 37.73088141 | - | 1478649600000 | - | D11 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1477404120000 | TRUMBULL ST | - | - | - | - | - | - |
| 112849 | N/A | Point | 1 | 1 | 100 - 199 | - | S231340 | 100-199 ROOSEVELT WAY | 100-199 ROOSEVELT WAY | F | F | - | F | 11141000 | 11141000 | W3-1.0002-2017-02-15 12:44:00-37.76669587--122.43889804 | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | BUENA VISTA TER | BUENA VISTA TER | 65881 | 65881 | 37.76669587 | -122.43889804 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | BUENA VISTA TER to 15TH ST \ PARK HILL AVE (100 - 199) | - | IFO# 30 | - | - | - | - | - | 130157 | 1487162640000 | -122.43889804 | 37.76669587 | - | 1487116800000 | - | D8 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1479910260000 | ROOSEVELT WAY | 100 - 199 ROOSEVELT WAY | 100 - 199 ROOSEVELT WAY | 100 ROOSEVELT WAY | - | 15TH ST \ PARK HILL AVE | 15TH ST \ PARK HILL AVE |
| 112850 | N/A | Point | - | - | - | - | S230158 | TRUMBULL ST: CONGDON ST | - | F | F | - | F | 21669000 | 21669000 | W17-1A.0001-2016-11-09 15:52:00-37.73088141--122.42614366 | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | TRUMBULL ST | CONGDON ST | 67225 | 67225 | 37.73088141 | -122.42614366 | CONGDON ST \ TRUMBULL ST | TRUMBULL ST \ CONGDON ST | 1718154860000 | middleware_editor | SPEED HUMPS | CONGDON ST intersection | - | IFO#387 | - | - | - | - | - | 130158 | 1478706720000 | -122.42614366 | 37.73088141 | - | 1478649600000 | - | D11 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1477404420000 | TRUMBULL ST | - | - | - | - | - | - |
| 112851 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S231716 | 1600-1699 QUINTARA ST | 1600-1699 QUINTARA ST | F | F | - | F | 10861000 | 10861000 | W1-7.0001-2008-12-10 00:00:00-37.74833807--122.48304802 | - | NORTH SIDE | - | - | - | - | 25TH AVE | 25TH AVE | 68528 | 68528 | 37.74833807 | -122.48304802 | - | - | 1745448870000 | middleware_editor | DOUBLE ARROW-LEFT & RIGHT (SYM) | 25TH AVE to 26TH AVE (1600 - 1699) | - | OPP.C-LINE | - | - | - | - | - | 130159 | 1228896000000 | -122.48304802 | 37.74833807 | - | 1745439900000 | - | D4 | - | OTHER WARNING | WARNING | W1-7.0001 | 36X18 | SUP2 | 2IN IRON POST | IS | 1481544240000 | QUINTARA ST | 1600 - 1699 QUINTARA ST | 1600 - 1699 QUINTARA ST | 1600 QUINTARA ST | - | 26TH AVE | 26TH AVE |
| 112852 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S238266 | 1800-1899 POLK ST | 1800-1899 POLK ST | F | F | - | F | 10573000 | 10573000 | R30B(CA).0195-2017-08-16 14:42:00-37.79370093--122.42131717 | - | EAST SIDE | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 75733 | 75733 | 37.79370093 | -122.42131717 | - | - | 1711569964000 | middleware_editor | NPRK 6AM-8AM TUE THUR STCL | WASHINGTON ST to JACKSON ST (1800 - 1899) | - | NPL IFO# 1820 | - | - | - | - | - | 130160 | 1502894520000 | -122.42131717 | 37.79370093 | - | 1502841600000 | - | D3 | - | STREET CLEANING | REG | R30B(CA).0195 | 18X18 | SUP1 | 2IN IRON POST | IS | 1502793060000 | POLK ST | 1800 - 1899 POLK ST | 1800 - 1899 POLK ST | 1800 POLK ST | - | JACKSON ST | JACKSON ST |
| 112853 | N/A | Point | - | - | - | INBOUND | S240805 | MISSION ST: 4TH ST | - | F | F | - | F | 24632000 | 24632000 | SOLAR-WHITE.0001-2018-02-06 07:50:00-37.78447875--122.40426687 | - | SOUTH SIDE | - | - | - | - | 4TH ST | 04TH ST | 76141 | 76141 | 37.78447875 | -122.40426687 | MISSION ST \ 4TH ST | MISSION ST \ 04TH ST | 1710539427000 | MTA | SOLAR LANTERN WHITE (V5) | 04TH ST intersection | 15533 | INFO #785 | - | - | - | - | - | 130161 | 1517903400000 | -122.40426687 | 37.78447875 | - | 1517875200000 | - | D6 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | UNISTRUT | IS | 1511291820000 | MISSION ST | - | - | - | - | - | - |
| 112854 | N/A | Point | - | - | - | INBOUND | S240774 | MISSION ST: 3RD ST | - | F | F | - | F | 24613000 | 24613000 | SOLAR-WHITE.0001-2018-02-06 07:18:00-37.78624815--122.40202542 | - | SOUTH SIDE | - | - | - | - | 3RD ST | 03RD ST | 83153 | 83153 | 37.78624815 | -122.40202542 | MISSION ST \ 3RD ST | MISSION ST \ 03RD ST | 1726191092000 | middleware_editor | SOLAR LANTERN WHITE (V5) | 03RD ST intersection | 15531 | 20' FT WEST OF END BUS STOP | - | - | - | - | - | 130162 | 1517901480000 | -122.40202542 | 37.78624815 | - | 1517875200000 | - | D6 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | UNISTRUT | IS | 1511291700000 | MISSION ST | - | - | - | - | - | - |
| 112855 | N/A | Point | 1 | 1 | 800 - 899 | - | S272080 | 800-899 CLEMENT ST | 800-899 CLEMENT ST | F | F | - | F | 4158000 | 4158000 | W3-1.0002-2021-02-11 10:00:00-37.78277658--122.46816679 | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 9TH AVE | 09TH AVE | 86441 | 86441 | 37.78277658 | -122.46816679 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | 09TH AVE to 10TH AVE (800 - 899) | - | EPL 837 | - | - | - | - | - | 130163 | 1613037600000 | -122.46816679 | 37.78277658 | - | 1643241600000 | - | D1 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1612259220000 | CLEMENT ST | 800 - 899 CLEMENT ST | 800 - 899 CLEMENT ST | 800 CLEMENT ST | - | 10TH AVE | 10TH AVE |
| 112856 | N/A | Point | - | - | - | - | S257376 | EVERSON ST: DIGBY ST | - | F | F | - | F | 33494000 | 33494000 | W(SF).0034-2005-04-13 00:00:00-37.74004786--122.4330599 | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | EVERSON ST | DIGBY ST | 86987 | 86987 | 37.74004786 | -122.4330599 | DIGBY ST \ EVERSON ST | EVERSON ST \ DIGBY ST | 1710539427000 | MTA | NOT A THROUGH STREET | DIGBY ST intersection | - | NPL 61 | - | - | - | - | - | 130164 | 1113350400000 | -122.4330599 | 37.74004786 | - | - | - | D8 | - | OTHER WARNING | WARNING | W(SF).0034 | 30X30 | SUP2 | 2IN IRON POST | IS | 1566896880000 | EVERSON ST | - | - | - | - | - | - |
| 112857 | N/A | Point | - | - | - | - | S257382 | EVERSON ST: DIGBY ST | - | F | F | - | F | 33494000 | 33494000 | W14-1.0002-2005-04-13 00:00:00-37.74004786--122.4330599 | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | EVERSON ST | DIGBY ST | 86988 | 86988 | 37.74004786 | -122.4330599 | DIGBY ST \ EVERSON ST | EVERSON ST \ DIGBY ST | 1710539427000 | MTA | DEAD END | DIGBY ST intersection | - | NPL 61 | - | - | - | - | - | 130165 | 1113350400000 | -122.4330599 | 37.74004786 | - | 1567641600000 | - | D8 | - | OTHER WARNING | WARNING | W14-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1566899460000 | EVERSON ST | - | - | - | - | - | - |
| 112858 | N/A | Point | - | - | - | - | S111621 | IDORA AVE: LAGUNA HONDA BLVD | - | F | F | - | F | 7157000 | 22841000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WOODSIDE AVE | IDORA AVE | 6693 | 6693 | 37.74405759 | -122.45652506 | - | LAGUNA HONDA BLVD \ IDORA AVE | 1710539427000 | MTA | STOP | IDORA AVE intersection | - | BELOW STREET NAMES | - | - | - | - | - | 130166 | 830217600000 | -122.45652506 | 37.74405759 | - | 1473206400000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373571180000 | LAGUNA HONDA BLVD | 1 - 99 IDORA AVE | - | - | - | LAGUNA HONDA BLVD | - |
| 112859 | N/A | Point | - | - | - | - | S226070 | LAGUNA HONDA BLVD: IDORA AVE | - | F | F | - | F | 7157000 | 22841000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | WOODSIDE AVE | IDORA AVE | 65332 | 65332 | 37.74405759 | -122.45652506 | - | LAGUNA HONDA BLVD \ IDORA AVE | 1710539427000 | MTA | STOP AHEAD (SYM) | IDORA AVE intersection | - | - | - | - | - | - | - | 130167 | - | -122.45652506 | 37.74405759 | - | - | - | D7 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1464347820000 | LAGUNA HONDA BLVD | 1 - 99 IDORA AVE | - | - | - | LAGUNA HONDA BLVD | - |
| 112860 | N/A | Point | - | - | - | - | S210676 | IDORA AVE: LAGUNA HONDA BLVD | - | F | F | - | F | 7157000 | 22841000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | WOODSIDE AVE | IDORA AVE | 52784 | 52784 | 37.74405759 | -122.45652506 | - | LAGUNA HONDA BLVD \ IDORA AVE | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | IDORA AVE intersection | - | - | - | - | - | - | - | 130168 | 1415863380000 | -122.45652506 | 37.74405759 | - | 1415836800000 | - | D7 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | LIGHT POLE | IS | 1415614320000 | LAGUNA HONDA BLVD | 1 - 99 IDORA AVE | - | - | - | LAGUNA HONDA BLVD | - |
| 112861 | N/A | Point | - | - | - | - | 23937 | - | - | F | F | - | F | - | - | - | - | WEST SIDE | 1694541483000 | smuneno | - | - | - | - | 154876 | 154876 | 37.7187858025696 | -122.384919682009 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | - | - | 115' SOUTH OF DONNER | - | - | - | - | - | 130169 | 1696242600000 | - | - | - | - | - | 10 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP1 | LIGHT POLE | IS | - | - | - | - | - | - | - | - |
| 112862 | N/A | Point | - | - | - | - | 23942 | - | - | F | F | - | F | 15203000 | - | - | - | SOUTH SIDE | 1694541752000 | smuneno | - | - | ARELIOUS WALKER DR | - | 154993 | 154993 | 37.7193678504135 | -122.385195651423 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | - | - | 100' EAST OF GIANTS DR | - | - | - | - | - | 130170 | 1696248900000 | - | - | - | - | - | 10 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP1 | LIGHT POLE | IS | - | DONNER AVE | 1100 - 1199 DONNER AVE | - | - | - | GIANTS DR | - |
| 112863 | N/A | Point | - | - | - | - | 23936 | - | - | F | F | - | F | 5587000 | - | - | - | WEST SIDE | 1694541422000 | smuneno | - | - | CARROLL AVE | - | 154822 | 154822 | 37.7194102836858 | -122.384349563782 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | - | - | 100' SOUTH OF CARROLL | - | - | - | - | - | 130171 | 1696246200000 | - | - | - | - | - | 10 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP1 | LIGHT POLE | IS | - | ARELIOUS WALKER DR | 2500 - 2699 ARELIOUS WALKER DR | - | - | - | EGBERT AVE | - |
| 112864 | N/A | Point | - | - | - | - | 23941 | - | - | F | F | - | F | - | - | - | - | NORTH SIDE | 1694541696000 | smuneno | - | - | - | - | 154977 | 154977 | 37.7181363271102 | -122.386237540651 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | - | - | 140' WEST OF ARELIOUS WALKER | - | - | - | - | - | 130172 | 1696237200000 | - | - | - | - | - | 10 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP1 | 2IN IRON POST | IS | - | - | - | - | - | - | - | - |
| 112865 | N/A | Point | - | - | - | - | 23938 | - | - | F | F | - | F | 5588000 | - | - | - | WEST SIDE | 1694541577000 | smuneno | - | - | EGBERT AVE | - | 154945 | 154945 | 37.7181431637052 | -122.385490396465 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | - | - | 110' SOUTH OF EGBERT | - | - | - | - | - | 130173 | 1696244400000 | - | - | - | - | - | 10 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP1 | LIGHT POLE | IS | - | ARELIOUS WALKER DR | 2700 - 2799 ARELIOUS WALKER DR | - | - | - | FITZGERALD AVE | - |
| 112866 | N/A | Point | - | - | - | - | S111196 | QUINT ST: DAVIDSON AVE | - | F | F | - | F | 4614000 | 20696000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | QUINT ST | DAVIDSON AVE | 9330 | 9330 | 37.74467268 | -122.38976017 | - | QUINT ST \ DAVIDSON AVE | 1710539427000 | MTA | STOP | DAVIDSON AVE intersection | NWC OF QUINT & DAVIDSON | - | - | - | - | - | - | 130174 | 763948800000 | -122.38976017 | 37.74467268 | - | 1694766300000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571060000 | QUINT ST | 1500 - 1599 DAVIDSON AVE | - | - | - | RANKIN ST | - |
| 112867 | N/A | Point | - | - | - | - | S230107 | QUINT ST: DAVIDSON AVE | - | F | F | - | F | - | 20696000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | - | DAVIDSON AVE | 67666 | 67666 | 37.74467268 | -122.38976017 | - | QUINT ST \ DAVIDSON AVE | 1710539427000 | MTA | ALL WAY | DAVIDSON AVE intersection | NEC OF QUINT & DAVIDSON | - | - | - | - | - | - | 130175 | 763948800000 | -122.38976017 | 37.74467268 | - | 1694616900000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1477318380000 | QUINT ST | - | - | - | - | - | - |
| 112868 | N/A | Point | - | - | - | - | 23693 | - | - | - | T | - | - | 50077000 | - | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | 1693953725000 | smuneno | - | - | I-80 W ON RAMP | - | 153666 | 153666 | 37.7755063779096 | -122.40647815757 | HARRISON ST \ I-80 W ON RAMP | - | 1748466991000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | HARRISON @ 7TH ST | - | - | - | - | - | 130176 | 1695842100000 | - | - | - | - | - | 06 | - | NO RIGHT TURN | REG | R13A(CA).0002 | 24X30 | SUP1 | SIGNAL POLE | IS | - | HARRISON ST | - | - | - | - | - | - |
| 112869 | N/A | Point | - | - | - | - | S112013 | JAMESTOWN AVE: HARNEY WAY | - | F | F | - | F | 20259000 | 20259000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HARNEY WAY | JAMESTOWN AVE | 11838 | 11838 | 37.71116108 | -122.38645191 | JAMESTOWN AVE \ HARNEY WAY | HARNEY WAY \ JAMESTOWN AVE | 1710539427000 | MTA | STOP | JAMESTOWN AVE intersection | - | - | - | - | - | - | - | 130177 | 899769600000 | -122.38645191 | 37.71116108 | - | 1705573800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571300000 | HARNEY WAY | - | - | - | - | - | - |
| 112870 | N/A | Point | 1 | 1 | 149 - 199 | - | S211576 | 149-199 BOUTWELL ST | 149-199 BOUTWELL ST | F | F | - | F | 3036000 | 3036000 | - | - | WEST SIDE | - | - | - | - | BOUTWELL ST | BOUTWELL ST | 93342 | 93342 | 37.73481408 | -122.40554927 | - | - | 1710539427000 | MTA | NPRK 1PM-3PM TUE STCL | BOUTWELL ST to AUGUSTA ST \ BAY SHORE BLVD (149 - 199) | - | NPL #190 | - | - | - | - | - | 130178 | 1418741820000 | -122.40554927 | 37.73481408 | - | 1695811500000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0106 | 18X18 | SUP1 | LIGHT POLE | IS | 1418131980000 | BOUTWELL ST | 149 - 199 BOUTWELL ST | 149 - 199 BOUTWELL ST | 149 BOUTWELL ST | - | AUGUSTA ST \ BAY SHORE BLVD | AUGUSTA ST \ BAY SHORE BLVD |
| 112871 | N/A | Point | - | - | - | - | S253637 | 7TH ST: HARRISON ST | - | T | T | - | F | 23929000 | 23929000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | HARRISON ST | 07TH ST | 100910 | 100910 | 37.77551415 | -122.40629597 | 7TH ST \ HARRISON ST | HARRISON ST \ 07TH ST | 1710539427000 | MTA | NO TURN ON RED ARROW | 07TH ST intersection | - | - | - | - | - | - | - | 130179 | 1466640000000 | -122.40629597 | 37.77551415 | - | 1586217600000 | 1695805200000 | D6 | - | OTHER REGULATORY | REG | R10-11A.0017 | 24X30 | SUP1 | LIGHT POLE | RETD | 1555670100000 | HARRISON ST | - | - | - | - | - | - |
| 112872 | N/A | Point | - | - | - | - | S101154 | REVERE AVE: LANE ST | - | F | F | - | F | 20499000 | 20499000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LANE ST | LANE ST | 427 | 427 | 37.73166294 | -122.3901644 | REVERE AVE \ LANE ST | REVERE AVE \ LANE ST | 1710539427000 | MTA | STOP | LANE ST intersection | - | 0 / 00 | - | - | - | - | - | 130180 | 1693921980000 | -122.3901644 | 37.73166294 | - | 1597881600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566680000 | REVERE AVE | - | - | - | - | - | - |
| 112873 | N/A | Point | - | - | - | LEFT ARROW | S225237 | FILLMORE ST: SUTTER ST | - | F | F | - | F | 26607000 | 26607000 | - | - | WEST SIDE | - | - | - | - | FILLMORE ST | FILLMORE ST | 65148 | 65148 | 37.78608543 | -122.43327158 | SUTTER ST \ FILLMORE ST | SUTTER ST \ FILLMORE ST | 1754403961000 | middleware_editor | TANSAT | FILLMORE ST intersection | - | 1805 FILLMORE ST | - | - | - | - | - | 130181 | 1636484400000 | -122.43327158 | 37.78608543 | - | 1754331300000 | - | D5 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1462186620000 | SUTTER ST | - | - | - | - | - | - |
| 112874 | N/A | Point | 1 | 1 | 400 - 499 | - | S274503 | 400-499 HARRISON ST | 400-499 HARRISON ST | F | F | - | F | 6711000 | 6711000 | - | - | NORTH SIDE | - | - | - | - | FREMONT ST \ I-80 W OFF RAMP | FREMONT ST \ I-80 W OFF RAMP | 118679 | 118679 | 37.78641651 | -122.39249482 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM MON STCL | FREMONT ST \ I-80 W OFF RAMP to 01ST ST \ I-80 E ON RAMP (400 - 499) | - | 80ft WEST OF FREMONT | - | - | - | - | - | 130182 | - | -122.39249482 | 37.78641651 | - | 1695040200000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0048 | 18X18 | SUP1 | LIGHT POLE | IS | 1620225240000 | HARRISON ST | 400 - 499 HARRISON ST | 400 - 499 HARRISON ST | 400 HARRISON ST | - | 01ST ST \ I-80 E ON RAMP | 01ST ST \ I-80 E ON RAMP |
| 112875 | N/A | Point | - | - | - | - | 23578 | - | - | F | F | - | F | 24465000 | - | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | 1693343612000 | APADILLA | - | - | POLK ST | - | 152508 | 152508 | 37.7817388790369 | -122.418990969758 | ELM ST \ POLK ST | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | - | - | - | - | - | - | - | 10 | 130183 | - | - | - | - | 1693319220000 | - | 05 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | - | ELM ST | - | - | - | - | - | - |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in meters