3,587 rows where qSpecies_id = 28 sorted by DBH

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)
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
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                              
498 260403 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500X Brotherhood Way 1 Median : Yard Tree Private 2       30x30   5992691 2087881 37.712504070633 -122.467118029673 (37.712504070633, -122.467118029673) 9 8 6 64 24
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
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                              
3631 260410 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 400X Brotherhood Way 10 Side Yard : Yard Tree Private 2       30x30   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
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
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                              
5246 262331 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 2140 Wawona St 1 Back Yard : Cutout Tree Private 2       3x3   5986390 2097232 37.7378137677629 -122.489583137449 (37.7378137677629, -122.489583137449) 1 8 3 29491 35
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
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                    
6611 262204 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 907 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001442 2095927 37.735097816857 -122.437447738546 (37.735097816857, -122.437447738546) 2 7 5 63 7
7147 260402 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10X Arch St 1 Median : Yard Tree DPW 1       3X5   5992587 2087523 37.7115150847083 -122.467451465905 (37.7115150847083, -122.467451465905) 9 8 4 64 24
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                    
7848 54566 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1312 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/1972 12:00:00 AM   3x3 Permit Number 10364 6000274.16247872 2109249.10106233 37.7716106075543 -122.44244149612 (37.7716106075543, -122.44244149612) 15 5 11 29492 9
7881 260404 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500X Brotherhood Way 2 Median : Yard Tree Private 2       30x30   5992691 2087881 37.712504070633 -122.467118029673 (37.712504070633, -122.467118029673) 9 8 6 64 24
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                    
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                    
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
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                    
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
10635 255127 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 5 Sidewalk: Property side : Yard Tree DPW 1                              
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
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                    
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
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                              
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
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
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
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                    
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
17595 255124 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 2 Sidewalk: Property side : Yard Tree DPW 1                              
17899 110754 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 500 COLE ST 3 Sidewalk: Curb side : Cutout Tree Private 2       6x4   5998015 2108858 37.770407716093 -122.450227838314 (37.770407716093, -122.450227838314) 15 5 11 29492 9
17905 260412 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 10X Brotherhood Way 1 Side Yard : Yard Tree Private 2       Width 0ft   5992928.58802 2087852.90738 37.7124406464989 -122.466294818667 (37.7124406464989, -122.466294818667) 9 8 4 64 24
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
18540 48750 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   8 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
18576 261447 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 317 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006993 2095799 37.7350603822594 -122.418246820854 (37.7350603822594, -122.418246820854) 2 7 7 28859 2
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                              
19587 260401 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3900 Alemany Blvd 2 Median : Yard Tree DPW 1       3X5   5992602.03225 2087509.49597 37.7114788737215 -122.467398529617 (37.7114788737215, -122.467398529617) 9 8 4 64 24
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
20259 26515 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2886 Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   6008938.68629 2101687.00134 37.7513368683627 -122.411935812817 (37.7513368683627, -122.411935812817) 2 4 7 28859 19
20402 257888 Property Tree 8 Corymbia ficifolia :: Red Flowering Gum 28 155X Magellan Ave 1 Front Yard : Yard Tree MTA 3       10x10   5995070 2100842 37.7482288640106 -122.459833790503 (37.7482288640106, -122.459833790503) 1 8 4 29491 40
20491 118331 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007461 2099574 37.7454520282724 -122.416896144845 (37.7454520282724, -122.416896144845) 2 7 7 28859 2
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
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
22417 58653 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1041 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1979 12:00:00 AM   3x3 Permit Number 17875 5997239.92048014 2106921.18918515 37.7650453439116 -122.452769014505 (37.7650453439116, -122.452769014505) 15 5 11 29492 12
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
24635 251248 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 829 Chenery St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6001839 2095802 37.7347771581377 -122.436066227259 (37.7347771581377, -122.436066227259) 2 7 5 63 7
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
24948 100206 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 155X Lundy's Ln 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006736.3 2098711.7 37.7430435558186 -122.4193408869 (37.7430435558186, -122.4193408869) 2 7 7 28859 2
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
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
25986 119612 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 200 Parnassus Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997281.95614032 2106749.56867224 37.7645765263283 -122.452611237527 (37.7645765263283, -122.452611237527) 15 5 11 29492 12
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
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
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
28235 122331 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 950X Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996124 2112291 37.7797254357482 -122.45701712634 (37.7797254357482, -122.45701712634) 11 6 2 54 16
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
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
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
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
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
29672 49691 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 450 Stanyan St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/21/2003 12:00:00 AM   tx5 Permit Number 46512 5996840.32777146 2110125.42661407 37.7738204478349 -122.454382576109 (37.7738204478349, -122.454382576109) 15 5 2 29492 16
29836 115998 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 143 ASHBURY ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998718 2110172 37.7740558300516 -122.447890785953 (37.7740558300516, -122.447890785953) 15 5 11 29492 16
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
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
30511 103595 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 10X Hermann St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
31425 103598 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 10X Hermann St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
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
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
32986 251533 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1201X Pierce St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6002292 2112799 37.7814725496882 -122.435715710029 (37.7814725496882, -122.435715710029) 15 5 11 29490 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
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
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
34612 115897 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 899X CHURCH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       6x11   6004447 2103700 37.7566110668577 -122.427611986325 (37.7566110668577, -122.427611986325) 2 4 5 28862 3
34737 111082 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 130 JUNIPERO SERRA BLVD 1 Median : Cutout Tree Private 2       3x3   5991393 2095322 37.7328602072681 -122.472146321186 (37.7328602072681, -122.472146321186) 1 8 4 64 40

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