trees

458 rows where Supervisor Districts = 4 and qLegalStatus_id = 6 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor 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)
2352 101748 Significant Tree 6 Pinus radiata :: Monterey Pine 15 700X Panorama Dr 1 Back Yard : Yard Tree Private 2           5997177.2 2102739.1 37.7535587877907 -122.452684092588 (37.7535587877907, -122.452684092588) 1 5 4 63 38
3096 100121 Significant Tree 6 Myoporum laetum :: Myoporum 62 690 Miramar Ave 1 Front Yard : Yard Tree Private 2           5995444.4 2093941.6 37.7293035878447 -122.458039824042 (37.7293035878447, -122.458039824042) 9 7 4 28861 40
7373 96567 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet 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
8007 261753 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 127 Edgehill Way 3 Back Yard : Cutout Tree Private 2   02/25/2020 12:00:00 AM 3     5994849.50332 2098967.43632 37.7430690988325 -122.46046044555 (37.7430690988325, -122.46046044555) 1 8 4 59 40
9206 114067 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 6 Higuera Ave 1 Front Yard : Cutout Tree Private 2     20     5987898 2090420 37.7191976939958 -122.48386996767 (37.7191976939958, -122.48386996767) 1 8 4 64 14
9997 104935 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 835 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
10661 114250 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 131 FONT BLVD 1 Front Yard : Yard Tree Private 2     36     5990844 2088883 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248) 1 8 4 64 14
11628 261752 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 127 Edgehill Way 2 Back Yard : Cutout Tree Private 2   02/25/2020 12:00:00 AM 3     5994849.50332 2098967.43632 37.7430690988325 -122.46046044555 (37.7430690988325, -122.46046044555) 1 8 4 59 40
12287 95982 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 100 Vasquez Ave 1 Back Yard : Yard Tree Private 2           5995122.4 2099706.3 37.7451135296363 -122.459570350972 (37.7451135296363, -122.459570350972) 1 8 4 59 40
12868 111864 Significant Tree 6 Callistemon citrinus :: Lemon Bottlebrush 67 45 Allston Way 1 Front Yard : Yard Tree Private 2   06/26/2015 12:00:00 AM 3   Permit Number 775591 5994228.4 2098418 37.7415247340782 -122.462568190827 (37.7415247340782, -122.462568190827) 1 8 4 59 40
13082 96572 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 = Trees not requiring permit; trees meet 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
13301 114388 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 361x ARBALLO DR 1 Front Yard : Yard Tree Private 2     7     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
15671 104278 Significant Tree 6 Acacia spp :: Acacia Spp 105 2 Allston Way 1 Back Yard : Yard Tree Private 2           5994445.1 2098202.2 37.7409446783355 -122.461803277974 (37.7409446783355, -122.461803277974) 1 8 4 59 40
17429 103965 Significant Tree 6 Tree(s) :: 17 141 Marview Way 1 Front Yard : Yard Tree Private 2   07/11/2013 12:00:00 AM     Permit Number 770303 5998318.6 2103174 37.7548182509721 -122.448768222318 (37.7548182509721, -122.448768222318) 1 5 4 63 38
17949 100194 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 2 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
19112 261751 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 127 Edgehill Way 1 Back Yard : Cutout Tree Private 2   02/25/2020 12:00:00 AM 3     5994849.50332 2098967.43632 37.7430690988325 -122.46046044555 (37.7430690988325, -122.46046044555) 1 8 4 59 40
19388 114226 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 2 Sidewalk: Curb side : Yard Tree Private 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
20037 100423 Significant Tree 6 Leptospermum laevigatum :: Australian Tea Tree 47 155 Winston Dr 1 Front Yard : Yard Tree Private 2           5990788 2093142.6 37.7268410933597 -122.474078979965 (37.7268410933597, -122.474078979965) 9 8 4 64 40
21577 114229 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 5 Sidewalk: Curb side : Yard Tree Private 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
21762 100124 Significant Tree 6 Radermachera sinica :: China Doll Tree 394 40@ San Ramon Eastwood Dr 1 Front Yard : Yard Tree Private 2           5995635 2092781 37.7261278087338 -122.457296979484 (37.7261278087338, -122.457296979484) 9 7 4 28861 40
23065 98547 Significant Tree 6 Pinus radiata :: Monterey Pine 15 555@Rio Teresita Blvd 3 Front Yard : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
23985 114387 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 417x ARBALLO DR 1 Sidewalk: Curb side : Yard Tree Private 2     7     5988152 2090574 37.7196353223366 -122.483003277928 (37.7196353223366, -122.483003277928) 1 8 4 64 14
24927 107413 Significant Tree 6 Pseudotsuga menziesii :: Douglas Fir 285 276 Yerba Buena Ave 1 Front Yard : Yard Tree Private 2     28     5995080.66446 2095640.15746 37.7339465073544 -122.459420244296 (37.7339465073544, -122.459420244296) 9 8 4 59 40
26401 114389 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 345x ARBALLO DR 1 Front Yard : Yard Tree Private 2     8     5988176 2090635 37.7198042094326 -122.48292478788 (37.7198042094326, -122.48292478788) 1 8 4 64 14
27121 114234 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 10 Sidewalk: Curb side : Yard Tree Private 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
27831 98834 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 333 Pacheco St 3 Sidewalk: Curb side : Cutout Tree Private 2           5994230.9 2100817.4 37.748113026994 -122.462733567037 (37.748113026994, -122.462733567037) 1 8 4 29491 40
28176 114157 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200x JUNIPERO SERRA BLVD 18 Front Yard : Yard Tree Private 2     32     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
28198 106364 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 155 BORICA ST 1 Front Yard : Yard Tree Private 2           5992696 2092292.5 37.7246172684066 -122.467421338179 (37.7246172684066, -122.467421338179) 9 8 4 59 40
28871 100193 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 1 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
29607 101467 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 301 Hazelwood Ave 2 Front Yard : Yard Tree Private 2           5996219.7 2095283.8 37.7330334614805 -122.455456526637 (37.7330334614805, -122.455456526637) 9 7 4 59 40
30455 114232 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 8 Sidewalk: Curb side : Yard Tree Private 2     15     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
30556 104909 Significant Tree 6 Pinus radiata :: Monterey Pine 15 533 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
31451 114152 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 11 Front Yard : Yard Tree Private 2     8     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
33433 104433 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1601X PORTOLA DR 2 Front Yard : Yard Tree Private 2     16     5991823 2096240 37.7354056792703 -122.47072655808 (37.7354056792703, -122.47072655808) 1 8 4 59 40
35139 104434 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1601X PORTOLA DR 3 Front Yard : Yard Tree Private 2     13     5991823 2096240 37.7354056792703 -122.47072655808 (37.7354056792703, -122.47072655808) 1 8 4 59 40
35440 97955 Significant Tree 6 Liquidambar styraciflua 'Slender Silhoutte' :: Upright Liquidambar 438 2 Mendosa Ave 1 Front Yard : Yard Tree Private 2   12/05/2011 12:00:00 AM     Permit Number 768165 5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
37139 98289 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Mangels Ave 5 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
38129 114239 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 1300x JUNIPERO SERRA BLVD 1 Sidewalk: Curb side : Yard Tree Private 2     28     5991168 2088425 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074) 1 8 4 64 14
38717 98546 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 555@Rio Teresita Blvd 2 Sidewalk: Property side : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
38864 114149 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 8 Front Yard : Yard Tree Private 2     12     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
39382 114391 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 23x PINTO AVE 2 Front Yard : Yard Tree Private 2     7     5988521 2090808 37.7202992922588 -122.481744923362 (37.7202992922588, -122.481744923362) 1 8 4 64 14
39757 104892 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 201 Gonzalez Dr   Front Yard : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
40036 104493 Significant Tree 6 Acer circinatum :: Vine Maple 452 171 SAN MARCOS AVE 1 Front Yard : Yard Tree Private 2         Permit Number 770388 5993514 2100282 37.7466016393389 -122.465173679454 (37.7466016393389, -122.465173679454) 1 8 4 29491 40
41336 96569 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet 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
41877 114072 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 454 ARBALLO DR 1 Sidewalk: Curb side : Yard Tree Private 2     4     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
42536 97945 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2 Mendosa Ave 1 Front Yard : Yard Tree Private 2         Permit Number 768165 5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
43517 88608 Significant Tree 6 Tree(s) :: 17 350 Urbano Dr 1 Front Yard : Cutout Tree Private 2   08/01/2008 12:00:00 AM     Permit Number 51562 5991996 2092560 37.7253113201117 -122.469860593138 (37.7253113201117, -122.469860593138) 9 8 4 59 40
44052 114240 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 99x FONT BLVD 16 Sidewalk: Curb side : Yard Tree Private 2           5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
44804 114228 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 4 Sidewalk: Curb side : Yard Tree Private 2     7     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
45348 93222 Significant Tree 6 Tree(s) :: 17 85 Santa Rita Ave 2 Front Yard : Yard Tree Private 2   02/26/2010 12:00:00 AM     Permit Number 53213 5993788 2100441 37.7470540096767 -122.464237765204 (37.7470540096767, -122.464237765204) 1 8 4 29491 40
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
50522 93931 Significant Tree 6 Pinus Spp :: Pine Spp 100     Front Yard : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.55284 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841) 1 8 4 64 14
51852 114156 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200x JUNIPERO SERRA BLVD 17 Front Yard : Yard Tree Private 2     32     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
52837 99659 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1325 Portola Dr 3 Front Yard : Yard Tree Private 2           5993615.2 2097760.6 37.7396843456359 -122.464640684629 (37.7396843456359, -122.464640684629) 1 8 4 59 40
54288 115736 Significant Tree 6 Acer rubrum :: Red Maple 75 66 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776551 5993801.4 2096894.7 37.7373175329251 -122.463934052027 (37.7373175329251, -122.463934052027) 1 8 4 59 40
54493 114150 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 9 Front Yard : Yard Tree Private 2     12     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
54868 96570 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 = Trees not requiring permit; trees meet 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
55614 104904 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 417 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
55746 98694 Significant Tree 6 Aesculus californica :: California Buckeye 168 191@Clarendon Forest Knolls Dr 1 Back Yard : Yard Tree Private 2   05/01/2012 12:00:00 AM     Permit Number 768674 5996330.9 2103059.9 37.7543910951738 -122.455633951336 (37.7543910951738, -122.455633951336) 1 5 4 63 12
56298 114392 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 104x TAPIA DR 1 Front Yard : Cutout Tree Private 2     10     5988688 2090939 37.7206686952673 -122.481177253578 (37.7206686952673, -122.481177253578) 1 8 4 64 14
57424 101476 Significant Tree 6 :: 45 541 Congo St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2015 12:00:00 AM 3   Permit Number 775316 6000089 2095440.1 37.7336838892166 -122.442090592963 (37.7336838892166, -122.442090592963) 9 7 4 63 40
57870 96483 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
58321 114094 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 239x VIDAL DR 1 Front Yard : Yard Tree Private 2     24     5987668 2090475 37.7193353179991 -122.484669012602 (37.7193353179991, -122.484669012602) 1 8 4 64 14
59764 105504 Significant Tree 6 Pinus radiata :: Monterey Pine 15 39 MAGELLAN AVE 1 Front Yard : Yard Tree Private 2     18     5994694.1 2101166.3 37.7490976851152 -122.461157135733 (37.7490976851152, -122.461157135733) 1 8 4 29491 40
60308 99100 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 60 Santa Monica Way 1 Sidewalk: Curb side : Cutout Tree Private 2           5993700.7 2097327 37.7384987171226 -122.464313592449 (37.7384987171226, -122.464313592449) 1 8 4 59 40
62078 114235 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 99x FONT BLVD 11 Sidewalk: Curb side : Yard Tree Private 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
62177 99097 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 99X Santa Monica Way 1 Sidewalk: Curb side : Yard Tree Private 2           5994003.8 2097131.6 37.7379796635799 -122.463251452094 (37.7379796635799, -122.463251452094) 9 8 4 59 40
63394 106833 Significant Tree 6 Juniperus chinensis :: Juniper 113 174 STILLINGS AVE 1 Front Yard : Yard Tree Private 2           5999619.6 2095804.2 37.7346568605649 -122.443739589791 (37.7346568605649, -122.443739589791) 9 7 4 63 40
64560 87191 Significant Tree 6 Tree(s) :: 17 640 Miramar Ave 1 Front Yard : Yard Tree Private 2   01/29/2008 12:00:00 AM     Permit Number 50212 5995439 2093622 37.7284257331327 -122.458035371987 (37.7284257331327, -122.458035371987) 9 7 4 28861 40
64792 114144 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 1200x JUNIPERO SERRA BLVD 1 Front Yard : Yard Tree Private 2     10     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
66594 114103 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 5 ACEVEDO AVE 2 Front Yard : Yard Tree Private 2     15     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
67970 93221 Significant Tree 6 Tree(s) :: 17 85 Santa Rita Ave 1 Front Yard : Yard Tree Private 2   02/26/2010 12:00:00 AM     Permit Number 53213 5993788 2100441 37.7470540096767 -122.464237765204 (37.7470540096767, -122.464237765204) 1 8 4 29491 40
69183 104494 Significant Tree 6 Acer circinatum :: Vine Maple 452 171 SAN MARCOS AVE 2 Front Yard : Yard Tree Private 2         Permit Number 770388 5993514 2100282 37.7466016393389 -122.465173679454 (37.7466016393389, -122.465173679454) 1 8 4 29491 40
69364 114151 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 10 Front Yard : Yard Tree Private 2     8     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
71364 115730 Significant Tree 6 Acer rubrum :: Red Maple 75 10x Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776540 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
71845 114379 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 443X ARBALLO DR 1 Front Yard : Yard Tree Private 2     36     5988110 2090275 37.7188118998372 -122.483126550771 (37.7188118998372, -122.483126550771) 1 8 4 64 14
72430 114147 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200x JUNIPERO SERRA BLVD 4 Front Yard : Yard Tree Private 2     7     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
72767 114153 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200x JUNIPERO SERRA BLVD 12 Front Yard : Yard Tree Private 2     40     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
73267 115729 Significant Tree 6 Acer rubrum :: Red Maple 75 10x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 776540 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
74024 114155 Significant Tree 6 Pittosporum spp :: Pittosporum spp 170 1200X JUNIPERO SERRA BLVD 16 Front Yard : Yard Tree Private 2           5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
75453 100529 Significant Tree 6 Tree(s) :: 17 720 Victoria St 1 Front Yard : Yard Tree Private 2   09/24/2012 12:00:00 AM     Permit Number 769203 5993611.6 2091925.6 37.723662667106 -122.464229627127 (37.723662667106, -122.464229627127) 9 8 4 59 40
76029 114099 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 201x VIDAL DR 1 Sidewalk: Curb side : Cutout Tree Private 2     14     5987665 2090646 37.7198046658936 -122.484691919383 (37.7198046658936, -122.484691919383) 1 8 4 64 14
76095 106244 Significant Tree 6 Magnolia spp :: Magnolia 224 735 MANGELS AVE 1 Front Yard : Yard Tree Private 2   06/02/2014 12:00:00 AM 14   Permit Number 772876 5996640.8 2095225.8 37.7328983615352 -122.453996493912 (37.7328983615352, -122.453996493912) 9 7 4 59 40
76411 104900 Significant Tree 6 Betula pendula :: European White Birch 253 317 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
78343 101466 Significant Tree 6 Afrocarpus gracilior :: Fern Pine 89 301 Hazelwood Ave 1 Front Yard : Yard Tree Private 2           5996219.7 2095283.8 37.7330334614805 -122.455456526637 (37.7330334614805, -122.455456526637) 9 7 4 59 40
78664 114390 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 23x PINTO AVE 1 Front Yard : Yard Tree Private 2     7     5988521 2090808 37.7202992922588 -122.481744923362 (37.7202992922588, -122.481744923362) 1 8 4 64 14
80551 100195 Significant Tree 6 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 361 Dellbrook Ave 3 Front Yard : Yard Tree Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
81276 114097 Significant Tree 6 Pinus thunbergii :: Japanese Black Pine 207 221x VIDAL DR 1 Front Yard : Yard Tree Private 2     14     5987664 2090556 37.7195574904968 -122.484688777519 (37.7195574904968, -122.484688777519) 1 8 4 64 14
81747 107245 Significant Tree 6 Tree(s) :: 17 140 CEDRO AVE   Front Yard : Yard Tree Private 2           5991993.7 2093259.3 37.7272312918526 -122.469919436342 (37.7272312918526, -122.469919436342) 9 8 4 59 40
81883 106311 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 5 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
82758 106514 Significant Tree 6 Tree(s) :: 17 190 EUCALYPTUS DR 2 Front Yard : Yard Tree Private 2           5990695.4 2094728.8 37.7311910349726 -122.474514801842 (37.7311910349726, -122.474514801842) 1 8 4 64 40
83163 115737 Significant Tree 6 Acer rubrum :: Red Maple 75 9x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776557 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
84029 102075 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 273 Magellan Ave 5 Front Yard : Yard Tree Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
85195 98151 Significant Tree 6 Pinus radiata :: Monterey Pine 15 850 Rockdale Dr 3 Front Yard : Yard Tree Private 2         Permit Number 768501 5996729.9 2098301.3 37.7413480470066 -122.453910481227 (37.7413480470066, -122.453910481227) 9 7 4 59 40
89599 98156 Significant Tree 6 Pinus radiata :: Monterey Pine 15 149x Chaves Ave 1 Front Yard : Yard Tree Private 2           5996703.5 2098396.7 37.7416084783757 -122.454008650942 (37.7416084783757, -122.454008650942) 9 7 4 59 40
90582 112375 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 801 ULLOA ST 1 Sidewalk: Curb side : Cutout Tree MTA 3     42     5993401 2098089 37.7405736985828 -122.465405140197 (37.7405736985828, -122.465405140197) 1 8 4 59 40
91742 114074 Significant Tree 6 Betula pendula :: European White Birch 253 18x HIGUERA AVE 2 Sidewalk: Curb side : Yard Tree Private 2     5     5988029 2090212 37.7186342037977 -122.483401916227 (37.7186342037977, -122.483401916227) 1 8 4 64 14
91798 173615 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1200X JUNIPERO SERRA BLVD 14 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
92153 117518 Significant Tree 6 Ulmus americana :: American Elm 74 30 Santa Paula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2016 12:00:00 AM 3   Permit Number 777803 5993995.8 2097679.6 37.7394838741894 -122.463318866351 (37.7394838741894, -122.463318866351) 1 8 4 59 40
93552 104749 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1X Junipero Serra Blvd Off Ramp 1 Front Yard : Yard Tree Private 2         Permit Number 770709 5991326.15861 2088181.65405 37.7132507161795 -122.47185719554 (37.7132507161795, -122.47185719554) 1 8 4 64 14

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