Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22354 | 22354 | 223359 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 3743 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005373.19499 | 2104277.5139 | 37.7582491303058 | -122.42444994393401 | (37.7582491303058, -122.424449943934) | |||
| 26617 | 26617 | 126477 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 614 Grant Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010973.50945 | 2116764.5912 | 37.7928504165589 | -122.405961165984 | (37.7928504165589, -122.405961165984) | |||
| 27099 | 27099 | 126471 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 2000 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003422.09984 | 2118291.85345 | 37.7966186559675 | -122.432198504452 | (37.7966186559675, -122.432198504452) | |||
| 27583 | 27583 | 117884 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 630 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5982594.795609999 | 2111471.89498 | 37.776690193509495 | -122.503759083181 | (37.7766901935095, -122.503759083181) | |||
| 30225 | 30225 | 55598 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 630 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1973 12:00:00 AM | 2 | Permit Number 11572 | 5982593.753219999 | 2111454.7596299998 | 37.7766430835553 | -122.503761419712 | (37.7766430835553, -122.503761419712) | ||
| 32569 | 32569 | 126472 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 215 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000962.17552 | 2120602.22155 | 37.8028225355966 | -122.44087618968 | (37.8028225355966, -122.44087618968) | |||
| 36282 | 36282 | 64572 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 1022 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/1988 12:00:00 AM | 3 | Permit Number 25466 | 6009955.950180001 | 2117288.8075599996 | 37.7942328247337 | -122.409518999103 | (37.7942328247337, -122.409518999103) | |
| 39720 | 39720 | 176222 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 264 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005107.28236 | 2094052.8313 | 37.7301594662742 | -122.424642251348 | (37.7301594662742, -122.424642251348) | |||
| 45364 | 45364 | 176216 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 133 Craut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004049.42682 | 2094174.0697700002 | 37.7304325589062 | -122.428308032805 | (37.7304325589062, -122.428308032805) | |||
| 46236 | 46236 | 223360 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 643 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010140.84304 | 2105287.39353 | 37.761290112276 | -122.40803247911501 | (37.761290112276, -122.408032479115) | |||
| 48247 | 48247 | 142079 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 46 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998735.419 | 2110500.1358 | 37.774957802418 | -122.44785415940599 | (37.774957802418, -122.447854159406) | |||
| 48754 | 48754 | 126483 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 700 Grant Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010931.99435 | 2117065.2913900004 | 37.7936737449935 | -122.40612600542102 | (37.7936737449935, -122.406126005421) | |||
| 50695 | 50695 | 126479 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 614 Grant Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010965.179380001 | 2116818.07903 | 37.7929968153971 | -122.405993758332 | (37.7929968153971, -122.405993758332) | |||
| 52826 | 52826 | 126476 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 614 Grant Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010976.5327699995 | 2116742.64267 | 37.79279032025671 | -122.405949158227 | (37.7927903202567, -122.405949158227) | |||
| 52958 | 52958 | 126480 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 700 Grant Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010938.47214 | 2117002.6943099997 | 37.7935022308001 | -122.406099179531 | (37.7935022308001, -122.406099179531) | |||
| 53863 | 53863 | 126484 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 700 Grant Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010928.02315 | 2117089.46942 | 37.79373990992 | -122.406141450376 | (37.79373990992, -122.406141450376) | |||
| 54113 | 54113 | 223362 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 395 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003417.87405 | 2099194.80135 | 37.744182584162104 | -122.430849568164 | (37.7441825841621, -122.430849568164) | |||
| 58335 | 58335 | 126482 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 700 Grant Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010934.85343 | 2117044.17747 | 37.7936159311689 | -122.406114624512 | (37.7936159311689, -122.406114624512) | |||
| 59890 | 59890 | 126490 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 48 Spofford St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010571.46321 | 2117448.9719700003 | 37.794707066936205 | -122.407400541724 | (37.7947070669362, -122.407400541724) | |||
| 60264 | 60264 | 31123 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 566 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 3 | Permit Number 34841 | 5996994.20499 | 2094132.06978 | 37.7299154972969 | -122.45269577881399 | (37.7299154972969, -122.452695778814) | |
| 62708 | 62708 | 40708 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 104 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 2 | Permit Number 41687 | 6004089.96816 | 2094279.4373400002 | 37.7307241685755 | -122.428175381905 | (37.7307241685755, -122.428175381905) | |
| 62861 | 62861 | 207528 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 409 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5998634.18995 | 2094365.36748 | 37.730649912445294 | -122.447042962376 | (37.7306499124453, -122.447042962376) | |||
| 63242 | 63242 | 126485 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 730 Grant Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010918.9479 | 2117151.41752 | 37.7939094968665 | -122.406177218214 | (37.7939094968665, -122.406177218214) | |||
| 65189 | 65189 | 126475 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 614 Grant Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010979.6308699995 | 2116716.2496599997 | 37.792718024660296 | -122.405936578515 | (37.7927180246603, -122.405936578515) | |||
| 67618 | 67618 | 176218 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 911 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6004966.17882 | 2092010.8136 | 37.7245445661569 | -122.424984834576 | (37.7245445661569, -122.424984834576) | |||
| 69584 | 69584 | 207530 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 167 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992439.85579 | 2088989.05805 | 37.71553203096521 | -122.468066604497 | (37.7155320309652, -122.468066604497) | |||
| 72468 | 72468 | 126473 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 965 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010055.7552 | 2117146.34025 | 37.793847235906 | -122.40916360322299 | (37.793847235906, -122.409163603223) | |||
| 73908 | 73908 | 126486 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 736 Grant Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010915.83375 | 2117183.06415 | 37.793996216698204 | -122.40619022421001 | (37.7939962166982, -122.40619022421) | |||
| 76776 | 76776 | 139217 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 2 Avery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6002855.8775 | 2113890.0776 | 37.78450038647 | -122.433842977402 | (37.78450038647, -122.433842977402) | |||
| 77271 | 77271 | 126489 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 740 Grant Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010909.75433 | 2117242.1436400004 | 37.7941580946843 | -122.40621542412902 | (37.7941580946843, -122.406215424129) | |||
| 84966 | 84966 | 95405 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 395 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767278 | 6003403.3 | 2099172.9 | 37.7441216223731 | -122.430898399301 | (37.7441216223731, -122.430898399301) | |
| 92565 | 92565 | 116410 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 600x GRANT AVE | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6011037.0 | 2116673.0 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | |||||
| 96020 | 96020 | 70696 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 40 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772487 | 6009871.61507193 | 2111016.36108742 | 37.7770054589734 | -122.409367943314 | (37.7770054589734, -122.409367943314) |
| 100908 | 100908 | 115257 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 270 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 773211 | 5994303.1 | 2088751.5 | 37.7149871811986 | -122.46160922895001 | (37.7149871811986, -122.46160922895) | |||
| 100975 | 100975 | 99819 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 618 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2012 12:00:00 AM | 4 | 3x3 | Permit Number 768974 | 6007328.1 | 2097732.5 | 37.7403882035532 | -122.417225224725 | (37.7403882035532, -122.417225224725) |
| 102964 | 102964 | 61860 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 1170 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767696 | 6010256.88549084 | 2102403.71374687 | 37.7533786697119 | -122.407427830244 | (37.7533786697119, -122.407427830244) | |
| 104752 | 104752 | 116408 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 600x GRANT AVE | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6011037.0 | 2116673.0 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | |||||
| 107020 | 107020 | 116412 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 600x GRANT AVE | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6011037.0 | 2116673.0 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | |||||
| 113167 | 113167 | 94578 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 555 Liberty St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53756 | 6002712.0 | 2103841.0 | 37.7568999283928 | -122.433622311574 | (37.7568999283928, -122.433622311574) | ||
| 121802 | 121802 | 249418 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 730 Eddy St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006958.572980001 | 2113300.36326 | 37.783113133000796 | -122.419607167559 | (37.7831131330008, -122.419607167559) | |||
| 125865 | 125865 | 63030 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 618 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 7 | 3x3 | Permit Number 23499 | 6007196.19448545 | 2097753.67919454 | 37.7404389351493 | -122.41768280382401 | (37.7404389351493, -122.417682803824) |
| 127093 | 127093 | 108817 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 70 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774653 | 6004639.46555 | 2093127.26363 | 37.7275916310609 | -122.426193686908 | (37.7275916310609, -122.426193686908) | |
| 128024 | 128024 | 116409 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 600x GRANT AVE | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6011037.0 | 2116673.0 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | |||||
| 129583 | 129583 | 176214 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 57 Niagara Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5999770.5022 | 2089130.6998299998 | 37.7163415745821 | -122.44273883941901 | (37.7163415745821, -122.442738839419) | |||
| 134040 | 134040 | 116415 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 616 Grant Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | 3x3 | 6010954.90415 | 2116873.4164299998 | 37.793148183903796 | -122.406033211575 | (37.7931481839038, -122.406033211575) | |||
| 139163 | 139163 | 116411 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 600x GRANT AVE | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6011037.0 | 2116673.0 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | |||||
| 146169 | 146169 | 126488 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 740 Grant Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010911.68346 | 2117221.5167 | 37.7941015659862 | -122.406207295144 | (37.7941015659862, -122.406207295144) | |||
| 147462 | 147462 | 207529 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 270 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994301.57599 | 2088731.20996 | 37.714931381842106 | -122.46161302633399 | (37.7149313818421, -122.461613026334) | |||
| 150207 | 150207 | 116416 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 654 Grant Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | 6010952.55495 | 2116896.00924 | 37.793210086935396 | -122.40604293235701 | (37.7932100869354, -122.406042932357) | ||||
| 151278 | 151278 | 116414 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 616 Grant Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | 6010958.19294 | 2116856.3996900003 | 37.7931016439695 | -122.406020632759 | (37.7931016439695, -122.406020632759) | ||||
| 152599 | 152599 | 223361 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 1170 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010259.59114 | 2102407.23208 | 37.753388481712605 | -122.407418721519 | (37.7533884817126, -122.407418721519) | |||
| 153906 | 153906 | 223358 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 120 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006443.608469999 | 2105370.02039 | 37.7613092876166 | -122.420825542059 | (37.7613092876166, -122.420825542059) | |||
| 155432 | 155432 | 176220 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 184 Trumbull St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004605.51014 | 2094301.89303 | 37.7308149830178 | -122.426394670297 | (37.7308149830178, -122.426394670297) | |||
| 155516 | 155516 | 116413 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 616 Grant Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | 6010963.21196 | 2116835.06885 | 37.7930433553227 | -122.40600176317801 | (37.7930433553227, -122.406001763178) | ||||
| 156080 | 156080 | 176217 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 133 Craut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004048.73113 | 2094210.3186700002 | 37.730532050899896 | -122.42831302043001 | (37.7305320508999, -122.42831302043) | |||
| 156807 | 156807 | 139215 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 2 Avery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6002851.6002 | 2113917.8805 | 37.7845764834799 | -122.433859763323 | (37.7845764834799, -122.433859763323) | |||
| 159450 | 159450 | 176224 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 104 Burrows St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011096.64094 | 2093492.43548 | 37.7289571770226 | -122.403896730856 | (37.7289571770226, -122.403896730856) | |||
| 161537 | 161537 | 191056 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 576 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009870.013669999 | 2111694.41232 | 37.778867138638795 | -122.409421347113 | (37.7788671386388, -122.409421347113) | |||
| 164289 | 164289 | 66581 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 68 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 2 | Permit Number 29771 | 6004634.9275400005 | 2093124.55932 | 37.7275839491245 | -122.426209182414 | (37.7275839491245, -122.426209182414) | |
| 167256 | 167256 | 116417 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 654 Grant Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | 6010951.3253 | 2116916.7689799997 | 37.79326701941329 | -122.406048650219 | (37.7932670194133, -122.406048650219) | ||||
| 167404 | 167404 | 139216 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 2 Avery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6002855.0221 | 2113902.0542 | 37.7845332226439 | -122.433846793125 | (37.7845332226439, -122.433846793125) | |||
| 168372 | 168372 | 176219 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 184 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004582.76626 | 2094300.24118 | 37.7308091617089 | -122.426473181996 | (37.7308091617089, -122.426473181996) | |||
| 168534 | 168534 | 126481 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 700 Grant Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010936.07876 | 2117021.70057 | 37.793554283548104 | -122.406108800487 | (37.7935542835481, -122.406108800487) | |||
| 170417 | 170417 | 176223 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 171 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009793.9846 | 2094669.3347900002 | 37.732115829878104 | -122.408483113209 | (37.7321158298781, -122.408483113209) | |||
| 171074 | 171074 | 106276 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 563 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2014 12:00:00 AM | 2 | 6x4 | Permit Number 772761 | 5994052.84239 | 2111670.29623 | 37.7779019935145 | -122.46413703523899 | (37.7779019935145, -122.464137035239) | |
| 172251 | 172251 | 56895 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 1870 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/1974 12:00:00 AM | 1 | Permit Number 14135 | 5985693.5589 | 2102489.949 | 37.7522099922978 | -122.49237811876101 | (37.7522099922978, -122.492378118761) | ||
| 172947 | 172947 | 81671 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 234 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | 1 | 3x3 | Permit Number 777070 | 6003007.57638 | 2092058.40596 | 37.724564414202796 | -122.431758857407 | (37.7245644142028, -122.431758857407) | |
| 173786 | 173786 | 176215 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 937 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6002306.56501 | 2088314.48047 | 37.7142446658383 | -122.433914672619 | (37.7142446658383, -122.433914672619) | |||
| 175740 | 175740 | 126478 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 614 Grant Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010968.42489 | 2116798.92375 | 37.7929444011198 | -122.40598117859699 | (37.7929444011198, -122.405981178597) | |||
| 176959 | 176959 | 108686 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 552 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | Permit Number 773099 | 6012953.395409999 | 2104451.1765 | 37.7591511152568 | -122.39824631113399 | (37.7591511152568, -122.398246311134) | ||
| 177150 | 177150 | 207527 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 451 Hearst Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998481.1046400005 | 2094367.89925 | 37.7306481165185 | -122.447572381583 | (37.7306481165185, -122.447572381583) | |||
| 179073 | 179073 | 176221 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 184 Trumbull St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004622.3507900005 | 2094301.19293 | 37.7308140126569 | -122.426336399617 | (37.7308140126569, -122.426336399617) | |||
| 183558 | 183558 | 126474 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 614 Grant Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010981.69424 | 2116687.73797 | 37.7926398538057 | -122.40592742973301 | (37.7926398538057, -122.405927429733) | |||
| 185194 | 185194 | 120190 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 366 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5987795.88265 | 2113523.4158400004 | 37.7826275288614 | -122.485917836455 | (37.7826275288614, -122.485917836455) | |||
| 187846 | 187846 | 126487 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 740 Grant Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010914.3312099995 | 2117201.57703 | 37.79404696456071 | -122.40619672810301 | (37.7940469645607, -122.406196728103) |
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");