trees

416 rows where Police Districts = 8 and qLegalStatus_id = 6 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
194499 265142 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 75X Cedro Ave 1 Back Yard : Cutout Tree Private 2       3x3   5992440 2092965 37.7264490050903 -122.468355192232 (37.7264490050903, -122.468355192232) 9 8 4 59 40
194467 265133 Significant Tree 6 Cordyline australis :: Dracena Palm 64 2166 41st Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/11/2021 12:00:00 AM 3 3x3 Permit Number 783123 5983589.67085 2100408.11005 37.7463706120083 -122.499499736486 (37.7463706120083, -122.499499736486) 1 8 3 29491 35
194374 265048 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 959 Kirkham St 1 Front Yard : Yard Tree Private 2       20x20   5991956 2105209 37.7600399316741 -122.470919881603 (37.7600399316741, -122.470919881603) 1 8 4 56 12
194359 262298 Significant Tree 6 Tree(s) :: 17 1000X Mandalay Ln 1 Side Yard : Yard Tree Private 2   12/17/2020 12:00:00 AM 3 10x10 Permit Number 787936 5991616 2101838 37.7507643799851 -122.471850083311 (37.7507643799851, -122.471850083311) 1 8 4 29491 12
194291 264997 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 909 Shields St 1 Sidewalk: Property side : Cutout Tree Private 2       3x9   5991621 2089826 37.7177827456648 -122.470957844969 (37.7177827456648, -122.470957844969) 9 8 6 64 24
194270 264977 Significant Tree 6 Tree(s) :: 17 188 Yerba Buena Ave 1 Front Yard : Yard Tree Private 2   12/02/2020 12:00:00 AM 3 3x3 Permit Number 787864 5994639 2096200 37.7354582929988 -122.460987765625 (37.7354582929988, -122.460987765625) 9 8 4 59 40
193868 115735 Significant Tree 6 Acer rubrum :: Red Maple 75 57 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776554 5993777.6 2097002.8 37.7376129769989 -122.464024183823 (37.7376129769989, -122.464024183823) 1 8 4 59 40
193743 211099 Significant Tree 6 Tree(s) :: 17 501 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2   05/18/2018 12:00:00 AM 3 10x10 Permit Number 781418 5993137.63738 2096084.35497 37.7350542531473 -122.466170096172 (37.7350542531473, -122.466170096172) 1 8 4 59 40
192391 253097 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1290 Portola Dr 1 Sidewalk: Property side : Yard Tree Private 2 DPW 08/22/2017 12:00:00 AM 3 3x3   5994035 2097938 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736) 1 8 4 59 40
188942 104888 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 146 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
188800 106107 Significant Tree 6 Magnolia champaca :: Champa 141 135 MENDOSA AVE 1 Sidewalk: Property side : Yard Tree Private 2   04/23/2014 12:00:00 AM     Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235) 1 8 4 29491 40
188643 122687 Significant Tree 6 Tree(s) :: 17 1462 Funston Ave 1 Front Yard : Cutout Tree Private 2   01/04/2017 12:00:00 AM 3 3x8 Permit Number 779171 5992142.99696903 2105491.66018597 37.7608268551195 -122.470293739312 (37.7608268551195, -122.470293739312) 1 8 4 56 12
188463 115734 Significant Tree 6 Acer rubrum :: Red Maple 75 55 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 776555 5993732.7 2097034 37.7376960566374 -122.464181687663 (37.7376960566374, -122.464181687663) 1 8 4 59 40
188246 115749 Significant Tree 6 Eucalyptus camaldulensis :: River Red Gum 342 100 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769) 9 8 4 59 40
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
187809 99099 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 65X Santa Monica Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2012 12:00:00 AM     Permit Number 768467 5993743.4 2097365.9 37.7386079879791 -122.464168780849 (37.7386079879791, -122.464168780849) 1 8 4 59 40
187309 106198 Significant Tree 6 Juniperus scopulorum 'Pat :: Juniper Tree 'Pathfinder' 570 2101 42ND AVE 1 Front Yard : Yard Tree Private 2     18     5983206.1 2100796.8 37.7474153345648 -122.500854798087 (37.7474153345648, -122.500854798087) 1 8 3 29491 35
187303 118359 Significant Tree 6 Pinus radiata :: Monterey Pine 15 8 Keystone Way 1 Front Yard : Yard Tree Private 2     20 3x3   5994105 2092664 37.7257185609933 -122.46257757783 (37.7257185609933, -122.46257757783) 9 8 4 59 40
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
185977 114238 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 14 Sidewalk: Curb side : Yard Tree Private 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
185127 116345 Significant Tree 6 Tree(s) :: 17 85x SANTA CLARA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2016 12:00:00 AM 3 3x3 Permit Number 777165 5993361 2096925 37.7373753392635 -122.465458906558 (37.7373753392635, -122.465458906558) 1 8 4 59 40
185053 99826 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Cascade Walk 1 Front Yard : Yard Tree Private 2           5992183.1 2103187.3 37.7545020044945 -122.469987253468 (37.7545020044945, -122.469987253468) 1 8 4 56 12
184580 114393 Significant Tree 6 Ficus Spp. :: 101 118x TAPIA DR 1 Front Yard : Yard Tree Private 2     36     5988638 2090878 37.7204982977387 -122.481345621141 (37.7204982977387, -122.481345621141) 1 8 4 64 14
183804 121087 Significant Tree 6 Myoporum laetum :: Myoporum 62 1443 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778784 5981521.32072 2105258.5458 37.7595669638281 -122.507011468719 (37.7595669638281, -122.507011468719) 1 8 3 56 35
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
183573 104808 Significant Tree 6 Ilex aquifolium :: European Holly 390 1665 08th Ave   Front Yard : Yard Tree Private 2     40     5993673.5 2104163.7 37.7572689897716 -122.464904006701 (37.7572689897716, -122.464904006701) 1 8 4 56 12
182457 115738 Significant Tree 6 Acer rubrum :: Red Maple 75 95x Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776553 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
181784 106310 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 4 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
181383 104933 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 755 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990427 2090598 37.7198333383806 -122.475141254145 (37.7198333383806, -122.475141254145) 1 8 4 64 40
181284 114154 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1200x JUNIPERO SERRA BLVD 13 Front Yard : Yard Tree Private 2     20     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
180735 114146 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 1200x JUNIPERO SERRA BLVD 3 Front Yard : Yard Tree Private 2     12     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
180538 116957 Significant Tree 6 Eucalyptus camaldulensis :: River Red Gum 342 10x Yerba Buena Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
179418 114233 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 9 Sidewalk: Curb side : Yard Tree Private 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
179237 115750 Significant Tree 6 Eucalyptus camaldulensis :: River Red Gum 342 100 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769) 9 8 4 59 40
179132 115753 Significant Tree 6 Acer rubrum :: Red Maple 75 135x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776552 5994185.89401 2096656.23912 37.7366849291808 -122.46258739592 (37.7366849291808, -122.46258739592) 9 8 4 59 40
178381 254173 Significant Tree 6 Geijera parviflora :: Australian Willow 25 1850 19th Ave 1 Front Yard : Yard Tree Private 2       3x6   5990394 2102783 37.7532883185876 -122.476144836826 (37.7532883185876, -122.476144836826) 1 8 4 56 12
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
177784 114257 Significant Tree 6 Leptospermum quinquenervia :: Tea Tree 470 50x CHUMASERO DR 1 Front Yard : Yard Tree Private 2           5990913 2088468 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941) 1 8 4 64 14
177311 115751 Significant Tree 6 Acer rubrum :: Red Maple 75 100 Yerba Buena Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/10/2016 12:00:00 AM 3   Permit Number 776558 5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769) 9 8 4 59 40
176886 117253 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2500x 34TH AVE 3 Side Yard : Yard Tree SFUSD 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
176646 72854 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 24 Lunado Way 4 Sidewalk: Curb side : Cutout Tree Private 2   09/26/1998 12:00:00 AM       5991516.52955398 2091408.89207172 37.7221229357531 -122.471434223035 (37.7221229357531, -122.471434223035) 9 8 4 59 40
175794 114405 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 500X ARBALLO DR 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
173894 114104 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 400x ARBALLO DR 1 Front Yard : Yard Tree Private 2     12 3x3   5988116 2090625 37.7197732605649 -122.48313145165 (37.7197732605649, -122.48313145165) 1 8 4 64 14
173820 104912 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 606 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
173819 104916 Significant Tree 6 Pinus radiata :: Monterey Pine 15 700 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
173544 114236 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 12 Sidewalk: Curb side : Yard Tree Private 2     22     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
173122 112354 Significant Tree 6 Tree(s) :: 17 300 Moncada Way 1 Front Yard : Yard Tree Private 2   01/04/2016 12:00:00 AM   10x10 Permit Number 775546 5992209.2 2093928.1 37.729080105492 -122.469223117768 (37.729080105492, -122.469223117768) 9 8 4 59 40
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
172353 99662 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1337 Portola Dr 1 Front Yard : Yard Tree Private 2           5993559.3 2097744.3 37.7396363671104 -122.464832777968 (37.7396363671104, -122.464832777968) 1 8 4 59 40
171749 253384 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 55 Cerritos Ave 1 Front Yard : Yard Tree Private 2       10x10   5992588 2092941 37.7263916542788 -122.46784182224 (37.7263916542788, -122.46784182224) 9 8 4 59 40
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
170438 96480 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
169388 104432 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 1601X PORTOLA DR 1 Front Yard : Yard Tree Private 2     14     5991823 2096240 37.7354056792703 -122.47072655808 (37.7354056792703, -122.47072655808) 1 8 4 59 40
168382 255283 Significant Tree 6 Olea europaea :: Olive Tree 9 320 Magellan Ave 4 Front Yard : Yard Tree Private 2   05/01/2018 12:00:00 AM 3 10x20 Permit Number 781012 5994287.14264 2099988.88368 37.7458413694018 -122.462478996433 (37.7458413694018, -122.462478996433) 1 8 4 29491 40
165218 114145 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 1200x JUNIPERO SERRA BLVD 2 Front Yard : Yard Tree Private 2     6     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
165013 85367 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1990 09th Ave 1 Front Yard : Cutout Tree Private 2   08/17/2007 12:00:00 AM     Permit Number 49643 5993523.3 2101996.8 37.7513105791605 -122.465266058842 (37.7513105791605, -122.465266058842) 1 8 4 29491 12
164851 103422 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1365 Portola Dr 1 Front Yard : Yard Tree Private 2         Permit Number 769779 5993416.2 2097683.7 37.7394617231066 -122.465323151466 (37.7394617231066, -122.465323151466) 1 8 4 59 40
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
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
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
162024 122639 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630X 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x8   5990614 2091411 37.7220764711857 -122.47455416919 (37.7220764711857, -122.47455416919) 9 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
161250 114073 Significant Tree 6 Betula pendula :: European White Birch 253 18x HIGUERA AVE 1 Sidewalk: Curb side : Yard Tree Private 2     6     5988029 2090212 37.7186342037977 -122.483401916227 (37.7186342037977, -122.483401916227) 1 8 4 64 14
160994 253716 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2959 21st Ave 2 Sidewalk: Property side : Yard Tree Private 2       5x15   5989962 2095532 37.7333538971055 -122.477108940264 (37.7333538971055, -122.477108940264) 1 8 4 64 35
160882 113234 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2023 43RD AVE 1 Front Yard : Yard Tree Private 2     12 3x3   5982877 2101339 37.7488847374588 -122.502032899239 (37.7488847374588, -122.502032899239) 1 8 3 29491 35
160583 104899 Significant Tree 6 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 314 Gonzalez Dr 2 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
159746 253286 Significant Tree 6 Tree(s) :: 17 40 Mendosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2017 12:00:00 AM 3 6x10 Permit Number 780599 5993445 2101187 37.7490825597194 -122.465478005037 (37.7490825597194, -122.465478005037) 1 8 4 29491 40
159155 104908 Significant Tree 6 Myoporum laetum :: Myoporum 62 500 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
157181 101138 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1290 Portola Dr 1 Front Yard : Yard Tree Private 2           5994035.6 2097938.3 37.7401964926879 -122.463200022957 (37.7401964926879, -122.463200022957) 1 8 4 59 40
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
156777 114101 Significant Tree 6 Betula pendula :: European White Birch 253 21x ACEVEDO AVE 2 Front Yard : Yard Tree Private 2     7     5988027 2090598 37.7196939458216 -122.48343711114 (37.7196939458216, -122.48343711114) 1 8 4 64 14
156684 105850 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 44 MENDOSA AVE 1 Sidewalk: Property side : Yard Tree Private 2     100 6x15   5993395.1 2101192.7 37.7490953323683 -122.465650972372 (37.7490953323683, -122.465650972372) 1 8 4 29491 40
156060 253715 Significant Tree 6 Pseudotsuga menziesii :: Douglas Fir 285 2959 21st Ave 1 Sidewalk: Property side : Yard Tree Private 2       5x15 Permit Number 780322 5989962 2095532 37.7333538971055 -122.477108940264 (37.7333538971055, -122.477108940264) 1 8 4 64 35
155948 102478 Significant Tree 6 Afrocarpus gracilior :: Fern Pine 89 760 Victoria St 4 Front Yard : Yard Tree Private 2           5993664.7 2092172.3 37.7243431058269 -122.464063971167 (37.7243431058269, -122.464063971167) 9 8 4 59 40
155480 116958 Significant Tree 6 Acer rubrum :: Red Maple 75 10x Yerba Buena Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   05/10/2016 12:00:00 AM 3   Permit Number 777762 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
154838 102479 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 760 Victoria St 5 Front Yard : Yard Tree Private 2           5993664.7 2092172.3 37.7243431058269 -122.464063971167 (37.7243431058269, -122.464063971167) 9 8 4 59 40
154745 114237 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 13 Sidewalk: Curb side : Yard Tree Private 2     14     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
154657 100850 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 Estero Ave 1 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
152541 114384 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 418X SERRANO DR 2 Front Yard : Yard Tree Private 2     6     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
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
150390 99101 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 55x Santa Monica Way 1 Median : Yard Tree Private 2   04/07/2012 12:00:00 AM     Permit Number 768464 5993693.6 2097654.3 37.7393969918941 -122.464361897304 (37.7393969918941, -122.464361897304) 1 8 4 59 40
149763 112290 Significant Tree 6 Acer rubrum :: Red Maple 75 34 YERBA BUENA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3 3x3 Permit Number 776546 5993584 2097045 37.7377176881769 -122.464696609393 (37.7377176881769, -122.464696609393) 1 8 4 59 40
149040 114068 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 8 HIGUERA AVE 1 Front Yard : Yard Tree Private 2     20     5987898 2090420 37.7191976939958 -122.48386996767 (37.7191976939958, -122.48386996767) 1 8 4 64 14
149016 114404 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 500X ARBALLO DR 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
147278 100431 Significant Tree 6 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 200X Stonecrest Dr 1 Front Yard : Yard Tree Private 2           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
146533 104435 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1601X PORTOLA DR 4 Front Yard : Yard Tree Private 2     16     5991823 2096240 37.7354056792703 -122.47072655808 (37.7354056792703, -122.47072655808) 1 8 4 59 40
146154 99098 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 66 Santa Monica Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2012 12:00:00 AM     Permit Number 768466 5993736.6 2097303.5 37.7384362612216 -122.464187762983 (37.7384362612216, -122.464187762983) 1 8 4 59 40
145907 187657 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2072 15th Ave 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5991666 2101424 37.7496305363998 -122.47164701446 (37.7496305363998, -122.47164701446) 1 8 4 29491 12
145813 173616 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1200X JUNIPERO SERRA BLVD 15 Front Yard : Yard Tree Private 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
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
144728 253098 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1290 Portola Dr 2 Sidewalk: Property side : Yard Tree DPW 1   08/22/2017 12:00:00 AM 3 3x3   5994035 2097938 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736) 1 8 4 59 40
144483 254258 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
144280 253255 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 270 Castenada Ave 2 Front Yard : Yard Tree Private 2   01/09/2018 12:00:00 AM 3 10x10 Permit Number 780226 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
143694 116535 Significant Tree 6 Tree(s) :: 17 598x MOUNT VERNON AVE 4 Back Yard : Yard Tree Private 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
142152 117309 Significant Tree 6 Tree(s) :: 17 3711 19th Ave 1 Back Yard : Yard Tree Private 2   06/06/2016 12:00:00 AM 3 10x10 Permit Number 777997 5990297.3 2090806 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889) 1 8 4 64 14
142019 104750 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1X Junipero Serra Blvd Off Ramp 2 Front Yard : Yard Tree Private 2   08/30/2016 12:00:00 AM 3   Permit Number 770709 5991326.15861 2088181.65405 37.7132507161795 -122.47185719554 (37.7132507161795, -122.47185719554) 1 8 4 64 14
141906 114383 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 418X SERRANO DR 1 Sidewalk: Curb side : Yard Tree Private 2     6     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
141272 114231 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 7 Sidewalk: Curb side : Yard Tree Private 2     10     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
139664 254256 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
139444 115733 Significant Tree 6 Acer rubrum :: Red Maple 75 50 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776548 5993693.2 2096969 37.7375153061033 -122.464313539267 (37.7375153061033, -122.464313539267) 1 8 4 59 40

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