Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | qLegalStatus | qSpecies | qAddress | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PermitNotes |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 1 | 1 | 501X Baker St | 1 | 1 | 1 | Permit Number 25401 | |
| 4 | 4 | 2 | 4 | 920 Kirkham St | 1 | 1 | 1 | ||
| 6 | 6 | 1 | 1 | 501X Baker St | 1 | 1 | 1 | ||
| 8 | 8 | 1 | 6 | 300x Hickory St | 1 | 1 | 1 | ||
| 9 | 9 | 2 | 7 | 920 Kirkham St | 1 | 1 | 1 | ||
| 10 | 10 | 1 | 8 | 301x Hickory St | 1 | 1 | 1 | ||
| 11 | 11 | 1 | 6 | 300x Hickory St | 1 | 1 | 1 | ||
| 12 | 12 | 1 | 6 | 300x Hickory St | 1 | 1 | 1 | ||
| 13 | 13 | 1 | 6 | 300x Hickory St | 1 | 1 | 1 | ||
| 16 | 16 | 1 | 6 | 300x Hickory St | 1 | 1 | 1 | ||
| 17 | 17 | 2 | 10 | 730 11th Ave | 1 | 1 | 1 | Permit Number 779614 | |
| 18 | 18 | 2 | 11 | 168 Cervantes Blvd | 1 | 1 | 1 | Permit Number 767919 | |
| 19 | 19 | 2 | 12 | 1471 28th Ave | 1 | 1 | 1 | ||
| 22 | 22 | 2 | 7 | 910 Kirkham St | 1 | 1 | 1 | ||
| 23 | 23 | 1 | 14 | 1555 40th Ave | 1 | 1 | 1 | Permit Number 777142 | |
| 24 | 24 | 3 | 11 | 5280 03rd St | 1 | 1 | 2 | ||
| 25 | 25 | 3 | 15 | 2975 Van Ness Ave | 1 | 1 | 2 | ||
| 26 | 26 | 1 | 16 | 4200 23rd St | 1 | 1 | 1 | Permit Number 43111 | |
| 28 | 28 | 1 | 15 | 2741 Taylor St | 1 | 1 | 1 | ||
| 31 | 31 | 1 | 5 | 1001 Turk St | 1 | 1 | 3 | ||
| 32 | 32 | 3 | 11 | 1359 Hudson Ave | 1 | 1 | 2 | ||
| 33 | 33 | 1 | 15 | 1545 California St | 1 | 1 | 1 | ||
| 34 | 34 | 2 | 18 | 20 Lily St | 1 | 1 | 1 | ||
| 36 | 36 | 3 | 15 | 2X Market St | 1 | 1 | 2 | ||
| 38 | 38 | 2 | 11 | 1390 Mission St | 1 | 1 | 1 | ||
| 39 | 39 | 1 | 11 | 101 Cargo Way | 1 | 1 | 1 | ||
| 40 | 40 | 2 | 20 | 1 Newburg St | 1 | 1 | 1 | ||
| 41 | 41 | 2 | 11 | 1390 Mission St | 1 | 1 | 1 | ||
| 42 | 42 | 3 | 21 | 3014 Sacramento St | 1 | 1 | 1 | Permit Number 54020 | |
| 43 | 43 | 2 | 20 | 1 Newburg St | 1 | 1 | 1 | ||
| 45 | 45 | 1 | 2 | 3201 California St | 1 | 1 | 1 | ||
| 46 | 46 | 3 | 22 | 1737-1795 Post St | 1 | 1 | 2 | ||
| 47 | 47 | 3 | 23 | 150 Otis St | 1 | 1 | 2 | ||
| 48 | 48 | 3 | 11 | 201X Cargo Way | 1 | 1 | 2 | ||
| 51 | 51 | 1 | 17 | 1 | 1 | 1 | Permit Number 20649 | ||
| 52 | 52 | 2 | 24 | 1021 Noe St | 1 | 1 | 1 | ||
| 53 | 53 | 2 | 25 | 1 Baker St | 1 | 1 | 1 | ||
| 54 | 54 | 4 | 26 | 1388x Minna St | 1 | 1 | 1 | ||
| 55 | 55 | 1 | 15 | 1700 California St | 1 | 1 | 1 | ||
| 56 | 56 | 1 | 26 | 988 Fulton St | 1 | 1 | 1 | ||
| 57 | 57 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 58 | 58 | 1 | 5 | 1255 Columbus Ave | 1 | 1 | 1 | ||
| 59 | 59 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 60 | 60 | 4 | 26 | 1388x Minna St | 1 | 1 | 1 | ||
| 62 | 62 | 2 | 9 | 10 12th St | 1 | 1 | 1 | ||
| 63 | 63 | 2 | 28 | 1 Newburg St | 1 | 1 | 1 | Permit Number 779491 | |
| 64 | 64 | 2 | 11 | 1614 Broderick St | 1 | 1 | 1 | ||
| 66 | 66 | 2 | 20 | 1 Newburg St | 1 | 1 | 1 | ||
| 67 | 67 | 1 | 29 | 520 Jersey St | 1 | 1 | 1 | Permit Number 18521 | |
| 68 | 68 | 2 | 25 | 1 Baker St | 1 | 1 | 1 | ||
| 69 | 69 | 3 | 30 | 630 Sansome St | 1 | 1 | 2 | ||
| 70 | 70 | 4 | 26 | 1388x Minna St | 1 | 1 | 1 | ||
| 71 | 71 | 2 | 18 | 270 Trumbull St | 1 | 1 | 1 | ||
| 72 | 72 | 3 | 15 | 729 Grove St | 1 | 1 | 2 | ||
| 73 | 73 | 1 | 18 | 1051 Bush St | 1 | 1 | 1 | 1 | Permit Number 28361 |
| 74 | 74 | 3 | 5 | 2175X Palou Ave | 1 | 1 | 2 | ||
| 75 | 75 | 1 | 15 | 729 GROVE ST | 1 | 1 | 1 | ||
| 77 | 77 | 1 | 17 | 145 Missouri St | 1 | 1 | 1 | 1 | Permit Number 779552 |
| 80 | 80 | 1 | 32 | 4425 18th St | 1 | 1 | 1 | Permit Number 47310 | |
| 81 | 81 | 2 | 28 | 55 Homestead St | 1 | 1 | 1 | Permit Number 778991 | |
| 83 | 83 | 2 | 21 | 3660 Jackson St | 1 | 1 | 1 | Permit Number 779583 | |
| 84 | 84 | 1 | 33 | 1 | 1 | 1 | Permit Number 39461 | ||
| 85 | 85 | 1 | 5 | 1001 Turk St | 1 | 1 | 3 | ||
| 87 | 87 | 1 | 32 | 1500 Hyde St | 1 | 1 | 1 | ||
| 88 | 88 | 2 | 2 | 4115 Kirkham St | 1 | 1 | 1 | ||
| 89 | 89 | 1 | 17 | 1493 Hudson Ave | 1 | 1 | 1 | ||
| 92 | 92 | 3 | 35 | 2X Frank Norris St | 1 | 1 | 4 | 2 | |
| 94 | 94 | 2 | 36 | 1051 Ingalls St | 1 | 1 | 1 | ||
| 97 | 97 | 3 | 26 | 1245 Divisadero St | 1 | 1 | 2 | ||
| 98 | 98 | 2 | 26 | 1384X GROVE ST | 1 | 1 | 1 | ||
| 99 | 99 | 1 | 9 | 2247 Franklin St | 1 | 1 | 1 | ||
| 100 | 100 | 1 | 37 | 2200 Lyon St | 1 | 1 | 1 | Permit Number 773028 | |
| 101 | 101 | 2 | 11 | 1399X Mission St | 1 | 1 | 1 | ||
| 102 | 102 | 5 | 26 | 1384X Grove St | 1 | 1 | 1 | Permit Number 767782 | |
| 103 | 103 | 1 | 38 | 1 | 1 | 1 | Permit Number 776915 | ||
| 104 | 104 | 3 | 39 | 1170 Ingalls St | 1 | 1 | 2 | ||
| 105 | 105 | 3 | 5 | 1315 Ellis St | 1 | 1 | 2 | ||
| 106 | 106 | 3 | 36 | 906 Hayes St | 1 | 1 | 2 | ||
| 107 | 107 | 2 | 26 | 1384X GROVE ST | 1 | 1 | 1 | ||
| 108 | 108 | 2 | 11 | 1399X Mission St | 1 | 1 | 1 | ||
| 109 | 109 | 3 | 40 | 1800X Pine St | 1 | 1 | 2 | ||
| 110 | 110 | 2 | 2 | 1824 Noriega St | 1 | 1 | 1 | ||
| 111 | 111 | 1 | 15 | 400X Franklin St | 1 | 1 | 1 | ||
| 112 | 112 | 3 | 11 | 1800X Pine St | 1 | 1 | 2 | ||
| 113 | 113 | 1 | 41 | 1341 42nd Ave | 1 | 1 | 1 | ||
| 115 | 115 | 1 | 26 | 700 Fell St | 1 | 1 | 1 | ||
| 116 | 116 | 1 | 32 | 220 Richardson Ave | 1 | 1 | 1 | ||
| 117 | 117 | 3 | 42 | 929 Valencia St | 1 | 1 | 2 | Permit Number 24134 | |
| 119 | 119 | 3 | 43 | 175X Otis St | 1 | 1 | 2 | ||
| 120 | 120 | 1 | 44 | 2123 Pierce St | 1 | 1 | 1 | Permit Number 774924 | |
| 121 | 121 | 1 | 2 | 1201 Palou Ave | 1 | 1 | 1 | 1 | Permit Number 19293 |
| 122 | 122 | 1 | 45 | 1341 42nd Ave | 1 | 1 | 1 | ||
| 123 | 123 | 3 | 41 | 2621 Sacramento St | 1 | 1 | 2 | ||
| 124 | 124 | 3 | 2 | 20X Sunset Blvd | 1 | 1 | 2 | ||
| 125 | 125 | 2 | 22 | 151X Octavia St Frontage West | 1 | 1 | 1 | ||
| 126 | 126 | 3 | 11 | 700 Valencia St | 1 | 1 | 2 | ||
| 127 | 127 | 3 | 46 | 2840 Pine St | 1 | 1 | 2 | ||
| 129 | 129 | 3 | 47 | 262X Sunset Blvd | 1 | 1 | 2 | ||
| 130 | 130 | 1 | 22 | 2041 Hayes St | 1 | 1 | 1 | 1 | Permit Number 30161 |
| 133 | 133 | 2 | 23 | 742 Myra Way | 1 | 1 | 1 | Permit Number 779535 |
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");