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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86851 | N/A | Point | - | - | - | - | S124548 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | 15TH ST | - | 145307 | 145307 | 37.765862 | -122.419747 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104036 | - | -122.419747 | 37.765862 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | 16TH ST | - |
| 86852 | N/A | Point | - | - | - | - | S124575 | - | - | NO | NO | - | - | - | - | - | - | WEST SIDE | 1691445421000 | MTA | - | - | 16TH ST | - | 145315 | 145315 | 37.76424 | -122.419591 | - | - | 1721697754000 | middleware_editor | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104037 | 1153699200000 | -122.419591 | 37.76424 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | IS | - | - | - | - | - | - | 17TH ST | - |
| 86853 | N/A | Point | - | - | - | - | S124577 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | 18TH ST | - | 145316 | 145316 | 37.761036 | -122.419283 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104038 | - | -122.419283 | 37.761036 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | 19TH ST | - |
| 86854 | N/A | Point | - | - | - | - | S125009 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | PRECITA AVE | - | 145327 | 145327 | 37.746479 | -122.419313 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104039 | - | -122.419313 | 37.746479 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | POWERS AVE | - |
| 86855 | N/A | Point | - | - | - | - | S256275 | QUESADA AVE: KEITH ST | - | T | T | - | F | 20161000 | 20161000 | - | - | SOUTH EAST CORNER | - | - | - | - | KEITH ST | KEITH ST | 88962 | 88962 | 37.73123179 | -122.38772939 | QUESADA AVE \ KEITH ST | QUESADA AVE \ KEITH ST | 1736540773000 | middleware_editor | QUESADA AVE | KEITH ST intersection | 00928A | - | - | - | - | - | - | 104040 | 1353024000000 | -122.38772939 | 37.73123179 | - | 1736504700000 | - | D10 | - | STREET NAME | GUIDE | D3-1.1438 | 36X08 | SUP1 | 3IN IRON POST | IS | 1563611700000 | QUESADA AVE | - | - | - | - | - | - |
| 86856 | N/A | Point | - | - | - | - | S256274 | QUESADA AVE: KEITH ST | - | T | T | - | F | 20161000 | 20161000 | - | - | SOUTH EAST CORNER | - | - | - | - | KEITH ST | KEITH ST | 88961 | 88961 | 37.73123179 | -122.38772939 | QUESADA AVE \ KEITH ST | QUESADA AVE \ KEITH ST | 1736540685000 | middleware_editor | KEITH ST | KEITH ST intersection | 00928A | - | - | - | - | - | - | 104041 | 1353024000000 | -122.38772939 | 37.73123179 | - | 1736504700000 | - | D10 | - | STREET NAME | GUIDE | D3-1.0961 | 36X08 | SUP1 | 3IN IRON POST | IS | 1563611640000 | QUESADA AVE | - | - | - | - | - | - |
| 86857 | N/A | Point | - | - | - | - | S112673 | 34TH AVE: YORBA ST | - | F | F | - | F | 23340000 | 23340000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | YORBA ST | 34TH AVE | 7192 | 7192 | 37.73532702 | -122.49132052 | 34TH AVE \ YORBA ST | YORBA ST \ 34TH AVE | 1710539427000 | MTA | S F BIKE ROUTE (RED SYM) 85 (LA) | 34TH AVE intersection | - | PLUS "(LA N)"/ABOVE R1 | - | - | - | - | - | 104042 | 956707200000 | -122.49132052 | 37.73532702 | - | - | - | D4 | - | BIKE GUIDE | GUIDE | SG45R(85).0002 | 12X24 | SUP2 | LIGHT POLE | IS | 1373571480000 | YORBA ST | - | - | - | - | - | - |
| 86858 | N/A | Point | 1 | 1 | 400 - 453 | - | S289547 | 400-453 VALENCIA ST | 400-453 VALENCIA ST | F | F | - | F | 13058000 | 13058000 | - | SHOULD BE RETIRED | EAST SIDE | - | - | - | - | 15TH ST | 15TH ST | 122300 | 122300 | 37.766047124 | -122.421977685 | - | - | 1745271338000 | middleware_editor | TYPE K71 DELINEATORS | 15TH ST to SPARROW ST (400 - 453) | - | 10 K 71 | - | - | - | - | - | 104043 | 1691184600000 | -122.42200406 | 37.76613017 | - | 1711385100000 | 1745271300000 | D8 | - | DELINEATOR 5 | WARNING | TYPE-K71 | 30X08 | SUP2 | ANCHORS | RETD | 1684246260000 | VALENCIA ST | 400 - 453 VALENCIA ST | 400 - 453 VALENCIA ST | 400 VALENCIA ST | - | SPARROW ST | SPARROW ST |
| 86859 | N/A | Point | 1 | 1 | 637 - 699 | - | S289484 | 637-699 VALENCIA ST | 637-699 VALENCIA ST | F | F | - | F | 13063000 | 13063000 | - | SHOULD BE RETIRED | EAST SIDE | - | - | - | - | SYCAMORE ST | SYCAMORE ST | 95507 | 95507 | 37.762037381 | -122.421585571 | - | - | 1743714369000 | middleware_editor | BUS LANE CURB | SYCAMORE ST to 18TH ST (637 - 699) | - | SECTION 3 | - | - | - | - | - | 104044 | 1680850800000 | -122.42162044 | 37.76213987 | - | - | 1743714300000 | D8 | - | OTHER WARNING | WARNING | W(SF).0118 | 72X18 | SUP2 | ANCHORS | RETD | 1684145820000 | VALENCIA ST | 637 - 699 VALENCIA ST | 637 - 699 VALENCIA ST | 637 VALENCIA ST | - | 18TH ST | 18TH ST |
| 86860 | N/A | Point | 1 | 1 | 623 - 654 | - | S289479 | 623-654 VALENCIA ST | 623-654 VALENCIA ST | F | F | - | F | 13062000 | 13062000 | - | SHOULD BE RETIRED | WEST SIDE | - | - | - | - | CLARION ALY | CLARION ALY | 102285 | 102285 | 37.762857375 | -122.421728728 | - | - | 1743773230000 | middleware_editor | BUS LANE CURB | CLARION ALY to SYCAMORE ST (623 - 654) | - | SECTION 1 | - | - | - | - | - | 104045 | 1680850800000 | -122.42167866 | 37.76274782 | - | - | 1743773160000 | D8 | - | OTHER WARNING | WARNING | W(SF).0118 | 72X18 | SUP2 | ANCHORS | RETD | 1684144380000 | VALENCIA ST | 623 - 654 VALENCIA ST | 623 - 654 VALENCIA ST | 623 VALENCIA ST | - | SYCAMORE ST | SYCAMORE ST |
| 86861 | N/A | Point | 1 | 1 | 100 - 199 | - | S226224 | 100-199 GROVE ST | 100-199 GROVE ST | F | F | - | F | 6554000 | 6554000 | - | - | NORTH SIDE | - | - | - | - | DR CARLTON B GOODLETT PL \ POLK ST | DR CARLTON B GOODLETT PL \ POLK ST | 61256 | 61256 | 37.77838141 | -122.41905837 | - | - | 1710539427000 | MTA | BIKE RACK | DR CARLTON B GOODLETT PL \ POLK ST to VAN NESS AVE (100 - 199) | - | 152 WEST OF POLK | - | - | - | - | - | 104046 | 1469536860000 | -122.41905837 | 37.77838141 | - | 1469491200000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1465033800000 | GROVE ST | 100 - 199 GROVE ST | 100 - 199 GROVE ST | 100 GROVE ST | - | VAN NESS AVE | VAN NESS AVE |
| 86862 | N/A | Point | 1 | 1 | 100 - 199 | - | S226229 | 100-199 GROVE ST | 100-199 GROVE ST | F | F | - | F | 6554000 | 6554000 | - | - | NORTH SIDE | - | - | - | - | DR CARLTON B GOODLETT PL \ POLK ST | DR CARLTON B GOODLETT PL \ POLK ST | 61259 | 61259 | 37.77838141 | -122.41905837 | - | - | 1710539427000 | MTA | BIKE RACK | DR CARLTON B GOODLETT PL \ POLK ST to VAN NESS AVE (100 - 199) | - | 292' WEST OF POLK | - | - | - | - | - | 104047 | - | -122.41905837 | 37.77838141 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1465034280000 | GROVE ST | 100 - 199 GROVE ST | 100 - 199 GROVE ST | 100 GROVE ST | - | VAN NESS AVE | VAN NESS AVE |
| 86863 | N/A | Point | - | - | - | - | S275644 | LYON ST: FULTON ST | - | F | F | - | F | - | 26370000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | - | FULTON ST | 105976 | 105976 | 37.77622604 | -122.44313245 | - | LYON ST \ FULTON ST | 1726762177000 | middleware_editor | SLOW STREETS FAMILY, H/C, PED, SKATEBOARD, BIKE (SYM)(COMBO) | FULTON ST intersection | - | 9 FT AND 14 FT 9 INCHES FROM CURB | - | - | - | - | - | 104048 | 1680825600000 | -122.44313245 | 37.77622604 | - | 1726484400000 | - | D5 | - | OTHER REGULATORY | REG | R(SF).0451 | 12X36 | SUP1 | CITY POST EMBEDDED ACHOR CUP 4 | IS | 1624446000000 | LYON ST | - | - | - | - | - | - |
| 86864 | N/A | Point | - | - | - | - | S137108 | LYON ST: FULTON ST | - | F | F | - | F | 26370000 | 26370000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LYON ST | FULTON ST | 28523 | 28523 | 37.77622604 | -122.44313245 | FULTON ST \ LYON ST | LYON ST \ FULTON ST | 1710539427000 | MTA | ALL WAY | FULTON ST intersection | - | - | - | - | - | - | - | 104049 | 1344816000000 | -122.44313245 | 37.77622604 | - | - | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1373579160000 | LYON ST | - | - | - | - | - | - |
| 86865 | N/A | Point | - | - | - | - | S137099 | LYON ST: FULTON ST | - | F | F | - | F | 26370000 | 26370000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LYON ST | FULTON ST | 28517 | 28517 | 37.77622604 | -122.44313245 | FULTON ST \ LYON ST | LYON ST \ FULTON ST | 1710539427000 | MTA | ALL WAY | FULTON ST intersection | - | - | - | - | - | - | - | 104050 | 1344556800000 | -122.44313245 | 37.77622604 | - | 1553644800000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373579160000 | LYON ST | - | - | - | - | - | - |
| 86866 | N/A | Point | - | - | - | - | S137098 | FULTON ST: LYON ST | - | F | F | - | F | 26370000 | 26370000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LYON ST | FULTON ST | 28516 | 28516 | 37.77622604 | -122.44313245 | FULTON ST \ LYON ST | LYON ST \ FULTON ST | 1710539427000 | MTA | ALL WAY | FULTON ST intersection | - | - | - | - | - | - | - | 104051 | 1344556800000 | -122.44313245 | 37.77622604 | - | 1707313740000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373579160000 | LYON ST | - | - | - | - | - | - |
| 86867 | N/A | Point | 1 | 1 | 100 - 199 | - | S241662 | 100-199 GROVE ST | 100-199 GROVE ST | F | F | - | F | 6554000 | 6554000 | - | - | NORTH SIDE | - | - | - | - | DR CARLTON B GOODLETT PL \ POLK ST | DR CARLTON B GOODLETT PL \ POLK ST | 75123 | 75123 | 37.77838141 | -122.41905837 | - | - | 1710539427000 | MTA | PERMIT PARKING ONLY 6A-7P M-F CITY OWNED VEH (PERMIT #) | DR CARLTON B GOODLETT PL \ POLK ST to VAN NESS AVE (100 - 199) | - | 170' EAST OF VAN NESS(PERMIT #83) | - | - | - | - | - | 104052 | 1450396800000 | -122.41905837 | 37.77838141 | - | 1513296000000 | - | D6 | - | PARKING | REG | R32C(SF).0068 | 10X15 | SUP1 | 2IN IRON POST | IS | 1513679880000 | GROVE ST | 100 - 199 GROVE ST | 100 - 199 GROVE ST | 100 GROVE ST | - | VAN NESS AVE | VAN NESS AVE |
| 86868 | N/A | Point | 1 | 1 | 100 - 199 | - | S241673 | 100-199 GROVE ST | 100-199 GROVE ST | F | F | - | F | 6554000 | 6554000 | - | - | NORTH SIDE | - | - | - | - | DR CARLTON B GOODLETT PL \ POLK ST | DR CARLTON B GOODLETT PL \ POLK ST | 75131 | 75131 | 37.77838141 | -122.41905837 | - | - | 1710539427000 | MTA | PERMIT PARKING ONLY 6A-7P M-F CITY OWNED VEH (PERMIT #) | DR CARLTON B GOODLETT PL \ POLK ST to VAN NESS AVE (100 - 199) | - | 160' WEST OF POLK (PERMIT #77) | - | - | - | - | - | 104053 | 1486512000000 | -122.41905837 | 37.77838141 | - | 1513900800000 | - | D6 | - | PARKING | REG | R32C(SF).0068 | 10X15 | SUP1 | 2IN IRON POST | IS | 1513680420000 | GROVE ST | 100 - 199 GROVE ST | 100 - 199 GROVE ST | 100 GROVE ST | - | VAN NESS AVE | VAN NESS AVE |
| 86869 | N/A | Point | 1 | 1 | 100 - 199 | - | S248065 | 100-199 GROVE ST | 100-199 GROVE ST | F | F | - | F | 6554000 | 6554000 | - | - | SOUTH SIDE | - | - | - | - | DR CARLTON B GOODLETT PL \ POLK ST | DR CARLTON B GOODLETT PL \ POLK ST | 77018 | 77018 | 37.77838141 | -122.41905837 | - | - | 1729804623000 | middleware_editor | VENDOR | DR CARLTON B GOODLETT PL \ POLK ST to VAN NESS AVE (100 - 199) | - | 195' E OF VAN NESS | - | - | - | - | - | 104054 | 1535723460000 | -122.41905837 | 37.77838141 | - | - | 1729762800000 | D6 | - | OTHER REGULATORY | REG | R(SF).0337 | 12X12 | SUP1 | 2IN FLANGE POST | RETD | 1535624100000 | GROVE ST | 100 - 199 GROVE ST | 100 - 199 GROVE ST | 100 GROVE ST | - | VAN NESS AVE | VAN NESS AVE |
| 86870 | N/A | Point | 1 | 1 | 100 - 199 | - | S135880 | 100-199 GROVE ST | 100-199 GROVE ST | F | F | - | F | 6554000 | 6554000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | DR CARLTON B GOODLETT PL \ POLK ST | DR CARLTON B GOODLETT PL \ POLK ST | 108868 | 108868 | 37.77838141 | -122.41905837 | - | - | 1710539427000 | MTA | CIVIC CENTER (LA) | DR CARLTON B GOODLETT PL \ POLK ST to VAN NESS AVE (100 - 199) | - | 120'W OF POLK | - | - | - | - | - | 104055 | 1328486400000 | -122.41905837 | 37.77838141 | - | - | - | D6 | - | OTHER GUIDE | GUIDE | G-C(SF).0048 | 30X30 | SUP1 | MUNI POLE | IS | 1373578740000 | GROVE ST | 100 - 199 GROVE ST | 100 - 199 GROVE ST | 100 GROVE ST | - | VAN NESS AVE | VAN NESS AVE |
| 86871 | N/A | Point | - | - | - | - | S104087 | MILTON ST: BOSWORTH ST | - | F | F | - | F | 21858000 | 21858000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MILTON ST | BOSWORTH ST | 2983 | 2983 | 37.73339282 | -122.429422 | BOSWORTH ST \ MILTON ST | MILTON ST \ BOSWORTH ST | 1710539427000 | MTA | STOP | BOSWORTH ST intersection | - | 0 / 00 | - | - | - | - | - | 104056 | -47952000000 | -122.429422 | 37.73339282 | - | 634521600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568840000 | MILTON ST | - | - | - | - | - | - |
| 86872 | N/A | Point | - | - | - | - | S104086 | MILTON ST: BOSWORTH ST | - | F | F | - | F | 9031002 | 21858000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GLEN CT | BOSWORTH ST | 2982 | 2982 | 37.73339282 | -122.429422 | - | MILTON ST \ BOSWORTH ST | 1710539427000 | MTA | STOP | BOSWORTH ST intersection | - | 0 / 00 | - | - | - | - | - | 104057 | -47952000000 | -122.429422 | 37.73339282 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568840000 | MILTON ST | 50 - 99 MILTON ST | - | - | - | BOSWORTH ST | - |
| 86873 | N/A | Point | - | - | - | - | S108958 | BOSWORTH ST: MILTON ST | - | F | F | - | F | 3021000 | 21858000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CUVIER ST | BOSWORTH ST | 8677 | 8677 | 37.73339282 | -122.429422 | - | MILTON ST \ BOSWORTH ST | 1710539427000 | MTA | STOP | BOSWORTH ST intersection | - | 0 / 0 | - | - | - | - | - | 104058 | 376876800000 | -122.429422 | 37.73339282 | - | 782524800000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570340000 | MILTON ST | 200 - 299 BOSWORTH ST | - | - | - | MILTON ST | - |
| 86874 | N/A | Point | - | - | - | - | S258414 | MILTON ST: BOSWORTH ST | - | F | F | - | F | - | 21858000 | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | - | - | - | - | - | BOSWORTH ST | 87847 | 87847 | 37.73339282 | -122.429422 | - | MILTON ST \ BOSWORTH ST | 1710539427000 | MTA | STOP | BOSWORTH ST intersection | - | - | - | - | - | - | - | 104059 | - | -122.429422 | 37.73339282 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1571391300000 | MILTON ST | - | - | - | - | - | - |
| 86875 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S147969 | 2500-2599 14TH AVE | 2500-2599 14TH AVE | F | F | - | F | 574000 | 574000 | - | - | WEST SIDE | - | - | - | - | ULLOA ST | ULLOA ST | 37411 | 37411 | 37.74049473 | -122.47004007 | - | - | 1710539427000 | MTA | NPRK 1PM-3PM 1ST & 3RD WED OF MONTH STCL | ULLOA ST to VICENTE ST (2500 - 2599) | - | 6`SOUTH | - | - | - | - | - | 104060 | 1224460800000 | -122.47004007 | 37.74049473 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0097 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1375728660000 | 14TH AVE | 2500 - 2599 14TH AVE | 2500 - 2599 14TH AVE | 2500 14TH AVE | - | VICENTE ST | VICENTE ST |
| 86876 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S147970 | 2500-2599 14TH AVE | 2500-2599 14TH AVE | F | F | - | F | 574000 | 574000 | - | - | WEST SIDE | - | - | - | - | ULLOA ST | ULLOA ST | 127014 | 127014 | 37.74049473 | -122.47004007 | - | - | 1710539427000 | MTA | NPRK 1PM-3PM 1ST & 3RD WED OF MONTH STCL | ULLOA ST to VICENTE ST (2500 - 2599) | - | 2547 14TH AVE | - | - | - | - | - | 104061 | 1224460800000 | -122.47004007 | 37.74049473 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0097 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1375728660000 | 14TH AVE | 2500 - 2599 14TH AVE | 2500 - 2599 14TH AVE | 2500 14TH AVE | - | VICENTE ST | VICENTE ST |
| 86877 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S147968 | 2500-2599 14TH AVE | 2500-2599 14TH AVE | F | F | - | F | 574000 | 574000 | - | - | WEST SIDE | - | - | - | - | ULLOA ST | ULLOA ST | 37410 | 37410 | 37.74049473 | -122.47004007 | - | - | 1710539427000 | MTA | NPRK 1PM-3PM 1ST & 3RD WED OF MONTH STCL | ULLOA ST to VICENTE ST (2500 - 2599) | - | 2591 14TH AVE | - | - | - | - | - | 104062 | 1224460800000 | -122.47004007 | 37.74049473 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0097 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1375728660000 | 14TH AVE | 2500 - 2599 14TH AVE | 2500 - 2599 14TH AVE | 2500 14TH AVE | - | VICENTE ST | VICENTE ST |
| 86878 | N/A | Point | - | - | - | - | 22070 | - | - | - | - | - | - | 574000 | - | - | - | WEST SIDE | 1691618210000 | jsanfel | - | - | ULLOA ST | - | 145623 | 145623 | 37.7412439299999 | -122.470167107041 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | - | - | 20 ft south | - | - | - | - | - | 104063 | 1704450900000 | - | - | - | - | - | 07 | FLUORESCENT YELLOW GREEN | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP3 | 2IN IRON POST | IS | - | 14TH AVE | 2500 - 2599 14TH AVE | - | - | - | VICENTE ST | - |
| 86879 | N/A | Point | - | - | - | - | S269092 | 100-299 WEST PORTAL AVE | - | F | F | - | F | 13578000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | - | - | 91205 | 91205 | 37.7397 | -122.47 | - | - | 1710539427000 | MTA | (45 LA-DN) | - | - | APPROX 198 BELOW FLASH BEACON | - | - | - | - | - | 104064 | 1105056000000 | -122.47 | 37.7397 | - | 1515628800000 | - | D7 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | 3IN IRON POST | IS | 1602670500000 | - | 100-299 WEST PORTAL AVE | - | - | - | - | - |
| 86880 | N/A | Point | 1 | 1 | 341 - 489 | - | S232283 | 0-489 BAYSHORE BLVD | 341-489 BAY SHORE BLVD | F | F | - | F | 2800102 | 2800102 | - | - | EAST SIDE | - | - | - | - | FLOWER ST | FLOWER ST | 70888 | 70888 | 37.7410481 | -122.40642678 | - | - | 1710539427000 | MTA | TANSAT | FLOWER ST to CORTLAND AVE (341 - 489) -- EAST -- | - | 45' SOUTH OF FLOWER ST | - | - | - | - | - | 104065 | 1484223840000 | -122.40642678 | 37.7410481 | - | 1484179200000 | - | D10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1483519980000 | BAY SHORE BLVD | 341 - 489 BAY SHORE BLVD | 341 - 489 BAY SHORE BLVD | 341 BAY SHORE BLVD | - | CORTLAND AVE | CORTLAND AVE |
| 86881 | N/A | Point | - | - | - | - | S260654 | HILL POINT AVE: PARNASSUS AVE | - | F | F | - | F | 6925000 | 26310000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | START: 1-99 BLOCK | PARNASSUS AVE | 99923 | 99923 | 37.76407007 | -122.45578107 | - | HILL POINT AVE \ PARNASSUS AVE | 1743613514000 | middleware_editor | DEAD END | PARNASSUS AVE intersection | - | - | - | - | - | - | - | 104066 | 1581456480000 | -122.45578107 | 37.76407007 | - | - | - | D5 | - | OTHER WARNING | WARNING | W14-1.0001 | 24X24 | SUP1 | 3IN IRON POST | IS | 1579783440000 | HILL POINT AVE | 1 - 99 HILL POINT AVE | - | - | - | PARNASSUS AVE | - |
| 86882 | N/A | Point | - | - | - | - | S288327 | HILL POINT AVE: PARNASSUS AVE | - | F | F | - | F | 26310000 | 26310000 | - | - | NORTH WEST CORNER | - | - | - | - | HILL POINT AVE | PARNASSUS AVE | 100813 | 100813 | 37.76407007 | -122.45578107 | PARNASSUS AVE \ HILL POINT AVE | HILL POINT AVE \ PARNASSUS AVE | 1710539427000 | MTA | HILL POINT AVE | PARNASSUS AVE intersection | - | <000| NORTH | - | - | - | - | - | 104067 | - | -122.45578107 | 37.76407007 | - | 1686009600000 | - | D5 | - | STREET NAME | GUIDE | D3-1.0842 | 36X08 | SUP1 | LIGHT POLE | IS | 1680252780000 | HILL POINT AVE | - | - | - | - | - | - |
| 86883 | N/A | Point | - | - | - | - | S112092 | ORTEGA ST: 20TH AVE | - | F | F | - | F | 27334000 | 27334000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ORTEGA ST | 20TH AVE | 10995 | 10995 | 37.7523291 | -122.47741498 | 20TH AVE \ ORTEGA ST | ORTEGA ST \ 20TH AVE | 1710539427000 | MTA | STOP | 20TH AVE intersection | - | - | - | - | - | - | - | 104068 | 912816000000 | -122.47741498 | 37.7523291 | - | 1509408000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571300000 | ORTEGA ST | - | - | - | - | - | - |
| 86884 | N/A | Point | - | - | - | - | S119697 | 20TH AVE: ORTEGA ST | - | F | F | - | F | 27334000 | 27334000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ORTEGA ST | 20TH AVE | 13887 | 13887 | 37.7523291 | -122.47741498 | 20TH AVE \ ORTEGA ST | ORTEGA ST \ 20TH AVE | 1710539427000 | MTA | ALL WAY | 20TH AVE intersection | - | - | - | - | - | - | - | 104069 | 1099699200000 | -122.47741498 | 37.7523291 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573700000 | ORTEGA ST | - | - | - | - | - | - |
| 86885 | N/A | Point | - | - | - | - | 22143 | - | - | F | F | - | F | 2800201 | - | - | - | WEST SIDE | 1691792830000 | APADILLA | - | - | OAKDALE AVE | - | 146289 | 146289 | 37.742811703019 | -122.405635799744 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM MON WED FRI SAT STCL | - | - | 130FT SOUTH OF OAKDALE | - | - | - | - | - | 104070 | - | - | - | - | - | - | 09 | - | STREET CLEANING | REG | R30B(CA).0050 | 18X18 | SUP3 | LIGHT POLE | PI | - | BAY SHORE BLVD | 300 - 338 BAY SHORE BLVD | - | - | - | COSGROVE ST | - |
| 86886 | N/A | Point | - | - | - | - | S261936 | CYRIL MAGNIN ST: ELLIS ST | - | T | T | - | F | 5170000 | 24895000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POWELL ST | ELLIS ST | 98976 | 98976 | 37.78538825 | -122.40866708 | - | CYRIL MAGNIN ST \ ELLIS ST | 1729113812000 | middleware_editor | ONE WAY (LA) | ELLIS ST intersection | - | - | - | - | - | - | - | 104071 | 1323129600000 | -122.40866708 | 37.78538825 | - | 1583539200000 | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1582719660000 | CYRIL MAGNIN ST | 100 - 148 ELLIS ST | - | - | - | CYRIL MAGNIN ST | - |
| 86887 | N/A | Point | - | - | - | - | S261935 | CYRIL MAGNIN ST: ELLIS ST | - | T | T | - | F | 5170000 | 24895000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POWELL ST | ELLIS ST | 110520 | 110520 | 37.78538825 | -122.40866708 | - | CYRIL MAGNIN ST \ ELLIS ST | 1742845787000 | middleware_editor | NO RIGHT TURN (SYM) | ELLIS ST intersection | - | - | - | - | - | - | - | 104072 | 1323158400000 | -122.40866708 | 37.78538825 | - | - | 1731449940000 | D6 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | LIGHT POLE | RETD | 1582719540000 | CYRIL MAGNIN ST | 100 - 148 ELLIS ST | - | - | - | CYRIL MAGNIN ST | - |
| 86888 | N/A | Point | - | - | - | - | S261940 | CYRIL MAGNIN ST: ELLIS ST | - | T | T | - | F | 5170000 | 24895000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POWELL ST | ELLIS ST | 98980 | 98980 | 37.78538825 | -122.40866708 | - | CYRIL MAGNIN ST \ ELLIS ST | 1729127879000 | middleware_editor | NO LEFT TURN (SYM) | ELLIS ST intersection | - | - | - | - | - | - | - | 104073 | 1322524800000 | -122.40866708 | 37.78538825 | - | 1583539200000 | - | D6 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1582721460000 | CYRIL MAGNIN ST | 100 - 148 ELLIS ST | - | - | - | CYRIL MAGNIN ST | - |
| 86889 | N/A | Point | 1 | 1 | 1200 - 1299 | RIGHT ARROW | S286336 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | F | F | - | F | 10672000 | 10672000 | - | - | WEST SIDE | - | - | - | - | 24TH ST | 24TH ST | 97056 | 97056 | 37.75236512 | -122.40627783 | - | - | 1710539427000 | MTA | TA (SYM) PLO 8AM-10AM/3PM-6PM MON-FRI (5 MIN) | 24TH ST to 25TH ST (1200 - 1299) | - | 54' NORTH OF 25 TH ST @ PAINT MARK. | - | - | - | - | - | 104074 | 1674086400000 | -122.40627783 | 37.75236512 | - | - | - | D9 | - | OTHER REGULATORY | REG | R38(SF)1.0249 | 18X21 | SUP2 | 2IN IRON POST | IS | 1669987440000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86890 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S258371 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | T | T | - | F | 10672000 | 10672000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 87743 | 87743 | 37.75236512 | -122.40627783 | - | - | 1710539427000 | MTA | "P" (WHITE-BLUE) | 24TH ST to 25TH ST (1200 - 1299) | - | 25' S OF 24TH ST | - | - | - | - | - | 104075 | 1572013260000 | -122.40627783 | 37.75236512 | - | - | - | D9 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1571304840000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86891 | N/A | Point | 1 | 1 | 1200 - 1299 | LEFT ARROW | S286337 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | F | F | - | F | 10672000 | 10672000 | - | - | WEST SIDE | - | - | - | - | 24TH ST | 24TH ST | 97057 | 97057 | 37.75236512 | -122.40627783 | - | - | 1710539427000 | MTA | TA (SYM) PLO 8AM-10AM/3PM-6PM MON-FRI (5 MIN) | 24TH ST to 25TH ST (1200 - 1299) | - | 89' NORTH OF 25 TH ST @ PAINT MARK. | - | - | - | - | - | 104076 | 1674086400000 | -122.40627783 | 37.75236512 | - | - | - | D9 | - | OTHER REGULATORY | REG | R38(SF)1.0249 | 18X21 | SUP2 | 2IN IRON POST | IS | 1669987740000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86892 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S128240 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | F | F | - | F | 10672000 | 10672000 | - | - | WEST SIDE | - | - | - | - | 24TH ST | 24TH ST | 23163 | 23163 | 37.75236512 | -122.40627783 | - | - | 1728351648000 | middleware_editor | NPRK 8AM-10AM MON WED FRI STCL | 24TH ST to 25TH ST (1200 - 1299) | - | IFO#1294 | - | - | - | - | - | 104077 | 1196726400000 | -122.40627783 | 37.75236512 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0265 | 18X18 | SUP2 | LIGHT POLE | IS | 1373576400000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86893 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S128239 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | F | F | - | F | 10672000 | 10672000 | - | - | WEST SIDE | - | - | - | - | 24TH ST | 24TH ST | 117696 | 117696 | 37.75236512 | -122.40627783 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM MON WED FRI STCL | 24TH ST to 25TH ST (1200 - 1299) | - | IFO#1248 | - | - | - | - | - | 104078 | 1196726400000 | -122.40627783 | 37.75236512 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0265 | 18X18 | SUP2 | LIGHT POLE | IS | 1373576400000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86894 | N/A | Point | 1 | 1 | 1296 - 1365 | - | S114764 | 1296-1365 POTRERO AVE | 1296-1365 POTRERO AVE | T | T | - | F | 10673000 | 10673000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 25TH ST | 25TH ST | 12121 | 12121 | 37.75154656 | -122.40620299 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | 25TH ST to 25TH ST \ CESAR CHAVEZ ON RAMP (1296 - 1365) | - | OPP C-LINE | - | - | - | - | - | 104079 | 1014854400000 | -122.40620299 | 37.75154656 | - | 1630281600000 | - | D10 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP1 | LIGHT POLE | IS | 1373572140000 | POTRERO AVE | 1296 - 1365 POTRERO AVE | 1296 - 1365 POTRERO AVE | 1296 POTRERO AVE | - | 25TH ST \ CESAR CHAVEZ ON RAMP | 25TH ST \ CESAR CHAVEZ ON RAMP |
| 86895 | N/A | Point | 1 | 1 | 1296 - 1365 | VERTICAL ARROW | S124382 | 1296-1365 POTRERO AVE | 1296-1365 POTRERO AVE | T | T | - | F | 10673000 | 10673000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 25TH ST | 25TH ST | 17475 | 17475 | 37.75154656 | -122.40620299 | - | - | 1710539427000 | MTA | HOSPITAL | 25TH ST to 25TH ST \ CESAR CHAVEZ ON RAMP (1296 - 1365) | - | 150`SOUTH | - | - | - | - | - | 104080 | 1152057600000 | -122.40620299 | 37.75154656 | - | 1546905600000 | - | D10 | - | OTHER GUIDE | GUIDE | G-H(SF).0010 | 30X30 | SUP1 | MUNI POLE | IS | 1373575200000 | POTRERO AVE | 1296 - 1365 POTRERO AVE | 1296 - 1365 POTRERO AVE | 1296 POTRERO AVE | - | 25TH ST \ CESAR CHAVEZ ON RAMP | 25TH ST \ CESAR CHAVEZ ON RAMP |
| 86896 | N/A | Point | - | - | - | - | S247014 | MANSELL ST: JOHN F SHELLEY DR | - | F | F | - | F | 20945000 | 20945000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | MANSELL ST | JOHN F SHELLEY DR | 82478 | 82478 | 37.71876609 | -122.41851237 | JOHN F SHELLEY DR \ MANSELL ST | MANSELL ST \ JOHN F SHELLEY DR | 1710539427000 | MTA | ALL WAY | JOHN F SHELLEY DR intersection | - | JOHN F SHELLEY DR (EAST) | - | - | - | - | - | 104081 | 1484611200000 | -122.41851237 | 37.71876609 | - | 1484611200000 | - | 09 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP3 | LIGHT POLE | IS | 1531494540000 | MANSELL ST | - | - | - | - | - | - |
| 86897 | N/A | Point | - | - | - | - | S247017 | MANSELL ST: VISITACION AVE | - | F | F | - | F | 13332000 | 33350000 | - | - | CENTER ISLAND, W LINE, SOUTHBOUND | - | - | - | - | HAHN ST \ MRS. JACKSON WAY | VISITACION AVE | 82480 | 82480 | 37.7187541 | -122.41167332 | - | MANSELL ST \ VISITACION AVE | 1730737905000 | middleware_editor | ALL WAY | VISITACION AVE intersection | - | ALLWAYS FOR VEHICLES | - | - | - | - | - | 104082 | 1485907200000 | -122.41167332 | 37.7187541 | - | 1531872000000 | - | 09 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP3 | 2IN IRON POST | IS | 1531495080000 | MANSELL ST | 1700 - 2499 VISITACION AVE | - | - | - | MANSELL ST | - |
| 86898 | N/A | Point | - | - | - | - | S243442 | MANSELL ST: VISITACION AVE | - | F | F | - | F | 13332000 | 33350000 | - | - | SOUTH WEST CORNER | - | - | - | - | HAHN ST \ MRS. JACKSON WAY | VISITACION AVE | 83170 | 83170 | 37.7187541 | -122.41167332 | - | MANSELL ST \ VISITACION AVE | 1730737801000 | middleware_editor | MANSELL ST | VISITACION AVE intersection | - | - | - | - | - | - | - | 104083 | - | -122.41167332 | 37.7187541 | - | 1677110400000 | - | 09 | - | STREET NAME | GUIDE | D3-1.1110 | 36X08 | SUP3 | LIGHT POLE | IS | 1519989180000 | MANSELL ST | 1700 - 2499 VISITACION AVE | - | - | - | MANSELL ST | - |
| 86899 | N/A | Point | - | - | - | - | S254535 | BRUMISS TER: ACTON ST | - | F | F | - | F | 33702000 | 33702000 | - | - | NORTH WEST CORNER | - | - | - | - | BRUMISS TER | ACTON ST | 86037 | 86037 | 37.7082148 | -122.45234681 | ACTON ST \ BRUMISS TER | BRUMISS TER \ ACTON ST | 1710539427000 | MTA | BRUMISS TER | ACTON ST intersection | - | CROSS STREET IS ACTION | - | - | - | - | - | 104084 | 1467072000000 | -122.45234681 | 37.7082148 | - | 1467072000000 | - | 11 | - | STREET NAME | GUIDE | D3-1.0269 | 36X08 | SUP3 | 3IN IRON POST | IS | 1558508820000 | BRUMISS TER | - | - | - | - | - | - |
| 86900 | N/A | Point | - | - | - | - | S256451 | MANSELL ST: VISITACION AVE | - | F | F | - | F | 33350000 | 33350000 | - | - | CENTER ISLAND, W LINE, WESTBOUND | - | - | - | - | VISITACION AVE | VISITACION AVE | 86069 | 86069 | 37.7187541 | -122.41167332 | MANSELL ST \ VISITACION AVE | MANSELL ST \ VISITACION AVE | 1730737626000 | middleware_editor | DELINEATOR (Y) (SAFE HIT) | VISITACION AVE intersection | - | START 30' WEST OF W-X-WALK, THEN 40' OC | - | - | - | - | - | 104085 | 1564748700000 | -122.41167332 | 37.7187541 | - | - | - | 09 | - | DELINEATOR 5 | WARNING | TYPE-DL.0002 | 03X36 | SUP3 | DELINEATOR BASE SAFE HIT | IS | 1564147680000 | MANSELL ST | - | - | - | - | - | - |
| 86901 | N/A | Point | - | - | - | - | S257531 | HWY 101 N OFF RAMP: MARIPOSA S | - | F | F | - | F | 52255000 | 52255000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HWY 101 N OFF RAMP | MARIPOSA ST | 86722 | 86722 | 37.76336185 | -122.40467275 | MARIPOSA ST \ HWY 101 N OFF RAMP | HWY 101 N OFF RAMP \ MARIPOSA ST | 1710539427000 | MTA | STOP | MARIPOSA ST intersection | - | X-STREET IS VERMONT ST. | - | - | - | - | - | 104086 | 1586606280000 | -122.40467275 | 37.76336185 | - | - | - | 10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1567606560000 | HWY 101 N OFF RAMP | - | - | - | - | - | - |
| 86902 | N/A | Point | - | - | - | - | S257966 | MARKET ST: ORD ST | - | F | F | - | F | 26163000 | 26163000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ORD ST | MARKET ST | 86992 | 86992 | 37.76117789 | -122.44006866 | MARKET ST \ ORD ST | ORD ST \ MARKET ST | 1710950712000 | elclark | BIKE (SYM) BIKE ROUTE | MARKET ST intersection | 1178 | NEXT TO PED LIGHT | - | - | - | - | - | 104087 | 1136332800000 | -122.44006866 | 37.76117789 | - | 1533168000000 | - | 08 | - | BIKE GUIDE | GUIDE | D11-1C.0002 | 24X18 | SUP3 | SIGNAL POLE | IS | 1569402660000 | ORD ST | - | - | - | - | - | - |
| 86903 | N/A | Point | - | - | - | - | S254088 | HOLLOWAY AVE: TAPIA DR | - | F | F | - | F | 23102000 | 23102000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HOLLOWAY AVE | TAPIA DR | 87196 | 87196 | 37.72097222 | -122.48066941 | TAPIA DR \ HOLLOWAY AVE | HOLLOWAY AVE \ TAPIA DR | 1710539427000 | MTA | BIKE (SYM) BIKE ROUTE | TAPIA DR intersection | 0725 | AT HOLLOWAY/FONT ON SIDEWALK | - | - | - | - | - | 104088 | 1577975400000 | -122.48066941 | 37.72097222 | - | - | - | 07 | - | BIKE GUIDE | GUIDE | D11-1C.0002 | 24X18 | SUP3 | 2IN IRON POST | IS | 1556888760000 | HOLLOWAY AVE | - | - | - | - | - | - |
| 86904 | N/A | Point | - | - | - | - | S254090 | HOLLOWAY AVE: TAPIA DR | - | F | F | - | F | 23102000 | 23102000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HOLLOWAY AVE | TAPIA DR | 87197 | 87197 | 37.72097222 | -122.48066941 | TAPIA DR \ HOLLOWAY AVE | HOLLOWAY AVE \ TAPIA DR | 1710539427000 | MTA | BIKE WAYFINDING SIGN | TAPIA DR intersection | 0724 | IFO 603 FONT | - | - | - | - | - | 104089 | 1561550940000 | -122.48066941 | 37.72097222 | - | - | - | 07 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP3 | LIGHT POLE | IS | 1556889060000 | HOLLOWAY AVE | - | - | - | - | - | - |
| 86905 | N/A | Point | - | - | - | - | S271743 | LEE AVE: END | - | F | F | - | F | 54350000 | 54350000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | END: NORTH | END: NORTH | 87254 | 87254 | 37.72399386 | -122.4541015 | LEE AVE \ END: NORTH | END: NORTH intersection | 1710539427000 | MTA | STOP | END: NORTH intersection | - | INTERSECTION IS RIORDAN | - | - | - | - | - | 104090 | 1611240000000 | -122.4541015 | 37.72399386 | - | - | - | 07 | - | STOP | REG | R1-1.0001 | 24X24 | SUP3 | 2IN IRON POST | IS | 1611233760000 | LEE AVE | - | - | - | - | - | - |
| 86906 | N/A | Point | - | - | - | - | S258243 | 1100-1199 MARKET ST | - | T | T | - | F | 24429000 | - | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GROVE ST \ HYDE ST \ MARKET ST | - | 88762 | 88762 | 37.778556446012 | -122.414791626895 | 08TH ST \ GROVE ST \ HYDE ST \ MARKET ST | - | 1742414071000 | middleware_editor | BIKE WAYFINDING SIGN | - | 1205 | IFO#1201 ABOVE BIKE FINDING SIGN | - | - | - | - | - | 104091 | 1525676400000 | -122.414741 | 37.77806938 | - | - | - | 06 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | LIGHT POLE | IS | 1570709040000 | - | - | - | - | - | - | - |
| 86907 | N/A | Point | - | - | - | - | S257867 | MISSION BAY CIR: END | - | F | F | - | F | 35053000 | 35053000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | CHANNEL | CHANNEL | 88794 | 88794 | 37.77070119 | -122.39597958 | MISSION BAY CIR \ CHANNEL | MISSION BAY CIR \ CHANNEL | 1714006721000 | middleware_editor | KEEP RIGHT (SYM) | CHANNEL intersection | - | LOCATION B | - | - | - | - | - | 104092 | 1556841600000 | -122.39597958 | 37.77070119 | - | 1569456000000 | - | 06 | - | OTHER REGULATORY | REG | R4-7A.0001 | 18X24 | SUP1 | 2IN IRON POST | IS | 1568974680000 | MISSION BAY CIR | - | - | - | - | - | - |
| 86908 | N/A | Point | - | - | - | - | S257868 | MISSION BAY CIR: END | - | F | F | - | F | 35053000 | 35053000 | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | - | - | - | - | CHANNEL | CHANNEL | 88795 | 88795 | 37.77070119 | -122.39597958 | MISSION BAY CIR \ CHANNEL | MISSION BAY CIR \ CHANNEL | 1714006749000 | middleware_editor | KEEP RIGHT (SYM) | CHANNEL intersection | - | LOCATION C | - | - | - | - | - | 104093 | 1569501120000 | -122.39597958 | 37.77070119 | - | - | - | 06 | - | OTHER REGULATORY | REG | R4-7A.0001 | 18X24 | SUP1 | 2IN IRON POST | IS | 1568974920000 | MISSION BAY CIR | - | - | - | - | - | - |
| 86909 | N/A | Point | - | - | - | - | S258684 | SAN JOSE AVE: TINGLEY ST | - | F | F | - | F | 52093000 | 52093000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | TINGLEY ST | TINGLEY ST | 88933 | 88933 | 37.7311206 | -122.43614692 | SAN JOSE AVE \ TINGLEY ST | SAN JOSE AVE \ TINGLEY ST | 1710539427000 | MTA | 25 MPH (ADV SPEED) | TINGLEY ST intersection | - | 30 FT SOUTH OF THERESA | - | - | - | - | - | 104094 | 1475452800000 | -122.43614692 | 37.7311206 | - | 1575590400000 | - | 11 | - | SPEED LIMIT | WARNING | W13-1P.0009 | 30X30 | SUP3 | MUNI POLE | IS | 1572254340000 | SAN JOSE AVE | - | - | - | - | - | - |
| 86910 | N/A | Point | - | - | - | - | S259490 | 46TH AVE: SLOAT BLVD | - | F | F | - | F | 23456000 | 23456000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SLOAT BLVD | SLOAT BLVD | 90098 | 90098 | 37.73555788 | -122.50418533 | 46TH AVE \ SLOAT BLVD | 46TH AVE \ SLOAT BLVD | 1742261354000 | middleware_editor | STOP | SLOAT BLVD intersection | - | INTERSECTION OF 46TH AVE & SLOAT BLVD | - | - | - | - | - | 104095 | 105346800000 | -122.50418533 | 37.73555788 | - | 1587366000000 | - | 07 | - | STOP | REG | R1-1.0002 | 30X30 | SUP3 | 2IN IRON POST | IS | 1574693880000 | 46TH AVE | - | - | - | - | - | - |
| 86911 | N/A | Point | - | - | - | - | S270293 | 3RD ST: MISSION BAY BLVD | - | F | F | - | T | 34161000 | 34161000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | 3RD ST \ MISSION BAY BLVD | 03RD ST \ MISSION BAY BLVD | 90357 | 90357 | 37.77065674 | -122.38948328 | MISSION BAY BLVD SOUTH \ 3RD ST \ MISSION BAY BLVD | MISSION BAY BLVD SOUTH \ 03RD ST \ MISSION BAY BLVD | 1749483099000 | middleware_editor | NO LEFT TURN (SYM)/NO U TURN (SYM) | 03RD ST \ MISSION BAY BLVD intersection | - | X IS MISSION BAY SOUTH | - | - | - | - | - | 104096 | - | -122.38948328 | 37.77065674 | - | - | - | 06 | - | NO LEFT TURN | REG | R3-18.0001 | 24X24 | SUP1 | SIGNAL POLE | IS | 1605866700000 | MISSION BAY BLVD SOUTH | - | - | - | - | - | - |
| 86912 | N/A | Point | - | - | - | - | S269267 | TOMPKINS AVE: CRESCENT AVE \ P | - | F | F | - | F | 21030000 | 21030000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | TOMPKINS AVE | 91496 | 91496 | 37.73682277 | -122.40913848 | PERALTA AVE \ TOMPKINS AVE | PERALTA AVE \ TOMPKINS AVE | 1716989703000 | middleware_editor | DEAD END | TOMPKINS AVE intersection | - | X IS TOMPKINS | - | - | - | - | - | 104097 | 1603359000000 | -122.40913848 | 37.73682277 | - | - | - | 09 | - | OTHER WARNING | WARNING | W14-1.0002 | 30X30 | SUP3 | 2IN IRON POST | IS | 1603097040000 | PERALTA AVE | - | - | - | - | - | - |
| 86913 | N/A | Point | - | - | - | - | S272244 | 26TH ST: VERMONT ST | - | F | F | - | F | 33657000 | 33657000 | - | - | NORTH WEST CORNER | - | - | - | - | 26TH ST | 26TH ST | 92909 | 92909 | 37.75055812 | -122.40260485 | VERMONT ST \ 26TH ST | VERMONT ST \ 26TH ST | 1710539427000 | MTA | 26TH ST | 26TH ST intersection | - | @ VERMONT | - | - | - | - | - | 104098 | - | -122.40260485 | 37.75055812 | - | 1706626500000 | - | 10 | - | STREET NAME | GUIDE | D3-1.0021 | 36X08 | SUP1 | 3IN IRON POST | IS | 1612535040000 | VERMONT ST | - | - | - | - | - | - |
| 86914 | N/A | Point | - | - | - | - | S124748 | - | - | NO | NO | - | - | - | - | - | - | WEST SIDE | 1691445421000 | MTA | - | - | CAPP ST \ CESAR CHAVEZ ST | - | 145319 | 145319 | 37.74747 | -122.418671 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104099 | - | -122.418671 | 37.74747 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | PRECITA AVE | - |
| 86915 | N/A | Point | - | - | - | - | S124749 | - | - | NO | NO | - | - | - | - | - | - | WEST SIDE | 1691445421000 | MTA | - | - | VALENCIA ST | - | 145320 | 145320 | 37.744713 | -122.420456 | - | - | 1750954284000 | middleware_editor | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104100 | 1154674800000 | -122.420456 | 37.744713 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | IS | - | - | - | - | - | - | 29TH ST | - |
| 86916 | N/A | Point | - | - | - | - | S125004 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | 21ST ST | - | 145322 | 145322 | 37.756236 | -122.418824 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104101 | - | -122.418824 | 37.756236 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | 22ND ST | - |
| 86917 | N/A | Point | - | - | - | - | S125005 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | 21ST ST | - | 145323 | 145323 | 37.756236 | -122.418824 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104102 | - | -122.418824 | 37.756236 | - | - | 1653436800000 | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | RETD | - | - | - | - | - | - | 22ND ST | - |
| 86918 | N/A | Point | - | - | - | - | S125043 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | PRECITA AVE | - | 145331 | 145331 | 37.746479 | -122.419313 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104103 | - | -122.419313 | 37.746479 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | POWERS AVE | - |
| 86919 | N/A | Point | - | - | - | - | S125134 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | CAPP ST \ CESAR CHAVEZ ST | - | 145336 | 145336 | 37.74747 | -122.418671 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104104 | - | -122.418671 | 37.74747 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | PRECITA AVE | - |
| 86920 | N/A | Point | - | - | - | - | S125728 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | CAPP ST \ CESAR CHAVEZ ST | - | 145344 | 145344 | 37.74747 | -122.418671 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104105 | - | -122.418671 | 37.74747 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | PRECITA AVE | - |
| 86921 | N/A | Point | - | - | - | - | S124922 | - | - | NO | NO | - | - | - | - | - | - | WEST SIDE | 1691445421000 | MTA | - | - | 25TH ST | - | 145349 | 145349 | 37.74984 | -122.418212 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104106 | - | -122.418212 | 37.74984 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | 26TH ST | - |
| 86922 | N/A | Point | - | - | - | - | S124923 | - | - | NO | NO | - | - | - | - | - | - | WEST SIDE | 1691445421000 | MTA | - | - | 25TH ST | - | 145350 | 145350 | 37.74984 | -122.418212 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104107 | - | -122.418212 | 37.74984 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | 26TH ST | - |
| 86923 | N/A | Point | - | - | - | - | S124925 | - | - | NO | NO | - | - | - | - | - | - | WEST SIDE | 1691445421000 | MTA | - | - | 25TH ST | - | 145352 | 145352 | 37.74984 | -122.418212 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104108 | - | -122.418212 | 37.74984 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | 26TH ST | - |
| 86924 | N/A | Point | - | - | - | - | S124926 | - | - | NO | NO | - | - | - | - | - | - | WEST SIDE | 1691445421000 | MTA | - | - | CAPP ST \ CESAR CHAVEZ ST | - | 145353 | 145353 | 37.74747 | -122.418671 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104109 | - | -122.418671 | 37.74747 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | PRECITA AVE | - |
| 86925 | N/A | Point | - | - | - | - | S124929 | - | - | NO | NO | - | - | - | - | - | - | WEST SIDE | 1691445421000 | MTA | - | - | VALENCIA ST | - | 145355 | 145355 | 37.744713 | -122.420456 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104110 | - | -122.420456 | 37.744713 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | 29TH 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