sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
127181 103126 1 17 1020 Guerrero St 2 1 1 1 4 03/22/2013 12:00:00 AM   3x3 Permit Number 769235 6005624.5 2103007.3 37.7547756072831 -122.423490517587 (37.7547756072831, -122.423490517587)
90552 47255 3 2 1035 Gilman Ave 4 1 1 4 4 05/09/2002 12:00:00 AM 6 3x3 Permit Number 45198 6015368.10493708 2089617.80548286 37.71855592189279 -122.388859444456 (37.7185559218928, -122.388859444456)
85143 115005 5 16 1050 MCALLISTER ST 2 8 1 21 4     3x3   6004148.0 2111858.0 37.778994045300706 -122.42922772691401 (37.7789940453007, -122.429227726914)
106272 115004 5 80 1050 MCALLISTER ST 1 8 1 21 4 01/19/2016 09:19:00 AM 3 3x3   6004148.0 2111858.0 37.778994045300706 -122.42922772691401 (37.7789940453007, -122.429227726914)
89333 104727 1 90 1079 Church St 1 1 1 1 4     3x3 Permit Number 770313 6004450.0 2102615.0 37.7536320814231 -122.427524315639 (37.7536320814231, -122.427524315639)
81591 95239 2 26 1220 Noe St 6 1 1 4 4   12     6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
95002 95237 2 26 1220 Noe St 4 1 1 4 4   9 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
107934 95238 2 26 1220 Noe St 5 1 1 4 4     3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
117440 95240 2 26 1220 Noe St 7 1 1 4 4   12 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
120777 95241 2 26 1220 Noe St 8 1 1 4 4   3 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
121486 95235 2 26 1220 Noe St 1 1 1 4 4   3 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
142420 95236 2 26 1220 Noe St 2 1 1 4 4   12 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
3158 253097 6 3 1290 Portola Dr 1 9 1 1 4 08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
22149 16024 1 11 130 Monterey Blvd 1 1 1 1 4 12/29/2015 12:00:00 AM 3 3X3 Permit Number 776129 6001188.36813 2094689.80455 37.731686341545206 -122.43823603107799 (37.7316863415452, -122.438236031078)
7506 14836 1 21 1300 McAllister St 1 1 1 1 4 10/22/2008 12:00:00 AM 9 3X3   6002892.8097 2111692.1261 37.7784674596438 -122.43355807318501 (37.7784674596438, -122.433558073185)
12092 77648 3 55 1300X Silliman St 9 1 1 4 4 01/01/2011 12:00:00 AM 3 3x3   6006817.147419999 2093142.9824700002 37.727757638780204 -122.418666516263 (37.7277576387802, -122.418666516263)
87235 117162 2 5 1383X VERMONT ST 2 8 1 1 4         6011571.0 2102081.0 37.752566033842896 -122.40286062573799 (37.7525660338429, -122.402860625738)
463 234072 3 26 1400 San Bruno Ave 2 1 1 4 4   4 Width 3ft   6011140.67766 2101759.7310900004 37.7516598624171 -122.404326151746 (37.7516598624171, -122.404326151746)
113857 97066 3 11 1599X Newcomb Ave 7 1 1 4 4   10 3x3   6015231.1 2095663.5 37.7351486000155 -122.38975506041099 (37.7351486000155, -122.389755060411)
77875 106884 2 53 180X SAN MARCOS AVE 6 11 1 1 4   4     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
94262 106880 2 53 180X SAN MARCOS AVE 3 11 1 1 4   5     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
108228 106878 2 3 180X SAN MARCOS AVE 1 11 1 1 4   26     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
114247 106879 2 126 180X SAN MARCOS AVE 2 11 1 1 4   6     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
125523 106883 2 53 180X SAN MARCOS AVE 4 11 1 1 4   4     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
94772 98675 1 17 199X Park St 1 1 1 4 4         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
85658 96467 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
89325 96464 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
103701 96466 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
110539 14250 1 15 2001 Market St 6 1 1 1 4 05/20/2011 12:00:00 AM 0 3x3 Permit Number 767173 6004759.8459002 2108188.2274393 37.7689523618819 -122.426849682313 (37.7689523618819, -122.426849682313)
115707 96469 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
120725 96465 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
124890 96470 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
140589 14248 1 15 2001 Market St 4 1 1 1 4 05/20/2011 12:00:00 AM 0 3x3 Permit Number 767173 6004759.8459002 2108188.2274393 37.7689523618819 -122.426849682313 (37.7689523618819, -122.426849682313)
144888 96468 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
26614 98657 1 55 2110 Greenwich St 11 1 1 4 4   11 5x5   6002607.56666 2119218.5959900003 37.7991170337862 -122.43508328318701 (37.7991170337862, -122.435083283187)
31571 98656 1 55 2110 Greenwich St 10 1 1 4 4   8 5x5   6002629.88193 2119221.45898 37.799126161900396 -122.435006269744 (37.7991261619004, -122.435006269744)
33915 98646 1 55 2110 Greenwich St 3 1 1 4 4   8 5x5   6002771.23879 2119243.65965 37.799195144410795 -122.43451871576099 (37.7991951444108, -122.434518715761)
44207 98648 1 55 2110 Greenwich St 5 1 1 4 4   9 5x5   6002730.0885 2119237.75472 37.7991765949935 -122.434660687245 (37.7991765949935, -122.434660687245)
53064 98650 1 55 2110 Greenwich St 7 1 1 4 4   11 5x5   6002693.158 2119231.9709099997 37.799158617543604 -122.43478806542801 (37.7991586175436, -122.434788065428)
69128 98649 1 55 2110 Greenwich St 6 1 1 4 4   16 5x5   6002707.76445 2119233.0203 37.799162328147794 -122.434737597267 (37.7991623281478, -122.434737597267)
71504 98651 1 32 2110 Greenwich St 8 1 1 4 4   23 5x5   6002674.17203 2119228.66956 37.799148474973705 -122.434853527066 (37.7991484749737, -122.434853527066)
74427 67860 1 55 2110 Greenwich St 1 1 1 4 4 01/20/1993 12:00:00 AM 5 5x5 Permit Number 31536 6002806.21719 2119247.92289 37.7992088356751 -122.43439798360501 (37.7992088356751, -122.434397983605)
105652 98659 1 43 2110 Greenwich St 13 1 1 4 4   20 7x7   6002683.8 2119245.6 37.799195508176105 -122.434821422435 (37.7991955081761, -122.434821422435)
111283 98658 3 17 2110 Greenwich St 12 1 1 4 4 06/20/2014 12:00:00 AM   6x6 Permit Number 772915 6002683.8 2119245.6 37.799195508176105 -122.434821422435 (37.7991955081761, -122.434821422435)
131687 98655 1 55 2110 Greenwich St 9 1 1 4 4   6 5x5   6002650.75991 2119226.56813 37.799141375727295 -122.434934390513 (37.7991413757273, -122.434934390513)
153048 98645 1 55 2110 Greenwich St 2 1 1 4 4   9 5x5   6002788.88101 2119245.38589 37.799200885676605 -122.434457791187 (37.7992008856766, -122.434457791187)
161870 98647 1 55 2110 Greenwich St 4 1 1 4 4   12 5x5   6002751.94545 2119240.19821 37.7991845449763 -122.434585229619 (37.7991845449763, -122.434585229619)
96184 102636 1 26 2176 Mission St 2 1 1 1 4 02/08/2013 12:00:00 AM 3 5x5 Permit Number 769974 6006850.0 2105688.0 37.7622052831774 -122.41944256138001 (37.7622052831774, -122.41944256138)
109180 102635 1 26 2176 Mission St 1 1 1 1 4 02/08/2013 12:00:00 AM 3 5x5 Permit Number 769974 6006850.0 2105688.0 37.7622052831774 -122.41944256138001 (37.7622052831774, -122.41944256138)
87567 100981 3 468 2190 Powell St 2 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
89035 100982 3 468 2190 Powell St 3 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
97910 100983 3 16 2190 Powell St 4 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
107842 100984 3 16 2190 Powell St 5 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
119959 100985 3 18 2190 Powell St 6 1 1 4 4 03/23/2016 02:34:00 PM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
140818 100980 3 468 2190 Powell St 1 1 1 4 4 05/03/2013 12:00:00 AM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
145388 100987 3 16 2190 Powell St 8 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
621 251339 1 51 2230 Ocean Ave 3 1 1 1 4 05/28/2012 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
10038 96503 3 150 2360X Harrison St 4 1 1 4 4     3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
69366 93014 1 79 2395 Lombard St 4 1 1 1 4 01/08/2010 12:00:00 AM 3 4x4 Permit Number 53139; 3-year maintenance agreement through 12/29/12 6001021.4146 2119265.9756 37.7991569323377 -122.440575294128 (37.7991569323377, -122.440575294128)
109229 93013 1 11 2395 Lombard St 1 1 1 1 4 01/08/2010 12:00:00 AM 3 4x4 Permit Number 53139; 3-year maintenance agreement through 12/29/12 6000915.0 2119261.0 37.7991372104515 -122.440943166878 (37.7991372104515, -122.440943166878)
171968 93015 1 79 2395 Lombard St 5 1 1 1 4 01/08/2010 12:00:00 AM 3 4x4 Permit Number 53139; 3-year maintenance agreement through 12/29/12 6001036.8533 2119267.6007 37.7991622735558 -122.440521987709 (37.7991622735558, -122.440521987709)
118370 97563 3 223 250 Divisadero St 1 1 1 1 4 09/21/2015 12:00:00 AM 3 5x5   6001845.0 2109086.0 37.771252182937296 -122.436996208247 (37.7712521829373, -122.436996208247)
80719 116576 6 40 2500x OCEAN AVE 1 9 1 6 4   30 10X10   5991377.0 2094742.0 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256)
61687 97564 3 223 252 Divisadero St 1 1 1 1 4   3     6001879.6 2109184.5 37.7715246060424 -122.43688357823 (37.7715246060424, -122.43688357823)
100514 97565 3 223 258 Divisadero St 1 1 1 1 4   3     6001879.6 2109184.5 37.7715246060424 -122.43688357823 (37.7715246060424, -122.43688357823)
18577 5154 3 9 259 Divisadero St 1 1 1 1 4   3 3X3   6001780.9624 2109220.4101 37.771617599631604 -122.43722734206499 (37.7716175996316, -122.437227342065)
20046 5155 3 9 265 Divisadero St 1 1 1 1 4 12/17/2001 12:00:00 AM 3 3X3   6001777.3063 2109242.3472 37.7716776256193 -122.43724155970399 (37.7716776256193, -122.437241559704)
9684 173630 6 1 2699x OCEAN AVE 2 5 1 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
114895 116578 6 1 2699x OCEAN AVE 1 5 1 6 4   11 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
116328 5157 3 223 270 Divisadero St 2 1 1 1 4   0     6001849.8958745 2109240.8779841997 37.7716777176824 -122.43699036314301 (37.7716777176824, -122.436990363143)
18219 5158 3 9 275 Divisadero St 1 1 1 1 4 03/27/1990 12:00:00 AM 3 3X3   6001773.6501 2109268.6052 37.771749515715605 -122.437256087151 (37.7717495157156, -122.437256087151)
101889 95411 1 20 2815 Diamond St 1 1 1 1 4   1 3x3 Planted by Glen Park Library; will become DPW maintained. 6002467.0 2095594.0 37.734241695714005 -122.43388015504499 (37.734241695714, -122.433880155045)
120383 95412 1 20 2815 Diamond St 3 1 1 1 4   1 3x3 Planted by Glen Park Public Library; will become DPW maintained after it is established. 6002467.0 2095594.0 37.734241695714005 -122.43388015504499 (37.734241695714, -122.433880155045)
108200 97586 3 223 285 Divisadero St 1 1 1 1 4   3     6001769.0 2109329.0 37.771915080469 -122.437276497302 (37.771915080469, -122.437276497302)
1685 251478 1 15 2x Virginia Ave 2 1 1 1 4 02/21/2004 12:00:00 AM   3x3   6006146.0 2098692.0 37.7429562000135 -122.42138058886101 (37.7429562000135, -122.421380588861)
28447 116579 6 98 3000x 19TH AVE 2 5 1 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
120634 116580 6 98 3000x 19TH AVE 3 5 2 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
126456 116577 6 98 3000x 19TH AVE 1 5 1 6 4   30 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
83032 28101 3 223 305 Divisadero St 1 1 1 1 4   3 3X3   6001749.0605888 2109439.6370142 37.7722177286516 -122.437353392664 (37.7722177286516, -122.437353392664)
52422 34688 1 55 3101X Webster St 2 1 1 4 4 07/28/1997 12:00:00 AM 7 3x3 Permit Number 38352 6002815.38185 2119347.35443 37.7994823689702 -122.434373383533 (37.7994823689702, -122.434373383533)
61243 34693 1 55 3101X Webster St 1 1 1 4 4 07/28/1997 12:00:00 AM 9 3x3 Permit Number 38352 6002813.73545 2119366.57801 37.799535058456 -122.43438045581301 (37.799535058456, -122.434380455813)
73429 34690 1 55 3101X Webster St 4 1 1 4 4 07/28/1997 12:00:00 AM 8 3x3 Permit Number 38352 6002819.05677 2119313.26082 37.7993889653989 -122.434358228162 (37.7993889653989, -122.434358228162)
133902 34692 1 55 3101X Webster St 6 1 1 4 4 07/28/1997 12:00:00 AM 9 3x3 Permit Number 38352 6002825.2019 2119271.55666 37.7992748054477 -122.434333980647 (37.7992748054477, -122.434333980647)
166994 34691 1 55 3101X Webster St 5 1 1 4 4 07/28/1997 12:00:00 AM 10 3x3 Permit Number 38352 6002820.98316 2119293.45008 37.7993346796145 -122.43435014504699 (37.7993346796145, -122.434350145047)
176592 34689 1 55 3101X Webster St 3 1 1 4 4 07/28/1997 12:00:00 AM 5 3x3 Permit Number 38352 6002816.77257 2119329.88091 37.79943447017929 -122.434367321195 (37.7994344701793, -122.434367321195)
17669 5170 3 223 318 Divisadero St 1 1 1 1 4 02/15/2005 12:00:00 AM 3 3X3   6001801.5136 2109559.6859 37.7725503347821 -122.43718055043101 (37.7725503347821, -122.437180550431)
118803 97587 3 223 319 Divisadero St 1 1 1 1 4   3     6001745.0 2109492.0 37.772361273527004 -122.437371188758 (37.772361273527, -122.437371188758)
80527 97588 3 223 327 Divisadero St 1 1 1 1 4   3     6001736.6 2109522.6 37.7724448159613 -122.437402436672 (37.7724448159613, -122.437402436672)
88343 97566 3 223 338 Divisadero St 1 1 1 1 4   3     6001793.0 2109569.0 37.7725754250276 -122.437210666805 (37.7725754250276, -122.437210666805)
113485 97567 3 223 342 Divisadero St 1 1 1 1 4   3     6001791.0 2109583.0 37.772613751849605 -122.43721858759199 (37.7726137518496, -122.437218587592)
63146 75990 2 273 350 Broadway 1 1 1 4 4 10/07/1995 12:00:00 AM 3 3x3   6011912.57037 2118781.03793 37.7984395708796 -122.40285383475599 (37.7984395708796, -122.402853834756)
17572 5174 3 9 350 Divisadero St 1 1 1 1 4 11/28/2006 12:00:00 AM 3 3x4   6001785.2321 2109677.0482 37.7728716568906 -122.437245274575 (37.7728716568906, -122.437245274575)
1493 103663 2 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
5598 103666 2 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7681 103657 6 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7764 103662 2 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8197 103668 6 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8408 103664 2 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
10665 103665 2 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11212 103658 6 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11415 103667 2 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
Powered by Datasette · Query took 3.77ms · Data source: data.sfgov.org