trees

163,064 rows where qCaretaker_id = 2 sorted by PermitNotes

✎ 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)
10 264794 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 31 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2020 12:00:00 AM 3 3x3   6011433 2091603 37.7237879639177 -122.40260109208 (37.7237879639177, -122.40260109208) 10 3 7 309 28
12 264792 Undocumented 4 Olea europaea :: Olive Tree 9 99 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2020 12:00:00 AM 3 3x3   6011432 2091645 37.7239032314516 -122.402607501044 (37.7239032314516, -122.402607501044) 10 3 7 309 28
14 162252 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 789 Girard St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2020 12:00:00 AM 3 Width 0ft   6011428.3902 2091205.22693 37.7226955033817 -122.402589068938 (37.7226955033817, -122.402589068938) 10 3 7 309 28
20 264793 Undocumented 4 Olea europaea :: Olive Tree 9 99 Dwight St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2020 12:00:00 AM 3 3x3   6011432 2091645 37.7239032314516 -122.402607501044 (37.7239032314516, -122.402607501044) 10 3 7 309 28
24 264941 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Portola Dr 12 Median : Cutout Tree Private 2       3x3   5999749 2101261 37.7496473113918 -122.443684097942 (37.7496473113918, -122.443684097942) 2 5 5 28862 38
29 264952 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 2 Front Yard : Yard Tree Private 2   11/13/2020 12:00:00 AM 3     6004818 2113712 37.7841225773231 -122.427042012496 (37.7841225773231, -122.427042012496) 13 9 11 28858 41
31 264951 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 1 Front Yard : Yard Tree Private 2   11/13/2020 12:00:00 AM 3     6004818 2113712 37.7841225773231 -122.427042012496 (37.7841225773231, -122.427042012496) 13 9 11 28858 41
34 262408 Property Tree 8 Pinus radiata :: Monterey Pine 15 66X Edgehill Way 1 Unaccepted Street : Yard Tree Private 2       3x3   5994840 2098758 37.7424934921887 -122.46047813267 (37.7424934921887, -122.46047813267) 1 8 4 59 40
35 16620 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 125 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/1999 12:00:00 AM 6 3X3   6002913 2107540 37.7670678918229 -122.433191472284 (37.7670678918229, -122.433191472284) 15 5 5 28862 3
37 264963 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 275 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2020 12:00:00 AM 3 3x3   6005706 2110306 37.7748207071365 -122.423727591769 (37.7748207071365, -122.423727591769) 7 9 11 28852 10
40 6039 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1822 Eddy St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6001574.3819 2112547.6661 37.7807416628926 -122.438180307395 (37.7807416628926, -122.438180307395) 15 5 11 29490 41
41 159866 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 20 Ruth St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2020 12:00:00 AM 3 4x6   6001590.27181 2091627.71254 37.7233013847479 -122.436627471279 (37.7233013847479, -122.436627471279) 9 7 6 28861 25
42 221891 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 180 Bartlett St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6006685.21207 2102724.39469 37.7540586268078 -122.419802203518 (37.7540586268078, -122.419802203518) 2 4 7 28859 19
43 264724 DPW Maintained 1 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 2901 Broadway 1 Front Yard : Yard Tree Private 2       3x3   5999656 2116990 37.7928298614365 -122.445136362104 (37.7928298614365, -122.445136362104) 13 6 1 29490 27
44 159867 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 20 Ruth St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2020 12:00:00 AM 3 4x6   6001543.73914 2091652.70256 37.7233673572035 -122.436790113668 (37.7233673572035, -122.436790113668) 9 7 6 28861 25
45 134298 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1948 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2020 12:00:00 AM 3 Width 4ft   6004784.56446 2117433.72769 37.7943396156388 -122.427422908337 (37.7943396156388, -122.427422908337) 13 9 1 28858 27
46 6035 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1826 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6001552.687 2112546.4084 37.7807369756783 -122.438255270265 (37.7807369756783, -122.438255270265) 15 5 11 29490 41
47 264965 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 951 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994993 2090257 37.7191606150529 -122.45933361899 (37.7191606150529, -122.45933361899) 9 8 6 28861 24
48 159865 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 20 Ruth St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2020 12:00:00 AM 3 4x6   6001621.37029 2091612.17517 37.7232604898693 -122.436518858358 (37.7232604898693, -122.436518858358) 9 7 6 28861 25
50 264964 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3641 California St 1 Sidewalk: Curb side : Cutout Tree Private 2       3X3   5996989 2114619 37.7861671437011 -122.454192924446 (37.7861671437011, -122.454192924446) 11 6 1 54 31
51 137691 DPW Maintained 1 Rhamnus alaternus :: Italian Buckthorn 29 2175 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2020 12:00:00 AM 3 Width 0ft   5999187.5809 2111472.1809 37.7776526229954 -122.44635998308 (37.7776526229954, -122.44635998308) 15 5 11 54 16
52 264970 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1026 Ingerson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014048 2089990 37.7195046364539 -122.393448574201 (37.7195046364539, -122.393448574201) 10 3 8 58 1
53 264969 Undocumented 4 Acacia stenophylla :: Shoestring Acacia 30 1099X Hollister Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     15x15   6014337 2089983 37.719501468928 -122.392449109694 (37.719501468928, -122.392449109694) 10 3 8 58 1
54 216739 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 11 Brighton Ave 1 Sidewalk: Curb side : Yard Tree Private 2   11/23/2020 12:00:00 AM 3 Width 3ft   5996185.57101 2089978.26988 37.7184637821573 -122.4551912491 (37.7184637821573, -122.4551912491) 9 8 6 28861 24
58 195132 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 825 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/2020 12:00:00 AM 3 Width 3ft   6015253.79115 2104691.52976 37.7599389420381 -122.390307168065 (37.7599389420381, -122.390307168065) 10 3 8 28856 29
59 195131 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 851 Minnesota St 7 Sidewalk: Curb side : Cutout Tree Private 2   11/25/2020 12:00:00 AM 3 Width 3ft   6015252.45033 2104672.28083 37.7598860142382 -122.390310460464 (37.7598860142382, -122.390310460464) 10 3 8 28856 29
60 264971 Private 9 Ulmus parvifolia :: Chinese Elm 31 150 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/2020 12:00:00 AM 3     5990555.23468 2114396.47455 37.7851851170506 -122.476435559205 (37.7851851170506, -122.476435559205) 11 6 2 54 26
62 264980 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 222 Winfield St 1 Front Yard : Yard Tree Private 2       3x3   6006740 2098205 37.7416524795013 -122.419292156581 (37.7416524795013, -122.419292156581) 2 7 7 28859 2
63 264975 Significant Tree 6 Pinus radiata :: Monterey Pine 15 445 Ortega St 1 Front Yard : Yard Tree Private 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
64 264974 Significant Tree 6 Persea americana :: Avocado 34 1868 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003954 2119422 37.7997518904289 -122.430438688757 (37.7997518904289, -122.430438688757) 13 9 1 57 17
66 132469 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3135 Pierce St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6001403 2119193 37.7989782820217 -122.43924964791 (37.7989782820217, -122.43924964791) 13 9 1 57 17
68 264976 Significant Tree 6 Pinus radiata :: Monterey Pine 15 445 Ortega St 2 Front Yard : Yard Tree Private 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
69 126274 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1240 Lombard St 1 Sidewalk: Property side : Yard Tree Private 2     24 Width 6ft   6006421.51674 2120105.21307 37.8017672864012 -122.421948716173 (37.8017672864012, -122.421948716173) 5 9 1 28858 32
71 227799 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1265 Stanyan St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2020 12:00:00 AM 17 6x6   5997473.24622 2105221.8097 37.760392645519 -122.451839397566 (37.760392645519, -122.451839397566) 15 5 11 29492 12
72 135801 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 16 Phoenix Ter 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 2ft   6008610.92916 2117913.61927 37.7958729471262 -122.414217164494 (37.7958729471262, -122.414217164494) 5 1 10 308 21
73 127010 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1931 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6003752.87677 2118634.51429 37.7975782631807 -122.431078412364 (37.7975782631807, -122.431078412364) 13 9 1 57 17
77 225344 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 207 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6004214.46195 2097518.65353 37.7396253677099 -122.42797572342 (37.7396253677099, -122.42797572342) 2 7 5 63 7
78 237365 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2463 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008244.71386 2104091.00553 37.7578987598438 -122.414505749733 (37.7578987598438, -122.414505749733) 2 4 7 28859 19
84 254457 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 1055X Duncan St 2 Side Yard : Yard Tree Private 2                              
86 239818 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 219 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007803 2098062 37.7413196437149 -122.415606526646 (37.7413196437149, -122.415606526646) 2 7 7 28859 2
94 260654 Permitted Site 7 :: 45 2590 Buchanan St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   10/03/2019 12:00:00 AM 3 3.5x3                      
95 261359 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 3 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007238 2095678 37.7347419306018 -122.417391193891 (37.7347419306018, -122.417391193891) 2 7 7 28859 2
96 137041 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1034 Sacramento St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2020 12:00:00 AM 3 Width 3ft   6009697.84819 2116804.05029 37.7928873337267 -122.410377820179 (37.7928873337267, -122.410377820179) 3 1 10 28857 21
97 261358 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2x Bache St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007175 2095707 37.7348180134015 -122.417611061749 (37.7348180134015, -122.417611061749) 2 7 7 28859 2
99 255073 Private 9 Tree(s) :: 17 173R Glenview Dr   Back Yard : Yard Tree Private 2                              
103 253831 DPW Maintained 1 :: 45 699X Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3                      
105 70839 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 939 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6010931.16123 2112337.60471 37.780692593337 -122.405795716794 (37.780692593337, -122.405795716794) 14 2 9 28853 34
111 97355 Permitted Site 7 Tree(s) :: 17   5 Unaccepted Street : Yard Tree Private 2                              
113 182915 DPW Maintained 1 :: 45 2711 47th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981812.2124 2096648.8938 37.7359443944789 -122.505367292654 (37.7359443944789, -122.505367292654) 1 8 3 29491 35
114 251458 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 651 Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/03/2017 12:00:00 AM 3 3x3                      
115 121173 Significant Tree 6 Tree(s) :: 17 950 Duncan St 2 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
116 113159 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 555 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005146 2111243 37.777361853017 -122.425731455878 (37.777361853017, -122.425731455878) 7 9 11 28852 10
117 108152 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
118 236256 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 151 Valencia St 1 : Tree Private 2     9 Width 4ft   6006073.15075 2108915.83898 37.7710243776945 -122.422358744984 (37.7710243776945, -122.422358744984) 8 2 9 28853 19
119 184195 DPW Maintained 1 :: 45 1459 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5984624.9154 2105245.6219 37.759713770345 -122.49627690204 (37.759713770345, -122.49627690204) 1 8 3 56 35
120 141225 DPW Maintained 1 :: 45 3 COMMONWEALTH AVE 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5996479.075 2114520.1031 37.7858663452689 -122.455949967769 (37.7858663452689, -122.455949967769) 11 6 1 54 31
123 221263 DPW Maintained 1 Betula spp :: Birch 55 1 Church St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 6ft   6004132.36771 2108477.00924 37.7697097883113 -122.429040680782 (37.7697097883113, -122.429040680782) 7 9 5 29492 10
125 92934 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 339 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10     5992211 2096907 37.737259523291 -122.46943364564 (37.737259523291, -122.46943364564) 1 8 4 59 40
126 173890 DPW Maintained 1 Maytenus boaria :: Mayten 58 2593 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989209 2097724 37.7393288482101 -122.479872589648 (37.7393288482101, -122.479872589648) 1 8 3 29491 35
128 110722 Undocumented 4 Callistemon viminalis :: Weeping Bottlebrush 60 1898X 10th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           5993137.43282 2102888.05903 37.753735486992 -122.466665198088 (37.753735486992, -122.466665198088) 1 8 4 56 12
131 109387 Undocumented 4 Myoporum laetum :: Myoporum 62 300X BAKER ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000704 2110147 37.7741005029649 -122.441019094263 (37.7741005029649, -122.441019094263) 15 5 11 29492 16
132 182257 DPW Maintained 1 :: 45 1439 35th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985240.365 2105399.9729 37.7601736080068 -122.494159774452 (37.7601736080068, -122.494159774452) 1 8 3 56 35
135 99586 Permitted Site 7 Tree(s) :: 17 2299 Market St 4 Sidewalk: Curb side : Cutout Tree Private 2           6002978.6 2106459.9 37.7641059209125 -122.432887400675 (37.7641059209125, -122.432887400675) 15 4 5 28862 3
138 203559 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 145 Lakeview Ave 1 : Tree Private 2     1 Width 3ft   5997146.51683 2089373.33367 37.7168578537955 -122.45182605794 (37.7168578537955, -122.45182605794) 9 8 6 28861 24
140 97920 Undocumented 4 Tree(s) :: 17 399X Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6000685 2110085 37.7739291843989 -122.441080369401 (37.7739291843989, -122.441080369401) 15 5 11 29492 16
141 254165 DPW Maintained 1 :: 45 579 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5983759 2111886 37.7778955894485 -122.499762435435 (37.7778955894485, -122.499762435435) 11 6 2 55 26
142 186181 DPW Maintained 1 :: 45 1700 37th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984741.0761 2103142.2522 37.75394530503 -122.495720014116 (37.75394530503, -122.495720014116) 1 8 3 56 35
143 251305 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1 Cashmere St 4 Back Yard : Yard Tree Private 2       3x3   6017463 2095772 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696) 10 3 8 58 1
144 108797 Undocumented 4 :: 45 501-599 University St 4 Sidewalk: Curb side : Cutout Tree Private 2           6008503.45306 2091469.83252 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961) 9 3 7 309 18
145 193492 DPW Maintained 1 Maytenus boaria :: Mayten 58 1918 23rd St 1 Front Yard : Yard Tree Private 2     9     6012632.36685 2102863.5529 37.7547739610597 -122.399245141377 (37.7547739610597, -122.399245141377) 10 3 8 28856 29
146 190658 DPW Maintained 1 :: 45 1461 Fairfax Ave 4 : Tree Private 2     7 Width 3ft   6016241.73559 2097685.48667 37.7407565574799 -122.386401828788 (37.7407565574799, -122.386401828788) 10 3 8 58 1
147 198543 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1700 Newcomb Ave 1 : Tree Private 2     3 Width 0ft   6014375.16951 2096346.21278 37.7369756879815 -122.392762090617 (37.7369756879815, -122.392762090617) 10 3 8 58 1
148 108238 Undocumented 4 Tree(s) :: 17 764x JUNIPERO SERRA BLVD 1 Median : Yard Tree Private 2           5991289.6 2092496.8 37.7250969308873 -122.472297921456 (37.7250969308873, -122.472297921456) 9 8 4 64 40
149 244279 Undocumented 4 :: 45 585 Oak St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004230.7823 2110095.842 37.7741602789386 -122.428815691218 (37.7741602789386, -122.428815691218) 7 9 11 28852 10
150 247856 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 80 Bradford St 5 Side Yard : Yard Tree Private 2     32     6009566.84713 2098148.32022 37.7416556510973 -122.409513828008 (37.7416556510973, -122.409513828008) 10 7 7 28859 2
151 233915 DPW Maintained 1 Persea americana :: Avocado 34 998 York St 9 Sidewalk: Curb side : Yard Tree Private 2     1 Width 7ft   6009943.01185 2103432.65253 37.7561863328563 -122.408585854469 (37.7561863328563, -122.408585854469) 2 4 7 28859 19
152 235666 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1301 Jessie St 4 : Tree Private 2     3 Width 2ft   6006462.25734 2109005.38337 37.7712921868165 -122.421019169707 (37.7712921868165, -122.421019169707) 8 2 9 28853 19
153 185313 DPW Maintained 1 Shrub :: Shrub 66 2601 Sunset Blvd 38 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984983.1747 2097234.3473 37.7377379790483 -122.494447317023 (37.7377379790483, -122.494447317023) 1 8 3 29491 35
155 142339 DPW Maintained 1 :: 45 516 Central Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5999737.6235 2110265.9409 37.7743719952599 -122.444370497086 (37.7743719952599, -122.444370497086) 15 5 11 29492 16
156 222165 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 953 Elizabeth St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6000303.11526 2101951.8939 37.7515759277946 -122.441817532557 (37.7515759277946, -122.441817532557) 2 4 5 28862 22
157 114186 Undocumented 4 Shrub :: Shrub 66 2200 HAYES ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997096 2109871 37.7731365175856 -122.453479795748 (37.7731365175856, -122.453479795748) 15 5 2 29492 16
158 100607 Permitted Site 7 Tree(s) :: 17 270x 05th St 5 Sidewalk: Curb side : Cutout Tree Private 2           6011410.5 2112131.8 37.7801542961347 -122.404122955966 (37.7801542961347, -122.404122955966) 14 2 9 28853 34
159 117627 Undocumented 4 Pinus radiata :: Monterey Pine 15 890x VERMONT ST 4 Unaccepted Street : Yard Tree Private 2           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
162 105806 Undocumented 4 Tree(s) :: 17 1248X ANZA ST   Sidewalk: Curb side : Cutout Tree Private 2       6x3   5994834 2112130 37.7792092085373 -122.461468091676 (37.7792092085373, -122.461468091676) 11 6 2 54 11
165 104843 Permitted Site 7 :: 45 1320 21st Ave   Sidewalk: Curb side : Cutout Tree Private 2           5989622 2106334.7 37.7629955389606 -122.479074319647 (37.7629955389606, -122.479074319647) 1 8 3 56 35
168 222969 DPW Maintained 1 Corymbia maculata :: Spotted Gum 69 1300 San Jose Ave 47 Front Yard : Yard Tree Private 2     16     6003392.92926 2095549.99469 37.7341733681018 -122.430675784084 (37.7341733681018, -122.430675784084) 2 7 5 63 7
169 258020 DPW Maintained 1 Tree(s) :: 17 1001X San Jose Ave 1 Side Yard : Yard Tree Private 2       3x3   6004855 2096548 37.7369963898236 -122.425691948858 (37.7369963898236, -122.425691948858) 2 7 5 28859 2
170 108637 Property Tree 8 Pinus radiata :: Monterey Pine 15 15 TUCKER AVE   Back Yard : Yard Tree Private 2           6011049.2 2088423.2 37.7150354478954 -122.403704200211 (37.7150354478954, -122.403704200211) 9 7 8 309 39
174 113728 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1580 Valencia St 5 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
175 184150 DPW Maintained 1 :: 45 1585 44th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5982480.9001 2104357.3743 37.7571490682193 -122.503626084685 (37.7571490682193, -122.503626084685) 1 8 3 56 35
176 194490 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 22nd St 19 Front Yard : Yard Tree Private 2     29     6013346.63868 2103825.44695 37.7574548949481 -122.396842409144 (37.7574548949481, -122.396842409144) 10 3 8 28856 29
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
178 233603 DPW Maintained 1 Olea europaea :: Olive Tree 9 199 Franconia St 9 : Yard Tree Private 2     6 Width 3ft   6010152.72418 2099634.52308 37.7457692517475 -122.407592814071 (37.7457692517475, -122.407592814071) 2 7 7 28859 2
179 113995 DPW Maintained 1 :: 45 3221 Washington St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   10/27/2015 12:00:00 AM   39x3   5999265.7 2115942.6 37.789931692457 -122.446411428366 (37.789931692457, -122.446411428366) 13 6 1 29490 31
180 110904 Significant Tree 6 Tree(s) :: 17 203 CORBETT AVE 1 Front Yard : Yard Tree Private 2     20 3x3   6000094 2105620 37.7616357315689 -122.442804047122 (37.7616357315689, -122.442804047122) 15 5 5 28862 3
183 253381 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 899 Waller St 3 Side Yard : Yard Tree Private 2           6001282 2108613 37.7699214264211 -122.438909742148 (37.7699214264211, -122.438909742148) 15 5 5 29492 9
185 184541 DPW Maintained 1 :: 45 1706 38th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984416.199 2103539.5001 37.7550170068332 -122.496872815694 (37.7550170068332, -122.496872815694) 1 8 3 56 35
188 112351 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 150 WEST PORTAL AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992711 2097652 37.7393339885882 -122.467759098278 (37.7393339885882, -122.467759098278) 1 8 4 59 40
189 178694 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 184 Mount Vernon Ave 7 Side Yard : Yard Tree Private 2     9     5998957.82756 2089383.479 37.7169892861082 -122.445565994978 (37.7169892861082, -122.445565994978) 9 7 6 28861 25
191 244985 DPW Maintained 1 Olea europaea :: Olive Tree 9 1250 Haight St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000147.9035 2108881.2284 37.7705933244615 -122.442851810939 (37.7705933244615, -122.442851810939) 15 5 11 29492 9

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