trees

3,587 rows where qSpecies_id = 28 sorted by Police Districts

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts ▼ Supervisor Districts Zip Codes Neighborhoods (old)
79 121399 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 349X Cargo Way 1 Sidewalk: Curb side : Cutout Tree DPW 1                              
100 255131 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 9 Sidewalk: Property side : Yard Tree DPW 1                              
1723 19755 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY15 13 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3                      
1845 20002 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY46 22 Sidewalk: Curb side : Cutout Tree DPW 1     6 2                      
2868 255125 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 3 Sidewalk: Property side : Yard Tree DPW 1                              
3319 255128 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 6 Sidewalk: Property side : Yard Tree DPW 1                              
3449 19754 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY15 12 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3                      
4083 19998 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY46 18 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
5059 255129 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 7 Sidewalk: Property side : Yard Tree DPW 1                              
5129 255126 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 4 Sidewalk: Property side : Yard Tree DPW 1                              
5510 104813 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1601X Portola Dr 5 Front Yard : Yard Tree Private 2                              
6473 48743 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
7374 48751 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
8604 48746 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
8612 255133 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 11 Sidewalk: Property side : Yard Tree DPW 1                              
8893 50823 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   2 Sidewalk: Curb side : Cutout Tree Private 2   03/19/2004 12:00:00 AM     Permit Number 47344                    
9839 48748 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   6 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
10173 48744 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
10238 255130 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 8 Sidewalk: Property side : Yard Tree DPW 1                              
10360 30354 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   1 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1956 12:00:00 AM     Permit Number 43                    
10635 255127 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 5 Sidewalk: Property side : Yard Tree DPW 1                              
11935 50824 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   1 Sidewalk: Curb side : Cutout Tree Private 2   03/19/2004 12:00:00 AM     Permit Number 47344                    
12040 48742 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   10 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
12785 48747 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
12883 255123 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 1 Sidewalk: Property side : Yard Tree DPW 1                              
15071 48749 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   7 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
15641 48745 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
17595 255124 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 2 Sidewalk: Property side : Yard Tree DPW 1                              
18540 48750 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   8 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
19147 255132 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 10 Sidewalk: Property side : Yard Tree DPW 1                              
1661 126293 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 300 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6009210.11859 2121881.78828 37.8068021921193 -122.412424475734 (37.8068021921193, -122.412424475734) 3 1 10 308 23
4157 52083 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 770 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/17/2005 12:00:00 AM     Permit Number 48281 6010080.56543171 2116389.03640526 37.7917692527785 -122.409024297587 (37.7917692527785, -122.409024297587) 5 1 10 28857 21
5844 99991 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600@Clay Montgomery St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 44594 6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
7755 126345 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 504 Clay St 6 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6011901.4963 2117456.13794 37.7948010955445 -122.402798926636 (37.7948010955445, -122.402798926636) 3 1 10 28860 4
8333 126339 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6012176.42228 2117479.41237 37.7948803483084 -122.401849275842 (37.7948803483084, -122.401849275842) 3 1 10 28860 4
12205 142979 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 302 CHESTNUT ST 1 Sidewalk: Curb side : Cutout Tree Private 2     34 Width 0ft   6010333.0283 2120985.7302 37.8044047900705 -122.40847515981 (37.8044047900705, -122.40847515981) 3 1 10 308 23
15569 4741 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1120 Columbus Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1   04/29/1992 12:00:00 AM 12 3X3   6008069.3023022 2121114.6784448 37.8046318166674 -122.416318139035 (37.8046318166674, -122.416318139035) 5 1 10 308 23
20003 99987 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 535@Clay Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2           6012018 2117734 37.7955705425922 -122.402415352518 (37.7955705425922, -122.402415352518) 3 1 10 28860 4
20023 126333 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 537 Washington St 6 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6011888.21181 2117712.45326 37.7955041342546 -122.402862928705 (37.7955041342546, -122.402862928705) 3 1 10 28860 4
20154 126324 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 514 Commercial St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6012230.12166 2117309.16104 37.7944158754575 -122.401651495115 (37.7944158754575, -122.401651495115) 3 1 10 28860 4
21249 112640 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 299X STOCKTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 6x9   6010693 2115178 37.7884783251045 -122.406819877074 (37.7884783251045, -122.406819877074) 5 1 10 28852 6
22089 86892 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 2500 Mason St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49821 6008765 2122158 37.8075356107649 -122.413984454109 (37.8075356107649, -122.413984454109) 3 1 10 308 23
23313 67885 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 558 Commercial St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/22/1993 12:00:00 AM 11 4x4 Permit Number 31579 6012000.40021 2117278.49262 37.7943188457921 -122.402444206153 (37.7943188457921, -122.402444206153) 3 1 10 28860 4
24340 126290 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1198 Columbus Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6007603.03986 2121549.62811 37.8057998482576 -122.417962541334 (37.8057998482576, -122.417962541334) 5 1 10 308 23
25543 126300 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 300 North Point St 12 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008880.73692 2121834.44066 37.8066536978683 -122.413561019128 (37.8066536978683, -122.413561019128) 3 1 10 308 23
25628 100017 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 12 Sidewalk: Curb side : Cutout Tree Private 2     15     6011791.69231 2117640.10072 37.7953000816886 -122.403191812578 (37.7953000816886, -122.403191812578) 3 1 10 28860 4
26881 97635 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1254 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008163 2117572 37.7949097746331 -122.415742887246 (37.7949097746331, -122.415742887246) 5 1 10 28858 21
29279 86893 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 2500 Mason St 12 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2007 12:00:00 AM   3x3 Permit Number 49821 6008765 2122158 37.8075356107649 -122.413984454109 (37.8075356107649, -122.413984454109) 3 1 10 308 23
29377 114412 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1345 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     12     6008898.23064 2117525.75314 37.7948240957174 -122.413195602999 (37.7948240957174, -122.413195602999) 5 1 10 28857 21
29882 100026 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 4 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
30430 102606 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 300 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010368 2120990 37.8044184722981 -122.408354438035 (37.8044184722981, -122.408354438035) 3 1 10 308 23
31020 126304 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 150 Lombard St 14 Sidewalk: Property side : Yard Tree Private 2     13 Width 3ft   6011511.53944 2120807.30084 37.8039807949437 -122.40438423177 (37.8039807949437, -122.40438423177) 3 1 10 28860 6
33339 100023 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 6 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
33792 142978 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1905 Grant Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6010357.7464 2121006.2509 37.8044625190574 -122.408391068632 (37.8044625190574, -122.408391068632) 3 1 10 308 23
33929 126323 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 California St 5 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 5ft   6013218.19178 2116960.71116 37.7935142007749 -122.398208171762 (37.7935142007749, -122.398208171762) 4 1 10 28860 6
33988 126305 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 19 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 5ft   6011380.98964 2121084.38787 37.8047343117091 -122.404855530454 (37.8047343117091, -122.404855530454) 3 1 10 28860 6
37746 142611 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2424 JONES ST 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6008004.2032 2120795.1714 37.8037508700928 -122.416520774929 (37.8037508700928, -122.416520774929) 5 1 10 308 32
39908 126191 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1490 Sacramento St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6007656.60094 2116516.3176 37.7919826517202 -122.417420253753 (37.7919826517202, -122.417420253753) 5 1 10 28858 21
40252 126270 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 757 North Point St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007122.07694 2121536.84547 37.8057376700126 -122.419626082101 (37.8057376700126, -122.419626082101) 5 1 1 28858 32
40556 126308 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 19 Chestnut St 5 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 5ft   6011431.79108 2121090.48477 37.8047538917423 -122.404680155458 (37.8047538917423, -122.404680155458) 3 1 10 28860 6
42643 258040 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1288 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007535 2121589 37.8059041239352 -122.418200797252 (37.8059041239352, -122.418200797252) 5 1 10 308 23
43802 57383 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1038 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/02/1976 12:00:00 AM 20   Permit Number 16222 6008178.63757 2116060.00557 37.790759089023 -122.415581676167 (37.790759089023, -122.415581676167) 5 1 10 28858 21
43941 46350 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600@Washington St Montgomery St 9 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2002 12:00:00 AM 12   Permit Number 44594 6011800.91872 2117592.16753 37.7951689839044 -122.403156514164 (37.7951689839044, -122.403156514164) 3 1 10 28860 4
44086 142980 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 302 CHESTNUT ST 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6010297.117 2120982.4656 37.8043938151268 -122.408599204074 (37.8043938151268, -122.408599204074) 3 1 10 308 23
44347 126299 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 300 North Point St 10 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6008955.34228 2121845.45564 37.806688131109 -122.413303611596 (37.806688131109, -122.413303611596) 3 1 10 308 23
44949 100027 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 3 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
45551 126301 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 300 North Point St 13 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008867.14931 2121833.93475 37.8066515458005 -122.413608006 (37.8066515458005, -122.413608006) 3 1 10 308 23
46872 27432 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1288 Columbus Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     22 4X4   6007580.92749 2121572.89753 37.8058624956614 -122.418040715371 (37.8058624956614, -122.418040715371) 5 1 10 308 23
50134 100004 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600@Washington St Montgomery St 8 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
51500 126291 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1198 Columbus Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6007589.25664 2121562.16822 37.8058335044831 -122.418011129904 (37.8058335044831, -122.418011129904) 5 1 10 308 23
51864 126255 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1234 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 3ft   6008711.5059 2117324.04043 37.7942597576443 -122.413827423524 (37.7942597576443, -122.413827423524) 5 1 10 28857 21
51876 126343 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 504 Clay St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 2ft   6011928.96747 2117459.63842 37.7948122408476 -122.402704118326 (37.7948122408476, -122.402704118326) 3 1 10 28860 4
53056 46349 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600@Washington St Montgomery St 10 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2002 12:00:00 AM 15   Permit Number 44594 6011797.44129 2117605.10565 37.7952043146792 -122.403169457224 (37.7952043146792, -122.403169457224) 3 1 10 28860 4
56878 126342 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 504 Clay St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6011942.798 2117460.48455 37.7948153363017 -122.402656322025 (37.7948153363017, -122.402656322025) 3 1 10 28860 4
57271 100029 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
57942 142990 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1847 GRANT AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6010376.3672 2120881.545 37.804121150252 -122.408317828181 (37.804121150252, -122.408317828181) 3 1 10 308 23
59629 126268 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 757 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007089.07712 2121533.77158 37.8057273709962 -122.419740064856 (37.8057273709962, -122.419740064856) 5 1 1 28858 32
59651 126346 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 504 Clay St 7 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6011888.53477 2117453.47011 37.7947930466025 -122.402843587862 (37.7947930466025, -122.402843587862) 3 1 10 28860 4
60177 99996 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600@Clay Montgomery St 10 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 44594 6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
60809 100009 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600@Washington St Montgomery St 4 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
61486 67390 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 California St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1992 12:00:00 AM 21   Permit Number 30887 6013339.22791 2116980.96183 37.7935765453846 -122.397790795502 (37.7935765453846, -122.397790795502) 4 1 10 28860 6
62295 106457 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1x CHESTNUT ST 14 Sidewalk: Curb side : Cutout Tree Private 2           6011546 2121132 37.8048742648975 -122.404287845465 (37.8048742648975, -122.404287845465) 3 1 10 28860 6
64433 126309 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 19 Chestnut St 8 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 5ft   6011549.22604 2121109.21321 37.8048118782298 -122.404275076545 (37.8048118782298, -122.404275076545) 3 1 10 28860 6
64698 114701 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 645 STOCKTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010496 2116407 37.7918418395307 -122.407588155464 (37.7918418395307, -122.407588155464) 5 1 10 28857 21
65772 126289 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1198 Columbus Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6007647.01376 2121508.69836 37.8056899403132 -122.417807459567 (37.8056899403132, -122.417807459567) 5 1 10 308 23
71604 126335 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 537 Washington St 8 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6011914.41162 2117716.44369 37.7955165539073 -122.40277255313 (37.7955165539073, -122.40277255313) 3 1 10 28860 4
72445 142612 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2424 JONES ST 3 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6008004.2032 2120805.2808 37.8037786279563 -122.416521491468 (37.8037786279563, -122.416521491468) 5 1 10 308 32
72568 112306 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1254 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008684 2117318 37.7942416273691 -122.413922169868 (37.7942416273691, -122.413922169868) 5 1 10 28857 21
72619 100020 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 9 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
74115 126307 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 19 Chestnut St 4 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 5ft   6011412.75588 2121088.95225 37.8047486199155 -122.404745921109 (37.8047486199155, -122.404745921109) 3 1 10 28860 6
74316 106886 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 580 Commercial St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2014 12:00:00 AM 3   Permit Number 772874 6011893.85928 2117261.69096 37.7942667642387 -122.402811670039 (37.7942667642387, -122.402811670039) 3 1 10 28860 4
74445 249775 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 102 Pfeiffer St 6 Side Yard : Yard Tree Private 2     21 Width 0ft   6010401.04426 2121152.23114 37.8048657692012 -122.40825153419 (37.8048657692012, -122.40825153419) 3 1 10 308 23
75097 126296 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 300 North Point St 5 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   6009109.48206 2121867.97371 37.8067586127902 -122.412771772309 (37.8067586127902, -122.412771772309) 3 1 10 308 23
75648 100015 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 14 Sidewalk: Curb side : Cutout Tree Private 2     19     6011789.64079 2117672.98825 37.795390268386 -122.403201225768 (37.795390268386, -122.403201225768) 3 1 10 28860 4
76298 126322 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 California St 4 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6013251.89041 2116966.13143 37.7935309605345 -122.398091951502 (37.7935309605345, -122.398091951502) 4 1 10 28860 6
76653 100018 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 11 Sidewalk: Curb side : Cutout Tree Private 2     14     6011793.71356 2117622.45121 37.7952517332473 -122.403183576561 (37.7952517332473, -122.403183576561) 3 1 10 28860 4
76867 126332 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 537 Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6011860.92866 2117711.02916 37.7954987005659 -122.402957233402 (37.7954987005659, -122.402957233402) 3 1 10 28860 4
78272 126292 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1198 Columbus Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   6007576.38379 2121572.19977 37.8058603240585 -122.418056390085 (37.8058603240585, -122.418056390085) 5 1 10 308 23
78962 142483 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 502 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6010521.5126 2119626.8488 37.8006841900348 -122.407727016144 (37.8006841900348, -122.407727016144) 3 1 10 308 23
79115 112307 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1254 Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM   3x3   6008684 2117318 37.7942416273691 -122.413922169868 (37.7942416273691, -122.413922169868) 5 1 10 28857 21

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);