trees

185 rows where Police Districts = 5 and qLegalStatus_id = 6 sorted by PlantDate 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)
58774 102106 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 50X Noe St 8 Front Yard : Yard Tree Private 2   12/19/2012 12:00:00 AM 25   Permit Number 769282 6002816.1 2107996.5 37.7683158318555 -122.433559261751 (37.7683158318555, -122.433559261751) 15 5 5 28862 3
8580 261010 Significant Tree 6 Tree(s) :: 17 91 Parkridge Dr 3 Sidewalk: Curb side : Cutout Tree Private 2   12/18/2019 12:00:00 AM 3 3x3 Permit Number 784979 5998980 2102204 37.7521926688144 -122.446411148664 (37.7521926688144, -122.446411148664) 2 5 5 63 38
22915 92852 Significant Tree 6 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 3794 16th St 1 Front Yard : Yard Tree Private 2   12/14/2009 12:00:00 AM     Permit Number 53072 6001901 2106436 37.7639791186972 -122.436612788339 (37.7639791186972, -122.436612788339) 15 5 5 28862 3
184408 92853 Significant Tree 6 Cercis occidentalis :: Western Redbud 136 3794 16th St 2 Front Yard : Yard Tree Private 2   12/14/2009 12:00:00 AM     Permit Number 53072 6001901 2106436 37.7639791186972 -122.436612788339 (37.7639791186972, -122.436612788339) 15 5 5 28862 3
15509 258701 Significant Tree 6 Tree(s) :: 17 206 Edgewood Ave 1 Front Yard : Yard Tree Private 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 783089 5996625 2105876 37.7621402663071 -122.454820337862 (37.7621402663071, -122.454820337862) 15 5 11 29492 12
77181 95229 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1@Carl Irving St 5 Sidewalk: Property side : Yard Tree Private 2   11/16/2010 12:00:00 AM 15     5995817.2 2106753.3 37.7645027364821 -122.45767767256 (37.7645027364821, -122.45767767256) 15 5 11 56 12
93603 95230 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1@Carl Irving St 6 Front Yard : Yard Tree Private 2   11/16/2010 12:00:00 AM 27     5995817.2 2106753.3 37.7645027364821 -122.45767767256 (37.7645027364821, -122.45767767256) 15 5 11 56 12
122339 95231 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1@Carl Irving St 10 Sidewalk: Property side : Yard Tree Private 2   11/16/2010 12:00:00 AM       5995817.2 2106753.3 37.7645027364821 -122.45767767256 (37.7645027364821, -122.45767767256) 15 5 11 56 12
74277 251372 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1526 Masonic Ave 1 Sidewalk: Property side : Cutout Tree Private 2   11/01/2017 12:00:00 AM 3 3x3 Permit Number 779800 5999767 2107205 37.7659690994291 -122.444048894864 (37.7659690994291, -122.444048894864) 15 5 5 29492 9
63103 101204 Significant Tree 6 Tree(s) :: 17 1290 Stanyan St 1 Front Yard : Yard Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769288 5997580.9 2104992.4 37.7597689094704 -122.451450528065 (37.7597689094704, -122.451450528065) 15 5 11 29492 12
5239 112929 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
23199 112923 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
53110 112918 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
56286 112919 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
65651 112922 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
74096 112921 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
106523 112930 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
148103 112925 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
166722 112928 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
176305 112927 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
179756 112920 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
186584 112926 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
153784 99733 Significant Tree 6 Pyrus calleryana :: Ornamental Pear 44 145 Irving St 1 Front Yard : Yard Tree Private 2   08/21/2012 12:00:00 AM     Permit Number 768746 5995340.8 2106458.8 37.76366673695 -122.45930407086 (37.76366673695, -122.45930407086) 15 5 11 56 12
163794 100464 Significant Tree 6 Pyrus calleryana :: Ornamental Pear 44 145 Irving St 3 Front Yard : Yard Tree Private 2   08/21/2012 12:00:00 AM     Permit Number 768746 5995340.8 2106458.8 37.76366673695 -122.45930407086 (37.76366673695, -122.45930407086) 15 5 11 56 12
168323 99734 Significant Tree 6 Pyrus calleryana :: Ornamental Pear 44 145 Irving St 2 Front Yard : Yard Tree Private 2   08/21/2012 12:00:00 AM     Permit Number 768746 5995340.8 2106458.8 37.76366673695 -122.45930407086 (37.76366673695, -122.45930407086) 15 5 11 56 12
157634 85365 Significant Tree 6 Myoporum laetum :: Myoporum 62 66 Clarendon Ave 1 Front Yard : Cutout Tree Private 2   08/17/2007 12:00:00 AM     Permit Number 49641 5997837.8 2104660.2 37.7588714791444 -122.450538092312 (37.7588714791444, -122.450538092312) 15 5 11 28862 12
96515 253513 Significant Tree 6 Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 373 1545 05th Ave 1 Front Yard : Yard Tree Private 2   08/14/2012 12:00:00 AM   3x3 Permit Number 768941 5994803.92058 2105050.88998 37.7597700982665 -122.461058902115 (37.7597700982665, -122.461058902115) 1 5 4 56 12
167818 99950 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1545 05th Ave 1 Front Yard : Yard Tree Private 2   08/14/2012 12:00:00 AM     Permit Number 768941 5994712.1 2105033.7 37.7597176147703 -122.461375215787 (37.7597176147703, -122.461375215787) 1 5 4 56 12
23924 92900 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 208 States St 4 Back Yard : Yard Tree Private 2   08/13/2008 12:00:00 AM       6000833 2106506 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354) 15 5 5 28862 3
131738 92899 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 208 States St 3 Back Yard : Yard Tree Private 2   08/13/2008 12:00:00 AM       6000833 2106506 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354) 15 5 5 28862 3
151892 92897 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 208 States St 1 Back Yard : Yard Tree Private 2   08/13/2008 12:00:00 AM       6000833 2106506 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354) 15 5 5 28862 3
175631 92898 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 208 States St 2 Back Yard : Yard Tree Private 2   08/13/2008 12:00:00 AM       6000833 2106506 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354) 15 5 5 28862 3
139544 104085 Significant Tree 6 Populus spp :: Poplar Spp 262 1329 Stanyan St 1 Front Yard : Yard Tree Private 2   08/07/2013 12:00:00 AM     Permit Number 770194 5997530.4 2104741.3 37.7590765601241 -122.451607069148 (37.7590765601241, -122.451607069148) 15 5 4 28862 12
128997 109708 Significant Tree 6 Tree(s) :: 17 621 Laguna Honda Blvd 3 Front Yard : Cutout Tree Private 2 FUF 07/29/2015 12:00:00 AM     Permit Number 774799 5995723.9 2099907.4 37.7457002690083 -122.457505029341 (37.7457002690083, -122.457505029341) 1 5 4 59 40
178069 104027 Significant Tree 6 Pinus radiata :: Monterey Pine 15 520X Oak Park Dr 1 Back Yard : Yard Tree Private 2   07/25/2013 12:00:00 AM     Permit Number 770238 5995008.5 2103700.7 37.7560745928775 -122.460253542676 (37.7560745928775, -122.460253542676) 1 5 4 63 12
14822 96765 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 184 Edgewood Ave 1 Front Yard : Yard Tree Private 2   07/12/2011 12:00:00 AM     Permit Number 767998 5996632 2105999 37.7624783944866 -122.454805014883 (37.7624783944866, -122.454805014883) 15 5 11 29492 12
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
35924 89310 Significant Tree 6 Tree(s) :: 17 32 Lyon St 2 Front Yard : Yard Tree Private 2   06/28/2017 12:00:00 AM 3 3x3 Permit Number 780094 6000399 2109002 37.7709392449299 -122.441991937871 (37.7709392449299, -122.441991937871) 15 5 11 29492 9
107510 89309 Significant Tree 6 Tree(s) :: 17 32 Lyon St 1 Front Yard : Yard Tree Private 2   06/28/2017 12:00:00 AM 3 3x3 Permit Number 780094 6000399 2109002 37.7709392449299 -122.441991937871 (37.7709392449299, -122.441991937871) 15 5 11 29492 9
173974 251394 Significant Tree 6 Araucaria araucana :: Monkey puzzle 287 203 Corbett Ave 1 Front Yard : Yard Tree Private 2   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779803 6000094 2105620 37.7616357315689 -122.442804047122 (37.7616357315689, -122.442804047122) 15 5 5 28862 3
61598 99299 Significant Tree 6 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 1457 Willard St 1 Front Yard : Tree Private 2   05/02/2012 12:00:00 AM     Permit Number 768720 5996809.7 2106270.3 37.763233506694 -122.454210015753 (37.763233506694, -122.454210015753) 15 5 11 29492 12
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
172767 98696 Significant Tree 6 Aesculus californica :: California Buckeye 168 191@Clarendon Forest Knolls Dr 3 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
175269 98695 Significant Tree 6 Aesculus californica :: California Buckeye 168 191@Clarendon Forest Knolls Dr 2 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
124217 109412 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 24 DELMAR ST 1 Front Yard : Yard Tree Private 2   04/03/2015 12:00:00 AM 3 3x3 Permit Number 774367 5999307.7 2108197.1 37.7686669444558 -122.445708866914 (37.7686669444558, -122.445708866914) 15 5 11 29492 9
166922 103307 Significant Tree 6 Pyrus spp :: Pear Tree 281 1467 Willard St 1 Front Yard : Yard Tree Private 2   04/02/2013 12:00:00 AM 5 6x6 Permit Number 768689 5996817.5 2106175 37.7629722844649 -122.454176154627 (37.7629722844649, -122.454176154627) 15 5 11 29492 12
173581 251197 Significant Tree 6 Pinus radiata :: Monterey Pine 15 900X 14th St 3 Front Yard : Yard Tree Private 2   03/22/2017 12:00:00 AM 3   Permit Number 779570 6002798.55883 2107703.57748 37.7675105430125 -122.433598998019 (37.7675105430125, -122.433598998019) 15 5 5 28862 3
180810 251196 Significant Tree 6 Pinus radiata :: Monterey Pine 15 900X 14th St 2 Front Yard : Cutout Tree Private 2   03/22/2017 12:00:00 AM 3     6002515 2107976 37.768242455455 -122.434599270731 (37.768242455455, -122.434599270731) 15 5 5 28862 3
10379 95953 Significant Tree 6 Tree(s) :: 17 499 Buena Vista East Ave   Front Yard : Yard Tree Private 2   03/18/2011 12:00:00 AM 21   Permit Number 57015 6000177 2107098 37.7656986843565 -122.442623109531 (37.7656986843565, -122.442623109531) 15 5 5 29492 3
80420 105436 Significant Tree 6 Tree(s) :: 17 610 PARNASSUS AVE 7 Sidewalk: Property side : Yard Tree Private 2   03/05/2014 12:00:00 AM 15   Permit Number 771221 5995151.3 2106193.4 37.762927120329 -122.459940260935 (37.762927120329, -122.459940260935) 15 5 11 56 12
155656 105435 Significant Tree 6 Tree(s) :: 17 610 PARNASSUS AVE 1 Sidewalk: Property side : Yard Tree Private 2   03/05/2014 12:00:00 AM 16   Permit Number 771221 5995151.3 2106193.4 37.762927120329 -122.459940260935 (37.762927120329, -122.459940260935) 15 5 11 56 12
49649 105844 Significant Tree 6 Tree(s) :: 17 355 Buena Vista Ave   Front Yard : Yard Tree Private 2   03/03/2014 12:00:00 AM     Permit Number 771052 6000886.5 2107736.6 37.767492540377 -122.440214908068 (37.767492540377, -122.440214908068) 15 5 5 29492 3
20293 254534 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 737 Buena Vista Ave West 6 Front Yard : Yard Tree Private 2   02/27/2018 12:00:00 AM 3 10X10   5999910.14564 2107959.614 37.7680492454315 -122.443607999122 (37.7680492454315, -122.443607999122) 15 5 5 29492 9
32791 254539 Significant Tree 6 Ilex spp :: Holly Species 81 737 Buena Vista Ave West 5 Front Yard : Yard Tree Private 2   02/27/2018 12:00:00 AM 3 10X10   5999910.14564 2107959.614 37.7680492454315 -122.443607999122 (37.7680492454315, -122.443607999122) 15 5 5 29492 9
43728 254538 Significant Tree 6 Ilex spp :: Holly Species 81 737 Buena Vista Ave West 4 Front Yard : Yard Tree Private 2   02/27/2018 12:00:00 AM 3 10X10   5999910.14564 2107959.614 37.7680492454315 -122.443607999122 (37.7680492454315, -122.443607999122) 15 5 5 29492 9
73911 254536 Significant Tree 6 Cordyline australis :: Dracena Palm 64 737 Buena Vista Ave West 2 Front Yard : Yard Tree Private 2   02/27/2018 12:00:00 AM 3 10X10   5999910.14564 2107959.614 37.7680492454315 -122.443607999122 (37.7680492454315, -122.443607999122) 15 5 5 29492 9
103639 254535 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 737 Buena Vista Ave West 1 Front Yard : Yard Tree Private 2   02/27/2018 12:00:00 AM 3 10X10   5999910.14564 2107959.614 37.7680492454315 -122.443607999122 (37.7680492454315, -122.443607999122) 15 5 5 29492 9
109929 254537 Significant Tree 6 Cordyline australis :: Dracena Palm 64 737 Buena Vista Ave West 3 Front Yard : Yard Tree Private 2   02/27/2018 12:00:00 AM 3 10X10   5999910.14564 2107959.614 37.7680492454315 -122.443607999122 (37.7680492454315, -122.443607999122) 15 5 5 29492 9
37603 93205 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 400 Masonic Ave 3 Front Yard : Yard Tree Private 2   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.7774714343299 -122.446572853901 (37.7774714343299, -122.446572853901) 15 5 11 29492 16
98332 93204 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 400 Masonic Ave 1 Front Yard : Yard Tree Private 2   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.7774714343299 -122.446572853901 (37.7774714343299, -122.446572853901) 15 5 11 29492 16
158156 93206 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 400 Masonic Ave 4 Front Yard : Yard Tree Private 2   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.7774714343299 -122.446572853901 (37.7774714343299, -122.446572853901) 15 5 11 29492 16
180298 93203 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 400 Masonic Ave 2 Front Yard : Yard Tree Private 2   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.7774714343299 -122.446572853901 (37.7774714343299, -122.446572853901) 15 5 11 29492 16
119882 105045 Significant Tree 6 Tree(s) :: 17 1899X Eddy St 3 Front Yard : Yard Tree Private 2   02/21/2014 12:00:00 AM     Permit Number 772599 6001374.8 2112478.6 37.7805406719806 -122.438865805362 (37.7805406719806, -122.438865805362) 15 5 11 29490 41
158054 105754 Significant Tree 6 Tree(s) :: 17 1899X Eddy St 2 Front Yard : Yard Tree Private 2   02/21/2014 12:00:00 AM     Permit Number 772599 6001374.8 2112478.6 37.7805406719806 -122.438865805362 (37.7805406719806, -122.438865805362) 15 5 11 29490 41
37092 254109 Significant Tree 6 Tree(s) :: 17 38X Starview Way 1 Sidewalk: Property side : Yard Tree Private 2   02/06/2018 12:00:00 AM 3 6x6 Permit Number 781050 5997469 2101545 37.7502968010125 -122.451588863361 (37.7502968010125, -122.451588863361) 1 5 4 63 38
111867 115459 Significant Tree 6 Tree(s) :: 17 80 Crestline Dr 1 Back Yard : Yard Tree Private 2   02/02/2016 12:00:00 AM 3   Permit Number 776150 5999012.8 2102131.7 37.7519960240451 -122.446292521132 (37.7519960240451, -122.446292521132) 2 5 5 63 38
179476 115460 Significant Tree 6 Tree(s) :: 17 80 Crestline Dr 2 Back Yard : Yard Tree Private 2   02/02/2016 12:00:00 AM 3   Permit Number 776150 5999012.8 2102131.7 37.7519960240451 -122.446292521132 (37.7519960240451, -122.446292521132) 2 5 5 63 38
58512 253898 Significant Tree 6 Tree(s) :: 17 201X Oak Park Dr 2 Back Yard : Yard Tree Private 2   01/17/2018 12:00:00 AM 3 10x10 Permit Number 780818 5996124 2103402 37.7553185401494 -122.45637419556 (37.7553185401494, -122.45637419556) 1 5 4 63 12
183899 253897 Significant Tree 6 Tree(s) :: 17 201X Oak Park Dr 1 Back Yard : Yard Tree Private 2   01/17/2018 12:00:00 AM 3 10x10 Permit Number 780818 5996124 2103402 37.7553185401494 -122.45637419556 (37.7553185401494, -122.45637419556) 1 5 4 63 12
25036 95137 Significant Tree 6 Tree(s) :: 17 2130 Fulton St 127 Front Yard : Tree Private 2   01/07/2011 12:00:00 AM   3x3 Permit Number 54069 5997590 2110608 37.7751884337973 -122.451824172116 (37.7751884337973, -122.451824172116) 15 5 2 29492 16
33415 95138 Significant Tree 6 Tree(s) :: 17 2130 Fulton St 128 Front Yard : Tree Private 2   01/07/2011 12:00:00 AM   3x3 Permit Number 54069 5997590 2110608 37.7751884337973 -122.451824172116 (37.7751884337973, -122.451824172116) 15 5 2 29492 16
147971 253973 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 2200 Ofarrell St 2 Front Yard : Yard Tree Private 2   01/05/2018 12:00:00 AM 3 3x3 Permit Number 780724 6000775 2113124 37.7822786323031 -122.440987106931 (37.7822786323031, -122.440987106931) 15 5 1 29490 41
163295 253972 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 2200 Ofarrell St 1 Front Yard : Yard Tree Private 2   01/05/2018 12:00:00 AM 3 3x3 Permit Number 780724 6000775 2113124 37.7822786323031 -122.440987106931 (37.7822786323031, -122.440987106931) 15 5 1 29490 41
180 110904 Significant Tree 6 Tree(s) :: 17 203 CORBETT AVE 1 Front Yard : Yard Tree Private 2     20 3x3   6000094 2105620 37.7616357315689 -122.442804047122 (37.7616357315689, -122.442804047122) 15 5 5 28862 3
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
3462 233333 Significant Tree 6 Pinus radiata :: Monterey Pine 15 188 States St 1 Back Yard : Yard Tree Private 2     14 Width 3ft Permit Number 784841 6001049.9199 2106366.66768 37.763740347549 -122.43955144426 (37.763740347549, -122.43955144426) 15 5 5 28862 3
3910 173844 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2X Crestline Dr 1 Front Yard : Yard Tree Private 2           5999319 2101169 37.7493701671822 -122.445164434644 (37.7493701671822, -122.445164434644) 2 5 5 63 38
5712 258876 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1326 Hayes St 1 Sidewalk: Curb side : Yard Tree Private 2       Width 0ft   6001504 2110473 37.7750411502564 -122.438275119801 (37.7750411502564, -122.438275119801) 15 5 11 29492 10
5928 260423 Significant Tree 6 Juniperus californica :: California juniper 295 237 Glenview Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998907 2100812 37.7483664070673 -122.446563453195 (37.7483664070673, -122.446563453195) 2 5 5 63 38
6519 251515 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99x Mountview Ct 1 Back Yard : Yard Tree Private 2       3x3   5997620 2100449 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073) 1 5 4 63 38
7026 121414 Significant Tree 6 Pinus radiata :: Monterey Pine 15 150 Raccoon Dr 1 Back Yard : Cutout Tree Private 2     36 3x3   5998776 2103987 37.7570766935068 -122.447244922317 (37.7570766935068, -122.447244922317) 15 5 5 63 3
7245 251144 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
10388 251145 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
13777 261032 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 438 Roosevelt Way 2 Front Yard : Yard Tree Private 2       Width 3ft   6000030.97008 2106544.70148 37.7641711390149 -122.443088453592 (37.7641711390149, -122.443088453592) 15 5 5 29492 3
14733 255398 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 637 MASONIC AVE 3 Sidewalk: Property side : Cutout Tree Private 2       Width 0ft   5999139.3301 2110590.1819 37.7752281241925 -122.446463429304 (37.7752281241925, -122.446463429304) 15 5 11 29492 16
15969 261831 Significant Tree 6 Acer japonicum :: Japanese Maple 124 1507 Cole St 1 Front Yard : Cutout Tree Private 2       3x3   5998279 2105297 37.7606452154312 -122.449058098094 (37.7606452154312, -122.449058098094) 15 5 11 29492 12
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
18711 262449 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 155 Baker St 1 Side Yard : Yard Tree Private 2       10x10   6000750.251 2109577.8851 37.7725404908768 -122.440818271359 (37.7725404908768, -122.440818271359) 15 5 11 29492 9
18868 260249 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 260 10 Crestline Dr 1 Median : Yard Tree Private 2       3x3   5999247 2101231 37.7495362941779 -122.445417868856 (37.7495362941779, -122.445417868856) 2 5 5 63 38
21449 255662 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1626 Shrader St 1 Sidewalk: Property side : Yard Tree Private 2       6x6 Permit Number 782137 5998119 2105007 37.759839795982 -122.44959056596 (37.759839795982, -122.44959056596) 15 5 11 29492 12
23401 114142 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99 Divisadero St   Front Yard : Yard Tree Private 2           6001906.1 2108188.4 37.7687910682296 -122.436720598265 (37.7687910682296, -122.436720598265) 15 5 5 29492 3
24444 173927 Significant Tree 6 Pinus radiata :: Monterey Pine 15 240 States St 1 Back Yard : Yard Tree Private 2           6001213 2106258 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423) 15 5 5 28862 3
25777 257968 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499X Carl St 2 Sidewalk: Property side : Yard Tree Private 2       10x10   5995946 2106884 37.7648690031923 -122.457241646887 (37.7648690031923, -122.457241646887) 15 5 11 29492 12
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
34055 105417 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1450X McAllister St 3 Front Yard : Yard Tree Private 2           6002220.78829 2111575.67932 37.7781095739995 -122.435874511445 (37.7781095739995, -122.435874511445) 15 5 11 29492 41
34533 110193 Significant Tree 6 Pinus radiata :: Monterey Pine 15 7X CASTRO ST 1 Back Yard : Yard Tree Private 2       3x3   6002014.1 2108690 37.7701744750285 -122.436382938918 (37.7701744750285, -122.436382938918) 15 5 5 29492 9
35186 100579 Significant Tree 6 Tree(s) :: 17 35 Lloyd St 2 Front Yard : Yard Tree Private 2           6002279.7 2108550 37.7698051576272 -122.435454215606 (37.7698051576272, -122.435454215606) 15 5 5 29492 9
35278 115415 Significant Tree 6 Pinus radiata :: Monterey Pine 15 137 ANZAVISTA AVE 1 Back Yard : Yard Tree Private 2       3x3   5999865 2112093 37.7793958997315 -122.444061187374 (37.7793958997315, -122.444061187374) 15 5 1 29490 16
36670 87156 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 237 Rivoli St 1 Front Yard : Yard Tree Private 2         Permit Number 50138 5997662 2105892 37.7622436280127 -122.451234923187 (37.7622436280127, -122.451234923187) 15 5 11 29492 9
36736 101527 Significant Tree 6 Ailanthus altissima :: Tree Of Heaven 333 151-153 Lower Ter 1 Front Yard : Yard Tree Private 2     18   Permit Number 769490 6000139.7 2106146.6 37.7630842500585 -122.4426838025 (37.7630842500585, -122.4426838025) 15 5 5 28862 3

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