sf-trees

Data source: data.sfgov.org

Custom SQL query returning 57 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
181728 136027 2 84 957 Sacramento St 2 10 1 1     4 Width 3ft   6010215.88282 2116843.14587 37.7930237069305 -122.408588145932 (37.7930237069305, -122.408588145932)
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)
183108 213705 2 84 175 Staples Ave 2 9 1 1     2     5998918.04752 2093764.63915 37.7290166671659 -122.4460184358 (37.7290166671659, -122.4460184358)
183588 196335 2 84 1900 19th St 10 7 1 1     1     6012008.47004 2105145.92381 37.761006057794 -122.401563163706 (37.761006057794, -122.401563163706)
184295 136024 2 84 66 MacOndray Ln 1 9 1 1     9     6008379.74874 2119143.46885 37.7992368207748 -122.415104191024 (37.7992368207748, -122.415104191024)
186195 196068 2 84 1700 Armstrong Ave 9 17 1 1     3     6013885.20395 2092887.6121599998 37.727451852204204 -122.39421406314399 (37.7274518522042, -122.394214063144)
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)
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)
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)
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)
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)
5325 40088 1 84   1 1 1 1   03/09/1999 12:00:00 AM     Permit Number 41311          
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)
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)
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)
124426 41411 1 84 531 Leland Ave 2 1 1 1   03/17/2000 12:00:00 AM     Permit Number 42023 6007932.96070428 2088253.06472002 37.7143937182098 -122.414463253601 (37.7143937182098, -122.414463253601)
47974 43350 1 84 651 Cambridge St 1 1 1 1   07/14/2000 12:00:00 AM 8   Permit Number 43102 6007249.157459999 2091540.3167400002 37.7233813767346 -122.417059535679 (37.7233813767346, -122.417059535679)
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)
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)
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)
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)
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)
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)
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)
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)
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)
100159 52194 1 84 415 Buchanan St 2 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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
Powered by Datasette · Query took 3.204ms · Data source: data.sfgov.org