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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 67651 | N/A | Point | - | - | - | - | S286324 | BAY SHORE BLVD: ARLETA AVE \ S | - | F | F | - | T | 20298000 | 20298000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | ARLETA AVE \ BAY SHORE BLVD | ARLETA AVE \ BAY SHORE BLVD | 106508 | 106508 | 37.71217949 | -122.40245948 | SAN BRUNO AVE \ ARLETA AVE \ BAY SHORE BLVD | SAN BRUNO AVE \ ARLETA AVE \ BAY SHORE BLVD | 1710539427000 | MTA | MUNI LOCAL (FLAG) T- LINE | ARLETA AVE \ BAY SHORE BLVD intersection | 17399 | 18FT SOUTH FROM NORTH END OF ISLAND | - | - | - | - | - | 84767 | 1670630400000 | -122.40245948 | 37.71217949 | - | - | - | D10 | - | OTHER GUIDE | GUIDE | G-L(SF).0046 | 18X24 | SUP1 | MUNI POLE | IS | 1669974660000 | SAN BRUNO AVE | - | - | - | - | - | - |
| 67652 | N/A | Point | - | - | - | - | S107305 | MUNICH ST: BRAZIL AVE | - | F | F | - | F | 21618000 | 21618000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | BRAZIL AVE | 106532 | 106532 | 37.720792956 | -122.426815581 | MUNICH ST \ BRAZIL AVE | MUNICH ST \ BRAZIL AVE | 1710539427000 | MTA | STOP | BRAZIL AVE intersection | - | 0 / 0 | - | - | - | - | - | 84768 | 215654400000 | -122.42683078 | 37.72086792 | - | 1579651200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569800000 | MUNICH ST | - | - | - | - | - | - |
| 67653 | N/A | Point | 1 | 1 | 2700 - 2799 | - | S275309 | 2700-2799 16TH ST | 2700-2799 16TH ST | - | - | - | F | 720000 | 720000 | - | - | NORTH SIDE | - | - | - | - | HARRISON ST \ TREAT AVE | HARRISON ST \ TREAT AVE | 106561 | 106561 | 37.765270862 | -122.413750844 | - | - | 1710539427000 | MTA | DELINEATOR (W) (SAFE HIT) | HARRISON ST \ TREAT AVE to FOLSOM ST (2700 - 2799) | - | E END OF CORRAL | - | - | - | - | - | 84769 | 1673222400000 | -122.41420682 | 37.76538112 | - | - | - | D9 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP2 | BIKE RACK | IS | 1623053160000 | 16TH ST | 2700 - 2799 16TH ST | 2700 - 2799 16TH ST | 2700 16TH ST | - | FOLSOM ST | FOLSOM ST |
| 67654 | N/A | Point | 1 | 1 | 2700 - 2799 | - | S275310 | 2700-2799 16TH ST | 2700-2799 16TH ST | - | - | - | F | 720000 | 720000 | - | - | NORTH SIDE | - | - | - | - | HARRISON ST \ TREAT AVE | HARRISON ST \ TREAT AVE | 106562 | 106562 | 37.765289238 | -122.413736539 | - | - | 1710539427000 | MTA | DELINEATOR (W) (SAFE HIT) | HARRISON ST \ TREAT AVE to FOLSOM ST (2700 - 2799) | - | MIDDLE OF CORRAL | - | - | - | - | - | 84770 | 1673222400000 | -122.41420682 | 37.76538112 | - | - | - | D9 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP2 | BIKE RACK | IS | 1623053340000 | 16TH ST | 2700 - 2799 16TH ST | 2700 - 2799 16TH ST | 2700 16TH ST | - | FOLSOM ST | FOLSOM ST |
| 67655 | N/A | Point | 1 | 1 | 3537 - 3564 | - | S274556 | 3537-3564 19TH ST | 3537-3564 19TH ST | F | F | - | F | 976000 | 976000 | - | - | SOUTH SIDE | - | - | - | - | LAPIDGE ST | LAPIDGE ST | 106602 | 106602 | 37.76003219 | -122.42256882 | - | - | 1710539427000 | MTA | BIKE RACK | LAPIDGE ST to LINDA ST (3537 - 3564) | 337973 | 41' E OF WPL 3540/4' IN FROM CURB | - | - | - | - | - | 84771 | 1621522080000 | -122.42256882 | 37.76003219 | - | - | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1620379560000 | 19TH ST | 3537 - 3564 19TH ST | 3537 - 3564 19TH ST | 3537 19TH ST | - | LINDA ST | LINDA ST |
| 67656 | N/A | Point | 1 | 1 | 700 - 799 | - | S274569 | 700-799 FLORIDA ST | 700-799 FLORIDA ST | F | F | - | F | 5624000 | 5624000 | - | - | EAST SIDE | - | - | - | - | 19TH ST | 19TH ST | 106606 | 106606 | 37.75976834 | -122.41089496 | - | - | 1710539427000 | MTA | BIKE RACK | 19TH ST to 20TH ST (700 - 799) | 337973 | 40' N OF SPL 777/5.5' IN FROM CURB | - | - | - | - | - | 84772 | 1621953600000 | -122.41089496 | 37.75976834 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1620382560000 | FLORIDA ST | 700 - 799 FLORIDA ST | 700 - 799 FLORIDA ST | 700 FLORIDA ST | - | 20TH ST | 20TH ST |
| 67657 | N/A | Point | 1 | 1 | 3147 - 3199 | - | S274572 | 3147-3199 17TH ST | 3147-3199 17TH ST | F | F | - | F | 794000 | 794000 | - | - | SOUTH SIDE | - | - | - | - | SHOTWELL ST | SHOTWELL ST | 106607 | 106607 | 37.76360337 | -122.41677984 | - | - | 1710539427000 | MTA | BIKE RACK | SHOTWELL ST to SOUTH VAN NESS AVE (3147 - 3199) | 327794 | 7' W OF EPL 3153/3.5' IN FROM CURB | - | - | - | - | - | 84773 | 1621946100000 | -122.41677984 | 37.76360337 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1620382740000 | 17TH ST | 3147 - 3199 17TH ST | 3147 - 3199 17TH ST | 3147 17TH ST | - | SOUTH VAN NESS AVE | SOUTH VAN NESS AVE |
| 67658 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S279131 | 1400-1499 IRVING ST | 1400-1499 IRVING ST | F | F | - | F | 7292000 | 7292000 | - | - | NORTH SIDE | - | - | - | - | 15TH AVE | 15TH AVE | 107378 | 107378 | 37.76372763 | -122.4733514 | - | - | 1710539427000 | MTA | BIKE RACK | 15TH AVE to 16TH AVE (1400 - 1499) | 408311 | 24' E OF WPL 1434/4' IN FROM CURB | - | - | - | - | - | 84774 | 1638489600000 | -122.4733514 | 37.76372763 | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1637745360000 | IRVING ST | 1400 - 1499 IRVING ST | 1400 - 1499 IRVING ST | 1400 IRVING ST | - | 16TH AVE | 16TH AVE |
| 67659 | N/A | Point | 1 | 1 | 400 - 499 | LEFT ARROW | S274237 | 400-499 ELIZABETH ST | 400-499 ELIZABETH ST | F | F | - | F | 5146000 | 5146000 | - | - | SOUTH SIDE | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 107380 | 107380 | 37.75229386 | -122.43083905 | - | - | 1735581781000 | middleware_editor | NPRK VEH OVER 6 FT HIGH | SANCHEZ ST to NOE ST (400 - 499) | - | 25 FT WEST OF SANCHEZ | - | - | - | - | - | 84775 | 1265760000000 | -122.43083905 | 37.75229386 | - | 1735032000000 | - | D8 | - | PARKING | REG | R28D(CA).0001 | 12X18 | SUP2 | 2IN IRON POST | IS | 1619182920000 | ELIZABETH ST | 400 - 499 ELIZABETH ST | 400 - 499 ELIZABETH ST | 400 ELIZABETH ST | - | NOE ST | NOE ST |
| 67660 | N/A | Point | - | - | - | - | S274450 | MARKET ST: GOUGH ST | - | F | F | - | F | 30754000 | 30754000 | - | - | NORTH WEST CORNER | - | - | - | - | GOUGH ST | GOUGH ST | 107381 | 107381 | 37.77290912 | -122.42218644 | MARKET ST \ GOUGH ST | MARKET ST \ GOUGH ST | 1746556654000 | middleware_editor | NO PED XING-USE CROSSWALK (RA) | GOUGH ST intersection | - | - | - | - | - | - | - | 84776 | 1402297200000 | -122.42218644 | 37.77290912 | - | 1746556200000 | - | D5 | - | PEDESTRIAN | REG | R49(CA).0006 | 36X18 | SUP1 | 2 POST ALUMINUM | IS | 1620136020000 | MARKET ST | - | - | - | - | - | - |
| 67661 | N/A | Point | - | - | - | - | S277125 | POST ST: PIERCE ST | - | F | F | - | F | 26615000 | 26615000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PIERCE ST | POST ST | 107382 | 107382 | 37.78473607 | -122.43636836 | POST ST \ PIERCE ST | PIERCE ST \ POST ST | 1710539427000 | MTA | (45 LA-DN) | POST ST intersection | - | - | - | - | - | - | - | 84777 | 1181865600000 | -122.43636836 | 37.78473607 | - | 1629676800000 | - | D5 | - | OTHER WARNING | WARNING | W16-7P.0001 | 18X18 | SUP1 | 2IN IRON POST | IS | 1628774340000 | PIERCE ST | - | - | - | - | - | - |
| 67662 | N/A | Point | - | - | - | - | S277126 | POST ST: PIERCE ST | - | F | F | - | F | 26615000 | 26615000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PIERCE ST | POST ST | 107383 | 107383 | 37.78473607 | -122.43636836 | POST ST \ PIERCE ST | PIERCE ST \ POST ST | 1710539427000 | MTA | (45 LA-DN) | POST ST intersection | - | - | - | - | - | - | - | 84778 | 1181865600000 | -122.43636836 | 37.78473607 | - | 1629676800000 | - | D5 | - | OTHER WARNING | WARNING | W16-7P.0001 | 18X18 | SUP1 | 2IN IRON POST | IS | 1628774400000 | PIERCE ST | - | - | - | - | - | - |
| 67663 | N/A | Point | - | - | - | - | S277546 | RICHARDSON AVE: CHESTNUT ST | - | T | T | - | F | 26999000 | 26999000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CHESTNUT ST | RICHARDSON AVE | 107387 | 107387 | 37.79958091 | -122.44596537 | RICHARDSON AVE \ CHESTNUT ST | CHESTNUT ST \ RICHARDSON AVE | 1741207376000 | middleware_editor | RIGHT LANE/ HIGH OCCUPANCY VEH 2+ & TURNS ONLY 5AM-8PM M-F | RICHARDSON AVE intersection | - | - | - | - | - | - | - | 84779 | 1632169860000 | -122.44596537 | 37.79958091 | - | - | - | D2 | - | OTHER REGULATORY | REG | R3-11.0001 | 30X42 | SUP1 | OVERHEAD MAST ARM | IS | 1631190240000 | CHESTNUT ST | - | - | - | - | - | - |
| 67664 | N/A | Point | - | - | - | - | S277548 | FRANCISCO ST: RICHARDSON AVE | - | T | T | - | F | 27023000 | 27023000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | RICHARDSON AVE | FRANCISCO ST | 107388 | 107388 | 37.80038582 | -122.44713057 | FRANCISCO ST \ RICHARDSON AVE | RICHARDSON AVE \ FRANCISCO ST | 1710539427000 | MTA | HOV (HIGH OCCUPANCY VEHICLES) LANE (RA-RA-VA) | FRANCISCO ST intersection | - | - | - | - | - | - | - | 84780 | 1632319620000 | -122.44713057 | 37.80038582 | - | - | - | D2 | - | OTHER WARNING | WARNING | SW54(CA).0002 | 30X30 | SUP1 | OVERHEAD MAST ARM | IS | 1631190420000 | RICHARDSON AVE | - | - | - | - | - | - |
| 67665 | N/A | Point | 1 | 1 | 10 - 54 | - | S277564 | 10-54 MCALLISTER ST | 10-54 MCALLISTER ST | T | T | - | F | 8888000 | 8888000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | JONES ST | JONES ST | 107395 | 107395 | 37.78106497 | -122.41258606 | - | - | 1710539427000 | MTA | EXC BUSES BICYCLES TAXIS AND TRUCKS (SYM) | JONES ST to CHARLES J BRENHAM PL (10 - 54) | - | E-LINE / ON TRIANGULAR ISLAND | - | - | - | - | - | 84781 | 1312243200000 | -122.41258606 | 37.78106497 | - | 1632700800000 | - | D6 | - | OTHER REGULATORY | REG | R(SF).0347 | 30X30 | SUP1 | 2IN IRON POST | IS | 1631261400000 | MCALLISTER ST | 10 - 54 MCALLISTER ST | 10 - 54 MCALLISTER ST | 10 MCALLISTER ST | - | CHARLES J BRENHAM PL | CHARLES J BRENHAM PL |
| 67666 | N/A | Point | 1 | 1 | 300 - 399 | - | S277570 | 300-399 MONTGOMERY ST | 300-399 MONTGOMERY ST | F | F | - | F | 9300000 | 9300000 | - | - | WEST SIDE | - | - | - | - | PINE ST | PINE ST | 107396 | 107396 | 37.79237508 | -122.40266905 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM MON WED FRI STCL | PINE ST to CALIFORNIA ST (300 - 399) | - | 75' S OF CALIFORNIA | - | - | - | - | - | 84782 | 1426032000000 | -122.40266905 | 37.79237508 | - | 1634083200000 | - | D3 | - | STREET CLEANING | REG | R30B(CA).0123 | 18X18 | SUP1 | 2IN FLANGE POST | IS | 1631275740000 | MONTGOMERY ST | 300 - 399 MONTGOMERY ST | 300 - 399 MONTGOMERY ST | 300 MONTGOMERY ST | - | CALIFORNIA ST | CALIFORNIA ST |
| 67667 | N/A | Point | - | - | - | - | S277574 | GREEN ST: SANSOME ST | - | F | F | - | F | 24822000 | 24822000 | - | - | NORTH EAST CORNER | - | - | - | - | GREEN ST | GREEN ST | 107399 | 107399 | 37.80030713 | -122.40260412 | SANSOME ST \ GREEN ST | SANSOME ST \ GREEN ST | 1710539427000 | MTA | GREEN ST | GREEN ST intersection | - | 200 --> W | - | - | - | - | - | 84783 | 1633603500000 | -122.40260412 | 37.80030713 | - | 1685664000000 | - | D3 | - | STREET NAME | GUIDE | D3-1.0771 | 36X08 | SUP1 | 3IN IRON POST | IS | 1631282520000 | SANSOME ST | - | - | - | - | - | - |
| 67668 | N/A | Point | - | - | - | - | S277575 | SANSOME ST: GREEN ST | - | F | F | - | F | 24822000 | 24822000 | - | - | NORTH EAST CORNER | - | - | - | - | GREEN ST | GREEN ST | 107400 | 107400 | 37.80030713 | -122.40260412 | SANSOME ST \ GREEN ST | SANSOME ST \ GREEN ST | 1710539427000 | MTA | SANSOME ST | GREEN ST intersection | - | 1100 --> N | - | - | - | - | - | 84784 | 1633603500000 | -122.40260412 | 37.80030713 | - | 1669852800000 | - | D3 | - | STREET NAME | GUIDE | D3-1.1574 | 36X08 | SUP1 | 3IN IRON POST | IS | 1631282640000 | SANSOME ST | - | - | - | - | - | - |
| 67669 | N/A | Point | - | 1 | 1 - 100 | - | S277226 | 1-99 SERGEANT JOHN V YOUNG ST | 1-100 SERGEANT JOHN V YOUNG ST | F | F | - | F | 11765000 | 11765000 | - | - | WEST SIDE, WESTBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 108437 | 108437 | 37.72497399 | -122.44467747 | - | - | 1710539427000 | MTA | INGLESIDE POLICE STATION - FOR SAFETY AND SEC...(45DN-RA) | SAN JOSE AVE to END: 1-99 BLOCK (1 - 100) | - | AT FENCE AT PARKING LOT | - | - | - | - | - | 84785 | 1629763200000 | -122.44467747 | 37.72497399 | - | 1629763200000 | - | D11 | - | OTHER GUIDE | GUIDE | G-X(SF).0052 | 24X24 | SUP2 | FENCE | IS | 1629809820000 | SERGEANT JOHN V YOUNG ST | 1 - 100 SERGEANT JOHN V YOUNG ST | 1 - 100 SERGEANT JOHN V YOUNG ST | 1 SERGEANT JOHN V YOUNG ST | - | END: 1-99 BLOCK | END: 1-99 BLOCK |
| 67670 | N/A | Point | - | 1 | 1 - 100 | - | S277227 | 1-99 SERGEANT JOHN V YOUNG ST | 1-100 SERGEANT JOHN V YOUNG ST | F | F | - | F | 11765000 | 11765000 | - | - | WEST SIDE, WESTBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 108438 | 108438 | 37.72497399 | -122.44467747 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | SAN JOSE AVE to END: 1-99 BLOCK (1 - 100) | - | AT FENCE AT PARKING LOT | - | - | - | - | - | 84786 | 1629763200000 | -122.44467747 | 37.72497399 | - | 1629763200000 | - | D11 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | FENCE | IS | 1629809940000 | SERGEANT JOHN V YOUNG ST | 1 - 100 SERGEANT JOHN V YOUNG ST | 1 - 100 SERGEANT JOHN V YOUNG ST | 1 SERGEANT JOHN V YOUNG ST | - | END: 1-99 BLOCK | END: 1-99 BLOCK |
| 67671 | N/A | Point | - | - | - | - | S280210 | 16TH ST: DAGGETT ST \ MISSOURI | - | T | T | - | F | 23787000 | 23787000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MISSOURI ST | MISSOURI ST | 108531 | 108531 | 37.76642997 | -122.3968971 | 16TH ST \ MISSOURI ST | 16TH ST \ MISSOURI ST | 1710539427000 | MTA | MISSOURI | MISSOURI ST intersection | - | - | - | - | - | - | - | 84787 | 1642723200000 | -122.3968971 | 37.76642997 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-2.0489 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1641394380000 | 16TH ST | - | - | - | - | - | - |
| 67672 | N/A | Point | - | - | - | - | S103018 | CAYUGA AVE: ROUSSEAU ST | - | F | F | - | F | 21706000 | 21706000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CAYUGA AVE | CAYUGA AVE | 108532 | 108532 | 37.73145973 | -122.42976635 | ROUSSEAU ST \ CAYUGA AVE | ROUSSEAU ST \ CAYUGA AVE | 1737064574000 | middleware_editor | STOP | CAYUGA AVE intersection | - | 0 / 0 | - | - | - | - | - | 84788 | -333331200000 | -122.42976635 | 37.73145973 | - | 1737024600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568480000 | ROUSSEAU ST | - | - | - | - | - | - |
| 67673 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S256454 | 1800-1899 EGBERT AVE | 1800-1899 EGBERT AVE | F | F | - | F | 5118000 | 5118000 | - | - | NORTH SIDE | - | - | - | - | NEWHALL ST | NEWHALL ST | 108533 | 108533 | 37.72728431 | -122.40066462 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM FRI STCL | NEWHALL ST to PHELPS ST (1800 - 1899) | - | 222' EAST OF NEWHALL ST | - | - | - | - | - | 84789 | 1050451200000 | -122.40066462 | 37.72728431 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0046 | 18X18 | SUP1 | 2IN IRON POST | IS | 1564151280000 | EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 - 1899 EGBERT AVE | 1800 EGBERT AVE | - | PHELPS ST | PHELPS ST |
| 67674 | N/A | Point | - | - | - | - | S225473 | HOLLY PARK CIR: HIGHLAND AVE | - | F | F | - | F | 21242000 | 21242000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HOLLY PARK CIR | HOLLY PARK CIR | 108550 | 108550 | 37.73714808 | -122.41880023 | HIGHLAND AVE \ HOLLY PARK CIR | HIGHLAND AVE \ HOLLY PARK CIR | 1746112016000 | middleware_editor | PEDESTRIAN (SYM) | HOLLY PARK CIR intersection | - | SOUTH CROSSWALK / HIGHLAND (EAST) | - | - | - | - | - | 84790 | 1462907760000 | -122.41880023 | 37.73714808 | - | 1462863600000 | - | D9 | - | OTHER WARNING | WARNING | W11-2.0001 | 18X18 | SUP2 | 2IN IRON POST | IS | 1462782600000 | HIGHLAND AVE | - | - | - | - | - | - |
| 67675 | N/A | Point | 1 | 1 | 2300 - 2343 | - | S119066 | 2300-2343 POST ST | 2300-2343 POST ST | F | F | - | F | 10652000 | 10652000 | - | - | NORTH SIDE | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 108591 | 108591 | 37.78428894 | -122.43991791 | - | - | 1710539427000 | MTA | NPPZ 8AM-6PM MON-FRI | DIVISADERO ST to ERKSON CT (2300 - 2343) | - | 81' WEST OF ERKSON CT @ PM | - | - | - | - | - | 84791 | 1087257600000 | -122.43991791 | 37.78428894 | - | - | - | D5 | - | OTHER REGULATORY | REG | R30(SF).0398 | 12X18 | SUP1 | 2IN IRON POST | IS | 1373573520000 | POST ST | 2300 - 2343 POST ST | 2300 - 2343 POST ST | 2300 POST ST | - | ERKSON CT | ERKSON CT |
| 67676 | N/A | Point | - | - | - | - | S241585 | 1ST ST: BUSH ST \ MARKET ST | - | T | T | - | F | 30731000 | 30731000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 1ST ST \ BUSH ST | 01ST ST \ BUSH ST | 109190 | 109190 | 37.79101665 | -122.3991486 | MARKET ST \ 1ST ST \ BUSH ST | MARKET ST \ 01ST ST \ BUSH ST | 1710539427000 | MTA | 49 MILE SCENIC DRIVE | 01ST ST \ BUSH ST intersection | 125 | - | - | - | - | - | - | 84792 | 1583763900000 | -122.3991486 | 37.79101665 | - | 1589760000000 | - | D3 | - | OTHER GUIDE | GUIDE | G-X(SF).0045 | 24X30 | SUP1 | LIGHT POLE | IS | 1513255680000 | MARKET ST | - | - | - | - | - | - |
| 67677 | N/A | Point | - | - | - | - | S236326 | LINCOLN WAY: LA PLAYA \ MARTIN | - | F | F | - | F | 8387201 | 27964000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | LA PLAYA \ MARTIN LUTHER KING JR DR | LA PLAYA \ MARTIN LUTHER KING JR DR | 109191 | 109191 | 37.7640548876597 | -122.509605735535 | - | LINCOLN WAY \ LA PLAYA \ MARTIN LUTHER KING JR DR | 1738257395000 | middleware_editor | STOP | LA PLAYA \ MARTIN LUTHER KING JR DR intersection | - | - | - | - | - | - | - | 84793 | - | -122.50940219 | 37.76403274 | - | - | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1495619400000 | LINCOLN WAY | 4800 - 4898 LINCOLN WAY | - | - | - | GREAT HWY | - |
| 67678 | N/A | Point | - | - | - | - | S236334 | LINCOLN WAY: LA PLAYA \ MARTIN | - | F | F | - | F | 8386201 | 27964000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 48TH AVE | LA PLAYA \ MARTIN LUTHER KING JR DR | 109192 | 109192 | 37.7640613055435 | -122.509214073439 | - | LINCOLN WAY \ LA PLAYA \ MARTIN LUTHER KING JR DR | 1751907462000 | middleware_editor | ALL WAY | LA PLAYA \ MARTIN LUTHER KING JR DR intersection | - | - | - | - | - | - | - | 84794 | - | -122.50940219 | 37.76403274 | - | 1751560140000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1495620120000 | LINCOLN WAY | 4700 - 4798 LINCOLN WAY | - | - | - | LA PLAYA \ MARTIN LUTHER KING JR DR | - |
| 67679 | N/A | Point | - | - | - | - | S239703 | LAGUNA ST: CLEARY CT \ GALILEE | - | F | F | - | F | 26513000 | 26513000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLEARY CT \ GALILEE LN | CLEARY CT \ GALILEE LN | 109193 | 109193 | 37.78392474 | -122.42777887 | LAGUNA ST \ CLEARY CT \ GALILEE LN | LAGUNA ST \ CLEARY CT \ GALILEE LN | 1710539427000 | MTA | ALL WAY | CLEARY CT \ GALILEE LN intersection | - | X ST IS CLEARY | - | - | - | - | - | 84795 | 1509321600000 | -122.42777887 | 37.78392474 | - | 1509321600000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1508507700000 | LAGUNA ST | - | - | - | - | - | - |
| 67680 | N/A | Point | - | - | - | - | S236692 | CHANNEL: EL DORADO ST | - | F | F | - | F | 34174000 | 34174000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CORINNE WOODS WAY | CORINNE WOODS WAY | 109194 | 109194 | 37.77250654 | -122.39393977 | CHANNEL ST \ CORINNE WOODS WAY | CHANNEL ST \ CORINNE WOODS WAY | 1710539427000 | MTA | STOP | CORINNE WOODS WAY intersection | - | X ST EL DORADO SOUTH | - | - | - | - | - | 84796 | 1497011580000 | -122.39393977 | 37.77250654 | - | 1496966400000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1496832840000 | CHANNEL ST | - | - | - | - | - | - |
| 67681 | N/A | Point | 1 | 1 | 951 - 978 | - | S200860 | 951-978 HARRISON ST | 951-978 HARRISON ST | F | F | - | F | 6722000 | 6722000 | - | - | NORTH SIDE | - | - | - | - | OAK GROVE ST | OAK GROVE ST | 109195 | 109195 | 37.7779244 | -122.4032454 | - | - | 1710539427000 | MTA | 2 HR PRK 7AM-6PM EXC SUN | OAK GROVE ST to MORRIS ST (951 - 978) | - | INFO #950 | - | - | - | - | - | 84797 | - | -122.4032454 | 37.7779244 | - | 1682380800000 | - | D6 | - | PARKING | REG | R32(CA).0071 | 18X18 | SUP1 | LIGHT POLE | IS | 1386585000000 | HARRISON ST | 951 - 978 HARRISON ST | 951 - 978 HARRISON ST | 951 HARRISON ST | - | MORRIS ST | MORRIS ST |
| 67682 | N/A | Point | 1 | 1 | 300 - 399 | LEFT ARROW | S238772 | 300-399 MAIN ST | 300-399 MAIN ST | F | F | - | F | 8630000 | 8630000 | - | - | WEST SIDE | - | - | - | - | FOLSOM ST | FOLSOM ST | 109201 | 109201 | 37.78875189 | -122.39108889 | - | - | 1710539427000 | MTA | TANSAT | FOLSOM ST to HARRISON ST (300 - 399) | - | 100`NORTH OF HARRISON | - | - | - | - | - | 84798 | - | -122.39108889 | 37.78875189 | - | - | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP1 | 2IN IRON POST | IS | 1504706100000 | MAIN ST | 300 - 399 MAIN ST | 300 - 399 MAIN ST | 300 MAIN ST | - | HARRISON ST | HARRISON ST |
| 67683 | N/A | Point | - | - | - | - | S241060 | BAKER ST: POST ST | - | F | F | - | F | 26814000 | 26814000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POST ST | BAKER ST | 109202 | 109202 | 37.78389737 | -122.44298911 | BAKER ST \ POST ST | POST ST \ BAKER ST | 1721403498000 | middleware_editor | ALL WAY | BAKER ST intersection | - | - | - | - | - | - | - | 84799 | 1516796940000 | -122.44298911 | 37.78389737 | - | 1516752000000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1512047760000 | POST ST | - | - | - | - | - | - |
| 67684 | N/A | Point | 1 | 1 | 900 - 999 | - | S250566 | 900-999 WAWONA ST | 900-999 WAWONA ST | F | F | - | F | 13476000 | 13476000 | - | - | NORTH SIDE | - | - | - | - | 20TH AVE | 20TH AVE | 109320 | 109320 | 37.73738373 | -122.47690608 | - | - | 1754065550000 | middleware_editor | (LA) WHITE ON GREEN | 20TH AVE to 21ST AVE (900 - 999) | 0341 | 40' EAST OF 21ST ST | - | - | - | - | - | 84800 | 1546552380000 | -122.47690608 | 37.73738373 | - | - | - | D4 | - | OTHER GUIDE | GUIDE | M7-1.0002 | 12X09 | SUP2 | 2IN IRON POST | IS | 1546499220000 | WAWONA ST | 900 - 999 WAWONA ST | 900 - 999 WAWONA ST | 900 WAWONA ST | - | 21ST AVE | 21ST AVE |
| 67685 | N/A | Point | 1 | 1 | 1101 - 1199 | - | S249487 | 0-1199 SAN JOSE AVE | 1101-1199 SAN JOSE AVE | F | F | - | F | 11439102 | 11439102 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | SAINT MARYS AVE | SAINT MARYS AVE | 109321 | 109321 | 37.73463707 | -122.42900196 | - | - | 1710539427000 | MTA | BIKE LANE (SYM) + BEGIN | SAINT MARYS AVE to MILTON ST (1101 - 1199) -- SOUTH -- | - | 256FT. SOUTH OF ST.MARYS AVE. | - | - | - | - | - | 84801 | - | -122.42900196 | 37.73463707 | - | - | - | D8 | - | BIKE REG | REG | R81(CA)/R81A(CA).01 | 24X18 | SUP2 | LIGHT POLE | IS | 1541589060000 | SAN JOSE AVE | 1101 - 1199 SAN JOSE AVE | 1101 - 1199 SAN JOSE AVE | 1101 SAN JOSE AVE | - | MILTON ST | MILTON ST |
| 67686 | N/A | Point | - | 1 | 191 - 199 | LEFT ARROW | S245022 | 191 - 199 KEZAR DR (GGP) | 191-199 KEZAR DR | F | F | - | F | 7827103 | 7827103 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | ARGUELLO BLVD | ARGUELLO BLVD | 109323 | 109323 | 37.76723099 | -122.45845473 | - | - | 1710539427000 | MTA | NPRK ANY TIME | ARGUELLO BLVD to MARTIN LUTHER KING JR DR (191 - 199) -- EAST -- | - | 0 / INSTALL SIGN ON LP 150FT. WEST ..... | - | - | - | - | - | 84802 | 1170892800000 | -122.45845473 | 37.76723099 | - | 1531872000000 | - | D5 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | LIGHT POLE | IS | 1524668520000 | KEZAR DR | 191 - 199 KEZAR DR | 191 - 199 KEZAR DR | 191 KEZAR DR | - | MARTIN LUTHER KING JR DR | MARTIN LUTHER KING JR DR |
| 67687 | N/A | Point | 1 | 1 | 200 - 299 | - | S244394 | 200-299 TURK ST | 200-299 TURK ST | F | F | - | F | 12718000 | 12718000 | - | - | SOUTH SIDE | - | - | - | - | JONES ST | JONES ST | 109324 | 109324 | 37.78289926 | -122.41323276 | - | - | 1738077572000 | middleware_editor | FG 300 UR DELINEATOR (W) | JONES ST to LEAVENWORTH ST (200 - 299) | - | 30' E OF LEAVENWORTH (4 @ LACATION) | - | - | - | - | - | 84803 | 1522930080000 | -122.41323276 | 37.78289926 | - | 1738048680000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1522836180000 | TURK ST | 200 - 299 TURK ST | 200 - 299 TURK ST | 200 TURK ST | - | LEAVENWORTH ST | LEAVENWORTH ST |
| 67688 | N/A | Point | 1 | 1 | 1 - 99 | - | S249911 | 1-99 DE WOLF ST | 1-99 DE WOLF ST | F | F | - | F | 4662000 | 4662000 | - | - | WEST SIDE | - | - | - | - | LAWRENCE AVE | LAWRENCE AVE | 109325 | 109325 | 37.71113101 | -122.45408182 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM THUR STCL | LAWRENCE AVE to ALEMANY BLVD (1 - 99) | - | 110 FEET SOUTH OF LAWRENCE @PM | - | - | - | - | - | 84804 | 991958400000 | -122.45408182 | 37.71113101 | - | 1543881600000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0241 | 18X18 | SUP2 | 2IN IRON POST | IS | 1543576680000 | DE WOLF ST | 1 - 99 DE WOLF ST | 1 - 99 DE WOLF ST | 1 DE WOLF ST | - | ALEMANY BLVD | ALEMANY BLVD |
| 67689 | N/A | Point | 1 | 1 | 900 - 999 | - | S233062 | 900-999 NEWHALL ST | 900-999 NEWHALL ST | F | F | - | F | 9569000 | 9569000 | - | - | WEST SIDE | - | - | - | - | 3RD ST \ JERROLD AVE | 03RD ST \ JERROLD AVE | 109326 | 109326 | 37.73848401 | -122.38966153 | - | - | 1710539427000 | MTA | BIKE RACK | 03RD ST \ JERROLD AVE to KIRKWOOD AVE (900 - 999) | 201600288 | 60'' (5.5') NORTH OF JERROLD AVE | - | - | - | - | - | 84805 | 1487944140000 | -122.38966153 | 37.73848401 | - | 1487894400000 | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1485526320000 | NEWHALL ST | 900 - 999 NEWHALL ST | 900 - 999 NEWHALL ST | 900 NEWHALL ST | - | KIRKWOOD AVE | KIRKWOOD AVE |
| 67690 | N/A | Point | - | - | - | - | S235486 | MISSION ST: ADMIRAL AVE | - | F | F | - | F | 21702000 | 21702000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MISSION ST | ADMIRAL AVE | 109327 | 109327 | 37.72985983 | -122.43018124 | ADMIRAL AVE \ MISSION ST | MISSION ST \ ADMIRAL AVE | 1752608090000 | middleware_editor | PEDESTRIAN (SYM) | ADMIRAL AVE intersection | - | - | - | - | - | - | - | 84806 | 1493149500000 | -122.43018124 | 37.72985983 | - | 1493103600000 | 1752596400000 | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | RETD | 1492781100000 | MISSION ST | - | - | - | - | - | - |
| 67691 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S278668 | 1400-1499 RIVERA ST | 1400-1499 RIVERA ST | F | F | - | F | 11057000 | 11057000 | - | - | SOUTH SIDE | - | - | - | - | 24TH AVE | 24TH AVE | 110096 | 110096 | 37.7464455354677 | -122.482105871783 | - | - | 1740091363000 | middleware_editor | BIKE RACK | 24TH AVE to 25TH AVE (1400 - 1499) | - | 47' E OF 25TH AVE/3' IN FROM CURB | - | - | - | - | - | 84807 | 1637107200000 | -122.48184742 | 37.74651964 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1636374360000 | RIVERA ST | 1400 - 1499 RIVERA ST | 1400 - 1499 RIVERA ST | 1400 RIVERA ST | - | 25TH AVE | 25TH AVE |
| 67692 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S278670 | 1700-1799 RIVERA ST | 1700-1799 RIVERA ST | F | F | - | F | 11060000 | 11060000 | - | - | NORTH SIDE | - | - | - | - | 27TH AVE | 27TH AVE | 110097 | 110097 | 37.74637779 | -122.48506054 | - | - | 1755110759000 | middleware_editor | BIKE RACK | 27TH AVE to 28TH AVE (1700 - 1799) | - | 69' W OF 27TH AVE/3' IN FROM CURB | - | - | - | - | - | 84808 | 1637136000000 | -122.48506054 | 37.74637779 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1636374900000 | RIVERA ST | 1700 - 1799 RIVERA ST | 1700 - 1799 RIVERA ST | 1700 RIVERA ST | - | 28TH AVE | 28TH AVE |
| 67693 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S278672 | 1800-1899 RIVERA ST | 1800-1899 RIVERA ST | F | F | - | F | 11061000 | 11061000 | - | - | SOUTH SIDE | - | - | - | - | 28TH AVE | 28TH AVE | 110098 | 110098 | 37.74633055 | -122.48613028 | - | - | 1741014587000 | middleware_editor | BIKE RACK | 28TH AVE to 29TH AVE (1800 - 1899) | - | 19' E OF 29TH AVE/3' IN FROM CURB | - | - | - | - | - | 84809 | 1637222400000 | -122.48613028 | 37.74633055 | - | 1740779100000 | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1636375200000 | RIVERA ST | 1800 - 1899 RIVERA ST | 1800 - 1899 RIVERA ST | 1800 RIVERA ST | - | 29TH AVE | 29TH AVE |
| 67694 | N/A | Point | - | - | - | - | S279324 | OCEAN AVE: FAXON AVE | - | T | T | - | F | 22654000 | 22654000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FAXON AVE | FAXON AVE | 110099 | 110099 | 37.72474885 | -122.46023446 | OCEAN AVE \ FAXON AVE | OCEAN AVE \ FAXON AVE | 1710539427000 | MTA | SPEED LIMIT 20 | FAXON AVE intersection | - | - | - | - | - | - | - | 84810 | 1054252800000 | -122.46023446 | 37.72474885 | - | 1568937600000 | - | D7 | - | SPEED LIMIT | REG | R2-1.0016 | 36X45 | SUP2 | OVERHEAD MAST ARM | IS | 1638868020000 | OCEAN AVE | - | - | - | - | - | - |
| 67695 | N/A | Point | - | - | - | - | S279326 | OCEAN AVE: DORADO TER \ JULES | - | T | T | - | F | 22662000 | 22662000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DORADO TER \ JULES AVE | DORADO TER \ JULES AVE | 110100 | 110100 | 37.7249497 | -122.46121055 | OCEAN AVE \ DORADO TER \ JULES AVE | OCEAN AVE \ DORADO TER \ JULES AVE | 1710539427000 | MTA | SPEED LIMIT 20 | DORADO TER \ JULES AVE intersection | - | - | - | - | - | - | - | 84811 | 1054252800000 | -122.46121055 | 37.7249497 | - | 1568937600000 | - | D7 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | OVERHEAD MAST ARM | IS | 1638868140000 | OCEAN AVE | - | - | - | - | - | - |
| 67696 | N/A | Point | - | - | - | - | S279329 | OCEAN AVE: VICTORIA ST | - | T | T | - | F | 22744000 | 22744000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VICTORIA ST | VICTORIA ST | 110101 | 110101 | 37.72600156 | -122.46422018 | OCEAN AVE \ VICTORIA ST | OCEAN AVE \ VICTORIA ST | 1727272940000 | middleware_editor | SPEED LIMIT 20 | VICTORIA ST intersection | - | - | - | - | - | - | - | 84812 | 1054252800000 | -122.46422018 | 37.72600156 | - | 1568937600000 | - | D7 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | OVERHEAD MAST ARM | IS | 1638868620000 | OCEAN AVE | - | - | - | - | - | - |
| 67697 | N/A | Point | - | - | - | - | S279330 | OCEAN AVE: VICTORIA ST | - | T | T | - | F | 22744000 | 22744000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VICTORIA ST | VICTORIA ST | 110102 | 110102 | 37.72600156 | -122.46422018 | OCEAN AVE \ VICTORIA ST | OCEAN AVE \ VICTORIA ST | 1749593795000 | middleware_editor | SPEED LIMIT 25 | VICTORIA ST intersection | - | - | - | - | - | - | - | 84813 | 1054278000000 | -122.46422018 | 37.72600156 | - | 1568962800000 | 1749587820000 | D7 | - | SPEED LIMIT | REG | R2-1.0006 | 36X45 | SUP2 | OVERHEAD MAST ARM | RETD | 1638869340000 | OCEAN AVE | - | - | - | - | - | - |
| 67698 | N/A | Point | - | - | - | - | S279331 | OCEAN AVE: JUNIPERO SERRA BLVD | - | T | T | - | F | 33538000 | 33538000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OCEAN AVE | OCEAN AVE | 110103 | 110103 | 37.7312055 | -122.47216033 | JUNIPERO SERRA BLVD \ OCEAN AVE | JUNIPERO SERRA BLVD \ OCEAN AVE | 1749504297000 | middleware_editor | SPEED LIMIT 25 | OCEAN AVE intersection | - | - | - | - | - | - | - | 84814 | 1054278000000 | -122.47216033 | 37.7312055 | - | 1568962800000 | 1749489720000 | D7 | - | SPEED LIMIT | REG | R2-1.0006 | 36X45 | SUP2 | OVERHEAD MAST ARM | RETD | 1638869520000 | JUNIPERO SERRA BLVD | - | - | - | - | - | - |
| 67699 | N/A | Point | 1 | 1 | 2700 - 2799 | - | S279332 | 2700-2799 OCEAN AVE | 2700-2799 OCEAN AVE | F | F | - | F | 9850000 | 9850000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 19TH AVE | 19TH AVE | 110104 | 110104 | 37.73262137 | -122.47548605 | - | - | 1728090610000 | middleware_editor | SPEED LIMIT 25 | 19TH AVE to 20TH AVE (2700 - 2799) | - | 20 FT WEST | - | - | - | - | - | 84815 | 949276800000 | -122.47548605 | 37.73262137 | - | 1547078400000 | - | D7 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP2 | LIGHT POLE | IS | 1638869760000 | OCEAN AVE | 2700 - 2799 OCEAN AVE | 2700 - 2799 OCEAN AVE | 2700 OCEAN AVE | - | 20TH AVE | 20TH AVE |
| 67700 | N/A | Point | 1 | 1 | 2600 - 2659 | - | S279336 | 2600-2659 OCEAN AVE | 2600-2659 OCEAN AVE | T | T | - | F | 9848000 | 9848000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | WOODACRE DR | WOODACRE DR | 110105 | 110105 | 37.73189464 | -122.47370469 | - | - | 1711588098000 | middleware_editor | SPEED LIMIT 20 | WOODACRE DR to LAGUNITAS DR (2600 - 2659) | - | EPL 2620 | - | - | - | - | - | 84816 | 1560988800000 | -122.47370469 | 37.73189464 | - | - | - | D7 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | LIGHT POLE | IS | 1638870480000 | OCEAN AVE | 2600 - 2659 OCEAN AVE | 2600 - 2659 OCEAN AVE | 2600 OCEAN AVE | - | LAGUNITAS DR | LAGUNITAS DR |
| 67701 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S211410 | 1200-1299 GILMAN AVE | 1200-1299 GILMAN AVE | F | F | - | F | 6190000 | 6190000 | - | - | NORTH SIDE | - | - | - | - | INGALLS ST | INGALLS ST | 110145 | 110145 | 37.72087878 | -122.39280364 | - | - | 1745609857000 | middleware_editor | NPRK 9AM-11AM MON STCL | INGALLS ST to JENNINGS ST (1200 - 1299) | - | 55' WEST OF INGALLS | - | - | - | - | - | 84817 | 1420567440000 | -122.39280364 | 37.72087878 | - | 1745606700000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0300 | 18X18 | SUP1 | 2IN IRON POST | IS | 1417702080000 | GILMAN AVE | 1200 - 1299 GILMAN AVE | 1200 - 1299 GILMAN AVE | 1200 GILMAN AVE | - | JENNINGS ST | JENNINGS ST |
| 67702 | N/A | Point | - | - | - | - | S212584 | 23RD ST: KANSAS ST | - | F | F | - | F | 23725000 | 23725000 | - | - | SOUTH WEST CORNER | - | - | - | - | KANSAS ST | 23RD ST | 110146 | 110146 | 37.75451212 | -122.40255751 | 23RD ST \ KANSAS ST | KANSAS ST \ 23RD ST | 1710539427000 | MTA | KANSAS ST | 23RD ST intersection | - | 1200 BLK | - | - | - | - | - | 84818 | 1421366400000 | -122.40255751 | 37.75451212 | - | 1421366400000 | - | D10 | - | STREET NAME | GUIDE | D3-1.0955 | 36X08 | SUP1 | 3IN IRON POST | IS | 1421231880000 | KANSAS ST | - | - | - | - | - | - |
| 67703 | N/A | Point | - | - | - | - | S212138 | FILBERT ST: GRANT AVE | - | F | F | - | F | 25349000 | 25349000 | - | - | NORTH EAST CORNER | - | - | - | - | GRANT AVE | GRANT AVE | 110148 | 110148 | 37.80157083 | -122.40776959 | FILBERT ST \ GRANT AVE | FILBERT ST \ GRANT AVE | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | GRANT AVE intersection | 132560 | OF FILBERT & MEDAU PL | - | - | - | - | - | 84819 | 1316995200000 | -122.40776959 | 37.80157083 | - | - | - | D3 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP1 | 2IN IRON POST | IS | 1419896040000 | FILBERT ST | - | - | - | - | - | - |
| 67704 | N/A | Point | - | - | - | - | S208388 | LILY ST: BUCHANAN ST | - | F | F | - | F | 25921000 | 25921000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LILY ST | BUCHANAN ST | 110149 | 110149 | 37.7739215 | -122.42745183 | BUCHANAN ST \ LILY ST | LILY ST \ BUCHANAN ST | 1710539427000 | MTA | DEAD END | BUCHANAN ST intersection | - | - | - | - | - | - | - | 84820 | 1409788800000 | -122.42745183 | 37.7739215 | - | 1409788800000 | - | D5 | - | OTHER WARNING | WARNING | W14-1.0001 | 24X24 | SUP1 | UTILITY POLE | IS | 1408618620000 | LILY ST | - | - | - | - | - | - |
| 67705 | N/A | Point | - | - | - | - | S217490 | GRANT AVE: MARKET ST \ OFARREL | - | T | T | - | F | 30768000 | 30768000 | - | - | NORTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MARKET ST \ OFARRELL ST | GRANT AVE \ MARKET ST | 110151 | 110151 | 37.78673057 | -122.40458332 | GRANT AVE \ MARKET ST \ OFARRELL ST | OFARRELL ST \ GRANT AVE \ MARKET ST | 1733182813000 | middleware_editor | (LA) ONLY | GRANT AVE \ MARKET ST intersection | - | - | - | - | - | - | - | 84821 | 1438873920000 | -122.40458332 | 37.78673057 | - | 1438819200000 | - | D3 | - | OTHER REGULATORY | REG | R59(CA).0001 | 30X36 | SUP1 | LIGHT POLE | IS | 1435325700000 | OFARRELL ST | - | - | - | - | - | - |
| 67706 | N/A | Point | 1 | 1 | 40 - 99 | RIGHT ARROW | S267501 | 40-99 FOLSOM ST | 40-99 FOLSOM ST | F | F | - | F | 5650000 | 5650000 | - | - | SOUTH SIDE | - | - | - | - | THE EMBARCADERO | THE EMBARCADERO | 110978 | 110978 | 37.79044838 | -122.39049168 | - | - | 1710539427000 | MTA | TA (SYM) PLO AT ALL TIMES (5 MIN) | THE EMBARCADERO to SPEAR ST (40 - 99) | - | 66' EAST OF SPEAR ST. | - | - | - | - | - | 84822 | 1597017600000 | -122.39049168 | 37.79044838 | - | 1606694400000 | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0001 | 14X21 | SUP1 | 2IN IRON POST | IS | 1598398080000 | FOLSOM ST | 40 - 99 FOLSOM ST | 40 - 99 FOLSOM ST | 40 FOLSOM ST | - | SPEAR ST | SPEAR ST |
| 67707 | N/A | Point | 1 | 1 | 40 - 99 | - | S267502 | 40-99 FOLSOM ST | 40-99 FOLSOM ST | F | F | - | F | 5650000 | 5650000 | - | - | NORTH SIDE | - | - | - | - | THE EMBARCADERO | THE EMBARCADERO | 110979 | 110979 | 37.79044838 | -122.39049168 | - | - | 1710539427000 | MTA | NPRK 12MN-2AM MON WED FRI STCL | THE EMBARCADERO to SPEAR ST (40 - 99) | - | 157' WEST OF THE EMBARCADERO | - | - | - | - | - | 84823 | 1606905060000 | -122.39049168 | 37.79044838 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0034 | 18X18 | SUP1 | LIGHT POLE | IS | 1598398320000 | FOLSOM ST | 40 - 99 FOLSOM ST | 40 - 99 FOLSOM ST | 40 FOLSOM ST | - | SPEAR ST | SPEAR ST |
| 67708 | N/A | Point | - | - | - | - | S288858 | PERU AVE: ATHENS ST | - | F | F | - | F | 21652000 | 21652000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ATHENS ST | ATHENS ST | 110984 | 110984 | 37.72632292 | -122.42492553 | PERU AVE \ ATHENS ST | PERU AVE \ ATHENS ST | 1730311781000 | middleware_editor | PERU (INDIA) | ATHENS ST intersection | - | <---600 (INDIA) | - | - | - | - | - | 84824 | 1389052800000 | -122.42492553 | 37.72632292 | - | - | - | D11 | - | STREET NAME | GUIDE | D3-1.2062 | 36X08 | SUP2 | 3IN IRON POST | IS | 1682431200000 | PERU AVE | - | - | - | - | - | - |
| 67709 | N/A | Point | - | - | - | - | S124091 | CABRILLO ST: 43RD AVE | - | F | F | - | F | 27882000 | 27882000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CABRILLO ST | CABRILLO ST | 111045 | 111045 | 37.77355433 | -122.50360859 | 43RD AVE \ CABRILLO ST | 43RD AVE \ CABRILLO ST | 1710539427000 | MTA | ALL WAY | CABRILLO ST intersection | - | - | - | - | - | - | - | 84825 | 1150243200000 | -122.50360859 | 37.77355433 | - | - | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | UTILITY POLE | IS | 1373575080000 | 43RD AVE | - | - | - | - | - | - |
| 67710 | N/A | Point | - | - | - | - | S124768 | JERSEY ST: CASTRO ST | - | F | F | - | F | 25739000 | 25739000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CASTRO ST | CASTRO ST | 111046 | 111046 | 37.75049493 | -122.43400652 | JERSEY ST \ CASTRO ST | JERSEY ST \ CASTRO ST | 1736796836000 | middleware_editor | ALL WAY | CASTRO ST intersection | - | - | - | - | - | - | - | 84826 | 1154908800000 | -122.43400652 | 37.75049493 | - | - | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575320000 | JERSEY ST | - | - | - | - | - | - |
| 67711 | N/A | Point | - | - | - | - | S124801 | LARKIN ST: FILBERT ST | - | F | F | - | F | 25561000 | 25561000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FILBERT ST | FILBERT ST | 111047 | 111047 | 37.79990244 | -122.42088264 | LARKIN ST \ FILBERT ST | LARKIN ST \ FILBERT ST | 1710539427000 | MTA | ALL WAY | FILBERT ST intersection | - | - | - | - | - | - | - | 84827 | 1154995200000 | -122.42088264 | 37.79990244 | - | 1557705600000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575320000 | LARKIN ST | - | - | - | - | - | - |
| 67712 | N/A | Point | - | - | - | - | S123205 | LAKE ST: 28TH AVE | - | F | F | - | F | 28020000 | 28020000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 28TH AVE | 28TH AVE | 111049 | 111049 | 37.78561178 | -122.48814038 | LAKE ST \ 28TH AVE | LAKE ST \ 28TH AVE | 1720057019000 | middleware_editor | ALL WAY | 28TH AVE intersection | - | WPL #2645 | - | - | - | - | - | 84828 | 1143676800000 | -122.48814038 | 37.78561178 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574840000 | LAKE ST | - | - | - | - | - | - |
| 67713 | N/A | Point | - | 1 | 1 - 99 | - | S123507 | 1-99 ELGIN PARK | 1-99 ELGIN PARK | F | F | - | F | 5139000 | 5139000 | - | - | EAST SIDE | - | - | - | - | MCCOPPIN ST | MCCOPPIN ST | 111050 | 111050 | 37.77065356 | -122.42322615 | - | - | 1710539427000 | MTA | TANSAT | MCCOPPIN ST to DUBOCE AVE (1 - 99) | - | 75 FT. NORTH OF DRIVEWAY TO# 25 | - | - | - | - | - | 84829 | 1146182400000 | -122.42322615 | 37.77065356 | - | - | - | D8 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373574900000 | ELGIN PARK | 1 - 99 ELGIN PARK | 1 - 99 ELGIN PARK | 1 ELGIN PARK | - | DUBOCE AVE | DUBOCE AVE |
| 67714 | N/A | Point | - | - | - | - | S124852 | CLIPPER ST: CASTRO ST | - | F | F | - | F | 25736000 | 25736000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CLIPPER ST | CASTRO ST | 111051 | 111051 | 37.74889597 | -122.4338511 | CASTRO ST \ CLIPPER ST | CLIPPER ST \ CASTRO ST | 1711152821000 | middleware_editor | ALL WAY | CASTRO ST intersection | - | - | - | - | - | - | - | 84830 | 1155081600000 | -122.4338511 | 37.74889597 | - | - | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575320000 | CLIPPER ST | - | - | - | - | - | - |
| 67715 | N/A | Point | - | - | - | - | S123811 | FULTON ST: PIERCE ST | - | F | F | - | F | 26054000 | 26054000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PIERCE ST | FULTON ST | 111053 | 111053 | 37.77728067 | -122.43486377 | FULTON ST \ PIERCE ST | PIERCE ST \ FULTON ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | FULTON ST intersection | - | SWCORNER | - | - | - | - | - | 84831 | 1147996800000 | -122.43486377 | 37.77728067 | - | - | - | D5 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373575020000 | PIERCE ST | - | - | - | - | - | - |
| 67716 | N/A | Point | 1 | 1 | 200 - 299 | - | S280803 | 200-299 23RD AVE | 200-299 23RD AVE | F | F | - | F | 1212000 | 1212000 | - | - | EAST SIDE | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 111054 | 111054 | 37.78305052 | -122.48280262 | - | - | 1738882828000 | middleware_editor | NPRK 7AM-8AM TUE STCL | CALIFORNIA ST to CLEMENT ST (200 - 299) | 122013237 | 250 NPL ALMO SCHOOL. | - | - | - | - | - | 84832 | - | -122.48280262 | 37.78305052 | - | 1738852800000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0220 | 18X18 | SUP2 | 2IN IRON POST | IS | 1644329220000 | 23RD AVE | 200 - 299 23RD AVE | 200 - 299 23RD AVE | 200 23RD AVE | - | CLEMENT ST | CLEMENT ST |
| 67717 | N/A | Point | - | - | - | - | S276974 | DOLORES ST: CLIPPER ST | - | F | F | - | F | 25609000 | 25609000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLIPPER ST | DOLORES ST | 111058 | 111058 | 37.7494349 | -122.424923 | DOLORES ST \ CLIPPER ST | CLIPPER ST \ DOLORES ST | 1710539427000 | MTA | (45 LA-DN) | DOLORES ST intersection | - | - | - | - | - | - | - | 84833 | 1285113600000 | -122.424923 | 37.7494349 | - | 1632355200000 | - | D8 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | 3IN IRON POST | IS | 1628163120000 | CLIPPER ST | - | - | - | - | - | - |
| 67718 | N/A | Point | - | - | - | - | S276979 | 26TH ST: SAN JOSE AVE | - | F | F | - | F | 33363000 | 33363000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 26TH ST | 26TH ST | 111059 | 111059 | 37.74885044 | -122.42128446 | SAN JOSE AVE \ 26TH ST | SAN JOSE AVE \ 26TH ST | 1751994848000 | middleware_editor | (45 LA-DN) | 26TH ST intersection | - | - | - | - | - | - | - | 84834 | 1196323200000 | -122.42128446 | 37.74885044 | - | 1632726000000 | - | D8 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | 2IN IRON POST | IS | 1628168640000 | SAN JOSE AVE | - | - | - | - | - | - |
| 67719 | N/A | Point | - | - | - | - | S276980 | 26TH ST: SAN JOSE AVE | - | F | F | - | F | 33363000 | 33363000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 26TH ST | 26TH ST | 111060 | 111060 | 37.74885044 | -122.42128446 | SAN JOSE AVE \ 26TH ST | SAN JOSE AVE \ 26TH ST | 1751994851000 | middleware_editor | (45 LA-DN) | 26TH ST intersection | - | IFO 3601 | - | - | - | - | - | 84835 | 1196323200000 | -122.42128446 | 37.74885044 | - | 1632985200000 | - | D8 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | 2IN IRON POST | IS | 1628168940000 | SAN JOSE AVE | - | - | - | - | - | - |
| 67720 | N/A | Point | - | - | - | - | S276981 | CHENERY ST: CASTRO ST | - | F | F | - | F | 21934000 | 21934000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | CHENERY ST | CASTRO ST | 111061 | 111061 | 37.73455137 | -122.43241657 | CASTRO ST \ CHENERY ST | CHENERY ST \ CASTRO ST | 1710539427000 | MTA | (45 LA-DN) | CASTRO ST intersection | - | IFO 641 | - | - | - | - | - | 84836 | 1139184000000 | -122.43241657 | 37.73455137 | - | 1632873600000 | - | D8 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | 2IN IRON POST | IS | 1628170140000 | CHENERY ST | - | - | - | - | - | - |
| 67721 | N/A | Point | - | - | - | - | S268042 | EXECUTIVE PARK BLVD: ALANA WAY | - | F | F | - | F | 20258000 | 20258000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ALANA WAY | EXECUTIVE PARK BLVD | 111794 | 111794 | 37.70890383 | -122.39440307 | EXECUTIVE PARK BLVD \ ALANA WAY | ALANA WAY \ EXECUTIVE PARK BLVD | 1710539427000 | MTA | STOP | EXECUTIVE PARK BLVD intersection | - | 15' NORTH OF ALANA WAY | - | - | - | - | - | 84837 | 1600164000000 | -122.39440307 | 37.70890383 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1600159800000 | ALANA WAY | - | - | - | - | - | - |
| 67722 | N/A | Point | 1 | 1 | 300 - 399 | - | S267740 | 300-399 MISSION ST | 300-399 MISSION ST | F | F | - | F | 9086000 | 9086000 | - | - | NORTH SIDE | - | - | - | - | BEALE ST | BEALE ST | 111795 | 111795 | 37.79080694 | -122.39625156 | - | - | 1710539427000 | MTA | BIKE RACK | BEALE ST to FREMONT ST (300 - 399) | 143553 | 30' W OF EPL 350/3.5' IN FROM CURB | - | - | - | - | - | 84838 | 1599126360000 | -122.39625156 | 37.79080694 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1598884920000 | MISSION ST | 300 - 399 MISSION ST | 300 - 399 MISSION ST | 300 MISSION ST | - | FREMONT ST | FREMONT ST |
| 67723 | N/A | Point | 1 | 1 | 300 - 399 | - | S267741 | 300-399 MISSION ST | 300-399 MISSION ST | F | F | - | F | 9086000 | 9086000 | - | - | NORTH SIDE | - | - | - | - | BEALE ST | BEALE ST | 111796 | 111796 | 37.79080694 | -122.39625156 | - | - | 1710539427000 | MTA | BIKE RACK | BEALE ST to FREMONT ST (300 - 399) | 143553 | 37' W OF EPL 350/3.5' IN FROM CURB | - | - | - | - | - | 84839 | 1599128160000 | -122.39625156 | 37.79080694 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1598884920000 | MISSION ST | 300 - 399 MISSION ST | 300 - 399 MISSION ST | 300 MISSION ST | - | FREMONT ST | FREMONT ST |
| 67724 | N/A | Point | - | - | - | - | S261395 | MARKET ST: 2ND ST | - | T | T | - | F | 30734000 | 30734000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MARKET ST | 02ND ST | 111797 | 111797 | 37.78926432 | -122.40137549 | 2ND ST \ MARKET ST | MARKET ST \ 02ND ST | 1710539427000 | MTA | DO NOT BLOCK INTERSECTION | 02ND ST intersection | - | - | - | - | - | - | - | 84840 | - | -122.40137549 | 37.78926432 | - | - | - | D6 | - | OTHER REGULATORY | REG | R10-7.0001 | 24X30 | SUP1 | SIGNAL POLE | IS | 1581509940000 | MARKET ST | - | - | - | - | - | - |
| 67725 | N/A | Point | - | - | - | - | S261615 | PNDG PRECITA AVE | - | F | F | - | F | 10741000 | 10741000 | - | - | EAST SIDE | - | - | - | - | - | - | 111827 | 111827 | 37.7472204 | -122.41659655 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | - | 132575 | IFO 299 PRECITA | - | - | - | - | - | 84841 | 1317254400000 | -122.41659655 | 37.7472204 | - | - | - | D9 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1582186680000 | PRECITA AVE | PNDG PRECITA AVE | PRECITA AVE | - | - | - | - |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in meters