sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1982 118349 3 109 100X Guerrero St 4 11 1 2   07/15/2016 06:43:00 AM 3              
2168 118346 3 109 100X Guerrero St 1 11 1 2   07/15/2016 05:47:00 AM 3              
2766 118353 3 109 100X Guerrero St 8 11 1 2   07/15/2016 05:58:00 AM 3              
3111 118355 3 109 100X Guerrero St 10 11 1 2   07/15/2016 06:48:00 AM 3              
3394 118348 3 109 100X Guerrero St 3 11 1 2   07/15/2016 06:19:00 AM 3              
4215 118354 3 109 100X Guerrero St 9 11 1 2   07/15/2016 06:05:00 AM 3              
4374 118351 3 109 100X Guerrero St 6 11 1 2   07/15/2016 06:32:00 AM 3              
5429 118350 3 109 100X Guerrero St 5 11 1 2   07/15/2016 05:53:00 AM 3              
5643 118347 3 109 100X Guerrero St 2 11 1 2   07/15/2016 05:39:00 AM 3              
5661 118352 3 109 100X Guerrero St 7 11 1 2   07/15/2016 06:56:00 AM 3              
30241 201711 2 109 724 Jamestown Ave 1 1 1 1     9 Width 4ft   6015357.64919 2088292.5533900002 37.714916457608204 -122.388803118478 (37.7149164576082, -122.388803118478)
179218 201712 2 109 724 Jamestown Ave 2 1 1 1     6 Width 4ft   6015351.33364 2088303.0821 37.7149450173645 -122.388825682463 (37.7149450173645, -122.388825682463)
39265 201713 2 109 724 Jamestown Ave 3 1 1 1     9 Width 4ft   6015343.41284 2088314.94317 37.7149771465452 -122.38885388790001 (37.7149771465452, -122.3888538879)
33280 201714 2 109 726 Jamestown Ave 1 1 1 1     9 Width 4ft   6015317.96334 2088364.51894 37.715111861390795 -122.388945312084 (37.7151118613908, -122.388945312084)
161335 201715 2 109 726 Jamestown Ave 2 1 1 1     8 Width 4ft   6015296.606380001 2088393.85947 37.715191240972 -122.38902117888901 (37.715191240972, -122.389021178889)
129415 43734 1 109 777 Lakeview Ave 1 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43371 5994281.26699369 2089905.22565848 37.7181537802459 -122.46176829730601 (37.7181537802459, -122.461768297306)
105304 43729 1 109 763 Lakeview Ave 1 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43366 5994409.95328954 2089904.45905166 37.7181590824666 -122.461323431638 (37.7181590824666, -122.461323431638)
83271 43725 1 109 759 Lakeview Ave 2 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43364 5994445.58077229 2089904.10562801 37.7181601624587 -122.46120025798099 (37.7181601624587, -122.461200257981)
86576 43724 1 109 759 Lakeview Ave 1 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43364 5994445.58077229 2089904.10562801 37.7181601624587 -122.46120025798099 (37.7181601624587, -122.461200257981)
90094 54118 1 109 760 Lakeview Ave 1 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
111021 43728 1 109 760 Lakeview Ave 4 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
112173 43727 1 109 760 Lakeview Ave 3 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
141030 43726 1 109 760 Lakeview Ave 2 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
45394 203292 2 109 10 Jules Ave 2 1 1 1     2 Width 2ft   5994458.02189 2089982.3581700001 37.7183757412389 -122.461162923744 (37.7183757412389, -122.461162923744)
55253 203291 2 109 11 Jules Ave 3 1 1 1     4 Width 2ft   5994415.48252 2089998.39973 37.7184173393668 -122.461311125716 (37.7184173393668, -122.461311125716)
59935 203290 2 109 11 Jules Ave 2 1 1 1     5 Width 2ft   5994415.40381 2090011.1413599998 37.7184523203103 -122.46131232093201 (37.7184523203103, -122.461312320932)
35135 56924 1 109 140 Tingley St 1 1 1 1   08/15/1974 12:00:00 AM 3   Permit Number 14167 6002240.5096 2093994.70553 37.7298375431559 -122.434548888919 (37.7298375431559, -122.434548888919)
31521 175079 3 109 1104x Alemany Blvd 1 3 1 2     1 Width 10ft   6003837.73065 2094453.4628599999 37.7311877286109 -122.42905980937599 (37.7311877286109, -122.429059809376)
29150 221508 2 109 1201 San Jose Ave 15 7 1 1     1     6004291.813569999 2095940.5809 37.73529671397821 -122.427595874056 (37.7352967139782, -122.427595874056)
46563 221509 2 109 1201 San Jose Ave 38 7 1 1     2     6004439.440880001 2096038.0117799998 37.735572586401894 -122.42709240931102 (37.7355725864019, -122.427092409311)
144269 56594 1 109 533 Laidley St 1 1 1 1   11/16/2012 12:00:00 AM 3 3x3 Permit Number 768959 6003224.0 2096098.0 37.7356684939052 -122.431298930259 (37.7356684939052, -122.431298930259)
116885 96193 2 109 1640 Jerrold Ave 1 1 1 1     4 4x50   6015077.4 2097255.4 37.7395111076977 -122.39039765239299 (37.7395111076977, -122.390397652393)
54543 187786 2 109 1650 Galvez Ave 1 17 1 1     6     6015560.61147 2097934.79581 37.7414033822515 -122.388774319486 (37.7414033822515, -122.388774319486)
59268 187787 2 109 1650 Galvez Ave 2 17 1 1     7     6015518.873319999 2097965.1979799997 37.7414845469671 -122.388920758811 (37.7414845469671, -122.388920758811)
145556 66265 1 109 4020 26th St 1 1 1 1   10/30/1990 12:00:00 AM 3 6x9 Permit Number 29370 6003740.3803829 2100725.5739603 37.7484039979455 -122.429843577344 (37.7484039979455, -122.429843577344)
178254 221510 3 109 1300x Guerrero St 13 11 1 2     7 Width 3ft   6005838.80296 2100921.0233299998 37.7490592658716 -122.422601154533 (37.7490592658716, -122.422601154533)
185178 221511 3 109 1300x Guerrero St 11 11 1 2     6 Width 3ft   6005835.54562 2100976.57743 37.749211620932606 -122.422616365666 (37.7492116209326, -122.422616365666)
182868 221512 3 109 1300x Guerrero St 10 11 1 2     7 Width 3ft   6005835.43443 2101000.02463 37.749275995297296 -122.422618416129 (37.7492759952973, -122.422618416129)
41002 221513 3 109 1300x Guerrero St 9 11 1 2     7 Width 3ft   6005831.83209 2101056.03846 37.7494295931996 -122.42263485302799 (37.7494295931996, -122.422634853028)
73212 221514 3 109 1300x Guerrero St 8 11 1 2     8 Width 3ft   6005830.22915 2101083.18072 37.7495040291878 -122.42264232458 (37.7495040291878, -122.42264232458)
52769 221515 3 109 1300x Guerrero St 7 11 1 2     7 Width 3ft   6005828.19442 2101110.33186 37.7495784651962 -122.42265128992399 (37.7495784651962, -122.422651289924)
137049 221516 3 109 1300x Guerrero St 6 11 1 2     9 Width 3ft   6005827.472999999 2101138.31675 37.749655264584 -122.42265577304701 (37.749655264584, -122.422655773047)
153605 221517 3 109 1300x Guerrero St 4 11 1 2     7 Width 3ft   6005823.4134 2101214.1336 37.7498632112216 -122.422675198428 (37.7498632112216, -122.422675198428)
48258 221518 3 109 1300x Guerrero St 3 11 1 2     7 Width 3ft   6005823.14172 2101242.96968 37.7499423731511 -122.42267818684799 (37.7499423731511, -122.422678186848)
74207 221519 3 109 1300x Guerrero St 2 11 1 2     7 Width 3ft   6005822.7904900005 2101267.93468 37.7500109014944 -122.422681175305 (37.7500109014944, -122.422681175305)
85186 91292 3 109 1286x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3     6005762.0 2101471.0 37.7505650422621 -122.422905822788 (37.7505650422621, -122.422905822788)
109596 91294 3 109 1286x Guerrero St 2 11 1 2   11/20/2008 12:00:00 AM 3     6005762.0 2101471.0 37.7505650422621 -122.422905822788 (37.7505650422621, -122.422905822788)
90155 91291 3 109 1282x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3     6005761.0 2101495.0 37.7506308843168 -122.422910986406 (37.7506308843168, -122.422910986406)
150263 221520 3 109 1200x Guerrero St 13 11 1 2     6 Width 3ft   6005805.491090001 2101500.8171 37.7506493670819 -122.422757545722 (37.7506493670819, -122.422757545722)
182320 221521 3 109 1200x Guerrero St 12 11 1 2     7 Width 3ft   6005805.669319999 2101529.55059 37.7507282726947 -122.422758971142 (37.7507282726947, -122.422758971142)
32093 221522 3 109 1200x Guerrero St 11 11 1 2     18 Width 3ft   6005804.6365 2101559.54048 37.750810559762705 -122.42276467376999 (37.7508105597627, -122.42276467377)
96686 91289 3 109 1258x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3     6005785.088369001 2101640.018452 37.751030430802395 -122.422837991942 (37.7510304308024, -122.422837991942)
155379 221559 2 109 1306 York St 4 4 1 1     7 Width 3ft   6010039.89073 2101557.1439900002 37.7510420290671 -122.408118546954 (37.7510420290671, -122.408118546954)
25270 221523 3 109 1200x Guerrero St 8 11 1 2     7 Width 3ft   6005797.77147 2101666.82906 37.751104762181 -122.42279603761101 (37.751104762181, -122.422796037611)
10086 88538 2 109 1306 York St   5 1 1   06/26/2009 12:00:00 AM   3x12 Permit Number 52223 6010027.5 2101589.4 37.7511299031436 -122.40816367021999 (37.7511299031436, -122.40816367022)
113015 91288 3 109 1250x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3     6005751.0 2101683.0 37.751146524787295 -122.42295892763201 (37.7511465247873, -122.422958927632)
54972 221524 3 109 1200x Guerrero St 7 11 1 2     8 Width 3ft   6005795.8556 2101693.96335 37.7511791585977 -122.42280459107401 (37.7511791585977, -122.422804591074)
48249 221525 3 109 1200x Guerrero St 6 11 1 2     4 Width 3ft   6005795.99168 2101720.64475 37.7512524272579 -122.422806016491 (37.7512524272579, -122.422806016491)
73681 221526 3 109 1200x Guerrero St 5 11 1 2     8 Width 3ft   6005792.85635 2101748.62489 37.7513290773756 -122.42281884712601 (37.7513290773756, -122.422818847126)
65787 221527 3 109 1200x Guerrero St 4 11 1 2     7 Width 3ft   6005790.21854 2101800.81566 37.7514722323764 -122.422831677752 (37.7514722323764, -122.422831677752)
47639 221528 3 109 1200x Guerrero St 3 11 1 2     8 Width 3ft   6005788.731319999 2101828.76193 37.7515488824818 -122.422838806667 (37.7515488824818, -122.422838806667)
55516 221529 3 109 1200x Guerrero St 1 11 1 2     10 Width 3ft   6005786.9094 2101880.5255400003 37.751690910628 -122.42284878555701 (37.751690910628, -122.422848785557)
18710 91284 3 109 1212x Guerrero St 4 11 1 2   11/20/2008 12:00:00 AM 3     6005738.0 2101906.0 37.7517580978369 -122.42301973133999 (37.7517580978369, -122.42301973134)
48376 91282 3 109 1212x Guerrero St 2 11 1 2   11/20/2008 12:00:00 AM 3     6005738.0 2101906.0 37.7517580978369 -122.42301973133999 (37.7517580978369, -122.42301973134)
87539 91285 3 109 1212x Guerrero St 5 11 1 2   11/20/2008 12:00:00 AM 3     6005738.0 2101906.0 37.7517580978369 -122.42301973133999 (37.7517580978369, -122.42301973134)
94847 91287 3 109 1212x Guerrero St 7 11 1 2   11/20/2008 12:00:00 AM 3     6005738.0 2101906.0 37.7517580978369 -122.42301973133999 (37.7517580978369, -122.42301973134)
113634 91283 3 109 1212x Guerrero St 3 11 1 2   11/20/2008 12:00:00 AM 3     6005738.0 2101906.0 37.7517580978369 -122.42301973133999 (37.7517580978369, -122.42301973134)
120589 91286 3 109 1212x Guerrero St 6 11 1 2   11/20/2008 12:00:00 AM 3     6005738.0 2101906.0 37.7517580978369 -122.42301973133999 (37.7517580978369, -122.42301973134)
141379 91281 3 109 1212x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3     6005738.0 2101906.0 37.7517580978369 -122.42301973133999 (37.7517580978369, -122.42301973134)
89562 91280 3 109 1180x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3     6005731.0 2102090.0 37.75226292437829 -122.42305701527599 (37.7522629243783, -122.423057015276)
42667 221530 3 109 1100x Guerrero St 12 11 1 2     11 Width 3ft   6005772.5167 2102115.11175 37.75233421815221 -122.422915228372 (37.7523342181522, -122.422915228372)
150449 221531 3 109 1100x Guerrero St 11 11 1 2     0 Width 3ft   6005769.92765 2102140.767 37.7524045154572 -122.422926004956 (37.7524045154572, -122.422926004956)
80134 91278 3 109 1170x Guerrero St 2 11 1 2   11/20/2008 12:00:00 AM 3     6005728.0 2102148.0 37.752422009696005 -122.42307151190799 (37.752422009696, -122.423071511908)
84876 91279 3 109 1170x Guerrero St 3 11 1 2   11/20/2008 12:00:00 AM 3     6005728.0 2102148.0 37.752422009696005 -122.42307151190799 (37.752422009696, -122.423071511908)
123253 91277 3 109 1170x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3     6005728.0 2102148.0 37.752422009696005 -122.42307151190799 (37.752422009696, -122.423071511908)
159464 221532 3 109 1100x Guerrero St 10 11 1 2     8 Width 3ft   6005770.103999999 2102168.30473 37.7524801376575 -122.42292735211201 (37.7524801376575, -122.422927352112)
188083 221533 3 109 1100x Guerrero St 9 11 1 2     8 Width 3ft   6005767.42939 2102227.70946 37.75264309841 -122.422940823082 (37.75264309841, -122.422940823082)
87396 91276 3 109 1156x Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3     6005723.0 2102230.0 37.75264688060071 -122.42309463069999 (37.7526468806007, -122.4230946307)
158034 221565 2 109 4286 23rd St 2 1 1 1     1 Width 3ft   6001328.916669999 2102339.67059 37.7526990668325 -122.438297967381 (37.7526990668325, -122.438297967381)
179284 221563 2 109 4286 23rd St 4 1 1 1     1 Width 3ft   6001305.60339 2102341.6071 37.752703058000705 -122.438378727412 (37.7527030580007, -122.438378727412)
179875 221564 2 109 4286 23rd St 3 1 1 1     1 Width 3ft   6001316.917769999 2102341.7359599997 37.7527040553705 -122.438339609582 (37.7527040553705, -122.438339609582)
55535 221566 2 109 4286 23rd St 1 1 1 1     1 Width 3ft   6001342.8820400005 2102344.46852 37.7527130350975 -122.43825001643299 (37.7527130350975, -122.438250016433)
163113 221534 3 109 1100x Guerrero St 8 11 1 2     7 Width 3ft   6005765.63484 2102254.12398 37.7527155253202 -122.422948906168 (37.7527155253202, -122.422948906168)
103989 91275 3 109 1150x Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3     6005721.0 2102265.0 37.7527428696504 -122.423104034617 (37.7527428696504, -122.423104034617)
116212 91274 3 109 1144x Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3     6005719.0 2102300.0 37.7528388586979 -122.423113438558 (37.7528388586979, -122.423113438558)
129563 221535 3 109 1100x Guerrero St 6 11 1 2     4 Width 3ft   6005763.23809 2102308.0919 37.7528635735186 -122.42296102995199 (37.7528635735186, -122.422961029952)
139621 91273 3 109 1140x Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3     6005718.0 2102324.0 37.752904700718105 -122.423118602517 (37.7529047007181, -122.423118602517)
185218 221536 3 109 1100x Guerrero St 5 11 1 2     9 Width 3ft   6005762.1987 2102333.32685 37.75293280420979 -122.422966417762 (37.7529328042098, -122.422966417762)
123263 91272 3 109 1136x Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3     6005717.0 2102348.0 37.752970542737295 -122.423123766486 (37.7529705427373, -122.423123766486)
130218 221537 3 109 1100x Guerrero St 4 11 1 2     6 Width 3ft   6005757.84067 2102377.3752200003 37.753053504939 -122.422984619142 (37.753053504939, -122.422984619142)
107213 91271 3 109 1130x Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3     6005715.0 2102383.0 37.753066531779496 -122.423133170481 (37.7530665317795, -122.423133170481)
32785 221538 3 109 1100x Guerrero St 3 11 1 2     7 Width 3ft   6005757.68157 2102409.38047 37.7531413749784 -122.422987443927 (37.7531413749784, -122.422987443927)
177057 221539 3 109 1100x Guerrero St 2 11 1 2     5 Width 3ft   6005756.51513 2102435.1394700003 37.753212037416 -122.422993308391 (37.753212037416, -122.422993308391)
95405 91269 3 109 1120x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3     6005712.0 2102441.0 37.753225617065894 -122.423147667433 (37.7532256170659, -122.423147667433)
34243 221540 3 109 1100x Guerrero St 1 11 1 2     6 Width 3ft   6005754.92272 2102467.8076299997 37.753301646771 -122.42300113699301 (37.753301646771, -122.423001136993)
44105 221562 2 109 100 San Jose Ave 5 1 1 1     1 Width 3ft   6006161.28805 2102498.9287799997 37.753410020459995 -122.421598049829 (37.75341002046, -122.421598049829)
148793 221561 2 109 100 San Jose Ave 4 1 1 1     1 Width 3ft   6006161.81341 2102510.42937 37.7534416280528 -122.42159704977 (37.7534416280528, -122.42159704977)
71884 221560 2 109 100 San Jose Ave 3 1 1 1     1 Width 3ft   6006161.42459 2102519.64651 37.7534669142699 -122.42159904898001 (37.7534669142699, -122.42159904898)
116707 91266 3 109 1100X Guerrero St 2 11 1 2   06/21/2016 01:48:00 PM 3 3x500   6005744.445578 2102548.346221 37.753522195893105 -122.423043093148 (37.7535221958931, -122.423043093148)
67326 221557 3 109 1000x Guerrero St 15 11 1 2     3 Width 3ft   6005743.02813 2102638.73526 37.7537703032837 -122.42305441913099 (37.7537703032837, -122.423054419131)
180267 221556 3 109 1000x Guerrero St 14 11 1 2     3 Width 3ft   6005741.57845 2102677.06839 37.753875475376 -122.42306215689501 (37.753875475376, -122.423062156895)
Powered by Datasette · Query took 3.449ms · Data source: data.sfgov.org