sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
8128 87100 1 3 700 Connecticut St 1 7 1 3       3x3 Permit Number 50056          
11793 120892 2 37 201 Leland Ave 8 1 1 3     6 3x3   6009904.76 2087542.3079 37.7125527002168 -122.407597819442 (37.7125527002168, -122.407597819442)
128075 120885 2 35 201 Leland Ave 1 1 1 3       3x3   6009830.0 2087548.0 37.7125641444482 -122.407856615551 (37.7125641444482, -122.407856615551)
63534 120891 2 35 201 Leland Ave 7 1 1 3     1 3x3   6009886.0438 2087551.2204 37.71257612443421 -122.407663136759 (37.7125761244342, -122.407663136759)
149958 120890 2 35 201 Leland Ave 6 1 1 3     1 3x3   6009870.8927 2087557.0134 37.71259118267999 -122.40771591213999 (37.71259118268, -122.40771591214)
74957 120889 2 35 201 Leland Ave 5 1 1 3     1 3x3   6009853.959 2087561.9153 37.71260369432971 -122.407774785999 (37.7126036943297, -122.407774785999)
61322 120888 2 35 201 Leland Ave 4 1 1 3     1 3x3   6009826.3305 2087573.9471 37.7126351844606 -122.40787112709101 (37.7126351844606, -122.407871127091)
56141 120887 2 35 201 Leland Ave 3 1 1 3     1 3x3   6009811.6249 2087578.8489 37.7126478205015 -122.407922299954 (37.7126478205015, -122.407922299954)
187851 120886 2 35 201 Leland Ave 2 1 1 3     1 3x3   6009795.1369 2087583.7508 37.712660357001795 -122.40797963340599 (37.7126603570018, -122.407979633406)
82737 106281 2 474 399X Elliot St 2 14 1 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
95834 106280 2 474 399X Elliot St 1 14 1 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
119057 106282 2 474 399X Elliot St 3 14 1 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
21616 25457 1 37 100 Randolph St 2 1 1 3   12/10/1997 12:00:00 AM 6 3X3   5993681.7949 2088543.8714 37.7143812997511 -122.463741645146 (37.7143812997511, -122.463741645146)
21638 18577 1 37 100 Randolph St 1 1 1 3   10/12/1998 12:00:00 AM 6 3X3   5993712.2633 2088544.8235 37.7143856696584 -122.46363640417201 (37.7143856696584, -122.463636404172)
98945 116341 2 54 201X Bright St 2 1 1 3           5993755.0695 2088847.02637 37.715217913096104 -122.463510368547 (37.7152179130961, -122.463510368547)
119252 116340 2 54 201X Bright St 1 1 1 3           5993755.0695 2088847.02637 37.715217913096104 -122.463510368547 (37.7152179130961, -122.463510368547)
89080 106004 2 103 695X CAMPBELL AVE   19 1 3           6009136.9 2088912.4 37.716271678506 -122.41034847162202 (37.716271678506, -122.410348471622)
18684 109456 1 17 951 GILMAN AVE 1 7 1 3   03/24/2015 12:00:00 AM 3   Permit Number 774986 6015934.0 2089205.0 37.717453787650705 -122.38687458595501 (37.7174537876507, -122.386874585955)
85033 109457 2 279 951 GILMAN AVE 43 7 1 3     23     6015934.0 2089205.0 37.717453787650705 -122.38687458595501 (37.7174537876507, -122.386874585955)
115560 109453 1 47 951 GILMAN AVE 1 7 1 3   03/24/2015 12:00:00 AM 3   Permit Number 774986 6015934.0 2089205.0 37.717453787650705 -122.38687458595501 (37.7174537876507, -122.386874585955)
51128 25415 1 12 895X Mansell St 5 1 1 3   07/19/1996 12:00:00 AM 9 3X3   6009314.2175931 2089925.7733477 37.719064130172 -122.409807064317 (37.719064130172, -122.409807064317)
99275 25419 1 12 895X Mansell St 9 1 1 3   07/19/1996 12:00:00 AM 3 3X3   6009314.2175931 2089925.7733477 37.719064130172 -122.409807064317 (37.719064130172, -122.409807064317)
106691 25411 1 2 895X Mansell St 1 1 1 3     12 3X3   6009314.2175931 2089925.7733477 37.719064130172 -122.409807064317 (37.719064130172, -122.409807064317)
110546 25416 1 2 895X Mansell St 6 1 1 3     18 3X3   6009314.2175931 2089925.7733477 37.719064130172 -122.409807064317 (37.719064130172, -122.409807064317)
112727 25417 1 2 895X Mansell St 7 1 1 3     12 3X3   6009314.2175931 2089925.7733477 37.719064130172 -122.409807064317 (37.719064130172, -122.409807064317)
116369 25413 1 12 895X Mansell St 3 1 1 3   07/28/1996 12:00:00 AM 3 3X3   6009314.2175931 2089925.7733477 37.719064130172 -122.409807064317 (37.719064130172, -122.409807064317)
138721 25414 1 12 895X Mansell St 4 1 1 3   07/19/1996 12:00:00 AM 9 3X3   6009314.2175931 2089925.7733477 37.719064130172 -122.409807064317 (37.719064130172, -122.409807064317)
78664 13380 1 12 1000X Mansell St 6 1 1 3     3 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
86895 13384 1 108 1000X Mansell St 10 1 1 3     12 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
92208 13378 1 12 1000X Mansell St 4 1 1 3   01/13/2000 12:00:00 AM 3 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
108952 13376 1 2 1000X Mansell St 2 1 1 3     6 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
109944 13381 1 2 1000X Mansell St 7 1 1 3     18 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
113947 13383 1 2 1000X Mansell St 9 1 1 3     18 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
119188 13379 1 12 1000X Mansell St 5 1 1 3     3 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
126625 13385 1 12 1000X Mansell St 11 1 1 3     3 3X3   6008956.780581599 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527)
181298 97892 1 12 401x Russia Ave 1 1 1 3   03/02/2010 12:00:00 AM 8 3x3 Permit Number 55034 6002514.74306 2090342.41745 37.7198247442045 -122.433339952791 (37.7198247442045, -122.433339952791)
95903 97893 1 12 401x Russia Ave 2 1 1 3   03/02/2010 12:00:00 AM   3x3 Permit Number 55034 6002347.5 2090445.5 37.72009829646 -122.433925417029 (37.72009829646, -122.433925417029)
94686 25454 1 12 595X Geneva Ave 5 1 1 3   06/28/1996 12:00:00 AM 12 2X3   5999113.4172 2090550.32647 37.720202063668 -122.445112038783 (37.720202063668, -122.445112038783)
12296 19104 1 21 10X Mansell St 2 1 1 3   03/29/2007 12:00:00 AM 3 4X30   6011705.43586 2090789.4617400002 37.721569360619604 -122.40160216911 (37.7215693606196, -122.40160216911)
15567 22419 1 79 5815 03rd St 2 1 1 3   12/19/2000 12:00:00 AM 3 3x3   6013854.3759 2092034.5068 37.7251076834032 -122.394260933329 (37.7251076834032, -122.394260933329)
15973 22420 1 79 5815 03rd St 3 1 1 3   01/18/2008 12:00:00 AM 3 3X3   6013860.9167 2092056.0916 37.725167314492104 -122.39423983281799 (37.7251673144921, -122.394239832818)
79426 116125 2 43 2500X Keith St 1 1 1 3           6014198.52795 2092093.45262 37.7252886606488 -122.39307534923799 (37.7252886606488, -122.393075349238)
92983 116128 2 43 2500X Keith St 4 1 1 3           6014198.52795 2092093.45262 37.7252886606488 -122.39307534923799 (37.7252886606488, -122.393075349238)
117524 116126 2 43 2500X Keith St 2 1 1 3           6014198.52795 2092093.45262 37.7252886606488 -122.39307534923799 (37.7252886606488, -122.393075349238)
141081 116127 2 43 2500X Keith St 3 1 1 3           6014198.52795 2092093.45262 37.7252886606488 -122.39307534923799 (37.7252886606488, -122.393075349238)
78103 22400 1 11 5755X 03rd St 3 1 1 3     5 4X4   6013951.2697336 2092275.7830743 37.7257755649285 -122.393942861008 (37.7257755649285, -122.393942861008)
78217 22401 1 11 5755X 03rd St 4 1 1 3     5 3X3   6013951.2697336 2092275.7830743 37.7257755649285 -122.393942861008 (37.7257755649285, -122.393942861008)
105626 22399 1 11 5755X 03rd St 2 1 1 3     5 3X3   6013951.2697336 2092275.7830743 37.7257755649285 -122.393942861008 (37.7257755649285, -122.393942861008)
124786 22398 1 11 5755X 03rd St 1 1 1 3     5 3X3   6013951.2697336 2092275.7830743 37.7257755649285 -122.393942861008 (37.7257755649285, -122.393942861008)
78609 26824 1 37 2000X San Jose Ave 17 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
79265 26306 1 37 2000X San Jose Ave 9 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
79960 26313 1 37 2000X San Jose Ave 16 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
80056 26299 1 37 2000X San Jose Ave 2 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
81506 26304 1 37 2000X San Jose Ave 7 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
85891 26298 1 37 2000X San Jose Ave 1 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
92206 26303 1 37 2000X San Jose Ave 6 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
95883 26312 1 37 2000X San Jose Ave 15 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
96826 26300 1 37 2000X San Jose Ave 3 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
99814 26311 1 37 2000X San Jose Ave 14 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
106413 26302 1 37 2000X San Jose Ave 5 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
107389 26297 1 37 2000X San Jose Ave 19 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
111375 26308 1 37 2000X San Jose Ave 11 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
114344 26310 1 37 2000X San Jose Ave 13 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
115681 26309 1 37 2000X San Jose Ave 12 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
122107 26305 1 37 2000X San Jose Ave 8 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
141627 26301 1 37 2000X San Jose Ave 4 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
146124 26307 1 37 2000X San Jose Ave 10 1 1 3   07/06/1998 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
38305 116138 2 53 1601X Armstrong Ave 10 1 1 3     30     6014404.0852 2092434.1919 37.7262356791342 -122.39238857399599 (37.7262356791342, -122.392388573996)
20862 116132 2 17 1601X Armstrong Ave 4 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
77747 116129 2 17 1601X Armstrong Ave 1 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
81024 116130 2 17 1601X Armstrong Ave 2 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
84841 116134 2 17 1601X Armstrong Ave 6 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
93581 116133 2 17 1601X Armstrong Ave 5 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
102302 116136 2 17 1601X Armstrong Ave 8 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
105094 116131 2 17 1601X Armstrong Ave 3 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
125773 116135 2 17 1601X Armstrong Ave 7 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
140572 116137 2 17 1601X Armstrong Ave 9 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
80819 12055 1 39 1300X La Salle Ave 7 1 1 3     18 3X3   6016940.808513099 2094664.4394134998 37.7325000389111 -122.38377438405399 (37.7325000389111, -122.383774384054)
105682 12051 1 37 1300X La Salle Ave 3 1 1 3   03/11/2006 12:00:00 AM 3 3X3   6016940.808513099 2094664.4394134998 37.7325000389111 -122.38377438405399 (37.7325000389111, -122.383774384054)
117183 12054 1 39 1300X La Salle Ave 6 1 1 3     18 3X3   6016940.808513099 2094664.4394134998 37.7325000389111 -122.38377438405399 (37.7325000389111, -122.383774384054)
120398 12053 1 39 1300X La Salle Ave 5 1 1 3   03/29/1993 12:00:00 AM 6 3X3   6016940.808513099 2094664.4394134998 37.7325000389111 -122.38377438405399 (37.7325000389111, -122.383774384054)
139264 12049 1 37 1300X La Salle Ave 1 1 1 3   12/17/2007 12:00:00 AM 3 3x3   6016940.808513099 2094664.4394134998 37.7325000389111 -122.38377438405399 (37.7325000389111, -122.383774384054)
78767 12056 1 39 1330X La Salle Ave 1 1 1 3     12 3X3   6016860.8582794005 2094712.6673543 37.732628043472 -122.38405415096399 (37.732628043472, -122.384054150964)
92477 12059 1 39 1330X La Salle Ave 4 1 1 3     12 3X3   6016860.8582794005 2094712.6673543 37.732628043472 -122.38405415096399 (37.732628043472, -122.384054150964)
93198 12058 1 39 1330X La Salle Ave 3 1 1 3     12 3X3   6016860.8582794005 2094712.6673543 37.732628043472 -122.38405415096399 (37.732628043472, -122.384054150964)
109212 12062 1 39 1330X La Salle Ave 7 1 1 3     12 3X3   6016860.8582794005 2094712.6673543 37.732628043472 -122.38405415096399 (37.732628043472, -122.384054150964)
110400 12057 1 39 1330X La Salle Ave 2 1 1 3     12 3X3   6016860.8582794005 2094712.6673543 37.732628043472 -122.38405415096399 (37.732628043472, -122.384054150964)
115282 12063 1 37 1330X La Salle Ave 8 1 1 3   03/11/2006 12:00:00 AM 3 3X3   6016860.8582794005 2094712.6673543 37.732628043472 -122.38405415096399 (37.732628043472, -122.384054150964)
117052 12065 1 39 1330X La Salle Ave 10 1 1 3     12 3X3   6016860.8582794005 2094712.6673543 37.732628043472 -122.38405415096399 (37.732628043472, -122.384054150964)
121136 12060 1 39 1330X La Salle Ave 5 1 1 3     12 3X3   6016860.8582794005 2094712.6673543 37.732628043472 -122.38405415096399 (37.732628043472, -122.384054150964)
95395 27160 1 20 1700X Silver Ave 9 1 1 3     3 3X3   6011020.5092245005 2095004.7366116 37.733105385033795 -122.40426632243 (37.7331053850338, -122.40426632243)
140654 27152 1 20 1700X Silver Ave 1 1 1 3   06/02/1999 12:00:00 AM 6 3X3   6011020.5092245005 2095004.7366116 37.733105385033795 -122.40426632243 (37.7331053850338, -122.40426632243)
16026 27153 1 20 1700X Silver Ave 2 1 1 3   01/12/2001 12:00:00 AM 6 3X3   6011109.96837 2095074.7045 37.7333025005961 -122.403961958687 (37.7333025005961, -122.403961958687)
13832 27154 1 20 1700X Silver Ave 3 1 1 3   01/12/2001 12:00:00 AM 6 3X3   6011126.61874 2095085.7194599998 37.7333336755986 -122.403905168305 (37.7333336755986, -122.403905168305)
15856 27155 1 20 1700X Silver Ave 4 1 1 3   01/29/2000 12:00:00 AM 6 3X3   6011143.89147 2095098.83858 37.733370662922795 -122.403846374205 (37.7333706629228, -122.403846374205)
80275 26143 1 49 1500 Oakdale Ave 13 1 1 3   02/08/2003 12:00:00 AM 3 3x3   6015586.393477299 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626)
88734 26148 1 11 1500 Oakdale Ave 18 1 1 3     6 3x3   6015586.393477299 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626)
89501 26142 1 49 1500 Oakdale Ave 12 1 1 3   03/21/2006 12:00:00 AM 3 3x3   6015586.393477299 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626)
93843 26146 1 11 1500 Oakdale Ave 16 1 1 3     6 3x3   6015586.393477299 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626)
96605 26144 1 50 1500 Oakdale Ave 14 1 1 3   04/22/1997 12:00:00 AM 10 3x3   6015586.393477299 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626)
98448 26147 1 11 1500 Oakdale Ave 17 1 1 3     6 3x3   6015586.393477299 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626)
Powered by Datasette · Query took 8.718ms · Data source: data.sfgov.org