sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
83145 118340 8 11 1 Franklin St 1 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
121990 118341 8 11 1 Franklin St 2 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
97792 89263 8 2 1 Polk St 2 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 775142 6007496.395175 2110885.881534 37.7765138277066 -122.41757533494 (37.7765138277066, -122.41757533494)
80528 108822 8 120 101x FREMONT ST 2 1 1 1       5x5   6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258)
87984 108821 8 120 101x FREMONT ST 1 1 1 1   01/06/2015 12:00:00 AM 3 5x5 Permit Number 774616 6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258)
145351 108823 8 120 101x FREMONT ST 3 1 1 1       5x5   6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258)
50489 108536 8 11 1036X Mission St 2 1 1 1       3x3   6009831.243980001 2112235.16984 37.780349758914795 -122.40959364419399 (37.7803497589148, -122.409593644194)
29879 97159 8 138 1079 Le Conte Ave 6 1 1 1   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012757.6057400005 2089814.3813 37.7189506418481 -122.397896712286 (37.7189506418481, -122.397896712286)
72331 97157 8 138 1079 Le Conte Ave 4 1 1 1   08/25/2011 12:00:00 AM 2   Permit Number 768080 6012734.70575 2089832.2191 37.7189983454895 -122.397977119771 (37.7189983454895, -122.397977119771)
73660 97156 8 138 1079 Le Conte Ave 3 1 1 1   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012721.62132 2089840.20593 37.7190195469812 -122.39802290784401 (37.7190195469812, -122.398022907844)
132132 97154 8 138 1079 Le Conte Ave 1 1 1 1   08/25/2011 12:00:00 AM 4   Permit Number 768080 6012676.26956 2089874.1029 37.7191100952408 -122.398182049174 (37.7191100952408, -122.398182049174)
149702 97155 8 138 1079 Le Conte Ave 2 1 1 1   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012703.24235 2089857.9517299999 37.719067249734294 -122.398087681509 (37.7190672497343, -122.398087681509)
181154 97158 8 138 1079 Le Conte Ave 5 1 1 1   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012744.23117 2089823.98249 37.7189762599209 -122.39794361640101 (37.7189762599209, -122.397943616401)
81444 101926 8 147 1099X Hyde St 3 1 1 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639.0 2116135.7 37.790936579280896 -122.417454166812 (37.7909365792809, -122.417454166812)
143550 101925 8 147 1099X Hyde St 2 1 1 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639.0 2116135.7 37.790936579280896 -122.417454166812 (37.7909365792809, -122.417454166812)
144056 101924 8 147 1099X Hyde St 1 1 1 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639.0 2116135.7 37.790936579280896 -122.417454166812 (37.7909365792809, -122.417454166812)
84197 113998 8 44 1110 SOUTH VAN NESS AVE 1 1 1 1   10/27/2015 12:00:00 AM 3 3x3   6007591.0 2103152.0 37.75528371898589 -122.41670005245301 (37.7552837189859, -122.416700052453)
121912 111085 8 183 117 Manchester St 1 7 1 1   05/20/2015 12:00:00 AM 3   Permit Number 774000 6008295.8 2099262.4 37.744643365507706 -122.413987490618 (37.7446433655077, -122.413987490618)
83777 103097 8 478 1199X Pacific Ave 1 1 1 1   03/20/2013 12:00:00 AM   3x3 Permit Number 768649 6008392.3 2117900.9 37.7958257402639 -122.41497276422399 (37.7958257402639, -122.414972764224)
11899 113090 8 9 1213 Silver Ave 1 1 1 1   09/08/2015 12:00:00 AM 3 3x3   6008675.52728 2094042.6087200001 37.7303322746045 -122.41230559972999 (37.7303322746045, -122.41230559973)
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)
108143 110651 8 2 127 CENTRAL AVE 1 1 1 1     1 3x3   5999845.0 2108967.0 37.770811558248 -122.44390571748998 (37.770811558248, -122.44390571749)
88908 107533 8 17 130 MATEO ST 1 1 1 1   02/05/2015 12:00:00 AM 3 3x3 Permit Number 774373 6003821.3 2096389.2 37.7365018950939 -122.429254591879 (37.7365018950939, -122.429254591879)
71351 101919 8 15 1401X California St 1 1 1 1   12/07/2012 12:00:00 AM 9 3x3 Permit Number 769132 6007497.406219999 2116101.25633 37.7908340376155 -122.417941633898 (37.7908340376155, -122.417941633898)
115319 101923 8 127 1401X California St 7 1 1 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007402.7 2116063.9 37.790726135860204 -122.418266664095 (37.7907261358602, -122.418266664095)
154640 101920 8 15 1401X California St 3 1 1 1   12/07/2012 12:00:00 AM 13 3x3 Permit Number 769132 6007536.5156 2116104.21807 37.79084437080729 -122.41780652694901 (37.7908443708073, -122.417806526949)
159429 101921 8 15 1401X California St 5 1 1 1   12/07/2012 12:00:00 AM 3 3x3 Permit Number 769132 6007574.87115 2116111.37594 37.7908661829645 -122.41767432572901 (37.7908661829645, -122.417674325729)
185806 101922 8 15 1401X California St 6 1 1 1   12/07/2012 12:00:00 AM 4 3x3 Permit Number 769132 6007599.52227 2116115.67925 37.7908793859256 -122.417589338874 (37.7908793859256, -122.417589338874)
64007 102480 8 21 1456 Chestnut St 1 1 1 1   01/25/2013 12:00:00 AM 3 3x3 Permit Number 768914 6004877.03101 2120232.9115400002 37.80203068792579 -122.427302455863 (37.8020306879258, -122.427302455863)
33388 103092 8 250 1540 Jones St 2 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008422.05981 2117808.6375599997 37.7955740826282 -122.41486325634399 (37.7955740826282, -122.414863256344)
42795 103093 8 250 1540 Jones St 3 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008420.39916 2117820.52002 37.79560661561779 -122.41486984389401 (37.7956066156178, -122.414869843894)
62948 103091 8 250 1540 Jones St 1 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008424.20559 2117797.21945 37.7955428518875 -122.414855023041 (37.7955428518875, -122.414855023041)
149863 103095 8 250 1540 Jones St 5 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008416.42419 2117851.09099 37.7956903325975 -122.414885762773 (37.7956903325975, -122.414885762773)
160143 103094 8 250 1540 Jones St 4 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008418.50881 2117836.67229 37.7956508595435 -122.414877528601 (37.7956508595435, -122.414877528601)
176988 103096 8 250 1540 Jones St 6 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008414.12252 2117870.41106 37.795743251405504 -122.414895095058 (37.7957432514055, -122.414895095058)
97621 98306 8 18 155 Terrace Dr   1 1 1           5993776.0 2096639.0 37.7366139805049 -122.46400331489299 (37.7366139805049, -122.464003314893)
98791 111204 8 18 168 CLIPPER ST 1 1 1 1   05/27/2015 12:00:00 AM 3 3x3   6004024.0 2101044.0 37.7492943788142 -122.428885525131 (37.7492943788142, -122.428885525131)
114269 111632 8 17 1758 36th Ave 1 1 1 1   06/15/2015 12:00:00 AM 3 3x3 Permit Number 774682 5985071.0 2103231.6 37.7542099449347 -122.49458566251002 (37.7542099449347, -122.49458566251)
53719 98437 8 21 1840 Washington St 1 1 1 1   02/13/2012 12:00:00 AM 4 4x12 Permit Number 768068 6005870.33263 2116931.58044 37.7930221942694 -122.423630300016 (37.7930221942694, -122.423630300016)
151907 111321 8 5 1X Peabody St 1 1 1 1     15     6010185.8855099995 2087316.24933 37.7119477217782 -122.406610237293 (37.7119477217782, -122.406610237293)
93245 112892 8 216 1X WEBSTER ST 4 9 1 1       3x3   6004219.0 2108568.0 37.769964530341895 -122.428747509741 (37.7699645303419, -122.428747509741)
98492 112891 8 216 1X WEBSTER ST 3 9 1 1       3x3   6004219.0 2108568.0 37.769964530341895 -122.428747509741 (37.7699645303419, -122.428747509741)
98030 118337 8 12 2 Page St 2 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
108721 118336 8 12 2 Page St 1 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
115517 118338 8 12 2 Page St 3 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
138904 118339 8 12 2 Page St 4 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
3768 228283 8 44 2036X 15th St 6 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3773 228285 8 44 2036X 15th St 8 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3775 228281 8 44 2036X 15th St 4 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3776 228280 8 44 2036X 15th St 3 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3780 228286 8 44 2036X 15th St 9 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3781 228284 8 44 2036X 15th St 7 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3791 228279 8 44 2036X 15th St 2 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3795 228282 8 44 2036X 15th St 5 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
18918 109119 8 44 2036x 15TH ST 5 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
82999 109123 8 44 2036x 15TH ST 9 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
93411 109120 8 44 2036x 15TH ST 6 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
93779 109124 8 44 2036x 15TH ST 10 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
100550 109117 8 44 2036x 15TH ST 3 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
104643 109122 8 44 2036x 15TH ST 8 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
125094 109115 8 44 2036x 15TH ST 1 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
125268 109121 8 44 2036x 15TH ST 7 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
126955 109116 8 44 2036x 15TH ST 2 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
140060 109118 8 44 2036x 15TH ST 4 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
99592 112755 8 37 2038 Balboa St 2 1 1 1   08/19/2015 12:00:00 AM   3x3   5989157.5 2111303.8 37.7766123371313 -122.481044705999 (37.7766123371313, -122.481044705999)
144968 17872 8 73 2148 Pine St 2 1 1 2 3 07/21/2010 12:00:00 AM 0 3X3 Permit Number 53638 6003654.7045158 2115269.5781823 37.788333445178104 -122.43117780902399 (37.7883334451781, -122.431177809024)
175584 96402 8 12 2160 36th Ave 1 1 1 1   05/12/2011 12:00:00 AM 1 2x3   5985141.5215 2100472.7854 37.746639122425606 -122.494138462065 (37.7466391224256, -122.494138462065)
84595 102523 8 62 2192 Funston Ave 1 1 1 1   01/29/2013 12:00:00 AM   3X3 Permit Number 769544 5992300.8 2100554.8 37.7472806432819 -122.46938861272601 (37.7472806432819, -122.469388612726)
18623 117138 8 49 2203x NEWCOMB AVE 3 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
84121 117143 8 49 2203x NEWCOMB AVE 8 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
95513 117140 8 49 2203x NEWCOMB AVE 5 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
103897 117136 8 49 2203x NEWCOMB AVE 1 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
109812 117145 8 49 2203x NEWCOMB AVE 10 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
111043 117137 8 49 2203x NEWCOMB AVE 2 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
112757 117142 8 49 2203x NEWCOMB AVE 7 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
116617 117139 8 49 2203x NEWCOMB AVE 4 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
123153 117141 8 49 2203x NEWCOMB AVE 6 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
139017 117144 8 49 2203x NEWCOMB AVE 9 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
44012 114160 8 21 2250 Vallejo St 2 1 1 1   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002777.5161 2117854.22202 37.7953804657925 -122.43439760046499 (37.7953804657925, -122.434397600465)
62298 114159 8 21 2250 Vallejo St 1 1 1 1   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002793.85496 2117859.65506 37.795396310934294 -122.434341453993 (37.7953963109343, -122.434341453993)
87817 112830 8 26 2265 MISSION ST 1 1 1 1   08/21/2015 12:00:00 AM 3 3x3   6006944.0 2105170.0 37.760788269780996 -122.41908070679399 (37.760788269781, -122.419080706794)
13395 110744 8 172 2300x Mariposa St 4 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010545.16814 2106015.79361 37.76331276399971 -122.406685416098 (37.7633127639997, -122.406685416098)
13873 110741 8 172 2300x Mariposa St 1 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010604.54028 2106019.5636299998 37.7633264372932 -122.40648033199498 (37.7633264372932, -122.406480331995)
13959 110743 8 246 2300x Mariposa St 3 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010565.192009999 2106016.80838 37.7633166706365 -122.406616231274 (37.7633166706365, -122.406616231274)
14294 110746 8 172 2300x Mariposa St 6 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010517.260009999 2106013.51672 37.7633049506856 -122.406781781161 (37.7633049506856, -122.406781781161)
15363 110742 8 172 2300x Mariposa St 2 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010595.22782 2106018.33058 37.7633225306396 -122.40651245401101 (37.7633225306396, -122.406512454011)
16786 110745 8 298 2300x Mariposa St 5 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010533.01376 2106015.32988 37.763310810661295 -122.406727421634 (37.7633108106613, -122.406727421634)
112556 112627 8 37 2385 BUSH ST 1 1 1 1       3x3   6002100.0 2114635.0 37.78650283124671 -122.436511387034 (37.7865028312467, -122.436511387034)
79684 107964 8 15 2401x SCOTT ST 1 1 1 1   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001096.0 2116670.0 37.792033311180504 -122.440130949989 (37.7920333111805, -122.440130949989)
8965 107967 8 15 2405x Scott St 4 1 1 1   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001240.6892800005 2116684.58018 37.792081580751294 -122.439631370586 (37.7920815807513, -122.439631370586)
108448 85460 8 17 245x Guerrero St 2 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006128.0 2107603.0 37.7674227286224 -122.422075738783 (37.7674227286224, -122.422075738783)
111923 85461 8 17 245x Guerrero St 3 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006128.0 2107603.0 37.7674227286224 -122.422075738783 (37.7674227286224, -122.422075738783)
116308 85459 8 17 245x Guerrero St 1 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006128.0 2107603.0 37.7674227286224 -122.422075738783 (37.7674227286224, -122.422075738783)
1138 44040 8 21 2504 Jackson St 1 1 1 1   11/30/2012 12:00:00 AM 3   Permit Number 769379 6002104.9323 2116736.7445400003 37.7922739619269 -122.436644820121 (37.7922739619269, -122.436644820121)
1723 112197 8 44 2570 Jackson St 1 1 1 1   07/16/2015 12:00:00 AM 3 3x3   6001886.22681 2116705.46829 37.792175654341605 -122.43739930364599 (37.7921756543416, -122.437399303646)
102547 112688 8 49 259 BRIGHT ST 1 1 1 1   08/18/2015 12:00:00 AM 3 5x4   5993720.0 2088919.0 37.71541351482001 -122.46363680360001 (37.71541351482, -122.4636368036)
51328 109935 8 11 260 05th St 4 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302.0 2112245.5 37.780460426865396 -122.404506314811 (37.7804604268654, -122.404506314811)
77766 100060 8 11 260 05th St 3 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435.0 2112345.0 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068)
97598 100059 8 11 260 05th St 2 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435.0 2112345.0 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068)
112863 32654 8 11 260 05th St 1 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011426.1069309 2112339.71009356 37.7807260408269 -122.40408360027 (37.7807260408269, -122.40408360027)
124592 109936 8 11 260 05th St 5 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302.0 2112245.5 37.780460426865396 -122.404506314811 (37.7804604268654, -122.404506314811)
Powered by Datasette · Query took 4.155ms · Data source: data.sfgov.org