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)
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)
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)
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)
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)
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              
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)
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)
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)
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)
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)
70424 124324 2 82 109 Jordan Ave 2 9 1 1     9 Width 3ft   5996182.48161 2113700.3553299997 37.7835985094544 -122.45691677945 (37.7835985094544, -122.45691677945)
4074 252967 5 82 109 Whipple Ave 1 1 1 1   10/05/2017 01:55:00 PM 3     5998144.81293 2087318.48212 37.7112728281964 -122.448227570418 (37.7112728281964, -122.448227570418)
27161 197088 2 82 1098 Pennsylvania Ave 6 9 1 1     5 Width 5ft   6014473.69906 2102184.6927400003 37.753012404101 -122.39282976818998 (37.753012404101, -122.39282976819)
36178 197095 2 82 1098 Pennsylvania Ave 13 9 1 1     4 Width 5ft   6014479.30677 2102077.89395 37.7527194688438 -122.39280290452601 (37.7527194688438, -122.392802904526)
41596 197086 2 82 1098 Pennsylvania Ave 4 9 1 1     6 Width 5ft   6014471.44073 2102209.38753 37.7530800852958 -122.39283930551599 (37.7530800852958, -122.392839305516)
45418 197094 2 82 1098 Pennsylvania Ave 12 9 1 1     5 Width 5ft   6014478.47867 2102089.9100099998 37.7527524163908 -122.392806608832 (37.7527524163908, -122.392806608832)
62833 197084 2 82 1098 Pennsylvania Ave 2 9 1 1     6 Width 5ft   6014468.76337 2102245.03022 37.753177803814 -122.39285105782801 (37.753177803814, -122.392851057828)
134469 197089 2 82 1098 Pennsylvania Ave 7 9 1 1     7 Width 5ft   6014473.51573 2102162.27258 37.7529508329366 -122.39282883379101 (37.7529508329366, -122.392828833791)
149097 197092 2 82 1098 Pennsylvania Ave 10 9 1 1     5 Width 5ft   6014476.97343 2102121.40509 37.752838811567 -122.392814017467 (37.752838811567, -122.392814017467)
157085 197085 2 82 1098 Pennsylvania Ave 3 9 1 1     7 Width 5ft   6014468.858580001 2102236.49554 37.7531543746906 -122.392850131521 (37.7531543746906, -122.392850131521)
160169 197087 2 82 1098 Pennsylvania Ave 5 9 1 1     5 Width 5ft   6014472.10243 2102198.29911 37.753049675611 -122.39283624152 (37.753049675611, -122.39283624152)
170402 197083 2 82 1098 Pennsylvania Ave 1 9 1 1     6 Width 5ft   6014468.24915 2102256.69833 37.7532098133945 -122.392853652369 (37.7532098133945, -122.392853652369)
171068 197090 2 82 1098 Pennsylvania Ave 8 9 1 1     7 Width 5ft   6014474.311480001 2102148.65752 37.752913493081294 -122.39282512948 (37.7529134930813, -122.39282512948)
181135 197093 2 82 1098 Pennsylvania Ave 11 9 1 1     6 Width 5ft   6014477.98301 2102105.11898 37.7527941494528 -122.392809386851 (37.7527941494528, -122.392809386851)
181973 197091 2 82 1098 Pennsylvania Ave 9 9 1 1     7 Width 5ft   6014475.63706 2102134.7648099996 37.7528754202862 -122.39281957348601 (37.7528754202862, -122.392819573486)
43382 246032 2 82 11 Belvedere St 1 1 1 1     1 Width 0ft   5998172.7746 2108470.8044 37.7693536035765 -122.44965419238501 (37.7693536035765, -122.449654192385)
36414 136262 2 82 11 Filbert St 7 2 1 1     7     6012539.8548099995 2120210.2855 37.8023989459081 -122.400783688018 (37.8023989459081, -122.400783688018)
77015 197152 2 82 11 Jakey Ct 1 1 1 1     3 Width 3ft   6016707.19345 2095564.5930700002 37.734958764918396 -122.384644735176 (37.7349587649184, -122.384644735176)
Powered by Datasette · Query took 13.194ms · Data source: data.sfgov.org