MTA.signshop_assets
No additional information has been provided for this dataset.
Between for ranges (e.g., 10,100)Regex for pattern matchingCase sensitive for exact matches
| ID | Feature ID | Geometry Type | ACCEPTED | ACTIVE | ADDRANGE | ARROW DIR | ASSET ID | ASSET NAME | ASSET NAME 1 | BAPA | BOOM TRUCK | CANCEL | CLEARANCE PERMIT | CNN | CNN 1 | COMBOKEY | CONDITION | CORNER SIDE FACING | CREATED DATE | CREATED USER | CURLYIDS | ETL | FROM ST | FROM ST 1 | GISOBJID | GLOBALID UDFCHAR44 | GPS LATITUDE | GPS LONGITUDE | INTERSECTION | INTERSECTION 1 | LAST EDITED DATE | LAST EDITED USER | LEGEND | LIMITS | LOCATION TRACK ID | LOC SPEC | NEW PURPOSE | NEW SIGN CODE | NEW SIGN LEGEND | NEW SIGN SIZE | NUM OF ASSETS | OBJECTID 1 | ORIG INSTALL DATE | POINT X | POINT Y | PURPOSE | REPLACEMENT DATE | RETIREMENT DATE | SF SUP DISTRICT | SHEETING | SIGN CATEGORY | SIGN CLASS | SIGN CODE | SIGN SIZE | SIGN SUPERVISOR | SIGN SUPPORT | STATUS CODE | STATUS DATE | STREETNAME | STREET ADDRESS RANGE | STREET ADDRESS RANGE 1 | STREET BLOCK | STREET VIEW | TO ST | TO ST 1 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 108151 | N/A | Point | - | - | - | - | 21202 | - | - | F | F | - | F | 54151000 | - | - | - | - | 1689777662000 | jrasmuss | - | - | THE EMBARCADERO | - | 141972 | 141972 | 37.79440615 | -122.39289583 | DON CHEE WAY \ THE EMBARCADERO | - | 1710539427000 | MTA | BIKE RACK | - | - | 19'5" s of utility box/4'6" from curb | - | - | - | - | - | 125456 | 1691652480000 | - | - | - | - | - | 03 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | - | DON CHEE WAY | - | - | - | - | - | - |
| 108152 | N/A | Point | - | - | - | - | 21201 | - | - | F | F | - | F | 54151000 | - | - | - | - | 1689777597000 | jrasmuss | - | - | THE EMBARCADERO | - | 141970 | 141970 | 37.794418074 | -122.392909185 | DON CHEE WAY \ THE EMBARCADERO | - | 1710539427000 | MTA | BIKE RACK | - | - | 10'5" s of utility box/4'6" from curb | - | - | - | - | - | 125457 | 1691673780000 | - | - | - | - | - | 03 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | - | DON CHEE WAY | - | - | - | - | - | - |
| 108153 | N/A | Point | - | - | - | - | 21200 | - | - | F | F | - | F | 54151000 | - | - | - | - | 1689777578000 | jrasmuss | - | - | THE EMBARCADERO | - | 141969 | 141969 | 37.794422192 | -122.392913666 | DON CHEE WAY \ THE EMBARCADERO | - | 1710539427000 | MTA | BIKE RACK | - | - | 7'5" s of utility box/4'6" from curb | - | - | - | - | - | 125458 | 1692107940000 | - | - | - | - | - | 03 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | - | DON CHEE WAY | - | - | - | - | - | - |
| 108154 | N/A | Point | - | - | - | - | 22156 | - | - | F | F | - | F | 6111000 | - | - | - | SOUTH SIDE | 1692054841000 | jrasmuss | - | - | MASON ST | - | 146689 | 146689 | 37.7870736581357 | -122.410037432384 | - | - | 1710539427000 | MTA | BIKE RACK | - | - | 10' e of epl 405/3.5' in from curb | - | - | - | - | - | 125459 | 1692087480000 | - | - | - | - | - | 03 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | - | GEARY ST | 400 - 499 GEARY ST | - | - | - | TAYLOR ST | - |
| 108155 | N/A | Point | - | - | - | - | 22151 | - | - | F | F | - | F | 13155201 | - | - | - | EAST SIDE | 1692038561000 | jrasmuss | - | - | SUTTER ST | - | 146625 | 146625 | 37.787920994453 | -122.421674359677 | - | - | 1710539427000 | MTA | BIKE RACK | - | 767441 | 32' s of npl 1300/3.5' in from curb | - | - | - | - | - | 125460 | 1692191580000 | - | - | - | - | - | 03 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | - | VAN NESS AVE | 1300 - 1330 VAN NESS AVE | - | - | - | FERN ST | - |
| 108156 | N/A | Point | - | - | - | - | 21171 | - | - | F | F | - | F | - | - | - | - | CENTER ISLAND | 1689604240000 | jrasmuss | - | - | - | - | 141777 | 141777 | 37.795022594 | -122.394000162 | - | - | 1710539427000 | MTA | BIKE RACK | - | - | 5' N of monument plaque | - | - | - | - | - | 125461 | 1689683520000 | - | - | - | - | - | 03 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | - | - | - | - | - | - | - | - |
| 108157 | N/A | Point | - | - | - | - | S232922 | EVANS AVE: NEWHALL ST | - | F | F | - | F | 20236000 | 20236000 | - | - | SOUTH EAST CORNER | - | - | - | - | EVANS AVE | EVANS AVE | 70194 | 70194 | 37.74195024 | -122.38655454 | NEWHALL ST \ EVANS AVE | NEWHALL ST \ EVANS AVE | 1710539427000 | MTA | EVANS AVE | EVANS AVE intersection | - | <1500 WEST | - | - | - | - | - | 125462 | 1490793360000 | -122.38655454 | 37.74195024 | - | 1694777400000 | - | D10 | - | STREET NAME | GUIDE | D3-1.0630 | 36X08 | SUP1 | 3IN IRON POST | IS | 1485332040000 | NEWHALL ST | - | - | - | - | - | - |
| 108158 | N/A | Point | - | - | - | - | S277904 | SAINT ELMO WAY: PLYMOUTH AVE \ | - | F | F | - | F | 22804000 | 22804000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SAINT ELMO WAY \ YERBA BUENA AVE | SAINT ELMO WAY \ YERBA BUENA AVE | 122109 | 122109 | 37.7325432 | -122.45861373 | PLYMOUTH AVE \ SAINT ELMO WAY \ YERBA BUENA AVE | PLYMOUTH AVE \ SAINT ELMO WAY \ YERBA BUENA AVE | 1726535706000 | middleware_editor | STOP | SAINT ELMO WAY \ YERBA BUENA AVE intersection | - | 0 / 0 | - | - | - | - | - | 125463 | 309744000000 | -122.45861373 | 37.7325432 | - | 1692576000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1632742020000 | PLYMOUTH AVE | - | - | - | - | - | - |
| 108159 | N/A | Point | - | - | - | - | S289622 | SLOAT BLVD: 24TH AVE | - | F | F | - | F | 23214000 | 23214000 | - | - | SOUTH EAST CORNER | - | - | - | - | 24TH AVE | SLOAT BLVD | 101116 | 101116 | 37.73442735 | -122.48024636 | SLOAT BLVD \ 24TH AVE | 24TH AVE \ SLOAT BLVD | 1728090787000 | middleware_editor | 24TH AVE | SLOAT BLVD intersection | - | <2900 SOUTH | - | - | - | - | - | 125464 | - | -122.48024636 | 37.73442735 | - | 1689811200000 | - | D7 | - | STREET NAME | GUIDE | D3-1.1943 | 36X08 | SUP2 | 3IN IRON POST | IS | 1684399680000 | 24TH AVE | - | - | - | - | - | - |
| 108160 | N/A | Point | - | - | - | - | S288773 | - | - | F | F | - | F | 99991606 | - | R6-1.0004-2021-03-19 00: 00: 00-37.736671--122.359657 | - | SOUTH SIDE | 1689201652000 | MTA | - | - | - | - | 132592 | 132592 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | ONE WAY (LA) | - | - | EAST OF DRIVEWAY POMEROY CENTER | - | - | - | - | - | 125465 | 1616112000000 | - | - | - | 1692887640000 | - | D7 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP2 | LIGHT POLE | IS | - | - | 000-299 ZOO RD | - | - | - | - | - |
| 108161 | N/A | Point | - | - | - | - | S289706 | TOPEKA AVE: MADDUX AVE | - | F | F | - | F | 20624000 | 20624000 | - | - | SOUTH WEST CORNER | - | - | - | - | TOPEKA AVE | TOPEKA AVE | 121871 | 121871 | 37.73363885 | -122.39858464 | MADDUX AVE \ TOPEKA AVE | MADDUX AVE \ TOPEKA AVE | 1710539427000 | MTA | MADDUX AVE | TOPEKA AVE intersection | - | <100 SOUTH | - | - | - | - | - | 125466 | - | -122.39858464 | 37.73363885 | - | 1690156800000 | - | D10 | - | STREET NAME | GUIDE | D3-1.1092 | 36X08 | SUP1 | 3IN IRON POST | IS | 1684488720000 | MADDUX AVE | - | - | - | - | - | - |
| 108162 | N/A | Point | - | - | - | - | S289816 | 4TH ST: FREELON ST | - | F | F | - | F | 23832000 | 23832000 | - | - | SOUTH EAST CORNER | - | - | - | - | 04TH ST | FREELON ST | 104349 | 104349 | 37.77875105 | -122.39706172 | FREELON ST \ 04TH ST | 04TH ST \ FREELON ST | 1710539427000 | MTA | FREELON ST | FREELON ST intersection | - | <100 WEST (7' SOUTH OF FREELON/4TH) | - | - | - | - | - | 125467 | 1454630400000 | -122.39706172 | 37.77875105 | - | 1692705600000 | - | D6 | - | STREET NAME | GUIDE | D3-1.0694 | 36X08 | SUP1 | 2IN IRON POST | IS | 1684938060000 | 04TH ST | - | - | - | - | - | - |
| 108163 | N/A | Point | 1 | 1 | 2800 - 2851 | - | S284288 | 2800-2851 16TH ST | 2800-2851 16TH ST | F | F | - | F | 721000 | 721000 | - | - | SOUTH SIDE | - | - | - | - | FOLSOM ST | FOLSOM ST | 92267 | 92267 | 37.76524735 | -122.415483292 | - | - | 1710539427000 | MTA | BIKE RACK | FOLSOM ST to SHOTWELL ST (2800 - 2851) | - | 10 W FOLSOM/5'' E FROM LINE/2'FROM CURB | - | - | - | - | - | 125468 | 1671148800000 | -122.41584796 | 37.76528207 | - | 1698238800000 | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1659433320000 | 16TH ST | 2800 - 2851 16TH ST | 2800 - 2851 16TH ST | 2800 16TH ST | - | SHOTWELL ST | SHOTWELL ST |
| 108164 | N/A | Point | - | - | - | - | S289855 | GEARY BLVD: 3RD AVE | - | F | F | - | F | 27245000 | 27245000 | - | - | NORTH WEST CORNER | - | - | - | - | 3RD AVE | GEARY BLVD | 106106 | 106106 | 37.78116026 | -122.46106283 | GEARY BLVD \ 3RD AVE | 03RD AVE \ GEARY BLVD | 1710539427000 | MTA | 3RD AVE | GEARY BLVD intersection | - | |<400 SOUTH | - | - | - | - | - | 125469 | - | -122.46106283 | 37.78116026 | - | 1691149500000 | - | D1 | - | STREET NAME | GUIDE | D3-1.2064 | 36X08 | SUP2 | SIGNAL POLE | IS | 1685097600000 | 03RD AVE | - | - | - | - | - | - |
| 108165 | N/A | Point | - | - | - | - | S289714 | SUNRISE WAY: SAWYER ST | - | F | F | - | F | 20404000 | 20404000 | - | - | NORTH WEST CORNER | - | - | - | - | SUNRISE WAY | SAWYER ST | 121875 | 121875 | 37.70969487 | -122.41595592 | SAWYER ST \ SUNRISE WAY | SUNRISE WAY \ SAWYER ST | 1710539427000 | MTA | SAWYER ST | SAWYER ST intersection | - | <600 SOUTH | - | - | - | - | - | 125470 | - | -122.41595592 | 37.70969487 | - | 1689897600000 | - | D10 | - | STREET NAME | GUIDE | D3-1.1591 | 36X08 | SUP1 | 3IN IRON POST | IS | 1684495920000 | SUNRISE WAY | - | - | - | - | - | - |
| 108166 | N/A | Point | - | - | - | - | S106260 | BRODERICK ST: VALLEJO ST | - | F | F | - | F | 26877000 | 26877000 | R1-1.0002-1974-03-12 00: 00: 00-37.79417288--122.4433842 | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VALLEJO ST | BRODERICK ST | 1423 | 1423 | 37.79417288 | -122.4433842 | BRODERICK ST \ VALLEJO ST | VALLEJO ST \ BRODERICK ST | 1710539427000 | MTA | STOP | BRODERICK ST intersection | - | 0 / 0 | - | - | - | - | - | 125471 | 132278400000 | -122.4433842 | 37.79417288 | - | 1175731200000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569500000 | VALLEJO ST | - | - | - | - | - | - |
| 108167 | N/A | Point | - | - | - | - | S106265 | VALLEJO ST: BRODERICK ST | - | F | F | - | F | 26877000 | 26877000 | R1-1.0002-1974-03-13 00: 00: 00-37.79417288--122.4433842 | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VALLEJO ST | BRODERICK ST | 1427 | 1427 | 37.79417288 | -122.4433842 | BRODERICK ST \ VALLEJO ST | VALLEJO ST \ BRODERICK ST | 1710539427000 | MTA | STOP | BRODERICK ST intersection | - | 0 / 0 | - | - | - | - | - | 125472 | 132364800000 | -122.4433842 | 37.79417288 | - | 1175731200000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569500000 | VALLEJO ST | - | - | - | - | - | - |
| 108168 | N/A | Point | - | - | - | - | S106266 | VALLEJO ST: BRODERICK ST | - | F | F | - | F | 26877000 | 26877000 | R1-1.0002-1974-03-13 00: 00: 00-37.79417288--122.4433842 | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VALLEJO ST | BRODERICK ST | 1428 | 1428 | 37.79417288 | -122.4433842 | BRODERICK ST \ VALLEJO ST | VALLEJO ST \ BRODERICK ST | 1710539427000 | MTA | STOP | BRODERICK ST intersection | - | 0 / 0 | - | - | - | - | - | 125473 | 132364800000 | -122.4433842 | 37.79417288 | - | 1135036800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569500000 | VALLEJO ST | - | - | - | - | - | - |
| 108169 | N/A | Point | - | - | - | - | S106280 | DUNCAN ST: TIFFANY AVE | - | F | F | - | F | 21341000 | 21341000 | R1-1.0002-1974-03-15 00: 00: 00-37.74649205--122.42035762 | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TIFFANY AVE | DUNCAN ST | 1437 | 1437 | 37.74649205 | -122.42035762 | DUNCAN ST \ TIFFANY AVE | TIFFANY AVE \ DUNCAN ST | 1710539427000 | MTA | STOP | DUNCAN ST intersection | - | 0 / 0 | - | - | - | - | - | 125474 | 132537600000 | -122.42035762 | 37.74649205 | - | 632707200000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569500000 | TIFFANY AVE | - | - | - | - | - | - |
| 108170 | N/A | Point | - | - | - | - | S104243 | VAN NESS AVE: NORTH POINT ST | - | F | F | - | F | 26708000 | 26708000 | R1-1.0002-1968-11-21 00: 00: 00-37.8050779--122.42529856 | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 1503 | 1503 | 37.8050779 | -122.42529856 | NORTH POINT ST \ VAN NESS AVE | NORTH POINT ST \ VAN NESS AVE | 1715131207000 | middleware_editor | STOP | VAN NESS AVE intersection | - | 00 / 00 | - | - | - | - | - | 125475 | -35078400000 | -122.42529856 | 37.8050779 | - | 1146441600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | MUNI POLE | IS | 1373568840000 | NORTH POINT ST | - | - | - | - | - | - |
| 108171 | N/A | Point | - | - | - | - | S105387 | 400-448 7TH ST | - | F | F | - | F | - | - | R5-1.0002-1972-03-22 00: 00: 00-37.77513--122.4058 | - | EAST SIDE, EASTBOUND TRAFFIC | - | - | - | - | - | - | 1763 | 1763 | 37.77513 | -122.4058 | - | - | 1710539427000 | MTA | DO NOT ENTER | - | - | 150N / HALL OF JUSTICE PARKING LOT | - | - | - | - | - | 125476 | 70070400000 | -122.4058 | 37.77513 | - | - | - | D6 | - | OTHER REGULATORY | REG | R5-1.0002 | 24X24 | SUP1 | UNKNOWN | IS | 1373569200000 | - | 400-448 7TH ST | - | - | - | - | - |
| 108172 | N/A | Point | - | - | - | - | S103929 | PACIFIC AVE: POWELL ST | - | F | F | - | F | 25064000 | 25064000 | R5-1.0001-1967-10-10 00: 00: 00-37.79649276--122.41007597 | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PACIFIC AVE | PACIFIC AVE | 2105 | 2105 | 37.79649276 | -122.41007597 | POWELL ST \ PACIFIC AVE | POWELL ST \ PACIFIC AVE | 1729089914000 | middleware_editor | DO NOT ENTER | PACIFIC AVE intersection | - | 0 / MADE WESTBOUND ONE WAY | - | - | - | - | - | 125477 | -70329600000 | -122.41007597 | 37.79649276 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373568780000 | POWELL ST | - | - | - | - | - | - |
| 108173 | N/A | Point | - | - | - | - | S103930 | PACIFIC AVE: POWELL ST | - | F | F | - | F | 25064000 | 25064000 | R5-1.0001-1967-10-10 00: 00: 00-37.79649276--122.41007597 | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PACIFIC AVE | PACIFIC AVE | 2106 | 2106 | 37.79649276 | -122.41007597 | POWELL ST \ PACIFIC AVE | POWELL ST \ PACIFIC AVE | 1744122143000 | middleware_editor | DO NOT ENTER | PACIFIC AVE intersection | - | 0 / MADE WESTBOUND ONE WAY | - | - | - | - | - | 125478 | -70304400000 | -122.41007597 | 37.79649276 | - | 1743009300000 | - | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373568780000 | POWELL ST | - | - | - | - | - | - |
| 108174 | N/A | Point | - | - | - | - | S105767 | ELLIS ST: 4TH ST \ MARKET ST \ | - | F | F | - | F | 24892000 | 24892000 | R6-1.0003-1973-03-13 00: 00: 00-37.78574399--122.40583101 | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 4TH ST \ MARKET ST \ STOCKTON ST | 04TH ST \ ELLIS ST \ MARKET ST | 2108 | 2108 | 37.78574399 | -122.40583101 | ELLIS ST \ 4TH ST \ MARKET ST \ STOCKTON ST | STOCKTON ST \ 04TH ST \ ELLIS ST \ MARKET ST | 1710539427000 | MTA | ONE WAY (RA) | 04TH ST \ ELLIS ST \ MARKET ST intersection | - | 0 / MADE ELLIS ONE-WAY WB BETMARKET..... | - | - | - | - | - | 125479 | 100828800000 | -122.40583101 | 37.78574399 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373569320000 | STOCKTON ST | - | - | - | - | - | - |
| 108175 | N/A | Point | - | - | - | - | S105193 | BEVERLY ST: GARFIELD ST | - | F | F | - | F | 22728000 | 22728000 | R1-1.0002-1971-11-11 00: 00: 00-37.7196402--122.47165211 | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BEVERLY ST | GARFIELD ST | 2133 | 2133 | 37.7196402 | -122.47165211 | GARFIELD ST \ BEVERLY ST | BEVERLY ST \ GARFIELD ST | 1728522930000 | middleware_editor | STOP | GARFIELD ST intersection | - | 0 / 0 | - | - | - | - | - | 125480 | 58665600000 | -122.47165211 | 37.7196402 | - | 1553558400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569140000 | BEVERLY ST | - | - | - | - | - | - |
| 108176 | N/A | Point | - | - | - | - | S105194 | BEVERLY ST: GARFIELD ST | - | F | F | - | F | 22728000 | 22728000 | R1-1.0002-1971-11-11 00: 00: 00-37.7196402--122.47165211 | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BEVERLY ST | GARFIELD ST | 2134 | 2134 | 37.7196402 | -122.47165211 | GARFIELD ST \ BEVERLY ST | BEVERLY ST \ GARFIELD ST | 1728522962000 | middleware_editor | STOP | GARFIELD ST intersection | - | 0 / 0 | - | - | - | - | - | 125481 | 58665600000 | -122.47165211 | 37.7196402 | - | 1329264000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569140000 | BEVERLY ST | - | - | - | - | - | - |
| 108177 | N/A | Point | - | - | - | - | S105494 | GREEN ST: SCOTT ST | - | F | F | - | F | 26870000 | 26870000 | R1-1.0002-1972-07-19 00: 00: 00-37.79553287--122.44023414 | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GREEN ST | GREEN ST | 2146 | 2146 | 37.79553287 | -122.44023414 | SCOTT ST \ GREEN ST | SCOTT ST \ GREEN ST | 1718760614000 | middleware_editor | STOP | GREEN ST intersection | - | 0 / 00 | - | - | - | - | - | 125482 | 80352000000 | -122.44023414 | 37.79553287 | - | 1299715200000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569260000 | SCOTT ST | - | - | - | - | - | - |
| 108178 | N/A | Point | - | - | - | - | S105495 | GREEN ST: SCOTT ST | - | F | F | - | F | 26870000 | 26870000 | R1-1.0002-1972-07-19 00: 00: 00-37.79553287--122.44023414 | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GREEN ST | GREEN ST | 2147 | 2147 | 37.79553287 | -122.44023414 | SCOTT ST \ GREEN ST | SCOTT ST \ GREEN ST | 1718760617000 | middleware_editor | STOP | GREEN ST intersection | - | 0 / 00 | - | - | - | - | - | 125483 | 80352000000 | -122.44023414 | 37.79553287 | - | 1556755200000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569260000 | SCOTT ST | - | - | - | - | - | - |
| 108179 | N/A | Point | - | - | - | - | S103937 | CLAY ST: POWELL ST | - | F | F | - | F | 25014000 | 25014000 | R6-1.0001-1967-10-11 00: 00: 00-37.79385193--122.40954105 | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POWELL ST | CLAY ST | 2175 | 2175 | 37.79385193 | -122.40954105 | CLAY ST \ POWELL ST | POWELL ST \ CLAY ST | 1717031968000 | middleware_editor | ONE WAY (LA) | CLAY ST intersection | - | 0 / 0 | - | - | - | - | - | 125484 | -70243200000 | -122.40954105 | 37.79385193 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373568780000 | POWELL ST | - | - | - | - | - | - |
| 108180 | N/A | Point | - | - | - | - | S103938 | PACIFIC AVE: POWELL ST | - | F | F | - | F | 25064000 | 25064000 | R6-1.0001-1967-10-11 00: 00: 00-37.79649276--122.41007597 | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PACIFIC AVE | PACIFIC AVE | 2176 | 2176 | 37.79649276 | -122.41007597 | POWELL ST \ PACIFIC AVE | POWELL ST \ PACIFIC AVE | 1744122140000 | middleware_editor | ONE WAY (LA) | PACIFIC AVE intersection | - | 0 / 0 | - | - | - | - | - | 125485 | -70218000000 | -122.41007597 | 37.79649276 | - | 1743005700000 | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373568780000 | POWELL ST | - | - | - | - | - | - |
| 108181 | N/A | Point | - | - | - | - | S105502 | SCOTT ST: GREEN ST | - | F | F | - | F | 26870000 | 26870000 | R1-1.0002-1972-07-19 00: 00: 00-37.79553287--122.44023414 | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GREEN ST | GREEN ST | 2218 | 2218 | 37.79553287 | -122.44023414 | SCOTT ST \ GREEN ST | SCOTT ST \ GREEN ST | 1718760644000 | middleware_editor | STOP | GREEN ST intersection | - | 0 / 0 | - | - | - | - | - | 125486 | 80352000000 | -122.44023414 | 37.79553287 | - | 1556841600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569260000 | SCOTT ST | - | - | - | - | - | - |
| 108182 | N/A | Point | - | - | - | - | S119484 | BEALE ST: MISSION ST | - | F | F | - | F | 24554000 | 24554000 | R10-3.0002-2004-10-05 00:00:00-37.79115281--122.39581342 | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BEALE ST | BEALE ST | 15905 | 15905 | 37.79115281 | -122.39581342 | MISSION ST \ BEALE ST | MISSION ST \ BEALE ST | 1710539427000 | MTA | START PED CROSSING (SYM)/DON'T START (HAND SYM)/ETC | BEALE ST intersection | - | - | - | - | - | - | - | 125487 | 1096934400000 | -122.39581342 | 37.79115281 | - | - | - | D6 | - | PEDESTRIAN | REG | R10-3.0002 | 09X12 | SUP1 | LIGHT POLE | IS | 1373573640000 | MISSION ST | - | - | - | - | - | - |
| 108183 | N/A | Point | - | - | - | - | S119496 | MISSION ST: BEALE ST | - | F | F | - | F | 24554000 | 24554000 | R10-3.0002-2004-10-05 00: 00: 00-37.79115281--122.39581342 | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BEALE ST | BEALE ST | 15912 | 15912 | 37.79115281 | -122.39581342 | MISSION ST \ BEALE ST | MISSION ST \ BEALE ST | 1710539427000 | MTA | START PED CROSSING (SYM)/DON'T START (HAND SYM)/ETC | BEALE ST intersection | - | - | - | - | - | - | - | 125488 | 1096934400000 | -122.39581342 | 37.79115281 | - | - | - | D6 | - | PEDESTRIAN | REG | R10-3.0002 | 09X12 | SUP1 | SIGNAL POLE | IS | 1373573640000 | MISSION ST | - | - | - | - | - | - |
| 108184 | N/A | Point | - | - | - | - | S119497 | MISSION ST: BEALE ST | - | F | F | - | F | 24554000 | 24554000 | R10-3.0002-2004-10-05 00:00:00-37.79115281--122.39581342 | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BEALE ST | BEALE ST | 15913 | 15913 | 37.79115281 | -122.39581342 | MISSION ST \ BEALE ST | MISSION ST \ BEALE ST | 1710539427000 | MTA | START PED CROSSING (SYM)/DON'T START (HAND SYM)/ETC | BEALE ST intersection | - | - | - | - | - | - | - | 125489 | 1096934400000 | -122.39581342 | 37.79115281 | - | - | - | D6 | - | PEDESTRIAN | REG | R10-3.0002 | 09X12 | SUP1 | LIGHT POLE | IS | 1373573640000 | MISSION ST | - | - | - | - | - | - |
| 108185 | N/A | Point | - | - | - | - | S115991 | POWELL ST: BUSH ST | - | F | F | - | F | 24976000 | 24976000 | R3-1.0002-2003-01-31 00:00:00-37.7901595--122.40878611 | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BUSH ST | BUSH ST | 16006 | 16006 | 37.7901595 | -122.40878611 | POWELL ST \ BUSH ST | POWELL ST \ BUSH ST | 1729097114000 | middleware_editor | NO RIGHT TURN (SYM) | BUSH ST intersection | - | SEE PHOTO#DSC00014.JPG BELOW NO LEF..... | - | - | - | - | - | 125490 | - | -122.40878611 | 37.7901595 | - | - | 1729071840000 | D3 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | 3IN IRON POST | RETD | 1373572560000 | POWELL ST | - | - | - | - | - | - |
| 108186 | N/A | Point | - | - | - | - | S115993 | POWELL ST: BUSH ST | - | F | F | - | F | 24976000 | 24976000 | R3-2.0003-2003-01-31 00:00:00-37.7901595--122.40878611 | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BUSH ST | BUSH ST | 16007 | 16007 | 37.7901595 | -122.40878611 | POWELL ST \ BUSH ST | POWELL ST \ BUSH ST | 1729097161000 | middleware_editor | NO LEFT TURN (SYM) | BUSH ST intersection | - | SEE PHOTO#DSC00014.JPG ABOVE NO RIG..... | - | - | - | - | - | 125491 | - | -122.40878611 | 37.7901595 | - | - | 1729071900000 | D3 | - | NO LEFT TURN | REG | R3-2.0003 | 36X36 | SUP1 | 3IN IRON POST | RETD | 1373572560000 | POWELL ST | - | - | - | - | - | - |
| 108187 | N/A | Point | - | - | - | - | S119609 | SANCHEZ ST: CUMBERLAND ST | - | F | F | - | F | 25716000 | 25716000 | W14-1.0001-2004-10-21 00:00:00-37.758756--122.43034437 | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SANCHEZ ST | CUMBERLAND ST | 16096 | 16096 | 37.758756 | -122.43034437 | CUMBERLAND ST \ SANCHEZ ST | SANCHEZ ST \ CUMBERLAND ST | 1710539427000 | MTA | DEAD END | CUMBERLAND ST intersection | - | NECORNER | - | - | - | - | - | 125492 | 1098316800000 | -122.43034437 | 37.758756 | - | 1402531200000 | - | D8 | - | OTHER WARNING | WARNING | W14-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373573700000 | SANCHEZ ST | - | - | - | - | - | - |
| 108188 | N/A | Point | - | - | - | - | S119610 | SANCHEZ ST: CUMBERLAND ST | - | F | F | - | F | 25716000 | 25716000 | W14-1.0001-2004-10-21 00:00:00-37.758756--122.43034437 | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SANCHEZ ST | CUMBERLAND ST | 16097 | 16097 | 37.758756 | -122.43034437 | CUMBERLAND ST \ SANCHEZ ST | SANCHEZ ST \ CUMBERLAND ST | 1710539427000 | MTA | DEAD END | CUMBERLAND ST intersection | - | NWCORNER | - | - | - | - | - | 125493 | 1098316800000 | -122.43034437 | 37.758756 | - | 1402531200000 | - | D8 | - | OTHER WARNING | WARNING | W14-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373573700000 | SANCHEZ ST | - | - | - | - | - | - |
| 108189 | N/A | Point | - | - | - | - | S119114 | CALIFORNIA ST: GRANT AVE | - | F | F | - | F | 24751000 | 24751000 | R3-2.0003-2004-06-26 00:00:00-37.79245075--122.40593812 | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GRANT AVE | CALIFORNIA ST | 16244 | 16244 | 37.79245075 | -122.40593812 | CALIFORNIA ST \ GRANT AVE | GRANT AVE \ CALIFORNIA ST | 1727801967000 | middleware_editor | NO LEFT TURN (SYM) | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 125494 | 1088208000000 | -122.40593812 | 37.79245075 | - | - | 1727776680000 | D3 | - | NO LEFT TURN | REG | R3-2.0003 | 36X36 | SUP1 | 2IN IRON POST | RETD | 1373573520000 | GRANT AVE | - | - | - | - | - | - |
| 108190 | N/A | Point | - | - | - | - | S119115 | CALIFORNIA ST: GRANT AVE | - | T | T | - | F | 24751000 | 24751000 | R3-2.0003-2004-06-26 00:00:00-37.79245075--122.40593812 | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GRANT AVE | CALIFORNIA ST | 16245 | 16245 | 37.79245075 | -122.40593812 | CALIFORNIA ST \ GRANT AVE | GRANT AVE \ CALIFORNIA ST | 1733182096000 | middleware_editor | NO RIGHT TURN (SYM) | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 125495 | 1088208000000 | -122.40593812 | 37.79245075 | - | 1728637500000 | - | D3 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1373573520000 | GRANT AVE | - | - | - | - | - | - |
| 108191 | N/A | Point | 1 | 1 | 3100 - 3199 | - | S116318 | 3100-3199 ORTEGA ST | 3100-3199 ORTEGA ST | F | F | - | F | - | 10027000 | R30(SF).0355-2003-03-12 00:00:00-37.7514512--122.4972363 | - | SOUTH SIDE | - | - | - | - | - | 38TH AVE | 16299 | 16299 | 37.7514512 | -122.4972363 | - | - | 1713489573000 | middleware_editor | NPPZ 8:30AM-9:30AM/3PM-4PM SCHL DAYS | 38TH AVE to 39TH AVE (3100 - 3199) | - | 50`WESTY | - | - | - | - | - | 125496 | 1047427200000 | -122.4972363 | 37.7514512 | - | - | - | D4 | - | OTHER REGULATORY | REG | R30(SF).0355 | 12X18 | SUP2 | 2IN IRON POST | IS | 1373572620000 | ORTEGA ST | - | 3100 - 3199 ORTEGA ST | 3100 ORTEGA ST | - | - | 39TH AVE |
| 108192 | N/A | Point | 1 | 1 | 3100 - 3199 | - | S116319 | 3100-3199 ORTEGA ST | 3100-3199 ORTEGA ST | F | F | - | F | - | 10027000 | R30(SF).0355-2003-03-12 00:00:00-37.7514512--122.4972363 | - | SOUTH SIDE | - | - | - | - | - | 38TH AVE | 16300 | 16300 | 37.7514512 | -122.4972363 | - | - | 1713489571000 | middleware_editor | NPPZ 8:30AM-9:30AM/3PM-4PM SCHL DAYS | 38TH AVE to 39TH AVE (3100 - 3199) | - | 98`WEST | - | - | - | - | - | 125497 | 1047427200000 | -122.4972363 | 37.7514512 | - | - | - | D4 | - | OTHER REGULATORY | REG | R30(SF).0355 | 12X18 | SUP2 | 2IN IRON POST | IS | 1373572620000 | ORTEGA ST | - | 3100 - 3199 ORTEGA ST | 3100 ORTEGA ST | - | - | 39TH AVE |
| 108193 | N/A | Point | 1 | 1 | 3100 - 3199 | - | S116320 | 3100-3199 ORTEGA ST | 3100-3199 ORTEGA ST | F | F | - | F | - | 10027000 | R30(SF).0355-2003-03-12 00:00:00-37.7514512--122.4972363 | - | SOUTH SIDE | - | - | - | - | - | 38TH AVE | 16301 | 16301 | 37.7514512 | -122.4972363 | - | - | 1713489606000 | middleware_editor | NPPZ 8:30AM-9:30AM/3PM-4PM SCHL DAYS | 38TH AVE to 39TH AVE (3100 - 3199) | - | OPP.NW CORNOR | - | - | - | - | - | 125498 | 1047427200000 | -122.4972363 | 37.7514512 | - | - | - | D4 | - | OTHER REGULATORY | REG | R30(SF).0355 | 12X18 | SUP2 | 2IN IRON POST | IS | 1373572620000 | ORTEGA ST | - | 3100 - 3199 ORTEGA ST | 3100 ORTEGA ST | - | - | 39TH AVE |
| 108194 | N/A | Point | 1 | - | - | - | S116373 | 3200-3299 VAN NESS AVE | - | F | F | - | F | 13174000 | 13174000 | R32(CA).0104-2003-03-27 00:00:00-37.80663475--122.42588422 | - | UNKNOWN | - | - | - | - | - | - | 16400 | 16400 | 37.80663475 | -122.42588422 | - | - | 1710539427000 | MTA | 4 HR PRK 8AM-6PM EXC SUN | - | - | 110N | - | - | - | - | - | 125499 | 1048723200000 | -122.42588422 | 37.80663475 | - | - | - | D2 | - | PARKING | REG | R32(CA).0104 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373572680000 | VAN NESS AVE | 3200-3299 VAN NESS AVE | VAN NESS AVE | - | - | - | - |
| 108195 | N/A | Point | 1 | - | - | - | S116374 | 3200-3299 VAN NESS AVE | - | F | F | - | F | 13174000 | 13174000 | R32(CA).0104-2003-03-27 00:00:00-37.80663475--122.42588422 | - | UNKNOWN | - | - | - | - | - | - | 16401 | 16401 | 37.80663475 | -122.42588422 | - | - | 1710539427000 | MTA | 4 HR PRK 8AM-6PM EXC SUN | - | - | 155N | - | - | - | - | - | 125500 | 1048723200000 | -122.42588422 | 37.80663475 | - | - | - | D2 | - | PARKING | REG | R32(CA).0104 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373572680000 | VAN NESS AVE | 3200-3299 VAN NESS AVE | VAN NESS AVE | - | - | - | - |
| 108196 | N/A | Point | 1 | - | - | - | S116375 | 3200-3299 VAN NESS AVE | - | F | F | - | F | 13174000 | 13174000 | R32(CA).0104-2003-03-27 00:00:00-37.80663475--122.42588422 | - | UNKNOWN | - | - | - | - | - | - | 16402 | 16402 | 37.80663475 | -122.42588422 | - | - | 1710539427000 | MTA | 4 HR PRK 8AM-6PM EXC SUN | - | - | 200N | - | - | - | - | - | 125501 | 1048723200000 | -122.42588422 | 37.80663475 | - | - | - | D2 | - | PARKING | REG | R32(CA).0104 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373572680000 | VAN NESS AVE | 3200-3299 VAN NESS AVE | VAN NESS AVE | - | - | - | - |
| 108197 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S139221 | 1500-1599 BAY ST | 1500-1599 BAY ST | F | F | - | F | 2789000 | 2789000 | R30B(CA).0067-2008-08-28 00: 00: 00-37.80316181--122.43250366 | - | SOUTH SIDE | - | - | - | - | LAGUNA ST | LAGUNA ST | 30331 | 30331 | 37.80316181 | -122.43250366 | - | - | 1736285783000 | middleware_editor | NPRK 12NN-2PM 1ST & 3RD THUR OF MONTH STCL | LAGUNA ST to BUCHANAN ST (1500 - 1599) | - | 100' WEST OF LAGUNA | - | - | - | - | - | 125502 | 1219881600000 | -122.43250366 | 37.80316181 | - | 1735642200000 | - | D2 | - | STREET CLEANING | REG | R30B(CA).0067 | 18X18 | SUP1 | 2IN IRON POST | IS | 1375724520000 | BAY ST | 1500 - 1599 BAY ST | 1500 - 1599 BAY ST | 1500 BAY ST | - | BUCHANAN ST | BUCHANAN ST |
| 108198 | N/A | Point | - | - | - | - | S136227 | CASTRO ST: DUNCAN ST | - | F | F | - | F | 22015000 | 22015000 | W14-1.0001-2012-03-30 00: 00: 00-37.74568669--122.43354538 | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CASTRO ST | DUNCAN ST | 30338 | 30338 | 37.74568669 | -122.43354538 | DUNCAN ST \ CASTRO ST | CASTRO ST \ DUNCAN ST | 1710539427000 | MTA | DEAD END | DUNCAN ST intersection | - | - | - | - | - | - | - | 125503 | 1333065600000 | -122.43354538 | 37.74568669 | - | - | - | D8 | - | OTHER WARNING | WARNING | W14-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373578860000 | CASTRO ST | - | - | - | - | - | - |
| 108199 | N/A | Point | - | - | - | - | S136228 | DUNCAN ST: CASTRO ST | - | F | F | - | F | 22015000 | 22015000 | W14-1.0001-2012-03-30 00: 00: 00-37.74568669--122.43354538 | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CASTRO ST | DUNCAN ST | 30339 | 30339 | 37.74568669 | -122.43354538 | DUNCAN ST \ CASTRO ST | CASTRO ST \ DUNCAN ST | 1710539427000 | MTA | DEAD END | DUNCAN ST intersection | - | - | - | - | - | - | - | 125504 | 1333065600000 | -122.43354538 | 37.74568669 | - | - | - | D8 | - | OTHER WARNING | WARNING | W14-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373578860000 | CASTRO ST | - | - | - | - | - | - |
| 108200 | N/A | Point | - | - | - | - | S138264 | POWELL ST: BUSH ST | - | F | F | - | F | 24976000 | 24976000 | R15-5.0001-2013-05-14 00:00:00-37.7901595--122.40878611 | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BUSH ST | BUSH ST | 30372 | 30372 | 37.7901595 | -122.40878611 | POWELL ST \ BUSH ST | POWELL ST \ BUSH ST | 1729128238000 | middleware_editor | LRV (SYM) DO NOT PASS | BUSH ST intersection | - | 15N / ABOVE "CABLE CAR STOP" SIGN | - | - | - | - | - | 125505 | 1368489600000 | -122.40878611 | 37.7901595 | - | - | - | D3 | - | OTHER REGULATORY | REG | R15-5.0001 | 24X30 | SUP1 | SIGNAL POLE | IS | 1373579520000 | POWELL ST | - | - | - | - | - | - |
| 108201 | N/A | Point | - | - | - | - | S136910 | DUBOCE AVE: SANCHEZ ST | - | F | F | - | F | 25986000 | 25986000 | R1-3P.0001-2012-07-05 00:00:00-37.76932091--122.43135662 | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 30484 | 30484 | 37.76932091 | -122.43135662 | SANCHEZ ST \ DUBOCE AVE | SANCHEZ ST \ DUBOCE AVE | 1714142134000 | middleware_editor | ALL WAY | DUBOCE AVE intersection | - | - | - | - | - | - | - | 125506 | 1341446400000 | -122.43135662 | 37.76932091 | - | - | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373579100000 | SANCHEZ ST | - | - | - | - | - | - |
| 108202 | N/A | Point | - | - | - | - | S136904 | SANCHEZ ST: DUBOCE AVE | - | F | F | - | F | 25986000 | 25986000 | R1-3P.0001-2012-07-05 00:00:00-37.76932091--122.43135662 | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 30543 | 30543 | 37.76932091 | -122.43135662 | SANCHEZ ST \ DUBOCE AVE | SANCHEZ ST \ DUBOCE AVE | 1714180126000 | middleware_editor | ALL WAY | DUBOCE AVE intersection | - | - | - | - | - | - | - | 125507 | 1341446400000 | -122.43135662 | 37.76932091 | - | 1675036800000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373579100000 | SANCHEZ ST | - | - | - | - | - | - |
| 108203 | N/A | Point | - | - | - | - | S136946 | JENNINGS ST: CARGO WAY | - | F | F | - | F | 33104000 | 33104000 | R1-3P.0001-2012-07-12 00:00:00-37.74019197--122.37684734 | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JENNINGS ST | CARGO WAY | 30547 | 30547 | 37.74019197 | -122.37684734 | CARGO WAY \ JENNINGS ST | JENNINGS ST \ CARGO WAY | 1710539427000 | MTA | ALL WAY | CARGO WAY intersection | - | - | - | - | - | - | - | 125508 | 1342051200000 | -122.37684734 | 37.74019197 | - | - | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373579100000 | JENNINGS ST | - | - | - | - | - | - |
| 108204 | N/A | Point | 1 | 1 | 2900 - 2999 | - | S139527 | 2900-2999 VALLEJO ST | 2900-2999 VALLEJO ST | F | F | - | F | 13123000 | 13123000 | R30B(CA).0065-2008-08-29 00:00:00-37.79386393--122.44581161 | - | NORTH SIDE | - | - | - | - | BAKER ST | BAKER ST | 30560 | 30560 | 37.79386393 | -122.44581161 | - | - | 1722452321000 | middleware_editor | NPRK 12NN-2PM 1ST & 3RD FRI OF MONTH STCL | BAKER ST to LYON ST (2900 - 2999) | - | 227 FEET WEST OF BAKER | - | - | - | - | - | 125509 | 1219968000000 | -122.44581161 | 37.79386393 | - | 1722348240000 | - | D2 | - | STREET CLEANING | REG | R30B(CA).0065 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1375724640000 | VALLEJO ST | 2900 - 2999 VALLEJO ST | 2900 - 2999 VALLEJO ST | 2900 VALLEJO ST | - | LYON ST | LYON ST |
| 108205 | N/A | Point | 1 | 1 | 2900 - 2999 | - | S139528 | 2900-2999 VALLEJO ST | 2900-2999 VALLEJO ST | F | F | - | F | 30821000 | 13123000 | R30B(CA).0065-2008-08-29 00:00:00-37.79386393--122.44581161 | - | NORTH SIDE | - | - | - | - | VALLEJO ST | BAKER ST | 30561 | 30561 | 37.79386393 | -122.44581161 | LYON ST \ VALLEJO ST | - | 1721761859000 | middleware_editor | NPRK 12NN-2PM 1ST & 3RD FRI OF MONTH STCL | BAKER ST to LYON ST (2900 - 2999) | - | 4 FEET EAST OF LYON | - | - | - | - | - | 125510 | 1219968000000 | -122.44581161 | 37.79386393 | - | - | - | D2 | - | STREET CLEANING | REG | R30B(CA).0065 | 18X18 | SUP1 | LIGHT POLE | IS | 1375724640000 | VALLEJO ST | - | 2900 - 2999 VALLEJO ST | 2900 VALLEJO ST | - | - | LYON ST |
| 108206 | N/A | Point | - | - | - | - | S137525 | VASQUEZ AVE: GARCIA AVE | - | F | F | - | F | 22883000 | 22883000 | R2-1.0003-2012-11-15 00:00:00-37.74383566--122.46103142 | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VASQUEZ AVE | GARCIA AVE | 30689 | 30689 | 37.74383566 | -122.46103142 | GARCIA AVE \ VASQUEZ AVE | VASQUEZ AVE \ GARCIA AVE | 1710539427000 | MTA | SPEED LIMIT 15 | GARCIA AVE intersection | - | - | - | - | - | - | - | 125511 | 1352937600000 | -122.46103142 | 37.74383566 | - | - | - | D7 | - | SPEED LIMIT | REG | R2-1.0003 | 24X30 | SUP2 | 2IN IRON POST | IS | 1373579280000 | VASQUEZ AVE | - | - | - | - | - | - |
| 108207 | N/A | Point | 1 | 1 | 4300 - 4399 | - | S135085 | 4300-4399 17TH ST | 4300-4399 17TH ST | F | F | - | F | 816000 | 816000 | R37(CA).0090-2011-10-11 00:00:00-37.76210502--122.44153816 | - | SOUTH SIDE | - | - | - | - | ORD ST | ORD ST | 30693 | 30693 | 37.76210502 | -122.44153816 | - | - | 1710539427000 | MTA | TANSAT | ORD ST to CORBIN PL (4300 - 4399) | - | 35'E OF CORBIN | - | - | - | - | - | 125512 | 1318291200000 | -122.44153816 | 37.76210502 | - | - | - | D8 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373578500000 | 17TH ST | 4300 - 4399 17TH ST | 4300 - 4399 17TH ST | 4300 17TH ST | - | CORBIN PL | CORBIN PL |
| 108208 | N/A | Point | 1 | 1 | 4300 - 4399 | - | S135086 | 4300-4399 17TH ST | 4300-4399 17TH ST | F | F | - | F | 816000 | 816000 | R37(CA).0090-2011-10-11 00:00:00-37.76210502--122.44153816 | - | SOUTH SIDE | - | - | - | - | ORD ST | ORD ST | 30694 | 30694 | 37.76210502 | -122.44153816 | - | - | 1718242563000 | middleware_editor | TANSAT | ORD ST to CORBIN PL (4300 - 4399) | - | 35'W OF CORBIN | - | - | - | - | - | 125513 | 1318291200000 | -122.44153816 | 37.76210502 | - | - | - | D8 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373578500000 | 17TH ST | 4300 - 4399 17TH ST | 4300 - 4399 17TH ST | 4300 17TH ST | - | CORBIN PL | CORBIN PL |
| 108209 | N/A | Point | 1 | 1 | 600 - 699 | - | S141249 | 600-699 39TH AVE | 600-699 39TH AVE | F | F | - | F | 1866000 | 1866000 | R30B(CA).0021-2008-09-11 00:00:00-37.7765501--122.49952269 | - | WEST SIDE | - | - | - | - | ANZA ST | ANZA ST | 30718 | 30718 | 37.7765501 | -122.49952269 | - | - | 1737068255000 | middleware_editor | NPRK 11AM-1PM 2ND & 4TH FRI OF MONTH STCL | ANZA ST to BALBOA ST (600 - 699) | - | 655 39TH AVE | - | - | - | - | - | 125514 | 1221091200000 | -122.49952269 | 37.7765501 | - | 1736990760000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0021 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375725720000 | 39TH AVE | 600 - 699 39TH AVE | 600 - 699 39TH AVE | 600 39TH AVE | - | BALBOA ST | BALBOA ST |
| 108210 | N/A | Point | - | - | - | - | S135372 | JACKSON ST: COLUMBUS AVE | - | F | F | - | F | 24766000 | 24766000 | R37(CA).0090-2011-11-17 00:00:00-37.7963021--122.40441216 | - | SOUTH WEST CORNER | - | - | - | - | JACKSON ST | COLUMBUS AVE | 30733 | 30733 | 37.7963021 | -122.40441216 | COLUMBUS AVE \ JACKSON ST | JACKSON ST \ COLUMBUS AVE | 1746134727000 | middleware_editor | TANSAT | COLUMBUS AVE intersection | - | - | - | - | - | - | - | 125515 | 1321516800000 | -122.40441216 | 37.7963021 | - | - | - | D3 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | RETD | 1373578620000 | JACKSON ST | - | - | - | - | - | - |
| 108211 | N/A | Point | 1 | 1 | 2746 - 2799 | - | S214267 | 2746-2799 24TH ST | 2746-2799 24TH ST | F | F | - | F | 1331000 | 1331000 | R(SF).0020-2015-03-17 15:26:00-37.75287951--122.40774008 | - | SOUTH SIDE | - | - | - | - | HAMPSHIRE ST | HAMPSHIRE ST | 51247 | 51247 | 37.75287951 | -122.40774008 | - | - | 1710539427000 | MTA | BIKE RACK | HAMPSHIRE ST to YORK ST (2746 - 2799) | - | 10'6" W OF WPL 2781/3' FROM CURB | - | - | - | - | - | 125516 | 1426550400000 | -122.40774008 | 37.75287951 | - | 1708090200000 | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1426501320000 | 24TH ST | 2746 - 2799 24TH ST | 2746 - 2799 24TH ST | 2746 24TH ST | - | YORK ST | YORK ST |
| 108212 | N/A | Point | 1 | 1 | 4100 - 4149 | - | S211120 | 4100-4149 20TH ST | 4100-4149 20TH ST | F | F | - | F | 1065000 | 1065000 | R28(CA).0005-2015-03-06 13:51:00-37.75778702--122.43303763 | - | EAST SIDE | - | - | - | - | NOE ST | NOE ST | 51361 | 51361 | 37.75778702 | -122.43303763 | - | - | 1710539427000 | MTA | NPRK ANY TIME(RA) | NOE ST to HARTFORD ST (4100 - 4149) | - | 22FT.SOUTH OF 20TH ST/ ON NOE ST | - | - | - | - | - | 125517 | 1425649860000 | -122.43303763 | 37.75778702 | - | 1425600000000 | - | D8 | - | PARKING:NPRK ANY TIME | REG | R28(CA).0005 | 12X18 | SUP2 | 2IN IRON POST | IS | 1416828900000 | 20TH ST | 4100 - 4149 20TH ST | 4100 - 4149 20TH ST | 4100 20TH ST | - | HARTFORD ST | HARTFORD ST |
| 108213 | N/A | Point | 1 | 1 | 4100 - 4149 | - | S211121 | 4100-4149 20TH ST | 4100-4149 20TH ST | F | F | - | F | 1065000 | 1065000 | R32C(CA).0126-2015-03-06 13:52:00-37.75778702--122.43303763 | - | EAST SIDE | - | - | - | - | NOE ST | NOE ST | 51362 | 51362 | 37.75778702 | -122.43303763 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | NOE ST to HARTFORD ST (4100 - 4149) | - | 22FT.SOUTH OF 20TH ST/ ON NOE ST | - | - | - | - | - | 125518 | 1425649920000 | -122.43303763 | 37.75778702 | - | 1425600000000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | 2IN IRON POST | IS | 1416829200000 | 20TH ST | 4100 - 4149 20TH ST | 4100 - 4149 20TH ST | 4100 20TH ST | - | HARTFORD ST | HARTFORD ST |
| 108214 | N/A | Point | - | - | - | - | S214673 | CASTRO ST: 17TH ST \ MARKET ST | - | F | F | - | F | 25814000 | 25814000 | R13A(CA).0002-1966-06-01 00:00:00-37.76267071--122.43518796 | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CASTRO ST \ MARKET ST | 17TH ST \ CASTRO ST | 51509 | 51509 | 37.76267071 | -122.43518796 | 17TH ST \ CASTRO ST \ MARKET ST | MARKET ST \ 17TH ST \ CASTRO ST | 1712874573000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | 17TH ST \ CASTRO ST intersection | - | RELOCATE TO CORNER OF MARKET SEE NOTES | - | - | - | - | - | 125519 | -113184000000 | -122.43518796 | 37.76267071 | - | 1428537600000 | - | D8 | - | NO RIGHT TURN | REG | R13A(CA).0002 | 24X30 | SUP2 | 2IN IRON POST | IS | 1427458800000 | MARKET ST | - | - | - | - | - | - |
| 108215 | N/A | Point | - | - | - | - | S213175 | SLOAT BLVD: BEACHMONT DR | - | F | F | - | F | 11950204 | 23146000 | SW24-1(CA).0001-2019-12-18 08:30:00-37.73456825--122.47411891 | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | AVON WAY | BEACHMONT DR | 51575 | 51575 | 37.73456825 | -122.47411891 | - | SLOAT BLVD \ BEACHMONT DR | 1717204186000 | middleware_editor | SCHOOL (SYM)/SCHOOL | BEACHMONT DR intersection | - | OPP.C-LINE OF BEACHMONT | - | - | - | - | - | 125520 | 1576657800000 | -122.47411891 | 37.73456825 | - | - | - | D7 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 3IN IRON POST | IS | 1422964860000 | SLOAT BLVD | 200 - 298 SLOAT BLVD | - | - | - | 19TH AVE | - |
| 108216 | N/A | Point | - | - | - | - | S213176 | SLOAT BLVD: BEACHMONT DR | - | F | F | - | F | 11950204 | 23146000 | SW24-1(CA).0001-2019-12-18 08:50:00-37.73456825--122.47411891 | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | AVON WAY | BEACHMONT DR | 51576 | 51576 | 37.73456825 | -122.47411891 | - | SLOAT BLVD \ BEACHMONT DR | 1717204215000 | middleware_editor | SCHOOL (SYM)/SCHOOL | BEACHMONT DR intersection | - | OPP.DRIVEWAY TO SCHOOL @ BEACHMONT | - | - | - | - | - | 125521 | 1576659000000 | -122.47411891 | 37.73456825 | - | - | - | D7 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1422965100000 | SLOAT BLVD | 200 - 298 SLOAT BLVD | - | - | - | 19TH AVE | - |
| 108217 | N/A | Point | 1 | - | - | - | S212761 | 301-399 JEFFERSON ST | - | F | F | - | F | 7458000 | 7458000 | R37(CA).0090-None-37.80790822--122.418266 | - | SOUTH SIDE | - | - | - | - | - | - | 51642 | 51642 | 37.80790822 | -122.418266 | - | - | 1710539427000 | MTA | TANSAT | - | - | EPL # 333 JEFFERSON | - | - | - | - | - | 125522 | - | -122.418266 | 37.80790822 | - | 1647561600000 | - | D3 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1421850000000 | JEFFERSON ST | 301-399 JEFFERSON ST | JEFFERSON ST | - | - | - | - |
| 108218 | N/A | Point | - | - | - | - | S212834 | 17TH AVE: LAWTON ST | - | F | F | - | F | 27331000 | 27331000 | W17-1.0001-2015-02-10 12:00:00-37.75806093--122.47459373 | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 17TH AVE | 17TH AVE | 51707 | 51707 | 37.75806093 | -122.47459373 | LAWTON ST \ 17TH AVE | LAWTON ST \ 17TH AVE | 1751385750000 | middleware_editor | SPEED HUMP | 17TH AVE intersection | - | 3`IFO TREE | - | - | - | - | - | 125523 | 1423598400000 | -122.47459373 | 37.75806093 | - | 1423555200000 | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1422011520000 | LAWTON ST | - | - | - | - | - | - |
| 108219 | N/A | Point | - | - | - | - | S214427 | STOCKTON ST: SACRAMENTO ST \ S | - | F | F | - | F | 24996000 | 24996000 | TYPE-DL.0001-2015-05-20 10:30:00-37.7931783--122.40772719 | - | WEST SIDE | - | - | - | - | STOCKTON ST \ STOCKTON TUNL | SACRAMENTO ST \ STOCKTON TUNL | 51882 | 51882 | 37.7931783 | -122.40772719 | SACRAMENTO ST \ STOCKTON ST \ STOCKTON TUNL | STOCKTON ST \ SACRAMENTO ST \ STOCKTON TUNL | 1718413950000 | middleware_editor | DELINEATOR (W) (SAFE HIT) | SACRAMENTO ST \ STOCKTON TUNL intersection | - | X ST IS SACREMENTO SEE DOCUMENTS | - | - | - | - | - | 125524 | 1432117800000 | -122.40772719 | 37.7931783 | - | 1432080000000 | - | D3 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1426857720000 | STOCKTON ST | - | - | - | - | - | - |
| 108220 | N/A | Point | 1 | 1 | 100 - 199 | - | S210660 | 100-199 POWELL ST | 100-199 POWELL ST | F | F | - | F | 10676000 | 10676000 | R26K(SF).0159-None-37.78595059--122.40794438 | - | WEST SIDE | - | - | - | - | ELLIS ST | ELLIS ST | 51895 | 51895 | 37.78595059 | -122.40794438 | - | - | 1710539427000 | MTA | TANP EXCEPT ACTIVE LOADING | ELLIS ST to OFARRELL ST (100 - 199) | - | 25' S. IFO # 135 | - | - | - | - | - | 125525 | - | -122.40794438 | 37.78595059 | - | - | - | D3 | - | TOW (TANP ANY TIME) | REG | R26K(SF).0159 | 18X21 | SUP1 | LIGHT POLE | IS | 1415365380000 | POWELL ST | 100 - 199 POWELL ST | 100 - 199 POWELL ST | 100 POWELL ST | - | OFARRELL ST | OFARRELL ST |
| 108221 | N/A | Point | 1 | 1 | 100 - 136 | - | S212891 | 100-136 3RD ST | 100-136 03RD ST | T | T | - | F | 166000 | 166000 | R37(CA).0090-2009-04-16 00:00:00-37.78603868--122.40175763 | - | EAST SIDE | - | - | - | - | MISSION ST | MISSION ST | 51918 | 51918 | 37.78603868 | -122.40175763 | - | - | 1710539427000 | MTA | TANSAT | MISSION ST to MINNA ST (100 - 136) | - | 100FT NORTH OF HOWARD | - | - | - | - | - | 125526 | 1239840000000 | -122.40175763 | 37.78603868 | - | - | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1422290280000 | 03RD ST | 100 - 136 3RD ST | 100 - 136 03RD ST | 100 3RD ST | - | MINNA ST | MINNA ST |
| 108222 | N/A | Point | 1 | 1 | 125 - 299 | - | S213892 | 125-299 EDGEWOOD AVE | 125-299 EDGEWOOD AVE | F | F | - | F | 5084000 | 5084000 | R32C(CA).0158-2010-10-12 00:00:00-37.76192564--122.4549907 | - | EAST SIDE | - | - | - | - | BELMONT AVE | BELMONT AVE | 51987 | 51987 | 37.76192564 | -122.4549907 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-5PM MON-FRI EXC "J" PERMITS | BELMONT AVE to END: 125-299 BLOCK (125 - 299) | - | OPP#191 | - | - | - | - | - | 125527 | 1286841600000 | -122.4549907 | 37.76192564 | - | - | - | D5 | - | PARKING:RPP | REG | R32C(CA).0158 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1425042840000 | EDGEWOOD AVE | 125 - 299 EDGEWOOD AVE | 125 - 299 EDGEWOOD AVE | 125 EDGEWOOD AVE | - | END: 125-299 BLOCK | END: 125-299 BLOCK |
| 108223 | N/A | Point | 1 | 1 | 125 - 299 | - | S213894 | 125-299 EDGEWOOD AVE | 125-299 EDGEWOOD AVE | F | F | - | F | 5084000 | 5084000 | R32C(CA).0158-2010-10-12 00:00:00-37.76192564--122.4549907 | - | EAST SIDE | - | - | - | - | BELMONT AVE | BELMONT AVE | 51988 | 51988 | 37.76192564 | -122.4549907 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-5PM MON-FRI EXC "J" PERMITS | BELMONT AVE to END: 125-299 BLOCK (125 - 299) | - | OPP#257 | - | - | - | - | - | 125528 | 1286841600000 | -122.4549907 | 37.76192564 | - | - | - | D5 | - | PARKING:RPP | REG | R32C(CA).0158 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1425043440000 | EDGEWOOD AVE | 125 - 299 EDGEWOOD AVE | 125 - 299 EDGEWOOD AVE | 125 EDGEWOOD AVE | - | END: 125-299 BLOCK | END: 125-299 BLOCK |
| 108224 | N/A | Point | 1 | 1 | 125 - 299 | LEFT ARROW | S213895 | 125-299 EDGEWOOD AVE | 125-299 EDGEWOOD AVE | F | F | - | F | 5084000 | 5084000 | R26(CA).0001-2010-10-12 00:00:00-37.76192564--122.4549907 | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | BELMONT AVE | BELMONT AVE | 52044 | 52044 | 37.76192564 | -122.4549907 | - | - | 1710539427000 | MTA | NPRK ANY TIME | BELMONT AVE to END: 125-299 BLOCK (125 - 299) | - | OPP#299 | - | - | - | - | - | 125529 | 1286841600000 | -122.4549907 | 37.76192564 | - | 1546819200000 | - | D5 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1425043680000 | EDGEWOOD AVE | 125 - 299 EDGEWOOD AVE | 125 - 299 EDGEWOOD AVE | 125 EDGEWOOD AVE | - | END: 125-299 BLOCK | END: 125-299 BLOCK |
| 108225 | N/A | Point | - | - | - | - | S213209 | DUBOCE AVE: SANCHEZ ST | - | F | F | - | F | 25986000 | 25986000 | R1-3P.0001-1957-07-25 00:00:00-37.76932091--122.43135662 | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 52072 | 52072 | 37.76932091 | -122.43135662 | SANCHEZ ST \ DUBOCE AVE | SANCHEZ ST \ DUBOCE AVE | 1714180156000 | middleware_editor | ALL WAY | DUBOCE AVE intersection | - | - | - | - | - | - | - | 125530 | -392515200000 | -122.43135662 | 37.76932091 | - | - | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1423048920000 | SANCHEZ ST | - | - | - | - | - | - |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in meters