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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109576 | N/A | Point | - | - | - | - | S211963 | MARKET ST: 17TH ST \ CASTRO ST | - | F | F | - | F | 25814000 | 25814000 | R3-2.0001-2015-01-05 15:11:00-37.76267071--122.43518796 | - | SOUTH EAST CORNER | - | - | - | - | CASTRO ST \ MARKET ST | 17TH ST \ CASTRO ST | 52542 | 52542 | 37.76267071 | -122.43518796 | 17TH ST \ CASTRO ST \ MARKET ST | MARKET ST \ 17TH ST \ CASTRO ST | 1725931541000 | middleware_editor | NO LEFT TURN (SYM) | 17TH ST \ CASTRO ST intersection | - | RELOCATE ONTO NEW 2IN POST | - | - | - | - | - | 126884 | 1420470660000 | -122.43518796 | 37.76267071 | - | 1420416000000 | - | D8 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1418910300000 | MARKET ST | - | - | - | - | - | - |
| 109577 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S214074 | 2200-2299 MARIPOSA ST | 2200-2299 MARIPOSA ST | F | F | - | F | 8728000 | 8728000 | W1-6.0004-None-37.76327832--122.40593604 | - | EAST SIDE, EASTBOUND TRAFFIC | - | - | - | - | SAN BRUNO AVE | SAN BRUNO AVE | 52650 | 52650 | 37.76327832 | -122.40593604 | - | - | 1710539427000 | MTA | RIGHT ARROW (SYM) | SAN BRUNO AVE to UTAH ST (2200 - 2299) | - | CENTER LINE END OF MARIPOSA | - | - | - | - | - | 126885 | - | -122.40593604 | 37.76327832 | - | - | - | D10 | - | OTHER WARNING | WARNING | W1-6.0004 | 36X18 | SUP1 | 3IN IRON POST | IS | 1425649860000 | MARIPOSA ST | 2200 - 2299 MARIPOSA ST | 2200 - 2299 MARIPOSA ST | 2200 MARIPOSA ST | - | UTAH ST | UTAH ST |
| 109578 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S213013 | 1100-1199 FILBERT ST | 1100-1199 FILBERT ST | F | F | - | F | 5511000 | 5511000 | SW(SF).0007-2015-02-06 14:48:00-37.80023737--122.41840996 | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | LEAVENWORTH ST | LEAVENWORTH ST | 52680 | 52680 | 37.80023737 | -122.41840996 | - | - | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | LEAVENWORTH ST to HYDE ST (1100 - 1199) | - | ABOVE"NPAT(LA)" SIGN IFO#1181 FILBERT ST | - | - | - | - | - | 126886 | 1423234080000 | -122.41840996 | 37.80023737 | - | 1423180800000 | - | D2 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP1 | 2IN IRON POST | IS | 1422515580000 | FILBERT ST | 1100 - 1199 FILBERT ST | 1100 - 1199 FILBERT ST | 1100 FILBERT ST | - | HYDE ST | HYDE ST |
| 109579 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S213014 | 1100-1199 FILBERT ST | 1100-1199 FILBERT ST | F | F | - | F | 5511000 | 5511000 | SW(SF).0007-2015-02-10 07:06:00-37.80023737--122.41840996 | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | LEAVENWORTH ST | LEAVENWORTH ST | 52681 | 52681 | 37.80023737 | -122.41840996 | - | - | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | LEAVENWORTH ST to HYDE ST (1100 - 1199) | - | IFO#1100 ABOVE AREA A PERMIT SIGN | - | - | - | - | - | 126887 | 1423551960000 | -122.41840996 | 37.80023737 | - | 1423526400000 | - | D2 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP1 | 2IN IRON POST | IS | 1422516600000 | FILBERT ST | 1100 - 1199 FILBERT ST | 1100 - 1199 FILBERT ST | 1100 FILBERT ST | - | HYDE ST | HYDE ST |
| 109580 | N/A | Point | - | - | - | - | S214450 | MARKET ST: 17TH ST \ CASTRO ST | - | F | F | - | F | 25814000 | 25814000 | R61(SF).0143-2015-04-08 15:33:00-37.76267071--122.43518796 | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CASTRO ST \ MARKET ST | 17TH ST \ CASTRO ST | 52703 | 52703 | 37.76267071 | -122.43518796 | 17TH ST \ CASTRO ST \ MARKET ST | MARKET ST \ 17TH ST \ CASTRO ST | 1725931544000 | middleware_editor | (LA)ONLY(VA)ONLY(VA-RA)MARKET 17TH | 17TH ST \ CASTRO ST intersection | - | - | - | - | - | - | - | 126888 | 1428507180000 | -122.43518796 | 37.76267071 | - | 1428451200000 | - | D8 | - | OTHER REGULATORY | REG | R61(SF).0143 | 36X30 | SUP2 | OVERHEAD MAST ARM | IS | 1427182860000 | MARKET ST | - | - | - | - | - | - |
| 109581 | N/A | Point | 1 | 1 | 1 - 34 | - | S213603 | 1-34 7TH ST | 1-34 07TH ST | F | F | - | F | 365000 | 365000 | TYPE-DL.0001-2015-02-19 08:51:00-37.78024219--122.41222283 | - | EAST SIDE | - | - | - | - | CHARLES J BRENHAM PL \ MARKET ST | CHARLES J BRENHAM PL \ MARKET ST | 52748 | 52748 | 37.78024219 | -122.41222283 | - | - | 1750966194000 | middleware_editor | FG 300 UR DELINEATOR (W) | CHARLES J BRENHAM PL \ MARKET ST to ODD FELLOWS WAY \ STEVENSON ST (1 - 34) | - | START 50'S OF STEVENSON/ (10) EVERY 20FT OC | - | - | - | - | 10 | 126889 | 1424364660000 | -122.41222283 | 37.78024219 | - | 1748889000000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1424259060000 | 07TH ST | 1 - 34 7TH ST | 1 - 34 07TH ST | 1 7TH ST | - | ODD FELLOWS WAY \ STEVENSON ST | ODD FELLOWS WAY \ STEVENSON ST |
| 109582 | N/A | Point | 1 | 1 | 1 - 99 | - | S225679 | 1-99 HEARST AVE | 1-99 HEARST AVE | F | F | - | F | 6861000 | 6861000 | TYPE-K(CA).0001-2009-10-20 00:00:00-37.73073545--122.43921514 | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | CIRCULAR AVE | CIRCULAR AVE | 62511 | 62511 | 37.73073545 | -122.43921514 | - | - | 1736801682000 | middleware_editor | TYPE K | CIRCULAR AVE to BADEN ST (1 - 99) | - | W-TIP OF ISLAND | - | - | - | - | - | 126890 | 1255996800000 | -122.43921514 | 37.73073545 | - | 1513209600000 | - | D7 | - | OTHER WARNING | WARNING | TYPE-K(CA).0001 | 05X12 | SUP2 | 2IN IRON POST | IS | 1463474880000 | HEARST AVE | 1 - 99 HEARST AVE | 1 - 99 HEARST AVE | 1 HEARST AVE | - | BADEN ST | BADEN ST |
| 109583 | N/A | Point | - | - | - | - | S225588 | JENNINGS ST: CARGO WAY | - | F | F | - | F | 33104000 | 33104000 | R26K(CA).0042-1979-07-17 00:00:00-37.74019197--122.37684734 | - | NORTH WEST CORNER | - | - | - | - | JENNINGS ST | CARGO WAY | 62705 | 62705 | 37.74019197 | -122.37684734 | CARGO WAY \ JENNINGS ST | JENNINGS ST \ CARGO WAY | 1710539427000 | MTA | TANP ANY TIME (LA) | CARGO WAY intersection | - | BELOW STOP SIGN | - | - | - | - | - | 126891 | 301017600000 | -122.37684734 | 37.74019197 | - | 1463097600000 | - | D10 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0042 | 18X21 | SUP1 | 2IN IRON POST | IS | 1463053560000 | JENNINGS ST | - | - | - | - | - | - |
| 109584 | N/A | Point | - | - | - | - | S226165 | BRENTWOOD AVE: COLON AVE | - | F | F | - | F | 22801000 | 22801000 | D3-1.0251-2016-06-29 11:20:00-37.73388285--122.45822976 | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | COLON AVE | COLON AVE | 62988 | 62988 | 37.73388285 | -122.45822976 | BRENTWOOD AVE \ COLON AVE | BRENTWOOD AVE \ COLON AVE | 1710539427000 | MTA | BRET HARTE TER | COLON AVE intersection | - | 1OF3 | - | - | - | - | - | 126892 | 1467199200000 | -122.45822976 | 37.73388285 | - | 1467158400000 | - | D7 | - | STREET NAME | GUIDE | D3-1.0251 | 36X08 | SUP2 | 3IN IRON POST | IS | 1464869460000 | BRENTWOOD AVE | - | - | - | - | - | - |
| 109585 | N/A | Point | - | - | - | - | S226168 | COLON AVE: BRENTWOOD AVE | - | F | F | - | F | 22801000 | 22801000 | D3-1.0417-2016-06-29 11:21:00-37.73388285--122.45822976 | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | COLON AVE | COLON AVE | 62989 | 62989 | 37.73388285 | -122.45822976 | BRENTWOOD AVE \ COLON AVE | BRENTWOOD AVE \ COLON AVE | 1710539427000 | MTA | COLON AVE | COLON AVE intersection | - | 2OF3 (X ST IS COLON) | - | - | - | - | - | 126893 | 1467199260000 | -122.45822976 | 37.73388285 | - | 1467158400000 | - | D7 | - | STREET NAME | GUIDE | D3-1.0417 | 36X08 | SUP2 | 3IN IRON POST | IS | 1464869820000 | BRENTWOOD AVE | - | - | - | - | - | - |
| 109586 | N/A | Point | 1 | 1 | 4300 - 4399 | - | S225146 | 4300-4399 17TH ST | 4300-4399 17TH ST | F | F | - | F | 816000 | 816000 | R32C(CA).0126-None-37.76210502--122.44153816 | - | SOUTH SIDE | - | - | - | - | ORD ST | ORD ST | 63150 | 63150 | 37.76210502 | -122.44153816 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | ORD ST to CORBIN PL (4300 - 4399) | - | IFO#4305 | - | - | - | - | - | 126894 | - | -122.44153816 | 37.76210502 | - | - | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | 2 POST ALUMINUM | IS | 1461687000000 | 17TH ST | 4300 - 4399 17TH ST | 4300 - 4399 17TH ST | 4300 17TH ST | - | CORBIN PL | CORBIN PL |
| 109587 | N/A | Point | 1 | 1 | 1900 - 1999 | - | S223407 | 1900-1999 26TH ST | 1900-1999 26TH ST | F | F | - | F | 1504000 | 1504000 | W1-7.0001-None-37.75099706--122.39909962 | - | SOUTH SIDE | - | - | - | - | WISCONSIN ST | WISCONSIN ST | 63327 | 63327 | 37.75099706 | -122.39909962 | - | - | 1710539427000 | MTA | DOUBLE ARROW-LEFT & RIGHT (SYM) | WISCONSIN ST to BLAIR TER (1900 - 1999) | - | CENTER END LINE OF WISCONSIN | - | - | - | - | - | 126895 | - | -122.39909962 | 37.75099706 | - | - | - | D10 | - | OTHER WARNING | WARNING | W1-7.0001 | 36X18 | SUP1 | 2IN IRON POST | IS | 1455282360000 | 26TH ST | 1900 - 1999 26TH ST | 1900 - 1999 26TH ST | 1900 26TH ST | - | BLAIR TER | BLAIR TER |
| 109588 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S227903 | 2500-2599 MISSION ST | 2500-2599 MISSION ST | F | F | - | F | 9123000 | 9123000 | R30B(CA).0137-2009-09-17 00:00:00-37.75623617--122.4188243 | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 21ST ST | 21ST ST | 63358 | 63358 | 37.75623617 | -122.4188243 | - | - | 1710539427000 | MTA | NPRK 4AM-6AM EVERYDAY INCL HOLIDAY STCL | 21ST ST to 22ND ST (2500 - 2599) | - | 20' SOUTH OF 21ST ST | - | - | - | - | - | 126896 | 1253145600000 | -122.4188243 | 37.75623617 | - | 1470873600000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0137 | 18X18 | SUP2 | LIGHT POLE | IS | 1470816120000 | MISSION ST | 2500 - 2599 MISSION ST | 2500 - 2599 MISSION ST | 2500 MISSION ST | - | 22ND ST | 22ND ST |
| 109589 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S227905 | 2500-2599 MISSION ST | 2500-2599 MISSION ST | F | F | - | F | 9123000 | 9123000 | R30B(CA).0137-2009-09-17 00:00:00-37.75623617--122.4188243 | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 21ST ST | 21ST ST | 63359 | 63359 | 37.75623617 | -122.4188243 | - | - | 1710539427000 | MTA | NPRK 4AM-6AM EVERYDAY INCL HOLIDAY STCL | 21ST ST to 22ND ST (2500 - 2599) | - | IFO# 2568 | - | - | - | - | - | 126897 | 1253145600000 | -122.4188243 | 37.75623617 | - | 1471305600000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0137 | 18X18 | SUP2 | LIGHT POLE | IS | 1470818280000 | MISSION ST | 2500 - 2599 MISSION ST | 2500 - 2599 MISSION ST | 2500 MISSION ST | - | 22ND ST | 22ND ST |
| 109590 | N/A | Point | - | - | - | - | S225087 | FOLSOM ST: ESSEX ST | - | F | F | - | F | 24524000 | 24524000 | TYPE-DL.0011-2017-01-24 14:56:00-37.78637894--122.39564547 | - | CENTER ISLAND | - | - | - | - | FOLSOM ST | FOLSOM ST | 63443 | 63443 | 37.78637894 | -122.39564547 | ESSEX ST \ FOLSOM ST | ESSEX ST \ FOLSOM ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | FOLSOM ST intersection | - | 10 DELINETAORS/CENTER LINE OF ESSEX | - | - | - | - | - | 126898 | 1485269760000 | -122.39564547 | 37.78637894 | - | 1485216000000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1461593760000 | ESSEX ST | - | - | - | - | - | - |
| 109591 | N/A | Point | - | - | - | - | S223257 | BUSH ST: SANSOME ST | - | T | T | - | F | 24679000 | 24679000 | R10-7.0001-2016-05-16 10:13:00-37.79117717--122.40074402 | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BUSH ST | BUSH ST | 63696 | 63696 | 37.79117717 | -122.40074402 | SANSOME ST \ BUSH ST | SANSOME ST \ BUSH ST | 1731437193000 | middleware_editor | DO NOT BLOCK INTERSECTION | BUSH ST intersection | - | - | - | - | - | - | - | 126899 | 1463393580000 | -122.40074402 | 37.79117717 | - | 1463356800000 | - | D3 | - | OTHER REGULATORY | REG | R10-7.0001 | 24X30 | SUP1 | LIGHT POLE | IS | 1455012120000 | SANSOME ST | - | - | - | - | - | - |
| 109592 | N/A | Point | 1 | 1 | 4300 - 4399 | - | S225421 | 4300-4399 JUDAH ST | 4300-4399 JUDAH ST | F | F | - | F | 7685000 | 7685000 | M5-1.0003-2007-06-21 00:00:00-37.76030607--122.50860439 | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 48TH AVE | 48TH AVE | 63733 | 63733 | 37.76030607 | -122.50860439 | - | - | 1710539427000 | MTA | VA (WHITE ON BLUE) TSUNAMI | 48TH AVE to LA PLAYA (4300 - 4399) | - | IFO#4323 | - | - | - | - | - | 126900 | 1182384000000 | -122.50860439 | 37.76030607 | - | - | - | D4 | - | OTHER GUIDE | GUIDE | M5-1.0003 | 21X15 | SUP2 | MUNI POLE | IS | 1462451760000 | JUDAH ST | 4300 - 4399 JUDAH ST | 4300 - 4399 JUDAH ST | 4300 JUDAH ST | - | LA PLAYA | LA PLAYA |
| 109593 | N/A | Point | - | - | - | - | S225754 | FOLSOM ST: ESSEX ST | - | T | T | - | F | 24524000 | 24524000 | R13A(SF).0006-2016-05-19 10:23:00-37.78637894--122.39564547 | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | FOLSOM ST | 64005 | 64005 | 37.78637894 | -122.39564547 | ESSEX ST \ FOLSOM ST | ESSEX ST \ FOLSOM ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED ARROW | FOLSOM ST intersection | - | INSTALL TO SIGNAL ON OVERHEAD MAST ARM | - | - | - | - | - | 126901 | 1463653380000 | -122.39564547 | 37.78637894 | - | 1463616000000 | - | D6 | - | NO RIGHT TURN | REG | R13A(SF).0006 | 24X30 | SUP1 | OVERHEAD MAST ARM | IS | 1463567640000 | ESSEX ST | - | - | - | - | - | - |
| 109594 | N/A | Point | - | - | - | - | S225755 | FOLSOM ST: ESSEX ST | - | T | T | - | F | 24524000 | 24524000 | R13A(SF).0006-2016-05-19 10:26:00-37.78637894--122.39564547 | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | FOLSOM ST | 64006 | 64006 | 37.78637894 | -122.39564547 | ESSEX ST \ FOLSOM ST | ESSEX ST \ FOLSOM ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED ARROW | FOLSOM ST intersection | - | SEE NOTES | - | - | - | - | - | 126902 | 1463653560000 | -122.39564547 | 37.78637894 | - | 1463616000000 | - | D6 | - | NO RIGHT TURN | REG | R13A(SF).0006 | 24X30 | SUP1 | OVERHEAD MAST ARM | IS | 1463567940000 | ESSEX ST | - | - | - | - | - | - |
| 109595 | N/A | Point | - | - | - | - | S224659 | JACKSON ST: STOCKTON ST | - | F | F | - | F | 25027000 | 25027000 | R62(SF).0002-2002-06-13 00:00:00-37.79582371--122.4082532 | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | JACKSON ST | JACKSON ST | 64029 | 64029 | 37.79582371 | -122.4082532 | STOCKTON ST \ JACKSON ST | STOCKTON ST \ JACKSON ST | 1710539427000 | MTA | START CROSSING ONLY ON (PED SYM)SIGNAL/CHINESE SAME MESSAGE | JACKSON ST intersection | - | ABOVE PED SIGNAL FOR WB PED TRAFFIC | - | - | - | - | - | 126903 | 1023926400000 | -122.4082532 | 37.79582371 | - | - | - | D3 | - | PEDESTRIAN | REG | R62(SF).0002 | 24X18 | SUP1 | LIGHT POLE | IS | 1460111340000 | STOCKTON ST | - | - | - | - | - | - |
| 109596 | N/A | Point | 1 | 1 | 4005 - 4099 | - | S229008 | 4005-4099 20TH ST | 4005-4099 20TH ST | F | F | - | F | 1064000 | 1064000 | R30B(CA).0298-2016-09-26 11:55:00-37.75777804--122.43166676 | - | NORTH SIDE | - | - | - | - | 20TH ST | 20TH ST | 64155 | 64155 | 37.75777804 | -122.43166676 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | 20TH ST to NOE ST (4005 - 4099) | - | 50FT. EAST OF NOE ST. | - | - | - | - | - | 126904 | 1474890900000 | -122.43166676 | 37.75777804 | - | 1474848000000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP2 | 2IN IRON POST | IS | 1474295580000 | 20TH ST | 4005 - 4099 20TH ST | 4005 - 4099 20TH ST | 4005 20TH ST | - | NOE ST | NOE ST |
| 109597 | N/A | Point | - | - | - | - | S223269 | BEVERLY ST: GARFIELD ST | - | F | F | - | F | - | 22728000 | R2-1.0005-None-37.7196402--122.47165211 | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | GARFIELD ST | GARFIELD ST | 64210 | 64210 | 37.7196402 | -122.47165211 | BEVERLY ST \ GARFIELD ST | BEVERLY ST \ GARFIELD ST | 1728523021000 | middleware_editor | SPEED LIMIT 25 | GARFIELD ST intersection | - | 20`NORTH OF 19TH AVE | - | - | - | - | - | 126905 | - | -122.47165211 | 37.7196402 | - | - | - | D11 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP2 | 2IN IRON POST | IS | 1455013380000 | BEVERLY ST | - | - | - | - | - | - |
| 109598 | N/A | Point | - | - | - | - | S247376 | CALIFORNIA ST: LOCUST ST | - | F | F | - | F | 26938000 | 26938000 | D3-1.1950-2019-03-29 15:08:00-37.78661956--122.45175796 | - | NORTH WEST CORNER | - | - | - | - | LOCUST ST | CALIFORNIA ST | 76929 | 76929 | 37.78661956 | -122.45175796 | CALIFORNIA ST \ LOCUST ST | LOCUST ST \ CALIFORNIA ST | 1710539427000 | MTA | LOCUST ST | CALIFORNIA ST intersection | - | (END) | - | - | - | - | - | 126906 | 1553872080000 | -122.45175796 | 37.78661956 | - | - | - | D2 | - | STREET NAME | GUIDE | D3-1.1950 | 36X08 | SUP1 | SIGNAL POLE | IS | 1532946360000 | LOCUST ST | - | - | - | - | - | - |
| 109599 | N/A | Point | 1 | 1 | 3500 - 3599 | - | S247380 | 3500-3599 CALIFORNIA ST | 3500-3599 CALIFORNIA ST | F | F | - | F | 3569000 | 3569000 | R(SF).0335-None-37.78651654--122.45258195 | - | SOUTH SIDE | - | - | - | - | LOCUST ST | LOCUST ST | 76932 | 76932 | 37.78651654 | -122.45258195 | - | - | 1710539427000 | MTA | MUNI LANDOR FLAG - TYPE 2 | LOCUST ST to SPRUCE ST (3500 - 3599) | - | 68' E 0F SPRUCE | - | - | - | - | - | 126907 | - | -122.45258195 | 37.78651654 | - | - | - | D2 | - | OTHER REGULATORY | REG | R(SF).0335 | 15X25 | SUP1 | MUNI LANDOR POLE 3" X121" | IS | 1532948280000 | CALIFORNIA ST | 3500 - 3599 CALIFORNIA ST | 3500 - 3599 CALIFORNIA ST | 3500 CALIFORNIA ST | - | SPRUCE ST | SPRUCE ST |
| 109600 | N/A | Point | 1 | 1 | 2100 - 2199 | - | S147524 | 2100-2199 15TH AVE | 2100-2199 15TH AVE | F | F | - | F | 625000 | 625000 | R30B(CA).0068-2008-10-16 00:00:00-37.74790362--122.47168439 | - | EAST SIDE | - | - | - | - | FANNING WAY \ QUINTARA ST | FANNING WAY \ QUINTARA ST | 77386 | 77386 | 37.74790362 | -122.47168439 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM 1ST & 3RD TUE OF MONTH STCL | FANNING WAY \ QUINTARA ST to RIVERA ST (2100 - 2199) | - | 2372 15TH AVE | - | - | - | - | - | 126908 | 1224115200000 | -122.47168439 | 37.74790362 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0068 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375728480000 | 15TH AVE | 2100 - 2199 15TH AVE | 2100 - 2199 15TH AVE | 2100 15TH AVE | - | RIVERA ST | RIVERA ST |
| 109601 | N/A | Point | - | - | - | - | S234997 | HOWARD ST: 8TH ST | - | F | F | - | F | 24299000 | 24299000 | D3-1.0871-2017-07-25 08:58:00-37.77622136--122.41160611 | - | NORTH EAST CORNER | - | - | - | - | 8TH ST | 08TH ST | 77441 | 77441 | 37.77622136 | -122.41160611 | HOWARD ST \ 8TH ST | HOWARD ST \ 08TH ST | 1710539427000 | MTA | HOWARD ST | 08TH ST intersection | - | HOWARD (1200) | - | - | - | - | - | 126909 | 1500973080000 | -122.41160611 | 37.77622136 | - | 1500940800000 | - | D6 | - | STREET NAME | GUIDE | D3-1.0871 | 36X08 | SUP1 | LIGHT POLE | IS | 1491562680000 | HOWARD ST | - | - | - | - | - | - |
| 109602 | N/A | Point | 1 | 1 | 3300 - 3399 | - | S149968 | 3300-3399 ORTEGA ST | 3300-3399 ORTEGA ST | F | F | - | F | 10029000 | 10029000 | R30B(CA).0094-2008-12-02 00:00:00-37.75135746--122.49937835 | - | SOUTH SIDE | - | - | - | - | 40TH AVE | 40TH AVE | 77499 | 77499 | 37.75135746 | -122.49937835 | - | - | 1750802180000 | middleware_editor | NPRK 1PM-3PM 1ST & 3RD MON OF MONTH STCL | 40TH AVE to 41ST AVE (3300 - 3399) | - | 155 FEET EAST OF 41ST AVE | - | - | - | - | - | 126910 | 1228204800000 | -122.49937835 | 37.75135746 | - | 1715974620000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0094 | 18X18 | SUP2 | LIGHT POLE | IS | 1375729500000 | ORTEGA ST | 3300 - 3399 ORTEGA ST | 3300 - 3399 ORTEGA ST | 3300 ORTEGA ST | - | 41ST AVE | 41ST AVE |
| 109603 | N/A | Point | 1 | 1 | 2900 - 2999 | - | S139526 | 2900-2999 VALLEJO ST | 2900-2999 VALLEJO ST | F | F | - | F | 13123000 | 13123000 | R30B(CA).0065-2008-08-29 00:00:00-37.79386393--122.44581161 | - | NORTH SIDE | - | - | - | - | BAKER ST | BAKER ST | 77522 | 77522 | 37.79386393 | -122.44581161 | - | - | 1721761922000 | middleware_editor | NPRK 12NN-2PM 1ST & 3RD FRI OF MONTH STCL | BAKER ST to LYON ST (2900 - 2999) | - | 4 FEET WEST OF BAKER | - | - | - | - | - | 126911 | 1219968000000 | -122.44581161 | 37.79386393 | - | - | - | D2 | - | STREET CLEANING | REG | R30B(CA).0065 | 18X18 | SUP1 | LIGHT POLE | IS | 1375724640000 | VALLEJO ST | 2900 - 2999 VALLEJO ST | 2900 - 2999 VALLEJO ST | 2900 VALLEJO ST | - | LYON ST | LYON ST |
| 109604 | N/A | Point | - | - | - | - | S250794 | CALIFORNIA ST: LOCUST ST | - | F | F | - | F | 26938000 | 26938000 | TYPE-DL.0014-2019-01-14 10:41:00-37.78661956--122.45175796 | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | LOCUST ST | CALIFORNIA ST | 77550 | 77550 | 37.78661956 | -122.45175796 | CALIFORNIA ST \ LOCUST ST | LOCUST ST \ CALIFORNIA ST | 1710539427000 | MTA | FG 300 EFX DELINEATOR (Y) | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 126912 | 1547462460000 | -122.45175796 | 37.78661956 | - | - | - | D2 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1547451600000 | LOCUST ST | - | - | - | - | - | - |
| 109605 | N/A | Point | - | - | - | - | S250795 | CALIFORNIA ST: LOCUST ST | - | F | F | - | F | 26938000 | 26938000 | TYPE-DL.0014-2019-01-14 10:22:00-37.78661956--122.45175796 | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | LOCUST ST | CALIFORNIA ST | 77551 | 77551 | 37.78661956 | -122.45175796 | CALIFORNIA ST \ LOCUST ST | LOCUST ST \ CALIFORNIA ST | 1710539427000 | MTA | FG 300 EFX DELINEATOR (Y) | CALIFORNIA ST intersection | - | 30FT EAST OF LOCUST | - | - | - | - | - | 126913 | 1547461320000 | -122.45175796 | 37.78661956 | - | - | - | D2 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1547451660000 | LOCUST ST | - | - | - | - | - | - |
| 109606 | N/A | Point | - | - | - | - | S250796 | CALIFORNIA ST: LOCUST ST | - | F | F | - | F | 26938000 | 26938000 | TYPE-DL.0014-2019-01-14 10:10:00-37.78661956--122.45175796 | - | CENTER ISLAND, W LINE, WESTBOUND | - | - | - | - | LOCUST ST | CALIFORNIA ST | 77552 | 77552 | 37.78661956 | -122.45175796 | CALIFORNIA ST \ LOCUST ST | LOCUST ST \ CALIFORNIA ST | 1710539427000 | MTA | FG 300 EFX DELINEATOR (Y) | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 126914 | 1547460600000 | -122.45175796 | 37.78661956 | - | - | - | D2 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1547451720000 | LOCUST ST | - | - | - | - | - | - |
| 109607 | N/A | Point | - | - | - | - | S250797 | CALIFORNIA ST: LOCUST ST | - | F | F | - | F | 26938000 | 26938000 | TYPE-DL.0014-2019-01-14 10:08:00-37.78661956--122.45175796 | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | LOCUST ST | CALIFORNIA ST | 77553 | 77553 | 37.78661956 | -122.45175796 | CALIFORNIA ST \ LOCUST ST | LOCUST ST \ CALIFORNIA ST | 1710539427000 | MTA | FG 300 EFX DELINEATOR (Y) | CALIFORNIA ST intersection | - | 30FT WEST OF LOCUST | - | - | - | - | - | 126915 | 1547460480000 | -122.45175796 | 37.78661956 | - | - | - | D2 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1547451780000 | LOCUST ST | - | - | - | - | - | - |
| 109608 | N/A | Point | - | - | - | - | S247181 | PACIFIC AVE: POWELL ST | - | T | T | - | F | 25064000 | 25064000 | D3-2.0285-2019-09-23 15:29:00-37.79649276--122.41007597 | - | SOUTH EAST CORNER | - | - | - | - | PACIFIC AVE | PACIFIC AVE | 77566 | 77566 | 37.79649276 | -122.41007597 | POWELL ST \ PACIFIC AVE | POWELL ST \ PACIFIC AVE | 1744122161000 | middleware_editor | POWELL ST | PACIFIC AVE intersection | - | - | - | - | - | - | - | 126916 | 1569277740000 | -122.41007597 | 37.79649276 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-2.0285 | 72X18 | SUP1 | LIGHT POLE | IS | 1532342400000 | POWELL ST | - | - | - | - | - | - |
| 109609 | N/A | Point | 1 | 1 | 200 - 699 | - | S148717 | 100-199 JOHN MUIR DR | 200-699 JOHN MUIR DR | F | F | - | F | 7553000 | 7553000 | R30B(CA).0257-2008-10-28 00:00:00-37.7138378--122.492589 | - | SOUTH SIDE | - | - | - | - | LAKE MERCED BLVD | LAKE MERCED BLVD | 77916 | 77916 | 37.7138378 | -122.492589 | - | - | 1715095208000 | middleware_editor | NPRK 8AM-10AM 2ND & 4TH TUE OF MONTH STCL | LAKE MERCED BLVD to SKYLINE BLVD (200 - 699) | - | 1803 FEET WEST OF LAKE MERCED | - | - | - | - | - | 126917 | 1225152000000 | -122.492589 | 37.7138378 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0257 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375729020000 | JOHN MUIR DR | 200 - 699 JOHN MUIR DR | 200 - 699 JOHN MUIR DR | 200 JOHN MUIR DR | - | SKYLINE BLVD | SKYLINE BLVD |
| 109610 | N/A | Point | - | - | - | - | S251537 | STOCKTON ST: 4TH ST \ ELLIS ST | - | T | T | - | F | 24892000 | 24892000 | R6-1.0001-2009-01-22 00:00:00-37.78574399--122.40583101 | - | NORTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 4TH ST \ MARKET ST \ STOCKTON ST | 04TH ST \ ELLIS ST \ MARKET ST | 77923 | 77923 | 37.78574399 | -122.40583101 | ELLIS ST \ 4TH ST \ MARKET ST \ STOCKTON ST | STOCKTON ST \ 04TH ST \ ELLIS ST \ MARKET ST | 1733182949000 | middleware_editor | ONE WAY (LA) | 04TH ST \ ELLIS ST \ MARKET ST intersection | - | ON NEW MUNI POLE / NWC OF ELLIS | - | - | - | - | - | 126918 | 1232582400000 | -122.40583101 | 37.78574399 | - | 1550534400000 | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | MUNI POLE | IS | 1549964700000 | STOCKTON ST | - | - | - | - | - | - |
| 109611 | N/A | Point | - | - | - | - | S270646 | FOLSOM ST: ESSEX ST | - | F | F | - | F | 24524000 | 24524000 | TYPE-DL.0011-2020-12-15 12:40:00-37.78637894--122.39564547 | - | CENTER ISLAND, N LINE, EASTBOUND | - | - | - | - | FOLSOM ST | FOLSOM ST | 91976 | 91976 | 37.78637894 | -122.39564547 | ESSEX ST \ FOLSOM ST | ESSEX ST \ FOLSOM ST | 1743011480000 | middleware_editor | FG 300 UR DELINEATOR (W) | FOLSOM ST intersection | - | 3' WEST OF CENTER ISLAND GOING WEST, | - | - | - | - | - | 126919 | 1608064800000 | -122.39564547 | 37.78637894 | - | - | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1607005500000 | ESSEX ST | - | - | - | - | - | - |
| 109612 | N/A | Point | - | - | - | - | S271613 | ALEMANY BLVD: INDUSTRIAL ST ON | - | F | F | - | F | 33691000 | 33691000 | TYPE-DL.0011-2019-07-08 00:00:00-37.73756582--122.40725235 | - | NORTH SIDE | - | - | - | - | ALEMANY BLVD | ALEMANY BLVD | 91979 | 91979 | 37.73756582 | -122.40725235 | INDUSTRIAL ST ON RAMP \ ALEMANY BLVD | INDUSTRIAL ST ON RAMP \ ALEMANY BLVD | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | ALEMANY BLVD intersection | - | 30 FT OC | - | - | - | - | - | 126920 | 1562544000000 | -122.40725235 | 37.73756582 | - | 1611014400000 | - | D9 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1611049500000 | INDUSTRIAL ST ON RAMP | - | - | - | - | - | - |
| 109613 | N/A | Point | 1 | 1 | 600 - 649 | - | S284283 | 600-649 4TH ST | 600-649 04TH ST | F | F | - | F | 265000 | 265000 | R37(CA).0090-None-37.77801263--122.3961373 | - | WEST SIDE | - | - | - | - | BRANNAN ST | BRANNAN ST | 92263 | 92263 | 37.77801263 | -122.3961373 | - | - | 1710539427000 | MTA | TANSAT | BRANNAN ST to BLUXOME ST (600 - 649) | - | 110' SOUTH OF BRANNAN ST | - | - | - | - | - | 126921 | 1660176000000 | -122.3961373 | 37.77801263 | - | - | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1659432720000 | 04TH ST | 600 - 649 4TH ST | 600 - 649 04TH ST | 600 4TH ST | - | BLUXOME ST | BLUXOME ST |
| 109614 | N/A | Point | - | - | - | - | S271935 | ALEMANY BLVD: INDUSTRIAL ST ON | - | F | F | - | F | 33691000 | 33691000 | TYPE-DL.0011-2019-07-08 00:00:00-37.73756582--122.40725235 | - | SOUTH SIDE | - | - | - | - | ALEMANY BLVD | ALEMANY BLVD | 92290 | 92290 | 37.73756582 | -122.40725235 | INDUSTRIAL ST ON RAMP \ ALEMANY BLVD | INDUSTRIAL ST ON RAMP \ ALEMANY BLVD | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | ALEMANY BLVD intersection | - | 30 FT OC | - | - | - | - | - | 126922 | 1562544000000 | -122.40725235 | 37.73756582 | - | 1613088000000 | - | D9 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1611822300000 | INDUSTRIAL ST ON RAMP | - | - | - | - | - | - |
| 109615 | N/A | Point | - | - | - | - | S271936 | ALEMANY BLVD: INDUSTRIAL ST ON | - | F | F | - | F | 33691000 | 33691000 | TYPE-DL.0011-2019-07-08 00:00:00-37.73756582--122.40725235 | - | EAST SIDE | - | - | - | - | ALEMANY BLVD | ALEMANY BLVD | 92291 | 92291 | 37.73756582 | -122.40725235 | INDUSTRIAL ST ON RAMP \ ALEMANY BLVD | INDUSTRIAL ST ON RAMP \ ALEMANY BLVD | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | ALEMANY BLVD intersection | - | 30 FT OC / IN HASH MARKINGS | - | - | - | - | - | 126923 | 1562544000000 | -122.40725235 | 37.73756582 | - | 1613692800000 | - | D9 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1611822540000 | INDUSTRIAL ST ON RAMP | - | - | - | - | - | - |
| 109616 | N/A | Point | - | - | - | - | S284395 | 26TH ST: WISCONSIN ST | - | F | F | - | F | 23686000 | 23686000 | R1-1.0002-None-37.75105461--122.39834078 | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 26TH ST | 26TH ST | 92326 | 92326 | 37.75105461 | -122.39834078 | WISCONSIN ST \ 26TH ST | WISCONSIN ST \ 26TH ST | 1753722056000 | middleware_editor | STOP | 26TH ST intersection | - | - | - | - | - | - | - | 126924 | 1660201200000 | -122.39834078 | 37.75105461 | - | 1753720500000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1660038360000 | WISCONSIN ST | - | - | - | - | - | - |
| 109617 | N/A | Point | - | - | - | - | S270330 | GEARY BLVD: STEINER ST | - | F | F | - | F | 26594000 | 26594000 | R3-3.0001-None-37.78415186--122.4345621 | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | GEARY BLVD | STEINER ST | 92431 | 92431 | 37.78415186 | -122.4345621 | STEINER ST \ GEARY BLVD | GEARY BLVD \ STEINER ST | 1710539427000 | MTA | NO TURNS | STEINER ST intersection | - | NORTH ISLAND | - | - | - | - | - | 126925 | - | -122.4345621 | 37.78415186 | - | - | - | D5 | - | OTHER REGULATORY | REG | R3-3.0001 | 30X30 | SUP1 | SIGNAL POLE | IS | 1606128120000 | GEARY BLVD | - | - | - | - | - | - |
| 109618 | N/A | Point | 1 | 1 | 100 - 136 | - | S283074 | 100-136 3RD ST | 100-136 03RD ST | T | T | - | F | 166000 | 166000 | R61(SF).0196-2009-04-16 00:00:00-37.78603868--122.40175763 | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | MISSION ST | MISSION ST | 92491 | 92491 | 37.78603868 | -122.40175763 | - | - | 1710539427000 | MTA | (VA) ONLY (VA) BUS ONLY (RA) ONLY | MISSION ST to MINNA ST (100 - 136) | - | 90' SOUTH OF MISSION ST | - | - | - | - | - | 126926 | 1239840000000 | -122.40175763 | 37.78603868 | - | - | - | D6 | - | OTHER REGULATORY | REG | R61(SF).0196 | 42X36 | SUP1 | LIGHT POLE | IS | 1653565260000 | 03RD ST | 100 - 136 3RD ST | 100 - 136 03RD ST | 100 3RD ST | - | MINNA ST | MINNA ST |
| 109619 | N/A | Point | - | - | - | - | S268475 | MARKET ST: 17TH ST \ CASTRO ST | - | F | F | - | F | 25814000 | 25814000 | TYPE-DL.0011-2005-05-23 00:00:00-37.76267071--122.43518796 | - | NORTH WEST CORNER | - | - | - | - | CASTRO ST \ MARKET ST | 17TH ST \ CASTRO ST | 92564 | 92564 | 37.76267071 | -122.43518796 | 17TH ST \ CASTRO ST \ MARKET ST | MARKET ST \ 17TH ST \ CASTRO ST | 1744380717000 | middleware_editor | FG 300 UR DELINEATOR (W) | 17TH ST \ CASTRO ST intersection | - | IN 20 FT DIAMOND AREA | - | - | - | - | - | 126927 | 1116831600000 | -122.43518796 | 37.76267071 | - | 1744145700000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | INTERSTATE BASE | IS | 1601030460000 | MARKET ST | - | - | - | - | - | - |
| 109620 | N/A | Point | - | - | - | - | S268476 | MARKET ST: 17TH ST \ CASTRO ST | - | F | F | - | F | 25814000 | 25814000 | TYPE-DL.0011-2005-05-23 00:00:00-37.76267071--122.43518796 | - | NORTH SIDE | - | - | - | - | CASTRO ST \ MARKET ST | 17TH ST \ CASTRO ST | 92565 | 92565 | 37.76267071 | -122.43518796 | 17TH ST \ CASTRO ST \ MARKET ST | MARKET ST \ 17TH ST \ CASTRO ST | 1755206025000 | middleware_editor | FG 300 UR DELINEATOR (W) | 17TH ST \ CASTRO ST intersection | - | 10 FT O.C IN MIDDLE OF HASH MARKS | - | - | - | - | - | 126928 | 1116831600000 | -122.43518796 | 37.76267071 | - | 1755019200000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | TURNPIKE BASE | IS | 1601030520000 | MARKET ST | - | - | - | - | - | - |
| 109621 | N/A | Point | - | - | - | - | S268477 | MARKET ST: 17TH ST \ CASTRO ST | - | F | F | - | F | 25814000 | 25814000 | TYPE-DL.0011-2005-05-23 00:00:00-37.76267071--122.43518796 | - | NORTH SIDE | - | - | - | - | CASTRO ST \ MARKET ST | 17TH ST \ CASTRO ST | 92566 | 92566 | 37.76267071 | -122.43518796 | 17TH ST \ CASTRO ST \ MARKET ST | MARKET ST \ 17TH ST \ CASTRO ST | 1725931541000 | middleware_editor | FG 300 UR DELINEATOR (W) | 17TH ST \ CASTRO ST intersection | - | 10 FT OC IN MIDDLE OF ROAD IN HASH MARKS | - | - | - | - | - | 126929 | 1116806400000 | -122.43518796 | 37.76267071 | - | 1646352000000 | 1654646400000 | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | TURNPIKE BASE | RETD | 1601030580000 | MARKET ST | - | - | - | - | - | - |
| 109622 | N/A | Point | - | - | - | - | S258463 | FRONT ST: FREMONT ST \ MARKET | - | T | T | - | F | 30730000 | 30730000 | R3-1.0002-None-37.79171606--122.39826445 | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FREMONT ST \ FRONT ST | FREMONT ST \ FRONT ST | 92632 | 92632 | 37.79171606 | -122.39826445 | MARKET ST \ FREMONT ST \ FRONT ST | MARKET ST \ FREMONT ST \ FRONT ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) | FREMONT ST \ FRONT ST intersection | - | - | - | - | - | - | - | 126930 | - | -122.39826445 | 37.79171606 | - | - | - | D3 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1571483880000 | MARKET ST | - | - | - | - | - | - |
| 109623 | N/A | Point | - | - | - | - | S258464 | FRONT ST: FREMONT ST \ MARKET | - | T | T | - | F | 30730000 | 30730000 | R(SF).0347-None-37.79171606--122.39826445 | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FREMONT ST \ FRONT ST | FREMONT ST \ FRONT ST | 92633 | 92633 | 37.79171606 | -122.39826445 | MARKET ST \ FREMONT ST \ FRONT ST | MARKET ST \ FREMONT ST \ FRONT ST | 1710539427000 | MTA | EXC BUSES BICYCLES TAXIS AND TRUCKS (SYM) | FREMONT ST \ FRONT ST intersection | - | - | - | - | - | - | - | 126931 | - | -122.39826445 | 37.79171606 | - | - | - | D3 | - | OTHER REGULATORY | REG | R(SF).0347 | 30X30 | SUP1 | SIGNAL POLE | IS | 1571484000000 | MARKET ST | - | - | - | - | - | - |
| 109624 | N/A | Point | - | - | - | - | S258466 | FRONT ST: FREMONT ST \ MARKET | - | F | F | - | F | 30730000 | 30730000 | R(SF).0062-2020-01-13 15:21:00-37.79171606--122.39826445 | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FREMONT ST \ FRONT ST | FREMONT ST \ FRONT ST | 92634 | 92634 | 37.79171606 | -122.39826445 | MARKET ST \ FREMONT ST \ FRONT ST | MARKET ST \ FREMONT ST \ FRONT ST | 1710539427000 | MTA | EXC BUSES AND TAXIS | FREMONT ST \ FRONT ST intersection | - | - | - | - | - | - | - | 126932 | 1578928860000 | -122.39826445 | 37.79171606 | - | - | - | D3 | - | OTHER REGULATORY | REG | R(SF).0062 | 18X12 | SUP1 | OVERHEAD MAST ARM | IS | 1571484120000 | MARKET ST | - | - | - | - | - | - |
| 109625 | N/A | Point | 1 | 1 | 200 - 699 | - | S252647 | 100-199 JOHN MUIR DR | 200-699 JOHN MUIR DR | F | F | - | F | 7553000 | 7553000 | W11-2.0003-2019-03-21 11:20:00-37.7138378--122.492589 | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | LAKE MERCED BLVD | LAKE MERCED BLVD | 92757 | 92757 | 37.7138378 | -122.492589 | - | - | 1725907289000 | middleware_editor | PEDESTRIAN (SYM) | LAKE MERCED BLVD to SKYLINE BLVD (200 - 699) | - | IFO 511 AT FIRST CROSSWALK HEADING WEST | - | - | - | - | - | 126933 | 1553167200000 | -122.492589 | 37.7138378 | - | 1725875400000 | - | D7 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1552998000000 | JOHN MUIR DR | 200 - 699 JOHN MUIR DR | 200 - 699 JOHN MUIR DR | 200 JOHN MUIR DR | - | SKYLINE BLVD | SKYLINE BLVD |
| 109626 | N/A | Point | - | - | - | - | S278998 | 151-199 HUNTERS POINT EXPY | - | F | F | - | F | 7097000 | 7097000 | R37(CA).0090-None-37.7109013--122.38169833 | - | SOUTH SIDE | - | - | - | - | - | - | 107690 | 107690 | 37.7109013 | -122.38169833 | - | - | 1710539427000 | MTA | TANSAT | - | - | 200' EAST OF HARNEY WAY | - | - | - | - | - | 126934 | - | -122.38169833 | 37.7109013 | - | 1641168000000 | - | D10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1637248080000 | HUNTERS POINT EXPY | 151-199 HUNTERS POINT EXPY | HUNTERS POINT EXPY | - | - | - | - |
| 109627 | N/A | Point | - | - | - | - | S276631 | KEARNY ST: CLAY ST | - | F | F | - | F | 24770000 | 24770000 | R37(CA).0020-None-37.794453--122.40479647 | - | SOUTH WEST CORNER | - | - | - | - | KEARNY ST | CLAY ST | 107780 | 107780 | 37.794453 | -122.40479647 | CLAY ST \ KEARNY ST | KEARNY ST \ CLAY ST | 1710539427000 | MTA | TANS 3PM-6PM EXC SAT & SUN | CLAY ST intersection | - | @ CLAY | - | - | - | - | - | 126935 | - | -122.40479647 | 37.794453 | - | - | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0020 | 18X21 | SUP1 | LIGHT POLE | IS | 1627477500000 | KEARNY ST | - | - | - | - | - | - |
| 109628 | N/A | Point | - | - | - | - | S276919 | MARKET ST: 4TH ST \ ELLIS ST \ | - | F | F | - | F | 24892000 | 24892000 | R3-1.0002-2021-08-11 14: 10: 00-37.78574399--122.40583101 | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 4TH ST \ MARKET ST \ STOCKTON ST | 04TH ST \ ELLIS ST \ MARKET ST | 107782 | 107782 | 37.78574399 | -122.40583101 | ELLIS ST \ 4TH ST \ MARKET ST \ STOCKTON ST | STOCKTON ST \ 04TH ST \ ELLIS ST \ MARKET ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) | 04TH ST \ ELLIS ST \ MARKET ST intersection | - | - | - | - | - | - | - | 126936 | 1628691000000 | -122.40583101 | 37.78574399 | - | - | - | D3 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1627992840000 | STOCKTON ST | - | - | - | - | - | - |
| 109629 | N/A | Point | - | - | - | - | S241078 | NORTH POINT ST: VAN NESS AVE | - | T | T | - | F | 26708000 | 26708000 | G-X(SF).0048-2019-07-03 12: 14: 00-37.8050779--122.42529856 | - | WEST SIDE, WESTBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 107956 | 107956 | 37.8050779 | -122.42529856 | NORTH POINT ST \ VAN NESS AVE | NORTH POINT ST \ VAN NESS AVE | 1715131541000 | middleware_editor | 49 MILE SCENIC DRIVE ARROW (LA) | VAN NESS AVE intersection | 37 | CTR-LINE NORTH POINT- W/S OF VAN NESS | - | - | - | - | - | 126937 | 1562156040000 | -122.42529856 | 37.8050779 | - | - | - | D2 | - | OTHER GUIDE | GUIDE | G-X(SF).0048 | 18X18 | SUP1 | LIGHT POLE | IS | 1512130620000 | NORTH POINT ST | - | - | - | - | - | - |
| 109630 | N/A | Point | - | - | - | - | S250525 | COLUMBUS AVE: GREEN ST \ STOCK | - | T | T | - | F | 25352000 | 25352000 | D3-2.0175-None-37.79948982--122.40901438 | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | COLUMBUS AVE \ GREEN ST | COLUMBUS AVE \ GREEN ST | 107963 | 107963 | 37.79948982 | -122.40901438 | STOCKTON ST \ COLUMBUS AVE \ GREEN ST | STOCKTON ST \ COLUMBUS AVE \ GREEN ST | 1711028589000 | elclark | GREEN ST | COLUMBUS AVE \ GREEN ST intersection | - | INTERSECTION STOCKTON GREEN COLUMBUS | - | - | - | - | - | 126938 | - | -122.40901438 | 37.79948982 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-2.0175 | 72X18 | SUP1 | LIGHT POLE | IS | 1545995400000 | STOCKTON ST | - | - | - | - | - | - |
| 109631 | N/A | Point | 1 | 1 | 100 - 136 | - | S250350 | 100-136 3RD ST | 100-136 03RD ST | F | F | - | F | 166000 | 166000 | W(SF).0098-2019-01-02 14:53:00-37.78603868--122.40175763 | - | WEST SIDE | - | - | - | - | MISSION ST | MISSION ST | 107965 | 107965 | 37.78603868 | -122.40175763 | - | - | 1710539427000 | MTA | EXCEPT 7AM-9AM AND 3PM-7PM | MISSION ST to MINNA ST (100 - 136) | - | 150' NORTH OF HOWARD ST. | - | - | - | - | - | 126939 | 1546440780000 | -122.40175763 | 37.78603868 | - | - | - | D6 | - | OTHER WARNING | WARNING | W(SF).0098 | 30X24 | SUP1 | 2IN IRON POST | IS | 1545134400000 | 03RD ST | 100 - 136 3RD ST | 100 - 136 03RD ST | 100 3RD ST | - | MINNA ST | MINNA ST |
| 109632 | N/A | Point | - | - | - | - | S103763 | WASHINGTON ST: KEARNY ST | - | F | F | - | F | 24774000 | 24774000 | R5-1.0002-1966-08-12 00:00:00-37.79532669--122.40495721 | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 107976 | 107976 | 37.79532669 | -122.40495721 | KEARNY ST \ WASHINGTON ST | KEARNY ST \ WASHINGTON ST | 1726796734000 | middleware_editor | DO NOT ENTER | WASHINGTON ST intersection | - | 0 / 00 | - | - | - | - | - | 126940 | -106963200000 | -122.40495721 | 37.79532669 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1.0002 | 24X24 | SUP1 | UNKNOWN | IS | 1373568720000 | KEARNY ST | - | - | - | - | - | - |
| 109633 | N/A | Point | - | - | - | LEFT ARROW | S226739 | CASTRO ST: 17TH ST \ MARKET ST | - | F | F | - | F | 25814000 | 25814000 | R38(SF)8.0005-2016-06-24 14:04:00-37.76267071--122.43518796 | - | NORTH EAST CORNER | - | - | - | - | CASTRO ST \ MARKET ST | 17TH ST \ CASTRO ST | 108161 | 108161 | 37.76267071 | -122.43518796 | 17TH ST \ CASTRO ST \ MARKET ST | MARKET ST \ 17TH ST \ CASTRO ST | 1725931532000 | middleware_editor | TA (SYM) PERMITTED COMM SHUTTLE ONLY 4PM-8PM MON-FRI | 17TH ST \ CASTRO ST intersection | - | THIS IS A (LA) SIGN | - | - | - | - | - | 126941 | 1466777040000 | -122.43518796 | 37.76267071 | - | 1466726400000 | - | D8 | - | OTHER REGULATORY | REG | R38(SF)8.0005 | 14X21 | SUP2 | LIGHT POLE | IS | 1466174580000 | MARKET ST | - | - | - | - | - | - |
| 109634 | N/A | Point | - | - | - | - | S271191 | ALEMANY BLVD: KEMPTON AVE | - | F | F | - | F | 22530000 | 22530000 | D3-1.0076-None-37.71101763--122.46842969 | - | NORTH WEST CORNER | - | - | - | - | ALEMANY BLVD | ALEMANY BLVD | 108180 | 108180 | 37.71101763 | -122.46842969 | KEMPTON AVE \ ALEMANY BLVD | KEMPTON AVE \ ALEMANY BLVD | 1726105211000 | middleware_editor | ALEMANY BLVD | ALEMANY BLVD intersection | 120008009 | FROM W.POLE TO 3IN POST | - | - | - | - | - | 126942 | - | -122.46842969 | 37.71101763 | - | - | - | D7 | - | STREET NAME | GUIDE | D3-1.0076 | 36X08 | SUP2 | 3IN IRON POST | IS | 1609755900000 | KEMPTON AVE | - | - | - | - | - | - |
| 109635 | N/A | Point | - | - | - | RIGHT ARROW | S219066 | 4TH ST: ELLIS ST \ MARKET ST \ | - | F | F | - | F | 24892000 | 24892000 | R30(SF).0571-None-37.78574399--122.40583101 | - | EAST SIDE | - | - | - | - | 4TH ST \ MARKET ST \ STOCKTON ST | 04TH ST \ ELLIS ST \ MARKET ST | 108185 | 108185 | 37.78574399 | -122.40583101 | ELLIS ST \ 4TH ST \ MARKET ST \ STOCKTON ST | STOCKTON ST \ 04TH ST \ ELLIS ST \ MARKET ST | 1710539427000 | MTA | NPRK TAXI ZONE | 04TH ST \ ELLIS ST \ MARKET ST intersection | - | 82' SOUTH OF MARKET | - | - | - | - | - | 126943 | - | -122.40583101 | 37.78574399 | - | - | - | D3 | - | PARKING | REG | R30(SF).0571 | 12X18 | SUP1 | 2IN FLANGE POST | IS | 1441275600000 | STOCKTON ST | - | - | - | - | - | - |
| 109636 | N/A | Point | - | - | - | - | S243716 | MARKET ST: 4TH ST \ ELLIS ST \ | - | T | T | - | F | 24892000 | 24892000 | R3-2.0002-None-37.78574399--122.40583101 | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 4TH ST \ MARKET ST \ STOCKTON ST | 04TH ST \ ELLIS ST \ MARKET ST | 108249 | 108249 | 37.78574399 | -122.40583101 | ELLIS ST \ 4TH ST \ MARKET ST \ STOCKTON ST | STOCKTON ST \ 04TH ST \ ELLIS ST \ MARKET ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | 04TH ST \ ELLIS ST \ MARKET ST intersection | - | - | - | - | - | - | - | 126944 | - | -122.40583101 | 37.78574399 | - | - | - | D3 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1521107580000 | STOCKTON ST | - | - | - | - | - | - |
| 109637 | N/A | Point | - | - | - | - | S278183 | GARFIELD ST: BEVERLY ST | - | F | F | - | F | 22728000 | 22728000 | D3-1.0217-None-37.7196402--122.47165211 | - | NORTH WEST CORNER | - | - | - | - | GARFIELD ST | GARFIELD ST | 108256 | 108256 | 37.7196402 | -122.47165211 | BEVERLY ST \ GARFIELD ST | BEVERLY ST \ GARFIELD ST | 1728482134000 | middleware_editor | BEVERLY ST | GARFIELD ST intersection | - | - | - | - | - | - | - | 126945 | - | -122.47165211 | 37.7196402 | - | - | 1728456840000 | D11 | - | STREET NAME | GUIDE | D3-1.0217 | 36X08 | SUP2 | 3IN IRON POST | RETD | 1634123160000 | BEVERLY ST | - | - | - | - | - | - |
| 109638 | N/A | Point | 1 | 1 | 333 - 399 | - | S274564 | 333-399 GRANT AVE | 333-399 GRANT AVE | F | F | - | F | 6388000 | 6388000 | R30B(CA).0123-2021-08-27 13:45:00-37.79032239--122.40554636 | - | WEST SIDE | - | - | - | - | HARLAN PL | HARLAN PL | 108342 | 108342 | 37.79032239 | -122.40554636 | - | - | 1715016401000 | middleware_editor | NPRK 2AM-6AM MON WED FRI STCL | HARLAN PL to BUSH ST (333 - 399) | - | IFO # 333 GRANT 60 ' S. BUSH | - | - | - | - | - | 126946 | 1630022400000 | -122.40554636 | 37.79032239 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0123 | 18X18 | SUP1 | 2IN FLANGE POST | IS | 1620381840000 | GRANT AVE | 333 - 399 GRANT AVE | 333 - 399 GRANT AVE | 333 GRANT AVE | - | BUSH ST | BUSH ST |
| 109639 | N/A | Point | - | - | - | - | S278997 | 151-199 HUNTERS POINT EXPY | - | F | F | - | F | 7097000 | 7097000 | R37(CA).0090-None-37.7109013--122.38169833 | - | SOUTH SIDE | - | - | - | - | - | - | 107689 | 107689 | 37.7109013 | -122.38169833 | - | - | 1710539427000 | MTA | TANSAT | - | - | 730' WEST OF GATE 1 | - | - | - | - | - | 126947 | - | -122.38169833 | 37.7109013 | - | 1641168000000 | - | D10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1637248020000 | HUNTERS POINT EXPY | 151-199 HUNTERS POINT EXPY | HUNTERS POINT EXPY | - | - | - | - |
| 109640 | N/A | Point | - | - | - | - | S111351 | 17TH ST: CASTRO ST \ MARKET ST | - | F | F | - | F | 25814000 | 25814000 | R5-1.0001-1994-10-07 00: 00: 00-37.76267071--122.43518796 | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CASTRO ST \ MARKET ST | 17TH ST \ CASTRO ST | 108387 | 108387 | 37.76267071 | -122.43518796 | 17TH ST \ CASTRO ST \ MARKET ST | MARKET ST \ 17TH ST \ CASTRO ST | 1725931542000 | middleware_editor | DO NOT ENTER | 17TH ST \ CASTRO ST intersection | - | ON PEDESTRIAN ISLAND | - | - | - | - | - | 126948 | 781488000000 | -122.43518796 | 37.76267071 | - | - | - | D8 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP2 | SIGNAL POLE | IS | 1373571120000 | MARKET ST | - | - | - | - | - | - |
| 109641 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S274912 | 1100-1199 FILBERT ST | 1100-1199 FILBERT ST | F | F | - | F | 5511000 | 5511000 | R81A(CA).0001-2021-06-09 13: 22: 00-37.80023737--122.41840996 | - | SOUTH SIDE | - | - | - | - | LEAVENWORTH ST | LEAVENWORTH ST | 121244 | 121244 | 37.80023737 | -122.41840996 | - | - | 1710539427000 | MTA | BEGIN | LEAVENWORTH ST to HYDE ST (1100 - 1199) | - | IFO #1147 FILBERT | - | - | - | - | - | 126949 | 1623244920000 | -122.41840996 | 37.80023737 | - | - | - | D2 | - | OTHER REGULATORY | REG | R81A(CA).0001 | 12X05 | SUP1 | 2IN IRON POST | IS | 1621862640000 | FILBERT ST | 1100 - 1199 FILBERT ST | 1100 - 1199 FILBERT ST | 1100 FILBERT ST | - | HYDE ST | HYDE ST |
| 109642 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S274914 | 1100-1199 FILBERT ST | 1100-1199 FILBERT ST | F | F | - | F | 5511000 | 5511000 | R6-1.0004-2021-06-09 13: 19: 00-37.80023737--122.41840996 | - | SOUTH SIDE | - | - | - | - | LEAVENWORTH ST | LEAVENWORTH ST | 121245 | 121245 | 37.80023737 | -122.41840996 | - | - | 1710539427000 | MTA | ONE WAY (LA) | LEAVENWORTH ST to HYDE ST (1100 - 1199) | - | IFO # 1147 FILBERT | - | - | - | - | - | 126950 | 1623244740000 | -122.41840996 | 37.80023737 | - | - | - | D2 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP1 | 2IN IRON POST | IS | 1621862820000 | FILBERT ST | 1100 - 1199 FILBERT ST | 1100 - 1199 FILBERT ST | 1100 FILBERT ST | - | HYDE ST | HYDE ST |
| 109643 | N/A | Point | - | - | - | - | S287090 | POWELL ST: BUSH ST | - | T | T | - | F | 24976000 | 24976000 | R2-1.0005-None-37.7901595--122.40878611 | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BUSH ST | BUSH ST | 121555 | 121555 | 37.7901595 | -122.40878611 | POWELL ST \ BUSH ST | POWELL ST \ BUSH ST | 1710539427000 | MTA | SPEED LIMIT 25 | BUSH ST intersection | - | - | - | - | - | - | - | 126951 | 1675728000000 | -122.40878611 | 37.7901595 | - | - | - | D3 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP1 | OVERHEAD MAST ARM | IS | 1674043380000 | POWELL ST | - | - | - | - | - | - |
| 109644 | N/A | Point | 1 | 1 | 300 - 399 | - | S287091 | 300-399 POWELL ST | 300-399 POWELL ST | T | T | - | F | 10678000 | 10678000 | R2-1.0004-None-37.78782623--122.40831414 | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | GEARY ST | GEARY ST | 121556 | 121556 | 37.78782623 | -122.40831414 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | GEARY ST to POST ST (300 - 399) | - | 115' NORTH OF GEARY ST. | - | - | - | - | - | 126952 | 1675641600000 | -122.40831414 | 37.78782623 | - | - | - | D3 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1674044280000 | POWELL ST | 300 - 399 POWELL ST | 300 - 399 POWELL ST | 300 POWELL ST | - | POST ST | POST ST |
| 109645 | N/A | Point | 1 | 1 | 200 - 299 | - | S287092 | 200-299 POWELL ST | 200-299 POWELL ST | T | T | - | F | 10677000 | 10677000 | R2-1.0004-None-37.78688444--122.40813148 | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | OFARRELL ST | OFARRELL ST | 121557 | 121557 | 37.78688444 | -122.40813148 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | OFARRELL ST to GEARY ST (200 - 299) | - | 75' SOUTH OF GEARY ST | - | - | - | - | - | 126953 | 1675641600000 | -122.40813148 | 37.78688444 | - | - | - | D3 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1674044820000 | POWELL ST | 200 - 299 POWELL ST | 200 - 299 POWELL ST | 200 POWELL ST | - | GEARY ST | GEARY ST |
| 109646 | N/A | Point | 1 | 1 | 100 - 199 | - | S287093 | 100-199 POWELL ST | 100-199 POWELL ST | T | T | - | F | 10676000 | 10676000 | R2-1.0004-None-37.78595059--122.40794438 | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 121558 | 121558 | 37.78595059 | -122.40794438 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | ELLIS ST to OFARRELL ST (100 - 199) | - | 100' SOUTH OF O'FARREL ST | - | - | - | - | - | 126954 | 1675641600000 | -122.40794438 | 37.78595059 | - | - | - | D3 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1674045540000 | POWELL ST | 100 - 199 POWELL ST | 100 - 199 POWELL ST | 100 POWELL ST | - | OFARRELL ST | OFARRELL ST |
| 109647 | N/A | Point | - | - | - | - | S287502 | MISSION ST: BEALE ST | - | T | T | - | F | 24554000 | 24554000 | R2-1.0004-None-37.79115281--122.39581342 | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BEALE ST | BEALE ST | 121561 | 121561 | 37.79115281 | -122.39581342 | MISSION ST \ BEALE ST | MISSION ST \ BEALE ST | 1753219977000 | middleware_editor | SPEED LIMIT 20 | BEALE ST intersection | - | 5 FT EAST OF BEALE | - | - | - | - | - | 126955 | 1678262400000 | -122.39581342 | 37.79115281 | - | - | - | D6 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | MUNI POLE | IS | 1676283900000 | MISSION ST | - | - | - | - | - | - |
| 109648 | N/A | Point | - | - | - | - | S274804 | SAN BRUNO AVE: MARIPOSA ST | - | F | F | - | F | 33617000 | 33617000 | D3-1.1556-2021-06-09 12: 10: 00-37.76330276--122.40556651 | - | SOUTH EAST CORNER | - | - | - | - | MARIPOSA ST | MARIPOSA ST | 121624 | 121624 | 37.76330276 | -122.40556651 | SAN BRUNO AVE \ MARIPOSA ST | SAN BRUNO AVE \ MARIPOSA ST | 1710539427000 | MTA | SAN BRUNO AVE | MARIPOSA ST intersection | - | X-ST IS MARIPOSA - (500) | - | - | - | - | - | 126956 | 1623240600000 | -122.40556651 | 37.76330276 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.1556 | 36X08 | SUP1 | 3IN IRON POST | IS | 1621419780000 | SAN BRUNO AVE | - | - | - | - | - | - |
| 109649 | N/A | Point | - | - | - | - | S274805 | SAN BRUNO AVE: MARIPOSA ST | - | F | F | - | F | 33617000 | 33617000 | D3-1.1123-2021-06-09 12: 10: 00-37.76330276--122.40556651 | - | SOUTH EAST CORNER | - | - | - | - | MARIPOSA ST | MARIPOSA ST | 121625 | 121625 | 37.76330276 | -122.40556651 | SAN BRUNO AVE \ MARIPOSA ST | SAN BRUNO AVE \ MARIPOSA ST | 1710539427000 | MTA | MARIPOSA ST | MARIPOSA ST intersection | - | X-ST IS MARIPOSA - (2200) | - | - | - | - | - | 126957 | 1623240600000 | -122.40556651 | 37.76330276 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.1123 | 36X08 | SUP1 | 3IN IRON POST | IS | 1621419840000 | SAN BRUNO AVE | - | - | - | - | - | - |
| 109650 | N/A | Point | - | - | - | - | S274806 | SAN BRUNO AVE: MARIPOSA ST | - | F | F | - | F | 33617000 | 33617000 | W1-6.0004-2021-06-22 09: 01: 00-37.76330276--122.40556651 | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MARIPOSA ST | MARIPOSA ST | 121626 | 121626 | 37.76330276 | -122.40556651 | SAN BRUNO AVE \ MARIPOSA ST | SAN BRUNO AVE \ MARIPOSA ST | 1710539427000 | MTA | RIGHT ARROW (SYM) | MARIPOSA ST intersection | - | X-ST IS MARIPOSA - | - | - | - | - | - | 126958 | 1624352460000 | -122.40556651 | 37.76330276 | - | - | - | D10 | - | OTHER WARNING | WARNING | W1-6.0004 | 36X18 | SUP1 | 3IN IRON POST | IS | 1621419960000 | SAN BRUNO AVE | - | - | - | - | - | - |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in meters