142,615 rows where qLegalStatus_id = 1

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                        
4 264831 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 230 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3 4x6   6011678 2088870 37.7162973770842 -122.401562170369 (37.7162973770842, -122.401562170369) 10 7 8 309 39
5 264836 DPW Maintained 1 Laurus x 'Saratoga' :: Hybrid Laurel 4 325 Olmstead St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3 4x6   6010737 2090909 37.7218435009065 -122.404958220137 (37.7218435009065, -122.404958220137) 10 3 7 309 28
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
13 264822 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2 Harkness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3 4x6                      
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
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
16 264823 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2 Harkness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3 4x6                      
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
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
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
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
39 210801 DPW Maintained 1 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 140 Merced Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2020 12:00:00 AM 3 Width 4ft Permit Number 787871 5994480.90157 2099425.24867 37.7443049252384 -122.461768149483 (37.7443049252384, -122.461768149483) 1 8 4 59 40
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
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
49 261834 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 20x Ruth St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/19/2020 12:00:00 AM 3 4x6   6001536 2091749 37.7236313283612 -122.436823756643 (37.7236313283612, -122.436823756643) 9 7 6 28861 25
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
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
55 1166 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2900 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/23/2020 12:00:00 AM 25 3X3   5997012.91474 2087625.16187 37.7120501257788 -122.45216178836 (37.7120501257788, -122.45216178836) 9 7 6 28861 25
57 230549 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 39 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/2020 12:00:00 AM 3 Width 3ft Permit Number 787877 6005359.28388 2095944.60166 37.7353680760624 -122.423905517743 (37.7353680760624, -122.423905517743) 2 7 7 28859 2
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
61 227151 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 48 Fair Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/2020 12:00:00 AM 3 Width 3ft Permit Number 787879 6006822.59734 2099508.62809 37.7452366012942 -122.419099008325 (37.7452366012942, -122.419099008325) 2 7 7 28859 2
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
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
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
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
79 121399 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 349X Cargo Way 1 Sidewalk: Curb side : Cutout Tree DPW 1                              
80 260998 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 600X Lake Merced Blvd 1 Sidewalk: Property side : Yard Tree SFUSD 4       10x10                      
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                            
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
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                        
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
98 261380 DPW Maintained 1 Potential Site :: Potential Site 48 298x Leavenworth St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6008523 2113477 37.7836861327236 -122.414207368753 (37.7836861327236, -122.414207368753) 7 10 9 28852 36
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                        
103 253831 DPW Maintained 1 :: 45 699X Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3                      
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                        
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                      
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
122 17067 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1355 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000506.9486 2109572.2346 37.7725111167076 -122.441659471159 (37.7725111167076, -122.441659471159) 15 5 11 29492 9
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
124 114040 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 95 LINARES AVE 1 Front Yard : Yard Tree DPW 1     40 3x3   5994258 2102054 37.7515099774588 -122.462729551044 (37.7515099774588, -122.462729551044) 1 8 4 29491 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
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
130 13128 DPW Maintained 1 Tristania conferta :: 61 1714 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6004131.2449 2119777.2826 37.8007374433085 -122.429850711739 (37.8007374433085, -122.429850711739) 13 9 1 57 17
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
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
134 257900 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 5701x 03rd St 7 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014158 2092336 37.7259523956068 -122.393232416121 (37.7259523956068, -122.393232416121) 10 3 8 58 1
136 11131 DPW Maintained 1 Olea europaea :: Olive Tree 9 2400X Hyde St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6007074.9072505 2120528.613771 37.802966665104 -122.419717737051 (37.802966665104, -122.419717737051) 5 1 1 28858 32
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
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
139 106382 DPW Maintained 1 Tree(s) :: 17 182x Lower Ter 9 Median : Cutout Tree DPW 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
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
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
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

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