trees

184 rows where SiteOrder = 2 and qLegalStatus_id = 2 sorted by TreeID

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: SiteOrder

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)
728 102430 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 200 06th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2017 12:00:00 AM 3 4x4 Permit Number 770993 6010566.09371 2111909.33227 37.7794962351107 -122.407028471514 (37.7794962351107, -122.407028471514) 14 2 9 28853 34
127597 103379 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 2712 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2013 12:00:00 AM 4 3x3 Permit Number 770136 6000520 2117210 37.7934832007909 -122.44216269001 (37.7934832007909, -122.44216269001) 13 9 1 57 27
135960 103695 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1X Hill St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006027.79546 2103458.18152 37.7560363783091 -122.422127839194 (37.7560363783091, -122.422127839194) 2 4 5 28859 19
48155 107646 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1600X Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3   Permit Number 773331 6005773.76538 2115716.99395 37.7896817924241 -122.423878022401 (37.7896817924241, -122.423878022401) 13 9 1 28858 41
193110 109470 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013467.61268 2109523.16527 37.7731063019529 -122.396823476633 (37.7731063019529, -122.396823476633) 14 2 9 310 20
193198 111714 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3038 CLEMENT ST 2 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM 1 3x3 Permit Number 777015 5986051 2113265 37.7818161572934 -122.491935266217 (37.7818161572934, -122.491935266217) 11 6 2 55 26
120325 112085 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 99X Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2015 12:00:00 AM     Permit Number 775592 6013631.8 2115864.7 37.7905278405438 -122.396700174955 (37.7905278405438, -122.396700174955) 12 2 9 28855 6
175873 112198 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 2570 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM 3 3x3 Permit Number 771994 6001873.5131 2116702.41623 37.7921665513862 -122.437443074554 (37.7921665513862, -122.437443074554) 13 6 1 29490 27
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
93218 113240 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 329 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM 2 3x4 Permit Number 770912 6014728.70394 2112464.72966 37.7812532891345 -122.392666980121 (37.7812532891345, -122.392666980121) 6 2 9 28856 6
160249 113337 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2X STANFORD ST 2 Sidewalk: Property side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727 2112481 37.7812978691674 -122.392674013487 (37.7812978691674, -122.392674013487) 6 2 9 28856 6
154892 113645 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1400 MISSION ST 2 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2016 12:00:00 AM 3 4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
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
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
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
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
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
122740 115096 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 537 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010119.08101 2111896.4319 37.7794357889593 -122.408573975335 (37.7794357889593, -122.408573975335) 14 2 9 28853 34
96508 115347 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 398X HARRISON ST 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x4 Permit Number 773314 6014854 2114630 37.7872055860551 -122.392385006805 (37.7872055860551, -122.392385006805) 6 2 9 28855 6
152753 115349 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014896.08459 2114567.05321 37.7870350854597 -122.392234997951 (37.7870350854597, -122.392234997951) 6 2 9 28855 6
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
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
135842 115529 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 101 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007327.31765 2111347.52577 37.777771876795 -122.418192961161 (37.777771876795, -122.418192961161) 7 9 9 28852 36
34272 115532 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 2 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007293.46404 2111265.83422 37.7775456658356 -122.418304279225 (37.7775456658356, -122.418304279225) 7 9 9 28852 36
12720 115537 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
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
188951 115977 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011639.0005 2091249.90123 37.7228299259539 -122.40186416949 (37.7228299259539, -122.40186416949) 10 3 7 309 28
177060 116640 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 270 Brannan St 2 Sidewalk: Property side : Cutout Tree Private 2     1 4x4   6015158 2112983 37.7827001752808 -122.391218053322 (37.7827001752808, -122.391218053322) 6 2 9 28856 6
190292 116775 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008794.04431 2117993.28546 37.7961019747828 -122.413589186808 (37.7961019747828, -122.413589186808) 5 1 10 308 21
164459 116850 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 83 Panorama Dr 2 Front Yard : Yard Tree Private 2   05/03/2016 12:00:00 AM 3     5997625.8 2100317.8 37.7469361901044 -122.450958160054 (37.7469361901044, -122.450958160054) 1 5 4 59 38
97662 117018 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008125.66458 2112987.05621 37.7823185388132 -122.415547303188 (37.7823185388132, -122.415547303188) 7 10 9 28852 36
64492 117113 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1650 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005663.57094 2117913.49378 37.7957066076266 -122.424415580821 (37.7957066076266, -122.424415580821) 13 9 1 28858 27
52945 117454 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 236 Shipley St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2016 12:00:00 AM 3 3x3 Permit Number 776408 6011519 2111785 37.7792081256956 -122.403723194086 (37.7792081256956, -122.403723194086) 14 2 9 28856 34
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
5835 118375 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 4x6   6014712.48727 2114662.02755 37.7872856671566 -122.392876855803 (37.7872856671566, -122.392876855803) 6 2 9 28855 6
97781 119286 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 400 Grove St 2 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
117515 119808 Planning Code 138.1 required 2 Eucalyptus sideroxylon :: Red Ironbark 127 1634 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3 3x3 Permit Number 773331 6006048 2115627 37.7894501691998 -122.422922798032 (37.7894501691998, -122.422922798032) 13 9 1 28858 41
47024 120519 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 520 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010156 2108818 37.7709851997146 -122.408229076629 (37.7709851997146, -122.408229076629) 8 2 9 28853 34
1751 121138 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1388x Minna St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2016 12:00:00 AM 3 3x3                      
3 121463 Planning Code 138.1 required 2 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 415 Oxford St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2020 12:00:00 AM 3 3x3 Permit Number 778984 6006773.54328 2092061.724 37.7247862819155 -122.418740608563 (37.7247862819155, -122.418740608563) 9 7 7 309 28
37189 121502 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 2 Sidewalk: Property side : Cutout Tree Private 2     4 10x4   6014428.99687 2115060.94265 37.7883652457059 -122.393885614549 (37.7883652457059, -122.393885614549) 6 2 9 28855 6
178528 121507 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 300 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6012241.512 2112714.7441 37.7818013227969 -122.401289065763 (37.7818013227969, -122.401289065763) 6 2 9 28856 34
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
40138 121526 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
187581 121535 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
186332 121541 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 2 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
168133 121551 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1125 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/23/2017 12:00:00 AM 3 3x3 Permit Number 778243 6009293.51408 2111653.12836 37.7787214646499 -122.411412777974 (37.7787214646499, -122.411412777974) 8 2 9 28853 34
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
60760 122593 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 72 Townsend 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
183675 122698 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 98 Woolsey St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2016 12:00:00 AM 3 3x3   6011441.99272 2092150.08828 37.725290657742 -122.402608459524 (37.725290657742, -122.402608459524) 10 3 7 309 28
152864 124718 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 610 Cortland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/22/2018 12:00:00 AM 3 3x3 Permit Number 775784 6007724.21349 2097196.46477 37.7389386461297 -122.415817669649 (37.7389386461297, -122.415817669649) 2 7 7 28859 2
190939 13063 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 590 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/29/2017 12:00:00 AM 3 2X2 Permit Number 780933 6009554.3361 2120533.7978 37.803120257284 -122.411137959105 (37.803120257284, -122.411137959105) 3 1 10 308 23
193648 147591 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 Width 4ft Permit Number 777516 5990250.17652 2113053.797 37.7814808023322 -122.477392789959 (37.7814808023322, -122.477392789959) 11 6 2 55 26
67108 152327 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 49 San Carlos St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 4x4   6006657.39777 2105617.1383 37.7619998635108 -122.420103671551 (37.7619998635108, -122.420103671551) 8 4 7 28859 19
61214 15236 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2015 12:00:00 AM 3 3X3 Permit Number 770747 6008261.49106 2110663.48431 37.7759461992201 -122.414912896556 (37.7759461992201, -122.414912896556) 8 2 9 28853 34
158086 15247 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1401X Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2016 12:00:00 AM 3 3X3 Permit Number 770901 6007902.55668 2110326.57547 37.7750009522643 -122.416130681693 (37.7750009522643, -122.416130681693) 8 2 9 28853 34
179256 152616 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 3098 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2019 12:00:00 AM 3 3x3 Permit Number 782654 6009096.56353 2101019.92176 37.7495140728181 -122.411342732484 (37.7495140728181, -122.411342732484) 2 4 7 28859 19
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
36893 152811 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 2901 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6009988.15821 2101607.87857 37.7511784382559 -122.40830102207 (37.7511784382559, -122.40830102207) 2 4 7 28859 19
6679 152982 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 3400 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 4x4 Permit Number 776221 6006311.85744 2102620.48455 37.7537522736602 -122.421085978553 (37.7537522736602, -122.421085978553) 2 4 5 28859 19
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
82212 156914 Planning Code 138.1 required 2 Tree(s) :: 17 2995 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2018 12:00:00 AM 3 3x3 Permit Number 782654 6009047.12311 2101072.92433 37.7496568330138 -122.411517443787 (37.7496568330138, -122.411517443787) 2 4 7 28859 19
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
113669 159358 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 49 Naglee Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998584.62871 2087583.88571 37.712026700246 -122.446726546692 (37.712026700246, -122.446726546692) 9 7 6 28861 25
179839 160370 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 868 Edinburgh St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001693.73373 2088950.71414 37.715956825716 -122.436078353349 (37.715956825716, -122.436078353349) 9 7 6 28861 5
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
5118 169123 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 210 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2019 12:00:00 AM 3 Width 4ft   6009469.52117 2113800.26568 37.7846268637924 -122.410955591431 (37.7846268637924, -122.410955591431) 14 10 9 28852 36
151446 170486 Planning Code 138.1 required 2 Rhamnus alaternus :: Italian Buckthorn 29 121 Cayuga Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2018 12:00:00 AM 3 4x4 Permit Number 779173 6003308.3245 2094432.02915 37.7310988944888 -122.430888530379 (37.7310988944888, -122.430888530379) 9 7 5 28861 25
147840 170500 Planning Code 138.1 required 2 Rhamnus alaternus :: Italian Buckthorn 29 1178 Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2018 12:00:00 AM 3 4x4 Permit Number 779173 6003320.2391 2094320.37512 37.7307929928046 -122.430839374365 (37.7307929928046, -122.430839374365) 9 7 5 28861 25
118329 172747 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1230 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6006022.78943 2120387.12776 37.8025188570147 -122.423348551388 (37.8025188570147, -122.423348551388) 5 9 1 28858 32
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
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
6889 173762 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1405 Van Dyke Ave 2 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
51709 173899 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 1762 12th Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 779465 5992511.90241 2103608.89481 37.7556785957656 -122.468880856653 (37.7556785957656, -122.468880856653) 1 8 4 56 12
47537 18353 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 480 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/02/2013 12:00:00 AM 3 3x3   6010310.70956 2106111.3358 37.7635619805233 -122.407503071611 (37.7635619805233, -122.407503071611) 8 4 8 28859 19
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
135962 187674 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
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
160771 187941 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 2 Sidewalk: Curb side : Yard Tree Private 2     3     6015065.49236 2115322.58848 37.7891190169896 -122.391701726057 (37.7891190169896, -122.391701726057) 6 2 9 28855 6
71488 190612 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 9 Washburn St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2018 12:00:00 AM 3 Width 3ft Permit Number 775218 6008236.46776 2110619.04505 37.7758227734432 -122.414996312823 (37.7758227734432, -122.414996312823) 8 2 9 28853 34
169960 192564 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.7777175065003 -122.413322904728 (37.7777175065003, -122.413322904728) 8 2 9 28853 34
52682 192595 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/07/1995 12:00:00 AM 3 Width 4ft Permit Number 770747 6008285.14461 2110684.68439 37.7760057386966 -122.414832573262 (37.7760057386966, -122.414832573262) 8 2 9 28853 34
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
98537 196590 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 43 Lafayette St 2 : Tree Private 2     10 Width 3ft Permit Number 772992 6007565.69447 2109618.27361 37.7730371773558 -122.417245760983 (37.7730371773558, -122.417245760983) 8 2 9 28853 19
185470 198582 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013779.59756 2107146.17602 37.7665969792947 -122.395577705173 (37.7665969792947, -122.395577705173) 14 3 8 28856 20
132587 199504 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 1009 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010510.13491 2111932.18806 37.7795558601644 -122.407223669342 (37.7795558601644, -122.407223669342) 14 2 9 28853 34
74052 201694 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009941.3987 2109939.6045 37.7740528464887 -122.409050544971 (37.7740528464887, -122.409050544971) 8 2 9 28853 34
176004 203201 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013028.4198 2107143.70013 37.7665483691258 -122.398175741313 (37.7665483691258, -122.398175741313) 14 3 8 28856 20
70866 224462 Planning Code 138.1 required 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2810 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2017 12:00:00 AM 3 3x3 Permit Number 775960 6010311.37562 2101086.64633 37.7497653433983 -122.407146558773 (37.7497653433983, -122.407146558773) 2 4 7 28859 19
761 224987 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 484 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2019 12:00:00 AM 3 4x4 Permit Number 782366 6003591.74199 2105457.02251 37.7613870178149 -122.430695151865 (37.7613870178149, -122.430695151865) 15 4 5 28862 3
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
1675 225195 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007206.11976 2103835.77909 37.7571395647689 -122.418079559351 (37.7571395647689, -122.418079559351) 2 4 7 28859 19
96451 225775 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 577 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft Permit Number 782239 6002401.77617 2104846.28665 37.75964259654 -122.43476706624 (37.75964259654, -122.43476706624) 2 4 5 28862 3
5042 231235 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2000 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009517.2839 2105385.27542 37.7615239413898 -122.410196026727 (37.7615239413898, -122.410196026727) 2 4 7 28859 19
7502 236582 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607 Florida St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009292.77734 2105398.52034 37.7615477221736 -122.410973441191 (37.7615477221736, -122.410973441191) 2 4 7 28859 19
27355 239457 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 165 Sussex St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001959.66963 2096487.1672 37.7366653238346 -122.435698035437 (37.7366653238346, -122.435698035437) 2 7 5 63 7
100425 243144 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 98x Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2017 12:00:00 AM 3 3x3   6006195 2098242 37.7417233638646 -122.421179213365 (37.7417233638646, -122.421179213365) 2 7 7 28859 2
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
173710 243660 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 4471 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/14/2018 12:00:00 AM 3 4x4 Permit Number 773370 6000282.83907 2102244.20874 37.7523773981989 -122.441908628496 (37.7523773981989, -122.441908628496) 2 4 5 28862 22
60942 247939 Planning Code 138.1 required 2 Quercus agrifolia :: Coast Live Oak 172 29 Joy St 2 Unaccepted Street : Yard Tree DPW 1     12   Permit Number 775404 6010258.29977 2098917.51569 37.7438064148349 -122.40717721395 (37.7438064148349, -122.40717721395) 2 7 7 28859 2

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