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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100876 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S121769 | 1800-1899 32ND AVE | 1800-1899 32ND AVE | F | F | - | F | 1713000 | 1713000 | - | - | EAST SIDE | - | - | - | - | NORIEGA ST | NORIEGA ST | 20041 | 20041 | 37.75269261 | -122.4903355 | - | - | 1710539427000 | MTA | TANS EXC 30 MIN 6 WHEEL TL 7AM-6PM MON-SAT | NORIEGA ST to ORTEGA ST (1800 - 1899) | - | 22`NORTH (PLUS DA) | - | - | - | - | - | 118149 | 1128643200000 | -122.4903355 | 37.75269261 | - | - | - | D4 | - | OTHER REGULATORY | REG | R37(SF).0152 | 10X15 | SUP2 | 2IN IRON POST | IS | 1373574360000 | 32ND AVE | 1800 - 1899 32ND AVE | 1800 - 1899 32ND AVE | 1800 32ND AVE | - | ORTEGA ST | ORTEGA ST |
| 100877 | N/A | Point | 1 | 1 | 300 - 399 | - | S209516 | 300-399 HAYES ST | 300-399 HAYES ST | F | F | - | F | 6815000 | 6815000 | - | - | SOUTH SIDE | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 50741 | 50741 | 37.77698725 | -122.42215429 | - | - | 1710539427000 | MTA | BIKE RACK | FRANKLIN ST to GOUGH ST (300 - 399) | - | IFO # 377 28" FROM CURB @W PM | - | - | - | - | - | 118150 | 1423039200000 | -122.42215429 | 37.77698725 | - | 1423008000000 | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | 2IN FLANGE POST | IS | 1411725180000 | HAYES ST | 300 - 399 HAYES ST | 300 - 399 HAYES ST | 300 HAYES ST | - | GOUGH ST | GOUGH ST |
| 100878 | N/A | Point | 1 | 1 | 3200 - 3299 | - | S149256 | 3200-3299 OCEAN AVE | 3200-3299 OCEAN AVE | F | F | - | F | 9856000 | 9856000 | - | - | NORTH SIDE | - | - | - | - | 24TH AVE | 24TH AVE | 38108 | 38108 | 37.73249062 | -122.48055245 | - | - | 1748532859000 | middleware_editor | NPRK 8AM-10AM 2ND & 4TH THUR OF MONTH STCL | 24TH AVE to 25TH AVE (3200 - 3299) | - | 127 FEET WEST OF 24TH AVE | - | - | - | - | - | 118151 | 1225350000000 | -122.48055245 | 37.73249062 | - | 1748470200000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0256 | 18X18 | SUP2 | LIGHT POLE | IS | 1375729200000 | OCEAN AVE | 3200 - 3299 OCEAN AVE | 3200 - 3299 OCEAN AVE | 3200 OCEAN AVE | - | 25TH AVE | 25TH AVE |
| 100879 | N/A | Point | - | - | - | - | S119000 | OCTAVIA ST: VALLEJO ST | - | F | F | - | F | 26575000 | 26575000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VALLEJO ST | VALLEJO ST | 15118 | 15118 | 37.79606289 | -122.42853781 | OCTAVIA ST \ VALLEJO ST | OCTAVIA ST \ VALLEJO ST | 1710539427000 | MTA | ALL WAY | VALLEJO ST intersection | - | SECORNER | - | - | - | - | - | 118152 | 1086307200000 | -122.42853781 | 37.79606289 | - | 1451952000000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373573520000 | OCTAVIA ST | - | - | - | - | - | - |
| 100880 | N/A | Point | - | - | - | - | S104468 | OCTAVIA ST: VALLEJO ST | - | F | F | - | F | 26575000 | 26575000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VALLEJO ST | VALLEJO ST | 3687 | 3687 | 37.79606289 | -122.42853781 | OCTAVIA ST \ VALLEJO ST | OCTAVIA ST \ VALLEJO ST | 1710539427000 | MTA | STOP | VALLEJO ST intersection | - | 0 / 0 | - | - | - | - | - | 118153 | 1036800000 | -122.42853781 | 37.79606289 | - | 1452124800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568960000 | OCTAVIA ST | - | - | - | - | - | - |
| 100881 | N/A | Point | - | - | - | - | S119020 | VALLEJO ST: OCTAVIA ST | - | F | F | - | F | 26575000 | 26575000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VALLEJO ST | VALLEJO ST | 14207 | 14207 | 37.79606289 | -122.42853781 | OCTAVIA ST \ VALLEJO ST | OCTAVIA ST \ VALLEJO ST | 1712877415000 | middleware_editor | ALL WAY | VALLEJO ST intersection | - | 4' W OF SIDEWALK | - | - | - | - | - | 118154 | 1086652800000 | -122.42853781 | 37.79606289 | - | 1712846340000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373573520000 | OCTAVIA ST | - | - | - | - | - | - |
| 100882 | N/A | Point | - | - | - | - | S100382 | 29TH AVE: LINCOLN WAY | - | F | F | - | F | 27440000 | 27440000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 476 | 476 | 37.76497079 | -122.48796743 | 29TH AVE \ LINCOLN WAY | 29TH AVE \ LINCOLN WAY | 1710539427000 | MTA | STOP | LINCOLN WAY intersection | - | 00 / 00 | - | - | - | - | - | 118155 | -404524800000 | -122.48796743 | 37.76497079 | - | 1465948800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566440000 | 29TH AVE | - | - | - | - | - | - |
| 100883 | N/A | Point | - | - | - | - | S236977 | DUBOCE AVE: BUCHANAN ST \ MARK | - | F | F | - | F | 30758000 | 30758000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | DUBOCE AVE \ MARKET ST | BUCHANAN ST \ DUBOCE AVE | 72361 | 72361 | 37.7696026 | -122.42630944 | BUCHANAN ST \ DUBOCE AVE \ MARKET ST | MARKET ST \ BUCHANAN ST \ DUBOCE AVE | 1729215936000 | middleware_editor | BICYCLES USE PED SIGNAL | BUCHANAN ST \ DUBOCE AVE intersection | - | NORTH EAST SIDE | - | - | - | - | - | 118156 | - | -122.42630944 | 37.7696026 | - | - | - | D8 | - | PEDESTRIAN | REG | R(SF).0016 | 12X18 | SUP2 | SIGNAL POLE | IS | 1497872880000 | MARKET ST | - | - | - | - | - | - |
| 100884 | N/A | Point | - | - | - | - | S120993 | DUBOCE AVE: BUCHANAN ST \ MARK | - | F | F | - | F | 30758000 | 30758000 | - | - | NORTH EAST CORNER | - | - | - | - | DUBOCE AVE \ MARKET ST | BUCHANAN ST \ DUBOCE AVE | 16857 | 16857 | 37.7696026 | -122.42630944 | BUCHANAN ST \ DUBOCE AVE \ MARKET ST | MARKET ST \ BUCHANAN ST \ DUBOCE AVE | 1729215965000 | middleware_editor | MARKET ST | BUCHANAN ST \ DUBOCE AVE intersection | - | (1967)-> | - | - | - | - | - | 118157 | 1115769600000 | -122.42630944 | 37.7696026 | - | - | - | D8 | - | STREET NAME | GUIDE | D3-1.1126 | 36X08 | SUP2 | LIGHT POLE | IS | 1373574120000 | MARKET ST | - | - | - | - | - | - |
| 100885 | N/A | Point | - | - | - | - | S205341 | BUCHANAN ST: DUBOCE AVE \ MARK | - | F | F | - | F | 30758000 | 30758000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DUBOCE AVE \ MARKET ST | BUCHANAN ST \ DUBOCE AVE | 46049 | 46049 | 37.7696026 | -122.42630944 | BUCHANAN ST \ DUBOCE AVE \ MARKET ST | MARKET ST \ BUCHANAN ST \ DUBOCE AVE | 1729215997000 | middleware_editor | BIKE (SYM) YIELD TO PEDS | BUCHANAN ST \ DUBOCE AVE intersection | - | NORTH CROSSWALK /NEAR SIDE OF INTERSEC | - | - | - | - | - | 118158 | 1399911420000 | -122.42630944 | 37.7696026 | - | 1399852800000 | - | D8 | - | OTHER REGULATORY | REG | R81(SF).0005 | 24X30 | SUP2 | LIGHT POLE | IS | 1398929940000 | MARKET ST | - | - | - | - | - | - |
| 100886 | N/A | Point | - | - | - | - | S219663 | MARKET ST: BUCHANAN ST \ DUBOC | - | F | F | - | T | 30758000 | 30758000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | DUBOCE AVE \ MARKET ST | BUCHANAN ST \ DUBOCE AVE | 55003 | 55003 | 37.7696026 | -122.42630944 | BUCHANAN ST \ DUBOCE AVE \ MARKET ST | MARKET ST \ BUCHANAN ST \ DUBOCE AVE | 1757026208000 | middleware_editor | NO LEFT TURN (SYM) | BUCHANAN ST \ DUBOCE AVE intersection | - | - | - | - | - | - | - | 118159 | 1444847400000 | -122.42630944 | 37.7696026 | - | 1757009700000 | - | D8 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1443698640000 | MARKET ST | - | - | - | - | - | - |
| 100887 | N/A | Point | - | - | - | - | S216615 | DUBOCE AVE: BUCHANAN ST \ MARK | - | F | F | - | F | 30758000 | 30758000 | - | - | NORTH WEST CORNER | - | - | - | - | DUBOCE AVE \ MARKET ST | BUCHANAN ST \ DUBOCE AVE | 54915 | 54915 | 37.7696026 | -122.42630944 | BUCHANAN ST \ DUBOCE AVE \ MARKET ST | MARKET ST \ BUCHANAN ST \ DUBOCE AVE | 1729215996000 | middleware_editor | TANSAT | BUCHANAN ST \ DUBOCE AVE intersection | - | OF DUBOCE & BUCHANAN | - | - | - | - | - | 118160 | 1433172240000 | -122.42630944 | 37.7696026 | - | 1433116800000 | - | D8 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | LIGHT POLE | IS | 1432883100000 | MARKET ST | - | - | - | - | - | - |
| 100888 | N/A | Point | - | - | - | - | S237608 | LINCOLN WAY: 29TH AVE | - | F | F | - | F | 8366201 | 27440000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | 28TH AVE | LINCOLN WAY | 109336 | 109336 | 37.76497079 | -122.48796743 | - | 29TH AVE \ LINCOLN WAY | 1710539427000 | MTA | SPEED LIMIT 30 | LINCOLN WAY intersection | - | - | - | - | - | - | - | 118161 | - | -122.48796743 | 37.76497079 | - | - | - | D4 | - | SPEED LIMIT | REG | R2-1.0009 | 36X45 | SUP2 | LIGHT POLE | RETD | 1500464580000 | 29TH AVE | 2700 - 2798 LINCOLN WAY | - | - | - | 29TH AVE | - |
| 100889 | N/A | Point | - | - | - | - | 25026 | - | - | F | F | - | F | 25880000 | - | - | - | CENTER ISLAND, E LINE, EASTBOUND | 1698790826000 | evillan | - | - | MARKET ST | - | 166177 | 166177 | 37.7661601488143 | -122.430756831316 | 15TH ST \ MARKET ST | - | 1730239991000 | middleware_editor | TYPE K | - | - | - | - | - | - | - | 1 | 118162 | - | - | - | - | - | 1729867320000 | 08 | - | OTHER WARNING | WARNING | TYPE-K(CA).0001 | 05X12 | SUP3 | STANDARD BASE | RETD | - | 15TH ST | - | - | - | - | - | - |
| 100890 | N/A | Point | 1 | - | - | - | S211868 | 700-799 MISSION ST | - | F | F | - | F | 9095000 | 9095000 | R37(CA).0090-2014-12-23 09:40:00-37.78536345--122.40314615 | - | SOUTH SIDE | - | - | - | - | - | - | 52108 | 52108 | 37.78536345 | -122.40314615 | - | - | 1710539427000 | MTA | TANSAT | - | - | 80'EAST OF #781 | - | - | - | - | - | 118163 | 1419327600000 | -122.40314615 | 37.78536345 | - | 1419292800000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | MUNI POLE | IS | 1418807220000 | MISSION ST | 700-799 MISSION ST | MISSION ST | - | - | - | - |
| 100891 | N/A | Point | - | - | - | - | S122891 | GREEN ST: OCTAVIA ST | - | F | F | - | F | 26576000 | 26576000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | GREEN ST | 21409 | 21409 | 37.79699173 | -122.4287254 | GREEN ST \ OCTAVIA ST | OCTAVIA ST \ GREEN ST | 1710539427000 | MTA | ALL WAY | GREEN ST intersection | - | - | - | - | - | - | - | 118164 | 1141603200000 | -122.4287254 | 37.79699173 | - | 1555372800000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574720000 | OCTAVIA ST | - | - | - | - | - | - |
| 100892 | N/A | Point | 1 | 1 | 100 - 199 | DOUBLE ARROW | S228168 | 100-199 PALM AVE | 100-199 PALM AVE | F | F | - | F | 10191000 | 10191000 | - | - | WEST SIDE | - | - | - | - | EUCLID AVE | EUCLID AVE | 61934 | 61934 | 37.78259446 | -122.45782793 | - | - | 1710539427000 | MTA | TA (SYM) PLO 8AM-10AM/2PM-4:30PM SCHOOL DAYS (5 MIN) | EUCLID AVE to GEARY BLVD (100 - 199) | - | OPP #166 | - | - | - | - | - | 118167 | 1471950720000 | -122.45782793 | 37.78259446 | - | 1627430400000 | - | D2 | - | OTHER REGULATORY | REG | R38(SF)6.0099 | 14X21 | SUP1 | LIGHT POLE | IS | 1471435560000 | PALM AVE | 100 - 199 PALM AVE | 100 - 199 PALM AVE | 100 PALM AVE | - | GEARY BLVD | GEARY BLVD |
| 100893 | N/A | Point | 1 | 1 | 100 - 199 | - | S251499 | 100-199 PALM AVE | 100-199 PALM AVE | F | F | - | F | 10191000 | 10191000 | - | - | EAST SIDE | - | - | - | - | EUCLID AVE | EUCLID AVE | 77867 | 77867 | 37.78259446 | -122.45782793 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | EUCLID AVE to GEARY BLVD (100 - 199) | - | IFO # 114 | - | - | - | - | - | 118168 | - | -122.45782793 | 37.78259446 | - | - | - | D2 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | LIGHT POLE | IS | 1549886220000 | PALM AVE | 100 - 199 PALM AVE | 100 - 199 PALM AVE | 100 PALM AVE | - | GEARY BLVD | GEARY BLVD |
| 100894 | N/A | Point | - | - | - | - | 24981 | - | - | F | F | - | F | 5063000 | - | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1698701703000 | smuneno | - | - | HYDE ST | - | 165871 | 165871 | 37.7835653608615 | -122.416053106047 | - | - | 1711748471000 | middleware_editor | FG 300 UR DELINEATOR (W) | - | - | INSIDE PSZ, EDDY @ HYDE, NWC | - | - | - | - | 2 | 118169 | 1701961200000 | - | - | - | - | - | 05 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | - | EDDY ST | 500 - 599 EDDY ST | - | - | - | LARKIN ST | - |
| 100895 | N/A | Point | - | - | - | - | 24983 | - | - | - | - | - | - | 25138000 | - | - | - | NORTH EAST CORNER | 1698701905000 | smuneno | - | - | HYDE ST | - | 165855 | 165855 | 37.7836089498975 | -122.415821933138 | EDDY ST \ HYDE ST | - | 1711748544000 | middleware_editor | TREE TOP 6FT SPEED BUMP | - | - | BETWEEN X-WALKS, NEC, HYDE @ EDDY | - | - | - | - | 2 | 118170 | 1702392300000 | - | - | - | - | - | 05 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP2 | STANDARD BASE | IS | - | EDDY ST | - | - | - | - | - | - |
| 100896 | N/A | Point | - | - | - | - | 24982 | - | - | F | F | - | F | 7117000 | - | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | 1698701843000 | smuneno | - | - | EDDY ST | - | 165872 | 165872 | 37.7836377001013 | -122.415834170716 | - | - | 1738104563000 | middleware_editor | FG 300 UR DELINEATOR (W) | - | - | INSIDE PSZ. HYDE @ EDDY, NEC | - | - | - | - | 4 | 118171 | 1702380600000 | - | - | - | 1738075500000 | - | 05 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | - | HYDE ST | 300 - 399 HYDE ST | - | - | - | ELLIS ST | - |
| 100897 | N/A | Point | - | - | - | - | 24986 | - | - | - | - | - | - | 5062000 | - | - | - | CENTER ISLAND, E LINE, WESTBOUND | 1698702095000 | smuneno | - | - | LEAVENWORTH ST | - | 165905 | 165905 | 37.7836020894004 | -122.415769916678 | - | - | 1711748487000 | middleware_editor | TREE TOP 6FT SPEED BUMP | - | - | EAST SIDE OF E-LINE, X-WALK, CENTER ISLAND | - | - | - | - | 1 | 118172 | 1702539360000 | - | - | - | - | - | 05 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP2 | STANDARD BASE | IS | - | EDDY ST | 400 - 499 EDDY ST | - | - | - | HYDE ST | - |
| 100898 | N/A | Point | - | - | - | - | S281563 | LINCOLN WAY: 46TH AVE | - | F | F | - | F | 27955000 | 27955000 | - | - | SOUTH EAST CORNER | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 92380 | 92380 | 37.76416613 | -122.50619149 | 46TH AVE \ LINCOLN WAY | 46TH AVE \ LINCOLN WAY | 1717204241000 | middleware_editor | LINCOLN WAY | LINCOLN WAY intersection | - | - | - | - | - | - | - | 118173 | - | -122.50619149 | 37.76416613 | - | 1680652800000 | - | D4 | - | STREET NAME | GUIDE | D3-1.1046 | 36X08 | SUP2 | 3IN IRON POST | IS | 1647425820000 | 46TH AVE | - | - | - | - | - | - |
| 100899 | N/A | Point | - | - | - | - | S100255 | 46TH AVE: LINCOLN WAY | - | F | F | - | F | 27955000 | 27955000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 269 | 269 | 37.76416613 | -122.50619149 | 46TH AVE \ LINCOLN WAY | 46TH AVE \ LINCOLN WAY | 1717204272000 | middleware_editor | STOP | LINCOLN WAY intersection | - | 0 / 00 | - | - | - | - | - | 118174 | -404870400000 | -122.50619149 | 37.76416613 | - | 1665619200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566380000 | 46TH AVE | - | - | - | - | - | - |
| 100900 | N/A | Point | - | - | - | - | S284640 | LINCOLN WAY: 46TH AVE | - | F | F | - | F | 27955000 | 27955000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 109417 | 109417 | 37.76416613 | -122.50619149 | 46TH AVE \ LINCOLN WAY | 46TH AVE \ LINCOLN WAY | 1717204274000 | middleware_editor | STOP | LINCOLN WAY intersection | - | - | - | - | - | - | - | 118175 | 1665619200000 | -122.50619149 | 37.76416613 | - | - | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1661162100000 | 46TH AVE | - | - | - | - | - | - |
| 100901 | N/A | Point | - | - | - | - | S284644 | LINCOLN WAY: 46TH AVE | - | F | F | - | F | 27955000 | 27955000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 97361 | 97361 | 37.76416613 | -122.50619149 | 46TH AVE \ LINCOLN WAY | 46TH AVE \ LINCOLN WAY | 1717204305000 | middleware_editor | ALL WAY | LINCOLN WAY intersection | - | - | - | - | - | - | - | 118176 | 1665619200000 | -122.50619149 | 37.76416613 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1661162640000 | 46TH AVE | - | - | - | - | - | - |
| 100902 | N/A | Point | - | - | - | - | S276720 | 46TH AVE: LINCOLN WAY | - | F | F | - | F | 27955000 | 27955000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 123587 | 123587 | 37.76416613 | -122.50619149 | 46TH AVE \ LINCOLN WAY | 46TH AVE \ LINCOLN WAY | 1710539427000 | MTA | SPEED HUMPS AHEAD | LINCOLN WAY intersection | - | - | - | - | - | - | - | 118177 | -404870400000 | -122.50619149 | 37.76416613 | - | 1628121600000 | - | D4 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1627639860000 | 46TH AVE | - | - | - | - | - | - |
| 100903 | N/A | Point | - | - | - | - | S284641 | LINCOLN WAY: 46TH AVE | - | F | F | - | F | 27955000 | 27955000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 97358 | 97358 | 37.76416613 | -122.50619149 | 46TH AVE \ LINCOLN WAY | 46TH AVE \ LINCOLN WAY | 1717204302000 | middleware_editor | ALL WAY | LINCOLN WAY intersection | - | - | - | - | - | - | - | 118178 | 1665619200000 | -122.50619149 | 37.76416613 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1661162220000 | 46TH AVE | - | - | - | - | - | - |
| 100904 | N/A | Point | - | - | - | - | S285470 | 46TH AVE: LINCOLN WAY | - | F | F | - | F | 27955000 | 27955000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 100415 | 100415 | 37.76416613 | -122.50619149 | 46TH AVE \ LINCOLN WAY | 46TH AVE \ LINCOLN WAY | 1717204335000 | middleware_editor | ALL WAY | LINCOLN WAY intersection | - | 0 / 00 | - | - | - | - | - | 118179 | 1665619200000 | -122.50619149 | 37.76416613 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1665662460000 | 46TH AVE | - | - | - | - | - | - |
| 100905 | N/A | Point | - | - | - | - | S284645 | LINCOLN WAY: 46TH AVE | - | F | F | - | F | 27955000 | 27955000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 97669 | 97669 | 37.76416613 | -122.50619149 | 46TH AVE \ LINCOLN WAY | 46TH AVE \ LINCOLN WAY | 1710539427000 | MTA | STOP | LINCOLN WAY intersection | - | - | - | - | - | - | - | 118180 | 1665619200000 | -122.50619149 | 37.76416613 | - | - | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1661162760000 | 46TH AVE | - | - | - | - | - | - |
| 100906 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S215890 | 1500-1599 30TH AVE | 1500-1599 30TH AVE | F | F | - | F | 1651000 | 1651000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | KIRKHAM ST | KIRKHAM ST | 53777 | 53777 | 37.75838004 | -122.48858263 | - | - | 1727901311000 | middleware_editor | SPEED HUMP | KIRKHAM ST to LAWTON ST (1500 - 1599) | - | NPL#1594 (SIGN SHOULD BE SPEED HUMPS) | - | - | - | - | - | 118181 | 1228435200000 | -122.48858263 | 37.75838004 | - | 1727872320000 | - | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1430837100000 | 30TH AVE | 1500 - 1599 30TH AVE | 1500 - 1599 30TH AVE | 1500 30TH AVE | - | LAWTON ST | LAWTON ST |
| 100907 | N/A | Point | 1 | 1 | 100 - 199 | - | S229537 | 100-199 COLLINS ST | 100-199 COLLINS ST | F | F | - | F | 4275000 | 4275000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | EUCLID AVE | EUCLID AVE | 65317 | 65317 | 37.78331205 | -122.45025144 | - | - | 1720706161000 | middleware_editor | SPEED HUMPS | EUCLID AVE to GEARY BLVD (100 - 199) | - | 25' NORTH OF GEARY BLVD | - | - | - | - | - | 118182 | 1477486680000 | -122.45025144 | 37.78331205 | - | 1477440000000 | - | D2 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1475663760000 | COLLINS ST | 100 - 199 COLLINS ST | 100 - 199 COLLINS ST | 100 COLLINS ST | - | GEARY BLVD | GEARY BLVD |
| 100908 | N/A | Point | - | - | - | - | S228379 | FUNSTON AVE: CABRILLO ST | - | T | T | - | F | 27268000 | 27268000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FUNSTON AVE | FUNSTON AVE | 67416 | 67416 | 37.77502758 | -122.47137305 | CABRILLO ST \ FUNSTON AVE | CABRILLO ST \ FUNSTON AVE | 1710539427000 | MTA | SPEED HUMPS | FUNSTON AVE intersection | - | - | - | - | - | - | - | 118183 | 1507807140000 | -122.47137305 | 37.77502758 | - | 1507766400000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1472111100000 | CABRILLO ST | - | - | - | - | - | - |
| 100909 | N/A | Point | - | - | - | - | S228366 | 5TH AVE: LAKE ST | - | F | F | - | F | 27595000 | 27595000 | - | - | WEST SIDE | - | - | - | - | 5TH AVE | 05TH AVE | 62167 | 62167 | 37.78672158 | -122.46361794 | LAKE ST \ 5TH AVE | LAKE ST \ 05TH AVE | 1710539427000 | MTA | SPEED HUMP | 05TH AVE intersection | - | IFO #73 X ST IS 000 BLOCK OF LAKE | - | - | - | - | - | 118184 | 1472220540000 | -122.46361794 | 37.78672158 | - | 1472169600000 | - | D2 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1472037540000 | LAKE ST | - | - | - | - | - | - |
| 100910 | N/A | Point | - | - | - | - | S228421 | 14TH AVE: CLEMENT ST | - | F | F | - | F | 27485000 | 27485000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | 14TH AVE | 64810 | 64810 | 37.78255399 | -122.47298448 | 14TH AVE \ CLEMENT ST | CLEMENT ST \ 14TH AVE | 1724081018000 | middleware_editor | SPEED HUMPS | 14TH AVE intersection | - | AT PAINT MARK | - | - | - | - | - | 118185 | 1481009640000 | -122.47298448 | 37.78255399 | - | 1480982400000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1472125080000 | CLEMENT ST | - | - | - | - | - | - |
| 100911 | N/A | Point | 1 | 1 | 500 - 699 | - | S227080 | 500-699 ARKANSAS ST | 500-699 ARKANSAS ST | F | F | - | F | 2440000 | 2440000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 20TH ST | 20TH ST | 105901 | 105901 | 37.7586341 | -122.39809295 | - | - | 1710539427000 | MTA | SPEED HUMP | 20TH ST to 22ND ST (500 - 699) | - | NPL #588 | - | - | - | - | - | 118186 | - | -122.39809295 | 37.7586341 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1467710640000 | ARKANSAS ST | 500 - 699 ARKANSAS ST | 500 - 699 ARKANSAS ST | 500 ARKANSAS ST | - | 22ND ST | 22ND ST |
| 100912 | N/A | Point | - | 1 | 1 - 50 | - | S230275 | 2150-2199 JOHN F KENNEDY DR (G | 1-50 DUTCH WINDMILL ACCESS RD | F | F | - | F | 12991000 | 12991000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | JOHN F KENNEDY DR | JOHN F KENNEDY DR | 65709 | 65709 | 37.77021819 | -122.50945454 | - | - | 1710539427000 | MTA | SPEED HUMPS | JOHN F KENNEDY DR to END: 0-0 BLOCK (1 - 50) | - | 30`EAST | - | - | - | - | - | 118187 | -187142400000 | -122.50945454 | 37.77021819 | - | 1477526400000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1477565940000 | DUTCH WINDMILL ACCESS RD | 2150-2199 JOHN F KENNEDY DR (G | 1 - 50 DUTCH WINDMILL ACCESS RD | - | - | END: 0-0 BLOCK | END: 0-0 BLOCK |
| 100913 | N/A | Point | - | - | - | - | S230154 | TRUMBULL ST: CRAUT ST | - | F | F | - | F | 21697000 | 21697000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | TRUMBULL ST | CRAUT ST | 65869 | 65869 | 37.73078874 | -122.42838995 | CRAUT ST \ TRUMBULL ST | TRUMBULL ST \ CRAUT ST | 1710539427000 | MTA | SPEED HUMPS | CRAUT ST intersection | - | OPP#184 | - | - | - | - | - | 118188 | 1478705700000 | -122.42838995 | 37.73078874 | - | 1478649600000 | - | D11 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1477403940000 | TRUMBULL ST | - | - | - | - | - | - |
| 100914 | N/A | Point | 1 | 1 | 700 - 812 | - | S227079 | 700-812 ARKANSAS ST | 700-812 ARKANSAS ST | F | F | - | F | 2441000 | 2441000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 22ND ST | 22ND ST | 67046 | 67046 | 37.75662875 | -122.39790027 | - | - | 1710539427000 | MTA | SPEED HUMPS | 22ND ST to MADERA ST (700 - 812) | - | OPP #758 | - | - | - | - | - | 118189 | 1468508400000 | -122.39790027 | 37.75662875 | - | 1468454400000 | - | D10 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1467710400000 | ARKANSAS ST | 700 - 812 ARKANSAS ST | 700 - 812 ARKANSAS ST | 700 ARKANSAS ST | - | MADERA ST | MADERA ST |
| 100915 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S226718 | 1200-1299 8TH AVE | 1200-1299 08TH AVE | F | F | - | F | 395000 | 395000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 64820 | 64820 | 37.76502687 | -122.46531076 | - | - | 1755206011000 | middleware_editor | SPEED HUMPS | LINCOLN WAY to IRVING ST (1200 - 1299) | - | IFO #1219 | - | - | - | - | - | 118190 | 1467055140000 | -122.46531076 | 37.76502687 | - | 1467010800000 | - | D5 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1466161800000 | 08TH AVE | 1200 - 1299 8TH AVE | 1200 - 1299 08TH AVE | 1200 8TH AVE | - | IRVING ST | IRVING ST |
| 100916 | N/A | Point | 1 | 1 | 200 - 220 | - | S226712 | PNDG WEBSTER ST | 200-220 WEBSTER ST | F | F | - | F | 13524001 | 13524001 | - | - | EAST SIDE | - | - | - | - | HAIGHT ST | HAIGHT ST | 126571 | 126571 | 37.77251074736 | -122.428781757086 | - | - | 1755878545000 | middleware_editor | SPEED HUMP | HAIGHT ST to ROSE ST (200 - 220) | - | 30' NORTH OF HAIGHT | - | - | - | - | - | 118191 | 1466796120000 | -122.42885025 | 37.7725546 | - | 1518163200000 | - | D5 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1466159940000 | WEBSTER ST | 200 - 220 WEBSTER ST | 200 - 220 WEBSTER ST | - | - | ROSE ST | ROSE ST |
| 100917 | N/A | Point | - | - | - | - | S228381 | FUNSTON AVE: FULTON ST | - | T | T | - | F | 27269000 | 27269000 | - | - | NORTH EAST CORNER | - | - | - | - | FULTON ST | FULTON ST | 67418 | 67418 | 37.77316198 | -122.47124007 | FUNSTON AVE \ FULTON ST | FUNSTON AVE \ FULTON ST | 1719928630000 | middleware_editor | SPEED HUMPS | FULTON ST intersection | - | OF FUNSTON & FULTON | - | - | - | - | - | 118192 | - | -122.47124007 | 37.77316198 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1472111820000 | FUNSTON AVE | - | - | - | - | - | - |
| 100918 | N/A | Point | - | - | - | - | S228438 | 15TH AVE: BALBOA ST | - | F | F | - | F | 27474000 | 27474000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 15TH AVE | BALBOA ST | 114373 | 114373 | 37.77679272 | -122.47369812 | BALBOA ST \ 15TH AVE | 15TH AVE \ BALBOA ST | 1710539427000 | MTA | SPEED HUMPS | BALBOA ST intersection | - | AT PAINT MARK | - | - | - | - | - | 118193 | 1474458780000 | -122.47369812 | 37.77679272 | - | 1474416000000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1472205840000 | 15TH AVE | - | - | - | - | - | - |
| 100919 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S208474 | 1400-1499 VAN DYKE AVE | 1400-1499 VAN DYKE AVE | F | F | - | F | 13140000 | 13140000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | JENNINGS ST | JENNINGS ST | 54586 | 54586 | 37.72757162 | -122.38961014 | - | - | 1710539427000 | MTA | SPEED HUMPS | JENNINGS ST to KEITH ST (1400 - 1499) | - | EPL #1418 | - | - | - | - | - | 118194 | 1415195640000 | -122.38961014 | 37.72757162 | - | 1415145600000 | - | D10 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1409045340000 | VAN DYKE AVE | 1400 - 1499 VAN DYKE AVE | 1400 - 1499 VAN DYKE AVE | 1400 VAN DYKE AVE | - | KEITH ST | KEITH ST |
| 100920 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S208640 | 1200-1299 SHAFTER AVE | 1200-1299 SHAFTER AVE | F | F | - | F | 11783000 | 11783000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | HAWES ST | HAWES ST | 50079 | 50079 | 37.72732915 | -122.38418356 | - | - | 1710539427000 | MTA | SPEED HUMPS | HAWES ST to INGALLS ST (1200 - 1299) | - | WPL #1222 | - | - | - | - | - | 118195 | 1415629920000 | -122.38418356 | 37.72732915 | - | 1415577600000 | - | D10 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1409317260000 | SHAFTER AVE | 1200 - 1299 SHAFTER AVE | 1200 - 1299 SHAFTER AVE | 1200 SHAFTER AVE | - | INGALLS ST | INGALLS ST |
| 100921 | N/A | Point | 1 | 1 | 2800 - 2899 | VERTICAL ARROW | S253866 | 2800-2899 HYDE ST | 2800-2899 HYDE ST | F | F | - | F | 7152000 | 7152000 | - | - | WEST SIDE | - | - | - | - | BEACH ST | BEACH ST | 77735 | 77735 | 37.80712392 | -122.42065162 | - | - | 1714570405000 | middleware_editor | CABLE CAR TICKETS | BEACH ST to JEFFERSON ST (2800 - 2899) | - | 100 FT NORTH ENTERANCE TO CABLE CAR AREA | - | - | - | - | - | 118196 | 1250640000000 | -122.42065162 | 37.80712392 | - | 1557446400000 | - | D2 | - | OTHER REGULATORY | REG | R(SF).0389 | 24X30 | SUP1 | 2IN IRON POST | IS | 1556544420000 | HYDE ST | 2800 - 2899 HYDE ST | 2800 - 2899 HYDE ST | 2800 HYDE ST | - | JEFFERSON ST | JEFFERSON ST |
| 100922 | N/A | Point | 1 | 1 | 2800 - 2899 | LEFT ARROW | S253869 | 2800-2899 HYDE ST | 2800-2899 HYDE ST | F | F | - | F | 7152000 | 7152000 | - | - | WEST SIDE | - | - | - | - | BEACH ST | BEACH ST | 77737 | 77737 | 37.80712392 | -122.42065162 | - | - | 1714570549000 | middleware_editor | CABLE CAR TICKETS | BEACH ST to JEFFERSON ST (2800 - 2899) | - | AROUND CABLE CAR WALK WAY, | - | - | - | - | - | 118197 | 1250640000000 | -122.42065162 | 37.80712392 | - | 1556841600000 | - | D2 | - | OTHER REGULATORY | REG | R(SF).0389 | 24X30 | SUP1 | 2IN IRON POST | IS | 1556544540000 | HYDE ST | 2800 - 2899 HYDE ST | 2800 - 2899 HYDE ST | 2800 HYDE ST | - | JEFFERSON ST | JEFFERSON ST |
| 100923 | N/A | Point | 1 | 1 | 2800 - 2899 | LEFT ARROW | S253870 | 2800-2899 HYDE ST | 2800-2899 HYDE ST | F | F | - | F | 7152000 | 7152000 | - | - | WEST SIDE | - | - | - | - | BEACH ST | BEACH ST | 77738 | 77738 | 37.80712392 | -122.42065162 | - | - | 1714570551000 | middleware_editor | CABLE CAR TICKETS | BEACH ST to JEFFERSON ST (2800 - 2899) | - | AROUND CABLE CAR WALK WAY,. | - | - | - | - | - | 118198 | 1250640000000 | -122.42065162 | 37.80712392 | - | 1556841600000 | - | D2 | - | OTHER REGULATORY | REG | R(SF).0389 | 24X30 | SUP1 | 2IN IRON POST | IS | 1556544600000 | HYDE ST | 2800 - 2899 HYDE ST | 2800 - 2899 HYDE ST | 2800 HYDE ST | - | JEFFERSON ST | JEFFERSON ST |
| 100924 | N/A | Point | 1 | 1 | 2800 - 2899 | - | S253876 | 2800-2899 HYDE ST | 2800-2899 HYDE ST | F | F | - | F | 7152000 | 7152000 | - | - | WEST SIDE | - | - | - | - | BEACH ST | BEACH ST | 78022 | 78022 | 37.80712392 | -122.42065162 | - | - | 1714570580000 | middleware_editor | CABLE CAR SAFETY | BEACH ST to JEFFERSON ST (2800 - 2899) | - | AROUND CABLE CAR WALK WAY... | - | - | - | - | - | 118199 | 1250640000000 | -122.42065162 | 37.80712392 | - | 1557446400000 | - | D2 | - | OTHER REGULATORY | REG | R(SF).0390 | 24X30 | SUP1 | 2IN IRON POST | IS | 1556544960000 | HYDE ST | 2800 - 2899 HYDE ST | 2800 - 2899 HYDE ST | 2800 HYDE ST | - | JEFFERSON ST | JEFFERSON ST |
| 100925 | N/A | Point | 1 | 1 | 2800 - 2899 | - | S253873 | 2800-2899 HYDE ST | 2800-2899 HYDE ST | F | F | - | F | 7152000 | 7152000 | - | - | WEST SIDE | - | - | - | - | BEACH ST | BEACH ST | 78019 | 78019 | 37.80712392 | -122.42065162 | - | - | 1714570611000 | middleware_editor | CABLE CAR SAFETY | BEACH ST to JEFFERSON ST (2800 - 2899) | - | AROUND CABLE CAR WALK WAY | - | - | - | - | - | 118200 | 1250640000000 | -122.42065162 | 37.80712392 | - | 1557446400000 | - | D2 | - | OTHER REGULATORY | REG | R(SF).0390 | 24X30 | SUP1 | 2IN IRON POST | IS | 1556544900000 | HYDE ST | 2800 - 2899 HYDE ST | 2800 - 2899 HYDE ST | 2800 HYDE ST | - | JEFFERSON ST | JEFFERSON ST |
| 100926 | N/A | Point | 1 | 1 | 2800 - 2899 | LEFT ARROW | S253872 | 2800-2899 HYDE ST | 2800-2899 HYDE ST | F | F | - | F | 7152000 | 7152000 | - | - | WEST SIDE | - | - | - | - | BEACH ST | BEACH ST | 78018 | 78018 | 37.80712392 | -122.42065162 | - | - | 1714570612000 | middleware_editor | CABLE CAR TICKETS | BEACH ST to JEFFERSON ST (2800 - 2899) | - | AROUND CABLE CAR WALK WAY,... | - | - | - | - | - | 118201 | 1250640000000 | -122.42065162 | 37.80712392 | - | 1556841600000 | - | D2 | - | OTHER REGULATORY | REG | R(SF).0389 | 24X30 | SUP1 | 2IN IRON POST | IS | 1556544660000 | HYDE ST | 2800 - 2899 HYDE ST | 2800 - 2899 HYDE ST | 2800 HYDE ST | - | JEFFERSON ST | JEFFERSON ST |
| 100927 | N/A | Point | 1 | 1 | 2800 - 2899 | - | S253877 | 2800-2899 HYDE ST | 2800-2899 HYDE ST | F | F | - | F | 7152000 | 7152000 | - | - | WEST SIDE | - | - | - | - | BEACH ST | BEACH ST | 78023 | 78023 | 37.80712392 | -122.42065162 | - | - | 1714570608000 | middleware_editor | CABLE CAR SAFETY | BEACH ST to JEFFERSON ST (2800 - 2899) | - | AROUND CABLE CAR WALK WAY.... | - | - | - | - | - | 118202 | 1250640000000 | -122.42065162 | 37.80712392 | - | 1556841600000 | - | D2 | - | OTHER REGULATORY | REG | R(SF).0390 | 24X30 | SUP1 | 2IN IRON POST | IS | 1556544960000 | HYDE ST | 2800 - 2899 HYDE ST | 2800 - 2899 HYDE ST | 2800 HYDE ST | - | JEFFERSON ST | JEFFERSON ST |
| 100928 | N/A | Point | 1 | 1 | 2800 - 2899 | - | S253875 | 2800-2899 HYDE ST | 2800-2899 HYDE ST | F | F | - | F | 7152000 | 7152000 | - | - | WEST SIDE | - | - | - | - | BEACH ST | BEACH ST | 78021 | 78021 | 37.80712392 | -122.42065162 | - | - | 1714570582000 | middleware_editor | CABLE CAR SAFETY | BEACH ST to JEFFERSON ST (2800 - 2899) | - | AROUND CABLE CAR WALK WAY.. | - | - | - | - | - | 118203 | 1250640000000 | -122.42065162 | 37.80712392 | - | 1557360000000 | - | D2 | - | OTHER REGULATORY | REG | R(SF).0390 | 24X30 | SUP1 | 2IN IRON POST | IS | 1556544960000 | HYDE ST | 2800 - 2899 HYDE ST | 2800 - 2899 HYDE ST | 2800 HYDE ST | - | JEFFERSON ST | JEFFERSON ST |
| 100929 | N/A | Point | 1 | 1 | 2800 - 2899 | RIGHT ARROW | S255636 | 2800-2899 HYDE ST | 2800-2899 HYDE ST | F | F | - | F | 7152000 | 7152000 | - | - | WEST SIDE | - | - | - | - | BEACH ST | BEACH ST | 86709 | 86709 | 37.80712392 | -122.42065162 | - | - | 1714570455000 | middleware_editor | TA (SYM) TAXI CAB ONLY AT ALL TIMES | BEACH ST to JEFFERSON ST (2800 - 2899) | - | 11' N OF BEACH ST | - | - | - | - | - | 118204 | 1561719120000 | -122.42065162 | 37.80712392 | - | - | - | D2 | - | OTHER REGULATORY | REG | R38(SF)5.0001 | 14X21 | SUP1 | 2IN IRON POST | IS | 1561460160000 | HYDE ST | 2800 - 2899 HYDE ST | 2800 - 2899 HYDE ST | 2800 HYDE ST | - | JEFFERSON ST | JEFFERSON ST |
| 100930 | N/A | Point | 1 | 1 | 2800 - 2899 | LEFT ARROW | S255638 | 2800-2899 HYDE ST | 2800-2899 HYDE ST | F | F | - | F | 7152000 | 7152000 | - | - | WEST SIDE | - | - | - | - | BEACH ST | BEACH ST | 86711 | 86711 | 37.80712392 | -122.42065162 | - | - | 1714569849000 | middleware_editor | TA (SYM) TAXI CAB ONLY AT ALL TIMES | BEACH ST to JEFFERSON ST (2800 - 2899) | - | 111' N OF BEACH ST | - | - | - | - | - | 118205 | 1561720380000 | -122.42065162 | 37.80712392 | - | - | - | D2 | - | OTHER REGULATORY | REG | R38(SF)5.0001 | 14X21 | SUP1 | 2IN IRON POST | IS | 1561460340000 | HYDE ST | 2800 - 2899 HYDE ST | 2800 - 2899 HYDE ST | 2800 HYDE ST | - | JEFFERSON ST | JEFFERSON ST |
| 100931 | N/A | Point | 1 | 1 | 2800 - 2899 | - | S253879 | 2800-2899 HYDE ST | 2800-2899 HYDE ST | F | F | - | F | 7152000 | 7152000 | - | - | WEST SIDE | - | - | - | - | BEACH ST | BEACH ST | 100916 | 100916 | 37.80712392 | -122.42065162 | - | - | 1714570614000 | middleware_editor | CABLE CAR SAFETY | BEACH ST to JEFFERSON ST (2800 - 2899) | - | AROUND CABLE CAR WALK WAY...... | - | - | - | - | - | 118206 | 1250640000000 | -122.42065162 | 37.80712392 | - | 1556841600000 | - | D2 | - | OTHER REGULATORY | REG | R(SF).0390 | 24X30 | SUP1 | 2IN IRON POST | IS | 1556545080000 | HYDE ST | 2800 - 2899 HYDE ST | 2800 - 2899 HYDE ST | 2800 HYDE ST | - | JEFFERSON ST | JEFFERSON ST |
| 100932 | N/A | Point | 1 | 1 | 2800 - 2899 | - | S240991 | 2800-2899 HYDE ST | 2800-2899 HYDE ST | T | T | - | F | 7152000 | 7152000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | BEACH ST | BEACH ST | 106700 | 106700 | 37.80712392 | -122.42065162 | - | - | 1710539427000 | MTA | 49 MILE SCENIC DRIVE ARROW (RA) | BEACH ST to JEFFERSON ST (2800 - 2899) | 34 | 80' NORTH OF BEACH ST | - | - | - | - | - | 118207 | - | -122.42065162 | 37.80712392 | - | - | - | D2 | - | OTHER GUIDE | GUIDE | G-X(SF).0047 | 18X18 | SUP1 | LIGHT POLE | IS | 1511959680000 | HYDE ST | 2800 - 2899 HYDE ST | 2800 - 2899 HYDE ST | 2800 HYDE ST | - | JEFFERSON ST | JEFFERSON ST |
| 100933 | N/A | Point | 1 | 1 | 2800 - 2899 | - | S253878 | 2800-2899 HYDE ST | 2800-2899 HYDE ST | F | F | - | F | 7152000 | 7152000 | - | - | WEST SIDE | - | - | - | - | BEACH ST | BEACH ST | 115124 | 115124 | 37.80712392 | -122.42065162 | - | - | 1714570665000 | middleware_editor | CABLE CAR SAFETY | BEACH ST to JEFFERSON ST (2800 - 2899) | - | AROUND CABLE CAR WALK WAY..... | - | - | - | - | - | 118208 | 1250640000000 | -122.42065162 | 37.80712392 | - | 1556841600000 | - | D2 | - | OTHER REGULATORY | REG | R(SF).0390 | 24X30 | SUP1 | 2IN IRON POST | IS | 1556545080000 | HYDE ST | 2800 - 2899 HYDE ST | 2800 - 2899 HYDE ST | 2800 HYDE ST | - | JEFFERSON ST | JEFFERSON ST |
| 100934 | N/A | Point | - | - | - | - | S254470 | SAN JOSE AVE: BADEN ST | - | F | F | - | F | 33377000 | 33377000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BADEN ST | SAN JOSE AVE | 88330 | 88330 | 37.72958897 | -122.4389832 | SAN JOSE AVE \ BADEN ST | BADEN ST \ SAN JOSE AVE | 1713982547000 | middleware_editor | (45 LA-DN) | SAN JOSE AVE intersection | - | - | - | - | - | - | - | 118209 | 1011744000000 | -122.4389832 | 37.72958897 | - | 1588291200000 | - | D11 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | 2IN IRON POST | IS | 1558357800000 | BADEN ST | - | - | - | - | - | - |
| 100935 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S223248 | 2000-2099 GOUGH ST | 2000-2099 GOUGH ST | F | F | - | F | 6340000 | 6340000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | CLAY ST | CLAY ST | 115122 | 115122 | 37.79219535 | -122.4260686 | - | - | 1749746112000 | middleware_editor | PEDESTRIAN (SYM) | CLAY ST to WASHINGTON ST (2000 - 2099) | - | OPP. NORTH SIDE OF DRIVEWAY TO #2030 | - | - | - | - | - | 118210 | 1456513740000 | -122.4260686 | 37.79219535 | - | 1680591600000 | - | D2 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1455003060000 | GOUGH ST | 2000 - 2099 GOUGH ST | 2000 - 2099 GOUGH ST | 2000 GOUGH ST | - | WASHINGTON ST | WASHINGTON ST |
| 100936 | N/A | Point | - | - | - | - | S223553 | LAKE MERCED BLVD: JOHN MUIR DR | - | T | T | - | F | - | 33539000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | - | JOHN MUIR DR | 128166 | 128166 | 37.7084818830764 | -122.486263811583 | - | LAKE MERCED BLVD \ JOHN MUIR DR | 1734546287000 | middleware_editor | SAN FRANCISCO CITY & COUNTY | JOHN MUIR DR intersection | - | 30`NORTH OF JOHN MUIR (1ST LP NORTH) | - | - | - | - | - | 118211 | - | -122.48572387 | 37.70808573 | - | 1729036800000 | - | D7 | - | OTHER GUIDE | GUIDE | G-S(SF).0014 | 48X24 | SUP2 | LIGHT POLE | IS | 1455791700000 | LAKE MERCED BLVD | 200 - 699 JOHN MUIR DR | - | - | - | - | - |
| 100937 | N/A | Point | - | - | - | - | S254448 | SAN JOSE AVE: LAKEVIEW AVE | - | F | F | - | F | 21575000 | 21575000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | LAKEVIEW AVE | SAN JOSE AVE | 88327 | 88327 | 37.71616897 | -122.45037835 | SAN JOSE AVE \ LAKEVIEW AVE | LAKEVIEW AVE \ SAN JOSE AVE | 1727485992000 | middleware_editor | CHEVRON - LEFT/RIGHT | SAN JOSE AVE intersection | - | SOUTH SIDE IFO 2213 | - | - | - | - | - | 118212 | 1489104000000 | -122.45037835 | 37.71616897 | - | 1646092800000 | - | D11 | - | OTHER WARNING | WARNING | TYPE-R(CA).0001 | 24X30 | SUP2 | 2IN IRON POST | IS | 1558349280000 | LAKEVIEW AVE | - | - | - | - | - | - |
| 100938 | N/A | Point | - | - | - | - | S253602 | OAK ST: FRANKLIN ST | - | T | T | - | F | 24447000 | 24447000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OAK ST | FRANKLIN ST | 100565 | 100565 | 37.77523234 | -122.42095992 | FRANKLIN ST \ OAK ST | OAK ST \ FRANKLIN ST | 1710539427000 | MTA | HOSPITAL (RA) | FRANKLIN ST intersection | - | 10' E OF FRANKLIN | - | - | - | - | - | 118213 | 1556236800000 | -122.42095992 | 37.77523234 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-H(SF).0014 | 48X16 | SUP1 | LIGHT POLE | IS | 1555504740000 | OAK ST | - | - | - | - | - | - |
| 100939 | N/A | Point | - | - | - | - | S253213 | DAVIS ST: VALLEJO ST | - | F | F | - | F | 24801000 | 24801000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VALLEJO ST | VALLEJO ST | 79487 | 79487 | 37.79982889 | -122.39888266 | DAVIS ST \ VALLEJO ST | DAVIS ST \ VALLEJO ST | 1710539427000 | MTA | (LA) WHITE ON GREEN | VALLEJO ST intersection | 0835 | ABOVE STOP SIGN | - | - | - | - | - | 118214 | 356058000000 | -122.39888266 | 37.79982889 | - | 1572220800000 | - | D3 | - | OTHER GUIDE | GUIDE | M7-1.0002 | 12X09 | SUP1 | 2IN IRON POST | IS | 1554384840000 | DAVIS ST | - | - | - | - | - | - |
| 100940 | N/A | Point | - | 1 | 1 - 100 | - | S253394 | 1-99 SERGEANT JOHN V YOUNG ST | 1-100 SERGEANT JOHN V YOUNG ST | F | F | - | F | 11765000 | 11765000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 85989 | 85989 | 37.72497399 | -122.44467747 | - | - | 1710539427000 | MTA | (45 LA-DN) | SAN JOSE AVE to END: 1-99 BLOCK (1 - 100) | - | 270FT WEST OF SAN JOSE AVE | - | - | - | - | - | 118215 | 1555586100000 | -122.44467747 | 37.72497399 | - | - | - | D11 | - | OTHER WARNING | WARNING | W16-7P.0001 | 18X18 | SUP2 | 2IN IRON POST | IS | 1554897240000 | SERGEANT JOHN V YOUNG ST | 1 - 100 SERGEANT JOHN V YOUNG ST | 1 - 100 SERGEANT JOHN V YOUNG ST | 1 SERGEANT JOHN V YOUNG ST | - | END: 1-99 BLOCK | END: 1-99 BLOCK |
| 100941 | N/A | Point | 1 | 1 | 500 - 511 | - | S254530 | 500-511 3RD ST | 500-511 03RD ST | F | F | - | F | 175000 | 175000 | - | - | WEST SIDE | - | - | - | - | BRYANT ST | BRYANT ST | 88622 | 88622 | 37.7811917 | -122.39568063 | - | - | 1710539427000 | MTA | SPECIAL EVENT AREA CHECK YOUR METER (SFPARK) | BRYANT ST to TABER PL (500 - 511) | - | 98' SOUTH OF BRYANT ST | - | - | - | - | - | 118216 | 953341200000 | -122.39568063 | 37.7811917 | - | 1455148800000 | - | D6 | - | OTHER GUIDE | GUIDE | G-S(SF).0058 | 18X18 | SUP1 | 2IN IRON POST | IS | 1558445220000 | 03RD ST | 500 - 511 3RD ST | 500 - 511 03RD ST | 500 3RD ST | - | TABER PL | TABER PL |
| 100942 | N/A | Point | - | 1 | 1 - 100 | - | S253395 | 1-99 SERGEANT JOHN V YOUNG ST | 1-100 SERGEANT JOHN V YOUNG ST | F | F | - | F | 11765000 | 11765000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 85990 | 85990 | 37.72497399 | -122.44467747 | - | - | 1756421795000 | middleware_editor | PEDESTRIAN (SYM) | SAN JOSE AVE to END: 1-99 BLOCK (1 - 100) | - | 290 FT WEST OF SAN JOSE AVE | - | - | - | - | - | 118217 | 1555610400000 | -122.44467747 | 37.72497399 | - | 1556175600000 | - | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1554897540000 | SERGEANT JOHN V YOUNG ST | 1 - 100 SERGEANT JOHN V YOUNG ST | 1 - 100 SERGEANT JOHN V YOUNG ST | 1 SERGEANT JOHN V YOUNG ST | - | END: 1-99 BLOCK | END: 1-99 BLOCK |
| 100943 | N/A | Point | - | - | - | - | S221947 | WASHINGTON ST: PRESIDIO AVE | - | F | F | - | F | 26952000 | 26952000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | PRESIDIO AVE | 59179 | 59179 | 37.78994083 | -122.44733033 | PRESIDIO AVE \ WASHINGTON ST | WASHINGTON ST \ PRESIDIO AVE | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | PRESIDIO AVE intersection | - | - | - | - | - | - | - | 118218 | 1452695340000 | -122.44733033 | 37.78994083 | - | 1452643200000 | - | D2 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP1 | LIGHT POLE | IS | 1452251280000 | WASHINGTON ST | - | - | - | - | - | - |
| 100944 | N/A | Point | 1 | 1 | 600 - 699 | - | S254499 | 600-699 3RD ST | 600-699 03RD ST | F | F | - | F | 179000 | 179000 | - | - | EAST SIDE | - | - | - | - | BRANNAN ST | BRANNAN ST | 88336 | 88336 | 37.77947073 | -122.39352491 | - | - | 1710539427000 | MTA | SPECIAL EVENT AREA CHECK YOUR METER (SFPARK) | BRANNAN ST to TOWNSEND ST (600 - 699) | - | 143' SOUTH OF BRANNAN | - | - | - | - | - | 118219 | 1167782400000 | -122.39352491 | 37.77947073 | - | 1455148800000 | - | D6 | - | OTHER GUIDE | GUIDE | G-S(SF).0058 | 18X18 | SUP1 | LIGHT POLE | IS | 1558435920000 | 03RD ST | 600 - 699 3RD ST | 600 - 699 03RD ST | 600 3RD ST | - | TOWNSEND ST | TOWNSEND ST |
| 100945 | N/A | Point | - | - | - | - | S255245 | SANTIAGO ST: 46TH AVE | - | F | F | - | F | 23507000 | 23507000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 46TH AVE | 46TH AVE | 86882 | 86882 | 37.74364293 | -122.50475258 | SANTIAGO ST \ 46TH AVE | SANTIAGO ST \ 46TH AVE | 1710539427000 | MTA | CROSS TRAFFIC DOES NOT STOP | 46TH AVE intersection | - | - | - | - | - | - | - | 118220 | 1562579880000 | -122.50475258 | 37.74364293 | - | - | - | D4 | - | OTHER WARNING | WARNING | W4-4P.0001 | 24X12 | SUP2 | 2IN IRON POST | IS | 1560336600000 | SANTIAGO ST | - | - | - | - | - | - |
| 100946 | N/A | Point | - | - | - | - | S256886 | BRYANT ST: BEALE ST | - | T | T | - | F | 23599000 | 23599000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BEALE ST \ BRYANT ST | BEALE ST \ DELANCEY ST | 127679 | 127679 | 37.78622378 | -122.38963664 | DELANCEY ST \ BEALE ST \ BRYANT ST | BRYANT ST \ BEALE ST \ DELANCEY ST | 1710539427000 | MTA | MISCELLANEOUS SIGNS | BEALE ST \ DELANCEY ST intersection | - | - | - | - | - | - | - | 118221 | 1489363200000 | -122.38963664 | 37.78622378 | - | 1569974400000 | - | D6 | - | OTHER GUIDE | GUIDE | G-M(SF).0038 | N/A | SUP1 | SIGNAL POLE | IS | 1565184420000 | BRYANT ST | - | - | - | - | - | - |
| 100947 | N/A | Point | 1 | 1 | 400 - 499 | - | S226760 | 400-499 14TH ST | 400-499 14TH ST | F | F | - | F | 589000 | 589000 | - | - | NORTH SIDE | - | - | - | - | VALENCIA ST | VALENCIA ST | 112542 | 112542 | 37.76807305 | -122.42330543 | - | - | 1710539427000 | MTA | WHEEL STOP | VALENCIA ST to GUERRERO ST (400 - 499) | - | INFO #494 (WEST END) | - | - | - | - | - | 118222 | 1297296000000 | -122.42330543 | 37.76807305 | - | 1466985600000 | - | D8 | - | OTHER WARNING | WARNING | W(SF).0072 | 36X08 | SUP2 | EPOXY | IS | 1466418360000 | 14TH ST | 400 - 499 14TH ST | 400 - 499 14TH ST | 400 14TH ST | - | GUERRERO ST | GUERRERO ST |
| 100948 | N/A | Point | 1 | 1 | 300 - 349 | - | S284341 | 300-349 PARNASSUS AVE | 300-349 PARNASSUS AVE | T | T | - | F | 10291000 | 10291000 | - | - | NORTH SIDE | - | - | - | - | WILLARD ST | WILLARD ST | 92882 | 92882 | 37.7642105 | -122.45500562 | - | - | 1710539427000 | MTA | T INTERSECTION (SYM) | WILLARD ST to HILL POINT AVE (300 - 349) | - | #326 WPL ABOVE 2 HR PRK SIGN. | - | - | - | - | - | 118223 | - | -122.45500562 | 37.7642105 | - | 1660780800000 | - | D5 | - | OTHER WARNING | WARNING | W2-4.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1659624360000 | PARNASSUS AVE | 300 - 349 PARNASSUS AVE | 300 - 349 PARNASSUS AVE | 300 PARNASSUS AVE | - | HILL POINT AVE | HILL POINT AVE |
| 100949 | N/A | Point | - | - | - | - | S273020 | EVANS AVE: JENNINGS ST \ MIDDL | - | F | F | - | F | 20177000 | 20177000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | EVANS AVE \ MIDDLE POINT RD | EVANS AVE \ MIDDLE POINT RD | 116940 | 116940 | 37.73768029 | -122.37910965 | JENNINGS ST \ EVANS AVE \ MIDDLE POINT RD | JENNINGS ST \ EVANS AVE \ MIDDLE POINT RD | 1745619051000 | middleware_editor | FG 300 UR DELINEATOR (Y) | EVANS AVE \ MIDDLE POINT RD intersection | - | START 20' EAST OF MIDDLE POINT 40' OC | - | - | - | - | - | 118224 | 1621541640000 | -122.37910965 | 37.73768029 | - | 1744917300000 | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0008 | 03X36 | SUP1 | STANDARD BASE | IS | 1615195860000 | JENNINGS ST | - | - | - | - | - | - |
| 100950 | N/A | Point | - | - | - | - | S243614 | MIDDLE POINT RD: EVANS AVE \ J | - | F | F | - | F | 20177000 | 20177000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | EVANS AVE \ MIDDLE POINT RD | EVANS AVE \ MIDDLE POINT RD | 85660 | 85660 | 37.73768029 | -122.37910965 | JENNINGS ST \ EVANS AVE \ MIDDLE POINT RD | JENNINGS ST \ EVANS AVE \ MIDDLE POINT RD | 1710539427000 | MTA | ALL WAY | EVANS AVE \ MIDDLE POINT RD intersection | - | - | - | - | - | - | - | 118225 | 209260800000 | -122.37910965 | 37.73768029 | - | - | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1520844660000 | JENNINGS 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.