sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5325 40088 1 84   1 1 1 1   03/09/1999 12:00:00 AM     Permit Number 41311          
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)
136660 238536 2 84 1 Penny Ln 4 13 1 1     3 Width 2ft   6002355.478619999 2096490.80035 37.736697774076 -122.434329814067 (37.736697774076, -122.434329814067)
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)
9515 19958 3 84 100 STAIRWAY40 3 1 1 2     3 15ST            
10800 19957 3 84 100 STAIRWAY40 2 1 1 2     3 15ST            
16368 19956 3 84 100 STAIRWAY40 1 1 1 2     12 15ST            
12896 19960 3 84 100 STAIRWAY41 18 1 1 2     6 25ST            
6573 19697 3 84 100 STAIRWAY9 1 1 1 2     3 15ST            
9562 19696 3 84 100 STAIRWAY9 -3 1 1 2     12 15ST            
76569 136021 2 84 1010 Lombard St 1 2 1 1     12     6007482.49892 2120248.47345 37.802220422406705 -122.418287380977 (37.8022204224067, -122.418287380977)
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)
68550 234921 2 84 1062 Valencia St 3 1 1 1     6 Width 3ft   6006317.5902 2103335.47216 37.7557157877704 -122.421116917936 (37.7557157877704, -122.421116917936)
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)
166130 238535 2 84 118 Saint Marys Ave 2 9 1 1     10 Width 3ft   6003941.15849 2095961.17353 37.735333416189206 -122.42880968543899 (37.7353334161892, -122.428809685439)
175278 199890 3 84 1200x Quesada Ave 1 11 1 2     3 Width 0ft   6017354.2822 2093058.6837 37.7281137963921 -122.382233221943 (37.7281137963921, -122.382233221943)
111598 102286 2 84 122 Hoffman Ave 1 1 1 1   06/16/2014 12:00:00 AM 26 4x4 Permit Number 772865 6000574.8 2102350.7 37.7526864299915 -122.44090662134501 (37.7526864299915, -122.440906621345)
153027 80867 1 84 123 Paris St 1 1 1 1   06/04/2008 12:00:00 AM 1 3x3 Permit Number 50655 6003213.7924 2092811.2834 37.7266433347113 -122.431099707385 (37.7266433347113, -122.431099707385)
41124 247987 2 84 124 Mullen Ave 1 7 1 1     11     6009857.2555 2099808.73815 37.7462310644209 -122.408626794296 (37.7462310644209, -122.408626794296)
139765 121317 3 84 1270 South Van Ness Ave 1 1 1 2     10 3x3   6007670.0 2102262.0 37.7528444245459 -122.41636381055099 (37.7528444245459, -122.416363810551)
24959 212860 2 84 129 Merced Ave 1 1 1 1     8 Width 4ft   5994548.15716 2099444.62817 37.7443620078908 -122.461537000359 (37.7443620078908, -122.461537000359)
2581 107490 3 84 1306x Montgomery St 19 11 1 2     12     6011447.18476 2119974.7633599997 37.8016912541172 -122.404548295963 (37.8016912541172, -122.404548295963)
116443 213700 2 84 1316 10th Ave 1 1 1 1     2 Width 3ft   5993037.4807 2106453.44522 37.76351933917171 -122.46727007765499 (37.7635193391717, -122.467270077655)
66954 234918 2 84 1319 San Bruno Ave 1 1 1 1     11 Width 3ft   6011166.831619999 2102201.8831 37.75287537621829 -122.404266824377 (37.7528753762183, -122.404266824377)
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)
37252 234917 2 84 1341 San Bruno Ave 1 1 1 1     14 Width 5ft   6011175.62775 2102086.9904099996 37.7525603976539 -122.40422831989599 (37.7525603976539, -122.404228319896)
137899 84640 1 84 1363 24th Ave 1 1 1 1 1 07/27/2009 12:00:00 AM 3 3x3 Permit Number 52752 5988634.2057 2106032.7782 37.7621091296561 -122.482468596885 (37.7621091296561, -122.482468596885)
90214 50019 1 84 1363 Alabama St 1 1 1 1 1 07/28/2003 12:00:00 AM     Permit Number 46753 6009308.17778689 2101227.80950502 37.750096752782504 -122.410625639874 (37.7500967527825, -122.410625639874)
44716 179166 2 84 137 University St 1 1 1 1     7 Width 3ft   6007974.04708 2093261.8498099998 37.7281490902886 -122.414675489606 (37.7281490902886, -122.414675489606)
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)
55882 196536 2 84 1422 Rhode Island St 1 4 1 1     10 Width 3ft   6011983.19537 2101729.68858 37.751624416549795 -122.40141048760401 (37.7516244165498, -122.401410487604)
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)
88192 50440 1 84 1539 Funston Ave 4 1 1 1   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320978998 (37.7593865436509, -122.47037320979)
138887 50441 1 84 1539 Funston Ave 5 1 1 1   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320978998 (37.7593865436509, -122.47037320979)
141592 50443 1 84 1539 Funston Ave 2 1 1 1   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320978998 (37.7593865436509, -122.47037320979)
145839 50442 1 84 1539 Funston Ave 3 1 1 1   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320978998 (37.7593865436509, -122.47037320979)
121392 11193 3 84 162 Idora Ave 1 11 1 2     18 8   5995521.0890831 2099407.054304 37.7443147925186 -122.458170108957 (37.7443147925186, -122.458170108957)
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)
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)
29648 196372 2 84 1700 Armstrong Ave 7 17 1 1     1     6013890.9677099995 2092887.97335 37.7274531643304 -122.394194162931 (37.7274531643304, -122.394194162931)
186195 196068 2 84 1700 Armstrong Ave 9 17 1 1     3     6013885.20395 2092887.6121599998 37.727451852204204 -122.39421406314399 (37.7274518522042, -122.394214063144)
100275 96676 7 84 1701 21st Ave 1 1 1 1   06/22/2011 12:00:00 AM       5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698)
115861 96677 1 84 1701 21st Ave 2 1 1 1         Permit Number 767971 5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698)
132716 212861 2 84 175 Garcia Ave 1 1 1 1     7 Width 4ft   5994619.09353 2099469.67136 37.7444348530002 -122.461293534079 (37.7444348530002, -122.461293534079)
183108 213705 2 84 175 Staples Ave 2 9 1 1     2     5998918.04752 2093764.63915 37.7290166671659 -122.4460184358 (37.7290166671659, -122.4460184358)
38547 196063 2 84 1751 22nd St 9 17 1 1     3 Width 5ft   6012868.1198 2103766.18767 37.757265535503 -122.39849317144501 (37.757265535503, -122.398493171445)
177483 196062 2 84 1751 22nd St 8 17 1 1     5 Width 5ft   6012859.76673 2103766.08005 37.757264774654395 -122.398522052264 (37.7572647746544, -122.398522052264)
161934 196371 2 84 1797 Bancroft Ave 3 10 1 1     3 Width 1ft   6013429.501019999 2092789.94242 37.7271583305791 -122.395782600389 (37.7271583305791, -122.395782600389)
147685 196064 2 84 1800 Illinois St 10 2 1 1     2 Width 5ft   6016257.27394 2100629.7145700003 37.7488416623195 -122.386553348372 (37.7488416623195, -122.386553348372)
137017 212859 2 84 1850 17th Ave 1 9 1 1     5 Width 6ft   5990965.567480001 2102825.03354 37.753436858936205 -122.474171325764 (37.7534368589362, -122.474171325764)
102022 20856 3 84 1892X Sunset Blvd 6 1 1 2     3 60   5984852.8466778 2102317.5089788004 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334)
119551 20857 3 84 1892X Sunset Blvd 7 1 1 2     3 60   5984852.8466778 2102317.5089788004 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334)
144988 20855 3 84 1892X Sunset Blvd 5 1 1 2     3 60   5984852.8466778 2102317.5089788004 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334)
155630 196373 2 84 1900 19th St 2 7 1 1     1     6012066.64129 2105141.25616 37.760996487210996 -122.40136164543101 (37.760996487211, -122.401361645431)
183588 196335 2 84 1900 19th St 10 7 1 1     1     6012008.47004 2105145.92381 37.761006057794 -122.401563163706 (37.761006057794, -122.401563163706)
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)
140252 93987 1 84 200 Belgrave Ave 2 5 1 1       3x3 Permit Number 53411 5997460.5 2104904.0 37.759519290122 -122.45186055280199 (37.759519290122, -122.451860552802)
63837 234919 2 84 200 Saint Marys Ave 5 17 1 1     2 Width 4ft   6003932.02563 2095971.19882 37.735360426449105 -122.428841975603 (37.7353604264491, -122.428841975603)
152021 196535 2 84 2050 20th St 1 1 1 1     3 Width 3ft   6011971.89654 2104695.5973799997 37.759767520477205 -122.401658003519 (37.7597675204772, -122.401658003519)
82397 45454 1 84 219 Faxon Ave 1 1 1 1   07/17/2001 12:00:00 AM     Permit Number 44239 5994709.07342911 2090056.25354598 37.7185930847656 -122.460300500781 (37.7185930847656, -122.460300500781)
17845 21084 3 84 2192X Sunset Blvd 20 1 1 2     3 60   5984923.321673 2100279.0596028 37.7460944336033 -122.494878681905 (37.7460944336033, -122.494878681905)
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)
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)
77997 53523 1 84 221 Farallones St 1 1 1 1   08/28/2015 12:00:00 AM 4 3x3 Permit Number 775251 5994812.01878897 2088373.36040249 37.7139781801866 -122.45982282724701 (37.7139781801866, -122.459822827247)
25209 196534 2 84 2221 26th St 2 1 1 1     4 Width 3ft   6011830.1521 2101342.3848900003 37.750552424667504 -122.401912510764 (37.7505524246675, -122.401912510764)
137994 196067 2 84 2338 Lane St 2 7 1 1     2 Width 5ft   6013920.54146 2092873.2671400001 37.727414427818395 -122.394090896496 (37.7274144278184, -122.394090896496)
135994 234923 2 84 24 Franconia St 1 1 1 1     9 Width 3ft   6009961.80336 2099942.52208 37.7466042605945 -122.40827471331998 (37.7466042605945, -122.40827471332)
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)
174227 181930 2 84 2431 33rd Ave 1 2 1 1     1 Width 0ft   5986090.3717 2098682.4704 37.741778875367295 -122.49072577603 (37.7417788753673, -122.49072577603)
143629 96998 6 84 2451X Griffith St   5 1 20 1         6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
171549 183196 2 84 2479 40th Ave 1 1 1 1     1 Width 0ft   5983931.1246 2098292.1691 37.740580843976005 -122.49816280562901 (37.740580843976, -122.498162805629)
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)
168863 234912 2 84 266 Richland Ave 1 1 1 1     5 Width 3ft   6006193.38743 2096072.09961 37.735765211285894 -122.421030756557 (37.7357652112859, -122.421030756557)
86674 107457 2 84 2682 16TH AVE 1 1 1 1           5991487.4 2097177.7 37.737960952695396 -122.47195516350901 (37.7379609526954, -122.471955163509)
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)
165336 213703 2 84 27 Melrose Ave 2 9 1 1     16 Width 10ft   5999907.55727 2095471.26814 37.733759127772394 -122.442720129024 (37.7337591277724, -122.442720129024)
181165 185048 2 84 2767 34th Ave 3 9 1 1     2 Width 0ft   5985831.6836 2096605.638 37.7360613326903 -122.49146739069799 (37.7360613326903, -122.491467390698)
182122 185047 2 84 2767 34th Ave 2 9 1 1     4 Width 0ft   5985832.2143 2096586.5348 37.7360089113847 -122.491464150215 (37.7360089113847, -122.491464150215)
104487 53181 1 84 2784 23rd St 1 1 1 1 1 11/07/2006 12:00:00 AM   3x3 Permit Number 49099 6010077.71172244 2102830.43618978 37.7545403242811 -122.408077545352 (37.7545403242811, -122.408077545352)
145578 40428 1 84 29 Colby St 1 1 1 1   06/03/1999 12:00:00 AM     Permit Number 41523 6007969.10251409 2094049.49213596 37.730311508750404 -122.414748301777 (37.7303115087504, -122.414748301777)
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)
187643 238533 2 84 2929 Harrison St 1 1 1 1     9 Width 3ft   6009029.88036 2101415.6654 37.7505969563892 -122.411601283067 (37.7505969563892, -122.411601283067)
91261 105378 2 84 298X SAN FERNANDO WAY 2 1 1 1     7 2x2   5991951.0 2094979.0 37.7319506911602 -122.47019222238899 (37.7319506911602, -122.470192222389)
92134 56560 1 84 298X SAN FERNANDO WAY 1 1 1 1     12 2x2   5992129.0 2095185.0 37.7325266047982 -122.46959183484199 (37.7325266047982, -122.469591834842)
14815 29657 3 84 299X Cashmere St 1 11 1 2   04/07/2006 12:00:00 AM 3 3x3   6016930.3488300005 2095863.99444 37.735793199983796 -122.38389404137699 (37.7357931999838, -122.383894041377)
70326 237949 2 84 3145 23rd St 1 1 1 1     13 Width 3ft   6008037.75868 2102668.77987 37.753982023462704 -122.41512082037599 (37.7539820234627, -122.415120820376)
157664 237950 2 84 3145 23rd St 2 1 1 1     8 Width 3ft   6008062.3853 2102670.45818 37.75398801563821 -122.415035774193 (37.7539880156382, -122.415035774193)
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)
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)
74766 237971 2 84 3178 Cesar Chavez St 2 1 1 1     3 Width 3ft   6008600.41483 2100617.45628 37.748381152776396 -122.413029982045 (37.7483811527764, -122.413029982045)
Powered by Datasette · Query took 3.606ms · Data source: data.sfgov.org