sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
14458 94035 3 25 1300X Lane St 3 1 1 4 2   32 5x5   6015684.8669 2095240.1882 37.7340114236329 -122.388156677838 (37.7340114236329, -122.388156677838)
15674 94034 3 25 1300X Lane St 2 5 1 4 2   24 3x3   6015674.4242 2095246.7836 37.7340289546749 -122.388193241926 (37.7340289546749, -122.388193241926)
15999 94036 3 26 1300X Lane St 4 5 1 4 2 12/08/2012 12:00:00 AM 3 5x5   6015673.325 2095216.0053 37.7339443827642 -122.388194894968 (37.7339443827642, -122.388194894968)
16453 96769 3 26 1300X Lane St 5 1 1 4 2   1 4x4   6015646.9436 2095179.7309 37.7338433188148 -122.388283573512 (37.7338433188148, -122.388283573512)
13403 96770 3 26 1300X Lane St 6 5 1 4 2 12/08/2012 12:00:00 AM 3 3x3   6015623.8599 2095148.9526 37.7337575287133 -122.388361234061 (37.7337575287133, -122.388361234061)
89310 66890 3 2 1035 Gilman Ave 1 1 1 4 2 05/07/2005 12:00:00 AM 6 3x3 Permit Number 45482 6015368.10493708 2089617.80548286 37.71855592189279 -122.388859444456 (37.7185559218928, -122.388859444456)
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)
129243 47256 3 2 1035 Gilman Ave 2 1 1 4 2 05/09/2002 12:00:00 AM 6 3x3 Permit Number 45198 6015368.10493708 2089617.80548286 37.71855592189279 -122.388859444456 (37.7185559218928, -122.388859444456)
145918 47257 3 2 1035 Gilman Ave 3 1 1 4 2 07/08/2009 12:00:00 AM 6 3x3 Permit Number 52469 6015368.10493708 2089617.80548286 37.71855592189279 -122.388859444456 (37.7185559218928, -122.388859444456)
46599 97073 3 17 1551 Newcomb Ave 7 1 1 4 2   18 4x4   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
83429 97069 3 17 1551 Newcomb Ave 3 1 1 4 2   12 6x6   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
83478 97078 3 17 1551 Newcomb Ave 10 1 1 4 2   16 4x4   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
84864 97082 3 17 1551 Newcomb Ave 13 1 1 4 2   16 3x3   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
86592 97067 3 26 1551 Newcomb Ave 1 1 1 4 2 03/06/2014 12:00:00 AM 3 3x3   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
88449 97070 3 17 1551 Newcomb Ave 4 1 1 4 2   14 3x3   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
88782 97068 3 26 1551 Newcomb Ave 2 1 1 4 2   3 3x3   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
89738 97080 3 26 1551 Newcomb Ave 12 1 1 4 2   3 3x3   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
93584 97074 3 11 1551 Newcomb Ave 8 1 1 4 2 08/20/2015 05:52:00 PM 3 4x4   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
106157 97076 3 17 1551 Newcomb Ave 9 1 1 4 2   12 4x4   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
116244 97072 3 17 1551 Newcomb Ave 6 1 1 4 2   18 4x4   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
124857 97071 3 17 1551 Newcomb Ave 5 1 1 4 2   18 4x4   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
139482 97079 3 17 1551 Newcomb Ave 11 1 1 4 2   16 4x4   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
77312 96772 3 26 1300X Lane St 8 1 1 4 2   2 3x3   6015407.2 2095381.5 37.73438404885479 -122.38912652987801 (37.7343840488548, -122.389126529878)
85372 96771 3 26 1300X Lane St 7 1 1 4 2 11/08/2011 12:00:00 AM 8 4x3   6015407.2 2095381.5 37.73438404885479 -122.38912652987801 (37.7343840488548, -122.389126529878)
124646 96774 3 26 1300X Lane St 10 1 1 4 2 12/08/2012 12:00:00 AM 3 3x3   6015407.2 2095381.5 37.73438404885479 -122.38912652987801 (37.7343840488548, -122.389126529878)
106838 102115 3 2 1035 Gilman Ave 5 1 1 4 2   6 3x3 Permit Number 52469 6015181.7 2089440.8 37.7180595657824 -122.389491420596 (37.7180595657824, -122.389491420596)
81950 97063 3 11 1599X Newcomb Ave 4 1 1 4 2   10 3x3   6015231.1 2095663.5 37.7351486000155 -122.38975506041099 (37.7351486000155, -122.389755060411)
92342 97065 3 11 1599X Newcomb Ave 6 1 1 4 2   10 3x3   6015231.1 2095663.5 37.7351486000155 -122.38975506041099 (37.7351486000155, -122.389755060411)
96887 97064 3 11 1599X Newcomb Ave 5 1 1 4 2   10 3x3   6015231.1 2095663.5 37.7351486000155 -122.38975506041099 (37.7351486000155, -122.389755060411)
103946 97061 3 11 1599X Newcomb Ave 2 1 1 4 2   6 3x3   6015231.1 2095663.5 37.7351486000155 -122.38975506041099 (37.7351486000155, -122.389755060411)
106885 97060 3 11 1599X Newcomb Ave 1 1 1 4 2   5 3x3   6015231.1 2095663.5 37.7351486000155 -122.38975506041099 (37.7351486000155, -122.389755060411)
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)
139761 97062 3 11 1599X Newcomb Ave 3 1 1 4 2   6 3x3   6015231.1 2095663.5 37.7351486000155 -122.38975506041099 (37.7351486000155, -122.389755060411)
180919 115549 2 46 925x Minnesota St 1 1 1 4 2   18 20x7   6015281.58054 2104112.34112 37.7583501556473 -122.390170593412 (37.7583501556473, -122.390170593412)
155253 115550 2 46 925x Minnesota St 2 1 1 4 2   18 20x7   6015279.22506 2104155.94994 37.7584697654838 -122.39018178636199 (37.7584697654838, -122.390181786362)
24594 115551 2 46 925x Minnesota St 3 1 1 4 2   20 18x7   6015277.41921 2104189.44931 37.7585616474178 -122.39019037219299 (37.7585616474178, -122.390190372193)
186618 115552 2 52 925x Minnesota St 4 1 1 4 2   6 15x7   6015276.56251 2104229.2059299997 37.7586707630633 -122.390196112573 (37.7586707630633, -122.390196112573)
14765 51356 3 135 50 Pomona St 1 1 1 4 2 12/10/2005 12:00:00 AM 3 3x3 Permit Number 47704 6014174.8382 2094728.0237900002 37.732521344076204 -122.393341524701 (37.7325213440762, -122.393341524701)
16516 51368 3 111 50 Pomona St 2 1 1 4 2 03/12/2005 12:00:00 AM 3 3x3 Permit Number 47704 6014172.092119999 2094713.43563 37.7324811353964 -122.393349998121 (37.7324811353964, -122.393349998121)
15702 51369 3 135 50 Pomona St 3 1 1 4 2 03/12/2005 12:00:00 AM 3 3x3 Permit Number 47704 6014169.21344 2094698.3618 37.7324395857978 -122.39335889598999 (37.7324395857978, -122.39335889599)
15170 51367 3 111 50 Pomona St 4 1 1 4 2 07/09/2009 12:00:00 AM 3 3x3 Permit Number 52508 6014166.48709 2094684.74927 37.732402057093296 -122.39336736943001 (37.7324020570933, -122.39336736943)
16338 51366 3 135 50 Pomona St 5 1 1 4 2 03/12/2005 12:00:00 AM 3 3x3 Permit Number 47704 6014162.991119999 2094669.4439299998 37.73235983751729 -122.39337838521601 (37.7323598375173, -122.393378385216)
16461 51365 3 111 50 Pomona St 6 1 1 4 2 03/12/2005 12:00:00 AM 3 3x3 Permit Number 47704 6014154.93455 2094628.60419 37.7322472522973 -122.39340338185801 (37.7322472522973, -122.393403381858)
13428 51364 3 135 50 Pomona St 7 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014150.64944 2094610.63008 37.732197660973505 -122.393416939157 (37.7321976609735, -122.393416939157)
14428 51357 3 180 50 Pomona St 8 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014147.24137 2094593.6145900001 37.732150750552 -122.393427531355 (37.732150750552, -122.393427531355)
16645 51363 3 135 50 Pomona St 9 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014143.519230001 2094573.1883599998 37.7320944574823 -122.393438970749 (37.7320944574823, -122.393438970749)
14071 51362 3 2 50 Pomona St 10 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014137.60928 2094535.47761 37.7319905830836 -122.393456764727 (37.7319905830836, -122.393456764727)
44829 94949 6 31 50 Pomona St   24 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
90667 94951 6 31 50 Pomona St   24 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
93623 94948 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
103824 94947 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
107188 94950 6 31 50 Pomona St   24 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
114698 94946 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
16818 51361 3 237 50 Pomona St 11 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014122.20154 2094470.50183 37.7318113167403 -122.39350548730499 (37.7318113167403, -122.393505487305)
16162 51360 3 66 50 Pomona St 12 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014114.6767 2094431.72556 37.7317044268964 -122.39352878961999 (37.7317044268964, -122.39352878962)
13409 51359 3 66 50 Pomona St 13 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014112.78564 2094416.99761 37.73166388187129 -122.393534297068 (37.7316638818713, -122.393534297068)
14652 51358 3 66 50 Pomona St 14 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014110.4538 2094404.7193099998 37.7316300385939 -122.393541499766 (37.7316300385939, -122.393541499766)
16408 78332 3 66 50 Pomona St 15 1 1 4 2 07/01/2009 12:00:00 AM 3 3x3 Permit Number 52305 6014106.86245 2094390.7581099998 37.73159150443121 -122.393552939125 (37.7315915044312, -122.393552939125)
14034 78331 3 97 50 Pomona St 16 1 1 4 2 07/15/2000 12:00:00 AM 3 3x3   6014103.033559999 2094377.1679 37.7315539757311 -122.393565225657 (37.7315539757311, -122.393565225657)
13536 78330 3 282 50 Pomona St 17 1 1 4 2 07/15/2000 12:00:00 AM 3 3x3   6014096.48223 2094344.10726 37.7314628339206 -122.39358556204999 (37.7314628339206, -122.39358556205)
15350 78329 3 135 50 Pomona St 18 1 1 4 2 07/15/2000 12:00:00 AM 3 3x3   6014093.60126 2094328.91133 37.731420948908294 -122.39359445903999 (37.7314209489083, -122.39359445904)
16401 78328 3 282 50 Pomona St 19 1 1 4 2 07/15/2000 12:00:00 AM 3 3x3   6014090.70522 2094312.9836799998 37.7313770539035 -122.39360335692601 (37.7313770539035, -122.393603356926)
15526 78327 3 135 50 Pomona St 20 1 1 4 2 07/15/2000 12:00:00 AM 3 3x3   6014087.33436 2094297.79766 37.7313351688787 -122.39361394824199 (37.7313351688787, -122.393613948242)
15298 78326 3 282 50 Pomona St 21 1 1 4 2 07/15/2000 12:00:00 AM 3 3x3   6014084.32077 2094282.11607 37.7312919429706 -122.39362326971799 (37.7312919429706, -122.393623269718)
15529 78325 3 97 50 Pomona St 22 1 1 4 2 07/15/2000 12:00:00 AM 3 3x3   6014082.074630001 2094268.0058099998 37.731253074258596 -122.393630047885 (37.7312530742586, -122.393630047885)
13640 78324 3 111 50 Pomona St 23 1 1 4 2 07/15/2000 12:00:00 AM 3 3x3   6014075.45071 2094231.93865 37.731153673106796 -122.393650424725 (37.7311536731068, -122.393650424725)
15731 78323 3 135 50 Pomona St 24 1 1 4 2 07/15/2000 12:00:00 AM 3 3x3   6014072.33534 2094216.7042200002 37.731111669349204 -122.393660129315 (37.7311116693492, -122.393660129315)
16070 78322 3 111 50 Pomona St 25 1 1 4 2 07/15/2000 12:00:00 AM 3 3x3   6014069.278530001 2094204.9289400002 37.7310791669665 -122.393669873461 (37.7310791669665, -122.393669873461)
15539 78321 3 135 50 Pomona St 26 1 1 4 2 07/15/2000 12:00:00 AM 3 3x3   6014066.05948 2094191.2042200002 37.73104130280179 -122.39368004209999 (37.7310413028018, -122.3936800421)
15757 78202 3 111 50 Pomona St 27 1 1 4 2 07/15/2000 12:00:00 AM 3 3x3   6014063.31576 2094176.7375400001 37.731001427778395 -122.393688515509 (37.7310014277784, -122.393688515509)
94061 94895 3 97 43 Flora St 4 1 1 4 2 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.732132475471104 -122.39381008289601 (37.7321324754711, -122.393810082896)
94704 94894 3 97 43 Flora St 3 1 1 4 2 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.732132475471104 -122.39381008289601 (37.7321324754711, -122.393810082896)
104168 94893 3 97 43 Flora St 2 1 1 4 2 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.732132475471104 -122.39381008289601 (37.7321324754711, -122.393810082896)
119228 94892 3 97 43 Flora St 1 1 1 4 2 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.732132475471104 -122.39381008289601 (37.7321324754711, -122.393810082896)
73786 94516 1 49 1106X Wisconsin St 1 1 1 4   08/27/2010 12:00:00 AM 2   Permit Number 53703 6012787.7377 2102360.9473599996 37.753402573178896 -122.39867255379299 (37.7534025731789, -122.398672553793)
97797 91788 3 127 830X Harrison St 8 1 1 4   03/07/2007 12:00:00 AM 3 3x3   6012494.965717 2112152.388469 37.7802713613915 -122.400372717325 (37.7802713613915, -122.400372717325)
78003 107872 3 15 830X Harrison St 5 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
79453 107874 3 15 830X Harrison St 7 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
82834 107870 3 15 830X Harrison St 3 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
89526 107869 3 15 830X Harrison St 2 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
91198 107871 3 15 830X Harrison St 4 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
92153 107873 3 15 830X Harrison St 6 1 1 4       3x3   6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
140524 107868 3 15 830X Harrison St 1 1 1 4           6012494.965419999 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325)
85224 112022 3 25 2101x 22nd Ave 2 1 1 4       5x5   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
88558 112026 3 25 2101x 22nd Ave 6 1 1 4       5x5   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
89475 112027 3 25 2101x 22nd Ave 7 1 1 4       5x5   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
103944 112029 3 48 2101x 22nd Ave 9 1 1 4   07/23/2015 12:00:00 AM 3 9x9   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
109884 112024 3 25 2101x 22nd Ave 4 1 1 4       5x5   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
118430 112023 3 2 2101x 22nd Ave 3 1 1 4   07/23/2015 12:00:00 AM 3 5x5   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
121651 112021 3 48 2101x 22nd Ave 1 1 1 4   07/23/2015 12:00:00 AM 3 5x5   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
140280 112025 3 48 2101x 22nd Ave 5 1 1 4   07/23/2015 12:00:00 AM 3 5x5   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
141236 112028 3 2 2101x 22nd Ave 8 1 1 4   07/23/2015 12:00:00 AM 3 9x9   6011761.0 2103726.0 37.757093449930004 -122.402319220858 (37.75709344993, -122.402319220858)
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)
128247 116052 2 5 650x KANSAS ST 8 1 1 4 2     4x4   6011530.0 2105347.0 37.761531458187 -122.403232137637 (37.761531458187, -122.403232137637)
129870 116056 2 5 650x Kansas St 12 1 1 4 2   23 4x4   6011515.191980001 2105171.68257 37.7610492486475 -122.40327101944901 (37.7610492486475, -122.403271019449)
15372 116055 2 1 650x Kansas St 11 1 1 4 2 06/30/2016 12:00:00 AM 3 4x4   6011513.13975 2105199.40577 37.7611252557522 -122.40328006754801 (37.7611252557522, -122.403280067548)
132178 116054 2 32 650x Kansas St 10 1 1 4 2   23 4x4   6011511.93551 2105220.59815 37.761183378041395 -122.403285723377 (37.7611833780414, -122.403285723377)
35622 116053 2 32 650x Kansas St 9 1 1 4 2   11 4x4   6011508.109619999 2105241.51829 37.761240606399795 -122.40330042728901 (37.7612406063998, -122.403300427289)
25232 116051 2 12 650x Kansas St 7 1 1 4 2   3 4x4   6011500.28754 2105307.1354099996 37.761420339490705 -122.40333209689699 (37.7614203394907, -122.403332096897)
163065 116050 2 12 650x Kansas St 6 1 1 4 2   3 4x4   6011499.79329 2105331.08163 37.76148606285779 -122.403335490949 (37.7614860628578, -122.403335490949)
30215 116049 2 55 650x Kansas St 5 1 1 4 2   5 4x4   6011498.3385 2105356.0244 37.761554468880206 -122.403342277248 (37.7615544688802, -122.403342277248)
Powered by Datasette · Query took 10.74ms · Data source: data.sfgov.org