142,615 rows where qLegalStatus_id = 1 sorted by PlotSize

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)
1 264847 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 109 Felton St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6010522 2093730 37.729577358437 -122.405900044893 (37.729577358437, -122.405900044893) 10 3 7 309 28
2 262167 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 420 Alpha St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 11/16/2020 12:00:00 AM 3                        
6 262166 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 420 Alpha St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 11/16/2020 12:00:00 AM 3                        
8 264824 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1x Harkness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6012032 2089425 37.7178410421308 -122.400377527521 (37.7178410421308, -122.400377527521) 10 7 8 309 39
9 32966 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 556 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/17/2020 12:00:00 AM 3   Permit Number 37281 6014072.59224 2104507.52941 37.759368126158 -122.394379509632 (37.759368126158, -122.394379509632) 10 3 8 28856 29
11 264841 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1601 Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6007819 2087884 37.7133739406818 -122.41483104388 (37.7133739406818, -122.41483104388) 9 7 8 309 39
15 264849 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 15 Hale St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6010381 2094903 37.7327902820185 -122.40647012075 (37.7327902820185, -122.40647012075) 10 3 7 309 28
18 50210 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 830 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/2003 12:00:00 AM 8   Permit Number 46918 5987602.00308 2110288.94488 37.7737352840678 -122.486351029235 (37.7737352840678, -122.486351029235) 11 6 2 55 26
19 262168 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 420 Alpha St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 11/16/2020 12:00:00 AM 3                        
21 264839 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1601 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6007819 2087884 37.7133739406818 -122.41483104388 (37.7133739406818, -122.41483104388) 9 7 8 309 39
23 50211 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 834 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/2003 12:00:00 AM 9   Permit Number 46919 5987605.33986 2110266.54313 37.7736739696217 -122.486337841964 (37.7736739696217, -122.486337841964) 11 6 2 55 26
25 49783 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/2020 12:00:00 AM 3   Permit Number 46568 6011944.29976 2088937.30454 37.7164970376796 -122.400646428989 (37.7164970376796, -122.400646428989) 10 7 8 309 39
26 259857 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1255 Brussels St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 11/01/2020 12:00:00 AM 3     6011768.59367 2089078.72926 37.7168755602396 -122.401263692233 (37.7168755602396, -122.401263692233) 10 7 8 309 39
28 264848 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 15 Hale St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6010381 2094903 37.7327902820185 -122.40647012075 (37.7327902820185, -122.40647012075) 10 3 7 309 28
32 264850 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 172 University St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6007951 2093149 37.7278379340298 -122.414747181337 (37.7278379340298, -122.414747181337) 9 3 7 309 5
76 34164 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2500 Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2   07/22/1997 12:00:00 AM 5   Permit Number 38230 6001594.91074 2117340.13182 37.7939017096586 -122.438452751501 (37.7939017096586, -122.438452751501) 13 9 1 57 27
79 121399 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 349X Cargo Way 1 Sidewalk: Curb side : Cutout Tree DPW 1                              
82 251210 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1170 Ingalls St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/02/1992 12:00:00 AM                          
83 259099 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 600 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
85 259368 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 1646 Revere Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
87 259654 DPW Maintained 1 :: 45 101x Cora St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
88 259653 DPW Maintained 1 :: 45 99x Cora St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
89 259623 DPW Maintained 1 :: 45 1498x Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
90 259864 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1398x Brussels St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
91 260225 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2201x 22nd Ave 21 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
92 260521 DPW Maintained 1 Leucodendron argenteum :: Silver Tree 46 3519x Kirkham St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 07/27/2019 12:00:00 AM 3                        
93 260525 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3437x Rivera St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 07/27/2019 12:00:00 AM 3                        
100 255131 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 9 Sidewalk: Property side : Yard Tree DPW 1                              
101 255229 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
102 258152 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 500X Bryant St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3                        
104 260590 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3099x Jennings St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/20/2020 12:00:00 AM 3                        
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
106 251438 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2501X Santiago St 1 Median : Yard Tree DPW 1                              
107 264818 DPW Maintained 1 Podocarpus gracilor :: Fern Pine 51 101x Olmstead St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/23/2020 12:00:00 AM 3                        
127 119777 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 12 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
129 107934 DPW Maintained 1 Tree(s) :: 17 3098X Market St 3 Median : Yard Tree DPW 1           5999920 2105144 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916) 2 4 5 28862 3
133 211075 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 650x Miramar Ave 6 Median : Yard Tree DPW 1     34     5995390.83549 2093912.64173 37.7292209976493 -122.458222905073 (37.7292209976493, -122.458222905073) 9 7 4 28861 40
137 189330 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1427x Innes Ave 23 Median : Yard Tree DPW 1     15     6016163.75351 2096735.77367 37.7381445215441 -122.386605256348 (37.7381445215441, -122.386605256348) 10 3 8 58 1
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
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
154 119838 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 11 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
160 107490 DPW Maintained 1 Prunus spp :: Cherry 68 1306x Montgomery St 19 Median : Cutout Tree DPW 1     12     6011447.18476 2119974.76336 37.8016912541172 -122.404548295963 (37.8016912541172, -122.404548295963) 3 1 10 308 23
161 194506 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 299x Cashmere St 26 Median : Yard Tree DPW 1     18     6016624.93937 2096021.78221 37.7362095654157 -122.384960961105 (37.7362095654157, -122.384960961105) 10 3 8 58 1
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
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
181 14420 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2X Masonic Ave 8 Median : Cutout Tree DPW 1     35     5998841.5976 2113071.3194 37.7820236767836 -122.447671998063 (37.7820236767836, -122.447671998063) 15 5 2 54 16
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
187 112917 DPW Maintained 1 Shrub :: Shrub 66 480X BEACON ST 1 Sidewalk: Property side : Yard Tree DPW 1           6002571 2098077 37.7410653426557 -122.433697996676 (37.7410653426557, -122.433697996676) 2 7 5 63 7
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
202 190636 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1 01st St 30 : Yard Tree Private 2     8     6014391.99798 2105898.86804 37.7632061898228 -122.393372206868 (37.7632061898228, -122.393372206868) 14 3 8 28856 29
206 119799 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 7 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
215 119692 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 10 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
225 119839 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 12 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
238 119796 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 4 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
245 251484 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 900 Bosworth St 7 Front Yard : Yard Tree DPW 1           6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
246 136052 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1114 Greenwich St 1 Side Yard : Yard Tree Private 2     3     6007569.13805 2119905.68389 37.801284085155 -122.417963252702 (37.801284085155, -122.417963252702) 5 1 1 28858 32
247 240348 DPW Maintained 1 Quercus suber :: Cork Oak 78 1201 San Jose Ave 26 Front Yard : Yard Tree Private 2     1     6004340.86769 2095971.00866 37.7353830362869 -122.427428442788 (37.7353830362869, -122.427428442788) 2 7 5 28861 2
248 119766 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 1 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
251 187669 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 554 Valley St 1 Median : Yard Tree Private 2           6002324 2099197 37.7441265828549 -122.434632098307 (37.7441265828549, -122.434632098307) 2 7 5 63 22
259 196282 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1 25th St 13 : Yard Tree Private 2     12     6015015.25562 2102205.64875 37.7531000097757 -122.390958410295 (37.7531000097757, -122.390958410295) 10 3 8 28856 29
266 219228 DPW Maintained 1 Ilex spp :: Holly Species 81 200x Terrace Dr 4 Median : Yard Tree DPW 1     10     5993785.97496 2096493.89011 37.736216119669 -122.463958297244 (37.736216119669, -122.463958297244) 1 8 4 59 40
267 178174 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard Tree Private 2     2     5988358.3694 2089791.63303 37.717499145949 -122.482232652541 (37.717499145949, -122.482232652541) 1 8 4 64 14
271 107116 DPW Maintained 1 Tree(s) :: 17 300X LIBERTY ST 18 Median : Cutout Tree DPW 1     12     6004270.1 2103982.4 37.7573764628527 -122.428243896062 (37.7573764628527, -122.428243896062) 2 4 5 28862 3
283 78989 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2319 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5988235.2891 2099507.8812 37.7441702991504 -122.483369943638 (37.7441702991504, -122.483369943638) 1 8 3 29491 35
285 260625 DPW Maintained 1 Laurus x 'Saratoga' :: Hybrid Laurel 4 1601x Thomas Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3                        
290 72670 DPW Maintained 1 Taxus baccata :: Irish Yew 86 203 04th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     5994586.71732 2114106.61682 37.7846222306097 -122.462466948558 (37.7846222306097, -122.462466948558) 11 6 2 54 11
300 234411 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 10x Benton Ave 4 Median : Yard Tree DPW 1     32     6004755.33467 2095032.93123 37.7328307189427 -122.425928720736 (37.7328307189427, -122.425928720736) 2 7 7 28861 2
304 132028 DPW Maintained 1 Olea europaea :: Olive Tree 9 33x Battery St 1 Median : Yard Tree DPW 1     27     6012842.61776 2116100.99756 37.7911327033699 -122.399447311639 (37.7911327033699, -122.399447311639) 4 1 10 28854 6
313 119729 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 9 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
344 119791 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 11 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
357 232461 DPW Maintained 1 Olea europaea :: Olive Tree 9 1300 San Jose Ave 12 Front Yard : Yard Tree Private 2     11     6003612.68018 2095726.39764 37.7346701778724 -122.429928614715 (37.7346701778724, -122.429928614715) 2 7 5 63 7
358 222991 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 7 Sidewalk: Curb side : Pot Tree Private 2     24     6002568.09263 2099485.22731 37.7449318417374 -122.433808677655 (37.7449318417374, -122.433808677655) 2 7 5 63 22
375 115067 DPW Maintained 1 :: 45 70 Coral Rd 7 Sidewalk: Curb side : Cutout Tree DPW 1           6012676.36761 2102522.24683 37.7538392609312 -122.399069018455 (37.7538392609312, -122.399069018455) 10 3 8 28856 29
389 121965 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 20 15th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6     5991180.37033 2114963.80683 37.7867790889821 -122.474314218886 (37.7867790889821, -122.474314218886) 11 6 1 54 33
391 104857 DPW Maintained 1 :: 45 2555 46th Ave   Sidewalk: Curb side : Cutout Landscaping Private 2           5982069.8 2097707.6 37.7388664658919 -122.504555139124 (37.7388664658919, -122.504555139124) 1 8 3 29491 35
406 119837 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 10 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
413 119686 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 4 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
420 35740 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 9 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/15/1998 12:00:00 AM 12   Permit Number 39014 6007525.01662 2093953.73286 37.7300236128799 -122.416276791867 (37.7300236128799, -122.416276791867) 9 3 7 309 28
421 65202 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 415 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM 29   Permit Number 27188 6004121.81538 2090701.65991 37.7209021868562 -122.4278104505 (37.7209021868562, -122.4278104505) 9 7 6 28861 5
428 119830 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 3 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
431 119778 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 13 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
432 196351 DPW Maintained 1 Prunus lyonii :: Catalina Cherry 104 1900 19th St 20 Front Yard : Yard Tree Private 2     3     6011965.48 2105145.22305 37.7610017347515 -122.401711799169 (37.7610017347515, -122.401711799169) 10 3 8 28856 29
436 120628 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 5 Median : Cutout Tree DPW 1           6004397 2113949 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
442 119718 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 11 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
444 105900 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 11X ELLIOT ST 1 Unaccepted Street : Yard Tree DPW 1     30     6009059 2088845 37.716082244868 -122.410612975888 (37.716082244868, -122.410612975888) 9 7 8 309 18
449 252970 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101X Whipple Ave 2 Sidewalk: Curb side : Yard Tree Private 2   04/26/2019 12:00:00 AM 3                        
458 125288 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 943 Green St 11 Side Yard : Yard Tree Private 2     1     6008674.79926 2118995.08989 37.7988459853112 -122.414072708211 (37.7988459853112, -122.414072708211) 5 1 10 308 21
459 192393 DPW Maintained 1 Fremontodendron spp :: Flannel Bush Tree 107 1 24th St 25 : Yard Tree Private 2     3     6017132.65269 2102598.12552 37.7542949326738 -122.38366328523 (37.7542949326738, -122.38366328523) 10 3 8 28856 29
470 119711 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 4 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
481 119782 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 2 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
483 173928 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 51 Vulcan Stwy 1 Front Yard : Cutout Tree Private 2           6000543 2106304 37.7635394137592 -122.441300222472 (37.7635394137592, -122.441300222472) 15 5 5 28862 3
503 64636 DPW Maintained 1 Chitalpa tashkentensis :: 114 1340 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/1993 12:00:00 AM 4   Permit Number 31906 6008274 2116946 37.7931971721852 -122.415314473397 (37.7931971721852, -122.415314473397) 5 1 10 28858 21
504 78734 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 901 Huron Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5997023.15719 2086886.03529 37.710021240846 -122.452073093618 (37.710021240846, -122.452073093618) 9 7 6 28861 25
505 71223 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2245 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5987597.8172 2100005.1583 37.7454985686348 -122.485610641464 (37.7454985686348, -122.485610641464) 1 8 3 29491 35
518 70144 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 8 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5991175.64413 2115000.10527 37.7868784805694 -122.474333220033 (37.7868784805694, -122.474333220033) 11 6 1 54 33
519 259637 DPW Maintained 1 :: 45 95 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3     6010745.67067 2087724.79538 37.7131008096728 -122.404704194453 (37.7131008096728, -122.404704194453) 9 7 8 309 39
522 74913 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1600 Cabrillo St 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     5990592.63982 2110647.77936 37.7748944063775 -122.476032267507 (37.7748944063775, -122.476032267507) 11 6 2 55 26
527 32100 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 156 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1995 12:00:00 AM 10   Permit Number 35473 6002658.19542 2104999.95129 37.7600790771166 -122.433891224619 (37.7600790771166, -122.433891224619) 2 4 5 28862 3
537 261951 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 5 Sidewalk: Property side : Yard Tree DPW 1                              
540 35140 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 911 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1998 12:00:00 AM 7   Permit Number 38670 6001882.60594 2088665.49745 37.7151844124098 -122.435405132561 (37.7151844124098, -122.435405132561) 9 7 6 28861 5

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