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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17551 | N/A | Point | 1 | 1 | 3800 - 3899 | - | S247271 | 3800-3899 JUDAH ST | 3800-3899 JUDAH ST | F | F | - | F | 7680000 | 7680000 | - | - | SOUTH SIDE | - | - | - | - | 43RD AVE | 43RD AVE | 81266 | 81266 | 37.76054284 | -122.50324923 | - | - | 1710539427000 | MTA | NPRK 7AM-8AM TUE FRI STCL | 43RD AVE to 44TH AVE (3800 - 3899) | - | WPL 3829 | - | - | - | - | - | 34627 | 1319760000000 | -122.50324923 | 37.76054284 | - | 1534377600000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0219 | 18X18 | SUP2 | 2IN IRON POST | IS | 1532520060000 | JUDAH ST | 3800 - 3899 JUDAH ST | 3800 - 3899 JUDAH ST | 3800 JUDAH ST | - | 44TH AVE | 44TH AVE |
| 17552 | N/A | Point | 1 | 1 | 100 - 149 | - | S246651 | 100-149 CHESTNUT ST | 100-149 CHESTNUT ST | F | F | - | F | 3951000 | 3951000 | - | - | SOUTH SIDE | - | - | - | - | MONTGOMERY ST | MONTGOMERY ST | 81267 | 81267 | 37.80471379 | -122.405564 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM THUR STCL | MONTGOMERY ST to KEARNY ST \ WINTHROP ST (100 - 149) | - | 40 W OF MONTGOMERY | - | - | - | - | - | 34628 | 1531207080000 | -122.405564 | 37.80471379 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0129 | 18X18 | SUP1 | 2IN IRON POST | IS | 1530530880000 | CHESTNUT ST | 100 - 149 CHESTNUT ST | 100 - 149 CHESTNUT ST | 100 CHESTNUT ST | - | KEARNY ST \ WINTHROP ST | KEARNY ST \ WINTHROP ST |
| 17553 | N/A | Point | 1 | 1 | 50 - 122 | - | S246652 | 50-122 BAY ST | 50-122 BAY ST | F | F | - | F | 2772000 | 2772000 | - | - | NORTH SIDE | - | - | - | - | KEARNY ST | KEARNY ST | 81268 | 81268 | 37.80627982 | -122.40831684 | - | - | 1721232331000 | middleware_editor | NPRK 2AM-6AM MON WED FRI STCL | KEARNY ST to MIDWAY ST (50 - 122) | - | 130' W. KEARNY | - | - | - | - | - | 34629 | - | -122.40831684 | 37.80627982 | - | 1682985600000 | - | D3 | - | STREET CLEANING | REG | R30B(CA).0123 | 18X18 | SUP1 | 2IN IRON POST | IS | 1530531420000 | BAY ST | 50 - 122 BAY ST | 50 - 122 BAY ST | 50 BAY ST | - | MIDWAY ST | MIDWAY ST |
| 17554 | N/A | Point | - | - | - | - | S250141 | AUSTIN ST: FRANK NORRIS ST \ P | - | F | F | - | F | 25211000 | 25211000 | - | - | NORTH WEST CORNER | - | - | - | - | AUSTIN ST \ POLK ST | AUSTIN ST \ FRANK NORRIS ST | 85589 | 85589 | 37.78916509 | -122.42040125 | FRANK NORRIS ST \ AUSTIN ST \ POLK ST | POLK ST \ AUSTIN ST \ FRANK NORRIS ST | 1710539427000 | MTA | AUSTIN ST | AUSTIN ST \ FRANK NORRIS ST intersection | - | @ POLK ST | - | - | - | - | - | 34630 | 1545831060000 | -122.42040125 | 37.78916509 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-1.0146 | 36X08 | SUP1 | LIGHT POLE | IS | 1544439360000 | POLK ST | - | - | - | - | - | - |
| 17555 | N/A | Point | 1 | 1 | 100 - 199 | - | S260954 | 100-199 CONNECTICUT ST | 100-199 CONNECTICUT ST | F | F | - | F | 4345000 | 4345000 | - | - | WEST SIDE | - | - | - | - | 17TH ST | 17TH ST | 86685 | 86685 | 37.76443305 | -122.39767505 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM MON STCL | 17TH ST to MARIPOSA ST (100 - 199) | - | NPL 116 | - | - | - | - | - | 34631 | 1475712000000 | -122.39767505 | 37.76443305 | - | 1592352000000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0261 | 18X18 | SUP1 | MUNI POLE | IS | 1580480160000 | CONNECTICUT ST | 100 - 199 CONNECTICUT ST | 100 - 199 CONNECTICUT ST | 100 CONNECTICUT ST | - | MARIPOSA ST | MARIPOSA ST |
| 17556 | N/A | Point | 1 | 1 | 100 - 199 | - | S260955 | 100-199 CONNECTICUT ST | 100-199 CONNECTICUT ST | F | F | - | F | 4345000 | 4345000 | - | - | WEST SIDE | - | - | - | - | 17TH ST | 17TH ST | 86686 | 86686 | 37.76443305 | -122.39767505 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM MON STCL | 17TH ST to MARIPOSA ST (100 - 199) | - | NPL 172 | - | - | - | - | - | 34632 | 1475712000000 | -122.39767505 | 37.76443305 | - | 1606780800000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0261 | 18X18 | SUP1 | MUNI POLE | IS | 1580480280000 | CONNECTICUT ST | 100 - 199 CONNECTICUT ST | 100 - 199 CONNECTICUT ST | 100 CONNECTICUT ST | - | MARIPOSA ST | MARIPOSA ST |
| 17557 | N/A | Point | 1 | 1 | 100 - 199 | - | S260956 | 100-199 CONNECTICUT ST | 100-199 CONNECTICUT ST | F | F | - | F | 4345000 | 4345000 | - | - | WEST SIDE | - | - | - | - | 17TH ST | 17TH ST | 86687 | 86687 | 37.76443305 | -122.39767505 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-10PM MON-SAT EXC "X" PERMITS | 17TH ST to MARIPOSA ST (100 - 199) | - | NPL 116 | - | - | - | - | - | 34633 | 1001289600000 | -122.39767505 | 37.76443305 | - | 1592352000000 | - | D10 | - | PARKING:RPP | REG | R32C(CA).0243 | 18X21 | SUP1 | MUNI POLE | IS | 1580480400000 | CONNECTICUT ST | 100 - 199 CONNECTICUT ST | 100 - 199 CONNECTICUT ST | 100 CONNECTICUT ST | - | MARIPOSA ST | MARIPOSA ST |
| 17558 | N/A | Point | 1 | 1 | 600 - 699 | LEFT ARROW | S258657 | 600-699 KANSAS ST | 600-699 KANSAS ST | F | F | - | F | 7730000 | 7730000 | - | - | EAST SIDE | - | - | - | - | 18TH ST | 18TH ST | 86688 | 86688 | 37.76153162 | -122.4032314 | - | - | 1752009580000 | middleware_editor | PARK AT 90 DEGREES | 18TH ST to 19TH ST (600 - 699) | - | 27' N OF 19TH ST | - | - | - | - | - | 34634 | - | -122.4032314 | 37.76153162 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0372 | 18X18 | SUP1 | 2IN IRON POST | IS | 1571994600000 | KANSAS ST | 600 - 699 KANSAS ST | 600 - 699 KANSAS ST | 600 KANSAS ST | - | 19TH ST | 19TH ST |
| 17559 | N/A | Point | 1 | 1 | 1400 - 1599 | - | S259014 | 1400-1599 EGBERT AVE | 1400-1599 EGBERT AVE | F | F | - | F | 5116000 | 5116000 | - | - | SOUTH SIDE | - | - | - | - | JENNINGS ST | JENNINGS ST | 86689 | 86689 | 37.72331526 | -122.39376792 | - | - | 1710539427000 | MTA | BIKE RACK | JENNINGS ST to 03RD ST (1400 - 1599) | 121809 | 22' W OF EPL 1439 | - | - | - | - | - | 34635 | 1573569600000 | -122.39376792 | 37.72331526 | - | - | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1573041480000 | EGBERT AVE | 1400 - 1599 EGBERT AVE | 1400 - 1599 EGBERT AVE | 1400 EGBERT AVE | - | 03RD ST | 03RD ST |
| 17560 | N/A | Point | 1 | 1 | 1400 - 1599 | - | S259015 | 1400-1599 EGBERT AVE | 1400-1599 EGBERT AVE | F | F | - | F | 5116000 | 5116000 | - | - | SOUTH SIDE | - | - | - | - | JENNINGS ST | JENNINGS ST | 86690 | 86690 | 37.72331526 | -122.39376792 | - | - | 1710539427000 | MTA | BIKE RACK | JENNINGS ST to 03RD ST (1400 - 1599) | 121809 | 29' W OF EPL 1439 | - | - | - | - | - | 34636 | 1573569600000 | -122.39376792 | 37.72331526 | - | - | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1573041540000 | EGBERT AVE | 1400 - 1599 EGBERT AVE | 1400 - 1599 EGBERT AVE | 1400 EGBERT AVE | - | 03RD ST | 03RD ST |
| 17561 | N/A | Point | - | - | - | - | S259020 | LAWTON ST: GREAT HWY \ LA PLAY | - | F | F | - | F | 27944000 | 27944000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GREAT HWY \ LAWTON ST | GREAT HWY \ LA PLAYA | 86691 | 86691 | 37.75655123 | -122.50890254 | LA PLAYA \ GREAT HWY \ LAWTON ST | LAWTON ST \ GREAT HWY \ LA PLAYA | 1734462131000 | middleware_editor | STOP | GREAT HWY \ LA PLAYA intersection | - | - | - | - | - | - | - | 34637 | 1417564800000 | -122.50890254 | 37.75655123 | - | 1573516800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1573051980000 | LAWTON ST | - | - | - | - | - | - |
| 17562 | N/A | Point | - | - | - | - | S259021 | LAWTON ST: GREAT HWY \ LA PLAY | - | F | F | - | F | 27944000 | 27944000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GREAT HWY \ LAWTON ST | GREAT HWY \ LA PLAYA | 86692 | 86692 | 37.75655123 | -122.50890254 | LA PLAYA \ GREAT HWY \ LAWTON ST | LAWTON ST \ GREAT HWY \ LA PLAYA | 1734462128000 | middleware_editor | ALL WAY | GREAT HWY \ LA PLAYA intersection | - | - | - | - | - | - | - | 34638 | 1417564800000 | -122.50890254 | 37.75655123 | - | 1573516800000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1573052160000 | LAWTON ST | - | - | - | - | - | - |
| 17563 | N/A | Point | - | - | - | - | S259078 | VALLEJO ST: POWELL ST | - | F | F | - | F | 25411000 | 25411000 | - | - | NORTH WEST CORNER | - | - | - | - | VALLEJO ST | VALLEJO ST | 86693 | 86693 | 37.7983727 | -122.41045616 | POWELL ST \ VALLEJO ST | POWELL ST \ VALLEJO ST | 1710539427000 | MTA | VALLEJO ST | VALLEJO ST intersection | - | - | - | - | - | - | - | 34639 | 1573052460000 | -122.41045616 | 37.7983727 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-1.1777 | 36X08 | SUP1 | LIGHT POLE | IS | 1573137600000 | POWELL ST | - | - | - | - | - | - |
| 17564 | N/A | Point | - | - | - | - | S259079 | VALLEJO ST: POWELL ST | - | F | F | - | F | 25411000 | 25411000 | - | - | NORTH WEST CORNER | - | - | - | - | VALLEJO ST | VALLEJO ST | 86694 | 86694 | 37.7983727 | -122.41045616 | POWELL ST \ VALLEJO ST | POWELL ST \ VALLEJO ST | 1710539427000 | MTA | POWELL ST | VALLEJO ST intersection | - | - | - | - | - | - | - | 34640 | 1573052100000 | -122.41045616 | 37.7983727 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-1.1416 | 36X08 | SUP1 | LIGHT POLE | IS | 1573137660000 | POWELL ST | - | - | - | - | - | - |
| 17565 | N/A | Point | 1 | 1 | 200 - 232 | - | S259369 | 200-232 5TH ST | 200-232 05TH ST | F | F | - | F | 296000 | 296000 | - | - | EAST SIDE | - | - | - | - | HOWARD ST | HOWARD ST | 86695 | 86695 | 37.78128805 | -122.40466852 | - | - | 1710539427000 | MTA | TANSAT | HOWARD ST to TEHAMA ST (200 - 232) | - | 10FT NORTH OF TEHAMA | - | - | - | - | - | 34641 | 1258588800000 | -122.40466852 | 37.78128805 | - | 1574294400000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1574256420000 | 05TH ST | 200 - 232 5TH ST | 200 - 232 05TH ST | 200 5TH ST | - | TEHAMA ST | TEHAMA ST |
| 17566 | N/A | Point | 1 | 1 | 500 - 599 | - | S259419 | 500-599 10TH AVE | 500-599 10TH AVE | F | F | - | F | 466000 | 466000 | - | - | WEST SIDE | - | - | - | - | ANZA ST | ANZA ST | 86696 | 86696 | 37.77796819 | -122.46835944 | - | - | 1742340206000 | middleware_editor | TA (SYM) NO STOPPING EXC PERMITTED CSV-GETAROUND | ANZA ST to BALBOA ST (500 - 599) | - | 14' N OF BALBOA | - | - | - | - | - | 34642 | 1580926200000 | -122.46835944 | 37.77796819 | - | - | 1742321880000 | D1 | - | OTHER REGULATORY | REG | R37(SF).0293 | 05X12 | SUP2 | 2IN IRON POST | RETD | 1574423520000 | 10TH AVE | 500 - 599 10TH AVE | 500 - 599 10TH AVE | 500 10TH AVE | - | BALBOA ST | BALBOA ST |
| 17567 | N/A | Point | 1 | 1 | 1 - 4 | - | S259426 | 3-29 MASONIC AVE | 1-4 MASONIC AVE | F | F | - | F | 8842000 | 8842000 | - | - | EAST SIDE | - | - | - | - | EUCLID AVE | EUCLID AVE | 86697 | 86697 | 37.7827917476247 | -122.44706181051 | - | - | 1746192165000 | middleware_editor | TA (SYM) NO STOPPING EXC PERMITTED CSV-GETAROUND | EUCLID AVE to GEARY BLVD (1 - 4) | - | 14' NORTH OF GEARY BLVD | - | - | - | - | - | 34643 | 1582926540000 | -122.44732943 | 37.78373699 | - | - | 1746136080000 | D2 | - | OTHER REGULATORY | REG | R37(SF).0293 | 05X12 | SUP1 | LIGHT POLE | RETD | 1574428500000 | MASONIC AVE | 1 - 4 MASONIC AVE | 1 - 4 MASONIC AVE | 1 MASONIC AVE | - | GEARY BLVD | GEARY BLVD |
| 17568 | N/A | Point | 1 | 1 | 700 - 799 | RIGHT ARROW | S258513 | 700-799 KIRKWOOD AVE | 700-799 KIRKWOOD AVE | F | F | - | F | 7891000 | 7891000 | - | - | SOUTH SIDE | - | - | - | - | EARL ST | EARL ST | 86698 | 86698 | 37.72914912 | -122.374043 | - | - | 1725659935000 | middleware_editor | TA (SYM) PLO 7AM-9AM/4PM-6PM MON-FRI (5 MIN) | EARL ST to DORMITORY RD \ KISKA RD (700 - 799) | - | 2' WEST OF #729 DRIVEWAY | - | - | - | - | - | 34644 | 1571914440000 | -122.374043 | 37.72914912 | - | - | - | D10 | - | OTHER REGULATORY | REG | R38(SF)1.0137 | 14X21 | SUP1 | 2IN IRON POST | IS | 1571669760000 | KIRKWOOD AVE | 700 - 799 KIRKWOOD AVE | 700 - 799 KIRKWOOD AVE | 700 KIRKWOOD AVE | - | DORMITORY RD \ KISKA RD | DORMITORY RD \ KISKA RD |
| 17569 | N/A | Point | 1 | 1 | 700 - 799 | - | S258514 | 700-799 KIRKWOOD AVE | 700-799 KIRKWOOD AVE | F | F | - | F | 7891000 | 7891000 | - | - | SOUTH SIDE | - | - | - | - | EARL ST | EARL ST | 86699 | 86699 | 37.72914912 | -122.374043 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7AM-9AM/4PM-6PM MON-FRI (5 MIN) | EARL ST to DORMITORY RD \ KISKA RD (700 - 799) | - | 46' WEST OF #729 DRIVEWAY | - | - | - | - | - | 34645 | 1571914500000 | -122.374043 | 37.72914912 | - | - | - | D10 | - | OTHER REGULATORY | REG | R38(SF)1.0137 | 14X21 | SUP1 | 2IN IRON POST | IS | 1571669820000 | KIRKWOOD AVE | 700 - 799 KIRKWOOD AVE | 700 - 799 KIRKWOOD AVE | 700 KIRKWOOD AVE | - | DORMITORY RD \ KISKA RD | DORMITORY RD \ KISKA RD |
| 17570 | N/A | Point | 1 | 1 | 700 - 799 | LEFT ARROW | S258515 | 700-799 KIRKWOOD AVE | 700-799 KIRKWOOD AVE | F | F | - | F | 7891000 | 7891000 | - | - | SOUTH SIDE | - | - | - | - | EARL ST | EARL ST | 86700 | 86700 | 37.72914912 | -122.374043 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7AM-9AM/4PM-6PM MON-FRI (5 MIN) | EARL ST to DORMITORY RD \ KISKA RD (700 - 799) | - | 90'' WEST OF #729 DRIVEWAY | - | - | - | - | - | 34646 | 1571914560000 | -122.374043 | 37.72914912 | - | - | - | D10 | - | OTHER REGULATORY | REG | R38(SF)1.0137 | 14X21 | SUP1 | 2IN IRON POST | IS | 1571669880000 | KIRKWOOD AVE | 700 - 799 KIRKWOOD AVE | 700 - 799 KIRKWOOD AVE | 700 KIRKWOOD AVE | - | DORMITORY RD \ KISKA RD | DORMITORY RD \ KISKA RD |
| 17571 | N/A | Point | - | - | - | - | S103223 | ELLIS ST: LAGUNA ST | - | F | F | - | F | 26512000 | 26512000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 3096 | 3096 | 37.78298605 | -122.42758433 | LAGUNA ST \ ELLIS ST | LAGUNA ST \ ELLIS ST | 1710960732000 | jsanfel | STOP | ELLIS ST intersection | - | 0 / 0 | - | - | - | - | - | 34647 | -286934400000 | -122.42758433 | 37.78298605 | - | 689299200000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568540000 | LAGUNA ST | - | - | - | - | - | - |
| 17572 | N/A | Point | - | - | - | - | S103224 | STEINER ST: EDDY ST | - | F | F | - | F | 26049000 | 26049000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | STEINER ST | EDDY ST | 3097 | 3097 | 37.781296169 | -122.434062995 | EDDY ST \ STEINER ST | STEINER ST \ EDDY ST | 1755816178000 | middleware_editor | STOP | EDDY ST intersection | - | 0 / 00 | - | - | - | - | - | 34648 | -286905600000 | -122.43397316 | 37.7812188 | - | - | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568540000 | STEINER ST | - | - | - | - | - | - |
| 17573 | N/A | Point | - | - | - | - | S103225 | STEINER ST: EDDY ST | - | F | F | - | F | 26049000 | 26049000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | STEINER ST | EDDY ST | 3098 | 3098 | 37.781142146 | -122.43389364 | EDDY ST \ STEINER ST | STEINER ST \ EDDY ST | 1754318473000 | mmadsen | STOP | EDDY ST intersection | - | 0 / 00 | - | - | - | - | - | 34649 | -286905600000 | -122.43397316 | 37.7812188 | - | 636278400000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568540000 | STEINER ST | - | - | - | - | - | - |
| 17574 | N/A | Point | - | - | - | - | S103227 | FARALLONES ST: CAPITOL AVE | - | F | F | - | F | 22473000 | 22473000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FARALLONES ST | CAPITOL AVE | 3099 | 3099 | 37.7140553 | -122.45903539 | CAPITOL AVE \ FARALLONES ST | FARALLONES ST \ CAPITOL AVE | 1720487572000 | middleware_editor | ALL WAY | CAPITOL AVE intersection | - | 0 / 0 | - | - | - | - | - | 34650 | -286934400000 | -122.45903539 | 37.7140553 | - | 1494201600000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373568540000 | FARALLONES ST | - | - | - | - | - | - |
| 17575 | N/A | Point | - | - | - | - | S103231 | MERCHANT ST: KEARNY ST | - | F | F | - | F | 24773000 | 24773000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MERCHANT ST | MERCHANT ST | 3100 | 3100 | 37.79485953 | -122.40487561 | KEARNY ST \ MERCHANT ST | KEARNY ST \ MERCHANT ST | 1710539427000 | MTA | ONE WAY (RA) | MERCHANT ST intersection | - | W LINE / 0 | - | - | - | - | - | 34651 | -284860800000 | -122.40487561 | 37.79485953 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373568540000 | KEARNY ST | - | - | - | - | - | - |
| 17576 | N/A | Point | - | - | - | - | S102608 | 9TH ST: RINGOLD ST | - | F | F | - | F | 24231000 | 24231000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 09TH ST | RINGOLD ST | 3104 | 3104 | 37.77333263 | -122.41107136 | RINGOLD ST \ 09TH ST | 09TH ST \ RINGOLD ST | 1712884877000 | middleware_editor | ONE WAY (LA) | RINGOLD ST intersection | - | - | - | - | - | - | - | 34652 | -387158400000 | -122.41107136 | 37.77333263 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP1 | 2IN IRON POST | IS | 1373568360000 | 09TH ST | - | - | - | - | - | - |
| 17577 | N/A | Point | - | - | - | - | S102609 | 9TH ST: MCLEA CT | - | F | F | - | F | 24203000 | 24203000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 9TH ST | 09TH ST | 3105 | 3105 | 37.77173211 | -122.40908315 | MCLEA CT \ 9TH ST | MCLEA CT \ 09TH ST | 1753726916000 | middleware_editor | ONE WAY (RA) | 09TH ST intersection | - | 0 / 0 | - | - | - | - | - | 34653 | -387133200000 | -122.40908315 | 37.77173211 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568360000 | MCLEA CT | - | - | - | - | - | - |
| 17578 | N/A | Point | - | - | - | - | S102612 | FOLSOM ST: BEALE ST | - | F | F | - | F | 24496000 | 24496000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | BEALE ST | 3106 | 3106 | 37.78868666 | -122.39272283 | BEALE ST \ FOLSOM ST | FOLSOM ST \ BEALE ST | 1710539427000 | MTA | STOP | BEALE ST intersection | - | 0 / 00 | - | - | - | - | - | 34654 | -387072000000 | -122.39272283 | 37.78868666 | - | - | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568360000 | FOLSOM ST | - | - | - | - | - | - |
| 17579 | N/A | Point | - | - | - | - | S102613 | FOLSOM ST: BEALE ST | - | F | F | - | F | 24496000 | 24496000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | BEALE ST | 3107 | 3107 | 37.78868666 | -122.39272283 | BEALE ST \ FOLSOM ST | FOLSOM ST \ BEALE ST | 1710539427000 | MTA | STOP | BEALE ST intersection | - | 0 / 00 | - | - | - | - | - | 34655 | -387072000000 | -122.39272283 | 37.78868666 | - | - | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568360000 | FOLSOM ST | - | - | - | - | - | - |
| 17580 | N/A | Point | - | - | - | - | S102614 | FOLSOM ST: FREMONT ST | - | F | F | - | F | 24498000 | 24498000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | FREMONT ST | 3108 | 3108 | 37.78799631 | -122.39359716 | FREMONT ST \ FOLSOM ST | FOLSOM ST \ FREMONT ST | 1710539427000 | MTA | STOP | FREMONT ST intersection | - | 0 / 00 | - | - | - | - | - | 34656 | -387072000000 | -122.39359716 | 37.78799631 | - | - | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568360000 | FOLSOM ST | - | - | - | - | - | - |
| 17581 | N/A | Point | - | - | - | - | S106933 | IRVING ST: 43RD AVE | - | F | F | - | F | 27802000 | 27802000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | IRVING ST | IRVING ST | 3161 | 3161 | 37.76242722 | -122.50284388 | 43RD AVE \ IRVING ST | 43RD AVE \ IRVING ST | 1737572153000 | middleware_editor | STOP | IRVING ST intersection | - | 0 / 0 | - | - | - | - | - | 34657 | 180662400000 | -122.50284388 | 37.76242722 | - | 1511913600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569680000 | 43RD AVE | - | - | - | - | - | - |
| 17582 | N/A | Point | - | - | - | - | S106934 | 39TH AVE: CABRILLO ST | - | F | F | - | F | 27867000 | 27867000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 39TH AVE | CABRILLO ST | 3162 | 3162 | 37.77375089 | -122.49931887 | CABRILLO ST \ 39TH AVE | 39TH AVE \ CABRILLO ST | 1710539427000 | MTA | STOP | CABRILLO ST intersection | - | 0 / 0 | - | - | - | - | - | 34658 | 180662400000 | -122.49931887 | 37.77375089 | - | 1707312780000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569680000 | 39TH AVE | - | - | - | - | - | - |
| 17583 | N/A | Point | - | - | - | - | S107741 | JOOST AVE: FOERSTER ST | - | F | F | - | F | 22233000 | 22233000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | JOOST AVE | FOERSTER ST | 3224 | 3224 | 37.73232632 | -122.44886866 | FOERSTER ST \ JOOST AVE | JOOST AVE \ FOERSTER ST | 1710539427000 | MTA | DO NOT ENTER | FOERSTER ST intersection | - | - | - | - | - | - | - | 34659 | 250214400000 | -122.44886866 | 37.73232632 | - | - | - | D7 | - | OTHER REGULATORY | REG | R5-1.0002 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373569980000 | JOOST AVE | - | - | - | - | - | - |
| 17584 | N/A | Point | 1 | 1 | 1646 - 1651 | - | S102438 | 1646-1651 GRANT AVE | 1646-1651 GRANT AVE | F | F | - | F | 25376000 | 6408000 | - | - | WEST SIDE, WESTBOUND TRAFFIC | - | - | - | - | GERKE ALY | GERKE ALY | 5036 | 5036 | 37.8022100601756 | -122.407946130315 | GRANT AVE \ GERKE ALY | - | 1754330653000 | middleware_editor | ONE WAY (RA) | GERKE ALY to JACK MICHELINE ALY (1646 - 1651) | - | W LINE / 0 | - | - | - | - | - | 34660 | -388429200000 | -122.40789718 | 37.80221059 | - | 1754325900000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | 3IN IRON POST | IS | 1373568300000 | GRANT AVE | - | 1646 - 1651 GRANT AVE | 1646 GRANT AVE | - | - | JACK MICHELINE ALY |
| 17585 | N/A | Point | - | - | - | - | S102439 | GRANT AVE: GREENWICH ST | - | F | F | - | F | 25379000 | 25379000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GREENWICH ST | GREENWICH ST | 5037 | 5037 | 37.80250477 | -122.40795586 | GRANT AVE \ GREENWICH ST | GRANT AVE \ GREENWICH ST | 1754331018000 | middleware_editor | ONE WAY (RA) | GREENWICH ST intersection | - | 0 / 0 | - | - | - | - | - | 34661 | -388429200000 | -122.40795586 | 37.80250477 | - | 1754327340000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373568300000 | GRANT AVE | - | - | - | - | - | - |
| 17586 | N/A | Point | - | - | - | - | S102440 | GRANT AVE: LOMBARD ST | - | F | F | - | F | 25382000 | 25382000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LOMBARD ST | GRANT AVE | 5038 | 5038 | 37.80343258 | -122.40814597 | GRANT AVE \ LOMBARD ST | LOMBARD ST \ GRANT AVE | 1754337920000 | middleware_editor | ONE WAY (RA) | GRANT AVE intersection | - | 0 / 0 | - | - | - | - | - | 34662 | -388429200000 | -122.40814597 | 37.80343258 | - | 1754331300000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373568300000 | LOMBARD ST | - | - | - | - | - | - |
| 17587 | N/A | Point | - | - | - | - | S102441 | GRANT AVE: CHESTNUT ST | - | F | F | - | F | 25400000 | 25400000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GRANT AVE | CHESTNUT ST | 5039 | 5039 | 37.80436708 | -122.40833228 | CHESTNUT ST \ GRANT AVE | GRANT AVE \ CHESTNUT ST | 1754338455000 | middleware_editor | ONE WAY (RA) | CHESTNUT ST intersection | - | - | - | - | - | - | - | 34663 | -388429200000 | -122.40833228 | 37.80436708 | - | 1754334780000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373568300000 | GRANT AVE | - | - | - | - | - | - |
| 17588 | N/A | Point | 1 | 1 | 1 - 99 | - | S102442 | 1-99 WASHINGTON ST | 1-99 WASHINGTON ST | F | F | - | F | 13403000 | 13403000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | THE EMBARCADERO | THE EMBARCADERO | 5040 | 5040 | 37.796507 | -122.39617809 | - | - | 1710539427000 | MTA | STOP | THE EMBARCADERO to DRUMM ST (1 - 99) | - | 2 LINE / 0 | - | - | - | - | - | 34664 | -388368000000 | -122.39617809 | 37.796507 | - | - | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568300000 | WASHINGTON ST | 1 - 99 WASHINGTON ST | 1 - 99 WASHINGTON ST | 1 WASHINGTON ST | - | DRUMM ST | DRUMM ST |
| 17589 | N/A | Point | - | - | - | - | S102443 | WASHINGTON ST: THE EMBARCADERO | - | F | F | - | F | - | 24572000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | - | WASHINGTON ST | 5041 | 5041 | 37.7966829 | -122.39540527 | - | THE EMBARCADERO \ WASHINGTON ST | 1747253651000 | middleware_editor | STOP | WASHINGTON ST intersection | - | 00 / 0 | - | - | - | - | - | 34665 | -388342800000 | -122.39540527 | 37.7966829 | - | - | 1747253580000 | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | RETD | 1373568300000 | THE EMBARCADERO | - | - | - | - | - | - |
| 17590 | N/A | Point | - | - | - | - | S102444 | BATTERY ST: BROADWAY | - | F | F | - | F | 30765000 | 30765000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BROADWAY | BROADWAY | 5042 | 5042 | 37.79858005 | -122.40105129 | BATTERY ST \ BROADWAY | BATTERY ST \ BROADWAY | 1741974631000 | middleware_editor | STOP | BROADWAY intersection | - | 0 / 0 | - | - | - | - | - | 34666 | -388342800000 | -122.40105129 | 37.79858005 | - | - | 1741974600000 | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | RETD | 1373568300000 | BATTERY ST | - | - | - | - | - | - |
| 17591 | N/A | Point | - | - | - | - | S102447 | CASTLE ST: GREEN ST | - | F | F | - | F | 24853000 | 24853000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GREEN ST | CASTLE ST | 5043 | 5043 | 37.80000082 | -122.40505102 | CASTLE ST \ GREEN ST | GREEN ST \ CASTLE ST | 1710539427000 | MTA | DO NOT ENTER | CASTLE ST intersection | - | 0 / 0 | - | - | - | - | - | 34667 | -388368000000 | -122.40505102 | 37.80000082 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1.0002 | 24X24 | SUP1 | UNKNOWN | IS | 1373568300000 | GREEN ST | - | - | - | - | - | - |
| 17592 | N/A | Point | - | - | - | - | S102448 | 1ST ST: BUSH ST \ MARKET ST | - | F | F | - | F | 30731000 | 30731000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 1ST ST \ BUSH ST | 01ST ST \ BUSH ST | 5044 | 5044 | 37.79101665 | -122.3991486 | MARKET ST \ 1ST ST \ BUSH ST | MARKET ST \ 01ST ST \ BUSH ST | 1710539427000 | MTA | ONE WAY (LA) | 01ST ST \ BUSH ST intersection | - | 0 / 0 | - | - | - | - | - | 34668 | -388368000000 | -122.3991486 | 37.79101665 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373568300000 | MARKET ST | - | - | - | - | - | - |
| 17593 | N/A | Point | - | - | - | - | S102449 | CASTLE ST: GREEN ST | - | F | F | - | F | 24853000 | 24853000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GREEN ST | CASTLE ST | 5045 | 5045 | 37.80000082 | -122.40505102 | CASTLE ST \ GREEN ST | GREEN ST \ CASTLE ST | 1710539427000 | MTA | ONE WAY (LA) | CASTLE ST intersection | - | 0 / 0 | - | - | - | - | - | 34669 | -388368000000 | -122.40505102 | 37.80000082 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373568300000 | GREEN ST | - | - | - | - | - | - |
| 17594 | N/A | Point | - | - | - | - | S102454 | ECKER ST: STEVENSON ST | - | F | F | - | F | 24607000 | 24607000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ECKER ST | STEVENSON ST | 5048 | 5048 | 37.78997051 | -122.39935006 | STEVENSON ST \ ECKER ST | ECKER ST \ STEVENSON ST | 1710539427000 | MTA | ONE WAY (RA) | STEVENSON ST intersection | - | 0 / 0 | - | - | - | - | - | 34670 | -388368000000 | -122.39935006 | 37.78997051 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568300000 | ECKER ST | - | - | - | - | - | - |
| 17595 | N/A | Point | - | - | - | - | S102455 | CASTLE ST: GREEN ST | - | F | F | - | F | 24853000 | 24853000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GREEN ST | CASTLE ST | 5049 | 5049 | 37.80000082 | -122.40505102 | CASTLE ST \ GREEN ST | GREEN ST \ CASTLE ST | 1710539427000 | MTA | ONE WAY (RA) | CASTLE ST intersection | - | 0 / 0 | - | - | - | - | - | 34671 | -388368000000 | -122.40505102 | 37.80000082 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568300000 | GREEN ST | - | - | - | - | - | - |
| 17596 | N/A | Point | - | - | - | - | S102459 | DE HARO ST: 16TH ST | - | F | F | - | F | 23754000 | 23754000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 16TH ST | DE HARO ST | 5051 | 5051 | 37.76613252 | -122.40172052 | DE HARO ST \ 16TH ST | 16TH ST \ DE HARO ST | 1710539427000 | MTA | STOP | DE HARO ST intersection | - | 0 / 0 | - | - | - | - | - | 34672 | -388281600000 | -122.40172052 | 37.76613252 | - | 935539200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568300000 | 16TH ST | - | - | - | - | - | - |
| 17597 | N/A | Point | - | - | - | - | S101504 | UNION ST: PIERCE ST | - | F | F | - | F | 26681000 | 26681000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | UNION ST | UNION ST | 5052 | 5052 | 37.79667044 | -122.4387794 | PIERCE ST \ UNION ST | PIERCE ST \ UNION ST | 1710539427000 | MTA | STOP | UNION ST intersection | - | 00 / 00 | - | - | - | - | - | 34673 | -396316800000 | -122.4387794 | 37.79667044 | - | 1143763200000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566800000 | PIERCE ST | - | - | - | - | - | - |
| 17598 | N/A | Point | - | - | - | - | S101505 | UNION ST: PIERCE ST | - | F | F | - | F | 26681000 | 26681000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | UNION ST | UNION ST | 5053 | 5053 | 37.79667044 | -122.4387794 | PIERCE ST \ UNION ST | PIERCE ST \ UNION ST | 1710539427000 | MTA | STOP | UNION ST intersection | - | 00 / 00 | - | - | - | - | - | 34674 | -396316800000 | -122.4387794 | 37.79667044 | - | 1143763200000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566800000 | PIERCE ST | - | - | - | - | - | - |
| 17599 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S104408 | 1300-1399 LA PLAYA ST | 1300-1399 LA PLAYA | F | F | - | F | 7923000 | 7923000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | IRVING ST | IRVING ST | 5055 | 5055 | 37.76121263 | -122.50920515 | - | - | 1750874345000 | middleware_editor | STOP | IRVING ST to JUDAH ST (1300 - 1399) | - | 0 / 0 | - | - | - | - | - | 34675 | -5068800000 | -122.50920515 | 37.76121263 | - | 1495782000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | RETD | 1373568900000 | LA PLAYA | 1300 - 1399 LA PLAYA | 1300 - 1399 LA PLAYA | 1300 LA PLAYA | - | JUDAH ST | JUDAH ST |
| 17600 | N/A | Point | - | - | - | - | S104409 | CORNWALL ST: 2ND AVE | - | F | F | - | F | 27565000 | 27565000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CORNWALL ST | 02ND AVE | 5056 | 5056 | 37.78500628 | -122.4602696 | 2ND AVE \ CORNWALL ST | CORNWALL ST \ 02ND AVE | 1738023787000 | middleware_editor | STOP | 02ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 34676 | -4924800000 | -122.4602696 | 37.78500628 | - | 1737985080000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568900000 | CORNWALL ST | - | - | - | - | - | - |
| 17601 | N/A | Point | - | - | - | - | S104696 | 23RD ST: CASTRO ST | - | F | F | - | F | 25745000 | 25745000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CASTRO ST | CASTRO ST | 5134 | 5134 | 37.75289128 | -122.43423976 | 23RD ST \ CASTRO ST | 23RD ST \ CASTRO ST | 1741805113000 | middleware_editor | STOP | CASTRO ST intersection | - | 0 / 0 | - | - | - | - | - | 34677 | 24649200000 | -122.43423976 | 37.75289128 | - | 1581494400000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569020000 | 23RD ST | - | - | - | - | - | - |
| 17602 | N/A | Point | - | - | - | - | S109176 | POWELL ST: CALIFORNIA ST | - | F | F | - | F | 25002000 | 25002000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 7315 | 7315 | 37.79204252 | -122.40917136 | POWELL ST \ CALIFORNIA ST | POWELL ST \ CALIFORNIA ST | 1744121954000 | middleware_editor | NO LEFT TURN (SYM) | CALIFORNIA ST intersection | - | 0 / CONSTRUCTION COMPLETE/ ALSO N/W..... | - | - | - | - | - | 34678 | 411811200000 | -122.40917136 | 37.79204252 | - | 1743100200000 | - | D3 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373570400000 | POWELL ST | - | - | - | - | - | - |
| 17603 | N/A | Point | - | - | - | - | S109177 | CALIFORNIA ST: POWELL ST | - | F | F | - | F | 25002000 | 25002000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 7316 | 7316 | 37.79204252 | -122.40917136 | POWELL ST \ CALIFORNIA ST | POWELL ST \ CALIFORNIA ST | 1729092717000 | middleware_editor | NO LEFT TURN (SYM) | CALIFORNIA ST intersection | - | 0 / CONSTRUCTION COMPLETE/ ALSO S/W..... | - | - | - | - | - | 34679 | - | -122.40917136 | 37.79204252 | - | - | 1729067460000 | D3 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | SIGNAL POLE | RETD | 1373570400000 | POWELL ST | - | - | - | - | - | - |
| 17604 | N/A | Point | - | - | - | - | S109178 | CALIFORNIA ST: POWELL ST | - | F | F | - | F | 25002000 | 25002000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 7317 | 7317 | 37.79204252 | -122.40917136 | POWELL ST \ CALIFORNIA ST | POWELL ST \ CALIFORNIA ST | 1729092781000 | middleware_editor | NO LEFT TURN (SYM) | CALIFORNIA ST intersection | - | 0 / CONSTRUCTION COMPLETE/ ALSO N/E..... | - | - | - | - | - | 34680 | - | -122.40917136 | 37.79204252 | - | - | 1729067520000 | D3 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | SIGNAL POLE | RETD | 1373570400000 | POWELL ST | - | - | - | - | - | - |
| 17605 | N/A | Point | - | - | - | - | S109179 | HYDE ST: BAY ST | - | F | F | - | F | 25577000 | 25577000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BAY ST | BAY ST | 7318 | 7318 | 37.80479031 | -122.42017813 | HYDE ST \ BAY ST | HYDE ST \ BAY ST | 1715006380000 | middleware_editor | DO NOT ENTER | BAY ST intersection | - | 0 / ON WOOD BARRICADE IN STREET | - | - | - | - | - | 34681 | 411782400000 | -122.42017813 | 37.80479031 | - | - | - | D2 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | BARRICADE | IS | 1373570400000 | HYDE ST | - | - | - | - | - | - |
| 17606 | N/A | Point | - | - | - | - | S109182 | JUDAH ST: FUNSTON AVE | - | F | F | - | F | 27168000 | 27168000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FUNSTON AVE | FUNSTON AVE | 7321 | 7321 | 37.76198699 | -122.47046492 | JUDAH ST \ FUNSTON AVE | JUDAH ST \ FUNSTON AVE | 1741188995000 | middleware_editor | STOP | FUNSTON AVE intersection | - | 0 / REPAIR | - | - | - | - | - | 34682 | 412156800000 | -122.47046492 | 37.76198699 | - | 1194422400000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373570400000 | JUDAH ST | - | - | - | - | - | - |
| 17607 | N/A | Point | - | - | - | - | S109183 | JUDAH ST: FUNSTON AVE | - | F | F | - | F | 27168000 | 27168000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FUNSTON AVE | FUNSTON AVE | 7322 | 7322 | 37.76198699 | -122.47046492 | JUDAH ST \ FUNSTON AVE | JUDAH ST \ FUNSTON AVE | 1741189000000 | middleware_editor | STOP | FUNSTON AVE intersection | - | - | - | - | - | - | - | 34683 | 412156800000 | -122.47046492 | 37.76198699 | - | 1618556400000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | MUNI POLE | IS | 1373570400000 | JUDAH ST | - | - | - | - | - | - |
| 17608 | N/A | Point | - | - | - | - | S110053 | FOREST VIEW DR: OCEAN AVE | - | F | F | - | F | 23128000 | 23128000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | OCEAN AVE | FOREST VIEW DR | 7323 | 7323 | 37.7323547 | -122.48363495 | FOREST VIEW DR \ OCEAN AVE | OCEAN AVE \ FOREST VIEW DR | 1710539427000 | MTA | STOP | FOREST VIEW DR intersection | - | - | - | - | - | - | - | 34684 | 587174400000 | -122.48363495 | 37.7323547 | - | 1533081600000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570700000 | OCEAN AVE | - | - | - | - | - | - |
| 17609 | N/A | Point | - | - | - | - | S110055 | 29TH AVE: ULLOA ST | - | F | F | - | F | 23258000 | 23258000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 29TH AVE | 29TH AVE | 7324 | 7324 | 37.74071069 | -122.48627949 | ULLOA ST \ 29TH AVE | ULLOA ST \ 29TH AVE | 1726707857000 | middleware_editor | STOP | 29TH AVE intersection | - | - | - | - | - | - | - | 34685 | 587174400000 | -122.48627949 | 37.74071069 | - | 1466035200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570700000 | ULLOA ST | - | - | - | - | - | - |
| 17610 | N/A | Point | - | - | - | - | S110056 | 29TH AVE: ULLOA ST | - | F | F | - | F | 23258000 | 23258000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 29TH AVE | 29TH AVE | 7325 | 7325 | 37.74071069 | -122.48627949 | ULLOA ST \ 29TH AVE | ULLOA ST \ 29TH AVE | 1727814487000 | middleware_editor | STOP | 29TH AVE intersection | - | - | - | - | - | - | - | 34686 | 587174400000 | -122.48627949 | 37.74071069 | - | 1466035200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570700000 | ULLOA ST | - | - | - | - | - | - |
| 17611 | N/A | Point | - | - | - | - | S108583 | 16TH AVE: QUINTARA ST | - | F | F | - | F | 23190000 | 23190000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | QUINTARA ST | 16TH AVE | 7326 | 7326 | 37.74878676 | -122.47287311 | 16TH AVE \ QUINTARA ST | QUINTARA ST \ 16TH AVE | 1710539427000 | MTA | STOP | 16TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 34687 | 317865600000 | -122.47287311 | 37.74878676 | - | 1166140800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570220000 | QUINTARA ST | - | - | - | - | - | - |
| 17612 | N/A | Point | - | - | - | - | S108587 | POPLAR ST: 25TH ST | - | F | F | - | F | 24098000 | 24098000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 25TH ST | POPLAR ST | 7329 | 7329 | 37.75047697 | -122.42098538 | POPLAR ST \ 25TH ST | 25TH ST \ POPLAR ST | 1745519288000 | middleware_editor | ONE WAY (LA) | POPLAR ST intersection | - | 0 / MADE POPLAR ONE-WAY NB 25TH ST-..... | - | - | - | - | - | 34688 | 317980800000 | -122.42098538 | 37.75047697 | - | - | - | D8 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | LIGHT POLE | IS | 1373570220000 | 25TH ST | - | - | - | - | - | - |
| 17613 | N/A | Point | - | - | - | - | S108589 | MISSION ST: THE EMBARCADERO | - | F | F | - | F | 24550000 | 24550000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | THE EMBARCADERO | THE EMBARCADERO | 7330 | 7330 | 37.79376881 | -122.39249933 | MISSION ST \ THE EMBARCADERO | MISSION ST \ THE EMBARCADERO | 1752522731000 | middleware_editor | DO NOT ENTER | THE EMBARCADERO intersection | - | 00 / AT MUNI TURN-AROUND ENTRANCE | - | - | - | - | - | 34689 | 318499200000 | -122.39249933 | 37.79376881 | - | - | 1752522660000 | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | MUNI POLE | RETD | 1373570220000 | MISSION ST | - | - | - | - | - | - |
| 17614 | N/A | Point | - | - | - | - | S108590 | MISSION ST: THE EMBARCADERO | - | F | F | - | F | 24550000 | 24550000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | THE EMBARCADERO | THE EMBARCADERO | 7331 | 7331 | 37.79376881 | -122.39249933 | MISSION ST \ THE EMBARCADERO | MISSION ST \ THE EMBARCADERO | 1752522740000 | middleware_editor | DO NOT ENTER | THE EMBARCADERO intersection | - | 00 / AT MUNI TURN-AROUND ENTRANCE | - | - | - | - | - | 34690 | 318499200000 | -122.39249933 | 37.79376881 | - | - | 1752522660000 | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | MUNI POLE | RETD | 1373570220000 | MISSION ST | - | - | - | - | - | - |
| 17615 | N/A | Point | - | - | - | - | S108592 | STEUART ST: MISSION ST | - | F | F | - | F | 24552000 | 24552000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MISSION ST | STEUART ST | 7332 | 7332 | 37.79323049 | -122.39318133 | STEUART ST \ MISSION ST | MISSION ST \ STEUART ST | 1752524635000 | middleware_editor | DO NOT ENTER | STEUART ST intersection | - | 300N / N/E CORNER/LAST EXIT MUNITUR..... | - | - | - | - | - | 34691 | 318499200000 | -122.39318133 | 37.79323049 | - | - | 1752524580000 | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | RETD | 1373570220000 | MISSION ST | - | - | - | - | - | - |
| 17616 | N/A | Point | - | - | - | - | S108554 | 48TH AVE: MORAGA ST | - | F | F | - | F | 27938000 | 27938000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 48TH AVE | 48TH AVE | 7333 | 7333 | 37.75473633 | -122.50767372 | MORAGA ST \ 48TH AVE | MORAGA ST \ 48TH AVE | 1742230293000 | middleware_editor | STOP | 48TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 34692 | 313660800000 | -122.50767372 | 37.75473633 | - | 1495609200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570220000 | MORAGA ST | - | - | - | - | - | - |
| 17617 | N/A | Point | - | - | - | - | S108633 | DIAMOND ST: 25TH ST | - | F | F | - | F | 25758000 | 25758000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 25TH ST | DIAMOND ST | 7334 | 7334 | 37.74956203 | -122.4361377 | DIAMOND ST \ 25TH ST | 25TH ST \ DIAMOND ST | 1710539427000 | MTA | STOP | DIAMOND ST intersection | - | 0 / 00 | - | - | - | - | - | 34693 | 323308800000 | -122.4361377 | 37.74956203 | - | 1155081600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373570220000 | 25TH ST | - | - | - | - | - | - |
| 17618 | N/A | Point | - | - | - | - | S119388 | 700-899 16TH ST | - | F | F | - | F | 699000 | 699000 | - | - | SOUTH SIDE | - | - | - | - | - | - | 14319 | 14319 | 37.76664249 | -122.39348456 | - | - | 1710539427000 | MTA | 16TH ST | - | - | OPPOSITE NEC | - | - | - | - | - | 34694 | 1093996800000 | -122.39348456 | 37.76664249 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.0007 | 36X08 | SUP1 | LIGHT POLE | IS | 1373573640000 | 16TH ST | 700-899 16TH ST | 16TH ST | - | - | - | - |
| 17619 | N/A | Point | 1 | 1 | 1 - 99 | - | S119390 | 1-99 CHESLEY ST | 1-99 CHESLEY ST | F | F | - | F | 3939000 | 3939000 | - | - | EAST SIDE | - | - | - | - | HARRISON ST | HARRISON ST | 14320 | 14320 | 37.77453141 | -122.40727112 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-10PM EVERYDAY EXC "U" PERMITS | HARRISON ST to HOMER ST (1 - 99) | - | 000 BLOCK | - | - | - | - | - | 34695 | 1093996800000 | -122.40727112 | 37.77453141 | - | - | - | D6 | - | PARKING:RPP | REG | R32C(CA).0030 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373573640000 | CHESLEY ST | 1 - 99 CHESLEY ST | 1 - 99 CHESLEY ST | 1 CHESLEY ST | - | HOMER ST | HOMER ST |
| 17620 | N/A | Point | 1 | 1 | 1 - 99 | - | S119392 | 1-99 CHESLEY ST | 1-99 CHESLEY ST | F | F | - | F | 3939000 | 3939000 | - | - | EAST SIDE | - | - | - | - | HARRISON ST | HARRISON ST | 14322 | 14322 | 37.77453141 | -122.40727112 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-10PM EVERYDAY EXC "U" PERMITS | HARRISON ST to HOMER ST (1 - 99) | - | 000 BLOCK | - | - | - | - | - | 34696 | 1093996800000 | -122.40727112 | 37.77453141 | - | - | - | D6 | - | PARKING:RPP | REG | R32C(CA).0030 | 18X21 | SUP1 | LIGHT POLE | IS | 1373573640000 | CHESLEY ST | 1 - 99 CHESLEY ST | 1 - 99 CHESLEY ST | 1 CHESLEY ST | - | HOMER ST | HOMER ST |
| 17621 | N/A | Point | - | - | - | - | S116698 | 17TH AVE: TARAVAL ST | - | F | F | - | F | 23179000 | 23179000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 17TH AVE | 14324 | 14324 | 37.74314359 | -122.47355342 | 17TH AVE \ TARAVAL ST | TARAVAL ST \ 17TH AVE | 1721944652000 | middleware_editor | ALL WAY | 17TH AVE intersection | - | - | - | - | - | - | - | 34697 | - | -122.47355342 | 37.74314359 | - | - | 1721915100000 | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | RETD | 1373572740000 | TARAVAL ST | - | - | - | - | - | - |
| 17622 | N/A | Point | - | - | - | - | S116703 | TARAVAL ST: 17TH AVE | - | F | F | - | F | 23179000 | 23179000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 17TH AVE | 14328 | 14328 | 37.74314359 | -122.47355342 | 17TH AVE \ TARAVAL ST | TARAVAL ST \ 17TH AVE | 1721944666000 | middleware_editor | ALL WAY | 17TH AVE intersection | - | - | - | - | - | - | - | 34698 | - | -122.47355342 | 37.74314359 | - | - | 1721916720000 | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | RETD | 1373572740000 | TARAVAL ST | - | - | - | - | - | - |
| 17623 | N/A | Point | - | - | - | - | S116704 | TARAVAL ST: 17TH AVE | - | F | F | - | F | 23179000 | 23179000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 17TH AVE | 14329 | 14329 | 37.74314359 | -122.47355342 | 17TH AVE \ TARAVAL ST | TARAVAL ST \ 17TH AVE | 1721944684000 | middleware_editor | ALL WAY | 17TH AVE intersection | - | - | - | - | - | - | - | 34699 | - | -122.47355342 | 37.74314359 | - | - | 1721914200000 | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | MUNI POLE | RETD | 1373572740000 | TARAVAL ST | - | - | - | - | - | - |
| 17624 | N/A | Point | 1 | 1 | 700 - 799 | - | S122667 | 700-799 SAN BRUNO AVE | 700-799 SAN BRUNO AVE | F | F | - | F | 11357000 | 11357000 | - | - | WEST SIDE | - | - | - | - | 19TH ST | 19TH ST | 14330 | 14330 | 37.76014719 | -122.40503452 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | 19TH ST to 20TH ST (700 - 799) | - | 25' NORTH OF 20TH ST | - | - | - | - | - | 34700 | 1139356800000 | -122.40503452 | 37.76014719 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373574660000 | SAN BRUNO AVE | 700 - 799 SAN BRUNO AVE | 700 - 799 SAN BRUNO AVE | 700 SAN BRUNO AVE | - | 20TH ST | 20TH ST |
| 17625 | N/A | Point | 1 | 1 | 700 - 799 | - | S122668 | 700-799 SAN BRUNO AVE | 700-799 SAN BRUNO AVE | F | F | - | F | 11357000 | 11357000 | - | - | EAST SIDE | - | - | - | - | 19TH ST | 19TH ST | 14331 | 14331 | 37.76014719 | -122.40503452 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | 19TH ST to 20TH ST (700 - 799) | - | NPL # 703 | - | - | - | - | - | 34701 | 1139356800000 | -122.40503452 | 37.76014719 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373574660000 | SAN BRUNO AVE | 700 - 799 SAN BRUNO AVE | 700 - 799 SAN BRUNO AVE | 700 SAN BRUNO AVE | - | 20TH ST | 20TH 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