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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5926 | N/A | Point | 1 | 1 | 50 - 99 | - | S214288 | 50-99 DIVISION ST | 50-99 DIVISION ST | F | F | - | F | 4839000 | 4839000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | 8TH ST | 08TH ST | 52357 | 52357 | 37.76978945 | -122.40370847 | - | - | 1753723695000 | middleware_editor | ONE WAY (RA) | 08TH ST to HENRY ADAMS ST (50 - 99) | - | N/S OF C/I OPP C/L OF 8TH ST | - | - | - | - | - | 22998 | - | -122.40370847 | 37.76978945 | - | - | - | D10 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | 2IN IRON POST | IS | 1426504860000 | DIVISION ST | 50 - 99 DIVISION ST | 50 - 99 DIVISION ST | 50 DIVISION ST | - | HENRY ADAMS ST | HENRY ADAMS ST |
| 5927 | N/A | Point | 1 | 1 | 50 - 99 | - | S214289 | 50-99 DIVISION ST | 50-99 DIVISION ST | F | F | - | F | 4839000 | 4839000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | 8TH ST | 08TH ST | 52358 | 52358 | 37.76978945 | -122.40370847 | - | - | 1753723696000 | middleware_editor | NO LEFT TURN (SYM) | 08TH ST to HENRY ADAMS ST (50 - 99) | - | N/S OF TRAFFIC ISLAND OPP C/L OF 8TH ST | - | - | - | - | - | 22999 | - | -122.40370847 | 37.76978945 | - | - | - | D10 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | 2IN IRON POST | IS | 1426505280000 | DIVISION ST | 50 - 99 DIVISION ST | 50 - 99 DIVISION ST | 50 DIVISION ST | - | HENRY ADAMS ST | HENRY ADAMS ST |
| 5928 | N/A | Point | 1 | 1 | 50 - 99 | - | S214290 | 50-99 DIVISION ST | 50-99 DIVISION ST | F | F | - | F | 4839000 | 4839000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | 8TH ST | 08TH ST | 52359 | 52359 | 37.76978945 | -122.40370847 | - | - | 1753723693000 | middleware_editor | ROUNDABOUT DIRECTIONAL (2) | 08TH ST to HENRY ADAMS ST (50 - 99) | - | N/S OF C/I OPP C/L OF 8TH ST | - | - | - | - | - | 23000 | 1429723080000 | -122.40370847 | 37.76978945 | - | 1429686000000 | - | D10 | - | OTHER REGULATORY | REG | R6-4.0001 | 36X18 | SUP1 | 2IN IRON POST | IS | 1426505640000 | DIVISION ST | 50 - 99 DIVISION ST | 50 - 99 DIVISION ST | 50 DIVISION ST | - | HENRY ADAMS ST | HENRY ADAMS ST |
| 5929 | N/A | Point | 1 | 1 | 300 - 399 | - | S214306 | 300-399 SAINT JOSEPHS AVE | 300-399 SAINT JOSEPHS AVE | F | F | - | F | 11309000 | 11309000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | OFARRELL ST | OFARRELL ST | 52360 | 52360 | 37.7825142 | -122.44230251 | - | - | 1727389541000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | OFARRELL ST to BAKER ST \ GEARY BLVD (300 - 399) | - | 5'SOUTH OF GEARY | - | - | - | - | - | 23001 | 1428322200000 | -122.44230251 | 37.7825142 | - | 1428278400000 | - | D2 | - | NO RIGHT TURN | REG | R13A(CA).0002 | 24X30 | SUP1 | SIGNAL POLE | IS | 1426510980000 | SAINT JOSEPHS AVE | 300 - 399 SAINT JOSEPHS AVE | 300 - 399 SAINT JOSEPHS AVE | 300 SAINT JOSEPHS AVE | - | BAKER ST \ GEARY BLVD | BAKER ST \ GEARY BLVD |
| 5930 | N/A | Point | - | - | - | - | S224621 | DETROIT ST: HEARST AVE | - | F | F | - | F | 22155000 | 22155000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DETROIT ST | DETROIT ST | 58912 | 58912 | 37.73070822 | -122.44429841 | HEARST AVE \ DETROIT ST | HEARST AVE \ DETROIT ST | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | DETROIT ST intersection | - | - | - | - | - | - | - | 23002 | - | -122.44429841 | 37.73070822 | - | - | - | D7 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | 2IN IRON POST | IS | 1460022360000 | HEARST AVE | - | - | - | - | - | - |
| 5931 | N/A | Point | 1 | 1 | 1 - 99 | - | S224628 | 1-99 TAMALPAIS TER | 1-99 TAMALPAIS TER | F | F | - | F | 12372000 | 12372000 | - | - | WEST SIDE | - | - | - | - | TURK BLVD | TURK BLVD | 58913 | 58913 | 37.77791116 | -122.44878126 | - | - | 1719958322000 | middleware_editor | NPRK 8AM-10AM WED STCL | TURK BLVD to GOLDEN GATE AVE (1 - 99) | - | 60` S OF TURK | - | - | - | - | - | 23003 | - | -122.44878126 | 37.77791116 | - | 1719927540000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP2 | 2IN IRON POST | IS | 1460028060000 | TAMALPAIS TER | 1 - 99 TAMALPAIS TER | 1 - 99 TAMALPAIS TER | 1 TAMALPAIS TER | - | GOLDEN GATE AVE | GOLDEN GATE AVE |
| 5932 | N/A | Point | 1 | 1 | 1 - 99 | - | S224629 | 1-99 PARSONS ST | 1-99 PARSONS ST | F | F | - | F | 10299000 | 10299000 | - | - | EAST SIDE | - | - | - | - | MCALLISTER ST | MCALLISTER ST | 58914 | 58914 | 37.7751491 | -122.45534661 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "L" PERMITS | MCALLISTER ST to FULTON ST (1 - 99) | - | 45`NORTH OF FULTON | - | - | - | - | - | 23004 | 1460982900000 | -122.45534661 | 37.7751491 | - | 1460937600000 | - | D1 | - | PARKING:RPP | REG | R32C(CA).0095 | 18X21 | SUP2 | 2 POST ALUMINUM | IS | 1460028600000 | PARSONS ST | 1 - 99 PARSONS ST | 1 - 99 PARSONS ST | 1 PARSONS ST | - | FULTON ST | FULTON ST |
| 5933 | N/A | Point | - | - | - | - | S220742 | JONES ST: CHESTNUT ST | - | F | F | - | F | 25527000 | 25527000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JONES ST | CHESTNUT ST | 58915 | 58915 | 37.80334797 | -122.41651077 | CHESTNUT ST \ JONES ST | JONES ST \ CHESTNUT ST | 1710539427000 | MTA | TOUR BUSES & VANS (SEAT CAP 8 OR MORE PASSGRS) PROHIBITED | CHESTNUT ST intersection | - | - | - | - | - | - | - | 23005 | - | -122.41651077 | 37.80334797 | - | - | - | D2 | - | OTHER REGULATORY | REG | R(SF).0272 | 36X30 | SUP1 | 2IN IRON POST | IS | 1448001780000 | JONES ST | - | - | - | - | - | - |
| 5934 | N/A | Point | - | - | - | - | S220743 | JONES ST: CHESTNUT ST | - | F | F | - | F | 25527000 | 25527000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | JONES ST | CHESTNUT ST | 58916 | 58916 | 37.80334797 | -122.41651077 | CHESTNUT ST \ JONES ST | JONES ST \ CHESTNUT ST | 1736796075000 | middleware_editor | TOUR BUSES & VANS (SEAT CAP 8 OR MORE PASSGRS) PROHIBITED | CHESTNUT ST intersection | - | - | - | - | - | - | - | 23006 | - | -122.41651077 | 37.80334797 | - | - | - | D2 | - | OTHER REGULATORY | REG | R(SF).0272 | 36X30 | SUP1 | 2IN IRON POST | IS | 1448002380000 | JONES ST | - | - | - | - | - | - |
| 5935 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S220744 | 2300-2399 JONES ST | 2300-2399 JONES ST | F | F | - | F | 7595000 | 7595000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LOMBARD ST | LOMBARD ST | 58917 | 58917 | 37.8028794 | -122.41641756 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | LOMBARD ST to CHESTNUT ST (2300 - 2399) | 227943 | IFO# 2331 | - | - | - | - | - | 23007 | 1205798400000 | -122.41641756 | 37.8028794 | - | 1624406400000 | - | D2 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | 2IN IRON POST | IS | 1448002740000 | JONES ST | 2300 - 2399 JONES ST | 2300 - 2399 JONES ST | 2300 JONES ST | - | CHESTNUT ST | CHESTNUT ST |
| 5936 | N/A | Point | - | - | - | - | S220745 | FRANCISCO ST: JONES ST | - | F | F | - | F | 25528000 | 25528000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JONES ST | FRANCISCO ST | 58918 | 58918 | 37.80427682 | -122.41669633 | FRANCISCO ST \ JONES ST | JONES ST \ FRANCISCO ST | 1710539427000 | MTA | STOP | FRANCISCO ST intersection | - | - | - | - | - | - | - | 23008 | 1154044800000 | -122.41669633 | 37.80427682 | - | 1556496000000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1448003220000 | JONES ST | - | - | - | - | - | - |
| 5937 | N/A | Point | - | - | - | - | S220747 | LEAVENWORTH ST: FRANCISCO ST | - | F | F | - | F | 30764000 | 30764000 | - | - | NORTH EAST CORNER | - | - | - | - | FRANCISCO ST | FRANCISCO ST | 58919 | 58919 | 37.80365022 | -122.41825589 | LEAVENWORTH ST \ FRANCISCO ST | LEAVENWORTH ST \ FRANCISCO ST | 1710539427000 | MTA | LEAVENWORTH ST | FRANCISCO ST intersection | - | - | - | - | - | - | - | 23009 | - | -122.41825589 | 37.80365022 | - | - | - | D2 | - | STREET NAME | GUIDE | D3-1.1025 | 36X08 | SUP1 | 3IN IRON POST | IS | 1448004060000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 5938 | N/A | Point | - | - | - | - | S220748 | LEAVENWORTH ST: FRANCISCO ST | - | F | F | - | F | 30764000 | 30764000 | - | - | NORTH EAST CORNER | - | - | - | - | FRANCISCO ST | FRANCISCO ST | 58920 | 58920 | 37.80365022 | -122.41825589 | LEAVENWORTH ST \ FRANCISCO ST | LEAVENWORTH ST \ FRANCISCO ST | 1710539427000 | MTA | FRANCISCO ST | FRANCISCO ST intersection | - | - | - | - | - | - | - | 23010 | - | -122.41825589 | 37.80365022 | - | - | - | D2 | - | STREET NAME | GUIDE | D3-1.0687 | 36X08 | SUP1 | 3IN IRON POST | IS | 1448004240000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 5939 | N/A | Point | - | - | - | - | S220749 | POLK ST: FILBERT ST | - | F | F | - | F | 25564000 | 25564000 | - | - | NORTH WEST CORNER | - | - | - | - | FILBERT ST | FILBERT ST | 58921 | 58921 | 37.79969367 | -122.42252522 | POLK ST \ FILBERT ST | POLK ST \ FILBERT ST | 1710539427000 | MTA | POLK ST | FILBERT ST intersection | - | - | - | - | - | - | - | 23011 | 1452592620000 | -122.42252522 | 37.79969367 | - | 1452556800000 | - | D2 | - | STREET NAME | GUIDE | D3-1.1404 | 36X08 | SUP1 | LIGHT POLE | IS | 1448004840000 | POLK ST | - | - | - | - | - | - |
| 5940 | N/A | Point | - | - | - | - | S220750 | UNION ST: LAGUNA ST | - | F | F | - | F | 26583000 | 26583000 | - | - | NORTH WEST CORNER | - | - | - | - | UNION ST | UNION ST | 58922 | 58922 | 37.79771621 | -122.43055896 | LAGUNA ST \ UNION ST | LAGUNA ST \ UNION ST | 1718759112000 | middleware_editor | UNION ST | UNION ST intersection | - | - | - | - | - | - | - | 23012 | - | -122.43055896 | 37.79771621 | - | - | - | D2 | - | STREET NAME | GUIDE | D3-1.1765 | 36X08 | SUP1 | 3IN IRON POST | IS | 1448005440000 | LAGUNA ST | - | - | - | - | - | - |
| 5941 | N/A | Point | - | - | - | - | S221799 | MASON ST: JOHN ST | - | F | F | - | F | 25112000 | 25112000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MASON ST | JOHN ST | 58928 | 58928 | 37.79585068 | -122.41163044 | JOHN ST \ MASON ST | MASON ST \ JOHN ST | 1750689846000 | middleware_editor | ONE WAY (RA) | JOHN ST intersection | - | - | - | - | - | - | - | 23013 | 1452193380000 | -122.41163044 | 37.79585068 | - | 1452153600000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | 2IN IRON POST | IS | 1451919960000 | MASON ST | - | - | - | - | - | - |
| 5942 | N/A | Point | 1 | 1 | 2700 - 2799 | - | S221800 | 2700-2799 JONES ST | 2700-2799 JONES ST | F | F | - | F | 7601000 | 7601000 | - | - | EAST SIDE | - | - | - | - | NORTH POINT ST | NORTH POINT ST | 58929 | 58929 | 37.80660688 | -122.41716896 | - | - | 1736549217000 | middleware_editor | NPRK 2AM-4AM TUE THUR STCL | NORTH POINT ST to BEACH ST (2700 - 2799) | - | 120' SOUTH OF BEACH | - | - | - | - | - | 23014 | 1453472340000 | -122.41716896 | 37.80660688 | - | 1557792000000 | - | D3 | - | STREET CLEANING | REG | R30B(CA).0109 | 18X18 | SUP1 | 2IN IRON POST | IS | 1451920920000 | JONES ST | 2700 - 2799 JONES ST | 2700 - 2799 JONES ST | 2700 JONES ST | - | BEACH ST | BEACH ST |
| 5943 | N/A | Point | 1 | 1 | 2700 - 2799 | - | S221801 | 2700-2799 JONES ST | 2700-2799 JONES ST | F | F | - | F | 7601000 | 7601000 | - | - | EAST SIDE | - | - | - | - | NORTH POINT ST | NORTH POINT ST | 58930 | 58930 | 37.80660688 | -122.41716896 | - | - | 1710539427000 | MTA | NPRK 2AM-4AM TUE THUR STCL | NORTH POINT ST to BEACH ST (2700 - 2799) | - | 10' SOUTH OF BEACH | - | - | - | - | - | 23015 | 1453472400000 | -122.41716896 | 37.80660688 | - | 1453420800000 | - | D3 | - | STREET CLEANING | REG | R30B(CA).0109 | 18X18 | SUP1 | 2IN IRON POST | IS | 1451920920000 | JONES ST | 2700 - 2799 JONES ST | 2700 - 2799 JONES ST | 2700 JONES ST | - | BEACH ST | BEACH ST |
| 5944 | N/A | Point | - | - | - | - | S221802 | JONES ST: NORTH POINT ST | - | F | F | - | F | 25593000 | 25593000 | - | - | NORTH EAST CORNER | - | - | - | - | JONES ST | JONES ST | 58931 | 58931 | 37.80614125 | -122.41707728 | NORTH POINT ST \ JONES ST | NORTH POINT ST \ JONES ST | 1710539427000 | MTA | NPRK 2AM-4AM TUE THUR STCL | JONES ST intersection | - | - | - | - | - | - | - | 23016 | 1453472160000 | -122.41707728 | 37.80614125 | - | 1453420800000 | - | D3 | - | STREET CLEANING | REG | R30B(CA).0109 | 18X18 | SUP1 | 2IN IRON POST | IS | 1451921040000 | NORTH POINT ST | - | - | - | - | - | - |
| 5945 | N/A | Point | - | - | - | - | S221984 | SYCAMORE ST: MISSION ST | - | F | F | - | F | 24163000 | 24163000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SYCAMORE ST | SYCAMORE ST | 58933 | 58933 | 37.76271287 | -122.41944374 | MISSION ST \ SYCAMORE ST | MISSION ST \ SYCAMORE ST | 1717722463000 | middleware_editor | ONE WAY (LA) | SYCAMORE ST intersection | - | - | - | - | - | - | - | 23017 | 429148800000 | -122.41944374 | 37.76271287 | - | - | - | D9 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | 2IN IRON POST | IS | 1452503640000 | MISSION ST | - | - | - | - | - | - |
| 5946 | N/A | Point | - | - | - | - | S226178 | 8TH ST: FOLSOM ST | - | T | T | - | F | 24272000 | 24272000 | - | - | SOUTH WEST CORNER | - | - | - | - | FOLSOM ST | FOLSOM ST | 61885 | 61885 | 37.77499179 | -122.41006277 | 8TH ST \ FOLSOM ST | 08TH ST \ FOLSOM ST | 1710539427000 | MTA | BIKE (SYM) LANE | FOLSOM ST intersection | - | - | - | - | - | - | - | 23018 | - | -122.41006277 | 37.77499179 | - | - | - | D6 | - | BIKE REG | REG | R81(CA).0001 | 12X18 | SUP1 | LIGHT POLE | IS | 1464945480000 | 08TH ST | - | - | - | - | - | - |
| 5947 | N/A | Point | - | - | - | - | S226180 | FOLSOM ST: 8TH ST | - | T | T | - | F | 24272000 | 24272000 | - | - | SOUTH EAST CORNER | - | - | - | - | FOLSOM ST | FOLSOM ST | 61886 | 61886 | 37.77499179 | -122.41006277 | 8TH ST \ FOLSOM ST | 08TH ST \ FOLSOM ST | 1710539427000 | MTA | 8TH ST | FOLSOM ST intersection | - | >>>>300 | - | - | - | - | - | 23019 | - | -122.41006277 | 37.77499179 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.0047 | 36X08 | SUP1 | LIGHT POLE | IS | 1464945840000 | 08TH ST | - | - | - | - | - | - |
| 5948 | N/A | Point | - | - | - | - | S226183 | GOUGH ST: HAIGHT ST \ MARKET S | - | F | F | - | F | 30753000 | 30753000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | GOUGH ST \ MARKET ST | GOUGH ST \ HAIGHT ST | 61888 | 61888 | 37.77303605 | -122.42194125 | HAIGHT ST \ GOUGH ST \ MARKET ST | MARKET ST \ GOUGH ST \ HAIGHT ST | 1710539427000 | MTA | DO NOT BLOCK INTERSECTION | GOUGH ST \ HAIGHT ST intersection | - | 10FT NORTH OF HAIGHT | - | - | - | - | - | 23020 | 1465474860000 | -122.42194125 | 37.77303605 | - | 1465430400000 | - | D5 | - | OTHER REGULATORY | REG | R10-7.0001 | 24X30 | SUP1 | 2IN IRON POST | IS | 1464949320000 | MARKET ST | - | - | - | - | - | - |
| 5949 | N/A | Point | - | - | - | - | S226184 | OCTAVIA ST: BUSH ST | - | F | F | - | F | 26521000 | 26521000 | - | - | NORTH WEST CORNER | - | - | - | - | OCTAVIA ST | BUSH ST | 61889 | 61889 | 37.78786244 | -122.42686464 | BUSH ST \ OCTAVIA ST | OCTAVIA ST \ BUSH ST | 1710539427000 | MTA | NPPZ | BUSH ST intersection | - | NPPZ 5P 10P TUE TO SUN | - | - | - | - | - | 23021 | - | -122.42686464 | 37.78786244 | - | - | - | D5 | - | OTHER REGULATORY | REG | R30(SF).0003 | 10X15 | SUP1 | LIGHT POLE | IS | 1464951480000 | OCTAVIA ST | - | - | - | - | - | - |
| 5950 | N/A | Point | 1 | 1 | 100 - 199 | - | S226527 | 100-199 HOOPER ST | 100-199 HOOPER ST | F | F | - | F | 7022000 | 7022000 | - | - | SOUTH SIDE | - | - | - | - | 7TH ST | 07TH ST | 61892 | 61892 | 37.76816201 | -122.39929483 | - | - | 1739912457000 | middleware_editor | 4 HR PRK 8AM-6PM EXC SUN | 07TH ST to 08TH ST (100 - 199) | - | 300FT. WEST OF 7TH ST | - | - | - | - | - | 23022 | 1493078400000 | -122.39929483 | 37.76816201 | - | 1493078400000 | 1739883600000 | D10 | - | PARKING | REG | R32(CA).0104 | 18X18 | SUP1 | LIGHT POLE | RETD | 1465809000000 | HOOPER ST | 100 - 199 HOOPER ST | 100 - 199 HOOPER ST | 100 HOOPER ST | - | 08TH ST | 08TH ST |
| 5951 | N/A | Point | 1 | 1 | 200 - 267 | - | S227409 | 200-267 4TH ST | 200-267 04TH ST | F | F | - | F | 254000 | 254000 | - | - | WEST SIDE | - | - | - | - | HOWARD ST | HOWARD ST | 61894 | 61894 | 37.78285599 | -122.40220218 | - | - | 1710539427000 | MTA | TANSAT | HOWARD ST to CLEMENTINA ST (200 - 267) | - | 50' NORTH OF HOWARD ST | - | - | - | - | - | 23023 | - | -122.40220218 | 37.78285599 | - | - | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1469108040000 | 04TH ST | 200 - 267 4TH ST | 200 - 267 04TH ST | 200 4TH ST | - | CLEMENTINA ST | CLEMENTINA ST |
| 5952 | N/A | Point | - | - | - | - | S225203 | LAFAYETTE ST: HOWARD ST | - | F | F | - | F | 24360000 | 24360000 | - | - | NORTH WEST CORNER | - | - | - | - | HOWARD ST | HOWARD ST | 61896 | 61896 | 37.77245616 | -122.4163036 | LAFAYETTE ST \ HOWARD ST | LAFAYETTE ST \ HOWARD ST | 1710539427000 | MTA | ONE WAY (RA) | HOWARD ST intersection | - | X ST IS HOWARD | - | - | - | - | - | 23024 | - | -122.4163036 | 37.77245616 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | 2IN IRON POST | IS | 1461850020000 | LAFAYETTE ST | - | - | - | - | - | - |
| 5953 | N/A | Point | - | - | - | - | S225204 | LAFAYETTE ST: HOWARD ST | - | F | F | - | F | 24360000 | 24360000 | - | - | NORTH WEST CORNER | - | - | - | - | HOWARD ST | HOWARD ST | 61897 | 61897 | 37.77245616 | -122.4163036 | LAFAYETTE ST \ HOWARD ST | LAFAYETTE ST \ HOWARD ST | 1710539427000 | MTA | DO NOT ENTER | HOWARD ST intersection | - | X ST IS HOWARD | - | - | - | - | - | 23025 | - | -122.4163036 | 37.77245616 | - | - | - | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1461850200000 | LAFAYETTE ST | - | - | - | - | - | - |
| 5954 | N/A | Point | - | - | - | - | S225205 | LAFAYETTE ST: HOWARD ST | - | F | F | - | F | 24360000 | 24360000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HOWARD ST | HOWARD ST | 61898 | 61898 | 37.77245616 | -122.4163036 | LAFAYETTE ST \ HOWARD ST | LAFAYETTE ST \ HOWARD ST | 1710539427000 | MTA | STOP | HOWARD ST intersection | - | X ST IS HOWARD. BACK TO BACK DO NOT ENTE | - | - | - | - | - | 23026 | 1462279740000 | -122.4163036 | 37.77245616 | - | 1462233600000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1461850380000 | LAFAYETTE ST | - | - | - | - | - | - |
| 5955 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S225234 | 1000-1099 SHRADER ST | 1000-1099 SHRADER ST | T | T | - | F | 11859000 | 11859000 | - | - | WEST SIDE | - | - | - | - | CARL ST | CARL ST | 61899 | 61899 | 37.76514906 | -122.45130798 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | CARL ST to PARNASSUS AVE (1000 - 1099) | - | SPL #1025 | - | - | - | - | - | 23027 | 1462406400000 | -122.45130798 | 37.76514906 | - | 1462406400000 | - | D5 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP1 | LIGHT POLE | IS | 1462186140000 | SHRADER ST | 1000 - 1099 SHRADER ST | 1000 - 1099 SHRADER ST | 1000 SHRADER ST | - | PARNASSUS AVE | PARNASSUS AVE |
| 5956 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S225236 | 1100-1199 SHRADER ST | 1100-1199 SHRADER ST | F | F | - | F | 11860000 | 11860000 | - | - | WEST SIDE | - | - | - | - | PARNASSUS AVE | PARNASSUS AVE | 61900 | 61900 | 37.76426251 | -122.45112768 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | PARNASSUS AVE to GRATTAN ST (1100 - 1199) | - | 10' SOUTH OF PARNASSUS | - | - | - | - | - | 23028 | 1462458360000 | -122.45112768 | 37.76426251 | - | 1462406400000 | - | D5 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP1 | 2 POST ALUMINUM | IS | 1462186560000 | SHRADER ST | 1100 - 1199 SHRADER ST | 1100 - 1199 SHRADER ST | 1100 SHRADER ST | - | GRATTAN ST | GRATTAN ST |
| 5957 | N/A | Point | - | - | - | - | S222404 | BALBOA ST: 11TH AVE | - | F | F | - | F | 27294000 | 27294000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BALBOA ST | 11TH AVE | 61902 | 61902 | 37.77699033 | -122.46936101 | 11TH AVE \ BALBOA ST | BALBOA ST \ 11TH AVE | 1710539427000 | MTA | STOP | 11TH AVE intersection | 121512697 | - | - | - | - | - | - | 23029 | 1357257600000 | -122.46936101 | 37.77699033 | - | 1453766400000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1453361340000 | BALBOA ST | - | - | - | - | - | - |
| 5958 | N/A | Point | - | - | - | - | S222406 | BALBOA ST: 11TH AVE | - | F | F | - | F | 27294000 | 27294000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BALBOA ST | 11TH AVE | 61903 | 61903 | 37.77699033 | -122.46936101 | 11TH AVE \ BALBOA ST | BALBOA ST \ 11TH AVE | 1710539427000 | MTA | ALL WAY | 11TH AVE intersection | 121512697 | - | - | - | - | - | - | 23030 | 1357257600000 | -122.46936101 | 37.77699033 | - | 1453766400000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1453361520000 | BALBOA ST | - | - | - | - | - | - |
| 5959 | N/A | Point | - | - | - | - | S222408 | BALBOA ST: 11TH AVE | - | F | F | - | F | 27294000 | 27294000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BALBOA ST | 11TH AVE | 61904 | 61904 | 37.77699033 | -122.46936101 | 11TH AVE \ BALBOA ST | BALBOA ST \ 11TH AVE | 1710539427000 | MTA | STOP | 11TH AVE intersection | - | - | - | - | - | - | - | 23031 | 1357257600000 | -122.46936101 | 37.77699033 | - | 1453766400000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1453361700000 | BALBOA ST | - | - | - | - | - | - |
| 5960 | N/A | Point | - | - | - | - | S222409 | BALBOA ST: 11TH AVE | - | F | F | - | F | 27294000 | 27294000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BALBOA ST | 11TH AVE | 61905 | 61905 | 37.77699033 | -122.46936101 | 11TH AVE \ BALBOA ST | BALBOA ST \ 11TH AVE | 1710539427000 | MTA | ALL WAY | 11TH AVE intersection | - | - | - | - | - | - | - | 23032 | 1357257600000 | -122.46936101 | 37.77699033 | - | 1453766400000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1453361880000 | BALBOA ST | - | - | - | - | - | - |
| 5961 | N/A | Point | - | - | - | - | S222411 | 11TH AVE: BALBOA ST | - | F | F | - | F | 27294000 | 27294000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | 11TH AVE | 61907 | 61907 | 37.77699033 | -122.46936101 | 11TH AVE \ BALBOA ST | BALBOA ST \ 11TH AVE | 1710539427000 | MTA | ALL WAY | 11TH AVE intersection | - | BELOW STOP SIGN | - | - | - | - | - | 23033 | -402105600000 | -122.46936101 | 37.77699033 | - | 1453766400000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1453362600000 | BALBOA ST | - | - | - | - | - | - |
| 5962 | N/A | Point | 1 | 1 | 500 - 599 | - | S231622 | 500-599 CHINA BASIN ST | 500-599 CHINA BASIN ST | F | F | - | F | 15025000 | 15025000 | - | - | NORTH SIDE | - | - | - | - | 3RD ST | 03RD ST | 64236 | 64236 | 37.77194756 | -122.39044787 | - | - | 1710539427000 | MTA | SPECIAL EVENT AREA CHECK YOUR METER (SFPARK) | 03RD ST to 04TH ST (500 - 599) | - | 100 FT WEST OF 3RD ST | - | - | - | - | - | 23034 | 1481208360000 | -122.39044787 | 37.77194756 | - | 1481155200000 | - | D6 | - | OTHER GUIDE | GUIDE | G-S(SF).0058 | 18X18 | SUP1 | LIGHT POLE | IS | 1481195280000 | CHINA BASIN ST | 500 - 599 CHINA BASIN ST | 500 - 599 CHINA BASIN ST | 500 CHINA BASIN ST | - | 04TH ST | 04TH ST |
| 5963 | N/A | Point | - | - | - | - | S231648 | CHAIN OF LAKES DR: JOHN F KENN | - | F | F | - | F | 27869000 | 27869000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CHAIN OF LAKES DR | CHAIN OF LAKES DR | 64240 | 64240 | 37.76772648 | -122.50182635 | JOHN F KENNEDY DR \ CHAIN OF LAKES DR | JOHN F KENNEDY DR \ CHAIN OF LAKES DR | 1710539427000 | MTA | ALL WAY | CHAIN OF LAKES DR intersection | - | - | - | - | - | - | - | 23035 | 1490280300000 | -122.50182635 | 37.76772648 | - | 1490227200000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481204520000 | JOHN F KENNEDY DR | - | - | - | - | - | - |
| 5964 | N/A | Point | - | - | - | - | S231650 | JOHN F KENNEDY DR: CHAIN OF LA | - | F | F | - | F | 27869000 | 27869000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CHAIN OF LAKES DR | CHAIN OF LAKES DR | 64241 | 64241 | 37.76772648 | -122.50182635 | JOHN F KENNEDY DR \ CHAIN OF LAKES DR | JOHN F KENNEDY DR \ CHAIN OF LAKES DR | 1710539427000 | MTA | ALL WAY | CHAIN OF LAKES DR intersection | - | - | - | - | - | - | - | 23036 | -32918400000 | -122.50182635 | 37.76772648 | - | 1490227200000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481205000000 | JOHN F KENNEDY DR | - | - | - | - | - | - |
| 5965 | N/A | Point | - | - | - | - | S231651 | JOHN F KENNEDY DR: CHAIN OF LA | - | F | F | - | F | 27869000 | 27869000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CHAIN OF LAKES DR | CHAIN OF LAKES DR | 64242 | 64242 | 37.76772648 | -122.50182635 | JOHN F KENNEDY DR \ CHAIN OF LAKES DR | JOHN F KENNEDY DR \ CHAIN OF LAKES DR | 1710539427000 | MTA | ALL WAY | CHAIN OF LAKES DR intersection | - | 0 / 0 | - | - | - | - | - | 23037 | -32918400000 | -122.50182635 | 37.76772648 | - | 1490227200000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481205180000 | JOHN F KENNEDY DR | - | - | - | - | - | - |
| 5966 | N/A | Point | - | - | - | - | S231654 | JOHN F KENNEDY DR: CONSERVATOR | - | F | F | - | F | 27187000 | 27187000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CONSERVATORY DR | CONSERVATORY DR | 64243 | 64243 | 37.77177649 | -122.46204713 | JOHN F KENNEDY DR \ CONSERVATORY DR | JOHN F KENNEDY DR \ CONSERVATORY DR | 1710539427000 | MTA | ALL WAY | CONSERVATORY DR intersection | - | OF JFK DR. & CONSERVATORY WEST DR. | - | - | - | - | - | 23038 | 1495284360000 | -122.46204713 | 37.77177649 | - | 1495238400000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481207280000 | JOHN F KENNEDY DR | - | - | - | - | - | - |
| 5967 | N/A | Point | - | - | - | - | S231655 | EL CAMINO DEL MAR: SEAL ROCK D | - | F | F | - | F | 28014000 | 28014000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SEAL ROCK DR | EL CAMINO DEL MAR | 64244 | 64244 | 37.78062721 | -122.50987917 | EL CAMINO DEL MAR \ SEAL ROCK DR | SEAL ROCK DR \ EL CAMINO DEL MAR | 1710539427000 | MTA | ALL WAY | EL CAMINO DEL MAR intersection | - | - | - | - | - | - | - | 23039 | 898732800000 | -122.50987917 | 37.78062721 | - | 1490832000000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481212020000 | SEAL ROCK DR | - | - | - | - | - | - |
| 5968 | N/A | Point | - | - | - | - | S231656 | EL CAMINO DEL MAR: SEAL ROCK D | - | F | F | - | F | 28014000 | 28014000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SEAL ROCK DR | EL CAMINO DEL MAR | 64245 | 64245 | 37.78062721 | -122.50987917 | EL CAMINO DEL MAR \ SEAL ROCK DR | SEAL ROCK DR \ EL CAMINO DEL MAR | 1710539427000 | MTA | ALL WAY | EL CAMINO DEL MAR intersection | - | BELOW STOP SIGN | - | - | - | - | - | 23040 | 898732800000 | -122.50987917 | 37.78062721 | - | 1490832000000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481212500000 | SEAL ROCK DR | - | - | - | - | - | - |
| 5969 | N/A | Point | - | - | - | - | S231657 | SEAL ROCK DR: EL CAMINO DEL MA | - | F | F | - | F | 28014000 | 28014000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SEAL ROCK DR | EL CAMINO DEL MAR | 64246 | 64246 | 37.78062721 | -122.50987917 | EL CAMINO DEL MAR \ SEAL ROCK DR | SEAL ROCK DR \ EL CAMINO DEL MAR | 1710539427000 | MTA | ALL WAY | EL CAMINO DEL MAR intersection | - | OF SEAL ROCK DR & EL CAMINO DEL MAR | - | - | - | - | - | 23041 | 1491487800000 | -122.50987917 | 37.78062721 | - | 1491436800000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481212860000 | SEAL ROCK DR | - | - | - | - | - | - |
| 5970 | N/A | Point | - | - | - | - | S237118 | 3RD ST: SHAFTER AVE | - | F | F | - | F | 20500000 | 20500000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | SHAFTER AVE | 03RD ST | 74458 | 74458 | 37.73164355 | -122.39179716 | 3RD ST \ SHAFTER AVE | SHAFTER AVE \ 03RD ST | 1710539427000 | MTA | FG 300 EFX DELINEATOR (Y) | 03RD ST intersection | - | WEST CI | - | - | - | - | - | 23042 | 1500910860000 | -122.39179716 | 37.73164355 | - | 1500854400000 | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1498643280000 | SHAFTER AVE | - | - | - | - | - | - |
| 5971 | N/A | Point | - | - | - | - | S237119 | 3RD ST: SHAFTER AVE | - | F | F | - | F | 20500000 | 20500000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | - | - | - | - | SHAFTER AVE | 03RD ST | 74459 | 74459 | 37.73164355 | -122.39179716 | 3RD ST \ SHAFTER AVE | SHAFTER AVE \ 03RD ST | 1710539427000 | MTA | FG 300 EFX DELINEATOR (Y) | 03RD ST intersection | - | EAST CI NORTH OF CROSSWALK | - | - | - | - | - | 23043 | 1500905100000 | -122.39179716 | 37.73164355 | - | 1500854400000 | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | INTERSTATE BASE | IS | 1498643520000 | SHAFTER AVE | - | - | - | - | - | - |
| 5972 | N/A | Point | - | - | - | - | S237122 | 3RD ST: THOMAS AVE | - | F | F | - | F | 20502000 | 20502000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | 3RD ST | 03RD ST | 74461 | 74461 | 37.73085518 | -122.39207296 | THOMAS AVE \ 3RD ST | THOMAS AVE \ 03RD ST | 1710539427000 | MTA | FG 300 EFX DELINEATOR(Y) SHORT | 03RD ST intersection | - | WEST CI NORTH OF CROSSWALK | - | - | - | - | - | 23044 | 1501941720000 | -122.39207296 | 37.73085518 | - | 1663977600000 | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0015 | 03X30 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1498643940000 | THOMAS AVE | - | - | - | - | - | - |
| 5973 | N/A | Point | - | - | - | - | S237126 | 3RD ST: THOMAS AVE | - | F | F | - | F | 20502000 | 20502000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | 3RD ST | 03RD ST | 74462 | 74462 | 37.73085518 | -122.39207296 | THOMAS AVE \ 3RD ST | THOMAS AVE \ 03RD ST | 1710539427000 | MTA | FG 300 EFX DELINEATOR (Y) | 03RD ST intersection | - | - | - | - | - | - | - | 23045 | 1501942080000 | -122.39207296 | 37.73085518 | - | 1501891200000 | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1498644360000 | THOMAS AVE | - | - | - | - | - | - |
| 5974 | N/A | Point | 1 | 1 | 1 - 63 | - | S236248 | 7-63 ORD ST | 1-63 ORD ST | F | F | - | F | 9967000 | 9967000 | - | - | WEST SIDE | - | - | - | - | ORD CT \ VULCAN STWY | ORD CT \ VULCAN STWY | 74464 | 74464 | 37.763135 | -122.44025314 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | ORD CT \ VULCAN STWY to SATURN ST (1 - 63) | - | @#18 ORD ST. | - | - | - | - | - | 23046 | 1495723080000 | -122.44025314 | 37.763135 | - | 1522800000000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | 2IN IRON POST | IS | 1495526700000 | ORD ST | 1 - 63 ORD ST | 1 - 63 ORD ST | 1 ORD ST | - | SATURN ST | SATURN ST |
| 5975 | N/A | Point | 1 | 1 | 1 - 63 | - | S236249 | 7-63 ORD ST | 1-63 ORD ST | F | F | - | F | 9967000 | 9967000 | - | - | WEST SIDE | - | - | - | - | ORD CT \ VULCAN STWY | ORD CT \ VULCAN STWY | 74465 | 74465 | 37.763135 | -122.44025314 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | ORD CT \ VULCAN STWY to SATURN ST (1 - 63) | - | @#50 ORD ST. | - | - | - | - | - | 23047 | 1495724580000 | -122.44025314 | 37.763135 | - | 1495670400000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | 2IN IRON POST | IS | 1495526940000 | ORD ST | 1 - 63 ORD ST | 1 - 63 ORD ST | 1 ORD ST | - | SATURN ST | SATURN ST |
| 5976 | N/A | Point | 1 | 1 | 700 - 799 | - | S237543 | 700-799 CENTRAL AVE | 700-799 CENTRAL AVE | F | F | - | F | 3866000 | 3866000 | - | - | EAST SIDE | - | - | - | - | FULTON ST | FULTON ST | 74466 | 74466 | 37.77648713 | -122.44487325 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | FULTON ST to MCALLISTER ST (700 - 799) | - | 20FT FROM FULTON/ SEE MAP | - | - | - | - | - | 23048 | 1500422400000 | -122.44487325 | 37.77648713 | - | 1631750400000 | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | INTERSTATE BASE | IS | 1500375240000 | CENTRAL AVE | 700 - 799 CENTRAL AVE | 700 - 799 CENTRAL AVE | 700 CENTRAL AVE | - | MCALLISTER ST | MCALLISTER ST |
| 5977 | N/A | Point | - | - | - | - | S237554 | SCOTT ST: FELL ST | - | T | T | - | F | 26030000 | 26030000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FELL ST | FELL ST | 74467 | 74467 | 37.77427668 | -122.43594033 | SCOTT ST \ FELL ST | SCOTT ST \ FELL ST | 1710539427000 | MTA | DO NOT ENTER | FELL ST intersection | - | - | - | - | - | - | - | 23049 | 1512487440000 | -122.43594033 | 37.77427668 | - | 1512432000000 | - | D5 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | SIGNAL POLE | IS | 1500377460000 | SCOTT ST | - | - | - | - | - | - |
| 5978 | N/A | Point | - | - | - | - | S237555 | SCOTT ST: FELL ST | - | T | T | - | F | 26030000 | 26030000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FELL ST | FELL ST | 74468 | 74468 | 37.77427668 | -122.43594033 | SCOTT ST \ FELL ST | SCOTT ST \ FELL ST | 1710539427000 | MTA | EXCEPT BIKE (SYM) | FELL ST intersection | - | - | - | - | - | - | - | 23050 | 1512487560000 | -122.43594033 | 37.77427668 | - | 1512432000000 | - | D5 | - | OTHER REGULATORY | REG | R(SF).0362 | 24X18 | SUP1 | SIGNAL POLE | IS | 1500377640000 | SCOTT ST | - | - | - | - | - | - |
| 5979 | N/A | Point | - | - | - | - | S237558 | SCOTT ST: FELL ST | - | F | F | - | F | 26030000 | 26030000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FELL ST | FELL ST | 74469 | 74469 | 37.77427668 | -122.43594033 | SCOTT ST \ FELL ST | SCOTT ST \ FELL ST | 1710539427000 | MTA | DO NOT ENTER | FELL ST intersection | - | INSTALL ON NEW TRAFFIC DIVERTER | - | - | - | - | - | 23051 | 1512487560000 | -122.43594033 | 37.77427668 | - | 1627430400000 | - | D5 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1500382440000 | SCOTT ST | - | - | - | - | - | - |
| 5980 | N/A | Point | - | - | - | - | S240825 | 3RD ST: HOLLISTER AVE | - | F | F | - | F | 20471000 | 20471000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | - | - | - | - | HOLLISTER AVE | 03RD ST | 74841 | 74841 | 37.72171588 | -122.39594383 | 3RD ST \ HOLLISTER AVE | HOLLISTER AVE \ 03RD ST | 1746134570000 | middleware_editor | FG 300 EFX DELINEATOR (Y) | 03RD ST intersection | - | NORTH OF CROSSWALK (SEE MAP) | - | - | - | - | - | 23052 | 1512514500000 | -122.39594383 | 37.72171588 | - | - | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | RETD | 1511340300000 | HOLLISTER AVE | - | - | - | - | - | - |
| 5981 | N/A | Point | - | - | - | - | S240826 | 3RD ST: HOLLISTER AVE | - | F | F | - | F | 20471000 | 20471000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | - | - | - | - | HOLLISTER AVE | 03RD ST | 74842 | 74842 | 37.72171588 | -122.39594383 | 3RD ST \ HOLLISTER AVE | HOLLISTER AVE \ 03RD ST | 1731016116000 | middleware_editor | FG 300 EFX DELINEATOR (Y) | 03RD ST intersection | - | SOUTH OF CROSSWALK | - | - | - | - | - | 23053 | 1512485820000 | -122.39594383 | 37.72171588 | - | 1512432000000 | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | INTERSTATE BASE | IS | 1511340540000 | HOLLISTER AVE | - | - | - | - | - | - |
| 5982 | N/A | Point | - | - | - | - | S240827 | 3RD ST: HOLLISTER AVE | - | F | F | - | F | 20471000 | 20471000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | - | - | - | - | HOLLISTER AVE | 03RD ST | 74843 | 74843 | 37.72171588 | -122.39594383 | 3RD ST \ HOLLISTER AVE | HOLLISTER AVE \ 03RD ST | 1746134573000 | middleware_editor | FG 300 EFX DELINEATOR (Y) | 03RD ST intersection | - | SOUTH OF CROSSWALK (SEE MAP) | - | - | - | - | - | 23054 | - | -122.39594383 | 37.72171588 | - | - | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | RETD | 1511340780000 | HOLLISTER AVE | - | - | - | - | - | - |
| 5983 | N/A | Point | - | - | - | - | S242467 | EDDY ST: TAYLOR ST | - | F | F | - | F | 24925000 | 24925000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TAYLOR ST | EDDY ST | 74845 | 74845 | 37.78414101 | -122.41095162 | EDDY ST \ TAYLOR ST | TAYLOR ST \ EDDY ST | 1710539427000 | MTA | ONE WAY (RA) | EDDY ST intersection | - | - | - | - | - | - | - | 23055 | 1454457600000 | -122.41095162 | 37.78414101 | - | 1454457600000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | MUNI POLE | IS | 1516707180000 | TAYLOR ST | - | - | - | - | - | - |
| 5984 | N/A | Point | 1 | 1 | 200 - 299 | - | S242468 | 200-299 EDDY ST | 200-299 EDDY ST | F | F | - | F | 5060000 | 5060000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | TAYLOR ST | TAYLOR ST | 74846 | 74846 | 37.7840368 | -122.41177345 | - | - | 1727917530000 | middleware_editor | SCHOOL (SYM)/SCHOOL | TAYLOR ST to JONES ST (200 - 299) | - | 135' E OF JONES | - | - | - | - | - | 23056 | 1517310900000 | -122.41177345 | 37.7840368 | - | 1540166400000 | - | D6 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | LIGHT POLE | IS | 1516709580000 | EDDY ST | 200 - 299 EDDY ST | 200 - 299 EDDY ST | 200 EDDY ST | - | JONES ST | JONES ST |
| 5985 | N/A | Point | - | - | - | - | S242490 | MERCEDES WAY: CERRITOS AVE \ L | - | F | F | - | F | 22782000 | 22782000 | - | - | NORTH EAST CORNER | - | - | - | - | CERRITOS AVE \ MERCEDES WAY | CERRITOS AVE \ LUNADO WAY | 74847 | 74847 | 37.72678774 | -122.471132 | LUNADO WAY \ CERRITOS AVE \ MERCEDES WAY | MERCEDES WAY \ CERRITOS AVE \ LUNADO WAY | 1710539427000 | MTA | STOP | CERRITOS AVE \ LUNADO WAY intersection | - | OF MERCEDES WAY & CERRITOS AVE. | - | - | - | - | - | 23057 | 1516959600000 | -122.471132 | 37.72678774 | - | 1516924800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1516785780000 | MERCEDES WAY | - | - | - | - | - | - |
| 5986 | N/A | Point | 1 | 1 | 500 - 599 | - | S245767 | 500-599 GOUGH ST | 500-599 GOUGH ST | F | F | - | F | 6321000 | 6321000 | - | - | EAST SIDE | - | - | - | - | GROVE ST | GROVE ST | 76133 | 76133 | 37.77828131 | -122.42325979 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM TUE THUR STCL | GROVE ST to FULTON ST (500 - 599) | - | 50FT SOUTH OF FULTON | - | - | - | - | - | 23058 | 1528202640000 | -122.42325979 | 37.77828131 | - | - | - | D5 | - | STREET CLEANING | REG | R30B(CA).0058 | 18X18 | SUP1 | 2IN IRON POST | IS | 1527087480000 | GOUGH ST | 500 - 599 GOUGH ST | 500 - 599 GOUGH ST | 500 GOUGH ST | - | FULTON ST | FULTON ST |
| 5987 | N/A | Point | 1 | 1 | 1900 - 1999 | - | S245768 | 1900-1999 17TH ST | 1900-1999 17TH ST | F | F | - | F | 781000 | 781000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | RHODE ISLAND ST | RHODE ISLAND ST | 76134 | 76134 | 37.76475195 | -122.40304522 | - | - | 1721159717000 | middleware_editor | FG 300 UR DELINEATOR (W) | RHODE ISLAND ST to KANSAS ST (1900 - 1999) | - | START 8FT WEST OF RHODE ISLAND/ 8FT O.C | - | - | - | - | - | 23059 | 1527171780000 | -122.40304522 | 37.76475195 | - | - | 1718007300000 | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | RETD | 1527088140000 | 17TH ST | 1900 - 1999 17TH ST | 1900 - 1999 17TH ST | 1900 17TH ST | - | KANSAS ST | KANSAS ST |
| 5988 | N/A | Point | - | - | - | INBOUND | S240799 | MISSION ST: 2ND ST | - | F | F | - | F | 24597000 | 24597000 | - | - | SOUTH SIDE | - | - | - | - | 2ND ST | 02ND ST | 76136 | 76136 | 37.78800716 | -122.39979802 | MISSION ST \ 2ND ST | MISSION ST \ 02ND ST | 1710539427000 | MTA | BIKE RACK RAPID | 02ND ST intersection | 15530 | WEST END OF BUS STOP PAINT MARK | - | - | - | - | - | 23060 | 1518104100000 | -122.39979802 | 37.78800716 | - | 1666224000000 | - | D6 | - | BIKE RACK | REG | R(SF).0353 | 02X36 | SUP1 | BIKE RACK | IS | 1511291820000 | MISSION ST | - | - | - | - | - | - |
| 5989 | N/A | Point | - | - | - | INBOUND | S240800 | MISSION ST: 8TH ST | - | F | F | - | F | 24311000 | 24311000 | - | - | SOUTH SIDE | - | - | - | - | 8TH ST | 08TH ST | 76137 | 76137 | 37.77745742 | -122.41315769 | MISSION ST \ 8TH ST | MISSION ST \ 08TH ST | 1710539427000 | MTA | BIKE RACK RAPID | 08TH ST intersection | 15541 | 16' EAST AT PAINT MARK | - | - | - | - | - | 23061 | 1518507120000 | -122.41315769 | 37.77745742 | - | 1518480000000 | 1635897600000 | D6 | - | BIKE RACK | REG | R(SF).0353 | 02X36 | SUP1 | BIKE RACK | RETD | 1511291820000 | MISSION ST | - | - | - | - | - | - |
| 5990 | N/A | Point | 1 | 1 | 200 - 237 | - | S242272 | 200-237 11TH ST | 200-237 11TH ST | F | F | - | F | 512000 | 512000 | - | - | WEST SIDE | - | - | - | - | HOWARD ST | HOWARD ST | 76192 | 76192 | 37.77287503 | -122.41528152 | - | - | 1710539427000 | MTA | BIKE RACK | HOWARD ST to KISSLING ST (200 - 237) | 05050 | 74FT NORTH OF SPL#298 (3FT FROM CRUB) | - | - | - | - | - | 23062 | 1516113900000 | -122.41528152 | 37.77287503 | - | 1516060800000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1515766740000 | 11TH ST | 200 - 237 11TH ST | 200 - 237 11TH ST | 200 11TH ST | - | KISSLING ST | KISSLING ST |
| 5991 | N/A | Point | - | - | - | - | S245597 | MIGUEL ST: LAIDLEY ST | - | F | F | - | F | 21872000 | 21872000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LAIDLEY ST | LAIDLEY ST | 76194 | 76194 | 37.73774434 | -122.42825612 | MIGUEL ST \ LAIDLEY ST | MIGUEL ST \ LAIDLEY ST | 1734456931000 | middleware_editor | VEH OVER 3 TONS PROHIBITED | LAIDLEY ST intersection | - | - | - | - | - | - | - | 23063 | 1528192800000 | -122.42825612 | 37.73774434 | - | - | - | D8 | - | OTHER REGULATORY | REG | R36(CA).0012 | 24X24 | SUP2 | 2IN IRON POST | IS | 1526545620000 | MIGUEL ST | - | - | - | - | - | - |
| 5992 | N/A | Point | - | - | - | - | S246343 | WASHINGTON ST: DIVISADERO ST | - | F | F | - | F | 26851000 | 26851000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DIVISADERO ST | WASHINGTON ST | 76195 | 76195 | 37.79075546 | -122.44098438 | WASHINGTON ST \ DIVISADERO ST | DIVISADERO ST \ WASHINGTON ST | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | WASHINGTON ST intersection | - | - | - | - | - | - | - | 23064 | 1529575260000 | -122.44098438 | 37.79075546 | - | - | - | D2 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP1 | 2IN IRON POST | IS | 1528883340000 | DIVISADERO ST | - | - | - | - | - | - |
| 5993 | N/A | Point | - | - | - | - | S246477 | LOMA VISTA TER: ROOSEVELT WAY | - | T | T | - | F | 26207000 | 26207000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LOMA VISTA TER | ROOSEVELT WAY | 76197 | 76197 | 37.76455755 | -122.44321528 | ROOSEVELT WAY \ LOMA VISTA TER | LOMA VISTA TER \ ROOSEVELT WAY | 1731081260000 | middleware_editor | SPEED LIMIT 15 | ROOSEVELT WAY intersection | - | OF LOMA VISTA TER & ROOSEVELT WAY | - | - | - | - | - | 23065 | 1531320300000 | -122.44321528 | 37.76455755 | - | - | - | D8 | - | SPEED LIMIT | REG | R2-1.0003 | 24X30 | SUP2 | LIGHT POLE | IS | 1529509260000 | LOMA VISTA TER | - | - | - | - | - | - |
| 5994 | N/A | Point | - | - | - | - | S240568 | COLLEGE AVE: SAINT MARYS AVE | - | F | F | - | F | 21854000 | 21854000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SAINT MARYS AVE | COLLEGE AVE | 76198 | 76198 | 37.7346939 | -122.4278388 | COLLEGE AVE \ SAINT MARYS AVE | SAINT MARYS AVE \ COLLEGE AVE | 1710539427000 | MTA | ALL WAY | COLLEGE AVE intersection | - | - | - | - | - | - | - | 23066 | 1287014400000 | -122.4278388 | 37.7346939 | - | - | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1510814700000 | SAINT MARYS AVE | - | - | - | - | - | - |
| 5995 | N/A | Point | - | - | - | - | S241599 | INGALLS ST: BEATRICE LN | - | F | F | - | F | 20081000 | 20081000 | - | - | SOUTH WEST CORNER | - | - | - | - | INGALLS ST | BEATRICE LN | 76201 | 76201 | 37.73071901 | -122.37990119 | BEATRICE LN \ INGALLS ST | INGALLS ST \ BEATRICE LN | 1710539427000 | MTA | BEATRICE LN | BEATRICE LN intersection | - | 000 II --> | - | - | - | - | - | 23067 | - | -122.37990119 | 37.73071901 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.0185 | 36X08 | SUP1 | LIGHT POLE | IS | 1513328160000 | INGALLS ST | - | - | - | - | - | - |
| 5996 | N/A | Point | - | - | - | - | S241608 | INGALLS ST: HUDSON AVE | - | F | F | - | F | 20085000 | 20085000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | INGALLS ST | INGALLS ST | 76202 | 76202 | 37.73246457 | -122.37959606 | HUDSON AVE \ INGALLS ST | HUDSON AVE \ INGALLS ST | 1714611706000 | middleware_editor | PEDESTRIAN (SYM) | INGALLS ST intersection | - | - | - | - | - | - | - | 23068 | 1513853460000 | -122.37959606 | 37.73246457 | - | 1513814400000 | - | D10 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1513331580000 | HUDSON AVE | - | - | - | - | - | - |
| 5997 | N/A | Point | - | - | - | - | S241609 | INGALLS ST: HUDSON AVE | - | F | F | - | F | 20085000 | 20085000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | INGALLS ST | INGALLS ST | 76203 | 76203 | 37.73246457 | -122.37959606 | HUDSON AVE \ INGALLS ST | HUDSON AVE \ INGALLS ST | 1714611746000 | middleware_editor | (45 LA-DN) | INGALLS ST intersection | - | - | - | - | - | - | - | 23069 | 1513853880000 | -122.37959606 | 37.73246457 | - | 1513814400000 | - | D10 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP1 | 2IN IRON POST | IS | 1513331700000 | HUDSON AVE | - | - | - | - | - | - |
| 5998 | N/A | Point | - | - | - | - | S221618 | OCTAVIA ST: GROVE ST | - | F | F | - | F | 25928000 | 25928000 | - | - | NORTH EAST CORNER | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 77157 | 77157 | 37.77760186 | -122.42480888 | GROVE ST \ OCTAVIA ST | GROVE ST \ OCTAVIA ST | 1710539427000 | MTA | NPRK 12NN-2PM FRI STCL | OCTAVIA ST intersection | - | - | - | - | - | - | - | 23070 | - | -122.42480888 | 37.77760186 | - | - | - | D5 | - | STREET CLEANING | REG | R30B(CA).0076 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1451374140000 | GROVE ST | - | - | - | - | - | - |
| 5999 | N/A | Point | 1 | 1 | 600 - 699 | - | S221975 | 600-699 HAIGHT ST | 600-699 HAIGHT ST | F | F | - | F | 6609000 | 6609000 | - | - | SOUTH SIDE | - | - | - | - | STEINER ST | STEINER ST | 77158 | 77158 | 37.77179277 | -122.43291354 | - | - | 1710539427000 | MTA | BIKE RACK | STEINER ST to PIERCE ST (600 - 699) | - | IFO 629 | - | - | - | - | - | 23071 | - | -122.43291354 | 37.77179277 | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1452268080000 | HAIGHT ST | 600 - 699 HAIGHT ST | 600 - 699 HAIGHT ST | 600 HAIGHT ST | - | PIERCE ST | PIERCE ST |
| 6000 | N/A | Point | - | 1 | 1 - 99 | - | S221681 | 1-99 SPOFFORD LN | 1-99 SPOFFORD ST | F | F | - | F | 12050000 | 12050000 | - | - | EAST SIDE | - | - | - | - | CLAY ST | CLAY ST | 77159 | 77159 | 37.79457689 | -122.4073896 | - | - | 1710539427000 | MTA | SPOFFORD LN | CLAY ST to OLD CHINATOWN LN \ WASHINGTON ST (1 - 99) | - | 3' NORTH OF CLAY II<-- 000 | - | - | - | - | - | 23072 | 1515679200000 | -122.4073896 | 37.79457689 | - | 1515628800000 | - | D3 | - | STREET NAME | GUIDE | D3-1.1654 | 36X08 | SUP1 | LIGHT POLE | IS | 1451465880000 | SPOFFORD ST | 1 - 99 SPOFFORD ST | 1 - 99 SPOFFORD ST | 1 SPOFFORD ST | - | OLD CHINATOWN LN \ WASHINGTON ST | OLD CHINATOWN LN \ WASHINGTON 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