sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
76012 97025 7 88 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
9836 6755 3 88 1215 Fairfax Ave 9 1 1 2   01/03/2017 06:41:00 AM 3 3x3   6017521.099066501 2096743.3718321999 37.7382404347673 -122.381912713319 (37.7382404347673, -122.381912713319)
505 6741 3 88 1300X Fairfax Ave 11 1 1 2   04/10/2017 01:50:00 PM 3 3x3   6016924.03316 2097256.8815900004 37.739617439282604 -122.38401284003099 (37.7396174392826, -122.384012840031)
500 6742 3 88 1300X Fairfax Ave 12 1 1 2   04/10/2017 01:53:00 PM 3 3x3   6016901.500630001 2097278.26947 37.7396749203573 -122.384092237585 (37.7396749203573, -122.384092237585)
123675 113269 1 88 1328 Quesada Ave 1 1 1 1   09/16/2015 12:00:00 AM     Permit Number 774425 6016744.9 2093624.7 37.7296342890732 -122.384379303046 (37.7296342890732, -122.384379303046)
81549 8225 3 88 1500X Galvez Ave 4 1 1 2   12/10/2015 08:37:00 AM 3 3x3   6016396.247314 2097296.3974116 37.739696749128896 -122.385840466933 (37.7396967491289, -122.385840466933)
116957 8230 3 88 1500X Galvez Ave 9 1 1 2   12/10/2015 08:33:00 AM 3 3x3   6016396.247314 2097296.3974116 37.739696749128896 -122.385840466933 (37.7396967491289, -122.385840466933)
143719 8223 3 88 1500X Galvez Ave 2 1 1 2   12/10/2015 08:24:00 AM 3 3x3   6016396.247314 2097296.3974116 37.739696749128896 -122.385840466933 (37.7396967491289, -122.385840466933)
528 248942 3 88 1500x Galvez Ave 1 1 1 2 3 03/18/2017 12:56:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
1063 248924 3 88 201x Cashmere St 5 1 1 2 3 04/29/2017 10:39:00 AM 3 3x3   6016272.0 2096170.0 37.7365970133228 -122.38619155869101 (37.7365970133228, -122.386191558691)
135931 193323 2 88 1189 Tennessee St 1 1 1 1     1 Width 3ft   6015597.773159999 2103545.2289400003 37.7568105190107 -122.38903745483299 (37.7568105190107, -122.389037454833)
13472 110653 1 88 1189 Tennessee St 2 1 1 1   04/28/2015 12:00:00 AM 3 3x4   6015597.65588 2103555.7138400003 37.7568393018153 -122.38903859247101 (37.7568393018153, -122.389038592471)
167402 193327 2 88 1398 Tennessee St 4 1 1 1     1 Width 5ft   6015585.429769999 2102602.25227 37.7542206208044 -122.38901430715799 (37.7542206208044, -122.389014307158)
48794 193328 2 88 900 24th St 1 1 1 1     1 Width 4ft   6015574.56777 2102562.74505 37.7541115402303 -122.389049112743 (37.7541115402303, -122.389049112743)
15260 116923 2 88 900x 24th St 2 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015559.42731 2102560.4848599997 37.7541044949445 -122.389101314797 (37.7541044949445, -122.389101314797)
13608 116924 2 88 900x 24th St 3 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015542.44799 2102559.60008 37.754101124282606 -122.389159972153 (37.7541011242826, -122.389159972153)
14797 116925 2 88 900x 24th St 4 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015524.58204 2102559.09611 37.7540987500629 -122.389221722302 (37.7540987500629, -122.389221722302)
52442 59600 1 88 1116 Tennessee St 1 1 1 1   02/26/1981 12:00:00 AM 9   Permit Number 19001 6015518.08801 2103793.04215 37.757486543884 -122.389330342431 (37.757486543884, -122.389330342431)
14030 116926 2 88 900x 24th St 5 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015510.15678 2102558.1918900004 37.7540954675573 -122.389271545654 (37.7540954675573, -122.389271545654)
16727 116927 2 88 900x 24th St 6 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015494.24319 2102557.91546 37.7540938262957 -122.38932655988899 (37.7540938262957, -122.389326559889)
14678 59614 1 88 1014 Tennessee St 1 1 1 1   02/10/2011 12:00:00 AM 3 3x3 Permit Number 767137 6015492.62077 2104343.80938 37.7589974211239 -122.389456881532 (37.7589974211239, -122.389456881532)
16512 116928 2 88 900x 24th St 7 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015476.82973 2102557.66932 37.754092185022394 -122.38938676319599 (37.7540921850224, -122.389386763196)
16892 116929 2 88 900x 24th St 8 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015461.93425 2102556.8401200003 37.7540890823654 -122.38943821792401 (37.7540890823654, -122.389438217924)
14067 116930 2 88 900x 24th St 9 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015446.80292 2102557.08015 37.7540889024884 -122.389490562948 (37.7540889024884, -122.389490562948)
123276 113270 1 88 1570 Quesada Ave 1 1 1 1   09/16/2015 12:00:00 AM     Permit Number 773602 6015432.5 2094545.1 37.732088865659705 -122.38898068227199 (37.7320888656597, -122.388980682272)
16017 116931 2 88 900x 24th St 10 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015431.47773 2102556.1938099996 37.754085619065705 -122.38954349973301 (37.7540856190657, -122.389543499733)
16611 116932 2 88 900x 24th St 11 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015412.75293 2102554.60022 37.7540802051572 -122.38960814389799 (37.7540802051572, -122.389608143898)
65070 78191 2 88 680 Tennessee St 1 1 1 1 1 10/05/2002 12:00:00 AM 1     6015407.71241 2105894.14692 37.7632496064147 -122.389858829046 (37.7632496064147, -122.389858829046)
16552 116933 2 88 1275 Minnesota St 1 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015369.147890001 2102590.92817 37.7541775360745 -122.38976147920799 (37.7541775360745, -122.389761479208)
15996 116935 2 88 1275 Minnesota St 3 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015368.355880001 2102637.50716 37.7543053881926 -122.389767471397 (37.7543053881926, -122.389767471397)
15315 116934 2 88 1275 Minnesota St 2 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015367.98495 2102613.01131 37.7542381072096 -122.38976704331999 (37.7542381072096, -122.38976704332)
18361 99292 1 88 1300 Minnesota St 3 1 1 1   05/01/2012 12:00:00 AM   3x3 Permit Number 768897 6015320.4 2102511.6 37.753957014382 -122.38992452193199 (37.753957014382, -122.389924521932)
103935 99293 1 88 1300 Minnesota St 4 1 1 1   05/01/2012 12:00:00 AM   3x3 Permit Number 768897 6015320.4 2102511.6 37.753957014382 -122.38992452193199 (37.753957014382, -122.389924521932)
109870 99290 1 88 1300 Minnesota St 1 1 1 1   05/01/2012 12:00:00 AM   3x3 Permit Number 768897 6015320.4 2102511.6 37.753957014382 -122.38992452193199 (37.753957014382, -122.389924521932)
110433 99294 1 88 1300 Minnesota St 5 1 1 1   05/01/2012 12:00:00 AM   3x3 Permit Number 768897 6015320.4 2102511.6 37.753957014382 -122.38992452193199 (37.753957014382, -122.389924521932)
145185 99291 1 88 1300 Minnesota St 2 1 1 1   05/01/2012 12:00:00 AM   3x3 Permit Number 768897 6015320.4 2102511.6 37.753957014382 -122.38992452193199 (37.753957014382, -122.389924521932)
186500 193340 2 88 1280 Minnesota St 1 1 1 1     4 Width 3ft   6015310.01646 2102516.50346 37.753969902388796 -122.38996077348 (37.7539699023888, -122.38996077348)
59718 193339 2 88 1278 Minnesota St 1 1 1 1     4 Width 3ft   6015309.7122 2102531.15535 37.7540101165005 -122.389962849121 (37.7540101165005, -122.389962849121)
147780 193338 2 88 1270 Minnesota St 3 1 1 1     3 Width 3ft   6015308.81376 2102546.1179299997 37.754051150748 -122.389967001302 (37.754051150748, -122.389967001302)
30570 193337 2 88 1270 Minnesota St 2 1 1 1     4 Width 3ft   6015308.479069999 2102559.27559 37.7540872603324 -122.389969077812 (37.7540872603324, -122.389969077812)
165822 193336 2 88 1270 Minnesota St 1 1 1 1     4 Width 3ft   6015307.256519999 2102573.04925 37.7541250120819 -122.38997426781499 (37.7541250120819, -122.389974267815)
51630 193333 2 88 1258 Minnesota St 4 1 1 1     2 Width 3ft   6015305.27356 2102653.19148 37.7543449556813 -122.389986723422 (37.7543449556813, -122.389986723422)
54895 193335 2 88 1260 Minnesota St 1 1 1 1     2 Width 3ft   6015305.18557 2102619.11987 37.7542513973846 -122.389984647787 (37.7542513973846, -122.389984647787)
60313 193334 2 88 1258 Minnesota St 5 1 1 1     2 Width 3ft   6015304.94166 2102636.75923 37.7542998178001 -122.38998672342 (37.7542998178001, -122.38998672342)
35331 193332 2 88 1258 Minnesota St 3 1 1 1     2 Width 3ft   6015304.05705 2102667.26372 37.7543835276007 -122.38999191341999 (37.7543835276007, -122.38999191342)
184199 193331 2 88 1258 Minnesota St 2 1 1 1     2 Width 3ft   6015302.57075 2102682.83592 37.754426203129 -122.38999814121 (37.754426203129, -122.38999814121)
137932 193330 2 88 1258 Minnesota St 1 1 1 1     2 Width 3ft   6015302.53629 2102695.98751 37.7544623126945 -122.389999179039 (37.7544623126945, -122.389999179039)
161946 193329 2 88 1240 Minnesota St 4 1 1 1     2 Width 3ft   6015301.017030001 2102739.65572 37.7545821320765 -122.390007483381 (37.7545821320765, -122.390007483381)
53186 106080 6 88 188 The Embarcadero 1 7 1 1   03/20/2014 12:00:00 AM     Permit Number 771259 6015087.8131 2116516.98611 37.7923997963133 -122.391708043282 (37.7923997963133, -122.391708043282)
61328 193352 2 88 1707 McKinnon Ave 1 4 1 1     4 Width 3ft   6014777.576230001 2096343.32459 37.736990099615 -122.39137057769199 (37.736990099615, -122.391370577692)
23030 17382 1 88 1627 Palou Ave 1 1 1 1   08/21/2015 12:00:00 AM 1 3X3 Permit Number 776412 6014690.32946 2095358.97831 37.7342824432881 -122.39160343105 (37.7342824432881, -122.39160343105)
185939 193350 2 88 1752 Quesada Ave 1 4 1 1     1 Width 4ft   6014471.5284 2095248.21375 37.7339661589078 -122.39235215802799 (37.7339661589078, -122.392352158028)
174129 193351 2 88 1752 Quesada Ave 2 4 1 1     1 Width 4ft   6014452.02014 2095263.45344 37.734006920685204 -122.392420670182 (37.7340069206852, -122.392420670182)
65040 84492 1 88 1726 Revere Ave 1 1 1 1   01/22/2008 12:00:00 AM 6 3x3 Permit Number 50144 6014424.88297 2094914.9156 37.733048399857005 -122.392490121246 (37.733048399857, -122.392490121246)
82853 88479 1 88 1751 Newcomb Ave   1 1 1   07/18/2008 12:00:00 AM 3 3x3 Permit Number 51431 6014386.0 2096253.8 37.7367225430205 -122.392718181551 (37.7367225430205, -122.392718181551)
173077 193354 2 88 75 Latona St 4 4 1 1     3 Width 2ft   6014363.50892 2094164.90475 37.7309856140862 -122.392649861509 (37.7309856140862, -122.392649861509)
181425 193353 2 88 75 Latona St 2 4 1 1     2 Width 2ft   6014356.71381 2094130.9148900001 37.730891907436295 -122.392670976684 (37.7308919074363, -122.392670976684)
45272 98453 1 88 518 Pennsylvania Ave 1 1 1 1   02/15/2012 12:00:00 AM 2 3x3 Permit Number 768642 6014340.87186 2104676.4561900003 37.7598468721503 -122.393463482668 (37.7598468721503, -122.393463482668)
165491 193346 2 88 1133 19th St 5 2 1 1     1 Width 3ft   6014187.49963 2105244.21667 37.761397296172 -122.394033672633 (37.761397296172, -122.394033672633)
187472 193345 2 88 1133 19th St 4 2 1 1     1 Width 3ft   6014171.26133 2105242.63423 37.7613920486234 -122.394089723782 (37.7613920486234, -122.394089723782)
164563 61691 1 88 61 Lucy St 1 1 1 1 1 11/05/1992 12:00:00 AM 4   Permit Number 31258 6014147.06906 2093799.2682599998 37.7299696274983 -122.393372558494 (37.7299696274983, -122.393372558494)
153849 193344 2 88 1133 19th St 3 2 1 1     1 Width 3ft   6014141.435 2105240.8231200003 37.761385417914205 -122.394192754591 (37.7613854179142, -122.394192754591)
150941 193359 2 88 208 Mission St 1 1 1 1     2 Width 4ft   6014052.912819999 2116289.5789400004 37.7917178877279 -122.39527291503299 (37.7917178877279, -122.395272915033)
160153 193360 2 88 208 Mission St 2 1 1 1     2 Width 4ft   6014042.14131 2116274.34783 37.7916754675957 -122.395309117238 (37.7916754675957, -122.395309117238)
33199 193347 2 88 444 Mississippi St 1 4 1 1     10 Width 4ft   6014042.11061 2105043.11718 37.760837039231205 -122.394522434371 (37.7608370392312, -122.394522434371)
34611 45681 1 88 440 Mississippi St 1 1 1 1   09/18/2001 12:00:00 AM 8   Permit Number 44368 6014041.208930001 2105068.9613799998 37.760907951647795 -122.39452736264099 (37.7609079516478, -122.394527362641)
127114 193361 2 88 246 Mission St 1 1 1 1     2 Width 4ft   6014025.95999 2116259.22664 37.7916330483898 -122.39536404513599 (37.7916330483898, -122.395364045136)
159964 193358 2 88 62 Main St 2 1 1 1     2 Width 4ft   6014021.3474 2116423.46881 37.79208376250261 -122.395391515812 (37.7920837625026, -122.395391515812)
66770 193362 2 88 246 Mission St 2 1 1 1     2 Width 4ft   6014011.61838 2116245.86436 37.7915955610366 -122.39541273082399 (37.7915955610366, -122.395412730824)
134536 193357 2 88 62 Main St 1 1 1 1     2 Width 4ft   6014010.133090001 2116432.89008 37.7921090073852 -122.395430978058 (37.7921090073852, -122.395430978058)
169527 193363 2 88 246 Mission St 3 1 1 1     2 Width 4ft   6014000.9996 2116238.17517 37.791573857707704 -122.39544893303801 (37.7915738577077, -122.395448933038)
57463 193356 2 88 60 Main St 2 1 1 1     2 Width 4ft   6014000.33626 2116445.25726 37.7921424198756 -122.395465742269 (37.7921424198756, -122.395465742269)
39423 193355 2 88 60 Main St 1 1 1 1     3 Width 4ft   6013990.6766 2116456.52969 37.792172834057496 -122.39549995516701 (37.7921728340575, -122.395499955167)
53678 193364 2 88 260 Mission St 1 1 1 1     2 Width 4ft   6013990.639330001 2116225.4508599997 37.791538343481605 -122.395483887876 (37.7915383434816, -122.395483887876)
66339 84782 1 88 228 Mississippi St 1 1 1 1   03/20/2007 12:00:00 AM 5   Permit No. 49243 6013990.15625 2105982.3752200003 37.763413148108505 -122.394767902514 (37.7634131481085, -122.394767902514)
137475 84780 1 88 224 Mississippi St 2 1 1 1   04/18/2007 12:00:00 AM 4   Permit No. 49287 6013987.25375 2106041.39506 37.7635750422708 -122.39478207494899 (37.7635750422708, -122.394782074949)
49125 84779 1 88 224 Mississippi St 1 1 1 1   04/18/2007 12:00:00 AM 3   Permit No. 49287 6013986.61648 2106050.38487 37.7635996908854 -122.394784908699 (37.7635996908854, -122.394784908699)
130079 193365 2 88 260 Mission St 2 1 1 1     1 Width 4ft   6013979.60171 2116214.89575 37.7915087476865 -122.39552133835899 (37.7915087476865, -122.395521338359)
186109 193366 2 88 260 Mission St 3 1 1 1     2 Width 4ft   6013970.035680001 2116205.7483599996 37.7914830990039 -122.395553795767 (37.7914830990039, -122.395553795767)
134263 193367 2 88 262 Mission St 1 1 1 1     2 Width 4ft   6013957.97413 2116198.08841 37.791461395664896 -122.395594991931 (37.7914613956649, -122.395594991931)
54394 193368 2 88 262 Mission St 2 1 1 1     2 Width 4ft   6013947.275280001 2116186.44855 37.79142884020779 -122.395631194149 (37.7914288402078, -122.395631194149)
32841 193369 2 88 262 Mission St 3 1 1 1     2 Width 4ft   6013943.1918 2116180.78279 37.791413056208704 -122.39564492587601 (37.7914130562087, -122.395644925876)
133388 193370 2 88 262 Mission St 4 1 1 1     2 Width 4ft   6013935.48002 2116174.11264 37.791394312559596 -122.39567114113001 (37.7913943125596, -122.39567114113)
172126 193371 2 88 264 Mission St 1 1 1 1     2 Width 4ft   6013926.2454699995 2116163.52102 37.791364716756 -122.395702350277 (37.791364716756, -122.395702350277)
14233 33800 1 88 77 Beale St 1 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013865.37275 2116161.97621 37.7913570887062 -122.39591286179899 (37.7913570887062, -122.395912861799)
16533 33792 1 88 77 Beale St 2 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013856.54517 2116173.60161 37.7913885182281 -122.395944220262 (37.7913885182281, -122.395944220262)
16231 33782 1 88 77 Beale St 3 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013852.02109 2116179.41654 37.7914042329729 -122.395960281264 (37.7914042329729, -122.395960281264)
14247 33783 1 88 77 Beale St 4 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013842.9233800005 2116188.62598 37.7914290137913 -122.395992405042 (37.7914290137913, -122.395992405042)
16526 33774 1 88 77 Beale St 5 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013834.28126 2116198.48682 37.791455608540396 -122.396022998165 (37.7914556085404, -122.396022998165)
13895 33780 1 88 77 Beale St 6 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013824.14126 2116210.79912 37.7914888510795 -122.39605894586 (37.7914888510795, -122.39605894586)
45125 193342 2 88 401 Texas St 4 4 1 1     1 Width 3ft   6013812.69862 2105193.07398 37.7612360315304 -122.39532637971901 (37.7612360315304, -122.395326379719)
13642 33785 1 88 77 Beale St 7 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013812.6799 2116223.3583 37.7915226979635 -122.39609948281701 (37.7915226979635, -122.396099482817)
14755 33779 1 88 77 Beale St 8 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013803.37475 2116233.23226 37.79154929181811 -122.396132371028 (37.7915492918181, -122.396132371028)
156067 193372 2 88 61 Beale St 1 1 1 1     2 Width 4ft   6013792.54079 2116244.01793 37.791578303941705 -122.39617061288999 (37.7915783039417, -122.39617061289)
54081 193373 2 88 61 Beale St 2 1 1 1     2 Width 4ft   6013783.27133 2116255.65231 37.7916097334637 -122.39620350109699 (37.7916097334637, -122.396203501097)
35824 131007 3 88 150x Drumm St 2 3 1 2     4 Width 7ft   6013687.07221 2117423.5151299997 37.7948110573238 -122.396618254944 (37.7948110573238, -122.396618254944)
25560 131008 3 88 150x Drumm St 3 3 1 2     4 Width 7ft   6013685.844769999 2117434.71438 37.7948417395127 -122.396623287539 (37.7948417395127, -122.396623287539)
54511 131009 3 88 150x Drumm St 4 3 1 2     4 Width 7ft   6013684.354719999 2117443.2289299998 37.794865035532396 -122.396629040522 (37.7948650355324, -122.396629040522)
134885 102443 1 88 514 Missouri St 1 1 1 1   08/07/2013 12:00:00 AM 1   Permit Number 770339 6013518.76597 2104573.81866 37.7595193399709 -122.396299571184 (37.7595193399709, -122.396299571184)
42961 193318 2 88 136 Hawthorne St 4 4 1 1     10 Width 2ft   6013332.96782 2113640.4980900004 37.7844040630434 -122.397578060899 (37.7844040630434, -122.397578060899)
29562 193317 2 88 136 Hawthorne St 3 4 1 1     9 Width 2ft   6013319.34244 2113654.62795 37.7844421016727 -122.397626191699 (37.7844421016727, -122.397626191699)
Powered by Datasette · Query took 5.77ms · Data source: data.sfgov.org