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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 84826 | N/A | Point | - | - | - | - | S107425 | PACHECO ST: CASTENADA AVE | - | F | F | - | F | 22895000 | 22895000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PACHECO ST | CASTENADA AVE | 129936 | 129936 | 37.7477767 | -122.46233324 | CASTENADA AVE \ PACHECO ST | PACHECO ST \ CASTENADA AVE | 1710539427000 | MTA | STOP | CASTENADA AVE intersection | - | 0 / 0 | - | - | - | - | - | 101947 | 226022400000 | -122.46233324 | 37.7477767 | - | 1557964800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569860000 | PACHECO ST | - | - | - | - | - | - |
| 84827 | N/A | Point | 1 | 1 | 569 - 599 | - | S222098 | 569-599 4TH ST | 569-599 04TH ST | F | F | - | F | 264000 | 264000 | - | - | WEST SIDE | - | - | - | - | FREELON ST | FREELON ST | 129937 | 129937 | 37.77853894 | -122.39679618 | - | - | 1710539427000 | MTA | TANSAT | FREELON ST to BRANNAN ST (569 - 599) | - | 10' SOUTH OF FREELON ST | - | - | - | - | - | 101948 | 1452781560000 | -122.39679618 | 37.77853894 | - | 1452729600000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | MUNI POLE | IS | 1452678960000 | 04TH ST | 569 - 599 4TH ST | 569 - 599 04TH ST | 569 4TH ST | - | BRANNAN ST | BRANNAN ST |
| 84828 | N/A | Point | 1 | 1 | 451 - 499 | - | S224696 | 451-499 CLARENDON AVE | 451-499 CLARENDON AVE | F | F | - | F | 4073000 | 4073000 | - | - | NORTH SIDE | - | - | - | - | PANORAMA DR | PANORAMA DR | 129938 | 129938 | 37.753553049 | -122.455906113 | - | - | 1710539427000 | MTA | NPRK 10AM-12NOON 1ST & 3RD FRIDAY OF MONTH STCL | PANORAMA DR to ASHWOOD LN (451 - 499) | - | 100`EAST | - | - | - | - | - | 101949 | - | -122.45581313 | 37.7533226 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0015 | 18X18 | SUP2 | 2IN IRON POST | IS | 1460381280000 | CLARENDON AVE | 451 - 499 CLARENDON AVE | 451 - 499 CLARENDON AVE | 451 CLARENDON AVE | - | ASHWOOD LN | ASHWOOD LN |
| 84829 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S223203 | 1100-1199 HAYES ST | 1100-1199 HAYES ST | T | T | - | F | 6823000 | 6823000 | - | - | NORTH SIDE | - | - | - | - | PIERCE ST | PIERCE ST | 129939 | 129939 | 37.7753114 | -122.43530614 | - | - | 1710539427000 | MTA | PREVENT THEFT REMOVE VALUABLES LOCK YOUR CAR | PIERCE ST to SCOTT ST (1100 - 1199) | - | OPP #1167 | - | - | - | - | - | 101950 | 1454944380000 | -122.43530614 | 37.7753114 | - | 1454889600000 | - | D5 | - | OTHER REGULATORY | REG | SR(SF).0052 | 18X21 | SUP1 | MUNI POLE | IS | 1454673660000 | HAYES ST | 1100 - 1199 HAYES ST | 1100 - 1199 HAYES ST | 1100 HAYES ST | - | SCOTT ST | SCOTT ST |
| 84830 | N/A | Point | 1 | 1 | 1 - 47 | - | S227975 | 1-47 CARMEL ST | 1-47 CARMEL ST | F | F | - | F | 3700000 | 3700000 | - | - | SOUTH SIDE | - | - | - | - | CLAYTON ST \ TWIN PEAKS BLVD | CLAYTON ST \ TWIN PEAKS BLVD | 129940 | 129940 | 37.7609697 | -122.44702923 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "J" PERMITS | CLAYTON ST \ TWIN PEAKS BLVD to BELVEDERE ST (1 - 47) | - | EPL #87 | - | - | - | - | - | 101951 | 1480342200000 | -122.44702923 | 37.7609697 | - | 1480291200000 | - | D5 | - | PARKING:RPP | REG | R32C(CA).0091 | 18X21 | SUP1 | 2IN IRON POST | IS | 1470912120000 | CARMEL ST | 1 - 47 CARMEL ST | 1 - 47 CARMEL ST | 1 CARMEL ST | - | BELVEDERE ST | BELVEDERE ST |
| 84831 | N/A | Point | - | - | - | - | S237114 | - | - | F | F | - | F | 10669000 | - | - | - | EAST SIDE | 1689201376000 | MTA | - | - | - | - | 132045 | 132045 | 37.75536319 | -122.40661026 | - | - | 1710539427000 | MTA | NO LITTERING (SYM)-IT SHALL BE UNLAWFUL¿ | - | - | IFO# 1080 POTREREO AVE, | - | - | - | - | - | 101952 | - | - | - | - | - | - | D9 | - | OTHER REGULATORY | REG | SR(SF).0035 | 18X24 | SUP2 | LIGHT POLE | IS | - | - | 1000 - 1098 POTRERO AVE | - | - | - | - | - |
| 84832 | N/A | Point | - | - | - | - | S103470 | - | - | F | F | - | F | - | - | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 132046 | 132046 | 37.71833993 | -122.41288351 | - | - | 1710539427000 | MTA | ONE WAY (LA) | - | - | N LINE / 0 | - | - | - | - | - | 101953 | -194313600000 | - | - | - | - | - | D10 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | - | - | 0 - 0 MANSELL ST | - | - | - | - | - |
| 84833 | N/A | Point | - | - | - | - | S255214 | - | - | F | F | - | F | 11963101 | - | - | - | SOUTH SIDE | 1689201376000 | MTA | - | - | 45TH AVE | - | 132047 | 132047 | 37.73555571 | -122.50474279 | - | - | 1711051304000 | evillan | NPRK 5AM-7AM EVERYDAY INCL HOLIDAY STCL | - | - | 90FT WEST | - | - | - | - | - | 101954 | 1560437520000 | - | - | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0154 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 2701 - 2899 SLOAT BLVD | - | - | - | 47TH AVE | - |
| 84834 | N/A | Point | - | - | - | - | S255216 | - | - | F | F | - | F | 11963101 | - | - | - | CENTER ISLAND | 1689201376000 | MTA | - | - | 45TH AVE | - | 132048 | 132048 | 37.73555571 | -122.50474279 | - | - | 1742260899000 | middleware_editor | NPRK 5AM-7AM EVERYDAY INCL HOLIDAY STCL | - | - | 5FT WEST OF 46TH AVE | - | - | - | - | - | 101955 | 1560528600000 | - | - | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0154 | 18X18 | SUP2 | LIGHT POLE | IS | - | - | 2701 - 2899 SLOAT BLVD | - | - | - | 47TH AVE | - |
| 84835 | N/A | Point | - | - | - | - | S255219 | - | - | F | F | - | F | 11963101 | - | - | - | CENTER ISLAND | 1689201376000 | MTA | - | - | 45TH AVE | - | 132049 | 132049 | 37.73555571 | -122.50474279 | - | - | 1722993799000 | middleware_editor | NPRK 5AM-7AM EVERYDAY INCL HOLIDAY STCL | - | - | 100FT EAST | - | - | - | - | - | 101956 | 1560507000000 | - | - | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0154 | 18X18 | SUP2 | LIGHT POLE | IS | - | - | 2701 - 2899 SLOAT BLVD | - | - | - | 47TH AVE | - |
| 84836 | N/A | Point | - | - | - | - | S281627 | - | - | F | F | - | F | 2175000 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 132072 | 132072 | 37.71300192 | -122.45047758 | - | - | 1727312990000 | middleware_editor | NPRK 7AM-9AM THUR STCL | - | - | 260 FT. NORTH OF NPL 2800 | - | - | - | - | - | 101957 | - | - | - | - | 1648512000000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0241 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 2701 - 2899 ALEMANY BLVD | - | - | - | - | - |
| 84837 | N/A | Point | - | - | - | RIGHT ARROW | S255238 | - | - | F | F | - | F | 23493000 | - | - | - | SOUTH SIDE | 1689201376000 | MTA | - | - | SLOAT BLVD | - | 132073 | 132073 | 37.73555571 | -122.50474279 | 47TH AVE \ SLOAT BLVD | - | 1711051304000 | evillan | TANSAT | - | - | 10FT WEST | - | - | - | - | - | 101958 | - | - | - | - | - | - | D7 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | - | - | - | - | - | - | - | - |
| 84838 | N/A | Point | - | - | - | - | S286346 | - | - | F | F | - | F | 11010020 | - | - | - | EAST SIDE | 1689201376000 | MTA | - | - | - | - | 132074 | 132074 | 37.80001511 | -122.44668258 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "KM" PERMITS | - | - | NORTH OF FRANCISCO S. # 220 | - | - | - | - | - | 101959 | - | - | - | - | - | - | D2 | - | PARKING:RPP | REG | R32C(CA).0094 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | - | - | 133 - 199 RICHARDSON AVE | - | - | - | - | - |
| 84839 | N/A | Point | - | - | - | - | S252002 | - | - | F | F | - | F | 10623000 | - | - | - | SOUTH SIDE, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 132075 | 132075 | 37.73546538 | -122.47078512 | - | - | 1710539427000 | MTA | BIKE WAYFINDING SIGN | - | 0396 | OPP#1650 | - | - | - | - | - | 101960 | - | - | - | - | - | - | D7 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | 2IN IRON POST | IS | - | - | 1601 - 1699 PORTOLA DR | - | - | - | - | - |
| 84840 | N/A | Point | - | - | - | - | S289894 | - | - | F | F | - | F | 11010010 | - | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 132079 | 132079 | 37.7997092 | -122.44606474 | - | - | 1750859299000 | middleware_editor | RADAR ENFORCED | - | - | 50FT WEST OF CHESTNUT | - | - | - | - | - | 101961 | 1686726000000 | - | - | - | 1744052880000 | 1750859220000 | D2 | - | OTHER REGULATORY | REG | R48-1(CA).0002 | 36X18 | SUP1 | 2IN BREAK-AWAY SYSTEM | RETD | - | - | 100 - 148 RICHARDSON AVE | - | - | - | - | - |
| 84841 | N/A | Point | - | - | - | - | S244666 | - | - | F | F | - | F | 8760030 | - | - | - | SOUTH SIDE | 1689201376000 | MTA | - | - | - | - | 132080 | 132080 | 37.77103758 | -122.42439918 | - | - | 1738872306000 | middleware_editor | BIKE RACK | - | - | IFO 1849 | - | - | - | - | - | 101962 | 1426032000000 | - | - | - | 1523491200000 | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | - | - | 1829 - 1899 MARKET ST | - | - | - | - | - |
| 84842 | N/A | Point | - | - | - | - | S246488 | - | - | F | F | - | F | 13577000 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 132081 | 132081 | 37.74027225 | -122.46635329 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | - | IFO 66 | - | - | - | - | - | 101963 | 1457568000000 | - | - | - | 1529625600000 | - | D7 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | MUNI POLE | IS | - | - | 1 - 99 WEST PORTAL AVE | - | - | - | - | - |
| 84843 | N/A | Point | - | - | - | - | S209557 | - | - | F | F | - | F | 9283000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 132082 | 132082 | 37.73105712 | -122.45702221 | - | - | 1720817974000 | middleware_editor | YIELD HERE TO PED (SYM) (LA) | - | - | 25`EAST (#30 ON LIST) SEE PAINT | - | - | - | - | - | 101964 | 1224806400000 | - | - | - | 1416960000000 | - | D7 | - | PEDESTRIAN | REG | R1-5.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | - | - | 929 - 951 MONTEREY BLVD | - | - | - | - | - |
| 84844 | N/A | Point | - | - | - | - | S210681 | - | - | F | F | - | F | 7831000 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 132083 | 132083 | 37.78071134 | -122.38860543 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM EVERYDAY & HOLIDAY STCL | - | - | 85' SOUTH OF TOWNSEND | - | - | - | - | - | 101965 | - | - | - | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0045 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | - | - | 1 - 99 KING ST | - | - | - | - | - |
| 84845 | N/A | Point | - | - | - | - | S104373 | - | - | F | F | - | F | 155270011 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 132084 | 132084 | 37.73389478 | -122.49796664 | - | - | 1738867960000 | middleware_editor | NO LEFT TURN (SYM) | - | - | 50W / ON TRIANGULAR ISLAND | - | - | - | - | - | 101966 | -13392000000 | - | - | - | - | - | D7 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP2 | UNKNOWN | IS | - | - | 2101 - 2299 SLOAT BLVD | - | - | - | - | - |
| 84846 | N/A | Point | - | - | - | - | S132447 | - | - | F | F | - | F | 8758020 | - | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 132085 | 132085 | 37.77271567 | -122.4224251 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | - | - | W LINE | - | - | - | - | - | 101967 | 1277251200000 | - | - | - | - | - | D6 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | SIGNAL POLE | IS | - | - | 1700 - 1724 MARKET ST | - | - | - | - | - |
| 84847 | N/A | Point | - | - | - | - | S218588 | - | - | F | F | - | F | 549030 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | - | - | 132086 | 132086 | 37.76957448 | -122.41519907 | - | - | 1710539427000 | MTA | RIGHT LANE MUST TURN RIGHT | - | - | 30' WEST OF ISIS | - | - | - | - | - | 101968 | 1441276260000 | - | - | - | 1441238400000 | - | D6 | - | OTHER REGULATORY | REG | R3-7.0005 | 30X30 | SUP1 | 2IN IRON POST | IS | - | - | 70 - 98 13TH ST | - | - | - | - | - |
| 84848 | N/A | Point | - | - | - | - | S212691 | - | - | F | F | - | F | 4868000 | - | - | - | EAST SIDE | 1689201376000 | MTA | - | - | - | - | 132087 | 132087 | 37.76258433 | -122.42626171 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | - | - | IFO #409 | - | - | - | - | - | 101969 | 1508850300000 | - | - | - | 1508803200000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | 2IN IRON POST | IS | - | - | 400 - 460 DOLORES ST | - | - | - | - | - |
| 84849 | N/A | Point | - | - | - | - | S264885 | - | - | T | T | - | F | 13712000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 132088 | 132088 | 37.74682532 | -122.4579544 | - | - | 1710539427000 | MTA | SIGNAL AHEAD (SYM) | - | - | 75 EAST OF VASQUEZ | - | - | - | - | - | 101970 | 1540857600000 | - | - | - | 1594252800000 | - | D7 | - | OTHER WARNING | WARNING | W3-3.0001 | 30X30 | SUP2 | LIGHT POLE | IS | - | - | 1 - 99 WOODSIDE AVE | - | - | - | - | - |
| 84850 | N/A | Point | - | - | - | - | S277112 | - | - | F | F | - | F | 6997000 | - | - | - | SOUTH SIDE | 1689201376000 | MTA | - | - | - | - | 132089 | 132089 | 37.72088915 | -122.47828066 | - | - | 1747244979000 | middleware_editor | TA (SYM) PLO AT ALL TIMES (5 MIN) H/C (SYM ) | - | - | 89 FT EAST OF CARDENAS | - | - | - | - | - | 101971 | 1234339200000 | - | - | - | 1629874800000 | - | D7 | - | OTHER REGULATORY | REG | R38(SF)1.0056 | 14X21 | SUP2 | 2IN IRON POST | IS | - | - | 1600 - 1720 HOLLOWAY AVE | - | - | - | - | - |
| 84851 | N/A | Point | - | - | - | - | S288312 | - | - | F | F | - | F | 11960000 | - | - | - | CENTER ISLAND | 1689201376000 | MTA | - | - | - | - | 132090 | 132090 | 37.73404758 | -122.49792814 | - | - | 1738867955000 | middleware_editor | NPRK 5AM-7AM EVERYDAY INCL HOLIDAY STCL | - | - | OPP. 2260/ PARKING LOT | - | - | - | - | - | 101972 | 1560470400000 | - | - | - | 1680652800000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0154 | 18X18 | SUP2 | LIGHT POLE | IS | - | - | 2100 - 2298 SLOAT BLVD | - | - | - | - | - |
| 84852 | N/A | Point | - | - | - | - | S262706 | - | - | T | T | - | F | 9173000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 132091 | 132091 | 37.71967616 | -122.43862356 | - | - | 1726762186000 | middleware_editor | PEDESTRIAN (SYM) | - | - | IF OF #4919 | - | - | - | - | - | 101973 | 1043193600000 | - | - | - | - | 1726565400000 | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | LIGHT POLE | RETD | - | - | 4900 - 4950 MISSION ST | - | - | - | - | - |
| 84853 | N/A | Point | - | - | - | - | S288300 | - | - | F | F | - | F | 11955020 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | - | - | 132092 | 132092 | 37.73439665 | -122.48452396 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM WED STCL | - | - | INFO 1240 | - | - | - | - | - | 101974 | 1514246400000 | - | - | - | 1680652800000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP2 | LIGHT POLE | IS | - | - | 1200 - 1248 SLOAT BLVD | - | - | - | - | - |
| 84854 | N/A | Point | - | - | - | - | S207788 | NAPLES ST: ROLPH ST | - | F | F | - | F | 21428000 | 21428000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ROLPH ST | NAPLES ST | 47742 | 47742 | 37.713408324 | -122.436645446 | NAPLES ST \ ROLPH ST | ROLPH ST \ NAPLES ST | 1710539427000 | MTA | ALL WAY | NAPLES ST intersection | - | INFO #1101 NAPLES ST | - | - | - | - | - | 101975 | 1406554200000 | -122.43664187 | 37.71354978 | - | 1406505600000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | UTILITY POLE | IS | 1406030040000 | ROLPH ST | - | - | - | - | - | - |
| 84855 | N/A | Point | - | - | - | - | S208170 | GARFIELD ST: RAMSELL ST | - | F | F | - | F | 22700000 | 22700000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | RAMSELL ST | GARFIELD ST | 47832 | 47832 | 37.71967859 | -122.46625434 | GARFIELD ST \ RAMSELL ST | RAMSELL ST \ GARFIELD ST | 1711219056000 | middleware_editor | SPEED HUMP | GARFIELD ST intersection | - | NEED 3IN EXTEN (SEE NOTES) | - | - | - | - | - | 101976 | 1408579200000 | -122.46625434 | 37.71967859 | - | 1711182600000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 3IN IRON POST | IS | 1407835200000 | RAMSELL ST | - | - | - | - | - | - |
| 84856 | N/A | Point | 1 | 1 | 200 - 299 | - | S208174 | 200-299 BEVERLY ST | 200-299 BEVERLY ST | F | F | - | F | 2969000 | 2969000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | GARFIELD ST | GARFIELD ST | 47835 | 47835 | 37.72063571 | -122.47166285 | - | - | 1738350329000 | middleware_editor | SPEED HUMP | GARFIELD ST to HOLLOWAY AVE (200 - 299) | - | SPL#218 | - | - | - | - | - | 101977 | 1408604940000 | -122.47166285 | 37.72063571 | - | 1408579200000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1407836280000 | BEVERLY ST | 200 - 299 BEVERLY ST | 200 - 299 BEVERLY ST | 200 BEVERLY ST | - | HOLLOWAY AVE | HOLLOWAY AVE |
| 84857 | N/A | Point | 1 | 1 | 200 - 299 | - | S208175 | 200-299 BEVERLY ST | 200-299 BEVERLY ST | F | F | - | F | 2969000 | 2969000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | GARFIELD ST | GARFIELD ST | 47836 | 47836 | 37.72063571 | -122.47166285 | - | - | 1738350322000 | middleware_editor | SPEED HUMP | GARFIELD ST to HOLLOWAY AVE (200 - 299) | - | SPL#279 | - | - | - | - | - | 101978 | 1408604940000 | -122.47166285 | 37.72063571 | - | 1408579200000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1407836580000 | BEVERLY ST | 200 - 299 BEVERLY ST | 200 - 299 BEVERLY ST | 200 BEVERLY ST | - | HOLLOWAY AVE | HOLLOWAY AVE |
| 84858 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S208584 | 1200-1299 REVERE AVE | 1200-1299 REVERE AVE | F | F | - | F | 10974000 | 10974000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | HAWES ST | HAWES ST | 48023 | 48023 | 37.72795536 | -122.38362165 | - | - | 1711588216000 | middleware_editor | SPEED HUMPS | HAWES ST to INGALLS ST (1200 - 1299) | - | INFO #1222 | - | - | - | - | - | 101979 | 1415370540000 | -122.38362165 | 37.72795536 | - | 1415318400000 | - | D10 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1409221740000 | REVERE AVE | 1200 - 1299 REVERE AVE | 1200 - 1299 REVERE AVE | 1200 REVERE AVE | - | INGALLS ST | INGALLS ST |
| 84859 | N/A | Point | 1 | 1 | 2112 - 2199 | - | S222817 | 2112-2199 15TH ST | 2112-2199 15TH ST | F | F | - | F | 664000 | 664000 | - | - | WEST SIDE | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 58670 | 58670 | 37.76592898 | -122.43214663 | - | - | 1710539427000 | MTA | DELINEATOR (W) (SAFE HIT) | SANCHEZ ST to NOE ST (2112 - 2199) | - | X WALK TO 18' SOUTH | - | - | - | - | - | 101980 | - | -122.43214663 | 37.76592898 | - | - | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1453974420000 | 15TH ST | 2112 - 2199 15TH ST | 2112 - 2199 15TH ST | 2112 15TH ST | - | NOE ST | NOE ST |
| 84860 | N/A | Point | 1 | 1 | 400 - 499 | - | S220222 | 400-499 JEFFERSON ST | 400-499 JEFFERSON ST | F | F | - | F | 7459000 | 7459000 | - | - | NORTH SIDE | - | - | - | - | LEAVENWORTH ST \ RICHARD HENRY DANA PL | LEAVENWORTH ST \ RICHARD HENRY DANA PL | 58717 | 58717 | 37.80769661 | -122.41991467 | - | - | 1710539427000 | MTA | BIKE RACK | LEAVENWORTH ST \ RICHARD HENRY DANA PL to HYDE ST (400 - 499) | 20154603 | WPL #498 | - | - | - | - | - | 101981 | 1445696340000 | -122.41991467 | 37.80769661 | - | 1445644800000 | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1445511360000 | JEFFERSON ST | 400 - 499 JEFFERSON ST | 400 - 499 JEFFERSON ST | 400 JEFFERSON ST | - | HYDE ST | HYDE ST |
| 84861 | N/A | Point | - | - | - | - | S218848 | MARKET ST: FRANKLIN ST | - | F | F | - | F | 30750000 | 30750000 | - | - | NORTH SIDE | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 58720 | 58720 | 37.773942087 | -122.420776554 | MARKET ST \ FRANKLIN ST | MARKET ST \ FRANKLIN ST | 1710539427000 | MTA | BIKE RACK | FRANKLIN ST intersection | 20154305 | 33FT. EAST OF WPL#1632(6FT. FROM CURB) | - | - | - | - | - | 101982 | 1446547200000 | -122.42069877 | 37.77400781 | - | 1446508800000 | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1440687660000 | MARKET ST | - | - | - | - | - | - |
| 84862 | N/A | Point | - | - | - | - | S224429 | 48TH AVE: JUDAH ST | - | F | F | - | F | 27951000 | 27951000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 48TH AVE | JUDAH ST | 58746 | 58746 | 37.76032982 | -122.50806756 | JUDAH ST \ 48TH AVE | 48TH AVE \ JUDAH ST | 1715390664000 | middleware_editor | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | JUDAH ST intersection | - | - | - | - | - | - | - | 101983 | 1459296000000 | -122.50806756 | 37.76032982 | - | 1459296000000 | - | D4 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | 2IN IRON POST | IS | 1459160580000 | 48TH AVE | - | - | - | - | - | - |
| 84863 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S220823 | 1400-1458 SAN BRUNO AVE | 1400-1499 SAN BRUNO AVE | F | F | - | F | 11362000 | 11362000 | - | - | EAST SIDE | - | - | - | - | 25TH ST | 25TH ST | 58788 | 58788 | 37.751488255 | -122.404137327 | - | - | 1710539427000 | MTA | NPRK 6AM-7AM MON STCL | 25TH ST to SAN BRUNO AVE (1400 - 1499) | - | NPL #1413 | - | - | - | - | - | 101984 | 1014854400000 | -122.40415208 | 37.75091671 | - | 1568246400000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0172 | 18X18 | SUP1 | 2IN IRON POST | IS | 1448270700000 | SAN BRUNO AVE | 1400 - 1499 SAN BRUNO AVE | 1400 - 1499 SAN BRUNO AVE | 1400 SAN BRUNO AVE | - | SAN BRUNO AVE | SAN BRUNO AVE |
| 84864 | N/A | Point | 1 | 1 | 400 - 499 | - | S223334 | 400-499 IRVING ST | 400-499 IRVING ST | F | F | - | F | 7282000 | 7282000 | - | - | SOUTH SIDE | - | - | - | - | 5TH AVE | 05TH AVE | 58799 | 58799 | 37.76420133 | -122.46256627 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "J" PERMITS | 05TH AVE to 06TH AVE (400 - 499) | - | 60' EAST 6TH AVE | - | - | - | - | - | 101985 | - | -122.46256627 | 37.76420133 | - | - | - | D5 | - | PARKING:RPP | REG | R32C(CA).0091 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1455117240000 | IRVING ST | 400 - 499 IRVING ST | 400 - 499 IRVING ST | 400 IRVING ST | - | 06TH AVE | 06TH AVE |
| 84865 | N/A | Point | - | - | - | - | S224654 | MIDDLE POINT RD: CATALINA ST \ | - | F | F | - | F | 20172000 | 20172000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CATALINA ST | CATALINA ST | 58811 | 58811 | 37.73627246 | -122.37941451 | MIDDLE POINT RD \ CATALINA ST | MIDDLE POINT RD \ CATALINA ST | 1741111834000 | middleware_editor | STOP | CATALINA ST intersection | - | - | - | - | - | - | - | 101986 | 1460151780000 | -122.37941451 | 37.73627246 | - | 1460098800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1460110620000 | MIDDLE POINT RD | - | - | - | - | - | - |
| 84866 | N/A | Point | 1 | 1 | 543 - 599 | - | S273852 | 543-599 COMMERCIAL ST | 543-599 COMMERCIAL ST | F | F | - | F | 4313000 | 4313000 | - | - | SOUTH SIDE | - | - | - | - | LEIDESDORFF ST | LEIDESDORFF ST | 105362 | 105362 | 37.79426749 | -122.402525623 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM TUE THUR STCL | LEIDESDORFF ST to MONTGOMERY ST (543 - 599) | - | 60' WEST OF LEIDESDORF | - | - | - | - | - | 101987 | 1617788040000 | -122.40265571 | 37.7942659 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0133 | 18X18 | SUP1 | 2IN IRON POST | IS | 1617716880000 | COMMERCIAL ST | 543 - 599 COMMERCIAL ST | 543 - 599 COMMERCIAL ST | 543 COMMERCIAL ST | - | MONTGOMERY ST | MONTGOMERY ST |
| 84867 | N/A | Point | 1 | 1 | 1050 - 1099 | - | S273487 | 1050-1099 VALENCIA ST | 1050-1099 VALENCIA ST | F | F | - | F | 13070000 | 13070000 | - | - | EAST SIDE | - | - | - | - | HILL ST | HILL ST | 105395 | 105395 | 37.755426859 | -122.421094411 | - | - | 1710539427000 | MTA | BIKE RACK | HILL ST to 22ND ST (1050 - 1099) | - | 12/15/18/21/24/27' N OF 22ND IN CORRAL | - | - | - | - | - | 101988 | - | -122.42100262 | 37.7556983 | - | - | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1616571600000 | VALENCIA ST | 1050 - 1099 VALENCIA ST | 1050 - 1099 VALENCIA ST | 1050 VALENCIA ST | - | 22ND ST | 22ND ST |
| 84868 | N/A | Point | 1 | 1 | 1050 - 1099 | - | S273488 | 1050-1099 VALENCIA ST | 1050-1099 VALENCIA ST | F | F | - | F | 13070000 | 13070000 | - | - | EAST SIDE | - | - | - | - | HILL ST | HILL ST | 105396 | 105396 | 37.755423089 | -122.421090835 | - | - | 1743821738000 | middleware_editor | WHEEL STOP | HILL ST to 22ND ST (1050 - 1099) | - | N END OF CORRAL @ 22ND ST | - | - | - | - | - | 101989 | - | -122.42100262 | 37.7556983 | - | - | - | D8 | - | OTHER WARNING | WARNING | W(SF).0072 | 36X08 | SUP2 | SPIKE | IS | 1616571660000 | VALENCIA ST | 1050 - 1099 VALENCIA ST | 1050 - 1099 VALENCIA ST | 1050 VALENCIA ST | - | 22ND ST | 22ND ST |
| 84869 | N/A | Point | 1 | 1 | 1050 - 1099 | - | S273489 | 1050-1099 VALENCIA ST | 1050-1099 VALENCIA ST | F | F | - | F | 13070000 | 13070000 | - | - | EAST SIDE | - | - | - | - | HILL ST | HILL ST | 105397 | 105397 | 37.755892455 | -122.421142095 | - | - | 1744041149000 | middleware_editor | DELINEATOR (W) (SAFE HIT) | HILL ST to 22ND ST (1050 - 1099) | - | N END OF CORRAL @ 22ND ST | - | - | - | - | - | 101990 | - | -122.42100262 | 37.7556983 | - | - | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP2 | SPIKE | IS | 1616571720000 | VALENCIA ST | 1050 - 1099 VALENCIA ST | 1050 - 1099 VALENCIA ST | 1050 VALENCIA ST | - | 22ND ST | 22ND ST |
| 84870 | N/A | Point | 1 | 1 | 1050 - 1099 | - | S273490 | 1050-1099 VALENCIA ST | 1050-1099 VALENCIA ST | F | F | - | F | 13070000 | 13070000 | - | - | EAST SIDE | - | - | - | - | HILL ST | HILL ST | 105398 | 105398 | 37.755195944 | -122.421052688 | - | - | 1712185763000 | middleware_editor | DELINEATOR (W) (SAFE HIT) | HILL ST to 22ND ST (1050 - 1099) | - | S END OF CORRAL @ 22ND ST | - | - | - | - | - | 101991 | - | -122.42100262 | 37.7556983 | - | 1712152800000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP2 | SPIKE | IS | 1616571780000 | VALENCIA ST | 1050 - 1099 VALENCIA ST | 1050 - 1099 VALENCIA ST | 1050 VALENCIA ST | - | 22ND ST | 22ND ST |
| 84871 | N/A | Point | - | - | - | - | S214527 | FRANKLIN ST: OFARRELL ST \ STA | - | T | T | - | F | 25196000 | 25196000 | - | - | SOUTH EAST CORNER | - | - | - | - | FRANKLIN ST \ STARR KING WAY | FRANKLIN ST \ OFARRELL ST | 105605 | 105605 | 37.784504214 | -122.422721413 | OFARRELL ST \ FRANKLIN ST \ STARR KING WAY | STARR KING WAY \ FRANKLIN ST \ OFARRELL ST | 1710539427000 | MTA | FRANKLIN ST | FRANKLIN ST \ OFARRELL ST intersection | - | - | - | - | - | - | - | 101992 | 1508149320000 | -122.42283809 | 37.78454661 | - | 1508112000000 | - | D5 | - | STREET NAME | GUIDE | D3-1.0690 | 36X08 | SUP1 | LIGHT POLE | IS | 1427271000000 | STARR KING WAY | - | - | - | - | - | - |
| 84872 | N/A | Point | - | - | - | - | S278137 | 44TH AVE: ULLOA ST | - | F | F | - | F | 23460000 | 23460000 | - | - | NORTH WEST CORNER | - | - | - | - | ULLOA ST | ULLOA ST | 105820 | 105820 | 37.74009949 | -122.502422373 | 44TH AVE \ ULLOA ST | 44TH AVE \ ULLOA ST | 1710539427000 | MTA | ULLOA ST | ULLOA ST intersection | - | 0 / 00 | - | - | - | - | - | 101993 | 560563200000 | -122.50234593 | 37.74000139 | - | 1653523200000 | - | D4 | - | STREET NAME | GUIDE | D3-1.1763 | 36X08 | SUP2 | 2IN IRON POST | IS | 1633617780000 | 44TH AVE | - | - | - | - | - | - |
| 84873 | N/A | Point | 1 | 1 | 100 - 199 | - | S289252 | 100-199 KISSLING ST | 100-199 KISSLING ST | F | F | - | F | 7903000 | 7903000 | - | - | SOUTH SIDE | - | - | - | - | 11TH ST | 11TH ST | 105859 | 105859 | 37.772502037 | -122.41512063 | - | - | 1710539427000 | MTA | WHEEL STOP | 11TH ST to 12TH ST (100 - 199) | - | W SIDE OF CORRAL | - | - | - | - | - | 101994 | 1683504000000 | -122.41560313 | 37.77203843 | - | 1704187200000 | - | D6 | - | OTHER WARNING | WARNING | W(SF).0072 | 36X08 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1683217080000 | KISSLING ST | 100 - 199 KISSLING ST | 100 - 199 KISSLING ST | 100 KISSLING ST | - | 12TH ST | 12TH ST |
| 84874 | N/A | Point | - | - | - | - | S229805 | SANTA ANA AVE: 14TH AVE \ PORT | - | F | F | - | F | 22943000 | 22943000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PORTOLA DR \ SAN ANSELMO AVE \ SANTA ANA AVE | 14TH AVE \ SAN ANSELMO AVE \ SANTA ANA AVE | 105900 | 105900 | 37.737212219 | -122.468122691 | 14TH AVE \ PORTOLA DR \ SAN ANSELMO AVE \ SANTA ANA AVE | PORTOLA DR \ 14TH AVE \ SAN ANSELMO AVE \ SANTA ANA AVE | 1710539427000 | MTA | STOP | 14TH AVE \ SAN ANSELMO AVE \ SANTA ANA AVE intersection | - | - | - | - | - | - | - | 101995 | 1477495500000 | -122.46830961 | 37.73741715 | - | 1477440000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1476354600000 | PORTOLA DR | - | - | - | - | - | - |
| 84875 | N/A | Point | - | - | - | - | S278591 | GUERRERO ST: 18TH ST | - | F | F | - | F | 25677000 | 25677000 | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | - | - | - | - | GUERRERO ST | 18TH ST | 106018 | 106018 | 37.7614289 | -122.423791282 | 18TH ST \ GUERRERO ST | GUERRERO ST \ 18TH ST | 1710539427000 | MTA | LEFT TURN YIELD ON GREEN (SYM) | 18TH ST intersection | - | INSTALL 10 FT HIGH | - | - | - | - | - | 101996 | 1636460100000 | -122.42380067 | 37.76156567 | - | - | - | D8 | - | OTHER REGULATORY | REG | R10-12.0001 | 30X36 | SUP2 | LIGHT POLE | IS | 1635933180000 | GUERRERO ST | - | - | - | - | - | - |
| 84876 | N/A | Point | - | - | - | - | S264654 | PORTOLA DR: 14TH AVE \ SAN ANS | - | F | F | - | F | 22943000 | 22943000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | PORTOLA DR \ SAN ANSELMO AVE \ SANTA ANA AVE | 14TH AVE \ SAN ANSELMO AVE \ SANTA ANA AVE | 106172 | 106172 | 37.737339489 | -122.46843148 | 14TH AVE \ PORTOLA DR \ SAN ANSELMO AVE \ SANTA ANA AVE | PORTOLA DR \ 14TH AVE \ SAN ANSELMO AVE \ SANTA ANA AVE | 1716399298000 | middleware_editor | NO LEFT TURN (SYM) | 14TH AVE \ SAN ANSELMO AVE \ SANTA ANA AVE intersection | - | BACK TO BACK WITH LEFT TURN ON GREEN | - | - | - | - | - | 101997 | - | -122.46830961 | 37.73741715 | - | - | 1716302460000 | D7 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | RETD | 1590661200000 | PORTOLA DR | - | - | - | - | - | - |
| 84877 | N/A | Point | - | - | - | - | S216305 | DIVISADERO ST: CASTRO ST \ WAL | - | F | F | - | F | 26011000 | 26011000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | DIVISADERO ST \ WALLER ST | CASTRO ST \ WALLER ST | 106207 | 106207 | 37.7703429 | -122.43684894 | CASTRO ST \ DIVISADERO ST \ WALLER ST | DIVISADERO ST \ CASTRO ST \ WALLER ST | 1724192345000 | middleware_editor | KEEP RIGHT | CASTRO ST \ WALLER ST intersection | - | - | - | - | - | - | - | 101998 | - | -122.43684894 | 37.7703429 | - | - | - | D5 | - | OTHER REGULATORY | REG | R4-7A(SF).0001 | 24X30 | SUP1 | LIGHT POLE | IS | 1432107360000 | DIVISADERO ST | - | - | - | - | - | - |
| 84878 | N/A | Point | - | - | - | - | S101811 | GOLDEN GATE AVE: FILLMORE ST | - | F | F | - | F | 25971000 | 25971000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FILLMORE ST | FILLMORE ST | 106237 | 106237 | 37.77956415 | -122.4319518 | GOLDEN GATE AVE \ FILLMORE ST | GOLDEN GATE AVE \ FILLMORE ST | 1744322031000 | middleware_editor | ONE WAY (LA) | FILLMORE ST intersection | - | - | - | - | - | - | - | 101999 | -394995600000 | -122.4319518 | 37.77956415 | - | 1744311600000 | - | D5 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373566860000 | GOLDEN GATE AVE | - | - | - | - | - | - |
| 84879 | N/A | Point | - | - | - | - | S288409 | 16TH ST: VALENCIA ST | - | F | F | - | F | 24183000 | 24183000 | - | - | NORTH EAST CORNER | - | - | - | - | VALENCIA ST | 16TH ST | 106243 | 106243 | 37.765003608 | -122.421735352 | 16TH ST \ VALENCIA ST | VALENCIA ST \ 16TH ST | 1710539427000 | MTA | 16TH ST/AMERICAN INDIAN CULTURAL DIST RAMAYTUSH OHLONE LAND | 16TH ST intersection | - | 3100 WEST ---> NEXT TO BUS STOP | - | - | - | - | - | 102000 | 1683763200000 | -122.42188645 | 37.76491738 | - | - | - | D8 | - | STREET NAME | GUIDE | D3-1.2054 | 36X18 | SUP2 | LIGHT POLE | IS | 1680616500000 | VALENCIA ST | - | - | - | - | - | - |
| 84880 | N/A | Point | - | - | - | - | S102173 | RONDEL PL: 16TH ST | - | F | F | - | F | 24177000 | 24177000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | RONDEL PL | RONDEL PL | 106446 | 106446 | 37.76503562 | -122.421372806 | 16TH ST \ RONDEL PL | 16TH ST \ RONDEL PL | 1710539427000 | MTA | ONE WAY (LA) | RONDEL PL intersection | - | 0 / 0 | - | - | - | - | - | 102001 | -390096000000 | -122.42123959 | 37.76495646 | - | - | - | D9 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | UNKNOWN | IS | 1373568240000 | 16TH ST | - | - | - | - | - | - |
| 84881 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S282601 | 1400-1499 OWENS ST | 1400-1499 OWENS ST | F | F | - | F | 19995000 | 19995000 | - | - | WEST SIDE | - | - | - | - | MISSION BAY CIR | MISSION BAY CIR | 106525 | 106525 | 37.76983213 | -122.39587734 | - | - | 1710539427000 | MTA | TANSAT | MISSION BAY CIR to NELSON RISING LN (1400 - 1499) | - | 35'SOUTH OF MISSION BAY CIR. | - | - | - | - | - | 102002 | 1410134400000 | -122.39587734 | 37.76983213 | - | 1652227200000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP1 | LIGHT POLE | IS | 1651572120000 | OWENS ST | 1400 - 1499 OWENS ST | 1400 - 1499 OWENS ST | 1400 OWENS ST | - | NELSON RISING LN | NELSON RISING LN |
| 84882 | N/A | Point | 1 | 1 | 500 - 589 | - | S270535 | 500-589 HOWARD ST | 500-589 HOWARD ST | F | F | - | F | 19938000 | 7033000 | - | - | NORTH SIDE | - | - | - | - | - | 01ST ST | 114441 | 114441 | 37.78778576 | -122.39698358 | - | - | 1710539427000 | MTA | TANSAT | 01ST ST to MALDEN ALY (500 - 589) | - | 214 FT EAST OF 2ND | - | - | - | - | - | 102003 | 1539820800000 | -122.39698358 | 37.78778576 | - | 1607558400000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1606813920000 | HOWARD ST | - | 500 - 589 HOWARD ST | 500 HOWARD ST | - | - | MALDEN ALY |
| 84883 | N/A | Point | 1 | 1 | 500 - 589 | - | S270536 | 500-589 HOWARD ST | 500-589 HOWARD ST | F | F | - | F | 19938000 | 7033000 | - | - | NORTH SIDE | - | - | - | - | - | 01ST ST | 114442 | 114442 | 37.78778576 | -122.39698358 | - | - | 1710539427000 | MTA | TANSAT | 01ST ST to MALDEN ALY (500 - 589) | - | 130 FT EAST OF 2ND | - | - | - | - | - | 102004 | 1539820800000 | -122.39698358 | 37.78778576 | - | 1607644800000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1606813980000 | HOWARD ST | - | 500 - 589 HOWARD ST | 500 HOWARD ST | - | - | MALDEN ALY |
| 84884 | N/A | Point | 1 | 1 | 500 - 589 | - | S270537 | 500-589 HOWARD ST | 500-589 HOWARD ST | F | F | - | F | 7034000 | 7033000 | - | - | NORTH SIDE | - | - | - | - | MALDEN ALY | 01ST ST | 114443 | 114443 | 37.78778576 | -122.39698358 | - | - | 1710539427000 | MTA | TANSAT | 01ST ST to MALDEN ALY (500 - 589) | - | 40 FT EAST OF 2ND | - | - | - | - | - | 102005 | 1539820800000 | -122.39698358 | 37.78778576 | - | 1607644800000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1606814040000 | HOWARD ST | 574 - 599 HOWARD ST | 500 - 589 HOWARD ST | 500 HOWARD ST | - | 02ND ST | MALDEN ALY |
| 84885 | N/A | Point | 1 | 1 | 2100 - 2199 | - | S270566 | 2100-2199 TURK BLVD | 2100-2199 TURK BLVD | F | F | - | F | 12738000 | 12738000 | - | - | NORTH SIDE | - | - | - | - | ARBOL LN \ LYON ST | ARBOL LN \ LYON ST | 114445 | 114445 | 37.77893733 | -122.44452293 | - | - | 1710539427000 | MTA | ARBOL LN | ARBOL LN \ LYON ST to CENTRAL AVE (2100 - 2199) | - | @ ARBOL STAIR WAY (END) | - | - | - | - | - | 102006 | 1606903500000 | -122.44452293 | 37.77893733 | - | - | - | D5 | - | STREET NAME | GUIDE | D3-1.2003 | 36X08 | SUP1 | LIGHT POLE | IS | 1606896300000 | TURK BLVD | 2100 - 2199 TURK BLVD | 2100 - 2199 TURK BLVD | 2100 TURK BLVD | - | CENTRAL AVE | CENTRAL AVE |
| 84886 | N/A | Point | 1 | 1 | 300 - 399 | LEFT ARROW | S270569 | 300-399 HOWARD ST | 300-399 HOWARD ST | F | F | - | F | 7031000 | 7031000 | - | - | SOUTH SIDE | - | - | - | - | BEALE ST | BEALE ST | 114446 | 114446 | 37.78958047 | -122.39471358 | - | - | 1710539427000 | MTA | TA (SYM) PLO AT ALL TIMES (5 MIN) | BEALE ST to FREMONT ST (300 - 399) | - | 55FT WEST OF EPL#301 | - | - | - | - | - | 102007 | 1523318400000 | -122.39471358 | 37.78958047 | - | 1636675200000 | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0001 | 14X21 | SUP1 | 2IN FLANGE POST | IS | 1606903140000 | HOWARD ST | 300 - 399 HOWARD ST | 300 - 399 HOWARD ST | 300 HOWARD ST | - | FREMONT ST | FREMONT ST |
| 84887 | N/A | Point | 1 | 1 | 300 - 399 | RIGHT ARROW | S270570 | 300-399 HOWARD ST | 300-399 HOWARD ST | F | F | - | F | 7031000 | 7031000 | - | - | SOUTH SIDE | - | - | - | - | BEALE ST | BEALE ST | 114447 | 114447 | 37.78958047 | -122.39471358 | - | - | 1710539427000 | MTA | TA (SYM) PLO AT ALL TIMES (5 MIN) | BEALE ST to FREMONT ST (300 - 399) | - | 15 FT WEST OF EPL#301 | - | - | - | - | - | 102008 | 1523318400000 | -122.39471358 | 37.78958047 | - | 1636675200000 | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0001 | 14X21 | SUP1 | 2IN FLANGE POST | IS | 1606903260000 | HOWARD ST | 300 - 399 HOWARD ST | 300 - 399 HOWARD ST | 300 HOWARD ST | - | FREMONT ST | FREMONT ST |
| 84888 | N/A | Point | - | - | - | - | S285527 | 4TH ST: LONG BRIDGE ST | - | F | F | - | F | 34168000 | 34168000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 4TH ST | 04TH ST | 114448 | 114448 | 37.77346692 | -122.39143434 | LONG BRIDGE ST \ 4TH ST | LONG BRIDGE ST \ 04TH ST | 1738944512000 | middleware_editor | (45 LA-DN) | 04TH ST intersection | - | OPP. SWC/ NORTH SIDE OF X-WALK | - | - | - | - | - | 102009 | 1456876800000 | -122.39143434 | 37.77346692 | - | 1456876800000 | - | D6 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP1 | 2IN IRON POST | IS | 1666016460000 | LONG BRIDGE ST | - | - | - | - | - | - |
| 84889 | N/A | Point | - | - | - | - | S285528 | 4TH ST: LONG BRIDGE ST | - | F | F | - | F | 34168000 | 34168000 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 4TH ST | 04TH ST | 114449 | 114449 | 37.77346692 | -122.39143434 | LONG BRIDGE ST \ 4TH ST | LONG BRIDGE ST \ 04TH ST | 1738944577000 | middleware_editor | PEDESTRIAN (SYM) | 04TH ST intersection | - | OPP. SWC/ NORTH SIDE OF X-WALK | - | - | - | - | - | 102010 | 1668556800000 | -122.39143434 | 37.77346692 | - | - | - | D6 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1666016520000 | LONG BRIDGE ST | - | - | - | - | - | - |
| 84890 | N/A | Point | - | - | - | - | S285529 | 4TH ST: LONG BRIDGE ST | - | F | F | - | F | 34168000 | 34168000 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 4TH ST | 04TH ST | 114450 | 114450 | 37.77346692 | -122.39143434 | LONG BRIDGE ST \ 4TH ST | LONG BRIDGE ST \ 04TH ST | 1738944700000 | middleware_editor | (45 RA-DN) | 04TH ST intersection | - | OPP. SWC/ NORTH SIDE OF X-WALK | - | - | - | - | - | 102011 | 1668556800000 | -122.39143434 | 37.77346692 | - | - | - | D6 | - | OTHER WARNING | WARNING | W16-7P.0006 | 24X12 | SUP1 | 2IN IRON POST | IS | 1666016580000 | LONG BRIDGE ST | - | - | - | - | - | - |
| 84891 | N/A | Point | - | - | - | - | S285530 | 4TH ST: LONG BRIDGE ST | - | T | T | - | F | 34168000 | 34168000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 4TH ST | 04TH ST | 114451 | 114451 | 37.77346692 | -122.39143434 | LONG BRIDGE ST \ 4TH ST | LONG BRIDGE ST \ 04TH ST | 1738944634000 | middleware_editor | (45 LA-DN) | 04TH ST intersection | - | - | - | - | - | - | - | 102012 | 1668643200000 | -122.39143434 | 37.77346692 | - | - | - | D6 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP1 | LIGHT POLE | IS | 1666022160000 | LONG BRIDGE ST | - | - | - | - | - | - |
| 84892 | N/A | Point | - | - | - | - | S285531 | 4TH ST: LONG BRIDGE ST | - | T | T | - | F | 34168000 | 34168000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 4TH ST | 04TH ST | 114452 | 114452 | 37.77346692 | -122.39143434 | LONG BRIDGE ST \ 4TH ST | LONG BRIDGE ST \ 04TH ST | 1738944697000 | middleware_editor | PEDESTRIAN (SYM) | 04TH ST intersection | - | - | - | - | - | - | - | 102013 | 1668556800000 | -122.39143434 | 37.77346692 | - | - | - | D6 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | LIGHT POLE | IS | 1666022220000 | LONG BRIDGE ST | - | - | - | - | - | - |
| 84893 | N/A | Point | - | - | - | - | S285532 | 4TH ST: LONG BRIDGE ST | - | T | T | - | F | 34168000 | 34168000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 4TH ST | 04TH ST | 114453 | 114453 | 37.77346692 | -122.39143434 | LONG BRIDGE ST \ 4TH ST | LONG BRIDGE ST \ 04TH ST | 1738944702000 | middleware_editor | (45 RA-DN) | 04TH ST intersection | - | - | - | - | - | - | - | 102014 | 1668556800000 | -122.39143434 | 37.77346692 | - | - | - | D6 | - | OTHER WARNING | WARNING | W16-7P.0006 | 24X12 | SUP1 | LIGHT POLE | IS | 1666022340000 | LONG BRIDGE ST | - | - | - | - | - | - |
| 84894 | N/A | Point | - | - | - | - | S285718 | CESAR CHAVEZ ON RAMP: 25TH ST | - | F | F | - | F | 23949000 | 23949000 | - | - | CENTER ISLAND, E LINE, NORTHBOUND | - | - | - | - | 25TH ST \ CESAR CHAVEZ ON RAMP | 25TH ST \ CESAR CHAVEZ ON RAMP | 114455 | 114455 | 37.7513669 | -122.40618657 | POTRERO AVE \ 25TH ST \ CESAR CHAVEZ ON RAMP | POTRERO AVE \ 25TH ST \ CESAR CHAVEZ ON RAMP | 1710539427000 | MTA | (90 LA) CURVE (SYM) | 25TH ST \ CESAR CHAVEZ ON RAMP intersection | - | 60'FT N.LINE OF CESAR CHAVEZ | - | - | - | - | - | 102015 | - | -122.40618657 | 37.7513669 | - | - | - | D9 | - | OTHER WARNING | WARNING | W1-1.0003 | 36X36 | SUP2 | 2IN IRON POST | IS | 1666870920000 | POTRERO AVE | - | - | - | - | - | - |
| 84895 | N/A | Point | 1 | 1 | 36 - 67 | RIGHT ARROW | S270259 | 36-67 3RD ST | 36-67 03RD ST | F | F | - | F | 164000 | 164000 | - | - | WEST SIDE | - | - | - | - | STEVENSON ST | STEVENSON ST | 114458 | 114458 | 37.78685131 | -122.40280171 | - | - | 1710539427000 | MTA | TA (SYM) PLO AT ALL TIMES (5 MIN) | STEVENSON ST to JESSIE ST (36 - 67) | - | 9' N OF MISSION | - | - | - | - | - | 102016 | 1605874140000 | -122.40280171 | 37.78685131 | - | - | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0001 | 14X21 | SUP1 | 2IN FLANGE POST | IS | 1605779400000 | 03RD ST | 36 - 67 3RD ST | 36 - 67 03RD ST | 36 3RD ST | - | JESSIE ST | JESSIE ST |
| 84896 | N/A | Point | 1 | 1 | 36 - 67 | LEFT ARROW | S270260 | 36-67 3RD ST | 36-67 03RD ST | F | F | - | F | 164000 | 164000 | - | - | WEST SIDE | - | - | - | - | STEVENSON ST | STEVENSON ST | 114459 | 114459 | 37.78685131 | -122.40280171 | - | - | 1710539427000 | MTA | TA (SYM) PLO AT ALL TIMES (5 MIN) | STEVENSON ST to JESSIE ST (36 - 67) | - | 90' N OF MISSION | - | - | - | - | - | 102017 | 1605876060000 | -122.40280171 | 37.78685131 | - | - | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0001 | 14X21 | SUP1 | 2IN FLANGE POST | IS | 1605779460000 | 03RD ST | 36 - 67 3RD ST | 36 - 67 03RD ST | 36 3RD ST | - | JESSIE ST | JESSIE ST |
| 84897 | N/A | Point | - | - | - | - | S204473 | STANYAN ST: 17TH ST | - | F | F | - | F | 26287000 | 26287000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | STANYAN ST | 17TH ST | 116664 | 116664 | 37.7614782 | -122.45195777 | 17TH ST \ STANYAN ST | STANYAN ST \ 17TH ST | 1710539427000 | MTA | VEH OVER 3 TONS PROHIBITED | 17TH ST intersection | - | 5'N OF BELGRAVE | - | - | - | - | - | 102018 | - | -122.45195777 | 37.7614782 | - | - | - | D5 | - | OTHER REGULATORY | REG | R36(CA).0013 | 30X30 | SUP1 | 2IN IRON POST | IS | 1396355340000 | STANYAN ST | - | - | - | - | - | - |
| 84898 | N/A | Point | 1 | 1 | 500 - 599 | - | S205042 | 500-599 MISSION ROCK ST | 500-599 MISSION ROCK ST | F | F | - | F | 15028000 | 15028000 | - | - | NORTH SIDE | - | - | - | - | 3RD ST | 03RD ST | 116665 | 116665 | 37.7728809 | -122.39054514 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM 1ST & 3RD THUR OF MONTH STCL | 03RD ST to 04TH ST (500 - 599) | - | 115FT WEST OF 3RD ST | - | - | - | - | - | 102019 | 1246406400000 | -122.39054514 | 37.7728809 | - | 1405728000000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0324 | 18X18 | SUP1 | LIGHT POLE | IS | 1398074520000 | MISSION ROCK ST | 500 - 599 MISSION ROCK ST | 500 - 599 MISSION ROCK ST | 500 MISSION ROCK ST | - | 04TH ST | 04TH ST |
| 84899 | N/A | Point | 1 | 1 | 300 - 399 | - | S203061 | 300-399 CHURCH ST | 300-399 CHURCH ST | F | F | - | F | 4011000 | 4011000 | - | - | EAST SIDE | - | - | - | - | 15TH ST | 15TH ST | 116666 | 116666 | 37.76531882 | -122.42874214 | - | - | 1746625011000 | middleware_editor | NPRK 9AM-11AM WED STCL | 15TH ST to 16TH ST (300 - 399) | - | IFO #331 | - | - | - | - | - | 102020 | - | -122.42874214 | 37.76531882 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0312 | 18X18 | SUP2 | LIGHT POLE | IS | 1392378000000 | CHURCH ST | 300 - 399 CHURCH ST | 300 - 399 CHURCH ST | 300 CHURCH ST | - | 16TH ST | 16TH ST |
| 84900 | N/A | Point | 1 | 1 | 1551 - 1599 | - | S205691 | 0-1599 MISSION ST | 1551-1599 MISSION ST | F | F | - | F | 9109102 | 9109102 | - | - | SOUTH SIDE | - | - | - | - | LAFAYETTE ST | LAFAYETTE ST | 116667 | 116667 | 37.7732357 | -122.41829936 | - | - | 1710539427000 | MTA | BIKE RACK | LAFAYETTE ST to 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE (1551 - 1599) -- SOUTH -- | - | INSTALL IN BIKE CORAL SEE MAP | - | - | - | - | - | 102021 | 1400598000000 | -122.41829936 | 37.7732357 | - | 1400544000000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | 2IN IRON POST | IS | 1399977540000 | MISSION ST | 1551 - 1599 MISSION ST | 1551 - 1599 MISSION ST | 1551 MISSION ST | - | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | 12TH ST \ OTIS ST \ SOUTH VAN NESS 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 meters