3,587 rows where qSpecies_id = 28

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)
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
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
9872 19236 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 651 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6002073.38012 2110681.82337 37.7756468948621 -122.436320461165 (37.7756468948621, -122.436320461165) 15 5 11 29492 10
9937 99488 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 800X Miramar Ave 1 Median : Yard Tree Private 2   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995450.2 2094280.5 37.7302344585425 -122.458044289565 (37.7302344585425, -122.458044289565) 9 7 4 28861 40
10052 14948 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 200X Mendell St 16 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016767.4558 2097838.85848 37.7412067724716 -122.384594749942 (37.7412067724716, -122.384594749942) 10 3 8 58 1
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
10116 248844 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 38 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6007344.42201 2099271.59206 37.7446151256805 -122.417277828134 (37.7446151256805, -122.417277828134) 2 7 7 28859 2
10121 110450 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 56 HANCOCK ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003933 2105145 37.7605496062864 -122.429492630385 (37.7605496062864, -122.429492630385) 2 4 5 28862 3
10137 228617 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 576 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6002640.85339 2103292.8906 37.7553909139673 -122.43382918759 (37.7553909139673, -122.43382918759) 2 4 5 28862 22
10173 48744 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
10232 140742 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2001 O'Farrell St 2 Sidewalk: Curb side : Cutout Tree Private 2     28 Width 0ft   6001472.9963 2113178.7683 37.7824687423539 -122.438576280753 (37.7824687423539, -122.438576280753) 15 5 11 29490 41
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                    
10391 261268 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1544 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   5999025.8241 2109069.656 37.771046664384 -122.446746640696 (37.771046664384, -122.446746640696) 15 5 11 29492 9
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
10712 205508 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 620 Quintara St 1 Sidewalk: Curb side : Yard Tree Private 2     24 Width 5ft   5991536.67412 2101158.90463 37.7488951701835 -122.472074903552 (37.7488951701835, -122.472074903552) 1 8 4 29491 12
10799 212114 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1902x Monterey Blvd 2 Median : Yard Tree DPW 1     36 Width 10ft   5992265.63325 2095412.19532 37.7331583221951 -122.469135994644 (37.7331583221951, -122.469135994644) 9 8 4 59 40
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
10989 254569 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1400x Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3   6004613 2113717 37.7841247118733 -122.427751595484 (37.7841247118733, -122.427751595484) 13 9 11 28858 41
11020 261566 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1800 26th St 1 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
11060 49693 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 450 Stanyan St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   23 5x5 Permit Number 46512 5996840.32777146 2110125.42661407 37.7738204478349 -122.454382576109 (37.7738204478349, -122.454382576109) 15 5 2 29492 16
11079 6325 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1895X Ellis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6001829.84497 2112881.90897 37.7816739348974 -122.437320479018 (37.7816739348974, -122.437320479018) 15 5 11 29490 41
11098 99478 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 650X Miramar Ave 4 Median : Yard Tree Private 2   01/15/2013 12:00:00 AM 30 15x280 Permit Number 769506 5995425.4 2093662.3 37.728535605791 -122.458085302932 (37.728535605791, -122.458085302932) 9 7 4 28861 40
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
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
11512 205516 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 309 San Fernando Way 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5992122.52237 2094864.24873 37.7316455276108 -122.469590887926 (37.7316455276108, -122.469590887926) 9 8 4 59 40
11636 249410 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 698 Polk St 1 : Tree Private 2     17 Width 3ft   6007114.55441 2113257.76141 37.7830049436594 -122.419064511231 (37.7830049436594, -122.419064511231) 7 9 9 28852 36
11685 122149 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 159 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   5991148.17044 2114368.07321 37.7851415048457 -122.47438213241 (37.7851415048457, -122.47438213241) 11 6 2 54 26
11714 24315 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600X Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6006566.61253 2112551.64159 37.7810352395317 -122.420910018978 (37.7810352395317, -122.420910018978) 7 9 11 28852 41
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
11851 124059 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401 Funston Ave 1 Sidewalk: Curb side : Yard Tree Private 2     20 Width 3ft   5991855.82446 2112441.44184 37.7798924782755 -122.471793433921 (37.7798924782755, -122.471793433921) 11 6 2 54 11
11876 5083 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2566 Diamond St 1 Sidewalk: Curb side : Cutout Tree DPW 1     75 3X3   6002238.2938951 2096914.6597978 37.7378549419938 -122.434765273064 (37.7378549419938, -122.434765273064) 2 7 5 63 7
11933 189475 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 149 Brannan St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6015929.94321 2113614.84757 37.7844778955793 -122.388591553884 (37.7844778955793, -122.388591553884) 6 2 9 28856 6
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                    
11953 189434 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 301 Mendell St 3 : Tree Private 2     12 Width 3ft   6016859.57023 2097844.08748 37.7412262239015 -122.384276612087 (37.7412262239015, -122.384276612087) 10 3 8 58 1
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
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
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
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
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
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                    
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
12883 255123 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 1 Sidewalk: Property side : Yard Tree DPW 1                              
12893 24392 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 699X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8   06/21/1995 12:00:00 AM 12 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 40
12920 175992 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500 Geneva Ave 9 Sidewalk: Property side : Yard Tree Private 2     21 Width 5ft   5998869.40884 2090603.99979 37.7203355078481 -122.445959349454 (37.7203355078481, -122.445959349454) 9 7 6 28861 25
13040 261562 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1801 25th St 7 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
13046 112126 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 8245 Geary Blvd   Sidewalk: Curb side : Cutout Tree Private 2     55 3x3   5981385.27932 2112314.25515 37.7789318748139 -122.508005614464 (37.7789318748139, -122.508005614464) 11 6 2 55 26
13061 111232 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2601X 15TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991704 2097685 37.7393664008113 -122.471243228199 (37.7393664008113, -122.471243228199) 1 8 4 29491 40
13507 184527 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1961 48th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5981338.0835 2101535.3662 37.7493333765729 -122.507368946557 (37.7493333765729, -122.507368946557) 1 8 3 29491 35
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
13816 99468 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 600X Miramar Ave 4 Median : Cutout Tree Private 2     6 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
14022 139534 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2139 O'Farrell St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6001083.2761 2113123.1868 37.7822939527692 -122.439920553002 (37.7822939527692, -122.439920553002) 15 5 11 29490 41
14179 257990 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1299x Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004575 2113275 37.7829089401984 -122.427851556708 (37.7829089401984, -122.427851556708) 7 9 11 29490 41
14358 206311 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 145 Majestic Ave 1 : Tree Private 2     16 Width 3ft   5996946.82319 2089129.17686 37.7161760165962 -122.452498687872 (37.7161760165962, -122.452498687872) 9 8 6 28861 24
14784 141149 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1934 O'Farrell St 8 Sidewalk: Curb side : Cutout Tree Private 2     33 Width 0ft   6001965.0616 2113298.9081 37.7828265946555 -122.436882555626 (37.7828265946555, -122.436882555626) 13 5 11 29490 41
14878 104430 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 73-75 MIRABEL AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3 Permit Number 770914 6007834 2100080 37.7468623651304 -122.415642186435 (37.7468623651304, -122.415642186435) 2 7 7 28859 2
14949 206319 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500 Junipero Serra Blvd 45 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5991343.42057 2093507.86668 37.7278761829176 -122.472185537258 (37.7278761829176, -122.472185537258) 9 8 4 64 40
15048 189404 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1180 De Haro St 2 Sidewalk: Curb side : Pot Tree Private 2     17 Width 3ft   6012199.54355 2102869.99992 37.7547675318026 -122.40074242533 (37.7547675318026, -122.40074242533) 10 3 8 28856 29
15052 1279 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3995X Alemany Blvd 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
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
15339 222951 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 400 Duboce Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6003922.8139 2108399.31131 37.7694845845646 -122.429759978361 (37.7694845845646, -122.429759978361) 7 9 5 29492 10
15382 248899 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 4007 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     32 Width 3ft   6001751.7117 2102909.07323 37.7542865483021 -122.436876628447 (37.7542865483021, -122.436876628447) 2 4 5 28862 22
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
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
15588 120716 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 154 21st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   5989318.46493 2114336.78774 37.7849494287395 -122.480709979349 (37.7849494287395, -122.480709979349) 11 6 2 55 26
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
15641 48745 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
15643 212158 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1340 Monterey Blvd 1 Sidewalk: Property side : Yard Tree Private 2     19 Width 10ft   5993891.68041 2094668.02643 37.7312088402015 -122.463460369625 (37.7312088402015, -122.463460369625) 9 8 4 59 40
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
15723 105168 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 4755X 03RD ST 2 Front Yard : Cutout Tree Arts Commission 19     23 3x3 Permit Number 770204 6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
15776 245828 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 151 Florida St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6009169.65844 2107587.30571 37.7675507193221 -122.411553908588 (37.7675507193221, -122.411553908588) 8 4 7 28853 19
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
15888 16825 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2139X OFARRELL ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6001076 2113135 37.7823259746064 -122.439946572306 (37.7823259746064, -122.439946572306) 15 5 11 29490 41
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
15938 248756 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 439 Shotwell St 15 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6007844.54725 2105467.77556 37.7616565644138 -122.415987193962 (37.7616565644138, -122.415987193962) 2 4 7 28859 19
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
16175 206292 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1273 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM 14 3x4 Permit Number 10064 5995766.39546 2106910.95096 37.764932686723 -122.457864799544 (37.764932686723, -122.457864799544) 15 5 11 56 12
16242 100094 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 11X Shotwell St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007856.7 2107724 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
16305 222125 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3772 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6003278.47263 2103621.8407 37.7563302945281 -122.431647592373 (37.7563302945281, -122.431647592373) 2 4 5 28862 3
16543 222123 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3766 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6003315.09234 2103619.46185 37.7563258383857 -122.431520778958 (37.7563258383857, -122.431520778958) 2 4 5 28862 3
16569 248863 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3224 23rd St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007411.22947 2102674.7075 37.7539630702642 -122.417287932915 (37.7539630702642, -122.417287932915) 2 4 7 28859 19
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
16677 12369 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1335 Laguna St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6004408.00965 2113459.2839 37.7834054897746 -122.428442413333 (37.7834054897746, -122.428442413333) 7 9 11 29490 41
16776 248830 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 511 Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     32 Width 5ft   6006940.05316 2097940.07234 37.7409363121555 -122.41858165623 (37.7409363121555, -122.41858165623) 2 7 7 28859 2
16795 189397 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1851 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6011825.915 2106039.85924 37.7634504169379 -122.402257398966 (37.7634504169379, -122.402257398966) 8 3 8 28856 29
16946 189444 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 201 Mendell St 7 : Tree Private 2     18 Width 4ft   6017009.92172 2098163.28563 37.7421109895326 -122.383778964147 (37.7421109895326, -122.383778964147) 10 3 8 58 1
17014 189420 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1751 22nd St 7 Sidewalk: Property side : Yard Tree Private 2     14 Width 3ft   6012859.34416 2103757.23618 37.7572404677783 -122.39852289312 (37.7572404677783, -122.39852289312) 10 3 8 28856 29
17024 248778 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 172 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6006028.35698 2096346.83132 37.7365102591456 -122.421620838654 (37.7365102591456, -122.421620838654) 2 7 7 28859 2
17215 212029 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 80 San Leandro Way 3 Sidewalk: Curb side : Yard Tree Private 2     20 Width 8ft   5992352.59251 2096080.713 37.7349989286488 -122.468883987517 (37.7349989286488, -122.468883987517) 1 8 4 59 40
17229 262360 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 241 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001078 2098361 37.7417603103416 -122.438880584073 (37.7417603103416, -122.438880584073) 2 7 5 63 7
17242 253971 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
17272 11727 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 899X Junipero Serra Blvd 22 Sidewalk: Curb side : Cutout Tree PUC 8   06/15/1995 12:00:00 AM 12 3X3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960662 (37.7216528879997, -122.47220960662) 9 8 4 64 40
17286 24406 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 999X Junipero Serra Blvd 11 Sidewalk: Curb side : Cutout Tree PUC 8   01/28/2000 12:00:00 AM 6 3x3   5991260.9047733 2090529.2081036 37.7196927494004 -122.472253753748 (37.7196927494004, -122.472253753748) 9 8 6 64 24

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