sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5893 46201 1 82   1 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
9250 46200 1 82   2 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
49521 240131 2 82 0 Chattanooga St 3 1 1 1     11 Width 3ft   6004671.7789900005 2103561.17999 37.7562426115098 -122.426824733295 (37.7562426115098, -122.426824733295)
75125 240132 2 82 0 Chattanooga St 4 1 1 1     8 Width 3ft   6004672.38894 2103545.66672 37.7562000502026 -122.42682151911801 (37.7562000502026, -122.426821519118)
154817 240133 2 82 0 Chattanooga St 5 1 1 1     11 Width 3ft   6004672.52486 2103529.70008 37.756156217245604 -122.426819912015 (37.7561562172456, -122.426819912015)
87818 102145 2 82 0X Ford St 2 1 1 1     10 3x3   6003601.0 2105679.0 37.7619970392507 -122.430678972901 (37.7619970392507, -122.430678972901)
103400 102146 2 82 0X Ford St 3 1 1 1     12 3x3   6003601.0 2105679.0 37.7619970392507 -122.430678972901 (37.7619970392507, -122.430678972901)
114315 102144 2 82 0X Ford St 1 1 1 1     12 3x3   6003601.0 2105679.0 37.7619970392507 -122.430678972901 (37.7619970392507, -122.430678972901)
123602 120676 2 82 1 Ford St 1 1 1 1       3x3   6003502.0 2105614.0 37.7618129556584 -122.43101673587799 (37.7618129556584, -122.431016735878)
63119 213926 2 82 1 Hill Point Ave 1 1 1 1     8 Width 3ft   5996340.85636 2106804.33971 37.764672946334294 -122.45587018867501 (37.7646729463343, -122.455870188675)
131145 213991 2 82 1 Merced Ave 2 2 1 1     11 Width 3ft   5995344.90173 2100199.2685 37.7464798897511 -122.458836668093 (37.7464798897511, -122.458836668093)
19725 114507 2 82 10 LOMBARD ST 2 16 1 9       4x4   6011932.0 2120995.0 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468)
70153 179314 2 82 100 Hamilton St 2 1 1 1     8 Width 3ft   6009038.30764 2093734.4569599999 37.7295065063148 -122.411029655989 (37.7295065063148, -122.411029655989)
153317 179315 2 82 100 Hamilton St 3 1 1 1     11 Width 3ft   6009040.95061 2093717.83367 37.729461010514605 -122.411019345266 (37.7294610105146, -122.411019345266)
69300 179323 2 82 100 Merrill St 1 1 1 1     11 Width 3ft   6009520.85663 2094768.8785700002 37.7323738561678 -122.409434403484 (37.7323738561678, -122.409434403484)
179013 179324 2 82 100 Merrill St 2 1 1 1     8 Width 3ft   6009528.37304 2094747.8855599998 37.7323166349901 -122.409406936389 (37.7323166349901, -122.409406936389)
665 239151 3 82 100 Octavia St 2 4 1 2   04/15/2017 01:58:00 PM 3 Width 4ft   6005731.03459 2109700.90805 37.7731606839629 -122.423597962203 (37.7731606839629, -122.423597962203)
9603 19972 3 82 100 STAIRWAY44 3 1 1 2     3 36            
118366 67075 1 82 100 Tompkins Ave 1 1 1 1 1 12/09/1995 12:00:00 AM     Permit Number 30469 6007674.59209912 2096541.81182002 37.7371383234242 -122.41594289157601 (37.7371383234242, -122.415942891576)
178446 179313 2 82 100 Yale St 4 1 1 1     2 Width 3ft   6006918.398519999 2093488.03593 37.728710780776 -122.418340943684 (37.728710780776, -122.418340943684)
108008 14770 1 82 1000X McAllister St 5 1 1 21   02/06/2016 08:42:00 AM 3 4x4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288)
112538 14773 1 82 1000X McAllister St 8 1 1 21   05/13/1992 12:00:00 AM 6 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288)
52058 41522 1 82 1001 Mariposa St 1 1 1 1   04/20/2000 12:00:00 AM 3   Permit Number 42063 6014186.00908 2106172.78785 37.763946866973704 -122.39410383682 (37.7639468669737, -122.39410383682)
50254 213950 2 82 1006 Capitol Ave 1 1 1 1     4 Width 3ft   5995061.44128 2090626.04133 37.720177849497794 -122.459123753274 (37.7201778494978, -122.459123753274)
67006 240153 2 82 1008 Cole St 1 1 1 1     8 Width 3ft   5998136.29263 2106764.45676 37.764666319205205 -122.449657403985 (37.7646663192052, -122.449657403985)
91163 16010 3 82 100X Monterey Blvd 4 11 1 2     2 4   6001411.931226401 2094682.0759854 37.7316778334432 -122.437462576871 (37.7316778334432, -122.437462576871)
9197 24149 1 82 100X Whitney Young Cir 9 1 1 1   03/11/2006 12:00:00 AM 3 3x3   6016357.373923 2096088.8828188 37.736379006835996 -122.385890729183 (37.736379006836, -122.385890729183)
9227 24151 1 82 100X Whitney Young Cir 11 1 1 1   03/11/2006 12:00:00 AM 3 3x3   6016357.373923 2096088.8828188 37.736379006835996 -122.385890729183 (37.736379006836, -122.385890729183)
13371 24145 1 82 100X Whitney Young Cir 5 1 1 1     12 3x3   6016696.89665 2095171.76192 37.7338795595807 -122.384652980151 (37.7338795595807, -122.384652980151)
14904 24147 1 82 100X Whitney Young Cir 7 1 1 1     12 3x3   6016689.05107 2095205.54183 37.7339718785836 -122.384682457242 (37.7339718785836, -122.384682457242)
25564 197127 2 82 101 Newhall St 13 4 1 1     3 Width 3ft   6017303.080490001 2098110.9339400004 37.7419834431736 -122.382761660942 (37.7419834431736, -122.382761660942)
71194 60642 1 82 101 Randall St 1 1 1 1 1 02/12/1983 12:00:00 AM     Permit Number 20270 6004901.36876785 2097539.55337894 37.7397215914528 -122.425602180558 (37.7397215914528, -122.425602180558)
104065 41900 1 82 101 Scott St 1 1 1 1   06/20/2000 12:00:00 AM     Permit Number 42265 6002336.18060938 2108825.44123893 37.7705646588804 -122.43527855581301 (37.7705646588804, -122.435278555813)
152901 239239 2 82 101 Scott St 1 4 1 1     20 Width 6ft   6002329.06188 2108869.34471 37.7706848027038 -122.435306320439 (37.7706848027038, -122.435306320439)
167332 136212 2 82 101 Spruce St 3 2 1 1     7 Width 3ft   5997026.477630001 2115953.7993900003 37.7898342954728 -122.454159706 (37.7898342954728, -122.454159706)
178696 136211 2 82 101 Spruce St 2 2 1 1     9 Width 3ft   5997026.34564 2115964.00812 37.7898623183414 -122.454160900321 (37.7898623183414, -122.454160900321)
3419 252969 5 82 101 Whipple Ave 1 1 1 1           5998180.94106 2087280.50358 37.711170613109104 -122.448099970249 (37.7111706131091, -122.448099970249)
117175 5222 3 82 1010 Divisadero St 1 1 1 2   05/24/2014 12:00:00 AM 3 4x4   6001485.7958586 2111861.2482698997 37.7788518948545 -122.438437575376 (37.7788518948545, -122.438437575376)
48422 197116 2 82 1015 Rhode Island St 1 4 1 1     2 Width 3ft   6011950.215340001 2103491.63171 37.75646048668521 -122.40164836548 (37.7564604866852, -122.40164836548)
4061 252970 5 82 101X Whipple Ave 2 2 1 1   10/05/2017 12:21:00 PM 3              
14061 24180 3 82 101X Whitney Young Cir 13 1 1 2     30 3x3   6016621.33395 2095295.74377 37.7342158098126 -122.384922860422 (37.7342158098126, -122.384922860422)
14634 24178 3 82 101X Whitney Young Cir 11 1 1 2   02/15/2001 12:00:00 AM 4 4x3   6016619.186290001 2095310.93644 37.7342574070589 -122.384931343733 (37.7342574070589, -122.384931343733)
15041 24179 3 82 101X Whitney Young Cir 12 1 1 2   03/29/1990 12:00:00 AM 12 5x3   6016625.58798 2095312.02915 37.7342607615082 -122.38490928693199 (37.7342607615082, -122.384909286932)
64108 83143 2 82 101X Whitney Young Cir 2 1 1 1 1 03/17/2006 12:00:00 AM 1     6016637.512159999 2095504.68596 37.7347904181313 -122.384881478104 (37.7347904181313, -122.384881478104)
61184 197150 2 82 102 Whitney Young Cir 14 1 1 1     1 Width 3ft   6016678.04362 2095528.85162 37.7348590139212 -122.38474302838999 (37.7348590139212, -122.38474302839)
181078 239315 2 82 1024 Hampshire St 1 1 1 1     3 Width 3ft   6010214.49456 2103222.56761 37.7556246873555 -122.40763215850599 (37.7556246873555, -122.407632158506)
38315 179295 2 82 103 Edinburgh St 1 1 1 1     6 Width 3ft   6004297.98606 2093012.3139099998 37.727256697520204 -122.42736600014 (37.7272566975202, -122.42736600014)
23326 14782 3 82 1037 McAllister St 1 1 1 2     11 4X4   6004198.5372 2111824.0669 37.7789037342236 -122.429050478372 (37.7789037342236, -122.429050478372)
98801 14783 3 82 1037 McAllister St 2 1 1 2     12 4X4   6004216.0719046 2111827.8420520998 37.7789150924062 -122.42899008807801 (37.7789150924062, -122.428990088078)
87312 24482 3 82 103X Sussex St 2 1 1 2     6 3X3   6002240.5138934 2096668.0977393002 37.7371780656004 -122.434739971035 (37.7371780656004, -122.434739971035)
170019 141931 2 82 1050 MCALLISTER ST 6 1 1 1     5 Width 0ft   6004116.6344 2111867.0624 37.7790171527246 -122.42933687953999 (37.7790171527246, -122.42933687954)
185979 141928 2 82 1050 MCALLISTER ST 3 1 1 1     7 Width 0ft   6004234.8996 2111882.5726 37.779066434664294 -122.428928858602 (37.7790664346643, -122.428928858602)
40781 101046 2 82 1050 Sansome St 1 1 1 1     1 3x3 Permit Number 774347 6012049.4869099995 2119300.00717 37.799872179210894 -122.40241656909201 (37.7998721792109, -122.402416569092)
87927 101047 1 82 1050 Sansome St 2 1 1 1   12/18/2014 12:00:00 AM 3 3x3 Permit Number 774347 6012043.0 2119296.0 37.799860814363 -122.40243873444099 (37.799860814363, -122.402438734441)
114943 61792 1 82 1053 De Haro St 1 1 1 1 1 01/26/1985 12:00:00 AM     Permit Number 21815 6012220.91982442 2103494.12981341 37.7564824480415 -122.400712343497 (37.7564824480415, -122.400712343497)
9055 24107 1 82 105X Whitney Young Cir 14 1 1 1   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.0813580002 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885)
9206 24109 1 82 105X Whitney Young Cir 16 1 1 1   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.0813580002 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885)
103685 24094 3 82 105X Whitney Young Cir 1 1 1 2   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.0813580002 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885)
109191 24106 3 82 105X Whitney Young Cir 13 1 1 2   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.0813580002 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885)
139566 24098 3 82 105X Whitney Young Cir 5 1 1 2   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.0813580002 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885)
85171 60613 1 82 106 Randall St 1 1 1 1 1 02/12/1983 12:00:00 AM     Permit Number 20237 6004863.02785957 2097589.48802411 37.7398565341458 -122.425738300436 (37.7398565341458, -122.425738300436)
33428 197157 2 82 106 Whitney Young Cir 5 1 1 1     1 Width 3ft   6016598.7871900005 2095669.6865 37.7352413346217 -122.385026857123 (37.7352413346217, -122.385026857123)
173068 197158 2 82 106 Whitney Young Cir 6 1 1 1     2 Width 3ft   6016583.16711 2095682.22839 37.7352749081106 -122.385081735533 (37.7352749081106, -122.385081735533)
23128 4406 3 82 1060 Church St 1 1 1 2     10 3X3   6004384.57785 2102734.51473 37.7539565402887 -122.42775907492799 (37.7539565402887, -122.427759074928)
29544 213971 2 82 1061 Capitol Ave 4 1 1 1     10 Width 3ft   5995026.07265 2091112.6142099998 37.7215118291791 -122.459281227253 (37.7215118291791, -122.459281227253)
33788 213974 2 82 1061 Capitol Ave 7 1 1 1     7 Width 3ft   5995026.3935 2091022.299 37.7212638636298 -122.459273581222 (37.7212638636298, -122.459273581222)
36604 213973 2 82 1061 Capitol Ave 6 1 1 1     13 Width 3ft   5995027.24606 2091045.4090900002 37.721327367434604 -122.459272306869 (37.7213273674346, -122.459272306869)
59382 213975 2 82 1061 Capitol Ave 8 1 1 1     11 Width 3ft   5995024.51997 2091003.2487299999 37.7212114484221 -122.45927867859501 (37.7212114484221, -122.459278678595)
69936 213969 2 82 1061 Capitol Ave 2 1 1 1     9 Width 3ft   5995027.18674 2091165.82123 37.7216579869959 -122.459281227274 (37.7216579869959, -122.459281227274)
71421 213970 2 82 1061 Capitol Ave 3 1 1 1     6 Width 3ft   5995027.09423 2091143.79671 37.721597507607996 -122.45927995292699 (37.721597507608, -122.459279952927)
124104 213976 2 82 1061 Capitol Ave 9 1 1 1     11 Width 3ft   5995023.46765 2090970.5982400002 37.7211217374705 -122.459279952923 (37.7211217374705, -122.459279952923)
172877 213968 2 82 1061 Capitol Ave 1 1 1 1     10 Width 3ft   5995026.496169999 2091185.65951 37.7217124184688 -122.459285050266 (37.7217124184688, -122.459285050266)
177551 213972 2 82 1061 Capitol Ave 5 1 1 1     11 Width 3ft   5995029.65711 2091072.52436 37.721401958108295 -122.459265935174 (37.7214019581083, -122.459265935174)
143372 91610 3 82 1068 South Van Ness Ave   1 1 2   02/19/2016 08:13:00 AM 3 3x3   6007601.453035 2103438.871938 37.7560719916571 -122.416684224173 (37.7560719916571, -122.416684224173)
30190 136213 2 82 107 Spruce St 2 1 1 1     10 Width 3ft   5997027.70911 2115921.73522 37.78974632646779 -122.45415312837099 (37.7897463264678, -122.454153128371)
169703 36194 1 82 107 Spruce St 1 1 1 1     10   Permit Number 39260 5997029.24357 2115938.23155 37.7897917089598 -122.454149011282 (37.7897917089598, -122.454149011282)
53523 48812 1 82 1082Street Pennsylvania Ave 2 1 1 1   11/06/2002 12:00:00 AM 5   Permit Number 46042 6014467.053730001 2102353.10418 37.753474456898104 -122.392864530587 (37.7534744568981, -122.392864530587)
79486 48797 1 82 1082Street Pennsylvania Ave 17 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
79749 48808 1 82 1082Street Pennsylvania Ave 7 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
80482 48805 1 82 1082Street Pennsylvania Ave 10 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
87368 48795 1 82 1082Street Pennsylvania Ave 15 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
93668 48814 1 82 1082Street Pennsylvania Ave 24 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
93881 48807 1 82 1082Street Pennsylvania Ave 8 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
95001 48798 1 82 1082Street Pennsylvania Ave 20 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
97538 48793 1 82 1082Street Pennsylvania Ave 13 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
103218 48813 1 82 1082Street Pennsylvania Ave 19 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
105017 48796 1 82 1082Street Pennsylvania Ave 16 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
107290 48806 1 82 1082Street Pennsylvania Ave 9 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
112016 48804 1 82 1082Street Pennsylvania Ave 11 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
113270 48802 1 82 1082Street Pennsylvania Ave 12 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
114793 48794 1 82 1082Street Pennsylvania Ave 14 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
116610 48792 1 82 1082Street Pennsylvania Ave 23 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
119141 48803 1 82 1082Street Pennsylvania Ave 18 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
124980 48800 1 82 1082Street Pennsylvania Ave 21 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
127193 48801 1 82 1082Street Pennsylvania Ave 22 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
147265 48809 1 82 1082Street Pennsylvania Ave 6 1 1 1   11/06/2002 12:00:00 AM 3   Permit Number 46042 6014468.625469999 2102279.9042599997 37.753273552832205 -122.392853974356 (37.7532735528322, -122.392853974356)
150866 48811 1 82 1082Street Pennsylvania Ave 4 1 1 1   11/06/2002 12:00:00 AM 7   Permit Number 46042 6014468.770930001 2102318.37211 37.7533791854235 -122.392856162375 (37.7533791854235, -122.392856162375)
151589 48815 1 82 1082Street Pennsylvania Ave 3 1 1 1   11/06/2002 12:00:00 AM 5   Permit Number 46042 6014467.97393 2102326.82142 37.7534023411579 -122.392859509671 (37.7534023411579, -122.392859509671)
151617 48799 1 82 1082Street Pennsylvania Ave 1 1 1 1   11/06/2002 12:00:00 AM 5   Permit Number 46042 6014465.83632 2102364.69447 37.753506213741396 -122.392869551502 (37.7535062137414, -122.392869551502)
161197 48810 1 82 1082Street Pennsylvania Ave 5 1 1 1   11/06/2002 12:00:00 AM 5   Permit Number 46042 6014469.89088 2102291.4479400003 37.753305319601495 -122.392850405821 (37.7533053196015, -122.392850405821)
41318 240143 2 82 109 Cole St 1 1 1 1     10 Width 2ft   5998171.35185 2106192.58759 37.763098116497204 -122.449494935145 (37.7630981164972, -122.449494935145)
Powered by Datasette · Query took 19.054ms · Data source: data.sfgov.org