sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1489 239150 3 147 100 Octavia St 1 1 1 2     4 Width 4ft   6005732.390269999 2109686.64828 37.773121606595105 -122.42359225870001 (37.7731216065951, -122.4235922587)
9721 173654 3 147 118 06th St 1 1 1 2       3x3   6010152.0 2112318.0 37.7805951592946 -122.408489839314 (37.7805951592946, -122.408489839314)
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)
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)
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)
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)
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)
20029 10244 3 147 99X Haight St 1 1 1 2   01/28/2000 12:00:00 AM 6 3X3   6005773.33687 2109613.89968 37.7729241676403 -122.42344544616002 (37.7729241676403, -122.42344544616)
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)
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)
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)
27650 239211 2 147 100 Hwy 101 Southbound 11 13 1 1     5     6005882.93751 2108938.64172 37.7710762568972 -122.42301832034501 (37.7710762568972, -122.423018320345)
27893 217747 2 147 625 Frederick St 1 4 1 1     4 Width 3ft   5996570.53056 2107292.29818 37.7660259340648 -122.455111074526 (37.7660259340648, -122.455111074526)
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)
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)
31969 239194 2 147 101 Hwy 101 Northbound 6 13 1 1     3     6005943.751730001 2109019.81978 37.7713025838749 -122.422813731768 (37.7713025838749, -122.422813731768)
32290 239198 2 147 101 Hwy 101 Northbound 10 13 1 1     3     6005918.91365 2109064.99496 37.771425222619705 -122.42290285910299 (37.7714252226197, -122.422902859103)
33973 239178 2 147 370 14th St 1 1 1 1     2 Width 3ft   6006302.56864 2107899.15692 37.7682457495759 -122.421492964039 (37.7682457495759, -122.421492964039)
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)
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)
34830 239214 2 147 100 Hwy 101 Southbound 7 13 1 1     6     6005859.14445 2108978.35649 37.771183961488106 -122.423103444792 (37.7711839614881, -122.423103444792)
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)
35375 239209 2 147 100 Hwy 101 Southbound 14 13 1 1     2     6005896.875990001 2108918.25042 37.7710210537973 -122.42296865708299 (37.7710210537973, -122.422968657083)
35585 239152 2 147 100 Octavia St 3 4 1 1     4 Width 4ft   6005729.11778 2109714.63204 37.773198258533895 -122.42360556863599 (37.7731982585339, -122.423605568636)
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)
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)
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)
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)
38350 239199 2 147 100 Hwy 101 Southbound 27 13 1 1     2     6005974.4493 2108807.19348 37.770720494984495 -122.422692434815 (37.7707204949845, -122.422692434815)
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)
44114 239182 2 147 3599 17th St 3 1 1 1     4 Width 3ft   6005021.22782 2106010.41037 37.7629873721785 -122.425790544398 (37.7629873721785, -122.425790544398)
44635 239192 2 147 101 Hwy 101 Northbound 4 13 1 1     6     6005960.3562900005 2108991.91912 37.771226912211795 -122.422754312663 (37.7712269122118, -122.422754312663)
45307 239204 2 147 100 Hwy 101 Southbound 21 13 1 1     4     6005940.87649 2108850.7859900002 37.7708382953675 -122.422811662426 (37.7708382953675, -122.422811662426)
45537 239188 2 147 1300 San Jose Ave 40 9 1 1     1     6003390.53226 2095588.92552 37.7342801275185 -122.430686848418 (37.7342801275185, -122.430686848418)
46484 239176 2 147 1748 15th St 1 1 1 1     4 Width 4ft   6005773.30835 2107281.9684900003 37.7665212410869 -122.42327974697201 (37.7665212410869, -122.423279746972)
46968 239180 2 147 370 14th St 4 1 1 1     2 Width 3ft   6006264.72566 2107896.23328 37.7682355881421 -122.42162365172301 (37.7682355881421, -122.421623651723)
47447 239172 2 147 66 Dorland St 2 1 1 1     9 Width 3ft   6005143.16857 2105759.69419 37.7623058551435 -122.42535095038299 (37.7623058551435, -122.425350950383)
50307 239175 2 147 1742 15th St 1 1 1 1     3 Width 4ft   6005792.615730001 2107282.2581599997 37.7665231260736 -122.42321298670099 (37.7665231260736, -122.423212986701)
52540 239181 2 147 380 14th St 3 1 1 1     2 Width 3ft   6006215.6761300005 2107893.9456599997 37.7682265409602 -122.42179314696001 (37.7682265409602, -122.42179314696)
52804 239179 2 147 370 14th St 2 1 1 1     2 Width 3ft   6006290.70185 2107898.44552 37.768243127135705 -122.42153395963601 (37.7682431271357, -122.421533959636)
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)
53022 239177 2 147 1778 15th St 1 1 1 1     1 Width 4ft   6005631.82803 2107273.89376 37.7664910841327 -122.42376852849199 (37.7664910841327, -122.423768528492)
53477 239185 2 147 483 South Van Ness Ave 1 1 1 1     5 Width 3ft   6007463.11739 2106828.6922 37.765371872436106 -122.41740285818199 (37.7653718724361, -122.417402858182)
54298 239149 2 147 8 Octavia St 13 4 1 1     3 Width 6ft   6005748.02057 2109577.9462099997 37.7728240191579 -122.423530461786 (37.7728240191579, -122.423530461786)
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)
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)
56900 239186 2 147 483 South Van Ness Ave 2 1 1 1     5 Width 3ft   6007463.67946 2106844.52399 37.7654153744566 -122.41740203617701 (37.7654153744566, -122.417402036177)
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)
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)
59769 239203 2 147 100 Hwy 101 Southbound 22 13 1 1     3     6005946.44181 2108844.1649 37.7708204294492 -122.42279194121402 (37.7708204294492, -122.422791941214)
60490 239208 2 147 100 Hwy 101 Southbound 17 13 1 1     3     6005920.35776 2108877.05935 37.7709092779754 -122.42288450484 (37.7709092779754, -122.42288450484)
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)
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)
61226 239216 2 147 100 Hwy 101 Southbound 3 13 1 1     5     6005843.543219999 2109006.7344400003 37.771261000120504 -122.42315942758499 (37.7712610001205, -122.423159427585)
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)
63424 239230 2 147 391 Church St 2 1 1 1     5 Width 3ft   6004227.15082 2106664.32977 37.7647379727106 -122.42858359946699 (37.7647379727106, -122.428583599467)
63559 136188 2 147 3598 Webster St 1 1 1 1     3 Width 3ft   6002648.6286 2120880.08452 37.8036813773578 -122.435060090577 (37.8036813773578, -122.435060090577)
63852 239189 2 147 101 Hwy 101 Northbound 1 13 1 1     3     6005983.85034 2108958.2836700003 37.7711358828561 -122.422670655046 (37.7711358828561, -122.422670655046)
64157 65681 1 147 345 08th Ave 1 1 1 1   03/03/2011 12:00:00 AM 3   Permit Number 767215 5993370.6959 2113311.72647 37.782369577363 -122.466616141073 (37.782369577363, -122.466616141073)
65016 239173 2 147 3705 25th St 3 1 1 1     6 Width 3ft   6005734.96606 2101372.66505 37.7502935116564 -122.422992320041 (37.7502935116564, -122.422992320041)
68215 239147 2 147 8 Octavia St 11 4 1 1     5 Width 6ft   6005750.76035 2109550.79453 37.7727496218289 -122.423519053867 (37.7727496218289, -122.423519053867)
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)
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)
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)
70626 239155 2 147 150 Octavia St 7 4 1 1     7 Width 4ft   6005700.01949 2109925.2105900003 37.7737748138817 -122.42372119899099 (37.7737748138817, -122.423721198991)
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)
72859 239145 2 147 101 Hwy 101 N Off Ramp 4 9 1 1     4 Width 5ft   6005859.0162 2109201.52808 37.7717967298683 -122.42311975398701 (37.7717967298683, -122.423119753987)
73553 239217 2 147 100 Hwy 101 Southbound 2 13 1 1     4     6005837.81281 2109017.0594 37.7712890265976 -122.423179983379 (37.7712890265976, -122.423179983379)
75553 239196 2 147 101 Hwy 101 Northbound 8 13 1 1     3     6005930.84591 2109041.9421200003 37.771362598325 -122.42285994612499 (37.771362598325, -122.422859946125)
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)
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)
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)
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)
77703 92591 1 147 445 Wawona St 14 1 1 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
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)
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)
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)
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)
81444 101926 8 147 1099X Hyde St 3 1 1 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639.0 2116135.7 37.790936579280896 -122.417454166812 (37.7909365792809, -122.417454166812)
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)
82949 55657 1 147 349 Coleridge St 1 1 1 1   07/14/2009 12:00:00 AM   3x3 Permit Number 52575 6006153.21523754 2098012.87204699 37.7410918742968 -122.421307424196 (37.7410918742968, -122.421307424196)
83586 82094 1 147 356 Funston Ave 1 1 1 1   06/03/2008 12:00:00 AM   3x3 Permit Number 50622 5991881.95379836 2113031.51992267 37.7815141826847 -122.471746056837 (37.7815141826847, -122.471746056837)
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)
85858 91025 1 147 140 South Van Ness Ave 8 1 1 1   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317)
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)
86387 87768 1 147 200 Beacon St   1 1 1   05/30/2008 12:00:00 AM   3x3 Permit Number 50472 6003134.0 2097619.0 37.739839710176895 -122.431718656253 (37.7398397101769, -122.431718656253)
86443 84663 1 147 4023 24th St 1 1 1 1 1 12/27/2012 12:00:00 AM 4 3x3 Permit Number 769743 6003022.50968447 2101807.41144942 37.7513337904703 -122.43240321347 (37.7513337904703, -122.43240321347)
87027 95700 1 147 101 Arbor St 1 1 1 1 1 03/09/2011 12:00:00 AM   3x3 Permit Number 767450 6001805.0 2096722.0 37.737301333655 -122.436249595043 (37.737301333655, -122.436249595043)
88388 92590 1 147 445 Wawona St 13 1 1 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
88534 87950 1 147 263a States St 1 1 1 1   06/19/2008 12:00:00 AM   3x3 Permit Number 50972 6000485.0 2106698.0 37.764617936044104 -122.441529100685 (37.7646179360441, -122.441529100685)
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)
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)
92280 84670 1 147 4089 24th St 1 1 1 1 1 12/27/2012 12:00:00 AM 4 3x3 Permit Number 769743 6002616.95424138 2101785.02656585 37.7512493217958 -122.433804069341 (37.7512493217958, -122.433804069341)
92650 92593 1 147 445 Wawona St 16 1 1 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
93008 84571 1 147 3991 24th St 1 1 1 1 1 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769743 6003245.44934651 2101819.71675357 37.7513802170554 -122.43163314148701 (37.7513802170554, -122.431633141487)
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)
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)
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)
94797 92592 1 147 445 Wawona St 15 1 1 1   08/24/2009 12:00:00 AM   3x3 Permit Number 52914 5991625.0 2097033.0 37.737571604455205 -122.471468876287 (37.7375716044552, -122.471468876287)
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)
Powered by Datasette · Query took 2.277ms · Data source: data.sfgov.org