Import ISO
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 103126 | N/A | Point | 1 | 1 | 500 - 544 | - | S276147 | 500-544 BROADWAY | 500-544 BROADWAY | F | F | - | F | 3151000 | 3151000 | - | - | NORTH SIDE | - | - | - | - | KEARNY ST | KEARNY ST | 123549 | 123549 | 37.79796862 | -122.40585223 | - | - | 1710539427000 | MTA | BIKE RACK | KEARNY ST to ROMOLO ST (500 - 544) | 378851 | 20' E OF WPL 506/ 3.5' IN FROM CURB | - | - | - | - | - | 120417 | 1626689220000 | -122.40585223 | 37.79796862 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1626176640000 | BROADWAY | 500 - 544 BROADWAY | 500 - 544 BROADWAY | 500 BROADWAY | - | ROMOLO ST | ROMOLO ST |
| 103127 | N/A | Point | 1 | 1 | 500 - 544 | - | S276152 | 500-544 BROADWAY | 500-544 BROADWAY | F | F | - | F | - | 3151000 | - | - | SOUTH SIDE | - | - | - | - | - | KEARNY ST | 123551 | 123551 | 37.79796862 | -122.40585223 | - | - | 1710539427000 | MTA | BIKE RACK | KEARNY ST to ROMOLO ST (500 - 544) | 378851 | 47' E OF WPL 527/ 3' IN FROM CURB | - | - | - | - | - | 120418 | 1626697080000 | -122.40585223 | 37.79796862 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1626177900000 | BROADWAY | - | 500 - 544 BROADWAY | 500 BROADWAY | - | - | ROMOLO ST |
| 103128 | N/A | Point | 1 | 1 | 500 - 544 | - | S276151 | 500-544 BROADWAY | 500-544 BROADWAY | F | F | - | F | 3151000 | 3151000 | - | - | SOUTH SIDE | - | - | - | - | KEARNY ST | KEARNY ST | 123550 | 123550 | 37.79796862 | -122.40585223 | - | - | 1728682929000 | middleware_editor | BIKE RACK | KEARNY ST to ROMOLO ST (500 - 544) | 378851 | 5' E OF WPL 527/ 3' IN FROM CURB | - | - | - | - | - | 120419 | 1626697140000 | -122.40585223 | 37.79796862 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1626177840000 | BROADWAY | 500 - 544 BROADWAY | 500 - 544 BROADWAY | 500 BROADWAY | - | ROMOLO ST | ROMOLO ST |
| 103129 | N/A | Point | 1 | 1 | 537 - 558 | - | S129633 | 537-558 BROADWAY | 537-558 BROADWAY | F | F | - | F | - | 3152000 | - | - | NORTH SIDE | - | - | - | - | - | ROMOLO ST | 23899 | 23899 | 37.79789244 | -122.40644966 | - | - | 1710539427000 | MTA | TANSAT | ROMOLO ST to COLUMBUS AVE (537 - 558) | - | 60' E COLUMBUS | - | - | - | - | - | 120420 | - | -122.40644966 | 37.79789244 | - | 1685923200000 | - | D3 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1373576820000 | BROADWAY | - | 537 - 558 BROADWAY | 537 BROADWAY | - | - | COLUMBUS AVE |
| 103130 | N/A | Point | 1 | 1 | 555 - 599 | - | S253011 | 555-599 BROADWAY | 555-599 BROADWAY | F | F | - | F | 3153000 | 3153000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | COLUMBUS AVE | COLUMBUS AVE | 78255 | 78255 | 37.79784346 | -122.40684205 | - | - | 1710539427000 | MTA | BIKE WAYFINDING SIGN | COLUMBUS AVE to GRANT AVE (555 - 599) | 0822 | 15 FT WEST OF COLUMBUS IFO ATM MACHINE | - | - | - | - | - | 120421 | 1532649600000 | -122.40684205 | 37.79784346 | - | 1557187200000 | - | D3 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | LIGHT POLE | IS | 1554124920000 | BROADWAY | 555 - 599 BROADWAY | 555 - 599 BROADWAY | 555 BROADWAY | - | GRANT AVE | GRANT AVE |
| 103131 | N/A | Point | 1 | 1 | 300 - 399 | - | S215456 | 300-399 SCOTT ST | 300-399 SCOTT ST | F | F | - | F | 11685000 | 11685000 | - | - | WEST SIDE | - | - | - | - | PAGE ST | PAGE ST | 54627 | 54627 | 37.77288182 | -122.43565741 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-8PM MON-FRI EXC ""Q' PERMITS | PAGE ST to OAK ST (300 - 399) | - | SPL #305 | - | - | - | - | - | 120422 | 1288051200000 | -122.43565741 | 37.77288182 | - | 1439251200000 | - | D5 | - | PARKING:RPP | REG | R32C(CA).0216 | 18X21 | SUP1 | 2IN IRON POST | IS | 1429531080000 | SCOTT ST | 300 - 399 SCOTT ST | 300 - 399 SCOTT ST | 300 SCOTT ST | - | OAK ST | OAK ST |
| 103132 | N/A | Point | 1 | 1 | 300 - 399 | - | S215453 | 300-399 SCOTT ST | 300-399 SCOTT ST | F | F | - | F | 11685000 | 11685000 | - | - | WEST SIDE | - | - | - | - | PAGE ST | PAGE ST | 54624 | 54624 | 37.77288182 | -122.43565741 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM FRI STCL | PAGE ST to OAK ST (300 - 399) | - | SPL #305 | - | - | - | - | - | 120423 | 1288051200000 | -122.43565741 | 37.77288182 | - | 1435104000000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0076 | 18X18 | SUP1 | 2IN IRON POST | IS | 1429530960000 | SCOTT ST | 300 - 399 SCOTT ST | 300 - 399 SCOTT ST | 300 SCOTT ST | - | OAK ST | OAK ST |
| 103133 | N/A | Point | - | - | - | DOUBLE ARROW | 25832 | - | - | - | - | - | - | 11684000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1702324360000 | jsanfel | - | - | HAIGHT ST | - | 174802 | 174802 | 37.7721683603072 | -122.435447826177 | - | - | 1710539427000 | MTA | PAGE SLOW ST FAMILY,H/C,PED,SKATEBOARD,BIKE (SYM) (COMBO) | - | - | SPL 244 | - | - | - | - | - | 120424 | 1702387980000 | - | - | - | - | - | 05 | - | OTHER REGULATORY | REG | R(SF).0515 | 24X30 | SUP2 | 2IN IRON POST | IS | - | SCOTT ST | 200 - 299 SCOTT ST | - | - | - | PAGE ST | - |
| 103134 | N/A | Point | - | - | - | - | 25816 | - | - | - | - | - | - | 10182000 | - | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | 1702318915000 | jsanfel | - | - | LYON ST | - | 174756 | 174756 | 37.7713992417905 | -122.443176192356 | - | - | 1710539427000 | MTA | PAGE SLOW ST FAMILY,H/C,PED,SKATEBOARD,BIKE (SYM) (COMBO) | - | - | EPL 1363 | - | - | - | - | - | 120425 | 1702381500000 | - | - | - | - | - | 05 | - | OTHER REGULATORY | REG | R(SF).0515 | 24X30 | SUP2 | 2IN IRON POST | IS | - | PAGE ST | 1300 - 1399 PAGE ST | - | - | - | CENTRAL AVE | - |
| 103135 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S289744 | 1800-1899 GREEN ST | 1800-1899 GREEN ST | F | F | - | F | 6471000 | 6471000 | - | - | NORTH SIDE | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 99500 | 99500 | 37.79688749 | -122.42954799 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "K" PERMITS | OCTAVIA ST to LAGUNA ST (1800 - 1899) | - | INFO 1882 | - | - | - | - | - | 120426 | 1219881600000 | -122.42954799 | 37.79688749 | - | 1702035240000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0092 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1684835820000 | GREEN ST | 1800 - 1899 GREEN ST | 1800 - 1899 GREEN ST | 1800 GREEN ST | - | LAGUNA ST | LAGUNA ST |
| 103136 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S274965 | 1600-1699 40TH AVE | 1600-1699 40TH AVE | F | F | - | F | 1893000 | 1893000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LAWTON ST | LAWTON ST | 106306 | 106306 | 37.75603912 | -122.49916839 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | LAWTON ST to MORAGA ST (1600 - 1699) | - | 1679 40TH AVE ABOVE SIGN | - | - | - | - | - | 120427 | 1228694400000 | -122.49916839 | 37.75603912 | - | 1623715200000 | - | D4 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1622023440000 | 40TH AVE | 1600 - 1699 40TH AVE | 1600 - 1699 40TH AVE | 1600 40TH AVE | - | MORAGA ST | MORAGA ST |
| 103137 | N/A | Point | - | 1 | 3700 - 3799 | - | S117178 | 3700-3799 BUCHANAN ST | 3700-3799 BUCHANAN ST | F | F | - | F | 3357000 | 3357000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | NORTH POINT ST | NORTH POINT ST | 113051 | 113051 | 37.80454948 | -122.43363199 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | NORTH POINT ST to BEACH ST \ LOWER FORT MASON ST \ MARINA BLVD (3700 - 3799) | - | 0 / AT NPL# 3735 | - | - | - | - | - | 120428 | 1057622400000 | -122.43363199 | 37.80454948 | - | 1592352000000 | - | D2 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373572920000 | BUCHANAN ST | 3700 - 3799 BUCHANAN ST | 3700 - 3799 BUCHANAN ST | 3700 BUCHANAN ST | - | BEACH ST \ LOWER FORT MASON ST \ MARINA BLVD | BEACH ST \ LOWER FORT MASON ST \ MARINA BLVD |
| 103138 | N/A | Point | 1 | 1 | 800 - 899 | - | S278684 | 800-899 28TH AVE | 800-899 28TH AVE | F | F | - | F | 1582000 | 1582000 | - | - | EAST SIDE | - | - | - | - | CABRILLO ST | CABRILLO ST | 124285 | 124285 | 37.77335659 | -122.48746611 | - | - | 1741716514000 | middleware_editor | STOP AHEAD (SYM) | CABRILLO ST to FULTON ST (800 - 899) | - | 832 28TH AVE | - | - | - | - | - | 120429 | 1221548400000 | -122.48746611 | 37.77335659 | - | - | - | D1 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1636378860000 | 28TH AVE | 800 - 899 28TH AVE | 800 - 899 28TH AVE | 800 28TH AVE | - | FULTON ST | FULTON ST |
| 103139 | N/A | Point | - | 1 | 2100 - 2199 | - | S263572 | 2100-2199 OAKDALE AVE | 2100-2199 OAKDALE AVE | T | T | - | F | 9794000 | 9794000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | INDUSTRIAL ST \ SELBY ST | INDUSTRIAL ST \ SELBY ST | 102247 | 102247 | 37.74043195 | -122.4006206 | - | - | 1745507753000 | middleware_editor | STOP AHEAD (SYM) | INDUSTRIAL ST \ SELBY ST to TOLAND ST (2100 - 2199) | - | 140 FT EAST OF TOLAND BELOW G7 | - | - | - | - | - | 120430 | 1063954800000 | -122.4006206 | 37.74043195 | - | 1745507700000 | - | D10 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1587984780000 | OAKDALE AVE | 2100 - 2199 OAKDALE AVE | 2100 - 2199 OAKDALE AVE | 2100 OAKDALE AVE | - | TOLAND ST | TOLAND ST |
| 103140 | N/A | Point | 1 | 1 | 300 - 399 | - | S131662 | 300-399 MOLIMO DR | 300-399 MOLIMO DR | F | F | - | F | 9229000 | 9229000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | BELLA VISTA WAY | BELLA VISTA WAY | 21798 | 21798 | 37.73722398 | -122.45188615 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | BELLA VISTA WAY to MYRA WAY (300 - 399) | - | OPP#349 | - | - | - | - | - | 120431 | 1256601600000 | -122.45188615 | 37.73722398 | - | - | - | D7 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373577420000 | MOLIMO DR | 300 - 399 MOLIMO DR | 300 - 399 MOLIMO DR | 300 MOLIMO DR | - | MYRA WAY | MYRA WAY |
| 103141 | N/A | Point | 1 | 1 | 600 - 699 | - | S234033 | 600-699 HEARST AVE | 600-699 HEARST AVE | F | F | - | F | 6867000 | 6867000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | GENNESSEE ST | GENNESSEE ST | 69935 | 69935 | 37.73067657 | -122.45227469 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | GENNESSEE ST to RIDGEWOOD AVE (600 - 699) | - | 619 HEARST | - | - | - | - | - | 120432 | 1222732800000 | -122.45227469 | 37.73067657 | - | 1504742400000 | - | D7 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1488372960000 | HEARST AVE | 600 - 699 HEARST AVE | 600 - 699 HEARST AVE | 600 HEARST AVE | - | RIDGEWOOD AVE | RIDGEWOOD AVE |
| 103142 | N/A | Point | 1 | 1 | 1255 - 1399 | - | S283194 | 1255-1399 22ND ST | 1255-1399 22ND ST | F | F | - | F | 1165000 | 1165000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | MISSISSIPPI ST | MISSISSIPPI ST | 96019 | 96019 | 37.75771122 | -122.39467471 | - | - | 1720821088000 | middleware_editor | STOP AHEAD (SYM) | MISSISSIPPI ST to TEXAS ST (1255 - 1399) | - | WPL# 1311 22ND ST | - | - | - | - | - | 120433 | 1654473600000 | -122.39467471 | 37.75771122 | - | - | - | D10 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1654251060000 | 22ND ST | 1255 - 1399 22ND ST | 1255 - 1399 22ND ST | 1255 22ND ST | - | TEXAS ST | TEXAS ST |
| 103143 | N/A | Point | - | - | - | - | S265978 | GRANT AVE: COLUMBUS AVE | - | F | F | - | F | 25330000 | 25330000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GRANT AVE | COLUMBUS AVE | 110887 | 110887 | 37.79815206 | -122.40708293 | COLUMBUS AVE \ GRANT AVE | GRANT AVE \ COLUMBUS AVE | 1710539427000 | MTA | STOP AHEAD (SYM) | COLUMBUS AVE intersection | - | MIDDLE OF STREET | - | - | - | - | - | 120434 | 1444780800000 | -122.40708293 | 37.79815206 | - | 1594339200000 | - | D3 | - | OTHER WARNING | WARNING | W3-1.0001 | 24X24 | SUP1 | A FRAME BARRICADE | IS | 1594213260000 | GRANT AVE | - | - | - | - | - | - |
| 103144 | N/A | Point | 1 | 1 | 1 - 99 | - | S285705 | 1-99 ORA WAY | 1-99 ORA WAY | F | F | - | F | 9961000 | 9961000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | GOLD MINE DR | GOLD MINE DR | 96846 | 96846 | 37.74135811 | -122.43797225 | - | - | 1755712925000 | middleware_editor | STOP AHEAD (SYM) | GOLD MINE DR to TOPAZ WAY (1 - 99) | - | NPL 17 | - | - | - | - | - | 120435 | 1675152000000 | -122.43797225 | 37.74135811 | - | - | - | D8 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1666859820000 | ORA WAY | 1 - 99 ORA WAY | 1 - 99 ORA WAY | 1 ORA WAY | - | TOPAZ WAY | TOPAZ WAY |
| 103145 | N/A | Point | - | 1 | 1900 - 2099 | - | S259094 | 1900-2099 JOHN F KENNEDY DR (G | 1900-2099 JOHN F KENNEDY DR | F | F | - | F | 7547000 | 7547000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | BERNICE RODGERS WAY | BERNICE RODGERS WAY | 92558 | 92558 | 37.76794619 | -122.50729725 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | BERNICE RODGERS WAY to 47TH AVE \ GOLF COURSE ACCESS RD (1900 - 2099) | 1075 | 140FT EAST OF BERNICE ROGERS | - | - | - | - | - | 120436 | 1573818900000 | -122.50729725 | 37.76794619 | - | - | - | D1 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1573211940000 | JOHN F KENNEDY DR | 1900-2099 JOHN F KENNEDY DR (G | 1900 - 2099 JOHN F KENNEDY DR | - | - | 47TH AVE \ GOLF COURSE ACCESS RD | 47TH AVE \ GOLF COURSE ACCESS RD |
| 103146 | N/A | Point | 1 | 1 | 5200 - 5299 | - | S278047 | 5200-5299 ANZA ST | 5200-5299 ANZA ST | F | F | - | F | 2359000 | 2359000 | - | - | SOUTH SIDE | - | - | - | - | 43RD AVE | 43RD AVE | 123999 | 123999 | 37.77726294 | -122.5044165 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | 43RD AVE to 44TH AVE (5200 - 5299) | - | 5233 ANZA | - | - | - | - | - | 120437 | 1221523200000 | -122.5044165 | 37.77726294 | - | 1638316800000 | - | D1 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1633098720000 | ANZA ST | 5200 - 5299 ANZA ST | 5200 - 5299 ANZA ST | 5200 ANZA ST | - | 44TH AVE | 44TH AVE |
| 103147 | N/A | Point | 1 | 1 | 100 - 199 | - | S118822 | 100-199 HAHN ST | 100-199 MRS. JACKSON WAY | F | F | - | F | 6599000 | 6599000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | HAHN ST \ VISITACION AVE | HAHN ST \ VISITACION AVE | 108598 | 108598 | 37.71270942 | -122.41564556 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | HAHN ST \ VISITACION AVE to HAHN ST \ SUNNYDALE AVE (100 - 199) | - | OPP#181 | - | - | - | - | - | 120438 | 1083196800000 | -122.41564556 | 37.71270942 | - | 1592524800000 | - | D10 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373573460000 | MRS. JACKSON WAY | 100 - 199 MRS. JACKSON WAY | 100 - 199 MRS. JACKSON WAY | 100 MRS. JACKSON WAY | - | HAHN ST \ SUNNYDALE AVE | HAHN ST \ SUNNYDALE AVE |
| 103148 | N/A | Point | - | - | - | - | S230588 | HUNTERS POINT EXPY: CANDLESTIC | - | F | F | - | F | 33646000 | 33646000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | UNNAMED #047 | UNNAMED #047 | 65587 | 65587 | 37.71271765 | -122.3815908 | CANDLESTICK POINT SRA \ UNNAMED #047 | CANDLESTICK POINT SRA \ UNNAMED #047 | 1710539427000 | MTA | STOP AHEAD (SYM) | UNNAMED #047 intersection | - | 20' EAST OF MID BLOCK X WALK | - | - | - | - | - | 120439 | 1478184540000 | -122.3815908 | 37.71271765 | - | 1478131200000 | - | D10 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1478080740000 | CANDLESTICK POINT SRA | - | - | - | - | - | - |
| 103149 | N/A | Point | 1 | 1 | 300 - 350 | - | S249550 | 300-350 FREDERICK ST | 300-350 FREDERICK ST | F | F | - | F | 5850000 | 5850000 | - | - | SOUTH SIDE | - | - | - | - | CLAYTON ST | CLAYTON ST | 85204 | 85204 | 37.7669394 | -122.44854353 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | CLAYTON ST to BELVEDERE ST (300 - 350) | - | EPL 331 FREDERICKS ST. | - | - | - | - | - | 120440 | 1542112920000 | -122.44854353 | 37.7669394 | - | - | - | D5 | - | OTHER WARNING | WARNING | W3-1.0001 | 24X24 | SUP1 | 2IN IRON POST | IS | 1541689380000 | FREDERICK ST | 300 - 350 FREDERICK ST | 300 - 350 FREDERICK ST | 300 FREDERICK ST | - | BELVEDERE ST | BELVEDERE ST |
| 103150 | N/A | Point | - | - | - | - | S108302 | PAGE ST: BRODERICK ST | - | F | F | - | F | 26035000 | 26035000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BRODERICK ST | PAGE ST | 5261 | 5261 | 37.77199042 | -122.4388991 | PAGE ST \ BRODERICK ST | BRODERICK ST \ PAGE ST | 1710539427000 | MTA | STOP | PAGE ST intersection | - | 0 / 0 | - | - | - | - | - | 120441 | 298080000000 | -122.4388991 | 37.77199042 | - | 1348444800000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373570160000 | BRODERICK ST | - | - | - | - | - | - |
| 103151 | N/A | Point | - | - | - | - | S137319 | BRODERICK ST: PAGE ST | - | F | F | - | F | 26035000 | 26035000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BRODERICK ST | PAGE ST | 33287 | 33287 | 37.77199042 | -122.4388991 | PAGE ST \ BRODERICK ST | BRODERICK ST \ PAGE ST | 1710539427000 | MTA | ALL WAY | PAGE ST intersection | - | - | - | - | - | - | - | 120442 | 1348099200000 | -122.4388991 | 37.77199042 | - | - | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373579220000 | BRODERICK ST | - | - | - | - | - | - |
| 103152 | N/A | Point | - | - | - | - | S137316 | PAGE ST: BRODERICK ST | - | F | F | - | F | 26035000 | 26035000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BRODERICK ST | PAGE ST | 33284 | 33284 | 37.77199042 | -122.4388991 | PAGE ST \ BRODERICK ST | BRODERICK ST \ PAGE ST | 1710539427000 | MTA | ALL WAY | PAGE ST intersection | - | - | - | - | - | - | - | 120443 | 1348099200000 | -122.4388991 | 37.77199042 | - | - | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373579220000 | BRODERICK ST | - | - | - | - | - | - |
| 103153 | N/A | Point | - | - | - | - | S137320 | BRODERICK ST: PAGE ST | - | F | F | - | F | 26035000 | 26035000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BRODERICK ST | PAGE ST | 129133 | 129133 | 37.77199042 | -122.4388991 | PAGE ST \ BRODERICK ST | BRODERICK ST \ PAGE ST | 1710539427000 | MTA | ALL WAY | PAGE ST intersection | - | - | - | - | - | - | - | 120444 | 1348099200000 | -122.4388991 | 37.77199042 | - | - | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373579220000 | BRODERICK ST | - | - | - | - | - | - |
| 103154 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S205459 | 1100-1199 PAGE ST | 1100-1199 PAGE ST | F | F | - | F | 10180000 | 10180000 | - | - | NORTH SIDE | - | - | - | - | BRODERICK ST | BRODERICK ST | 47171 | 47171 | 37.77188476 | -122.43972266 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM TUE STCL | BRODERICK ST to BAKER ST (1100 - 1199) | - | 60'EAST OF BAKER | - | - | - | - | - | 120445 | 1433242380000 | -122.43972266 | 37.77188476 | - | 1433203200000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0083 | 18X18 | SUP1 | 2IN IRON POST | IS | 1399372200000 | PAGE ST | 1100 - 1199 PAGE ST | 1100 - 1199 PAGE ST | 1100 PAGE ST | - | BAKER ST | BAKER ST |
| 103155 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S236701 | 1100-1199 PAGE ST | 1100-1199 PAGE ST | F | F | - | F | 10180000 | 10180000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | BRODERICK ST | BRODERICK ST | 73094 | 73094 | 37.77188476 | -122.43972266 | - | - | 1710539427000 | MTA | BIKE WAYFINDING SIGN | BRODERICK ST to BAKER ST (1100 - 1199) | 0195 | 125`EAST OF BAKER | - | - | - | - | - | 120446 | 1547216880000 | -122.43972266 | 37.77188476 | - | - | - | D5 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | 2IN IRON POST | IS | 1496838960000 | PAGE ST | 1100 - 1199 PAGE ST | 1100 - 1199 PAGE ST | 1100 PAGE ST | - | BAKER ST | BAKER ST |
| 103156 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S220184 | 1100-1199 PAGE ST | 1100-1199 PAGE ST | F | F | - | F | 10180000 | 10180000 | - | - | SOUTH SIDE | - | - | - | - | BRODERICK ST | BRODERICK ST | 60596 | 60596 | 37.77188476 | -122.43972266 | - | - | 1710539427000 | MTA | BIKE RACK | BRODERICK ST to BAKER ST (1100 - 1199) | 20154527 | 51FT. 6IN. WEST OF EPL# 1155 PAGE ST. | - | - | - | - | - | 120447 | 1446213660000 | -122.43972266 | 37.77188476 | - | 1446163200000 | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1445500320000 | PAGE ST | 1100 - 1199 PAGE ST | 1100 - 1199 PAGE ST | 1100 PAGE ST | - | BAKER ST | BAKER ST |
| 103157 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S216248 | 1100-1199 PAGE ST | 1100-1199 PAGE ST | F | F | - | F | 10180000 | 10180000 | - | - | SOUTH SIDE | - | - | - | - | BRODERICK ST | BRODERICK ST | 129161 | 129161 | 37.77188476 | -122.43972266 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "Q" PERMITS | BRODERICK ST to BAKER ST (1100 - 1199) | - | IFO #1193 | - | - | - | - | - | 120448 | 1439050800000 | -122.43972266 | 37.77188476 | - | 1438992000000 | - | D5 | - | PARKING:RPP | REG | R32C(CA).0215 | 18X21 | SUP1 | 2IN IRON POST | IS | 1432027020000 | PAGE ST | 1100 - 1199 PAGE ST | 1100 - 1199 PAGE ST | 1100 PAGE ST | - | BAKER ST | BAKER ST |
| 103158 | N/A | Point | - | - | - | - | S135311 | 6TH ST: HARRISON ST | - | F | F | - | F | 23919000 | 23919000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | HARRISON ST | 06TH ST | 30416 | 30416 | 37.7772727 | -122.40407026 | 06TH ST \ HARRISON ST | HARRISON ST \ 06TH ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) | 06TH ST intersection | - | - | - | - | - | - | - | 120449 | 1320796800000 | -122.40407026 | 37.7772727 | - | - | - | D6 | - | NO RIGHT TURN | REG | R3-1.0003 | 36X36 | SUP1 | SIGNAL POLE | IS | 1373578620000 | HARRISON ST | - | - | - | - | - | - |
| 103159 | N/A | Point | - | - | - | - | S136426 | HARRISON ST: 6TH ST | - | F | F | - | F | 23919000 | 23919000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HARRISON ST | 06TH ST | 26529 | 26529 | 37.7772727 | -122.40407026 | 06TH ST \ HARRISON ST | HARRISON ST \ 06TH ST | 1710539427000 | MTA | SPEED LIMIT 25 | 06TH ST intersection | - | @ PM NWC | - | - | - | - | - | 120450 | 1335744000000 | -122.40407026 | 37.7772727 | - | - | - | D6 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP1 | SIGNAL POLE | IS | 1373578920000 | HARRISON ST | - | - | - | - | - | - |
| 103160 | N/A | Point | - | - | - | - | S135312 | 6TH ST: HARRISON ST | - | F | T | - | F | 23919000 | 23919000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HARRISON ST | 06TH ST | 30417 | 30417 | 37.7772727 | -122.40407026 | 06TH ST \ HARRISON ST | HARRISON ST \ 06TH ST | 1745863056000 | elclark | NO LEFT TURN (SYM) | 06TH ST intersection | - | - | - | - | - | - | - | 120451 | 1320825600000 | -122.40407026 | 37.7772727 | - | - | - | D6 | - | NO LEFT TURN | REG | R3-2.0003 | 36X36 | SUP1 | OVERHEAD MAST ARM | IS | 1373578620000 | HARRISON ST | - | - | - | - | - | - |
| 103161 | N/A | Point | - | - | - | - | S137755 | 6TH ST: HARRISON ST | - | F | F | - | F | - | 23919000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | - | 06TH ST | 29177 | 29177 | 37.7772727 | -122.40407026 | - | HARRISON ST \ 06TH ST | 1710539427000 | MTA | LEFT TURN YIELD ON GREEN (SYM) | 06TH ST intersection | - | ON MAST ARM | - | - | - | - | - | 120452 | 1358380800000 | -122.40407026 | 37.7772727 | - | - | - | D6 | - | OTHER REGULATORY | REG | R10-12.0001 | 30X36 | SUP1 | LIGHT POLE | IS | 1373579340000 | HARRISON ST | - | - | - | - | - | - |
| 103162 | N/A | Point | - | - | - | - | S112685 | LAKE MERCED BLVD: WINSTON DR | - | F | F | - | F | 33512000 | 33512000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WINSTON DR | LAKE MERCED BLVD | 8810 | 8810 | 37.72701952 | -122.4838644 | LAKE MERCED BLVD \ WINSTON DR | WINSTON DR \ LAKE MERCED BLVD | 1710539427000 | MTA | S F BIKE ROUTE (GREEN SYM) 885 LAKE MERCED LOOP (VA) | LAKE MERCED BLVD intersection | - | PLUS "(LAKE MERCED LOOP-VA)"/SEE PAINT | - | - | - | - | - | 120453 | 957398400000 | -122.4838644 | 37.72701952 | - | - | - | D7 | - | BIKE GUIDE | GUIDE | SG45G(885).0008 | 12X30 | SUP2 | 2IN IRON POST | IS | 1373571480000 | WINSTON DR | - | - | - | - | - | - |
| 103163 | N/A | Point | - | - | - | - | S112684 | LAKE MERCED BLVD: WINSTON DR | - | F | F | - | F | 33512000 | 33512000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WINSTON DR | LAKE MERCED BLVD | 7536 | 7536 | 37.72701952 | -122.4838644 | LAKE MERCED BLVD \ WINSTON DR | WINSTON DR \ LAKE MERCED BLVD | 1710539427000 | MTA | S F BIKE ROUTE (GREEN SYM) 86 STONESTOWN (RA) | LAKE MERCED BLVD intersection | - | PLUS "(STONESTOWN-RA E)"/SEE PAINT | - | - | - | - | - | 120454 | 957398400000 | -122.4838644 | 37.72701952 | - | - | - | D7 | - | BIKE GUIDE | GUIDE | SG45G(86).0007 | 12X24 | SUP2 | 2IN IRON POST | IS | 1373571480000 | WINSTON DR | - | - | - | - | - | - |
| 103164 | N/A | Point | - | - | - | - | S212339 | LAKE MERCED BLVD: WINSTON DR | - | F | F | - | F | 33512000 | 33512000 | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | - | - | - | - | WINSTON DR | LAKE MERCED BLVD | 51809 | 51809 | 37.72701952 | -122.4838644 | LAKE MERCED BLVD \ WINSTON DR | WINSTON DR \ LAKE MERCED BLVD | 1711559668000 | middleware_editor | 2 LEFT LANES MUST TURN LEFT | LAKE MERCED BLVD intersection | - | - | - | - | - | - | - | 120455 | - | -122.4838644 | 37.72701952 | - | - | - | D7 | - | OTHER REGULATORY | REG | R3-7(SF).0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1420540740000 | WINSTON DR | - | - | - | - | - | - |
| 103165 | N/A | Point | 1 | 1 | 2100 - 2149 | - | S136358 | 2100-2149 MARIPOSA ST | 2100-2149 MARIPOSA ST | F | F | - | F | 8727000 | 8727000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | VERMONT ST | VERMONT ST | 27621 | 27621 | 37.7633718 | -122.40452224 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | VERMONT ST to HWY 101 N OFF RAMP (2100 - 2149) | - | E-LINE / INSTALL TYPE N SIGN AND 2I..... | - | - | - | - | - | 120456 | 1334880000000 | -122.40452224 | 37.7633718 | - | - | - | 10 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP1 | 2IN IRON POST | IS | 1373578920000 | MARIPOSA ST | 2100 - 2149 MARIPOSA ST | 2100 - 2149 MARIPOSA ST | 2100 MARIPOSA ST | - | HWY 101 N OFF RAMP | HWY 101 N OFF RAMP |
| 103166 | N/A | Point | - | - | - | - | S201691 | NORIEGA ST: 17TH AVE | - | F | F | - | F | 27319000 | 27319000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | NORIEGA ST | 17TH AVE | 48934 | 48934 | 37.75433403 | -122.4743346 | 17TH AVE \ NORIEGA ST | NORIEGA ST \ 17TH AVE | 1729793079000 | middleware_editor | OBJECT MARKER - YELLOW | 17TH AVE intersection | - | E-LINE | - | - | - | - | - | 120457 | - | -122.4743346 | 37.75433403 | - | - | - | D7 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP2 | 2IN IRON POST | IS | 1388745660000 | NORIEGA ST | - | - | - | - | - | - |
| 103167 | N/A | Point | - | - | - | - | S285537 | BERNAL HEIGHTS BLVD: BRADFORD | - | F | F | - | F | 33298000 | 33298000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | BERNAL HEIGHTS BLVD | BERNAL HEIGHTS BLVD | 102289 | 102289 | 37.74194215 | -122.40944546 | \BERNAL HEIGHTS BLVD: BRADFORD | BRADFORD ST \ BERNAL HEIGHTS BLVD | 1745534105000 | middleware_editor | OBJECT MARKER - YELLOW | BERNAL HEIGHTS BLVD intersection | - | BELOW STREET NAMES. | - | - | - | - | - | 120458 | - | -122.40944546 | 37.74194215 | - | 1667808000000 | - | D9 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP2 | 3IN IRON POST | IS | 1666086120000 | BRADFORD ST | - | - | - | - | - | - |
| 103168 | N/A | Point | - | - | - | - | S219779 | RHODE ISLAND ST: SOUTHERN HEIG | - | F | F | - | F | 23755000 | 23755000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | RHODE ISLAND ST | RHODE ISLAND ST | 112847 | 112847 | 37.75840281 | -122.40195658 | SOUTHERN HEIGHTS AVE \ RHODE ISLAND ST | SOUTHERN HEIGHTS AVE \ RHODE ISLAND ST | 1710539427000 | MTA | OBJECT MARKER - YELLOW | RHODE ISLAND ST intersection | - | ON ISLAND | - | - | - | - | - | 120459 | - | -122.40195658 | 37.75840281 | - | 1657497600000 | - | D10 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP1 | 2IN IRON POST | IS | 1444140360000 | SOUTHERN HEIGHTS AVE | - | - | - | - | - | - |
| 103169 | N/A | Point | - | - | - | - | S136582 | JOOST AVE: MONTEREY BLVD | - | F | F | - | F | 33695000 | 33695000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | MONTEREY BLVD | JOOST AVE | 27945 | 27945 | 37.73229529 | -122.43499278 | JOOST AVE \ MONTEREY BLVD | MONTEREY BLVD \ JOOST AVE | 1744045700000 | middleware_editor | OBJECT MARKER - YELLOW | JOOST AVE intersection | - | OPP#4 | - | - | - | - | - | 120460 | 1337238000000 | -122.43499278 | 37.73229529 | - | 1635922800000 | - | D7 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373578980000 | MONTEREY BLVD | - | - | - | - | - | - |
| 103170 | N/A | Point | 1 | 1 | 3300 - 3399 | - | S208266 | 3300-3399 ORTEGA ST | 3300-3399 ORTEGA ST | F | F | - | F | 10029000 | 10029000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | 40TH AVE | 40TH AVE | 49980 | 49980 | 37.75135746 | -122.49937835 | - | - | 1715649062000 | middleware_editor | OBJECT MARKER - YELLOW | 40TH AVE to 41ST AVE (3300 - 3399) | - | W-LINE | - | - | - | - | - | 120461 | 1267401600000 | -122.49937835 | 37.75135746 | - | 1424649600000 | - | D4 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP2 | 2IN IRON POST | IS | 1408366320000 | ORTEGA ST | 3300 - 3399 ORTEGA ST | 3300 - 3399 ORTEGA ST | 3300 ORTEGA ST | - | 41ST AVE | 41ST AVE |
| 103171 | N/A | Point | 1 | 1 | 1 - 99 | - | S207473 | 1-99 EDWARD ST | 1-99 EDWARD ST | F | F | - | F | 27208000 | 5105000 | - | - | NORTH SIDE, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | WILLARD ST | WILLARD ST | 50311 | 50311 | 37.77810627 | -122.45784123 | EDWARD ST \ WILLARD ST | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | WILLARD ST to ARGUELLO BLVD (1 - 99) | - | OPP.C-LINE | - | - | - | - | - | 120462 | - | -122.45784123 | 37.77810627 | - | - | - | D1 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP2 | LIGHT POLE | IS | 1404732000000 | EDWARD ST | - | 1 - 99 EDWARD ST | 1 EDWARD ST | - | - | ARGUELLO BLVD |
| 103172 | N/A | Point | 1 | 1 | 600 - 699 | LEFT ARROW | S242481 | 600-699 NIAGARA AVE | 600-699 NIAGARA AVE | F | F | - | F | 9595000 | 9596000 | - | - | NORTH SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | SAN MIGUEL ST | TARA ST | 75435 | 75435 | 37.72031677 | -122.44969118 | - | - | 1721784948000 | middleware_editor | OBJECT MARKER - YELLOW | TARA ST to LOUISBURG ST (600 - 699) | - | OPP.EPL#515 NIAGARA AVE. | - | - | - | - | - | 120463 | 839376000000 | -122.44969118 | 37.72031677 | - | 1517184000000 | - | D11 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP2 | 2IN IRON POST | IS | 1516781460000 | NIAGARA AVE | 500 - 599 NIAGARA AVE | 600 - 699 NIAGARA AVE | 600 NIAGARA AVE | - | TARA ST | LOUISBURG ST |
| 103173 | N/A | Point | - | - | - | - | S247367 | CALIFORNIA ST: LOCUST ST | - | F | F | - | F | 26938000 | 26938000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | LOCUST ST | CALIFORNIA ST | 80835 | 80835 | 37.78661956 | -122.45175796 | CALIFORNIA ST \ LOCUST ST | LOCUST ST \ CALIFORNIA ST | 1710539427000 | MTA | OBJECT MARKER - YELLOW | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 120464 | - | -122.45175796 | 37.78661956 | - | - | - | D2 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP1 | 2IN IRON POST | IS | 1532694900000 | LOCUST ST | - | - | - | - | - | - |
| 103174 | N/A | Point | - | - | - | - | S113362 | - | - | F | F | - | F | 10665000 | - | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | - | - | 131651 | 131651 | 37.7600101 | -122.4070614 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | - | - | BACK TO BACK N-LINE OF CENTER ISLAND | - | - | - | - | - | 120465 | 987811200000 | - | - | - | - | - | D10 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP1 | 2IN IRON POST | IS | - | - | 700 - 798 POTRERO AVE | - | - | - | - | - |
| 103175 | N/A | Point | 1 | 1 | 545 - 575 | - | S135690 | 545-575 2ND ST | 545-575 02ND ST | F | F | - | F | 145000 | 145000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | SOUTH PARK | SOUTH PARK | 28904 | 28904 | 37.78236558 | -122.39272713 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | SOUTH PARK to DE BOOM ST (545 - 575) | - | N-LINE / @ PM IN PAINTED CENTER ISL..... | - | - | - | - | - | 120466 | 1325635200000 | -122.39272713 | 37.78236558 | - | - | - | D6 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP1 | 2IN IRON POST | IS | 1373578680000 | 02ND ST | 545 - 575 2ND ST | 545 - 575 02ND ST | 545 2ND ST | - | DE BOOM ST | DE BOOM ST |
| 103176 | N/A | Point | - | - | - | - | S203195 | 15TH AVE: FANNING WAY \ QUINTA | - | F | F | - | F | 23189000 | 23189000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | FANNING WAY \ QUINTARA ST | FANNING WAY \ QUINTARA ST | 41012 | 41012 | 37.74883627 | -122.47174916 | 15TH AVE \ FANNING WAY \ QUINTARA ST | 15TH AVE \ FANNING WAY \ QUINTARA ST | 1717724837000 | middleware_editor | OBJECT MARKER - YELLOW | FANNING WAY \ QUINTARA ST intersection | - | NE ON FANNING WAY | - | - | - | - | - | 120467 | - | -122.47174916 | 37.74883627 | - | - | - | D7 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP2 | 3IN IRON POST | IS | 1392911460000 | 15TH AVE | - | - | - | - | - | - |
| 103177 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S202450 | 2200-2299 MARIPOSA ST | 2200-2299 MARIPOSA ST | F | F | - | F | 8728000 | 8728000 | - | - | EAST SIDE, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | SAN BRUNO AVE | SAN BRUNO AVE | 42076 | 42076 | 37.76327832 | -122.40593604 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | SAN BRUNO AVE to UTAH ST (2200 - 2299) | - | CENTER LINE END OF MARIPOSA | - | - | - | - | - | 120468 | - | -122.40593604 | 37.76327832 | - | - | - | D10 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP1 | 3IN IRON POST | IS | 1390477620000 | MARIPOSA ST | 2200 - 2299 MARIPOSA ST | 2200 - 2299 MARIPOSA ST | 2200 MARIPOSA ST | - | UTAH ST | UTAH ST |
| 103178 | N/A | Point | - | - | - | - | S219409 | TRUMBULL ST: CONGDON ST | - | F | F | - | F | 21669000 | 21669000 | - | - | CENTER ISLAND, W LINE, WESTBOUND | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | TRUMBULL ST | CONGDON ST | 57913 | 57913 | 37.73088141 | -122.42614366 | CONGDON ST \ TRUMBULL ST | TRUMBULL ST \ CONGDON ST | 1742940513000 | middleware_editor | OBJECT MARKER - YELLOW | CONGDON ST intersection | - | 3OF4 | - | - | - | - | - | 120469 | 1476908340000 | -122.42614366 | 37.73088141 | - | 1742835600000 | - | D11 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP2 | 2IN BREAK-AWAY SYSTEM | IS | 1442922960000 | TRUMBULL ST | - | - | - | - | - | - |
| 103179 | N/A | Point | 1 | 1 | 1 - 99 | - | S225676 | 1-99 STAPLES AVE | 1-99 STAPLES AVE | F | F | - | F | 12103000 | 12103000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | CIRCULAR AVE | CIRCULAR AVE | 62508 | 62508 | 37.72909766 | -122.44343978 | - | - | 1730239914000 | middleware_editor | OBJECT MARKER - YELLOW | CIRCULAR AVE to DETROIT ST (1 - 99) | - | SEE PAINT | - | - | - | - | - | 120470 | 1256083200000 | -122.44343978 | 37.72909766 | - | 1730211900000 | - | D7 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP2 | 2IN IRON POST | IS | 1463473140000 | STAPLES AVE | 1 - 99 STAPLES AVE | 1 - 99 STAPLES AVE | 1 STAPLES AVE | - | DETROIT ST | DETROIT ST |
| 103180 | N/A | Point | - | - | - | - | S106334 | ANDERSON ST: TOMPKINS AVE | - | F | F | - | F | 21188000 | 21188000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | ANDERSON ST | 3206 | 3206 | 37.73717557 | -122.41533788 | ANDERSON ST \ TOMPKINS AVE | TOMPKINS AVE \ ANDERSON ST | 1710539427000 | MTA | ONE WAY (RA) | ANDERSON ST intersection | - | 00 / 0 | - | - | - | - | - | 120471 | 137116800000 | -122.41533788 | 37.73717557 | - | - | - | D9 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | UNKNOWN | IS | 1373569500000 | TOMPKINS AVE | - | - | - | - | - | - |
| 103181 | N/A | Point | - | - | - | - | 23814 | - | - | F | T | - | F | 25166000 | - | - | - | NORTH WEST CORNER | 1694195492000 | elclark | - | - | HYDE ST | - | 154268 | 154268 | 37.7863765934734 | -122.416561916465 | GEARY ST \ HYDE ST | - | 1725481835000 | middleware_editor | HYDE ST | - | - | NWC <600| NORTH | - | - | - | - | - | 120473 | - | - | - | - | 1725456600000 | - | 03 | HIGH INTENSITY PRISMATIC (TYPE IV WITH OL-1000 ANTI GRAFFITI OVERLAY FILM) | STREET NAME | GUIDE | D3-1.0884 | 36X08 | SUP1 | SIGNAL POLE | IS | - | GEARY ST | - | - | - | - | - | - |
| 103182 | N/A | Point | - | - | - | - | 24077 | - | - | F | T | - | F | 24101000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1695230665000 | smuneno | - | - | VALENCIA ST | - | 156242 | 156242 | 37.7520035823944 | -122.420765316675 | 24TH ST \ VALENCIA ST | - | 1710539427000 | MTA | REMOVE (SF BIKE ROUTE) GREEN (SYM) # | - | - | VALENCIA @ 24TH ST | - | - | - | - | - | 120474 | - | - | - | - | - | 1696426200000 | 08 | - | BIKE REG | REG | R(SF).0388 | 12X24 | SUP3 | SIGNAL POLE | RETD | - | 24TH ST | - | - | - | - | - | - |
| 103183 | N/A | Point | - | - | - | - | 24083 | - | - | F | T | - | F | 25138000 | - | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | 1695236564000 | smuneno | - | - | HYDE ST | - | 156274 | 156274 | 37.7834803081114 | -122.415767680527 | EDDY ST \ HYDE ST | - | 1710539427000 | MTA | HYDE ST | - | - | EDDY @ HYDE ST | - | - | - | - | - | 120475 | - | - | - | - | - | - | 05 | - | STREET NAME | GUIDE | D3-2.0191 | 72X18 | SUP2 | SIGNAL POLE | PI | - | EDDY ST | - | - | - | - | - | - |
| 103184 | N/A | Point | - | - | - | - | 24085 | - | - | F | T | - | F | 24945000 | - | - | - | NORTH EAST CORNER | 1695243684000 | smuneno | - | - | OFARRELL ST | - | 156275 | 156275 | 37.7858941579776 | -122.412916834912 | JONES ST \ OFARRELL ST | - | 1710539427000 | MTA | OFARRELL ST | - | - | JONES @ OFARRELL / []<---500 | - | - | - | - | - | 120476 | - | - | - | - | - | - | 05 | - | STREET NAME | GUIDE | D3-1.1303 | 36X08 | SUP2 | SIGNAL POLE | PI | - | JONES ST | - | - | - | - | - | - |
| 103185 | N/A | Point | - | - | - | - | S122088 | OFARRELL ST: JONES ST | - | F | F | - | F | 24945000 | 24945000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OFARRELL ST | JONES ST | 13139 | 13139 | 37.78578959 | -122.41296967 | JONES ST \ OFARRELL ST | OFARRELL ST \ JONES ST | 1710539427000 | MTA | RIGHT LANE BUSES, TAXIS AND RIGHT TURNS ONLY AT ALL TIMES | JONES ST intersection | - | - | - | - | - | - | - | 120477 | 1133481600000 | -122.41296967 | 37.78578959 | - | - | - | D6 | - | TRANSIT ONLY(RIGHT LANE) | REG | SR60-6(SF).0005 | 30X42 | SUP1 | LIGHT POLE | IS | 1373574480000 | OFARRELL ST | - | - | - | - | - | - |
| 103186 | N/A | Point | - | - | - | - | 24087 | - | - | F | T | - | F | 24945000 | - | - | - | SOUTH EAST CORNER | 1695243928000 | smuneno | - | - | OFARRELL ST | - | 156290 | 156290 | 37.7857659120499 | -122.412857826314 | JONES ST \ OFARRELL ST | - | 1710539427000 | MTA | JONES ST | - | - | OFARRELL @ JONES | - | - | - | - | - | 120478 | - | - | - | - | - | - | 05 | - | STREET NAME | GUIDE | D3-1.0935 | 36X08 | SUP2 | SIGNAL POLE | PI | - | JONES ST | - | - | - | - | - | - |
| 103187 | N/A | Point | - | - | - | - | 24078 | - | - | F | T | - | F | 24101000 | - | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | 1695231179000 | smuneno | - | - | VALENCIA ST | - | 156227 | 156227 | 37.7521629026109 | -122.420805214534 | 24TH ST \ VALENCIA ST | - | 1710539427000 | MTA | VALENCIA ST | - | - | 24TH ST @ VALENCIA | - | - | - | - | - | 120479 | - | - | - | - | - | - | 09 | - | STREET NAME | GUIDE | D3-2.0345 | 72X18 | SUP3 | SIGNAL POLE | PI | - | 24TH ST | - | - | - | - | - | - |
| 103188 | N/A | Point | - | - | - | - | 24076 | - | - | - | T | - | - | 24101000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1695230596000 | smuneno | - | - | VALENCIA ST | - | 156226 | 156226 | 37.7520043776709 | -122.420765651951 | 24TH ST \ VALENCIA ST | - | 1710539427000 | MTA | BIKE (SYM) LANE | - | - | VALENCIA @24TH ST | - | - | - | - | - | 120480 | - | - | - | - | - | 1696424400000 | 08 | - | BIKE REG | REG | R81(CA).0002 | 24X18 | SUP3 | SIGNAL POLE | RETD | - | 24TH ST | - | - | - | - | - | - |
| 103189 | N/A | Point | - | - | - | - | 24091 | - | - | - | T | - | - | 24434000 | - | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1695240470000 | smuneno | - | - | GROVE ST | - | 156289 | 156289 | 37.7787855222882 | -122.416512274329 | LARKIN ST \ GROVE ST | - | 1710539427000 | MTA | SKATEBOARD & BICYCLE RIDING PROH SEC 100 TC | - | - | LARKIN @ GROVE | - | - | - | - | - | 120481 | - | - | - | - | - | - | 05 | - | OTHER REGULATORY | REG | R(SF).0240 | 18X24 | SUP2 | SIGNAL POLE | PI | - | LARKIN ST | - | - | - | - | - | - |
| 103190 | N/A | Point | - | - | - | - | S283853 | MISSION ST: 26TH ST | - | T | T | - | F | 21306000 | 21306000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 26TH ST | MISSION ST | 95230 | 95230 | 37.749132185 | -122.418061942 | MISSION ST \ 26TH ST | 26TH ST \ MISSION ST | 1710539427000 | MTA | SPEED LIMIT 20 | MISSION ST intersection | - | - | - | - | - | - | - | 120482 | 1665705600000 | -122.41813525 | 37.74904129 | - | - | - | D9 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | LIGHT POLE | IS | 1656683760000 | 26TH ST | - | - | - | - | - | - |
| 103191 | N/A | Point | - | - | - | - | S111191 | DAVIDSON AVE: QUINT ST | - | F | F | - | F | 20696000 | 20696000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | QUINT ST | DAVIDSON AVE | 109138 | 109138 | 37.74467268 | -122.38976017 | DAVIDSON AVE \ QUINT ST | QUINT ST \ DAVIDSON AVE | 1710539427000 | MTA | STOP | DAVIDSON AVE intersection | - | - | - | - | - | - | - | 120483 | 763948800000 | -122.38976017 | 37.74467268 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571060000 | QUINT ST | - | - | - | - | - | - |
| 103192 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S224575 | 1300-1399 LARKIN ST | 1300-1399 LARKIN ST | F | F | - | F | 8140000 | 8140000 | - | - | EAST SIDE | - | - | - | - | PINE ST | PINE ST | 62396 | 62396 | 37.790309 | -122.41893943 | - | - | 1754933854000 | middleware_editor | 2 HR PRK 8AM-9PM MON-SAT EXC "CG" PERMITS | PINE ST to CALIFORNIA ST (1300 - 1399) | - | SPL #1326 | - | - | - | - | - | 120484 | 1218006000000 | -122.41893943 | 37.790309 | - | 1696523400000 | - | D3 | - | PARKING:RPP | REG | R32C(CA).0135 | 18X21 | SUP1 | 2IN IRON POST | IS | 1459781940000 | LARKIN ST | 1300 - 1399 LARKIN ST | 1300 - 1399 LARKIN ST | 1300 LARKIN ST | - | CALIFORNIA ST | CALIFORNIA ST |
| 103193 | N/A | Point | 1 | 1 | 201 - 300 | - | S268389 | 201-300 JEFFERSON ST | 201-300 JEFFERSON ST | T | T | - | F | 7457000 | 7457000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | TAYLOR ST | TAYLOR ST | 90423 | 90423 | 37.80811369 | -122.41662418 | - | - | 1710539427000 | MTA | TWO WAY TRAFFIC (SYM) | TAYLOR ST to JONES ST (201 - 300) | - | - | - | - | - | - | - | 120485 | 1601037780000 | -122.41662418 | 37.80811369 | - | - | 1695889800000 | D3 | - | OTHER WARNING | WARNING | W6-3.0001 | 24X24 | SUP1 | MUNI POLE | RETD | 1600856220000 | JEFFERSON ST | 201 - 300 JEFFERSON ST | 201 - 300 JEFFERSON ST | 201 JEFFERSON ST | - | JONES ST | JONES ST |
| 103194 | N/A | Point | - | - | - | - | S230106 | QUINT ST: DAVIDSON AVE | - | F | F | - | F | 20696000 | 20696000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | QUINT ST | DAVIDSON AVE | 67665 | 67665 | 37.74467268 | -122.38976017 | DAVIDSON AVE \ QUINT ST | QUINT ST \ DAVIDSON AVE | 1710539427000 | MTA | ALL WAY | DAVIDSON AVE intersection | - | - | - | - | - | - | - | 120486 | 763948800000 | -122.38976017 | 37.74467268 | - | 1694617380000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1477318320000 | QUINT ST | - | - | - | - | - | - |
| 103195 | N/A | Point | - | - | - | - | 23919 | - | - | - | T | - | - | 7457000 | - | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | 1694536603000 | smuneno | - | - | TAYLOR ST | - | 154869 | 154869 | 37.8079957552696 | -122.417187752159 | - | - | 1710539427000 | MTA | SKEWED RAILROAD CROSSING (R TO L) | - | - | 40' EAST OF JONES | - | - | - | - | - | 120487 | 1695893400000 | - | - | - | - | - | 03 | - | OTHER WARNING | WARNING | W10-12.0002 | 30X30 | SUP1 | OVERHEAD MAST ARM | IS | - | JEFFERSON ST | 201 - 300 JEFFERSON ST | - | - | - | JONES ST | - |
| 103196 | N/A | Point | - | - | - | - | 23915 | - | - | - | - | - | - | - | - | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | 1694534653000 | smuneno | - | - | - | - | 154866 | 154866 | 37.8078753466208 | -122.419151590169 | - | - | 1710539427000 | MTA | DOUBLE ARROW-LEFT & RIGHT (SYM) | - | - | RICHARD HENRY DANA @ JEFFERSON | - | - | - | - | - | 120488 | - | - | - | - | - | 1695901500000 | 03 | - | OTHER WARNING | WARNING | W1-7.0003 | 30X12 | SUP1 | 2IN IRON POST | RETD | - | - | - | - | - | - | - | - |
| 103197 | N/A | Point | - | - | - | - | S222649 | MISSION ST: 26TH ST | - | T | T | - | F | 21306000 | 21306000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 26TH ST | MISSION ST | 61151 | 61151 | 37.74896441 | -122.41804182 | MISSION ST \ 26TH ST | 26TH ST \ MISSION ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | MISSION ST intersection | - | - | - | - | - | - | - | 120489 | 1459171680000 | -122.41813525 | 37.74904129 | - | 1692713040000 | - | D9 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1453729800000 | 26TH ST | - | - | - | - | - | - |
| 103198 | N/A | Point | - | - | - | - | S111197 | QUINT ST: DAVIDSON AVE | - | F | F | - | F | 20696000 | 20696000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | QUINT ST | DAVIDSON AVE | 9331 | 9331 | 37.74467268 | -122.38976017 | DAVIDSON AVE \ QUINT ST | QUINT ST \ DAVIDSON AVE | 1726260105000 | middleware_editor | STOP | DAVIDSON AVE intersection | - | - | - | - | - | - | - | 120490 | 763948800000 | -122.38976017 | 37.74467268 | - | 1709198700000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373571060000 | QUINT ST | - | - | - | - | - | - |
| 103199 | N/A | Point | - | - | - | - | 23939 | - | - | F | F | - | F | 5589000 | - | - | - | WEST SIDE | 1694541625000 | smuneno | - | - | FITZGERALD AVE | - | 154961 | 154961 | 37.7175299877317 | -122.386042931522 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | - | - | 100' SOUTH OF FITZGERALD | - | - | - | - | - | 120491 | 1696239000000 | - | - | - | - | - | 10 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP1 | LIGHT POLE | IS | - | ARELIOUS WALKER DR | 2800 - 2999 ARELIOUS WALKER DR | - | - | - | GILMAN AVE | - |
| 103200 | N/A | Point | - | - | - | - | 23712 | - | - | - | T | - | - | 35026000 | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1694025275000 | smuneno | - | - | DONAHUE ST | - | 153793 | 153793 | 37.7299190350262 | -122.369250031895 | GALVEZ AVE \ DONAHUE ST | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | - | - | 25' SOUTH OF GALVEZ | - | - | - | - | - | 120492 | 1695028500000 | - | - | - | - | - | 10 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP1 | LIGHT POLE | IS | - | GALVEZ AVE | - | - | - | - | - | - |
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 metersMetadata automatically harvested from the ESRI service during import.