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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 69076 | N/A | Point | 1 | 1 | 1000 - 1099 | LEFT ARROW | S269445 | 1000-1099 POST ST | 1000-1099 POST ST | F | F | - | F | - | 10639000 | - | - | SOUTH SIDE | - | - | - | - | - | LARKIN ST | 96936 | 96936 | 37.78693804 | -122.419198702 | - | - | 1710539427000 | MTA | NO STOPPING FIRE LANE | LARKIN ST to POLK ST (1000 - 1099) | - | 106' E OF POLK | - | - | - | - | - | 86192 | 1603968720000 | -122.41909946 | 37.78693274 | - | - | - | D6 | - | OTHER REGULATORY | REG | R26F.0003 | 12X18 | SUP1 | 2IN IRON POST | IS | 1603360620000 | POST ST | - | 1000 - 1099 POST ST | 1000 POST ST | - | - | POLK ST |
| 69077 | N/A | Point | 1 | 1 | 300 - 399 | - | S262611 | 300 - 399 LA GRANDE AVE | 300-399 LA GRANDE AVE | F | F | - | F | 7916001 | 7916001 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | BRAZIL AVE | 96983 | 96983 | 37.720012048 | -122.425635011 | - | - | 1754433645000 | middleware_editor | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | BRAZIL AVE to DUBLIN ST (300 - 399) | 133556 | 40' SOUTH OF BRAZIL AVE. | - | - | - | - | - | 86193 | 1319612400000 | -122.42565468 | 37.71976735 | - | 1754428500000 | - | D11 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1584963360000 | LA GRANDE AVE | 300 - 399 LA GRANDE AVE | 300 - 399 LA GRANDE AVE | 300 LA GRANDE AVE | - | DUBLIN ST | DUBLIN ST |
| 69078 | N/A | Point | 1 | 1 | 300 - 399 | - | S262614 | PNDG DUBLIN ST | 300-399 LA GRANDE AVE | T | T | - | F | 4975001 | 7916001 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | LA GRANDE AVE | BRAZIL AVE | 96985 | 96985 | 37.7191000854673 | -122.425917759358 | - | - | 1754433627000 | middleware_editor | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | BRAZIL AVE to DUBLIN ST (300 - 399) | 133557 | 200' NORTH OF PERSIA OPP 20 | - | - | - | - | - | 86194 | 1319612400000 | -122.42565468 | 37.71976735 | - | 1754426700000 | - | D11 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP2 | LIGHT POLE | IS | 1584966180000 | LA GRANDE AVE | 1 - 99 DUBLIN ST | 300 - 399 LA GRANDE AVE | - | - | PERSIA AVE | DUBLIN ST |
| 69079 | N/A | Point | - | - | - | - | S286822 | POLK ST: PINE ST | - | F | F | - | F | 25222000 | 25222000 | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | - | - | - | - | POLK ST | POLK ST | 97061 | 97061 | 37.78962044 | -122.42049344 | PINE ST \ POLK ST | PINE ST \ POLK ST | 1710539427000 | MTA | TREE TOP 6FT SPEED BUMP | POLK ST intersection | - | - | - | - | - | - | - | 86195 | 1675900800000 | -122.42049344 | 37.78962044 | - | - | - | D3 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1672225080000 | PINE ST | - | - | - | - | - | - |
| 69080 | N/A | Point | 1 | 1 | 100 - 199 | - | S266814 | 100-199 BACON ST | 100-199 BACON ST | F | F | - | F | 2579000 | 2580000 | - | - | SOUTH SIDE | - | - | - | - | BAY SHORE BLVD \ EGBERT AVE | SAN BRUNO AVE | 97075 | 97075 | 37.727653417 | -122.403328929 | - | - | 1710539427000 | MTA | NPRK 7AM-8AM FRI STCL | SAN BRUNO AVE to GIRARD ST (100 - 199) | - | 40 FT EAST OF SAN BRUNO | - | - | - | - | - | 86196 | 1421971200000 | -122.40409336 | 37.72750421 | - | 1596499200000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0209 | 18X18 | SUP2 | 2IN IRON POST | IS | 1596463620000 | BACON ST | 50 - 99 BACON ST | 100 - 199 BACON ST | 100 BACON ST | - | SAN BRUNO AVE | GIRARD ST |
| 69081 | N/A | Point | - | - | - | - | S286769 | FRANKLIN ST: VALLEJO ST | - | F | F | - | F | 26553000 | 26553000 | - | - | SOUTH WEST CORNER | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 97108 | 97108 | 37.7964813 | -122.42524988 | VALLEJO ST \ FRANKLIN ST | VALLEJO ST \ FRANKLIN ST | 1744234156000 | middleware_editor | TREE TOP 6FT SPEED BUMP | FRANKLIN ST intersection | - | 0 / 0 | - | - | - | - | - | 86197 | 1672992000000 | -122.42524988 | 37.7964813 | - | 1744215060000 | - | D2 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1672136220000 | VALLEJO ST | - | - | - | - | - | - |
| 69082 | N/A | Point | - | - | - | - | S260439 | LAGUNA ST: PAGE ST | - | F | F | - | F | 25908000 | 25908000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAGUNA ST | LAGUNA ST | 97195 | 97195 | 37.773587256 | -122.425623097 | PAGE ST \ LAGUNA ST | PAGE ST \ LAGUNA ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) | LAGUNA ST intersection | - | - | - | - | - | - | - | 86198 | -199152000000 | -122.42570021 | 37.77366623 | - | 1583366400000 | - | D5 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1579177080000 | PAGE ST | - | - | - | - | - | - |
| 69083 | N/A | Point | 1 | 1 | 500 - 599 | - | S262792 | 500-599 VALENCIA ST | 500-599 VALENCIA ST | F | F | - | F | 13060000 | 13060000 | - | - | EAST SIDE | - | - | - | - | 16TH ST | 16TH ST | 97200 | 97200 | 37.76382162 | -122.42170348 | - | - | 1710539427000 | MTA | NO LITTERING (SYM)-IT SHALL BE UNLAWFUL¿ | 16TH ST to 17TH ST (500 - 599) | - | IFO 575 | - | - | - | - | - | 86199 | - | -122.42180898 | 37.76410858 | - | - | - | D9 | - | OTHER REGULATORY | REG | SR(SF).0035 | 18X24 | SUP2 | LIGHT POLE | IS | 1585228440000 | VALENCIA ST | 500 - 599 VALENCIA ST | 500 - 599 VALENCIA ST | 500 VALENCIA ST | - | 17TH ST | 17TH ST |
| 69084 | N/A | Point | 1 | 1 | 500 - 599 | - | S262793 | 500-599 VALENCIA ST | 500-599 VALENCIA ST | F | F | - | F | 13060000 | 13060000 | - | - | WEST SIDE | - | - | - | - | 16TH ST | 16TH ST | 97201 | 97201 | 37.763765076 | -122.421882294 | - | - | 1710539427000 | MTA | NO LITTERING (SYM)-IT SHALL BE UNLAWFUL¿ | 16TH ST to 17TH ST (500 - 599) | - | IFO 572 | - | - | - | - | - | 86200 | - | -122.42180898 | 37.76410858 | - | - | - | D9 | - | OTHER REGULATORY | REG | SR(SF).0035 | 18X24 | SUP2 | LIGHT POLE | IS | 1585228500000 | VALENCIA ST | 500 - 599 VALENCIA ST | 500 - 599 VALENCIA ST | 500 VALENCIA ST | - | 17TH ST | 17TH ST |
| 69085 | N/A | Point | - | - | - | - | S285332 | FAIRFAX AVE: KEITH ST | - | F | F | - | F | 20182000 | 20182000 | - | - | CENTER ISLAND, W LINE, WESTBOUND | - | - | - | - | FAIRFAX AVE | FAIRFAX AVE | 97927 | 97927 | 37.73812292 | -122.38155774 | KEITH ST \ FAIRFAX AVE | KEITH ST \ FAIRFAX AVE | 1710539427000 | MTA | TREE TOP 6FT SPEED BUMP | FAIRFAX AVE intersection | - | ON 4" SINGLE YELLOW, 20' OC | - | - | - | - | - | 86201 | 1676073600000 | -122.38155774 | 37.73812292 | - | - | - | D10 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1664799000000 | KEITH ST | - | - | - | - | - | - |
| 69086 | N/A | Point | - | - | - | - | S285333 | FAIRFAX AVE: MENDELL ST | - | F | F | - | F | 20204000 | 20204000 | - | - | CENTER ISLAND, W LINE, WESTBOUND | - | - | - | - | FAIRFAX AVE | FAIRFAX AVE | 97928 | 97928 | 37.74024002 | -122.38528166 | MENDELL ST \ FAIRFAX AVE | MENDELL ST \ FAIRFAX AVE | 1710539427000 | MTA | TREE TOP 6FT SPEED BUMP | FAIRFAX AVE intersection | - | ON 4" SINGLE YELLOW, 20' OC | - | - | - | - | - | 86202 | - | -122.38528166 | 37.74024002 | - | - | - | D10 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1664799180000 | MENDELL ST | - | - | - | - | - | - |
| 69087 | N/A | Point | 1 | 1 | 5900 - 5999 | - | S266598 | 5900-5949 MISSION ST | 5900-5999 MISSION ST | F | F | - | F | 9197000 | 9197000 | - | - | EAST SIDE | - | - | - | - | ACTON ST \ SICKLES AVE | ACTON ST \ SICKLES AVE | 99875 | 99875 | 37.708519833 | -122.45339603 | - | - | 1710539427000 | MTA | 2 HR PRK 7AM-6PM EXC SUN | ACTON ST \ SICKLES AVE to HURON AVE (5900 - 5999) | - | 25FT SOUTH OF ACTON UNDER SIGNAL LIGHT | - | - | - | - | - | 86203 | 1676505600000 | -122.45347292 | 37.70853115 | - | - | - | D11 | - | PARKING | REG | R32(CA).0071 | 18X18 | SUP2 | SIGNAL POLE | IS | 1595859060000 | MISSION ST | 5900 - 5999 MISSION ST | 5900 - 5999 MISSION ST | 5900 MISSION ST | - | HURON AVE | HURON AVE |
| 69088 | N/A | Point | 1 | 1 | 200 - 299 | - | S263130 | 200-299 EXCELSIOR AVE | 200-299 EXCELSIOR AVE | F | F | - | F | 5361000 | 5361000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | PARIS ST | PARIS ST | 99934 | 99934 | 37.725355318 | -122.431626788 | - | - | 1725907285000 | middleware_editor | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | PARIS ST to LISBON ST (200 - 299) | 132864 | WPL 231 | - | - | - | - | - | 86204 | 1319068800000 | -122.43165361 | 37.72529733 | - | - | - | D11 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1585924920000 | EXCELSIOR AVE | 200 - 299 EXCELSIOR AVE | 200 - 299 EXCELSIOR AVE | 200 EXCELSIOR AVE | - | LISBON ST | LISBON ST |
| 69089 | N/A | Point | - | - | - | - | S263134 | EXCELSIOR AVE: PARIS ST | - | F | F | - | F | 21759000 | 21759000 | - | - | SOUTH EAST CORNER | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 99935 | 99935 | 37.725522024 | -122.431950108 | PARIS ST \ EXCELSIOR AVE | PARIS ST \ EXCELSIOR AVE | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | EXCELSIOR AVE intersection | 132865 | - | - | - | - | - | - | 86205 | 1319068800000 | -122.43205382 | 37.72548808 | - | - | - | D11 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP2 | LIGHT POLE | IS | 1585931100000 | PARIS ST | - | - | - | - | - | - |
| 69090 | N/A | Point | - | - | - | - | S289066 | VALENCIA ST: 20TH ST | - | T | T | - | F | 24153000 | 24153000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 20TH ST | 20TH ST | 99994 | 99994 | 37.758412275 | -122.421373654 | VALENCIA ST \ 20TH ST | VALENCIA ST \ 20TH ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | 20TH ST intersection | - | - | - | - | - | - | - | 86206 | 1682640000000 | -122.42127173 | 37.75849851 | - | - | - | D8 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | OVERHEAD MAST ARM | IS | 1682602440000 | VALENCIA ST | - | - | - | - | - | - |
| 69091 | N/A | Point | 1 | 1 | 900 - 955 | - | S285487 | 900-955 CAYUGA AVE | 900-955 CAYUGA AVE | F | F | - | F | 3832000 | 3832000 | - | - | WEST SIDE | - | - | - | - | OCEAN AVE | OCEAN AVE | 100024 | 100024 | 37.72324798 | -122.438979184 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM FRI STCL | OCEAN AVE to VALERTON CT (900 - 955) | - | 70 FT SOUTH OF OCEAN OPP 917 | - | - | - | - | - | 86207 | 1670371200000 | -122.43907932 | 37.72316736 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0259 | 18X18 | SUP2 | 2IN IRON POST | IS | 1665747060000 | CAYUGA AVE | 900 - 955 CAYUGA AVE | 900 - 955 CAYUGA AVE | 900 CAYUGA AVE | - | VALERTON CT | VALERTON CT |
| 69092 | N/A | Point | 1 | 1 | 900 - 955 | - | S285488 | 900-955 CAYUGA AVE | 900-955 CAYUGA AVE | F | F | - | F | 3832000 | 3832000 | - | - | WEST SIDE | - | - | - | - | OCEAN AVE | OCEAN AVE | 100025 | 100025 | 37.723256466 | -122.438968455 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "V" PERMITS | OCEAN AVE to VALERTON CT (900 - 955) | - | 70 FT SOUTH OF OCEAN OPP 917 | - | - | - | - | - | 86208 | 1670371200000 | -122.43907932 | 37.72316736 | - | - | - | D11 | - | PARKING:RPP | REG | R32C(CA).0102 | 18X21 | SUP2 | 2IN IRON POST | IS | 1665747300000 | CAYUGA AVE | 900 - 955 CAYUGA AVE | 900 - 955 CAYUGA AVE | 900 CAYUGA AVE | - | VALERTON CT | VALERTON CT |
| 69093 | N/A | Point | - | - | - | - | S285392 | LAKE ST: 3RD AVE | - | F | F | - | F | 27584000 | 27584000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 3RD AVE | LAKE ST | 100039 | 100039 | 37.78681607 | -122.46147084 | LAKE ST \ 3RD AVE | 03RD AVE \ LAKE ST | 1710539427000 | MTA | SPEED HUMP | LAKE ST intersection | - | - | - | - | - | - | - | 86209 | 1665964800000 | -122.46147084 | 37.78681607 | - | - | - | D2 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1665048720000 | 03RD AVE | - | - | - | - | - | - |
| 69094 | N/A | Point | - | - | - | - | S285393 | LAKE ST: 12TH AVE | - | F | F | - | F | 27613000 | 27613000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LAKE ST | 12TH AVE | 100040 | 100040 | 37.78638724 | -122.4711146 | 12TH AVE \ LAKE ST | LAKE ST \ 12TH AVE | 1725457234000 | middleware_editor | SPEED HUMP | 12TH AVE intersection | - | - | - | - | - | - | - | 86210 | 1666051200000 | -122.4711146 | 37.78638724 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1665050220000 | LAKE ST | - | - | - | - | - | - |
| 69095 | N/A | Point | - | - | - | - | S285396 | LAKE ST: 15TH AVE | - | T | T | - | F | 27625000 | 27625000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LAKE ST | 15TH AVE | 100042 | 100042 | 37.78623802 | -122.47438284 | 15TH AVE \ LAKE ST | LAKE ST \ 15TH AVE | 1714786468000 | middleware_editor | SPEED HUMP | 15TH AVE intersection | - | ABOVE SIGNS | - | - | - | - | - | 86211 | 1667779200000 | -122.47438284 | 37.78623802 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1665050880000 | LAKE ST | - | - | - | - | - | - |
| 69096 | N/A | Point | - | - | - | - | S288547 | DIVISADERO ST: PAGE ST | - | F | F | - | F | 26029000 | 26029000 | - | - | NORTH WEST CORNER | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 100079 | 100079 | 37.77220371 | -122.43723493 | PAGE ST \ DIVISADERO ST | PAGE ST \ DIVISADERO ST | 1710539427000 | MTA | TREE TOP 6FT SPEED BUMP | DIVISADERO ST intersection | - | IN PSZ, SOUTH OF N-LINE X-WALK | - | - | - | - | - | 86212 | 1683676800000 | -122.43723493 | 37.77220371 | - | - | - | D5 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1681474380000 | PAGE ST | - | - | - | - | - | - |
| 69097 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S262886 | 1000-1099 POST ST | 1000-1099 POST ST | F | F | - | F | 10639000 | 10639000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | LARKIN ST | LARKIN ST | 100090 | 100090 | 37.786914722 | -122.418781618 | - | - | 1710539427000 | MTA | EXC BUSES | LARKIN ST to POLK ST (1000 - 1099) | 11914 | 115' W OF HYDE | - | - | - | - | - | 86213 | 159321600000 | -122.41909946 | 37.78693274 | - | - | - | D6 | - | OTHER REGULATORY | REG | R(SF).0059 | 12X18 | SUP1 | MUNI POLE | IS | 1585643340000 | POST ST | 1000 - 1099 POST ST | 1000 - 1099 POST ST | 1000 POST ST | - | POLK ST | POLK ST |
| 69098 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S262932 | 1700-1799 IRVING ST | 1700-1799 IRVING ST | F | F | - | F | 7295000 | 7295000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 18TH AVE | 18TH AVE | 100224 | 100224 | 37.763668063 | -122.476891412 | - | - | 1710539427000 | MTA | RIGHT LANE MUST TURN RIGHT | 18TH AVE to 19TH AVE (1700 - 1799) | 042506 | 60' EAST OF 19TH AVE | - | - | - | - | - | 86214 | 673574400000 | -122.47661425 | 37.76358413 | - | - | - | D4 | - | OTHER REGULATORY | REG | R3-7.0005 | 30X30 | SUP2 | 2IN IRON POST | IS | 1585660260000 | IRVING ST | 1700 - 1799 IRVING ST | 1700 - 1799 IRVING ST | 1700 IRVING ST | - | 19TH AVE | 19TH AVE |
| 69099 | N/A | Point | - | - | - | - | S268508 | BROTHERHOOD WAY: ARCH ST | - | F | F | - | F | 22524000 | 22524000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | ARCH ST | ARCH ST | 100350 | 100350 | 37.71242386 | -122.467203112 | BROTHERHOOD WAY \ ARCH ST | BROTHERHOOD WAY \ ARCH ST | 1748012396000 | middleware_editor | NO LEFT TURN (SYM) | ARCH ST intersection | - | - | - | - | - | - | - | 86215 | 267174000000 | -122.46707269 | 37.71242187 | - | 1689373140000 | 1747933200000 | D11 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | SIGNAL POLE | RETD | 1601370720000 | BROTHERHOOD WAY | - | - | - | - | - | - |
| 69100 | N/A | Point | - | - | - | - | S288097 | HANOVER ST: POPE ST | - | F | F | - | F | 21418000 | 21418000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HANOVER ST | HANOVER ST | 102220 | 102220 | 37.71021714 | -122.43957484 | POPE ST \ HANOVER ST | POPE ST \ HANOVER ST | 1732226232000 | middleware_editor | SPEED HUMP | HANOVER ST intersection | - | BELOW STREET NAMES. | - | - | - | - | - | 86216 | 274579200000 | -122.43957484 | 37.71021714 | - | 1531699200000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 3IN IRON POST | IS | 1678888560000 | POPE ST | - | - | - | - | - | - |
| 69101 | N/A | Point | 1 | 1 | 346 - 399 | - | S288181 | 346-399 BOCANA ST | 346-399 BOCANA ST | F | F | - | F | 3007000 | 3007000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | ELLERT ST | ELLERT ST | 102479 | 102479 | 37.73835983 | -122.41918791 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | ELLERT ST to HOLLY PARK CIR (346 - 399) | - | 369 BOCANA | - | - | - | - | - | 86217 | 1680134400000 | -122.41918791 | 37.73835983 | - | - | - | D9 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1679041080000 | BOCANA ST | 346 - 399 BOCANA ST | 346 - 399 BOCANA ST | 346 BOCANA ST | - | HOLLY PARK CIR | HOLLY PARK CIR |
| 69102 | N/A | Point | 1 | 1 | 300 - 355 | - | S288183 | 300-355 BOCANA ST | 300-355 BOCANA ST | F | F | - | F | 3006000 | 3006000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | CORTLAND AVE | CORTLAND AVE | 102480 | 102480 | 37.73891749 | -122.41882885 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | CORTLAND AVE to ELLERT ST (300 - 355) | - | 5' SOUTH OF CORTLAND AVE. | - | - | - | - | - | 86218 | - | -122.41882885 | 37.73891749 | - | 1680134400000 | - | D9 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 3IN IRON POST | IS | 1679042040000 | BOCANA ST | 300 - 355 BOCANA ST | 300 - 355 BOCANA ST | 300 BOCANA ST | - | ELLERT ST | ELLERT ST |
| 69103 | N/A | Point | - | - | - | - | S287847 | ELLIS ST: STEINER ST | - | F | F | - | F | 26593000 | 26593000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | STEINER ST | ELLIS ST | 102490 | 102490 | 37.78215091 | -122.43416177 | ELLIS ST \ STEINER ST | STEINER ST \ ELLIS ST | 1720626260000 | middleware_editor | SPEED HUMPS AHEAD | ELLIS ST intersection | - | - | - | - | - | - | - | 86219 | 1678665600000 | -122.43416177 | 37.78215091 | - | - | - | D5 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1678101780000 | STEINER ST | - | - | - | - | - | - |
| 69104 | N/A | Point | - | - | - | - | S287849 | ELLIS ST: PIERCE ST | - | F | F | - | F | 26612000 | 26612000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 102491 | 102491 | 37.78194033 | -122.43581374 | PIERCE ST \ ELLIS ST | PIERCE ST \ ELLIS ST | 1710539427000 | MTA | SPEED HUMPS AHEAD | ELLIS ST intersection | - | - | - | - | - | - | - | 86220 | 1678665600000 | -122.43581374 | 37.78194033 | - | - | - | D5 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1678101900000 | PIERCE ST | - | - | - | - | - | - |
| 69105 | N/A | Point | 1 | 1 | 2400 - 2499 | - | S266927 | 2400-2499 LOWER GREAT HWY | 2400-2499 GREAT HWY | F | F | - | F | 2078000 | 8520000 | - | - | EAST SIDE | - | - | - | - | GREAT HWY \ TARAVAL ST | 48TH AVE \ TARAVAL ST | 102601 | 102601 | 37.74075071 | -122.50681012 | - | - | 1750771368000 | middleware_editor | NPRK 7AM-8AM MON STCL | 48TH AVE \ TARAVAL ST to 48TH AVE \ ULLOA ST (2400 - 2499) | - | IFO 2414 | - | - | - | - | - | 86221 | 1598898540000 | -122.50681012 | 37.74075071 | - | 1683788400000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0211 | 18X18 | SUP2 | LIGHT POLE | IS | 1596721980000 | GREAT HWY | 2400 - 2499 48TH AVE | 2400 - 2499 GREAT HWY | 2400 GREAT HWY | - | GREAT HWY \ ULLOA ST | 48TH AVE \ ULLOA ST |
| 69106 | N/A | Point | - | - | - | - | S256716 | PNDG TERRY A FRANCOIS BLVD | - | F | F | - | F | 12532000 | 12532000 | - | - | EAST SIDE | - | - | - | - | - | - | 102660 | 102660 | 37.76873346 | -122.38636338 | - | - | 1710539427000 | MTA | SPECIAL EVENT AREA CHECK YOUR METER (SFPARK) | - | - | 680FT SOUTH / FLAG OUT | - | - | - | - | - | 86222 | 1565101200000 | -122.38636338 | 37.76873346 | - | - | - | D6 | - | OTHER GUIDE | GUIDE | G-S(SF).0058 | 18X18 | SUP1 | LIGHT POLE | IS | 1564742460000 | TERRY A FRANCOIS BLVD | PNDG TERRY A FRANCOIS BLVD | TERRY A FRANCOIS BLVD | - | - | - | - |
| 69107 | N/A | Point | 1 | 1 | 200 - 270 | - | S255803 | 200-270 BRANNAN ST | 200-270 BRANNAN ST | F | F | - | F | 3072000 | 3072000 | - | - | NORTH SIDE | - | - | - | - | DELANCEY ST | DELANCEY ST | 102701 | 102701 | 37.78303157 | -122.39057735 | - | - | 1710539427000 | MTA | BACK IN ANGLE PARKING ONLY | DELANCEY ST to COLIN P KELLY JR ST (200 - 270) | - | IFO#250 OPP ENT #229 @ PM | - | - | - | - | - | 86223 | 1023148800000 | -122.39057735 | 37.78303157 | - | 1572220800000 | - | D6 | - | PARKING | REG | R(SF).0009 | 18X21 | SUP1 | 2IN IRON POST | IS | 1562149860000 | BRANNAN ST | 200 - 270 BRANNAN ST | 200 - 270 BRANNAN ST | 200 BRANNAN ST | - | COLIN P KELLY JR ST | COLIN P KELLY JR ST |
| 69108 | N/A | Point | - | - | - | - | S253120 | NORTH POINT ST: TAYLOR ST | - | F | F | - | F | 25592000 | 25592000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TAYLOR ST | NORTH POINT ST | 102720 | 102720 | 37.80634343 | -122.41543157 | NORTH POINT ST \ TAYLOR ST | TAYLOR ST \ NORTH POINT ST | 1710777342000 | mmadsen | BIKE WAYFINDING SIGN | NORTH POINT ST intersection | 0880 | UNDER SIGNAL LIGHT | - | - | - | - | - | 86224 | 1557149460000 | -122.41543157 | 37.80634343 | - | - | - | D3 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | SIGNAL POLE | IS | 1554298140000 | TAYLOR ST | - | - | - | - | - | - |
| 69109 | N/A | Point | 1 | 1 | 800 - 818 | LEFT ARROW | S288770 | 800-818 LARKIN ST | 800-818 LARKIN ST | F | F | - | F | 8130000 | 8130000 | - | - | EAST SIDE | - | - | - | - | OFARRELL ST | OFARRELL ST | 102752 | 102752 | 37.78540446 | -122.41794884 | - | - | 1748987182000 | middleware_editor | ONE WAY (LA) | OFARRELL ST to MYRTLE ST (800 - 818) | - | 140FT NORTH OF FARRELL | - | - | - | - | - | 86225 | - | -122.41794884 | 37.78540446 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP1 | 2IN IRON POST | IS | 1681986420000 | LARKIN ST | 800 - 818 LARKIN ST | 800 - 818 LARKIN ST | 800 LARKIN ST | - | MYRTLE ST | MYRTLE ST |
| 69110 | N/A | Point | 1 | 1 | 200 - 299 | - | S286724 | 200-299 PIERCE ST | 200-299 PIERCE ST | F | F | - | F | 10419000 | 10419000 | - | - | EAST SIDE | - | - | - | - | HAIGHT ST | HAIGHT ST | 102789 | 102789 | 37.77215429 | -122.43382848 | - | - | 1753213150000 | middleware_editor | BIKE RACK | HAIGHT ST to PAGE ST (200 - 299) | 285957 | 45' S OF NPL 214/3' FROM CURB | - | - | - | - | - | 86226 | 1672905600000 | -122.43382848 | 37.77215429 | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1671639420000 | PIERCE ST | 200 - 299 PIERCE ST | 200 - 299 PIERCE ST | 200 PIERCE ST | - | PAGE ST | PAGE ST |
| 69111 | N/A | Point | - | - | - | - | S287574 | COLUMBUS AVE: FILBERT ST \ VIA | - | T | T | - | F | 30710000 | 30710000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | FILBERT ST \ VIA BUFANO | COLUMBUS AVE \ FILBERT ST | 102804 | 102804 | 37.80112513 | -122.41137627 | COLUMBUS AVE \ FILBERT ST \ VIA BUFANO | VIA BUFANO \ COLUMBUS AVE \ FILBERT ST | 1710539427000 | MTA | SPEED LIMIT 25 | COLUMBUS AVE \ FILBERT ST intersection | - | - | - | - | - | - | - | 86227 | - | -122.41137627 | 37.80112513 | - | - | 1677628800000 | D3 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP1 | LIGHT POLE | RETD | 1676554620000 | VIA BUFANO | - | - | - | - | - | - |
| 69112 | N/A | Point | - | - | - | - | S129052 | NAGLEE AVE: HURON AVE | - | F | F | - | F | 21557000 | 21557000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | NAGLEE AVE | HURON AVE | 107332 | 107332 | 37.7132153652092 | -122.448022549562 | HURON AVE \ NAGLEE AVE | NAGLEE AVE \ HURON AVE | 1755268105000 | middleware_editor | ALL WAY | HURON AVE intersection | - | - | - | - | - | - | - | 86228 | 1208934000000 | -122.44810848 | 37.71321065 | - | 1495090800000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576640000 | NAGLEE AVE | - | - | - | - | - | - |
| 69113 | N/A | Point | - | - | - | - | S108198 | DRAKE ST: MUNICH ST | - | F | F | - | F | 21420000 | 21420000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DRAKE ST | DRAKE ST | 107343 | 107343 | 37.71074571 | -122.4369928 | MUNICH ST \ DRAKE ST | MUNICH ST \ DRAKE ST | 1731696544000 | middleware_editor | STOP | DRAKE ST intersection | - | 0 / 0 | - | - | - | - | - | 86229 | 290649600000 | -122.4369928 | 37.71074571 | - | 1683676800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373570100000 | MUNICH ST | - | - | - | - | - | - |
| 69114 | N/A | Point | - | - | - | - | S106837 | POWERS AVE: MISSION ST | - | F | F | - | F | 21339000 | 21339000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POWERS AVE | POWERS AVE | 107360 | 107360 | 37.74618268 | -122.41950511 | MISSION ST \ POWERS AVE | MISSION ST \ POWERS AVE | 1756936960000 | middleware_editor | ONE WAY (RA) | POWERS AVE intersection | - | 0 / MADE POWERS ONE-WAY WB COLERIDG..... | - | - | - | - | - | 86230 | 176108400000 | -122.41950511 | 37.74618268 | - | - | - | D9 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | UNKNOWN | IS | 1373569680000 | MISSION ST | - | - | - | - | - | - |
| 69115 | N/A | Point | 1 | 1 | 1800 - 1899 | LEFT ARROW | S274236 | 1800-1899 ELLIS ST | 1800-1899 ELLIS ST | F | F | - | F | 5189000 | 5189000 | - | - | SOUTH SIDE | - | - | - | - | PIERCE ST | PIERCE ST | 107379 | 107379 | 37.7818337 | -122.43663009 | - | - | 1721265644000 | middleware_editor | TA (SYM) SCHOOL BUS ONLY 7:30AM-9:30AM/3PM-6PM SCHOOL DAYS | PIERCE ST to SCOTT ST (1800 - 1899) | - | 206' WEST OF PIERCE | - | - | - | - | - | 86231 | 1621555200000 | -122.43663009 | 37.7818337 | - | 1633392000000 | 1633392000000 | D5 | - | OTHER REGULATORY | REG | R38(SF)4.0029 | 14X21 | SUP1 | 2IN IRON POST | RETD | 1630417140000 | ELLIS ST | 1800 - 1899 ELLIS ST | 1800 - 1899 ELLIS ST | 1800 ELLIS ST | - | SCOTT ST | SCOTT ST |
| 69116 | N/A | Point | 1 | 1 | 1900 - 1999 | - | S279034 | 1900-1999 LOWER GREAT HWY | 1900-1999 GREAT HWY | T | T | - | F | 8515000 | 8515000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | ORTEGA ST | ORTEGA ST | 107402 | 107402 | 37.75003957 | -122.5080641 | - | - | 1729301229000 | middleware_editor | SPEED HUMP | ORTEGA ST to PACHECO ST (1900 - 1999) | - | X IS LOWER GREAT HWY IFO 1906 | - | - | - | - | - | 86232 | - | -122.5080641 | 37.75003957 | - | 1637539200000 | - | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1637327040000 | GREAT HWY | 1900 - 1999 GREAT HWY | 1900 - 1999 GREAT HWY | 1900 GREAT HWY | - | PACHECO ST | PACHECO ST |
| 69117 | N/A | Point | - | - | - | LEFT ARROW | S267477 | MISSION ST: 8TH ST | - | F | F | - | F | 9102000 | 24311000 | - | - | SOUTH SIDE | - | - | - | - | ANGELOS ALY \ JULIA ST | 08TH ST | 107427 | 107427 | 37.7779469084032 | -122.412415317498 | - | MISSION ST \ 08TH ST | 1756309625000 | middleware_editor | TANSAT | 08TH ST intersection | - | 20' WEST OF JULIA ST. | - | - | - | - | - | 86233 | 1600364040000 | -122.41315769 | 37.77745742 | - | 1601967600000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1598355060000 | MISSION ST | 1166 - 1199 MISSION ST | - | - | - | 08TH ST | - |
| 69118 | N/A | Point | - | - | - | - | S272913 | BALBOA ST: 2ND AVE | - | F | F | - | F | 27224000 | 27224000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 2ND AVE | 02ND AVE | 107480 | 107480 | 37.77742986 | -122.45972482 | BALBOA ST \ 2ND AVE | BALBOA ST \ 02ND AVE | 1710539427000 | MTA | ALL WAY | 02ND AVE intersection | - | - | - | - | - | - | - | 86234 | 1269216000000 | -122.45972482 | 37.77742986 | - | 1616716800000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | MUNI POLE | IS | 1614850980000 | BALBOA ST | - | - | - | - | - | - |
| 69119 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S288075 | 2000-2099 41ST AVE | 2000-2099 41ST AVE | F | F | - | F | 1918000 | 1918000 | - | - | EAST SIDE | - | - | - | - | PACHECO ST | PACHECO ST | 107503 | 107503 | 37.7490482656347 | -122.499690848957 | - | - | 1749591867000 | middleware_editor | TA (SYM) NO PARKING 6AM-2PM FRIDAY | PACHECO ST to QUINTARA ST (2000 - 2099) | - | 100 FT SOUTH OF PACHECO OPP 2019 | - | - | - | - | - | 86235 | 1679641200000 | -122.49971931 | 37.74853856 | - | - | 1749590700000 | D4 | - | PARKING | REG | R37(SF).0475 | 18X21 | SUP2 | LIGHT POLE | RETD | 1678877820000 | 41ST AVE | 2000 - 2099 41ST AVE | 2000 - 2099 41ST AVE | 2000 41ST AVE | - | QUINTARA ST | QUINTARA ST |
| 69120 | N/A | Point | - | - | - | - | S276796 | CABRILLO ST: 33RD AVE | - | F | F | - | F | 27822000 | 27822000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CABRILLO ST | CABRILLO ST | 107523 | 107523 | 37.77404459 | -122.49290281 | 33RD AVE \ CABRILLO ST | 33RD AVE \ CABRILLO ST | 1752007067000 | middleware_editor | SLOW STREETS FAMILY, H/C, PED, SKATEBOARD, BIKE (SYM)(COMBO) | CABRILLO ST intersection | - | 15 FT AND 21 FT FROM CURB | - | - | - | - | - | 86236 | 1681369200000 | -122.49290281 | 37.77404459 | - | 1748019300000 | - | D1 | - | OTHER REGULATORY | REG | R(SF).0451 | 12X36 | SUP2 | CITY POST EMBEDDED ACHOR CUP 4 | IS | 1627909080000 | 33RD AVE | - | - | - | - | - | - |
| 69121 | N/A | Point | - | - | - | - | S100756 | LAKE MERCED BLVD: SKYLINE BLVD | - | F | F | - | F | 33518000 | 33518000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SKYLINE BLVD | SKYLINE BLVD | 107547 | 107547 | 37.73226789 | -122.49810692 | LAKE MERCED BLVD \ SKYLINE BLVD | LAKE MERCED BLVD \ SKYLINE BLVD | 1710539427000 | MTA | ONE WAY (RA) | SKYLINE BLVD intersection | - | 0 / 0 | - | - | - | - | - | 86237 | -402710400000 | -122.49810692 | 37.73226789 | - | - | - | D7 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | UNKNOWN | IS | 1373566560000 | LAKE MERCED BLVD | - | - | - | - | - | - |
| 69122 | N/A | Point | - | - | - | - | S116368 | 3RD ST: STEVENSON ST | - | F | F | - | F | 24639000 | 24639000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | STEVENSON ST | 03RD ST | 107567 | 107567 | 37.78702442 | -122.40302819 | 3RD ST \ STEVENSON ST | STEVENSON ST \ 03RD ST | 1710539427000 | MTA | FOUR SEASONS HOTEL (LA) | 03RD ST intersection | - | - | - | - | - | - | - | 86238 | 1048636800000 | -122.40302819 | 37.78702442 | - | - | - | D6 | - | OTHER GUIDE | GUIDE | G-F(SF).0047 | 30X24 | SUP1 | LIGHT POLE | IS | 1373572680000 | STEVENSON ST | - | - | - | - | - | - |
| 69123 | N/A | Point | 1 | 1 | 623 - 646 | RIGHT ARROW | S233225 | 623-646 HARRISON ST | 623-646 HARRISON ST | F | F | - | F | 6715000 | 6715000 | - | - | SOUTH SIDE | - | - | - | - | VASSAR PL | VASSAR PL | 107583 | 107583 | 37.78366156 | -122.39598285 | - | - | 1710539427000 | MTA | TA (SYM) PLO 9AM-6PM MON-SAT (5 MIN) | VASSAR PL to HAWTHORNE ST (623 - 646) | - | IFO #645 | - | - | - | - | - | 86239 | 1486043400000 | -122.39598285 | 37.78366156 | - | 1485993600000 | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0032 | 14X21 | SUP1 | 2IN IRON POST | IS | 1486025820000 | HARRISON ST | 623 - 646 HARRISON ST | 623 - 646 HARRISON ST | 623 HARRISON ST | - | HAWTHORNE ST | HAWTHORNE ST |
| 69124 | N/A | Point | - | - | - | - | S101900 | DIAMOND ST: 24TH ST | - | F | F | - | F | 25760000 | 25760000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DIAMOND ST | DIAMOND ST | 107604 | 107604 | 37.75115322 | -122.43629871 | 24TH ST \ DIAMOND ST | 24TH ST \ DIAMOND ST | 1710539427000 | MTA | STOP | DIAMOND ST intersection | - | 0 / 0 | - | - | - | - | - | 86240 | -394588800000 | -122.43629871 | 37.75115322 | - | 1594166400000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373566920000 | 24TH ST | - | - | - | - | - | - |
| 69125 | N/A | Point | 1 | 1 | 300 - 399 | - | S128197 | 300-399 POTRERO AVE | 300-399 POTRERO AVE | F | F | - | F | 10661000 | 10661000 | - | - | WEST SIDE | - | - | - | - | 16TH ST | 16TH ST | 107633 | 107633 | 37.76513557 | -122.40747698 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM MON WED FRI STCL | 16TH ST to 17TH ST (300 - 399) | - | OPP#381 | - | - | - | - | - | 86241 | 1196380800000 | -122.40747698 | 37.76513557 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0265 | 18X18 | SUP1 | LIGHT POLE | IS | 1373576400000 | POTRERO AVE | 300 - 399 POTRERO AVE | 300 - 399 POTRERO AVE | 300 POTRERO AVE | - | 17TH ST | 17TH ST |
| 69126 | N/A | Point | - | - | - | - | S285394 | LAKE ST: FUNSTON AVE | - | F | F | - | F | 27627000 | 27627000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LAKE ST | FUNSTON AVE | 107645 | 107645 | 37.7863335 | -122.47218534 | FUNSTON AVE \ LAKE ST | LAKE ST \ FUNSTON AVE | 1722391564000 | middleware_editor | SPEED HUMP | FUNSTON AVE intersection | - | ABOVE 25 MPH SIGN | - | - | - | - | - | 86242 | 1666051200000 | -122.47218534 | 37.7863335 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1665050460000 | LAKE ST | - | - | - | - | - | - |
| 69127 | N/A | Point | - | - | - | - | S289278 | CAYUGA AVE: SAN JUAN AVE | - | F | F | - | F | 21800000 | 21800000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CAYUGA AVE | CAYUGA AVE | 107663 | 107663 | 37.72509446 | -122.43793363 | SAN JUAN AVE \ CAYUGA AVE | SAN JUAN AVE \ CAYUGA AVE | 1728417096000 | middleware_editor | SLOW STREETS FAMILY, H/C, PED, SKATEBOARD, BIKE (SYM)(COMBO) | CAYUGA AVE intersection | - | 7 FT FROM CURB IN STREET | - | - | - | - | - | 86243 | - | -122.43793363 | 37.72509446 | - | - | 1728379800000 | D11 | - | OTHER REGULATORY | REG | R(SF).0451 | 12X36 | SUP2 | CITY POST EMBEDDED ACHOR CUP 4 | RETD | 1683538200000 | SAN JUAN AVE | - | - | - | - | - | - |
| 69128 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S274974 | 1000-1099 HAYES ST | 1000-1099 HAYES ST | F | F | - | F | 6822000 | 6822000 | - | - | NORTH SIDE | - | - | - | - | STEINER ST | STEINER ST | 107671 | 107671 | 37.77552148 | -122.43365652 | - | - | 1710539427000 | MTA | NO PED XING-USE CROSSWALK | STEINER ST to PIERCE ST (1000 - 1099) | - | 90' E OF PIERCE | - | - | - | - | - | 86244 | 1623239160000 | -122.43365652 | 37.77552148 | - | - | - | D5 | - | PEDESTRIAN | REG | R49(CA).0002 | 36X18 | SUP1 | 2 POST ALUMINUM | IS | 1622030940000 | HAYES ST | 1000 - 1099 HAYES ST | 1000 - 1099 HAYES ST | 1000 HAYES ST | - | PIERCE ST | PIERCE ST |
| 69129 | N/A | Point | - | - | - | - | S206952 | CHURCH ST: 16TH ST | - | F | F | - | F | 25726000 | 25726000 | - | - | SOUTH EAST CORNER | - | - | - | - | 16TH ST | CHURCH ST | 109388 | 109388 | 37.76462211 | -122.428571253 | CHURCH ST \ 16TH ST | 16TH ST \ CHURCH ST | 1710539427000 | MTA | TANSAT (RA) | CHURCH ST intersection | - | REINSTALL SIGN & POST TIED TO LIGHTPOLE | - | - | - | - | - | 86245 | - | -122.42866513 | 37.76450761 | - | - | - | D8 | - | TOW (TANSAT) | REG | R37(CA).0094 | 18X21 | SUP2 | 2IN IRON POST | IS | 1403011380000 | 16TH ST | - | - | - | - | - | - |
| 69130 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S289328 | 1100-1199 VALENCIA ST | 1100-1199 VALENCIA ST | F | F | - | F | 13071000 | 13071000 | - | SHOULD BE RETIRED | EAST SIDE | - | - | - | - | 22ND ST | 22ND ST | 109411 | 109411 | 37.753881295 | -122.420829783 | - | - | 1743701898000 | middleware_editor | BUS LANE CURB | 22ND ST to 23RD ST (1100 - 1199) | - | SECTION 5 ( 405--495 FT ) FROM 22ND ST | - | - | - | - | - | 86246 | 1686121200000 | -122.42088812 | 37.75449894 | - | 1728061200000 | 1743701820000 | D8 | - | OTHER WARNING | WARNING | W(SF).0118 | 72X18 | SUP2 | ANCHORS | RETD | 1683707700000 | VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 VALENCIA ST | - | 23RD ST | 23RD ST |
| 69131 | N/A | Point | - | - | - | - | S265227 | 25TH ST: SANCHEZ ST | - | F | F | - | F | 25645000 | 25645000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 25TH ST | 25TH ST | 109418 | 109418 | 37.7499645 | -122.42950009 | SANCHEZ ST \ 25TH ST | SANCHEZ ST \ 25TH ST | 1711491517000 | middleware_editor | SPEED HUMPS | 25TH ST intersection | - | - | - | - | - | - | - | 86247 | 292032000000 | -122.42950009 | 37.7499645 | - | 1592784000000 | - | D8 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1592390400000 | SANCHEZ ST | - | - | - | - | - | - |
| 69132 | N/A | Point | - | - | - | - | S100070 | LONDON ST: PERSIA AVE | - | F | F | - | F | 21725000 | 21725000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LONDON ST | PERSIA AVE | 109430 | 109430 | 37.722859201 | -122.435231646 | PERSIA AVE \ LONDON ST | LONDON ST \ PERSIA AVE | 1710539427000 | MTA | STOP | PERSIA AVE intersection | - | 0 / 0 | - | - | - | - | - | 86248 | -406425600000 | -122.4352084 | 37.72276373 | - | 1594684800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373566320000 | LONDON ST | - | - | - | - | - | - |
| 69133 | N/A | Point | - | - | - | - | S100840 | 46TH AVE: POINT LOBOS AVE | - | F | F | - | F | 28002000 | 28002000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 46TH AVE | 46TH AVE | 109431 | 109431 | 37.7799821 | -122.50729998 | POINT LOBOS AVE \ 46TH AVE | POINT LOBOS AVE \ 46TH AVE | 1710539427000 | MTA | STOP | 46TH AVE intersection | - | - | - | - | - | - | - | 86249 | -402389999000 | -122.50729998 | 37.7799821 | - | - | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | POINT LOBOS AVE | - | - | - | - | - | - |
| 69134 | N/A | Point | - | - | - | - | S104423 | VARENNES ST: UNION ST | - | F | F | - | F | 25342000 | 25342000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VARENNES ST | VARENNES ST | 109432 | 109432 | 37.80073684 | -122.40680105 | UNION ST \ VARENNES ST | UNION ST \ VARENNES ST | 1710539427000 | MTA | STOP | VARENNES ST intersection | - | - | - | - | - | - | - | 86250 | -3916800000 | -122.40680105 | 37.80073684 | - | 892141200000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568900000 | UNION ST | - | - | - | - | - | - |
| 69135 | N/A | Point | - | - | - | - | S105248 | GOETTINGEN ST: BACON ST | - | F | F | - | F | 20887000 | 20887000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GOETTINGEN ST | BACON ST | 109439 | 109439 | 37.726929235 | -122.406652999 | BACON ST \ GOETTINGEN ST | GOETTINGEN ST \ BACON ST | 1736968529000 | middleware_editor | STOP | BACON ST intersection | - | 0 / 0 | - | - | - | - | - | 86251 | 64454400000 | -122.40656538 | 37.72685852 | - | 1736865000000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569140000 | GOETTINGEN ST | - | - | - | - | - | - |
| 69136 | N/A | Point | - | - | - | - | S105408 | FRANCE AVE: NAPLES ST | - | F | F | - | F | 21713000 | 21713000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | NAPLES ST | FRANCE AVE | 109465 | 109465 | 37.717739777 | -122.433693037 | FRANCE AVE \ NAPLES ST | NAPLES ST \ FRANCE AVE | 1710539427000 | MTA | STOP | FRANCE AVE intersection | - | 0 / 00 | - | - | - | - | - | 86252 | 71366400000 | -122.43355535 | 37.71774402 | - | 1113523200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569200000 | NAPLES ST | - | - | - | - | - | - |
| 69137 | N/A | Point | - | - | - | - | S240091 | BALTIMORE WAY: SOUTH HILL BLVD | - | F | F | - | F | 21374000 | 21374000 | - | - | SOUTH WEST CORNER | - | - | - | - | SOUTH HILL BLVD | BALTIMORE WAY | 109535 | 109535 | 37.71001367 | -122.43072468 | BALTIMORE WAY \ SOUTH HILL BLVD | SOUTH HILL BLVD \ BALTIMORE WAY | 1710539427000 | MTA | BALTIMORE WAY | BALTIMORE WAY intersection | - | - | - | - | - | - | - | 86253 | 1511365140000 | -122.4306764 | 37.71016645 | - | 1511308800000 | - | D11 | - | STREET NAME | GUIDE | D3-1.0165 | 36X08 | SUP2 | LIGHT POLE | IS | 1509527460000 | SOUTH HILL BLVD | - | - | - | - | - | - |
| 69138 | N/A | Point | - | - | - | - | S274055 | JERSEY ST: DIAMOND ST | - | F | F | - | F | 25759000 | 25759000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DIAMOND ST | DIAMOND ST | 109595 | 109595 | 37.75036056 | -122.43622245 | JERSEY ST \ DIAMOND ST | JERSEY ST \ DIAMOND ST | 1710539427000 | MTA | SPEED HUMPS AHEAD | DIAMOND ST intersection | - | - | - | - | - | - | - | 86254 | 90720000000 | -122.43622245 | 37.75036056 | - | 1621468800000 | - | D8 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1618823940000 | JERSEY ST | - | - | - | - | - | - |
| 69139 | N/A | Point | 1 | 1 | 300 - 399 | - | S289153 | 100-199 HARBOR RD | 300-399 HARBOR RD | F | F | - | F | 6672000 | 6672000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | INGALLS ST | INGALLS ST | 109598 | 109598 | 37.73367434 | -122.38062521 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | INGALLS ST to BERTHA LN (300 - 399) | - | 10W / @ PM 10'W OF INGALLS | - | - | - | - | - | 86255 | 1683158400000 | -122.38062521 | 37.73367434 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1682946300000 | HARBOR RD | 300 - 399 HARBOR RD | 300 - 399 HARBOR RD | 300 HARBOR RD | - | BERTHA LN | BERTHA LN |
| 69140 | N/A | Point | 1 | 1 | 300 - 399 | - | S289154 | 100-199 HARBOR RD | 300-399 HARBOR RD | F | F | - | F | 6672000 | 6672000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | INGALLS ST | INGALLS ST | 109599 | 109599 | 37.73367434 | -122.38062521 | - | - | 1745880208000 | middleware_editor | SPEED HUMPS AHEAD | INGALLS ST to BERTHA LN (300 - 399) | - | 45' EAST OF BERTHA LANE | - | - | - | - | - | 86256 | 1683183600000 | -122.38062521 | 37.73367434 | - | 1745876700000 | - | D10 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1682946360000 | HARBOR RD | 300 - 399 HARBOR RD | 300 - 399 HARBOR RD | 300 HARBOR RD | - | BERTHA LN | BERTHA LN |
| 69141 | N/A | Point | - | - | - | - | S261843 | 24TH AVE: QUINTARA ST | - | F | F | - | F | 23269000 | 23269000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | QUINTARA ST | 24TH AVE | 110858 | 110858 | 37.74840903 | -122.48144024 | 24TH AVE \ QUINTARA ST | QUINTARA ST \ 24TH AVE | 1735579677000 | middleware_editor | SPEED HUMPS | 24TH AVE intersection | - | - | - | - | - | - | - | 86257 | -70934400000 | -122.48144024 | 37.74840903 | - | 1582848000000 | - | D4 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | UTILITY POLE | IS | 1582624320000 | QUINTARA ST | - | - | - | - | - | - |
| 69142 | N/A | Point | 1 | 1 | 600 - 699 | - | S262912 | 600-699 CLARENDON AVE | 600-699 CLARENDON AVE | T | T | - | F | 4076000 | 4076000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | OLYMPIA WAY | OLYMPIA WAY | 110880 | 110880 | 37.751748508 | -122.461307592 | - | - | 1710539427000 | MTA | RIGHT LANE MUST TURN RIGHT | OLYMPIA WAY to LAGUNA HONDA BLVD (600 - 699) | 015594 | 50' EAST OF LAGUNA HONDA | - | - | - | - | - | 86258 | 281318400000 | -122.45900215 | 37.75171522 | - | - | - | D7 | - | OTHER REGULATORY | REG | R3-7.0005 | 30X30 | SUP2 | 2IN IRON POST | IS | 1585651320000 | CLARENDON AVE | 600 - 699 CLARENDON AVE | 600 - 699 CLARENDON AVE | 600 CLARENDON AVE | - | LAGUNA HONDA BLVD | LAGUNA HONDA BLVD |
| 69143 | N/A | Point | - | - | - | - | S283822 | MISSION ST: 19TH ST | - | T | T | - | F | 24145000 | 24145000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MISSION ST | 19TH ST | 110915 | 110915 | 37.760156445 | -122.419300452 | 19TH ST \ MISSION ST | MISSION ST \ 19TH ST | 1710539427000 | MTA | SPEED LIMIT 20 | 19TH ST intersection | - | - | - | - | - | - | - | 86259 | 1663545600000 | -122.41920604 | 37.76023536 | - | - | - | D9 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | OVERHEAD MAST ARM | IS | 1656666720000 | MISSION ST | - | - | - | - | - | - |
| 69144 | N/A | Point | - | - | - | - | S283824 | MISSION ST: 21ST ST | - | T | T | - | F | 24113000 | 24113000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MISSION ST | MISSION ST | 110917 | 110917 | 37.756955878 | -122.418994907 | 21ST ST \ MISSION ST | 21ST ST \ MISSION ST | 1710539427000 | MTA | SPEED LIMIT 20 | MISSION ST intersection | - | - | - | - | - | - | - | 86260 | 1663545600000 | -122.41890103 | 37.7570354 | - | - | - | D9 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | OVERHEAD MAST ARM | IS | 1656669300000 | 21ST ST | - | - | - | - | - | - |
| 69145 | N/A | Point | - | - | - | - | S283829 | MISSION ST: 26TH ST | - | T | T | - | F | 21306000 | 21306000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 26TH ST | MISSION ST | 110922 | 110922 | 37.748947674 | -122.418226898 | MISSION ST \ 26TH ST | 26TH ST \ MISSION ST | 1710539427000 | MTA | SPEED LIMIT 20 | MISSION ST intersection | - | - | - | - | - | - | - | 86261 | 1663545600000 | -122.41813525 | 37.74904129 | - | - | - | D9 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | OVERHEAD MAST ARM | IS | 1656671400000 | 26TH ST | - | - | - | - | - | - |
| 69146 | N/A | Point | - | - | - | - | S266182 | 19TH AVE: CLEMENT ST | - | F | F | - | F | 27506000 | 27506000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 110938 | 110938 | 37.78230838 | -122.47844351 | 19TH AVE \ CLEMENT ST | 19TH AVE \ CLEMENT ST | 1715356419000 | middleware_editor | SPEED HUMPS | CLEMENT ST intersection | - | IFO 194 | - | - | - | - | - | 86262 | -74908800000 | -122.47844351 | 37.78230838 | - | 1594684800000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1594645140000 | 19TH AVE | - | - | - | - | - | - |
| 69147 | N/A | Point | - | - | - | - | S288853 | EXCELSIOR AVE: MOSCOW ST | - | F | F | - | F | 21621000 | 21621000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 110980 | 110980 | 37.722807213 | -122.426595108 | MOSCOW ST \ EXCELSIOR AVE | MOSCOW ST \ EXCELSIOR AVE | 1710539427000 | MTA | EXCELSIOR (CHINA) | EXCELSIOR AVE intersection | - | <--- 900 (CHINA) | - | - | - | - | - | 86263 | 1389052800000 | -122.42646815 | 37.7228256 | - | 1433462400000 | - | D11 | - | STREET NAME | GUIDE | D3-1.2060 | 36X08 | SUP2 | 3IN IRON POST | IS | 1682428740000 | MOSCOW ST | - | - | - | - | - | - |
| 69148 | N/A | Point | - | - | - | - | S288854 | EXCELSIOR AVE: NAPLES ST | - | F | F | - | F | 21642000 | 21642000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | NAPLES ST | EXCELSIOR AVE | 110981 | 110981 | 37.723929112 | -122.428992098 | EXCELSIOR AVE \ NAPLES ST | NAPLES ST \ EXCELSIOR AVE | 1729694561000 | middleware_editor | EXCELSIOR (CHINA) | EXCELSIOR AVE intersection | - | <--- 600 (CHINA) | - | - | - | - | - | 86264 | 1389052800000 | -122.42883653 | 37.72395457 | - | 1729597800000 | - | D11 | - | STREET NAME | GUIDE | D3-1.2060 | 36X08 | SUP2 | 3IN IRON POST | IS | 1682428980000 | NAPLES ST | - | - | - | - | - | - |
| 69149 | N/A | Point | - | - | - | - | S288855 | EXCELSIOR AVE: LISBON ST | - | F | F | - | F | 21687000 | 21687000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LISBON ST | EXCELSIOR AVE | 110982 | 110982 | 37.725107994 | -122.431383934 | EXCELSIOR AVE \ LISBON ST | LISBON ST \ EXCELSIOR AVE | 1710539427000 | MTA | EXCELSIOR (CHINA) | EXCELSIOR AVE intersection | - | <--- 300 (CHINA) | - | - | - | - | - | 86265 | 1389052800000 | -122.4312534 | 37.72510658 | - | 1433462400000 | - | D11 | - | STREET NAME | GUIDE | D3-1.2060 | 36X08 | SUP2 | 3IN IRON POST | IS | 1682429460000 | LISBON ST | - | - | - | - | - | - |
| 69150 | N/A | Point | - | - | - | - | S274610 | MISSION ST: 26TH ST | - | F | F | - | F | 21306000 | 21306000 | - | - | SOUTH EAST CORNER | - | - | - | - | 26TH ST | MISSION ST | 111090 | 111090 | 37.748997459 | -122.418007845 | MISSION ST \ 26TH ST | 26TH ST \ MISSION ST | 1710539427000 | MTA | MISSION ST | MISSION ST intersection | - | - | - | - | - | - | - | 86266 | 1459123200000 | -122.41813525 | 37.74904129 | - | 1649635200000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1207 | 36X08 | SUP2 | LIGHT POLE | IS | 1620643680000 | 26TH 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.