sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2503 253120 1 3 815 Buena Vista Ave West 1 9 1 1       10x100   6000071.60031 2108311.04493 37.769023393565604 -122.44307478834801 (37.7690233935656, -122.443074788348)
8128 87100 1 3 700 Connecticut St 1 7 1 3       3x3 Permit Number 50056          
9593 94859 1 3   1 1 1 1       3x3 Permit Number 53932          
13319 93075 1 3 1230 Twin Peaks Blvd 1 9 1 1   02/01/2010 12:00:00 AM     Permit Number 53156 5997905.5 2100119.1 37.7464066170132 -122.449976668748 (37.7464066170132, -122.449976668748)
14837 94862 1 3   2 1 1 1       3x3 Permit Number 53932          
20076 98360 1 3 807 Francisco St 1 2 1 1         Permit Number 768654 6007370.5 2120864.5 37.8039055703948 -122.418718664572 (37.8039055703948, -122.418718664572)
34344 55599 1 3 642 43rd Ave 1 1 1 1   01/08/1973 12:00:00 AM 12   Permit Number 11573 5982597.2205300005 2111395.81021 37.776481429538705 -122.503745058688 (37.7764814295387, -122.503745058688)
40007 95885 1 3 1501@Ocean Sloat Blvd 16 9 1 1   03/16/2011 12:00:00 AM 12   Permit Number 767134 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
42964 95883 1 3 1501@Everglade Sloat Blvd 14 9 1 1   03/16/2011 12:00:00 AM 12   Permit Number 767134 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
65540 100177 1 3 252 States St 3 7 1 1         Permit Number 768965 6000636.0 2106677.4 37.764569975148895 -122.44100535545 (37.7645699751489, -122.44100535545)
66024 87113 1 3 470 West Portal Ave 4 19 1 1   01/03/2008 12:00:00 AM     Permit Number 50062 5991694.0 2096460.0 37.736002282933704 -122.47118857830601 (37.7360022829337, -122.471188578306)
66190 20482 1 3 1204 Sunset Blvd 3 1 1 3     42 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
67566 87917 1 3 160 Gardenside Dr 2 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50940 5999367.0 2102115.0 37.751970392561496 -122.445066449965 (37.7519703925615, -122.445066449965)
74227 96113 1 3 229 Point Lobos Ave 1 1 1 1 1 07/28/2011 12:00:00 AM 4 3x3 Permit Number 767768 5982054.02521 2112599.84865 37.779755411650704 -122.505713372558 (37.7797554116507, -122.505713372558)
78201 20481 1 3 1204 Sunset Blvd 2 1 1 3     48 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
79736 95880 1 3 1501@Clearfield Sloat Blvd 17 9 1 1   03/16/2011 12:00:00 AM 12   Permit Number 767134 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621)
80410 20503 1 3 1204 Sunset Blvd 24 1 1 3     12 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
80533 87918 1 3 160 Gardenside Dr 3 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50940 5999367.0 2102115.0 37.751970392561496 -122.445066449965 (37.7519703925615, -122.445066449965)
80577 85020 1 3 299 Maywood Dr 1 1 1 1           5994525.0 2094707.0 37.7313523209144 -122.46127371080699 (37.7313523209144, -122.461273710807)
81556 99518 1 3 1501@Clearfield Sloat Blvd 2 5 1 1   05/22/2012 12:00:00 AM     Permit Number 768821 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
82329 57589 1 3 93 Arbor St 1 1 1 1   12/19/2007 12:00:00 AM   3x3 Permit Number 50021 6001851.03848289 2096750.6660448 37.7373826596428 -122.436092469726 (37.7373826596428, -122.436092469726)
82693 20498 1 3 1204 Sunset Blvd 19 1 1 3     48 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
83538 92871 1 3 3600 Jackson St   1 1 1       3x3 Permit Number 53088 5997031.0 2116025.0 37.790030052590105 -122.454149203806 (37.7900300525901, -122.454149203806)
85342 99520 1 3 1501@Clearfield Sloat Blvd 19 5 1 1   05/22/2012 12:00:00 AM     Permit Number 768821 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621)
87086 20486 1 3 1204 Sunset Blvd 7 1 1 3     36 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
88950 86946 1 3 495 Pacheco St 1 13 1 1   11/20/2007 12:00:00 AM   3x3 Permit Number 51051 5993544.7 2101797.8 37.750765410178 -122.465177603148 (37.750765410178, -122.465177603148)
89237 87112 1 3 470 West Portal Ave 3 19 1 1   01/03/2008 12:00:00 AM     Permit Number 50062 5991694.0 2096460.0 37.736002282933704 -122.47118857830601 (37.7360022829337, -122.471188578306)
90425 20506 1 3 1211X Sunset Blvd 2 1 1 3     24 60   5984783.690159501 2107169.3790132 37.7650051676015 -122.49586970049101 (37.7650051676015, -122.495869700491)
90768 38768 1 3 2086 10th Ave 1 1 1 1         Permit Number 40635 5993219.31121709 2101288.86117635 37.7493492253318 -122.46626583425699 (37.7493492253318, -122.466265834257)
90956 99523 1 3 1501@Ocean Sloat Blvd 33 5 1 1   05/22/2012 12:00:00 AM     Permit Number 768821 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
91956 85282 1 3 1283 Greenwich St 1 1 1 1         Permit Number 49571 6006751.0 2119761.0 37.8008407409326 -122.42078409851001 (37.8008407409326, -122.42078409851)
92814 113055 1 3 815 Buena Vista West Ave 1 7 1 1           5999858.0 2108239.0 37.76881339508 -122.44380843942301 (37.76881339508, -122.443808439423)
93592 97535 1 3 300 Winfield St 1 14 1 1           6006649.9 2098038.3 37.7411896837785 -122.41959186825599 (37.7411896837785, -122.419591868256)
94528 85283 1 3 1283 Greenwich St 2 1 1 1         Permit Number 49571 6006751.0 2119761.0 37.8008407409326 -122.42078409851001 (37.8008407409326, -122.42078409851)
94706 52776 1 3 451@ CASTRO Jersey St 1 1 1 1         Permit Number 48822 6002227.28068346 2101467.46194579 37.750355244869105 -122.43512889078501 (37.7503552448691, -122.435128890785)
99272 20491 1 3 1204 Sunset Blvd 12 1 1 3     36 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
99897 20497 1 3 1204 Sunset Blvd 18 1 1 3     48 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
102283 20490 1 3 1204 Sunset Blvd 11 1 1 3     18 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
103272 50960 1 3 65 Montclair Ter 1 1 1 1         Permit Number 47453 6007264.23528351 2120370.2610527 37.8025425319574 -122.41905132385 (37.8025425319574, -122.41905132385)
103309 87916 1 3 160 Gardenside Dr 1 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50940 5999367.0 2102115.0 37.751970392561496 -122.445066449965 (37.7519703925615, -122.445066449965)
103757 40487 1 3 1955 10th Ave 1 1 1 1   06/21/1999 12:00:00 AM     Permit Number 41566 5993136.04980647 2102175.12230653 37.7517778666293 -122.466618163119 (37.7517778666293, -122.466618163119)
104110 20487 1 3 1204 Sunset Blvd 8 1 1 3     12 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
104414 54892 1 3 171 Carl St 1 1 1 1   02/27/2008 12:00:00 AM     Permit Number 50283 5997476.90745851 2107071.75606077 37.7654723391322 -122.45196020293601 (37.7654723391322, -122.451960202936)
104532 20502 1 3 1204 Sunset Blvd 23 1 1 3     18 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
105140 20485 1 3 1204 Sunset Blvd 6 1 1 3     36 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
105238 20492 1 3 1204 Sunset Blvd 13 1 1 3     6 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
105836 40618 1 3 201 Laguna St 1 1 1 1 1 11/03/2001 12:00:00 AM     Permit Number 41624 6005148.26696606 2109558.58269734 37.7727369810284 -122.425603701556 (37.7727369810284, -122.425603701556)
106366 108368 1 3 36 KNOLLVIEW WAY 2 7 1 1     3   Permit Number 774549 5997629.0 2101321.0 37.7496909137477 -122.451019424553 (37.7496909137477, -122.451019424553)
106956 97537 1 3 300 Winfield St 3 14 1 1           6006649.9 2098038.3 37.7411896837785 -122.41959186825599 (37.7411896837785, -122.419591868256)
107034 20493 1 3 1204 Sunset Blvd 14 1 1 3     6 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
107496 96868 1 3 2100X San Jose Ave 2 9 1 1           5999221.1 2091561.9 37.7229857575378 -122.444812491923 (37.7229857575378, -122.444812491923)
108958 99522 1 3 1501@Ocean Sloat Blvd 26 5 1 1   05/22/2012 12:00:00 AM     Permit Number 768821 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621)
109590 41376 1 3 491 Buena Vista East Ave 2 1 1 1         Permit Number 42013 6000280.5585881 2107138.11157559 37.7658147234719 -122.442267803649 (37.7658147234719, -122.442267803649)
110442 9647 1 3 420X Masonic Ave 1 1 1 1     50 3X3   5999128.38767 2111347.91542 37.77730804103229 -122.446555809153 (37.7773080410323, -122.446555809153)
112435 108367 1 3 36 KNOLLVIEW WAY 1 7 1 1     3   Permit Number 774549 5997629.0 2101321.0 37.7496909137477 -122.451019424553 (37.7496909137477, -122.451019424553)
113460 20494 1 3 1204 Sunset Blvd 15 1 1 3     18 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
114131 96875 1 3 2100X San Jose Ave 7 9 1 1           5999221.1 2091561.9 37.7229857575378 -122.444812491923 (37.7229857575378, -122.444812491923)
114357 85057 1 3 114 Chattanooga St 1 1 1 1   06/29/2007 12:00:00 AM     Permit Number 49394 6004707.0 2103005.0 37.754717463060395 -122.426663322428 (37.7547174630604, -122.426663322428)
114374 95881 1 3 1501@Ocean Sloat Blvd 17 9 1 1   03/16/2011 12:00:00 AM 12   Permit Number 767134 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
114437 96866 1 3 2100X San Jose Ave 1 9 1 1           5999221.1 2091561.9 37.7229857575378 -122.444812491923 (37.7229857575378, -122.444812491923)
115747 97403 1 3 2 STANFORD HEIGHTS AVE 1 2 1 1           5997807.0 2095590.8 37.7339673631019 -122.449990957178 (37.7339673631019, -122.449990957178)
115936 20480 1 3 1204 Sunset Blvd 1 1 1 3     48 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
116169 87111 1 3 470 West Portal Ave 2 19 1 1   01/03/2008 12:00:00 AM     Permit Number 50062 5991694.0 2096460.0 37.736002282933704 -122.47118857830601 (37.7360022829337, -122.471188578306)
118061 99521 1 3 1501@Clearfield Sloat Blvd 20 5 1 1   05/22/2012 12:00:00 AM     Permit Number 768821 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
118959 41377 1 3 491 Buena Vista East Ave 1 1 1 1         Permit Number 42013 6000280.5585881 2107138.11157559 37.7658147234719 -122.442267803649 (37.7658147234719, -122.442267803649)
119828 20484 1 3 1204 Sunset Blvd 5 1 1 3     36 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
120101 97404 1 3 2@Melrose Stanford Heights Ave 1 2 1 1           5997807.0 2095590.8 37.7339673631019 -122.449990957178 (37.7339673631019, -122.449990957178)
120944 85217 1 3 1913 Castro St 1 1 1 1           6002690.1 2099961.9 37.746247596031296 -122.43342085572901 (37.7462475960313, -122.433420855729)
121001 20500 1 3 1204 Sunset Blvd 21 1 1 3     6 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
122040 95884 1 3 1501@Everglade Sloat Blvd 17 9 1 1   03/16/2011 12:00:00 AM 12   Permit Number 767134 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621)
122306 52778 1 3 451@ CASTRO Jersey St 2 1 1 1         Permit Number 48822 6002227.28068346 2101467.46194579 37.750355244869105 -122.43512889078501 (37.7503552448691, -122.435128890785)
122730 52420 1 3 60@ 29TH ST Zircon Pl 1 1 1 1         Permit Number 48540 6002312.55382502 2098717.30876937 37.7428088130721 -122.434637382981 (37.7428088130721, -122.434637382981)
122754 99519 1 3 1501@Clearfield Sloat Blvd 5 5 1 1   05/22/2012 12:00:00 AM     Permit Number 768821 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
122763 86746 1 3 41 Nevada St   7 1 1         Permit Number 49711 6009063.0 2098235.0 37.7418654099413 -122.411262090685 (37.7418654099413, -122.411262090685)
126238 52742 1 3 432@ NOE 28th St 1 1 1 1   04/26/2006 12:00:00 AM     Permit Number 48791 6003090.32224136 2099513.72726182 37.7450397163723 -122.4320049394 (37.7450397163723, -122.4320049394)
126874 95334 1 3 466 Gonzalez Dr 1 1 1 1   02/28/2011 12:00:00 AM 75   Permit Number 767212 5989603.4 2089229.6 37.7160282834266 -122.477888136934 (37.7160282834266, -122.477888136934)
128377 79685 1 3 2 Hahn St 1 1 1 1   04/18/2008 12:00:00 AM   3x3 Permit Number 50355 6007801.88811391 2088315.49386025 37.7145577712837 -122.414920709681 (37.7145577712837, -122.414920709681)
138913 113080 1 3 89 Castenada Ave 1 9 1 1       10x2 Permit Number 776239 5994496.1 2101295.2 37.7494402154084 -122.461851162221 (37.7494402154084, -122.461851162221)
139137 20489 1 3 1204 Sunset Blvd 10 1 1 3     18 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
139210 100069 1 3 619 Gonzalez Dr 1 1 1 1   07/13/2012 12:00:00 AM     Permit Number 769006 5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
139433 53183 1 3 125 HERNANDEZ Vasquez Ave 1 1 1 1         Permit Number 49101 5995111.76133889 2099617.2866261 37.7448685093949 -122.45960069150699 (37.7448685093949, -122.459600691507)
140992 94636 1 3 170X Crestmont Dr 1 7 1 1   09/24/2010 12:00:00 AM     Permit Number 53783 5995178.5 2103444.0 37.7553795372421 -122.45964703776801 (37.7553795372421, -122.459647037768)
141981 87114 1 3 470 West Portal Ave 5 19 1 1   01/03/2008 12:00:00 AM     Permit Number 50062 5991694.0 2096460.0 37.736002282933704 -122.47118857830601 (37.7360022829337, -122.471188578306)
143327 87115 1 3 470 West Portal Ave 6 19 1 1   01/03/2008 12:00:00 AM     Permit Number 50062 5991694.0 2096460.0 37.736002282933704 -122.47118857830601 (37.7360022829337, -122.471188578306)
144308 97536 1 3 300 Winfield St 2 14 1 1         Permit Number 768224 6006649.9 2098038.3 37.7411896837785 -122.41959186825599 (37.7411896837785, -122.419591868256)
144564 95882 1 3 1501@Clearfield Sloat Blvd 13 9 1 1   03/16/2011 12:00:00 AM 12   Permit Number 767134 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
144600 20499 1 3 1204 Sunset Blvd 20 1 1 3     48 40   5984687.760267501 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741)
144816 99524 1 3 1501@Everglade Sloat Blvd 12 5 1 1   05/22/2012 12:00:00 AM     Permit Number 768821 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
145163 94637 1 3 170X Crestmont Dr 2 7 1 1   09/24/2010 12:00:00 AM     Permit Number 53783 5995178.5 2103444.0 37.7553795372421 -122.45964703776801 (37.7553795372421, -122.459647037768)
145766 51721 1 3 1335 Douglass St 2 1 1 1   05/02/2005 12:00:00 AM     Permit Number 47991 6001394.735632 2099881.41998428 37.7459530403724 -122.437894295142 (37.7459530403724, -122.437894295142)
145924 87273 1 3 4 Miraloma Dr 1 16 1 1   03/12/2008 12:00:00 AM     Permit Number 50295 5995203.0 2097905.0 37.7401722415629 -122.45916124145 (37.7401722415629, -122.45916124145)
149391 63257 1 3 465 36th Ave 1 1 1 1   01/23/1987 12:00:00 AM 38   Permit Number 23810 5984679.75149 2112668.94882 37.780099327718794 -122.49663507465799 (37.7800993277188, -122.496635074658)
184966 54835 1 3 117 Ashbury St 1 1 1 1   08/09/1972 12:00:00 AM 15   Permit Number 10689 5998722.2979 2110262.8651 37.7743055679817 -122.447882461981 (37.7743055679817, -122.447882461981)
162 251231 2 3 164 Serrano Dr 1 1 1 1       3x3   5989598.0 2090848.0 37.7204716934452 -122.478025052476 (37.7204716934452, -122.478025052476)
818 251389 2 3 202x Mangels Ave 1 9 1 1       3x3   5999774.0 2095231.0 37.7330917931436 -122.44316462438499 (37.7330917931436, -122.443164624385)
934 251409 2 3 95x Andover St 1 14 1 1       3x3   6007642.0 2098274.0 37.741892697320296 -122.41617822056101 (37.7418926973203, -122.416178220561)
1034 251427 2 3 5028 Diamond Heights Blvd 1 9 1 1       3x3   5999606.0 2100130.0 37.7465337016449 -122.44409733772801 (37.7465337016449, -122.444097337728)
1620 251543 2 3 0X Bay Shore Blvd Off Ramp   17 1 1                    
1772 173895 2 3 326x Dellbrook Ave 2 13 1 1     3 3x3   5997295.0 2102064.0 37.7517118802849 -122.452228008054 (37.7517118802849, -122.452228008054)
2100 178279 2 3 900 Brotherhood Way 6 7 1 2     4 Width 0ft   5987917.15522 2088760.91322 37.714643374877895 -122.48368218070499 (37.7146433748779, -122.483682180705)
2399 253072 2 3 1350 46th Ave 1 9 1 1       5x10 Permit Number 780489 5981849.666569999 2105897.22193 37.761339917853896 -122.50592325662 (37.7613399178539, -122.50592325662)
Powered by Datasette · Query took 17.799ms · Data source: data.sfgov.org