sf-trees

Data source: data.sfgov.org

Custom SQL query returning 57 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
27679 234916 2 84 1 Albion St 5 1 1 1     5 Width 2ft   6005792.88209 2107221.84485 37.766357260514 -122.423207770616 (37.766357260514, -122.423207770616)
94149 58408 1 84 755 Buena Vista Ave 1 1 1 1   03/19/1979 12:00:00 AM 5   Permit Number 17543 5999798.5 2108081.7 37.7683780948237 -122.44400294123699 (37.7683780948237, -122.444002941237)
117786 109243 1 84 755 Buena Vista Ave 2 1 1 1     4     5999798.5 2108081.7 37.7683780948237 -122.44400294123699 (37.7683780948237, -122.444002941237)
75325 196511 2 84 625 King St 1 2 1 1     10 Width 4ft   6011918.6881 2108412.1194599997 37.7699692876805 -122.402103311835 (37.7699692876805, -122.402103311835)
25681 196512 2 84 625 King St 2 2 1 1     9 Width 4ft   6011914.18479 2108425.06588 37.770004584260704 -122.402119799109 (37.7700045842607, -122.402119799109)
170723 196513 2 84 625 King St 3 2 1 1     11 Width 4ft   6011917.55402 2108434.4901900003 37.770030649334295 -122.402108807587 (37.7700306493343, -122.402108807587)
97214 17372 1 84 1050X Masonic Ave 2 1 1 1   10/24/2012 12:00:00 AM 6 3X3 Permit Number 769300 5999379.151930001 2109268.47217 37.771612740675394 -122.44553877169399 (37.7716127406754, -122.445538771694)
100159 52194 1 84 415 Buchanan St 2 1 1 1   11/03/2005 12:00:00 AM   3x3 Permit Number 48384 6004604.76721884 2109944.08482631 37.7737647507648 -122.42751119704201 (37.7737647507648, -122.427511197042)
125784 42766 1 84 415 Buchanan St 1 1 1 1 1 11/03/2005 12:00:00 AM   3x3 Permit Number 48384 6004604.76721884 2109944.08482631 37.7737647507648 -122.42751119704201 (37.7737647507648, -122.427511197042)
91181 51065 1 84 10 South Van Ness Ave 3 1 1 1   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047)
105516 51062 1 84 10 South Van Ness Ave 7 1 1 1   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047)
111577 51061 1 84 10 South Van Ness Ave 8 1 1 1   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047)
115880 51064 1 84 10 South Van Ness Ave 5 1 1 1   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047)
141391 51063 1 84 10 South Van Ness Ave 6 1 1 1   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047)
141745 51060 1 84 10 South Van Ness Ave 2 1 1 1   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047)
457 142162 2 84 490X Baker St 4 1 1 1     0 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
17606 6944 3 84 561 Fell St 1 1 1 2   03/09/2006 12:00:00 AM 3 3X3   6004740.44786 2110511.39404 37.7753301167361 -122.42708227125601 (37.7753301167361, -122.427082271256)
154486 142312 2 84 1691 Grove St 1 1 1 1     7 Width 0ft   5999733.1826 2110513.1611 37.775050545633796 -122.444403629404 (37.7750505456338, -122.444403629404)
189034 122230 2 84 700 14th Ave 1 2 1 1     6 Width 3ft   5991662.29598 2110580.8797299997 37.774772683199394 -122.472327258665 (37.7747726831994, -122.472327258665)
78119 105781 1 84 1631 MCALLISTER ST 1 1 1 1   03/03/2014 12:00:00 AM     Permit Number 772613 6001347.6 2111440.1 37.7776876665107 -122.43888545994 (37.7776876665107, -122.43888545994)
98329 40636 1 84 142 Russ St 1 1 1 1   08/10/1999 12:00:00 AM     Permit Number 41636 6010372.94752615 2111469.26002805 37.7782770896065 -122.40766561205099 (37.7782770896065, -122.407665612051)
116225 49367 1 84 1328@ 4th & 5t Anza St 1 1 1 1   04/29/2005 12:00:00 AM     Permit Number 47977 5994585.78557071 2112147.74022661 37.7792436288989 -122.46232804837099 (37.7792436288989, -122.462328048371)
131317 117739 2 84 475 39th Ave 1 2 1 1     4 Width 4ft   5983746.16527 2112679.78018 37.7800743257794 -122.49986552243 (37.7800743257794, -122.49986552243)
158870 141006 2 84 269 COLLINS ST 1 1 1 1     1 Width 0ft   5998171.183999999 2112777.5693 37.7811787774786 -122.449970134459 (37.7811787774786, -122.449970134459)
119284 116071 3 84 4150X CLEMENT ST 1 7 1 2     8 3x3   5983115.0 2113126.0 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527)
50088 1497 3 84 325 Arguello Blvd 3 1 1 2     2 3x3   5995534.5488977 2114067.6155393003 37.7845696798314 -122.45918496626999 (37.7845696798314, -122.45918496627)
107994 39201 1 84 36 Commonwealth Ave 1 1 1 1   11/23/1998 12:00:00 AM   3x3 Permit Number 40852 5996541.64157093 2114326.11365116 37.7853372927938 -122.455719478601 (37.7853372927938, -122.455719478601)
51063 120699 2 84 82 22nd Ave 1 1 1 1     8 Width 4ft   5988985.45615 2114833.30825 37.786293373056104 -122.48189845318501 (37.7862933730561, -122.481898453185)
144369 19033 1 84 3192 Sacramento St 1 1 1 1     12 2X2   5999542.700669999 2115392.3027 37.7884365373764 -122.44541344917101 (37.7884365373764, -122.445413449171)
90536 19034 1 84 3192 Sacramento St 2 5 1 1     12 2X2   5999529.89099 2115397.3219999997 37.7884495878023 -122.445458129536 (37.7884495878023, -122.445458129536)
113713 19022 1 84 3170 Sacramento St 1 1 1 1     12 2X2   5999571.77228 2115429.18678 37.7885394709311 -122.445315519372 (37.7885394709311, -122.445315519372)
123844 19023 3 84 3170 Sacramento St 2 1 1 2     7 2X2   5999571.77228 2115429.18678 37.7885394709311 -122.445315519372 (37.7885394709311, -122.445315519372)
145402 19024 3 84 3170 Sacramento St 3 1 1 2     6 2X2   5999571.77228 2115429.18678 37.7885394709311 -122.445315519372 (37.7885394709311, -122.445315519372)
188094 72435 2 84 339 Presidio Ave 1 1 1 1 1 04/13/1996 12:00:00 AM 13     5999048.262080001 2115432.1499099997 37.7885177095774 -122.447126990534 (37.7885177095774, -122.447126990534)
112476 19031 1 84 3190 Sacramento St 1 1 1 1     8 2X2   5999568.0947900005 2115476.97835 37.7886704841429 -122.445331680485 (37.7886704841429, -122.445331680485)
96787 19030 3 84 3176 SACRAMENTO ST 2 1 1 2     7 2x2   5999568.0 2115477.0 37.78867053817721 -122.44533201 (37.7886705381772, -122.44533201)
98177 19029 3 84 3176 SACRAMENTO ST 4 1 1 2     8 2x2   5999568.0 2115477.0 37.78867053817721 -122.44533201 (37.7886705381772, -122.44533201)
144726 19028 3 84 3176 SACRAMENTO ST 3 1 1 2     7 2x2   5999568.0 2115477.0 37.78867053817721 -122.44533201 (37.7886705381772, -122.44533201)
94724 84725 1 84 20 Cherry St 2 1 1 1   04/24/2007 12:00:00 AM     Permit No. 49296 5996092.0 2115960.0 37.7897976912986 -122.457393340224 (37.7897976912986, -122.457393340224)
19474 51214 1 84 111 Mission St 11 1 1 1   08/11/2004 12:00:00 AM     Permit Number 47578 6014394.74626942 2116530.73461445 37.7923990500381 -122.39410705418699 (37.7923990500381, -122.394107054187)
148635 136026 2 84 957 Sacramento St 1 10 1 1     3 Width 3ft   6010195.26054 2116841.12509 37.793017003381706 -122.408659357866 (37.7930170033817, -122.408659357866)
181728 136027 2 84 957 Sacramento St 2 10 1 1     4 Width 3ft   6010215.88282 2116843.14587 37.7930237069305 -122.408588145932 (37.7930237069305, -122.408588145932)
98763 249657 2 84 2401 Lyon St 9 7 1 1     5 Width 10ft   5999220.856459999 2117228.0712599996 37.7934586955217 -122.44665911012301 (37.7934586955217, -122.446659110123)
104294 43986 1 84 2200 Franklin St 1 1 1 1   09/08/2000 12:00:00 AM     Permit Number 43550 6005547.87197183 2117529.65351428 37.7946461451301 -122.42478860010799 (37.7946461451301, -122.424788600108)
78765 122579 2 84 2500X Lyon St 1 11 1 1     30 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
143403 122586 2 84 2500X Lyon St 6 11 1 1     12 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
40011 88560 1 84 2901 Pierce St   1 1 1   07/24/2008 12:00:00 AM   3x3 Permit Number 51505 6001501.0 2118350.0 37.7966692015857 -122.43885009322901 (37.7966692015857, -122.438850093229)
143271 88559 1 84 2901 Pierce St   1 1 1   07/24/2008 12:00:00 AM   3x3 Permit Number 51505 6001501.0 2118350.0 37.7966692015857 -122.43885009322901 (37.7966692015857, -122.438850093229)
36648 136020 2 84 1477 Green St 1 9 1 1     4 Width 2ft   6006004.56438 2118595.56069 37.7975986409201 -122.423284189634 (37.7975986409201, -122.423284189634)
158246 136025 2 84 80 MacOndray Ln 1 9 1 1     11     6008316.37067 2119137.06676 37.79921568041429 -122.415323048225 (37.7992156804143, -122.415323048225)
184295 136024 2 84 66 MacOndray Ln 1 9 1 1     9     6008379.74874 2119143.46885 37.7992368207748 -122.415104191024 (37.7992368207748, -122.415104191024)
165975 136022 2 84 60 MacOndray Ln 2 9 1 1     6     6008402.81482 2119144.69077 37.7992414720639 -122.415024460715 (37.7992414720639, -122.415024460715)
152816 136023 2 84 60 MacOndray Ln 3 9 1 1     3     6008389.23117 2119145.89275 37.7992440090735 -122.415071550105 (37.7992440090735, -122.415071550105)
85877 103517 1 84 55X MacOndray Ln 1 14 1 1         Permit Number 770452 6008432.0 2119159.0 37.7992824016355 -122.41492448290899 (37.7992824016355, -122.414924482909)
2581 107490 3 84 1306x Montgomery St 19 11 1 2     12     6011447.18476 2119974.7633599997 37.8016912541172 -122.404548295963 (37.8016912541172, -122.404548295963)
76569 136021 2 84 1010 Lombard St 1 2 1 1     12     6007482.49892 2120248.47345 37.802220422406705 -122.418287380977 (37.8022204224067, -122.418287380977)
92324 96987 1 84 2201 North Point St   9 1 1   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.44357930017799 (37.8026268776405, -122.443579300178)
Powered by Datasette · Query took 2.555ms · Data source: data.sfgov.org