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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23626 | N/A | Point | 1 | 1 | 1 - 39 | - | S247165 | 1-39 GILROY ST | 1-39 GILROY ST | F | F | - | F | 6192000 | 6192000 | - | - | WEST SIDE | - | - | - | - | INGERSON AVE | INGERSON AVE | 76329 | 76329 | 37.71648526 | -122.38894621 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM WED STCL | INGERSON AVE to IGNACIO AVE (1 - 39) | - | SPL#795 | - | - | - | - | - | 40704 | - | -122.38894621 | 37.71648526 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP1 | 2IN IRON POST | IS | 1532333700000 | GILROY ST | 1 - 39 GILROY ST | 1 - 39 GILROY ST | 1 GILROY ST | - | IGNACIO AVE | IGNACIO AVE |
| 23627 | N/A | Point | - | - | - | - | S247167 | IRVING ST: 5TH AVE | - | F | F | - | F | 27083000 | 27083000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | IRVING ST | 05TH AVE | 76330 | 76330 | 37.76422484 | -122.46203054 | 5TH AVE \ IRVING ST | IRVING ST \ 05TH AVE | 1710539427000 | MTA | (45 LA-DN) | 05TH AVE intersection | - | - | - | - | - | - | - | 40705 | 1283212800000 | -122.46203054 | 37.76422484 | - | 1532304000000 | - | D5 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP1 | SIGNAL POLE | IS | 1532334360000 | IRVING ST | - | - | - | - | - | - |
| 23628 | N/A | Point | - | - | - | - | S247169 | IRVING ST: 5TH AVE | - | F | F | - | F | 27083000 | 27083000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | IRVING ST | 05TH AVE | 76332 | 76332 | 37.76422484 | -122.46203054 | 5TH AVE \ IRVING ST | IRVING ST \ 05TH AVE | 1710539427000 | MTA | (45 RA-DN) | 05TH AVE intersection | - | - | - | - | - | - | - | 40706 | 1283212800000 | -122.46203054 | 37.76422484 | - | 1532304000000 | - | D5 | - | OTHER WARNING | WARNING | W16-7P.0006 | 24X12 | SUP1 | LIGHT POLE | IS | 1532334780000 | IRVING ST | - | - | - | - | - | - |
| 23629 | N/A | Point | - | - | - | - | S247171 | IRVING ST: 5TH AVE | - | F | F | - | F | 27083000 | 27083000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | IRVING ST | 05TH AVE | 76333 | 76333 | 37.76422484 | -122.46203054 | 5TH AVE \ IRVING ST | IRVING ST \ 05TH AVE | 1710539427000 | MTA | PEDESTRIAN (SYM) | 05TH AVE intersection | - | EPL #421 | - | - | - | - | - | 40707 | 1283212800000 | -122.46203054 | 37.76422484 | - | 1532304000000 | - | D5 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | LIGHT POLE | IS | 1532339100000 | IRVING ST | - | - | - | - | - | - |
| 23630 | N/A | Point | - | - | - | - | S247172 | IRVING ST: 5TH AVE | - | F | F | - | F | 27083000 | 27083000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | IRVING ST | 05TH AVE | 76334 | 76334 | 37.76422484 | -122.46203054 | 5TH AVE \ IRVING ST | IRVING ST \ 05TH AVE | 1710539427000 | MTA | AHEAD | 05TH AVE intersection | - | EPL #421 | - | - | - | - | - | 40708 | 1283212800000 | -122.46203054 | 37.76422484 | - | 1532304000000 | - | D5 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP1 | LIGHT POLE | IS | 1532339340000 | IRVING ST | - | - | - | - | - | - |
| 23631 | N/A | Point | 1 | 1 | 1409 - 1499 | - | S247179 | 1409-1499 SACRAMENTO ST | 1409-1499 SACRAMENTO ST | F | F | - | F | 11245000 | 11245000 | - | - | NORTH SIDE | - | - | - | - | KIMBALL PL | KIMBALL PL | 76335 | 76335 | 37.79200529 | -122.41693644 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM TUE STCL | KIMBALL PL to HYDE ST (1409 - 1499) | - | IFO #1420 | - | - | - | - | - | 40709 | 1461628800000 | -122.41693644 | 37.79200529 | - | 1532476800000 | - | D3 | - | STREET CLEANING | REG | R30B(CA).0243 | 18X18 | SUP1 | 2IN IRON POST | IS | 1532342340000 | SACRAMENTO ST | 1409 - 1499 SACRAMENTO ST | 1409 - 1499 SACRAMENTO ST | 1409 SACRAMENTO ST | - | HYDE ST | HYDE ST |
| 23632 | N/A | Point | - | 1 | 500 - 599 | - | S247208 | 500-599 TOWNSEND ST | 500-599 TOWNSEND ST | F | F | - | F | 12665000 | 12665000 | - | - | NORTH SIDE | - | - | - | - | 6TH ST | 06TH ST | 76336 | 76336 | 37.7726953 | -122.40054491 | - | - | 1710539427000 | MTA | TANSAT | 06TH ST to 07TH ST (500 - 599) | - | 45FT WEST | - | - | - | - | - | 40710 | 1316736000000 | -122.40054491 | 37.7726953 | - | 1532304000000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1532353260000 | TOWNSEND ST | 500 - 599 TOWNSEND ST | 500 - 599 TOWNSEND ST | 500 TOWNSEND ST | - | 07TH ST | 07TH ST |
| 23633 | N/A | Point | - | 1 | 500 - 599 | RIGHT ARROW | S247209 | 500-599 TOWNSEND ST | 500-599 TOWNSEND ST | F | F | - | F | 12665000 | 12665000 | - | - | NORTH SIDE | - | - | - | - | 6TH ST | 06TH ST | 76337 | 76337 | 37.7726953 | -122.40054491 | - | - | 1710539427000 | MTA | TANSAT | 06TH ST to 07TH ST (500 - 599) | - | 100FT WEST OF 6TH ST | - | - | - | - | - | 40711 | 1316736000000 | -122.40054491 | 37.7726953 | - | 1532304000000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1532353440000 | TOWNSEND ST | 500 - 599 TOWNSEND ST | 500 - 599 TOWNSEND ST | 500 TOWNSEND ST | - | 07TH ST | 07TH ST |
| 23634 | N/A | Point | - | - | - | LEFT ARROW | S247210 | TOWNSEND ST: 6TH ST | - | F | F | - | F | 23855000 | 23855000 | - | - | NORTH WEST CORNER | - | - | - | - | TOWNSEND ST | 06TH ST | 76338 | 76338 | 37.77357346 | -122.39943313 | 6TH ST \ TOWNSEND ST | TOWNSEND ST \ 06TH ST | 1710539427000 | MTA | TANSAT | 06TH ST intersection | - | - | - | - | - | - | - | 40712 | 1316736000000 | -122.39943313 | 37.77357346 | - | 1532304000000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 3IN IRON POST | IS | 1532354280000 | TOWNSEND ST | - | - | - | - | - | - |
| 23635 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S251015 | 1000-1099 16TH ST | 1000-1099 16TH ST | T | T | - | F | 702000 | 702000 | - | - | NORTH SIDE | - | - | - | - | MISSOURI ST | MISSOURI ST | 77592 | 77592 | 37.76639965 | -122.39738025 | - | - | 1710539427000 | MTA | TANSAT | MISSOURI ST to CONNECTICUT ST (1000 - 1099) | - | 4' EAST OF EAST CROSSWALK | - | - | - | - | - | 40713 | 1481673600000 | -122.39738025 | 37.76639965 | - | 1510704000000 | - | D10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1548239700000 | 16TH ST | 1000 - 1099 16TH ST | 1000 - 1099 16TH ST | 1000 16TH ST | - | CONNECTICUT ST | CONNECTICUT ST |
| 23636 | N/A | Point | 1 | 1 | 300 - 329 | - | S205141 | 300-329 DOUGLASS ST | 300-329 DOUGLASS ST | F | F | - | F | 4945000 | 4945000 | - | - | WEST SIDE | - | - | - | - | 19TH ST | 19TH ST | 77594 | 77594 | 37.75874531 | -122.43914086 | - | - | 1753898066000 | middleware_editor | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | 19TH ST to CARSON ST (300 - 329) | - | IFO #372 | - | - | - | - | - | 40714 | 1363244400000 | -122.43914086 | 37.75874531 | - | - | - | D8 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | 2IN IRON POST | IS | 1398332640000 | DOUGLASS ST | 300 - 329 DOUGLASS ST | 300 - 329 DOUGLASS ST | 300 DOUGLASS ST | - | CARSON ST | CARSON ST |
| 23637 | N/A | Point | 1 | 1 | 4400 - 4499 | - | S205020 | 4400-4499 CALIFORNIA ST | 4400-4499 CALIFORNIA ST | F | F | - | F | 3582000 | 3582000 | - | - | NORTH SIDE | - | - | - | - | 6TH AVE | 06TH AVE | 77596 | 77596 | 37.78492325 | -122.46510224 | - | - | 1710539427000 | MTA | MUNI LANDOR FLAG - TYPE 2 | 06TH AVE to 07TH AVE \ CORNWALL ST (4400 - 4499) | - | IFO# 4416 CALIFORNIA ST | - | - | - | - | - | 40715 | - | -122.46510224 | 37.78492325 | - | - | - | D1 | - | OTHER REGULATORY | REG | R(SF).0335 | 15X25 | SUP2 | 2IN IRON POST | IS | 1397831880000 | CALIFORNIA ST | 4400 - 4499 CALIFORNIA ST | 4400 - 4499 CALIFORNIA ST | 4400 CALIFORNIA ST | - | 07TH AVE \ CORNWALL ST | 07TH AVE \ CORNWALL ST |
| 23638 | N/A | Point | 1 | 1 | 1 - 99 | - | S205255 | 1-99 BLUXOME ST | 1-99 BLUXOME ST | F | F | - | F | 2993000 | 2993000 | - | - | SOUTH SIDE | - | - | - | - | 4TH ST | 04TH ST | 77598 | 77598 | 37.77681983 | -122.39685672 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | 04TH ST to 05TH ST (1 - 99) | - | IFO #77 | - | - | - | - | - | 40716 | 1400853060000 | -122.39685672 | 37.77681983 | - | 1400803200000 | - | D6 | - | PARKING: PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | LIGHT POLE | IS | 1398692580000 | BLUXOME ST | 1 - 99 BLUXOME ST | 1 - 99 BLUXOME ST | 1 BLUXOME ST | - | 05TH ST | 05TH ST |
| 23639 | N/A | Point | 1 | 1 | 100 - 109 | - | S205374 | 100-109 SUTTER ST | 100-109 SUTTER ST | F | F | - | F | 12317000 | 12317000 | - | - | NORTH SIDE | - | - | - | - | MONTGOMERY ST | MONTGOMERY ST | 77599 | 77599 | 37.79001732 | -122.40236116 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM MON WED FRI STCL | MONTGOMERY ST to TRINITY ST (100 - 109) | - | IFO #180 | - | - | - | - | - | 40717 | 1190160000000 | -122.40236116 | 37.79001732 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0123 | 18X18 | SUP1 | LIGHT POLE | IS | 1399020300000 | SUTTER ST | 100 - 109 SUTTER ST | 100 - 109 SUTTER ST | 100 SUTTER ST | - | TRINITY ST | TRINITY ST |
| 23640 | N/A | Point | 1 | 1 | 2700 - 2798 | - | S250693 | 2700-2798 GEARY BLVD | 2700-2798 GEARY BLVD | F | F | - | F | 6047202 | 6047202 | - | - | NORTH SIDE | - | - | - | - | EMERSON ST | EMERSON ST | 77600 | 77600 | 37.78241262 | -122.44857845 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM TUE THUR STCL | EMERSON ST to WOOD ST (2700 - 2798) -- NORTH -- | - | 50 FT EAST OF WOORDS | - | - | - | - | - | 40718 | - | -122.44857845 | 37.78241262 | - | - | - | D1 | - | STREET CLEANING | REG | R30B(CA).0195 | 18X18 | SUP2 | 2IN IRON POST | IS | 1547037180000 | GEARY BLVD | 2700 - 2798 GEARY BLVD | 2700 - 2798 GEARY BLVD | 2700 GEARY BLVD | - | WOOD ST | WOOD ST |
| 23641 | N/A | Point | 1 | 1 | 100 - 199 | - | S250719 | 100-199 BRIGHTON AVE | 100-199 BRIGHTON AVE | F | F | - | F | 3133000 | 3133000 | - | - | WEST SIDE | - | - | - | - | GRAFTON AVE | GRAFTON AVE | 77601 | 77601 | 37.72094218 | -122.45512274 | - | - | 1754577553000 | middleware_editor | NPRK 1PM-3PM 1ST & 3RD MON OF MONTH STCL | GRAFTON AVE to HOLLOWAY AVE (100 - 199) | - | SPL 115 | - | - | - | - | - | 40719 | 1223276400000 | -122.45512274 | 37.72094218 | - | 1754504100000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0094 | 18X18 | SUP2 | 2IN IRON POST | IS | 1547111640000 | BRIGHTON AVE | 100 - 199 BRIGHTON AVE | 100 - 199 BRIGHTON AVE | 100 BRIGHTON AVE | - | HOLLOWAY AVE | HOLLOWAY AVE |
| 23642 | N/A | Point | 1 | 1 | 100 - 199 | - | S250720 | 100-199 BRIGHTON AVE | 100-199 BRIGHTON AVE | F | F | - | F | 3133000 | 3133000 | - | - | WEST SIDE | - | - | - | - | GRAFTON AVE | GRAFTON AVE | 77602 | 77602 | 37.72094218 | -122.45512274 | - | - | 1753723333000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "V" PERMITS | GRAFTON AVE to HOLLOWAY AVE (100 - 199) | - | 20 FEET SOUTH OF HOLLAWAY | - | - | - | - | - | 40720 | 1175670000000 | -122.45512274 | 37.72094218 | - | 1584082800000 | - | D11 | - | PARKING:RPP | REG | R32C(CA).0102 | 18X21 | SUP2 | 2IN IRON POST | IS | 1547111760000 | BRIGHTON AVE | 100 - 199 BRIGHTON AVE | 100 - 199 BRIGHTON AVE | 100 BRIGHTON AVE | - | HOLLOWAY AVE | HOLLOWAY AVE |
| 23643 | N/A | Point | - | - | - | - | S250727 | SANTIAGO ST: 47TH AVE | - | F | F | - | F | 23508000 | 23508000 | - | - | NORTH WEST CORNER | - | - | - | - | 47TH AVE | 47TH AVE | 77603 | 77603 | 37.74359563 | -122.50582381 | SANTIAGO ST \ 47TH AVE | SANTIAGO ST \ 47TH AVE | 1710539427000 | MTA | SANTIAGO ST | 47TH AVE intersection | - | - | - | - | - | - | - | 40721 | 1551962460000 | -122.50582381 | 37.74359563 | - | - | - | D4 | - | STREET NAME | GUIDE | D3-1.1587 | 36X08 | SUP2 | 3IN IRON POST | IS | 1547116020000 | SANTIAGO ST | - | - | - | - | - | - |
| 23644 | N/A | Point | - | - | - | - | S250732 | BALBOA ST: 18TH AVE | - | F | F | - | F | 27493000 | 27493000 | - | - | NORTH WEST CORNER | - | - | - | - | BALBOA ST | 18TH AVE | 77604 | 77604 | 37.7767173135889 | -122.477065846319 | 18TH AVE \ BALBOA ST | BALBOA ST \ 18TH AVE | 1740176101000 | middleware_editor | BALBOA ST | 18TH AVE intersection | - | NWC 1700> WEST | - | - | - | - | - | 40722 | 1552907880000 | -122.47696485 | 37.77664393 | - | 1740139200000 | - | D1 | - | STREET NAME | GUIDE | D3-1.0160 | 36X08 | SUP2 | 3IN IRON POST | IS | 1547119080000 | BALBOA ST | - | - | - | - | - | - |
| 23645 | N/A | Point | - | - | - | - | S250735 | 18TH AVE: BALBOA ST | - | F | F | - | F | 27493000 | 27493000 | - | - | NORTH WEST CORNER | - | - | - | - | BALBOA ST | 18TH AVE | 77605 | 77605 | 37.7767279137319 | -122.477053776378 | 18TH AVE \ BALBOA ST | BALBOA ST \ 18TH AVE | 1740176131000 | middleware_editor | 18TH AVE | 18TH AVE intersection | - | NWC 600> SOUTH | - | - | - | - | - | 40723 | 1552907940000 | -122.47696485 | 37.77664393 | - | 1740139200000 | - | D1 | - | STREET NAME | GUIDE | D3-1.0009 | 36X08 | SUP2 | 3IN IRON POST | IS | 1547119320000 | BALBOA ST | - | - | - | - | - | - |
| 23646 | N/A | Point | 1 | 1 | 900 - 999 | - | S250746 | 900-999 BUENA VISTA WEST AVE | 900-999 BUENA VISTA AVE WEST | F | F | - | F | 3371000 | 3371000 | - | - | EAST SIDE | - | - | - | - | BUENA VISTA AVE \ WALLER ST | BUENA VISTA AVE \ WALLER ST | 77607 | 77607 | 37.7700281 | -122.44312445 | - | - | 1756148316000 | middleware_editor | PARK AT 90 DEGREES (SYM) | BUENA VISTA AVE \ WALLER ST to BUENA VISTA AVE \ HAIGHT ST (900 - 999) | - | OPP #935 | - | - | - | - | - | 40724 | 1553023500000 | -122.44312445 | 37.7700281 | - | - | - | D8 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP2 | LIGHT POLE | IS | 1547123460000 | BUENA VISTA AVE WEST | 900 - 999 BUENA VISTA AVE WEST | 900 - 999 BUENA VISTA AVE WEST | 900 BUENA VISTA AVE WEST | - | BUENA VISTA AVE \ HAIGHT ST | BUENA VISTA AVE \ HAIGHT ST |
| 23647 | N/A | Point | - | - | - | - | S247668 | 22ND AVE: QUINTARA ST | - | F | F | - | F | 23210000 | 23210000 | - | - | NORTH WEST CORNER | - | - | - | - | QUINTARA ST | 22ND AVE | 77609 | 77609 | 37.74850364 | -122.47929591 | 22ND AVE \ QUINTARA ST | QUINTARA ST \ 22ND AVE | 1730912306000 | middleware_editor | 22ND AVE | 22ND AVE intersection | - | - | - | - | - | - | - | 40725 | 1538661600000 | -122.47929591 | 37.74850364 | - | - | - | D4 | - | STREET NAME | GUIDE | D3-1.0014 | 36X08 | SUP2 | 3IN IRON POST | IS | 1533740220000 | QUINTARA ST | - | - | - | - | - | - |
| 23648 | N/A | Point | - | - | - | - | S247670 | CLEARFIELD DR: 34TH AVE \ SLOA | - | F | F | - | F | 23338000 | 23338000 | - | - | SOUTH WEST CORNER | - | - | - | - | 34TH AVE \ CLEARFIELD DR | 34TH AVE \ CLEARFIELD DR | 77610 | 77610 | 37.73400786 | -122.49134262 | SLOAT BLVD \ 34TH AVE \ CLEARFIELD DR | SLOAT BLVD \ 34TH AVE \ CLEARFIELD DR | 1750170117000 | middleware_editor | CLEARFIELD DR | 34TH AVE \ CLEARFIELD DR intersection | - | - | - | - | - | - | - | 40726 | 1540588020000 | -122.49134262 | 37.73400786 | - | - | - | D4 | - | STREET NAME | GUIDE | D3-1.0393 | 36X08 | SUP2 | SIGNAL POLE | IS | 1533741480000 | SLOAT BLVD | - | - | - | - | - | - |
| 23649 | N/A | Point | - | - | - | - | S248319 | NIAGARA AVE: MISSION ST | - | T | T | - | F | 21484000 | 21484000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | NIAGARA AVE | NIAGARA AVE | 77612 | 77612 | 37.7155727 | -122.44169116 | MISSION ST \ NIAGARA AVE | MISSION ST \ NIAGARA AVE | 1710539427000 | MTA | (LA) POPE / NIAGARA (RA) | NIAGARA AVE intersection | - | - | - | - | - | - | - | 40727 | 588297600000 | -122.44169116 | 37.7155727 | - | 1548288000000 | - | D11 | - | STREET NAME | GUIDE | D3-2.0456 | 72X30 | SUP2 | MUNI POLE | IS | 1536835200000 | MISSION ST | - | - | - | - | - | - |
| 23650 | N/A | Point | - | - | - | - | S234065 | RUTLAND ST: CAMPBELL AVE | - | F | F | - | F | 20333000 | 20333000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CAMPBELL AVE | CAMPBELL AVE | 67021 | 67021 | 37.71524435 | -122.40618937 | RUTLAND ST \ CAMPBELL AVE | RUTLAND ST \ CAMPBELL AVE | 1715383044000 | middleware_editor | ALL WAY | CAMPBELL AVE intersection | - | 0 / 0 | - | - | - | - | - | 40728 | -65836800000 | -122.40618937 | 37.71524435 | - | 1494201600000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1488535020000 | RUTLAND ST | - | - | - | - | - | - |
| 23651 | N/A | Point | - | - | - | - | S233557 | LIBERTY ST: SANCHEZ ST | - | F | F | - | F | 25782000 | 25782000 | - | - | SOUTH SIDE | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 67024 | 67024 | 37.75712501 | -122.4306785 | LIBERTY ST \ SANCHEZ ST | LIBERTY ST \ SANCHEZ ST | 1755277426000 | middleware_editor | 2 HR PRK 8AM-9PM MON-SAT EXC "S" PERMITS | SANCHEZ ST intersection | - | @ 455 LIBERTY ST. | - | - | - | - | - | 40729 | 1491514320000 | -122.4306785 | 37.75712501 | - | 1491462000000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0139 | 18X21 | SUP2 | 2IN IRON POST | IS | 1487057760000 | LIBERTY ST | - | - | - | - | - | - |
| 23652 | N/A | Point | - | - | - | - | S233559 | LIBERTY ST: SANCHEZ ST | - | F | F | - | F | 25782000 | 25782000 | - | - | SOUTH WEST CORNER | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 67025 | 67025 | 37.75712501 | -122.4306785 | LIBERTY ST \ SANCHEZ ST | LIBERTY ST \ SANCHEZ ST | 1755277418000 | middleware_editor | 2 HR PRK 8AM-9PM MON-SAT EXC "S" PERMITS | SANCHEZ ST intersection | - | - | - | - | - | - | - | 40730 | 1491515820000 | -122.4306785 | 37.75712501 | - | 1491462000000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0139 | 18X21 | SUP2 | LIGHT POLE | IS | 1487058240000 | LIBERTY ST | - | - | - | - | - | - |
| 23653 | N/A | Point | - | - | - | - | S233560 | LIBERTY ST: SANCHEZ ST | - | F | F | - | F | 25782000 | 25782000 | - | - | SOUTH WEST CORNER | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 67026 | 67026 | 37.75712501 | -122.4306785 | LIBERTY ST \ SANCHEZ ST | LIBERTY ST \ SANCHEZ ST | 1755277428000 | middleware_editor | LIBERTY ST | SANCHEZ ST intersection | - | LIBERTY (400)--> WEST | - | - | - | - | - | 40731 | 1491515940000 | -122.4306785 | 37.75712501 | - | 1491462000000 | - | D8 | - | STREET NAME | GUIDE | D3-1.1039 | 36X08 | SUP2 | LIGHT POLE | IS | 1487058780000 | LIBERTY ST | - | - | - | - | - | - |
| 23654 | N/A | Point | - | - | - | - | S233561 | SANCHEZ ST: LIBERTY ST | - | F | F | - | F | 25714000 | 25714000 | - | - | SOUTH WEST CORNER | - | - | - | - | LIBERTY ST | SANCHEZ ST | 67027 | 67027 | 37.75715468 | -122.43026021 | SANCHEZ ST \ LIBERTY ST | LIBERTY ST \ SANCHEZ ST | 1710539427000 | MTA | SANCHEZ ST | SANCHEZ ST intersection | - | - | - | - | - | - | - | 40732 | 1491490860000 | -122.43026021 | 37.75715468 | - | 1491436800000 | - | D8 | - | STREET NAME | GUIDE | D3-1.1573 | 36X08 | SUP2 | LIGHT POLE | IS | 1487059140000 | LIBERTY ST | - | - | - | - | - | - |
| 23655 | N/A | Point | 1 | 1 | 400 - 414 | - | S233562 | PNDG LIBERTY ST | 400-414 LIBERTY ST | F | F | - | F | 8326000 | 8325000 | - | - | SOUTH SIDE | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 67028 | 67028 | 37.7570768116296 | -122.430977107417 | - | - | 1755880408000 | middleware_editor | NPRK 9AM-11AM THUR STCL | SANCHEZ ST to SANCHEZ ST (400 - 414) | - | @ 433 LIBERTY ST. | - | - | - | - | - | 40733 | 1522773900000 | -122.43046935 | 37.75713984 | - | 1755639000000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0304 | 18X18 | SUP2 | 2IN IRON POST | IS | 1487059560000 | LIBERTY ST | 413 - 483 LIBERTY ST | 400 - 414 LIBERTY ST | - | - | RAYBURN ST | SANCHEZ ST |
| 23656 | N/A | Point | - | - | - | - | S233563 | RAYBURN ST: LIBERTY ST | - | F | F | - | F | 25783000 | 25783000 | - | - | SOUTH WEST CORNER | - | - | - | - | LIBERTY ST | LIBERTY ST | 67029 | 67029 | 37.75705435 | -122.43184639 | RAYBURN ST \ LIBERTY ST | RAYBURN ST \ LIBERTY ST | 1710539427000 | MTA | RAYBURN ST | LIBERTY ST intersection | - | - | - | - | - | - | - | 40734 | 1491490920000 | -122.43184639 | 37.75705435 | - | 1491436800000 | - | D8 | - | STREET NAME | GUIDE | D3-1.1454 | 36X08 | SUP2 | LIGHT POLE | IS | 1487059920000 | RAYBURN ST | - | - | - | - | - | - |
| 23657 | N/A | Point | - | - | - | - | S233564 | LIBERTY ST: RAYBURN ST | - | F | F | - | F | 25783000 | 25783000 | - | - | SOUTH WEST CORNER | - | - | - | - | LIBERTY ST | LIBERTY ST | 67030 | 67030 | 37.75705435 | -122.43184639 | RAYBURN ST \ LIBERTY ST | RAYBURN ST \ LIBERTY ST | 1710539427000 | MTA | LIBERTY ST | LIBERTY ST intersection | - | OF LIBERTY ST. & RAYBURN ST. | - | - | - | - | - | 40735 | 1491490980000 | -122.43184639 | 37.75705435 | - | 1491436800000 | - | D8 | - | STREET NAME | GUIDE | D3-1.1039 | 36X08 | SUP2 | LIGHT POLE | IS | 1487060220000 | RAYBURN ST | - | - | - | - | - | - |
| 23658 | N/A | Point | - | - | - | - | S233686 | TARAVAL ST: SUNSET BLVD | - | T | T | - | F | 23384000 | 23384000 | - | - | SOUTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | SUNSET BLVD | 67032 | 67032 | 37.74222503 | -122.49444328 | SUNSET BLVD \ TARAVAL ST | TARAVAL ST \ SUNSET BLVD | 1731105040000 | middleware_editor | NO LEFT TURN (SYM) | SUNSET BLVD intersection | - | 20 FT WEST OF SUNSET | - | - | - | - | - | 40736 | 1276732800000 | -122.49444328 | 37.74222503 | - | - | 1731063900000 | D4 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | MUNI POLE | RETD | 1487238660000 | TARAVAL ST | - | - | - | - | - | - |
| 23659 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S233693 | 2300-2399 31ST AVE | 2300-2399 31ST AVE | F | F | - | F | 1694000 | 1694000 | - | - | EAST SIDE | - | - | - | - | SANTIAGO ST | SANTIAGO ST | 67033 | 67033 | 37.74341809 | -122.48861243 | - | - | 1727140679000 | middleware_editor | 1 HR PRK 8AM-1PM SCHL DAYS EXC "T" PERMITS | SANTIAGO ST to TARAVAL ST (2300 - 2399) | - | 20`NORTH OF TARAVAL | - | - | - | - | - | 40737 | 1487937960000 | -122.48861243 | 37.74341809 | - | 1487894400000 | - | D4 | - | PARKING:RPP | REG | R32C(CA).0005 | 18X21 | SUP2 | 2IN IRON POST | IS | 1487244780000 | 31ST AVE | 2300 - 2399 31ST AVE | 2300 - 2399 31ST AVE | 2300 31ST AVE | - | TARAVAL ST | TARAVAL ST |
| 23660 | N/A | Point | - | - | - | - | S230748 | GATES ST: EUGENIA AVE | - | F | F | - | F | 21086000 | 21086000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GATES ST | GATES ST | 67034 | 67034 | 37.74031684 | -122.41392377 | EUGENIA AVE \ GATES ST | EUGENIA AVE \ GATES ST | 1710539427000 | MTA | ALL WAY | GATES ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 40738 | 190252800000 | -122.41392377 | 37.74031684 | - | 1493251200000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1478676840000 | EUGENIA AVE | - | - | - | - | - | - |
| 23661 | N/A | Point | - | - | - | - | S230749 | PERALTA AVE: POWHATTAN AVE | - | F | F | - | F | 21097000 | 21097000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | POWHATTAN AVE | POWHATTAN AVE | 67035 | 67035 | 37.74127738 | -122.40874913 | PERALTA AVE \ POWHATTAN AVE | PERALTA AVE \ POWHATTAN AVE | 1755117122000 | middleware_editor | ALL WAY | POWHATTAN AVE intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 40739 | 619772400000 | -122.40874913 | 37.74127738 | - | 1493276400000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1478677380000 | PERALTA AVE | - | - | - | - | - | - |
| 23662 | N/A | Point | - | - | - | - | S230752 | POWHATTAN AVE: PERALTA AVE | - | F | F | - | F | 21097000 | 21097000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | POWHATTAN AVE | POWHATTAN AVE | 67036 | 67036 | 37.74127738 | -122.40874913 | PERALTA AVE \ POWHATTAN AVE | PERALTA AVE \ POWHATTAN AVE | 1756421799000 | middleware_editor | ALL WAY | POWHATTAN AVE intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 40740 | 619772400000 | -122.40874913 | 37.74127738 | - | 1756408500000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1478678400000 | PERALTA AVE | - | - | - | - | - | - |
| 23663 | N/A | Point | - | - | - | - | S230753 | PROSPECT AVE: VIRGINIA AVE | - | F | F | - | F | 21317000 | 21317000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VIRGINIA AVE | VIRGINIA AVE | 67037 | 67037 | 37.74231754 | -122.41949107 | PROSPECT AVE \ VIRGINIA AVE | PROSPECT AVE \ VIRGINIA AVE | 1710539427000 | MTA | ALL WAY | VIRGINIA AVE intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 40741 | -394848000000 | -122.41949107 | 37.74231754 | - | - | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1478679060000 | PROSPECT AVE | - | - | - | - | - | - |
| 23664 | N/A | Point | - | - | - | - | S230754 | PROSPECT AVE: VIRGINIA AVE | - | F | F | - | F | 21317000 | 21317000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VIRGINIA AVE | VIRGINIA AVE | 67038 | 67038 | 37.74231754 | -122.41949107 | PROSPECT AVE \ VIRGINIA AVE | PROSPECT AVE \ VIRGINIA AVE | 1710539427000 | MTA | ALL WAY | VIRGINIA AVE intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 40742 | -394848000000 | -122.41949107 | 37.74231754 | - | 1494288000000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1478679240000 | PROSPECT AVE | - | - | - | - | - | - |
| 23665 | N/A | Point | - | - | - | - | S228773 | MASON ST: OFARRELL ST | - | F | F | - | F | 24913000 | 24913000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MASON ST | OFARRELL ST | 67039 | 67039 | 37.78620267 | -122.40968307 | OFARRELL ST \ MASON ST | MASON ST \ OFARRELL ST | 1710539427000 | MTA | ONE WAY (LA) | OFARRELL ST intersection | - | - | - | - | - | - | - | 40743 | 1473766440000 | -122.40968307 | 37.78620267 | - | 1473724800000 | - | D3 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP1 | SIGNAL POLE | IS | 1473330840000 | MASON ST | - | - | - | - | - | - |
| 23666 | N/A | Point | - | - | - | - | S228790 | ALAMEDA ST: HENRY ADAMS ST | - | F | F | - | F | 23862000 | 23862000 | - | - | SOUTH WEST CORNER | - | - | - | - | HENRY ADAMS ST | ALAMEDA ST | 67041 | 67041 | 37.76859109 | -122.40387382 | ALAMEDA ST \ HENRY ADAMS ST | HENRY ADAMS ST \ ALAMEDA ST | 1753722967000 | middleware_editor | ALAMEDA ST | ALAMEDA ST intersection | - | 1900 | - | - | - | - | - | 40744 | 1474061580000 | -122.40387382 | 37.76859109 | - | 1474009200000 | - | D10 | - | STREET NAME | GUIDE | D3-1.0070 | 36X08 | SUP1 | 3IN IRON POST | IS | 1473339720000 | HENRY ADAMS ST | - | - | - | - | - | - |
| 23667 | N/A | Point | - | - | - | - | S229127 | NORTH POINT ST: LEAVENWORTH ST | - | F | F | - | F | 25575000 | 25575000 | - | - | SOUTH WEST CORNER | - | - | - | - | NORTH POINT ST | NORTH POINT ST | 67556 | 67556 | 37.80593152 | -122.41871827 | LEAVENWORTH ST \ NORTH POINT ST | LEAVENWORTH ST \ NORTH POINT ST | 1710539427000 | MTA | NO PED XING-USE CROSSWALK (LA) | NORTH POINT ST intersection | - | ARROW FOR COLUMBUS X WALK | - | - | - | - | - | 40745 | 1474903200000 | -122.41871827 | 37.80593152 | - | 1474848000000 | - | D2 | - | PEDESTRIAN | REG | R49(CA).0004 | 36X18 | SUP1 | 2 POST ALUMINUM | IS | 1474539900000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 23668 | N/A | Point | - | - | - | - | S229128 | MARKET ST: 6TH ST \ GOLDEN GAT | - | T | T | - | F | 24922000 | 24922000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 6TH ST \ GOLDEN GATE AVE \ MARKET ST | 06TH ST \ GOLDEN GATE AVE \ TAYLOR ST | 67557 | 67557 | 37.78223058 | -122.41029203 | TAYLOR ST \ 6TH ST \ GOLDEN GATE AVE \ MARKET ST | MARKET ST \ 06TH ST \ GOLDEN GATE AVE \ TAYLOR ST | 1744120891000 | middleware_editor | EXC MUNI | 06TH ST \ GOLDEN GATE AVE \ TAYLOR ST intersection | - | - | - | - | - | - | - | 40746 | -385488000000 | -122.41029203 | 37.78223058 | - | 1475823600000 | 1743867000000 | D6 | - | OTHER REGULATORY | REG | R(SF).0072 | 30X12 | SUP1 | SIGNAL POLE | RETD | 1474542420000 | MARKET ST | - | - | - | - | - | - |
| 23669 | N/A | Point | - | - | - | - | S230536 | 12TH AVE: LAWTON ST | - | F | F | - | F | 27130000 | 27130000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LAWTON ST | 12TH AVE | 67561 | 67561 | 37.75830399 | -122.46913102 | 12TH AVE \ LAWTON ST | LAWTON ST \ 12TH AVE | 1732038944000 | middleware_editor | ALL WAY | 12TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 40747 | 214531200000 | -122.46913102 | 37.75830399 | - | 1479168000000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477992900000 | LAWTON ST | - | - | - | - | - | - |
| 23670 | N/A | Point | - | - | - | - | S227671 | INDUSTRIAL ST: BARNEVELD AVE \ | - | F | F | - | F | 20788000 | 20788000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BARNEVELD AVE \ INDUSTRIAL ST | BARNEVELD AVE \ INDUSTRIAL ST | 67565 | 67565 | 37.73871259 | -122.40425799 | SHAFTER AVE \ BARNEVELD AVE \ INDUSTRIAL ST | SHAFTER AVE \ BARNEVELD AVE \ INDUSTRIAL ST | 1753884502000 | middleware_editor | (45 LA-DN) | BARNEVELD AVE \ INDUSTRIAL ST intersection | - | - | - | - | - | - | - | 40748 | 1470344820000 | -122.40425799 | 37.73871259 | - | 1470294000000 | - | D10 | - | OTHER WARNING | WARNING | W16-7P.0001 | 18X18 | SUP1 | 2IN IRON POST | IS | 1470143400000 | SHAFTER AVE | - | - | - | - | - | - |
| 23671 | N/A | Point | - | - | - | - | S227674 | JAMESTOWN AVE: CORONADO ST | - | F | F | - | F | 20434000 | 20434000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | JAMESTOWN AVE | JAMESTOWN AVE | 67566 | 67566 | 37.71692191 | -122.39072311 | CORONADO ST \ JAMESTOWN AVE | CORONADO ST \ JAMESTOWN AVE | 1710539427000 | MTA | STOP | JAMESTOWN AVE intersection | - | - | - | - | - | - | - | 40749 | 1470310680000 | -122.39072311 | 37.71692191 | - | 1470268800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1470145020000 | CORONADO ST | - | - | - | - | - | - |
| 23672 | N/A | Point | - | - | - | - | S227675 | JAMESTOWN AVE: CORONADO ST | - | F | F | - | F | 20434000 | 20434000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JAMESTOWN AVE | JAMESTOWN AVE | 67567 | 67567 | 37.71692191 | -122.39072311 | CORONADO ST \ JAMESTOWN AVE | CORONADO ST \ JAMESTOWN AVE | 1710539427000 | MTA | STOP | JAMESTOWN AVE intersection | - | - | - | - | - | - | - | 40750 | 1470310860000 | -122.39072311 | 37.71692191 | - | 1470268800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1470145080000 | CORONADO ST | - | - | - | - | - | - |
| 23673 | N/A | Point | - | - | - | - | S228324 | LINDA ST: 19TH ST | - | F | F | - | F | 25672000 | 25672000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 67568 | 67568 | 37.76001342 | -122.42287938 | LINDA ST \ 19TH ST | LINDA ST \ 19TH ST | 1749050552000 | middleware_editor | STOP | 19TH ST intersection | - | S/S OF UTILLITY BOX @ EDGE OF H/C RAMP | - | - | - | - | - | 40751 | 1475013420000 | -122.42287938 | 37.76001342 | - | 1651561200000 | 1748973300000 | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | RETD | 1471948320000 | LINDA ST | - | - | - | - | - | - |
| 23674 | N/A | Point | - | - | - | - | S228327 | LINDA ST: 19TH ST | - | F | F | - | F | 25672000 | 25672000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 67569 | 67569 | 37.76001342 | -122.42287938 | LINDA ST \ 19TH ST | LINDA ST \ 19TH ST | 1749050530000 | middleware_editor | DO NOT ENTER | 19TH ST intersection | - | BACK TO BACK WITH NEW STOP SIGN | - | - | - | - | - | 40752 | 1475014920000 | -122.42287938 | 37.76001342 | - | 1748978400000 | - | D8 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1471948560000 | LINDA ST | - | - | - | - | - | - |
| 23675 | N/A | Point | 1 | 1 | 1 - 99 | - | S228329 | 1-99 LINDA ST | 1-99 LINDA ST | T | T | - | F | 8388000 | 8388000 | - | - | WEST SIDE | - | - | - | - | 18TH ST | 18TH ST | 67570 | 67570 | 37.76081825 | -122.42293163 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM WED STCL | 18TH ST to 19TH ST (1 - 99) | - | 15'N OF 19TH ST. | - | - | - | - | - | 40753 | 1053475200000 | -122.42293163 | 37.76081825 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0312 | 18X18 | SUP2 | LIGHT POLE | IS | 1471949100000 | LINDA ST | 1 - 99 LINDA ST | 1 - 99 LINDA ST | 1 LINDA ST | - | 19TH ST | 19TH ST |
| 23676 | N/A | Point | 1 | 1 | 800 - 899 | - | S231165 | 800-899 BATTERY ST | 800-899 BATTERY ST | F | F | - | F | 2763000 | 2763000 | - | - | EAST SIDE | - | - | - | - | BROADWAY | BROADWAY | 67571 | 67571 | 37.79905575 | -122.40114577 | - | - | 1716227788000 | middleware_editor | NPPZ 7AM-10PM EVERYDAY | BROADWAY to VALLEJO ST (800 - 899) | - | IFO #810 | - | - | - | - | - | 40754 | 1480603320000 | -122.40114577 | 37.79905575 | - | 1480550400000 | 1716202500000 | D3 | - | OTHER REGULATORY | REG | R30(SF).0253 | 12X18 | SUP1 | 2IN IRON POST | RETD | 1479468660000 | BATTERY ST | 800 - 899 BATTERY ST | 800 - 899 BATTERY ST | 800 BATTERY ST | - | VALLEJO ST | VALLEJO ST |
| 23677 | N/A | Point | - | - | - | - | S231589 | 2701-2899 ALEMANY BLVD | - | T | T | - | F | 2175000 | - | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | - | - | 67582 | 67582 | 37.713506 | -122.449851 | - | - | 1727312538000 | middleware_editor | PEDESTRIAN (SYM) | - | - | 200 FT SOUTH OF NAGLEE | - | - | - | - | - | 40755 | 1485434640000 | -122.449851 | 37.713506 | - | 1485388800000 | - | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | LIGHT POLE | IS | 1481109660000 | - | 2701-2899 ALEMANY BLVD | - | - | - | - | - |
| 23678 | N/A | Point | - | - | - | - | S231590 | 2701-2899 ALEMANY BLVD | - | T | T | - | F | 2175000 | - | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | - | - | 67583 | 67583 | 37.713506 | -122.449851 | - | - | 1727312541000 | middleware_editor | AHEAD | - | - | 200 FT SOUTH OF NAGLEE | - | - | - | - | - | 40756 | 1485513540000 | -122.449851 | 37.713506 | - | 1485475200000 | - | D11 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP2 | LIGHT POLE | IS | 1481109900000 | - | 2701-2899 ALEMANY BLVD | - | - | - | - | - |
| 23679 | N/A | Point | - | - | - | - | S231591 | 2701-2899 ALEMANY BLVD | - | T | T | - | F | 2175000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | - | - | 67584 | 67584 | 37.713395 | -122.449793 | - | - | 1710539427000 | MTA | PEDESTRIAN (SYM) | - | - | 250`SOUTH (OPP LP) | - | - | - | - | - | 40757 | 1485442740000 | -122.449793 | 37.713395 | - | 1485388800000 | - | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1481110140000 | - | 2701-2899 ALEMANY BLVD | - | - | - | - | - |
| 23680 | N/A | Point | - | - | - | - | S227127 | FRANKLIN ST: UNION ST | - | F | F | - | F | 26687000 | 26687000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 67594 | 67594 | 37.79834354 | -122.4256255 | UNION ST \ FRANKLIN ST | UNION ST \ FRANKLIN ST | 1710539427000 | MTA | ONE WAY (RA) | FRANKLIN ST intersection | - | - | - | - | - | - | - | 40758 | -300585600000 | -122.4256255 | 37.79834354 | - | 1468281600000 | - | D2 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | LIGHT POLE | IS | 1467881760000 | UNION ST | - | - | - | - | - | - |
| 23681 | N/A | Point | 1 | 1 | 1 - 99 | - | S228586 | 1-99 IRVING ST | 1-99 IRVING ST | F | F | - | F | 7278000 | 7278000 | - | - | SOUTH SIDE | - | - | - | - | ARGUELLO BLVD | ARGUELLO BLVD | 67641 | 67641 | 37.76440398 | -122.45821914 | - | - | 1710539427000 | MTA | NPRK 7AM-8AM TUE STCL | ARGUELLO BLVD to 02ND AVE (1 - 99) | 15124 | OPP C/L OF ARGUELLO | - | - | - | - | - | 40759 | - | -122.45821914 | 37.76440398 | - | - | - | D5 | - | STREET CLEANING | REG | R30B(CA).0220 | 18X18 | SUP1 | 2IN IRON POST | IS | 1472725260000 | IRVING ST | 1 - 99 IRVING ST | 1 - 99 IRVING ST | 1 IRVING ST | - | 02ND AVE | 02ND AVE |
| 23682 | N/A | Point | 1 | 1 | 3300 - 3399 | - | S228999 | 3300-3399 21ST ST | 3300-3399 21ST ST | F | F | - | F | 1113000 | 1113000 | - | - | SOUTH SIDE | - | - | - | - | VALENCIA ST | VALENCIA ST | 68351 | 68351 | 37.75683539 | -122.42222407 | - | - | 1731449438000 | middleware_editor | BUMP | VALENCIA ST to GUERRERO ST (3300 - 3399) | - | WPL# 3381 | - | - | - | - | - | 40760 | - | -122.42222407 | 37.75683539 | - | - | - | D8 | - | OTHER WARNING | WARNING | W8-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1474281240000 | 21ST ST | 3300 - 3399 21ST ST | 3300 - 3399 21ST ST | 3300 21ST ST | - | GUERRERO ST | GUERRERO ST |
| 23683 | N/A | Point | 1 | 1 | 3900 - 3999 | - | S229002 | 3900-3999 20TH ST | 3900-3999 20TH ST | F | F | - | F | 1062000 | 1062000 | - | - | SOUTH SIDE | - | - | - | - | CHURCH ST | CHURCH ST | 68353 | 68353 | 37.75802166 | -122.42915935 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM MON STCL | CHURCH ST to SANCHEZ ST (3900 - 3999) | - | WPL #3909/3911 | - | - | - | - | - | 40761 | 1062547200000 | -122.42915935 | 37.75802166 | - | 1474848000000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0300 | 18X18 | SUP2 | 2IN IRON POST | IS | 1474284480000 | 20TH ST | 3900 - 3999 20TH ST | 3900 - 3999 20TH ST | 3900 20TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 23684 | N/A | Point | 1 | 1 | 3900 - 3999 | - | S229003 | 3900-3999 20TH ST | 3900-3999 20TH ST | F | F | - | F | 1062000 | 1062000 | - | - | SOUTH SIDE | - | - | - | - | CHURCH ST | CHURCH ST | 68354 | 68354 | 37.75802166 | -122.42915935 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM MON STCL | CHURCH ST to SANCHEZ ST (3900 - 3999) | - | INFO #3933 | - | - | - | - | - | 40762 | 1062547200000 | -122.42915935 | 37.75802166 | - | 1474848000000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0300 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1474284900000 | 20TH ST | 3900 - 3999 20TH ST | 3900 - 3999 20TH ST | 3900 20TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 23685 | N/A | Point | - | - | - | - | S229023 | 2ND ST: FEDERAL ST | - | F | F | - | F | 24486000 | 24486000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 2ND ST | FEDERAL ST | 68355 | 68355 | 37.78264967 | -122.39308248 | FEDERAL ST \ 2ND ST | 02ND ST \ FEDERAL ST | 1710539427000 | MTA | (VA) ONLY (VA-RA) (RA) ONLY | FEDERAL ST intersection | - | SEE NOTES | - | - | - | - | - | 40763 | 1474901340000 | -122.39308248 | 37.78264967 | - | 1474848000000 | - | D6 | - | OTHER REGULATORY | REG | R61(SF).0108 | 36X30 | SUP1 | 2IN IRON POST | IS | 1474362180000 | 02ND ST | - | - | - | - | - | - |
| 23686 | N/A | Point | - | - | - | - | S227731 | GUERRERO ST: 21ST ST | - | F | F | - | F | 25627000 | 25627000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | GUERRERO ST | GUERRERO ST | 68358 | 68358 | 37.75676878 | -122.42333061 | 21ST ST \ GUERRERO ST | 21ST ST \ GUERRERO ST | 1721696668000 | middleware_editor | SPEED LIMIT 25 | GUERRERO ST intersection | - | BELOW COMM VECH SIGN | - | - | - | - | - | 40764 | 1472553480000 | -122.42333061 | 37.75676878 | - | 1472515200000 | - | D8 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP2 | LIGHT POLE | IS | 1470301680000 | 21ST ST | - | - | - | - | - | - |
| 23687 | N/A | Point | - | - | - | - | S227732 | GUERRERO ST: 21ST ST | - | F | F | - | F | 25627000 | 25627000 | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | - | - | - | - | GUERRERO ST | GUERRERO ST | 68359 | 68359 | 37.75676878 | -122.42333061 | 21ST ST \ GUERRERO ST | 21ST ST \ GUERRERO ST | 1721696695000 | middleware_editor | SPEED LIMIT 25 | GUERRERO ST intersection | - | - | - | - | - | - | - | 40765 | 1472553540000 | -122.42333061 | 37.75676878 | - | 1472515200000 | - | D8 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP2 | LIGHT POLE | IS | 1470302040000 | 21ST ST | - | - | - | - | - | - |
| 23688 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S234935 | 1500-1599 POWELL ST | 1500-1599 POWELL ST | F | F | - | F | 10694000 | 10694000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | VALLEJO ST | VALLEJO ST | 68361 | 68361 | 37.79883778 | -122.41055022 | - | - | 1711461411000 | middleware_editor | "P" (WHITE-BLUE) | VALLEJO ST to GREEN ST (1500 - 1599) | - | OPP#1504 | - | - | - | - | - | 40766 | 1497364560000 | -122.41055022 | 37.79883778 | - | 1497312000000 | - | D3 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1491472080000 | POWELL ST | 1500 - 1599 POWELL ST | 1500 - 1599 POWELL ST | 1500 POWELL ST | - | GREEN ST | GREEN ST |
| 23689 | N/A | Point | - | - | - | - | S233529 | BAY VIEW ST: FLORA ST | - | F | F | - | F | 20530000 | 20530000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | FLORA ST | FLORA ST | 68362 | 68362 | 37.73274324 | -122.39412709 | BAY VIEW ST \ FLORA ST | BAY VIEW ST \ FLORA ST | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | FLORA ST intersection | 133485 | X-ST IS FLORA ST., 45`EAST OF NEWHALL | - | - | - | - | - | 40767 | 1319068800000 | -122.39412709 | 37.73274324 | - | - | - | D10 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP1 | 2IN IRON POST | IS | 1486975140000 | BAY VIEW ST | - | - | - | - | - | - |
| 23690 | N/A | Point | 1 | 1 | 100 - 154 | LEFT ARROW | S233530 | 100-154 PARNASSUS AVE | 100-154 PARNASSUS AVE | F | F | - | F | 10287000 | 10287000 | - | - | SOUTH SIDE | - | - | - | - | COLE ST | COLE ST | 68363 | 68363 | 37.76477441 | -122.45049139 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-5PM MON-FRI EXC "J" PERMITS | COLE ST to SHRADER ST (100 - 154) | - | 60 FT WEST OF COLE | - | - | - | - | - | 40768 | 1610104560000 | -122.45049139 | 37.76477441 | - | - | - | D5 | - | PARKING:RPP | REG | R32C(CA).0063 | 18X21 | SUP1 | 2IN IRON POST | IS | 1486977780000 | PARNASSUS AVE | 100 - 154 PARNASSUS AVE | 100 - 154 PARNASSUS AVE | 100 PARNASSUS AVE | - | SHRADER ST | SHRADER ST |
| 23691 | N/A | Point | - | - | - | - | S233698 | CESAR CHAVEZ ST: CAPP ST \ MIS | - | F | F | - | F | 21304000 | 21304000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | CESAR CHAVEZ ST \ MISSION ST | CAPP ST \ CESAR CHAVEZ ST | 68365 | 68365 | 37.74816569 | -122.41822117 | CAPP ST \ CESAR CHAVEZ ST \ MISSION ST | MISSION ST \ CAPP ST \ CESAR CHAVEZ ST | 1710539427000 | MTA | EXC MUNI | CAPP ST \ CESAR CHAVEZ ST intersection | - | OF CESAR CHAVEZ & MISSION ST.-F/E/B/T | - | - | - | - | - | 40769 | 1487947680000 | -122.41822117 | 37.74816569 | - | 1487894400000 | - | D9 | - | OTHER REGULATORY | REG | R(SF).0072 | 30X12 | SUP2 | LIGHT POLE | IS | 1487245980000 | MISSION ST | - | - | - | - | - | - |
| 23692 | N/A | Point | 1 | 1 | 1100 - 1136 | - | S233819 | 1100-1136 TAYLOR ST | 1100-1136 TAYLOR ST | F | F | - | F | 12442000 | 12442000 | - | - | WEST SIDE | - | - | - | - | SACRAMENTO ST | SACRAMENTO ST | 68366 | 68366 | 37.79277231 | -122.41269454 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-SAT EXC "C" PERMITS | SACRAMENTO ST to PLEASANT ST (1100 - 1136) | - | IFO# 1115 | - | - | - | - | - | 40770 | - | -122.41269454 | 37.79277231 | - | - | - | D3 | - | PARKING:RPP | REG | R32C(CA).0134 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1487755680000 | TAYLOR ST | 1100 - 1136 TAYLOR ST | 1100 - 1136 TAYLOR ST | 1100 TAYLOR ST | - | PLEASANT ST | PLEASANT ST |
| 23693 | N/A | Point | - | - | - | - | S233782 | WISCONSIN ST: CONNECTICUT ST | - | F | F | - | F | 28098000 | 28098000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WISCONSIN ST | WISCONSIN ST | 68367 | 68367 | 37.75368475 | -122.39859315 | CONNECTICUT ST \ WISCONSIN ST | CONNECTICUT ST \ WISCONSIN ST | 1738100139000 | middleware_editor | ALL WAY | WISCONSIN ST intersection | - | 0 / 0 | - | - | - | - | - | 40771 | 104461200000 | -122.39859315 | 37.75368475 | - | 1738070400000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1487664660000 | CONNECTICUT ST | - | - | - | - | - | - |
| 23694 | N/A | Point | - | - | - | - | S233783 | CONNECTICUT ST: WISCONSIN ST | - | F | F | - | F | 28098000 | 28098000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WISCONSIN ST | WISCONSIN ST | 68368 | 68368 | 37.75368475 | -122.39859315 | CONNECTICUT ST \ WISCONSIN ST | CONNECTICUT ST \ WISCONSIN ST | 1738105875000 | middleware_editor | ALL WAY | WISCONSIN ST intersection | - | 0 / 0 | - | - | - | - | - | 40772 | 104374800000 | -122.39859315 | 37.75368475 | - | 1738074000000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 3IN IRON POST | IS | 1487664780000 | CONNECTICUT ST | - | - | - | - | - | - |
| 23695 | N/A | Point | - | - | - | - | S233784 | CONNECTICUT ST: WISCONSIN ST | - | F | F | - | F | 28098000 | 28098000 | - | - | SOUTH WEST CORNER | - | - | - | - | WISCONSIN ST | WISCONSIN ST | 68369 | 68369 | 37.75368475 | -122.39859315 | CONNECTICUT ST \ WISCONSIN ST | CONNECTICUT ST \ WISCONSIN ST | 1737487612000 | middleware_editor | ALL WAY | WISCONSIN ST intersection | - | X ST IS WISCONSIN | - | - | - | - | - | 40773 | 104374800000 | -122.39859315 | 37.75368475 | - | 1737448200000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 3IN IRON POST | IS | 1487665020000 | CONNECTICUT ST | - | - | - | - | - | - |
| 23696 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S242952 | 1400-1499 FAIRFAX AVE | 1400-1499 FAIRFAX AVE | F | F | - | F | 5392000 | 5392000 | - | - | SOUTH SIDE | - | - | - | - | MENDELL ST | MENDELL ST | 74108 | 74108 | 37.74076869 | -122.38621248 | - | - | 1710539427000 | MTA | NPRK VEH OVER 6 FT HIGH | MENDELL ST to NEWHALL ST (1400 - 1499) | - | 35`WEST | - | - | - | - | - | 40774 | 1426118400000 | -122.38621248 | 37.74076869 | - | 1518652800000 | - | D10 | - | PARKING | REG | R28D(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1518175200000 | FAIRFAX AVE | 1400 - 1499 FAIRFAX AVE | 1400 - 1499 FAIRFAX AVE | 1400 FAIRFAX AVE | - | NEWHALL ST | NEWHALL ST |
| 23697 | N/A | Point | 1 | 1 | 1400 - 1499 | LEFT ARROW | S242953 | 1400-1499 FAIRFAX AVE | 1400-1499 FAIRFAX AVE | F | F | - | F | 5392000 | 5392000 | - | - | NORTH SIDE | - | - | - | - | MENDELL ST | MENDELL ST | 74109 | 74109 | 37.74076869 | -122.38621248 | - | - | 1710539427000 | MTA | NPRK VEH OVER 6 FT HIGH | MENDELL ST to NEWHALL ST (1400 - 1499) | - | 100`EAST | - | - | - | - | - | 40775 | 1426118400000 | -122.38621248 | 37.74076869 | - | 1519084800000 | - | D10 | - | PARKING | REG | R28D(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1518175920000 | FAIRFAX AVE | 1400 - 1499 FAIRFAX AVE | 1400 - 1499 FAIRFAX AVE | 1400 FAIRFAX AVE | - | NEWHALL ST | NEWHALL ST |
| 23698 | N/A | Point | 1 | 1 | 100 - 199 | - | S242116 | 119-199 HUBBELL ST | 100-199 HUBBELL ST | F | F | - | F | 7064000 | 7064000 | - | - | WEST SIDE | - | - | - | - | 7TH ST | 07TH ST | 74122 | 74122 | 37.76708475 | -122.39759055 | - | - | 1713482674000 | middleware_editor | NPRK 12MN-6AM THUR STCL | 07TH ST to 16TH ST (100 - 199) | 120045899 | AT# 180 WOODEN POLE TO NEW 2INCH | - | - | - | - | - | 40776 | 1468368000000 | -122.39759055 | 37.76708475 | - | 1713453360000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0054 | 18X18 | SUP1 | 2IN IRON POST | IS | 1515418380000 | HUBBELL ST | 100 - 199 HUBBELL ST | 100 - 199 HUBBELL ST | 100 HUBBELL ST | - | 16TH ST | 16TH ST |
| 23699 | N/A | Point | - | - | - | - | S242405 | COLLINS ST: EUCLID AVE | - | T | T | - | F | 26912000 | 26912000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | COLLINS ST | COLLINS ST | 74123 | 74123 | 37.7844809 | -122.45013569 | EUCLID AVE \ COLLINS ST | EUCLID AVE \ COLLINS ST | 1715278413000 | middleware_editor | NO LEFT TURN (SYM) VEHICLES OVER 22 FEET | COLLINS ST intersection | - | - | - | - | - | - | - | 40777 | 1516362060000 | -122.45013569 | 37.7844809 | - | 1516320000000 | - | D2 | - | NO LEFT TURN | REG | R3-2(SF).0056 | 30X42 | SUP1 | LIGHT POLE | IS | 1516350960000 | EUCLID AVE | - | - | - | - | - | - |
| 23700 | N/A | Point | - | - | - | - | S242406 | COLLINS ST: EUCLID AVE | - | T | T | - | F | 26912000 | 26912000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | COLLINS ST | COLLINS ST | 74124 | 74124 | 37.7844809 | -122.45013569 | EUCLID AVE \ COLLINS ST | EUCLID AVE \ COLLINS ST | 1715278425000 | middleware_editor | NO LEFT TURN (SYM) VEHICLES OVER 22 FEET | COLLINS ST intersection | - | - | - | - | - | - | - | 40778 | 1516362180000 | -122.45013569 | 37.7844809 | - | 1516320000000 | - | D2 | - | NO LEFT TURN | REG | R3-2(SF).0056 | 30X42 | SUP1 | LIGHT POLE | IS | 1516351020000 | EUCLID AVE | - | - | - | - | - | - |
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