sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1480 251545 3 88 347 Dolores St 1 1 1 2       3x3   6004948.0 2106317.0 37.7638250559684 -122.426065641314 (37.7638250559684, -122.426065641314)
18361 99292 1 88 1300 Minnesota St 3 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)
18733 88323 1 88 125 Lisbon St   1 1 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51312 6003417.0 2092629.0 37.7261543381556 -122.430384225952 (37.7261543381556, -122.430384225952)
19246 97101 1 88 1096@Jones Pine St 3 1 1 1       3x3   6008668.0 2115966.0 37.7905284677514 -122.41388184826499 (37.7905284677514, -122.413881848265)
38343 122390 2 88 1958 17th Ave 1 1 1 1 1     3x2   5991007.0 2102078.0 37.7513881006776 -122.47397354599501 (37.7513881006776, -122.473973545995)
49119 65035 1 88 1205 Sanchez St 1 1 1 1   10/08/2008 12:00:00 AM   3x3 Permit Number 51820 6003879.11104946 2101261.18670708 37.7498825208731 -122.429402039878 (37.7498825208731, -122.429402039878)
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)
53186 106080 6 88 188 The Embarcadero 1 7 1 1   03/20/2014 12:00:00 AM     Permit Number 771259 6015087.8131 2116516.98611 37.7923997963133 -122.391708043282 (37.7923997963133, -122.391708043282)
61145 95563 1 88 497 Elizabeth St 1 1 1 1 1     3x3   6003239.0 2102086.6 37.75211264995529 -122.43167449646799 (37.7521126499553, -122.431674496468)
61699 86883 1 88 550 Jersey St   1 1 1       3x3 Permit Number 49808 6001589.0 2101474.0 37.750336931820996 -122.43733657341998 (37.750336931821, -122.43733657342)
66636 82354 1 88 254 Dublin St 1 1 1 1   06/04/2008 12:00:00 AM   3x3 Permit Number 50649 6004015.90676212 2089097.25184538 37.716490841330106 -122.428062269463 (37.7164908413301, -122.428062269463)
66641 50836 1 88 202 Kirkham St 2 1 1 1   03/25/2004 12:00:00 AM     Permit Number 47354 5994277.69303186 2105335.48637483 37.7605212305047 -122.462899497742 (37.7605212305047, -122.462899497742)
76012 97025 7 88 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
77434 81367 2 88 1001 Polk St 1 10 1 1   11/08/2003 12:00:00 AM   3x3   6006914.85774282 2114314.60875621 37.7858955407321 -122.41983039718201 (37.7858955407321, -122.419830397182)
77905 89162 1 88 370 03rd St 1 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)
78394 95830 1 88 5 Lucerne St 1 1 1 1 1 08/29/2011 12:00:00 AM   3x3 Permit Number 767564 6011975.0 2109856.0 37.7739369979495 -122.402010048031 (37.7739369979495, -122.402010048031)
78911 95113 1 88 887 Cayuga Ave 1 1 1 1 1 12/28/2010 12:00:00 AM   3x3 Permit Number 54041 6001057.0 2091844.3 37.7238657652599 -122.43848639746099 (37.7238657652599, -122.438486397461)
79183 87126 1 88 438 33rd Ave 2 1 1 1   01/08/2008 12:00:00 AM   3x3 Permit Number 50074 5985668.2 2112929.7 37.7808731376826 -122.493234847229 (37.7808731376826, -122.493234847229)
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)
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)
81271 96117 1 88 201 Andover St 2 1 1 1 1 09/08/2011 12:00:00 AM   3x3 Permit Number 767772 6007577.0 2097739.0 37.7404200508617 -122.41636508469699 (37.7404200508617, -122.416365084697)
81380 112795 8 88 1235 40th Ave 1 1 1 1   08/20/2015 12:00:00 AM   3x3   5983624.1 2106731.7 37.763735444165796 -122.49984801640899 (37.7637354441658, -122.499848016409)
81903 112888 1 88 3980 Clay St 1 1 1 1   08/26/2015 12:00:00 AM     Permit Number 774440 5995705.4 2115208.7 37.7877126116995 -122.458676518899 (37.7877126116995, -122.458676518899)
82182 99585 1 88 301X Noe St 3 1 1 1   07/19/2013 12:00:00 AM       6003014.6 2106437.9 37.7640475560396 -122.432761315556 (37.7640475560396, -122.432761315556)
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)
82889 114908 4 88 281 LOBOS ST 1 1 1 1       3x3   5994225.0 2088676.0 37.714775380268996 -122.461873702271 (37.714775380269, -122.461873702271)
82980 87788 1 88 114 Theresa St   1 1 1   05/30/2008 12:00:00 AM   3x3 Permit Number 50526 6002199.1 2093679.9 37.7289708079503 -122.43466954464199 (37.7289708079503, -122.434669544642)
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)
83737 82146 1 88 1083 Portola Dr 1 1 1 1   07/07/2008 12:00:00 AM   3x3 Permit Number 51167 5995391.16373818 2098013.23554983 37.7404802453018 -122.458518484651 (37.7404802453018, -122.458518484651)
83905 87914 1 88 101 Wool St 4 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50936 6007398.0 2097753.0 37.7404484242714 -122.41698498961 (37.7404484242714, -122.41698498961)
84201 109760 1 88 3590 20TH ST 4 1 1 1   12/01/2015 12:00:00 AM   3x3 Permit Number 772584 6006354.0 2104372.0 37.75856390529879 -122.421064595152 (37.7585639052988, -122.421064595152)
84591 95703 1 88 497 Elizabeth St 1 1 1 1 1 03/02/2011 12:00:00 AM   3x3 Permit Number 767357 6003239.0 2102086.6 37.75211264995529 -122.43167449646799 (37.7521126499553, -122.431674496468)
85604 115256 1 88 277 Granada Ave 1 1 1 1   01/21/2016 12:00:00 AM     Permit Number 773180 5995612.8 2091840.6 37.723544420177205 -122.457305721784 (37.7235444201772, -122.457305721784)
86015 82961 1 88 3925 17th St 1 1 1 1   06/12/2008 12:00:00 AM   3x3 Permit Number 50821 6002789.88777109 2105883.76961321 37.7625133012574 -122.433498925711 (37.7625133012574, -122.433498925711)
86132 51656 1 88 949 Sanchez St 1 1 1 1   05/29/2008 12:00:00 AM   3x3 Permit Number 50463 6003796.70592748 2102740.00151399 37.7539383334149 -122.42979246604999 (37.7539383334149, -122.42979246605)
86466 53191 1 88 720@ 20TH ST. Castro St 1 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50943 6002391.64717096 2103940.90451156 37.757156060155104 -122.434737353785 (37.7571560601551, -122.434737353785)
86557 112587 1 88 790 Tehama St 3 1 1 1       3x3   6008900.0 2110136.0 37.774533709285706 -122.41266682187201 (37.7745337092857, -122.412666821872)
87360 88834 1 88 156 Collins St   1 1 1   09/11/2008 12:00:00 AM   3x3 Permit Number 51716 5998112.0 2113497.0 37.78315075925521 -122.45022675387301 (37.7831507592552, -122.450226753873)
87428 49067 1 88 1298 Ocean Ave 2 1 1 1   06/02/2008 12:00:00 AM   3x3 Permit Number 50555 5995836.31315767 2092013.47244835 37.724031921729704 -122.45654557668001 (37.7240319217297, -122.45654557668)
87745 87898 1 88 700 Eugenia Ave 1 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50917 6007438.0 2097723.6 37.740369948387794 -122.41684460251801 (37.7403699483878, -122.416844602518)
87866 96066 1 88 957 Shotwell St 1 1 1 1 1 08/03/2011 12:00:00 AM   3x3 Permit Number 767691 6008013.0 2102358.0 37.753127300999395 -122.415184444517 (37.7531273009994, -122.415184444517)
88038 104296 1 88 4267 24TH ST   1 1 1       3x3 Permit Number 770781 6001461.0 2101700.0 37.7509501962946 -122.43779538996901 (37.7509501962946, -122.437795389969)
88138 88597 1 88 77 Jordan Ave   1 1 1   07/31/2008 12:00:00 AM   3x3 Permit Number 51542 5996162.8 2114014.5 37.7844599367093 -122.457007600103 (37.7844599367093, -122.457007600103)
88613 87900 1 88 700 Eugenia Ave 3 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50917 6007438.0 2097723.6 37.740369948387794 -122.41684460251801 (37.7403699483878, -122.416844602518)
88687 95549 1 88 1712 Castro St 1 1 1 1 1 03/02/2011 12:00:00 AM   3x3 Permit Number 767351 6002582.0 2100598.0 37.7479880436154 -122.433840109923 (37.7479880436154, -122.433840109923)
88700 97099 1 88 1096@Jones Pine St 1 1 1 1       3x3   6008668.0 2115966.0 37.7905284677514 -122.41388184826499 (37.7905284677514, -122.413881848265)
88766 84634 1 88 361 Nevada St 1 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50931 6008966.27725874 2096629.00783692 37.737450280623605 -122.411483091014 (37.7374502806236, -122.411483091014)
89118 98412 1 88 55 19th Ave 4 21 1 1   02/09/2012 12:00:00 AM     Permit Number 768592 5990099.2 2106073.1 37.7623049568555 -122.477404745944 (37.7623049568555, -122.477404745944)
89605 88526 1 88 1680 McAllister St   1 1 1   10/08/2008 12:00:00 AM   3x3 Permit Number 51817 6001106.0 2111441.0 37.7776763890724 -122.43972129937299 (37.7776763890724, -122.439721299373)
89634 39742 1 88 4248 20th St 1 1 1 1   05/29/2008 12:00:00 AM   3x3 Permit Number 50468 6002277.29168205 2104153.16512299 37.7577323837885 -122.435148020003 (37.7577323837885, -122.435148020003)
90133 109758 1 88 3590 20TH ST 2 1 1 1   12/01/2015 12:00:00 AM   3x3 Permit Number 772584 6006354.0 2104372.0 37.75856390529879 -122.421064595152 (37.7585639052988, -122.421064595152)
90136 108459 5 88 771 11th Ave   1 1 1 1     3x3 Permit Number 773786 5992558.08669 2110211.94426 37.7738114893979 -122.469201704334 (37.7738114893979, -122.469201704334)
90318 94819 1 88 1551 10th Ave 1 1 1 1 1 11/10/2010 12:00:00 AM   3x3 Permit Number 53898 5993027.2 2104915.2 37.759295127513106 -122.467193784759 (37.7592951275131, -122.467193784759)
90414 112573 8 88 56 ROCKWOOD CT 1 1 1 1   12/31/2015 12:00:00 AM   3x6 Permit Number 776002 5995685.0 2098946.0 37.7430582687021 -122.457569991387 (37.7430582687021, -122.457569991387)
90961 94705 1 88 682 12th Ave   1 1 1 1 10/28/2010 12:00:00 AM   3x3 Permit Number 53845 5992291.3 2110837.3 37.7755131276945 -122.470170100471 (37.7755131276945, -122.470170100471)
91295 98410 1 88 55 19th Ave 2 21 1 1   02/09/2012 12:00:00 AM     Permit Number 768592 5990099.2 2106073.1 37.7623049568555 -122.477404745944 (37.7623049568555, -122.477404745944)
91395 87785 1 88 114 Theresa St   1 1 1   05/30/2008 12:00:00 AM   3x3 Permit Number 50526 6002199.1 2093679.9 37.7289708079503 -122.43466954464199 (37.7289708079503, -122.434669544642)
91749 32526 1 88 871 Moultrie St 1 1 1 1 1 10/06/2015 12:00:00 AM     Permit Number 776214 6007576.4663397 2095282.92697428 37.733676184028795 -122.416193025137 (37.7336761840288, -122.416193025137)
91852 112388 1 88 4200 18th St 2 1 1 1       3x3   6002010.54318716 2105309.8458945 37.760893198333704 -122.436153317055 (37.7608931983337, -122.436153317055)
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)
93883 87912 1 88 101 Wool St 2 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50936 6007398.0 2097753.0 37.7404484242714 -122.41698498961 (37.7404484242714, -122.41698498961)
94031 104138 1 88 3067 Steiner St 1 1 1 1   05/31/2013 12:00:00 AM   3x3 Permit Number 770728 6001906.1 2118706.9 37.7976721947069 -122.43747392910299 (37.7976721947069, -122.437473929103)
94334 89047 1 88 4552 19th St   1 1 1   10/06/2008 12:00:00 AM   3x3 Permit Number 51787 6000860.0 2104654.0 37.7590269716409 -122.440085499527 (37.7590269716409, -122.440085499527)
94680 89190 1 88 370 03rd St 7 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
94923 88503 1 88 7 Wheat St   1 1 1   07/18/2008 12:00:00 AM   3x3 Permit Number 51441 6012178.0 2091435.0 37.723368235520205 -122.400013942822 (37.7233682355202, -122.400013942822)
94972 96116 1 88 201 Andover St 1 1 1 1 1 09/08/2011 12:00:00 AM   3x3 Permit Number 767772 6007577.0 2097739.0 37.7404200508617 -122.41636508469699 (37.7404200508617, -122.416365084697)
95030 88376 1 88 563 14th Ave   1 1 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51354 5991545.8 2111599.6 37.777563068378704 -122.472804534873 (37.7775630683787, -122.472804534873)
96004 95123 1 88 75 Oneida Ave 1 1 1 1 1 12/28/2010 12:00:00 AM   3x3 Permit Number 54050 6000595.4 2090675.6 37.720630512863295 -122.439998309146 (37.7206305128633, -122.439998309146)
96094 88841 1 88 1300 Polk St 2 1 1 1   09/12/2008 12:00:00 AM   3x3 Permit Number 51719 6006820.0 2115342.0 37.788711160036996 -122.42023152280301 (37.788711160037, -122.420231522803)
96203 96118 1 88 201 Andover St 3 1 1 1 1 09/08/2011 12:00:00 AM   3x3 Permit Number 767772 6007577.0 2097739.0 37.7404200508617 -122.41636508469699 (37.7404200508617, -122.416365084697)
96447 98411 1 88 55 19th Ave 3 21 1 1   02/09/2012 12:00:00 AM     Permit Number 768592 5990099.2 2106073.1 37.7623049568555 -122.477404745944 (37.7623049568555, -122.477404745944)
96881 114721 1 88 465 Woolsey St 4 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)
97155 52415 1 88 445 Flood Ave 1 1 1 1   06/19/2008 12:00:00 AM   3x3 Permit Number 50993 5997805.99655674 2094075.37872241 37.729806319232004 -122.44988524851401 (37.729806319232, -122.449885248514)
98401 88306 1 88 575 Athens St   1 1 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51300 6003350.0 2089985.0 37.718890705147 -122.43042727566299 (37.718890705147, -122.430427275663)
98471 69097 1 88 1652 12th Ave 1 1 1 1 1 09/15/2010 12:00:00 AM   3x3 Permit Number 53733 5992497.75001654 2104207.48539143 37.7573213517081 -122.46897335970101 (37.7573213517081, -122.468973359701)
98602 46567 1 88 3900 22nd St 1 1 1 1   10/08/2008 12:00:00 AM   3x3 Permit Number 51812 6002455.82917315 2102994.91492425 37.754562242839704 -122.43444775294701 (37.7545622428397, -122.434447752947)
98773 106368 1 88 426 Country Club Dr   9 1 1   04/23/2014 12:00:00 AM     Permit Number 770073 5984817.1 2094918.3 37.731369010287 -122.494850794258 (37.731369010287, -122.494850794258)
100026 87899 1 88 700 Eugenia Ave 2 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50917 6007438.0 2097723.6 37.740369948387794 -122.41684460251801 (37.7403699483878, -122.416844602518)
101412 89164 1 88 370 03rd St 3 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)
101462 99540 1 88 801X Central Ave 3 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)
102151 88269 1 88 1175 Stanyan St   1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51255 5997354.0 2106147.0 37.7629261534889 -122.452318574624 (37.7629261534889, -122.452318574624)
102499 89170 1 88 370 03rd St 9 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
103056 99584 1 88 3599X 16th St 2 1 1 1   05/21/2013 12:00:00 AM       6003014.6 2106437.9 37.7640475560396 -122.432761315556 (37.7640475560396, -122.432761315556)
103099 88326 1 88 559 Lisbon St   1 1 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51315 6001911.0 2090236.0 37.7194982755804 -122.43541926902701 (37.7194982755804, -122.435419269027)
103156 87781 1 88 270 Delano Ave   1 1 1   05/30/2008 12:00:00 AM   3x3 Permit Number 50517 5999921.6 2092148.7 37.7246369273224 -122.44243312170299 (37.7246369273224, -122.442433121703)
103299 83188 1 88 1664 11th Ave 1 1 1 1   06/15/2010 12:00:00 AM   3x3 Permit Number 53557 5992810.26262937 2104140.01708709 37.7571541524742 -122.467887670443 (37.7571541524742, -122.467887670443)
103885 87238 1 88 313 04th Ave   1 1 1   02/14/2008 12:00:00 AM   3x3 Permit Number 50268 5994594.9 2113356.1 37.7825619851863 -122.462384185128 (37.7825619851863, -122.462384185128)
103935 99293 1 88 1300 Minnesota St 4 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)
103973 81044 1 88 4521 19th St 1 1 1 1   12/24/2007 12:00:00 AM   3x3 Permit Number 50047 6001024.93237313 2104618.24519857 37.758938185839206 -122.439512523669 (37.7589381858392, -122.439512523669)
104309 88650 1 88 400 Haight St   1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51631 6004213.0 2109445.0 37.772372219374105 -122.428830794856 (37.7723722193741, -122.428830794856)
104650 87913 1 88 101 Wool St 3 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50936 6007398.0 2097753.0 37.7404484242714 -122.41698498961 (37.7404484242714, -122.41698498961)
105080 88268 1 88 1158 Stanyan St   1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51254 5997417.6 2106243.4 37.7631944867864 -122.45210556106701 (37.7631944867864, -122.452105561067)
105494 95926 1 88 651 24th Ave 1 1 1 1 1 07/29/2011 12:00:00 AM   3x3 Permit Number 767623 5988426.1 2111542.8 37.777226019991204 -122.483592327097 (37.7772260199912, -122.483592327097)
105665 95129 1 88 2200@Broderick Beach St 3 5 1 1   01/08/2008 12:00:00 AM       5999690.0 2120891.0 37.80354290788161 -122.445299328106 (37.8035429078816, -122.445299328106)
105801 88240 1 88 2501 Turk Blvd 2 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)
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)
105983 88239 1 88 2501 Turk Blvd 1 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)
106504 88322 1 88 645 France Ave 3 1 1 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51311 6002646.5 2089495.7 37.717507319615706 -122.432824059512 (37.7175073196157, -122.432824059512)
106643 89194 1 88 370 03rd St   1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
107907 88241 1 88 2501 Turk Blvd 3 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 13.249ms · Data source: data.sfgov.org