sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
787 221428 3 109 100x Guerrero St 1 11 1 2   07/15/2016 05:47:00 AM 1 Width 3ft   6005427.7802 2108362.05998 37.769467407522896 -122.424551705821 (37.7694674075229, -122.424551705821)
2168 118346 3 109 100X Guerrero St 1 11 1 2   07/15/2016 05:47:00 AM 3              
4373 221456 3 109 300x Guerrero St 1 11 1 2   06/19/2015 10:59:00 AM 2 Width 3ft   6005491.36744 2107155.48275 37.7661580255906 -122.424245934501 (37.7661580255906, -122.424245934501)
4379 221468 3 109 400x Guerrero St 1 11 1 2   04/29/2015 10:37:00 AM 2 Width 3ft   6005525.86145 2106563.70328 37.764535087455 -122.42408453767099 (37.764535087455, -122.424084537671)
4411 221455 3 109 200x Guerrero St 1 11 1 2   02/09/2016 12:55:00 PM 1 Width 3ft   6005458.8795300005 2107745.71785 37.7677768358576 -122.424400289657 (37.7677768358576, -122.424400289657)
4507 221494 3 109 600x Guerrero St 1 11 1 2   02/21/2015 10:53:00 PM 2 Width 3ft   6005589.49697 2105398.2938599996 37.7613387412987 -122.423781567769 (37.7613387412987, -122.423781567769)
5138 152412 3 109 700x Guerrero St 1 11 1 2     0 Width 3ft   6005623.17605 2104812.38517 37.7597318749526 -122.4236234274 (37.7597318749526, -122.4236234274)
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)
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)
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)
43283 221415 3 109 800x Guerrero St 1 11 1 2     1 Width 3ft   6005678.5014 2103825.14435 37.7570242653802 -122.42336190183201 (37.7570242653802, -122.423361901832)
49955 91244 3 109 852x Guerrero St 1 11 1 2   01/20/2016 07:21:00 AM 3     6005625.0 2104006.0 37.757517833055395 -122.423559787953 (37.7575178330554, -122.423559787953)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
114885 110772 3 109 1000X GUERRERO ST 1 11 1 2   05/26/2015 03:10:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
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)
123181 91238 3 109 812x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3     6005612.0 2104238.0 37.7581541170225 -122.423621241698 (37.7581541170225, -122.423621241698)
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)
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)
123889 109693 3 109 600x GUERRERO ST 1 11 1 2   02/21/2015 10:53:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
128795 91254 3 109 928x Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3 3x100   6005681.9790819995 2103558.204453 37.7562915069181 -122.423330899086 (37.7562915069181, -122.423330899086)
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)
140294 110759 3 109 300X GUERRERO ST 1 11 1 2   06/19/2015 10:59:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
141128 91251 3 109 906X Guerrero St 1 11 1 2   11/20/2008 12:00:00 AM 3 3x100   6005675.14042 2103682.124768 37.756631377266295 -122.42336335858299 (37.7566313772663, -122.423363358583)
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)
141675 91237 3 109 808 Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3 4x15   6005611.0 2104262.0 37.7582199589604 -122.423626406477 (37.7582199589604, -122.423626406477)
169767 221481 3 109 500x Guerrero St 1 11 1 2     2 Width 3ft   6005557.328430001 2105982.39063 37.7629407171602 -122.423934361684 (37.7629407171602, -122.423934361684)
745 221429 3 109 100x Guerrero St 2 11 1 2   07/15/2016 05:39:00 AM 1 Width 3ft   6005428.96653 2108339.30361 37.76940499098671 -122.424545983407 (37.7694049909867, -122.424545983407)
4312 221469 3 109 400x Guerrero St 2 11 1 2   04/29/2015 10:33:00 AM 1 3x3   6005528.17729 2106528.83552 37.7644394796106 -122.42407404799499 (37.7644394796106, -122.424074047995)
4371 221454 3 109 200x Guerrero St 2 11 1 2   02/09/2016 12:48:00 PM 1 Width 3ft   6005462.2492 2107712.58298 37.7676860457059 -122.42438627731501 (37.7676860457059, -122.424386277315)
4372 221457 3 109 300x Guerrero St 2 11 1 2   06/19/2015 10:54:00 AM 1 Width 3ft   6005492.07657 2107122.67642 37.766067987261295 -122.42424114830798 (37.7660679872613, -122.424241148308)
4454 221495 3 109 600x Guerrero St 2 11 1 2   02/21/2015 10:54:00 PM 2 Width 3ft   6005593.17627 2105367.35468 37.761253997298205 -122.42376664264299 (37.7612539972982, -122.423766642643)
5110 152413 3 109 700x Guerrero St 2 11 1 2     0 Width 3ft   6005625.074080001 2104777.98262 37.7596375207611 -122.42361441706899 (37.7596375207611, -122.423614417069)
5643 118347 3 109 100X Guerrero St 2 11 1 2   07/15/2016 05:39:00 AM 3              
30827 221416 3 109 800x Guerrero St 2 11 1 2     2 Width 3ft   6005677.18728 2103848.76992 37.757089061516204 -122.42336812603399 (37.7570890615162, -122.423368126034)
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)
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)
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)
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)
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)
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)
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)
117919 91293 3 109 812x Guerrero St 2 11 1 2   11/20/2001 12:00:00 AM 3     6005612.0 2104238.0 37.7581541170225 -122.423621241698 (37.7581541170225, -122.423621241698)
118209 115511 3 109 200x Guerrero St 2 11 1 2   02/09/2016 12:48:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
118317 109694 3 109 600x GUERRERO ST 2 11 1 2   02/21/2015 10:54:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
118503 91256 3 109 940X Guerrero St 2 11 1 2   11/20/2008 12:00:00 AM 3 3x100   6005685.709261 2103490.611554 37.75610612308 -122.423313194032 (37.75610612308, -122.423313194032)
121602 110760 3 109 300X GUERRERO ST 2 11 1 2   06/19/2015 10:54:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
144929 110773 3 109 1000X GUERRERO ST 2 11 1 2   05/26/2015 03:06:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
145184 91240 3 109 842x Guerrero St 2 11 1 2   11/20/2009 12:00:00 AM 3     6005622.0 2104059.0 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211)
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)
169800 221482 3 109 500x Guerrero St 2 11 1 2     1 Width 3ft   6005559.28434 2105952.19302 37.762857912083795 -122.423925449408 (37.7628579120838, -122.423925449408)
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)
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)
772 221430 3 109 100x Guerrero St 3 11 1 2   07/15/2016 06:19:00 AM 1 Width 3ft   6005430.67341 2108312.23866 37.7693307735195 -122.424538153922 (37.7693307735195, -122.424538153922)
3394 118348 3 109 100X Guerrero St 3 11 1 2   07/15/2016 06:19:00 AM 3              
4354 221470 3 109 400x Guerrero St 3 11 1 2   04/29/2015 10:30:00 AM 1 Width 3ft   6005530.44166 2106496.00345 37.7643494583795 -122.42406388114401 (37.7643494583795, -122.424063881144)
4392 221453 3 109 200x Guerrero St 3 11 1 2   02/09/2016 12:40:00 PM 1 Width 3ft   6005462.88888 2107675.99901 37.7675856309877 -122.424381462352 (37.7675856309877, -122.424381462352)
4403 221458 3 109 300x Guerrero St 3 11 1 2   06/19/2015 10:49:00 AM 2 Width 3ft   6005493.2574 2107088.45627 37.7659740935515 -122.424234630048 (37.7659740935515, -122.424234630048)
4523 221496 3 109 600x Guerrero St 3 11 1 2   02/21/2015 12:00:00 AM 2 Width 3ft   6005594.03058 2105332.56679 37.761158526170895 -122.423761214331 (37.7611585261709, -122.423761214331)
5114 152414 3 109 700x Guerrero St 3 11 1 2     0 Width 3ft   6005626.99355 2104746.96336 37.7595524574982 -122.423605573157 (37.7595524574982, -122.423605573157)
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)
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)
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)
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)
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)
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)
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)
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)
115942 221483 3 109 500x Guerrero St 3 11 1 2     1 Width 3ft   6005560.35948 2105916.5024900003 37.7627599750213 -122.42391919281201 (37.7627599750213, -122.423919192812)
126273 109695 3 109 600x GUERRERO ST 3 11 1 2   02/21/2015 12:00:00 AM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
128230 110620 3 109 400X GUERRERO ST 3 11 1 2   04/29/2015 10:30:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
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)
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)
159637 221417 3 109 800x Guerrero St 3 11 1 2     1 Width 3ft   6005673.16306 2103886.4908 37.7571924071266 -122.42338472483101 (37.7571924071266, -122.423384724831)
766 221431 3 109 100x Guerrero St 4 11 1 2   07/15/2016 06:43:00 AM 1 Width 3ft   6005433.2519 2108280.1340799998 37.769242767658 -122.424526951068 (37.769242767658, -122.424526951068)
1982 118349 3 109 100X Guerrero St 4 11 1 2   07/15/2016 06:43:00 AM 3              
4370 221471 3 109 400x Guerrero St 4 11 1 2   04/29/2015 10:27:00 AM 1 Width 3ft   6005532.14271 2106464.3538900004 37.764262652233704 -122.42405574678301 (37.7642626522337, -122.424055746783)
Powered by Datasette · Query took 15.269ms · Data source: data.sfgov.org