Import ISO
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 103051 | N/A | Point | 1 | 1 | 100 - 199 | - | S272838 | 100-199 VIENNA ST | 100-199 VIENNA ST | F | F | - | F | 13298000 | 13298000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | PERU AVE | PERU AVE | 122112 | 122112 | 37.72592969 | -122.42632226 | - | - | 1739381061000 | middleware_editor | STOP AHEAD (SYM) | PERU AVE to AVALON AVE (100 - 199) | - | NPL 182 | - | - | - | - | - | 120342 | 1258502400000 | -122.42632226 | 37.72592969 | - | 1617148800000 | - | D11 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1614761940000 | VIENNA ST | 100 - 199 VIENNA ST | 100 - 199 VIENNA ST | 100 VIENNA ST | - | AVALON AVE | AVALON AVE |
| 103052 | N/A | Point | - | - | - | - | S224649 | MIDDLE POINT RD: CATALINA ST \ | - | F | F | - | F | 20172000 | 20172000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | CATALINA ST | CATALINA ST | 58808 | 58808 | 37.73627246 | -122.37941451 | MIDDLE POINT RD \ CATALINA ST | MIDDLE POINT RD \ CATALINA ST | 1710539427000 | MTA | STOP AHEAD (SYM) | CATALINA ST intersection | - | 200' N OF WEST PT./CROSS ST. IS CATALINA | - | - | - | - | - | 120343 | 1460126760000 | -122.37941451 | 37.73627246 | - | 1460073600000 | - | D10 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1460041560000 | MIDDLE POINT RD | - | - | - | - | - | - |
| 103053 | N/A | Point | - | - | - | - | S108773 | STEINER ST: CLAY ST | - | F | F | - | F | 26636000 | 26636000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | STEINER ST | CLAY ST | 111141 | 111141 | 37.7905018 | -122.43584896 | CLAY ST \ STEINER ST | STEINER ST \ CLAY ST | 1710539427000 | MTA | STOP | CLAY ST intersection | - | - | - | - | - | - | - | 120344 | 347500800000 | -122.43584896 | 37.7905018 | - | 1408492800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570280000 | STEINER ST | - | - | - | - | - | - |
| 103054 | N/A | Point | - | - | - | - | S126323 | CLAY ST: STEINER ST | - | F | F | - | F | 4113000 | 26636000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | STEINER ST | CLAY ST | 19139 | 19139 | 37.7905018 | -122.43584896 | - | STEINER ST \ CLAY ST | 1710539427000 | MTA | ALL WAY | CLAY ST intersection | - | - | - | - | - | - | - | 120345 | 1166140800000 | -122.43584896 | 37.7905018 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575800000 | STEINER ST | 2600 - 2699 CLAY ST | - | - | - | PIERCE ST | - |
| 103055 | N/A | Point | - | - | - | - | S126320 | STEINER ST: CLAY ST | - | F | F | - | F | 26636000 | 26636000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | STEINER ST | CLAY ST | 19137 | 19137 | 37.7905018 | -122.43584896 | CLAY ST \ STEINER ST | STEINER ST \ CLAY ST | 1710539427000 | MTA | ALL WAY | CLAY ST intersection | - | - | - | - | - | - | - | 120346 | 1166140800000 | -122.43584896 | 37.7905018 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575800000 | STEINER ST | - | - | - | - | - | - |
| 103056 | N/A | Point | - | - | - | - | S126321 | STEINER ST: CLAY ST | - | F | F | - | F | 26636000 | 26636000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | STEINER ST | CLAY ST | 128092 | 128092 | 37.7905018 | -122.43584896 | CLAY ST \ STEINER ST | STEINER ST \ CLAY ST | 1710539427000 | MTA | ALL WAY | CLAY ST intersection | - | - | - | - | - | - | - | 120347 | 1166140800000 | -122.43584896 | 37.7905018 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575800000 | STEINER ST | - | - | - | - | - | - |
| 103057 | N/A | Point | - | - | - | - | S248474 | CLAY ST: STEINER ST | - | F | F | - | F | 26636000 | 26636000 | - | - | NORTH WEST CORNER | - | - | - | - | STEINER ST | CLAY ST | 79696 | 79696 | 37.7905018 | -122.43584896 | CLAY ST \ STEINER ST | STEINER ST \ CLAY ST | 1710539427000 | MTA | CLAY ST | CLAY ST intersection | - | - | - | - | - | - | - | 120348 | 1539187020000 | -122.43584896 | 37.7905018 | - | - | - | D2 | - | STREET NAME | GUIDE | D3-1.0391 | 36X08 | SUP1 | LIGHT POLE | IS | 1537450140000 | STEINER ST | - | - | - | - | - | - |
| 103058 | N/A | Point | - | - | - | - | S248473 | CLAY ST: STEINER ST | - | F | F | - | F | 26636000 | 26636000 | - | - | NORTH WEST CORNER | - | - | - | - | STEINER ST | CLAY ST | 79695 | 79695 | 37.7905018 | -122.43584896 | CLAY ST \ STEINER ST | STEINER ST \ CLAY ST | 1710539427000 | MTA | STEINER ST | CLAY ST intersection | - | - | - | - | - | - | - | 120349 | 1539186780000 | -122.43584896 | 37.7905018 | - | - | - | D2 | - | STREET NAME | GUIDE | D3-1.1669 | 36X08 | SUP1 | LIGHT POLE | IS | 1537450080000 | STEINER ST | - | - | - | - | - | - |
| 103059 | N/A | Point | 1 | 1 | 600 - 699 | RIGHT ARROW | S260086 | 600-699 STEVENSON ST | 600-699 ODD FELLOWS WAY | F | F | - | F | 12172000 | 12172000 | - | - | NORTH SIDE | - | - | - | - | 7TH ST \ STEVENSON ST | 07TH ST \ STEVENSON ST | 114534 | 114534 | 37.77948434 | -122.41259035 | - | - | 1710539427000 | MTA | TA (SYM) PLO 6AM-12MN DAILY (5 MIN)/ TANS ALL OTHER TIMES | 07TH ST \ STEVENSON ST to END: 600-699 BLOCK (600 - 699) | - | 322' WEST OF 7TH ST. | - | - | - | - | - | 120350 | 1262131200000 | -122.41259035 | 37.77948434 | - | 1578355200000 | - | D6 | - | OTHER REGULATORY | REG | R37(SF).0403 | 18X24 | SUP1 | 2IN IRON POST | IS | 1578048240000 | ODD FELLOWS WAY | 600 - 699 ODD FELLOWS WAY | 600 - 699 ODD FELLOWS WAY | 600 ODD FELLOWS WAY | - | END: 600-699 BLOCK | END: 600-699 BLOCK |
| 103060 | N/A | Point | - | - | - | - | S110236 | BRODERICK ST: PAGE ST | - | F | F | - | F | 26035000 | 26035000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BRODERICK ST | PAGE ST | 7867 | 7867 | 37.77199042 | -122.4388991 | PAGE ST \ BRODERICK ST | BRODERICK ST \ PAGE ST | 1710539427000 | MTA | STOP | PAGE ST intersection | - | 10N / OF CORNER | - | - | - | - | - | 120351 | 607737600000 | -122.4388991 | 37.77199042 | - | 1585872000000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570760000 | BRODERICK ST | - | - | - | - | - | - |
| 103061 | N/A | Point | - | - | - | - | S108301 | PAGE ST: BRODERICK ST | - | F | F | - | F | 26035000 | 26035000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BRODERICK ST | PAGE ST | 5260 | 5260 | 37.77199042 | -122.4388991 | PAGE ST \ BRODERICK ST | BRODERICK ST \ PAGE ST | 1710539427000 | MTA | STOP | PAGE ST intersection | - | 0 / 0 | - | - | - | - | - | 120352 | 298080000000 | -122.4388991 | 37.77199042 | - | 788054400000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570160000 | BRODERICK ST | - | - | - | - | - | - |
| 103062 | N/A | Point | - | - | - | - | S130731 | MISSION ST: 5TH ST | - | T | T | - | F | - | 24634000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | - | 05TH ST | 27314 | 27314 | 37.78273164 | -122.4064794 | - | MISSION ST \ 05TH ST | 1710539427000 | MTA | CENTER LANE/BUSES TAXIS ONLY 7AM-6PM MON-FRI | 05TH ST intersection | - | - | - | - | - | - | - | 120353 | 1242086400000 | -122.4064794 | 37.78273164 | - | - | - | D6 | - | OTHER REGULATORY | REG | R(SF).0031 | 30X42 | SUP1 | OVERHEAD MAST ARM | IS | 1373577180000 | MISSION ST | - | - | - | - | - | - |
| 103063 | N/A | Point | - | - | - | - | S269375 | MISSION ST: 5TH ST | - | T | T | - | F | - | 24634000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | - | 05TH ST | 91938 | 91938 | 37.78273164 | -122.4064794 | - | MISSION ST \ 05TH ST | 1710539427000 | MTA | CENTER LANE/BUSES TAXIS ONLY AT ALL TIMES | 05TH ST intersection | - | - | - | - | - | - | - | 120354 | 1242086400000 | -122.4064794 | 37.78273164 | - | 1607299200000 | - | D6 | - | OTHER REGULATORY | REG | R(SF).0032 | 30X42 | SUP1 | OVERHEAD MAST ARM | IS | 1603194240000 | MISSION ST | - | - | - | - | - | - |
| 103064 | N/A | Point | - | - | - | - | S130670 | MISSION ST: 5TH ST | - | T | T | - | F | 24634000 | 24634000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MISSION ST | 05TH ST | 24034 | 24034 | 37.78273164 | -122.4064794 | 05TH ST \ MISSION ST | MISSION ST \ 05TH ST | 1710539427000 | MTA | RIGHT LANE BUSES TAXIS ONLY 4PM-6PM MON-FRI | 05TH ST intersection | - | - | - | - | - | - | - | 120355 | 1241049600000 | -122.4064794 | 37.78273164 | - | 1453507200000 | - | D6 | - | TRANSIT ONLY(RIGHT LANE) | REG | SR60-3(CA).0005 | 30X42 | SUP1 | OVERHEAD MAST ARM | IS | 1373577120000 | MISSION ST | - | - | - | - | - | - |
| 103065 | N/A | Point | - | - | - | INBOUND | S240771 | MISSION ST: 5TH ST | - | F | F | - | F | - | 24634000 | - | - | SOUTH SIDE | - | - | - | - | - | 05TH ST | 83150 | 83150 | 37.78273164 | -122.4064794 | - | MISSION ST \ 05TH ST | 1710539427000 | MTA | BIKE RACK RAPID | 05TH ST intersection | 15535 | INFO 925 | - | - | - | - | - | 120356 | 1518100920000 | -122.4064794 | 37.78273164 | - | 1518048000000 | - | D6 | - | BIKE RACK | REG | R(SF).0353 | 02X36 | SUP1 | BIKE RACK | IS | 1511291700000 | MISSION ST | - | - | - | - | - | - |
| 103066 | N/A | Point | - | - | - | INBOUND | S240796 | MISSION ST: 5TH ST | - | F | F | - | F | - | 24634000 | - | - | SOUTH SIDE | - | - | - | - | - | 05TH ST | 112608 | 112608 | 37.78273164 | -122.4064794 | - | MISSION ST \ 05TH ST | 1710539427000 | MTA | SOLAR LANTERN WHITE (V5) | 05TH ST intersection | 15535 | 5 FT WEST OF 5TH ST | - | - | - | - | - | 120357 | 1517904360000 | -122.4064794 | 37.78273164 | - | 1517875200000 | - | D6 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | UNISTRUT | IS | 1511291820000 | MISSION ST | - | - | - | - | - | - |
| 103067 | N/A | Point | - | - | - | - | S258834 | 5TH ST: MISSION ST | - | F | F | - | F | - | 24634000 | - | - | SOUTH WEST CORNER | - | - | - | - | - | 05TH ST | 89249 | 89249 | 37.78273164 | -122.4064794 | - | MISSION ST \ 05TH ST | 1710539427000 | MTA | TANP 7AM-7PM EVERYDAY | 05TH ST intersection | - | - | - | - | - | - | - | 120358 | 1325721600000 | -122.4064794 | 37.78273164 | - | - | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0027 | 18X21 | SUP1 | LIGHT POLE | IS | 1572430380000 | MISSION ST | - | - | - | - | - | - |
| 103068 | N/A | Point | - | - | - | - | 23375 | - | - | - | - | - | - | 25564000 | - | - | - | - | 1692660593000 | wdwilli | - | - | POLK ST | - | 150529 | 150529 | 37.799660998583 | -122.422407677877 | FILBERT ST \ POLK ST | - | 1714417340000 | middleware_editor | TOUR BUSES & VANS (SEAT CAP 8 OR MORE PASSGRS) PROHIBITED | - | - | SEC | - | - | - | - | - | 120359 | - | - | - | - | 1714392000000 | - | 03 | - | OTHER REGULATORY | REG | R(SF).0272 | 36X30 | SUP1 | 2IN IRON POST | IS | - | FILBERT ST | - | - | - | - | - | - |
| 103069 | N/A | Point | - | - | - | - | 23376 | - | - | - | - | - | - | 25564000 | - | - | - | - | 1692660682000 | wdwilli | - | - | POLK ST | - | 150514 | 150514 | 37.7996588792124 | -122.422407677877 | FILBERT ST \ POLK ST | - | 1716471996000 | middleware_editor | TOUR BUSES & VANS (SEAT CAP 8 OR MORE PASSGRS) PROHIBITED | - | - | SWC | - | - | - | - | - | 120360 | - | - | - | - | - | - | 03 | - | OTHER REGULATORY | REG | R(SF).0272 | 36X30 | SUP1 | 2IN IRON POST | PI | - | FILBERT ST | - | - | - | - | - | - |
| 103070 | N/A | Point | - | - | - | - | S218758 | 6TH ST: HARRISON ST | - | F | F | - | F | 23919000 | 23919000 | - | - | EAST SIDE | - | - | - | - | 6TH ST | 06TH ST | 56439 | 56439 | 37.7772727 | -122.40407026 | HARRISON ST \ 6TH ST | HARRISON ST \ 06TH ST | 1710539427000 | MTA | BIKE RACK | 06TH ST intersection | 20154237 | 20FT. SOUTH OF NPL# 451 | - | - | - | - | - | 120361 | 1444122240000 | -122.40407026 | 37.7772727 | - | 1444089600000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1440425220000 | HARRISON ST | - | - | - | - | - | - |
| 103071 | N/A | Point | - | - | - | - | S112027 | HARRISON ST: 6TH ST | - | F | F | - | F | 23919000 | 23919000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | HARRISON ST | 06TH ST | 12143 | 12143 | 37.7772727 | -122.40407026 | 06TH ST \ HARRISON ST | HARRISON ST \ 06TH ST | 1742930757000 | middleware_editor | ONE WAY (LA) | 06TH ST intersection | - | - | - | - | - | - | - | 120362 | 900658800000 | -122.40407026 | 37.7772727 | - | 1742919600000 | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373571300000 | HARRISON ST | - | - | - | - | - | - |
| 103072 | N/A | Point | - | - | - | - | 25210 | - | - | F | T | - | F | 8048102 | - | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1699378933000 | jsanfel | - | - | STATE DR | - | 167735 | 167735 | 37.725034080189 | -122.484494197654 | - | - | 1722531702000 | middleware_editor | YIELD HERE TO PED (SYM) (RA) | - | - | NE CORNER | - | - | - | - | - | 120363 | - | - | - | - | - | - | 07 | - | PEDESTRIAN | REG | R10-15.0003 | 30X30 | SUP3 | SIGNAL POLE | IS | - | LAKE MERCED BLVD | 700 - 710 LAKE MERCED BLVD | - | - | - | STATE DR | - |
| 103073 | N/A | Point | - | - | - | - | S205535 | MINNA ST: NEW MONTGOMERY ST | - | F | F | - | F | 24599000 | 24599000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MINNA ST | MINNA ST | 47615 | 47615 | 37.78701079 | -122.39997496 | NEW MONTGOMERY ST \ MINNA ST | NEW MONTGOMERY ST \ MINNA ST | 1710539427000 | MTA | ONE WAY (LA) | MINNA ST intersection | - | - | - | - | - | - | - | 120364 | 247276800000 | -122.39997496 | 37.78701079 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1399467540000 | NEW MONTGOMERY ST | - | - | - | - | - | - |
| 103074 | N/A | Point | - | - | - | - | S203829 | AVILA ST: CAPRA WAY | - | F | F | - | F | 26983000 | 26983000 | - | - | NORTH EAST CORNER | - | - | - | - | CAPRA WAY | AVILA ST | 46835 | 46835 | 37.80261861 | -122.44078007 | AVILA ST \ CAPRA WAY | CAPRA WAY \ AVILA ST | 1710539427000 | MTA | AVILA ST | AVILA ST intersection | - | 0/0 | - | - | - | - | - | 120365 | - | -122.44078007 | 37.80261861 | - | - | - | D2 | - | STREET NAME | GUIDE | D3-1.0150 | 36X08 | SUP1 | 3IN IRON POST | IS | 1394658060000 | CAPRA WAY | - | - | - | - | - | - |
| 103075 | N/A | Point | - | - | - | - | S105179 | AVILA ST: CAPRA WAY | - | F | F | - | F | 26983000 | 26983000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CAPRA WAY | AVILA ST | 2488 | 2488 | 37.80261861 | -122.44078007 | AVILA ST \ CAPRA WAY | CAPRA WAY \ AVILA ST | 1710539427000 | MTA | STOP | AVILA ST intersection | - | 0 / 0 | - | - | - | - | - | 120366 | 57456000000 | -122.44078007 | 37.80261861 | - | 1600905600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569140000 | CAPRA WAY | - | - | - | - | - | - |
| 103076 | N/A | Point | - | - | - | - | 24182 | - | - | F | F | - | F | 26983000 | - | - | - | NORTH EAST CORNER | 1695409333000 | elclark | - | - | CAPRA WAY | - | 156918 | 156918 | 37.8026828389334 | -122.440708167846 | AVILA ST \ CAPRA WAY | - | 1722531702000 | middleware_editor | ALL WAY | - | - | NEC ON CAPRA | - | - | - | - | - | 120367 | - | - | - | - | - | - | 02 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | - | CAPRA WAY | - | - | - | - | - | - |
| 103077 | N/A | Point | - | - | - | - | S278707 | 151-199 HUNTERS POINT EXPY | - | F | F | - | F | 7097000 | 7097000 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | - | - | 124123 | 124123 | 37.7109013 | -122.38169833 | - | - | 1710539427000 | MTA | OBJECT MARKER - RED | - | - | SOUTH SIDE OF STATE REC PRK AREA ENTRANC | - | - | - | - | - | 120368 | 1636675200000 | -122.38169833 | 37.7109013 | - | - | - | D10 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP1 | K-RAIL BARRICADE | IS | 1636451820000 | HUNTERS POINT EXPY | 151-199 HUNTERS POINT EXPY | HUNTERS POINT EXPY | - | - | - | - |
| 103078 | N/A | Point | - | - | - | - | 21465 | - | - | - | - | - | - | 33047000 | - | - | - | - | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | CONNECTICUT ST | - | 143779 | 143779 | 37.757373377 | -122.397010785 | 22ND ST \ CONNECTICUT ST | - | 1722531702000 | middleware_editor | OBJECT MARKER - RED | - | - | SOUTH TERMINUS , MINI PARK PARKING AREA | - | - | - | - | - | 120369 | - | - | - | - | - | - | 10 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP1 | 2IN IRON POST | IS | - | 22ND ST | - | - | - | - | - | - |
| 103079 | N/A | Point | - | - | - | - | S219538 | QUINTARA ST: 15TH AVE \ FANNIN | - | F | F | - | F | 23189000 | 23189000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | FANNING WAY \ QUINTARA ST | FANNING WAY \ QUINTARA ST | 58480 | 58480 | 37.74883627 | -122.47174916 | 15TH AVE \ FANNING WAY \ QUINTARA ST | 15TH AVE \ FANNING WAY \ QUINTARA ST | 1717724917000 | middleware_editor | OBJECT MARKER - RED | FANNING WAY \ QUINTARA ST intersection | - | - | - | - | - | - | - | 120370 | - | -122.47174916 | 37.74883627 | - | - | - | D7 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1443186480000 | 15TH AVE | - | - | - | - | - | - |
| 103080 | N/A | Point | 1 | 1 | 1 - 99 | - | S262927 | 1-99 MONTCLAIR TER | 1-99 MONTCLAIR TER | F | F | - | F | 9264000 | 9264000 | - | - | NORTH SIDE, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | LOMBARD ST | LOMBARD ST | 97575 | 97575 | 37.80245378 | -122.41895683 | - | - | 1710539427000 | MTA | OBJECT MARKER - RED | LOMBARD ST to END: 1-99 BLOCK (1 - 99) | - | AT THE END OF BLOCK DEAD END | - | - | - | - | - | 120371 | 1587397500000 | -122.41895683 | 37.80245378 | - | - | - | D2 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP1 | 3IN IRON POST | IS | 1585658580000 | MONTCLAIR TER | 1 - 99 MONTCLAIR TER | 1 - 99 MONTCLAIR TER | 1 MONTCLAIR TER | - | END: 1-99 BLOCK | END: 1-99 BLOCK |
| 103081 | N/A | Point | - | - | - | - | S278708 | 151-199 HUNTERS POINT EXPY | - | F | F | - | F | 7097000 | 7097000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | - | - | 124124 | 124124 | 37.7109013 | -122.38169833 | - | - | 1710539427000 | MTA | OBJECT MARKER - RED | - | - | SOUTH SIDE OF STATE REC PRK AREA ENTRANC | - | - | - | - | - | 120372 | 1636675200000 | -122.38169833 | 37.7109013 | - | - | - | D10 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP1 | K-RAIL BARRICADE | IS | 1636451880000 | HUNTERS POINT EXPY | 151-199 HUNTERS POINT EXPY | HUNTERS POINT EXPY | - | - | - | - |
| 103082 | N/A | Point | 1 | 1 | 1 - 299 | - | S135789 | 1-99 HARBOR RD | 1-299 HARBOR RD | F | F | - | F | 6671000 | 6671000 | - | - | UNKNOWN | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | NORTHRIDGE RD | NORTHRIDGE RD | 28743 | 28743 | 37.73232349 | -122.37835407 | - | - | 1710539427000 | MTA | OBJECT MARKER - RED | NORTHRIDGE RD to INGALLS ST (1 - 299) | - | 0 / INSTALL SIGN ON K-RAIL IFO# 54-..... | - | - | - | - | - | 120373 | 1326844800000 | -122.37835407 | 37.73232349 | - | - | - | D10 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373578740000 | HARBOR RD | 1 - 299 HARBOR RD | 1 - 299 HARBOR RD | 1 HARBOR RD | - | INGALLS ST | INGALLS ST |
| 103083 | N/A | Point | 1 | 1 | 1148 - 1169 | - | S270498 | 1148 - 1169 CHESTNUT ST | 1148-1169 CHESTNUT ST | F | F | - | F | 3967000 | 3967000 | - | - | WEST SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | CULEBRA TER | CULEBRA TER | 90929 | 90929 | 37.80257628 | -122.42240989 | - | - | 1753210382000 | mmadsen | OBJECT MARKER - YELLOW | CULEBRA TER to CULEBRA TER (1148 - 1169) | - | 15' N OF STAIRWAY | - | - | - | - | - | 120374 | - | -122.42240989 | 37.80257628 | - | 1666569600000 | - | D2 | - | OTHER WARNING | WARNING | TYPE-N(CA).0005 | 24X24 | SUP1 | RETAINING WALL | IS | 1606737120000 | CHESTNUT ST | 1148 - 1169 CHESTNUT ST | 1148 - 1169 CHESTNUT ST | 1148 CHESTNUT ST | - | CULEBRA TER | CULEBRA TER |
| 103084 | N/A | Point | 1 | 1 | 600 - 699 | - | S205470 | 600-699 39TH AVE | 600-699 39TH AVE | F | F | - | F | 1866000 | 1866000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | ANZA ST | ANZA ST | 47174 | 47174 | 37.7765501 | -122.49952269 | - | - | 1730753686000 | middleware_editor | OBJECT MARKER - YELLOW | ANZA ST to BALBOA ST (600 - 699) | - | OPP#695 | - | - | - | - | - | 120375 | - | -122.49952269 | 37.7765501 | - | 1730444160000 | - | D1 | - | OTHER WARNING | WARNING | TYPE-N(CA).0005 | 24X24 | SUP2 | 2IN IRON POST | IS | 1399382520000 | 39TH AVE | 600 - 699 39TH AVE | 600 - 699 39TH AVE | 600 39TH AVE | - | BALBOA ST | BALBOA ST |
| 103085 | N/A | Point | 1 | 1 | 600 - 699 | - | S206959 | 600-699 39TH AVE | 600-699 39TH AVE | F | F | - | F | 27889000 | 1866000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | 39TH AVE | ANZA ST | 47596 | 47596 | 37.7765501 | -122.49952269 | ANZA ST \ 39TH AVE | - | 1730753637000 | middleware_editor | OBJECT MARKER - YELLOW | ANZA ST to BALBOA ST (600 - 699) | - | OPP#603 39TH AVE. | - | - | - | - | - | 120376 | - | -122.49952269 | 37.7765501 | - | 1730444040000 | - | D1 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP2 | 2IN IRON POST | IS | 1403018280000 | 39TH AVE | - | 600 - 699 39TH AVE | 600 39TH AVE | - | - | BALBOA ST |
| 103086 | N/A | Point | 1 | 1 | 4100 - 4149 | - | S212160 | 4100-4149 20TH ST | 4100-4149 20TH ST | F | F | - | F | 1065000 | 1065000 | - | - | EAST LINE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | NOE ST | NOE ST | 51603 | 51603 | 37.75778702 | -122.43303763 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | NOE ST to HARTFORD ST (4100 - 4149) | - | INTERSECTION 20TH ST @ NOE BEHIND WALL | - | - | - | - | - | 120377 | - | -122.43303763 | 37.75778702 | - | - | - | D8 | - | OTHER WARNING | WARNING | TYPE-N(CA).0005 | 24X24 | SUP2 | 4X4 WOOD POST | IS | 1419937800000 | 20TH ST | 4100 - 4149 20TH ST | 4100 - 4149 20TH ST | 4100 20TH ST | - | HARTFORD ST | HARTFORD ST |
| 103087 | N/A | Point | 1 | 1 | 200 - 233 | - | S242372 | 200-237 JUSTIN DR | 200-233 JUSTIN DR | F | F | - | F | 7721000 | 7721000 | - | - | CENTER ISLAND | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | BENTON AVE | BENTON AVE | 126765 | 126765 | 37.73295505 | -122.42185249 | - | - | 1715879665000 | middleware_editor | OBJECT MARKER - YELLOW | BENTON AVE to JUSTIN DR (200 - 233) | - | OPP.#245 | - | - | - | - | - | 120378 | - | -122.42185249 | 37.73295505 | - | - | - | D9 | - | OTHER WARNING | WARNING | TYPE-N(CA).0005 | 24X24 | SUP2 | 2IN IRON POST | IS | 1516273560000 | JUSTIN DR | 200 - 233 JUSTIN DR | 200 - 233 JUSTIN DR | 200 JUSTIN DR | - | JUSTIN DR | JUSTIN DR |
| 103088 | N/A | Point | - | - | - | - | S240719 | SAN JOSE AVE: NAGLEE AVE | - | F | F | - | F | 33459000 | 33459000 | - | - | SOUTH EAST CORNER | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | SAN JOSE AVE | NAGLEE AVE | 75318 | 75318 | 37.71549351 | -122.45095625 | NAGLEE AVE \ SAN JOSE AVE | SAN JOSE AVE \ NAGLEE AVE | 1748447497000 | middleware_editor | OBJECT MARKER - YELLOW | NAGLEE AVE intersection | - | - | - | - | - | - | - | 120379 | - | -122.45095625 | 37.71549351 | - | - | - | D11 | - | OTHER WARNING | WARNING | TYPE-N(CA).0005 | 24X24 | SUP2 | 2IN IRON POST | IS | 1511252520000 | SAN JOSE AVE | - | - | - | - | - | - |
| 103089 | N/A | Point | - | - | - | - | S257651 | CROSSOVER DR: TRANSVERSE DR | - | F | F | - | F | 32864000 | 32864000 | - | - | CENTER ISLAND, W LINE, WESTBOUND | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | CROSSOVER DR | CROSSOVER DR | 88374 | 88374 | 37.771888 | -122.48178536 | TRANSVERSE DR \ CROSSOVER DR | TRANSVERSE DR \ CROSSOVER DR | 1710539427000 | MTA | OBJECT MARKER - YELLOW | CROSSOVER DR intersection | - | TIP OF ISLAND | - | - | - | - | - | 120380 | 1598877360000 | -122.48178536 | 37.771888 | - | - | - | 01 | - | OTHER WARNING | WARNING | TYPE-N(CA).0005 | 24X24 | SUP2 | 2IN IRON POST | IS | 1568113920000 | TRANSVERSE DR | - | - | - | - | - | - |
| 103090 | N/A | Point | - | 1 | 2600 - 2699 | - | S211622 | 2600-2699 EL CAMINO DEL MAR | 2600-2699 EL CAMINO DEL MAR | F | F | - | F | 28014000 | 19092000 | - | - | WEST SIDE, WESTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | SEAL ROCK DR | SEAL ROCK DR | 93341 | 93341 | 37.780738368766 | -122.509989291424 | EL CAMINO DEL MAR \ SEAL ROCK DR | - | 1745860457000 | jsanfel | OBJECT MARKER - YELLOW | SEAL ROCK DR to 48TH AVE \ POINT LOBOS AVE (2600 - 2699) | - | OPP #192 SEAL ROCK | - | - | - | - | - | 120381 | 976089600000 | -122.50964565 | 37.78024279 | - | 1637740800000 | - | D1 | - | OTHER WARNING | WARNING | TYPE-N(CA).0005 | 24X24 | SUP2 | 2IN IRON POST | IS | 1418212380000 | EL CAMINO DEL MAR | - | 2600 - 2699 EL CAMINO DEL MAR | 2600 EL CAMINO DEL MAR | - | - | 48TH AVE \ POINT LOBOS AVE |
| 103091 | N/A | Point | 1 | 1 | 545 - 575 | - | S135691 | 545-575 2ND ST | 545-575 02ND ST | F | F | - | F | 145000 | 145000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | SOUTH PARK | SOUTH PARK | 28905 | 28905 | 37.78236558 | -122.39272713 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | SOUTH PARK to DE BOOM ST (545 - 575) | - | N-LINE / @ PM IN PAINTED CENTER ISL..... | - | - | - | - | - | 120382 | 1325635200000 | -122.39272713 | 37.78236558 | - | - | - | D6 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP1 | 2IN IRON POST | IS | 1373578680000 | 02ND ST | 545 - 575 2ND ST | 545 - 575 02ND ST | 545 2ND ST | - | DE BOOM ST | DE BOOM ST |
| 103092 | N/A | Point | - | - | - | - | S129193 | FOLSOM ST: 3RD ST | - | F | F | - | F | 24583000 | 24583000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | 3RD ST | 03RD ST | 22768 | 22768 | 37.78378493 | -122.39893033 | FOLSOM ST \ 3RD ST | FOLSOM ST \ 03RD ST | 1710539427000 | MTA | (45 LA-DN/45 RA-DN) (SYM) | 03RD ST intersection | - | - | - | - | - | - | - | 120383 | 1212019200000 | -122.39893033 | 37.78378493 | - | 1555632000000 | - | D6 | - | OTHER WARNING | WARNING | W12-1.0001 | 24X24 | SUP1 | 2IN IRON POST | IS | 1373576700000 | FOLSOM ST | - | - | - | - | - | - |
| 103093 | N/A | Point | - | - | - | - | S244636 | STOCKTON ST: BUSH ST | - | F | F | - | F | 24911000 | 24911000 | - | - | WEST SIDE | - | - | - | - | STOCKTON ST | BUSH ST | 84707 | 84707 | 37.79036847 | -122.40713172 | BUSH ST \ STOCKTON ST | STOCKTON ST \ BUSH ST | 1710539427000 | MTA | NPRK 6AM-8AM TUE STCL | BUSH ST intersection | - | 64 FT. NORTH OF BUSH | - | - | - | - | - | 120384 | - | -122.40713172 | 37.79036847 | - | 1697455800000 | - | D3 | - | STREET CLEANING | REG | R30B(CA).0191 | 18X18 | SUP1 | 2IN IRON POST | IS | 1523443500000 | STOCKTON ST | - | - | - | - | - | - |
| 103094 | N/A | Point | 1 | 1 | 100 - 164 | LEFT ARROW | S234867 | 0-199 SOUTH PARK | 100-164 SOUTH PARK | F | F | - | F | 12009102 | 12009102 | R26K(CA).0038-2017-05-08 13: 19: 00-37.78137976--122.39445288 | - | CENTER ISLAND | - | - | - | - | JACK LONDON ALY | JACK LONDON ALY | 68590 | 68590 | 37.78137976 | -122.39445288 | - | - | 1710539427000 | MTA | TANP ANY TIME | JACK LONDON ALY to SOUTH PARK (100 - 164) -- NORTH -- | - | OPP #171 | - | - | - | - | - | 120385 | 1494249540000 | -122.39445288 | 37.78137976 | - | 1494201600000 | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | 2IN IRON POST | IS | 1491307020000 | SOUTH PARK | 100 - 164 SOUTH PARK | 100 - 164 SOUTH PARK | 100 SOUTH PARK | - | SOUTH PARK | SOUTH PARK |
| 103095 | N/A | Point | - | - | - | - | S211655 | MARINA BLVD: AVILA ST \ CASA W | - | F | F | - | F | 26799000 | 26799000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CASA WAY \ MARINA BLVD | AVILA ST \ CASA WAY | 53038 | 53038 | 37.8060772 | -122.43999932 | AVILA ST \ CASA WAY \ MARINA BLVD | MARINA BLVD \ AVILA ST \ CASA WAY | 1710539427000 | MTA | STOP | AVILA ST \ CASA WAY intersection | - | - | - | - | - | - | - | 120386 | 1603447200000 | -122.43999932 | 37.8060772 | - | 1695643200000 | - | D2 | - | STOP | REG | R1-1.0004 | 48X48 | SUP1 | 2IN IRON POST | IS | 1418294340000 | MARINA BLVD | - | - | - | - | - | - |
| 103096 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S249098 | 1700-1799 PINE ST | 1700-1799 PINE ST | F | F | - | F | 10479000 | 10479000 | - | - | SOUTH SIDE | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 85160 | 85160 | 37.78909892 | -122.42460203 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7PM-9PM EVERYDAY (5 MIN) | FRANKLIN ST to GOUGH ST (1700 - 1799) | - | 24FT WEST OF FRANKLIN | - | - | - | - | - | 120387 | 1540995060000 | -122.42460203 | 37.78909892 | - | - | 1695900600000 | D2 | - | OTHER REGULATORY | REG | R38(SF)1.0153 | 14X21 | SUP1 | 2IN IRON POST | RETD | 1540292640000 | PINE ST | 1700 - 1799 PINE ST | 1700 - 1799 PINE ST | 1700 PINE ST | - | GOUGH ST | GOUGH ST |
| 103097 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S228747 | 1600-1699 WALLACE AVE | 1600-1699 WALLACE AVE | F | F | - | F | 13357000 | 13357000 | - | - | NORTH SIDE | - | - | - | - | KEITH ST | KEITH ST | 63498 | 63498 | 37.72798297 | -122.39200352 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM MON STCL | KEITH ST to 03RD ST \ LANE ST (1600 - 1699) | - | IFO# 1674 | - | - | - | - | - | 120388 | - | -122.39200352 | 37.72798297 | - | 1695369240000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0078 | 18X18 | SUP1 | 2IN IRON POST | IS | 1473321840000 | WALLACE AVE | 1600 - 1699 WALLACE AVE | 1600 - 1699 WALLACE AVE | 1600 WALLACE AVE | - | 03RD ST \ LANE ST | 03RD ST \ LANE ST |
| 103098 | N/A | Point | - | - | - | - | 24224 | - | - | F | F | - | F | 10573000 | - | - | - | EAST SIDE | 1695677968000 | APADILLA | - | - | WASHINGTON ST | - | 157227 | 157227 | 37.7937018660695 | -122.421241417303 | - | - | 1710539427000 | MTA | MISCELLANEOUS SIGNS | - | - | SPL #1820 | - | - | - | - | 5 | 120389 | - | - | - | - | - | 1695808800000 | 03 | - | OTHER GUIDE | GUIDE | G-M(SF).0038 | N/A | SUP1 | 2IN IRON POST | RETD | - | POLK ST | 1800 - 1899 POLK ST | - | - | - | JACKSON ST | - |
| 103099 | N/A | Point | - | - | - | - | 24144 | - | - | F | T | - | F | 24748000 | - | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | 1695338019000 | wdwilli | - | - | KEARNY ST | - | 156787 | 156787 | 37.7927527603096 | -122.404357883145 | CALIFORNIA ST \ KEARNY ST | - | 1721160323000 | middleware_editor | CALIFORNIA ST | - | - | <-- 600 | - | - | - | - | - | 120390 | - | - | - | - | - | - | 03 | - | STREET NAME | GUIDE | D3-1.0300 | 36X08 | SUP1 | SIGNAL POLE | PI | - | CALIFORNIA ST | - | - | - | - | - | - |
| 103100 | N/A | Point | - | - | - | - | S273528 | JONES ST: OFARRELL ST | - | T | T | - | F | 24945000 | 24945000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OFARRELL ST | JONES ST | 122912 | 122912 | 37.78578959 | -122.41296967 | JONES ST \ OFARRELL ST | OFARRELL ST \ JONES ST | 1710539427000 | MTA | JONES ST | JONES ST intersection | - | - | - | - | - | - | - | 120391 | - | -122.41296967 | 37.78578959 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-2.0204 | 72X18 | SUP1 | LIGHT POLE | IS | 1616583180000 | OFARRELL ST | - | - | - | - | - | - |
| 103101 | N/A | Point | - | - | - | - | S271901 | GEARY ST: HYDE ST | - | T | T | - | F | 25166000 | 25166000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HYDE ST | GEARY ST | 108504 | 108504 | 37.78631022 | -122.41644912 | GEARY ST \ HYDE ST | HYDE ST \ GEARY ST | 1710539427000 | MTA | SPEED LIMIT 20 | GEARY ST intersection | - | - | - | - | - | - | - | 120392 | 1126656000000 | -122.41644912 | 37.78631022 | - | 1622160000000 | - | D6 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1611745080000 | HYDE ST | - | - | - | - | - | - |
| 103102 | N/A | Point | - | - | - | - | S273527 | JONES ST: OFARRELL ST | - | T | T | - | F | 24945000 | 24945000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OFARRELL ST | JONES ST | 122911 | 122911 | 37.78578959 | -122.41296967 | JONES ST \ OFARRELL ST | OFARRELL ST \ JONES ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | JONES ST intersection | - | - | - | - | - | - | - | 120393 | 1619620020000 | -122.41296967 | 37.78578959 | - | - | - | D6 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | 1616582400000 | OFARRELL ST | - | - | - | - | - | - |
| 103103 | N/A | Point | - | - | - | - | S271849 | HYDE ST: GEARY ST | - | T | T | - | F | 25166000 | 25166000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HYDE ST | GEARY ST | 95319 | 95319 | 37.78631022 | -122.41644912 | GEARY ST \ HYDE ST | HYDE ST \ GEARY ST | 1710539427000 | MTA | (LA) TURNING VEHICLES YIELD(SYM) TO PED(SYM) | GEARY ST intersection | - | - | - | - | - | - | - | 120394 | 1288224000000 | -122.41644912 | 37.78631022 | - | - | - | D6 | - | OTHER REGULATORY | REG | R10-15.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1611658440000 | HYDE ST | - | - | - | - | - | - |
| 103104 | N/A | Point | - | - | - | - | S261447 | BUSH ST: GRANT AVE | - | F | T | - | F | 24741000 | 24741000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GRANT AVE | BUSH ST | 111844 | 111844 | 37.79056524 | -122.40557375 | BUSH ST \ GRANT AVE | GRANT AVE \ BUSH ST | 1720559360000 | middleware_editor | SPEED LIMIT 25 | BUSH ST intersection | - | - | - | - | - | - | - | 120395 | 1595604780000 | -122.40557375 | 37.79056524 | - | - | 1720441140000 | D3 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP1 | OVERHEAD MAST ARM | RETD | 1581590880000 | GRANT AVE | - | - | - | - | - | - |
| 103105 | N/A | Point | - | - | - | - | S133284 | HYDE ST: GEARY ST | - | F | F | - | F | 6116000 | 25166000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HYDE ST | GEARY ST | 24572 | 24572 | 37.78631022 | -122.41644912 | - | HYDE ST \ GEARY ST | 1710539427000 | MTA | TURNING VEHICLES(RA) YIELD(SYM) TO PED(SYM) | GEARY ST intersection | - | - | - | - | - | - | - | 120396 | 1288224000000 | -122.41644912 | 37.78631022 | - | - | - | D6 | - | OTHER REGULATORY | REG | R10-15.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373577960000 | HYDE ST | 800 - 899 GEARY ST | - | - | - | LARKIN ST | - |
| 103106 | N/A | Point | - | - | - | - | 24273 | - | - | - | - | - | - | 13696000 | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1695833320000 | smuneno | - | - | 22ND ST | - | 158465 | 158465 | 37.757161865829 | -122.399016876405 | - | - | 1710539427000 | MTA | SPEED HUMP | - | - | 20' SOUTH OF 22ND ST | - | - | - | - | - | 120397 | 1696505400000 | - | - | - | - | - | 10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | - | WISCONSIN ST | 800 - 919 WISCONSIN ST | - | - | - | MADERA ST | - |
| 103107 | N/A | Point | - | - | - | - | S272806 | HYDE ST: GEARY ST | - | T | T | - | F | 25166000 | 25166000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HYDE ST | GEARY ST | 96123 | 96123 | 37.78631022 | -122.41644912 | GEARY ST \ HYDE ST | HYDE ST \ GEARY ST | 1710539427000 | MTA | NO LEFT TURN (SYM) ON RED | GEARY ST intersection | - | - | - | - | - | - | - | 120398 | 1288224000000 | -122.41644912 | 37.78631022 | - | 1617321600000 | - | D6 | - | NO LEFT TURN | REG | R13B(CA).0002 | 24X36 | SUP1 | LIGHT POLE | IS | 1614684720000 | HYDE ST | - | - | - | - | - | - |
| 103108 | N/A | Point | - | - | - | - | S272807 | HYDE ST: GEARY ST | - | T | T | - | F | 25166000 | 25166000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HYDE ST | GEARY ST | 96124 | 96124 | 37.78631022 | -122.41644912 | GEARY ST \ HYDE ST | HYDE ST \ GEARY ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | GEARY ST intersection | - | - | - | - | - | - | - | 120399 | 1288224000000 | -122.41644912 | 37.78631022 | - | 1617321600000 | - | D6 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | 1614685020000 | HYDE ST | - | - | - | - | - | - |
| 103109 | N/A | Point | - | - | - | - | S236732 | GRANT AVE: BUSH ST | - | T | T | - | F | 24741000 | 24741000 | - | - | NORTH WEST CORNER | - | - | - | - | GRANT AVE | BUSH ST | 126110 | 126110 | 37.79056524 | -122.40557375 | BUSH ST \ GRANT AVE | GRANT AVE \ BUSH ST | 1733182222000 | middleware_editor | GRANT AVE | BUSH ST intersection | - | 400 II--> | - | - | - | - | - | 120400 | 1544798760000 | -122.40557375 | 37.79056524 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-1.0766 | 36X08 | SUP1 | LIGHT POLE | IS | 1496927640000 | GRANT AVE | - | - | - | - | - | - |
| 103110 | N/A | Point | - | - | - | - | S266337 | FELL ST: COLE ST | - | F | F | - | F | 26422000 | 26422000 | - | - | SOUTH WEST CORNER | - | - | - | - | FELL ST | FELL ST | 102264 | 102264 | 37.77236766 | -122.45078671 | COLE ST \ FELL ST | COLE ST \ FELL ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | FELL ST intersection | - | START SWC FROM W-LINE, X-WALK | - | - | - | - | - | 120401 | 1595830800000 | -122.45078671 | 37.77236766 | - | 1681344000000 | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1594909200000 | COLE ST | - | - | - | - | - | - |
| 103111 | N/A | Point | - | - | - | - | S266767 | CHESTNUT ST: GOUGH ST | - | F | F | - | F | - | 26716000 | - | - | SOUTH WEST CORNER | - | - | - | - | - | CHESTNUT ST | 100209 | 100209 | 37.80186291 | -122.4280221 | - | GOUGH ST \ CHESTNUT ST | 1710539427000 | MTA | CHESTNUT ST | CHESTNUT ST intersection | - | 1500 <-- W | - | - | - | - | - | 120402 | 1605001800000 | -122.4280221 | 37.80186291 | - | - | - | D2 | - | STREET NAME | GUIDE | D3-1.0371 | 36X08 | SUP1 | 3IN IRON POST | IS | 1596197400000 | GOUGH ST | - | - | - | - | - | - |
| 103112 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S251757 | 1300-1399 SILLIMAN ST | 1300-1399 SILLIMAN ST | F | F | - | F | 11886000 | 11886000 | - | - | SOUTH SIDE | - | - | - | - | YALE ST | YALE ST | 102382 | 102382 | 37.72775661 | -122.41840281 | - | - | 1710539427000 | MTA | NPRK 12NN-3PM TUE STCL | YALE ST to CAMBRIDGE ST (1300 - 1399) | - | WPL 1339 | - | - | - | - | - | 120403 | 1109635200000 | -122.41840281 | 37.72775661 | - | 1551225600000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0090 | 18X18 | SUP2 | 2IN IRON POST | IS | 1550746500000 | SILLIMAN ST | 1300 - 1399 SILLIMAN ST | 1300 - 1399 SILLIMAN ST | 1300 SILLIMAN ST | - | CAMBRIDGE ST | CAMBRIDGE ST |
| 103113 | N/A | Point | - | - | - | - | S110534 | GIRARD ST: WOOLSEY ST | - | F | F | - | F | 20631000 | 20631000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WOOLSEY ST | GIRARD ST | 8038 | 8038 | 37.72497559 | -122.40360092 | GIRARD ST \ WOOLSEY ST | WOOLSEY ST \ GIRARD ST | 1710539427000 | MTA | STOP | GIRARD ST intersection | - | 0 / 0 | - | - | - | - | - | 120404 | 653097600000 | -122.40360092 | 37.72497559 | - | 1150329600000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570820000 | WOOLSEY ST | - | - | - | - | - | - |
| 103114 | N/A | Point | - | - | - | - | S272778 | GEARY ST: JONES ST | - | T | T | - | F | 24960000 | 24960000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JONES ST | GEARY ST | 114037 | 114037 | 37.78672975 | -122.41316144 | GEARY ST \ JONES ST | JONES ST \ GEARY ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | GEARY ST intersection | - | - | - | - | - | - | - | 120405 | 28080000000 | -122.41316144 | 37.78672975 | - | 1617235200000 | - | D3 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | 1614679860000 | JONES ST | - | - | - | - | - | - |
| 103115 | N/A | Point | - | - | - | - | S104817 | GEARY ST: JONES ST | - | F | F | - | F | 24960000 | 24960000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JONES ST | GEARY ST | 1271 | 1271 | 37.78672975 | -122.41316144 | GEARY ST \ JONES ST | JONES ST \ GEARY ST | 1710539427000 | MTA | ONE WAY (RA) | GEARY ST intersection | - | 0 / MADE GEARY ONE-WAY WB | - | - | - | - | - | 120406 | 28080000000 | -122.41316144 | 37.78672975 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569020000 | JONES ST | - | - | - | - | - | - |
| 103116 | N/A | Point | - | - | - | - | S271895 | GEARY ST: JONES ST | - | T | T | - | F | 24960000 | 24960000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | JONES ST | GEARY ST | 94536 | 94536 | 37.78672975 | -122.41316144 | GEARY ST \ JONES ST | JONES ST \ GEARY ST | 1721160139000 | middleware_editor | SPEED LIMIT 20 | GEARY ST intersection | - | - | - | - | - | - | - | 120407 | 1126742400000 | -122.41316144 | 37.78672975 | - | 1622160000000 | - | D3 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1611742920000 | JONES ST | - | - | - | - | - | - |
| 103117 | N/A | Point | - | - | - | - | S218288 | GEARY ST: JONES ST | - | F | F | - | F | 6114000 | 24960000 | - | - | NORTH SIDE | - | - | - | - | JONES ST | GEARY ST | 57897 | 57897 | 37.78672975 | -122.41316144 | - | JONES ST \ GEARY ST | 1710539427000 | MTA | BIKE RACK | GEARY ST intersection | 20154203 | WPL# 610(ADANTE HOTEL) | - | - | - | - | - | 120408 | 1444914780000 | -122.41316144 | 37.78672975 | - | 1444867200000 | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1438770840000 | JONES ST | 600 - 699 GEARY ST | - | - | - | LEAVENWORTH ST | - |
| 103118 | N/A | Point | - | - | - | - | S268242 | JEFFERSON ST: MASON ST | - | F | F | - | F | - | 25486000 | - | - | SOUTH EAST CORNER | - | - | - | - | - | JEFFERSON ST | 127441 | 127441 | 37.80842106 | -122.41416443 | - | MASON ST \ JEFFERSON ST | 1710539427000 | MTA | JEFFERSON ST | JEFFERSON ST intersection | - | 100 <-- II W | - | - | - | - | - | 120409 | 1601464200000 | -122.41416443 | 37.80842106 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-1.0921 | 36X08 | SUP1 | SIGNAL POLE | IS | 1600686420000 | MASON ST | - | - | - | - | - | - |
| 103119 | N/A | Point | - | - | - | - | S136434 | JEFFERSON ST: MASON ST | - | T | T | - | F | 25486000 | 25486000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MASON ST | JEFFERSON ST | 29676 | 29676 | 37.80842106 | -122.41416443 | JEFFERSON ST \ MASON ST | MASON ST \ JEFFERSON ST | 1710539427000 | MTA | TSUNAMI EVACUATION ROUTE | JEFFERSON ST intersection | - | - | - | - | - | - | - | 120410 | 1335830400000 | -122.41416443 | 37.80842106 | - | - | - | D3 | - | OTHER GUIDE | GUIDE | G-T(SF).0034 | 24X24 | SUP1 | LIGHT POLE | IS | 1373578920000 | MASON ST | - | - | - | - | - | - |
| 103120 | N/A | Point | - | - | - | - | S240985 | MASON ST: JEFFERSON ST | - | T | T | - | F | 25486000 | 25486000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MASON ST | JEFFERSON ST | 81690 | 81690 | 37.80842106 | -122.41416443 | JEFFERSON ST \ MASON ST | MASON ST \ JEFFERSON ST | 1710539427000 | MTA | 49 MILE SCENIC DRIVE ARROW (LA) | JEFFERSON ST intersection | 32 | - | - | - | - | - | - | 120411 | 1524491940000 | -122.41416443 | 37.80842106 | - | 1524441600000 | - | D3 | - | OTHER GUIDE | GUIDE | G-X(SF).0048 | 18X18 | SUP1 | LIGHT POLE | IS | 1511957700000 | MASON ST | - | - | - | - | - | - |
| 103121 | N/A | Point | - | - | - | - | S284541 | JEFFERSON ST: MASON ST | - | T | T | - | F | 25486000 | 25486000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MASON ST | JEFFERSON ST | 96219 | 96219 | 37.80842106 | -122.41416443 | JEFFERSON ST \ MASON ST | MASON ST \ JEFFERSON ST | 1710539427000 | MTA | SPEED LIMIT 20 | JEFFERSON ST intersection | - | ABOVE SIGN | - | - | - | - | - | 120412 | 1673913600000 | -122.41416443 | 37.80842106 | - | - | - | D3 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | SIGNAL POLE | IS | 1660655160000 | MASON ST | - | - | - | - | - | - |
| 103122 | N/A | Point | - | - | - | - | S268399 | 24TH AVE: ANZA ST | - | F | F | - | F | 27536000 | 27536000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ANZA ST | ANZA ST | 86312 | 86312 | 37.77821431 | -122.4835254 | 24TH AVE \ ANZA ST | 24TH AVE \ ANZA ST | 1710539427000 | MTA | SPEED HUMPS | ANZA ST intersection | - | - | - | - | - | - | - | 120413 | 74822400000 | -122.4835254 | 37.77821431 | - | 1601337600000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1600859340000 | 24TH AVE | - | - | - | - | - | - |
| 103123 | N/A | Point | 1 | 1 | 500 - 544 | - | S129632 | 500-544 BROADWAY | 500-544 BROADWAY | F | F | - | F | 3152000 | 3151000 | - | - | SOUTH SIDE | - | - | - | - | ROMOLO ST | KEARNY ST | 23898 | 23898 | 37.79796862 | -122.40585223 | - | - | 1710539427000 | MTA | TANSAT | KEARNY ST to ROMOLO ST (500 - 544) | - | 25FT WEST | - | - | - | - | - | 120414 | 1221609600000 | -122.40585223 | 37.79796862 | - | - | - | D3 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1373576820000 | BROADWAY | 537 - 558 BROADWAY | 500 - 544 BROADWAY | 500 BROADWAY | - | COLUMBUS AVE | ROMOLO ST |
| 103124 | N/A | Point | 1 | 1 | 500 - 544 | - | S201315 | 500-544 BROADWAY | 500-544 BROADWAY | T | T | - | F | 3150000 | 3151000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | DIRK DIRKSEN PL | KEARNY ST | 45400 | 45400 | 37.79796862 | -122.40585223 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | KEARNY ST to ROMOLO ST (500 - 544) | - | EPL# 494 | - | - | - | - | - | 120415 | 443232000000 | -122.40585223 | 37.79796862 | - | 1389052800000 | - | D3 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | LIGHT POLE | IS | 1387537140000 | BROADWAY | 447 - 499 BROADWAY | 500 - 544 BROADWAY | 500 BROADWAY | - | KEARNY ST | ROMOLO ST |
| 103125 | N/A | Point | 1 | 1 | 500 - 544 | - | S201316 | 500-544 BROADWAY | 500-544 BROADWAY | T | T | - | F | - | 3151000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | - | KEARNY ST | 117995 | 117995 | 37.79796862 | -122.40585223 | - | - | 1710539427000 | MTA | EXC BUSES | KEARNY ST to ROMOLO ST (500 - 544) | - | EPL# 494 | - | - | - | - | - | 120416 | 443232000000 | -122.40585223 | 37.79796862 | - | 1389052800000 | - | D3 | - | OTHER REGULATORY | REG | R(SF).0059 | 12X18 | SUP1 | LIGHT POLE | IS | 1387538100000 | BROADWAY | - | 500 - 544 BROADWAY | 500 BROADWAY | - | - | ROMOLO 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 metersMetadata automatically harvested from the ESRI service during import.