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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 116701 | N/A | Point | - | - | - | RIGHT ARROW | S287807 | SAN JOSE AVE: BROAD ST \ FARRA | - | F | F | - | F | 11466000 | 21593000 | - | - | EAST SIDE | - | - | - | - | FARALLONES ST \ WHIPPLE AVE | BROAD ST \ SAN JOSE AVE | 103101 | 103101 | 37.7132415651939 | -122.453235747681 | - | FARRAGUT AVE \ BROAD ST \ SAN JOSE AVE | 1738883011000 | middleware_editor | TANSAT | BROAD ST \ SAN JOSE AVE intersection | - | OPP 2776 | - | - | - | - | - | 134032 | - | -122.4534577 | 37.71321239 | - | 1680652800000 | - | D11 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | 1677679020000 | FARRAGUT AVE | 2718 - 2799 SAN JOSE AVE | - | - | - | BROAD ST \ FARRAGUT AVE | - |
| 116702 | N/A | Point | - | - | - | RIGHT ARROW | 21499 | - | - | NO | NO | - | - | - | - | - | SHOULD BE RETIRED | CENTER ISLAND, N LINE, SOUTHBOUND | 1690927613000 | MTA | - | - | 22ND ST | - | 143837 | 143837 | 37.755295 | -122.420964 | VALENCIA ST \ 22ND ST | - | 1743773335000 | jsanfel | BICYCLE (SYM) MAY USE FULL LANE | - | - | MIDDLE OF BIKE LANE | - | - | - | - | - | 134033 | - | -122.420964 | 37.755295 | - | - | - | 09 | - | OTHER REGULATORY | REG | R4-11.0001 | 24X24 | SUP3 | TYPE III BARRICADE | D | - | - | - | - | - | - | - | - |
| 116703 | N/A | Point | - | - | - | - | 21654 | - | - | NO | NO | - | - | - | - | - | SHOULD BE RETIRED | CENTER ISLAND, S LINE, SOUTHBOUND | 1690927613000 | MTA | - | - | 20TH ST | - | 143978 | 143978 | 37.758499 | -122.421272 | VALENCIA ST \ 20TH ST | - | 1722531297000 | middleware_editor | BIKE LANE CLOSED | - | - | MIDDLE OF BIKE LANE | - | - | - | - | - | 134034 | - | -122.421272 | 37.758499 | - | - | - | 09 | - | BIKE REG | REG | R(SF).0490 | 24X24 | SUP3 | TYPE III BARRICADE | D | - | - | - | - | - | - | - | - |
| 116704 | N/A | Point | 1 | 1 | 700 - 799 | - | S207167 | 700-799 24TH ST | 700-799 24TH ST | F | F | - | F | 1321000 | 1321000 | - | - | NORTH SIDE | - | - | - | - | ILLINOIS ST | ILLINOIS ST | 47028 | 47028 | 37.75413997 | -122.38740867 | - | - | 1710539427000 | MTA | NPRK ANY TIME VEH OVER 22' LONG OR 7' HIGH 12AM-6AM EVERYDAY | ILLINOIS ST to 03RD ST (700 - 799) | - | 60' WESTOF ILLINOIS | - | - | - | - | - | 134035 | 1364860800000 | -122.38740867 | 37.75413997 | - | 1536969600000 | - | D10 | - | PARKING:NPRK ANY TIME | REG | R30(SF).0572 | 18X18 | SUP1 | 2IN IRON POST | IS | 1403527020000 | 24TH ST | 700 - 799 24TH ST | 700 - 799 24TH ST | 700 24TH ST | - | 03RD ST | 03RD ST |
| 116705 | N/A | Point | 1 | 1 | 300 - 337 | - | S134181 | 300-337 15TH AVE | 300-337 15TH AVE | F | F | - | F | 607000 | 607000 | - | - | WEST SIDE | - | - | - | - | CLEMENT ST | CLEMENT ST | 24149 | 24149 | 37.78216288 | -122.47408764 | - | - | 1746536989000 | middleware_editor | 2 HR PRK 9AM-6PM MON-FRI EXC "N" PERMITS | CLEMENT ST to TACOMA ST (300 - 337) | - | SPL 339 | - | - | - | - | 1 | 134036 | 1302678000000 | -122.47408764 | 37.78216288 | - | 1746480360000 | - | D1 | - | PARKING:RPP | REG | R32C(CA).0169 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373578260000 | 15TH AVE | 300 - 337 15TH AVE | 300 - 337 15TH AVE | 300 15TH AVE | - | TACOMA ST | TACOMA ST |
| 116706 | N/A | Point | 1 | 1 | 600 - 699 | LEFT ARROW | S120705 | 600-699 MCALLISTER ST | 600-699 MCALLISTER ST | F | F | - | F | 8896000 | 8896000 | - | - | NORTH SIDE | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 18400 | 18400 | 37.77978185 | -122.42271644 | - | - | 1725398945000 | middleware_editor | TANS 3PM-7PM EXC SAT & SUN | FRANKLIN ST to GOUGH ST (600 - 699) | - | 8' E OF GOUGH | - | - | - | - | - | 134037 | 1112572800000 | -122.42271644 | 37.77978185 | - | 1725373620000 | - | D5 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373574060000 | MCALLISTER ST | 600 - 699 MCALLISTER ST | 600 - 699 MCALLISTER ST | 600 MCALLISTER ST | - | GOUGH ST | GOUGH ST |
| 116707 | N/A | Point | - | - | - | - | S102616 | TEHAMA ST: 5TH ST | - | F | F | - | F | 23940000 | 23940000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TEHAMA ST | 05TH ST | 3109 | 3109 | 37.7810766 | -122.40440368 | 5TH ST \ TEHAMA ST | TEHAMA ST \ 05TH ST | 1738002920000 | middleware_editor | STOP | 05TH ST intersection | - | 0 / 0 | - | - | - | - | - | 134038 | -387072000000 | -122.40440368 | 37.7810766 | - | 1737972000000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 3IN IRON POST | IS | 1373568360000 | TEHAMA ST | - | - | - | - | - | - |
| 116708 | N/A | Point | - | - | - | - | S259019 | TEHAMA ST: 5TH ST | - | F | F | - | F | 23940000 | 23940000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TEHAMA ST | 05TH ST | 104527 | 104527 | 37.7810766 | -122.40440368 | 05TH ST \ TEHAMA ST | TEHAMA ST \ 05TH ST | 1737999841000 | middleware_editor | ONE WAY (LA) | 05TH ST intersection | - | 0 / 0 | - | - | - | - | - | 134039 | -387072000000 | -122.40440368 | 37.7810766 | - | 1737970200000 | - | D6 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP1 | 3IN IRON POST | IS | 1573046040000 | TEHAMA ST | - | - | - | - | - | - |
| 116709 | N/A | Point | - | - | - | - | S250183 | TEHAMA ST: 5TH ST | - | F | F | - | F | 12476000 | 23940000 | - | - | NORTH SIDE | - | - | - | - | 05TH ST | 05TH ST | 82674 | 82674 | 37.7810766 | -122.40440368 | - | TEHAMA ST \ 05TH ST | 1715710175000 | middleware_editor | NPRK 12MN-6AM MON FRI STCL | 05TH ST intersection | - | 200' WEST OF 5TH ST. | - | - | - | - | - | 134040 | 1323129600000 | -122.40440368 | 37.7810766 | - | 1715684400000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0047 | 18X18 | SUP1 | 2IN IRON POST | IS | 1544531820000 | TEHAMA ST | 400 - 499 TEHAMA ST | - | - | - | 06TH ST | - |
| 116710 | N/A | Point | - | - | - | - | 25214 | - | - | F | F | - | F | 8048102 | - | - | - | EAST SIDE | 1699379457000 | jsanfel | - | - | STATE DR | - | 167710 | 167710 | 37.7254965680029 | -122.484299067071 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | - | - | (2) INBETWEEN RAISED CURBS | - | - | - | - | 2 | 134041 | 1704724860000 | - | - | - | - | - | 07 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP3 | DELINEATOR BASE SAFE HIT | IS | - | LAKE MERCED BLVD | 700 - 710 LAKE MERCED BLVD | - | - | - | STATE DR | - |
| 116711 | N/A | Point | - | - | - | - | 25268 | - | - | F | F | - | F | 8048102 | - | - | - | EAST SIDE | 1699540804000 | jsanfel | - | - | STATE DR | - | 168322 | 168322 | 37.7256821986551 | -122.484222623746 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | - | - | 2 BETWEEN RAISED CURBS | - | - | - | - | 2 | 134042 | 1705051320000 | - | - | - | - | - | 07 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP3 | DELINEATOR BASE SAFE HIT | IS | - | LAKE MERCED BLVD | 700 - 710 LAKE MERCED BLVD | - | - | - | STATE DR | - |
| 116712 | N/A | Point | - | - | - | - | 25269 | - | - | F | F | - | F | 8048102 | - | - | - | EAST SIDE | 1699540836000 | jsanfel | - | - | STATE DR | - | 168338 | 168338 | 37.7258487355474 | -122.484152886311 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | - | - | 2 BETWEEN RAISED CURBS | - | - | - | - | 2 | 134043 | 1705055040000 | - | - | - | - | - | 07 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP3 | DELINEATOR BASE SAFE HIT | IS | - | LAKE MERCED BLVD | 700 - 710 LAKE MERCED BLVD | - | - | - | STATE DR | - |
| 116713 | N/A | Point | - | - | - | - | S214606 | MISSION ST: SANTA ROSA AVE | - | T | T | - | F | 9161000 | 21773000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | EXCELSIOR AVE | MISSION ST | 114643 | 114643 | 37.72576179 | -122.43398236 | - | SANTA ROSA AVE \ MISSION ST | 1710539427000 | MTA | SANTA ROSA AVE | MISSION ST intersection | - | IFO# 4492 MISSION ST. | - | - | - | - | - | 134044 | 1465293960000 | -122.43398236 | 37.72576179 | - | 1465257600000 | - | D11 | - | STREET NAME | GUIDE | D3-2.0309 | 72X18 | SUP2 | LIGHT POLE | IS | 1427373480000 | SANTA ROSA AVE | 4466 - 4529 MISSION ST | - | - | - | SANTA ROSA AVE | - |
| 116714 | N/A | Point | - | - | - | - | S131673 | MISSION ST: SANTA ROSA AVE | - | F | F | - | F | 21773000 | 21773000 | - | - | SOUTH WEST CORNER | - | - | - | - | SANTA ROSA AVE | MISSION ST | 21807 | 21807 | 37.72576179 | -122.43398236 | MISSION ST \ SANTA ROSA AVE | SANTA ROSA AVE \ MISSION ST | 1710539427000 | MTA | MISSION ST | MISSION ST intersection | - | - | - | - | - | - | - | 134045 | 1257724800000 | -122.43398236 | 37.72576179 | - | - | - | D11 | - | STREET NAME | GUIDE | D3-1.1207 | 36X08 | SUP2 | SIGNAL POLE | IS | 1373577420000 | SANTA ROSA AVE | - | - | - | - | - | - |
| 116715 | N/A | Point | - | - | - | - | S223237 | LYON ST: GEARY BLVD | - | F | F | - | F | 26829000 | 26829000 | - | - | NORTH WEST CORNER | - | - | - | - | LYON ST | GEARY BLVD | 60676 | 60676 | 37.78277467 | -122.44445802 | GEARY BLVD \ LYON ST | LYON ST \ GEARY BLVD | 1710539427000 | MTA | NO PED XING-USE CROSSWALK | GEARY BLVD intersection | - | - | - | - | - | - | - | 134046 | 1455111120000 | -122.44445802 | 37.78277467 | - | 1705582500000 | - | D2 | - | PEDESTRIAN | REG | R49(CA).0002 | 36X18 | SUP1 | 2 POST ALUMINUM | IS | 1454942040000 | LYON ST | - | - | - | - | - | - |
| 116716 | N/A | Point | - | - | - | - | S220969 | LYON ST: GEARY BLVD | - | F | F | - | F | 26829000 | 26829000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LYON ST | GEARY BLVD | 59114 | 59114 | 37.78277467 | -122.44445802 | GEARY BLVD \ LYON ST | LYON ST \ GEARY BLVD | 1710539427000 | MTA | STOP | GEARY BLVD intersection | - | - | - | - | - | - | - | 134047 | - | -122.44445802 | 37.78277467 | - | - | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1448878800000 | LYON ST | - | - | - | - | - | - |
| 116717 | N/A | Point | 1 | 1 | 11 - 99 | - | S222285 | 11-99 BATTERY ST | 11-99 BATTERY ST | F | F | - | F | 2752000 | 2752000 | - | - | WEST SIDE | - | - | - | - | BUSH ST | BUSH ST | 64935 | 64935 | 37.79179224 | -122.39966769 | - | - | 1710539427000 | MTA | TANS 7AM-9AM/3PM-7PM EXC SAT & SUN | BUSH ST to PINE ST (11 - 99) | - | 10' N OF BUSH | - | - | - | - | - | 134048 | - | -122.39966769 | 37.79179224 | - | - | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0071 | 18X21 | SUP1 | LIGHT POLE | IS | 1453203240000 | BATTERY ST | 11 - 99 BATTERY ST | 11 - 99 BATTERY ST | 11 BATTERY ST | - | PINE ST | PINE ST |
| 116718 | N/A | Point | 1 | 1 | 1 - 10 | - | S212012 | 1-10 BATTERY ST | 1-10 BATTERY ST | F | F | - | F | 2751000 | 2751000 | - | - | EAST SIDE | - | - | - | - | MARKET ST | MARKET ST | 53027 | 53027 | 37.79106576 | -122.39955268 | - | - | 1710539427000 | MTA | BIKE RACK | MARKET ST to BUSH ST (1 - 10) | - | 27'N OF MARKET | - | - | - | - | - | 134049 | - | -122.39955268 | 37.79106576 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1419253080000 | BATTERY ST | 1 - 10 BATTERY ST | 1 - 10 BATTERY ST | 1 BATTERY ST | - | BUSH ST | BUSH ST |
| 116719 | N/A | Point | - | - | - | - | S267991 | BROTHERHOOD WAY: CHUMASERO DR | - | F | F | - | F | 22554000 | 22554000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | CHUMASERO DR \ THOMAS MORE WAY | CHUMASERO DR \ THOMAS MORE WAY | 92352 | 92352 | 37.71292738 | -122.47273721 | BROTHERHOOD WAY \ CHUMASERO DR \ THOMAS MORE WAY | BROTHERHOOD WAY \ CHUMASERO DR \ THOMAS MORE WAY | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 25/WHEN CHILDREN ARE PRESENT | CHUMASERO DR \ THOMAS MORE WAY intersection | - | 130 FT WEST OF CHUMASERO | - | - | - | - | - | 134050 | 1425427200000 | -122.47273721 | 37.71292738 | - | 1599696000000 | 1693479600000 | D7 | - | OTHER REGULATORY | REG | SR4-1(CA).0002 | 24X48 | SUP2 | LIGHT POLE | RETD | 1599652380000 | BROTHERHOOD WAY | - | - | - | - | - | - |
| 116720 | N/A | Point | - | - | - | - | 22951 | - | - | - | - | - | - | 27193000 | - | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1692299677000 | evillan | - | - | LINCOLN WAY | - | 148235 | 148235 | 37.7661465432127 | -122.460005804189 | 03RD AVE \ LINCOLN WAY | - | 1710539427000 | MTA | (45 LA-DN) | - | - | CENTER ISLAND IN INTERSECTION | - | - | - | - | - | 134051 | 1694689200000 | - | - | - | - | - | 07 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP3 | 2IN BREAK-AWAY SYSTEM | IS | - | 03RD AVE | - | - | - | - | - | - |
| 116721 | N/A | Point | - | - | - | - | 22186 | - | - | - | - | - | - | 3241101 | - | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | 1692206648000 | evillan | - | - | CHUMASERO DR \ THOMAS MORE WAY | - | 146886 | 146886 | 37.7129628286556 | -122.473194343046 | - | - | 1710539427000 | MTA | SENIOR ZONE | - | - | 285 FT WEST OF CHUMASERO | - | - | - | - | - | 134052 | 1693408380000 | - | - | - | - | - | 07 | - | OTHER WARNING | WARNING | SW50(CA).0001 | 24X18 | SUP3 | 2IN IRON POST | IS | - | BROTHERHOOD WAY | 751 - 799 BROTHERHOOD WAY | - | - | - | CHURCH ACCESS RD | - |
| 116722 | N/A | Point | - | - | - | - | 22180 | - | - | F | T | - | F | 3243201 | - | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1692204441000 | evillan | - | - | CHURCH ACCESS RD | - | 146865 | 146865 | 37.7146701956804 | -122.482167226504 | - | - | 1710539427000 | MTA | SPEED LIMIT 45 | - | - | 335 FT EAST OF LAKE MERCED | - | - | - | - | - | 134053 | 1693406100000 | - | - | - | - | - | 07 | - | SPEED LIMIT | REG | R2-1.0014 | 36X45 | SUP3 | LIGHT POLE | IS | - | - | 900 - 998 BROTHERHOOD WAY | - | - | - | LAKE MERCED BLVD | - |
| 116723 | N/A | Point | - | - | - | - | 22182 | - | - | - | T | - | F | 3243201 | - | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1692205232000 | evillan | - | - | CHURCH ACCESS RD | - | 146853 | 146853 | 37.7145283881634 | -122.4801466291 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 25/WHEN CHILDREN ARE PRESENT | - | - | 100 FT EAST OF CHURCH ACEESS PARKING LOT | - | - | - | - | - | 134054 | 1693322220000 | - | - | - | - | - | 07 | - | OTHER REGULATORY | REG | SR4-1(CA).0002 | 24X48 | SUP3 | LIGHT POLE | IS | - | CHURCH ACCESS RD | 900 - 998 BROTHERHOOD WAY | - | - | - | LAKE MERCED BLVD | - |
| 116724 | N/A | Point | - | - | - | - | 22952 | - | - | F | F | - | F | - | - | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | 1692299892000 | evillan | - | - | - | - | 148236 | 148236 | 37.7663882606497 | -122.459742947706 | - | - | 1710539427000 | MTA | STOP | - | - | - | - | - | - | - | - | 134055 | - | - | - | - | - | 1694683800000 | 07 | - | STOP | REG | R1-1.0002 | 30X30 | SUP3 | 2IN IRON POST | RETD | - | LINCOLN WAY | - | - | - | - | - | - |
| 116725 | N/A | Point | - | - | - | - | 22982 | - | - | - | - | - | - | - | - | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1692302101000 | evillan | - | - | - | - | 148387 | 148387 | 37.7662737630148 | -122.459767087587 | - | - | 1710539427000 | MTA | BICYCLE (SYM) | - | - | 30 FT SOUTH OF KEZAR BIKE (SYM( | - | - | - | - | - | 134056 | - | - | - | - | - | 1696258800000 | 07 | - | OTHER WARNING | WARNING | W11-1.0001 | 30X30 | SUP3 | LIGHT POLE | RETD | - | - | - | - | - | - | - | - |
| 116726 | N/A | Point | - | - | - | - | 22983 | - | - | - | - | - | - | 8342201 | - | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1692304117000 | evillan | - | - | 02ND AVE | - | 149425 | 149425 | 37.7662765902379 | -122.459734006409 | - | - | 1710539427000 | MTA | AHEAD | - | - | 30 fFT SOUTH OF KEZAR | - | - | - | - | - | 134057 | - | - | - | - | - | 1695049200000 | 07 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP3 | LIGHT POLE | RETD | - | LINCOLN WAY | 100 - 198 LINCOLN WAY | - | - | - | 03RD AVE \ KEZAR DR | - |
| 116727 | N/A | Point | - | - | - | - | 22110 | - | - | F | F | - | F | 9489000 | - | - | - | - | 1691678591000 | MMENDIET | - | - | AVALON AVE | - | 145857 | 145857 | 37.7245399524222 | -122.428513515899 | - | - | 1750285449000 | middleware_editor | NPRK 10AM-12NN MON STCL | - | - | - | - | - | - | - | - | 134058 | - | - | - | - | 1750279200000 | - | 11 | - | STREET CLEANING | REG | R30B(CA).0011 | 18X18 | SUP3 | - | IS | - | NAPLES ST | 200 - 299 NAPLES ST | - | - | - | EXCELSIOR AVE | - |
| 116728 | N/A | Point | - | - | - | - | 22238 | - | - | F | T | - | F | 33560000 | - | - | - | - | 1692292765000 | evillan | - | - | 03RD AVE \ KEZAR DR | - | 147862 | 147862 | 37.7664773142431 | -122.459953054024 | LINCOLN WAY \ 03RD AVE \ KEZAR DR | - | 1719538353000 | middleware_editor | PEDESTRIAN (SYM) | - | - | NWC ON KEZAR AND LINCOLN | - | - | - | - | - | 134059 | 1694598300000 | - | - | - | - | - | 07 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP3 | LIGHT POLE | IS | - | - | - | - | - | - | - | - |
| 116729 | N/A | Point | - | - | - | - | 22245 | - | - | F | F | - | F | 33560000 | - | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1692293035000 | evillan | - | - | 03RD AVE \ KEZAR DR | - | 147865 | 147865 | 37.7664179451927 | -122.459861858918 | LINCOLN WAY \ 03RD AVE \ KEZAR DR | - | 1710539427000 | MTA | PEDESTRIAN (SYM) | - | - | CENTER ISLAND UNDER SIGNAL LIGHT | - | - | - | - | - | 134060 | 1694601000000 | - | - | - | - | 1694691900000 | 07 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP3 | SIGNAL POLE | IS | - | LINCOLN WAY | - | - | - | - | - | - |
| 116730 | N/A | Point | 1 | 1 | 600 - 699 | - | S263356 | 600-699 ELIZABETH ST | 600-699 ELIZABETH ST | F | F | - | F | 5148000 | 5148000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | CASTRO ST | CASTRO ST | 113676 | 113676 | 37.75202622 | -122.43526983 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | CASTRO ST to DIAMOND ST (600 - 699) | 179783 | EPL 606 | - | - | - | - | - | 134061 | 1094601600000 | -122.43526983 | 37.75202622 | - | 1633046400000 | - | D8 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1587031080000 | ELIZABETH ST | 600 - 699 ELIZABETH ST | 600 - 699 ELIZABETH ST | 600 ELIZABETH ST | - | DIAMOND ST | DIAMOND ST |
| 116731 | N/A | Point | - | - | - | - | S261356 | MIGUEL ST: CHENERY ST \ WHITNE | - | F | F | - | F | 21869000 | 21869000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CHENERY ST \ MIGUEL ST | CHENERY ST \ WHITNEY ST | 110850 | 110850 | 37.73721374 | -122.42770735 | WHITNEY ST \ CHENERY ST \ MIGUEL ST | MIGUEL ST \ CHENERY ST \ WHITNEY ST | 1710539427000 | MTA | ALL WAY | CHENERY ST \ WHITNEY ST intersection | - | CHENERY IS CROS STREET | - | - | - | - | - | 134062 | 1222646400000 | -122.42770735 | 37.73721374 | - | 1582588800000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1581501840000 | MIGUEL ST | - | - | - | - | - | - |
| 116732 | N/A | Point | 1 | 1 | 300 - 337 | - | S134179 | 300-337 15TH AVE | 300-337 15TH AVE | F | F | - | F | 607000 | 607000 | - | - | WEST SIDE | - | - | - | - | CLEMENT ST | CLEMENT ST | 79072 | 79072 | 37.78216288 | -122.47408764 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-6PM MON-FRI EXC "N" PERMITS | CLEMENT ST to TACOMA ST (300 - 337) | - | IFO# 379 AT PAINT MARK | - | - | - | - | - | 134063 | 1302652800000 | -122.47408764 | 37.78216288 | - | - | - | D1 | - | PARKING:RPP | REG | R32C(CA).0169 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373578260000 | 15TH AVE | 300 - 337 15TH AVE | 300 - 337 15TH AVE | 300 15TH AVE | - | TACOMA ST | TACOMA ST |
| 116733 | N/A | Point | 1 | 1 | 300 - 337 | - | S119566 | 300-337 15TH AVE | 300-337 15TH AVE | F | F | - | F | 607000 | 607000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 16955 | 16955 | 37.78216288 | -122.47408764 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | CLEMENT ST to TACOMA ST (300 - 337) | - | IFO#346 | - | - | - | - | - | 134064 | 1097625600000 | -122.47408764 | 37.78216288 | - | 1624406400000 | - | D1 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1373573700000 | 15TH AVE | 300 - 337 15TH AVE | 300 - 337 15TH AVE | 300 15TH AVE | - | TACOMA ST | TACOMA ST |
| 116734 | N/A | Point | 1 | 1 | 300 - 337 | - | S134192 | 300-337 15TH AVE | 300-337 15TH AVE | F | F | - | F | 607000 | 607000 | - | - | EAST SIDE | - | - | - | - | CLEMENT ST | CLEMENT ST | 24212 | 24212 | 37.78216288 | -122.47408764 | - | - | 1746537015000 | middleware_editor | 2 HR PRK 9AM-6PM MON-FRI EXC "N" PERMITS | CLEMENT ST to TACOMA ST (300 - 337) | - | NPL# 334 | - | - | - | - | - | 134065 | 1302764400000 | -122.47408764 | 37.78216288 | - | 1746481560000 | - | D1 | - | PARKING:RPP | REG | R32C(CA).0169 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373578260000 | 15TH AVE | 300 - 337 15TH AVE | 300 - 337 15TH AVE | 300 15TH AVE | - | TACOMA ST | TACOMA ST |
| 116735 | N/A | Point | 1 | 1 | 300 - 337 | - | S139964 | 300-337 15TH AVE | 300-337 15TH AVE | F | F | - | F | 607000 | 607000 | - | - | EAST SIDE | - | - | - | - | CLEMENT ST | CLEMENT ST | 32638 | 32638 | 37.78216288 | -122.47408764 | - | - | 1746647514000 | middleware_editor | NPRK 8AM-10AM 2ND & 4TH TUE OF MONTH STCL | CLEMENT ST to TACOMA ST (300 - 337) | - | 334 15TH AVE | - | - | - | - | - | 134066 | 1221202800000 | -122.47408764 | 37.78216288 | - | 1746642960000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0257 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375724820000 | 15TH AVE | 300 - 337 15TH AVE | 300 - 337 15TH AVE | 300 15TH AVE | - | TACOMA ST | TACOMA ST |
| 116736 | N/A | Point | - | - | - | - | S115423 | OAKDALE AVE: LOOMIS ST | - | F | F | - | F | 20813000 | 20813000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OAKDALE AVE | LOOMIS ST | 11092 | 11092 | 37.74252073 | -122.40430629 | LOOMIS ST \ OAKDALE AVE | OAKDALE AVE \ LOOMIS ST | 1744121964000 | middleware_editor | ALL WAY | LOOMIS ST intersection | - | 15W / BELOW EXISTING STOP SIGN (SEE..... | - | - | - | - | - | 134067 | 1030518000000 | -122.40430629 | 37.74252073 | - | 1706894400000 | 1733331600000 | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | UTILITY POLE | RETD | 1373572380000 | OAKDALE AVE | - | - | - | - | - | - |
| 116737 | N/A | Point | - | - | - | - | 25110 | - | - | - | - | - | - | 24678000 | - | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | 1699022753000 | smuneno | - | - | MONTGOMERY ST | - | 167057 | 167057 | 37.7899562374962 | -122.402257025237 | SUTTER ST \ MONTGOMERY ST | - | 1722531702000 | middleware_editor | DETOUR (RA) | - | - | MONTGOMERY @ SUTTER, SOUTH SIDE OF S-LINE, X-WALK | - | - | - | - | - | 134068 | - | - | - | - | - | - | 03 | - | OTHER GUIDE | GUIDE | M4-10.0001 | 48X16 | SUP1 | TYPE III BARRICADE | IS | - | SUTTER ST | - | - | - | - | - | - |
| 116738 | N/A | Point | - | - | - | - | 25219 | - | - | F | T | - | F | 8048101 | - | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1699380016000 | jsanfel | - | - | WINSTON DR | - | 167777 | 167777 | 37.7267811233608 | -122.483786094556 | - | - | 1722531702000 | middleware_editor | (RA) TURNING VEHICLES YIELD (SYM) TO PED & BIKE (SYM) | - | - | NE CORNER | - | - | - | - | - | 134070 | - | - | - | - | - | - | 07 | - | PEDESTRIAN | REG | R10-15.0003 | 30X30 | SUP3 | LIGHT POLE | IS | - | LAKE MERCED BLVD | 650 - 698 LAKE MERCED BLVD | - | - | - | STATE DR | - |
| 116739 | N/A | Point | - | - | - | - | S220216 | SANTA ROSA AVE: MISSION ST | - | F | F | - | F | 21773000 | 21773000 | - | - | SOUTH WEST CORNER | - | - | - | - | SANTA ROSA AVE | MISSION ST | 60601 | 60601 | 37.72576179 | -122.43398236 | MISSION ST \ SANTA ROSA AVE | SANTA ROSA AVE \ MISSION ST | 1732666788000 | middleware_editor | FG 300 UR DELINEATOR (W) | MISSION ST intersection | - | SOUTH OF CROSSWALK ON 6" WHITE LINE | - | - | - | - | - | 134071 | 1474295400000 | -122.43398236 | 37.72576179 | - | 1732545000000 | - | D11 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1445511060000 | SANTA ROSA AVE | - | - | - | - | - | - |
| 116740 | N/A | Point | - | - | - | - | S264831 | SANTA ROSA AVE: MISSION ST | - | F | F | - | F | 9162000 | 21773000 | - | - | EAST SIDE | - | - | - | - | SANTA ROSA AVE | MISSION ST | 98930 | 98930 | 37.72576179 | -122.43398236 | - | SANTA ROSA AVE \ MISSION ST | 1755205845000 | middleware_editor | FG 300 UR DELINEATOR (W) | MISSION ST intersection | - | OF INTERSECTION IFO 4527 / KHAKE | - | - | - | - | - | 134072 | 1474268400000 | -122.43398236 | 37.72576179 | - | 1755189900000 | - | D11 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1591084560000 | SANTA ROSA AVE | 4500 - 4569 MISSION ST | - | - | - | HARRINGTON ST | - |
| 116741 | N/A | Point | - | - | - | - | S276471 | CLAY ST: CHERRY ST | - | F | F | - | F | 4125000 | 27571000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MAPLE ST | CHERRY ST | 124228 | 124228 | 37.78780934 | -122.45705805 | - | CLAY ST \ CHERRY ST | 1712179517000 | middleware_editor | FG 300 UR DELINEATOR (W) | CHERRY ST intersection | - | 15 ' 9 FROM CURB | - | - | - | - | - | 134073 | 1583884800000 | -122.45705805 | 37.78780934 | - | 1628640000000 | 1712067480000 | D2 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | RETD | 1627299000000 | CLAY ST | 3800 - 3899 CLAY ST | - | - | - | CHERRY ST | - |
| 116742 | N/A | Point | - | - | - | - | S106162 | LAGUNA ST: GREEN ST | - | F | F | - | F | 26580000 | 26580000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GREEN ST | GREEN ST | 2438 | 2438 | 37.79678326 | -122.43037057 | LAGUNA ST \ GREEN ST | LAGUNA ST \ GREEN ST | 1710539427000 | MTA | STOP | GREEN ST intersection | - | - | - | - | - | - | - | 134074 | 125193600000 | -122.43037057 | 37.79678326 | - | 1702640460000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569440000 | LAGUNA ST | - | - | - | - | - | - |
| 116743 | N/A | Point | 1 | 1 | 11 - 99 | - | S286034 | 11-99 BATTERY ST | 11-99 BATTERY ST | F | F | - | F | 2752000 | 2752000 | - | - | EAST SIDE | - | - | - | - | BUSH ST | BUSH ST | 100176 | 100176 | 37.79179224 | -122.39966769 | - | - | 1710539427000 | MTA | TANSAT | BUSH ST to PINE ST (11 - 99) | - | SPL #98 BATTERY | - | - | - | - | - | 134075 | 1671408000000 | -122.39966769 | 37.79179224 | - | - | - | D3 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1668758700000 | BATTERY ST | 11 - 99 BATTERY ST | 11 - 99 BATTERY ST | 11 BATTERY ST | - | PINE ST | PINE ST |
| 116744 | N/A | Point | - | - | - | - | 23812 | 400 - 499 29TH AVE | - | F | F | - | F | - | - | - | - | WEST SIDE | 1703198998000 | middleware_editor | - | - | CLEMENT ST | - | 154306 | 154306 | 37.781626 | -122.489222 | - | - | 1710539427000 | MTA | VEH MUST FIT WITHIN STALL MARKINGS | - | - | 35 FT SOUTH OF CLEMENT | - | - | - | - | 1 | 135457 | - | - | - | - | - | - | 01 | - | OTHER REGULATORY | REG | R32C(SF).0046 | 18X21 | SUP2 | 2IN IRON POST | PI | - | 400 - 499 29TH AVE | 400 - 499 29TH AVE | - | - | - | GEARY BLVD | - |
| 116745 | N/A | Point | - | - | - | RIGHT ARROW | 23835 | 400 - 499 29TH AVE | - | F | F | - | F | - | - | - | - | WEST SIDE | 1703199305000 | middleware_editor | - | - | CLEMENT ST | - | 154449 | 154449 | 37.78102 | -122.489176 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | - | 262 FT SOUTH OF CLEMENT OPP 442 | - | - | - | - | 1 | 135458 | - | - | - | - | - | 1703774880000 | 01 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | 2IN IRON POST | RETD | - | 400 - 499 29TH AVE | 400 - 499 29TH AVE | - | - | - | GEARY BLVD | - |
| 116746 | N/A | Point | - | - | - | - | 25699 | 300 - 399 09TH AVE | - | F | F | - | F | - | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1703199305000 | middleware_editor | - | - | CLEMENT ST | - | 173169 | 173169 | 37.781903 | -122.467502 | - | - | 1747255565000 | middleware_editor | TA (SYM) PLO 8AM- 9:30AM AND 1PM-6PM MON- FRI / 8:30AM-12:30PM SUNDAY 5 MIN | - | - | 40' SOUTH FROM NPL 350 | - | - | - | - | 1 | 135459 | - | - | - | - | - | - | 01 | - | TOW (TANP ANY TIME) | REG | R38(SF)6.0122 | 14X21 | SUP2 | 2IN IRON POST | IS | - | 300 - 399 09TH AVE | 300 - 399 09TH AVE | - | - | - | GEARY BLVD | - |
| 116747 | N/A | Point | - | - | - | DOUBLE ARROW | 25850 | 300 - 399 STEINER ST | - | F | F | - | F | - | - | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | 1703199305000 | middleware_editor | - | - | HAIGHT ST | - | 175090 | 175090 | 37.772745 | -122.432203 | - | - | 1710539427000 | MTA | PAGE SLOW ST FAMILY,H/C,PED,SKATEBOARD,BIKE (SYM) (COMBO) | - | - | SE CORNER ABOVE STOP SIGN | - | - | - | - | 1 | 135460 | - | - | - | - | - | - | 05 | - | OTHER REGULATORY | REG | R(SF).0515 | 24X30 | SUP2 | 2IN IRON POST | PI | - | 300 - 399 STEINER ST | 300 - 399 STEINER ST | - | - | - | PAGE ST | - |
| 116748 | N/A | Point | - | - | - | - | S201375 | 1100 - 1199 VALENCIA ST | - | F | F | - | F | - | - | - | - | EAST SIDE | 1703199305000 | middleware_editor | - | - | 22ND ST | - | 44909 | 44909 | 37.75384 | -122.420738 | - | - | 1743803926000 | middleware_editor | BIKE CORRAL (SEE NOTES FOR CONFIGURATION) | - | - | IFO #1199 /15FT.NORTH OF 23ED ST | - | - | - | - | 1 | 135461 | 1388084760000 | - | - | - | 1388044800000 | - | D8 | - | BIKE | MISC | BIKE-CORRAL | N/A | SUP2 | 2IN IRON POST | IS | - | 1100 - 1199 VALENCIA ST | 1100 - 1199 VALENCIA ST | - | - | - | 23RD ST | - |
| 116749 | N/A | Point | - | - | - | - | S225250 | 100-199 POPE ST | - | F | F | - | F | - | - | - | - | EAST SIDE, EASTBOUND TRAFFIC | 1703199305000 | middleware_editor | - | - | CROSS ST | - | 63416 | 63416 | 37.713289 | -122.44088 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | - | - | OPP.C-LINE | - | - | - | - | 1 | 135462 | 274579200000 | - | - | - | - | - | D11 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP2 | 2IN IRON POST | IS | - | 100-199 POPE ST | 100-199 POPE ST | - | - | - | MORSE ST | - |
| 116750 | N/A | Point | - | - | - | - | S203955 | 800-919 WISCONSIN ST | - | F | F | - | F | - | - | - | - | EAST SIDE | 1703199305000 | middleware_editor | - | - | 22ND ST | - | 47537 | 47537 | 37.756571 | -122.398869 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | - | - | OPP CENTER LINE OF 22ND ST | - | - | - | - | 1 | 135463 | 1414505400000 | - | - | - | 1414454400000 | - | D10 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP1 | 2IN IRON POST | IS | - | 800-919 WISCONSIN ST | 800-919 WISCONSIN ST | - | - | - | MADERA ST | - |
| 116751 | N/A | Point | - | - | - | - | S257539 | PENDING QUESADA AVE | - | F | F | - | F | - | - | - | - | SOUTH SIDE | 1703199305000 | middleware_editor | - | - | - | - | 140766 | 140766 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | OBJECT MARKER - RED | - | - | AT DEAD END UNDER TUESDAY STREET CLEANIN | - | - | - | - | 1 | 135464 | - | - | - | - | - | - | - | - | OTHER WARNING | WARNING | TYPE-N(CA).0001 | 24X24 | - | 2IN IRON POST | IS | - | PENDING QUESADA AVE | PENDING QUESADA AVE | - | - | - | - | - |
| 116752 | N/A | Point | - | - | - | - | S238960 | PENDING SAINT GERMAIN AVE | - | F | F | - | F | - | - | - | - | WEST SIDE | 1703199305000 | middleware_editor | - | - | - | - | 134340 | 134340 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | OBJECT MARKER - RED | - | - | W/B CUL DE SAC OFF GLENBROOK | - | - | - | - | 1 | 135465 | - | - | - | - | - | - | - | - | OTHER WARNING | WARNING | TYPE-N(CA).0001 | 24X24 | - | 2IN IRON POST | IS | - | PENDING SAINT GERMAIN AVE | PENDING SAINT GERMAIN AVE | - | - | - | - | - |
| 116753 | N/A | Point | - | - | - | - | S218706 | MISSION ST: NEW MONTGOMERY ST | - | F | F | - | F | - | - | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | 1703199305000 | middleware_editor | - | - | NEW MONTGOMERY ST | - | 55291 | 55291 | 37.787451 | -122.400503 | MISSION ST: NEW MONTGOMERY ST | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | - | - | - | - | - | - | 1 | 135466 | - | - | - | - | - | - | D6 | - | OTHER MISC | MISC | PROVISIONAL CODE | N/A | SUP1 | LIGHT POLE | IS | - | MISSION ST: NEW MONTGOMERY ST | - | - | - | - | - | - |
| 116754 | N/A | Point | - | - | - | - | S221963 | 24TH AVE: PACHECO ST | - | F | F | - | F | - | - | - | - | WEST SIDE, WESTBOUND TRAFFIC | 1703199472000 | middleware_editor | - | - | 24TH AVE | - | 77162 | 77162 | 37.750274 | -122.48157 | 24TH AVE: PACHECO ST | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | - | - | OPP.C-LINE (W/B/T) | - | - | - | - | 1 | 135467 | 1566216000000 | - | - | - | - | - | D4 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP2 | 2IN IRON POST | IS | - | 24TH AVE: PACHECO ST | - | - | - | - | - | - |
| 116755 | N/A | Point | - | - | - | - | S222366 | 24TH AVE: PACHECO ST | - | F | F | - | F | - | - | - | - | NORTH SIDE, NORTHBOUND TRAFFIC | 1703199472000 | middleware_editor | - | - | 24TH AVE | - | 117088 | 117088 | 37.750274 | -122.48157 | 24TH AVE: PACHECO ST | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | - | - | OPP.C-LINE | - | - | - | - | 1 | 135468 | 1455710520000 | - | - | - | 1455667200000 | - | D4 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP2 | 2IN IRON POST | IS | - | 24TH AVE: PACHECO ST | - | - | - | - | - | - |
| 116756 | N/A | Point | - | - | - | - | S283364 | YERBA BUENA AVE: MIRALOMA DR \ | - | F | F | - | F | - | - | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1703199472000 | middleware_editor | - | - | MIRALOMA DR \ RAVENWOOD DR | - | 106844 | 106844 | 37.73518 | -122.460477 | YERBA BUENA AVE: MIRALOMA DR \ | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | - | - | - | - | - | - | - | 1 | 135469 | 1654819200000 | - | - | - | - | - | D7 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP2 | 2IN IRON POST | IS | - | YERBA BUENA AVE: MIRALOMA DR \ | - | - | - | - | - | - |
| 116757 | N/A | Point | - | - | - | - | S129568 | 1900-1999 20TH AVE | - | F | F | - | F | - | - | - | - | EAST SIDE | 1703199472000 | middleware_editor | - | - | ORTEGA ST | - | 22857 | 22857 | 37.751396 | -122.477349 | - | - | 1740091419000 | middleware_editor | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | R26K(SF).0101 | IFO#1932 (PLUS LA) | - | - | - | - | 1 | 135470 | 1219881600000 | - | - | - | - | - | D4 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | 2IN IRON POST | IS | - | 1900-1999 20TH AVE | 1900-1999 20TH AVE | - | - | - | PACHECO ST | - |
| 116758 | N/A | Point | - | - | - | - | S244107 | 1000-1099 PAGE ST | - | F | F | - | F | - | - | - | - | NORTH SIDE | 1703199472000 | middleware_editor | - | - | DIVISADERO ST | - | 85378 | 85378 | 37.772097 | -122.438067 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | 4958 -- R(SF).0001 | 9' WEST OF DIVISADERO/ 3' IN FROM CURB | - | - | - | - | 1 | 135471 | 1522713600000 | - | - | - | 1522713600000 | - | D5 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP1 | BIKE RACK | IS | - | 1000-1099 PAGE ST | 1000-1099 PAGE ST | - | - | - | BRODERICK ST | - |
| 116759 | N/A | Point | - | - | - | - | S250636 | 100-128 7TH ST | - | F | F | - | F | - | - | - | - | WEST SIDE | 1703199472000 | middleware_editor | - | - | MISSION ST | - | 79093 | 79093 | 37.778999 | -122.410669 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | 31880 -- R(SF).0001 | 12' N OF SPL#270/2.5' IN FROM CURB | - | - | - | - | 1 | 135472 | 1547476500000 | - | - | - | - | - | D6 | - | OTHER REGULATORY | REG | PROVISIONAL CODE | N/A | SUP1 | BIKE RACK | IS | - | 100-128 7TH ST | 100-128 7TH ST | - | - | - | MINNA ST | - |
| 116760 | N/A | Point | - | - | - | - | S288020 | 1100-1130 POLK ST | - | F | F | - | F | - | - | - | - | WEST SIDE | 1703199472000 | middleware_editor | - | - | POST ST | - | 101396 | 101396 | 37.787054 | -122.419974 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | 688835 -- R(SF).0001 | 27' N OF SPL 1101/3.5' IN FROM CURB | - | - | - | - | 1 | 135473 | - | - | - | - | - | - | D3 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP1 | BIKE RACK | IS | - | 1100-1130 POLK ST | 1100-1130 POLK ST | - | - | - | HEMLOCK ST | - |
| 116761 | N/A | Point | - | - | - | - | S221919 | 1100-1199 GEARY BLVD | - | F | F | - | F | - | - | - | - | SOUTH SIDE | 1703199472000 | middleware_editor | - | - | GEARY ST \ VAN NESS AVE | - | 60802 | 60802 | 37.785584 | -122.42221 | - | - | 1726847286000 | middleware_editor | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | R38(SF)1.0050 | IFO #1117 | - | - | - | - | 1 | 135474 | - | - | - | - | - | - | D5 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP1 | 2IN IRON POST | IS | - | 1100-1199 GEARY BLVD | 1100-1199 GEARY BLVD | - | - | - | FRANKLIN ST | - |
| 116762 | N/A | Point | - | - | - | - | S239182 | 1-99 BRODERICK ST | - | F | F | - | F | - | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1703199472000 | middleware_editor | - | - | WALLER ST | - | 73645 | 73645 | 37.770591 | -122.438613 | - | - | 1720635447000 | middleware_editor | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | W1-1A.0001 | SPL#3 | - | - | - | - | 1 | 135475 | 1506598140000 | - | - | - | 1506556800000 | - | D5 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP1 | 2IN IRON POST | IS | - | 1-99 BRODERICK ST | 1-99 BRODERICK ST | - | - | - | HAIGHT ST | - |
| 116763 | N/A | Point | - | - | - | LEFT ARROW | S221020 | 600-699 BRANNAN ST | - | F | F | - | F | - | - | - | - | SOUTH SIDE | 1703199472000 | middleware_editor | - | - | 5TH ST | - | 115384 | 115384 | 37.775689 | -122.399869 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | R38(SF)1.0047 | 40' EAST OF WPL OF #651 | - | - | - | - | 1 | 135476 | 1451470020000 | - | - | - | 1451433600000 | - | D6 | - | OTHER REGULATORY | REG | PROVISIONAL CODE | N/A | SUP1 | 2IN IRON POST | IS | - | 600-699 BRANNAN ST | 600-699 BRANNAN ST | - | - | - | 06TH ST \ I-280 NORTHBOUND \ I-280 SOUTHBOUND | - |
| 116764 | N/A | Point | - | - | - | RIGHT ARROW | S221021 | 600-699 BRANNAN ST | - | F | F | - | F | - | - | - | - | SOUTH SIDE | 1703199472000 | middleware_editor | - | - | 5TH ST | - | 58534 | 58534 | 37.775689 | -122.399869 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | R38(SF)1.0047 | 80' EAST OF WPL OF #651 | - | - | - | - | 1 | 135477 | 1451470140000 | - | - | - | 1451433600000 | - | D6 | - | OTHER REGULATORY | REG | PROVISIONAL CODE | N/A | SUP1 | 2IN IRON POST | IS | - | 600-699 BRANNAN ST | 600-699 BRANNAN ST | - | - | - | 06TH ST \ I-280 NORTHBOUND \ I-280 SOUTHBOUND | - |
| 116765 | N/A | Point | - | - | - | - | S265481 | 700-799 CLEMENT ST | - | F | F | - | F | - | - | - | - | NORTH SIDE | 1703199598000 | middleware_editor | - | - | 8TH AVE | - | 112161 | 112161 | 37.782826 | -122.467096 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | 148215 -- R(SF)1.0084 | 24' E OF WPL 744/ 3' IN FROM CURB | - | - | - | - | 1 | 135601 | 1593435360000 | - | - | - | - | - | D1 | - | OTHER REGULATORY | REG | PROVISIONAL CODE | N/A | SUP2 | BIKE RACK | IS | - | 700-799 CLEMENT ST | 700-799 CLEMENT ST | - | - | - | 09TH AVE | - |
| 116766 | N/A | Point | - | - | - | - | S259149 | 700-799 MISSION ST | - | F | F | - | F | - | - | - | - | NORTH SIDE | 1703199598000 | middleware_editor | - | - | - | - | 104244 | 104244 | 37.785363 | -122.403146 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | 71301 -- R(SF).0001 | 6' E OF EPL #756/3' IN FROM CURB | - | - | - | - | 1 | 135602 | 1579685100000 | - | - | - | - | - | D6 | - | OTHER REGULATORY | REG | PROVISIONAL CODE | N/A | SUP1 | BIKE RACK | IS | - | 700-799 MISSION ST | 700-799 MISSION ST | - | - | - | - | - |
| 116767 | N/A | Point | - | - | - | - | S208409 | PRECITA AVE: BRYANT ST | - | F | F | - | F | - | - | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | 1703199598000 | middleware_editor | - | - | PRECITA AVE | - | 48120 | 48120 | 37.747953 | -122.408663 | PRECITA AVE: BRYANT ST | - | 1721663593000 | middleware_editor | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | R(SF).0001 | IFO #690 PRECITA & CESAR CHAVEZ ST | - | - | - | - | 1 | 135603 | - | - | - | - | - | - | D9 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | 2IN IRON POST | IS | - | PRECITA AVE: BRYANT ST | - | - | - | - | - | - |
| 116768 | N/A | Point | - | - | - | - | S228097 | SANSOME ST: CALIFORNIA ST | - | F | F | - | F | - | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1703199598000 | middleware_editor | - | - | CALIFORNIA ST | - | 129397 | 129397 | 37.79306 | -122.401126 | SANSOME ST: CALIFORNIA ST | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | R(SF).0001 | BELOW 'DO NOT ENTER' | - | - | - | - | 1 | 135604 | - | - | - | - | - | - | D3 | - | OTHER REGULATORY | REG | PROVISIONAL CODE | N/A | SUP1 | LIGHT POLE | IS | - | SANSOME ST: CALIFORNIA ST | - | - | - | - | - | - |
| 116769 | N/A | Point | - | - | - | - | S245815 | SUTTER ST: FILLMORE ST | - | T | T | - | F | - | - | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | 1703199598000 | middleware_editor | - | - | FILLMORE ST | - | 85839 | 85839 | 37.786085 | -122.433272 | SUTTER ST: FILLMORE ST | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | Delco 38-MT | - | - | - | - | - | 1 | 135605 | - | - | - | - | - | - | D5 | - | OTHER MISC | MISC | PROVISIONAL CODE | N/A | SUP1 | MUNI POLE | IS | - | SUTTER ST: FILLMORE ST | - | - | - | - | - | - |
| 116770 | N/A | Point | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 1703201899000 | wdwilli | - | - | BATTERY ST \ THE EMBARCADERO | - | 135607 | 135607 | 37.8040712814253 | -122.401968493313 | LOMBARD ST \ BATTERY ST \ THE EMBARCADERO | - | 1710539427000 | MTA | - | - | - | - | - | - | - | - | - | 135607 | - | - | - | - | - | - | 03 | - | OTHER WARNING | WARNING | - | - | SUP1 | - | PI | - | - | - | - | - | - | - | - |
| 116771 | N/A | Point | - | - | - | - | 27086 | - | - | F | F | - | F | 5774000 | - | - | - | SOUTH SIDE | 1707261549000 | elclark | - | - | OCTAVIA ST | - | 100001612 | {5F5205C6-9CB1-48CE-87F2-97AF5DBD8997} | 37.8024227882371 | -122.430435603265 | - | - | 1731626031000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "M" PERMITS | - | - | epl #1535 | - | - | - | - | - | 146721 | - | - | - | - | 1731594240000 | - | 02 | - | PARKING:RPP | REG | R32C(CA).0096 | 18X21 | SUP2 | LIGHT POLE | IS | - | - | 1500 - 1599 FRANCISCO ST | - | - | - | LAGUNA ST | - |
| 116772 | N/A | Point | - | - | - | - | - | - | - | F | F | - | F | 8753101 | - | - | - | SOUTH SIDE | 1707782065000 | wdwilli | - | - | 09TH ST \ LARKIN ST | - | 149873 | 149873 | 37.7772788751276 | -122.416419091858 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | - | - | - | - | - | - | - | 5 | 149873 | - | - | - | - | - | - | 06 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 02X36 | SUP1 | DELINEATOR BASE SAFE HIT | PI | - | MARKET ST | 1301 - 1399 MARKET ST | - | - | - | 10TH ST \ FELL ST \ POLK ST | - |
| 116773 | N/A | Point | - | - | - | - | - | - | - | - | - | - | - | 255000 | - | - | - | - | 1707849349000 | APADILLA | - | - | CLEMENTINA ST | - | 150112 | 150112 | 37.7821936788562 | -122.401385951043 | - | - | 1710539427000 | MTA | - | - | - | - | - | - | - | - | - | 150112 | - | - | - | - | - | - | 06 | - | OTHER REGULATORY | REG | - | - | SUP1 | - | PI | - | 04TH ST | 260 - 299 04TH ST | - | - | - | FOLSOM ST | - |
| 116774 | N/A | Point | - | - | - | - | - | - | - | - | - | - | - | 7427000 | - | - | - | - | 1709653342000 | wdwilli | - | - | GILROY ST | - | 155525 | 155525 | 37.7160480516763 | -122.38976248129 | - | - | 1710539427000 | MTA | - | - | - | - | - | - | - | - | - | 155525 | - | - | - | - | - | - | 10 | - | OTHER MISC | MISC | - | - | SUP1 | - | PI | - | JAMESTOWN AVE | 750 - 799 JAMESTOWN AVE | - | - | - | GRIFFITH ST | - |
| 116775 | N/A | Point | - | - | - | - | S118199 | 20TH AVE: QUINTARA ST | - | F | F | - | F | 23206000 | 23206000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 20TH AVE | 20TH AVE | 12296 | 12296 | 37.74859811 | -122.4771536 | QUINTARA ST \ 20TH AVE | QUINTARA ST \ 20TH AVE | 1710539427000 | MTA | ALL WAY | 20TH AVE intersection | - | - | - | - | - | - | - | 158417 | 1074556800000 | -122.4771536 | 37.74859811 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573220000 | QUINTARA 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