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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22876 | N/A | Point | 1 | 1 | 2400 - 2449 | - | S243281 | 2400-2449 22ND ST | 2400-2449 22ND ST | F | F | - | F | 1177000 | 1177000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SAN BRUNO AVE | SAN BRUNO AVE | 75959 | 75959 | 37.75693632 | -122.40499591 | - | - | 1713488786000 | middleware_editor | PEDESTRIAN (SYM) | SAN BRUNO AVE to UTAH ST (2400 - 2449) | - | 255'W OF SAN BRUNO AVE(ABOVE RRFB) | - | - | - | - | - | 39954 | 1520337240000 | -122.40499591 | 37.75693632 | - | 1520294400000 | - | D10 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | SIGNAL POLE | IS | 1519297320000 | 22ND ST | 2400 - 2449 22ND ST | 2400 - 2449 22ND ST | 2400 22ND ST | - | UTAH ST | UTAH ST |
| 22877 | N/A | Point | 1 | 1 | 900 - 999 | - | S246497 | 900-999 HAMPSHIRE ST | 900-999 HAMPSHIRE ST | F | F | - | F | 6654000 | 6654000 | - | - | EAST SIDE | - | - | - | - | 21ST ST | 21ST ST | 75998 | 75998 | 37.75690682 | -122.40767817 | - | - | 1710539427000 | MTA | 1 HR PRK 8AM-6PM MON-FRI EXC "W" PERMITS | 21ST ST to 22ND ST (900 - 999) | - | 25FT.SOUTH OF 21T ST | - | - | - | - | - | 39955 | 1387843200000 | -122.40767817 | 37.75690682 | - | 1578614400000 | - | D9 | - | PARKING:RPP | REG | R32C(CA).0012 | 18X21 | SUP2 | 2 POST ALUMINUM | IS | 1529582520000 | HAMPSHIRE ST | 900 - 999 HAMPSHIRE ST | 900 - 999 HAMPSHIRE ST | 900 HAMPSHIRE ST | - | 22ND ST | 22ND ST |
| 22878 | N/A | Point | - | - | - | - | S246640 | TARAVAL ST: 20TH AVE | - | T | - | - | F | 23195000 | 23195000 | - | - | NORTH WEST CORNER | - | - | - | - | TARAVAL ST | 20TH AVE | 76000 | 76000 | 37.7430929475301 | -122.476868933578 | 20TH AVE \ TARAVAL ST | TARAVAL ST \ 20TH AVE | 1741048284000 | middleware_editor | TARAVAL ST | 20TH AVE intersection | - | BETWEEN BOTH CROSSWALK RAMPS | - | - | - | - | 1 | 39956 | 1499065200000 | -122.4767646 | 37.74300263 | - | 1730843700000 | - | D4 | - | STREET NAME | GUIDE | D3-1.1706 | 36X08 | SUP2 | 3IN IRON POST | IS | 1530194100000 | TARAVAL ST | - | - | - | - | - | - |
| 22879 | N/A | Point | 1 | 1 | 1 - 34 | - | S243231 | 1-34 FAIR AVE | 1-34 FAIR AVE | F | F | - | F | 5376000 | 5376000 | - | - | NORTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 76002 | 76002 | 37.74547574 | -122.41959001 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM TUE STCL | MISSION ST to PETERS AVE (1 - 34) | - | 50FT. EAST OF MISSION ST | - | - | - | - | - | 39957 | - | -122.41959001 | 37.74547574 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0083 | 18X18 | SUP2 | 2IN IRON POST | IS | 1519200240000 | FAIR AVE | 1 - 34 FAIR AVE | 1 - 34 FAIR AVE | 1 FAIR AVE | - | PETERS AVE | PETERS AVE |
| 22880 | N/A | Point | - | - | - | - | S243283 | GREENWICH ST: HYDE ST | - | F | F | - | F | 25558000 | 25558000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GREENWICH ST | GREENWICH ST | 76003 | 76003 | 37.80106221 | -122.41942541 | HYDE ST \ GREENWICH ST | HYDE ST \ GREENWICH ST | 1710539427000 | MTA | NO OUTLET | GREENWICH ST intersection | - | X ST IS HYDE | - | - | - | - | - | 39958 | 1519257600000 | -122.41942541 | 37.80106221 | - | 1519257600000 | - | D2 | - | OTHER WARNING | WARNING | W14-2.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1519297680000 | HYDE ST | - | - | - | - | - | - |
| 22881 | N/A | Point | - | - | - | - | S246015 | MCALLISTER ST: STEINER ST | - | F | F | - | F | 26046000 | 26046000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | MCALLISTER ST | MCALLISTER ST | 76004 | 76004 | 37.77842248 | -122.43340734 | STEINER ST \ MCALLISTER ST | STEINER ST \ MCALLISTER ST | 1720661053000 | middleware_editor | FG 300 EFX DELINEATOR (Y) | MCALLISTER ST intersection | - | 25FT EAST OF CROSSWALK | - | - | - | - | - | 39959 | 1528115820000 | -122.43340734 | 37.77842248 | - | - | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | INTERSTATE BASE | IS | 1528102620000 | STEINER ST | - | - | - | - | - | - |
| 22882 | N/A | Point | - | - | - | - | S246016 | MCALLISTER ST: STEINER ST | - | F | F | - | F | 26046000 | 26046000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | MCALLISTER ST | MCALLISTER ST | 76005 | 76005 | 37.77842248 | -122.43340734 | STEINER ST \ MCALLISTER ST | STEINER ST \ MCALLISTER ST | 1720661051000 | middleware_editor | FG 300 EFX DELINEATOR (Y) | MCALLISTER ST intersection | - | 25FT EAST OF CROSSWALK | - | - | - | - | - | 39960 | 1528116180000 | -122.43340734 | 37.77842248 | - | - | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1528102620000 | STEINER ST | - | - | - | - | - | - |
| 22883 | N/A | Point | - | - | - | - | S246017 | MCALLISTER ST: STEINER ST | - | F | F | - | F | 26046000 | 26046000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | MCALLISTER ST | MCALLISTER ST | 76006 | 76006 | 37.77842248 | -122.43340734 | STEINER ST \ MCALLISTER ST | STEINER ST \ MCALLISTER ST | 1720661084000 | middleware_editor | FG 300 EFX DELINEATOR (Y) | MCALLISTER ST intersection | - | 25FT WEST OF CROSSWALK | - | - | - | - | - | 39961 | 1528117320000 | -122.43340734 | 37.77842248 | - | - | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | INTERSTATE BASE | IS | 1528102680000 | STEINER ST | - | - | - | - | - | - |
| 22884 | N/A | Point | - | - | - | - | S246018 | MCALLISTER ST: STEINER ST | - | F | F | - | F | 26046000 | 26046000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | MCALLISTER ST | MCALLISTER ST | 76007 | 76007 | 37.77842248 | -122.43340734 | STEINER ST \ MCALLISTER ST | STEINER ST \ MCALLISTER ST | 1720661082000 | middleware_editor | FG 300 EFX DELINEATOR (Y) | MCALLISTER ST intersection | - | 25FT WEST OF CROSSWALK | - | - | - | - | - | 39962 | 1528119360000 | -122.43340734 | 37.77842248 | - | - | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1528102740000 | STEINER ST | - | - | - | - | - | - |
| 22885 | N/A | Point | - | - | - | - | S246019 | MCALLISTER ST: STEINER ST | - | F | F | - | F | 26046000 | 26046000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | MCALLISTER ST | MCALLISTER ST | 76008 | 76008 | 37.77842248 | -122.43340734 | STEINER ST \ MCALLISTER ST | STEINER ST \ MCALLISTER ST | 1720661113000 | middleware_editor | STATE LAW YIELD TO PEDS (SYM) | MCALLISTER ST intersection | - | 20FT EAST OF CROSSWALK | - | - | - | - | - | 39963 | 1528117020000 | -122.43340734 | 37.77842248 | - | - | - | D5 | - | OTHER REGULATORY | REG | R1-6.0001 | 12X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1528102860000 | STEINER ST | - | - | - | - | - | - |
| 22886 | N/A | Point | - | - | - | - | S246020 | MCALLISTER ST: STEINER ST | - | F | F | - | F | 26046000 | 26046000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | MCALLISTER ST | MCALLISTER ST | 76009 | 76009 | 37.77842248 | -122.43340734 | STEINER ST \ MCALLISTER ST | STEINER ST \ MCALLISTER ST | 1720661115000 | middleware_editor | STATE LAW YIELD TO PEDS (SYM) | MCALLISTER ST intersection | - | 20FT WEST OF CROSSWALK | - | - | - | - | - | 39964 | 1528121940000 | -122.43340734 | 37.77842248 | - | - | - | D5 | - | OTHER REGULATORY | REG | R1-6.0001 | 12X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1528102860000 | STEINER ST | - | - | - | - | - | - |
| 22887 | N/A | Point | - | 1 | 1300 - 1398 | - | S246234 | 1300-1398 JUNIPERO SERRA BLVD | 1300-1398 JUNIPERO SERRA BLVD | F | F | - | F | 7710202 | 7710202 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | FONT BLVD | FONT BLVD | 76012 | 76012 | 37.71403915 | -122.47165478 | - | - | 1710539427000 | MTA | AHEAD | FONT BLVD to JUNIPERO SERRA BLVD OFF RAMP (1300 - 1398) -- WEST -- | - | EASTBOUND OFFRAMP TO BROTHERHOOD WY | - | - | - | - | - | 39965 | 1528453800000 | -122.47165478 | 37.71403915 | - | - | - | D7 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP2 | 2IN IRON POST | IS | 1528443360000 | JUNIPERO SERRA BLVD | 1300 - 1398 JUNIPERO SERRA BLVD | 1300 - 1398 JUNIPERO SERRA BLVD | 1300 JUNIPERO SERRA BLVD | - | JUNIPERO SERRA BLVD OFF RAMP | JUNIPERO SERRA BLVD OFF RAMP |
| 22888 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S246351 | 2300-2399 BRODERICK ST | 2300-2399 BRODERICK ST | F | F | - | F | 3210000 | 3210000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | JACKSON ST | JACKSON ST | 76013 | 76013 | 37.79185797 | -122.44291577 | - | - | 1710539427000 | MTA | SCHOOL (SYM) | JACKSON ST to PACIFIC AVE (2300 - 2399) | - | NPL#2207 | - | - | - | - | - | 39966 | 1529936640000 | -122.44291577 | 37.79185797 | - | - | - | D2 | - | SCHOOL | WARNING | S1-1.0001 | 24X24 | SUP1 | 2IN IRON POST | IS | 1528887120000 | BRODERICK ST | 2300 - 2399 BRODERICK ST | 2300 - 2399 BRODERICK ST | 2300 BRODERICK ST | - | PACIFIC AVE | PACIFIC AVE |
| 22889 | N/A | Point | 1 | 1 | 3400 - 3499 | - | S148837 | 3400-3499 OCEAN AVE | 3400-3499 OCEAN AVE | F | F | - | F | 9858000 | 9858000 | - | - | SOUTH SIDE | - | - | - | - | 26TH AVE | 26TH AVE | 77631 | 77631 | 37.73241298 | -122.48231344 | - | - | 1748014291000 | middleware_editor | NPRK 12NN-2PM 2ND & 4TH TUE OF MONTH STCL | 26TH AVE to INVERNESS DR (3400 - 3499) | - | 3445 OCEAN | - | - | - | - | - | 39967 | 1225090800000 | -122.48231344 | 37.73241298 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0074 | 18X18 | SUP2 | LIGHT POLE | IS | 1375729020000 | OCEAN AVE | 3400 - 3499 OCEAN AVE | 3400 - 3499 OCEAN AVE | 3400 OCEAN AVE | - | INVERNESS DR | INVERNESS DR |
| 22890 | N/A | Point | 1 | 1 | 300 - 399 | - | S149385 | 300-399 SANTA ANA AVE | 300-399 SANTA ANA AVE | F | F | - | F | 11566000 | 11566000 | - | - | EAST SIDE | - | - | - | - | DARIEN WAY | DARIEN WAY | 77633 | 77633 | 37.73067236 | -122.46807536 | - | - | 1710539427000 | MTA | NPRK 11AM-1PM 2ND & 4TH THUR OF MONTH STCL | DARIEN WAY to OCEAN AVE (300 - 399) | - | 307 SANTA ANA | - | - | - | - | - | 39968 | 1225152000000 | -122.46807536 | 37.73067236 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0023 | 18X18 | SUP2 | LIGHT POLE | IS | 1375729260000 | SANTA ANA AVE | 300 - 399 SANTA ANA AVE | 300 - 399 SANTA ANA AVE | 300 SANTA ANA AVE | - | OCEAN AVE | OCEAN AVE |
| 22891 | N/A | Point | - | - | - | - | S248441 | HAIGHT ST: DIVISADERO ST | - | F | F | - | F | 26026000 | 26026000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HAIGHT ST | DIVISADERO ST | 77644 | 77644 | 37.77126742 | -122.43704561 | DIVISADERO ST \ HAIGHT ST | HAIGHT ST \ DIVISADERO ST | 1710539427000 | MTA | EXCEPT MUNI | DIVISADERO ST intersection | - | 0 / 0 | - | - | - | - | - | 39969 | 400723200000 | -122.43704561 | 37.77126742 | - | 1537488000000 | - | D5 | - | OTHER REGULATORY | REG | R(SF).0357 | 30X08 | SUP1 | SIGNAL POLE | IS | 1537534500000 | HAIGHT ST | - | - | - | - | - | - |
| 22892 | N/A | Point | - | - | - | - | S248721 | GEARY BLVD: LAGUNA ST | - | T | T | - | F | 26514000 | 26514000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LAGUNA ST | GEARY BLVD | 77645 | 77645 | 37.78495388 | -122.42798893 | GEARY BLVD \ LAGUNA ST | LAGUNA ST \ GEARY BLVD | 1740681335000 | evillan | BUS LANE AHEAD | GEARY BLVD intersection | - | - | - | - | - | - | - | 39970 | 1538493600000 | -122.42798893 | 37.78495388 | - | - | - | D5 | - | OTHER REGULATORY | REG | R3-12F.0001 | 30X36 | SUP1 | OVERHEAD MAST ARM | IS | 1538388000000 | LAGUNA ST | - | - | - | - | - | - |
| 22893 | N/A | Point | - | - | - | - | S219595 | 6TH AVE: ANZA ST | - | F | F | - | F | 27275000 | 27275000 | - | - | NORTH WEST CORNER | - | - | - | - | ANZA ST | 06TH AVE | 77660 | 77660 | 37.77909073 | -122.46414497 | 6TH AVE \ ANZA ST | ANZA ST \ 06TH AVE | 1710539427000 | MTA | ANZA ST | 06TH AVE intersection | - | - | - | - | - | - | - | 39971 | - | -122.46414497 | 37.77909073 | - | - | - | D1 | - | STREET NAME | GUIDE | D3-1.0111 | 36X08 | SUP2 | 3IN IRON POST | IS | 1443524520000 | ANZA ST | - | - | - | - | - | - |
| 22894 | N/A | Point | 1 | 1 | 800 - 999 | - | S219518 | 800-999 GOLDEN GATE AVE | 800-999 GOLDEN GATE AVE | F | F | - | F | 6268000 | 6268000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | GOUGH ST | GOUGH ST | 77661 | 77661 | 37.78040233 | -122.42537387 | - | - | 1742423239000 | middleware_editor | YIELD HERE TO PED (SYM) (LA) | GOUGH ST to LAGUNA ST (800 - 999) | - | X ST IS OCTAVIA 40' WEST OF MID XWALK | - | - | - | - | - | 39972 | 1443738600000 | -122.42537387 | 37.78040233 | - | 1443682800000 | 1742419800000 | D5 | - | PEDESTRIAN | REG | R1-5.0002 | 30X30 | SUP1 | 2IN IRON POST | RETD | 1443170580000 | GOLDEN GATE AVE | 800 - 999 GOLDEN GATE AVE | 800 - 999 GOLDEN GATE AVE | 800 GOLDEN GATE AVE | - | LAGUNA ST | LAGUNA ST |
| 22895 | N/A | Point | - | - | - | - | S219506 | VALLEJO ST: GRANT AVE | - | F | F | - | F | 25325000 | 25325000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VALLEJO ST | VALLEJO ST | 77662 | 77662 | 37.79877631 | -122.40720639 | GRANT AVE \ VALLEJO ST | GRANT AVE \ VALLEJO ST | 1712353801000 | middleware_editor | DO NOT ENTER | VALLEJO ST intersection | - | - | - | - | - | - | - | 39973 | - | -122.40720639 | 37.79877631 | - | - | 1712328540000 | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | LIGHT POLE | RETD | 1443102840000 | GRANT AVE | - | - | - | - | - | - |
| 22896 | N/A | Point | 1 | 1 | 100 - 199 | RIGHT ARROW | S219537 | 100-199 SPEAR ST | 100-199 SPEAR ST | F | F | - | F | 12045000 | 12045000 | - | - | WEST SIDE | - | - | - | - | MISSION ST | MISSION ST | 77664 | 77664 | 37.7919241 | -122.39329212 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7AM-7PM MON-SAT (5 MIN) | MISSION ST to HOWARD ST (100 - 199) | - | 81' SOUTH OF NPL #150 | - | - | - | - | - | 39974 | 1446636540000 | -122.39329212 | 37.7919241 | - | 1526428800000 | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0014 | 14X21 | SUP1 | 2IN IRON POST | IS | 1443184440000 | SPEAR ST | 100 - 199 SPEAR ST | 100 - 199 SPEAR ST | 100 SPEAR ST | - | HOWARD ST | HOWARD ST |
| 22897 | N/A | Point | 1 | 1 | 1 - 99 | - | S251331 | 1-99 LOCKSLEY AVE | 1-99 LOCKSLEY AVE | F | F | - | F | 8419000 | 8419000 | - | - | EAST SIDE | - | - | - | - | 6TH AVE | 06TH AVE | 77668 | 77668 | 37.75920833 | -122.46323151 | - | - | 1736280528000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "J" PERMITS | 06TH AVE to WARREN DR (1 - 99) | - | 5FT SOUTH OF DRIVEWAY TO #8 | - | - | - | - | - | 39975 | 1224201600000 | -122.46323151 | 37.75920833 | - | 1549929600000 | - | D7 | - | PARKING:RPP | REG | R32C(CA).0091 | 18X21 | SUP2 | LIGHT POLE | IS | 1549360140000 | LOCKSLEY AVE | 1 - 99 LOCKSLEY AVE | 1 - 99 LOCKSLEY AVE | 1 LOCKSLEY AVE | - | WARREN DR | WARREN DR |
| 22898 | N/A | Point | 1 | 1 | 300 - 399 | - | S251349 | 300-399 SAN FERNANDO WAY | 300-399 SAN FERNANDO WAY | F | F | - | F | 11415000 | 11415000 | - | - | EAST SIDE | - | - | - | - | DARIEN WAY | DARIEN WAY | 77669 | 77669 | 37.73107194 | -122.46976566 | - | - | 1738011994000 | middleware_editor | NPRK 7AM-8AM MON STCL | DARIEN WAY to OCEAN AVE (300 - 399) | - | IFO 309 | - | - | - | - | - | 39976 | 1225065600000 | -122.46976566 | 37.73107194 | - | 1549843200000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0211 | 18X18 | SUP2 | LIGHT POLE | IS | 1549373100000 | SAN FERNANDO WAY | 300 - 399 SAN FERNANDO WAY | 300 - 399 SAN FERNANDO WAY | 300 SAN FERNANDO WAY | - | OCEAN AVE | OCEAN AVE |
| 22899 | N/A | Point | - | - | - | - | S251398 | VICENTE ST: 47TH AVE | - | F | F | - | F | 23500000 | 23500000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | VICENTE ST | 47TH AVE | 77670 | 77670 | 37.73800399 | -122.50542866 | 47TH AVE \ VICENTE ST | VICENTE ST \ 47TH AVE | 1726017559000 | middleware_editor | BIKE WAYFINDING SIGN | 47TH AVE intersection | 0315 | UP ON RAISED BIKE PATH SEE NOTES | - | - | - | - | - | 39977 | 1549966080000 | -122.50542866 | 37.73800399 | - | - | - | D4 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | 2IN IRON POST | IS | 1549517940000 | VICENTE ST | - | - | - | - | - | - |
| 22900 | N/A | Point | - | - | - | - | S251401 | GREAT HWY: SLOAT BLVD | - | F | F | - | F | 32904000 | 32904000 | - | - | SOUTH WEST CORNER | - | - | - | - | SLOAT BLVD | GREAT HWY | 77673 | 77673 | 37.7354155741787 | -122.506892681117 | GREAT HWY \ SLOAT BLVD | SLOAT BLVD \ GREAT HWY | 1738353017000 | middleware_editor | BIKE WAYFINDING SIGN | GREAT HWY intersection | 0317 | - | - | - | - | - | - | 39978 | 1549881840000 | -122.50671743 | 37.73546976 | - | - | - | D7 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | SIGNAL POLE | IS | 1549519020000 | SLOAT BLVD | - | - | - | - | - | - |
| 22901 | N/A | Point | - | - | - | - | S251402 | SLOAT BLVD: 47TH AVE | - | F | F | - | F | 11964201 | 23493000 | - | - | SOUTH SIDE | - | - | - | - | 47TH AVE | 47TH AVE | 77674 | 77674 | 37.7356298163436 | -122.505780570204 | - | SLOAT BLVD \ 47TH AVE | 1754345814000 | middleware_editor | BIKE WAYFINDING SIGN | 47TH AVE intersection | 0319 | 110' W OF 47TH AVE | - | - | - | - | - | 39979 | 1549910760000 | -122.50525735 | 37.73547529 | - | - | - | D7 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | 2IN IRON POST | IS | 1549519500000 | SLOAT BLVD | 2900 - 2998 SLOAT BLVD | - | - | - | GREAT HWY | - |
| 22902 | N/A | Point | 1 | 1 | 700 - 738 | - | S253698 | 700-738 HURON AVE | 700-738 HURON AVE | F | F | - | F | 7106000 | 7106000 | - | - | WEST SIDE | - | - | - | - | WHIPPLE AVE | WHIPPLE AVE | 78265 | 78265 | 37.71195115 | -122.4497105 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM TUE STCL | WHIPPLE AVE to MILAN TER (700 - 738) | - | SPL 742 | - | - | - | - | - | 39980 | 1582810800000 | -122.4497105 | 37.71195115 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0270 | 18X18 | SUP2 | 2IN IRON POST | IS | 1555946520000 | HURON AVE | 700 - 738 HURON AVE | 700 - 738 HURON AVE | 700 HURON AVE | - | MILAN TER | MILAN TER |
| 22903 | N/A | Point | - | - | - | - | S235588 | DIVISADERO ST: SUTTER ST | - | F | F | - | F | 26624000 | 26624000 | - | - | SOUTH WEST CORNER | - | - | - | - | SUTTER ST | DIVISADERO ST | 66543 | 66543 | 37.78524753 | -122.43987261 | DIVISADERO ST \ SUTTER ST | SUTTER ST \ DIVISADERO ST | 1710539427000 | MTA | SUTTER ST | DIVISADERO ST intersection | - | - | - | - | - | - | - | 39981 | 1506958680000 | -122.43987261 | 37.78524753 | - | 1506902400000 | - | D2 | - | STREET NAME | GUIDE | D3-1.1694 | 36X08 | SUP1 | SIGNAL POLE | IS | 1493118900000 | SUTTER ST | - | - | - | - | - | - |
| 22904 | N/A | Point | - | - | - | - | S235591 | DIVISADERO ST: SUTTER ST | - | T | T | - | F | 26624000 | 26624000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SUTTER ST | DIVISADERO ST | 66544 | 66544 | 37.78524753 | -122.43987261 | DIVISADERO ST \ SUTTER ST | SUTTER ST \ DIVISADERO ST | 1710539427000 | MTA | DIVISADERO ST | DIVISADERO ST intersection | - | - | - | - | - | - | - | 39982 | 1504278960000 | -122.43987261 | 37.78524753 | - | 1504224000000 | - | D2 | - | STREET NAME | GUIDE | D3-2.0131 | 72X18 | SUP1 | SIGNAL POLE | IS | 1493119380000 | SUTTER ST | - | - | - | - | - | - |
| 22905 | N/A | Point | - | - | - | - | S235600 | DIVISADERO ST: SACRAMENTO ST | - | T | T | - | F | 26821000 | 26821000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 66545 | 66545 | 37.78899526 | -122.44062362 | SACRAMENTO ST \ DIVISADERO ST | SACRAMENTO ST \ DIVISADERO ST | 1746733288000 | middleware_editor | SACRAMENTO ST | DIVISADERO ST intersection | - | DIVISADERO (2100) | - | - | - | - | - | 39983 | 1504737060000 | -122.44062362 | 37.78899526 | - | 1504681200000 | - | D2 | - | STREET NAME | GUIDE | D3-2.0298 | 72X18 | SUP1 | MUNI POLE | IS | 1493122860000 | SACRAMENTO ST | - | - | - | - | - | - |
| 22906 | N/A | Point | 1 | 1 | 1900 - 1949 | - | S227150 | 1900-1949 SUTTER ST | 1900-1949 SUTTER ST | T | T | - | F | 12337000 | 12337000 | - | - | SOUTH SIDE | - | - | - | - | WEBSTER ST | WEBSTER ST | 66547 | 66547 | 37.78626291 | -122.43187473 | - | - | 1710539427000 | MTA | PREVENT THEFT REMOVE VALUABLES LOCK YOUR CAR | WEBSTER ST to COTTAGE ROW (1900 - 1949) | - | IFO# 1945 SUTTER ST. | - | - | - | - | - | 39984 | 1469028600000 | -122.43187473 | 37.78626291 | - | 1468972800000 | - | D5 | - | OTHER REGULATORY | REG | SR(SF).0052 | 18X21 | SUP1 | MUNI POLE | IS | 1467970740000 | SUTTER ST | 1900 - 1949 SUTTER ST | 1900 - 1949 SUTTER ST | 1900 SUTTER ST | - | COTTAGE ROW | COTTAGE ROW |
| 22907 | N/A | Point | 1 | 1 | 10 - 98 | RIGHT ARROW | S234878 | 0-199 SOUTH PARK | 10-98 SOUTH PARK | F | F | - | F | 12009101 | 12009101 | - | - | CENTER ISLAND | - | - | - | - | SOUTH PARK | SOUTH PARK | 66627 | 66627 | 37.781975 | -122.39369893 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM FRI STCL | SOUTH PARK to JACK LONDON ALY (10 - 98) -- NORTH -- | - | OPP #86 | - | - | - | - | - | 39985 | 1494342660000 | -122.39369893 | 37.781975 | - | 1494288000000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0046 | 18X18 | SUP1 | 2IN IRON POST | IS | 1491312960000 | SOUTH PARK | 10 - 98 SOUTH PARK | 10 - 98 SOUTH PARK | 10 SOUTH PARK | - | JACK LONDON ALY | JACK LONDON ALY |
| 22908 | N/A | Point | - | - | - | - | S230612 | 21ST ST: CAPP ST | - | F | F | - | F | 24084000 | 24084000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CAPP ST | 21ST ST | 66634 | 66634 | 37.75710093 | -122.4178119 | 21ST ST \ CAPP ST | CAPP ST \ 21ST ST | 1718224789000 | middleware_editor | ALL WAY | 21ST ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 39986 | 33350400000 | -122.4178119 | 37.75710093 | - | 1497657600000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1478102100000 | CAPP ST | - | - | - | - | - | - |
| 22909 | N/A | Point | - | - | - | - | S230613 | 21ST ST: CAPP ST | - | F | F | - | F | 24084000 | 24084000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CAPP ST | 21ST ST | 66635 | 66635 | 37.75710093 | -122.4178119 | 21ST ST \ CAPP ST | CAPP ST \ 21ST ST | 1718253566000 | middleware_editor | ALL WAY | 21ST ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 39987 | 33350400000 | -122.4178119 | 37.75710093 | - | 1497657600000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1478102220000 | CAPP ST | - | - | - | - | - | - |
| 22910 | N/A | Point | - | - | - | - | S230615 | CAPP ST: 21ST ST | - | F | F | - | F | 24084000 | 24084000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CAPP ST | 21ST ST | 66637 | 66637 | 37.75710093 | -122.4178119 | 21ST ST \ CAPP ST | CAPP ST \ 21ST ST | 1718224793000 | middleware_editor | ALL WAY | 21ST ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 39988 | -165196800000 | -122.4178119 | 37.75710093 | - | 1582588800000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1478103360000 | CAPP ST | - | - | - | - | - | - |
| 22911 | N/A | Point | - | - | - | - | S228987 | TURK ST: SEYMOUR ST | - | F | F | - | F | 26078000 | 26078000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TURK ST | TURK ST | 66639 | 66639 | 37.77976495 | -122.43789453 | SEYMOUR ST \ TURK ST | SEYMOUR ST \ TURK ST | 1733866912000 | middleware_editor | TWO WAY TRAFFIC AHEAD | TURK ST intersection | - | - | - | - | - | - | - | 39989 | - | -122.43789453 | 37.77976495 | - | - | - | D5 | - | OTHER REGULATORY | REG | R40(CA).0001 | 24X30 | SUP1 | LIGHT POLE | IS | 1474040520000 | SEYMOUR ST | - | - | - | - | - | - |
| 22912 | N/A | Point | - | 1 | 200 - 216 | - | S231526 | 200-216 DIVISION ST | 200-216 DIVISION ST | F | F | - | F | 4845000 | 4844000 | - | - | NORTH SIDE | - | - | - | - | UTAH ST | 09TH ST | 67373 | 67373 | 37.7693547 | -122.40653685 | - | - | 1710539427000 | MTA | TANSAT | 09TH ST to UTAH ST (200 - 216) | - | 80' EAST OF BRANNAN | - | - | - | - | - | 39990 | 1481500800000 | -122.40653685 | 37.7693547 | - | 1578528000000 | - | D10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1481021580000 | DIVISION ST | 217 - 299 DIVISION ST | 200 - 216 DIVISION ST | 200 DIVISION ST | - | 10TH ST \ BRANNAN ST \ POTRERO AVE | UTAH ST |
| 22913 | N/A | Point | - | - | - | - | S230835 | 22ND ST: RHODE ISLAND ST | - | F | F | - | F | 23711000 | 23711000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | RHODE ISLAND ST | 22ND ST | 67374 | 67374 | 37.75712085 | -122.40183251 | 22ND ST \ RHODE ISLAND ST | RHODE ISLAND ST \ 22ND ST | 1731538193000 | middleware_editor | ALL WAY | 22ND ST intersection | - | MADE ALL-WAY STOP | - | - | - | - | - | 39991 | 792028800000 | -122.40183251 | 37.75712085 | - | 1731495000000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1478769420000 | RHODE ISLAND ST | - | - | - | - | - | - |
| 22914 | N/A | Point | - | - | - | - | S232736 | TARAVAL ST: 19TH AVE | - | T | T | - | F | 23183000 | 23183000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 19TH AVE | 67375 | 67375 | 37.74305181 | -122.47564447 | 19TH AVE \ TARAVAL ST | TARAVAL ST \ 19TH AVE | 1723769852000 | middleware_editor | LEFT LANE MUNI TAXIS ONLY | 19TH AVE intersection | - | 30`EAST OF 20TH AVE | - | - | - | - | - | 39992 | 1486993440000 | -122.47564447 | 37.74305181 | - | 1486944000000 | - | D4 | - | TRANSIT ONLY(LEFT LANE) | REG | SR60-4(SF).0001 | 30X42 | SUP2 | MUNI POLE | IS | 1484822220000 | TARAVAL ST | - | - | - | - | - | - |
| 22915 | N/A | Point | - | - | - | - | S232739 | TARAVAL ST: 19TH AVE | - | T | T | - | F | 23183000 | 23183000 | - | - | SOUTH SIDE | - | - | - | - | TARAVAL ST | 19TH AVE | 67376 | 67376 | 37.74305181 | -122.47564447 | 19TH AVE \ TARAVAL ST | TARAVAL ST \ 19TH AVE | 1722992923000 | middleware_editor | TANSAT | 19TH AVE intersection | - | IFO#917 | - | - | - | - | - | 39993 | 1485431340000 | -122.47564447 | 37.74305181 | - | 1485388800000 | - | D4 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | MUNI POLE | IS | 1484823480000 | TARAVAL ST | - | - | - | - | - | - |
| 22916 | N/A | Point | - | - | - | LEFT ARROW | S232740 | TARAVAL ST: 19TH AVE | - | T | T | - | F | 23183000 | 23183000 | - | - | SOUTH SIDE | - | - | - | - | TARAVAL ST | 19TH AVE | 67377 | 67377 | 37.74305181 | -122.47564447 | 19TH AVE \ TARAVAL ST | TARAVAL ST \ 19TH AVE | 1722992925000 | middleware_editor | NPRK 2AM-6AM MON WED FRI SAT STCL | 19TH AVE intersection | - | 32`WEST | - | - | - | - | - | 39994 | - | -122.47564447 | 37.74305181 | - | - | - | D4 | - | STREET CLEANING | REG | R30B(CA).0121 | 18X18 | SUP2 | MUNI POLE | IS | 1484824140000 | TARAVAL ST | - | - | - | - | - | - |
| 22917 | N/A | Point | - | - | - | - | S232743 | TARAVAL ST: 18TH AVE | - | T | T | - | F | 23182000 | 23182000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 18TH AVE | 67378 | 67378 | 37.74309662 | -122.47462383 | 18TH AVE \ TARAVAL ST | TARAVAL ST \ 18TH AVE | 1716416629000 | middleware_editor | LEFT LANE TRAINS LEFT TURNS ONLY 24 HOURS | 18TH AVE intersection | - | IFO#823 | - | - | - | - | - | 39995 | 1487251620000 | -122.47462383 | 37.74309662 | - | 1487203200000 | - | D7 | - | OTHER REGULATORY | REG | SR60-4(SF).0002 | 30X42 | SUP2 | 2IN IRON POST | IS | 1484825940000 | TARAVAL ST | - | - | - | - | - | - |
| 22918 | N/A | Point | - | - | - | - | S232745 | TARAVAL ST: 17TH AVE | - | T | T | - | F | 768000 | 23179000 | - | - | WEST SIDE | - | - | - | - | SANTIAGO ST | 17TH AVE | 67379 | 67379 | 37.74314359 | -122.47355342 | - | TARAVAL ST \ 17TH AVE | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "O" PERMITS | 17TH AVE intersection | - | 45`SOUTH | - | - | - | - | - | 39996 | - | -122.47355342 | 37.74314359 | - | - | - | D7 | - | PARKING:RPP | REG | R32C(CA).0097 | 18X21 | SUP2 | 2IN IRON POST | IS | 1484826660000 | TARAVAL ST | 2300 - 2399 17TH AVE | - | - | - | TARAVAL ST | - |
| 22919 | N/A | Point | 1 | 1 | 700 - 746 | - | S233820 | 700-746 GREEN ST | 700-746 GREEN ST | F | F | - | F | 6455000 | 6455000 | - | - | SOUTH SIDE | - | - | - | - | POWELL ST | POWELL ST | 67380 | 67380 | 37.79925263 | -122.41104177 | - | - | 1729214216000 | middleware_editor | NPRK ANY TIME | POWELL ST to AUGUST ALY (700 - 746) | - | 45`WEST | - | - | - | - | - | 39997 | - | -122.41104177 | 37.79925263 | - | - | - | D3 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1487756220000 | GREEN ST | 700 - 746 GREEN ST | 700 - 746 GREEN ST | 700 GREEN ST | - | AUGUST ALY | AUGUST ALY |
| 22920 | N/A | Point | 1 | 1 | 700 - 746 | - | S233821 | 700-746 GREEN ST | 700-746 GREEN ST | F | F | - | F | 6455000 | 6455000 | - | - | SOUTH SIDE | - | - | - | - | POWELL ST | POWELL ST | 67381 | 67381 | 37.79925263 | -122.41104177 | - | - | 1729175674000 | middleware_editor | NPRK ANY TIME | POWELL ST to AUGUST ALY (700 - 746) | - | 150``WEST | - | - | - | - | - | 39998 | - | -122.41104177 | 37.79925263 | - | - | - | D3 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1487756400000 | GREEN ST | 700 - 746 GREEN ST | 700 - 746 GREEN ST | 700 GREEN ST | - | AUGUST ALY | AUGUST ALY |
| 22921 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S233824 | 1500-1599 BEACH ST | 1500-1599 BEACH ST | F | F | - | F | 2849000 | 2849000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | BUCHANAN ST \ LOWER FORT MASON ST \ MARINA BLVD | BUCHANAN ST \ LOWER FORT MASON ST \ MARINA BLVD | 67382 | 67382 | 37.80486439 | -122.43455978 | - | - | 1728349909000 | middleware_editor | STOP | BUCHANAN ST \ LOWER FORT MASON ST \ MARINA BLVD to WEBSTER ST (1500 - 1599) | - | - | - | - | - | - | - | 39999 | 1488549480000 | -122.43455978 | 37.80486439 | - | 1488499200000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1487760720000 | BEACH ST | 1500 - 1599 BEACH ST | 1500 - 1599 BEACH ST | 1500 BEACH ST | - | WEBSTER ST | WEBSTER ST |
| 22922 | N/A | Point | - | - | - | - | S233825 | BEACH ST: BUCHANAN ST \ LOWER | - | F | F | - | F | 26758000 | 26758000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST | BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST | 67383 | 67383 | 37.80504329 | -122.43379794 | MARINA BLVD \ BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST | MARINA BLVD \ BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST | 1710539427000 | MTA | RIGHT TURN ONLY (SYM) | BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST intersection | - | - | - | - | - | - | - | 40000 | 1489492200000 | -122.43379794 | 37.80504329 | - | 1489449600000 | - | D2 | - | OTHER REGULATORY | REG | R3-5.0001 | 24X30 | SUP1 | 2IN IRON POST | IS | 1487760900000 | MARINA BLVD | - | - | - | - | - | - |
| 22923 | N/A | Point | - | - | - | - | S233826 | BEACH ST: BUCHANAN ST \ LOWER | - | F | F | - | F | 26758000 | 26758000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST | BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST | 67384 | 67384 | 37.80504329 | -122.43379794 | MARINA BLVD \ BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST | MARINA BLVD \ BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST | 1710539427000 | MTA | STOP | BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST intersection | - | - | - | - | - | - | - | 40001 | 1488549660000 | -122.43379794 | 37.80504329 | - | 1488499200000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1487761080000 | MARINA BLVD | - | - | - | - | - | - |
| 22924 | N/A | Point | 1 | 1 | 537 - 558 | - | S234807 | 537-558 BROADWAY | 537-558 BROADWAY | T | T | - | F | 3152000 | 3152000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | ROMOLO ST | ROMOLO ST | 67385 | 67385 | 37.79789244 | -122.40644966 | - | - | 1710539427000 | MTA | (VA) NORTH BEACH GARAGE | ROMOLO ST to COLUMBUS AVE (537 - 558) | - | IFO#554 | - | - | - | - | - | 40002 | 1497621780000 | -122.40644966 | 37.79789244 | - | 1497571200000 | - | D3 | - | OTHER GUIDE | GUIDE | G-P(SF).0142 | 30X30 | SUP1 | LIGHT POLE | IS | 1491212820000 | BROADWAY | 537 - 558 BROADWAY | 537 - 558 BROADWAY | 537 BROADWAY | - | COLUMBUS AVE | COLUMBUS AVE |
| 22925 | N/A | Point | 1 | 1 | 400 - 499 | - | S234808 | 400-499 COLUMBUS AVE | 400-499 COLUMBUS AVE | T | T | - | F | 4294000 | 4294000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | VALLEJO ST | VALLEJO ST | 67386 | 67386 | 37.79909334 | -122.40844194 | - | - | 1754324728000 | middleware_editor | (VA) NORTH BEACH GARAGE | VALLEJO ST to GREEN ST \ STOCKTON ST (400 - 499) | - | OPP#468 @ CAFFE GRECO | - | - | - | - | - | 40003 | 1497379500000 | -122.40844194 | 37.79909334 | - | 1497337200000 | - | D3 | - | OTHER GUIDE | GUIDE | G-P(SF).0142 | 30X30 | SUP1 | LIGHT POLE | IS | 1491213480000 | COLUMBUS AVE | 400 - 499 COLUMBUS AVE | 400 - 499 COLUMBUS AVE | 400 COLUMBUS AVE | - | GREEN ST \ STOCKTON ST | GREEN ST \ STOCKTON ST |
| 22926 | N/A | Point | 1 | 1 | 500 - 599 | - | S234810 | 500-599 COLUMBUS AVE | 500-599 COLUMBUS AVE | F | F | - | F | 4295000 | 4295000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | GREEN ST \ STOCKTON ST | GREEN ST \ STOCKTON ST | 67387 | 67387 | 37.79990266 | -122.40961046 | - | - | 1710539427000 | MTA | (VA) NORTH BEACH GARAGE | GREEN ST \ STOCKTON ST to UNION ST (500 - 599) | - | IFO#527 | - | - | - | - | - | 40004 | 1497354600000 | -122.40961046 | 37.79990266 | - | 1497312000000 | - | D3 | - | OTHER GUIDE | GUIDE | G-P(SF).0142 | 30X30 | SUP1 | LIGHT POLE | IS | 1491213840000 | COLUMBUS AVE | 500 - 599 COLUMBUS AVE | 500 - 599 COLUMBUS AVE | 500 COLUMBUS AVE | - | UNION ST | UNION ST |
| 22927 | N/A | Point | 1 | 1 | 1200 - 1246 | - | S234814 | 1200-1246 STOCKTON ST | 1200-1246 STOCKTON ST | F | F | - | F | 12208000 | 12208000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | PACIFIC AVE | PACIFIC AVE | 67389 | 67389 | 37.79701555 | -122.40849431 | - | - | 1710539427000 | MTA | (VA) NORTH BEACH GARAGE | PACIFIC AVE to STARK ST (1200 - 1246) | - | OPP#1151 | - | - | - | - | - | 40005 | 1497966840000 | -122.40849431 | 37.79701555 | - | 1497916800000 | - | D3 | - | OTHER GUIDE | GUIDE | G-P(SF).0142 | 30X30 | SUP1 | LIGHT POLE | IS | 1491217260000 | STOCKTON ST | 1200 - 1246 STOCKTON ST | 1200 - 1246 STOCKTON ST | 1200 STOCKTON ST | - | STARK ST | STARK ST |
| 22928 | N/A | Point | 1 | 1 | 1000 - 1010 | - | S235371 | 1000-1010 INNES AVE | 1000-1010 INNES AVE | F | F | - | F | 7257000 | 7257000 | - | - | NORTH SIDE | - | - | - | - | HAWES ST | HAWES ST | 68027 | 68027 | 37.73327012 | -122.37800134 | - | - | 1750713440000 | middleware_editor | NPRK 8AM-10AM THUR STCL | HAWES ST to MARIST CT (1000 - 1010) | - | 50'WEST | - | - | - | - | - | 40006 | 1099468800000 | -122.37800134 | 37.73327012 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0267 | 18X18 | SUP1 | 2IN IRON POST | IS | 1492594440000 | INNES AVE | 1000 - 1010 INNES AVE | 1000 - 1010 INNES AVE | 1000 INNES AVE | - | MARIST CT | MARIST CT |
| 22929 | N/A | Point | - | - | - | RIGHT ARROW | S232249 | BENTON AVE: ANDOVER ST | - | F | F | - | F | 21193000 | 21193000 | - | - | SOUTH WEST CORNER | - | - | - | - | ANDOVER ST | BENTON AVE | 68028 | 68028 | 37.73392836 | -122.41691183 | BENTON AVE \ ANDOVER ST | ANDOVER ST \ BENTON AVE | 1710539427000 | MTA | TANSAT | BENTON AVE intersection | - | OF BENTON AVE & ANDOVER ST. | - | - | - | - | - | 40007 | 1485249300000 | -122.41691183 | 37.73392836 | - | 1485216000000 | - | D9 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | 1483440360000 | ANDOVER ST | - | - | - | - | - | - |
| 22930 | N/A | Point | - | - | - | - | S232250 | BENTON AVE: ANDOVER ST | - | F | F | - | F | 21193000 | 21193000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ANDOVER ST | BENTON AVE | 68029 | 68029 | 37.73392836 | -122.41691183 | BENTON AVE \ ANDOVER ST | ANDOVER ST \ BENTON AVE | 1710539427000 | MTA | STOP | BENTON AVE intersection | - | OF BENTON AVE & ANDOVER ST. | - | - | - | - | - | 40008 | - | -122.41691183 | 37.73392836 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1483440780000 | ANDOVER ST | - | - | - | - | - | - |
| 22931 | N/A | Point | - | 1 | 600 - 699 | LEFT ARROW | S232252 | 600-699 BENTON AVE | 600-699 BENTON AVE | F | F | - | F | 2933000 | 2933000 | - | - | SOUTH SIDE | - | - | - | - | BACHE ST | BACHE ST | 68030 | 68030 | 37.73392319 | -122.41724198 | - | - | 1710539427000 | MTA | TANSAT | BACHE ST to ANDOVER ST (600 - 699) | - | (LA) SIGN 70FT. WEST OF ANDOVER ST. | - | - | - | - | - | 40009 | 1485256980000 | -122.41724198 | 37.73392319 | - | 1485216000000 | - | D9 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | 1483441020000 | BENTON AVE | 600 - 699 BENTON AVE | 600 - 699 BENTON AVE | 600 BENTON AVE | - | ANDOVER ST | ANDOVER ST |
| 22932 | N/A | Point | - | 1 | 100 - 199 | - | S228235 | 100-199 VALENCIA ST | 100-199 VALENCIA ST | F | F | - | F | 13053000 | 13053000 | - | - | WEST SIDE | - | - | - | - | MCCOPPIN ST | MCCOPPIN ST | 68032 | 68032 | 37.77073141 | -122.42244558 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM MON WED FRI STCL | MCCOPPIN ST to DUBOCE AVE (100 - 199) | - | NPL# 150 | - | - | - | - | - | 40010 | 1472473920000 | -122.42244558 | 37.77073141 | - | 1472428800000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0192 | 18X18 | SUP1 | LIGHT POLE | IS | 1471603500000 | VALENCIA ST | 100 - 199 VALENCIA ST | 100 - 199 VALENCIA ST | 100 VALENCIA ST | - | DUBOCE AVE | DUBOCE AVE |
| 22933 | N/A | Point | 1 | 1 | 1 - 99 | - | S228245 | 1-99 BUCHANAN ST | 1-99 BUCHANAN ST | F | F | - | F | 3321000 | 3321000 | - | - | WEST SIDE | - | - | - | - | DUBOCE AVE \ MARKET ST | DUBOCE AVE \ MARKET ST | 68033 | 68033 | 37.77008316 | -122.42663564 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM FRI STCL | DUBOCE AVE \ MARKET ST to HERMANN ST (1 - 99) | - | OPNPL#40 | - | - | - | - | - | 40011 | 1585827300000 | -122.42663564 | 37.77008316 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0076 | 18X18 | SUP2 | 2IN IRON POST | IS | 1471605360000 | BUCHANAN ST | 1 - 99 BUCHANAN ST | 1 - 99 BUCHANAN ST | 1 BUCHANAN ST | - | HERMANN ST | HERMANN ST |
| 22934 | N/A | Point | - | - | - | - | S228247 | GERMANIA ST: WEBSTER ST | - | F | F | - | F | 25886000 | 25886000 | - | - | NORTH WEST CORNER | - | - | - | - | WEBSTER ST | GERMANIA ST | 68034 | 68034 | 37.77091785 | -122.42852017 | GERMANIA ST \ WEBSTER ST | WEBSTER ST \ GERMANIA ST | 1710539427000 | MTA | GERMANIA ST | GERMANIA ST intersection | - | - | - | - | - | - | - | 40012 | 1472832660000 | -122.42852017 | 37.77091785 | - | 1472774400000 | - | D5 | - | STREET NAME | GUIDE | D3-1.0726 | 36X08 | SUP1 | 3IN IRON POST | IS | 1471606140000 | WEBSTER ST | - | - | - | - | - | - |
| 22935 | N/A | Point | - | - | - | - | S228251 | PIERCE ST: WALLER ST | - | F | F | - | F | 25996000 | 25996000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PIERCE ST | WALLER ST | 68035 | 68035 | 37.77075523 | -122.43354716 | WALLER ST \ PIERCE ST | PIERCE ST \ WALLER ST | 1710539427000 | MTA | DEAD END | WALLER ST intersection | - | - | - | - | - | - | - | 40013 | - | -122.43354716 | 37.77075523 | - | - | - | D5 | - | OTHER WARNING | WARNING | W14-1.0001 | 24X24 | SUP1 | LIGHT POLE | IS | 1471606680000 | PIERCE ST | - | - | - | - | - | - |
| 22936 | N/A | Point | - | - | - | - | S231323 | EUCALYPTUS DR: FOREST VIEW DR | - | F | F | - | F | 23125000 | 23125000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | EUCALYPTUS DR | EUCALYPTUS DR | 68036 | 68036 | 37.73107997 | -122.48354489 | FOREST VIEW DR \ EUCALYPTUS DR | FOREST VIEW DR \ EUCALYPTUS DR | 1754752495000 | middleware_editor | ALL WAY | EUCALYPTUS DR intersection | - | - | - | - | - | - | 1 | 40014 | 700128000000 | -122.48354489 | 37.73107997 | - | 1487059200000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1479893340000 | FOREST VIEW DR | - | - | - | - | - | - |
| 22937 | N/A | Point | - | - | - | - | S231325 | FOREST VIEW DR: EUCALYPTUS DR | - | F | F | - | F | 23125000 | 23125000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | EUCALYPTUS DR | EUCALYPTUS DR | 68037 | 68037 | 37.73107997 | -122.48354489 | FOREST VIEW DR \ EUCALYPTUS DR | FOREST VIEW DR \ EUCALYPTUS DR | 1754668304000 | middleware_editor | ALL WAY | EUCALYPTUS DR intersection | - | X ST IS EUCALYPTUS | - | - | - | - | - | 40015 | 700128000000 | -122.48354489 | 37.73107997 | - | 1487059200000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1479893880000 | FOREST VIEW DR | - | - | - | - | - | - |
| 22938 | N/A | Point | - | - | - | - | S231327 | CLEARFIELD DR: OCEAN AVE | - | F | F | - | F | 23307000 | 23307000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLEARFIELD DR | CLEARFIELD DR | 68038 | 68038 | 37.73201021 | -122.49143643 | OCEAN AVE \ CLEARFIELD DR | OCEAN AVE \ CLEARFIELD DR | 1715994118000 | middleware_editor | ALL WAY | CLEARFIELD DR intersection | - | 0 / 00 | - | - | - | - | - | 40016 | -402796800000 | -122.49143643 | 37.73201021 | - | 1488153600000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479894420000 | OCEAN AVE | - | - | - | - | - | - |
| 22939 | N/A | Point | 1 | 1 | 600 - 699 | - | S231338 | 600-699 INNES AVE | 600-699 INNES AVE | F | F | - | F | 19397001 | 19397001 | - | - | SOUTH SIDE | - | - | - | - | DONAHUE ST | DONAHUE ST | 68039 | 68039 | 37.72934001 | -122.37107554 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM TUE STCL | DONAHUE ST to EARL ST (600 - 699) | - | 235' EAST OF EARL | - | - | - | - | - | 40017 | 1480515660000 | -122.37107554 | 37.72934001 | - | 1480464000000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0270 | 18X18 | SUP1 | LIGHT POLE | IS | 1479902760000 | INNES AVE | 600 - 699 INNES AVE | 600 - 699 INNES AVE | 600 INNES AVE | - | EARL ST | EARL ST |
| 22940 | N/A | Point | 1 | 1 | 500 - 599 | - | S231502 | 500-599 10TH ST | 500-599 10TH ST | F | F | - | F | 491000 | 491000 | - | - | EAST SIDE | - | - | - | - | BRYANT ST \ HWY 101 S ON RAMP | BRYANT ST \ HWY 101 S ON RAMP | 68040 | 68040 | 37.76972689 | -122.4089196 | - | - | 1710539427000 | MTA | TANP ANY TIME | BRYANT ST \ HWY 101 S ON RAMP to BRANNAN ST \ DIVISION ST \ POTRERO AVE (500 - 599) | - | 208' SOUTH OF BRYANT (SEE NOTES) | - | - | - | - | - | 40018 | 1487327640000 | -122.4089196 | 37.76972689 | - | 1641859200000 | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0037 | 14X21 | SUP1 | FENCE | IS | 1480950600000 | 10TH ST | 500 - 599 10TH ST | 500 - 599 10TH ST | 500 10TH ST | - | BRANNAN ST \ DIVISION ST \ POTRERO AVE | BRANNAN ST \ DIVISION ST \ POTRERO AVE |
| 22941 | N/A | Point | 1 | 1 | 300 - 399 | LEFT ARROW | S231509 | 300-399 FULTON ST | 300-399 FULTON ST | F | F | - | F | 5882000 | 5882000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 68041 | 68041 | 37.77885212 | -122.42253167 | - | - | 1710539427000 | MTA | NPRK ANY TIME | FRANKLIN ST to GOUGH ST (300 - 399) | - | 93' EAST OF GOUGH ST. | - | - | - | - | - | 40019 | 1483974240000 | -122.42253167 | 37.77885212 | - | 1483920000000 | - | D5 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1481010180000 | FULTON ST | 300 - 399 FULTON ST | 300 - 399 FULTON ST | 300 FULTON ST | - | GOUGH ST | GOUGH ST |
| 22942 | N/A | Point | 1 | 1 | 300 - 399 | - | S231510 | 300-399 FULTON ST | 300-399 FULTON ST | F | F | - | F | 5882000 | 5882000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 68042 | 68042 | 37.77885212 | -122.42253167 | - | - | 1710539427000 | MTA | NPRK ANY TIME | FRANKLIN ST to GOUGH ST (300 - 399) | - | 40' EAST OF GOUGH ST. | - | - | - | - | - | 40020 | 1483974120000 | -122.42253167 | 37.77885212 | - | 1483920000000 | - | D5 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1481010720000 | FULTON ST | 300 - 399 FULTON ST | 300 - 399 FULTON ST | 300 FULTON ST | - | GOUGH ST | GOUGH ST |
| 22943 | N/A | Point | - | - | - | - | S231533 | CALIFORNIA ST: 23RD AVE | - | F | F | - | F | 27647000 | 27647000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 23RD AVE | CALIFORNIA ST | 68043 | 68043 | 37.78397927 | -122.48287005 | CALIFORNIA ST \ 23RD AVE | 23RD AVE \ CALIFORNIA ST | 1715389599000 | middleware_editor | ALL WAY | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 40021 | 855014400000 | -122.48287005 | 37.78397927 | - | 1484784000000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481023860000 | 23RD AVE | - | - | - | - | - | - |
| 22944 | N/A | Point | - | - | - | - | S231534 | CALIFORNIA ST: 23RD AVE | - | F | F | - | F | 27647000 | 27647000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 23RD AVE | CALIFORNIA ST | 68044 | 68044 | 37.78397927 | -122.48287005 | CALIFORNIA ST \ 23RD AVE | 23RD AVE \ CALIFORNIA ST | 1740089168000 | middleware_editor | ALL WAY | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 40022 | 855014400000 | -122.48287005 | 37.78397927 | - | 1740046680000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481024040000 | 23RD AVE | - | - | - | - | - | - |
| 22945 | N/A | Point | - | - | - | - | S234321 | 20TH ST: VERMONT ST | - | F | F | - | F | 23757000 | 23757000 | - | - | SOUTH SIDE | - | - | - | - | VERMONT ST | 20TH ST | 68046 | 68046 | 37.75955913 | -122.4040106 | 20TH ST \ VERMONT ST | VERMONT ST \ 20TH ST | 1710539427000 | MTA | NPRK 8AM-10AM WED STCL | 20TH ST intersection | - | 75`WEST OF VERMONT | - | - | - | - | - | 40023 | 718329600000 | -122.4040106 | 37.75955913 | - | 1622592000000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP1 | 2IN IRON POST | IS | 1489497840000 | VERMONT ST | - | - | - | - | - | - |
| 22946 | N/A | Point | 1 | 1 | 10 - 98 | RIGHT ARROW | S234877 | 0-199 SOUTH PARK | 10-98 SOUTH PARK | F | F | - | F | 12009101 | 12009101 | - | - | CENTER ISLAND | - | - | - | - | SOUTH PARK | SOUTH PARK | 68603 | 68603 | 37.781975 | -122.39369893 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-10PM EVERYDAY EXC "U" PERMITS | SOUTH PARK to JACK LONDON ALY (10 - 98) -- NORTH -- | - | OPP #62 | - | - | - | - | - | 40024 | 1494342600000 | -122.39369893 | 37.781975 | - | 1494288000000 | - | D6 | - | PARKING:RPP | REG | R32C(CA).0030 | 18X21 | SUP1 | 2IN IRON POST | IS | 1491312660000 | SOUTH PARK | 10 - 98 SOUTH PARK | 10 - 98 SOUTH PARK | 10 SOUTH PARK | - | JACK LONDON ALY | JACK LONDON ALY |
| 22947 | N/A | Point | 1 | 1 | 600 - 699 | - | S233206 | 600-699 DUBOCE AVE | 600-699 DUBOCE AVE | F | F | - | F | 4991000 | 4991000 | - | - | NORTH SIDE | - | - | - | - | NOE ST | NOE ST | 68604 | 68604 | 37.76914608 | -122.4342327 | - | - | 1710539427000 | MTA | DO NOT ENTER | NOE ST to SCOTT ST (600 - 699) | - | OPP#585 | - | - | - | - | - | 40025 | 1486021080000 | -122.4342327 | 37.76914608 | - | 1485993600000 | - | D8 | - | OTHER REGULATORY | REG | R5-1.0003 | 36X36 | SUP2 | LIGHT POLE | IS | 1486020360000 | DUBOCE AVE | 600 - 699 DUBOCE AVE | 600 - 699 DUBOCE AVE | 600 DUBOCE AVE | - | SCOTT ST | SCOTT ST |
| 22948 | N/A | Point | - | - | - | - | S232857 | INGALLS ST: FITZGERALD AVE | - | F | F | - | F | 20448000 | 20448000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FITZGERALD AVE | FITZGERALD AVE | 68610 | 68610 | 37.72097599 | -122.39130649 | INGALLS ST \ FITZGERALD AVE | INGALLS ST \ FITZGERALD AVE | 1710539427000 | MTA | ALL WAY | FITZGERALD AVE intersection | - | - | - | - | - | - | - | 40026 | 655516800000 | -122.39130649 | 37.72097599 | - | 1487030400000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1485248760000 | INGALLS ST | - | - | - | - | - | - |
| 22949 | N/A | Point | 1 | 1 | 800 - 899 | - | S232895 | 800-899 24TH ST | 800-899 24TH ST | F | F | - | F | 1322000 | 1322000 | - | - | SOUTH SIDE | - | - | - | - | 3RD ST | 03RD ST | 68611 | 68611 | 37.75408258 | -122.38837795 | - | - | 1710539427000 | MTA | BIKE RACK | 03RD ST to TENNESSEE ST (800 - 899) | 2016002114 | 55' WEST OF 3RD ST | - | - | - | - | - | 40027 | 1486639080000 | -122.38837795 | 37.75408258 | - | 1486598400000 | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1485262320000 | 24TH ST | 800 - 899 24TH ST | 800 - 899 24TH ST | 800 24TH ST | - | TENNESSEE ST | TENNESSEE ST |
| 22950 | N/A | Point | 1 | 1 | 100 - 199 | - | S233230 | 100-199 CLAY ST | 100-199 CLAY ST | F | F | - | F | 4080000 | 4080000 | - | - | SOUTH SIDE | - | - | - | - | DRUMM ST | DRUMM ST | 68612 | 68612 | 37.79538953 | -122.39737316 | - | - | 1717722945000 | middleware_editor | TANS 3PM-6PM EXC SAT & SUN | DRUMM ST to DAVIS ST (100 - 199) | - | 75' EAST OF DAVIS | - | - | - | - | - | 40028 | - | -122.39737316 | 37.79538953 | - | - | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0020 | 18X21 | SUP1 | 2IN IRON POST | IS | 1486028700000 | CLAY ST | 100 - 199 CLAY ST | 100 - 199 CLAY ST | 100 CLAY ST | - | DAVIS ST | DAVIS 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