159 rows where Supervisor Districts = 7 and qLegalStatus_id = 2 sorted by Location

View and edit SQL

Supervisor Districts

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)
13984 115980 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 5 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011593.71434 2091235.60939 37.7227881560287 -122.402019710862 (37.7227881560287, -122.402019710862) 10 3 7 309 28
156122 115979 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011610.19593 2091240.25279 37.7228018257296 -122.401963063449 (37.7228018257296, -122.401963063449) 10 3 7 309 28
158751 115978 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011623.9012 2091244.95295 37.7228154963084 -122.40191601721 (37.7228154963084, -122.40191601721) 10 3 7 309 28
188951 115977 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011639.0005 2091249.90123 37.7228299259539 -122.40186416949 (37.7228299259539, -122.40186416949) 10 3 7 309 28
163344 115976 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011653.53869 2091254.58415 37.7228435956385 -122.401814242757 (37.7228435956385, -122.401814242757) 10 3 7 309 28
27287 255049 Planning Code 138.1 required 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 925 Woolsey St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2018 12:00:00 AM 3 3x3 Permit Number 779631 6009075.60356 2091383.60862 37.7230536656288 -122.410734764023 (37.7230536656288, -122.410734764023) 9 3 7 309 28
3 121463 Planning Code 138.1 required 2 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 415 Oxford St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2020 12:00:00 AM 3 3x3 Permit Number 778984 6006773.54328 2092061.724 37.7247862819155 -122.418740608563 (37.7247862819155, -122.418740608563) 9 7 7 309 28
27 121462 Planning Code 138.1 required 2 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 415 Oxford St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2020 12:00:00 AM 3 3x3 Permit Number 778984 6006773.54328 2092061.724 37.7247862819155 -122.418740608563 (37.7247862819155, -122.418740608563) 9 7 7 309 28
161840 148099 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 509 Holyoke St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/19/2018 12:00:00 AM 3 4x4 Permit Number 782106 6009909.13224 2092063.05855 37.7249659929773 -122.40790129952 (37.7249659929773, -122.40790129952) 10 3 7 309 28
173437 255664 Planning Code 138.1 required 2 Tree(s) :: 17 368 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2018 12:00:00 AM 3 3x3 Permit Number 781650 6007860.32032 2092132.7947 37.7250425565594 -122.414988767826 (37.7250425565594, -122.414988767826) 9 3 7 309 28
182774 255792 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 368 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2018 12:00:00 AM 3 3x3   6007843 2092137 37.7250531301082 -122.415048939995 (37.7250531301082, -122.415048939995) 9 3 7 309 28
81706 122697 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 98 Woolsey St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2016 12:00:00 AM 3 3x3   6011441.99272 2092150.08828 37.725290657742 -122.402608459524 (37.725290657742, -122.402608459524) 10 3 7 309 28
101909 122699 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 98 Woolsey St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2016 12:00:00 AM 3 3x3   6011441.99272 2092150.08828 37.725290657742 -122.402608459524 (37.725290657742, -122.402608459524) 10 3 7 309 28
183675 122698 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 98 Woolsey St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2016 12:00:00 AM 3 3x3   6011441.99272 2092150.08828 37.725290657742 -122.402608459524 (37.725290657742, -122.402608459524) 10 3 7 309 28
35834 122701 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 2895 San Bruno Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2016 12:00:00 AM 3 3x9   6011453.69513 2092165.76794 37.7253343641976 -122.402569107292 (37.7253343641976, -122.402569107292) 10 3 7 309 28
191014 122700 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 2895 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2016 12:00:00 AM 3 3x9   6011453.69513 2092165.76794 37.7253343641976 -122.402569107292 (37.7253343641976, -122.402569107292) 10 3 7 309 28
99548 256905 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 338 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2019 12:00:00 AM 3 3x3 Permit Number 781421 6007824.5446 2092249.93927 37.7253622000817 -122.415120729164 (37.7253622000817, -122.415120729164) 9 3 7 309 28
122256 254396 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 167 Harvard St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2018 12:00:00 AM 3 3x3 Permit Number 774780 6006150.23201 2093073.81475 37.7275301484246 -122.420967149802 (37.7275301484246, -122.420967149802) 9 7 7 309 5
23615 117008 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1315 Silliman St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2016 12:00:00 AM 3 3x3   6006952.61647 2093135.11232 37.7277436552341 -122.418197638517 (37.7277436552341, -122.418197638517) 9 3 7 309 5
71950 176972 Planning Code 138.1 required 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 161 University St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft Permit Number 781886 6008005.59306 2093164.83572 37.7278844827614 -122.414559571484 (37.7278844827614, -122.414559571484) 9 3 7 309 28
27582 116803 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 931 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/2016 12:00:00 AM 3 3x3   6007342.71844 2093540.39539 37.7288784251848 -122.416877747635 (37.7288784251848, -122.416877747635) 9 3 7 309 28
41739 253164 Planning Code 138.1 required 2 Tree(s) :: 17 146 Cambridge St 1 Front Yard : Cutout Tree Private 2   07/27/2017 12:00:00 AM 3 4x4   6006598.94029 2094006.41191 37.7301161400075 -122.419482094225 (37.7301161400075, -122.419482094225) 9 7 7 309 5
174008 251470 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 194 Sweeny St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2017 12:00:00 AM 3 3x3 Permit Number 777454 6009558.57553 2094850.08468 37.7325989441491 -122.409309728531 (37.7325989441491, -122.409309728531) 10 3 7 309 28
8190 261370 Planning Code 138.1 required 2 Eriobotrya japonica :: Edible Loquat 119 102 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007140 2095356 37.7338522748733 -122.417707198486 (37.7338522748733, -122.417707198486) 2 7 7 28859 2
11346 261371 Planning Code 138.1 required 2 Syagrus romanzoffianum :: Queen Palm 85 105 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007217 2095358 37.7338620991787 -122.417441127318 (37.7338620991787, -122.417441127318) 2 7 7 28859 2
5901 260465 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 3933 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2019 12:00:00 AM 3 3x4 Permit Number 782033 6005003.24747 2095750.87761 37.7348160467336 -122.425122689163 (37.7348160467336, -122.425122689163) 2 7 7 28861 2
6487 261445 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 339 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007092 2095790 37.7350412423636 -122.417903903871 (37.7350412423636, -122.417903903871) 2 7 7 28859 2
17746 262424 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 328 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/2020 12:00:00 AM 3 3x3   6006735.98718 2096026.524 37.7356706425738 -122.419151541699 (37.7356706425738, -122.419151541699) 2 7 7 28859 2
32243 66394 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 504 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/2016 12:00:00 AM 3 3x4 Permit Number 772815 6007447.25872729 2096493.62336554 37.7369932248849 -122.41672547553 (37.7369932248849, -122.41672547553) 2 7 7 28859 2
176317 256115 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 503 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2018 12:00:00 AM 3 3x3 Permit Number 774745 6007867.72621 2096528.91607 37.7371137709195 -122.41527422465 (37.7371137709195, -122.41527422465) 2 7 7 28859 2
20472 124717 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 610 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2016 12:00:00 AM 3 3x3 Permit Number 775784 6007724.21349 2097196.46477 37.7389386461297 -122.415817669649 (37.7389386461297, -122.415817669649) 2 7 7 28859 2
152864 124718 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 610 Cortland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/22/2018 12:00:00 AM 3 3x3 Permit Number 775784 6007724.21349 2097196.46477 37.7389386461297 -122.415817669649 (37.7389386461297, -122.415817669649) 2 7 7 28859 2
4773 165865 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 275 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 3x4   6006836.83511 2097542.23848 37.7398381374333 -122.418910337746 (37.7398381374333, -122.418910337746) 2 7 7 28859 2
100907 229627 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 3662 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 778622 6008456.11159 2097816.22885 37.7406815009641 -122.413330912287 (37.7406815009641, -122.413330912287) 2 7 7 28859 2
172871 256721 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1025 Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 776275 6009358 2098062 37.7414069300959 -122.410229861131 (37.7414069300959, -122.410229861131) 10 7 7 28859 2
93272 256871 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1025 Powhattan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/20/2018 12:00:00 AM 3 3x3 Permit Number 776275 6009358.6182 2098062.94866 37.7414095695618 -122.410227790564 (37.7414095695618, -122.410227790564) 10 7 7 28859 2
71921 256722 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 985 Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/20/2018 12:00:00 AM 3 3x3 Permit Number 776274 6009288 2098069 37.7414222265504 -122.410472391962 (37.7414222265504, -122.410472391962) 10 7 7 28859 2
155799 256869 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 985 Powhattan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/20/2018 12:00:00 AM 3 3x3 Permit Number 776274 6009287.99434 2098069.06568 37.7414224065761 -122.410472416169 (37.7414224065761, -122.410472416169) 10 7 7 28859 2
131611 255979 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 965 Powhattan Ave   Sidewalk: Curb side : Cutout Tree Private 2   12/20/2018 12:00:00 AM 3 3x3 Permit Number 776273 6009246 2098072 37.7414281092456 -122.410617825786 (37.7414281092456, -122.410617825786) 10 7 7 28859 2
98671 256868 Planning Code 138.1 required 2 Quercus agrifolia :: Coast Live Oak 172 965 Powhattan Ave 1 Side Yard : Yard Tree Private 2   12/20/2018 12:00:00 AM 3 3x3 Permit Number 776273 6009246.49493 2098072.65991 37.7414299489627 -122.410616161073 (37.7414299489627, -122.410616161073) 10 7 7 28859 2
48832 243143 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 98x Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2017 12:00:00 AM 3 3x3   6006195 2098242 37.7417233638646 -122.421179213365 (37.7417233638646, -122.421179213365) 2 7 7 28859 2
100425 243144 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 98x Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2017 12:00:00 AM 3 3x3   6006195 2098242 37.7417233638646 -122.421179213365 (37.7417233638646, -122.421179213365) 2 7 7 28859 2
22723 119256 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 195 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2016 12:00:00 AM 3 3x3   6010242 2098801 37.7434855758555 -122.407225363197 (37.7434855758555, -122.407225363197) 2 7 7 28859 2
78754 119257 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 191 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2016 12:00:00 AM 3 3x3   6010220 2098811 37.743511802413 -122.407302138847 (37.743511802413, -122.407302138847) 2 7 7 28859 2
37358 247943 Planning Code 138.1 required 2 Maytenus boaria :: Mayten 58 29 Joy St 6 Unaccepted Street : Yard Tree DPW 1     2   Permit Number 775404 6010304.2598 2098903.51059 37.7437705318851 -122.407017307297 (37.7437705318851, -122.407017307297) 2 7 7 28859 2
7505 247942 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 29 Joy St 5 Unaccepted Street : Yard Tree DPW 1     3   Permit Number 775404 6010292.72224 2098904.67919 37.7437730949632 -122.407057283984 (37.7437730949632, -122.407057283984) 2 7 7 28859 2
128791 247940 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 29 Joy St 3 Unaccepted Street : Yard Tree DPW 1     5   Permit Number 775404 6010280.31746 2098909.28814 37.7437850559498 -122.407100501782 (37.7437850559498, -122.407100501782) 2 7 7 28859 2
126738 247941 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 29 Joy St 4 Unaccepted Street : Yard Tree DPW 1     5   Permit Number 775404 6010287.82636 2098909.7574 37.743786764646 -122.407074570729 (37.743786764646, -122.407074570729) 2 7 7 28859 2
60942 247939 Planning Code 138.1 required 2 Quercus agrifolia :: Coast Live Oak 172 29 Joy St 2 Unaccepted Street : Yard Tree DPW 1     12   Permit Number 775404 6010258.29977 2098917.51569 37.7438064148349 -122.40717721395 (37.7438064148349, -122.40717721395) 2 7 7 28859 2
162044 247938 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 29 Joy St 1 Unaccepted Street : Yard Tree DPW 1     9   Permit Number 775404 6010254.90659 2098918.71089 37.7438095066969 -122.407189031056 (37.7438095066969, -122.407189031056) 2 7 7 28859 2
21868 221950 Planning Code 138.1 required 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 31 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3 Permit Number 780973 6006097.6775 2099053.58173 37.7439462971915 -122.421573349947 (37.7439462971915, -122.421573349947) 2 7 7 28859 2
6077 230988 Planning Code 138.1 required 2 Magnolia spp :: Magnolia 224 44 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2018 12:00:00 AM 3 3x6 Permit Number 778706 6007424.10799 2099038.48568 37.7439795505181 -122.416985775987 (37.7439795505181, -122.416985775987) 2 7 7 28859 2
58996 242613 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 48 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3 Permit Number 777782 6007306.44134 2099195.30791 37.7444035295914 -122.417403753004 (37.7444035295914, -122.417403753004) 2 7 7 28859 2
74714 166016 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 3332 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/10/2018 12:00:00 AM 3 3x3 Permit Number 776384 6008453.51061 2099255.43212 37.7446330896597 -122.413441663829 (37.7446330896597, -122.413441663829) 2 7 7 28859 2
48760 255654 Planning Code 138.1 required 2 Quercus agrifolia :: Coast Live Oak 172 298X Coso Ave 2 Side Yard : Yard Tree Private 2   06/27/2018 12:00:00 AM 3 10x10 Permit Number 776462 6007785 2099424 37.7450583812321 -122.415765181935 (37.7450583812321, -122.415765181935) 2 7 7 28859 2
183741 255653 Planning Code 138.1 required 2 Quercus agrifolia :: Coast Live Oak 172 298X Coso Ave 1 Side Yard : Yard Tree Private 2   06/27/2018 12:00:00 AM 3 10x10 Permit Number 776462 6007785 2099424 37.7450583812321 -122.415765181935 (37.7450583812321, -122.415765181935) 2 7 7 28859 2
33539 114537 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 1624 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2015 12:00:00 AM   3x4   6009248.6 2099914.9 37.7464884538144 -122.41073895467 (37.7464884538144, -122.41073895467) 2 7 7 28859 2
68317 228832 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 517 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2018 12:00:00 AM 3 4x4   6006836.21643 2100716.23735 37.7485531903885 -122.419137558645 (37.7485531903885, -122.419137558645) 2 4 7 28859 19
4803 260955 Planning Code 138.1 required 2 Nyssa sylvatica :: Tupelo: Sour Gum 92 1296 Shotwell St 4 Sidewalk: Curb side : Cutout Tree Private 2       4x8   6008013 2100716 37.7486187391462 -122.4150682294 (37.7486187391462, -122.4150682294) 2 4 7 28859 19
11040 260952 Planning Code 138.1 required 2 Nyssa sylvatica :: Tupelo: Sour Gum 92 1296 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x8   6008013 2100716 37.7486187391462 -122.4150682294 (37.7486187391462, -122.4150682294) 2 4 7 28859 19
11620 260954 Planning Code 138.1 required 2 Nyssa sylvatica :: Tupelo: Sour Gum 92 1296 Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2       4x8   6008013 2100716 37.7486187391462 -122.4150682294 (37.7486187391462, -122.4150682294) 2 4 7 28859 19
13412 260953 Planning Code 138.1 required 2 Nyssa sylvatica :: Tupelo: Sour Gum 92 1296 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x8   6008013 2100716 37.7486187391462 -122.4150682294 (37.7486187391462, -122.4150682294) 2 4 7 28859 19
685 151339 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 1411 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2019 12:00:00 AM 3 6x6 Permit Number 781016 6009578.8057 2100900.01209 37.7492118628581 -122.409666655187 (37.7492118628581, -122.409666655187) 2 4 7 28859 19
179256 152616 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 3098 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2019 12:00:00 AM 3 3x3 Permit Number 782654 6009096.56353 2101019.92176 37.7495140728181 -122.411342732484 (37.7495140728181, -122.411342732484) 2 4 7 28859 19
180002 258222 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 2997 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2019 12:00:00 AM   3x3   6009042 2101022 37.7495167187784 -122.41153156233 (37.7495167187784, -122.41153156233) 2 4 7 28859 19
125934 256878 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 3098 26th St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2019 12:00:00 AM 3 3x3 Permit Number 782654 6009121.70897 2101021.23838 37.7495190982493 -122.411255871462 (37.7495190982493, -122.411255871462) 2 4 7 28859 19
152203 152615 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 3098 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2019 12:00:00 AM 3 3x3 Permit Number 782654 6009121.70897 2101021.23838 37.7495190982493 -122.411255871462 (37.7495190982493, -122.411255871462) 2 4 7 28859 19
82212 156914 Planning Code 138.1 required 2 Tree(s) :: 17 2995 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2018 12:00:00 AM 3 3x3 Permit Number 782654 6009047.12311 2101072.92433 37.7496568330138 -122.411517443787 (37.7496568330138, -122.411517443787) 2 4 7 28859 19
70866 224462 Planning Code 138.1 required 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2810 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2017 12:00:00 AM 3 3x3 Permit Number 775960 6010311.37562 2101086.64633 37.7497653433983 -122.407146558773 (37.7497653433983, -122.407146558773) 2 4 7 28859 19
114599 240686 Planning Code 138.1 required 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2810 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2017 12:00:00 AM 3 3x3 Permit Number 775960 6010325.27315 2101087.17666 37.7497675773096 -122.407098537685 (37.7497675773096, -122.407098537685) 2 4 7 28859 19
133371 255306 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1163 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2018 12:00:00 AM 3 3x6 Permit Number 777039 6008085.276 2101160.09095 37.7498421745418 -122.414849724814 (37.7498421745418, -122.414849724814) 2 4 7 28859 19
120060 221127 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1218 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2016 12:00:00 AM 1 Width 3ft Permit Number 778419 6008662.3869 2101444.26707 37.750654869142 -122.412874131348 (37.750654869142, -122.412874131348) 2 4 7 28859 19
17339 166211 Planning Code 138.1 required 2 Cercis canadensis :: Eastern Redbud 346 3140 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6008730.35876 2101584.0935 37.7510426163255 -122.412648961786 (37.7510426163255, -122.412648961786) 2 4 7 28859 19
53742 82615 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2901 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777487 6010040.72394239 2101604.72592715 37.7511727251881 -122.408119020981 (37.7511727251881, -122.408119020981) 2 4 7 28859 19
131633 115503 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2901 25th St 72 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777487 6010040.72394239 2101604.72592715 37.7511727251881 -122.408119020981 (37.7511727251881, -122.408119020981) 2 4 7 28859 19
163013 115504 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2901 25th St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777487 6010040.72394239 2101604.72592715 37.7511727251881 -122.408119020981 (37.7511727251881, -122.408119020981) 2 4 7 28859 19
134654 152810 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 2901 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6009973.24314 2101608.01571 37.7511779795992 -122.408352609887 (37.7511779795992, -122.408352609887) 2 4 7 28859 19
36893 152811 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 2901 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6009988.15821 2101607.87857 37.7511784382559 -122.40830102207 (37.7511784382559, -122.40830102207) 2 4 7 28859 19
46028 152812 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 2901 25th St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6010002.42353 2101608.75594 37.7511816461268 -122.408251752714 (37.7511816461268, -122.408251752714) 2 4 7 28859 19
54415 224728 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 1110 York St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/13/2018 12:00:00 AM 3 3x3 Permit Number 771820 6009984.63313 2102660.33541 37.754068053508 -122.408387439738 (37.754068053508, -122.408387439738) 2 4 7 28859 19
80448 187677 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
88053 187676 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
119022 60277 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2690 Harrison St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/03/2008 12:00:00 AM   3x3 Permit Number 51145 6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
135962 187674 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
169946 187675 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
170362 187678 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
185007 187679 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
78698 173775 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 1057 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/26/2018 12:00:00 AM 3 4x4 Permit Number 779347 6009462.91602 2103024.17334 37.7550378411013 -122.410217357343 (37.7550378411013, -122.410217357343) 2 4 7 28859 19
10960 166315 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008872.21502 2103120.32489 37.7552687230844 -122.412266973836 (37.7552687230844, -122.412266973836) 2 4 7 28859 19
18610 259660 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008872.21502 2103120.32489 37.7552687230844 -122.412266973836 (37.7552687230844, -122.412266973836) 2 4 7 28859 19
16166 166316 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008870.16891 2103155.64589 37.7553655917605 -122.412276546247 (37.7553655917605, -122.412276546247) 2 4 7 28859 19
12003 166317 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008865.69274 2103234.56357 37.755582030708 -122.412297603862 (37.755582030708, -122.412297603862) 2 4 7 28859 19
182124 166234 Planning Code 138.1 required 2 Tree(s) :: 17 2986 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2018 12:00:00 AM 3 3x3 Permit Number 781629 6008392.95809 2103319.50363 37.7557887182862 -122.413938481678 (37.7557887182862, -122.413938481678) 2 4 7 28859 19
88632 60705 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 963 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1983 12:00:00 AM 1 3x3 Permit Number 20354 6009178.18020232 2103559.73737881 37.7564924147418 -122.4112398899 (37.7564924147418, -122.4112398899) 2 4 7 28859 19
129591 152667 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 811 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2018 12:00:00 AM 3 3x3 Permit Number 777381 6008576.51497 2103684.24515 37.7568005230537 -122.413329473377 (37.7568005230537, -122.413329473377) 2 4 7 28859 19
13037 152668 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 811 Treat Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2018 12:00:00 AM 3 3x3 Permit Number 777381 6008574.99769 2103713.14234 37.7568797829862 -122.413336764205 (37.7568797829862, -122.413336764205) 2 4 7 28859 19
11511 225198 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007149.23047 2103831.77129 37.7571253581517 -122.418276020715 (37.7571253581517, -122.418276020715) 2 4 7 28859 19
11548 225197 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007163.79352 2103832.50742 37.7571281991351 -122.418225708166 (37.7571281991351, -122.418225708166) 2 4 7 28859 19
1462 225196 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007182.851 2103832.80652 37.7571300930895 -122.418159821127 (37.7571300930895, -122.418159821127) 2 4 7 28859 19
1675 225195 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007206.11976 2103835.77909 37.7571395647689 -122.418079559351 (37.7571395647689, -122.418079559351) 2 4 7 28859 19

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