215 rows where qLegalStatus_id = 9 sorted by XCoord

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)
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
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
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
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
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
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
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
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
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
18526 250107 Private 9 Tree(s) :: 17 1688 Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6005911.45005 2115583.38163 37.7893226981327 -122.423392144226 (37.7893226981327, -122.423392144226) 13 9 1 28858 41
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
165045 114647 Private 9 Eriobotrya deflexa :: Bronze Loquat 8 331 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2015 12:00:00 AM     Permit Number 774946 6008851.6 2097283.6 37.7392412152063 -122.41192582952 (37.7392412152063, -122.41192582952) 10 7 7 28859 2
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
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
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
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
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
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
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
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
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
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
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
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
15228 261687 Private 9 Tree(s) :: 17 2067 Bancroft Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 02/20/2020 12:00:00 AM 3 4x4 Permit Number 782291 6011786.16554 2094038.32843 37.730494584078 -122.401551330673 (37.730494584078, -122.401551330673) 10 3 8 58 1
13426 260872 Private 9 Tree(s) :: 17 1736 Fitzgerald Ave 1 Sidewalk: Property side : Cutout Tree Private 2     3 3x3   6011805.50809 2092676.7551 37.7267570649137 -122.401388810186 (37.7267570649137, -122.401388810186) 10 3 8 58 1
142770 150735 Private 9 Cordyline australis :: Dracena Palm 64 783 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/31/2019 12:00:00 AM 3 3x3 Permit Number 778950 6012760.80751 2103885.27159 37.7575865350131 -122.398872659244 (37.7575865350131, -122.398872659244) 10 3 8 28856 29
10049 261052 Private 9 Ginkgo biloba :: Maidenhair Tree 22 100 Hooper St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013012.2905 2108046.92839 37.769027533769 -122.398294909078 (37.769027533769, -122.398294909078) 14 3 8 28856 20
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
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
8824 261056 Private 9 Afrocarpus gracilior :: Fern Pine 89 1952 Quesada Ave 1 Front Yard : Cutout Tree Private 2 DPW 11/20/2019 12:00:00 AM 3 3x3 Permit Number 780727 6013369.93114 2096051.4395 37.7361104181421 -122.396217020065 (37.7361104181421, -122.396217020065) 10 3 8 58 1
6336 261055 Private 9 Afrocarpus gracilior :: Fern Pine 89 1948 Quesada Ave 1 Front Yard : Cutout Tree Private 2 DPW 11/20/2019 12:00:00 AM 3 3x3 Permit Number 780729 6013389.35902 2096036.97619 37.7360717858924 -122.396148836191 (37.7360717858924, -122.396148836191) 10 3 8 58 1
11563 259753 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 1229 Connecticut St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6013525 2101361 37.7506979810533 -122.396052856578 (37.7506979810533, -122.396052856578) 10 3 8 28856 1
60173 80520 Private 9 Pyrus spp :: Pear Tree 281 2499X Mendell St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2002 12:00:00 AM 2     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
64184 80593 Private 9 Alnus rhombifolia :: White Alder 327 1780 Bancroft Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2002 12:00:00 AM 7     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
92274 80514 Private 9 Pyrus spp :: Pear Tree 281 1769X Armstrong Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
108336 80517 Private 9 Pyrus spp :: Pear Tree 281 1769X Armstrong Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2002 12:00:00 AM 3     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
133648 80515 Private 9 Pyrus spp :: Pear Tree 281 1769X Armstrong Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
141800 80510 Private 9 Alnus rhombifolia :: White Alder 327 1740 Bancroft Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2007 12:00:00 AM 9   Permit Number 49651 6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
143868 80518 Private 9 Pyrus spp :: Pear Tree 281 1769X Armstrong Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2002 12:00:00 AM 5     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
164704 80516 Private 9 Pyrus spp :: Pear Tree 281 1769X Armstrong Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
169586 80512 Private 9 Alnus rhombifolia :: White Alder 327 1740 Bancroft Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2002 12:00:00 AM 9     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
23936 22386 Private 9 Pyrus spp :: Pear Tree 281 1769X Armstrong Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6014045.0718623 2092725.5085003 37.7270156330804 -122.393650054041 (37.7270156330804, -122.393650054041) 10 3 8 58 1
94173 22382 Private 9 Pyrus spp :: Pear Tree 281 2499X Mendell St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM 3 3X3   6014045.0718623 2092725.5085003 37.7270156330804 -122.393650054041 (37.7270156330804, -122.393650054041) 10 3 8 58 1
154962 22381 Private 9 Alnus rhombifolia :: White Alder 327 1780 Bancroft Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3X3   6014045.0718623 2092725.5085003 37.7270156330804 -122.393650054041 (37.7270156330804, -122.393650054041) 10 3 8 58 1
2295 193115 Private 9 Tree(s) :: 17 1791 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 4x3 Permit Number 782693 6014511.3912 2096886.32335 37.7384662854853 -122.392328872775 (37.7384662854853, -122.392328872775) 10 3 8 58 1
17564 38555 Private 9 Tree(s) :: 17 1791 La Salle Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 3 4x3 Permit Number 782693 6014548.4967 2096859.88077 37.7383957399564 -122.392198730091 (37.7383957399564, -122.392198730091) 10 3 8 58 1
4984 154060 Private 9 Tree(s) :: 17 1796 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 4x3 Permit Number 782693 6014554.77098 2096926.88452 37.7385800668269 -122.392181721216 (37.7385800668269, -122.392181721216) 10 3 8 58 1
10549 38556 Private 9 Tree(s) :: 17 1791 La Salle Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 3 4x3 Permit Number 782693 6014562.13286 2096849.44481 37.7383678420956 -122.39215085288 (37.7383678420956, -122.39215085288) 10 3 8 58 1
16385 154062 Private 9 Tree(s) :: 17 1791 La Salle Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 4x3 Permit Number 782693 6014575.41577 2096839.56035 37.7383414389075 -122.392104235638 (37.7383414389075, -122.392104235638) 10 3 8 58 1
12863 154063 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1781 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 4x3 Permit Number 782693 6014599.10763 2096821.84485 37.7382941111836 -122.392021081628 (37.7382941111836, -122.392021081628) 10 3 8 58 1
91085 111308 Private 9 Pinus radiata :: Monterey Pine 15 780x JAMESTOWN AVE 1 Sidewalk: Property side : Yard Tree Private 2       6x90   6015099 2088640 37.7158561393861 -122.389721379672 (37.7158561393861, -122.389721379672) 10 3 8 58 1
137357 117353 Private 9 Pittosporum crassifolium :: Karo Tree 95 101X China Basin St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 772935 6015309.46376 2108739.72137 37.7710574836343 -122.390397474374 (37.7710574836343, -122.390397474374) 14 3 9 310 20
8842 150020 Private 9 Tree(s) :: 17 777 Tennessee St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2019 12:00:00 AM 0 9x5 Permit Number 776949 6015489.50926 2105477.62507 37.7621104630605 -122.389546827243 (37.7621104630605, -122.389546827243) 10 3 8 28856 29
675 150019 Private 9 Tree(s) :: 17 777 Tennessee St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2019 12:00:00 AM 0 9x5 Permit Number 776949 6015489.62882 2105456.11878 37.7620514180509 -122.389544911688 (37.7620514180509, -122.389544911688) 10 3 8 28856 29
14649 150018 Private 9 Tree(s) :: 17 777 Tennessee St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2019 12:00:00 AM 0 9x5 Permit Number 776949 6015492.47093 2105432.35195 37.7619863170408 -122.389533421936 (37.7619863170408, -122.389533421936) 10 3 8 28856 29
15916 150017 Private 9 Tree(s) :: 17 777 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2019 12:00:00 AM 0 9x5 Permit Number 776949 6015494.08881 2105409.25245 37.7619229804945 -122.389526212978 (37.7619229804945, -122.389526212978) 10 3 8 28856 29
3212 150016 Private 9 Tree(s) :: 17 777 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2019 12:00:00 AM 0 9x5 Permit Number 776949 6015494.18586 2105386.64383 37.7618609074738 -122.389524298311 (37.7618609074738, -122.389524298311) 10 3 8 28856 29
123246 22155 Private 9 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 1570X FAIRFAX AVE 7 Sidewalk: Curb side : Cutout Tree Private 2     1 3X3   6015579 2098247 37.7422616499572 -122.388732527256 (37.7422616499572, -122.388732527256) 10 3 8 58 1
51620 26198 Private 9 Lophostemon confertus :: Brisbane Box 11 3830 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 3x4   6015747.5106038 2098323.3315623 37.742480578689 -122.388155190044 (37.742480578689, -122.388155190044) 10 3 8 58 1
4192 264915 Private 9 Pistacia chinensis :: Chinese Pistache 32 1461 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/09/2020 12:00:00 AM 3 3x3 Permit Number 784397 6015819.34366 2093828.22518 37.7301419060949 -122.387593270969 (37.7301419060949, -122.387593270969) 10 3 8 58 1
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
4077 102546 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 409 Illinois St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2016 12:00:00 AM 3 5x5   6015961.34604 2107137.76144 37.7666949900978 -122.388030764508 (37.7666949900978, -122.388030764508) 14 3 9 310 20
6900 102545 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 409 Illinois St 6 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2016 12:00:00 AM 3 5x5   6015962.79104 2107111.95809 37.7666242197475 -122.38802396564 (37.7666242197475, -122.38802396564) 14 3 9 310 20
5864 189275 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 409 Illinois St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015964.59668 2107087.77889 37.7665579289401 -122.388016032733 (37.7665579289401, -122.388016032733) 14 3 9 310 20
18169 189274 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 409 Illinois St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015965.43281 2107064.27168 37.7664934295578 -122.388011500129 (37.7664934295578, -122.388011500129) 14 3 9 310 20
13982 189273 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 409 Illinois St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015966.51086 2107036.5181 37.7664172839651 -122.388005834417 (37.7664172839651, -122.388005834417) 14 3 9 310 20
9264 188788 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 409 Illinois St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015967.32751 2107012.0323 37.7663500965054 -122.388001300914 (37.7663500965054, -122.388001300914) 14 3 9 310 20
14181 188787 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 409 Illinois St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015968.04519 2106982.6549 37.7662694722874 -122.387996768362 (37.7662694722874, -122.387996768362) 14 3 9 310 20
7177 74026 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 499 Illinois St 9 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2016 12:00:00 AM 3 5x5   6015970.5058 2106958.46215 37.7662031805546 -122.387986569137 (37.7662031805546, -122.387986569137) 14 3 9 310 20
5551 74240 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 499 Illinois St 8 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2016 12:00:00 AM 3 5x5   6015971.85212 2106927.76687 37.7661189725478 -122.387979770277 (37.7661189725478, -122.387979770277) 14 3 9 310 20
17556 75105 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 499 Illinois St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2016 12:00:00 AM 3 5x5   6015973.99843 2106904.23323 37.7660544731729 -122.387970704195 (37.7660544731729, -122.387970704195) 14 3 9 310 20

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