Street_Tree_List

Data source: data.sfgov.org

616 rows where qSpecies = 45

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
122 183689 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1341 42nd Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5983043.6112 2105976.497 37.761627789464704 -122.501799836383 (37.7616277894647, -122.501799836383)
576 240412 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 3420 Market St 1 : 4 Tree 1 DPW 2   04/19/1996 12:00:00 AM 7 Width 3ft   6000095.059769999 2103920.2632400002 37.7569687331323 -122.442678332141 (37.7569687331323, -122.442678332141)
596 240413 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 3420 Market St 2 : 4 Tree 1 DPW 2   04/19/1996 12:00:00 AM 8 Width 3ft   6000107.95046 2103900.11575 37.756914147893795 -122.442632304847 (37.7569141478938, -122.442632304847)
1152 240384 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 65 Hermann St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/04/2017 12:00:00 AM 3 Width 2ft Permit Number 779910 6004983.769180001 2108813.08838 37.7706807377627 -122.426119636009 (37.7706807377627, -122.426119636009)
1553 207056 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 340 Vicente St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5991811.94775 2097766.11202 37.7395953573424 -122.470875903123 (37.7395953573424, -122.470875903123)
1559 207057 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 340 Vicente St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5991827.84816 2097768.2699700003 37.7396022020835 -122.47082108403099 (37.7396022020835, -122.470821084031)
1984 252847 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1500 Harrison St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6008908.0 2108725.0 37.7706598827985 -122.412539385599 (37.7706598827985, -122.412539385599)
1993 252846 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1500 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6008908.0 2108725.0 37.7706598827985 -122.412539385599 (37.7706598827985, -122.412539385599)
2099 200057 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1898x Lane St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6014825.8229 2094079.4071 37.7307765200208 -122.39104557773999 (37.7307765200208, -122.39104557774)
2370 112542 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 438 Broadway 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/24/2016 12:00:00 AM 3 3x3   6011405.06525 2118709.9257400003 37.7982159634572 -122.40460495956002 (37.7982159634572, -122.40460495956)
5190 253817 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 159 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6001018.0 2098627.0 37.742487269754704 -122.43910710368601 (37.7424872697547, -122.439107103686)
6247 112539 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 426 Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/12/2016 11:10:00 AM 3 3x3   6011460.82325 2118719.23159 37.7982446311281 -122.404412674615 (37.7982446311281, -122.404412674615)
6998 112530 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 435 Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/24/2016 07:26:00 AM 3 3x3   6011409.86951 2118646.99301 37.7980434339179 -122.40458390283199 (37.7980434339179, -122.404583902832)
7100 106210 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 585X Bush St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/06/2014 12:00:00 AM 3 3x3 Permit Number 774310 6010773.37918 2115862.1930299997 37.7903614528559 -122.406590009715 (37.7903614528559, -122.406590009715)
9846 41266 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2929 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/23/2016 12:00:00 AM 3   Permit Number 779089 6002905.04785 2118704.6759200003 37.7977228301084 -122.434017142274 (37.7977228301084, -122.434017142274)
10245 43062 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 490 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 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)
10851 52794 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1277TEHAMA Houston St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2006 12:00:00 AM     Permit Number 48833          
10944 35742 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/15/1998 12:00:00 AM     Permit Number 39016          
10980 52793 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1277TEHAMA Houston St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2006 12:00:00 AM     Permit Number 48833          
11876 38200 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 514 Goettingen St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 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)
13065 52792 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1277TEHAMA Houston St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2006 12:00:00 AM     Permit Number 48833          
13295 187666 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 107 Bernard St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 2ft   6008318.73536 2118064.92593 37.796271980829 -122.415238929252 (37.796271980829, -122.415238929252)
14122 35743 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/15/1998 12:00:00 AM     Permit Number 39016          
14808 106045 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2201X 20th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/21/2014 12:00:00 AM 14 4x14 Permit Number 772230 6011471.492269999 2104620.16703 37.7595324691706 -122.403383358282 (37.7595324691706, -122.403383358282)
15769 30659 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 54 Lafayette St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 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 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 409 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/26/1996 12:00:00 AM 6 3X3   5992903.2652 2088492.7734 37.7141961040887 -122.46642881780501 (37.7141961040887, -122.466428817805)
17788 18608 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 550 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/03/1997 12:00:00 AM 6 3X3   5992502.2173 2088557.38 37.7143503484358 -122.467819678694 (37.7143503484358, -122.467819678694)
17804 26068 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 282 Orizaba Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/27/2003 12:00:00 AM 3 2X3   5994051.2236 2088339.7969 37.7138422407476 -122.46244996961 (37.7138422407476, -122.46244996961)
18331 34 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 759 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6003742.09963 2107707.8799900003 37.767575847275204 -122.430335723414 (37.7675758472752, -122.430335723414)
18385 25468 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 437 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/26/1996 12:00:00 AM 6 3X3   5992774.4094 2088493.0908 37.7141895393891 -122.466874212626 (37.7141895393891, -122.466874212626)
18565 68830 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 111 Flood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 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 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 260 Orizaba Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/27/1997 12:00:00 AM 3 3X3   5994051.6997 2088243.7899 37.713578655736 -122.462441364614 (37.713578655736, -122.462441364614)
19205 17244 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 10X Randolph St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/08/2005 12:00:00 AM 6 3X3   5993945.3779 2088542.9193 37.7143938707274 -122.462830535838 (37.7143938707274, -122.462830535838)
19634 31 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 753 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/08/2016 06:04:00 AM 3 3X3   6003785.60824 2107710.67637 37.7675859898405 -122.430185432325 (37.7675859898405, -122.430185432325)
20666 33 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 755 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/17/1998 12:00:00 AM 3 3X3   6003762.7674 2107707.98129 37.7675772960935 -122.43026424352199 (37.7675772960935, -122.430264243522)
21370 22 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 725 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/18/2017 08:22:00 AM 3 3X3   6003898.66598 2107719.95316 37.7676178644975 -122.429795042015 (37.7676178644975, -122.429795042015)
21649 18607 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 530 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/26/1996 12:00:00 AM 6 3x3   5992558.0676 2088557.0731 37.7143527306111 -122.467626617395 (37.7143527306111, -122.467626617395)
22821 197331 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1501 25th St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     6014124.123369999 2101967.77095 37.752397360459 -122.39402349321199 (37.752397360459, -122.394023493212)
23461 240416 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 12 Harper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6003644.58951 2098299.35585 37.7417367402568 -122.43000177276899 (37.7417367402568, -122.430001772769)
23811 140094 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1652 FULTON ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5999863.0392 2110926.6558 37.7761933050322 -122.44398414486 (37.7761933050322, -122.44398414486)
23960 136302 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 3362 Clay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5998728.182469999 2115610.0271400004 37.788987820287 -122.44824722563699 (37.788987820287, -122.448247225637)
23996 240380 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 87 14th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6008113.4152 2107953.3802 37.768496570485794 -122.41523324373199 (37.7684965704858, -122.415233243732)
24847 214027 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 130 Baden St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6000768.47308 2094513.82924 37.7311792633149 -122.439675077667 (37.7311792633149, -122.439675077667)
25175 34531 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 635 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/1997 12:00:00 AM 5   Permit Number 38240 5988437.8449 2111647.649 37.7775145896121 -122.483559386935 (37.7775145896121, -122.483559386935)
25229 197350 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 719 Tehama St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6009290.40599 2110497.98819 37.7755495477154 -122.411341904202 (37.7755495477154, -122.411341904202)
25257 240410 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 235 Surrey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6001912.29637 2096185.45895 37.735834211766 -122.43584024433599 (37.735834211766, -122.435840244336)
25288 136307 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1110 Jones St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008614.233080001 2116420.22843 37.7917726483359 -122.41410002782 (37.7917726483359, -122.41410002782)
25889 48457 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 520 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2002 12:00:00 AM 6   Permit Number 45824 6011919.3472 2110495.26684 37.7756891719521 -122.402247516312 (37.7756891719521, -122.402247516312)
26373 140857 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 617 Euclid Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5996458.4312 2113796.5573 37.7838784965198 -122.45596906246 (37.7838784965198, -122.45596906246)
26432 141346 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 463 BRODERICK ST 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   6001145.1037 2110334.7664 37.774641176317104 -122.439506706044 (37.7746411763171, -122.439506706044)
26602 89200 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 3236 Broderick St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/08/2008 12:00:00 AM 4 3x3 Permit Number 51816 5999879.096940001 2119719.87548 37.8003381062886 -122.444560730091 (37.8003381062886, -122.444560730091)
26737 41177 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1555 Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 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 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 4362 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6000898.63467 2103311.26449 37.7553423460847 -122.439855611169 (37.7553423460847, -122.439855611169)
26795 179378 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2016 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6012163.289480001 2088075.41369 37.7141426692356 -122.39982900101299 (37.7141426692356, -122.399829001013)
27483 124544 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1001 Balboa St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5992459.19305 2111330.13563 37.7768760257506 -122.46962520893801 (37.7768760257506, -122.469625208938)
27566 200054 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1800 Lane St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6014879.1353 2094151.956 37.73097868287971 -122.39086633517 (37.7309786828797, -122.39086633517)
27615 47743 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 4201 Clement St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/30/2002 12:00:00 AM 6   Permit Number 45527 5982418.5702 2113061.40286 37.78104415210971 -122.50448647782 (37.7810441521097, -122.50448647782)
27641 240391 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 346 Bocana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6006743.91028 2097051.2853599999 37.7384848564878 -122.41919681678199 (37.7384848564878, -122.419196816782)
27695 214032 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 342 Staples Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997805.133780001 2093821.6600400002 37.729109618413 -122.449869953332 (37.729109618413, -122.449869953332)
27782 136327 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 463 Broadway 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6011305.85301 2118630.68117 37.797992831771495 -122.404942682854 (37.7979928317715, -122.404942682854)
28149 214012 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1479 Funston Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5992097.0420699995 2105377.93896 37.7605119495939 -122.47044439308998 (37.7605119495939, -122.47044439309)
28437 240376 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1367 Natoma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6007185.77161 2107529.7326700003 37.76728115653079 -122.41841184713499 (37.7672811565308, -122.418411847135)
29132 31972 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 100 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/30/1995 12:00:00 AM 5   Permit Number 35372 5995228.46958 2114784.79077 37.786521248530995 -122.46029586964701 (37.786521248531, -122.460295869647)
29223 183217 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 3150 Rivera St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5983341.801 2100199.14 37.7457822914528 -122.50034138058201 (37.7457822914528, -122.500341380582)
29438 31973 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 100 02nd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/30/1995 12:00:00 AM 5   Permit Number 35372 5995224.68838 2114814.58842 37.7866028473263 -122.460311111336 (37.7866028473263, -122.460311111336)
29717 32611 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2926 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1996 12:00:00 AM 0   Permit Number 37076 5985807.8579886 2105043.58172562 37.7592282476447 -122.492170870983 (37.7592282476447, -122.492170870983)
29920 240423 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 5 Penny Ln 5 Back Yard : Yard 13 Tree 1 Private 1     2 Width 2ft   6002449.92079 2096381.9214299999 37.7364041778047 -122.433995506402 (37.7364041778047, -122.433995506402)
30089 122281 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1750 Balboa St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   5990111.6262 2111320.57885 37.7767138255075 -122.477745368245 (37.7767138255075, -122.477745368245)
30486 214028 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 130 Baden St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6000768.83365 2094531.22311 37.7312270433827 -122.43967507764201 (37.7312270433827, -122.439675077642)
30553 240407 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 489 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6003411.63679 2096255.36709 37.7361112200507 -122.430661423705 (37.7361112200507, -122.430661423705)
31206 246759 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 70 Waltham St 3 Front Yard : Yard 7 Tree 1 Private 1     8     6009196.74806 2098886.80636 37.7436626276403 -122.410845655606 (37.7436626276403, -122.410845655606)
31223 184437 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2115 45th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5982295.3096 2100678.1438 37.7470360206297 -122.50399540910401 (37.7470360206297, -122.503995409104)
31386 214044 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 119 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5999274.87025 2093768.2240099998 37.729046879900295 -122.444785134325 (37.7290468799003, -122.444785134325)
31525 214031 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 119 Gennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5997420.89454 2093944.4368 37.7294247417474 -122.45120714359501 (37.7294247417474, -122.451207143595)
31765 214029 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 133 Baden St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   6000729.59206 2094530.6160900001 37.7312231430208 -122.43981069901301 (37.7312231430208, -122.439810699013)
32010 136323 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 360 Broadway 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6011675.19116 2118742.8856099998 37.79832155645679 -122.403672558643 (37.7983215564568, -122.403672558643)
32269 69005 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2087 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 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 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1310 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5992104.55451 2106488.0935299997 37.7635605748926 -122.47049926614099 (37.7635605748926, -122.470499266141)
32809 137686 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2143 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5999343.9567 2111495.7816 37.7777263543907 -122.445820725833 (37.7777263543907, -122.445820725833)
33040 185413 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2300 Sunset Blvd 29 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5985092.6382 2099208.8841 37.7431659316065 -122.49421435006501 (37.7431659316065, -122.494214350065)
33363 240383 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 65 Hermann St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6004954.4402 2108809.15318 37.770668274943205 -122.426220805247 (37.7706682749432, -122.426220805247)
33748 214024 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 118 Baden St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6000768.15588 2094464.1173900003 37.7310427480136 -122.43967261170201 (37.7310427480136, -122.439672611702)
33870 95740 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 61 Ina Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 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)
34018 136313 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1201 Sacramento St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6008832.97743 2116650.20878 37.7924164019518 -122.413359441492 (37.7924164019518, -122.413359441492)
34675 31971 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 100 02nd Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/30/1995 12:00:00 AM 9   Permit Number 35372 5995225.90281 2114852.20624 37.786706205556 -122.46030963631 (37.786706205556, -122.46030963631)
34981 207052 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1266 09th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5993336.085580001 2106823.92199 37.7645538041289 -122.46626423270901 (37.7645538041289, -122.466264232709)
35219 136329 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 447 Broadway 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 Width 3ft   6011341.08824 2118636.57968 37.7980109971731 -122.404821173685 (37.7980109971731, -122.404821173685)
35338 124543 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1001 Balboa St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5992464.59444 2111330.54171 37.776877452914206 -122.46960655362801 (37.7768774529142, -122.469606553628)
35367 197333 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1501 25th St 22 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6014202.148440001 2101967.42619 37.7524007500093 -122.39375364352301 (37.7524007500093, -122.393753643523)
35387 240421 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 5 Penny Ln 3 Back Yard : Yard 13 Tree 1 Private 1     2 Width 2ft   6002440.8921300005 2096392.57557 37.736432919229706 -122.43402748359101 (37.7364329192297, -122.434027483591)
35612 72078 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 167 20th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/14/1984 12:00:00 AM 5     5989583.57132 2114255.42421 37.784741432124 -122.479786850818 (37.784741432124, -122.479786850818)
35987 51788 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 339 Bridgeview Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 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 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 26 Mallorca Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 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)
36052 240426 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 60 Brady St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6006672.38997 2109529.27096 37.772742500096705 -122.42032950031499 (37.7727425000967, -122.420329500315)
36061 214023 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 111 Hearst Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6000598.84895 2094335.4471599997 37.7306798113107 -122.44024870933599 (37.7306798113107, -122.440248709336)
36146 69007 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2115 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/05/1994 12:00:00 AM 0   Permit Number 33008 5982291.49205895 2100703.22551621 37.7471046635524 -122.504010467091 (37.7471046635524, -122.504010467091)
36460 122283 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1750 Balboa St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   5990098.96698 2111321.01529 37.7767142891731 -122.477789191669 (37.7767142891731, -122.477789191669)
36999 122289 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1750 Balboa St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   5990067.41245 2111319.5030799997 37.7767083057233 -122.477898236364 (37.7767083057233, -122.477898236364)
37135 124541 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1001 Balboa St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5992474.53157 2111331.5451 37.7768807822685 -122.46957225145 (37.7768807822685, -122.46957225145)
37930 186236 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1701 Sunset Blvd 47 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984809.6691 2103350.7929 37.75452191688171 -122.495498186629 (37.7545219168817, -122.495498186629)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 203.729ms · Data source: data.sfgov.org