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 | |
2 | 2 | 2 | 2 | 940 Elizabeth St | 2 | 1 | 1 | Permit Number 779625 | |
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 | ||
14 | 14 | 4 | 9 | 43 Lafayette St | 4 | 1 | 1 | Permit Number 772992 | |
15 | 15 | 4 | 9 | 43 Lafayette St | 4 | 1 | 1 | Permit Number 772992 | |
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 | ||
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 | ||
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 | |
27 | 27 | 5 | 17 | 342 Scott St | 2 | 1 | 1 | Permit Number 779666 | |
28 | 28 | 1 | 15 | 2741 Taylor St | 1 | 1 | 1 | ||
29 | 29 | 3 | 5 | 1300 Evans Ave | 4 | 1 | 2 | ||
30 | 30 | 4 | 9 | 43 Lafayette St | 4 | 1 | 1 | Permit Number 772992 | |
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 | ||
35 | 35 | 2 | 1 | 2562 26th Ave | 2 | 1 | 1 | Permit Number 779639 | |
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 | ||
42 | 42 | 3 | 21 | 3014 Sacramento St | 1 | 1 | 1 | Permit Number 54020 | |
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 | ||
50 | 50 | 5 | 17 | 632 HAYES ST | 2 | 1 | 1 | Permit Number 779650 | |
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 | ||
61 | 61 | 2 | 27 | 1 Newburg St | 6 | 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 | ||
65 | 65 | 2 | 19 | 1 Newburg St | 6 | 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 | ||
76 | 76 | 1 | 31 | 300 Duboce Ave | 7 | 1 | 1 | Permit Number 43693 | |
77 | 77 | 1 | 17 | 145 Missouri St | 1 | 1 | 1 | 1 | Permit Number 779552 |
78 | 78 | 6 | 3 | 900X 14th St | 7 | 1 | 1 | ||
79 | 79 | 2 | 2 | 2000X Market St | 5 | 1 | 1 | ||
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 | |
82 | 82 | 1 | 31 | 300 Duboce Ave | 7 | 1 | 1 | Permit Number 43693 | |
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 | ||
86 | 86 | 6 | 34 | 4357x Mission St | 7 | 1 | 1 | Permit Number 774415 | |
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 | ||
90 | 90 | 1 | 31 | 300 Duboce Ave | 7 | 1 | 1 | Permit Number 43693 | |
91 | 91 | 1 | 31 | 300 Duboce Ave | 7 | 1 | 1 | Permit Number 43693 | |
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 | ||
95 | 95 | 6 | 3 | 900X 14th St | 7 | 1 | 1 | Permit Number 779570 | |
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 | ||
100 | 100 | 1 | 37 | 2200 Lyon St | 1 | 1 | 1 | Permit Number 773028 |
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");