Street_Tree_List_fts

Data source: data.sfgov.org

189,144 rows sorted by qLegalStatus

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid qLegalStatus ▼ qSpecies qAddress qSiteInfo PlantType qCaretaker qCareAssistant PermitNotes
10187 10187   17 410 Hearst Ave 1 1 1   Permit Number 774920
10251 10251   17 231 Stratford Dr 9 1 1   Permit Number 779366
20491 20491   52 2889 24th St 1 1 2 3 under 3yr maintenance agreement. ends on 4/13/2007
25407 25407   17 211 Maynard St 8 2 1    
42741 42741   18 3390 Cesar Chavez St 1 1 2    
61148 61148   41 1250 Haight St 1 1 2 3 Under 3 yr maintenance agreement. Ends 7/27/2010.
79071 79071   17 27 Hartford St 8 2 1    
79402 79402   5 466 Gonzalez Dr 2 1 1    
80888 80888   6 598X Alemany Blvd 1 1 2    
82777 82777   127 360Y12 Valencia St 1 1 2 3  
83194 83194   82 400X Monterey Blvd 11 1 2    
84406 84406   35 132 Surrey St 1 1 1   Permit Number 779127
85180 85180   11 1366 Turk St 1 1 2    
88231 88231   127 360Y1 Valencia St 1 1 2 3  
89317 89317   1 2448 Hyde St 1 1 2    
90534 90534   56   1 1 1    
90989 90989   22 134 26th Ave 1 1 1    
91145 91145   6 522X Alemany Blvd 1 1 2    
91687 91687   55 1661 Pine St 1 1 2    
93324 93324   17 552 Broderick St 1 1 1 1 Permit Number 54024
95026 95026   18 3390 Cesar Chavez St 1 1 2    
95845 95845   127 360Y14 Valencia St 1 1 2 3  
96265 96265   127 360Y4 Valencia St 1 1 2 3  
96662 96662   82 400X Monterey Blvd 11 1 2    
97533 97533   127 360Y10 Valencia St 1 1 2 3  
98712 98712   127 360Y5 Valencia St 1 1 2 3  
99579 99579   127 360Y11 Valencia St 1 1 2 3  
102642 102642   127 360Y3 Valencia St 1 1 2 3  
103498 103498   127 360Y6 Valencia St 1 1 2 3  
104112 104112   6 598X Alemany Blvd 1 1 2    
104127 104127   17 38 Museum Way 1 1 1    
105765 105765   11 45X Jones St 1 1 2    
105788 105788   127 360Y9 Valencia St 1 1 2 3  
107509 107509   16 1300 Webster St 11 1 2    
108522 108522   47 2X Cranleigh Dr 4 1 2    
110133 110133   6 522X Alemany Blvd 1 1 2    
117485 117485   82 400X Monterey Blvd 11 1 2    
117918 117918   6 500X Alemany Blvd 1 1 2    
119480 119480   17 25X Jones St 1 1 2    
119540 119540   11 1397X Buchanan St 1 1 2 3 Maintenance agreement ends 8/17/2010
120951 120951   131 1335 Fulton St 1 1 2 3 under 3 yr maintenance agreement. expires 7/19/2010
122843 122843   16 455 Valley St 1 1 1   Permit Number 49374
122914 122914   127 360Y7 Valencia St 1 1 2 3  
123072 123072   127 360Y2 Valencia St 1 1 2 3  
123320 123320   116 818 Goettingen St 13 1 1    
123690 123690   1 2448 Hyde St 1 1 2    
125466 125466   1 1490X Douglass St 9 1 1    
126348 126348   127 360Y13 Valencia St 1 1 2 3  
128811 128811   11 45X Jones St 1 1 2    
129428 129428   18 3390 Cesar Chavez St 1 1 2    
138815 138815   11 898X Ellis St 1 1 2    
140895 140895   41 1250 Haight St 1 1 2 3 Under 3 yr maintenance agreement. Ends 7/27/2010.
141531 141531   299 1548x Quesada Ave 11 1 2    
141737 141737   46 1380x Newcomb Ave 11 1 2    
143542 143542   127 360Y8 Valencia St 1 1 2 3  
143623 143623   35 132 Surrey St 1 1 1   Permit Number 779127
145363 145363   131 1335 Fulton St 1 1 2 3 under 3yr maintenance agreement. Expires 7/19/2010.
1 1 1 1 501X Baker St 1 1 1   Permit Number 25401
6 6 1 1 501X Baker St 1 1 1    
8 8 1 6 300x Hickory 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    
23 23 1 14 1555 40th Ave 1 1 1   Permit Number 777142
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    
33 33 1 15 1545 California St 1 1 1    
39 39 1 11 101 Cargo Way 1 1 1    
45 45 1 2 3201 California St 1 1 1    
51 51 1 17   1 1 1   Permit Number 20649
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
67 67 1 29 520 Jersey St 1 1 1   Permit Number 18521
73 73 1 18 1051 Bush St 1 1 1 1 Permit Number 28361
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
80 80 1 32 4425 18th St 1 1 1   Permit Number 47310
82 82 1 31 300 Duboce Ave 7 1 1   Permit Number 43693
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    
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
99 99 1 9 2247 Franklin St 1 1 1    
100 100 1 37 2200 Lyon St 1 1 1   Permit Number 773028
103 103 1 38   1 1 1   Permit Number 776915
111 111 1 15 400X Franklin St 1 1 1    
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    
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

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 1654.403ms · Data source: data.sfgov.org