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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 131626 | N/A | Point | - | - | - | - | S217502 | FUNSTON AVE: CLEMENT ST | - | F | F | - | F | 27482000 | 27482000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FUNSTON AVE | CLEMENT ST | 87299 | 87299 | 37.78259621 | -122.47191503 | CLEMENT ST \ FUNSTON AVE | FUNSTON AVE \ CLEMENT ST | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | CLEMENT ST intersection | 134745 | - | - | - | - | - | - | 173285 | 1330992000000 | -122.47191503 | 37.78259621 | - | - | - | D1 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1435563000000 | FUNSTON AVE | - | - | - | - | - | - |
| 131627 | N/A | Point | - | - | - | - | S107789 | 40TH AVE: WAWONA ST | - | F | F | - | F | 23429000 | 23429000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WAWONA ST | 40TH AVE | 3435 | 3435 | 37.7364644 | -122.49779797 | 40TH AVE \ WAWONA ST | WAWONA ST \ 40TH AVE | 1710539427000 | MTA | STOP | 40TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 173286 | 255830400000 | -122.49779797 | 37.7364644 | - | 1489968000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | WAWONA ST | - | - | - | - | - | - |
| 131628 | N/A | Point | - | - | - | - | S107791 | CRESTLAKE DR: CONSTANSO WAY | - | F | F | - | F | 23248000 | 23248000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CONSTANSO WAY | CRESTLAKE DR | 3436 | 3436 | 37.735167 | -122.48842585 | CRESTLAKE DR \ CONSTANSO WAY | CONSTANSO WAY \ CRESTLAKE DR | 1728435801000 | middleware_editor | STOP | CRESTLAKE DR intersection | - | 0 / 0 | - | - | - | - | - | 173287 | 255830400000 | -122.48842585 | 37.735167 | - | 1516320000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569980000 | CONSTANSO WAY | - | - | - | - | - | - |
| 131629 | N/A | Point | - | - | - | - | S107792 | 25TH AVE: LAWTON ST | - | F | F | - | F | 27392000 | 27392000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LAWTON ST | 25TH AVE | 3437 | 3437 | 37.75768385 | -122.48316146 | 25TH AVE \ LAWTON ST | LAWTON ST \ 25TH AVE | 1710539427000 | MTA | STOP | 25TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 173288 | 255830400000 | -122.48316146 | 37.75768385 | - | 1465171200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | LAWTON ST | - | - | - | - | - | - |
| 131630 | N/A | Point | - | - | - | - | S107793 | 25TH AVE: LAWTON ST | - | F | F | - | F | 27392000 | 27392000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAWTON ST | 25TH AVE | 3438 | 3438 | 37.75768385 | -122.48316146 | 25TH AVE \ LAWTON ST | LAWTON ST \ 25TH AVE | 1710539427000 | MTA | STOP | 25TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 173289 | 255830400000 | -122.48316146 | 37.75768385 | - | 1465171200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | LAWTON ST | - | - | - | - | - | - |
| 131631 | N/A | Point | - | - | - | - | S107795 | 40TH AVE: IRVING ST | - | F | F | - | F | 27789000 | 27789000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 40TH AVE | IRVING ST | 3440 | 3440 | 37.7625694 | -122.49962745 | IRVING ST \ 40TH AVE | 40TH AVE \ IRVING ST | 1737575210000 | middleware_editor | STOP | IRVING ST intersection | - | 0 / 0 | - | - | - | - | - | 173290 | 256348800000 | -122.49962745 | 37.7625694 | - | 1489708800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | 40TH AVE | - | - | - | - | - | - |
| 131632 | N/A | Point | - | - | - | - | S103241 | COMMONWEALTH AVE: EUCLID AVE | - | F | F | - | F | 26934000 | 26934000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | EUCLID AVE | EUCLID AVE | 3441 | 3441 | 37.78397889 | -122.45571133 | COMMONWEALTH AVE \ EUCLID AVE | COMMONWEALTH AVE \ EUCLID AVE | 1710539427000 | MTA | STOP | EUCLID AVE intersection | - | 0 / 00 | - | - | - | - | - | 173291 | -280713600000 | -122.45571133 | 37.78397889 | - | 1556150400000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568540000 | COMMONWEALTH AVE | - | - | - | - | - | - |
| 131633 | N/A | Point | - | - | - | - | S103242 | KEITH ST: YOSEMITE AVE | - | F | F | - | F | 20492000 | 20492000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | YOSEMITE AVE | YOSEMITE AVE | 3442 | 3442 | 37.72685132 | -122.39166982 | KEITH ST \ YOSEMITE AVE | KEITH ST \ YOSEMITE AVE | 1711588489000 | middleware_editor | STOP | YOSEMITE AVE intersection | - | 0 / 0 | - | - | - | - | - | 173292 | -280713600000 | -122.39166982 | 37.72685132 | - | 1515456000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568540000 | KEITH ST | - | - | - | - | - | - |
| 131634 | N/A | Point | - | - | - | - | S132349 | WAWONA ST: 15TH AVE | - | F | F | - | F | 22952000 | 22952000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | WAWONA ST | WAWONA ST | 24610 | 24610 | 37.73764891 | -122.47096273 | 15TH AVE \ WAWONA ST | 15TH AVE \ WAWONA ST | 1712159046000 | middleware_editor | ALL WAY | WAWONA ST intersection | - | - | - | - | - | - | - | 173293 | 1273708800000 | -122.47096273 | 37.73764891 | - | 1711984860000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373577660000 | 15TH AVE | - | - | - | - | - | - |
| 131635 | N/A | Point | 1 | 1 | 800 - 875 | - | S132350 | 800-875 ULLOA ST | 800-875 ULLOA ST | F | F | - | F | 12784000 | 12784000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | CLAREMONT BLVD | CLAREMONT BLVD | 24611 | 24611 | 37.7407324 | -122.46544593 | - | - | 1727486202000 | middleware_editor | PARKING (RA) | CLAREMONT BLVD to WEST PORTAL AVE (800 - 875) | - | IFO#807 SEE PHOTO | - | - | - | - | - | 173294 | 1273795200000 | -122.46544593 | 37.7407324 | - | - | - | D7 | - | PARKING | REG | G-P(SF).0040 | 24X30 | SUP2 | MUNI POLE | IS | 1373577660000 | ULLOA ST | 800 - 875 ULLOA ST | 800 - 875 ULLOA ST | 800 ULLOA ST | - | WEST PORTAL AVE | WEST PORTAL AVE |
| 131636 | N/A | Point | 1 | 1 | 200 - 299 | - | S132067 | 200-299 FOLSOM ST | 200-299 FOLSOM ST | F | F | - | F | 5652000 | 5652000 | - | - | NORTH SIDE | - | - | - | - | MAIN ST | MAIN ST | 24612 | 24612 | 37.78902797 | -122.39229056 | - | - | 1739229705000 | middleware_editor | 2 HR PRK 7AM-6PM EXC SUN | MAIN ST to BEALE ST (200 - 299) | - | 92FT SOUTH | - | - | - | - | - | 173295 | 1267401600000 | -122.39229056 | 37.78902797 | - | - | 1739190060000 | D6 | - | PARKING | REG | R32(CA).0071 | 18X18 | SUP1 | LIGHT POLE | RETD | 1373577600000 | FOLSOM ST | 200 - 299 FOLSOM ST | 200 - 299 FOLSOM ST | 200 FOLSOM ST | - | BEALE ST | BEALE ST |
| 131637 | N/A | Point | - | - | - | RIGHT ARROW | S235912 | PAGE ST: FRANKLIN ST | - | F | F | - | F | 24444000 | 24444000 | - | - | SOUTH WEST CORNER | - | - | - | - | PAGE ST | FRANKLIN ST | 73453 | 73453 | 37.7742944 | -122.42075989 | FRANKLIN ST \ PAGE ST | PAGE ST \ FRANKLIN ST | 1710539427000 | MTA | TANSAT | FRANKLIN ST intersection | - | - | - | - | - | - | - | 173296 | 1495717440000 | -122.42075989 | 37.7742944 | - | 1495670400000 | - | D5 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP1 | MUNI POLE | IS | 1494235920000 | PAGE ST | - | - | - | - | - | - |
| 131638 | N/A | Point | - | - | - | LEFT ARROW | S235914 | PAGE ST: FRANKLIN ST | - | F | F | - | F | 24444000 | 24444000 | - | - | SOUTH SIDE | - | - | - | - | PAGE ST | FRANKLIN ST | 73454 | 73454 | 37.7742944 | -122.42075989 | FRANKLIN ST \ PAGE ST | PAGE ST \ FRANKLIN ST | 1710539427000 | MTA | TANSAT | FRANKLIN ST intersection | - | 90`WEST | - | - | - | - | - | 173297 | 1495717860000 | -122.42075989 | 37.7742944 | - | 1495670400000 | - | D5 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP1 | 2IN FLANGE POST | IS | 1494236460000 | PAGE ST | - | - | - | - | - | - |
| 131639 | N/A | Point | - | - | - | - | S236288 | TARAVAL ST: 22ND AVE | - | F | F | - | F | 23199000 | 23199000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 22ND AVE | 73460 | 73460 | 37.74290864 | -122.47890479 | 22ND AVE \ TARAVAL ST | TARAVAL ST \ 22ND AVE | 1720576404000 | middleware_editor | FG 300 UR DELINEATOR (W) | 22ND AVE intersection | - | @X-WALK (6' TO CURB) 8' E (4' TO CURB) | - | - | - | - | - | 173298 | 1500478680000 | -122.47890479 | 37.74290864 | - | 1500422400000 | - | D4 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1495539660000 | TARAVAL ST | - | - | - | - | - | - |
| 131640 | N/A | Point | - | - | - | - | S236289 | TARAVAL ST: 22ND AVE | - | F | F | - | F | 23199000 | 23199000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 22ND AVE | 73461 | 73461 | 37.74290864 | -122.47890479 | 22ND AVE \ TARAVAL ST | TARAVAL ST \ 22ND AVE | 1720548785000 | middleware_editor | FG 300 UR DELINEATOR (W) | 22ND AVE intersection | - | @X-WALK (6' TO CURB) 8' W (4' TO CURB) | - | - | - | - | - | 173299 | 1500478740000 | -122.47890479 | 37.74290864 | - | 1500422400000 | - | D4 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1495539660000 | TARAVAL ST | - | - | - | - | - | - |
| 131641 | N/A | Point | - | - | - | - | S236290 | TARAVAL ST: 21ST AVE | - | F | F | - | F | 23198000 | 23198000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 21ST AVE | TARAVAL ST | 73462 | 73462 | 37.74295557 | -122.47783624 | TARAVAL ST \ 21ST AVE | 21ST AVE \ TARAVAL ST | 1721744531000 | middleware_editor | FG 300 UR DELINEATOR (W) | TARAVAL ST intersection | - | @X-WALK (6' TO CURB) 8' E (4' TO CURB) | - | - | - | - | - | 173300 | 1500549300000 | -122.47783624 | 37.74295557 | - | 1500508800000 | - | D4 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1495540200000 | 21ST AVE | - | - | - | - | - | - |
| 131642 | N/A | Point | - | - | - | - | S236291 | TARAVAL ST: 20TH AVE | - | F | F | - | F | 23195000 | 23195000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 20TH AVE | 73463 | 73463 | 37.74300263 | -122.4767646 | 20TH AVE \ TARAVAL ST | TARAVAL ST \ 20TH AVE | 1722994709000 | middleware_editor | FG 300 UR DELINEATOR (W) | 20TH AVE intersection | - | @X-WALK (6' TO CURB) 8' E (4' TO CURB) | - | - | - | - | - | 173301 | 1500478620000 | -122.4767646 | 37.74300263 | - | 1675382400000 | - | D4 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1495540380000 | TARAVAL ST | - | - | - | - | - | - |
| 131643 | N/A | Point | - | - | - | - | S112860 | WAWONA ST: 41ST AVE | - | F | F | - | F | 23430000 | 23430000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 41ST AVE | 41ST AVE | 10035 | 10035 | 37.73641744 | -122.49886941 | WAWONA ST \ 41ST AVE | WAWONA ST \ 41ST AVE | 1710539427000 | MTA | STOP | 41ST AVE intersection | - | BLOCK #300 PER DM | - | - | - | - | - | 173302 | 971222400000 | -122.49886941 | 37.73641744 | - | 1429833600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571540000 | WAWONA ST | - | - | - | - | - | - |
| 131644 | N/A | Point | - | - | - | - | S112861 | WAWONA ST: 41ST AVE | - | F | F | - | F | 23430000 | 23430000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 41ST AVE | 41ST AVE | 10036 | 10036 | 37.73641744 | -122.49886941 | WAWONA ST \ 41ST AVE | WAWONA ST \ 41ST AVE | 1710539427000 | MTA | STOP | 41ST AVE intersection | - | - | - | - | - | - | - | 173303 | 971222400000 | -122.49886941 | 37.73641744 | - | 1430870400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571540000 | WAWONA ST | - | - | - | - | - | - |
| 131645 | N/A | Point | - | - | - | - | S112862 | 1ST ST: HOWARD ST | - | F | F | - | F | 24532000 | 24532000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 1ST ST | 01ST ST | 10037 | 10037 | 37.78853593 | -122.39603477 | HOWARD ST \ 1ST ST | HOWARD ST \ 01ST ST | 1710539427000 | MTA | MUNI SIGNAL | 01ST ST intersection | - | ABOVE SIGNAL | - | - | - | - | - | 173304 | 971395200000 | -122.39603477 | 37.78853593 | - | - | - | D6 | - | OTHER REGULATORY | REG | R(SF).0136 | 24X24 | SUP1 | MUNI POLE | IS | 1373571540000 | HOWARD ST | - | - | - | - | - | - |
| 131646 | N/A | Point | - | - | - | - | S112865 | FUNSTON AVE: CLEMENT ST | - | F | F | - | F | 27482000 | 27482000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FUNSTON AVE | CLEMENT ST | 10039 | 10039 | 37.78259621 | -122.47191503 | CLEMENT ST \ FUNSTON AVE | FUNSTON AVE \ CLEMENT ST | 1710539427000 | MTA | RIGHT TURN ONLY (SYM) | CLEMENT ST intersection | - | - | - | - | - | - | - | 173305 | 971740800000 | -122.47191503 | 37.78259621 | - | - | - | D1 | - | OTHER REGULATORY | REG | R3-5.0001 | 24X30 | SUP2 | 2IN IRON POST | IS | 1373571540000 | FUNSTON AVE | - | - | - | - | - | - |
| 131647 | N/A | Point | 1 | 1 | 300 - 399 | - | S112866 | 300-399 FUNSTON AVE | 300-399 FUNSTON AVE | F | F | - | F | 5960000 | 5960000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 10040 | 10040 | 37.78163867 | -122.47184525 | - | - | 1710539427000 | MTA | RIGHT TURN ONLY (SYM) | CLEMENT ST to GEARY BLVD (300 - 399) | - | 50S | - | - | - | - | - | 173306 | 971740800000 | -122.47184525 | 37.78163867 | - | - | - | D1 | - | OTHER REGULATORY | REG | R3-5.0001 | 24X30 | SUP2 | LIGHT POLE | IS | 1373571540000 | FUNSTON AVE | 300 - 399 FUNSTON AVE | 300 - 399 FUNSTON AVE | 300 FUNSTON AVE | - | GEARY BLVD | GEARY BLVD |
| 131648 | N/A | Point | - | - | - | - | S112867 | FUNSTON AVE: CLEMENT ST | - | F | F | - | F | 27482000 | 27482000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FUNSTON AVE | CLEMENT ST | 10041 | 10041 | 37.78259621 | -122.47191503 | CLEMENT ST \ FUNSTON AVE | FUNSTON AVE \ CLEMENT ST | 1710539427000 | MTA | (RA) ONLY | CLEMENT ST intersection | - | 25S | - | - | - | - | - | 173307 | 971740800000 | -122.47191503 | 37.78259621 | - | - | - | D1 | - | OTHER REGULATORY | REG | R59(CA).0002 | 30X36 | SUP2 | 2IN IRON POST | IS | 1373571540000 | FUNSTON AVE | - | - | - | - | - | - |
| 131649 | N/A | Point | - | - | - | - | S107465 | MAGELLAN AVE: PLAZA ST | - | F | F | - | F | 22888000 | 22888000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MAGELLAN AVE | PLAZA ST | 10060 | 10060 | 37.74869513 | -122.46005054 | PLAZA ST \ MAGELLAN AVE | MAGELLAN AVE \ PLAZA ST | 1710539427000 | MTA | ONE WAY (LA) | PLAZA ST intersection | - | - | - | - | - | - | - | 173308 | 227491200000 | -122.46005054 | 37.74869513 | - | - | - | D7 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP2 | 2IN IRON POST | IS | 1373569860000 | MAGELLAN AVE | - | - | - | - | - | - |
| 131650 | N/A | Point | 1 | 1 | 200 - 297 | - | S107466 | 200-299 MAGELLAN AVE | 200-297 MAGELLAN AVE | F | F | - | F | 8618000 | 8618000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SOLA AVE | SOLA AVE | 10061 | 10061 | 37.74703579 | -122.46081261 | - | - | 1710539427000 | MTA | ONE WAY (LA) | SOLA AVE to PACHECO ST (200 - 297) | - | 105 WPL/MADE MAGELLAN ONE-WAY NB PA..... | - | - | - | - | - | 173309 | 227491200000 | -122.46081261 | 37.74703579 | - | 1513036800000 | - | D7 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | UNKNOWN | IS | 1373569860000 | MAGELLAN AVE | 200 - 297 MAGELLAN AVE | 200 - 297 MAGELLAN AVE | 200 MAGELLAN AVE | - | PACHECO ST | PACHECO ST |
| 131651 | N/A | Point | - | - | - | - | S111379 | JENNINGS ST: UNDERWOOD AVE | - | F | F | - | F | 20149000 | 20149000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | UNDERWOOD AVE | UNDERWOOD AVE | 10063 | 10063 | 37.7276664 | -122.38810995 | JENNINGS ST \ UNDERWOOD AVE | JENNINGS ST \ UNDERWOOD AVE | 1710539427000 | MTA | STOP | UNDERWOOD AVE intersection | - | - | - | - | - | - | - | 173310 | 784512000000 | -122.38810995 | 37.7276664 | - | 1506643200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571120000 | JENNINGS ST | - | - | - | - | - | - |
| 131652 | N/A | Point | - | - | - | - | S111380 | JENNINGS ST: YOSEMITE AVE | - | F | F | - | F | 20482000 | 20482000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | YOSEMITE AVE | YOSEMITE AVE | 10064 | 10064 | 37.72579056 | -122.38980071 | JENNINGS ST \ YOSEMITE AVE | JENNINGS ST \ YOSEMITE AVE | 1735070162000 | middleware_editor | STOP | YOSEMITE AVE intersection | - | - | - | - | - | - | - | 173311 | 784512000000 | -122.38980071 | 37.72579056 | - | 1735036200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571120000 | JENNINGS ST | - | - | - | - | - | - |
| 131653 | N/A | Point | 1 | 1 | 4400 - 4455 | - | S115646 | 4400-4455 17TH ST | 4400-4455 17TH ST | F | F | - | F | 818000 | 818000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | TEMPLE ST | TEMPLE ST | 10954 | 10954 | 37.76197169 | -122.44377746 | - | - | 1710539427000 | MTA | YIELD TO PEDESTRIANS | TEMPLE ST to MARS ST (4400 - 4455) | - | EAST SIDE OF EAST LINE | - | - | - | - | - | 173312 | 1036108800000 | -122.44377746 | 37.76197169 | - | - | - | D8 | - | OTHER REGULATORY | REG | R1-5.0004 | 24X24 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1373572440000 | 17TH ST | 4400 - 4455 17TH ST | 4400 - 4455 17TH ST | 4400 17TH ST | - | MARS ST | MARS ST |
| 131654 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S113778 | 1800-1899 IRVING ST | 1800-1899 IRVING ST | F | F | - | F | 7296000 | 7296000 | - | - | NORTH SIDE | - | - | - | - | 19TH AVE | 19TH AVE | 10955 | 10955 | 37.76353713 | -122.47768247 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM TUE THUR SUN STCL | 19TH AVE to 20TH AVE (1800 - 1899) | - | IFO#1838 | - | - | - | - | - | 173313 | 996537600000 | -122.47768247 | 37.76353713 | - | 1477267200000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0134 | 18X18 | SUP2 | LIGHT POLE | IS | 1373571840000 | IRVING ST | 1800 - 1899 IRVING ST | 1800 - 1899 IRVING ST | 1800 IRVING ST | - | 20TH AVE | 20TH AVE |
| 131655 | N/A | Point | 1 | 1 | 1900 - 1999 | - | S113779 | 1900-1999 IRVING ST | 1900-1999 IRVING ST | F | F | - | F | 7297000 | 7297000 | - | - | NORTH SIDE | - | - | - | - | 20TH AVE | 20TH AVE | 10956 | 10956 | 37.76349109 | -122.47872867 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM TUE THUR SUN STCL | 20TH AVE to 21ST AVE (1900 - 1999) | - | 50`WEST | - | - | - | - | - | 173314 | 996537600000 | -122.47872867 | 37.76349109 | - | - | - | D4 | - | STREET CLEANING | REG | R30B(CA).0134 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1373571840000 | IRVING ST | 1900 - 1999 IRVING ST | 1900 - 1999 IRVING ST | 1900 IRVING ST | - | 21ST AVE | 21ST AVE |
| 131656 | N/A | Point | 1 | 1 | 1900 - 1999 | - | S113780 | 1900-1999 IRVING ST | 1900-1999 IRVING ST | F | F | - | F | 7297000 | 7297000 | - | - | NORTH SIDE | - | - | - | - | 20TH AVE | 20TH AVE | 10957 | 10957 | 37.76349109 | -122.47872867 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM TUE THUR SUN STCL | 20TH AVE to 21ST AVE (1900 - 1999) | - | IFOL#1924 | - | - | - | - | - | 173315 | 996537600000 | -122.47872867 | 37.76349109 | - | - | - | D4 | - | STREET CLEANING | REG | R30B(CA).0134 | 18X18 | SUP2 | LIGHT POLE | IS | 1373571840000 | IRVING ST | 1900 - 1999 IRVING ST | 1900 - 1999 IRVING ST | 1900 IRVING ST | - | 21ST AVE | 21ST AVE |
| 131657 | N/A | Point | 1 | 1 | 200 - 299 | - | S114655 | 200-299 BUENA VISTA EAST AVE | 200-299 BUENA VISTA AVE EAST | F | F | - | F | 3364000 | 3364000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BUENA VISTA AVE \ BUENA VISTA TER \ DUBOCE AVE | BUENA VISTA AVE \ BUENA VISTA TER \ DUBOCE AVE | 10958 | 10958 | 37.76854189 | -122.43876439 | - | - | 1710539427000 | MTA | STOP | BUENA VISTA AVE \ BUENA VISTA TER \ DUBOCE AVE to BUENA VISTA AVE \ PARK HILL AVE (200 - 299) | - | OPP #181 | - | - | - | - | - | 173316 | 1012608000000 | -122.43876439 | 37.76854189 | - | 1513641600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373572140000 | BUENA VISTA AVE EAST | 200 - 299 BUENA VISTA AVE EAST | 200 - 299 BUENA VISTA AVE EAST | 200 BUENA VISTA AVE EAST | - | BUENA VISTA AVE \ PARK HILL AVE | BUENA VISTA AVE \ PARK HILL AVE |
| 131658 | N/A | Point | 1 | 1 | 200 - 299 | - | S114656 | 200-299 BUENA VISTA EAST AVE | 200-299 BUENA VISTA AVE EAST | F | F | - | F | 3364000 | 3364000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BUENA VISTA AVE \ BUENA VISTA TER \ DUBOCE AVE | BUENA VISTA AVE \ BUENA VISTA TER \ DUBOCE AVE | 10959 | 10959 | 37.76854189 | -122.43876439 | - | - | 1710539427000 | MTA | ALL WAY | BUENA VISTA AVE \ BUENA VISTA TER \ DUBOCE AVE to BUENA VISTA AVE \ PARK HILL AVE (200 - 299) | - | OPP #181 | - | - | - | - | - | 173317 | 1012608000000 | -122.43876439 | 37.76854189 | - | 1513641600000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1373572140000 | BUENA VISTA AVE EAST | 200 - 299 BUENA VISTA AVE EAST | 200 - 299 BUENA VISTA AVE EAST | 200 BUENA VISTA AVE EAST | - | BUENA VISTA AVE \ PARK HILL AVE | BUENA VISTA AVE \ PARK HILL AVE |
| 131659 | N/A | Point | 1 | 1 | 200 - 299 | - | S114515 | 200-299 PIERCE ST | 200-299 PIERCE ST | F | F | - | F | 10419000 | 10419000 | - | - | WEST SIDE | - | - | - | - | HAIGHT ST | HAIGHT ST | 12421 | 12421 | 37.77215429 | -122.43382848 | - | - | 1753213297000 | middleware_editor | MOTORCYCLE PRK ONLY | HAIGHT ST to PAGE ST (200 - 299) | - | AT PAINT MARK-42 1/2 FT. SOUTH OF P..... | - | - | - | - | - | 173318 | 1008144000000 | -122.43382848 | 37.77215429 | - | - | - | D5 | - | PARKING | REG | R32F(SF).0003 | 10X15 | SUP1 | 2IN IRON POST | IS | 1373572080000 | PIERCE ST | 200 - 299 PIERCE ST | 200 - 299 PIERCE ST | 200 PIERCE ST | - | PAGE ST | PAGE ST |
| 131660 | N/A | Point | - | - | - | - | S236681 | PAGE ST: OCTAVIA ST | - | T | T | - | F | 25909000 | 25909000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 73847 | 73847 | 37.77388924 | -122.42394706 | PAGE ST \ OCTAVIA ST | PAGE ST \ OCTAVIA ST | 1710539427000 | MTA | BIKE WAYFINDING SIGN | OCTAVIA ST intersection | 0186 | - | - | - | - | - | - | 173319 | 1545229440000 | -122.42394706 | 37.77388924 | - | - | - | D5 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | MUNI POLE | IS | 1496748840000 | PAGE ST | - | - | - | - | - | - |
| 131661 | N/A | Point | - | - | - | - | S236682 | PAGE ST: OCTAVIA ST | - | T | T | - | F | 25909000 | 25909000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 73848 | 73848 | 37.77388924 | -122.42394706 | PAGE ST \ OCTAVIA ST | PAGE ST \ OCTAVIA ST | 1710539427000 | MTA | BIKE WAYFINDING SIGN | OCTAVIA ST intersection | 0187 | - | - | - | - | - | - | 173320 | 1545229500000 | -122.42394706 | 37.77388924 | - | - | - | D5 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | MUNI POLE | IS | 1496749800000 | PAGE ST | - | - | - | - | - | - |
| 131662 | N/A | Point | - | - | - | - | S236857 | FOLSOM ST: 11TH ST | - | T | T | - | F | 24238000 | 24238000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | FOLSOM ST | 73850 | 73850 | 37.77186371 | -122.41402671 | 11TH ST \ FOLSOM ST | 11TH ST \ FOLSOM ST | 1710539427000 | MTA | BIKE WAYFINDING SIGN | FOLSOM ST intersection | 0162 | - | - | - | - | - | - | 173321 | 1543834740000 | -122.41402671 | 37.77186371 | - | - | - | D6 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | SIGNAL POLE | IS | 1497441600000 | 11TH ST | - | - | - | - | - | - |
| 131663 | N/A | Point | - | - | - | - | S236860 | FOLSOM ST: 7TH ST | - | F | F | - | F | 24262000 | 24262000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | FOLSOM ST | 73852 | 73852 | 37.77674611 | -122.40784206 | 7TH ST \ FOLSOM ST | 07TH ST \ FOLSOM ST | 1738947855000 | middleware_editor | BIKE WAYFINDING SIGN | FOLSOM ST intersection | 0164 | - | - | - | - | - | - | 173322 | 1542291780000 | -122.40784206 | 37.77674611 | - | - | - | D6 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | 2IN IRON POST | IS | 1497443160000 | 07TH ST | - | - | - | - | - | - |
| 131664 | N/A | Point | - | - | - | - | S236861 | FOLSOM ST: 5TH ST | - | F | F | - | F | 23937000 | 23937000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | 05TH ST | 73853 | 73853 | 37.78026497 | -122.40338721 | 5TH ST \ FOLSOM ST | FOLSOM ST \ 05TH ST | 1710539427000 | MTA | BIKE WAYFINDING SIGN | 05TH ST intersection | 0165 | - | - | - | - | - | - | 173323 | - | -122.40338721 | 37.78026497 | - | - | - | D6 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | 2IN IRON POST | IS | 1497443760000 | FOLSOM ST | - | - | - | - | - | - |
| 131665 | N/A | Point | - | - | - | - | S236862 | FOLSOM ST: 5TH ST | - | F | F | - | F | 23937000 | 23937000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | 05TH ST | 73854 | 73854 | 37.78026497 | -122.40338721 | 5TH ST \ FOLSOM ST | FOLSOM ST \ 05TH ST | 1710539427000 | MTA | BIKE WAYFINDING SIGN | 05TH ST intersection | 0165 | - | - | - | - | - | - | 173324 | 1542291960000 | -122.40338721 | 37.78026497 | - | - | - | D6 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | 2IN IRON POST | IS | 1497444120000 | FOLSOM ST | - | - | - | - | - | - |
| 131666 | N/A | Point | 1 | 1 | 700 - 763 | - | S236865 | 700-763 FOLSOM ST | 700-763 FOLSOM ST | F | F | - | F | 5662000 | 5662000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 3RD ST | 03RD ST | 73855 | 73855 | 37.78321473 | -122.39965235 | - | - | 1753132807000 | middleware_editor | BIKE WAYFINDING SIGN | 03RD ST to MABINI ST (700 - 763) | 0166 | OPP#600 | - | - | - | - | - | 173325 | 1542320820000 | -122.39965235 | 37.78321473 | - | - | - | D6 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | 2IN IRON POST | IS | 1497447120000 | FOLSOM ST | 700 - 763 FOLSOM ST | 700 - 763 FOLSOM ST | 700 FOLSOM ST | - | MABINI ST | MABINI ST |
| 131667 | N/A | Point | 1 | 1 | 1200 - 1399 | - | S251491 | 1200-1399 INDIANA ST | 1200-1399 INDIANA ST | F | F | - | F | 7198000 | 7198000 | - | - | EAST SIDE | - | - | - | - | 23RD ST | 23RD ST | 79106 | 79106 | 37.75393679 | -122.39078579 | - | - | 1713835614000 | middleware_editor | NPRK 12MN-6AM FRI STCL | 23RD ST to 25TH ST \ I-280 N ON RAMP (1200 - 1399) | - | 15' SOUTH OF #1325 GARAGE ENTRANCE | - | - | - | - | - | 173326 | 1550746500000 | -122.39078579 | 37.75393679 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0046 | 18X18 | SUP1 | 2IN IRON POST | IS | 1549877820000 | INDIANA ST | 1200 - 1399 INDIANA ST | 1200 - 1399 INDIANA ST | 1200 INDIANA ST | - | 25TH ST \ I-280 N ON RAMP | 25TH ST \ I-280 N ON RAMP |
| 131668 | N/A | Point | 1 | 1 | 100 - 199 | - | S247565 | 100-199 PAGE ST | 100-199 PAGE ST | F | F | - | F | 10170000 | 10170000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | GOUGH ST | GOUGH ST | 79107 | 79107 | 37.77398711 | -122.42317709 | - | - | 1710539427000 | MTA | WARNING DFSZ/DON'T DO DRUGS | GOUGH ST to OCTAVIA ST (100 - 199) | - | 63'WEST OF GOUGH ST | - | - | - | - | - | 173327 | - | -122.42317709 | 37.77398711 | - | - | - | D5 | - | OTHER WARNING | WARNING | SW(SF).0001 | 24X18 | SUP1 | LIGHT POLE | IS | 1533303540000 | PAGE ST | 100 - 199 PAGE ST | 100 - 199 PAGE ST | 100 PAGE ST | - | OCTAVIA ST | OCTAVIA ST |
| 131669 | N/A | Point | 1 | 1 | 100 - 199 | - | S247566 | 100-199 PAGE ST | 100-199 PAGE ST | F | F | - | F | 10170000 | 10170000 | - | - | SOUTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | GOUGH ST | GOUGH ST | 79108 | 79108 | 37.77398711 | -122.42317709 | - | - | 1710539427000 | MTA | WARNING DFSZ/DON'T DO DRUGS | GOUGH ST to OCTAVIA ST (100 - 199) | - | 63'WEST OF GOUGH ST | - | - | - | - | - | 173328 | - | -122.42317709 | 37.77398711 | - | - | - | D5 | - | OTHER WARNING | WARNING | SW(SF).0001 | 24X18 | SUP1 | LIGHT POLE | IS | 1533303600000 | PAGE ST | 100 - 199 PAGE ST | 100 - 199 PAGE ST | 100 PAGE ST | - | OCTAVIA ST | OCTAVIA ST |
| 131670 | N/A | Point | - | - | - | - | S247567 | JERROLD AVE: RANKIN ST | - | F | F | - | F | 33115000 | 33115000 | - | - | NORTH EAST CORNER | - | - | - | - | JERROLD AVE | JERROLD AVE | 79109 | 79109 | 37.74193658 | -122.39504606 | RANKIN ST \ JERROLD AVE | RANKIN ST \ JERROLD AVE | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | JERROLD AVE intersection | - | 10 FT OC 40 FT NORTH | - | - | - | - | - | 173329 | 1535107440000 | -122.39504606 | 37.74193658 | - | 1671062400000 | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1533307560000 | RANKIN ST | - | - | - | - | - | - |
| 131671 | N/A | Point | - | - | - | - | S247569 | JERROLD AVE: RANKIN ST | - | F | F | - | F | 33115000 | 33115000 | - | - | NORTH SIDE | - | - | - | - | JERROLD AVE | JERROLD AVE | 79111 | 79111 | 37.74193658 | -122.39504606 | RANKIN ST \ JERROLD AVE | RANKIN ST \ JERROLD AVE | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | JERROLD AVE intersection | - | 250 FT NORTH | - | - | - | - | - | 173330 | 1535369880000 | -122.39504606 | 37.74193658 | - | 1572998400000 | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1533307980000 | RANKIN ST | - | - | - | - | - | - |
| 131672 | N/A | Point | - | - | - | - | S247570 | JERROLD AVE: RANKIN ST | - | F | F | - | F | 33115000 | 33115000 | - | - | SOUTH SIDE | - | - | - | - | JERROLD AVE | JERROLD AVE | 79112 | 79112 | 37.74193658 | -122.39504606 | RANKIN ST \ JERROLD AVE | RANKIN ST \ JERROLD AVE | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | JERROLD AVE intersection | - | 250 FT NORTH | - | - | - | - | - | 173331 | 1535369760000 | -122.39504606 | 37.74193658 | - | 1630540800000 | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1533308040000 | RANKIN ST | - | - | - | - | - | - |
| 131673 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S247624 | 1800-1899 SACRAMENTO ST | 1800-1899 SACRAMENTO ST | F | F | - | F | 11249000 | 11249000 | - | - | NORTH SIDE | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 79113 | 79113 | 37.7911851 | -122.4233382 | - | - | 1710539427000 | MTA | (H/C SYM) PARK ONLY/MIN FINE $250 | VAN NESS AVE to FRANKLIN ST (1800 - 1899) | - | 21' W OF VAN NESS | - | - | - | - | - | 173332 | 1533772800000 | -122.4233382 | 37.7911851 | - | - | - | D2 | - | OTHER REGULATORY | REG | R99C(CA).0001 | 12X24 | SUP1 | 2IN IRON POST | IS | 1533640800000 | SACRAMENTO ST | 1800 - 1899 SACRAMENTO ST | 1800 - 1899 SACRAMENTO ST | 1800 SACRAMENTO ST | - | FRANKLIN ST | FRANKLIN ST |
| 131674 | N/A | Point | - | - | - | - | S248384 | ROSEWOOD DR: FERNWOOD DR \ RAV | - | F | F | - | F | 22813000 | 22813000 | - | - | NORTH EAST CORNER | - | - | - | - | FERNWOOD DR \ RAVENWOOD DR | FERNWOOD DR \ RAVENWOOD DR | 79114 | 79114 | 37.73475386 | -122.46155104 | ROSEWOOD DR \ FERNWOOD DR \ RAVENWOOD DR | ROSEWOOD DR \ FERNWOOD DR \ RAVENWOOD DR | 1710539427000 | MTA | ALL WAY | FERNWOOD DR \ RAVENWOOD DR intersection | - | OF ROSEWOOD DR & FERNWOOD DR-F/W/B/T | - | - | - | - | - | 173333 | 539913600000 | -122.46155104 | 37.73475386 | - | 1538438400000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1537348260000 | ROSEWOOD DR | - | - | - | - | - | - |
| 131675 | N/A | Point | - | - | - | - | S236089 | FELL ST: STEINER ST | - | T | T | - | F | 26038000 | 26038000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | STEINER ST | FELL ST | 69729 | 69729 | 37.77469266 | -122.43264862 | FELL ST \ STEINER ST | STEINER ST \ FELL ST | 1721179827000 | middleware_editor | SPEED LIMIT 25 | FELL ST intersection | - | ABOVE SIGNAL | - | - | - | - | - | 173334 | 1500390060000 | -122.43264862 | 37.77469266 | - | 1500336000000 | - | D5 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP1 | LIGHT POLE | IS | 1494593880000 | STEINER ST | - | - | - | - | - | - |
| 131676 | N/A | Point | 1 | 1 | 1 - 99 | - | S232070 | 1-99 HAWTHORNE ST | 1-99 HAWTHORNE ST | F | F | - | F | 6809000 | 6809000 | - | - | WEST SIDE | - | - | - | - | HOWARD ST | HOWARD ST | 69734 | 69734 | 37.78528292 | -122.39859057 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM MON WED FRI STCL | HOWARD ST to FOLSOM ST (1 - 99) | - | 5' SOUTH OF HOWARD | - | - | - | - | - | 173335 | - | -122.39859057 | 37.78528292 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0051 | 18X18 | SUP1 | LIGHT POLE | IS | 1482915420000 | HAWTHORNE ST | 1 - 99 HAWTHORNE ST | 1 - 99 HAWTHORNE ST | 1 HAWTHORNE ST | - | FOLSOM ST | FOLSOM ST |
| 131677 | N/A | Point | 1 | 1 | 1 - 99 | - | S232071 | 1-99 HAWTHORNE ST | 1-99 HAWTHORNE ST | F | F | - | F | 6809000 | 6809000 | - | - | WEST SIDE | - | - | - | - | HOWARD ST | HOWARD ST | 69735 | 69735 | 37.78528292 | -122.39859057 | - | - | 1710539427000 | MTA | TANSAT | HOWARD ST to FOLSOM ST (1 - 99) | - | 5' SOUTH OF HOWARD | - | - | - | - | - | 173336 | - | -122.39859057 | 37.78528292 | - | - | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1482915480000 | HAWTHORNE ST | 1 - 99 HAWTHORNE ST | 1 - 99 HAWTHORNE ST | 1 HAWTHORNE ST | - | FOLSOM ST | FOLSOM ST |
| 131678 | N/A | Point | - | - | - | - | S282066 | MINNESOTA ST: 18TH ST | - | F | F | - | F | 23650000 | 23650000 | - | - | NORTH EAST CORNER | - | - | - | - | MINNESOTA ST | 18TH ST | 86475 | 86475 | 37.76292575 | -122.39069849 | 18TH ST \ MINNESOTA ST | MINNESOTA ST \ 18TH ST | 1720489381000 | middleware_editor | FG 300 UR DELINEATOR (W) | 18TH ST intersection | - | 17 FT FROM CURB | - | - | - | - | - | 173337 | 1661212800000 | -122.39069849 | 37.76292575 | - | - | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1649073120000 | MINNESOTA ST | - | - | - | - | - | - |
| 131679 | N/A | Point | - | - | - | - | S282070 | ULLOA ST: WEST PORTAL AVE | - | T | T | - | F | 22928000 | 22928000 | - | - | SOUTH EAST CORNER | - | - | - | - | ULLOA ST | ULLOA ST | 86476 | 86476 | 37.74089198 | -122.46582902 | WEST PORTAL AVE \ ULLOA ST | WEST PORTAL AVE \ ULLOA ST | 1727469570000 | middleware_editor | TRAFFIC SAFETY MIRROR | ULLOA ST intersection | - | - | - | - | - | - | - | 173338 | 1661212800000 | -122.46582902 | 37.74089198 | - | - | - | D7 | - | OTHER REGULATORY | REG | R(SF).0341 | 36X36 | SUP2 | MUNI POLE | IS | 1649078700000 | WEST PORTAL AVE | - | - | - | - | - | - |
| 131680 | N/A | Point | - | - | - | - | S282123 | NATOMA ST: 5TH ST | - | T | T | - | F | 23945000 | 23945000 | - | - | SOUTH WEST CORNER | - | - | - | - | NATOMA ST | 05TH ST | 86477 | 86477 | 37.78192502 | -122.40546628 | 5TH ST \ NATOMA ST | NATOMA ST \ 05TH ST | 1710539427000 | MTA | NATOMA ST | 05TH ST intersection | - | 400-->II W | - | - | - | - | - | 173339 | -388195200000 | -122.40546628 | 37.78192502 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.1259 | 36X08 | SUP1 | LIGHT POLE | IS | 1649325300000 | NATOMA ST | - | - | - | - | - | - |
| 131681 | N/A | Point | - | - | - | - | S282124 | NATOMA ST: MARY ST | - | F | F | - | F | 24283000 | 24283000 | - | - | SOUTH WEST CORNER | - | - | - | - | NATOMA ST | NATOMA ST | 86478 | 86478 | 37.78130585 | -122.40624778 | MARY ST \ NATOMA ST | MARY ST \ NATOMA ST | 1739226445000 | middleware_editor | NATOMA ST | NATOMA ST intersection | - | SWC 400> WEST / ABOVE R1 | - | - | - | - | - | 173340 | 86572800000 | -122.40624778 | 37.78130585 | - | 1739183400000 | - | D6 | - | STREET NAME | GUIDE | D3-1.1259 | 36X08 | SUP1 | 2IN IRON POST | IS | 1649326500000 | MARY ST | - | - | - | - | - | - |
| 131682 | N/A | Point | - | - | - | - | S271877 | LEAVENWORTH ST: ELLIS ST | - | T | T | - | F | 25139000 | 25139000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 86479 | 86479 | 37.78465714 | -122.4144302 | LEAVENWORTH ST \ ELLIS ST | LEAVENWORTH ST \ ELLIS ST | 1710539427000 | MTA | SPEED LIMIT 20 | ELLIS ST intersection | - | - | - | - | - | - | - | 173341 | 1600128000000 | -122.4144302 | 37.78465714 | - | 1623801600000 | - | D6 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1611667680000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 131683 | N/A | Point | 1 | 1 | 500 - 599 | - | S271878 | 500-599 LEAVENWORTH ST | 500-599 LEAVENWORTH ST | F | F | - | F | 8243000 | 8243000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | OFARRELL ST | OFARRELL ST | 86480 | 86480 | 37.78605115 | -122.41471193 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | OFARRELL ST to GEARY ST (500 - 599) | - | 15 FT NORTH OF OFARRELL | - | - | - | - | - | 173342 | 1173312000000 | -122.41471193 | 37.78605115 | - | 1623801600000 | - | D6 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | 2IN IRON POST | IS | 1611667920000 | LEAVENWORTH ST | 500 - 599 LEAVENWORTH ST | 500 - 599 LEAVENWORTH ST | 500 LEAVENWORTH ST | - | GEARY ST | GEARY ST |
| 131684 | N/A | Point | - | - | - | - | S265207 | YORK ST: 25TH ST | - | F | F | - | F | 23951000 | 23951000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 25TH ST | 25TH ST | 86481 | 86481 | 37.7512568 | -122.40803685 | YORK ST \ 25TH ST | YORK ST \ 25TH ST | 1714787226000 | middleware_editor | ALL WAY | 25TH ST intersection | - | 0 / 0 | - | - | - | - | - | 173343 | -57369600000 | -122.40803685 | 37.7512568 | - | 1592956800000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1592383560000 | YORK ST | - | - | - | - | - | - |
| 131685 | N/A | Point | - | - | - | - | S265209 | 25TH ST: YORK ST | - | F | F | - | F | 23951000 | 23951000 | - | - | NORTH SIDE | - | - | - | - | 25TH ST | 25TH ST | 86483 | 86483 | 37.7512568 | -122.40803685 | YORK ST \ 25TH ST | YORK ST \ 25TH ST | 1714787229000 | middleware_editor | NPRK 8AM-10AM MON STCL | 25TH ST intersection | - | EPL 2928 | - | - | - | - | - | 173344 | 1547683200000 | -122.40803685 | 37.7512568 | - | 1593129600000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0261 | 18X18 | SUP2 | 2IN IRON POST | IS | 1592383860000 | YORK ST | - | - | - | - | - | - |
| 131686 | N/A | Point | 1 | 1 | 200 - 299 | - | S244199 | 200-299 TURK ST | 200-299 TURK ST | F | F | - | F | 12718000 | 12718000 | - | - | SOUTH SIDE | - | - | - | - | JONES ST | JONES ST | 81758 | 81758 | 37.78289926 | -122.41323276 | - | - | 1737566437000 | middleware_editor | TANP EXCEPT ACTIVE LOADING | JONES ST to LEAVENWORTH ST (200 - 299) | - | 155' E OF LEAVENWORTH | - | - | - | - | - | 173345 | 1172707200000 | -122.41323276 | 37.78289926 | - | 1522800000000 | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(SF).0159 | 18X21 | SUP1 | 2IN IRON POST | IS | 1522318200000 | TURK ST | 200 - 299 TURK ST | 200 - 299 TURK ST | 200 TURK ST | - | LEAVENWORTH ST | LEAVENWORTH ST |
| 131687 | N/A | Point | 1 | 1 | 300 - 399 | RIGHT ARROW | S244207 | 300-399 TURK ST | 300-399 TURK ST | F | F | - | F | 12719000 | 12719000 | - | - | SOUTH SIDE | - | - | - | - | LEAVENWORTH ST | LEAVENWORTH ST | 81760 | 81760 | 37.78268974 | -122.41487382 | - | - | 1737566433000 | middleware_editor | TANSAT | LEAVENWORTH ST to HYDE ST (300 - 399) | - | WPL #321 | - | - | - | - | - | 173346 | 1477612800000 | -122.41487382 | 37.78268974 | - | 1522800000000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1522320240000 | TURK ST | 300 - 399 TURK ST | 300 - 399 TURK ST | 300 TURK ST | - | HYDE ST | HYDE ST |
| 131688 | N/A | Point | 1 | 1 | 300 - 399 | LEFT ARROW | S244208 | 300-399 TURK ST | 300-399 TURK ST | F | F | - | F | 12719000 | 12719000 | - | - | SOUTH SIDE | - | - | - | - | LEAVENWORTH ST | LEAVENWORTH ST | 81761 | 81761 | 37.78268974 | -122.41487382 | - | - | 1737566449000 | middleware_editor | TANSAT | LEAVENWORTH ST to HYDE ST (300 - 399) | - | 242' E OF HYDE | - | - | - | - | - | 173347 | 1477612800000 | -122.41487382 | 37.78268974 | - | 1522800000000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1522320360000 | TURK ST | 300 - 399 TURK ST | 300 - 399 TURK ST | 300 TURK ST | - | HYDE ST | HYDE ST |
| 131689 | N/A | Point | 1 | 1 | 300 - 399 | RIGHT ARROW | S244209 | 300-399 TURK ST | 300-399 TURK ST | F | F | - | F | 12719000 | 12719000 | - | - | SOUTH SIDE | - | - | - | - | LEAVENWORTH ST | LEAVENWORTH ST | 81762 | 81762 | 37.78268974 | -122.41487382 | - | - | 1737566443000 | middleware_editor | TANP EXCEPT ACTIVE LOADING | LEAVENWORTH ST to HYDE ST (300 - 399) | - | 242' E OF HYDE | - | - | - | - | - | 173348 | 1477612800000 | -122.41487382 | 37.78268974 | - | 1522800000000 | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(SF).0159 | 18X21 | SUP1 | 2IN IRON POST | IS | 1522320480000 | TURK ST | 300 - 399 TURK ST | 300 - 399 TURK ST | 300 TURK ST | - | HYDE ST | HYDE ST |
| 131690 | N/A | Point | 1 | 1 | 300 - 399 | RIGHT ARROW | S244210 | 300-399 TURK ST | 300-399 TURK ST | F | F | - | F | 12719000 | 12719000 | - | - | SOUTH SIDE | - | - | - | - | LEAVENWORTH ST | LEAVENWORTH ST | 81763 | 81763 | 37.78268974 | -122.41487382 | - | - | 1737566445000 | middleware_editor | TANSAT | LEAVENWORTH ST to HYDE ST (300 - 399) | - | 197' E OF HYDE | - | - | - | - | - | 173349 | 1477612800000 | -122.41487382 | 37.78268974 | - | 1522800000000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1522320720000 | TURK ST | 300 - 399 TURK ST | 300 - 399 TURK ST | 300 TURK ST | - | HYDE ST | HYDE ST |
| 131691 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S245138 | 1500-1599 FILLMORE ST | 1500-1599 FILLMORE ST | T | T | - | F | 5546000 | 5546000 | - | - | EAST SIDE | - | - | - | - | OFARRELL ST | OFARRELL ST | 81764 | 81764 | 37.78382383 | -122.43281021 | - | - | 1710539427000 | MTA | GEARY ST | OFARRELL ST to GEARY BLVD (1500 - 1599) | - | SPL #1526 | - | - | - | - | - | 173350 | - | -122.43281021 | 37.78382383 | - | - | - | D5 | - | STREET NAME | GUIDE | D3-2.0167 | 72X18 | SUP1 | LIGHT POLE | IS | 1525086360000 | FILLMORE ST | 1500 - 1599 FILLMORE ST | 1500 - 1599 FILLMORE ST | 1500 FILLMORE ST | - | GEARY BLVD | GEARY BLVD |
| 131692 | N/A | Point | - | - | - | - | S243682 | HARRISON ST: 4TH ST \ I-80 W O | - | F | F | - | F | 23906000 | 23906000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HARRISON ST \ I-80 W ON RAMP | 04TH ST \ I-80 W ON RAMP | 81765 | 81765 | 37.78079148 | -122.39961623 | HARRISON ST \ 04TH ST \ I-80 W ON RAMP | HARRISON ST \ 04TH ST \ I-80 W ON RAMP | 1738015675000 | middleware_editor | ONE WAY (RA) | 04TH ST \ I-80 W ON RAMP intersection | - | - | - | - | - | - | - | 173351 | 1521032460000 | -122.39961623 | 37.78079148 | - | 1737983100000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1521030540000 | HARRISON ST | - | - | - | - | - | - |
| 131693 | N/A | Point | 1 | 1 | 600 - 699 | - | S244972 | 600-699 8TH ST | 600-699 08TH ST | F | F | - | F | 417000 | 417000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | BRANNAN ST | BRANNAN ST | 81766 | 81766 | 37.77067961 | -122.40465122 | - | - | 1710539427000 | MTA | YIELD (SYM) | BRANNAN ST to TOWNSEND ST (600 - 699) | - | 65` N OF DIVISION (ON STREET) | - | - | - | - | - | 173352 | 1525263780000 | -122.40465122 | 37.77067961 | - | - | - | D6 | - | OTHER REGULATORY | REG | R1-2.0002 | 24X24 | SUP1 | 2IN IRON POST | IS | 1524647760000 | 08TH ST | 600 - 699 8TH ST | 600 - 699 08TH ST | 600 8TH ST | - | TOWNSEND ST | TOWNSEND ST |
| 131694 | N/A | Point | 1 | 1 | 600 - 699 | - | S244973 | 600-699 8TH ST | 600-699 08TH ST | F | F | - | F | 417000 | 417000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | BRANNAN ST | BRANNAN ST | 81767 | 81767 | 37.77067961 | -122.40465122 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | BRANNAN ST to TOWNSEND ST (600 - 699) | - | 65` N OF DIVISION (ON STREET) | - | - | - | - | - | 173353 | 1525262040000 | -122.40465122 | 37.77067961 | - | - | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1524647940000 | 08TH ST | 600 - 699 8TH ST | 600 - 699 08TH ST | 600 8TH ST | - | TOWNSEND ST | TOWNSEND ST |
| 131695 | N/A | Point | 1 | 1 | 1 - 99 | - | S243533 | 1-99 BALBOA ST | 1-99 BALBOA ST | F | F | - | F | 2645000 | 2645000 | - | - | NORTH SIDE | - | - | - | - | ARGUELLO BLVD \ TURK BLVD | ARGUELLO BLVD \ TURK BLVD | 81768 | 81768 | 37.77741738 | -122.45911899 | - | - | 1741872004000 | middleware_editor | NPRK 8AM-10AM 1ST & 3RD MON OF MONTH STCL | ARGUELLO BLVD \ TURK BLVD to 02ND AVE (1 - 99) | - | IFO 26 | - | - | - | - | - | 173354 | - | -122.45911899 | 37.77741738 | - | 1741817100000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0248 | 18X18 | SUP2 | LIGHT POLE | IS | 1520421300000 | BALBOA ST | 1 - 99 BALBOA ST | 1 - 99 BALBOA ST | 1 BALBOA ST | - | 02ND AVE | 02ND AVE |
| 131696 | N/A | Point | - | - | - | - | S236292 | TARAVAL ST: 20TH AVE | - | F | F | - | F | 23195000 | 23195000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 20TH AVE | 73464 | 73464 | 37.74300263 | -122.4767646 | 20TH AVE \ TARAVAL ST | TARAVAL ST \ 20TH AVE | 1722994737000 | middleware_editor | FG 300 UR DELINEATOR (W) | 20TH AVE intersection | - | @X-WALK (6' TO CURB) 8' W (4' TO CURB) | - | - | - | - | - | 173355 | 1500478440000 | -122.4767646 | 37.74300263 | - | 1500422400000 | - | D4 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1495540380000 | TARAVAL ST | - | - | - | - | - | - |
| 131697 | N/A | Point | 1 | 1 | 2200 - 2299 | RIGHT ARROW | S237420 | 2200-2299 JONES ST | 2200-2299 JONES ST | F | F | - | F | 7594000 | 7594000 | - | - | WEST SIDE | - | - | - | - | GREENWICH ST | GREENWICH ST | 73465 | 73465 | 37.80194585 | -122.41622868 | - | - | 1710539427000 | MTA | TA (SYM) SCHOOL BUS ONLY 8AM-4PM SCH DAYS | GREENWICH ST to LOMBARD ST (2200 - 2299) | - | OPP#2224 | - | - | - | - | - | 173356 | 1409702400000 | -122.41622868 | 37.80194585 | - | 1500595200000 | - | D3 | - | OTHER REGULATORY | REG | R38(SF)4.0002 | 14X21 | SUP1 | 2IN IRON POST | IS | 1499852880000 | JONES ST | 2200 - 2299 JONES ST | 2200 - 2299 JONES ST | 2200 JONES ST | - | LOMBARD ST | LOMBARD ST |
| 131698 | N/A | Point | 1 | 1 | 2200 - 2299 | DOWN ARROW | S237422 | 2200-2299 JONES ST | 2200-2299 JONES ST | F | F | - | F | 7594000 | 7594000 | - | - | WEST SIDE | - | - | - | - | GREENWICH ST | GREENWICH ST | 73466 | 73466 | 37.80194585 | -122.41622868 | - | - | 1710539427000 | MTA | TA (SYM) SCHOOL BUS ONLY 8AM-4PM SCH DAYS | GREENWICH ST to LOMBARD ST (2200 - 2299) | - | OPP#2228 | - | - | - | - | - | 173357 | 1408924800000 | -122.41622868 | 37.80194585 | - | 1500595200000 | - | D3 | - | OTHER REGULATORY | REG | R38(SF)4.0002 | 14X21 | SUP1 | 2IN IRON POST | IS | 1499853540000 | JONES ST | 2200 - 2299 JONES ST | 2200 - 2299 JONES ST | 2200 JONES ST | - | LOMBARD ST | LOMBARD ST |
| 131699 | N/A | Point | 1 | 1 | 2200 - 2299 | DOWN ARROW | S237423 | 2200-2299 JONES ST | 2200-2299 JONES ST | F | F | - | F | 7594000 | 7594000 | - | - | WEST SIDE | - | - | - | - | GREENWICH ST | GREENWICH ST | 73467 | 73467 | 37.80194585 | -122.41622868 | - | - | 1710539427000 | MTA | TA (SYM) SCHOOL BUS ONLY 8AM-4PM SCH DAYS | GREENWICH ST to LOMBARD ST (2200 - 2299) | - | OPP#2256 | - | - | - | - | - | 173358 | 1408924800000 | -122.41622868 | 37.80194585 | - | 1500595200000 | - | D3 | - | OTHER REGULATORY | REG | R38(SF)4.0002 | 14X21 | SUP1 | 2IN IRON POST | IS | 1499853840000 | JONES ST | 2200 - 2299 JONES ST | 2200 - 2299 JONES ST | 2200 JONES ST | - | LOMBARD ST | LOMBARD ST |
| 131700 | N/A | Point | 1 | 1 | 2200 - 2299 | LEFT ARROW | S237424 | 2200-2299 JONES ST | 2200-2299 JONES ST | F | F | - | F | 7594000 | 7594000 | - | - | WEST SIDE | - | - | - | - | GREENWICH ST | GREENWICH ST | 73468 | 73468 | 37.80194585 | -122.41622868 | - | - | 1710539427000 | MTA | TA (SYM) SCHOOL BUS ONLY 8AM-4PM SCH DAYS | GREENWICH ST to LOMBARD ST (2200 - 2299) | - | 6FT SOUTH OF LOMNBARD | - | - | - | - | - | 173359 | 1408924800000 | -122.41622868 | 37.80194585 | - | 1500940800000 | - | D3 | - | OTHER REGULATORY | REG | R38(SF)4.0002 | 14X21 | SUP1 | 2IN IRON POST | IS | 1499854020000 | JONES ST | 2200 - 2299 JONES ST | 2200 - 2299 JONES ST | 2200 JONES ST | - | LOMBARD ST | LOMBARD 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