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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51526 | N/A | Point | - | - | - | - | S266541 | THE EMBARCADERO: HOWARD ST | - | F | F | - | F | 24546000 | 24546000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | THE EMBARCADERO | THE EMBARCADERO | 98273 | 98273 | 37.79243605 | -122.39109612 | HOWARD ST \ THE EMBARCADERO | HOWARD ST \ THE EMBARCADERO | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | THE EMBARCADERO intersection | - | IN INTERSECTION BOX/ 10FT O.C 1FT IN | - | - | - | - | - | 68629 | 1304553600000 | -122.39109612 | 37.79243605 | - | 1598486400000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | TURNPIKE BASE | IS | 1595582280000 | HOWARD ST | - | - | - | - | - | - |
| 51527 | N/A | Point | - | 1 | 1600 - 1667 | RIGHT ARROW | S268026 | 1600-1667 MISSION ST | 1600-1667 MISSION ST | F | F | - | F | 9110000 | 9110000 | - | - | EAST SIDE | - | - | - | - | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | 98972 | 98972 | 37.77203117 | -122.41913215 | - | - | 1710539427000 | MTA | TA (SYM) PLO 8AM-6PM MON-SAT (5 MIN) | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE to PLUM ST (1600 - 1667) | - | 139' NORTH OF PLUM ST | - | - | - | - | - | 68630 | 1620053340000 | -122.41913215 | 37.77203117 | - | - | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0030 | 14X21 | SUP1 | 2IN IRON POST | IS | 1599737640000 | MISSION ST | 1600 - 1667 MISSION ST | 1600 - 1667 MISSION ST | 1600 MISSION ST | - | PLUM ST | PLUM ST |
| 51528 | N/A | Point | - | - | - | - | S268029 | HUNTERS POINT BLVD: INNES AVE | - | F | F | - | F | 33138000 | 33138000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HUNTERS POINT BLVD | HUNTERS POINT BLVD | 98974 | 98974 | 37.73249613 | -122.37663804 | INNES AVE \ HUNTERS POINT BLVD | INNES AVE \ HUNTERS POINT BLVD | 1710539427000 | MTA | BIKE LANE (SYM) + END | HUNTERS POINT BLVD intersection | - | - | - | - | - | - | - | 68631 | - | -122.37663804 | 37.73249613 | - | - | - | D10 | - | BIKE REG | REG | R81(CA)/R81B(CA).02 | 24X18 | SUP1 | 2IN IRON POST | IS | 1599750900000 | INNES AVE | - | - | - | - | - | - |
| 51529 | N/A | Point | 1 | 1 | 700 - 799 | - | S268192 | 700-799 BUSH ST | 700-799 BUSH ST | F | F | - | F | 3437000 | 3437000 | - | - | NORTH SIDE | - | - | - | - | POWELL ST | POWELL ST | 98975 | 98975 | 37.79005546 | -122.40960968 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM MON FRI STCL | POWELL ST to MASON ST (700 - 799) | - | IFO# 734 BUSH ST | - | - | - | - | - | 68632 | 1601639520000 | -122.40960968 | 37.79005546 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0236 | 18X18 | SUP1 | 2IN IRON POST | IS | 1600414740000 | BUSH ST | 700 - 799 BUSH ST | 700 - 799 BUSH ST | 700 BUSH ST | - | MASON ST | MASON ST |
| 51530 | N/A | Point | - | - | - | - | S261951 | ELLIS ST: POWELL ST | - | T | T | - | F | 24894000 | 24894000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POWELL ST | ELLIS ST | 98986 | 98986 | 37.78549156 | -122.40785252 | ELLIS ST \ POWELL ST | POWELL ST \ ELLIS ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | ELLIS ST intersection | - | - | - | - | - | - | - | 68633 | 1446681600000 | -122.40785252 | 37.78549156 | - | 1583539200000 | - | D3 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | SIGNAL POLE | IS | 1582723740000 | POWELL ST | - | - | - | - | - | - |
| 51531 | N/A | Point | - | - | - | - | S261953 | ELLIS ST: POWELL ST | - | T | T | - | F | 24894000 | 24894000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POWELL ST | ELLIS ST | 98987 | 98987 | 37.78549156 | -122.40785252 | ELLIS ST \ POWELL ST | POWELL ST \ ELLIS ST | 1710539427000 | MTA | ONE WAY (RA) | ELLIS ST intersection | - | - | - | - | - | - | - | 68634 | 1583576520000 | -122.40785252 | 37.78549156 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | SIGNAL POLE | IS | 1582723920000 | POWELL ST | - | - | - | - | - | - |
| 51532 | N/A | Point | - | - | - | - | S262393 | KIRKHAM ST: 19TH AVE | - | F | F | - | F | 27364000 | 27364000 | - | - | NORTH SIDE | - | - | - | - | 19TH AVE | 19TH AVE | 98988 | 98988 | 37.75983394 | -122.47681389 | KIRKHAM ST \ 19TH AVE | KIRKHAM ST \ 19TH AVE | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | 19TH AVE intersection | - | NEC ON 19TH AVE | - | - | - | - | - | 68635 | 1468195200000 | -122.47681389 | 37.75983394 | - | 1583884800000 | - | D4 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1583831280000 | KIRKHAM ST | - | - | - | - | - | - |
| 51533 | N/A | Point | - | - | - | - | S262400 | QUINTARA ST: 17TH AVE | - | F | F | - | F | 23193000 | 23193000 | - | - | NORTH WEST CORNER | - | - | - | - | QUINTARA ST | 17TH AVE | 98989 | 98989 | 37.7487395 | -122.47394569 | 17TH AVE \ QUINTARA ST | QUINTARA ST \ 17TH AVE | 1710539427000 | MTA | QUINTARA ST | 17TH AVE intersection | - | - | - | - | - | - | - | 68636 | 1266278400000 | -122.47394569 | 37.7487395 | - | 1585008000000 | - | D7 | - | STREET NAME | GUIDE | D3-1.1441 | 36X08 | SUP2 | 3IN IRON POST | IS | 1583832480000 | QUINTARA ST | - | - | - | - | - | - |
| 51534 | N/A | Point | - | - | - | - | S262405 | QUINTARA ST: 17TH AVE | - | F | F | - | F | 23193000 | 23193000 | - | - | NORTH WEST CORNER | - | - | - | - | QUINTARA ST | 17TH AVE | 98990 | 98990 | 37.7487395 | -122.47394569 | 17TH AVE \ QUINTARA ST | QUINTARA ST \ 17TH AVE | 1710539427000 | MTA | QUINTARA ST | 17TH AVE intersection | - | - | - | - | - | - | - | 68637 | 1266278400000 | -122.47394569 | 37.7487395 | - | 1585008000000 | - | D7 | - | STREET NAME | GUIDE | D3-1.1441 | 36X08 | SUP2 | 3IN IRON POST | IS | 1583833020000 | QUINTARA ST | - | - | - | - | - | - |
| 51535 | N/A | Point | - | - | - | - | S262409 | QUINTARA ST: 17TH AVE | - | F | F | - | F | 23193000 | 23193000 | - | - | NORTH WEST CORNER | - | - | - | - | QUINTARA ST | 17TH AVE | 98991 | 98991 | 37.7487395 | -122.47394569 | 17TH AVE \ QUINTARA ST | QUINTARA ST \ 17TH AVE | 1710539427000 | MTA | 28TH AVE | 17TH AVE intersection | - | - | - | - | - | - | - | 68638 | 1266278400000 | -122.47394569 | 37.7487395 | - | 1585008000000 | - | D7 | - | STREET NAME | GUIDE | D3-1.1933 | 36X08 | SUP2 | 3IN IRON POST | IS | 1583833140000 | QUINTARA ST | - | - | - | - | - | - |
| 51536 | N/A | Point | 1 | 1 | 600 - 699 | - | S262417 | 600-699 32ND AVE | 600-699 32ND AVE | F | F | - | F | 1704000 | 1704000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | ANZA ST | ANZA ST | 98994 | 98994 | 37.77689138 | -122.49202717 | - | - | 1729789979000 | middleware_editor | AHEAD | ANZA ST to BALBOA ST (600 - 699) | - | 20 FT NORTH OF BALBOA | - | - | - | - | - | 68639 | 1583928000000 | -122.49202717 | 37.77689138 | - | - | - | D1 | - | OTHER WARNING | WARNING | W(SF).0106 | 18X06 | SUP2 | 2IN IRON POST | IS | 1583838660000 | 32ND AVE | 600 - 699 32ND AVE | 600 - 699 32ND AVE | 600 32ND AVE | - | BALBOA ST | BALBOA ST |
| 51537 | N/A | Point | 1 | 1 | 600 - 699 | - | S262418 | 600-699 32ND AVE | 600-699 32ND AVE | F | F | - | F | 1704000 | 1704000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | ANZA ST | ANZA ST | 98995 | 98995 | 37.77689138 | -122.49202717 | - | - | 1729790889000 | middleware_editor | AHEAD | ANZA ST to BALBOA ST (600 - 699) | - | NPL 609 | - | - | - | - | - | 68640 | 1583928000000 | -122.49202717 | 37.77689138 | - | - | - | D1 | - | OTHER WARNING | WARNING | W(SF).0106 | 18X06 | SUP2 | 2IN IRON POST | IS | 1583838840000 | 32ND AVE | 600 - 699 32ND AVE | 600 - 699 32ND AVE | 600 32ND AVE | - | BALBOA ST | BALBOA ST |
| 51538 | N/A | Point | 1 | 1 | 600 - 699 | LEFT ARROW | S262181 | 600-699 7TH ST | 600-699 07TH ST | F | F | - | F | 376000 | 376000 | - | - | EAST SIDE | - | - | - | - | BRANNAN ST | BRANNAN ST | 98997 | 98997 | 37.77243412 | -122.40243088 | - | - | 1710539427000 | MTA | TANSAT | BRANNAN ST to TOWNSEND ST (600 - 699) | - | 20' SOUTH OF #615 DRIVEWAY. | - | - | - | - | - | 68641 | 953078400000 | -122.40243088 | 37.77243412 | - | 1590451200000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1583317620000 | 07TH ST | 600 - 699 7TH ST | 600 - 699 07TH ST | 600 7TH ST | - | TOWNSEND ST | TOWNSEND ST |
| 51539 | N/A | Point | 1 | 1 | 600 - 699 | - | S262184 | 600-699 7TH ST | 600-699 07TH ST | F | F | - | F | 376000 | 376000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | BRANNAN ST | BRANNAN ST | 98998 | 98998 | 37.77243412 | -122.40243088 | - | - | 1748014242000 | MALOPEZ | FG 300 UR DELINEATOR (W) | BRANNAN ST to TOWNSEND ST (600 - 699) | - | START 15' FROM S-LINE, X-WALK | - | - | - | - | 5 | 68642 | 953107200000 | -122.40243088 | 37.77243412 | - | 1591081200000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1583319540000 | 07TH ST | 600 - 699 7TH ST | 600 - 699 07TH ST | 600 7TH ST | - | TOWNSEND ST | TOWNSEND ST |
| 51540 | N/A | Point | 1 | 1 | 600 - 699 | - | S262190 | 600-699 7TH ST | 600-699 07TH ST | F | F | - | F | 376000 | 376000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | BRANNAN ST | BRANNAN ST | 98999 | 98999 | 37.77243412 | -122.40243088 | - | - | 1748020616000 | middleware_editor | FG 300 UR DELINEATOR (W) | BRANNAN ST to TOWNSEND ST (600 - 699) | - | NPL# 619 TO SPL# 619 | - | - | - | - | 3 | 68643 | 953107200000 | -122.40243088 | 37.77243412 | - | 1591081200000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1583321760000 | 07TH ST | 600 - 699 7TH ST | 600 - 699 07TH ST | 600 7TH ST | - | TOWNSEND ST | TOWNSEND ST |
| 51541 | N/A | Point | 1 | 1 | 600 - 699 | - | S262192 | 600-699 7TH ST | 600-699 07TH ST | F | F | - | F | 376000 | 376000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | BRANNAN ST | BRANNAN ST | 99000 | 99000 | 37.77243412 | -122.40243088 | - | - | 1748020709000 | middleware_editor | FG 300 UR DELINEATOR (W) | BRANNAN ST to TOWNSEND ST (600 - 699) | - | SPL# 647 GOING SOUTH BTWN DRIVEWAYS | - | - | - | - | 5 | 68644 | 953107200000 | -122.40243088 | 37.77243412 | - | 1594278000000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1583322060000 | 07TH ST | 600 - 699 7TH ST | 600 - 699 07TH ST | 600 7TH ST | - | TOWNSEND ST | TOWNSEND ST |
| 51542 | N/A | Point | 1 | 1 | 600 - 699 | - | S262193 | 600-699 7TH ST | 600-699 07TH ST | F | F | - | F | 376000 | 376000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | BRANNAN ST | BRANNAN ST | 99001 | 99001 | 37.77243412 | -122.40243088 | - | - | 1748014545000 | MALOPEZ | FG 300 UR DELINEATOR (W) | BRANNAN ST to TOWNSEND ST (600 - 699) | - | SPL# 643 | - | - | - | - | 1 | 68645 | 953107200000 | -122.40243088 | 37.77243412 | - | 1591081200000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1583322120000 | 07TH ST | 600 - 699 7TH ST | 600 - 699 07TH ST | 600 7TH ST | - | TOWNSEND ST | TOWNSEND ST |
| 51543 | N/A | Point | - | - | - | - | S268509 | BROTHERHOOD WAY: ARCH ST | - | F | F | - | F | 22524000 | 22524000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | ARCH ST | ARCH ST | 100351 | 100351 | 37.71242187 | -122.46707269 | BROTHERHOOD WAY \ ARCH ST | BROTHERHOOD WAY \ ARCH ST | 1747231162000 | middleware_editor | REMOVE (SF BIKE ROUTE) GREEN (SYM) # | ARCH ST intersection | - | # 98 | - | - | - | - | - | 68646 | 267174000000 | -122.46707269 | 37.71242187 | - | 1491894000000 | - | D11 | - | BIKE REG | REG | R(SF).0388 | 12X24 | SUP2 | SIGNAL POLE | IS | 1601370840000 | BROTHERHOOD WAY | - | - | - | - | - | - |
| 51544 | N/A | Point | 1 | 1 | 401 - 499 | - | S268510 | 0-499 BROTHERHOOD WAY | 401-499 BROTHERHOOD WAY | F | F | - | F | 3239101 | 3239101 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | ALEMANY BLVD | 100352 | 100352 | 37.71221333 | -122.46528182 | - | - | 1713575324000 | middleware_editor | FG 300 UR DELINEATOR (W) | ALEMANY BLVD to ARCH ST (401 - 499) -- SOUTH -- | - | AFTER DELINEATORS GOING WEST 30 FT O.C | - | - | - | - | - | 68647 | 1459728000000 | -122.46528182 | 37.71221333 | - | 1620604800000 | - | D7 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1601371020000 | BROTHERHOOD WAY | 401 - 499 BROTHERHOOD WAY | 401 - 499 BROTHERHOOD WAY | 401 BROTHERHOOD WAY | - | ARCH ST | ARCH ST |
| 51545 | N/A | Point | 1 | 1 | 401 - 499 | - | S268511 | 0-499 BROTHERHOOD WAY | 401-499 BROTHERHOOD WAY | F | F | - | F | 3239101 | 3239101 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | ALEMANY BLVD | 100353 | 100353 | 37.71221333 | -122.46528182 | - | - | 1713575349000 | middleware_editor | FG 300 UR DELINEATOR (W) | ALEMANY BLVD to ARCH ST (401 - 499) -- SOUTH -- | - | 30FT O.C FROM ARCH TO TURN LANE | - | - | - | - | - | 68648 | 1459728000000 | -122.46528182 | 37.71221333 | - | 1620691200000 | - | D7 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1601371440000 | BROTHERHOOD WAY | 401 - 499 BROTHERHOOD WAY | 401 - 499 BROTHERHOOD WAY | 401 BROTHERHOOD WAY | - | ARCH ST | ARCH ST |
| 51546 | N/A | Point | 1 | 1 | 500 - 598 | - | S268512 | 500-598 BROTHERHOOD WAY | 500-598 BROTHERHOOD WAY | F | F | - | F | 3240201 | 3240201 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | ARCH ST | ARCH ST | 100354 | 100354 | 37.71255557 | -122.46853402 | - | - | 1717024661000 | middleware_editor | FG 300 UR DELINEATOR (W) | ARCH ST to JUNIPERO SERRA BLVD ON RAMP (500 - 598) -- NORTH -- | - | 30 FT O.C TO ST CHARLES PATH | - | - | - | - | - | 68649 | 1469491200000 | -122.46853402 | 37.71255557 | - | 1716383700000 | - | D11 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1601371740000 | BROTHERHOOD WAY | 500 - 598 BROTHERHOOD WAY | 500 - 598 BROTHERHOOD WAY | 500 BROTHERHOOD WAY | - | JUNIPERO SERRA BLVD ON RAMP | JUNIPERO SERRA BLVD ON RAMP |
| 51547 | N/A | Point | 1 | 1 | 35 - 100 | - | S268547 | 35-99 MERCEDES WAY | 35-100 MERCEDES WAY | F | F | - | F | 8983000 | 8983000 | - | - | WEST SIDE | - | - | - | - | CEDRO AVE | CEDRO AVE | 100356 | 100356 | 37.72796021 | -122.47029735 | - | - | 1752680616000 | middleware_editor | 2 HR PRK 8AM-4PM MON-FRI EXC "H" PERMITS | CEDRO AVE to PALOMA AVE (35 - 100) | - | NPL75 | - | - | - | - | - | 68650 | 1223362800000 | -122.47029735 | 37.72796021 | - | - | - | D7 | - | PARKING:RPP | REG | R32C(CA).0049 | 18X21 | SUP2 | LIGHT POLE | IS | 1601381340000 | MERCEDES WAY | 35 - 100 MERCEDES WAY | 35 - 100 MERCEDES WAY | 35 MERCEDES WAY | - | PALOMA AVE | PALOMA AVE |
| 51548 | N/A | Point | 1 | 1 | 500 - 599 | - | S268607 | 500-599 HAYES ST | 500-599 HAYES ST | F | F | - | F | 6817000 | 6817000 | - | - | SOUTH SIDE | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 100358 | 100358 | 37.77657593 | -122.42538852 | - | - | 1728608275000 | middleware_editor | BIKE RACK | OCTAVIA ST to LAGUNA ST (500 - 599) | - | IFO 501/10' W OF XWALK/2' FROM CURB | - | - | - | - | - | 68651 | 1601510400000 | -122.42538852 | 37.77657593 | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1601449800000 | HAYES ST | 500 - 599 HAYES ST | 500 - 599 HAYES ST | 500 HAYES ST | - | LAGUNA ST | LAGUNA ST |
| 51549 | N/A | Point | - | - | - | - | S256938 | JUDAH ST: 27TH AVE | - | F | F | - | F | 27428000 | 27428000 | - | - | NORTH WEST CORNER | - | - | - | - | 27TH AVE | 27TH AVE | 100361 | 100361 | 37.76132282 | -122.48556839 | JUDAH ST \ 27TH AVE | JUDAH ST \ 27TH AVE | 1738851334000 | middleware_editor | JUDAH ST | 27TH AVE intersection | - | - | - | - | - | - | - | 68652 | 1566891420000 | -122.48556839 | 37.76132282 | - | - | - | D4 | - | STREET NAME | GUIDE | D3-1.0943 | 36X08 | SUP2 | LIGHT POLE | IS | 1565269500000 | JUDAH ST | - | - | - | - | - | - |
| 51550 | N/A | Point | - | - | - | - | S256939 | JUDAH ST: 27TH AVE | - | F | F | - | F | 27428000 | 27428000 | - | - | NORTH WEST CORNER | - | - | - | - | 27TH AVE | 27TH AVE | 100362 | 100362 | 37.76132282 | -122.48556839 | JUDAH ST \ 27TH AVE | JUDAH ST \ 27TH AVE | 1738851332000 | middleware_editor | 27TH AVE | 27TH AVE intersection | - | - | - | - | - | - | - | 68653 | 1566891480000 | -122.48556839 | 37.76132282 | - | - | - | D4 | - | STREET NAME | GUIDE | D3-1.1957 | 36X08 | SUP2 | LIGHT POLE | IS | 1565269740000 | JUDAH ST | - | - | - | - | - | - |
| 51551 | N/A | Point | - | - | - | - | S257576 | MARTIN LUTHER KING JR DR: CHAI | - | F | F | - | F | - | 27793000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | - | CHAIN OF LAKES DR | 100363 | 100363 | 37.76484591 | -122.50085702 | - | MARTIN LUTHER KING JR DR \ CHAIN OF LAKES DR | 1723669025000 | middleware_editor | STOP | CHAIN OF LAKES DR intersection | - | - | - | - | - | - | - | 68654 | 1166400000000 | -122.50085702 | 37.76484591 | - | 1567728000000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1567767720000 | MARTIN LUTHER KING JR DR | - | - | - | - | - | - |
| 51552 | N/A | Point | 1 | 1 | 101 - 149 | - | S257736 | 0-149 SAN MARCOS AVE | 101-149 SAN MARCOS AVE | F | F | - | F | 11494000 | 11494000 | - | - | SOUTH SIDE | - | - | - | - | CASTENADA AVE | CASTENADA AVE | 100364 | 100364 | 37.74659093 | -122.46445381 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM 1ST & 3RD TUE OF MONTH STCL | CASTENADA AVE to SANTA RITA AVE (101 - 149) -- SOUTH -- | - | EPL 121 | - | - | - | - | - | 68655 | 1224547200000 | -122.46445381 | 37.74659093 | - | 1569024000000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0288 | 18X18 | SUP2 | 2IN IRON POST | IS | 1568303460000 | SAN MARCOS AVE | 101 - 149 SAN MARCOS AVE | 101 - 149 SAN MARCOS AVE | 101 SAN MARCOS AVE | - | SANTA RITA AVE | SANTA RITA AVE |
| 51553 | N/A | Point | 1 | 1 | 1700 - 1798 | - | S257740 | PNDG 3RD ST | 1700-1798 03RD ST | F | F | - | F | 185206 | 185206 | - | - | EAST SIDE | - | - | - | - | CAMPUS WAY | CAMPUS WAY | 100365 | 100365 | 37.76737808 | -122.38923219 | - | - | 1710539427000 | MTA | TANSAT | CAMPUS WAY to 16TH ST (1700 - 1798) -- WEST -- | - | 185' SOUTH OF SOUTH ST. | - | - | - | - | - | 68656 | 1141430400000 | -122.38923219 | 37.76737808 | - | 1569196800000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1568365620000 | 03RD ST | PNDG 3RD ST | 1700 - 1798 03RD ST | - | - | 16TH ST | 16TH ST |
| 51554 | N/A | Point | 1 | 1 | 200 - 299 | - | S265431 | 200-299 CONNECTICUT ST | 200-299 CONNECTICUT ST | F | F | - | F | 4346000 | 4346000 | - | - | WEST SIDE | - | - | - | - | MARIPOSA ST | MARIPOSA ST | 100366 | 100366 | 37.76315755 | -122.39755385 | - | - | 1710539427000 | MTA | BIKE RACK | MARIPOSA ST to 18TH ST (200 - 299) | 134152 | 9' N OF SPL 212/ 3' IN FROM CURB | - | - | - | - | - | 68657 | 1594899480000 | -122.39755385 | 37.76315755 | - | - | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1593066240000 | CONNECTICUT ST | 200 - 299 CONNECTICUT ST | 200 - 299 CONNECTICUT ST | 200 CONNECTICUT ST | - | 18TH ST | 18TH ST |
| 51555 | N/A | Point | 1 | 1 | 1 - 99 | - | S265432 | PNDG BARNEVELD AVE | 1-99 DORMAN AVE | F | F | - | F | 4936000 | 4936000 | - | - | WEST SIDE | - | - | - | - | PALOU AVE | PALOU AVE | 100367 | 100367 | 37.73967931 | -122.40285616 | - | - | 1710539427000 | MTA | BIKE RACK | PALOU AVE to BARNEVELD AVE (1 - 99) | 134646 | 4' N OF SPL 550/ 3' IN FORM CURB | - | - | - | - | - | 68658 | 1615543440000 | -122.40285616 | 37.73967931 | - | - | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1593066360000 | DORMAN AVE | PNDG BARNEVELD AVE | 1 - 99 DORMAN AVE | - | - | BARNEVELD AVE | BARNEVELD AVE |
| 51556 | N/A | Point | 1 | 1 | 100 - 199 | RIGHT ARROW | S288155 | 100-199 CALIFORNIA ST | 100-199 CALIFORNIA ST | F | F | - | F | 3525000 | 3525000 | - | - | SOUTH SIDE | - | - | - | - | DAVIS ST | DAVIS ST | 102546 | 102546 | 37.79343385 | -122.39819499 | - | - | 1755628180000 | middleware_editor | TANS 7AM-9AM/3PM-6PM EXC SAT & SUN | DAVIS ST to FRONT ST (100 - 199) | - | 90' EAST OF FRONT | - | - | - | - | - | 68659 | - | -122.39819499 | 37.79343385 | - | - | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0067 | 18X21 | SUP1 | 2IN IRON POST | IS | 1678963200000 | CALIFORNIA ST | 100 - 199 CALIFORNIA ST | 100 - 199 CALIFORNIA ST | 100 CALIFORNIA ST | - | FRONT ST | FRONT ST |
| 51557 | N/A | Point | - | 1 | 400 - 448 | - | S264515 | 400-499 7TH ST | 400-448 07TH ST | F | F | - | F | 374000 | 374000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | HARRISON ST | HARRISON ST | 102547 | 102547 | 37.77517463 | -122.40586988 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | HARRISON ST to I-80 E OFF RAMP (400 - 448) | - | START 105' SOUTH OF HARRISON ST. | - | - | - | - | - | 68660 | 1591366440000 | -122.40586988 | 37.77517463 | - | - | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1590064920000 | 07TH ST | 400 - 448 7TH ST | 400 - 448 07TH ST | 400 7TH ST | - | I-80 E OFF RAMP | I-80 E OFF RAMP |
| 51558 | N/A | Point | 1 | 1 | 100 - 199 | - | S263059 | 100-199 FAIR OAKS ST | 100-199 FAIR OAKS ST | T | T | - | F | 5382000 | 5382000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 22ND ST | 22ND ST | 102548 | 102548 | 37.75430442 | -122.424213 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | 22ND ST to 23RD ST (100 - 199) | 134978 | SPL #170 | - | - | - | - | - | 68661 | 1333411200000 | -122.424213 | 37.75430442 | - | 1489017600000 | - | D8 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP2 | LIGHT POLE | IS | 1585825740000 | FAIR OAKS ST | 100 - 199 FAIR OAKS ST | 100 - 199 FAIR OAKS ST | 100 FAIR OAKS ST | - | 23RD ST | 23RD ST |
| 51559 | N/A | Point | 1 | 1 | 1600 - 1649 | - | S263068 | 1600-1649 NOE ST | 1600-1649 NOE ST | T | T | - | F | 9638000 | 9638000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 29TH ST | 29TH ST | 102550 | 102550 | 37.74303081 | -122.43106133 | - | - | 1751997377000 | middleware_editor | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | 29TH ST to DAY ST (1600 - 1649) | 134789 | NPL #1620 | - | - | - | - | - | 68662 | 1333436400000 | -122.43106133 | 37.74303081 | - | 1489046400000 | - | D8 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP2 | MUNI POLE | IS | 1585831800000 | NOE ST | 1600 - 1649 NOE ST | 1600 - 1649 NOE ST | 1600 NOE ST | - | DAY ST | DAY ST |
| 51560 | N/A | Point | 1 | 1 | 300 - 399 | - | S263069 | 300-399 DAY ST | 300-399 DAY ST | F | F | - | F | 4621000 | 4621000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 102551 | 102551 | 37.74269758 | -122.42991396 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | SANCHEZ ST to NOE ST (300 - 399) | 134794 | EPL #396 | - | - | - | - | - | 68663 | 1333411200000 | -122.42991396 | 37.74269758 | - | 1489017600000 | - | D8 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1585832220000 | DAY ST | 300 - 399 DAY ST | 300 - 399 DAY ST | 300 DAY ST | - | NOE ST | NOE ST |
| 51561 | N/A | Point | 1 | 1 | 400 - 499 | - | S263071 | 400-499 DAY ST | 400-499 DAY ST | F | F | - | F | 4622000 | 4622000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | NOE ST | NOE ST | 102552 | 102552 | 37.74269015 | -122.43240447 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | NOE ST to 29TH ST \ CASTRO ST (400 - 499) | 134797 | 10FT E.OF #431 | - | - | - | - | - | 68664 | 1333411200000 | -122.43240447 | 37.74269015 | - | 1489017600000 | - | D8 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1585832460000 | DAY ST | 400 - 499 DAY ST | 400 - 499 DAY ST | 400 DAY ST | - | 29TH ST \ CASTRO ST | 29TH ST \ CASTRO ST |
| 51562 | N/A | Point | 1 | 1 | 200 - 299 | - | S263073 | 200-299 DIAMOND ST | 200-299 DIAMOND ST | F | F | - | F | 4739000 | 4739000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 102553 | 102553 | 37.75835709 | -122.43696245 | - | - | 1754677182000 | middleware_editor | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | 19TH ST to 20TH ST (200 - 299) | 135006 | SPL #225 | - | - | - | - | - | 68665 | 1333522800000 | -122.43696245 | 37.75835709 | - | 1489046400000 | - | D8 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1585835820000 | DIAMOND ST | 200 - 299 DIAMOND ST | 200 - 299 DIAMOND ST | 200 DIAMOND ST | - | 20TH ST | 20TH ST |
| 51563 | N/A | Point | - | - | - | - | S263075 | 22ND ST: CHATTANOOGA ST | - | F | F | - | F | 25656000 | 25656000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 22ND ST | 22ND ST | 102554 | 102554 | 37.75496227 | -122.42663401 | CHATTANOOGA ST \ 22ND ST | CHATTANOOGA ST \ 22ND ST | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | 22ND ST intersection | 134833 | - | - | - | - | - | - | 68666 | 1333497600000 | -122.42663401 | 37.75496227 | - | 1489017600000 | - | D8 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1585841520000 | CHATTANOOGA ST | - | - | - | - | - | - |
| 51564 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S255017 | 1100-1199 TENNESSEE ST | 1100-1199 TENNESSEE ST | F | F | - | F | 12486000 | 12486000 | - | - | WEST SIDE | - | - | - | - | 22ND ST | 22ND ST | 102689 | 102689 | 37.75712013 | -122.38917728 | - | - | 1710539427000 | MTA | 2HR PRK 8AM-10PM MON-SAT EXC "EE" PERMITS | 22ND ST to TUBBS ST (1100 - 1199) | - | IFO #1122 | - | - | - | - | - | 68667 | 1464048000000 | -122.38917728 | 37.75712013 | - | 1535414400000 | - | D10 | - | PARKING:RPP | REG | R32C(CA).0245 | 18X21 | SUP1 | 2IN IRON POST | IS | 1559646360000 | TENNESSEE ST | 1100 - 1199 TENNESSEE ST | 1100 - 1199 TENNESSEE ST | 1100 TENNESSEE ST | - | TUBBS ST | TUBBS ST |
| 51565 | N/A | Point | 1 | 1 | 700 - 799 | - | S255188 | 700-799 IRVING ST | 700-799 IRVING ST | F | F | - | F | 7285000 | 7285000 | - | - | NORTH SIDE | - | - | - | - | 8TH AVE | 08TH AVE | 102690 | 102690 | 37.76406038 | -122.46577776 | - | - | 1710539427000 | MTA | BIKE RACK | 08TH AVE to 09TH AVE (700 - 799) | 66688 | 3' EAST FRM WPL#716/3' IN FROM CURB | - | - | - | - | - | 68668 | 1560338820000 | -122.46577776 | 37.76406038 | - | 1646006400000 | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1560251100000 | IRVING ST | 700 - 799 IRVING ST | 700 - 799 IRVING ST | 700 IRVING ST | - | 09TH AVE | 09TH AVE |
| 51566 | N/A | Point | 1 | 1 | 531 - 599 | - | S255189 | 531-599 OCTAVIA ST | 531-599 OCTAVIA ST | F | F | - | F | 9885000 | 9885000 | - | - | WEST SIDE | - | - | - | - | IVY ST | IVY ST | 102691 | 102691 | 37.77737076 | -122.42476322 | - | - | 1748012318000 | middleware_editor | BIKE RACK | IVY ST to GROVE ST (531 - 599) | 63406 | SPL#537/4' IN FROM CURB | - | - | - | - | - | 68669 | 1560358980000 | -122.42476322 | 37.77737076 | - | - | 1747953000000 | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | RETD | 1560252180000 | OCTAVIA ST | 531 - 599 OCTAVIA ST | 531 - 599 OCTAVIA ST | 531 OCTAVIA ST | - | GROVE ST | GROVE ST |
| 51567 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S254417 | 1500-1599 43RD AVE | 1500-1599 43RD AVE | F | F | - | F | 1957000 | 1957000 | - | - | EAST SIDE | - | - | - | - | KIRKHAM ST | KIRKHAM ST | 102692 | 102692 | 37.75776738 | -122.50251609 | - | - | 1710539427000 | MTA | BIKE RACK | KIRKHAM ST to LAWTON ST (1500 - 1599) | 56395 | 3' N OF SPL/3' IN FROM CURB | - | - | - | - | - | 68670 | 1559565480000 | -122.50251609 | 37.75776738 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1558104120000 | 43RD AVE | 1500 - 1599 43RD AVE | 1500 - 1599 43RD AVE | 1500 43RD AVE | - | LAWTON ST | LAWTON ST |
| 51568 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S254418 | 1500-1599 43RD AVE | 1500-1599 43RD AVE | F | F | - | F | 1957000 | 1957000 | - | - | EAST SIDE | - | - | - | - | KIRKHAM ST | KIRKHAM ST | 102693 | 102693 | 37.75776738 | -122.50251609 | - | - | 1710539427000 | MTA | BIKE RACK | KIRKHAM ST to LAWTON ST (1500 - 1599) | 56395 | 29' N OF SPL/3' IN FROM CURB | - | - | - | - | - | 68671 | 1559565600000 | -122.50251609 | 37.75776738 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1558105740000 | 43RD AVE | 1500 - 1599 43RD AVE | 1500 - 1599 43RD AVE | 1500 43RD AVE | - | LAWTON ST | LAWTON ST |
| 51569 | N/A | Point | - | - | - | - | S255680 | FULTON ST: 14TH AVE | - | F | F | - | F | 27447000 | 27447000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FULTON ST | FULTON ST | 102694 | 102694 | 37.77311442 | -122.47229734 | 14TH AVE \ FULTON ST | 14TH AVE \ FULTON ST | 1719866238000 | middleware_editor | NO LEFT TURN (SYM) 7AM-9AM/4PM-7PM EXC SUN | FULTON ST intersection | - | OF 14TH AVE & FULTON ST.-F/S/B/T | - | - | - | - | - | 68672 | 1487030400000 | -122.47229734 | 37.77311442 | - | 1487030400000 | - | D1 | - | NO LEFT TURN | REG | R33A(CA).0017 | 30X48 | SUP2 | 2IN IRON POST | IS | 1561546920000 | 14TH AVE | - | - | - | - | - | - |
| 51570 | N/A | Point | - | - | - | - | S219126 | MASONIC AVE: PAGE ST | - | F | F | - | F | 26344000 | 26344000 | - | - | SOUTH EAST CORNER | - | - | - | - | MASONIC AVE | MASONIC AVE | 105747 | 105747 | 37.77114193 | -122.44553528 | PAGE ST \ MASONIC AVE | PAGE ST \ MASONIC AVE | 1710539427000 | MTA | NPRK 8AM-10AM FRI STCL | MASONIC AVE intersection | - | - | - | - | - | - | - | 68673 | - | -122.44553528 | 37.77114193 | - | - | - | D5 | - | STREET CLEANING | REG | R30B(CA).0259 | 18X18 | SUP1 | SIGNAL POLE | IS | 1441710540000 | PAGE ST | - | - | - | - | - | - |
| 51571 | N/A | Point | - | - | - | - | S219019 | JONES ST: POST ST | - | F | F | - | F | 24965000 | 24965000 | - | - | WEST SIDE | - | - | - | - | JONES ST | JONES ST | 105748 | 105748 | 37.7876636 | -122.41335396 | POST ST \ JONES ST | POST ST \ JONES ST | 1710539427000 | MTA | NPRK 6AM-8AM TUE STCL | JONES ST intersection | - | IFO# 729 | - | - | - | - | - | 68674 | - | -122.41335396 | 37.7876636 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0191 | 18X18 | SUP1 | 2IN IRON POST | IS | 1441192620000 | POST ST | - | - | - | - | - | - |
| 51572 | N/A | Point | - | - | - | - | S222057 | LINCOLN WAY: 34TH AVE | - | F | F | - | F | 27741000 | 27741000 | - | - | SOUTH EAST CORNER | - | - | - | - | LINCOLN WAY | 34TH AVE | 105749 | 105749 | 37.76473291 | -122.49333078 | 34TH AVE \ LINCOLN WAY | LINCOLN WAY \ 34TH AVE | 1748370379000 | middleware_editor | 34TH AVE | 34TH AVE intersection | - | - | - | - | - | - | - | 68675 | 1459282680000 | -122.49333078 | 37.76473291 | - | 1459234800000 | - | D4 | - | STREET NAME | GUIDE | D3-1.0026 | 36X08 | SUP2 | SIGNAL POLE | IS | 1452606900000 | LINCOLN WAY | - | - | - | - | - | - |
| 51573 | N/A | Point | - | - | - | - | S221535 | MISSION ST: MINT ST | - | F | F | - | F | 24886000 | 24886000 | - | - | NORTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 105750 | 105750 | 37.78219072 | -122.40716438 | MINT ST \ MISSION ST | MINT ST \ MISSION ST | 1710539427000 | MTA | TANS 4PM-6PM EXC SAT & SUN | MISSION ST intersection | - | EPL #948 | - | - | - | - | - | 68676 | 1455261300000 | -122.40716438 | 37.78219072 | - | 1455235200000 | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0026 | 18X21 | SUP1 | LIGHT POLE | IS | 1450866360000 | MINT ST | - | - | - | - | - | - |
| 51574 | N/A | Point | - | - | - | - | S222110 | 16TH ST: DE HARO ST | - | F | F | - | F | 23754000 | 23754000 | - | - | SOUTH EAST CORNER | - | - | - | - | 16TH ST | DE HARO ST | 105752 | 105752 | 37.76613252 | -122.40172052 | DE HARO ST \ 16TH ST | 16TH ST \ DE HARO ST | 1710539427000 | MTA | DELINEATOR (W) (SAFE HIT) | DE HARO ST intersection | - | SEE NOTES | - | - | - | - | - | 68677 | 1455720720000 | -122.40172052 | 37.76613252 | - | 1455667200000 | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1452682320000 | 16TH ST | - | - | - | - | - | - |
| 51575 | N/A | Point | - | - | - | - | S225478 | HOLLY PARK CIR: HIGHLAND AVE | - | F | F | - | F | 21242000 | 21242000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | HOLLY PARK CIR | HOLLY PARK CIR | 105753 | 105753 | 37.73714808 | -122.41880023 | HIGHLAND AVE \ HOLLY PARK CIR | HIGHLAND AVE \ HOLLY PARK CIR | 1746112019000 | middleware_editor | AHEAD | HOLLY PARK CIR intersection | - | SPL 327 120FT SOUTH OF HIGHLAND (EAST) | - | - | - | - | - | 68678 | 1463079780000 | -122.41880023 | 37.73714808 | - | 1463036400000 | - | D9 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP2 | 2IN IRON POST | IS | 1462785000000 | HIGHLAND AVE | - | - | - | - | - | - |
| 51576 | N/A | Point | - | - | - | - | S230203 | PRINCETON ST: SILLIMAN ST | - | F | F | - | F | 20966000 | 20966000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PRINCETON ST | PRINCETON ST | 105757 | 105757 | 37.72839884 | -122.41594594 | SILLIMAN ST \ PRINCETON ST | SILLIMAN ST \ PRINCETON ST | 1718068730000 | middleware_editor | ALL WAY | PRINCETON ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 68679 | 621648000000 | -122.41594594 | 37.72839884 | - | 1480377600000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477486620000 | SILLIMAN ST | - | - | - | - | - | - |
| 51577 | N/A | Point | - | - | - | - | S230534 | JAMESTOWN AVE: HAWES ST | - | F | F | - | F | 33227000 | 33227000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | JAMESTOWN AVE | JAMESTOWN AVE | 105758 | 105758 | 37.71752616 | -122.39159941 | HAWES ST \ JAMESTOWN AVE | HAWES ST \ JAMESTOWN AVE | 1710539427000 | MTA | ALL WAY | JAMESTOWN AVE intersection | - | - | - | - | - | - | - | 68680 | 1480948260000 | -122.39159941 | 37.71752616 | - | 1480896000000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1477991520000 | HAWES ST | - | - | - | - | - | - |
| 51578 | N/A | Point | - | - | - | - | S229677 | HOWARD ST: 3RD ST | - | T | T | - | F | 24590000 | 24590000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | HOWARD ST | 03RD ST | 105761 | 105761 | 37.78503029 | -122.40046848 | 3RD ST \ HOWARD ST | HOWARD ST \ 03RD ST | 1710539427000 | MTA | SIGNAL AHEAD (SYM) | 03RD ST intersection | - | 200FT WEST OF 3RD ST | - | - | - | - | - | 68681 | 1476110400000 | -122.40046848 | 37.78503029 | - | 1476057600000 | - | D6 | - | OTHER WARNING | WARNING | W3-3.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1476106020000 | HOWARD ST | - | - | - | - | - | - |
| 51579 | N/A | Point | - | - | - | - | S230541 | JENNINGS ST: JAMESTOWN AVE | - | F | F | - | F | 20459000 | 20459000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JENNINGS ST | JENNINGS ST | 105762 | 105762 | 37.71955811 | -122.39543147 | JAMESTOWN AVE \ JENNINGS ST | JAMESTOWN AVE \ JENNINGS ST | 1756132242000 | middleware_editor | ALL WAY | JENNINGS ST intersection | - | 0 / 0 | - | - | - | - | - | 68682 | - | -122.39543147 | 37.71955811 | - | 1669017600000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1477994040000 | JAMESTOWN AVE | - | - | - | - | - | - |
| 51580 | N/A | Point | - | - | - | - | S235601 | DIVISADERO ST: SACRAMENTO ST | - | T | T | - | F | 26821000 | 26821000 | - | - | NORTH EAST CORNER | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 105764 | 105764 | 37.78899526 | -122.44062362 | SACRAMENTO ST \ DIVISADERO ST | SACRAMENTO ST \ DIVISADERO ST | 1746733310000 | middleware_editor | SACRAMENTO ST | DIVISADERO ST intersection | - | SACRAMENTO (2900) | - | - | - | - | - | 68683 | - | -122.44062362 | 37.78899526 | - | - | - | D2 | - | STREET NAME | GUIDE | D3-1.1534 | 36X08 | SUP1 | MUNI POLE | IS | 1493123340000 | SACRAMENTO ST | - | - | - | - | - | - |
| 51581 | N/A | Point | 1 | 1 | 200 - 299 | - | S287887 | 200-299 NORTH POINT ST | 200-299 NORTH POINT ST | F | F | - | F | 9688000 | 9688000 | - | - | NORTH SIDE | - | - | - | - | STOCKTON ST | STOCKTON ST | 105765 | 105765 | 37.8068605 | -122.41131949 | - | - | 1710539427000 | MTA | BIKE RACK | STOCKTON ST to POWELL ST (200 - 299) | 688894 | 153 ' E OF POWELL/ 3' IN FROM CURB | - | - | - | - | - | 68684 | 1678752000000 | -122.41131949 | 37.8068605 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1678173780000 | NORTH POINT ST | 200 - 299 NORTH POINT ST | 200 - 299 NORTH POINT ST | 200 NORTH POINT ST | - | POWELL ST | POWELL ST |
| 51582 | N/A | Point | - | 1 | 501 - 599 | - | S275697 | 0-599 ALEMANY BLVD | 501-599 ALEMANY BLVD | F | F | - | F | 2157102 | 2157102 | - | - | SOUTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | I-280 N OFF RAMP \ I-280 N ON RAMP | I-280 N OFF RAMP \ I-280 N ON RAMP | 106017 | 106017 | 37.73153006 | -122.42077209 | - | - | 1710539427000 | MTA | BIKE (SYM) LANE | I-280 N OFF RAMP \ I-280 N ON RAMP to STONEYBROOK AVE (501 - 599) -- SOUTH -- | - | 32 FT EAST OF STONEYBROOK | - | - | - | - | - | 68685 | 1463702400000 | -122.42077209 | 37.73153006 | - | 1626307200000 | - | D9 | - | BIKE REG | REG | R81(CA).0001 | 12X18 | SUP2 | LIGHT POLE | IS | 1624528260000 | ALEMANY BLVD | 501 - 599 ALEMANY BLVD | 501 - 599 ALEMANY BLVD | 501 ALEMANY BLVD | - | STONEYBROOK AVE | STONEYBROOK AVE |
| 51583 | N/A | Point | - | - | - | - | S117365 | PAGE ST: SCOTT ST | - | F | F | - | F | 26028000 | 26028000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PAGE ST | SCOTT ST | 106019 | 106019 | 37.77241793 | -122.43556332 | SCOTT ST \ PAGE ST | PAGE ST \ SCOTT ST | 1715358946000 | middleware_editor | PEDESTRIAN (SYM) | SCOTT ST intersection | - | NWCORNER | - | - | - | - | - | 68686 | 1060214400000 | -122.43556332 | 37.77241793 | - | - | - | D5 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | 3IN IRON POST | IS | 1373572980000 | PAGE ST | - | - | - | - | - | - |
| 51584 | N/A | Point | 1 | 1 | 900 - 999 | - | S279954 | 900-999 OFARRELL ST | 900-999 OFARRELL ST | F | F | - | F | 9735000 | 9735000 | - | - | NORTH SIDE | - | - | - | - | POLK ST | POLK ST | 112624 | 112624 | 37.78485685 | -122.42037041 | - | - | 1710539427000 | MTA | TANS 7AM-9AM/4PM-6PM EXC SAT & SUN | POLK ST to VAN NESS AVE (900 - 999) | - | 90' E OF VAN NESS | - | - | - | - | - | 68687 | 1642032000000 | -122.42037041 | 37.78485685 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0072 | 18X21 | SUP1 | 2IN IRON POST | IS | 1640173620000 | OFARRELL ST | 900 - 999 OFARRELL ST | 900 - 999 OFARRELL ST | 900 OFARRELL ST | - | VAN NESS AVE | VAN NESS AVE |
| 51585 | N/A | Point | - | - | - | - | S279955 | MCALLISTER ST: ARGUELLO BLVD | - | F | F | - | F | 27204000 | 27204000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MCALLISTER ST | ARGUELLO BLVD | 112625 | 112625 | 37.77523976 | -122.45843527 | ARGUELLO BLVD \ MCALLISTER ST | MCALLISTER ST \ ARGUELLO BLVD | 1710539427000 | MTA | STOP | ARGUELLO BLVD intersection | - | - | - | - | - | - | - | 68688 | 1473984000000 | -122.45843527 | 37.77523976 | - | 1505260800000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1640173860000 | MCALLISTER ST | - | - | - | - | - | - |
| 51586 | N/A | Point | 1 | 1 | 900 - 999 | - | S279956 | 900-999 OFARRELL ST | 900-999 OFARRELL ST | F | F | - | F | 9735000 | 9735000 | - | - | NORTH SIDE | - | - | - | - | POLK ST | POLK ST | 112626 | 112626 | 37.78485685 | -122.42037041 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM MON WED FRI SAT STCL | POLK ST to VAN NESS AVE (900 - 999) | - | 90' E OF VAN NESS | - | - | - | - | - | 68689 | 1647475200000 | -122.42037041 | 37.78485685 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0189 | 18X18 | SUP1 | 2IN IRON POST | IS | 1640175420000 | OFARRELL ST | 900 - 999 OFARRELL ST | 900 - 999 OFARRELL ST | 900 OFARRELL ST | - | VAN NESS AVE | VAN NESS AVE |
| 51587 | N/A | Point | - | - | - | - | S108962 | CALIFORNIA ST: 4TH AVE | - | F | F | - | F | 27587000 | 27587000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 112627 | 112627 | 37.78526613 | -122.46244144 | 4TH AVE \ CALIFORNIA ST | 04TH AVE \ CALIFORNIA ST | 1710539427000 | MTA | STOP | CALIFORNIA ST intersection | - | 0 / 0 | - | - | - | - | - | 68690 | 377395200000 | -122.46244144 | 37.78526613 | - | 759369600000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570340000 | 04TH AVE | - | - | - | - | - | - |
| 51588 | N/A | Point | - | - | - | - | S107461 | CRESCENT AVE: FOLSOM ST | - | F | F | - | F | 21046000 | 21046000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CRESCENT AVE | FOLSOM ST | 112628 | 112628 | 37.73473162 | -122.41368902 | FOLSOM ST \ CRESCENT AVE | CRESCENT AVE \ FOLSOM ST | 1736968500000 | middleware_editor | STOP | FOLSOM ST intersection | - | 0 / 0 | - | - | - | - | - | 68691 | 227491200000 | -122.41368902 | 37.73473162 | - | 1736860200000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569860000 | CRESCENT AVE | - | - | - | - | - | - |
| 51589 | N/A | Point | - | - | - | - | S102285 | TAYLOR ST: NORTH POINT ST | - | F | F | - | F | 25592000 | 25592000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | TAYLOR ST | NORTH POINT ST | 112632 | 112632 | 37.80634343 | -122.41543157 | NORTH POINT ST \ TAYLOR ST | TAYLOR ST \ NORTH POINT ST | 1710779118000 | middleware_editor | STOP | NORTH POINT ST intersection | - | 0 / 00 | - | - | - | - | - | 68692 | -389404800000 | -122.41543157 | 37.80634343 | - | - | 1710753840000 | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | RETD | 1373568240000 | TAYLOR ST | - | - | - | - | - | - |
| 51590 | N/A | Point | - | - | - | - | S102596 | DORE ST: HOWARD ST | - | F | F | - | F | 24247000 | 24247000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DORE ST | DORE ST | 112633 | 112633 | 37.77451626 | -122.41376885 | HOWARD ST \ DORE ST | HOWARD ST \ DORE ST | 1726276370000 | middleware_editor | DO NOT ENTER | DORE ST intersection | - | 0 / ONE WAY SOUTH | - | - | - | - | - | 68693 | -387158400000 | -122.41376885 | 37.77451626 | - | - | - | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373568360000 | HOWARD ST | - | - | - | - | - | - |
| 51591 | N/A | Point | - | - | - | - | S102626 | HARRISON ST: HARRIET ST | - | F | F | - | F | 23921000 | 23921000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HARRISON ST | HARRISON ST | 112634 | 112634 | 37.77684624 | -122.40461003 | HARRIET ST \ HARRISON ST | HARRIET ST \ HARRISON ST | 1710539427000 | MTA | ONE WAY (RA) | HARRISON ST intersection | - | 0 / 0 | - | - | - | - | - | 68694 | -387072000000 | -122.40461003 | 37.77684624 | - | 1462320000000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568360000 | HARRIET ST | - | - | - | - | - | - |
| 51592 | N/A | Point | - | - | - | - | S102644 | JESSIE ST: 1ST ST | - | F | F | - | F | 24564000 | 24564000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JESSIE ST | JESSIE ST | 112635 | 112635 | 37.7902288 | -122.39815969 | 1ST ST \ JESSIE ST | 01ST ST \ JESSIE ST | 1710539427000 | MTA | STOP | JESSIE ST intersection | - | 0 / 00 | - | - | - | - | - | 68695 | -386553600000 | -122.39815969 | 37.7902288 | - | 1115164800000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568360000 | 01ST ST | - | - | - | - | - | - |
| 51593 | N/A | Point | - | - | - | - | S102689 | 4TH ST: CLEMENTINA ST | - | F | F | - | F | 24589000 | 24589000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 4TH ST | CLEMENTINA ST | 112636 | 112636 | 37.78245274 | -122.4016962 | CLEMENTINA ST \ 4TH ST | 04TH ST \ CLEMENTINA ST | 1710539427000 | MTA | ONE WAY (LA) | CLEMENTINA ST intersection | - | 00 / 0 | - | - | - | - | - | 68696 | -386208000000 | -122.4016962 | 37.78245274 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373568360000 | 04TH ST | - | - | - | - | - | - |
| 51594 | N/A | Point | - | - | - | - | S107745 | JOOST AVE: GENNESSEE ST | - | F | F | - | F | 22260000 | 22260000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JOOST AVE | GENNESSEE ST | 112637 | 112637 | 37.73231592 | -122.45115344 | GENNESSEE ST \ JOOST AVE | JOOST AVE \ GENNESSEE ST | 1712626324000 | middleware_editor | ONE WAY (LA) | GENNESSEE ST intersection | - | - | - | - | - | - | - | 68697 | 250214400000 | -122.45115344 | 37.73231592 | - | 1571788800000 | - | D7 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP2 | 2IN IRON POST | IS | 1373569980000 | JOOST AVE | - | - | - | - | - | - |
| 51595 | N/A | Point | - | - | - | - | S107773 | HEARST AVE: GENNESSEE ST | - | F | F | - | F | 22244000 | 22244000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HEARST AVE | GENNESSEE ST | 112638 | 112638 | 37.73068111 | -122.45114081 | GENNESSEE ST \ HEARST AVE | HEARST AVE \ GENNESSEE ST | 1710539427000 | MTA | STOP | GENNESSEE ST intersection | - | - | - | - | - | - | - | 68698 | 253843200000 | -122.45114081 | 37.73068111 | - | 1504742400000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | HEARST AVE | - | - | - | - | - | - |
| 51596 | N/A | Point | - | - | - | - | S103088 | 33RD AVE: NORIEGA ST | - | F | F | - | F | 27680000 | 27680000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | NORIEGA ST | 33RD AVE | 112641 | 112641 | 37.75357933 | -122.49147517 | 33RD AVE \ NORIEGA ST | NORIEGA ST \ 33RD AVE | 1711039783000 | wdwilli | STOP | 33RD AVE intersection | - | 0 / 0 | - | - | - | - | - | 68699 | -310953600000 | -122.49147517 | 37.75357933 | - | 1475193600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568480000 | NORIEGA ST | - | - | - | - | - | - |
| 51597 | N/A | Point | - | - | - | - | S103109 | 47TH AVE: NORIEGA ST | - | F | F | - | F | 27927000 | 27927000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 47TH AVE | 47TH AVE | 112642 | 112642 | 37.75291676 | -122.50647634 | NORIEGA ST \ 47TH AVE | NORIEGA ST \ 47TH AVE | 1728567430000 | middleware_editor | STOP | 47TH AVE intersection | - | 0 / 00 | - | - | - | - | - | 68700 | -310780800000 | -122.50647634 | 37.75291676 | - | 1495065600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568480000 | NORIEGA ST | - | - | - | - | - | - |
| 51598 | N/A | Point | - | - | - | RIGHT ARROW | S101769 | AUSTIN ST: GOUGH ST | - | F | F | - | F | 26506000 | 26506000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GOUGH ST | GOUGH ST | 112643 | 112643 | 37.78853628 | -122.42533051 | AUSTIN ST \ GOUGH ST | AUSTIN ST \ GOUGH ST | 1755644149000 | middleware_editor | ONE WAY (RA) | GOUGH ST intersection | - | 00 / 0 | - | - | - | - | 1 | 68701 | -395082000000 | -122.42533051 | 37.78853628 | - | 1755638760000 | - | D2 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373566860000 | AUSTIN ST | - | - | - | - | - | - |
| 51599 | N/A | Point | - | - | - | - | S102077 | PAGE ST: FILLMORE ST | - | F | F | - | F | 25902000 | 25902000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PAGE ST | FILLMORE ST | 112644 | 112644 | 37.7730393 | -122.43062909 | FILLMORE ST \ PAGE ST | PAGE ST \ FILLMORE ST | 1721401990000 | middleware_editor | ALL WAY | FILLMORE ST intersection | - | 0 / 0 | - | - | - | - | - | 68702 | -393033600000 | -122.43062909 | 37.7730393 | - | 1422316800000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 3IN IRON POST | IS | 1373568180000 | PAGE ST | - | - | - | - | - | - |
| 51600 | N/A | Point | 1 | 1 | 500 - 633 | - | S114045 | 500-633 TEXAS ST | 500-633 TEXAS ST | F | F | - | F | 12543000 | 12543000 | - | - | WEST SIDE | - | - | - | - | 20TH ST | 20TH ST | 14442 | 14442 | 37.75921819 | -122.39523316 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | 20TH ST to SIERRA ST (500 - 633) | - | OPP. #515 | - | - | - | - | - | 68703 | 1000771200000 | -122.39523316 | 37.75921819 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373571960000 | TEXAS ST | 500 - 633 TEXAS ST | 500 - 633 TEXAS ST | 500 TEXAS ST | - | SIERRA ST | SIERRA ST |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in meters