trees

8,298 rows where qLegalStatus_id = 4 sorted by TreeID descending

✎ View and edit SQL

This data as json, CSV (advanced)

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)
52174 99998 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 501X Mission St 1 Sidewalk: Curb side : Pot Tree Private 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013420 2115433 37.7893307029327 -122.397402707509 (37.7893307029327, -122.397402707509) 12 2 9 28855 6
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
163853 99986 Undocumented 4 Corymbia maculata :: Spotted Gum 69 535 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2           6012018 2117734 37.7955705425922 -122.402415352518 (37.7955705425922, -122.402415352518) 3 1 10 28860 4
108297 99985 Undocumented 4 Corymbia maculata :: Spotted Gum 69 535 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012018 2117734 37.7955705425922 -122.402415352518 (37.7955705425922, -122.402415352518) 3 1 10 28860 4
152273 99984 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 535 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2           6012018 2117734 37.7955705425922 -122.402415352518 (37.7955705425922, -122.402415352518) 3 1 10 28860 4
173075 99983 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 535@Clay Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2           6012018 2117734 37.7955705425922 -122.402415352518 (37.7955705425922, -122.402415352518) 3 1 10 28860 4
177588 99982 Undocumented 4 Corymbia maculata :: Spotted Gum 69 535@Clay Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2           6012018 2117734 37.7955705425922 -122.402415352518 (37.7955705425922, -122.402415352518) 3 1 10 28860 4
24671 99980 Undocumented 4 Corymbia maculata :: Spotted Gum 69 441 Castenada Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           5993079.9 2099895.8 37.7455161901456 -122.466646671257 (37.7455161901456, -122.466646671257) 1 8 4 29491 40
169611 99979 Undocumented 4 Corymbia maculata :: Spotted Gum 69 441 Castenada Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5993079.9 2099895.8 37.7455161901456 -122.466646671257 (37.7455161901456, -122.466646671257) 1 8 4 29491 40
151198 99978 Undocumented 4 Corymbia maculata :: Spotted Gum 69 441 Castenada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5993079.9 2099895.8 37.7455161901456 -122.466646671257 (37.7455161901456, -122.466646671257) 1 8 4 29491 40
80873 99972 Undocumented 4 Tree(s) :: 17 143 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x3 Permit Number 776811 5988622.1 2114374.2 37.7850116539768 -122.483121892919 (37.7850116539768, -122.483121892919) 11 6 2 55 26
128468 99971 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2270 Folsom St 13 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
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
33189 99969 Undocumented 4 Tree(s) :: 17 2270 Folsom St 11 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2013 12:00:00 AM     Permit Number 767924 6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
48096 99968 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2270 Folsom St 10 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
8269 99967 Undocumented 4 Ficus nitida :: Laurel Fig 53 2270 Folsom St 9 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
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
152512 99965 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2270 Folsom St 7 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
147160 99960 Undocumented 4 Ulmus americana :: American Elm 74 279 Filbert St 1 Unaccepted Street : Yard Tree Private 2         shared responsibility with 1400 Montgomery 6011546.2 2120046.5 37.8018937585678 -122.40421070766 (37.8018937585678, -122.40421070766) 3 1 10 308 23
179834 99959 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 19 Rausch St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2014 12:00:00 AM 28 3x3 Permit Number 772856 6009640 2110980 37.776892640268 -122.410166607108 (37.776892640268, -122.410166607108) 8 2 9 28853 34
189821 99958 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4204 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6003489 2093971 37.7298432476922 -122.430231025456 (37.7298432476922, -122.430231025456) 9 7 6 28861 25
99885 99952 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 420 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2016 12:00:00 AM 3 3x3 Permit Number 778491 5993609 2105311 37.760415458577 -122.465210403501 (37.760415458577, -122.465210403501) 1 8 11 56 12
138820 99944 Undocumented 4 Melaleuca linariifolia :: Flaxleaf Paperbark 103 221 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6006240 2101855 37.7516463781161 -122.421280123778 (37.7516463781161, -122.421280123778) 2 4 5 28859 19
44771 99937 Undocumented 4 Tree(s) :: 17 315 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2012 12:00:00 AM   3c3 Permit Number 768708 6006226 2098169 37.7415246698481 -122.421066843418 (37.7415246698481, -122.421066843418) 2 7 7 28859 2
97025 99934 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 63 Manchester St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 768712 6008250 2099654 37.7457160396744 -122.41417355851 (37.7457160396744, -122.41417355851) 2 7 7 28859 2
132137 99933 Undocumented 4 Tree(s) :: 17 63 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2012 12:00:00 AM   3x3 Permit Number 768712 6008250 2099654 37.7457160396744 -122.41417355851 (37.7457160396744, -122.41417355851) 2 7 7 28859 2
142116 99931 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 801X Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2012 12:00:00 AM   3x3 Permit Number 768924 6003100.6 2103580.4 37.7562064244422 -122.432259777723 (37.7562064244422, -122.432259777723) 2 4 5 28862 22
83394 99914 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 85 Ramona Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2012 12:00:00 AM 4 3x3 Permit Number 768764 6005244.6 2107384.2 37.7667720917659 -122.425115731153 (37.7667720917659, -122.425115731153) 8 4 5 28853 19
31355 99913 Undocumented 4 Ulmus pumila :: Siberian Elm 99 3751X Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 768933 6005509.05056 2101091.11643 37.7495076933522 -122.42375353502 (37.7495076933522, -122.42375353502) 2 4 5 28859 19
18105 99912 Undocumented 4 Ulmus pumila :: Siberian Elm 99 3751X Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005509.05056 2101091.11643 37.7495076933522 -122.42375353502 (37.7495076933522, -122.42375353502) 2 4 5 28859 19
132451 99911 Undocumented 4 Ulmus pumila :: Siberian Elm 99 400 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005460.7 2101331.3 37.7501644526018 -122.423937810125 (37.7501644526018, -122.423937810125) 2 4 5 28859 19
184096 99876 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1295X San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6003506.1 2095452.4 37.7339118061219 -122.430277556689 (37.7339118061219, -122.430277556689) 2 7 5 28861 25
50988 99875 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1301X San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6003616.3 2095455.7 37.7339271085192 -122.429896797189 (37.7339271085192, -122.429896797189) 2 7 5 28861 25
165954 99862 Undocumented 4 Myoporum laetum :: Myoporum 62 4444x 19th St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6001291.6 2104678.2 37.7591179803285 -122.438594559919 (37.7591179803285, -122.438594559919) 2 4 5 28862 3
136489 99861 Undocumented 4 Myoporum laetum :: Myoporum 62 4444x 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6001291.6 2104678.2 37.7591179803285 -122.438594559919 (37.7591179803285, -122.438594559919) 2 4 5 28862 3
178376 99860 Undocumented 4 Myoporum laetum :: Myoporum 62 4444x 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6001291.6 2104678.2 37.7591179803285 -122.438594559919 (37.7591179803285, -122.438594559919) 2 4 5 28862 3
170311 99846 Undocumented 4 Maytenus boaria :: Mayten 58 850@14th Ave Judah St 4 Sidewalk: Curb side : Cutout Tree Private 2           5991942 2105939 37.7620435090796 -122.471021481615 (37.7620435090796, -122.471021481615) 1 8 11 56 12
134121 99845 Undocumented 4 Maytenus boaria :: Mayten 58 850@14th Ave Judah St 3 Sidewalk: Curb side : Cutout Tree Private 2           5991942 2105939 37.7620435090796 -122.471021481615 (37.7620435090796, -122.471021481615) 1 8 11 56 12
134950 99844 Undocumented 4 Maytenus boaria :: Mayten 58 850@14th Ave Judah St 2 Sidewalk: Curb side : Cutout Tree Private 2           5991942 2105939 37.7620435090796 -122.471021481615 (37.7620435090796, -122.471021481615) 1 8 11 56 12
66026 99833 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1610 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3x   6007914 2117933 37.7958869904292 -122.416630050903 (37.7958869904292, -122.416630050903) 5 1 10 28858 21
81460 99821 Undocumented 4 Salix spp :: Willow 203 1230 Twin Peaks Blvd 1 Back Yard : Yard Tree Private 2     11   Tree closest to sidewalk and retaining wall 5997905.5 2100119.1 37.7464066170132 -122.449976668748 (37.7464066170132, -122.449976668748) 2 5 4 63 38
33717 99818 Undocumented 4 Schinus molle :: California Pepper 91 1134 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6002486 2102282 37.7526064609065 -122.434292449268 (37.7526064609065, -122.434292449268) 2 4 5 28862 22
3509 99817 Undocumented 4 Schinus molle :: California Pepper 91 1134 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6002486 2102282 37.7526064609065 -122.434292449268 (37.7526064609065, -122.434292449268) 2 4 5 28862 22
193536 99816 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 660-662 Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4 Most likely permitted for planting at same time as tree no. 1 6002127 2102089 37.7520561456392 -122.435520126196 (37.7520561456392, -122.435520126196) 2 4 5 28862 22
31732 99815 Undocumented 4 Tree(s) :: 17 730 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2012 12:00:00 AM   3x3 Permit Number 769053 6001682 2102065 37.7519649632224 -122.437057281239 (37.7519649632224, -122.437057281239) 2 4 5 28862 22
23526 99814 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 709 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001253 2102268 37.7524979583971 -122.438555365412 (37.7524979583971, -122.438555365412) 2 4 5 28862 22
87430 99813 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 721x Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 795-797 Elizabeth St same address; corner property 6001267.3 2102059 37.751924908035 -122.438490940634 (37.751924908035, -122.438490940634) 2 4 5 28862 22
28909 99810 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 4201-4203 23rd St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001860 2102333 37.7527109432388 -122.436460912327 (37.7527109432388, -122.436460912327) 2 4 5 28862 22
95886 99808 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 4143 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002228 2102353 37.7527867625939 -122.435189734753 (37.7527867625939, -122.435189734753) 2 4 5 28862 22
162365 99806 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 4141 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6002241 2102354 37.7527902465656 -122.435144849965 (37.7527902465656, -122.435144849965) 2 4 5 28862 22
145320 99804 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 4288-4298 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6001333 2101754 37.75109118813 -122.438241893494 (37.75109118813, -122.438241893494) 2 4 5 28862 22
104801 99803 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 4288-4298 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6001333 2101754 37.75109118813 -122.438241893494 (37.75109118813, -122.438241893494) 2 4 5 28862 22
168864 99802 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 741 Douglass St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6001292.8 2101960.5 37.7516559011478 -122.438395701912 (37.7516559011478, -122.438395701912) 2 4 5 28862 22
122777 99801 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 741 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6001292.8 2101960.5 37.7516559011478 -122.438395701912 (37.7516559011478, -122.438395701912) 2 4 5 28862 22
32798 99800 Undocumented 4 Myoporum laetum :: Myoporum 62 795-797 Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001281 2102008 37.7517856535599 -122.438439910597 (37.7517856535599, -122.438439910597) 2 4 5 28862 22
62127 99799 Undocumented 4 Malus :: Crab Apple 82 795-797 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001281 2102008 37.7517856535599 -122.438439910597 (37.7517856535599, -122.438439910597) 2 4 5 28862 22
14565 99798 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 723-725 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001735 2102034 37.7518828570558 -122.436871780919 (37.7518828570558, -122.436871780919) 2 4 5 28862 22
162055 99797 Undocumented 4 Schinus molle :: California Pepper 91 703-705 Elizabeth St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001860 2102041 37.7519091810186 -122.436440015083 (37.7519091810186, -122.436440015083) 2 4 5 28862 22
18844 99796 Undocumented 4 Olea europaea :: Olive Tree 9 703-705 Elizabeth St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001860 2102041 37.7519091810186 -122.436440015083 (37.7519091810186, -122.436440015083) 2 4 5 28862 22
122834 99795 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 703-705 Elizabeth St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001860 2102041 37.7519091810186 -122.436440015083 (37.7519091810186, -122.436440015083) 2 4 5 28862 22
141039 99794 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 703-705 Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001860 2102041 37.7519091810186 -122.436440015083 (37.7519091810186, -122.436440015083) 2 4 5 28862 22
170610 99793 Undocumented 4 Prunus serrulata 'Double Pink Weeping' :: Weeping Double Pink Flowering Cherry 549 4120-4124 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002399 2101817 37.7513247429435 -122.434560064215 (37.7513247429435, -122.434560064215) 2 4 5 28862 22
173521 99792 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4120-4124 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x5   6002399 2101817 37.7513247429435 -122.434560064215 (37.7513247429435, -122.434560064215) 2 4 5 28862 22
126696 99791 Undocumented 4 Prunus serrulata 'Double Pink Weeping' :: Weeping Double Pink Flowering Cherry 549 4120-4124 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x4   6002399 2101817 37.7513247429435 -122.434560064215 (37.7513247429435, -122.434560064215) 2 4 5 28862 22
105912 99790 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 4140-4124 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Most likely planted when tree 1 was planted/permitted. 6002271 2101809 37.7512955097612 -122.435002130134 (37.7512955097612, -122.435002130134) 2 4 5 28862 22
85703 99789 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 832 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001877 2101668 37.7508859779493 -122.436354534162 (37.7508859779493, -122.436354534162) 2 4 5 28862 22
172214 99787 Undocumented 4 Myoporum laetum :: Myoporum 62 542 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001639 2101477 37.750348011432 -122.437163885099 (37.750348011432, -122.437163885099) 2 4 5 28862 22
55193 99785 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 803-805 Douglass St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001281.6 2101711.5 37.7509715697707 -122.438416595038 (37.7509715697707, -122.438416595038) 2 4 5 28862 22
110919 99784 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 4281 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001386 2101717 37.7509926092516 -122.438055964302 (37.7509926092516, -122.438055964302) 2 4 5 28862 22
30513 99783 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 4214-4216 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001799 2101779 37.7511863251897 -122.436632209418 (37.7511863251897, -122.436632209418) 2 4 5 28862 22
176522 99782 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 4238-4240 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001648 2101771 37.7511557768566 -122.437153809999 (37.7511557768566, -122.437153809999) 2 4 5 28862 22
91550 99780 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 409 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002495 2101491 37.7504350734104 -122.434204782525 (37.7504350734104, -122.434204782525) 2 4 5 28862 22
140403 99779 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 468 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002109 2101503 37.75044610673 -122.435540455001 (37.75044610673, -122.435540455001) 2 4 5 28862 22
110132 99778 Undocumented 4 Myoporum laetum :: Myoporum 62 492x Jersey St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 492-494x Jersey corner property at 845-849 Diamond St 6001966.3 2101499 37.7504270178067 -122.436033635078 (37.7504270178067, -122.436033635078) 2 4 5 28862 22
100835 99777 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 492x Jersey St 2 Sidewalk: Curb side : Pot Tree Private 2       3x3 492-494x Jersey St 845-849 Diamond St 6001966.3 2101499 37.7504270178067 -122.436033635078 (37.7504270178067, -122.436033635078) 2 4 5 28862 22
190551 99776 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800x Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 4205 24th St corner property 6001819.1 2101713.8 37.7510084437682 -122.436558035286 (37.7510084437682, -122.436558035286) 2 4 5 28862 22
35532 99775 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800x Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 4205 24th St corner property 6001819.1 2101713.8 37.7510084437682 -122.436558035286 (37.7510084437682, -122.436558035286) 2 4 5 28862 22
193904 99774 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 4330 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2       8x6   6001764 2100607 37.7479663028981 -122.436669359529 (37.7479663028981, -122.436669359529) 2 4 5 28862 22
186697 99773 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 4348 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001650 2100601 37.7479433490982 -122.437063136505 (37.7479433490982, -122.437063136505) 2 4 5 28862 22
170973 99772 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 4380 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001449 2100590 37.7479017186091 -122.437757396744 (37.7479017186091, -122.437757396744) 2 4 5 28862 22
107905 99771 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 4380 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001449 2100590 37.7479017186091 -122.437757396744 (37.7479017186091, -122.437757396744) 2 4 5 28862 22
86467 99770 Undocumented 4 Myoporum laetum :: Myoporum 62 1025x Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 595 Clipper St is true property address 6001337.9 2100792.7 37.7484519666196 -122.438156093062 (37.7484519666196, -122.438156093062) 2 4 5 28862 22
39115 99769 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 575 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001440 2101432 37.7502131382163 -122.437848816697 (37.7502131382163, -122.437848816697) 2 4 5 28862 22
29790 99768 Undocumented 4 Tree(s) :: 17 545 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2012 12:00:00 AM 22 3x3 Permit Number 769091 6001628 2101442 37.750251284489 -122.437199418076 (37.750251284489, -122.437199418076) 2 4 5 28862 22
95637 99767 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 543 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001641 2101443 37.7502547692275 -122.437154534913 (37.7502547692275, -122.437154534913) 2 4 5 28862 22
176074 99766 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 4300x 26th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 1192 Diamond ST 6001940.4 2100620.7 37.7480139430027 -122.436060356931 (37.7480139430027, -122.436060356931) 2 4 5 28862 22
68893 99765 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 4300x 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 1192 Diamond St is true address 6001940.4 2100620.7 37.7480139430027 -122.436060356931 (37.7480139430027, -122.436060356931) 2 4 5 28862 22
79077 99764 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 4300x 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 1192 Diamond St 6001940.4 2100620.7 37.7480139430027 -122.436060356931 (37.7480139430027, -122.436060356931) 2 4 5 28862 22
158246 99763 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1014-1016 Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 6x8 1014-1016 Diamond St 6001909 2101139 37.749435287958 -122.436206022483 (37.749435287958, -122.436206022483) 2 4 5 28862 22
15862 99761 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 4212 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 4212-4216 25th St (4214 is visible address) 6002485 2101232 37.7497233531083 -122.434220849449 (37.7497233531083, -122.434220849449) 2 4 5 28862 22
117885 99760 Undocumented 4 Acacia baileyana :: Bailey's Acacia 122 4247 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Most likely planted/permitted with tree no. 1 on same day/permit. 6002269 2101186 37.7495847859814 -122.434964495609 (37.7495847859814, -122.434964495609) 2 4 5 28862 22
75100 99759 Undocumented 4 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 4295x 25th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001974.5 2101167.2 37.7495164396885 -122.435981539714 (37.7495164396885, -122.435981539714) 2 4 5 28862 22
98008 99758 Undocumented 4 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 4295x 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001974.5 2101167.2 37.7495164396885 -122.435981539714 (37.7495164396885, -122.435981539714) 2 4 5 28862 22
111416 99757 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 4295x 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001974.5 2101167.2 37.7495164396885 -122.435981539714 (37.7495164396885, -122.435981539714) 2 4 5 28862 22
83914 99756 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 517 Clipper St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Probably planted at same time/permitted with tree no. 1 6001837 2100870 37.7486925868246 -122.436435749617 (37.7486925868246, -122.436435749617) 2 4 5 28862 22
133804 99755 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 519 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001824 2100869 37.7486891023588 -122.43648063187 (37.7486891023588, -122.43648063187) 2 4 5 28862 22
88727 99754 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 590 Clipper St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001368 2100878 37.7486878919362 -122.438058117383 (37.7486878919362, -122.438058117383) 2 4 5 28862 22
3101 99753 Undocumented 4 Tree(s) :: 17 526 Clipper St 2 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3 Permit Number 776170 6001772 2100900 37.748771266015 -122.436662665796 (37.748771266015, -122.436662665796) 2 4 5 28862 22
116479 99752 Undocumented 4 Tree(s) :: 17 526 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/21/2015 12:00:00 AM   3x3 Permit Number 776170 6001772 2100900 37.748771266015 -122.436662665796 (37.748771266015, -122.436662665796) 2 4 5 28862 22
128798 99751 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 500x Clipper St 4 Sidewalk: Curb side : Cutout Tree Private 2     25 3x3 1046 Diamond St 6001860.7 2100931.8 37.7488636216299 -122.436358217698 (37.7488636216299, -122.436358217698) 2 4 5 28862 22

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