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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 75376 | N/A | Point | 1 | 1 | 400 - 499 | - | S270144 | 400-499 12TH AVE | 400-499 12TH AVE | F | F | - | F | 523000 | 523000 | - | - | WEST SIDE | - | - | - | - | GEARY BLVD | GEARY BLVD | 94136 | 94136 | 37.77976199 | -122.47064218 | - | - | 1738783750000 | middleware_editor | 2 HR PRK 9AM-6PM MON-FRI EXC "N" PERMITS | GEARY BLVD to ANZA ST (400 - 499) | - | SPL 429 | - | - | - | - | - | 92494 | 1399852800000 | -122.47064218 | 37.77976199 | - | 1605744000000 | - | D1 | - | PARKING:RPP | REG | R32C(CA).0169 | 18X21 | SUP2 | 2IN IRON POST | IS | 1605608640000 | 12TH AVE | 400 - 499 12TH AVE | 400 - 499 12TH AVE | 400 12TH AVE | - | ANZA ST | ANZA ST |
| 75377 | N/A | Point | 1 | 1 | 1895 - 1899 | - | S283336 | 1895-1899 FUNSTON AVE | 1895-1899 FUNSTON AVE | F | F | - | F | 32876000 | 5974000 | - | - | WEST SIDE | - | - | - | - | AERIAL WAY | AERIAL WAY | 94241 | 94241 | 37.7527532076423 | -122.469943825947 | FUNSTON AVE \ AERIAL WAY | - | 1746719766000 | middleware_editor | AERIAL WAY | AERIAL WAY to AERIAL WAY (1895 - 1899) | - | NPL 1901 NEXT TO STAIRCASE ( END ) | - | - | - | - | - | 92495 | - | -122.46983798 | 37.75272573 | - | 1746642000000 | - | D7 | - | STREET NAME | GUIDE | D3-1.0063 | 36X08 | SUP2 | 3IN IRON POST | IS | 1654772880000 | FUNSTON AVE | - | 1895 - 1899 FUNSTON AVE | 1895 FUNSTON AVE | - | - | AERIAL WAY |
| 75378 | N/A | Point | 1 | 1 | 400 - 499 | - | S260094 | 400-499 KEARNY ST | 400-499 KEARNY ST | F | F | - | F | 7754000 | 7754000 | - | - | EAST SIDE | - | - | - | - | PINE ST | PINE ST | 94280 | 94280 | 37.79216462 | -122.40431913 | - | - | 1710539427000 | MTA | TANSAT | PINE ST to CALIFORNIA ST (400 - 499) | - | 5' N OF PINE | - | - | - | - | - | 92496 | - | -122.40431913 | 37.79216462 | - | - | - | D3 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1578313140000 | KEARNY ST | 400 - 499 KEARNY ST | 400 - 499 KEARNY ST | 400 KEARNY ST | - | CALIFORNIA ST | CALIFORNIA ST |
| 75379 | N/A | Point | - | - | - | - | S270287 | DIAMOND HEIGHTS BLVD: DUNCAN S | - | F | F | - | F | 22038000 | 22038000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | DUNCAN ST | DUNCAN ST | 94289 | 94289 | 37.745371333 | -122.440110178 | DIAMOND HEIGHTS BLVD \ DUNCAN ST | DIAMOND HEIGHTS BLVD \ DUNCAN ST | 1710539427000 | MTA | (45 RA-DN) | DUNCAN ST intersection | - | AT CROSSWALK ( END ) DUNCAN | - | - | - | - | - | 92497 | 1517961600000 | -122.44008805 | 37.74529604 | - | 1606867200000 | - | D8 | - | OTHER WARNING | WARNING | W16-7P.0006 | 24X12 | SUP2 | LIGHT POLE | IS | 1605863160000 | DIAMOND HEIGHTS BLVD | - | - | - | - | - | - |
| 75380 | N/A | Point | - | - | - | - | S270288 | DIAMOND HEIGHTS BLVD: DUNCAN S | - | F | F | - | F | 22038000 | 22038000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | DUNCAN ST | DUNCAN ST | 94290 | 94290 | 37.745373454 | -122.440084697 | DIAMOND HEIGHTS BLVD \ DUNCAN ST | DIAMOND HEIGHTS BLVD \ DUNCAN ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | DUNCAN ST intersection | - | AT CROSSWALK ( END ) DUNCAN | - | - | - | - | - | 92498 | 1022716800000 | -122.44008805 | 37.74529604 | - | 1606867200000 | 1704879000000 | D8 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | RETD | 1605863520000 | DIAMOND HEIGHTS BLVD | - | - | - | - | - | - |
| 75381 | N/A | Point | - | - | - | - | S270289 | DIAMOND HEIGHTS BLVD: DUNCAN S | - | F | F | - | F | 22038000 | 22038000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | DUNCAN ST | DUNCAN ST | 94291 | 94291 | 37.745376105 | -122.440061228 | DIAMOND HEIGHTS BLVD \ DUNCAN ST | DIAMOND HEIGHTS BLVD \ DUNCAN ST | 1710539427000 | MTA | (45 LA-DN) | DUNCAN ST intersection | - | AT CROSSWALK ( END ) DUNCAN | - | - | - | - | - | 92499 | 1022716800000 | -122.44008805 | 37.74529604 | - | 1606867200000 | - | D8 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | 2IN IRON POST | IS | 1605863640000 | DIAMOND HEIGHTS BLVD | - | - | - | - | - | - |
| 75382 | N/A | Point | - | - | - | - | S270290 | DIAMOND HEIGHTS BLVD: DUNCAN S | - | T | T | - | F | 4774101 | 22038000 | - | - | CENTER ISLAND, W LINE, WESTBOUND | - | - | - | - | CLIPPER ST | DUNCAN ST | 94292 | 94292 | 37.746580252 | -122.443236293 | - | DIAMOND HEIGHTS BLVD \ DUNCAN ST | 1711579236000 | middleware_editor | (LA) ONLY (LA) ONLY (RA) ONLY | DUNCAN ST intersection | - | CENTER ISLAND W LINE | - | - | - | - | - | 92500 | - | -122.44008805 | 37.74529604 | - | 1682294400000 | - | D8 | - | OTHER REGULATORY | REG | R61-13(CA).0001 | 48X30 | SUP2 | LIGHT POLE | IS | 1605864120000 | DIAMOND HEIGHTS BLVD | 5001 - 5049 DIAMOND HEIGHTS BLVD | - | - | - | DUNCAN ST | - |
| 75383 | N/A | Point | - | - | - | - | S281210 | 37TH AVE: SANTIAGO ST | - | F | F | - | F | 23408000 | 23408000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 37TH AVE | 37TH AVE | 94296 | 94296 | 37.74406827 | -122.49510921 | SANTIAGO ST \ 37TH AVE | SANTIAGO ST \ 37TH AVE | 1718138290000 | middleware_editor | SPEED HUMPS AHEAD | 37TH AVE intersection | - | - | - | - | - | - | - | 92501 | 1646956800000 | -122.49510921 | 37.74406827 | - | - | - | D4 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1646299860000 | SANTIAGO ST | - | - | - | - | - | - |
| 75384 | N/A | Point | - | - | - | - | S281211 | 37TH AVE: RIVERA ST | - | F | F | - | F | 23412000 | 23412000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RIVERA ST | 37TH AVE | 94297 | 94297 | 37.74592793 | -122.4952396 | 37TH AVE \ RIVERA ST | RIVERA ST \ 37TH AVE | 1715219131000 | middleware_editor | SPEED HUMPS AHEAD | 37TH AVE intersection | - | - | - | - | - | - | - | 92502 | 1646956800000 | -122.4952396 | 37.74592793 | - | - | - | D4 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1646300280000 | RIVERA ST | - | - | - | - | - | - |
| 75385 | N/A | Point | 1 | 1 | 2600 - 2699 | - | S281214 | 2600-2699 37TH AVE | 2600-2699 37TH AVE | F | F | - | F | 1840000 | 1840000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | VICENTE ST | VICENTE ST | 94298 | 94298 | 37.73753891 | -122.49465568 | - | - | 1716427832000 | middleware_editor | SPEED HUMPS | VICENTE ST to WAWONA ST (2600 - 2699) | - | 60 FT NORTH OF WAWONA OPP 2287 | - | - | - | - | - | 92503 | 1646870400000 | -122.49465568 | 37.73753891 | - | - | - | D4 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1646301120000 | 37TH AVE | 2600 - 2699 37TH AVE | 2600 - 2699 37TH AVE | 2600 37TH AVE | - | WAWONA ST | WAWONA ST |
| 75386 | N/A | Point | 1 | 1 | 900 - 999 | - | S269019 | 900-999 COLUMBUS AVE | 900-999 COLUMBUS AVE | F | F | - | F | 4301000 | 4301000 | - | - | WEST SIDE | - | - | - | - | LOMBARD ST | LOMBARD ST | 94312 | 94312 | 37.80314276 | -122.41429777 | - | - | 1710539427000 | MTA | BIKE RACK | LOMBARD ST to CHESTNUT ST \ TAYLOR ST (900 - 999) | 152297 | 32' S OF NPL 915/3' IN FROM CURB | - | - | - | - | - | 92504 | 1602572700000 | -122.41429777 | 37.80314276 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1602236700000 | COLUMBUS AVE | 900 - 999 COLUMBUS AVE | 900 - 999 COLUMBUS AVE | 900 COLUMBUS AVE | - | CHESTNUT ST \ TAYLOR ST | CHESTNUT ST \ TAYLOR ST |
| 75387 | N/A | Point | - | - | - | - | S266978 | SLOAT BLVD: 25TH AVE | - | F | F | - | F | 11953103 | 23215000 | - | - | SOUTH SIDE | - | - | - | - | 25TH AVE | 25TH AVE | 94320 | 94320 | 37.7342978602928 | -122.481617806724 | - | SLOAT BLVD \ 25TH AVE | 1738866578000 | middleware_editor | NPRK 8AM-10AM WED STCL | 25TH AVE intersection | - | EPL 945 | - | - | - | - | - | 92505 | -402793200000 | -122.48112987 | 37.73438842 | - | 1598832000000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP2 | 2IN IRON POST | IS | 1597052340000 | SLOAT BLVD | 901 - 999 SLOAT BLVD | - | - | - | 26TH AVE | - |
| 75388 | N/A | Point | - | - | - | - | S281348 | VAN NESS AVE: VALLEJO ST | - | F | F | - | F | 26552000 | 26552000 | - | - | CENTER ISLAND | - | - | - | - | VALLEJO ST | VALLEJO ST | 94371 | 94371 | 37.79669106 | -122.4236013 | VAN NESS AVE \ VALLEJO ST | VAN NESS AVE \ VALLEJO ST | 1710539427000 | MTA | TYPE Q DELINEATOR (IPR) | VALLEJO ST intersection | - | N LINE (WEST ISLAND) | - | - | - | - | - | 92506 | 1653350400000 | -122.4236013 | 37.79669106 | - | - | - | D2 | - | DELINEATOR 5 | WARNING | TYPE-Q(CA).0001 | 02X24 | SUP1 | STANDARD BASE | IS | 1646658180000 | VAN NESS AVE | - | - | - | - | - | - |
| 75389 | N/A | Point | - | - | - | - | S281323 | VAN NESS AVE: UNION ST | - | F | F | - | F | 26686000 | 26686000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | UNION ST | VAN NESS AVE | 94391 | 94391 | 37.79855245 | -122.42398215 | VAN NESS AVE \ UNION ST | UNION ST \ VAN NESS AVE | 1710539427000 | MTA | TRANSIT TURN SIGNAL | VAN NESS AVE intersection | - | BELOW TRANSIT SIGNAL | - | - | - | - | - | 92507 | 1648252800000 | -122.42398215 | 37.79855245 | - | - | - | D2 | - | OTHER REGULATORY | REG | R(SF).0462 | 24X18 | SUP1 | SIGNAL POLE | IS | 1646608920000 | UNION ST | - | - | - | - | - | - |
| 75390 | N/A | Point | 1 | 1 | 100 - 199 | - | S281368 | 100-199 GUTTENBERG ST | 100-199 GUTTENBERG ST | F | F | - | F | 6593000 | 6593000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | MORSE ST | MORSE ST | 94393 | 94393 | 37.71113614 | -122.44368329 | - | - | 1710539427000 | MTA | SPEED HUMP | MORSE ST to BRUNSWICK ST (100 - 199) | - | WPL 195 | - | - | - | - | - | 92508 | 1657065600000 | -122.44368329 | 37.71113614 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1646734680000 | GUTTENBERG ST | 100 - 199 GUTTENBERG ST | 100 - 199 GUTTENBERG ST | 100 GUTTENBERG ST | - | BRUNSWICK ST | BRUNSWICK ST |
| 75391 | N/A | Point | 1 | 1 | 100 - 199 | - | S281369 | 100-199 LOWELL ST | 100-199 LOWELL ST | F | F | - | F | 8504000 | 8504000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | MORSE ST | MORSE ST | 94394 | 94394 | 37.7104263 | -122.44583574 | - | - | 1710539427000 | MTA | SPEED HUMP | MORSE ST to BRUNSWICK ST (100 - 199) | - | WPL 187 ABOVE SIGN | - | - | - | - | - | 92509 | 1647216000000 | -122.44583574 | 37.7104263 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1646736120000 | LOWELL ST | 100 - 199 LOWELL ST | 100 - 199 LOWELL ST | 100 LOWELL ST | - | BRUNSWICK ST | BRUNSWICK ST |
| 75392 | N/A | Point | 1 | 1 | 100 - 199 | - | S281370 | 100-199 LOWELL ST | 100-199 LOWELL ST | F | F | - | F | 8504000 | 8504000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | MORSE ST | MORSE ST | 94395 | 94395 | 37.7104263 | -122.44583574 | - | - | 1710539427000 | MTA | SPEED HUMP | MORSE ST to BRUNSWICK ST (100 - 199) | - | 6 FT EAST OF MORSE | - | - | - | - | - | 92510 | 1647216000000 | -122.44583574 | 37.7104263 | - | 1678838400000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1646736360000 | LOWELL ST | 100 - 199 LOWELL ST | 100 - 199 LOWELL ST | 100 LOWELL ST | - | BRUNSWICK ST | BRUNSWICK ST |
| 75393 | N/A | Point | - | - | - | - | S281371 | JULES AVE: GRAFTON AVE | - | F | F | - | F | 22605000 | 22605000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | JULES AVE | GRAFTON AVE | 94396 | 94396 | 37.72001799 | -122.46123397 | GRAFTON AVE \ JULES AVE | JULES AVE \ GRAFTON AVE | 1720621518000 | middleware_editor | SPEED HUMP | GRAFTON AVE intersection | - | - | - | - | - | - | - | 92511 | 1647302400000 | -122.46123397 | 37.72001799 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1646737560000 | JULES AVE | - | - | - | - | - | - |
| 75394 | N/A | Point | - | - | - | - | S281373 | FARALLONES ST: CAPITOL AVE | - | F | F | - | F | 22473000 | 22473000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FARALLONES ST | CAPITOL AVE | 94398 | 94398 | 37.7140553 | -122.45903539 | CAPITOL AVE \ FARALLONES ST | FARALLONES ST \ CAPITOL AVE | 1720489136000 | middleware_editor | SPEED HUMPS AHEAD | CAPITOL AVE intersection | - | - | - | - | - | - | - | 92512 | 1657065600000 | -122.45903539 | 37.7140553 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1646739660000 | FARALLONES ST | - | - | - | - | - | - |
| 75395 | N/A | Point | - | - | - | - | S281384 | SANTA ROSA AVE: ALEMANY BLVD | - | F | F | - | F | 21772000 | 21772000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SANTA ROSA AVE | ALEMANY BLVD | 94402 | 94402 | 37.72671922 | -122.43599095 | ALEMANY BLVD \ SANTA ROSA AVE | SANTA ROSA AVE \ ALEMANY BLVD | 1718242294000 | middleware_editor | SPEED HUMP | ALEMANY BLVD intersection | - | - | - | - | - | - | - | 92513 | 1648166400000 | -122.43599095 | 37.72671922 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1646815560000 | SANTA ROSA AVE | - | - | - | - | - | - |
| 75396 | N/A | Point | 1 | 1 | 700 - 999 | - | S270926 | 700-999 ELLSWORTH ST | 700-999 ELLSWORTH ST | T | T | - | F | 5201000 | 5201000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CRESCENT AVE | CRESCENT AVE | 94408 | 94408 | 37.73322801 | -122.4166609 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | CRESCENT AVE to ALEMANY BLVD \ I-280 S OFF RAMP \ I-280 S ON RAMP (700 - 999) | - | 20 FT SOUTH OF SPL 755 | - | - | - | - | - | 92514 | 1179446400000 | -122.4166609 | 37.73322801 | - | 1616371200000 | - | D9 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | UTILITY POLE | IS | 1608538920000 | ELLSWORTH ST | 700 - 999 ELLSWORTH ST | 700 - 999 ELLSWORTH ST | 700 ELLSWORTH ST | - | ALEMANY BLVD \ I-280 S OFF RAMP \ I-280 S ON RAMP | ALEMANY BLVD \ I-280 S OFF RAMP \ I-280 S ON RAMP |
| 75397 | N/A | Point | - | - | - | - | S270928 | ELLSWORTH ST: CRESCENT AVE | - | F | F | - | F | 21180000 | 21180000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ELLSWORTH ST | CRESCENT AVE | 94409 | 94409 | 37.73479389 | -122.41493476 | CRESCENT AVE \ ELLSWORTH ST | ELLSWORTH ST \ CRESCENT AVE | 1723846111000 | middleware_editor | SPEED HUMPS AHEAD | CRESCENT AVE intersection | - | - | - | - | - | - | - | 92515 | 1348099200000 | -122.41493476 | 37.73479389 | - | 1723802400000 | - | D9 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1608539340000 | ELLSWORTH ST | - | - | - | - | - | - |
| 75398 | N/A | Point | - | - | - | - | S270931 | ELLSWORTH ST: TOMPKINS AVE | - | F | F | - | F | 21077000 | 21077000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | ELLSWORTH ST | 94410 | 94410 | 37.73714063 | -122.41472262 | ELLSWORTH ST \ TOMPKINS AVE | TOMPKINS AVE \ ELLSWORTH ST | 1753476914000 | middleware_editor | SPEED HUMPS AHEAD | ELLSWORTH ST intersection | - | - | - | - | - | - | - | 92516 | 1522652400000 | -122.41472262 | 37.73714063 | - | 1625814000000 | - | D9 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1608539940000 | TOMPKINS AVE | - | - | - | - | - | - |
| 75399 | N/A | Point | - | - | - | - | S270946 | MISSION ST: SAINT MARYS AVE | - | F | F | - | F | 21826000 | 21826000 | - | - | EAST SIDE | - | - | - | - | SAINT MARYS AVE | SAINT MARYS AVE | 94412 | 94412 | 37.73395448 | -122.42611454 | MISSION ST \ SAINT MARYS AVE | MISSION ST \ SAINT MARYS AVE | 1710539427000 | MTA | NPRK 5AM-7AM TUE THUR SUN STCL | SAINT MARYS AVE intersection | - | IFO 3975 | - | - | - | - | - | 92517 | 1568160000000 | -122.42611454 | 37.73395448 | - | 1609977600000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0166 | 18X18 | SUP2 | LIGHT POLE | IS | 1608557160000 | MISSION ST | - | - | - | - | - | - |
| 75400 | N/A | Point | 1 | 1 | 7300 - 7399 | LEFT ARROW | S270163 | 7300-7399 FULTON ST | 7300-7399 FULTON ST | F | F | - | F | 27978000 | 5956000 | - | - | SOUTH WEST CORNER | - | - | - | - | LA PLAYA | LA PLAYA | 94427 | 94427 | 37.7713176287875 | -122.50999040711 | FULTON ST \ LA PLAYA | - | 1747060957000 | middleware_editor | NPRK ANY TIME | LA PLAYA to GREAT HWY (7300 - 7399) | - | SWC | - | - | - | - | - | 92518 | 1080720000000 | -122.51047425 | 37.77136927 | - | 1605772800000 | - | D1 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0002 | 18X18 | SUP2 | MUNI POLE | IS | 1605616020000 | FULTON ST | - | 7300 - 7399 FULTON ST | 7300 FULTON ST | - | - | GREAT HWY |
| 75401 | N/A | Point | 1 | 1 | 200 - 299 | - | S270405 | 200-299 FOLSOM ST | 200-299 FOLSOM ST | F | F | - | F | 5652000 | 5652000 | - | - | SOUTH SIDE | - | - | - | - | MAIN ST | MAIN ST | 94432 | 94432 | 37.78902797 | -122.39229056 | - | - | 1738793950000 | middleware_editor | TA (SYM) PLO AT ALL TIMES (5 MIN) | MAIN ST to BEALE ST (200 - 299) | - | 48' EAST OF BEALE ST. | - | - | - | - | - | 92519 | 1608549960000 | -122.39229056 | 37.78902797 | - | - | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0001 | 14X21 | SUP1 | LIGHT POLE | IS | 1606216440000 | FOLSOM ST | 200 - 299 FOLSOM ST | 200 - 299 FOLSOM ST | 200 FOLSOM ST | - | BEALE ST | BEALE ST |
| 75402 | N/A | Point | - | - | - | - | S284030 | KANSAS ST: 17TH ST | - | F | F | - | F | 23774000 | 23774000 | - | - | SOUTH WEST CORNER | - | - | - | - | 17TH ST | 17TH ST | 94476 | 94476 | 37.764725388 | -122.403549494 | KANSAS ST \ 17TH ST | KANSAS ST \ 17TH ST | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "X" PERMITS | 17TH ST intersection | - | 10 'SOUTH OF 17TH ST. | - | - | - | - | - | 92520 | 1618790400000 | -122.40352703 | 37.76472287 | - | - | - | D10 | - | PARKING:RPP | REG | R32C(CA).0106 | 18X21 | SUP1 | MUNI POLE | IS | 1657877220000 | KANSAS ST | - | - | - | - | - | - |
| 75403 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S266348 | 1300-1399 FLORIDA ST | 1300-1399 FLORIDA ST | F | F | - | F | 5630000 | 5630000 | - | - | WEST SIDE | - | - | - | - | 25TH ST | 25TH ST | 94513 | 94513 | 37.750740215 | -122.409930616 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM THUR STCL | 25TH ST to 26TH ST (1300 - 1399) | - | NPL #1320 | - | - | - | - | - | 92521 | 1306800000000 | -122.40983808 | 37.75034469 | - | 1579651200000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0304 | 18X18 | SUP2 | 2IN IRON POST | IS | 1594977480000 | FLORIDA ST | 1300 - 1399 FLORIDA ST | 1300 - 1399 FLORIDA ST | 1300 FLORIDA ST | - | 26TH ST | 26TH ST |
| 75404 | N/A | Point | 1 | 1 | 1 - 99 | - | S253049 | 1-99 FARALLONES ST | 1-99 FARALLONES ST | F | F | - | F | 5406000 | 5406000 | - | - | NORTH SIDE | - | - | - | - | SAN JOSE AVE \ WHIPPLE AVE | SAN JOSE AVE \ WHIPPLE AVE | 94523 | 94523 | 37.71409026 | -122.45411776 | - | - | 1720489138000 | middleware_editor | NPRK 1PM-3PM 1ST & 3RD FRI OF MONTH STCL | SAN JOSE AVE \ WHIPPLE AVE to PLYMOUTH AVE (1 - 99) | - | EPL 48 | - | - | - | - | - | 92522 | 1223251200000 | -122.45411776 | 37.71409026 | - | 1590451200000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0093 | 18X18 | SUP2 | LIGHT POLE | IS | 1554207720000 | FARALLONES ST | 1 - 99 FARALLONES ST | 1 - 99 FARALLONES ST | 1 FARALLONES ST | - | PLYMOUTH AVE | PLYMOUTH AVE |
| 75405 | N/A | Point | - | - | - | - | S272529 | DAVIDSON AVE: 3RD ST | - | F | F | - | F | 20244000 | 20244000 | - | - | SOUTH EAST CORNER | - | - | - | - | 3RD ST | 03RD ST | 94841 | 94841 | 37.74352793 | -122.38762945 | DAVIDSON AVE \ 3RD ST | DAVIDSON AVE \ 03RD ST | 1729127789000 | middleware_editor | (LA) WHITE ON GREEN | 03RD ST intersection | 1090 | - | - | - | - | - | - | 92523 | 1613998020000 | -122.38762945 | 37.74352793 | - | - | - | D10 | - | OTHER GUIDE | GUIDE | M7-1.0002 | 12X09 | SUP1 | SIGNAL POLE | IS | 1613643540000 | DAVIDSON AVE | - | - | - | - | - | - |
| 75406 | N/A | Point | - | - | - | - | S281488 | OTTAWA AVE: ALEMANY BLVD | - | F | F | - | F | 21522000 | 21522000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | ALEMANY BLVD | 94851 | 94851 | 37.7152978 | -122.44583508 | OTTAWA AVE \ ALEMANY BLVD | OTTAWA AVE \ ALEMANY BLVD | 1727312958000 | middleware_editor | SPEED HUMPS AHEAD | ALEMANY BLVD intersection | - | ABOVE SIGN | - | - | - | - | - | 92524 | 1648598400000 | -122.44583508 | 37.7152978 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1647258600000 | OTTAWA AVE | - | - | - | - | - | - |
| 75407 | N/A | Point | - | - | - | - | S281876 | VAN NESS AVE: JACKSON ST | - | F | F | - | F | 26541000 | 26541000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 94862 | 94862 | 37.79393501 | -122.4230488 | JACKSON ST \ VAN NESS AVE | JACKSON ST \ VAN NESS AVE | 1710539427000 | MTA | MUNI SOLAR LANDOR SIGN | VAN NESS AVE intersection | 18099 | 7 FT NORTH OF JACKSON | - | - | - | - | - | 92525 | 1646265600000 | -122.4230488 | 37.79393501 | - | - | - | D2 | - | OTHER GUIDE | GUIDE | G-S(SF).0077 | 18X30 | SUP1 | UNISTRUT | IS | 1648295700000 | JACKSON ST | - | - | - | - | - | - |
| 75408 | N/A | Point | - | - | - | - | S259913 | VIA BUFANO: GREENWICH ST | - | F | F | - | F | 25452000 | 25452000 | - | - | NORTH EAST CORNER | - | - | - | - | VIA BUFANO | GREENWICH ST | 94882 | 94882 | 37.80205023 | -122.41160002 | GREENWICH ST \ VIA BUFANO | VIA BUFANO \ GREENWICH ST | 1710539427000 | MTA | VIA BUFANO | GREENWICH ST intersection | - | - | - | - | - | - | - | 92526 | 1578397860000 | -122.41160002 | 37.80205023 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-1.1992 | 36X08 | SUP1 | BUILDING | IS | 1576840260000 | VIA BUFANO | - | - | - | - | - | - |
| 75409 | N/A | Point | 1 | 1 | 1 - 15 | - | S272007 | 1-99 SOUTH PARK | 1-15 SOUTH PARK | F | F | - | F | 12008000 | 12008000 | - | - | NORTH SIDE | - | - | - | - | 2ND ST | 02ND ST | 94900 | 94900 | 37.78229709 | -122.3930437 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES | 02ND ST to SOUTH PARK (1 - 15) | - | 60' WEST OF 2ND ST | - | - | - | - | - | 92527 | 1614854280000 | -122.3930437 | 37.78229709 | - | - | - | D6 | - | PARKING:PARK AT 90 | REG | R(SF).0372 | 18X18 | SUP1 | 2IN IRON POST | IS | 1611917340000 | SOUTH PARK | 1 - 15 SOUTH PARK | 1 - 15 SOUTH PARK | 1 SOUTH PARK | - | SOUTH PARK | SOUTH PARK |
| 75410 | N/A | Point | 1 | 1 | 900 - 999 | - | S272383 | 900-1099 4TH ST | 900-999 04TH ST | F | F | - | F | 270002 | 270002 | - | - | EAST SIDE, EASTBOUND TRAFFIC | - | - | - | - | BERRY ST | BERRY ST | 94914 | 94914 | 37.77540709 | -122.39285066 | - | - | 1710539427000 | MTA | NO PED (SYM) | BERRY ST to MISSION CREEK (900 - 999) | - | 230' SOUTH OF BERRY ST. | - | - | - | - | - | 92528 | 1615208040000 | -122.39285066 | 37.77540709 | - | - | - | D6 | - | PEDESTRIAN | REG | R9-3.0004 | 24X24 | SUP1 | MUNI POLE | IS | 1613122980000 | 04TH ST | 900 - 999 4TH ST | 900 - 999 04TH ST | 900 4TH ST | - | MISSION CREEK | MISSION CREEK |
| 75411 | N/A | Point | 1 | 1 | 100 - 199 | - | S280936 | 100-199 DRUMM ST | 100-199 DRUMM ST | F | F | - | F | 4971000 | 4971000 | - | - | EAST SIDE | - | - | - | - | SACRAMENTO ST | SACRAMENTO ST | 94926 | 94926 | 37.79502717 | -122.39667874 | - | - | 1710539427000 | MTA | BIKE RACK | SACRAMENTO ST to CLAY ST (100 - 199) | 466392 | 117' N OF SACRAMENTO/3.5' IN FROM CURB | - | - | - | - | - | 92529 | 1654646400000 | -122.39667874 | 37.79502717 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1645004160000 | DRUMM ST | 100 - 199 DRUMM ST | 100 - 199 DRUMM ST | 100 DRUMM ST | - | CLAY ST | CLAY ST |
| 75412 | N/A | Point | 1 | 1 | 800 - 899 | LEFT ARROW | S282649 | 800-899 FRONT ST | 800-899 FRONT ST | F | F | - | F | 5874000 | 5874000 | - | - | EAST SIDE | - | - | - | - | BROADWAY | BROADWAY | 94964 | 94964 | 37.79920521 | -122.39996977 | - | - | 1710539427000 | MTA | TA (SYM) PLO AT ALL TIMES (5 MIN) H/C (SYM) | BROADWAY to VALLEJO ST (800 - 899) | - | 77' NORTH OF BROADWAY | - | - | - | - | - | 92530 | 1653264000000 | -122.39996977 | 37.79920521 | - | - | - | D3 | - | OTHER REGULATORY | REG | R38(SF)1.0152 | 14X21 | SUP1 | 2IN IRON POST | IS | 1651747560000 | FRONT ST | 800 - 899 FRONT ST | 800 - 899 FRONT ST | 800 FRONT ST | - | VALLEJO ST | VALLEJO ST |
| 75413 | N/A | Point | 1 | 1 | 200 - 299 | - | S272419 | 200-299 CHURCH ST | 200-299 CHURCH ST | F | F | - | F | 4010000 | 4010000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | MARKET ST | MARKET ST | 94980 | 94980 | 37.76681724 | -122.42888386 | - | - | 1721058002000 | middleware_editor | BIKE (SYM) PED (SYM) DETOUR (RA) WALK BICYCLES | MARKET ST to 15TH ST (200 - 299) | - | 140' S OF MARKET | - | - | - | - | - | 92531 | 1613470800000 | -122.42888386 | 37.76681724 | - | - | - | D8 | - | PEDESTRIAN | REG | R(SF).0441 | 30X42 | SUP2 | A FRAME BARRICADE | IS | 1613472600000 | CHURCH ST | 200 - 299 CHURCH ST | 200 - 299 CHURCH ST | 200 CHURCH ST | - | 15TH ST | 15TH ST |
| 75414 | N/A | Point | 1 | 1 | 500 - 599 | LEFT ARROW | S282260 | 500-699 BERRY ST | 500-599 BERRY ST | F | T | - | F | 2957000 | 2957000 | - | - | NORTH SIDE | - | - | - | - | 7TH ST | 07TH ST | 95013 | 95013 | 37.76975226 | -122.40099196 | - | - | 1755016629000 | middleware_editor | PARK PARALLEL | 07TH ST to DE HARO ST (500 - 599) | - | 193' E OF DE HARO | - | - | - | - | - | 92532 | 1650956400000 | -122.40099196 | 37.76975226 | - | - | - | D10 | - | PARKING:PARALLEL | REG | R24(CA).0001 | 18X18 | SUP1 | LIGHT POLE | IS | 1649944740000 | BERRY ST | 500 - 599 BERRY ST | 500 - 599 BERRY ST | 500 BERRY ST | - | DE HARO ST | DE HARO ST |
| 75415 | N/A | Point | 1 | 1 | 800 - 899 | - | S280894 | 800-899 42ND AVE | 800-899 42ND AVE | F | F | - | F | 1931000 | 1931000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CABRILLO ST | CABRILLO ST | 95024 | 95024 | 37.77267098 | -122.50246742 | - | - | 1710539427000 | MTA | SPEED HUMPS | CABRILLO ST to FULTON ST (800 - 899) | 122008875 | 30'NORTH OF FULTON | - | - | - | - | - | 92533 | 1429228800000 | -122.50246742 | 37.77267098 | - | 1429228800000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1644847020000 | 42ND AVE | 800 - 899 42ND AVE | 800 - 899 42ND AVE | 800 42ND AVE | - | FULTON ST | FULTON ST |
| 75416 | N/A | Point | 1 | 1 | 400 - 499 | - | S260250 | 400-499 BENTON AVE | 400-499 BENTON AVE | F | F | - | F | 2931000 | 2931000 | - | - | NORTH SIDE | - | - | - | - | ROSCOE ST | ROSCOE ST | 95044 | 95044 | 37.73400051 | -122.41850355 | - | - | 1710539427000 | MTA | BIKE RACK | ROSCOE ST to PORTER ST (400 - 499) | 97753 | 33' W OF EPL# 495/3' IN FROM CURB | - | - | - | - | - | 92534 | 1579013400000 | -122.41850355 | 37.73400051 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1578903960000 | BENTON AVE | 400 - 499 BENTON AVE | 400 - 499 BENTON AVE | 400 BENTON AVE | - | PORTER ST | PORTER ST |
| 75417 | N/A | Point | - | - | - | - | S270752 | GREAT HWY: SANTIAGO ST | - | F | F | - | F | 23513000 | 23513000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | SANTIAGO ST | GREAT HWY | 95046 | 95046 | 37.74353516 | -122.50719325 | GREAT HWY \ SANTIAGO ST | SANTIAGO ST \ GREAT HWY | 1730244374000 | middleware_editor | SPEED HUMP | GREAT HWY intersection | - | NEXT TO SPEED HUMP | - | - | - | - | - | 92535 | 1608647280000 | -122.50719325 | 37.74353516 | - | 1672963200000 | - | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1607677500000 | SANTIAGO ST | - | - | - | - | - | - |
| 75418 | N/A | Point | - | - | - | - | S270755 | IRVING ST: LA PLAYA | - | F | F | - | F | 27962000 | 27961000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | IRVING ST | IRVING ST | 95048 | 95048 | 37.7620396928249 | -122.509546726937 | GREAT HWY \ IRVING ST | LA PLAYA \ IRVING ST | 1742512527000 | middleware_editor | SPEED HUMP | IRVING ST intersection | - | - | - | - | - | - | - | 92536 | 1588921200000 | -122.50926908 | 37.76214292 | - | 1608537600000 | 1742501400000 | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | RETD | 1607678220000 | LA PLAYA | - | - | - | - | - | - |
| 75419 | N/A | Point | - | - | - | - | S270758 | IRVING ST: LA PLAYA | - | F | F | - | F | - | 27961000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | - | IRVING ST | 95051 | 95051 | 37.761725417 | -122.509316367 | - | LA PLAYA \ IRVING ST | 1741633888000 | middleware_editor | SPEED HUMP | IRVING ST intersection | - | S-LINE / SWC | - | - | - | - | - | 92537 | 1588921200000 | -122.50926908 | 37.76214292 | - | 1608537600000 | - | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1607678340000 | LA PLAYA | - | - | - | - | - | - |
| 75420 | N/A | Point | - | - | - | - | S270760 | IRVING ST: LA PLAYA | - | F | F | - | F | 27961000 | 27961000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LA PLAYA | IRVING ST | 95052 | 95052 | 37.76214292 | -122.50926908 | IRVING ST \ LA PLAYA | LA PLAYA \ IRVING ST | 1716419265000 | middleware_editor | SPEED HUMP | IRVING ST intersection | - | SWC | - | - | - | - | - | 92538 | 1588896000000 | -122.50926908 | 37.76214292 | - | 1608508800000 | - | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1607678880000 | LA PLAYA | - | - | - | - | - | - |
| 75421 | N/A | Point | - | - | - | - | S270763 | IRVING ST: LA PLAYA | - | F | F | - | F | 7923000 | 27961000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | IRVING ST | IRVING ST | 95055 | 95055 | 37.76214292 | -122.50926908 | - | LA PLAYA \ IRVING ST | 1715390633000 | middleware_editor | SPEED HUMP | IRVING ST intersection | - | AT SPEED HUMP | - | - | - | - | - | 92539 | 1588896000000 | -122.50926908 | 37.76214292 | - | 1608595200000 | - | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1607679000000 | LA PLAYA | 1300 - 1399 LA PLAYA | - | - | - | JUDAH ST | - |
| 75422 | N/A | Point | - | - | - | - | S271799 | BRAZIL AVE: EDINBURGH ST | - | F | F | - | F | 21648000 | 21648000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | EDINBURGH ST | 95089 | 95089 | 37.722796949 | -122.430702576 | EDINBURGH ST \ BRAZIL AVE | BRAZIL AVE \ EDINBURGH ST | 1710539427000 | MTA | STOP | EDINBURGH ST intersection | - | - | - | - | - | - | - | 92540 | 1393459200000 | -122.43083311 | 37.72278422 | - | 1612483200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1611562800000 | BRAZIL AVE | - | - | - | - | - | - |
| 75423 | N/A | Point | 1 | 1 | 1 - 99 | - | S260232 | 1-99 FELL ST | 1-99 FELL ST | F | F | - | F | 5439000 | 5439000 | - | - | SOUTH SIDE | - | - | - | - | 10TH ST \ MARKET ST \ POLK ST | 10TH ST \ MARKET ST \ POLK ST | 95953 | 95953 | 37.77647877 | -122.4184951 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | 10TH ST \ MARKET ST \ POLK ST to VAN NESS AVE (1 - 99) | - | START N-LINE X-WALK GOING WEST @ MARKET | - | - | - | - | - | 92541 | 1398902400000 | -122.4184951 | 37.77647877 | - | 1579824000000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1578663600000 | FELL ST | 1 - 99 FELL ST | 1 - 99 FELL ST | 1 FELL ST | - | VAN NESS AVE | VAN NESS AVE |
| 75424 | N/A | Point | - | - | - | - | S263188 | SACRAMENTO ST: CHERRY ST | - | T | T | - | F | 27567000 | 27567000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CHERRY ST | CHERRY ST | 95972 | 95972 | 37.78692822 | -122.45687452 | SACRAMENTO ST \ CHERRY ST | SACRAMENTO ST \ CHERRY ST | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | CHERRY ST intersection | 175938 | BELOW ST.NAME SIGNS | - | - | - | - | - | 92542 | 1080604800000 | -122.45687452 | 37.78692822 | - | 1635379200000 | - | D2 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | LIGHT POLE | IS | 1586259240000 | SACRAMENTO ST | - | - | - | - | - | - |
| 75425 | N/A | Point | 1 | 1 | 3000 - 3099 | - | S269654 | 3000-3099 STEINER ST | 3000-3099 STEINER ST | F | F | - | F | 12150000 | 12150000 | - | - | EAST SIDE | - | - | - | - | UNION ST | UNION ST | 96004 | 96004 | 37.7973454 | -122.43723194 | - | - | 1730128890000 | middleware_editor | BIKE RACK | UNION ST to FILBERT ST (3000 - 3099) | 238553 | 60' N OF NPL 3034/3' IN FROM CURB | - | - | - | - | - | 92543 | 1604499720000 | -122.43723194 | 37.7973454 | - | - | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1603973760000 | STEINER ST | 3000 - 3099 STEINER ST | 3000 - 3099 STEINER ST | 3000 STEINER ST | - | FILBERT ST | FILBERT ST |
| 75426 | N/A | Point | 1 | 1 | 4750 - 4799 | - | S283174 | 4750-4799 19TH ST | 4750-4799 19TH ST | F | F | - | F | 994000 | 994000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | DANVERS ST | DANVERS ST | 96018 | 96018 | 37.7589553 | -122.44341886 | - | - | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | DANVERS ST to CASELLI AVE \ MONO ST (4750 - 4799) | - | INFO #4474 | - | - | - | - | - | 92544 | 285465600000 | -122.44341886 | 37.7589553 | - | - | 1670284800000 | D8 | - | OTHER WARNING | WARNING | SW(SF).0003 | 24X18 | SUP2 | 2IN IRON POST | RETD | 1654181580000 | 19TH ST | 4750 - 4799 19TH ST | 4750 - 4799 19TH ST | 4750 19TH ST | - | CASELLI AVE \ MONO ST | CASELLI AVE \ MONO ST |
| 75427 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S265033 | 1700-1799 4TH ST | 1700-1799 04TH ST | F | F | - | F | 19989000 | 19989000 | - | - | EAST SIDE | - | - | - | - | CAMPUS WAY | CAMPUS WAY | 96035 | 96035 | 37.76729013 | -122.39084379 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | CAMPUS WAY to 16TH ST (1700 - 1799) | - | S LINE OF CORRAL/5' FROM CURB | - | - | - | - | - | 92545 | 1594997460000 | -122.39084379 | 37.76729013 | - | 1628467200000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1591782720000 | 04TH ST | 1700 - 1799 4TH ST | 1700 - 1799 04TH ST | 1700 4TH ST | - | 16TH ST | 16TH ST |
| 75428 | N/A | Point | 1 | 1 | 4334 - 4363 | - | S266837 | 4334-4363 MISSION ST | 4334-4363 MISSION ST | F | F | - | F | 9156000 | 9156000 | - | - | EAST SIDE | - | - | - | - | TINGLEY ST | TINGLEY ST | 97077 | 97077 | 37.72798314 | -122.43208203 | - | - | 1710539427000 | MTA | (H/C SYM) PARK ONLY/MIN FINE $250 | TINGLEY ST to THERESA ST (4334 - 4363) | - | 62 FT NORTH OF AVALON | - | - | - | - | - | 92546 | 1596710520000 | -122.43208203 | 37.72798314 | - | - | - | D11 | - | OTHER REGULATORY | REG | R99C(CA).0001 | 12X24 | SUP2 | 2IN IRON POST | IS | 1596536460000 | MISSION ST | 4334 - 4363 MISSION ST | 4334 - 4363 MISSION ST | 4334 MISSION ST | - | THERESA ST | THERESA ST |
| 75429 | N/A | Point | 1 | 1 | 1 - 99 | - | S281440 | 1-99 REGENT ST | 1-99 REGENT ST | F | F | - | F | 10960000 | 10960000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | CAYUGA AVE | CAYUGA AVE | 97569 | 97569 | 37.70965284 | -122.4564492 | - | - | 1756138126000 | middleware_editor | SPEED HUMP | CAYUGA AVE to ALEMANY BLVD \ I-280 N ON RAMP \ SAN JOSE AVE (1 - 99) | - | EPL 79 ABOVE STREET CLEANING | - | - | - | - | - | 92547 | 1648105200000 | -122.4564492 | 37.70965284 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1646912700000 | REGENT ST | 1 - 99 REGENT ST | 1 - 99 REGENT ST | 1 REGENT ST | - | ALEMANY BLVD \ I-280 N ON RAMP \ SAN JOSE AVE | ALEMANY BLVD \ I-280 N ON RAMP \ SAN JOSE AVE |
| 75430 | N/A | Point | - | - | - | - | S271694 | BURROWS ST: GIRARD ST | - | F | F | - | F | 20652000 | 20652000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GIRARD ST | BURROWS ST | 97601 | 97601 | 37.72857432 | -122.40509102 | BURROWS ST \ GIRARD ST | GIRARD ST \ BURROWS ST | 1726154165000 | middleware_editor | SPEED HUMP | BURROWS ST intersection | - | - | - | - | - | - | - | 92548 | 137289600000 | -122.40509102 | 37.72857432 | - | 1615161600000 | - | D9 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1611218280000 | GIRARD ST | - | - | - | - | - | - |
| 75431 | N/A | Point | - | - | - | - | S271695 | BURROWS ST: GIRARD ST | - | F | F | - | F | 20652000 | 20652000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GIRARD ST | BURROWS ST | 97602 | 97602 | 37.72857432 | -122.40509102 | BURROWS ST \ GIRARD ST | GIRARD ST \ BURROWS ST | 1726154103000 | middleware_editor | SPEED HUMP | BURROWS ST intersection | - | - | - | - | - | - | - | 92549 | 137289600000 | -122.40509102 | 37.72857432 | - | 1615161600000 | - | D9 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1611218700000 | GIRARD ST | - | - | - | - | - | - |
| 75432 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S289325 | 1100-1199 VALENCIA ST | 1100-1199 VALENCIA ST | F | F | - | F | 13071000 | 13071000 | - | SHOULD BE RETIRED | EAST SIDE | - | - | - | - | 22ND ST | 22ND ST | 97689 | 97689 | 37.75443479 | -122.420892143 | - | - | 1743702083000 | middleware_editor | BUS LANE CURB | 22ND ST to 23RD ST (1100 - 1199) | - | SECTION 3 ( 205--295 FT ) FROM 22ND ST | - | - | - | - | - | 92550 | 1686207600000 | -122.42088812 | 37.75449894 | - | - | 1743702000000 | D8 | - | OTHER WARNING | WARNING | W(SF).0118 | 72X18 | SUP2 | ANCHORS | RETD | 1683707460000 | VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 VALENCIA ST | - | 23RD ST | 23RD ST |
| 75433 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S289327 | 1100-1199 VALENCIA ST | 1100-1199 VALENCIA ST | F | F | - | F | 13071000 | 13071000 | - | SHOULD BE RETIRED | EAST SIDE | - | - | - | - | 22ND ST | 22ND ST | 97690 | 97690 | 37.7542768 | -122.420881414 | - | - | 1743701994000 | middleware_editor | BUS LANE CURB | 22ND ST to 23RD ST (1100 - 1199) | - | SECTION 4 ( 305--395 FT ) FROM 22ND ST | - | - | - | - | - | 92551 | 1686207600000 | -122.42088812 | 37.75449894 | - | - | 1743701940000 | D8 | - | OTHER WARNING | WARNING | W(SF).0118 | 72X18 | SUP2 | ANCHORS | RETD | 1683707580000 | VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 VALENCIA ST | - | 23RD ST | 23RD ST |
| 75434 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S289329 | 1100-1199 VALENCIA ST | 1100-1199 VALENCIA ST | F | F | - | F | 13071000 | 13071000 | - | SHOULD BE RETIRED | WEST SIDE | - | - | - | - | 22ND ST | 22ND ST | 97691 | 97691 | 37.755218902 | -122.420951823 | - | - | 1743702324000 | middleware_editor | BUS LANE CURB | 22ND ST to 23RD ST (1100 - 1199) | - | SECTION 1 ( 5--95 FT ) FROM 22ND ST | - | - | - | - | - | 92552 | 1686207600000 | -122.42088812 | 37.75449894 | - | - | 1743702300000 | D8 | - | OTHER WARNING | WARNING | W(SF).0118 | 72X18 | SUP2 | ANCHORS | RETD | 1683708060000 | VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 VALENCIA ST | - | 23RD ST | 23RD ST |
| 75435 | N/A | Point | - | - | - | - | S265128 | CALIFORNIA ST: ARGUELLO BLVD | - | T | T | - | F | 27566000 | 27566000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | ARGUELLO BLVD | 97827 | 97827 | 37.785744753 | -122.459347078 | ARGUELLO BLVD \ CALIFORNIA ST | CALIFORNIA ST \ ARGUELLO BLVD | 1710539427000 | MTA | LANE REDUCTION (SYM) LEFT | ARGUELLO BLVD intersection | - | ABOVE SIGNAL | - | - | - | - | - | 92553 | 1593511020000 | -122.45917877 | 37.78568169 | - | - | - | D1 | - | OTHER WARNING | WARNING | W4-2.0001 | 30X30 | SUP2 | SIGNAL POLE | IS | 1592217720000 | CALIFORNIA ST | - | - | - | - | - | - |
| 75436 | N/A | Point | 1 | 1 | 2700 - 2799 | - | S264260 | 2700-2799 CLAY ST | 2700-2799 CLAY ST | F | F | - | F | 4114000 | 4114000 | - | - | NORTH SIDE | - | - | - | - | PIERCE ST | PIERCE ST | 101349 | 101349 | 37.7901869 | -122.43831557 | - | - | 1733949842000 | middleware_editor | BIKE RACK | PIERCE ST to SCOTT ST (2700 - 2799) | 116821 | 20' W OF PIERCE IFO STAIRS/3.5' FRM CRB | - | - | - | - | - | 92554 | 1590139980000 | -122.43831557 | 37.7901869 | - | - | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1589539260000 | CLAY ST | 2700 - 2799 CLAY ST | 2700 - 2799 CLAY ST | 2700 CLAY ST | - | SCOTT ST | SCOTT ST |
| 75437 | N/A | Point | 1 | 1 | 3300 - 3314 | - | S264280 | 3300-3314 22ND ST | 3300-3314 22ND ST | F | F | - | F | 1193000 | 1193000 | - | - | NORTH SIDE | - | - | - | - | VALENCIA ST | VALENCIA ST | 101354 | 101354 | 37.755329214 | -122.421559086 | - | - | 1710539427000 | MTA | 1 HR PRK 9AM-8PM MON-SAT EXC "I" PERMITS | VALENCIA ST to SAN JOSE AVE (3300 - 3314) | 337683 | WPL #3320 | - | - | - | - | - | 92555 | 1361232000000 | -122.42119967 | 37.7552815 | - | - | - | D8 | - | PARKING:RPP | REG | R32C(CA).0020 | 18X21 | SUP2 | 2IN IRON POST | IS | 1589812500000 | 22ND ST | 3300 - 3314 22ND ST | 3300 - 3314 22ND ST | 3300 22ND ST | - | SAN JOSE AVE | SAN JOSE AVE |
| 75438 | N/A | Point | - | 1 | 529 - 599 | - | S267396 | 529-599 FOLSOM ST | 529-599 FOLSOM ST | F | F | - | F | 5659000 | 5659000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | ESSEX ST | ESSEX ST | 101370 | 101370 | 37.78596054 | -122.39617532 | - | - | 1710539427000 | MTA | EXCEPT BIKE (SYM) | ESSEX ST to 02ND ST (529 - 599) | - | 30' EAST OF 2ND ST. | - | - | - | - | - | 92556 | 1607608980000 | -122.39617532 | 37.78596054 | - | - | - | D6 | - | OTHER REGULATORY | REG | R(SF).0362 | 24X18 | SUP1 | LIGHT POLE | IS | 1598276460000 | FOLSOM ST | 529 - 599 FOLSOM ST | 529 - 599 FOLSOM ST | 529 FOLSOM ST | - | 02ND ST | 02ND ST |
| 75439 | N/A | Point | - | - | - | - | S285430 | ATHENS ST: GENEVA AVE | - | F | F | - | F | 21405000 | 21405000 | - | - | NORTH WEST CORNER | - | - | - | - | GENEVA AVE | GENEVA AVE | 101389 | 101389 | 37.71347595 | -122.43454113 | ATHENS ST \ GENEVA AVE | ATHENS ST \ GENEVA AVE | 1710539427000 | MTA | ATHENS ST | GENEVA AVE intersection | - | 1000 | - | - | - | - | - | 92557 | - | -122.43454113 | 37.71347595 | - | 1671667200000 | - | D11 | - | STREET NAME | GUIDE | D3-1.0142 | 36X08 | SUP2 | SIGNAL POLE | IS | 1665139980000 | ATHENS ST | - | - | - | - | - | - |
| 75440 | N/A | Point | - | - | - | - | S288841 | GUERRERO ST: 16TH ST | - | F | F | - | F | 25698000 | 25698000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | GUERRERO ST | 16TH ST | 101411 | 101411 | 37.764913853 | -122.424124808 | 16TH ST \ GUERRERO ST | GUERRERO ST \ 16TH ST | 1710539427000 | MTA | EXCEPT MUNI | 16TH ST intersection | - | UNDER SIGN | - | - | - | - | - | 92558 | 1682467200000 | -122.42410268 | 37.76478345 | - | - | - | D8 | - | OTHER REGULATORY | REG | R(SF).0357 | 30X08 | SUP2 | LIGHT POLE | IS | 1682419560000 | GUERRERO ST | - | - | - | - | - | - |
| 75441 | N/A | Point | - | - | - | - | S288842 | GUERRERO ST: 16TH ST | - | F | F | - | F | 25698000 | 25698000 | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | - | - | - | - | GUERRERO ST | 16TH ST | 101412 | 101412 | 37.764674251 | -122.42411475 | 16TH ST \ GUERRERO ST | GUERRERO ST \ 16TH ST | 1710539427000 | MTA | EXCEPT MUNI | 16TH ST intersection | - | UNDER SIGN | - | - | - | - | - | 92559 | 1682467200000 | -122.42410268 | 37.76478345 | - | - | - | D8 | - | OTHER REGULATORY | REG | R(SF).0357 | 30X08 | SUP2 | LIGHT POLE | IS | 1682419680000 | GUERRERO ST | - | - | - | - | - | - |
| 75442 | N/A | Point | - | - | - | - | S288943 | VALENCIA ST: 22ND ST | - | T | T | - | F | 24115000 | 24115000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | 22ND ST | 101414 | 101414 | 37.755400812 | -122.420877365 | 22ND ST \ VALENCIA ST | VALENCIA ST \ 22ND ST | 1753118789000 | middleware_editor | NO LEFT TURN (SYM)/NO U TURN (SYM) | 22ND ST intersection | - | NEXT TO SIGNAL LIGHT | - | - | - | - | - | 92560 | 1682578800000 | -122.42096409 | 37.75529478 | - | - | - | D8 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | OVERHEAD MAST ARM | IS | 1682515800000 | VALENCIA ST | - | - | - | - | - | - |
| 75443 | N/A | Point | - | - | - | - | S288945 | VALENCIA ST: 22ND ST | - | T | T | - | F | 24115000 | 24115000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | 22ND ST | 101415 | 101415 | 37.75540576 | -122.420876471 | 22ND ST \ VALENCIA ST | VALENCIA ST \ 22ND ST | 1710539427000 | MTA | NEW | 22ND ST intersection | - | - | - | - | - | - | - | 92561 | - | -122.42096409 | 37.75529478 | - | - | 1709719200000 | D8 | - | OTHER WARNING | WARNING | W(SF).0079 | 30X12 | SUP2 | OVERHEAD MAST ARM | RETD | 1682515920000 | VALENCIA ST | - | - | - | - | - | - |
| 75444 | N/A | Point | - | - | - | - | S288947 | VALENCIA ST: 22ND ST | - | F | F | - | F | 24115000 | 24115000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | 22ND ST | 101417 | 101417 | 37.755410708 | -122.42108926 | 22ND ST \ VALENCIA ST | VALENCIA ST \ 22ND ST | 1753398668000 | middleware_editor | NO LEFT TURN (SYM)/NO U TURN (SYM) | 22ND ST intersection | - | - | - | - | - | - | - | 92562 | 1682665200000 | -122.42096409 | 37.75529478 | - | - | 1753394460000 | D8 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | SIGNAL POLE | RETD | 1682516400000 | VALENCIA ST | - | - | - | - | - | - |
| 75445 | N/A | Point | - | - | - | - | S288948 | VALENCIA ST: 22ND ST | - | T | T | - | F | 24115000 | 24115000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | 22ND ST | 101418 | 101418 | 37.755212075 | -122.421073167 | 22ND ST \ VALENCIA ST | VALENCIA ST \ 22ND ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | 22ND ST intersection | - | NEXT TO SIGNAL LIGHT | - | - | - | - | - | 92563 | 1682640000000 | -122.42096409 | 37.75529478 | - | - | - | D8 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | OVERHEAD MAST ARM | IS | 1682516460000 | VALENCIA ST | - | - | - | - | - | - |
| 75446 | N/A | Point | - | - | - | - | S288949 | VALENCIA ST: 22ND ST | - | T | T | - | F | 24115000 | 24115000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VALENCIA ST | 22ND ST | 101419 | 101419 | 37.755209247 | -122.421066014 | 22ND ST \ VALENCIA ST | VALENCIA ST \ 22ND ST | 1710539427000 | MTA | NEW | 22ND ST intersection | - | NEXT TO SIGNAL LIGHT | - | - | - | - | - | 92564 | - | -122.42096409 | 37.75529478 | - | - | 1709737440000 | D8 | - | OTHER WARNING | WARNING | W(SF).0079 | 30X12 | SUP2 | OVERHEAD MAST ARM | RETD | 1682516580000 | VALENCIA ST | - | - | - | - | - | - |
| 75447 | N/A | Point | 1 | 1 | 1050 - 1099 | - | S287858 | 1050-1099 VALENCIA ST | 1050-1099 VALENCIA ST | F | F | - | F | 13070000 | 13070000 | - | - | EAST SIDE | - | - | - | - | HILL ST | HILL ST | 101423 | 101423 | 37.755714323 | -122.420908445 | - | - | 1710539427000 | MTA | BIKE RACK | HILL ST to 22ND ST (1050 - 1099) | - | 9' S OF NPL 1075/3' IN FROM CURB | - | - | - | - | - | 92565 | 1678147200000 | -122.42100262 | 37.7556983 | - | - | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1678163220000 | VALENCIA ST | 1050 - 1099 VALENCIA ST | 1050 - 1099 VALENCIA ST | 1050 VALENCIA ST | - | 22ND ST | 22ND ST |
| 75448 | N/A | Point | 1 | 1 | 1000 - 1049 | - | S287859 | 1000-1049 VALENCIA ST | 1000-1049 VALENCIA ST | F | F | - | F | 13069000 | 13069000 | - | - | EAST SIDE | - | - | - | - | 21ST ST | 21ST ST | 101424 | 101424 | 37.756760153 | -122.421010199 | - | - | 1744387215000 | middleware_editor | BIKE RACK | 21ST ST to HILL ST (1000 - 1049) | - | 27' S OF NPL 1007/ 3' IN FROM CURB | - | - | - | - | - | 92566 | 1678176000000 | -122.42107934 | 37.75650191 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1678163400000 | VALENCIA ST | 1000 - 1049 VALENCIA ST | 1000 - 1049 VALENCIA ST | 1000 VALENCIA ST | - | HILL ST | HILL ST |
| 75449 | N/A | Point | 1 | 1 | 1000 - 1049 | - | S287860 | 1000-1049 VALENCIA ST | 1000-1049 VALENCIA ST | F | F | - | F | 13069000 | 13069000 | - | - | WEST SIDE | - | - | - | - | 21ST ST | 21ST ST | 101425 | 101425 | 37.756801622 | -122.421227159 | - | - | 1710539427000 | MTA | BIKE RACK | 21ST ST to HILL ST (1000 - 1049) | - | 2' S OF NPL 1000/2' IN FROM CURB | - | - | - | - | - | 92567 | 1678147200000 | -122.42107934 | 37.75650191 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1678163520000 | VALENCIA ST | 1000 - 1049 VALENCIA ST | 1000 - 1049 VALENCIA ST | 1000 VALENCIA ST | - | HILL ST | HILL ST |
| 75450 | N/A | Point | 1 | 1 | 950 - 999 | - | S287861 | 950-999 VALENCIA ST | 950-999 VALENCIA ST | F | F | - | F | 13068000 | 13068000 | - | - | EAST SIDE | - | - | - | - | LIBERTY ST | LIBERTY ST | 101426 | 101426 | 37.758208255 | -122.42115123 | - | - | 1710539427000 | MTA | BIKE RACK | LIBERTY ST to 21ST ST (950 - 999) | - | 14' N OF SPL 911/ 3' IN FROM CURB | - | - | - | - | - | 92568 | 1678147200000 | -122.4211557 | 37.75730171 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1678163640000 | VALENCIA ST | 950 - 999 VALENCIA ST | 950 - 999 VALENCIA ST | 950 VALENCIA ST | - | 21ST ST | 21ST 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