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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101551 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S140897 | 2500-2599 CABRILLO ST | 2500-2599 CABRILLO ST | F | F | - | F | 3493000 | 3493000 | - | - | NORTH SIDE | - | - | - | - | 26TH AVE | 26TH AVE | 34621 | 34621 | 37.77436325 | -122.48593296 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM 2ND & 4TH THUR OF MONTH STCL | 26TH AVE to 27TH AVE (2500 - 2599) | - | 2512 CABRILLO | - | - | - | - | - | 118829 | 1221091200000 | -122.48593296 | 37.77436325 | - | 1704456840000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0073 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375725540000 | CABRILLO ST | 2500 - 2599 CABRILLO ST | 2500 - 2599 CABRILLO ST | 2500 CABRILLO ST | - | 27TH AVE | 27TH AVE |
| 101552 | N/A | Point | - | - | - | - | S110101 | 27TH AVE: CABRILLO ST | - | F | F | - | F | 27526000 | 27526000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 27TH AVE | 5382 | 5382 | 37.77433877 | -122.48646865 | 27TH AVE \ CABRILLO ST | CABRILLO ST \ 27TH AVE | 1739888508000 | middleware_editor | STOP | 27TH AVE intersection | - | - | - | - | - | - | - | 118830 | 593654400000 | -122.48646865 | 37.77433877 | - | 1739540160000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570700000 | CABRILLO ST | - | - | - | - | - | - |
| 101553 | N/A | Point | - | - | - | - | S276755 | CABRILLO ST: 27TH AVE | - | F | F | - | F | 27526000 | 27526000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 27TH AVE | 106021 | 106021 | 37.77433877 | -122.48646865 | 27TH AVE \ CABRILLO ST | CABRILLO ST \ 27TH AVE | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | 27TH AVE intersection | - | 9 FT AND 24 FT FROM CURB | - | - | - | - | - | 118831 | 101088000000 | -122.48646865 | 37.77433877 | - | 1631664000000 | - | D1 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1627894620000 | CABRILLO ST | - | - | - | - | - | - |
| 101554 | N/A | Point | - | - | - | - | S124608 | CABRILLO ST: 27TH AVE | - | F | F | - | F | 27526000 | 27526000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 27TH AVE | 106397 | 106397 | 37.77433877 | -122.48646865 | 27TH AVE \ CABRILLO ST | CABRILLO ST \ 27TH AVE | 1710539427000 | MTA | ALL WAY | 27TH AVE intersection | - | - | - | - | - | - | - | 118832 | 1153872000000 | -122.48646865 | 37.77433877 | - | 1677801600000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1373575260000 | CABRILLO ST | - | - | - | - | - | - |
| 101555 | N/A | Point | - | - | - | - | S200091 | CABRILLO ST: 27TH AVE | - | F | F | - | F | 27526000 | 27526000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 27TH AVE | 45022 | 45022 | 37.77433877 | -122.48646865 | 27TH AVE \ CABRILLO ST | CABRILLO ST \ 27TH AVE | 1739888594000 | middleware_editor | STOP | 27TH AVE intersection | - | NE OF 28TH AVE | - | - | - | - | - | 118833 | - | -122.48646865 | 37.77433877 | - | 1739539920000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1378204620000 | CABRILLO ST | - | - | - | - | - | - |
| 101556 | N/A | Point | - | - | - | - | S124609 | 27TH AVE: CABRILLO ST | - | F | F | - | F | 27526000 | 27526000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 27TH AVE | 16605 | 16605 | 37.77433877 | -122.48646865 | 27TH AVE \ CABRILLO ST | CABRILLO ST \ 27TH AVE | 1710539427000 | MTA | ALL WAY | 27TH AVE intersection | - | - | - | - | - | - | - | 118834 | 1153872000000 | -122.48646865 | 37.77433877 | - | 1677801600000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575260000 | CABRILLO ST | - | - | - | - | - | - |
| 101557 | N/A | Point | - | - | - | - | S105645 | CABRILLO ST: 27TH AVE | - | F | F | - | F | 27526000 | 27526000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 27TH AVE | 109775 | 109775 | 37.77433877 | -122.48646865 | 27TH AVE \ CABRILLO ST | CABRILLO ST \ 27TH AVE | 1739888497000 | middleware_editor | STOP | 27TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 118835 | 91411200000 | -122.48646865 | 37.77433877 | - | 1739540640000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569320000 | CABRILLO ST | - | - | - | - | - | - |
| 101558 | N/A | Point | - | - | - | - | S124610 | 27TH AVE: CABRILLO ST | - | F | F | - | F | 27526000 | 27526000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 27TH AVE | 19742 | 19742 | 37.77433877 | -122.48646865 | 27TH AVE \ CABRILLO ST | CABRILLO ST \ 27TH AVE | 1710539427000 | MTA | ALL WAY | 27TH AVE intersection | - | - | - | - | - | - | - | 118836 | 1153872000000 | -122.48646865 | 37.77433877 | - | 1677801600000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575260000 | CABRILLO ST | - | - | - | - | - | - |
| 101559 | N/A | Point | - | - | - | - | S105392 | WINFIELD ST: AZTEC ST \ COSO A | - | F | F | - | F | 4454000 | 21280000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PROSPECT AVE | AZTEC ST \ COSO AVE | 1885 | 1885 | 37.74543914 | -122.41655911 | - | WINFIELD ST \ AZTEC ST \ COSO AVE | 1710539427000 | MTA | ONE WAY (LA) | AZTEC ST \ COSO AVE intersection | - | 0 / MADE WINFIELD ONE-WAY SB COSO-E..... | - | - | - | - | - | 118837 | 70588800000 | -122.41655911 | 37.74543914 | - | - | - | D9 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | UNKNOWN | IS | 1373569200000 | WINFIELD ST | 101 - 199 COSO AVE | - | - | - | AZTEC ST \ WINFIELD ST | - |
| 101560 | N/A | Point | - | - | - | - | S276753 | CABRILLO ST: 27TH AVE | - | F | F | - | F | 27526000 | 27526000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 27TH AVE | 111710 | 111710 | 37.77433877 | -122.48646865 | 27TH AVE \ CABRILLO ST | CABRILLO ST \ 27TH AVE | 1710539427000 | MTA | SLOW STREETS FAMILY, H/C, PED, SKATEBOARD, BIKE (SYM)(COMBO) | 27TH AVE intersection | - | 15 FT AND 21 FT FROM CURB | - | - | - | - | - | 118838 | 1681257600000 | -122.48646865 | 37.77433877 | - | 1631664000000 | - | D1 | - | OTHER REGULATORY | REG | R(SF).0451 | 12X36 | SUP2 | CITY POST EMBEDDED ACHOR CUP 4 | IS | 1627894320000 | CABRILLO ST | - | - | - | - | - | - |
| 101561 | N/A | Point | - | - | - | - | S276752 | CABRILLO ST: 27TH AVE | - | F | F | - | F | 27526000 | 27526000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 27TH AVE | 111709 | 111709 | 37.77433877 | -122.48646865 | 27TH AVE \ CABRILLO ST | CABRILLO ST \ 27TH AVE | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | 27TH AVE intersection | - | 9 FT AND 24 FT FROM CURB | - | - | - | - | - | 118839 | 101088000000 | -122.48646865 | 37.77433877 | - | 1631664000000 | - | D1 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1627894200000 | CABRILLO ST | - | - | - | - | - | - |
| 101562 | N/A | Point | - | - | - | - | S226188 | NORTH POINT ST: BAKER ST | - | F | F | - | F | 27016000 | 27016000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BAKER ST | BAKER ST | 65597 | 65597 | 37.80235294 | -122.44672315 | NORTH POINT ST \ BAKER ST | NORTH POINT ST \ BAKER ST | 1738008134000 | middleware_editor | PEDESTRIAN (SYM) | BAKER ST intersection | - | - | - | - | - | - | - | 118840 | 1465218480000 | -122.44672315 | 37.80235294 | - | 1465171200000 | - | D2 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1464959520000 | NORTH POINT ST | - | - | - | - | - | - |
| 101563 | N/A | Point | - | - | - | - | S225058 | CLEARFIELD DR: EUCALYPTUS DR | - | F | F | - | F | 23304000 | 23304000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | EUCALYPTUS DR | EUCALYPTUS DR | 63083 | 63083 | 37.73070362 | -122.49134536 | CLEARFIELD DR \ EUCALYPTUS DR | CLEARFIELD DR \ EUCALYPTUS DR | 1710539427000 | MTA | PEDESTRIAN (SYM) | EUCALYPTUS DR intersection | - | IFO#151 (SEE PAINT) | - | - | - | - | - | 118841 | 1462876740000 | -122.49134536 | 37.73070362 | - | 1462838400000 | - | D7 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1461326280000 | CLEARFIELD DR | - | - | - | - | - | - |
| 101564 | N/A | Point | 1 | 1 | 900 - 999 | - | S229134 | 900-999 SOUTH VAN NESS AVE | 900-999 SOUTH VAN NESS AVE | F | F | - | F | 12027000 | 12027000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 20TH ST | 20TH ST | 127772 | 127772 | 37.75796544 | -122.41679604 | - | - | 1710539427000 | MTA | MISSION-BARTLETT (RA) | 20TH ST to 21ST ST (900 - 999) | - | SPL #986 "BARNEY'S AUTO" | - | - | - | - | - | 118842 | 1007769600000 | -122.41679604 | 37.75796544 | - | 1474848000000 | - | D9 | - | OTHER GUIDE | GUIDE | G-M(SF).0015 | 30X30 | SUP2 | MUNI POLE | IS | 1474546680000 | SOUTH VAN NESS AVE | 900 - 999 SOUTH VAN NESS AVE | 900 - 999 SOUTH VAN NESS AVE | 900 SOUTH VAN NESS AVE | - | 21ST ST | 21ST ST |
| 101565 | N/A | Point | 1 | 1 | 2100 - 2199 | - | S222134 | 2100-2199 BUCHANAN ST | 2100-2199 BUCHANAN ST | F | F | - | F | 3340000 | 3340000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 57378 | 57378 | 37.78978828 | -122.43064391 | - | - | 1741968494000 | middleware_editor | SIGNAL AHEAD (SYM) | CALIFORNIA ST to SACRAMENTO ST (2100 - 2199) | - | NPL# 2141 BUCHANAN ST. | - | - | - | - | - | 118843 | - | -122.43064391 | 37.78978828 | - | - | - | D2 | - | OTHER WARNING | WARNING | W3-3.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1452695220000 | BUCHANAN ST | 2100 - 2199 BUCHANAN ST | 2100 - 2199 BUCHANAN ST | 2100 BUCHANAN ST | - | SACRAMENTO ST | SACRAMENTO ST |
| 101566 | N/A | Point | - | - | - | - | S226415 | SANSOME ST: WASHINGTON ST | - | T | T | - | F | 24711000 | 24711000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 62873 | 62873 | 37.79571938 | -122.40167603 | SANSOME ST \ WASHINGTON ST | SANSOME ST \ WASHINGTON ST | 1727212089000 | middleware_editor | TWO WAY TRAFFIC (SYM) | WASHINGTON ST intersection | - | - | - | - | - | - | - | 118844 | 1145404800000 | -122.40167603 | 37.79571938 | - | - | 1727186820000 | D3 | - | OTHER WARNING | WARNING | W6-3.0002 | 30X30 | SUP1 | LIGHT POLE | RETD | 1465467720000 | SANSOME ST | - | - | - | - | - | - |
| 101567 | N/A | Point | - | - | - | - | S225047 | DOLORES TER: DOLORES ST | - | F | F | - | F | 25702000 | 25702000 | - | - | NORTH EAST CORNER | - | - | - | - | DOLORES TER | DOLORES TER | 63666 | 63666 | 37.76263136 | -122.42610427 | DOLORES ST \ DOLORES TER | DOLORES ST \ DOLORES TER | 1710539427000 | MTA | DEAD END | DOLORES TER intersection | - | OF DOLORES TER. & DOLORES ST. | - | - | - | - | - | 118845 | 1461927720000 | -122.42610427 | 37.76263136 | - | 1461888000000 | - | D8 | - | OTHER WARNING | WARNING | W14-1.0001 | 24X24 | SUP2 | LIGHT POLE | IS | 1461309120000 | DOLORES ST | - | - | - | - | - | - |
| 101568 | N/A | Point | - | - | - | - | S229953 | MINNESOTA ST: 24TH ST | - | F | F | - | F | 23610000 | 23610000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 66665 | 66665 | 37.75399972 | -122.38985955 | MINNESOTA ST \ 24TH ST | MINNESOTA ST \ 24TH ST | 1710539427000 | MTA | (45 LA-DN) | 24TH ST intersection | - | @24TH ST / 15' SOUTH OF NPL #1278 | - | - | - | - | - | 118846 | 1477649220000 | -122.38985955 | 37.75399972 | - | 1477612800000 | - | D10 | - | OTHER WARNING | WARNING | W16-7P.0001 | 18X18 | SUP1 | 2IN IRON POST | IS | 1476875400000 | MINNESOTA ST | - | - | - | - | - | - |
| 101569 | N/A | Point | - | - | - | - | S225591 | TARAVAL ST: 36TH AVE | - | F | F | - | F | 12411000 | 23377000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | 35TH AVE | 36TH AVE | 62708 | 62708 | 37.74224865 | -122.49390704 | - | TARAVAL ST \ 36TH AVE | 1722648569000 | middleware_editor | TYPE K | 36TH AVE intersection | - | E-TIP ISLAND | - | - | - | - | - | 118847 | 1475754960000 | -122.49390704 | 37.74224865 | - | 1594598400000 | - | D4 | - | OTHER WARNING | WARNING | TYPE-K(CA).0001 | 05X12 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1463054100000 | TARAVAL ST | 2500 - 2599 TARAVAL ST | - | - | - | 36TH AVE | - |
| 101570 | N/A | Point | 1 | 1 | 600 - 699 | - | S273748 | 600-699 TOWNSEND ST | 600-699 TOWNSEND ST | F | F | - | F | 12666000 | 12666000 | - | - | NORTH SIDE | - | - | - | - | 7TH ST | 07TH ST | 123417 | 123417 | 37.77094 | -122.40276719 | - | - | 1755527402000 | jsanfel | TRUQIT CAR SHARE | 07TH ST to 08TH ST (600 - 699) | - | 125 FT EAST OF 8TH ST OPP 681 | - | - | - | - | - | 118848 | 1414047600000 | -122.40276719 | 37.77094 | - | 1620025200000 | - | D10 | - | OTHER GUIDE | GUIDE | G-T(SF).0068 | 05X12 | SUP1 | 2IN IRON POST | IS | 1617266880000 | TOWNSEND ST | 600 - 699 TOWNSEND ST | 600 - 699 TOWNSEND ST | 600 TOWNSEND ST | - | 08TH ST | 08TH ST |
| 101571 | N/A | Point | - | - | - | - | S268347 | 26TH AVE: SEACLIFF AVE | - | F | F | - | F | 27671000 | 27671000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SEACLIFF AVE | 26TH AVE | 87695 | 87695 | 37.78877033 | -122.48701841 | 26TH AVE \ SEACLIFF AVE | SEACLIFF AVE \ 26TH AVE | 1710539427000 | MTA | TYPE P RIGHT | 26TH AVE intersection | - | PLANTER BOX | - | - | - | - | - | 118849 | 1149811200000 | -122.48701841 | 37.78877033 | - | 1600905600000 | - | D2 | - | OTHER WARNING | WARNING | TYPE-P(CA).0002 | 12X36 | SUP1 | UNISTRUT | IS | 1600778760000 | SEACLIFF AVE | - | - | - | - | - | - |
| 101572 | N/A | Point | - | - | - | - | S225061 | CLEARFIELD DR: EUCALYPTUS DR | - | F | F | - | F | 23304000 | 23304000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | EUCALYPTUS DR | EUCALYPTUS DR | 62440 | 62440 | 37.73070362 | -122.49134536 | CLEARFIELD DR \ EUCALYPTUS DR | CLEARFIELD DR \ EUCALYPTUS DR | 1710539427000 | MTA | (45 LA-DN) | EUCALYPTUS DR intersection | - | (SEE PAINT) | - | - | - | - | - | 118850 | - | -122.49134536 | 37.73070362 | - | - | - | D7 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | 2IN IRON POST | IS | 1461326880000 | CLEARFIELD DR | - | - | - | - | - | - |
| 101573 | N/A | Point | - | - | - | - | S227757 | RIVERA ST: 42ND AVE | - | F | F | - | F | 11076000 | 23476000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 42ND AVE | 42ND AVE | 67053 | 67053 | 37.7456243489439 | -122.500733407098 | - | RIVERA ST \ 42ND AVE | 1740419311000 | middleware_editor | (45 LA-DN) | 42ND AVE intersection | - | - | - | - | - | - | - | 118851 | 1123804800000 | -122.50059751 | 37.74569198 | - | - | - | D4 | - | OTHER WARNING | WARNING | W16-7P.0001 | 18X18 | SUP2 | 2IN IRON POST | IS | 1470311520000 | RIVERA ST | 3200 - 3299 RIVERA ST | - | - | - | 43RD AVE | - |
| 101574 | N/A | Point | - | - | - | - | S225282 | 2ND AVE: HUGO ST | - | F | F | - | F | 27070000 | 27070000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 2ND AVE | 02ND AVE | 63898 | 63898 | 37.76530432 | -122.45888053 | HUGO ST \ 2ND AVE | HUGO ST \ 02ND AVE | 1710539427000 | MTA | (RA) BIKE (SYM) UCSF GARAGE | 02ND AVE intersection | #0026 | 2IN EXT NEEDED | - | - | - | - | - | 118852 | 1462892940000 | -122.45888053 | 37.76530432 | - | 1462838400000 | - | D5 | - | OTHER GUIDE | GUIDE | D11-1C.0004 | 30X08 | SUP1 | 2IN IRON POST | IS | 1462272780000 | HUGO ST | - | - | - | - | - | - |
| 101575 | N/A | Point | - | - | - | - | S227224 | TWIN PEAKS BLVD: CHRISTMAS TRE | - | F | F | - | F | 26223000 | 26223000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | TWIN PEAKS BLVD | CHRISTMAS TREE POINT RD | 67270 | 67270 | 37.75404289 | -122.44720983 | CHRISTMAS TREE POINT RD \ TWIN PEAKS BLVD | TWIN PEAKS BLVD \ CHRISTMAS TREE POINT RD | 1710539427000 | MTA | PEDESTRIAN (SYM) | CHRISTMAS TREE POINT RD intersection | - | 60`EAST SEE DRAWING (#12) | - | - | - | - | - | 118853 | 1468424340000 | -122.44720983 | 37.75404289 | - | 1468368000000 | - | D7 | - | OTHER WARNING | WARNING | W11-2.0001 | 18X18 | SUP2 | 2IN IRON POST | IS | 1468331820000 | TWIN PEAKS BLVD | - | - | - | - | - | - |
| 101576 | N/A | Point | - | - | - | - | S227210 | INNES AVE: HUNTERS POINT BLVD | - | F | F | - | F | 33138000 | 33138000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | HUNTERS POINT BLVD | HUNTERS POINT BLVD | 63772 | 63772 | 37.73249613 | -122.37663804 | INNES AVE \ HUNTERS POINT BLVD | INNES AVE \ HUNTERS POINT BLVD | 1710539427000 | MTA | AHEAD | HUNTERS POINT BLVD intersection | 172585 | EPL#950 | - | - | - | - | - | 118854 | 1071100800000 | -122.37663804 | 37.73249613 | - | 1469491200000 | - | D10 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP1 | 2IN IRON POST | IS | 1468321200000 | INNES AVE | - | - | - | - | - | - |
| 101577 | N/A | Point | - | - | - | - | S226417 | SANSOME ST: WASHINGTON ST | - | T | T | - | F | 24711000 | 24711000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 62875 | 62875 | 37.79571938 | -122.40167603 | SANSOME ST \ WASHINGTON ST | SANSOME ST \ WASHINGTON ST | 1727212120000 | middleware_editor | TWO WAY TRAFFIC (SYM) | WASHINGTON ST intersection | - | - | - | - | - | - | - | 118855 | 1145404800000 | -122.40167603 | 37.79571938 | - | - | 1727186880000 | D3 | - | OTHER WARNING | WARNING | W6-3.0003 | 36X36 | SUP1 | LIGHT POLE | RETD | 1465468140000 | SANSOME ST | - | - | - | - | - | - |
| 101578 | N/A | Point | - | - | - | - | S225060 | CLEARFIELD DR: EUCALYPTUS DR | - | F | F | - | F | 23304000 | 23304000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | EUCALYPTUS DR | EUCALYPTUS DR | 124782 | 124782 | 37.73070362 | -122.49134536 | CLEARFIELD DR \ EUCALYPTUS DR | CLEARFIELD DR \ EUCALYPTUS DR | 1710539427000 | MTA | PEDESTRIAN (SYM) | EUCALYPTUS DR intersection | - | SEE PAINT MARK | - | - | - | - | - | 118856 | 1462886640000 | -122.49134536 | 37.73070362 | - | 1462838400000 | - | D7 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1461326700000 | CLEARFIELD DR | - | - | - | - | - | - |
| 101579 | N/A | Point | - | - | - | - | S117196 | PERU AVE: MADRID ST | - | F | F | - | F | 21681000 | 21681000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PERU AVE | PERU AVE | 126735 | 126735 | 37.72784593 | -122.42811583 | MADRID ST \ PERU AVE | MADRID ST \ PERU AVE | 1751387462000 | middleware_editor | STOP | PERU AVE intersection | - | - | - | - | - | - | - | 118857 | 1057820400000 | -122.42811583 | 37.72784593 | - | 1751308500000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373572920000 | MADRID ST | - | - | - | - | - | - |
| 101580 | N/A | Point | - | - | - | - | 23549 | - | - | F | F | - | F | 886000 | - | - | - | NORTH SIDE | 1693256597000 | jrasmuss | - | - | OAKWOOD ST | - | 152385 | 152385 | 37.7615075519925 | -122.425777050352 | - | - | 1752776797000 | middleware_editor | BIKE RACK | - | - | 23' E OF DOLORES/CORRAL/3.5 FROM CURB | - | - | - | - | - | 118858 | 1701973800000 | - | - | - | 1752689700000 | - | 08 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP3 | BIKE RACK | IS | - | 18TH ST | 3652 - 3699 18TH ST | - | - | - | DOLORES ST | - |
| 101581 | N/A | Point | - | - | - | - | 23550 | - | - | F | F | - | F | 886000 | - | - | - | - | 1693256650000 | jrasmuss | - | - | OAKWOOD ST | - | 152371 | 152371 | 37.7615100470692 | -122.425734368378 | - | - | 1752776822000 | middleware_editor | BIKE RACK | - | - | 26' E OF DOLORES/CORRAL/35' FROM CURB | - | - | - | - | - | 118859 | 1701975600000 | - | - | - | 1752693300000 | - | 08 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP3 | BIKE RACK | IS | - | 18TH ST | 3652 - 3699 18TH ST | - | - | - | DOLORES ST | - |
| 101582 | N/A | Point | - | - | - | - | 23553 | - | - | F | F | - | F | 886000 | - | - | - | NORTH SIDE | 1693256916000 | jrasmuss | - | - | OAKWOOD ST | - | 152372 | 152372 | 37.7615180347185 | -122.425597727826 | - | - | 1722531702000 | middleware_editor | BIKE RACK | - | - | 35' E OF DOLORES/CORRAL/3.5' FROM CURB | - | - | - | - | - | 118860 | - | - | - | - | - | - | 08 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP3 | BIKE RACK | IS | - | 18TH ST | 3652 - 3699 18TH ST | - | - | - | DOLORES ST | - |
| 101583 | N/A | Point | - | - | - | - | 23551 | - | - | F | F | - | F | 886000 | - | - | - | - | 1693256700000 | jrasmuss | - | - | OAKWOOD ST | - | 152339 | 152339 | 37.7615124553892 | -122.425693170505 | - | - | 1722531702000 | middleware_editor | BIKE RACK | - | - | - | - | - | - | - | - | 118861 | - | - | - | - | - | - | 08 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP3 | BIKE RACK | IS | - | 18TH ST | 3652 - 3699 18TH ST | - | - | - | DOLORES ST | - |
| 101584 | N/A | Point | - | - | - | - | 23548 | - | - | F | F | - | F | - | - | - | - | NORTH SIDE | 1693256556000 | jrasmuss | - | - | - | - | 152370 | 152370 | 37.761504157 | -122.425835106 | - | - | 1752776810000 | middleware_editor | BIKE RACK | - | - | 20'E OF DOLORES/ CORRAL/ 3.5' FROM CURB | - | - | - | - | - | 118862 | 1701979800000 | - | - | - | 1752695100000 | - | 08 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP3 | BIKE RACK | IS | - | 18TH ST | - | - | - | - | - | - |
| 101585 | N/A | Point | - | - | - | - | 23552 | - | - | F | F | - | F | 886000 | - | - | - | NORTH SIDE | 1693256870000 | jrasmuss | - | - | OAKWOOD ST | - | 152401 | 152401 | 37.7615152623503 | -122.425645153285 | - | - | 1722531702000 | middleware_editor | BIKE RACK | - | - | 32' E OF DOLORES/CORRAL/3/5' IN FROM CURB | - | - | - | - | - | 118863 | - | - | - | - | - | - | 08 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP3 | BIKE RACK | IS | - | 18TH ST | 3652 - 3699 18TH ST | - | - | - | DOLORES ST | - |
| 101586 | N/A | Point | - | - | - | - | 23555 | - | - | - | - | - | - | 886000 | - | - | - | NORTH SIDE | 1693257970000 | jrasmuss | - | - | OAKWOOD ST | - | 152402 | 152402 | 37.7615088206781 | -122.42575534761 | - | - | 1722531702000 | middleware_editor | WHEEL STOP | - | - | 38' E OF DOLORES/CORRAL | - | - | - | - | - | 118864 | - | - | - | - | - | - | 08 | - | OTHER WARNING | WARNING | W(SF).0072 | 36X08 | SUP3 | - | IS | - | 18TH ST | 3652 - 3699 18TH ST | - | - | - | DOLORES ST | - |
| 101587 | N/A | Point | - | - | - | - | 23554 | - | - | - | - | - | - | 886000 | - | - | - | - | 1693257923000 | jrasmuss | - | - | OAKWOOD ST | - | 152373 | 152373 | 37.7615042752896 | -122.425833103195 | - | - | 1722531702000 | middleware_editor | WHEEL STOP | - | - | 16' E OF DOLORES/CORRAL | - | - | - | - | - | 118865 | - | - | - | - | - | - | 08 | - | OTHER WARNING | WARNING | W(SF).0072 | 36X08 | SUP3 | - | IS | - | 18TH ST | 3652 - 3699 18TH ST | - | - | - | DOLORES ST | - |
| 101588 | N/A | Point | - | - | - | - | S205583 | BUSH ST: FRANKLIN ST | - | T | T | - | F | 26498000 | 26498000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 45508 | 45508 | 37.78827973 | -122.42359407 | BUSH ST \ FRANKLIN ST | BUSH ST \ FRANKLIN ST | 1710539427000 | MTA | FRANKLIN ST | FRANKLIN ST intersection | - | - | - | - | - | - | - | 118866 | - | -122.42359407 | 37.78827973 | - | - | - | D2 | - | STREET NAME | GUIDE | D3-2.0159 | 72X18 | SUP1 | LIGHT POLE | IS | 1399556460000 | BUSH ST | - | - | - | - | - | - |
| 101589 | N/A | Point | - | - | - | - | 24441 | - | - | F | F | - | F | 8046201 | - | - | - | WEST SIDE | 1696371418000 | evillan | - | - | CLEARFIELD DR | - | 160164 | 160164 | 37.7302776368092 | -122.48941101114 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | - | - | IN BETWEEN NEW ISLANDS FOR BIKE LANE | - | - | - | - | 10 | 118867 | 1705930200000 | - | - | - | - | - | 07 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP3 | DELINEATOR BASE SAFE HIT | IS | - | - | 401 - 599 LAKE MERCED BLVD | - | - | - | MIDDLEFIELD DR | - |
| 101590 | N/A | Point | - | - | - | - | S253842 | MONTEREY BLVD: SAN BENITO WAY | - | F | F | - | F | 22911000 | 22911000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MONTEREY BLVD | SAN BENITO WAY | 80370 | 80370 | 37.73309214 | -122.46699849 | SAN BENITO WAY \ MONTEREY BLVD | MONTEREY BLVD \ SAN BENITO WAY | 1710539427000 | MTA | (LA) WHITE ON GREEN | SAN BENITO WAY intersection | 0663 | ON TOP OF STOP SIGN | - | - | - | - | - | 118868 | 1560781080000 | -122.46699849 | 37.73309214 | - | - | - | D7 | - | OTHER GUIDE | GUIDE | M7-1.0002 | 12X09 | SUP2 | 2IN IRON POST | IS | 1556540640000 | MONTEREY BLVD | - | - | - | - | - | - |
| 101591 | N/A | Point | - | - | - | - | S271526 | LOOMIS ST: OAKDALE AVE | - | F | F | - | F | 20813000 | 20813000 | - | - | SOUTH EAST CORNER | - | - | - | - | OAKDALE AVE | LOOMIS ST | 91417 | 91417 | 37.74252073 | -122.40430629 | LOOMIS ST \ OAKDALE AVE | OAKDALE AVE \ LOOMIS ST | 1744122004000 | middleware_editor | LOOMIS ST | LOOMIS ST intersection | - | 100BLK | - | - | - | - | - | 118869 | - | -122.40430629 | 37.74252073 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.1064 | 36X08 | SUP1 | LIGHT POLE | IS | 1610622420000 | OAKDALE AVE | - | - | - | - | - | - |
| 101592 | N/A | Point | 1 | 1 | 345 - 399 | - | S237176 | 345-399 GOUGH ST | 345-399 GOUGH ST | F | F | - | F | 6318000 | 6318000 | - | - | WEST SIDE | - | - | - | - | LINDEN ST | LINDEN ST | 73308 | 73308 | 37.77664967 | -122.42293043 | - | - | 1710539427000 | MTA | 2HR PRK 9AM-6PM EXC SUN | LINDEN ST to HAYES ST (345 - 399) | - | 100' N OFLINDEN | - | - | - | - | - | 118870 | 1499355300000 | -122.42293043 | 37.77664967 | - | 1537142400000 | - | D5 | - | PARKING | REG | R32(CA).0114 | 18X18 | SUP1 | LIGHT POLE | IS | 1498735800000 | GOUGH ST | 345 - 399 GOUGH ST | 345 - 399 GOUGH ST | 345 GOUGH ST | - | HAYES ST | HAYES ST |
| 101593 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S138070 | 2200-2299 MISSION ST | 2200-2299 MISSION ST | F | F | - | F | 9120000 | 9120000 | - | - | EAST SIDE | - | - | - | - | 18TH ST | 18TH ST | 28772 | 28772 | 37.76103561 | -122.41928266 | - | - | 1710539427000 | MTA | BIKE RACK | 18TH ST to 19TH ST (2200 - 2299) | - | IFO #2211 MISSION | - | - | - | - | - | 118871 | 1364947200000 | -122.41928266 | 37.76103561 | - | 1506297600000 | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1373579460000 | MISSION ST | 2200 - 2299 MISSION ST | 2200 - 2299 MISSION ST | 2200 MISSION ST | - | 19TH ST | 19TH ST |
| 101594 | N/A | Point | 1 | 1 | 1 - 99 | - | S246430 | 1-99 ELLIS ST | 1-99 ELLIS ST | F | F | - | F | 5169000 | 5169000 | - | - | SOUTH SIDE | - | - | - | - | 4TH ST \ MARKET ST \ STOCKTON ST | 04TH ST \ MARKET ST \ STOCKTON ST | 84609 | 84609 | 37.78561777 | -122.40684177 | - | - | 1755535135000 | middleware_editor | NPRK 6AM-8AM EVERYDAY INCL HOLIDAY STCL | 04TH ST \ MARKET ST \ STOCKTON ST to POWELL ST (1 - 99) | - | 150' W OF STOCKTON | - | - | - | - | - | 118872 | 1529089920000 | -122.40684177 | 37.78561777 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0183 | 18X18 | SUP1 | LIGHT POLE | IS | 1529051460000 | ELLIS ST | 1 - 99 ELLIS ST | 1 - 99 ELLIS ST | 1 ELLIS ST | - | POWELL ST | POWELL ST |
| 101595 | N/A | Point | 1 | 1 | 2400 - 2499 | - | S212085 | 2400-2499 CLEMENT ST | 2400-2499 CLEMENT ST | F | F | - | F | 4175000 | 4175000 | - | - | NORTH SIDE | - | - | - | - | 25TH AVE | 25TH AVE | 122207 | 122207 | 37.78200006 | -122.48540979 | - | - | 1710539427000 | MTA | (H/C SYM) PARK ONLY/MIN FINE $250 | 25TH AVE to 26TH AVE (2400 - 2499) | - | 38`WEST | - | - | - | - | - | 118873 | 1421844780000 | -122.48540979 | 37.78200006 | - | 1421798400000 | - | D1 | - | OTHER REGULATORY | REG | R99C(CA).0001 | 12X24 | SUP2 | PARKING METER | IS | 1419588960000 | CLEMENT ST | 2400 - 2499 CLEMENT ST | 2400 - 2499 CLEMENT ST | 2400 CLEMENT ST | - | 26TH AVE | 26TH AVE |
| 101596 | N/A | Point | - | - | - | - | S239561 | SHAFTER AVE: KEITH ST | - | F | F | - | F | 20158000 | 20158000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SHAFTER AVE | KEITH ST | 73013 | 73013 | 37.729983071 | -122.388713633 | KEITH ST \ SHAFTER AVE | SHAFTER AVE \ KEITH ST | 1710539427000 | MTA | STOP | KEITH ST intersection | - | 0 / 0 | - | - | - | - | - | 118874 | 25747200000 | -122.38885512 | 37.72998042 | - | 1691406000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1508316360000 | SHAFTER AVE | - | - | - | - | - | - |
| 101597 | N/A | Point | - | - | - | - | S109380 | KEITH ST: UNDERWOOD AVE | - | F | F | - | F | 20484000 | 20484000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | UNDERWOOD AVE | UNDERWOOD AVE | 6182 | 6182 | 37.728617087 | -122.390022894 | KEITH ST \ UNDERWOOD AVE | KEITH ST \ UNDERWOOD AVE | 1710539427000 | MTA | STOP | UNDERWOOD AVE intersection | - | 0 / 0 | - | - | - | - | - | 118875 | 471139200000 | -122.38998132 | 37.72872846 | - | 1691058000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570460000 | KEITH ST | - | - | - | - | - | - |
| 101598 | N/A | Point | - | - | - | - | S109379 | KEITH ST: UNDERWOOD AVE | - | F | F | - | F | 20484000 | 20484000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | UNDERWOOD AVE | UNDERWOOD AVE | 6181 | 6181 | 37.728843546 | -122.389960533 | KEITH ST \ UNDERWOOD AVE | KEITH ST \ UNDERWOOD AVE | 1710539427000 | MTA | STOP | UNDERWOOD AVE intersection | - | 6N / 0 | - | - | - | - | - | 118876 | 471139200000 | -122.38998132 | 37.72872846 | - | 1691065200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570460000 | KEITH ST | - | - | - | - | - | - |
| 101599 | N/A | Point | - | - | - | - | S235053 | PRESIDIO AVE: GEARY BLVD | - | F | F | - | F | 26834000 | 26834000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GEARY BLVD | GEARY BLVD | 69915 | 69915 | 37.782683057 | -122.445952609 | PRESIDIO AVE \ GEARY BLVD | PRESIDIO AVE \ GEARY BLVD | 1710539427000 | MTA | STOP | GEARY BLVD intersection | - | - | - | - | - | - | - | 118877 | - | -122.44582051 | 37.78248803 | - | 1690804800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1491828660000 | PRESIDIO AVE | - | - | - | - | - | - |
| 101600 | N/A | Point | - | - | - | - | S101347 | MASONIC AVE: EUCLID AVE | - | F | F | - | F | - | 26845000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | - | EUCLID AVE | 4078 | 4078 | 37.785170816 | -122.447725051 | - | MASONIC AVE \ EUCLID AVE | 1710539427000 | MTA | ONE WAY (LA) | EUCLID AVE intersection | - | 0 / 0 | - | - | - | - | - | 118878 | -398563200000 | -122.44762011 | 37.78508364 | - | 1690194600000 | - | D2 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373566740000 | MASONIC AVE | - | - | - | - | - | - |
| 101601 | N/A | Point | - | - | - | - | S245912 | PRESIDIO AVE: GEARY BLVD | - | F | F | - | F | 26834000 | 26834000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | GEARY BLVD | GEARY BLVD | 81097 | 81097 | 37.782474781 | -122.445921763 | PRESIDIO AVE \ GEARY BLVD | PRESIDIO AVE \ GEARY BLVD | 1710539427000 | MTA | ALL WAY | GEARY BLVD intersection | - | X ST IS GEARY (OPP TARGET) | - | - | - | - | - | 118879 | - | -122.44582051 | 37.78248803 | - | 1690380000000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1527758220000 | PRESIDIO AVE | - | - | - | - | - | - |
| 101602 | N/A | Point | - | - | - | - | S112094 | UNDERWOOD AVE: KEITH ST | - | F | F | - | F | 20484000 | 20484000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | UNDERWOOD AVE | UNDERWOOD AVE | 11228 | 11228 | 37.728721035 | -122.390122136 | KEITH ST \ UNDERWOOD AVE | KEITH ST \ UNDERWOOD AVE | 1710539427000 | MTA | STOP | UNDERWOOD AVE intersection | - | - | - | - | - | - | - | 118880 | 912816000000 | -122.38998132 | 37.72872846 | - | 1691061600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571300000 | KEITH ST | - | - | - | - | - | - |
| 101603 | N/A | Point | - | - | - | - | S112093 | UNDERWOOD AVE: KEITH ST | - | F | F | - | F | 20484000 | 20484000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | UNDERWOOD AVE | UNDERWOOD AVE | 11227 | 11227 | 37.728733763 | -122.389844527 | KEITH ST \ UNDERWOOD AVE | KEITH ST \ UNDERWOOD AVE | 1750287659000 | middleware_editor | STOP | UNDERWOOD AVE intersection | - | - | - | - | - | - | - | 118881 | 912844800000 | -122.38998132 | 37.72872846 | - | 1691080200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571300000 | KEITH ST | - | - | - | - | - | - |
| 101604 | N/A | Point | - | - | - | - | S239305 | KEITH ST: SHAFTER AVE | - | F | F | - | F | 20158000 | 20158000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SHAFTER AVE | KEITH ST | 70975 | 70975 | 37.730100277 | -122.388834333 | KEITH ST \ SHAFTER AVE | SHAFTER AVE \ KEITH ST | 1710539427000 | MTA | ALL WAY | KEITH ST intersection | - | 0 / 0 | - | - | - | - | - | 118882 | 25747200000 | -122.38885512 | 37.72998042 | - | 1691566260000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1507115460000 | SHAFTER AVE | - | - | - | - | - | - |
| 101605 | N/A | Point | - | - | - | - | S239304 | KEITH ST: SHAFTER AVE | - | F | F | - | F | 20158000 | 20158000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SHAFTER AVE | KEITH ST | 70974 | 70974 | 37.729866397 | -122.388896023 | KEITH ST \ SHAFTER AVE | SHAFTER AVE \ KEITH ST | 1710539427000 | MTA | ALL WAY | KEITH ST intersection | - | 0 / 0 | - | - | - | - | - | 118883 | 25747200000 | -122.38885512 | 37.72998042 | - | 1691401500000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1507115400000 | SHAFTER AVE | - | - | - | - | - | - |
| 101606 | N/A | Point | - | - | - | - | S235054 | PRESIDIO AVE: GEARY BLVD | - | F | F | - | F | 26834000 | 26834000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GEARY BLVD | GEARY BLVD | 69916 | 69916 | 37.782683057 | -122.445952609 | PRESIDIO AVE \ GEARY BLVD | PRESIDIO AVE \ GEARY BLVD | 1710539427000 | MTA | ALL WAY | GEARY BLVD intersection | - | - | - | - | - | - | - | 118884 | 1492861260000 | -122.44582051 | 37.78248803 | - | 1690805700000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1491828840000 | PRESIDIO AVE | - | - | - | - | - | - |
| 101607 | N/A | Point | - | - | - | - | S105765 | ELLIS ST: TAYLOR ST | - | F | F | - | F | 24926000 | 24926000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TAYLOR ST | ELLIS ST | 109470 | 109470 | 37.785159391 | -122.411040558 | ELLIS ST \ TAYLOR ST | TAYLOR ST \ ELLIS ST | 1750192734000 | middleware_editor | ONE WAY (LA) | ELLIS ST intersection | - | 0 / MADE ELLIS ONE-WAY WB BETMARKET..... | - | - | - | - | - | 118885 | 100854000000 | -122.4111398 | 37.7850746 | - | 1691440200000 | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373569320000 | TAYLOR ST | - | - | - | - | - | - |
| 101608 | N/A | Point | - | - | - | - | S124952 | PENNSYLVANIA AVE: 19TH ST | - | F | F | - | F | 23649000 | 23649000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 127581 | 127581 | 37.761558858 | -122.39360976 | PENNSYLVANIA AVE \ 19TH ST | PENNSYLVANIA AVE \ 19TH ST | 1710539427000 | MTA | ALL WAY | 19TH ST intersection | - | 25N / INSTALL SIGN 25FT. NORTH OF N..... | - | - | - | - | - | 118886 | 1155513600000 | -122.39348839 | 37.76147616 | - | 1689945600000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575320000 | PENNSYLVANIA AVE | - | - | - | - | - | - |
| 101609 | N/A | Point | - | - | - | - | S122706 | 3RD ST: 19TH ST | - | F | F | - | F | 23567000 | 23567000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 19TH ST | 03RD ST | 15149 | 15149 | 37.761685873 | -122.38853784 | 3RD ST \ 19TH ST | 19TH ST \ 03RD ST | 1710539427000 | MTA | ONE WAY (LA) | 03RD ST intersection | - | - | - | - | - | - | - | 118887 | 1139616000000 | -122.38868402 | 37.76176645 | - | 1689775200000 | - | D10 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373574660000 | 19TH ST | - | - | - | - | - | - |
| 101610 | N/A | Point | - | - | - | - | S124937 | 19TH ST: PENNSYLVANIA AVE | - | F | F | - | F | 23649000 | 23649000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 18414 | 18414 | 37.761553027 | -122.393344221 | PENNSYLVANIA AVE \ 19TH ST | PENNSYLVANIA AVE \ 19TH ST | 1710539427000 | MTA | ALL WAY | 19TH ST intersection | - | 0 / BELOW EXISTING STOP SIGN | - | - | - | - | - | 118888 | 1155513600000 | -122.39348839 | 37.76147616 | - | 1689775500000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575320000 | PENNSYLVANIA AVE | - | - | - | - | - | - |
| 101611 | N/A | Point | - | - | - | - | S124938 | 19TH ST: PENNSYLVANIA AVE | - | F | F | - | F | 23649000 | 23649000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 18415 | 18415 | 37.761423678 | -122.393639935 | PENNSYLVANIA AVE \ 19TH ST | PENNSYLVANIA AVE \ 19TH ST | 1710539427000 | MTA | ALL WAY | 19TH ST intersection | - | 0 / BELOW EXISTING STOP SIGN | - | - | - | - | - | 118889 | 1155513600000 | -122.39348839 | 37.76147616 | - | 1689776700000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575320000 | PENNSYLVANIA AVE | - | - | - | - | - | - |
| 101612 | N/A | Point | - | - | - | - | S239273 | UNDERWOOD AVE: KEITH ST | - | F | F | - | F | 20484000 | 20484000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | UNDERWOOD AVE | UNDERWOOD AVE | 71847 | 71847 | 37.728720505 | -122.390122806 | KEITH ST \ UNDERWOOD AVE | KEITH ST \ UNDERWOOD AVE | 1710539427000 | MTA | ALL WAY | UNDERWOOD AVE intersection | - | - | - | - | - | - | - | 118890 | 912816000000 | -122.38998132 | 37.72872846 | - | 1691077800000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1507024800000 | KEITH ST | - | - | - | - | - | - |
| 101613 | N/A | Point | - | - | - | - | S124933 | PENNSYLVANIA AVE: 19TH ST | - | F | F | - | F | 23649000 | 23649000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 18411 | 18411 | 37.761562304 | -122.393610431 | PENNSYLVANIA AVE \ 19TH ST | PENNSYLVANIA AVE \ 19TH ST | 1710539427000 | MTA | STOP | 19TH ST intersection | - | 25N / INSTALL SIGN 25FT. NORTH OF N..... | - | - | - | - | - | 118891 | 1155513600000 | -122.39348839 | 37.76147616 | - | 1689947400000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373575320000 | PENNSYLVANIA AVE | - | - | - | - | - | - |
| 101614 | N/A | Point | 1 | 1 | 900 - 1099 | - | S253348 | 900-1099 TURK ST | 900-1099 TURK ST | F | F | - | F | 12726000 | 12726000 | - | - | NORTH SIDE | - | - | - | - | GOUGH ST | GOUGH ST | 101817 | 101817 | 37.78153041 | -122.424482042 | - | - | 1710539427000 | MTA | AHEAD | GOUGH ST to LAGUNA ST (900 - 1099) | - | 120' W GOUGH | - | - | - | - | - | 118892 | - | -122.42556029 | 37.78132637 | - | 1689669900000 | - | D5 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP1 | LIGHT POLE | IS | 1554730320000 | TURK ST | 900 - 1099 TURK ST | 900 - 1099 TURK ST | 900 TURK ST | - | LAGUNA ST | LAGUNA ST |
| 101615 | N/A | Point | 1 | 1 | 1 - 39 | - | S288630 | 1-39 FRANKLIN ST | 1-39 FRANKLIN ST | F | F | - | F | 5796000 | 5796000 | - | - | WEST SIDE | - | - | - | - | PAGE ST | PAGE ST | 103188 | 103188 | 37.77452711 | -122.42080952 | - | - | 1710539427000 | MTA | BIKE RACK | PAGE ST to LILY ST (1 - 39) | - | 6' S OF SOUTH LILY SIDEWALK/2'6" IN FROM | - | - | - | - | - | 118893 | - | -122.42080952 | 37.77452711 | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1681833720000 | FRANKLIN ST | 1 - 39 FRANKLIN ST | 1 - 39 FRANKLIN ST | 1 FRANKLIN ST | - | LILY ST | LILY ST |
| 101616 | N/A | Point | 1 | 1 | 1 - 39 | - | S203548 | 1-39 FRANKLIN ST | 1-39 FRANKLIN ST | F | F | - | F | 5796000 | 5796000 | - | - | EAST SIDE | - | - | - | - | PAGE ST | PAGE ST | 41369 | 41369 | 37.77452711 | -122.42080952 | - | - | 1723663072000 | middleware_editor | (H/C SYM) PARK ONLY/MIN FINE $250 | PAGE ST to LILY ST (1 - 39) | - | 35' NORTH OF MARKET ST. | - | - | - | - | - | 118894 | 1411134300000 | -122.42080952 | 37.77452711 | - | 1411084800000 | - | D5 | - | OTHER REGULATORY | REG | R99C(CA).0001 | 12X24 | SUP1 | 2IN IRON POST | IS | 1394018700000 | FRANKLIN ST | 1 - 39 FRANKLIN ST | 1 - 39 FRANKLIN ST | 1 FRANKLIN ST | - | LILY ST | LILY ST |
| 101617 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S127736 | 1200-1299 MASON ST | 1200-1299 MASON ST | F | F | - | F | 8818000 | 8818000 | - | - | WEST SIDE | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 22399 | 22399 | 37.79496759 | -122.41145279 | - | - | 1710539427000 | MTA | TANS EXC VEH W/PERMIT ISSUED BY MTA T.C. SEC. 32.1.10 | WASHINGTON ST to JACKSON ST (1200 - 1299) | - | OPP. #1206/ 60'FT NORTH OF WASHINGTON | - | - | - | - | - | 118895 | 1182816000000 | -122.41145279 | 37.79496759 | - | - | - | D3 | - | OTHER REGULATORY | REG | R32C(SF).0042 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373576220000 | MASON ST | 1200 - 1299 MASON ST | 1200 - 1299 MASON ST | 1200 MASON ST | - | JACKSON ST | JACKSON ST |
| 101618 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S127737 | 1200-1299 MASON ST | 1200-1299 MASON ST | F | F | - | F | 8818000 | 8818000 | - | - | WEST SIDE | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 21037 | 21037 | 37.79496759 | -122.41145279 | - | - | 1710539427000 | MTA | TANS EXC VEH W/PERMIT ISSUED BY MTA T.C. SEC. 32.1.10 | WASHINGTON ST to JACKSON ST (1200 - 1299) | - | OPP.#1230/115 FT NORTH OF WASHINGTON | - | - | - | - | - | 118896 | 1182816000000 | -122.41145279 | 37.79496759 | - | 1611705600000 | - | D3 | - | OTHER REGULATORY | REG | R32C(SF).0042 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373576220000 | MASON ST | 1200 - 1299 MASON ST | 1200 - 1299 MASON ST | 1200 MASON ST | - | JACKSON ST | JACKSON ST |
| 101619 | N/A | Point | 1 | 1 | 1600 - 1631 | - | S217737 | 1600-1631 JONES ST | 1600-1631 JONES ST | F | F | - | F | 7584000 | 7584000 | - | - | WEST SIDE | - | - | - | - | PACIFIC AVE | PACIFIC AVE | 55656 | 55656 | 37.79609692 | -122.41504987 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-7PM MON-FRI EXC "AC" PERMITS | PACIFIC AVE to BERNARD ST (1600 - 1631) | - | OPP #1602-1604 | - | - | - | - | - | 118897 | 1595340600000 | -122.41504987 | 37.79609692 | - | - | - | D3 | - | PARKING:RPP | REG | R32C(CA).0113 | 18X21 | SUP1 | LIGHT POLE | IS | 1436360100000 | JONES ST | 1600 - 1631 JONES ST | 1600 - 1631 JONES ST | 1600 JONES ST | - | BERNARD ST | BERNARD ST |
| 101620 | N/A | Point | 1 | 1 | 3000 - 3099 | - | S148989 | 3000-3099 21ST AVE | 3000-3099 21ST AVE | F | F | - | F | 1095000 | 1095000 | - | - | WEST SIDE | - | - | - | - | OCEAN AVE | OCEAN AVE | 38717 | 38717 | 37.73188229 | -122.47689324 | - | - | 1747946104000 | middleware_editor | NPRK 8AM-10AM 2ND & 4TH WED OF MONTH STCL | OCEAN AVE to EUCALYPTUS DR (3000 - 3099) | - | SPL 3073 21ST AVE | - | - | - | - | - | 118898 | 1225263600000 | -122.47689324 | 37.73188229 | - | 1747945380000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0258 | 18X18 | SUP2 | LIGHT POLE | IS | 1375729140000 | 21ST AVE | 3000 - 3099 21ST AVE | 3000 - 3099 21ST AVE | 3000 21ST AVE | - | EUCALYPTUS DR | EUCALYPTUS DR |
| 101621 | N/A | Point | 1 | 1 | 108 - 183 | - | S217990 | 108-183 LANGTON ST | 108-183 LANGTON ST | F | F | - | F | 8100000 | 8100000 | - | - | WEST SIDE | - | - | - | - | DECKER ALY | DECKER ALY | 54992 | 54992 | 37.77557161 | -122.40743767 | - | - | 1710539427000 | MTA | 1 HR PRK 8AM-10PM EVRYDAY EXC "U" PERMITS | DECKER ALY to HARRISON ST (108 - 183) | - | NPL #130 | - | - | - | - | - | 118899 | 1459327440000 | -122.40743767 | 37.77557161 | - | 1459296000000 | - | D6 | - | PARKING:RPP | REG | R32C(CA).0004 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1437391140000 | LANGTON ST | 108 - 183 LANGTON ST | 108 - 183 LANGTON ST | 108 LANGTON ST | - | HARRISON ST | HARRISON ST |
| 101622 | N/A | Point | - | - | - | - | S238949 | MALTA DR: OSHAUGHNESSY BLVD | - | F | F | - | F | 22285000 | 22285000 | - | - | SOUTH WEST CORNER | - | - | - | - | MALTA DR | OSHAUGHNESSY BLVD | 72034 | 72034 | 37.73650258 | -122.44360224 | OSHAUGHNESSY BLVD \ MALTA DR | MALTA DR \ OSHAUGHNESSY BLVD | 1710539427000 | MTA | MALTA DR | OSHAUGHNESSY BLVD intersection | - | OF MALTA DR & O SHAUGHNESSY BLVD | - | - | - | - | - | 118900 | 1543415880000 | -122.44360224 | 37.73650258 | - | - | - | D7 | - | STREET NAME | GUIDE | D3-1.1104 | 36X08 | SUP2 | 3IN IRON POST | IS | 1505734020000 | MALTA DR | - | - | - | - | - | - |
| 101623 | N/A | Point | - | - | - | - | S242583 | 24TH ST: TREAT AVE | - | T | T | - | F | 23987000 | 23987000 | - | - | SOUTH EAST CORNER | - | - | - | - | TREAT AVE | 24TH ST | 76210 | 76210 | 37.75257276 | -122.41299518 | 24TH ST \ TREAT AVE | TREAT AVE \ 24TH ST | 1710539427000 | MTA | NO LITTERING (SYM)-IT SHALL BE UNLAWFUL¿ | 24TH ST intersection | - | - | - | - | - | - | - | 118901 | 1509494400000 | -122.41299518 | 37.75257276 | - | 1509494400000 | - | D9 | - | OTHER REGULATORY | REG | SR(SF).0035 | 18X24 | SUP2 | LIGHT POLE | IS | 1516981500000 | TREAT AVE | - | - | - | - | - | - |
| 101624 | N/A | Point | 1 | 1 | 3049 - 3089 | - | S266049 | 3049-3089 24TH ST | 3049-3089 24TH ST | F | F | - | F | 1338000 | 1338000 | - | - | NORTH SIDE | - | - | - | - | TREAT AVE | TREAT AVE | 104412 | 104412 | 37.75255532 | -122.41325617 | - | - | 1710539427000 | MTA | BIKE RACK | TREAT AVE to LUCKY ST (3049 - 3089) | 126768 | 3' W OF EPL 3066/3' IN FROM CURB | - | - | - | - | - | 118902 | 1594640880000 | -122.41325617 | 37.75255532 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1594367160000 | 24TH ST | 3049 - 3089 24TH ST | 3049 - 3089 24TH ST | 3049 24TH ST | - | LUCKY ST | LUCKY ST |
| 101625 | N/A | Point | 1 | 1 | 3049 - 3089 | - | S288596 | 3049-3089 24TH ST | 3049-3089 24TH ST | F | F | - | F | 1338000 | 1338000 | - | - | SOUTH SIDE | - | - | - | - | TREAT AVE | TREAT AVE | 109537 | 109537 | 37.75255532 | -122.41325617 | - | - | 1710539427000 | MTA | BIKE RACK | TREAT AVE to LUCKY ST (3049 - 3089) | - | 22' W OF TREAT STREET/3.5' IN FROM CURB | - | - | - | - | - | 118903 | - | -122.41325617 | 37.75255532 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1681826760000 | 24TH ST | 3049 - 3089 24TH ST | 3049 - 3089 24TH ST | 3049 24TH ST | - | LUCKY ST | LUCKY 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.