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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86776 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S251030 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | F | F | - | F | 10672000 | 10672000 | - | - | EAST SIDE | - | - | - | - | 24TH ST | 24TH ST | 79680 | 79680 | 37.75236512 | -122.40627783 | - | - | 1710539427000 | MTA | 1 HR PRK 8AM-6PM MON-FRI EXC "W" PERMITS | 24TH ST to 25TH ST (1200 - 1299) | - | IFO #1249 | - | - | - | - | - | 103960 | 1196812800000 | -122.40627783 | 37.75236512 | - | 1568073600000 | - | D9 | - | PARKING:RPP | REG | R32C(CA).0012 | 18X21 | SUP2 | LIGHT POLE | IS | 1548253020000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86777 | N/A | Point | 1 | 1 | 1200 - 1299 | LEFT ARROW | S239529 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | F | F | - | F | 10672000 | 10672000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 75019 | 75019 | 37.75236512 | -122.40627783 | - | - | 1710539427000 | MTA | TANSAT | 24TH ST to 25TH ST (1200 - 1299) | - | IFO# 1260 POTRERO AVE. | - | - | - | - | - | 103961 | 1505779200000 | -122.40627783 | 37.75236512 | - | 1572912000000 | - | D9 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | 1508168520000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86778 | N/A | Point | 1 | 1 | 1200 - 1299 | RIGHT ARROW | S245327 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | F | F | - | F | 10672000 | 10672000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 81523 | 81523 | 37.75236512 | -122.40627783 | - | - | 1710539427000 | MTA | TANSAT | 24TH ST to 25TH ST (1200 - 1299) | - | SPL# 1260 POTRERO AVE. | - | - | - | - | - | 103962 | 1505779200000 | -122.40627783 | 37.75236512 | - | 1572912000000 | - | D9 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | 1525426980000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86779 | N/A | Point | 1 | 1 | 1200 - 1299 | RIGHT ARROW | S238882 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | F | F | - | F | 10672000 | 10672000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 71601 | 71601 | 37.75236512 | -122.40627783 | - | - | 1710539427000 | MTA | TANSAT | 24TH ST to 25TH ST (1200 - 1299) | - | 133' SOUTH OF 24TH ST | - | - | - | - | - | 103963 | 1505831400000 | -122.40627783 | 37.75236512 | - | 1505779200000 | - | D9 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | 2IN IRON POST | IS | 1505382900000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86780 | N/A | Point | 1 | 1 | 1200 - 1299 | RIGHT ARROW | S258369 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | T | T | - | F | 10672000 | 10672000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 87742 | 87742 | 37.75236512 | -122.40627783 | - | - | 1710539427000 | MTA | GENERAL HOSPITAL GARAGE | 24TH ST to 25TH ST (1200 - 1299) | - | 25' S OF 24TH ST | - | - | - | - | - | 103964 | 1572012900000 | -122.40627783 | 37.75236512 | - | - | - | D9 | - | OTHER GUIDE | GUIDE | G-G(SF).0040 | 30X30 | SUP2 | LIGHT POLE | IS | 1571304720000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86781 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S246830 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | T | T | - | F | 10672000 | 10672000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 84621 | 84621 | 37.75236512 | -122.40627783 | - | - | 1710539427000 | MTA | BUS AND TAXI LANE ENDS | 24TH ST to 25TH ST (1200 - 1299) | - | 100S / ABOVE SAMTRANS SIGN | - | - | - | - | - | 103965 | 1073001600000 | -122.40627783 | 37.75236512 | - | 1551830400000 | - | D9 | - | OTHER REGULATORY | REG | R(SF).0023 | 30X42 | SUP2 | LIGHT POLE | IS | 1531230360000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86782 | N/A | Point | - | - | - | - | S247431 | MARKET ST: ORD ST | - | F | F | - | F | 26163000 | 26163000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | ORD ST | MARKET ST | 76359 | 76359 | 37.76117789 | -122.44006866 | MARKET ST \ ORD ST | ORD ST \ MARKET ST | 1715291029000 | middleware_editor | AHEAD | MARKET ST intersection | - | E-LINE OF ORD ST | - | - | - | - | - | 103966 | 1136332800000 | -122.44006866 | 37.76117789 | - | 1533168000000 | 1715170260000 | 08 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP3 | LIGHT POLE | RETD | 1533046500000 | ORD ST | - | - | - | - | - | - |
| 86783 | N/A | Point | 1 | 1 | 1804 - 1896 | - | S247850 | 1800-1899 MARKET ST | 1804-1896 MARKET ST | F | F | - | F | 8760203 | 8760203 | - | - | NORTH SIDE | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 76363 | 76363 | 37.77125261 | -122.4242868 | - | - | 1710539427000 | MTA | BIKE RACK | OCTAVIA ST to GUERRERO ST \ LAGUNA ST (1804 - 1896) -- NORTH -- | 27979 | 40'E OF EPL#1844/4' IN FROM CURB | - | - | - | - | - | 103967 | 1536070620000 | -122.4242868 | 37.77125261 | - | - | - | 08 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP3 | BIKE RACK | IS | 1534845360000 | MARKET ST | 1804 - 1896 MARKET ST | 1804 - 1896 MARKET ST | 1804 MARKET ST | - | GUERRERO ST \ LAGUNA ST | GUERRERO ST \ LAGUNA ST |
| 86784 | N/A | Point | - | - | - | - | S252817 | LINCOLN BLVD: LETTERMAN DR \ P | - | T | T | - | F | 51243000 | 51243000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LETTERMAN DR \ PRESIDIO BLVD | LINCOLN BLVD \ PRESIDIO BLVD | 76526 | 76526 | 37.79918292 | -122.4526076 | LINCOLN BLVD \ LETTERMAN DR \ PRESIDIO BLVD | LETTERMAN DR \ LINCOLN BLVD \ PRESIDIO BLVD | 1710539427000 | MTA | REMOVE (SF BIKE ROUTE) GREEN (SYM) # | LINCOLN BLVD \ PRESIDIO BLVD intersection | - | PERSIDEO / LINCOLN AND LETTERMAN #55 | - | - | - | - | - | 103968 | - | -122.4526076 | 37.79918292 | - | - | - | 02 | - | BIKE REG | REG | R(SF).0388 | 12X24 | SUP2 | LIGHT POLE | IS | 1553769000000 | LETTERMAN DR | - | - | - | - | - | - |
| 86785 | N/A | Point | - | - | - | - | S252819 | LINCOLN BLVD: LETTERMAN DR \ P | - | T | T | - | F | 51243000 | 51243000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LETTERMAN DR \ PRESIDIO BLVD | LINCOLN BLVD \ PRESIDIO BLVD | 76527 | 76527 | 37.79918292 | -122.4526076 | LINCOLN BLVD \ LETTERMAN DR \ PRESIDIO BLVD | LETTERMAN DR \ LINCOLN BLVD \ PRESIDIO BLVD | 1710539427000 | MTA | REMOVE (SF BIKE ROUTE) GREEN (SYM) # | LINCOLN BLVD \ PRESIDIO BLVD intersection | - | PERSIDEO / LINCOLN AND LETTERMAN #4 | - | - | - | - | - | 103969 | - | -122.4526076 | 37.79918292 | - | - | - | 02 | - | BIKE REG | REG | R(SF).0388 | 12X24 | SUP2 | LIGHT POLE | IS | 1553769000000 | LETTERMAN DR | - | - | - | - | - | - |
| 86786 | N/A | Point | - | - | - | - | S251399 | SLOAT BLVD: GREAT HWY | - | F | F | - | F | 32904000 | 32904000 | - | - | NORTH EAST CORNER | - | - | - | - | SLOAT BLVD | GREAT HWY | 77671 | 77671 | 37.7356531496113 | -122.506581544871 | GREAT HWY \ SLOAT BLVD | SLOAT BLVD \ GREAT HWY | 1738353056000 | middleware_editor | BIKE WAYFINDING SIGN | GREAT HWY intersection | 0316 | ON 2 IN POST ENTERING PATH SEE NOTES | - | - | - | - | - | 103970 | 1576660620000 | -122.50671743 | 37.73546976 | - | - | - | 07 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP3 | 2IN IRON POST | IS | 1549518360000 | SLOAT BLVD | - | - | - | - | - | - |
| 86787 | N/A | Point | - | - | - | - | S254278 | COLEMAN ST: JERROLD AVE \ KENN | - | F | F | - | F | 35035000 | 35035000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | COLEMAN ST \ JERROLD AVE \ KIRKWOOD AVE | COLEMAN ST \ JERROLD AVE \ KIRKWOOD AVE | 78001 | 78001 | 37.72722398 | -122.36898928 | KENNEDY PL \ COLEMAN ST \ JERROLD AVE \ KIRKWOOD AVE | KENNEDY PL \ COLEMAN ST \ JERROLD AVE \ KIRKWOOD AVE | 1710539427000 | MTA | STOP | COLEMAN ST \ JERROLD AVE \ KIRKWOOD AVE intersection | - | X- ST IS JERROLD AVE. | - | - | - | - | - | 103971 | - | -122.36898928 | 37.72722398 | - | - | - | 10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1557493020000 | KENNEDY PL | - | - | - | - | - | - |
| 86788 | N/A | Point | - | - | - | - | S248808 | BAY SHORE BLVD: CORTLAND AVE | - | T | T | - | F | 21023000 | 21023000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CORTLAND AVE | CORTLAND AVE | 78346 | 78346 | 37.73956627 | -122.40697859 | BAY SHORE BLVD \ CORTLAND AVE | BAY SHORE BLVD \ CORTLAND AVE | 1710539427000 | MTA | NO U TURN (SYM) | CORTLAND AVE intersection | - | OF BAYSHORE BLVD & CORTLAND AVE | - | - | - | - | - | 103972 | 1539175020000 | -122.40697859 | 37.73956627 | - | - | - | 10 | - | OTHER REGULATORY | REG | R3-4.0002 | 30X30 | SUP1 | OVERHEAD MAST ARM | IS | 1538573580000 | BAY SHORE BLVD | - | - | - | - | - | - |
| 86789 | N/A | Point | - | - | - | - | S247545 | LANGTON ST: END | - | F | F | - | F | 50057000 | 50057000 | - | - | NORTH EAST CORNER | - | - | - | - | MID BLOCK | MID BLOCK | 78406 | 78406 | 37.77326578 | -122.40455195 | LANGTON ST \ MID BLOCK | LANGTON ST \ MID BLOCK | 1710539427000 | MTA | LANGTON ST | MID BLOCK intersection | - | X IS BRANNAN (PRIVATE) | - | - | - | - | - | 103973 | 1533627300000 | -122.40455195 | 37.77326578 | - | - | - | 06 | - | STREET NAME | GUIDE | D3-1.1006 | 36X08 | SUP1 | 3IN IRON POST | IS | 1533289500000 | LANGTON ST | - | - | - | - | - | - |
| 86790 | N/A | Point | - | - | - | - | S254099 | CHANNEL ST: 3RD ST | - | F | F | - | F | 34155000 | 34155000 | - | - | CENTER ISLAND | - | - | - | - | CHANNEL ST | 03RD ST | 78523 | 78523 | 37.77455117 | -122.389865 | 3RD ST \ CHANNEL ST | CHANNEL ST \ 03RD ST | 1734624128000 | middleware_editor | TANSAT | 03RD ST intersection | - | 20FT SOUTH | - | - | - | - | - | 103974 | 1556064000000 | -122.389865 | 37.77455117 | - | 1558396800000 | - | 06 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP1 | LIGHT POLE | IS | 1556896440000 | CHANNEL ST | - | - | - | - | - | - |
| 86791 | N/A | Point | 1 | 1 | 1804 - 1896 | - | S247815 | 1800-1899 MARKET ST | 1804-1896 MARKET ST | F | F | - | F | 8760203 | 8760203 | - | - | SOUTH SIDE | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 79456 | 79456 | 37.77125261 | -122.4242868 | - | - | 1710539427000 | MTA | BIKE RACK | OCTAVIA ST to GUERRERO ST \ LAGUNA ST (1804 - 1896) -- NORTH -- | 27711 | 10' E OF PEARL ST/4' IN FROM CURB | - | - | - | - | - | 103975 | 1536064020000 | -122.4242868 | 37.77125261 | - | - | - | 08 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP3 | BIKE RACK | IS | 1534499760000 | MARKET ST | 1804 - 1896 MARKET ST | 1804 - 1896 MARKET ST | 1804 MARKET ST | - | GUERRERO ST \ LAGUNA ST | GUERRERO ST \ LAGUNA ST |
| 86792 | N/A | Point | - | - | - | - | S247430 | MARKET ST: ORD ST | - | F | F | - | F | 26163000 | 26163000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | ORD ST | MARKET ST | 80819 | 80819 | 37.76117789 | -122.44006866 | MARKET ST \ ORD ST | ORD ST \ MARKET ST | 1715291024000 | middleware_editor | PEDESTRIAN (SYM) | MARKET ST intersection | - | E-LINE OF ORD ST | - | - | - | - | - | 103976 | 1136332800000 | -122.44006866 | 37.76117789 | - | 1533168000000 | 1715238600000 | 08 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP3 | LIGHT POLE | RETD | 1533045540000 | ORD ST | - | - | - | - | - | - |
| 86793 | N/A | Point | 1 | 1 | 1804 - 1896 | - | S247825 | 1800-1899 MARKET ST | 1804-1896 MARKET ST | F | F | - | F | 8760203 | 8760203 | - | - | NORTH SIDE | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 80961 | 80961 | 37.77125261 | -122.4242868 | - | - | 1710539427000 | MTA | BIKE RACK | OCTAVIA ST to GUERRERO ST \ LAGUNA ST (1804 - 1896) -- NORTH -- | 27899 | 27'E OF WPL#1844/4' IN FROM CURB | - | - | - | - | - | 103977 | 1536580200000 | -122.4242868 | 37.77125261 | - | - | - | 08 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP3 | BIKE RACK | IS | 1534517820000 | MARKET ST | 1804 - 1896 MARKET ST | 1804 - 1896 MARKET ST | 1804 MARKET ST | - | GUERRERO ST \ LAGUNA ST | GUERRERO ST \ LAGUNA ST |
| 86794 | N/A | Point | - | - | - | - | S248926 | MARKET ST: ROMAIN ST | - | F | F | - | F | 26105000 | 26105000 | - | - | CENTER ISLAND, W LINE, NORTHBOUND | - | - | - | - | MARKET ST | MARKET ST | 81486 | 81486 | 37.75621849 | -122.44099876 | ROMAIN ST \ MARKET ST | ROMAIN ST \ MARKET ST | 1710539427000 | MTA | ONE WAY (RA) | MARKET ST intersection | - | F/W/B/T FROM ROMAIN ST | - | - | - | - | - | 103978 | 1540771200000 | -122.44099876 | 37.75621849 | - | - | - | 08 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP3 | RETAINING WALL | IS | 1539360420000 | ROMAIN ST | - | - | - | - | - | - |
| 86795 | N/A | Point | - | - | - | - | S250152 | BURROWS ST: BOWDOIN ST | - | F | F | - | F | 20913000 | 20913000 | - | - | NORTH EAST CORNER | - | - | - | - | BOWDOIN ST | BURROWS ST | 81531 | 81531 | 37.72702632 | -122.41100774 | BURROWS ST \ BOWDOIN ST | BOWDOIN ST \ BURROWS ST | 1710539427000 | MTA | BURROWS ST | BURROWS ST intersection | - | OF BURROWS ST & BOWDOIN ST. | - | - | - | - | - | 103979 | - | -122.41100774 | 37.72702632 | - | - | - | 09 | - | STREET NAME | GUIDE | D3-1.0289 | 36X08 | SUP3 | 3IN IRON POST | IS | 1544453820000 | BOWDOIN ST | - | - | - | - | - | - |
| 86796 | N/A | Point | - | - | - | - | S241999 | MARIPOSA ST: I-280 S ON RAMP | - | T | T | - | F | 52249000 | 52249000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | I-280 S ON RAMP | I-280 S ON RAMP | 82211 | 82211 | 37.7640556 | -122.39317381 | MARIPOSA ST: I-280 S ON RAMP | MARIPOSA ST \ I-280 S ON RAMP | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | I-280 S ON RAMP intersection | - | X ST IS I 280 OFFRAMP | - | - | - | - | - | 103980 | 1486512000000 | -122.39317381 | 37.7640556 | - | 1515110400000 | - | 10 | - | NO RIGHT TURN | REG | R13A(CA).0004 | 30X48 | SUP1 | SIGNAL POLE | IS | 1514970900000 | MARIPOSA ST | - | - | - | - | - | - |
| 86797 | N/A | Point | - | - | - | - | S239263 | MANSELL ST: JOHN F SHELLEY DR | - | T | T | - | F | 20945000 | 20945000 | - | - | NORTH WEST CORNER | - | - | - | - | MANSELL ST | JOHN F SHELLEY DR | 82284 | 82284 | 37.71876609 | -122.41851237 | JOHN F SHELLEY DR \ MANSELL ST | MANSELL ST \ JOHN F SHELLEY DR | 1710539427000 | MTA | MANSELL ST | JOHN F SHELLEY DR intersection | - | - | - | - | - | - | - | 103981 | - | -122.41851237 | 37.71876609 | - | - | - | 09 | - | STREET NAME | GUIDE | D3-1.1110 | 36X08 | SUP3 | LIGHT POLE | IS | 1507023000000 | MANSELL ST | - | - | - | - | - | - |
| 86798 | N/A | Point | - | - | - | - | S239264 | JOHN F SHELLEY DR: MANSELL ST | - | T | T | - | F | 20945000 | 20945000 | - | - | NORTH WEST CORNER | - | - | - | - | MANSELL ST | JOHN F SHELLEY DR | 82285 | 82285 | 37.71876609 | -122.41851237 | JOHN F SHELLEY DR \ MANSELL ST | MANSELL ST \ JOHN F SHELLEY DR | 1710539427000 | MTA | JOHN F SHELLEY DR | JOHN F SHELLEY DR intersection | - | - | - | - | - | - | - | 103982 | - | -122.41851237 | 37.71876609 | - | - | - | 09 | - | STREET NAME | GUIDE | D3-1.0930 | 36X08 | SUP3 | LIGHT POLE | IS | 1507023240000 | MANSELL ST | - | - | - | - | - | - |
| 86799 | N/A | Point | - | - | - | - | S214718 | - | - | NO | NO | - | - | - | - | - | - | SOUTH SIDE | 1691445421000 | MTA | - | - | DIVISADERO ST | - | 145203 | 145203 | 37.772097 | -122.438067 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-8PM MON-FRI EXC "Q' PERMITS | - | - | - | - | - | - | - | - | 103983 | - | -122.438067 | 37.772097 | - | - | 1687910400000 | 05 | - | PARKING:RPP | REG | R32C(CA).0216 | 18X21 | SUP2 | 2IN IRON POST | RETD | - | - | - | - | - | - | BRODERICK ST | - |
| 86800 | N/A | Point | - | - | - | - | S224221 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | - | - | 145227 | 145227 | 37.757834 | -122.418977 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 103984 | - | -122.418977 | 37.757834 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | - | - |
| 86801 | N/A | Point | - | - | - | - | S280624 | - | - | NO | NO | - | - | - | - | - | - | NORTH SIDE | 1691445421000 | MTA | - | - | WEBSTER ST | - | 145242 | 145242 | 37.773144 | -122.42981 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-8PM MON-FRI EXC "Q" OR "HV" PERMITS | - | - | - | - | - | - | - | - | 103985 | 1660694400000 | -122.42981 | 37.773144 | - | - | 1687737600000 | 05 | - | PARKING:RPP | REG | R32C(CA).0257 | 18X21 | SUP2 | LIGHT POLE | RETD | - | - | - | - | - | - | FILLMORE ST | - |
| 86802 | N/A | Point | - | - | - | - | S289095 | - | - | NO | NO | - | - | - | - | - | SHOULD BE RETIRED | CENTER ISLAND, NORTHBOUND TRAFFIC | 1691445421000 | MTA | - | - | VALENCIA ST | - | 145270 | 145270 | 37.759372 | -122.421355 | CUNNINGHAM PL \ VALENCIA ST | - | 1746135208000 | middleware_editor | BIKE LANE CLOSED | - | - | - | - | - | - | - | - | 103986 | - | -122.421355 | 37.759372 | - | - | - | 09 | - | BIKE REG | REG | R(SF).0490 | 24X24 | SUP3 | TYPE III BARRICADE | RETD | - | - | - | - | - | - | - | - |
| 86803 | N/A | Point | - | - | - | - | S124541 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | 14TH ST | - | 145303 | 145303 | 37.767474 | -122.419903 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 103987 | - | -122.419903 | 37.767474 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | 15TH ST | - |
| 86804 | N/A | Point | - | - | - | - | S124545 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | 14TH ST | - | 145304 | 145304 | 37.767474 | -122.419903 | - | - | 1734453931000 | middleware_editor | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 103988 | 1153440000000 | -122.419903 | 37.767474 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | IS | - | - | - | - | - | - | 15TH ST | - |
| 86805 | N/A | Point | - | - | - | - | S124551 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | 16TH ST | - | 145309 | 145309 | 37.76424 | -122.419591 | - | - | 1721697664000 | middleware_editor | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 103989 | 1153440000000 | -122.419591 | 37.76424 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | IS | - | - | - | - | - | - | 17TH ST | - |
| 86806 | N/A | Point | - | - | - | - | S124554 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | 18TH ST | - | 145312 | 145312 | 37.761036 | -122.419283 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 103990 | - | -122.419283 | 37.761036 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | 19TH ST | - |
| 86807 | N/A | Point | - | - | - | - | S124573 | - | - | NO | NO | - | - | - | - | - | - | WEST SIDE | 1691445421000 | MTA | - | - | 16TH ST | - | 145313 | 145313 | 37.76424 | -122.419591 | - | - | 1721697661000 | middleware_editor | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 103991 | - | -122.419591 | 37.76424 | - | - | 1653350400000 | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | RETD | - | - | - | - | - | - | 17TH ST | - |
| 86808 | N/A | Point | - | - | - | - | S124574 | - | - | NO | NO | - | - | - | - | - | - | WEST SIDE | 1691445421000 | MTA | - | - | 16TH ST | - | 145314 | 145314 | 37.76424 | -122.419591 | - | - | 1721697691000 | middleware_editor | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 103992 | - | -122.419591 | 37.76424 | - | - | 1653350400000 | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | RETD | - | - | - | - | - | - | 17TH ST | - |
| 86809 | N/A | Point | 1 | 1 | 501 - 599 | - | S264147 | PNDG MARKET ST | 501-599 MARKET ST | F | F | - | T | 8742101 | 8742101 | - | - | CENTER ISLAND | - | - | - | - | 01ST ST \ BUSH ST | 01ST ST \ BUSH ST | 103802 | 103802 | 37.79010997 | -122.40022309 | - | - | 1710539427000 | MTA | MUNI LANDOR FLAG - TYPE 6 | 01ST ST \ BUSH ST to 02ND ST (501 - 599) -- SOUTH -- | 17264 | BUS ISLAND | - | - | - | - | - | 103993 | 1431475200000 | -122.40022309 | 37.79010997 | - | 1431475200000 | - | 06 | - | OTHER REGULATORY | REG | R(SF).0334 | 15X39 | SUP1 | UNISTRUT | IS | 1589285220000 | MARKET ST | PNDG MARKET ST | 501 - 599 MARKET ST | - | - | 02ND ST | 02ND ST |
| 86810 | N/A | Point | - | - | - | - | S257808 | CHANNEL ST: 4TH ST | - | T | T | - | F | 34167000 | 34167000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 4TH ST | CHANNEL ST | 103937 | 103937 | 37.77432755 | -122.39163414 | CHANNEL ST \ 4TH ST | 04TH ST \ CHANNEL ST | 1710539427000 | MTA | CHANNEL ST | CHANNEL ST intersection | - | X-STREET IS CHANNEL ST. | - | - | - | - | - | 103994 | 1570449960000 | -122.39163414 | 37.77432755 | - | - | - | 06 | - | STREET NAME | GUIDE | D3-2.0108 | 72X18 | SUP1 | LIGHT POLE | IS | 1568722260000 | 04TH ST | - | - | - | - | - | - |
| 86811 | N/A | Point | - | - | - | - | S255825 | CHANNEL ST: 4TH ST | - | F | F | - | F | 34167000 | 34167000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | 4TH ST | CHANNEL ST | 104145 | 104145 | 37.77432755 | -122.39163414 | CHANNEL ST \ 4TH ST | 04TH ST \ CHANNEL ST | 1710539427000 | MTA | DELINEATOR (Y) (SAFE HIT) | CHANNEL ST intersection | - | STARTING@CRSSWLK 96FT WEST/ 12FT OC | - | - | - | - | - | 103995 | 1562596560000 | -122.39163414 | 37.77432755 | - | - | - | 06 | - | DELINEATOR 5 | WARNING | TYPE-DL.0002 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1562167620000 | 04TH ST | - | - | - | - | - | - |
| 86812 | N/A | Point | - | - | - | - | S268350 | BANBURY DR: 19TH AVE | - | F | F | - | F | 23006000 | 23006000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 19TH AVE | 19TH AVE | 104823 | 104823 | 37.71957477 | -122.47467711 | BANBURY DR \ 19TH AVE | BANBURY DR \ 19TH AVE | 1729127818000 | middleware_editor | ONE WAY (LA) | 19TH AVE intersection | - | X-STREET IS 19TH AVE. | - | - | - | - | - | 103996 | 1242086400000 | -122.47467711 | 37.71957477 | - | - | - | 07 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP3 | 2IN IRON POST | IS | 1600781040000 | BANBURY DR | - | - | - | - | - | - |
| 86813 | N/A | Point | 1 | 1 | 801 - 863 | - | S217549 | 800-899 MARKET ST | 801-863 MARKET ST | F | F | - | F | 8747102 | 8747102 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 4TH ST \ ELLIS ST \ STOCKTON ST | 04TH ST \ ELLIS ST \ STOCKTON ST | 105417 | 105417 | 37.78512171 | -122.40654805 | - | - | 1710539427000 | MTA | LEFT LANE BUSES TAXI ONLY AT ALL TIMES | 04TH ST \ ELLIS ST \ STOCKTON ST to POWELL ST (801 - 863) -- SOUTH -- | - | INFO #768 | - | - | - | - | - | 103997 | 1465995900000 | -122.40654805 | 37.78512171 | - | 1465948800000 | - | 06 | - | TRANSIT ONLY(LEFT LANE) | REG | SR60-4(CA).0002 | 30X42 | SUP1 | LIGHT POLE | IS | 1435674540000 | MARKET ST | 801 - 863 MARKET ST | 801 - 863 MARKET ST | 801 MARKET ST | - | POWELL ST | POWELL ST |
| 86814 | N/A | Point | - | - | - | - | S277956 | 7TH ST: MISSION BAY DR | - | T | T | - | F | 34186000 | 34186000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MISSION BAY DR | 07TH ST | 105507 | 105507 | 37.76939087 | -122.39861749 | 7TH ST \ MISSION BAY DR | MISSION BAY DR \ 07TH ST | 1727187035000 | middleware_editor | NO RIGHT TURN (SYM) ON RED ARROW | 07TH ST intersection | - | X ST IS MISSION BAY DR. | - | - | - | - | - | 103998 | 1490140800000 | -122.39861749 | 37.76939087 | - | 1634083200000 | - | 06 | - | NO RIGHT TURN | REG | R13A(SF).0006 | 24X30 | SUP1 | SIGNAL POLE | IS | 1632829740000 | MISSION BAY DR | - | - | - | - | - | - |
| 86815 | N/A | Point | - | - | - | - | S235442 | EGBERT AVE: END | - | F | F | - | F | 50878000 | 50878000 | - | - | SOUTH EAST CORNER | - | - | - | - | START: 1700-1798 BLOCK | START: 1700-1798 BLOCK | 105579 | 105579 | 37.72619352 | -122.39657588 | EGBERT AVE \ START: 1700-1798 BLOCK | EGBERT AVE \ START: 1700-1798 BLOCK | 1710539427000 | MTA | G ST (TI) | START: 1700-1798 BLOCK intersection | - | EGBERT (NORTH) CROSS ST. IS G ST | - | - | - | - | - | 103999 | 1492505760000 | -122.39657588 | 37.72619352 | - | 1492473600000 | - | 10 | - | STREET NAME | GUIDE | D3-1.1921 | 36X08 | SUP1 | LIGHT POLE | IS | 1492698000000 | EGBERT AVE | - | - | - | - | - | - |
| 86816 | N/A | Point | - | - | - | - | S287127 | MANSELL ST: JOHN F SHELLEY DR | - | T | T | - | F | 20945000 | 20945000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | MANSELL ST | JOHN F SHELLEY DR | 105853 | 105853 | 37.71876609 | -122.41851237 | JOHN F SHELLEY DR \ MANSELL ST | MANSELL ST \ JOHN F SHELLEY DR | 1710539427000 | MTA | SPEED LIMIT 30 | JOHN F SHELLEY DR intersection | - | WEST C.I @ JOHN F SHELLY WEST | - | - | - | - | - | 104000 | 1674172800000 | -122.41851237 | 37.71876609 | - | - | - | 09 | - | SPEED LIMIT | REG | R2-1.0009 | 36X45 | SUP3 | LIGHT POLE | IS | 1674138900000 | MANSELL ST | - | - | - | - | - | - |
| 86817 | N/A | Point | - | - | - | - | S261922 | MANSELL ST: BRAZIL AVE | - | T | T | - | F | 33338000 | 33338000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | MANSELL ST | BRAZIL AVE | 106156 | 106156 | 37.71788738 | -122.42247299 | BRAZIL AVE \ MANSELL ST | MANSELL ST \ BRAZIL AVE | 1710539427000 | MTA | BIKE WAYFINDING SIGN | BRAZIL AVE intersection | 1465 | CROSS STREET IS BRAZILBOVE SIGN AND BOX | - | - | - | - | - | 104001 | 1583405340000 | -122.42247299 | 37.71788738 | - | - | - | 10 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | LIGHT POLE | IS | 1582713840000 | MANSELL ST | - | - | - | - | - | - |
| 86818 | N/A | Point | - | - | - | - | S100028 | ESTERO AVE: JUNIPERO SERRA BLV | - | F | F | - | F | 33415000 | 33415000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | JUNIPERO SERRA BLVD | ESTERO AVE | 106650 | 106650 | 37.72375411 | -122.47212511 | ESTERO AVE \ JUNIPERO SERRA BLVD | JUNIPERO SERRA BLVD \ ESTERO AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) | ESTERO AVE intersection | - | 0 / 0 | - | - | - | - | - | 104002 | -407635200000 | -122.47212511 | 37.72375411 | - | - | - | 07 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP3 | UNKNOWN | IS | 1373566320000 | JUNIPERO SERRA BLVD | - | - | - | - | - | - |
| 86819 | N/A | Point | - | - | - | - | S252815 | LINCOLN BLVD: LETTERMAN DR \ P | - | T | T | - | F | 51243000 | 51243000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LETTERMAN DR \ PRESIDIO BLVD | LINCOLN BLVD \ PRESIDIO BLVD | 107621 | 107621 | 37.79918292 | -122.4526076 | LINCOLN BLVD \ LETTERMAN DR \ PRESIDIO BLVD | LETTERMAN DR \ LINCOLN BLVD \ PRESIDIO BLVD | 1710539427000 | MTA | 49 MILE SCENIC DRIVE | LINCOLN BLVD \ PRESIDIO BLVD intersection | - | PERSIDEO / LINCOLN AND LETTERMAN | - | - | - | - | - | 104003 | - | -122.4526076 | 37.79918292 | - | - | - | 02 | - | OTHER GUIDE | GUIDE | G-X(SF).0043 | 30X36 | SUP2 | LIGHT POLE | IS | 1553768760000 | LETTERMAN DR | - | - | - | - | - | - |
| 86820 | N/A | Point | - | - | - | - | S272968 | MANSELL ST: JOHN F SHELLEY DR | - | T | T | - | F | 20945000 | 20945000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | MANSELL ST | JOHN F SHELLEY DR | 107811 | 107811 | 37.71876609 | -122.41851237 | JOHN F SHELLEY DR \ MANSELL ST | MANSELL ST \ JOHN F SHELLEY DR | 1710539427000 | MTA | SPEED HUMP | JOHN F SHELLEY DR intersection | - | OPP.C-LINE/ JOHN F SHELLEY EAST | - | - | - | - | - | 104004 | 1616151240000 | -122.41851237 | 37.71876609 | - | - | - | 09 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP3 | LIGHT POLE | IS | 1614939600000 | MANSELL ST | - | - | - | - | - | - |
| 86821 | N/A | Point | - | - | - | - | S272969 | MANSELL ST: JOHN F SHELLEY DR | - | T | T | - | F | 20945000 | 20945000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | MANSELL ST | JOHN F SHELLEY DR | 107812 | 107812 | 37.71876609 | -122.41851237 | JOHN F SHELLEY DR \ MANSELL ST | MANSELL ST \ JOHN F SHELLEY DR | 1710539427000 | MTA | 25 MPH (ADV SPEED) | JOHN F SHELLEY DR intersection | - | OPP.C-LINE/ JOHN F SHELLEY EAST | - | - | - | - | - | 104005 | 1616151420000 | -122.41851237 | 37.71876609 | - | - | - | 09 | - | SPEED LIMIT | WARNING | W13-1P.0009 | 30X30 | SUP3 | LIGHT POLE | IS | 1614939660000 | MANSELL ST | - | - | - | - | - | - |
| 86822 | N/A | Point | - | - | - | - | S261366 | RICHLAND AVE: MIGUEL ST | - | F | F | - | F | 54234000 | 54234000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | RICHLAND AVE | RICHLAND AVE | 108199 | 108199 | 37.73652838 | -122.42699074 | MIGUEL ST \ RICHLAND AVE | MIGUEL ST \ RICHLAND AVE | 1710539427000 | MTA | BIKE WAYFINDING SIGN | RICHLAND AVE intersection | 1379 | WPL #19 | - | - | - | - | - | 104006 | 1405382400000 | -122.42699074 | 37.73652838 | - | 1582502400000 | - | 08 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP3 | UTILITY POLE | IS | 1581504420000 | MIGUEL ST | - | - | - | - | - | - |
| 86823 | N/A | Point | - | - | - | - | S278343 | SUNRISE WAY: END | - | F | F | - | F | 51044000 | 51044000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | START: 324-399 BLOCK | START: 324-399 BLOCK | 108329 | 108329 | 37.70957921 | -122.41551859 | SUNRISE WAY \ START: 324-399 BLOCK | SUNRISE WAY \ START: 324-399 BLOCK | 1710539427000 | MTA | SIDEWALK CLOSED - CROSS HERE (RA) | START: 324-399 BLOCK intersection | - | X ST IS MALOSI | - | - | - | - | - | 104007 | 1635811200000 | -122.41551859 | 37.70957921 | - | - | - | 10 | - | OTHER REGULATORY | REG | R(SF).0238 | 36X18 | SUP1 | 2 POST ALUMINUM | IS | 1634638140000 | SUNRISE WAY | - | - | - | - | - | - |
| 86824 | N/A | Point | 1 | 1 | 1400 - 1498 | - | S244170 | 1400-1498 MARKET ST | 1400-1498 MARKET ST | F | F | - | F | 8754201 | 8754201 | - | - | NORTH SIDE | - | - | - | - | 10TH ST \ FELL ST \ POLK ST | 10TH ST \ FELL ST \ POLK ST | 108579 | 108579 | 37.77587096 | -122.41841244 | - | - | 1710539427000 | MTA | TANSAT | 10TH ST \ FELL ST \ POLK ST to SOUTH VAN NESS AVE \ VAN NESS AVE (1400 - 1498) -- NORTH -- | - | 235' W OF FELL ST | - | - | - | - | - | 104008 | 1523974260000 | -122.41841244 | 37.77587096 | - | 1523923200000 | - | 06 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | MUNI POLE | IS | 1522245120000 | MARKET ST | 1400 - 1498 MARKET ST | 1400 - 1498 MARKET ST | 1400 MARKET ST | - | SOUTH VAN NESS AVE \ VAN NESS AVE | SOUTH VAN NESS AVE \ VAN NESS AVE |
| 86825 | N/A | Point | - | - | - | - | S278208 | 15TH AVE: PORTOLA DR | - | T | T | - | F | 22939000 | 33004000 | - | - | SOUTH WEST CORNER | - | - | - | - | SAN FERNANDO WAY | 15TH AVE | 108721 | 108721 | 37.736074208 | -122.469813153 | PORTOLA DR \ SAN FERNANDO WAY | PORTOLA DR \ 15TH AVE | 1710539427000 | MTA | 15TH AVE | 15TH AVE intersection | - | 15TH AVE//SAN FERNANDO/PORTOLA | - | - | - | - | - | 104009 | 1634134260000 | -122.46994154 | 37.7361868 | - | 1634083200000 | - | 07 | - | STREET NAME | GUIDE | D3-1.0005 | 36X08 | SUP3 | LIGHT POLE | IS | 1634134080000 | PORTOLA DR | - | - | - | - | - | - |
| 86826 | N/A | Point | - | - | - | RIGHT ARROW | 21162 | - | - | F | F | - | F | 10620202 | - | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1689617234000 | elclark | - | - | DORCHESTER WAY | - | 141857 | 141857 | 37.739974706 | -122.464075873 | - | - | 1710539427000 | MTA | ONE WAY (RA) | - | - | CI PORTOLA FACING NORTHBOUND SAN LORENZOSAN LORENZO | - | - | - | - | - | 104010 | 1690465800000 | - | - | - | - | - | 07 | DIAMOND GRADE (TYPE XI OMNICUBE WITH OL-1000 ANTI GRAFFITI OVERLAY FILM) | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP3 | LIGHT POLE | IS | - | PORTOLA DR | 1300 - 1366 PORTOLA DR | - | - | - | CLAREMONT BLVD \ PORTAL PATH | - |
| 86827 | N/A | Point | - | - | - | - | 21168 | - | - | - | - | - | - | 10619201 | - | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | 1689618795000 | elclark | - | - | KENSINGTON WAY \ MIRALOMA DR | - | 141875 | 141875 | 37.740608568 | -122.459429817 | - | - | 1710539427000 | MTA | RIGHT TURN ONLY (SYM) | - | - | CI KENSINTGON/PORTOLA FACING SOUTHBOUND KENSINGTON | - | - | - | - | - | 104011 | 1690195620000 | - | - | - | - | - | 07 | - | OTHER REGULATORY | REG | R3-5.0001 | 24X30 | SUP3 | 3IN IRON POST | IS | - | PORTOLA DR | 1100 - 1198 PORTOLA DR | - | - | - | GRANVILLE WAY \ SAN PABLO AVE | - |
| 86828 | N/A | Point | - | - | - | - | 21181 | - | - | F | F | - | F | 13072000 | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1689624889000 | jsanfel | - | - | 23RD ST | - | 141879 | 141879 | 37.753528573 | -122.420897435 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | - | - | 40' south of 23rd | - | - | - | - | - | 104012 | - | - | - | - | - | - | 09 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP3 | 2IN IRON POST | PI | - | VALENCIA ST | 1200 - 1299 VALENCIA ST | - | - | - | 24TH ST | - |
| 86829 | N/A | Point | - | - | - | - | 21182 | - | - | - | F | - | - | 12726000 | - | - | - | SOUTH SIDE, WESTBOUND TRAFFIC | 1689625202000 | APADILLA | - | - | GOUGH ST | - | 141880 | 141880 | 37.781296503 | -122.42548136 | - | - | 1710539427000 | MTA | (45 RA-DN) | - | - | 400FT WEST OF GOUGH | - | - | - | - | - | 104013 | - | - | - | - | - | - | 05 | - | OTHER WARNING | WARNING | W16-7P.0006 | 24X12 | SUP2 | 2IN IRON POST | PI | - | TURK ST | 900 - 1099 TURK ST | - | - | - | LAGUNA ST | - |
| 86830 | N/A | Point | - | - | - | - | 21224 | - | - | - | - | - | - | - | - | - | - | - | 1689785977000 | gorr | - | - | - | - | 141987 | 141987 | 37.725037576 | -122.390947373 | - | - | 1710539427000 | MTA | NPRK 6:30AM-8:00AM MON STCL | - | - | - | - | - | - | - | - | 104015 | - | - | - | - | - | - | 10 | - | PARKING | REG | R30B(CA).0338 | 18X18 | SUP1 | - | RETD | - | - | - | - | - | - | - | - |
| 86831 | N/A | Point | - | - | - | - | 21226 | - | - | - | - | - | - | - | - | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | 1689786614000 | malopez | - | - | - | - | 142006 | 142006 | 37.74740137 | -122.469466634 | - | - | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | - | - | CENTER ISLANS OPP/2183. 2188 | - | - | - | - | 1 | 104016 | 1690382340000 | - | - | - | - | - | 07 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP3 | 2IN IRON POST | IS | - | - | - | - | - | - | - | - |
| 86832 | N/A | Point | - | - | - | - | 21239 | - | - | F | F | - | F | 2145000 | - | - | - | EAST SIDE | 1689788804000 | MMENDIET | - | - | 16TH ST | - | 142027 | 142027 | 37.764678879 | -122.422790473 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | - | - | 28' SOUTH OF 16 TH ST | - | - | - | - | - | 104017 | - | - | - | - | - | - | 09 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP3 | 2IN IRON POST | PI | - | ALBION ST | 100 - 149 ALBION ST | - | - | - | CAMP ST | - |
| 86833 | N/A | Point | - | - | - | - | S100012 | STRATFORD DR: JUNIPERO SERRA B | - | F | F | - | F | 33448000 | 33448000 | - | - | NORTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JUNIPERO SERRA BLVD | STRATFORD DR | 529 | 529 | 37.71857704 | -122.47260417 | STRATFORD DR \ JUNIPERO SERRA BLVD | JUNIPERO SERRA BLVD \ STRATFORD DR | 1710539427000 | MTA | NO LEFT TURN (SYM) | STRATFORD DR intersection | - | 0 / 00 | - | - | - | - | - | 104018 | -407721600000 | -122.47260417 | 37.71857704 | - | - | - | 11 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP3 | UNKNOWN | IS | 1373566320000 | JUNIPERO SERRA BLVD | - | - | - | - | - | - |
| 86834 | N/A | Point | - | - | - | - | S100225 | GREAT HWY: SLOAT BLVD | - | F | F | - | F | 23496000 | 32904000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GREAT HWY | GREAT HWY | 1034 | 1034 | 37.7356671658895 | -122.506007505375 | SLOAT BLVD \ GREAT HWY | SLOAT BLVD \ GREAT HWY | 1756421788000 | middleware_editor | STOP | GREAT HWY intersection | - | NWC LOWER GRT HWY / SLOAT | - | - | - | - | - | 104019 | -404841600000 | -122.50671743 | 37.73546976 | - | 1756399800000 | - | 07 | - | STOP | REG | R1-1.0002 | 30X30 | SUP3 | 2IN IRON POST | IS | 1373566380000 | SLOAT BLVD | - | - | - | - | - | - |
| 86835 | N/A | Point | - | - | - | - | S104253 | JUNIPERO SERRA BLVD: ESTERO AV | - | F | F | - | F | 33416000 | 33416000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ESTERO AVE | ESTERO AVE | 1510 | 1510 | 37.72374353 | -122.4718698 | JUNIPERO SERRA BLVD \ ESTERO AVE | JUNIPERO SERRA BLVD \ ESTERO AVE | 1710539427000 | MTA | ONE WAY (RA) | ESTERO AVE intersection | - | 100W / 0 | - | - | - | - | - | 104020 | -34041600000 | -122.4718698 | 37.72374353 | - | - | - | 07 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP3 | UNKNOWN | IS | 1373568840000 | JUNIPERO SERRA BLVD | - | - | - | - | - | - |
| 86836 | N/A | Point | - | - | - | - | S109689 | GREAT HWY: SLOAT BLVD | - | F | F | - | F | 32904000 | 32904000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SLOAT BLVD | GREAT HWY | 6612 | 6612 | 37.7353211801568 | -122.506554722781 | GREAT HWY \ SLOAT BLVD | SLOAT BLVD \ GREAT HWY | 1738353079000 | middleware_editor | DO NOT ENTER | GREAT HWY intersection | - | 0 / 00 | - | - | - | - | - | 104021 | 538617600000 | -122.50671743 | 37.73546976 | - | 1578441600000 | - | 07 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP3 | 2IN IRON POST | IS | 1373570580000 | SLOAT BLVD | - | - | - | - | - | - |
| 86837 | N/A | Point | - | - | - | - | S109801 | JUNIPERO SERRA BLVD: STONECRES | - | F | F | - | F | 23064000 | 23064000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | STONECREST DR | STONECREST DR | 6776 | 6776 | 37.72881084 | -122.47225691 | JUNIPERO SERRA BLVD \ STONECREST DR | JUNIPERO SERRA BLVD \ STONECREST DR | 1729694452000 | middleware_editor | STOP | STONECREST DR intersection | - | 0 / SERVICE ROAD WEST SIDE | - | - | - | - | - | 104022 | 556329600000 | -122.47225691 | 37.72881084 | - | 1667174400000 | - | 07 | - | STOP | REG | R1-1.0002 | 30X30 | SUP3 | 2IN IRON POST | IS | 1373570580000 | JUNIPERO SERRA BLVD | - | - | - | - | - | - |
| 86838 | N/A | Point | 1 | 1 | 700 - 799 | - | S112701 | 700-773 4TH ST | 700-799 04TH ST | F | F | - | F | 267001 | 267001 | - | - | WEST SIDE | - | - | - | - | TOWNSEND ST | TOWNSEND ST | 9125 | 9125 | 37.77671116 | -122.39450827 | - | - | 1710539427000 | MTA | RIGHT LANE TO I-280(SYM) ONLY | TOWNSEND ST to KING ST (700 - 799) | - | 60N / OF KING | - | - | - | - | - | 104023 | 959299200000 | -122.39450827 | 37.77671116 | - | - | - | 06 | - | OTHER GUIDE | GUIDE | G-R(SF).0002 | 36X36 | SUP1 | 2IN IRON POST | IS | 1373571540000 | 04TH ST | 700-773 4TH ST | 700 - 799 04TH ST | - | - | KING ST | KING ST |
| 86839 | N/A | Point | - | - | - | - | S111353 | JUNIPERO SERRA BLVD: ESTERO AV | - | F | F | - | F | 33416000 | 33416000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ESTERO AVE | ESTERO AVE | 10269 | 10269 | 37.72374353 | -122.4718698 | JUNIPERO SERRA BLVD \ ESTERO AVE | JUNIPERO SERRA BLVD \ ESTERO AVE | 1710539427000 | MTA | STOP | ESTERO AVE intersection | - | 5S / EAST SIDE OF SERVICE ROAD | - | - | - | - | - | 104024 | 782352000000 | -122.4718698 | 37.72374353 | - | 1601424000000 | - | 07 | - | STOP | REG | R1-1.0002 | 30X30 | SUP3 | 2IN IRON POST | IS | 1373571120000 | JUNIPERO SERRA BLVD | - | - | - | - | - | - |
| 86840 | N/A | Point | - | - | - | - | S119281 | 4TH ST: CHANNEL ST | - | F | F | - | F | 50385000 | 50385000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CHANNEL ST | CHANNEL ST | 13313 | 13313 | 37.77468036 | -122.39191151 | 4TH ST \ CHANNEL ST | 04TH ST \ CHANNEL ST | 1710539427000 | MTA | NO LEFT TURN (SYM) AFTER BALL PARK EVENTS | CHANNEL ST intersection | - | 0 / NEXT TO TYPE N SIGN/SEE PHOTO A..... | - | - | - | - | - | 104025 | 1090972800000 | -122.39191151 | 37.77468036 | - | - | - | 06 | - | NO LEFT TURN | REG | R3-2(SF).0001 | 30X42 | SUP1 | 2IN IRON POST | IS | 1373573580000 | 04TH ST | - | - | - | - | - | - |
| 86841 | N/A | Point | 1 | 1 | 500 - 599 | - | S120144 | 500-599 DE LONG ST | 500-599 DE LONG ST | F | F | - | F | 4655000 | 4655000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SAN DIEGO AVE | SAN DIEGO AVE | 16053 | 16053 | 37.708258892 | -122.466906835 | - | - | 1710539427000 | MTA | SPEED HUMP | SAN DIEGO AVE to COUNTY LINE (500 - 599) | - | 20' E OF SANDIEGO | - | - | - | - | - | 104026 | 1105660800000 | -122.4670177 | 37.70816128 | - | - | - | 11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP3 | 2IN IRON POST | IS | 1373573880000 | DE LONG ST | 500 - 599 DE LONG ST | 500 - 599 DE LONG ST | 500 DE LONG ST | - | COUNTY LINE | COUNTY LINE |
| 86842 | N/A | Point | 1 | - | - | - | S122576 | 1-299 TELEGRAPH HILL BLVD | - | F | F | - | F | 12479000 | 12479000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | - | - | 16794 | 16794 | 37.80258264 | -122.40606944 | - | - | 1710539427000 | MTA | PEDESTRIAN (SYM) XING/(45 LA-DN) | - | - | 60'SOUTH OF SPL # 201 @ X-WALK | - | - | - | - | - | 104027 | 1138320000000 | -122.40606944 | 37.80258264 | - | - | - | 03 | - | PEDESTRIAN(LA DN) | WARNING | W11-2+SW44(CA).01 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373574600000 | TELEGRAPH HILL BLVD | 1-299 TELEGRAPH HILL BLVD | TELEGRAPH HILL BLVD | - | - | - | - |
| 86843 | N/A | Point | 1 | 1 | 950 - 999 | - | S124050 | 950-999 3RD ST | 950-999 03RD ST | F | F | - | F | 183000 | 183000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | MISSION CREEK | MISSION CREEK | 16921 | 16921 | 37.77651933 | -122.39009021 | - | - | 1710539427000 | MTA | NO U TURN (SYM) | MISSION CREEK to TERRY A FRANCOIS BLVD (950 - 999) | - | SOUTH CENTER ISLAND BELOW LEFT TURN..... | - | - | - | - | - | 104028 | 1150070400000 | -122.39009021 | 37.77651933 | - | - | - | 06 | - | OTHER REGULATORY | REG | R3-4.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1373575080000 | 03RD ST | 950 - 999 3RD ST | 950 - 999 03RD ST | 950 3RD ST | - | TERRY A FRANCOIS BLVD | TERRY A FRANCOIS BLVD |
| 86844 | N/A | Point | - | - | - | - | S123223 | MANSELL ST: VISITACION AVE | - | F | F | - | F | 33350000 | 33350000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VISITACION AVE | VISITACION AVE | 17874 | 17874 | 37.7187541 | -122.41167332 | MANSELL ST \ VISITACION AVE | MANSELL ST \ VISITACION AVE | 1730737698000 | middleware_editor | STOP AHEAD (SYM) | VISITACION AVE intersection | - | - | - | - | - | - | - | 104029 | 1143676800000 | -122.41167332 | 37.7187541 | - | - | - | 09 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP3 | 3IN IRON POST | IS | 1373574840000 | MANSELL ST | - | - | - | - | - | - |
| 86845 | N/A | Point | 1 | 1 | 950 - 999 | - | S124102 | 950-999 3RD ST | 950-999 03RD ST | F | F | - | F | 183000 | 183000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | MISSION CREEK | MISSION CREEK | 19489 | 19489 | 37.77651933 | -122.39009021 | - | - | 1710539427000 | MTA | NO U TURN (SYM) | MISSION CREEK to TERRY A FRANCOIS BLVD (950 - 999) | - | NORTH CENTER ISLAND BELOW TRAIN SIGNAL | - | - | - | - | - | 104030 | 1150243200000 | -122.39009021 | 37.77651933 | - | - | - | 06 | - | OTHER REGULATORY | REG | R3-4.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1373575080000 | 03RD ST | 950 - 999 3RD ST | 950 - 999 03RD ST | 950 3RD ST | - | TERRY A FRANCOIS BLVD | TERRY A FRANCOIS BLVD |
| 86846 | N/A | Point | - | - | - | - | S288939 | - | - | NO | NO | - | - | - | - | - | SHOULD BE RETIRED | CENTER ISLAND, N LINE, NORTHBOUND | 1691445421000 | MTA | - | - | - | - | - | 145250 | 37.753703 | -122.420812 | - | - | 1710875389000 | middleware_editor | BIKE LANE CLOSED | - | - | - | - | - | - | - | - | 104031 | - | -122.420812 | 37.753703 | - | - | - | 09 | - | BIKE REG | REG | R(SF).0490 | 24X24 | SUP3 | TYPE III BARRICADE | RETD | - | - | - | - | - | - | - | - |
| 86847 | N/A | Point | - | - | - | - | S119582 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | 25TH ST | - | 145296 | 145296 | 37.74984 | -122.418212 | - | - | 1756936530000 | middleware_editor | NO DBL PRK ANY TIME DBL FINE ZONE $100 FINE IMPOSED ETC | - | - | - | - | - | - | - | - | 104032 | 1097737200000 | -122.418212 | 37.74984 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0001 | 18X21 | SUP3 | LIGHT POLE | IS | - | - | - | - | - | - | 26TH ST | - |
| 86848 | N/A | Point | - | - | - | - | S119606 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | 21ST ST | - | 145297 | 145297 | 37.756236 | -122.418824 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $100 FINE IMPOSED ETC | - | - | - | - | - | - | - | - | 104033 | - | -122.418824 | 37.756236 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0001 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | 22ND ST | - |
| 86849 | N/A | Point | - | - | - | - | S119620 | - | - | NO | NO | - | - | - | - | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | 1691445421000 | MTA | - | - | 23RD ST | - | 145300 | 145300 | 37.754692 | -122.39958 | CAROLINA ST \ 23RD ST | - | 1735664204000 | middleware_editor | SCHOOL (SYM) | - | - | - | - | - | - | - | - | 104034 | 1098748800000 | -122.39958 | 37.754692 | - | 1476662400000 | - | 10 | - | SCHOOL | WARNING | S1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | - | - | - | - | - | - | - | - |
| 86850 | N/A | Point | - | - | - | - | S124540 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | 14TH ST | - | 145302 | 145302 | 37.767474 | -122.419903 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 104035 | - | -122.419903 | 37.767474 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | 15TH 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 metersMetadata automatically harvested from the ESRI service during import.