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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102151 | N/A | Point | - | - | - | - | S253225 | FONT BLVD: LAKE MERCED BLVD | - | T | T | - | F | 33541000 | 33541000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | FONT BLVD | FONT BLVD | 80681 | 80681 | 37.72399973 | -122.48507518 | LAKE MERCED BLVD \ FONT BLVD | LAKE MERCED BLVD \ FONT BLVD | 1726796674000 | middleware_editor | REMOVE (SF BIKE ROUTE) GREEN (SYM) # | FONT BLVD intersection | - | X LAKE MERCED / #90 | - | - | - | - | - | 119433 | - | -122.48507518 | 37.72399973 | - | - | - | D7 | - | BIKE REG | REG | R(SF).0388 | 12X24 | SUP2 | LIGHT POLE | IS | 1554453480000 | LAKE MERCED BLVD | - | - | - | - | - | - |
| 102152 | N/A | Point | - | - | - | - | S253224 | FONT BLVD: LAKE MERCED BLVD | - | T | T | - | F | 33541000 | 33541000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | FONT BLVD | FONT BLVD | 79770 | 79770 | 37.72399973 | -122.48507518 | LAKE MERCED BLVD \ FONT BLVD | LAKE MERCED BLVD \ FONT BLVD | 1726796674000 | middleware_editor | REMOVE (SF BIKE ROUTE) GREEN (SYM) # | FONT BLVD intersection | - | X LAKE MERCED / #85 | - | - | - | - | - | 119434 | - | -122.48507518 | 37.72399973 | - | - | - | D7 | - | BIKE REG | REG | R(SF).0388 | 12X24 | SUP2 | LIGHT POLE | IS | 1554453480000 | LAKE MERCED BLVD | - | - | - | - | - | - |
| 102153 | N/A | Point | - | - | - | - | S216131 | LAKE MERCED BLVD: HIGUERA AVE | - | T | T | - | F | 23112000 | 23112000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | HIGUERA AVE | LAKE MERCED BLVD | 55132 | 55132 | 37.71857436 | -122.48507679 | LAKE MERCED BLVD \ HIGUERA AVE | HIGUERA AVE \ LAKE MERCED BLVD | 1710539427000 | MTA | NO U TURN (SYM) | LAKE MERCED BLVD intersection | - | N-LINE OF ENTRANCE (ON MAST ARM) | - | - | - | - | - | 119435 | 1454510880000 | -122.48507679 | 37.71857436 | - | 1454457600000 | - | D7 | - | OTHER REGULATORY | REG | R3-4.0002 | 30X30 | SUP2 | SIGNAL POLE | IS | 1431682920000 | HIGUERA AVE | - | - | - | - | - | - |
| 102154 | N/A | Point | - | - | - | - | S216130 | LAKE MERCED BLVD: HIGUERA AVE | - | T | T | - | F | 23112000 | 23112000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | HIGUERA AVE | LAKE MERCED BLVD | 55131 | 55131 | 37.71857436 | -122.48507679 | LAKE MERCED BLVD \ HIGUERA AVE | HIGUERA AVE \ LAKE MERCED BLVD | 1710539427000 | MTA | NO U TURN (SYM) | LAKE MERCED BLVD intersection | - | ON MAST ARM | - | - | - | - | - | 119436 | 1454510820000 | -122.48507679 | 37.71857436 | - | 1454457600000 | - | D7 | - | OTHER REGULATORY | REG | R3-4.0002 | 30X30 | SUP2 | SIGNAL POLE | IS | 1431682500000 | HIGUERA AVE | - | - | - | - | - | - |
| 102155 | N/A | Point | - | - | - | - | 25484 | - | - | F | F | - | F | 826000 | - | - | - | WEST SIDE | 1701124997000 | elclark | - | - | START: 1-99 BLOCK | - | 171252 | 171252 | 37.7864294731392 | -122.477741205082 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES | - | - | NPL #49 BELOW STCLN | - | - | - | - | - | 119437 | - | - | - | - | 1701270840000 | - | 01 | - | PARKING:PARK AT 90 | REG | R(SF).0372 | 18X18 | SUP2 | 2IN IRON POST | IS | - | 18TH AVE | 1 - 99 18TH AVE | - | - | - | LAKE ST | - |
| 102156 | N/A | Point | - | - | - | - | S243066 | TOMPKINS AVE: PRENTISS ST | - | F | F | - | F | 21073000 | 21073000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PRENTISS ST | TOMPKINS AVE | 75646 | 75646 | 37.73699957 | -122.41223939 | TOMPKINS AVE \ PRENTISS ST | PRENTISS ST \ TOMPKINS AVE | 1710539427000 | MTA | ALL WAY | TOMPKINS AVE intersection | - | BELOW STOP SIGN | - | - | - | - | - | 119438 | 1527595080000 | -122.41223939 | 37.73699957 | - | - | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1518607620000 | PRENTISS ST | - | - | - | - | - | - |
| 102157 | N/A | Point | - | - | - | - | 25639 | - | - | F | F | - | F | 7904000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1701463859000 | MALOPEZ | - | - | TURK BLVD | - | 172490 | 172490 | 37.7778212021693 | -122.450533854937 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | - | - | NPL 22 KITTREDGE | - | - | - | - | 1 | 119439 | - | - | - | - | - | - | 01 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP2 | 2 POST ALUMINUM | PI | - | KITTREDGE TER | 1 - 99 KITTREDGE TER | - | - | - | GOLDEN GATE AVE | - |
| 102158 | N/A | Point | - | - | - | - | S250554 | VALENCIA ST: DUBOCE AVE | - | F | F | - | F | 24403000 | 24403000 | - | - | WEST SIDE | - | - | - | - | VALENCIA ST | DUBOCE AVE | 84806 | 84806 | 37.7698677 | -122.42236482 | DUBOCE AVE \ VALENCIA ST | VALENCIA ST \ DUBOCE AVE | 1710539427000 | MTA | TA (SYM) 7:30-8:30AM SCH DAYS CLZ/8:30AM-6PM M-SAT PLO | DUBOCE AVE intersection | - | IFO 220 | - | - | - | - | - | 119440 | 1546613100000 | -122.42236482 | 37.7698677 | - | - | - | D8 | - | OTHER REGULATORY | REG | R37(SF).0369 | 14X21 | SUP2 | 2IN IRON POST | IS | 1546434480000 | VALENCIA ST | - | - | - | - | - | - |
| 102159 | N/A | Point | - | - | - | - | S283797 | DUBOCE AVE: VALENCIA ST | - | T | T | - | F | 24403000 | 24403000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VALENCIA ST | DUBOCE AVE | 94348 | 94348 | 37.7698677 | -122.42236482 | DUBOCE AVE \ VALENCIA ST | VALENCIA ST \ DUBOCE AVE | 1710539427000 | MTA | EXCEPT BIKE (SYM) | DUBOCE AVE intersection | - | - | - | - | - | - | - | 119441 | 1679011200000 | -122.42236482 | 37.7698677 | - | - | - | D8 | - | OTHER REGULATORY | REG | R(SF).0362 | 24X18 | SUP2 | SIGNAL POLE | IS | 1656594960000 | VALENCIA ST | - | - | - | - | - | - |
| 102160 | N/A | Point | - | - | - | - | S283798 | DUBOCE AVE: VALENCIA ST | - | T | T | - | F | 24403000 | 24403000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VALENCIA ST | DUBOCE AVE | 94349 | 94349 | 37.7698677 | -122.42236482 | DUBOCE AVE \ VALENCIA ST | VALENCIA ST \ DUBOCE AVE | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | DUBOCE AVE intersection | - | - | - | - | - | - | - | 119442 | 1679011200000 | -122.42236482 | 37.7698677 | - | - | - | D8 | - | NO RIGHT TURN | REG | R13A(CA).0002 | 24X30 | SUP2 | SIGNAL POLE | IS | 1656595020000 | VALENCIA ST | - | - | - | - | - | - |
| 102161 | N/A | Point | - | - | - | - | S255249 | VALENCIA ST: DUBOCE AVE | - | T | T | - | F | 24403000 | 24403000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | DUBOCE AVE | 102950 | 102950 | 37.7698677 | -122.42236482 | DUBOCE AVE \ VALENCIA ST | VALENCIA ST \ DUBOCE AVE | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED ARROW | DUBOCE AVE intersection | - | - | - | - | - | - | - | 119443 | 1545868800000 | -122.42236482 | 37.7698677 | - | 1565222400000 | - | D8 | - | NO RIGHT TURN | REG | R13A(SF).0006 | 24X30 | SUP2 | OVERHEAD MAST ARM | IS | 1560337680000 | VALENCIA ST | - | - | - | - | - | - |
| 102162 | N/A | Point | - | - | - | - | S255246 | DUBOCE AVE: VALENCIA ST | - | T | T | - | F | 24403000 | 24403000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VALENCIA ST | DUBOCE AVE | 102948 | 102948 | 37.7698677 | -122.42236482 | DUBOCE AVE \ VALENCIA ST | VALENCIA ST \ DUBOCE AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) | DUBOCE AVE intersection | - | - | - | - | - | - | - | 119444 | 1421107200000 | -122.42236482 | 37.7698677 | - | 1565222400000 | - | D8 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | OVERHEAD MAST ARM | IS | 1560336660000 | VALENCIA ST | - | - | - | - | - | - |
| 102163 | N/A | Point | - | - | - | - | S255262 | VALENCIA ST: DUBOCE AVE | - | T | T | - | F | 24403000 | 24403000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | DUBOCE AVE | 103230 | 103230 | 37.7698677 | -122.42236482 | DUBOCE AVE \ VALENCIA ST | VALENCIA ST \ DUBOCE AVE | 1710539427000 | MTA | EXCEPT BIKE (SYM) | DUBOCE AVE intersection | - | INSTALL UNDER NO RIGHT TURN ON RED ARROW | - | - | - | - | - | 119445 | 1545868800000 | -122.42236482 | 37.7698677 | - | 1565222400000 | - | D8 | - | OTHER REGULATORY | REG | R(SF).0362 | 24X18 | SUP2 | OVERHEAD MAST ARM | IS | 1560344700000 | VALENCIA ST | - | - | - | - | - | - |
| 102164 | N/A | Point | - | - | - | - | S255257 | VALENCIA ST: DUBOCE AVE | - | T | T | - | F | 24403000 | 24403000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | DUBOCE AVE | 102952 | 102952 | 37.7698677 | -122.42236482 | DUBOCE AVE \ VALENCIA ST | VALENCIA ST \ DUBOCE AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) | DUBOCE AVE intersection | - | - | - | - | - | - | - | 119446 | 1545868800000 | -122.42236482 | 37.7698677 | - | 1565222400000 | - | D8 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | OVERHEAD MAST ARM | IS | 1560344460000 | VALENCIA ST | - | - | - | - | - | - |
| 102165 | N/A | Point | - | - | - | - | S279382 | VALENCIA ST: DUBOCE AVE | - | T | T | - | F | 24403000 | 24403000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | DUBOCE AVE | 111439 | 111439 | 37.7698677 | -122.42236482 | DUBOCE AVE \ VALENCIA ST | VALENCIA ST \ DUBOCE AVE | 1710539427000 | MTA | SPEED LIMIT 20 | DUBOCE AVE intersection | - | - | - | - | - | - | - | 119447 | 1548201600000 | -122.42236482 | 37.7698677 | - | - | - | D8 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | OVERHEAD MAST ARM | IS | 1638952860000 | VALENCIA ST | - | - | - | - | - | - |
| 102166 | N/A | Point | - | - | - | - | S255252 | VALENCIA ST: DUBOCE AVE | - | T | T | - | F | 24403000 | 24403000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | DUBOCE AVE | 117866 | 117866 | 37.7698677 | -122.42236482 | DUBOCE AVE \ VALENCIA ST | VALENCIA ST \ DUBOCE AVE | 1710539427000 | MTA | EXCEPT BIKE (SYM) | DUBOCE AVE intersection | - | INSTALL UNDER NO RIGHT TURN LIGHT SIGN | - | - | - | - | - | 119448 | 1545868800000 | -122.42236482 | 37.7698677 | - | 1565222400000 | - | D8 | - | OTHER REGULATORY | REG | R(SF).0362 | 24X18 | SUP2 | OVERHEAD MAST ARM | IS | 1560338040000 | VALENCIA ST | - | - | - | - | - | - |
| 102167 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S115782 | 1600-1699 KIRKWOOD AVE | 1600-1699 KIRKWOOD AVE | F | F | - | F | 7895000 | 7895000 | - | - | NORTH SIDE | - | - | - | - | NEWHALL ST | NEWHALL ST | 115246 | 115246 | 37.73869707 | -122.39089478 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | NEWHALL ST to PHELPS ST (1600 - 1699) | - | WPL # 1678 | - | - | - | - | - | 119449 | 1039219200000 | -122.39089478 | 37.73869707 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373572500000 | KIRKWOOD AVE | 1600 - 1699 KIRKWOOD AVE | 1600 - 1699 KIRKWOOD AVE | 1600 KIRKWOOD AVE | - | PHELPS ST | PHELPS ST |
| 102168 | N/A | Point | - | - | - | - | S250499 | VALENCIA ST: DUBOCE AVE | - | T | T | - | F | 24403000 | 24403000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | DUBOCE AVE | 115675 | 115675 | 37.7698677 | -122.42236482 | DUBOCE AVE \ VALENCIA ST | VALENCIA ST \ DUBOCE AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) | DUBOCE AVE intersection | - | - | - | - | - | - | - | 119450 | 1545911460000 | -122.42236482 | 37.7698677 | - | - | - | D8 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1545896340000 | VALENCIA ST | - | - | - | - | - | - |
| 102169 | N/A | Point | - | - | - | - | S281101 | SANTA YNEZ AVE: OTSEGO AVE | - | F | F | - | F | 22073000 | 22073000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SANTA YNEZ AVE | SANTA YNEZ AVE | 93074 | 93074 | 37.72468141 | -122.4403165 | OTSEGO AVE \ SANTA YNEZ AVE | OTSEGO AVE \ SANTA YNEZ AVE | 1710539427000 | MTA | SPEED HUMP | SANTA YNEZ AVE intersection | - | - | - | - | - | - | - | 119451 | 1645833600000 | -122.4403165 | 37.72468141 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1645711080000 | OTSEGO AVE | - | - | - | - | - | - |
| 102170 | N/A | Point | 1 | 1 | 1 - 45 | - | S148870 | 1-45 SANTA CLARA AVE | 1-45 SANTA CLARA AVE | F | F | - | F | 11568000 | 11568000 | - | - | WEST SIDE | - | - | - | - | PORTOLA DR \ VICENTE ST | PORTOLA DR \ VICENTE ST | 43652 | 43652 | 37.73886474 | -122.46600112 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM 2ND & 4TH TUE OF MONTH STCL | PORTOLA DR \ VICENTE ST to SANTA MONICA WAY \ YERBA BUENA AVE (1 - 45) | - | 20 SANTA CLARA | - | - | - | - | - | 119452 | 1225065600000 | -122.46600112 | 37.73886474 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0074 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375729080000 | SANTA CLARA AVE | 1 - 45 SANTA CLARA AVE | 1 - 45 SANTA CLARA AVE | 1 SANTA CLARA AVE | - | SANTA MONICA WAY \ YERBA BUENA AVE | SANTA MONICA WAY \ YERBA BUENA AVE |
| 102171 | N/A | Point | 1 | 1 | 100 - 149 | - | S216214 | 100-149 KEARNY ST | 100-149 KEARNY ST | F | F | - | F | 7749000 | 7749000 | - | - | WEST SIDE | - | - | - | - | POST ST | POST ST | 55038 | 55038 | 37.78912885 | -122.40370376 | - | - | 1719450695000 | middleware_editor | TANS 7AM-9AM/3PM-7PM EXC SAT & SUN | POST ST to VER MEHR PL (100 - 149) | - | 85' N OF POST | - | - | - | - | - | 119453 | 1432114800000 | -122.40370376 | 37.78912885 | - | 1432080000000 | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0071 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1431949740000 | KEARNY ST | 100 - 149 KEARNY ST | 100 - 149 KEARNY ST | 100 KEARNY ST | - | VER MEHR PL | VER MEHR PL |
| 102172 | N/A | Point | 1 | 1 | 100 - 149 | - | S135145 | 100-149 KEARNY ST | 100-149 KEARNY ST | F | F | - | F | 7749000 | 7749000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | POST ST | POST ST | 31951 | 31951 | 37.78912885 | -122.40370376 | - | - | 1719450697000 | middleware_editor | "P" (WHITE-BLUE) | POST ST to VER MEHR PL (100 - 149) | - | OPP #141 | - | - | - | - | - | 119454 | 1318896000000 | -122.40370376 | 37.78912885 | - | - | - | D3 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1373578560000 | KEARNY ST | 100 - 149 KEARNY ST | 100 - 149 KEARNY ST | 100 KEARNY ST | - | VER MEHR PL | VER MEHR PL |
| 102173 | N/A | Point | 1 | 1 | 100 - 149 | - | S135152 | 100-149 KEARNY ST | 100-149 KEARNY ST | F | F | - | F | 7749000 | 7749000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | POST ST | POST ST | 28233 | 28233 | 37.78912885 | -122.40370376 | - | - | 1719450725000 | middleware_editor | ST MARYS SQUARE (VA) PORTSMOUTH SQUARE (VA) | POST ST to VER MEHR PL (100 - 149) | - | OPP #141 | - | - | - | - | - | 119455 | 1318896000000 | -122.40370376 | 37.78912885 | - | - | - | D3 | - | OTHER GUIDE | GUIDE | G-S(SF).0033 | 30X30 | SUP1 | LIGHT POLE | IS | 1373578560000 | KEARNY ST | 100 - 149 KEARNY ST | 100 - 149 KEARNY ST | 100 KEARNY ST | - | VER MEHR PL | VER MEHR PL |
| 102174 | N/A | Point | 1 | 1 | 1 - 45 | - | S148869 | 1-45 SANTA CLARA AVE | 1-45 SANTA CLARA AVE | F | F | - | F | 11568000 | 11568000 | - | - | WEST SIDE | - | - | - | - | PORTOLA DR \ VICENTE ST | PORTOLA DR \ VICENTE ST | 124706 | 124706 | 37.73886474 | -122.46600112 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM 2ND & 4TH TUE OF MONTH STCL | PORTOLA DR \ VICENTE ST to SANTA MONICA WAY \ YERBA BUENA AVE (1 - 45) | - | 14 SANTA CLARA | - | - | - | - | - | 119456 | 1225065600000 | -122.46600112 | 37.73886474 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0074 | 18X18 | SUP2 | LIGHT POLE | IS | 1375729080000 | SANTA CLARA AVE | 1 - 45 SANTA CLARA AVE | 1 - 45 SANTA CLARA AVE | 1 SANTA CLARA AVE | - | SANTA MONICA WAY \ YERBA BUENA AVE | SANTA MONICA WAY \ YERBA BUENA AVE |
| 102175 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S133562 | 1500-1599 YOSEMITE AVE | 1500-1599 YOSEMITE AVE | F | F | - | F | 13781000 | 13781000 | - | - | SOUTH SIDE | - | - | - | - | JENNINGS ST | JENNINGS ST | 26337 | 26337 | 37.726152166408 | -122.390587172702 | - | - | 1756130454000 | middleware_editor | BIKE RACK | JENNINGS ST to KEITH ST (1500 - 1599) | - | (BIKE RACKS-LIST# 14 ID:G) | - | - | - | - | - | 119457 | 1294300800000 | -122.39073526 | 37.72632094 | - | - | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BARRICADE | IS | 1373578020000 | YOSEMITE AVE | 1500 - 1599 YOSEMITE AVE | 1500 - 1599 YOSEMITE AVE | 1500 YOSEMITE AVE | - | KEITH ST | KEITH ST |
| 102176 | N/A | Point | - | - | - | - | S122936 | 3RD ST: CHANNEL ST | - | F | F | - | F | 34155000 | 34155000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CHANNEL ST | 03RD ST | 20728 | 20728 | 37.77455117 | -122.389865 | 3RD ST \ CHANNEL ST | CHANNEL ST \ 03RD ST | 1710539427000 | MTA | ONE WAY (LA) | 03RD ST intersection | - | - | - | - | - | - | - | 119458 | 1141862400000 | -122.389865 | 37.77455117 | - | 1698659100000 | - | 06 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373574720000 | CHANNEL ST | - | - | - | - | - | - |
| 102177 | N/A | Point | - | - | - | - | 24944 | - | - | F | F | - | F | 24954000 | - | - | - | WEST SIDE | 1698683032000 | elclark | - | - | COSMO PL | - | 165766 | 165766 | 37.788061074038 | -122.412439994111 | TRADER VIC ALY \ COSMO PL | - | 1715120039000 | middleware_editor | TRADER VIC ALLEY | - | - | SWC TRADER VIC ALLEY (END) / COSMO PL | - | - | - | - | - | 119459 | - | - | - | - | - | - | 03 | - | STREET NAME | MISC | D3-1.2069 | - | SUP1 | BUILDING | PI | - | - | - | - | - | - | - | - |
| 102178 | N/A | Point | 1 | 1 | 2900 - 2999 | - | S223467 | 2900-2999 21ST AVE | 2900-2999 21ST AVE | T | T | - | F | 1094000 | 1094000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | SLOAT BLVD | SLOAT BLVD | 63789 | 63789 | 37.73363433 | -122.47701397 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | SLOAT BLVD to OCEAN AVE (2900 - 2999) | - | IFO#2955 | - | - | - | - | - | 119460 | 1456492980000 | -122.47701397 | 37.73363433 | - | 1456444800000 | - | D7 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | LIGHT POLE | IS | 1455627480000 | 21ST AVE | 2900 - 2999 21ST AVE | 2900 - 2999 21ST AVE | 2900 21ST AVE | - | OCEAN AVE | OCEAN AVE |
| 102179 | N/A | Point | - | - | - | - | S125423 | PRAGUE ST: NAYLOR ST | - | F | F | - | F | 21390000 | 21390000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PRAGUE ST | NAYLOR ST | 17896 | 17896 | 37.71081379 | -122.43359984 | NAYLOR ST \ PRAGUE ST | PRAGUE ST \ NAYLOR ST | 1710539427000 | MTA | ALL WAY | NAYLOR ST intersection | - | - | - | - | - | - | - | 119461 | 1157414400000 | -122.43359984 | 37.71081379 | - | 1553558400000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575500000 | PRAGUE ST | - | - | - | - | - | - |
| 102180 | N/A | Point | - | - | - | - | S125424 | PRAGUE ST: NAYLOR ST | - | F | F | - | F | 21390000 | 21390000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PRAGUE ST | NAYLOR ST | 17897 | 17897 | 37.71081379 | -122.43359984 | NAYLOR ST \ PRAGUE ST | PRAGUE ST \ NAYLOR ST | 1710539427000 | MTA | ALL WAY | NAYLOR ST intersection | - | - | - | - | - | - | - | 119462 | 1157414400000 | -122.43359984 | 37.71081379 | - | 1446076800000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575500000 | PRAGUE ST | - | - | - | - | - | - |
| 102181 | N/A | Point | - | 1 | 1100 - 1199 | RIGHT ARROW | S249252 | 1100-1199 22ND ST | 1100-1199 22ND ST | F | F | - | F | 1163000 | 1163000 | - | - | NORTH SIDE | - | - | - | - | IOWA ST | IOWA ST | 81145 | 81145 | 37.75768051 | -122.39262818 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7AM-7PM MON-SAT (5 MIN) | IOWA ST to PENNSYLVANIA AVE (1100 - 1199) | - | 76' E OF PENNSLYVANIA | - | - | - | - | - | 119463 | 1541140740000 | -122.39262818 | 37.75768051 | - | - | 1692354600000 | D10 | - | OTHER REGULATORY | REG | R38(SF)1.0014 | 14X21 | SUP1 | 2IN IRON POST | RETD | 1540810380000 | 22ND ST | 1100 - 1199 22ND ST | 1100 - 1199 22ND ST | 1100 22ND ST | - | PENNSYLVANIA AVE | PENNSYLVANIA AVE |
| 102182 | N/A | Point | 1 | 1 | 800 - 899 | - | S220345 | 800-899 PRAGUE ST | 800-899 PRAGUE ST | F | F | - | F | 10735000 | 10735000 | - | - | SOUTH SIDE | - | - | - | - | NAYLOR ST | NAYLOR ST | 60131 | 60131 | 37.71049949 | -122.43427223 | - | - | 1754419059000 | middleware_editor | NPRK 12NN-2PM TUE STCL | NAYLOR ST to CORDOVA ST (800 - 899) | - | 125`WEST` | - | - | - | - | - | 119464 | - | -122.43427223 | 37.71049949 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0083 | 18X18 | SUP2 | LIGHT POLE | IS | 1445947920000 | PRAGUE ST | 800 - 899 PRAGUE ST | 800 - 899 PRAGUE ST | 800 PRAGUE ST | - | CORDOVA ST | CORDOVA ST |
| 102183 | N/A | Point | 1 | 1 | 100 - 199 | - | S260616 | 100-199 NAYLOR ST | 100-199 NAYLOR ST | F | F | - | F | 9524000 | 9524000 | - | - | EAST SIDE | - | - | - | - | PRAGUE ST | PRAGUE ST | 100244 | 100244 | 37.71054218 | -122.43331654 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM THUR STCL | PRAGUE ST to WINDING WAY (100 - 199) | - | 15 FT NORTH OF WINDING | - | - | - | - | - | 119465 | 1431043200000 | -122.43331654 | 37.71054218 | - | 1586822400000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0080 | 18X18 | SUP2 | 2IN IRON POST | IS | 1579690800000 | NAYLOR ST | 100 - 199 NAYLOR ST | 100 - 199 NAYLOR ST | 100 NAYLOR ST | - | WINDING WAY | WINDING WAY |
| 102184 | N/A | Point | - | - | - | - | S265292 | NAYLOR ST: PRAGUE ST | - | F | F | - | F | 21390000 | 21390000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PRAGUE ST | NAYLOR ST | 113578 | 113578 | 37.71081379 | -122.43359984 | NAYLOR ST \ PRAGUE ST | PRAGUE ST \ NAYLOR ST | 1710539427000 | MTA | NAYLOR ST | NAYLOR ST intersection | - | - | - | - | - | - | - | 119466 | 1319068800000 | -122.43359984 | 37.71081379 | - | - | - | D11 | - | STREET NAME | GUIDE | D3-1.1262 | 36X08 | SUP2 | LIGHT POLE | IS | 1592562600000 | PRAGUE ST | - | - | - | - | - | - |
| 102185 | N/A | Point | - | - | - | - | S265293 | NAYLOR ST: PRAGUE ST | - | F | F | - | F | 21390000 | 21390000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PRAGUE ST | NAYLOR ST | 113579 | 113579 | 37.71081379 | -122.43359984 | NAYLOR ST \ PRAGUE ST | PRAGUE ST \ NAYLOR ST | 1710539427000 | MTA | PRAGUE ST | NAYLOR ST intersection | - | - | - | - | - | - | - | 119467 | 1319068800000 | -122.43359984 | 37.71081379 | - | - | - | D11 | - | STREET NAME | GUIDE | D3-1.1420 | 36X08 | SUP2 | LIGHT POLE | IS | 1592562600000 | PRAGUE ST | - | - | - | - | - | - |
| 102186 | N/A | Point | - | 1 | 1100 - 1199 | LEFT ARROW | S249253 | 1100-1199 22ND ST | 1100-1199 22ND ST | F | F | - | F | 1163000 | 1163000 | - | - | NORTH SIDE | - | - | - | - | IOWA ST | IOWA ST | 81146 | 81146 | 37.75768051 | -122.39262818 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7AM-7PM MON-SAT (5 MIN) | IOWA ST to PENNSYLVANIA AVE (1100 - 1199) | - | 145' E OF PENNSYLVANIA | - | - | - | - | - | 119468 | 1541140800000 | -122.39262818 | 37.75768051 | - | - | 1692352800000 | D10 | - | OTHER REGULATORY | REG | R38(SF)1.0014 | 14X21 | SUP1 | 2IN IRON POST | RETD | 1540810680000 | 22ND ST | 1100 - 1199 22ND ST | 1100 - 1199 22ND ST | 1100 22ND ST | - | PENNSYLVANIA AVE | PENNSYLVANIA AVE |
| 102187 | N/A | Point | - | - | - | - | S106606 | NAYLOR ST: WINDING WAY | - | F | F | - | F | 21389000 | 21389000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | NAYLOR ST | WINDING WAY | 5280 | 5280 | 37.71027056 | -122.43303324 | WINDING WAY \ NAYLOR ST | NAYLOR ST \ WINDING WAY | 1732666784000 | middleware_editor | STOP | WINDING WAY intersection | - | 0 / 0 | - | - | - | - | - | 119469 | 153446400000 | -122.43303324 | 37.71027056 | - | 1732544700000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569620000 | NAYLOR ST | - | - | - | - | - | - |
| 102188 | N/A | Point | - | - | - | - | S263128 | NAYLOR ST: WINDING WAY | - | F | F | - | F | 21389000 | 21389000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WINDING WAY | WINDING WAY | 99933 | 99933 | 37.71027056 | -122.43303324 | NAYLOR ST \ WINDING WAY | NAYLOR ST \ WINDING WAY | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | WINDING WAY intersection | 133031 | UTILITY POLE | - | - | - | - | - | 119470 | 1319068800000 | -122.43303324 | 37.71027056 | - | - | - | D11 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP2 | UTILITY POLE | IS | 1585924320000 | NAYLOR ST | - | - | - | - | - | - |
| 102189 | N/A | Point | - | - | - | - | S233134 | WINDING WAY: NAYLOR ST | - | F | F | - | F | 21389000 | 21389000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WINDING WAY | WINDING WAY | 70950 | 70950 | 37.71027056 | -122.43303324 | NAYLOR ST \ WINDING WAY | NAYLOR ST \ WINDING WAY | 1732207686000 | middleware_editor | ALL WAY | WINDING WAY intersection | - | 0 / 0 | - | - | - | - | - | 119471 | 153446400000 | -122.43303324 | 37.71027056 | - | 1732114200000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1485870060000 | NAYLOR ST | - | - | - | - | - | - |
| 102190 | N/A | Point | - | - | - | - | S125470 | NAYLOR ST: PRAGUE ST | - | F | F | - | F | 21390000 | 21390000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PRAGUE ST | NAYLOR ST | 78764 | 78764 | 37.71081379 | -122.43359984 | NAYLOR ST \ PRAGUE ST | PRAGUE ST \ NAYLOR ST | 1710539427000 | MTA | ALL WAY | NAYLOR ST intersection | - | - | - | - | - | - | - | 119472 | 1157587200000 | -122.43359984 | 37.71081379 | - | - | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575500000 | PRAGUE ST | - | - | - | - | - | - |
| 102191 | N/A | Point | - | - | - | - | 22226 | - | - | - | - | - | - | 1162000 | - | - | - | NORTH SIDE, EASTBOUND TRAFFIC | 1692290453000 | smuneno | - | - | INDIANA ST | - | 147845 | 147845 | 37.7577832761143 | -122.391976474771 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7AM-7PM MON-SAT (5 MIN) | - | - | 10' EAST OF IOWA ST. | - | - | - | - | - | 119473 | 1692357300000 | - | - | - | - | - | 10 | - | OTHER REGULATORY | REG | R38(SF)1.0014 | 14X21 | SUP1 | LIGHT POLE | IS | - | 22ND ST | 1000 - 1099 22ND ST | - | - | - | IOWA ST | - |
| 102192 | N/A | Point | 1 | 1 | 300 - 399 | - | S141764 | 300-399 7TH AVE | 300-399 07TH AVE | F | F | - | F | 352000 | 352000 | - | - | EAST SIDE | - | - | - | - | CLEMENT ST | CLEMENT ST | 32832 | 32832 | 37.78192824 | -122.46542263 | - | - | 1752188431000 | middleware_editor | NPRK 7AM-9AM 1ST & 3RD TUE OF MONTH STCL | CLEMENT ST to GEARY BLVD (300 - 399) | - | 368 7TH AVE | - | - | - | - | - | 119474 | 1220598000000 | -122.46542263 | 37.78192824 | - | 1752172260000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0229 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375725960000 | 07TH AVE | 300 - 399 07TH AVE | 300 - 399 07TH AVE | 300 7TH AVE | - | GEARY BLVD | GEARY BLVD |
| 102193 | N/A | Point | 1 | 1 | 300 - 399 | - | S278895 | 300-399 3RD AVE | 300-399 03RD AVE | F | F | - | F | 154000 | 154000 | - | - | EAST SIDE | - | - | - | - | CLEMENT ST | CLEMENT ST | 122614 | 122614 | 37.78212386 | -122.46113515 | - | - | 1710539427000 | MTA | BIKE RACK | CLEMENT ST to GEARY BLVD (300 - 399) | 398929 | 4' N OF SPL 386/3.5' IN FROM CURB | - | - | - | - | - | 119475 | 1637280000000 | -122.46113515 | 37.78212386 | - | - | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1637148420000 | 03RD AVE | 300 - 399 3RD AVE | 300 - 399 03RD AVE | 300 3RD AVE | - | GEARY BLVD | GEARY BLVD |
| 102194 | N/A | Point | 1 | 1 | 300 - 399 | - | S265511 | 300-399 3RD AVE | 300-399 03RD AVE | F | F | - | F | 154000 | 154000 | - | - | WEST SIDE | - | - | - | - | CLEMENT ST | CLEMENT ST | 121009 | 121009 | 37.78212386 | -122.46113515 | - | - | 1710539427000 | MTA | BIKE RACK | CLEMENT ST to GEARY BLVD (300 - 399) | 148208 | 21' N OF SPL 307/3.5' INI FROM CURB | - | - | - | - | - | 119476 | 1593445500000 | -122.46113515 | 37.78212386 | - | - | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1593165300000 | 03RD AVE | 300 - 399 3RD AVE | 300 - 399 03RD AVE | 300 3RD AVE | - | GEARY BLVD | GEARY BLVD |
| 102195 | N/A | Point | 1 | - | - | - | S134146 | 700-799 MISSION ST | - | F | F | - | F | 9095000 | 9095000 | G-P(SF).0001-2011-04-07 00:00:00-37.78536345--122.40314615 | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | - | - | 25318 | 25318 | 37.78536345 | -122.40314615 | - | - | 1710539427000 | MTA | "P" (WHITE-BLUE) | - | - | 29FT WEST | - | - | - | - | - | 119477 | 1302134400000 | -122.40314615 | 37.78536345 | - | - | - | D6 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP1 | MUNI POLE | IS | 1373578200000 | MISSION ST | 700-799 MISSION ST | MISSION ST | - | - | - | - |
| 102196 | N/A | Point | 1 | 1 | 500 - 599 | - | S254351 | 500-599 PLYMOUTH AVE | 500-599 PLYMOUTH AVE | F | F | - | F | 10516000 | 10516000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | LOBOS ST | LOBOS ST | 90126 | 90126 | 37.71534625 | -122.45607582 | - | - | 1720647705000 | middleware_editor | SPEED HUMP | LOBOS ST to MINERVA ST (500 - 599) | - | 5FT NORTH OF LOBOS | - | - | - | - | - | 119478 | 1560856980000 | -122.45607582 | 37.71534625 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1557997920000 | PLYMOUTH AVE | 500 - 599 PLYMOUTH AVE | 500 - 599 PLYMOUTH AVE | 500 PLYMOUTH AVE | - | MINERVA ST | MINERVA ST |
| 102197 | N/A | Point | - | - | - | - | S256597 | EXCELSIOR AVE: PARIS ST | - | T | T | - | F | 21759000 | 21759000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 104802 | 104802 | 37.725397563 | -122.431982295 | PARIS ST \ EXCELSIOR AVE | PARIS ST \ EXCELSIOR AVE | 1710539427000 | MTA | SPEED HUMP | EXCELSIOR AVE intersection | - | ABOVE SCHOOL 15 MPH SIGN | - | - | - | - | - | 119479 | 130978800000 | -122.43205382 | 37.72548808 | - | 1565136000000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1564495620000 | PARIS ST | - | - | - | - | - | - |
| 102198 | N/A | Point | 1 | 1 | 700 - 999 | - | S257032 | 700-999 ELLSWORTH ST | 700-999 ELLSWORTH ST | F | F | - | F | 5201000 | 5201000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CRESCENT AVE | CRESCENT AVE | 127904 | 127904 | 37.73322801 | -122.4166609 | - | - | 1710539427000 | MTA | SPEED HUMP | CRESCENT AVE to ALEMANY BLVD \ I-280 S OFF RAMP \ I-280 S ON RAMP (700 - 999) | - | IFO 995 5 FT NORTH OF ALEMANY | - | - | - | - | - | 119480 | 1179792000000 | -122.4166609 | 37.73322801 | - | 1577923200000 | - | D9 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1565860620000 | ELLSWORTH ST | 700 - 999 ELLSWORTH ST | 700 - 999 ELLSWORTH ST | 700 ELLSWORTH ST | - | ALEMANY BLVD \ I-280 S OFF RAMP \ I-280 S ON RAMP | ALEMANY BLVD \ I-280 S OFF RAMP \ I-280 S ON RAMP |
| 102199 | N/A | Point | 1 | 1 | 3000 - 3099 | - | S249388 | 3000-3099 KIRKHAM ST | 3000-3099 KIRKHAM ST | F | F | - | F | 7872000 | 7872000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 34TH AVE | 34TH AVE | 81157 | 81157 | 37.75909921 | -122.49347343 | - | - | 1710539427000 | MTA | SPEED HUMP | 34TH AVE to 35TH AVE (3000 - 3099) | - | 5 FT WEST OF 34TH | - | - | - | - | - | 119481 | 1228176000000 | -122.49347343 | 37.75909921 | - | 1541116800000 | - | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1541068620000 | KIRKHAM ST | 3000 - 3099 KIRKHAM ST | 3000 - 3099 KIRKHAM ST | 3000 KIRKHAM ST | - | 35TH AVE | 35TH AVE |
| 102200 | N/A | Point | - | - | - | - | S256610 | MOSCOW ST: FRANCE AVE | - | F | F | - | F | 21398000 | 21398000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FRANCE AVE | FRANCE AVE | 87171 | 87171 | 37.716574514 | -122.431282586 | MOSCOW ST \ FRANCE AVE | MOSCOW ST \ FRANCE AVE | 1710539427000 | MTA | SPEED HUMP | FRANCE AVE intersection | - | UNDER STREET NAMES | - | - | - | - | - | 119482 | 1565617380000 | -122.43115384 | 37.71659361 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 3IN IRON POST | IS | 1564565160000 | MOSCOW ST | - | - | - | - | - | - |
| 102201 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S249390 | 2300-2399 WAWONA ST | 2300-2399 WAWONA ST | F | F | - | F | 23363000 | 13487000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | WAWONA ST | 34TH AVE \ CRESTLAKE DR | 119396 | 119396 | 37.7370801770712 | -122.492314875121 | 35TH AVE \ WAWONA ST | - | 1754672207000 | middleware_editor | SPEED HUMP | 34TH AVE \ CRESTLAKE DR to 35TH AVE (2300 - 2399) | - | 5 FT EAST OF 35TH | - | - | - | - | - | 119483 | 1228204800000 | -122.49191067 | 37.73720629 | - | 1541142000000 | - | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1541069760000 | WAWONA ST | - | 2300 - 2399 WAWONA ST | 2300 WAWONA ST | - | - | 35TH AVE |
| 102202 | N/A | Point | - | - | - | - | S254359 | CORDOVA ST: PRAGUE ST | - | F | F | - | F | 21393000 | 21393000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PRAGUE ST | CORDOVA ST | 87700 | 87700 | 37.71023873 | -122.43497949 | CORDOVA ST \ PRAGUE ST | PRAGUE ST \ CORDOVA ST | 1710539427000 | MTA | SPEED HUMP | CORDOVA ST intersection | - | - | - | - | - | - | - | 119484 | 1308182400000 | -122.43497949 | 37.71023873 | - | 1559779200000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1558005060000 | PRAGUE ST | - | - | - | - | - | - |
| 102203 | N/A | Point | 1 | 1 | 500 - 633 | - | S253371 | 500-633 TEXAS ST | 500-633 TEXAS ST | F | F | - | F | 12543000 | 12543000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 20TH ST | 20TH ST | 90437 | 90437 | 37.75921819 | -122.39523316 | - | - | 1710539427000 | MTA | SPEED HUMP | 20TH ST to SIERRA ST (500 - 633) | - | 15' SOUTH OF 20TH ST. | - | - | - | - | - | 119485 | 1566397440000 | -122.39523316 | 37.75921819 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1554813660000 | TEXAS ST | 500 - 633 TEXAS ST | 500 - 633 TEXAS ST | 500 TEXAS ST | - | SIERRA ST | SIERRA ST |
| 102204 | N/A | Point | 1 | 1 | 600 - 649 | - | S254366 | 600-649 BRUNSWICK ST | 600-649 BRUNSWICK ST | F | F | - | F | 3258000 | 3258000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LOWELL ST | LOWELL ST | 87851 | 87851 | 37.70960786 | -122.44610421 | - | - | 1717809171000 | middleware_editor | SPEED HUMP | LOWELL ST to ROEMER WAY (600 - 649) | - | SPL 614 | - | - | - | - | - | 119486 | 1560164400000 | -122.44610421 | 37.70960786 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1558006740000 | BRUNSWICK ST | 600 - 649 BRUNSWICK ST | 600 - 649 BRUNSWICK ST | 600 BRUNSWICK ST | - | ROEMER WAY | ROEMER WAY |
| 102205 | N/A | Point | - | - | - | - | S254335 | BYXBEE ST: SHIELDS ST | - | F | F | - | F | 22721000 | 22721000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BYXBEE ST | BYXBEE ST | 78579 | 78579 | 37.71788816 | -122.46983763 | SHIELDS ST \ BYXBEE ST | SHIELDS ST \ BYXBEE ST | 1710539427000 | MTA | SPEED HUMP | BYXBEE ST intersection | - | ABOVE PLAYGROUND SIGN | - | - | - | - | - | 119487 | 1561420800000 | -122.46983763 | 37.71788816 | - | 1669852800000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1557925920000 | SHIELDS ST | - | - | - | - | - | - |
| 102206 | N/A | Point | - | - | - | - | S254356 | CORDOVA ST: ROLPH ST | - | F | F | - | F | 21427000 | 21427000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CORDOVA ST | CORDOVA ST | 87698 | 87698 | 37.712452971 | -122.435861132 | ROLPH ST \ CORDOVA ST | ROLPH ST \ CORDOVA ST | 1710539427000 | MTA | SPEED HUMP | CORDOVA ST intersection | - | NPL 65 @PM | - | - | - | - | - | 119488 | 1558440000000 | -122.43633499 | 37.71341205 | - | 1559779200000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1558004400000 | ROLPH ST | - | - | - | - | - | - |
| 102207 | N/A | Point | - | - | - | - | S257794 | SAN JUAN AVE: CAYUGA AVE | - | F | F | - | F | 21800000 | 21800000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CAYUGA AVE | CAYUGA AVE | 88359 | 88359 | 37.72509446 | -122.43793363 | SAN JUAN AVE \ CAYUGA AVE | SAN JUAN AVE \ CAYUGA AVE | 1727295077000 | middleware_editor | SPEED HUMP | CAYUGA AVE intersection | - | - | - | - | - | - | - | 119489 | 1102291200000 | -122.43793363 | 37.72509446 | - | 1569283200000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1568713320000 | SAN JUAN AVE | - | - | - | - | - | - |
| 102208 | N/A | Point | - | - | - | - | S256608 | MOSCOW ST: AMAZON AVE | - | F | F | - | F | 21399000 | 21399000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | AMAZON AVE | AMAZON AVE | 86889 | 86889 | 37.714394713 | -122.432936284 | MOSCOW ST \ AMAZON AVE | MOSCOW ST \ AMAZON AVE | 1710539427000 | MTA | SPEED HUMP | AMAZON AVE intersection | - | - | - | - | - | - | - | 119490 | 1457568000000 | -122.43277714 | 37.71443715 | - | 1565568000000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1564564680000 | MOSCOW ST | - | - | - | - | - | - |
| 102209 | N/A | Point | - | - | - | - | S254339 | PRAGUE ST: CORDOVA ST | - | F | F | - | F | 21393000 | 21393000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | PRAGUE ST | CORDOVA ST | 104148 | 104148 | 37.71023873 | -122.43497949 | CORDOVA ST \ PRAGUE ST | PRAGUE ST \ CORDOVA ST | 1710539427000 | MTA | SPEED HUMP | CORDOVA ST intersection | - | IFO 981 @PM | - | - | - | - | - | 119491 | 244771200000 | -122.43497949 | 37.71023873 | - | 1559779200000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1557928380000 | PRAGUE ST | - | - | - | - | - | - |
| 102210 | N/A | Point | 1 | 1 | 500 - 599 | - | S254350 | 500-599 MOUNT VERNON AVE | 500-599 MOUNT VERNON AVE | F | F | - | F | 9432000 | 9432000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SAN MIGUEL ST | SAN MIGUEL ST | 126328 | 126328 | 37.71885746 | -122.44957935 | - | - | 1710539427000 | MTA | SPEED HUMP | SAN MIGUEL ST to TARA ST (500 - 599) | - | 5FT EAST OF TARA | - | - | - | - | - | 119492 | 1560866820000 | -122.44957935 | 37.71885746 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1557996060000 | MOUNT VERNON AVE | 500 - 599 MOUNT VERNON AVE | 500 - 599 MOUNT VERNON AVE | 500 MOUNT VERNON AVE | - | TARA ST | TARA ST |
| 102211 | N/A | Point | - | - | - | - | S256177 | KANSAS ST: 26TH ST | - | F | F | - | F | 23715000 | 23715000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | KANSAS ST | 26TH ST | 89075 | 89075 | 37.75058076 | -122.40218352 | 26TH ST \ KANSAS ST | KANSAS ST \ 26TH ST | 1710539427000 | MTA | SPEED HUMP | 26TH ST intersection | - | X-STREET IS 26TH ST | - | - | - | - | - | 119493 | 1260835200000 | -122.40218352 | 37.75058076 | - | 1568678400000 | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1563367860000 | KANSAS ST | - | - | - | - | - | - |
| 102212 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S212938 | 1000-1099 PACHECO ST | 1000-1099 PACHECO ST | F | F | - | F | 10089000 | 10089000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 14TH AVE \ ORTEGA WAY | 14TH AVE \ ORTEGA WAY | 51709 | 51709 | 37.75162532 | -122.47127778 | - | - | 1714501136000 | middleware_editor | SPEED HUMP | 14TH AVE \ ORTEGA WAY to 15TH AVE \ MANDALAY LN (1000 - 1099) | - | NPL#1036 | - | - | - | - | - | 119494 | 1424166780000 | -122.47127778 | 37.75162532 | - | 1424131200000 | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1422360480000 | PACHECO ST | 1000 - 1099 PACHECO ST | 1000 - 1099 PACHECO ST | 1000 PACHECO ST | - | 15TH AVE \ MANDALAY LN | 15TH AVE \ MANDALAY LN |
| 102213 | N/A | Point | - | - | - | - | S246639 | BROTHERHOOD WAY: CHUMASERO DR | - | T | T | - | F | 22554000 | 22554000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CHUMASERO DR \ THOMAS MORE WAY | CHUMASERO DR \ THOMAS MORE WAY | 75999 | 75999 | 37.71292738 | -122.47273721 | BROTHERHOOD WAY \ CHUMASERO DR \ THOMAS MORE WAY | BROTHERHOOD WAY \ CHUMASERO DR \ THOMAS MORE WAY | 1710539427000 | MTA | STOP HERE ON RED (45LA) | CHUMASERO DR \ THOMAS MORE WAY intersection | - | - | - | - | - | - | - | 119495 | 1425427200000 | -122.47273721 | 37.71292738 | - | 1530748800000 | - | D7 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP2 | 2IN IRON POST | IS | 1530193080000 | BROTHERHOOD WAY | - | - | - | - | - | - |
| 102214 | N/A | Point | 1 | 1 | 1300 - 1399 | LEFT ARROW | S250162 | 1300-1399 HYDE ST | 1300-1399 HYDE ST | F | F | - | F | 7129000 | 7129000 | - | - | EAST SIDE | - | - | - | - | CLAY ST | CLAY ST | 81446 | 81446 | 37.79324372 | -122.41784744 | - | - | 1710539427000 | MTA | STOP HERE ON RED (45LA) | CLAY ST to WASHINGTON ST (1300 - 1399) | - | 20' SOUTH OF WASHINGTON ST | - | - | - | - | - | 119496 | 1548931260000 | -122.41784744 | 37.79324372 | - | - | - | D3 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP1 | 2IN IRON POST | IS | 1544523420000 | HYDE ST | 1300 - 1399 HYDE ST | 1300 - 1399 HYDE ST | 1300 HYDE ST | - | WASHINGTON ST | WASHINGTON ST |
| 102215 | N/A | Point | - | - | - | - | S127262 | 3RD ST: DONNER AVE | - | F | F | - | F | 20515000 | 20515000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DONNER AVE | 03RD ST | 23093 | 23093 | 37.72469314 | -122.39453212 | 3RD ST \ DONNER AVE | DONNER AVE \ 03RD ST | 1710539427000 | MTA | STOP HERE ON RED (45LA) | 03RD ST intersection | - | BELOW SIGNAL HEAD | - | - | - | - | - | 119497 | 1175040000000 | -122.39453212 | 37.72469314 | - | - | - | D10 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP1 | LIGHT POLE | IS | 1373576100000 | DONNER AVE | - | - | - | - | - | - |
| 102216 | N/A | Point | - | - | - | - | S285080 | HERMANN ST: LAGUNA ST | - | F | F | - | F | 25863000 | 25863000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HERMANN ST | HERMANN ST | 103670 | 103670 | 37.77086855 | -122.42513551 | LAGUNA ST \ HERMANN ST | LAGUNA ST \ HERMANN ST | 1710539427000 | MTA | STOP HERE ON RED (45LA) | HERMANN ST intersection | - | - | - | - | - | - | - | 119498 | 1671667200000 | -122.42513551 | 37.77086855 | - | - | - | D8 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP2 | UTILITY POLE | IS | 1663236780000 | LAGUNA ST | - | - | - | - | - | - |
| 102217 | N/A | Point | - | - | - | - | S202171 | SUTTER ST: MARKET ST | - | F | F | - | F | 30733000 | 30733000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SUTTER ST | MARKET ST | 46757 | 46757 | 37.79029016 | -122.40015247 | MARKET ST \ SUTTER ST | SUTTER ST \ MARKET ST | 1710539427000 | MTA | STOP HERE ON RED (45LA) | MARKET ST intersection | - | 25' W OF MARKET | - | - | - | - | - | 119499 | 1392336000000 | -122.40015247 | 37.79029016 | - | 1649376000000 | - | D3 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP1 | 2IN IRON POST | IS | 1389798060000 | SUTTER ST | - | - | - | - | - | - |
| 102218 | N/A | Point | 1 | 1 | 1775 - 1828 | - | S212941 | 1775-1828 14TH AVE | 1775-1828 14TH AVE | T | T | - | F | 566000 | 566000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | ORTEGA ST | ORTEGA ST | 51712 | 51712 | 37.75453137 | -122.47103353 | - | - | 1710539427000 | MTA | SPEED HUMP | ORTEGA ST to MOUNT LN (1775 - 1828) | - | OPP.C-LINE | - | - | - | - | - | 119500 | 1424267580000 | -122.47103353 | 37.75453137 | - | 1424217600000 | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1422362640000 | 14TH AVE | 1775 - 1828 14TH AVE | 1775 - 1828 14TH AVE | 1775 14TH AVE | - | MOUNT LN | MOUNT LN |
| 102219 | N/A | Point | - | - | - | - | S285087 | LAGUNA ST: HERMANN ST | - | F | F | - | F | 25863000 | 25863000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HERMANN ST | HERMANN ST | 103829 | 103829 | 37.77086855 | -122.42513551 | LAGUNA ST \ HERMANN ST | LAGUNA ST \ HERMANN ST | 1710539427000 | MTA | STOP HERE ON RED (45LA) | HERMANN ST intersection | - | - | - | - | - | - | - | 119501 | 1671753600000 | -122.42513551 | 37.77086855 | - | - | - | D8 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP2 | SIGNAL POLE | IS | 1663237920000 | LAGUNA ST | - | - | - | - | - | - |
| 102220 | N/A | Point | - | - | - | - | S138229 | 3RD ST: STEVENSON ST | - | F | F | - | F | 24639000 | 24639000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | STEVENSON ST | 03RD ST | 33302 | 33302 | 37.78702442 | -122.40302819 | 3RD ST \ STEVENSON ST | STEVENSON ST \ 03RD ST | 1710539427000 | MTA | STOP HERE ON RED (45RA) | 03RD ST intersection | - | - | - | - | - | - | - | 119502 | 1367971200000 | -122.40302819 | 37.78702442 | - | - | - | D6 | - | OTHER REGULATORY | REG | R10-6.0003 | 24X36 | SUP1 | 2IN FLANGE POST | IS | 1373579520000 | STEVENSON ST | - | - | - | - | - | - |
| 102221 | N/A | Point | - | - | - | - | S264914 | CLAYTON ST: IRON ALY | - | F | F | - | F | 32942000 | 32942000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | CLAYTON ST | CLAYTON ST | 98686 | 98686 | 37.75832982 | -122.44456261 | IRON ALY \ CLAYTON ST | IRON ALY \ CLAYTON ST | 1710539427000 | MTA | STOP HERE ON RED (45LA) | CLAYTON ST intersection | - | 30FT WEST OF 1499 CLAYTON AT LINE MARKER | - | - | - | - | - | 119503 | 1623244200000 | -122.44456261 | 37.75832982 | - | - | - | D8 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP2 | 2IN IRON POST | IS | 1591353540000 | IRON ALY | - | - | - | - | - | - |
| 102222 | N/A | Point | - | - | - | - | S201884 | DOLORES ST: MARKET ST | - | F | F | - | F | 25865000 | 25865000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MARKET ST | DOLORES ST | 45738 | 45738 | 37.76904239 | -122.42685829 | DOLORES ST \ MARKET ST | MARKET ST \ DOLORES ST | 1729215907000 | middleware_editor | STOP HERE ON RED (45LA) | DOLORES ST intersection | - | CLINTON PARK INTERSECTION | - | - | - | - | - | 119504 | - | -122.42685829 | 37.76904239 | - | - | - | D8 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP2 | 2IN IRON POST | IS | 1389190500000 | MARKET ST | - | - | - | - | - | - |
| 102223 | N/A | Point | - | - | - | - | S266341 | MISSION BAY DR: BERRY EXTENSIO | - | T | T | - | F | 34187000 | 34187000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MISSION BAY DR | BERRY EXTENSION ST | 129054 | 129054 | 37.7697083 | -122.39826856 | BERRY EXTENSION ST \ MISSION BAY DR | MISSION BAY DR \ BERRY EXTENSION ST | 1727187158000 | middleware_editor | STOP HERE ON RED (45LA) | BERRY EXTENSION ST intersection | - | 15' EAST OF E-LINE, X-WALK @ BERRY EXT | - | - | - | - | - | 119505 | 1596628800000 | -122.39826856 | 37.7697083 | - | - | - | D6 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP1 | 2IN IRON POST | IS | 1594972020000 | MISSION BAY DR | - | - | - | - | - | - |
| 102224 | N/A | Point | - | - | - | - | S204975 | DOLORES ST: MARKET ST | - | F | F | - | F | 25865000 | 25865000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MARKET ST | DOLORES ST | 45128 | 45128 | 37.76904239 | -122.42685829 | DOLORES ST \ MARKET ST | MARKET ST \ DOLORES ST | 1729215937000 | middleware_editor | STOP HERE ON RED (45LA) | DOLORES ST intersection | - | CLINTON PARK INTERSECTION | - | - | - | - | - | 119506 | - | -122.42685829 | 37.76904239 | - | - | - | D8 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP2 | 2IN IRON POST | IS | 1397733120000 | MARKET ST | - | - | - | - | - | - |
| 102225 | N/A | Point | - | - | - | - | S272465 | GOUGH ST: MARKET ST | - | F | F | - | F | 30754000 | 30754000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GOUGH ST | GOUGH ST | 102151 | 102151 | 37.77290912 | -122.42218644 | MARKET ST \ GOUGH ST | MARKET ST \ GOUGH ST | 1710539427000 | MTA | STOP HERE ON RED (45RA) | GOUGH ST intersection | - | - | - | - | - | - | - | 119507 | -397526400000 | -122.42218644 | 37.77290912 | - | - | - | D5 | - | OTHER REGULATORY | REG | R10-6.0003 | 24X36 | SUP1 | 2IN IRON POST | IS | 1613557080000 | MARKET 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.