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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17176 | N/A | Point | 1 | 1 | 1466 - 1499 | - | S244335 | 1466-1499 SHOTWELL ST | 1466-1499 SHOTWELL ST | F | F | - | F | 11848000 | 11848000 | - | - | WEST SIDE | - | - | - | - | AZTEC ST | AZTEC ST | 81223 | 81223 | 37.7452972 | -122.41494494 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "AA" PERMITS | AZTEC ST to STONEMAN ST (1466 - 1499) | - | NORTH LINE OF AZTEC ST | - | - | - | - | - | 34251 | 1527605760000 | -122.41494494 | 37.7452972 | - | - | - | D9 | - | PARKING:RPP | REG | R32C(CA).0239 | 18X21 | SUP2 | LIGHT POLE | IS | 1522741920000 | SHOTWELL ST | 1466 - 1499 SHOTWELL ST | 1466 - 1499 SHOTWELL ST | 1466 SHOTWELL ST | - | STONEMAN ST | STONEMAN ST |
| 17177 | N/A | Point | 1 | 1 | 1420 - 1471 | - | S244336 | 1420-1471 SHOTWELL ST | 1420-1471 SHOTWELL ST | F | F | - | F | 11847000 | 11847000 | - | - | EAST SIDE | - | - | - | - | MONTEZUMA ST | MONTEZUMA ST | 81224 | 81224 | 37.7457967 | -122.41499284 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "AA" PERMITS | MONTEZUMA ST to AZTEC ST (1420 - 1471) | - | SPL# 1459 | - | - | - | - | - | 34252 | 1527600900000 | -122.41499284 | 37.7457967 | - | - | - | D9 | - | PARKING:RPP | REG | R32C(CA).0239 | 18X21 | SUP2 | 2IN IRON POST | IS | 1522742160000 | SHOTWELL ST | 1420 - 1471 SHOTWELL ST | 1420 - 1471 SHOTWELL ST | 1420 SHOTWELL ST | - | AZTEC ST | AZTEC ST |
| 17178 | N/A | Point | 1 | 1 | 700 - 740 | - | S244286 | 700-740 DUBOCE AVE | 700-740 DUBOCE AVE | F | F | - | F | 4992000 | 4992000 | - | - | NORTH SIDE | - | - | - | - | SCOTT ST | SCOTT ST | 81228 | 81228 | 37.76908613 | -122.4353437 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM WED STCL | SCOTT ST to CASTRO ST (700 - 740) | - | 50FT. WEST OF SCOTT ST. | - | - | - | - | - | 34253 | 1523275980000 | -122.4353437 | 37.76908613 | - | 1523232000000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0312 | 18X18 | SUP2 | LIGHT POLE | IS | 1522424880000 | DUBOCE AVE | 700 - 740 DUBOCE AVE | 700 - 740 DUBOCE AVE | 700 DUBOCE AVE | - | CASTRO ST | CASTRO ST |
| 17179 | N/A | Point | 1 | 1 | 700 - 740 | - | S244287 | 700-740 DUBOCE AVE | 700-740 DUBOCE AVE | F | F | - | F | 4992000 | 4992000 | - | - | NORTH SIDE | - | - | - | - | SCOTT ST | SCOTT ST | 81229 | 81229 | 37.76908613 | -122.4353437 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | SCOTT ST to CASTRO ST (700 - 740) | - | 50FT. WEST OF SCOTT ST. | - | - | - | - | - | 34254 | 1523276700000 | -122.4353437 | 37.76908613 | - | 1523232000000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | LIGHT POLE | IS | 1522425060000 | DUBOCE AVE | 700 - 740 DUBOCE AVE | 700 - 740 DUBOCE AVE | 700 DUBOCE AVE | - | CASTRO ST | CASTRO ST |
| 17180 | N/A | Point | - | - | - | - | S250575 | VALENCIA ST: BROSNAN ST | - | F | F | - | F | 24382000 | 24382000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | BROSNAN ST | BROSNAN ST | 84242 | 84242 | 37.76875414 | -122.42225816 | VALENCIA ST \ BROSNAN ST | VALENCIA ST \ BROSNAN ST | 1721059493000 | middleware_editor | SCHOOL (SYM)/ 45 RIGHT DN ARROW (COMBO) | BROSNAN ST intersection | - | EAST SIDE C I BEFORE CROSSWALK BROSNAN | - | - | - | - | - | 34255 | 1334880000000 | -122.42225816 | 37.76875414 | - | 1546560000000 | - | D8 | - | SCHOOL | WARNING | SW24-2(CA).0002 | 30X42 | SUP2 | 2IN IRON POST | IS | 1546510080000 | VALENCIA ST | - | - | - | - | - | - |
| 17181 | N/A | Point | - | - | - | - | S250577 | VALENCIA ST: BROSNAN ST | - | F | F | - | F | 24382000 | 24382000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | BROSNAN ST | BROSNAN ST | 84243 | 84243 | 37.76875414 | -122.42225816 | VALENCIA ST \ BROSNAN ST | VALENCIA ST \ BROSNAN ST | 1721059426000 | middleware_editor | TA (SYM) PLO 8AM-9AM/2:30PM-6PM SCHOOL DAYS (5 MIN) | BROSNAN ST intersection | - | EAST SIDE NORTH TIP OF CENTER ISLAND | - | - | - | - | - | 34256 | 1334880000000 | -122.42225816 | 37.76875414 | - | 1546819200000 | - | D8 | - | OTHER REGULATORY | REG | R38(SF)6.0076 | 14X21 | SUP2 | 2IN IRON POST | IS | 1546510980000 | VALENCIA ST | - | - | - | - | - | - |
| 17182 | N/A | Point | - | - | - | RIGHT ARROW | S250578 | WAWONA ST: 21ST AVE | - | F | F | - | F | 23169000 | 23169000 | - | - | SOUTH EAST CORNER | - | - | - | - | WAWONA ST | 21ST AVE | 84244 | 84244 | 37.73736011 | -122.4774439 | 21ST AVE \ WAWONA ST | WAWONA ST \ 21ST AVE | 1754148012000 | middleware_editor | NPRK ANY TIME | 21ST AVE intersection | - | JUST EAST OF ENTRANCE GATE AT 21ST AVE | - | - | - | - | 1 | 34257 | - | -122.4774439 | 37.73736011 | - | 1748380380000 | - | D4 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP2 | 2IN IRON POST | IS | 1546511340000 | WAWONA ST | - | - | - | - | - | - |
| 17183 | N/A | Point | 1 | 1 | 900 - 999 | - | S250579 | 900-999 WAWONA ST | 900-999 WAWONA ST | F | F | - | F | 13476000 | 13476000 | - | - | NORTH SIDE | - | - | - | - | 20TH AVE | 20TH AVE | 84245 | 84245 | 37.73738373 | -122.47690608 | - | - | 1754065489000 | middleware_editor | BIKE (SYM) BIKE ROUTE | 20TH AVE to 21ST AVE (900 - 999) | 0341 | 40' EAST OF 21ST ST | - | - | - | - | - | 34258 | 1546968660000 | -122.47690608 | 37.73738373 | - | - | - | D4 | - | BIKE GUIDE | GUIDE | D11-1C.0002 | 24X18 | SUP2 | 2IN IRON POST | IS | 1546511700000 | WAWONA ST | 900 - 999 WAWONA ST | 900 - 999 WAWONA ST | 900 WAWONA ST | - | 21ST AVE | 21ST AVE |
| 17184 | N/A | Point | 1 | 1 | 1 - 31 | - | S244148 | 1-31 PROSPECT AVE | 1-31 PROSPECT AVE | F | F | - | F | 10784000 | 10784000 | - | - | EAST SIDE | - | - | - | - | COSO AVE | COSO AVE | 84246 | 84246 | 37.74524396 | -122.41754547 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "AA" PERMITS | COSO AVE to FAIR AVE (1 - 31) | - | SPL#3 PROSPECT AVE. | - | - | - | - | - | 34259 | 1527243600000 | -122.41754547 | 37.74524396 | - | - | - | D9 | - | PARKING:RPP | REG | R32C(CA).0239 | 18X21 | SUP2 | 2IN IRON POST | IS | 1522222680000 | PROSPECT AVE | 1 - 31 PROSPECT AVE | 1 - 31 PROSPECT AVE | 1 PROSPECT AVE | - | FAIR AVE | FAIR AVE |
| 17185 | N/A | Point | 1 | 1 | 200 - 299 | - | S244196 | 200-299 WESTGATE DR | 200-299 WESTGATE DR | T | T | - | F | 13585000 | 13585000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | UPLAND DR | UPLAND DR | 84247 | 84247 | 37.73044947 | -122.46452386 | - | - | 1717549392000 | middleware_editor | AHEAD | UPLAND DR to DARIEN WAY (200 - 299) | - | IFO 130 | - | - | - | - | - | 34260 | 1520812800000 | -122.46452386 | 37.73044947 | - | 1520812800000 | - | D7 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP2 | LIGHT POLE | IS | 1522318080000 | WESTGATE DR | 200 - 299 WESTGATE DR | 200 - 299 WESTGATE DR | 200 WESTGATE DR | - | DARIEN WAY | DARIEN WAY |
| 17186 | N/A | Point | 1 | 1 | 300 - 399 | - | S244201 | 300-399 WESTGATE DR | 300-399 WESTGATE DR | T | T | - | F | 13586000 | 13586000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | DARIEN WAY | DARIEN WAY | 84248 | 84248 | 37.73123689 | -122.46409541 | - | - | 1717549418000 | middleware_editor | AHEAD | DARIEN WAY to MONTEREY BLVD (300 - 399) | - | IFO 225 | - | - | - | - | - | 34261 | 1520844900000 | -122.46409541 | 37.73123689 | - | 1520812800000 | - | D7 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP2 | LIGHT POLE | IS | 1522318620000 | WESTGATE DR | 300 - 399 WESTGATE DR | 300 - 399 WESTGATE DR | 300 WESTGATE DR | - | MONTEREY BLVD | MONTEREY BLVD |
| 17187 | N/A | Point | 1 | 1 | 600 - 699 | - | S244202 | 600-699 DARIEN WAY | 600-699 DARIEN WAY | F | F | - | F | 4591000 | 4591000 | - | - | EAST SIDE | - | - | - | - | SAN ALESO AVE | SAN ALESO AVE | 84249 | 84249 | 37.73136806 | -122.46467422 | - | - | 1724116155000 | middleware_editor | AHEAD | SAN ALESO AVE to WESTGATE DR (600 - 699) | - | 53 FEET NORTH OF WESTGATE | - | - | - | - | - | 34262 | 1225324800000 | -122.46467422 | 37.73136806 | - | 1520812800000 | - | D7 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP2 | 2IN IRON POST | IS | 1522319160000 | DARIEN WAY | 600 - 699 DARIEN WAY | 600 - 699 DARIEN WAY | 600 DARIEN WAY | - | WESTGATE DR | WESTGATE DR |
| 17188 | N/A | Point | 1 | 1 | 300 - 348 | - | S244204 | 300-348 SAN BENITO WAY | 300-348 SAN BENITO WAY | T | T | - | F | 11344000 | 11344000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | DARIEN WAY | DARIEN WAY | 84250 | 84250 | 37.73113745 | -122.46699747 | - | - | 1744058762000 | middleware_editor | AHEAD | DARIEN WAY to UPLAND DR (300 - 348) | - | IFO 326 | - | - | - | - | - | 34263 | 1520870220000 | -122.46699747 | 37.73113745 | - | 1520838000000 | - | D7 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP2 | LIGHT POLE | IS | 1522319580000 | SAN BENITO WAY | 300 - 348 SAN BENITO WAY | 300 - 348 SAN BENITO WAY | 300 SAN BENITO WAY | - | UPLAND DR | UPLAND DR |
| 17189 | N/A | Point | 1 | 1 | 951 - 979 | - | S247837 | 951-979 CLAY ST | 951-979 CLAY ST | F | F | - | F | 4093000 | 4093000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | JOICE ST | JOICE ST | 84252 | 84252 | 37.79392638 | -122.4089559 | - | - | 1741025287000 | middleware_editor | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | JOICE ST to PARKHURST ALY (951 - 979) | 134498 | WPL #979 | - | - | - | - | - | 34264 | 1323158400000 | -122.4089559 | 37.79392638 | - | - | - | D3 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP1 | 2IN IRON POST | IS | 1534767360000 | CLAY ST | 951 - 979 CLAY ST | 951 - 979 CLAY ST | 951 CLAY ST | - | PARKHURST ALY | PARKHURST ALY |
| 17190 | N/A | Point | - | - | - | - | S247840 | CLAY ST: JOICE ST | - | F | F | - | F | 25009000 | 25009000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CLAY ST | CLAY ST | 84253 | 84253 | 37.79395635 | -122.40872036 | JOICE ST \ CLAY ST | JOICE ST \ CLAY ST | 1728003897000 | middleware_editor | SCHOOL (SYM)/ 45 LEFT DN ARROW (COMBO) | CLAY ST intersection | - | - | - | - | - | - | - | 34265 | 1534860660000 | -122.40872036 | 37.79395635 | - | 1628208000000 | - | D3 | - | SCHOOL | WARNING | SW24-2(CA).0001 | 30X42 | SUP1 | MUNI POLE | IS | 1534768260000 | JOICE ST | - | - | - | - | - | - |
| 17191 | N/A | Point | 1 | 1 | 205 - 299 | LEFT ARROW | S248974 | 205-299 6TH AVE | 205-299 06TH AVE | F | F | - | F | 315000 | 315000 | - | - | EAST SIDE | - | - | - | - | CORNWALL ST | CORNWALL ST | 84254 | 84254 | 37.78386591 | -122.4644882 | - | - | 1719968961000 | middleware_editor | OBSOLETE GUIDE SIGNS | CORNWALL ST to CLEMENT ST (205 - 299) | - | 13FT. NORTH OF CLEMENT ST | - | - | - | - | - | 34266 | - | -122.4644882 | 37.78386591 | - | - | - | D1 | - | OTHER GUIDE | GUIDE | G-O(SF).0003 | 36X30 | SUP2 | 2IN IRON POST | IS | 1539789360000 | 06TH AVE | 205 - 299 6TH AVE | 205 - 299 06TH AVE | 205 6TH AVE | - | CLEMENT ST | CLEMENT ST |
| 17192 | N/A | Point | - | - | - | - | S249500 | GOLDEN GATE AVE: MASONIC AVE | - | F | F | - | F | 26383000 | 26383000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GOLDEN GATE AVE | GOLDEN GATE AVE | 84526 | 84526 | 37.77766911 | -122.44684647 | MASONIC AVE \ GOLDEN GATE AVE | MASONIC AVE \ GOLDEN GATE AVE | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | GOLDEN GATE AVE intersection | - | 12FT EAST OF MASONIC | - | - | - | - | - | 34267 | 1541679960000 | -122.44684647 | 37.77766911 | - | - | - | D1 | - | NO RIGHT TURN | REG | R13A(CA).0002 | 24X30 | SUP2 | 2IN IRON POST | IS | 1541593260000 | MASONIC AVE | - | - | - | - | - | - |
| 17193 | N/A | Point | - | - | - | - | S104068 | DAVIS ST: BROADWAY | - | F | F | - | F | 24798000 | 24798000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DAVIS ST | BROADWAY | 2642 | 2642 | 37.79888097 | -122.3986957 | BROADWAY \ DAVIS ST | DAVIS ST \ BROADWAY | 1741973547000 | middleware_editor | STOP | BROADWAY intersection | - | - | - | - | - | - | - | 34268 | -56476800000 | -122.3986957 | 37.79888097 | - | 982310400000 | 1741973460000 | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | RETD | 1373568780000 | DAVIS ST | - | - | - | - | - | - |
| 17194 | N/A | Point | - | - | - | - | S107765 | 37TH AVE: KIRKHAM ST | - | F | F | - | F | 27730000 | 27730000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | KIRKHAM ST | 37TH AVE | 2645 | 2645 | 37.75898112 | -122.49615248 | 37TH AVE \ KIRKHAM ST | KIRKHAM ST \ 37TH AVE | 1741896937000 | middleware_editor | STOP | 37TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 34270 | 252835200000 | -122.49615248 | 37.75898112 | - | 1524466800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | KIRKHAM ST | - | - | - | - | - | - |
| 17195 | N/A | Point | - | - | - | - | S107767 | UNION ST: BAKER ST | - | F | F | - | F | 26890000 | 26890000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BAKER ST | UNION ST | 2647 | 2647 | 37.7958266 | -122.44541046 | UNION ST \ BAKER ST | BAKER ST \ UNION ST | 1710539427000 | MTA | STOP | UNION ST intersection | - | 0 / 0 | - | - | - | - | - | 34271 | 253152000000 | -122.44541046 | 37.7958266 | - | 1134432000000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | MUNI POLE | IS | 1373569980000 | BAKER ST | - | - | - | - | - | - |
| 17196 | N/A | Point | - | - | - | - | S107768 | UNION ST: BAKER ST | - | F | F | - | F | 26890000 | 26890000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BAKER ST | UNION ST | 2648 | 2648 | 37.7958266 | -122.44541046 | UNION ST \ BAKER ST | BAKER ST \ UNION ST | 1710539427000 | MTA | STOP | UNION ST intersection | - | 0 / 0 | - | - | - | - | - | 34272 | 253152000000 | -122.44541046 | 37.7958266 | - | 1502755200000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569980000 | BAKER ST | - | - | - | - | - | - |
| 17197 | N/A | Point | - | - | - | - | S107769 | VICENTE ST: 33RD AVE | - | F | F | - | F | 23349000 | 23349000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 33RD AVE | 33RD AVE | 2649 | 2649 | 37.73866262 | -122.49043223 | VICENTE ST \ 33RD AVE | VICENTE ST \ 33RD AVE | 1710539427000 | MTA | STOP | 33RD AVE intersection | - | 0 / 0 | - | - | - | - | - | 34273 | 253756800000 | -122.49043223 | 37.73866262 | - | 1512950400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | VICENTE ST | - | - | - | - | - | - |
| 17198 | N/A | Point | - | - | - | - | S107770 | VICENTE ST: 33RD AVE | - | F | F | - | F | 23349000 | 23349000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 33RD AVE | 33RD AVE | 2650 | 2650 | 37.73866262 | -122.49043223 | VICENTE ST \ 33RD AVE | VICENTE ST \ 33RD AVE | 1710539427000 | MTA | STOP | 33RD AVE intersection | - | 0 / 0 | - | - | - | - | - | 34274 | 253756800000 | -122.49043223 | 37.73866262 | - | 1496361600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | VICENTE ST | - | - | - | - | - | - |
| 17199 | N/A | Point | - | - | - | - | S105916 | BROADWAY: WEBSTER ST | - | F | F | - | F | 26655000 | 26655000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BROADWAY | BROADWAY | 2651 | 2651 | 37.79447411 | -122.43327423 | WEBSTER ST \ BROADWAY | WEBSTER ST \ BROADWAY | 1710539427000 | MTA | STOP | BROADWAY intersection | - | 0 / 0 | - | - | - | - | - | 34275 | 106531200000 | -122.43327423 | 37.79447411 | - | 1557705600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569380000 | WEBSTER ST | - | - | - | - | - | - |
| 17200 | N/A | Point | - | - | - | - | S105919 | LANE ST: UNDERWOOD AVE | - | F | F | - | F | 20506000 | 20506000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | UNDERWOOD AVE | LANE ST | 2653 | 2653 | 37.72978556 | -122.39185242 | LANE ST \ UNDERWOOD AVE | UNDERWOOD AVE \ LANE ST | 1710539427000 | MTA | STOP | LANE ST intersection | - | 0 / 0 | - | - | - | - | - | 34276 | 106876800000 | -122.39185242 | 37.72978556 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569380000 | UNDERWOOD AVE | - | - | - | - | - | - |
| 17201 | N/A | Point | - | - | - | - | S105920 | LANE ST: UNDERWOOD AVE | - | F | F | - | F | 20506000 | 20506000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | UNDERWOOD AVE | LANE ST | 2654 | 2654 | 37.72978556 | -122.39185242 | LANE ST \ UNDERWOOD AVE | UNDERWOOD AVE \ LANE ST | 1710539427000 | MTA | STOP | LANE ST intersection | - | 0 / 0 | - | - | - | - | - | 34277 | 106876800000 | -122.39185242 | 37.72978556 | - | 1200009600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569380000 | UNDERWOOD AVE | - | - | - | - | - | - |
| 17202 | N/A | Point | - | - | - | - | S105921 | 20TH ST: CHURCH ST | - | F | F | - | F | 25708000 | 25708000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CHURCH ST | CHURCH ST | 2655 | 2655 | 37.75808876 | -122.42805019 | 20TH ST \ CHURCH ST | 20TH ST \ CHURCH ST | 1745860264000 | middleware_editor | STOP | CHURCH ST intersection | - | 40E/MUNI STCAR TRACKS | - | - | - | - | - | 34278 | 107074800000 | -122.42805019 | 37.75808876 | - | 1745605500000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373569380000 | 20TH ST | - | - | - | - | - | - |
| 17203 | N/A | Point | - | - | - | - | S105922 | 20TH ST: CHURCH ST | - | F | F | - | F | 25708000 | 25708000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CHURCH ST | CHURCH ST | 2656 | 2656 | 37.75808876 | -122.42805019 | 20TH ST \ CHURCH ST | 20TH ST \ CHURCH ST | 1745337164000 | middleware_editor | STOP | CHURCH ST intersection | - | NEXT TO MUNI TRACKS | - | - | - | - | - | 34279 | 107074800000 | -122.42805019 | 37.75808876 | - | 1737057000000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569380000 | 20TH ST | - | - | - | - | - | - |
| 17204 | N/A | Point | - | - | - | - | S105925 | WALTER ST: DUBOCE AVE | - | F | F | - | F | 25985000 | 25985000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 2659 | 2659 | 37.76924965 | -122.43246434 | WALTER ST \ DUBOCE AVE | WALTER ST \ DUBOCE AVE | 1710539427000 | MTA | STOP | DUBOCE AVE intersection | - | - | - | - | - | - | - | 34280 | 107568000000 | -122.43246434 | 37.76924965 | - | 1675036800000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569380000 | WALTER ST | - | - | - | - | - | - |
| 17205 | N/A | Point | 1 | 1 | 3500 - 3549 | - | S105926 | 3500-3549 21ST ST | 3500-3549 21ST ST | F | F | - | F | 1118000 | 1118000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | DOLORES ST | DOLORES ST | 2660 | 2660 | 37.756596 | -122.4261997 | - | - | 1710539427000 | MTA | STOP | DOLORES ST to CHATTANOOGA ST (3500 - 3549) | - | 0 / WPL 3546 MUNI STCAR TRACKS | - | - | - | - | - | 34281 | 107654400000 | -122.4261997 | 37.756596 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373569380000 | 21ST ST | 3500 - 3549 21ST ST | 3500 - 3549 21ST ST | 3500 21ST ST | - | CHATTANOOGA ST | CHATTANOOGA ST |
| 17206 | N/A | Point | - | - | - | - | S105928 | LIBERTY ST: CHURCH ST | - | F | F | - | F | 25678000 | 25678000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LIBERTY ST | CHURCH ST | 2661 | 2661 | 37.75729224 | -122.4279696 | CHURCH ST \ LIBERTY ST | LIBERTY ST \ CHURCH ST | 1721955899000 | middleware_editor | STOP | CHURCH ST intersection | - | 0 / FOR STCAR TRACKS FRONT OF259 | - | - | - | - | - | 34282 | 107740800000 | -122.4279696 | 37.75729224 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569380000 | LIBERTY ST | - | - | - | - | - | - |
| 17207 | N/A | Point | - | - | - | - | S101481 | BEALE ST: HOWARD ST | - | F | F | - | F | 24506000 | 24506000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BEALE ST | BEALE ST | 2814 | 2814 | 37.78992623 | -122.39427623 | HOWARD ST \ BEALE ST | HOWARD ST \ BEALE ST | 1710539427000 | MTA | ONE WAY (RA) | BEALE ST intersection | - | 0 / 0 | - | - | - | - | - | 34283 | -397267200000 | -122.39427623 | 37.78992623 | - | 1577664000000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | SIGNAL POLE | IS | 1373566800000 | HOWARD ST | - | - | - | - | - | - |
| 17208 | N/A | Point | - | - | - | - | S107912 | GEARY ST: LARKIN ST | - | F | F | - | F | 25170000 | 25170000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GEARY ST | GEARY ST | 4964 | 4964 | 37.78610104 | -122.4180881 | LARKIN ST \ GEARY ST | LARKIN ST \ GEARY ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | GEARY ST intersection | - | 0 / 0 | - | - | - | - | - | 34284 | 263606400000 | -122.4180881 | 37.78610104 | - | - | - | D6 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | LIGHT POLE | IS | 1373570040000 | LARKIN ST | - | - | - | - | - | - |
| 17209 | N/A | Point | - | - | - | - | S107915 | LEAVENWORTH ST: OFARRELL ST | - | F | T | - | F | 25153000 | 25153000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LEAVENWORTH ST | OFARRELL ST | 4965 | 4965 | 37.78558248 | -122.41461721 | OFARRELL ST \ LEAVENWORTH ST | LEAVENWORTH ST \ OFARRELL ST | 1750961794000 | middleware_editor | NO LEFT TURN (SYM) | OFARRELL ST intersection | - | 0 / 0 | - | - | - | - | - | 34285 | 263718000000 | -122.41461721 | 37.78558248 | - | 1750961760000 | - | D6 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373570040000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 17210 | N/A | Point | - | - | - | - | S107918 | HYDE ST: MCALLISTER ST | - | F | T | - | F | 7114000 | 24333000 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | MCALLISTER ST | MCALLISTER ST | 4967 | 4967 | 37.7808691441687 | -122.415277125201 | - | HYDE ST \ MCALLISTER ST | 1755811372000 | middleware_editor | NO LEFT TURN (SYM) | MCALLISTER ST intersection | - | 15' N OF MCALLISTER | - | - | - | - | 1 | 34286 | 264063600000 | -122.41531562 | 37.78071918 | - | - | - | D6 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | MUNI POLE | IS | 1373570040000 | HYDE ST | 50 - 99 HYDE ST | - | - | - | GOLDEN GATE AVE | - |
| 17211 | N/A | Point | - | - | - | - | S107920 | HARRISON ST: 23RD ST | - | F | F | - | F | 23979000 | 23979000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 23RD ST | 23RD ST | 4968 | 4968 | 37.75423033 | -122.41204727 | HARRISON ST \ 23RD ST | HARRISON ST \ 23RD ST | 1742908810000 | middleware_editor | STOP | 23RD ST intersection | - | 0 / 0 | - | - | - | - | - | 34287 | 264409200000 | -122.41204727 | 37.75423033 | - | 636278400000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373570040000 | HARRISON ST | - | - | - | - | - | - |
| 17212 | N/A | Point | - | - | - | - | S102433 | GRANT AVE: LOMBARD ST | - | F | F | - | F | 25382000 | 25382000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LOMBARD ST | GRANT AVE | 4969 | 4969 | 37.80343258 | -122.40814597 | GRANT AVE \ LOMBARD ST | LOMBARD ST \ GRANT AVE | 1754338155000 | middleware_editor | ONE WAY (LA) | GRANT AVE intersection | - | - | - | - | - | - | - | 34288 | -388429200000 | -122.40814597 | 37.80343258 | - | 1754334900000 | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373568300000 | LOMBARD ST | - | - | - | - | - | - |
| 17213 | N/A | Point | - | - | - | - | S102434 | GRANT AVE: CHESTNUT ST | - | F | F | - | F | 25400000 | 25400000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GRANT AVE | CHESTNUT ST | 4970 | 4970 | 37.80436708 | -122.40833228 | CHESTNUT ST \ GRANT AVE | GRANT AVE \ CHESTNUT ST | 1754344880000 | middleware_editor | ONE WAY (LA) | CHESTNUT ST intersection | - | - | - | - | - | - | - | 34289 | -388429200000 | -122.40833228 | 37.80436708 | - | 1754339400000 | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373568300000 | GRANT AVE | - | - | - | - | - | - |
| 17214 | N/A | Point | - | - | - | - | S102435 | GRANT AVE: FRANCISCO ST | - | F | F | - | F | 25403000 | 25403000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FRANCISCO ST | FRANCISCO ST | 4971 | 4971 | 37.80529998 | -122.40852126 | GRANT AVE \ FRANCISCO ST | GRANT AVE \ FRANCISCO ST | 1754345056000 | middleware_editor | ONE WAY (LA) | FRANCISCO ST intersection | - | - | - | - | - | - | - | 34290 | -388429200000 | -122.40852126 | 37.80529998 | - | 1754343000000 | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373568300000 | GRANT AVE | - | - | - | - | - | - |
| 17215 | N/A | Point | - | - | - | - | S102437 | GRANT AVE: FILBERT ST | - | F | F | - | F | 25349000 | 25349000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GRANT AVE | GRANT AVE | 4973 | 4973 | 37.80157083 | -122.40776959 | FILBERT ST \ GRANT AVE | FILBERT ST \ GRANT AVE | 1754330441000 | middleware_editor | ONE WAY (RA) | GRANT AVE intersection | - | 0 / 0 | - | - | - | - | - | 34291 | -388429200000 | -122.40776959 | 37.80157083 | - | 1754324100000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568300000 | FILBERT ST | - | - | - | - | - | - |
| 17216 | N/A | Point | - | - | - | - | S102767 | SHAW ALY: MISSION ST | - | F | F | - | F | 24602000 | 24602000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MISSION ST | MISSION ST | 4974 | 4974 | 37.78898117 | -122.39856429 | SHAW ALY \ MISSION ST | SHAW ALY \ MISSION ST | 1710539427000 | MTA | ONE WAY (LA) | MISSION ST intersection | - | 0 / 0 | - | - | - | - | - | 34292 | -385776000000 | -122.39856429 | 37.78898117 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373568420000 | SHAW ALY | - | - | - | - | - | - |
| 17217 | N/A | Point | - | - | - | - | S102769 | 1ST ST: NATOMA ST | - | F | F | - | F | 24534000 | 24534000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 1ST ST | 01ST ST | 4976 | 4976 | 37.78896296 | -122.39657077 | NATOMA ST \ 1ST ST | NATOMA ST \ 01ST ST | 1710539427000 | MTA | ONE WAY (RA) | 01ST ST intersection | - | 0 / 0 | - | - | - | - | - | 34293 | -385776000000 | -122.39657077 | 37.78896296 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568420000 | NATOMA ST | - | - | - | - | - | - |
| 17218 | N/A | Point | - | - | - | - | S102770 | MARKET ST: 6TH ST \ GOLDEN GAT | - | F | F | - | F | 24922000 | 24922000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 6TH ST \ GOLDEN GATE AVE \ MARKET ST | 06TH ST \ GOLDEN GATE AVE \ TAYLOR ST | 4977 | 4977 | 37.78223058 | -122.41029203 | TAYLOR ST \ 6TH ST \ GOLDEN GATE AVE \ MARKET ST | MARKET ST \ 06TH ST \ GOLDEN GATE AVE \ TAYLOR ST | 1742499968000 | middleware_editor | NO LEFT TURN (SYM) | 06TH ST \ GOLDEN GATE AVE \ TAYLOR ST intersection | - | 0 / 000 | - | - | - | - | - | 34294 | -385488000000 | -122.41029203 | 37.78223058 | - | - | 1742499900000 | D6 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | UNKNOWN | RETD | 1373568420000 | MARKET ST | - | - | - | - | - | - |
| 17219 | N/A | Point | - | - | - | - | S101644 | AUSTIN ST: GOUGH ST | - | F | F | - | F | 26506000 | 26506000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | AUSTIN ST | GOUGH ST | 4978 | 4978 | 37.78853628 | -122.42533051 | GOUGH ST \ AUSTIN ST | AUSTIN ST \ GOUGH ST | 1721350829000 | middleware_editor | DO NOT ENTER | GOUGH ST intersection | - | 0 / 0 | - | - | - | - | - | 34295 | -395539200000 | -122.42533051 | 37.78853628 | - | - | - | D2 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373566860000 | AUSTIN ST | - | - | - | - | - | - |
| 17220 | N/A | Point | - | - | - | LEFT ARROW | S101645 | GOUGH ST: FERN ST | - | F | F | - | F | 26503000 | 26503000 | - | - | WEST SIDE | - | - | - | - | GOUGH ST | GOUGH ST | 4979 | 4979 | 37.78759653 | -122.42514096 | FERN ST \ GOUGH ST | FERN ST \ GOUGH ST | 1755644117000 | middleware_editor | ONE WAY (LA) | GOUGH ST intersection | - | W LINE / IFO 1505 | - | - | - | - | 1 | 34296 | -395514000000 | -122.42514096 | 37.78759653 | - | 1755637560000 | - | D2 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373566860000 | FERN ST | - | - | - | - | - | - |
| 17221 | N/A | Point | - | - | - | - | S101647 | FRANKLIN ST: AUSTIN ST | - | F | F | - | F | 26499000 | 26499000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | AUSTIN ST | 4980 | 4980 | 37.78874578 | -122.42368846 | AUSTIN ST \ FRANKLIN ST | FRANKLIN ST \ AUSTIN ST | 1710539427000 | MTA | ONE WAY (RA) | AUSTIN ST intersection | - | @ FRANKLIN | - | - | - | - | - | 34297 | -395539200000 | -122.42368846 | 37.78874578 | - | 1508889600000 | - | D2 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373566860000 | FRANKLIN ST | - | - | - | - | - | - |
| 17222 | N/A | Point | - | - | - | - | S101648 | EWING TER: MASONIC AVE | - | F | F | - | F | 26396000 | 26396000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MASONIC AVE | EWING TER | 4981 | 4981 | 37.78015206 | -122.44735193 | EWING TER \ MASONIC AVE | MASONIC AVE \ EWING TER | 1710539427000 | MTA | STOP | EWING TER intersection | - | 00 / 00 | - | - | - | - | - | 34298 | -395452800000 | -122.44735193 | 37.78015206 | - | 1213747200000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566860000 | MASONIC AVE | - | - | - | - | - | - |
| 17223 | N/A | Point | - | - | - | - | S101651 | SCOTT ST: POST ST | - | F | F | - | F | 26622000 | 26622000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POST ST | SCOTT ST | 4984 | 4984 | 37.78453092 | -122.43801967 | SCOTT ST \ POST ST | POST ST \ SCOTT ST | 1710539427000 | MTA | STOP | SCOTT ST intersection | - | 0 / 0 | - | - | - | - | - | 34299 | -395452800000 | -122.43801967 | 37.78453092 | - | - | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566860000 | POST ST | - | - | - | - | - | - |
| 17224 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S101762 | 1700-1799 OAK ST | 1700-1799 OAK ST | F | F | - | F | 9767000 | 9767000 | - | - | UNKNOWN | - | - | - | - | ASHBURY ST | ASHBURY ST | 4985 | 4985 | 37.77177324 | -122.44813521 | - | - | 1710539427000 | MTA | ONE WAY (RA) | ASHBURY ST to CLAYTON ST (1700 - 1799) | - | N LINE / 0 | - | - | - | - | - | 34300 | -395107200000 | -122.44813521 | 37.77177324 | - | - | - | D5 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373566860000 | OAK ST | 1700 - 1799 OAK ST | 1700 - 1799 OAK ST | 1700 OAK ST | - | CLAYTON ST | CLAYTON ST |
| 17225 | N/A | Point | - | - | - | - | S102935 | 22ND AVE: SANTIAGO ST | - | F | F | - | F | 23201000 | 23201000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 22ND AVE | SANTIAGO ST | 7267 | 7267 | 37.744671967 | -122.478969209 | SANTIAGO ST \ 22ND AVE | 22ND AVE \ SANTIAGO ST | 1735659373000 | middleware_editor | STOP | SANTIAGO ST intersection | - | 0 / 00 | - | - | - | - | - | 34301 | -358214400000 | -122.4790353 | 37.74477547 | - | 1467244800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568480000 | 22ND AVE | - | - | - | - | - | - |
| 17226 | N/A | Point | - | - | - | - | S102936 | HARRISON ST: 3RD ST | - | F | F | - | F | 24513000 | 24513000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 3RD ST | 03RD ST | 7268 | 7268 | 37.78255359 | -122.39738554 | HARRISON ST \ 3RD ST | HARRISON ST \ 03RD ST | 1710539427000 | MTA | ONE WAY (LA) | 03RD ST intersection | - | 0 / 00 | - | - | - | - | - | 34302 | -356745600000 | -122.39738554 | 37.78255359 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373568480000 | HARRISON ST | - | - | - | - | - | - |
| 17227 | N/A | Point | - | - | - | - | S102959 | 19TH AVE: QUINTARA ST | - | F | F | - | F | 23204000 | 23204000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 19TH AVE | 19TH AVE | 7269 | 7269 | 37.74864751 | -122.4760331 | QUINTARA ST \ 19TH AVE | QUINTARA ST \ 19TH AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) | 19TH AVE intersection | - | N LINE / 00 | - | - | - | - | - | 34303 | -356227200000 | -122.4760331 | 37.74864751 | - | - | - | D4 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568480000 | QUINTARA ST | - | - | - | - | - | - |
| 17228 | N/A | Point | - | - | - | - | S102960 | 19TH AVE: QUINTARA ST | - | F | F | - | F | 23204000 | 23204000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 19TH AVE | 19TH AVE | 7270 | 7270 | 37.74864751 | -122.4760331 | QUINTARA ST \ 19TH AVE | QUINTARA ST \ 19TH AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) | 19TH AVE intersection | - | S LINE / 00 | - | - | - | - | - | 34304 | -356227200000 | -122.4760331 | 37.74864751 | - | - | - | D4 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568480000 | QUINTARA ST | - | - | - | - | - | - |
| 17229 | N/A | Point | - | - | - | - | S102858 | GROVE ST: MASONIC AVE | - | F | F | - | F | 26377000 | 26377000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GROVE ST | GROVE ST | 7272 | 7272 | 37.7748711 | -122.44628367 | MASONIC AVE \ GROVE ST | MASONIC AVE \ GROVE ST | 1710539427000 | MTA | STOP | GROVE ST intersection | - | 0 / 0 | - | - | - | - | - | 34305 | -378172800000 | -122.44628367 | 37.7748711 | - | - | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568420000 | MASONIC AVE | - | - | - | - | - | - |
| 17230 | N/A | Point | - | - | - | - | S102978 | CAPITOL AVE: GRAFTON AVE | - | F | F | - | F | 22582000 | 22582000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GRAFTON AVE | GRAFTON AVE | 7274 | 7274 | 37.72002413 | -122.45919844 | CAPITOL AVE \ GRAFTON AVE | CAPITOL AVE \ GRAFTON AVE | 1718327290000 | middleware_editor | STOP | GRAFTON AVE intersection | - | 0 / 0 | - | - | - | - | - | 34306 | -355622400000 | -122.45919844 | 37.72002413 | - | 1440028800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568480000 | CAPITOL AVE | - | - | - | - | - | - |
| 17231 | N/A | Point | - | - | - | - | S109945 | 42ND AVE: QUINTARA ST | - | F | F | - | F | 23482000 | 23482000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 42ND AVE | QUINTARA ST | 7275 | 7275 | 37.7475572 | -122.5007262 | QUINTARA ST \ 42ND AVE | 42ND AVE \ QUINTARA ST | 1710539427000 | MTA | STOP | QUINTARA ST intersection | - | - | - | - | - | - | - | 34307 | 573350400000 | -122.5007262 | 37.7475572 | - | 1490572800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570640000 | 42ND AVE | - | - | - | - | - | - |
| 17232 | N/A | Point | - | - | - | - | S109946 | 24TH AVE: ULLOA ST | - | F | F | - | F | 23233000 | 23233000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 24TH AVE | 24TH AVE | 7276 | 7276 | 37.7410312716046 | -122.48101741075 | ULLOA ST \ 24TH AVE | ULLOA ST \ 24TH AVE | 1738426767000 | middleware_editor | STOP | 24TH AVE intersection | - | - | - | - | - | - | - | 34308 | 573350400000 | -122.48091787 | 37.74094773 | - | 1465171200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570640000 | ULLOA ST | - | - | - | - | - | - |
| 17233 | N/A | Point | - | - | - | - | S109947 | 24TH AVE: ULLOA ST | - | F | F | - | F | 23233000 | 23233000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH AVE | 24TH AVE | 7277 | 7277 | 37.740867950442 | -122.480844408269 | ULLOA ST \ 24TH AVE | ULLOA ST \ 24TH AVE | 1740089161000 | middleware_editor | STOP | 24TH AVE intersection | - | - | - | - | - | - | - | 34309 | 573350400000 | -122.48091787 | 37.74094773 | - | 1465171200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570640000 | ULLOA ST | - | - | - | - | - | - |
| 17234 | N/A | Point | - | - | - | - | S109948 | 25TH AVE: ULLOA ST | - | F | F | - | F | 23239000 | 23239000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 25TH AVE | 25TH AVE | 7278 | 7278 | 37.7409001 | -122.48198944 | ULLOA ST \ 25TH AVE | ULLOA ST \ 25TH AVE | 1726752279000 | middleware_editor | STOP | 25TH AVE intersection | - | - | - | - | - | - | - | 34310 | 573350400000 | -122.48198944 | 37.7409001 | - | 1464912000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570640000 | ULLOA ST | - | - | - | - | - | - |
| 17235 | N/A | Point | - | - | - | - | S109949 | 25TH AVE: ULLOA ST | - | F | F | - | F | 23239000 | 23239000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 25TH AVE | 25TH AVE | 7279 | 7279 | 37.7409001 | -122.48198944 | ULLOA ST \ 25TH AVE | ULLOA ST \ 25TH AVE | 1726752286000 | middleware_editor | STOP | 25TH AVE intersection | - | 3 FEET S OF UP | - | - | - | - | - | 34311 | 573350400000 | -122.48198944 | 37.7409001 | - | 1726664460000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570640000 | ULLOA ST | - | - | - | - | - | - |
| 17236 | N/A | Point | - | - | - | - | S109950 | WHIPPLE AVE: HURON AVE | - | F | F | - | F | 21542000 | 21542000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WHIPPLE AVE | WHIPPLE AVE | 7280 | 7280 | 37.71218225 | -122.44941576 | HURON AVE \ WHIPPLE AVE | HURON AVE \ WHIPPLE AVE | 1710539427000 | MTA | STOP | WHIPPLE AVE intersection | - | 0 / 0 | - | - | - | - | - | 34312 | 574905600000 | -122.44941576 | 37.71218225 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570640000 | HURON AVE | - | - | - | - | - | - |
| 17237 | N/A | Point | - | - | - | - | S109951 | WHIPPLE AVE: HURON AVE | - | F | F | - | F | 21542000 | 21542000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WHIPPLE AVE | WHIPPLE AVE | 7281 | 7281 | 37.71218225 | -122.44941576 | HURON AVE \ WHIPPLE AVE | HURON AVE \ WHIPPLE AVE | 1710539427000 | MTA | STOP | WHIPPLE AVE intersection | - | 0 / 0 | - | - | - | - | - | 34313 | 574905600000 | -122.44941576 | 37.71218225 | - | 1462320000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570640000 | HURON AVE | - | - | - | - | - | - |
| 17238 | N/A | Point | - | - | - | - | S110555 | 1301-1368 PORTOLA DR | - | F | F | - | F | 10620040 | - | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | - | - | 7284 | 7284 | 37.73980205 | -122.464052 | - | - | 1710539427000 | MTA | ONE WAY (RA) | - | - | C LINE | - | - | - | - | - | 34314 | 658713600000 | -122.464052 | 37.73980205 | - | - | - | D7 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | LIGHT POLE | IS | 1373570820000 | - | 1301-1368 PORTOLA DR | - | - | - | - | - |
| 17239 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S109502 | 1300-1399 BUSH ST | 1300-1399 BUSH ST | F | F | - | F | 3443000 | 3443000 | - | - | NORTH SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LARKIN ST | LARKIN ST | 7288 | 7288 | 37.78880433 | -122.41948138 | - | - | 1710539427000 | MTA | STOP | LARKIN ST to POLK ST (1300 - 1399) | - | 0 / 1330 WPL/15W AND THEN 36WOF | - | - | - | - | - | 34315 | 501465600000 | -122.41948138 | 37.78880433 | - | - | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570520000 | BUSH ST | 1300 - 1399 BUSH ST | 1300 - 1399 BUSH ST | 1300 BUSH ST | - | POLK ST | POLK ST |
| 17240 | N/A | Point | 1 | 1 | 3500 - 3599 | - | S109506 | 3500-3599 LAGUNA ST | 3500-3599 LAGUNA ST | F | F | - | F | 26754000 | 7986000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | LAGUNA ST | BAY ST | 7290 | 7290 | 37.80375567 | -122.43177679 | BAY ST \ LAGUNA ST | - | 1724257139000 | middleware_editor | DO NOT ENTER | BAY ST to NORTH POINT ST (3500 - 3599) | - | N LINE / ON ISLAND AT NE COR/REM EX..... | - | - | - | - | - | 34316 | 503020800000 | -122.43177679 | 37.80375567 | - | - | - | D2 | - | OTHER REGULATORY | REG | R5-1.0002 | 24X24 | SUP1 | SIGNAL POLE | IS | 1373570520000 | LAGUNA ST | - | 3500 - 3599 LAGUNA ST | 3500 LAGUNA ST | - | - | NORTH POINT ST |
| 17241 | N/A | Point | - | - | - | - | S109142 | POWELL ST: SACRAMENTO ST | - | F | F | - | F | 25013000 | 25013000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | SACRAMENTO ST | 7291 | 7291 | 37.79297077 | -122.40936129 | POWELL ST \ SACRAMENTO ST | POWELL ST \ SACRAMENTO ST | 1729126944000 | middleware_editor | DO NOT ENTER | SACRAMENTO ST intersection | - | - | - | - | - | - | - | 34317 | 405043200000 | -122.40936129 | 37.79297077 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1373570400000 | POWELL ST | - | - | - | - | - | - |
| 17242 | N/A | Point | 1 | 1 | 2800 - 2899 | - | S122662 | 2800-2899 OCTAVIA ST | 2800-2899 OCTAVIA ST | F | F | - | F | 9900000 | 9900000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | UNION ST | UNION ST | 14265 | 14265 | 37.79839147 | -122.42900811 | - | - | 1710539427000 | MTA | NO TRUCKS (SYM) OVER 3 TONS | UNION ST to FILBERT ST (2800 - 2899) | - | 20FT.SO OF UNION | - | - | - | - | - | 34318 | 1139270400000 | -122.42900811 | 37.79839147 | - | - | - | D2 | - | OTHER REGULATORY | REG | R5-2.0005 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373574660000 | OCTAVIA ST | 2800 - 2899 OCTAVIA ST | 2800 - 2899 OCTAVIA ST | 2800 OCTAVIA ST | - | FILBERT ST | FILBERT ST |
| 17243 | N/A | Point | - | - | - | - | S122663 | FOERSTER ST: MANGELS AVE | - | F | F | - | F | 22349000 | 22349000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MANGELS AVE | FOERSTER ST | 14266 | 14266 | 37.7331148181901 | -122.448962330813 | FOERSTER ST \ MANGELS AVE | MANGELS AVE \ FOERSTER ST | 1745956451000 | elclark | PEDESTRIAN (SYM) XING/(45 LA-DN) | FOERSTER ST intersection | - | - | - | - | - | - | - | 34319 | 1139299200000 | -122.44887339 | 37.73306872 | - | - | - | D7 | - | PEDESTRIAN(LA DN) | WARNING | W11-2+SW44(CA).01 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373574660000 | MANGELS AVE | - | - | - | - | - | - |
| 17244 | N/A | Point | 1 | 1 | 600 - 699 | - | S122665 | 600-699 SAN BRUNO AVE | 600-699 SAN BRUNO AVE | F | F | - | F | 11356000 | 11356000 | - | - | EAST SIDE | - | - | - | - | 18TH ST | 18TH ST | 14267 | 14267 | 37.76142323 | -122.40515856 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | 18TH ST to 19TH ST (600 - 699) | - | 100'N OF 19TH ST | - | - | - | - | - | 34320 | 1139356800000 | -122.40515856 | 37.76142323 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373574660000 | SAN BRUNO AVE | 600 - 699 SAN BRUNO AVE | 600 - 699 SAN BRUNO AVE | 600 SAN BRUNO AVE | - | 19TH ST | 19TH ST |
| 17245 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S119681 | 1800-1899 19TH ST | 1800-1899 19TH ST | F | F | - | F | 951000 | 951000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | CAROLINA ST | CAROLINA ST | 14268 | 14268 | 37.76103985 | -122.4007333 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | CAROLINA ST to DE HARO ST (1800 - 1899) | 096154 | WPL# 1833 | - | - | - | - | - | 34321 | 1099440000000 | -122.4007333 | 37.76103985 | - | 1624406400000 | - | D10 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP1 | 2IN IRON POST | IS | 1373573700000 | 19TH ST | 1800 - 1899 19TH ST | 1800 - 1899 19TH ST | 1800 19TH ST | - | DE HARO ST | DE HARO ST |
| 17246 | N/A | Point | 1 | 1 | 2201 - 2299 | - | S122049 | 2201-2299 FULTON ST | 2201-2299 FULTON ST | F | F | - | F | 26470000 | 5903000 | - | - | SOUTH SIDE | - | - | - | - | SHRADER ST | SHRADER ST | 14269 | 14269 | 37.77486312 | -122.45384299 | FULTON ST \ SHRADER ST | - | 1721158383000 | middleware_editor | NPPZ 8AM-6PM MON-FRI | SHRADER ST to STANYAN ST (2201 - 2299) | - | 2' W OF SHRADER | - | - | - | - | - | 34322 | 1132617600000 | -122.45384299 | 37.77486312 | - | - | 1721124960000 | D1 | - | OTHER REGULATORY | REG | R30(SF).0398 | 12X18 | SUP2 | SIGNAL POLE | RETD | 1373574480000 | FULTON ST | - | 2201 - 2299 FULTON ST | 2201 FULTON ST | - | - | STANYAN ST |
| 17247 | N/A | Point | 1 | 1 | 100 - 199 | - | S122053 | 100-199 OFARRELL ST | 100-199 OFARRELL ST | F | F | - | F | 9722000 | 9722000 | - | - | NORTH SIDE | - | - | - | - | STOCKTON ST | STOCKTON ST | 14271 | 14271 | 37.78651248 | -122.40721756 | - | - | 1710539427000 | MTA | TANS 7AM-8PM EVERYDAY | STOCKTON ST to POWELL ST (100 - 199) | - | 25' WEST | - | - | - | - | - | 34323 | 1132704000000 | -122.40721756 | 37.78651248 | - | - | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0059 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1373574480000 | OFARRELL ST | 100 - 199 OFARRELL ST | 100 - 199 OFARRELL ST | 100 OFARRELL ST | - | POWELL ST | POWELL ST |
| 17248 | N/A | Point | 1 | 1 | 100 - 199 | - | S122054 | 100-199 OFARRELL ST | 100-199 OFARRELL ST | F | F | - | F | 9722000 | 9722000 | - | - | NORTH SIDE | - | - | - | - | STOCKTON ST | STOCKTON ST | 14272 | 14272 | 37.78651248 | -122.40721756 | - | - | 1710539427000 | MTA | TANS 7AM-8PM EVERYDAY | STOCKTON ST to POWELL ST (100 - 199) | - | OPP EPL # 121 | - | - | - | - | - | 34324 | 1132704000000 | -122.40721756 | 37.78651248 | - | - | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0059 | 18X21 | SUP1 | LIGHT POLE | IS | 1373574480000 | OFARRELL ST | 100 - 199 OFARRELL ST | 100 - 199 OFARRELL ST | 100 OFARRELL ST | - | POWELL ST | POWELL ST |
| 17249 | N/A | Point | - | - | - | - | S122055 | FREDERICK ST: WILLARD ST | - | F | F | - | F | 26431000 | 26431000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FREDERICK ST | WILLARD ST | 14273 | 14273 | 37.7662438187634 | -122.454499461945 | WILLARD ST \ FREDERICK ST | FREDERICK ST \ WILLARD ST | 1732651762000 | middleware_editor | STOP | WILLARD ST intersection | - | - | - | - | - | - | - | 34325 | 1133136000000 | -122.45459292 | 37.76616547 | - | 1597017600000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373574480000 | FREDERICK ST | - | - | - | - | - | - |
| 17250 | N/A | Point | - | - | - | - | S122056 | FREDERICK ST: WILLARD ST | - | F | F | - | F | 26431000 | 26431000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FREDERICK ST | WILLARD ST | 14274 | 14274 | 37.7660893756343 | -122.454658672208 | WILLARD ST \ FREDERICK ST | FREDERICK ST \ WILLARD ST | 1732651822000 | middleware_editor | STOP | WILLARD ST intersection | - | - | - | - | - | - | - | 34326 | 1133136000000 | -122.45459292 | 37.76616547 | - | 1597017600000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373574480000 | FREDERICK 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