Street_Tree_List_fts

Data source: data.sfgov.org

189,144 rows sorted by qCareAssistant descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid qLegalStatus qSpecies qAddress qSiteInfo PlantType qCaretaker qCareAssistant ▲ PermitNotes
116973 116973 2 17 315X PACIFIC AVE 1 1 1 15  
111940 111940 2 2 1601X NEWCOMB AVE 1 1 16 14 Permit Number 770204
99848 99848 2 17 100X ASHBURY ST 1 1 10 13  
121101 121101 2 22 100X ASHBURY ST 1 1 10 13  
125707 125707 2 17 100X ASHBURY ST 1 1 10 13  
126853 126853 2 11 100X ASHBURY ST 1 1 10 13  
144922 144922 2 22 100X ASHBURY ST 1 1 10 13  
62495 62495 2 12 199X JULES AVE 1 1 1 12  
80969 80969 1 49 361 Elsie St 1 1 1 12 Permit Number 774685
112534 112534 1 120 1969 17th Ave 1 1 1 12 Permit Number 773668
112977 112977 2 12 199X JULES AVE 1 1 1 12  
117298 117298 1 13 565 Banks St 1 1 1 12 Permit Number 772986
50491 50491 2 17 2400X 25th Ave 1 2 1 11 Permit Number 773973
80890 80890 2 19 1798X Washington St 5 1 1 11  
92163 92163 2 19 1798X Washington St 5 1 1 11  
97433 97433 2 17 2400X 25th Ave 1 2 1 11 Permit Number 773973
98097 98097 2 19 1798X Washington St 5 1 1 11  
105668 105668 2 19 1798X Washington St 5 1 1 11  
112717 112717 2 19 1798X Washington St 5 1 1 11  
120202 120202 2 43 1990X Laguna St 1 1 1 11  
121707 121707 2 19 1798X Washington St 5 1 1 11  
136121 136121 2 44 2728 Union St 1 1 1 11  
143269 143269 2 43 1990X Laguna St 1 1 1 11  
43480 43480 2 3 301x OCEAN AVE 5 1 10 10  
44757 44757 2 21 800 Folsom St 1 1 1 10 Permit Number 770959
51360 51360 2 36 419X 18th Ave 1 1 10 10  
90733 90733 2 21 250 04th St 1 1 1 10 Permit Number 770961
95314 95314 2 21 266-286X 04th St 1 1 1 10 Permit Number 770959
101265 101265 2 256 419X 18TH AVE 1 1 10 10  
107894 107894 2 3 301x OCEAN AVE 5 1 10 10  
108530 108530 2 19 419X 18TH AVE 1 1 10 10  
113498 113498 2 21 250 04th St 1 1 1 10 Permit Number 770961
115819 115819 2 19 419X 18TH AVE 1 1 10 10  
121695 121695 2 3 301x OCEAN AVE 5 1 10 10  
125272 125272 2 20 419X 18TH AVE 1 1 10 10  
132930 132930 2 60 419X 18th Ave 1 1 10 10  
140020 140020 2 21 266-286X 04th St 1 1 1 10 Permit Number 770959
144668 144668 2 19 419X 18TH AVE 1 1 10 10  
145040 145040 2 21 250 04th St 1 1 1 10 Permit Number 770961
151790 151790 2 21 800 Folsom St 1 1 1 10 Permit Number 770959
164897 164897 2 21 800 Folsom St 1 1 1 10 Permit Number 770959
27975 27975 2 340 418 19th Ave 1 1 1 9  
100855 100855 7 103 934 BRANNAN ST 13 1 1 9  
18491 18491 3 7 3722 Cabrillo St 1 1 2 8  
19788 19788 3 7 3730 Cabrillo St 1 1 2 8  
21238 21238 3 7 3547 Cabrillo St 1 1 2 8  
51131 51131 3 12 2730 Cabrillo St 1 1 2 8  
51442 51442 3 37 4300 Anza St 1 1 2 8  
65723 65723 3 17 3026 Balboa St 1 1 2 8  
66010 66010 3 80 578 25th Ave 1 1 2 8  
76161 76161 3 1 3350 Cabrillo St 1 1 2 8  
77531 77531 3 12 2626 Cabrillo St 1 1 2 8  
77588 77588 3 1 3350 Cabrillo St 1 1 2 8  
77805 77805 3 12 3645X Anza St 1 1 2 8  
78169 78169 3 460 600 25th Ave 1 1 2 8  
79444 79444 3 141 4801X Anza St 1 1 2 8  
80593 80593 3 141 5500 Anza St 1 1 2 8  
81324 81324 3 180 4899X Balboa St 1 1 2 8  
82136 82136 3 1 3636 Cabrillo St 1 1 2 8  
82540 82540 3 131 999 South Van Ness Ave 1 1 2 8  
83123 83123 3 7 4125 Cabrillo St 1 1 2 8  
83550 83550 3 9 379 25th Ave 1 1 2 8  
84396 84396 3 483 4332 Cabrillo St 1 1 2 8  
84596 84596 3 150 2500X Harrison St 1 1 2 8  
84637 84637 3 223 1935 Cabrillo St 1 1 2 8  
84778 84778 3 7 3399X Cabrillo St 1 1 2 8  
85635 85635 3 131 387 South Van Ness Ave 1 1 2 8  
86241 86241 3 211 4799X Cabrillo St 1 1 2 8  
86271 86271 3 1 3700 Cabrillo St 1 1 2 8  
89759 89759 3 361 4801 Balboa St 1 1 2 8  
90226 90226 3 1 3300X Cabrillo St 1 1 2 8  
90847 90847 3 80 705 25th Ave 1 1 2 8  
91114 91114 3 17 3450 Cabrillo St 1 1 2 8 Permit Number 776853
91386 91386 3 141 5250X Anza St 1 1 2 8  
91876 91876 3 2 4501X Balboa St 1 1 2 8  
92040 92040 3 12 3645X Anza St 1 1 2 8  
92270 92270 3 483 4530 Cabrillo St 1 1 2 8  
92911 92911 3 180 4899X Balboa St 1 1 2 8  
94469 94469 3 1 3400 Cabrillo St 1 1 2 8  
94921 94921 3 1 3350 Cabrillo St 1 1 2 8  
95614 95614 3 2 3900 Balboa St 1 1 2 8  
95754 95754 3 12 3849X Anza St 1 1 2 8  
95891 95891 3 211 4400 Cabrillo St 1 1 2 8  
96444 96444 3 483 4799X Cabrillo St 1 1 2 8  
96504 96504 3 1 3326 Cabrillo St 1 1 2 8  
96755 96755 3 223 2045 Cabrillo St 1 1 2 8  
96970 96970 3 2 3850X Balboa St 1 1 2 8  
97317 97317 3 12 3645X Anza St 1 1 2 8  
97676 97676 3 483 4400 Cabrillo St 1 1 2 8  
97679 97679 3 18 2450 27th Ave 1 1 2 8  
98076 98076 3 141 5500 Anza St 1 1 2 8  
98157 98157 3 51 2349X Balboa St 1 1 2 8  
99105 99105 3 7 4130 Cabrillo St 1 1 2 8  
99421 99421 3 361 4545X Balboa St 1 1 2 8  
99422 99422 3 80 555 25th Ave 1 1 2 8  
99844 99844 3 49 2558 Balboa St 1 1 2 8  
100138 100138 3 7 3750x CABRILLO ST 1 1 2 8  
101073 101073 3 361 4800X Balboa St 1 1 2 8  
101411 101411 3 141 4700X Anza St 1 1 2 8  
101873 101873 3 141 5000X Anza St 1 1 2 8  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIRTUAL TABLE "Street_Tree_List_fts" USING FTS4 ("qLegalStatus", "qSpecies", "qAddress", "qSiteInfo", "PlantType", "qCaretaker", "qCareAssistant", "PermitNotes", content="Street_Tree_List");
Powered by Datasette · Query took 1563.425ms · Data source: data.sfgov.org