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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77776 | N/A | Point | - | - | - | - | S235611 | ULLOA ST: LAGUNA HONDA BLVD \ | - | F | F | - | F | 22445000 | 22445000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAGUNA HONDA BLVD \ ULLOA ST | LAGUNA HONDA BLVD \ ULLOA ST | 124468 | 124468 | 37.74348245 | -122.45590515 | ROCKAWAY AVE \ LAGUNA HONDA BLVD \ ULLOA ST | ROCKAWAY AVE \ LAGUNA HONDA BLVD \ ULLOA ST | 1742423237000 | middleware_editor | ALL WAY | LAGUNA HONDA BLVD \ ULLOA ST intersection | - | - | - | - | - | - | - | 94895 | 1494105720000 | -122.45590515 | 37.74348245 | - | 1494054000000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1493125080000 | ROCKAWAY AVE | - | - | - | - | - | - |
| 77777 | N/A | Point | 1 | 1 | 0 - 0 | - | S100760 | PNDG VIDAL DR | 0-0 VIDAL DR | F | F | - | F | 13005000 | 13005000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | ACEVEDO AVE | ACEVEDO AVE | 124469 | 124469 | 37.71920408 | -122.48463547 | - | - | 1710539427000 | MTA | ONE WAY (RA) | ACEVEDO AVE to HIGUERA AVE (0 - 0) | - | S LINE / 0 | - | - | - | - | - | 94896 | -402710400000 | -122.48463547 | 37.71920408 | - | - | - | D7 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | UNKNOWN | IS | 1373566560000 | VIDAL DR | PNDG VIDAL DR | 0 - 0 VIDAL DR | - | - | HIGUERA AVE | HIGUERA AVE |
| 77778 | N/A | Point | - | 1 | 800 - 899 | - | S113258 | PNDG MARIPOSA ST | 800-899 MARIPOSA ST | F | F | - | F | 8716000 | 8716000 | - | - | NORTH SIDE | - | - | - | - | INDIANA ST | INDIANA ST | 124470 | 124470 | 37.7641197 | -122.39213331 | - | - | 1710539427000 | MTA | TANS 1PM-6PM/8PM-12MN ON DATE BELOW (CALENDAR) | INDIANA ST to I-280 N OFF RAMP \ OWENS ST (800 - 899) | - | OPP C-LINE | - | - | - | - | - | 94897 | 985651200000 | -122.39213331 | 37.7641197 | - | - | - | D10 | - | OTHER REGULATORY | REG | R37(SF).0081 | 18X30 | SUP1 | 2IN IRON POST | IS | 1373571660000 | MARIPOSA ST | PNDG MARIPOSA ST | 800 - 899 MARIPOSA ST | - | - | I-280 N OFF RAMP \ OWENS ST | I-280 N OFF RAMP \ OWENS ST |
| 77779 | N/A | Point | - | 1 | 1951 - 1969 | - | S110358 | PNDG SELBY ST | 1951-1969 JERROLD AVE | F | F | - | F | 7500102 | 7500102 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | RANKIN ST | RANKIN ST | 124471 | 124471 | 37.7423943 | -122.39603737 | - | - | 1710539427000 | MTA | STOP | RANKIN ST to SELBY ST (1951 - 1969) -- SOUTH -- | - | N LINE / 00 | - | - | - | - | - | 94898 | 625795200000 | -122.39603737 | 37.7423943 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570760000 | JERROLD AVE | PNDG SELBY ST | 1951 - 1969 JERROLD AVE | - | - | SELBY ST | SELBY ST |
| 77780 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S120032 | PNDG LA SALLE AVE | 1200-1299 LA SALLE AVE | F | F | - | F | 7928000 | 7928000 | - | - | NORTH SIDE | - | - | - | - | OSCEOLA LN | OSCEOLA LN | 124472 | 124472 | 37.73202015 | -122.38284329 | - | - | 1710539427000 | MTA | TANSAT | OSCEOLA LN to OSCEOLA LN (1200 - 1299) | - | 65'EAST OF OSCEOLA (WEST EXIT) | - | - | - | - | - | 94899 | 1103587200000 | -122.38284329 | 37.73202015 | - | - | - | D10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373573820000 | LA SALLE AVE | PNDG LA SALLE AVE | 1200 - 1299 LA SALLE AVE | - | - | OSCEOLA LN | OSCEOLA LN |
| 77781 | N/A | Point | 1 | 1 | 100 - 199 | - | S148608 | 100-199 VALDEZ AVE | 100-199 VALDEZ AVE | F | F | - | F | 13048000 | 13048000 | - | - | EAST SIDE | - | - | - | - | MONTECITO AVE | MONTECITO AVE | 124859 | 124859 | 37.73074533 | -122.45532244 | - | - | 1724180681000 | middleware_editor | NPRK 1PM-3PM 2ND & 4TH MON OF MONTH STCL | MONTECITO AVE to MONTEREY BLVD (100 - 199) | - | 100 VALDEZ | - | - | - | - | - | 94900 | 1224806400000 | -122.45532244 | 37.73074533 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0099 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375728960000 | VALDEZ AVE | 100 - 199 VALDEZ AVE | 100 - 199 VALDEZ AVE | 100 VALDEZ AVE | - | MONTEREY BLVD | MONTEREY BLVD |
| 77782 | N/A | Point | 1 | 1 | 100 - 199 | - | S148829 | 100-199 MEADOWBROOK DR | 100-199 MEADOWBROOK DR | F | F | - | F | 8941000 | 8941000 | - | - | WEST SIDE | - | - | - | - | OCEAN AVE | OCEAN AVE | 124860 | 124860 | 37.73166444 | -122.48446937 | - | - | 1743708740000 | middleware_editor | NPRK 11AM-1PM 2ND & 4TH TUE OF MONTH STCL | OCEAN AVE to EUCALYPTUS DR (100 - 199) | - | NPL #165 | - | - | - | - | - | 94901 | 1225090800000 | -122.48446937 | 37.73166444 | - | 1706125380000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0024 | 18X18 | SUP2 | LIGHT POLE | IS | 1375729020000 | MEADOWBROOK DR | 100 - 199 MEADOWBROOK DR | 100 - 199 MEADOWBROOK DR | 100 MEADOWBROOK DR | - | EUCALYPTUS DR | EUCALYPTUS DR |
| 77783 | N/A | Point | 1 | 1 | 1 - 99 | - | S148849 | 1-99 SAN FERNANDO WAY | 1-99 SAN FERNANDO WAY | F | F | - | F | 11412000 | 11412000 | - | - | WEST SIDE | - | - | - | - | PORTOLA DR | PORTOLA DR | 124861 | 124861 | 37.73545628 | -122.46974423 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM 2ND & 4TH TUE OF MONTH STCL | PORTOLA DR to SAINT FRANCIS BLVD (1 - 99) | - | 80 SAN FERNANDO | - | - | - | - | - | 94902 | 1225065600000 | -122.46974423 | 37.73545628 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0074 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1375729080000 | SAN FERNANDO WAY | 1 - 99 SAN FERNANDO WAY | 1 - 99 SAN FERNANDO WAY | 1 SAN FERNANDO WAY | - | SAINT FRANCIS BLVD | SAINT FRANCIS BLVD |
| 77784 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S147565 | 1700-1799 ULLOA ST | 1700-1799 ULLOA ST | F | F | - | F | 12795000 | 12795000 | - | - | SOUTH SIDE | - | - | - | - | 18TH AVE | 18TH AVE | 124862 | 124862 | 37.74121046 | -122.47501701 | - | - | 1732126225000 | middleware_editor | NPRK 1PM-3PM 1ST & 3RD TUE OF MONTH STCL | 18TH AVE to 19TH AVE (1700 - 1799) | - | 1715 ULLOA | - | - | - | - | - | 94903 | 1224201600000 | -122.47501701 | 37.74121046 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0096 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375728480000 | ULLOA ST | 1700 - 1799 ULLOA ST | 1700 - 1799 ULLOA ST | 1700 ULLOA ST | - | 19TH AVE | 19TH AVE |
| 77785 | N/A | Point | 1 | 1 | 100 - 199 | - | S149469 | 100-199 SAN RAMON WAY | 100-199 SAN RAMON WAY | F | F | - | F | 11506000 | 11506000 | - | - | SOUTH SIDE | - | - | - | - | PLYMOUTH AVE \ SOUTHWOOD DR | PLYMOUTH AVE \ SOUTHWOOD DR | 124863 | 124863 | 37.72600557 | -122.45694972 | - | - | 1710539427000 | MTA | NPRK 1PM-3PM 2ND & 4TH THUR OF MONTH STCL | PLYMOUTH AVE \ SOUTHWOOD DR to EASTWOOD DR (100 - 199) | - | 25 FEET EAST OF EASTWOOD | - | - | - | - | - | 94904 | 1225324800000 | -122.45694972 | 37.72600557 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0100 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375729320000 | SAN RAMON WAY | 100 - 199 SAN RAMON WAY | 100 - 199 SAN RAMON WAY | 100 SAN RAMON WAY | - | EASTWOOD DR | EASTWOOD DR |
| 77786 | N/A | Point | 1 | 1 | 1 - 99 | - | S144044 | 1-99 DAY ST | 1-99 DAY ST | F | F | - | F | 4618000 | 4618000 | - | - | SOUTH SIDE | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 124922 | 124922 | 37.74307438 | -122.42367596 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 2ND & 4TH FRI OF MONTH STCL | SAN JOSE AVE to DOLORES ST (1 - 99) | - | 45 DAY | - | - | - | - | - | 94905 | 1222214400000 | -122.42367596 | 37.74307438 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0254 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375726980000 | DAY ST | 1 - 99 DAY ST | 1 - 99 DAY ST | 1 DAY ST | - | DOLORES ST | DOLORES ST |
| 77787 | N/A | Point | 1 | 1 | 1 - 12 | - | S145350 | 1-12 COLERIDGE ST | 1-12 COLERIDGE ST | F | F | - | F | 4252000 | 4252000 | - | - | WEST SIDE | - | - | - | - | COSO AVE | COSO AVE | 124923 | 124923 | 37.74590641 | -122.41828066 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 2ND & 4TH FRI OF MONTH STCL | COSO AVE to POWERS AVE (1 - 12) | - | 21 FEET NORTH OF POWERS | - | - | - | - | - | 94906 | 1222819200000 | -122.41828066 | 37.74590641 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0254 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375727580000 | COLERIDGE ST | 1 - 12 COLERIDGE ST | 1 - 12 COLERIDGE ST | 1 COLERIDGE ST | - | POWERS AVE | POWERS AVE |
| 77788 | N/A | Point | 1 | 1 | 500 - 599 | - | S145927 | 500-599 MOUNT VERNON AVE | 500-599 MOUNT VERNON AVE | F | F | - | F | 9432000 | 9432000 | - | - | NORTH SIDE | - | - | - | - | SAN MIGUEL ST | SAN MIGUEL ST | 124925 | 124925 | 37.71885746 | -122.44957935 | - | - | 1710539427000 | MTA | NPRK 1PM-3PM 1ST & 3RD MON OF MONTH STCL | SAN MIGUEL ST to TARA ST (500 - 599) | - | 67 FEET EAST OF TARA | - | - | - | - | - | 94907 | 1223337600000 | -122.44957935 | 37.71885746 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0094 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375727820000 | MOUNT VERNON AVE | 500 - 599 MOUNT VERNON AVE | 500 - 599 MOUNT VERNON AVE | 500 MOUNT VERNON AVE | - | TARA ST | TARA ST |
| 77789 | N/A | Point | 1 | 1 | 1 - 99 | - | S138168 | 1-99 MONTGOMERY ST | 1-99 MONTGOMERY ST | F | F | - | F | 9297000 | 9297000 | - | - | WEST SIDE | - | - | - | - | POST ST | POST ST | 124982 | 124982 | 37.78957088 | -122.40209356 | - | - | 1710539427000 | MTA | BIKE RACK | POST ST to SUTTER ST (1 - 99) | - | 45S / OF SUTTER/IFO# 45 (24HR. FITNESS) | - | - | - | - | - | 94908 | 1366848000000 | -122.40209356 | 37.78957088 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | 2IN FLANGE POST | IS | 1373579460000 | MONTGOMERY ST | 1 - 99 MONTGOMERY ST | 1 - 99 MONTGOMERY ST | 1 MONTGOMERY ST | - | SUTTER ST | SUTTER ST |
| 77790 | N/A | Point | 1 | 1 | 200 - 299 | - | S137309 | 200-299 BERRY ST | 200-299 BERRY ST | F | F | - | F | 2954000 | 2954000 | - | - | NORTH SIDE | - | - | - | - | 4TH ST | 04TH ST | 124983 | 124983 | 37.77490909 | -122.39446589 | - | - | 1710539427000 | MTA | NPRK 6PM-11PM MON-FRI | 04TH ST to 05TH ST (200 - 299) | - | 56' WEST | - | - | - | - | - | 94909 | 1347840000000 | -122.39446589 | 37.77490909 | - | - | - | D6 | - | PARKING | REG | R30(CA).0020 | 12X18 | SUP1 | 2IN IRON POST | IS | 1373579220000 | BERRY ST | 200 - 299 BERRY ST | 200 - 299 BERRY ST | 200 BERRY ST | - | 05TH ST | 05TH ST |
| 77791 | N/A | Point | 1 | 1 | 600 - 665 | - | S141796 | 600-665 ARGUELLO BLVD | 600-665 ARGUELLO BLVD | F | F | - | F | 2424000 | 2424000 | - | - | WEST SIDE | - | - | - | - | ANZA ST | ANZA ST | 124984 | 124984 | 37.77867076 | -122.45868476 | - | - | 1716491618000 | middleware_editor | 30 MIN PRK 7AM-6PM EXC SAT & SUN | ANZA ST to EDWARD ST (600 - 665) | - | 653 ARGUELLO | - | - | - | - | - | 94910 | 1220832000000 | -122.45868476 | 37.77867076 | - | - | - | D1 | - | PARKING | REG | R32(CA).0095 | 18X18 | SUP2 | MUNI POLE | IS | 1375725960000 | ARGUELLO BLVD | 600 - 665 ARGUELLO BLVD | 600 - 665 ARGUELLO BLVD | 600 ARGUELLO BLVD | - | EDWARD ST | EDWARD ST |
| 77792 | N/A | Point | 1 | 1 | 1 - 99 | - | S142348 | 1-99 HEATHER AVE | 1-99 HEATHER AVE | F | F | - | F | 6868000 | 6868000 | - | - | EAST SIDE | - | - | - | - | MAYFAIR DR | MAYFAIR DR | 124985 | 124985 | 37.78491425 | -122.45285501 | - | - | 1754324478000 | middleware_editor | NPRK 8AM-10AM 1ST & 3RD WED OF MONTH STCL | MAYFAIR DR to EUCLID AVE (1 - 99) | - | 72 HEATHER | - | - | - | - | - | 94911 | 1220857200000 | -122.45285501 | 37.78491425 | - | - | - | D2 | - | STREET CLEANING | REG | R30B(CA).0251 | 18X18 | SUP1 | LIGHT POLE | IS | 1375726260000 | HEATHER AVE | 1 - 99 HEATHER AVE | 1 - 99 HEATHER AVE | 1 HEATHER AVE | - | EUCLID AVE | EUCLID AVE |
| 77793 | N/A | Point | 1 | 1 | 100 - 199 | - | S143417 | 100-199 29TH ST | 100-199 29TH ST | F | F | - | F | 1630000 | 1630000 | - | - | SOUTH SIDE | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 124986 | 124986 | 37.74389023 | -122.42352715 | - | - | 1745939867000 | middleware_editor | NPRK 8AM-10AM 2ND & 4TH TUE OF MONTH STCL | SAN JOSE AVE to DOLORES ST (100 - 199) | - | 167 29TH ST | - | - | - | - | - | 94912 | 1222239600000 | -122.42352715 | 37.74389023 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0257 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375726740000 | 29TH ST | 100 - 199 29TH ST | 100 - 199 29TH ST | 100 29TH ST | - | DOLORES ST | DOLORES ST |
| 77794 | N/A | Point | 1 | 1 | 3500 - 3599 | - | S142024 | 3500-3599 CLAY ST | 3500-3599 CLAY ST | F | F | - | F | 4122000 | 4122000 | - | - | SOUTH SIDE | - | - | - | - | LAUREL ST | LAUREL ST | 124987 | 124987 | 37.78854231 | -122.45130334 | - | - | 1735281302000 | middleware_editor | NPRK 11AM-1PM 1ST & 3RD TUE OF MONTH STCL | LAUREL ST to LOCUST ST (3500 - 3599) | - | 3535 CLAY | - | - | - | - | - | 94913 | 1220572800000 | -122.45130334 | 37.78854231 | - | 1734693000000 | - | D2 | - | STREET CLEANING | REG | R30B(CA).0019 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1375726080000 | CLAY ST | 3500 - 3599 CLAY ST | 3500 - 3599 CLAY ST | 3500 CLAY ST | - | LOCUST ST | LOCUST ST |
| 77795 | N/A | Point | 1 | 1 | 300 - 399 | - | S116487 | 300-399 RHODE ISLAND ST | 300-399 RHODE ISLAND ST | F | F | - | F | 10995000 | 10995000 | - | - | WEST SIDE | - | - | - | - | 16TH ST | 16TH ST | 125192 | 125192 | 37.76542783 | -122.40262418 | - | - | 1710539427000 | MTA | NPPZ 6AM-6PM EVERYDAY | 16TH ST to 17TH ST (300 - 399) | - | 195S / 195'SOUTH @ PM | - | - | - | - | - | 94914 | 1050278400000 | -122.40262418 | 37.76542783 | - | - | - | D10 | - | OTHER REGULATORY | REG | R30(SF).0156 | 12X18 | SUP1 | 2IN IRON POST | IS | 1373572680000 | RHODE ISLAND ST | 300 - 399 RHODE ISLAND ST | 300 - 399 RHODE ISLAND ST | 300 RHODE ISLAND ST | - | 17TH ST | 17TH ST |
| 77796 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S120375 | 1500-1599 GALVEZ AVE | 1500-1599 GALVEZ AVE | F | F | - | F | 5985000 | 5985000 | - | - | NORTH SIDE | - | - | - | - | MENDELL ST | MENDELL ST | 125193 | 125193 | 37.74014036 | -122.38677104 | - | - | 1753821028000 | middleware_editor | PARK AT 90 DEGREES (SYM) | MENDELL ST to NEWHALL ST (1500 - 1599) | - | 100'EAST OF NEWHALL | - | - | - | - | - | 94915 | 1108627200000 | -122.38677104 | 37.74014036 | - | - | - | D10 | - | PARKING: PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373573940000 | GALVEZ AVE | 1500 - 1599 GALVEZ AVE | 1500 - 1599 GALVEZ AVE | 1500 GALVEZ AVE | - | NEWHALL ST | NEWHALL ST |
| 77797 | N/A | Point | 1 | 1 | 2000 - 2099 | DOWN ARROW | S118522 | 2000-2099 34TH AVE | 2000-2099 34TH AVE | F | F | - | F | 1754000 | 1754000 | - | - | WEST SIDE | - | - | - | - | PACHECO ST | PACHECO ST | 125194 | 125194 | 37.74886811 | -122.49222042 | - | - | 1711674257000 | middleware_editor | NPPZ 8AM-9AM/2PM-3PM SCHL DAYS | PACHECO ST to QUINTARA ST (2000 - 2099) | - | OPP.#2050 | - | - | - | - | - | 94916 | 1079049600000 | -122.49222042 | 37.74886811 | - | - | - | D4 | - | OTHER REGULATORY | REG | R30(SF).0429 | 12X18 | SUP2 | 2IN IRON POST | IS | 1373573340000 | 34TH AVE | 2000 - 2099 34TH AVE | 2000 - 2099 34TH AVE | 2000 34TH AVE | - | QUINTARA ST | QUINTARA ST |
| 77798 | N/A | Point | 1 | 1 | 6200 - 6335 | - | S122366 | 6200-6335 FULTON ST | 6200-6335 FULTON ST | F | F | - | F | 5945000 | 5945000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 38TH AVE | 38TH AVE | 125195 | 125195 | 37.77190981 | -122.49864845 | - | - | 1726083380000 | middleware_editor | PEDESTRIAN (SYM) XING/(45 LA-DN) | 38TH AVE to 39TH AVE (6200 - 6335) | - | OPP NEC | - | - | - | - | - | 94917 | 1136419200000 | -122.49864845 | 37.77190981 | - | - | - | D1 | - | PEDESTRIAN(LA DN) | WARNING | W11-2+SW44(CA).01 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373574540000 | FULTON ST | 6200 - 6335 FULTON ST | 6200 - 6335 FULTON ST | 6200 FULTON ST | - | 39TH AVE | 39TH AVE |
| 77799 | N/A | Point | 1 | 1 | 900 - 999 | - | S116518 | 900-999 STANYAN ST | 900-999 STANYAN ST | F | F | - | F | 12094000 | 12094000 | - | - | WEST SIDE | - | - | - | - | FREDERICK ST | FREDERICK ST | 125196 | 125196 | 37.76590847 | -122.45285273 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM FRI STCL | FREDERICK ST to CARL ST (900 - 999) | - | 25' NORTH OF CARL | - | - | - | - | - | 94918 | 1050364800000 | -122.45285273 | 37.76590847 | - | 1411430400000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0235 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1373572680000 | STANYAN ST | 900 - 999 STANYAN ST | 900 - 999 STANYAN ST | 900 STANYAN ST | - | CARL ST | CARL ST |
| 77800 | N/A | Point | - | - | - | - | S126028 | WASHINGTON ST: DIVISADERO ST | - | F | F | - | F | 26851000 | 26851000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DIVISADERO ST | WASHINGTON ST | 125199 | 125199 | 37.79075546 | -122.44098438 | WASHINGTON ST \ DIVISADERO ST | DIVISADERO ST \ WASHINGTON ST | 1710539427000 | MTA | ALL WAY | WASHINGTON ST intersection | - | - | - | - | - | - | - | 94919 | 1163376000000 | -122.44098438 | 37.79075546 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575680000 | DIVISADERO ST | - | - | - | - | - | - |
| 77801 | N/A | Point | - | - | - | - | S130084 | STOCKTON ST: GEARY ST | - | F | F | - | F | 24901000 | 24901000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GEARY ST | STOCKTON ST | 125200 | 125200 | 37.78756803 | -122.40658988 | STOCKTON ST \ GEARY ST | GEARY ST \ STOCKTON ST | 1733182953000 | middleware_editor | RIGHT LANE BUSES AND RIGHT TURNS ONLY AT ALL TIMES | STOCKTON ST intersection | - | - | - | - | - | - | - | 94920 | 1232496000000 | -122.40658988 | 37.78756803 | - | - | 1726655100000 | D3 | - | TRANSIT ONLY(RIGHT LANE) | REG | SR60-6(CA).0003 | 30X42 | SUP1 | LIGHT POLE | RETD | 1373576940000 | GEARY ST | - | - | - | - | - | - |
| 77802 | N/A | Point | - | - | - | - | S128055 | NOE ST: 14TH ST | - | F | F | - | F | 25982000 | 25982000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | NOE ST | 14TH ST | 125201 | 125201 | 37.76746158 | -122.43340826 | 14TH ST \ NOE ST | NOE ST \ 14TH ST | 1715994537000 | middleware_editor | SPEED LIMIT 25 | 14TH ST intersection | - | - | - | - | - | - | - | 94921 | 1191974400000 | -122.43340826 | 37.76746158 | - | - | - | D8 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP2 | LIGHT POLE | IS | 1373576340000 | NOE ST | - | - | - | - | - | - |
| 77803 | N/A | Point | - | - | - | - | S147044 | 174-199 VASQUEZ AVE | - | F | F | - | F | 13186201 | - | - | - | WEST SIDE | - | - | - | - | GARCIA AVE | - | 125205 | 125205 | 37.7435544859955 | -122.461520751661 | - | - | 1753740998000 | middleware_editor | NPRK 9AM-11AM 1ST & 3RD MON OF MONTH STCL | - | - | SPL 220 | - | - | - | - | - | 94922 | 1753726260000 | -122.461031 | 37.74346729 | - | - | - | D7 | - | STREET CLEANING | REG | R30(CA).0036 | 18X18 | SUP2 | LIGHT POLE | IS | 1375728300000 | - | 200 - 298 VASQUEZ AVE | - | - | - | KENSINGTON WAY | - |
| 77804 | N/A | Point | - | - | - | - | S252705 | GENEVA AVE: ESQUINA DR | - | F | F | - | F | 20427000 | 20427000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | ESQUINA DR | GENEVA AVE | 125276 | 125276 | 37.708795464 | -122.421809882 | GENEVA AVE \ ESQUINA DR | ESQUINA DR \ GENEVA AVE | 1710539427000 | MTA | FG 300 EFX DELINEATOR (Y) | GENEVA AVE intersection | - | W-LINE OF INTERECT/ WEST SIDE OF ISLAND | - | - | - | - | - | 94923 | 1553598300000 | -122.42161733 | 37.70874305 | - | - | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1553247780000 | ESQUINA DR | - | - | - | - | - | - |
| 77805 | N/A | Point | 1 | 1 | 2900 - 2999 | - | S133716 | 2900-2999 RIVERA ST | 2900-2999 RIVERA ST | F | F | - | F | 11073000 | 11073000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 39TH AVE | 39TH AVE | 125372 | 125372 | 37.74580953 | -122.49791722 | - | - | 1743706193000 | middleware_editor | SCHOOL (SYM)/SCHOOL | 39TH AVE to 40TH AVE (2900 - 2999) | 241124 | EPL#2937 | - | - | - | - | - | 94924 | 1225350000000 | -122.49791722 | 37.74580953 | - | 1689698040000 | - | D4 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | LIGHT POLE | IS | 1373578080000 | RIVERA ST | 2900 - 2999 RIVERA ST | 2900 - 2999 RIVERA ST | 2900 RIVERA ST | - | 40TH AVE | 40TH AVE |
| 77806 | N/A | Point | - | - | - | - | S131732 | 17TH AVE: IRVING ST | - | F | F | - | F | 27360000 | 27360000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 17TH AVE | 17TH AVE | 125377 | 125377 | 37.763554011 | -122.474909194 | IRVING ST \ 17TH AVE | IRVING ST \ 17TH AVE | 1710539427000 | MTA | ALL WAY | 17TH AVE intersection | - | - | - | - | - | - | - | 94925 | 1258502400000 | -122.47498519 | 37.76365579 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373577480000 | IRVING ST | - | - | - | - | - | - |
| 77807 | N/A | Point | - | - | - | - | S231531 | 23RD AVE: CALIFORNIA ST | - | F | F | - | F | 27647000 | 27647000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 23RD AVE | CALIFORNIA ST | 125847 | 125847 | 37.78397927 | -122.48287005 | CALIFORNIA ST \ 23RD AVE | 23RD AVE \ CALIFORNIA ST | 1715390905000 | middleware_editor | ALL WAY | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 94926 | -385430400000 | -122.48287005 | 37.78397927 | - | 1484784000000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481023620000 | 23RD AVE | - | - | - | - | - | - |
| 77808 | N/A | Point | - | - | - | - | S231153 | DIAMOND ST: 18TH ST | - | F | F | - | F | 25818000 | 25818000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DIAMOND ST | DIAMOND ST | 125848 | 125848 | 37.76075811 | -122.43719063 | 18TH ST \ DIAMOND ST | 18TH ST \ DIAMOND ST | 1710539427000 | MTA | ALL WAY | DIAMOND ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 94927 | 164764800000 | -122.43719063 | 37.76075811 | - | 1488499200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479460440000 | 18TH ST | - | - | - | - | - | - |
| 77809 | N/A | Point | - | - | - | - | S231382 | GENNESSEE ST: JOOST AVE | - | F | F | - | F | 22260000 | 22260000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | JOOST AVE | GENNESSEE ST | 125849 | 125849 | 37.73231592 | -122.45115344 | GENNESSEE ST \ JOOST AVE | JOOST AVE \ GENNESSEE ST | 1710539427000 | MTA | ALL WAY | GENNESSEE ST intersection | - | - | - | - | - | - | - | 94928 | 1058832000000 | -122.45115344 | 37.73231592 | - | 1585872000000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1480425060000 | JOOST AVE | - | - | - | - | - | - |
| 77810 | N/A | Point | - | - | - | - | S233639 | DE SOTO ST: URBANO DR | - | F | F | - | F | 22707000 | 22707000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | DE SOTO ST | DE SOTO ST | 125851 | 125851 | 37.72326482 | -122.46565838 | URBANO DR \ DE SOTO ST | URBANO DR \ DE SOTO ST | 1710539427000 | MTA | STOP | DE SOTO ST intersection | - | 10`SOUTH (N-END OF INTERSECTION) | - | - | - | - | - | 94929 | 1492174740000 | -122.46565838 | 37.72326482 | - | 1492128000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1487165100000 | URBANO DR | - | - | - | - | - | - |
| 77811 | N/A | Point | - | - | - | - | S233216 | SANTA CRUZ AVE: DE LONG ST | - | F | F | - | F | 22513000 | 22513000 | - | - | SOUTH EAST CORNER | - | - | - | - | DE LONG ST | SANTA CRUZ AVE | 125852 | 125852 | 37.70944574 | -122.46547874 | SANTA CRUZ AVE \ DE LONG ST | DE LONG ST \ SANTA CRUZ AVE | 1755712227000 | middleware_editor | SANTA CRUZ | SANTA CRUZ AVE intersection | - | - | - | - | - | - | - | 94930 | 1504277220000 | -122.46547874 | 37.70944574 | - | 1504249200000 | - | D11 | - | STREET NAME | GUIDE | D3-1.1578 | 36X08 | SUP2 | 3IN IRON POST | IS | 1486024440000 | DE LONG ST | - | - | - | - | - | - |
| 77812 | N/A | Point | - | - | - | - | S101566 | JACKSON ST: FRANKLIN ST | - | F | F | - | F | 26544000 | 26544000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | JACKSON ST | FRANKLIN ST | 125853 | 125853 | 37.79372602 | -122.42469414 | FRANKLIN ST \ JACKSON ST | JACKSON ST \ FRANKLIN ST | 1710539427000 | MTA | STOP | FRANKLIN ST intersection | - | 0 / ONE WAY | - | - | - | - | - | 94931 | -395712000000 | -122.42469414 | 37.79372602 | - | - | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566800000 | JACKSON ST | - | - | - | - | - | - |
| 77813 | N/A | Point | - | - | - | - | S101873 | OLIVE ST: VAN NESS AVE | - | F | F | - | F | 25193000 | 25193000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 125854 | 125854 | 37.78430273 | -122.42101751 | OLIVE ST \ VAN NESS AVE | OLIVE ST \ VAN NESS AVE | 1710539427000 | MTA | DO NOT ENTER | VAN NESS AVE intersection | - | NEC OF FRANKLIN | - | - | - | - | - | 94932 | -394848000000 | -122.42101751 | 37.78430273 | - | 1410480000000 | - | D5 | - | OTHER REGULATORY | REG | R5-1.0002 | 24X24 | SUP1 | LIGHT POLE | IS | 1373566920000 | OLIVE ST | - | - | - | - | - | - |
| 77814 | N/A | Point | - | - | - | - | S108215 | ELLINGTON AVE: NAGLEE AVE | - | F | F | - | F | 21503000 | 21503000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ELLINGTON AVE | ELLINGTON AVE | 125855 | 125855 | 37.71216078 | -122.44679998 | NAGLEE AVE \ ELLINGTON AVE | NAGLEE AVE \ ELLINGTON AVE | 1710539427000 | MTA | STOP | ELLINGTON AVE intersection | - | 0 / 0 | - | - | - | - | - | 94933 | 291254400000 | -122.44679998 | 37.71216078 | - | 1553126400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570100000 | NAGLEE AVE | - | - | - | - | - | - |
| 77815 | N/A | Point | - | - | - | - | S108248 | SPROULE LN: SACRAMENTO ST | - | F | F | - | F | 30047000 | 30047000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SPROULE LN | SPROULE LN | 125856 | 125856 | 37.79264451 | -122.41192994 | SACRAMENTO ST \ SPROULE LN | SACRAMENTO ST \ SPROULE LN | 1752070688000 | middleware_editor | DO NOT ENTER | SPROULE LN intersection | - | 0 / MADE SPROULE 1-WAY SB BETCLAY &..... | - | - | - | - | - | 94934 | 292579200000 | -122.41192994 | 37.79264451 | - | 1752052500000 | - | D3 | - | OTHER REGULATORY | REG | R5-1.0002 | 24X24 | SUP1 | LIGHT POLE | IS | 1373570100000 | SACRAMENTO ST | - | - | - | - | - | - |
| 77816 | N/A | Point | - | - | - | - | S107048 | SANTIAGO ST: 21ST AVE | - | F | F | - | F | 23200000 | 23200000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 21ST AVE | 21ST AVE | 125858 | 125858 | 37.7448224 | -122.47796682 | SANTIAGO ST \ 21ST AVE | SANTIAGO ST \ 21ST AVE | 1738074283000 | middleware_editor | STOP | 21ST AVE intersection | - | 0 / 0 | - | - | - | - | - | 94935 | 187315200000 | -122.47796682 | 37.7448224 | - | 1677456000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569740000 | SANTIAGO ST | - | - | - | - | - | - |
| 77817 | N/A | Point | - | - | - | - | S107358 | RALSTON ST: SHIELDS ST | - | F | F | - | F | 22719000 | 22719000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RALSTON ST | SHIELDS ST | 125859 | 125859 | 37.71789415 | -122.46894114 | SHIELDS ST \ RALSTON ST | RALSTON ST \ SHIELDS ST | 1720792355000 | middleware_editor | STOP | SHIELDS ST intersection | - | 0 / 0 | - | - | - | - | - | 94936 | 221097600000 | -122.46894114 | 37.71789415 | - | 1575417600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569860000 | RALSTON ST | - | - | - | - | - | - |
| 77818 | N/A | Point | - | - | - | - | S103574 | GLADYS ST: SANTA MARINA ST | - | F | F | - | F | 21262000 | 21262000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GLADYS ST | GLADYS ST | 125860 | 125860 | 37.74030155 | -122.42225559 | SANTA MARINA ST \ GLADYS ST | SANTA MARINA ST \ GLADYS ST | 1749134792000 | middleware_editor | ONE WAY (RA) | GLADYS ST intersection | - | 0 / 0 | - | - | - | - | - | 94937 | -155318400000 | -122.42225559 | 37.74030155 | - | - | - | D9 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | UNKNOWN | IS | 1373568660000 | SANTA MARINA ST | - | - | - | - | - | - |
| 77819 | N/A | Point | - | - | - | - | S103605 | 36TH AVE: LAWTON ST | - | F | F | - | F | 27706000 | 27706000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 36TH AVE | 36TH AVE | 125861 | 125861 | 37.75716387 | -122.49495169 | LAWTON ST \ 36TH AVE | LAWTON ST \ 36TH AVE | 1710539427000 | MTA | STOP | 36TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 94938 | -147225600000 | -122.49495169 | 37.75716387 | - | 1484870400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568660000 | LAWTON ST | - | - | - | - | - | - |
| 77820 | N/A | Point | - | - | - | - | S102183 | SAN CARLOS ST: 20TH ST | - | F | F | - | F | 24146000 | 24146000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 20TH ST | 20TH ST | 125862 | 125862 | 37.75858493 | -122.41984132 | SAN CARLOS ST \ 20TH ST | SAN CARLOS ST \ 20TH ST | 1720548304000 | middleware_editor | ONE WAY (LA) | 20TH ST intersection | - | 0 / 0 | - | - | - | - | - | 94939 | -390096000000 | -122.41984132 | 37.75858493 | - | - | - | D9 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | UNKNOWN | IS | 1373568240000 | SAN CARLOS ST | - | - | - | - | - | - |
| 77821 | N/A | Point | - | - | - | - | S108299 | COLE ST: PARNASSUS AVE | - | F | F | - | F | 26281000 | 26281000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PARNASSUS AVE | COLE ST | 125864 | 125864 | 37.76486645 | -122.44976971 | COLE ST \ PARNASSUS AVE | PARNASSUS AVE \ COLE ST | 1710539427000 | MTA | STOP | COLE ST intersection | - | 0 / 00 | - | - | - | - | - | 94940 | 298080000000 | -122.44976971 | 37.76486645 | - | 1389744000000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570160000 | PARNASSUS AVE | - | - | - | - | - | - |
| 77822 | N/A | Point | - | - | - | - | S108328 | MASON ST: CHESTNUT ST | - | F | F | - | F | 25463000 | 25463000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CHESTNUT ST | CHESTNUT ST | 125865 | 125865 | 37.8037613 | -122.41322279 | MASON ST \ CHESTNUT ST | MASON ST \ CHESTNUT ST | 1712096532000 | middleware_editor | STOP | CHESTNUT ST intersection | - | 0 / 0 | - | - | - | - | - | 94941 | 300326400000 | -122.41322279 | 37.8037613 | - | 1556150400000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570160000 | MASON ST | - | - | - | - | - | - |
| 77823 | N/A | Point | - | - | - | - | S107404 | PRESIDIO AVE: POST ST | - | F | F | - | F | 26838000 | 26838000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PRESIDIO AVE | PRESIDIO AVE | 125866 | 125866 | 37.7835092 | -122.44603303 | POST ST \ PRESIDIO AVE | POST ST \ PRESIDIO AVE | 1710539427000 | MTA | STOP | PRESIDIO AVE intersection | - | 0 / 00 | - | - | - | - | - | 94942 | 223603200000 | -122.44603303 | 37.7835092 | - | 666489600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | MUNI POLE | IS | 1373569860000 | POST ST | - | - | - | - | - | - |
| 77824 | N/A | Point | - | - | - | - | S233781 | WISCONSIN ST: CONNECTICUT ST | - | F | F | - | F | 28098000 | 28098000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WISCONSIN ST | WISCONSIN ST | 126130 | 126130 | 37.75368475 | -122.39859315 | CONNECTICUT ST \ WISCONSIN ST | CONNECTICUT ST \ WISCONSIN ST | 1738183774000 | middleware_editor | ALL WAY | WISCONSIN ST intersection | - | - | - | - | - | - | - | 94943 | 104461200000 | -122.39859315 | 37.75368475 | - | 1738147500000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1487664540000 | CONNECTICUT ST | - | - | - | - | - | - |
| 77825 | N/A | Point | - | - | - | - | S233078 | FRANKLIN ST: GOLDEN GATE AVE | - | T | T | - | F | 24476000 | 24476000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | GOLDEN GATE AVE | 126131 | 126131 | 37.78082105 | -122.42208679 | GOLDEN GATE AVE \ FRANKLIN ST | FRANKLIN ST \ GOLDEN GATE AVE | 1710539427000 | MTA | GOLDEN GATE AVE | GOLDEN GATE AVE intersection | - | - | - | - | - | - | - | 94944 | 1502459340000 | -122.42208679 | 37.78082105 | - | 1502409600000 | - | D5 | - | STREET NAME | GUIDE | D3-2.0172 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1485772020000 | FRANKLIN ST | - | - | - | - | - | - |
| 77826 | N/A | Point | - | - | - | - | S234254 | GEARY BLVD: 38TH AVE | - | F | F | - | F | 27895000 | 27895000 | - | - | SOUTH EAST CORNER | - | - | - | - | GEARY BLVD | GEARY BLVD | 126133 | 126133 | 37.77945547 | -122.49866462 | 38TH AVE \ GEARY BLVD | 38TH AVE \ GEARY BLVD | 1718760194000 | middleware_editor | GEARY ST | GEARY BLVD intersection | - | - | - | - | - | - | - | 94945 | 1505892120000 | -122.49866462 | 37.77945547 | - | 1505865600000 | - | D1 | - | STREET NAME | GUIDE | D3-1.0718 | 36X08 | SUP2 | 3IN IRON POST | IS | 1489155300000 | 38TH AVE | - | - | - | - | - | - |
| 77827 | N/A | Point | - | - | - | LEFT ARROW | S232738 | TARAVAL ST: 19TH AVE | - | T | T | - | F | 23183000 | 23183000 | - | - | SOUTH SIDE | - | - | - | - | TARAVAL ST | 19TH AVE | 126134 | 126134 | 37.74305181 | -122.47564447 | 19TH AVE \ TARAVAL ST | TARAVAL ST \ 19TH AVE | 1722993561000 | middleware_editor | TANSAT | 19TH AVE intersection | - | IFO 937 | - | - | - | - | - | 94946 | 1485431280000 | -122.47564447 | 37.74305181 | - | 1485388800000 | - | D4 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | 2IN IRON POST | IS | 1484823000000 | TARAVAL ST | - | - | - | - | - | - |
| 77828 | N/A | Point | - | - | - | - | S234124 | SUTTER ST: LAGUNA ST | - | F | F | - | F | 26519000 | 26519000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SUTTER ST | SUTTER ST | 126135 | 126135 | 37.78671266 | -122.42833561 | LAGUNA ST \ SUTTER ST | LAGUNA ST \ SUTTER ST | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | SUTTER ST intersection | - | - | - | - | - | - | - | 94947 | 1489758840000 | -122.42833561 | 37.78671266 | - | 1489708800000 | - | D5 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP1 | LIGHT POLE | IS | 1488801000000 | LAGUNA ST | - | - | - | - | - | - |
| 77829 | N/A | Point | - | - | - | - | S234059 | RAYMOND AVE: ALPHA ST | - | F | F | - | F | 20310000 | 20310000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RAYMOND AVE | ALPHA ST | 126136 | 126136 | 37.71257784 | -122.4052353 | ALPHA ST \ RAYMOND AVE | RAYMOND AVE \ ALPHA ST | 1710539427000 | MTA | ALL WAY | ALPHA ST intersection | - | - | - | - | - | - | - | 94948 | 1493210760000 | -122.4052353 | 37.71257784 | - | 1493164800000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1488532620000 | RAYMOND AVE | - | - | - | - | - | - |
| 77830 | N/A | Point | - | - | - | - | S233795 | MISSOURI ST: SIERRA ST | - | F | F | - | F | 23662000 | 23662000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MISSOURI ST | MISSOURI ST | 126137 | 126137 | 37.75829497 | -122.39608874 | SIERRA ST \ MISSOURI ST | SIERRA ST \ MISSOURI ST | 1710539427000 | MTA | ALL WAY | MISSOURI ST intersection | - | MADE ALL WAY STOP | - | - | - | - | - | 94949 | 714787200000 | -122.39608874 | 37.75829497 | - | 1492819200000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1487667480000 | SIERRA ST | - | - | - | - | - | - |
| 77831 | N/A | Point | - | - | - | - | S275389 | BATTERY ST: PINE ST | - | T | T | - | F | 24671000 | 24671000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BATTERY ST | BATTERY ST | 126138 | 126138 | 37.79225795 | -122.39976335 | PINE ST \ BATTERY ST | PINE ST \ BATTERY ST | 1750962886000 | middleware_editor | DO NOT BLOCK INTERSECTION | BATTERY ST intersection | - | - | - | - | - | - | - | 94950 | 423817200000 | -122.39976335 | 37.79225795 | - | 1634626800000 | - | D3 | - | OTHER REGULATORY | REG | R10-7.0002 | 30X42 | SUP1 | 3IN IRON POST | IS | 1623327720000 | PINE ST | - | - | - | - | - | - |
| 77832 | N/A | Point | 1 | 1 | 200 - 299 | - | S280817 | 200-299 15TH AVE | 200-299 15TH AVE | F | F | - | F | 606000 | 606000 | - | - | WEST SIDE | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 126139 | 126139 | 37.78343977 | -122.47417807 | - | - | 1745448872000 | middleware_editor | 2 HR PRK 9AM-6PM MON-FRI EXC "N" PERMITS | CALIFORNIA ST to CLEMENT ST (200 - 299) | 121902150 | 263 15TH AVE | - | - | - | - | - | 94951 | 1221202800000 | -122.47417807 | 37.78343977 | - | 1745443860000 | - | D1 | - | PARKING:RPP | REG | R32C(CA).0169 | 18X21 | SUP2 | 2IN IRON POST | IS | 1644406440000 | 15TH AVE | 200 - 299 15TH AVE | 200 - 299 15TH AVE | 200 15TH AVE | - | CLEMENT ST | CLEMENT ST |
| 77833 | N/A | Point | - | - | - | - | S279413 | VALENCIA ST: CESAR CHAVEZ ST | - | T | T | - | F | 21345000 | 21345000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | CESAR CHAVEZ ST | 126140 | 126140 | 37.74812528 | -122.42027883 | CESAR CHAVEZ ST \ VALENCIA ST | VALENCIA ST \ CESAR CHAVEZ ST | 1710539427000 | MTA | SPEED LIMIT 25 | CESAR CHAVEZ ST intersection | - | - | - | - | - | - | - | 94952 | 1548201600000 | -122.42027883 | 37.74812528 | - | - | - | D9 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP2 | OVERHEAD MAST ARM | IS | 1638956580000 | VALENCIA ST | - | - | - | - | - | - |
| 77834 | N/A | Point | - | - | - | - | S273673 | DOLORES ST: CESAR CHAVEZ ST | - | F | F | - | F | 21901000 | 21901000 | - | - | EAST SIDE | - | - | - | - | CESAR CHAVEZ ST | DOLORES ST | 126141 | 126141 | 37.7478303 | -122.42476828 | DOLORES ST \ CESAR CHAVEZ ST | CESAR CHAVEZ ST \ DOLORES ST | 1710539427000 | MTA | NPRK 7AM-9AM MON STCL | DOLORES ST intersection | - | IFO 1633 | - | - | - | - | - | 94953 | 1456185600000 | -122.42476828 | 37.7478303 | - | 1620950400000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0237 | 18X18 | SUP2 | LIGHT POLE | IS | 1617024180000 | CESAR CHAVEZ ST | - | - | - | - | - | - |
| 77835 | N/A | Point | - | - | - | - | S277576 | MARKET ST: SHORT ST | - | F | F | - | F | 26152000 | 26152000 | - | - | SOUTH SIDE | - | - | - | - | MARKET ST | MARKET ST | 126142 | 126142 | 37.75779863 | -122.44321651 | SHORT ST \ MARKET ST | SHORT ST \ MARKET ST | 1755265597000 | middleware_editor | NPRK 12NN-2PM FRI STCL | MARKET ST intersection | - | 25 FT EAST OF STANTON | - | - | - | - | - | 94954 | 1634841900000 | -122.44321651 | 37.75779863 | - | 1634799600000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0076 | 18X18 | SUP2 | LIGHT POLE | IS | 1631527260000 | SHORT ST | - | - | - | - | - | - |
| 77836 | N/A | Point | - | - | - | - | S280333 | POLK ST: JACKSON ST | - | T | T | - | F | 25304000 | 25304000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JACKSON ST | JACKSON ST | 126143 | 126143 | 37.79414398 | -122.42140436 | POLK ST \ JACKSON ST | POLK ST \ JACKSON ST | 1710539427000 | MTA | SPEED LIMIT 20 | JACKSON ST intersection | - | - | - | - | - | - | - | 94955 | 1552608000000 | -122.42140436 | 37.79414398 | - | - | - | D3 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | SIGNAL POLE | IS | 1641896880000 | POLK ST | - | - | - | - | - | - |
| 77837 | N/A | Point | - | - | - | - | S278499 | OAK ST: SHRADER ST | - | F | F | - | F | 26436000 | 26436000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | OAK ST | OAK ST | 126146 | 126146 | 37.77122983 | -122.45224178 | SHRADER ST \ OAK ST | SHRADER ST \ OAK ST | 1710539427000 | MTA | NO RIGHT TURN (SYM)/NO U TURN (SYM) | OAK ST intersection | - | IFO 2017 ABOVE NO U TURN SIGN | - | - | - | - | - | 94956 | 1030320000000 | -122.45224178 | 37.77122983 | - | 1623888000000 | - | D5 | - | NO RIGHT TURN | REG | R3-18.0005 | 30X30 | SUP1 | 2IN IRON POST | IS | 1635342360000 | SHRADER ST | - | - | - | - | - | - |
| 77838 | N/A | Point | - | - | - | - | S107137 | CAMPBELL AVE: SAN BRUNO AVE | - | F | F | - | F | 20295000 | 20295000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CAMPBELL AVE | CAMPBELL AVE | 126147 | 126147 | 37.71539032 | -122.39954775 | SAN BRUNO AVE \ CAMPBELL AVE | SAN BRUNO AVE \ CAMPBELL AVE | 1736812017000 | middleware_editor | STOP | CAMPBELL AVE intersection | - | 0 / 0 | - | - | - | - | - | 94957 | 200620800000 | -122.39954775 | 37.71539032 | - | 1736731800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569740000 | SAN BRUNO AVE | - | - | - | - | - | - |
| 77839 | N/A | Point | - | - | - | - | S103703 | LILY ST: FRANKLIN ST | - | F | F | - | F | 24455000 | 24455000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 126148 | 126148 | 37.77475982 | -122.42085915 | LILY ST \ FRANKLIN ST | LILY ST \ FRANKLIN ST | 1710539427000 | MTA | ONE WAY (RA) | FRANKLIN ST intersection | - | 0 / 0 | - | - | - | - | - | 94958 | -131846400000 | -122.42085915 | 37.77475982 | - | - | - | D5 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | 2IN IRON POST | IS | 1373568720000 | LILY ST | - | - | - | - | - | - |
| 77840 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S251764 | 1100-1199 SILLIMAN ST | 1100-1199 SILLIMAN ST | F | F | - | F | 11884000 | 11884000 | - | - | SOUTH SIDE | - | - | - | - | PRINCETON ST | PRINCETON ST | 126920 | 126920 | 37.72827154 | -122.41643295 | - | - | 1718069122000 | middleware_editor | NPRK 12NN-3PM TUE STCL | PRINCETON ST to AMHERST ST (1100 - 1199) | - | WPL 1133 | - | - | - | - | - | 94959 | 1109635200000 | -122.41643295 | 37.72827154 | - | 1551225600000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0090 | 18X18 | SUP2 | 2IN IRON POST | IS | 1550747280000 | SILLIMAN ST | 1100 - 1199 SILLIMAN ST | 1100 - 1199 SILLIMAN ST | 1100 SILLIMAN ST | - | AMHERST ST | AMHERST ST |
| 77841 | N/A | Point | - | 1 | 300 - 399 | - | S256654 | 0-299 16TH ST | 300-399 16TH ST | T | T | - | F | 15049000 | 15049000 | - | - | SOUTH SIDE | - | - | - | - | TERRY A FRANCOIS BLVD | TERRY A FRANCOIS BLVD | 126921 | 126921 | 37.76701694 | -122.38714988 | - | - | 1710539427000 | MTA | TA (SYM) NO STOPPING 12MID- 6AM DAILY | TERRY A FRANCOIS BLVD to ILLINOIS ST (300 - 399) | - | 165' WEST OF TERRY FRANCOIS | - | - | - | - | - | 94960 | 1228780800000 | -122.38714988 | 37.76701694 | - | 1655942400000 | 1653436800000 | D6 | - | OTHER REGULATORY | REG | R37(CA).0109 | 18X21 | SUP1 | LIGHT POLE | RETD | 1564657200000 | 16TH ST | 300 - 399 16TH ST | 300 - 399 16TH ST | 300 16TH ST | - | ILLINOIS ST | ILLINOIS ST |
| 77842 | N/A | Point | 1 | 1 | 3600 - 3699 | - | S212272 | 3600-3699 TARAVAL ST | 3600-3699 TARAVAL ST | F | F | - | F | 12423000 | 12423000 | - | - | NORTH SIDE | - | - | - | - | 46TH AVE | 46TH AVE | 126924 | 126924 | 37.74174044 | -122.50515572 | - | - | 1729215334000 | middleware_editor | PARK AT 90 DEGREES (SYM) | 46TH AVE to 47TH AVE (3600 - 3699) | - | IFO#3626 (SEE MAP) | - | - | - | - | - | 94961 | 1438700640000 | -122.50515572 | 37.74174044 | - | 1438646400000 | - | D4 | - | PARKING: PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP2 | MUNI POLE | IS | 1420454460000 | TARAVAL ST | 3600 - 3699 TARAVAL ST | 3600 - 3699 TARAVAL ST | 3600 TARAVAL ST | - | 47TH AVE | 47TH AVE |
| 77843 | N/A | Point | 1 | 1 | 1 - 100 | - | S211856 | 1-99 STARR KING WAY | 1-100 STARR KING WAY | F | F | - | F | 12110000 | 12110000 | - | - | NORTH SIDE | - | - | - | - | FRANKLIN ST \ OFARRELL ST | FRANKLIN ST \ OFARRELL ST | 126925 | 126925 | 37.784913 | -122.42377191 | - | - | 1710539427000 | MTA | SIGNAL AHEAD (SYM) | FRANKLIN ST \ OFARRELL ST to GEARY BLVD \ GOUGH ST \ PETER YORKE WAY (1 - 100) | - | 120FT. WEST OF FRANKLIN ST. | - | - | - | - | - | 94962 | 1419344820000 | -122.42377191 | 37.784913 | - | 1419292800000 | - | D5 | - | OTHER WARNING | WARNING | W3-3.0002 | 36X36 | SUP1 | LIGHT POLE | IS | 1418794980000 | STARR KING WAY | 1 - 100 STARR KING WAY | 1 - 100 STARR KING WAY | 1 STARR KING WAY | - | GEARY BLVD \ GOUGH ST \ PETER YORKE WAY | GEARY BLVD \ GOUGH ST \ PETER YORKE WAY |
| 77844 | N/A | Point | 1 | 1 | 1 - 99 | - | S210244 | 1-99 DORLAND ST | 1-99 DORLAND ST | F | F | - | F | 4934000 | 4934000 | - | - | SOUTH SIDE | - | - | - | - | GUERRERO ST | GUERRERO ST | 126926 | 126926 | 37.76227657 | -122.42504591 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | GUERRERO ST to DOLORES ST (1 - 99) | - | INFO #45 DORLAND ST. | - | - | - | - | - | 94963 | 1016409600000 | -122.42504591 | 37.76227657 | - | - | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | LIGHT POLE | IS | 1413970020000 | DORLAND ST | 1 - 99 DORLAND ST | 1 - 99 DORLAND ST | 1 DORLAND ST | - | DOLORES ST | DOLORES ST |
| 77845 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S211300 | 2000-2099 LOWER GREAT HWY | 2000-2099 GREAT HWY | F | F | - | F | 8516000 | 8516000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PACHECO ST | PACHECO ST | 126927 | 126927 | 37.74817974 | -122.50781822 | - | - | 1713298537000 | middleware_editor | STOP | PACHECO ST to QUINTARA ST (2000 - 2099) | - | - | - | - | - | - | - | 94964 | 1418049000000 | -122.50781822 | 37.74817974 | - | 1417996800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1417525800000 | GREAT HWY | 2000 - 2099 GREAT HWY | 2000 - 2099 GREAT HWY | 2000 GREAT HWY | - | QUINTARA ST | QUINTARA ST |
| 77846 | N/A | Point | 1 | 1 | 200 - 299 | - | S213729 | 200-299 BAKER ST | 200-299 BAKER ST | F | F | - | F | 2606000 | 2606000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | OAK ST | OAK ST | 126928 | 126928 | 37.77317409 | -122.44082847 | - | - | 1728351180000 | middleware_editor | BAY AREA RIDGE TRAIL | OAK ST to FELL ST (200 - 299) | - | 120'S OF FELL PLUS LA | - | - | - | - | - | 94965 | 1431697620000 | -122.44082847 | 37.77317409 | - | 1431648000000 | - | D5 | - | OTHER GUIDE | GUIDE | G-B(SF).0044 | 15X20 | SUP1 | 2IN IRON POST | IS | 1424698680000 | BAKER ST | 200 - 299 BAKER ST | 200 - 299 BAKER ST | 200 BAKER ST | - | FELL ST | FELL ST |
| 77847 | N/A | Point | 1 | 1 | 500 - 599 | - | S212626 | 500-599 ARGUELLO BLVD | 500-599 ARGUELLO BLVD | F | F | - | F | 2423000 | 2423000 | - | - | EAST SIDE | - | - | - | - | GEARY BLVD | GEARY BLVD | 126929 | 126929 | 37.78029512 | -122.45879514 | - | - | 1738852884000 | middleware_editor | 2 HR PRK 9AM-4PM MON-FRI EXC "FN" PERMITS | GEARY BLVD to ANZA ST (500 - 599) | - | 160FT. NORTH OF GEARY BLVD. | - | - | - | - | - | 94966 | 1237420800000 | -122.45879514 | 37.78029512 | - | 1423785600000 | - | D1 | - | PARKING:RPP | REG | R32C(CA).0146 | 18X21 | SUP2 | MUNI POLE | IS | 1421394420000 | ARGUELLO BLVD | 500 - 599 ARGUELLO BLVD | 500 - 599 ARGUELLO BLVD | 500 ARGUELLO BLVD | - | ANZA ST | ANZA ST |
| 77848 | N/A | Point | - | - | - | - | S130481 | PERRY ST: 4TH ST | - | F | F | - | F | 23904000 | 23904000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 4TH ST | 04TH ST | 126930 | 126930 | 37.78036289 | -122.39907963 | PERRY ST \ 4TH ST | PERRY ST \ 04TH ST | 1710539427000 | MTA | DO NOT ENTER | 04TH ST intersection | - | - | - | - | - | - | - | 94967 | 1238544000000 | -122.39907963 | 37.78036289 | - | - | - | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | FREEWAY COLUMN | IS | 1373577060000 | PERRY ST | - | - | - | - | - | - |
| 77849 | N/A | Point | - | - | - | - | S130791 | GRAFTON AVE: CAPITOL AVE | - | F | F | - | F | 22582000 | 22582000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GRAFTON AVE | GRAFTON AVE | 126931 | 126931 | 37.72002413 | -122.45919844 | CAPITOL AVE \ GRAFTON AVE | CAPITOL AVE \ GRAFTON AVE | 1718328380000 | middleware_editor | ALL WAY | GRAFTON AVE intersection | - | - | - | - | - | - | - | 94968 | 1242604800000 | -122.45919844 | 37.72002413 | - | 1549929600000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373577180000 | CAPITOL AVE | - | - | - | - | - | - |
| 77850 | N/A | Point | - | - | - | - | S133048 | DOLORES ST: CLIPPER ST | - | F | F | - | F | 25609000 | 25609000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CLIPPER ST | DOLORES ST | 126932 | 126932 | 37.7494349 | -122.424923 | DOLORES ST \ CLIPPER ST | CLIPPER ST \ DOLORES ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | DOLORES ST intersection | - | IFO 1259 | - | - | - | - | - | 94969 | 1285113600000 | -122.424923 | 37.7494349 | - | 1632355200000 | - | D8 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | LIGHT POLE | IS | 1373577900000 | CLIPPER 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.