trees

155 rows where Police Districts = 8 and qLegalStatus_id = 2 sorted by PermitNotes

✎ View and edit SQL

This data as json, CSV (advanced)

qCareAssistant ✖

Police 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)
2139 251538 Planning Code 138.1 required 2 Brahea edulis :: Guadalupe Palm 218 1746 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981086 2103156 37.753768326371 -122.508360924805 (37.753768326371, -122.508360924805) 1 8 3 56 35
3289 262310 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1356 20th Ave   Sidewalk: Curb side : Cutout Tree Private 2   08/26/2016 12:00:00 AM       5989914.31197 2106134.19071 37.7624619657204 -122.478048663847 (37.7624619657204, -122.478048663847) 1 8 3 56 35
6357 261583 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 496 Urbano Dr 6 Sidewalk: Property side : Yard Tree Private 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
6460 261585 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 496 Urbano Dr 8 Sidewalk: Property side : Yard Tree Private 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
6598 261578 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 496 Urbano Dr 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
9333 261584 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 496 Urbano Dr 7 Sidewalk: Property side : Yard Tree Private 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
11732 261580 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 496 Urbano Dr 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
14010 261579 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 496 Urbano Dr 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
14168 261582 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 496 Urbano Dr 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
15585 258769 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 1633 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2019 12:00:00 AM 3 3x3   5988962.35654 2103065.4403 37.7539807026125 -122.481116375927 (37.7539807026125, -122.481116375927) 1 8 3 56 35
16304 162975 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 131 Harold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   5996790.92866 2090757.22233 37.72063731584 -122.453154991525 (37.72063731584, -122.453154991525) 9 8 6 28861 24
19480 261581 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 496 Urbano Dr 4 Sidewalk: Property side : Yard Tree Private 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
20111 1217 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 3501 Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   06/17/2016 12:00:00 AM 3 3x3   5993695.72185 2087421.09824 37.7112992341463 -122.463612070865 (37.7112992341463, -122.463612070865) 9 8 4 64 24
22364 114870 Planning Code 138.1 required 2 Prunus serrulata :: Ornamental Cherry 84 2326 Cecelia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/16/2015 12:00:00 AM 3 3x4   5991484.88147917 2099641.61135178 37.744726077495 -122.472143418263 (37.744726077495, -122.472143418263) 1 8 4 29491 40
25596 117510 Planning Code 138.1 required 2 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 23x BRIGHT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   06/17/2016 12:00:00 AM 3 3x3   5993679 2087403 37.7112485771375 -122.463668552658 (37.7112485771375, -122.463668552658) 9 8 4 64 24
26576 173651 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 80 Entrada Ct 3 Sidewalk: Property side : Yard Tree Private 2   12/21/2016 12:00:00 AM 3 4x10   5992424.45657 2092194.59394 37.7243327619491 -122.468352901223 (37.7243327619491, -122.468352901223) 9 8 4 59 40
26702 117483 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 5 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
32475 255482 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1559 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2018 12:00:00 AM 3 3x5   5993958 2104895 37.7592933500003 -122.463973185629 (37.7592933500003, -122.463973185629) 1 8 4 56 12
36980 105047 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 278 Capitol Ave   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995102.4 2087946.7 37.7128233663074 -122.458788296392 (37.7128233663074, -122.458788296392) 9 8 6 28861 24
37551 253474 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 134 Lunado Way 1 Sidewalk: Property side : Yard Tree Private 2       3x2   5991633 2092401 37.7248537561355 -122.471103859098 (37.7248537561355, -122.471103859098) 9 8 4 59 40
37901 251534 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1818 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2017 12:00:00 AM 3 3x3   5983226 2102732 37.7527300247516 -122.500929082058 (37.7527300247516, -122.500929082058) 1 8 3 56 35
45409 114908 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 281 LOBOS ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994225 2088676 37.714775380269 -122.461873702271 (37.714775380269, -122.461873702271) 9 8 6 28861 24
55332 115079 Planning Code 138.1 required 2 Brahea edulis :: Guadalupe Palm 218 1746 Great Hwy 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981053.87958296 2103176.2415425 37.7538220108937 -122.508473505042 (37.7538220108937, -122.508473505042) 1 8 3 56 35
56397 251539 Planning Code 138.1 required 2 Brahea edulis :: Guadalupe Palm 218 1746 Great Hwy 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981086 2103156 37.753768326371 -122.508360924805 (37.753768326371, -122.508360924805) 1 8 3 56 35
58189 121145 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 962 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2016 12:00:00 AM 3 3x3   5995080 2090346 37.7194099895512 -122.459039336024 (37.7194099895512, -122.459039336024) 9 8 6 28861 24
64249 252820 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 2339 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2017 12:00:00 AM 3 3x3   5983590.30233 2099230.68636 37.743137766616 -122.499410557243 (37.743137766616, -122.499410557243) 1 8 3 29491 35
64628 113721 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1526 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/2015 12:00:00 AM   3x3   5989360 2104938.6 37.7591470062831 -122.479878309336 (37.7591470062831, -122.479878309336) 1 8 3 56 35
65989 255377 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2699X Vicente St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2018 12:00:00 AM 3 3x3   5984648 2097442 37.7382885158105 -122.495621472041 (37.7382885158105, -122.495621472041) 1 8 3 29491 35
77927 187639 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1671 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/22/2017 12:00:00 AM 3 3x6   5985585 2103854 37.7559489545124 -122.492853989295 (37.7559489545124, -122.492853989295) 1 8 3 56 35
80043 255924 Planning Code 138.1 required 2 Maytenus boaria :: Mayten 58 454 Ralston St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5992261 2090872 37.7206918008503 -122.468821743954 (37.7206918008503, -122.468821743954) 9 8 6 64 24
84340 115405 Planning Code 138.1 required 2 Podocarpus macrophyllus :: Yew Pine 137 2050 43RD AVE 1 Sidewalk: Property side : Cutout Tree Private 2   01/29/2016 12:00:00 AM 3 3x3   5982969 2101168 37.7484206232379 -122.50170211889 (37.7484206232379, -122.50170211889) 1 8 3 29491 35
101680 255378 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2699X Vicente St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2018 12:00:00 AM 3 3x3   5984648 2097442 37.7382885158105 -122.495621472041 (37.7382885158105, -122.495621472041) 1 8 3 29491 35
104008 79418 Planning Code 138.1 required 2 Brahea edulis :: Guadalupe Palm 218 1746 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2   10/27/2001 12:00:00 AM   3x3   5981053.87958296 2103176.2415425 37.7538220108937 -122.508473505042 (37.7538220108937, -122.508473505042) 1 8 3 56 35
105730 120914 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1356 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/26/2016 12:00:00 AM 3 3x3   5989939 2106143 37.7624875866057 -122.477963922005 (37.7624875866057, -122.477963922005) 1 8 3 56 35
125559 120527 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1672 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2016 12:00:00 AM 3 3x3   5981030 2103685 37.7552175094175 -122.508593851446 (37.7552175094175, -122.508593851446) 1 8 3 56 35
160718 117479 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 1 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
164050 114792 Planning Code 138.1 required 2 Callistemon citrinus :: Lemon Bottlebrush 67 10 Linares Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x10   5993887.4 2102332.1 37.7522522176371 -122.464031307011 (37.7522522176371, -122.464031307011) 1 8 4 29491 40
165057 255376 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2699X Vicente St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2018 12:00:00 AM 3 3x3   5984648 2097442 37.7382885158105 -122.495621472041 (37.7382885158105, -122.495621472041) 1 8 3 29491 35
166329 117480 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 2 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
167011 254235 Planning Code 138.1 required 2 Syzygium australe :: Eugenia 228 454 Ralston St 1 Unaccepted Street : Cutout Tree Private 2       10x10   5992261 2090872 37.7206918008503 -122.468821743954 (37.7206918008503, -122.468821743954) 9 8 6 64 24
167666 173650 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 80 Entrada Ct 2 Sidewalk: Property side : Yard Tree Private 2   12/21/2016 12:00:00 AM 3 4x10   5992424.45657 2092194.59394 37.7243327619491 -122.468352901223 (37.7243327619491, -122.468352901223) 9 8 4 59 40
172845 255375 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2699X Vicente St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2018 12:00:00 AM 3 3x3   5984648 2097442 37.7382885158105 -122.495621472041 (37.7382885158105, -122.495621472041) 1 8 3 29491 35
179923 122379 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 466 Vernon St 1 Front Yard : Cutout Tree Private 2   10/26/2016 12:00:00 AM 3 3x3   5992521 2090937 37.7208852925782 -122.467927737968 (37.7208852925782, -122.467927737968) 9 8 6 64 24
180231 254400 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2346 46th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   02/12/2018 12:00:00 AM 3 3X3   5982081.05878 2099125.72352 37.7427609043033 -122.504621254744 (37.7427609043033, -122.504621254744) 1 8 3 29491 35
184372 117482 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 4 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
184867 112863 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2451 19TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2015 12:00:00 AM 3 3x3   5990427 2098705 37.7420931085193 -122.475732948104 (37.7420931085193, -122.475732948104) 1 8 3 29491 35
187328 117481 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 3 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
194418 265072 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 2027 41st Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5983517.97374 2101348.17171 37.7489475550359 -122.499817124771 (37.7489475550359, -122.499817124771) 1 8 3 29491 35
42827 253341 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1935 46th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   08/23/2017 12:00:00 AM 3 3x3 Permit Number 769984 5981944.68101 2101921.14451 37.7504283278742 -122.505299944249 (37.7504283278742, -122.505299944249) 1 8 3 29491 35
28863 115887 Planning Code 138.1 required 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 134 Lunado Way 2 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3 2x4 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397) 9 8 4 59 40
29841 115885 Planning Code 138.1 required 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 134 Lunado Way 1 Sidewalk: Property side : Yard Tree Private 2   03/01/2016 12:00:00 AM 3 10x10 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397) 9 8 4 59 40
45389 115886 Planning Code 138.1 required 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 134 Lunado Way 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3 2x4 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397) 9 8 4 59 40
49225 53968 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1354 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 773113 5988678.33594659 2106104.92629407 37.7623097958053 -122.482321255458 (37.7623097958053, -122.482321255458) 1 8 3 56 35
36667 112972 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4099x ULLOA ST 1 Sidewalk: Property side : Cutout Tree Private 2   10/20/2015 12:00:00 AM 1 3x3 Permit Number 773327 5983385 2098079 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652) 1 8 3 29491 35
45850 112974 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4099x ULLOA ST 3 Sidewalk: Property side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385 2098079 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652) 1 8 3 29491 35
64240 112973 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4099x ULLOA ST 2 Sidewalk: Property side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385 2098079 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652) 1 8 3 29491 35
124554 112975 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4099x ULLOA ST 4 Sidewalk: Property side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385 2098079 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652) 1 8 3 29491 35
95009 173748 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1259 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2017 12:00:00 AM 3 3x3 Permit Number 773489 5989520 2106786 37.7642287625639 -122.479460118399 (37.7642287625639, -122.479460118399) 1 8 3 56 35
1560 258220 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 477 Eucalyptus Dr 2 Sidewalk: Property side : Cutout Tree Private 2   07/03/2019 12:00:00 AM 3 3x3 Permit Number 774069 5989683 2094686 37.7310148065902 -122.478011682019 (37.7310148065902, -122.478011682019) 1 8 4 64 14
18060 258219 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 477 Eucalyptus Dr 1 Sidewalk: Property side : Cutout Tree Private 2   07/03/2019 12:00:00 AM 3 3x3 Permit Number 774069 5989683 2094686 37.7310148065902 -122.478011682019 (37.7310148065902, -122.478011682019) 1 8 4 64 14
184166 115674 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1433 48th Ave   Sidewalk: Curb side : Cutout Tree Private 2   10/18/2016 12:00:00 AM 3 3x3 Permit Number 774098 5981190.2 2105303.4 37.7596706142775 -122.508159957785 (37.7596706142775, -122.508159957785) 1 8 3 56 35
53166 112854 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 2622 JUDAH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 774112 5986417 2105735 37.7611622818619 -122.49011505097 (37.7611622818619, -122.49011505097) 1 8 3 56 35
114870 253576 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 2622 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 774112 5986417 2105735 37.7611622818619 -122.49011505097 (37.7611622818619, -122.49011505097) 1 8 3 56 35
151100 81972 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1822 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/2015 12:00:00 AM 3 3x6 Permit Number 774361 5989407.90008391 2102936.76390687 37.7536532824256 -122.479566183797 (37.7536532824256, -122.479566183797) 1 8 3 56 35
8046 261018 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 79 Cragmont Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/15/2019 12:00:00 AM 3 3x3 Permit Number 774761 5992858 2101375 37.749564886931 -122.467521508976 (37.749564886931, -122.467521508976) 1 8 4 29491 12
11989 261017 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 79 Cragmont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/2019 12:00:00 AM 3 3x3 Permit Number 774761 5992858 2101375 37.749564886931 -122.467521508976 (37.749564886931, -122.467521508976) 1 8 4 29491 12
106240 122625 Planning Code 138.1 required 2 Cordyline australis :: Dracena Palm 64 189 Country Club Dr 1 Sidewalk: Property side : Cutout Tree Private 2   11/15/2016 12:00:00 AM 3 4x5 Permit Number 774974 5984222 2094938 37.7313882480876 -122.496909587532 (37.7313882480876, -122.496909587532) 1 8 4 64 35
178269 122626 Planning Code 138.1 required 2 Cordyline australis :: Dracena Palm 64 330 Country Club Dr 1 Sidewalk: Property side : Cutout Tree Private 2   11/15/2016 12:00:00 AM 3 3x5 Permit Number 774975 5984613 2095517 37.7330009316807 -122.495600537949 (37.7330009316807, -122.495600537949) 1 8 4 64 35
171095 122627 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 34 Country Club Dr 1 Sidewalk: Property side : Cutout Tree Private 2   11/15/2016 12:00:00 AM 3 3x4 Permit Number 775279 5984731 2094410 37.7299683129055 -122.495110985344 (37.7299683129055, -122.495110985344) 1 8 4 64 35
25630 255709 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 2458 40th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   06/28/2018 12:00:00 AM 3 3x3 Permit Number 775348 5983968.47211 2098431.39968 37.740965323086 -122.498043953777 (37.740965323086, -122.498043953777) 1 8 3 29491 35
105599 256614 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1483 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2018 12:00:00 AM 3 3x3 Permit Number 776026 5987111.69916 2105187.42749 37.7596993421459 -122.487672186767 (37.7596993421459, -122.487672186767) 1 8 3 56 35
120310 173614 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2955 20th Ave 2 Sidewalk: Property side : Yard Tree Private 2   12/12/2016 12:00:00 AM 3 3x6 Permit Number 776469 5990236.78382 2095590.44954 37.7335303227244 -122.476163213901 (37.7335303227244, -122.476163213901) 1 8 4 64 35
146537 173613 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2955 20th Ave 1 Sidewalk: Property side : Yard Tree Private 2   12/12/2016 12:00:00 AM 3 3x6 Permit Number 776469 5990236.78382 2095590.44954 37.7335303227244 -122.476163213901 (37.7335303227244, -122.476163213901) 1 8 4 64 35
89164 67994 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 241 Minerva St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 776577 5994615.10957021 2088996.30431809 37.7156773106674 -122.460548527933 (37.7156773106674, -122.460548527933) 9 8 6 28861 24
62051 254764 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 77 Caine Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2018 12:00:00 AM 3 3x3 Permit Number 776607 5997448.21567 2089391.00345 37.7169236459528 -122.450784510991 (37.7169236459528, -122.450784510991) 9 8 6 28861 24
57156 254766 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 79 Caine Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2018 12:00:00 AM 3 3x3 Permit Number 776608 5997440.77634 2089380.40278 37.7168941131095 -122.450809461106 (37.7168941131095, -122.450809461106) 9 8 6 28861 24
186896 114793 Planning Code 138.1 required 2 Tree(s) :: 17 10 Linares Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x10 Permit Number 777094 5993887.4 2102332.1 37.7522522176371 -122.464031307011 (37.7522522176371, -122.464031307011) 1 8 4 29491 40
23597 115495 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 1199X OCEAN AVE 3 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259 2091739 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389) 9 8 4 28861 24
27737 115492 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 280 BRIGHTON AVE 3 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259 2091739 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389) 9 8 4 28861 24
46086 115494 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 1199X OCEAN AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259 2091739 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389) 9 8 4 28861 24
65049 115493 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 280 BRIGHTON AVE 4 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259 2091739 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389) 9 8 4 28861 24
71090 115491 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 280 BRIGHTON AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259 2091739 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389) 9 8 4 28861 24
155417 106315 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 1199X OCEAN AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259 2091739 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389) 9 8 4 28861 24
186409 115490 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 280 BRIGHTON AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259 2091739 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389) 9 8 4 28861 24
5422 122567 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 241 Flournoy St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2020 12:00:00 AM 3 3x3 Permit Number 777809 5994026.14526 2086558.74537 37.7089504501359 -122.46240754496 (37.7089504501359, -122.46240754496) 9 8 6 28861 25
145605 183545 Planning Code 138.1 required 2 Agonis flexuosa :: Peppermint Willow 65 2580 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/13/2017 12:00:00 AM 3 4x4 Permit Number 777874 5988340.9772 2097760.0505 37.7393773655768 -122.482876432223 (37.7393773655768, -122.482876432223) 1 8 3 29491 35
49019 113699 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 239 Minerva St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2016 12:00:00 AM 3 3x3 Permit Number 778180 5994635.15348587 2088996.04011087 37.7156777383317 -122.460479228374 (37.7156777383317, -122.460479228374) 9 8 6 28861 24
46091 98406 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 237 Minerva St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2016 12:00:00 AM 3 3x3 Permit Number 778181 5994692.2 2088928.8 37.7154963945459 -122.460277182084 (37.7154963945459, -122.460277182084) 9 8 6 28861 24
120709 253166 Planning Code 138.1 required 2 Pyrus kawakamii :: Evergreen Pear 83 2405 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/2017 12:00:00 AM 3 3x3 Permit Number 778209 5986396.6612 2098868.17463 37.742306656921 -122.489680395865 (37.742306656921, -122.489680395865) 1 8 3 29491 35
24135 254150 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 2123 30th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/09/2018 12:00:00 AM 3 3x6 Permit Number 778310 5986951.71761 2100810.65655 37.7476725845461 -122.487903895201 (37.7476725845461, -122.487903895201) 1 8 3 29491 35
82445 254665 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1771 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/26/2018 12:00:00 AM 3 3x3 Permit Number 778441 5989948 2103325 37.7547506343258 -122.477726795598 (37.7547506343258, -122.477726795598) 1 8 3 56 35
31798 154902 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1101X Ortega St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2018 12:00:00 AM 3 4x4 Permit Number 778565 5990408 2102358 37.7521221923779 -122.476065384407 (37.7521221923779, -122.476065384407) 1 8 4 29491 12
34999 154898 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1101X Ortega St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2018 12:00:00 AM 3 4x4 Permit Number 778565 5990408 2102358 37.7521221923779 -122.476065384407 (37.7521221923779, -122.476065384407) 1 8 4 29491 12
86852 154903 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1101X Ortega St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2018 12:00:00 AM 3 4x4 Permit Number 778565 5990408 2102358 37.7521221923779 -122.476065384407 (37.7521221923779, -122.476065384407) 1 8 4 29491 12
160246 254370 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1101X Ortega St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2018 12:00:00 AM 3 4x4 Permit Number 778565 5990408 2102358 37.7521221923779 -122.476065384407 (37.7521221923779, -122.476065384407) 1 8 4 29491 12
14929 256105 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1935 34th Ave 1 Sidewalk: Property side : Cutout Tree Private 2 Port 09/06/2018 12:00:00 AM 3 3x3 Permit Number 778629 5985666.45669 2102048.38182 37.7509959848908 -122.492439326416 (37.7509959848908, -122.492439326416) 1 8 3 29491 35
194213 253623 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1331 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/11/2017 12:00:00 AM 3 3x3 Permit Number 778744 5983976.42262 2106100.27997 37.7620224120695 -122.498582815109 (37.7620224120695, -122.498582815109) 1 8 3 56 35
24860 121465 Planning Code 138.1 required 2 Tree(s) :: 17 218 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2016 12:00:00 AM 3 3x3 Permit Number 778899 5994755.06729 2090055.4837 37.7185936165551 -122.460141464151 (37.7185936165551, -122.460141464151) 9 8 6 28861 24
107033 104876 Planning Code 138.1 required 2 Prunus laurocerasus :: English laurel 371 2478 43rd Ave   Sidewalk: Property side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3   Permit Number 778928 5983068.6 2098273.8 37.7404797966413 -122.501143676277 (37.7404797966413, -122.501143676277) 1 8 3 29491 35
139506 254366 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 79 Ashton Ave 1 Front Yard : Yard Tree Private 2   02/06/2018 12:00:00 AM 3   Permit Number 778929 5994130.90698 2090445.22251 37.7196278254181 -122.462327167234 (37.7196278254181, -122.462327167234) 9 8 6 28861 24

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