sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4491 221497 3 109 600x Guerrero St 4 11 1 2   02/21/2015 10:57:00 PM 2 Width 3ft   6005595.06917 2105295.4476799998 37.761056664463204 -122.42375498292499 (37.7610566644632, -122.423754982925)
4499 221499 3 109 600x Guerrero St 6 11 1 2   02/28/2015 11:01:00 PM 2 Width 3ft   6005601.090469999 2105206.48742 37.760812740428904 -122.42372783238899 (37.7608127404289, -122.423727832389)
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)
4517 221503 3 109 600x Guerrero St 10 11 1 2   02/21/2015 11:06:00 PM 2 Width 3ft   6005610.53101 2105047.42068 37.7603765134773 -122.423683871708 (37.7603765134773, -122.423683871708)
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)
4526 221501 3 109 600x Guerrero St 8 11 1 2   02/21/2015 11:08:00 PM 2 Width 3ft   6005604.17413 2105138.97106 37.7606275304574 -122.423712366728 (37.7606275304574, -122.423712366728)
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)
5111 152416 3 109 700x Guerrero St 5 11 1 2     0 Width 3ft   6005631.99539 2104658.5890900004 37.7593100848133 -122.423581991114 (37.7593100848133, -122.423581991114)
5113 152421 3 109 700x Guerrero St 10 11 1 2     0 Width 3ft   6005642.99765 2104457.73967 37.7587592203909 -122.42352966049 (37.7587592203909, -122.42352966049)
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)
5118 152420 3 109 700x Guerrero St 9 11 1 2     0 Width 3ft   6005641.8915099995 2104501.69931 37.7588798608311 -122.42353661133998 (37.7588798608311, -122.42353661134)
5122 152419 3 109 700x Guerrero St 8 11 1 2     0 Width 3ft   6005637.900330001 2104551.94757 37.7590176055009 -122.423553987148 (37.7590176055009, -122.423553987148)
5127 152423 3 109 700x Guerrero St 12 11 1 2     0 Width 3ft   6005645.11359 2104396.78205 37.758591964470895 -122.423518008854 (37.7585919644709, -122.423518008854)
5131 152418 3 109 700x Guerrero St 7 11 1 2     0 Width 3ft   6005636.4507 2104585.0792400003 37.759108495478394 -122.42356135618999 (37.7591084954784, -122.42356135619)
5135 152417 3 109 700x Guerrero St 6 11 1 2     0 Width 3ft   6005634.27087 2104624.16733 37.7592156991708 -122.423571674116 (37.7592156991708, -122.423571674116)
5137 152415 3 109 700x Guerrero St 4 11 1 2     0 Width 3ft   6005628.48676 2104715.95286 37.7594673942256 -122.423598204106 (37.7594673942256, -122.423598204106)
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)
5168 152422 3 109 700x Guerrero St 11 11 1 2     0 Width 3ft   6005644.9376300005 2104427.7274700003 37.7586769234173 -122.423520817442 (37.7586769234173, -122.423520817442)
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              
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)
18919 110775 3 109 1000X GUERRERO ST 4 11 1 2   05/26/2015 02:57:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
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)
25703 221449 3 109 200x Guerrero St 7 11 1 2     1 Width 3ft   6005469.95975 2107527.1833200003 37.767177417921 -122.42434641935499 (37.767177417921, -122.424346419355)
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)
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)
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)
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)
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)
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)
38301 221488 3 109 500x Guerrero St 8 11 1 2     2 Width 3ft   6005571.71667 2105739.51079 37.7622746387822 -122.42386732621999 (37.7622746387822, -122.42386732622)
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)
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)
42902 221440 3 109 100x Guerrero St 13 11 1 2     1 Width 3ft   6005447.60224 2108007.88033 37.7684960344855 -122.424457946087 (37.7684960344855, -122.424457946087)
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)
44886 221418 3 109 800x Guerrero St 5 11 1 2     8 Width 3ft   6005666.2176 2103986.40391 37.757466353200996 -122.423415847665 (37.757466353201, -122.423415847665)
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)
47104 221492 3 109 500x Guerrero St 12 11 1 2     2 Width 3ft   6005579.45797 2105601.3239599997 37.761895647375205 -122.42383072560301 (37.7618956473752, -122.423830725603)
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)
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)
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)
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)
48680 221505 3 109 600x Guerrero St 12 11 1 2     2 Width 3ft   6005615.32825 2104975.43597 37.760179131174795 -122.423662162075 (37.7601791311748, -122.423662162075)
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)
51561 221489 3 109 500x Guerrero St 9 11 1 2     2 Width 3ft   6005574.236269999 2105711.57302 37.7621980705008 -122.423856625205 (37.7621980705008, -122.423856625205)
52085 221487 3 109 500x Guerrero St 7 11 1 2     2 Width 3ft   6005570.243559999 2105766.57088 37.762348856238205 -122.42387434542101 (37.7623488562382, -122.423874345421)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
Powered by Datasette · Query took 6.525ms · Data source: data.sfgov.org