MTA.signshop_assets
No additional information has been provided for this dataset.
Between for ranges (e.g., 10,100)Regex for pattern matchingCase sensitive for exact matches
| ID | Feature ID | Geometry Type | ACCEPTED | ACTIVE | ADDRANGE | ARROW DIR | ASSET ID | ASSET NAME | ASSET NAME 1 | BAPA | BOOM TRUCK | CANCEL | CLEARANCE PERMIT | CNN | CNN 1 | COMBOKEY | CONDITION | CORNER SIDE FACING | CREATED DATE | CREATED USER | CURLYIDS | ETL | FROM ST | FROM ST 1 | GISOBJID | GLOBALID UDFCHAR44 | GPS LATITUDE | GPS LONGITUDE | INTERSECTION | INTERSECTION 1 | LAST EDITED DATE | LAST EDITED USER | LEGEND | LIMITS | LOCATION TRACK ID | LOC SPEC | NEW PURPOSE | NEW SIGN CODE | NEW SIGN LEGEND | NEW SIGN SIZE | NUM OF ASSETS | OBJECTID 1 | ORIG INSTALL DATE | POINT X | POINT Y | PURPOSE | REPLACEMENT DATE | RETIREMENT DATE | SF SUP DISTRICT | SHEETING | SIGN CATEGORY | SIGN CLASS | SIGN CODE | SIGN SIZE | SIGN SUPERVISOR | SIGN SUPPORT | STATUS CODE | STATUS DATE | STREETNAME | STREET ADDRESS RANGE | STREET ADDRESS RANGE 1 | STREET BLOCK | STREET VIEW | TO ST | TO ST 1 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17026 | N/A | Point | - | - | - | - | S105768 | ELLIS ST: POWELL ST | - | F | F | - | F | 24894000 | 24894000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POWELL ST | ELLIS ST | 2109 | 2109 | 37.78549156 | -122.40785252 | ELLIS ST \ POWELL ST | POWELL ST \ ELLIS ST | 1710539427000 | MTA | ONE WAY (RA) | ELLIS ST intersection | - | 0 / MADE ELLIS ONE-WAY WB BETMARKET..... | - | - | - | - | - | 34101 | 100828800000 | -122.40785252 | 37.78549156 | - | - | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373569320000 | POWELL ST | - | - | - | - | - | - |
| 17027 | N/A | Point | - | - | - | - | S105769 | ELLIS ST: MASON ST | - | F | F | - | F | 24900000 | 24900000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 2110 | 2110 | 37.78528292 | -122.40949753 | MASON ST \ ELLIS ST | MASON ST \ ELLIS ST | 1752169829000 | middleware_editor | ONE WAY (RA) | ELLIS ST intersection | - | - | - | - | - | - | - | 34102 | 100854000000 | -122.40949753 | 37.78528292 | - | 1752167400000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569320000 | MASON ST | - | - | - | - | - | - |
| 17028 | N/A | Point | - | - | - | - | S105770 | ELLIS ST: JONES ST | - | F | F | - | F | 24936000 | 24936000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JONES ST | ELLIS ST | 2111 | 2111 | 37.78486625 | -122.41278213 | ELLIS ST \ JONES ST | JONES ST \ ELLIS ST | 1739485020000 | middleware_editor | ONE WAY (RA) | ELLIS ST intersection | - | 0 / MADE ELLIS ONE-WAY WB BETMARKET..... | - | - | - | - | - | 34103 | 100832400000 | -122.41278213 | 37.78486625 | - | 1739457600000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569320000 | JONES ST | - | - | - | - | - | - |
| 17029 | N/A | Point | - | - | - | - | S105771 | WAWONA ST: 33RD AVE | - | F | F | - | F | 23350000 | 23350000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 33RD AVE | WAWONA ST | 2112 | 2112 | 37.73792956 | -122.49036419 | WAWONA ST \ 33RD AVE | 33RD AVE \ WAWONA ST | 1710539427000 | MTA | STOP | WAWONA ST intersection | - | 0 / 0 | - | - | - | - | - | 34104 | 100915200000 | -122.49036419 | 37.73792956 | - | 1513209600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569320000 | 33RD AVE | - | - | - | - | - | - |
| 17030 | N/A | Point | 1 | 1 | 4057 - 4099 | - | S105784 | 0-4099 ALEMANY BLVD | 4057-4099 ALEMANY BLVD | F | F | - | F | 2185102 | 2185102 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | CHESTER AVE | CHESTER AVE | 2122 | 2122 | 37.70952496 | -122.47078105 | - | - | 1727382859000 | middleware_editor | ONE WAY (RA) | CHESTER AVE to JUNIPERO SERRA BLVD (4057 - 4099) -- SOUTH -- | - | C LINE / 0 | - | - | - | - | - | 34105 | 101520000000 | -122.47078105 | 37.70952496 | - | - | - | D7 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | LIGHT POLE | IS | 1373569320000 | ALEMANY BLVD | 4057 - 4099 ALEMANY BLVD | 4057 - 4099 ALEMANY BLVD | 4057 ALEMANY BLVD | - | JUNIPERO SERRA BLVD | JUNIPERO SERRA BLVD |
| 17031 | N/A | Point | - | - | - | - | S106115 | LAKEVIEW AVE: CAPITOL AVE | - | F | F | - | F | 22581000 | 22581000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LAKEVIEW AVE | CAPITOL AVE | 2125 | 2125 | 37.7182297 | -122.45918721 | CAPITOL AVE \ LAKEVIEW AVE | LAKEVIEW AVE \ CAPITOL AVE | 1733238101000 | middleware_editor | STOP | CAPITOL AVE intersection | - | 0 / 0 | - | - | - | - | - | 34106 | 123724800000 | -122.45918721 | 37.7182297 | - | 1733148900000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | LAKEVIEW AVE | - | - | - | - | - | - |
| 17032 | N/A | Point | - | - | - | - | S106116 | LAKEVIEW AVE: CAPITOL AVE | - | F | F | - | F | 22581000 | 22581000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LAKEVIEW AVE | CAPITOL AVE | 2126 | 2126 | 37.7182297 | -122.45918721 | CAPITOL AVE \ LAKEVIEW AVE | LAKEVIEW AVE \ CAPITOL AVE | 1733237975000 | middleware_editor | STOP | CAPITOL AVE intersection | - | 0 / 0 | - | - | - | - | - | 34107 | 123724800000 | -122.45918721 | 37.7182297 | - | 1733150100000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569440000 | LAKEVIEW AVE | - | - | - | - | - | - |
| 17033 | N/A | Point | - | - | - | - | S106117 | TOLAND ST: JERROLD AVE | - | F | F | - | F | 20799000 | 20799000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | TOLAND ST | TOLAND ST | 2127 | 2127 | 37.74409606 | -122.39874696 | JERROLD AVE \ TOLAND ST | JERROLD AVE \ TOLAND ST | 1753809365000 | middleware_editor | STOP | TOLAND ST intersection | - | 0 / 0 | - | - | - | - | - | 34108 | 123753600000 | -122.39874696 | 37.74409606 | - | 1219042800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569440000 | JERROLD AVE | - | - | - | - | - | - |
| 17034 | N/A | Point | - | - | - | - | S105187 | EDNA ST: MONTEREY BLVD | - | F | T | - | F | 22162000 | 22162000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MONTEREY BLVD | EDNA ST | 2129 | 2129 | 37.73154905 | -122.4465784 | EDNA ST \ MONTEREY BLVD | MONTEREY BLVD \ EDNA ST | 1756396796000 | middleware_editor | ONE WAY (RA) | EDNA ST intersection | - | - | - | - | - | - | - | 34109 | 58435200000 | -122.4465784 | 37.73154905 | - | - | - | D7 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | LIGHT POLE | IS | 1373569140000 | MONTEREY BLVD | - | - | - | - | - | - |
| 17035 | N/A | Point | - | - | - | - | S105069 | 9TH AVE: LAKE ST | - | F | F | - | F | 27608000 | 27608000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAKE ST | 09TH AVE | 2130 | 2130 | 37.7864359464979 | -122.467832341785 | 09TH AVE \ LAKE ST | LAKE ST \ 09TH AVE | 1750791508000 | middleware_editor | STOP | 09TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 34110 | 43570800000 | -122.46789846 | 37.78653345 | - | 1461135600000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569140000 | LAKE ST | - | - | - | - | - | - |
| 17036 | N/A | Point | - | - | - | - | S105190 | IRVING ST: 41ST AVE | - | F | F | - | F | 27798000 | 27798000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 41ST AVE | 41ST AVE | 2131 | 2131 | 37.76252208 | -122.50069817 | IRVING ST \ 41ST AVE | IRVING ST \ 41ST AVE | 1710539427000 | MTA | STOP | 41ST AVE intersection | - | 0 / 0 | - | - | - | - | - | 34111 | 58492800000 | -122.50069817 | 37.76252208 | - | 1511913600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569140000 | IRVING ST | - | - | - | - | - | - |
| 17037 | N/A | Point | - | - | - | - | S105191 | IRVING ST: 41ST AVE | - | F | F | - | F | 27798000 | 27798000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 41ST AVE | 41ST AVE | 2132 | 2132 | 37.76252208 | -122.50069817 | IRVING ST \ 41ST AVE | IRVING ST \ 41ST AVE | 1710539427000 | MTA | STOP | 41ST AVE intersection | - | 0 / 0 | - | - | - | - | - | 34112 | 58492800000 | -122.50069817 | 37.76252208 | - | 1511913600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569140000 | IRVING ST | - | - | - | - | - | - |
| 17038 | N/A | Point | - | - | - | - | S105196 | 5TH AVE: CLEMENT ST | - | F | F | - | F | 27251000 | 27251000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | 05TH AVE | 2136 | 2136 | 37.7829892 | -122.46335053 | 5TH AVE \ CLEMENT ST | CLEMENT ST \ 05TH AVE | 1739488803000 | middleware_editor | STOP | 05TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 34113 | 59011200000 | -122.46335053 | 37.7829892 | - | 1739457000000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569140000 | CLEMENT ST | - | - | - | - | - | - |
| 17039 | N/A | Point | - | - | - | - | S104988 | HOWARD ST: 2ND ST | - | F | F | - | F | 24540000 | 24540000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HOWARD ST | 02ND ST | 2638 | 2638 | 37.78677895 | -122.39825696 | 2ND ST \ HOWARD ST | HOWARD ST \ 02ND ST | 1710539427000 | MTA | ONE WAY (RA) | 02ND ST intersection | - | 0 / MADE HOWARD 1-WAY WB BET BEALE ..... | - | - | - | - | - | 34114 | 38966400000 | -122.39825696 | 37.78677895 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373569080000 | HOWARD ST | - | - | - | - | - | - |
| 17040 | N/A | Point | - | - | - | RIGHT ARROW | S104989 | HOWARD ST: NEW MONTGOMERY ST | - | F | T | - | F | 24596000 | 24596000 | - | - | SOUTH SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | NEW MONTGOMERY ST | HOWARD ST | 2639 | 2639 | 37.78620949 | -122.39897717 | HOWARD ST \ NEW MONTGOMERY ST | NEW MONTGOMERY ST \ HOWARD ST | 1715014073000 | middleware_editor | ONE WAY (RA) | HOWARD ST intersection | - | 30' W. E-LINE X-WALK | - | - | - | - | - | 34115 | 38966400000 | -122.39897717 | 37.78620949 | - | 1714986900000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373569080000 | NEW MONTGOMERY ST | - | - | - | - | - | - |
| 17041 | N/A | Point | - | - | - | - | S104990 | HOWARD ST: 4TH ST | - | F | F | - | F | 24627000 | 24627000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HOWARD ST | 04TH ST | 2640 | 2640 | 37.78325924 | -122.40270815 | 4TH ST \ HOWARD ST | HOWARD ST \ 04TH ST | 1738018095000 | middleware_editor | ONE WAY (RA) | 04TH ST intersection | - | 0 / MADE HOWARD 1-WAY WB BET BEALE ..... | - | - | - | - | - | 34116 | 38970000000 | -122.40270815 | 37.78325924 | - | 1737987300000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373569080000 | HOWARD ST | - | - | - | - | - | - |
| 17042 | N/A | Point | - | - | - | - | S103827 | POLK ST: BROADWAY | - | F | T | - | F | 25315000 | 25315000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BROADWAY | BROADWAY | 4925 | 4925 | 37.7959454 | -122.42176817 | POLK ST \ BROADWAY | POLK ST \ BROADWAY | 1737752591000 | middleware_editor | NO LEFT TURN (SYM) | BROADWAY intersection | - | 0 / 00 | - | - | - | - | - | 34117 | -90806400000 | -122.42176817 | 37.7959454 | - | 1737717300000 | - | D3 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1373568720000 | POLK ST | - | - | - | - | - | - |
| 17043 | N/A | Point | 1 | 1 | 301 - 399 | - | S103828 | 301-399 CLAY ST | 301-399 CLAY ST | F | F | - | F | 4082000 | 4082000 | - | - | SOUTH SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | FRONT ST | FRONT ST | 4926 | 4926 | 37.79508827 | -122.39973938 | - | - | 1710539427000 | MTA | ONE WAY (LA) | FRONT ST to BATTERY ST (301 - 399) | - | 0 / GARAGE/350 NEAR | - | - | - | - | - | 34118 | -88300800000 | -122.39973938 | 37.79508827 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373568720000 | CLAY ST | 301 - 399 CLAY ST | 301 - 399 CLAY ST | 301 CLAY ST | - | BATTERY ST | BATTERY ST |
| 17044 | N/A | Point | - | - | - | - | S103541 | CAPP ST: 21ST ST | - | F | F | - | F | 24084000 | 24084000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CAPP ST | 21ST ST | 4929 | 4929 | 37.75710093 | -122.4178119 | 21ST ST \ CAPP ST | CAPP ST \ 21ST ST | 1719613445000 | middleware_editor | STOP | 21ST ST intersection | - | - | - | - | - | - | - | 34119 | -165196800000 | -122.4178119 | 37.75710093 | - | 1685577600000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568660000 | CAPP ST | - | - | - | - | - | - |
| 17045 | N/A | Point | - | - | - | - | S103542 | CAPP ST: 21ST ST | - | F | F | - | F | 24084000 | 24084000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CAPP ST | 21ST ST | 4930 | 4930 | 37.75710093 | -122.4178119 | 21ST ST \ CAPP ST | CAPP ST \ 21ST ST | 1718224731000 | middleware_editor | STOP | 21ST ST intersection | - | - | - | - | - | - | - | 34120 | -165196800000 | -122.4178119 | 37.75710093 | - | 1582588800000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568660000 | CAPP ST | - | - | - | - | - | - |
| 17046 | N/A | Point | - | - | - | - | S106454 | ATHENS ST: CORDOVA ST | - | F | F | - | F | 21416000 | 21416000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ATHENS ST | CORDOVA ST | 4949 | 4949 | 37.71226106 | -122.43584332 | CORDOVA ST \ ATHENS ST | ATHENS ST \ CORDOVA ST | 1731693225000 | middleware_editor | STOP | CORDOVA ST intersection | - | 0 / 0 | - | - | - | - | - | 34121 | 141264000000 | -122.43584332 | 37.71226106 | - | 1595203200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569560000 | ATHENS ST | - | - | - | - | - | - |
| 17047 | N/A | Point | - | - | - | - | S106455 | ATHENS ST: CORDOVA ST | - | F | F | - | F | 21416000 | 21416000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ATHENS ST | CORDOVA ST | 4950 | 4950 | 37.71226106 | -122.43584332 | CORDOVA ST \ ATHENS ST | ATHENS ST \ CORDOVA ST | 1731693200000 | middleware_editor | STOP | CORDOVA ST intersection | - | 0 / 0 | - | - | - | - | - | 34122 | 141264000000 | -122.43584332 | 37.71226106 | - | 1595376000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569560000 | ATHENS ST | - | - | - | - | - | - |
| 17048 | N/A | Point | - | - | - | - | S106456 | 21ST AVE: QUINTARA ST | - | F | F | - | F | 23211000 | 23211000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | QUINTARA ST | 21ST AVE | 4951 | 4951 | 37.7485509 | -122.47822416 | 21ST AVE \ QUINTARA ST | QUINTARA ST \ 21ST AVE | 1710539427000 | MTA | STOP | 21ST AVE intersection | - | 0 / 0 | - | - | - | - | - | 34123 | 141264000000 | -122.47822416 | 37.7485509 | - | 1664755200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569560000 | QUINTARA ST | - | - | - | - | - | - |
| 17049 | N/A | Point | - | - | - | - | S107897 | HAYES ST: OCTAVIA ST | - | F | F | - | F | 25925000 | 25925000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HAYES ST | OCTAVIA ST | 4953 | 4953 | 37.77668756 | -122.4245137 | OCTAVIA ST \ HAYES ST | HAYES ST \ OCTAVIA ST | 1743716484000 | middleware_editor | STOP | OCTAVIA ST intersection | - | - | - | - | - | - | - | 34124 | 261302400000 | -122.4245137 | 37.77668756 | - | 1743672600000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570040000 | HAYES ST | - | - | - | - | - | - |
| 17050 | N/A | Point | - | - | - | - | S107901 | BANKS ST: JARBOE AVE | - | F | F | - | F | 21074000 | 21074000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BANKS ST | BANKS ST | 4956 | 4956 | 37.7382792 | -122.41274598 | JARBOE AVE \ BANKS ST | JARBOE AVE \ BANKS ST | 1747771810000 | middleware_editor | DO NOT ENTER | BANKS ST intersection | - | 00 / MAKE ONE WAY SOUTH BOUND AND ROAD | - | - | - | - | - | 34125 | 261734400000 | -122.41274598 | 37.7382792 | - | 1747765260000 | - | D9 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570040000 | JARBOE AVE | - | - | - | - | - | - |
| 17051 | N/A | Point | - | - | - | - | S107902 | BANKS ST: JARBOE AVE | - | F | F | - | F | 21074000 | 21074000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BANKS ST | BANKS ST | 4957 | 4957 | 37.7382792 | -122.41274598 | JARBOE AVE \ BANKS ST | JARBOE AVE \ BANKS ST | 1743021915000 | middleware_editor | DO NOT ENTER | BANKS ST intersection | - | 00 / MAKE ONE WAY SOUTH BOUND AND ROAD | - | - | - | - | - | 34126 | 261734400000 | -122.41274598 | 37.7382792 | - | - | - | D9 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570040000 | JARBOE AVE | - | - | - | - | - | - |
| 17052 | N/A | Point | - | - | - | - | S107903 | BANKS ST: CORTLAND AVE | - | F | F | - | F | 21069000 | 21069000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BANKS ST | CORTLAND AVE | 4958 | 4958 | 37.73931147 | -122.41265699 | CORTLAND AVE \ BANKS ST | BANKS ST \ CORTLAND AVE | 1746568384000 | middleware_editor | ONE WAY (RA) | CORTLAND AVE intersection | - | 100N / MAKE ONE WAY SOUTH BOUND AND ROAD | - | - | - | - | - | 34127 | 261734400000 | -122.41265699 | 37.73931147 | - | - | - | D9 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | 2IN IRON POST | IS | 1373570040000 | BANKS ST | - | - | - | - | - | - |
| 17053 | N/A | Point | - | - | - | - | S107905 | PINE ST: BATTERY ST | - | T | T | - | F | 24671000 | 24671000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BATTERY ST | BATTERY ST | 4959 | 4959 | 37.79225795 | -122.39976335 | PINE ST \ BATTERY ST | PINE ST \ BATTERY ST | 1750962899000 | middleware_editor | ONE WAY (RA) | BATTERY ST intersection | - | 0 / 0 | - | - | - | - | - | 34128 | 263199600000 | -122.39976335 | 37.79225795 | - | 1412665200000 | - | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373570040000 | PINE ST | - | - | - | - | - | - |
| 17054 | N/A | Point | - | - | - | - | S107906 | GEARY ST: GRANT AVE | - | F | F | - | F | 24655000 | 24655000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GEARY ST | GRANT AVE | 4960 | 4960 | 37.7877655 | -122.4050414 | GRANT AVE \ GEARY ST | GEARY ST \ GRANT AVE | 1733182588000 | middleware_editor | NO LEFT TURN (SYM) | GRANT AVE intersection | - | 0 / 00 | - | - | - | - | - | 34129 | 263520000000 | -122.4050414 | 37.7877655 | - | - | 1727273700000 | D3 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | LIGHT POLE | RETD | 1373570040000 | GEARY ST | - | - | - | - | - | - |
| 17055 | N/A | Point | - | - | - | - | S107907 | GEARY ST: TAYLOR ST | - | F | F | - | F | 24941000 | 24941000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TAYLOR ST | GEARY ST | 4961 | 4961 | 37.78693971 | -122.41151577 | GEARY ST \ TAYLOR ST | TAYLOR ST \ GEARY ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | GEARY ST intersection | - | 0 / 0 | - | - | - | - | - | 34130 | 263520000000 | -122.41151577 | 37.78693971 | - | - | - | D3 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | LIGHT POLE | IS | 1373570040000 | TAYLOR ST | - | - | - | - | - | - |
| 17056 | N/A | Point | - | - | - | - | S107909 | GEARY ST: LEAVENWORTH ST | - | F | F | - | F | 25154000 | 25154000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LEAVENWORTH ST | GEARY ST | 4963 | 4963 | 37.78651982 | -122.41480665 | GEARY ST \ LEAVENWORTH ST | LEAVENWORTH ST \ GEARY ST | 1726010071000 | middleware_editor | NO LEFT TURN (SYM) | GEARY ST intersection | - | 0 / 0 | - | - | - | - | - | 34131 | 263520000000 | -122.41480665 | 37.78651982 | - | 1725974940000 | - | D6 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | LIGHT POLE | IS | 1373570040000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 17057 | N/A | Point | - | - | - | - | S110039 | INVERNESS DR: OCEAN AVE | - | F | F | - | F | 23221000 | 23221000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | INVERNESS DR | INVERNESS DR | 7248 | 7248 | 37.73239366 | -122.48275143 | OCEAN AVE \ INVERNESS DR | OCEAN AVE \ INVERNESS DR | 1748014555000 | MALOPEZ | STOP | INVERNESS DR intersection | - | 0 / 0 | - | - | - | - | - | 34132 | 582188400000 | -122.48275143 | 37.73239366 | - | 1629356400000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570700000 | OCEAN AVE | - | - | - | - | - | - |
| 17058 | N/A | Point | - | - | - | - | S110041 | 20TH ST: CONNECTICUT ST | - | F | F | - | F | 23666000 | 23666000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 20TH ST | CONNECTICUT ST | 7250 | 7250 | 37.75996741 | -122.39724893 | CONNECTICUT ST \ 20TH ST | 20TH ST \ CONNECTICUT ST | 1710539427000 | MTA | STOP | CONNECTICUT ST intersection | - | - | - | - | - | - | - | 34133 | 582768000000 | -122.39724893 | 37.75996741 | - | 1709738100000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570700000 | 20TH ST | - | - | - | - | - | - |
| 17059 | N/A | Point | - | - | - | - | S110042 | 20TH ST: CONNECTICUT ST | - | F | F | - | F | 23666000 | 23666000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CONNECTICUT ST | CONNECTICUT ST | 7251 | 7251 | 37.75996741 | -122.39724893 | 20TH ST \ CONNECTICUT ST | 20TH ST \ CONNECTICUT ST | 1710539427000 | MTA | STOP | CONNECTICUT ST intersection | - | SWC E/B | - | - | - | - | - | 34134 | 582768000000 | -122.39724893 | 37.75996741 | - | 1709730900000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570700000 | 20TH ST | - | - | - | - | - | - |
| 17060 | N/A | Point | - | - | - | - | S110043 | GOLDEN GATE AVE: BAKER ST | - | F | F | - | F | 26359000 | 26359000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BAKER ST | BAKER ST | 7252 | 7252 | 37.77829955 | -122.44186564 | GOLDEN GATE AVE \ BAKER ST | GOLDEN GATE AVE \ BAKER ST | 1719958314000 | middleware_editor | STOP | BAKER ST intersection | - | - | - | - | - | - | - | 34135 | 582768000000 | -122.44186564 | 37.77829955 | - | - | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570700000 | GOLDEN GATE AVE | - | - | - | - | - | - |
| 17061 | N/A | Point | - | - | - | - | S109068 | HENRY ADAMS ST: ALAMEDA ST | - | F | F | - | F | 23862000 | 23862000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HENRY ADAMS ST | ALAMEDA ST | 7253 | 7253 | 37.76859109 | -122.40387382 | ALAMEDA ST \ HENRY ADAMS ST | HENRY ADAMS ST \ ALAMEDA ST | 1753723034000 | middleware_editor | STOP | ALAMEDA ST intersection | - | 0 / 0 | - | - | - | - | - | 34136 | 399193200000 | -122.40387382 | 37.76859109 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570400000 | HENRY ADAMS ST | - | - | - | - | - | - |
| 17062 | N/A | Point | 1 | 1 | 800 - 899 | - | S109108 | 801-899 COLUMBUS AVE | 800-899 COLUMBUS AVE | F | F | - | F | 4300000 | 4300000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | MASON ST | MASON ST | 7254 | 7254 | 37.80246349 | -122.41331342 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | MASON ST to LOMBARD ST (800 - 899) | - | 0 / 0 | - | - | - | - | - | 34137 | 404265600000 | -122.41331342 | 37.80246349 | - | 1501545600000 | - | D3 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | LIGHT POLE | IS | 1373570400000 | COLUMBUS AVE | 800 - 899 COLUMBUS AVE | 800 - 899 COLUMBUS AVE | 800 COLUMBUS AVE | - | LOMBARD ST | LOMBARD ST |
| 17063 | N/A | Point | - | - | - | - | S110046 | NORTH POINT ST: STOCKTON ST | - | F | F | - | F | 25478000 | 25478000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | NORTH POINT ST | NORTH POINT ST | 7255 | 7255 | 37.80696291 | -122.41049755 | STOCKTON ST \ NORTH POINT ST | STOCKTON ST \ NORTH POINT ST | 1710539427000 | MTA | STOP | NORTH POINT ST intersection | - | MADE ALL-WAY STOP | - | - | - | - | - | 34138 | 585187200000 | -122.41049755 | 37.80696291 | - | 967161600000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570700000 | STOCKTON ST | - | - | - | - | - | - |
| 17064 | N/A | Point | - | - | - | - | S110047 | NORTH POINT ST: STOCKTON ST | - | F | F | - | F | 25478000 | 25478000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | NORTH POINT ST | NORTH POINT ST | 7256 | 7256 | 37.80696291 | -122.41049755 | STOCKTON ST \ NORTH POINT ST | STOCKTON ST \ NORTH POINT ST | 1710539427000 | MTA | STOP | NORTH POINT ST intersection | - | MADE ALL-WAY STOP | - | - | - | - | - | 34139 | 585187200000 | -122.41049755 | 37.80696291 | - | 967161600000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570700000 | STOCKTON ST | - | - | - | - | - | - |
| 17065 | N/A | Point | - | - | - | - | S110049 | DELTA ST: ARLETA AVE | - | F | F | - | F | 20364000 | 20364000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DELTA ST | DELTA ST | 7257 | 7257 | 37.71447896 | -122.40889554 | ARLETA AVE \ DELTA ST | ARLETA AVE \ DELTA ST | 1710539427000 | MTA | STOP | DELTA ST intersection | - | DPW ORDER | - | - | - | - | - | 34140 | 585446400000 | -122.40889554 | 37.71447896 | - | 1576108800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570700000 | ARLETA AVE | - | - | - | - | - | - |
| 17066 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S110051 | 1500-1599 POWELL ST | 1500-1599 POWELL ST | F | F | - | F | 10694000 | 10694000 | - | - | EAST SIDE | - | - | - | - | VALLEJO ST | VALLEJO ST | 7258 | 7258 | 37.79883778 | -122.41055022 | - | - | 1711461405000 | middleware_editor | STOP | VALLEJO ST to GREEN ST (1500 - 1599) | - | 4S / OF NPL 1524 | - | - | - | - | - | 34141 | 586137600000 | -122.41055022 | 37.79883778 | - | - | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570700000 | POWELL ST | 1500 - 1599 POWELL ST | 1500 - 1599 POWELL ST | 1500 POWELL ST | - | GREEN ST | GREEN ST |
| 17067 | N/A | Point | - | - | - | - | S110052 | POWELL ST: NORTH POINT ST | - | F | F | - | F | 25480000 | 25480000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POWELL ST | POWELL ST | 7259 | 7259 | 37.80675808 | -122.41214142 | NORTH POINT ST \ POWELL ST | NORTH POINT ST \ POWELL ST | 1753206814000 | middleware_editor | STOP | POWELL ST intersection | - | MADE TWO-WAY STREET | - | - | - | - | - | 34142 | 586681200000 | -122.41214142 | 37.80675808 | - | - | 1753206780000 | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | RETD | 1373570700000 | NORTH POINT ST | - | - | - | - | - | - |
| 17068 | N/A | Point | - | - | - | - | S102927 | HATTIE ST: MARKET ST | - | F | F | - | F | 26165000 | 26165000 | - | SHOULD BE RETIRED | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HATTIE ST | HATTIE ST | 7262 | 7262 | 37.76107799 | -122.4409847 | MARKET ST \ HATTIE ST | MARKET ST \ HATTIE ST | 1746135239000 | middleware_editor | STOP | HATTIE ST intersection | - | 0 / 0 | - | - | - | - | - | 34143 | -358534800000 | -122.4409847 | 37.76107799 | - | 782031600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | RETD | 1373568480000 | MARKET ST | - | - | - | - | - | - |
| 17069 | N/A | Point | - | - | - | - | S102928 | HATTIE ST: MARKET ST | - | F | F | - | F | 26165000 | 26165000 | - | SHOULD BE RETIRED | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | HATTIE ST | HATTIE ST | 7263 | 7263 | 37.76107799 | -122.4409847 | MARKET ST \ HATTIE ST | MARKET ST \ HATTIE ST | 1715107034000 | middleware_editor | STOP | HATTIE ST intersection | - | SE | - | - | - | - | - | 34144 | -358560000000 | -122.4409847 | 37.76107799 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | RETD | 1373568480000 | MARKET ST | - | - | - | - | - | - |
| 17070 | N/A | Point | - | - | - | - | S102929 | PORTOLA DR: MARKET ST | - | F | F | - | F | 32977000 | 32977000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MARKET ST | MARKET ST | 7264 | 7264 | 37.75008261 | -122.44334726 | PORTOLA DR \ MARKET ST | PORTOLA DR \ MARKET ST | 1721066048000 | middleware_editor | STOP | MARKET ST intersection | - | 00 / AT SIDE ROAD | - | - | - | - | - | 34145 | -358560000000 | -122.44334726 | 37.75008261 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568480000 | PORTOLA DR | - | - | - | - | - | - |
| 17071 | N/A | Point | - | - | - | - | S102932 | MERRITT ST: MARKET ST | - | F | F | - | F | 26174000 | 26174000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MERRITT ST | MERRITT ST | 7265 | 7265 | 37.76104312 | -122.44278561 | MARKET ST \ MERRITT ST | MARKET ST \ MERRITT ST | 1710539427000 | MTA | DO NOT ENTER | MERRITT ST intersection | - | 0 / 00 | - | - | - | - | - | 34146 | -358560000000 | -122.44278561 | 37.76104312 | - | - | - | D8 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP2 | UNKNOWN | IS | 1373568480000 | MARKET ST | - | - | - | - | - | - |
| 17072 | N/A | Point | - | - | - | - | S102934 | 22ND AVE: SANTIAGO ST | - | F | F | - | F | 23201000 | 23201000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 22ND AVE | SANTIAGO ST | 7266 | 7266 | 37.744877964 | -122.479119413 | SANTIAGO ST \ 22ND AVE | 22ND AVE \ SANTIAGO ST | 1735659256000 | middleware_editor | STOP | SANTIAGO ST intersection | - | 0 / 00 | - | - | - | - | - | 34147 | -358214400000 | -122.4790353 | 37.74477547 | - | 1467244800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568480000 | 22ND AVE | - | - | - | - | - | - |
| 17073 | N/A | Point | - | - | - | - | S112034 | PRINCETON ST: SWEENY ST | - | F | F | - | F | 20973000 | 20973000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SWEENY ST | SWEENY ST | 13945 | 13945 | 37.73028639 | -122.41623998 | PRINCETON ST \ SWEENY ST | PRINCETON ST \ SWEENY ST | 1718154110000 | middleware_editor | STOP | SWEENY ST intersection | - | - | - | - | - | - | - | 34148 | 903312000000 | -122.41623998 | 37.73028639 | - | 1574035200000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571300000 | PRINCETON ST | - | - | - | - | - | - |
| 17074 | N/A | Point | - | - | - | - | S112035 | SWEENY ST: PRINCETON ST | - | F | F | - | F | 20973000 | 20973000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SWEENY ST | SWEENY ST | 13946 | 13946 | 37.73028639 | -122.41623998 | PRINCETON ST \ SWEENY ST | PRINCETON ST \ SWEENY ST | 1718154137000 | middleware_editor | STOP | SWEENY ST intersection | - | - | - | - | - | - | - | 34149 | 903312000000 | -122.41623998 | 37.73028639 | - | 1574035200000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373571300000 | PRINCETON ST | - | - | - | - | - | - |
| 17075 | N/A | Point | - | - | - | - | S112038 | 48TH AVE: IRVING ST | - | F | F | - | F | 27953000 | 27953000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | IRVING ST | 48TH AVE | 13948 | 13948 | 37.76219031 | -122.50819857 | 48TH AVE \ IRVING ST | IRVING ST \ 48TH AVE | 1710539427000 | MTA | STOP | 48TH AVE intersection | - | - | - | - | - | - | - | 34150 | 903484800000 | -122.50819857 | 37.76219031 | - | 1495411200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571300000 | IRVING ST | - | - | - | - | - | - |
| 17076 | N/A | Point | - | - | - | - | S112039 | 48TH AVE: IRVING ST | - | F | F | - | F | 27953000 | 27953000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | IRVING ST | 48TH AVE | 13949 | 13949 | 37.76219031 | -122.50819857 | 48TH AVE \ IRVING ST | IRVING ST \ 48TH AVE | 1710539427000 | MTA | STOP | 48TH AVE intersection | - | - | - | - | - | - | - | 34151 | 903484800000 | -122.50819857 | 37.76219031 | - | 1495411200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571300000 | IRVING ST | - | - | - | - | - | - |
| 17077 | N/A | Point | - | - | - | - | S112040 | 32ND AVE: ULLOA ST | - | F | F | - | F | 23348000 | 23348000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ULLOA ST | 32ND AVE | 13950 | 13950 | 37.74056913 | -122.48949004 | 32ND AVE \ ULLOA ST | ULLOA ST \ 32ND AVE | 1715217123000 | middleware_editor | STOP | 32ND AVE intersection | - | MADE ALL WAY STOP | - | - | - | - | - | 34152 | 903484800000 | -122.48949004 | 37.74056913 | - | 1468886400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571300000 | ULLOA ST | - | - | - | - | - | - |
| 17078 | N/A | Point | - | - | - | - | S112041 | 32ND AVE: ULLOA ST | - | F | F | - | F | 23348000 | 23348000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ULLOA ST | 32ND AVE | 13951 | 13951 | 37.74056913 | -122.48949004 | 32ND AVE \ ULLOA ST | ULLOA ST \ 32ND AVE | 1741048157000 | middleware_editor | STOP | 32ND AVE intersection | - | - | - | - | - | - | - | 34153 | 903510000000 | -122.48949004 | 37.74056913 | - | 1468911600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571300000 | ULLOA ST | - | - | - | - | - | - |
| 17079 | N/A | Point | - | - | - | - | S119217 | JULES AVE: GRAFTON AVE | - | F | F | - | F | 22605000 | 22605000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JULES AVE | GRAFTON AVE | 13954 | 13954 | 37.72001799 | -122.46123397 | GRAFTON AVE \ JULES AVE | JULES AVE \ GRAFTON AVE | 1719262997000 | middleware_editor | ALL WAY | GRAFTON AVE intersection | - | - | - | - | - | - | - | 34154 | 1089849600000 | -122.46123397 | 37.72001799 | - | 1719226500000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573580000 | JULES AVE | - | - | - | - | - | - |
| 17080 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S122060 | 1000-1099 JONES ST | 1000-1099 JONES ST | F | F | - | F | 7577000 | 7577000 | - | - | WEST SIDE | - | - | - | - | PINE ST | PINE ST | 13970 | 13970 | 37.7909398 | -122.41401159 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | PINE ST to CALIFORNIA ST (1000 - 1099) | - | 100' SOUTH OF CALIFORNIA | - | - | - | - | - | 34155 | 1133222400000 | -122.41401159 | 37.7909398 | - | - | - | D3 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | LIGHT POLE | IS | 1373574480000 | JONES ST | 1000 - 1099 JONES ST | 1000 - 1099 JONES ST | 1000 JONES ST | - | CALIFORNIA ST | CALIFORNIA ST |
| 17081 | N/A | Point | 1 | 1 | 800 - 849 | - | S122062 | 800-849 TERESITA BLVD | 800-849 TERESITA BLVD | F | F | - | F | 12517000 | 12517000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | STILLINGS AVE | STILLINGS AVE | 13972 | 13972 | 37.73418309 | -122.44550444 | - | - | 1710539427000 | MTA | STOP | STILLINGS AVE to MELROSE AVE (800 - 849) | - | OPP.NE CORNOR | - | - | - | - | - | 34156 | 1133222400000 | -122.44550444 | 37.73418309 | - | - | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373574480000 | TERESITA BLVD | 800 - 849 TERESITA BLVD | 800 - 849 TERESITA BLVD | 800 TERESITA BLVD | - | MELROSE AVE | MELROSE AVE |
| 17082 | N/A | Point | 1 | 1 | 800 - 849 | - | S122064 | 800-849 TERESITA BLVD | 800-849 TERESITA BLVD | F | F | - | F | 12517000 | 12517000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | STILLINGS AVE | STILLINGS AVE | 13974 | 13974 | 37.73418309 | -122.44550444 | - | - | 1710539427000 | MTA | ALL WAY | STILLINGS AVE to MELROSE AVE (800 - 849) | - | OPP.NE CORNOR | - | - | - | - | - | 34157 | 1133222400000 | -122.44550444 | 37.73418309 | - | - | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373574480000 | TERESITA BLVD | 800 - 849 TERESITA BLVD | 800 - 849 TERESITA BLVD | 800 TERESITA BLVD | - | MELROSE AVE | MELROSE AVE |
| 17083 | N/A | Point | - | - | - | - | S122065 | OFARRELL ST: LEAVENWORTH ST | - | T | T | - | F | 25153000 | 25153000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LEAVENWORTH ST | OFARRELL ST | 13975 | 13975 | 37.78558248 | -122.41461721 | OFARRELL ST \ LEAVENWORTH ST | LEAVENWORTH ST \ OFARRELL ST | 1717635574000 | middleware_editor | RIGHT LANE BUSES, TAXIS AND RIGHT TURNS ONLY AT ALL TIMES | OFARRELL ST intersection | - | - | - | - | - | - | - | 34158 | 1133222400000 | -122.41461721 | 37.78558248 | - | - | - | D6 | - | TRANSIT ONLY(RIGHT LANE) | REG | SR60-6(SF).0005 | 30X42 | SUP1 | LIGHT POLE | IS | 1373574480000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 17084 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S123527 | 2300-2399 WASHINGTON ST | 2300-2399 WASHINGTON ST | F | F | - | F | 13438000 | 13438000 | - | - | SOUTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | BUCHANAN ST | BUCHANAN ST | 18191 | 18191 | 37.79190405 | -122.43191577 | - | - | 1710539427000 | MTA | WEBSTER STREET HISTORIC DISTRICT | BUCHANAN ST to WEBSTER ST (2300 - 2399) | - | EPL # 2367 | - | - | - | - | - | 34159 | 1146528000000 | -122.43191577 | 37.79190405 | - | - | - | D2 | - | OTHER GUIDE | GUIDE | G-W(SF).0003 | 36X08 | SUP1 | MUNI POLE | IS | 1373574900000 | WASHINGTON ST | 2300 - 2399 WASHINGTON ST | 2300 - 2399 WASHINGTON ST | 2300 WASHINGTON ST | - | WEBSTER ST | WEBSTER ST |
| 17085 | N/A | Point | - | - | - | - | S123528 | WEBSTER ST: JACKSON ST | - | F | F | - | F | 26650000 | 26650000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WEBSTER ST | JACKSON ST | 18192 | 18192 | 37.79267992 | -122.43291758 | JACKSON ST \ WEBSTER ST | WEBSTER ST \ JACKSON ST | 1743443749000 | middleware_editor | WEBSTER STREET HISTORIC DISTRICT | JACKSON ST intersection | - | - | - | - | - | - | - | 34160 | 1146553200000 | -122.43291758 | 37.79267992 | - | - | - | D2 | - | OTHER GUIDE | GUIDE | G-W(SF).0003 | 36X08 | SUP1 | LIGHT POLE | IS | 1373574900000 | WEBSTER ST | - | - | - | - | - | - |
| 17086 | N/A | Point | 1 | 1 | 2400 - 2499 | - | S123529 | 2400-2499 WASHINGTON ST | 2400-2499 WASHINGTON ST | F | F | - | F | 13439000 | 13439000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | WEBSTER ST | WEBSTER ST | 18193 | 18193 | 37.79169565 | -122.43356002 | - | - | 1710539427000 | MTA | WEBSTER STREET HISTORIC DISTRICT | WEBSTER ST to FILLMORE ST (2400 - 2499) | - | WPL # 2409 | - | - | - | - | - | 34161 | 1146528000000 | -122.43356002 | 37.79169565 | - | - | - | D2 | - | OTHER GUIDE | GUIDE | G-W(SF).0003 | 36X08 | SUP1 | MUNI POLE | IS | 1373574900000 | WASHINGTON ST | 2400 - 2499 WASHINGTON ST | 2400 - 2499 WASHINGTON ST | 2400 WASHINGTON ST | - | FILLMORE ST | FILLMORE ST |
| 17087 | N/A | Point | - | - | - | - | S123530 | PACIFIC AVE: LEAVENWORTH ST | - | F | F | - | F | 25274000 | 25274000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LEAVENWORTH ST | PACIFIC AVE | 18194 | 18194 | 37.79567005 | -122.41665276 | PACIFIC AVE \ LEAVENWORTH ST | LEAVENWORTH ST \ PACIFIC AVE | 1711485317000 | middleware_editor | ALL WAY | PACIFIC AVE intersection | - | - | - | - | - | - | - | 34162 | 1146528000000 | -122.41665276 | 37.79567005 | - | 1711447800000 | - | D3 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574900000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 17088 | N/A | Point | - | - | - | - | S123531 | PACIFIC AVE: LEAVENWORTH ST | - | F | F | - | F | 25274000 | 25274000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LEAVENWORTH ST | PACIFIC AVE | 18195 | 18195 | 37.79567005 | -122.41665276 | PACIFIC AVE \ LEAVENWORTH ST | LEAVENWORTH ST \ PACIFIC AVE | 1711485754000 | middleware_editor | ALL WAY | PACIFIC AVE intersection | - | - | - | - | - | - | - | 34163 | 1146528000000 | -122.41665276 | 37.79567005 | - | 1711453800000 | - | D3 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574900000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 17089 | N/A | Point | - | - | - | - | S126638 | SAN BRUNO AVE: WOOLSEY ST | - | F | F | - | F | 33273000 | 33273000 | - | - | SOUTH EAST CORNER | - | - | - | - | SAN BRUNO AVE | SAN BRUNO AVE | 18603 | 18603 | 37.72523511 | -122.40260041 | WOOLSEY ST \ SAN BRUNO AVE | WOOLSEY ST \ SAN BRUNO AVE | 1710539427000 | MTA | 1 HR PRK 7AM-6PM EXC SUN | SAN BRUNO AVE intersection | - | 0 / INSTALL SIGN ON NEW LP AT S/E C..... | - | - | - | - | - | 34164 | 1170374400000 | -122.40260041 | 37.72523511 | - | - | - | D9 | - | PARKING | REG | R32(CA).0005 | 18X18 | SUP2 | LIGHT POLE | IS | 1373575860000 | WOOLSEY ST | - | - | - | - | - | - |
| 17090 | N/A | Point | - | - | - | - | S124492 | JENNINGS ST: WALLACE AVE | - | F | F | - | F | 20152000 | 20152000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WALLACE AVE | JENNINGS ST | 18604 | 18604 | 37.72641515 | -122.38923775 | JENNINGS ST \ WALLACE AVE | WALLACE AVE \ JENNINGS ST | 1724711197000 | middleware_editor | STOP | JENNINGS ST intersection | - | 30S / INSTALL SIGN BELOW ST.NAMES SIGNS | - | - | - | - | - | 34165 | 1153094400000 | -122.38923775 | 37.72641515 | - | 1508284800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 3IN IRON POST | IS | 1373575200000 | WALLACE AVE | - | - | - | - | - | - |
| 17091 | N/A | Point | - | - | - | - | S124493 | ARMSTRONG AVE: INGALLS ST | - | F | F | - | F | 20113000 | 20113000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | INGALLS ST | ARMSTRONG AVE | 18605 | 18605 | 37.72410024 | -122.38849621 | ARMSTRONG AVE \ INGALLS ST | INGALLS ST \ ARMSTRONG AVE | 1739217292000 | middleware_editor | ALL WAY | ARMSTRONG AVE intersection | - | - | - | - | - | - | - | 34166 | 1153094400000 | -122.38849621 | 37.72410024 | - | 1739181600000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575200000 | INGALLS ST | - | - | - | - | - | - |
| 17092 | N/A | Point | - | - | - | - | S124494 | JENNINGS ST: WALLACE AVE | - | F | F | - | F | 20152000 | 20152000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WALLACE AVE | JENNINGS ST | 18606 | 18606 | 37.72641515 | -122.38923775 | JENNINGS ST \ WALLACE AVE | WALLACE AVE \ JENNINGS ST | 1724720255000 | middleware_editor | ALL WAY | JENNINGS ST intersection | - | BELOW STOP SIGN | - | - | - | - | - | 34167 | 1153094400000 | -122.38923775 | 37.72641515 | - | 1508284800000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 3IN IRON POST | IS | 1373575200000 | WALLACE AVE | - | - | - | - | - | - |
| 17093 | N/A | Point | - | - | - | - | S123911 | 19TH AVE: BALBOA ST | - | F | F | - | F | 27496000 | 27496000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | BALBOA ST | 18608 | 18608 | 37.77659524 | -122.47803328 | 19TH AVE \ BALBOA ST | 19TH AVE \ BALBOA ST | 1720794508000 | middleware_editor | ALL WAY | BALBOA ST intersection | - | - | - | - | - | - | - | 34168 | 1148947200000 | -122.47803328 | 37.77659524 | - | - | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575020000 | 19TH AVE | - | - | - | - | - | - |
| 17094 | N/A | Point | 1 | 1 | 100 - 199 | - | S123914 | 100-199 BENTON AVE | 100-199 BENTON AVE | F | F | - | F | 2927000 | 2927000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | GENEBERN WAY | GENEBERN WAY | 18610 | 18610 | 37.73284878 | -122.42436858 | - | - | 1710539427000 | MTA | ROUNDABOUT ARROWS | GENEBERN WAY to COLLEGE AVE (100 - 199) | - | OPP.C-LINE | - | - | - | - | - | 34169 | 1148947200000 | -122.42436858 | 37.73284878 | - | 1398211200000 | - | D9 | - | OTHER REGULATORY | REG | R7(SF).0001 | 18X24 | SUP2 | 2IN IRON POST | IS | 1373575020000 | BENTON AVE | 100 - 199 BENTON AVE | 100 - 199 BENTON AVE | 100 BENTON AVE | - | COLLEGE AVE | COLLEGE AVE |
| 17095 | N/A | Point | - | - | - | VERTICAL ARROW | S123920 | 4TH ST: BRANNAN ST | - | T | T | - | F | 23827000 | 23827000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BRANNAN ST | BRANNAN ST | 18612 | 18612 | 37.77832683 | -122.39653064 | 4TH ST \ BRANNAN ST | 04TH ST \ BRANNAN ST | 1710539427000 | MTA | ORACLE PARK (TEMPORARY DECAL) | BRANNAN ST intersection | 50 | - | - | - | - | - | - | 34170 | 1149033600000 | -122.39653064 | 37.77832683 | - | 1553904000000 | - | D6 | - | OTHER GUIDE | GUIDE | G-OC(SF).0001 | 42X18 | SUP1 | OVERHEAD MAST ARM | IS | 1373575020000 | 04TH ST | - | - | - | - | - | - |
| 17096 | N/A | Point | 1 | 1 | 500 - 584 | - | S143454 | 500-584 VALLEY ST | 500-584 VALLEY ST | F | F | - | F | 13130000 | 13130000 | - | - | NORTH SIDE | - | - | - | - | CASTRO ST | CASTRO ST | 29852 | 29852 | 37.74404892 | -122.43426455 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 2ND & 4TH TUE OF MONTH STCL | CASTRO ST to VALLEY ST (500 - 584) | - | 25 FEET WEST OF CASTRO | - | - | - | - | - | 34171 | 1222214400000 | -122.43426455 | 37.74404892 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0257 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375726740000 | VALLEY ST | 500 - 584 VALLEY ST | 500 - 584 VALLEY ST | 500 VALLEY ST | - | VALLEY ST | VALLEY ST |
| 17097 | N/A | Point | 1 | 1 | 500 - 599 | - | S143455 | 500-599 29TH ST | 500-599 29TH ST | F | F | - | F | 1634000 | 1634000 | - | - | SOUTH SIDE | - | - | - | - | NOE ST | NOE ST | 29853 | 29853 | 37.74336337 | -122.43220993 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 2ND & 4TH TUE OF MONTH STCL | NOE ST to CASTRO ST \ DAY ST (500 - 599) | - | 531 29TH ST | - | - | - | - | - | 34172 | 1222214400000 | -122.43220993 | 37.74336337 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0257 | 18X18 | SUP2 | UTILITY POLE | IS | 1375726740000 | 29TH ST | 500 - 599 29TH ST | 500 - 599 29TH ST | 500 29TH ST | - | CASTRO ST \ DAY ST | CASTRO ST \ DAY ST |
| 17098 | N/A | Point | 1 | 1 | 400 - 499 | - | S143457 | 400-499 29TH ST | 400-499 29TH ST | F | F | - | F | 1633000 | 1633000 | - | - | SOUTH SIDE | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 29854 | 29854 | 37.74349804 | -122.42999151 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 2ND & 4TH TUE OF MONTH STCL | SANCHEZ ST to NOE ST (400 - 499) | - | 485 29TH ST | - | - | - | - | - | 34173 | 1222214400000 | -122.42999151 | 37.74349804 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0257 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1375726740000 | 29TH ST | 400 - 499 29TH ST | 400 - 499 29TH ST | 400 29TH ST | - | NOE ST | NOE ST |
| 17099 | N/A | Point | 1 | 1 | 400 - 499 | - | S143458 | 400-499 29TH ST | 400-499 29TH ST | F | F | - | F | 1633000 | 1633000 | - | - | SOUTH SIDE | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 29855 | 29855 | 37.74349804 | -122.42999151 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 2ND & 4TH TUE OF MONTH STCL | SANCHEZ ST to NOE ST (400 - 499) | - | 407 29TH ST | - | - | - | - | - | 34174 | 1222300800000 | -122.42999151 | 37.74349804 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0257 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1375726740000 | 29TH ST | 400 - 499 29TH ST | 400 - 499 29TH ST | 400 29TH ST | - | NOE ST | NOE ST |
| 17100 | N/A | Point | 1 | 1 | 400 - 499 | - | S143459 | 400-499 29TH ST | 400-499 29TH ST | F | F | - | F | 1633000 | 1633000 | - | - | SOUTH SIDE | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 29856 | 29856 | 37.74349804 | -122.42999151 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 2ND & 4TH TUE OF MONTH STCL | SANCHEZ ST to NOE ST (400 - 499) | - | 443 29TH ST | - | - | - | - | - | 34175 | 1222300800000 | -122.42999151 | 37.74349804 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0257 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1375726740000 | 29TH ST | 400 - 499 29TH ST | 400 - 499 29TH ST | 400 29TH ST | - | NOE ST | NOE ST |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in meters