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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64726 | N/A | Point | 1 | 1 | 800 - 850 | - | S145931 | 800-850 MOUNT VERNON AVE | 800-850 MOUNT VERNON AVE | F | F | - | F | 9435000 | 9435000 | - | - | NORTH SIDE | - | - | - | - | HOWTH ST | HOWTH ST | 121919 | 121919 | 37.71982249 | -122.45198759 | - | - | 1753374530000 | middleware_editor | NPRK 1PM-3PM 1ST & 3RD MON OF MONTH STCL | HOWTH ST to WILLIAR AVE (800 - 850) | - | OPP#811 | - | - | - | - | - | 81839 | 1223362800000 | -122.45198759 | 37.71982249 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0094 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375727820000 | MOUNT VERNON AVE | 800 - 850 MOUNT VERNON AVE | 800 - 850 MOUNT VERNON AVE | 800 MOUNT VERNON AVE | - | WILLIAR AVE | WILLIAR AVE |
| 64727 | N/A | Point | - | - | - | - | S273686 | ESMERALDA AVE: FRANCONIA ST \ | - | F | F | - | F | 10349000 | 21105000 | - | - | SOUTH EAST CORNER | - | - | - | - | BRADFORD ST \ ESMERALDA AVE | BRADFORD ST \ ESMERALDA AVE | 121933 | 121933 | 37.7432320852124 | -122.409009361495 | - | PERALTA AVE \ BRADFORD ST \ ESMERALDA AVE | 1754579001000 | middleware_editor | PERALTA AVE | BRADFORD ST \ ESMERALDA AVE intersection | - | NEXT TO 603 PERALTA | - | - | - | - | - | 81840 | 187603200000 | -122.40936105 | 37.74326278 | - | 1617346800000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1370 | 36X08 | SUP2 | 3IN IRON POST | IS | 1617096060000 | PERALTA AVE | 600 - 649 PERALTA AVE | - | - | - | MAYFLOWER ST | - |
| 64728 | N/A | Point | - | - | - | - | S273687 | ESMERALDA AVE: FRANCONIA ST \ | - | F | F | - | F | 10349000 | 21105000 | - | - | SOUTH EAST CORNER | - | - | - | - | BRADFORD ST \ ESMERALDA AVE | BRADFORD ST \ ESMERALDA AVE | 121934 | 121934 | 37.743236602278 | -122.409032955761 | - | PERALTA AVE \ BRADFORD ST \ ESMERALDA AVE | 1754501140000 | middleware_editor | ESMERALDA AVE | BRADFORD ST \ ESMERALDA AVE intersection | - | NEXT TO 603 PERALTA | - | - | - | - | - | 81841 | 187603200000 | -122.40936105 | 37.74326278 | - | 1617346800000 | - | D9 | - | STREET NAME | GUIDE | D3-1.0622 | 36X08 | SUP2 | 3IN IRON POST | IS | 1617096780000 | PERALTA AVE | 600 - 649 PERALTA AVE | - | - | - | MAYFLOWER ST | - |
| 64729 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S275153 | 2200-2299 INGALLS ST | 2200-2299 INGALLS ST | F | F | - | F | 7232000 | 7232000 | - | - | WEST SIDE | - | - | - | - | WALLACE AVE | WALLACE AVE | 121957 | 121957 | 37.72504161 | -122.38764938 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM MON/ 12MN-6AM FR STCL | WALLACE AVE to YOSEMITE AVE (2200 - 2299) | - | 80' NORTH OF WALLACE AVE. | - | - | - | - | - | 81842 | 1625667840000 | -122.38764938 | 37.72504161 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0334 | 18X18 | SUP1 | 2IN IRON POST | IS | 1622561880000 | INGALLS ST | 2200 - 2299 INGALLS ST | 2200 - 2299 INGALLS ST | 2200 INGALLS ST | - | YOSEMITE AVE | YOSEMITE AVE |
| 64730 | N/A | Point | - | - | - | - | S279410 | GOETTINGEN ST: MANSELL ST | - | F | F | - | F | 20589000 | 20589000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MANSELL ST | GOETTINGEN ST | 124082 | 124082 | 37.72076685 | -122.40401775 | GOETTINGEN ST \ MANSELL ST | MANSELL ST \ GOETTINGEN ST | 1716427560000 | middleware_editor | DEAD END | GOETTINGEN ST intersection | - | - | - | - | - | - | - | 81843 | - | -122.40401775 | 37.72076685 | - | - | - | D10 | - | OTHER WARNING | WARNING | W14-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1638956400000 | MANSELL ST | - | - | - | - | - | - |
| 64731 | N/A | Point | 1 | 1 | 500 - 599 | - | S279414 | 500-599 FELL ST | 500-599 FELL ST | F | F | - | F | 5444000 | 5444000 | - | - | SOUTH SIDE | - | - | - | - | LAGUNA ST | LAGUNA ST | 124083 | 124083 | 37.77542093 | -122.42689719 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-9PM MON-SAT EXC "HV" PERMITS | LAGUNA ST to BUCHANAN ST (500 - 599) | - | IFO#529-531 | - | - | - | - | - | 81844 | 1667260800000 | -122.42689719 | 37.77542093 | - | - | - | D5 | - | PARKING:RPP | REG | R32C(CA).0251 | 18X21 | SUP1 | LIGHT POLE | IS | 1638957480000 | FELL ST | 500 - 599 FELL ST | 500 - 599 FELL ST | 500 FELL ST | - | BUCHANAN ST | BUCHANAN ST |
| 64732 | N/A | Point | 1 | 1 | 500 - 599 | - | S279415 | 500-599 FELL ST | 500-599 FELL ST | F | F | - | F | 5444000 | 5444000 | - | - | SOUTH SIDE | - | - | - | - | LAGUNA ST | LAGUNA ST | 124084 | 124084 | 37.77542093 | -122.42689719 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-9PM MON-SAT EXC "HV" PERMITS | LAGUNA ST to BUCHANAN ST (500 - 599) | - | WPL# 573 FELL ST | - | - | - | - | - | 81845 | 1667174400000 | -122.42689719 | 37.77542093 | - | - | - | D5 | - | PARKING:RPP | REG | R32C(CA).0251 | 18X21 | SUP1 | 2IN IRON POST | IS | 1638957540000 | FELL ST | 500 - 599 FELL ST | 500 - 599 FELL ST | 500 FELL ST | - | BUCHANAN ST | BUCHANAN ST |
| 64733 | N/A | Point | 1 | 1 | 400 - 599 | LEFT ARROW | S279416 | 400-599 PARNASSUS AVE | 400-599 PARNASSUS AVE | F | F | - | F | 10293000 | 10293000 | - | - | SOUTH SIDE | - | - | - | - | HILLWAY AVE | HILLWAY AVE | 124085 | 124085 | 37.76336907 | -122.45822957 | - | - | 1710539427000 | MTA | TA (SYM) SHUTTLE BUS ONLY AT ALL TIMES (20 MIN) | HILLWAY AVE to 03RD AVE (400 - 599) | - | 45' E OF ENTRANCE OF # 521 PARNASUS | - | - | - | - | - | 81846 | 1641859200000 | -122.45822957 | 37.76336907 | - | - | - | D5 | - | OTHER REGULATORY | REG | R38(SF)2.0001 | 14X21 | SUP1 | 2IN IRON POST | IS | 1638960240000 | PARNASSUS AVE | 400 - 599 PARNASSUS AVE | 400 - 599 PARNASSUS AVE | 400 PARNASSUS AVE | - | 03RD AVE | 03RD AVE |
| 64734 | N/A | Point | 1 | 1 | 400 - 599 | - | S279417 | 400-599 PARNASSUS AVE | 400-599 PARNASSUS AVE | F | F | - | F | 10293000 | 10293000 | - | - | SOUTH SIDE | - | - | - | - | HILLWAY AVE | HILLWAY AVE | 124086 | 124086 | 37.76336907 | -122.45822957 | - | - | 1710539427000 | MTA | TA (SYM) SHUTTLE BUS ONLY AT ALL TIMES (20 MIN) | HILLWAY AVE to 03RD AVE (400 - 599) | - | 110' E OF ENTRANCE OF # 521 PARNASUS | - | - | - | - | - | 81847 | 1641859200000 | -122.45822957 | 37.76336907 | - | - | - | D5 | - | OTHER REGULATORY | REG | R38(SF)2.0001 | 14X21 | SUP1 | LIGHT POLE | IS | 1638960300000 | PARNASSUS AVE | 400 - 599 PARNASSUS AVE | 400 - 599 PARNASSUS AVE | 400 PARNASSUS AVE | - | 03RD AVE | 03RD AVE |
| 64735 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S274802 | 1500-1599 HAIGHT ST | 1500-1599 HAIGHT ST | F | F | - | F | 6619000 | 6619000 | - | - | NORTH SIDE | - | - | - | - | ASHBURY ST | ASHBURY ST | 124163 | 124163 | 37.76990273 | -122.44775632 | - | - | 1710539427000 | MTA | MUNI LANDOR FLAG - TYPE 6 | ASHBURY ST to CLAYTON ST (1500 - 1599) | - | 38' E OF CLAYTON | - | - | - | - | - | 81848 | - | -122.44775632 | 37.76990273 | - | - | - | D5 | - | OTHER REGULATORY | REG | R(SF).0334 | 15X39 | SUP1 | MUNI POLE | IS | 1621418700000 | HAIGHT ST | 1500 - 1599 HAIGHT ST | 1500 - 1599 HAIGHT ST | 1500 HAIGHT ST | - | CLAYTON ST | CLAYTON ST |
| 64736 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S274984 | 1200-1299 SACRAMENTO ST | 1200-1299 SACRAMENTO ST | F | F | - | F | 11240000 | 11240000 | - | - | NORTH SIDE | - | - | - | - | TAYLOR ST | TAYLOR ST | 124164 | 124164 | 37.79244747 | -122.41347146 | - | - | 1738255382000 | middleware_editor | 2 HR PRK 8AM-9PM MON-FRI EXC "C" PERMITS | TAYLOR ST to JONES ST (1200 - 1299) | - | 25' WEST OF TAYLOR | - | - | - | - | - | 81849 | 1623321120000 | -122.41347146 | 37.79244747 | - | - | - | D3 | - | PARKING:RPP | REG | R32C(CA).0121 | 18X21 | SUP1 | 2IN IRON POST | IS | 1622052120000 | SACRAMENTO ST | 1200 - 1299 SACRAMENTO ST | 1200 - 1299 SACRAMENTO ST | 1200 SACRAMENTO ST | - | JONES ST | JONES ST |
| 64737 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S274985 | 1200-1299 SACRAMENTO ST | 1200-1299 SACRAMENTO ST | F | F | - | F | 11240000 | 11240000 | - | - | NORTH SIDE | - | - | - | - | TAYLOR ST | TAYLOR ST | 124165 | 124165 | 37.79244747 | -122.41347146 | - | - | 1738259219000 | middleware_editor | TANS 3PM-7PM EXC SAT & SUN | TAYLOR ST to JONES ST (1200 - 1299) | - | 25' WEST OF TAYLOR ST. | - | - | - | - | - | 81850 | 1623331560000 | -122.41347146 | 37.79244747 | - | 1656374400000 | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | 2IN IRON POST | IS | 1622052180000 | SACRAMENTO ST | 1200 - 1299 SACRAMENTO ST | 1200 - 1299 SACRAMENTO ST | 1200 SACRAMENTO ST | - | JONES ST | JONES ST |
| 64738 | N/A | Point | 1 | 1 | 100 - 199 | RIGHT ARROW | S274870 | 100-199 WISCONSIN ST | 100-199 WISCONSIN ST | F | F | - | F | 13693000 | 13693000 | - | - | WEST SIDE | - | - | - | - | 16TH ST | 16TH ST | 124182 | 124182 | 37.76560405 | -122.39972714 | - | - | 1710539427000 | MTA | PARK PARALLEL | 16TH ST to 17TH ST (100 - 199) | - | 84' SOUTH OF 16TH ST | - | - | - | - | - | 81851 | 1622714820000 | -122.39972714 | 37.76560405 | - | - | - | D10 | - | PARKING:PARALLEL | REG | R24(CA).0001 | 18X18 | SUP1 | 2IN IRON POST | IS | 1621591140000 | WISCONSIN ST | 100 - 199 WISCONSIN ST | 100 - 199 WISCONSIN ST | 100 WISCONSIN ST | - | 17TH ST | 17TH ST |
| 64739 | N/A | Point | 1 | 1 | 100 - 199 | LEFT ARROW | S274871 | 100-199 WISCONSIN ST | 100-199 WISCONSIN ST | F | F | - | F | 13693000 | 13693000 | - | - | WEST SIDE | - | - | - | - | 16TH ST | 16TH ST | 124183 | 124183 | 37.76560405 | -122.39972714 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES | 16TH ST to 17TH ST (100 - 199) | - | 84' SOUTH OF 16TH ST | - | - | - | - | - | 81852 | 1622714880000 | -122.39972714 | 37.76560405 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0372 | 18X18 | SUP1 | 2IN IRON POST | IS | 1621591140000 | WISCONSIN ST | 100 - 199 WISCONSIN ST | 100 - 199 WISCONSIN ST | 100 WISCONSIN ST | - | 17TH ST | 17TH ST |
| 64740 | N/A | Point | - | - | - | - | S275234 | BRANNAN ST: 8TH ST | - | T | T | - | F | 23872000 | 23872000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BRANNAN ST | 08TH ST | 124184 | 124184 | 37.77129635 | -122.40542474 | 8TH ST \ BRANNAN ST | BRANNAN ST \ 08TH ST | 1710539427000 | MTA | 8TH ST | 08TH ST intersection | - | - | - | - | - | - | - | 81853 | 1627307640000 | -122.40542474 | 37.77129635 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-2.0064 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1622714280000 | BRANNAN ST | - | - | - | - | - | - |
| 64741 | N/A | Point | - | - | - | - | S275236 | BRANNAN ST: 8TH ST | - | T | T | - | F | 23872000 | 23872000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BRANNAN ST | 08TH ST | 124185 | 124185 | 37.77129635 | -122.40542474 | 8TH ST \ BRANNAN ST | BRANNAN ST \ 08TH ST | 1710539427000 | MTA | 8TH ST | 08TH ST intersection | - | - | - | - | - | - | - | 81854 | 1627378140000 | -122.40542474 | 37.77129635 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-2.0064 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1622714940000 | BRANNAN ST | - | - | - | - | - | - |
| 64742 | N/A | Point | - | - | - | - | S275243 | 8TH ST: BRANNAN ST | - | T | T | - | F | 23872000 | 23872000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BRANNAN ST | 08TH ST | 124186 | 124186 | 37.77129635 | -122.40542474 | 8TH ST \ BRANNAN ST | BRANNAN ST \ 08TH ST | 1710539427000 | MTA | BRANNAN ST | 08TH ST intersection | - | ABOVE DO NOT ENTER | - | - | - | - | - | 81855 | 1627386240000 | -122.40542474 | 37.77129635 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-2.0088 | 72X18 | SUP1 | SIGNAL POLE | IS | 1622715900000 | BRANNAN ST | - | - | - | - | - | - |
| 64743 | N/A | Point | - | - | - | - | S275245 | BRANNAN ST: 8TH ST | - | T | T | - | F | 23872000 | 23872000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BRANNAN ST | 08TH ST | 124187 | 124187 | 37.77129635 | -122.40542474 | 8TH ST \ BRANNAN ST | BRANNAN ST \ 08TH ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | 08TH ST intersection | - | - | - | - | - | - | - | 81856 | 1627378320000 | -122.40542474 | 37.77129635 | - | - | - | D6 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1622716920000 | BRANNAN ST | - | - | - | - | - | - |
| 64744 | N/A | Point | 1 | 1 | 1 - 99 | - | S272808 | 1-99 MARINA BLVD | 1-99 MARINA BLVD | F | F | - | F | 8701000 | 8701000 | - | - | SOUTH SIDE | - | - | - | - | LAGUNA ST | LAGUNA ST | 124188 | 124188 | 37.80510956 | -122.43294619 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "M" PERMITS | LAGUNA ST to BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST (1 - 99) | - | 110' E OF BUCHANAN | - | - | - | - | - | 81857 | - | -122.43294619 | 37.80510956 | - | - | - | D2 | - | PARKING:RPP | REG | R32C(CA).0096 | 18X21 | SUP1 | 2IN IRON POST | IS | 1614685620000 | MARINA BLVD | 1 - 99 MARINA BLVD | 1 - 99 MARINA BLVD | 1 MARINA BLVD | - | BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST | BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST |
| 64745 | N/A | Point | - | 1 | 100 - 199 | - | S272846 | 100-199 RICKARD ST | 100-199 RICKARD ST | F | F | - | F | 11017000 | 11017000 | - | - | SOUTH SIDE | - | - | - | - | BARNEVELD AVE | BARNEVELD AVE | 124189 | 124189 | 37.73427625 | -122.40743409 | - | - | 1710539427000 | MTA | NPRK 8AM-11AM THUR STCL | BARNEVELD AVE to SAN BRUNO AVE (100 - 199) | - | 250 FT WEST FROM SAN BRUNO | - | - | - | - | - | 81858 | 1548288000000 | -122.40743409 | 37.73427625 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0276 | 18X18 | SUP2 | 2IN IRON POST | IS | 1614764160000 | RICKARD ST | 100 - 199 RICKARD ST | 100 - 199 RICKARD ST | 100 RICKARD ST | - | SAN BRUNO AVE | SAN BRUNO AVE |
| 64746 | N/A | Point | - | - | - | - | S231227 | MANGELS AVE: HAZELWOOD AVE | - | F | F | - | F | 22798000 | 22798000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MANGELS AVE | HAZELWOOD AVE | 125661 | 125661 | 37.73292362 | -122.45526051 | HAZELWOOD AVE \ MANGELS AVE | MANGELS AVE \ HAZELWOOD AVE | 1710539427000 | MTA | ALL WAY | HAZELWOOD AVE intersection | - | 0 / 0 | - | - | - | - | - | 81859 | 118368000000 | -122.45526051 | 37.73292362 | - | 1486425600000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1479811920000 | MANGELS AVE | - | - | - | - | - | - |
| 64747 | N/A | Point | 1 | 1 | 27 - 83 | - | S287233 | 27-83 MAYFAIR DR | 27-83 MAYFAIR DR | F | F | - | F | 8871000 | 8871000 | - | - | NORTH SIDE | - | - | - | - | COLLINS ST | COLLINS ST | 125663 | 125663 | 37.78602967 | -122.45081581 | - | - | 1713229868000 | middleware_editor | NPRK 6AM-8AM MON STCL | COLLINS ST to MANZANITA AVE (27 - 83) | - | 55' EAST OF MANZANITA | - | - | - | - | - | 81860 | - | -122.45081581 | 37.78602967 | - | - | - | D2 | - | STREET CLEANING | REG | R30B(CA).0186 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1674731160000 | MAYFAIR DR | 27 - 83 MAYFAIR DR | 27 - 83 MAYFAIR DR | 27 MAYFAIR DR | - | MANZANITA AVE | MANZANITA AVE |
| 64748 | N/A | Point | 1 | 1 | 500 - 599 | - | S138129 | 500-599 12TH AVE | 500-599 12TH AVE | F | F | - | F | 524000 | 524000 | - | - | EAST SIDE | - | - | - | - | ANZA ST | ANZA ST | 125884 | 125884 | 37.77787105 | -122.47050029 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-6PM MON-FRI EXC "N" PERMITS | ANZA ST to BALBOA ST (500 - 599) | - | SPL #506 | - | - | - | - | - | 81861 | 1366070400000 | -122.47050029 | 37.77787105 | - | - | - | D1 | - | PARKING:RPP | REG | R32C(CA).0169 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373579460000 | 12TH AVE | 500 - 599 12TH AVE | 500 - 599 12TH AVE | 500 12TH AVE | - | BALBOA ST | BALBOA ST |
| 64749 | N/A | Point | - | - | - | - | S135507 | OCTAVIA ST: GROVE ST | - | F | F | - | F | 25928000 | 25928000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 125886 | 125886 | 37.77760186 | -122.42480888 | GROVE ST \ OCTAVIA ST | GROVE ST \ OCTAVIA ST | 1710539427000 | MTA | "P" (WHITE-BLUE) | OCTAVIA ST intersection | - | - | - | - | - | - | - | 81862 | 1323302400000 | -122.42480888 | 37.77760186 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP1 | UTILITY POLE | IS | 1373578680000 | GROVE ST | - | - | - | - | - | - |
| 64750 | N/A | Point | - | - | - | - | S137533 | CHURCH ST: 15TH ST | - | F | F | - | F | 25727000 | 25727000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 15TH ST | 15TH ST | 125887 | 125887 | 37.76613001 | -122.42881915 | CHURCH ST \ 15TH ST | CHURCH ST \ 15TH ST | 1722993981000 | middleware_editor | NO LEFT TURN (SYM) 7AM-7PM EXC SAT & SUN | 15TH ST intersection | - | - | - | - | - | - | - | 81863 | 1353283200000 | -122.42881915 | 37.76613001 | - | - | - | D8 | - | NO LEFT TURN | REG | R33(CA).0023 | 24X36 | SUP2 | MUNI POLE | IS | 1373579280000 | CHURCH ST | - | - | - | - | - | - |
| 64751 | N/A | Point | - | - | - | - | S136736 | CHURCH ST: DUBOCE AVE | - | F | F | - | F | 25884000 | 25884000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 125888 | 125888 | 37.76945613 | -122.42912799 | CHURCH ST \ DUBOCE AVE | CHURCH ST \ DUBOCE AVE | 1710539427000 | MTA | EXC MUNI & BICYCLES | DUBOCE AVE intersection | - | - | - | - | - | - | - | 81864 | 1339632000000 | -122.42912799 | 37.76945613 | - | - | - | D8 | - | OTHER REGULATORY | REG | R(SF).0074 | 30X24 | SUP2 | MUNI POLE | IS | 1373579040000 | CHURCH ST | - | - | - | - | - | - |
| 64752 | N/A | Point | - | 1 | 200 - 256 | LEFT ARROW | S268997 | 200-256 PENNSYLVANIA AVE | 200-256 PENNSYLVANIA AVE | F | F | - | F | 10332000 | 10332000 | - | - | EAST SIDE | - | - | - | - | MARIPOSA ST | MARIPOSA ST | 125889 | 125889 | 37.76365878 | -122.39369621 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM THUR STCL | MARIPOSA ST to I-280 S OFF RAMP (200 - 256) | - | OPPO #260 / 75' NORTH OF 1-280 OFF RAMP | - | - | - | - | - | 81865 | - | -122.39369621 | 37.76365878 | - | 1639440000000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0054 | 18X18 | SUP1 | LIGHT POLE | IS | 1602169860000 | PENNSYLVANIA AVE | 200 - 256 PENNSYLVANIA AVE | 200 - 256 PENNSYLVANIA AVE | 200 PENNSYLVANIA AVE | - | I-280 S OFF RAMP | I-280 S OFF RAMP |
| 64753 | N/A | Point | 1 | 1 | 600 - 699 | - | S281557 | 600-699 CENTRAL AVE | 600-699 CENTRAL AVE | F | F | - | F | 3865000 | 3865000 | - | - | EAST SIDE | - | - | - | - | GROVE ST | GROVE ST | 125891 | 125891 | 37.77555134 | -122.44468638 | - | - | 1710539427000 | MTA | BIKE RACK | GROVE ST to FULTON ST (600 - 699) | 520382 | SPL 654/3.5' IN FROM CURB | - | - | - | - | - | 81866 | 1664928000000 | -122.44468638 | 37.77555134 | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1647421140000 | CENTRAL AVE | 600 - 699 CENTRAL AVE | 600 - 699 CENTRAL AVE | 600 CENTRAL AVE | - | FULTON ST | FULTON ST |
| 64754 | N/A | Point | - | - | - | - | S254994 | MARTIN LUTHER KING JR DR: BOWL | - | F | F | - | F | 27182000 | 27182000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | MARTIN LUTHER KING JR DR | BOWLING GREEN DR | 125893 | 125893 | 37.76744881 | -122.46067684 | BOWLING GREEN DR \ MARTIN LUTHER KING JR DR | MARTIN LUTHER KING JR DR \ BOWLING GREEN DR | 1710539427000 | MTA | REMOVE (SF BIKE ROUTE) GREEN (SYM) # | BOWLING GREEN DR intersection | - | SOUTH SIDE OPP GAS STATION ENTRANCE | - | - | - | - | - | 81867 | 514339200000 | -122.46067684 | 37.76744881 | - | - | - | D5 | - | BIKE REG | REG | R(SF).0388 | 12X24 | SUP1 | 2IN IRON POST | IS | 1559642760000 | MARTIN LUTHER KING JR DR | - | - | - | - | - | - |
| 64755 | N/A | Point | - | - | - | - | S255426 | LYELL ST: STILL ST | - | F | F | - | F | 33700000 | 33700000 | - | - | WEST SIDE, WESTBOUND TRAFFIC | - | - | - | - | STILL ST | STILL ST | 125895 | 125895 | 37.73173713 | -122.43139031 | LYELL ST \ STILL ST | LYELL ST \ STILL ST | 1710539427000 | MTA | TWO WAY BIKE TRAFFIC (SYM) BIKE ON BOTTOM | STILL ST intersection | - | NPL 68 | - | - | - | - | - | 81868 | 1075766400000 | -122.43139031 | 37.73173713 | - | 1561507200000 | - | D8 | - | OTHER WARNING | WARNING | W6-3.0005 | 30X30 | SUP2 | 2IN IRON POST | IS | 1560936000000 | LYELL ST | - | - | - | - | - | - |
| 64756 | N/A | Point | 1 | 1 | 631 - 699 | - | S121509 | 631-699 MISSOURI ST | 631-699 MISSOURI ST | F | F | - | F | 9213000 | 9213000 | - | - | WEST SIDE | - | - | - | - | SIERRA ST | SIERRA ST | 125897 | 125897 | 37.75788598 | -122.39605075 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM WED STCL | SIERRA ST to 22ND ST (631 - 699) | - | NPL # 642 | - | - | - | - | - | 81869 | 1124064000000 | -122.39605075 | 37.75788598 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373574300000 | MISSOURI ST | 631 - 699 MISSOURI ST | 631 - 699 MISSOURI ST | 631 MISSOURI ST | - | 22ND ST | 22ND ST |
| 64757 | N/A | Point | - | - | - | - | S253497 | MISSION BAY DR: MISSION BAY CI | - | F | F | - | F | 35049000 | 35049000 | - | - | SOUTH WEST CORNER | - | - | - | - | MISSION BAY CIR | MISSION BAY CIR | 128907 | 128907 | 37.77036256 | -122.3961987 | MISSION BAY DR \ MISSION BAY CIR | MISSION BAY DR \ MISSION BAY CIR | 1713922663000 | middleware_editor | MISSION BAY DR | MISSION BAY CIR intersection | - | MISSION BAY DR & MISSION BAY SOUTH | - | - | - | - | - | 81870 | 1556204160000 | -122.3961987 | 37.77036256 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.1980 | 36X08 | SUP1 | LIGHT POLE | IS | 1555074300000 | MISSION BAY DR | - | - | - | - | - | - |
| 64758 | N/A | Point | - | - | - | - | S254089 | MISSION BAY DR: MISSION BAY CI | - | F | F | - | F | 35051000 | 35049000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MISSION BAY BLVD \ MISSION BAY CIR | MISSION BAY CIR | 128908 | 128908 | 37.7704473108982 | -122.395585765259 | MISSION BAY BLVD SOUTH \ MISSION BAY BLVD \ MISSION BAY CIR | MISSION BAY DR \ MISSION BAY CIR | 1744057708000 | middleware_editor | (45 LA-DN) | MISSION BAY CIR intersection | - | - | - | - | - | - | - | 81871 | 1556521200000 | -122.3961987 | 37.77036256 | - | 1557126000000 | - | D6 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP1 | 2IN IRON POST | IS | 1556889000000 | MISSION BAY DR | - | - | - | - | - | - |
| 64759 | N/A | Point | - | - | - | - | S255369 | TAYLOR ST: GEARY ST | - | F | F | - | F | 24941000 | 24941000 | - | - | NORTH WEST CORNER | - | - | - | - | TAYLOR ST | GEARY ST | 128910 | 128910 | 37.78693971 | -122.41151577 | GEARY ST \ TAYLOR ST | TAYLOR ST \ GEARY ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | GEARY ST intersection | - | - | - | - | - | - | - | 81872 | 1476662400000 | -122.41151577 | 37.78693971 | - | 1560816000000 | - | D3 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1560848220000 | TAYLOR ST | - | - | - | - | - | - |
| 64760 | N/A | Point | - | - | - | - | S103233 | WAITHMAN WAY: ULLOA ST | - | F | F | - | F | 22839000 | 22839000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WAITHMAN WAY | WAITHMAN WAY | 128911 | 128911 | 37.74214895 | -122.45678008 | ULLOA ST \ WAITHMAN WAY | ULLOA ST \ WAITHMAN WAY | 1756319924000 | middleware_editor | ONE WAY (RA) | WAITHMAN WAY intersection | - | IFO 284 | - | - | - | - | - | 81873 | -282844800000 | -122.45678008 | 37.74214895 | - | - | - | D7 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | 2IN IRON POST | IS | 1373568540000 | ULLOA ST | - | - | - | - | - | - |
| 64761 | N/A | Point | - | - | - | - | S252383 | 2ND ST: CLEMENTINA ST | - | F | F | - | F | 24535000 | 24535000 | - | - | WEST SIDE | - | - | - | - | CLEMENTINA ST | 02ND ST | 128912 | 128912 | 37.78596399 | -122.39723446 | 2ND ST \ CLEMENTINA ST | CLEMENTINA ST \ 02ND ST | 1738885832000 | middleware_editor | FG 300 UR DELINEATOR (W) | 02ND ST intersection | - | 10' O.C. BTWN CLEMENTINA TO FOLSOM | - | - | - | - | - | 81874 | 1542585600000 | -122.39723446 | 37.78596399 | - | 1738839600000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | TURNPIKE BASE | IS | 1552484340000 | CLEMENTINA ST | - | - | - | - | - | - |
| 64762 | N/A | Point | - | - | - | - | S214299 | 2ND AVE: ANZA ST | - | F | F | - | F | 27226000 | 27226000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ANZA ST | 02ND AVE | 128913 | 128913 | 37.7791977056197 | -122.459787726397 | 02ND AVE \ ANZA ST | ANZA ST \ 02ND AVE | 1742422228000 | middleware_editor | ALL WAY | 02ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 81875 | -41187600000 | -122.45986037 | 37.77928263 | - | 1430290800000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1426509420000 | ANZA ST | - | - | - | - | - | - |
| 64763 | N/A | Point | - | - | - | - | S252141 | WOOLSEY ST: BOWDOIN ST | - | F | F | - | F | 20868000 | 20868000 | - | - | SOUTH SIDE | - | - | - | - | BOWDOIN ST | BOWDOIN ST | 128915 | 128915 | 37.72343035 | -122.40951469 | WOOLSEY ST \ BOWDOIN ST | WOOLSEY ST \ BOWDOIN ST | 1710539427000 | MTA | NPRK 12NN-3PM FRI STCL | BOWDOIN ST intersection | - | WPL 825 | - | - | - | - | - | 81876 | 854928000000 | -122.40951469 | 37.72343035 | - | 1553731200000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0087 | 18X18 | SUP2 | 2IN IRON POST | IS | 1551868680000 | WOOLSEY ST | - | - | - | - | - | - |
| 64764 | N/A | Point | - | - | - | - | S234602 | 7TH ST: FOLSOM ST | - | T | T | - | F | 24262000 | 24262000 | - | - | SOUTH EAST CORNER | - | - | - | - | FOLSOM ST | FOLSOM ST | 128916 | 128916 | 37.77674611 | -122.40784206 | 7TH ST \ FOLSOM ST | 07TH ST \ FOLSOM ST | 1738947913000 | middleware_editor | 7TH ST | FOLSOM ST intersection | - | 7TH ST 300 | - | - | - | - | - | 81877 | 1493032740000 | -122.40784206 | 37.77674611 | - | 1492992000000 | - | D6 | - | STREET NAME | GUIDE | D3-1.0045 | 36X08 | SUP1 | LIGHT POLE | IS | 1490357100000 | 07TH ST | - | - | - | - | - | - |
| 64765 | N/A | Point | - | - | - | - | S201744 | CLEMENTINA ST: 5TH ST | - | F | F | - | F | 23939000 | 23939000 | - | - | SOUTH WEST CORNER | - | - | - | - | CLEMENTINA ST | 05TH ST | 129790 | 129790 | 37.78069905 | -122.40392088 | 5TH ST \ CLEMENTINA ST | CLEMENTINA ST \ 05TH ST | 1710539427000 | MTA | 1 HR PRK 8AM-10PM EVRYDAY EXC "U" PERMITS | 05TH ST intersection | - | - | - | - | - | - | - | 81878 | 1436365500000 | -122.40392088 | 37.78069905 | - | 1436313600000 | - | D6 | - | PARKING:RPP | REG | R32C(CA).0004 | 18X21 | SUP1 | LIGHT POLE | IS | 1389005040000 | CLEMENTINA ST | - | - | - | - | - | - |
| 64766 | N/A | Point | - | - | - | - | S205954 | MARINA BLVD: BEACH ST \ BUCHAN | - | F | F | - | F | 26758000 | 26758000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BEACH ST \ BUCHANAN ST \ MARINA BLVD | BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST | 129791 | 129791 | 37.80504329 | -122.43379794 | LOWER FORT MASON ST \ BEACH ST \ BUCHANAN ST \ MARINA BLVD | MARINA BLVD \ BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST | 1710539427000 | MTA | RIGHT LANE MUST TURN RIGHT | BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST intersection | 016342 | - | - | - | - | - | - | 81879 | 384480000000 | -122.43379794 | 37.80504329 | - | - | - | D2 | - | OTHER REGULATORY | REG | R3-7.0005 | 30X30 | SUP1 | 2IN IRON POST | IS | 1400663460000 | MARINA BLVD | - | - | - | - | - | - |
| 64767 | N/A | Point | - | - | - | - | S200164 | HARRINGTON ST: MISSION ST | - | F | F | - | F | 6705000 | 21771000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MISSION ST | HARRINGTON ST | 129793 | 129793 | 37.7251948664069 | -122.43457730859 | - | MISSION ST \ HARRINGTON ST | 1747846444000 | middleware_editor | STOP | HARRINGTON ST intersection | - | - | - | - | - | - | - | 81880 | - | -122.4344257 | 37.72517548 | - | - | - | D11 | - | STOP | REG | R1-1.0003 | 36X36 | SUP2 | 2IN IRON POST | IS | 1379403600000 | MISSION ST | 1 - 99 HARRINGTON ST | - | - | - | ALEMANY BLVD | - |
| 64768 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S287844 | 1800-1899 SACRAMENTO ST | 1800-1899 SACRAMENTO ST | F | F | - | F | 11249000 | 11249000 | - | - | SOUTH SIDE | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 129794 | 129794 | 37.7911851 | -122.4233382 | - | - | 1710539427000 | MTA | 2 HR PRK 6PM-11PM MON-SAT EXC "G" PERMITS | VAN NESS AVE to FRANKLIN ST (1800 - 1899) | - | 60' WEST OF VAN NESS AVE | - | - | - | - | - | 81881 | 1678838400000 | -122.4233382 | 37.7911851 | - | - | - | D2 | - | PARKING:RPP | REG | R32C(CA).0025 | 18X21 | SUP1 | LIGHT POLE | IS | 1678096620000 | SACRAMENTO ST | 1800 - 1899 SACRAMENTO ST | 1800 - 1899 SACRAMENTO ST | 1800 SACRAMENTO ST | - | FRANKLIN ST | FRANKLIN ST |
| 64769 | N/A | Point | 1 | 1 | 100 - 199 | - | S289253 | 100-199 KISSLING ST | 100-199 KISSLING ST | F | F | - | F | 7903000 | 7903000 | - | - | SOUTH SIDE | - | - | - | - | 11TH ST | 11TH ST | 129797 | 129797 | 37.772522767 | -122.415091126 | - | - | 1710539427000 | MTA | WHEEL STOP | 11TH ST to 12TH ST (100 - 199) | - | E SIDE OF CORRAL | - | - | - | - | - | 81882 | 1683504000000 | -122.41560313 | 37.77203843 | - | 1703845800000 | - | D6 | - | OTHER WARNING | WARNING | W(SF).0072 | 36X08 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1683217080000 | KISSLING ST | 100 - 199 KISSLING ST | 100 - 199 KISSLING ST | 100 KISSLING ST | - | 12TH ST | 12TH ST |
| 64770 | N/A | Point | - | - | - | - | S111899 | ORTEGA ST: 15TH AVE \ ORTEGA W | - | F | F | - | F | 27308000 | 27308000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ORTEGA ST \ ORTEGA WAY | 15TH AVE \ ORTEGA WAY | 7715 | 7715 | 37.752494269 | -122.472111515 | 15TH AVE \ ORTEGA ST \ ORTEGA WAY | ORTEGA ST \ 15TH AVE \ ORTEGA WAY | 1710539427000 | MTA | STOP | 15TH AVE \ ORTEGA WAY intersection | - | - | - | - | - | - | - | 81883 | 874454400000 | -122.47200758 | 37.75256982 | - | 1636070400000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571240000 | ORTEGA ST | - | - | - | - | - | - |
| 64771 | N/A | Point | 1 | 1 | 1 - 99 | - | S113472 | 1-99 SAN FERNANDO WAY | 1-99 SAN FERNANDO WAY | F | F | - | F | 11412000 | 11412000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | PORTOLA DR | PORTOLA DR | 7889 | 7889 | 37.73545628 | -122.46974423 | - | - | 1710539427000 | MTA | SPEED HUMP | PORTOLA DR to SAINT FRANCIS BLVD (1 - 99) | - | 35`SOUTH | - | - | - | - | - | 81884 | 989452800000 | -122.46974423 | 37.73545628 | - | 1394755200000 | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571780000 | SAN FERNANDO WAY | 1 - 99 SAN FERNANDO WAY | 1 - 99 SAN FERNANDO WAY | 1 SAN FERNANDO WAY | - | SAINT FRANCIS BLVD | SAINT FRANCIS BLVD |
| 64772 | N/A | Point | 1 | 1 | 100 - 199 | - | S113473 | 100-199 SAN PABLO AVE | 100-199 SAN PABLO AVE | F | F | - | F | 11502000 | 11502000 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | SANTA MONICA WAY | SANTA MONICA WAY | 7890 | 7890 | 37.73752678 | -122.4622637 | - | - | 1710539427000 | MTA | SPEED HUMP | SANTA MONICA WAY to YERBA BUENA AVE (100 - 199) | - | IFO#105 | - | - | - | - | - | 81885 | 989452800000 | -122.4622637 | 37.73752678 | - | - | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1373571780000 | SAN PABLO AVE | 100 - 199 SAN PABLO AVE | 100 - 199 SAN PABLO AVE | 100 SAN PABLO AVE | - | YERBA BUENA AVE | YERBA BUENA AVE |
| 64773 | N/A | Point | - | - | - | - | S113475 | SAN FERNANDO WAY: MONTEREY BLV | - | F | F | - | F | 22936000 | 22936000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SAN FERNANDO WAY | SAN FERNANDO WAY | 7891 | 7891 | 37.73317701 | -122.4695589 | MONTEREY BLVD \ SAN FERNANDO WAY | MONTEREY BLVD \ SAN FERNANDO WAY | 1756505787000 | middleware_editor | SPEED HUMP | SAN FERNANDO WAY intersection | - | - | - | - | - | - | - | 81886 | 989478000000 | -122.4695589 | 37.73317701 | - | - | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571780000 | MONTEREY BLVD | - | - | - | - | - | - |
| 64774 | N/A | Point | - | - | - | - | S111609 | MARKET ST: FRANKLIN ST | - | F | F | - | F | 5796000 | 30750000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PAGE ST | FRANKLIN ST | 7950 | 7950 | 37.774391549 | -122.420889207 | - | MARKET ST \ FRANKLIN ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | FRANKLIN ST intersection | - | - | - | - | - | - | - | 81887 | 828576000000 | -122.42069877 | 37.77400781 | - | - | - | D5 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1373571180000 | MARKET ST | 1 - 39 FRANKLIN ST | - | - | - | LILY ST | - |
| 64775 | N/A | Point | - | - | - | - | S111238 | EXCELSIOR AVE: LISBON ST | - | F | F | - | F | 21687000 | 21687000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LISBON ST | EXCELSIOR AVE | 8001 | 8001 | 37.725103751 | -122.431121078 | EXCELSIOR AVE \ LISBON ST | LISBON ST \ EXCELSIOR AVE | 1710539427000 | MTA | STOP | EXCELSIOR AVE intersection | - | 3'E OF UTILTIY POLE | - | - | - | - | - | 81888 | 765244800000 | -122.4312534 | 37.72510658 | - | 1260316800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571060000 | LISBON ST | - | - | - | - | - | - |
| 64776 | N/A | Point | - | - | - | - | S111239 | EXCELSIOR AVE: LISBON ST | - | F | F | - | F | 21687000 | 21687000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LISBON ST | EXCELSIOR AVE | 8002 | 8002 | 37.725117895 | -122.431364264 | EXCELSIOR AVE \ LISBON ST | LISBON ST \ EXCELSIOR AVE | 1710539427000 | MTA | STOP | EXCELSIOR AVE intersection | - | - | - | - | - | - | - | 81889 | 765244800000 | -122.4312534 | 37.72510658 | - | 1553212800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571060000 | LISBON ST | - | - | - | - | - | - |
| 64777 | N/A | Point | - | - | - | - | S111248 | 19TH ST: HARTFORD ST | - | F | F | - | F | 25788000 | 25788000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 8008 | 8008 | 37.759307678 | -122.433839887 | HARTFORD ST \ 19TH ST | HARTFORD ST \ 19TH ST | 1710539427000 | MTA | STOP | 19TH ST intersection | - | - | - | - | - | - | - | 81890 | 765244800000 | -122.43374455 | 37.75935631 | - | 1452038400000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571060000 | HARTFORD ST | - | - | - | - | - | - |
| 64778 | N/A | Point | - | - | - | - | S111249 | BRAZIL AVE: NAPLES ST | - | F | F | - | F | 21643000 | 21643000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | NAPLES ST | BRAZIL AVE | 8009 | 8009 | 37.722416257 | -122.429909921 | BRAZIL AVE \ NAPLES ST | NAPLES ST \ BRAZIL AVE | 1710539427000 | MTA | STOP | BRAZIL AVE intersection | - | - | - | - | - | - | - | 81891 | 765244800000 | -122.43002615 | 37.72239787 | - | 1598918400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571060000 | NAPLES ST | - | - | - | - | - | - |
| 64779 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S113449 | 1700-1799 IRVING ST | 1700-1799 IRVING ST | F | F | - | F | 7295000 | 7295000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 18TH AVE | 18TH AVE | 8788 | 8788 | 37.763689267 | -122.476510314 | - | - | 1710539427000 | MTA | RIGHT LANE MUST TURN RIGHT | 18TH AVE to 19TH AVE (1700 - 1799) | 79541 | 47' E OF 19TH AVE, BETWEEN PM #1722..... | - | - | - | - | - | 81892 | 989280000000 | -122.47661425 | 37.76358413 | - | - | - | D4 | - | OTHER REGULATORY | REG | R3-7.0006 | 36X36 | SUP2 | 2IN IRON POST | IS | 1373571720000 | IRVING ST | 1700 - 1799 IRVING ST | 1700 - 1799 IRVING ST | 1700 IRVING ST | - | 19TH AVE | 19TH AVE |
| 64780 | N/A | Point | - | - | - | - | S109196 | MOSCOW ST: ITALY AVE | - | F | F | - | F | 21400000 | 21400000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ITALY AVE | ITALY AVE | 8798 | 8798 | 37.715140066 | -122.432351563 | MOSCOW ST \ ITALY AVE | MOSCOW ST \ ITALY AVE | 1710539427000 | MTA | STOP | ITALY AVE intersection | - | 0 / 0 | - | - | - | - | - | 81893 | 414806400000 | -122.4323234 | 37.71503822 | - | 1577059200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570400000 | MOSCOW ST | - | - | - | - | - | - |
| 64781 | N/A | Point | - | - | - | - | S109197 | MOSCOW ST: ITALY AVE | - | F | F | - | F | 21400000 | 21400000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ITALY AVE | ITALY AVE | 8799 | 8799 | 37.714952287 | -122.43233547 | MOSCOW ST \ ITALY AVE | MOSCOW ST \ ITALY AVE | 1710539427000 | MTA | STOP | ITALY AVE intersection | - | 0 / 0 | - | - | - | - | - | 81894 | 414806400000 | -122.4323234 | 37.71503822 | - | 1577059200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373570400000 | MOSCOW ST | - | - | - | - | - | - |
| 64782 | N/A | Point | - | - | - | - | S109205 | WEST PORTAL AVE: 15TH AVE | - | F | F | - | F | 22940000 | 22940000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WEST PORTAL AVE | 15TH AVE | 8802 | 8802 | 37.736750946 | -122.470642039 | 15TH AVE \ WEST PORTAL AVE | WEST PORTAL AVE \ 15TH AVE | 1710539427000 | MTA | STOP | 15TH AVE intersection | - | - | - | - | - | - | - | 81895 | 417916800000 | -122.47057409 | 37.73658903 | - | 881884800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570400000 | WEST PORTAL AVE | - | - | - | - | - | - |
| 64783 | N/A | Point | - | - | - | - | S113558 | NEWTON ST: ROLPH ST | - | F | F | - | F | 21473000 | 21473000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | NEWTON ST | NEWTON ST | 8844 | 8844 | 37.714550942 | -122.439056989 | ROLPH ST \ NEWTON ST | ROLPH ST \ NEWTON ST | 1710539427000 | MTA | STOP | NEWTON ST intersection | - | INSTALL IN STREET | - | - | - | - | - | 81896 | 991785600000 | -122.4391911 | 37.71469381 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571780000 | ROLPH ST | - | - | - | - | - | - |
| 64784 | N/A | Point | - | - | - | - | S108979 | 25TH ST: UTAH ST | - | F | F | - | F | 23722000 | 23722000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | UTAH ST | 25TH ST | 8932 | 8932 | 37.751861707 | -122.405079625 | 25TH ST \ UTAH ST | UTAH ST \ 25TH ST | 1734447450000 | middleware_editor | STOP | 25TH ST intersection | - | 0 / 0 | - | - | - | - | - | 81897 | 382147200000 | -122.4052077 | 37.75178695 | - | 1734358500000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570340000 | UTAH ST | - | - | - | - | - | - |
| 64785 | N/A | Point | - | - | - | - | S108980 | 25TH ST: UTAH ST | - | F | F | - | F | 23722000 | 23722000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | UTAH ST | 25TH ST | 8933 | 8933 | 37.751726509 | -122.405338457 | 25TH ST \ UTAH ST | UTAH ST \ 25TH ST | 1710539427000 | MTA | STOP | 25TH ST intersection | - | - | - | - | - | - | - | 81898 | 382147200000 | -122.4052077 | 37.75178695 | - | 1421884800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570340000 | UTAH ST | - | - | - | - | - | - |
| 64786 | N/A | Point | 1 | 1 | 3000 - 3049 | - | S114657 | 3000-3049 22ND ST | 3000-3049 22ND ST | F | F | - | F | 1187000 | 1187000 | - | - | SOUTH SIDE | - | - | - | - | FOLSOM ST | FOLSOM ST | 10960 | 10960 | 37.75566679 | -122.41493044 | - | - | 1755877454000 | middleware_editor | NPRK 9AM-11AM TUE STCL | FOLSOM ST to SHOTWELL ST (3000 - 3049) | - | 33' W OF FOLSOM | - | - | - | - | - | 81899 | 1012636800000 | -122.41493044 | 37.75566679 | - | 1713822300000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0308 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373572140000 | 22ND ST | 3000 - 3049 22ND ST | 3000 - 3049 22ND ST | 3000 22ND ST | - | SHOTWELL ST | SHOTWELL ST |
| 64787 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S115786 | 1600-1699 SHAFTER AVE | 1600-1699 SHAFTER AVE | F | F | - | F | 11787000 | 11787000 | - | - | NORTH SIDE | - | - | - | - | LANE ST | LANE ST | 10987 | 10987 | 37.73134035 | -122.39126212 | - | - | 1745363867000 | middleware_editor | PARK AT 90 DEGREES (SYM) | LANE ST to 03RD ST (1600 - 1699) | - | 50' EAST OF 3RD ST | - | - | - | - | - | 81900 | 1039248000000 | -122.39126212 | 37.73134035 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373572500000 | SHAFTER AVE | 1600 - 1699 SHAFTER AVE | 1600 - 1699 SHAFTER AVE | 1600 SHAFTER AVE | - | 03RD ST | 03RD ST |
| 64788 | N/A | Point | - | - | - | - | S129380 | LISBON ST: BRAZIL AVE | - | F | F | - | F | 21716000 | 21716000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | BRAZIL AVE | 22840 | 22840 | 37.723469101 | -122.432401662 | LISBON ST \ BRAZIL AVE | LISBON ST \ BRAZIL AVE | 1710539427000 | MTA | ALL WAY | BRAZIL AVE intersection | - | - | - | - | - | - | - | 81901 | 1215648000000 | -122.43243206 | 37.72354972 | - | 1541116800000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576760000 | LISBON ST | - | - | - | - | - | - |
| 64789 | N/A | Point | - | - | - | - | S131490 | GUTTENBERG ST: HANOVER ST | - | F | F | - | F | 21461000 | 21461000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HANOVER ST | HANOVER ST | 22870 | 22870 | 37.709395586 | -122.442623986 | GUTTENBERG ST \ HANOVER ST | GUTTENBERG ST \ HANOVER ST | 1710539427000 | MTA | STOP | HANOVER ST intersection | - | - | - | - | - | - | - | 81902 | 1251763200000 | -122.44266869 | 37.70932061 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373577420000 | GUTTENBERG ST | - | - | - | - | - | - |
| 64790 | N/A | Point | - | - | - | - | S135960 | GENEVA AVE: MISSION ST | - | F | F | - | F | 21486000 | 21486000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MISSION ST | GENEVA AVE | 24979 | 24979 | 37.716470866 | -122.440878297 | GENEVA AVE \ MISSION ST | MISSION ST \ GENEVA AVE | 1752677052000 | middleware_editor | S F BIKE ROUTE (RED SYM) 90 | GENEVA AVE intersection | - | - | - | - | - | - | - | 81903 | 1329379200000 | -122.44101956 | 37.71645955 | - | - | - | D11 | - | BIKE GUIDE | GUIDE | SG45R(90).0001 | 12X22 | SUP2 | LIGHT POLE | IS | 1373578800000 | MISSION ST | - | - | - | - | - | - |
| 64791 | N/A | Point | - | - | - | - | S135961 | GENEVA AVE: MISSION ST | - | F | F | - | F | 21486000 | 21486000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MISSION ST | GENEVA AVE | 24980 | 24980 | 37.716473695 | -122.440876509 | GENEVA AVE \ MISSION ST | MISSION ST \ GENEVA AVE | 1752776754000 | middleware_editor | S F BIKE ROUTE (RED SYM) 90 | GENEVA AVE intersection | - | - | - | - | - | - | - | 81904 | 1329379200000 | -122.44101956 | 37.71645955 | - | - | 1752774300000 | D11 | - | BIKE GUIDE | GUIDE | SG45R(90).0001 | 12X22 | SUP2 | SIGNAL POLE | RETD | 1373578800000 | MISSION ST | - | - | - | - | - | - |
| 64792 | N/A | Point | - | - | - | - | S134455 | BACON ST: BOWDOIN ST | - | F | F | - | F | 20911000 | 20911000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BACON ST | BOWDOIN ST | 25001 | 25001 | 37.725818798 | -122.410626661 | BOWDOIN ST \ BACON ST | BACON ST \ BOWDOIN ST | 1710539427000 | MTA | LEFT ARROW (SYM) | BOWDOIN ST intersection | - | (INSTALL SIGN AND 2IN POST 3FT. SOU..... | - | - | - | - | - | 81905 | 1307404800000 | -122.41051222 | 37.72582587 | - | - | - | D9 | - | OTHER WARNING | WARNING | W1-6.0002 | 36X18 | SUP2 | 2IN IRON POST | IS | 1373578320000 | BACON ST | - | - | - | - | - | - |
| 64793 | N/A | Point | 1 | 1 | 100 - 149 | - | S132117 | 100-149 ALBION ST | 100-149 ALBION ST | F | F | - | F | 2145000 | 2145000 | - | - | EAST SIDE | - | - | - | - | 16TH ST | 16TH ST | 25396 | 25396 | 37.764515379 | -122.422833809 | - | - | 1710539427000 | MTA | NPPZ DURING POSTED SERVICES | 16TH ST to CAMP ST (100 - 149) | - | 43FT NORTH OF 16TH ST | - | - | - | - | - | 81906 | 1268352000000 | -122.42281414 | 37.76444894 | - | - | - | D8 | - | OTHER REGULATORY | REG | R30(SF).0500 | 12X18 | SUP2 | 2IN IRON POST | IS | 1373577600000 | ALBION ST | 100 - 149 ALBION ST | 100 - 149 ALBION ST | 100 ALBION ST | - | CAMP ST | CAMP ST |
| 64794 | N/A | Point | - | - | - | - | S131727 | IRVING ST: 17TH AVE | - | F | F | - | F | 27360000 | 27360000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 17TH AVE | 17TH AVE | 25421 | 25421 | 37.763749794 | -122.474872538 | IRVING ST \ 17TH AVE | IRVING ST \ 17TH AVE | 1710539427000 | MTA | STOP | 17TH AVE intersection | - | - | - | - | - | - | - | 81907 | 1258502400000 | -122.47498519 | 37.76365579 | - | 1578355200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373577480000 | IRVING ST | - | - | - | - | - | - |
| 64795 | N/A | Point | - | - | - | - | S131728 | IRVING ST: 17TH AVE | - | F | F | - | F | 27360000 | 27360000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 17TH AVE | 17TH AVE | 25422 | 25422 | 37.763578042 | -122.475091584 | IRVING ST \ 17TH AVE | IRVING ST \ 17TH AVE | 1710539427000 | MTA | STOP | 17TH AVE intersection | - | - | - | - | - | - | - | 81908 | 1258502400000 | -122.47498519 | 37.76365579 | - | 1510617600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373577480000 | IRVING ST | - | - | - | - | - | - |
| 64796 | N/A | Point | 1 | 1 | 143 - 178 | - | S135978 | 143-178 YERBA BUENA AVE | 143-178 YERBA BUENA AVE | F | F | - | F | 13748000 | 13748000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SAN PABLO AVE | SAN PABLO AVE | 25569 | 25569 | 37.73606412 | -122.46164077 | - | - | 1710539427000 | MTA | SPEED HUMP | SAN PABLO AVE to MAYWOOD DR (143 - 178) | - | IFO#154 | - | - | - | - | - | 81909 | 1329782400000 | -122.46164077 | 37.73606412 | - | - | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1373578800000 | YERBA BUENA AVE | 143 - 178 YERBA BUENA AVE | 143 - 178 YERBA BUENA AVE | 143 YERBA BUENA AVE | - | MAYWOOD DR | MAYWOOD DR |
| 64797 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S135047 | 1100-1199 YORK ST | 1100-1199 YORK ST | F | F | - | F | 13772000 | 13772000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 23RD ST | 23RD ST | 25612 | 25612 | 37.753854105 | -122.408240399 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | 23RD ST to 24TH ST (1100 - 1199) | - | IFO #1115 | - | - | - | - | - | 81910 | 1317686400000 | -122.40826588 | 37.75365264 | - | - | - | D9 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1373578500000 | YORK ST | 1100 - 1199 YORK ST | 1100 - 1199 YORK ST | 1100 YORK ST | - | 24TH ST | 24TH ST |
| 64798 | N/A | Point | - | - | - | - | S131731 | 17TH AVE: IRVING ST | - | F | F | - | F | 27360000 | 27360000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 17TH AVE | 17TH AVE | 25705 | 25705 | 37.763766051 | -122.475071915 | IRVING ST \ 17TH AVE | IRVING ST \ 17TH AVE | 1710539427000 | MTA | ALL WAY | 17TH AVE intersection | - | - | - | - | - | - | - | 81911 | 1258502400000 | -122.47498519 | 37.76365579 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373577480000 | IRVING ST | - | - | - | - | - | - |
| 64799 | N/A | Point | - | - | - | - | S131733 | IRVING ST: 17TH AVE | - | F | F | - | F | 27360000 | 27360000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 17TH AVE | 17TH AVE | 25706 | 25706 | 37.763749794 | -122.474869855 | IRVING ST \ 17TH AVE | IRVING ST \ 17TH AVE | 1710539427000 | MTA | ALL WAY | 17TH AVE intersection | - | - | - | - | - | - | - | 81912 | 1258502400000 | -122.47498519 | 37.76365579 | - | 1578355200000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373577480000 | IRVING ST | - | - | - | - | - | - |
| 64800 | N/A | Point | - | - | - | - | S131734 | IRVING ST: 17TH AVE | - | F | F | - | F | 27360000 | 27360000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 17TH AVE | 17TH AVE | 25707 | 25707 | 37.763575921 | -122.475087114 | IRVING ST \ 17TH AVE | IRVING ST \ 17TH AVE | 1710539427000 | MTA | ALL WAY | 17TH AVE intersection | - | - | - | - | - | - | - | 81913 | 1258502400000 | -122.47498519 | 37.76365579 | - | 1573516800000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373577480000 | IRVING 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