3,587 rows where qSpecies_id = 28 sorted by PlotSize

View and edit SQL

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                              
2050 50805 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1498 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/09/2004 12:00:00 AM     Permit Number 47329 6000596.76427703 2111027.41746177 37.7765117981927 -122.441453229456 (37.7765117981927, -122.441453229456) 15 5 11 29492 41
2152 33675 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 469 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/03/1996 12:00:00 AM 13   Permit Number 37757 6005116.23557125 2111084.96150687 37.7769262359606 -122.425823168919 (37.7769262359606, -122.425823168919) 7 9 11 28852 10
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                              
3865 105892 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1100 Masonic Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           5999444.5 2109060.1 37.7710443339737 -122.445297745357 (37.7710443339737, -122.445297745357) 15 5 11 29492 9
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
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
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                              
5273 218292 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Woodacre Dr 16 Sidewalk: Curb side : Yard Tree Private 2     39     5991223.38049 2095418.74528 37.7331160279643 -122.472739784911 (37.7331160279643, -122.472739784911) 1 8 4 64 40
5510 104813 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1601X Portola Dr 5 Front Yard : Yard Tree Private 2                              
5631 50066 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 406 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46794 6003569.14495563 2105912.6827965 37.7626368713078 -122.430805824209 (37.7626368713078, -122.430805824209) 15 4 5 28862 3
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
6176 217849 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1 Woodacre Dr 4 Sidewalk: Curb side : Yard Tree Private 2     33     5991387.06493 2095679.62189 37.7338418033391 -122.47219289908 (37.7338418033391, -122.47219289908) 1 8 4 64 40
6425 102410 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 55X Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2           6000310.8 2109142 37.7713186232103 -122.442307075209 (37.7713186232103, -122.442307075209) 15 5 11 29492 9
6473 48743 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
6987 249466 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 900x Van Ness Ave 4 Median : Yard Tree DPW 1     25     6006522.49711 2113836.87509 37.7845616899264 -122.421153924138 (37.7845616899264, -122.421153924138) 7 9 11 28858 36
7358 108758 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1449 PAGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2           5999638.3 2109087.9 37.7711317264146 -122.444629385712 (37.7711317264146, -122.444629385712) 15 5 11 29492 9
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                              
8634 176044 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Font Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     21     5990534.22824 2089263.30634 37.7161748133009 -122.474673246391 (37.7161748133009, -122.474673246391) 1 8 4 64 14
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                    
9073 205507 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1518 05th Ave 1 Sidewalk: Curb side : Pot Tree Private 2     24     5994641.65352 2105137.30281 37.7599980266194 -122.46162636506 (37.7599980266194, -122.46162636506) 15 5 4 56 12
9226 99970 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2270 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
9839 48748 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   6 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
9847 248795 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5175 Diamond Heights Blvd 9 Sidewalk: Property side : Yard Tree Private 2     16     6000777.48804 2099988.6184 37.7462122622804 -122.440036333505 (37.7462122622804, -122.440036333505) 2 4 5 63 22
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                    
10613 56603 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 4199@43rd Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2     0     5982724.27515302 2106932.91664164 37.7642350821119 -122.502975078628 (37.7642350821119, -122.502975078628) 1 8 3 56 35
10635 255127 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 5 Sidewalk: Property side : Yard Tree DPW 1                              
10661 114250 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 131 FONT BLVD 1 Front Yard : Yard Tree Private 2     36     5990844 2088883 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248) 1 8 4 64 14
10872 33492 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 25 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1996 12:00:00 AM     Permit Number 37604 6007009.01726732 2099597.28801828 37.7454905378147 -122.418460683772 (37.7454905378147, -122.418460683772) 2 7 7 28859 2
11184 56634 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1917 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2     27     6001626.77222134 2112852.27703888 37.7815810267112 -122.438020890084 (37.7815810267112, -122.438020890084) 15 5 11 29490 41
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                    
12047 176041 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 420 Font Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     20     5989405 2090258 37.7188404967574 -122.478649058693 (37.7188404967574, -122.478649058693) 1 8 4 64 14
12051 106705 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 199X BRIGHTON AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     24     5996224 2090880 37.7209419254054 -122.455123542447 (37.7209419254054, -122.455123542447) 9 8 6 28861 24
12565 104957 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 759 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
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                              
13608 70503 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 193 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6004252.47977 2092436.67804 37.7256735552654 -122.427482323859 (37.7256735552654, -122.427482323859) 9 7 6 28861 5
15071 48749 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   7 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
15264 2135 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1100X Bosworth St 24 Sidewalk: Property side : Cutout Tree DPW 1     24     6001043.628513 2095761.867481 37.7346217448773 -122.438813219285 (37.7346217448773, -122.438813219285) 2 7 5 63 7
15641 48745 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
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
16008 212124 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 300x Miramar Ave 6 Median : Yard Tree DPW 1     5     5995365.62659 2092320.18392 37.7248470432517 -122.45819484442 (37.7248470432517, -122.45819484442) 9 7 4 28861 40
17595 255124 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 2 Sidewalk: Property side : Yard Tree DPW 1                              
18302 33467 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 72 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1996 12:00:00 AM     Permit Number 37623 6006783.56593714 2099291.50343979 37.7446382277934 -122.419218573599 (37.7446382277934, -122.419218573599) 2 7 7 28859 2
18469 61073 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2638 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/01/1983 12:00:00 AM 20   Permit Number 20909 5999566.78827199 2113662.02579548 37.78368702296 -122.445205661056 (37.78368702296, -122.445205661056) 15 6 11 29490 31
18540 48750 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   8 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
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
18977 97306 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 47 Kittredge Ter 1 Sidewalk: Curb side : Cutout Tree Private 2           5997949.8 2111441.7 37.7774981585608 -122.450639669067 (37.7774981585608, -122.450639669067) 15 6 2 54 16
19147 255132 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 10 Sidewalk: Property side : Yard Tree DPW 1                              
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
20704 2136 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1100X Bosworth St 25 Sidewalk: Curb side : Cutout Tree DPW 1     12     6001043.628513 2095761.867481 37.7346217448773 -122.438813219285 (37.7346217448773, -122.438813219285) 2 7 5 63 7
20880 99966 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2270 Folsom St 8 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
20912 24331 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 601X Golden Gate Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1     18     6006691.6523257 2112520.4868544 37.7809567435024 -122.420475231256 (37.7809567435024, -122.420475231256) 7 9 9 28852 36
21900 176048 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2     18     5989010.93647 2089619.81285 37.7170653066825 -122.479964486788 (37.7170653066825, -122.479964486788) 1 8 4 64 14
22660 33533 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 185 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1996 12:00:00 AM     Permit Number 37643 6007275.34853053 2097937.54990535 37.7409482571652 -122.417422147014 (37.7409482571652, -122.417422147014) 2 7 7 28859 2
23585 2101 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000X Bosworth St 9 Sidewalk: Property side : Cutout Tree DPW 1   04/09/1990 12:00:00 AM 14     6001184.3961353 2095706.3375319 37.7344772801388 -122.438322562248 (37.7344772801388, -122.438322562248) 9 7 5 63 7
24024 54655 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 280 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/1972 12:00:00 AM 18   Permit Number 10479 6012382.77536 2087271.8623 37.7119485104815 -122.399014002112 (37.7119485104815, -122.399014002112) 10 3 8 309 1
24111 2116 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1100X Bosworth St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12     6001043.628513 2095761.867481 37.7346217448773 -122.438813219285 (37.7346217448773, -122.438813219285) 2 7 5 63 7
24372 212187 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 720 Bosworth St 1 Sidewalk: Property side : Yard Tree DPW 1     16     6002096.28779 2095466.30888 37.733870041163 -122.435152693763 (37.733870041163, -122.435152693763) 2 7 5 63 7
24640 176024 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 26 Ervine St 3 Front Yard : Yard Tree Private 2     25     6009648.36238 2089313.42999 37.7174014822691 -122.40860887622 (37.7174014822691, -122.40860887622) 9 7 8 309 18
24682 50574 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 2295 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/2003 12:00:00 AM     Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
24768 50314 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1055 Ellis St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2003 12:00:00 AM     Permit Number 47021 6005825.34130744 2113438.50468071 37.7834285368624 -122.42353751819 (37.7834285368624, -122.42353751819) 7 9 11 28858 41
24910 50685 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 915 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47258 5999168.89515798 2107036.01925898 37.7654709832109 -122.446105453704 (37.7654709832109, -122.446105453704) 15 5 11 29492 9
25023 176021 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 26 Ervine St 8 Front Yard : Yard Tree Private 2     5     6009620.69504 2089243.53702 37.7172080210075 -122.408699581837 (37.7172080210075, -122.408699581837) 9 7 8 309 18
25471 2132 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1100X Bosworth St 21 Sidewalk: Property side : Cutout Tree DPW 1     0     6001043.628513 2095761.867481 37.7346217448773 -122.438813219285 (37.7346217448773, -122.438813219285) 2 7 5 63 7
25604 99496 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1400X Plymouth Ave 3 Median : Cutout Tree Private 2           5995903 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576) 9 7 4 28861 40
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
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
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
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
28699 40132 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 697 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/1999 12:00:00 AM     Permit Number 41337 6008515.22056385 2095655.65791493 37.7347523629036 -122.412973810281 (37.7347523629036, -122.412973810281) 10 7 7 28859 2
28914 24330 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 601X Golden Gate Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     18     6006691.6523257 2112520.4868544 37.7809567435024 -122.420475231256 (37.7809567435024, -122.420475231256) 7 9 9 28852 36
29045 54788 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 266 Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/1972 12:00:00 AM 17   Permit Number 10637 6012648.47164 2087248.62221 37.7118995001448 -122.398094045129 (37.7118995001448, -122.398094045129) 10 3 8 309 1
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
29446 50634 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 2900 Jennings St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/2004 12:00:00 AM     Permit Number 47740 6014120.76360854 2090918.26429059 37.7220575083684 -122.393261977074 (37.7220575083684, -122.393261977074) 10 3 8 58 1
29506 33680 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 419 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM 13   Permit Number 37760 6005344.46198727 2111116.85391927 37.7770266994083 -122.425035932953 (37.7770266994083, -122.425035932953) 7 9 11 28852 10
29605 217817 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1x Junipero Serra Blvd 4 Median : Yard Tree DPW 1     27     5991627.99201 2095776.79312 37.7341225510202 -122.47136702736 (37.7341225510202, -122.47136702736) 1 8 4 59 40
29844 53048 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 65@ APPLETON Gladys St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2006 12:00:00 AM     Permit Number 49026 6005683.68607987 2097324.15915168 37.7391743410359 -122.422881952522 (37.7391743410359, -122.422881952522) 2 7 7 28859 2
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
30818 2115 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1100X Bosworth St 4 Sidewalk: Property side : Cutout Tree DPW 1     18     6001043.628513 2095761.867481 37.7346217448773 -122.438813219285 (37.7346217448773, -122.438813219285) 2 7 5 63 7
31243 212222 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1120 Bosworth St 15 Sidewalk: Property side : Yard Tree DPW 1   10/13/2014 11:02:00 AM 16     6000900.61271 2095850.79313 37.7348577764545 -122.439314043907 (37.7348577764545, -122.439314043907) 2 7 5 63 7
32152 56296 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 153 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1973 12:00:00 AM 19   Permit Number 12428 5993949.48549 2114460.3201 37.7855566873358 -122.464697232751 (37.7855566873358, -122.464697232751) 11 6 2 54 11
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
33171 33502 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 155 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1996 12:00:00 AM     Permit Number 37596 6006575.63931047 2098797.68147059 37.7432705917121 -122.419902509091 (37.7432705917121, -122.419902509091) 2 7 7 28859 2
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
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
33433 104433 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1601X PORTOLA DR 2 Front Yard : Yard Tree Private 2     16     5991823 2096240 37.7354056792703 -122.47072655808 (37.7354056792703, -122.47072655808) 1 8 4 59 40
33512 212209 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 920 Bosworth St 10 Sidewalk: Property side : Yard Tree Private 2     14     6001437.10561 2095636.37062 37.7342995375914 -122.437443855175 (37.7342995375914, -122.437443855175) 9 7 5 63 7
34008 32073 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3254 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     30   Permit Number 35447 5999189.55674 2115674.61094 37.7891915158244 -122.446655586587 (37.7891915158244, -122.446655586587) 13 6 1 29490 31
34555 33952 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1 Arbor St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/09/1997 12:00:00 AM     Permit Number 37910 6002287.3237241 2097040.91143479 37.7382043832783 -122.434604778209 (37.7382043832783, -122.434604778209) 2 7 5 63 7

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