trees

1,011 rows where qLegalStatus_id = 2 sorted by qCaretaker_id

✎ View and edit SQL

This data as json, CSV (advanced)

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)
15827 262585 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2 Byron Ct 1 Front Yard : Yard Tree Private 2   08/19/2020 12:00:00 AM 3 8x8 Permit Number 781313 5999459.72778 2086749.57445 37.7097858201455 -122.443642066205 (37.7097858201455, -122.443642066205) 9 7 6 28861 5
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
16066 260290 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1029 Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2019 12:00:00 AM 3 Width 4ft   6006781.41851 2114264.09095 37.7857493130165 -122.420288474132 (37.7857493130165, -122.420288474132) 13 9 9 28858 36
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
16206 109465 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 10 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013321.87847 2109385.26551 37.7727195476045 -122.397317921189 (37.7727195476045, -122.397317921189) 14 2 9 310 20
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
16371 260999 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 77 Belgrave Ave 2 Sidewalk: Property side : Yard Tree Private 2   11/12/2019 12:00:00 AM 3 6x6 Permit Number 781419 5998149.61527 2104897.27011 37.7595402565853 -122.449476776674 (37.7595402565853, -122.449476776674) 15 5 11 28862 12
16386 262532 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 815 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2020 12:00:00 AM 3 4x4 Permit Number 781917 5999987.51846 2111668.14853 37.7782363548085 -122.443606817465 (37.7782363548085, -122.443606817465) 15 5 11 29490 16
16409 54948 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 1531 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/28/1972 12:00:00 AM 15 6x3 Permit Number 779312 5982470.8167 2104681.2673 37.7580377938942 -122.503684942327 (37.7580377938942, -122.503684942327) 1 8 3 56 35
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
16618 251060 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 5418 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft Permit Number 777516 5990225.155 2112720.9896 37.7805655538274 -122.477455019941 (37.7805655538274, -122.477455019941) 11 6 2 55 26
16662 260846 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 6 Cragmont Ave 2 Sidewalk: Property side : Yard Tree Private 2   10/15/2019 12:00:00 AM 3 4x4 Permit Number 782122 5992584.1181 2101828.636 37.7507946382458 -122.468501593976 (37.7507946382458, -122.468501593976) 1 8 4 29491 12
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
16780 85805 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011627 2111882 37.7794804977568 -122.403356401218 (37.7794804977568, -122.403356401218) 14 2 9 28856 34
16815 109466 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 11 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2017 12:00:00 AM 3 4x4 Permit Number 773752 6013302.89282 2109368.02055 37.7726711397891 -122.397382385507 (37.7726711397891, -122.397382385507) 14 2 9 310 20
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
17276 72565 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 270 Brannan St 1 Sidewalk: Property side : Cutout Tree Private 2     3 4x4 Permit Number 770847 6015158 2112983 37.7827001752808 -122.391218053322 (37.7827001752808, -122.391218053322) 6 2 9 28856 6
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
17501 251213 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 6 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604 2111950 37.7796659253507 -122.403440753721 (37.7796659253507, -122.403440753721) 14 2 9 28856 34
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
17726 65839 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2328 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2018 12:00:00 AM 3 6x6 Permit Number 772721 5999589.88517 2120533.82376 37.802556482867 -122.445620078411 (37.802556482867, -122.445620078411) 13 9 1 57 17
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
17863 261376 Planning Code 138.1 required 2 Olea Majestic Beauty :: 183 3015 25th Ave 1 Sidewalk: Property side : Yard Tree Private 2   01/08/2020 12:00:00 AM 3 4x10 Permit Number 784883 5988814.87181 2095155.07295 37.7322523337557 -122.481047245899 (37.7322523337557, -122.481047245899) 1 8 4 64 35
17886 261591 Planning Code 138.1 required 2 :: 45 1747 Cayuga Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/28/2020 12:00:00 AM 3   Permit Number 784552 5998049.81023 2088594.07996 37.7147698965646 -122.44864773571 (37.7147698965646, -122.44864773571) 9 7 6 28861 25
17897 254369 Planning Code 138.1 required 2 Citrus spp :: Lemon: Orange: Lime 120 590X Orizaba Ave 2 Back Yard : Yard Tree Private 2   02/06/2018 12:00:00 AM 3   Permit Number 778929                    
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
18138 260191 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1699 Market St 4 Sidewalk: Property side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 4X4   6006124.91889 2109483.72494 37.7725865765291 -122.422220029928 (37.7725865765291, -122.422220029928) 8 2 9 28853 19
18342 253705 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 98X Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137                    
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
18507 254122 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 4 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
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
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
18618 170106 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 527 Mangels Ave 1 Sidewalk: Property side : Yard Tree Private 2   08/18/2020 12:00:00 AM 3 6x10 Permit Number 783167 5997920.28587 2095246.22061 37.7330277118397 -122.449574473879 (37.7330277118397, -122.449574473879) 9 7 4 59 40
18657 251312 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1499 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2019 12:00:00 AM 3 4x4 Permit Number 779703 6003369 2099547 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183) 2 7 5 63 22
18826 262002 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607X Florida St 8 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009282 2105415 37.7615923672124 -122.411011879772 (37.7615923672124, -122.411011879772) 2 4 7 28859 19
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
19151 242322 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 99X San Jose Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   09/17/2019 12:00:00 AM 3 4x4 Permit Number 776221 6006212.50813 2102671.12138 37.7538857096745 -122.421433147433 (37.7538857096745, -122.421433147433) 2 4 5 28859 19
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
19431 242096 Planning Code 138.1 required 2 Quercus suber :: Cork Oak 78 3721 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/2019 12:00:00 AM 3 4x4 Permit Number 769571 6003563.92038 2103590.2718 37.756259789464 -122.430658162741 (37.756259789464, -122.430658162741) 2 4 5 28862 22
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
19998 69332 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 160 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/23/1994 12:00:00 AM 11   Permit Number 781107 6013130.58112 2106316.68773 37.7642832664742 -122.397764366249 (37.7642832664742, -122.397764366249) 14 3 8 28856 29
20105 255010 Planning Code 138.1 required 2 :: 45 619 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x6   5989082.77589 2111106.98355 37.7760675897916 -122.481288779285 (37.7760675897916, -122.481288779285) 11 6 2 55 26
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
20157 121528 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 4 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
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
20702 37086 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1426 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/2017 12:00:00 AM 3   Permit Number 780691 5981873.63686209 2105374.96731705 37.7599073668224 -122.505801636192 (37.7599073668224, -122.505801636192) 1 8 3 56 35
20988 201691 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 324 08th St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009873.18605 2110010.6659 37.7742441430989 -122.40929152101 (37.7742441430989, -122.40929152101) 8 2 9 28853 34
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
21732 121544 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 5 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
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
21880 201692 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 324 08th St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009893.13849 2109987.83278 37.7741825665069 -122.409220890035 (37.7741825665069, -122.409220890035) 8 2 9 28853 34
22052 115353 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014819.91687 2114646.31579 37.7872484927813 -122.39250406973 (37.7872484927813, -122.39250406973) 6 2 9 28855 6
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
22638 113651 Planning Code 138.1 required 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 98X 10TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
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
22749 184649 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 1688 42nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft Permit Number 782197 5983169.0582 2103665.8835 37.7552908641291 -122.501195062681 (37.7552908641291, -122.501195062681) 1 8 3 56 35
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
23724 15248 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1401X Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2016 12:00:00 AM 3 3X3 Permit Number 770901 6007914.86722 2110337.26914 37.7750310067149 -122.41608885424 (37.7750310067149, -122.41608885424) 8 2 9 28853 34
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
24826 198583 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013760.46871 2107146.56354 37.7665969793027 -122.395643896153 (37.7665969793027, -122.395643896153) 14 3 8 28856 20
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
25972 121523 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 280 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
26024 203202 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013039.197 2107156.64294 37.7665845074832 -122.398139372753 (37.7665845074832, -122.398139372753) 14 3 8 28856 20
26350 115356 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 9 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014763.69701 2114705.74438 37.7874085478076 -122.392702738938 (37.7874085478076, -122.392702738938) 6 2 9 28855 6
26464 251519 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
26508 113650 Planning Code 138.1 required 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 98X 10TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
26571 150167 Planning Code 138.1 required 2 Pyrus kawakamii :: Evergreen Pear 83 333 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2017 12:00:00 AM 3 Width 3ft Permit Number 779492 6014367.55242 2105483.96934 37.7620656102492 -122.393427719319 (37.7620656102492, -122.393427719319) 10 3 8 28856 29
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
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
27322 201695 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009961.08769 2109918.57103 37.7739961964126 -122.408980952704 (37.7739961964126, -122.408980952704) 8 2 9 28853 34
27368 109463 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2017 12:00:00 AM 3 4x4 Permit Number 773752 6013357.96458 2109418.68041 37.7728133064148 -122.397195438039 (37.7728133064148, -122.397195438039) 14 2 9 310 20
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
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
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
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
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
29612 119287 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 400 Grove St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/28/2016 12:00:00 AM 3 4x4   6005873 2111410 37.7778614491402 -122.423228396467 (37.7778614491402, -122.423228396467) 7 9 11 28852 10
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
30147 115348 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014915.48611 2114547.78532 37.7869832575075 -122.39216652446 (37.7869832575075, -122.39216652446) 6 2 9 28855 6
30239 121540 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 1 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 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
31022 79408 Planning Code 138.1 required 2 Quercus agrifolia :: Coast Live Oak 172 322 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2018 12:00:00 AM 3 4x4 Permit Number 776851 6004758.73696772 2101857.84943819 37.7515705801104 -122.426402728229 (37.7515705801104, -122.426402728229) 2 4 5 28862 22

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);