sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
55679 200228 2 39 1079 Ingerson Ave 2 19 1 1     7 Width 0ft   6013685.1573 2090181.4131 37.7200100518893 -122.394716195485 (37.7200100518893, -122.394716195485)
182621 200227 2 39 1079 Ingerson Ave 1 19 1 1     11 Width 0ft   6013668.3894 2090192.8153 37.7200404277679 -122.39477495490499 (37.7200404277679, -122.394774954905)
183984 200230 2 39 1079 Ingerson Ave 4 19 1 1     9 Width 0ft   6013720.7054 2090151.9015 37.7199309952824 -122.394591251483 (37.7199309952824, -122.394591251483)
28127 191847 2 39 2101 Newcomb Ave 1 17 1 1     23 Width 10ft   6012411.60288 2097770.43241 37.7407770404189 -122.39965102878901 (37.7407770404189, -122.399651028789)
43726 247881 2 39 387 Mayflower St 2 17 1 1     15     6009928.32781 2098399.30466 37.742365048010896 -122.4082816417 (37.7423650480109, -122.4082816417)
54010 247872 2 39 388 Mayflower St 2 17 1 1     23     6009895.64631 2098398.03188 37.7423597231243 -122.408394555183 (37.7423597231243, -122.408394555183)
136621 249776 2 39 102 Pfeiffer St 7 17 1 1     25 Width 0ft   6010370.54568 2121149.36884 37.804856202214204 -122.408356876268 (37.8048562022142, -122.408356876268)
169612 247876 2 39 388 Mayflower St 5 17 1 1     22     6009908.43883 2098395.0561 37.742352268652 -122.40835011248001 (37.742352268652, -122.40835011248)
172369 191849 2 39 1998 Revere Ave 1 17 1 1     18     6013048.000580001 2095925.65097 37.735747110629 -122.397321254093 (37.735747110629, -122.397321254093)
669 251343 7 39 934 Brannan St 1 13 1 1       3x3   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
27119 209185 2 39 140 Kensington Way 5 13 1 1     7 Width 3ft   5994853.690119999 2098493.2474700003 37.741767335194105 -122.460411617495 (37.7417673351941, -122.460411617495)
48070 209184 2 39 140 Kensington Way 4 13 1 1     16 Width 3ft   5994856.4919300005 2098484.57238 37.7417436767315 -122.460401301401 (37.7417436767315, -122.460401301401)
48281 209182 2 39 140 Kensington Way 2 13 1 1     17 Width 3ft   5994867.86795 2098472.15279 37.7417102300345 -122.46036106750799 (37.7417102300345, -122.460361067508)
60639 191813 2 39 300 Vermont St 6 13 1 1     25     6011137.70759 2106686.95849 37.7651887659782 -122.40468325722901 (37.7651887659782, -122.404683257229)
63607 191841 2 39 1501 Davidson Ave 9 13 1 1     23     6015067.74656 2099262.4877299997 37.7450216201491 -122.39057124226801 (37.7450216201491, -122.390571242268)
71300 191840 2 39 1501 Davidson Ave 8 13 1 1     16     6015034.2062 2099284.7294900003 37.7450808306162 -122.39068877377701 (37.7450808306162, -122.390688773777)
73581 191844 2 39 1501 Davidson Ave 14 13 1 1     27     6015247.82087 2099125.91751 37.7446566150196 -122.38993903417 (37.7446566150196, -122.38993903417)
73889 191811 2 39 300 Vermont St 3 13 1 1     24     6011131.47947 2106831.70462 37.76558585803421 -122.40471498982299 (37.7655858580342, -122.404714989823)
172795 191843 2 39 1501 Davidson Ave 11 13 1 1     20     6015141.47385 2099207.7707599998 37.7448754686187 -122.390312482158 (37.7448754686187, -122.390312482158)
172941 191812 2 39 300 Vermont St 5 13 1 1     23     6011136.684719999 2106709.3643099996 37.765250230128004 -122.404688372578 (37.765250230128, -122.404688372578)
174819 209181 2 39 140 Kensington Way 1 13 1 1     15 Width 3ft   5994876.85162 2098459.48593 37.7416759667651 -122.46032908762699 (37.7416759667651, -122.460329087627)
177691 209186 2 39 140 Kensington Way 6 13 1 1     12 Width 3ft   5994849.5459 2098494.81966 37.741771413634794 -122.46042606063 (37.7417714136348, -122.46042606063)
177754 209147 2 39 75 Ralston St 3 13 1 1     16     5992171.618 2088327.33496 37.7136996047335 -122.46894561897 (37.7136996047335, -122.46894561897)
180957 191842 2 39 1501 Davidson Ave 10 13 1 1     15     6015112.514169999 2099226.0983 37.744924185813396 -122.390413900506 (37.7449241858134, -122.390413900506)
182862 209187 2 39 156 Kensington Way 1 13 1 1     9 Width 3ft   5994832.7400400005 2098518.64338 37.7418358608449 -122.460485895213 (37.7418358608449, -122.460485895213)
182994 191809 2 39 300 Vermont St 1 13 1 1     19     6011127.66334 2106895.1514 37.76575985524929 -122.404732656101 (37.7657598552493, -122.404732656101)
183262 191810 2 39 300 Vermont St 2 13 1 1     18     6011130.07486 2106859.15267 37.7656611456652 -122.40472178059099 (37.7656611456652, -122.404721780591)
189024 209189 2 39 156 Kensington Way 3 13 1 1     9 Width 3ft   5994812.38667 2098544.02713 37.7419043873887 -122.460558108972 (37.7419043873887, -122.460558108972)
5380 23543 3 39 2800X Van Ness Ave 1 11 1 2     35 9   6005659.04127 2120027.6333 37.8015112413055 -122.424581715282 (37.8015112413055, -122.424581715282)
6534 23551 3 39 2900X Van Ness Ave 1 11 1 2     30     6005612.78895 2120375.11437 37.802462723129395 -122.424766503478 (37.8024627231294, -122.424766503478)
7152 29781 3 39 2000X Van Ness Ave 3 11 1 2   03/12/2006 12:00:00 AM 3     6006021.95745 2117391.75426 37.7942942736085 -122.42313839334601 (37.7942942736085, -122.423138393346)
8259 23442 3 39 2100X Van Ness Ave 1 11 1 2     24 9   6005990.50725 2117651.28863 37.795005114851 -122.42326567258301 (37.795005114851, -122.423265672583)
10299 1295 3 39 4000X Alemany Blvd 3 11 1 2     25 10   5991914.74417 2087134.82891 37.710410426081 -122.46974669545901 (37.710410426081, -122.469746695459)
10727 1298 3 39 4000X Alemany Blvd 6 11 1 2     25 10   5991889.9079 2087118.85792 37.7103651380077 -122.46983137204599 (37.7103651380077, -122.469831372046)
10785 1296 3 39 4000X Alemany Blvd 4 11 1 2     35 10   5991907.39965 2087130.17274 37.710397216839496 -122.46977174067499 (37.7103972168395, -122.469771740675)
10821 1299 3 39 4000X Alemany Blvd 7 11 1 2     40 10   5991881.88808 2087114.90346 37.7103538164401 -122.46985880224301 (37.7103538164401, -122.469858802243)
11437 1297 3 39 4000X Alemany Blvd 5 11 1 2     25 10   5991899.37983 2087126.21827 37.7103858952584 -122.46979917089199 (37.7103858952584, -122.469799170892)
17146 2013 3 39 500X Bosworth St 6 11 1 2     12 10   6002577.1884699995 2095292.92439 37.7334212632741 -122.433477690263 (37.7334212632741, -122.433477690263)
17205 26909 3 39 10 Caine Ave 5 11 1 2     18 10   5997629.54091 2089680.9775599998 37.71773022584279 -122.45017865014299 (37.7177302258428, -122.450178650143)
17236 19195 3 39 150 Sanchez St 2 11 1 2     24 3X3   6003512.4095 2107418.3103 37.76676774608121 -122.431109521045 (37.7667677460812, -122.431109521045)
17237 26912 3 39 10 Caine Ave 8 11 1 2     50 10   5997598.31865 2089637.50605 37.7176090763688 -122.450283439137 (37.7176090763688, -122.450283439137)
19083 26913 3 39 10 Caine Ave 9 11 1 2     24 10   5997584.35365 2089616.43233 37.717550413599795 -122.45033019131 (37.7175504135998, -122.45033019131)
19195 26910 3 39 10 Caine Ave 6 11 1 2     12 10   5997620.43146 2089669.0920400003 37.7176970696553 -122.45020928103399 (37.7176970696553, -122.450209281034)
19231 2011 3 39 500X Bosworth St 4 11 1 2     12 10   6002543.1242 2095301.43659 37.7334427031002 -122.433596068029 (37.7334427031002, -122.433596068029)
19342 26905 3 39 10 Caine Ave 1 11 1 2     12 10   5997683.40035 2089758.8108400002 37.7179470200262 -122.449998089654 (37.7179470200262, -122.449998089654)
19416 2014 3 39 500X Bosworth St 7 11 1 2     18 10   6002609.44021 2095285.23051 37.733401967419205 -122.43336563743799 (37.7334019674192, -122.433365637438)
19538 16588 3 39 88X Noe St 2 11 1 2     6 3X3   6002852.6033 2107735.26664 37.7676006199961 -122.43341433031401 (37.7676006199961, -122.433414330314)
19568 26708 3 39 88X Noe St 1 11 1 2     12 3   6002857.07874 2107723.1475299997 37.767567597789295 -122.43339798423 (37.7675675977893, -122.43339798423)
19977 29369 3 39 500X Bosworth St 9 11 1 2   07/06/2005 12:00:00 AM 3 3X3   6002638.340030001 2095276.9082799999 37.733380755998894 -122.43326512830099 (37.7333807559989, -122.433265128301)
20093 2015 3 39 500X Bosworth St 8 11 1 2     12 10   6002627.0989 2095279.66022 37.733387674484604 -122.433304188563 (37.7333876744846, -122.433304188563)
20603 26906 3 39 10 Caine Ave 2 11 1 2     24 10   5997668.873459999 2089736.17467 37.717884035095295 -122.450046671911 (37.7178840350953, -122.450046671911)
21305 26908 3 39 10 Caine Ave 4 11 1 2     18 10   5997639.65043 2089696.09364 37.7177723096208 -122.45014479517 (37.7177723096208, -122.45014479517)
21568 2012 3 39 500X Bosworth St 5 11 1 2     18 10   6002566.51434 2095294.967 37.7334262662011 -122.43351473961599 (37.7334262662011, -122.433514739616)
21645 26907 3 39 10 Caine Ave 3 11 1 2     18 10   5997653.71656 2089718.57825 37.717834852078205 -122.45009779478701 (37.7178348520782, -122.450097794787)
21793 29370 3 39 500X Bosworth St 10 11 1 2   07/06/2005 12:00:00 AM 3 3X3   6002650.152480001 2095274.05972 37.733373604614 -122.433224085933 (37.733373604614, -122.433224085933)
22854 176359 3 39 350x Winding Way 8 11 1 2     19 Width 0ft   6001093.21408 2086592.19305 37.7094467152559 -122.437985185864 (37.7094467152559, -122.437985185864)
67936 209179 3 39 255x San Marcos Ave 6 11 1 2     14 Width 5ft   5993078.87861 2100249.74193 37.7464879656554 -122.46667592616998 (37.7464879656554, -122.46667592617)
76168 2148 3 39 1100X Bosworth St 9 11 1 2     12 6   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
77440 23201 3 39 538X Van Ness Ave 3 11 1 2     30 9   6006777.891315901 2112378.9819314997 37.7805730648795 -122.420166841786 (37.7805730648795, -122.420166841786)
82031 23557 3 39 2900X Van Ness Ave 8 11 1 2     28 9x200   6005648.5023441 2120304.1415398 37.8022698669467 -122.42463786565399 (37.8022698669467, -122.424637865654)
88140 2149 3 39 1100X Bosworth St 10 11 1 2     24 6   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
91725 2147 3 39 1100X Bosworth St 8 11 1 2     18 6   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
97478 2145 3 39 1100X Bosworth St 6 11 1 2     6 6   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
102311 23415 3 39 1800X VAN NESS AVE 3 11 1 2     30 9   6006192.0 2116736.0 37.7925033310543 -122.422503407712 (37.7925033310543, -122.422503407712)
112688 2150 3 39 1100X Bosworth St 11 11 1 2   04/12/2006 12:00:00 AM 24 6   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
116746 2143 3 39 1100X Bosworth St 4 11 1 2     18 6   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
121107 2142 3 39 1100X Bosworth St 3 11 1 2     18 4   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
124289 2008 3 39 500X Bosworth St 1 11 1 2     18 12x100   6002728.1222807 2095276.2570246002 37.733384060718 -122.432954679755 (37.733384060718, -122.432954679755)
128637 2140 3 39 1100X Bosworth St 1 11 1 2     18 4   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
144777 24280 3 39 300X Winding Way 18 11 1 2     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117)
146698 223933 3 39 500x 27th St 10 11 1 2     14 Width 4ft   6002792.14111 2100065.62398 37.7465381864861 -122.43307541991999 (37.7465381864861, -122.43307541992)
179926 176358 3 39 300x Mansell St 1 11 1 2     24 Width 0ft   6010959.21222 2090503.85024 37.720743461908995 -122.40416158569599 (37.720743461909, -122.404161585696)
132830 223930 2 39 400 Clipper St 1 10 1 1     18 Width 4ft   6002523.62609 2100944.1238700002 37.748935105485295 -122.434066703011 (37.7489351054853, -122.434066703011)
340 191854 3 39 573 10th St 1 9 1 2     24 Width 6ft tree is in ROW therefore DPW maintained 6009977.72395 2108375.30106 37.7697596664942 -122.408814503513 (37.7697596664942, -122.408814503513)
389 191855 3 39 573 10th St 2 9 1 2     49 Width 6ft Cal Trans adjacent; 10 ft ROW 6009921.77605 2108434.69103 37.7699196037317 -122.409012217656 (37.7699196037317, -122.409012217656)
4764 253679 2 39 94 Teresita Blvd 1 9 1 1       4x8   5997405.0 2099153.0 37.7437252916895 -122.45163765514201 (37.7437252916895, -122.451637655142)
25083 250988 2 39 401 45th Ave 1 9 1 1     6     5981857.67732 2112961.27677 37.780736228431394 -122.50641942431999 (37.7807362284314, -122.50641942432)
25469 224313 2 39 1300 San Jose Ave 43 9 1 1     23     6003370.69781 2095579.24653 37.734252427487895 -122.43075473197099 (37.7342524274879, -122.430754731971)
29272 206257 2 39 470 Joost Ave 1 9 1 1     6     5998979.032869999 2094999.63504 37.7324111582444 -122.44589639242099 (37.7324111582444, -122.445896392421)
34621 142349 2 39 101 Jean Way 1 9 1 1     13 Width 0ft   5998390.8197 2112613.6039 37.780741136182996 -122.44919849112499 (37.780741136183, -122.449198491125)
34820 185062 2 39 57 Crestlake Dr 2 9 1 1     34 Width 0ft   5988606.9554 2096240.5545 37.735220697007 -122.48184553440599 (37.735220697007, -122.481845534406)
34903 209050 2 39 1957 11th Ave 1 9 1 1     2 Width 8ft   5992832.0563900005 2102279.47717 37.752046850582104 -122.46767699299299 (37.7520468505821, -122.467676992993)
38245 206256 2 39 52 Burnside Ave 9 9 1 1     14     6001149.03132 2095735.7759900002 37.7345560997669 -122.438446938292 (37.7345560997669, -122.438446938292)
40028 223932 2 39 540 28th St 2 9 1 1     6 Width 10ft   6002411.2824 2099479.33596 37.74490676593071 -122.434350476903 (37.7449067659307, -122.434350476903)
43280 202107 2 39 1833 Egbert Ave 1 9 1 1     23 Width 5ft   6011947.78492 2092850.2983099998 37.727241516067 -122.40090914794399 (37.727241516067, -122.400909147944)
45093 176361 2 39 33 Burr Ave 1 9 1 1     15 Width 3ft   6007913.680380001 2086634.77605 37.70994915030529 -122.414415456032 (37.7099491503053, -122.414415456032)
49532 191815 2 39 1101 18th St 3 9 1 1     34 Width 4ft   6014219.19015 2105700.54735 37.762652041984296 -122.39395601257 (37.7626520419843, -122.39395601257)
51031 206258 2 39 470 Joost Ave 2 9 1 1     2     5998976.70694 2094998.91633 37.732409052024295 -122.44590438200198 (37.7324090520243, -122.445904382002)
51663 224312 2 39 1300 San Jose Ave 42 9 1 1     14     6003373.67876 2095579.3072 37.7342527629625 -122.43074443020599 (37.7342527629625, -122.430744430206)
53137 191990 2 39 1000 Oakdale Ave 8 9 1 1     22     6018074.25782 2093264.02641 37.7287173674097 -122.379758475681 (37.7287173674097, -122.379758475681)
56135 250989 2 39 401 45th Ave 2 9 1 1     10     5981864.98937 2112954.2603599997 37.7807173939441 -122.506393608376 (37.7807173939441, -122.506393608376)
60751 209139 2 39 201 Judson Ave 2 9 1 1     15 Width 10ft   5998643.81867 2093469.90945 37.72819174514839 -122.44694526181001 (37.7281917451484, -122.44694526181)
62844 191852 2 39 130 Vermont St 2 9 1 1     22 Width 8ft   6011081.7581400005 2107773.41593 37.768168804485605 -122.404953275984 (37.7681688044856, -122.404953275984)
62987 209141 2 39 112 Marston Ave 6 9 1 1     16     5998693.6705599995 2093224.71233 37.7275213392184 -122.446755287223 (37.7275213392184, -122.446755287223)
68442 126585 2 39 2626 Baker St 3 9 1 1     9 Width 6ft   5999659.00092 2117875.6856 37.7952618910822 -122.445189684462 (37.7952618910822, -122.445189684462)
68826 209140 2 39 112 Marston Ave 2 9 1 1     16     5998703.32943 2093223.9709599998 37.727519855354096 -122.446721843256 (37.7275198553541, -122.446721843256)
69503 224311 2 39 1300 San Jose Ave 41 9 1 1     16     6003371.63665 2095581.9974099998 37.7342600339703 -122.430751682345 (37.7342600339703, -122.430751682345)
69709 202108 2 39 1833 Egbert Ave 2 9 1 1     17 Width 5ft   6011952.33399 2092848.9632599999 37.7272381040432 -122.400893327983 (37.7272381040432, -122.400893327983)
70601 209051 2 39 1957 11th Ave 2 9 1 1     2 Width 8ft   5992829.67425 2102278.35273 37.7520436256167 -122.46768514894501 (37.7520436256167, -122.467685148945)
72113 142421 2 39 10 MAYFAIR DR 36 9 1 1     3 Width 0ft   5997633.2625 2114522.3029 37.78593856211079 -122.451956978624 (37.7859385621108, -122.451956978624)
93393 103615 6 39 200X Buchanan St 5 9 1 1           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637)
Powered by Datasette · Query took 13.346ms · Data source: data.sfgov.org