sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2216 122752 3 94 693 Vermont St 6 1 1 4 2   18     6011278.80569 2105286.3398 37.7613508668666 -122.404096651066 (37.7613508668666, -122.404096651066)
2219 122754 3 55 693 Vermont St 4 1 1 4 2   16     6011277.363419999 2105334.1858 37.761482160689894 -122.404105006665 (37.7614821606899, -122.404105006665)
2223 43305 3 94 693 Vermont St 10 1 1 4 2 07/12/2000 12:00:00 AM 6   Permit Number 43072 6011285.67007 2105193.27319 37.7610957103087 -122.4040663601 (37.7610957103087, -122.4040663601)
2229 43306 3 133 693 Vermont St 12 1 1 4 2 07/12/2000 12:00:00 AM 22   Permit Number 43072 6011289.47877 2105149.93268 37.7609769197604 -122.404050137204 (37.7609769197604, -122.404050137204)
2231 122750 3 94 693 Vermont St 8 1 1 4 2   9     6011285.1392 2105241.4016400003 37.761227830607204 -122.40407158333299 (37.7612278306072, -122.404071583333)
2232 122753 3 13 693 Vermont St 5 1 1 4 2   15     6011277.810190001 2105311.62173 37.7614202297665 -122.404101873421 (37.7614202297665, -122.404101873421)
2233 122749 3 94 693 Vermont St 9 1 1 4 2   5     6011285.506709999 2105214.92948 37.761155164510605 -122.404068449214 (37.7611551645106, -122.404068449214)
2240 122755 3 55 693 Vermont St 3 1 1 4 2   14     6011274.22678 2105356.76628 37.7615439863765 -122.40411744427601 (37.7615439863765, -122.404117444276)
17867 98680 1 55 199X Park St 6 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
33468 95148 1 2 250 23rd Ave 4 1 1 4 2   14     5988724.779619999 2113566.5271900003 37.78279998730721 -122.482707449869 (37.7827999873072, -122.482707449869)
41129 95156 1 10 250 23rd Ave 12 1 1 4 2   21     5988717.78601 2113765.0163 37.7833445754979 -122.48274619510799 (37.7833445754979, -122.482746195108)
41571 95149 1 2 250 23rd Ave 5 1 1 4 2   15     5988721.12033 2113580.3815900004 37.7828378146839 -122.48272112492901 (37.7828378146839, -122.482721124929)
60314 95147 1 2 250 23rd Ave 3 1 1 4 2   13     5988726.59645 2113538.2792 37.7827225319963 -122.48269909375901 (37.7827225319963, -122.482699093759)
63647 95150 1 2 250 23rd Ave 6 1 1 4 2   12     5988721.361169999 2113591.74757 37.7828690364709 -122.482721124926 (37.7828690364709, -122.482721124926)
70878 95154 1 10 250 23rd Ave 10 1 1 4 2   20     5988718.8555 2113711.8550400003 37.783198671909794 -122.48273859805 (37.7831986719098, -122.48273859805)
78641 116976 2 218 100x CARGO WAY 7 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
79463 116977 2 5 100x CARGO WAY 117 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
80122 98749 2 26 540X Eureka St 6 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
81972 98746 2 26 540X Eureka St 3 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
82915 95268 3 43 2245 Jones St 7 1 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
84977 98681 1 55 199X Park St 7 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
86909 120542 2 71 2450 California St 1 7 1 6 2         6002644.1089699995 2115479.97736 37.7888538273233 -122.43468935172599 (37.7888538273233, -122.434689351726)
88992 98678 1 55 199X Park St 4 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
90630 98561 3 12 2035X Stockton St 4 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
90673 98752 2 26 540X Eureka St 9 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
91242 98559 3 12 2035X Stockton St 2 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
92105 98750 2 26 540X Eureka St 7 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
92729 98679 1 55 199X Park St 5 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
93270 98756 2 26 540X Eureka St 13 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
94912 98754 2 26 540X Eureka St 11 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
95375 98676 1 55 199X Park St 2 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
97683 98677 1 55 199X Park St 3 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
99342 95260 3 51 2290X 14th Ave 8 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
104719 95263 3 15 2245 Jones St 1 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
105405 98743 2 5 155 Masonic Ave 5 26 1 4 2         5998843.8 2112455.0 37.7803315496091 -122.447619999218 (37.7803315496091, -122.447619999218)
106816 95261 3 51 2290X 14th Ave 9 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
108801 98744 2 16 540X Eureka St 1 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
110614 98755 2 26 540X Eureka St 12 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
110736 98753 2 26 540X Eureka St 10 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
112310 95267 3 125 2245 Jones St 6 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
116005 95264 3 15 2245 Jones St 2 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
117184 98682 1 55 199X Park St 8 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
119088 95258 3 51 2290X 14th Ave 6 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
120054 95152 1 2 250 23rd Ave 8 1 1 4 2   10     5988720.65561 2113620.6282200003 37.7829482935383 -122.482725682965 (37.7829482935383, -122.482725682965)
120920 95266 3 15 2245 Jones St 5 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
121500 42841 3 21 2245 Jones St 4 1 1 4 2 07/03/2000 12:00:00 AM     Permit Number 42773 6008051.69679947 2120116.37092576 37.8018897255523 -122.416308313185 (37.8018897255523, -122.416308313185)
121513 107883 3 44 941 Washington St 1 1 1 4 2         6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
126599 98562 3 12 2035X Stockton St 5 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
138350 98747 2 26 540X Eureka St 4 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
138703 95262 3 51 2290X 14th Ave 10 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
139365 98751 2 26 540X Eureka St 8 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
140503 116975 2 218 100x CARGO WAY 6 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
141315 98560 3 12 2035X Stockton St 3 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
141772 98748 2 26 540X Eureka St 5 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
142592 96085 3 51 2290X 14th Ave 11 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
143508 95265 3 15 2245 Jones St 3 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
145208 95259 3 51 2290X 14th Ave 7 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
145453 95270 3 21 2245 Jones St 9 1 1 4 2 03/23/2016 02:41:00 PM 3     6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
146991 95155 1 10 250 23rd Ave 11 1 1 4 2   16     5988718.098730001 2113738.3311400004 37.7832713237769 -122.482743157022 (37.7832713237769, -122.482743157022)
151441 70932 1 2 250 23rd Ave 2 1 1 4 2 03/11/1995 12:00:00 AM 14     5988727.46903 2113517.2675099997 37.7826648905872 -122.48269453478301 (37.7826648905872, -122.482694534783)
156514 122751 3 32 693 Vermont St 7 1 1 4 2   18     6011280.99043 2105260.13165 37.7612790272197 -122.40408725043301 (37.7612790272197, -122.404087250433)
159681 73495 1 2 250 23rd Ave 1 1 1 4 2 03/11/1995 12:00:00 AM 10     5988730.14838 2113498.62278 37.7826138532986 -122.482683898749 (37.7826138532986, -122.482683898749)
163336 95153 1 2 250 23rd Ave 9 1 1 4 2   18     5988721.4522400005 2113658.22406 37.783051567455004 -122.482725682991 (37.783051567455, -122.482725682991)
174085 43304 3 32 693 Vermont St 11 1 1 4 2 07/12/2000 12:00:00 AM 19   Permit Number 43072 6011287.96925 2105166.37556 37.7610219838923 -122.404056515205 (37.7610219838923, -122.404056515205)
183769 95151 1 2 250 23rd Ave 7 1 1 4 2   13     5988720.99449 2113605.53219 37.7829068638151 -122.482723403965 (37.7829068638151, -122.482723403965)
23202 77640 3 55 1300X Silliman St 1 1 1 4 2 10/26/1984 12:00:00 AM 13 0   6006980.92428 2093193.1114700001 37.7279045016753 -122.418103887786 (37.7279045016753, -122.418103887786)
23284 76311 3 44 299X Cambridge St 1 1 1 4 2 10/26/1984 12:00:00 AM 4 0   6006754.260559999 2093151.90933 37.7277786091743 -122.418884550584 (37.7277786091743, -122.418884550584)
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)
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)
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)
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)
72161 99692 3 26 1550X Washington St 3 1 1 4 2   8 2x2   6007274.7 2117123.2 37.7936275055362 -122.41878469564101 (37.7936275055362, -122.418784695641)
122316 99339 3 2 450 30th Ave 17 1 1 4 2   12 3.5x3.5   5986576.130469999 2112991.43823 37.7810957151351 -122.49009845653799 (37.7810957151351, -122.490098456538)
124662 99335 3 39 450 30th Ave 13 1 1 4 2   30 3.5x3.5   5986578.25407 2112899.8451 37.780844350584005 -122.490084370963 (37.780844350584, -122.490084370963)
91017 99338 3 60 450 30th Ave 16 1 1 4 2   4 3X3   5986576.26956 2112967.74794 37.7810306764919 -122.490096232309 (37.7810306764919, -122.490096232309)
23164 76784 3 2 1501X 42nd Ave 7 1 1 4 2 05/14/1994 12:00:00 AM 1 3x12   5983097.2131 2104562.028 37.7577472058325 -122.50150981087799 (37.7577472058325, -122.501509810878)
23240 76785 3 39 1501X 42nd Ave 8 1 1 4 2 05/14/1994 12:00:00 AM 24 3x12   5983097.8243 2104541.5546 37.757691027540005 -122.501506182606 (37.75769102754, -122.501506182606)
23245 76756 3 108 1501X 42nd Ave 6 1 1 4 2 05/14/1994 12:00:00 AM 2 3x12   5983095.0741 2104639.3384 37.757959352781 -122.501522927406 (37.757959352781, -122.501522927406)
23276 76755 3 108 1501X 42nd Ave 5 1 1 4 2 05/14/1994 12:00:00 AM 3 3x12   5983093.5463 2104662.8676 37.758023867602 -122.501529951702 (37.758023867602, -122.501529951702)
23340 76382 3 39 1501X 42nd Ave 2 1 1 4 2 05/14/1994 12:00:00 AM 25 3x12   5983091.4072 2104771.8049 37.7583228530818 -122.501545408351 (37.7583228530818, -122.501545408351)
23355 76748 3 42 1501X 42nd Ave 4 1 1 4 2 05/14/1994 12:00:00 AM 7 3x12   5983093.5463 2104693.1195 37.7581069307926 -122.501532189631 (37.7581069307926, -122.501532189631)
86769 46964 3 2 3899X Kirkham St 2 1 1 4 2 05/01/2002 12:00:00 AM 8 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
88512 46967 3 2 3899X Kirkham St 5 1 1 4 2 05/01/2002 12:00:00 AM 5 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
91304 76222 3 2 3899X Kirkham St 6 1 1 4 2 05/14/1994 12:00:00 AM 5 3x20   5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
95663 76252 3 2 3899X Kirkham St 8 1 1 4 2 05/14/1994 12:00:00 AM 8 3x20   5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
98630 46965 3 2 3899X Kirkham St 3 1 1 4 2 05/01/2002 12:00:00 AM 8 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
120521 46966 3 2 3899X Kirkham St 4 1 1 4 2 05/01/2002 12:00:00 AM 8 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
142732 76271 3 2 3899X Kirkham St 9 1 1 4 2 05/14/1994 12:00:00 AM 8 3x20   5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
144911 76325 3 2 3899X Kirkham St 11 1 1 4 2 05/14/1994 12:00:00 AM 5 3x20   5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
44052 46958 3 2 1530 43rd Ave 11 1 1 4 2 05/01/2002 12:00:00 AM 7 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
85268 46950 3 2 1530 43rd Ave 3 1 1 4 2 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
88649 46953 3 2 1530 43rd Ave 6 1 1 4 2 05/01/2002 12:00:00 AM 6 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
89109 46955 3 2 1530 43rd Ave 8 1 1 4 2 05/01/2002 12:00:00 AM 4 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
90893 46948 3 2 1530 43rd Ave 1 1 1 4 2 05/01/2002 12:00:00 AM 3 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
93081 46957 3 2 1530 43rd Ave 10 1 1 4 2 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
93345 46960 3 2 1530 43rd Ave 13 1 1 4 2 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
97074 46962 3 2 1530 43rd Ave 15 1 1 4 2 05/01/2002 12:00:00 AM 6 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
100272 46952 3 2 1530 43rd Ave 5 1 1 4 2 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
118208 46949 3 2 1530 43rd Ave 2 1 1 4 2 05/01/2002 12:00:00 AM 5 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
119652 46951 3 2 1530 43rd Ave 4 1 1 4 2 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
120283 46961 3 2 1530 43rd Ave 14 1 1 4 2 05/01/2002 12:00:00 AM 7 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
Powered by Datasette · Query took 5.879ms · Data source: data.sfgov.org