trees

163,064 rows where qCaretaker_id = 2 sorted by qAddress descending

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress ▲ SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
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
83645 242323 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 99X San Jose Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6006214.26543 2102686.33739 37.7539275884093 -122.421428150793 (37.7539275884093, -122.421428150793) 2 4 5 28859 19
121510 242324 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 99X San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006214.10132 2102706.48549 37.7539829011917 -122.421430149091 (37.7539829011917, -122.421430149091) 2 4 5 28859 19
175437 242325 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 99X San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006215.7234 2102729.1867 37.7540453249341 -122.421426151609 (37.7540453249341, -122.421426151609) 2 4 5 28859 19
76960 18670 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 99X Richardson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   5999509.53732 2119357.26289 37.7993213750517 -122.445813455145 (37.7993213750517, -122.445813455145) 13 9 1 57 17
144870 24434 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 99X Peter Yorke Way 2 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2002 12:00:00 AM 3 3X3   6005916.1529 2114537.1027597 37.7864501414891 -122.423301466307 (37.7864501414891, -122.423301466307) 13 9 1 28858 41
76518 52391 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 99X Park St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/2005 12:00:00 AM 5 3x3 Permit Number 48514 6005316.06148505 2096495.16732584 37.7368773658256 -122.424094095206 (37.7368773658256, -122.424094095206) 2 7 7 28859 2
96297 52390 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 99X Park St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/2005 12:00:00 AM 5 3x3 Permit Number 48514 6005316.06148505 2096495.16732584 37.7368773658256 -122.424094095206 (37.7368773658256, -122.424094095206) 2 7 7 28859 2
156134 52392 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 99X Park St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/2005 12:00:00 AM 5 3x3 Permit Number 48514 6005316.06148505 2096495.16732584 37.7368773658256 -122.424094095206 (37.7368773658256, -122.424094095206) 2 7 7 28859 2
190179 52389 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 99X Park St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/2005 12:00:00 AM 5 3x3 Permit Number 48514 6005316.06148505 2096495.16732584 37.7368773658256 -122.424094095206 (37.7368773658256, -122.424094095206) 2 7 7 28859 2
172870 117258 Undocumented 4 Tree(s) :: 17 99X PROSPER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       2x3   6003339 2106236 37.7635115803019 -122.431624896471 (37.7635115803019, -122.431624896471) 15 4 5 28862 3
2105 227358 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 99X Ogden Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6007594.39314 2096161.75328 37.7360902568635 -122.416193267317 (37.7360902568635, -122.416193267317) 2 7 7 28859 2
11598 227356 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 99X Ogden Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6007559.31004 2096165.80664 37.7360994137559 -122.416314851151 (37.7360994137559, -122.416314851151) 2 7 7 28859 2
15724 227357 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 99X Ogden Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6007581.53732 2096160.90491 37.736087204549 -122.416237655152 (37.736087204549, -122.416237655152) 2 7 7 28859 2
20359 111160 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 99X Magnolia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6003321.77346 2119803.50555 37.8007635719416 -122.432653690929 (37.8007635719416, -122.432653690929) 13 9 1 57 17
35594 111164 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 99X Magnolia St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6003392.25539 2119813.00098 37.8007936407819 -122.432410472862 (37.8007936407819, -122.432410472862) 13 9 1 57 17
107681 111163 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 99X Magnolia St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6003374.28365 2119810.99129 37.8007871036097 -122.432472518919 (37.8007871036097, -122.432472518919) 13 9 1 57 17
117311 111161 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 99X Magnolia St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6003338.31122 2119805.54449 37.8007701082019 -122.432596609162 (37.8007701082019, -122.432596609162) 13 9 1 57 17
126173 111165 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 99X Magnolia St 6 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6003411.20248 2119815.94235 37.8008027913768 -122.432345118256 (37.8008027913768, -122.432345118256) 13 9 1 57 17
137511 111162 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 99X Magnolia St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6003355.09781 2119808.05454 37.8007779520905 -122.4325387 (37.8007779520905, -122.4325387) 13 9 1 57 17
99985 101898 Undocumented 4 Cedrus deodara :: Deodar Cedar 109 99X MacOndray Ln 1 Sidewalk: Property side : Yard Tree Private 2           6008233.5 2119097.7 37.7991029311983 -122.415607021356 (37.7991029311983, -122.415607021356) 5 1 10 308 32
129291 101899 Undocumented 4 Cedrus deodara :: Deodar Cedar 109 99X MacOndray Ln 2 Sidewalk: Property side : Yard Tree Private 2           6008233.5 2119097.7 37.7991029311983 -122.415607021356 (37.7991029311983, -122.415607021356) 5 1 10 308 32
177 253253 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 99X Lopez Ave 4 Front Yard : Yard Tree Private 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
6296 260461 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 4 Front Yard : Yard Tree Private 2       10x10 Permit Number 784513 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
19246 253252 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 3 Front Yard : Yard Tree Private 2       10x10 Permit Number 784513 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
66926 253251 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 2 Front Yard : Yard Tree Private 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
94784 253250 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 99X Lopez Ave 1 Front Yard : Yard Tree Private 2   01/09/2018 12:00:00 AM 3 10x10 Permit Number 780226 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
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
40425 115540 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x5 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
75364 115539 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 4 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
164265 115538 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 3 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
185440 115536 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 1 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
96237 121608 Undocumented 4 Leptospermum scoparium :: New Zealand Tea Tree 157 99X Lamartine St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002710 2094292 37.7306804869695 -122.432947039569 (37.7306804869695, -122.432947039569) 9 7 5 28861 25
153155 121606 Undocumented 4 Leptospermum scoparium :: New Zealand Tea Tree 157 99X Lamartine St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002710 2094292 37.7306804869695 -122.432947039569 (37.7306804869695, -122.432947039569) 9 7 5 28861 25
186126 121607 Undocumented 4 Leptospermum scoparium :: New Zealand Tea Tree 157 99X Lamartine St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002710 2094292 37.7306804869695 -122.432947039569 (37.7306804869695, -122.432947039569) 9 7 5 28861 25
59968 47489 Permitted Site 7 Olea europaea :: Olive Tree 9 99X LYELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM 10 3x3 Permit Number 45384 6003192 2094433 37.7310949685834 -122.431290753374 (37.7310949685834, -122.431290753374) 9 7 5 28861 25
72072 47490 Permitted Site 7 Yucca gloriosa :: Spanish Dagger 126 99X LYELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM 2 3x3 Permit Number 45384 6003192 2094433 37.7310949685834 -122.431290753374 (37.7310949685834, -122.431290753374) 9 7 5 28861 25
96582 47488 Permitted Site 7 Olea europaea :: Olive Tree 9 99X LYELL ST 3 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM   3x3 Permit Number 45384 6003192 2094433 37.7310949685834 -122.431290753374 (37.7310949685834, -122.431290753374) 9 7 5 28861 25
166623 32752 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 99X LOBOS ST 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM     Permit Number 37130 5995934 2088667 37.7148489062392 -122.455966075921 (37.7148489062392, -122.455966075921) 9 8 6 28861 24
61746 103815 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 99X Hemlock St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006959.84507 2114826.77891 37.7873043685578 -122.419711106691 (37.7873043685578, -122.419711106691) 13 9 10 28858 21
188159 103814 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 99X Hemlock St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006931.25215 2114822.01169 37.7872896682178 -122.41980969397 (37.7872896682178, -122.41980969397) 13 9 10 28858 21
134437 106104 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 99X HARTFORD ST 4 Sidewalk: Curb side : Cutout Tree Private 2     14 4x3   6002644 2105609 37.7617505722061 -122.433983855891 (37.7617505722061, -122.433983855891) 15 4 5 28862 3
92555 9315 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 99X Gold Mine Dr 3 Sidewalk: Curb side : Cutout Tree Private 2     40 2X2   6001391.6487444 2098856.3848919 37.7431383606087 -122.437831565564 (37.7431383606087, -122.437831565564) 2 7 5 63 7
125252 9316 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 99X Gold Mine Dr 4 Sidewalk: Curb side : Cutout Tree Private 2     8 2X2   6001391.6487444 2098856.3848919 37.7431383606087 -122.437831565564 (37.7431383606087, -122.437831565564) 2 7 5 63 7
2335 262272 Undocumented 4 Tree(s) :: 17 99X Glendale St   Unaccepted Street : Yard Tree Private 2       3x3   5999984 2103563 37.7559814441149 -122.443036761048 (37.7559814441149, -122.443036761048) 2 5 5 28862 38
6991 112084 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 99X Fremont St 1 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
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
6364 264920 Significant Tree 6 Tree(s) :: 17 99X Everglade Dr 2 Sidewalk: Property side : Cutout Tree Private 2   11/10/2020 12:00:00 AM 3 6x10 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
7796 264921 Significant Tree 6 Tree(s) :: 17 99X Everglade Dr 3 Sidewalk: Property side : Cutout Tree Private 2   11/10/2020 12:00:00 AM 3 6x10 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
101827 173631 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 99X Everglade Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5986361 2095495 37.7330427310611 -122.489555709533 (37.7330427310611, -122.489555709533) 1 8 4 64 35
51708 173779 Significant Tree 6 Ficus macrophylla :: Morton Bay Fig 322 99X Cleveland St 2 Side Yard : Yard Tree Private 2       3x6   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
77590 173780 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 99X Cleveland St 3 Side Yard : Yard Tree Private 2       3x6   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
145519 173778 Significant Tree 6 Tree(s) :: 17 99X Cleveland St 1 Side Yard : Cutout Tree Private 2       3x3   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
81883 106311 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 5 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
181784 106310 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 4 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
21772 3914 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 99X Castro St 6 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2010 12:00:00 AM 3 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
40390 3920 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X Castro St 12 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
43569 3923 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X Castro St 15 Sidewalk: Curb side : Cutout Tree Private 2   12/24/2011 12:00:00 AM 3 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
55615 3918 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X Castro St 10 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
69340 3912 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 99X Castro St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2010 12:00:00 AM 3 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
77146 3910 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 99X Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2010 12:00:00 AM 3 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
78619 3922 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X Castro St 14 Sidewalk: Curb side : Cutout Tree Private 2   01/01/2001 12:00:00 AM 12 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
81486 3924 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X Castro St 16 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
88689 82306 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 99X Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2010 12:00:00 AM 3 3x3   6002236.81411993 2107669.61965331 37.7673854141811 -122.435539566136 (37.7673854141811, -122.435539566136) 15 5 5 28862 3
89700 3927 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X Castro St 20 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
101939 3917 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X Castro St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
108333 3911 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 99X Castro St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2010 12:00:00 AM 3 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
111951 3913 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X Castro St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
126241 27764 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X Castro St 17 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
139918 3926 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X Castro St 19 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
147445 3916 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X Castro St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
158946 3919 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X Castro St 11 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
172617 3928 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X Castro St 21 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
176655 3915 Permitted Site 7 Magnolia sargentiana 'Robusta' :: Robusta Magnolia 514 99X Castro St 7 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2010 12:00:00 AM 3 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
187464 3921 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X Castro St 13 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002235.815722 2107669.5624773 37.7673852004846 -122.435543015361 (37.7673852004846, -122.435543015361) 15 5 5 28862 3
35264 113587 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 99X Augusta St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6011311.67558 2095454.8306 37.7343575141735 -122.403291328826 (37.7343575141735, -122.403291328826) 10 3 8 58 1
36150 113586 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 99X AUGUSTA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2015 12:00:00 AM   3x3   6011271 2095434 37.7342980459086 -122.403430493306 (37.7342980459086, -122.403430493306) 10 3 8 58 1
5959 36677 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 99X ALBION ST 5 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1998 12:00:00 AM 16 3x3 Permit Number 39481 6005790 2106965 37.7656518628938 -122.42319948022 (37.7656518628938, -122.42319948022) 8 4 5 28853 19
17724 36678 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 99X ALBION ST 2 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1998 12:00:00 AM 16 3x3 Permit Number 39481 6005790 2106965 37.7656518628938 -122.42319948022 (37.7656518628938, -122.42319948022) 8 4 5 28853 19
64745 36679 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 99X ALBION ST 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1998 12:00:00 AM 14 3x3 Permit Number 39481 6005790 2106965 37.7656518628938 -122.42319948022 (37.7656518628938, -122.42319948022) 8 4 5 28853 19
100199 36676 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 99X ALBION ST 4 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1998 12:00:00 AM 14 3x3 Permit Number 39481 6005790 2106965 37.7656518628938 -122.42319948022 (37.7656518628938, -122.42319948022) 8 4 5 28853 19
174066 36680 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 99X ALBION ST 3 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1998 12:00:00 AM 16 3x3 Permit Number 39481 6005790 2106965 37.7656518628938 -122.42319948022 (37.7656518628938, -122.42319948022) 8 4 5 28853 19
104787 41729 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 99X 14th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42172 6008031.27943269 2107943.20653569 37.7684640195804 -122.415516624702 (37.7684640195804, -122.415516624702) 8 4 7 28853 19
181210 41725 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 99X 14th St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42172 6008031.27943269 2107943.20653569 37.7684640195804 -122.415516624702 (37.7684640195804, -122.415516624702) 8 4 7 28853 19
185234 41728 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 99X 14th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42172 6008031.27943269 2107943.20653569 37.7684640195804 -122.415516624702 (37.7684640195804, -122.415516624702) 8 4 7 28853 19
191578 41726 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 99X 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42172 6008031.27943269 2107943.20653569 37.7684640195804 -122.415516624702 (37.7684640195804, -122.415516624702) 8 4 7 28853 19
122142 95091 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X 08th St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/02/2013 12:00:00 AM 3 3x3 Permit Number 771124 6008785.98711 2111225.82851 37.777519721304 -122.413138294803 (37.777519721304, -122.413138294803) 8 2 9 28853 34
138911 95092 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99X 08th St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/11/2010 12:00:00 AM 3 3x3 Permit Number 771124 6008785.98711 2111225.82851 37.777519721304 -122.413138294803 (37.777519721304, -122.413138294803) 8 2 9 28853 34
14814 50011 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 99@ 20TH ST Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2003 12:00:00 AM     Permit Number 46742                    
22977 34457 Permitted Site 7 Arbutus unedo :: Strawberry Tree 106 999x UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM   3x3 Permit Number 38200 6008246 2119227 37.7994586593975 -122.415572926479 (37.7994586593975, -122.415572926479) 5 1 10 308 32
41044 34456 Permitted Site 7 Arbutus unedo :: Strawberry Tree 106 999x UNION ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38200 6008246 2119227 37.7994586593975 -122.415572926479 (37.7994586593975, -122.415572926479) 5 1 10 308 32
183393 113369 Undocumented 4 Acacia baileyana :: Bailey's Acacia 122 999x JARBOE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x9   6009304 2096928 37.7382901856605 -122.410336525414 (37.7382901856605, -122.410336525414) 10 7 7 28859 2
69625 102708 Undocumented 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 999X PHELPS ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2015 12:00:00 AM 3 3x3 Permit Number 773962 6014744 2097272 37.7395381878784 -122.391551574015 (37.7395381878784, -122.391551574015) 10 3 8 58 1
143371 102709 Undocumented 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 999X PHELPS ST 2 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2015 12:00:00 AM 3 3x3 Permit Number 773962 6014744 2097272 37.7395381878784 -122.391551574015 (37.7395381878784, -122.391551574015) 10 3 8 58 1
81713 109645 Undocumented 4 Acacia decurrens :: Acacia: Silver Wattle 111 999X PAGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001842 2109394 37.7720977038705 -122.437028639855 (37.7720977038705, -122.437028639855) 15 5 11 29492 9
136679 102437 Permitted Site 7 Washingtonia filifera :: California Fan Palm 176 999X Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010518 2112007 37.77976171638 -122.407201735558 (37.77976171638, -122.407201735558) 14 2 9 28853 34
179950 32943 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 999X Minnesota St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 8 3x3 Permit Number 37261 6015287.47006 2104039.63341 37.7581508424957 -122.390145145285 (37.7581508424957, -122.390145145285) 10 3 8 28856 29
189188 32942 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 999X Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 13   Permit Number 37261 6015289.11919 2103969.28048 37.7579577598656 -122.390134526983 (37.7579577598656, -122.390134526983) 10 3 8 28856 29
162587 20127 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 999X Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6003226.6736 2110648.3783 37.7756205244718 -122.432328548686 (37.7756205244718, -122.432328548686) 15 9 11 29492 10
66620 28855 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 999X Fulton St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6003293.83169 2111352.42992 37.7775574834057 -122.432146522449 (37.7775574834057, -122.432146522449) 15 9 11 29492 10

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