sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
178112 178839 2 16 921 Prague St 1 1 1 1     1 Width 6ft   6001840.757 2086804.7866200001 37.7100729338953 -122.435416754499 (37.7100729338953, -122.435416754499)
97508 108899 1 18 16 Hanover St 1 1 1 1 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772775 6000547.04329 2086890.00633 37.710233369404605 -122.43989417722 (37.7102333694046, -122.43989417722)
182397 78518 2 16 75 Laura St 2 1 1 1 1 10/21/2000 12:00:00 AM 0     5997355.58596 2086978.87375 37.7102951905332 -122.450930851174 (37.7102951905332, -122.450930851174)
39626 78781 2 16 75 Laura St 1 1 1 1 1 10/21/2000 12:00:00 AM 0     5997342.70536 2086993.5441299998 37.7103347346378 -122.450976426135 (37.7103347346378, -122.450976426135)
136130 178972 2 18 856 Sunnydale Ave 1 1 1 1     1 Width 3ft   6009124.92679 2086754.6391599998 37.7103462396574 -122.410237598787 (37.7103462396574, -122.410237598787)
57287 178739 2 16 416 Peninsula Ave 3 1 1 1     5 Width 2ft   6012199.66481 2086699.2931099997 37.7103661434655 -122.39960671288999 (37.7103661434655, -122.39960671289)
137051 178842 2 16 856 Prague St 2 2 1 1     1 Width 6ft   6002039.2106099995 2086908.72872 37.7103696049432 -122.434738288839 (37.7103696049432, -122.434738288839)
59060 178841 2 16 856 Prague St 1 2 1 1     2 Width 6ft   6002067.276880001 2086921.00065 37.710404894347704 -122.434642162998 (37.7104048943477, -122.434642162998)
45234 178756 2 16 47 Garrison Ave 1 1 1 1     4 Width 2ft   6008299.13366 2086795.4391400001 37.710411944121596 -122.413094604643 (37.7104119441216, -122.413094604643)
105452 37342 1 18 507 Brunswick St 1 1 1 1 1 06/15/1998 12:00:00 AM 15   Permit Number 39850 5999504.92576 2086983.7691900001 37.71043144412221 -122.44350266602801 (37.7104314441222, -122.443502666028)
53799 178967 2 18 505 Brunswick St 1 1 1 1     15 Width 4ft   5999517.95201 2086983.4986400001 37.7104314441356 -122.44345762526899 (37.7104314441356, -122.443457625269)
155848 178895 2 35 240 Concord St 1 9 1 1     13 Width 10ft   5999918.78145 2087003.9139 37.7105103506437 -122.44207374220801 (37.7105103506437, -122.442073742208)
31556 178755 2 16 35 Garrison Ave 1 1 1 1     5 Width 2ft   6008316.596469999 2086843.3583099998 37.710544500606396 -122.413037635286 (37.7105445006064, -122.413037635286)
28887 84197 1 18 551 Sawyer St 1 1 1 1   06/05/2008 12:00:00 AM 8 3x3 Permit Number 50697 6007614.52495 2086883.3270299998 37.7106148095844 -122.41546698201 (37.7106148095844, -122.41546698201)
185410 178754 2 16 27 Garrison Ave 1 1 1 1     7 Width 2ft   6008327.5198 2086871.77855 37.7106231499219 -122.41300188991801 (37.7106231499219, -122.413001889918)
146266 109076 7 18 1137 Munich St 1 1 1 1 1     3x3 Permit Number 772744 6001554.7 2087011.6 37.7106245477128 -122.43642021389401 (37.7106245477128, -122.436420213894)
57825 78914 2 16 219 Concord St 1 1 1 1 1 03/22/2003 12:00:00 AM 3     5999956.6131 2087048.59536 37.7106351918399 -122.44194619318 (37.7106351918399, -122.44194619318)
161431 179036 2 18 551 Sawyer St 2 1 1 1     7 Width 3ft   6007618.72078 2086894.99872 37.7106470934606 -122.415453306029 (37.7106470934606, -122.415453306029)
82049 69397 1 18 1137 Munich St 1 1 1 1 1 01/23/2015 12:00:00 AM 3   Permit Number 772744 6001523.93675849 2087030.79827901 37.7106755138649 -122.436527911504 (37.7106755138649, -122.436527911504)
12718 109057 1 18 825 Huron Ave 1 1 1 1 1 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772770 5997289.5352300005 2087142.99435 37.7107420465867 -122.45117096298401 (37.7107420465867, -122.451170962984)
51659 178979 2 18 190 Rae Ave 3 1 1 1     6 Width 1ft   5997616.63139 2087136.8467599999 37.7107438892848 -122.450040007061 (37.7107438892848, -122.450040007061)
42755 178970 2 18 1029 Sunnydale Ave 3 1 1 1     5 Width 2ft   6008583.66239 2086910.8267599999 37.7107447436356 -122.412119359132 (37.7107447436356, -122.412119359132)
164778 178845 2 16 543 Sawyer St 2 1 1 1     8 Width 3ft   6007634.8415 2086934.3968099998 37.7107561785306 -122.415400376427 (37.7107561785306, -122.415400376427)
51769 178969 2 18 1029 Sunnydale Ave 2 1 1 1     5 Width 2ft   6008570.63643 2086915.27252 37.710756219889 -122.412164693966 (37.710756219889, -122.412164693966)
71089 84187 1 16 543 Sawyer St 1 1 1 1   06/05/2008 12:00:00 AM 8 3x3 Permit Number 50696 6007633.86618 2086936.80805 37.7107627444765 -122.41540391795601 (37.7107627444765, -122.415403917956)
168670 178978 2 18 190 Rae Ave 2 1 1 1     6 Width 1ft   5997625.81626 2087145.6195099999 37.7107685028255 -122.450008894089 (37.7107685028255, -122.450008894089)
155352 178968 2 18 1029 Sunnydale Ave 1 1 1 1     5 Width 2ft   6008554.00356 2086922.9270900001 37.710776304465 -122.412222721805 (37.710776304465, -122.412222721805)
80030 84222 1 18 1099 Sunnydale Ave 2 1 1 1   06/05/2008 12:00:00 AM   3x3 Permit Number 50699 6008536.64493866 2086928.58742632 37.710790872531796 -122.412283117187 (37.7107908725318, -122.412283117187)
93504 84211 1 18 1099 Sunnydale Ave 3 1 1 1   06/05/2008 12:00:00 AM   3x3 Permit Number 50699 6008536.64493866 2086928.58742632 37.710790872531796 -122.412283117187 (37.7107908725318, -122.412283117187)
141941 84223 1 18 1099 Sunnydale Ave 1 1 1 1   06/05/2008 12:00:00 AM   3x3 Permit Number 50699 6008536.64493866 2086928.58742632 37.710790872531796 -122.412283117187 (37.7107908725318, -122.412283117187)
133475 178977 2 18 190 Rae Ave 1 1 1 1     7 Width 1ft   5997636.8287 2087155.6990200002 37.71079680899621 -122.449971558745 (37.7107968089962, -122.449971558745)
130109 78715 2 16 190 Schwerin St 1 1 1 1 1 10/28/2000 12:00:00 AM 5     6008812.7369 2086938.0409099997 37.710832318719504 -122.411329543927 (37.7108323187195, -122.411329543927)
76801 178696 2 16 1121 Sunnydale Ave 1 1 1 1     6 Width 2ft   6008480.0549800005 2086950.0388900002 37.7108465981642 -122.41248022108101 (37.7108465981642, -122.412480221081)
187979 179663 2 198 333 Tocoloma Ave 1 1 1 1     8 Width 2ft   6012567.3674099995 2086868.9308 37.7108524248833 -122.398347742071 (37.7108524248833, -122.398347742071)
175027 51531 1 35 175 Rae Ave 1 1 1 1   01/14/2005 12:00:00 AM 1   Permit Number 47833 5997697.55511 2087175.4993200002 37.7108546506849 -122.449763101302 (37.7108546506849, -122.449763101302)
156949 178980 2 18 38 Whipple Ave 1 1 1 1     1 Width 2ft   5998273.4288099995 2087174.03892 37.7108835719974 -122.44777265158702 (37.7108835719974, -122.447772651587)
161728 179021 2 18 5642 Mission St 2 1 1 1     2 Width 3ft   5998317.810930001 2087173.37189 37.7108842770725 -122.447619209286 (37.7108842770725, -122.447619209286)
85059 51530 1 35 169 Rae Ave 1 1 1 1   01/14/2005 12:00:00 AM     Permit Number 47832 5997730.87276608 2087189.13752554 37.710894004264205 -122.449648930425 (37.7108940042642, -122.449648930425)
92213 99888 1 18 5646 Mission St 2 1 1 1   06/13/2012 12:00:00 AM   3x3 Permit Number 767758 5998305.1 2087181.1 37.710904770255105 -122.44766369700199 (37.7109047702551, -122.447663697002)
102810 99892 1 18 5646@ Whipple Mission St 4 1 1 1   06/13/2012 12:00:00 AM   3x3 Permit Number 767758 5998305.1 2087181.1 37.710904770255105 -122.44766369700199 (37.7109047702551, -122.447663697002)
103926 99890 1 18 5646@ Whipple Mission St 2 1 1 1   06/13/2012 12:00:00 AM   3x3 Permit Number 767758 5998305.1 2087181.1 37.710904770255105 -122.44766369700199 (37.7109047702551, -122.447663697002)
111780 99887 1 18 5646 Mission St 1 1 1 1   06/13/2012 12:00:00 AM   3x3 Permit Number 767758 5998305.1 2087181.1 37.710904770255105 -122.44766369700199 (37.7109047702551, -122.447663697002)
139392 99891 1 18 5646@ Whipple Mission St 3 1 1 1   06/13/2012 12:00:00 AM   3x3 Permit Number 767758 5998305.1 2087181.1 37.710904770255105 -122.44766369700199 (37.7109047702551, -122.447663697002)
146325 99889 1 18 5646@ Whipple Mission St 1 1 1 1   06/13/2012 12:00:00 AM   3x3 Permit Number 767758 5998305.1 2087181.1 37.710904770255105 -122.44766369700199 (37.7109047702551, -122.447663697002)
181085 178981 2 18 38 Whipple Ave 2 1 1 1     1 Width 2ft   5998261.9451 2087183.3832900003 37.7109085731488 -122.447813014086 (37.7109085731488, -122.447813014086)
88240 65746 1 16 252 Curtis St 1 1 1 1 1 04/20/1990 12:00:00 AM     Permit Number 28705 6000865.93587078 2087131.69490372 37.7109151403091 -122.438809330108 (37.7109151403091, -122.438809330108)
135851 31058 1 18 32 Winding Way 2 1 1 1 1 03/13/1995 12:00:00 AM 6   Permit Number 34809 6002732.75221 2087097.44922 37.71092714054029 -122.432354735598 (37.7109271405403, -122.432354735598)
165923 178982 2 18 38 Whipple Ave 3 1 1 1     2 Width 2ft   5998252.81183 2087192.10261 37.7109319923872 -122.447845208002 (37.7109319923872, -122.447845208002)
62486 179020 2 18 5642 Mission St 1 1 1 1     2 Width 3ft   5998346.4551 2087191.26802 37.7109350527871 -122.44752149612101 (37.7109350527871, -122.447521496121)
66305 54661 1 35 345 Peninsula Ave 1 1 1 1   07/27/1972 12:00:00 AM 2   Permit Number 10485 6012308.35839 2086909.49761 37.71094938168571 -122.399245788885 (37.7109493816857, -122.399245788885)
139522 51976 1 18 163 Rae Ave 1 1 1 1   08/18/2005 12:00:00 AM     Permit Number 48195 5997753.64161846 2087210.79293758 37.710954767676704 -122.449571795733 (37.7109547676767, -122.449571795733)
165739 178983 2 18 38 Whipple Ave 4 1 1 1     2 Width 2ft   5998242.85384 2087202.59008 37.710960219414794 -122.447880379569 (37.7109602194148, -122.447880379569)
161744 105552 2 198 329 Tocoloma Ave 1 1 1 1     9     6012582.61187 2086912.65676 37.7109733369276 -122.398298119266 (37.7109733369276, -122.398298119266)
163282 31057 1 18 32 Winding Way 1 1 1 1 1 03/13/1995 12:00:00 AM 5   Permit Number 34809 6002747.277969999 2087115.5773200002 37.7109777400017 -122.43230582505 (37.7109777400017, -122.43230582505)
10668 108896 1 35 312 Allison St 1 1 1 1 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772786 6000205.0169 2087170.16849 37.7109831566161 -122.441096373403 (37.7109831566161, -122.441096373403)
32097 179664 2 198 325 Tocoloma Ave 1 1 1 1     8 Width 1ft   6012585.69681 2086923.17392 37.711002386816 -122.398288194338 (37.711002386816, -122.398288194338)
183711 178832 2 16 26 Winding Way 1 1 1 1     8 Width 6ft   6002753.4939 2087126.6504400002 37.711008496830004 -122.43228513165 (37.71100849683, -122.43228513165)
68434 178697 2 16 170 Lawrence Ave 1 9 1 1     5 Width 2ft   5996822.297619999 2087264.10807 37.7110478340594 -122.452794569318 (37.7110478340594, -122.452794569318)
42877 179665 2 198 325 Tocoloma Ave 2 1 1 1     8 Width 1ft   6012591.22281 2086940.79015 37.7110510653234 -122.398270330217 (37.7110510653234, -122.398270330217)
72980 69395 1 18 1075 Munich St 1 1 1 1 1 05/09/1994 12:00:00 AM 4   Permit Number 33499 6002066.46838 2087158.9447 37.711058190666705 -122.43466196070801 (37.7110581906667, -122.434661960708)
10613 16409 3 198 1186X Munich St 2 1 1 2     42 TR   6001094.970430001 2087182.82135 37.7110685499383 -122.43802139438401 (37.7110685499383, -122.438021394384)
162407 65315 1 16 543 Blanken Ave 1 1 1 1   09/20/1989 12:00:00 AM 18   Permit Number 28137 6013067.51643 2086945.4340000001 37.711090336012504 -122.39662445846001 (37.7110903360125, -122.39662445846)
13060 109069 1 18 1065 Munich St 1 1 1 1 1 01/23/2015 12:00:00 AM 3 3x3 Permit Number 772763 6002105.570119999 2087176.80573 37.7111094529054 -122.434528092094 (37.7111094529054, -122.434528092094)
40726 178738 2 16 88 Gillette Ave 4 1 1 1     7 Width 3ft   6013102.20794 2086955.43637 37.7111197312489 -122.39650525601002 (37.7111197312489, -122.39650525601)
72038 178737 2 16 91 Gillette Ave 2 1 1 1     9 Width 2ft   6013141.93389 2086956.08513 37.7111237233427 -122.39636799789801 (37.7111237233427, -122.396367997898)
52624 86960 1 18 208 Head St 1 1 1 1   11/26/2007 12:00:00 AM 6 3x3 Permit Number 49928 5993493.7535 2087361.9529 37.71112519553311 -122.464305827668 (37.7111251955331, -122.464305827668)
133075 178840 2 16 1065 Munich St 2 1 1 1     1 Width 3ft   6002119.38667 2087187.3937099997 37.711139309492395 -122.434481095339 (37.7111393094924, -122.434481095339)
153282 179666 2 198 309 Tocoloma Ave 1 1 1 1     7 Width 3ft   6012604.11309 2086981.7039299998 37.7111641245081 -122.39822864665899 (37.7111641245081, -122.398228646659)
155089 179667 2 198 309 Tocoloma Ave 2 1 1 1     7 Width 3ft   6012610.18411 2086997.87945 37.711208877458404 -122.398208797709 (37.7112088774584, -122.398208797709)
170429 178896 2 35 424 Blanken Ave 2 1 1 1     2 Width 2ft   6012763.5947 2086999.9849599998 37.711223202768295 -122.397678716599 (37.7112232027683, -122.397678716599)
89222 89359 1 35 308 Tocoloma Ave 3 8 1 1   06/05/2008 12:00:00 AM   3x3 Permit Number 50704 6012556.9 2087009.2 37.7112369933076 -122.39839375585301 (37.7112369933076, -122.398393755853)
173907 179668 2 198 301 Tocoloma Ave 1 1 1 1     6 Width 3ft   6012612.993480001 2087008.97407 37.7112394975798 -122.398199865648 (37.7112394975798, -122.398199865648)
12196 86961 1 18 212 Head St 1 1 1 1   11/26/2007 12:00:00 AM 4 3x3 Permit Number 49929 5993495.99209 2087406.2303400002 37.7112468999028 -122.464301303157 (37.7112468999028, -122.464301303157)
182222 178965 2 35 748 Prague St 1 1 1 1     3 Width 4ft   6002497.1974599995 2087222.1001 37.7112560450962 -122.433177768149 (37.7112560450962, -122.433177768149)
45466 179637 2 198 120 Farragut Ave 6 9 1 1     6 Width 3ft   5997385.090419999 2087337.68892 37.7112821038472 -122.45085473348301 (37.7112821038472, -122.450854733483)
165663 179669 2 198 301 Tocoloma Ave 2 1 1 1     8 Width 3ft   6012620.012630001 2087029.4196400002 37.71129602805021 -122.39817703904801 (37.7112960280502, -122.398177039048)
11772 95029 1 35 13 Leland Ave 1 1 1 1     3 3x3   6010870.6461 2087075.073 37.71132378726 -122.40422653482 (37.71132378726, -122.40422653482)
10780 26783 1 35 6 Leland Ave 2 1 1 1     3 4X4   6010951.9721 2087077.0783 37.711333837408205 -122.40394559103301 (37.7113338374082, -122.403945591033)
12055 95028 1 35 21 Leland Ave 1 1 1 1     3 3x3   6010854.6037 2087083.0942 37.711344915432 -122.404282545919 (37.711344915432, -122.404282545919)
11844 95027 1 35 29 Leland Ave 1 1 1 1     3 3x3   6010839.0069 2087091.1154 37.711366068478 -122.404337016935 (37.711366068478, -122.404337016935)
13116 26784 1 35 6 Leland Ave 3 1 1 1     3 4X4   6010928.7998 2087090.8926 37.7113704740421 -122.40402665236999 (37.7113704740421, -122.40402665237)
149646 179794 2 198 640 Rolph St 1 9 1 1     3 Width 5ft   6002828.72839 2087264.3912099998 37.711390968591296 -122.432034933064 (37.7113909685913, -122.432034933064)
10565 94985 1 35 6 Leland Ave 4 1 1 1     3 3x3   6010907.8555 2087101.5876 37.7113986701374 -122.40409979381799 (37.7113986701374, -122.404099793818)
147925 69417 1 18 149 Seville St 1 1 1 1 1 05/09/1994 12:00:00 AM 7   Permit Number 33522 6001453.459840001 2087297.44526 37.7114036625088 -122.436790570551 (37.7114036625088, -122.436790570551)
11754 95026 1 35 33 Leland Ave 1 1 1 1     3 3x3   6010809.5958 2087105.821 37.7114048035242 -122.404439704211 (37.7114048035242, -122.404439704211)
12814 95025 1 35 37 Leland Ave 1 1 1 1     3 3x3   6010791.7709 2087116.9615 37.7114343969477 -122.40450209567699 (37.7114343969477, -122.404502095677)
11522 94986 1 35 6 Leland Ave 5 1 1 1     3 3x3   6010873.097 2087120.3037 37.711448118617 -122.404221245197 (37.711448118617, -122.404221245197)
34465 179159 2 18 113 Seville St 1 1 1 1     1 Width 4ft   6001727.04807 2087313.1468599997 37.711462320802205 -122.435846103423 (37.7114623208022, -122.435846103423)
12283 95024 1 35 41 Leland Ave 1 1 1 1     3 3x3   6010769.0442 2087127.6565 37.7114624931322 -122.404581397838 (37.7114624931322, -122.404581397838)
151564 179160 2 18 113 Seville St 2 1 1 1     1 Width 4ft   6001754.98626 2087320.62379 37.711484437814896 -122.43575007652599 (37.7114844378149, -122.435750076526)
10438 95023 1 35 45 Leland Ave 2 1 1 1     3 3x3   6010750.3281 2087136.1233 37.711484695229295 -122.404646681546 (37.7114846952293, -122.404646681546)
11422 26785 1 35 28 Leland Ave 1 1 1 1   10/13/1999 12:00:00 AM 3 3X3   6010847.2509 2087135.4549 37.7114882765061 -122.40431164223101 (37.7114882765061, -122.404311642231)
144970 179173 2 220 136 Seville St 1 1 1 1     3 Width 4ft   6001549.186980001 2087334.6879 37.7115113626193 -122.43646237733299 (37.7115113626193, -122.436462377333)
36774 69416 1 18 148 Seville St 1 1 1 1 1 05/09/1994 12:00:00 AM 2   Permit Number 33521 6001460.481240001 2087339.3254900002 37.7115190554232 -122.436769298869 (37.7115190554232, -122.436769298869)
11927 52333 1 35 30 Leland Ave 1 1 1 1   12/05/2005 12:00:00 AM 3   Permit Number 48484 6010821.8504 2087147.4867 37.7115198939825 -122.40440027981701 (37.7115198939825, -122.404400279817)
36399 179158 2 18 148 Seville St 2 1 1 1     4 Width 4ft   6001439.08808 2087342.2198599998 37.7115257868681 -122.436843446185 (37.7115257868681, -122.436843446185)
55272 179170 2 237 179 Seville St 1 1 1 1     3 Width 3ft   6001259.83204 2087347.3317200001 37.7115296332658 -122.437463366848 (37.7115296332658, -122.437463366848)
173547 37340 1 18 131 Brunswick St 1 1 1 1 1 06/15/1998 12:00:00 AM 10   Permit Number 39848 6000626.60293 2087367.0099799999 37.7115476439893 -122.43965337791799 (37.7115476439893, -122.439653377918)
12802 26786 1 35 34 Leland Ave 1 1 1 1     3 3X3   6010794.6675 2087161.3009 37.7115563058928 -122.404495203342 (37.7115563058928, -122.404495203342)
11853 94988 1 35 38 Leland Ave 1 1 1 1     3 3x3   6010771.4951 2087173.3327 37.711588047755605 -122.40457614013901 (37.7115880477556, -122.404576140139)
180223 179671 2 198 701 Delta St 1 9 1 1     7 Width 3ft   6009275.06023 2087222.94519 37.71164052686 -122.409751738267 (37.71164052686, -122.409751738267)
Powered by Datasette · Query took 69.539ms · Data source: data.sfgov.org