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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79951 | N/A | Point | 1 | 1 | 100 - 199 | - | S217631 | 100-199 GRANVILLE WAY | 100-199 GRANVILLE WAY | F | F | - | F | 6421000 | 6421000 | - | - | NORTH SIDE | - | - | - | - | ULLOA ST | ULLOA ST | 128244 | 128244 | 37.74171376 | -122.46156891 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "O" PERMITS | ULLOA ST to PUBLIC PARK (100 - 199) | - | IFO#280 | - | - | - | - | - | 97071 | 1224201600000 | -122.46156891 | 37.74171376 | - | - | - | D7 | - | PARKING:RPP | REG | R32C(CA).0097 | 18X21 | SUP2 | 2IN IRON POST | IS | 1436179800000 | GRANVILLE WAY | 100 - 199 GRANVILLE WAY | 100 - 199 GRANVILLE WAY | 100 GRANVILLE WAY | - | PUBLIC PARK | PUBLIC PARK |
| 79952 | N/A | Point | 1 | 1 | 1 - 99 | - | S244722 | 1-99 BRIGHTON AVE | 1-99 BRIGHTON AVE | F | F | - | F | 3132000 | 3132000 | - | - | EAST SIDE | - | - | - | - | LAKEVIEW AVE | LAKEVIEW AVE | 128245 | 128245 | 37.71913636 | -122.45511486 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 1ST & 3RD THUR OF MONTH STCL | LAKEVIEW AVE to GRAFTON AVE (1 - 99) | - | SPL# 54 | - | - | - | - | - | 97072 | 1223424000000 | -122.45511486 | 37.71913636 | - | 1584057600000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0249 | 18X18 | SUP2 | 2IN IRON POST | IS | 1523951760000 | BRIGHTON AVE | 1 - 99 BRIGHTON AVE | 1 - 99 BRIGHTON AVE | 1 BRIGHTON AVE | - | GRAFTON AVE | GRAFTON AVE |
| 79953 | N/A | Point | - | 1 | 400 - 499 | LEFT ARROW | S249980 | 400-499 TOWNSEND ST | 400-499 TOWNSEND ST | F | F | - | F | 12664000 | 12664000 | - | - | NORTH SIDE | - | - | - | - | 5TH ST | 05TH ST | 128247 | 128247 | 37.77445286 | -122.39831972 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | 05TH ST to 06TH ST (400 - 499) | - | 60'FT EAST OF WPL 460/ METER | - | - | - | - | - | 97073 | 1400544000000 | -122.39831972 | 37.77445286 | - | 1544659200000 | - | D6 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP1 | 2IN IRON POST | IS | 1543917480000 | TOWNSEND ST | 400 - 499 TOWNSEND ST | 400 - 499 TOWNSEND ST | 400 TOWNSEND ST | - | 06TH ST | 06TH ST |
| 79954 | N/A | Point | 1 | 1 | 1 - 99 | - | S249557 | 1-99 GRACE ST | 1-99 GRACE ST | F | F | - | F | 6354000 | 6354000 | - | - | EAST SIDE | - | - | - | - | MISSION ST | MISSION ST | 128248 | 128248 | 37.77499269 | -122.41471426 | - | - | 1751915360000 | middleware_editor | 1 HR PRK 8AM-10PM EVRYDAY EXC "U" PERMITS | MISSION ST to HOWARD ST (1 - 99) | - | NPL 63 GRACE | - | - | - | - | - | 97074 | 1542305280000 | -122.41471426 | 37.77499269 | - | - | - | D6 | - | PARKING:RPP | REG | R32C(CA).0004 | 18X21 | SUP1 | 2IN IRON POST | IS | 1541761680000 | GRACE ST | 1 - 99 GRACE ST | 1 - 99 GRACE ST | 1 GRACE ST | - | HOWARD ST | HOWARD ST |
| 79955 | N/A | Point | - | - | - | - | S130888 | ADDISON ST: DIGBY ST | - | F | F | - | F | 21962000 | 21962000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ADDISON ST | DIGBY ST | 129066 | 129066 | 37.74008092 | -122.43371065 | DIGBY ST \ ADDISON ST | ADDISON ST \ DIGBY ST | 1710539427000 | MTA | STOP | DIGBY ST intersection | - | - | - | - | - | - | - | 97075 | 1244505600000 | -122.43371065 | 37.74008092 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373577180000 | ADDISON ST | - | - | - | - | - | - |
| 79956 | N/A | Point | - | - | - | - | S132084 | 2ND AVE: HUGO ST | - | F | F | - | F | 27070000 | 27070000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 2ND AVE | 02ND AVE | 129067 | 129067 | 37.76530432 | -122.45888053 | HUGO ST \ 2ND AVE | HUGO ST \ 02ND AVE | 1710539427000 | MTA | STOP | 02ND AVE intersection | - | - | - | - | - | - | - | 97076 | 1267660800000 | -122.45888053 | 37.76530432 | - | - | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373577600000 | HUGO ST | - | - | - | - | - | - |
| 79957 | N/A | Point | 1 | 1 | 700 - 799 | - | S130325 | 700-799 3RD AVE | 700-799 03RD AVE | F | F | - | F | 158000 | 158000 | - | - | EAST SIDE | - | - | - | - | CABRILLO ST | CABRILLO ST | 129068 | 129068 | 37.77477404 | -122.46060671 | - | - | 1738681325000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "L" PERMITS | CABRILLO ST to FULTON ST (700 - 799) | - | IFO #700 ES | - | - | - | - | - | 97077 | 1236038400000 | -122.46060671 | 37.77477404 | - | - | - | D1 | - | PARKING:RPP | REG | R32C(CA).0095 | 18X21 | SUP2 | 2 POST ALUMINUM | IS | 1373577060000 | 03RD AVE | 700 - 799 3RD AVE | 700 - 799 03RD AVE | 700 3RD AVE | - | FULTON ST | FULTON ST |
| 79958 | N/A | Point | - | - | - | - | S132619 | ULLOA ST: KENSINGTON WAY | - | F | F | - | F | 22847000 | 22847000 | - | - | NORTH WEST CORNER | - | - | - | - | ULLOA ST | ULLOA ST | 129069 | 129069 | 37.74106112 | -122.45983995 | KENSINGTON WAY \ ULLOA ST | KENSINGTON WAY \ ULLOA ST | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "O" PERMITS | ULLOA ST intersection | - | ABOVE R10(RA) | - | - | - | - | - | 97078 | 1280102400000 | -122.45983995 | 37.74106112 | - | - | - | D7 | - | PARKING:RPP | REG | R32C(CA).0097 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373577720000 | KENSINGTON WAY | - | - | - | - | - | - |
| 79959 | N/A | Point | - | - | - | - | S132138 | BAY ST: LEAVENWORTH ST | - | T | T | - | F | 25536000 | 25536000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BAY ST | BAY ST | 129070 | 129070 | 37.80499904 | -122.41853063 | LEAVENWORTH ST \ BAY ST | LEAVENWORTH ST \ BAY ST | 1712155033000 | middleware_editor | NO TRUCKS (SYM) OVER 3 TONS | BAY ST intersection | - | 0 / BELOW "NO LEFT TURN(SYM)SIGN (B..... | - | - | - | - | - | 97079 | 1268784000000 | -122.41853063 | 37.80499904 | - | 1682899200000 | - | D2 | - | OTHER REGULATORY | REG | R5-2.0005 | 30X30 | SUP1 | LIGHT POLE | IS | 1373577600000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 79960 | N/A | Point | - | - | - | - | S283622 | THORNTON AVE: POMONA ST | - | F | F | - | F | 20527000 | 20527000 | - | - | NORTH WEST CORNER | - | - | - | - | THORNTON AVE | THORNTON AVE | 129071 | 129071 | 37.73085416 | -122.39364556 | POMONA ST \ THORNTON AVE | POMONA ST \ THORNTON AVE | 1754401745000 | middleware_editor | STOP | THORNTON AVE intersection | - | - | - | - | - | - | - | 97080 | - | -122.39364556 | 37.73085416 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1655903040000 | POMONA ST | - | - | - | - | - | - |
| 79961 | N/A | Point | - | - | - | - | S282401 | NORIEGA ST: 20TH AVE | - | F | F | - | F | 27336000 | 27336000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 20TH AVE | 20TH AVE | 129072 | 129072 | 37.75419271 | -122.4775485 | NORIEGA ST \ 20TH AVE | NORIEGA ST \ 20TH AVE | 1749678097000 | middleware_editor | SPEED LIMIT 20 | 20TH AVE intersection | - | ABOVE STOP SIGN | - | - | - | - | - | 97081 | 1653462000000 | -122.4775485 | 37.75419271 | - | - | - | D4 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | 2IN IRON POST | IS | 1650547200000 | NORIEGA ST | - | - | - | - | - | - |
| 79962 | N/A | Point | - | - | - | - | S270725 | MAIN ST: FOLSOM ST | - | T | T | - | F | 24503000 | 24503000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MAIN ST | FOLSOM ST | 129074 | 129074 | 37.78936927 | -122.39185829 | FOLSOM ST \ MAIN ST | MAIN ST \ FOLSOM ST | 1710539427000 | MTA | FOLSOM ST | FOLSOM ST intersection | - | - | - | - | - | - | - | 97082 | - | -122.39185829 | 37.78936927 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-2.0156 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1607514180000 | MAIN ST | - | - | - | - | - | - |
| 79963 | N/A | Point | - | - | - | - | S104297 | LANE ST: SHAFTER AVE | - | F | F | - | F | 20501000 | 20501000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SHAFTER AVE | SHAFTER AVE | 129075 | 129075 | 37.73103715 | -122.39072708 | LANE ST \ SHAFTER AVE | LANE ST \ SHAFTER AVE | 1710539427000 | MTA | STOP | SHAFTER AVE intersection | - | 0 / 00 | - | - | - | - | - | 97083 | -24710400000 | -122.39072708 | 37.73103715 | - | 1046649600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568900000 | LANE ST | - | - | - | - | - | - |
| 79964 | N/A | Point | - | - | - | - | S103935 | WASHINGTON ST: POWELL ST | - | F | F | - | F | 25048000 | 25048000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | POWELL ST | WASHINGTON ST | 129076 | 129076 | 37.79473683 | -122.40972158 | WASHINGTON ST \ POWELL ST | POWELL ST \ WASHINGTON ST | 1715823400000 | middleware_editor | DO NOT ENTER | WASHINGTON ST intersection | - | 0 / MADE WASHINGTON 1-WAY EB | - | - | - | - | - | 97084 | -70243200000 | -122.40972158 | 37.79473683 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1.0002 | 24X24 | SUP1 | UNKNOWN | IS | 1373568780000 | POWELL ST | - | - | - | - | - | - |
| 79965 | N/A | Point | - | - | - | - | S104552 | 29TH AVE: IRVING ST | - | F | F | - | F | 27438000 | 27438000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 29TH AVE | 29TH AVE | 129078 | 129078 | 37.76308977 | -122.48783871 | IRVING ST \ 29TH AVE | IRVING ST \ 29TH AVE | 1737581333000 | middleware_editor | STOP | 29TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 97085 | 9248400000 | -122.48783871 | 37.76308977 | - | 1465948800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1373568960000 | IRVING ST | - | - | - | - | - | - |
| 79966 | N/A | Point | - | - | - | - | S104848 | EUCALYPTUS DR: MIDDLEFIELD DR | - | F | F | - | F | 23134000 | 23134000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MIDDLEFIELD DR | EUCALYPTUS DR | 129079 | 129079 | 37.73087918 | -122.48617933 | EUCALYPTUS DR \ MIDDLEFIELD DR | MIDDLEFIELD DR \ EUCALYPTUS DR | 1751058699000 | middleware_editor | STOP | EUCALYPTUS DR intersection | - | 0 / 0 | - | - | - | - | - | 97086 | 32688000000 | -122.48617933 | 37.73087918 | - | 1750958400000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569020000 | MIDDLEFIELD DR | - | - | - | - | - | - |
| 79967 | N/A | Point | - | - | - | - | S104053 | 18TH AVE: IRVING ST | - | F | F | - | F | 27371000 | 27371000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 18TH AVE | 18TH AVE | 129081 | 129081 | 37.76371478 | -122.476121435 | IRVING ST \ 18TH AVE | IRVING ST \ 18TH AVE | 1710539427000 | MTA | STOP | 18TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 97087 | -57369600000 | -122.47605438 | 37.76360876 | - | 1516320000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568780000 | IRVING ST | - | - | - | - | - | - |
| 79968 | N/A | Point | 1 | 1 | 500 - 599 | - | S233391 | 500-599 LARKIN ST | 500-599 LARKIN ST | F | F | - | F | 8125000 | 8125000 | - | - | EAST SIDE | - | - | - | - | TURK ST | TURK ST | 129092 | 129092 | 37.782588417 | -122.41731179 | - | - | 1710539427000 | MTA | BIKE RACK | TURK ST to EDDY ST (500 - 599) | 20154710 | NPL #510 | - | - | - | - | - | 97088 | 1486554480000 | -122.41743383 | 37.78284492 | - | 1486512000000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1486478880000 | LARKIN ST | 500 - 599 LARKIN ST | 500 - 599 LARKIN ST | 500 LARKIN ST | - | EDDY ST | EDDY ST |
| 79969 | N/A | Point | - | - | - | - | S210804 | 100-149 BERNAL HEIGHTS BLVD | - | F | F | - | F | 2942002 | 2942000 | - | - | SOUTH SIDE | - | - | - | - | ANDERSON ST | - | 129099 | 129099 | 37.74215284 | -122.41533157 | - | - | 1710539427000 | MTA | TANS 10PM-6AM EVERYDAY | - | - | 175 ' WEST OF ANDERSON ST. | - | - | - | - | - | 97089 | - | -122.41533157 | 37.74215284 | - | 1707955200000 | - | D9 | - | OTHER REGULATORY | REG | R37(CA).0002 | 18X21 | SUP2 | LIGHT POLE | IS | 1415886540000 | BERNAL HEIGHTS BLVD | 0 - 0 BERNAL HEIGHTS BLVD | BERNAL HEIGHTS BLVD | - | - | MOULTRIE ST | - |
| 79970 | N/A | Point | - | 1 | 1800 - 1890 | - | S272280 | 3200-3259 ILLINOIS ST | 1800-1890 ILLINOIS ST | F | F | - | F | 7177000 | 7177000 | - | - | WEST SIDE | - | - | - | - | MARIN ST | MARIN ST | 129741 | 129741 | 37.74855337 | -122.3863785 | - | - | 1710539427000 | MTA | BIKE WAYFINDING SIGN | MARIN ST to ILLINOIS ST (1800 - 1890) | 1068 | 100' NORTH OF CARGO | - | - | - | - | - | 97090 | 1205193600000 | -122.3863785 | 37.74855337 | - | 1612915200000 | - | D10 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | LIGHT POLE | IS | 1612855380000 | ILLINOIS ST | 1800 - 1890 ILLINOIS ST | 1800 - 1890 ILLINOIS ST | 1800 ILLINOIS ST | - | ILLINOIS ST | ILLINOIS ST |
| 79971 | N/A | Point | 1 | 1 | 1600 - 1660 | - | S272451 | 1600-1660 HAIGHT ST | 1600-1660 HAIGHT ST | F | F | - | F | 6620000 | 6620000 | - | - | SOUTH SIDE | - | - | - | - | CLAYTON ST | CLAYTON ST | 129742 | 129742 | 37.76972986 | -122.44911199 | - | - | 1710539427000 | MTA | BIKE RACK | CLAYTON ST to BELVEDERE ST (1600 - 1660) | 241357 | 30' E OF EPL 1621/ 3' IN FROM CURB | - | - | - | - | - | 97091 | 1613572680000 | -122.44911199 | 37.76972986 | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1613482260000 | HAIGHT ST | 1600 - 1660 HAIGHT ST | 1600 - 1660 HAIGHT ST | 1600 HAIGHT ST | - | BELVEDERE ST | BELVEDERE ST |
| 79972 | N/A | Point | 1 | 1 | 1100 - 1165 | - | S282742 | 1100-1165 MISSION ST | 1100-1165 MISSION ST | F | F | - | F | 9101000 | 9101000 | - | - | SOUTH SIDE | - | - | - | - | 7TH ST | 07TH ST | 129743 | 129743 | 37.77862851 | -122.41167496 | - | - | 1710539427000 | MTA | TANSAT | 07TH ST to ANGELOS ALY \ JULIA ST (1100 - 1165) | - | 175' EAST OF JULIA ST | - | - | - | - | - | 97092 | 1652313600000 | -122.41167496 | 37.77862851 | - | - | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1652186940000 | MISSION ST | 1100 - 1165 MISSION ST | 1100 - 1165 MISSION ST | 1100 MISSION ST | - | ANGELOS ALY \ JULIA ST | ANGELOS ALY \ JULIA ST |
| 79973 | N/A | Point | - | - | - | - | S126172 | CALIFORNIA ST: 14TH AVE | - | F | F | - | F | 27621000 | 27621000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 129750 | 129750 | 37.78442147 | -122.47311981 | 14TH AVE \ CALIFORNIA ST | 14TH AVE \ CALIFORNIA ST | 1747345968000 | middleware_editor | LANE REDUCTION (SYM) RIGHT | CALIFORNIA ST intersection | - | 0 / INSTALL LANE REDUCTION RIGHT(SY..... | - | - | - | - | - | 97093 | 1164873600000 | -122.47311981 | 37.78442147 | - | - | 1747345920000 | D1 | - | OTHER WARNING | WARNING | W4-2.0003 | 30X30 | SUP2 | LIGHT POLE | RETD | 1373575740000 | 14TH AVE | - | - | - | - | - | - |
| 79974 | N/A | Point | - | - | - | - | S129306 | FRANKLIN ST: GREEN ST | - | F | T | - | F | 26554000 | 26554000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | GREEN ST | 129751 | 129751 | 37.7974649863796 | -122.425561940794 | GREEN ST \ FRANKLIN ST | FRANKLIN ST \ GREEN ST | 1749850243000 | middleware_editor | SCHOOL (SYM)/SCHOOL | GREEN ST intersection | - | - | - | - | - | - | - | 97094 | 1214377200000 | -122.42543687 | 37.79740835 | - | 1749850200000 | - | D2 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | SIGNAL POLE | IS | 1373576700000 | FRANKLIN ST | - | - | - | - | - | - |
| 79975 | N/A | Point | - | - | - | - | S128184 | WINSTON DR: STONECREST DR | - | F | F | - | F | 23067000 | 23067000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | WINSTON DR | WINSTON DR | 129752 | 129752 | 37.72688809 | -122.47423317 | STONECREST DR \ WINSTON DR | STONECREST DR \ WINSTON DR | 1729723778000 | middleware_editor | PEDESTRIAN (SYM) | WINSTON DR intersection | - | - | - | - | - | - | - | 97095 | 1196208000000 | -122.47423317 | 37.72688809 | - | 1632873600000 | - | D7 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373576340000 | STONECREST DR | - | - | - | - | - | - |
| 79976 | N/A | Point | - | - | - | - | S131494 | HANOVER ST: GUTTENBERG ST | - | F | F | - | F | 21461000 | 21461000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HANOVER ST | HANOVER ST | 129753 | 129753 | 37.709370122 | -122.442781343 | GUTTENBERG ST \ HANOVER ST | GUTTENBERG ST \ HANOVER ST | 1710539427000 | MTA | ALL WAY | HANOVER ST intersection | - | - | - | - | - | - | - | 97096 | 1251763200000 | -122.44266869 | 37.70932061 | - | 1522627200000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | UTILITY POLE | IS | 1373577420000 | GUTTENBERG ST | - | - | - | - | - | - |
| 79977 | N/A | Point | - | - | - | - | S125581 | WALNUT ST: JACKSON ST | - | F | F | - | F | - | 26955000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | - | WALNUT ST | 129754 | 129754 | 37.79060811 | -122.44918958 | - | JACKSON ST \ WALNUT ST | 1710539427000 | MTA | ALL WAY | WALNUT ST intersection | - | - | - | - | - | - | - | 97097 | 1158192000000 | -122.44918958 | 37.79060811 | - | 1541030400000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1373575560000 | JACKSON ST | - | - | - | - | - | - |
| 79978 | N/A | Point | - | - | - | - | S129379 | BRAZIL AVE: LISBON ST | - | F | F | - | F | 21716000 | 21716000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | BRAZIL AVE | 129756 | 129756 | 37.723544062 | -122.432551865 | LISBON ST \ BRAZIL AVE | LISBON ST \ BRAZIL AVE | 1710539427000 | MTA | ALL WAY | BRAZIL AVE intersection | - | - | - | - | - | - | - | 97098 | 1215648000000 | -122.43243206 | 37.72354972 | - | 1543363200000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576760000 | LISBON ST | - | - | - | - | - | - |
| 79979 | N/A | Point | - | - | - | - | S127280 | BACON ST: HOLYOKE ST | - | F | F | - | F | 20890000 | 20890000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BACON ST | BACON ST | 129759 | 129759 | 37.726272583 | -122.408621907 | HOLYOKE ST \ BACON ST | HOLYOKE ST \ BACON ST | 1710539427000 | MTA | SCHOOL (SYM) | BACON ST intersection | - | AT PAINT MARK | - | - | - | - | - | 97099 | 1175126400000 | -122.40854164 | 37.72634147 | - | - | - | D9 | - | SCHOOL | WARNING | S1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373576100000 | HOLYOKE ST | - | - | - | - | - | - |
| 79980 | N/A | Point | - | - | - | - | S127307 | FRANKLIN ST: LOMBARD ST | - | F | F | - | F | 26699000 | 26699000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 129762 | 129762 | 37.80109546 | -122.42618004 | LOMBARD ST \ FRANKLIN ST | LOMBARD ST \ FRANKLIN ST | 1748619339000 | jsanfel | LOMBARD ST | FRANKLIN ST intersection | - | - | - | - | - | - | - | 97100 | 1175670000000 | -122.42618004 | 37.80109546 | - | - | - | D2 | - | STREET NAME | GUIDE | D3-2.0231 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1373576100000 | LOMBARD ST | - | - | - | - | - | - |
| 79981 | N/A | Point | - | - | - | - | S126521 | SAN JOSE AVE: NIAGARA AVE | - | F | F | - | F | 22174000 | 22174000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | NIAGARA AVE | 129763 | 129763 | 37.71948112 | -122.44756206 | NIAGARA AVE \ SAN JOSE AVE | SAN JOSE AVE \ NIAGARA AVE | 1710539427000 | MTA | ALL WAY | NIAGARA AVE intersection | - | - | - | - | - | - | - | 97101 | 1168646400000 | -122.44756206 | 37.71948112 | - | 1553472000000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | MUNI POLE | IS | 1373575860000 | SAN JOSE AVE | - | - | - | - | - | - |
| 79982 | N/A | Point | - | - | - | - | S125642 | MANGELS AVE: COLON AVE | - | F | F | - | F | 22651000 | 22651000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MANGELS AVE | COLON AVE | 129764 | 129764 | 37.73243411 | -122.45688129 | COLON AVE \ MANGELS AVE | MANGELS AVE \ COLON AVE | 1710539427000 | MTA | STOP | COLON AVE intersection | - | - | - | - | - | - | - | 97102 | 1158624000000 | -122.45688129 | 37.73243411 | - | 1527638400000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373575560000 | MANGELS AVE | - | - | - | - | - | - |
| 79983 | N/A | Point | - | - | - | - | S129565 | 26TH ST: HAMPSHIRE ST | - | F | F | - | F | 23948000 | 23948000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HAMPSHIRE ST | HAMPSHIRE ST | 129765 | 129765 | 37.74971663 | -122.40689645 | 26TH ST \ HAMPSHIRE ST | 26TH ST \ HAMPSHIRE ST | 1722561031000 | middleware_editor | ALL WAY | HAMPSHIRE ST intersection | - | - | - | - | - | - | - | 97103 | 1219795200000 | -122.40689645 | 37.74971663 | - | 1533081600000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576820000 | 26TH ST | - | - | - | - | - | - |
| 79984 | N/A | Point | - | - | - | - | S127368 | LOMBARD ST: WEBSTER ST | - | F | F | - | F | 26748000 | 26748000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LOMBARD ST | LOMBARD ST | 129766 | 129766 | 37.80005155 | -122.4344047 | WEBSTER ST \ LOMBARD ST | WEBSTER ST \ LOMBARD ST | 1710539427000 | MTA | WEBSTER ST | LOMBARD ST intersection | - | - | - | - | - | - | - | 97104 | 1176163200000 | -122.4344047 | 37.80005155 | - | - | - | D2 | - | STREET NAME | GUIDE | D3-2.0357 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1373576100000 | WEBSTER ST | - | - | - | - | - | - |
| 79985 | N/A | Point | - | - | - | - | S127419 | SANTIAGO ST: 34TH AVE | - | F | F | - | F | 23394000 | 23394000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SANTIAGO ST | 34TH AVE | 129767 | 129767 | 37.74420961 | -122.49190074 | 34TH AVE \ SANTIAGO ST | SANTIAGO ST \ 34TH AVE | 1738279220000 | middleware_editor | ALL WAY | 34TH AVE intersection | - | - | - | - | - | - | - | 97105 | 1176854400000 | -122.49190074 | 37.74420961 | - | 1738248960000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576100000 | SANTIAGO ST | - | - | - | - | - | - |
| 79986 | N/A | Point | - | - | - | - | S126258 | ORTEGA ST: 41ST AVE | - | F | F | - | F | 27753000 | 27753000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 41ST AVE | ORTEGA ST | 129769 | 129769 | 37.75133377 | -122.49991446 | ORTEGA ST \ 41ST AVE | 41ST AVE \ ORTEGA ST | 1715219610000 | middleware_editor | ALL WAY | ORTEGA ST intersection | - | - | - | - | - | - | - | 97106 | 1165622400000 | -122.49991446 | 37.75133377 | - | 1488153600000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575740000 | 41ST AVE | - | - | - | - | - | - |
| 79987 | N/A | Point | 1 | 1 | 600 - 699 | - | S221653 | 600-699 GRANT AVE | 600-699 GRANT AVE | F | F | - | F | 6392000 | 6392000 | - | - | WEST SIDE | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 129770 | 129770 | 37.79291523 | -122.4060338 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM MON THRU FRI STCL | CALIFORNIA ST to SACRAMENTO ST (600 - 699) | - | IFO #625 | - | - | - | - | - | 97107 | 1623715200000 | -122.4060338 | 37.79291523 | - | 1710153900000 | - | D3 | - | STREET CLEANING | REG | R30B(CA).0120 | 18X18 | SUP1 | LIGHT POLE | IS | 1451386560000 | GRANT AVE | 600 - 699 GRANT AVE | 600 - 699 GRANT AVE | 600 GRANT AVE | - | SACRAMENTO ST | SACRAMENTO ST |
| 79988 | N/A | Point | - | - | - | - | S252740 | - | - | F | F | - | F | 8665000 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | - | - | 131466 | 131466 | 37.72130816 | -122.40153107 | - | - | 1716427680000 | middleware_editor | NPRK 7AM-8AM FRI STCL | - | - | WPL #30 | - | - | - | - | - | 97108 | 1485907200000 | - | - | - | 1485907200000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0209 | 18X18 | SUP1 | 2IN IRON POST | IS | - | - | 1 - 99 MANSELL ST | - | - | - | - | - |
| 79989 | N/A | Point | - | - | - | - | S282140 | - | - | T | T | - | F | 27181000 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | LINCOLN WAY | - | 131467 | 131467 | 37.76614079 | -122.4583683 | 02ND AVE \ LINCOLN WAY | - | 1710539427000 | MTA | PEDESTRIAN (SYM) | - | - | 2' EAST OF 2ND AVE | - | - | - | - | - | 97109 | - | - | - | - | 1649635200000 | - | D5 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | LIGHT POLE | IS | - | - | - | - | - | - | - | - |
| 79990 | N/A | Point | - | - | - | - | S269597 | - | - | F | F | - | F | 8777000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131468 | 131468 | 37.75131317 | -122.44297102 | - | - | 1740415478000 | middleware_editor | SIGNAL AHEAD (SYM) | - | - | 200FT NORTHOF ARGENT ALLEY | - | - | - | - | - | 97110 | 1604998800000 | - | - | - | - | - | D8 | - | OTHER WARNING | WARNING | W3-3.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | - | - | 3891 - 3999 MARKET ST | - | - | - | - | - |
| 79991 | N/A | Point | - | - | - | - | S269604 | - | - | F | F | - | F | 8777000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131469 | 131469 | 37.75131317 | -122.44297102 | - | - | 1740413295000 | middleware_editor | TANSAT | - | - | 200FT NORTH OF ARGENT ALLEY | - | - | - | - | - | 97111 | 1609944000000 | - | - | - | - | - | D8 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | - | - | 3891 - 3999 MARKET ST | - | - | - | - | - |
| 79992 | N/A | Point | - | - | - | - | S286345 | - | - | T | T | - | F | 11009000 | - | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131470 | 131470 | 37.79915064 | -122.44544969 | - | - | 1710539427000 | MTA | LYON ST | - | - | 100'FT N.LINE FRANCISCO ST FACING NBT | - | - | - | - | - | 97112 | - | - | - | - | 1678147200000 | - | D2 | - | STREET NAME | GUIDE | D3-2.0232 | 72X18 | SUP1 | LIGHT POLE | IS | - | - | 1 - 99 RICHARDSON AVE | - | - | - | - | - |
| 79993 | N/A | Point | - | - | - | - | S242328 | - | - | F | F | - | F | 10669000 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 131471 | 131471 | 37.75536319 | -122.40661026 | - | - | 1710539427000 | MTA | BIKE RACK | - | - | IFO# 1028 POTREREO AVE. | - | - | - | - | - | 97113 | 1516708800000 | - | - | - | 1516665600000 | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | - | - | 1000 - 1098 POTRERO AVE | - | - | - | - | - |
| 79994 | N/A | Point | - | - | - | - | S239355 | - | - | F | F | - | F | 2489000 | - | - | - | CENTER ISLAND | 1689201376000 | MTA | - | - | - | - | 131472 | 131472 | 37.7480926 | -122.41925067 | - | - | 1753384991000 | middleware_editor | DELINEATOR (Y) (SAFE HIT) | - | - | (N/S)FROM MISSION ST X-WALK TO 6FT. WEST | - | - | - | - | - | 97114 | 1507749300000 | - | - | - | 1507705200000 | - | D9 | - | DELINEATOR 5 | WARNING | TYPE-DL.0002 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | - | - | 3401 - 3499 CESAR CHAVEZ ST | - | - | - | - | - |
| 79995 | N/A | Point | - | - | - | RIGHT ARROW | S238262 | - | - | F | F | - | F | 12018000 | - | - | - | SOUTH SIDE | 1689201376000 | MTA | - | - | - | - | 131473 | 131473 | 37.77010715 | -122.41762987 | - | - | 1740091811000 | middleware_editor | NPRK ANY TIME | - | - | IFO BIG O TIRES | - | - | - | - | - | 97115 | 1502893020000 | - | - | - | 1527638400000 | - | D6 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0002 | 18X18 | SUP1 | LIGHT POLE | IS | - | - | 193 - 199 SOUTH VAN NESS AVE | - | - | - | - | - |
| 79996 | N/A | Point | - | - | - | - | S277229 | - | - | F | F | - | F | - | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131475 | 131475 | 37.7222464835776 | -122.501573955095 | - | - | 1740438649000 | middleware_editor | GREAT HWY CLOSED WEEKENDS & HOLIDAYS USE SUNSET BLVD (VA) | - | - | 5TH UTILITY POLE NORTH OF JOHN MUIR | - | - | - | - | - | 97116 | 1629849600000 | - | - | - | 1629849600000 | 1740407400000 | D7 | - | OTHER GUIDE | GUIDE | M4-10.0005 | 48X36 | SUP2 | UTILITY POLE | RETD | - | - | 200 - 699 JOHN MUIR DR | - | - | - | - | - |
| 79997 | N/A | Point | - | - | - | RIGHT ARROW | S246491 | - | - | F | F | - | F | 13577000 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 131476 | 131476 | 37.74027225 | -122.46635329 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | - | 80 FT NORTH OF VINCENTE | - | - | - | - | - | 97117 | 1529676000000 | - | - | - | - | - | D7 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | 2IN IRON POST | IS | - | - | 1 - 99 WEST PORTAL AVE | - | - | - | - | - |
| 79998 | N/A | Point | - | - | - | - | S125742 | - | - | F | F | - | F | 21705000 | - | - | - | CENTER ISLAND, N LINE, NORTHBOUND | 1689201376000 | MTA | - | - | ROUSSEAU ST | - | 131477 | 131477 | 37.73078828 | -122.43024162 | ALEMANY BLVD \ ROUSSEAU ST | - | 1734621216000 | middleware_editor | PEDESTRIAN (SYM) | - | - | - | - | - | - | - | - | 97118 | - | - | - | - | - | 1734532380000 | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | LIGHT POLE | RETD | - | - | - | - | - | - | - | - |
| 79999 | N/A | Point | - | - | - | - | S120973 | - | - | F | F | - | F | 13052000 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | - | - | 131478 | 131478 | 37.77204446 | -122.42261221 | - | - | 1710539427000 | MTA | MARKET ST | - | - | <-(1750) | - | - | - | - | - | 97119 | 1115251200000 | - | - | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.1126 | 36X08 | SUP1 | LIGHT POLE | IS | - | - | 1 - 99 VALENCIA ST | - | - | - | - | - |
| 80000 | N/A | Point | - | - | - | - | S123727 | - | - | F | F | - | F | 9273000 | - | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131480 | 131480 | 37.7315392 | -122.43859475 | - | - | 1710539427000 | MTA | STATE LAW YIELD TO PEDS (SYM) | - | - | W-LINE | - | - | - | - | - | 97120 | 1147737600000 | - | - | - | 1442275200000 | - | D7 | - | OTHER REGULATORY | REG | R1-6.0001 | 12X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | - | - | 95 - 199 MONTEREY BLVD | - | - | - | - | - |
| 80001 | N/A | Point | - | - | - | - | S123728 | - | - | F | F | - | F | 9273000 | - | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131481 | 131481 | 37.7315392 | -122.43859475 | - | - | 1710539427000 | MTA | STATE LAW YIELD TO PEDS (SYM) | - | - | E-LINE | - | - | - | - | - | 97121 | 1147737600000 | - | - | - | - | - | D7 | - | OTHER REGULATORY | REG | R1-6.0001 | 12X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | - | - | 95 - 199 MONTEREY BLVD | - | - | - | - | - |
| 80002 | N/A | Point | - | - | - | - | S123798 | - | - | F | F | - | F | 2179000 | - | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131482 | 131482 | 37.71003623 | -122.45881834 | - | - | 1727485749000 | middleware_editor | BEGIN | - | - | 200'WEST ABOVE R26 | - | - | - | - | - | 97122 | 1147910400000 | - | - | - | - | - | D11 | - | OTHER REGULATORY | REG | R81A(CA).0001 | 12X05 | SUP2 | LIGHT POLE | IS | - | - | 3157 - 3279 ALEMANY BLVD | - | - | - | - | - |
| 80003 | N/A | Point | - | - | - | - | S124488 | - | - | F | F | - | F | 9173000 | - | - | SHOULD BE RETIRED | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 131483 | 131483 | 37.71967616 | -122.43862356 | - | - | 1746134754000 | middleware_editor | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | IF OF SAFEWAY/ 50 FT SO. OF FRANCE | - | - | - | - | - | 97123 | 1152860400000 | - | - | - | - | - | D11 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP2 | LIGHT POLE | RETD | - | - | 4900 - 4950 MISSION ST | - | - | - | - | - |
| 80004 | N/A | Point | - | - | - | - | S246473 | - | - | F | F | - | F | 8760030 | - | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131484 | 131484 | 37.77103758 | -122.42439918 | - | - | 1710539427000 | MTA | YIELD HERE TO PED (SYM) (LA) | - | - | AT 1845 MARKET ST | - | - | - | - | - | 97124 | 1529936700000 | - | - | - | - | - | D8 | - | PEDESTRIAN | REG | R1-5.0002 | 30X30 | SUP2 | LIGHT POLE | IS | - | - | 1829 - 1899 MARKET ST | - | - | - | - | - |
| 80005 | N/A | Point | - | - | - | - | S245558 | - | - | F | F | - | F | 8843000 | - | - | - | EAST SIDE | 1689201376000 | MTA | - | - | - | - | 131485 | 131485 | 37.78173382 | -122.4475608 | - | - | 1710539427000 | MTA | TANSAT | - | - | 100 NORTH OF OFARRELL | - | - | - | - | - | 97125 | 1412035200000 | - | - | - | 1527206400000 | - | D1 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | LIGHT POLE | IS | - | - | 5 - 99 MASONIC AVE | - | - | - | - | - |
| 80006 | N/A | Point | - | - | - | - | S149318 | - | - | F | F | - | F | 5717201 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | CHUMASERO DR | - | 131486 | 131486 | 37.7145967 | -122.47237555 | - | - | 1723821580000 | middleware_editor | NPRK 9AM-11AM 2ND & 4TH THUR OF MONTH STCL | - | - | 100 FT WEST OF CHUMASERO | - | - | - | - | - | 97126 | 1225065600000 | - | - | - | 1723728300000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0295 | 18X18 | SUP2 | LIGHT POLE | IS | - | - | 100 - 198 FONT BLVD | - | - | - | CAMBON DR | - |
| 80007 | N/A | Point | - | - | - | LEFT ARROW | S216271 | - | - | F | F | - | F | 2175000 | - | - | - | EAST SIDE | 1689201376000 | MTA | - | - | - | - | 131487 | 131487 | 37.71300192 | -122.45047758 | - | - | 1727312901000 | middleware_editor | NPRK ANY TIME | - | - | 50FT SOUTH OF NAGLEE | - | - | - | - | - | 97127 | 1434034140000 | - | - | - | 1433980800000 | - | D11 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0002 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 2701 - 2899 ALEMANY BLVD | - | - | - | - | - |
| 80008 | N/A | Point | - | - | - | - | S202170 | - | - | F | F | - | F | 6437000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131488 | 131488 | 37.74817974 | -122.50781822 | - | - | 1713298580000 | middleware_editor | OBSOLETE GUIDE SIGNS | - | - | 151`WEST OF SKYLINE | - | - | - | - | - | 97128 | 1422429540000 | - | - | - | 1422403200000 | - | D7 | - | OTHER GUIDE | GUIDE | G-O(SF).0003 | 36X30 | SUP2 | LIGHT POLE | IS | - | - | 2000 - 2099 GREAT HWY | - | - | - | - | - |
| 80009 | N/A | Point | - | - | - | RIGHT ARROW | S242136 | - | - | F | F | - | F | 155270050 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | - | - | 131489 | 131489 | 37.72597244 | -122.3952049 | - | - | 1750184664000 | middleware_editor | PARK PARALLEL | - | - | E-LINE OF 1ST RED BULB OUT WEST OF 3RDST | - | - | - | - | - | 97129 | 1515702600000 | - | - | - | 1515657600000 | - | D10 | - | PARKING:PARALLEL | REG | R24(CA).0001 | 18X18 | SUP1 | LIGHT POLE | IS | - | - | 1700 - 1799 CARROLL AVE | - | - | - | - | - |
| 80010 | N/A | Point | - | - | - | - | S146045 | - | - | F | F | - | F | 9036000 | - | - | - | SOUTH SIDE | 1689201376000 | MTA | - | - | - | - | 131491 | 131491 | 37.71574684 | -122.45479709 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM 1ST & 3RD WED OF MONTH STCL | - | - | 39 MINERVA | - | - | - | - | - | 97130 | 1223251200000 | - | - | - | 1636329600000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0289 | 18X18 | SUP2 | LIGHT POLE | IS | - | - | 1 - 99 MINERVA ST | - | - | - | - | - |
| 80011 | N/A | Point | - | - | - | - | S104489 | GIRARD ST: BACON ST | - | F | F | - | F | 20638000 | 20638000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GIRARD ST | GIRARD ST | 2738 | 2738 | 37.727447843 | -122.404708271 | BACON ST \ GIRARD ST | BACON ST \ GIRARD ST | 1710539427000 | MTA | STOP | GIRARD ST intersection | - | 0 / 0 | - | - | - | - | - | 97131 | 2160000000 | -122.40459383 | 37.7273743 | - | 1539043200000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568960000 | BACON ST | - | - | - | - | - | - |
| 80012 | N/A | Point | - | - | - | - | S105953 | LEAVENWORTH ST: JACKSON ST | - | F | F | - | F | 25272000 | 25272000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LEAVENWORTH ST | JACKSON ST | 3008 | 3008 | 37.79477729 | -122.41647275 | JACKSON ST \ LEAVENWORTH ST | LEAVENWORTH ST \ JACKSON ST | 1728004930000 | middleware_editor | STOP | JACKSON ST intersection | - | - | - | - | - | - | - | 97132 | 110480400000 | -122.41647275 | 37.79477729 | - | 1609804800000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569380000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 80013 | N/A | Point | - | - | - | - | S107301 | BRAZIL AVE: MUNICH ST | - | F | F | - | F | 21618000 | 21618000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | BRAZIL AVE | 3048 | 3048 | 37.720872163 | -122.426942539 | MUNICH ST \ BRAZIL AVE | MUNICH ST \ BRAZIL AVE | 1710539427000 | MTA | STOP | BRAZIL AVE intersection | - | 0 / 0 | - | - | - | - | - | 97133 | 215654400000 | -122.42683078 | 37.72086792 | - | 1579651200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569800000 | MUNICH ST | - | - | - | - | - | - |
| 80014 | N/A | Point | - | - | - | - | S107304 | MUNICH ST: BRAZIL AVE | - | F | F | - | F | 21618000 | 21618000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | BRAZIL AVE | 3051 | 3051 | 37.720977537 | -122.426848661 | MUNICH ST \ BRAZIL AVE | MUNICH ST \ BRAZIL AVE | 1710539427000 | MTA | STOP | BRAZIL AVE intersection | - | 0 / 0 | - | - | - | - | - | 97134 | 215654400000 | -122.42683078 | 37.72086792 | - | 1579651200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569800000 | MUNICH ST | - | - | - | - | - | - |
| 80015 | N/A | Point | - | - | - | - | S107306 | ITALY AVE: EDINBURGH ST | - | F | F | - | F | 21726000 | 21726000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | EDINBURGH ST | EDINBURGH ST | 3052 | 3052 | 37.716568131 | -122.435407868 | ITALY AVE \ EDINBURGH ST | ITALY AVE \ EDINBURGH ST | 1710539427000 | MTA | STOP | EDINBURGH ST intersection | - | 0 / 0 | - | - | - | - | - | 97135 | 215913600000 | -122.43553125 | 37.71657096 | - | 1429488000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569800000 | ITALY AVE | - | - | - | - | - | - |
| 80016 | N/A | Point | - | - | - | - | S101849 | TURK ST: SCOTT ST | - | T | T | - | F | 26074000 | 26074000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TURK ST | TURK ST | 3209 | 3209 | 37.7798674 | -122.43707187 | SCOTT ST \ TURK ST | SCOTT ST \ TURK ST | 1710539427000 | MTA | ONE WAY (LA) | TURK ST intersection | - | 0 / 0 | - | - | - | - | - | 97136 | -394934400000 | -122.43707187 | 37.7798674 | - | - | - | D5 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373566920000 | SCOTT ST | - | - | - | - | - | - |
| 80017 | N/A | Point | - | - | - | - | S106715 | PIERCE ST: OAK ST | - | F | F | - | F | 26002000 | 26002000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | OAK ST | OAK ST | 3255 | 3255 | 37.77354938 | -122.43410901 | PIERCE ST \ OAK ST | PIERCE ST \ OAK ST | 1746828270000 | middleware_editor | DO NOT ENTER | OAK ST intersection | - | 0 / MADE PIERCE ONE WAY SB BET FELL..... | - | - | - | - | - | 97137 | 160214400000 | -122.43410901 | 37.77354938 | - | - | - | D5 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1373569620000 | PIERCE ST | - | - | - | - | - | - |
| 80018 | N/A | Point | - | - | - | - | S101655 | SCOTT ST: SUTTER ST | - | F | F | - | F | 26625000 | 26625000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SUTTER ST | SCOTT ST | 3264 | 3264 | 37.78545934 | -122.43820638 | SCOTT ST \ SUTTER ST | SUTTER ST \ SCOTT ST | 1754407888000 | middleware_editor | STOP | SCOTT ST intersection | - | 0 / 0 | - | - | - | - | - | 97138 | -395427600000 | -122.43820638 | 37.78545934 | - | 1557385200000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566860000 | SUTTER ST | - | - | - | - | - | - |
| 80019 | N/A | Point | - | - | - | - | S101657 | PRECITA AVE: FOLSOM ST | - | F | F | - | F | 21172000 | 21172000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | FOLSOM ST | 3266 | 3266 | 37.7473315 | -122.41183127 | PRECITA AVE \ FOLSOM ST | PRECITA AVE \ FOLSOM ST | 1710539427000 | MTA | DO NOT ENTER | FOLSOM ST intersection | - | 0 / MADE WESTBOUND ONE WAY | - | - | - | - | - | 97139 | -395452800000 | -122.41357113 | 37.74717102 | - | - | - | D9 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP2 | UNKNOWN | IS | 1373566860000 | PRECITA AVE | - | - | - | - | - | - |
| 80020 | N/A | Point | - | - | - | - | S107930 | CHURCH ST: 21ST ST | - | F | F | - | F | 25663000 | 25663000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CHURCH ST | CHURCH ST | 3282 | 3282 | 37.75649407 | -122.42789161 | 21ST ST \ CHURCH ST | 21ST ST \ CHURCH ST | 1721956715000 | middleware_editor | STOP | CHURCH ST intersection | - | 0 / 00 | - | - | - | - | - | 97140 | 264729600000 | -122.42789161 | 37.75649407 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373570040000 | 21ST ST | - | - | - | - | - | - |
| 80021 | N/A | Point | - | - | - | - | S107943 | ALPHA ST: TEDDY AVE | - | F | F | - | F | 20322000 | 20322000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | TEDDY AVE | ALPHA ST | 3293 | 3293 | 37.713919999 | -122.404468398 | ALPHA ST \ TEDDY AVE | TEDDY AVE \ ALPHA ST | 1710539427000 | MTA | STOP | ALPHA ST intersection | - | - | - | - | - | - | - | 97141 | 266716800000 | -122.40445834 | 37.71383937 | - | 1686700800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570040000 | TEDDY AVE | - | - | - | - | - | - |
| 80022 | N/A | Point | - | - | - | - | S107944 | ALPHA ST: TEDDY AVE | - | F | F | - | F | 2216000 | 20322000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TEDDY AVE | ALPHA ST | 3294 | 3294 | 37.713777306 | -122.404452305 | - | TEDDY AVE \ ALPHA ST | 1710539427000 | MTA | STOP | ALPHA ST intersection | - | - | - | - | - | - | - | 97142 | 266716800000 | -122.40445834 | 37.71383937 | - | 1704278100000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570040000 | TEDDY AVE | 200 - 299 ALPHA ST | - | - | - | ARLETA AVE | - |
| 80023 | N/A | Point | - | - | - | - | S104154 | ELLSWORTH ST: CORTLAND AVE | - | F | F | - | F | 21084000 | 21084000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CORTLAND AVE | CORTLAND AVE | 3325 | 3325 | 37.73888149 | -122.41455886 | ELLSWORTH ST \ CORTLAND AVE | ELLSWORTH ST \ CORTLAND AVE | 1710539427000 | MTA | ONE WAY (RA) | CORTLAND AVE intersection | - | - | - | - | - | - | - | 97143 | -43113600000 | -122.41455886 | 37.73888149 | - | 1538352000000 | - | D9 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | 2IN IRON POST | IS | 1373568840000 | ELLSWORTH ST | - | - | - | - | - | - |
| 80024 | N/A | Point | - | - | - | - | S104173 | STATES ST: CASTRO ST | - | F | F | - | F | 25822000 | 25822000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CASTRO ST | CASTRO ST | 3339 | 3339 | 37.76346284 | -122.43525866 | STATES ST \ CASTRO ST | STATES ST \ CASTRO ST | 1710539427000 | MTA | STOP | CASTRO ST intersection | - | - | - | - | - | - | - | 97144 | -42620400000 | -122.43525866 | 37.76346284 | - | 1614136500000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | MUNI POLE | IS | 1373568840000 | STATES ST | - | - | - | - | - | - |
| 80025 | N/A | Point | - | - | - | - | S102085 | BARTLETT ST: 22ND ST | - | F | F | - | F | 24112000 | 24112000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 22ND ST | BARTLETT ST | 3362 | 3362 | 37.755289387 | -122.419803625 | BARTLETT ST \ 22ND ST | 22ND ST \ BARTLETT ST | 1710539427000 | MTA | STOP | BARTLETT ST intersection | - | 0 / 00 | - | - | - | - | - | 97145 | -392601600000 | -122.41985794 | 37.75536573 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568180000 | 22ND 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.