trees

183 rows where qLegalStatus_id = 6 and qSiteInfo = "Sidewalk: Property side : Cutout" sorted by qCareAssistant

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

  • Sidewalk: Property side : Cutout · 183 ✖
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)
22 262394 Significant Tree 6 Pinus radiata :: Monterey Pine 15 66 Cleary Ct 1 Sidewalk: Property side : Cutout Tree DPW 1   11/13/2020 12:00:00 AM 3 3x3   6004824 2113713 37.7841256623529 -122.427021325889 (37.7841256623529, -122.427021325889) 13 9 11 28858 41
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
1377 262327 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
1679 262328 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
3188 260646 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3905 Sacramento St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996106 2114850 37.7867507340863 -122.457264569448 (37.7867507340863, -122.457264569448) 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
5928 260423 Significant Tree 6 Juniperus californica :: California juniper 295 237 Glenview Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998907 2100812 37.7483664070673 -122.446563453195 (37.7483664070673, -122.446563453195) 2 5 5 63 38
6364 264920 Significant Tree 6 Tree(s) :: 17 99X Everglade Dr 2 Sidewalk: Property side : Cutout Tree Private 2   11/10/2020 12:00:00 AM 3 6x10 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
6867 260482 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 3333 California St 4 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
7796 264921 Significant Tree 6 Tree(s) :: 17 99X Everglade Dr 3 Sidewalk: Property side : Cutout Tree Private 2   11/10/2020 12:00:00 AM 3 6x10 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
8316 260638 Significant Tree 6 Olea europaea :: Olive Tree 9 3140 25th St 2 Sidewalk: Property side : Cutout Tree Private 2     3 3x3   6008726.17419 2101580.94088 37.7510337250786 -122.412663209658 (37.7510337250786, -122.412663209658) 2 4 7 28859 19
10213 260647 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3905 Sacramento St 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996106 2114850 37.7867507340863 -122.457264569448 (37.7867507340863, -122.457264569448) 11 6 1 54 31
10395 260478 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3333 California St 8 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
11407 260477 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3333 California St 7 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
12545 260484 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 3333 California St 6 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
14136 112391 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 2201X LYON ST 2 Sidewalk: Property side : Cutout Tree Private 2       3x12   5999307 2116423 37.7912531030346 -122.446303107227 (37.7912531030346, -122.446303107227) 13 6 1 29490 31
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
14780 262330 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 4 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
14823 260479 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 3333 California St 1 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
15160 260680 Significant Tree 6 Tree(s) :: 17 1450x Laguna St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6004617 2113883 37.7845807327875 -122.42774958855 (37.7845807327875, -122.42774958855) 13 9 11 28858 41
15393 260480 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 3333 California St 2 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
16021 260481 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 3333 California St 3 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
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
17264 260645 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 3905 Sacramento St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996106 2114850 37.7867507340863 -122.457264569448 (37.7867507340863, -122.457264569448) 11 6 1 54 31
17369 260483 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 3333 California St 5 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
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
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
17902 113640 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 545X Minna St 1 Sidewalk: Property side : Cutout Tree Private 2           6010081.18772 2112137.85468 37.7800965567953 -122.408722101319 (37.7800965567953, -122.408722101319) 14 2 9 28853 34
18276 119614 Significant Tree 6 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 2X Sutter St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6012582 2115890 37.7905388243453 -122.400334219916 (37.7905388243453, -122.400334219916) 4 1 10 28854 6
18601 262329 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 3 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
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
22296 113639 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1X Russ St 3 Sidewalk: Property side : Cutout Tree Private 2           6009949.39418 2111947.85897 37.7795674908256 -122.409164626268 (37.7795674908256, -122.409164626268) 14 2 9 28853 34
22688 120924 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 7 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
27222 258201 Significant Tree 6 Populus spp :: Poplar Spp 262 598X Alemany Blvd 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006099.613365 2094764.868461 37.732170557365 -122.421262171784 (37.732170557365, -122.421262171784) 2 7 7 28861 2
31720 254395 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1286 26th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 781556 5988061 2106558 37.7635178832746 -122.484489596097 (37.7635178832746, -122.484489596097) 1 8 3 56 35
33311 258200 Significant Tree 6 Populus spp :: Poplar Spp 262 598X Alemany Blvd 4 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006099.613365 2094764.868461 37.732170557365 -122.421262171784 (37.732170557365, -122.421262171784) 2 7 7 28861 2
34238 1283 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 3995X Alemany Blvd 1 Sidewalk: Property side : Cutout Tree Private 2     10 10x10   5992081.50866 2087171.04221 37.7105194967412 -122.469172961285 (37.7105194967412, -122.469172961285) 9 8 4 64 24
37483 85089 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1600 Chestnut St 2 Sidewalk: Property side : Cutout Tree Private 2           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303) 13 9 1 57 17
39767 254934 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 755 Ocean Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x6   5998003.33154 2091542.89024 37.7228639895457 -122.449020681299 (37.7228639895457, -122.449020681299) 9 7 4 28861 24
41224 258232 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 1 Sidewalk: Property side : Cutout Tree Private 2   04/24/2019 12:00:00 AM 3 3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
41328 121446 Significant Tree 6 Tree(s) :: 17 500 Terry A Francois Blvd 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6016102 2110410 37.775687633053 -122.387772601034 (37.775687633053, -122.387772601034) 14 3 9 310 20
43239 258527 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 50 Hermann St 3 Sidewalk: Property side : Cutout Tree Private 2           6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
45541 92053 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1001 Potrero Ave   Sidewalk: Property side : Cutout Tree Private 2         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
45774 114249 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 499x 24TH AVE 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5988415 2112957 37.7811083698872 -122.483734439284 (37.7811083698872, -122.483734439284) 11 6 2 55 26
47402 120930 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 13 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
47483 113358 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 702 Foerster St 1 Sidewalk: Property side : Cutout Tree Private 2           5998153.40008835 2095558.62470631 37.7338988325043 -122.448791034412 (37.7338988325043, -122.448791034412) 9 7 4 59 40
48765 98082 Significant Tree 6 Pinus Spp :: Pine Spp 100 525 Grafton Ave 1 Sidewalk: Property side : Cutout Tree Private 2           5995193.7 2090526.9 37.7199132334677 -122.45865940878 (37.7199132334677, -122.45865940878) 9 8 6 28861 24
50301 254481 Significant Tree 6 Juniperus chinensis :: Juniper 113 1274 11th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5992738 2106820 37.7645085090972 -122.468332545675 (37.7645085090972, -122.468332545675) 11 8 11 56 12
50856 1263 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 3 Sidewalk: Property side : Cutout Tree Private 2   12/02/1998 12:00:00 AM 10 3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
51080 120925 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 8 Sidewalk: Property side : Cutout Tree Private 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
52899 173663 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 3878 17th St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6003109 2105964 37.7627516946294 -122.432400964417 (37.7627516946294, -122.432400964417) 15 4 5 28862 3
53621 258239 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 8 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
54776 109969 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 1x DAVIS ST 1 Sidewalk: Property side : Cutout Tree Private 2   08/28/2015 12:00:00 AM 18 3x3 Permit Number 774526 6013431.7 2116562.3 37.7924321476874 -122.397441457592 (37.7924321476874, -122.397441457592) 4 2 10 28860 6
56399 254401 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 755 Ocean Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 779678 5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
56668 113769 Significant Tree 6 Tree(s) :: 17 2550 Broadway 1 Sidewalk: Property side : Cutout Tree Private 2           6001418.65940389 2117313.19689891 37.7938177263924 -122.439060665499 (37.7938177263924, -122.439060665499) 13 9 1 57 27
60038 258526 Significant Tree 6 Pinus radiata :: Monterey Pine 15 50 Hermann St 2 Sidewalk: Property side : Cutout Tree Private 2           6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
60656 120926 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 9 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
61291 113491 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 366x 07TH AVE 1 Sidewalk: Property side : Cutout Tree Private 2   12/07/2015 12:00:00 AM 6 3x3 Permit Number 776681 5993712 2113143 37.7819259902039 -122.465423128165 (37.7819259902039, -122.465423128165) 11 6 2 54 11
67165 258067 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 833 York St 1 Sidewalk: Property side : Cutout Tree Private 2       2x3 Permit Number 782335 6009933.30187 2104364.32189 37.758743943813 -122.408685158341 (37.758743943813, -122.408685158341) 2 4 7 28859 19
67239 251216 Significant Tree 6 Myoporum laetum :: Myoporum 62 399X Townsend St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6013957 2110872 37.776837125863 -122.395225113019 (37.776837125863, -122.395225113019) 6 2 9 28856 20
67916 258235 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 4 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
69574 1284 Significant Tree 6 Acer buergeranum :: Trident Maple 110 3995X Alemany Blvd 2 Sidewalk: Property side : Cutout Tree Private 2     12 3X10 Permit Number 778829 5992111.48083 2087185.84409 37.7105618710011 -122.469070448459 (37.7105618710011, -122.469070448459) 9 8 4 64 24
71526 258236 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
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
73343 122634 Significant Tree 6 Tree(s) :: 17 3680X 19th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   12/05/2016 12:00:00 AM 3 3x10 Permit Number 779220 5990592 2091224 37.7215617409212 -122.474616575991 (37.7215617409212, -122.474616575991) 9 8 4 64 40
73609 252836 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 98 Prosper St 4 Sidewalk: Property side : Cutout Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
73917 120923 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 6 Sidewalk: Property side : Cutout Tree Private 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
74277 251372 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1526 Masonic Ave 1 Sidewalk: Property side : Cutout Tree Private 2   11/01/2017 12:00:00 AM 3 3x3 Permit Number 779800 5999767 2107205 37.7659690994291 -122.444048894864 (37.7659690994291, -122.444048894864) 15 5 5 29492 9
78486 94301 Significant Tree 6 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1150X Fillmore St 5 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
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
81897 120931 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 14 Sidewalk: Property side : Cutout Tree Private 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
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
92540 113772 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2550 Broadway 4 Sidewalk: Property side : Cutout Tree Private 2     4     6001375.31674 2117310.7972 37.7938086711861 -122.439210462719 (37.7938086711861, -122.439210462719) 13 9 1 57 27
92919 115827 Significant Tree 6 Myoporum laetum :: Myoporum 62 60X CHUMASERO DR 1 Sidewalk: Property side : Cutout Tree Private 2   08/30/2016 12:00:00 AM 3 3x3 Permit Number 777531 5990913 2088468 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941) 1 8 4 64 14
93094 106927 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 4150 24th St   Sidewalk: Property side : Cutout Tree Private 2       1.5X1.5 Permit Number 772519 6002207.56819 2101805.30097 37.7512817512061 -122.435221219626 (37.7512817512061, -122.435221219626) 2 4 5 28862 22
94421 120922 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 5 Sidewalk: Property side : Cutout Tree Private 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
95081 112874 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2636 Vallejo St 1 Sidewalk: Property side : Cutout Tree Private 2   08/25/2015 12:00:00 AM 13 3x3 Permit Number 776037 6000935.48392 2117605.97258 37.7945941075731 -122.440753504176 (37.7945941075731, -122.440753504176) 13 9 1 57 27
98424 94303 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 6 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
101055 119613 Significant Tree 6 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 2X Sutter St 1 Sidewalk: Property side : Cutout Tree Private 2     12 3x3   6012582 2115890 37.7905388243453 -122.400334219916 (37.7905388243453, -122.400334219916) 4 1 10 28854 6
101827 173631 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 99X Everglade Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5986361 2095495 37.7330427310611 -122.489555709533 (37.7330427310611, -122.489555709533) 1 8 4 64 35
103863 251217 Significant Tree 6 Myoporum laetum :: Myoporum 62 399X Townsend St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6013957 2110872 37.776837125863 -122.395225113019 (37.776837125863, -122.395225113019) 6 2 9 28856 20
103945 258237 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 6 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
105107 85090 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1600 Chestnut St 3 Sidewalk: Property side : Cutout Tree Private 2           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303) 13 9 1 57 17
106382 116072 Significant Tree 6 Juniperus chinensis :: Juniper 113 388 POLARIS WAY 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6000586 2086414 37.7089285790833 -122.439725431133 (37.7089285790833, -122.439725431133) 9 7 6 28861 5
109250 107818 Significant Tree 6 Ficus Spp. :: 101 474 Oak St 1 Sidewalk: Property side : Cutout Tree Private 2       3X3   6004715.2 2110227.8 37.7745500089947 -122.427149405032 (37.7745500089947, -122.427149405032) 7 9 11 28852 10
109715 120932 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 15 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
110239 94295 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 2 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
110581 113359 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 702 Foerster St 2 Sidewalk: Property side : Cutout Tree Private 2           5998153.40008835 2095558.62470631 37.7338988325043 -122.448791034412 (37.7338988325043, -122.448791034412) 9 7 4 59 40
113295 113637 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1X Russ St 1 Sidewalk: Property side : Cutout Tree Private 2           6009949.39418 2111947.85897 37.7795674908256 -122.409164626268 (37.7795674908256, -122.409164626268) 14 2 9 28853 34
115499 113638 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1X Russ St 2 Sidewalk: Property side : Cutout Tree Private 2           6009949.39418 2111947.85897 37.7795674908256 -122.409164626268 (37.7795674908256, -122.409164626268) 14 2 9 28853 34
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
118707 94293 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 1 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
119547 107080 Significant Tree 6 Magnolia x soulangiana :: Saucer Magnolia 147 401X TOWNSEND ST 8 Sidewalk: Property side : Cutout Tree Private 2     14 2x30   6013045 2110022 37.774452457479 -122.398320364295 (37.774452457479, -122.398320364295) 14 2 9 28856 20
120900 258240 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 9 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
122238 254735 Significant Tree 6 Afrocarpus gracilior :: Fern Pine 89 363 14th Ave 1 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 781538 5991507 2112990 37.781378479082 -122.473040175374 (37.781378479082, -122.473040175374) 11 6 2 54 26
124817 120927 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 10 Sidewalk: Property side : Cutout Tree Private 2       3X3 Permit Number 778829 5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
125310 94299 Significant Tree 6 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1150X Fillmore St 4 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
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
127144 258338 Significant Tree 6 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 209 Spear St 1 Sidewalk: Property side : Cutout Tree Private 2                              
128000 104003 Significant Tree 6 Acer palmatum 'Sango Kaku' :: Coral Bark Maple 550 2109 Steiner St 1 Sidewalk: Property side : Cutout Tree Private 2   07/17/2013 12:00:00 AM     Permit Number 767176 6002333.5 2115633.4 37.7892574480846 -122.435774995524 (37.7892574480846, -122.435774995524) 13 6 1 29490 27

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