Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77943 | 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) | |||||
| 78453 | 78453 | 102458 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3267 20th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6008409.0 | 2104449.0 | 37.7588909590293 | -122.413962902008 | (37.7588909590293, -122.413962902008) | ||||
| 92060 | 92060 | 87052 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 511 Euclid Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 50168 | 5996764.3 | 2113789.0 | 37.783875296894294 | -122.45491032952499 | (37.7838752968943, -122.454910329525) | |||
| 96965 | 96965 | 112126 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 8245 Geary Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3x3 | 5981385.27932 | 2112314.25515 | 37.7789318748139 | -122.508005614464 | (37.7789318748139, -122.508005614464) | ||||
| 99967 | 99967 | 108018 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 109 ALPINE TER | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x7 | 6001716.4 | 2108199.1 | 37.7688096651516 | -122.43737752181002 | (37.7688096651516, -122.43737752181) | ||||
| 116115 | 116115 | 104650 | Private 5 | Corymbia ficifolia :: Red Flowering Gum 60 | 346 LAKE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 10x8 | 5994385.6 | 2114927.2 | 37.7868637456835 | -122.46322230514099 | (37.7868637456835, -122.463222305141) | ||||
| 116646 | 116646 | 105767 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 245 RUTLEDGE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | 6010031.3 | 2099465.2 | 37.7452975299559 | -122.40800074456999 | (37.7452975299559, -122.40800074457) | ||||
| 122131 | 122131 | 85112 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4201 22nd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51811 | 6001198.0 | 2102882.0 | 37.7541807256906 | -122.43878955892201 | (37.7541807256906, -122.438789558922) | |||
| 124247 | 124247 | 88364 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2559 33rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51343 | 5986101.6 | 2097823.5 | 37.739421027827 | -122.490623769288 | (37.739421027827, -122.490623769288) | |||
| 187 | 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 | 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) | ||||
| 492 | 492 | 173939 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 570 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2017 12:00:00 AM | 3 | 5xt | Permit Number 779890 | 6014341.0 | 2104455.0 | 37.7592388085315 | -122.39344754111201 | (37.7592388085315, -122.393447541112) | |
| 526 | 526 | 18856 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2201 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004191.661859999 | 2115995.22985 | 37.790356315029996 | -122.429371791378 | (37.79035631503, -122.429371791378) | |||
| 662 | 662 | 206411 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 241 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | Permit Number 779935 | 5993240.35303 | 2102520.36003 | 37.752731819221 | -122.466282559112 | (37.752731819221, -122.466282559112) | ||
| 794 | 794 | 212187 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002096.28779 | 2095466.30888 | 37.733870041163 | -122.435152693763 | (37.733870041163, -122.435152693763) | ||||
| 804 | 804 | 216488 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/1998 12:00:00 AM | 0 | Width 3ft | 6001838.4009 | 2095488.4107 | 37.7339160801534 | -122.43604586623002 | (37.7339160801534, -122.43604586623) | ||
| 922 | 922 | 140943 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 925 | 925 | 139814 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1652 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6002517.0 | 2112708.0 | 37.7812354643217 | -122.434930809638 | (37.7812354643217, -122.434930809638) | |||
| 1438 | 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 | 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) | ||||
| 1543 | 1543 | 141557 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 524 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6000673.0 | 2110815.0 | 37.7759328964671 | -122.44117426506 | (37.7759328964671, -122.44117426506) | |||
| 1614 | 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) | ||||
| 1636 | 1636 | 139812 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1624 EDDY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1997 12:00:00 AM | 32 | Width 0ft | 6002737.4248 | 2112708.2774 | 37.7812487388446 | -122.434168269296 | (37.7812487388446, -122.434168269296) | ||
| 1832 | 1832 | 24314 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006601.99404 | 2112547.97273 | 37.781027160014204 | -122.420787355977 | (37.7810271600142, -122.420787355977) | |||
| 2401 | 2401 | 140740 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2057X O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6001431.032000001 | 2113174.7073 | 37.7824552046492 | -122.438721167537 | (37.7824552046492, -122.438721167537) | |||
| 2542 | 2542 | 4384 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X14 | 6001725.16099 | 2095738.6738900002 | 37.7345968111862 | -122.43645527631 | (37.7345968111862, -122.43645527631) | |||
| 2614 | 2614 | 248773 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5999776.82694 | 2101824.96428 | 37.751197407653706 | -122.44362838043999 | (37.7511974076537, -122.44362838044) | |||
| 2628 | 2628 | 248767 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5999684.377780001 | 2101641.28638 | 37.750687799606105 | -122.443934882898 | (37.7506877996061, -122.443934882898) | |||
| 2693 | 2693 | 98923 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3527 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5997962.31773 | 2115134.58282 | 37.7876385629149 | -122.450862707746 | (37.7876385629149, -122.450862707746) | |||
| 2800 | 2800 | 248806 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1039 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1979 12:00:00 AM | 18 | Width 4ft | Permit Number 17875 | 5997248.91757 | 2106862.4287 | 37.7648845181415 | -122.45273365463001 | (37.7648845181415, -122.45273365463) | |
| 2873 | 2873 | 41127 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2049 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) |
| 3045 | 3045 | 141431 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 501 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2005 12:00:00 AM | 17 | Width 0ft | Permit Number 48304 | 6005404.7905 | 2110954.8993 | 37.776585419130896 | -122.42481571306601 | (37.7765854191309, -122.424815713066) | |
| 3053 | 3053 | 126134 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2829 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | Permit Number 779774 | 6000559.90395 | 2118036.87537 | 37.7957558571972 | -122.44208400078101 | (37.7957558571972, -122.442084000781) | ||
| 3357 | 3357 | 32073 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3254 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Permit Number 35447 | 5999189.55674 | 2115674.61094 | 37.7891915158244 | -122.44665558658701 | (37.7891915158244, -122.446655586587) | |||
| 3490 | 3490 | 141187 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1802 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 25 | Width 0ft | 6002206.3563 | 2112987.8984 | 37.7819863518957 | -122.436025516484 | (37.7819863518957, -122.436025516484) | |||
| 4330 | 4330 | 70503 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 193 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 7 | 6004252.47977 | 2092436.6780400001 | 37.725673555265395 | -122.42748232385901 | (37.7256735552654, -122.427482323859) | ||
| 4673 | 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) | ||||
| 5253 | 5253 | 222095 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 116 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 39 | 12x9 | 6004345.11847 | 2101047.98994 | 37.7493235046981 | -122.427775375138 | (37.7493235046981, -122.427775375138) | |||
| 5515 | 5515 | 48743 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 5977 | 5977 | 98925 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3541 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | 5997905.152000001 | 2115121.83421 | 37.7876002859601 | -122.45105956936399 | (37.7876002859601, -122.451059569364) | |||
| 6446 | 6446 | 107232 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2265 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6006749.11596 | 2119031.04722 | 37.7988363688534 | -122.420738768293 | (37.7988363688534, -122.420738768293) | |||
| 7016 | 7016 | 22573 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006249.787140001 | 2112806.77447 | 37.781717908586295 | -122.422024207046 | (37.7817179085863, -122.422024207046) | |||
| 7149 | 7149 | 23486 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005800.3407 | 2119014.80575 | 37.7987382537111 | -122.424020688524 | (37.7987382537111, -122.424020688524) | |||
| 7248 | 7248 | 65393 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1345 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/1989 12:00:00 AM | 22 | Permit Number 28235 | 6008898.78625 | 2117545.17326 | 37.7948774497893 | -122.41319505442 | (37.7948774497893, -122.41319505442) | ||
| 7803 | 7803 | 98047 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2251 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003407.78151 | 2116869.84399 | 37.7927133715759 | -122.43214644721901 | (37.7927133715759, -122.432146447219) | |||
| 7840 | 7840 | 19005 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3067 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000119.97054 | 2115432.29592 | 37.788579285248495 | -122.443419066834 | (37.7885792852485, -122.443419066834) | |||
| 7904 | 7904 | 23169 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 202X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006882.10264 | 2111252.84384 | 37.777486833097896 | -122.419726396954 | (37.7774868330979, -122.419726396954) | |||
| 8791 | 8791 | 117119 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 447 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 5x9 | Permit Number 778563 | 5997182.09338 | 2114812.8648 | 37.78671051561479 | -122.45353887881001 | (37.7867105156148, -122.45353887881) | |
| 9022 | 9022 | 105217 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5999896.62594 | 2116125.07257 | 37.7904687293982 | -122.44424160568998 | (37.7904687293982, -122.44424160569) | |||
| 9050 | 9050 | 1999 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 217 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 38 | 3X3 | 6007148.9837828 | 2097704.1672577998 | 37.7403003295941 | -122.417842531543 | (37.7403003295941, -122.417842531543) | |||
| 9093 | 9093 | 12590 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 521 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 11 | 4x4 | 5993790.57771 | 2114837.48993 | 37.786583130222 | -122.465274409298 | (37.786583130222, -122.465274409298) | ||
| 9163 | 9163 | 17982 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2578 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6001610.4943389995 | 2114985.9919613 | 37.7874387369759 | -122.43823010545499 | (37.7874387369759, -122.438230105455) | |||
| 9177 | 9177 | 10667 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1021 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6002954.21433 | 2110590.33753 | 37.7754457061984 | -122.43326690297701 | (37.7754457061984, -122.433266902977) | |||
| 9275 | 9275 | 9356 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 241 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 6000999.4900667 | 2098404.1035626 | 37.74187419547079 | -122.43915513344 | (37.7418741954708, -122.43915513344) | |||
| 9286 | 9286 | 4816 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 50X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 11x5 | 6005990.1672425 | 2097819.1039723 | 37.7405506369184 | -122.421857425384 | (37.7405506369184, -122.421857425384) | |||
| 9297 | 9297 | 5763 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 401 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6004052.45174 | 2108353.78487 | 37.7693669201086 | -122.429308319494 | (37.7693669201086, -122.429308319494) | |||
| 9301 | 9301 | 28308 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 244X CORTLAND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6006809.0 | 2097383.0 | 37.739399336612 | -122.418995288624 | (37.739399336612, -122.418995288624) | |||
| 9420 | 9420 | 12628 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 840 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 5992820.04588 | 2114852.30881 | 37.786567801977796 | -122.46863326133999 | (37.7865678019778, -122.46863326134) | |||
| 9450 | 9450 | 19167 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 95 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003517.6175946 | 2107764.5447227 | 37.767718716857 | -122.43111622226601 | (37.767718716857, -122.431116222266) | |||
| 9474 | 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) | ||||
| 9497 | 9497 | 122159 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 547 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 4ft | 5991246.192840001 | 2111684.05416 | 37.7777776077222 | -122.473847129053 | (37.7777776077222, -122.473847129053) | |||
| 9558 | 9558 | 122158 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 515 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 6ft | 5991239.57046 | 2111867.63351 | 37.7782812827035 | -122.47388343446801 | (37.7782812827035, -122.473883434468) | |||
| 9609 | 9609 | 97058 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 506 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 5991284.01792 | 2111924.69862 | 37.7784405421859 | -122.473733839825 | (37.7784405421859, -122.473733839825) | |||
| 9706 | 9706 | 5132 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2787 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 55 | 5X5 | 6002542.444802401 | 2095842.6422614 | 37.734928691439706 | -122.433637082687 | (37.7349286914397, -122.433637082687) | |||
| 9760 | 9760 | 2247 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 21 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002207.695280001 | 2095600.7924099998 | 37.734245627727 | -122.434777138659 | (37.734245627727, -122.434777138659) | |||
| 9805 | 9805 | 57857 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 491 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/1984 12:00:00 AM | 15 | Permit Number 779316 | 5992173.1495199995 | 2112167.2990599996 | 37.7791581122705 | -122.47067570242599 | (37.7791581122705, -122.470675702426) | ||
| 9864 | 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 | 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 | 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 | 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 | |||||||||
| 10466 | 10466 | 1196 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3080 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 28 | 3X3 | 5996438.01379 | 2087205.1874 | 37.7108640234246 | -122.45411848649799 | (37.7108640234246, -122.454118486498) | ||
| 10725 | 10725 | 941 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1352 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 5x5 | 6002586.79672 | 2094029.0615 | 37.7299515286195 | -122.43335418993799 | (37.7299515286195, -122.433354189938) | |||
| 11180 | 11180 | 103669 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 20 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2016 12:00:00 AM | 3 | 3x3 | 6010632.36965 | 2089377.76421 | 37.717633192597205 | -122.40521212966298 | (37.7176331925972, -122.405212129663) | ||
| 12526 | 12526 | 104428 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 390 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 4x4 | 6010699.78768 | 2089233.16834 | 37.7172399307634 | -122.404968919684 | (37.7172399307634, -122.404968919684) | |||
| 13264 | 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) | ||||
| 13443 | 13443 | 14968 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016667.040519999 | 2097697.80462 | 37.7408139135396 | -122.384932128834 | (37.7408139135396, -122.384932128834) | |||
| 13625 | 13625 | 14933 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016941.57525 | 2098184.84614 | 37.7421664120423 | -122.384016788063 | (37.7421664120423, -122.384016788063) | |||
| 13902 | 13902 | 14887 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 151 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2006 12:00:00 AM | 3 | 3x3 | 6017068.53164 | 2098456.8281 | 37.7429202372855 | -122.38359673900699 | (37.7429202372855, -122.383596739007) | ||
| 14289 | 14289 | 102315 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2325 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x6 | 6010497.0299 | 2105967.33167 | 37.7631770050447 | -122.40684849557199 | (37.7631770050447, -122.406848495572) | |||
| 14499 | 14499 | 35359 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 917 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 28 | 6x6 | Permit Number 38821 | 6011905.65469 | 2104108.25722 | 37.758151117709104 | -122.40184581615 | (37.7581511177091, -122.40184581615) |
| 15356 | 15356 | 54446 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 661 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1972 12:00:00 AM | 30 | Permit Number 10224 | 6014152.690909999 | 2104085.93791 | 37.7582149794585 | -122.394072973006 | (37.7582149794585, -122.394072973006) | ||
| 15460 | 15460 | 14875 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 50 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017137.53448 | 2098765.92965 | 37.7437727810994 | -122.383379656173 | (37.7437727810994, -122.383379656173) | |||
| 15691 | 15691 | 11881 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017730.140319999 | 2096877.36865 | 37.7386199049771 | -122.381199258841 | (37.7386199049771, -122.381199258841) | |||
| 15745 | 15745 | 106168 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1052 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6012164.747830001 | 2103476.70855 | 37.7564314799541 | -122.400905383382 | (37.7564314799541, -122.400905383382) | ||||
| 16035 | 16035 | 54185 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1526 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | 30 | 4x4 | Permit Number 9920 | 6015598.37895 | 2096494.31778 | 37.7374502170542 | -122.388543207207 | (37.7374502170542, -122.388543207207) | |
| 16335 | 16335 | 14985 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016500.60947 | 2097476.87493 | 37.740198078478706 | -122.385492197802 | (37.7401980784787, -122.385492197802) | |||
| 16857 | 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 | |||||||||
| 16938 | 16938 | 16130 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 339 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 5999827.96036 | 2094635.2259799999 | 37.73145901361271 | -122.442935300848 | (37.7314590136127, -122.442935300848) | |||
| 17040 | 17040 | 12655 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1016 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 6x21 | 5992294.67406 | 2114836.34542 | 37.7864936077921 | -122.47044973930201 | (37.7864936077921, -122.470449739302) | |||
| 17061 | 17061 | 5075 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2518X Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002273.67466 | 2097186.93566 | 37.7386045571491 | -122.434662408564 | (37.7386045571491, -122.434662408564) | |||
| 17200 | 17200 | 4330 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 831 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001821.43184 | 2095823.4199 | 37.7348349741444 | -122.436128498656 | (37.7348349741444, -122.436128498656) | |||
| 17365 | 17365 | 2069 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 843 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001701.031909999 | 2095490.9133099997 | 37.7339151466682 | -122.43652097087299 | (37.7339151466682, -122.436520970873) | |||
| 17406 | 17406 | 19187 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 125 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003528.70248 | 2107586.69801 | 37.7672310211182 | -122.43106518602501 | (37.7672310211182, -122.431065186025) | |||
| 17615 | 17615 | 12962 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 65 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6001964.35979 | 2095666.44125 | 37.734412066167394 | -122.435623121007 | (37.7344120661674, -122.435623121007) | |||
| 17626 | 17626 | 5082 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2563 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002286.6614 | 2096942.37452 | 37.7379337860994 | -122.434600024386 | (37.7379337860994, -122.434600024386) | |||
| 17705 | 17705 | 4348 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 924 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001433.25109 | 2095991.10142 | 37.735273327102796 | -122.43748257546999 | (37.7352733271028, -122.43748257547) | |||
| 17715 | 17715 | 16378 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Moraga St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 5991088.16435 | 2103840.65792 | 37.756232597572605 | -122.473821451692 | (37.7562325975726, -122.473821451692) | |||
| 17750 | 17750 | 2151 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1107 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001039.9865 | 2095675.11992 | 37.734383349014394 | -122.43881959664101 | (37.7343833490144, -122.438819596641) | |||
| 17765 | 17765 | 16205 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 508 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998710.56573 | 2094730.4194599998 | 37.7316566225543 | -122.44680517802401 | (37.7316566225543, -122.446805178024) | |||
| 17838 | 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) |
JSON shape: default, array, newline-delimited
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");