sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4012 252965 5 82 115X Whipple Ave 1 1 1 1   10/05/2017 02:04:00 PM 3              
4061 252970 5 82 101X Whipple Ave 2 2 1 1   10/05/2017 12:21:00 PM 3              
5893 46201 1 82   1 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
6305 52146 1 82 145 Hawes St 1 1 1 1   10/31/2005 12:00:00 AM     Permit Number 48337          
9250 46200 1 82   2 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
9603 19972 3 82 100 STAIRWAY44 3 1 1 2     3 36            
11507 30593 1 82 269 Walter St 1 1 1 1   01/26/1995 12:00:00 AM     Permit Number 34561          
13405 30592 1 82 269 Walter St 2 1 1 1   01/26/1995 12:00:00 AM     Permit Number 34561          
180005 72279 2 82 767 41st Ave 1 1 1 1 1 01/20/1996 12:00:00 AM 6     5983194.45467 2110583.80622 37.7742869998631 -122.501619002427 (37.7742869998631, -122.501619002427)
45516 117917 2 82 767 41st Ave 2 9 1 1     6 Width 4ft   5983194.46177 2110567.54263 37.7742423451733 -122.501617774429 (37.7742423451733, -122.501617774429)
109406 63194 1 82 420 38th Ave 1 1 1 1 1 12/14/1991 12:00:00 AM     Permit Number 23734 5984095.68800959 2112985.55374836 37.78093439601071 -122.498678978522 (37.7809343960107, -122.498678978522)
135259 69460 1 82 446 35th Ave 1 1 1 1 1 05/16/1994 12:00:00 AM 3   Permit Number 33570 5985026.614630001 2112867.05169 37.7806635770894 -122.495449750327 (37.7806635770894, -122.495449750327)
109207 21209 3 82 2392X Sunset Blvd 12 1 1 2     3 60   5984971.116957701 2098921.2732344 37.7423691180201 -122.494613333405 (37.7423691180201, -122.494613333405)
125824 21211 3 82 2392X Sunset Blvd 14 1 1 2     3 60   5984971.116957701 2098921.2732344 37.7423691180201 -122.494613333405 (37.7423691180201, -122.494613333405)
143816 21208 3 82 2392X Sunset Blvd 11 1 1 2     3 60   5984971.116957701 2098921.2732344 37.7423691180201 -122.494613333405 (37.7423691180201, -122.494613333405)
91492 24700 1 82 6940 Geary Blvd 1 1 1 1   03/15/2006 12:00:00 AM 3 3X3   5985447.12642 2112543.37928 37.77979947939 -122.493971158415 (37.77979947939, -122.493971158415)
69129 69449 1 82 435 33rd Ave 1 1 1 1 1 05/16/1994 12:00:00 AM 7   Permit Number 33559 5985596.63224 2112961.6611 37.7809567074922 -122.493484787172 (37.7809567074922, -122.493484787172)
169324 118185 2 82 435 33rd Ave 2 1 1 1     4 Width 2ft   5985597.25903 2112945.4232900003 37.7809121598048 -122.493481422073 (37.7809121598048, -122.493481422073)
72842 69456 1 82 471 33rd Ave 1 1 1 1 1 05/16/1994 12:00:00 AM 5   Permit Number 33566 5985607.3929 2112736.22477 37.7803383536355 -122.493430946652 (37.7803383536355, -122.493430946652)
70320 181741 2 82 1215 33rd Ave 1 1 1 1     7 Width 0ft   5985810.6327 2106942.082 37.7644411641486 -122.492301073815 (37.7644411641486, -122.492301073815)
146269 24686 1 82 6599X Geary Blvd 2 1 1 3   03/15/2006 12:00:00 AM 3 3X3   5986563.55545 2112507.59289 37.77976647962429 -122.49010635929599 (37.7797664796243, -122.490106359296)
53492 75980 2 82 6555 Geary Blvd 2 1 1 1 1 06/03/1989 12:00:00 AM 3     5986643.29892 2112486.62546 37.7797135654944 -122.48982895296699 (37.7797135654944, -122.489828952967)
2715 253166 4 82 2405 32nd Ave 1 1 1 1   07/31/2017 12:00:00 AM 3 3x3 Permit Number 778209 5986396.6612 2098868.17463 37.742306656921 -122.48968039586501 (37.742306656921, -122.489680395865)
121744 107696 1 82 2401 MORAGA ST 4 9 1 1     3     5986802.4 2103641.7 37.7554371523715 -122.488628271884 (37.7554371523715, -122.488628271884)
166878 182744 2 82 1769 30th Ave 1 1 1 1     5 Width 0ft   5986859.8585 2103239.7166 37.754336768117206 -122.488400024275 (37.7543367681172, -122.488400024275)
181096 182748 2 82 1789 30th Ave 5 1 1 1     4 Width 0ft   5986861.6929 2103148.806 37.754087259353206 -122.488386999785 (37.7540872593532, -122.488386999785)
65500 182749 2 82 1791 30th Ave 6 1 1 1     4 Width 0ft   5986862.6162 2103130.8030000003 37.754037881879 -122.488382483852 (37.754037881879, -122.488382483852)
35976 181801 2 82 1919 Santiago St 2 1 1 1     2 Width 0ft   5986905.9682 2099586.0566 37.744307492185 -122.487972126615 (37.744307492185, -122.487972126615)
72832 181803 2 82 1915 Santiago St 4 1 1 1     2 Width 0ft   5986942.1793 2099588.0871 37.7443151796952 -122.487847067129 (37.7443151796952, -122.487847067129)
141691 112080 2 82 1901x SANTIAGO ST 2 1 1 1     3 3x3   5986971.0 2099566.0 37.744256215511896 -122.487745790198 (37.7442562155119, -122.487745790198)
144808 112082 2 82 1901x SANTIAGO ST 4 1 1 1     3 3x3   5986971.0 2099566.0 37.744256215511896 -122.487745790198 (37.7442562155119, -122.487745790198)
123759 38869 1 82 2439 29th Ave 2 1 1 1 1 11/02/1998 12:00:00 AM     Permit Number 40694 5987327.75302366 2098677.68678111 37.7418379454862 -122.486447023752 (37.7418379454862, -122.486447023752)
120653 93044 1 82 155 26th Ave 1 1 1 1     12     5987698.59819 2114939.90173 37.7865111255347 -122.486358421479 (37.7865111255347, -122.486358421479)
126891 120181 2 82 142 26th Ave 1 1 1 1     8 Width 3ft   5987742.587230001 2115005.98358 37.7866951312776 -122.486211085191 (37.7866951312776, -122.486211085191)
50738 120183 2 82 160 26th Ave 1 1 1 1     8 Width 3ft   5987744.35264 2114901.48572 37.7864083129421 -122.486197303246 (37.7864083129421, -122.486197303246)
82718 90488 3 82 125 25th Ave 1 1 1 2   03/27/2008 12:00:00 AM 6 3x3   5987997.512680001 2115126.89685 37.7870419790043 -122.485337990995 (37.7870419790043, -122.485337990995)
51338 182788 2 82 1781 26th Ave 1 1 1 1     7 Width 0ft   5988111.6274 2103184.2484 37.754257425098096 -122.484067075117 (37.7542574250981, -122.484067075117)
74587 182789 2 82 1785 26th Ave 2 1 1 1     7 Width 0ft   5988112.4655 2103151.9819 37.7541688787672 -122.484061810783 (37.7541688787672, -122.484061810783)
188071 182790 2 82 1791 26th Ave 3 1 1 1     7 Width 0ft   5988113.3036 2103133.9629 37.754119452236 -122.48405759118499 (37.754119452236, -122.484057591185)
172764 120258 2 82 130 24th Ave 4 2 1 1     3 Width 4ft   5988366.4287 2115019.00218 37.7867672160285 -122.48405372444599 (37.7867672160285, -122.484053724446)
49709 120248 2 82 164 24th Ave 3 2 1 1     9 Width 6ft   5988365.09621 2114861.46484 37.786334585774604 -122.484046777757 (37.7863345857746, -122.484046777757)
176550 120252 2 82 160 24th Ave 1 2 1 1     5 Width 6ft   5988365.81555 2114876.44647 37.7863757629455 -122.484045388081 (37.7863757629455, -122.484045388081)
44437 120251 2 82 160 24th Ave 2 2 1 1     10 Width 6ft   5988366.40775 2114885.43189 37.7864004688283 -122.48404399839899 (37.7864004688283, -122.484043998399)
63345 120250 2 82 164 24th Ave 1 2 1 1     9 Width 6ft   5988365.5517 2114845.05893 37.7862895663335 -122.484043998391 (37.7862895663335, -122.484043998391)
77045 120249 2 82 164 24th Ave 2 2 1 1     10 Width 6ft   5988365.91336 2114852.64965 37.786310429345704 -122.48404330399599 (37.7863104293457, -122.484043303996)
22887 120259 2 82 130 24th Ave 3 2 1 1     6 Width 4ft   5988369.32629 2115004.14379 37.7867265878172 -122.484042609601 (37.7867265878172, -122.484042609601)
185841 120256 2 82 140 24th Ave 2 2 1 1     8 Width 4ft   5988368.86327 2114963.36268 37.7866145875471 -122.48404121988199 (37.7866145875471, -122.484041219882)
49555 120257 2 82 140 24th Ave 1 2 1 1     6 Width 4ft   5988368.87318 2114954.3645200003 37.786589881739104 -122.484040525506 (37.7865898817391, -122.484040525506)
153635 120255 2 82 150 24th Ave 1 2 1 1     3 Width 6ft   5988367.99594 2114912.99225 37.7864762341937 -122.484040525506 (37.7864762341937, -122.484040525506)
47047 120253 2 82 150 24th Ave 3 2 1 1     3 Width 6ft   5988369.64092 2114933.75275 37.7865333323848 -122.48403635730499 (37.7865333323848, -122.484036357305)
28239 120254 2 82 150 24th Ave 2 2 1 1     3 Width 6ft   5988369.36546 2114920.76145 37.7864976459369 -122.4840363573 (37.7864976459369, -122.4840363573)
39057 120310 2 82 120 23rd Ave 1 1 1 1     12 Width 3ft   5988691.601840001 2114529.40052 37.7854418348342 -122.482892819932 (37.7854418348342, -122.482892819932)
154275 120315 2 82 206 23rd Ave 1 1 1 1     8 Width 3ft   5988712.81851 2113914.04057 37.7837534650339 -122.48277430520001 (37.7837534650339, -122.4827743052)
110346 114383 6 82 418X SERRANO DR 1 2 1 1     6     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
138436 114384 6 82 418X SERRANO DR 2 7 1 1     6     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
75524 120438 2 82 123 22nd Ave 1 1 1 1     6 Width 2ft   5988956.31634 2114501.1697400003 37.7853797200377 -122.48197492857099 (37.7853797200377, -122.481974928571)
156985 65109 1 82 145 22nd Ave 1 1 1 1 1 06/24/2000 12:00:00 AM 5   Permit Number 27078 5988958.234730001 2114388.99376 37.7850718280894 -122.481960071321 (37.7850718280894, -122.481960071321)
175706 64667 1 82 155 22nd Ave 1 1 1 1 1 07/24/1989 12:00:00 AM 7   Permit Number 27077 5988959.0752 2114316.0403299998 37.784871567471704 -122.48195181759701 (37.7848715674717, -122.481951817597)
135886 65108 1 82 183 22nd Ave 1 1 1 1 1 07/24/1989 12:00:00 AM 6   Permit Number 27075 5988968.22756 2114128.63613 37.7843575407485 -122.481906421224 (37.7843575407485, -122.481906421224)
81776 114391 6 82 23x PINTO AVE 2 7 1 1     7     5988521.0 2090808.0 37.720299292258794 -122.481744923362 (37.7202992922588, -122.481744923362)
93217 114390 6 82 23x PINTO AVE 1 7 1 1     7     5988521.0 2090808.0 37.720299292258794 -122.481744923362 (37.7202992922588, -122.481744923362)
51119 182028 2 82 2209 Irving St 1 1 1 1     7 Width 0ft   5988891.7451 2106459.406 37.7632955122177 -122.481609125496 (37.7632955122177, -122.481609125496)
139387 3372 1 82 5951 California St 1 1 1 1     8 3X3   5989085.57316 2113985.01381 37.7839700180526 -122.48148992901301 (37.7839700180526, -122.481489929013)
114129 101280 2 82 2201 Irving St 1 1 1 1       3x3   5988947.0 2106461.0 37.7633031017087 -122.48141813594201 (37.7633031017087, -122.481418135942)
73312 120776 2 82 57 21st Ave 3 1 1 1     4 Width 3ft   5989252.7771 2114825.68271 37.7862879782034 -122.48097304382 (37.7862879782034, -122.48097304382)
149008 120775 2 82 57 21st Ave 2 1 1 1     7 Width 3ft   5989253.50277 2114844.1258799997 37.7863386601165 -122.48097188408 (37.7863386601165, -122.48097188408)
28532 120778 2 82 57 21st Ave 5 1 1 1     8 Width 3ft   5989252.84217 2114809.1452099998 37.7862425746859 -122.480971607416 (37.7862425746859, -122.480971607416)
69793 120774 2 82 57 21st Ave 1 1 1 1     7 Width 3ft   5989253.85466 2114850.93568 37.7863573783569 -122.48097116542499 (37.7863573783569, -122.480971165425)
170056 120777 2 82 57 21st Ave 4 1 1 1     6 Width 3ft   5989253.41901 2114816.7810299997 37.786263574020204 -122.480970171004 (37.7862635740202, -122.480970171004)
70653 65118 1 82 127 21st Ave 1 1 1 1 1 07/24/1989 12:00:00 AM 4   Permit Number 27088 5989266.29156 2114491.8349900004 37.7853721122289 -122.480901836159 (37.7853721122289, -122.480901836159)
155477 65116 1 82 130 21st Ave 1 1 1 1 1 07/24/1989 12:00:00 AM 3   Permit Number 27086 5989313.29751 2114460.89745 37.7852898986689 -122.480736945877 (37.7852898986689, -122.480736945877)
161956 65112 1 82 367 21st Ave 1 1 1 1 1 07/24/1989 12:00:00 AM 9   Permit Number 27081 5989323.93516 2112879.29731 37.78094788727989 -122.48058432391001 (37.7809478872799, -122.48058432391)
46895 88581 1 82 515 21st Ave   1 1 1   07/31/2008 12:00:00 AM 5 3x3 Permit Number 51523 5989364.701169999 2111797.63767 37.777980320812 -122.480364100125 (37.777980320812, -122.480364100125)
27910 183007 2 82 2440 22nd Ave 1 1 1 1     5 Width 0ft   5989549.7088 2098739.1145 37.742135877465294 -122.478768805014 (37.7421358774653, -122.478768805014)
43050 83178 1 82 743 19th Ave 1 1 1 1   07/31/2008 12:00:00 AM 3 3x3 Permit Number 51518 5990037.32656 2110290.0684599997 37.7738800155956 -122.477927036337 (37.7738800155956, -122.477927036337)
157386 49548 1 82 2434@ TARAVAL 21st Ave 2 1 1 1   04/29/2003 12:00:00 AM 1   Permit Number 46439 5989857.9655 2098790.1552 37.742293916006 -122.47770669165199 (37.742293916006, -122.477706691652)
63407 49549 1 82 2434@ TARAVAL 21st Ave 1 1 1 1   04/29/2003 12:00:00 AM 3   Permit Number 46439 5989858.6972 2098774.0563 37.7422497550695 -122.47770298517 (37.7422497550695, -122.47770298517)
39644 121918 2 82 434 17th Ave 2 1 1 1     10 Width 1ft   5990628.47281 2112418.69115 37.7797589204997 -122.47603768167 (37.7797589204997, -122.47603768167)
176231 43755 1 82 264 16th Ave 1 1 1 1 1 07/26/2000 12:00:00 AM 3   Permit Number 43391 5990896.100380001 2113625.86147 37.783088990728004 -122.47520000357201 (37.783088990728, -122.475200003572)
127900 69289 1 82 1900 18th Ave 1 1 1 1 1 03/09/1994 12:00:00 AM     Permit Number 33361 5990665.04614057 2102443.50433652 37.7523718663796 -122.47518273070699 (37.7523718663796, -122.475182730707)
137292 56158 1 82 447 16th Ave 1 1 1 1   07/02/1973 12:00:00 AM 8   Permit Number 12266 5990893.795580001 2112339.9216299998 37.779558022090605 -122.475114071606 (37.7795580220906, -122.475114071606)
73880 122099 2 82 451 16th Ave 1 1 1 1     8 Width 3ft   5990895.26927 2112314.80254 37.7794891374062 -122.47510713931001 (37.7794891374062, -122.47510713931)
174380 56156 1 82 471 16th Ave 1 1 1 1   07/02/1973 12:00:00 AM 12   Permit Number 12264 5990899.19855 2112188.99411 37.779143929860204 -122.475084359841 (37.7791439298602, -122.475084359841)
20863 112866 2 82 750 VICENTE ST 3 1 1 1       3x3   5990595.0 2097751.0 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927)
99727 112868 2 82 750 VICENTE ST 5 1 1 1       3x3   5990595.0 2097751.0 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927)
107775 112864 2 82 750 VICENTE ST 1 1 1 1     8 3x3   5990595.0 2097751.0 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927)
109062 112867 2 82 750 VICENTE ST 4 1 1 1       3x3   5990595.0 2097751.0 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927)
109983 112869 2 82 750 VICENTE ST 6 1 1 1       3x3   5990595.0 2097751.0 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927)
114300 112865 2 82 750 VICENTE ST 2 1 1 1       3x3   5990595.0 2097751.0 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927)
169460 56218 1 82 475 16th Ave 1 1 1 1   07/03/1973 12:00:00 AM 9   Permit Number 12339 5990899.771790001 2112161.89837 37.779069565646 -122.475080398267 (37.779069565646, -122.475080398267)
162268 56219 1 82 479 16th Ave 1 1 1 1   07/03/1973 12:00:00 AM 6   Permit Number 12340 5990900.9414099995 2112135.93012 37.7789983317715 -122.475074455932 (37.7789983317715, -122.475074455932)
31313 56220 1 82 483 16th Ave 1 1 1 1   07/03/1973 12:00:00 AM 10   Permit Number 12342 5990901.62894 2112114.24855 37.7789388399986 -122.475070494342 (37.7789388399986, -122.475070494342)
34193 122096 2 82 515 16th Ave 1 1 1 1     9 Width 3ft   5990911.764769999 2111862.01127 37.778246853274105 -122.475017013162 (37.7782468532741, -122.475017013162)
135724 56157 1 82 474 16th Ave 1 1 1 1   07/02/1973 12:00:00 AM 9   Permit Number 12265 5990948.43736 2112161.09667 37.7790701847482 -122.474911987504 (37.7790701847482, -122.474911987504)
173179 122094 2 82 695 16th Ave 1 1 1 1     6 Width 3ft   5990954.58445 2110703.0239 37.775067073184296 -122.474784270445 (37.7750670731843, -122.474784270445)
109609 60149 1 82 1719 17th Ave 1 1 1 1 1 04/28/1982 12:00:00 AM     Permit Number 19680 5990880.97000409 2103694.68949662 37.755819804064394 -122.474527341121 (37.7558198040644, -122.474527341121)
128046 60143 1 82 1610 17th Ave 1 1 1 1 1 04/28/1982 12:00:00 AM     Permit Number 19673 5990907.91625844 2104426.54438296 37.7578308453136 -122.474487560238 (37.7578308453136, -122.474487560238)
100811 60145 1 82 1622 17th Ave 1 1 1 1 1 04/28/1982 12:00:00 AM     Permit Number 19675 5990910.59858922 2104348.57566212 37.757616919266 -122.474472593844 (37.757616919266, -122.474472593844)
96854 60150 1 82 1767 17th Ave 1 1 1 1 1 04/28/1982 12:00:00 AM     Permit Number 19681 5990891.54356846 2103381.184277 37.754959614042 -122.474467896907 (37.754959614042, -122.474467896907)
45337 213911 2 82 1767 17th Ave 1 1 1 1     8 Width 2ft   5990895.24857 2103389.01356 37.754981325851205 -122.474455655417 (37.7549813258512, -122.474455655417)
108707 60148 1 82 1718 17th Ave 1 1 1 1 1 04/28/1982 12:00:00 AM     Permit Number 19679 5990932.94045417 2103696.44229965 37.7558276278389 -122.47434774022301 (37.7558276278389, -122.474347740223)
Powered by Datasette · Query took 18.042ms · Data source: data.sfgov.org