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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21076 | N/A | Point | - | - | - | - | S225550 | RIVERA ST: 43RD AVE | - | F | F | - | F | 23477000 | 23477000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 43RD AVE | 43RD AVE | 63431 | 63431 | 37.74564495 | -122.50166937 | RIVERA ST \ 43RD AVE | RIVERA ST \ 43RD AVE | 1743705446000 | middleware_editor | STOP | 43RD AVE intersection | - | - | - | - | - | - | - | 38154 | 1463682300000 | -122.50166937 | 37.74564495 | - | 1463641200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1462962300000 | RIVERA ST | - | - | - | - | - | - |
| 21077 | N/A | Point | - | - | - | - | S225551 | RIVERA ST: 43RD AVE | - | F | F | - | F | 23477000 | 23477000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 43RD AVE | 43RD AVE | 63432 | 63432 | 37.74564495 | -122.50166937 | RIVERA ST \ 43RD AVE | RIVERA ST \ 43RD AVE | 1743705453000 | middleware_editor | ALL WAY | 43RD AVE intersection | - | - | - | - | - | - | - | 38155 | 1463682360000 | -122.50166937 | 37.74564495 | - | 1463641200000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1462962420000 | RIVERA ST | - | - | - | - | - | - |
| 21078 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S225461 | 1300-1399 LANE ST | 1300-1399 LANE ST | F | F | - | F | 8087000 | 8087000 | - | - | WEST SIDE | - | - | - | - | NEWCOMB AVE | NEWCOMB AVE | 63467 | 63467 | 37.73385221 | -122.38819582 | - | - | 1726259649000 | middleware_editor | NPRK 8AM-10AM TUE STCL | NEWCOMB AVE to OAKDALE AVE (1300 - 1399) | - | 20FT. SOUTH OF NEWCOMB AVE. | - | - | - | - | - | 38156 | - | -122.38819582 | 37.73385221 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0270 | 18X18 | SUP1 | 2IN IRON POST | IS | 1462549380000 | LANE ST | 1300 - 1399 LANE ST | 1300 - 1399 LANE ST | 1300 LANE ST | - | OAKDALE AVE | OAKDALE AVE |
| 21079 | N/A | Point | - | - | - | - | S225462 | MENDELL ST: LA SALLE AVE | - | F | F | - | F | 20211000 | 20211000 | - | - | SOUTH EAST CORNER | - | - | - | - | LA SALLE AVE | MENDELL ST | 63468 | 63468 | 37.73648282 | -122.38865297 | MENDELL ST \ LA SALLE AVE | MENDELL ST intersection | 1713921116000 | middleware_editor | MENDELL ST | MENDELL ST intersection | - | N.MENDELL(1100)-->SOUTH | - | - | - | - | - | 38157 | 1463383260000 | -122.38865297 | 37.73648282 | - | 1463356800000 | - | D10 | - | STREET NAME | GUIDE | D3-1.1164 | 36X08 | SUP1 | 3IN IRON POST | IS | 1462549800000 | LA SALLE AVE | - | - | - | - | - | - |
| 21080 | N/A | Point | - | - | - | - | S225463 | MENDELL ST: LA SALLE AVE | - | F | F | - | F | 20211000 | 20211000 | - | - | SOUTH EAST CORNER | - | - | - | - | LA SALLE AVE | MENDELL ST | 63469 | 63469 | 37.73648282 | -122.38865297 | MENDELL ST \ LA SALLE AVE | MENDELL ST intersection | 1713921234000 | middleware_editor | LA SALLE AVE | MENDELL ST intersection | - | LA SALLE(1600)-WEST | - | - | - | - | - | 38158 | 1463383200000 | -122.38865297 | 37.73648282 | - | 1463356800000 | - | D10 | - | STREET NAME | GUIDE | D3-1.0991 | 36X08 | SUP1 | 3IN IRON POST | IS | 1462549980000 | LA SALLE AVE | - | - | - | - | - | - |
| 21081 | N/A | Point | 1 | 1 | 875 - 999 | - | S225464 | 875-999 MENDELL ST | 875-999 MENDELL ST | F | F | - | F | 8961000 | 8961000 | - | - | WEST SIDE | - | - | - | - | JERROLD AVE | JERROLD AVE | 63470 | 63470 | 37.73741852 | -122.38780942 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM TUE STCL | JERROLD AVE to KIRKWOOD AVE (875 - 999) | - | IFO# 900 JERROLD AVE. | - | - | - | - | - | 38159 | 1462980600000 | -122.38780942 | 37.73741852 | - | 1462924800000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0270 | 18X18 | SUP1 | LIGHT POLE | IS | 1462550280000 | MENDELL ST | 875 - 999 MENDELL ST | 875 - 999 MENDELL ST | 875 MENDELL ST | - | KIRKWOOD AVE | KIRKWOOD AVE |
| 21082 | N/A | Point | - | - | - | - | S228428 | CASTENADA AVE: MONTALVO AVE | - | F | F | - | F | 22976000 | 22976000 | - | - | SOUTH WEST CORNER | - | - | - | - | CASTENADA AVE | CASTENADA AVE | 63473 | 63473 | 37.74569034 | -122.46573285 | MONTALVO AVE \ CASTENADA AVE | MONTALVO AVE \ CASTENADA AVE | 1710539427000 | MTA | MONTALVO AVE | CASTENADA AVE intersection | - | - | - | - | - | - | - | 38160 | 1473869340000 | -122.46573285 | 37.74569034 | - | 1473811200000 | - | D7 | - | STREET NAME | GUIDE | D3-1.1222 | 36X08 | SUP2 | 3IN IRON POST | IS | 1472136660000 | MONTALVO AVE | - | - | - | - | - | - |
| 21083 | N/A | Point | 1 | 1 | 100 - 140 | - | S226940 | 100-140 POST ST | 100-140 POST ST | F | F | - | F | 10625000 | 10625000 | - | - | SOUTH SIDE | - | - | - | - | KEARNY ST | KEARNY ST | 64344 | 64344 | 37.78885055 | -122.40400233 | - | - | 1710539427000 | MTA | BIKE RACK | KEARNY ST to ROBERT KIRK LN (100 - 140) | 20154808 | IFO #101 3' FROM CURB | - | - | - | - | - | 38161 | 1469715720000 | -122.40400233 | 37.78885055 | - | 1469664000000 | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1467037740000 | POST ST | 100 - 140 POST ST | 100 - 140 POST ST | 100 POST ST | - | ROBERT KIRK LN | ROBERT KIRK LN |
| 21084 | N/A | Point | 1 | 1 | 100 - 140 | - | S226941 | 100-140 POST ST | 100-140 POST ST | F | F | - | F | 10625000 | 10625000 | - | - | SOUTH SIDE | - | - | - | - | KEARNY ST | KEARNY ST | 64345 | 64345 | 37.78885055 | -122.40400233 | - | - | 1710539427000 | MTA | BIKE RACK | KEARNY ST to ROBERT KIRK LN (100 - 140) | 20154808 | WPL #101 3' FROM CURB | - | - | - | - | - | 38162 | 1469715840000 | -122.40400233 | 37.78885055 | - | 1469664000000 | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1467037920000 | POST ST | 100 - 140 POST ST | 100 - 140 POST ST | 100 POST ST | - | ROBERT KIRK LN | ROBERT KIRK LN |
| 21085 | N/A | Point | 1 | 1 | 700 - 799 | - | S224337 | 700-799 POST ST | 700-799 POST ST | F | F | - | F | 10635000 | 10635000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | JONES ST | JONES ST | 64346 | 64346 | 37.78755872 | -122.41417469 | - | - | 1742394003000 | middleware_editor | 49 MILE SCENIC DRIVE | JONES ST to LEAVENWORTH ST (700 - 799) | 12 | 60' EAST OF LEAVENWORTH ST. | - | - | - | - | - | 38163 | 1520875020000 | -122.41417469 | 37.78755872 | - | 1587020400000 | - | D3 | - | OTHER GUIDE | GUIDE | G-X(SF).0045 | 24X30 | SUP1 | LIGHT POLE | IS | 1458729720000 | POST ST | 700 - 799 POST ST | 700 - 799 POST ST | 700 POST ST | - | LEAVENWORTH ST | LEAVENWORTH ST |
| 21086 | N/A | Point | 1 | 1 | 400 - 499 | - | S224345 | 400-499 POST ST | 400-499 POST ST | T | T | - | F | 10629000 | 10629000 | - | - | NORTH SIDE | - | - | - | - | POWELL ST | POWELL ST | 64347 | 64347 | 37.78818769 | -122.40922924 | - | - | 1710539427000 | MTA | TOWAWAY LANE MUST TURN LEFT | POWELL ST to MASON ST (400 - 499) | - | 5' WEST OF POWELL ST. | - | - | - | - | - | 38164 | - | -122.40922924 | 37.78818769 | - | - | - | D3 | - | OTHER REGULATORY | REG | R(SF).0283 | 30X42 | SUP1 | 2IN FLANGE POST | IS | 1458730920000 | POST ST | 400 - 499 POST ST | 400 - 499 POST ST | 400 POST ST | - | MASON ST | MASON ST |
| 21087 | N/A | Point | - | - | - | - | S224348 | POST ST: POWELL ST | - | T | T | - | F | 24918000 | 24918000 | - | - | NORTH WEST CORNER | - | - | - | - | POST ST | POST ST | 64348 | 64348 | 37.78829319 | -122.40840155 | POWELL ST \ POST ST | POWELL ST \ POST ST | 1729127003000 | middleware_editor | POWELL ST | POST ST intersection | - | - | - | - | - | - | - | 38165 | 1503302100000 | -122.40840155 | 37.78829319 | - | 1503273600000 | - | D3 | - | STREET NAME | GUIDE | D3-2.0285 | 72X18 | SUP1 | LIGHT POLE | IS | 1458731100000 | POWELL ST | - | - | - | - | - | - |
| 21088 | N/A | Point | - | - | - | - | S224368 | SONOMA ST: UNION ST | - | F | F | - | F | 28180000 | 28180000 | - | - | SOUTH EAST CORNER | - | - | - | - | SONOMA ST | UNION ST | 64349 | 64349 | 37.80078642 | -122.40640795 | UNION ST \ SONOMA ST | SONOMA ST \ UNION ST | 1710539427000 | MTA | STOP | UNION ST intersection | - | OF SONOMA ST & UNION ST | - | - | - | - | - | 38166 | -3888000000 | -122.40640795 | 37.80078642 | - | - | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1458745740000 | SONOMA ST | - | - | - | - | - | - |
| 21089 | N/A | Point | - | - | - | - | S231264 | HEARST AVE: DETROIT ST | - | F | F | - | F | 22155000 | 22155000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DETROIT ST | DETROIT ST | 64350 | 64350 | 37.73070822 | -122.44429841 | HEARST AVE \ DETROIT ST | HEARST AVE \ DETROIT ST | 1710539427000 | MTA | ALL WAY | DETROIT ST intersection | - | - | - | - | - | - | - | 38167 | 700099200000 | -122.44429841 | 37.73070822 | - | 1486944000000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479819360000 | HEARST AVE | - | - | - | - | - | - |
| 21090 | N/A | Point | 1 | 1 | 200 - 299 | - | S231265 | 200-299 SPEAR ST | 200-299 SPEAR ST | F | F | - | F | 12046000 | 12046000 | - | - | WEST SIDE | - | - | - | - | HOWARD ST | HOWARD ST | 64351 | 64351 | 37.79069039 | -122.39174782 | - | - | 1710539427000 | MTA | TANS EXCEPT CARPOOL 3PM-7PM MON-FRI | HOWARD ST to FOLSOM ST (200 - 299) | - | 2' NORTH OF FOLSOM | - | - | - | - | - | 38168 | - | -122.39174782 | 37.79069039 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(SF).0322 | 18X21 | SUP1 | 2IN IRON POST | IS | 1479819360000 | SPEAR ST | 200 - 299 SPEAR ST | 200 - 299 SPEAR ST | 200 SPEAR ST | - | FOLSOM ST | FOLSOM ST |
| 21091 | N/A | Point | - | - | - | - | S231267 | HEARST AVE: DETROIT ST | - | F | F | - | F | 22155000 | 22155000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DETROIT ST | DETROIT ST | 64352 | 64352 | 37.73070822 | -122.44429841 | HEARST AVE \ DETROIT ST | HEARST AVE \ DETROIT ST | 1710539427000 | MTA | ALL WAY | DETROIT ST intersection | - | - | - | - | - | - | - | 38169 | 700099200000 | -122.44429841 | 37.73070822 | - | 1486944000000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479819480000 | HEARST AVE | - | - | - | - | - | - |
| 21092 | N/A | Point | 1 | 1 | 200 - 299 | - | S231268 | 200-299 SPEAR ST | 200-299 SPEAR ST | F | F | - | F | 12046000 | 12046000 | - | - | WEST SIDE | - | - | - | - | HOWARD ST | HOWARD ST | 64353 | 64353 | 37.79069039 | -122.39174782 | - | - | 1710539427000 | MTA | CARPOOLS TO VALLEJO/MAIN ST | HOWARD ST to FOLSOM ST (200 - 299) | - | 40' NORTH OF FOLSOM | - | - | - | - | - | 38170 | - | -122.39174782 | 37.79069039 | - | - | - | D6 | - | OTHER REGULATORY | REG | SR(SF).0051 | 30X24 | SUP1 | 2IN FLANGE POST | IS | 1479819600000 | SPEAR ST | 200 - 299 SPEAR ST | 200 - 299 SPEAR ST | 200 SPEAR ST | - | FOLSOM ST | FOLSOM ST |
| 21093 | N/A | Point | 1 | 1 | 200 - 299 | - | S231269 | 200-299 SPEAR ST | 200-299 SPEAR ST | F | F | - | F | 12046000 | 12046000 | - | - | WEST SIDE | - | - | - | - | HOWARD ST | HOWARD ST | 64354 | 64354 | 37.79069039 | -122.39174782 | - | - | 1710539427000 | MTA | CARPOOLS TO WALNUT CREEK/PLEASANT HILL/CONCORD | HOWARD ST to FOLSOM ST (200 - 299) | - | 60' NORTH OF FOLSOM | - | - | - | - | - | 38171 | - | -122.39174782 | 37.79069039 | - | - | - | D6 | - | OTHER REGULATORY | REG | SR(SF).0027 | 42X30 | SUP1 | 2IN IRON POST | IS | 1479819720000 | SPEAR ST | 200 - 299 SPEAR ST | 200 - 299 SPEAR ST | 200 SPEAR ST | - | FOLSOM ST | FOLSOM ST |
| 21094 | N/A | Point | 1 | 1 | 200 - 299 | - | S231270 | 200-299 SPEAR ST | 200-299 SPEAR ST | F | F | - | F | 12046000 | 12046000 | - | - | WEST SIDE | - | - | - | - | HOWARD ST | HOWARD ST | 64355 | 64355 | 37.79069039 | -122.39174782 | - | - | 1710539427000 | MTA | CARPOOLS TO ORINDA/LAFAYETTE | HOWARD ST to FOLSOM ST (200 - 299) | - | 80' NORTH OF FOLSOM | - | - | - | - | - | 38172 | 1481896620000 | -122.39174782 | 37.79069039 | - | 1481846400000 | - | D6 | - | OTHER REGULATORY | REG | SR(SF).0023 | 42X30 | SUP1 | 2IN FLANGE POST | IS | 1479819840000 | SPEAR ST | 200 - 299 SPEAR ST | 200 - 299 SPEAR ST | 200 SPEAR ST | - | FOLSOM ST | FOLSOM ST |
| 21095 | N/A | Point | - | - | - | - | S231271 | DONAHUE ST: INNES AVE | - | F | F | - | F | 35028000 | 35028000 | - | - | EAST SIDE | - | - | - | - | INNES AVE | DONAHUE ST | 64356 | 64356 | 37.72880615 | -122.37014538 | DONAHUE ST \ INNES AVE | INNES AVE \ DONAHUE ST | 1710539427000 | MTA | NPRK 8AM-10AM TUE STCL | DONAHUE ST intersection | - | 146' NORTH OF INNES AVE | - | - | - | - | - | 38173 | 1480508100000 | -122.37014538 | 37.72880615 | - | 1480464000000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0270 | 18X18 | SUP1 | 2IN IRON POST | IS | 1479819960000 | INNES AVE | - | - | - | - | - | - |
| 21096 | N/A | Point | - | - | - | - | S228493 | BAY SHORE BLVD: HESTER AVE | - | T | T | - | F | 20291000 | 20291000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | HESTER AVE | BAY SHORE BLVD | 64357 | 64357 | 37.71358404 | -122.40001669 | BAY SHORE BLVD \ HESTER AVE | HESTER AVE \ BAY SHORE BLVD | 1710539427000 | MTA | PHOTO ENFORCED (SYM) | BAY SHORE BLVD intersection | - | - | - | - | - | - | - | 38174 | - | -122.40001669 | 37.71358404 | - | - | - | D10 | - | OTHER REGULATORY | REG | SR56(CA).0001 | 30X42 | SUP1 | LIGHT POLE | IS | 1472548920000 | HESTER AVE | - | - | - | - | - | - |
| 21097 | N/A | Point | - | - | - | - | S228499 | SAMOSET ST: FRANCONIA ST | - | F | F | - | F | 21095000 | 21095000 | - | - | NORTH WEST CORNER | - | - | - | - | FRANCONIA ST | FRANCONIA ST | 64358 | 64358 | 37.74440613 | -122.40778731 | SAMOSET ST \ FRANCONIA ST | SAMOSET ST \ FRANCONIA ST | 1710539427000 | MTA | SAMOSET ST | FRANCONIA ST intersection | - | - | - | - | - | - | - | 38175 | 1475164140000 | -122.40778731 | 37.74440613 | - | 1475107200000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1550 | 36X08 | SUP2 | 3IN IRON POST | IS | 1472551140000 | SAMOSET ST | - | - | - | - | - | - |
| 21098 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S228503 | 2300-2399 FOLSOM ST | 2300-2399 FOLSOM ST | F | F | - | F | 5694000 | 5694000 | - | - | EAST SIDE | - | - | - | - | 19TH ST | 19TH ST | 64359 | 64359 | 37.75969744 | -122.41476596 | - | - | 1755878936000 | middleware_editor | NPRK 9AM-11AM TUE THUR STCL | 19TH ST to 20TH ST (2300 - 2399) | - | OPP.# 2376 FOLSOM ST. | - | - | - | - | - | 38176 | 1196928000000 | -122.41476596 | 37.75969744 | - | 1473318000000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0309 | 18X18 | SUP2 | LIGHT POLE | IS | 1472552520000 | FOLSOM ST | 2300 - 2399 FOLSOM ST | 2300 - 2399 FOLSOM ST | 2300 FOLSOM ST | - | 20TH ST | 20TH ST |
| 21099 | N/A | Point | - | - | - | - | S231354 | 22ND ST: CHATTANOOGA ST | - | F | F | - | F | 25656000 | 25656000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 22ND ST | 22ND ST | 64360 | 64360 | 37.75496227 | -122.42663401 | CHATTANOOGA ST \ 22ND ST | CHATTANOOGA ST \ 22ND ST | 1710539427000 | MTA | ALL WAY | 22ND ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 38177 | 66614400000 | -122.42663401 | 37.75496227 | - | 1488758400000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1480333560000 | CHATTANOOGA ST | - | - | - | - | - | - |
| 21100 | N/A | Point | 1 | 1 | 2300 - 2399 | LEFT ARROW | S229724 | 2300-2399 SACRAMENTO ST | 2300-2399 SACRAMENTO ST | F | F | - | F | 11254000 | 11254000 | - | - | NORTH SIDE | - | - | - | - | BUCHANAN ST | BUCHANAN ST | 64361 | 64361 | 37.79014813 | -122.43156068 | - | - | 1730129746000 | middleware_editor | TA (SYM) PLO 8AM-6PM MON-FRI (5 MIN) | BUCHANAN ST to WEBSTER ST (2300 - 2399) | - | IFO #2324 | - | - | - | - | - | 38178 | 1476886380000 | -122.43156068 | 37.79014813 | - | 1476835200000 | - | D2 | - | OTHER REGULATORY | REG | R38(SF)1.0010 | 14X21 | SUP1 | 2IN IRON POST | IS | 1476196920000 | SACRAMENTO ST | 2300 - 2399 SACRAMENTO ST | 2300 - 2399 SACRAMENTO ST | 2300 SACRAMENTO ST | - | WEBSTER ST | WEBSTER ST |
| 21101 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S229574 | 1200-1299 19TH ST | 1200-1299 19TH ST | F | F | - | F | 945000 | 945000 | - | - | SOUTH SIDE | - | - | - | - | MISSISSIPPI ST | MISSISSIPPI ST | 65360 | 65360 | 37.7613876 | -122.39495584 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM MON STCL | MISSISSIPPI ST to TEXAS ST (1200 - 1299) | - | INFO # 1225 | - | - | - | - | - | 38179 | 1001376000000 | -122.39495584 | 37.7613876 | - | 1475712000000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0300 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1475676960000 | 19TH ST | 1200 - 1299 19TH ST | 1200 - 1299 19TH ST | 1200 19TH ST | - | TEXAS ST | TEXAS ST |
| 21102 | N/A | Point | 1 | 1 | 700 - 799 | - | S229575 | 700-799 MINNESOTA ST | 700-799 MINNESOTA ST | F | F | - | F | 9055000 | 9055000 | - | - | WEST SIDE | - | - | - | - | 19TH ST | 19TH ST | 65361 | 65361 | 37.76103833 | -122.39051381 | - | - | 1745530779000 | middleware_editor | NPRK 2AM-6AM MON STCL | 19TH ST to 20TH ST (700 - 799) | - | 200FT SOUTH OF 19TH | - | - | - | - | - | 38180 | 1046764800000 | -122.39051381 | 37.76103833 | - | 1715193600000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0119 | 18X18 | SUP1 | 2IN IRON POST | IS | 1475677920000 | MINNESOTA ST | 700 - 799 MINNESOTA ST | 700 - 799 MINNESOTA ST | 700 MINNESOTA ST | - | 20TH ST | 20TH ST |
| 21103 | N/A | Point | 1 | 1 | 600 - 699 | - | S229621 | 600-699 SAWYER ST | 600-699 SAWYER ST | F | F | - | F | 11669000 | 11669000 | - | - | EAST SIDE | - | - | - | - | SUNRISE WAY | SUNRISE WAY | 65362 | 65362 | 37.70934791 | -122.41597642 | - | - | 1710539427000 | MTA | NPRK 8AM-11AM MON STCL | SUNRISE WAY to CALGARY ST \ VELASCO AVE (600 - 699) | - | OPP. #632 | - | - | - | - | - | 38181 | 1476443040000 | -122.41597642 | 37.70934791 | - | 1476403200000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0275 | 18X18 | SUP1 | 2IN IRON POST | IS | 1475763540000 | SAWYER ST | 600 - 699 SAWYER ST | 600 - 699 SAWYER ST | 600 SAWYER ST | - | CALGARY ST \ VELASCO AVE | CALGARY ST \ VELASCO AVE |
| 21104 | N/A | Point | 1 | 1 | 600 - 699 | - | S229622 | 600-699 SAWYER ST | 600-699 SAWYER ST | F | F | - | F | 11669000 | 11669000 | - | - | WEST SIDE | - | - | - | - | SUNRISE WAY | SUNRISE WAY | 65363 | 65363 | 37.70934791 | -122.41597642 | - | - | 1710539427000 | MTA | NPRK 8AM-11AM WED STCL | SUNRISE WAY to CALGARY ST \ VELASCO AVE (600 - 699) | - | INFO #620 | - | - | - | - | - | 38182 | 1476442980000 | -122.41597642 | 37.70934791 | - | 1476403200000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0278 | 18X18 | SUP1 | 2IN IRON POST | IS | 1475763600000 | SAWYER ST | 600 - 699 SAWYER ST | 600 - 699 SAWYER ST | 600 SAWYER ST | - | CALGARY ST \ VELASCO AVE | CALGARY ST \ VELASCO AVE |
| 21105 | N/A | Point | - | - | - | - | S230011 | BANKS ST: TOMPKINS AVE | - | F | F | - | F | 21052000 | 21052000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | BANKS ST | 65366 | 65366 | 37.73703469 | -122.41285757 | BANKS ST \ TOMPKINS AVE | TOMPKINS AVE \ BANKS ST | 1746472958000 | middleware_editor | ONE WAY (LA) | BANKS ST intersection | - | ABOVE STOP SIGN | - | - | - | - | - | 38183 | 125308800000 | -122.41285757 | 37.73703469 | - | 1494918000000 | - | D9 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP2 | 2IN IRON POST | IS | 1476968700000 | TOMPKINS AVE | - | - | - | - | - | - |
| 21106 | N/A | Point | - | - | - | - | S230012 | BANKS ST: TOMPKINS AVE | - | F | F | - | F | 21052000 | 21052000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | BANKS ST | 65367 | 65367 | 37.73703469 | -122.41285757 | BANKS ST \ TOMPKINS AVE | TOMPKINS AVE \ BANKS ST | 1746472952000 | middleware_editor | ONE WAY (RA) | BANKS ST intersection | - | ABOVE EXISTING NEIGHBORHOOD WATCH SIGN | - | - | - | - | - | 38184 | 125308800000 | -122.41285757 | 37.73703469 | - | 1494918000000 | - | D9 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | 2IN IRON POST | IS | 1476969300000 | TOMPKINS AVE | - | - | - | - | - | - |
| 21107 | N/A | Point | - | - | - | - | S230018 | BANKS ST: TOMPKINS AVE | - | F | F | - | F | 21052000 | 21052000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | BANKS ST | 65368 | 65368 | 37.73703469 | -122.41285757 | BANKS ST \ TOMPKINS AVE | TOMPKINS AVE \ BANKS ST | 1746473014000 | middleware_editor | STOP | BANKS ST intersection | - | - | - | - | - | - | - | 38185 | 125308800000 | -122.41285757 | 37.73703469 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1476970800000 | TOMPKINS AVE | - | - | - | - | - | - |
| 21108 | N/A | Point | - | - | - | - | S230019 | BANKS ST: TOMPKINS AVE | - | F | F | - | F | 21052000 | 21052000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | BANKS ST | 65369 | 65369 | 37.73703469 | -122.41285757 | BANKS ST \ TOMPKINS AVE | TOMPKINS AVE \ BANKS ST | 1746473013000 | middleware_editor | ONE WAY (RA) | BANKS ST intersection | - | ON POLE WHERE STOP SIGN WAS REMOVED | - | - | - | - | - | 38186 | 125308800000 | -122.41285757 | 37.73703469 | - | 1494918000000 | - | D9 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | 2IN IRON POST | IS | 1476971340000 | TOMPKINS AVE | - | - | - | - | - | - |
| 21109 | N/A | Point | - | - | - | - | S230021 | BANKS ST: OGDEN AVE | - | F | F | - | F | 21050000 | 21050000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | OGDEN AVE | BANKS ST | 65370 | 65370 | 37.73585735 | -122.41296404 | BANKS ST \ OGDEN AVE | OGDEN AVE \ BANKS ST | 1710539427000 | MTA | DO NOT ENTER | BANKS ST intersection | - | BACK TO BACK WITH STOP SIGN | - | - | - | - | - | 38187 | 1173225600000 | -122.41296404 | 37.73585735 | - | 1494892800000 | - | D9 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1476972480000 | OGDEN AVE | - | - | - | - | - | - |
| 21110 | N/A | Point | - | - | - | - | S230023 | BANKS ST: OGDEN AVE | - | F | F | - | F | 21050000 | 21050000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | OGDEN AVE | BANKS ST | 65371 | 65371 | 37.73585735 | -122.41296404 | BANKS ST \ OGDEN AVE | OGDEN AVE \ BANKS ST | 1710539427000 | MTA | ONE WAY (LA) | BANKS ST intersection | - | ABOVE EXISTING STOP SIGN | - | - | - | - | - | 38188 | 1173225600000 | -122.41296404 | 37.73585735 | - | 1494892800000 | - | D9 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP2 | 2IN IRON POST | IS | 1476972780000 | OGDEN AVE | - | - | - | - | - | - |
| 21111 | N/A | Point | - | - | - | - | S229814 | CORTLAND AVE: BRADFORD ST | - | F | F | - | F | 21037000 | 21037000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BRADFORD ST | CORTLAND AVE | 65372 | 65372 | 37.73971763 | -122.40949339 | CORTLAND AVE \ BRADFORD ST | BRADFORD ST \ CORTLAND AVE | 1739573159000 | middleware_editor | CORTLAND AVE | CORTLAND AVE intersection | - | (1500)-->EAST | - | - | - | - | - | 38189 | 1487154480000 | -122.40949339 | 37.73971763 | - | 1487116800000 | - | D9 | - | STREET NAME | GUIDE | D3-1.0448 | 36X08 | SUP2 | 3IN IRON POST | IS | 1476359040000 | BRADFORD ST | - | - | - | - | - | - |
| 21112 | N/A | Point | - | - | - | - | S231637 | COLUMBUS AVE: GREENWICH ST \ S | - | T | T | - | F | 25442000 | 25442000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | COLUMBUS AVE \ SCOTLAND ST | COLUMBUS AVE \ SCOTLAND ST | 65373 | 65373 | 37.80193064 | -122.41254128 | GREENWICH ST \ COLUMBUS AVE \ SCOTLAND ST | GREENWICH ST \ COLUMBUS AVE \ SCOTLAND ST | 1740753865000 | middleware_editor | RAILROAD TRACK ADVANCE WARNING CROSS BUCK (SYM) | COLUMBUS AVE \ SCOTLAND ST intersection | - | X ST IS GREENWICH | - | - | - | - | - | 38190 | 1481629800000 | -122.41254128 | 37.80193064 | - | 1481587200000 | - | D3 | - | OTHER WARNING | WARNING | W47(CA).0002 | 30X30 | SUP1 | UTILITY POLE | IS | 1481199660000 | GREENWICH ST | - | - | - | - | - | - |
| 21113 | N/A | Point | 1 | 1 | 100 - 199 | - | S229696 | 100-199 CLEMENT ST | 100-199 CLEMENT ST | F | F | - | F | 4151000 | 4151000 | - | - | NORTH SIDE | - | - | - | - | 2ND AVE | 02ND AVE | 65405 | 65405 | 37.78311197 | -122.46067234 | - | - | 1710539427000 | MTA | BIKE RACK | 02ND AVE to 03RD AVE (100 - 199) | 201600259 | 7 FT6" EAST OF WPL#116 2FT6" FROM CRUB | - | - | - | - | - | 38191 | 1478044800000 | -122.46067234 | 37.78311197 | - | 1478044800000 | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1476180300000 | CLEMENT ST | 100 - 199 CLEMENT ST | 100 - 199 CLEMENT ST | 100 CLEMENT ST | - | 03RD AVE | 03RD AVE |
| 21114 | N/A | Point | 1 | 1 | 100 - 199 | - | S229698 | 100-199 CLEMENT ST | 100-199 CLEMENT ST | F | F | - | F | 4151000 | 4151000 | - | - | NORTH SIDE | - | - | - | - | 2ND AVE | 02ND AVE | 65406 | 65406 | 37.78311197 | -122.46067234 | - | - | 1710539427000 | MTA | BIKE RACK | 02ND AVE to 03RD AVE (100 - 199) | 201600259 | 18FT EAST OF WPL#116 2FT 6" FROM CRUB | - | - | - | - | - | 38192 | 1485129600000 | -122.46067234 | 37.78311197 | - | 1485129600000 | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1476180720000 | CLEMENT ST | 100 - 199 CLEMENT ST | 100 - 199 CLEMENT ST | 100 CLEMENT ST | - | 03RD AVE | 03RD AVE |
| 21115 | N/A | Point | 1 | 1 | 100 - 199 | - | S229700 | 100-199 CLEMENT ST | 100-199 CLEMENT ST | F | F | - | F | 4151000 | 4151000 | - | - | SOUTH SIDE | - | - | - | - | 2ND AVE | 02ND AVE | 65407 | 65407 | 37.78311197 | -122.46067234 | - | - | 1710539427000 | MTA | BIKE RACK | 02ND AVE to 03RD AVE (100 - 199) | 201600263 | 14 FT EAST OF WPL#111 3 FT FROM CRUB | - | - | - | - | - | 38193 | 1478044800000 | -122.46067234 | 37.78311197 | - | 1478044800000 | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1476181080000 | CLEMENT ST | 100 - 199 CLEMENT ST | 100 - 199 CLEMENT ST | 100 CLEMENT ST | - | 03RD AVE | 03RD AVE |
| 21116 | N/A | Point | 1 | 1 | 300 - 399 | - | S214635 | 300-399 BRODERICK ST | 300-399 BRODERICK ST | F | F | - | F | 3190000 | 3190000 | - | - | WEST SIDE | - | - | - | - | OAK ST | OAK ST | 55970 | 55970 | 37.77338455 | -122.4391827 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM EXC SAT & SUN | OAK ST to FELL ST (300 - 399) | - | 50' NORTH OF OAK ST | - | - | - | - | - | 38194 | 1440681780000 | -122.4391827 | 37.77338455 | - | 1440633600000 | - | D5 | - | PARKING | REG | R32(CA).0081 | 18X18 | SUP1 | 2IN IRON POST | IS | 1427448420000 | BRODERICK ST | 300 - 399 BRODERICK ST | 300 - 399 BRODERICK ST | 300 BRODERICK ST | - | FELL ST | FELL ST |
| 21117 | N/A | Point | 1 | 1 | 200 - 299 | - | S214638 | 200-299 BAKER ST | 200-299 BAKER ST | F | F | - | F | 2606000 | 2606000 | - | - | EAST SIDE | - | - | - | - | OAK ST | OAK ST | 55971 | 55971 | 37.77317409 | -122.44082847 | - | - | 1728349911000 | middleware_editor | 2 HR PRK 8AM-6PM EXC SAT & SUN | OAK ST to FELL ST (200 - 299) | - | 120'S OF FELL | - | - | - | - | - | 38195 | 1440424980000 | -122.44082847 | 37.77317409 | - | 1440374400000 | - | D5 | - | PARKING | REG | R32(CA).0081 | 18X18 | SUP1 | 2IN IRON POST | IS | 1427449560000 | BAKER ST | 200 - 299 BAKER ST | 200 - 299 BAKER ST | 200 BAKER ST | - | FELL ST | FELL ST |
| 21118 | N/A | Point | - | - | - | - | S212577 | RANDOLPH ST: BRIGHT ST | - | F | F | - | F | 22496000 | 22496000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | RANDOLPH ST | BRIGHT ST | 55972 | 55972 | 37.71430078 | -122.4634997 | BRIGHT ST \ RANDOLPH ST | RANDOLPH ST \ BRIGHT ST | 1710539427000 | MTA | (45 LA-DN) | BRIGHT ST intersection | - | - | - | - | - | - | - | 38196 | 1270080000000 | -122.4634997 | 37.71430078 | - | 1589155200000 | - | D11 | - | OTHER WARNING | WARNING | W16-7P.0001 | 18X18 | SUP2 | SIGNAL POLE | IS | 1421229240000 | RANDOLPH ST | - | - | - | - | - | - |
| 21119 | N/A | Point | - | - | - | - | S212580 | RANDOLPH ST: BRIGHT ST | - | F | F | - | F | 22496000 | 22496000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | RANDOLPH ST | BRIGHT ST | 55973 | 55973 | 37.71430078 | -122.4634997 | BRIGHT ST \ RANDOLPH ST | RANDOLPH ST \ BRIGHT ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | BRIGHT ST intersection | - | 2`NORTH ON NEW BULB | - | - | - | - | - | 38197 | 1270080000000 | -122.4634997 | 37.71430078 | - | 1589414400000 | - | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | SIGNAL POLE | IS | 1421229540000 | RANDOLPH ST | - | - | - | - | - | - |
| 21120 | N/A | Point | - | - | - | - | S212581 | RANDOLPH ST: BRIGHT ST | - | F | F | - | F | 22496000 | 22496000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | RANDOLPH ST | BRIGHT ST | 55974 | 55974 | 37.71430078 | -122.4634997 | BRIGHT ST \ RANDOLPH ST | RANDOLPH ST \ BRIGHT ST | 1710539427000 | MTA | (45 RA-DN) | BRIGHT ST intersection | - | - | - | - | - | - | - | 38198 | 1270080000000 | -122.4634997 | 37.71430078 | - | 1589155200000 | - | D11 | - | OTHER WARNING | WARNING | W16-7P.0006 | 24X12 | SUP2 | SIGNAL POLE | IS | 1421229720000 | RANDOLPH ST | - | - | - | - | - | - |
| 21121 | N/A | Point | - | - | - | - | S212586 | ORIZABA AVE: RANDOLPH ST | - | F | F | - | F | 22497000 | 22497000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ORIZABA AVE | RANDOLPH ST | 55975 | 55975 | 37.71430765 | -122.46260204 | RANDOLPH ST \ ORIZABA AVE | ORIZABA AVE \ RANDOLPH ST | 1740503405000 | middleware_editor | STOP | RANDOLPH ST intersection | - | 6`SOUTH TO NEW BULB | - | - | - | - | - | 38199 | 105321600000 | -122.46260204 | 37.71430765 | - | 1446508800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1421233260000 | ORIZABA AVE | - | - | - | - | - | - |
| 21122 | N/A | Point | 1 | 1 | 1600 - 1657 | - | S217115 | 1600-1657 GREENWICH ST | 1600-1657 GREENWICH ST | F | F | - | F | 6512000 | 6512000 | - | - | NORTH SIDE | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 55976 | 55976 | 37.80015627 | -122.42639442 | - | - | 1752010753000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "KM" PERMITS | FRANKLIN ST to IMPERIAL ALY (1600 - 1657) | - | 75' WEST OF FRANKLIN | - | - | - | - | - | 38200 | 1219993200000 | -122.42639442 | 37.80015627 | - | 1751911200000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0094 | 18X21 | SUP1 | 2IN IRON POST | IS | 1434459060000 | GREENWICH ST | 1600 - 1657 GREENWICH ST | 1600 - 1657 GREENWICH ST | 1600 GREENWICH ST | - | IMPERIAL ALY | IMPERIAL ALY |
| 21123 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S217122 | 2200-2299 CLAY ST | 2200-2299 CLAY ST | F | F | - | F | 4109000 | 4109000 | - | - | NORTH SIDE | - | - | - | - | LAGUNA ST | LAGUNA ST | 55977 | 55977 | 37.79123407 | -122.43009204 | - | - | 1749751213000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "G" PERMITS | LAGUNA ST to BUCHANAN ST (2200 - 2299) | - | 2216 CLAY | - | - | - | - | - | 38201 | 1220338800000 | -122.43009204 | 37.79123407 | - | - | - | D2 | - | PARKING:RPP | REG | R32C(CA).0086 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1434460500000 | CLAY ST | 2200 - 2299 CLAY ST | 2200 - 2299 CLAY ST | 2200 CLAY ST | - | BUCHANAN ST | BUCHANAN ST |
| 21124 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S217123 | 2200-2299 CLAY ST | 2200-2299 CLAY ST | F | F | - | F | 4109000 | 4109000 | - | - | NORTH SIDE | - | - | - | - | LAGUNA ST | LAGUNA ST | 55978 | 55978 | 37.79123407 | -122.43009204 | - | - | 1749751244000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "G" PERMITS | LAGUNA ST to BUCHANAN ST (2200 - 2299) | - | 2224 CLAY | - | - | - | - | - | 38202 | 1220338800000 | -122.43009204 | 37.79123407 | - | 1434697200000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0086 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1434460680000 | CLAY ST | 2200 - 2299 CLAY ST | 2200 - 2299 CLAY ST | 2200 CLAY ST | - | BUCHANAN ST | BUCHANAN ST |
| 21125 | N/A | Point | - | - | - | - | S217124 | CLAY ST: BUCHANAN ST | - | F | F | - | F | 26563000 | 26563000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BUCHANAN ST | CLAY ST | 55979 | 55979 | 37.79112951 | -122.43091425 | CLAY ST \ BUCHANAN ST | BUCHANAN ST \ CLAY ST | 1736271966000 | middleware_editor | DO NOT ENTER | CLAY ST intersection | - | CROSS ST IS BUCHANAN ST | - | - | - | - | - | 38203 | 130982400000 | -122.43091425 | 37.79112951 | - | - | - | D2 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | 3IN IRON POST | IS | 1434460980000 | BUCHANAN ST | - | - | - | - | - | - |
| 21126 | N/A | Point | - | - | - | - | S217457 | TURK ST: MARKET ST \ MASON ST | - | T | T | - | F | 24898000 | 24898000 | - | - | CENTER ISLAND, E LINE, SOUTHBOUND | - | - | - | - | MASON ST \ TURK ST | MARKET ST \ TURK ST | 55981 | 55981 | 37.78328785 | -122.40895216 | MARKET ST \ MASON ST \ TURK ST | MASON ST \ MARKET ST \ TURK ST | 1742921118000 | middleware_editor | DO NOT ENTER | MARKET ST \ TURK ST intersection | - | - | - | - | - | - | - | 38204 | 1438725120000 | -122.40895216 | 37.78328785 | - | 1438671600000 | - | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | SIGNAL POLE | IS | 1435312020000 | MASON ST | - | - | - | - | - | - |
| 21127 | N/A | Point | - | - | - | - | S217462 | 7TH ST: 16TH ST \ MISSISSIPPI | - | T | T | - | F | 23785000 | 23785000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 07TH ST \ MISSISSIPPI ST | 07TH ST \ MISSISSIPPI ST | 55983 | 55983 | 37.76654458 | -122.39506055 | 16TH ST \ 07TH ST \ MISSISSIPPI ST | 16TH ST \ 07TH ST \ MISSISSIPPI ST | 1710967591000 | evillan | NO RIGHT TURN (SYM) | 07TH ST \ MISSISSIPPI ST intersection | - | 20' NORTH OF STEVENSON | - | - | - | - | - | 38205 | 1438646400000 | -122.39506055 | 37.76654458 | - | 1438646400000 | - | D10 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1435313700000 | 16TH ST | - | - | - | - | - | - |
| 21128 | N/A | Point | - | - | - | - | S217464 | CHARLES J BRENHAM PL: 7TH ST \ | - | T | T | - | F | 30742000 | 30742000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 7TH ST \ CHARLES J BRENHAM PL | 07TH ST \ CHARLES J BRENHAM PL | 55984 | 55984 | 37.78047851 | -122.41251226 | MARKET ST \ 7TH ST \ CHARLES J BRENHAM PL | MARKET ST \ 07TH ST \ CHARLES J BRENHAM PL | 1710539427000 | MTA | NO RIGHT TURN (SYM) | 07TH ST \ CHARLES J BRENHAM PL intersection | - | - | - | - | - | - | - | 38206 | 1438700340000 | -122.41251226 | 37.78047851 | - | 1438646400000 | - | D6 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1435313880000 | MARKET ST | - | - | - | - | - | - |
| 21129 | N/A | Point | 1 | 1 | 1 - 99 | - | S217472 | 1-99 GOLDEN GATE AVE | 1-99 GOLDEN GATE AVE | T | T | - | F | 6259000 | 6259000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 6TH ST \ MARKET ST \ TAYLOR ST | 06TH ST \ MARKET ST \ TAYLOR ST | 55985 | 55985 | 37.78218666 | -122.41125738 | - | - | 1710539427000 | MTA | NO RIGHT TURN (SYM) | 06TH ST \ MARKET ST \ TAYLOR ST to JONES ST (1 - 99) | - | 100' WEST | - | - | - | - | - | 38207 | 1173139200000 | -122.41125738 | 37.78218666 | - | 1438732800000 | - | D6 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1435315020000 | GOLDEN GATE AVE | 1 - 99 GOLDEN GATE AVE | 1 - 99 GOLDEN GATE AVE | 1 GOLDEN GATE AVE | - | JONES ST | JONES ST |
| 21130 | N/A | Point | - | - | - | - | S220139 | MCALLISTER ST: WEBSTER ST | - | T | T | - | F | 25967000 | 25967000 | - | - | NORTH WEST CORNER | - | - | - | - | MCALLISTER ST | WEBSTER ST | 56688 | 56688 | 37.77885093 | -122.43004727 | WEBSTER ST \ MCALLISTER ST | MCALLISTER ST \ WEBSTER ST | 1710539427000 | MTA | WEBSTER ST | WEBSTER ST intersection | - | - | - | - | - | - | - | 38208 | 1573217580000 | -122.43004727 | 37.77885093 | - | - | - | D5 | - | STREET NAME | GUIDE | D3-1.1845 | 36X08 | SUP1 | MUNI POLE | IS | 1445424540000 | MCALLISTER ST | - | - | - | - | - | - |
| 21131 | N/A | Point | - | - | - | - | S220140 | MCALLISTER ST: WEBSTER ST | - | T | T | - | F | 25967000 | 25967000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MCALLISTER ST | WEBSTER ST | 56689 | 56689 | 37.77885093 | -122.43004727 | WEBSTER ST \ MCALLISTER ST | MCALLISTER ST \ WEBSTER ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | WEBSTER ST intersection | - | - | - | - | - | - | - | 38209 | 1449230520000 | -122.43004727 | 37.77885093 | - | 1449187200000 | - | D5 | - | NO RIGHT TURN | REG | R13A(CA).0001 | 18X30 | SUP1 | MUNI POLE | IS | 1445424660000 | MCALLISTER ST | - | - | - | - | - | - |
| 21132 | N/A | Point | - | - | - | - | S220143 | MCALLISTER ST: WEBSTER ST | - | T | T | - | F | 25967000 | 25967000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MCALLISTER ST | WEBSTER ST | 56690 | 56690 | 37.77885093 | -122.43004727 | WEBSTER ST \ MCALLISTER ST | MCALLISTER ST \ WEBSTER ST | 1710539427000 | MTA | EXC BICYCLES | WEBSTER ST intersection | - | - | - | - | - | - | - | 38210 | 1449156840000 | -122.43004727 | 37.77885093 | - | 1449100800000 | - | D5 | - | OTHER REGULATORY | REG | R(SF).0058 | 24X18 | SUP1 | MUNI POLE | IS | 1445424960000 | MCALLISTER ST | - | - | - | - | - | - |
| 21133 | N/A | Point | - | - | - | - | S220144 | MCALLISTER ST: WEBSTER ST | - | T | T | - | F | 25967000 | 25967000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MCALLISTER ST | WEBSTER ST | 56691 | 56691 | 37.77885093 | -122.43004727 | WEBSTER ST \ MCALLISTER ST | MCALLISTER ST \ WEBSTER ST | 1710539427000 | MTA | WEBSTER ST | WEBSTER ST intersection | - | - | - | - | - | - | - | 38211 | 1569339120000 | -122.43004727 | 37.77885093 | - | - | - | D5 | - | STREET NAME | GUIDE | D3-2.0357 | 72X18 | SUP1 | LIGHT POLE | IS | 1445425320000 | MCALLISTER ST | - | - | - | - | - | - |
| 21134 | N/A | Point | - | - | - | - | S220146 | MCALLISTER ST: WEBSTER ST | - | T | T | - | F | 25967000 | 25967000 | - | - | SOUTH EAST CORNER | - | - | - | - | MCALLISTER ST | WEBSTER ST | 56692 | 56692 | 37.77885093 | -122.43004727 | WEBSTER ST \ MCALLISTER ST | MCALLISTER ST \ WEBSTER ST | 1710539427000 | MTA | WEBSTER ST | WEBSTER ST intersection | - | - | - | - | - | - | - | 38212 | 1573217700000 | -122.43004727 | 37.77885093 | - | - | - | D5 | - | STREET NAME | GUIDE | D3-1.1845 | 36X08 | SUP1 | LIGHT POLE | IS | 1445425440000 | MCALLISTER ST | - | - | - | - | - | - |
| 21135 | N/A | Point | - | - | - | - | S220148 | MCALLISTER ST: WEBSTER ST | - | T | T | - | F | 25967000 | 25967000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MCALLISTER ST | WEBSTER ST | 56693 | 56693 | 37.77885093 | -122.43004727 | WEBSTER ST \ MCALLISTER ST | MCALLISTER ST \ WEBSTER ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | WEBSTER ST intersection | - | - | - | - | - | - | - | 38213 | 1449230700000 | -122.43004727 | 37.77885093 | - | 1449187200000 | - | D5 | - | NO RIGHT TURN | REG | R13A(CA).0001 | 18X30 | SUP1 | LIGHT POLE | IS | 1445425620000 | MCALLISTER ST | - | - | - | - | - | - |
| 21136 | N/A | Point | 1 | 1 | 1 - 38 | - | S220152 | 1-38 GOUGH ST | 1-38 GOUGH ST | F | F | - | F | 6307000 | 6307000 | - | - | EAST SIDE | - | - | - | - | MCCOPPIN ST \ OTIS ST | MCCOPPIN ST \ OTIS ST | 56694 | 56694 | 37.77205709 | -122.42070622 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM TUE THUR STCL | MCCOPPIN ST \ OTIS ST to COLTON ST (1 - 38) | - | IFO #12 | - | - | - | - | - | 38214 | 1449489120000 | -122.42070622 | 37.77205709 | - | 1449446400000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0058 | 18X18 | SUP1 | 2IN IRON POST | IS | 1445426820000 | GOUGH ST | 1 - 38 GOUGH ST | 1 - 38 GOUGH ST | 1 GOUGH ST | - | COLTON ST | COLTON ST |
| 21137 | N/A | Point | 1 | 1 | 1 - 38 | - | S220153 | 1-38 GOUGH ST | 1-38 GOUGH ST | F | F | - | F | 6307000 | 6307000 | - | - | EAST SIDE | - | - | - | - | MCCOPPIN ST \ OTIS ST | MCCOPPIN ST \ OTIS ST | 56695 | 56695 | 37.77205709 | -122.42070622 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | MCCOPPIN ST \ OTIS ST to COLTON ST (1 - 38) | - | IFO #12 | - | - | - | - | - | 38215 | 1449489000000 | -122.42070622 | 37.77205709 | - | 1449446400000 | - | D6 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP1 | 2IN IRON POST | IS | 1445426940000 | GOUGH ST | 1 - 38 GOUGH ST | 1 - 38 GOUGH ST | 1 GOUGH ST | - | COLTON ST | COLTON ST |
| 21138 | N/A | Point | 1 | 1 | 1 - 38 | RIGHT ARROW | S220155 | 1-38 GOUGH ST | 1-38 GOUGH ST | F | F | - | F | 6307000 | 6307000 | - | - | EAST SIDE | - | - | - | - | MCCOPPIN ST \ OTIS ST | MCCOPPIN ST \ OTIS ST | 56696 | 56696 | 37.77205709 | -122.42070622 | - | - | 1710539427000 | MTA | TA (SYM) PLO 8AM-5PM MON-FRI (5 MIN) | MCCOPPIN ST \ OTIS ST to COLTON ST (1 - 38) | - | NPL #2 | - | - | - | - | - | 38216 | 1449488880000 | -122.42070622 | 37.77205709 | - | 1449446400000 | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0031 | 14X21 | SUP1 | 2IN IRON POST | IS | 1445431680000 | GOUGH ST | 1 - 38 GOUGH ST | 1 - 38 GOUGH ST | 1 GOUGH ST | - | COLTON ST | COLTON ST |
| 21139 | N/A | Point | 1 | 1 | 1 - 38 | LEFT ARROW | S220156 | 1-38 GOUGH ST | 1-38 GOUGH ST | F | F | - | F | 6307000 | 6307000 | - | - | EAST SIDE | - | - | - | - | MCCOPPIN ST \ OTIS ST | MCCOPPIN ST \ OTIS ST | 56697 | 56697 | 37.77205709 | -122.42070622 | - | - | 1710539427000 | MTA | TA (SYM) PLO 8AM-5PM MON-FRI (5 MIN) | MCCOPPIN ST \ OTIS ST to COLTON ST (1 - 38) | - | 15' NORTH OF OTIS | - | - | - | - | - | 38217 | 1449488940000 | -122.42070622 | 37.77205709 | - | 1449446400000 | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0031 | 14X21 | SUP1 | 2IN IRON POST | IS | 1445431860000 | GOUGH ST | 1 - 38 GOUGH ST | 1 - 38 GOUGH ST | 1 GOUGH ST | - | COLTON ST | COLTON ST |
| 21140 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S220158 | 1700-1799 HYDE ST | 1700-1799 HYDE ST | F | F | - | F | 7134000 | 7134000 | - | - | WEST SIDE | - | - | - | - | BROADWAY | BROADWAY | 56699 | 56699 | 37.79680465 | -122.41856467 | - | - | 1711747889000 | middleware_editor | 2 HR PRK 8AM-7PM MON-FRI EXC "AC" PERMITS | BROADWAY to VALLEJO ST (1700 - 1799) | - | IFO #1715 | - | - | - | - | - | 38218 | - | -122.41856467 | 37.79680465 | - | 1708683300000 | - | D3 | - | PARKING:RPP | REG | R32C(CA).0113 | 18X21 | SUP1 | 2IN IRON POST | IS | 1445433420000 | HYDE ST | 1700 - 1799 HYDE ST | 1700 - 1799 HYDE ST | 1700 HYDE ST | - | VALLEJO ST | VALLEJO ST |
| 21141 | N/A | Point | 1 | 1 | 1608 - 1699 | - | S220159 | 1601-1699 HYDE ST | 1608-1699 HYDE ST | F | F | - | F | 7133000 | 7133000 | - | - | EAST SIDE | - | - | - | - | LYNCH ST | LYNCH ST | 56700 | 56700 | 37.79599586 | -122.41840112 | - | - | 1710539427000 | MTA | TRUCKS NOT ADVISED ON BROADWAY | LYNCH ST to BROADWAY (1608 - 1699) | - | NPL #1612 | - | - | - | - | - | 38219 | - | -122.41840112 | 37.79599586 | - | - | - | D3 | - | OTHER WARNING | WARNING | W(SF).0082 | 30X24 | SUP1 | LIGHT POLE | IS | 1445434080000 | HYDE ST | 1608 - 1699 HYDE ST | 1608 - 1699 HYDE ST | 1608 HYDE ST | - | BROADWAY | BROADWAY |
| 21142 | N/A | Point | 1 | 1 | 1 - 100 | - | S220633 | 1-99 STANFORD ST | 1-100 STANFORD ST | F | F | - | F | 12068000 | 12068000 | - | - | WEST SIDE | - | - | - | - | BRANNAN ST | BRANNAN ST | 56701 | 56701 | 37.78080267 | -122.39183883 | - | - | 1710539427000 | MTA | TANP ANY TIME | BRANNAN ST to TOWNSEND ST (1 - 100) | - | 280' S OF BRANNAN | - | - | - | - | - | 38220 | 1447329060000 | -122.39183883 | 37.78080267 | - | 1707394500000 | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | UTILITY POLE | IS | 1447158420000 | STANFORD ST | 1 - 100 STANFORD ST | 1 - 100 STANFORD ST | 1 STANFORD ST | - | TOWNSEND ST | TOWNSEND ST |
| 21143 | N/A | Point | 1 | 1 | 200 - 299 | - | S215187 | 200-299 WINDING WAY | 200-299 WINDING WAY | F | F | - | F | 13674000 | 13674000 | - | - | NORTH SIDE | - | - | - | - | CORDOVA ST | CORDOVA ST | 56702 | 56702 | 37.70942475 | -122.43532749 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM TUE STCL | CORDOVA ST to DRAKE ST (200 - 299) | - | IFO#242 | - | - | - | - | - | 38221 | - | -122.43532749 | 37.70942475 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0083 | 18X18 | SUP2 | 2IN IRON POST | IS | 1428571680000 | WINDING WAY | 200 - 299 WINDING WAY | 200 - 299 WINDING WAY | 200 WINDING WAY | - | DRAKE ST | DRAKE ST |
| 21144 | N/A | Point | 1 | 1 | 200 - 299 | - | S215188 | 200-299 WINDING WAY | 200-299 WINDING WAY | F | F | - | F | 13674000 | 13674000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CORDOVA ST | CORDOVA ST | 56703 | 56703 | 37.70942475 | -122.43532749 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | CORDOVA ST to DRAKE ST (200 - 299) | - | 35`WEST | - | - | - | - | - | 38222 | 1429007280000 | -122.43532749 | 37.70942475 | - | 1428969600000 | - | D11 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1428571920000 | WINDING WAY | 200 - 299 WINDING WAY | 200 - 299 WINDING WAY | 200 WINDING WAY | - | DRAKE ST | DRAKE ST |
| 21145 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S216389 | 1400-1499 HAYES ST | 1400-1499 HAYES ST | F | F | - | F | 6826000 | 6826000 | - | - | SOUTH SIDE | - | - | - | - | BRODERICK ST | BRODERICK ST | 56711 | 56711 | 37.77467286 | -122.44028832 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM THUR STCL | BRODERICK ST to BAKER ST (1400 - 1499) | - | 15'E OF BAKER | - | - | - | - | - | 38223 | 1433850180000 | -122.44028832 | 37.77467286 | - | 1433808000000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0304 | 18X18 | SUP1 | MUNI POLE | IS | 1432208340000 | HAYES ST | 1400 - 1499 HAYES ST | 1400 - 1499 HAYES ST | 1400 HAYES ST | - | BAKER ST | BAKER ST |
| 21146 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S216390 | 1400-1499 HAYES ST | 1400-1499 HAYES ST | F | F | - | F | 6826000 | 6826000 | - | - | SOUTH SIDE | - | - | - | - | BRODERICK ST | BRODERICK ST | 56712 | 56712 | 37.77467286 | -122.44028832 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "Q" PERMITS | BRODERICK ST to BAKER ST (1400 - 1499) | - | 15'E OF BAKER | - | - | - | - | - | 38224 | 1438958460000 | -122.44028832 | 37.77467286 | - | 1438905600000 | - | D5 | - | PARKING:RPP | REG | R32C(CA).0215 | 18X21 | SUP1 | MUNI POLE | IS | 1432208460000 | HAYES ST | 1400 - 1499 HAYES ST | 1400 - 1499 HAYES ST | 1400 HAYES ST | - | BAKER ST | BAKER ST |
| 21147 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S216391 | 1400-1499 HAYES ST | 1400-1499 HAYES ST | F | F | - | F | 6826000 | 6826000 | - | - | SOUTH SIDE | - | - | - | - | BRODERICK ST | BRODERICK ST | 56713 | 56713 | 37.77467286 | -122.44028832 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM THUR STCL | BRODERICK ST to BAKER ST (1400 - 1499) | - | EPL #1451 | - | - | - | - | - | 38225 | 1433849940000 | -122.44028832 | 37.77467286 | - | 1433808000000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0304 | 18X18 | SUP1 | MUNI POLE | IS | 1432208640000 | HAYES ST | 1400 - 1499 HAYES ST | 1400 - 1499 HAYES ST | 1400 HAYES ST | - | BAKER ST | BAKER ST |
| 21148 | N/A | Point | 1 | 1 | 139 - 199 | - | S224679 | 139-199 14TH ST | 139-199 14TH ST | F | F | - | F | 581000 | 581000 | - | - | EAST SIDE, EASTBOUND TRAFFIC | - | - | - | - | SHOTWELL ST | SHOTWELL ST | 57445 | 57445 | 37.76843832 | -122.41725476 | - | - | 1710539427000 | MTA | ONE WAY (RA) | SHOTWELL ST to SOUTH VAN NESS AVE (139 - 199) | - | OPP CENTER LINE OF SHOTWELL | - | - | - | - | - | 38226 | - | -122.41725476 | 37.76843832 | - | - | - | D9 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | 2IN IRON POST | IS | 1460370360000 | 14TH ST | 139 - 199 14TH ST | 139 - 199 14TH ST | 139 14TH ST | - | SOUTH VAN NESS AVE | SOUTH VAN NESS AVE |
| 21149 | N/A | Point | 1 | 1 | 200 - 223 | - | S224682 | 200-223 TOWNSEND ST | 200-223 TOWNSEND ST | F | F | - | F | 12659000 | 12659000 | - | - | NORTH SIDE | - | - | - | - | 3RD ST | 03RD ST | 57446 | 57446 | 37.77863961 | -122.39301839 | - | - | 1713879379000 | middleware_editor | BIKE RACK | 03RD ST to RITCH ST (200 - 223) | - | WPL #214 | - | - | - | - | - | 38227 | - | -122.39301839 | 37.77863961 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1460371980000 | TOWNSEND ST | 200 - 223 TOWNSEND ST | 200 - 223 TOWNSEND ST | 200 TOWNSEND ST | - | RITCH ST | RITCH ST |
| 21150 | N/A | Point | 1 | 1 | 100 - 199 | - | S224687 | 100-199 ROMAIN ST | 100-199 ROMAIN ST | F | F | - | F | 11131000 | 11131000 | - | - | NORTH SIDE | - | - | - | - | GRAND VIEW AVE | GRAND VIEW AVE | 57447 | 57447 | 37.75632234 | -122.44056703 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM WED STCL | GRAND VIEW AVE to MARKET ST (100 - 199) | - | 5`EAST OF MARKET | - | - | - | - | - | 38228 | - | -122.44056703 | 37.75632234 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0086 | 18X18 | SUP2 | LIGHT POLE | IS | 1460375760000 | ROMAIN ST | 100 - 199 ROMAIN ST | 100 - 199 ROMAIN ST | 100 ROMAIN ST | - | MARKET ST | MARKET 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