trees

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

✎ 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)
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
167489 104452 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1045 Mission St 1 Sidewalk: Property side : Cutout Tree Private 2       2x6 Permit Number 770594 6009749.9 2112056.4 37.7798543407434 -122.409862429103 (37.7798543407434, -122.409862429103) 14 2 9 28853 34
173080 105857 Significant Tree 6 Juniperus chinensis :: Juniper 113 1500X Valencia St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006259.2 2100711.5 37.7485076710609 -122.421132539956 (37.7485076710609, -122.421132539956) 2 4 5 28859 19
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
137083 106962 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 218 SADOWA ST 3 Sidewalk: Property side : Cutout Tree Private 2     22     5994814 2087793.9 37.7123872323548 -122.459774032106 (37.7123872323548, -122.459774032106) 9 8 6 28861 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
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
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
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
144153 109970 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 1x DAVIS ST 2 Sidewalk: Property side : Cutout Tree Private 2   08/28/2015 12:00:00 AM   3x3 Permit Number 774526 6013431.7 2116562.3 37.7924321476874 -122.397441457592 (37.7924321476874, -122.397441457592) 4 2 10 28860 6
160307 110393 Significant Tree 6 Juniperus chinensis :: Juniper 113 451 LOS PALMOS DR 1 Sidewalk: Property side : Cutout Tree Private 2       3x8   5997298 2095759 37.7344000615683 -122.451762846846 (37.7344000615683, -122.451762846846) 9 7 4 59 40
168909 112367 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2770 Broadway 1 Sidewalk: Property side : Cutout Tree Private 2   07/23/2015 12:00:00 AM 3 3x3 Permit Number 774944 6000432.43478 2117179.73451 37.7933951089516 -122.442463497617 (37.7933951089516, -122.442463497617) 13 9 1 57 27
189234 112390 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 2201X LYON ST 1 Sidewalk: Property side : Cutout Tree Private 2       3x12   5999307 2116423 37.7912531030346 -122.446303107227 (37.7912531030346, -122.446303107227) 13 6 1 29490 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
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
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
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
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
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
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
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
174218 113641 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 545X Minna St 2 Sidewalk: Property side : Cutout Tree Private 2           6010081.18772 2112137.85468 37.7800965567953 -122.408722101319 (37.7800965567953, -122.408722101319) 14 2 9 28853 34
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
172310 113770 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2550 Broadway 2 Sidewalk: Property side : Cutout Tree Private 2     5     6001403.30227 2117311.89486 37.7938132775122 -122.439113709125 (37.7938132775122, -122.439113709125) 13 9 1 57 27
128387 113771 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2550 Broadway 3 Sidewalk: Property side : Cutout Tree Private 2     5     6001386.1067 2117311.2447 37.7938105138862 -122.439173160634 (37.7938105138862, -122.439173160634) 13 9 1 57 27
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
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
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
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
20043 116577 Significant Tree 6 Shrub :: Shrub 66 3000x 19TH AVE 1 Sidewalk: Property side : Cutout Tree MTA 3 DPW   30 3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
135904 116578 Significant Tree 6 Myoporum laetum :: Myoporum 62 2699x OCEAN AVE 1 Sidewalk: Property side : Cutout Tree MTA 3 DPW   11 3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
6915 116579 Significant Tree 6 Shrub :: Shrub 66 3000x 19TH AVE 2 Sidewalk: Property side : Cutout Tree MTA 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
161563 116580 Significant Tree 6 Shrub :: Shrub 66 3000x 19TH AVE 3 Sidewalk: Property side : Cutout Landscaping MTA 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
149078 117438 Significant Tree 6 Juniperus chinensis :: Juniper 113 230 AMBER DR 1 Sidewalk: Property side : Cutout Tree Private 2     25 3X3   5999593 2099199 37.7439766577846 -122.444075405191 (37.7439766577846, -122.444075405191) 2 7 5 63 22
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
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
162461 120921 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 4 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
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
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
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
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
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
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
171046 120928 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 11 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
156900 120929 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 12 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
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
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
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
136239 120933 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 16 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
145282 120934 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 17 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
178015 120935 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3995X Alemany Blvd 18 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
162123 120936 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 19 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
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
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
151110 122636 Significant Tree 6 Juniperus chinensis :: Juniper 113 3698X 19th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5990586 2091171 37.7214158684235 -122.474633449984 (37.7214158684235, -122.474633449984) 9 8 4 64 40
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
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
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
172960 173598 Significant Tree 6 Casuarina cunninghamiana :: Horsetail pine 112 1771 11th Ave 1 Sidewalk: Property side : Cutout Tree Private 2     12 3x3   5992768 2103420 37.7551747322674 -122.467981458634 (37.7551747322674, -122.467981458634) 1 8 4 56 12
188169 173629 Significant Tree 6 Tibochina urvilleana :: Princess Flower 154 10X Junipero Serra Blvd Off Ramp 1 Sidewalk: Property side : Cutout Tree Private 2   01/20/2017 12:00:00 AM 3 3x3 Permit Number 779383 5991168 2088425 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074) 1 8 4 64 14
136506 173630 Significant Tree 6 Myoporum laetum :: Myoporum 62 2699x OCEAN AVE 2 Sidewalk: Property side : Cutout Tree MTA 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
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
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
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
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
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
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
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
164291 253651 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 131 Font Blvd 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5990844 2088883 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248) 1 8 4 64 14
135306 253899 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 380 Monterey Blvd 1 Sidewalk: Property side : Cutout Tree Private 2       6x10 Permit Number 780835 5999528 2094735 37.7317158633652 -122.443979483467 (37.7317158633652, -122.443979483467) 9 7 4 63 40
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
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
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
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
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
168489 254935 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 755 Ocean Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x6 Permit Number 779678 5998003.33154 2091542.89024 37.7228639895457 -122.449020681299 (37.7228639895457, -122.449020681299) 9 7 4 28861 24
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
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
133327 255538 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 700x Folsom St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6012646 2113072 37.7828048233647 -122.399914812284 (37.7828048233647, -122.399914812284) 6 2 9 28856 34
185174 255539 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 700x Folsom St 17 Sidewalk: Property side : Cutout Tree Private 2       3x3   6012646 2113072 37.7828048233647 -122.399914812284 (37.7828048233647, -122.399914812284) 6 2 9 28856 34
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
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
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
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
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
163996 258199 Significant Tree 6 Populus spp :: Poplar Spp 262 598X Alemany Blvd 3 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
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
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
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
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
155172 258233 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
138832 258234 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
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
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
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
160060 258238 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 7 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
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
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
127144 258338 Significant Tree 6 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 209 Spear St 1 Sidewalk: Property side : Cutout Tree Private 2                              

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