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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 69901 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S206541 | 1700-1799 17TH ST | 1700-1799 17TH ST | F | F | - | F | 779000 | 779000 | - | - | SOUTH SIDE | - | - | - | - | CAROLINA ST | CAROLINA ST | 125463 | 125463 | 37.76486837 | -122.40111616 | - | - | 1721159846000 | middleware_editor | NPRK 12MN-6AM MON STCL | CAROLINA ST to DE HARO ST (1700 - 1799) | - | 20' EAST OF DE HARO | - | - | - | - | - | 87017 | 1272326400000 | -122.40111616 | 37.76486837 | - | - | 1717672800000 | D10 | - | STREET CLEANING | REG | R30B(CA).0048 | 18X18 | SUP1 | LIGHT POLE | RETD | 1401978840000 | 17TH ST | 1700 - 1799 17TH ST | 1700 - 1799 17TH ST | 1700 17TH ST | - | DE HARO ST | DE HARO ST |
| 69902 | N/A | Point | 1 | 1 | 4000 - 4099 | - | S209915 | 4000-4099 IRVING ST | 4000-4099 IRVING ST | F | F | - | F | 7319000 | 7319000 | - | - | NORTH SIDE | - | - | - | - | 41ST AVE | 41ST AVE | 125465 | 125465 | 37.76249838 | -122.50123434 | - | - | 1737572516000 | middleware_editor | BIKE RACK | 41ST AVE to 42ND AVE (4000 - 4099) | - | IFO#4006 (SEE PAINT MARK) | - | - | - | - | - | 87018 | - | -122.50123434 | 37.76249838 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BARRICADE | IS | 1412862540000 | IRVING ST | 4000 - 4099 IRVING ST | 4000 - 4099 IRVING ST | 4000 IRVING ST | - | 42ND AVE | 42ND AVE |
| 69903 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S208582 | 1800-1899 LYON ST | 1800-1899 LYON ST | F | F | - | F | 8569000 | 8569000 | - | - | WEST SIDE | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 125466 | 125466 | 37.78790096 | -122.44549542 | - | - | 1734034388000 | middleware_editor | OBSOLETE GUIDE SIGNS | CALIFORNIA ST to SACRAMENTO ST (1800 - 1899) | - | ON TREE IFO #1831 | - | - | - | - | - | 87019 | - | -122.44549542 | 37.78790096 | - | - | - | D2 | - | OTHER GUIDE | GUIDE | G-O(SF).0003 | 36X30 | SUP1 | PED BARRICADE | IS | 1409221500000 | LYON ST | 1800 - 1899 LYON ST | 1800 - 1899 LYON ST | 1800 LYON ST | - | SACRAMENTO ST | SACRAMENTO ST |
| 69904 | N/A | Point | - | - | - | - | S281238 | MISSION ST: 12TH ST \ OTIS ST | - | F | F | - | F | 24388000 | 24388000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | 125496 | 125496 | 37.77305345 | -122.41861822 | MISSION ST \ 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | MISSION ST \ 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | 1710539427000 | MTA | TYPE Q DELINEATOR (IPR) | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE intersection | - | WEST END OF ISLAND | - | - | - | - | - | 87020 | 1653091200000 | -122.41861822 | 37.77305345 | - | - | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-Q(CA).0001 | 02X24 | SUP1 | STANDARD BASE | IS | 1646309040000 | MISSION ST | - | - | - | - | - | - |
| 69905 | N/A | Point | - | - | - | - | S280987 | SOUTH VAN NESS AVE: 12TH ST \ | - | T | T | - | F | 24388000 | 24388000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | 125497 | 125497 | 37.77305345 | -122.41861822 | MISSION ST \ 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | MISSION ST \ 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | 1710539427000 | MTA | NO LEFT TURN(SYM)/NO U TURN (SYM) EXCEPT MUNI | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE intersection | - | S/W ISLAND | - | - | - | - | - | 87021 | 1646092800000 | -122.41861822 | 37.77305345 | - | - | - | D6 | - | NO LEFT TURN | REG | R3-18(SF).0009 | 36X42 | SUP1 | OVERHEAD MAST ARM | IS | 1645103820000 | MISSION ST | - | - | - | - | - | - |
| 69906 | N/A | Point | - | 1 | 0 - 0 | - | S270382 | PNDG POST ST | 0-0 MONTGOMERY ST | F | F | - | F | 9296000 | 9296000 | - | - | NORTH SIDE | - | - | - | - | MARKET ST \ NEW MONTGOMERY ST | MARKET ST \ NEW MONTGOMERY ST | 125499 | 125499 | 37.78890877 | -122.4019975 | - | - | 1710539427000 | MTA | BIKE RACK | MARKET ST \ NEW MONTGOMERY ST to POST ST (0 - 0) | 285969 | 18' E OF WPL 98/ 4' IN FROM CURB | - | - | - | - | - | 87022 | 1606818840000 | -122.4019975 | 37.78890877 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1606198680000 | MONTGOMERY ST | PNDG POST ST | 0 - 0 MONTGOMERY ST | - | - | POST ST | POST ST |
| 69907 | N/A | Point | - | - | - | - | S270782 | KING ST: 5TH ST \ I-280 N OFF | - | F | F | - | F | 23819000 | 23819000 | - | - | SOUTH EAST CORNER | - | - | - | - | 05TH ST \ I-280 N OFF RAMP \ I-280 S ON RAMP | 05TH ST \ I-280 N OFF RAMP \ I-280 S ON RAMP | 125501 | 125501 | 37.77457807 | -122.39626135 | KING ST \ 05TH ST \ I-280 N OFF RAMP \ I-280 S ON RAMP | KING ST \ 05TH ST \ I-280 N OFF RAMP \ I-280 S ON RAMP | 1710539427000 | MTA | KING ST | 05TH ST \ I-280 N OFF RAMP \ I-280 S ON RAMP intersection | - | X ST IS 5TH ST. | - | - | - | - | - | 87023 | 1609286400000 | -122.39626135 | 37.77457807 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.0975 | 36X08 | SUP1 | SIGNAL POLE | IS | 1607958060000 | KING ST | - | - | - | - | - | - |
| 69908 | N/A | Point | - | - | - | - | S267992 | BROTHERHOOD WAY: CHUMASERO DR | - | F | F | - | F | 22554000 | 22554000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | CHUMASERO DR \ THOMAS MORE WAY | CHUMASERO DR \ THOMAS MORE WAY | 125502 | 125502 | 37.71292738 | -122.47273721 | BROTHERHOOD WAY \ CHUMASERO DR \ THOMAS MORE WAY | BROTHERHOOD WAY \ CHUMASERO DR \ THOMAS MORE WAY | 1738681624000 | middleware_editor | SCHOOL/SPEED LIMIT 25/WHEN CHILDREN ARE PRESENT | CHUMASERO DR \ THOMAS MORE WAY intersection | - | 100 FT WEST OF THOMAS WAY | - | - | - | - | - | 87024 | 1425427200000 | -122.47273721 | 37.71292738 | - | 1599696000000 | - | D7 | - | OTHER REGULATORY | REG | SR4-1(CA).0002 | 24X48 | SUP2 | 2IN IRON POST | IS | 1599652500000 | BROTHERHOOD WAY | - | - | - | - | - | - |
| 69909 | N/A | Point | - | - | - | - | S270913 | BAY SHORE BLVD: INDUSTRIAL ST | - | F | F | - | F | 33674000 | 33674000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BAY SHORE BLVD \ INDUSTRIAL ST | BAY SHORE BLVD \ INDUSTRIAL ST | 125503 | 125503 | 37.73796587 | -122.4069105 | INDUSTRIAL ST ON RAMP \ BAY SHORE BLVD \ INDUSTRIAL ST | INDUSTRIAL ST ON RAMP \ BAY SHORE BLVD \ INDUSTRIAL ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | BAY SHORE BLVD \ INDUSTRIAL ST intersection | - | 10 FT SOUTH F INDUSTRIAL | - | - | - | - | - | 87025 | 1331078400000 | -122.4069105 | 37.73796587 | - | 1610668800000 | - | D9 | - | NO RIGHT TURN | REG | R13A(CA).0002 | 24X30 | SUP2 | 2IN IRON POST | IS | 1608281880000 | INDUSTRIAL ST ON RAMP | - | - | - | - | - | - |
| 69910 | N/A | Point | - | - | - | - | S270917 | BAY SHORE BLVD: INDUSTRIAL ST | - | F | F | - | F | 33674000 | 33674000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BAY SHORE BLVD \ INDUSTRIAL ST | BAY SHORE BLVD \ INDUSTRIAL ST | 125504 | 125504 | 37.73796587 | -122.4069105 | INDUSTRIAL ST ON RAMP \ BAY SHORE BLVD \ INDUSTRIAL ST | INDUSTRIAL ST ON RAMP \ BAY SHORE BLVD \ INDUSTRIAL ST | 1710539427000 | MTA | STOP | BAY SHORE BLVD \ INDUSTRIAL ST intersection | - | SWC OF BAYSHORE / BIKE PATH | - | - | - | - | - | 87026 | 1331078400000 | -122.4069105 | 37.73796587 | - | 1610409600000 | - | D9 | - | STOP | REG | R1-1.0005 | 18X18 | SUP2 | MUNI POLE | IS | 1608284520000 | INDUSTRIAL ST ON RAMP | - | - | - | - | - | - |
| 69911 | N/A | Point | 1 | 1 | 100 - 199 | - | S208670 | 100-199 KISSLING ST | 100-199 KISSLING ST | F | F | - | F | 7903000 | 7903000 | - | - | NORTH SIDE | - | - | - | - | 11TH ST | 11TH ST | 125543 | 125543 | 37.772524652 | -122.415175169 | - | - | 1710539427000 | MTA | NPRK ANY TIME | 11TH ST to 12TH ST (100 - 199) | - | 30' WEST OF 11TH ST | - | - | - | - | - | 87027 | 1410445980000 | -122.41560313 | 37.77203843 | - | 1410393600000 | - | D6 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1409656740000 | KISSLING ST | 100 - 199 KISSLING ST | 100 - 199 KISSLING ST | 100 KISSLING ST | - | 12TH ST | 12TH ST |
| 69912 | N/A | Point | - | - | - | - | S276671 | LA PLAYA: GREAT HWY \ KIRKHAM | - | F | F | - | F | 27945000 | 27945000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GREAT HWY \ KIRKHAM ST | GREAT HWY \ KIRKHAM ST | 125582 | 125582 | 37.75841445 | -122.50911129 | LA PLAYA \ GREAT HWY \ KIRKHAM ST | LA PLAYA \ GREAT HWY \ KIRKHAM ST | 1710539427000 | MTA | SPEED HUMP | GREAT HWY \ KIRKHAM ST intersection | - | X IS KIRKHAM | - | - | - | - | - | 87028 | 1420156800000 | -122.50911129 | 37.75841445 | - | 1627948800000 | - | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1627558020000 | LA PLAYA | - | - | - | - | - | - |
| 69913 | N/A | Point | - | - | - | - | S228154 | GUERRERO ST: 16TH ST | - | F | F | - | F | 25698000 | 25698000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | - | - | - | - | GUERRERO ST | 16TH ST | 125652 | 125652 | 37.764675311 | -122.424113409 | 16TH ST \ GUERRERO ST | GUERRERO ST \ 16TH ST | 1710539427000 | MTA | NO LEFT TURN 4PM-7PM MON-FRI | 16TH ST intersection | - | - | - | - | - | - | - | 87029 | 1472555100000 | -122.42410268 | 37.76478345 | - | 1472515200000 | - | D8 | - | NO LEFT TURN | REG | R33(CA).0041 | 30X36 | SUP2 | LIGHT POLE | IS | 1471430580000 | GUERRERO ST | - | - | - | - | - | - |
| 69914 | N/A | Point | - | - | - | - | S230428 | BACON ST: GIRARD ST | - | F | F | - | F | 20638000 | 20638000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GIRARD ST | GIRARD ST | 125655 | 125655 | 37.727460572 | -122.404511575 | BACON ST \ GIRARD ST | BACON ST \ GIRARD ST | 1710539427000 | MTA | ALL WAY | GIRARD ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 87030 | 545875200000 | -122.40459383 | 37.7273743 | - | 1491004800000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477899720000 | BACON ST | - | - | - | - | - | - |
| 69915 | N/A | Point | - | - | - | - | S229514 | SPRUCE ST: EUCLID AVE | - | F | F | - | F | 26929000 | 26929000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | EUCLID AVE | EUCLID AVE | 125658 | 125658 | 37.78405448 | -122.4536535 | SPRUCE ST \ EUCLID AVE | SPRUCE ST \ EUCLID AVE | 1736186371000 | middleware_editor | SPEED HUMPS | EUCLID AVE intersection | - | - | - | - | - | - | - | 87031 | 1475849100000 | -122.4536535 | 37.78405448 | - | 1475798400000 | - | D2 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1475659560000 | SPRUCE ST | - | - | - | - | - | - |
| 69916 | N/A | Point | 1 | 1 | 1 - 49 | - | S200304 | 1-49 CENTRAL AVE | 1-49 CENTRAL AVE | F | F | - | F | 3859000 | 3859000 | - | - | EAST SIDE | - | - | - | - | BUENA VISTA AVE | BUENA VISTA AVE | 125752 | 125752 | 37.76922062 | -122.44340875 | - | - | 1746819155000 | middleware_editor | NPRK 8AM-10AM WED STCL | BUENA VISTA AVE to WALLER ST (1 - 49) | - | 40'N OF BUENA VISTA AVE | - | - | - | - | - | 87032 | 1386360540000 | -122.44340875 | 37.76922062 | - | 1746816300000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1384263660000 | CENTRAL AVE | 1 - 49 CENTRAL AVE | 1 - 49 CENTRAL AVE | 1 CENTRAL AVE | - | WALLER ST | WALLER ST |
| 69917 | N/A | Point | - | - | - | - | S258449 | BAY SHORE BLVD: LOIS LN | - | F | F | - | F | 53016000 | 53016000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LOIS LN | BAY SHORE BLVD | 125753 | 125753 | 37.71385776 | -122.39975545 | BAY SHORE BLVD \ LOIS LN | LOIS LN \ BAY SHORE BLVD | 1710539427000 | MTA | LOIS LN | BAY SHORE BLVD intersection | - | X-STREET IS LOIS LN --- 000--> | - | - | - | - | - | 87033 | 1571928780000 | -122.39975545 | 37.71385776 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.1056 | 36X08 | SUP1 | 3IN IRON POST | IS | 1571471160000 | LOIS LN | - | - | - | - | - | - |
| 69918 | N/A | Point | - | - | - | - | S119360 | OWENS ST: 16TH ST | - | T | T | - | F | 23784000 | 23784000 | - | - | NORTH EAST CORNER | - | - | - | - | 16TH ST | 16TH ST | 125754 | 125754 | 37.76669146 | -122.39266187 | OWENS ST \ 16TH ST | OWENS ST \ 16TH ST | 1710539427000 | MTA | OWENS | 16TH ST intersection | - | - | - | - | - | - | - | 87034 | 1092787200000 | -122.39266187 | 37.76669146 | - | 1556755200000 | - | D6 | - | STREET NAME | GUIDE | D3-1.1946 | 36X08 | SUP1 | LIGHT POLE | IS | 1373573640000 | OWENS ST | - | - | - | - | - | - |
| 69919 | N/A | Point | - | - | - | - | S269653 | POST ST: GOUGH ST | - | T | T | - | F | 26501000 | 26501000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GOUGH ST | GOUGH ST | 125756 | 125756 | 37.78619643 | -122.42485842 | POST ST \ GOUGH ST | POST ST \ GOUGH ST | 1746192915000 | middleware_editor | PEDESTRIAN (SYM) | GOUGH ST intersection | - | X-STREET IS OCTAVIA ST. | - | - | - | - | - | 87035 | 1605223980000 | -122.42485842 | 37.78619643 | - | - | - | D5 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | MUNI POLE | IS | 1603972680000 | POST ST | - | - | - | - | - | - |
| 69920 | N/A | Point | - | - | - | - | S259654 | SILLIMAN ST: BRUSSELS ST | - | F | F | - | F | 20894000 | 20894000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BRUSSELS ST | BRUSSELS ST | 125757 | 125757 | 37.73071773 | -122.40707297 | SILLIMAN ST \ BRUSSELS ST | SILLIMAN ST \ BRUSSELS ST | 1726622743000 | middleware_editor | STOP | BRUSSELS ST intersection | - | - | - | - | - | - | - | 87036 | 1550102400000 | -122.40707297 | 37.73071773 | - | 1579651200000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1575969000000 | SILLIMAN ST | - | - | - | - | - | - |
| 69921 | N/A | Point | - | - | - | - | S260201 | 12TH ST: BERNICE ST | - | F | F | - | F | 24236000 | 24236000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 12TH ST | 12TH ST | 125759 | 125759 | 37.77034734 | -122.41374961 | BERNICE ST \ 12TH ST | BERNICE ST \ 12TH ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | 12TH ST intersection | - | - | - | - | - | - | - | 87037 | 1582632360000 | -122.41374961 | 37.77034734 | - | - | - | D6 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1578580020000 | BERNICE ST | - | - | - | - | - | - |
| 69922 | N/A | Point | - | - | - | - | S280971 | VAN NESS AVE: LOMBARD ST | - | T | T | - | F | 26696000 | 26696000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LOMBARD ST | VAN NESS AVE | 125760 | 125760 | 37.80130372 | -122.42453833 | VAN NESS AVE \ LOMBARD ST | LOMBARD ST \ VAN NESS AVE | 1710539427000 | MTA | NO U TURN (SYM) | VAN NESS AVE intersection | - | - | - | - | - | - | - | 87038 | 1645747200000 | -122.42453833 | 37.80130372 | - | - | - | D2 | - | OTHER REGULATORY | REG | R3-4.0002 | 30X30 | SUP1 | OVERHEAD MAST ARM | IS | 1645092300000 | LOMBARD ST | - | - | - | - | - | - |
| 69923 | N/A | Point | - | - | - | - | S272622 | SILVER AVE: WATERVILLE ST | - | F | F | - | F | 20763000 | 20763000 | - | - | NORTH WEST CORNER | - | - | - | - | WATERVILLE ST | WATERVILLE ST | 125761 | 125761 | 37.73419242 | -122.40266489 | SILVER AVE \ WATERVILLE ST | SILVER AVE \ WATERVILLE ST | 1754402242000 | middleware_editor | WATERVILLE ST | WATERVILLE ST intersection | - | 200 | - | - | - | - | - | 87039 | 1616523300000 | -122.40266489 | 37.73419242 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.1837 | 36X08 | SUP1 | 3IN IRON POST | IS | 1614166080000 | SILVER AVE | - | - | - | - | - | - |
| 69924 | N/A | Point | - | - | - | - | S260362 | MARKET ST: 12TH ST \ PAGE ST | - | F | F | - | F | - | 30749000 | - | - | NORTH SIDE | - | - | - | - | - | 12TH ST \ PAGE ST | 125767 | 125767 | 37.77434808 | -122.42060699 | - | MARKET ST \ 12TH ST \ PAGE ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | 12TH ST \ PAGE ST intersection | - | START @ W-LINE, X-WALK @ PAGE ST EB (3) | - | - | - | - | - | 87040 | 1551744000000 | -122.42025428 | 37.77435868 | - | 1580860800000 | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1579083840000 | MARKET ST | - | - | - | - | - | - |
| 69925 | N/A | Point | - | - | - | - | S270280 | DIAMOND HEIGHTS BLVD: DUNCAN S | - | F | F | - | F | 22038000 | 22038000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DUNCAN ST | DUNCAN ST | 125771 | 125771 | 37.746475267 | -122.443291278 | DIAMOND HEIGHTS BLVD \ DUNCAN ST | DIAMOND HEIGHTS BLVD \ DUNCAN ST | 1711570283000 | middleware_editor | (45 LA-DN) | DUNCAN ST intersection | - | ( END ) DUNCAN ON FLASHING PED POLE | - | - | - | - | - | 87041 | 1022716800000 | -122.44008805 | 37.74529604 | - | 1606867200000 | - | D8 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | LIGHT POLE | IS | 1605861540000 | DIAMOND HEIGHTS BLVD | - | - | - | - | - | - |
| 69926 | N/A | Point | - | - | - | - | S109339 | 12TH AVE: QUINTARA ST | - | F | F | - | F | 27095000 | 27095000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | QUINTARA ST | 12TH AVE | 125797 | 125797 | 37.74894564 | -122.46848104 | 12TH AVE \ QUINTARA ST | QUINTARA ST \ 12TH AVE | 1710539427000 | MTA | STOP | 12TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 87042 | 458697600000 | -122.46848104 | 37.74894564 | - | 1666051200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373570460000 | QUINTARA ST | - | - | - | - | - | - |
| 69927 | N/A | Point | - | - | - | - | S109090 | 19TH ST: DOUGLASS ST | - | F | F | - | F | 26138000 | 26138000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DOUGLASS ST | DOUGLASS ST | 125798 | 125798 | 37.75902775 | -122.43916731 | 19TH ST \ DOUGLASS ST | 19TH ST \ DOUGLASS ST | 1710539427000 | MTA | STOP | DOUGLASS ST intersection | - | 0 / 0 | - | - | - | - | - | 87043 | 402019200000 | -122.43916731 | 37.75902775 | - | 1582502400000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570400000 | 19TH ST | - | - | - | - | - | - |
| 69928 | N/A | Point | - | - | - | - | S111031 | LINDEN ST: OCTAVIA ST | - | F | F | - | F | 35011000 | 35011000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | LINDEN ST | 125799 | 125799 | 37.7762386 | -122.42427319 | LINDEN ST \ OCTAVIA ST | OCTAVIA ST \ LINDEN ST | 1710539427000 | MTA | ONE WAY (LA) | LINDEN ST intersection | - | MADE ONE WAY W/B | - | - | - | - | - | 87044 | 736732800000 | -122.42427319 | 37.7762386 | - | - | - | D5 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373571000000 | OCTAVIA ST | - | - | - | - | - | - |
| 69929 | N/A | Point | - | - | - | - | S111223 | YOSEMITE AVE: KEITH ST | - | F | F | - | F | 20492000 | 20492000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | YOSEMITE AVE | YOSEMITE AVE | 125800 | 125800 | 37.72685132 | -122.39166982 | KEITH ST \ YOSEMITE AVE | KEITH ST \ YOSEMITE AVE | 1711588095000 | middleware_editor | STOP | YOSEMITE AVE intersection | - | - | - | - | - | - | - | 87045 | 765244800000 | -122.39166982 | 37.72685132 | - | 1645056000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571060000 | KEITH ST | - | - | - | - | - | - |
| 69930 | N/A | Point | - | - | - | - | S114627 | BALBOA ST: 9TH AVE | - | F | F | - | F | 27281000 | 27281000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 9TH AVE | BALBOA ST | 125801 | 125801 | 37.77708786 | -122.4672204 | BALBOA ST \ 9TH AVE | 09TH AVE \ BALBOA ST | 1731972317000 | middleware_editor | STOP | BALBOA ST intersection | - | - | - | - | - | - | - | 87046 | 1012262400000 | -122.4672204 | 37.77708786 | - | 1731941400000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373572140000 | 09TH AVE | - | - | - | - | - | - |
| 69931 | N/A | Point | - | - | - | - | S236133 | WRIGHT ST: MONTCALM ST | - | F | F | - | F | 20834000 | 20834000 | - | - | NORTH WEST CORNER | - | - | - | - | WRIGHT ST | WRIGHT ST | 125939 | 125939 | 37.74745938 | -122.40592556 | MONTCALM ST \ WRIGHT ST | MONTCALM ST \ WRIGHT ST | 1710539427000 | MTA | ONE WAY (RA) | WRIGHT ST intersection | - | OF WRIGHT ST & MONTCALM ST-F/N/B/T | - | - | - | - | - | 87047 | 1146182400000 | -122.40592556 | 37.74745938 | - | - | - | D9 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | 3IN IRON POST | IS | 1494852840000 | MONTCALM ST | - | - | - | - | - | - |
| 69932 | N/A | Point | - | - | - | RIGHT ARROW | S276303 | TRANSVERSE DR: MIDDLE WEST DR | - | T | T | - | F | 27459000 | 27459000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | TRANSVERSE DR | TRANSVERSE DR | 125963 | 125963 | 37.766255279 | -122.478809181 | MIDDLE WEST DR \ TRANSVERSE DR | MIDDLE WEST DR \ TRANSVERSE DR | 1710539427000 | MTA | MUSIC CONCOURSE MUSEUMS | TRANSVERSE DR intersection | - | 200 FT NORTH OF MARTIN LUTHER KING | - | - | - | - | - | 87048 | 1629072000000 | -122.47968537 | 37.76776211 | - | 1629072000000 | - | D1 | - | OTHER GUIDE | GUIDE | G-M(SF).0044 | 30X24 | SUP2 | LIGHT POLE | IS | 1626693180000 | MIDDLE WEST DR | - | - | - | - | - | - |
| 69933 | N/A | Point | 1 | 1 | 900 - 1016 | - | S282523 | 900-1016 PENNSYLVANIA AVE | 900-1016 PENNSYLVANIA AVE | T | T | - | F | 10337000 | 10337000 | - | - | WEST SIDE | - | - | - | - | 23RD ST | 23RD ST | 125970 | 125970 | 37.75437148 | -122.39281463 | - | - | 1714484262000 | middleware_editor | NPRK ANY TIME VEH OVER 22' LONG OR 7' HIGH 12AM-6AM EVERYDAY | 23RD ST to I-280 S OFF RAMP (900 - 1016) | - | 20 FT SOUTH OF 23RD ST | - | - | - | - | - | 87049 | - | -122.39281463 | 37.75437148 | - | - | - | D10 | - | PARKING: NPRK ANY TIME | REG | R30(SF).0572 | 18X18 | SUP1 | LIGHT POLE | IS | 1651172460000 | PENNSYLVANIA AVE | 900 - 1016 PENNSYLVANIA AVE | 900 - 1016 PENNSYLVANIA AVE | 900 PENNSYLVANIA AVE | - | I-280 S OFF RAMP | I-280 S OFF RAMP |
| 69934 | N/A | Point | 1 | 1 | 100 - 199 | - | S267666 | 100-199 MISSION ST | 100-199 MISSION ST | F | F | - | F | 9084000 | 9084000 | - | - | SOUTH SIDE | - | - | - | - | SPEAR ST | SPEAR ST | 125971 | 125971 | 37.79218965 | -122.39449993 | - | - | 1710539427000 | MTA | BIKE RACK | SPEAR ST to MAIN ST (100 - 199) | 143654 | 98' W OF EPL 101/3.5' IN FROM CURB | - | - | - | - | - | 87050 | 1599052500000 | -122.39449993 | 37.79218965 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1598610060000 | MISSION ST | 100 - 199 MISSION ST | 100 - 199 MISSION ST | 100 MISSION ST | - | MAIN ST | MAIN ST |
| 69935 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S150673 | 1800-1899 41ST AVE | 1800-1899 41ST AVE | F | F | - | F | 1916000 | 1916000 | - | - | EAST SIDE | - | - | - | - | NORIEGA ST | NORIEGA ST | 125995 | 125995 | 37.75226742 | -122.49997966 | - | - | 1726179598000 | middleware_editor | NPRK 12NN-2PM 1ST & 3RD THUR OF MONTH STCL | NORIEGA ST to ORTEGA ST (1800 - 1899) | - | 1878 41ST AVE | - | - | - | - | - | 87051 | 1228694400000 | -122.49997966 | 37.75226742 | - | 1726049880000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0067 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375729860000 | 41ST AVE | 1800 - 1899 41ST AVE | 1800 - 1899 41ST AVE | 1800 41ST AVE | - | ORTEGA ST | ORTEGA ST |
| 69936 | N/A | Point | 1 | 1 | 1 - 99 | - | S214382 | 1-99 LEO ST | 1-99 LEO ST | F | F | - | F | 8308000 | 8308000 | - | - | SOUTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 126049 | 126049 | 37.722764307 | -122.43732902 | - | - | 1754419927000 | middleware_editor | NPRK ANY TIME | MISSION ST to ALEMANY BLVD (1 - 99) | - | OPP#52 | - | - | - | - | - | 87052 | - | -122.43709835 | 37.72271056 | - | - | - | D11 | - | PARKING: NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP2 | 2IN IRON POST | IS | 1426758120000 | LEO ST | 1 - 99 LEO ST | 1 - 99 LEO ST | 1 LEO ST | - | ALEMANY BLVD | ALEMANY BLVD |
| 69937 | N/A | Point | - | - | - | - | S214264 | 600-699 NORIEGA ST | - | F | F | - | F | 9647030 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | - | - | 126156 | 126156 | 37.75554223 | -122.47001 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | - | - | IFO#600 (SEE PAINT MARK) | - | - | - | - | - | 87053 | - | -122.47001 | 37.75554223 | - | - | - | D7 | - | OTHER WARNING | WARNING | W3-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1426501080000 | - | 600-699 NORIEGA ST | - | - | - | - | - |
| 69938 | N/A | Point | 1 | 1 | 0 - 0 | - | S235977 | 1-17 SAN PABLO AVE | 0-0 SAN PABLO AVE | F | F | - | F | 11500000 | 11500000 | - | - | EAST SIDE | - | - | - | - | GRANVILLE WAY \ PORTOLA DR | GRANVILLE WAY \ PORTOLA DR | 126176 | 126176 | 37.74018118 | -122.46106958 | - | - | 1729636035000 | middleware_editor | NPRK 1PM-3PM 2ND & 4TH TUE OF MONTH STCL | GRANVILLE WAY \ PORTOLA DR to SAN PABLO AVE (0 - 0) | - | 93 SAN PABLO | - | - | - | - | - | 87054 | 1225152000000 | -122.46106958 | 37.74018118 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0101 | 18X18 | SUP2 | 2IN IRON POST | IS | 1494337140000 | SAN PABLO AVE | 0 - 0 SAN PABLO AVE | 0 - 0 SAN PABLO AVE | 0 SAN PABLO AVE | - | SAN PABLO AVE | SAN PABLO AVE |
| 69939 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S236845 | 2200-2299 IRVING ST | 2200-2299 IRVING ST | F | F | - | F | 7300000 | 7300000 | - | - | SOUTH SIDE | - | - | - | - | 23RD AVE | 23RD AVE | 126177 | 126177 | 37.76334945 | -122.48194568 | - | - | 1710539427000 | MTA | BIKE RACK | 23RD AVE to 24TH AVE (2200 - 2299) | 201700340 | EAST/WEST BANK IFO 2219 | - | - | - | - | - | 87055 | 1499946900000 | -122.48194568 | 37.76334945 | - | 1499904000000 | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1497361260000 | IRVING ST | 2200 - 2299 IRVING ST | 2200 - 2299 IRVING ST | 2200 IRVING ST | - | 24TH AVE | 24TH AVE |
| 69940 | N/A | Point | 1 | 1 | 476 - 499 | - | S241201 | 476-499 FILBERT ST | 476-499 FILBERT ST | F | F | - | F | 5498000 | 5498000 | - | - | SOUTH SIDE | - | - | - | - | BOB KAUFMAN ALY | BOB KAUFMAN ALY | 126179 | 126179 | 37.80159114 | -122.40761548 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES | BOB KAUFMAN ALY to GRANT AVE (476 - 499) | - | 6' W. IFO #487 | - | - | - | - | - | 87056 | - | -122.40761548 | 37.80159114 | - | 1685577600000 | - | D3 | - | PARKING:PARK AT 90 | REG | R(SF).0372 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1512474180000 | FILBERT ST | 476 - 499 FILBERT ST | 476 - 499 FILBERT ST | 476 FILBERT ST | - | GRANT AVE | GRANT AVE |
| 69941 | N/A | Point | 1 | 1 | 200 - 275 | - | S261968 | 200-275 MIDDLEFIELD DR | 200-275 MIDDLEFIELD DR | F | F | - | F | 9018000 | 9018000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | EUCALYPTUS DR | EUCALYPTUS DR | 126201 | 126201 | 37.73033249 | -122.48629479 | - | - | 1755807121000 | middleware_editor | SPEED HUMP | EUCALYPTUS DR to GELLERT DR (200 - 275) | - | 40 FT NORTH OF GELLERT | - | - | - | - | - | 87057 | 1000796400000 | -122.48629479 | 37.73033249 | - | 1584946800000 | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1582796220000 | MIDDLEFIELD DR | 200 - 275 MIDDLEFIELD DR | 200 - 275 MIDDLEFIELD DR | 200 MIDDLEFIELD DR | - | GELLERT DR | GELLERT DR |
| 69942 | N/A | Point | 1 | 1 | 700 - 731 | - | S123350 | 700-731 FRANKLIN ST | 700-731 FRANKLIN ST | F | F | - | F | 5808000 | 5808000 | - | - | WEST SIDE | - | - | - | - | GOLDEN GATE AVE | GOLDEN GATE AVE | 126217 | 126217 | 37.78105372 | -122.42213675 | - | - | 1710539427000 | MTA | TANS 4PM-6PM EXC SAT & SUN | GOLDEN GATE AVE to ELM ST (700 - 731) | - | 50' NORTH | - | - | - | - | - | 87058 | 1144886400000 | -122.42213675 | 37.78105372 | - | - | - | D5 | - | OTHER REGULATORY | REG | R37(CA).0026 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1373574840000 | FRANKLIN ST | 700 - 731 FRANKLIN ST | 700 - 731 FRANKLIN ST | 700 FRANKLIN ST | - | ELM ST | ELM ST |
| 69943 | N/A | Point | 1 | 1 | 4400 - 4499 | - | S129591 | 4400-4499 OCEAN AVE | 4400-4499 OCEAN AVE | F | F | - | F | 9868000 | 9868000 | - | - | NORTH SIDE | - | - | - | - | WESTMOORLAND DR | WESTMOORLAND DR | 126218 | 126218 | 37.73202878 | -122.49101383 | - | - | 1748015924000 | middleware_editor | HABITTN IN VEH PROH 10PM6AM EVRYDY/VLTRS SUBJ FINE OR ARRST | WESTMOORLAND DR to CLEARFIELD DR (4400 - 4499) | - | OPP #4445 | - | - | - | - | - | 87059 | 1221462000000 | -122.49101383 | 37.73202878 | - | - | - | D7 | - | OTHER REGULATORY | REG | R(SF).0091 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373576820000 | OCEAN AVE | 4400 - 4499 OCEAN AVE | 4400 - 4499 OCEAN AVE | 4400 OCEAN AVE | - | CLEARFIELD DR | CLEARFIELD DR |
| 69944 | N/A | Point | - | - | - | - | S277487 | VAN NESS AVE: OFARRELL ST | - | T | T | - | F | 25192000 | 25192000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | OFARRELL ST | VAN NESS AVE | 126240 | 126240 | 37.78475345 | -122.42119297 | VAN NESS AVE \ OFARRELL ST | OFARRELL ST \ VAN NESS AVE | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | VAN NESS AVE intersection | - | - | - | - | - | - | - | 87060 | 1634395620000 | -122.42119297 | 37.78475345 | - | - | - | D5 | - | NO LEFT TURN | REG | R3-18.0003 | 36X36 | SUP1 | OVERHEAD MAST ARM | IS | 1631181240000 | OFARRELL ST | - | - | - | - | - | - |
| 69945 | N/A | Point | 1 | 1 | 2000 - 2035 | RIGHT ARROW | S277582 | 2000-2035 FOLSOM ST | 2000-2035 FOLSOM ST | F | F | - | F | 5690000 | 5690000 | - | - | WEST SIDE | - | - | - | - | 16TH ST | 16TH ST | 126241 | 126241 | 37.76500997 | -122.41527952 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7AM-10PM DAILY (5 MIN) H/C | 16TH ST to ENTERPRISE ST (2000 - 2035) | - | 166 FT NORTH OF 17TH ST IFO 2070 | - | - | - | - | - | 87061 | 1289174400000 | -122.41527952 | 37.76500997 | - | 1632355200000 | - | D9 | - | OTHER REGULATORY | REG | R38(SF)1.0216 | 14X21 | SUP2 | 2IN IRON POST | IS | 1631613360000 | FOLSOM ST | 2000 - 2035 FOLSOM ST | 2000 - 2035 FOLSOM ST | 2000 FOLSOM ST | - | ENTERPRISE ST | ENTERPRISE ST |
| 69946 | N/A | Point | - | - | - | - | S278865 | MASONIC AVE: TURK BLVD | - | F | F | - | F | 26392000 | 26392000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | - | - | - | - | MASONIC AVE | TURK BLVD | 126242 | 126242 | 37.77862231 | -122.44703981 | TURK BLVD \ MASONIC AVE | MASONIC AVE \ TURK BLVD | 1747149474000 | middleware_editor | NO LEFT TURN (SYM)/NO U TURN (SYM) | TURK BLVD intersection | - | - | - | - | - | - | - | 87062 | 1638172800000 | -122.44703981 | 37.77862231 | - | - | - | D1 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | SIGNAL POLE | IS | 1637071200000 | MASONIC AVE | - | - | - | - | - | - |
| 69947 | N/A | Point | - | - | - | - | S277054 | IRVING ST: 3RD AVE | - | T | T | - | F | 27079000 | 27079000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | IRVING ST | 03RD AVE | 126244 | 126244 | 37.76431883 | -122.45988756 | 3RD AVE \ IRVING ST | IRVING ST \ 03RD AVE | 1710539427000 | MTA | PEDESTRIAN (SYM) | 03RD AVE intersection | - | - | - | - | - | - | - | 87063 | 1285027200000 | -122.45988756 | 37.76431883 | - | 1629936000000 | - | D5 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | LIGHT POLE | IS | 1628601960000 | IRVING ST | - | - | - | - | - | - |
| 69948 | N/A | Point | - | - | - | - | S277537 | GONZALEZ DR: CASTELO AVE | - | F | F | - | F | 23018000 | 23018000 | - | - | SOUTH WEST CORNER | - | - | - | - | GONZALEZ DR | CASTELO AVE | 126245 | 126245 | 37.7174154 | -122.47525348 | CASTELO AVE \ GONZALEZ DR | GONZALEZ DR \ CASTELO AVE | 1710539427000 | MTA | CASTELO AVE | CASTELO AVE intersection | - | - | - | - | - | - | - | 87064 | - | -122.47525348 | 37.7174154 | - | 1670371200000 | - | D7 | - | STREET NAME | GUIDE | D3-1.0339 | 36X08 | SUP2 | 3IN IRON POST | IS | 1631187780000 | GONZALEZ DR | - | - | - | - | - | - |
| 69949 | N/A | Point | - | - | - | - | S277873 | 20TH ST: SHOTWELL ST | - | F | F | - | F | 24124000 | 24124000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 20TH ST | 20TH ST | 126257 | 126257 | 37.75883023 | -122.4157793 | SHOTWELL ST \ 20TH ST | SHOTWELL ST \ 20TH ST | 1730858391000 | middleware_editor | EXCEPT BIKE (SYM) | 20TH ST intersection | - | ABOVE STOP SIGN | - | - | - | - | - | 87065 | 1634083200000 | -122.4157793 | 37.75883023 | - | 1634083200000 | - | D9 | - | OTHER REGULATORY | REG | R(SF).0362 | 24X18 | SUP2 | 2IN IRON POST | IS | 1632736680000 | SHOTWELL ST | - | - | - | - | - | - |
| 69950 | N/A | Point | - | - | - | - | S275955 | LAIDLEY ST: FAIRMOUNT ST | - | F | F | - | F | 21874000 | 21874000 | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | - | - | - | - | FAIRMOUNT ST | FAIRMOUNT ST | 126258 | 126258 | 37.73867631 | -122.42810483 | LAIDLEY ST \ FAIRMOUNT ST | LAIDLEY ST \ FAIRMOUNT ST | 1710539427000 | MTA | KEEP RIGHT | FAIRMOUNT ST intersection | - | - | - | - | - | - | - | 87066 | 1478649600000 | -122.42810483 | 37.73867631 | - | 1634774400000 | - | D8 | - | OTHER REGULATORY | REG | R4-7A(SF).0001 | 24X30 | SUP2 | 2IN IRON POST | IS | 1625218080000 | LAIDLEY ST | - | - | - | - | - | - |
| 69951 | N/A | Point | - | - | - | - | S271762 | WEBSTER ST: GEARY BLVD | - | F | F | - | F | 26587000 | 26587000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GEARY BLVD | GEARY BLVD | 126260 | 126260 | 37.78456824 | -122.43120495 | WEBSTER ST \ GEARY BLVD | WEBSTER ST \ GEARY BLVD | 1710539427000 | MTA | NPRK 6AM-8AM WED STCL | GEARY BLVD intersection | - | - | - | - | - | - | - | 87067 | - | -122.43120495 | 37.78456824 | - | - | - | D5 | - | STREET CLEANING | REG | R30B(CA).0199 | 18X18 | SUP1 | LIGHT POLE | IS | 1611239160000 | WEBSTER ST | - | - | - | - | - | - |
| 69952 | N/A | Point | - | - | - | - | S281984 | LINCOLN WAY: LA PLAYA \ MARTIN | - | T | T | - | F | 8386201 | 27964000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | 48TH AVE | LA PLAYA \ MARTIN LUTHER KING JR DR | 126261 | 126261 | 37.7640538274638 | -122.509268447752 | - | LINCOLN WAY \ LA PLAYA \ MARTIN LUTHER KING JR DR | 1738257498000 | middleware_editor | NO LEFT TURN (SYM)/NO U TURN (SYM) | LA PLAYA \ MARTIN LUTHER KING JR DR intersection | - | - | - | - | - | - | - | 87068 | 1649808000000 | -122.50940219 | 37.76403274 | - | - | - | D4 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1648725540000 | LINCOLN WAY | 4700 - 4798 LINCOLN WAY | - | - | - | LA PLAYA \ MARTIN LUTHER KING JR DR | - |
| 69953 | N/A | Point | - | - | - | - | S282816 | WILLOW ST: VAN NESS AVE | - | F | F | - | F | 30707000 | 30707000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 126262 | 126262 | 37.78335208 | -122.42097712 | WILLOW ST \ VAN NESS AVE | WILLOW ST \ VAN NESS AVE | 1710539427000 | MTA | WILLOW ST | VAN NESS AVE intersection | - | <---200 | - | - | - | - | - | 87069 | - | -122.42097712 | 37.78335208 | - | 1681948800000 | - | D6 | - | STREET NAME | GUIDE | D3-1.1875 | 36X08 | SUP1 | BUILDING | IS | 1652716260000 | WILLOW ST | - | - | - | - | - | - |
| 69954 | N/A | Point | - | - | - | - | S270458 | JONES ST: PINE ST | - | T | T | - | F | 25090000 | 25090000 | - | - | SOUTH EAST CORNER | - | - | - | - | JONES ST | PINE ST | 126263 | 126263 | 37.79046312 | -122.41391588 | PINE ST \ JONES ST | JONES ST \ PINE ST | 1751905983000 | middleware_editor | JONES ST | PINE ST intersection | - | 1000 --> II N | - | - | - | - | - | 87070 | 1609265160000 | -122.41391588 | 37.79046312 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-1.0935 | 36X08 | SUP1 | LIGHT POLE | IS | 1606311300000 | JONES ST | - | - | - | - | - | - |
| 69955 | N/A | Point | - | - | - | - | S281586 | VAN NESS AVE: SACRAMENTO ST | - | F | F | - | F | 26536000 | 26536000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | - | - | - | - | SACRAMENTO ST | VAN NESS AVE | 126264 | 126264 | 37.79128889 | -122.42251494 | VAN NESS AVE \ SACRAMENTO ST | SACRAMENTO ST \ VAN NESS AVE | 1732121235000 | middleware_editor | FG 300 UR DELINEATOR (W) | VAN NESS AVE intersection | - | - | - | - | - | - | - | 87071 | 1656115200000 | -122.42251494 | 37.79128889 | - | - | - | D2 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1647442920000 | SACRAMENTO ST | - | - | - | - | - | - |
| 69956 | N/A | Point | - | - | - | - | S271696 | BURROWS ST: GIRARD ST | - | F | F | - | F | 20652000 | 20652000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GIRARD ST | BURROWS ST | 126265 | 126265 | 37.72857432 | -122.40509102 | BURROWS ST \ GIRARD ST | GIRARD ST \ BURROWS ST | 1726154169000 | middleware_editor | SPEED HUMP | BURROWS ST intersection | - | - | - | - | - | - | - | 87072 | 137289600000 | -122.40509102 | 37.72857432 | - | 1615161600000 | - | D9 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1611218760000 | GIRARD ST | - | - | - | - | - | - |
| 69957 | N/A | Point | - | - | - | - | S282489 | VAN NESS AVE: ELLIS ST | - | F | F | - | F | 25190000 | 25190000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | ELLIS ST | ELLIS ST | 126266 | 126266 | 37.78382412 | -122.42100836 | VAN NESS AVE \ ELLIS ST | VAN NESS AVE \ ELLIS ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | ELLIS ST intersection | - | - | - | - | - | - | - | 87073 | 1652486400000 | -122.42100836 | 37.78382412 | - | - | - | D5 | - | NO LEFT TURN | REG | R3-18.0001 | 24X24 | SUP1 | 2IN IRON POST | IS | 1651072320000 | VAN NESS AVE | - | - | - | - | - | - |
| 69958 | N/A | Point | - | - | - | - | S108497 | EL VERANO WAY: SAINT ELMO WAY | - | F | F | - | F | 22681000 | 22681000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | EL VERANO WAY | EL VERANO WAY | 126285 | 126285 | 37.73188581 | -122.45970121 | SAINT ELMO WAY \ EL VERANO WAY | SAINT ELMO WAY \ EL VERANO WAY | 1712937280000 | middleware_editor | STOP | EL VERANO WAY intersection | - | 0 / 0 | - | - | - | - | - | 87074 | 309744000000 | -122.45970121 | 37.73188581 | - | 1712660400000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570220000 | SAINT ELMO WAY | - | - | - | - | - | - |
| 69959 | N/A | Point | - | - | - | - | S106743 | 18TH ST: DIAMOND ST | - | F | F | - | F | 25818000 | 25818000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DIAMOND ST | DIAMOND ST | 126287 | 126287 | 37.76075811 | -122.43719063 | 18TH ST \ DIAMOND ST | 18TH ST \ DIAMOND ST | 1710539427000 | MTA | STOP | DIAMOND ST intersection | - | - | - | - | - | - | - | 87075 | 164764800000 | -122.43719063 | 37.76075811 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | MUNI POLE | IS | 1373569620000 | 18TH ST | - | - | - | - | - | - |
| 69960 | N/A | Point | - | - | - | - | S103677 | 21ST ST: HARRISON ST | - | F | F | - | F | 23998000 | 23998000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HARRISON ST | 21ST ST | 126288 | 126288 | 37.75742952 | -122.41234804 | 21ST ST \ HARRISON ST | HARRISON ST \ 21ST ST | 1717203972000 | middleware_editor | STOP | 21ST ST intersection | - | 0 / 0 | - | - | - | - | - | 87076 | -142819200000 | -122.41234804 | 37.75742952 | - | 881280000000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568660000 | HARRISON ST | - | - | - | - | - | - |
| 69961 | N/A | Point | - | - | - | - | S106584 | WASHINGTON ST: BAKER ST | - | F | F | - | F | 26862000 | 26862000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BAKER ST | WASHINGTON ST | 126291 | 126291 | 37.79032652 | -122.44430035 | WASHINGTON ST \ BAKER ST | BAKER ST \ WASHINGTON ST | 1710539427000 | MTA | STOP | WASHINGTON ST intersection | - | 0 / 0 | - | - | - | - | - | 87077 | 151804800000 | -122.44430035 | 37.79032652 | - | 1593561600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569620000 | BAKER ST | - | - | - | - | - | - |
| 69962 | N/A | Point | - | - | - | - | S108518 | 28TH AVE: MORAGA ST | - | F | F | - | F | 27405000 | 27405000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 28TH AVE | 28TH AVE | 126292 | 126292 | 37.75568252 | -122.48624769 | MORAGA ST \ 28TH AVE | MORAGA ST \ 28TH AVE | 1726862217000 | middleware_editor | STOP | 28TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 87078 | 310089600000 | -122.48624769 | 37.75568252 | - | 1465862400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570220000 | MORAGA ST | - | - | - | - | - | - |
| 69963 | N/A | Point | - | - | - | - | S108549 | STANYAN ST: 17TH ST | - | F | F | - | F | 26287000 | 26287000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | STANYAN ST | 17TH ST | 126293 | 126293 | 37.7614782 | -122.45195777 | 17TH ST \ STANYAN ST | STANYAN ST \ 17TH ST | 1710539427000 | MTA | STOP | 17TH ST intersection | - | - | - | - | - | - | - | 87079 | 313286400000 | -122.45195777 | 37.7614782 | - | - | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570220000 | STANYAN ST | - | - | - | - | - | - |
| 69964 | N/A | Point | - | - | - | - | S101350 | PINE ST: BEALE ST \ DAVIS ST \ | - | T | T | - | F | 30729000 | 30729000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BEALE ST \ DAVIS ST \ MARKET ST | BEALE ST \ DAVIS ST \ MARKET ST | 126296 | 126296 | 37.79240552 | -122.39738345 | PINE ST \ BEALE ST \ DAVIS ST \ MARKET ST | PINE ST \ BEALE ST \ DAVIS ST \ MARKET ST | 1710539427000 | MTA | ONE WAY (LA) | BEALE ST \ DAVIS ST \ MARKET ST intersection | - | 0 / 0 | - | - | - | - | - | 87080 | -398131200000 | -122.39738345 | 37.79240552 | - | 1677628800000 | - | D3 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP1 | LIGHT POLE | IS | 1373566740000 | PINE ST | - | - | - | - | - | - |
| 69965 | N/A | Point | - | - | - | - | S101667 | PINE ST: DIVISADERO ST | - | F | F | - | F | 26643000 | 26643000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 126297 | 126297 | 37.78711246 | -122.44024996 | PINE ST \ DIVISADERO ST | PINE ST \ DIVISADERO ST | 1710539427000 | MTA | ONE WAY (RA) | DIVISADERO ST intersection | - | 0 / 0 | - | - | - | - | - | 87081 | -395452800000 | -122.44024996 | 37.78711246 | - | 1684108800000 | - | D2 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373566860000 | PINE ST | - | - | - | - | - | - |
| 69966 | N/A | Point | 1 | 1 | 24 - 99 | - | S226120 | 24-99 PAGE ST | 24-99 PAGE ST | F | F | - | F | 10169000 | 10169000 | - | - | SOUTH SIDE | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 126299 | 126299 | 37.77418969 | -122.42158351 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM TUE THUR STCL | FRANKLIN ST to GOUGH ST (24 - 99) | - | 5' EAST OF GOUGH | - | - | - | - | - | 87082 | 1465219260000 | -122.42158351 | 37.77418969 | - | 1465171200000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0133 | 18X18 | SUP1 | LIGHT POLE | IS | 1464774060000 | PAGE ST | 24 - 99 PAGE ST | 24 - 99 PAGE ST | 24 PAGE ST | - | GOUGH ST | GOUGH ST |
| 69967 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S225347 | 1200-1299 9TH AVE | 1200-1299 09TH AVE | F | F | - | F | 431000 | 431000 | - | - | WEST SIDE | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 126300 | 126300 | 37.76498083 | -122.46637656 | - | - | 1710539427000 | MTA | NPRK 7AM-8AM MON WED STCL | LINCOLN WAY to IRVING ST (1200 - 1299) | - | SPL #1239 | - | - | - | - | - | 87083 | - | -122.46637656 | 37.76498083 | - | - | - | D5 | - | STREET CLEANING | REG | R30B(CA).0217 | 18X18 | SUP1 | 2IN IRON POST | IS | 1462354080000 | 09TH AVE | 1200 - 1299 9TH AVE | 1200 - 1299 09TH AVE | 1200 9TH AVE | - | IRVING ST | IRVING ST |
| 69968 | N/A | Point | 1 | 1 | 1 - 99 | - | S226251 | 1-99 DR CARLTON B GOODLETT PL | 1-99 DR CARLTON B GOODLETT PL | F | F | - | F | 10549000 | 10549000 | - | - | WEST SIDE | - | - | - | - | GROVE ST \ POLK ST | GROVE ST \ POLK ST | 126301 | 126301 | 37.77937463 | -122.41841255 | - | - | 1729538514000 | middleware_editor | BIKE RACK | GROVE ST \ POLK ST to MCALLISTER ST \ POLK ST (1 - 99) | - | X ST IS GROVE 112' N OF MID BLOCK X WALK | - | - | - | - | - | 87084 | - | -122.41841255 | 37.77937463 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1465047840000 | DR CARLTON B GOODLETT PL | 1 - 99 DR CARLTON B GOODLETT PL | 1 - 99 DR CARLTON B GOODLETT PL | 1 DR CARLTON B GOODLETT PL | - | MCALLISTER ST \ POLK ST | MCALLISTER ST \ POLK ST |
| 69969 | N/A | Point | 1 | 1 | 300 - 399 | LEFT ARROW | S228254 | 300-399 15TH ST | 300-399 15TH ST | F | F | - | F | 636000 | 636000 | - | - | NORTH SIDE | - | - | - | - | HENRY ADAMS ST \ KANSAS ST | HENRY ADAMS ST \ KANSAS ST | 126302 | 126302 | 37.7672868 | -122.40425487 | - | - | 1753722208000 | middleware_editor | NPRK VEH OVER 6 FT HIGH | HENRY ADAMS ST \ KANSAS ST to VERMONT ST (300 - 399) | - | 105' EAST OF VERMONT | - | - | - | - | - | 87085 | 1472056560000 | -122.40425487 | 37.7672868 | - | 1472022000000 | - | D10 | - | PARKING | REG | R28D(CA).0007 | 18X18 | SUP1 | 2IN IRON POST | IS | 1471607700000 | 15TH ST | 300 - 399 15TH ST | 300 - 399 15TH ST | 300 15TH ST | - | VERMONT ST | VERMONT ST |
| 69970 | N/A | Point | - | 1 | 601 - 799 | - | S225732 | 0-799 ALEMANY BLVD | 601-799 ALEMANY BLVD | F | F | - | F | 2157103 | 2157103 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | STONEYBROOK AVE | STONEYBROOK AVE | 126303 | 126303 | 37.73113809 | -122.42395446 | - | - | 1710539427000 | MTA | CURVE CHEVRON (SYM) (LA) | STONEYBROOK AVE to CONGDON ST (601 - 799) -- SOUTH -- | - | 4TH SIGN WEST | - | - | - | - | - | 87086 | 1463746500000 | -122.42395446 | 37.73113809 | - | 1463702400000 | - | D11 | - | OTHER WARNING | WARNING | W1-8.0003 | 18X24 | SUP2 | 2IN IRON POST | IS | 1463561700000 | ALEMANY BLVD | 601 - 799 ALEMANY BLVD | 601 - 799 ALEMANY BLVD | 601 ALEMANY BLVD | - | CONGDON ST | CONGDON ST |
| 69971 | N/A | Point | - | - | - | - | S279255 | SADOWA ST: CAPITOL AVE | - | F | F | - | F | 22470000 | 22470000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SADOWA ST | CAPITOL AVE | 117430 | 117430 | 37.71229574 | -122.45901512 | CAPITOL AVE \ SADOWA ST | SADOWA ST \ CAPITOL AVE | 1710539427000 | MTA | SPEED HUMPS AHEAD | CAPITOL AVE intersection | - | - | - | - | - | - | - | 87087 | 1639958400000 | -122.45901512 | 37.71229574 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1638439560000 | SADOWA ST | - | - | - | - | - | - |
| 69972 | N/A | Point | 1 | 1 | 4400 - 4499 | - | S262217 | 4400-4499 PACHECO ST | 4400-4499 PACHECO ST | F | F | - | F | 10117000 | 10117000 | - | - | SOUTH SIDE | - | - | - | - | 48TH AVE | 48TH AVE | 117450 | 117450 | 37.749052803 | -122.507810959 | - | - | 1710539427000 | MTA | BIKE RACK | 48TH AVE to GREAT HWY (4400 - 4499) | 141931 | 4' E OF L.GHWY/ 3' IN FROM CURB | - | - | - | - | - | 87088 | 1583750400000 | -122.50761421 | 37.74912546 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1583334360000 | PACHECO ST | 4400 - 4499 PACHECO ST | 4400 - 4499 PACHECO ST | 4400 PACHECO ST | - | GREAT HWY | GREAT HWY |
| 69973 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S269474 | 2000-2099 22ND ST | 2000-2099 22ND ST | F | F | - | F | 1171000 | 1171000 | - | - | SOUTH SIDE | - | - | - | - | DE HARO ST | DE HARO ST | 117484 | 117484 | 37.7571528 | -122.40135103 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM WED STCL | DE HARO ST to RHODE ISLAND ST (2000 - 2099) | - | WPL # 2033 2ND ST | - | - | - | - | - | 87089 | 1606822980000 | -122.40135103 | 37.7571528 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP1 | 2IN IRON POST | IS | 1603445220000 | 22ND ST | 2000 - 2099 22ND ST | 2000 - 2099 22ND ST | 2000 22ND ST | - | RHODE ISLAND ST | RHODE ISLAND ST |
| 69974 | N/A | Point | 1 | 1 | 3500 - 3538 | - | S200794 | 3500-3538 19TH ST | 3500-3538 19TH ST | F | F | - | F | 975000 | 975000 | - | - | NORTH SIDE | - | - | - | - | VALENCIA ST | VALENCIA ST | 117527 | 117527 | 37.759963036 | -122.423003127 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | VALENCIA ST to LAPIDGE ST (3500 - 3538) | - | IFO #3554 | - | - | - | - | - | 87090 | - | -122.42184173 | 37.76007613 | - | - | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | 2 POST ALUMINUM | IS | 1386255720000 | 19TH ST | 3500 - 3538 19TH ST | 3500 - 3538 19TH ST | 3500 19TH ST | - | LAPIDGE ST | LAPIDGE ST |
| 69975 | N/A | Point | - | - | - | - | S257818 | DOLORES ST: 16TH ST | - | F | F | - | F | 25706000 | 25706000 | - | - | NORTH WEST CORNER | - | - | - | - | 16TH ST | 16TH ST | 117541 | 117541 | 37.764785635 | -122.426525208 | DOLORES ST \ 16TH ST | DOLORES ST \ 16TH ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | 16TH ST intersection | - | - | - | - | - | - | - | 87091 | 1455667200000 | -122.42638171 | 37.76464569 | - | 1574121600000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1568725440000 | DOLORES 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