sf-trees

Data source: data.sfgov.org

Custom SQL query returning 57 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
81568 40117 1 84 51 Clipper St 1 1 1 1 1 09/29/2001 12:00:00 AM     Permit Number 41332 6004835.9770779 2101026.68937802 37.7492927732201 -122.42607645855 (37.7492927732201, -122.42607645855)
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)
85877 103517 1 84 55X MacOndray Ln 1 14 1 1         Permit Number 770452 6008432.0 2119159.0 37.7992824016355 -122.41492448290899 (37.7992824016355, -122.414924482909)
86674 107457 2 84 2682 16TH AVE 1 1 1 1           5991487.4 2097177.7 37.737960952695396 -122.47195516350901 (37.7379609526954, -122.471955163509)
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)
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)
93929 49741 1 84 646@ 18th Hampshire St 1 1 1 1   06/04/2003 12:00:00 AM     Permit Number 46540 6010086.91434322 2105281.03537103 37.761269634638296 -122.408218548113 (37.7612696346383, -122.408218548113)
94149 58408 1 84 755 Buena Vista Ave 1 1 1 1   03/19/1979 12:00:00 AM 5   Permit Number 17543 5999798.5 2108081.7 37.7683780948237 -122.44400294123699 (37.7683780948237, -122.444002941237)
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)
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)
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)
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)
106210 56999 1 84 4206 24th St 1 1 1 1   08/27/1974 12:00:00 AM     Permit Number 14257 6001838.61131344 2101787.92307498 37.7512130767933 -122.43649586805401 (37.7512130767933, -122.436495868054)
107994 39201 1 84 36 Commonwealth Ave 1 1 1 1   11/23/1998 12:00:00 AM   3x3 Permit Number 40852 5996541.64157093 2114326.11365116 37.7853372927938 -122.455719478601 (37.7853372927938, -122.455719478601)
111429 82056 1 84 447 Bright St 1 1 1 1   04/11/2011 12:00:00 AM   3x3 Permit Number 767285 5993745.17939928 2090171.13367763 37.718853024691896 -122.463640596127 (37.7188530246919, -122.463640596127)
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)
111732 50308 1 84 701 (REVISED) Grafton Ave 1 1 1 1   12/30/2003 12:00:00 AM     Permit Number 47019 5994734.51143453 2090549.74162157 37.719949548569396 -122.46024830726499 (37.7199495485694, -122.460248307265)
112476 19031 1 84 3190 Sacramento St 1 1 1 1     8 2X2   5999568.0947900005 2115476.97835 37.7886704841429 -122.445331680485 (37.7886704841429, -122.445331680485)
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)
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)
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)
119284 116071 3 84 4150X CLEMENT ST 1 7 1 2     8 3x3   5983115.0 2113126.0 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527)
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)
125784 42766 1 84 415 Buchanan St 1 1 1 1 1 11/03/2005 12:00:00 AM   3x3 Permit Number 48384 6004604.76721884 2109944.08482631 37.7737647507648 -122.42751119704201 (37.7737647507648, -122.427511197042)
131317 117739 2 84 475 39th Ave 1 2 1 1     4 Width 4ft   5983746.16527 2112679.78018 37.7800743257794 -122.49986552243 (37.7800743257794, -122.49986552243)
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)
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)
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)
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)
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)
140754 53304 1 84 47 Vicksburg St 1 1 1 1   08/21/1969 12:00:00 AM 2 4x4 Permit Number 6194 6004117.25840717 2102785.08371789 37.7540802654829 -122.42868713344 (37.7540802654829, -122.42868713344)
144369 19033 1 84 3192 Sacramento St 1 1 1 1     12 2X2   5999542.700669999 2115392.3027 37.7884365373764 -122.44541344917101 (37.7884365373764, -122.445413449171)
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)
148091 234924 2 84 323 Mullen Ave 1 2 1 1     5 Width 5ft   6010626.29866 2099830.99271 37.7463352122137 -122.4059690917 (37.7463352122137, -122.4059690917)
148635 136026 2 84 957 Sacramento St 1 10 1 1     3 Width 3ft   6010195.26054 2116841.12509 37.793017003381706 -122.408659357866 (37.7930170033817, -122.408659357866)
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)
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)
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)
158246 136025 2 84 80 MacOndray Ln 1 9 1 1     11     6008316.37067 2119137.06676 37.79921568041429 -122.415323048225 (37.7992156804143, -122.415323048225)
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)
168491 213704 2 84 635 Mangels Ave 1 9 1 1     15     5997206.92035 2095245.84356 37.7329858403205 -122.45204072612499 (37.7329858403205, -122.452040726125)
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)
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)
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)
175156 179165 2 84 671 London St 1 2 1 1     3     6001067.99101 2089902.67343 37.7185351226768 -122.438309369006 (37.7185351226768, -122.438309369006)
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)
184295 136024 2 84 66 MacOndray Ln 1 9 1 1     9     6008379.74874 2119143.46885 37.7992368207748 -122.415104191024 (37.7992368207748, -122.415104191024)
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)
188094 72435 2 84 339 Presidio Ave 1 1 1 1 1 04/13/1996 12:00:00 AM 13     5999048.262080001 2115432.1499099997 37.7885177095774 -122.447126990534 (37.7885177095774, -122.447126990534)
189034 122230 2 84 700 14th Ave 1 2 1 1     6 Width 3ft   5991662.29598 2110580.8797299997 37.774772683199394 -122.472327258665 (37.7747726831994, -122.472327258665)
9562 19696 3 84 100 STAIRWAY9 -3 1 1 2     12 15ST            
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)
86739 86757 1 84 500 Brotherhood Way   19 1 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
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)
95257 93959 1 84 419 Elizabeth St   8 1 1       3x3 Permit Number 53399 6003681.0 2102149.0 37.752309029626495 -122.430150445418 (37.7523090296265, -122.430150445418)
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)
143629 96998 6 84 2451X Griffith St   5 1 20 1         6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
Powered by Datasette · Query took 3.886ms · Data source: data.sfgov.org