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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14851 | N/A | Point | 1 | 1 | 1600 - 1699 | RIGHT ARROW | S228272 | 1600-1699 JENNINGS ST | 1600-1699 JENNINGS ST | F | F | - | F | 7474000 | 7474000 | - | - | WEST SIDE | - | - | - | - | QUESADA AVE | QUESADA AVE | 66608 | 66608 | 37.72985474 | -122.38613561 | - | - | 1710539427000 | MTA | NPRK VEH OVER 6 FT HIGH | QUESADA AVE to REVERE AVE (1600 - 1699) | - | 30' SOUTH OF QUESADA | - | - | - | - | - | 31926 | 1471950360000 | -122.38613561 | 37.72985474 | - | 1471910400000 | - | D10 | - | PARKING | REG | R28D(CA).0007 | 18X18 | SUP1 | 2IN IRON POST | IS | 1471856880000 | JENNINGS ST | 1600 - 1699 JENNINGS ST | 1600 - 1699 JENNINGS ST | 1600 JENNINGS ST | - | REVERE AVE | REVERE AVE |
| 14852 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S228275 | 1500-1599 INGALLS ST | 1500-1599 INGALLS ST | F | F | - | F | 7225000 | 7225000 | - | - | WEST SIDE | - | - | - | - | PALOU AVE | PALOU AVE | 66609 | 66609 | 37.72942463 | -122.38371247 | - | - | 1754587674000 | middleware_editor | NPRK VEH OVER 6 FT HIGH | PALOU AVE to QUESADA AVE (1500 - 1599) | - | 50' NORTH OF QUESADA | - | - | - | - | - | 31927 | 1471969500000 | -122.38371247 | 37.72942463 | - | 1471935600000 | - | D10 | - | PARKING | REG | R28D(CA).0007 | 18X18 | SUP1 | 2IN IRON POST | IS | 1471857420000 | INGALLS ST | 1500 - 1599 INGALLS ST | 1500 - 1599 INGALLS ST | 1500 INGALLS ST | - | QUESADA AVE | QUESADA AVE |
| 14853 | N/A | Point | - | - | - | - | S231013 | MAGELLAN AVE: CORTES AVE | - | F | F | - | F | 22962000 | 22962000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CORTES AVE | CORTES AVE | 66610 | 66610 | 37.74428069 | -122.46613821 | MAGELLAN AVE \ CORTES AVE | MAGELLAN AVE \ CORTES AVE | 1710539427000 | MTA | ALL WAY | CORTES AVE intersection | - | 0 / 0 | - | - | - | - | - | 31928 | 153446400000 | -122.46613821 | 37.74428069 | - | 1484611200000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479212220000 | MAGELLAN AVE | - | - | - | - | - | - |
| 14854 | N/A | Point | - | - | - | - | S231014 | MAGELLAN AVE: CORTES AVE | - | F | F | - | F | 22962000 | 22962000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CORTES AVE | CORTES AVE | 66611 | 66611 | 37.74428069 | -122.46613821 | MAGELLAN AVE \ CORTES AVE | MAGELLAN AVE \ CORTES AVE | 1710539427000 | MTA | ALL WAY | CORTES AVE intersection | - | 0 / 0 | - | - | - | - | - | 31929 | 153446400000 | -122.46613821 | 37.74428069 | - | 1484611200000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479212400000 | MAGELLAN AVE | - | - | - | - | - | - |
| 14855 | N/A | Point | - | - | - | - | S231017 | MAGELLAN AVE: MONTALVO AVE | - | F | F | - | F | 22960000 | 22960000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MAGELLAN AVE | MONTALVO AVE | 66612 | 66612 | 37.74444466 | -122.46416112 | MONTALVO AVE \ MAGELLAN AVE | MAGELLAN AVE \ MONTALVO AVE | 1710539427000 | MTA | ALL WAY | MONTALVO AVE intersection | - | 0 / 0 | - | - | - | - | - | 31930 | 153446400000 | -122.46416112 | 37.74444466 | - | 1666742400000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479212640000 | MAGELLAN AVE | - | - | - | - | - | - |
| 14856 | N/A | Point | - | - | - | - | S231020 | THE EMBARCADERO: KEARNY ST \ N | - | T | T | - | F | 25474000 | 25474000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | NORTH POINT ST \ THE EMBARCADERO | KEARNY ST \ THE EMBARCADERO | 66613 | 66613 | 37.80737946 | -122.40730366 | KEARNY ST \ NORTH POINT ST \ THE EMBARCADERO | NORTH POINT ST \ KEARNY ST \ THE EMBARCADERO | 1728003837000 | middleware_editor | RA (WHITE ON BLUE) TSUNAMI | KEARNY ST \ THE EMBARCADERO intersection | - | OPP PIER 39 | - | - | - | - | - | 31931 | 1333411200000 | -122.40730366 | 37.80737946 | - | 1494979200000 | - | D3 | - | OTHER GUIDE | GUIDE | M5-1.0002 | 21X15 | SUP1 | LIGHT POLE | IS | 1479212880000 | NORTH POINT ST | - | - | - | - | - | - |
| 14857 | N/A | Point | - | - | - | - | S231021 | MONTALVO AVE: MAGELLAN AVE | - | F | F | - | F | 22960000 | 22960000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MAGELLAN AVE | MONTALVO AVE | 66614 | 66614 | 37.74444466 | -122.46416112 | MONTALVO AVE \ MAGELLAN AVE | MAGELLAN AVE \ MONTALVO AVE | 1710539427000 | MTA | ALL WAY | MONTALVO AVE intersection | - | 0 / 0 | - | - | - | - | - | 31932 | 153446400000 | -122.46416112 | 37.74444466 | - | 1685491200000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479213060000 | MAGELLAN AVE | - | - | - | - | - | - |
| 14858 | N/A | Point | - | - | - | - | S231022 | MONTALVO AVE: MAGELLAN AVE | - | F | F | - | F | 22960000 | 22960000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MAGELLAN AVE | MONTALVO AVE | 66615 | 66615 | 37.74444466 | -122.46416112 | MONTALVO AVE \ MAGELLAN AVE | MAGELLAN AVE \ MONTALVO AVE | 1710539427000 | MTA | ALL WAY | MONTALVO AVE intersection | - | - | - | - | - | - | - | 31933 | 936835200000 | -122.46416112 | 37.74444466 | - | 1685491200000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479213360000 | MAGELLAN AVE | - | - | - | - | - | - |
| 14859 | N/A | Point | - | - | - | - | S232166 | COSO AVE: BONVIEW ST \ STONEMA | - | F | F | - | F | 21272000 | 21272000 | - | - | SOUTH WEST CORNER | - | - | - | - | BONVIEW ST \ STONEMAN ST | BONVIEW ST \ COSO AVE | 67201 | 67201 | 37.74510347 | -122.41569297 | COSO AVE \ BONVIEW ST \ STONEMAN ST | STONEMAN ST \ BONVIEW ST \ COSO AVE | 1710539427000 | MTA | COSO AVE | BONVIEW ST \ COSO AVE intersection | - | OF COSO AVE & BONVIEW ST(COSO(END)) | - | - | - | - | - | 31934 | 1487081220000 | -122.41569297 | 37.74510347 | - | 1487030400000 | - | D9 | - | STREET NAME | GUIDE | D3-1.0451 | 36X08 | SUP2 | LIGHT POLE | IS | 1483012800000 | STONEMAN ST | - | - | - | - | - | - |
| 14860 | N/A | Point | - | - | - | - | S232169 | BONVIEW ST: COSO AVE \ STONEMA | - | F | F | - | F | 21272000 | 21272000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BONVIEW ST \ STONEMAN ST | BONVIEW ST \ COSO AVE | 67202 | 67202 | 37.74510347 | -122.41569297 | COSO AVE \ BONVIEW ST \ STONEMAN ST | STONEMAN ST \ BONVIEW ST \ COSO AVE | 1710539427000 | MTA | NOT A THROUGH STREET | BONVIEW ST \ COSO AVE intersection | - | - | - | - | - | - | - | 31935 | - | -122.41569297 | 37.74510347 | - | - | - | D9 | - | OTHER WARNING | WARNING | W(SF).0033 | 24X24 | SUP2 | LIGHT POLE | IS | 1483013100000 | STONEMAN ST | - | - | - | - | - | - |
| 14861 | N/A | Point | 1 | 1 | 3700 - 3799 | - | S233777 | 3700-3799 17TH ST | 3700-3799 17TH ST | F | F | - | F | 805000 | 805000 | - | - | SOUTH SIDE | - | - | - | - | CHURCH ST | CHURCH ST | 67203 | 67203 | 37.76282127 | -122.42961774 | - | - | 1729300082000 | middleware_editor | FG 300 UR DELINEATOR (W) | CHURCH ST to SANCHEZ ST (3700 - 3799) | - | 32FT. WEST OF CHURCH ST.(1FT. FROM CURB) | - | - | - | - | - | 31936 | 1506783780000 | -122.42961774 | 37.76282127 | - | 1506729600000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1487346480000 | 17TH ST | 3700 - 3799 17TH ST | 3700 - 3799 17TH ST | 3700 17TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 14862 | N/A | Point | 1 | 1 | 3700 - 3799 | - | S233778 | 3700-3799 17TH ST | 3700-3799 17TH ST | F | F | - | T | 805000 | 805000 | - | - | NORTH SIDE | - | - | - | - | CHURCH ST | CHURCH ST | 67204 | 67204 | 37.76282127 | -122.42961774 | - | - | 1729300112000 | middleware_editor | FG 300 UR DELINEATOR (W) | CHURCH ST to SANCHEZ ST (3700 - 3799) | - | 10 AND 20 FT FROM CHURCH | - | - | - | - | - | 31937 | - | -122.42961774 | 37.76282127 | - | 1683763200000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1487346660000 | 17TH ST | 3700 - 3799 17TH ST | 3700 - 3799 17TH ST | 3700 17TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 14863 | N/A | Point | 1 | 1 | 3700 - 3799 | - | S233779 | 3700-3799 17TH ST | 3700-3799 17TH ST | F | F | - | F | 805000 | 805000 | - | - | NORTH SIDE | - | - | - | - | CHURCH ST | CHURCH ST | 67205 | 67205 | 37.76282127 | -122.42961774 | - | - | 1729300111000 | middleware_editor | DELINEATOR (W) (SAFE HIT) | CHURCH ST to SANCHEZ ST (3700 - 3799) | - | 26FT. WEST OF CHURCH ST.(3FT. FROM CURB) | - | - | - | - | - | 31938 | - | -122.42961774 | 37.76282127 | - | - | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1487346840000 | 17TH ST | 3700 - 3799 17TH ST | 3700 - 3799 17TH ST | 3700 17TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 14864 | N/A | Point | - | - | - | - | S235592 | ROCKAWAY AVE: LAGUNA HONDA BLV | - | F | F | - | F | 22445000 | 22445000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LAGUNA HONDA BLVD \ ULLOA ST | LAGUNA HONDA BLVD \ ULLOA ST | 67211 | 67211 | 37.74348245 | -122.45590515 | ROCKAWAY AVE \ LAGUNA HONDA BLVD \ ULLOA ST | ROCKAWAY AVE \ LAGUNA HONDA BLVD \ ULLOA ST | 1742423269000 | middleware_editor | STOP | LAGUNA HONDA BLVD \ ULLOA ST intersection | - | - | - | - | - | - | - | 31939 | - | -122.45590515 | 37.74348245 | - | 908434800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1493121180000 | ROCKAWAY AVE | - | - | - | - | - | - |
| 14865 | N/A | Point | - | - | - | - | S235593 | ULLOA ST: LAGUNA HONDA BLVD \ | - | F | F | - | F | 22445000 | 22445000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LAGUNA HONDA BLVD \ ULLOA ST | LAGUNA HONDA BLVD \ ULLOA ST | 67212 | 67212 | 37.74348245 | -122.45590515 | ROCKAWAY AVE \ LAGUNA HONDA BLVD \ ULLOA ST | ROCKAWAY AVE \ LAGUNA HONDA BLVD \ ULLOA ST | 1742423030000 | middleware_editor | STOP | LAGUNA HONDA BLVD \ ULLOA ST intersection | - | - | - | - | - | - | - | 31940 | - | -122.45590515 | 37.74348245 | - | - | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1493121480000 | ROCKAWAY AVE | - | - | - | - | - | - |
| 14866 | N/A | Point | - | - | - | - | S235597 | LAGUNA HONDA BLVD: ROCKAWAY AV | - | F | F | - | F | 22445000 | 22445000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LAGUNA HONDA BLVD \ ULLOA ST | LAGUNA HONDA BLVD \ ULLOA ST | 67214 | 67214 | 37.74348245 | -122.45590515 | ROCKAWAY AVE \ LAGUNA HONDA BLVD \ ULLOA ST | ROCKAWAY AVE \ LAGUNA HONDA BLVD \ ULLOA ST | 1742423207000 | middleware_editor | ALL WAY | LAGUNA HONDA BLVD \ ULLOA ST intersection | - | /ROCKAWAY | - | - | - | - | - | 31941 | 1494096780000 | -122.45590515 | 37.74348245 | - | 1622617200000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1493122560000 | ROCKAWAY AVE | - | - | - | - | - | - |
| 14867 | N/A | Point | 1 | 1 | 611 - 699 | - | S228904 | 611-699 BAY ST | 611-699 BAY ST | F | F | - | F | 2779000 | 2779000 | - | - | NORTH SIDE | - | - | - | - | COLUMBUS AVE | COLUMBUS AVE | 67216 | 67216 | 37.80508435 | -122.41787841 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM TUE STCL | COLUMBUS AVE to LEAVENWORTH ST (611 - 699) | - | EPL# 660 | - | - | - | - | - | 31942 | 1219622400000 | -122.41787841 | 37.80508435 | - | 1473897600000 | - | D2 | - | STREET CLEANING | REG | R30B(CA).0270 | 18X18 | SUP1 | LIGHT POLE | IS | 1473850020000 | BAY ST | 611 - 699 BAY ST | 611 - 699 BAY ST | 611 BAY ST | - | LEAVENWORTH ST | LEAVENWORTH ST |
| 14868 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S229203 | 1400-1499 CARROLL AVE | 1400-1499 CARROLL AVE | F | F | - | F | 3736000 | 3736000 | - | - | NORTH SIDE | - | - | - | - | INGALLS ST | INGALLS ST | 67217 | 67217 | 37.72338278 | -122.39055573 | - | - | 1710539427000 | MTA | NO IDLING BUSES AND TRUCKS (SYM) | INGALLS ST to JENNINGS ST (1400 - 1499) | - | 45' WEST OF INGALLS | - | - | - | - | - | 31943 | 1349308800000 | -122.39055573 | 37.72338278 | - | 1477958400000 | - | D10 | - | OTHER REGULATORY | REG | SR62(SF).0002 | 24X30 | SUP1 | 2IN IRON POST | IS | 1474879740000 | CARROLL AVE | 1400 - 1499 CARROLL AVE | 1400 - 1499 CARROLL AVE | 1400 CARROLL AVE | - | JENNINGS ST | JENNINGS ST |
| 14869 | N/A | Point | 1 | 1 | 2400 - 2499 | - | S229207 | 2400-2499 INGALLS ST | 2400-2499 INGALLS ST | F | F | - | F | 7234000 | 7234000 | - | - | WEST SIDE | - | - | - | - | ARMSTRONG AVE | ARMSTRONG AVE | 67218 | 67218 | 37.72379093 | -122.38877445 | - | - | 1710539427000 | MTA | NO IDLING BUSES AND TRUCKS (SYM) | ARMSTRONG AVE to BANCROFT AVE (2400 - 2499) | - | 100' SOUTH OF ARMSTRONG AVE | - | - | - | - | - | 31944 | 1477925820000 | -122.38877445 | 37.72379093 | - | 1477872000000 | - | D10 | - | OTHER REGULATORY | REG | SR62(SF).0002 | 24X30 | SUP1 | 2IN IRON POST | IS | 1474880880000 | INGALLS ST | 2400 - 2499 INGALLS ST | 2400 - 2499 INGALLS ST | 2400 INGALLS ST | - | BANCROFT AVE | BANCROFT AVE |
| 14870 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S229209 | 2300-2399 INGALLS ST | 2300-2399 INGALLS ST | F | F | - | F | 7233000 | 7233000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | YOSEMITE AVE | YOSEMITE AVE | 67219 | 67219 | 37.72441467 | -122.38821335 | - | - | 1721158487000 | middleware_editor | NO IDLING BUSES AND TRUCKS (SYM) | YOSEMITE AVE to ARMSTRONG AVE (2300 - 2399) | - | 10' NORTH OF ARMSTRONG | - | - | - | - | - | 31945 | 1477927980000 | -122.38821335 | 37.72441467 | - | 1477872000000 | - | D10 | - | OTHER REGULATORY | REG | SR62(SF).0002 | 24X30 | SUP1 | 2IN IRON POST | IS | 1474881240000 | INGALLS ST | 2300 - 2399 INGALLS ST | 2300 - 2399 INGALLS ST | 2300 INGALLS ST | - | ARMSTRONG AVE | ARMSTRONG AVE |
| 14871 | N/A | Point | - | - | - | - | S235452 | ARELIOUS WALKER DR: FITZGERALD | - | F | F | - | F | 33220000 | 33220000 | - | - | SOUTH WEST CORNER | - | - | - | - | FITZGERALD AVE | ARELIOUS WALKER DR | 68158 | 68158 | 37.71779708 | -122.38569654 | ARELIOUS WALKER DR \ FITZGERALD AVE | FITZGERALD AVE \ ARELIOUS WALKER DR | 1710539427000 | MTA | FITZGERALD AVE | ARELIOUS WALKER DR intersection | - | - | - | - | - | - | - | 31946 | 1492506360000 | -122.38569654 | 37.71779708 | - | 1492473600000 | - | D10 | - | STREET NAME | GUIDE | D3-1.0666 | 36X08 | SUP1 | LIGHT POLE | IS | 1492699680000 | FITZGERALD AVE | - | - | - | - | - | - |
| 14872 | N/A | Point | - | - | - | - | S235453 | ARELIOUS WALKER DR: EGBERT AVE | - | F | F | - | F | 20092000 | 20092000 | - | - | NORTH WEST CORNER | - | - | - | - | ARELIOUS WALKER DR | EGBERT AVE | 68159 | 68159 | 37.71840736 | -122.38515706 | EGBERT AVE \ ARELIOUS WALKER DR | ARELIOUS WALKER DR \ EGBERT AVE | 1710539427000 | MTA | EGBERT AVE | EGBERT AVE intersection | - | - | - | - | - | - | - | 31947 | 1493655060000 | -122.38515706 | 37.71840736 | - | 1493596800000 | - | D10 | - | STREET NAME | GUIDE | D3-1.0584 | 36X08 | SUP1 | LIGHT POLE | IS | 1492699920000 | ARELIOUS WALKER DR | - | - | - | - | - | - |
| 14873 | N/A | Point | - | - | - | - | S235476 | MISSION ST: NEY ST | - | F | F | - | F | 21696000 | 21696000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | NEY ST | NEY ST | 68160 | 68160 | 37.72993059 | -122.43011092 | MISSION ST \ NEY ST | MISSION ST \ NEY ST | 1752608076000 | middleware_editor | PEDESTRIAN (SYM) | NEY ST intersection | - | - | - | - | - | - | - | 31948 | 1493141400000 | -122.43011092 | 37.72993059 | - | 1493103600000 | 1752599400000 | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | RETD | 1492775220000 | MISSION ST | - | - | - | - | - | - |
| 14874 | N/A | Point | - | - | - | - | S235477 | MISSION ST: NEY ST | - | F | F | - | F | 21696000 | 21696000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | NEY ST | NEY ST | 68161 | 68161 | 37.72993059 | -122.43011092 | MISSION ST \ NEY ST | MISSION ST \ NEY ST | 1752608086000 | middleware_editor | PEDESTRIAN (SYM) | NEY ST intersection | - | - | - | - | - | - | - | 31949 | 1493145900000 | -122.43011092 | 37.72993059 | - | 1493103600000 | 1752601200000 | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | RETD | 1492775280000 | MISSION ST | - | - | - | - | - | - |
| 14875 | N/A | Point | - | - | - | - | S232665 | BEALE ST: BRYANT ST | - | T | T | - | F | 23599000 | 23599000 | - | - | NORTH WEST CORNER | - | - | - | - | BEALE ST \ BRYANT ST | BEALE ST \ DELANCEY ST | 68162 | 68162 | 37.78622378 | -122.38963664 | DELANCEY ST \ BEALE ST \ BRYANT ST | BRYANT ST \ BEALE ST \ DELANCEY ST | 1710539427000 | MTA | BEALE ST | BEALE ST \ DELANCEY ST intersection | - | 500 | - | - | - | - | - | 31950 | 1496329740000 | -122.38963664 | 37.78622378 | - | 1496275200000 | - | D6 | - | STREET NAME | GUIDE | D3-1.0184 | 36X08 | SUP1 | SIGNAL POLE | IS | 1484656800000 | BRYANT ST | - | - | - | - | - | - |
| 14876 | N/A | Point | - | - | - | - | S235827 | SUNSET BLVD: WAWONA ST | - | F | F | - | F | 23367000 | 23367000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | - | - | - | - | SUNSET BLVD | SUNSET BLVD | 68163 | 68163 | 37.73663509 | -122.49405382 | WAWONA ST \ SUNSET BLVD | WAWONA ST \ SUNSET BLVD | 1714599401000 | middleware_editor | NO LEFT TURN (SYM) | SUNSET BLVD intersection | - | S-LINE | - | - | - | - | - | 31951 | 1494935880000 | -122.49405382 | 37.73663509 | - | 1714556460000 | - | D4 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1493812080000 | WAWONA ST | - | - | - | - | - | - |
| 14877 | N/A | Point | - | - | - | - | S235834 | SUNSET BLVD: RIVERA ST | - | F | F | - | F | 23411000 | 23411000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | SUNSET BLVD | SUNSET BLVD | 68164 | 68164 | 37.74595154 | -122.49470571 | RIVERA ST \ SUNSET BLVD | RIVERA ST \ SUNSET BLVD | 1710539427000 | MTA | NO LEFT TURN (SYM) | SUNSET BLVD intersection | - | - | - | - | - | - | - | 31952 | - | -122.49470571 | 37.74595154 | - | - | - | D4 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1493818200000 | RIVERA ST | - | - | - | - | - | - |
| 14878 | N/A | Point | 1 | 1 | 600 - 699 | - | S231932 | 600-699 9TH ST | 600-699 09TH ST | F | F | - | F | 460000 | 460000 | - | - | EAST SIDE | - | - | - | - | BRANNAN ST | BRANNAN ST | 68173 | 68173 | 37.76975616 | -122.40660743 | - | - | 1710539427000 | MTA | 2 HR PRK 7AM-6PM EXC SUN | BRANNAN ST to DIVISION ST (600 - 699) | - | 36FT SOUTH OF BRANNAN ST | - | - | - | - | - | 31953 | 1108598400000 | -122.40660743 | 37.76975616 | - | 1482364800000 | - | D6 | - | PARKING | REG | R32(CA).0071 | 18X18 | SUP1 | 2IN IRON POST | IS | 1482246120000 | 09TH ST | 600 - 699 9TH ST | 600 - 699 09TH ST | 600 9TH ST | - | DIVISION ST | DIVISION ST |
| 14879 | N/A | Point | 1 | 1 | 3700 - 3799 | - | S233413 | 3700-3799 LAWTON ST | 3700-3799 LAWTON ST | F | F | - | F | 8224000 | 8224000 | - | - | SOUTH SIDE | - | - | - | - | 43RD AVE | 43RD AVE | 68219 | 68219 | 37.75681102 | -122.50298703 | - | - | 1746564131000 | middleware_editor | FG 300 UR DELINEATOR (W) | 43RD AVE to 44TH AVE (3700 - 3799) | - | 3FT.EAST OF 43RD AVE.(18' FROM CURB) | - | - | - | - | - | 31954 | 1488924000000 | -122.50298703 | 37.75681102 | - | 1488873600000 | - | D4 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1486553760000 | LAWTON ST | 3700 - 3799 LAWTON ST | 3700 - 3799 LAWTON ST | 3700 LAWTON ST | - | 44TH AVE | 44TH AVE |
| 14880 | N/A | Point | 1 | 1 | 10 - 98 | - | S234858 | 0-199 SOUTH PARK | 10-98 SOUTH PARK | F | F | - | F | 12009101 | 12009101 | - | - | CENTER ISLAND | - | - | - | - | SOUTH PARK | SOUTH PARK | 68221 | 68221 | 37.781975 | -122.39369893 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM MON STCL | SOUTH PARK to JACK LONDON ALY (10 - 98) -- NORTH -- | - | OPP #35 | - | - | - | - | - | 31955 | - | -122.39369893 | 37.781975 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0048 | 18X18 | SUP1 | 2IN IRON POST | IS | 1491303600000 | SOUTH PARK | 10 - 98 SOUTH PARK | 10 - 98 SOUTH PARK | 10 SOUTH PARK | - | JACK LONDON ALY | JACK LONDON ALY |
| 14881 | N/A | Point | - | - | - | - | S234663 | FELL ST: GOUGH ST | - | T | T | - | F | 25916000 | 25916000 | - | - | SOUTH WEST CORNER | - | - | - | - | FELL ST | GOUGH ST | 68232 | 68232 | 37.77594986 | -122.42278763 | GOUGH ST \ FELL ST | FELL ST \ GOUGH ST | 1726239777000 | middleware_editor | FELL ST | GOUGH ST intersection | - | FELL (300) | - | - | - | - | - | 31956 | - | -122.42278763 | 37.77594986 | - | - | - | D5 | - | STREET NAME | GUIDE | D3-1.0656 | 36X08 | SUP1 | LIGHT POLE | IS | 1490699040000 | FELL ST | - | - | - | - | - | - |
| 14882 | N/A | Point | - | - | - | - | S234664 | GOUGH ST: OAK ST | - | F | F | - | F | 25906000 | 25906000 | - | - | SOUTH EAST CORNER | - | - | - | - | GOUGH ST | GOUGH ST | 68233 | 68233 | 37.7750207 | -122.42259804 | OAK ST \ GOUGH ST | OAK ST \ GOUGH ST | 1726239902000 | middleware_editor | GOUGH ST | GOUGH ST intersection | - | GOUGH (200) | - | - | - | - | - | 31957 | - | -122.42259804 | 37.7750207 | - | - | - | D5 | - | STREET NAME | GUIDE | D3-1.0757 | 36X08 | SUP1 | LIGHT POLE | IS | 1490701620000 | OAK ST | - | - | - | - | - | - |
| 14883 | N/A | Point | - | - | - | - | S234666 | OAK ST: GOUGH ST | - | F | F | - | F | 25906000 | 25906000 | - | - | SOUTH EAST CORNER | - | - | - | - | GOUGH ST | GOUGH ST | 68234 | 68234 | 37.7750207 | -122.42259804 | OAK ST \ GOUGH ST | OAK ST \ GOUGH ST | 1726239894000 | middleware_editor | OAK ST | GOUGH ST intersection | - | OAK (200) | - | - | - | - | - | 31958 | - | -122.42259804 | 37.7750207 | - | - | - | D5 | - | STREET NAME | GUIDE | D3-1.1297 | 36X08 | SUP1 | LIGHT POLE | IS | 1490701920000 | OAK ST | - | - | - | - | - | - |
| 14884 | N/A | Point | - | - | - | - | S234417 | COLLINS ST: EUCLID AVE | - | F | F | - | F | 26912000 | 26912000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | COLLINS ST | COLLINS ST | 71029 | 71029 | 37.7844809 | -122.45013569 | EUCLID AVE \ COLLINS ST | EUCLID AVE \ COLLINS ST | 1715278418000 | middleware_editor | ALL WAY | COLLINS ST intersection | - | 0 / 00 | - | - | - | - | - | 31959 | -398736000000 | -122.45013569 | 37.7844809 | - | 1492473600000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1489664880000 | EUCLID AVE | - | - | - | - | - | - |
| 14885 | N/A | Point | - | - | - | - | S234418 | COLLINS ST: EUCLID AVE | - | F | F | - | F | 26912000 | 26912000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | COLLINS ST | COLLINS ST | 71030 | 71030 | 37.7844809 | -122.45013569 | EUCLID AVE \ COLLINS ST | EUCLID AVE \ COLLINS ST | 1715278431000 | middleware_editor | ALL WAY | COLLINS ST intersection | - | 0 / 00 | - | - | - | - | - | 31960 | -398736000000 | -122.45013569 | 37.7844809 | - | 1492473600000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1489665000000 | EUCLID AVE | - | - | - | - | - | - |
| 14886 | N/A | Point | - | - | - | - | S234419 | EUCLID AVE: COLLINS ST | - | F | F | - | F | 26912000 | 26912000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | COLLINS ST | COLLINS ST | 71031 | 71031 | 37.7844809 | -122.45013569 | EUCLID AVE \ COLLINS ST | EUCLID AVE \ COLLINS ST | 1715278428000 | middleware_editor | ALL WAY | COLLINS ST intersection | - | 00 / 00 | - | - | - | - | - | 31961 | -398736000000 | -122.45013569 | 37.7844809 | - | 1492473600000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1489665180000 | EUCLID AVE | - | - | - | - | - | - |
| 14887 | N/A | Point | - | - | - | - | S234471 | SAINT JOSEPHS AVE: ELLIS ST \ | - | F | F | - | F | 26361000 | 26361000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 71032 | 71032 | 37.78131006 | -122.44078384 | \SAINT JOSEPHS AVE: ELLIS ST \ | BRODERICK ST \ ELLIS ST | 1710539427000 | MTA | ALL WAY | ELLIS ST intersection | - | - | - | - | - | - | - | 31962 | 1493942400000 | -122.44078384 | 37.78131006 | - | 1493942400000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1489999080000 | BRODERICK ST | - | - | - | - | - | - |
| 14888 | N/A | Point | - | - | - | - | S234472 | SAINT JOSEPHS AVE: ELLIS ST \ | - | F | F | - | F | 26361000 | 26361000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 71033 | 71033 | 37.78131006 | -122.44078384 | \SAINT JOSEPHS AVE: ELLIS ST \ | BRODERICK ST \ ELLIS ST | 1710539427000 | MTA | STOP | ELLIS ST intersection | - | - | - | - | - | - | - | 31963 | - | -122.44078384 | 37.78131006 | - | - | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1489999200000 | BRODERICK ST | - | - | - | - | - | - |
| 14889 | N/A | Point | - | - | - | - | S234473 | SAINT JOSEPHS AVE: ELLIS ST \ | - | F | F | - | F | 26361000 | 26361000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 71034 | 71034 | 37.78131006 | -122.44078384 | \SAINT JOSEPHS AVE: ELLIS ST \ | BRODERICK ST \ ELLIS ST | 1710539427000 | MTA | ALL WAY | ELLIS ST intersection | - | - | - | - | - | - | - | 31964 | 1493942400000 | -122.44078384 | 37.78131006 | - | 1493942400000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1489999320000 | BRODERICK ST | - | - | - | - | - | - |
| 14890 | N/A | Point | - | - | - | - | S234474 | ELLIS ST: SAINT JOSEPHS AVE \ | - | F | F | - | F | 26361000 | 26361000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 71035 | 71035 | 37.78131006 | -122.44078384 | \ELLIS ST: SAINT JOSEPHS AVE \ | BRODERICK ST \ ELLIS ST | 1710539427000 | MTA | STOP | ELLIS ST intersection | - | X IS IS SAINT JOSEPH | - | - | - | - | - | 31965 | - | -122.44078384 | 37.78131006 | - | - | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1489999500000 | BRODERICK ST | - | - | - | - | - | - |
| 14891 | N/A | Point | - | - | - | - | S234476 | SAINT JOSEPHS AVE: ELLIS ST \ | - | F | F | - | F | 26361000 | 26361000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BRODERICK ST | ELLIS ST | 71036 | 71036 | 37.78131006 | -122.44078384 | ELLIS ST \ BRODERICK ST | BRODERICK ST \ ELLIS ST | 1710539427000 | MTA | STOP | ELLIS ST intersection | - | - | - | - | - | - | - | 31966 | - | -122.44078384 | 37.78131006 | - | 1708613820000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1489999740000 | BRODERICK ST | - | - | - | - | - | - |
| 14892 | N/A | Point | - | - | - | - | S234477 | SAINT JOSEPHS AVE: ELLIS ST \ | - | F | F | - | F | 26361000 | 26361000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 71037 | 71037 | 37.78131006 | -122.44078384 | \SAINT JOSEPHS AVE: ELLIS ST \ | BRODERICK ST \ ELLIS ST | 1710539427000 | MTA | ALL WAY | ELLIS ST intersection | - | - | - | - | - | - | - | 31967 | 1493942400000 | -122.44078384 | 37.78131006 | - | 1493942400000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1489999800000 | BRODERICK ST | - | - | - | - | - | - |
| 14893 | N/A | Point | - | - | - | - | S234479 | SPRUCE ST: MAYFAIR DR | - | F | F | - | F | 12062000 | 26944000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | SPRUCE ST | 71038 | 71038 | 37.78572237 | -122.45325549 | - | MAYFAIR DR \ SPRUCE ST | 1737558952000 | middleware_editor | ALL WAY | SPRUCE ST intersection | - | - | - | - | - | - | - | 31968 | 874368000000 | -122.45325549 | 37.78572237 | - | 1737473640000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1490000640000 | MAYFAIR DR | 500 - 528 SPRUCE ST | - | - | - | MAYFAIR DR | - |
| 14894 | N/A | Point | - | - | - | - | S234482 | SAINT JOSEPHS AVE: ELLIS ST \ | - | F | F | - | F | 26361000 | 26361000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 71039 | 71039 | 37.78131006 | -122.44078384 | \SAINT JOSEPHS AVE: ELLIS ST \ | BRODERICK ST \ ELLIS ST | 1710539427000 | MTA | ALL WAY | ELLIS ST intersection | - | X ST IS SPRUCE | - | - | - | - | - | 31969 | 1492646400000 | -122.44078384 | 37.78131006 | - | 1492646400000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1490001120000 | BRODERICK ST | - | - | - | - | - | - |
| 14895 | N/A | Point | - | - | - | - | S234483 | SAINT JOSEPHS AVE: ELLIS ST \ | - | F | F | - | F | 26361000 | 26361000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 71040 | 71040 | 37.78131006 | -122.44078384 | \SAINT JOSEPHS AVE: ELLIS ST \ | BRODERICK ST \ ELLIS ST | 1710539427000 | MTA | ALL WAY | ELLIS ST intersection | - | X ST IS SPRUCE | - | - | - | - | - | 31970 | 1492646400000 | -122.44078384 | 37.78131006 | - | 1492646400000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1490001240000 | BRODERICK ST | - | - | - | - | - | - |
| 14896 | N/A | Point | - | - | - | - | S234484 | LYON ST: LOMBARD ST | - | F | F | - | F | 27022000 | 27022000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LOMBARD ST | LOMBARD ST | 71041 | 71041 | 37.79845923 | -122.44730304 | LYON ST \ LOMBARD ST | LYON ST \ LOMBARD ST | 1736527869000 | middleware_editor | ALL WAY | LOMBARD ST intersection | - | 0 / 0 | - | - | - | - | - | 31971 | -359510400000 | -122.44730304 | 37.79845923 | - | 1601337600000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1490002080000 | LYON ST | - | - | - | - | - | - |
| 14897 | N/A | Point | - | - | - | - | S232240 | CAPITOL AVE: FARALLONES ST | - | F | F | - | F | 22473000 | 22473000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FARALLONES ST | CAPITOL AVE | 71042 | 71042 | 37.7140553 | -122.45903539 | CAPITOL AVE \ FARALLONES ST | FARALLONES ST \ CAPITOL AVE | 1720487447000 | middleware_editor | ALL WAY | CAPITOL AVE intersection | - | 0 / 0 | - | - | - | - | - | 31972 | 221097600000 | -122.45903539 | 37.7140553 | - | - | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1483437480000 | FARALLONES ST | - | - | - | - | - | - |
| 14898 | N/A | Point | - | - | - | - | S232243 | CAPITOL AVE: FARALLONES ST | - | F | F | - | F | 22473000 | 22473000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FARALLONES ST | CAPITOL AVE | 71043 | 71043 | 37.7140553 | -122.45903539 | CAPITOL AVE \ FARALLONES ST | FARALLONES ST \ CAPITOL AVE | 1750714100000 | middleware_editor | ALL WAY | CAPITOL AVE intersection | - | 0 / 0 | - | - | - | - | - | 31973 | 221126400000 | -122.45903539 | 37.7140553 | - | 1750705200000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1483437720000 | FARALLONES ST | - | - | - | - | - | - |
| 14899 | N/A | Point | - | - | - | - | S232255 | SUNSET BLVD: SANTIAGO ST | - | T | T | - | F | 23407000 | 23407000 | - | - | CENTER ISLAND, N LINE, EASTBOUND | - | - | - | - | SANTIAGO ST | SUNSET BLVD | 71046 | 71046 | 37.74409186 | -122.49457384 | SUNSET BLVD \ SANTIAGO ST | SANTIAGO ST \ SUNSET BLVD | 1710539427000 | MTA | SUNSET BLVD | SUNSET BLVD intersection | - | - | - | - | - | - | - | 31974 | - | -122.49457384 | 37.74409186 | - | - | - | D4 | - | STREET NAME | GUIDE | D3-2.0329 | 72X18 | SUP2 | SIGNAL POLE | IS | 1483441320000 | SANTIAGO ST | - | - | - | - | - | - |
| 14900 | N/A | Point | 1 | 1 | 200 - 299 | - | S232347 | 200-299 DUBOCE AVE | 200-299 DUBOCE AVE | F | F | - | F | 4983000 | 4983000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | GUERRERO ST | GUERRERO ST | 71047 | 71047 | 37.76967958 | -122.42544696 | - | - | 1753470257000 | middleware_editor | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | GUERRERO ST to BUCHANAN ST \ MARKET ST (200 - 299) | - | @ EPL# 214 | - | - | - | - | - | 31975 | - | -122.42544696 | 37.76967958 | - | - | - | D8 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | 2IN IRON POST | IS | 1483631700000 | DUBOCE AVE | 200 - 299 DUBOCE AVE | 200 - 299 DUBOCE AVE | 200 DUBOCE AVE | - | BUCHANAN ST \ MARKET ST | BUCHANAN ST \ MARKET ST |
| 14901 | N/A | Point | - | - | - | - | S232227 | ARCH ST: SARGENT ST | - | F | F | - | F | 22695000 | 22695000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SARGENT ST | SARGENT ST | 71048 | 71048 | 37.71610778 | -122.46711576 | ARCH ST \ SARGENT ST | ARCH ST \ SARGENT ST | 1710539427000 | MTA | ALL WAY | SARGENT ST intersection | - | X ST IS SARGENT | - | - | - | - | - | 31976 | 1488805200000 | -122.46711576 | 37.71610778 | - | 1488758400000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1483435740000 | ARCH ST | - | - | - | - | - | - |
| 14902 | N/A | Point | - | - | - | - | S243313 | GEARY BLVD: COLLINS ST | - | F | F | - | F | 26908000 | 26908000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | COLLINS ST | GEARY BLVD | 74215 | 74215 | 37.7821166 | -122.4500923 | GEARY BLVD \ COLLINS ST | COLLINS ST \ GEARY BLVD | 1714571530000 | middleware_editor | NO LEFT TURN (SYM) | GEARY BLVD intersection | - | - | - | - | - | - | - | 31977 | - | -122.4500923 | 37.7821166 | - | - | 1714476480000 | D1 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | RETD | 1519384320000 | COLLINS ST | - | - | - | - | - | - |
| 14903 | N/A | Point | - | - | - | - | S243314 | GEARY BLVD: PARKER AVE | - | F | F | - | F | 26930000 | 26930000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | PARKER AVE | GEARY BLVD | 74216 | 74216 | 37.78159882 | -122.45417599 | GEARY BLVD \ PARKER AVE | PARKER AVE \ GEARY BLVD | 1714571572000 | middleware_editor | NO LEFT TURN (SYM) | GEARY BLVD intersection | - | - | - | - | - | - | - | 31978 | - | -122.45417599 | 37.78159882 | - | - | 1714487940000 | D1 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | RETD | 1519384740000 | PARKER AVE | - | - | - | - | - | - |
| 14904 | N/A | Point | - | - | - | - | S243315 | GEARY BLVD: ARGUELLO BLVD | - | F | F | - | F | 27230000 | 27230000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | ARGUELLO BLVD | GEARY BLVD | 74217 | 74217 | 37.78125706 | -122.45885866 | GEARY BLVD \ ARGUELLO BLVD | ARGUELLO BLVD \ GEARY BLVD | 1714774304000 | middleware_editor | NO LEFT TURN (SYM) | GEARY BLVD intersection | - | - | - | - | - | - | - | 31979 | - | -122.45885866 | 37.78125706 | - | - | 1714733280000 | D1 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | RETD | 1519385160000 | ARGUELLO BLVD | - | - | - | - | - | - |
| 14905 | N/A | Point | - | - | - | - | S243316 | GEARY BLVD: ARGUELLO BLVD | - | F | F | - | F | 27230000 | 27230000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | ARGUELLO BLVD | GEARY BLVD | 74218 | 74218 | 37.78125706 | -122.45885866 | GEARY BLVD \ ARGUELLO BLVD | ARGUELLO BLVD \ GEARY BLVD | 1714774325000 | middleware_editor | NO LEFT TURN (SYM) | GEARY BLVD intersection | - | - | - | - | - | - | - | 31980 | - | -122.45885866 | 37.78125706 | - | - | 1714734180000 | D1 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | RETD | 1519385220000 | ARGUELLO BLVD | - | - | - | - | - | - |
| 14906 | N/A | Point | - | - | - | - | S243317 | GEARY BLVD: ARGUELLO BLVD | - | F | F | - | F | 27230000 | 27230000 | - | - | CENTER ISLAND, W LINE, WESTBOUND | - | - | - | - | ARGUELLO BLVD | GEARY BLVD | 74219 | 74219 | 37.78125706 | -122.45885866 | GEARY BLVD \ ARGUELLO BLVD | ARGUELLO BLVD \ GEARY BLVD | 1714774302000 | middleware_editor | NO LEFT TURN (SYM) | GEARY BLVD intersection | - | - | - | - | - | - | - | 31981 | - | -122.45885866 | 37.78125706 | - | - | 1714734120000 | D1 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | RETD | 1519385280000 | ARGUELLO BLVD | - | - | - | - | - | - |
| 14907 | N/A | Point | - | - | - | - | S243318 | GEARY BLVD: 2ND AVE | - | F | F | - | F | 27231000 | 27231000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | GEARY BLVD | GEARY BLVD | 74220 | 74220 | 37.78121348 | -122.45999966 | 2ND AVE \ GEARY BLVD | 02ND AVE \ GEARY BLVD | 1714658192000 | middleware_editor | NO LEFT TURN (SYM) | GEARY BLVD intersection | - | - | - | - | - | - | - | 31982 | - | -122.45999966 | 37.78121348 | - | - | 1714566360000 | D1 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | RETD | 1519385460000 | 02ND AVE | - | - | - | - | - | - |
| 14908 | N/A | Point | - | - | - | - | S236456 | PORTOLA DR: BURNETT AVE \ DIAM | - | T | T | - | F | 22341000 | 22341000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BURNETT AVE \ DIAMOND HEIGHTS BLVD | BURNETT AVE \ DIAMOND HEIGHTS BLVD | 74224 | 74224 | 37.74694537 | -122.44484723 | PORTOLA DR \ BURNETT AVE \ DIAMOND HEIGHTS BLVD | PORTOLA DR \ BURNETT AVE \ DIAMOND HEIGHTS BLVD | 1712863534000 | middleware_editor | CLIPPER (45 RA)/DIAMOND HEIGHTS (RA) | BURNETT AVE \ DIAMOND HEIGHTS BLVD intersection | - | BELOW "DIAMOND HEIGHTS BLVD" SIGN | - | - | - | - | - | 31983 | - | -122.44484723 | 37.74694537 | - | - | - | D8 | - | OTHER GUIDE | GUIDE | G-C(SF).0059 | 36X72 | SUP2 | LIGHT POLE | IS | 1496140320000 | PORTOLA DR | - | - | - | - | - | - |
| 14909 | N/A | Point | - | - | - | - | S237239 | DARTMOUTH ST: OLMSTEAD ST | - | F | F | - | F | 20854000 | 20854000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | OLMSTEAD ST | DARTMOUTH ST | 74225 | 74225 | 37.72076874 | -122.40950657 | DARTMOUTH ST \ OLMSTEAD ST | OLMSTEAD ST \ DARTMOUTH ST | 1710539427000 | MTA | HILL(SYM) | DARTMOUTH ST intersection | - | ABOVE "PREPARE TO STOP FOR VEH" SIGN | - | - | - | - | - | 31984 | - | -122.40950657 | 37.72076874 | - | - | - | D9 | - | OTHER WARNING | WARNING | W7-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1499248800000 | OLMSTEAD ST | - | - | - | - | - | - |
| 14910 | N/A | Point | - | - | - | - | S236034 | TARAVAL ST: 17TH AVE | - | T | T | - | F | 23179000 | 23179000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 17TH AVE | 74227 | 74227 | 37.74314359 | -122.47355342 | 17TH AVE \ TARAVAL ST | TARAVAL ST \ 17TH AVE | 1742851170000 | middleware_editor | LEFT LANE TRANSIT TAXIS & LEFT TURNS ONLY 24 HOURS | 17TH AVE intersection | - | NW | - | - | - | - | - | 31985 | 1528836540000 | -122.47355342 | 37.74314359 | - | 1742842800000 | - | D7 | - | TRANSIT ONLY(LEFT LANE) | REG | SR60-4(SF).0003 | 30X42 | SUP2 | LIGHT POLE | IS | 1494493860000 | TARAVAL ST | - | - | - | - | - | - |
| 14911 | N/A | Point | - | - | - | - | S236036 | TARAVAL ST: 18TH AVE | - | T | T | - | F | 12394000 | 23182000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 18TH AVE | 18TH AVE | 74228 | 74228 | 37.74309662 | -122.47462383 | - | TARAVAL ST \ 18TH AVE | 1742851172000 | middleware_editor | LEFT LANE TRANSIT TAXIS & LEFT TURNS ONLY 24 HOURS | 18TH AVE intersection | - | IFO 821 | - | - | - | - | - | 31986 | 1528831920000 | -122.47462383 | 37.74309662 | - | 1742843100000 | - | D7 | - | TRANSIT ONLY(LEFT LANE) | REG | SR60-4(SF).0003 | 30X42 | SUP2 | MUNI POLE | IS | 1494494760000 | TARAVAL ST | 800 - 899 TARAVAL ST | - | - | - | 19TH AVE | - |
| 14912 | N/A | Point | - | - | - | - | S236037 | TARAVAL ST: 19TH AVE | - | T | T | - | F | 23183000 | 23183000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 19TH AVE | 74229 | 74229 | 37.74305181 | -122.47564447 | 19TH AVE \ TARAVAL ST | TARAVAL ST \ 19TH AVE | 1722647184000 | middleware_editor | LEFT LANE TRANSIT TAXIS & LEFT TURNS ONLY 24 HOURS | 19TH AVE intersection | - | 75`WEST | - | - | - | - | - | 31987 | 1499084580000 | -122.47564447 | 37.74305181 | - | 1499040000000 | - | D4 | - | TRANSIT ONLY(LEFT LANE) | REG | SR60-4(SF).0003 | 30X42 | SUP2 | MUNI POLE | IS | 1494495120000 | TARAVAL ST | - | - | - | - | - | - |
| 14913 | N/A | Point | - | - | - | - | S236038 | TARAVAL ST: 20TH AVE | - | T | T | - | F | 23195000 | 23195000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 20TH AVE | 74230 | 74230 | 37.74300263 | -122.4767646 | 20TH AVE \ TARAVAL ST | TARAVAL ST \ 20TH AVE | 1743031759000 | middleware_editor | LEFT LANE TRANSIT TAXIS & LEFT TURNS ONLY 24 HOURS | 20TH AVE intersection | - | - | - | - | - | - | - | 31988 | 1499115300000 | -122.4767646 | 37.74300263 | - | 1743024120000 | - | D4 | - | TRANSIT ONLY(LEFT LANE) | REG | SR60-4(SF).0003 | 30X42 | SUP2 | MUNI POLE | IS | 1494495540000 | TARAVAL ST | - | - | - | - | - | - |
| 14914 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S236041 | 1100-1199 TARAVAL ST | 1100-1199 TARAVAL ST | T | T | - | F | 12397000 | 12397000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 21ST AVE | 21ST AVE | 74232 | 74232 | 37.74293211 | -122.47837052 | - | - | 1722963340000 | middleware_editor | LEFT LANE TRANSIT TAXIS & LEFT TURNS ONLY 24 HOURS | 21ST AVE to 22ND AVE (1100 - 1199) | - | 22`WEST | - | - | - | - | - | 31989 | 1499094120000 | -122.47837052 | 37.74293211 | - | 1499040000000 | - | D4 | - | TRANSIT ONLY(LEFT LANE) | REG | SR60-4(SF).0003 | 30X42 | SUP2 | MUNI POLE | IS | 1494496260000 | TARAVAL ST | 1100 - 1199 TARAVAL ST | 1100 - 1199 TARAVAL ST | 1100 TARAVAL ST | - | 22ND AVE | 22ND AVE |
| 14915 | N/A | Point | - | - | - | - | S236043 | TARAVAL ST: 22ND AVE | - | T | T | - | F | 23199000 | 23199000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 22ND AVE | 74233 | 74233 | 37.74290864 | -122.47890479 | 22ND AVE \ TARAVAL ST | TARAVAL ST \ 22ND AVE | 1743116649000 | middleware_editor | LEFT LANE TRANSIT TAXIS & LEFT TURNS ONLY 24 HOURS | 22ND AVE intersection | - | - | - | - | - | - | - | 31990 | 1499293260000 | -122.47890479 | 37.74290864 | - | 1499238000000 | - | D4 | - | TRANSIT ONLY(LEFT LANE) | REG | SR60-4(SF).0003 | 30X42 | SUP2 | SIGNAL POLE | IS | 1494496800000 | TARAVAL ST | - | - | - | - | - | - |
| 14916 | N/A | Point | - | - | - | - | S240206 | HALLAM ST: FOLSOM ST | - | F | F | - | F | 24275000 | 24275000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FOLSOM ST | FOLSOM ST | 74692 | 74692 | 37.77595323 | -122.40884575 | HALLAM ST \ FOLSOM ST | HALLAM ST \ FOLSOM ST | 1710539427000 | MTA | DEAD END | FOLSOM ST intersection | - | 000 --> SOUTH | - | - | - | - | - | 31991 | - | -122.40884575 | 37.77595323 | - | - | - | D6 | - | OTHER WARNING | WARNING | W14-1.0001 | 24X24 | SUP1 | 3IN IRON POST | IS | 1509962400000 | HALLAM ST | - | - | - | - | - | - |
| 14917 | N/A | Point | 1 | 1 | 400 - 499 | - | S240212 | 400-499 LARKIN ST | 400-499 LARKIN ST | F | F | - | F | 8124000 | 8124000 | - | - | WEST SIDE | - | - | - | - | GOLDEN GATE AVE | GOLDEN GATE AVE | 74693 | 74693 | 37.78191322 | -122.41724225 | - | - | 1753393068000 | middleware_editor | TANS EXC US MARSHAL SVC TRANSPORT VEH | GOLDEN GATE AVE to TURK ST (400 - 499) | - | 50' NORTH OF GOLDEN GATE | - | - | - | - | - | 31992 | 1510252980000 | -122.41724225 | 37.78191322 | - | 1510214400000 | - | D6 | - | OTHER REGULATORY | REG | R37(SF).0254 | 18X21 | SUP1 | 2IN IRON POST | IS | 1509964320000 | LARKIN ST | 400 - 499 LARKIN ST | 400 - 499 LARKIN ST | 400 LARKIN ST | - | TURK ST | TURK ST |
| 14918 | N/A | Point | - | - | - | - | S240231 | JONES ST: LOMBARD ST | - | F | F | - | F | 25521000 | 25521000 | - | - | NORTH WEST CORNER | - | - | - | - | JONES ST | JONES ST | 74694 | 74694 | 37.80241083 | -122.41632436 | LOMBARD ST \ JONES ST | LOMBARD ST \ JONES ST | 1710539427000 | MTA | JONES ST | JONES ST intersection | - | 2300 --> NORTH | - | - | - | - | - | 31993 | 82252800000 | -122.41632436 | 37.80241083 | - | 1586304000000 | - | D2 | - | STREET NAME | GUIDE | D3-1.0935 | 36X08 | SUP1 | UTILITY POLE | IS | 1509971700000 | LOMBARD ST | - | - | - | - | - | - |
| 14919 | N/A | Point | - | - | - | - | S240232 | JONES ST: LOMBARD ST | - | F | F | - | F | 25521000 | 25521000 | - | - | NORTH WEST CORNER | - | - | - | - | JONES ST | JONES ST | 74695 | 74695 | 37.80241083 | -122.41632436 | LOMBARD ST \ JONES ST | LOMBARD ST \ JONES ST | 1710539427000 | MTA | LOMBARD ST | JONES ST intersection | - | 900 --> WEST | - | - | - | - | - | 31994 | 82252800000 | -122.41632436 | 37.80241083 | - | 1512345600000 | - | D2 | - | STREET NAME | GUIDE | D3-1.1058 | 36X08 | SUP1 | UTILITY POLE | IS | 1509971880000 | LOMBARD ST | - | - | - | - | - | - |
| 14920 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S240233 | 1400-1499 VALLEJO ST | 1400-1499 VALLEJO ST | F | F | - | F | 13107000 | 13107000 | - | - | NORTH SIDE | - | - | - | - | LARKIN ST | LARKIN ST | 74696 | 74696 | 37.79700431 | -122.4211389 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-SAT EXC "AC" PERMITS | LARKIN ST to POLK ST (1400 - 1499) | - | 37' WEST OF LARKIN | - | - | - | - | - | 31995 | - | -122.4211389 | 37.79700431 | - | - | - | D3 | - | PARKING:RPP | REG | R32C(CA).0130 | 18X21 | SUP1 | 2IN IRON POST | IS | 1509974340000 | VALLEJO ST | 1400 - 1499 VALLEJO ST | 1400 - 1499 VALLEJO ST | 1400 VALLEJO ST | - | POLK ST | POLK ST |
| 14921 | N/A | Point | 1 | 1 | 945 - 999 | - | S243249 | 945-999 BAY ST | 945-999 BAY ST | F | F | - | F | 2783000 | 2783000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | NORTH VIEW CT | NORTH VIEW CT | 74697 | 74697 | 37.80441406 | -122.42300119 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EX SAT & SUN | NORTH VIEW CT to POLK ST (945 - 999) | - | 20' EAST OF POLK ST | - | - | - | - | - | 31996 | 1473120000000 | -122.42300119 | 37.80441406 | - | 1658361600000 | - | D2 | - | NO LEFT TURN | REG | R33A(CA).0026 | 30X42 | SUP1 | 2IN IRON POST | IS | 1519213020000 | BAY ST | 945 - 999 BAY ST | 945 - 999 BAY ST | 945 BAY ST | - | POLK ST | POLK ST |
| 14922 | N/A | Point | 1 | 1 | 945 - 999 | - | S243250 | 945-999 BAY ST | 945-999 BAY ST | F | F | - | F | 2783000 | 2783000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | NORTH VIEW CT | NORTH VIEW CT | 74698 | 74698 | 37.80441406 | -122.42300119 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EX SAT & SUN | NORTH VIEW CT to POLK ST (945 - 999) | - | 20' EAST OF POLK ST | - | - | - | - | - | 31997 | 1473120000000 | -122.42300119 | 37.80441406 | - | 1658361600000 | - | D2 | - | NO LEFT TURN | REG | R33A(CA).0026 | 30X42 | SUP1 | 2IN IRON POST | IS | 1519213020000 | BAY ST | 945 - 999 BAY ST | 945 - 999 BAY ST | 945 BAY ST | - | POLK ST | POLK ST |
| 14923 | N/A | Point | 1 | 1 | 36 - 118 | - | S246287 | 36-118 COSO AVE | 36-118 COSO AVE | F | F | - | F | 4451000 | 4451000 | - | - | SOUTH SIDE | - | - | - | - | COLERIDGE ST | COLERIDGE ST | 74703 | 74703 | 37.74601764 | -122.4179911 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "AA" PERMITS | COLERIDGE ST to MIRABEL AVE (36 - 118) | - | 10FT. EAST OF COLERIDGE ST. | - | - | - | - | - | 31998 | 1529058600000 | -122.4179911 | 37.74601764 | - | - | - | D9 | - | PARKING:RPP | REG | R32C(CA).0239 | 18X21 | SUP2 | 2IN IRON POST | IS | 1528698180000 | COSO AVE | 36 - 118 COSO AVE | 36 - 118 COSO AVE | 36 COSO AVE | - | MIRABEL AVE | MIRABEL AVE |
| 14924 | N/A | Point | 1 | 1 | 36 - 118 | - | S246289 | 36-118 COSO AVE | 36-118 COSO AVE | F | F | - | F | 4451000 | 4451000 | - | - | SOUTH SIDE | - | - | - | - | COLERIDGE ST | COLERIDGE ST | 74705 | 74705 | 37.74601764 | -122.4179911 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "AA" PERMITS | COLERIDGE ST to MIRABEL AVE (36 - 118) | - | AT EPL 130 COSO AVE. | - | - | - | - | - | 31999 | 1529065800000 | -122.4179911 | 37.74601764 | - | - | - | D9 | - | PARKING:RPP | REG | R32C(CA).0239 | 18X21 | SUP2 | 2IN IRON POST | IS | 1528699080000 | COSO AVE | 36 - 118 COSO AVE | 36 - 118 COSO AVE | 36 COSO AVE | - | MIRABEL AVE | MIRABEL AVE |
| 14925 | N/A | Point | 1 | 1 | 71 - 148 | - | S246290 | 71-148 COSO AVE | 71-148 COSO AVE | F | F | - | F | 4453000 | 4453000 | - | - | NORTH SIDE | - | - | - | - | LUNDYS LN \ MONTEZUMA ST | LUNDYS LN \ MONTEZUMA ST | 74706 | 74706 | 37.7457997 | -122.41744016 | - | - | 1734469096000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "AA" PERMITS | LUNDYS LN \ MONTEZUMA ST to PROSPECT AVE (71 - 148) | - | 25FT. EAST OF MONTEZUMA ST. | - | - | - | - | - | 32000 | 1529072100000 | -122.41744016 | 37.7457997 | - | - | - | D9 | - | PARKING:RPP | REG | R32C(CA).0239 | 18X21 | SUP2 | 2IN IRON POST | IS | 1528699440000 | COSO AVE | 71 - 148 COSO AVE | 71 - 148 COSO AVE | 71 COSO AVE | - | PROSPECT AVE | PROSPECT 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