Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | qLegalStatus | qSpecies | qAddress | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PermitNotes ▼ |
---|---|---|---|---|---|---|---|---|---|
3 | 3 | 3 | 3 | 495X Lakeshore Dr | 3 | 1 | 2 | ||
4 | 4 | 2 | 4 | 920 Kirkham St | 1 | 1 | 1 | ||
5 | 5 | 3 | 5 | 1501 Evans Ave | 4 | 1 | 2 | ||
6 | 6 | 1 | 1 | 501X Baker St | 1 | 1 | 1 | ||
7 | 7 | 3 | 5 | 1301 Evans Ave | 4 | 1 | 2 | ||
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 | ||
19 | 19 | 2 | 12 | 1471 28th Ave | 1 | 1 | 1 | ||
20 | 20 | 4 | 13 | 1043 Minna St | 5 | 1 | 1 | ||
21 | 21 | 4 | 13 | 1043 Minna St | 5 | 1 | 1 | ||
22 | 22 | 2 | 7 | 910 Kirkham St | 1 | 1 | 1 | ||
24 | 24 | 3 | 11 | 5280 03rd St | 1 | 1 | 2 | ||
25 | 25 | 3 | 15 | 2975 Van Ness Ave | 1 | 1 | 2 | ||
28 | 28 | 1 | 15 | 2741 Taylor St | 1 | 1 | 1 | ||
29 | 29 | 3 | 5 | 1300 Evans Ave | 4 | 1 | 2 | ||
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 | ||
37 | 37 | 2 | 19 | 1 Newburg St | 6 | 1 | 1 | ||
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 | ||
43 | 43 | 2 | 20 | 1 Newburg St | 1 | 1 | 1 | ||
44 | 44 | 2 | 19 | 1 Newburg St | 6 | 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 | ||
49 | 49 | 2 | 19 | 3042 Steiner St | 5 | 1 | 1 | ||
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 | ||
58 | 58 | 1 | 5 | 1255 Columbus Ave | 1 | 1 | 1 | ||
60 | 60 | 4 | 26 | 1388x Minna St | 1 | 1 | 1 | ||
61 | 61 | 2 | 27 | 1 Newburg St | 6 | 1 | 1 | ||
62 | 62 | 2 | 9 | 10 12th St | 1 | 1 | 1 | ||
64 | 64 | 2 | 11 | 1614 Broderick St | 1 | 1 | 1 | ||
65 | 65 | 2 | 19 | 1 Newburg St | 6 | 1 | 1 | ||
66 | 66 | 2 | 20 | 1 Newburg St | 1 | 1 | 1 | ||
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 | ||
74 | 74 | 3 | 5 | 2175X Palou Ave | 1 | 1 | 2 | ||
75 | 75 | 1 | 15 | 729 GROVE ST | 1 | 1 | 1 | ||
78 | 78 | 6 | 3 | 900X 14th St | 7 | 1 | 1 | ||
79 | 79 | 2 | 2 | 2000X Market St | 5 | 1 | 1 | ||
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 | |
93 | 93 | 6 | 3 | 900X 14th St | 7 | 1 | 1 | ||
94 | 94 | 2 | 36 | 1051 Ingalls St | 1 | 1 | 1 | ||
96 | 96 | 6 | 3 | 900X 14th St | 8 | 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 | ||
101 | 101 | 2 | 11 | 1399X Mission St | 1 | 1 | 1 | ||
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 | ||
114 | 114 | 6 | 1 | 399X Townsend St | 5 | 1 | 1 | ||
115 | 115 | 1 | 26 | 700 Fell St | 1 | 1 | 1 | ||
116 | 116 | 1 | 32 | 220 Richardson Ave | 1 | 1 | 1 | ||
118 | 118 | 6 | 1 | 399X Townsend St | 5 | 1 | 1 | ||
119 | 119 | 3 | 43 | 175X Otis St | 1 | 1 | 2 | ||
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 | ||
128 | 128 | 2 | 16 | 115 Beverly St | 9 | 1 | 1 | ||
129 | 129 | 3 | 47 | 262X Sunset Blvd | 1 | 1 | 2 | ||
131 | 131 | 3 | 18 | 100 Octavia St | 4 | 1 | 2 | ||
132 | 132 | 1 | 44 | 270 Brannan St | 5 | 1 | 1 | ||
135 | 135 | 3 | 18 | 100 Octavia St | 4 | 1 | 2 | ||
137 | 137 | 3 | 11 | 700 Valencia St | 1 | 1 | 2 | ||
139 | 139 | 4 | 44 | 270 Brannan St | 5 | 1 | 1 | ||
140 | 140 | 3 | 2 | 1916 Ellis St | 1 | 1 | 2 | ||
141 | 141 | 3 | 48 | 1396 47th Ave | 1 | 1 | 2 |
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");