sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
19680 82786 1 147 1910-12 Keith St 3 1 1 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52461 6015243.83790646 2093539.28137109 37.72931663038511 -122.389562713545 (37.7293166303851, -122.389562713545)
157689 197030 2 147 1601 Kirkwood Ave 2 4 1 1     4 Width 4ft   6015124.98776 2096779.4659400003 37.7382069300149 -122.39019987173401 (37.7382069300149, -122.390199871734)
132976 197029 2 147 1601 Kirkwood Ave 1 4 1 1     4 Width 4ft   6015115.28126 2096786.0121099998 37.738224366070106 -122.390233889493 (37.7382243660701, -122.390233889493)
121921 95064 3 147 4849X 03rd St 1 1 1 1     3 3x3   6014989.6 2095442.3 37.734527834908 -122.390574568357 (37.734527834908, -122.390574568357)
124525 92866 1 147 4800 03rd St 1 1 1 1     3 3x3   6014889.778059999 2095498.93005 37.7346777911521 -122.390923645427 (37.7346777911521, -122.390923645427)
101764 22308 3 147 5033 03rd St 3 1 1 2   04/24/2000 12:00:00 AM 3 3x3   6014806.8487599995 2094754.47288 37.7326290611665 -122.39115834308599 (37.7326290611665, -122.391158343086)
117701 95060 3 147 5033 03rd St 2 1 1 2     3 3x3   6014806.53085 2094754.47288 37.732629043524206 -122.391159442188 (37.7326290435242, -122.391159442188)
111319 22306 3 147 5015 03rd St 1 1 1 2     3 3x3   6014803.86419 2094824.41992 37.7328209559263 -122.39117354906 (37.7328209559263, -122.39117354906)
118628 22295 1 147 4910 03rd St 2 1 1 1     3 3x3   6014801.71028 2095185.44595 37.733812140558705 -122.391206222681 (37.7338121405587, -122.391206222681)
109696 95059 1 147 5115X 03rd St 4 1 1 1     3 3x3   6014711.63884 2094587.79956 37.7321661259618 -122.391475861678 (37.7321661259618, -122.391475861678)
121292 22304 3 147 5012X 03rd St 3 1 1 2     3 3x3   6014702.6472 2094891.22359 37.7329987676998 -122.39152815342301 (37.7329987676998, -122.391528153423)
165840 83748 1 147 235 Thornton Ave 1 1 1 1   07/18/2008 12:00:00 AM 4 3x3 Permit Number 51439 6013723.72454 2094177.53037 37.730984728264204 -122.39486260383 (37.7309847282642, -122.39486260383)
34563 197036 2 147 1751 Armstrong Ave 2 2 1 1     3 Width 4ft   6013567.3449099995 2093051.01085 37.7278828388179 -122.395324352636 (37.7278828388179, -122.395324352636)
158469 197035 2 147 1751 Armstrong Ave 1 2 1 1     4 Width 4ft   6013551.1098 2093063.74117 37.7279168907351 -122.39538136964799 (37.7279168907351, -122.395381369648)
26151 197034 2 147 1777 Armstrong Ave 1 2 1 1     5 Width 4ft   6013492.1426 2093105.4939599999 37.728028255576504 -122.395588146293 (37.7280282555765, -122.395588146293)
16217 22383 5 147 1799X Armstrong Ave 2 1 1 1   05/13/1997 12:00:00 AM 2 4x15   6013476.602999999 2093118.78047 37.7280638732384 -122.39564279807301 (37.7280638732384, -122.395642798073)
15294 94619 1 147 1799X Armstrong Ave 1 5 1 1   10/13/2010 12:00:00 AM 2   Permit Number 53777 6013459.79784 2093130.5142700002 37.7280951570487 -122.39570171627199 (37.7280951570487, -122.395701716272)
38308 197032 2 147 2425 Mendell St 1 2 1 1     3 Width 6ft   6013410.89228 2092904.9423599998 37.727473061829706 -122.395854985916 (37.7274730618297, -122.395854985916)
154682 197033 2 147 2421 Mendell St 1 2 1 1     3 Width 6ft   6013404.921569999 2092933.78448 37.7275519242636 -122.395877647031 (37.7275519242636, -122.395877647031)
18021 108056 1 147 535X Mission St 5 1 1 1   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.39829295327401 (37.7889890532579, -122.398292953274)
103499 108058 1 147 535X Mission St 7 1 1 1   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.39829295327401 (37.7889890532579, -122.398292953274)
107638 108055 1 147 535X Mission St 4 1 1 1   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.39829295327401 (37.7889890532579, -122.398292953274)
108163 108057 1 147 535X Mission St 6 1 1 1   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.39829295327401 (37.7889890532579, -122.398292953274)
157838 197037 2 147 176 Maddux Ave 1 4 1 1     2 Width 3ft   6012326.10159 2094826.6531599998 37.732689273593294 -122.399740013104 (37.7326892735933, -122.399740013104)
76599 114205 2 147 310 Carolina St 5 1 1 1     2 3x3   6012283.24048 2106396.5985 37.7644554605731 -122.40070071026399 (37.7644554605731, -122.400700710264)
169669 114203 2 147 310 Carolina St 3 1 1 1     3 3x3   6012282.10678 2106442.32004 37.764580938483704 -122.400707843686 (37.7645809384837, -122.400707843686)
130504 114204 2 147 310 Carolina St 4 1 1 1     2 3x3   6012281.598730001 2106430.0070700003 37.764547101481 -122.40070873583599 (37.764547101481, -122.400708735836)
131578 114201 2 147 310 Carolina St 1 1 1 1     2 3x3   6012278.4302 2106502.4698 37.7647458912325 -122.40072478603001 (37.7647458912325, -122.40072478603)
52838 114202 2 147 310 Carolina St 2 1 1 1     3 3x3   6012278.21126 2106491.69166 37.7647162846561 -122.400724786045 (37.7647162846561, -122.400724786045)
29865 197031 2 147 1950 Donner Ave 1 4 1 1     5 Width 3ft   6011564.47329 2093570.84173 37.729198590121 -122.40228490112301 (37.729198590121, -122.402284901123)
18013 109951 8 147 400x CLEMENTINA ST 11 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
77374 109950 8 147 400x CLEMENTINA ST 10 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
82275 109948 8 147 400x CLEMENTINA ST 8 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
92212 109944 8 147 400x CLEMENTINA ST 4 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
93248 109945 8 147 400x CLEMENTINA ST 5 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
93713 109942 8 147 400x CLEMENTINA ST 2 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
100892 109943 8 147 400x CLEMENTINA ST 3 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
104982 109946 8 147 400x CLEMENTINA ST 6 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
113160 109947 8 147 400x CLEMENTINA ST 7 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
144711 109941 8 147 400x CLEMENTINA ST 1 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
145620 109949 8 147 400x CLEMENTINA ST 9 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
178965 239171 2 147 1400 Potrero Ave 20 1 1 1     4 Width 2ft   6010775.13287 2100929.58266 37.7493600234457 -122.40553179815399 (37.7493600234457, -122.405531798154)
27616 239170 2 147 1400 Potrero Ave 17 1 1 1     4 Width 2ft   6010748.55016 2100997.3935 37.749544730724296 -122.405628497759 (37.7495447307243, -122.405628497759)
60926 239169 2 147 1400 Potrero Ave 14 1 1 1     4 Width 2ft   6010720.159580001 2101068.9953099997 37.749739745990894 -122.40573171655399 (37.7497397459909, -122.405731716554)
149452 197024 2 147 2 Waterloo St 1 1 1 1     3 Width 4ft   6010624.95454 2097233.34103 37.7392025469594 -122.405790793937 (37.7392025469594, -122.405790793937)
139273 239168 2 147 1400 Potrero Ave 12 1 1 1     4 Width 2ft   6010702.848069999 2101113.77684 37.749861738144396 -122.40579473475 (37.7498617381444, -122.40579473475)
43810 239167 2 147 1400 Potrero Ave 11 1 1 1     3 Width 2ft   6010693.269230001 2101137.12494 37.749925311216295 -122.405829503442 (37.7499253112163, -122.405829503442)
180815 239166 2 147 1400 Potrero Ave 10 1 1 1     4 Width 2ft   6010684.29962 2101159.52227 37.749986307743 -122.40586209846799 (37.749986307743, -122.405862098468)
61124 239165 2 147 1400 Potrero Ave 9 1 1 1     5 Width 2ft   6010673.4453300005 2101181.95766 37.7500473033606 -122.40590121358801 (37.7500473033606, -122.405901213588)
153397 197025 2 147 2 Waterloo St 2 1 1 1     3 Width 4ft   6010590.71236 2097235.47599 37.7392064940954 -122.405909338939 (37.7392064940954, -122.405909338939)
38314 239164 2 147 1400 Potrero Ave 8 1 1 1     5 Width 2ft   6010663.94961 2101209.37133 37.75012204421029 -122.405935981386 (37.7501220442103, -122.405935981386)
69456 239163 2 147 1400 Potrero Ave 7 1 1 1     4 Width 2ft   6010654.95431 2101230.51738 37.75017960352871 -122.40596857728701 (37.7501796035287, -122.405968577287)
76455 239162 2 147 1400 Potrero Ave 6 1 1 1     5 Width 2ft   6010646.644669999 2101254.46555 37.7502448951922 -122.40599899954799 (37.7502448951922, -122.405998999548)
79882 94762 1 147 10X Waterloo St 1 1 1 1   11/03/2010 12:00:00 AM   3x3 Permit Number 53881 6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
80263 94763 1 147 10X Waterloo St 2 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
94383 94764 1 147 10X Waterloo St 3 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
126197 94767 1 147 10X Waterloo St 5 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
138458 94765 1 147 10X Waterloo St 4 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
25154 239161 2 147 1400 Potrero Ave 4 1 1 1     4 Width 2ft   6010627.47447 2101300.53615 37.7503703227358 -122.406068536926 (37.7503703227358, -122.406068536926)
33987 239160 2 147 1400 Potrero Ave 2 1 1 1     4 Width 2ft   6010602.41193 2101365.81223 37.750548154678604 -122.40615980372601 (37.7505481546786, -122.406159803726)
57531 239159 2 147 1400 Potrero Ave 1 1 1 1     6 Width 2ft   6010593.731000001 2101386.95157 37.750605713091105 -122.40619131239201 (37.7506057130911, -122.406191312392)
72607 197026 2 147 2 Waterloo St 3 4 1 1     3 Width 4ft   6010467.19371 2097248.77404 37.7392360988707 -122.406337349712 (37.7392360988707, -122.406337349712)
37803 197027 2 147 2 Waterloo St 4 1 1 1     3 Width 4ft   6010417.49048 2097253.73995 37.739246953685395 -122.406509551872 (37.7392469536854, -122.406509551872)
158471 197028 2 147 2 Waterloo St 5 1 1 1     4 Width 4ft   6010376.04785 2097256.74048 37.739252873912704 -122.40665305401801 (37.7392528739127, -122.406653054018)
158027 239221 2 147 2810 26th St 3 1 1 1     7 Width 3ft   6010295.22869 2101085.95879 37.749762551916106 -122.407202347334 (37.7497625519161, -122.407202347334)
38302 239222 2 147 2830 26th St 1 1 1 1     5 Width 3ft   6010232.06115 2101082.77231 37.749750267174 -122.407420559713 (37.749750267174, -122.407420559713)
57803 239223 2 147 2850 26th St 1 1 1 1     6 Width 3ft   6010195.06778 2101081.2894 37.749744124791896 -122.407548380357 (37.7497441247919, -122.407548380357)
61349 239227 2 147 2851 26th St 2 1 1 1     8 Width 3ft   6010159.00691 2101032.6548200003 37.7496085663777 -122.40766965215201 (37.7496085663777, -122.407669652152)
69212 239226 2 147 2851 26th St 1 1 1 1     9 Width 3ft   6010136.754380001 2101030.89604 37.749602491463705 -122.407746478521 (37.7496024914637, -122.407746478521)
35302 239224 2 147 2850 26th St 3 1 1 1     5 Width 3ft   6010131.271430001 2101077.30272 37.7497296070346 -122.407768710669 (37.7497296070346, -122.407768710669)
9721 173654 3 147 118 06th St 1 1 1 2       3x3   6010152.0 2112318.0 37.7805951592946 -122.408489839314 (37.7805951592946, -122.408489839314)
56551 239228 2 147 819 York St 1 1 1 1     5 Width 3ft   6009935.7806 2104272.5292700003 37.7584920407792 -122.408670110163 (37.7584920407792, -122.408670110163)
174547 239220 2 147 2730 Bryant St 6 7 1 1     2 Width 7ft   6009770.4944400005 2101313.01983 37.750356630576796 -122.409032927236 (37.7503566305768, -122.409032927236)
154686 239219 2 147 2730 Bryant St 3 1 1 1     4 Width 4ft   6009767.82555 2101370.89854 37.7505154031821 -122.409046239907 (37.7505154031821, -122.409046239907)
54547 239225 2 147 3041 26th St 2 1 1 1     2 Width 4ft   6009370.46908 2100985.69041 37.7494354397039 -122.410393138328 (37.7494354397039, -122.410393138328)
127469 65253 1 147 1020 Florida St 1 1 1 1   07/21/2009 12:00:00 AM   3x3 Permit Number 52660 6009405.78315449 2103223.20926555 37.75558114637921 -122.410428993303 (37.7555811463792, -122.410428993303)
83671 82942 1 147 236 08th St 3 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52427 6009386.0 2110546.0 37.775686737909496 -122.411014612047 (37.7756867379095, -122.411014612047)
96771 102104 1 147 705X Tehama St 3 1 1 1       3x3 Permit Number 52427 6009386.0 2110546.0 37.775686737909496 -122.411014612047 (37.7756867379095, -122.411014612047)
107768 82751 1 147 52 Sheridan St 1 1 2 1   07/07/2009 12:00:00 AM 3 3x3 Permit Number 52446 6009256.89976445 2109417.42292722 37.772580689338 -122.41138145626002 (37.772580689338, -122.41138145626)
68673 249388 2 147 301 Eddy St 3 4 1 1     5 Width 3ft   6008934.66326 2113525.78003 37.78384318556579 -122.41278661472602 (37.7838431855658, -122.412786614726)
138658 51377 1 147 356 12th St 2 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52402 6008497.808835 2108622.2239572 37.770354654829504 -122.413950975697 (37.7703546548295, -122.413950975697)
30621 249356 2 147 625 Leavenworth St 2 4 1 1     2 Width 3ft   6008325.07213 2114654.93665 37.7869093422284 -122.414975526796 (37.7869093422284, -122.414975526796)
79900 95067 1 147 1575 South Van Ness Ave 2 1 1 1   12/15/2010 12:00:00 AM   3x3 Permit Number 54019 6007827.1 2100671.6 37.7484863781823 -122.415707927927 (37.7484863781823, -122.415707927927)
96940 95066 1 147 1575 South Van Ness Ave 1 1 1 1   12/15/2010 12:00:00 AM   3x3 Permit Number 54019 6007827.1 2100671.6 37.7484863781823 -122.415707927927 (37.7484863781823, -122.415707927927)
86372 74812 1 147 165-167 11th St 2 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
91409 82833 1 147 165-167 11th St 3 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
93976 82832 1 147 165-167 11th St 4 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
98771 74661 1 147 165-167 11th St 3 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
101698 82834 1 147 165-167 11th St 2 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
107641 74954 1 147 165-167 11th St 1 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
126209 74507 1 147 165-167 11th St 4 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
138910 82835 1 147 165-167 11th St 1 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
110849 91029 3 147 967 South Van Ness Ave 1 1 1 2   11/18/2008 12:00:00 AM 5 3x3   6007608.48742 2104034.949256 37.7577090789947 -122.416702122814 (37.7577090789947, -122.416702122814)
105339 82259 1 147 850 South Van Ness Ave 5 1 1 1 1 12/23/2011 12:00:00 AM 3 4x4 Permit Number 768603 6007525.28639452 2104705.22805815 37.759544830410704 -122.417037358657 (37.7595448304107, -122.417037358657)
145837 82263 1 147 850 South Van Ness Ave 1 1 1 1   12/23/2011 12:00:00 AM 5 4x4 Permit Number 768603 6007525.28639452 2104705.22805815 37.759544830410704 -122.417037358657 (37.7595448304107, -122.417037358657)
75691 239184 2 147 754 South Van Ness Ave 2 1 1 1     3 Width 3ft   6007487.61608 2105246.87358 37.761029944687294 -122.417206023563 (37.7610299446873, -122.417206023563)
80041 91027 3 147 722 South Van Ness Ave 3 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6007490.257402 2105446.273959 37.761577600545394 -122.417211018518 (37.7615776005454, -122.417211018518)
110318 91028 3 147 722 South Van Ness Ave 4 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6007490.257402 2105446.273959 37.761577600545394 -122.417211018518 (37.7615776005454, -122.417211018518)
126287 91026 3 147 722 South Van Ness Ave 2 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6007490.257402 2105446.273959 37.761577600545394 -122.417211018518 (37.7615776005454, -122.417211018518)
107618 39176 1 147 754 South Van Ness Ave 2 1 1 1   12/15/2009 12:00:00 AM     Permit Number 53085 6007474.0 2105260.0 37.761065220770504 -122.417254045994 (37.7610652207705, -122.417254045994)
184867 239183 2 147 720 South Van Ness Ave 4 1 1 1     3 Width 3ft   6007476.35772 2105397.09343 37.761441780224 -122.41725560676001 (37.761441780224, -122.41725560676)
Powered by Datasette · Query took 4.106ms · Data source: data.sfgov.org