215 rows where qLegalStatus_id = 9 sorted by Fire Prevention Districts descending

View and edit SQL

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)
3361 261454 Private 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2 Geneva Ave 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
4221 160246 Private 9 Potential Site :: Potential Site 48 962 Edinburgh St 1 Front Yard : Cutout Tree Private 2 DPW 02/20/2020 12:00:00 AM 3 3x3 Permit Number 779047 6001480.24176 2088600.7563 37.7149837880375 -122.436791243222 (37.7149837880375, -122.436791243222) 9 7 6 28861 5
8479 204048 Private 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2 Geneva Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
8858 261455 Private 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2 Geneva Ave 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
10378 163649 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 226 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 07/01/2020 12:00:00 AM 3 3x4 Permit Number 784460 5994737.04022 2087470.63166 37.71149518743 -122.460016622663 (37.71149518743, -122.460016622663) 9 8 6 28861 24
11157 261456 Private 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2 Geneva Ave 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
11394 260246 Private 9 Magnolia spp :: Magnolia 224 568 Huron Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/14/2019 12:00:00 AM 3 3x3 Permit Number 784595 5998297.39121 2088148.96817 37.7135618752392 -122.447759972312 (37.7135618752392, -122.447759972312) 9 7 6 28861 25
12761 261857 Private 9 Pistacia chinensis :: Chinese Pistache 32 176 Ramsell St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/2020 12:00:00 AM 3     5992988.80812 2088380.73889 37.7138934199028 -122.466125014283 (37.7138934199028, -122.466125014283) 9 8 6 64 24
14046 262297 Private 9 Sequoia sempervirens :: Coast Redwood 155 666 Hamilton St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009767 2091318 37.722912259595 -122.408340109411 (37.722912259595, -122.408340109411) 9 3 7 309 28
14848 260375 Private 9 Tree(s) :: 17 67 Allison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2019 12:00:00 AM 3 3x3 Permit Number 784562 5999904.1409 2088281.96487 37.714018757491 -122.442216028541 (37.714018757491, -122.442216028541) 9 7 6 28861 5
15121 261452 Private 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2 Geneva Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
15415 261457 Private 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2 Geneva Ave 12 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
15590 260947 Private 9 Tree(s) :: 17 143 Gambier St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6005856 2093079 37.72752779603 -122.421984681693 (37.72752779603, -122.421984681693) 9 7 7 309 5
16285 114961 Private 9 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 220 Evelyn Way 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2015 12:00:00 AM     Permit Number 776128 5997838.7 2098850.9 37.7429206264442 -122.450116261368 (37.7429206264442, -122.450116261368) 9 7 4 59 40
16566 261453 Private 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2 Geneva Ave 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
70534 104510 Private 9 Sequoia sempervirens :: Coast Redwood 155 254 ALLISON ST 1 Back Yard : Yard Tree Private 2     40     6000052 2087408 37.7116274717654 -122.441642291463 (37.7116274717654, -122.441642291463) 9 7 6 28861 5
74288 105439 Private 9 Tree(s) :: 17 790 LAKEVIEW AVE 1 Front Yard : Yard Tree Private 2           5994224.8 2089960.8 37.7183031233486 -122.461967505828 (37.7183031233486, -122.461967505828) 9 8 6 28861 24
112528 104689 Private 9 Pinus radiata :: Monterey Pine 15 657 PALMETTO AVE 1 Back Yard : Yard Tree Private 2     30     5991786 2087190.1 37.7105547448876 -122.470195680575 (37.7105547448876, -122.470195680575) 9 8 4 64 24
119423 114977 Private 9 Pittosporum undulatum :: Victorian Box 36 183 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2015 12:00:00 AM     Permit Number 774982 5996484.3 2091092.2 37.7215395068839 -122.454239087603 (37.7215395068839, -122.454239087603) 9 8 6 28861 24
160381 256862 Private 9 Picea Spp :: Spruce Spp 200 133 Majestic Ave 1 Back Yard : Yard Tree Private 2           5997017.00624 2089223.65081 37.7164394409514 -122.452262915882 (37.7164394409514, -122.452262915882) 9 8 6 28861 24
180111 256895 Private 9 Ginkgo biloba :: Maidenhair Tree 22 701 Congo St 1 Sidewalk: Property side : Cutout Tree Private 2       3x12 Permit Number 768867 6000183.68977 2096091.89275 37.7354789553486 -122.441809987085 (37.7354789553486, -122.441809987085) 9 7 4 63 40
1077 149677 Private 9 Melaleuca linariifolia :: Flaxleaf Paperbark 103 2100x Mariposa St 1 Front Yard : Cutout Tree DPW 1   05/19/2020 12:00:00 AM 3 Width 4ft Permit Number 784452 6011154.9566 2106050.92707 37.7634433311543 -122.404578819881 (37.7634433311543, -122.404578819881) 8 3 8 28856 29
3416 262187 Private 9 Melaleuca linariifolia :: Flaxleaf Paperbark 103 2100x Mariposa St 4 Front Yard : Cutout Tree DPW 1   05/19/2020 12:00:00 AM 3 Width 4ft Permit Number 784452 6011170 2106024 37.76337023621 -122.404524893747 (37.76337023621, -122.404524893747) 8 3 8 28856 29
7435 239668 Private 9 Butia capitata :: Pindo Palm 313 180 Dolores St 3 Sidewalk: Property side : Pot Landscaping Private 2     23 Width 4ft   6004776.3298 2107329.36682 37.7665950691341 -122.426731495165 (37.7665950691341, -122.426731495165) 8 4 5 28862 3
8898 149678 Private 9 Melaleuca linariifolia :: Flaxleaf Paperbark 103 2100x Mariposa St 2 Front Yard : Cutout Tree DPW 1   05/19/2020 12:00:00 AM 3 Width 4ft Permit Number 784452 6011170 2106024 37.76337023621 -122.404524893747 (37.76337023621, -122.404524893747) 8 3 8 28856 29
18413 149679 Private 9 Melaleuca linariifolia :: Flaxleaf Paperbark 103 2100x Mariposa St 3 Front Yard : Cutout Tree DPW 1   05/19/2020 12:00:00 AM 3 Width 4ft Permit Number 784452 6011170 2106024 37.76337023621 -122.404524893747 (37.76337023621, -122.404524893747) 8 3 8 28856 29
19354 262188 Private 9 Jacaranda mimosifolia :: Jacaranda 50 490 Vermont St 1 Front Yard : Cutout Tree DPW 1   05/19/2020 12:00:00 AM 3 3x3 Permit Number 784452 6011166 2106075 37.7635100471883 -122.404542318782 (37.7635100471883, -122.404542318782) 8 3 8 28856 29
5914 254656 Private 9 :: 45 640 Larch St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004524 2112776 37.781535924842 -122.427992425483 (37.781535924842, -122.427992425483) 7 9 11 29490 41
10772 264676 Private 9 Cassia leptophylla :: Gold Medallion Tree 152 668 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2020 12:00:00 AM 3 3x3   6003797.75621 2110080.31484 37.7740931268852 -122.430312496695 (37.7740931268852, -122.430312496695) 7 9 11 29492 10
41193 16883 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 300X Oak St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3   6005538.3415996 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733) 7 9 11 28852 10
47945 16888 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 300X Oak St 9 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3   6005538.3415996 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733) 7 9 11 28852 10
68363 16887 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 300X Oak St 8 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3   6005538.3415996 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733) 7 9 11 28852 10
69117 16884 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 300X Oak St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3   6005538.3415996 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733) 7 9 11 28852 10
106383 122643 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 300X Oak St 12 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3   6005538.3415996 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733) 7 9 11 28852 10
108163 104358 Private 9 Maytenus boaria :: Mayten 58 745X GOLDEN GATE AVE   Sidewalk: Curb side : Cutout Tree Private 2     10 3   6005986 2112447 37.7807151749226 -122.422911209833 (37.7807151749226, -122.422911209833) 7 9 11 28852 41
132854 25212 Private 9 Lophostemon confertus :: Brisbane Box 11 215X Fell St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6006420.22763 2110742.05634 37.7760583047566 -122.421287897592 (37.7760583047566, -122.421287897592) 7 9 11 28852 10
133992 16886 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 300X Oak St 7 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X4   6005538.3415996 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733) 7 9 11 28852 10
136268 122644 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 300X Oak St 13 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3   6005538.3415996 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733) 7 9 11 28852 10
144187 16882 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 300X Oak St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3   6005538.3415996 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733) 7 9 11 28852 10
172318 122641 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 300X Oak St 10 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3   6005538.3415996 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733) 7 9 11 28852 10
176217 122642 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 300X Oak St 11 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3   6005538.3415996 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733) 7 9 11 28852 10
184134 16885 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 300X Oak St 6 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3   6005538.3415996 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733) 7 9 11 28852 10
192405 238576 Private 9 Prunus x yedoensis :: Yoshino Cherry 77 127 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/02/2002 12:00:00 AM 3 Width 3ft Permit Number 782890 6004764 2108902 37.7709124438039 -122.42688615445 (37.7709124438039, -122.42688615445) 7 9 11 28852 10
95724 85741 Private 9 Platanus x hispanica :: Sycamore: London Plane 27 601X Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2007 12:00:00 AM 3 5x5 Permit Number 770115 6013161.811798 2114488.497614 37.7867229411628 -122.398229721423 (37.7867229411628, -122.398229721423) 6 2 9 28855 6
109240 115128 Private 9 Geijera parviflora :: Australian Willow 25 499X MAIN ST 6 Sidewalk: Curb side : Cutout Tree Private 2     7     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
128761 115129 Private 9 Geijera parviflora :: Australian Willow 25 499X MAIN ST 7 Sidewalk: Curb side : Cutout Tree Private 2     6     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
156773 85739 Private 9 Platanus x hispanica :: Sycamore: London Plane 27 601X Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2007 12:00:00 AM 3 5x5 Permit Number 770115 6013161.811798 2114488.497614 37.7867229411628 -122.398229721423 (37.7867229411628, -122.398229721423) 6 2 9 28855 6
171374 85740 Private 9 Platanus x hispanica :: Sycamore: London Plane 27 601X Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2007 12:00:00 AM 3 5x5 Permit Number 770115 6013161.811798 2114488.497614 37.7867229411628 -122.398229721423 (37.7867229411628, -122.398229721423) 6 2 9 28855 6
11239 260905 Private 9 Magnolia doltsopa :: Himalayan Magnolia 20 2211 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2019 12:00:00 AM 3 2X3   6007589.07412 2119959.01259 37.8014316343257 -122.417898047397 (37.8014316343257, -122.417898047397) 5 1 1 28858 32
12190 260906 Private 9 Magnolia doltsopa :: Himalayan Magnolia 20 2215 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2019 12:00:00 AM 3 2X3   6007586.25473 2119982.21322 37.8014951787433 -122.417909449339 (37.8014951787433, -122.417909449339) 5 1 1 28858 32
33729 109829 Private 9 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 629 TAYLOR ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM     Permit Number 775362 6009246.3 2115118.4 37.7882336239769 -122.41182103906 (37.7882336239769, -122.41182103906) 5 1 10 28852 21
20327 109501 Private 9 Ulmus americana :: American Elm 74 1400X on Filbert Montgomery St 1 Unaccepted Street : Yard Tree Private 2         see 279 Filbert St. Same tree; shared responsibility 6011485.9 2120124.8 37.8021053817179 -122.404424889694 (37.8021053817179, -122.404424889694) 3 1 10 308 23
273 117070 Private 9 Tree(s) :: 17 6 JOY ST 3 Front Yard : Yard Tree Private 2           6010444 2098901 37.7437714571602 -122.406533939617 (37.7437714571602, -122.406533939617) 2 7 7 28859 2
893 226590 Private 9 Eriobotrya deflexa :: Bronze Loquat 8 837 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 Port 08/14/2019 12:00:00 AM 3 3x3 Permit Number 784594 6001099.54842 2099653.23365 37.7453097044788 -122.438898660558 (37.7453097044788, -122.438898660558) 2 4 5 63 22
3984 243570 Private 9 Eriobotrya deflexa :: Bronze Loquat 8 837 Duncan St 2 Sidewalk: Curb side : Cutout Tree Private 2 Port   3 3x3 Permit Number 784594 6001117.2647 2099653.19311 37.7453106011164 -122.438837397829 (37.7453106011164, -122.438837397829) 2 4 5 63 22
4884 260462 Private 9 Pinus radiata :: Monterey Pine 15 119 Moffitt St 1 Back Yard : Yard Tree Private 2       3x3   6002736 2096650 37.7371564911538 -122.433025558613 (37.7371564911538, -122.433025558613) 2 7 5 63 7
4985 260550 Private 9 Private shrub :: Private Shrub 284 155 Graystone Ter 1 Sidewalk: Property side : Yard Landscaping Private 2       3x3   5999080 2104142 37.7575196509651 -122.446204727568 (37.7575196509651, -122.446204727568) 2 5 5 28862 3
33896 104968 Private 9 Pinus halepensis :: Allepo Pine 330 495 COLLINGWOOD ST 1 Front Yard : Yard Tree Private 2     15   Permit Number 770776 6002186.6 2103026 37.7546323087418 -122.435381040855 (37.7546323087418, -122.435381040855) 2 4 5 28862 22
34779 104448 Private 9 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2490X Folsom St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
44862 114642 Private 9 Crataegus phaenopyrum :: Washington Hawthorn 102 30 MacEdonia St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2015 12:00:00 AM     Permit Number 773527 6010319.9 2099707.2 37.745978163197 -122.407019863158 (37.745978163197, -122.407019863158) 2 7 7 28859 2
53506 108816 Private 9 Pinus radiata :: Monterey Pine 15 348 Gold Mine Dr 1 Back Yard : Yard Tree Private 2     30     6001084 2097744 37.740066514789 -122.438815634293 (37.740066514789, -122.438815634293) 2 7 5 63 7
64208 71505 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 328 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774557 6006691.32680411 2104197.11487977 37.7581027211657 -122.419885554796 (37.7581027211657, -122.419885554796) 2 4 7 28859 19
68698 104451 Private 9 Acacia melanoxylon :: Blackwood Acacia 70 2490X Folsom St 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
69100 104567 Private 9 Tree(s) :: 17 8 JOY ST 2 Front Yard : Yard Tree Private 2     40     6010448 2098932 37.7438568002142 -122.406522292508 (37.7438568002142, -122.406522292508) 2 7 7 28859 2
80106 114666 Private 9 Podocarpus gracilor :: Fern Pine 51 382 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2015 12:00:00 AM     Permit Number 774512 6007233.6 2095963.6 37.7355258779344 -122.417426639907 (37.7355258779344, -122.417426639907) 2 7 7 28859 2
83952 109126 Private 9 Schinus molle :: California Pepper 91 890x CASTRO ST 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6002411 2103002 37.7545791519678 -122.434603290485 (37.7545791519678, -122.434603290485) 2 4 5 28862 22
86075 100243 Private 9 Tree(s) :: 17 1326-1332 Shotwell St   unknown : Yard Tree Private 2           6008043 2100485 37.7479861507453 -122.414948142067 (37.7479861507453, -122.414948142067) 2 7 7 28859 2
91676 104449 Private 9 Acacia melanoxylon :: Blackwood Acacia 70 2490X Folsom St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
97720 104310 Private 9 Brachychiton populneus :: Bottle Tree 348 3747 23RD ST 3 Sidewalk: Curb side : Cutout Tree Private 2     13 5x5   6004798 2102451 37.7532014528284 -122.426309178314 (37.7532014528284, -122.426309178314) 2 4 5 28862 22
102300 113801 Private 9 Ulmus parvifolia :: Chinese Elm 31 806 SHOTWELL ST 3 Front Yard : Yard Tree Private 2           6007931 2103220 37.755489548438 -122.415529041662 (37.755489548438, -122.415529041662) 2 4 7 28859 19
107120 121090 Private 9 Pinus radiata :: Monterey Pine 15 1X Grand View Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
108854 104446 Private 9 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2490X Folsom St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
110382 108170 Private 9 Ginkgo biloba :: Maidenhair Tree 22 1645 ALABAMA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   02/03/2015 12:00:00 AM 3 3x3 Permit Number 774689 6009348.4 2099893.7 37.7464358384441 -122.410392359276 (37.7464358384441, -122.410392359276) 2 7 7 28859 2
112431 104768 Private 9 Ulmus parvifolia :: Chinese Elm 31 912 CASTRO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6002431.1 2102873.8 37.7542282864134 -122.434524613527 (37.7542282864134, -122.434524613527) 2 4 5 28862 22
120017 105072 Private 9 Metrosideros excelsa :: New Zealand Xmas Tree 16 88X PROSPECT AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     12 5x6   6007074 2099135 37.7442248567037 -122.418203213837 (37.7442248567037, -122.418203213837) 2 7 7 28859 2
122325 104309 Private 9 Myoporum laetum :: Myoporum 62 3747 23RD ST 2 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6004798 2102451 37.7532014528284 -122.426309178314 (37.7532014528284, -122.426309178314) 2 4 5 28862 22
156160 108314 Private 9 Corymbia ficifolia :: Red Flowering Gum 28 2501X DIAMOND ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002141 2097265 37.7388113707969 -122.435126715418 (37.7388113707969, -122.435126715418) 2 7 5 63 7
165242 104317 Private 9 Pyrus calleryana :: Ornamental Pear 44 13011305 SANCHEZ ST 2 Sidewalk: Property side : Cutout Tree Private 2     12 3x3   6003956 2100665 37.7482498839608 -122.429093651106 (37.7482498839608, -122.429093651106) 2 4 5 63 22
168048 122898 Private 9 Podocarpus gracilor :: Fern Pine 51 198X San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6006160 2102149 37.7524491239798 -122.421577653162 (37.7524491239798, -122.421577653162) 2 4 5 28859 19
180187 112262 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 1 Holly Park Cir 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x15   6006308.21143459 2096885.36921844 37.7380047408881 -122.420691480393 (37.7380047408881, -122.420691480393) 2 7 7 28859 2
181524 121089 Private 9 Eucalyptus globulus :: Blue Gum 56 1X Grand View Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
181589 73314 Private 9 Photinia fraseri :: Photinia: Chinese photinia 166 1142 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/2014 12:00:00 AM 3 3x3   6009184.98526399 2102501.75487234 37.7535878144828 -122.411141625253 (37.7535878144828, -122.411141625253) 2 4 7 28859 19
186484 109125 Private 9 Schinus molle :: California Pepper 91 890x CASTRO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002411 2103002 37.7545791519678 -122.434603290485 (37.7545791519678, -122.434603290485) 2 4 5 28862 22
188939 104962 Private 9 Jacaranda mimosifolia :: Jacaranda 50 1474X SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3 74 Aztec St. 6008023 2099506 37.7452969115591 -122.414948020341 (37.7452969115591, -122.414948020341) 2 7 7 28859 2
190102 104109 Private 9 Maytenus boaria :: Mayten 58 342-346 MOULTRIE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x6   6007700 2097518 37.7398201496863 -122.415924151926 (37.7398201496863, -122.415924151926) 2 7 7 28859 2
193423 108885 Private 9 Cupaniopsis anacardioides :: Carrotwood 195 707 NOE ST 5 Back Yard : Yard Tree Private 2       3x3   6003152.4 2104071.5 37.7575578048507 -122.432115704961 (37.7575578048507, -122.432115704961) 2 4 5 28862 3
8510 259163 Private 9 Shrub :: Shrub 66 1 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
9208 259164 Private 9 Shrub :: Shrub 66 1 Corbett Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
10003 264730 Private 9 Magnolia grandiflora :: Southern Magnolia 19 748 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/23/2020 12:00:00 AM 3     6002983.4557 2109619.25261 37.7727810060219 -122.433096352422 (37.7727810060219, -122.433096352422) 15 5 11 29492 9
10609 262014 Private 9 Magnolia grandiflora :: Southern Magnolia 19 1591 Page St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2020 12:00:00 AM 3 3x3   5998968.26858 2109018.36861 37.7709025542262 -122.446942035054 (37.7709025542262, -122.446942035054) 15 5 11 29492 9
12794 262012 Private 9 Magnolia grandiflora :: Southern Magnolia 19 1591 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2020 12:00:00 AM 3 3x3   5998968.26858 2109018.36861 37.7709025542262 -122.446942035054 (37.7709025542262, -122.446942035054) 15 5 11 29492 9
12902 262013 Private 9 Magnolia grandiflora :: Southern Magnolia 19 1591 Page St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2020 12:00:00 AM 3 3x3   5998968.26858 2109018.36861 37.7709025542262 -122.446942035054 (37.7709025542262, -122.446942035054) 15 5 11 29492 9
16189 104502 Private 9 Pinus radiata :: Monterey Pine 15 30X SATURN ST 1 Median : Yard Tree DPW 1     14     6000456 2106003 37.7627079858093 -122.44157952537 (37.7627079858093, -122.44157952537) 15 5 5 28862 3
16349 259165 Private 9 Shrub :: Shrub 66 1 Corbett Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
17012 262011 Private 9 Magnolia grandiflora :: Southern Magnolia 19 1591 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2020 12:00:00 AM 3 3x3   5998968.26858 2109018.36861 37.7709025542262 -122.446942035054 (37.7709025542262, -122.446942035054) 15 5 11 29492 9
35396 104626 Private 9 Platanus x hispanica :: Sycamore: London Plane 27 49 BRODERICK ST 3 Sidewalk: Curb side : Cutout Tree Private 2     18 6X5   6001285 2108936 37.7708084746611 -122.438922516011 (37.7708084746611, -122.438922516011) 15 5 11 29492 9
57138 104401 Private 9 Ulmus parvifolia :: Chinese Elm 31 727 Ashbury St   Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5999017 2108166 37.768564950056 -122.44671213341 (37.768564950056, -122.44671213341) 15 5 11 29492 9
88394 39627 Private 9 Platanus x hispanica :: Sycamore: London Plane 27 199X Carmel St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM 6   Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.450318782133 (37.7607233191374, -122.450318782133) 15 5 11 29492 12
96093 39626 Private 9 Platanus x hispanica :: Sycamore: London Plane 27 1550 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.450318782133 (37.7607233191374, -122.450318782133) 15 5 11 29492 12
108521 110587 Private 9 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 151 EDGEWOOD AVE 1 Front Yard : Yard Tree Private 2           5996558 2106132 37.7628393335165 -122.45507056335 (37.7628393335165, -122.45507056335) 15 5 11 29492 12

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