trees

208 rows where Police Districts = 9 and qLegalStatus_id = 6 sorted by TreeID

✎ 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)
150357 100434 Significant Tree 6 Tree(s) :: 17 2430 Sacramento St 1 Front Yard : Yard Tree Private 2   09/24/2012 12:00:00 AM     Permit Number 769154 6003168.3 2115899 37.7900341016439 -122.432905672523 (37.7900341016439, -122.432905672523) 13 9 1 29490 27
147643 100770 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 450 Hayes St 1 Back Yard : Yard Tree Private 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
66091 100771 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 450 Hayes St 2 Back Yard : Yard Tree Private 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
100606 100772 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 450 Hayes St 3 Back Yard : Yard Tree Private 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
55812 101740 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1590 Broadway 3 Front Yard : Yard Tree Private 2   12/21/2012 12:00:00 AM 10   Permit Number 769428 6006182.95151 2117984.64817 37.7959312951427 -122.42262348649 (37.7959312951427, -122.42262348649) 13 9 10 28858 32
172328 101741 Significant Tree 6 Tree(s) :: 17 1590 Broadway 1 Front Yard : Yard Tree Private 2   12/21/2012 12:00:00 AM     Permit Number 769428 6006147.8 2117991.4 37.7959478507639 -122.422745597666 (37.7959478507639, -122.422745597666) 13 9 10 28858 32
140481 101742 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1590 Broadway 2 Front Yard : Yard Tree Private 2   12/21/2012 12:00:00 AM 8   Permit Number 769428 6006220.99461 2117990.30451 37.7959489722299 -122.422492252021 (37.7959489722299, -122.422492252021) 13 9 10 28858 32
63716 101743 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1590 Broadway 4 Front Yard : Yard Tree Private 2   12/21/2012 12:00:00 AM 12   Permit Number 769428 6006129.33795 2117976.30804 37.7959053703882 -122.422808406898 (37.7959053703882, -122.422808406898) 13 9 10 28858 32
84706 103143 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2620 Buchanan St 1 Front Yard : Yard Tree Private 2       3x3   6003626 2117322 37.7939672460834 -122.431423695166 (37.7939672460834, -122.431423695166) 13 9 1 29490 27
99529 103588 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 101X Laguna St 1 Front Yard : Yard Tree Private 2           6005198.60314 2109385.58511 37.772264815602 -122.425417269432 (37.772264815602, -122.425417269432) 7 9 5 28852 10
154569 103589 Significant Tree 6 Juniperus chinensis :: Juniper 113 55X Laguna St 1 Front Yard : Yard Tree Private 2           6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
120358 103590 Significant Tree 6 Juniperus chinensis :: Juniper 113 55X Laguna St 2 Front Yard : Yard Tree Private 2           6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
94077 103591 Significant Tree 6 Juniperus chinensis :: Juniper 113 55X Laguna St 3 Front Yard : Yard Tree Private 2           6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
22976 103600 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 50X Hermann St 1 Front Yard : Yard Tree Private 2           6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
182906 103611 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 200X Buchanan St 1 Sidewalk: Property side : Yard Tree Private 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
110134 103612 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 200X Buchanan St 2 Sidewalk: Property side : Yard Tree Private 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
172262 103613 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 200X Buchanan St 3 Sidewalk: Property side : Yard Tree Private 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
144064 103614 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 200X Buchanan St 4 Sidewalk: Property side : Yard Tree Private 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
88383 103615 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 200X Buchanan St 5 Sidewalk: Property side : Yard Tree Private 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
60900 103616 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 201X Haight St 1 Sidewalk: Property side : Yard Tree Private 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
75842 103617 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 201X Haight St 2 Sidewalk: Property side : Yard Tree Private 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
95437 103618 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 201X Haight St 3 Sidewalk: Property side : Yard Tree Private 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
152489 103652 Significant Tree 6 Tree(s) :: 17 307X Octavia St 1 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
29114 103653 Significant Tree 6 Tree(s) :: 17 307X Octavia St 2 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
3436 103654 Significant Tree 6 Tree(s) :: 17 307X Octavia St 3 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
108684 103655 Significant Tree 6 Tree(s) :: 17 307X Octavia St 4 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
109449 103656 Significant Tree 6 Tree(s) :: 17 307X Octavia St 5 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
81315 104261 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1556X O'Farrell St 1 Front Yard : Yard Tree Private 2           6003781.85581 2113525.38813 37.783551542878 -122.430613377711 (37.783551542878, -122.430613377711) 13 9 11 29490 41
83971 105071 Significant Tree 6 Acacia stenophylla :: Shoestring Acacia 30 1808 Vallejo St 1 Front Yard : Yard Tree Private 2     3   Permit Number 771033 6004794.05676 2118138.55822 37.7962754378239 -122.427440299436 (37.7962754378239, -122.427440299436) 13 9 1 57 17
15911 105081 Significant Tree 6 :: 45 344 Fulton St 1 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
126537 105082 Significant Tree 6 :: 45 344 Fulton St 2 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
167444 105083 Significant Tree 6 :: 45 344 Fulton St 3 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
75459 105084 Significant Tree 6 :: 45 344 Fulton St 4 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
145102 105085 Significant Tree 6 :: 45 344 Fulton St 5 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
17108 105086 Significant Tree 6 :: 45 344 Fulton St 6 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
154153 105087 Significant Tree 6 :: 45 344 Fulton St 7 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
186789 105088 Significant Tree 6 :: 45 344 Fulton St 8 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
803 105089 Significant Tree 6 :: 45 344 Fulton St 9 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
161677 105090 Significant Tree 6 :: 45 344 Fulton St 10 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
91093 105091 Significant Tree 6 :: 45 344 Fulton St 11 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
25451 105226 Significant Tree 6 Tree(s) :: 17 1150X Golden Gate Ave 1 Front Yard : Yard Tree Private 2   01/02/2014 12:00:00 AM     Permit Number 771276 6004329.61165 2112216.22051 37.7799879097685 -122.428625001082 (37.7799879097685, -122.428625001082) 7 9 11 29490 41
165618 105227 Significant Tree 6 Tree(s) :: 17 1150X Golden Gate Ave 2 Front Yard : Yard Tree Private 2   01/02/2014 12:00:00 AM     Permit Number 771276 6004329.61165 2112216.22051 37.7799879097685 -122.428625001082 (37.7799879097685, -122.428625001082) 7 9 11 29490 41
20207 105239 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 6 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
27763 105240 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 10 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
117572 105241 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 11 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
117668 105242 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 14 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
180419 105351 Significant Tree 6 Pyrus calleryana :: Ornamental Pear 44 2040 Jackson St 1 Front Yard : Yard Tree Private 2   01/16/2014 12:00:00 AM 3   Permit Number 769933 6004399.13095 2117053.27366 37.7932731788779 -122.428729419132 (37.7932731788779, -122.428729419132) 13 9 1 28858 27
82071 106360 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 1820 POST ST 1 Front Yard : Yard Tree Private 2     30     6003351.1 2114201.6 37.785383838011 -122.432151932321 (37.785383838011, -122.432151932321) 13 9 11 29490 13
22018 106361 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 1645 WEBSTER ST 2 Front Yard : Yard Tree Private 2     30     6003301.2 2114333.7 37.7857437219688 -122.432334009178 (37.7857437219688, -122.432334009178) 13 9 11 29490 13
109809 106362 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 1645 WEBSTER ST 1 Front Yard : Yard Tree Private 2     12     6003301.2 2114333.7 37.7857437219688 -122.432334009178 (37.7857437219688, -122.432334009178) 13 9 11 29490 13
100242 106956 Significant Tree 6 Tree(s) :: 17 50 Fell St 3 Front Yard : Yard Tree Private 2     14 10x10   6007226 2110908 37.7765593411304 -122.418512280303 (37.7765593411304, -122.418512280303) 7 9 9 28852 36
62475 107113 Significant Tree 6 Brahea edulis :: Guadalupe Palm 218 2100 MARKET ST   Front Yard : Cutout Tree Private 2           6004034 2107672.1 37.7674941340109 -122.429323526179 (37.7674941340109, -122.429323526179) 7 9 5 28862 3
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
181978 107824 Significant Tree 6 Tree(s) :: 17 10 STARR KING WAY 6 Front Yard : Yard Tree Private 2   01/06/2015 12:00:00 AM 3   Permit Number 774657 6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
113506 108002 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 461X Ivy St 1 Front Yard : Cutout Tree Private 2           6005199.36333 2111122.83043 37.7770349120596 -122.425538300101 (37.7770349120596, -122.425538300101) 7 9 11 28852 10
170978 108021 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 455X Ivy St 1 Front Yard : Cutout Tree Private 2           6005179.30837 2111099.83336 37.776970634543 -122.42560603936 (37.776970634543, -122.42560603936) 7 9 11 28852 10
65723 108022 Significant Tree 6 Grevillea robusta :: Silk Oak Tree 76 455X Ivy St 2 Front Yard : Cutout Tree Private 2           6005179.30837 2111099.83336 37.776970634543 -122.42560603936 (37.776970634543, -122.42560603936) 7 9 11 28852 10
154508 109210 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2637 Larkin St 1 Front Yard : Yard Tree Private 2   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774817 6006569.78732 2120282.61277 37.8022627417937 -122.421448236261 (37.8022627417937, -122.421448236261) 5 9 1 28858 32
125282 110236 Significant Tree 6 Pinus radiata :: Monterey Pine 15 100 BUCHANAN ST 1 Sidewalk: Curb side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3 3x20   6004868.5 2109011.4 37.7712187378523 -122.426532477218 (37.7712187378523, -122.426532477218) 7 9 5 28852 10
157916 110559 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 320x FULTON ST 1 Sidewalk: Property side : Yard Tree Private 2       10x36   6006080 2112015 37.7795343118474 -122.422555311635 (37.7795343118474, -122.422555311635) 7 9 11 28852 10
157383 110560 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 320x FULTON ST 2 Sidewalk: Property side : Yard Tree Private 2       10x36   6006080 2112015 37.7795343118474 -122.422555311635 (37.7795343118474, -122.422555311635) 7 9 11 28852 10
14326 112045 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2418 Pacific Ave 1 Front Yard : Yard Tree Private 2   06/26/2020 12:00:00 AM 3 3x3 Permit Number 785474 6002446.95594 2117111.03197 37.7933210893366 -122.435488200226 (37.7933210893366, -122.435488200226) 13 9 1 29490 27
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
166073 112419 Significant Tree 6 Picea Spp :: Spruce Spp 200 268 Lily St 1 Back Yard : Yard Tree Private 2   07/29/2015 12:00:00 AM 3     6005334.87738 2110100.0463 37.7742342515583 -122.424996726643 (37.7742342515583, -122.424996726643) 7 9 11 28852 10
60332 112420 Significant Tree 6 Picea Spp :: Spruce Spp 200 268 Lily St 2 Back Yard : Yard Tree Private 2   07/29/2015 12:00:00 AM 3     6005334.87738 2110100.0463 37.7742342515583 -122.424996726643 (37.7742342515583, -122.424996726643) 7 9 11 28852 10
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
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
73226 114272 Significant Tree 6 Tree(s) :: 17 2241 Sacramento St 1 Front Yard : Cutout Tree Private 2   03/22/2016 12:00:00 AM 3 3x6 Permit Number 776884 6004082.4 2115905.7 37.7901043022718 -122.429743441495 (37.7901043022718, -122.429743441495) 13 9 1 29490 27
169126 115697 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1425x LAGUNA ST 1 Front Yard : Yard Tree Private 2     25     6004559 2113815 37.7843907406582 -122.4279454018 (37.7843907406582, -122.4279454018) 13 9 11 29490 41
92381 116164 Significant Tree 6 Juniperus chinensis :: Juniper 113 2411 OCTAVIA ST 1 Sidewalk: Curb side : Yard Tree Private 2     13 15x4   6004495 2117637 37.7948813682629 -122.428439330772 (37.7948813682629, -122.428439330772) 13 9 1 28858 27
105893 116998 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 880x MCALLISTER ST 1 Front Yard : Cutout Tree Private 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
22312 116999 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 880x MCALLISTER ST 2 Front Yard : Cutout Tree Private 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
99950 117000 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 880x MCALLISTER ST 3 Front Yard : Cutout Tree Private 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
92359 120121 Significant Tree 6 Juglans hindsii :: Walnut: Black (n.calif) 457 444 Page St 1 Front Yard : Yard Tree Private 2           6004415 2109849 37.7734929358756 -122.428160854421 (37.7734929358756, -122.428160854421) 7 9 11 28852 10
106415 121157 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 1 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
194054 121158 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 2 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
99672 121159 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 3 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
123818 121160 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 4 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
74407 121161 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 5 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
83376 121162 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 6 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
79081 121163 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 7 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
12590 121368 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 245 Mallorca Way 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 778992 6001431 2120732 37.8032055622797 -122.439263127997 (37.8032055622797, -122.439263127997) 13 9 1 57 17
156627 125128 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2545 Baker St 2 Sidewalk: Property side : Yard Tree Private 2     13 Width 4ft   5999632.15337 2117620.57677 37.7945598973812 -122.44526423016 (37.7945598973812, -122.44526423016) 13 9 1 57 27
69 126274 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1240 Lombard St 1 Sidewalk: Property side : Yard Tree Private 2     24 Width 6ft   6006421.51674 2120105.21307 37.8017672864012 -122.421948716173 (37.8017672864012, -122.421948716173) 5 9 1 28858 32
185953 126695 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2829 Divisadero St 2 Front Yard : Yard Tree Private 2     11 10x10 Permit Number 779774 6000551.43021 2118023.61416 37.7957189625051 -122.442112369006 (37.7957189625051, -122.442112369006) 13 9 1 57 17
166311 127110 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3201 Laguna St 1 Sidewalk: Property side : Yard Tree Private 2     23 Width 6ft   6003718.35126 2119752.0994 37.8006449063974 -122.431277695812 (37.8006449063974, -122.431277695812) 13 9 1 57 17
166780 173951 Significant Tree 6 Tree(s) :: 17 2646 Union St 1 Front Yard : Cutout Tree Private 2   04/11/2017 12:00:00 AM 3 10x10 Permit Number 779549 6000338 2118225 37.7962597494046 -122.442865342513 (37.7962597494046, -122.442865342513) 13 9 1 57 17
133531 187642 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 2526 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006264 2119500 37.8000966404513 -122.42245076966 (37.8000966404513, -122.42245076966) 13 9 1 28858 32
177345 251411 Significant Tree 6 Tree(s) :: 17 2751 Buchanan St 1 Front Yard : Cutout Tree Private 2   06/21/2017 12:00:00 AM 3 6x6 Permit Number 779887 6003497 2117826 37.7953437887296 -122.431906052505 (37.7953437887296, -122.431906052505) 13 9 1 29490 27
106956 251495 Significant Tree 6 Tree(s) :: 17 2448 Clay St 1 Sidewalk: Curb side : Yard Tree Private 2   06/28/2017 12:00:00 AM 3 10x10 Permit Number 780000 6003026 2116224 37.7909183964794 -122.433421252488 (37.7909183964794, -122.433421252488) 13 9 1 29490 27
43750 253165 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 1451 Bay St 3 Front Yard : Yard Tree Private 2       3x3   6003691 2120547 37.8028259466608 -122.431429119577 (37.8028259466608, -122.431429119577) 13 9 1 57 17
44345 253366 Significant Tree 6 Ficus carica :: Edible Fig 341 20 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004582 2109434 37.7723628942784 -122.427553605007 (37.7723628942784, -122.427553605007) 7 9 11 28852 10
159837 253968 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
108843 253969 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
139296 253970 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
17242 253971 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
139171 255246 Significant Tree 6 Maytenus boaria :: Mayten 58 209x Willow St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6006475 2113325 37.7831535286214 -122.421281886667 (37.7831535286214, -122.421281886667) 7 9 11 28858 41

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