MTA.signshop_assets
No additional information has been provided for this dataset.
Between for ranges (e.g., 10,100)Regex for pattern matchingCase sensitive for exact matches
| ID | Feature ID | Geometry Type | ACCEPTED | ACTIVE | ADDRANGE | ARROW DIR | ASSET ID | ASSET NAME | ASSET NAME 1 | BAPA | BOOM TRUCK | CANCEL | CLEARANCE PERMIT | CNN | CNN 1 | COMBOKEY | CONDITION | CORNER SIDE FACING | CREATED DATE | CREATED USER | CURLYIDS | ETL | FROM ST | FROM ST 1 | GISOBJID | GLOBALID UDFCHAR44 | GPS LATITUDE | GPS LONGITUDE | INTERSECTION | INTERSECTION 1 | LAST EDITED DATE | LAST EDITED USER | LEGEND | LIMITS | LOCATION TRACK ID | LOC SPEC | NEW PURPOSE | NEW SIGN CODE | NEW SIGN LEGEND | NEW SIGN SIZE | NUM OF ASSETS | OBJECTID 1 | ORIG INSTALL DATE | POINT X | POINT Y | PURPOSE | REPLACEMENT DATE | RETIREMENT DATE | SF SUP DISTRICT | SHEETING | SIGN CATEGORY | SIGN CLASS | SIGN CODE | SIGN SIZE | SIGN SUPERVISOR | SIGN SUPPORT | STATUS CODE | STATUS DATE | STREETNAME | STREET ADDRESS RANGE | STREET ADDRESS RANGE 1 | STREET BLOCK | STREET VIEW | TO ST | TO ST 1 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 116026 | N/A | Point | - | - | - | - | S126216 | OCEAN AVE: 25TH AVE | - | F | F | - | F | 23121000 | 23121000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OCEAN AVE | 25TH AVE | 23779 | 23779 | 37.73247118 | -122.48099356 | 25TH AVE \ OCEAN AVE | OCEAN AVE \ 25TH AVE | 1710539427000 | MTA | ALL WAY | 25TH AVE intersection | - | - | - | - | - | - | - | 133344 | 1165449600000 | -122.48099356 | 37.73247118 | - | 1532995200000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575740000 | OCEAN AVE | - | - | - | - | - | - |
| 116027 | N/A | Point | - | - | - | - | 25788 | - | - | F | F | - | F | 21799000 | - | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | 1701976131000 | mmendiet | - | - | SAN JUAN AVE | - | 173905 | 173905 | 37.7256075776186 | -122.438785723724 | CAPISTRANO AVE \ SAN JUAN AVE | - | 1710539427000 | MTA | ALL WAY | - | - | NWCORNER | - | - | - | - | - | 133345 | 1703157600000 | - | - | - | - | - | 11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP3 | 2IN IRON POST | IS | - | CAPISTRANO AVE | - | - | - | - | - | - |
| 116028 | N/A | Point | 1 | 1 | 177 - 299 | - | S144731 | 177-299 SUSSEX ST | 177-299 SUSSEX ST | F | F | - | F | 12310000 | 12310000 | - | - | SOUTH SIDE | - | - | - | - | CONRAD ST | CONRAD ST | 35269 | 35269 | 37.73651646 | -122.43714346 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM 2ND & 4TH TUE OF MONTH STCL | CONRAD ST to SWISS AVE (177 - 299) | - | 237 SUSSEX | - | - | - | - | - | 133346 | 1222905600000 | -122.43714346 | 37.73651646 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0296 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375727280000 | SUSSEX ST | 177 - 299 SUSSEX ST | 177 - 299 SUSSEX ST | 177 SUSSEX ST | - | SWISS AVE | SWISS AVE |
| 116029 | N/A | Point | - | - | - | - | S128845 | DELANO AVE: SANTA YNEZ AVE | - | F | F | - | F | 22110000 | 22110000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DELANO AVE | DELANO AVE | 23063 | 23063 | 37.72538039 | -122.44161908 | SANTA YNEZ AVE \ DELANO AVE | SANTA YNEZ AVE \ DELANO AVE | 1731076542000 | middleware_editor | STOP | DELANO AVE intersection | - | - | - | - | - | - | - | 133347 | 1205712000000 | -122.44161908 | 37.72538039 | - | 1730974200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373576580000 | SANTA YNEZ AVE | - | - | - | - | - | - |
| 116030 | N/A | Point | - | - | - | - | S245163 | CHENERY ST: ELK ST | - | T | T | - | F | 3933000 | 22268000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MIZPAH ST \ SURREY ST | ELK ST | 84730 | 84730 | 37.73588604 | -122.43972251 | - | CHENERY ST \ ELK ST | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | ELK ST intersection | 93266 | - | - | - | - | - | - | 133348 | 1082419200000 | -122.43972251 | 37.73588604 | - | 1529280000000 | - | D8 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | LIGHT POLE | IS | 1525159920000 | CHENERY ST | 1000 - 1099 CHENERY ST | - | - | - | ELK ST | - |
| 116031 | N/A | Point | - | - | - | - | S210771 | POST ST: LAGUNA ST | - | F | F | - | F | - | 26505000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | - | LAGUNA ST | 51356 | 51356 | 37.78578449 | -122.42814819 | - | POST ST \ LAGUNA ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | LAGUNA ST intersection | - | INTERSECTION IS POST & OCTAVIA ST | - | - | - | - | - | 133349 | - | -122.42814819 | 37.78578449 | - | - | - | D5 | - | OTHER WARNING | WARNING | W11-2.0001 | 18X18 | SUP1 | LIGHT POLE | IS | 1415870520000 | POST ST | - | - | - | - | - | - |
| 116032 | N/A | Point | - | - | - | - | S122735 | FOLSOM ST: 4TH ST | - | F | F | - | F | 23938000 | 23938000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 4TH ST | FOLSOM ST | 15626 | 15626 | 37.78202427 | -122.40115972 | FOLSOM ST \ 4TH ST | 04TH ST \ FOLSOM ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | FOLSOM ST intersection | - | - | - | - | - | - | - | 133350 | 1139961600000 | -122.40115972 | 37.78202427 | - | - | - | D6 | - | NO RIGHT TURN | REG | R13A(CA).0001 | 18X30 | SUP1 | 2IN IRON POST | IS | 1373574660000 | 04TH ST | - | - | - | - | - | - |
| 116033 | N/A | Point | 1 | 1 | 350 - 399 | - | S118788 | 350-399 SURREY ST | 350-399 SURREY ST | F | F | - | F | 12304000 | 12304000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | SWISS AVE | SWISS AVE | 14573 | 14573 | 37.73574078 | -122.43840199 | - | - | 1748037957000 | middleware_editor | SCHOOL (SYM) AHEAD | SWISS AVE to CHENERY ST \ MIZPAH ST (350 - 399) | 93265 | SPL #360 | - | - | - | - | - | 133351 | 1082530800000 | -122.43840199 | 37.73574078 | - | 1709663400000 | - | D8 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1373573460000 | SURREY ST | 350 - 399 SURREY ST | 350 - 399 SURREY ST | 350 SURREY ST | - | CHENERY ST \ MIZPAH ST | CHENERY ST \ MIZPAH ST |
| 116034 | N/A | Point | 1 | 1 | 800 - 899 | - | S143036 | 800-899 EUCLID AVE | 800-899 EUCLID AVE | F | F | - | F | 5299000 | 5299000 | - | - | NORTH SIDE | - | - | - | - | PALM AVE | PALM AVE | 32914 | 32914 | 37.78385046 | -122.45848369 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM 1ST & 3RD FRI OF MONTH STCL | PALM AVE to ARGUELLO BLVD (800 - 899) | - | 804 EUCLID | - | - | - | - | - | 133352 | 1220572800000 | -122.45848369 | 37.78385046 | - | 1405468800000 | - | D2 | - | STREET CLEANING | REG | R30B(CA).0226 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1375726560000 | EUCLID AVE | 800 - 899 EUCLID AVE | 800 - 899 EUCLID AVE | 800 EUCLID AVE | - | ARGUELLO BLVD | ARGUELLO BLVD |
| 116035 | N/A | Point | 1 | 1 | 800 - 899 | - | S258339 | 800-899 EUCLID AVE | 800-899 EUCLID AVE | - | - | - | F | 5299000 | 5299000 | - | - | SOUTH SIDE | - | - | - | - | PALM AVE | PALM AVE | 88781 | 88781 | 37.78385046 | -122.45848369 | - | - | 1710539427000 | MTA | BIKE RACK | PALM AVE to ARGUELLO BLVD (800 - 899) | 70217 | 53' W OF WPL#835/3' IN FROM CURB | - | - | - | - | - | 133353 | 1571310840000 | -122.45848369 | 37.78385046 | - | - | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1571234820000 | EUCLID AVE | 800 - 899 EUCLID AVE | 800 - 899 EUCLID AVE | 800 EUCLID AVE | - | ARGUELLO BLVD | ARGUELLO BLVD |
| 116036 | N/A | Point | - | - | - | - | 21808 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1690927613000 | MTA | - | - | KIRKHAM ST | - | 144181 | 144181 | 37.759472 | -122.463847 | - | - | 1722531297000 | middleware_editor | TANSAT (RA) | - | - | 20`NORTH OF LAWTON | - | - | - | - | - | 133354 | - | -122.463847 | 37.759472 | - | - | - | 07 | - | TOW (TANSAT) | REG | R37(CA).0093 | 14X21 | SUP3 | 2IN IRON POST | D | - | - | - | - | - | - | LAWTON ST \ WARREN DR | - |
| 116037 | N/A | Point | - | - | - | - | S255528 | TAYLOR ST: OFARRELL ST | - | F | F | - | F | 24942000 | 24942000 | TYPE-DL.0011-2019-06-22 12:45:00-37.78599624--122.41132558 | - | SOUTH WEST CORNER | - | - | - | - | OFARRELL ST | TAYLOR ST | 86438 | 86438 | 37.78599624 | -122.41132558 | TAYLOR ST \ OFARRELL ST | OFARRELL ST \ TAYLOR ST | 1722435184000 | middleware_editor | FG 300 UR DELINEATOR (W) | TAYLOR ST intersection | - | - | - | - | - | - | - | 133355 | 1561207500000 | -122.41132558 | 37.78599624 | - | 1722333600000 | - | D3 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1561131060000 | OFARRELL ST | - | - | - | - | - | - |
| 116038 | N/A | Point | - | - | - | - | S251776 | CLAY ST: HYDE ST | - | F | F | - | F | 25258000 | 25258000 | - | - | SOUTH EAST CORNER | - | - | - | - | HYDE ST | CLAY ST | 76848 | 76848 | 37.79280364 | -122.41775912 | CLAY ST \ HYDE ST | HYDE ST \ CLAY ST | 1710539427000 | MTA | CLAY ST | CLAY ST intersection | - | <1500 WEST | - | - | - | - | - | 133356 | 1553856840000 | -122.41775912 | 37.79280364 | - | 1698145200000 | - | D3 | - | STREET NAME | GUIDE | D3-1.0391 | 36X08 | SUP1 | 3IN IRON POST | IS | 1550823120000 | HYDE ST | - | - | - | - | - | - |
| 116039 | N/A | Point | - | - | - | - | 24881 | - | - | F | F | - | F | 4942000 | - | - | - | WEST SIDE | 1698270900000 | jrasmuss | - | - | MARKET ST | - | 164870 | 164870 | 37.7609165720592 | -122.439421112591 | - | - | 1710539427000 | MTA | BIKE RACK | - | 817783 | 12' S OF NPL 192/3.5' IN FROM CURB | - | - | - | - | - | 133357 | - | - | - | - | - | - | 08 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP3 | BIKE RACK | PI | - | DOUGLASS ST | 137 - 199 DOUGLASS ST | - | - | - | 18TH ST | - |
| 116040 | N/A | Point | 1 | 1 | 600 - 699 | RIGHT ARROW | S257438 | 600-699 CLAY ST | 600-699 CLAY ST | T | T | - | F | 4086000 | 4086000 | - | - | SOUTH SIDE | - | - | - | - | MONTGOMERY ST | MONTGOMERY ST | 90410 | 90410 | 37.79455964 | -122.40396788 | - | - | 1710539427000 | MTA | TANS 7AM-9AM/3PM-6PM EXC SAT & SUN | MONTGOMERY ST to KEARNY ST (600 - 699) | - | 130' WEST OF MONTGOMERYST. | - | - | - | - | - | 133358 | 1570454280000 | -122.40396788 | 37.79455964 | - | - | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0067 | 18X21 | SUP1 | 2IN FLANGE POST | IS | 1566995880000 | CLAY ST | 600 - 699 CLAY ST | 600 - 699 CLAY ST | 600 CLAY ST | - | KEARNY ST | KEARNY ST |
| 116041 | N/A | Point | 1 | 1 | 600 - 699 | - | S273084 | 600-699 CLAY ST | 600-699 CLAY ST | F | F | - | F | 4086000 | 4086000 | - | - | NORTH SIDE | - | - | - | - | MONTGOMERY ST | MONTGOMERY ST | 120805 | 120805 | 37.79455964 | -122.40396788 | - | - | 1728684736000 | middleware_editor | BIKE RACK | MONTGOMERY ST to KEARNY ST (600 - 699) | 328864 | 14' E OF WPL 662/2.5' IN FROM CURB | - | - | - | - | - | 133359 | 1615383660000 | -122.40396788 | 37.79455964 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1615283580000 | CLAY ST | 600 - 699 CLAY ST | 600 - 699 CLAY ST | 600 CLAY ST | - | KEARNY ST | KEARNY ST |
| 116042 | N/A | Point | - | - | - | - | 24822 | - | - | - | - | - | - | 1630000 | - | - | - | NORTH SIDE | 1698165481000 | jsanfel | - | - | SAN JOSE AVE | - | 164577 | 164577 | 37.7439150432194 | -122.424105541814 | - | - | 1746117791000 | middleware_editor | TA (SYM) NO STOPPING EXC PERMITTED CSV-GETAROUND | - | - | 15' EAST OF DOLORES | - | - | - | - | - | 133360 | - | - | - | - | 1698856200000 | 1746117660000 | 08 | - | OTHER REGULATORY | REG | R37(SF).0293 | 05X12 | SUP3 | 2IN IRON POST | RETD | - | 29TH ST | 100 - 199 29TH ST | - | - | - | DOLORES ST | - |
| 116043 | N/A | Point | - | - | - | - | 25392 | - | - | - | - | - | - | 4165000 | - | - | - | NORTH SIDE | 1700496528000 | jrasmuss | - | - | 15TH AVE | - | 170291 | 170291 | 37.7825762465348 | -122.474255853035 | - | - | 1710539427000 | MTA | WHEEL STOP | - | - | 11' W OF 15TH AVE/6" FROM CURB ON W LINE OF CORRAL | - | - | - | - | - | 133361 | 1704716400000 | - | - | - | - | - | 01 | - | OTHER WARNING | WARNING | W(SF).0072 | 36X08 | SUP2 | SPIKE | IS | - | CLEMENT ST | 1400 - 1499 CLEMENT ST | - | - | - | 16TH AVE | - |
| 116044 | N/A | Point | - | - | - | - | 25386 | - | - | F | F | - | F | 4165000 | - | - | - | NORTH SIDE | 1700496307000 | jrasmuss | - | - | 15TH AVE | - | 170273 | 170273 | 37.7825759198716 | -122.474263037694 | - | - | 1710539427000 | MTA | BIKE RACK | - | - | 3.5' W OF 15TH AVE/3.5' FROM CURB IN CORRAL | - | - | - | - | - | 133362 | 1704704400000 | - | - | - | - | - | 01 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | - | CLEMENT ST | 1400 - 1499 CLEMENT ST | - | - | - | 16TH AVE | - |
| 116045 | N/A | Point | - | - | - | - | 25395 | - | - | F | F | - | F | 9121000 | - | - | - | WEST SIDE | 1700500215000 | jrasmuss | - | - | 19TH ST | - | 170293 | 170293 | 37.7595365112509 | -122.419239799796 | - | - | 1722531702000 | middleware_editor | BIKE RACK | - | - | 2' S OF NPL 2348/3.5' IN FROM CURB | - | - | - | - | - | 133363 | - | - | - | - | - | - | 09 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP3 | BIKE RACK | IS | - | MISSION ST | 2300 - 2399 MISSION ST | - | - | - | 20TH ST | - |
| 116046 | N/A | Point | - | - | - | - | 25398 | - | - | T | T | - | F | 21486000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1700500617000 | evillan | - | - | GENEVA AVE | - | 170277 | 170277 | 37.7164351643828 | -122.441173448446 | MISSION ST \ GENEVA AVE | - | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | - | - | SWC | - | - | - | - | - | 133364 | - | - | - | - | - | - | 11 | - | NO RIGHT TURN | REG | R13A(CA).0001 | 18X30 | SUP3 | OVERHEAD MAST ARM | PI | - | MISSION ST | - | - | - | - | - | - |
| 116047 | N/A | Point | - | - | - | - | 25397 | - | - | F | F | - | F | 21486000 | - | - | - | SOUTH WEST CORNER | 1700500474000 | evillan | - | - | GENEVA AVE | - | 170294 | 170294 | 37.7164441818465 | -122.441174118999 | MISSION ST \ GENEVA AVE | - | 1753809691000 | middleware_editor | GENEVA AVE | - | - | SWC 900 EAST | - | - | - | - | - | 133365 | - | - | - | - | - | - | 11 | - | STREET NAME | GUIDE | D3-1.0722 | 36X08 | SUP3 | SIGNAL POLE | IS | - | MISSION ST | - | - | - | - | - | - |
| 116048 | N/A | Point | - | - | - | - | 25400 | - | - | F | F | - | F | 21486000 | - | - | - | SOUTH EAST CORNER | 1700501212000 | evillan | - | - | GENEVA AVE | - | 170337 | 170337 | 37.7162680758854 | -122.441047384623 | MISSION ST \ GENEVA AVE | - | 1710539427000 | MTA | MISSION ST | - | - | SEC 5150 SOUTH | - | - | - | - | - | 133366 | - | - | - | - | - | - | 11 | - | STREET NAME | GUIDE | D3-1.1207 | 36X08 | SUP3 | SIGNAL POLE | PI | - | MISSION ST | - | - | - | - | - | - |
| 116049 | N/A | Point | - | - | - | - | S234638 | GENEVA AVE: MOSCOW ST \ SOUTH | - | T | T | - | F | 21396000 | 21396000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | GENEVA AVE \ SOUTH HILL BLVD | GENEVA AVE \ SOUTH HILL BLVD | 116411 | 116411 | 37.71314316 | -122.43370682 | MOSCOW ST \ GENEVA AVE \ SOUTH HILL BLVD | MOSCOW ST \ GENEVA AVE \ SOUTH HILL BLVD | 1710539427000 | MTA | MOSCOW ST | GENEVA AVE \ SOUTH HILL BLVD intersection | - | @MOSCOW ST | - | - | - | - | - | 133367 | 1511956500000 | -122.43370682 | 37.71314316 | - | 1511913600000 | - | D11 | - | STREET NAME | GUIDE | D3-2.0250 | 72X18 | SUP2 | LIGHT POLE | IS | 1490625240000 | MOSCOW ST | - | - | - | - | - | - |
| 116050 | N/A | Point | - | - | - | - | S285788 | GENEVA AVE: MOSCOW ST \ SOUTH | - | F | F | - | F | 21396000 | 21396000 | - | - | SOUTH EAST CORNER | - | - | - | - | GENEVA AVE \ SOUTH HILL BLVD | GENEVA AVE \ SOUTH HILL BLVD | 101146 | 101146 | 37.71314316 | -122.43370682 | MOSCOW ST \ GENEVA AVE \ SOUTH HILL BLVD | MOSCOW ST \ GENEVA AVE \ SOUTH HILL BLVD | 1710539427000 | MTA | MOSCOW ST | GENEVA AVE \ SOUTH HILL BLVD intersection | - | (END). | - | - | - | - | - | 133368 | - | -122.43370682 | 37.71314316 | - | 1697810700000 | - | D11 | - | STREET NAME | GUIDE | D3-1.1238 | 36X08 | SUP2 | SIGNAL POLE | IS | 1667293200000 | MOSCOW ST | - | - | - | - | - | - |
| 116051 | N/A | Point | - | - | - | - | S234637 | GENEVA AVE: MOSCOW ST \ SOUTH | - | T | T | - | F | 21396000 | 21396000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | GENEVA AVE \ SOUTH HILL BLVD | GENEVA AVE \ SOUTH HILL BLVD | 71179 | 71179 | 37.71314316 | -122.43370682 | MOSCOW ST \ GENEVA AVE \ SOUTH HILL BLVD | MOSCOW ST \ GENEVA AVE \ SOUTH HILL BLVD | 1710539427000 | MTA | MOSCOW ST | GENEVA AVE \ SOUTH HILL BLVD intersection | - | @MOSCOW ST | - | - | - | - | - | 133369 | - | -122.43370682 | 37.71314316 | - | - | - | D11 | - | STREET NAME | GUIDE | D3-2.0250 | 72X18 | SUP2 | LIGHT POLE | IS | 1490625180000 | MOSCOW ST | - | - | - | - | - | - |
| 116052 | N/A | Point | - | - | - | - | S223179 | GENEVA AVE: MOSCOW ST \ SOUTH | - | F | F | - | F | 21396000 | 21396000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | GENEVA AVE \ SOUTH HILL BLVD | GENEVA AVE \ SOUTH HILL BLVD | 59456 | 59456 | 37.71314316 | -122.43370682 | MOSCOW ST \ GENEVA AVE \ SOUTH HILL BLVD | MOSCOW ST \ GENEVA AVE \ SOUTH HILL BLVD | 1725907288000 | middleware_editor | SPEED LIMIT 25 | GENEVA AVE \ SOUTH HILL BLVD intersection | - | X ST IS MOSCOW | - | - | - | - | - | 133370 | 1455616020000 | -122.43370682 | 37.71314316 | - | - | 1725538800000 | D11 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP2 | SIGNAL POLE | RETD | 1454661540000 | MOSCOW ST | - | - | - | - | - | - |
| 116053 | N/A | Point | - | - | - | - | S223178 | GENEVA AVE: MOSCOW ST \ SOUTH | - | F | F | - | F | 21396000 | 21396000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | GENEVA AVE \ SOUTH HILL BLVD | GENEVA AVE \ SOUTH HILL BLVD | 117788 | 117788 | 37.71314316 | -122.43370682 | MOSCOW ST \ GENEVA AVE \ SOUTH HILL BLVD | MOSCOW ST \ GENEVA AVE \ SOUTH HILL BLVD | 1725907284000 | middleware_editor | SPEED LIMIT 25 | GENEVA AVE \ SOUTH HILL BLVD intersection | - | - | - | - | - | - | - | 133371 | 1591953600000 | -122.43370682 | 37.71314316 | - | - | 1725544500000 | D11 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP2 | SIGNAL POLE | RETD | 1454661360000 | MOSCOW ST | - | - | - | - | - | - |
| 116054 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S261117 | 1300-1399 SANTIAGO ST | 1300-1399 SANTIAGO ST | F | F | - | F | 11615000 | 11615000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 24TH AVE | 24TH AVE | 111218 | 111218 | 37.74465768 | -122.48171593 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | 24TH AVE to 25TH AVE (1300 - 1399) | - | EPL 1325 | - | - | - | - | - | 133372 | 1319673600000 | -122.48171593 | 37.74465768 | - | - | - | D4 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1580910600000 | SANTIAGO ST | 1300 - 1399 SANTIAGO ST | 1300 - 1399 SANTIAGO ST | 1300 SANTIAGO ST | - | 25TH AVE | 25TH AVE |
| 116055 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S152271 | 1300-1399 SANTIAGO ST | 1300-1399 SANTIAGO ST | F | F | - | F | 11615000 | 11615000 | - | - | SOUTH SIDE | - | - | - | - | 24TH AVE | 24TH AVE | 40275 | 40275 | 37.74465768 | -122.48171593 | - | - | 1724709835000 | middleware_editor | NPRK 1PM-3PM 2ND & 4TH THUR OF MONTH STCL | 24TH AVE to 25TH AVE (1300 - 1399) | - | 1331 SANTIAGO | - | - | - | - | - | 133373 | 1228780800000 | -122.48171593 | 37.74465768 | - | 1724674260000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0100 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375730580000 | SANTIAGO ST | 1300 - 1399 SANTIAGO ST | 1300 - 1399 SANTIAGO ST | 1300 SANTIAGO ST | - | 25TH AVE | 25TH AVE |
| 116056 | N/A | Point | - | - | - | - | 25776 | - | - | F | T | - | F | - | - | - | - | NORTH WEST CORNER | 1701972660000 | mmendiet | - | - | - | - | 173843 | 173843 | 37.7208675649007 | -122.446657755565 | - | - | 1710539427000 | MTA | SAN JOSE AVE | - | - | 2300-->S. | - | - | - | - | - | 133374 | - | - | - | - | 1709284800000 | - | 11 | - | STREET NAME | GUIDE | D3-1.1564 | 36X08 | SUP3 | MUNI POLE | IS | - | - | - | - | - | - | - | - |
| 116057 | N/A | Point | - | 1 | 1 - 37 | - | S278632 | 1-37 CLEMENTINA ST | 1-37 CLEMENTINA ST | F | F | - | F | 4194000 | 4194000 | - | - | SOUTH SIDE | - | - | - | - | 1ST ST | 01ST ST | 119858 | 119858 | 37.78740858 | -122.39540024 | - | - | 1726510964000 | middleware_editor | NPRK 12MN-6AM TUE THUR STCL | 01ST ST to ECKER ST (1 - 37) | - | 70' WEST OF WPL# 33 / UNDER OVERPASS | - | - | - | - | - | 133375 | 1647302400000 | -122.39540024 | 37.78740858 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0058 | 18X18 | SUP1 | 2IN IRON POST | IS | 1636018560000 | CLEMENTINA ST | 1 - 37 CLEMENTINA ST | 1 - 37 CLEMENTINA ST | 1 CLEMENTINA ST | - | ECKER ST | ECKER ST |
| 116058 | N/A | Point | - | - | - | - | S137379 | WEST PORTAL AVE: 14TH AVE | - | F | F | - | F | 22926000 | 22926000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WEST PORTAL AVE | 14TH AVE | 28927 | 28927 | 37.73796988 | -122.46905668 | 14TH AVE \ WEST PORTAL AVE | WEST PORTAL AVE \ 14TH AVE | 1710539427000 | MTA | ALL WAY | 14TH AVE intersection | - | - | - | - | - | - | - | 133376 | 1349136000000 | -122.46905668 | 37.73796988 | - | 1577664000000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373579220000 | WEST PORTAL AVE | - | - | - | - | - | - |
| 116059 | N/A | Point | 1 | 1 | 100 - 199 | - | S246381 | 100-199 HYDE ST | 100-199 HYDE ST | F | F | - | F | 7114000 | 7115000 | - | - | EAST SIDE | - | - | - | - | MCALLISTER ST | GOLDEN GATE AVE | 76075 | 76075 | 37.78211965 | -122.41559953 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7AM-6PM MON-SAT (5 MIN) | GOLDEN GATE AVE to TURK ST (100 - 199) | - | 125' SOUTH OF GOLDEN GATE | - | - | - | - | - | 133377 | 1528967580000 | -122.41559953 | 37.78211965 | - | - | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0026 | 14X21 | SUP1 | 2IN FLANGE POST | IS | 1528899120000 | HYDE ST | 50 - 99 HYDE ST | 100 - 199 HYDE ST | 100 HYDE ST | - | GOLDEN GATE AVE | TURK ST |
| 116060 | N/A | Point | 1 | 1 | 100 - 199 | LEFT ARROW | S272814 | 100-199 HYDE ST | 100-199 HYDE ST | F | F | - | F | 7115000 | 7115000 | - | - | WEST SIDE | - | - | - | - | GOLDEN GATE AVE | GOLDEN GATE AVE | 99680 | 99680 | 37.78211965 | -122.41559953 | - | - | 1711748436000 | middleware_editor | TANSAT | GOLDEN GATE AVE to TURK ST (100 - 199) | - | 25' NORTH OF GOLDEN GATE AVE. | - | - | - | - | - | 133378 | - | -122.41559953 | 37.78211965 | - | 1643155200000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1670316600000 | HYDE ST | 100 - 199 HYDE ST | 100 - 199 HYDE ST | 100 HYDE ST | - | TURK ST | TURK ST |
| 116061 | N/A | Point | 1 | 1 | 50 - 99 | - | S272811 | 50-99 HYDE ST | 50-99 HYDE ST | F | F | - | F | 7114000 | 7114000 | - | - | WEST SIDE | - | - | - | - | MCALLISTER ST | MCALLISTER ST | 99679 | 99679 | 37.78118672 | -122.4154104 | - | - | 1710539427000 | MTA | TANSAT | MCALLISTER ST to GOLDEN GATE AVE (50 - 99) | - | 130 FT NORTH OF MCALLISTER | - | - | - | - | - | 133379 | 1614778620000 | -122.4154104 | 37.78118672 | - | - | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1614686280000 | HYDE ST | 50 - 99 HYDE ST | 50 - 99 HYDE ST | 50 HYDE ST | - | GOLDEN GATE AVE | GOLDEN GATE AVE |
| 116062 | N/A | Point | 1 | 1 | 50 - 99 | - | S127105 | 50-99 HYDE ST | 50-99 HYDE ST | F | F | - | F | 7114000 | 7114000 | - | - | EAST SIDE | - | - | - | - | MCALLISTER ST | MCALLISTER ST | 16777 | 16777 | 37.7810262944822 | -122.415310158262 | - | - | 1749070007000 | middleware_editor | NPRK 6AM-8AM TUE THUR SUN STCL | MCALLISTER ST to GOLDEN GATE AVE (50 - 99) | - | 66' N OF MCALLISTER | - | - | - | - | - | 133380 | 1173769200000 | -122.4154104 | 37.78118672 | - | 1749069960000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0196 | 18X18 | SUP1 | LIGHT POLE | IS | 1373576040000 | HYDE ST | 50 - 99 HYDE ST | 50 - 99 HYDE ST | 50 HYDE ST | - | GOLDEN GATE AVE | GOLDEN GATE AVE |
| 116063 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S259224 | 1100-1199 LAKE ST | 1100-1199 LAKE ST | F | F | - | F | 8020000 | 8020000 | - | - | SOUTH SIDE | - | - | - | - | 12TH AVE | 12TH AVE | 126922 | 126922 | 37.78636037 | -122.47164997 | - | - | 1710539427000 | MTA | BIKE RACK | 12TH AVE to FUNSTON AVE (1100 - 1199) | 71135 | 13' W OF EPL 1101//3' IN FROM CURB | - | - | - | - | - | 133381 | 1573816800000 | -122.47164997 | 37.78636037 | - | - | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1573728900000 | LAKE ST | 1100 - 1199 LAKE ST | 1100 - 1199 LAKE ST | 1100 LAKE ST | - | FUNSTON AVE | FUNSTON AVE |
| 116064 | N/A | Point | 1 | 1 | 177 - 199 | - | S142220 | 177-199 2ND AVE | 177-199 02ND AVE | F | F | - | F | 120000 | 120000 | - | - | WEST SIDE | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 31063 | 31063 | 37.78527242 | -122.46028892 | - | - | 1742851011000 | middleware_editor | NPRK 7AM-9AM 1ST & 3RD WED OF MONTH STCL | CALIFORNIA ST to CORNWALL ST (177 - 199) | - | 87 FEET NORTH OF CORNWALL | - | - | - | - | - | 133382 | 1220511600000 | -122.46028892 | 37.78527242 | - | 1742840400000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0230 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1375726200000 | 02ND AVE | 177 - 199 2ND AVE | 177 - 199 02ND AVE | 177 2ND AVE | - | CORNWALL ST | CORNWALL ST |
| 116065 | N/A | Point | 1 | 1 | 131 - 164 | - | S252364 | 131-164 2ND ST | 131-164 02ND ST | F | F | - | F | 133000 | 133000 | - | - | WEST SIDE | - | - | - | - | MINNA ST | MINNA ST | 80676 | 80676 | 37.78739137 | -122.39902233 | - | - | 1755180939000 | middleware_editor | FG 300 UR DELINEATOR (W) | MINNA ST to NATOMA ST (131 - 164) | - | MINNA TO NPL 144 | - | - | - | - | - | 133383 | 1556056800000 | -122.39902233 | 37.78739137 | - | 1755008100000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1552474080000 | 02ND ST | 131 - 164 2ND ST | 131 - 164 02ND ST | 131 2ND ST | - | NATOMA ST | NATOMA ST |
| 116066 | N/A | Point | - | - | - | - | S130175 | POST ST: GRANT AVE | - | F | F | - | F | 24660000 | 24660000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | GRANT AVE | GRANT AVE | 25497 | 25497 | 37.78869399 | -122.40522117 | POST ST \ GRANT AVE | POST ST \ GRANT AVE | 1746134735000 | middleware_editor | RIGHT LANE BUS LANE ENDS | GRANT AVE intersection | - | - | - | - | - | - | - | 133384 | 1233561600000 | -122.40522117 | 37.78869399 | - | - | 1727471640000 | D3 | - | OTHER REGULATORY | REG | SR60-7(CA).0002 | 30X42 | SUP1 | LIGHT POLE | RETD | 1373577000000 | POST ST | - | - | - | - | - | - |
| 116067 | N/A | Point | - | - | - | - | S130091 | BUSH ST: SANSOME ST | - | F | F | - | F | 24679000 | 24679000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | BUSH ST | BUSH ST | 22142 | 22142 | 37.79117717 | -122.40074402 | SANSOME ST \ BUSH ST | SANSOME ST \ BUSH ST | 1727377043000 | middleware_editor | RIGHT LANE BUS LANE ENDS | BUSH ST intersection | - | - | - | - | - | - | - | 133385 | 1232582400000 | -122.40074402 | 37.79117717 | - | - | - | D3 | - | OTHER REGULATORY | REG | SR60-7(CA).0002 | 30X42 | SUP1 | LIGHT POLE | IS | 1373576940000 | SANSOME ST | - | - | - | - | - | - |
| 116068 | N/A | Point | - | - | - | - | S130785 | MISSION ST: BEALE ST | - | F | F | - | F | 24554000 | 24554000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | BEALE ST | BEALE ST | 108259 | 108259 | 37.79115281 | -122.39581342 | MISSION ST \ BEALE ST | MISSION ST \ BEALE ST | 1710539427000 | MTA | RIGHT LANE BUS LANE ENDS | BEALE ST intersection | - | - | - | - | - | - | - | 133386 | 1242259200000 | -122.39581342 | 37.79115281 | - | - | - | D6 | - | OTHER REGULATORY | REG | SR60-7(CA).0002 | 30X42 | SUP1 | OVERHEAD MAST ARM | IS | 1604323620000 | MISSION ST | - | - | - | - | - | - |
| 116069 | N/A | Point | 1 | 1 | 200 - 267 | - | S130612 | 200-267 4TH ST | 200-267 04TH ST | F | F | - | F | 254000 | 254000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | HOWARD ST | HOWARD ST | 26112 | 26112 | 37.78285599 | -122.40220218 | - | - | 1710539427000 | MTA | RIGHT LANE BUS LANE ENDS | HOWARD ST to CLEMENTINA ST (200 - 267) | - | 45FT SOUTH OF CLEMENTINA | - | - | - | - | - | 133387 | 1240185600000 | -122.40220218 | 37.78285599 | - | - | - | D6 | - | OTHER REGULATORY | REG | SR60-7(CA).0002 | 30X42 | SUP1 | LIGHT POLE | IS | 1373577120000 | 04TH ST | 200 - 267 4TH ST | 200 - 267 04TH ST | 200 4TH ST | - | CLEMENTINA ST | CLEMENTINA ST |
| 116070 | N/A | Point | - | - | - | - | S130603 | 3RD ST: KEARNY ST \ MARKET ST | - | T | T | - | F | 30738000 | 30738000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | 3RD ST \ MARKET ST | 03RD ST \ MARKET ST | 125687 | 125687 | 37.78764185 | -122.4034308 | KEARNY ST \ 3RD ST \ MARKET ST | KEARNY ST \ 03RD ST \ MARKET ST | 1719417806000 | middleware_editor | RIGHT LANE BUS LANE ENDS | 03RD ST \ MARKET ST intersection | - | - | - | - | - | - | - | 133388 | 1239926400000 | -122.4034308 | 37.78764185 | - | - | - | D3 | - | OTHER REGULATORY | REG | SR60-7(CA).0002 | 30X42 | SUP1 | MUNI POLE | IS | 1373577120000 | KEARNY ST | - | - | - | - | - | - |
| 116071 | N/A | Point | - | - | - | - | S130220 | SUTTER ST: GOUGH ST | - | F | F | - | F | 26502000 | 26502000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | GOUGH ST | GOUGH ST | 125376 | 125376 | 37.78713043 | -122.42504695 | SUTTER ST \ GOUGH ST | SUTTER ST \ GOUGH ST | 1755541326000 | middleware_editor | RIGHT LANE BUS LANE ENDS | GOUGH ST intersection | - | - | - | - | - | - | - | 133389 | 1233820800000 | -122.42504695 | 37.78713043 | - | - | - | D2 | - | OTHER REGULATORY | REG | SR60-7(CA).0002 | 30X42 | SUP1 | LIGHT POLE | IS | 1373577000000 | SUTTER ST | - | - | - | - | - | - |
| 116072 | N/A | Point | - | 1 | 200 - 249 | - | S131573 | 200-249 FREMONT ST | 200-249 FREMONT ST | F | F | - | F | 5863000 | 5863000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | HOWARD ST | HOWARD ST | 21947 | 21947 | 37.78890501 | -122.39473728 | - | - | 1710539427000 | MTA | RIGHT LANE BUS LANE ENDS | HOWARD ST to I-80 W OFF RAMP (200 - 249) | - | 307FT SOUTH OPP FREEWAY OFF-RAMP | - | - | - | - | - | 133390 | 1253664000000 | -122.39473728 | 37.78890501 | - | - | - | D6 | - | OTHER REGULATORY | REG | SR60-7(CA).0002 | 30X42 | SUP1 | LIGHT POLE | IS | 1373577420000 | FREMONT ST | 200 - 249 FREMONT ST | 200 - 249 FREMONT ST | 200 FREMONT ST | - | I-80 W OFF RAMP | I-80 W OFF RAMP |
| 116073 | N/A | Point | - | - | - | - | S130136 | CLAY ST: FRONT ST | - | F | F | - | F | 24693000 | 24693000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | FRONT ST | FRONT ST | 22048 | 22048 | 37.79516339 | -122.39914942 | CLAY ST \ FRONT ST | CLAY ST \ FRONT ST | 1710539427000 | MTA | RIGHT LANE BUS LANE ENDS | FRONT ST intersection | - | - | - | - | - | - | - | 133391 | 1233100800000 | -122.39914942 | 37.79516339 | - | - | - | D3 | - | OTHER REGULATORY | REG | SR60-7(CA).0002 | 30X42 | SUP1 | LIGHT POLE | IS | 1373577000000 | CLAY ST | - | - | - | - | - | - |
| 116074 | N/A | Point | - | - | - | - | S134117 | POST ST: STOCKTON ST | - | F | F | - | F | 24908000 | 24908000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | STOCKTON ST | STOCKTON ST | 24154 | 24154 | 37.78849948 | -122.40677114 | POST ST \ STOCKTON ST | POST ST \ STOCKTON ST | 1710539427000 | MTA | RIGHT LANE BUS LANE ENDS | STOCKTON ST intersection | - | - | - | - | - | - | - | 133392 | 1301443200000 | -122.40677114 | 37.78849948 | - | - | - | D3 | - | OTHER REGULATORY | REG | SR60-7(CA).0002 | 30X42 | SUP1 | LIGHT POLE | IS | 1373578200000 | POST ST | - | - | - | - | - | - |
| 116075 | N/A | Point | 1 | 1 | 4300 - 4399 | - | S130362 | 4300-4399 JUDAH ST | 4300-4399 JUDAH ST | F | F | - | F | 7685000 | 7685000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | 48TH AVE | 48TH AVE | 25971 | 25971 | 37.76030607 | -122.50860439 | - | - | 1715390812000 | middleware_editor | LEFT LANE TRAIN LANE ENDS | 48TH AVE to LA PLAYA (4300 - 4399) | - | 20`EAST | - | - | - | - | - | 133393 | 1236556800000 | -122.50860439 | 37.76030607 | - | - | - | D4 | - | OTHER REGULATORY | REG | SR60-7(CA).0004 | 30X42 | SUP2 | MUNI POLE | IS | 1373577060000 | JUDAH ST | 4300 - 4399 JUDAH ST | 4300 - 4399 JUDAH ST | 4300 JUDAH ST | - | LA PLAYA | LA PLAYA |
| 116076 | N/A | Point | - | - | - | - | S130543 | JUDAH ST: 19TH AVE | - | F | F | - | F | 27366000 | 27366000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | JUDAH ST | 19TH AVE | 25583 | 25583 | 37.7616065897264 | -122.477157376701 | 19TH AVE \ JUDAH ST | JUDAH ST \ 19TH AVE | 1745934235000 | gorr | LEFT LANE TRAIN LANE ENDS | 19TH AVE intersection | - | - | - | - | - | - | - | 133394 | 1239174000000 | -122.47701089 | 37.76169938 | - | - | - | D4 | - | OTHER REGULATORY | REG | SR60-7(CA).0004 | 30X42 | SUP2 | MUNI POLE | IS | 1373577120000 | JUDAH ST | - | - | - | - | - | - |
| 116077 | N/A | Point | - | - | - | - | S133068 | JONES ST: BEACH ST | - | F | F | - | F | 25595000 | 25595000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | BEACH ST | BEACH ST | 25804 | 25804 | 37.80707251 | -122.41726063 | JONES ST \ BEACH ST | JONES ST \ BEACH ST | 1710539427000 | MTA | RIGHT LANE TRANSIT LANE ENDS | BEACH ST intersection | - | - | - | - | - | - | - | 133395 | 1285200000000 | -122.41726063 | 37.80707251 | - | - | - | D3 | - | OTHER REGULATORY | REG | SR60-7(CA).0006 | 30X42 | SUP1 | LIGHT POLE | IS | 1373577900000 | JONES ST | - | - | - | - | - | - |
| 116078 | N/A | Point | - | - | - | - | S133074 | JEFFERSON ST: JONES ST | - | F | F | - | F | 25596000 | 25596000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | JONES ST | JONES ST | 27880 | 27880 | 37.80801332 | -122.41744594 | JEFFERSON ST \ JONES ST | JEFFERSON ST \ JONES ST | 1710539427000 | MTA | RIGHT LANE TRANSIT LANE ENDS | JONES ST intersection | - | - | - | - | - | - | - | 133396 | 1285286400000 | -122.41744594 | 37.80801332 | - | - | - | D3 | - | OTHER REGULATORY | REG | SR60-7(CA).0006 | 30X42 | SUP1 | LIGHT POLE | IS | 1373577900000 | JEFFERSON ST | - | - | - | - | - | - |
| 116079 | N/A | Point | - | - | - | - | S267798 | 8TH ST: HOWARD ST | - | T | T | - | F | 24299000 | 24299000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | 8TH ST | 08TH ST | 106155 | 106155 | 37.77622136 | -122.41160611 | HOWARD ST \ 8TH ST | HOWARD ST \ 08TH ST | 1710539427000 | MTA | RIGHT LANE BUSES TAXIS ONLY-AT ALL TIMES(VA-DN) | 08TH ST intersection | - | DIRECTLY OVER RIGHT LANE/ SBT | - | - | - | - | - | 133397 | 1603799520000 | -122.41160611 | 37.77622136 | - | - | - | D6 | - | TRANSIT ONLY(RIGHT LANE) | REG | SR60-9(SF).0001 | 30X42 | SUP1 | OVERHEAD MAST ARM | IS | 1598969280000 | HOWARD ST | - | - | - | - | - | - |
| 116080 | N/A | Point | - | - | - | - | S273152 | 400-448 7TH ST | - | T | T | - | F | - | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | - | - | 99991 | 99991 | 37.77513 | -122.4058 | - | - | 1710539427000 | MTA | RIGHT LANE BUSES TAXIS ONLY-AT ALL TIMES(VA-DN) | - | - | ABOVE 3RD TO LEFT LANE | - | - | - | - | - | 133398 | 1616589540000 | -122.4058 | 37.77513 | - | - | - | D6 | - | TRANSIT ONLY(RIGHT LANE) | REG | SR60-9(SF).0001 | 30X42 | SUP1 | FREEWAY COLUMN | IS | 1615462080000 | - | 400-448 7TH ST | - | - | - | - | - |
| 116081 | N/A | Point | - | - | - | - | S126206 | SPRUCE ST: WASHINGTON ST | - | F | F | - | F | 26950000 | 26950000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SPRUCE ST | WASHINGTON ST | 23465 | 23465 | 37.78909863 | -122.45394444 | WASHINGTON ST \ SPRUCE ST | SPRUCE ST \ WASHINGTON ST | 1710539427000 | MTA | ALL WAY | WASHINGTON ST intersection | - | - | - | - | - | - | - | 133399 | 1165449600000 | -122.45394444 | 37.78909863 | - | 1556496000000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575740000 | SPRUCE ST | - | - | - | - | - | - |
| 116082 | N/A | Point | 1 | - | - | - | S252101 | PNDG BROADWAY | - | F | F | - | F | - | 3155000 | - | - | SOUTH SIDE | - | - | - | - | - | - | 77887 | 77887 | 37.79756036 | -122.40915395 | - | - | 1710539427000 | MTA | ONE WAY (RA) | - | - | 12' WEST OF CORDELIA ST./ SIGN F/W/B/T | - | - | - | - | - | 133400 | 1552050960000 | -122.40915395 | 37.79756036 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1551792720000 | BROADWAY | - | BROADWAY | - | - | - | - |
| 116083 | N/A | Point | 1 | - | - | - | S256443 | 1-99 RICHLAND AVE | - | F | F | - | F | 11011002 | 11011000 | - | - | SOUTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | MIGUEL ST | - | 87878 | 87878 | 37.73615237 | -122.4258687 | - | - | 1710539427000 | MTA | CAUTION WATCH FOR PEDESTRIANS & CYCLIST | - | - | WPL #18 AGAINST BRIDGE WALL | - | - | - | - | - | 133402 | 1612878120000 | -122.4258687 | 37.73615237 | - | - | - | D8 | - | OTHER WARNING | WARNING | W(SF).0084 | 12X18 | SUP2 | RETAINING WALL | IS | 1564135920000 | RICHLAND AVE | 1 - 99 RICHLAND AVE | RICHLAND AVE | - | - | MISSION ST | - |
| 116084 | N/A | Point | - | - | - | - | 25510 | - | - | F | F | - | F | 27440000 | - | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | 1701203691000 | malopez | - | - | LINCOLN WAY | - | 171635 | 171635 | 37.764886871723 | -122.488076984877 | 29TH AVE \ LINCOLN WAY | - | 1710890473000 | middleware_editor | FG 300 UR DELINEATOR (W) | - | - | NORTH OF 1201 29TH ON LINCOLN WAY / 4 DELINEATORS | - | - | - | - | 4 | 133403 | 1710763140000 | - | - | - | - | - | 04 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | - | 29TH AVE | - | - | - | - | - | - |
| 116085 | N/A | Point | 1 | 1 | 1500 - 1599 | RIGHT ARROW | S285338 | 1500-1599 CORTLAND AVE | 1500-1599 CORTLAND AVE | F | F | - | F | 4438000 | 4438000 | - | - | NORTH SIDE | - | - | - | - | BRADFORD ST | BRADFORD ST | 96781 | 96781 | 37.7396992 | -122.40918824 | - | - | 1710539427000 | MTA | TANS EXC 30 MIN COMMERCIAL VEH 8AM-6PM MON-FRI | BRADFORD ST to PERALTA AVE (1500 - 1599) | - | IFO 1525 ENTRANCE | - | - | - | - | - | 133404 | 1665532800000 | -122.40918824 | 37.7396992 | - | - | - | D9 | - | OTHER REGULATORY | REG | R37(SF).0185 | 10X15 | SUP2 | 2IN IRON POST | IS | 1664806860000 | CORTLAND AVE | 1500 - 1599 CORTLAND AVE | 1500 - 1599 CORTLAND AVE | 1500 CORTLAND AVE | - | PERALTA AVE | PERALTA AVE |
| 116086 | N/A | Point | - | - | - | - | S112222 | MONTALVO AVE: MAGELLAN AVE | - | F | F | - | F | 22960000 | 22960000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MAGELLAN AVE | MONTALVO AVE | 8754 | 8754 | 37.74444466 | -122.46416112 | MONTALVO AVE \ MAGELLAN AVE | MAGELLAN AVE \ MONTALVO AVE | 1710539427000 | MTA | STOP | MONTALVO AVE intersection | - | - | - | - | - | - | - | 133405 | 936835200000 | -122.46416112 | 37.74444466 | - | 1701873660000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571360000 | MAGELLAN AVE | - | - | - | - | - | - |
| 116087 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S203852 | 1700-1799 37TH AVE | 1700-1799 37TH AVE | F | F | - | F | 1831000 | 1831000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | MORAGA ST | MORAGA ST | 45666 | 45666 | 37.7543208 | -122.49582868 | - | - | 1746656803000 | middleware_editor | SCHOOL (SYM)/SCHOOL | MORAGA ST to NORIEGA ST (1700 - 1799) | - | 175' S OF MORAGA | - | - | - | - | - | 133406 | 1173254400000 | -122.49582868 | 37.7543208 | - | 1746655200000 | - | D4 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1394708220000 | 37TH AVE | 1700 - 1799 37TH AVE | 1700 - 1799 37TH AVE | 1700 37TH AVE | - | NORIEGA ST | NORIEGA ST |
| 116088 | N/A | Point | 1 | 1 | 1 - 99 | - | S215962 | 1-99 MEDA AVE | 1-99 MEDA AVE | F | F | - | F | 8942000 | 8942000 | - | - | NORTH SIDE | - | - | - | - | OCEAN AVE \ OTSEGO AVE | OCEAN AVE \ OTSEGO AVE | 54370 | 54370 | 37.72373859 | -122.44180483 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM WED STCL | OCEAN AVE \ OTSEGO AVE to DELANO AVE (1 - 99) | - | IFO#42 | - | - | - | - | - | 133407 | 1431948360000 | -122.44180483 | 37.72373859 | - | 1431907200000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0312 | 18X18 | SUP2 | 2IN IRON POST | IS | 1431079200000 | MEDA AVE | 1 - 99 MEDA AVE | 1 - 99 MEDA AVE | 1 MEDA AVE | - | DELANO AVE | DELANO AVE |
| 116089 | N/A | Point | - | - | - | - | S128852 | DELANO AVE: SANTA YNEZ AVE | - | F | F | - | F | 22110000 | 22110000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DELANO AVE | DELANO AVE | 21508 | 21508 | 37.72538039 | -122.44161908 | SANTA YNEZ AVE \ DELANO AVE | SANTA YNEZ AVE \ DELANO AVE | 1731076573000 | middleware_editor | ALL WAY | DELANO AVE intersection | - | - | - | - | - | - | - | 133408 | 1205712000000 | -122.44161908 | 37.72538039 | - | 1730972400000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576580000 | SANTA YNEZ AVE | - | - | - | - | - | - |
| 116090 | N/A | Point | 1 | 1 | 1 - 99 | - | S215961 | 1-99 MEDA AVE | 1-99 MEDA AVE | F | F | - | F | 8942000 | 8942000 | - | - | SOUTH SIDE | - | - | - | - | OCEAN AVE \ OTSEGO AVE | OCEAN AVE \ OTSEGO AVE | 54108 | 54108 | 37.72373859 | -122.44180483 | - | - | 1732318376000 | middleware_editor | NPRK 9AM-11AM MON STCL | OCEAN AVE \ OTSEGO AVE to DELANO AVE (1 - 99) | - | IFO#43 | - | - | - | - | - | 133409 | 1432036380000 | -122.44180483 | 37.72373859 | - | 1431993600000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0300 | 18X18 | SUP2 | 2IN IRON POST | IS | 1431078960000 | MEDA AVE | 1 - 99 MEDA AVE | 1 - 99 MEDA AVE | 1 MEDA AVE | - | DELANO AVE | DELANO AVE |
| 116091 | N/A | Point | - | - | - | - | S280239 | SAN JOSE AVE: SANTA YNEZ AVE | - | F | F | - | T | 22115000 | 22115000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | - | - | - | - | SANTA YNEZ AVE | SANTA YNEZ AVE | 107817 | 107817 | 37.72579269 | -122.44238719 | SAN JOSE AVE \ SANTA YNEZ AVE | SAN JOSE AVE \ SANTA YNEZ AVE | 1710539427000 | MTA | STOP | SANTA YNEZ AVE intersection | - | - | - | - | - | - | - | 133410 | - | -122.44238719 | 37.72579269 | - | 1649894400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN BREAK-AWAY SYSTEM | IS | 1641466740000 | SAN JOSE AVE | - | - | - | - | - | - |
| 116092 | N/A | Point | - | - | - | - | S128844 | DELANO AVE: SANTA YNEZ AVE | - | F | F | - | F | 22110000 | 22110000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DELANO AVE | DELANO AVE | 129221 | 129221 | 37.72538039 | -122.44161908 | SANTA YNEZ AVE \ DELANO AVE | SANTA YNEZ AVE \ DELANO AVE | 1731076557000 | middleware_editor | STOP | DELANO AVE intersection | - | - | - | - | - | - | - | 133411 | 1205712000000 | -122.44161908 | 37.72538039 | - | 1730977800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373576580000 | SANTA YNEZ AVE | - | - | - | - | - | - |
| 116093 | N/A | Point | - | - | - | - | S231555 | SANTA YNEZ AVE: SAN JOSE AVE | - | F | F | - | F | 22115000 | 22115000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SANTA YNEZ AVE | SANTA YNEZ AVE | 65861 | 65861 | 37.72579269 | -122.44238719 | SAN JOSE AVE \ SANTA YNEZ AVE | SAN JOSE AVE \ SANTA YNEZ AVE | 1710539427000 | MTA | ALL WAY | SANTA YNEZ AVE intersection | - | X ST IS SAN JOSE AVE | - | - | - | - | - | 133412 | -406425600000 | -122.44238719 | 37.72579269 | - | 1486425600000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481029860000 | SAN JOSE AVE | - | - | - | - | - | - |
| 116094 | N/A | Point | - | - | - | - | S106641 | SANTA YNEZ AVE: DELANO AVE | - | F | F | - | F | 22110000 | 22110000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DELANO AVE | DELANO AVE | 3149 | 3149 | 37.72538039 | -122.44161908 | SANTA YNEZ AVE \ DELANO AVE | SANTA YNEZ AVE \ DELANO AVE | 1731076570000 | middleware_editor | STOP | DELANO AVE intersection | - | 0 / 0 | - | - | - | - | - | 133413 | 154310400000 | -122.44161908 | 37.72538039 | - | 1730976000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569620000 | SANTA YNEZ AVE | - | - | - | - | - | - |
| 116095 | N/A | Point | - | - | - | - | S128854 | SANTA YNEZ AVE: DELANO AVE | - | F | F | - | F | 22110000 | 22110000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DELANO AVE | DELANO AVE | 21510 | 21510 | 37.72538039 | -122.44161908 | SANTA YNEZ AVE \ DELANO AVE | SANTA YNEZ AVE \ DELANO AVE | 1710539427000 | MTA | ALL WAY | DELANO AVE intersection | - | - | - | - | - | - | - | 133414 | 1205712000000 | -122.44161908 | 37.72538039 | - | 1553040000000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576580000 | SANTA YNEZ AVE | - | - | - | - | - | - |
| 116096 | N/A | Point | 1 | 1 | 800 - 899 | - | S142944 | 800-899 EUCLID AVE | 800-899 EUCLID AVE | F | F | - | F | 5299000 | 5299000 | - | - | SOUTH SIDE | - | - | - | - | PALM AVE | PALM AVE | 79064 | 79064 | 37.78385046 | -122.45848369 | - | - | 1732145105000 | middleware_editor | NPRK 11AM-1PM 1ST & 3RD THUR OF MONTH STCL | PALM AVE to ARGUELLO BLVD (800 - 899) | - | 32 FEET EAST OF ARGUELLO | - | - | - | - | - | 133415 | 1220400000000 | -122.45848369 | 37.78385046 | - | 1732114980000 | - | D2 | - | STREET CLEANING | REG | R30B(CA).0018 | 18X18 | SUP1 | 2IN IRON POST | IS | 1375726500000 | EUCLID AVE | 800 - 899 EUCLID AVE | 800 - 899 EUCLID AVE | 800 EUCLID AVE | - | ARGUELLO BLVD | ARGUELLO BLVD |
| 116097 | N/A | Point | 1 | 1 | 800 - 899 | - | S143037 | 800-899 EUCLID AVE | 800-899 EUCLID AVE | F | F | - | F | 5299000 | 5299000 | - | - | NORTH SIDE | - | - | - | - | PALM AVE | PALM AVE | 32915 | 32915 | 37.78385046 | -122.45848369 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM 1ST & 3RD FRI OF MONTH STCL | PALM AVE to ARGUELLO BLVD (800 - 899) | - | 50FT EAST OF ARGUELLO | - | - | - | - | - | 133416 | 1220572800000 | -122.45848369 | 37.78385046 | - | - | - | D2 | - | STREET CLEANING | REG | R30B(CA).0226 | 18X18 | SUP1 | 2IN IRON POST | IS | 1375726560000 | EUCLID AVE | 800 - 899 EUCLID AVE | 800 - 899 EUCLID AVE | 800 EUCLID AVE | - | ARGUELLO BLVD | ARGUELLO BLVD |
| 116098 | N/A | Point | 1 | 1 | 196 - 199 | - | S267209 | 196-199 CHURCH ST | 196-199 CHURCH ST | T | T | - | F | 4009000 | 4009000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 14TH ST | 14TH ST | 98086 | 98086 | 37.76761682 | -122.42895867 | - | - | 1710539427000 | MTA | RIGHT TURN ONLY(SYM) | 14TH ST to MARKET ST (196 - 199) | - | EPL 130 | - | - | - | - | - | 133417 | 1597760820000 | -122.42895867 | 37.76761682 | - | - | - | D8 | - | OTHER REGULATORY | REG | R3-5.0002 | 30X36 | SUP2 | LIGHT POLE | IS | 1597750860000 | CHURCH ST | 196 - 199 CHURCH ST | 196 - 199 CHURCH ST | 196 CHURCH ST | - | MARKET ST | MARKET ST |
| 116099 | N/A | Point | 1 | 1 | 196 - 199 | - | S203462 | 196-199 CHURCH ST | 196-199 CHURCH ST | F | F | - | F | 4009000 | 4009000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 14TH ST | 14TH ST | 42377 | 42377 | 37.76761682 | -122.42895867 | - | - | 1710539427000 | MTA | RIGHT LANE BUSES AND RIGHT TURNS ONLY AT ALL TIMES | 14TH ST to MARKET ST (196 - 199) | - | INFO#152 | - | - | - | - | - | 133418 | - | -122.42895867 | 37.76761682 | - | - | - | D8 | - | TRANSIT ONLY(RIGHT LANE) | REG | SR60-6(CA).0003 | 30X42 | SUP2 | LIGHT POLE | IS | 1393686780000 | CHURCH ST | 196 - 199 CHURCH ST | 196 - 199 CHURCH ST | 196 CHURCH ST | - | MARKET ST | MARKET ST |
| 116100 | N/A | Point | - | - | - | - | S232015 | MIZPAH ST: CHENERY ST \ SURREY | - | F | F | - | F | - | 21983000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | - | CHENERY ST \ SURREY ST | 71316 | 71316 | 37.73566945 | -122.43882125 | - | MIZPAH ST \ CHENERY ST \ SURREY ST | 1710539427000 | MTA | STOP | CHENERY ST \ SURREY ST intersection | - | OF MIZPAH ST. & CHENERY ST. | - | - | - | - | - | 133419 | 1487160300000 | -122.43882125 | 37.73566945 | - | 1487116800000 | - | 08 | - | STOP | REG | R1-1.0002 | 30X30 | SUP3 | 2IN IRON POST | IS | 1482825000000 | MIZPAH ST | - | - | - | - | - | - |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in meters