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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 73876 | N/A | Point | - | - | - | - | S277196 | LA GRANDE AVE: BRAZIL AVE | - | F | F | - | F | 21607000 | 21607000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LA GRANDE AVE | BRAZIL AVE | 108470 | 108470 | 37.7201228926281 | -122.425415076527 | BRAZIL AVE \ LA GRANDE AVE | LA GRANDE AVE \ BRAZIL AVE | 1750714122000 | middleware_editor | STOP | BRAZIL AVE intersection | - | 5' SOUTH OF BRAZIL AVE. | - | - | - | - | - | 90993 | - | -122.42547935 | 37.72023259 | - | 1750696800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1629367980000 | LA GRANDE AVE | - | - | - | - | - | - |
| 73877 | N/A | Point | - | - | - | - | S277197 | LA GRANDE AVE: BRAZIL AVE | - | F | F | - | F | 21607000 | 21607000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LA GRANDE AVE | BRAZIL AVE | 108471 | 108471 | 37.7201224210176 | -122.425414977264 | BRAZIL AVE \ LA GRANDE AVE | LA GRANDE AVE \ BRAZIL AVE | 1750714114000 | middleware_editor | ALL WAY | BRAZIL AVE intersection | - | 5' SOUTH OF BRAZIL AVE. | - | - | - | - | - | 90994 | - | -122.42547935 | 37.72023259 | - | 1750698300000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1629368040000 | LA GRANDE AVE | - | - | - | - | - | - |
| 73878 | N/A | Point | - | - | - | - | S261997 | YALE ST: SILVER AVE | - | T | T | - | F | 20991000 | 20991000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | YALE ST | YALE ST | 108474 | 108474 | 37.72903876 | -122.41838131 | SILVER AVE \ YALE ST | SILVER AVE \ YALE ST | 1727919558000 | middleware_editor | SPEED HUMP | YALE ST intersection | - | - | - | - | - | - | - | 90995 | 745027200000 | -122.41838131 | 37.72903876 | - | 1583366400000 | - | D9 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1582811100000 | SILVER AVE | - | - | - | - | - | - |
| 73879 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S260850 | 1300-1399 VAN DYKE AVE | 1300-1399 VAN DYKE AVE | F | F | - | F | 13139000 | 13139000 | - | - | SOUTH SIDE | - | - | - | - | INGALLS ST | INGALLS ST | 108487 | 108487 | 37.72651491 | -122.38773646 | - | - | 1745359992000 | middleware_editor | TANS EXC 30 MIN TL 9AM-6PM MON-FRI | INGALLS ST to JENNINGS ST (1300 - 1399) | - | INFO #1333 | - | - | - | - | - | 90996 | - | -122.38773646 | 37.72651491 | - | - | - | D10 | - | OTHER REGULATORY | REG | R37(SF).0206 | 10X15 | SUP1 | 2IN IRON POST | IS | 1580311140000 | VAN DYKE AVE | 1300 - 1399 VAN DYKE AVE | 1300 - 1399 VAN DYKE AVE | 1300 VAN DYKE AVE | - | JENNINGS ST | JENNINGS ST |
| 73880 | N/A | Point | - | - | - | - | S256879 | HUDSON AVE: KEITH ST | - | T | T | - | F | 20201000 | 20201000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HUDSON AVE | HUDSON AVE | 108538 | 108538 | 37.73751422 | -122.38404651 | KEITH ST \ HUDSON AVE | KEITH ST \ HUDSON AVE | 1710539427000 | MTA | SPEED HUMPS | HUDSON AVE intersection | - | - | - | - | - | - | - | 90997 | 1468195200000 | -122.38404651 | 37.73751422 | - | 1566777600000 | - | D10 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1565171700000 | KEITH ST | - | - | - | - | - | - |
| 73881 | N/A | Point | - | - | - | - | S222619 | MISSION ST: CAPP ST \ CESAR CH | - | F | F | - | F | 21304000 | 21304000 | - | - | CENTER ISLAND, W LINE, NORTHBOUND | - | - | - | - | CESAR CHAVEZ ST \ MISSION ST | CAPP ST \ CESAR CHAVEZ ST | 108547 | 108547 | 37.74816569 | -122.41822117 | CAPP ST \ CESAR CHAVEZ ST \ MISSION ST | MISSION ST \ CAPP ST \ CESAR CHAVEZ ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | CAPP ST \ CESAR CHAVEZ ST intersection | - | - | - | - | - | - | - | 90998 | - | -122.41822117 | 37.74816569 | - | - | - | D9 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1453548900000 | MISSION ST | - | - | - | - | - | - |
| 73882 | N/A | Point | 1 | 1 | 300 - 399 | - | S280019 | 300-399 BERRY ST | 300-399 BERRY ST | F | F | - | F | 2955000 | 2955000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 5TH ST | 05TH ST | 108608 | 108608 | 37.7731514 | -122.3966889 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | 05TH ST to 06TH ST (300 - 399) | - | 10' WEST OF 5TH ST | - | - | - | - | - | 90999 | 1640822400000 | -122.3966889 | 37.7731514 | - | - | - | D6 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1640686800000 | BERRY ST | 300 - 399 BERRY ST | 300 - 399 BERRY ST | 300 BERRY ST | - | 06TH ST | 06TH ST |
| 73883 | N/A | Point | 1 | 1 | 300 - 399 | - | S211294 | 300-399 31ST AVE | 300-399 31ST AVE | F | F | - | F | 1679000 | 1679000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 110150 | 110150 | 37.7819058721012 | -122.491249721876 | - | - | 1746635077000 | middleware_editor | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | CALIFORNIA ST to CLEMENT ST (300 - 399) | - | 10' N. OF CLEMENT | - | - | - | - | - | 91000 | 1221721200000 | -122.49136764 | 37.78265875 | - | 1424246400000 | - | D1 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | 2IN IRON POST | IS | 1417521540000 | 31ST AVE | 300 - 399 31ST AVE | 300 - 399 31ST AVE | 300 31ST AVE | - | CLEMENT ST | CLEMENT ST |
| 73884 | N/A | Point | - | - | - | - | S217150 | 14TH AVE: SANTIAGO ST | - | F | F | - | F | 32888000 | 32888000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | SANTIAGO ST | 14TH AVE | 110153 | 110153 | 37.74515899 | -122.4703653 | 14TH AVE \ SANTIAGO ST | SANTIAGO ST \ 14TH AVE | 1749769580000 | middleware_editor | SPEED HUMPS | 14TH AVE intersection | - | 3FT. SOUTH OF NPL# 2380 | - | - | - | - | - | 91001 | 1438015500000 | -122.4703653 | 37.74515899 | - | 1437980400000 | - | D7 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1434550200000 | SANTIAGO ST | - | - | - | - | - | - |
| 73885 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S231663 | 1200-1299 4TH ST | 1200-1299 04TH ST | F | F | - | F | 19983000 | 19983000 | - | - | WEST SIDE | - | - | - | - | MISSION ROCK ST | MISSION ROCK ST | 110184 | 110184 | 37.77236409 | -122.39132889 | - | - | 1710539427000 | MTA | SPECIAL EVENT AREA CHECK YOUR METER (SFPARK) | MISSION ROCK ST to CHINA BASIN ST (1200 - 1299) | - | 105' N OF CHINA BASIN | - | - | - | - | - | 91002 | 1481292060000 | -122.39132889 | 37.77236409 | - | 1481241600000 | - | D6 | - | OTHER GUIDE | GUIDE | G-S(SF).0058 | 18X18 | SUP1 | LIGHT POLE | IS | 1481271300000 | 04TH ST | 1200 - 1299 4TH ST | 1200 - 1299 04TH ST | 1200 4TH ST | - | CHINA BASIN ST | CHINA BASIN ST |
| 73886 | N/A | Point | - | - | - | - | S231432 | MASONIC AVE: UPPER TER | - | F | F | - | F | 26328000 | 26328000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | UPPER TER | UPPER TER | 110195 | 110195 | 37.76532273 | -122.44353831 | MASONIC AVE \ UPPER TER | MASONIC AVE \ UPPER TER | 1741013633000 | middleware_editor | ALL WAY | UPPER TER intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 91003 | 1489772100000 | -122.44353831 | 37.76532273 | - | 1489734000000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1480660620000 | MASONIC AVE | - | - | - | - | - | - |
| 73887 | N/A | Point | 1 | 1 | 1000 - 1049 | - | S260883 | 1000-1049 PIERCE ST | 1000-1049 PIERCE ST | T | T | - | F | 10425000 | 10425000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | GOLDEN GATE AVE | GOLDEN GATE AVE | 110231 | 110231 | 37.77938994 | -122.43528922 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | GOLDEN GATE AVE to ELM ST (1000 - 1049) | 134124 | NPL 1022 | - | - | - | - | - | 91004 | 1321315200000 | -122.43528922 | 37.77938994 | - | - | - | D5 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP1 | LIGHT POLE | IS | 1580386380000 | PIERCE ST | 1000 - 1049 PIERCE ST | 1000 - 1049 PIERCE ST | 1000 PIERCE ST | - | ELM ST | ELM ST |
| 73888 | N/A | Point | - | - | - | - | S272477 | TARAVAL ST: 47TH AVE | - | F | F | - | F | 23503000 | 23503000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 47TH AVE | 110267 | 110267 | 37.74171621 | -122.50569099 | 47TH AVE \ TARAVAL ST | TARAVAL ST \ 47TH AVE | 1729215604000 | middleware_editor | STOP | 47TH AVE intersection | - | - | - | - | - | - | - | 91005 | -404870400000 | -122.50569099 | 37.74171621 | - | 1623628800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1613558760000 | TARAVAL ST | - | - | - | - | - | - |
| 73889 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S263336 | 2000-2099 23RD AVE | 2000-2099 23RD AVE | F | F | - | F | 1226000 | 1226000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | PACHECO ST | PACHECO ST | 110343 | 110343 | 37.74938872 | -122.48043328 | - | - | 1713315754000 | middleware_editor | SCHOOL (SYM)/SCHOOL | PACHECO ST to QUINTARA ST (2000 - 2099) | 100221 | SPL# 2063 | - | - | - | - | - | 91006 | 1133568000000 | -122.48043328 | 37.74938872 | - | 1667865600000 | - | D4 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1586944320000 | 23RD AVE | 2000 - 2099 23RD AVE | 2000 - 2099 23RD AVE | 2000 23RD AVE | - | QUINTARA ST | QUINTARA ST |
| 73890 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S266606 | 1600-1699 20TH AVE | 1600-1699 20TH AVE | F | F | - | F | 1009000 | 1009000 | - | - | EAST SIDE | - | - | - | - | LAWTON ST | LAWTON ST | 110374 | 110374 | 37.75699008 | -122.47774366 | - | - | 1736285519000 | middleware_editor | NPRK 7AM-9AM FRI STCL | LAWTON ST to MORAGA ST (1600 - 1699) | - | 70' S OF LAWTON OPP 1609 | - | - | - | - | - | 91007 | 1546560000000 | -122.47774366 | 37.75699008 | - | 1735817100000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0235 | 18X18 | SUP2 | 2IN IRON POST | IS | 1595927640000 | 20TH AVE | 1600 - 1699 20TH AVE | 1600 - 1699 20TH AVE | 1600 20TH AVE | - | MORAGA ST | MORAGA ST |
| 73891 | N/A | Point | - | - | - | - | S279072 | FRANKLIN ST: UNION ST | - | F | F | - | F | 26687000 | 26687000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 110444 | 110444 | 37.79834354 | -122.4256255 | UNION ST \ FRANKLIN ST | UNION ST \ FRANKLIN ST | 1747861795000 | middleware_editor | TREE TOP 6FT SPEED BUMP | FRANKLIN ST intersection | - | - | - | - | - | - | - | 91008 | - | -122.4256255 | 37.79834354 | - | 1688108400000 | - | D2 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1637581260000 | UNION ST | - | - | - | - | - | - |
| 73892 | N/A | Point | - | - | - | - | S279073 | FRANKLIN ST: UNION ST | - | F | F | - | F | 26687000 | 26687000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 110445 | 110445 | 37.79834354 | -122.4256255 | UNION ST \ FRANKLIN ST | UNION ST \ FRANKLIN ST | 1747855223000 | mmadsen | TREE TOP 6FT SPEED BUMP | FRANKLIN ST intersection | - | - | - | - | - | - | - | 91009 | 1649314800000 | -122.4256255 | 37.79834354 | - | 1688108400000 | 1683788400000 | D2 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1637581320000 | UNION ST | - | - | - | - | - | - |
| 73893 | N/A | Point | - | - | - | - | S279075 | FRANKLIN ST: UNION ST | - | F | F | - | F | 26687000 | 26687000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 110446 | 110446 | 37.79834354 | -122.4256255 | UNION ST \ FRANKLIN ST | UNION ST \ FRANKLIN ST | 1747861825000 | middleware_editor | TREE TOP 6FT SPEED BUMP | FRANKLIN ST intersection | - | - | - | - | - | - | - | 91010 | 1649314800000 | -122.4256255 | 37.79834354 | - | 1688108400000 | - | D2 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1637583180000 | UNION ST | - | - | - | - | - | - |
| 73894 | N/A | Point | - | - | - | - | S124162 | VIENNA ST: ITALY AVE | - | F | F | - | F | 21409000 | 21409000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VIENNA ST | VIENNA ST | 111672 | 111672 | 37.715907004 | -122.433948795 | ITALY AVE \ VIENNA ST | ITALY AVE \ VIENNA ST | 1710539427000 | MTA | ALL WAY | VIENNA ST intersection | - | - | - | - | - | - | - | 91011 | 1150761600000 | -122.43393069 | 37.71580622 | - | - | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575080000 | ITALY AVE | - | - | - | - | - | - |
| 73895 | N/A | Point | - | - | - | - | S125191 | FILLMORE ST: PACIFIC AVE | - | F | F | - | F | 26657000 | 26657000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PACIFIC AVE | FILLMORE ST | 111682 | 111682 | 37.793443376 | -122.434824855 | FILLMORE ST \ PACIFIC AVE | PACIFIC AVE \ FILLMORE ST | 1710539427000 | MTA | ALL WAY | FILLMORE ST intersection | - | - | - | - | - | - | - | 91012 | 1156291200000 | -122.43473366 | 37.79334729 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575440000 | PACIFIC AVE | - | - | - | - | - | - |
| 73896 | N/A | Point | - | - | - | - | S256626 | MOSCOW ST: EXCELSIOR AVE | - | F | F | - | F | 21621000 | 21621000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 113174 | 113174 | 37.722713864 | -122.426423447 | MOSCOW ST \ EXCELSIOR AVE | MOSCOW ST \ EXCELSIOR AVE | 1710539427000 | MTA | STOP | EXCELSIOR AVE intersection | - | - | - | - | - | - | - | 91013 | 1329177600000 | -122.42646815 | 37.7228256 | - | 1565049600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1564578000000 | MOSCOW ST | - | - | - | - | - | - |
| 73897 | N/A | Point | 1 | 1 | 400 - 499 | - | S277098 | 400-499 15TH AVE | 400-499 15TH AVE | F | F | - | F | 609000 | 609000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | GEARY BLVD | GEARY BLVD | 113226 | 113226 | 37.7796142 | -122.4739077 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | GEARY BLVD to ANZA ST (400 - 499) | - | 10 FT NORTH OF ANZA | - | - | - | - | - | 91014 | 1221177600000 | -122.4739077 | 37.7796142 | - | 1629158400000 | - | D1 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1628687460000 | 15TH AVE | 400 - 499 15TH AVE | 400 - 499 15TH AVE | 400 15TH AVE | - | ANZA ST | ANZA ST |
| 73898 | N/A | Point | 1 | 1 | 400 - 499 | - | S277100 | 400-499 15TH AVE | 400-499 15TH AVE | T | T | - | F | 609000 | 609000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | GEARY BLVD | GEARY BLVD | 113227 | 113227 | 37.7796142 | -122.4739077 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | GEARY BLVD to ANZA ST (400 - 499) | 121886675 | 60' SOUTH OF GEARY BLV. | - | - | - | - | - | 91015 | 1221177600000 | -122.4739077 | 37.7796142 | - | 1629417600000 | - | D1 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1628687700000 | 15TH AVE | 400 - 499 15TH AVE | 400 - 499 15TH AVE | 400 15TH AVE | - | ANZA ST | ANZA ST |
| 73899 | N/A | Point | - | - | - | - | S266185 | 19TH AVE: CLEMENT ST | - | F | F | - | F | 27506000 | 27506000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 113236 | 113236 | 37.78230838 | -122.47844351 | 19TH AVE \ CLEMENT ST | 19TH AVE \ CLEMENT ST | 1715356424000 | middleware_editor | SPEED HUMPS | CLEMENT ST intersection | - | - | - | - | - | - | - | 91016 | -74908800000 | -122.47844351 | 37.78230838 | - | 1594684800000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1594645500000 | 19TH AVE | - | - | - | - | - | - |
| 73900 | N/A | Point | - | - | - | - | S266187 | 19TH AVE: CLEMENT ST | - | F | F | - | F | 27506000 | 27506000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 113237 | 113237 | 37.78230838 | -122.47844351 | 19TH AVE \ CLEMENT ST | 19TH AVE \ CLEMENT ST | 1715356421000 | middleware_editor | SPEED HUMPS | CLEMENT ST intersection | - | - | - | - | - | - | - | 91017 | -74908800000 | -122.47844351 | 37.78230838 | - | 1594944000000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | UTILITY POLE | IS | 1594646700000 | 19TH AVE | - | - | - | - | - | - |
| 73901 | N/A | Point | - | - | - | - | S266189 | 19TH AVE: CLEMENT ST | - | F | F | - | F | 27506000 | 27506000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 113239 | 113239 | 37.78230838 | -122.47844351 | 19TH AVE \ CLEMENT ST | 19TH AVE \ CLEMENT ST | 1715356446000 | middleware_editor | SPEED HUMPS | CLEMENT ST intersection | - | NPL 394 | - | - | - | - | - | 91018 | -74908800000 | -122.47844351 | 37.78230838 | - | 1594944000000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1594647000000 | 19TH AVE | - | - | - | - | - | - |
| 73902 | N/A | Point | 1 | 1 | 200 - 299 | - | S266191 | 200-299 24TH AVE | 200-299 24TH AVE | F | F | - | F | 1291000 | 1291000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | LAKE ST | LAKE ST | 113241 | 113241 | 37.78486271 | -122.48400798 | - | - | 1710539427000 | MTA | SPEED HUMPS | LAKE ST to CALIFORNIA ST (200 - 299) | - | 40FT NORTH OF CALIFORNIA ST ABOVE SIGN | - | - | - | - | - | 91019 | 1594944000000 | -122.48400798 | 37.78486271 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1594647780000 | 24TH AVE | 200 - 299 24TH AVE | 200 - 299 24TH AVE | 200 24TH AVE | - | CALIFORNIA ST | CALIFORNIA ST |
| 73903 | N/A | Point | 1 | 1 | 200 - 299 | - | S266194 | 200-299 24TH AVE | 200-299 24TH AVE | F | F | - | F | 1291000 | 1291000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LAKE ST | LAKE ST | 113244 | 113244 | 37.78486271 | -122.48400798 | - | - | 1710539427000 | MTA | SPEED HUMPS | LAKE ST to CALIFORNIA ST (200 - 299) | 121734365 | 56' SOUTH OF LAKE ST | - | - | - | - | - | 91020 | 1594944000000 | -122.48400798 | 37.78486271 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1594648140000 | 24TH AVE | 200 - 299 24TH AVE | 200 - 299 24TH AVE | 200 24TH AVE | - | CALIFORNIA ST | CALIFORNIA ST |
| 73904 | N/A | Point | 1 | 1 | 800 - 899 | RIGHT ARROW | S265310 | 800-899 LONDON ST | 800-899 LONDON ST | F | F | - | F | 8478000 | 8478000 | - | - | WEST SIDE | - | - | - | - | AMAZON AVE | AMAZON AVE | 113269 | 113269 | 37.716350031 | -122.440119415 | - | - | 1710539427000 | MTA | 2 HR PRK 7AM-6PM EXC SUN | AMAZON AVE to GENEVA AVE (800 - 899) | - | 70 ' NORTH OF GENEVA | - | - | - | - | - | 91021 | - | -122.43993166 | 37.71649431 | - | - | - | D11 | - | PARKING | REG | R32(CA).0071 | 18X18 | SUP2 | 2IN IRON POST | IS | 1592573520000 | LONDON ST | 800 - 899 LONDON ST | 800 - 899 LONDON ST | 800 LONDON ST | - | GENEVA AVE | GENEVA AVE |
| 73905 | N/A | Point | 1 | 1 | 100 - 199 | - | S261887 | 100-199 BACON ST | 100-199 BACON ST | F | F | - | F | 2580000 | 2580000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | SAN BRUNO AVE | SAN BRUNO AVE | 113320 | 113320 | 37.727478399 | -122.404447859 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | SAN BRUNO AVE to GIRARD ST (100 - 199) | 132744 | 20' EAST OF GIRARD ST. | - | - | - | - | - | 91022 | 1316649600000 | -122.40409336 | 37.72750421 | - | - | - | D9 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1582643760000 | BACON ST | 100 - 199 BACON ST | 100 - 199 BACON ST | 100 BACON ST | - | GIRARD ST | GIRARD ST |
| 73906 | N/A | Point | - | - | - | - | S264090 | SAN JOSE AVE: RANDALL ST | - | T | T | - | F | 21838000 | 21838000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | RANDALL ST | RANDALL ST | 113357 | 113357 | 37.739769539 | -122.42462056 | SAN JOSE AVE \ RANDALL ST | SAN JOSE AVE \ RANDALL ST | 1710539427000 | MTA | LANE REDUCTION (SYM) LEFT | RANDALL ST intersection | - | NPL #1739 | - | - | - | - | - | 91023 | - | -122.42414715 | 37.73986923 | - | - | - | D8 | - | OTHER WARNING | WARNING | W4-2.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1589205960000 | SAN JOSE AVE | - | - | - | - | - | - |
| 73907 | N/A | Point | - | - | - | - | S270057 | BALBOA ST: 43RD AVE | - | F | F | - | F | 27908000 | 27908000 | - | - | NORTH WEST CORNER | - | - | - | - | BALBOA ST | BALBOA ST | 113390 | 113390 | 37.7755018013132 | -122.503839401512 | 43RD AVE \ BALBOA ST | 43RD AVE \ BALBOA ST | 1753366917000 | middleware_editor | BALBOA ST | BALBOA ST intersection | - | - | - | - | - | - | - | 91024 | 25513200000 | -122.50374465 | 37.77542147 | - | 1753305600000 | - | D1 | - | STREET NAME | GUIDE | D3-1.0160 | 36X08 | SUP2 | 3IN IRON POST | IS | 1605260880000 | 43RD AVE | - | - | - | - | - | - |
| 73908 | N/A | Point | - | - | - | - | S270058 | BALBOA ST: 43RD AVE | - | F | F | - | F | 27908000 | 27908000 | - | - | NORTH WEST CORNER | - | - | - | - | BALBOA ST | BALBOA ST | 113391 | 113391 | 37.7755071044373 | -122.503833648789 | 43RD AVE \ BALBOA ST | 43RD AVE \ BALBOA ST | 1753367505000 | middleware_editor | 43RD AVE | BALBOA ST intersection | - | - | - | - | - | - | - | 91025 | 25513200000 | -122.50374465 | 37.77542147 | - | 1753305600000 | - | D1 | - | STREET NAME | GUIDE | D3-1.0033 | 36X08 | SUP2 | 3IN IRON POST | IS | 1605261000000 | 43RD AVE | - | - | - | - | - | - |
| 73909 | N/A | Point | - | - | - | - | S225307 | MISSION ST: 19TH ST | - | F | F | - | F | 9121000 | 24145000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 113462 | 113462 | 37.760105302 | -122.419113056 | - | MISSION ST \ 19TH ST | 1710539427000 | MTA | EXCEPT MUNI | 19TH ST intersection | - | - | - | - | - | - | - | 91026 | 1095897600000 | -122.41920604 | 37.76023536 | - | 1462406400000 | - | D9 | - | OTHER REGULATORY | REG | R(SF).0357 | 30X08 | SUP2 | LIGHT POLE | IS | 1462282860000 | MISSION ST | 2300 - 2399 MISSION ST | - | - | - | 20TH ST | - |
| 73910 | N/A | Point | 1 | 1 | 700 - 749 | - | S266372 | 700-749 CHURCH ST | 700-749 CHURCH ST | F | F | - | F | 4018000 | 4018000 | - | - | EAST SIDE | - | - | - | - | 19TH ST | 19TH ST | 113652 | 113652 | 37.75929106 | -122.4281643 | - | - | 1710539427000 | MTA | NPRK ANY TIME | 19TH ST to CUMBERLAND ST (700 - 749) | - | 50 FT SOUTH OF CUMBERLAND OPP 726 | - | - | - | - | - | 91027 | 1595325300000 | -122.4281643 | 37.75929106 | - | - | - | D8 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0002 | 18X18 | SUP2 | 2IN IRON POST | IS | 1595240640000 | CHURCH ST | 700 - 749 CHURCH ST | 700 - 749 CHURCH ST | 700 CHURCH ST | - | CUMBERLAND ST | CUMBERLAND ST |
| 73911 | N/A | Point | - | - | - | - | S266374 | CESAR CHAVEZ ST: FLORIDA ST | - | F | F | - | F | 21139000 | 21139000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FLORIDA ST | FLORIDA ST | 113653 | 113653 | 37.74833439 | -122.40964639 | CESAR CHAVEZ ST \ FLORIDA ST | CESAR CHAVEZ ST \ FLORIDA ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | FLORIDA ST intersection | - | - | - | - | - | - | - | 91028 | 1400457600000 | -122.40964639 | 37.74833439 | - | 1595289600000 | - | D9 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1595244120000 | CESAR CHAVEZ ST | - | - | - | - | - | - |
| 73912 | N/A | Point | - | - | - | - | S266375 | CESAR CHAVEZ ST: FLORIDA ST | - | F | F | - | F | 21139000 | 21139000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FLORIDA ST | FLORIDA ST | 113654 | 113654 | 37.74833439 | -122.40964639 | CESAR CHAVEZ ST \ FLORIDA ST | CESAR CHAVEZ ST \ FLORIDA ST | 1710539427000 | MTA | (45 LA-DN) | FLORIDA ST intersection | - | - | - | - | - | - | - | 91029 | 1400457600000 | -122.40964639 | 37.74833439 | - | 1595289600000 | - | D9 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | 2IN IRON POST | IS | 1595244240000 | CESAR CHAVEZ ST | - | - | - | - | - | - |
| 73913 | N/A | Point | - | - | - | - | S266379 | ANDERSON ST: CRESCENT AVE | - | F | F | - | F | 21181000 | 21181000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CRESCENT AVE | CRESCENT AVE | 113655 | 113655 | 37.73482486 | -122.4155544 | ANDERSON ST \ CRESCENT AVE | ANDERSON ST \ CRESCENT AVE | 1734027476000 | middleware_editor | AHEAD | CRESCENT AVE intersection | - | UNDER SIGN | - | - | - | - | - | 91030 | 1108080000000 | -122.4155544 | 37.73482486 | - | 1595289600000 | - | D9 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP2 | 2IN IRON POST | IS | 1595248440000 | ANDERSON ST | - | - | - | - | - | - |
| 73914 | N/A | Point | 1 | 1 | 1 - 99 | - | S263628 | 1-99 DIAZ AVE | 1-99 DIAZ AVE | F | F | - | F | 4787000 | 4787000 | - | - | SOUTH SIDE | - | - | - | - | GONZALEZ DR | GONZALEZ DR | 113656 | 113656 | 37.71810804 | -122.47628123 | - | - | 1712769188000 | middleware_editor | 1 HR PRK 8AM-6PM MON-FRI EXC "E" PERMITS | GONZALEZ DR to JUAN BAUTISTA CIR (1 - 99) | 144213 | 31 DIAZ | - | - | - | - | - | 91031 | 971654400000 | -122.47628123 | 37.71810804 | - | - | - | D7 | - | PARKING:RPP | REG | R32C(CA).0008 | 18X21 | SUP2 | LIGHT POLE | IS | 1588148280000 | DIAZ AVE | 1 - 99 DIAZ AVE | 1 - 99 DIAZ AVE | 1 DIAZ AVE | - | JUAN BAUTISTA CIR | JUAN BAUTISTA CIR |
| 73915 | N/A | Point | 1 | 1 | 1 - 99 | - | S263629 | 1-99 DIAZ AVE | 1-99 DIAZ AVE | F | F | - | F | 4787000 | 4787000 | - | - | NORTH SIDE | - | - | - | - | GONZALEZ DR | GONZALEZ DR | 113657 | 113657 | 37.71810804 | -122.47628123 | - | - | 1713305951000 | middleware_editor | 1 HR PRK 8AM-6PM MON-FRI EXC "E" PERMITS | GONZALEZ DR to JUAN BAUTISTA CIR (1 - 99) | 319393 | EPL 26 | - | - | - | - | - | 91032 | 1321920000000 | -122.47628123 | 37.71810804 | - | 1713268800000 | - | D7 | - | PARKING:RPP | REG | R32C(CA).0008 | 18X21 | SUP2 | 2IN IRON POST | IS | 1588148640000 | DIAZ AVE | 1 - 99 DIAZ AVE | 1 - 99 DIAZ AVE | 1 DIAZ AVE | - | JUAN BAUTISTA CIR | JUAN BAUTISTA CIR |
| 73916 | N/A | Point | 1 | 1 | 1 - 99 | - | S263630 | 1-99 DIAZ AVE | 1-99 DIAZ AVE | F | F | - | F | 4787000 | 4787000 | - | - | SOUTH SIDE | - | - | - | - | GONZALEZ DR | GONZALEZ DR | 113658 | 113658 | 37.71810804 | -122.47628123 | - | - | 1712769069000 | middleware_editor | 1 HR PRK 8AM-6PM MON-FRI EXC "E" PERMITS | GONZALEZ DR to JUAN BAUTISTA CIR (1 - 99) | 269045 | 11 DIAZ | - | - | - | - | - | 91033 | 1257984000000 | -122.47628123 | 37.71810804 | - | - | - | D7 | - | PARKING:RPP | REG | R32C(CA).0008 | 18X21 | SUP2 | LIGHT POLE | IS | 1588149840000 | DIAZ AVE | 1 - 99 DIAZ AVE | 1 - 99 DIAZ AVE | 1 DIAZ AVE | - | JUAN BAUTISTA CIR | JUAN BAUTISTA CIR |
| 73917 | N/A | Point | - | - | - | - | S107576 | PAGE ST: LAGUNA ST | - | F | F | - | F | 25908000 | 25908000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LAGUNA ST | LAGUNA ST | 113764 | 113764 | 37.773739374 | -122.425605662 | PAGE ST \ LAGUNA ST | PAGE ST \ LAGUNA ST | 1710539427000 | MTA | STOP | LAGUNA ST intersection | - | 0 / 0 | - | - | - | - | - | 91034 | 236304000000 | -122.42570021 | 37.77366623 | - | 1195603200000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | MUNI POLE | IS | 1373569920000 | PAGE ST | - | - | - | - | - | - |
| 73918 | N/A | Point | 1 | 1 | 300 - 399 | - | S282181 | 300-399 RAYMOND AVE | 300-399 RAYMOND AVE | F | F | - | F | 10945000 | 10945000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | DELTA ST | DELTA ST | 113825 | 113825 | 37.71408269 | -122.41025486 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | DELTA ST to ELLIOT ST (300 - 399) | - | 30 FT EAST OF ELLIOT | - | - | - | - | - | 91035 | 1649808000000 | -122.41025486 | 37.71408269 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1649800260000 | RAYMOND AVE | 300 - 399 RAYMOND AVE | 300 - 399 RAYMOND AVE | 300 RAYMOND AVE | - | ELLIOT ST | ELLIOT ST |
| 73919 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S260851 | 1300-1399 VAN DYKE AVE | 1300-1399 VAN DYKE AVE | F | F | - | F | 13139000 | 13139000 | - | - | SOUTH SIDE | - | - | - | - | INGALLS ST | INGALLS ST | 113961 | 113961 | 37.72651491 | -122.38773646 | - | - | 1715119982000 | middleware_editor | TANS EXC 30 MIN TL 9AM-6PM MON-FRI | INGALLS ST to JENNINGS ST (1300 - 1399) | - | INFO 1333 | - | - | - | - | - | 91036 | - | -122.38773646 | 37.72651491 | - | - | - | D10 | - | OTHER REGULATORY | REG | R37(SF).0206 | 10X15 | SUP1 | 2IN IRON POST | IS | 1580311500000 | VAN DYKE AVE | 1300 - 1399 VAN DYKE AVE | 1300 - 1399 VAN DYKE AVE | 1300 VAN DYKE AVE | - | JENNINGS ST | JENNINGS ST |
| 73920 | N/A | Point | 1 | 1 | 451 - 499 | - | S263387 | 451-499 CLARENDON AVE | 451-499 CLARENDON AVE | F | F | - | F | 4073000 | 4073000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | PANORAMA DR | PANORAMA DR | 113975 | 113975 | 37.753430048 | -122.455648621 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | PANORAMA DR to ASHWOOD LN (451 - 499) | - | 110 FT SOUTH OF | - | - | - | - | - | 91037 | 1298505600000 | -122.45581313 | 37.7533226 | - | 1644969600000 | - | D7 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1587111660000 | CLARENDON AVE | 451 - 499 CLARENDON AVE | 451 - 499 CLARENDON AVE | 451 CLARENDON AVE | - | ASHWOOD LN | ASHWOOD LN |
| 73921 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S130153 | 1000-1099 POST ST | 1000-1099 POST ST | F | F | - | F | 10639000 | 10639000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | LARKIN ST | LARKIN ST | 114029 | 114029 | 37.786924261 | -122.418718587 | - | - | 1710539427000 | MTA | RIGHT LANE BUSES AND RIGHT TURNS ONLY AT ALL TIMES | LARKIN ST to POLK ST (1000 - 1099) | - | EPL # 1025 | - | - | - | - | - | 91038 | 1233273600000 | -122.41909946 | 37.78693274 | - | - | - | D6 | - | TRANSIT ONLY(RIGHT LANE) | REG | SR60-6(CA).0003 | 30X42 | SUP1 | MUNI POLE | IS | 1373577000000 | POST ST | 1000 - 1099 POST ST | 1000 - 1099 POST ST | 1000 POST ST | - | POLK ST | POLK ST |
| 73922 | N/A | Point | - | - | - | - | S271804 | EDINBURGH ST: BRAZIL AVE | - | F | F | - | F | 21648000 | 21648000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | EDINBURGH ST | 114082 | 114082 | 37.722888884 | -122.430856355 | EDINBURGH ST \ BRAZIL AVE | BRAZIL AVE \ EDINBURGH ST | 1710539427000 | MTA | ALL WAY | EDINBURGH ST intersection | - | X IS BRAZIL | - | - | - | - | - | 91039 | 1393459200000 | -122.43083311 | 37.72278422 | - | 1612483200000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1611563760000 | BRAZIL AVE | - | - | - | - | - | - |
| 73923 | N/A | Point | - | - | - | - | S100073 | CAYUGA AVE: COTTER ST | - | F | F | - | F | 21798000 | 21798000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | COTTER ST | COTTER ST | 114086 | 114086 | 37.72867091 | -122.43574963 | CAYUGA AVE \ COTTER ST | CAYUGA AVE \ COTTER ST | 1720747281000 | middleware_editor | STOP | COTTER ST intersection | - | - | - | - | - | - | - | 91040 | -406454400000 | -122.43574963 | 37.72867091 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373566320000 | CAYUGA AVE | - | - | - | - | - | - |
| 73924 | N/A | Point | - | - | - | - | S104120 | PARIS ST: GENEVA AVE | - | F | F | - | F | 21444000 | 21444000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GENEVA AVE | GENEVA AVE | 114088 | 114088 | 37.715533937 | -122.439450987 | PARIS ST \ GENEVA AVE | PARIS ST \ GENEVA AVE | 1710539427000 | MTA | STOP | GENEVA AVE intersection | - | 0 / 0 | - | - | - | - | - | 91041 | -46051200000 | -122.43943847 | 37.71567256 | - | 658108800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568840000 | PARIS ST | - | - | - | - | - | - |
| 73925 | N/A | Point | 1 | 1 | 800 - 899 | - | S255776 | 800-899 EDINBURG ST | 800-899 EDINBURGH ST | F | F | - | F | 5093000 | 5093000 | - | - | EAST SIDE | - | - | - | - | ITALY AVE | ITALY AVE | 116681 | 116681 | 37.715880287 | -122.435974065 | - | - | 1710539427000 | MTA | NPRK 11AM-1PM FRI STCL | ITALY AVE to AMAZON AVE (800 - 899) | - | SPL 851 | - | - | - | - | - | 91042 | 1585747500000 | -122.4358632 | 37.71613207 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0026 | 18X18 | SUP2 | 2IN IRON POST | IS | 1562057580000 | EDINBURGH ST | 800 - 899 EDINBURGH ST | 800 - 899 EDINBURGH ST | 800 EDINBURGH ST | - | AMAZON AVE | AMAZON AVE |
| 73926 | N/A | Point | 1 | 1 | 600 - 699 | - | S226440 | 600-699 SANSOME ST | 600-699 SANSOME ST | F | F | - | F | 11551000 | 11551000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 116714 | 116714 | 37.796578765 | -122.401774247 | - | - | 1727227616000 | middleware_editor | DO NOT ENTER 7AM-8PM EVERYDAY | WASHINGTON ST to JACKSON ST (600 - 699) | - | 20' SOUTH OF JACKSON ST | - | - | - | - | - | 91043 | 1469521860000 | -122.40176471 | 37.79617277 | - | 1469491200000 | - | D3 | - | OTHER REGULATORY | REG | R5-1(SF).0013 | 30X42 | SUP1 | 2IN IRON POST | IS | 1465479780000 | SANSOME ST | 600 - 699 SANSOME ST | 600 - 699 SANSOME ST | 600 SANSOME ST | - | JACKSON ST | JACKSON ST |
| 73927 | N/A | Point | 1 | 1 | 100 - 199 | - | S202705 | 100-199 BARTLETT ST | 100-199 BARTLETT ST | F | F | - | F | 2743000 | 2743000 | - | - | EAST SIDE | - | - | - | - | 22ND ST | 22ND ST | 116760 | 116760 | 37.75393788 | -122.419674412 | - | - | 1755880571000 | middleware_editor | NPRK 8AM-10AM FRI STCL | 22ND ST to 23RD ST (100 - 199) | - | IFO#195 | - | - | - | - | - | 91044 | 1455061860000 | -122.4197817 | 37.75456772 | - | 1658386800000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0259 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1391010840000 | BARTLETT ST | 100 - 199 BARTLETT ST | 100 - 199 BARTLETT ST | 100 BARTLETT ST | - | 23RD ST | 23RD ST |
| 73928 | N/A | Point | 1 | 1 | 1290 - 1299 | - | S253385 | PNDG GOETTINGEN ST | 1290-1299 GOETTINGEN ST | F | F | - | F | 6246000 | 6246000 | - | - | EAST SIDE | - | - | - | - | WILDE AVE | WILDE AVE | 116801 | 116801 | 37.715071629 | -122.40160847 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | WILDE AVE to ALPHA ST \ WILDE AVE (1290 - 1299) | - | NPL #1387 | - | - | - | - | - | 91045 | 1555512120000 | -122.40210602 | 37.71609751 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | 2IN IRON POST | IS | 1554819420000 | GOETTINGEN ST | PNDG GOETTINGEN ST | 1290 - 1299 GOETTINGEN ST | - | - | ALPHA ST \ WILDE AVE | ALPHA ST \ WILDE AVE |
| 73929 | N/A | Point | - | - | - | - | S108170 | 14TH AVE: RIVERA ST | - | F | F | - | F | 22999000 | 22999000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | RIVERA ST | 14TH AVE | 116872 | 116872 | 37.746964677 | -122.470404502 | 14TH AVE \ RIVERA ST | RIVERA ST \ 14TH AVE | 1710539427000 | MTA | STOP | 14TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 91046 | 289440000000 | -122.47051179 | 37.74701982 | - | 1199923200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570100000 | RIVERA ST | - | - | - | - | - | - |
| 73930 | N/A | Point | - | - | - | - | S273057 | 4TH AVE: FULTON ST | - | F | F | - | F | 27237000 | 27237000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FULTON ST | FULTON ST | 116944 | 116944 | 37.77389525 | -122.46161976 | 4TH AVE \ FULTON ST | 04TH AVE \ FULTON ST | 1710539427000 | MTA | SPEED HUMPS AHEAD | FULTON ST intersection | - | X IS FULTON | - | - | - | - | - | 91047 | 1615987440000 | -122.46161976 | 37.77389525 | - | 1615939200000 | - | D1 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1615208640000 | 04TH AVE | - | - | - | - | - | - |
| 73931 | N/A | Point | - | - | - | - | S233872 | MISSION ST: MARY ST | - | F | F | - | F | 24883000 | 24883000 | - | - | SOUTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 116964 | 116964 | 37.782081262 | -122.407336487 | MARY ST \ MISSION ST | MARY ST \ MISSION ST | 1710539427000 | MTA | TANS 7AM-9AM/4PM-6PM EXC SAT & SUN | MISSION ST intersection | - | INFO #965 | - | - | - | - | - | 91048 | 1202342400000 | -122.40725468 | 37.78211942 | - | 1488153600000 | - | D6 | - | OTHER REGULATORY | REG | R37(SF).0116 | 18X21 | SUP1 | LIGHT POLE | IS | 1487852220000 | MARY ST | - | - | - | - | - | - |
| 73932 | N/A | Point | - | - | - | - | S234968 | 17TH ST: MISSISSIPPI ST | - | T | T | - | F | 23675000 | 23675000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 17TH ST | MISSISSIPPI ST | 116975 | 116975 | 37.765184254 | -122.394958847 | MISSISSIPPI ST \ 17TH ST | 17TH ST \ MISSISSIPPI ST | 1710539427000 | MTA | BIKE WAYFINDING SIGN | MISSISSIPPI ST intersection | 0042 | - | - | - | - | - | - | 91049 | 1536155700000 | -122.39482876 | 37.7652476 | - | - | - | D10 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | UTILITY POLE | IS | 1491555180000 | 17TH ST | - | - | - | - | - | - |
| 73933 | N/A | Point | 1 | 1 | 900 - 999 | - | S135786 | 900-999 DUBOCE AVE | 900-999 DUBOCE AVE | F | F | - | F | 4995000 | 4995000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | ALPINE TER | ALPINE TER | 117054 | 117054 | 37.76902498 | -122.43794737 | - | - | 1749067799000 | middleware_editor | STOP AHEAD (SYM) | ALPINE TER to BUENA VISTA AVE \ BUENA VISTA TER (900 - 999) | - | 40E / OPP #832 (8FT EAST OF ORIGINA..... | - | - | - | - | - | 91050 | 1326787200000 | -122.43794737 | 37.76902498 | - | - | - | D8 | - | OTHER WARNING | WARNING | W3-1.0003 | 36X36 | SUP2 | LIGHT POLE | IS | 1373578740000 | DUBOCE AVE | 900 - 999 DUBOCE AVE | 900 - 999 DUBOCE AVE | 900 DUBOCE AVE | - | BUENA VISTA AVE \ BUENA VISTA TER | BUENA VISTA AVE \ BUENA VISTA TER |
| 73934 | N/A | Point | - | - | - | - | S279374 | HOWARD ST: STEUART ST | - | F | F | - | F | 24548000 | 24548000 | - | - | SOUTH EAST CORNER | - | - | - | - | HOWARD ST \ STEUART LN | HOWARD ST \ STEUART ST | 123797 | 123797 | 37.792012059 | -122.39148755 | STEUART ST \ HOWARD ST \ STEUART LN | STEUART LN \ HOWARD ST \ STEUART ST | 1710539427000 | MTA | STEUART LANE | HOWARD ST \ STEUART ST intersection | - | []<---000 | - | - | - | - | - | 91051 | 1639440000000 | -122.3916458 | 37.7920057 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.2026 | 36X08 | SUP1 | SIGNAL POLE | IS | 1638952020000 | STEUART LN | - | - | - | - | - | - |
| 73935 | N/A | Point | - | - | - | - | S275162 | FULTON ST: 10TH AVE | - | F | F | - | F | 27262000 | 27262000 | - | - | SOUTH WEST CORNER | - | - | - | - | FULTON ST | FULTON ST | 123836 | 123836 | 37.773319378 | -122.468031073 | 10TH AVE \ FULTON ST | 10TH AVE \ FULTON ST | 1745008344000 | middleware_editor | FG 300 UR DELINEATOR (W) | FULTON ST intersection | - | 3 DELINIATORS | - | - | - | - | - | 91052 | 1129618800000 | -122.46802392 | 37.77330383 | - | 1623740400000 | - | D1 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1622631060000 | 10TH AVE | - | - | - | - | - | - |
| 73936 | N/A | Point | - | - | - | - | S275174 | 17TH ST: SOUTH VAN NESS AVE | - | F | F | - | F | 24139000 | 24139000 | - | - | NORTH EAST CORNER | - | - | - | - | SOUTH VAN NESS AVE | 17TH ST | 123837 | 123837 | 37.7635716 | -122.41733241 | 17TH ST \ SOUTH VAN NESS AVE | SOUTH VAN NESS AVE \ 17TH ST | 1749137468000 | middleware_editor | FG 300 UR DELINEATOR (W) | 17TH ST intersection | - | 2 DELINIATORS | - | - | - | - | - | 91053 | 1435734000000 | -122.41733241 | 37.7635716 | - | 1631602800000 | - | D9 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1622640000000 | SOUTH VAN NESS AVE | - | - | - | - | - | - |
| 73937 | N/A | Point | - | - | - | - | S275981 | ALEMANY BLVD: MOUNT VERNON AVE | - | T | T | - | F | 21517000 | 21517000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | ALEMANY BLVD | 123854 | 123854 | 37.716203553 | -122.444631466 | MOUNT VERNON AVE \ ALEMANY BLVD | MOUNT VERNON AVE \ ALEMANY BLVD | 1727900156000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | ALEMANY BLVD intersection | - | - | - | - | - | - | - | 91054 | 1566864000000 | -122.44456307 | 37.71607943 | - | 1626048000000 | - | D11 | - | NO RIGHT TURN | REG | R13A(CA).0001 | 18X30 | SUP2 | SIGNAL POLE | IS | 1625563980000 | MOUNT VERNON AVE | - | - | - | - | - | - |
| 73938 | N/A | Point | - | - | - | - | S275982 | ALEMANY BLVD: MOUNT VERNON AVE | - | T | T | - | F | 21517000 | 21517000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | ALEMANY BLVD | 123855 | 123855 | 37.715958489 | -122.444516131 | MOUNT VERNON AVE \ ALEMANY BLVD | MOUNT VERNON AVE \ ALEMANY BLVD | 1727919497000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | ALEMANY BLVD intersection | - | - | - | - | - | - | - | 91055 | 1566864000000 | -122.44456307 | 37.71607943 | - | 1626048000000 | - | D11 | - | NO RIGHT TURN | REG | R13A(CA).0001 | 18X30 | SUP2 | SIGNAL POLE | IS | 1625564160000 | MOUNT VERNON AVE | - | - | - | - | - | - |
| 73939 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S274509 | 2500-2599 CALIFORNIA ST | 2500-2599 CALIFORNIA ST | T | T | - | F | 3559000 | 3559000 | - | - | NORTH SIDE | - | - | - | - | STEINER ST | STEINER ST | 123875 | 123875 | 37.7885924 | -122.43630738 | - | - | 1755277058000 | middleware_editor | LANE REDUCTION (SYM) RIGHT | STEINER ST to PIERCE ST (2500 - 2599) | - | IFO # 2530 CALIFORNIA | - | - | - | - | - | 91056 | 1621023120000 | -122.43630738 | 37.7885924 | - | - | - | D2 | - | OTHER WARNING | WARNING | W4-2.0003 | 30X30 | SUP1 | MUNI POLE | IS | 1620227100000 | CALIFORNIA ST | 2500 - 2599 CALIFORNIA ST | 2500 - 2599 CALIFORNIA ST | 2500 CALIFORNIA ST | - | PIERCE ST | PIERCE ST |
| 73940 | N/A | Point | 1 | 1 | 400 - 499 | - | S274534 | 400-499 DE HARO ST | 400-499 DE HARO ST | F | F | - | F | 4631000 | 4631000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 123878 | 123878 | 37.76420035 | -122.40153897 | - | - | 1710539427000 | MTA | PAY TO PARK EXCEPT "X" PERMITS | 17TH ST to MARIPOSA ST (400 - 499) | - | 50' SOUTH OF 17TH ST | - | - | - | - | - | 91057 | 1622040300000 | -122.40153897 | 37.76420035 | - | - | - | D10 | - | PARKING:RPP | GUIDE | G-P(SF).0151 | 18X18 | SUP1 | 2IN IRON POST | IS | 1620298320000 | DE HARO ST | 400 - 499 DE HARO ST | 400 - 499 DE HARO ST | 400 DE HARO ST | - | MARIPOSA ST | MARIPOSA ST |
| 73941 | N/A | Point | 1 | 1 | 400 - 499 | - | S274535 | 400-499 DE HARO ST | 400-499 DE HARO ST | F | F | - | F | 4631000 | 4631000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 123879 | 123879 | 37.76420035 | -122.40153897 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM TUE STCL | 17TH ST to MARIPOSA ST (400 - 499) | - | 180' NORTH OF MARIPOSA ST | - | - | - | - | - | 91058 | 1622041620000 | -122.40153897 | 37.76420035 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0056 | 18X18 | SUP1 | 2IN IRON POST | IS | 1620298380000 | DE HARO ST | 400 - 499 DE HARO ST | 400 - 499 DE HARO ST | 400 DE HARO ST | - | MARIPOSA ST | MARIPOSA ST |
| 73942 | N/A | Point | 1 | 1 | 400 - 499 | - | S274536 | 400-499 DE HARO ST | 400-499 DE HARO ST | F | F | - | F | 4631000 | 4631000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 123880 | 123880 | 37.76420035 | -122.40153897 | - | - | 1710539427000 | MTA | PAY TO PARK EXCEPT "X" PERMITS | 17TH ST to MARIPOSA ST (400 - 499) | - | 180' NORTH OF MARIPOSA ST | - | - | - | - | - | 91059 | 1622038440000 | -122.40153897 | 37.76420035 | - | - | - | D10 | - | PARKING:RPP | GUIDE | G-P(SF).0151 | 18X18 | SUP1 | 2IN IRON POST | IS | 1620298380000 | DE HARO ST | 400 - 499 DE HARO ST | 400 - 499 DE HARO ST | 400 DE HARO ST | - | MARIPOSA ST | MARIPOSA ST |
| 73943 | N/A | Point | 1 | 1 | 400 - 499 | - | S274537 | 400-499 DE HARO ST | 400-499 DE HARO ST | F | F | - | F | 4631000 | 4631000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 123881 | 123881 | 37.76420035 | -122.40153897 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM TUE STCL | 17TH ST to MARIPOSA ST (400 - 499) | - | 60' NORTH OF MARIPOSA ST | - | - | - | - | - | 91060 | - | -122.40153897 | 37.76420035 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0056 | 18X18 | SUP1 | 2IN IRON POST | IS | 1620298440000 | DE HARO ST | 400 - 499 DE HARO ST | 400 - 499 DE HARO ST | 400 DE HARO ST | - | MARIPOSA ST | MARIPOSA ST |
| 73944 | N/A | Point | 1 | 1 | 400 - 499 | - | S274538 | 400-499 DE HARO ST | 400-499 DE HARO ST | F | F | - | F | 4631000 | 4631000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 123882 | 123882 | 37.76420035 | -122.40153897 | - | - | 1710539427000 | MTA | PAY TO PARK EXCEPT "X" PERMITS | 17TH ST to MARIPOSA ST (400 - 499) | - | 60' NORTH OF MARIPOSA ST | - | - | - | - | - | 91061 | 1622042100000 | -122.40153897 | 37.76420035 | - | - | - | D10 | - | PARKING:RPP | GUIDE | G-P(SF).0151 | 18X18 | SUP1 | 2IN IRON POST | IS | 1620298500000 | DE HARO ST | 400 - 499 DE HARO ST | 400 - 499 DE HARO ST | 400 DE HARO ST | - | MARIPOSA ST | MARIPOSA ST |
| 73945 | N/A | Point | - | - | - | - | S274604 | QUINTARA ST: 24TH AVE | - | F | F | - | F | 23269000 | 23269000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | QUINTARA ST | 24TH AVE | 123883 | 123883 | 37.74840903 | -122.48144024 | 24TH AVE \ QUINTARA ST | QUINTARA ST \ 24TH AVE | 1735579688000 | middleware_editor | ROAD CLOSED (BLACK /WHITE) | 24TH AVE intersection | - | MIDDLE OF STREET | - | - | - | - | - | 91062 | 1228867200000 | -122.48144024 | 37.74840903 | - | 1620864000000 | - | D4 | - | OTHER WARNING | WARNING | W(SF).0083 | 30X24 | SUP2 | TYPE III BARRICADE | IS | 1620637560000 | QUINTARA ST | - | - | - | - | - | - |
| 73946 | N/A | Point | 1 | 1 | 741 - 799 | - | S274787 | 741-799 UNIVERSITY ST | 741-799 UNIVERSITY ST | F | F | - | F | 12888000 | 12888000 | - | - | WEST SIDE | - | - | - | - | UNIVERSITY ST | UNIVERSITY ST | 123884 | 123884 | 37.72062275 | -122.41162856 | - | - | 1710539427000 | MTA | NPRK 12NN-3PM WED STCL | UNIVERSITY ST to OLMSTEAD ST (741 - 799) | - | OPP #751 | - | - | - | - | - | 91063 | 1515715200000 | -122.41162856 | 37.72062275 | - | 1576454400000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0091 | 18X18 | SUP2 | 2IN IRON POST | IS | 1621342980000 | UNIVERSITY ST | 741 - 799 UNIVERSITY ST | 741 - 799 UNIVERSITY ST | 741 UNIVERSITY ST | - | OLMSTEAD ST | OLMSTEAD ST |
| 73947 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S276421 | 1500-1599 FULTON ST | 1500-1599 FULTON ST | F | F | - | F | 5895000 | 5893000 | - | - | NORTH SIDE | - | - | - | - | CENTRAL AVE | BAKER ST | 123885 | 123885 | 37.77633054 | -122.44231039 | - | - | 1726880748000 | middleware_editor | BIKE RACK | BAKER ST to LYON ST (1500 - 1599) | 380100 | 142' E OF WPL 1750/3' IN FROM CURB | - | - | - | - | - | 91064 | 1628682960000 | -122.44231039 | 37.77633054 | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1626961860000 | FULTON ST | 1700 - 1799 FULTON ST | 1500 - 1599 FULTON ST | 1500 FULTON ST | - | MASONIC AVE | LYON ST |
| 73948 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S276422 | 1500-1599 FULTON ST | 1500-1599 FULTON ST | F | F | - | F | 5895000 | 5893000 | - | - | NORTH SIDE | - | - | - | - | CENTRAL AVE | BAKER ST | 123886 | 123886 | 37.77633054 | -122.44231039 | - | - | 1726880748000 | middleware_editor | BIKE RACK | BAKER ST to LYON ST (1500 - 1599) | 380100 | 73' E OF WPL 1750/3' IN FROM CURB | - | - | - | - | - | 91065 | 1628682900000 | -122.44231039 | 37.77633054 | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1626961860000 | FULTON ST | 1700 - 1799 FULTON ST | 1500 - 1599 FULTON ST | 1500 FULTON ST | - | MASONIC AVE | LYON ST |
| 73949 | N/A | Point | - | - | - | - | S279060 | SAN BRUNO AVE: BACON ST | - | T | T | - | F | 33647000 | 33647000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SAN BRUNO AVE | BACON ST | 123959 | 123959 | 37.72753432 | -122.403649762 | BACON ST \ SAN BRUNO AVE | SAN BRUNO AVE \ BACON ST | 1710539427000 | MTA | SPEED LIMIT 20 | BACON ST intersection | - | ABOVE STREET NAME | - | - | - | - | - | 91066 | 1170288000000 | -122.40359289 | 37.72763413 | - | 1423180800000 | - | D9 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | LIGHT POLE | IS | 1637575620000 | SAN BRUNO AVE | - | - | - | - | - | - |
| 73950 | N/A | Point | - | - | - | - | S275601 | DE LONG ST: RICE ST | - | F | F | - | F | 22466000 | 22466000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | DE LONG ST | DE LONG ST | 123971 | 123971 | 37.70966594 | -122.45912596 | RICE ST \ DE LONG ST | RICE ST \ DE LONG ST | 1738796807000 | middleware_editor | SPEED HUMP | DE LONG ST intersection | - | WPL 44 | - | - | - | - | - | 91067 | 1223337600000 | -122.45912596 | 37.70966594 | - | 1624492800000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | UTILITY POLE | IS | 1624360980000 | RICE 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.