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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 117976 | N/A | Point | - | - | - | - | S126331 | MANSELL ST: HAMILTON ST | - | T | T | - | F | 20847000 | 20847000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MANSELL ST | HAMILTON ST | 22360 | 22360 | 37.71999112 | -122.40699791 | HAMILTON ST \ MANSELL ST | MANSELL ST \ HAMILTON ST | 1717030604000 | middleware_editor | SCHOOL (SYM)/ 45 LEFT DN ARROW (COMBO) | HAMILTON ST intersection | - | 0 / ON WESTBOUND LANES OF MANSELL B..... | - | - | - | - | - | 159619 | - | -122.40699791 | 37.71999112 | - | 1675123200000 | - | D10 | - | SCHOOL | WARNING | SW24-2(CA).0001 | 30X42 | SUP1 | LIGHT POLE | IS | 1373575800000 | MANSELL ST | - | - | - | - | - | - |
| 117977 | N/A | Point | - | - | - | - | S126332 | 3RD ST: SOUTH ST | - | F | F | - | F | 34162000 | 34162000 | - | - | SOUTH EAST CORNER | - | - | - | - | WARRIORS WAY | 03RD ST | 22361 | 22361 | 37.76881994 | -122.38930772 | 3RD ST \ WARRIORS WAY | WARRIORS WAY \ 03RD ST | 1710539427000 | MTA | 3RD ST | 03RD ST intersection | - | I-1600BLK> | - | - | - | - | - | 159620 | 1166400000000 | -122.38930772 | 37.76881994 | - | 1564531200000 | - | D6 | - | STREET NAME | GUIDE | D3-1.0030 | 36X08 | SUP1 | LIGHT POLE | IS | 1373575800000 | WARRIORS WAY | - | - | - | - | - | - |
| 117978 | N/A | Point | - | - | - | - | S129977 | 3RD ST: STEVENSON ST | - | F | F | - | F | 24639000 | 24639000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | STEVENSON ST | 03RD ST | 22362 | 22362 | 37.78702442 | -122.40302819 | 3RD ST \ STEVENSON ST | STEVENSON ST \ 03RD ST | 1710539427000 | MTA | NO PED XING-USE CROSSWALK (LA) | 03RD ST intersection | - | - | - | - | - | - | - | 159621 | 1230681600000 | -122.40302819 | 37.78702442 | - | - | - | D6 | - | PEDESTRIAN | REG | R49(CA).0004 | 36X18 | SUP1 | MUNI POLE | IS | 1373576940000 | STEVENSON ST | - | - | - | - | - | - |
| 117979 | N/A | Point | 1 | 1 | 700 - 999 | - | S127588 | 700-999 ELLSWORTH ST | 700-999 ELLSWORTH ST | F | F | - | F | 5201000 | 5201000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CRESCENT AVE | CRESCENT AVE | 21033 | 21033 | 37.73322801 | -122.4166609 | - | - | 1710539427000 | MTA | 10MPH (ADV SPEED) | CRESCENT AVE to ALEMANY BLVD \ I-280 S OFF RAMP \ I-280 S ON RAMP (700 - 999) | - | OPP #764 | - | - | - | - | - | 159622 | 1179792000000 | -122.4166609 | 37.73322801 | - | - | - | D9 | - | SPEED LIMIT | WARNING | W13-1P.0001 | 24X24 | SUP2 | LIGHT POLE | IS | 1373576160000 | ELLSWORTH ST | 700 - 999 ELLSWORTH ST | 700 - 999 ELLSWORTH ST | 700 ELLSWORTH ST | - | ALEMANY BLVD \ I-280 S OFF RAMP \ I-280 S ON RAMP | ALEMANY BLVD \ I-280 S OFF RAMP \ I-280 S ON RAMP |
| 117980 | N/A | Point | 1 | 1 | 700 - 999 | - | S127589 | 700-999 ELLSWORTH ST | 700-999 ELLSWORTH ST | F | F | - | F | 5201000 | 5201000 | - | - | WEST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CRESCENT AVE | CRESCENT AVE | 21034 | 21034 | 37.73322801 | -122.4166609 | - | - | 1710539427000 | MTA | 10MPH (ADV SPEED) | CRESCENT AVE to ALEMANY BLVD \ I-280 S OFF RAMP \ I-280 S ON RAMP (700 - 999) | - | 5FT SOUTH OF #764 | - | - | - | - | - | 159623 | 1179792000000 | -122.4166609 | 37.73322801 | - | - | - | D9 | - | SPEED LIMIT | WARNING | W13-1P.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373576160000 | ELLSWORTH ST | 700 - 999 ELLSWORTH ST | 700 - 999 ELLSWORTH ST | 700 ELLSWORTH ST | - | ALEMANY BLVD \ I-280 S OFF RAMP \ I-280 S ON RAMP | ALEMANY BLVD \ I-280 S OFF RAMP \ I-280 S ON RAMP |
| 117981 | N/A | Point | - | - | - | - | S127590 | ILLINOIS ST: 18TH ST | - | F | F | - | F | 23569000 | 23569000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ILLINOIS ST | 18TH ST | 21035 | 21035 | 37.76310722 | -122.3877948 | 18TH ST \ ILLINOIS ST | ILLINOIS ST \ 18TH ST | 1710539427000 | MTA | (LA) I-280 (SYM) | 18TH ST intersection | - | - | - | - | - | - | - | 159624 | 1179878400000 | -122.3877948 | 37.76310722 | - | - | - | D10 | - | OTHER GUIDE | GUIDE | G-I(SF).0005 | 36X30 | SUP1 | 2IN IRON POST | IS | 1373576160000 | ILLINOIS ST | - | - | - | - | - | - |
| 117982 | N/A | Point | 1 | 1 | 3600 - 3699 | - | S127518 | 3600-3699 CALIFORNIA ST | 3600-3699 CALIFORNIA ST | F | F | - | F | 3570000 | 3570000 | - | - | SOUTH SIDE | - | - | - | - | SPRUCE ST | SPRUCE ST | 21036 | 21036 | 37.78633078 | -122.45409055 | - | - | 1739902004000 | middleware_editor | NPRK 6AM-8AM MON WED FRI STCL | SPRUCE ST to PARKER AVE (3600 - 3699) | - | 0 / INSTALL ADDITIONAL SIGN ON 2IN ..... | - | - | - | - | - | 159625 | 1178064000000 | -122.45409055 | 37.78633078 | - | - | - | D2 | - | STREET CLEANING | REG | R30B(CA).0192 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373576160000 | CALIFORNIA ST | 3600 - 3699 CALIFORNIA ST | 3600 - 3699 CALIFORNIA ST | 3600 CALIFORNIA ST | - | PARKER AVE | PARKER AVE |
| 117983 | N/A | Point | - | - | - | - | S121246 | ARLINGTON ST: MATEO ST | - | F | F | - | F | 21856000 | 21856000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ARLINGTON ST | ARLINGTON ST | 21117 | 21117 | 37.73585745 | -122.42842923 | MATEO ST \ ARLINGTON ST | MATEO ST \ ARLINGTON ST | 1739289988000 | middleware_editor | STOP | ARLINGTON ST intersection | - | EPL #401, SEE PAINT MARK | - | - | - | - | - | 159626 | 1120780800000 | -122.42842923 | 37.73585745 | - | 1739186700000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373574180000 | MATEO ST | - | - | - | - | - | - |
| 117984 | N/A | Point | - | - | - | - | S121248 | ARLINGTON ST: ROANOKE ST | - | F | F | - | F | 21866000 | 21866000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ARLINGTON ST | ARLINGTON ST | 21119 | 21119 | 37.73502742 | -122.42969864 | ROANOKE ST \ ARLINGTON ST | ROANOKE ST \ ARLINGTON ST | 1736968548000 | middleware_editor | STOP | ARLINGTON ST intersection | - | 2 FEET WEST OF UP, SEE PAINT MARK | - | - | - | - | - | 159627 | 1120780800000 | -122.42969864 | 37.73502742 | - | 1736847900000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373574180000 | ROANOKE ST | - | - | - | - | - | - |
| 117985 | N/A | Point | - | - | - | - | S121249 | ROANOKE ST: ARLINGTON ST | - | F | F | - | F | 21866000 | 21866000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ARLINGTON ST | ARLINGTON ST | 21120 | 21120 | 37.73502742 | -122.42969864 | ROANOKE ST \ ARLINGTON ST | ROANOKE ST \ ARLINGTON ST | 1736535292000 | middleware_editor | ALL WAY | ARLINGTON ST intersection | - | - | - | - | - | - | - | 159628 | 1120780800000 | -122.42969864 | 37.73502742 | - | 1586736000000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373574180000 | ROANOKE ST | - | - | - | - | - | - |
| 117986 | N/A | Point | - | - | - | - | S121250 | ROANOKE ST: ARLINGTON ST | - | F | F | - | F | 21866000 | 21866000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ARLINGTON ST | ARLINGTON ST | 21121 | 21121 | 37.73502742 | -122.42969864 | ROANOKE ST \ ARLINGTON ST | ROANOKE ST \ ARLINGTON ST | 1716472298000 | middleware_editor | ALL WAY | ARLINGTON ST intersection | - | - | - | - | - | - | - | 159629 | 1120780800000 | -122.42969864 | 37.73502742 | - | 1586736000000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1373574180000 | ROANOKE ST | - | - | - | - | - | - |
| 117987 | N/A | Point | - | - | - | - | S121253 | ARLINGTON ST: MATEO ST | - | F | F | - | F | 21856000 | 21856000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ARLINGTON ST | ARLINGTON ST | 21123 | 21123 | 37.73585745 | -122.42842923 | MATEO ST \ ARLINGTON ST | MATEO ST \ ARLINGTON ST | 1739290017000 | middleware_editor | ALL WAY | ARLINGTON ST intersection | - | - | - | - | - | - | - | 159630 | 1120780800000 | -122.42842923 | 37.73585745 | - | 1739185200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373574180000 | MATEO ST | - | - | - | - | - | - |
| 117988 | N/A | Point | - | - | - | - | S129276 | SUTTER ST: HYDE ST | - | F | F | - | F | 25163000 | 25163000 | - | - | NORTH EAST CORNER | - | - | - | - | SUTTER ST | SUTTER ST | 22978 | 22978 | 37.78817789 | -122.41682715 | HYDE ST \ SUTTER ST | HYDE ST \ SUTTER ST | 1710539427000 | MTA | 2 HR PRK 8AM-4PM MON-SAT EXC "C" PERMITS | SUTTER ST intersection | - | IFO #1008 | - | - | - | - | - | 159631 | 1213833600000 | -122.41682715 | 37.78817789 | - | - | - | D3 | - | PARKING:RPP | REG | R32C(CA).0045 | 18X21 | SUP1 | MUNI POLE | IS | 1373576700000 | HYDE ST | - | - | - | - | - | - |
| 117989 | N/A | Point | 1 | 1 | 1 - 99 | - | S125579 | 1-99 HARNEY WAY | 1-99 HARNEY WAY | F | F | - | F | 6690000 | 6690000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | JAMESTOWN AVE | JAMESTOWN AVE | 22979 | 22979 | 37.71063294 | -122.38863389 | - | - | 1710539427000 | MTA | SOUTH US-101 KEEP RIGHT | JAMESTOWN AVE to EXECUTIVE PARK BLVD (1 - 99) | - | OVERHEAD SIGNAL POLE 150' EAST OF E..... | - | - | - | - | - | 159632 | 1158192000000 | -122.38863389 | 37.71063294 | - | - | - | D10 | - | OTHER GUIDE | GUIDE | G-S(SF).0026 | 36X48 | SUP1 | SIGNAL POLE | IS | 1373575560000 | HARNEY WAY | 1 - 99 HARNEY WAY | 1 - 99 HARNEY WAY | 1 HARNEY WAY | - | EXECUTIVE PARK BLVD | EXECUTIVE PARK BLVD |
| 117990 | N/A | Point | - | - | - | - | S125582 | WALNUT ST: JACKSON ST | - | F | F | - | F | 26955000 | 26955000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | JACKSON ST | WALNUT ST | 22981 | 22981 | 37.79060811 | -122.44918958 | WALNUT ST \ JACKSON ST | JACKSON ST \ WALNUT ST | 1710539427000 | MTA | ALL WAY | WALNUT ST intersection | - | - | - | - | - | - | - | 159633 | 1158192000000 | -122.44918958 | 37.79060811 | - | 1541030400000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1373575560000 | JACKSON ST | - | - | - | - | - | - |
| 117991 | N/A | Point | - | - | - | - | S125584 | NOE ST: 29TH ST | - | F | F | - | F | 22003000 | 22003000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | NOE ST | 29TH ST | 22982 | 22982 | 37.74343074 | -122.43110034 | 29TH ST \ NOE ST | NOE ST \ 29TH ST | 1710539427000 | MTA | ALL WAY | 29TH ST intersection | - | - | - | - | - | - | - | 159634 | 1158192000000 | -122.43110034 | 37.74343074 | - | 1591228800000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1373575560000 | NOE ST | - | - | - | - | - | - |
| 117992 | N/A | Point | - | - | - | - | S126519 | SAN JOSE AVE: NIAGARA AVE | - | F | F | - | F | 22174000 | 22174000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | NIAGARA AVE | 22983 | 22983 | 37.71948112 | -122.44756206 | NIAGARA AVE \ SAN JOSE AVE | SAN JOSE AVE \ NIAGARA AVE | 1738883007000 | middleware_editor | ALL WAY | NIAGARA AVE intersection | - | - | - | - | - | - | - | 159635 | 1168646400000 | -122.44756206 | 37.71948112 | - | 1738850700000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | MUNI POLE | IS | 1373575860000 | SAN JOSE AVE | - | - | - | - | - | - |
| 117993 | N/A | Point | - | - | - | - | S126520 | SAN JOSE AVE: NIAGARA AVE | - | F | F | - | F | 22174000 | 22174000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | NIAGARA AVE | 22984 | 22984 | 37.71948112 | -122.44756206 | NIAGARA AVE \ SAN JOSE AVE | SAN JOSE AVE \ NIAGARA AVE | 1710539427000 | MTA | ALL WAY | NIAGARA AVE intersection | - | - | - | - | - | - | - | 159636 | 1168646400000 | -122.44756206 | 37.71948112 | - | 1553472000000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575860000 | SAN JOSE AVE | - | - | - | - | - | - |
| 117994 | N/A | Point | - | - | - | - | S126522 | SAN JOSE AVE: NIAGARA AVE | - | F | F | - | F | 22174000 | 22174000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | NIAGARA AVE | 22985 | 22985 | 37.71948112 | -122.44756206 | NIAGARA AVE \ SAN JOSE AVE | SAN JOSE AVE \ NIAGARA AVE | 1710539427000 | MTA | PEDESTRIAN (SYM) XING/(45 LA-DN) | NIAGARA AVE intersection | - | - | - | - | - | - | - | 159637 | 1168646400000 | -122.44756206 | 37.71948112 | - | - | - | D11 | - | PEDESTRIAN(LA DN) | WARNING | W11-2+SW44(CA).01 | 30X30 | SUP2 | MUNI POLE | IS | 1373575860000 | SAN JOSE AVE | - | - | - | - | - | - |
| 117995 | N/A | Point | - | - | - | - | S126523 | SAN JOSE AVE: NIAGARA AVE | - | F | F | - | F | 22174000 | 22174000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | NIAGARA AVE | 22986 | 22986 | 37.71948112 | -122.44756206 | NIAGARA AVE \ SAN JOSE AVE | SAN JOSE AVE \ NIAGARA AVE | 1710539427000 | MTA | PEDESTRIAN (SYM) XING/(45 LA-DN) | NIAGARA AVE intersection | - | - | - | - | - | - | - | 159638 | 1168646400000 | -122.44756206 | 37.71948112 | - | - | - | D11 | - | PEDESTRIAN(LA DN) | WARNING | W11-2+SW44(CA).01 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373575860000 | SAN JOSE AVE | - | - | - | - | - | - |
| 117996 | N/A | Point | - | - | - | - | S126524 | SAN JOSE AVE: NIAGARA AVE | - | F | F | - | F | 22174000 | 22174000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | NIAGARA AVE | 22987 | 22987 | 37.71948112 | -122.44756206 | NIAGARA AVE \ SAN JOSE AVE | SAN JOSE AVE \ NIAGARA AVE | 1710539427000 | MTA | PEDESTRIAN (SYM) XING/(45 LA-DN) | NIAGARA AVE intersection | - | - | - | - | - | - | - | 159639 | 1168646400000 | -122.44756206 | 37.71948112 | - | - | - | D11 | - | PEDESTRIAN(LA DN) | WARNING | W11-2+SW44(CA).01 | 30X30 | SUP2 | MUNI POLE | IS | 1373575860000 | SAN JOSE AVE | - | - | - | - | - | - |
| 117997 | N/A | Point | - | - | - | - | S138002 | 3RD ST: BERRY ST | - | T | T | - | F | 23796000 | 23796000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 3RD ST | 03RD ST | 27984 | 27984 | 37.77755328 | -122.39112142 | BERRY ST \ 3RD ST | BERRY ST \ 03RD ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | 03RD ST intersection | - | - | - | - | - | - | - | 159640 | 1363737600000 | -122.39112142 | 37.77755328 | - | - | - | D6 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP1 | OVERHEAD MAST ARM | IS | 1373579400000 | BERRY ST | - | - | - | - | - | - |
| 117998 | N/A | Point | - | - | - | - | S136314 | TREAT AVE: PRECITA AVE | - | F | F | - | F | 21159000 | 21159000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | TREAT AVE | TREAT AVE | 28031 | 28031 | 37.746825 | -122.41254705 | PRECITA AVE \ TREAT AVE | PRECITA AVE \ TREAT AVE | 1740062164000 | middleware_editor | DEAD END | TREAT AVE intersection | - | - | - | - | - | - | - | 159641 | 1334016000000 | -122.41254705 | 37.746825 | - | - | - | D9 | - | OTHER WARNING | WARNING | W14-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373578920000 | PRECITA AVE | - | - | - | - | - | - |
| 117999 | N/A | Point | 1 | 1 | 600 - 699 | - | S136316 | 600-699 36TH AVE | 600-699 36TH AVE | F | F | - | F | 1792000 | 1792000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | ANZA ST | ANZA ST | 28032 | 28032 | 37.77669603 | -122.49631909 | - | - | 1711033794000 | middleware_editor | TANP PZ 7AM-5PM (H/C SYM) SCHL DAYS | ANZA ST to BALBOA ST (600 - 699) | - | OPP#614 84'S OF ANZA | - | - | - | - | - | 159642 | 1334188800000 | -122.49631909 | 37.77669603 | - | - | - | D1 | - | TOW (TANP ANY TIME) | REG | R26K(SF).0090 | 12X18 | SUP2 | 2IN IRON POST | IS | 1373578920000 | 36TH AVE | 600 - 699 36TH AVE | 600 - 699 36TH AVE | 600 36TH AVE | - | BALBOA ST | BALBOA ST |
| 118000 | N/A | Point | 1 | 1 | 600 - 699 | - | S136318 | 600-699 36TH AVE | 600-699 36TH AVE | F | F | - | F | 1792000 | 1792000 | - | - | WEST SIDE | - | - | - | - | ANZA ST | ANZA ST | 28034 | 28034 | 37.77669603 | -122.49631909 | - | - | 1711033785000 | middleware_editor | BUS STOP TANS (H/C SYM) 7AM-5PM SCHL DAYS | ANZA ST to BALBOA ST (600 - 699) | - | (RA) SIGN OPP#614 84'S OF ANZA | - | - | - | - | - | 159643 | 1334188800000 | -122.49631909 | 37.77669603 | - | - | - | D1 | - | OTHER REGULATORY | REG | R37(SF).0005 | 18X30 | SUP2 | 2IN IRON POST | IS | 1373578920000 | 36TH AVE | 600 - 699 36TH AVE | 600 - 699 36TH AVE | 600 36TH AVE | - | BALBOA ST | BALBOA ST |
| 118001 | N/A | Point | 1 | 1 | 600 - 699 | - | S136319 | 600-699 36TH AVE | 600-699 36TH AVE | F | F | - | F | 1792000 | 1792000 | - | - | WEST SIDE | - | - | - | - | ANZA ST | ANZA ST | 28035 | 28035 | 37.77669603 | -122.49631909 | - | - | 1711033798000 | middleware_editor | BUS STOP TANS (H/C SYM) 7AM-5PM SCHL DAYS | ANZA ST to BALBOA ST (600 - 699) | - | (LA) SIGN OPP#618 122'S OF ANZA | - | - | - | - | - | 159644 | 1334188800000 | -122.49631909 | 37.77669603 | - | - | - | D1 | - | OTHER REGULATORY | REG | R37(SF).0005 | 18X30 | SUP2 | 2IN IRON POST | IS | 1373578920000 | 36TH AVE | 600 - 699 36TH AVE | 600 - 699 36TH AVE | 600 36TH AVE | - | BALBOA ST | BALBOA ST |
| 118002 | N/A | Point | - | 1 | 100 - 199 | - | S136321 | 100-199 PATTERSON ST | 100-199 PATTERSON ST | F | F | - | F | 10304000 | 10304000 | - | - | WEST SIDE | - | - | - | - | OAKDALE AVE | OAKDALE AVE | 28037 | 28037 | 37.74256959 | -122.40501028 | - | - | 1710539427000 | MTA | NPRK 7AM-5PM MON-FRI | OAKDALE AVE to FLOWER ST (100 - 199) | - | 96N / INSTALL(LA)SIGN AND 2IN POST ..... | - | - | - | - | - | 159645 | 1334534400000 | -122.40501028 | 37.74256959 | - | - | - | D10 | - | PARKING | REG | R30(CA).0026 | 12X18 | SUP1 | 2IN IRON POST | IS | 1373578920000 | PATTERSON ST | 100 - 199 PATTERSON ST | 100 - 199 PATTERSON ST | 100 PATTERSON ST | - | FLOWER ST | FLOWER ST |
| 118003 | N/A | Point | 1 | 1 | 600 - 699 | - | S122757 | 600-699 SAN BRUNO AVE | 600-699 SAN BRUNO AVE | F | F | - | F | 11356000 | 11356000 | - | - | WEST SIDE | - | - | - | - | 18TH ST | 18TH ST | 21144 | 21144 | 37.76142323 | -122.40515856 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | 18TH ST to 19TH ST (600 - 699) | - | C-LINE OF 18TH ST | - | - | - | - | - | 159646 | 1140134400000 | -122.40515856 | 37.76142323 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373574660000 | SAN BRUNO AVE | 600 - 699 SAN BRUNO AVE | 600 - 699 SAN BRUNO AVE | 600 SAN BRUNO AVE | - | 19TH ST | 19TH ST |
| 118004 | N/A | Point | - | - | - | - | S122990 | MISSISSIPPI ST: 7TH ST \ 16TH | - | F | F | - | F | 23785000 | 23785000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 07TH ST \ MISSISSIPPI ST | 07TH ST \ MISSISSIPPI ST | 21145 | 21145 | 37.76654458 | -122.39506055 | 16TH ST \ 07TH ST \ MISSISSIPPI ST | 16TH ST \ 07TH ST \ MISSISSIPPI ST | 1710979678000 | middleware_editor | RAILROAD TRACK ADVANCE WARNING CROSS BUCK (SYM) | 07TH ST \ MISSISSIPPI ST intersection | - | 10'WEST OF CROSSWALK | - | - | - | - | - | 159647 | 1142467200000 | -122.39506055 | 37.76654458 | - | - | - | D10 | - | OTHER WARNING | WARNING | W47(CA).0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373574780000 | 16TH ST | - | - | - | - | - | - |
| 118005 | N/A | Point | - | - | - | - | S122991 | 3RD ST: 16TH ST | - | T | T | - | F | 23578000 | 23578000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 16TH ST | 03RD ST | 21146 | 21146 | 37.7667837815948 | -122.389255017037 | 03RD ST \ 16TH ST | 16TH ST \ 03RD ST | 1738857186000 | middleware_editor | 16TH ST | 03RD ST intersection | - | - | - | - | - | - | - | 159648 | 1142553600000 | -122.3890991 | 37.76690348 | - | 1669766400000 | - | D6 | - | STREET NAME | GUIDE | D3-2.0013 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1373574780000 | 16TH ST | - | - | - | - | - | - |
| 118006 | N/A | Point | - | - | - | - | S122992 | 16TH ST: 3RD ST | - | F | F | - | F | 23578000 | 23578000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 16TH ST | 03RD ST | 21147 | 21147 | 37.7670005833415 | -122.389339506621 | 03RD ST \ 16TH ST | 16TH ST \ 03RD ST | 1738857177000 | middleware_editor | 3RD ST | 03RD ST intersection | - | - | - | - | - | - | - | 159649 | 1142553600000 | -122.3890991 | 37.76690348 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-2.0046 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1373574780000 | 16TH ST | - | - | - | - | - | - |
| 118007 | N/A | Point | - | - | - | - | S122993 | 16TH ST: 3RD ST | - | F | F | - | F | 23578000 | 23578000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 16TH ST | 03RD ST | 21148 | 21148 | 37.7668288382449 | -122.388872802252 | 03RD ST \ 16TH ST | 16TH ST \ 03RD ST | 1738857182000 | middleware_editor | 3RD ST | 03RD ST intersection | - | - | - | - | - | - | - | 159650 | 1142553600000 | -122.3890991 | 37.76690348 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-2.0046 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1373574780000 | 16TH ST | - | - | - | - | - | - |
| 118008 | N/A | Point | - | - | - | - | S122994 | UNION ST: BRODERICK ST | - | F | F | - | F | 26879000 | 26879000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BRODERICK ST | BRODERICK ST | 21149 | 21149 | 37.79603648 | -122.44376132 | UNION ST \ BRODERICK ST | UNION ST \ BRODERICK ST | 1710539427000 | MTA | ALL WAY | BRODERICK ST intersection | - | - | - | - | - | - | - | 159651 | 1142553600000 | -122.44376132 | 37.79603648 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574780000 | UNION ST | - | - | - | - | - | - |
| 118009 | N/A | Point | - | - | - | - | S122995 | UNION ST: BRODERICK ST | - | F | F | - | F | 26879000 | 26879000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BRODERICK ST | BRODERICK ST | 21150 | 21150 | 37.79603648 | -122.44376132 | UNION ST \ BRODERICK ST | UNION ST \ BRODERICK ST | 1710539427000 | MTA | ALL WAY | BRODERICK ST intersection | - | - | - | - | - | - | - | 159652 | 1142553600000 | -122.44376132 | 37.79603648 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574780000 | UNION ST | - | - | - | - | - | - |
| 118010 | N/A | Point | - | - | - | - | S122996 | BRODERICK ST: UNION ST | - | F | F | - | F | 26879000 | 26879000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BRODERICK ST | BRODERICK ST | 21151 | 21151 | 37.79603648 | -122.44376132 | UNION ST \ BRODERICK ST | UNION ST \ BRODERICK ST | 1710539427000 | MTA | ALL WAY | BRODERICK ST intersection | - | - | - | - | - | - | - | 159653 | 1142553600000 | -122.44376132 | 37.79603648 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574780000 | UNION ST | - | - | - | - | - | - |
| 118011 | N/A | Point | - | 1 | 1 - 99 | - | S122997 | 1-99 MISSISSIPPI ST | 1-99 MISSISSIPPI ST | F | F | - | F | 9199000 | 9199000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 7TH ST \ 16TH ST | 07TH ST \ 16TH ST | 21152 | 21152 | 37.76590828 | -122.39489822 | - | - | 1729007377000 | middleware_editor | LEFT LANE MUST TURN LEFT | 07TH ST \ 16TH ST to 17TH ST (1 - 99) | - | 200'SOUTH @ PM | - | - | - | - | - | 159654 | 1142553600000 | -122.39489822 | 37.76590828 | - | - | - | D10 | - | OTHER REGULATORY | REG | R3-7.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373574780000 | MISSISSIPPI ST | 1 - 99 MISSISSIPPI ST | 1 - 99 MISSISSIPPI ST | 1 MISSISSIPPI ST | - | 17TH ST | 17TH ST |
| 118012 | N/A | Point | 1 | 1 | 1 - 55 | - | S122999 | 1-55 9TH ST | 1-55 09TH ST | F | F | - | F | 446000 | 446000 | - | - | WEST SIDE | - | - | - | - | LARKIN ST \ MARKET ST | LARKIN ST \ MARKET ST | 21154 | 21154 | 37.77710578 | -122.41580614 | - | - | 1710539427000 | MTA | TANS 3PM-7PM EXC SAT & SUN | LARKIN ST \ MARKET ST to JESSIE ST (1 - 55) | - | 100' SOUTH OF JESSIE | - | - | - | - | - | 159655 | 1142553600000 | -122.41580614 | 37.77710578 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | LIGHT POLE | IS | 1373574780000 | 09TH ST | 1 - 55 9TH ST | 1 - 55 09TH ST | 1 9TH ST | - | JESSIE ST | JESSIE ST |
| 118013 | N/A | Point | 1 | 1 | 1 - 55 | - | S123000 | 1-55 9TH ST | 1-55 09TH ST | F | F | - | F | 446000 | 446000 | - | - | EAST SIDE | - | - | - | - | LARKIN ST \ MARKET ST | LARKIN ST \ MARKET ST | 21155 | 21155 | 37.77710578 | -122.41580614 | - | - | 1710539427000 | MTA | TANS 3PM-7PM EXC SAT & SUN | LARKIN ST \ MARKET ST to JESSIE ST (1 - 55) | - | 125' NORTH OF MISSION | - | - | - | - | - | 159656 | 1142553600000 | -122.41580614 | 37.77710578 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373574780000 | 09TH ST | 1 - 55 9TH ST | 1 - 55 09TH ST | 1 9TH ST | - | JESSIE ST | JESSIE ST |
| 118014 | N/A | Point | 1 | 1 | 1 - 55 | - | S123001 | 1-55 9TH ST | 1-55 09TH ST | F | F | - | F | 446000 | 446000 | - | - | EAST SIDE | - | - | - | - | LARKIN ST \ MARKET ST | LARKIN ST \ MARKET ST | 21156 | 21156 | 37.77710578 | -122.41580614 | - | - | 1710539427000 | MTA | TANS 3PM-7PM EXC SAT & SUN | LARKIN ST \ MARKET ST to JESSIE ST (1 - 55) | - | 25' SOUTH | - | - | - | - | - | 159657 | 1142553600000 | -122.41580614 | 37.77710578 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | MUNI POLE | IS | 1373574780000 | 09TH ST | 1 - 55 9TH ST | 1 - 55 09TH ST | 1 9TH ST | - | JESSIE ST | JESSIE ST |
| 118015 | N/A | Point | - | - | - | - | S125166 | SACRAMENTO ST: STEINER ST | - | F | F | - | F | 26637000 | 26637000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | STEINER ST | 21402 | 21402 | 37.78962926 | -122.43567328 | STEINER ST \ SACRAMENTO ST | SACRAMENTO ST \ STEINER ST | 1729040191000 | middleware_editor | ALL WAY | STEINER ST intersection | - | - | - | - | - | - | - | 159658 | 1156204800000 | -122.43567328 | 37.78962926 | - | 1556582400000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1373575440000 | SACRAMENTO ST | - | - | - | - | - | - |
| 118016 | N/A | Point | 1 | 1 | 4100 - 4199 | - | S127763 | 4100-4199 NORIEGA ST | 4100-4199 NORIEGA ST | F | F | - | F | 9683000 | 9683000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 48TH AVE | 48TH AVE | 21415 | 21415 | 37.75284984 | -122.50798909 | - | - | 1727113960000 | middleware_editor | TSUNAMI EVACUATION ROUTE | 48TH AVE to GREAT HWY (4100 - 4199) | - | WPL#4117 | - | - | - | - | - | 159659 | 1183075200000 | -122.50798909 | 37.75284984 | - | 1571875200000 | - | D4 | - | OTHER GUIDE | GUIDE | G-T(SF).0034 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373576220000 | NORIEGA ST | 4100 - 4199 NORIEGA ST | 4100 - 4199 NORIEGA ST | 4100 NORIEGA ST | - | GREAT HWY | GREAT HWY |
| 118017 | N/A | Point | 1 | 1 | 4100 - 4199 | - | S127764 | 4100-4199 ORTEGA ST | 4100-4199 ORTEGA ST | F | F | - | F | 10037000 | 10037000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 48TH AVE | 48TH AVE | 21416 | 21416 | 37.75098574 | -122.50780144 | - | - | 1729299415000 | middleware_editor | TSUNAMI EVACUATION ROUTE | 48TH AVE to GREAT HWY (4100 - 4199) | - | 3`EAST OF GREAT HWY (ABOVE BIKE LANE) | - | - | - | - | - | 159660 | 1183075200000 | -122.50780144 | 37.75098574 | - | 1485388800000 | - | D4 | - | OTHER GUIDE | GUIDE | G-T(SF).0034 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373576220000 | ORTEGA ST | 4100 - 4199 ORTEGA ST | 4100 - 4199 ORTEGA ST | 4100 ORTEGA ST | - | GREAT HWY | GREAT HWY |
| 118018 | N/A | Point | 1 | 1 | 4600 - 4699 | - | S127766 | 4600-4699 IRVING ST | 4600-4699 IRVING ST | F | F | - | F | 7325000 | 7325000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 47TH AVE | 47TH AVE | 21417 | 21417 | 37.76221396 | -122.50766439 | - | - | 1711398639000 | middleware_editor | TSUNAMI EVACUATION ROUTE | 47TH AVE to 48TH AVE (4600 - 4699) | - | IFO#4631 | - | - | - | - | - | 159661 | 1183075200000 | -122.50766439 | 37.76221396 | - | - | - | D4 | - | OTHER GUIDE | GUIDE | G-T(SF).0034 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373576220000 | IRVING ST | 4600 - 4699 IRVING ST | 4600 - 4699 IRVING ST | 4600 IRVING ST | - | 48TH AVE | 48TH AVE |
| 118019 | N/A | Point | 1 | 1 | 3562 - 3599 | - | S127770 | 3562-3599 18TH ST | 3562-3599 18TH ST | F | F | - | F | 884000 | 884000 | - | - | NORTH SIDE | - | - | - | - | LINDA ST | LINDA ST | 21418 | 21418 | 37.7615914 | -122.423378 | - | - | 1732302763000 | middleware_editor | NPPZ 6PM-10:30PM MON-FR/5:30PM-10:30PM SAT & SUN | LINDA ST to GUERRERO ST (3562 - 3599) | - | IFO #3560 | - | - | - | - | - | 159662 | 1183075200000 | -122.423378 | 37.7615914 | - | - | - | D8 | - | OTHER REGULATORY | REG | R30(SF).0161 | 12X18 | SUP2 | 2IN IRON POST | IS | 1373576220000 | 18TH ST | 3562 - 3599 18TH ST | 3562 - 3599 18TH ST | 3562 18TH ST | - | GUERRERO ST | GUERRERO ST |
| 118020 | N/A | Point | - | - | - | - | S127771 | OAK ST: WEBSTER ST | - | T | T | - | F | 25900000 | 25900000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OAK ST | WEBSTER ST | 21419 | 21419 | 37.77418142 | -122.42917834 | WEBSTER ST \ OAK ST | OAK ST \ WEBSTER ST | 1710539427000 | MTA | FREEWAY RIGHT LANE (VA) | WEBSTER ST intersection | - | - | - | - | - | - | - | 159663 | 1183334400000 | -122.42917834 | 37.77418142 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-F(SF).0061 | 48X24 | SUP1 | LIGHT POLE | IS | 1373576220000 | OAK ST | - | - | - | - | - | - |
| 118021 | N/A | Point | - | - | - | - | S127391 | 41ST AVE: KIRKHAM ST | - | F | F | - | F | 27795000 | 27795000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | KIRKHAM ST | 41ST AVE | 23038 | 23038 | 37.75879397 | -122.50043603 | 41ST AVE \ KIRKHAM ST | KIRKHAM ST \ 41ST AVE | 1710539427000 | MTA | ALL WAY | 41ST AVE intersection | - | - | - | - | - | - | - | 159664 | 1176336000000 | -122.50043603 | 37.75879397 | - | 1442880000000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576100000 | KIRKHAM ST | - | - | - | - | - | - |
| 118022 | N/A | Point | - | - | - | - | S127392 | 41ST AVE: KIRKHAM ST | - | F | F | - | F | 27795000 | 27795000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | KIRKHAM ST | 41ST AVE | 23039 | 23039 | 37.75879397 | -122.50043603 | 41ST AVE \ KIRKHAM ST | KIRKHAM ST \ 41ST AVE | 1710539427000 | MTA | ALL WAY | 41ST AVE intersection | - | - | - | - | - | - | - | 159665 | 1176336000000 | -122.50043603 | 37.75879397 | - | 1397779200000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576100000 | KIRKHAM ST | - | - | - | - | - | - |
| 118023 | N/A | Point | - | - | - | - | S125587 | LYON ST: JACKSON ST | - | F | F | - | F | 26885000 | 26885000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JACKSON ST | JACKSON ST | 23042 | 23042 | 37.7909993 | -122.44611681 | LYON ST \ JACKSON ST | LYON ST \ JACKSON ST | 1751908038000 | middleware_editor | ALL WAY | JACKSON ST intersection | - | - | - | - | - | - | - | 159666 | 1158217200000 | -122.44611681 | 37.7909993 | - | 1557730800000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575560000 | LYON ST | - | - | - | - | - | - |
| 118024 | N/A | Point | - | - | - | - | S125588 | LYON ST: JACKSON ST | - | F | F | - | F | 26885000 | 26885000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | JACKSON ST | JACKSON ST | 23043 | 23043 | 37.7909993 | -122.44611681 | LYON ST \ JACKSON ST | LYON ST \ JACKSON ST | 1751907985000 | middleware_editor | ALL WAY | JACKSON ST intersection | - | - | - | - | - | - | - | 159667 | 1158217200000 | -122.44611681 | 37.7909993 | - | 1557730800000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575560000 | LYON ST | - | - | - | - | - | - |
| 118025 | N/A | Point | - | - | - | - | S125589 | JACKSON ST: LYON ST | - | F | F | - | F | 26885000 | 26885000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | JACKSON ST | JACKSON ST | 23044 | 23044 | 37.7909993 | -122.44611681 | LYON ST \ JACKSON ST | LYON ST \ JACKSON ST | 1752010605000 | middleware_editor | ALL WAY | JACKSON ST intersection | - | - | - | - | - | - | - | 159668 | 1158217200000 | -122.44611681 | 37.7909993 | - | 1752002820000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | MUNI POLE | IS | 1373575560000 | LYON ST | - | - | - | - | - | - |
| 118026 | N/A | Point | - | - | - | - | S125593 | JACKSON ST: WALNUT ST | - | F | F | - | F | 26955000 | 26955000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | JACKSON ST | WALNUT ST | 23048 | 23048 | 37.79060811 | -122.44918958 | WALNUT ST \ JACKSON ST | JACKSON ST \ WALNUT ST | 1710539427000 | MTA | ALL WAY | WALNUT ST intersection | - | - | - | - | - | - | - | 159669 | 1158192000000 | -122.44918958 | 37.79060811 | - | 1541030400000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1373575560000 | JACKSON ST | - | - | - | - | - | - |
| 118027 | N/A | Point | - | - | - | - | S125594 | JACKSON ST: WALNUT ST | - | F | F | - | F | 26955000 | 26955000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JACKSON ST | WALNUT ST | 23049 | 23049 | 37.79060811 | -122.44918958 | WALNUT ST \ JACKSON ST | JACKSON ST \ WALNUT ST | 1710539427000 | MTA | ALL WAY | WALNUT ST intersection | - | - | - | - | - | - | - | 159670 | 1158192000000 | -122.44918958 | 37.79060811 | - | 1541030400000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1373575560000 | JACKSON ST | - | - | - | - | - | - |
| 118028 | N/A | Point | - | - | - | - | S125595 | VALLEY ST: NOE ST | - | F | F | - | F | 21911000 | 21911000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VALLEY ST | VALLEY ST | 23050 | 23050 | 37.74424514 | -122.43117977 | NOE ST \ VALLEY ST | NOE ST \ VALLEY ST | 1710539427000 | MTA | ALL WAY | VALLEY ST intersection | - | - | - | - | - | - | - | 159671 | 1158192000000 | -122.43117977 | 37.74424514 | - | 1591747200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575560000 | NOE ST | - | - | - | - | - | - |
| 118029 | N/A | Point | - | - | - | - | S125596 | 30TH ST: NOE ST | - | F | F | - | F | 21953000 | 21953000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 30TH ST | NOE ST | 23051 | 23051 | 37.74183313 | -122.43088788 | NOE ST \ 30TH ST | 30TH ST \ NOE ST | 1710539427000 | MTA | ALL WAY | NOE ST intersection | - | - | - | - | - | - | - | 159672 | 1158192000000 | -122.43088788 | 37.74183313 | - | 1591660800000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1373575560000 | 30TH ST | - | - | - | - | - | - |
| 118030 | N/A | Point | - | - | - | - | S125597 | 29TH ST: NOE ST | - | F | F | - | F | 22003000 | 22003000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | NOE ST | 29TH ST | 23052 | 23052 | 37.74343074 | -122.43110034 | 29TH ST \ NOE ST | NOE ST \ 29TH ST | 1710539427000 | MTA | ALL WAY | 29TH ST intersection | - | - | - | - | - | - | - | 159673 | 1158192000000 | -122.43110034 | 37.74343074 | - | 1591574400000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575560000 | NOE ST | - | - | - | - | - | - |
| 118031 | N/A | Point | - | - | - | - | S125602 | FULTON ST: 7TH AVE | - | F | F | - | F | 27272000 | 27272000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 7TH AVE | FULTON ST | 23056 | 23056 | 37.77348874 | -122.46481167 | FULTON ST \ 7TH AVE | 07TH AVE \ FULTON ST | 1710539427000 | MTA | PARKING (VA) MUSEUM GARAGE | FULTON ST intersection | - | - | - | - | - | - | - | 159674 | 1158278400000 | -122.46481167 | 37.77348874 | - | - | - | D1 | - | PARKING | REG | G-P(SF).0059 | 24X30 | SUP2 | LIGHT POLE | IS | 1373575560000 | 07TH AVE | - | - | - | - | - | - |
| 118032 | N/A | Point | 1 | 1 | 900 - 999 | - | S125604 | 900-999 BALBOA ST | 900-999 BALBOA ST | F | T | - | F | 2654000 | 2654000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 10TH AVE | 10TH AVE | 23057 | 23057 | 37.77701467 | -122.4688268 | - | - | 1728342635000 | middleware_editor | PARKING (VA) MUSEUM GARAGE | 10TH AVE to 11TH AVE (900 - 999) | - | 20`W OF 10TH AV | - | - | - | - | - | 159675 | 1158278400000 | -122.4688268 | 37.77701467 | - | - | 1728308820000 | D1 | - | PARKING | REG | G-P(SF).0059 | 24X30 | SUP2 | MUNI POLE | RETD | 1373575560000 | BALBOA ST | 900 - 999 BALBOA ST | 900 - 999 BALBOA ST | 900 BALBOA ST | - | 11TH AVE | 11TH AVE |
| 118033 | N/A | Point | - | - | - | - | S125605 | NOE ST: 26TH ST | - | F | F | - | F | 22020000 | 22020000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | NOE ST | 26TH ST | 23058 | 23058 | 37.74822948 | -122.43155665 | 26TH ST \ NOE ST | NOE ST \ 26TH ST | 1717599554000 | middleware_editor | ALL WAY | 26TH ST intersection | - | - | - | - | - | - | - | 159676 | 1158278400000 | -122.43155665 | 37.74822948 | - | 1531353600000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1373575560000 | NOE ST | - | - | - | - | - | - |
| 118034 | N/A | Point | - | - | - | - | S128474 | SLOAT BLVD: 20TH AVE | - | F | F | - | F | 23162000 | 23162000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SLOAT BLVD | 20TH AVE | 23293 | 23293 | 37.7344981440352 | -122.476068735118 | 20TH AVE \ SLOAT BLVD | SLOAT BLVD \ 20TH AVE | 1747143105000 | middleware_editor | SCHOOL (SYM) AHEAD | 20TH AVE intersection | - | - | - | - | - | - | - | 159677 | 1197964800000 | -122.47615981 | 37.73455352 | - | 1747079760000 | - | D7 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | LIGHT POLE | IS | 1373576460000 | SLOAT BLVD | - | - | - | - | - | - |
| 118035 | N/A | Point | - | - | - | - | S129978 | STEVENSON ST: 3RD ST | - | F | F | - | F | 24639000 | 24639000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | STEVENSON ST | 03RD ST | 22363 | 22363 | 37.78702442 | -122.40302819 | 3RD ST \ STEVENSON ST | STEVENSON ST \ 03RD ST | 1710539427000 | MTA | NO PED XING-USE CROSSWALK (RA) | 03RD ST intersection | - | - | - | - | - | - | - | 159678 | 1230681600000 | -122.40302819 | 37.78702442 | - | - | - | D6 | - | PEDESTRIAN | REG | R49(CA).0006 | 36X18 | SUP1 | MUNI POLE | IS | 1373576940000 | STEVENSON ST | - | - | - | - | - | - |
| 118036 | N/A | Point | - | - | - | - | S129980 | 3RD ST: STEVENSON ST | - | F | F | - | F | 24639000 | 24639000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | STEVENSON ST | 03RD ST | 22365 | 22365 | 37.78702442 | -122.40302819 | 3RD ST \ STEVENSON ST | STEVENSON ST \ 03RD ST | 1710539427000 | MTA | NO PED XING-USE CROSSWALK (RA) | 03RD ST intersection | - | - | - | - | - | - | - | 159679 | 1230681600000 | -122.40302819 | 37.78702442 | - | 1504656000000 | - | D6 | - | PEDESTRIAN | REG | R49(CA).0006 | 36X18 | SUP1 | 2IN FLANGE POST | IS | 1373576940000 | STEVENSON ST | - | - | - | - | - | - |
| 118037 | N/A | Point | - | - | - | - | S129981 | 3RD ST: STEVENSON ST | - | F | F | - | F | 24639000 | 24639000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | STEVENSON ST | 03RD ST | 22366 | 22366 | 37.78702442 | -122.40302819 | 3RD ST \ STEVENSON ST | STEVENSON ST \ 03RD ST | 1710539427000 | MTA | NO PED XING-USE CROSSWALK (RA) | 03RD ST intersection | - | - | - | - | - | - | - | 159680 | 1230681600000 | -122.40302819 | 37.78702442 | - | - | - | D6 | - | PEDESTRIAN | REG | R49(CA).0006 | 36X18 | SUP1 | MUNI POLE | IS | 1373576940000 | STEVENSON ST | - | - | - | - | - | - |
| 118038 | N/A | Point | 1 | - | - | - | S128401 | 3000-3099 FOLSOM ST | - | F | F | - | F | 5701000 | 5701000 | - | - | WEST SIDE | - | - | - | - | - | - | 22367 | 22367 | 37.7487797 | -122.41371974 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM MON WED FRI STCL | - | - | OPP #3049 100 FT SOUTH OF 26TH ST | - | - | - | - | - | 159681 | 1196899200000 | -122.41371974 | 37.7487797 | - | 1671148800000 | 1633392000000 | D9 | - | STREET CLEANING | REG | R30B(CA).0302 | 18X18 | SUP2 | LIGHT POLE | RETD | 1373576460000 | FOLSOM ST | 3000-3099 FOLSOM ST | FOLSOM ST | - | - | - | - |
| 118039 | N/A | Point | 1 | - | - | - | S128402 | 3000-3099 FOLSOM ST | - | F | F | - | F | 5701000 | 5701000 | - | - | WEST SIDE | - | - | - | - | - | - | 22368 | 22368 | 37.7487797 | -122.41371974 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM MON WED FRI STCL | - | - | OPP #3075 | - | - | - | - | - | 159682 | 1196899200000 | -122.41371974 | 37.7487797 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0302 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373576460000 | FOLSOM ST | 3000-3099 FOLSOM ST | FOLSOM ST | - | - | - | - |
| 118040 | N/A | Point | 1 | 1 | 2000 - 2039 | - | S128403 | 2000-2039 QUESADA AVE | 2000-2039 QUESADA AVE | F | F | - | F | 10821000 | 10821000 | - | - | NORTH SIDE | - | - | - | - | QUINT ST | QUINT ST | 22369 | 22369 | 37.73669827 | -122.39737363 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM THUR STCL | QUINT ST to SILVER AVE (2000 - 2039) | - | WPL #1962 | - | - | - | - | - | 159683 | 1196899200000 | -122.39737363 | 37.73669827 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0304 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373576460000 | QUESADA AVE | 2000 - 2039 QUESADA AVE | 2000 - 2039 QUESADA AVE | 2000 QUESADA AVE | - | SILVER AVE | SILVER AVE |
| 118041 | N/A | Point | - | 1 | 2100 - 2199 | - | S128404 | 2100-2199 QUESADA AVE | 2100-2199 QUESADA AVE | F | F | - | F | 10823000 | 10823000 | - | - | NORTH SIDE | - | - | - | - | RANKIN ST | RANKIN ST | 22370 | 22370 | 37.73811872 | -122.39987519 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM THUR STCL | RANKIN ST to SELBY ST (2100 - 2199) | - | 60FT WEST | - | - | - | - | - | 159684 | 1196899200000 | -122.39987519 | 37.73811872 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0304 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373576460000 | QUESADA AVE | 2100 - 2199 QUESADA AVE | 2100 - 2199 QUESADA AVE | 2100 QUESADA AVE | - | SELBY ST | SELBY ST |
| 118042 | N/A | Point | - | - | - | - | S130997 | PIERCE ST: CALIFORNIA ST | - | F | F | - | F | 26640000 | 26640000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 22432 | 22432 | 37.78848786 | -122.4371292 | PIERCE ST \ CALIFORNIA ST | PIERCE ST \ CALIFORNIA ST | 1710539427000 | MTA | RIGHT TURN ONLY(SYM) | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 159685 | 1245715200000 | -122.4371292 | 37.78848786 | - | - | - | D2 | - | OTHER REGULATORY | REG | R3-5.0002 | 30X36 | SUP1 | 2IN IRON POST | IS | 1373577240000 | PIERCE ST | - | - | - | - | - | - |
| 118043 | N/A | Point | 1 | - | - | - | S130998 | 1300-1307 MONTGOMERY ST | - | F | F | - | F | 9315000 | 9315000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | - | - | 22433 | 22433 | 37.80121073 | -122.40446229 | - | - | 1710539427000 | MTA | TRUCKS NOT ADVISED | - | - | 60N / BELOW EXISTING "NO OUTLET" AN..... | - | - | - | - | - | 159686 | 1245715200000 | -122.40446229 | 37.80121073 | - | - | - | D3 | - | OTHER WARNING | WARNING | W(SF).0067 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373577240000 | MONTGOMERY ST | 1300-1307 MONTGOMERY ST | MONTGOMERY ST | - | - | - | - |
| 118044 | N/A | Point | - | - | - | - | S130999 | CASTENADA AVE: PACHECO ST | - | F | F | - | F | 22895000 | 22895000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PACHECO ST | CASTENADA AVE | 22434 | 22434 | 37.7477767 | -122.46233324 | CASTENADA AVE \ PACHECO ST | PACHECO ST \ CASTENADA AVE | 1710539427000 | MTA | ALL WAY | CASTENADA AVE intersection | - | - | - | - | - | - | - | 159687 | 1245801600000 | -122.46233324 | 37.7477767 | - | 1569283200000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373577240000 | PACHECO ST | - | - | - | - | - | - |
| 118045 | N/A | Point | - | - | - | - | S131000 | CASTENADA AVE: PACHECO ST | - | F | F | - | F | 22895000 | 22895000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PACHECO ST | CASTENADA AVE | 22435 | 22435 | 37.7477767 | -122.46233324 | CASTENADA AVE \ PACHECO ST | PACHECO ST \ CASTENADA AVE | 1710539427000 | MTA | ALL WAY | CASTENADA AVE intersection | - | - | - | - | - | - | - | 159688 | 1245801600000 | -122.46233324 | 37.7477767 | - | - | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373577240000 | PACHECO ST | - | - | - | - | - | - |
| 118046 | N/A | Point | - | - | - | - | S131001 | PACHECO ST: CASTENADA AVE | - | F | F | - | F | 22895000 | 22895000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PACHECO ST | CASTENADA AVE | 22436 | 22436 | 37.7477767 | -122.46233324 | CASTENADA AVE \ PACHECO ST | PACHECO ST \ CASTENADA AVE | 1710539427000 | MTA | ALL WAY | CASTENADA AVE intersection | - | - | - | - | - | - | - | 159689 | 1245801600000 | -122.46233324 | 37.7477767 | - | 1569283200000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373577240000 | PACHECO ST | - | - | - | - | - | - |
| 118047 | N/A | Point | 1 | 1 | 300 - 449 | - | S127224 | 300-449 CARL ST | 300-449 CARL ST | F | F | - | F | 3698000 | 3698000 | - | - | SOUTH SIDE | - | - | - | - | WILLARD ST | WILLARD ST | 23680 | 23680 | 37.7650827 | -122.45558152 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM MON STCL | WILLARD ST to HILLWAY AVE (300 - 449) | - | IFO#357 | - | - | - | - | - | 159690 | 1174867200000 | -122.45558152 | 37.7650827 | - | - | - | D5 | - | STREET CLEANING | REG | R30B(CA).0261 | 18X18 | SUP1 | LIGHT POLE | IS | 1373576040000 | CARL ST | 300 - 449 CARL ST | 300 - 449 CARL ST | 300 CARL ST | - | HILLWAY AVE | HILLWAY AVE |
| 118048 | N/A | Point | 1 | 1 | 300 - 449 | - | S127225 | 300-449 CARL ST | 300-449 CARL ST | F | F | - | F | 3698000 | 3698000 | - | - | SOUTH SIDE | - | - | - | - | WILLARD ST | WILLARD ST | 23681 | 23681 | 37.7650827 | -122.45558152 | - | - | 1743774380000 | middleware_editor | NPRK 8AM-10AM MON STCL | WILLARD ST to HILLWAY AVE (300 - 449) | - | IFO#449 | - | - | - | - | - | 159691 | 1174892400000 | -122.45558152 | 37.7650827 | - | - | - | D5 | - | STREET CLEANING | REG | R30B(CA).0261 | 18X18 | SUP1 | LIGHT POLE | IS | 1373576040000 | CARL ST | 300 - 449 CARL ST | 300 - 449 CARL ST | 300 CARL ST | - | HILLWAY AVE | HILLWAY AVE |
| 118049 | N/A | Point | 1 | 1 | 1500 - 1599 | DOWN ARROW | S129525 | 1500-1599 OAKDALE AVE | 1500-1599 OAKDALE AVE | F | F | - | F | 9786000 | 9786000 | - | - | NORTH SIDE | - | - | - | - | LANE ST | LANE ST | 23682 | 23682 | 37.73406634 | -122.38941327 | - | - | 1728521808000 | middleware_editor | BUS STOP TANS 9AM-2PM SCHL DAYS | LANE ST to MENDELL ST (1500 - 1599) | - | 388FT WEST | - | - | - | - | - | 159692 | 1218499200000 | -122.38941327 | 37.73406634 | - | 1651104000000 | - | D10 | - | OTHER REGULATORY | REG | R37(SF).0056 | 18X30 | SUP1 | 2IN IRON POST | IS | 1373576760000 | OAKDALE AVE | 1500 - 1599 OAKDALE AVE | 1500 - 1599 OAKDALE AVE | 1500 OAKDALE AVE | - | MENDELL ST | MENDELL ST |
| 118050 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S129527 | 1500-1599 OAKDALE AVE | 1500-1599 OAKDALE AVE | F | F | - | F | 9786000 | 9786000 | - | - | NORTH SIDE | - | - | - | - | LANE ST | LANE ST | 23684 | 23684 | 37.73406634 | -122.38941327 | - | - | 1728521808000 | middleware_editor | BUS STOP TANS 7AM-6PM SCHL DAYS | LANE ST to MENDELL ST (1500 - 1599) | - | 58 FT WEST | - | - | - | - | - | 159693 | 1218585600000 | -122.38941327 | 37.73406634 | - | - | - | D10 | - | OTHER REGULATORY | REG | R37(SF).0040 | 18X30 | SUP1 | 2IN IRON POST | IS | 1373576760000 | OAKDALE AVE | 1500 - 1599 OAKDALE AVE | 1500 - 1599 OAKDALE AVE | 1500 OAKDALE AVE | - | MENDELL ST | MENDELL 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