trees

3,587 rows where qSpecies_id = 28 sorted by Supervisor 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                              
50 264964 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3641 California St 1 Sidewalk: Curb side : Cutout Tree Private 2       3X3   5996989 2114619 37.7861671437011 -122.454192924446 (37.7861671437011, -122.454192924446) 11 6 1 54 31
69 126274 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1240 Lombard St 1 Sidewalk: Property side : Yard Tree Private 2     24 Width 6ft   6006421.51674 2120105.21307 37.8017672864012 -122.421948716173 (37.8017672864012, -122.421948716173) 5 9 1 28858 32
2245 126164 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3404 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   5998411.11322 2115565.12364 37.7888463955847 -122.449341001806 (37.7888463955847, -122.449341001806) 13 6 1 54 31
2480 126159 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 240 Walnut St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   5998555.75349 2115712.4889 37.7892592941314 -122.448851187837 (37.7892592941314, -122.448851187837) 13 6 1 54 31
2816 126194 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2323 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 5ft   6000797.30385 2116351.55373 37.7911419313024 -122.441141581441 (37.7911419313024, -122.441141581441) 13 6 1 29490 27
2993 140841 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 128 JORDAN AVE 1 Sidewalk: Curb side : Yard Tree Private 2     16 Width 0ft   5996252.84 2113531.7423 37.7831395829214 -122.456661169882 (37.7831395829214, -122.456661169882) 11 6 1 54 31
3026 142443 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 58 Sidewalk: Property side : Yard Tree Private 2     20 Width 0ft   5997409.7349 2114492.5218 37.7858439854294 -122.452728168531 (37.7858439854294, -122.452728168531) 11 6 1 54 31
3684 98923 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3527 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   5997962.31773 2115134.58282 37.7876385629149 -122.450862707746 (37.7876385629149, -122.450862707746) 11 6 1 54 31
4413 106528 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2100 Baker St 4 Sidewalk: Curb side : Cutout Tree Private 2     23     5999888.51189 2116174.57366 37.7906041834903 -122.444273238422 (37.7906041834903, -122.444273238422) 13 6 1 29490 27
7933 142422 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 37 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5997618.0335 2114520.9492 37.7859339729155 -122.452009568816 (37.7859339729155, -122.452009568816) 11 6 1 54 31
9240 126178 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2413 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6000282.738 2119543.98555 37.7998781830919 -122.44315133689 (37.7998781830919, -122.44315133689) 13 9 1 57 17
9867 18856 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2201 Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004191.66186 2115995.22985 37.79035631503 -122.429371791378 (37.79035631503, -122.429371791378) 13 9 1 29490 27
10114 12679 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1302 Lake St 4 Sidewalk: Curb side : Cutout Tree DPW 1     60 4x4   5991386.80092 2114799.39324 37.7863396121206 -122.473588027094 (37.7863396121206, -122.473588027094) 11 6 1 54 33
11261 117631 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3406 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     27 3x3   5998437.09993 2115571.11659 37.7888643370692 -122.44925152374 (37.7888643370692, -122.44925152374) 13 6 1 54 31
11727 27637 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 300X Lake St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 4x4   5994586.51749 2114934.45483 37.7868952379175 -122.462527708701 (37.7868952379175, -122.462527708701) 11 6 1 54 11
11833 16835 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2200 O'Farrell St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 5x14   6000775.7711116 2113134.575359 37.7823077134494 -122.440985198149 (37.7823077134494, -122.440985198149) 15 5 1 29490 41
12050 261306 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1555 Union St 1 Front Yard : Cutout Tree Private 2       3x3   6005549 2118864 37.7983099861265 -122.424879674285 (37.7983099861265, -122.424879674285) 13 9 1 57 17
12133 133687 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1451 Bay St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6003859 2120749 37.803390106055 -122.430862178125 (37.803390106055, -122.430862178125) 13 9 1 28858 17
12838 110205 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2113 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     26 6x6   6000355.27236 2115993.16696 37.7901327067156 -122.442645247897 (37.7901327067156, -122.442645247897) 13 6 1 29490 27
15504 126213 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2730 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     29 Width 4ft   6000853.52401 2116888.62885 37.7926198016173 -122.440985608413 (37.7926198016173, -122.440985608413) 13 6 1 29490 27
15622 126182 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1451 Bay St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003859 2120749 37.803390106055 -122.430862178125 (37.803390106055, -122.430862178125) 13 9 1 28858 17
15721 126288 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2500x Van Ness Ave 7 Median : Yard Tree DPW 1     27 Width 8ft   6005772.33142 2119211.18315 37.7992758747311 -122.424131583019 (37.7992758747311, -122.424131583019) 13 9 1 28858 32
15846 75161 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1500X Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6005585.43876 2119632.07302 37.8004209769936 -122.42480825631 (37.8004209769936, -122.42480825631) 13 9 1 57 17
15919 94903 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3701 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     21     5997033.01745 2115334.97967 37.7881355570475 -122.454092366574 (37.7881355570475, -122.454092366574) 11 6 1 54 31
16576 142423 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 38 Sidewalk: Property side : Yard Tree Private 2     26 Width 0ft   5997605.1735 2114516.8881 37.7859220855908 -122.452053767548 (37.7859220855908, -122.452053767548) 11 6 1 54 31
17411 12539 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 210 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/01/2019 12:00:00 AM 3 3x3   5994802.33005 2114932.67469 37.7869027759417 -122.461780923147 (37.7869027759417, -122.461780923147) 11 6 1 54 11
17574 120058 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 132 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     37 Width 4ft   5987428.81431 2115064.18199 37.7868366349011 -122.487300926674 (37.7868366349011, -122.487300926674) 11 6 1 55 33
18145 12518 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 25 Lake St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 3X3   5995386.16934 2114888.58618 37.7868153127181 -122.459757792257 (37.7868153127181, -122.459757792257) 11 6 1 54 11
18822 65766 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1937 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1990 12:00:00 AM 15   Permit Number 28729 6003642.45675 2118972.66599 37.7985004828598 -122.431484647806 (37.7985004828598, -122.431484647806) 13 9 1 57 17
19077 138568 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2626 Pine St 6 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6001336.9539 2114950.5561 37.7873258778413 -122.439173956551 (37.7873258778413, -122.439173956551) 13 6 1 29490 27
19241 26162 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 220 Richardson Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   5999090.09548 2119848.96049 37.8006474865597 -122.447300272802 (37.8006474865597, -122.447300272802) 13 9 1 57 17
19433 123853 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 300 Lake St 11 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 7ft   5994558.56386 2114921.26273 37.786857406167 -122.462623463806 (37.786857406167, -122.462623463806) 11 6 1 54 11
19442 123590 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 28 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   5994274.25903 2115401.74269 37.7881602957788 -122.463641970091 (37.7881602957788, -122.463641970091) 11 6 1 54 11
19688 126199 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3045 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   5999577.09584 2116663.67012 37.7919293417196 -122.44538589855 (37.7919293417196, -122.44538589855) 13 6 1 29490 27
19805 126225 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2137 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6003795.94873 2115803.8767 37.7898084966014 -122.430727270273 (37.7898084966014, -122.430727270273) 13 9 1 29490 27
22935 12652 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000 Lake St 2 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   5992352.41288 2114839.20557 37.7865047992766 -122.470250187524 (37.7865047992766, -122.470250187524) 11 6 1 54 11
24268 142433 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 48 Sidewalk: Property side : Yard Tree Private 2     16 Width 0ft   5997499.5859 2114503.0128 37.7858779390155 -122.452418068061 (37.7858779390155, -122.452418068061) 11 6 1 54 31
24318 12678 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1302 Lake St 3 Sidewalk: Curb side : Cutout Tree DPW 1     50 4X4   5991402.06133 2114800.45081 37.7863433996674 -122.473535307672 (37.7863433996674, -122.473535307672) 11 6 1 54 33
24554 142386 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 1 Sidewalk: Property side : Yard Tree Private 2     27 Width 0ft   5998114.6675 2114591.1717 37.7861552196694 -122.450296423393 (37.7861552196694, -122.450296423393) 11 6 1 54 31
24587 126136 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2722 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 5ft   6000010.55961 2117815.97054 37.7951179896682 -122.443968946536 (37.7951179896682, -122.443968946536) 13 9 1 57 17
24858 120075 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 135 26th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5987696.45298 2115057.78701 37.7868346797306 -122.486374501304 (37.7868346797306, -122.486374501304) 11 6 1 55 33
25028 23944 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2334X Sacramento St 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6003622.99851 2115966.72014 37.7902458233354 -122.431337290596 (37.7902458233354, -122.431337290596) 13 9 1 29490 27
25404 113493 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2850 LAKE ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5986565 2114493 37.7852179229774 -122.490247450243 (37.7852179229774, -122.490247450243) 11 6 1 55 33
25883 142395 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 10 Sidewalk: Property side : Yard Tree Private 2     30 Width 0ft   5997933.9503 2114564.4364 37.7860714676838 -122.450919725605 (37.7860714676838, -122.450919725605) 11 6 1 54 31
25886 126275 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2836 Larkin St 7 Side Yard : Yard Tree Private 2     26     6006511.2494 2120976.42855 37.8041644823576 -122.421700114785 (37.8041644823576, -122.421700114785) 5 9 1 28858 32
26325 124553 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 36 Palm Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   5995908.32639 2114279.98645 37.7851742747708 -122.457907204393 (37.7851742747708, -122.457907204393) 11 6 1 54 31
26412 34885 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1539 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38493 6002855.27225509 2121286.11305956 37.8048079563004 -122.434374036967 (37.8048079563004, -122.434374036967) 13 9 1 57 17
26452 249722 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2500 Broderick St 6 Front Yard : Yard Tree Private 2     14     6000190.26691 2117349.57001 37.7938476262185 -122.443313617731 (37.7938476262185, -122.443313617731) 13 9 1 57 27
27213 87671 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 450 El Camino Del Mar 1 Sidewalk: Property side : Cutout Tree Private 2   05/22/2008 12:00:00 AM   3x3 Permit Number 50395 5987244 2115292 37.7874513785554 -122.487957078163 (37.7874513785554, -122.487957078163) 11 6 1 55 33
27609 142416 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 31 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5997686.3947 2114529.7482 37.7859620480803 -122.451773694005 (37.7859620480803, -122.451773694005) 11 6 1 54 31
27861 126209 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2692 Broadway 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6000795.3234 2117174.07818 37.7934002557748 -122.441207473859 (37.7934002557748, -122.441207473859) 13 9 1 29490 27
28380 142413 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 28 Sidewalk: Property side : Yard Tree Private 2     22 Width 0ft   5997716.1759 2114533.1324 37.7859730457909 -122.451670903916 (37.7859730457909, -122.451670903916) 11 6 1 54 31
28428 126195 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2315 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 5ft   6000798.79511 2116331.19704 37.7910861220794 -122.441134960611 (37.7910861220794, -122.441134960611) 13 6 1 29490 27
28660 142432 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 47 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5997511.0923 2114504.0281 37.785881385969 -122.452378332604 (37.785881385969, -122.452378332604) 11 6 1 54 31
29014 115937 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 500X LAKE ST 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   5993877 2114929 37.786839375345 -122.464982060228 (37.786839375345, -122.464982060228) 11 6 1 54 11
29187 250878 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 111 30th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     15 Width 4ft   5986467.64007 2114737.19206 37.7858827175598 -122.490602253393 (37.7858827175598, -122.490602253393) 11 6 1 55 33
29507 115701 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2840 LAKE ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x15   5986626 2114487 37.785205010982 -122.490035970437 (37.785205010982, -122.490035970437) 11 6 1 55 33
30238 137810 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2075 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6003825.3493 2115561.4198 37.7891444370337 -122.430608239064 (37.7891444370337, -122.430608239064) 13 9 1 29490 27
30248 12543 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 239 Lake St 2 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   5994669.04887 2114868.49847 37.786718892107 -122.462237385897 (37.786718892107, -122.462237385897) 11 6 1 54 11
31368 126148 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1535 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6004474.30573 2120123.1658 37.8017065704734 -122.428688249077 (37.8017065704734, -122.428688249077) 13 9 1 57 17
31529 97954 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 140 Palm Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     28 3x3 Permit Number 768198 5995938.36032 2113419.39672 37.7828130508284 -122.457741003486 (37.7828130508284, -122.457741003486) 11 6 1 54 31
31664 115699 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2840 LAKE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x15   5986626 2114487 37.785205010982 -122.490035970437 (37.785205010982, -122.490035970437) 11 6 1 55 33
31814 16836 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2200 O'Farrell St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6000775.7711116 2113134.575359 37.7823077134494 -122.440985198149 (37.7823077134494, -122.440985198149) 15 5 1 29490 41
31933 123854 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 300 Lake St 12 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 5ft   5994546.44545 2114926.51849 37.7868711391421 -122.462665771787 (37.7868711391421, -122.462665771787) 11 6 1 54 11
32650 126192 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2546 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     38 Width 4ft   6001970.71981 2116718.3057 37.7922157056542 -122.437107876546 (37.7922157056542, -122.437107876546) 13 6 1 29490 27
32983 38841 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1817 California St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 40670 6005665.65244341 2115853.93139831 37.7900516844756 -122.42426182602 (37.7900516844756, -122.42426182602) 13 9 1 28858 41
33080 27503 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 198X LAKE ST 5 Sidewalk: Property side : Cutout Tree DPW 1     25 3x3   5995045 2114905 37.7868407552542 -122.46093934021 (37.7868407552542, -122.46093934021) 11 6 1 54 11
33180 37143 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2155 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     28   Permit Number 39724 6003778.52248 2115919.83113 37.7901258907459 -122.430795841768 (37.7901258907459, -122.430795841768) 13 9 1 29490 27
33719 142414 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10 MAYFAIR DR 29 Sidewalk: Property side : Yard Tree Private 2     24 Width 0ft   5997709.7458 2114531.1019 37.7859671023257 -122.451693003671 (37.7859671023257, -122.451693003671) 11 6 1 54 31
33780 12632 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 900 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   5992668.91715 2114851.34382 37.7865564209787 -122.469156054781 (37.7865564209787, -122.469156054781) 11 6 1 54 11

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)
);