Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | qLegalStatus ▲ | qSpecies | qAddress | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PermitNotes |
|---|---|---|---|---|---|---|---|---|---|
| 1573 | 1573 | 9 | 148 | 1650 Valencia St | 17 | 1 | 1 | ||
| 2263 | 2263 | 9 | 25 | 5490X 03rd St | 11 | 1 | 2 | ||
| 4546 | 4546 | 9 | 184 | 1701 Franklin St | 1 | 1 | 1 | ||
| 7798 | 7798 | 9 | 30 | 555 Battery St | 1 | 1 | 2 | ||
| 13675 | 13675 | 9 | 5 | 1700X Quesada Ave | 11 | 1 | 2 | ||
| 16525 | 16525 | 9 | 72 | 1700X Quesada Ave | 11 | 1 | 2 | ||
| 16768 | 16768 | 9 | 100 | 1700X Quesada Ave | 11 | 1 | 2 | ||
| 16811 | 16811 | 9 | 100 | 1700X Quesada Ave | 11 | 1 | 2 | ||
| 18163 | 18163 | 9 | 292 | 500X Cortland Ave | 1 | 1 | 3 | ||
| 20653 | 20653 | 9 | 103 | 1661X Octavia St | 1 | 1 | 2 | ||
| 21449 | 21449 | 9 | 292 | 500X Cortland Ave | 1 | 1 | 3 | ||
| 22308 | 22308 | 9 | 24 | 46 Cook St | 7 | 1 | 1 | Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 | |
| 22823 | 22823 | 9 | 100 | 1700X Quesada Ave | 3 | 1 | 2 | ||
| 22824 | 22824 | 9 | 100 | 1700X Quesada Ave | 22 | 1 | 2 | ||
| 22825 | 22825 | 9 | 100 | 1700X Quesada Ave | 3 | 1 | 2 | ||
| 22828 | 22828 | 9 | 100 | 1700X Quesada Ave | 3 | 1 | 2 | ||
| 22831 | 22831 | 9 | 100 | 1700X Quesada Ave | 3 | 1 | 2 | ||
| 22832 | 22832 | 9 | 100 | 1700X Quesada Ave | 3 | 1 | 2 | ||
| 22833 | 22833 | 9 | 100 | 1700X Quesada Ave | 3 | 1 | 2 | ||
| 22838 | 22838 | 9 | 100 | 1700X Quesada Ave | 3 | 1 | 2 | ||
| 22839 | 22839 | 9 | 100 | 1700X Quesada Ave | 3 | 1 | 2 | ||
| 35608 | 35608 | 9 | 100 | 1700x Quesada Ave | 3 | 1 | 2 | ||
| 39870 | 39870 | 9 | 100 | 1700x Quesada Ave | 3 | 1 | 2 | ||
| 54354 | 54354 | 9 | 100 | 1700x Quesada Ave | 3 | 1 | 2 | ||
| 58702 | 58702 | 9 | 100 | 1700x Quesada Ave | 3 | 1 | 2 | ||
| 65300 | 65300 | 9 | 180 | 4124 23rd St | 13 | 1 | 1 | ||
| 78801 | 78801 | 9 | 103 | 1661X Octavia St | 1 | 1 | 2 | ||
| 80756 | 80756 | 9 | 103 | 1661X Octavia St | 1 | 1 | 2 | ||
| 90443 | 90443 | 9 | 338 | 730 28th Ave | 13 | 1 | 1 | ||
| 94802 | 94802 | 9 | 100 | 1700X Quesada Ave | 11 | 1 | 2 | ||
| 97410 | 97410 | 9 | 148 | 1580 Valencia St | 7 | 1 | 1 | ||
| 101071 | 101071 | 9 | 480 | 3440X Folsom St | 7 | 1 | 3 | ||
| 114869 | 114869 | 9 | 24 | 46 COOK ST | 13 | 1 | 1 | Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 | |
| 116419 | 116419 | 9 | 103 | 1661X Octavia St | 1 | 1 | 2 | ||
| 121641 | 121641 | 9 | 447 | 1221 Stanyan St | 1 | 1 | 1 | Permit Number 25220 | |
| 124625 | 124625 | 9 | 47 | 2626 Vallejo St | 13 | 1 | 1 | ||
| 126137 | 126137 | 9 | 180 | 20-28 ROSEMONT PL | 13 | 1 | 1 | ||
| 126390 | 126390 | 9 | 103 | 1661X Octavia St | 1 | 1 | 2 | ||
| 138324 | 138324 | 9 | 103 | 1661X Octavia St | 1 | 1 | 2 | ||
| 1138 | 1138 | 8 | 21 | 2504 Jackson St | 1 | 1 | 1 | Permit Number 769379 | |
| 1723 | 1723 | 8 | 44 | 2570 Jackson St | 1 | 1 | 1 | ||
| 3768 | 3768 | 8 | 44 | 2036X 15th St | 2 | 1 | 1 | ||
| 3773 | 3773 | 8 | 44 | 2036X 15th St | 2 | 1 | 1 | ||
| 3775 | 3775 | 8 | 44 | 2036X 15th St | 2 | 1 | 1 | ||
| 3776 | 3776 | 8 | 44 | 2036X 15th St | 2 | 1 | 1 | ||
| 3780 | 3780 | 8 | 44 | 2036X 15th St | 2 | 1 | 1 | ||
| 3781 | 3781 | 8 | 44 | 2036X 15th St | 2 | 1 | 1 | ||
| 3791 | 3791 | 8 | 44 | 2036X 15th St | 2 | 1 | 1 | ||
| 3795 | 3795 | 8 | 44 | 2036X 15th St | 2 | 1 | 1 | ||
| 8183 | 8183 | 8 | 51 | 2646 Greenwich St | 1 | 1 | 1 | ||
| 8240 | 8240 | 8 | 51 | 41 Toledo Way | 1 | 1 | 1 | Permit Number 773012 | |
| 8965 | 8965 | 8 | 15 | 2405x Scott St | 1 | 1 | 1 | Permit Number 770079 | |
| 9707 | 9707 | 8 | 51 | 900X JESSIE ST | 1 | 1 | 1 | ||
| 11899 | 11899 | 8 | 9 | 1213 Silver Ave | 1 | 1 | 1 | ||
| 12209 | 12209 | 8 | 172 | 414 Somerset St | 1 | 1 | 1 | ||
| 12972 | 12972 | 8 | 44 | 443 Madrid St | 1 | 1 | 1 | Permit Number 775730 | |
| 13395 | 13395 | 8 | 172 | 2300x Mariposa St | 1 | 1 | 1 | ||
| 13845 | 13845 | 8 | 49 | 928 Toland St | 1 | 1 | 1 | Permit Number 774325 | |
| 13873 | 13873 | 8 | 172 | 2300x Mariposa St | 1 | 1 | 1 | ||
| 13959 | 13959 | 8 | 246 | 2300x Mariposa St | 1 | 1 | 1 | ||
| 14083 | 14083 | 8 | 87 | 696 Pennsylvania Ave | 1 | 1 | 1 | ||
| 14294 | 14294 | 8 | 172 | 2300x Mariposa St | 1 | 1 | 1 | ||
| 14802 | 14802 | 8 | 76 | 54 Whitney Young Cir | 1 | 1 | 1 | this is original dpw basin record. | |
| 15089 | 15089 | 8 | 49 | 928 Toland St | 1 | 1 | 1 | Permit Number 774325 | |
| 15363 | 15363 | 8 | 172 | 2300x Mariposa St | 1 | 1 | 1 | ||
| 15752 | 15752 | 8 | 49 | 928 Toland St | 1 | 1 | 1 | Permit Number 774325 | |
| 15833 | 15833 | 8 | 49 | 928 Toland St | 1 | 1 | 1 | Permit Number 774325 | |
| 16141 | 16141 | 8 | 26 | 49 Grace St | 1 | 1 | 1 | Permit Number 770598 | |
| 16786 | 16786 | 8 | 298 | 2300x Mariposa St | 1 | 1 | 1 | ||
| 18013 | 18013 | 8 | 147 | 400x CLEMENTINA ST | 1 | 1 | 1 | ||
| 18623 | 18623 | 8 | 49 | 2203x NEWCOMB AVE | 1 | 1 | 1 | Permit Number 774325 | |
| 18811 | 18811 | 8 | 26 | 64 Sanchez St | 1 | 1 | 1 | Permit Number 774356 | |
| 18918 | 18918 | 8 | 44 | 2036x 15TH ST | 1 | 1 | 1 | ||
| 19435 | 19435 | 8 | 2 | 690 Monterey Blvd | 1 | 1 | 1 | ||
| 25738 | 25738 | 8 | 12 | 858 34th Ave | 1 | 1 | 1 | Permit Number 767389 | |
| 27410 | 27410 | 8 | 87 | 696 Pennsylvania Ave | 1 | 1 | 1 | ||
| 29879 | 29879 | 8 | 138 | 1079 Le Conte Ave | 1 | 1 | 1 | Permit Number 768080 | |
| 33388 | 33388 | 8 | 250 | 1540 Jones St | 1 | 1 | 1 | Permit Number 768649 | |
| 42795 | 42795 | 8 | 250 | 1540 Jones St | 1 | 1 | 1 | Permit Number 768649 | |
| 44012 | 44012 | 8 | 21 | 2250 Vallejo St | 1 | 1 | 1 | Permit Number 770124 | |
| 50489 | 50489 | 8 | 11 | 1036X Mission St | 1 | 1 | 1 | ||
| 51328 | 51328 | 8 | 11 | 260 05th St | 1 | 1 | 1 | Permit Number 773313 | |
| 53719 | 53719 | 8 | 21 | 1840 Washington St | 1 | 1 | 1 | Permit Number 768068 | |
| 62298 | 62298 | 8 | 21 | 2250 Vallejo St | 1 | 1 | 1 | Permit Number 770124 | |
| 62948 | 62948 | 8 | 250 | 1540 Jones St | 1 | 1 | 1 | Permit Number 768649 | |
| 64007 | 64007 | 8 | 21 | 1456 Chestnut St | 1 | 1 | 1 | Permit Number 768914 | |
| 71351 | 71351 | 8 | 15 | 1401X California St | 1 | 1 | 1 | Permit Number 769132 | |
| 72331 | 72331 | 8 | 138 | 1079 Le Conte Ave | 1 | 1 | 1 | Permit Number 768080 | |
| 73660 | 73660 | 8 | 138 | 1079 Le Conte Ave | 1 | 1 | 1 | Permit Number 768080 | |
| 77374 | 77374 | 8 | 147 | 400x CLEMENTINA ST | 1 | 1 | 1 | ||
| 77418 | 77418 | 8 | 21 | 54 COMMONWEALTH AVE | 1 | 1 | 1 | ||
| 77589 | 77589 | 8 | 58 | 440 29th St | 1 | 1 | 1 | ||
| 77766 | 77766 | 8 | 11 | 260 05th St | 1 | 1 | 1 | Permit Number 773313 | |
| 77847 | 77847 | 8 | 8 | 890X Sansome St | 1 | 1 | 1 | ||
| 78583 | 78583 | 8 | 246 | 300 Mangels Ave | 9 | 1 | 1 | Permit Number 768637 | |
| 78687 | 78687 | 8 | 62 | 45 Belcher St | 1 | 1 | 1 | ||
| 79039 | 79039 | 8 | 406 | 3534 24th St | 1 | 1 | 1 | ||
| 79684 | 79684 | 8 | 15 | 2401x SCOTT ST | 1 | 1 | 1 | Permit Number 770079 | |
| 79719 | 79719 | 8 | 48 | 3400x WAWONA ST | 5 | 1 | 1 | ||
| 80528 | 80528 | 8 | 120 | 101x FREMONT ST | 1 | 1 | 1 |
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "Street_Tree_List_fts" USING FTS4 ("qLegalStatus", "qSpecies", "qAddress", "qSiteInfo", "PlantType", "qCaretaker", "qCareAssistant", "PermitNotes", content="Street_Tree_List");