sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
113114 92604 1 88 2201 Baker St 13 5 1 1   08/25/2009 12:00:00 AM   3x3 Permit Number 52915 5999814.0 2116396.0 37.7912079107295 -122.444546965455 (37.7912079107295, -122.444546965455)
132124 193349 2 88 2501 18th St 13 1 1 1     1 Width 5ft   6010309.72434 2105489.81742 37.761855376635104 -122.407462658778 (37.7618553766351, -122.407462658778)
500 6742 3 88 1300X Fairfax Ave 12 1 1 2   04/10/2017 01:53:00 PM 3 3x3   6016901.500630001 2097278.26947 37.7396749203573 -122.384092237585 (37.7396749203573, -122.384092237585)
3902 253544 3 88 1000 Cayuga Ave 12 13 1 2   10/03/2017 02:38:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
109413 92603 1 88 2201 Baker St 12 5 1 1   08/25/2009 12:00:00 AM   3x3 Permit Number 52915 5999814.0 2116396.0 37.7912079107295 -122.444546965455 (37.7912079107295, -122.444546965455)
505 6741 3 88 1300X Fairfax Ave 11 1 1 2   04/10/2017 01:50:00 PM 3 3x3   6016924.03316 2097256.8815900004 37.739617439282604 -122.38401284003099 (37.7396174392826, -122.384012840031)
3900 253543 3 88 1000 Cayuga Ave 11 13 1 2   10/03/2017 02:35:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
16611 116932 2 88 900x 24th St 11 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015412.75293 2102554.60022 37.7540802051572 -122.38960814389799 (37.7540802051572, -122.389608143898)
115103 89172 1 88 370 03rd St 11 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
124094 92602 1 88 2201 Baker St 11 5 1 1   08/25/2009 12:00:00 AM   3x3 Permit Number 52915 5999814.0 2116396.0 37.7912079107295 -122.444546965455 (37.7912079107295, -122.444546965455)
3896 253542 3 88 1000 Cayuga Ave 10 13 1 2   10/03/2017 02:42:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
16017 116931 2 88 900x 24th St 10 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015431.47773 2102556.1938099996 37.754085619065705 -122.38954349973301 (37.7540856190657, -122.389543499733)
93683 92601 1 88 2201 Baker St 10 5 1 1   08/25/2009 12:00:00 AM   3x3 Permit Number 52915 5999814.0 2116396.0 37.7912079107295 -122.444546965455 (37.7912079107295, -122.444546965455)
119795 450 3 88 700x 23rd Ave 10 11 1 2   05/29/2015 01:42:00 PM 3     5988819.93055 2110324.8097900003 37.773904673102 -122.48214070454901 (37.773904673102, -122.482140704549)
121536 89171 1 88 370 03rd St 10 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
3899 253541 3 88 1000 Cayuga Ave 9 13 1 2   10/03/2017 03:59:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
9836 6755 3 88 1215 Fairfax Ave 9 1 1 2   01/03/2017 06:41:00 AM 3 3x3   6017521.099066501 2096743.3718321999 37.7382404347673 -122.381912713319 (37.7382404347673, -122.381912713319)
14067 116930 2 88 900x 24th St 9 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015446.80292 2102557.08015 37.7540889024884 -122.389490562948 (37.7540889024884, -122.389490562948)
36826 218387 2 88 50 San Marcos Ave 9 2 1 1     2 Width 0ft   5993857.52408 2100226.90247 37.746470159084396 -122.46398181990101 (37.7464701590844, -122.463981819901)
77791 85870 3 88 2310 Folsom St 9 1 1 2   05/22/2007 12:00:00 AM 3 3x3   6008150.982530001 2104964.863142 37.760292906427296 -122.41489175995599 (37.7602929064273, -122.414891759956)
102499 89170 1 88 370 03rd St 9 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
116957 8230 3 88 1500X Galvez Ave 9 1 1 2   12/10/2015 08:33:00 AM 3 3x3   6016396.247314 2097296.3974116 37.739696749128896 -122.385840466933 (37.7396967491289, -122.385840466933)
116964 89192 1 88 370 03rd St 9 1 1 1   10/07/2008 12:00:00 AM   3x3 Permit Number 51807 6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
127852 92600 1 88 2201 Baker St 9 5 1 1   08/25/2009 12:00:00 AM   3x3 Permit Number 52915 5999814.0 2116396.0 37.7912079107295 -122.444546965455 (37.7912079107295, -122.444546965455)
182271 130978 2 88 2801 Webster St 9 10 1 1     1 Width 2ft   6002959.932159999 2118244.90398 37.7964635301195 -122.433794348725 (37.7964635301195, -122.433794348725)
3906 253540 3 88 1000 Cayuga Ave 8 13 1 2   10/03/2017 04:11:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
14755 33779 1 88 77 Beale St 8 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013803.37475 2116233.23226 37.79154929181811 -122.396132371028 (37.7915492918181, -122.396132371028)
16892 116929 2 88 900x 24th St 8 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015461.93425 2102556.8401200003 37.7540890823654 -122.38943821792401 (37.7540890823654, -122.389438217924)
123609 89169 1 88 370 03rd St 8 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
124483 37803 1 88 465 Woolsey St 8 1 1 1 1 12/02/2015 12:00:00 AM     Permit Number 774759 6010402.90992445 2091781.87036726 37.7242215408534 -122.406174555323 (37.7242215408534, -122.406174555323)
143973 89191 1 88 370 03rd St 8 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
153254 230343 2 88 65 Chenery St 8 1 1 1     1 Width 3ft   6004910.0558400005 2097921.66035 37.7407712613889 -122.42559933235 (37.7407712613889, -122.42559933235)
165318 130977 2 88 2801 Webster St 8 10 1 1     4 Width 2ft   6002958.5494099995 2118258.6214900003 37.7965011163873 -122.43380011427901 (37.7965011163873, -122.433800114279)
3940 179536 2 88 1880 Alemany Blvd 7 1 1 1   10/04/2017 10:42:00 AM 3 Width 3ft   6000969.55481 2091096.3953200001 37.7218072142025 -122.438735113438 (37.7218072142025, -122.438735113438)
13642 33785 1 88 77 Beale St 7 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013812.6799 2116223.3583 37.7915226979635 -122.39609948281701 (37.7915226979635, -122.396099482817)
16512 116928 2 88 900x 24th St 7 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015476.82973 2102557.66932 37.754092185022394 -122.38938676319599 (37.7540921850224, -122.389386763196)
37514 193348 2 88 2501 18th St 7 1 1 1     1 Width 5ft   6010227.27367 2105486.95448 37.7618429003376 -122.407747622459 (37.7618429003376, -122.407747622459)
44551 230342 2 88 65 Chenery St 7 1 1 1     1 Width 3ft   6004911.05921 2097907.1085200002 37.740731362062704 -122.42559482765499 (37.7407313620627, -122.425594827655)
69069 130976 2 88 2801 Webster St 7 10 1 1     3 Width 2ft   6002956.82977 2118266.12381 37.796521618235005 -122.433806601098 (37.796521618235, -122.433806601098)
94680 89190 1 88 370 03rd St 7 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
135397 218385 2 88 50 San Marcos Ave 7 2 1 1     4 Width 0ft   5993842.10795 2100214.10934 37.7464341439306 -122.46403419821999 (37.7464341439306, -122.46403419822)
160542 130984 2 88 2200 Beach St 7 9 1 1     1 Width 4ft   5999592.955130001 2120888.49408 37.803530487293 -122.445634974783 (37.803530487293, -122.445634974783)
168943 88037 1 88 2301X Lyon St 7 1 1 1   06/23/2008 12:00:00 AM 5 3x3 Permit Number 51052 5999275.57165 2116691.87228 37.7919895603315 -122.446431199448 (37.7919895603315, -122.446431199448)
13895 33780 1 88 77 Beale St 6 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013824.14126 2116210.79912 37.7914888510795 -122.39605894586 (37.7914888510795, -122.39605894586)
16727 116927 2 88 900x 24th St 6 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015494.24319 2102557.91546 37.7540938262957 -122.38932655988899 (37.7540938262957, -122.389326559889)
17962 5397 3 88 347 Dolores St 6 1 1 2   06/10/2014 12:00:00 AM 30 6x6   6004921.39011 2106378.39566 37.7639921298444 -122.42616204806002 (37.7639921298444, -122.42616204806)
21415 136 3 88 1025X 14th St 6 1 1 2     9 3X3   6001971.14414 2107605.72409 37.767194880067294 -122.436453906645 (37.7671948800673, -122.436453906645)
38961 230341 2 88 65 Chenery St 6 1 1 1     1 Width 3ft   6004909.36728 2097888.2006599996 37.7406793497697 -122.425599332346 (37.7406793497697, -122.425599332346)
45725 130982 2 88 3601 Broderick St 6 9 1 1     3 Width 4ft   5999659.44076 2120919.3234599996 37.8036189320344 -122.44540711714701 (37.8036189320344, -122.445407117147)
54260 177419 2 88 100 Capistrano Ave 6 1 1 1     2 Width 2ft   6001443.854169999 2093560.7227900003 37.7286006695825 -122.437271950666 (37.7286006695825, -122.437271950666)
55251 130983 2 88 2200 Beach St 6 9 1 1     1 Width 4ft   5999604.2907300005 2120890.91469 37.8035377808009 -122.44559592174 (37.8035377808009, -122.44559592174)
79562 114722 1 88 465 Woolsey St 6 1 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010466.6 2091788.0 37.724241933851296 -122.405954818575 (37.7242419338513, -122.405954818575)
84281 26689 3 88 1295X Pierce St 6 1 1 2     3 4X4   6002245.89461 2112942.9215 37.7818651028046 -122.435885513106 (37.7818651028046, -122.435885513106)
105976 112558 2 88 35 DOLORES ST 6 1 1 1   08/28/2015 12:00:00 AM   3x3   6004913.0 2108042.0 37.7685595148495 -122.426309519551 (37.7685595148495, -122.426309519551)
140338 89189 1 88 370 03rd St 6 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
169605 193341 2 88 1751 22nd St 6 17 1 1     2 Width 4ft   6012847.48484 2103764.38864 37.757259446178104 -122.398564409431 (37.7572594461781, -122.398564409431)
184007 130975 2 88 2801 Webster St 6 10 1 1     3 Width 2ft   6002956.23707 2118277.75105 37.796553509993 -122.43380948344101 (37.796553509993, -122.433809483441)
1063 248924 3 88 201x Cashmere St 5 1 1 2 3 04/29/2017 10:39:00 AM 3 3x3   6016272.0 2096170.0 37.7365970133228 -122.38619155869101 (37.7365970133228, -122.386191558691)
14030 116926 2 88 900x 24th St 5 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015510.15678 2102558.1918900004 37.7540954675573 -122.389271545654 (37.7540954675573, -122.389271545654)
15251 108093 1 88 2501X 18th St 5 1 1 1   11/20/2014 12:00:00 AM 3   Permit Number 773081 6010203.41719 2105485.67353 37.7618380476045 -122.40783004261999 (37.7618380476045, -122.40783004262)
16526 33774 1 88 77 Beale St 5 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013834.28126 2116198.48682 37.791455608540396 -122.396022998165 (37.7914556085404, -122.396022998165)
26519 115980 4 88 2x Olmstead St 5 1 1 1     1 3x3   6011593.71434 2091235.60939 37.722788156028706 -122.402019710862 (37.7227881560287, -122.402019710862)
49969 112557 2 88 35 DOLORES ST 5 1 1 1   08/28/2015 12:00:00 AM   3x3   6004913.0 2108042.0 37.7685595148495 -122.426309519551 (37.7685595148495, -122.426309519551)
59160 230296 2 88 3500 19th St 5 1 1 1     2 Width 5ft   6006123.351530001 2104947.42015 37.7601308699707 -122.421903157405 (37.7601308699707, -122.421903157405)
60313 193334 2 88 1258 Minnesota St 5 1 1 1     2 Width 3ft   6015304.94166 2102636.75923 37.7542998178001 -122.38998672342 (37.7542998178001, -122.38998672342)
82829 88007 1 88 1394 Masonic Ave 5 1 1 1 1 09/15/2010 12:00:00 AM   3x3 Permit Number 53732 5999618.7 2107794.0 37.7675778847064 -122.44460417005699 (37.7675778847064, -122.444604170057)
83713 99542 1 88 801X Central Ave 5 1 1 1   05/16/2012 12:00:00 AM   3x3 Permit Number 768631 5999563.7 2111218.2 37.776976730821794 -122.445040600733 (37.7769767308218, -122.445040600733)
90740 18413 3 88 799X Potrero Ave 5 1 1 2   03/05/2013 12:00:00 AM 3 4X4   6010481.346466599 2104567.7087473 37.759333078347105 -122.406804093165 (37.7593330783471, -122.406804093165)
108377 89188 1 88 370 03rd St 5 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
110433 99294 1 88 1300 Minnesota St 5 1 1 1   05/01/2012 12:00:00 AM   3x3 Permit Number 768897 6015320.4 2102511.6 37.753957014382 -122.38992452193199 (37.753957014382, -122.389924521932)
143836 103802 1 88 1157 Polk St 5 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006858.38304 2114906.78358 37.787518325661296 -122.42006782447201 (37.7875183256613, -122.420067824472)
144400 103811 3 88 1145 Polk St 5 1 1 2   11/01/2009 12:00:00 AM 3 3x3   6006819.8 2114898.5 37.7874934070669 -122.42020072617599 (37.7874934070669, -122.420200726176)
147660 230340 2 88 65 Chenery St 5 1 1 1     1 Width 3ft   6004910.8116 2097869.74707 37.7406287620114 -122.425593025396 (37.7406287620114, -122.425593025396)
161578 230318 2 88 107 Valley St 5 2 1 1     2 Width 4ft   6005160.92225 2099293.15868 37.744551255839795 -122.424829478514 (37.7445512558398, -122.424829478514)
164901 230299 2 88 590 York St 5 1 1 1     7 Width 3ft   6009785.6882 2105558.56974 37.762014809365 -122.409279952113 (37.762014809365, -122.409279952113)
165491 193346 2 88 1133 19th St 5 2 1 1     1 Width 3ft   6014187.49963 2105244.21667 37.761397296172 -122.394033672633 (37.761397296172, -122.394033672633)
167026 130974 2 88 2801 Webster St 5 10 1 1     4 Width 2ft   6002954.53886 2118286.2899 37.796576859099105 -122.433815970239 (37.7965768590991, -122.433815970239)
177912 130966 2 88 99 Moulton St 5 1 1 1     2 Width 3ft   6002966.56472 2119407.57255 37.7996562924699 -122.433854543963 (37.7996562924699, -122.433854543963)
181062 31608 1 88 5 Lucerne St 5 1 1 1   06/06/1995 12:00:00 AM 4   Permit Number 35133 6012020.8525 2109827.45516 37.7738611793697 -122.401849428724 (37.7738611793697, -122.401849428724)
10309 108845 1 88 420 Woolsey St 4 1 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 772583 6010479.05335 2091857.99264 37.7244348155857 -122.405916697196 (37.7244348155857, -122.405916697196)
14247 33783 1 88 77 Beale St 4 1 1 1   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013842.9233800005 2116188.62598 37.7914290137913 -122.395992405042 (37.7914290137913, -122.395992405042)
14797 116925 2 88 900x 24th St 4 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015524.58204 2102559.09611 37.7540987500629 -122.389221722302 (37.7540987500629, -122.389221722302)
22958 103860 3 88 1475 Polk St 4 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006677.0 2115920.4 37.7902912446707 -122.420767361582 (37.7902912446707, -122.420767361582)
27684 208849 2 88 15 Santa Rita Ave 4 2 1 1     24 Width 3ft   5993729.602000001 2100694.18749 37.7477458321253 -122.464458079273 (37.7477458321253, -122.464458079273)
28385 230289 2 88 3798 25th St 4 1 1 1     1 Width 4ft   6005260.07773 2101390.67485 37.750316153870294 -122.424635797817 (37.7503161538703, -122.424635797817)
33296 110565 2 88 135 Theresa St 4 1 1 1     7 3x9   6002103.512680001 2093689.48997 37.728991712774295 -122.43500068223301 (37.7289917127743, -122.435000682233)
35821 130973 2 88 2801 Webster St 4 10 1 1     1 Width 2ft   6002952.36205 2118301.89076 37.796619571497104 -122.43382461811501 (37.7966195714971, -122.433824618115)
36370 130994 2 88 800 Lombard St 4 1 1 1     8 Width 3ft   6008432.69085 2120383.1883 37.8026437557674 -122.41500878732401 (37.8026437557674, -122.415008787324)
42961 193318 2 88 136 Hawthorne St 4 4 1 1     10 Width 2ft   6013332.96782 2113640.4980900004 37.7844040630434 -122.397578060899 (37.7844040630434, -122.397578060899)
44168 177405 2 88 688 Vienna St 4 1 1 1     6 Width 2ft   6002677.6930599995 2089500.91725 37.71752341415829 -122.432716611994 (37.7175234141583, -122.432716611994)
45125 193342 2 88 401 Texas St 4 4 1 1     1 Width 3ft   6013812.69862 2105193.07398 37.7612360315304 -122.39532637971901 (37.7612360315304, -122.395326379719)
51630 193333 2 88 1258 Minnesota St 4 1 1 1     2 Width 3ft   6015305.27356 2102653.19148 37.7543449556813 -122.389986723422 (37.7543449556813, -122.389986723422)
53463 47067 1 88 604 Webster St 4 1 1 1   03/28/2012 12:00:00 AM 1   Permit Number 768780 6004041.40702 2110873.30571 37.7762842830232 -122.429526231047 (37.7762842830232, -122.429526231047)
54511 131009 3 88 150x Drumm St 4 3 1 2     4 Width 7ft   6013684.354719999 2117443.2289299998 37.794865035532396 -122.396629040522 (37.7948650355324, -122.396629040522)
60128 250187 2 88 665 Parker Ave 4 4 1 1     1 Width 4ft   5997222.68042 2110871.6887 37.7758914096851 -122.453113845732 (37.7758914096851, -122.453113845732)
60673 230347 2 88 1801 Church St 4 1 1 1     2 Width 3ft   6004579.28935 2098353.48586 37.741938260334294 -122.42677374352199 (37.7419382603343, -122.426773743522)
61520 130998 2 88 2201 Leavenworth St 4 9 1 1     5 Width 3ft   6007580.24685 2119942.9983 37.8013871663302 -122.41792745790899 (37.8013871663302, -122.417927457909)
72470 130987 2 88 1332 Bush St 4 1 1 1     2 Width 3ft   6006981.766419999 2115388.7011599997 37.7888485036088 -122.419675148215 (37.7888485036088, -122.419675148215)
73543 193322 2 88 2111 18th St 4 1 1 1     5 Width 4ft   6011436.66428 2105551.33646 37.762087307318104 -122.403569326371 (37.7620873073181, -122.403569326371)
80385 99541 1 88 801X Central Ave 4 1 1 1   05/16/2012 12:00:00 AM   3x3 Permit Number 768631 5999563.7 2111218.2 37.776976730821794 -122.445040600733 (37.7769767308218, -122.445040600733)
80871 88242 1 88 2501 Turk Blvd 4 1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51228 5998431.6 2111697.4 37.778227810594295 -122.44899139417299 (37.7782278105943, -122.448991394173)
Powered by Datasette · Query took 6.09ms · Data source: data.sfgov.org