sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
113542 110761 3 109 300X GUERRERO ST 3 11 1 2   06/19/2015 10:49:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
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)
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)
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)
111602 91252 3 109 908x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3 3x100   6005675.762116 2103670.859284 37.7566004799608 -122.42336040770901 (37.7566004799608, -122.423360407709)
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)
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)
110419 109704 3 109 600x GUERRERO ST 12 11 1 2   02/28/2015 10:40:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
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)
109310 91243 3 109 850x Guerrero St 1 11 1 2   02/10/2009 12:00:00 AM 3     6005625.0 2104018.0 37.7575507822519 -122.423560641088 (37.7575507822519, -122.423560641088)
108090 91255 3 109 940x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3 3x100   6005685.709261 2103490.611554 37.75610612308 -122.423313194032 (37.75610612308, -122.423313194032)
107320 109701 3 109 600x GUERRERO ST 9 11 1 2   02/21/2015 11:07:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
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)
106984 115515 3 109 200x Guerrero St 6 11 1 2   02/09/2016 11:34:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
106423 109703 3 109 600x GUERRERO ST 11 11 1 2   02/21/2015 11:05:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
105592 115519 3 109 200x Guerrero St 10 11 1 2   02/09/2016 11:45:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
105439 115510 3 109 200x Guerrero St 1 11 1 2   02/09/2016 12:55:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
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)
104357 110622 3 109 400X GUERRERO ST 5 11 1 2   04/29/2015 10:24:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
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)
102576 110781 3 109 1000X GUERRERO ST 10 11 1 2   05/26/2015 02:26:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
101837 110765 3 109 300X GUERRERO ST 7 11 1 2   06/19/2015 10:33:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
101466 91258 3 109 948x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3 3x100   6005688.196047001 2103445.549621 37.755982533848794 -122.423301390711 (37.7559825338488, -122.423301390711)
101453 91246 3 109 876x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3     6005633.0 2103862.0 37.7571228942355 -122.423521883288 (37.7571228942355, -122.423521883288)
100063 110650 3 109 400X GUERRERO ST 13 11 1 2   04/29/2015 05:03:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
99866 110766 3 109 300X GUERRERO ST 8 11 1 2   06/19/2015 10:29:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
98416 115516 3 109 200x Guerrero St 7 11 1 2           6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
97980 110776 3 109 1000X GUERRERO ST 5 11 1 2   05/26/2015 02:53:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
97820 110763 3 109 300X GUERRERO ST 5 11 1 2   06/19/2015 10:41:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
97329 115520 3 109 200x Guerrero St 11 11 1 2   02/09/2016 10:50:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
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)
95444 109697 3 109 600x GUERRERO ST 5 11 1 2   02/21/2015 10:59:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
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)
95136 110618 3 109 400X GUERRERO ST 1 11 1 2   04/29/2015 10:37:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
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)
94846 110770 3 109 300X GUERRERO ST 12 11 1 2   06/19/2015 10:14:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
94270 110769 3 109 300X GUERRERO ST 11 11 1 2   06/19/2015 10:17:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
94067 91239 3 109 842x Guerrero St 1 28 1 2   11/20/1989 12:00:00 AM 3     6005622.0 2104059.0 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211)
93719 110771 3 109 300X GUERRERO ST 13 11 1 2   06/19/2015 10:10:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
93547 110779 3 109 1000X GUERRERO ST 8 11 1 2   05/26/2015 02:35:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
92681 109700 3 109 600x GUERRERO ST 8 11 1 2   02/21/2015 11:08:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
91609 110624 3 109 400X GUERRERO ST 7 11 1 2   04/29/2015 10:16:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
91073 109698 3 109 600x GUERRERO ST 6 11 1 2   02/28/2015 11:01:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
90408 110621 3 109 400X GUERRERO ST 4 11 1 2   04/29/2015 10:27:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
90343 91247 3 109 880x Guerrero St 1 11 1 2   01/20/2016 07:29:00 AM 3     6005634.0 2103838.0 37.7570570522806 -122.423516718678 (37.7570570522806, -122.423516718678)
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)
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)
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)
88573 109696 3 109 600x GUERRERO ST 4 11 1 2   02/21/2015 10:57:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
88269 91249 3 109 870x Guerrero St 1 11 1 2   01/20/2016 07:26:00 AM 3     6005631.0 2103898.0 37.7572216289442 -122.423531359417 (37.7572216289442, -122.423531359417)
87711 91236 3 109 804 Guerrero St 1 22 1 2   11/20/2009 12:00:00 AM 3 3x100   6005614.0 2104300.0 37.758324467407704 -122.423618732861 (37.7583244674077, -122.423618732861)
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)
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)
86793 115518 3 109 200x Guerrero St 9 11 1 2   02/09/2016 12:33:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
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)
86391 184203 2 109 1466 41st Ave 1 1 1 1     1 Width 0ft   5983430.71 2105161.519 37.75941282066329 -122.500400782356 (37.7594128206633, -122.500400782356)
86005 110628 3 109 400X GUERRERO ST 11 11 1 2   04/29/2015 05:18:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
85719 110619 3 109 400X GUERRERO ST 2 11 1 2   04/29/2015 10:33:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
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)
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)
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)
83208 91248 3 109 888x Guerrero St 1 11 1 2   01/20/2016 07:34:00 AM 3     6005668.887935 2103795.421709 37.7569421113624 -122.423393035961 (37.7569421113624, -122.423393035961)
82614 91242 3 109 842x Guerrero St 3 11 1 2   11/20/2009 12:00:00 AM 3     6005622.0 2104059.0 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211)
82356 110764 3 109 300X GUERRERO ST 6 11 1 2   06/19/2015 10:37:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
82047 110777 3 109 1000X GUERRERO ST 6 11 1 2   05/26/2015 02:47:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
81262 110626 3 109 400X GUERRERO ST 9 11 1 2   04/29/2015 09:37:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
81226 110627 3 109 400X GUERRERO ST 10 11 1 2   04/29/2015 05:29:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
81008 110625 3 109 400X GUERRERO ST 8 11 1 2   04/29/2015 10:13:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
80584 110774 3 109 1000X GUERRERO ST 3 11 1 2   05/26/2015 03:02:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
80319 115517 3 109 200x Guerrero St 8 11 1 2   02/09/2016 12:52:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
80233 110778 3 109 1000X GUERRERO ST 7 11 1 2   05/26/2015 02:43:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
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)
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)
80086 37574 1 109 30 Collingwood St 1 1 1 1 1 08/15/2014 12:00:00 AM 3   Permit Number 773155 6001973.00287599 2105680.02476784 37.7619074866084 -122.43630964556101 (37.7619074866084, -122.436309645561)
79479 91245 3 109 870x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3     6005631.0 2103898.0 37.7572216289442 -122.423531359417 (37.7572216289442, -122.423531359417)
79149 91241 3 109 842x Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3     6005622.0 2104059.0 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211)
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)
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)
76798 187783 2 109 101 Pennsylvania Ave 26 7 1 1     4     6014314.48936 2106550.7653 37.764991850418895 -122.393685915597 (37.7649918504189, -122.393685915597)
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)
75755 115513 3 109 200x Guerrero St 4 11 1 2   02/09/2016 11:41:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
75610 221438 3 109 100x Guerrero St 11 11 1 2     2 Width 3ft   6005446.19377 2108068.2932700003 37.7686618344154 -122.42446711555901 (37.7686618344154, -122.424467115559)
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)
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)
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)
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)
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)
67739 187784 2 109 101 Pennsylvania Ave 35 7 1 1     4     6014258.31464 2106694.98019 37.765384711161104 -122.393890307196 (37.7653847111611, -122.393890307196)
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)
66900 221490 3 109 500x Guerrero St 10 11 1 2     3 Width 3ft   6005576.38505 2105666.63585 37.7620748049423 -122.423845997918 (37.7620748049423, -122.423845997918)
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)
65305 221484 3 109 500x Guerrero St 4 11 1 2     2 Width 3ft   6005563.22827 2105880.05418 37.7626600585326 -122.42390667874399 (37.7626600585326, -122.423906678744)
63120 105071 6 109 1808 Vallejo St 1 7 1 1     3   Permit Number 771033 6004794.05676 2118138.55822 37.796275437823894 -122.427440299436 (37.7962754378239, -122.427440299436)
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)
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)
59268 187787 2 109 1650 Galvez Ave 2 17 1 1     7     6015518.873319999 2097965.1979799997 37.7414845469671 -122.388920758811 (37.7414845469671, -122.388920758811)
55774 221419 3 109 800x Guerrero St 6 11 1 2     6 Width 3ft   6005664.4202 2104015.7148700003 37.7575467328056 -122.423424147502 (37.7575467328056, -122.423424147502)
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)
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)
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)
55100 221486 3 109 500x Guerrero St 6 11 1 2     3 Width 3ft   6005569.00136 2105791.30468 37.7624166992856 -122.423880400579 (37.7624166992856, -122.423880400579)
Powered by Datasette · Query took 3.169ms · Data source: data.sfgov.org