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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102976 | N/A | Point | - | - | - | - | 25763 | - | - | F | F | - | F | - | - | - | - | NORTH SIDE | 1701963071000 | jrasmuss | - | - | - | - | 173763 | 173763 | 37.8086502909812 | -122.412865873709 | - | - | 1710539427000 | MTA | BIKE RACK | - | - | 61' W OF POWELL ST/3' IN FROM CURB | - | - | - | - | - | 120267 | 1702549800000 | - | - | - | - | - | 03 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | - | - | - | - | - | - | - | - |
| 102977 | N/A | Point | - | - | - | - | S275779 | LYON ST: GOLDEN GATE AVE | - | F | F | - | F | 26375000 | 26375000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LYON ST | GOLDEN GATE AVE | 121185 | 121185 | 37.77808921 | -122.44350692 | GOLDEN GATE AVE \ LYON ST | LYON ST \ GOLDEN GATE AVE | 1710539427000 | MTA | ROAD CLOSED TO THROUGH TRAFFIC | GOLDEN GATE AVE intersection | - | - | - | - | - | - | - | 120268 | -395020800000 | -122.44350692 | 37.77808921 | - | 1625702400000 | 1708696800000 | D5 | - | OTHER REGULATORY | REG | R(SF).0455 | 30X30 | SUP1 | 2IN IRON POST | RETD | 1624871580000 | LYON ST | - | - | - | - | - | - |
| 102978 | N/A | Point | - | - | - | - | S277439 | GOLDEN GATE AVE: LYON ST | - | F | F | - | F | 26375000 | 26375000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LYON ST | GOLDEN GATE AVE | 126422 | 126422 | 37.77808921 | -122.44350692 | GOLDEN GATE AVE \ LYON ST | LYON ST \ GOLDEN GATE AVE | 1710539427000 | MTA | SLOW STREETS FAMILY, H/C, PED, SKATEBOARD, BIKE (SYM)(COMBO) | GOLDEN GATE AVE intersection | - | 14 FT AND 20 FT FROM CURB | - | - | - | - | - | 120269 | 1344297600000 | -122.44350692 | 37.77808921 | - | 1630022400000 | - | D5 | - | OTHER REGULATORY | REG | R(SF).0451 | 12X36 | SUP1 | CITY POST EMBEDDED ACHOR CUP 4 | IS | 1631009940000 | LYON ST | - | - | - | - | - | - |
| 102979 | N/A | Point | 1 | 1 | 1300 - 1370 | - | S223978 | 1300-1370 JACKSON ST | 1300-1370 JACKSON ST | F | F | - | F | 7393000 | 7392000 | - | - | NORTH SIDE | - | - | - | - | WALL PL | LEAVENWORTH ST | 59964 | 59964 | 37.794699642 | -122.41704469 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-SAT EXC "AC" PERMITS | LEAVENWORTH ST to WALL PL (1300 - 1370) | - | 1376 JACKSON ST. | - | - | - | - | - | 120270 | 1569068040000 | -122.41699641 | 37.79471024 | - | - | - | D3 | - | PARKING:RPP | REG | R32C(CA).0130 | 18X21 | SUP1 | 2IN IRON POST | IS | 1457443440000 | JACKSON ST | 1365 - 1399 JACKSON ST | 1300 - 1370 JACKSON ST | 1300 JACKSON ST | - | HYDE ST | WALL PL |
| 102980 | N/A | Point | - | - | - | - | 24175 | - | - | F | F | - | F | 7392000 | - | - | - | SOUTH SIDE | 1695406377000 | jrasmuss | - | - | LEAVENWORTH ST | - | 156914 | 156914 | 37.7946257732471 | -122.417361457667 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-SAT EXC "AC" PERMITS | - | - | ifo 1353 | - | - | - | - | - | 120271 | - | - | - | - | - | - | 03 | - | PARKING:RPP | REG | R32C(CA).0130 | 18X21 | SUP1 | 2IN IRON POST | PI | - | JACKSON ST | 1300 - 1370 JACKSON ST | - | - | - | WALL PL | - |
| 102981 | N/A | Point | - | - | - | - | S107717 | MINNA ST: NEW MONTGOMERY ST | - | F | F | - | F | 24599000 | 24599000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MINNA ST | MINNA ST | 2873 | 2873 | 37.78701079 | -122.39997496 | NEW MONTGOMERY ST \ MINNA ST | NEW MONTGOMERY ST \ MINNA ST | 1710539427000 | MTA | DO NOT ENTER | MINNA ST intersection | - | - | - | - | - | - | - | 120272 | 247276800000 | -122.39997496 | 37.78701079 | - | - | - | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | 2IN FLANGE POST | IS | 1373569980000 | NEW MONTGOMERY ST | - | - | - | - | - | - |
| 102982 | N/A | Point | - | - | - | - | S107718 | MINNA ST: NEW MONTGOMERY ST | - | F | F | - | F | 24599000 | 24599000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MINNA ST | MINNA ST | 2874 | 2874 | 37.78701079 | -122.39997496 | NEW MONTGOMERY ST \ MINNA ST | NEW MONTGOMERY ST \ MINNA ST | 1710539427000 | MTA | ONE WAY (LA) | MINNA ST intersection | - | 0 / MINNA CHANGED 1-WAY WB-EB3RD-NE..... | - | - | - | - | - | 120273 | 247536000000 | -122.39997496 | 37.78701079 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373569980000 | NEW MONTGOMERY ST | - | - | - | - | - | - |
| 102983 | N/A | Point | 1 | 1 | 900 - 949 | - | S114880 | 900-949 VALLEJO ST | 900-949 VALLEJO ST | F | F | - | F | 13099000 | 13099000 | - | - | WEST SIDE, WESTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | MASON ST | MASON ST | 12362 | 12362 | 37.79811991 | -122.41246317 | - | - | 1731506992000 | MALOPEZ | OBJECT MARKER - RED | MASON ST to ALTA VISTA TER (900 - 949) | - | W-LINE / AT WEST DEAD-END NEAR #937 1/2 | - | - | - | - | - | 120274 | 1018483200000 | -122.41246317 | 37.79811991 | - | 1463356800000 | - | D3 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373572200000 | VALLEJO ST | 900 - 949 VALLEJO ST | 900 - 949 VALLEJO ST | 900 VALLEJO ST | - | ALTA VISTA TER | ALTA VISTA TER |
| 102984 | N/A | Point | 1 | 1 | 1 - 299 | - | S135790 | 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 | 28796 | 28796 | 37.73232349 | -122.37835407 | - | - | 1710539427000 | MTA | OBJECT MARKER - RED | NORTHRIDGE RD to INGALLS ST (1 - 299) | - | 0 / INSTALL SIGN ON K-RAIL IFO# 54-..... | - | - | - | - | - | 120275 | 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 |
| 102985 | N/A | Point | - | - | - | - | S268024 | COLON AVE: BRENTWOOD AVE | - | F | F | - | F | 22801000 | 22801000 | - | - | SOUTH SIDE, SOUTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | COLON AVE | COLON AVE | 111792 | 111792 | 37.73388285 | -122.45822976 | BRENTWOOD AVE \ COLON AVE | BRENTWOOD AVE \ COLON AVE | 1710539427000 | MTA | OBJECT MARKER - RED | COLON AVE intersection | - | END OF BLOCK AGAINST FENCE | - | - | - | - | - | 120276 | 1467158400000 | -122.45822976 | 37.73388285 | - | 1600387200000 | - | D7 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP2 | FENCE | IS | 1599735300000 | BRENTWOOD AVE | - | - | - | - | - | - |
| 102986 | N/A | Point | - | - | - | - | S278746 | 151-199 HUNTERS POINT EXPY | - | F | F | - | F | 7097000 | 7097000 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | - | - | 121439 | 121439 | 37.7109013 | -122.38169833 | - | - | 1710539427000 | MTA | OBJECT MARKER - RED | - | - | SOUTH SIDE / STATE REC PRK AREA ENTRANC | - | - | - | - | - | 120277 | 1636934400000 | -122.38169833 | 37.7109013 | - | - | - | D10 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP1 | K-RAIL BARRICADE | IS | 1636469580000 | HUNTERS POINT EXPY | 151-199 HUNTERS POINT EXPY | HUNTERS POINT EXPY | - | - | - | - |
| 102987 | N/A | Point | 1 | 1 | 126 - 199 | - | S204083 | 126-199 BURNSIDE AVE | 126-199 BURNSIDE AVE | F | F | - | F | 3401000 | 3401000 | - | - | NORTH SIDE, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | MANGELS AVE | MANGELS AVE | 44922 | 44922 | 37.73348667 | -122.43868555 | - | - | 1710539427000 | MTA | OBJECT MARKER - RED | MANGELS AVE to BURNSIDE AVE (126 - 199) | - | OPP#128 @ DEAD END | - | - | - | - | - | 120278 | 1395998100000 | -122.43868555 | 37.73348667 | - | 1395964800000 | - | D8 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1395315780000 | BURNSIDE AVE | 126 - 199 BURNSIDE AVE | 126 - 199 BURNSIDE AVE | 126 BURNSIDE AVE | - | BURNSIDE AVE | BURNSIDE AVE |
| 102988 | N/A | Point | 1 | 1 | 1000 - 1049 | - | S224476 | 1000-1049 BROADWAY | 1000-1049 BROADWAY | F | F | - | F | 3161000 | 3161000 | - | - | WEST SIDE, WESTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | TAYLOR ST | TAYLOR ST | 64725 | 64725 | 37.79695373 | -122.41400813 | - | - | 1710539427000 | MTA | OBJECT MARKER - RED | TAYLOR ST to END: 1000-1049 BLOCK (1000 - 1049) -- NORTH -- | - | WEST END OF BLOCK | - | - | - | - | - | 120279 | 1052265600000 | -122.41400813 | 37.79695373 | - | 1608595200000 | - | D3 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP1 | RETAINING WALL | IS | 1459332000000 | BROADWAY | 1000 - 1049 BROADWAY | 1000 - 1049 BROADWAY | 1000 BROADWAY | - | END: 1000-1049 BLOCK | END: 1000-1049 BLOCK |
| 102989 | N/A | Point | - | - | - | RIGHT ARROW | S239634 | 16TH ST: FLINT ST | - | F | F | - | F | 25825000 | 25825000 | - | - | CENTER ISLAND, W LINE, WESTBOUND | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | FLINT ST | FLINT ST | 72693 | 72693 | 37.76398268 | -122.43653488 | 16TH ST \ FLINT ST | 16TH ST \ FLINT ST | 1710539427000 | MTA | OBJECT MARKER - RED | FLINT ST intersection | - | AT DEAD-END IFO# 3810 16TH ST. | - | - | - | - | - | 120280 | 1326067200000 | -122.43653488 | 37.76398268 | - | 1508803200000 | - | D8 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1508493360000 | 16TH ST | - | - | - | - | - | - |
| 102990 | N/A | Point | 1 | 1 | 1200 - 1231 | - | S289837 | 1200-1248 MONTGOMERY ST | 1200-1231 MONTGOMERY ST | F | F | - | F | 9313000 | 9313000 | - | - | SOUTH SIDE, SOUTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | GREEN ST | GREEN ST | 103954 | 103954 | 37.80033773 | -122.40428769 | - | - | 1725412167000 | middleware_editor | OBJECT MARKER - RED | GREEN ST to MONTAGUE PL (1200 - 1231) | - | SPL# 1227/ @ DEAD END/CL MONTGOMERY | - | - | - | - | - | 120281 | - | -122.40428769 | 37.80033773 | - | 1685404800000 | - | D3 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1685028840000 | MONTGOMERY ST | 1200 - 1231 MONTGOMERY ST | 1200 - 1231 MONTGOMERY ST | 1200 MONTGOMERY ST | - | MONTAGUE PL | MONTAGUE PL |
| 102991 | N/A | Point | 1 | 1 | 400 - 499 | - | S201902 | 400-499 RIVERA ST | 400-499 RIVERA ST | F | F | - | F | 11047000 | 11047000 | - | - | EAST SIDE, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | 14TH AVE | 14TH AVE | 47005 | 47005 | 37.747092511 | -122.46993555 | - | - | 1710539427000 | MTA | OBJECT MARKER - RED | 14TH AVE to 15TH AVE (400 - 499) | - | E- END OF BLOCK | - | - | - | - | - | 120282 | 1485345840000 | -122.47091545 | 37.74700202 | - | 1485302400000 | - | D7 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1389259380000 | RIVERA ST | 400 - 499 RIVERA ST | 400 - 499 RIVERA ST | 400 RIVERA ST | - | 15TH AVE | 15TH AVE |
| 102992 | N/A | Point | - | - | - | - | S241210 | COOK ST: GEARY BLVD | - | F | F | - | F | 26924000 | 26924000 | - | - | NORTH SIDE, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | GEARY BLVD | GEARY BLVD | 106702 | 106702 | 37.781859296 | -122.452082323 | COOK ST \ GEARY BLVD | COOK ST \ GEARY BLVD | 1752102513000 | middleware_editor | OBJECT MARKER - RED | GEARY BLVD intersection | - | N-END OF BLOCK NEAR STEPS | - | - | - | - | - | 120283 | - | -122.45214312 | 37.78185329 | - | 1752101160000 | - | D1 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1512477600000 | COOK ST | - | - | - | - | - | - |
| 102993 | N/A | Point | 1 | 1 | 2700 - 2799 | - | S216854 | 2700-2799 LARKIN ST | 2700-2799 LARKIN ST | F | F | - | F | 8155000 | 8155000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | CHESTNUT ST | CHESTNUT ST | 87298 | 87298 | 37.80310637 | -122.4214947 | - | - | 1717450743000 | middleware_editor | OBJECT MARKER - RED | CHESTNUT ST to FRANCISCO ST (2700 - 2799) | - | 25' NORTH OF LARKIN | - | - | - | - | - | 120284 | - | -122.4214947 | 37.80310637 | - | 1717412400000 | - | D2 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP1 | RETAINING WALL | IS | 1433419980000 | LARKIN ST | 2700 - 2799 LARKIN ST | 2700 - 2799 LARKIN ST | 2700 LARKIN ST | - | FRANCISCO ST | FRANCISCO ST |
| 102994 | N/A | Point | - | - | - | - | S273740 | SANCHEZ ST: CUMBERLAND ST | - | F | F | - | F | 25716000 | 25716000 | - | - | NORTH SIDE, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | SANCHEZ ST | CUMBERLAND ST | 114483 | 114483 | 37.758756 | -122.43034437 | CUMBERLAND ST \ SANCHEZ ST | SANCHEZ ST \ CUMBERLAND ST | 1710539427000 | MTA | OBJECT MARKER - RED | CUMBERLAND ST intersection | - | END OF BLOCK DEAD END IFO 606 | - | - | - | - | - | 120285 | 1604275200000 | -122.43034437 | 37.758756 | - | 1618358400000 | - | D8 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1617189960000 | SANCHEZ ST | - | - | - | - | - | - |
| 102995 | N/A | Point | - | - | - | - | S218244 | KENSINGTON WAY: MERCED AVE | - | F | F | - | F | 22881000 | 22881000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | MERCED AVE | MERCED AVE | 55675 | 55675 | 37.74338362 | -122.46286001 | KENSINGTON WAY \ MERCED AVE | KENSINGTON WAY \ MERCED AVE | 1746570807000 | middleware_editor | OBJECT MARKER - RED | MERCED AVE intersection | - | OPP#34 | - | - | - | - | - | 120286 | - | -122.46286001 | 37.74338362 | - | - | - | D7 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1438266720000 | KENSINGTON WAY | - | - | - | - | - | - |
| 102996 | N/A | Point | - | - | - | - | S232017 | TIFFANY AVE: DUNCAN ST | - | F | F | - | F | 21341000 | 21341000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | TIFFANY AVE | DUNCAN ST | 71373 | 71373 | 37.74649205 | -122.42035762 | DUNCAN ST \ TIFFANY AVE | TIFFANY AVE \ DUNCAN ST | 1741275096000 | middleware_editor | OBJECT MARKER - RED | DUNCAN ST intersection | - | @ PM INSTALL ATLEAST 7 FT HIGH | - | - | - | - | - | 120287 | 1488319440000 | -122.42035762 | 37.74649205 | - | 1565852400000 | - | D9 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1482825960000 | TIFFANY AVE | - | - | - | - | - | - |
| 102997 | N/A | Point | 1 | 1 | 600 - 655 | - | S249056 | 600-655 DUNCAN ST | 600-655 DUNCAN ST | F | F | - | F | 5006000 | 5006000 | - | - | EAST SIDE, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | CASTRO ST | CASTRO ST | 84874 | 84874 | 37.74564914 | -122.43413413 | - | - | 1725585639000 | middleware_editor | OBJECT MARKER - RED | CASTRO ST to NEWBURG ST (600 - 655) | - | AT EAST DEAD-END(NEAR 538 DUNCAN ST) | - | - | - | - | - | 120288 | 984700800000 | -122.43413413 | 37.74564914 | - | - | - | D8 | - | OTHER WARNING | WARNING | TYPE-N(CA).0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1539960780000 | DUNCAN ST | 600 - 655 DUNCAN ST | 600 - 655 DUNCAN ST | 600 DUNCAN ST | - | NEWBURG ST | NEWBURG ST |
| 102998 | N/A | Point | 1 | 1 | 200 - 299 | - | S237801 | 200-299 DORE ST | 200-299 DORE ST | F | F | - | F | 4931000 | 4931000 | - | - | EAST SIDE | - | - | - | - | HARRISON ST | HARRISON ST | 69741 | 69741 | 37.77143616 | -122.40990643 | - | - | 1710539427000 | MTA | NPRK ANY TIME | HARRISON ST to BRYANT ST (200 - 299) | - | 40`SOUTH | - | - | - | - | - | 120289 | - | -122.40990643 | 37.77143616 | - | 1697542200000 | - | D6 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1501072680000 | DORE ST | 200 - 299 DORE ST | 200 - 299 DORE ST | 200 DORE ST | - | BRYANT ST | BRYANT ST |
| 102999 | N/A | Point | 1 | 1 | 50 - 99 | - | S278371 | 50-99 HAYES ST | 50-99 HAYES ST | F | F | - | F | 6812000 | 6812000 | - | - | NORTH SIDE | - | - | - | - | LARKIN ST | LARKIN ST | 106435 | 106435 | 37.77761723 | -122.41722212 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | LARKIN ST to POLK ST (50 - 99) | - | START 24 'EAST OF POLK ST | - | - | - | - | - | 120290 | 1636379220000 | -122.41722212 | 37.77761723 | - | 1696590000000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1634684280000 | HAYES ST | 50 - 99 HAYES ST | 50 - 99 HAYES ST | 50 HAYES ST | - | POLK ST | POLK ST |
| 103000 | N/A | Point | 1 | 1 | 131 - 199 | - | S287148 | 131-199 GRANT AVE | 131-199 GRANT AVE | T | T | - | F | 6383000 | 6383000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | MAIDEN LN | MAIDEN LN | 104006 | 104006 | 37.78846214 | -122.40517628 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | MAIDEN LN to POST ST (131 - 199) | - | 25 FT SOUTH OF POST IFO 199 | - | - | - | - | - | 120291 | 1676246400000 | -122.40517628 | 37.78846214 | - | 1697450400000 | - | D3 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | 2IN FLANGE POST | IS | 1674467640000 | GRANT AVE | 131 - 199 GRANT AVE | 131 - 199 GRANT AVE | 131 GRANT AVE | - | POST ST | POST ST |
| 103001 | N/A | Point | - | - | - | - | 24370 | - | - | - | - | - | - | 9563000 | - | - | - | EAST SIDE | 1696003112000 | smuneno | - | - | MENDELL ST | - | 159473 | 159473 | 37.7421365337057 | -122.386298858562 | - | - | 1747246825000 | middleware_editor | ZIPCARS | - | - | 36' NORTH OF EVANS AVE | - | - | - | - | - | 120292 | 1696354200000 | - | - | - | - | 1747243800000 | 10 | - | OTHER GUIDE | GUIDE | G-Z(SF).0005 | 05X12 | SUP1 | 2IN IRON POST | RETD | - | NEWHALL ST | 200 - 399 NEWHALL ST | - | - | - | EVANS AVE | - |
| 103002 | N/A | Point | 1 | 1 | 700 - 899 | - | S274228 | PNDG 16TH ST | 700-899 16TH ST | F | F | - | F | 699001 | 699001 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | OWENS ST | OWENS ST | 123203 | 123203 | 37.76661802 | -122.39386121 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | OWENS ST to 07TH ST \ MISSISSIPPI ST (700 - 899) | - | START 100' W OF W-LINE X-WALK, 10' OC | - | - | - | - | - | 120293 | 1619609520000 | -122.39386121 | 37.76661802 | - | - | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | TURNPIKE BASE | IS | 1619173980000 | 16TH ST | PNDG 16TH ST | 700 - 899 16TH ST | - | - | 07TH ST \ MISSISSIPPI ST | 07TH ST \ MISSISSIPPI ST |
| 103003 | N/A | Point | 1 | 1 | 1 - 99 | - | S276403 | 1-99 SCHWERIN ST | 1-99 SCHWERIN ST | F | F | - | F | 11672000 | 11672000 | - | - | EAST SIDE | - | - | - | - | LELAND AVE | LELAND AVE | 124143 | 124143 | 37.71275524 | -122.41039559 | - | - | 1710539427000 | MTA | TA (SYM) PLO 1PM-3:30PM SCHOOL DAYS (5 MIN) | LELAND AVE to VISITACION AVE (1 - 99) | - | 50' NORTH OF VISITACION AVE | - | - | - | - | - | 120294 | 1628769480000 | -122.41039559 | 37.71275524 | - | 1696251600000 | - | D10 | - | OTHER REGULATORY | REG | R38(SF)6.0104 | 14X21 | SUP1 | 2IN IRON POST | IS | 1626955020000 | SCHWERIN ST | 1 - 99 SCHWERIN ST | 1 - 99 SCHWERIN ST | 1 SCHWERIN ST | - | VISITACION AVE | VISITACION AVE |
| 103004 | N/A | Point | - | - | - | - | 24346 | - | - | - | - | - | - | 12595000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1695923658000 | smuneno | - | - | NEPTUNE ST | - | 159153 | 159153 | 37.731399601946 | -122.397117408466 | - | - | 1710539427000 | MTA | SPEED HUMP | - | - | 40' WEST OF NEPTUNE ST | - | - | - | - | - | 120295 | 1696416600000 | - | - | - | - | - | 10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | - | THORNTON AVE | 394 - 449 THORNTON AVE | - | - | - | VENUS ST | - |
| 103005 | N/A | Point | - | - | - | - | S272078 | TOLAND ST: MCKINNON AVE | - | F | F | - | F | 20805000 | 20805000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MCKINNON AVE | TOLAND ST | 91765 | 91765 | 37.7421972 | -122.40042674 | TOLAND ST \ MCKINNON AVE | MCKINNON AVE \ TOLAND ST | 1728681711000 | middleware_editor | PEDESTRIAN (SYM) | TOLAND ST intersection | - | ABOVE PED | - | - | - | - | - | 120296 | 1357257600000 | -122.40042674 | 37.7421972 | - | 1728611400000 | - | D10 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1612259040000 | MCKINNON AVE | - | - | - | - | - | - |
| 103006 | N/A | Point | - | - | - | - | S250495 | JONES ST: GEARY ST | - | T | T | - | F | 24960000 | 24960000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JONES ST | GEARY ST | 82130 | 82130 | 37.78672975 | -122.41316144 | GEARY ST \ JONES ST | JONES ST \ GEARY ST | 1710539427000 | MTA | GEARY ST | GEARY ST intersection | - | - | - | - | - | - | - | 120297 | - | -122.41316144 | 37.78672975 | - | 1697717700000 | - | D3 | - | STREET NAME | GUIDE | D3-2.0167 | 72X18 | SUP1 | LIGHT POLE | IS | 1545831900000 | JONES ST | - | - | - | - | - | - |
| 103007 | N/A | Point | - | - | - | - | 24369 | - | - | - | - | - | - | 9563000 | - | - | - | EAST SIDE | 1696003057000 | smuneno | - | - | MENDELL ST | - | 159457 | 159457 | 37.7421386547258 | -122.386298858562 | - | - | 1747246923000 | middleware_editor | TA (SYM) NO STOPPING EXC PERMITTED CSV- ZIPCARS | - | - | 36' NORTH OF EVANS AVE. | - | - | - | - | - | 120298 | 1696351500000 | - | - | - | - | 1747244700000 | 10 | - | OTHER REGULATORY | REG | R37(SF).0291 | 05X12 | SUP1 | 2IN IRON POST | RETD | - | NEWHALL ST | 200 - 399 NEWHALL ST | - | - | - | EVANS AVE | - |
| 103008 | N/A | Point | - | - | - | - | 24295 | - | - | F | F | - | F | 12625000 | - | - | - | WEST SIDE | 1695838288000 | APADILLA | - | - | JERROLD AVE | - | 158530 | 158530 | 37.743519866 | -122.399369036 | - | - | 1726782427000 | middleware_editor | NPRK ANY TIME VEH OVER 22' LONG OR 7' HIGH 12AM-6AM EVERYDAY | - | - | 240FT SOUTH OF JERROLD | - | - | - | - | - | 120299 | - | - | - | - | 1726756200000 | - | 10 | - | PARKING:NPRK ANY TIME | REG | R30(SF).0572 | 18X18 | SUP1 | 2IN IRON POST | IS | - | TOLAND ST | 500 - 599 TOLAND ST | - | - | - | KIRKWOOD AVE | - |
| 103009 | N/A | Point | - | - | - | - | S203042 | MINNA ST: NEW MONTGOMERY ST | - | F | F | - | F | 24599000 | 24599000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MINNA ST | MINNA ST | 42282 | 42282 | 37.78701079 | -122.39997496 | NEW MONTGOMERY ST \ MINNA ST | NEW MONTGOMERY ST \ MINNA ST | 1710539427000 | MTA | DO NOT ENTER | MINNA ST intersection | - | - | - | - | - | - | - | 120300 | 247280400000 | -122.39997496 | 37.78701079 | - | 1696240800000 | - | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1392304800000 | NEW MONTGOMERY ST | - | - | - | - | - | - |
| 103010 | N/A | Point | - | - | - | - | 24347 | - | - | - | - | - | - | 20541000 | - | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | 1695923740000 | smuneno | - | - | THORNTON AVE | - | 159063 | 159063 | 37.731392260474 | -122.397657267845 | VENUS ST \ THORNTON AVE | - | 1710539427000 | MTA | SPEED HUMP | - | - | 3' EAST OF VENUS | - | - | - | - | - | 120301 | 1696414500000 | - | - | - | - | - | 10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | - | VENUS ST | - | - | - | - | - | - |
| 103011 | N/A | Point | - | - | - | - | 24100 | - | - | - | - | - | - | 10145000 | - | - | - | SOUTH SIDE | 1695312119000 | smuneno | - | - | MCCORMICK ST \ MORRELL PL | - | 156561 | 156561 | 37.7952738087666 | -122.419505863134 | - | - | 1710539427000 | MTA | TANS EXC 30 MIN COMMERCIAL VEH 12NN-4PM MON-FRI | - | - | 100' EAST OF LARKIN ST | - | - | - | - | - | 120302 | 1696502400000 | - | - | - | - | - | 03 | - | TOW (TANSAT) | REG | R37(SF).0487 | 18X21 | SUP1 | 2IN IRON POST | IS | - | PACIFIC AVE | 1450 - 1499 PACIFIC AVE | - | - | - | LARKIN ST | - |
| 103012 | N/A | Point | 1 | 1 | 912 - 999 | - | S287155 | 912-999 WISCONSIN ST | 912-999 WISCONSIN ST | F | F | - | F | 13697000 | 13697000 | - | - | EAST SIDE | - | - | - | - | MADERA ST | MADERA ST | 95565 | 95565 | 37.75529301 | -122.39874656 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM WED STCL | MADERA ST to 23RD ST (912 - 999) | - | 23' NORTH OF 23RD ST INFO 999 | - | - | - | - | - | 120303 | 1674691200000 | -122.39874656 | 37.75529301 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0086 | 18X18 | SUP1 | 2IN IRON POST | IS | 1674472080000 | WISCONSIN ST | 912 - 999 WISCONSIN ST | 912 - 999 WISCONSIN ST | 912 WISCONSIN ST | - | 23RD ST | 23RD ST |
| 103013 | N/A | Point | - | - | - | - | 24274 | - | - | - | - | - | - | 13696000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1695833429000 | smuneno | - | - | 22ND ST | - | 158435 | 158435 | 37.7559783415697 | -122.398730326649 | - | - | 1710539427000 | MTA | SPEED HUMP | - | - | 20' NORTH OF MADERA ST | - | - | - | - | - | 120304 | 1696509000000 | - | - | - | - | - | 10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | - | WISCONSIN ST | 800 - 919 WISCONSIN ST | - | - | - | MADERA ST | - |
| 103014 | N/A | Point | 1 | 1 | 700 - 799 | - | S283092 | 700-799 MINNA ST | 700-799 MINNA ST | F | F | - | F | 9049000 | 9049000 | - | - | SOUTH SIDE | - | - | - | - | 8TH ST | 08TH ST | 90011 | 90011 | 37.77641356 | -122.41339494 | - | - | 1710539427000 | MTA | NPRK ANY TIME | 08TH ST to 09TH ST (700 - 799) | - | 35FT WEST OF 8TH ST | - | - | - | - | - | 120305 | - | -122.41339494 | 37.77641356 | - | 1695812400000 | - | D6 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1653661620000 | MINNA ST | 700 - 799 MINNA ST | 700 - 799 MINNA ST | 700 MINNA ST | - | 09TH ST | 09TH ST |
| 103015 | N/A | Point | 1 | 1 | 300 - 399 | LEFT ARROW | S226843 | 300-399 6TH AVE | 300-399 06TH AVE | F | F | - | F | 316000 | 316000 | - | - | WEST SIDE | - | - | - | - | CLEMENT ST | CLEMENT ST | 67060 | 67060 | 37.78197943 | -122.4643521 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-6PM MON-FRI EXC "N" PERMITS | CLEMENT ST to GEARY BLVD (300 - 399) | - | 54`NORTH OF GEARY | - | - | - | - | - | 120306 | 1220313600000 | -122.4643521 | 37.78197943 | - | 1467849600000 | - | D1 | - | PARKING:RPP | REG | R32C(CA).0169 | 18X21 | SUP2 | 2IN IRON POST | IS | 1466589300000 | 06TH AVE | 300 - 399 06TH AVE | 300 - 399 06TH AVE | 300 6TH AVE | - | GEARY BLVD | GEARY BLVD |
| 103016 | N/A | Point | 1 | 1 | 300 - 399 | - | S141361 | 300-399 6TH AVE | 300-399 06TH AVE | F | F | - | F | 316000 | 316000 | - | - | EAST SIDE | - | - | - | - | CLEMENT ST | CLEMENT ST | 127138 | 127138 | 37.7816650715772 | -122.464263568902 | - | - | 1754000474000 | middleware_editor | NPRK 7AM-9AM 1ST & 3RD MON OF MONTH STCL | CLEMENT ST to GEARY BLVD (300 - 399) | - | 372 6TH AVE | - | - | - | - | - | 120307 | 1220338800000 | -122.4643521 | 37.78197943 | - | 1753984440000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0227 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375725780000 | 06TH AVE | 300 - 399 06TH AVE | 300 - 399 06TH AVE | 300 6TH AVE | - | GEARY BLVD | GEARY BLVD |
| 103017 | N/A | Point | 1 | 1 | 300 - 399 | - | S223038 | 300-399 6TH AVE | 300-399 06TH AVE | F | F | - | F | 316000 | 316000 | - | - | EAST SIDE | - | - | - | - | CLEMENT ST | CLEMENT ST | 60294 | 60294 | 37.78197943 | -122.4643521 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | CLEMENT ST to GEARY BLVD (300 - 399) | - | IFO 302 6TH AVE | - | - | - | - | - | 120308 | 1220313600000 | -122.4643521 | 37.78197943 | - | 1454544000000 | - | D1 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1454483340000 | 06TH AVE | 300 - 399 06TH AVE | 300 - 399 06TH AVE | 300 6TH AVE | - | GEARY BLVD | GEARY BLVD |
| 103018 | N/A | Point | - | - | - | - | 25425 | 24TH AVE: PACHECO ST | - | F | F | - | F | 23272000 | 23272000 | - | SHOULD BE RETIRED | NORTH SIDE, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | 24TH AVE | 24TH AVE | 158253 | 158253 | 37.75027382 | -122.48157001 | PACHECO ST \ 24TH AVE | PACHECO ST \ 24TH AVE | 1710539427000 | MTA | OBJECT MARKER - YELLOW | 24TH AVE intersection | - | OPP.C-LINE | - | - | - | - | - | 120309 | 1455710520000 | -122.48157001 | 37.75027382 | - | 1455667200000 | - | D4 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP2 | 2IN IRON POST | IS | 1453297200000 | PACHECO ST | - | - | - | - | - | - |
| 103019 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S226708 | 2200-2299 MISSION ST | 2200-2299 MISSION ST | F | F | - | F | 9120000 | 9120000 | - | - | WEST SIDE | - | - | - | - | 18TH ST | 18TH ST | 65076 | 65076 | 37.76103561 | -122.41928266 | - | - | 1710539427000 | MTA | BIKE RACK | 18TH ST to 19TH ST (2200 - 2299) | 20154720 | 8 FT 6" SOUTH OF NPL#2250 | - | - | - | - | - | 120310 | 1468837080000 | -122.41928266 | 37.76103561 | - | 1468800000000 | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1466158320000 | MISSION ST | 2200 - 2299 MISSION ST | 2200 - 2299 MISSION ST | 2200 MISSION ST | - | 19TH ST | 19TH ST |
| 103020 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S226709 | 2200-2299 MISSION ST | 2200-2299 MISSION ST | F | F | - | F | 9120000 | 9120000 | - | - | WEST SIDE | - | - | - | - | 18TH ST | 18TH ST | 65077 | 65077 | 37.76103561 | -122.41928266 | - | - | 1710539427000 | MTA | BIKE RACK | 18TH ST to 19TH ST (2200 - 2299) | 20154720 | 21 FT SOUTH OF NPL#2250 | - | - | - | - | - | 120311 | 1467121500000 | -122.41928266 | 37.76103561 | - | 1467072000000 | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1466158560000 | MISSION ST | 2200 - 2299 MISSION ST | 2200 - 2299 MISSION ST | 2200 MISSION ST | - | 19TH ST | 19TH ST |
| 103021 | N/A | Point | - | 1 | 529 - 599 | - | S224653 | 529-599 FOLSOM ST | 529-599 FOLSOM ST | T | T | - | F | 5659000 | 5659000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | ESSEX ST | ESSEX ST | 58810 | 58810 | 37.78596054 | -122.39617532 | - | - | 1710539427000 | MTA | BICYCLE SIGNAL AHEAD (SYM) | ESSEX ST to 02ND ST (529 - 599) | - | 120' WEST OF ESSEX ST. | - | - | - | - | - | 120312 | 1461247920000 | -122.39617532 | 37.78596054 | - | 1461196800000 | 1700217000000 | D6 | - | OTHER WARNING | WARNING | W3-3(SF).0004 | 30X30 | SUP1 | LIGHT POLE | RETD | 1460110200000 | FOLSOM ST | 529 - 599 FOLSOM ST | 529 - 599 FOLSOM ST | 529 FOLSOM ST | - | 02ND ST | 02ND ST |
| 103022 | N/A | Point | 1 | 1 | 1900 - 1999 | - | S208252 | 1900-1999 37TH AVE | 1900-1999 37TH AVE | F | F | - | F | 1833000 | 1833000 | - | - | EAST SIDE | - | - | - | - | ORTEGA ST | ORTEGA ST | 49683 | 49683 | 37.75059446 | -122.4955652 | - | - | 1710539427000 | MTA | TANP PZ 8:30AM-9:30AM/3PM-4PM SCHL DAYS | ORTEGA ST to PACHECO ST (1900 - 1999) | - | 100`SOUTH PLUS(LA) | - | - | - | - | - | 120313 | 1408544760000 | -122.4955652 | 37.75059446 | - | 1408492800000 | - | D4 | - | TOW (TANP ANY TIME) | REG | R26K(SF).0158 | 12X18 | SUP2 | 2IN IRON POST | IS | 1408361640000 | 37TH AVE | 1900 - 1999 37TH AVE | 1900 - 1999 37TH AVE | 1900 37TH AVE | - | PACHECO ST | PACHECO ST |
| 103023 | N/A | Point | 1 | 1 | 1900 - 1999 | RIGHT ARROW | S115507 | 1900-1999 37TH AVE | 1900-1999 37TH AVE | T | T | - | F | 1833000 | 1833000 | - | - | WEST SIDE | - | - | - | - | ORTEGA ST | ORTEGA ST | 10700 | 10700 | 37.75059446 | -122.4955652 | - | - | 1710539427000 | MTA | BUS STOP NPPZ 8AM-9AM/2:30PM-4:00PM SCHL DAYS (RA) | ORTEGA ST to PACHECO ST (1900 - 1999) | - | 160`SOUTH OF ORTEGA | - | - | - | - | - | 120314 | 1033344000000 | -122.4955652 | 37.75059446 | - | - | 1702565160000 | D4 | - | OTHER REGULATORY | REG | R30(SF).0002 | 10X15 | SUP2 | LIGHT POLE | RETD | 1373572380000 | 37TH AVE | 1900 - 1999 37TH AVE | 1900 - 1999 37TH AVE | 1900 37TH AVE | - | PACHECO ST | PACHECO ST |
| 103024 | N/A | Point | 1 | 1 | 1900 - 1999 | - | S114574 | 1900-1999 37TH AVE | 1900-1999 37TH AVE | T | T | - | F | 1833000 | 1833000 | - | - | WEST SIDE | - | - | - | - | ORTEGA ST | ORTEGA ST | 13087 | 13087 | 37.7510439875101 | -122.495688640566 | - | - | 1744921504000 | middleware_editor | NPRK 2AM-6AM TUE THUR STCL | ORTEGA ST to PACHECO ST (1900 - 1999) | - | 160 FT SOUTH OF ORTEGA | - | - | - | - | - | 120315 | 1010649600000 | -122.4955652 | 37.75059446 | - | 1744918740000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0133 | 18X18 | SUP2 | LIGHT POLE | IS | 1373572080000 | 37TH AVE | 1900 - 1999 37TH AVE | 1900 - 1999 37TH AVE | 1900 37TH AVE | - | PACHECO ST | PACHECO ST |
| 103025 | N/A | Point | 1 | 1 | 1900 - 1999 | - | S205829 | 1900-1999 37TH AVE | 1900-1999 37TH AVE | T | T | - | F | 1833000 | 1833000 | - | - | WEST SIDE | - | - | - | - | ORTEGA ST | ORTEGA ST | 44613 | 44613 | 37.75059446 | -122.4955652 | - | - | 1710539427000 | MTA | NPRK ANY TIME VEH OVER 22' LONG OR 7' HIGH 12AM-6AM EVERYDAY | ORTEGA ST to PACHECO ST (1900 - 1999) | - | 160`SOUTH OF ORTEGA | - | - | - | - | - | 120316 | 1033344000000 | -122.4955652 | 37.75059446 | - | 1402531200000 | - | D4 | - | PARKING:NPRK ANY TIME | REG | R30(SF).0572 | 18X18 | SUP2 | LIGHT POLE | IS | 1400233920000 | 37TH AVE | 1900 - 1999 37TH AVE | 1900 - 1999 37TH AVE | 1900 37TH AVE | - | PACHECO ST | PACHECO ST |
| 103026 | N/A | Point | 1 | 1 | 200 - 250 | - | S250193 | 200-250 SILVER AVE | 200-250 SILVER AVE | F | F | - | F | 11892000 | 11892000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | ALEMANY BLVD | 81214 | 81214 | 37.72952252 | -122.43285656 | - | - | 1710539427000 | MTA | PUBLIC LIBRARY (LOGO) (RA) | ALEMANY BLVD to CAMELLIA AVE (200 - 250) | - | AT # 282 SILVER AVE. | - | - | - | - | - | 120317 | 1548852000000 | -122.43285656 | 37.72952252 | - | - | - | D11 | - | OTHER GUIDE | GUIDE | G-P(SF).0119 | 24X42 | SUP2 | LIGHT POLE | IS | 1544601480000 | SILVER AVE | 200 - 250 SILVER AVE | 200 - 250 SILVER AVE | 200 SILVER AVE | - | CAMELLIA AVE | CAMELLIA AVE |
| 103027 | N/A | Point | - | - | - | - | S268240 | JEFFERSON ST: MASON ST | - | F | F | - | F | 25486000 | 25486000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MASON ST | JEFFERSON ST | 96294 | 96294 | 37.80842106 | -122.41416443 | JEFFERSON ST \ MASON ST | MASON ST \ JEFFERSON ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | JEFFERSON ST intersection | - | FOR VEHICLES EXITING BOUDINS CAFE | - | - | - | - | - | 120318 | 1600775100000 | -122.41416443 | 37.80842106 | - | - | - | D3 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | 1600685280000 | MASON ST | - | - | - | - | - | - |
| 103028 | N/A | Point | - | - | - | - | S258395 | JEFFERSON ST: MASON ST | - | F | F | - | F | 25486000 | 25486000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | MASON ST | JEFFERSON ST | 88985 | 88985 | 37.80842106 | -122.41416443 | JEFFERSON ST \ MASON ST | MASON ST \ JEFFERSON ST | 1710539427000 | MTA | BIKE WAYFINDING SIGN | JEFFERSON ST intersection | 1320 | 12 FT NORTH OF GREEN | - | - | - | - | - | 120319 | 1336435200000 | -122.41416443 | 37.80842106 | - | 1603238400000 | - | D3 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | LIGHT POLE | IS | 1571319960000 | MASON ST | - | - | - | - | - | - |
| 103029 | N/A | Point | - | - | - | - | S234536 | JEFFERSON ST: MASON ST | - | T | T | - | F | 25486000 | 25486000 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | MASON ST | JEFFERSON ST | 69823 | 69823 | 37.80842106 | -122.41416443 | JEFFERSON ST \ MASON ST | MASON ST \ JEFFERSON ST | 1710539427000 | MTA | RA (WHITE ON BLUE) TSUNAMI | JEFFERSON ST intersection | - | CROSS ST IS BATTERY/SEC | - | - | - | - | - | 120320 | 1336435200000 | -122.41416443 | 37.80842106 | - | 1490054400000 | - | D3 | - | OTHER GUIDE | GUIDE | M5-1.0002 | 21X15 | SUP1 | LIGHT POLE | IS | 1490103660000 | MASON ST | - | - | - | - | - | - |
| 103030 | N/A | Point | - | - | - | - | S240983 | MASON ST: JEFFERSON ST | - | T | T | - | F | 25486000 | 25486000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MASON ST | JEFFERSON ST | 81351 | 81351 | 37.80842106 | -122.41416443 | JEFFERSON ST \ MASON ST | MASON ST \ JEFFERSON ST | 1710539427000 | MTA | 49 MILE SCENIC DRIVE | JEFFERSON ST intersection | 32 | - | - | - | - | - | - | 120321 | 1524492000000 | -122.41416443 | 37.80842106 | - | 1524441600000 | - | D3 | - | OTHER GUIDE | GUIDE | G-X(SF).0045 | 24X30 | SUP1 | LIGHT POLE | IS | 1511957640000 | MASON ST | - | - | - | - | - | - |
| 103031 | N/A | Point | - | - | - | - | S268239 | JEFFERSON ST: MASON ST | - | F | F | - | F | 25486000 | 25486000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MASON ST | JEFFERSON ST | 96293 | 96293 | 37.80842106 | -122.41416443 | JEFFERSON ST \ MASON ST | MASON ST \ JEFFERSON ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | JEFFERSON ST intersection | - | FOR VEHICLES EXITING BOUDINS CAFE | - | - | - | - | - | 120322 | 1600773360000 | -122.41416443 | 37.80842106 | - | - | - | D3 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | SIGNAL POLE | IS | 1600684980000 | MASON ST | - | - | - | - | - | - |
| 103032 | N/A | Point | - | - | - | - | S208117 | JEFFERSON ST: MASON ST | - | T | T | - | F | 25486000 | 25486000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MASON ST | JEFFERSON ST | 46664 | 46664 | 37.80842106 | -122.41416443 | JEFFERSON ST \ MASON ST | MASON ST \ JEFFERSON ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | JEFFERSON ST intersection | - | - | - | - | - | - | - | 120323 | - | -122.41416443 | 37.80842106 | - | - | - | D3 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | 1407322440000 | MASON ST | - | - | - | - | - | - |
| 103033 | N/A | Point | - | - | - | - | S268244 | JEFFERSON ST: MASON ST | - | F | F | - | F | 7456000 | 25486000 | - | - | NORTH WEST CORNER | - | - | - | - | MASON ST | JEFFERSON ST | 96580 | 96580 | 37.80842106 | -122.41416443 | - | MASON ST \ JEFFERSON ST | 1710539427000 | MTA | JEFFERSON ST | JEFFERSON ST intersection | - | 100 II <-- W | - | - | - | - | - | 120324 | 1601466600000 | -122.41416443 | 37.80842106 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-1.0921 | 36X08 | SUP1 | LIGHT POLE | IS | 1600686660000 | MASON ST | 101 - 200 JEFFERSON ST | - | - | - | TAYLOR ST | - |
| 103034 | N/A | Point | - | - | - | - | S205356 | KEARNY ST: BROADWAY | - | F | F | - | F | 24795000 | 24795000 | - | - | NORTH WEST CORNER | - | - | - | - | KEARNY ST | BROADWAY | 43534 | 43534 | 37.79801696 | -122.40547307 | BROADWAY \ KEARNY ST | KEARNY ST \ BROADWAY | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | BROADWAY intersection | - | - | - | - | - | - | - | 120325 | - | -122.40547307 | 37.79801696 | - | - | - | D3 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP1 | 2IN IRON POST | IS | 1398941100000 | KEARNY ST | - | - | - | - | - | - |
| 103035 | N/A | Point | - | - | - | - | S105452 | 24TH AVE: ANZA ST | - | F | F | - | F | 27536000 | 27536000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ANZA ST | ANZA ST | 3937 | 3937 | 37.77821431 | -122.4835254 | 24TH AVE \ ANZA ST | 24TH AVE \ ANZA ST | 1710539427000 | MTA | STOP | ANZA ST intersection | - | - | - | - | - | - | - | 120326 | 74822400000 | -122.4835254 | 37.77821431 | - | 1656979200000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | 24TH AVE | - | - | - | - | - | - |
| 103036 | N/A | Point | - | - | - | - | S283022 | ANZA ST: 24TH AVE | - | F | F | - | F | 27536000 | 27536000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ANZA ST | ANZA ST | 92202 | 92202 | 37.77821431 | -122.4835254 | 24TH AVE \ ANZA ST | 24TH AVE \ ANZA ST | 1710539427000 | MTA | STOP | ANZA ST intersection | - | - | - | - | - | - | - | 120327 | 1656979200000 | -122.4835254 | 37.77821431 | - | - | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1653475740000 | 24TH AVE | - | - | - | - | - | - |
| 103037 | N/A | Point | - | - | - | - | S273974 | EVANS AVE: JENNINGS ST \ MIDDL | - | F | F | - | F | 20177000 | 20177000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | EVANS AVE \ MIDDLE POINT RD | EVANS AVE \ MIDDLE POINT RD | 121935 | 121935 | 37.73768029 | -122.37910965 | JENNINGS ST \ EVANS AVE \ MIDDLE POINT RD | JENNINGS ST \ EVANS AVE \ MIDDLE POINT RD | 1710539427000 | MTA | (RA) TURNING VEHICLES YIELD (SYM) TO PED & BIKE (SYM) | EVANS AVE \ MIDDLE POINT RD intersection | - | - | - | - | - | - | - | 120328 | 1618586700000 | -122.37910965 | 37.73768029 | - | 1694766060000 | - | D10 | - | PEDESTRIAN | REG | R10-15.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1618399260000 | JENNINGS ST | - | - | - | - | - | - |
| 103038 | N/A | Point | - | - | - | - | S283023 | ANZA ST: 24TH AVE | - | F | F | - | F | 27536000 | 27536000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ANZA ST | ANZA ST | 92203 | 92203 | 37.77821431 | -122.4835254 | 24TH AVE \ ANZA ST | 24TH AVE \ ANZA ST | 1710539427000 | MTA | ALL WAY | ANZA ST intersection | - | - | - | - | - | - | - | 120329 | 1656979200000 | -122.4835254 | 37.77821431 | - | - | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1653475860000 | 24TH AVE | - | - | - | - | - | - |
| 103039 | N/A | Point | - | - | - | - | S268400 | 24TH AVE: ANZA ST | - | F | F | - | F | 27536000 | 27536000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ANZA ST | ANZA ST | 86313 | 86313 | 37.77821431 | -122.4835254 | 24TH AVE \ ANZA ST | 24TH AVE \ ANZA ST | 1710539427000 | MTA | AHEAD | ANZA ST intersection | - | - | - | - | - | - | - | 120330 | 74822400000 | -122.4835254 | 37.77821431 | - | 1601337600000 | - | D1 | - | OTHER WARNING | WARNING | W(SF).0106 | 18X06 | SUP2 | 2IN IRON POST | IS | 1600859460000 | 24TH AVE | - | - | - | - | - | - |
| 103040 | N/A | Point | - | - | - | - | S261836 | OTSEGO AVE: ONONDAGA AVE | - | F | F | - | F | 22076000 | 22076000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ONONDAGA AVE | ONONDAGA AVE | 110558 | 110558 | 37.72272567 | -122.44143062 | OTSEGO AVE \ ONONDAGA AVE | OTSEGO AVE \ ONONDAGA AVE | 1710539427000 | MTA | SPEED HUMPS | ONONDAGA AVE intersection | - | - | - | - | - | - | - | 120331 | 53049600000 | -122.44143062 | 37.72272567 | - | 1582761600000 | - | D11 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1582620600000 | OTSEGO AVE | - | - | - | - | - | - |
| 103041 | N/A | Point | 1 | 1 | 1 - 99 | - | S205699 | 1-99 ROOSEVELT WAY | 1-99 ROOSEVELT WAY | F | F | - | F | 11140000 | 11140000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 14TH ST \ ALPINE TER | 14TH ST \ ALPINE TER | 77597 | 77597 | 37.76677222 | -122.43761734 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | 14TH ST \ ALPINE TER to BUENA VISTA TER (1 - 99) | - | OPP#18 ROOSEVELT | - | - | - | - | - | 120332 | 1400081940000 | -122.43761734 | 37.76677222 | - | 1400025600000 | - | D8 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2 POST ALUMINUM | IS | 1399977960000 | ROOSEVELT WAY | 1 - 99 ROOSEVELT WAY | 1 - 99 ROOSEVELT WAY | 1 ROOSEVELT WAY | - | BUENA VISTA TER | BUENA VISTA TER |
| 103042 | N/A | Point | - | - | - | - | S273617 | SILVER AVE: PRINCETON ST | - | F | F | - | F | 20970000 | 20970000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SILVER AVE | SILVER AVE | 120069 | 120069 | 37.72891947 | -122.41617441 | PRINCETON ST \ SILVER AVE | PRINCETON ST \ SILVER AVE | 1718053783000 | middleware_editor | STOP AHEAD (SYM) | SILVER AVE intersection | - | - | - | - | - | - | - | 120333 | 1617099900000 | -122.41617441 | 37.72891947 | - | - | - | D9 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1617006240000 | PRINCETON ST | - | - | - | - | - | - |
| 103043 | N/A | Point | 1 | 1 | 100 - 150 | - | S258080 | 100-150 SURREY ST | 100-150 SURREY ST | F | F | - | F | 12299000 | 12299000 | - | - | EAST SIDE | - | - | - | - | DIAMOND ST | DIAMOND ST | 101546 | 101546 | 37.73595462 | -122.43470754 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | DIAMOND ST to THOR AVE (100 - 150) | - | 100 FT SOUTH OF DIAMOND 115 FENCE LINE | - | - | - | - | - | 120334 | 1222992000000 | -122.43470754 | 37.73595462 | - | 1571443200000 | - | D8 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1569935940000 | SURREY ST | 100 - 150 SURREY ST | 100 - 150 SURREY ST | 100 SURREY ST | - | THOR AVE | THOR AVE |
| 103044 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S119444 | 1100-1199 CASTRO ST | 1100-1199 CASTRO ST | T | T | - | F | 3799000 | 3799000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 23RD ST | 23RD ST | 80350 | 80350 | 37.7524917 | -122.43420127 | - | - | 1741805125000 | middleware_editor | STOP AHEAD (SYM) | 23RD ST to ELIZABETH ST (1100 - 1199) | - | INFO #1113 | - | - | - | - | - | 120335 | 1095404400000 | -122.43420127 | 37.7524917 | - | - | - | D8 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373573640000 | CASTRO ST | 1100 - 1199 CASTRO ST | 1100 - 1199 CASTRO ST | 1100 CASTRO ST | - | ELIZABETH ST | ELIZABETH ST |
| 103045 | N/A | Point | 1 | 1 | 1 - 99 | - | S287702 | 1-99 WALNUT ST | 1-99 WALNUT ST | T | T | - | F | 13381000 | 13381000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | PACIFIC AVE | PACIFIC AVE | 108666 | 108666 | 37.79104805 | -122.44927845 | - | - | 1734383168000 | middleware_editor | STOP AHEAD (SYM) | PACIFIC AVE to JACKSON ST (1 - 99) | - | NPL# 33 WANUT ST | - | - | - | - | - | 120336 | 1681862400000 | -122.44927845 | 37.79104805 | - | - | - | D2 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1677159420000 | WALNUT ST | 1 - 99 WALNUT ST | 1 - 99 WALNUT ST | 1 WALNUT ST | - | JACKSON ST | JACKSON ST |
| 103046 | N/A | Point | 1 | 1 | 2400 - 2448 | - | S281083 | 2400-2449 SAN JOSE AVE | 2400-2448 SAN JOSE AVE | T | T | - | F | 11459000 | 11459000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | NIAGARA AVE | NIAGARA AVE | 128377 | 128377 | 37.71920278 | -122.44775674 | - | - | 1712244105000 | middleware_editor | STOP AHEAD (SYM) | NIAGARA AVE to SHAWNEE AVE (2400 - 2448) | - | 340 FT SOUTH NEXT TO FENCE OF OVERPASS | - | - | - | - | - | 120337 | 1649116800000 | -122.44775674 | 37.71920278 | - | - | - | D11 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | MUNI POLE | IS | 1645620000000 | SAN JOSE AVE | 2400 - 2448 SAN JOSE AVE | 2400 - 2448 SAN JOSE AVE | 2400 SAN JOSE AVE | - | SHAWNEE AVE | SHAWNEE AVE |
| 103047 | N/A | Point | 1 | 1 | 3600 - 3699 | - | S288096 | 3600-3699 21ST ST | 3600-3699 21ST ST | F | F | - | F | 1120000 | 1120000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | CHURCH ST | CHURCH ST | 107221 | 107221 | 37.75642708 | -122.42900341 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | CHURCH ST to SANCHEZ ST (3600 - 3699) | - | EPL 3676 | - | - | - | - | - | 120338 | 1678924800000 | -122.42900341 | 37.75642708 | - | - | - | D8 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1678888500000 | 21ST ST | 3600 - 3699 21ST ST | 3600 - 3699 21ST ST | 3600 21ST ST | - | SANCHEZ ST | SANCHEZ ST |
| 103048 | N/A | Point | 1 | 1 | 4100 - 4199 | - | S218112 | 4100-4199 ORTEGA ST | 4100-4199 ORTEGA ST | F | F | - | F | 10037000 | 10037000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 48TH AVE | 48TH AVE | 58982 | 58982 | 37.75098574 | -122.50780144 | - | - | 1729301743000 | middleware_editor | STOP AHEAD (SYM) | 48TH AVE to GREAT HWY (4100 - 4199) | - | OPP.WPL#4146 | - | - | - | - | - | 120339 | 1438863960000 | -122.50780144 | 37.75098574 | - | 1438819200000 | - | D4 | - | OTHER WARNING | WARNING | W3-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1437654420000 | ORTEGA ST | 4100 - 4199 ORTEGA ST | 4100 - 4199 ORTEGA ST | 4100 ORTEGA ST | - | GREAT HWY | GREAT HWY |
| 103049 | N/A | Point | 1 | 1 | 100 - 199 | - | S287703 | 100-199 SPRUCE ST | 100-199 SPRUCE ST | T | T | - | F | 12058000 | 12058000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | JACKSON ST | JACKSON ST | 108667 | 108667 | 37.78953948 | -122.45403267 | - | - | 1751046534000 | middleware_editor | STOP AHEAD (SYM) | JACKSON ST to WASHINGTON ST (100 - 199) | - | SPL# 100 | - | - | - | - | - | 120340 | 1681887600000 | -122.45403267 | 37.78953948 | - | - | - | D2 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1677159720000 | SPRUCE ST | 100 - 199 SPRUCE ST | 100 - 199 SPRUCE ST | 100 SPRUCE ST | - | WASHINGTON ST | WASHINGTON ST |
| 103050 | N/A | Point | 1 | 1 | 700 - 799 | - | S272825 | 700-799 AVALON AVE | 700-799 AVALON AVE | F | F | - | F | 2562000 | 2562000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | VIENNA ST | VIENNA ST | 121785 | 121785 | 37.72495558 | -122.42650228 | - | - | 1715305225000 | middleware_editor | STOP AHEAD (SYM) | VIENNA ST to ATHENS ST (700 - 799) | - | EPL# 725 | - | - | - | - | - | 120341 | 1527724800000 | -122.42650228 | 37.72495558 | - | 1617148800000 | - | D11 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1614760920000 | AVALON AVE | 700 - 799 AVALON AVE | 700 - 799 AVALON AVE | 700 AVALON AVE | - | ATHENS ST | ATHENS 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.