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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24076 | N/A | Point | - | - | - | - | S230886 | CHENERY ST: ROANOKE ST | - | F | F | - | F | 21870000 | 21870000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CHENERY ST | CHENERY ST | 66316 | 66316 | 37.73555951 | -122.43024575 | ROANOKE ST \ CHENERY ST | ROANOKE ST \ CHENERY ST | 1725629173000 | middleware_editor | ALL WAY | CHENERY ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 41154 | 792288000000 | -122.43024575 | 37.73555951 | - | 1491177600000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479116700000 | ROANOKE ST | - | - | - | - | - | - |
| 24077 | N/A | Point | - | 1 | 1 - 99 | - | S226620 | 1-99 RHODE ISLAND ST | 1-99 RHODE ISLAND ST | F | F | - | F | 10992000 | 10992000 | - | - | EAST SIDE | - | - | - | - | DIVISION ST | DIVISION ST | 66318 | 66318 | 37.7692384 | -122.40298229 | - | - | 1754336497000 | middleware_editor | 4 HR PRK 8AM-6PM EXC SUN | DIVISION ST to ALAMEDA ST (1 - 99) | - | AT# 99 RHODE ISLAND ST. | - | - | - | - | - | 41155 | 1468265340000 | -122.40298229 | 37.7692384 | - | 1468220400000 | - | D10 | - | PARKING | REG | R32(CA).0104 | 18X18 | SUP1 | LIGHT POLE | IS | 1466001120000 | RHODE ISLAND ST | 1 - 99 RHODE ISLAND ST | 1 - 99 RHODE ISLAND ST | 1 RHODE ISLAND ST | - | ALAMEDA ST | ALAMEDA ST |
| 24078 | N/A | Point | 1 | 1 | 1 - 45 | - | S228167 | PNDG PORTOLA DR | 1-45 SAN LORENZO WAY | F | F | - | F | 11487000 | 11487000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | PORTOLA DR | PORTOLA DR | 66322 | 66322 | 37.73962677 | -122.4641502 | - | - | 1710539427000 | MTA | PUBLIC LIBRARY (LOGO) (LA) | PORTOLA DR to SANTA MONICA WAY (1 - 45) | - | 150`WEST OF CLAREMONT | - | - | - | - | - | 41156 | - | -122.4641502 | 37.73962677 | - | - | - | D7 | - | OTHER GUIDE | GUIDE | G-P(SF).0116 | 24X42 | SUP2 | LIGHT POLE | IS | 1471435500000 | SAN LORENZO WAY | PNDG PORTOLA DR | 1 - 45 SAN LORENZO WAY | - | - | SANTA MONICA WAY | SANTA MONICA WAY |
| 24079 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S228171 | 1000-1099 IRVING ST | 1000-1099 IRVING ST | F | F | - | F | 7288000 | 7288000 | - | - | NORTH SIDE | - | - | - | - | 11TH AVE | 11TH AVE | 66323 | 66323 | 37.76391947 | -122.46898654 | - | - | 1710539427000 | MTA | NPRK 7AM-8AM MON WED STCL | 11TH AVE to 12TH AVE (1000 - 1099) | - | IFO#1098 | - | - | - | - | - | 41157 | 1548253740000 | -122.46898654 | 37.76391947 | - | - | - | D5 | - | STREET CLEANING | REG | R30B(CA).0217 | 18X18 | SUP1 | 2IN IRON POST | IS | 1471436640000 | IRVING ST | 1000 - 1099 IRVING ST | 1000 - 1099 IRVING ST | 1000 IRVING ST | - | 12TH AVE | 12TH AVE |
| 24080 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S227014 | 1800-1899 EGBERT AVE | 1800-1899 EGBERT AVE | F | F | - | F | 5118000 | 5118000 | - | - | NORTH SIDE | - | - | - | - | NEWHALL ST | NEWHALL ST | 66326 | 66326 | 37.72728431 | -122.40066462 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM TUE STCL | NEWHALL ST to PHELPS ST (1800 - 1899) | - | 75' WEST OF NEWHALL | - | - | - | - | - | 41158 | - | -122.40066462 | 37.72728431 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0083 | 18X18 | SUP1 | 2IN IRON POST | IS | 1467278520000 | EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 EGBERT AVE | - | PHELPS ST | PHELPS ST |
| 24081 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S227016 | 1800-1899 EGBERT AVE | 1800-1899 EGBERT AVE | F | F | - | F | 5118000 | 5118000 | - | - | NORTH SIDE | - | - | - | - | NEWHALL ST | NEWHALL ST | 66327 | 66327 | 37.72728431 | -122.40066462 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM TUE STCL | NEWHALL ST to PHELPS ST (1800 - 1899) | - | INFO #1886 | - | - | - | - | - | 41159 | 1471864080000 | -122.40066462 | 37.72728431 | - | 1471824000000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0083 | 18X18 | SUP1 | 2IN IRON POST | IS | 1467278880000 | EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 EGBERT AVE | - | PHELPS ST | PHELPS ST |
| 24082 | N/A | Point | 1 | 1 | 2900 - 2999 | RIGHT ARROW | S227028 | 2900-2999 CALIFORNIA ST | 2900-2999 CALIFORNIA ST | F | F | - | F | 3563000 | 3563000 | - | - | SOUTH SIDE | - | - | - | - | BRODERICK ST | BRODERICK ST | 66328 | 66328 | 37.7876278161175 | -122.443284178599 | - | - | 1731615602000 | middleware_editor | NPRK 9AM-11AM MON STCL | BRODERICK ST to BAKER ST (2900 - 2999) | - | IFO #2971 | - | - | - | - | - | 41160 | - | -122.4429314 | 37.78775139 | - | - | - | D2 | - | STREET CLEANING | REG | R30B(CA).0300 | 18X18 | SUP1 | MUNI POLE | IS | 1467282660000 | CALIFORNIA ST | 2900 - 2999 CALIFORNIA ST | 2900 - 2999 CALIFORNIA ST | 2900 CALIFORNIA ST | - | BAKER ST | BAKER ST |
| 24083 | N/A | Point | 1 | 1 | 2900 - 2999 | RIGHT ARROW | S227030 | 2900-2999 CALIFORNIA ST | 2900-2999 CALIFORNIA ST | F | F | - | F | 3563000 | 3563000 | - | - | SOUTH SIDE | - | - | - | - | BRODERICK ST | BRODERICK ST | 66329 | 66329 | 37.7876294770936 | -122.443271197283 | - | - | 1731615667000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "G" PERMITS | BRODERICK ST to BAKER ST (2900 - 2999) | - | IFO #2971 | - | - | - | - | - | 41161 | - | -122.4429314 | 37.78775139 | - | - | - | D2 | - | PARKING:RPP | REG | R32C(CA).0086 | 18X21 | SUP1 | MUNI POLE | IS | 1467282900000 | CALIFORNIA ST | 2900 - 2999 CALIFORNIA ST | 2900 - 2999 CALIFORNIA ST | 2900 CALIFORNIA ST | - | BAKER ST | BAKER ST |
| 24084 | N/A | Point | - | - | - | - | S228459 | 15TH AVE: WAWONA ST | - | F | F | - | F | 22952000 | 22952000 | - | - | NORTH WEST CORNER | - | - | - | - | WAWONA ST | WAWONA ST | 66330 | 66330 | 37.73764891 | -122.47096273 | 15TH AVE \ WAWONA ST | 15TH AVE \ WAWONA ST | 1711722800000 | middleware_editor | 15TH AVE | WAWONA ST intersection | - | - | - | - | - | - | - | 41162 | 1473869400000 | -122.47096273 | 37.73764891 | - | 1473811200000 | - | D7 | - | STREET NAME | GUIDE | D3-1.0005 | 36X08 | SUP2 | 3IN IRON POST | IS | 1472214900000 | 15TH AVE | - | - | - | - | - | - |
| 24085 | N/A | Point | - | - | - | - | S228460 | WAWONA ST: 15TH AVE | - | F | F | - | F | 22952000 | 22952000 | - | - | NORTH WEST CORNER | - | - | - | - | WAWONA ST | WAWONA ST | 66331 | 66331 | 37.73764891 | -122.47096273 | 15TH AVE \ WAWONA ST | 15TH AVE \ WAWONA ST | 1711722853000 | middleware_editor | WAWONA ST | WAWONA ST intersection | - | - | - | - | - | - | - | 41163 | 1473869460000 | -122.47096273 | 37.73764891 | - | 1473811200000 | - | D7 | - | STREET NAME | GUIDE | D3-1.1841 | 36X08 | SUP2 | 3IN IRON POST | IS | 1472215200000 | 15TH AVE | - | - | - | - | - | - |
| 24086 | N/A | Point | - | - | - | - | S244221 | GEARY BLVD: FRANKLIN ST | - | T | T | - | F | 25213000 | 25213000 | - | - | SOUTH WEST CORNER | - | - | - | - | GEARY BLVD | FRANKLIN ST | 76903 | 76903 | 37.78548224 | -122.42302755 | FRANKLIN ST \ GEARY BLVD | GEARY BLVD \ FRANKLIN ST | 1710539427000 | MTA | GEARY ST | FRANKLIN ST intersection | - | - | - | - | - | - | - | 41164 | 1508284800000 | -122.42302755 | 37.78548224 | - | 1508284800000 | - | D2 | - | STREET NAME | GUIDE | D3-1.0718 | 36X08 | SUP1 | SIGNAL POLE | IS | 1522325880000 | GEARY BLVD | - | - | - | - | - | - |
| 24087 | N/A | Point | - | 1 | 1600 - 1667 | LEFT ARROW | S244557 | 1600-1667 MISSION ST | 1600-1667 MISSION ST | F | F | - | F | 9110000 | 9110000 | - | - | NORTH SIDE | - | - | - | - | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | 76904 | 76904 | 37.77203117 | -122.41913215 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7AM-7PM MON-SAT (5 MIN) | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE to PLUM ST (1600 - 1667) | - | 433FT SOUTH | - | - | - | - | - | 41165 | 1523616540000 | -122.41913215 | 37.77203117 | - | 1523577600000 | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0014 | 14X21 | SUP1 | 2IN IRON POST | IS | 1523270520000 | MISSION ST | 1600 - 1667 MISSION ST | 1600 - 1667 MISSION ST | 1600 MISSION ST | - | PLUM ST | PLUM ST |
| 24088 | N/A | Point | 1 | 1 | 1 - 99 | - | S252874 | 1-99 MCLEA CT | 1-99 MCLEA CT | F | F | - | F | 8934000 | 8934000 | - | - | SOUTH SIDE | - | - | - | - | START: 1-99 BLOCK | START: 1-99 BLOCK | 76910 | 76910 | 37.77203625 | -122.40869802 | - | - | 1733171476000 | middleware_editor | NPRK ANY TIME | START: 1-99 BLOCK to 09TH ST (1 - 99) | - | 20' WEST OF EAST TERMINUS | - | - | - | - | - | 41166 | 1555071240000 | -122.40869802 | 37.77203625 | - | - | - | D6 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1553844420000 | MCLEA CT | 1 - 99 MCLEA CT | 1 - 99 MCLEA CT | 1 MCLEA CT | - | 09TH ST | 09TH ST |
| 24089 | N/A | Point | - | - | - | - | S109278 | MORAGA ST: 34TH AVE | - | F | F | - | F | 27699000 | 27699000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MORAGA ST | 34TH AVE | 76911 | 76911 | 37.7554742244578 | -122.492560297246 | 34TH AVE \ MORAGA ST | MORAGA ST \ 34TH AVE | 1749769523000 | middleware_editor | STOP | 34TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 41167 | 440841600000 | -122.49267539 | 37.75539848 | - | 1684998000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1373570460000 | MORAGA ST | - | - | - | - | - | - |
| 24090 | N/A | Point | - | - | - | - | S108995 | 37TH AVE: SANTIAGO ST | - | F | F | - | F | 23408000 | 23408000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 37TH AVE | 37TH AVE | 76913 | 76913 | 37.74406827 | -122.49510921 | SANTIAGO ST \ 37TH AVE | SANTIAGO ST \ 37TH AVE | 1716426471000 | middleware_editor | STOP | 37TH AVE intersection | - | 0 / 00 | - | - | - | - | - | 41168 | 385603200000 | -122.49510921 | 37.74406827 | - | 1491782400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570340000 | SANTIAGO ST | - | - | - | - | - | - |
| 24091 | N/A | Point | - | - | - | - | S109004 | 36TH AVE: KIRKHAM ST | - | F | F | - | F | 27728000 | 27728000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 36TH AVE | 36TH AVE | 76914 | 76914 | 37.75902813 | -122.49508239 | KIRKHAM ST \ 36TH AVE | KIRKHAM ST \ 36TH AVE | 1710539427000 | MTA | STOP | 36TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 41169 | 385776000000 | -122.49508239 | 37.75902813 | - | 1484870400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570340000 | KIRKHAM ST | - | - | - | - | - | - |
| 24092 | N/A | Point | - | - | - | - | S109621 | LAURA ST: HURON AVE | - | F | F | - | F | 21556000 | 21556000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HURON AVE | LAURA ST | 76916 | 76916 | 37.71067069 | -122.45134423 | LAURA ST \ HURON AVE | HURON AVE \ LAURA ST | 1710539427000 | MTA | STOP | LAURA ST intersection | - | 0 / 00 | - | - | - | - | - | 41170 | 526694400000 | -122.45134423 | 37.71067069 | - | 1269475200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570580000 | HURON AVE | - | - | - | - | - | - |
| 24093 | N/A | Point | - | - | - | - | S109931 | DIAMOND HEIGHTS BLVD: BERKELEY | - | F | F | - | F | 22282000 | 22282000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BERKELEY WAY | BERKELEY WAY | 76917 | 76917 | 37.73868842 | -122.43954905 | DIAMOND HEIGHTS BLVD \ BERKELEY WAY | DIAMOND HEIGHTS BLVD \ BERKELEY WAY | 1710539427000 | MTA | DO NOT ENTER | BERKELEY WAY intersection | - | 0 / 0 | - | - | - | - | - | 41171 | 571968000000 | -122.43954905 | 37.73868842 | - | - | - | D8 | - | OTHER REGULATORY | REG | R5-1.0002 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373570640000 | DIAMOND HEIGHTS BLVD | - | - | - | - | - | - |
| 24094 | N/A | Point | 1 | 1 | 630 - 699 | - | S109028 | 630-699 FRANKLIN ST | 630-699 FRANKLIN ST | F | F | - | F | 5807000 | 5807000 | - | - | WEST SIDE, WESTBOUND TRAFFIC | - | - | - | - | REDWOOD ST | REDWOOD ST | 76918 | 76918 | 37.78058802 | -122.42203968 | - | - | 1710539427000 | MTA | ONE WAY (LA) | REDWOOD ST to GOLDEN GATE AVE (630 - 699) | - | 0 / 00 | - | - | - | - | - | 41172 | 388368000000 | -122.42203968 | 37.78058802 | - | - | - | D5 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373570340000 | FRANKLIN ST | 630 - 699 FRANKLIN ST | 630 - 699 FRANKLIN ST | 630 FRANKLIN ST | - | GOLDEN GATE AVE | GOLDEN GATE AVE |
| 24095 | N/A | Point | - | - | - | - | S111910 | SANSOME ST: PINE ST | - | T | T | - | F | 24686000 | 24686000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PINE ST | PINE ST | 76921 | 76921 | 37.7921084 | -122.40093308 | SANSOME ST \ PINE ST | SANSOME ST \ PINE ST | 1727375561000 | middleware_editor | DO NOT ENTER | PINE ST intersection | - | - | - | - | - | - | - | 41173 | 875318400000 | -122.40093308 | 37.7921084 | - | - | 1727350320000 | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | LIGHT POLE | RETD | 1373571240000 | SANSOME ST | - | - | - | - | - | - |
| 24096 | N/A | Point | - | - | - | - | S112224 | MONTGOMERY ST: CLAY ST | - | F | T | - | F | 24756000 | 24756000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CLAY ST | MONTGOMERY ST | 76922 | 76922 | 37.79466628 | -122.4031393 | MONTGOMERY ST \ CLAY ST | CLAY ST \ MONTGOMERY ST | 1733183418000 | middleware_editor | ONE WAY (RA) | MONTGOMERY ST intersection | - | - | - | - | - | - | - | 41174 | 936921600000 | -122.4031393 | 37.79466628 | - | 1724076420000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373571360000 | CLAY ST | - | - | - | - | - | - |
| 24097 | N/A | Point | 1 | 1 | 1000 - 1089 | - | S112906 | 1000-1228 WISCONSIN ST | 1000-1089 WISCONSIN ST | F | F | - | F | 13698000 | 13698000 | - | - | WEST SIDE, EASTBOUND TRAFFIC | - | - | - | - | 23RD ST | 23RD ST | 76924 | 76924 | 37.75428357 | -122.3986497 | - | - | 1710539427000 | MTA | TANP EXC DPH CLINIC EMPLS & PATR0N TOWED VEH CALL 553-1235 | 23RD ST to CORAL RD (1000 - 1089) | - | 25'N OF CORRAL RD @ PM | - | - | - | - | - | 41175 | 974160000000 | -122.3986497 | 37.75428357 | - | - | - | D10 | - | TOW (TANP ANY TIME) | REG | R26K(SF).0036 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373571600000 | WISCONSIN ST | 1000 - 1089 WISCONSIN ST | 1000 - 1089 WISCONSIN ST | 1000 WISCONSIN ST | - | CORAL RD | CORAL RD |
| 24098 | N/A | Point | 1 | 1 | 700 - 799 | - | S112936 | 700-799 TREAT AVE | 700-799 TREAT AVE | F | F | - | F | 12686000 | 12686000 | - | - | EAST SIDE | - | - | - | - | 20TH ST | 20TH ST | 76925 | 76925 | 37.75816264 | -122.4135233 | - | - | 1710539427000 | MTA | 1 HR PRK 9AM-6PM MON-SAT EXC "I" PERMITS | 20TH ST to 21ST ST (700 - 799) | - | 56'N OF 21ST ST | - | - | - | - | - | 41176 | 975715200000 | -122.4135233 | 37.75816264 | - | - | - | D9 | - | PARKING:RPP | REG | R32C(CA).0018 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373571600000 | TREAT AVE | 700 - 799 TREAT AVE | 700 - 799 TREAT AVE | 700 TREAT AVE | - | 21ST ST | 21ST ST |
| 24099 | N/A | Point | - | - | - | - | S247968 | MISSION ST: FREMONT ST | - | T | T | - | F | 24560000 | 24560000 | - | - | SOUTH WEST CORNER | - | - | - | - | MISSION ST | FREMONT ST | 76926 | 76926 | 37.79046107 | -122.39668969 | FREMONT ST \ MISSION ST | MISSION ST \ FREMONT ST | 1728349939000 | middleware_editor | MISSION ST | FREMONT ST intersection | - | - | - | - | - | - | - | 41177 | 1543587900000 | -122.39668969 | 37.79046107 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.1207 | 36X08 | SUP1 | LIGHT POLE | IS | 1535197740000 | MISSION ST | - | - | - | - | - | - |
| 24100 | N/A | Point | - | - | - | - | S247969 | MISSION ST: FREMONT ST | - | F | T | - | F | 24560000 | 24560000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MISSION ST | FREMONT ST | 76927 | 76927 | 37.79046107 | -122.39668969 | FREMONT ST \ MISSION ST | MISSION ST \ FREMONT ST | 1754430446000 | middleware_editor | FREMONT ST | FREMONT ST intersection | - | SE EB MAST ARM | - | - | - | - | - | 41178 | 1554847740000 | -122.39668969 | 37.79046107 | - | 1741022280000 | - | D6 | - | STREET NAME | GUIDE | D3-2.0162 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1535198640000 | MISSION ST | - | - | - | - | - | - |
| 24101 | N/A | Point | 1 | 1 | 3000 - 3099 | - | S226327 | 3000-3099 POLK ST | 3000-3099 POLK ST | F | F | - | F | 10586000 | 10586000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | BAY ST | BAY ST | 66393 | 66393 | 37.80482096 | -122.42356056 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | BAY ST to NORTH POINT ST (3000 - 3099) | 133814 | 25FT. NORTH OF BAY ST. | - | - | - | - | - | 41179 | 1320710400000 | -122.42356056 | 37.80482096 | - | - | - | D2 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP1 | 2IN IRON POST | IS | 1465303020000 | POLK ST | 3000 - 3099 POLK ST | 3000 - 3099 POLK ST | 3000 POLK ST | - | NORTH POINT ST | NORTH POINT ST |
| 24102 | N/A | Point | - | - | - | - | S226810 | CLAYTON ST: PARNASSUS AVE | - | F | F | - | F | 26401000 | 26401000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLAYTON ST | CLAYTON ST | 66394 | 66394 | 37.76513873 | -122.44763463 | PARNASSUS AVE \ CLAYTON ST | PARNASSUS AVE \ CLAYTON ST | 1710539427000 | MTA | ALL WAY | CLAYTON ST intersection | - | 0 / 0 | - | - | - | - | - | 41180 | 48988800000 | -122.44763463 | 37.76513873 | - | 1469059200000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | MUNI POLE | IS | 1466510460000 | PARNASSUS AVE | - | - | - | - | - | - |
| 24103 | N/A | Point | - | - | - | - | S226811 | CLAYTON ST: PARNASSUS AVE | - | F | F | - | F | 26401000 | 26401000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CLAYTON ST | CLAYTON ST | 66395 | 66395 | 37.76513873 | -122.44763463 | PARNASSUS AVE \ CLAYTON ST | PARNASSUS AVE \ CLAYTON ST | 1710539427000 | MTA | ALL WAY | CLAYTON ST intersection | - | 0 / 910 NPL | - | - | - | - | - | 41181 | 48988800000 | -122.44763463 | 37.76513873 | - | 1469145600000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1466510760000 | PARNASSUS AVE | - | - | - | - | - | - |
| 24104 | N/A | Point | - | - | - | - | S230032 | THE EMBARCADERO: GREEN ST | - | F | F | - | F | 12556202 | 34014000 | - | - | CENTER ISLAND, E LINE, NORTHBOUND | - | - | - | - | GREEN ST | GREEN ST | 66396 | 66396 | 37.80089648 | -122.39913024 | - | THE EMBARCADERO \ GREEN ST | 1727392196000 | middleware_editor | MUNI (E) EMBARCADERO | GREEN ST intersection | 14517 | WB PED TRAFFIC NORTH OF X WALK | - | - | - | - | - | 41182 | - | -122.39913024 | 37.80089648 | - | - | 1727362740000 | D3 | - | OTHER GUIDE | GUIDE | G-E(SF).0020 | 16X18 | SUP1 | 2IN FLANGE POST | RETD | 1476974040000 | THE EMBARCADERO | 600 - 1098 THE EMBARCADERO | - | - | - | BATTERY ST \ LOMBARD ST | - |
| 24105 | N/A | Point | - | - | - | - | S230033 | THE EMBARCADERO: GREEN ST | - | F | F | - | F | 12556202 | 34014000 | - | - | CENTER ISLAND, E LINE, NORTHBOUND | - | - | - | - | GREEN ST | GREEN ST | 66397 | 66397 | 37.80089648 | -122.39913024 | - | THE EMBARCADERO \ GREEN ST | 1724421224000 | middleware_editor | MUNI (E) EMBARCADERO | GREEN ST intersection | 14517 | EB PED TRAFFIC NORTH OF X WALK | - | - | - | - | - | 41183 | - | -122.39913024 | 37.80089648 | - | - | - | D3 | - | OTHER GUIDE | GUIDE | G-E(SF).0020 | 16X18 | SUP1 | GUARD RAIL | IS | 1476974640000 | THE EMBARCADERO | 600 - 1098 THE EMBARCADERO | - | - | - | BATTERY ST \ LOMBARD ST | - |
| 24106 | N/A | Point | 1 | 1 | 200 - 299 | - | S226916 | PNDG EDDY ST | 200-299 JONES ST | F | F | - | F | 7565000 | 7565000 | - | - | SOUTH SIDE | - | - | - | - | TURK ST | TURK ST | 66398 | 66398 | 37.78346833 | -122.41250351 | - | - | 1727917955000 | middleware_editor | POLICE VEHICLES ONLY | TURK ST to EDDY ST (200 - 299) | - | 130' WEST OF JONES | - | - | - | - | - | 41184 | 1248998400000 | -122.41250351 | 37.78346833 | - | 1471564800000 | - | D6 | - | OTHER REGULATORY | REG | R32(SF).0010 | 18X18 | SUP1 | 2IN IRON POST | IS | 1466690820000 | JONES ST | PNDG EDDY ST | 200 - 299 JONES ST | - | - | EDDY ST | EDDY ST |
| 24107 | N/A | Point | 1 | 1 | 200 - 299 | - | S226917 | PNDG EDDY ST | 200-299 JONES ST | F | F | - | F | 7565000 | 7565000 | - | - | SOUTH SIDE | - | - | - | - | TURK ST | TURK ST | 66399 | 66399 | 37.78346833 | -122.41250351 | - | - | 1727917984000 | middleware_editor | POLICE VEHICLES ONLY | TURK ST to EDDY ST (200 - 299) | - | EPL #339 | - | - | - | - | - | 41185 | 1248998400000 | -122.41250351 | 37.78346833 | - | 1468281600000 | - | D6 | - | OTHER REGULATORY | REG | R32(SF).0010 | 18X18 | SUP1 | LIGHT POLE | IS | 1466690880000 | JONES ST | PNDG EDDY ST | 200 - 299 JONES ST | - | - | EDDY ST | EDDY ST |
| 24108 | N/A | Point | 1 | - | - | - | S226918 | 300-399 EDDY ST | - | F | F | - | F | 5061000 | 5061000 | - | - | SOUTH SIDE | - | - | - | - | - | - | 66400 | 66400 | 37.78382818 | -122.41341843 | - | - | 1733182186000 | middleware_editor | POLICE VEHICLES ONLY | - | - | WPL #339 | - | - | - | - | - | 41186 | 1248998400000 | -122.41341843 | 37.78382818 | - | - | 1730108700000 | D6 | - | OTHER REGULATORY | REG | R32(SF).0010 | 18X18 | SUP1 | 2IN FLANGE POST | RETD | 1466690880000 | EDDY ST | 300-399 EDDY ST | EDDY ST | - | - | - | - |
| 24109 | N/A | Point | - | - | - | - | S231511 | CALIFORNIA ST: 22ND AVE | - | F | F | - | F | 27644000 | 27644000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 66401 | 66401 | 37.78402824 | -122.48179117 | 22ND AVE \ CALIFORNIA ST | 22ND AVE \ CALIFORNIA ST | 1718977541000 | middleware_editor | ALL WAY | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 41187 | 185414400000 | -122.48179117 | 37.78402824 | - | 1484784000000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481013960000 | 22ND AVE | - | - | - | - | - | - |
| 24110 | N/A | Point | - | - | - | - | S231512 | CALIFORNIA ST: 22ND AVE | - | F | F | - | F | 27644000 | 27644000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 66402 | 66402 | 37.78402824 | -122.48179117 | 22ND AVE \ CALIFORNIA ST | 22ND AVE \ CALIFORNIA ST | 1714611840000 | middleware_editor | ALL WAY | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 41188 | 185414400000 | -122.48179117 | 37.78402824 | - | 1484784000000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481014140000 | 22ND AVE | - | - | - | - | - | - |
| 24111 | N/A | Point | - | - | - | - | S231513 | 23RD AVE: CALIFORNIA ST | - | F | F | - | F | 27647000 | 27647000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 23RD AVE | CALIFORNIA ST | 66403 | 66403 | 37.78397927 | -122.48287005 | CALIFORNIA ST \ 23RD AVE | 23RD AVE \ CALIFORNIA ST | 1746224049000 | middleware_editor | ALL WAY | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 41189 | -385405200000 | -122.48287005 | 37.78397927 | - | 1746212580000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481014440000 | 23RD AVE | - | - | - | - | - | - |
| 24112 | N/A | Point | - | - | - | - | S231516 | DUBOCE AVE: BELCHER ST | - | T | T | - | F | 25892000 | 25892000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 66405 | 66405 | 37.76939226 | -122.43024736 | BELCHER ST \ DUBOCE AVE | BELCHER ST \ DUBOCE AVE | 1710539427000 | MTA | DO NOT DRIVE ON TRACKS | DUBOCE AVE intersection | - | - | - | - | - | - | - | 41190 | 1483601220000 | -122.43024736 | 37.76939226 | - | 1483574400000 | - | D8 | - | OTHER REGULATORY | REG | R15-6A(CA).0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1481017860000 | BELCHER ST | - | - | - | - | - | - |
| 24113 | N/A | Point | - | - | - | - | S231518 | DUBOCE AVE: FILLMORE ST | - | F | F | - | F | 25893000 | 25893000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 66406 | 66406 | 37.76940792 | -122.42990564 | FILLMORE ST \ DUBOCE AVE | FILLMORE ST \ DUBOCE AVE | 1710539427000 | MTA | SPEED LIMIT 10 WHEN BUS OR STREETCAR STOPPED AT SAFETY ZONE | DUBOCE AVE intersection | - | IFO#439 | - | - | - | - | - | 41191 | 807494400000 | -122.42990564 | 37.76940792 | - | - | - | D8 | - | SPEED LIMIT | REG | R(SF).0245 | 24X36 | SUP2 | MUNI POLE | IS | 1481018340000 | FILLMORE ST | - | - | - | - | - | - |
| 24114 | N/A | Point | - | - | - | - | S231519 | DUBOCE AVE: FILLMORE ST | - | T | T | - | F | 25893000 | 25893000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 66407 | 66407 | 37.76940792 | -122.42990564 | FILLMORE ST \ DUBOCE AVE | FILLMORE ST \ DUBOCE AVE | 1710539427000 | MTA | LEFT LANE BUSES TAXI ONLY AT ALL TIMES | DUBOCE AVE intersection | - | IFO#439 | - | - | - | - | - | 41192 | 807494400000 | -122.42990564 | 37.76940792 | - | 1483574400000 | - | D8 | - | TRANSIT ONLY(LEFT LANE) | REG | SR60-4(CA).0002 | 30X42 | SUP2 | MUNI POLE | IS | 1481018520000 | FILLMORE ST | - | - | - | - | - | - |
| 24115 | N/A | Point | - | - | - | - | S231520 | DUBOCE AVE: FILLMORE ST | - | T | T | - | F | 25893000 | 25893000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 66408 | 66408 | 37.76940792 | -122.42990564 | FILLMORE ST \ DUBOCE AVE | FILLMORE ST \ DUBOCE AVE | 1710539427000 | MTA | SPEED LIMIT 10 WHEN BUS OR STREETCAR STOPPED AT SAFETY ZONE | DUBOCE AVE intersection | - | ABOVE RA(SYM) | - | - | - | - | - | 41193 | 807494400000 | -122.42990564 | 37.76940792 | - | 1483574400000 | - | D8 | - | SPEED LIMIT | REG | R(SF).0245 | 24X36 | SUP2 | MUNI POLE | IS | 1481018820000 | FILLMORE ST | - | - | - | - | - | - |
| 24116 | N/A | Point | - | - | - | - | S231522 | DUBOCE AVE: FILLMORE ST | - | T | F | - | T | 25893000 | 25893000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 66409 | 66409 | 37.76940792 | -122.42990564 | FILLMORE ST \ DUBOCE AVE | FILLMORE ST \ DUBOCE AVE | 1756312808000 | middleware_editor | FG 300 UR DELINEATOR (W) | DUBOCE AVE intersection | - | CENTER LINE NORTH LINE OPP C-LINE | - | - | - | - | - | 41194 | 807519600000 | -122.42990564 | 37.76940792 | - | 1483603200000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1481019600000 | FILLMORE ST | - | - | - | - | - | - |
| 24117 | N/A | Point | - | - | - | - | S231523 | DUBOCE AVE: FILLMORE ST | - | T | F | - | T | 25893000 | 25893000 | - | - | CENTER ISLAND | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 66410 | 66410 | 37.76940792 | -122.42990564 | FILLMORE ST \ DUBOCE AVE | FILLMORE ST \ DUBOCE AVE | 1756312815000 | middleware_editor | FG 300 UR DELINEATOR (W) | DUBOCE AVE intersection | - | OPP C-LINE S-LINE | - | - | - | - | - | 41195 | 807519600000 | -122.42990564 | 37.76940792 | - | 1508828400000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1481019900000 | FILLMORE ST | - | - | - | - | - | - |
| 24118 | N/A | Point | - | - | - | - | S231593 | HAIGHT ST: LYON ST | - | T | T | - | F | 26323000 | 26323000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HAIGHT ST | HAIGHT ST | 66411 | 66411 | 37.77063764 | -122.44199776 | LYON ST \ HAIGHT ST | LYON ST \ HAIGHT ST | 1710539427000 | MTA | LYON ST | HAIGHT ST intersection | - | - | - | - | - | - | - | 41196 | 1147132800000 | -122.44199776 | 37.77063764 | - | - | - | D5 | - | STREET NAME | GUIDE | D3-2.0232 | 72X18 | SUP1 | LIGHT POLE | IS | 1481110260000 | LYON ST | - | - | - | - | - | - |
| 24119 | N/A | Point | - | - | - | - | S231594 | HAIGHT ST: LYON ST | - | T | T | - | F | 26323000 | 26323000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | HAIGHT ST | HAIGHT ST | 66412 | 66412 | 37.77063764 | -122.44199776 | LYON ST \ HAIGHT ST | LYON ST \ HAIGHT ST | 1710539427000 | MTA | LYON ST | HAIGHT ST intersection | - | 50' WEST OF LYON | - | - | - | - | - | 41197 | 1147132800000 | -122.44199776 | 37.77063764 | - | - | - | D5 | - | STREET NAME | GUIDE | D3-2.0232 | 72X18 | SUP1 | LIGHT POLE | IS | 1481110440000 | LYON ST | - | - | - | - | - | - |
| 24120 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S227956 | 1200-1299 DE HARO ST | 1200-1299 DE HARO ST | F | F | - | F | 4638000 | 4638000 | - | - | WEST SIDE | - | - | - | - | 23RD ST | 23RD ST | 67113 | 67113 | 37.75398264 | -122.40057119 | - | - | 1754593641000 | middleware_editor | NPRK 12NN-2PM MON STCL | 23RD ST to 24TH ST (1200 - 1299) | - | 52' SOUTH OF 23RD ST | - | - | - | - | - | 41198 | - | -122.40057119 | 37.75398264 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0078 | 18X18 | SUP1 | 2IN IRON POST | IS | 1470905640000 | DE HARO ST | 1200 - 1299 DE HARO ST | 1200 - 1299 DE HARO ST | 1200 DE HARO ST | - | 24TH ST | 24TH ST |
| 24121 | N/A | Point | - | - | - | - | S231426 | ROOSEVELT WAY: LOMA VISTA TER | - | F | F | - | F | 26207000 | 26207000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LOMA VISTA TER | ROOSEVELT WAY | 67123 | 67123 | 37.76455755 | -122.44321528 | ROOSEVELT WAY \ LOMA VISTA TER | LOMA VISTA TER \ ROOSEVELT WAY | 1731081256000 | middleware_editor | ALL WAY | ROOSEVELT WAY intersection | - | 0 / 0 | - | - | - | - | - | 41199 | 210297600000 | -122.44321528 | 37.76455755 | - | 1493164800000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1480593360000 | LOMA VISTA TER | - | - | - | - | - | - |
| 24122 | N/A | Point | - | - | - | - | S231433 | UPPER TER: MASONIC AVE | - | F | F | - | F | 26328000 | 26328000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | UPPER TER | UPPER TER | 67124 | 67124 | 37.76532273 | -122.44353831 | MASONIC AVE \ UPPER TER | MASONIC AVE \ UPPER TER | 1741013642000 | middleware_editor | ALL WAY | UPPER TER intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 41200 | 1489772580000 | -122.44353831 | 37.76532273 | - | 1489734000000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1480660980000 | MASONIC AVE | - | - | - | - | - | - |
| 24123 | N/A | Point | - | - | - | - | S231435 | MASONIC AVE: UPPER TER | - | F | F | - | F | 26328000 | 26328000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | UPPER TER | UPPER TER | 67125 | 67125 | 37.76532273 | -122.44353831 | MASONIC AVE \ UPPER TER | MASONIC AVE \ UPPER TER | 1741013635000 | middleware_editor | ALL WAY | UPPER TER intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 41201 | 1489771920000 | -122.44353831 | 37.76532273 | - | 1489734000000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1480661700000 | MASONIC AVE | - | - | - | - | - | - |
| 24124 | N/A | Point | 1 | 1 | 2050 - 2149 | LEFT ARROW | S227107 | 2100-2129 HARRISON ST | 2050-2149 HARRISON ST | F | F | - | F | 6746000 | 6746000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 67127 | 67127 | 37.76348205 | -122.41295072 | - | - | 1710539427000 | MTA | TANS EXC 30 MIN COMMERCIAL VEH 8AM-6PM MON-FRI | 17TH ST to MARIPOSA ST (2050 - 2149) | - | 63' SOUTH OF 17TH ST | - | - | - | - | - | 41202 | 1282176000000 | -122.41295072 | 37.76348205 | - | 1471564800000 | - | D9 | - | OTHER REGULATORY | REG | R37(SF).0185 | 10X15 | SUP2 | 2IN IRON POST | IS | 1467799740000 | HARRISON ST | 2050 - 2149 HARRISON ST | 2050 - 2149 HARRISON ST | 2050 HARRISON ST | - | MARIPOSA ST | MARIPOSA ST |
| 24125 | N/A | Point | 1 | 1 | 1 - 18 | - | S227109 | 1-18 10TH ST | 1-18 10TH ST | F | F | - | F | 480000 | 480000 | - | - | EAST SIDE | - | - | - | - | FELL ST \ MARKET ST \ POLK ST | FELL ST \ MARKET ST \ POLK ST | 67128 | 67128 | 37.77630834 | -122.41720866 | - | - | 1710539427000 | MTA | BIKE RACK | FELL ST \ MARKET ST \ POLK ST to STEVENSON ST (1 - 18) | 20154827 | 13' N OF SF FITNESS 3' APART | - | - | - | - | - | 41203 | 1470228540000 | -122.41720866 | 37.77630834 | - | 1470182400000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1467803820000 | 10TH ST | 1 - 18 10TH ST | 1 - 18 10TH ST | 1 10TH ST | - | STEVENSON ST | STEVENSON ST |
| 24126 | N/A | Point | 1 | 1 | 1 - 18 | - | S227110 | 1-18 10TH ST | 1-18 10TH ST | F | F | - | F | 480000 | 480000 | - | - | EAST SIDE | - | - | - | - | FELL ST \ MARKET ST \ POLK ST | FELL ST \ MARKET ST \ POLK ST | 67129 | 67129 | 37.77630834 | -122.41720866 | - | - | 1710539427000 | MTA | BIKE RACK | FELL ST \ MARKET ST \ POLK ST to STEVENSON ST (1 - 18) | 20154827 | 16' N OF SF FITNESS 3' APART | - | - | - | - | - | 41204 | 1470228660000 | -122.41720866 | 37.77630834 | - | 1470182400000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1467803940000 | 10TH ST | 1 - 18 10TH ST | 1 - 18 10TH ST | 1 10TH ST | - | STEVENSON ST | STEVENSON ST |
| 24127 | N/A | Point | 1 | 1 | 1 - 18 | - | S227111 | 1-18 10TH ST | 1-18 10TH ST | F | F | - | F | 480000 | 480000 | - | - | EAST SIDE | - | - | - | - | FELL ST \ MARKET ST \ POLK ST | FELL ST \ MARKET ST \ POLK ST | 67130 | 67130 | 37.77630834 | -122.41720866 | - | - | 1710539427000 | MTA | BIKE RACK | FELL ST \ MARKET ST \ POLK ST to STEVENSON ST (1 - 18) | 20154827 | 19' N OF SF FITNESS 3' APART | - | - | - | - | - | 41205 | 1470234480000 | -122.41720866 | 37.77630834 | - | 1470182400000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1467804060000 | 10TH ST | 1 - 18 10TH ST | 1 - 18 10TH ST | 1 10TH ST | - | STEVENSON ST | STEVENSON ST |
| 24128 | N/A | Point | - | - | - | - | S231151 | 18TH ST: DIAMOND ST | - | F | F | - | F | 25818000 | 25818000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DIAMOND ST | DIAMOND ST | 67152 | 67152 | 37.76075811 | -122.43719063 | 18TH ST \ DIAMOND ST | 18TH ST \ DIAMOND ST | 1734111416000 | middleware_editor | ALL WAY | DIAMOND ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 41206 | 164764800000 | -122.43719063 | 37.76075811 | - | 1488499200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1479460020000 | 18TH ST | - | - | - | - | - | - |
| 24129 | N/A | Point | - | - | - | - | S231152 | DIAMOND ST: 18TH ST | - | F | F | - | F | 25818000 | 25818000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DIAMOND ST | DIAMOND ST | 67153 | 67153 | 37.76075811 | -122.43719063 | 18TH ST \ DIAMOND ST | 18TH ST \ DIAMOND ST | 1710539427000 | MTA | ALL WAY | DIAMOND ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 41207 | 164764800000 | -122.43719063 | 37.76075811 | - | 1488499200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479460260000 | 18TH ST | - | - | - | - | - | - |
| 24130 | N/A | Point | 1 | 1 | 1600 - 1699 | LEFT ARROW | S229031 | 1600-1699 OAK ST | 1600-1699 OAK ST | F | F | - | F | 9766000 | 9766000 | - | - | SOUTH SIDE | - | - | - | - | MASONIC AVE | MASONIC AVE | 67154 | 67154 | 37.77197907 | -122.44651454 | - | - | 1710539427000 | MTA | TA (SYM) SCHOOL BUS ONLY 7:30AM-9AM/1PM-7PM SCHOOL DAYS | MASONIC AVE to ASHBURY ST (1600 - 1699) | - | WPL #1631 | - | - | - | - | - | 41208 | 1474552620000 | -122.44651454 | 37.77197907 | - | 1474502400000 | - | D5 | - | OTHER REGULATORY | REG | R38(SF)4.0013 | 14X21 | SUP1 | 2IN IRON POST | IS | 1474371060000 | OAK ST | 1600 - 1699 OAK ST | 1600 - 1699 OAK ST | 1600 OAK ST | - | ASHBURY ST | ASHBURY ST |
| 24131 | N/A | Point | 1 | 1 | 1600 - 1699 | DOWN ARROW | S229032 | 1600-1699 OAK ST | 1600-1699 OAK ST | F | F | - | F | 9766000 | 9766000 | - | - | SOUTH SIDE | - | - | - | - | MASONIC AVE | MASONIC AVE | 67155 | 67155 | 37.77197907 | -122.44651454 | - | - | 1710539427000 | MTA | TA (SYM) SCHOOL BUS ONLY 7:30AM-9AM/1PM-7PM SCHOOL DAYS | MASONIC AVE to ASHBURY ST (1600 - 1699) | - | IFO #1631 | - | - | - | - | - | 41209 | 1474554540000 | -122.44651454 | 37.77197907 | - | 1474502400000 | - | D5 | - | OTHER REGULATORY | REG | R38(SF)4.0013 | 14X21 | SUP1 | 2IN IRON POST | IS | 1474371180000 | OAK ST | 1600 - 1699 OAK ST | 1600 - 1699 OAK ST | 1600 OAK ST | - | ASHBURY ST | ASHBURY ST |
| 24132 | N/A | Point | 1 | 1 | 1900 - 1999 | LEFT ARROW | S229036 | 1900-1999 OFARRELL ST | 1900-1999 OFARRELL ST | F | F | - | F | 9739000 | 9739000 | - | - | NORTH SIDE | - | - | - | - | PIERCE ST | PIERCE ST | 67156 | 67156 | 37.78276548 | -122.43683091 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7AM-9AM/3PM-5:30PM SCH DAYS H/C (SYM) (5 MIN) | PIERCE ST to SCOTT ST (1900 - 1999) | - | OPP#1909 | - | - | - | - | - | 41210 | 1174003200000 | -122.43683091 | 37.78276548 | - | - | - | D5 | - | OTHER REGULATORY | REG | R38(SF)6.0036 | 14X21 | SUP1 | 2IN IRON POST | IS | 1474373460000 | OFARRELL ST | 1900 - 1999 OFARRELL ST | 1900 - 1999 OFARRELL ST | 1900 OFARRELL ST | - | SCOTT ST | SCOTT ST |
| 24133 | N/A | Point | - | - | - | - | S233538 | GIBB ST: COLUMBUS AVE \ ILS LN | - | F | F | - | F | 24782000 | 24782000 | - | - | SOUTH SIDE | - | - | - | - | COLUMBUS AVE \ GIBB ST | COLUMBUS AVE \ GIBB ST | 67796 | 67796 | 37.79606404 | -122.40406849 | ILS LN \ COLUMBUS AVE \ GIBB ST | ILS LN \ COLUMBUS AVE \ GIBB ST | 1710539427000 | MTA | NPRK ANY TIME | COLUMBUS AVE \ GIBB ST intersection | - | 10`WEST (X ST IS COLUMBUS) | - | - | - | - | - | 41211 | - | -122.40406849 | 37.79606404 | - | - | - | D3 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1486984080000 | ILS LN | - | - | - | - | - | - |
| 24134 | N/A | Point | 1 | 1 | 845 - 862 | LEFT ARROW | S233541 | 845-862 JACKSON ST | 845-862 JACKSON ST | F | F | - | F | 7382000 | 7382000 | - | - | SOUTH SIDE | - | - | - | - | TRENTON ST | TRENTON ST | 67797 | 67797 | 37.79570325 | -122.40920953 | - | - | 1710539427000 | MTA | TA (SYM) PLO AT ALL TIMES (5 MIN) | TRENTON ST to STONE ST (845 - 862) | - | 12`EAST OF STONE | - | - | - | - | - | 41212 | - | -122.40920953 | 37.79570325 | - | - | - | D3 | - | OTHER REGULATORY | REG | R38(SF)1.0001 | 14X21 | SUP1 | 2IN IRON POST | IS | 1486986720000 | JACKSON ST | 845 - 862 JACKSON ST | 845 - 862 JACKSON ST | 845 JACKSON ST | - | STONE ST | STONE ST |
| 24135 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S235514 | 2000-2099 22ND AVE | 2000-2099 22ND AVE | F | F | - | F | 1147000 | 1147000 | - | - | EAST SIDE | - | - | - | - | PACHECO ST | PACHECO ST | 67798 | 67798 | 37.74943604 | -122.47936076 | - | - | 1719434284000 | middleware_editor | BIKE RACK | PACHECO ST to QUINTARA ST (2000 - 2099) | 20165429 | 20' NORTH ON QUINTARA | - | - | - | - | - | 41213 | 1494861240000 | -122.47936076 | 37.74943604 | - | 1494806400000 | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1493024400000 | 22ND AVE | 2000 - 2099 22ND AVE | 2000 - 2099 22ND AVE | 2000 22ND AVE | - | QUINTARA ST | QUINTARA ST |
| 24136 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S235515 | 2000-2099 22ND AVE | 2000-2099 22ND AVE | F | F | - | F | 1147000 | 1147000 | - | - | EAST SIDE | - | - | - | - | PACHECO ST | PACHECO ST | 67799 | 67799 | 37.74943604 | -122.47936076 | - | - | 1719434281000 | middleware_editor | BIKE RACK | PACHECO ST to QUINTARA ST (2000 - 2099) | 20165429 | 27' NORTH ON QUINTARA | - | - | - | - | - | 41214 | 1494858780000 | -122.47936076 | 37.74943604 | - | 1494806400000 | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1493024460000 | 22ND AVE | 2000 - 2099 22ND AVE | 2000 - 2099 22ND AVE | 2000 22ND AVE | - | QUINTARA ST | QUINTARA ST |
| 24137 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S235516 | 2000-2099 22ND AVE | 2000-2099 22ND AVE | F | F | - | F | 1147000 | 1147000 | - | - | EAST SIDE | - | - | - | - | PACHECO ST | PACHECO ST | 67800 | 67800 | 37.74943604 | -122.47936076 | - | - | 1719450308000 | middleware_editor | BIKE RACK | PACHECO ST to QUINTARA ST (2000 - 2099) | 20165429 | 38' NORTH ON QUINTARA | - | - | - | - | - | 41215 | 1494861420000 | -122.47936076 | 37.74943604 | - | 1494806400000 | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1493024520000 | 22ND AVE | 2000 - 2099 22ND AVE | 2000 - 2099 22ND AVE | 2000 22ND AVE | - | QUINTARA ST | QUINTARA ST |
| 24138 | N/A | Point | - | - | - | - | S235530 | MONTEREY BLVD: EDNA ST | - | F | F | - | F | 22162000 | 22162000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | MONTEREY BLVD | EDNA ST | 67801 | 67801 | 37.73154905 | -122.4465784 | EDNA ST \ MONTEREY BLVD | MONTEREY BLVD \ EDNA ST | 1710539427000 | MTA | STOP | EDNA ST intersection | - | - | - | - | - | - | - | 41216 | 1576833600000 | -122.4465784 | 37.73154905 | - | 1684972800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1493032740000 | MONTEREY BLVD | - | - | - | - | - | - |
| 24139 | N/A | Point | - | - | - | - | S235532 | MONTEREY BLVD: EDNA ST | - | F | F | - | F | 22162000 | 22162000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MONTEREY BLVD | EDNA ST | 67802 | 67802 | 37.73154905 | -122.4465784 | EDNA ST \ MONTEREY BLVD | MONTEREY BLVD \ EDNA ST | 1710539427000 | MTA | STOP | EDNA ST intersection | - | - | - | - | - | - | - | 41217 | - | -122.4465784 | 37.73154905 | - | - | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1493032860000 | MONTEREY BLVD | - | - | - | - | - | - |
| 24140 | N/A | Point | - | - | - | - | S235534 | MONTEREY BLVD: EDNA ST | - | F | F | - | F | 22162000 | 22162000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MONTEREY BLVD | EDNA ST | 67803 | 67803 | 37.73154905 | -122.4465784 | EDNA ST \ MONTEREY BLVD | MONTEREY BLVD \ EDNA ST | 1710539427000 | MTA | ALL WAY | EDNA ST intersection | - | - | - | - | - | - | - | 41218 | 1494417840000 | -122.4465784 | 37.73154905 | - | 1494374400000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1493033580000 | MONTEREY BLVD | - | - | - | - | - | - |
| 24141 | N/A | Point | - | - | - | - | S229129 | MARKET ST: 6TH ST \ GOLDEN GAT | - | T | T | - | F | 24922000 | 24922000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 6TH ST \ GOLDEN GATE AVE \ MARKET ST | 06TH ST \ GOLDEN GATE AVE \ TAYLOR ST | 67804 | 67804 | 37.78223058 | -122.41029203 | TAYLOR ST \ 6TH ST \ GOLDEN GATE AVE \ MARKET ST | MARKET ST \ 06TH ST \ GOLDEN GATE AVE \ TAYLOR ST | 1742500611000 | middleware_editor | EXC MUNI | 06TH ST \ GOLDEN GATE AVE \ TAYLOR ST intersection | - | - | - | - | - | - | - | 41219 | -385488000000 | -122.41029203 | 37.78223058 | - | 1475823600000 | 1742500560000 | D6 | - | OTHER REGULATORY | REG | R(SF).0072 | 30X12 | SUP1 | OVERHEAD MAST ARM | RETD | 1474542960000 | MARKET ST | - | - | - | - | - | - |
| 24142 | N/A | Point | - | 1 | 1 - 99 | - | S227241 | 1-99 ELWOOD ST | 1-99 ELWOOD ST | F | F | - | F | 5222000 | 5222000 | - | - | SOUTH SIDE | - | - | - | - | MASON ST | MASON ST | 67806 | 67806 | 37.78655309 | -122.40946025 | - | - | 1710539427000 | MTA | TANP ANY TIME | MASON ST to OFARRELL ST (1 - 99) | - | 20' EAST OF MASON | - | - | - | - | - | 41220 | 1471516800000 | -122.40946025 | 37.78655309 | - | 1471478400000 | - | D3 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | 2IN IRON POST | IS | 1468408440000 | ELWOOD ST | 1 - 99 ELWOOD ST | 1 - 99 ELWOOD ST | 1 ELWOOD ST | - | OFARRELL ST | OFARRELL ST |
| 24143 | N/A | Point | 1 | 1 | 1210 - 1299 | RIGHT ARROW | S227764 | 1210-1299 17TH ST | 1210-1299 17TH ST | F | F | - | F | 774000 | 774000 | - | - | SOUTH SIDE | - | - | - | - | TEXAS ST | TEXAS ST | 67808 | 67808 | 37.76515956 | -122.39628883 | - | - | 1716324004000 | middleware_editor | TA (SYM) PLO 5PM-1AM DAILY (5 MIN) | TEXAS ST to MISSOURI ST (1210 - 1299) | - | EPL #1233 | - | - | - | - | - | 41221 | 1471619520000 | -122.39628883 | 37.76515956 | - | - | 1716298740000 | D10 | - | OTHER REGULATORY | REG | R38(SF)1.0074 | 14X21 | SUP1 | 2IN IRON POST | RETD | 1470386340000 | 17TH ST | 1210 - 1299 17TH ST | 1210 - 1299 17TH ST | 1210 17TH ST | - | MISSOURI ST | MISSOURI ST |
| 24144 | N/A | Point | 1 | 1 | 1210 - 1299 | LEFT ARROW | S227765 | 1210-1299 17TH ST | 1210-1299 17TH ST | F | F | - | F | 774000 | 774000 | - | - | SOUTH SIDE | - | - | - | - | TEXAS ST | TEXAS ST | 67809 | 67809 | 37.76515956 | -122.39628883 | - | - | 1716323913000 | middleware_editor | TA (SYM) PLO 5PM-1AM DAILY (5 MIN) | TEXAS ST to MISSOURI ST (1210 - 1299) | - | WPL #1233 | - | - | - | - | - | 41222 | 1471619400000 | -122.39628883 | 37.76515956 | - | - | 1716298620000 | D10 | - | OTHER REGULATORY | REG | R38(SF)1.0074 | 14X21 | SUP1 | 2IN IRON POST | RETD | 1470386400000 | 17TH ST | 1210 - 1299 17TH ST | 1210 - 1299 17TH ST | 1210 17TH ST | - | MISSOURI ST | MISSOURI ST |
| 24145 | N/A | Point | - | - | - | - | S227770 | 7TH ST: 16TH ST \ MISSISSIPPI | - | T | T | - | F | 23785000 | 23785000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 07TH ST \ MISSISSIPPI ST | 07TH ST \ MISSISSIPPI ST | 67810 | 67810 | 37.76654458 | -122.39506055 | 16TH ST \ 07TH ST \ MISSISSIPPI ST | 16TH ST \ 07TH ST \ MISSISSIPPI ST | 1710971030000 | elclark | AT MARKET | 07TH ST \ MISSISSIPPI ST intersection | - | 20' NORTH OF STEVENSON | - | - | - | - | - | 41223 | 1472169600000 | -122.39506055 | 37.76654458 | - | 1472169600000 | - | D10 | - | OTHER REGULATORY | REG | R(SF).0359 | 18X30 | SUP1 | LIGHT POLE | IS | 1470388860000 | 16TH ST | - | - | - | - | - | - |
| 24146 | N/A | Point | - | - | - | - | S232460 | BERKELEY WAY: CRAGS CT | - | F | F | - | F | 22284000 | 22284000 | - | - | NORTH WEST CORNER | - | - | - | - | BERKELEY WAY | BERKELEY WAY | 67904 | 67904 | 37.74035694 | -122.43952083 | CRAGS CT \ BERKELEY WAY | CRAGS CT \ BERKELEY WAY | 1710539427000 | MTA | CRAGS CT | BERKELEY WAY intersection | - | CRAGS CT.(END) | - | - | - | - | - | 41224 | 1503304560000 | -122.43952083 | 37.74035694 | - | 1503273600000 | - | D8 | - | STREET NAME | GUIDE | D3-1.0460 | 36X08 | SUP2 | 3IN IRON POST | IS | 1483980120000 | CRAGS CT | - | - | - | - | - | - |
| 24147 | N/A | Point | - | - | - | - | S233397 | DETROIT ST: JOOST AVE | - | F | F | - | F | 22157000 | 22157000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DETROIT ST | DETROIT ST | 67906 | 67906 | 37.7323469 | -122.44431435 | JOOST AVE \ DETROIT ST | JOOST AVE \ DETROIT ST | 1710539427000 | MTA | LOW GROUND CLEARANCE (SYM) | DETROIT ST intersection | - | ABOVE STOP SIGN | - | - | - | - | - | 41225 | 1487861580000 | -122.44431435 | 37.7323469 | - | 1672790400000 | - | D7 | - | OTHER WARNING | WARNING | W10-5.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1486547100000 | JOOST AVE | - | - | - | - | - | - |
| 24148 | N/A | Point | - | - | - | - | S233398 | DETROIT ST: JOOST AVE | - | F | F | - | F | 22157000 | 22157000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DETROIT ST | DETROIT ST | 67907 | 67907 | 37.7323469 | -122.44431435 | JOOST AVE \ DETROIT ST | JOOST AVE \ DETROIT ST | 1710539427000 | MTA | LOW GROUND CLEARANCE | DETROIT ST intersection | - | ABOVE STOP SIGN | - | - | - | - | - | 41226 | 1487861700000 | -122.44431435 | 37.7323469 | - | 1672790400000 | - | D7 | - | OTHER WARNING | WARNING | W10-5P.0001 | 24X18 | SUP2 | 2IN IRON POST | IS | 1486547160000 | JOOST AVE | - | - | - | - | - | - |
| 24149 | N/A | Point | - | - | - | - | S233399 | DETROIT ST: JOOST AVE | - | F | F | - | F | 22157000 | 22157000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DETROIT ST | DETROIT ST | 67908 | 67908 | 37.7323469 | -122.44431435 | JOOST AVE \ DETROIT ST | JOOST AVE \ DETROIT ST | 1710539427000 | MTA | LOW GROUND CLEARANCE (SYM) | DETROIT ST intersection | - | ABOVE STOP SIGN | - | - | - | - | - | 41227 | 1487861820000 | -122.44431435 | 37.7323469 | - | 1672790400000 | - | D7 | - | OTHER WARNING | WARNING | W10-5.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1486547580000 | JOOST AVE | - | - | - | - | - | - |
| 24150 | N/A | Point | - | - | - | - | S234315 | SUTTER ST: SCOTT ST | - | F | F | - | F | 26625000 | 26625000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SUTTER ST | SCOTT ST | 68452 | 68452 | 37.78545934 | -122.43820638 | SCOTT ST \ SUTTER ST | SUTTER ST \ SCOTT ST | 1754407894000 | middleware_editor | ALL WAY | SCOTT ST intersection | - | 0 / 00 | - | - | - | - | - | 41228 | 104745600000 | -122.43820638 | 37.78545934 | - | 1491202800000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | MUNI POLE | IS | 1489495440000 | SUTTER 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