Import ISO
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74476 | N/A | Point | - | - | - | - | S261491 | 10TH AVE: MORAGA ST | - | F | F | - | F | 27108000 | 27108000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MORAGA ST | 10TH AVE | 99887 | 99887 | 37.756534 | -122.46686233 | 10TH AVE \ MORAGA ST | MORAGA ST \ 10TH AVE | 1710539427000 | MTA | STOP | 10TH AVE intersection | - | - | - | - | - | - | - | 91593 | 223516800000 | -122.46686233 | 37.756534 | - | 1586995200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1581670260000 | MORAGA ST | - | - | - | - | - | - |
| 74477 | N/A | Point | - | - | - | - | S261492 | 10TH AVE: MORAGA ST | - | F | F | - | F | 27108000 | 27108000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MORAGA ST | 10TH AVE | 99888 | 99888 | 37.756534 | -122.46686233 | 10TH AVE \ MORAGA ST | MORAGA ST \ 10TH AVE | 1710539427000 | MTA | ALL WAY | 10TH AVE intersection | - | - | - | - | - | - | - | 91594 | 223516800000 | -122.46686233 | 37.756534 | - | 1586995200000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1581670380000 | MORAGA ST | - | - | - | - | - | - |
| 74478 | N/A | Point | - | - | - | - | S261493 | 10TH AVE: MORAGA ST | - | F | F | - | F | 27108000 | 27108000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MORAGA ST | 10TH AVE | 99889 | 99889 | 37.756534 | -122.46686233 | 10TH AVE \ MORAGA ST | MORAGA ST \ 10TH AVE | 1710539427000 | MTA | ALL WAY | 10TH AVE intersection | - | 15 FT SOUTH | - | - | - | - | - | 91595 | 223516800000 | -122.46686233 | 37.756534 | - | 1586995200000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1581670500000 | MORAGA ST | - | - | - | - | - | - |
| 74479 | N/A | Point | - | - | - | - | S261494 | MORAGA ST: 10TH AVE | - | F | F | - | F | 27108000 | 27108000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MORAGA ST | 10TH AVE | 99890 | 99890 | 37.756534 | -122.46686233 | 10TH AVE \ MORAGA ST | MORAGA ST \ 10TH AVE | 1710539427000 | MTA | STOP | 10TH AVE intersection | - | - | - | - | - | - | - | 91596 | 1224115200000 | -122.46686233 | 37.756534 | - | 1586995200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1581670740000 | MORAGA ST | - | - | - | - | - | - |
| 74480 | N/A | Point | - | - | - | - | S261495 | MORAGA ST: 10TH AVE | - | F | F | - | F | 27108000 | 27108000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MORAGA ST | 10TH AVE | 99891 | 99891 | 37.756534 | -122.46686233 | 10TH AVE \ MORAGA ST | MORAGA ST \ 10TH AVE | 1710539427000 | MTA | STOP | 10TH AVE intersection | - | - | - | - | - | - | - | 91597 | 1224115200000 | -122.46686233 | 37.756534 | - | 1586995200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1581670860000 | MORAGA ST | - | - | - | - | - | - |
| 74481 | N/A | Point | - | - | - | - | S261496 | MORAGA ST: 10TH AVE | - | F | F | - | F | 27108000 | 27108000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MORAGA ST | 10TH AVE | 99892 | 99892 | 37.756534 | -122.46686233 | 10TH AVE \ MORAGA ST | MORAGA ST \ 10TH AVE | 1710539427000 | MTA | ALL WAY | 10TH AVE intersection | - | - | - | - | - | - | - | 91598 | 1224115200000 | -122.46686233 | 37.756534 | - | 1586995200000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1581670980000 | MORAGA ST | - | - | - | - | - | - |
| 74482 | N/A | Point | 1 | 1 | 1 - 99 | - | S259638 | 1-99 HARRISON ST | 1-99 HARRISON ST | F | F | - | F | 6707000 | 6707000 | - | - | NORTH SIDE | - | - | - | - | THE EMBARCADERO | THE EMBARCADERO | 99893 | 99893 | 37.78920767 | -122.38895849 | - | - | 1710539427000 | MTA | BIKE RACK | THE EMBARCADERO to SPEAR ST (1 - 99) | 83069 | 115' W OF EPL #2/ 2.5' IN FROM CURB | - | - | - | - | - | 91599 | 1575936000000 | -122.38895849 | 37.78920767 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1575962400000 | HARRISON ST | 1 - 99 HARRISON ST | 1 - 99 HARRISON ST | 1 HARRISON ST | - | SPEAR ST | SPEAR ST |
| 74483 | N/A | Point | - | - | - | - | S263682 | 16TH ST: KANSAS ST | - | F | F | - | F | 23775000 | 23775000 | - | - | SOUTH SIDE | - | - | - | - | KANSAS ST | KANSAS ST | 99904 | 99904 | 37.76601707 | -122.40364306 | 16TH ST \ KANSAS ST | 16TH ST \ KANSAS ST | 1710539427000 | MTA | TANSAT | KANSAS ST intersection | - | 20' W OF WISCONSIN | - | - | - | - | - | 91600 | 1588339320000 | -122.40364306 | 37.76601707 | - | - | - | D10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1588238940000 | 16TH ST | - | - | - | - | - | - |
| 74484 | N/A | Point | - | - | - | - | S262306 | POST ST: LEAVENWORTH ST | - | T | T | - | F | 25157000 | 25157000 | - | - | NORTH WEST CORNER | - | - | - | - | POST ST | LEAVENWORTH ST | 99928 | 99928 | 37.78745384 | -122.41499542 | LEAVENWORTH ST \ POST ST | POST ST \ LEAVENWORTH ST | 1710539427000 | MTA | LEAVENWORTH ST | LEAVENWORTH ST intersection | - | []--->700 | - | - | - | - | - | 91601 | 28080000000 | -122.41499542 | 37.78745384 | - | 1594339200000 | - | D3 | - | STREET NAME | GUIDE | D3-1.1025 | 36X08 | SUP1 | MUNI POLE | IS | 1583496840000 | POST ST | - | - | - | - | - | - |
| 74485 | N/A | Point | - | - | - | - | S284896 | LAKE ST: 3RD AVE | - | F | F | - | F | 27584000 | 27584000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 3RD AVE | LAKE ST | 99949 | 99949 | 37.78681607 | -122.46147084 | LAKE ST \ 3RD AVE | 03RD AVE \ LAKE ST | 1710539427000 | MTA | ALL WAY | LAKE ST intersection | - | - | - | - | - | - | - | 91602 | 1663891200000 | -122.46147084 | 37.78681607 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1662458040000 | 03RD AVE | - | - | - | - | - | - |
| 74486 | N/A | Point | - | - | - | - | S272775 | TAYLOR ST: GEARY ST | - | T | T | - | F | 24941000 | 24941000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TAYLOR ST | GEARY ST | 99966 | 99966 | 37.78693971 | -122.41151577 | GEARY ST \ TAYLOR ST | TAYLOR ST \ GEARY ST | 1710539427000 | MTA | NO LEFT TURN (SYM) ON RED | GEARY ST intersection | - | - | - | - | - | - | - | 91603 | 1430352000000 | -122.41151577 | 37.78693971 | - | 1617148800000 | - | D3 | - | NO LEFT TURN | REG | R13B(CA).0002 | 24X36 | SUP1 | LIGHT POLE | IS | 1614679380000 | TAYLOR ST | - | - | - | - | - | - |
| 74487 | N/A | Point | - | - | - | - | S286510 | LAKE ST: 4TH AVE | - | F | F | - | F | 27588000 | 27588000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 4TH AVE | 04TH AVE | 99979 | 99979 | 37.78676805 | -122.46254656 | LAKE ST \ 4TH AVE | LAKE ST \ 04TH AVE | 1753913185000 | middleware_editor | PEXCO SURFACE MOUNT SLOW ST DELINEATOR (VEH,PED,BIKE) SYM | 04TH AVE intersection | - | 13 FT FROM CURB | - | - | - | - | - | 91604 | 1670832000000 | -122.46254656 | 37.78676805 | - | 1753899900000 | - | D2 | - | OTHER MISC | MISC | TYPE-DL.0030 | 03X36 | SUP1 | ANCHORS | IS | 1670841300000 | LAKE ST | - | - | - | - | - | - |
| 74488 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S288074 | 1400-1458 SAN BRUNO AVE | 1400-1499 SAN BRUNO AVE | F | F | - | F | 11362000 | 11362000 | - | - | WEST SIDE | - | - | - | - | 25TH ST | 25TH ST | 100004 | 100004 | 37.751205134 | -122.404272779 | - | - | 1750873865000 | middleware_editor | PARK AT 90 DEGREES | 25TH ST to SAN BRUNO AVE (1400 - 1499) | - | 205' SOUTH OF 25TH ST, NPL OF PARK | - | - | - | - | - | 91605 | 1680246000000 | -122.40415208 | 37.75091671 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0372 | 18X18 | SUP1 | 2IN IRON POST | IS | 1678877760000 | SAN BRUNO AVE | 1400 - 1499 SAN BRUNO AVE | 1400 - 1499 SAN BRUNO AVE | 1400 SAN BRUNO AVE | - | SAN BRUNO AVE | SAN BRUNO AVE |
| 74489 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S288077 | 1400-1458 SAN BRUNO AVE | 1400-1499 SAN BRUNO AVE | F | F | - | F | 11362000 | 11362000 | - | - | WEST SIDE | - | - | - | - | 25TH ST | 25TH ST | 100005 | 100005 | 37.750872174 | -122.404240593 | - | - | 1748464895000 | middleware_editor | TA (SYM) NO PARKING 6AM-2PM TUESDAY | 25TH ST to SAN BRUNO AVE (1400 - 1499) | - | 330' SOUTH OF 25TH ST. | - | - | - | - | - | 91606 | 1680246000000 | -122.40415208 | 37.75091671 | - | - | 1748458200000 | D10 | - | PARKING | REG | R26K(CA).0057 | 18X21 | SUP1 | 2IN IRON POST | RETD | 1678878780000 | SAN BRUNO AVE | 1400 - 1499 SAN BRUNO AVE | 1400 - 1499 SAN BRUNO AVE | 1400 SAN BRUNO AVE | - | SAN BRUNO AVE | SAN BRUNO AVE |
| 74490 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S288082 | 1400-1458 SAN BRUNO AVE | 1400-1499 SAN BRUNO AVE | F | F | - | F | 11362000 | 11362000 | - | - | WEST SIDE | - | - | - | - | 25TH ST | 25TH ST | 100006 | 100006 | 37.750418327 | -122.404203042 | - | - | 1748464653000 | middleware_editor | TA (SYM) NO PARKING 6AM-2PM TUESDAY | 25TH ST to SAN BRUNO AVE (1400 - 1499) | - | OPP 50FT SOUTH OF SPL#1435 | - | - | - | - | - | 91607 | 1680246000000 | -122.40415208 | 37.75091671 | - | - | 1748455800000 | D10 | - | PARKING | REG | R26K(CA).0057 | 18X21 | SUP1 | 2IN IRON POST | RETD | 1678881180000 | SAN BRUNO AVE | 1400 - 1499 SAN BRUNO AVE | 1400 - 1499 SAN BRUNO AVE | 1400 SAN BRUNO AVE | - | SAN BRUNO AVE | SAN BRUNO AVE |
| 74491 | N/A | Point | 1 | 1 | 1400 - 1499 | RIGHT ARROW | S288086 | 1400-1458 SAN BRUNO AVE | 1400-1499 SAN BRUNO AVE | F | F | - | F | 11362000 | 11362000 | - | - | WEST SIDE | - | - | - | - | 25TH ST | 25TH ST | 100007 | 100007 | 37.750280477 | -122.404192313 | - | - | 1748464745000 | middleware_editor | TA (SYM) NO PARKING 6AM-2PM TUESDAY | 25TH ST to SAN BRUNO AVE (1400 - 1499) | - | 535' SOUTH OF 25TH ST, SPL OF PARK | - | - | - | - | - | 91608 | 1680246000000 | -122.40415208 | 37.75091671 | - | - | 1748457000000 | D10 | - | PARKING | REG | R26K(CA).0057 | 18X21 | SUP1 | 2IN IRON POST | RETD | 1678882680000 | SAN BRUNO AVE | 1400 - 1499 SAN BRUNO AVE | 1400 - 1499 SAN BRUNO AVE | 1400 SAN BRUNO AVE | - | SAN BRUNO AVE | SAN BRUNO AVE |
| 74492 | N/A | Point | - | 1 | 1 - 99 | - | S288710 | 60-99 LOMBARD ST | 1-99 LOMBARD ST | F | F | - | F | 8431000 | 8431000 | - | - | SOUTH SIDE | - | - | - | - | BATTERY ST \ THE EMBARCADERO | BATTERY ST \ THE EMBARCADERO | 100013 | 100013 | 37.80408744 | -122.40265964 | - | - | 1710539427000 | MTA | BIKE RACK | BATTERY ST \ THE EMBARCADERO to SANSOME ST (1 - 99) | - | 24'2" E OF WPL 15/2' IN FROM CURB | - | - | - | - | - | 91609 | - | -122.40265964 | 37.80408744 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1681904700000 | LOMBARD ST | 1 - 99 LOMBARD ST | 1 - 99 LOMBARD ST | 1 LOMBARD ST | - | SANSOME ST | SANSOME ST |
| 74493 | N/A | Point | - | - | - | - | S267695 | MISSION ST: FLORENTINE AVE | - | F | F | - | F | 21507000 | 21507000 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | MISSION ST | FLORENTINE AVE | 101977 | 101977 | 37.71336209 | -122.44395163 | FLORENTINE AVE \ MISSION ST | MISSION ST \ FLORENTINE AVE | 1710539427000 | MTA | PEDESTRIAN (SYM) | FLORENTINE AVE intersection | - | 5 FT SOUTH | - | - | - | - | - | 91610 | 1064448000000 | -122.44395163 | 37.71336209 | - | 1598918400000 | - | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | LIGHT POLE | IS | 1598865420000 | MISSION ST | - | - | - | - | - | - |
| 74494 | N/A | Point | - | - | - | - | S267696 | MISSION ST: FLORENTINE AVE | - | F | F | - | F | 21507000 | 21507000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | MISSION ST | FLORENTINE AVE | 101978 | 101978 | 37.71336209 | -122.44395163 | FLORENTINE AVE \ MISSION ST | MISSION ST \ FLORENTINE AVE | 1710539427000 | MTA | PEDESTRIAN (SYM) | FLORENTINE AVE intersection | - | 5 FT SOUTH | - | - | - | - | - | 91611 | 1064448000000 | -122.44395163 | 37.71336209 | - | 1598918400000 | - | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | LIGHT POLE | IS | 1598865420000 | MISSION ST | - | - | - | - | - | - |
| 74495 | N/A | Point | - | - | - | - | S267702 | MISSION ST: FLORENTINE AVE | - | F | F | - | F | 21507000 | 21507000 | - | - | WEST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | MISSION ST | FLORENTINE AVE | 101979 | 101979 | 37.71336209 | -122.44395163 | FLORENTINE AVE \ MISSION ST | MISSION ST \ FLORENTINE AVE | 1710539427000 | MTA | (45 LA-DN) | FLORENTINE AVE intersection | - | WESTSIDE OF INTERSECTION 2 FT NORTH OFXW | - | - | - | - | - | 91612 | 1064361600000 | -122.44395163 | 37.71336209 | - | 1598918400000 | - | D11 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | LIGHT POLE | IS | 1598866080000 | MISSION ST | - | - | - | - | - | - |
| 74496 | N/A | Point | 1 | 1 | 5400 - 5449 | - | S267706 | 5400-5449 MISSION ST | 5400-5449 MISSION ST | F | F | - | F | 9185000 | 9185000 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | OTTAWA AVE | OTTAWA AVE | 101980 | 101980 | 37.7134768 | -122.44382883 | - | - | 1710539427000 | MTA | PEDESTRIAN (SYM) | OTTAWA AVE to FLORENTINE AVE (5400 - 5449) | - | IFO#5419 | - | - | - | - | - | 91613 | 1064361600000 | -122.44382883 | 37.7134768 | - | 1598918400000 | - | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | LIGHT POLE | IS | 1598867940000 | MISSION ST | 5400 - 5449 MISSION ST | 5400 - 5449 MISSION ST | 5400 MISSION ST | - | FLORENTINE AVE | FLORENTINE AVE |
| 74497 | N/A | Point | 1 | 1 | 100 - 199 | - | S289255 | 100-199 KISSLING ST | 100-199 KISSLING ST | F | F | - | F | - | 7903000 | - | - | SOUTH SIDE | - | - | - | - | - | 11TH ST | 101991 | 101991 | 37.772508869 | -122.415113776 | - | - | 1710539427000 | MTA | BIKE RACK | 11TH ST to 12TH ST (100 - 199) | - | 16.5' FROM 11TH IN CORRAL/3' OFF OF CURB | - | - | - | - | - | 91614 | 1683504000000 | -122.41560313 | 37.77203843 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1683217440000 | KISSLING ST | - | 100 - 199 KISSLING ST | 100 KISSLING ST | - | - | 12TH ST |
| 74498 | N/A | Point | 1 | 1 | 600 - 699 | - | S289918 | 600-699 SANSOME ST | 600-699 SANSOME ST | F | F | - | F | 11551000 | 11551000 | - | - | WEST SIDE | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 102016 | 102016 | 37.795871334 | -122.40178736 | - | - | 1710539427000 | MTA | BIKE RACK | WASHINGTON ST to JACKSON ST (600 - 699) | - | 19.5' FROM WASHNTON ST/3.5 FRM CRB/CORRL | - | - | - | - | - | 91615 | 1702470600000 | -122.40176471 | 37.79617277 | - | 1702463400000 | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1685540880000 | SANSOME ST | 600 - 699 SANSOME ST | 600 - 699 SANSOME ST | 600 SANSOME ST | - | JACKSON ST | JACKSON ST |
| 74499 | N/A | Point | 1 | 1 | 600 - 699 | - | S289919 | 600-699 SANSOME ST | 600-699 SANSOME ST | F | F | - | F | 11551000 | 11551000 | - | - | WEST SIDE | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 102017 | 102017 | 37.795862856 | -122.401784975 | - | - | 1710539427000 | MTA | BIKE RACK | WASHINGTON ST to JACKSON ST (600 - 699) | - | 16.5' FROM WASHNTON ST/3.5 FRM CRB/CORRL | - | - | - | - | - | 91616 | 1702468200000 | -122.40176471 | 37.79617277 | - | 1702467000000 | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1685540940000 | SANSOME ST | 600 - 699 SANSOME ST | 600 - 699 SANSOME ST | 600 SANSOME ST | - | JACKSON ST | JACKSON ST |
| 74500 | N/A | Point | 1 | 1 | 600 - 699 | - | S289920 | 600-699 SANSOME ST | 600-699 SANSOME ST | F | F | - | F | 11551000 | 11551000 | - | - | WEST SIDE | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 102018 | 102018 | 37.7958459 | -122.401775439 | - | - | 1710539427000 | MTA | WHEEL STOP | WASHINGTON ST to JACKSON ST (600 - 699) | - | 13' W OF WASHNGTN/S-END OF CORRAL | - | - | - | - | - | 91617 | 1702638000000 | -122.40176471 | 37.79617277 | - | - | - | D3 | - | OTHER WARNING | WARNING | W(SF).0072 | 36X08 | SUP1 | SPIKE | IS | 1685541000000 | SANSOME ST | 600 - 699 SANSOME ST | 600 - 699 SANSOME ST | 600 SANSOME ST | - | JACKSON ST | JACKSON ST |
| 74501 | N/A | Point | - | - | - | - | S268872 | 46TH AVE: LAWTON ST | - | F | F | - | F | - | 27932000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | - | 46TH AVE | 102059 | 102059 | 37.75669308 | -122.50566548 | - | LAWTON ST \ 46TH AVE | 1715713366000 | middleware_editor | STOP | 46TH AVE intersection | - | - | - | - | - | - | - | 91618 | 289612800000 | -122.50566548 | 37.75669308 | - | - | 1715688120000 | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | RETD | 1601984760000 | LAWTON ST | - | - | - | - | - | - |
| 74502 | N/A | Point | 1 | - | - | - | S259060 | 2400-2499 MISSION ST | - | F | F | - | F | 9122000 | 9122000 | - | - | EAST SIDE | - | - | - | - | - | - | 102073 | 102073 | 37.75783399 | -122.41897682 | - | - | 1710539427000 | MTA | BIKE RACK | - | 69480 | 14' N OF SPL#2417//3' IN FROM CURB | - | - | - | - | - | 91619 | 1573558500000 | -122.41897682 | 37.75783399 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1573126440000 | MISSION ST | 2400-2499 MISSION ST | MISSION ST | - | - | - | - |
| 74503 | N/A | Point | 1 | 1 | 200 - 295 | - | S254182 | 200-295 SAGAMORE ST | 200-295 SAGAMORE ST | F | F | - | F | 11282000 | 11282000 | - | - | NORTH SIDE | - | - | - | - | CAPITOL AVE | CAPITOL AVE | 102083 | 102083 | 37.71138003 | -122.46053436 | - | - | 1716557881000 | middleware_editor | BIKE (SYM) BIKE ROUTE | CAPITOL AVE to SAGAMORE ST (200 - 295) | 0740 | 286 SAGAMORE | - | - | - | - | - | 91620 | 1223251200000 | -122.46053436 | 37.71138003 | - | 1578268800000 | - | D11 | - | BIKE GUIDE | GUIDE | D11-1C.0002 | 24X18 | SUP2 | 2IN IRON POST | IS | 1557224700000 | SAGAMORE ST | 200 - 295 SAGAMORE ST | 200 - 295 SAGAMORE ST | 200 SAGAMORE ST | - | SAGAMORE ST | SAGAMORE ST |
| 74504 | N/A | Point | 1 | 1 | 2900 - 2999 | - | S215650 | 2900-2999 WAWONA ST | 2900-2999 WAWONA ST | F | F | - | F | 13494000 | 13494000 | - | - | NORTH SIDE | - | - | - | - | 40TH AVE | 40TH AVE | 102122 | 102122 | 37.73644092 | -122.49833369 | - | - | 1710539427000 | MTA | (H/C SYM) PARK ONLY/MIN FINE $250 | 40TH AVE to 41ST AVE (2900 - 2999) | - | 18`WEST | - | - | - | - | - | 91621 | - | -122.49833369 | 37.73644092 | - | - | - | D4 | - | OTHER REGULATORY | REG | R99C(CA).0001 | 12X24 | SUP2 | 2IN IRON POST | IS | 1430139000000 | WAWONA ST | 2900 - 2999 WAWONA ST | 2900 - 2999 WAWONA ST | 2900 WAWONA ST | - | 41ST AVE | 41ST AVE |
| 74505 | N/A | Point | - | - | - | - | S270430 | FOLSOM ST: 1ST ST | - | F | F | - | F | 24522000 | 24522000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | 01ST ST | 102140 | 102140 | 37.78729822 | -122.39448127 | 1ST ST \ FOLSOM ST | FOLSOM ST \ 01ST ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | 01ST ST intersection | - | - | - | - | - | - | - | 91622 | 1608036480000 | -122.39448127 | 37.78729822 | - | - | - | D6 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1606265880000 | FOLSOM ST | - | - | - | - | - | - |
| 74506 | N/A | Point | - | - | - | - | S289542 | MISSION ST: FARRAGUT AVE | - | F | F | - | F | 21547000 | 21547000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MISSION ST | FARRAGUT AVE | 102202 | 102202 | 37.7099462 | -122.44930867 | FARRAGUT AVE \ MISSION ST | MISSION ST \ FARRAGUT AVE | 1710539427000 | MTA | (45 RA-DN) | FARRAGUT AVE intersection | - | - | - | - | - | - | - | 91623 | 1684281600000 | -122.44930867 | 37.7099462 | - | - | - | D11 | - | OTHER WARNING | WARNING | W16-7P.0006 | 24X12 | SUP2 | 2IN IRON POST | IS | 1684245840000 | MISSION ST | - | - | - | - | - | - |
| 74507 | N/A | Point | 1 | 1 | 3951 - 3999 | - | S287578 | 3951-3999 17TH ST | 3951-3999 17TH ST | F | F | - | F | 810000 | 810000 | - | - | NORTH SIDE | - | - | - | - | HARTFORD ST | HARTFORD ST | 102207 | 102207 | 37.76254283 | -122.43465361 | - | - | 1710539427000 | MTA | BIKE RACK | HARTFORD ST to CASTRO ST \ MARKET ST (3951 - 3999) | 679044 | 7' E OF WPL 3970 /3' IN FROM CURB | - | - | - | - | - | 91624 | 1677110400000 | -122.43465361 | 37.76254283 | - | - | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1676558820000 | 17TH ST | 3951 - 3999 17TH ST | 3951 - 3999 17TH ST | 3951 17TH ST | - | CASTRO ST \ MARKET ST | CASTRO ST \ MARKET ST |
| 74508 | N/A | Point | - | - | - | - | S284700 | MISSION ST: SAN JUAN AVE | - | F | F | - | F | 21741000 | 21741000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MISSION ST | MISSION ST | 102208 | 102208 | 37.72400491 | -122.43531257 | SAN JUAN AVE \ MISSION ST | SAN JUAN AVE \ MISSION ST | 1715823465000 | middleware_editor | SPEED LIMIT 20 | MISSION ST intersection | - | ABOVE ONE WAY | - | - | - | - | - | 91625 | 1665964800000 | -122.43531257 | 37.72400491 | - | - | - | D11 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | 2IN IRON POST | IS | 1661345760000 | SAN JUAN AVE | - | - | - | - | - | - |
| 74509 | N/A | Point | - | - | - | - | S289814 | OFARRELL ST: SAINT JOSEPHS AVE | - | F | F | - | F | 26812000 | 26812000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | OFARRELL ST | SAINT JOSEPHS AVE | 103344 | 103344 | 37.7823514453929 | -122.441508352758 | SAINT JOSEPHS AVE \ OFARRELL ST | OFARRELL ST \ SAINT JOSEPHS AVE | 1733326064000 | middleware_editor | STOP | SAINT JOSEPHS AVE intersection | - | 0 / 0 | - | - | - | - | - | 91626 | 340502400000 | -122.44167164 | 37.78223395 | - | 1684886400000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1684934940000 | OFARRELL ST | - | - | - | - | - | - |
| 74510 | N/A | Point | 1 | 1 | 2800 - 2899 | - | S289831 | 2800-2899 GREEN ST | 2800-2899 GREEN ST | F | F | - | F | 6481000 | 6481000 | - | - | NORTH SIDE | - | - | - | - | BAKER ST | BAKER ST | 103345 | 103345 | 37.7948022 | -122.44597567 | - | - | 1710539427000 | MTA | 3 HR PRK 8AM-6PM MON-FRI EXC "K" PERMITS | BAKER ST to LYON ST (2800 - 2899) | - | INFO # 2800 | - | - | - | - | - | 91627 | - | -122.44597567 | 37.7948022 | - | 1685923200000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0187 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1685012880000 | GREEN ST | 2800 - 2899 GREEN ST | 2800 - 2899 GREEN ST | 2800 GREEN ST | - | LYON ST | LYON ST |
| 74511 | N/A | Point | - | - | - | - | S288329 | FREDERICK ST: COLE ST | - | F | F | - | F | 26410000 | 26410000 | - | - | NORTH WEST CORNER | - | - | - | - | FREDERICK ST | COLE ST | 103347 | 103347 | 37.7667901425353 | -122.450252473349 | COLE ST \ FREDERICK ST | FREDERICK ST \ COLE ST | 1741881034000 | middleware_editor | COLE ST | COLE ST intersection | - | - | - | - | - | - | - | 91628 | - | -122.45014564 | 37.76672907 | - | 1684479600000 | - | D5 | - | STREET NAME | GUIDE | D3-1.0407 | 36X08 | SUP1 | 3IN IRON POST | IS | 1680255240000 | FREDERICK ST | - | - | - | - | - | - |
| 74512 | N/A | Point | - | - | - | - | S285779 | BARNEVELD AVE: LOOMIS ST \ MCK | - | F | F | - | F | 20812000 | 20812000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | BARNEVELD AVE \ MCKINNON AVE | BARNEVELD AVE \ LOOMIS ST | 103403 | 103403 | 37.74379436 | -122.40324329 | LOOMIS ST \ BARNEVELD AVE \ MCKINNON AVE | MCKINNON AVE \ BARNEVELD AVE \ LOOMIS ST | 1710539427000 | MTA | TREE TOP 6FT SPEED BUMP | BARNEVELD AVE \ LOOMIS ST intersection | - | 120' NORTH OF NORTH LINE OF INTERSECTION | - | - | - | - | - | 91629 | 1669766400000 | -122.40324329 | 37.74379436 | - | - | - | D10 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1667219160000 | MCKINNON AVE | - | - | - | - | - | - |
| 74513 | N/A | Point | - | - | - | - | S284937 | 24TH AVE: LAKE ST | - | F | F | - | F | 27654000 | 27654000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH AVE | 24TH AVE | 103427 | 103427 | 37.78579453 | -122.48407981 | LAKE ST \ 24TH AVE | LAKE ST \ 24TH AVE | 1734117126000 | middleware_editor | ALL WAY | 24TH AVE intersection | - | - | - | - | - | - | - | 91630 | 1663632000000 | -122.48407981 | 37.78579453 | - | - | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1662470700000 | LAKE ST | - | - | - | - | - | - |
| 74514 | N/A | Point | 1 | 1 | 5300 - 5399 | - | S262473 | 5300-5399 MISSION ST | 5300-5399 MISSION ST | F | F | - | F | 9183000 | 9183000 | - | - | WEST SIDE | - | - | - | - | MOUNT VERNON AVE | MOUNT VERNON AVE | 103470 | 103470 | 37.714505137 | -122.442946349 | - | - | 1710539427000 | MTA | BIKE RACK | MOUNT VERNON AVE to CONCORD ST (5300 - 5399) | 146135 | 12'N OF SPL 5392/ 3' IN FROM CURB | - | - | - | - | - | 91631 | 1586772540000 | -122.44300357 | 37.71424769 | - | - | - | D11 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1583922600000 | MISSION ST | 5300 - 5399 MISSION ST | 5300 - 5399 MISSION ST | 5300 MISSION ST | - | CONCORD ST | CONCORD ST |
| 74515 | N/A | Point | - | - | - | - | S264915 | LEXINGTON ST: 21ST ST | - | F | F | - | F | 24121000 | 24121000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 21ST ST | LEXINGTON ST | 103472 | 103472 | 37.757033734 | -122.420316882 | LEXINGTON ST \ 21ST ST | 21ST ST \ LEXINGTON ST | 1710539427000 | MTA | ONE WAY (RA) | LEXINGTON ST intersection | - | - | - | - | - | - | - | 91632 | 1591623600000 | -122.42033834 | 37.75694891 | - | - | - | D9 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | 3IN IRON POST | IS | 1591365720000 | 21ST ST | - | - | - | - | - | - |
| 74516 | N/A | Point | 1 | 1 | 900 - 999 | - | S266436 | 900-999 VIENNA ST | 900-999 VIENNA ST | F | F | - | F | 13306000 | 13306000 | - | - | EAST SIDE | - | - | - | - | AMAZON AVE | AMAZON AVE | 103473 | 103473 | 37.714188506 | -122.435049682 | - | - | 1710539427000 | MTA | NPRK 10AM-12NN FRI STCL | AMAZON AVE to GENEVA AVE (900 - 999) | - | NPL 985 | - | - | - | - | - | 91633 | 1596449700000 | -122.4349263 | 37.71445444 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0010 | 18X18 | SUP2 | 2IN IRON POST | IS | 1595407860000 | VIENNA ST | 900 - 999 VIENNA ST | 900 - 999 VIENNA ST | 900 VIENNA ST | - | GENEVA AVE | GENEVA AVE |
| 74517 | N/A | Point | 1 | 1 | 500 - 599 | RIGHT ARROW | S256414 | 500-599 ALABAMA ST | 500-599 ALABAMA ST | F | F | - | F | 2111000 | 2111000 | - | - | WEST SIDE | - | - | - | - | MARIPOSA ST | MARIPOSA ST | 103550 | 103550 | 37.76227947 | -122.4121118 | - | - | 1740173460000 | middleware_editor | TANS EXC 30 MIN COMMERCIAL VEH 8AM-6PM MON-SAT | MARIPOSA ST to 18TH ST (500 - 599) | - | 34 FT NORTH OF SPL 550 @PM | - | - | - | - | - | 91634 | 1475798400000 | -122.4121118 | 37.76227947 | - | 1565222400000 | - | D9 | - | OTHER REGULATORY | REG | R37(SF).0186 | 18X21 | SUP2 | 2IN IRON POST | IS | 1564052580000 | ALABAMA ST | 500 - 599 ALABAMA ST | 500 - 599 ALABAMA ST | 500 ALABAMA ST | - | 18TH ST | 18TH ST |
| 74518 | N/A | Point | 1 | 1 | 500 - 599 | LEFT ARROW | S256415 | 500-599 ALABAMA ST | 500-599 ALABAMA ST | F | F | - | F | 2111000 | 2111000 | - | - | WEST SIDE | - | - | - | - | MARIPOSA ST | MARIPOSA ST | 103551 | 103551 | 37.76227947 | -122.4121118 | - | - | 1740173467000 | middleware_editor | TANS EXC 30 MIN COMMERCIAL VEH 8AM-6PM MON-SAT | MARIPOSA ST to 18TH ST (500 - 599) | - | 58 FT NORTH OF SPL 550 @PM | - | - | - | - | - | 91635 | 1475798400000 | -122.4121118 | 37.76227947 | - | 1565222400000 | - | D9 | - | OTHER REGULATORY | REG | R37(SF).0186 | 18X21 | SUP2 | 2IN IRON POST | IS | 1564052760000 | ALABAMA ST | 500 - 599 ALABAMA ST | 500 - 599 ALABAMA ST | 500 ALABAMA ST | - | 18TH ST | 18TH ST |
| 74519 | N/A | Point | 1 | 1 | 700 - 799 | - | S256416 | 700-799 VALENCIA ST | 700-799 VALENCIA ST | F | F | - | F | 13064000 | 13064000 | - | - | WEST SIDE | - | - | - | - | 18TH ST | 18TH ST | 103552 | 103552 | 37.760841737 | -122.421597699 | - | - | 1710539427000 | MTA | TANS EXC 30 MIN COMMERCIAL VEH 8AM-11AM DAILY | 18TH ST to 19TH ST (700 - 799) | - | IFO 756 | - | - | - | - | - | 91636 | 1342483200000 | -122.42150181 | 37.76090111 | - | 1566864000000 | - | D8 | - | OTHER REGULATORY | REG | R37(SF).0393 | 18X21 | SUP2 | 2IN IRON POST | IS | 1564053780000 | VALENCIA ST | 700 - 799 VALENCIA ST | 700 - 799 VALENCIA ST | 700 VALENCIA ST | - | 19TH ST | 19TH ST |
| 74520 | N/A | Point | 1 | 1 | 700 - 799 | RIGHT ARROW | S256417 | 700-799 VALENCIA ST | 700-799 VALENCIA ST | F | F | - | F | 13064000 | 13064000 | - | - | WEST SIDE | - | - | - | - | 18TH ST | 18TH ST | 103553 | 103553 | 37.760743134 | -122.421588982 | - | - | 1710539427000 | MTA | TA (SYM) PLO AT ALL TIMES (5 MIN) | 18TH ST to 19TH ST (700 - 799) | - | SPL 762 | - | - | - | - | - | 91637 | 1342483200000 | -122.42150181 | 37.76090111 | - | 1566864000000 | - | D8 | - | OTHER REGULATORY | REG | R38(SF)1.0001 | 14X21 | SUP2 | 2IN IRON POST | IS | 1564053960000 | VALENCIA ST | 700 - 799 VALENCIA ST | 700 - 799 VALENCIA ST | 700 VALENCIA ST | - | 19TH ST | 19TH ST |
| 74521 | N/A | Point | - | - | - | - | S256566 | 1ST ST: MINNA ST | - | T | T | - | F | 24542000 | 24542000 | - | - | NORTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MINNA ST | MINNA ST | 103554 | 103554 | 37.78933265 | -122.3970348 | 1ST ST \ MINNA ST | 01ST ST \ MINNA ST | 1710539427000 | MTA | ONE WAY (RA) | MINNA ST intersection | - | - | - | - | - | - | - | 91638 | 1537747200000 | -122.3970348 | 37.78933265 | - | 1564704000000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | SIGNAL POLE | IS | 1564484820000 | 01ST ST | - | - | - | - | - | - |
| 74522 | N/A | Point | - | - | - | - | S256567 | 1ST ST: MINNA ST | - | T | T | - | F | 24542000 | 24542000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MINNA ST | MINNA ST | 103555 | 103555 | 37.78933265 | -122.3970348 | 1ST ST \ MINNA ST | 01ST ST \ MINNA ST | 1710539427000 | MTA | ONE WAY (RA) | MINNA ST intersection | - | OPPO SOUTHWEST CORNER | - | - | - | - | - | 91639 | 1537747200000 | -122.3970348 | 37.78933265 | - | 1564704000000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | SIGNAL POLE | IS | 1564484940000 | 01ST ST | - | - | - | - | - | - |
| 74523 | N/A | Point | - | 1 | 1 - 99 | - | S256572 | 1-99 WARRIORS WAY | 1-99 WARRIORS WAY | F | F | - | F | 15031000 | 15031000 | - | - | SOUTH SIDE | - | - | - | - | TERRY A FRANCOIS BLVD | TERRY A FRANCOIS BLVD | 103556 | 103556 | 37.76896326 | -122.38692775 | - | - | 1710539427000 | MTA | TA (SYM) NO STOPPING 12MID- 6AM DAILY | TERRY A FRANCOIS BLVD to BRIDGEVIEW WAY (1 - 99) | - | 180' WEST OF TERRY FRANCOIS | - | - | - | - | - | 91640 | 1250208000000 | -122.38692775 | 37.76896326 | - | 1565654400000 | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0109 | 18X21 | SUP1 | LIGHT POLE | IS | 1564490220000 | WARRIORS WAY | 1 - 99 WARRIORS WAY | 1 - 99 WARRIORS WAY | 1 WARRIORS WAY | - | BRIDGEVIEW WAY | BRIDGEVIEW WAY |
| 74524 | N/A | Point | - | - | - | - | S104757 | LEAVENWORTH ST: CALIFORNIA ST | - | F | F | - | F | 25231000 | 25231000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 105230 | 105230 | 37.79120631 | -122.4157502 | LEAVENWORTH ST \ CALIFORNIA ST | LEAVENWORTH ST \ CALIFORNIA ST | 1752608374000 | middleware_editor | DO NOT ENTER | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 91641 | 28108800000 | -122.4157502 | 37.79120631 | - | 1752606900000 | - | D3 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | SIGNAL POLE | IS | 1373569020000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 74525 | N/A | Point | - | - | - | - | S105116 | 12TH AVE: CLEMENT ST | - | F | F | - | F | 27306000 | 27306000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 105233 | 105233 | 37.7826524 | -122.470846 | 12TH AVE \ CLEMENT ST | 12TH AVE \ CLEMENT ST | 1740089201000 | middleware_editor | STOP | CLEMENT ST intersection | 121884979 | - | - | - | - | - | - | 91642 | 52074000000 | -122.470846 | 37.7826524 | - | 1740044880000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569140000 | 12TH AVE | - | - | - | - | - | - |
| 74526 | N/A | Point | - | - | - | - | S106026 | BROADMOOR DR: WINSTON DR | - | F | F | - | F | 23063000 | 23063000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BROADMOOR DR | BROADMOOR DR | 105252 | 105252 | 37.72685485 | -122.47334716 | WINSTON DR \ BROADMOOR DR | WINSTON DR \ BROADMOOR DR | 1729723780000 | middleware_editor | ONE WAY (RA) | BROADMOOR DR intersection | - | 0 / MAKE ONE WAY NORTH BOUND | - | - | - | - | - | 91643 | 116726400000 | -122.47334716 | 37.72685485 | - | - | - | D7 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | UNKNOWN | IS | 1373569440000 | WINSTON DR | - | - | - | - | - | - |
| 74527 | N/A | Point | - | - | - | - | S105882 | ARCH ST: RANDOLPH ST | - | F | F | - | F | 22525000 | 22525000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ARCH ST | ARCH ST | 105254 | 105254 | 37.71427319 | -122.46709432 | RANDOLPH ST \ ARCH ST | RANDOLPH ST \ ARCH ST | 1710539427000 | MTA | STOP | ARCH ST intersection | - | - | - | - | - | - | - | 91644 | 105728400000 | -122.46709432 | 37.71427319 | - | 1220288400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569380000 | RANDOLPH ST | - | - | - | - | - | - |
| 74528 | N/A | Point | - | - | - | - | S260329 | MARKET ST: 12TH ST \ PAGE ST | - | T | T | - | F | 30749000 | 30749000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 12TH ST \ MARKET ST | 12TH ST \ PAGE ST | 105270 | 105270 | 37.77446604 | -122.420364747 | PAGE ST \ 12TH ST \ MARKET ST | MARKET ST \ 12TH ST \ PAGE ST | 1710539427000 | MTA | EXCEPT BIKE (SYM) | 12TH ST \ PAGE ST intersection | - | - | - | - | - | - | - | 91645 | 1580739840000 | -122.42025428 | 37.77435868 | - | - | - | D5 | - | OTHER REGULATORY | REG | R(SF).0362 | 24X18 | SUP1 | SIGNAL POLE | IS | 1579008660000 | MARKET ST | - | - | - | - | - | - |
| 74529 | N/A | Point | - | - | - | - | S229297 | YORK ST: 24TH ST | - | F | F | - | F | 23957000 | 23957000 | - | - | SOUTH EAST CORNER | - | - | - | - | YORK ST | 24TH ST | 105276 | 105276 | 37.7528041607464 | -122.408127207304 | 24TH ST \ YORK ST | YORK ST \ 24TH ST | 1748356557000 | middleware_editor | YORK ST | 24TH ST intersection | - | 1200 | - | - | - | - | - | 91646 | 1476805380000 | -122.40818897 | 37.7528524 | - | 1476774000000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1902 | 36X08 | SUP2 | LIGHT POLE | IS | 1474984860000 | YORK ST | - | - | - | - | - | - |
| 74530 | N/A | Point | - | - | - | - | S233875 | GLENBROOK AVE: SAINT GERMAIN A | - | F | F | - | F | 26247000 | 26247000 | - | - | SOUTH WEST CORNER | - | - | - | - | SAINT GERMAIN AVE | GLENBROOK AVE | 105295 | 105295 | 37.75745823 | -122.4502893 | GLENBROOK AVE \ SAINT GERMAIN AVE | SAINT GERMAIN AVE \ GLENBROOK AVE | 1710539427000 | MTA | GLENBROOK AVE | GLENBROOK AVE intersection | - | - | - | - | - | - | - | 91647 | - | -122.4502893 | 37.75745823 | - | - | - | D7 | - | STREET NAME | GUIDE | D3-1.0739 | 36X08 | SUP2 | 3IN IRON POST | IS | 1487852580000 | SAINT GERMAIN AVE | - | - | - | - | - | - |
| 74531 | N/A | Point | 1 | 1 | 264 - 299 | - | S274169 | 264-299 6TH ST | 264-299 06TH ST | F | F | - | F | 334000 | 334000 | - | - | EAST SIDE | - | - | - | - | CLEMENTINA ST | CLEMENTINA ST | 105386 | 105386 | 37.77872393 | -122.40588906 | - | - | 1710539427000 | MTA | BIKE RACK | CLEMENTINA ST to FOLSOM ST (264 - 299) | 328459 | 31' S OF NPL 275/3' IN FROM CURB | - | - | - | - | - | 91648 | 1620211680000 | -122.40588906 | 37.77872393 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1619085480000 | 06TH ST | 264 - 299 6TH ST | 264 - 299 06TH ST | 264 6TH ST | - | FOLSOM ST | FOLSOM ST |
| 74532 | N/A | Point | - | - | - | - | S274251 | 45TH AVE: BALBOA ST | - | F | F | - | F | 27984000 | 27984000 | - | - | NORTH WEST CORNER | - | - | - | - | 45TH AVE | 45TH AVE | 105406 | 105406 | 37.775403103 | -122.505983452 | BALBOA ST \ 45TH AVE | BALBOA ST \ 45TH AVE | 1753737314000 | middleware_editor | 45TH AVE | 45TH AVE intersection | - | - | - | - | - | - | - | 91649 | - | -122.50588421 | 37.7753236 | - | 1753736400000 | - | D1 | - | STREET NAME | GUIDE | D3-1.0035 | 36X08 | SUP2 | 3IN IRON POST | IS | 1619447820000 | BALBOA ST | - | - | - | - | - | - |
| 74533 | N/A | Point | - | - | - | - | S274252 | 45TH AVE: BALBOA ST | - | F | F | - | F | 27984000 | 27984000 | - | - | NORTH WEST CORNER | - | - | - | - | 45TH AVE | 45TH AVE | 105407 | 105407 | 37.775402043 | -122.505982111 | BALBOA ST \ 45TH AVE | BALBOA ST \ 45TH AVE | 1753737311000 | middleware_editor | BALBOA ST | 45TH AVE intersection | - | - | - | - | - | - | - | 91650 | - | -122.50588421 | 37.7753236 | - | 1753736400000 | - | D1 | - | STREET NAME | GUIDE | D3-1.0160 | 36X08 | SUP2 | 3IN IRON POST | IS | 1619448180000 | BALBOA ST | - | - | - | - | - | - |
| 74534 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S217159 | 1700-1799 17TH AVE | 1700-1799 17TH AVE | F | F | - | F | 762000 | 762000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | MORAGA ST | MORAGA ST | 105408 | 105408 | 37.7552682 | -122.47439915 | - | - | 1710539427000 | MTA | SPEED HUMPS | MORAGA ST to NORIEGA ST (1700 - 1799) | - | NPL#1786 | - | - | - | - | - | 91651 | 1438335300000 | -122.47439915 | 37.7552682 | - | 1438300800000 | - | D7 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1434552540000 | 17TH AVE | 1700 - 1799 17TH AVE | 1700 - 1799 17TH AVE | 1700 17TH AVE | - | NORIEGA ST | NORIEGA ST |
| 74535 | N/A | Point | - | - | - | - | S217088 | MARKET ST: EAGLE ST | - | F | F | - | F | 26185000 | 26185000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | EAGLE ST | EAGLE ST | 105412 | 105412 | 37.75882546 | -122.44470747 | MARKET ST \ EAGLE ST | MARKET ST \ EAGLE ST | 1710539427000 | MTA | SIGNAL AHEAD (SYM) | EAGLE ST intersection | - | - | - | - | - | - | - | 91652 | 1434463620000 | -122.44470747 | 37.75882546 | - | 1434412800000 | - | D8 | - | OTHER WARNING | WARNING | W3-3.0001 | 30X30 | SUP2 | SIGNAL POLE | IS | 1434438960000 | MARKET ST | - | - | - | - | - | - |
| 74536 | N/A | Point | - | - | - | - | S106245 | MADRID ST: EXCELSIOR AVE | - | F | F | - | F | 21686000 | 21686000 | - | SHOULD BE RETIRED | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MADRID ST | EXCELSIOR AVE | 105420 | 105420 | 37.724590757 | -122.430411973 | EXCELSIOR AVE \ MADRID ST | MADRID ST \ EXCELSIOR AVE | 1746135016000 | middleware_editor | STOP | EXCELSIOR AVE intersection | - | 0 / 0 | - | - | - | - | - | 91653 | 131011200000 | -122.4304531 | 37.72472512 | - | 1684134000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | RETD | 1373569500000 | MADRID ST | - | - | - | - | - | - |
| 74537 | N/A | Point | - | - | - | - | S106129 | VIENNA ST: BRAZIL AVE | - | F | F | - | F | 21639000 | 21639000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | VIENNA ST | 105425 | 105425 | 37.722128544 | -122.42925391 | VIENNA ST \ BRAZIL AVE | BRAZIL AVE \ VIENNA ST | 1710539427000 | MTA | STOP | VIENNA ST intersection | - | - | - | - | - | - | - | 91654 | 124416000000 | -122.42924944 | 37.722026 | - | 1289779200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | BRAZIL AVE | - | - | - | - | - | - |
| 74538 | N/A | Point | - | - | - | - | S132326 | WEBSTER ST: GREEN ST | - | F | F | - | F | 26661000 | 26661000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WEBSTER ST | GREEN ST | 105440 | 105440 | 37.79636664 | -122.4336579 | GREEN ST \ WEBSTER ST | WEBSTER ST \ GREEN ST | 1753977317000 | middleware_editor | NO TRUCKS (SYM) OVER 3 TONS | GREEN ST intersection | - | - | - | - | - | - | - | 91655 | 1273042800000 | -122.4336579 | 37.79636664 | - | - | - | D2 | - | OTHER REGULATORY | REG | R5-2.0005 | 30X30 | SUP1 | LIGHT POLE | IS | 1373577660000 | WEBSTER ST | - | - | - | - | - | - |
| 74539 | N/A | Point | - | - | - | - | S276270 | JUDAH ST: 47TH AVE | - | T | T | - | F | 27950000 | 27950000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 47TH AVE | JUDAH ST | 107489 | 107489 | 37.76037707 | -122.50699921 | JUDAH ST \ 47TH AVE | 47TH AVE \ JUDAH ST | 1710539427000 | MTA | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EXC SAT & SUN | JUDAH ST intersection | - | - | - | - | - | - | - | 91656 | 1507075200000 | -122.50699921 | 37.76037707 | - | 1630281600000 | - | D4 | - | NO LEFT TURN | REG | R33A(CA).0014 | 30X48 | SUP2 | LIGHT POLE | IS | 1626427560000 | 47TH AVE | - | - | - | - | - | - |
| 74540 | N/A | Point | - | - | - | - | S276274 | PORTOLA DR: LAGUNA HONDA BLVD | - | F | F | - | F | 22840000 | 22840000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | LAGUNA HONDA BLVD | PORTOLA DR | 107490 | 107490 | 37.74304867 | -122.45527108 | PORTOLA DR \ LAGUNA HONDA BLVD | LAGUNA HONDA BLVD \ PORTOLA DR | 1710539427000 | MTA | NO U TURN (SYM) | PORTOLA DR intersection | - | - | - | - | - | - | - | 91657 | - | -122.45527108 | 37.74304867 | - | - | - | D7 | - | OTHER REGULATORY | REG | R3-4.0001 | 24X24 | SUP2 | SIGNAL POLE | IS | 1626428940000 | LAGUNA HONDA BLVD | - | - | - | - | - | - |
| 74541 | N/A | Point | - | - | - | - | S276280 | PORTOLA DR: LAGUNA HONDA BLVD | - | F | F | - | F | 22840000 | 22840000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | LAGUNA HONDA BLVD | PORTOLA DR | 107491 | 107491 | 37.74304867 | -122.45527108 | PORTOLA DR \ LAGUNA HONDA BLVD | LAGUNA HONDA BLVD \ PORTOLA DR | 1710539427000 | MTA | NO U TURN (SYM) | PORTOLA DR intersection | - | - | - | - | - | - | - | 91658 | 1629988980000 | -122.45527108 | 37.74304867 | - | - | - | D7 | - | OTHER REGULATORY | REG | R3-4.0001 | 24X24 | SUP2 | SIGNAL POLE | IS | 1626429900000 | LAGUNA HONDA BLVD | - | - | - | - | - | - |
| 74542 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S276372 | 2000-2099 TURK BLVD | 2000-2099 TURK BLVD | F | F | - | F | 26362000 | 12737000 | - | - | CENTER ISLAND | - | - | - | - | BAKER ST \ TURK BLVD | BAKER ST \ TURK ST | 107492 | 107492 | 37.77914103 | -122.44287621 | TURK ST \ BAKER ST \ TURK BLVD | - | 1710539427000 | MTA | FG 300 EFX DELINEATOR (Y) | BAKER ST \ TURK ST to ARBOL LN \ LYON ST (2000 - 2099) | - | FROM CRSSWLK TO 300FT WEST/EVERY20FT O.C | - | - | - | - | - | 91659 | 1626825600000 | -122.44287621 | 37.77914103 | - | 1626825600000 | - | D2 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1626868680000 | TURK BLVD | - | 2000 - 2099 TURK BLVD | 2000 TURK BLVD | - | - | ARBOL LN \ LYON ST |
| 74543 | N/A | Point | 1 | 1 | 400 - 499 | - | S276619 | 400-499 KEARNY ST | 400-499 KEARNY ST | F | F | - | F | 7754000 | 7754000 | - | - | WEST SIDE | - | - | - | - | PINE ST | PINE ST | 107494 | 107494 | 37.79216462 | -122.40431913 | - | - | 1721159495000 | middleware_editor | NPRK 2AM-6AM EVERYDAY INCLUDING HOLIDAY STCL | PINE ST to CALIFORNIA ST (400 - 499) | - | 70' S OF CALIFORNIA | - | - | - | - | - | 91660 | - | -122.40431913 | 37.79216462 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0113 | 18X18 | SUP1 | 2IN FLANGE POST | IS | 1627470000000 | KEARNY ST | 400 - 499 KEARNY ST | 400 - 499 KEARNY ST | 400 KEARNY ST | - | CALIFORNIA ST | CALIFORNIA ST |
| 74544 | N/A | Point | 1 | 1 | 400 - 499 | LEFT ARROW | S276622 | 400-499 KEARNY ST | 400-499 KEARNY ST | F | F | - | F | 7754000 | 7754000 | - | - | WEST SIDE | - | - | - | - | PINE ST | PINE ST | 107495 | 107495 | 37.79216462 | -122.40431913 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7AM-7PM MON-SAT (5 MIN) | PINE ST to CALIFORNIA ST (400 - 499) | - | 55' S OF CALIFORNIA ST | - | - | - | - | - | 91661 | 1605225600000 | -122.40431913 | 37.79216462 | - | 1627603200000 | - | D3 | - | OTHER REGULATORY | REG | R38(SF)1.0014 | 14X21 | SUP1 | 2IN FLANGE POST | IS | 1627470300000 | KEARNY ST | 400 - 499 KEARNY ST | 400 - 499 KEARNY ST | 400 KEARNY ST | - | CALIFORNIA ST | CALIFORNIA ST |
| 74545 | N/A | Point | 1 | 1 | 1100 - 1149 | - | S273691 | 1100-1149 ILLINOIS ST | 1100-1149 ILLINOIS ST | F | F | - | F | 7170000 | 7170000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 22ND ST | 22ND ST | 107497 | 107497 | 37.75738882 | -122.38725362 | - | - | 1710539427000 | MTA | BIKE WAYFINDING SIGN | 22ND ST to HUMBOLDT ST (1100 - 1149) | 1553 | UNDER OTHER WAYFINDING SIGN/22' S | - | - | - | - | - | 91662 | 1359072000000 | -122.38725362 | 37.75738882 | - | 1561593600000 | - | D10 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | 2IN IRON POST | IS | 1617097980000 | ILLINOIS ST | 1100 - 1149 ILLINOIS ST | 1100 - 1149 ILLINOIS ST | 1100 ILLINOIS ST | - | HUMBOLDT ST | HUMBOLDT ST |
| 74546 | N/A | Point | - | - | - | - | S273846 | COLLEGE TER: MISSION ST | - | F | F | - | F | 33391000 | 33391000 | - | - | SOUTH WEST CORNER | - | - | - | - | MISSION ST | COLLEGE TER | 107499 | 107499 | 37.734278 | -122.4257918 | COLLEGE TER \ MISSION ST | MISSION ST \ COLLEGE TER | 1710539427000 | MTA | COLLEGE TER | COLLEGE TER intersection | - | - | - | - | - | - | - | 91663 | 1633348800000 | -122.4257918 | 37.734278 | - | 1647993600000 | - | D8 | - | STREET NAME | GUIDE | D3-1.0413 | 36X08 | SUP2 | 3IN IRON POST | IS | 1617715560000 | MISSION ST | - | - | - | - | - | - |
| 74547 | N/A | Point | - | - | - | - | S273848 | COLLEGE TER: MISSION ST | - | F | F | - | F | 33391000 | 33391000 | - | - | SOUTH WEST CORNER | - | - | - | - | MISSION ST | COLLEGE TER | 107500 | 107500 | 37.734278 | -122.4257918 | COLLEGE TER \ MISSION ST | MISSION ST \ COLLEGE TER | 1710539427000 | MTA | PRIVATE (BLOCK PLATE) | COLLEGE TER intersection | - | - | - | - | - | - | - | 91664 | 1633362900000 | -122.4257918 | 37.734278 | - | - | - | D8 | - | STREET NAME | GUIDE | D3-1(SF).0116 | 12X05 | SUP2 | 3IN IRON POST | IS | 1617715740000 | MISSION ST | - | - | - | - | - | - |
| 74548 | N/A | Point | 1 | 1 | 600 - 655 | - | S273868 | 600-655 47TH AVE | 600-655 47TH AVE | F | F | - | F | 2038000 | 2038000 | - | - | WEST SIDE | - | - | - | - | ANZA ST | ANZA ST | 107501 | 107501 | 37.77662086 | -122.50812615 | - | - | 1710539427000 | MTA | NPRK 1PM-3PM 2ND & 4TH FRI OF MONTH STCL | ANZA ST to SUTRO HEIGHTS AVE (600 - 655) | - | 20FT NORTH OF BALBOA | - | - | - | - | - | 91665 | 1221436800000 | -122.50812615 | 37.77662086 | - | 1675900800000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0098 | 18X18 | SUP2 | 2IN IRON POST | IS | 1617800520000 | 47TH AVE | 600 - 655 47TH AVE | 600 - 655 47TH AVE | 600 47TH AVE | - | SUTRO HEIGHTS AVE | SUTRO HEIGHTS AVE |
| 74549 | N/A | Point | 1 | 1 | 600 - 655 | - | S273870 | 600-655 47TH AVE | 600-655 47TH AVE | F | F | - | F | 2038000 | 2038000 | - | - | EAST SIDE | - | - | - | - | ANZA ST | ANZA ST | 107502 | 107502 | 37.77662086 | -122.50812615 | - | - | 1710539427000 | MTA | NPRK 1PM-3PM 2ND & 4TH WED OF MONTH STCL | ANZA ST to SUTRO HEIGHTS AVE (600 - 655) | - | 20 FT NORTH OF BALBOA | - | - | - | - | - | 91666 | 1233014400000 | -122.50812615 | 37.77662086 | - | 1675900800000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0102 | 18X18 | SUP2 | 2IN IRON POST | IS | 1617803040000 | 47TH AVE | 600 - 655 47TH AVE | 600 - 655 47TH AVE | 600 47TH AVE | - | SUTRO HEIGHTS AVE | SUTRO HEIGHTS AVE |
| 74550 | N/A | Point | 1 | 1 | 1300 - 1399 | RIGHT ARROW | S277043 | 1300-1399 18TH AVE | 1300-1399 18TH AVE | F | F | - | F | 835000 | 835000 | - | - | WEST SIDE | - | - | - | - | IRVING ST | IRVING ST | 107504 | 107504 | 37.76267796 | -122.47598924 | - | - | 1734531324000 | middleware_editor | TA (SYM) PLO 7AM-9AM/12PM-2:30PM SCHOOL DAYS (5 MIN) | IRVING ST to JUDAH ST (1300 - 1399) | - | 285' SOUTH OF IRVING OPPO 1344 | - | - | - | - | - | 91667 | 1206057600000 | -122.47598924 | 37.76267796 | - | 1734452040000 | - | D4 | - | OTHER REGULATORY | REG | R38(SF)6.0097 | 14X21 | SUP2 | 2IN IRON POST | IS | 1628586120000 | 18TH AVE | 1300 - 1399 18TH AVE | 1300 - 1399 18TH AVE | 1300 18TH AVE | - | JUDAH ST | JUDAH 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 metersMetadata automatically harvested from the ESRI service during import.