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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23926 | N/A | Point | 1 | 1 | 100 - 199 | - | S229705 | 100-199 CLEMENT ST | 100-199 CLEMENT ST | F | F | - | F | 4151000 | 4151000 | - | - | SOUTH SIDE | - | - | - | - | 2ND AVE | 02ND AVE | 65410 | 65410 | 37.78311197 | -122.46067234 | - | - | 1710539427000 | MTA | BIKE RACK | 02ND AVE to 03RD AVE (100 - 199) | 201600276 | 11 FT6" EAST OF WPL#127 3FT FROM CRUB | - | - | - | - | - | 41004 | 1478085840000 | -122.46067234 | 37.78311197 | - | 1478044800000 | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1476181860000 | CLEMENT ST | 100 - 199 CLEMENT ST | 100 - 199 CLEMENT ST | 100 CLEMENT ST | - | 03RD AVE | 03RD AVE |
| 23927 | N/A | Point | 1 | 1 | 500 - 599 | LEFT ARROW | S230598 | 500-599 RANDOLPH ST | 500-599 RANDOLPH ST | F | F | - | F | 10920000 | 10920000 | - | - | NORTH SIDE | - | - | - | - | ARCH ST | ARCH ST | 65428 | 65428 | 37.71426972 | -122.46754523 | - | - | 1710539427000 | MTA | PARK PARALLEL | ARCH ST to VERNON ST (500 - 599) | - | EPL #530 | - | - | - | - | - | 41005 | 1493223120000 | -122.46754523 | 37.71426972 | - | 1493164800000 | - | D11 | - | PARKING:PARALLEL | REG | R24(CA).0001 | 18X18 | SUP2 | 2IN IRON POST | IS | 1478086740000 | RANDOLPH ST | 500 - 599 RANDOLPH ST | 500 - 599 RANDOLPH ST | 500 RANDOLPH ST | - | VERNON ST | VERNON ST |
| 23928 | N/A | Point | - | - | - | - | S230599 | BREWSTER ST: RUTLEDGE ST | - | F | F | - | F | 20828000 | 20828000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | BREWSTER ST | BREWSTER ST | 65429 | 65429 | 37.74533332 | -122.40673737 | RUTLEDGE ST \ BREWSTER ST | RUTLEDGE ST \ BREWSTER ST | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | BREWSTER ST intersection | - | OPP. CENTER LINE RUTLEDGE ST | - | - | - | - | - | 41006 | 1486045800000 | -122.40673737 | 37.74533332 | - | 1485993600000 | - | D9 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | 2IN IRON POST | IS | 1478086800000 | RUTLEDGE ST | - | - | - | - | - | - |
| 23929 | N/A | Point | - | - | - | - | S230600 | BREWSTER ST: FAITH ST | - | F | F | - | F | 21093000 | 21093000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | BREWSTER ST | FAITH ST | 65430 | 65430 | 37.74435937 | -122.40707554 | FAITH ST \ BREWSTER ST | BREWSTER ST \ FAITH ST | 1710539427000 | MTA | SPEED LIMIT 15 | FAITH ST intersection | - | OPP. WEST LINE OF FAITH ST. | - | - | - | - | - | 41007 | 1480417620000 | -122.40707554 | 37.74435937 | - | 1480377600000 | - | D9 | - | SPEED LIMIT | REG | R2-1.0003 | 24X30 | SUP2 | 2IN IRON POST | IS | 1478087580000 | BREWSTER ST | - | - | - | - | - | - |
| 23930 | N/A | Point | 1 | 1 | 14 - 49 | - | S230601 | 1-21 JUAN BAUTISTA CIR | 14-49 JUAN BAUTISTA CIR | F | F | - | F | 7622000 | 7622000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | FUENTE AVE | FUENTE AVE | 65431 | 65431 | 37.71862762 | -122.47833748 | - | - | 1710539427000 | MTA | SPEED LIMIT 25 | FUENTE AVE to FONT BLVD (14 - 49) | - | IFO#4 | - | - | - | - | - | 41008 | 1479723000000 | -122.47833748 | 37.71862762 | - | 1479686400000 | - | D7 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP2 | 2IN IRON POST | IS | 1478088060000 | JUAN BAUTISTA CIR | 14 - 49 JUAN BAUTISTA CIR | 14 - 49 JUAN BAUTISTA CIR | 14 JUAN BAUTISTA CIR | - | FONT BLVD | FONT BLVD |
| 23931 | N/A | Point | 1 | 1 | 500 - 599 | - | S229408 | 500-599 CLEMENT ST | 500-599 CLEMENT ST | F | F | - | F | 4155000 | 4155000 | - | - | NORTH SIDE | - | - | - | - | 6TH AVE | 06TH AVE | 65434 | 65434 | 37.78291546 | -122.46495871 | - | - | 1710539427000 | MTA | BIKE RACK | 06TH AVE to 07TH AVE (500 - 599) | - | IFO#520(90FT. WEST OF 6TH AVE) | - | - | - | - | - | 41009 | - | -122.46495871 | 37.78291546 | - | - | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BARRICADE | IS | 1475222640000 | CLEMENT ST | 500 - 599 CLEMENT ST | 500 - 599 CLEMENT ST | 500 CLEMENT ST | - | 07TH AVE | 07TH AVE |
| 23932 | N/A | Point | 1 | 1 | 216 - 299 | - | S229736 | 216-299 CORTLAND AVE | 216-299 CORTLAND AVE | F | F | - | F | 4422000 | 4422000 | - | - | NORTH SIDE | - | - | - | - | BONVIEW ST | BONVIEW ST | 65435 | 65435 | 37.73941536 | -122.41887485 | - | - | 1735581830000 | middleware_editor | BIKE RACK | BONVIEW ST to BOCANA ST (216 - 299) | 201600243 | IFO#231 4FT FROM CRUB | - | - | - | - | - | 41010 | 1476964500000 | -122.41887485 | 37.73941536 | - | 1476921600000 | 1734952500000 | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | RETD | 1476263760000 | CORTLAND AVE | 216 - 299 CORTLAND AVE | 216 - 299 CORTLAND AVE | 216 CORTLAND AVE | - | BOCANA ST | BOCANA ST |
| 23933 | N/A | Point | 1 | 1 | 1450 - 1499 | - | S229737 | 1450-1499 CHURCH ST | 1450-1499 CHURCH ST | F | F | - | F | 4032000 | 4032000 | - | - | WEST SIDE | - | - | - | - | CESAR CHAVEZ ST | CESAR CHAVEZ ST | 65436 | 65436 | 37.74729622 | -122.42700687 | - | - | 1710539427000 | MTA | BIKE RACK | CESAR CHAVEZ ST to 27TH ST (1450 - 1499) | 201600240 | 4 FT NORTH OF SPL#1404 4FT FROM CRUB | - | - | - | - | - | 41011 | 1484222340000 | -122.42700687 | 37.74729622 | - | 1484179200000 | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1476264720000 | CHURCH ST | 1450 - 1499 CHURCH ST | 1450 - 1499 CHURCH ST | 1450 CHURCH ST | - | 27TH ST | 27TH ST |
| 23934 | N/A | Point | 1 | 1 | 3900 - 3999 | - | S229738 | 3900-3999 26TH ST | 3900-3999 26TH ST | F | F | - | F | 1536000 | 1536000 | - | - | WEST SIDE | - | - | - | - | CHURCH ST | CHURCH ST | 65437 | 65437 | 37.74842905 | -122.42823463 | - | - | 1710539427000 | MTA | BIKE RACK | CHURCH ST to SANCHEZ ST (3900 - 3999) | 201600239 | 10' N - 3FT FROM CURB | - | - | - | - | - | 41012 | 1486723920000 | -122.42823463 | 37.74842905 | - | 1486684800000 | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1476264960000 | 26TH ST | 3900 - 3999 26TH ST | 3900 - 3999 26TH ST | 3900 26TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 23935 | N/A | Point | 1 | 1 | 3900 - 3999 | - | S229739 | 3900-3999 26TH ST | 3900-3999 26TH ST | F | F | - | F | 1536000 | 1536000 | - | - | NORTH SIDE | - | - | - | - | CHURCH ST | CHURCH ST | 65438 | 65438 | 37.74842905 | -122.42823463 | - | - | 1710539427000 | MTA | BIKE RACK | CHURCH ST to SANCHEZ ST (3900 - 3999) | 201600239 | 10 FT EAST 3FT FROM CRUB | - | - | - | - | - | 41013 | 1484231640000 | -122.42823463 | 37.74842905 | - | 1484179200000 | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1476265140000 | 26TH ST | 3900 - 3999 26TH ST | 3900 - 3999 26TH ST | 3900 26TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 23936 | N/A | Point | 1 | 1 | 500 - 549 | - | S229744 | 500-549 CHURCH ST | 500-549 CHURCH ST | F | F | - | F | 4014000 | 4014000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 65439 | 65439 | 37.76248878 | -122.42846998 | - | - | 1710539427000 | MTA | BIKE RACK | 17TH ST to DORLAND ST (500 - 549) | 201600233 | 19FT SOUTH OF NPL#487 4FT FROM CRUB | - | - | - | - | - | 41014 | 1480598940000 | -122.42846998 | 37.76248878 | - | 1480550400000 | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1476266160000 | CHURCH ST | 500 - 549 CHURCH ST | 500 - 549 CHURCH ST | 500 CHURCH ST | - | DORLAND ST | DORLAND ST |
| 23937 | N/A | Point | 1 | 1 | 300 - 399 | - | S229747 | 300-399 CHURCH ST | 300-399 CHURCH ST | F | F | - | F | 4011000 | 4011000 | - | - | EAST SIDE | - | - | - | - | 15TH ST | 15TH ST | 65440 | 65440 | 37.76531882 | -122.42874214 | - | - | 1711414015000 | middleware_editor | BIKE RACK | 15TH ST to 16TH ST (300 - 399) | 201600231 | 10 FT SOUTH OF NPL#225 3FT FROM CRUB | - | - | - | - | - | 41015 | 1480602840000 | -122.42874214 | 37.76531882 | - | 1480550400000 | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1476267240000 | CHURCH ST | 300 - 399 CHURCH ST | 300 - 399 CHURCH ST | 300 CHURCH ST | - | 16TH ST | 16TH ST |
| 23938 | N/A | Point | - | - | - | - | S230244 | WOOLSEY ST: END | - | F | F | - | F | 51661000 | 51661000 | - | - | NORTH EAST CORNER | - | - | - | - | WOOLSEY ST | WOOLSEY ST | 66092 | 66092 | 37.72534003 | -122.4021791 | WOOLSEY ST \ WOOLSEY ST | WOOLSEY ST \ WOOLSEY ST | 1710539427000 | MTA | ALL WAY | WOOLSEY ST intersection | - | OF WOOLSEY ST & UNIVERSITY ST | - | - | - | - | - | 41016 | 1496158560000 | -122.4021791 | 37.72534003 | - | 1496102400000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477555740000 | WOOLSEY ST | - | - | - | - | - | - |
| 23939 | N/A | Point | - | - | - | - | S230421 | GIRARD ST: BURROWS ST | - | F | F | - | F | 20652000 | 20652000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GIRARD ST | BURROWS ST | 66093 | 66093 | 37.72857432 | -122.40509102 | BURROWS ST \ GIRARD ST | GIRARD ST \ BURROWS ST | 1726154164000 | middleware_editor | ALL WAY | BURROWS ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 41017 | 545529600000 | -122.40509102 | 37.72857432 | - | 1494201600000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477672500000 | GIRARD ST | - | - | - | - | - | - |
| 23940 | N/A | Point | - | - | - | - | S230422 | GIRARD ST: BURROWS ST | - | F | F | - | F | 20652000 | 20652000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GIRARD ST | BURROWS ST | 66094 | 66094 | 37.72857432 | -122.40509102 | BURROWS ST \ GIRARD ST | GIRARD ST \ BURROWS ST | 1726154167000 | middleware_editor | ALL WAY | BURROWS ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 41018 | 545529600000 | -122.40509102 | 37.72857432 | - | 1494201600000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477672740000 | GIRARD ST | - | - | - | - | - | - |
| 23941 | N/A | Point | - | 1 | 800 - 899 | - | S228865 | 800-899 25TH ST | 800-899 25TH ST | F | F | - | F | 1404000 | 1404000 | - | - | NORTH SIDE | - | - | - | - | ILLINOIS ST | ILLINOIS ST | 66095 | 66095 | 37.752863 | -122.38728396 | - | - | 1710539427000 | MTA | DO NOT BLOCK TRACKS | ILLINOIS ST to 03RD ST (800 - 899) | - | 30' EAST OF 3RD ST | - | - | - | - | - | 41019 | 1477654620000 | -122.38728396 | 37.752863 | - | 1477612800000 | - | D10 | - | OTHER REGULATORY | REG | R10-7.0003 | 30X42 | SUP1 | 2IN IRON POST | IS | 1473754080000 | 25TH ST | 800 - 899 25TH ST | 800 - 899 25TH ST | 800 25TH ST | - | 03RD ST | 03RD ST |
| 23942 | N/A | Point | - | 1 | 800 - 899 | - | S228866 | 800-899 25TH ST | 800-899 25TH ST | T | T | - | F | 1404000 | 1404000 | - | - | NORTH SIDE | - | - | - | - | ILLINOIS ST | ILLINOIS ST | 66096 | 66096 | 37.752863 | -122.38728396 | - | - | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | ILLINOIS ST to 03RD ST (800 - 899) | - | 5' EAST OF 3RD ST | - | - | - | - | - | 41020 | 1477654740000 | -122.38728396 | 37.752863 | - | 1477612800000 | - | D10 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | 1473754260000 | 25TH ST | 800 - 899 25TH ST | 800 - 899 25TH ST | 800 25TH ST | - | 03RD ST | 03RD ST |
| 23943 | N/A | Point | - | - | - | - | S228867 | 25TH ST: 3RD ST | - | T | T | - | F | 23541000 | 23541000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 25TH ST | 03RD ST | 66097 | 66097 | 37.75283561 | -122.38775628 | 3RD ST \ 25TH ST | 25TH ST \ 03RD ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | 03RD ST intersection | - | - | - | - | - | - | - | 41021 | 1477655340000 | -122.38775628 | 37.75283561 | - | 1477612800000 | - | D10 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | 1473754380000 | 25TH ST | - | - | - | - | - | - |
| 23944 | N/A | Point | - | - | - | - | S229335 | 14TH ST: FOLSOM ST | - | T | T | - | F | 24336000 | 24336000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 14TH ST | FOLSOM ST | 66098 | 66098 | 37.76853739 | -122.41561378 | FOLSOM ST \ 14TH ST | 14TH ST \ FOLSOM ST | 1724202609000 | middleware_editor | FOLSOM ST | FOLSOM ST intersection | - | - | - | - | - | - | - | 41022 | 874713600000 | -122.41561378 | 37.76853739 | - | - | - | D9 | - | STREET NAME | GUIDE | D3-1.0676 | 36X08 | SUP2 | LIGHT POLE | IS | 1475067360000 | 14TH ST | - | - | - | - | - | - |
| 23945 | N/A | Point | - | - | - | - | S229336 | FOLSOM ST: 14TH ST | - | T | T | - | F | 24336000 | 24336000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 14TH ST | FOLSOM ST | 66099 | 66099 | 37.76853739 | -122.41561378 | FOLSOM ST \ 14TH ST | 14TH ST \ FOLSOM ST | 1724202636000 | middleware_editor | 14TH ST | FOLSOM ST intersection | - | - | - | - | - | - | - | 41023 | - | -122.41561378 | 37.76853739 | - | - | - | D9 | - | STREET NAME | GUIDE | D3-1.0004 | 36X08 | SUP2 | LIGHT POLE | IS | 1475068380000 | 14TH ST | - | - | - | - | - | - |
| 23946 | N/A | Point | - | - | - | - | S229337 | FOLSOM ST: 14TH ST | - | T | T | - | F | 24336000 | 24336000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 14TH ST | FOLSOM ST | 66100 | 66100 | 37.76853739 | -122.41561378 | FOLSOM ST \ 14TH ST | 14TH ST \ FOLSOM ST | 1753741012000 | middleware_editor | (LA) TURNING VEHICLES YIELD(SYM) TO PED(SYM) | FOLSOM ST intersection | - | - | - | - | - | - | - | 41024 | - | -122.41561378 | 37.76853739 | - | 1753736040000 | - | D9 | - | OTHER REGULATORY | REG | R10-15.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1475068440000 | 14TH ST | - | - | - | - | - | - |
| 23947 | N/A | Point | - | - | - | - | S229338 | FOLSOM ST: 14TH ST | - | T | T | - | F | 24336000 | 24336000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 14TH ST | FOLSOM ST | 66101 | 66101 | 37.76853739 | -122.41561378 | FOLSOM ST \ 14TH ST | 14TH ST \ FOLSOM ST | 1752704412000 | middleware_editor | NO LEFT TURN (SYM) | FOLSOM ST intersection | - | - | - | - | - | - | - | 41025 | - | -122.41561378 | 37.76853739 | - | - | - | D9 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1475068620000 | 14TH ST | - | - | - | - | - | - |
| 23948 | N/A | Point | 1 | 1 | 500 - 599 | - | S229346 | 500-599 STEVENSON ST | 500-599 STEVENSON ST | F | F | - | F | 12171000 | 12171000 | - | - | SOUTH SIDE | - | - | - | - | 6TH ST | 06TH ST | 66102 | 66102 | 37.78088745 | -122.41082115 | - | - | 1738257289000 | middleware_editor | TANSAT | 06TH ST to 07TH ST \ ODD FELLOWS WAY (500 - 599) | - | 130FT EAST OF 7TH ST | - | - | - | - | - | 41026 | 1475152440000 | -122.41082115 | 37.78088745 | - | 1475107200000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1475071200000 | STEVENSON ST | 500 - 599 STEVENSON ST | 500 - 599 STEVENSON ST | 500 STEVENSON ST | - | 07TH ST \ ODD FELLOWS WAY | 07TH ST \ ODD FELLOWS WAY |
| 23949 | N/A | Point | 1 | 1 | 500 - 599 | RIGHT ARROW | S229347 | 500-599 STEVENSON ST | 500-599 STEVENSON ST | F | F | - | F | 12171000 | 12171000 | - | - | SOUTH SIDE | - | - | - | - | 6TH ST | 06TH ST | 66103 | 66103 | 37.78088745 | -122.41082115 | - | - | 1710539427000 | MTA | TANSAT | 06TH ST to 07TH ST \ ODD FELLOWS WAY (500 - 599) | - | 300FT EAST OF 7TH ST | - | - | - | - | - | 41027 | 1475152740000 | -122.41082115 | 37.78088745 | - | 1475107200000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1475071380000 | STEVENSON ST | 500 - 599 STEVENSON ST | 500 - 599 STEVENSON ST | 500 STEVENSON ST | - | 07TH ST \ ODD FELLOWS WAY | 07TH ST \ ODD FELLOWS WAY |
| 23950 | N/A | Point | - | - | - | - | S229857 | WALLER ST: ASHBURY ST | - | F | F | - | F | 26337000 | 26337000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | WALLER ST | WALLER ST | 66104 | 66104 | 37.76907436 | -122.44674489 | ASHBURY ST \ WALLER ST | ASHBURY ST \ WALLER ST | 1727398797000 | middleware_editor | ALL WAY | WALLER ST intersection | - | 0 / 0 | - | - | - | - | - | 41028 | 246240000000 | -122.44674489 | 37.76907436 | - | 1477353600000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1476693180000 | ASHBURY ST | - | - | - | - | - | - |
| 23951 | N/A | Point | - | - | - | - | S229859 | ASHBURY ST: WALLER ST | - | F | F | - | F | 26337000 | 26337000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WALLER ST | WALLER ST | 66105 | 66105 | 37.76907436 | -122.44674489 | ASHBURY ST \ WALLER ST | ASHBURY ST \ WALLER ST | 1727398794000 | middleware_editor | ALL WAY | WALLER ST intersection | - | 0 / 0 | - | - | - | - | - | 41029 | -182908800000 | -122.44674489 | 37.76907436 | - | 1477353600000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | MUNI POLE | IS | 1476693540000 | ASHBURY ST | - | - | - | - | - | - |
| 23952 | N/A | Point | - | - | - | - | S229860 | ASHBURY ST: WALLER ST | - | F | F | - | F | 26337000 | 26337000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WALLER ST | WALLER ST | 66106 | 66106 | 37.76907436 | -122.44674489 | ASHBURY ST \ WALLER ST | ASHBURY ST \ WALLER ST | 1727398825000 | middleware_editor | ALL WAY | WALLER ST intersection | - | 0 / 0 | - | - | - | - | - | 41030 | -182908800000 | -122.44674489 | 37.76907436 | - | 1477353600000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1476693840000 | ASHBURY ST | - | - | - | - | - | - |
| 23953 | N/A | Point | - | - | - | - | S229506 | 3RD ST: 22ND ST | - | F | F | - | F | 23555000 | 23555000 | - | - | CENTER ISLAND | - | - | - | - | 22ND ST | 03RD ST | 66108 | 66108 | 37.75793971 | -122.38831553 | 3RD ST \ 22ND ST | 22ND ST \ 03RD ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (Y) | 03RD ST intersection | - | SEE NOTES | - | - | - | - | - | 41031 | - | -122.38831553 | 37.75793971 | - | - | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0008 | 03X36 | SUP1 | METRO BASE | IS | 1475657040000 | 22ND ST | - | - | - | - | - | - |
| 23954 | N/A | Point | - | - | - | - | S229507 | 3RD ST: 22ND ST | - | F | F | - | F | 23555000 | 23555000 | - | - | CENTER ISLAND | - | - | - | - | 22ND ST | 03RD ST | 66109 | 66109 | 37.75793971 | -122.38831553 | 3RD ST \ 22ND ST | 22ND ST \ 03RD ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (Y) | 03RD ST intersection | - | SEE NOTES | - | - | - | - | - | 41032 | - | -122.38831553 | 37.75793971 | - | - | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0008 | 03X36 | SUP1 | METRO BASE | IS | 1475657400000 | 22ND ST | - | - | - | - | - | - |
| 23955 | N/A | Point | - | - | - | - | S229511 | 3RD ST: 19TH ST | - | F | F | - | F | 23567000 | 23567000 | - | - | CENTER ISLAND | - | - | - | - | 19TH ST | 03RD ST | 66111 | 66111 | 37.76176645 | -122.38868402 | 3RD ST \ 19TH ST | 19TH ST \ 03RD ST | 1753473219000 | middleware_editor | FG 300 UR DELINEATOR (Y) | 03RD ST intersection | - | SEE NOTES | - | - | - | - | - | 41033 | - | -122.38868402 | 37.76176645 | - | - | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0008 | 03X36 | SUP1 | METRO BASE | IS | 1475658600000 | 19TH ST | - | - | - | - | - | - |
| 23956 | N/A | Point | 1 | 1 | 2500 - 2549 | - | S226982 | 2500-2549 YORBA ST | 2500-2549 YORBA ST | F | F | - | F | 13759000 | 13759000 | - | - | NORTH SIDE | - | - | - | - | 36TH AVE | 36TH AVE | 66206 | 66206 | 37.73494199 | -122.49363202 | - | - | 1710539427000 | MTA | ONCOMING TRAFFIC DOES NOT STOP | 36TH AVE to SUNSET BLVD (2500 - 2549) | - | 3`EAST | - | - | - | - | - | 41034 | 1467803400000 | -122.49363202 | 37.73494199 | - | 1467763200000 | - | D4 | - | OTHER WARNING | WARNING | W4-4BP.0001 | 30X18 | SUP2 | 2IN IRON POST | IS | 1467125220000 | YORBA ST | 2500 - 2549 YORBA ST | 2500 - 2549 YORBA ST | 2500 YORBA ST | - | SUNSET BLVD | SUNSET BLVD |
| 23957 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S231056 | 1700-1799 PIERCE ST | 1700-1799 PIERCE ST | F | F | - | F | 10431000 | 10431000 | - | - | EAST SIDE | - | - | - | - | SUTTER ST | SUTTER ST | 66207 | 66207 | 37.78613441 | -122.43665193 | - | - | 1710539427000 | MTA | BIKE RACK | SUTTER ST to BUSH ST (1700 - 1799) | 20165203 | IFO #1700 (27' NORTH OF SUTTER) | - | - | - | - | - | 41035 | - | -122.43665193 | 37.78613441 | - | - | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1479296880000 | PIERCE ST | 1700 - 1799 PIERCE ST | 1700 - 1799 PIERCE ST | 1700 PIERCE ST | - | BUSH ST | BUSH ST |
| 23958 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S231065 | 1800-1899 CHESTNUT ST | 1800-1899 CHESTNUT ST | F | F | - | F | 3975000 | 3975000 | - | - | NORTH SIDE | - | - | - | - | BUCHANAN ST | BUCHANAN ST | 66209 | 66209 | 37.80113117 | -122.43377999 | - | - | 1743441974000 | middleware_editor | BIKE RACK | BUCHANAN ST to WEBSTER ST (1800 - 1899) | 20165201 | IFO #1890 (57.6' EAST OF WPL) | - | - | - | - | - | 41036 | 1479500700000 | -122.43377999 | 37.80113117 | - | 1479456000000 | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1479301020000 | CHESTNUT ST | 1800 - 1899 CHESTNUT ST | 1800 - 1899 CHESTNUT ST | 1800 CHESTNUT ST | - | WEBSTER ST | WEBSTER ST |
| 23959 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S231066 | 1800-1899 CHESTNUT ST | 1800-1899 CHESTNUT ST | F | F | - | F | 3975000 | 3975000 | - | - | NORTH SIDE | - | - | - | - | BUCHANAN ST | BUCHANAN ST | 66210 | 66210 | 37.80113117 | -122.43377999 | - | - | 1743441991000 | middleware_editor | BIKE RACK | BUCHANAN ST to WEBSTER ST (1800 - 1899) | 20165201 | IFO #1890 (64' EAST OF WPL) | - | - | - | - | - | 41037 | - | -122.43377999 | 37.80113117 | - | - | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1479301140000 | CHESTNUT ST | 1800 - 1899 CHESTNUT ST | 1800 - 1899 CHESTNUT ST | 1800 CHESTNUT ST | - | WEBSTER ST | WEBSTER ST |
| 23960 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S231067 | 1800-1899 CHESTNUT ST | 1800-1899 CHESTNUT ST | F | F | - | F | 3975000 | 3975000 | - | - | NORTH SIDE | - | - | - | - | BUCHANAN ST | BUCHANAN ST | 66211 | 66211 | 37.80113117 | -122.43377999 | - | - | 1743441997000 | middleware_editor | BIKE RACK | BUCHANAN ST to WEBSTER ST (1800 - 1899) | 20165201 | IFO #1890 (84' EAST OF WPL) | - | - | - | - | - | 41038 | 1479500340000 | -122.43377999 | 37.80113117 | - | 1479456000000 | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1479301140000 | CHESTNUT ST | 1800 - 1899 CHESTNUT ST | 1800 - 1899 CHESTNUT ST | 1800 CHESTNUT ST | - | WEBSTER ST | WEBSTER ST |
| 23961 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S231068 | 1800-1899 CHESTNUT ST | 1800-1899 CHESTNUT ST | F | F | - | F | 3975000 | 3975000 | - | - | NORTH SIDE | - | - | - | - | BUCHANAN ST | BUCHANAN ST | 66212 | 66212 | 37.80113117 | -122.43377999 | - | - | 1743441985000 | middleware_editor | BIKE RACK | BUCHANAN ST to WEBSTER ST (1800 - 1899) | 20165201 | IFO #1890 (92' EAST OF WPL) | - | - | - | - | - | 41039 | 1479500160000 | -122.43377999 | 37.80113117 | - | 1479456000000 | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1479301200000 | CHESTNUT ST | 1800 - 1899 CHESTNUT ST | 1800 - 1899 CHESTNUT ST | 1800 CHESTNUT ST | - | WEBSTER ST | WEBSTER ST |
| 23962 | N/A | Point | - | - | - | - | S231217 | CALIFORNIA ST: 7TH AVE \ CORNW | - | T | F | - | F | 3583000 | 27593000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | 07TH AVE \ CORNWALL ST | 07TH AVE \ CALIFORNIA ST | 66213 | 66213 | 37.78485253 | -122.46563231 | - | CORNWALL ST \ 07TH AVE \ CALIFORNIA ST | 1727995062000 | middleware_editor | STATE LAW YIELD TO PEDS (SYM) | 07TH AVE \ CALIFORNIA ST intersection | - | - | - | - | - | - | - | 41040 | 1489069440000 | -122.46563231 | 37.78485253 | - | 1727959500000 | - | D1 | - | OTHER REGULATORY | REG | R1-6.0001 | 12X36 | SUP2 | MUNI POLE | IS | 1479734340000 | CORNWALL ST | 4500 - 4599 CALIFORNIA ST | - | - | - | 08TH AVE | - |
| 23963 | N/A | Point | - | - | - | - | S231218 | CALIFORNIA ST: 7TH AVE \ CORNW | - | T | T | - | F | 4409000 | 27593000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 06TH AVE | 07TH AVE \ CALIFORNIA ST | 66214 | 66214 | 37.78485253 | -122.46563231 | - | CORNWALL ST \ 07TH AVE \ CALIFORNIA ST | 1725584734000 | middleware_editor | YIELD HERE TO PED (SYM) (LA) | 07TH AVE \ CALIFORNIA ST intersection | - | 20`EAST | - | - | - | - | - | 41041 | 1489069620000 | -122.46563231 | 37.78485253 | - | 1489017600000 | - | D1 | - | PEDESTRIAN | REG | R1-5.0001 | 18X24 | SUP2 | MUNI POLE | IS | 1479734580000 | CORNWALL ST | 4400 - 4499 CORNWALL ST | - | - | - | 07TH AVE \ CALIFORNIA ST | - |
| 23964 | N/A | Point | - | - | - | - | S231237 | JUDSON AVE: GENNESSEE ST | - | F | F | - | F | 22235000 | 22235000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GENNESSEE ST | GENNESSEE ST | 66215 | 66215 | 37.72835755 | -122.45111256 | JUDSON AVE \ GENNESSEE ST | JUDSON AVE \ GENNESSEE ST | 1719598555000 | middleware_editor | ALL WAY | GENNESSEE ST intersection | - | 0 / 00 | - | - | - | - | - | 41042 | 300412800000 | -122.45111256 | 37.72835755 | - | 1486512000000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479815580000 | JUDSON AVE | - | - | - | - | - | - |
| 23965 | N/A | Point | - | - | - | - | S231239 | JUDSON AVE: GENNESSEE ST | - | F | F | - | F | 22235000 | 22235000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GENNESSEE ST | GENNESSEE ST | 66216 | 66216 | 37.72835755 | -122.45111256 | JUDSON AVE \ GENNESSEE ST | JUDSON AVE \ GENNESSEE ST | 1719928023000 | middleware_editor | ALL WAY | GENNESSEE ST intersection | - | - | - | - | - | - | - | 41043 | 300412800000 | -122.45111256 | 37.72835755 | - | - | 1719836100000 | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | RETD | 1479815880000 | JUDSON AVE | - | - | - | - | - | - |
| 23966 | N/A | Point | - | - | - | - | S231244 | GENNESSEE ST: JUDSON AVE | - | F | F | - | F | 22235000 | 22235000 | - | SHOULD BE RETIRED | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GENNESSEE ST | GENNESSEE ST | 66217 | 66217 | 37.72835755 | -122.45111256 | JUDSON AVE \ GENNESSEE ST | JUDSON AVE \ GENNESSEE ST | 1746135228000 | middleware_editor | ALL WAY | GENNESSEE ST intersection | - | 0 / 0 | - | - | - | - | - | 41044 | 300438000000 | -122.45111256 | 37.72835755 | - | 1486540800000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | RETD | 1479816720000 | JUDSON AVE | - | - | - | - | - | - |
| 23967 | N/A | Point | 1 | 1 | 200 - 299 | - | S231245 | 200-299 SPEAR ST | 200-299 SPEAR ST | F | F | - | F | 12046000 | 12046000 | - | - | EAST SIDE | - | - | - | - | HOWARD ST | HOWARD ST | 66218 | 66218 | 37.79069039 | -122.39174782 | - | - | 1710539427000 | MTA | CARPOOLS TO ORINDA/LAFAYETTE | HOWARD ST to FOLSOM ST (200 - 299) | - | 120' SOUTH OF HOWARD | - | - | - | - | - | 41045 | 1480688940000 | -122.39174782 | 37.79069039 | - | 1480636800000 | - | D6 | - | OTHER REGULATORY | REG | SR(SF).0023 | 42X30 | SUP1 | 2IN FLANGE POST | IS | 1479816900000 | SPEAR ST | 200 - 299 SPEAR ST | 200 - 299 SPEAR ST | 200 SPEAR ST | - | FOLSOM ST | FOLSOM ST |
| 23968 | N/A | Point | - | - | - | - | S231246 | INNES AVE: DONAHUE ST | - | F | F | - | F | 35028000 | 35028000 | - | - | SOUTH WEST CORNER | - | - | - | - | INNES AVE | DONAHUE ST | 66219 | 66219 | 37.72880615 | -122.37014538 | DONAHUE ST \ INNES AVE | INNES AVE \ DONAHUE ST | 1710539427000 | MTA | NPRK 8AM-10AM TUE STCL | DONAHUE ST intersection | - | ABOVE STOP SIGN | - | - | - | - | - | 41046 | -399772800000 | -122.37014538 | 37.72880615 | - | 1480464000000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0270 | 18X18 | SUP1 | LIGHT POLE | IS | 1479816960000 | INNES AVE | - | - | - | - | - | - |
| 23969 | N/A | Point | - | - | - | - | S233088 | RAMSELL ST: SHIELDS ST | - | F | F | - | F | 22698000 | 22698000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SHIELDS ST | SHIELDS ST | 66220 | 66220 | 37.71791217 | -122.46623527 | RAMSELL ST \ SHIELDS ST | RAMSELL ST \ SHIELDS ST | 1754433675000 | middleware_editor | ALL WAY | SHIELDS ST intersection | - | - | - | - | - | - | - | 41047 | 1487890200000 | -122.46623527 | 37.71791217 | - | 1754430300000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1485775440000 | RAMSELL ST | - | - | - | - | - | - |
| 23970 | N/A | Point | 1 | 1 | 1600 - 1660 | - | S233511 | 1600-1660 HAIGHT ST | 1600-1660 HAIGHT ST | F | F | - | F | 6620000 | 6620000 | - | - | NORTH SIDE | - | - | - | - | CLAYTON ST | CLAYTON ST | 66221 | 66221 | 37.76972986 | -122.44911199 | - | - | 1710539427000 | MTA | BIKE RACK | CLAYTON ST to BELVEDERE ST (1600 - 1660) | - | IFO #1626 | - | - | - | - | - | 41048 | 1325030400000 | -122.44911199 | 37.76972986 | - | 1488758400000 | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1486718100000 | HAIGHT ST | 1600 - 1660 HAIGHT ST | 1600 - 1660 HAIGHT ST | 1600 HAIGHT ST | - | BELVEDERE ST | BELVEDERE ST |
| 23971 | N/A | Point | 1 | 1 | 1 - 6 | - | S201442 | 1-6 DRUMM ST | 1-6 DRUMM ST | F | F | - | F | 4969000 | 4969000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | MARKET ST | MARKET ST | 76870 | 76870 | 37.79346006 | -122.39634621 | - | - | 1710539427000 | MTA | ONE WAY (RA) | MARKET ST to CALIFORNIA ST (1 - 6) | - | - | - | - | - | - | - | 41049 | 1405784040000 | -122.39634621 | 37.79346006 | - | 1405728000000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | MUNI POLE | IS | 1388141700000 | DRUMM ST | 1 - 6 DRUMM ST | 1 - 6 DRUMM ST | 1 DRUMM ST | - | CALIFORNIA ST | CALIFORNIA ST |
| 23972 | N/A | Point | 1 | 1 | 800 - 899 | - | S201336 | 800-899 PIERCE ST | 800-899 PIERCE ST | F | F | - | F | 10423000 | 10423000 | - | - | EAST SIDE | - | - | - | - | FULTON ST | FULTON ST | 76871 | 76871 | 37.77774672 | -122.43495808 | - | - | 1746739318000 | middleware_editor | NPRK 9AM-11AM WED STCL | FULTON ST to MCALLISTER ST (800 - 899) | - | 40'SOUTH OF MCALLISTER | - | - | - | - | - | 41050 | 1389220260000 | -122.43495808 | 37.77774672 | - | 1746737400000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0312 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1387548060000 | PIERCE ST | 800 - 899 PIERCE ST | 800 - 899 PIERCE ST | 800 PIERCE ST | - | MCALLISTER ST | MCALLISTER ST |
| 23973 | N/A | Point | 1 | 1 | 1400 - 1599 | - | S201511 | 1400-1599 POST ST | 1400-1599 POST ST | F | F | - | F | 10643000 | 10643000 | - | - | NORTH SIDE | - | - | - | - | GOUGH ST | GOUGH ST | 76872 | 76872 | 37.78599046 | -122.42650331 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM THUR STCL | GOUGH ST to LAGUNA ST (1400 - 1599) | - | 5' WEST OF # 1510 DRIVEWAY | - | - | - | - | - | 41051 | 1390979040000 | -122.42650331 | 37.78599046 | - | 1390953600000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0193 | 18X18 | SUP1 | MUNI POLE | IS | 1388407740000 | POST ST | 1400 - 1599 POST ST | 1400 - 1599 POST ST | 1400 POST ST | - | LAGUNA ST | LAGUNA ST |
| 23974 | N/A | Point | 1 | 1 | 1 - 99 | - | S200265 | 1-99 LANGTON ST | 1-99 LANGTON ST | F | F | - | F | 8098000 | 8098000 | - | - | WEST SIDE | - | - | - | - | HOWARD ST | HOWARD ST | 76874 | 76874 | 37.7769345 | -122.40915312 | - | - | 1724461136000 | middleware_editor | BUS STOP NO STOPPING 1:30PM-2:30PM SCHL DAYS | HOWARD ST to FOLSOM ST (1 - 99) | - | - | - | - | - | - | - | 41052 | 1395413700000 | -122.40915312 | 37.7769345 | - | 1395360000000 | - | D6 | - | OTHER REGULATORY | REG | R30F(SF).0001 | 18X30 | SUP1 | 2 POST ALUMINUM | IS | 1383909780000 | LANGTON ST | 1 - 99 LANGTON ST | 1 - 99 LANGTON ST | 1 LANGTON ST | - | FOLSOM ST | FOLSOM ST |
| 23975 | N/A | Point | - | - | - | - | S247389 | THE EMBARCADERO: BATTERY ST \ | - | F | F | - | F | 24819000 | 24819000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | BATTERY ST \ THE EMBARCADERO | BATTERY ST \ THE EMBARCADERO | 76876 | 76876 | 37.80407225 | -122.40197343 | LOMBARD ST \ BATTERY ST \ THE EMBARCADERO | LOMBARD ST \ BATTERY ST \ THE EMBARCADERO | 1710539427000 | MTA | DO NOT ENTER | BATTERY ST \ THE EMBARCADERO intersection | - | CRSS ST. IS LOMBARD/ WEST LINE LP | - | - | - | - | - | 41053 | 823651200000 | -122.40197343 | 37.80407225 | - | 1532736000000 | - | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1532950980000 | LOMBARD ST | - | - | - | - | - | - |
| 23976 | N/A | Point | - | - | - | - | S247390 | THE EMBARCADERO: BATTERY ST \ | - | F | F | - | F | 24819000 | 24819000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | BATTERY ST \ THE EMBARCADERO | BATTERY ST \ THE EMBARCADERO | 76877 | 76877 | 37.80407225 | -122.40197343 | LOMBARD ST \ BATTERY ST \ THE EMBARCADERO | LOMBARD ST \ BATTERY ST \ THE EMBARCADERO | 1710539427000 | MTA | EXC MUNI | BATTERY ST \ THE EMBARCADERO intersection | - | CRSS ST. IS LOMBARD/ WEST LINE LP | - | - | - | - | - | 41054 | 823651200000 | -122.40197343 | 37.80407225 | - | - | - | D3 | - | OTHER REGULATORY | REG | R(SF).0070 | 24X12 | SUP1 | LIGHT POLE | IS | 1532951040000 | LOMBARD ST | - | - | - | - | - | - |
| 23977 | N/A | Point | 1 | 1 | 1 - 49 | LEFT ARROW | S247614 | 1-49 MINNA ST | 1-49 MINNA ST | F | F | - | F | 9038000 | 9038000 | - | - | SOUTH SIDE | - | - | - | - | 1ST ST | 01ST ST | 76878 | 76878 | 37.78894448 | -122.39752768 | - | - | 1710539427000 | MTA | TANSAT | 01ST ST to SHAW ALY (1 - 49) | - | 35' FTWEST | - | - | - | - | - | 41055 | 1323734400000 | -122.39752768 | 37.78894448 | - | 1534896000000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN FLANGE POST | IS | 1533637140000 | MINNA ST | 1 - 49 MINNA ST | 1 - 49 MINNA ST | 1 MINNA ST | - | SHAW ALY | SHAW ALY |
| 23978 | N/A | Point | 1 | 1 | 1 - 49 | RIGHT ARROW | S247615 | 1-49 MINNA ST | 1-49 MINNA ST | F | F | - | F | 9038000 | 9038000 | - | - | SOUTH SIDE | - | - | - | - | 1ST ST | 01ST ST | 76879 | 76879 | 37.78894448 | -122.39752768 | - | - | 1710539427000 | MTA | TANSAT | 01ST ST to SHAW ALY (1 - 49) | - | 91' FTWEST | - | - | - | - | - | 41056 | 1323734400000 | -122.39752768 | 37.78894448 | - | 1534896000000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN FLANGE POST | IS | 1533637320000 | MINNA ST | 1 - 49 MINNA ST | 1 - 49 MINNA ST | 1 MINNA ST | - | SHAW ALY | SHAW ALY |
| 23979 | N/A | Point | 1 | 1 | 1 - 49 | LEFT ARROW | S247616 | 1-49 MINNA ST | 1-49 MINNA ST | F | F | - | F | 9038000 | 9038000 | - | - | SOUTH SIDE | - | - | - | - | 1ST ST | 01ST ST | 76880 | 76880 | 37.78894448 | -122.39752768 | - | - | 1710539427000 | MTA | TANSAT | 01ST ST to SHAW ALY (1 - 49) | - | 219' FT WEST | - | - | - | - | - | 41057 | 1323734400000 | -122.39752768 | 37.78894448 | - | 1534896000000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN FLANGE POST | IS | 1533637320000 | MINNA ST | 1 - 49 MINNA ST | 1 - 49 MINNA ST | 1 MINNA ST | - | SHAW ALY | SHAW ALY |
| 23980 | N/A | Point | 1 | 1 | 1 - 49 | LEFT ARROW | S247617 | 1-49 MINNA ST | 1-49 MINNA ST | F | F | - | F | 9038000 | 9038000 | - | - | SOUTH SIDE | - | - | - | - | 1ST ST | 01ST ST | 76881 | 76881 | 37.78894448 | -122.39752768 | - | - | 1710539427000 | MTA | TANSAT | 01ST ST to SHAW ALY (1 - 49) | - | 424 FT WEST | - | - | - | - | - | 41058 | 1323734400000 | -122.39752768 | 37.78894448 | - | 1534896000000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN FLANGE POST | IS | 1533637500000 | MINNA ST | 1 - 49 MINNA ST | 1 - 49 MINNA ST | 1 MINNA ST | - | SHAW ALY | SHAW ALY |
| 23981 | N/A | Point | 1 | 1 | 1 - 49 | RIGHT ARROW | S247618 | 1-49 MINNA ST | 1-49 MINNA ST | F | F | - | F | 9038000 | 9038000 | - | - | SOUTH SIDE | - | - | - | - | 1ST ST | 01ST ST | 76882 | 76882 | 37.78894448 | -122.39752768 | - | - | 1710539427000 | MTA | TANSAT | 01ST ST to SHAW ALY (1 - 49) | - | 294 FT WEST | - | - | - | - | - | 41059 | 1323734400000 | -122.39752768 | 37.78894448 | - | 1534896000000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN FLANGE POST | IS | 1533637560000 | MINNA ST | 1 - 49 MINNA ST | 1 - 49 MINNA ST | 1 MINNA ST | - | SHAW ALY | SHAW ALY |
| 23982 | N/A | Point | 1 | 1 | 1 - 49 | LEFT ARROW | S247619 | 1-49 MINNA ST | 1-49 MINNA ST | F | F | - | F | 9038000 | 9038000 | - | - | SOUTH SIDE | - | - | - | - | 1ST ST | 01ST ST | 76883 | 76883 | 37.78894448 | -122.39752768 | - | - | 1710539427000 | MTA | TANSAT | 01ST ST to SHAW ALY (1 - 49) | - | 711'' FTWEST | - | - | - | - | - | 41060 | 1323734400000 | -122.39752768 | 37.78894448 | - | 1534896000000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN FLANGE POST | IS | 1533637680000 | MINNA ST | 1 - 49 MINNA ST | 1 - 49 MINNA ST | 1 MINNA ST | - | SHAW ALY | SHAW ALY |
| 23983 | N/A | Point | 1 | 1 | 1 - 49 | - | S247621 | 1-49 MINNA ST | 1-49 MINNA ST | F | F | - | F | 9038000 | 9038000 | - | - | SOUTH SIDE | - | - | - | - | 1ST ST | 01ST ST | 76885 | 76885 | 37.78894448 | -122.39752768 | - | - | 1710539427000 | MTA | TA (SYM) NO PARKING DISABLED PASS LOADING AT ALL TIMES 5 MIN | 01ST ST to SHAW ALY (1 - 49) | - | 47 FT WEST | - | - | - | - | - | 41061 | 1323734400000 | -122.39752768 | 37.78894448 | - | 1534896000000 | - | D6 | - | PARKING | REG | R37(SF).0361 | 14X21 | SUP1 | 2IN FLANGE POST | IS | 1533637980000 | MINNA ST | 1 - 49 MINNA ST | 1 - 49 MINNA ST | 1 MINNA ST | - | SHAW ALY | SHAW ALY |
| 23984 | N/A | Point | - | - | - | - | S226458 | CAYUGA AVE: ROUSSEAU ST | - | F | F | - | F | 21706000 | 21706000 | - | - | SOUTH SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | CAYUGA AVE | CAYUGA AVE | 66372 | 66372 | 37.73145973 | -122.42976635 | ROUSSEAU ST \ CAYUGA AVE | ROUSSEAU ST \ CAYUGA AVE | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | CAYUGA AVE intersection | - | OPP#84 | - | - | - | - | - | 41062 | 1329782400000 | -122.42976635 | 37.73145973 | - | 1465948800000 | - | D8 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | 2IN IRON POST | IS | 1465550400000 | ROUSSEAU ST | - | - | - | - | - | - |
| 23985 | N/A | Point | 1 | 1 | 300 - 399 | LEFT ARROW | S227003 | 300-399 CHURCH ST | 300-399 CHURCH ST | F | F | - | F | 4011000 | 4011000 | - | - | WEST SIDE | - | - | - | - | 15TH ST | 15TH ST | 66374 | 66374 | 37.76531882 | -122.42874214 | - | - | 1746652612000 | middleware_editor | TANSAT | 15TH ST to 16TH ST (300 - 399) | - | 70' N OF 16TH ST @ MARKING | - | - | - | - | - | 41063 | 1468608900000 | -122.42874214 | 37.76531882 | - | 1468566000000 | - | D8 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | 2 POST ALUMINUM | IS | 1467206700000 | CHURCH ST | 300 - 399 CHURCH ST | 300 - 399 CHURCH ST | 300 CHURCH ST | - | 16TH ST | 16TH ST |
| 23986 | N/A | Point | 1 | 1 | 368 - 427 | - | S228136 | 368-427 4TH ST | 368-427 04TH ST | F | F | - | F | 258000 | 258000 | - | - | EAST SIDE | - | - | - | - | CLARA ST | CLARA ST | 66376 | 66376 | 37.7810045 | -122.39988293 | - | - | 1710539427000 | MTA | BIKE RACK (YERBA BUENA) | CLARA ST to HARRISON ST \ I-80 W ON RAMP (368 - 427) | - | INFO 399/ OPP. SWC | - | - | - | - | - | 41064 | - | -122.39988293 | 37.7810045 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0345 | 36X36 | SUP1 | BIKE RACK | IS | 1471423620000 | 04TH ST | 368 - 427 4TH ST | 368 - 427 04TH ST | 368 4TH ST | - | HARRISON ST \ I-80 W ON RAMP | HARRISON ST \ I-80 W ON RAMP |
| 23987 | N/A | Point | - | 1 | 90 - 198 | - | S231187 | PNDG THE EMBARCADERO | 90-198 THE EMBARCADERO | F | F | - | F | 12553201 | 12553201 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | MISSION ST | MISSION ST | 66377 | 66377 | 37.79527839 | -122.39389252 | - | - | 1723669024000 | middleware_editor | SHARED PATH BIKE/PED(SYM) FASTER CYC USE ROADWAY BIKE LANE | MISSION ST to WASHINGTON ST (90 - 198) -- EAST -- | - | SPL OF THE FERRY BUILDING | - | - | - | - | - | 41065 | 1479907980000 | -122.39389252 | 37.79527839 | - | 1479859200000 | - | D3 | - | BIKE REG | REG | R(SF).0367 | 24X30 | SUP1 | 2IN IRON POST | IS | 1479720960000 | THE EMBARCADERO | PNDG THE EMBARCADERO | 90 - 198 THE EMBARCADERO | - | - | WASHINGTON ST | WASHINGTON ST |
| 23988 | N/A | Point | - | 1 | 90 - 198 | - | S231188 | PNDG THE EMBARCADERO | 90-198 THE EMBARCADERO | F | F | - | F | 12553201 | 12553201 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | MISSION ST | MISSION ST | 66378 | 66378 | 37.79527839 | -122.39389252 | - | - | 1723669019000 | middleware_editor | SHARED PATH BIKE/PED(SYM) FASTER CYC USE ROADWAY BIKE LANE | MISSION ST to WASHINGTON ST (90 - 198) -- EAST -- | - | SPL OF THE FERRY BUILDING | - | - | - | - | - | 41066 | 1479908280000 | -122.39389252 | 37.79527839 | - | 1479859200000 | - | D3 | - | BIKE REG | REG | R(SF).0367 | 24X30 | SUP1 | 2IN IRON POST | IS | 1479721020000 | THE EMBARCADERO | PNDG THE EMBARCADERO | 90 - 198 THE EMBARCADERO | - | - | WASHINGTON ST | WASHINGTON ST |
| 23989 | N/A | Point | - | - | - | - | S231088 | CALIFORNIA ST: 11TH AVE | - | F | F | - | F | 27610000 | 27610000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 11TH AVE | CALIFORNIA ST | 66380 | 66380 | 37.78457278 | -122.46990786 | CALIFORNIA ST \ 11TH AVE | 11TH AVE \ CALIFORNIA ST | 1720832604000 | middleware_editor | PEDESTRIAN (SYM) | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 41067 | - | -122.46990786 | 37.78457278 | - | - | - | D1 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | LIGHT POLE | IS | 1479368820000 | 11TH AVE | - | - | - | - | - | - |
| 23990 | N/A | Point | 1 | 1 | 4900 - 4999 | - | S231090 | 4900-4999 CALIFORNIA ST | 4900-4999 CALIFORNIA ST | F | F | - | F | 3587000 | 3587000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 11TH AVE | 11TH AVE | 66382 | 66382 | 37.78454863 | -122.47044467 | - | - | 1739224149000 | middleware_editor | YIELD HERE TO PED (SYM) (LA) | 11TH AVE to 12TH AVE (4900 - 4999) | - | 30FT. EAST OF 11TH AVE(AT PAINT MARK) | - | - | - | - | - | 41068 | 1480590660000 | -122.47044467 | 37.78454863 | - | 1480550400000 | - | D1 | - | PEDESTRIAN | REG | R1-5.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1479369360000 | CALIFORNIA ST | 4900 - 4999 CALIFORNIA ST | 4900 - 4999 CALIFORNIA ST | 4900 CALIFORNIA ST | - | 12TH AVE | 12TH AVE |
| 23991 | N/A | Point | 1 | 1 | 4900 - 4999 | - | S231091 | 4900-4999 CALIFORNIA ST | 4900-4999 CALIFORNIA ST | F | F | - | F | 3587000 | 3587000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 11TH AVE | 11TH AVE | 66383 | 66383 | 37.78454863 | -122.47044467 | - | - | 1739224174000 | middleware_editor | PEDESTRIAN (SYM) | 11TH AVE to 12TH AVE (4900 - 4999) | - | 13FT. WEST OF 11TH AVE. | - | - | - | - | - | 41069 | - | -122.47044467 | 37.78454863 | - | - | - | D1 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1479369840000 | CALIFORNIA ST | 4900 - 4999 CALIFORNIA ST | 4900 - 4999 CALIFORNIA ST | 4900 CALIFORNIA ST | - | 12TH AVE | 12TH AVE |
| 23992 | N/A | Point | 1 | 1 | 4900 - 4999 | - | S231093 | 4900-4999 CALIFORNIA ST | 4900-4999 CALIFORNIA ST | F | F | - | F | 3587000 | 3587000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 11TH AVE | 11TH AVE | 66384 | 66384 | 37.78454863 | -122.47044467 | - | - | 1739224151000 | middleware_editor | YIELD HERE TO PED (SYM) (LA) | 11TH AVE to 12TH AVE (4900 - 4999) | - | 13FT. WEST OF 11TH AVE. | - | - | - | - | - | 41070 | 1480590840000 | -122.47044467 | 37.78454863 | - | 1480550400000 | - | D1 | - | PEDESTRIAN | REG | R1-5.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1479370140000 | CALIFORNIA ST | 4900 - 4999 CALIFORNIA ST | 4900 - 4999 CALIFORNIA ST | 4900 CALIFORNIA ST | - | 12TH AVE | 12TH AVE |
| 23993 | N/A | Point | - | - | - | - | S231297 | YUKON ST: 19TH ST | - | F | F | - | F | 26155000 | 26155000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | YUKON ST | 19TH ST | 66385 | 66385 | 37.75893944 | -122.44217528 | 19TH ST \ YUKON ST | YUKON ST \ 19TH ST | 1710824279000 | middleware_editor | ALL WAY | 19TH ST intersection | - | BELOW EXIST R17 | - | - | - | - | - | 41071 | 748137600000 | -122.44217528 | 37.75893944 | - | 1490140800000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479884040000 | YUKON ST | - | - | - | - | - | - |
| 23994 | N/A | Point | - | - | - | - | S231300 | 19TH ST: YUKON ST | - | F | F | - | F | 26155000 | 26155000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | YUKON ST | 19TH ST | 66387 | 66387 | 37.75893944 | -122.44217528 | 19TH ST \ YUKON ST | YUKON ST \ 19TH ST | 1710824338000 | middleware_editor | ALL WAY | 19TH ST intersection | - | - | - | - | - | - | - | 41072 | 748137600000 | -122.44217528 | 37.75893944 | - | 1490140800000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479886800000 | YUKON ST | - | - | - | - | - | - |
| 23995 | N/A | Point | - | - | - | - | S231301 | 19TH ST: YUKON ST | - | F | F | - | F | 26155000 | 26155000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | YUKON ST | 19TH ST | 66388 | 66388 | 37.75893944 | -122.44217528 | 19TH ST \ YUKON ST | YUKON ST \ 19TH ST | 1710824407000 | middleware_editor | ALL WAY | 19TH ST intersection | - | - | - | - | - | - | - | 41073 | 748137600000 | -122.44217528 | 37.75893944 | - | 1490140800000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479889500000 | YUKON ST | - | - | - | - | - | - |
| 23996 | N/A | Point | - | - | - | - | S231302 | YUKON ST: 19TH ST | - | F | F | - | F | 26155000 | 26155000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | YUKON ST | 19TH ST | 66389 | 66389 | 37.75893944 | -122.44217528 | 19TH ST \ YUKON ST | YUKON ST \ 19TH ST | 1710824461000 | middleware_editor | NO RIGHT TURN (SYM) | 19TH ST intersection | - | - | - | - | - | - | - | 41074 | 748137600000 | -122.44217528 | 37.75893944 | - | - | - | D8 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1479890100000 | YUKON ST | - | - | - | - | - | - |
| 23997 | N/A | Point | 1 | 1 | 300 - 398 | - | S231306 | 300-399 MISSION BAY BLVD NORTH | 300-398 MISSION BAY BLVD NORTH | F | F | - | F | 15017201 | 15017201 | - | - | NORTH SIDE | - | - | - | - | MISSION BAY BLVD \ TERRY A FRANCOIS BLVD | MISSION BAY BLVD \ TERRY A FRANCOIS BLVD | 66390 | 66390 | 37.77125142 | -122.38717746 | - | - | 1710539427000 | MTA | 2 HR PRK 7AM-10PM EVERYDAY | MISSION BAY BLVD \ TERRY A FRANCOIS BLVD to MISSION BAY BLVD \ VARA ST (300 - 398) | - | 5' WEST OF TERRY A FRANCOIS BLVD | - | - | - | - | - | 41075 | - | -122.38717746 | 37.77125142 | - | - | - | D6 | - | PARKING | REG | R32(CA).0061 | 18X18 | SUP1 | LIGHT POLE | IS | 1479890460000 | MISSION BAY BLVD NORTH | 300 - 398 MISSION BAY BLVD NORTH | 300 - 398 MISSION BAY BLVD NORTH | 300 MISSION BAY BLVD NORTH | - | MISSION BAY BLVD \ VARA ST | MISSION BAY BLVD \ VARA ST |
| 23998 | N/A | Point | - | - | - | - | S226322 | BAY SHORE BLVD: QUINT ST | - | F | F | - | F | 20642000 | 20642000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BAY SHORE BLVD | BAY SHORE BLVD | 66391 | 66391 | 37.7299019 | -122.40302162 | QUINT ST \ BAY SHORE BLVD | QUINT ST \ BAY SHORE BLVD | 1733784426000 | middleware_editor | NPRK VEH OVER 6 FT HIGH (LA) | BAY SHORE BLVD intersection | - | 4' N OF QUINT | - | - | - | - | - | 41076 | 1465555620000 | -122.40302162 | 37.7299019 | - | 1733742300000 | - | D10 | - | PARKING | REG | R28D(CA).0003 | 12X18 | SUP1 | 2IN IRON POST | IS | 1465299000000 | QUINT ST | - | - | - | - | - | - |
| 23999 | N/A | Point | - | - | - | - | S226325 | BAY SHORE BLVD: CARROLL AVE \ | - | F | F | - | F | 20646000 | 20646000 | - | - | SOUTH EAST CORNER | - | - | - | - | ELMIRA ST | ELMIRA ST | 66392 | 66392 | 37.7308005 | -122.40286611 | \BAY SHORE BLVD: CARROLL AVE \ | THORNTON AVE \ ELMIRA ST | 1710539427000 | MTA | NPRK VEH OVER 6 FT HIGH (RA) | ELMIRA ST intersection | - | OF BAYSHORE BLVD. & CARROLL AVE. | - | - | - | - | - | 41077 | 1465555860000 | -122.40286611 | 37.7308005 | - | 1465516800000 | - | D10 | - | PARKING | REG | R28D(CA).0004 | 12X18 | SUP1 | 2IN IRON POST | IS | 1465299360000 | THORNTON AVE | - | - | - | - | - | - |
| 24000 | N/A | Point | - | - | - | - | S234722 | FRANKLIN ST: ELLIS ST | - | T | T | - | F | 26489000 | 26489000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 67091 | 67091 | 37.7836191 | -122.42265254 | ELLIS ST \ FRANKLIN ST | ELLIS ST \ FRANKLIN ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | FRANKLIN ST intersection | - | - | - | - | - | - | - | 41078 | 980899200000 | -122.42265254 | 37.7836191 | - | 1504137600000 | - | D5 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1490788740000 | ELLIS 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