sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
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)
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)
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)
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)
47711 187781 2 109 101 Pennsylvania Ave 4 7 1 1     3     6014331.70125 2106323.79299 37.7643695906061 -122.393610496623 (37.7643695906061, -122.393610496623)
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)
51201 221569 2 109 616 Noe St 1 1 1 1     8 Width 3ft   6003001.08037 2104529.5167 37.7588068286936 -122.432671745707 (37.7588068286936, -122.432671745707)
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)
54543 187786 2 109 1650 Galvez Ave 1 17 1 1     6     6015560.61147 2097934.79581 37.7414033822515 -122.388774319486 (37.7414033822515, -122.388774319486)
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)
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)
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)
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)
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)
59268 187787 2 109 1650 Galvez Ave 2 17 1 1     7     6015518.873319999 2097965.1979799997 37.7414845469671 -122.388920758811 (37.7414845469671, -122.388920758811)
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)
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)
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)
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)
67739 187784 2 109 101 Pennsylvania Ave 35 7 1 1     4     6014258.31464 2106694.98019 37.765384711161104 -122.393890307196 (37.7653847111611, -122.393890307196)
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)
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)
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)
76798 187783 2 109 101 Pennsylvania Ave 26 7 1 1     4     6014314.48936 2106550.7653 37.764991850418895 -122.393685915597 (37.7649918504189, -122.393685915597)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
98416 115516 3 109 200x Guerrero St 7 11 1 2           6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
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)
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)
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)
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)
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)
Powered by Datasette · Query took 2.71ms · Data source: data.sfgov.org