trees

1,011 rows where qLegalStatus_id = 2 sorted by PlotSize

✎ 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)
10742 166681 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 563 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2019 12:00:00 AM 3 3x3   6002718.47853 2102666.28528 37.7536748096657 -122.433515959096 (37.7536748096657, -122.433515959096) 2 4 5 28862 22
11143 258742 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 367 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2019 12:00:00 AM 3 3x3 Permit Number 774042 6003945 2103884 37.7570878795298 -122.429361203627 (37.7570878795298, -122.429361203627) 2 4 5 28862 3
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
11471 260869 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
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
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
11885 157920 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4147 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2019 12:00:00 AM 3 3x3 Permit Number 777832 6002961.17206 2100636.31842 37.7481147664022 -122.432531686182 (37.7481147664022, -122.432531686182) 2 4 5 63 22
11910 262222 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 240 Chattanooga St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2020 12:00:00 AM 3 3x3 Permit Number 781435 6004728 2102256 37.7526620712812 -122.426537368454 (37.7526620712812, -122.426537368454) 2 4 5 28862 22
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
12221 261589 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 299x 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006795 2107850 37.7681385292637 -122.41978620049 (37.7681385292637, -122.41978620049) 8 4 7 28853 19
12438 260430 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
12606 261830 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 256 Casitas Ave 2 Sidewalk: Property side : Yard Tree Private 2   03/05/2020 12:00:00 AM 3 3x3 Permit Number 781540 5994862.12068 2096567.59314 37.7364804498834 -122.460242983215 (37.7364804498834, -122.460242983215) 9 7 4 59 40
12677 259879 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 10 Romain St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2019 12:00:00 AM 3 3x3 Permit Number 776294 6001192.18773 2103413.52714 37.7556398401092 -122.438847746407 (37.7556398401092, -122.438847746407) 2 4 5 28862 3
12753 253419 Planning Code 138.1 required 2 :: 45 3499 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997570 2115996 37.7899813188913 -122.452282225129 (37.7899813188913, -122.452282225129) 11 6 1 54 31
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
13706 225187 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
13730 260870 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
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
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
14035 159355 Planning Code 138.1 required 2 Melaleuca quinquenervia :: Cajeput 10 417 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998509.88268 2087558.19074 37.7119518775514 -122.44698304145 (37.7119518775514, -122.44698304145) 9 7 6 28861 25
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
14175 260509 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 436 Colon Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5995686 2095271 37.7329676771739 -122.457300730651 (37.7329676771739, -122.457300730651) 9 7 4 59 40
14212 253124 Planning Code 138.1 required 2 Tree(s) :: 17 399x Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2017 12:00:00 AM 3 3x3 Permit Number 780530                    
14258 261352 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 297 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 780859 5994172 2087374 37.7111973453091 -122.461962532307 (37.7111973453091, -122.461962532307) 9 8 6 28861 24
14403 260183 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 66x McCoppin St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 3x3   6006141 2109130 37.7716162396968 -122.422139269172 (37.7716162396968, -122.422139269172) 8 2 9 28853 19
14869 117019 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008121.68381 2113004.40875 37.782365960952 -122.415562303882 (37.782365960952, -122.415562303882) 7 10 9 28852 36
14905 260579 Planning Code 138.1 required 2 Tree(s) :: 17 1662 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x3 Permit Number 782799 5985048 2103886 37.7560054004173 -122.494713443881 (37.7560054004173, -122.494713443881) 1 8 3 56 35
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
15413 262220 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 240 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2020 12:00:00 AM 3 3x3 Permit Number 781435 6004728 2102256 37.7526620712812 -122.426537368454 (37.7526620712812, -122.426537368454) 2 4 5 28862 22
15566 121139 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1388x Minna St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2016 12:00:00 AM 3 3x3                      
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
15819 151746 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 3030 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 779245 6008502.96204 2106251.6003 37.763845762487 -122.413765441348 (37.763845762487, -122.413765441348) 8 4 7 28859 19
15918 255699 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 9 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
16474 253340 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 1045 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2017 12:00:00 AM 3 3x3 Permit Number 780536 6004464 2102825 37.7542094840672 -122.427490860103 (37.7542094840672, -122.427490860103) 2 4 5 28862 22
16696 195151 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1912 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   6012043 2105629 37.7623344042956 -122.401477690357 (37.7623344042956, -122.401477690357) 8 3 8 28856 29
17123 254549 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 170 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2020 12:00:00 AM 3 3x3   5992784 2114350 37.7851865177567 -122.46872140612 (37.7851865177567, -122.46872140612) 11 6 2 54 11
17210 225188 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
17700 260555 Planning Code 138.1 required 2 Tree(s) :: 17 502 07th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/23/2019 12:00:00 AM 3 3x3   6011196 2109910 37.7740417608934 -122.404708555539 (37.7740417608934, -122.404708555539) 14 2 9 28853 34
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
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
18063 259659 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 4061 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 3x3 Permit Number 784440 6003514 2100377 37.7474340728524 -122.430601526112 (37.7474340728524, -122.430601526112) 2 4 5 63 22
18437 260868 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
18512 260829 Planning Code 138.1 required 2 Callistemon viminalis :: Weeping Bottlebrush 60 165 Cerritos Ave 2 Sidewalk: Property side : Yard Tree Private 2   10/10/2019 12:00:00 AM 3 3x3 Permit Number 781510 5991854 2092943 37.7263547341381 -122.470379348754 (37.7263547341381, -122.470379348754) 9 8 4 59 40
19030 221366 Planning Code 138.1 required 2 Quercus suber :: Cork Oak 78 55 Homestead St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/2019 12:00:00 AM 3 3x3 Permit Number 778991 6000992.93047 2101385.53728 37.7500601303816 -122.439391477336 (37.7500601303816, -122.439391477336) 2 4 5 28862 22
19087 261350 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 299 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 784323 5994169 2087374 37.7111971725927 -122.461972900974 (37.7111971725927, -122.461972900974) 9 8 6 28861 24
19183 261351 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 299 Sagamore St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 784323 5994169 2087374 37.7111971725927 -122.461972900974 (37.7111971725927, -122.461972900974) 9 8 6 28861 24
19209 122592 Planning Code 138.1 required 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 72 Townsend St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
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
19663 256686 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 11 Back Yard : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
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
20307 253871 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1601 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2017 12:00:00 AM 3 3x3 Permit Number 56289 6007037 2116831 37.7928118105792 -122.419586418272 (37.7928118105792, -122.419586418272) 13 9 10 28858 32
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
21074 256565 Planning Code 138.1 required 2 Acer buergeranum :: Trident Maple 110 2099X Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002352 2115365 37.7885215412843 -122.435691777518 (37.7885215412843, -122.435691777518) 13 6 1 29490 27
21720 122796 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 306 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/28/2016 12:00:00 AM 3 3x3   6009497.08014 2088289.51504 37.7145815488228 -122.4090595839 (37.7145815488228, -122.4090595839) 9 7 8 309 39
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
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
23551 121466 Planning Code 138.1 required 2 Tree(s) :: 17 79 Harrington St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2016 12:00:00 AM 3 3x3 Permit Number 778952 6001819.85633 2092538.60283 37.7258155279415 -122.435898987028 (37.7258155279415, -122.435898987028) 9 7 6 28861 25
23587 256680 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 330 Twin Peaks Blvd 6 Front Yard : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
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
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
24808 254852 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2816 Clement St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2018 12:00:00 AM 3 3x3   5986739 2113291 37.7819277358837 -122.48955705182 (37.7819277358837, -122.48955705182) 11 6 2 55 26
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
25098 257924 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1490x Green St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 3x3 Permit Number 779557 6005922 2118675 37.79781210117 -122.423575535726 (37.79781210117, -122.423575535726) 13 9 10 28858 32
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
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
27168 75842 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
27220 159357 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 49 Naglee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998577.13551 2087591.01668 37.7120458522191 -122.446752958004 (37.7120458522191, -122.446752958004) 9 7 6 28861 25
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
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
27935 253392 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.16338 2116767.09226 37.7930680031541 -122.392879995147 (37.7930680031541, -122.392879995147) 12 2 9 28855 6
28167 256679 Planning Code 138.1 required 2 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 330 Twin Peaks Blvd 5 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
28225 253377 Planning Code 138.1 required 2 :: 45 2 Alpine Ter 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001556 2108661 37.7700688079313 -122.43796542225 (37.7700688079313, -122.43796542225) 15 5 5 29492 9
29570 105276 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 64 Townsend St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015520.22928 2112423.42174 37.7811837949483 -122.389925782657 (37.7811837949483, -122.389925782657) 6 2 9 28856 6
30240 243370 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Hill St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006249.22799 2103449.78821 37.7560258191488 -122.421361454386 (37.7560258191488, -122.421361454386) 2 4 5 28859 19
30794 10153 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 978 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/11/2016 06:51:00 AM 3 3x3 Permit Number 780464 6005672.85931 2103292.97405 37.7555627312558 -122.423343584439 (37.7555627312558, -122.423343584439) 2 4 5 28859 19
31747 173761 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1405 Van Dyke Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2017 12:00:00 AM 3 3x3 Permit Number 773007 6015436.02818 2092717.71929 37.727071439337 -122.388840955894 (37.727071439337, -122.388840955894) 10 3 8 58 1
34077 256492 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 280 Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/17/2018 12:00:00 AM 3 3x3 Permit Number 780675 6001741.51076 2104267.16046 37.7580149486389 -122.437009129166 (37.7580149486389, -122.437009129166) 2 4 5 28862 3
34241 122599 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
34711 44001 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 2701X 17th St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
34716 255695 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
34894 253483 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
35262 253489 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 7 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
35619 85803 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 923 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 3x3 Permit Number 778048 6011427.0378 2111936.1074 37.779617893816 -122.40405196806 (37.779617893816, -122.40405196806) 14 2 9 28856 34
36004 187698 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2880 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008980.17665 2103937.78959 37.7575193538388 -122.41195137385 (37.7575193538388, -122.41195137385) 2 4 7 28859 19
36333 253491 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 9 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
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
36929 256611 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 80 Terra Vista Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2018 12:00:00 AM 3 3x3 Permit Number 780481 6000092 2112863 37.7815230689536 -122.443331223004 (37.7815230689536, -122.443331223004) 15 5 1 29490 16
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
37180 44003 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 2701X 17th St 9 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
37533 253101 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3000x Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427 2106455 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734) 1 8 3 56 35
37738 256569 Planning Code 138.1 required 2 Acer buergeranum :: Trident Maple 110 2099X Steiner St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002352 2115365 37.7885215412843 -122.435691777518 (37.7885215412843, -122.435691777518) 13 6 1 29490 27
37766 150676 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 548 Rhode Island St 1 Front Yard : Cutout Tree Private 2   11/07/2017 12:00:00 AM 3 3x3 Permit Number 780811 6011754.98399 2105812.52377 37.7628222449765 -122.402486741392 (37.7628222449765, -122.402486741392) 8 3 8 28856 29
37845 256671 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 423 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2019 12:00:00 AM 3 3x3 Permit Number 781122 5994719 2091406 37.7222997368586 -122.460363933092 (37.7222997368586, -122.460363933092) 9 8 4 28861 24
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
38312 167082 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 280 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/17/2018 12:00:00 AM 3 3x3 Permit Number 780675 6001741.51076 2104267.16046 37.7580149486389 -122.437009129166 (37.7580149486389, -122.437009129166) 2 4 5 28862 3
39420 253554 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1855 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2017 12:00:00 AM 3 3x3 Permit Number 778968 5986885.63083 2102641.2721 37.7526951056681 -122.488266922919 (37.7526951056681, -122.488266922919) 1 8 3 56 35
40028 57959 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 336 Hanover St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2017 12:00:00 AM 3 3x3 Permit Number 774423 5999490.29697456 2086502.70799744 37.7091097236101 -122.443518692288 (37.7091097236101, -122.443518692288) 9 7 6 28861 5
41357 255423 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2398X 44th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3 Permit Number 780836 5982745 2098835 37.7420016902952 -122.502304062071 (37.7420016902952, -122.502304062071) 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

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