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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 132676 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S113807 | 2300-2399 IRVING ST | 2300-2399 IRVING ST | F | F | - | F | 7301000 | 7301000 | - | - | NORTH SIDE | - | - | - | - | 24TH AVE | 24TH AVE | 11268 | 11268 | 37.76330222 | -122.48301804 | - | - | 1747253288000 | middleware_editor | NPRK 2AM-6AM TUE THUR SUN STCL | 24TH AVE to 25TH AVE (2300 - 2399) | - | WPL#2360 | - | - | - | - | - | 174344 | 996649200000 | -122.48301804 | 37.76330222 | - | 1487923200000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0134 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373571840000 | IRVING ST | 2300 - 2399 IRVING ST | 2300 - 2399 IRVING ST | 2300 IRVING ST | - | 25TH AVE | 25TH AVE |
| 132677 | N/A | Point | 1 | 1 | 2400 - 2499 | - | S113809 | 2400-2499 IRVING ST | 2400-2499 IRVING ST | F | F | - | F | 7302000 | 7302000 | - | - | NORTH SIDE | - | - | - | - | 25TH AVE | 25TH AVE | 11270 | 11270 | 37.76325499 | -122.48409011 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM TUE THUR SUN STCL | 25TH AVE to 26TH AVE (2400 - 2499) | - | IFO#2400 | - | - | - | - | - | 174345 | 996624000000 | -122.48409011 | 37.76325499 | - | 1487203200000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0134 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373571840000 | IRVING ST | 2400 - 2499 IRVING ST | 2400 - 2499 IRVING ST | 2400 IRVING ST | - | 26TH AVE | 26TH AVE |
| 132678 | N/A | Point | - | - | - | - | S117614 | GREAT HWY: POINT LOBOS AVE | - | F | F | - | F | - | 33559000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | - | POINT LOBOS AVE | 11272 | 11272 | 37.7766375570224 | -122.511876862746 | - | GREAT HWY \ POINT LOBOS AVE | 1731530364000 | middleware_editor | BICYCLE (SYM) ALLOWED USE OF FULL LANE CVC 21202 | POINT LOBOS AVE intersection | - | 0 / ABOVE SPEED LIMIT 30 SIGN-SEE P..... | - | - | - | - | - | 174346 | 1063756800000 | -122.51193833 | 37.77675619 | - | - | - | D1 | - | OTHER WARNING | WARNING | W11-1(SF).0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373573040000 | GREAT HWY | - | - | - | - | - | - |
| 132679 | N/A | Point | 1 | 1 | 700 - 1299 | - | S117615 | 700-1299 POINT LOBOS AVE | 700-1299 POINT LOBOS AVE | F | F | - | F | 10543000 | 10544000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 48TH AVE \ EL CAMINO DEL MAR | MERRIE WAY | 11273 | 11273 | 37.7799128293782 | -122.509985642763 | - | - | 1731693908000 | middleware_editor | BICYCLE (SYM) ALLOWED USE OF FULL LANE CVC 21202 | MERRIE WAY to GREAT HWY (700 - 1299) | - | 150W / ABOVE "PARK PARALLEL" SIGN- ..... | - | - | - | - | - | 174347 | 1063756800000 | -122.51275009 | 37.7783052 | - | - | - | D1 | - | OTHER WARNING | WARNING | W11-1(SF).0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1373573040000 | POINT LOBOS AVE | 600 - 699 POINT LOBOS AVE | 700 - 1299 POINT LOBOS AVE | 700 POINT LOBOS AVE | - | MERRIE WAY | GREAT HWY |
| 132680 | N/A | Point | - | - | - | - | S117616 | YALE ST: SILLIMAN ST | - | F | F | - | F | 20963000 | 20963000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | YALE ST | YALE ST | 11274 | 11274 | 37.72788659 | -122.41790557 | SILLIMAN ST \ YALE ST | SILLIMAN ST \ YALE ST | 1718069612000 | middleware_editor | ALL WAY | YALE ST intersection | - | - | - | - | - | - | - | 174348 | 1063843200000 | -122.41790557 | 37.72788659 | - | 1531699200000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573040000 | SILLIMAN ST | - | - | - | - | - | - |
| 132681 | N/A | Point | - | - | - | - | S114665 | 174-199 VASQUEZ AVE | - | F | F | - | F | - | - | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | - | - | 11275 | 11275 | 37.74346729 | -122.461031 | - | - | 1710539427000 | MTA | TWO WAY TRAFFIC (SYM) | - | - | OPP#260 | - | - | - | - | - | 174349 | 1012867200000 | -122.461031 | 37.74346729 | - | - | - | D7 | - | OTHER WARNING | WARNING | W6-3.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373572140000 | - | 174-199 VASQUEZ AVE | - | - | - | - | - |
| 132682 | N/A | Point | - | - | - | - | S115705 | RANKIN ST: CUSTER AVE | - | F | F | - | F | 20703000 | 20703000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | RANKIN ST | CUSTER AVE | 11300 | 11300 | 37.7463899147965 | -122.390951514239 | CUSTER AVE \ RANKIN ST | RANKIN ST \ CUSTER AVE | 1736276924000 | middleware_editor | NOT A THROUGH STREET | CUSTER AVE intersection | - | BELOW ST NAMES | - | - | - | - | - | 174350 | 1037664000000 | -122.3910568 | 37.74636178 | - | - | - | D10 | - | OTHER WARNING | WARNING | W(SF).0033 | 24X24 | SUP1 | 3IN IRON POST | IS | 1373572440000 | RANKIN ST | - | - | - | - | - | - |
| 132683 | N/A | Point | - | - | - | - | S112109 | SACRAMENTO ST: MAPLE ST | - | F | F | - | F | 26947000 | 26947000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | SACRAMENTO ST | 11303 | 11303 | 37.78713699 | -122.45523635 | MAPLE ST \ SACRAMENTO ST | MAPLE ST \ SACRAMENTO ST | 1710539427000 | MTA | STOP | SACRAMENTO ST intersection | - | - | - | - | - | - | - | 174351 | 912816000000 | -122.45523635 | 37.78713699 | - | 1556668800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | MUNI POLE | IS | 1373571300000 | MAPLE ST | - | - | - | - | - | - |
| 132684 | N/A | Point | - | - | - | - | S112110 | 27TH AVE: ANZA ST | - | F | F | - | F | 27551000 | 27551000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 27TH AVE | ANZA ST | 11304 | 11304 | 37.7781620990671 | -122.486824393267 | ANZA ST \ 27TH AVE | 27TH AVE \ ANZA ST | 1752780494000 | middleware_editor | STOP | ANZA ST intersection | - | - | - | - | - | - | - | 174352 | 912844800000 | -122.48673752 | 37.77806875 | - | 1739569800000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571300000 | 27TH AVE | - | - | - | - | - | - |
| 132685 | N/A | Point | - | - | - | - | S112111 | 27TH AVE: ANZA ST | - | F | F | - | F | 27551000 | 27551000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 27TH AVE | ANZA ST | 11305 | 11305 | 37.77797554 | -122.486666813 | ANZA ST \ 27TH AVE | 27TH AVE \ ANZA ST | 1752855573000 | middleware_editor | STOP | ANZA ST intersection | - | - | - | - | - | - | - | 174353 | 912844800000 | -122.48673752 | 37.77806875 | - | 1739569680000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373571360000 | 27TH AVE | - | - | - | - | - | - |
| 132686 | N/A | Point | 1 | 1 | 800 - 899 | - | S112381 | 800-899 VICENTE ST | 800-899 VICENTE ST | F | F | - | F | 13245000 | 13245000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 19TH AVE | 19TH AVE | 11306 | 11306 | 37.73930139 | -122.47594752 | - | - | 1710539427000 | MTA | S F BIKE ROUTE (RED SYM) 75 | 19TH AVE to 20TH AVE (800 - 899) | - | 125W / PLUS "(GOLDEN GATE PARK-RA N..... | - | - | - | - | - | 174354 | 949363200000 | -122.47594752 | 37.73930139 | - | - | - | D4 | - | BIKE GUIDE | GUIDE | SG45R(75).0001 | 12X22 | SUP2 | 2IN IRON POST | IS | 1373571420000 | VICENTE ST | 800 - 899 VICENTE ST | 800 - 899 VICENTE ST | 800 VICENTE ST | - | 20TH AVE | 20TH AVE |
| 132687 | N/A | Point | 1 | 1 | 2700 - 2783 | RIGHT ARROW | S112384 | 2700-2783 DIAMOND ST | 2700-2783 DIAMOND ST | F | F | - | F | 4768000 | 4768000 | - | - | EAST SIDE | - | - | - | - | SURREY ST | SURREY ST | 11309 | 11309 | 37.73560836 | -122.43408451 | - | - | 1710539427000 | MTA | TANSAT | SURREY ST to UNNAMED 026 (2700 - 2783) | - | IFO# 2789/2791 // PLUS "(RA)" | - | - | - | - | - | 174355 | 949968000000 | -122.43408451 | 37.73560836 | - | 1637193600000 | - | D8 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | 2IN IRON POST | IS | 1373571420000 | DIAMOND ST | 2700 - 2783 DIAMOND ST | 2700 - 2783 DIAMOND ST | 2700 DIAMOND ST | - | UNNAMED 026 | UNNAMED 026 |
| 132688 | N/A | Point | 1 | 1 | 2201 - 2299 | - | S117244 | 2201-2299 FULTON ST | 2201-2299 FULTON ST | F | F | - | F | 5903000 | 5903000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SHRADER ST | SHRADER ST | 11973 | 11973 | 37.77486312 | -122.45384299 | - | - | 1721092921000 | middleware_editor | ST. MARY'S MEDICAL CENTER (RA) | SHRADER ST to STANYAN ST (2201 - 2299) | - | APPROX 110' W OF PARKER | - | - | - | - | - | 174356 | 1058400000000 | -122.45384299 | 37.77486312 | - | - | - | D1 | - | OTHER GUIDE | GUIDE | G-S(SF).0034 | 42X30 | SUP2 | MUNI POLE | IS | 1373572920000 | FULTON ST | 2201 - 2299 FULTON ST | 2201 - 2299 FULTON ST | 2201 FULTON ST | - | STANYAN ST | STANYAN ST |
| 132689 | N/A | Point | - | - | - | - | S110944 | BROADMOOR DR: WINSTON DR | - | F | F | - | F | 23063000 | 23063000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BROADMOOR DR | BROADMOOR DR | 86583 | 86583 | 37.72685485 | -122.47334716 | WINSTON DR \ BROADMOOR DR | WINSTON DR \ BROADMOOR DR | 1734026991000 | middleware_editor | STOP | BROADMOOR DR intersection | - | - | - | - | - | - | - | 174357 | 722131200000 | -122.47334716 | 37.72685485 | - | 1225152000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570940000 | WINSTON DR | - | - | - | - | - | - |
| 132690 | N/A | Point | - | - | - | - | S110976 | IRVING ST: 34TH AVE | - | F | F | - | F | 27727000 | 27727000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 34TH AVE | IRVING ST | 86584 | 86584 | 37.76285332 | -122.4931988 | IRVING ST \ 34TH AVE | 34TH AVE \ IRVING ST | 1710539427000 | MTA | STOP | IRVING ST intersection | - | - | - | - | - | - | - | 174358 | 724896000000 | -122.4931988 | 37.76285332 | - | 1510704000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571000000 | 34TH AVE | - | - | - | - | - | - |
| 132691 | N/A | Point | - | - | - | - | S110984 | OLMSTEAD ST: BOWDOIN ST | - | F | F | - | F | 20852000 | 20852000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BOWDOIN ST | BOWDOIN ST | 86585 | 86585 | 37.72102675 | -122.40852407 | OLMSTEAD ST \ BOWDOIN ST | OLMSTEAD ST \ BOWDOIN ST | 1740006577000 | middleware_editor | STOP | BOWDOIN ST intersection | - | - | - | - | - | - | - | 174359 | 724896000000 | -122.40852407 | 37.72102675 | - | 1236297600000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373571000000 | OLMSTEAD ST | - | - | - | - | - | - |
| 132692 | N/A | Point | 1 | 1 | 800 - 899 | - | S250823 | 800-899 STOCKTON ST | 800-899 STOCKTON ST | F | F | - | F | 12204000 | 12204000 | - | - | EAST SIDE | - | - | - | - | SACRAMENTO ST \ STOCKTON TUNL | SACRAMENTO ST \ STOCKTON TUNL | 80626 | 80626 | 37.7936193 | -122.40781524 | - | - | 1710539427000 | MTA | NO LITTERING (SYM)-IT SHALL BE UNLAWFUL¿ | SACRAMENTO ST \ STOCKTON TUNL to CLAY ST (800 - 899) | - | 820 | - | - | - | - | - | 174360 | - | -122.40781524 | 37.7936193 | - | - | - | D3 | - | OTHER REGULATORY | REG | SR(SF).0035 | 18X24 | SUP1 | LIGHT POLE | IS | 1547547540000 | STOCKTON ST | 800 - 899 STOCKTON ST | 800 - 899 STOCKTON ST | 800 STOCKTON ST | - | CLAY ST | CLAY ST |
| 132693 | N/A | Point | 1 | 1 | 700 - 799 | - | S247206 | 700-799 30TH AVE | 700-799 30TH AVE | F | F | - | F | 1644000 | 1644000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | BALBOA ST | 80627 | 80627 | 37.77512479 | -122.48974764 | - | - | 1710539427000 | MTA | SCHOOL (SYM) | BALBOA ST to CABRILLO ST (700 - 799) | - | NPL 726 30TH AVE | - | - | - | - | - | 174361 | 1100217600000 | -122.48974764 | 37.77512479 | - | 1532563200000 | - | D1 | - | SCHOOL | WARNING | S1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1532352780000 | 30TH AVE | 700 - 799 30TH AVE | 700 - 799 30TH AVE | 700 30TH AVE | - | CABRILLO ST | CABRILLO ST |
| 132694 | N/A | Point | 1 | 1 | 700 - 799 | - | S247207 | 700-799 30TH AVE | 700-799 30TH AVE | F | F | - | F | 1644000 | 1644000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | BALBOA ST | 80628 | 80628 | 37.77512479 | -122.48974764 | - | - | 1710539427000 | MTA | AHEAD | BALBOA ST to CABRILLO ST (700 - 799) | - | NPL 726 30TH AVE | - | - | - | - | - | 174362 | 1100217600000 | -122.48974764 | 37.77512479 | - | 1532563200000 | - | D1 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP2 | 2IN IRON POST | IS | 1532353020000 | 30TH AVE | 700 - 799 30TH AVE | 700 - 799 30TH AVE | 700 30TH AVE | - | CABRILLO ST | CABRILLO ST |
| 132695 | N/A | Point | - | - | - | LEFT ARROW | S248344 | KIRKHAM ST: 19TH AVE | - | F | F | - | F | 27364000 | 27364000 | - | - | SOUTH SIDE | - | - | - | - | 19TH AVE | 19TH AVE | 80629 | 80629 | 37.75983394 | -122.47681389 | KIRKHAM ST \ 19TH AVE | KIRKHAM ST \ 19TH AVE | 1710539427000 | MTA | TA (SYM) SCHOOL BUS ONLY 7:30AM-8:30AM SCHOOL DAYS | 19TH AVE intersection | - | 112' FT WEST | - | - | - | - | - | 174363 | 1468195200000 | -122.47681389 | 37.75983394 | - | 1537401600000 | - | D4 | - | OTHER REGULATORY | REG | R38(SF)4.0026 | 14X21 | SUP2 | 2IN IRON POST | IS | 1537180440000 | KIRKHAM ST | - | - | - | - | - | - |
| 132696 | N/A | Point | 1 | 1 | 2400 - 2499 | - | S248347 | 2400-2499 31ST AVE | 2400-2499 31ST AVE | F | F | - | F | 1695000 | 1695000 | - | - | WEST SIDE | - | - | - | - | TARAVAL ST | TARAVAL ST | 80630 | 80630 | 37.74155057 | -122.48848197 | - | - | 1715219888000 | middleware_editor | (H/C SYM) PARK ONLY/MIN FINE $250 | TARAVAL ST to ULLOA ST (2400 - 2499) | - | 24' FT SOUTH OF TARAVAL | - | - | - | - | - | 174364 | 1228953600000 | -122.48848197 | 37.74155057 | - | 1537401600000 | - | D4 | - | OTHER REGULATORY | REG | R99C(CA).0001 | 12X24 | SUP2 | 2IN IRON POST | IS | 1537181640000 | 31ST AVE | 2400 - 2499 31ST AVE | 2400 - 2499 31ST AVE | 2400 31ST AVE | - | ULLOA ST | ULLOA ST |
| 132697 | N/A | Point | - | - | - | - | S248350 | SILVER AVE: SAN BRUNO AVE | - | T | T | - | F | 20770000 | 20770000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SILVER AVE | SILVER AVE | 80631 | 80631 | 37.73243866 | -122.40560755 | SAN BRUNO AVE \ SILVER AVE | SAN BRUNO AVE \ SILVER AVE | 1754681971000 | middleware_editor | (LA) ONLY (VA-RA) | SILVER AVE intersection | - | - | - | - | - | - | - | 174365 | 1539276660000 | -122.40560755 | 37.73243866 | - | - | - | D10 | - | OTHER REGULATORY | REG | R61-5(CA).0001 | 36X30 | SUP1 | OVERHEAD MAST ARM | IS | 1537187220000 | SAN BRUNO AVE | - | - | - | - | - | - |
| 132698 | N/A | Point | - | - | - | - | S248356 | WESTGATE DR: DARIEN WAY | - | F | F | - | F | 22758000 | 22758000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DARIEN WAY | DARIEN WAY | 80632 | 80632 | 37.73092581 | -122.46441157 | WESTGATE DR \ DARIEN WAY | WESTGATE DR \ DARIEN WAY | 1717524537000 | middleware_editor | RIGHT TURN ONLY(SYM) | DARIEN WAY intersection | - | INTER OF MONTEREY WEST GATE | - | - | - | - | - | 174366 | 1138147200000 | -122.46441157 | 37.73092581 | - | - | - | D7 | - | OTHER REGULATORY | REG | R3-5.0002 | 30X36 | SUP2 | 2IN IRON POST | IS | 1537194180000 | WESTGATE DR | - | - | - | - | - | - |
| 132699 | N/A | Point | 1 | 1 | 3401 - 3499 | - | S248450 | 0-3499 ALEMANY BLVD | 3401-3499 ALEMANY BLVD | F | F | - | F | 2181101 | 2181101 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | ORIZABA AVE \ SAGAMORE ST | ORIZABA AVE \ SAGAMORE ST | 80635 | 80635 | 37.71123887 | -122.46301317 | - | - | 1710539427000 | MTA | PEDESTRIAN (SYM) | ORIZABA AVE \ SAGAMORE ST to BRIGHT ST (3401 - 3499) -- SOUTH -- | - | AT CROSSWALK | - | - | - | - | - | 174367 | 1336953600000 | -122.46301317 | 37.71123887 | - | 1537747200000 | - | D7 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1537443540000 | ALEMANY BLVD | 3401 - 3499 ALEMANY BLVD | 3401 - 3499 ALEMANY BLVD | 3401 ALEMANY BLVD | - | BRIGHT ST | BRIGHT ST |
| 132700 | N/A | Point | 1 | 1 | 3401 - 3499 | - | S248451 | 0-3499 ALEMANY BLVD | 3401-3499 ALEMANY BLVD | F | F | - | F | 2181101 | 2181101 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | ORIZABA AVE \ SAGAMORE ST | ORIZABA AVE \ SAGAMORE ST | 80636 | 80636 | 37.71123887 | -122.46301317 | - | - | 1710539427000 | MTA | (45 LA-DN) | ORIZABA AVE \ SAGAMORE ST to BRIGHT ST (3401 - 3499) -- SOUTH -- | - | AT CROSSWALK | - | - | - | - | - | 174368 | 1336953600000 | -122.46301317 | 37.71123887 | - | 1537747200000 | - | D7 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | 2IN IRON POST | IS | 1537443600000 | ALEMANY BLVD | 3401 - 3499 ALEMANY BLVD | 3401 - 3499 ALEMANY BLVD | 3401 ALEMANY BLVD | - | BRIGHT ST | BRIGHT ST |
| 132701 | N/A | Point | 1 | 1 | 3401 - 3499 | - | S248452 | 0-3499 ALEMANY BLVD | 3401-3499 ALEMANY BLVD | F | F | - | F | 2181101 | 2181101 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | ORIZABA AVE \ SAGAMORE ST | ORIZABA AVE \ SAGAMORE ST | 80637 | 80637 | 37.71123887 | -122.46301317 | - | - | 1710539427000 | MTA | PEDESTRIAN (SYM) | ORIZABA AVE \ SAGAMORE ST to BRIGHT ST (3401 - 3499) -- SOUTH -- | - | AT CROSSWALK | - | - | - | - | - | 174369 | 1336953600000 | -122.46301317 | 37.71123887 | - | 1537747200000 | - | D7 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1537443840000 | ALEMANY BLVD | 3401 - 3499 ALEMANY BLVD | 3401 - 3499 ALEMANY BLVD | 3401 ALEMANY BLVD | - | BRIGHT ST | BRIGHT ST |
| 132702 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S242451 | 1200-1299 9TH AVE | 1200-1299 09TH AVE | F | F | - | F | 431000 | 431000 | - | - | WEST SIDE | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 81694 | 81694 | 37.76498083 | -122.46637656 | - | - | 1715219883000 | middleware_editor | BIKE RACK | LINCOLN WAY to IRVING ST (1200 - 1299) | - | INFO #1225 | - | - | - | - | - | 174370 | - | -122.46637656 | 37.76498083 | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1516622220000 | 09TH AVE | 1200 - 1299 9TH AVE | 1200 - 1299 09TH AVE | 1200 9TH AVE | - | IRVING ST | IRVING ST |
| 132703 | N/A | Point | - | - | - | - | S249758 | GREENWICH ST: TAYLOR ST | - | F | F | - | F | 25498000 | 25498000 | - | - | NORTH WEST CORNER | - | - | - | - | GREENWICH ST | GREENWICH ST | 81695 | 81695 | 37.80168859 | -122.41449234 | TAYLOR ST \ GREENWICH ST | TAYLOR ST \ GREENWICH ST | 1710539427000 | MTA | TAYLOR ST | GREENWICH ST intersection | - | I>2100 | - | - | - | - | - | 174371 | - | -122.41449234 | 37.80168859 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-1.1707 | 36X08 | SUP1 | UTILITY POLE | IS | 1543228860000 | TAYLOR ST | - | - | - | - | - | - |
| 132704 | N/A | Point | - | - | - | - | S249788 | POTRERO AVE: 22ND ST | - | T | T | - | F | 23964000 | 23964000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 22ND ST | POTRERO AVE | 81700 | 81700 | 37.75616698 | -122.4066358 | POTRERO AVE \ 22ND ST | 22ND ST \ POTRERO AVE | 1716920510000 | middleware_editor | NO U TURN (SYM) | POTRERO AVE intersection | - | (NORTHERN INTERSECTION) | - | - | - | - | - | 174372 | 1119830400000 | -122.4066358 | 37.75616698 | - | - | - | D9 | - | OTHER REGULATORY | REG | R3-4.0001 | 24X24 | SUP2 | OVERHEAD MAST ARM | IS | 1543304880000 | 22ND ST | - | - | - | - | - | - |
| 132705 | N/A | Point | - | - | - | - | S249791 | POTRERO AVE: 22ND ST | - | T | T | - | F | 23964000 | 23964000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | 22ND ST | POTRERO AVE | 81701 | 81701 | 37.75616698 | -122.4066358 | POTRERO AVE \ 22ND ST | 22ND ST \ POTRERO AVE | 1716920507000 | middleware_editor | NO LEFT TURN (SYM)/NO U TURN (SYM) | POTRERO AVE intersection | - | (NORTHERN INTERSECTION) | - | - | - | - | - | 174373 | 1119830400000 | -122.4066358 | 37.75616698 | - | 1543968000000 | - | D9 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | SIGNAL POLE | IS | 1543305900000 | 22ND ST | - | - | - | - | - | - |
| 132706 | N/A | Point | 1 | 1 | 6300 - 6421 | - | S245774 | 6300-6421 FULTON ST | 6300-6421 FULTON ST | F | F | - | F | 5946000 | 5946000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 39TH AVE | 39TH AVE | 81703 | 81703 | 37.77186085 | -122.49972029 | - | - | 1710539427000 | MTA | YIELD HERE TO PED (SYM) (LA) | 39TH AVE to 40TH AVE (6300 - 6421) | - | 20FT. WEST OF 39TH AVE. | - | - | - | - | - | 174374 | 1527681360000 | -122.49972029 | 37.77186085 | - | - | - | D1 | - | PEDESTRIAN | REG | R1-5.0001 | 18X24 | SUP2 | 2IN IRON POST | IS | 1527090540000 | FULTON ST | 6300 - 6421 FULTON ST | 6300 - 6421 FULTON ST | 6300 FULTON ST | - | 40TH AVE | 40TH AVE |
| 132707 | N/A | Point | 1 | 1 | 1600 - 1699 | RIGHT ARROW | S257138 | 1600-1699 FELL ST | 1600-1699 FELL ST | F | F | - | F | 5455000 | 5455000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | CENTRAL AVE | CENTRAL AVE | 88799 | 88799 | 37.77310374 | -122.44505928 | - | - | 1710539427000 | MTA | MISCELLANEOUS SIGNS | CENTRAL AVE to MASONIC AVE (1600 - 1699) | - | 75'E OF MASONIC | - | - | - | - | - | 174375 | 1386028800000 | -122.44505928 | 37.77310374 | - | 1588550400000 | - | D5 | - | OTHER GUIDE | GUIDE | G-M(SF).0038 | N/A | SUP1 | 2IN IRON POST | IS | 1566200640000 | FELL ST | 1600 - 1699 FELL ST | 1600 - 1699 FELL ST | 1600 FELL ST | - | MASONIC AVE | MASONIC AVE |
| 132708 | N/A | Point | 1 | 1 | 500 - 599 | - | S257215 | 500-599 JESSIE ST | 500-599 JESSIE ST | F | F | - | F | 7523000 | 7523000 | - | - | SOUTH SIDE | - | - | - | - | 6TH ST | 06TH ST | 88800 | 88800 | 37.78102414 | -122.40971856 | - | - | 1710539427000 | MTA | BIKE RACK | 06TH ST to END: 500-599 BLOCK (500 - 599) | 48077 | 7' W OF 6TH ST/ 2.5' IN FROM CURB | - | - | - | - | - | 174376 | 1566479640000 | -122.40971856 | 37.78102414 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1566391620000 | JESSIE ST | 500 - 599 JESSIE ST | 500 - 599 JESSIE ST | 500 JESSIE ST | - | END: 500-599 BLOCK | END: 500-599 BLOCK |
| 132709 | N/A | Point | - | - | - | - | S111395 | NORTHGATE DR: DARIEN WAY | - | F | F | - | F | 22678000 | 22678000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DARIEN WAY | DARIEN WAY | 10075 | 10075 | 37.7293186 | -122.46152436 | NORTHGATE DR \ DARIEN WAY | NORTHGATE DR \ DARIEN WAY | 1710539427000 | MTA | STOP | DARIEN WAY intersection | - | SEE PAINT | - | - | - | - | - | 174377 | 786758400000 | -122.46152436 | 37.7293186 | - | 1674000000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571120000 | NORTHGATE DR | - | - | - | - | - | - |
| 132710 | N/A | Point | - | - | - | - | S111679 | THORNTON AVE: LEDYARD ST \ VES | - | F | F | - | F | 20620000 | 20620000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | THORNTON AVE \ VESTA ST | THORNTON AVE \ VESTA ST | 10078 | 10078 | 37.73147826 | -122.40029326 | LEDYARD ST \ THORNTON AVE \ VESTA ST | LEDYARD ST \ THORNTON AVE \ VESTA ST | 1754421239000 | middleware_editor | STOP | THORNTON AVE \ VESTA ST intersection | - | - | - | - | - | - | - | 174378 | 839919600000 | -122.40029326 | 37.73147826 | - | 1514880000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571180000 | LEDYARD ST | - | - | - | - | - | - |
| 132711 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S111680 | 1800-1899 TURK ST | 1800-1899 TURK ST | F | F | - | F | 12734000 | 12734000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 10079 | 10079 | 37.77954913 | -122.43956847 | - | - | 1712712217000 | middleware_editor | NO LEFT TURN (SYM) | DIVISADERO ST to BRODERICK ST (1800 - 1899) | - | 20W / ABOVE EXISTING R41 | - | - | - | - | - | 174379 | 839894400000 | -122.43956847 | 37.77954913 | - | - | - | D5 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373571180000 | TURK ST | 1800 - 1899 TURK ST | 1800 - 1899 TURK ST | 1800 TURK ST | - | BRODERICK ST | BRODERICK ST |
| 132712 | N/A | Point | - | - | - | - | S111681 | 33RD AVE: ULLOA ST | - | F | F | - | F | 23353000 | 23353000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ULLOA ST | ULLOA ST | 10080 | 10080 | 37.74052185 | -122.49056181 | 33RD AVE \ ULLOA ST | 33RD AVE \ ULLOA ST | 1742492650000 | middleware_editor | STOP | ULLOA ST intersection | - | - | - | - | - | - | - | 174380 | 840697200000 | -122.49056181 | 37.74052185 | - | 1475132400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571180000 | 33RD AVE | - | - | - | - | - | - |
| 132713 | N/A | Point | - | - | - | - | S113052 | HIGUERA AVE: ARBALLO DR | - | F | F | - | F | 23099000 | 23099000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ARBALLO DR | ARBALLO DR | 10085 | 10085 | 37.71827109 | -122.48315976 | HIGUERA AVE \ ARBALLO DR | HIGUERA AVE \ ARBALLO DR | 1742263657000 | middleware_editor | ONE WAY (RA) | ARBALLO DR intersection | - | - | - | - | - | - | - | 174381 | 979632000000 | -122.48315976 | 37.71827109 | - | - | - | D7 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | 2IN IRON POST | IS | 1373571600000 | HIGUERA AVE | - | - | - | - | - | - |
| 132714 | N/A | Point | 1 | 1 | 900 - 956 | - | S113054 | 900-956 CLAY ST | 900-956 CLAY ST | F | F | - | F | 4092000 | 4092000 | - | - | SOUTH SIDE | - | - | - | - | STOCKTON ST | STOCKTON ST | 10087 | 10087 | 37.79400832 | -122.40831183 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM TUE THUR STCL | STOCKTON ST to JOICE ST (900 - 956) | - | IFO #979 | - | - | - | - | - | 174382 | 979862400000 | -122.40831183 | 37.79400832 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0133 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1373571600000 | CLAY ST | 900 - 956 CLAY ST | 900 - 956 CLAY ST | 900 CLAY ST | - | JOICE ST | JOICE ST |
| 132715 | N/A | Point | - | - | - | - | S117167 | JENNINGS ST: KEY AVE | - | F | F | - | F | 20264000 | 20264000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | KEY AVE | KEY AVE | 12438 | 12438 | 37.71893209 | -122.39599491 | JENNINGS ST \ KEY AVE | JENNINGS ST \ KEY AVE | 1710539427000 | MTA | ALL WAY | KEY AVE intersection | - | 2700 BLOCK PER OMD | - | - | - | - | - | 174383 | 1057622400000 | -122.39599491 | 37.71893209 | - | - | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373572920000 | JENNINGS ST | - | - | - | - | - | - |
| 132716 | N/A | Point | - | - | - | - | S117168 | JENNINGS ST: KEY AVE | - | F | F | - | F | 20264000 | 20264000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | KEY AVE | KEY AVE | 12439 | 12439 | 37.71893209 | -122.39599491 | JENNINGS ST \ KEY AVE | JENNINGS ST \ KEY AVE | 1710539427000 | MTA | ALL WAY | KEY AVE intersection | - | 2700 BLOCK PER OMD | - | - | - | - | - | 174384 | 1057622400000 | -122.39599491 | 37.71893209 | - | - | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373572920000 | JENNINGS ST | - | - | - | - | - | - |
| 132717 | N/A | Point | 1 | 1 | 3100 - 3149 | - | S118272 | 3100-3149 JUDAH ST | 3100-3149 JUDAH ST | F | F | - | F | 7672000 | 7672000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | 36TH AVE | 36TH AVE | 12440 | 12440 | 37.76088584 | -122.49548135 | - | - | 1710539427000 | MTA | (45 LA-DN/45 RA-DN) (SYM) | 36TH AVE to SUNSET BLVD (3100 - 3149) | - | 20`EAST | - | - | - | - | - | 174385 | 1075248000000 | -122.49548135 | 37.76088584 | - | - | - | D4 | - | OTHER WARNING | WARNING | W12-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373573220000 | JUDAH ST | 3100 - 3149 JUDAH ST | 3100 - 3149 JUDAH ST | 3100 JUDAH ST | - | SUNSET BLVD | SUNSET BLVD |
| 132718 | N/A | Point | 1 | 1 | 3500 - 3599 | - | S118273 | 3500-3599 JUDAH ST | 3500-3599 JUDAH ST | T | F | - | F | 27787000 | 7677000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | JUDAH ST | 40TH AVE | 12441 | 12441 | 37.7606823275712 | -122.499379813666 | 40TH AVE \ JUDAH ST | - | 1745617271000 | middleware_editor | (45 LA-DN/45 RA-DN) (SYM) | 40TH AVE to 41ST AVE (3500 - 3599) | - | W TIP OF CI EASTBOUND | - | - | - | - | - | 174386 | 1075276800000 | -122.50003198 | 37.76068496 | - | 1745601420000 | - | D4 | - | OTHER WARNING | WARNING | W12-1.0001 | 24X24 | SUP2 | 2IN BREAK-AWAY SYSTEM | IS | 1373573220000 | JUDAH ST | - | 3500 - 3599 JUDAH ST | 3500 JUDAH ST | - | - | 41ST AVE |
| 132719 | N/A | Point | 1 | 1 | 2850 - 2899 | - | S118274 | 2850-2899 24TH ST | 2850-2899 24TH ST | F | F | - | F | 1333000 | 1333000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | BRYANT ST | BRYANT ST | 12442 | 12442 | 37.7527673 | -122.40959816 | - | - | 1710539427000 | MTA | (45 LA-DN) | BRYANT ST to FLORIDA ST (2850 - 2899) | - | INFO #2884 | - | - | - | - | - | 174387 | 1075248000000 | -122.40959816 | 37.7527673 | - | - | - | D9 | - | OTHER WARNING | WARNING | W16-7P.0001 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373573220000 | 24TH ST | 2850 - 2899 24TH ST | 2850 - 2899 24TH ST | 2850 24TH ST | - | FLORIDA ST | FLORIDA ST |
| 132720 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S118276 | 1100-1199 ALABAMA ST | 1100-1199 ALABAMA ST | F | F | - | F | 2117000 | 2117000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 23RD ST | 23RD ST | 12443 | 12443 | 37.75348583 | -122.41104139 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | 23RD ST to 24TH ST (1100 - 1199) | - | SPL #1166 | - | - | - | - | - | 174388 | 1075248000000 | -122.41104139 | 37.75348583 | - | 1548115200000 | - | D9 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1373573220000 | ALABAMA ST | 1100 - 1199 ALABAMA ST | 1100 - 1199 ALABAMA ST | 1100 ALABAMA ST | - | 24TH ST | 24TH ST |
| 132721 | N/A | Point | 1 | 1 | 2850 - 2899 | - | S118280 | 2850-2899 24TH ST | 2850-2899 24TH ST | F | F | - | F | 1333000 | 1333000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | BRYANT ST | BRYANT ST | 12447 | 12447 | 37.7527673 | -122.40959816 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | BRYANT ST to FLORIDA ST (2850 - 2899) | - | WPL #2866 | - | - | - | - | - | 174389 | 1075248000000 | -122.40959816 | 37.7527673 | - | - | - | D9 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1373573220000 | 24TH ST | 2850 - 2899 24TH ST | 2850 - 2899 24TH ST | 2850 24TH ST | - | FLORIDA ST | FLORIDA ST |
| 132722 | N/A | Point | 1 | 1 | 500 - 599 | - | S118032 | 500-599 ASHBURY ST | 500-599 ASHBURY ST | F | F | - | F | 2512000 | 2512000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | PAGE ST | PAGE ST | 12448 | 12448 | 37.77047113 | -122.44702826 | - | - | 1710539427000 | MTA | ROUNDABOUT ARROWS | PAGE ST to HAIGHT ST (500 - 599) | - | NORTH LINE OF TURN AROUND | - | - | - | - | - | 174390 | 1070409600000 | -122.44702826 | 37.77047113 | - | - | - | D5 | - | OTHER REGULATORY | REG | R7(SF).0001 | 18X24 | SUP1 | 2IN IRON POST | IS | 1373573160000 | ASHBURY ST | 500 - 599 ASHBURY ST | 500 - 599 ASHBURY ST | 500 ASHBURY ST | - | HAIGHT ST | HAIGHT ST |
| 132723 | N/A | Point | 1 | 1 | 500 - 599 | - | S118033 | 500-599 CLAYTON ST | 500-599 CLAYTON ST | F | F | - | F | 26415000 | 4131000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | PAGE ST | PAGE ST | 12449 | 12449 | 37.77026437 | -122.44867337 | CLAYTON ST \ PAGE ST | - | 1710539427000 | MTA | ROUNDABOUT ARROWS | PAGE ST to HAIGHT ST (500 - 599) | - | SOUTH LINE OF TURN AROUND | - | - | - | - | - | 174391 | 1070409600000 | -122.44867337 | 37.77026437 | - | - | - | D5 | - | OTHER REGULATORY | REG | R7(SF).0001 | 18X24 | SUP1 | 2IN IRON POST | IS | 1373573160000 | CLAYTON ST | - | 500 - 599 CLAYTON ST | 500 CLAYTON ST | - | - | HAIGHT ST |
| 132724 | N/A | Point | - | - | - | - | S118036 | 25TH ST: FOUNTAIN ST | - | F | F | - | F | 22322000 | 22322000 | - | - | NORTH WEST CORNER | - | - | - | - | 25TH ST | FOUNTAIN ST | 12450 | 12450 | 37.74923082 | -122.44153808 | FOUNTAIN ST \ 25TH ST | 25TH ST \ FOUNTAIN ST | 1710539427000 | MTA | NPRK 12NN-2PM WED STCL | FOUNTAIN ST intersection | - | NWCORNER | - | - | - | - | - | 174392 | 1070496000000 | -122.44153808 | 37.74923082 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0086 | 18X18 | SUP2 | LIGHT POLE | IS | 1373573160000 | 25TH ST | - | - | - | - | - | - |
| 132725 | N/A | Point | 1 | 1 | 100 - 199 | - | S118037 | 100-199 20TH AVE | 100-199 20TH AVE | F | F | - | F | 998000 | 998000 | - | - | CENTER ISLAND | - | - | - | - | LAKE ST | LAKE ST | 12451 | 12451 | 37.78505399 | -122.4797183 | - | - | 1725499280000 | middleware_editor | COMPACT CARS ONLY | LAKE ST to CALIFORNIA ST (100 - 199) | - | OPP.#25 | - | - | - | - | - | 174393 | 1070582400000 | -122.4797183 | 37.78505399 | - | - | - | D1 | - | OTHER REGULATORY | REG | R(SF).0036 | 10X15 | SUP2 | FENCE | IS | 1373573160000 | 20TH AVE | 100 - 199 20TH AVE | 100 - 199 20TH AVE | 100 20TH AVE | - | CALIFORNIA ST | CALIFORNIA ST |
| 132726 | N/A | Point | - | - | - | - | S118038 | CHURCH ST: 27TH ST | - | F | F | - | F | 21915000 | 21915000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 27TH ST | 27TH ST | 12452 | 12452 | 37.74689658 | -122.42696826 | CHURCH ST \ 27TH ST | CHURCH ST \ 27TH ST | 1710539427000 | MTA | ALL WAY | 27TH ST intersection | - | NWCORNER | - | - | - | - | - | 174394 | 1070582400000 | -122.42696826 | 37.74689658 | - | - | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573160000 | CHURCH ST | - | - | - | - | - | - |
| 132727 | N/A | Point | - | - | - | - | S240651 | QUINT ST: CUSTER AVE | - | F | F | - | F | 20252000 | 20252000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CUSTER AVE | CUSTER AVE | 75837 | 75837 | 37.74529841 | -122.3891933 | QUINT ST \ CUSTER AVE | QUINT ST \ CUSTER AVE | 1741901046000 | middleware_editor | ALL WAY | CUSTER AVE intersection | - | - | - | - | - | - | - | 174395 | 1430118000000 | -122.3891933 | 37.74529841 | - | 1510992000000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1510909980000 | QUINT ST | - | - | - | - | - | - |
| 132728 | N/A | Point | - | - | - | - | S240652 | CUSTER AVE: QUINT ST | - | F | F | - | F | 20252000 | 20252000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CUSTER AVE | CUSTER AVE | 75838 | 75838 | 37.74529841 | -122.3891933 | QUINT ST \ CUSTER AVE | QUINT ST \ CUSTER AVE | 1741896529000 | gorr | STOP | CUSTER AVE intersection | - | - | - | - | - | - | - | 174396 | 1511044080000 | -122.3891933 | 37.74529841 | - | 1653548400000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1510910340000 | QUINT ST | - | - | - | - | - | - |
| 132729 | N/A | Point | - | - | - | - | S240655 | CUSTER AVE: QUINT ST | - | F | F | - | F | 20252000 | 20252000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CUSTER AVE | CUSTER AVE | 75839 | 75839 | 37.74529841 | -122.3891933 | QUINT ST \ CUSTER AVE | QUINT ST \ CUSTER AVE | 1741891635000 | elclark | STOP | CUSTER AVE intersection | - | - | - | - | - | - | - | 174397 | 1511044260000 | -122.3891933 | 37.74529841 | - | 1510992000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 3IN IRON POST | IS | 1510910940000 | QUINT ST | - | - | - | - | - | - |
| 132730 | N/A | Point | - | - | - | - | S240656 | CUSTER AVE: QUINT ST | - | F | F | - | F | 20252000 | 20252000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CUSTER AVE | CUSTER AVE | 75840 | 75840 | 37.74529841 | -122.3891933 | QUINT ST \ CUSTER AVE | QUINT ST \ CUSTER AVE | 1741901058000 | middleware_editor | ALL WAY | CUSTER AVE intersection | - | - | - | - | - | - | - | 174398 | 1511044380000 | -122.3891933 | 37.74529841 | - | 1510992000000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 3IN IRON POST | IS | 1510911120000 | QUINT ST | - | - | - | - | - | - |
| 132731 | N/A | Point | - | - | - | - | S253210 | BROADWAY: THE EMBARCADERO | - | F | F | - | F | 24570000 | 24570000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BROADWAY | BROADWAY | 79484 | 79484 | 37.79923448 | -122.39766995 | THE EMBARCADERO \ BROADWAY | THE EMBARCADERO \ BROADWAY | 1724167386000 | middleware_editor | BIKE WAYFINDING SIGN | BROADWAY intersection | 0829 | 10 FT WEST OF WEST EMBARCADERO | - | - | - | - | - | 174399 | -388886400000 | -122.39766995 | 37.79923448 | - | 1557100800000 | - | D3 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | 2IN IRON POST | IS | 1554384240000 | THE EMBARCADERO | - | - | - | - | - | - |
| 132732 | N/A | Point | 1 | 1 | 3100 - 3128 | - | S138385 | 3100-3128 STEINER ST | 3100-3128 STEINER ST | F | F | - | F | 12151000 | 12151000 | - | - | WEST SIDE | - | - | - | - | FILBERT ST | FILBERT ST | 80282 | 80282 | 37.79804449 | -122.43737329 | - | - | 1710539427000 | MTA | NPRK 10AM-12NN 1ST & 3RD MON OF MONTH STCL | FILBERT ST to PIXLEY ST (3100 - 3128) | - | 42 FEET NORTH OF FILBERT | - | - | - | - | - | 174400 | 1219795200000 | -122.43737329 | 37.79804449 | - | 1450137600000 | - | D2 | - | STREET CLEANING | REG | R30B(CA).0001 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1375723920000 | STEINER ST | 3100 - 3128 STEINER ST | 3100 - 3128 STEINER ST | 3100 STEINER ST | - | PIXLEY ST | PIXLEY ST |
| 132733 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S138634 | 2000-2099 GREENWICH ST | 2000-2099 GREENWICH ST | F | F | - | F | 6517000 | 6517000 | - | - | SOUTH SIDE | - | - | - | - | BUCHANAN ST | BUCHANAN ST | 80283 | 80283 | 37.79926521 | -122.43340257 | - | - | 1744067100000 | middleware_editor | NPRK 9AM-11AM 1ST & 3RD TUE OF MONTH STCL | BUCHANAN ST to WEBSTER ST (2000 - 2099) | - | 2085 GREENWICH | - | - | - | - | - | 174401 | 1219820400000 | -122.43340257 | 37.79926521 | - | 1744050120000 | - | D2 | - | STREET CLEANING | REG | R30B(CA).0288 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1375724040000 | GREENWICH ST | 2000 - 2099 GREENWICH ST | 2000 - 2099 GREENWICH ST | 2000 GREENWICH ST | - | WEBSTER ST | WEBSTER ST |
| 132734 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S138644 | 1800-1899 GREENWICH ST | 1800-1899 GREENWICH ST | F | F | - | F | 6515000 | 6515000 | - | - | SOUTH SIDE | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 80284 | 80284 | 37.7997093151417 | -122.429559423796 | - | - | 1743807594000 | middleware_editor | NPRK 9AM-11AM 1ST & 3RD TUE OF MONTH STCL | OCTAVIA ST to LAGUNA ST (1800 - 1899) | - | 1801 GREENWICH | - | - | - | - | - | 174402 | 1219820400000 | -122.43011266 | 37.79968356 | - | 1743802860000 | - | D2 | - | STREET CLEANING | REG | R30B(CA).0288 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1375724040000 | GREENWICH ST | 1800 - 1899 GREENWICH ST | 1800 - 1899 GREENWICH ST | 1800 GREENWICH ST | - | LAGUNA ST | LAGUNA ST |
| 132735 | N/A | Point | 1 | 1 | 3000 - 3099 | - | S138921 | 3000-3099 FRANKLIN ST | 3000-3099 FRANKLIN ST | F | F | - | F | 5840000 | 5840000 | - | - | WEST SIDE | - | - | - | - | CHESTNUT ST | CHESTNUT ST | 80285 | 80285 | 37.80253495 | -122.42647127 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 1ST & 3RD THUR OF MONTH STCL | CHESTNUT ST to FRANCISCO ST (3000 - 3099) | - | 3053 FRANKLIN | - | - | - | - | - | 174403 | 1219968000000 | -122.42647127 | 37.80253495 | - | - | - | D2 | - | STREET CLEANING | REG | R30B(CA).0249 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1375724400000 | FRANKLIN ST | 3000 - 3099 FRANKLIN ST | 3000 - 3099 FRANKLIN ST | 3000 FRANKLIN ST | - | FRANCISCO ST | FRANCISCO ST |
| 132736 | N/A | Point | 1 | 1 | 700 - 729 | - | S251277 | 700-729 POLK ST | 700-729 POLK ST | F | F | - | F | 10555000 | 10555000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | EDDY ST | EDDY ST | 80286 | 80286 | 37.78333459 | -122.41922757 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | EDDY ST to WILLOW ST (700 - 729) | - | START 10' NORTH OF X-WALK /EVERY 15' OC | - | - | - | - | - | 174404 | 1550534400000 | -122.41922757 | 37.78333459 | - | 1710253440000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | TURNPIKE BASE | IS | 1549007760000 | POLK ST | 700 - 729 POLK ST | 700 - 729 POLK ST | 700 POLK ST | - | WILLOW ST | WILLOW ST |
| 132737 | N/A | Point | 1 | 1 | 726 - 799 | - | S251278 | 726-799 POLK ST | 726-799 POLK ST | F | F | - | F | 10556000 | 10556000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | WILLOW ST | WILLOW ST | 80287 | 80287 | 37.78379845 | -122.4193188 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | WILLOW ST to ELLIS ST (726 - 799) | - | 10' OC NORTH OF WILLOW ST. | - | - | - | - | - | 174405 | 1550534400000 | -122.4193188 | 37.78379845 | - | 1710252180000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | TURNPIKE BASE | IS | 1549008060000 | POLK ST | 726 - 799 POLK ST | 726 - 799 POLK ST | 726 POLK ST | - | ELLIS ST | ELLIS ST |
| 132738 | N/A | Point | - | 1 | 500 - 599 | - | S251510 | 500-599 8TH ST | 500-599 08TH ST | F | F | - | F | 416000 | 416000 | - | - | EAST SIDE | - | - | - | - | BRYANT ST | BRYANT ST | 80288 | 80288 | 37.77191132 | -122.40619651 | - | - | 1710539427000 | MTA | BIKE RACK | BRYANT ST to BRANNAN ST (500 - 599) | 39149 | 14' S OF NPL#541/3' IN FROM CURB | - | - | - | - | - | 174406 | 1549896420000 | -122.40619651 | 37.77191132 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1549892460000 | 08TH ST | 500 - 599 8TH ST | 500 - 599 08TH ST | 500 8TH ST | - | BRANNAN ST | BRANNAN ST |
| 132739 | N/A | Point | - | 1 | 500 - 599 | - | S251511 | 500-599 8TH ST | 500-599 08TH ST | F | F | - | F | 416000 | 416000 | - | - | EAST SIDE | - | - | - | - | BRYANT ST | BRYANT ST | 80289 | 80289 | 37.77191132 | -122.40619651 | - | - | 1710539427000 | MTA | BIKE RACK | BRYANT ST to BRANNAN ST (500 - 599) | 39149 | 11' N OF NPL#541/3' IN FROM CURB | - | - | - | - | - | 174407 | 1549896540000 | -122.40619651 | 37.77191132 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1549892640000 | 08TH ST | 500 - 599 8TH ST | 500 - 599 08TH ST | 500 8TH ST | - | BRANNAN ST | BRANNAN ST |
| 132740 | N/A | Point | 1 | 1 | 800 - 899 | - | S251646 | 800-899 EDDY ST | 800-899 EDDY ST | F | F | - | F | 5066000 | 5066000 | - | - | SOUTH SIDE | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 80290 | 80290 | 37.78278975 | -122.42164037 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM TUE STCL | VAN NESS AVE to FRANKLIN ST (800 - 899) | - | 75' E OF FRANKLIN | - | - | - | - | - | 174408 | - | -122.42164037 | 37.78278975 | - | - | - | D5 | - | STREET CLEANING | REG | R30B(CA).0270 | 18X18 | SUP1 | LIGHT POLE | IS | 1550144220000 | EDDY ST | 800 - 899 EDDY ST | 800 - 899 EDDY ST | 800 EDDY ST | - | FRANKLIN ST | FRANKLIN ST |
| 132741 | N/A | Point | 1 | 1 | 801 - 899 | - | S247443 | 800-899 BROADWAY | 801-899 BROADWAY | T | T | - | F | 3158000 | 3158000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | POWELL ST \ ROBERT C LEVY TUNL | POWELL ST \ ROBERT C LEVY TUNL | 80294 | 80294 | 37.79714934 | -122.41104508 | - | - | 1710539427000 | MTA | "P" (WHITE-BLUE) | POWELL ST \ ROBERT C LEVY TUNL to MASON ST (801 - 899) -- SOUTH -- | - | 140FT WEST OF POWELL | - | - | - | - | - | 174409 | 1533081600000 | -122.41104508 | 37.79714934 | - | - | - | D3 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1533116820000 | BROADWAY | 801 - 899 BROADWAY | 801 - 899 BROADWAY | 801 BROADWAY | - | MASON ST | MASON ST |
| 132742 | N/A | Point | 1 | 1 | 801 - 899 | - | S247444 | 800-899 BROADWAY | 801-899 BROADWAY | T | T | - | F | 3158000 | 3158000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | POWELL ST \ ROBERT C LEVY TUNL | POWELL ST \ ROBERT C LEVY TUNL | 80295 | 80295 | 37.79714934 | -122.41104508 | - | - | 1710539427000 | MTA | (LA) NORTH BEACH GARAGE | POWELL ST \ ROBERT C LEVY TUNL to MASON ST (801 - 899) -- SOUTH -- | - | 140FT WEST OF POWELL | - | - | - | - | - | 174410 | 1533081600000 | -122.41104508 | 37.79714934 | - | 1678838400000 | - | D3 | - | OTHER GUIDE | GUIDE | G-P(SF).0141 | 30X30 | SUP1 | LIGHT POLE | IS | 1533117000000 | BROADWAY | 801 - 899 BROADWAY | 801 - 899 BROADWAY | 801 BROADWAY | - | MASON ST | MASON ST |
| 132743 | N/A | Point | 1 | 1 | 801 - 899 | - | S247445 | 800-899 BROADWAY | 801-899 BROADWAY | T | T | - | F | 3158000 | 3158000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | POWELL ST \ ROBERT C LEVY TUNL | POWELL ST \ ROBERT C LEVY TUNL | 80296 | 80296 | 37.79714934 | -122.41104508 | - | - | 1710539427000 | MTA | (45 LA) REVERSE CURVE (SYM) | POWELL ST \ ROBERT C LEVY TUNL to MASON ST (801 - 899) -- SOUTH -- | - | 140FT WEST OF POWELL | - | - | - | - | - | 174411 | 1533081600000 | -122.41104508 | 37.79714934 | - | - | - | D3 | - | OTHER WARNING | WARNING | W1-4.0005 | 36X36 | SUP1 | LIGHT POLE | IS | 1533117120000 | BROADWAY | 801 - 899 BROADWAY | 801 - 899 BROADWAY | 801 BROADWAY | - | MASON ST | MASON ST |
| 132744 | N/A | Point | - | - | - | - | S111020 | LOMBARD ST: VAN NESS AVE | - | F | F | - | F | 26696000 | 26696000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LOMBARD ST | VAN NESS AVE | 86586 | 86586 | 37.80130372 | -122.42453833 | VAN NESS AVE \ LOMBARD ST | LOMBARD ST \ VAN NESS AVE | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | VAN NESS AVE intersection | - | - | - | - | - | - | - | 174412 | 735264000000 | -122.42453833 | 37.80130372 | - | 1653523200000 | - | D2 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1373571000000 | LOMBARD ST | - | - | - | - | - | - |
| 132745 | N/A | Point | - | - | - | - | S253671 | ARKANSAS ST: 23RD ST | - | F | F | - | F | 23642000 | 23642000 | - | - | NORTH WEST CORNER | - | - | - | - | 23RD ST | ARKANSAS ST | 86587 | 86587 | 37.75482658 | -122.39772873 | ARKANSAS ST \ 23RD ST | 23RD ST \ ARKANSAS ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | ARKANSAS ST intersection | - | 6 DEL, X-STREET IS 23RD ST SEE NOTES | - | - | - | - | - | 174413 | 1559743200000 | -122.39772873 | 37.75482658 | - | - | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1555928760000 | 23RD ST | - | - | - | - | - | - |
| 132746 | N/A | Point | - | - | - | - | S253672 | ARKANSAS ST: 23RD ST | - | F | F | - | F | 23642000 | 23642000 | - | - | NORTH EAST CORNER | - | - | - | - | 23RD ST | ARKANSAS ST | 86588 | 86588 | 37.75482658 | -122.39772873 | ARKANSAS ST \ 23RD ST | 23RD ST \ ARKANSAS ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | ARKANSAS ST intersection | - | 5 DEL, X-STREET IS 23RD ST SEE NOTES | - | - | - | - | - | 174414 | 1559743320000 | -122.39772873 | 37.75482658 | - | - | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1555928880000 | 23RD ST | - | - | - | - | - | - |
| 132747 | N/A | Point | 1 | 1 | 2100 - 2199 | - | S258995 | 2084-2199 CHESTNUT ST | 2100-2199 CHESTNUT ST | F | F | - | F | 3979000 | 3979000 | - | - | SOUTH SIDE | - | - | - | - | STEINER ST | STEINER ST | 86589 | 86589 | 37.80050609 | -122.43869681 | - | - | 1710539427000 | MTA | BIKE RACK | STEINER ST to PIERCE ST (2100 - 2199) | 76734 | 1' W OF EPL 2125/3' IN FROM CURB | - | - | - | - | - | 174415 | 1575383880000 | -122.43869681 | 37.80050609 | - | - | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1573025580000 | CHESTNUT ST | 2100 - 2199 CHESTNUT ST | 2100 - 2199 CHESTNUT ST | 2100 CHESTNUT ST | - | PIERCE ST | PIERCE ST |
| 132748 | N/A | Point | - | - | - | - | S217214 | WEBSTER ST: GEARY BLVD | - | F | F | - | F | 26587000 | 26587000 | - | - | CENTER ISLAND, W LINE, WESTBOUND | - | - | - | - | GEARY BLVD | GEARY BLVD | 87301 | 87301 | 37.78456824 | -122.43120495 | WEBSTER ST \ GEARY BLVD | WEBSTER ST \ GEARY BLVD | 1710539427000 | MTA | TYPE P LEFT | GEARY BLVD intersection | - | ON GEARY BLVD CI | - | - | - | - | - | 174416 | - | -122.43120495 | 37.78456824 | - | - | - | D5 | - | OTHER WARNING | WARNING | TYPE-P(CA).0001 | 12X36 | SUP1 | 2IN IRON POST | IS | 1434705960000 | WEBSTER ST | - | - | - | - | - | - |
| 132749 | N/A | Point | 1 | 1 | 4200 - 4299 | - | S217693 | 4200-4299 JUDAH ST | 4200-4299 JUDAH ST | F | F | - | F | 7684000 | 7684000 | - | - | SOUTH SIDE | - | - | - | - | 47TH AVE | 47TH AVE | 87303 | 87303 | 37.76035344 | -122.50753338 | - | - | 1710539427000 | MTA | NPRK 7AM-8AM TUE FRI STCL | 47TH AVE to 48TH AVE (4200 - 4299) | - | 15`WEST (IFO# 4207) | - | - | - | - | - | 174417 | - | -122.50753338 | 37.76035344 | - | 1709904360000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0219 | 18X18 | SUP2 | 2IN IRON POST | IS | 1436276580000 | JUDAH ST | 4200 - 4299 JUDAH ST | 4200 - 4299 JUDAH ST | 4200 JUDAH ST | - | 48TH AVE | 48TH AVE |
| 132750 | N/A | Point | - | - | - | - | S108706 | 5TH AVE: KIRKHAM ST | - | F | F | - | F | 27074000 | 27074000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 5TH AVE | 05TH AVE | 87304 | 87304 | 37.76049923 | -122.4617702 | KIRKHAM ST \ 5TH AVE | KIRKHAM ST \ 05TH AVE | 1710539427000 | MTA | STOP | 05TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 174418 | 338774400000 | -122.4617702 | 37.76049923 | - | 1477526400000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570280000 | KIRKHAM 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