sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
65292 87805 1 45 21 Mallorca Way   1 1 1   06/02/2008 12:00:00 AM   3x3 Permit Number 50570 6001886.8 2119949.6 37.8010832252731 -122.437629755692 (37.8010832252731, -122.437629755692)
86666 88224 1 45 1821 Hayes St   1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51220 5999142.0 2110084.0 37.7738384306008 -122.446417770519 (37.7738384306008, -122.446417770519)
92053 88271 1 45 142 Belvedere St   1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51257 5998321.8 2107947.7 37.7679258166536 -122.449101033169 (37.7679258166536, -122.449101033169)
96974 112589 2 45 776 TEHAMA ST   1 1 1       3x3   6009004.0 2110266.0 37.7748964951756 -122.41231625471 (37.7748964951756, -122.41231625471)
102768 88618 1 45 1815 Taraval St   1 1 1   08/04/2008 12:00:00 AM 4 3x3 Permit Number 51591 5987609.0 2098941.0 37.7425773238376 -122.485493894781 (37.7425773238376, -122.485493894781)
105477 112588 2 45 776 TEHAMA ST   1 1 1       3x3   6009004.0 2110266.0 37.7748964951756 -122.41231625471 (37.7748964951756, -122.41231625471)
111517 88222 1 45 1650 Fulton St   1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51218 5999862.0 2110923.0 37.7761832078575 -122.44398747698999 (37.7761832078575, -122.44398747699)
113170 88439 1 45 837 Moultrie St   1 1 1   07/11/2008 12:00:00 AM   3x3 Permit Number 51403 6007580.0 2095463.0 37.7341708239465 -122.416193557304 (37.7341708239465, -122.416193557304)
116144 87465 1 45 485 Scott St   1 1 1   05/07/2008 12:00:00 AM   3x3 Permit Number 50381 6002157.0 2110126.0 37.77412549340271 -122.43599141878201 (37.7741254934027, -122.435991418782)
119575 88274 1 45 4440 23rd St   1 1 1   07/09/2008 12:00:00 AM   3x3 Permit Number 51264 6000402.0 2102285.0 37.7524961905728 -122.441499478589 (37.7524961905728, -122.441499478589)
146176 89014 1 45 2147 Mason St   1 1 1   09/30/2008 12:00:00 AM   3X3 Permit Number 51763 6008963.0 2120596.0 37.803257869178 -122.41318870136499 (37.803257869178, -122.413188701365)
157979 89252 1 45 433 34th Ave   1 1 1   10/14/2008 12:00:00 AM 4 4x4 Permit Number 51885 5985288.27991 2112944.4922700003 37.780891524599 -122.49455024837 (37.780891524599, -122.49455024837)
576 240412 3 45 3420 Market St 1 4 1 2   04/19/1996 12:00:00 AM 7 Width 3ft   6000095.059769999 2103920.2632400002 37.7569687331323 -122.442678332141 (37.7569687331323, -122.442678332141)
1993 252846 2 45 1500 Harrison St 1 1 1 1       3x3   6008908.0 2108725.0 37.7706598827985 -122.412539385599 (37.7706598827985, -122.412539385599)
5190 253817 3 45 159 Gold Mine Dr 1 1 1 2       3x3   6001018.0 2098627.0 37.742487269754704 -122.43910710368601 (37.7424872697547, -122.439107103686)
6247 112539 2 45 426 Broadway 1 1 1 2   08/12/2016 11:10:00 AM 3 3x3   6011460.82325 2118719.23159 37.7982446311281 -122.404412674615 (37.7982446311281, -122.404412674615)
6998 112530 2 45 435 Broadway 1 1 1 2   03/24/2016 07:26:00 AM 3 3x3   6011409.86951 2118646.99301 37.7980434339179 -122.40458390283199 (37.7980434339179, -122.404583902832)
10245 43062 1 45 490 34th Ave 1 1 1 1   02/10/2017 12:00:00 AM 3 3x3 Permit Number 51464 5985348.18764 2112571.6735099996 37.779871377757296 -122.49431551232401 (37.7798713777573, -122.494315512324)
10980 52793 1 45 1277TEHAMA Houston St 1 1 1 1   05/25/2006 12:00:00 AM     Permit Number 48833          
11876 38200 1 45 514 Goettingen St 1 1 1 1 1 05/09/2002 12:00:00 AM 12 3x3 Permit Number 45184 6010449.69037 2092207.2371 37.7253921259422 -122.406042793857 (37.7253921259422, -122.406042793857)
14122 35743 1 45   1 1 1 1   04/15/1998 12:00:00 AM     Permit Number 39016          
15769 30659 1 45 54 Lafayette St 1 1 1 1 1 04/13/2015 12:00:00 AM 3 3x3 Permit Number 34592 6007591.74325 2109572.72569 37.7729135790239 -122.41715242667 (37.7729135790239, -122.41715242667)
17486 18596 1 45 409 Randolph St 1 1 1 1   07/26/1996 12:00:00 AM 6 3X3   5992903.2652 2088492.7734 37.7141961040887 -122.46642881780501 (37.7141961040887, -122.466428817805)
17788 18608 1 45 550 Randolph St 1 1 1 1   01/03/1997 12:00:00 AM 6 3X3   5992502.2173 2088557.38 37.7143503484358 -122.467819678694 (37.7143503484358, -122.467819678694)
17804 26068 1 45 282 Orizaba Ave 1 1 1 1   02/27/2003 12:00:00 AM 3 2X3   5994051.2236 2088339.7969 37.7138422407476 -122.46244996961 (37.7138422407476, -122.46244996961)
18331 34 3 45 759 14th St 1 1 1 2     18 3X3   6003742.09963 2107707.8799900003 37.767575847275204 -122.430335723414 (37.7675758472752, -122.430335723414)
18385 25468 3 45 437 Randolph St 1 1 1 2   07/26/1996 12:00:00 AM 6 3X3   5992774.4094 2088493.0908 37.7141895393891 -122.466874212626 (37.7141895393891, -122.466874212626)
18565 68830 1 45 111 Flood Ave 1 1 1 1 1 11/30/1993 12:00:00 AM     Permit Number 32781 6000000.33338592 2094041.19205625 37.729837760714204 -122.44229674739599 (37.7298377607142, -122.442296747396)
18943 26157 1 45 260 Orizaba Ave 1 1 1 1   06/27/1997 12:00:00 AM 3 3X3   5994051.6997 2088243.7899 37.713578655736 -122.462441364614 (37.713578655736, -122.462441364614)
19634 31 3 45 753 14th St 1 1 1 2   06/08/2016 06:04:00 AM 3 3X3   6003785.60824 2107710.67637 37.7675859898405 -122.430185432325 (37.7675859898405, -122.430185432325)
20666 33 3 45 755 14th St 1 1 1 2   02/17/1998 12:00:00 AM 3 3X3   6003762.7674 2107707.98129 37.7675772960935 -122.43026424352199 (37.7675772960935, -122.430264243522)
21370 22 3 45 725 14th St 1 1 1 2   01/18/2017 08:22:00 AM 3 3X3   6003898.66598 2107719.95316 37.7676178644975 -122.429795042015 (37.7676178644975, -122.429795042015)
21649 18607 1 45 530 Randolph St 1 1 1 1   07/26/1996 12:00:00 AM 6 3x3   5992558.0676 2088557.0731 37.7143527306111 -122.467626617395 (37.7143527306111, -122.467626617395)
23461 240416 2 45 12 Harper St 1 1 1 1     4 Width 3ft   6003644.58951 2098299.35585 37.7417367402568 -122.43000177276899 (37.7417367402568, -122.430001772769)
23811 140094 2 45 1652 FULTON ST 1 1 1 1     2 Width 0ft   5999863.0392 2110926.6558 37.7761933050322 -122.44398414486 (37.7761933050322, -122.44398414486)
24847 214027 2 45 130 Baden St 1 1 1 1     6 Width 2ft   6000768.47308 2094513.82924 37.7311792633149 -122.439675077667 (37.7311792633149, -122.439675077667)
25175 34531 1 45 635 24th Ave 1 1 1 1   07/22/1997 12:00:00 AM 5   Permit Number 38240 5988437.8449 2111647.649 37.7775145896121 -122.483559386935 (37.7775145896121, -122.483559386935)
25257 240410 2 45 235 Surrey St 1 1 1 1     6 Width 2ft   6001912.29637 2096185.45895 37.735834211766 -122.43584024433599 (37.735834211766, -122.435840244336)
25889 48457 1 45 520 06th St 1 1 1 1   08/05/2002 12:00:00 AM 6   Permit Number 45824 6011919.3472 2110495.26684 37.7756891719521 -122.402247516312 (37.7756891719521, -122.402247516312)
26737 41177 1 45 1555 Beach St 1 1 1 1 1 11/23/1999 12:00:00 AM 3   Permit Number 41896 6002761.3685800005 2121278.33423 37.804781267115104 -122.43469844348301 (37.8047812671151, -122.434698443483)
26763 240404 2 45 4362 21st St 1 1 1 1     1 Width 3ft   6000898.63467 2103311.26449 37.7553423460847 -122.439855611169 (37.7553423460847, -122.439855611169)
27566 200054 2 45 1800 Lane St 1 1 1 1     5 Width 0ft   6014879.1353 2094151.956 37.73097868287971 -122.39086633517 (37.7309786828797, -122.39086633517)
27641 240391 2 45 346 Bocana St 1 1 1 1     4 Width 3ft   6006743.91028 2097051.2853599999 37.7384848564878 -122.41919681678199 (37.7384848564878, -122.419196816782)
28437 240376 2 45 1367 Natoma St 1 1 1 1     9 Width 2ft   6007185.77161 2107529.7326700003 37.76728115653079 -122.41841184713499 (37.7672811565308, -122.418411847135)
29132 31972 1 45 100 02nd Ave 1 1 1 1 1 06/30/1995 12:00:00 AM 5   Permit Number 35372 5995228.46958 2114784.79077 37.786521248530995 -122.46029586964701 (37.786521248531, -122.460295869647)
29717 32611 1 45 2926 Kirkham St 1 1 1 1 1 10/23/1996 12:00:00 AM 0   Permit Number 37076 5985807.8579886 2105043.58172562 37.7592282476447 -122.492170870983 (37.7592282476447, -122.492170870983)
30553 240407 2 45 489 Laidley St 1 1 1 1     9 Width 4ft   6003411.63679 2096255.36709 37.7361112200507 -122.430661423705 (37.7361112200507, -122.430661423705)
31386 214044 2 45 119 Staples Ave 1 1 1 1     7 Width 2ft   5999274.87025 2093768.2240099998 37.729046879900295 -122.444785134325 (37.7290468799003, -122.444785134325)
31525 214031 2 45 119 Gennessee St 1 1 1 1     5 Width 2ft   5997420.89454 2093944.4368 37.7294247417474 -122.45120714359501 (37.7294247417474, -122.451207143595)
31765 214029 2 45 133 Baden St 1 1 1 1     5 Width 1ft   6000729.59206 2094530.6160900001 37.7312231430208 -122.43981069901301 (37.7312231430208, -122.439810699013)
32269 69005 1 45 2087 44th Ave 1 1 1 1 1 01/05/1994 12:00:00 AM 0   Permit Number 33006 5982594.36064133 2100924.19223319 37.7477291823956 -122.50297954562099 (37.7477291823956, -122.502979545621)
32460 214016 2 45 1310 Funston Ave 1 1 1 1     4 Width 3ft   5992104.55451 2106488.0935299997 37.7635605748926 -122.47049926614099 (37.7635605748926, -122.470499266141)
32809 137686 2 45 2143 GOLDEN GATE AVE 1 1 1 1     6 Width 0ft   5999343.9567 2111495.7816 37.7777263543907 -122.445820725833 (37.7777263543907, -122.445820725833)
33363 240383 2 45 65 Hermann St 1 1 1 1     6 Width 2ft   6004954.4402 2108809.15318 37.770668274943205 -122.426220805247 (37.7706682749432, -122.426220805247)
33748 214024 2 45 118 Baden St 1 1 1 1     1 Width 2ft   6000768.15588 2094464.1173900003 37.7310427480136 -122.43967261170201 (37.7310427480136, -122.439672611702)
33870 95740 1 45 61 Ina Ct 1 1 1 1 1 09/07/2011 12:00:00 AM 4 3x3 Permit Number 767486 6004943.22126 2091523.89765 37.7232063048111 -122.42502956775499 (37.7232063048111, -122.425029567755)
35987 51788 1 45 339 Bridgeview Dr 1 1 1 1   07/01/2009 12:00:00 AM 7 3x3 Permit Number 52292 6012718.572319999 2094804.9461700001 37.7326515416146 -122.39838161323 (37.7326515416146, -122.39838161323)
36032 84615 1 45 26 Mallorca Way 1 1 1 1   06/13/2008 12:00:00 AM 2 3x3 Permit Number 50848 6001974.9488 2119960.7519900003 37.8011188571965 -122.437325522376 (37.8011188571965, -122.437325522376)
36146 69007 1 45 2115 45th Ave 1 1 1 1 1 01/05/1994 12:00:00 AM 0   Permit Number 33008 5982291.49205895 2100703.22551621 37.7471046635524 -122.504010467091 (37.7471046635524, -122.504010467091)
38309 120769 2 45 4500 Fulton St 1 1 1 1     5 Width 3ft   5989405.82896 2109925.10593 37.7728412569544 -122.48008475013701 (37.7728412569544, -122.480084750137)
38403 197339 2 45 696 Amador St 1 7 1 1     24     6016827.1128 2099574.92506 37.745976956489294 -122.384509368331 (37.7459769564893, -122.384509368331)
39197 136301 2 45 119 Locust St 1 1 1 1     3 Width 3ft   5997498.90653 2116025.43206 37.790058058469 -122.452530326034 (37.790058058469, -122.452530326034)
39998 122277 2 45 1750 Balboa St 1 9 1 1     1 Width 3ft   5990139.99053 2111321.69927 37.7767185479371 -122.477647330613 (37.7767185479371, -122.477647330613)
40291 240392 2 45 1803 Folsom St 1 1 1 1     8 Width 4ft   6008038.16649 2107910.1392200002 37.768373611578205 -122.415490461517 (37.7683736115782, -122.415490461517)
40556 32518 1 45 842 Moultrie St 1 1 1 1 1 08/23/2007 12:00:00 AM 9   Permit Number 49664 6007548.7449 2095423.3131 37.7340600948986 -122.41629880637 (37.7340600948986, -122.41629880637)
41315 95661 1 45 231 Brussels St 1 1 1 1 1 03/08/2011 12:00:00 AM 3 3x3 Permit Number 767423 6010393.1108800005 2093567.05478 37.7291227359169 -122.406334153496 (37.7291227359169, -122.406334153496)
41388 75003 2 45 3501 Jackson St 1 1 1 1 1 02/10/1996 12:00:00 AM 5     5997399.304819999 2116036.40743 37.7900824867734 -122.452875730442 (37.7900824867734, -122.452875730442)
41529 73403 2 45 81 Lyell St 1 1 1 1 1 08/27/1994 12:00:00 AM 4     6003121.9233099995 2094558.5911 37.7314358416937 -122.43154198316999 (37.7314358416937, -122.43154198317)
41992 118563 2 45 8000 Geary Blvd 1 1 1 1     11 Width 3ft   5982185.81739 2112405.54556 37.7792296683273 -122.50524304882099 (37.7792296683273, -122.505243048821)
42442 136326 2 45 463 Broadway 1 1 1 1     3 Width 3ft   6011288.49181 2118628.67213 37.797986344959995 -122.405002616378 (37.79798634496, -122.405002616378)
42735 69006 1 45 2111 45th Ave 1 1 1 1 1 01/05/1994 12:00:00 AM 3   Permit Number 33007 5982290.62244002 2100729.28975496 37.7471761775601 -122.504015404359 (37.7471761775601, -122.504015404359)
43449 69150 1 45 3826 Ulloa St 1 1 1 1 1 01/18/1994 12:00:00 AM 4   Permit Number 33185 5984181.23627049 2098183.21295551 37.7402963417492 -122.49728998800501 (37.7402963417492, -122.497289988005)
44130 41755 1 45 1630 Jones St 1 1 1 1   06/19/2000 12:00:00 AM 5   Permit Number 42184 6008378.01882 2118113.9596 37.79640994672071 -122.415037267971 (37.7964099467207, -122.415037267971)
44795 122290 2 45 1750 Balboa St 1 9 1 1     1 Width 3ft   5990062.61204 2111318.0216900003 37.7767039596239 -122.47791473389799 (37.7767039596239, -122.477914733898)
46584 112541 3 45 438 Broadway 1 1 1 2     2 3x3   6011421.73685 2118713.41459 37.798226474727 -122.404547516275 (37.798226474727, -122.404547516275)
46879 52639 1 45 1634 47th Ave 1 1 1 1 1 03/08/2006 12:00:00 AM 3   Permit Number 48720 5981612.27437325 2103952.63979264 37.7559866741692 -122.506600058306 (37.7559866741692, -122.506600058306)
46883 214041 2 45 431 Staples Ave 1 1 1 1     7 Width 3ft   5997281.4748599995 2093791.4004 37.7289965565343 -122.451678093372 (37.7289965565343, -122.451678093372)
47021 179382 2 45 143 University St 1 1 1 1     10 Width 3ft   6007980.64963 2093237.8287400003 37.728083504546596 -122.414650965095 (37.7280835045466, -122.414650965095)
47444 68867 1 45 123 Staples Ave 1 1 1 1 1 10/08/1994 12:00:00 AM     Permit Number 32831 5999260.75597787 2093758.61799029 37.7290196985316 -122.444833238065 (37.7290196985316, -122.444833238065)
47685 214042 2 45 22 Gennessee St 1 9 1 1     16 Width 10ft   5997465.40478 2093699.4723200002 37.728754675784394 -122.451035610522 (37.7287546757844, -122.451035610522)
48149 240393 2 45 35 Hill St 1 10 1 1     3 Width 3ft   6006109.51353 2103440.5803799997 37.7559926584484 -122.421843980221 (37.7559926584484, -122.421843980221)
48290 67377 1 45 841 Balboa St 1 1 1 1 1 12/22/2015 12:00:00 AM 1   Permit Number 776566 5992946.95858 2111357.65552 37.776979766827104 -122.467939896695 (37.7769797668271, -122.467939896695)
48473 92109 1 45 654 46th Ave 1 1 1 1   07/02/2009 12:00:00 AM 3 3x3 Permit Number 52365 5981669.51861 2111284.19832 37.7761203861627 -122.506945906937 (37.7761203861627, -122.506945906937)
49623 43808 1 45 1420 Cabrillo St 1 1 1 1 1 07/26/2000 12:00:00 AM 1   Permit Number 43438 5991181.63114 2110671.05879 37.77499245989021 -122.473996541351 (37.7749924598902, -122.473996541351)
50005 181948 2 45 1813 Taraval St 1 1 1 1     3 Width 0ft   5987556.2457 2098923.5959 37.742526463070796 -122.48567502435301 (37.7425264630708, -122.485675024353)
50125 35432 1 45 1506 25th St 1 1 1 1 1 03/16/1998 12:00:00 AM 7   Permit Number 38878 6014141.4984800005 2102013.02263 37.7525225775725 -122.39396657421499 (37.7525225775725, -122.393966574215)
50859 240415 2 45 751 14th St 1 1 1 1     1 Width 2ft   6003800.46059 2107711.4253 37.7675888874331 -122.43013411340901 (37.7675888874331, -122.430134113409)
51677 81327 1 45 3236 Broderick St 1 1 1 1   06/13/2008 12:00:00 AM 4 3x3 Permit Number 50837 5999881.46394 2119701.75031 37.8002884744792 -122.444551235949 (37.8002884744792, -122.444551235949)
53292 217579 2 45 636 Randolph St 1 1 1 1     4 Width 0ft   5992273.5996 2088560.7555 37.714346412845295 -122.46861011007299 (37.7143464128453, -122.468610110073)
54592 32576 1 45 1366 32nd Ave 1 1 1 1 1 10/22/1996 12:00:00 AM 2   Permit Number 37050 5986201.05883385 2105941.9596711 37.7617179230551 -122.49087711798 (37.7617179230551, -122.49087711798)
54735 32597 1 45 1478 34th Ave 1 1 1 1 1 10/22/1996 12:00:00 AM 2   Permit Number 37065 5985606.43921528 2105161.9851204 37.759541574007 -122.492876185531 (37.759541574007, -122.492876185531)
54931 136322 2 45 360 Broadway 1 1 1 1     1 Width 5ft   6011695.90155 2118747.3363 37.798334933855294 -122.40360120733801 (37.7983349338553, -122.403601207338)
55875 61446 1 45 167 20th Ave 1 1 1 1 1 10/24/2005 12:00:00 AM 4   Permit Number 48286 5989582.2838 2114261.13607 37.7847570404878 -122.479791723267 (37.7847570404878, -122.479791723267)
56315 240406 2 45 101 Roanoke St 1 1 1 1     4 Width 3ft   6003419.55137 2096211.39701 37.7359909366181 -122.430630923178 (37.7359909366181, -122.430630923178)
56835 240403 2 45 557 Duncan St 1 1 1 1     6 Width 3ft   6002931.13898 2099759.29881 37.7457049727185 -122.43257290392799 (37.7457049727185, -122.432572903928)
57928 54837 1 45 131 Ashbury St 1 1 1 1 1 10/28/1995 12:00:00 AM 8   Permit Number 10691 5998715.81827648 2110282.46474316 37.77435901320929 -122.447906287477 (37.7743590132093, -122.447906287477)
58725 82802 1 45 770 40th Ave 1 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52410 5983565.30013547 2110567.26400669 37.7742633542941 -122.500334977362 (37.7742633542941, -122.500334977362)
59699 197345 2 45 1277 Howard St 1 1 1 1     8 Width 3ft   6008901.33871 2110395.02653 37.7752450102959 -122.41268050642599 (37.7752450102959, -122.412680506426)
60527 32523 1 45 861 Moultrie St 1 1 1 1 1 10/15/1996 12:00:00 AM 8   Permit Number 37025 6007568.6691 2095324.89508 37.7337909808565 -122.416222953925 (37.7337909808565, -122.416222953925)
61590 137691 2 45 2175 GOLDEN GATE AVE 1 1 1 1     2 Width 0ft   5999187.5809 2111472.1809 37.7776526229954 -122.44635998308 (37.7776526229954, -122.44635998308)
62196 240395 2 45 37 Highland Ave 1 1 1 1     2 Width 4ft   6005177.74113 2096695.2803099998 37.7374190204687 -122.42458656083201 (37.7374190204687, -122.424586560832)
Powered by Datasette · Query took 7.495ms · Data source: data.sfgov.org