sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
47711 187781 2 109 101 Pennsylvania Ave 4 7 1 1     3     6014331.70125 2106323.79299 37.7643695906061 -122.393610496623 (37.7643695906061, -122.393610496623)
181350 187782 2 109 101 Pennsylvania Ave 14 7 1 1     1     6014325.58247 2106437.08289 37.764680319857995 -122.39363958970199 (37.764680319858, -122.393639589702)
76798 187783 2 109 101 Pennsylvania Ave 26 7 1 1     4     6014314.48936 2106550.7653 37.764991850418895 -122.393685915597 (37.7649918504189, -122.393685915597)
67739 187784 2 109 101 Pennsylvania Ave 35 7 1 1     4     6014258.31464 2106694.98019 37.765384711161104 -122.393890307196 (37.7653847111611, -122.393890307196)
136012 187785 2 109 1740 20th St 2 9 1 1     1 Width 3ft   6012766.00153 2104746.33455 37.7599511143744 -122.39891512883499 (37.7599511143744, -122.398915128835)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
182798 221555 3 109 1000x Guerrero St 13 11 1 2     2 Width 3ft   6005738.9106 2102712.57542 37.753972818908 -122.423073906548 (37.753972818908, -122.423073906548)
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)
76663 221554 3 109 1000x Guerrero St 12 11 1 2     4 Width 3ft   6005736.5559 2102753.56312 37.754085228758505 -122.423084962814 (37.7540852287585, -122.423084962814)
68227 221553 3 109 1000x Guerrero St 11 11 1 2     3 Width 3ft   6005734.111409999 2102791.4847 37.7541892146839 -122.42309611170799 (37.7541892146839, -122.423096111708)
176544 221552 3 109 1000x Guerrero St 10 11 1 2     3 Width 3ft   6005734.10722 2102815.94179 37.754256367947704 -122.423097864468 (37.7542563679477, -122.423097864468)
143107 221551 3 109 1000x Guerrero St 9 11 1 2     2 Width 3ft   6005731.5319 2102850.00284 37.7543497463656 -122.423109191463 (37.7543497463656, -122.423109191463)
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)
177873 221550 3 109 1000x Guerrero St 7 11 1 2     1 Width 3ft   6005729.97057 2102894.68155 37.7544723356343 -122.423117766494 (37.7544723356343, -122.423117766494)
176764 221549 3 109 1000x Guerrero St 6 11 1 2     1 Width 3ft   6005728.89674 2102911.59468 37.7545187145683 -122.423122682192 (37.7545187145683, -122.423122682192)
169550 221558 3 109 1000x Guerrero St 5 11 1 2     3 Width 3ft   6005728.5881 2102926.2105099997 37.754558828830106 -122.423124788381 (37.7545588288301, -122.423124788381)
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)
131374 221548 3 109 1000x Guerrero St 4 11 1 2     3 Width 3ft   6005727.072790001 2102965.9789400003 37.7546679382008 -122.42313285530899 (37.7546679382008, -122.423132855309)
76927 221546 3 109 1000x Guerrero St 2 11 1 2     3 Width 3ft   6005723.96055 2103030.09242 37.7548438033068 -122.423148175257 (37.7548438033068, -122.423148175257)
135861 221547 3 109 1000x Guerrero St 3 11 1 2     3 Width 3ft   6005723.41397 2102999.7023 37.7547603282456 -122.42314790545299 (37.7547603282456, -122.423147905453)
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)
34286 221545 3 109 1000x Guerrero St 1 11 1 2     2 Width 3ft   6005721.87722 2103062.7074700003 37.754933239094704 -122.423157698184 (37.7549332390947, -122.423157698184)
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)
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)
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)
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)
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)
178961 221541 3 109 900x Guerrero St 8 11 1 2     6 Width 3ft   6005710.1718 2103251.3867 37.7554506478492 -122.423211590049 (37.7554506478492, -122.423211590049)
149575 221542 3 109 900x Guerrero St 7 11 1 2     8 Width 3ft   6005709.18006 2103278.9471400003 37.7555262664424 -122.423216978787 (37.7555262664424, -122.423216978787)
61658 221543 3 109 900x Guerrero St 6 11 1 2     8 Width 3ft   6005707.0284 2103306.91954 37.7556029507207 -122.42322640818999 (37.7556029507207, -122.42322640819)
168829 221544 3 109 900x Guerrero St 5 11 1 2     7 Width 3ft   6005705.623380001 2103333.32509 37.755675374928295 -122.423233144119 (37.7556753749283, -122.423233144119)
111105 91265 3 109 986x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3 3x100   6005700.008282 2103231.505425 37.7553954849101 -122.423245325469 (37.7553954849101, -122.423245325469)
148070 221507 3 109 900x Guerrero St 2 11 1 2     5 Width 3ft   6005699.48542 2103446.5929900003 37.755986035831704 -122.42326242243999 (37.7559860358317, -122.42326242244)
35380 221506 3 109 900x Guerrero St 1 11 1 2     5 Width 3ft   6005698.11962 2103476.06965 37.756066894799204 -122.423269241105 (37.7560668947992, -122.423269241105)
80089 91264 3 109 978X Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3 3x100   6005697.5214949995 2103276.567378 37.7555190742141 -122.423257128608 (37.7555190742141, -122.423257128608)
32169 221427 3 109 900x Guerrero St 6 11 1 2     6 Width 3ft   6005696.85287 2103501.5592 37.7561368116793 -122.42327543382099 (37.7561368116793, -122.423275433821)
111728 91263 3 109 970x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3 3x100   6005695.03471 2103321.62929 37.7556426634019 -122.42326893177601 (37.7556426634019, -122.423268931776)
46284 221426 3 109 900x Guerrero St 5 11 1 2     6 Width 3ft   6005693.61577 2103548.6076700003 37.7562658131324 -122.423289973179 (37.7562658131324, -122.423289973179)
134735 221425 3 109 900x Guerrero St 3 11 1 2     6 Width 3ft   6005689.68683 2103597.2936 37.7563992716189 -122.42330702161301 (37.7563992716189, -122.423307021613)
189094 221424 3 109 900x Guerrero St 2 11 1 2     6 Width 3ft   6005689.534530001 2103630.03961 37.7564891759384 -122.423309876046 (37.7564891759384, -122.423309876046)
78847 91259 3 109 952x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3 3x100   6005689.43944 2103423.018644 37.755920739203 -122.423295489065 (37.755920739203, -122.423295489065)
Powered by Datasette · Query took 3.712ms · Data source: data.sfgov.org