trees

1,732 rows where qLegalStatus_id = 6 sorted by PlotSize 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)
5115 260959 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 400 Cherry St 11 Sidewalk: Property side : Yard Tree Private 2       Width 9ft   5996243 2114742 37.7864620624436 -122.456782770891 (37.7864620624436, -122.456782770891) 11 6 1 54 31
32937 178336 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 2 Sidewalk: Property side : Yard Tree MTA 3     29 Width 8ft   5998664.9682 2091522.93582 37.7228470175482 -122.44673211619 (37.7228470175482, -122.44673211619) 9 7 6 28861 25
54303 178335 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 1 Sidewalk: Property side : Yard Tree MTA 3     33 Width 8ft   5998656.04486 2091523.12147 37.7228470175503 -122.446762975526 (37.7228470175503, -122.446762975526) 9 7 6 28861 25
1427 260648 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 3891 Sacramento St 6 Sidewalk: Property side : Yard Tree Private 2       Width 7ft   5996301.11796 2114890.85877 37.7868741256738 -122.456592467462 (37.7868741256738, -122.456592467462) 11 6 1 54 31
4071 260649 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 3891 Sacramento St 7 Sidewalk: Property side : Yard Tree Private 2       Width 7ft   5996301.11796 2114890.85877 37.7868741256738 -122.456592467462 (37.7868741256738, -122.456592467462) 11 6 1 54 31
12431 262225 Significant Tree 6 Cupressus spp :: Cypress species 337 2450 Golden Gate Ave 1 Sidewalk: Property side : Yard Tree Private 2       Width 7ft   5997659.54255 2111324.05825 37.7771585265736 -122.451635273045 (37.7771585265736, -122.451635273045) 15 6 2 54 16
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
74248 208929 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 501 Saint Francis Blvd 1 Sidewalk: Curb side : Pot Tree Private 2     34 Width 6ft   5993145.62708 2096072.03007 37.735020873007 -122.466141577798 (37.735020873007, -122.466141577798) 1 8 4 59 40
101661 257928 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 101 Lombard St 12 Sidewalk: Property side : Yard Tree Private 2       Width 6ft   6011760.21977 2120791.0173 37.8039499778675 -122.403522505873 (37.8039499778675, -122.403522505873) 3 1 10 28860 6
137836 208971 Significant Tree 6 Tree(s) :: 17 150 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2   12/18/2018 12:00:00 AM 3 Width 6ft Permit Number 782070 5994318.90627 2096521.25566 37.7363219572757 -122.462117732164 (37.7363219572757, -122.462117732164) 9 8 4 59 40
166311 127110 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3201 Laguna St 1 Sidewalk: Property side : Yard Tree Private 2     23 Width 6ft   6003718.35126 2119752.0994 37.8006449063974 -122.431277695812 (37.8006449063974, -122.431277695812) 13 9 1 57 17
9908 215094 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 218 Sadowa St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994821.63014 2087784.20309 37.7123610457095 -122.459746958272 (37.7123610457095, -122.459746958272) 9 8 6 28861 24
36628 177109 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 16 Sidewalk: Property side : Yard Tree MTA 3     6 Width 5ft   5998958.08532 2091518.52367 37.7228516427597 -122.445718558684 (37.7228516427597, -122.445718558684) 9 7 6 28861 25
47041 177110 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 17 Sidewalk: Property side : Yard Tree MTA 3     6 Width 5ft   5998978.57855 2091518.53644 37.722852847868 -122.445647719081 (37.722852847868, -122.445647719081) 9 7 6 28861 25
49633 177105 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 12 Sidewalk: Property side : Yard Tree MTA 3     4 Width 5ft   5998924.5969 2091518.78116 37.7228504376811 -122.445834339179 (37.7228504376811, -122.445834339179) 9 7 6 28861 25
57339 177108 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 15 Sidewalk: Property side : Yard Tree MTA 3     5 Width 5ft   5998950.80755 2091518.23612 37.7228504376851 -122.44574369564 (37.7228504376851, -122.44574369564) 9 7 6 28861 25
81780 206842 Significant Tree 6 Tree(s) :: 17 218 Sadowa St 3 Sidewalk: Property side : Cutout Tree Private 2   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994803.1874 2087784.4983 37.712360795684 -122.45981072288 (37.712360795684, -122.45981072288) 9 8 6 28861 24
173815 177104 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 11 Sidewalk: Property side : Yard Tree MTA 3     4 Width 5ft   5998921.08183 2091519.29315 37.7228516427808 -122.445846526795 (37.7228516427808, -122.445846526795) 9 7 6 28861 25
176521 177106 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 13 Sidewalk: Property side : Yard Tree MTA 3     7 Width 5ft   5998933.17773 2091518.16383 37.7228492325857 -122.445804632792 (37.7228492325857, -122.445804632792) 9 7 6 28861 25
3724 260475 Significant Tree 6 Acer spp :: Maple 88 520 Laurel St 3 Side Yard : Cutout Tree Private 2       Width 4ft   5998188 2114710 37.7864856873194 -122.450051281182 (37.7864856873194, -122.450051281182) 11 6 1 54 31
6928 260474 Significant Tree 6 Acer spp :: Maple 88 520 Laurel St 2 Side Yard : Cutout Tree Private 2       Width 4ft   5998188 2114710 37.7864856873194 -122.450051281182 (37.7864856873194, -122.450051281182) 11 6 1 54 31
13058 260903 Significant Tree 6 Taxus baccata :: Irish Yew 86 51 Shore View Ave 1 Sidewalk: Property side : Yard Tree Private 2       Width 4ft   5984536 2112849 37.7805852728313 -122.497145662996 (37.7805852728313, -122.497145662996) 11 6 2 55 26
14900 260476 Significant Tree 6 Acer spp :: Maple 88 520 Laurel St 4 Side Yard : Cutout Tree Private 2       Width 4ft   5998188 2114710 37.7864856873194 -122.450051281182 (37.7864856873194, -122.450051281182) 11 6 1 54 31
18519 260473 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 520 Laurel St 1 Side Yard : Cutout Tree Private 2       Width 4ft   5998188 2114710 37.7864856873194 -122.450051281182 (37.7864856873194, -122.450051281182) 11 6 1 54 31
19027 260904 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 4228 Geary Blvd 1 Sidewalk: Property side : Cutout Tree Private 2       Width 4ft   5993841 2112866 37.7811728620679 -122.464956727678 (37.7811728620679, -122.464956727678) 11 6 2 54 11
27012 255276 Significant Tree 6 Maytenus boaria :: Mayten 58 263 Willow St 6 Sidewalk: Property side : Yard Tree Private 2       Width 4ft   6006404.75096 2113360.62408 37.7832473828943 -122.421527451234 (37.7832473828943, -122.421527451234) 7 9 11 28858 41
46153 209002 Significant Tree 6 Tree(s) :: 17 115 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2   07/17/2018 12:00:00 AM 3 Width 4ft Permit Number 781950 5994125 2096751 37.7369416119865 -122.462804803775 (37.7369416119865, -122.462804803775) 9 8 4 59 40
115750 255277 Significant Tree 6 Maytenus boaria :: Mayten 58 263 Willow St 7 Sidewalk: Property side : Cutout Tree Private 2       Width 4ft   6006404.75096 2113360.62408 37.7832473828943 -122.421527451234 (37.7832473828943, -122.421527451234) 7 9 11 28858 41
126646 255275 Significant Tree 6 Maytenus boaria :: Mayten 58 263 Willow St 5 Sidewalk: Property side : Yard Tree Private 2       Width 4ft   6006404.75096 2113360.62408 37.7832473828943 -122.421527451234 (37.7832473828943, -122.421527451234) 7 9 11 28858 41
156627 125128 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2545 Baker St 2 Sidewalk: Property side : Yard Tree Private 2     13 Width 4ft   5999632.15337 2117620.57677 37.7945598973812 -122.44526423016 (37.7945598973812, -122.44526423016) 13 9 1 57 27
551 234021 Significant Tree 6 Pittosporum tobira :: Japanese Mockorange 118 147 Nevada St 1 Sidewalk: Curb side : Pot Tree Private 2     13 Width 3ft   6009064.54563 2097789.74594 37.7406429263284 -122.411225300822 (37.7406429263284, -122.411225300822) 10 7 7 28859 2
1248 260958 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 3790 California St 2 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   5996359 2114633 37.786169437555 -122.456373557771 (37.786169437555, -122.456373557771) 11 6 1 54 31
3323 258079 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 606 Capp St 3 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   6007262.82565 2103708.68672 37.7567937898158 -122.417874439265 (37.7567937898158, -122.417874439265) 2 4 7 28859 19
3385 223764 Significant Tree 6 Juniperus chinensis :: Juniper 113 126 Bradford St 2 Sidewalk: Property side : Yard Tree Private 2     12 Width 3ft   6009530.67949 2097860.55808 37.7408634922583 -122.409618578359 (37.7408634922583, -122.409618578359) 10 7 7 28859 2
3462 233333 Significant Tree 6 Pinus radiata :: Monterey Pine 15 188 States St 1 Back Yard : Yard Tree Private 2     14 Width 3ft Permit Number 784841 6001049.9199 2106366.66768 37.763740347549 -122.43955144426 (37.763740347549, -122.43955144426) 15 5 5 28862 3
4164 260061 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 8 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
4813 223765 Significant Tree 6 Juniperus chinensis :: Juniper 113 126 Bradford St 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6009530.59471 2097856.4038 37.7408520807582 -122.409618578357 (37.7408520807582, -122.409618578357) 10 7 7 28859 2
7930 223763 Significant Tree 6 Juniperus chinensis :: Juniper 113 126 Bradford St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6009530.79254 2097866.09723 37.7408787078943 -122.409618578334 (37.7408787078943, -122.409618578334) 10 7 7 28859 2
8078 260059 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 6 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
9215 260060 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 7 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
9783 261822 Significant Tree 6 Acacia baileyana :: Bailey's Acacia 122 3580 21st St 2 Front Yard : Yard Tree Private 2       Width 3ft Permit Number 785112 6004538.52309 2103691.84305 37.7565938462521 -122.427294885373 (37.7565938462521, -122.427294885373) 2 4 5 28862 3
10162 230434 Significant Tree 6 Magnolia x soulangiana :: Saucer Magnolia 147 272 Anderson St 1 Front Yard : Yard Tree Private 2     9 Width 3ft   6007874.82314 2097362.07469 37.7394018403099 -122.415308650074 (37.7394018403099, -122.415308650074) 2 7 7 28859 2
11129 236516 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 63 Bronte St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6009359.84862 2097078.24448 37.7387058549889 -122.410154031979 (37.7387058549889, -122.410154031979) 10 7 7 28859 2
11600 260651 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3751 Sacramento St 2 Front Yard : Cutout Tree Private 2       Width 3ft   5996933 2115011 37.7872402598449 -122.454414995547 (37.7872402598449, -122.454414995547) 11 6 1 54 31
12923 237906 Significant Tree 6 Tree(s) :: 17 3937 21st St 3 Front Yard : Yard Tree Private 2   10/06/2020 12:00:00 AM 3 Width 3ft Permit Number 785171 6002245.41508 2103514.00804 37.7559756019151 -122.43521254633 (37.7559756019151, -122.43521254633) 2 4 5 28862 22
13777 261032 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 438 Roosevelt Way 2 Front Yard : Yard Tree Private 2       Width 3ft   6000030.97008 2106544.70148 37.7641711390149 -122.443088453592 (37.7641711390149, -122.443088453592) 15 5 5 29492 3
15065 261762 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 2943 Harrison St 1 Front Yard : Yard Tree Private 2       Width 3ft   6009034.67775 2101326.83516 37.7503533174728 -122.411578417814 (37.7503533174728, -122.411578417814) 2 4 7 28859 19
15717 221238 Significant Tree 6 Betula pendula :: European White Birch 253 55 Bronte St 1 Sidewalk: Curb side : Pot Tree Private 2     14 Width 3ft   6009363.02974 2097125.97708 37.7388370966643 -122.41014640214 (37.7388370966643, -122.41014640214) 10 7 7 28859 2
16055 260578 Significant Tree 6 Tree(s) :: 17 1879 Funston Ave 1 Sidewalk: Property side : Cutout Tree Private 2   05/22/2020 12:00:00 AM 3 Width 3ft Permit Number 784834 5992075.37659 2102679.56742 37.7531016753032 -122.470322812874 (37.7531016753032, -122.470322812874) 1 8 4 56 12
16256 260911 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2035 15th Ave 1 Front Yard : Yard Tree Private 2       Width 3ft   5991575 2101572 37.7500316406912 -122.471972478281 (37.7500316406912, -122.471972478281) 1 8 4 29491 12
16260 260650 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3751 Sacramento St 1 Front Yard : Cutout Tree Private 2       Width 3ft   5996933 2115011 37.7872402598449 -122.454414995547 (37.7872402598449, -122.454414995547) 11 6 1 54 31
17671 260957 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 3790 California St 1 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   5996359 2114633 37.786169437555 -122.456373557771 (37.786169437555, -122.456373557771) 11 6 1 54 31
18171 260058 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 5 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
18860 229626 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 3658 Folsom St 1 Side Yard : Cutout Tree Private 2     10 Width 3ft   6008459.0571 2097864.523 37.7408142714666 -122.413324142211 (37.7408142714666, -122.413324142211) 2 7 7 28859 2
27985 253620 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 1120 South Van Ness Ave 3 Front Yard : Cutout Tree Private 2       Width 3ft   6007603.98274 2103104.14442 37.7551530486792 -122.416651764192 (37.7551530486792, -122.416651764192) 2 4 7 28859 19
52809 224289 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 166 San Carlos St 1 Sidewalk: Property side : Yard Tree Private 2     18 Width 3ft   6006647.34642 2105145.25174 37.7607036068074 -122.420104944992 (37.7607036068074, -122.420104944992) 2 4 7 28859 19
66903 233917 Significant Tree 6 Persea americana :: Avocado 34 1011 South Van Ness Ave 1 Front Yard : Yard Tree Private 2     21 Width 3ft   6007639.59401 2103741.67603 37.756905567467 -122.416573768674 (37.756905567467, -122.416573768674) 2 4 7 28859 19
67906 223957 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 98 Seward St 1 Sidewalk: Property side : Yard Tree Private 2     14 Width 3ft   6000715.72405 2104622.00656 37.7589309108477 -122.440582177927 (37.7589309108477, -122.440582177927) 2 4 5 28862 38
72516 258223 Significant Tree 6 Pinus Spp :: Pine Spp 100 53 Starr King Way 1 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft Permit Number 782966 6005764 2113984 37.784922869937 -122.423788535241 (37.784922869937, -122.423788535241) 13 9 11 28858 41
104567 254405 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 321 Lexington St 2 Sidewalk: Curb side : Yard Tree Private 2       Width 3ft   6006540.69106 2104208.04068 37.7581242333638 -122.420407294379 (37.7581242333638, -122.420407294379) 2 4 7 28859 19
107642 251173 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 367 Jersey St 2 Front Yard : Yard Tree Private 2       Width 3ft   6002770.52649 2101500.01269 37.7504754543841 -122.433252636724 (37.7504754543841, -122.433252636724) 2 4 5 28862 22
113217 255048 Significant Tree 6 Pinus Spp :: Pine Spp 100 45 Eagle St 3 Front Yard : Yard Tree Private 2       Width 3ft   6000118.88808 2104341.86796 37.7581277146448 -122.44262619575 (37.7581277146448, -122.44262619575) 2 4 5 28862 3
126309 258077 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 291 Duboce Ave 4 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   6005037.67201 2108401.42033 37.7695534429634 -122.425903876974 (37.7695534429634, -122.425903876974) 8 4 5 28853 19
128499 255151 Significant Tree 6 Araucaria bidwillii :: Bunya Bunya 551 201 Vicente St 4 Front Yard : Yard Tree Private 2       Width 3ft   5992494.60347 2097875.96956 37.7399364549038 -122.468523586018 (37.7399364549038, -122.468523586018) 1 8 4 59 40
156075 258076 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 291 Duboce Ave 3 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   6005037.67201 2108401.42033 37.7695534429634 -122.425903876974 (37.7695534429634, -122.425903876974) 8 4 5 28853 19
167295 223958 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 98 Seward St 2 Sidewalk: Property side : Yard Tree Private 2     13 Width 3ft   6000714.90104 2104629.88079 37.7589524846915 -122.440585589054 (37.7589524846915, -122.440585589054) 2 4 5 28862 38
172650 255483 Significant Tree 6 Persea americana :: Avocado 34 1295 Hampshire St 1 Front Yard : Yard Tree Private 2       Width 3ft   6010340.83328 2101731.71507 37.7515382084299 -122.407090155993 (37.7515382084299, -122.407090155993) 10 4 7 28859 19
176722 253637 Significant Tree 6 Pinus radiata :: Monterey Pine 15 701 Noe St 2 Front Yard : Yard Tree Private 2       Width 3ft   6003144.80454 2104133.37104 37.7577272573137 -122.432146391441 (37.7577272573137, -122.432146391441) 2 4 5 28862 3
193898 258078 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 606 Capp St 2 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   6007262.82565 2103708.68672 37.7567937898158 -122.417874439265 (37.7567937898158, -122.417874439265) 2 4 7 28859 19
159697 226945 Significant Tree 6 Juniperus chinensis :: Juniper 113 998 Chenery St 4 Sidewalk: Property side : Yard Tree Private 2     21 Width 1ft   6001140.61217 2096125.61153 37.7356260187109 -122.438503967885 (37.7356260187109, -122.438503967885) 2 7 5 63 7
891 207770 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 40 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     35 Width 10ft   5993240.61068 2097284.1687 37.7383545825079 -122.465901234858 (37.7383545825079, -122.465901234858) 1 8 4 59 40
4898 211279 Significant Tree 6 Pinus radiata :: Monterey Pine 15 350 Joost Ave 1 Sidewalk: Property side : Yard Tree Private 2     28 Width 10ft   5999756.13451 2094992.8184 37.7324367835174 -122.443209289192 (37.7324367835174, -122.443209289192) 9 7 4 63 40
177584 234000 Significant Tree 6 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 749 27th St 2 Front Yard : Yard Tree Private 2     10 Width 10ft   6001659.60779 2099970.43439 37.7462125114091 -122.436984776447 (37.7462125114091, -122.436984776447) 2 7 5 63 22
5712 258876 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1326 Hayes St 1 Sidewalk: Curb side : Yard Tree Private 2       Width 0ft   6001504 2110473 37.7750411502564 -122.438275119801 (37.7750411502564, -122.438275119801) 15 5 11 29492 10
14733 255398 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 637 MASONIC AVE 3 Sidewalk: Property side : Cutout Tree Private 2       Width 0ft   5999139.3301 2110590.1819 37.7752281241925 -122.446463429304 (37.7752281241925, -122.446463429304) 15 5 11 29492 16
17502 260902 Significant Tree 6 Populus alba :: White Poplar 184 1901 Geary Blvd 1 Sidewalk: Property side : Cutout Tree DPW 1       Width 0ft   6002672 2113572 37.7836165897996 -122.434456380093 (37.7836165897996, -122.434456380093) 13 9 11 29490 41
33161 254729 Significant Tree 6 Cryptomeria japonica :: Japanese Cryptomeria 420 1940 Mission St 6 Sidewalk: Property side : Yard Tree Private 2       Width 0ft   6006763.6807 2106952.0622 37.7656712394659 -122.419830807079 (37.7656712394659, -122.419830807079) 8 4 7 28853 19
89841 253178 Significant Tree 6 Washingtonia filifera :: California Fan Palm 176 4450 24th St 2 Front Yard : Cutout Tree Private 2       Width 0ft Permit Number 780574 6000289.52403 2101701.02913 37.7508863393389 -122.441846529398 (37.7508863393389, -122.441846529398) 2 4 5 28862 22
104067 255325 Significant Tree 6 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 42 Lippard Ave 1 Front Yard : Yard Tree Private 2       Width 0ft Permit Number 781812 6002006.02273 2095939.48888 37.7351641583954 -122.435498605394 (37.7351641583954, -122.435498605394) 2 7 5 63 7
151585 254728 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1940 Mission St 5 Sidewalk: Property side : Yard Tree Private 2       Width 0ft   6006763.6807 2106952.0622 37.7656712394659 -122.419830807079 (37.7656712394659, -122.419830807079) 8 4 7 28853 19
64053 96906 Significant Tree 6 Ulmus 'Frontier' :: Frontier Elm 115 1155@Sansome Battery St 1 Front Yard : Yard Tree Private 2   08/05/2011 12:00:00 AM   Plaza Permit Number 768022 6012245 2120028 37.8018819838627 -122.401791216362 (37.8018819838627, -122.401791216362) 3 1 10 28860 6
84386 99192 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1155@Sansome Battery St 3 Front Yard : Yard Tree Private 2       Plaza Permit Number 768022 6012245 2120028 37.8018819838627 -122.401791216362 (37.8018819838627, -122.401791216362) 3 1 10 28860 6
93882 99191 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1155@Sansome Battery St 2 Front Yard : Yard Tree Private 2     9 Plaza Permit Number 768022 6012232.15659 2120086.23158 37.8020411569217 -122.401839756495 (37.8020411569217, -122.401839756495) 3 1 10 28860 6
78031 91107 Significant Tree 6 Tree(s) :: 17 2650 Turk Blvd 2 Front Yard : Yard Tree Private 2   01/12/2009 12:00:00 AM   On campus Permit Number 51996 5995208 2110277 37.7741428808777 -122.460040004978 (37.7741428808777, -122.460040004978) 11 6 2 54 11
153312 91106 Significant Tree 6 Tree(s) :: 17 2650 Turk Blvd 1 Front Yard : Yard Tree Private 2   01/12/2009 12:00:00 AM   On campus Permit Number 51996 5995208 2110277 37.7741428808777 -122.460040004978 (37.7741428808777, -122.460040004978) 11 6 2 54 11
138623 91110 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2650 Turk Blvd 1 Front Yard : Yard Tree Private 2       On Campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16
191593 91111 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2650 Turk Blvd 2 Front Yard : Yard Tree Private 2       On Campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16
183605 104761 Significant Tree 6 Ilex aquifolium :: European Holly 390 1665 18TH AVE   Front Yard : Yard Tree Private 2     50 9x9   5990543.2 2104073 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248) 1 8 4 56 12
186272 104762 Significant Tree 6 Ilex aquifolium :: European Holly 390 1665 18TH AVE   Front Yard : Yard Tree Private 2     50 9x9   5990543.2 2104073 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248) 1 8 4 56 12
80305 111179 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 400 NORTH POINT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3 9x6   6008572 2121805 37.806555520543 -122.414627380808 (37.806555520543, -122.414627380808) 3 1 10 308 23
4724 262586 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2 Byron Ct 1 Front Yard : Yard Tree Private 2   08/19/2020 12:00:00 AM 3 8x8 Permit Number 781313 5999459.72778 2086749.57445 37.7097858201455 -122.443642066205 (37.7097858201455, -122.443642066205) 9 7 6 28861 5
17604 261710 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 3555 16th St 1 Front Yard : Yard Tree Public Library 12       8x8   6003221.95473 2106496.25325 37.7642195378276 -122.432048304209 (37.7642195378276, -122.432048304209) 15 4 5 28862 3
87462 107036 Significant Tree 6 Tree(s) :: 17 350 08th St   Sidewalk: Property side : Cutout Tree Private 2   07/23/2014 12:00:00 AM   7x7 Permit Number 772214 6009826 2110084 37.7744428576765 -122.409459923405 (37.7744428576765, -122.409459923405) 8 2 9 28853 34
12289 254085 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Lansdale Ave 1 Front Yard : Cutout Tree Private 2       6x6   5995707 2096451 37.7362088759349 -122.457313463895 (37.7362088759349, -122.457313463895) 9 7 4 59 40
21449 255662 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1626 Shrader St 1 Sidewalk: Property side : Yard Tree Private 2       6x6 Permit Number 782137 5998119 2105007 37.759839795982 -122.44959056596 (37.759839795982, -122.44959056596) 15 5 11 29492 12
29379 254551 Significant Tree 6 Cordyline australis :: Dracena Palm 64 1433 Cayuga Ave 1 Front Yard : Cutout Tree Private 2       6x6   5999129 2089595 37.7175798453783 -122.444989533853 (37.7175798453783, -122.444989533853) 9 7 6 28861 25
37092 254109 Significant Tree 6 Tree(s) :: 17 38X Starview Way 1 Sidewalk: Property side : Yard Tree Private 2   02/06/2018 12:00:00 AM 3 6x6 Permit Number 781050 5997469 2101545 37.7502968010125 -122.451588863361 (37.7502968010125, -122.451588863361) 1 5 4 63 38
63888 254137 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1619 47th Ave 1 Side Yard : Yard Tree Private 2       6x6   5981543 2104041 37.756225206981 -122.506846181577 (37.756225206981, -122.506846181577) 1 8 3 56 35
75557 254361 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1749 09th Ave 1 Front Yard : Yard Tree Private 2       6x6   5993372 2103579 37.7556461665355 -122.465904219148 (37.7556461665355, -122.465904219148) 1 8 4 56 12
85388 255663 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1626 Shrader St 2 Sidewalk: Property side : Yard Tree Private 2       6x6 Permit Number 782137 5998119 2105007 37.759839795982 -122.44959056596 (37.759839795982, -122.44959056596) 15 5 11 29492 12

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