Street_Tree_List

Data source: data.sfgov.org

3,530 rows where qSpecies = 60 sorted by DBH

View and edit SQL

Suggested facets: qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH ▼ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
187 251248 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 829 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6001839.0 2095802.0 37.7347771581377 -122.436066227259 (37.7347771581377, -122.436066227259)
197 251245 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 701 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/04/1992 12:00:00 AM       6002463.96916 2095671.24377 37.73445361741221 -122.433896153002 (37.7344536174122, -122.433896153002)
813 251390 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Bosworth St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       Width 3ft   6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
821 251392 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Bosworth St 9 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2       Width 3ft   6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1438 251533 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1201X Pierce St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   6002292.0 2112799.0 37.7814725496882 -122.43571571002899 (37.7814725496882, -122.435715710029)
1453 251535 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2799 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6002520.0 2095715.0 37.734576941489294 -122.433705562416 (37.7345769414893, -122.433705562416)
1471 251536 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2799 Diamond St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6002520.0 2095715.0 37.734576941489294 -122.433705562416 (37.7345769414893, -122.433705562416)
1614 251637 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1640 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6002593.76659 2112688.5347700003 37.7811863760687 -122.43466384314199 (37.7811863760687, -122.434663843142)
4673 253651 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 131 Font Blvd 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
5515 48743 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 46023          
6135 48746 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 46023          
6959 48747 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 46023          
7180 48749 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 46023          
8095 50823 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/19/2004 12:00:00 AM     Permit Number 47344          
8773 48750 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 46023          
8939 48748 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 46023          
9025 48744 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 46023          
9474 173600 Property Tree 7 Corymbia ficifolia :: Red Flowering Gum 60 500 Clarendon Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5996184.0 2102497.0 37.7528370823128 -122.45610127186899 (37.7528370823128, -122.456101271869)
9685 111779 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 356 Marietta Dr 4 Median : Cutout 11 Tree 1 DPW 2       5   5999368.0 2097504.0 37.7393097549515 -122.44473159198601 (37.7393097549515, -122.444731591986)
9864 173715 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 4143 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x9   6002772.0 2104111.0 37.7576446879549 -122.43343410325701 (37.7576446879549, -122.433434103257)
10109 114554 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1200x 43RD AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5982778.0 2106905.0 37.764161588502795 -122.50278719613199 (37.7641615885028, -122.502787196132)
10143 58653 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1041 Stanyan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/10/1979 12:00:00 AM   3x3 Permit Number 17875 5997239.92048014 2106921.18918515 37.7650453439116 -122.45276901450501 (37.7650453439116, -122.452769014505)
10338 30354 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/17/1956 12:00:00 AM     Permit Number 43          
13264 187632 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 268 Sadowa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5994314.0 2087800.0 37.7123752149716 -122.461502613047 (37.7123752149716, -122.461502613047)
13566 48742 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 46023          
14417 48751 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 46023          
15637 48745 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 46023          
16097 104813 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 1601X Portola Dr 5 Front Yard : Yard 7 Tree 1 Private 1                    
16857 50824 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/19/2004 12:00:00 AM     Permit Number 47344          
17838 110450 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 56 HANCOCK ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003933.0 2105145.0 37.760549606286396 -122.429492630385 (37.7605496062864, -122.429492630385)
18367 99991 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 600@Clay Montgomery St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 44594 6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063)
19062 50066 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 406 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2003 12:00:00 AM     Permit Number 46794 6003569.14495563 2105912.6827965 37.7626368713078 -122.430805824209 (37.7626368713078, -122.430805824209)
30547 54566 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1312 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/18/1972 12:00:00 AM   3x3 Permit Number 10364 6000274.16247872 2109249.10106233 37.7716106075543 -122.44244149612 (37.7716106075543, -122.44244149612)
34298 102410 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 55X Lyon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6000310.8 2109142.0 37.7713186232103 -122.442307075209 (37.7713186232103, -122.442307075209)
51327 97306 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 47 Kittredge Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5997949.8 2111441.7 37.777498158560796 -122.450639669067 (37.7774981585608, -122.450639669067)
63415 33467 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 72 Coleridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/25/1996 12:00:00 AM     Permit Number 37623 6006783.56593714 2099291.50343979 37.744638227793395 -122.419218573599 (37.7446382277934, -122.419218573599)
65725 99970 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2270 Folsom St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6007986.9 2105322.2 37.761264849910205 -122.415484545241 (37.7612648499102, -122.415484545241)
66741 50805 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1498 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/09/2004 12:00:00 AM     Permit Number 47329 6000596.76427703 2111027.41746177 37.7765117981927 -122.441453229456 (37.7765117981927, -122.441453229456)
71511 104957 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 759 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
72582 34885 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1539 Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 38493 6002855.27225509 2121286.11305956 37.804807956300394 -122.43437403696699 (37.8048079563004, -122.434374036967)
76127 50574 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2295 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/18/2003 12:00:00 AM     Permit Number 47188 6008194.0 2105070.0 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926)
77327 33952 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1 Arbor St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/09/1997 12:00:00 AM     Permit Number 37910 6002287.323724099 2097040.91143479 37.7382043832783 -122.43460477820899 (37.7382043832783, -122.434604778209)
77439 33533 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 185 Bocana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/25/1996 12:00:00 AM     Permit Number 37643 6007275.34853053 2097937.54990535 37.7409482571652 -122.41742214701401 (37.7409482571652, -122.417422147014)
77484 97635 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1254 Jackson St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6008163.0 2117572.0 37.794909774633105 -122.415742887246 (37.7949097746331, -122.415742887246)
77642 120125 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 620 El Camino Del Mar 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5986678.0 2115081.0 37.786839000237705 -122.489899771602 (37.7868390002377, -122.489899771602)
77699 50634 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2900 Jennings St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/14/2004 12:00:00 AM     Permit Number 47740 6014120.76360854 2090918.26429059 37.722057508368394 -122.39326197707399 (37.7220575083684, -122.393261977074)
77803 86893 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2500 Mason St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/24/2007 12:00:00 AM   3x3 Permit Number 49821 6008765.0 2122158.0 37.8075356107649 -122.413984454109 (37.8075356107649, -122.413984454109)
77943 115998 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 143 ASHBURY ST   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998718.0 2110172.0 37.7740558300516 -122.447890785953 (37.7740558300516, -122.447890785953)
77978 50685 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 915 Ashbury St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47258 5999168.89515798 2107036.01925898 37.765470983210896 -122.44610545370399 (37.7654709832109, -122.446105453704)
78017 99966 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2270 Folsom St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6007986.9 2105322.2 37.761264849910205 -122.415484545241 (37.7612648499102, -122.415484545241)
78022 50314 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1055 Ellis St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/22/2003 12:00:00 AM     Permit Number 47021 6005825.34130744 2113438.50468071 37.783428536862395 -122.42353751818999 (37.7834285368624, -122.42353751819)
78069 51559 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 29 West Clay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47854 5988768.43262818 2115023.56671426 37.7868031451511 -122.48266323691001 (37.7868031451511, -122.48266323691)
78254 100023 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 600 Montgomery St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063)
78281 111082 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 130 JUNIPERO SERRA BLVD 1 Median : Cutout 11 Tree 1 Private 1       3x3   5991393.0 2095322.0 37.7328602072681 -122.472146321186 (37.7328602072681, -122.472146321186)
78428 103592 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 10X Hermann St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6005031.0649 2108842.56611 37.7707643495235 -122.42595813798201 (37.7707643495235, -122.425958137982)
78466 111235 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2601X 15TH AVE 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991704.0 2097685.0 37.73936640081129 -122.471243228199 (37.7393664008113, -122.471243228199)
78495 121113 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 450 Stanyan St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     5x5   5996840.32777146 2110125.42661407 37.7738204478349 -122.45438257610901 (37.7738204478349, -122.454382576109)
78551 38221 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 140 Chester Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/1998 12:00:00 AM     Permit Number 40348 5991708.17687703 2088279.9583595002 37.7135427330302 -122.470543976889 (37.7135427330302, -122.470543976889)
78769 116833 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 1750 Geneva Ave 1 Front Yard : Yard 7 Tree 1 Private 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
78924 41636 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 727 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/01/2000 12:00:00 AM     Permit Number 42114 6002231.96646512 2108774.97906552 37.7704201835081 -122.43563542227899 (37.7704201835081, -122.435635422279)
78943 102413 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1301 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       9x6   6000345.0 2109213.0 37.77151552050871 -122.44219387377399 (37.7715155205087, -122.442193873774)
79094 114460 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1462 UNION ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6005986.0 2118991.0 37.7986833693446 -122.423376553534 (37.7986833693446, -122.423376553534)
79506 117197 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 70 CERRITOS AVE 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       10x6   5992485.0 2092977.0 37.7264845532002 -122.4682005031 (37.7264845532002, -122.4682005031)
79553 114178 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1x SHRADER ST 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997234.0 2110523.0 37.774934649960606 -122.453049512511 (37.7749346499606, -122.453049512511)
79797 114240 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 99x FONT BLVD 16 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
79856 51669 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 852@ DIAMOND Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/11/2005 12:00:00 AM     Permit Number 47947 6001771.23876172 2095874.53487777 37.734972472287104 -122.43630569021099 (37.7349724722871, -122.436305690211)
79986 49370 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 470 REVISED West Portal Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/19/2003 12:00:00 AM     Permit Number 46343 5991620.22800025 2096213.28684732 37.735320603541204 -122.471425664133 (37.7353206035412, -122.471425664133)
80226 99208 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2 Hahn St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 768718 6007772.4 2088271.5 37.7144353163031 -122.415019520784 (37.7144353163031, -122.415019520784)
80282 121422 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2466 Francisco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5999524.0 2119846.0 37.800664141980704 -122.44579857739599 (37.8006641419807, -122.445798577396)
80381 100004 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 600@Washington St Montgomery St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063)
80480 100029 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 600 Montgomery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063)
80498 115704 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2820 LAKE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x15   5986689.0 2114483.0 37.7851977068092 -122.489817718558 (37.7851977068092, -122.489817718558)
80750 99968 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2270 Folsom St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6007986.9 2105322.2 37.761264849910205 -122.415484545241 (37.7612648499102, -122.415484545241)
80769 107162 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 798X 07TH AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5993812.0 2110401.0 37.7744029620428 -122.464877983618 (37.7744029620428, -122.464877983618)
80970 33511 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 30 Coleridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/25/1996 12:00:00 AM     Permit Number 37606 6006939.76943127 2099579.03687854 37.7454365257217 -122.41869883835899 (37.7454365257217, -122.418698838359)
80978 94439 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 598 Belvedere St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5998670.0 2105688.0 37.7617411583254 -122.447733959945 (37.7617411583254, -122.447733959945)
80983 50445 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1458 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47092 5999576.80908785 2109151.13897488 37.7713018555978 -122.44484663077499 (37.7713018555978, -122.444846630775)
81000 57042 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 201@ Page Central Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/21/1974 12:00:00 AM     Permit Number 14305. Tree 1 on Page St 5999842.06289616 2109172.2578569 37.7713749769665 -122.44393062683201 (37.7713749769665, -122.443930626832)
81041 49157 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 116 Clipper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/23/2003 12:00:00 AM     Permit Number 46278 6004391.65758992 2101053.62273947 37.749341603598204 -122.42761484309999 (37.7493416035982, -122.4276148431)
81062 30494 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 245 Bemis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/1956 12:00:00 AM     Permit Number 153 6003080.18850262 2096294.42354032 37.736199676901705 -122.431810162156 (37.7361996769017, -122.431810162156)
81258 99089 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2801@Broderick Broadway 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6000146.4 2117058.8 37.7930467467367 -122.44344450483601 (37.7930467467367, -122.443444504836)
81469 98319 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1811 Pierce St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001987.8 2114705.4 37.786689755292 -122.436904612265 (37.786689755292, -122.436904612265)
81543 115936 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 500X LAKE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   5993877.0 2114929.0 37.786839375345004 -122.46498206022801 (37.786839375345, -122.464982060228)
81752 116834 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 1750 Geneva Ave 2 Front Yard : Yard 7 Tree 1 Private 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
81894 101361 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1303 Larkin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007113.6 2115829.0 37.7900648810449 -122.419250267251 (37.7900648810449, -122.419250267251)
81985 98551 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 290X Brighton Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x5.5   5996260.0 2091802.8 37.723477781170295 -122.45506574958999 (37.7234777811703, -122.45506574959)
82044 33219 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 100 Vasquez Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/06/1996 12:00:00 AM     Permit Number 37411 5995201.63425474 2099773.01638321 37.745301271936604 -122.459301205113 (37.7453012719366, -122.459301205113)
82161 114181 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1x SHRADER ST 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997234.0 2110523.0 37.774934649960606 -122.453049512511 (37.7749346499606, -122.453049512511)
82373 121115 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 450 Stanyan St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     5x5   5996840.32777146 2110125.42661407 37.7738204478349 -122.45438257610901 (37.7738204478349, -122.454382576109)
82664 94440 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 598 Belvedere St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998670.0 2105688.0 37.7617411583254 -122.447733959945 (37.7617411583254, -122.447733959945)
83274 99496 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1400X Plymouth Ave 3 Median : Cutout 11 Tree 1 Private 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
83324 109180 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 301x 28TH ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003894.0 2099493.0 37.7450283339929 -122.42922448756201 (37.7450283339929, -122.429224487562)
83354 33464 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 52 Coleridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/25/1996 12:00:00 AM     Permit Number 37617 6006854.98101405 2099423.3660818003 37.7450043146116 -122.418980984578 (37.7450043146116, -122.418980984578)
83492 100027 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 600 Montgomery St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063)
83720 115376 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 500 BUCHANAN ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6004637.0 2110246.0 37.7745955592359 -122.427421211008 (37.7745955592359, -122.427421211008)
83962 112105 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 208 WARREN DR 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5994949.0 2102924.0 37.7539385499463 -122.46040303664 (37.7539385499463, -122.46040303664)
84125 52252 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 237 San Carlos St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/22/2005 12:00:00 AM     Permit Number 48419 6006717.04487845 2104738.84078637 37.7595916236736 -122.419835049965 (37.7595916236736, -122.419835049965)
84191 101134 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1477 Grove St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6000788.3 2110635.6 37.775446876390205 -122.44076254186001 (37.7754468763902, -122.44076254186)
84602 47600 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 100 Alemany Blvd 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/20/2002 12:00:00 AM     Permit Number 45435 6009710.93340167 2096438.06354235 37.7369677288425 -122.408894986555 (37.7369677288425, -122.408894986555)
84676 105867 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 3555 Cesar Chavez St 2 Front Yard : Yard 7 Tree 1 Private 1           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 2763.343ms · Data source: data.sfgov.org