trees

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

✎ 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)
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
105498 93932 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
105921 102569 Significant Tree 6 Olea europaea :: Olive Tree 9 0 Diaz Ave 1 Front Yard : Yard Tree Private 2   02/04/2013 12:00:00 AM 2   Permit Number 769785 5990053.95839 2089992.81974 37.7181500356804 -122.476386530439 (37.7181500356804, -122.476386530439) 1 8 4 64 14
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
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
40307 86910 Significant Tree 6 Ilex spp :: Holly Species 81 1 Urbano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49875 5993901 2092133 37.7242488135215 -122.463244271267 (37.7242488135215, -122.463244271267) 9 8 4 59 40
123466 254110 Significant Tree 6 Tree(s) :: 17 100 Cerritos Ave 1 Sidewalk: Curb side : Yard Tree Private 2   05/04/2018 12:00:00 AM 3 10x10 Permit Number 781003 5992103 2092952 37.7263938396388 -122.469519230239 (37.7263938396388, -122.469519230239) 9 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
116051 115752 Significant Tree 6 Acer rubrum :: Red Maple 75 100 Yerba Buena Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/24/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
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
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
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
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
133714 111093 Significant Tree 6 Pinus radiata :: Monterey Pine 15 100x FONT BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2015 12:00:00 AM 50 3x3 Permit Number 775594 5990916 2088996 37.715462969911 -122.473334188491 (37.715462969911, -122.473334188491) 1 8 4 64 14
17188 260389 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 101 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2       10x6   5993303.46118 2096918.61416 37.7373544866644 -122.465657379584 (37.7373544866644, -122.465657379584) 1 8 4 59 40
120316 106363 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 101 URBANO DR 1 Front Yard : Yard Tree Private 2     80     5993535.8 2092458.1 37.7251204132224 -122.464530299025 (37.7251204132224, -122.464530299025) 9 8 4 59 40
24761 101258 Significant Tree 6 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1049 Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992548 2106581 37.7638413023971 -122.468972303767 (37.7638413023971, -122.468972303767) 1 8 11 56 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
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
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
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
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
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
4096 261159 Significant Tree 6 Tree(s) :: 17 1100X Moraga St 3 Sidewalk: Property side : Yard Tree Private 2   05/22/2020 12:00:00 AM 3 10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
6747 261157 Significant Tree 6 Tree(s) :: 17 1100X Moraga St 1 Sidewalk: Property side : Yard Tree Private 2   05/22/2020 12:00:00 AM 3 10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
9381 261160 Significant Tree 6 Tree(s) :: 17 1100X Moraga St 4 Sidewalk: Property side : Yard Tree Private 2   05/22/2020 12:00:00 AM 3 10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
11981 261158 Significant Tree 6 Juniperus californica :: California juniper 295 1100X Moraga St 2 Sidewalk: Property side : Yard Tree Private 2       10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
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
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
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
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
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
99609 96481 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
103743 96568 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
109546 96484 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 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
110019 96485 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 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
124067 96482 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
135340 96571 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
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
46153 209002 Significant Tree 6 Tree(s) :: 17 115 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2   07/17/2018 12:00:00 AM 3 Width 4ft Permit Number 781950 5994125 2096751 37.7369416119865 -122.462804803775 (37.7369416119865, -122.462804803775) 9 8 4 59 40
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
21096 253953 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 11X Ravenwood Dr 2 Sidewalk: Curb side : Yard Tree Private 2       10x10   5994792 2096029 37.7349975719357 -122.460446404237 (37.7349975719357, -122.460446404237) 9 8 4 59 40
110540 253952 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 11X Ravenwood Dr 1 Sidewalk: Curb side : Yard Tree Private 2       10x10   5994792 2096029 37.7349975719357 -122.460446404237 (37.7349975719357, -122.460446404237) 9 8 4 59 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
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
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
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
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
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
95053 114148 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 7 Front Yard : Yard Tree Private 2     19     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
95557 114140 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 5 Side 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
105349 114158 Significant Tree 6 Prunus armeniaca :: Apricot 296 1200X JUNIPERO SERRA BLVD 6 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
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
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
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
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
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
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
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
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
58651 100191 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1201 Holloway Ave 1 Front Yard : Yard Tree Private 2           5992431.5 2091178.1 37.7215421255294 -122.468254640211 (37.7215421255294, -122.468254640211) 9 8 6 64 24
117265 116346 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 121 SAN BENITO WAY 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2016 12:00:00 AM 3 3x3 Permit Number 777164 5992901 2095856 37.7344135917102 -122.466971633047 (37.7344135917102, -122.466971633047) 9 8 4 59 40
76823 255913 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 121 San Marcos Ave 1 Side Yard : Yard Tree Private 2       10x10   5993694 2100263 37.7465598483618 -122.464549884035 (37.7465598483618, -122.464549884035) 1 8 4 29491 40
132771 112955 Significant Tree 6 Araucaria heterophylla :: Norfolk Island Pine 238 121X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2           5991652.84779157 2095347.0788302 37.7329441015396 -122.471249796136 (37.7329441015396, -122.471249796136) 9 8 4 59 40
127076 104193 Significant Tree 6 Calocedrus decurrens :: Incense Cedar 206 122 Arch St 1 Front Yard : Yard Tree Private 2           5992720.4 2088013.1 37.7128684825751 -122.467026013031 (37.7128684825751, -122.467026013031) 9 8 6 64 24
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
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
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
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
10025 264885 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1279 44th Ave 1 Front Yard : Yard Tree Private 2       3x3 Permit Number 787806 5982392 2106415 37.7627934961857 -122.504085938563 (37.7627934961857, -122.504085938563) 1 8 3 56 35
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
13972 260573 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 129 Edgehill Way 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5994858 2098970 37.7430766268484 -122.460431252252 (37.7430766268484, -122.460431252252) 1 8 4 59 40
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
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
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
2183 117295 Significant Tree 6 Tree(s) :: 17 130 CAMBON DR 1 Side Yard : Yard Tree Private 2       3x3   5990450 2089482 37.7167704112637 -122.474980331165 (37.7167704112637, -122.474980331165) 1 8 4 64 14
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
66315 109521 Significant Tree 6 Tree(s) :: 17 1308 Ulloa St 1 Front Yard : Yard Tree Private 2       3x3   5991965.5 2098469.9 37.7415366593774 -122.470396231887 (37.7415366593774, -122.470396231887) 1 8 4 29491 40
2657 260570 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 4 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
5792 260568 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 2 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
8040 260572 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 6 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
11442 260571 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 5 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
11875 260569 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 3 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
13149 260567 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 1 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 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
133059 253652 Significant Tree 6 Tree(s) :: 17 131 Font Blvd 2 Sidewalk: Property side : Yard Tree Private 2   11/20/2017 12:00:00 AM 3 10x10 Permit Number 780806 5990844 2088883 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248) 1 8 4 64 14
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
13120 258703 Significant Tree 6 Tree(s) :: 17 131X Juan Bautista Cir 2 Sidewalk: Curb side : Yard Tree Private 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 783241 5989556 2089774 37.7175203194228 -122.478091750656 (37.7175203194228, -122.478091750656) 1 8 4 64 14
15674 258702 Significant Tree 6 Tree(s) :: 17 131X Juan Bautista Cir 1 Sidewalk: Curb side : Yard Tree Private 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 783241 5989556 2089774 37.7175203194228 -122.478091750656 (37.7175203194228, -122.478091750656) 1 8 4 64 14
15657 259657 Significant Tree 6 Tree(s) :: 17 132 Sagamore St 1 Front Yard : Yard Tree Private 2       3x3   5995545 2087474 37.7115508726991 -122.457224363425 (37.7115508726991, -122.457224363425) 9 8 6 28861 24
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
89112 106184 Significant Tree 6 Olea europaea :: Olive Tree 9 1327 ULLOA ST 1 Front Yard : Cutout Tree Private 2 FUF   2 4x4   5991893.8 2098371.4 37.7412620575898 -122.470636971077 (37.7412620575898, -122.470636971077) 1 8 4 59 40
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
96414 114394 Significant Tree 6 Ficus Spp. :: 101 134x TAPIA DR 1 Front Yard : Yard Tree Private 2     28     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
4567 261551 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 135 Fernwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994788 2095004 37.7321829429526 -122.460385989231 (37.7321829429526, -122.460385989231) 9 8 4 59 40
122278 106109 Significant Tree 6 Magnolia champaca :: Champa 141 135 MENDOSA AVE 2 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
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
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
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

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