Street_Tree_List

Data source: data.sfgov.org

1,742 rows where qSpecies = 51

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
154 830 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1384 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:15:00 PM 3 5.5x6.5   5981549.5887 2105676.5499 37.7607163481902 -122.506944712409 (37.7607163481902, -122.506944712409)
163 29943 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 242 Broad St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:23:00 PM 3 3x3   5994593.32204167 2088106.90572275 37.7132339790874 -122.460559423837 (37.7132339790874, -122.460559423837)
621 251339 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2230 Ocean Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4 05/28/2012 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
628 251337 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2230 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/26/1996 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
629 251338 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2230 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/28/2012 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
634 251340 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2230 Ocean Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/1996 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
2079 181058 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5258 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 3ft   5999890.56935 2088656.9040700002 37.7150474825255 -122.442289836724 (37.7150474825255, -122.442289836724)
2127 252902 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2375 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/1996 12:00:00 AM   3x3   5992177.0 2094185.0 37.7297836282973 -122.469353126495 (37.7297836282973, -122.469353126495)
2218 114579 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1501 Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/2015 12:00:00 AM 3 3x3   6002950.36974 2121305.2817599997 37.8048659859314 -122.43404631360701 (37.8048659859314, -122.434046313607)
2333 253025 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1754 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/11/2017 12:00:00 AM 3     5993444.58369 2103545.63859 37.7555587516047 -122.465650780273 (37.7555587516047, -122.465650780273)
2511 246852 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 300 Broderick St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6001238.428669999 2109976.67902 37.7736632691848 -122.43915820668998 (37.7736632691848, -122.43915820669)
2885 205488 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1430 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 3ft   5990862.44739 2105654.74875 37.761200533507 -122.474734450646 (37.761200533507, -122.474734450646)
2988 118173 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3221 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/13/2008 12:00:00 AM 2 Width 3ft   5985542.20124 2111089.15517 37.7758121588594 -122.49353507754299 (37.7758121588594, -122.493535077543)
3661 253519 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 701 22nd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 3ft   6015696.1864 2103920.99342 37.7578477430893 -122.38872333331899 (37.7578477430893, -122.388723333319)
3809 95203 Planning Code 138.1 required 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 314 Walnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 3x3 Permit Number 769992 5998598.6333800005 2115400.1597599997 37.7884041728517 -122.44868032474 (37.7884041728517, -122.44868032474)
4081 102392 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 30X Harriet St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6010436.41014 2111752.09711 37.7790572463352 -122.40746601596202 (37.7790572463352, -122.407466015962)
4320 178028 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 398x Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 09:59:00 AM 3 Width 3ft   6004185.0 2091264.0 37.7224498233553 -122.427632084441 (37.7224498233553, -122.427632084441)
4352 178029 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 398x Athens St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 10:03:00 AM 3 Width 3ft   6003930.0 2091029.0 37.7217901378795 -122.428496818895 (37.7217901378795, -122.428496818895)
4422 253158 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 700 Avalon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 07:47:00 AM 3 3x3   6004446.0 2092174.0 37.7249632430066 -122.426794641082 (37.7249632430066, -122.426794641082)
4434 253623 Planning Code 138.1 required 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1331 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 12:00:00 AM 3 3x3 Permit Number 778744 5983976.422619999 2106100.27997 37.7620224120695 -122.498582815109 (37.7620224120695, -122.498582815109)
4637 160693 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 700 Russia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/2017 03:34:00 PM 3 Width 0ft   6003044.40323 2089957.59001 37.7187981275985 -122.431481646786 (37.7187981275985, -122.431481646786)
4672 160512 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 718 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/2017 03:07:00 PM 3 Width 0ft   6001887.21385 2089766.7884 37.7182085743334 -122.43546794121 (37.7182085743334, -122.43546794121)
4720 160434 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 France Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/24/2017 12:17:00 PM 3 Width 0ft   6002057.78511 2089843.09143 37.7184277715106 -122.434883803643 (37.7184277715106, -122.434883803643)
4732 160902 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 687 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/24/2017 03:13:00 PM 3 Width 0ft   6002042.96964 2089934.48855 37.718677886450294 -122.43494154733101 (37.7186778864503, -122.434941547331)
4745 253432 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 501X Madrid St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/25/2017 04:09:00 PM 3 3x3   6002703.0 2090930.0 37.721448793681 -122.43273116699801 (37.721448793681, -122.432731166998)
4758 161382 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 523 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/25/2017 03:54:00 PM 3 Width 0ft   6002614.99011 2090841.7835900001 37.721201579268495 -122.43302909312901 (37.7212015792685, -122.433029093129)
4788 253430 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 501X Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/25/2017 04:04:00 PM 3 3x3   6002703.0 2090930.0 37.721448793681 -122.43273116699801 (37.721448793681, -122.432731166998)
4805 253431 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 501X Madrid St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/25/2017 04:07:00 PM 3 3x3   6002703.0 2090930.0 37.721448793681 -122.43273116699801 (37.721448793681, -122.432731166998)
4984 44099 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1880 Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/02/2015 12:00:00 AM 3 3x3 Permit Number 774618 6003969.398019999 2119063.44467 37.798768262294395 -122.43035980995701 (37.7987682622944, -122.430359809957)
5559 98004 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1908 Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/20/2015 12:00:00 AM 14 5x5 Permit Number 775450 6003753.55269 2119031.9849799997 37.79866965343071 -122.43110445762301 (37.7986696534307, -122.431104457623)
5769 39272 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2740 Green St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/15/2015 12:00:00 AM 3   Permit Number 774808 5999918.5789 2117802.13868 37.7950747637355 -122.44428621834999 (37.7950747637355, -122.44428621835)
5807 47379 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4453 Manzanita Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/13/2002 12:00:00 AM     Permit Number 45296          
5982 39271 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2740 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/03/2015 12:00:00 AM 3   Permit Number 774808 5999943.4858099995 2117805.21945 37.7950846436855 -122.444200258451 (37.7950846436855, -122.444200258451)
6209 91354 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2131 Leavenworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/07/2015 12:00:00 AM 3 3x3 Permit Number 52063 6007623.63084 2119707.2305900003 37.8007422490107 -122.417760608464 (37.8007422490107, -122.417760608464)
6520 121576 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3553-3555 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   5997856.717119999 2115116.32362 37.787582382260396 -122.451226746117 (37.7875823822604, -122.451226746117)
6649 114581 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1501 Beach St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/2015 12:00:00 AM 3 3x3   6002967.5258 2121305.9196 37.8048687108976 -122.433986988903 (37.8048687108976, -122.433986988903)
6718 97922 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2939 Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6000509.433540001 2118403.315 37.7967591273891 -122.442284956098 (37.7967591273891, -122.442284956098)
6827 100292 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3701 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6003061.81659 2121064.97367 37.804212487284005 -122.43364345509701 (37.804212487284, -122.433643455097)
7392 61776 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2939 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/1993 12:00:00 AM 6 3x3   6000507.69204 2118417.15605 37.7967970320012 -122.44229197620001 (37.7967970320012, -122.4422919762)
7427 83207 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1630 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3   Permit Number 772967 6005062.56265 2119560.0197 37.8001935906169 -122.426612484272 (37.8001935906169, -122.426612484272)
8183 112515 Section 143 8 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2646 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6000218.93903 2118886.7143900003 37.7980698532985 -122.443324869154 (37.7980698532985, -122.443324869154)
8240 111918 Section 143 8 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 41 Toledo Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2015 12:00:00 AM 3 3x3 Permit Number 773012 6001705.38657 2120044.83908 37.801334410325104 -122.438264349848 (37.8013344103251, -122.438264349848)
8700 94740 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3208 Pierce St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2010 12:00:00 AM 3 3x3 Permit Number 53872 6001386.25296 2119488.63139 37.799789054867794 -122.439328800002 (37.7997890548678, -122.439328800002)
8887 97923 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2939 Divisadero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6000511.871719999 2118390.4696 37.7967239962744 -122.442275596851 (37.7967239962744, -122.442275596851)
8919 49958 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1635 REVISED Gough St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/06/2003 12:00:00 AM     Permit Number 46712 6005318.44165545 2115314.81375181 37.788551790903604 -122.425424765275 (37.7885517909036, -122.425424765275)
8949 38494 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1345 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/11/2015 12:00:00 AM 3 3x3 Permit Number 774878 6006577.84973 2118679.48452 37.797861412034294 -122.42130642757401 (37.7978614120343, -122.421306427574)
9112 122861 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3000X Alemany Blvd 8 Median : Cutout 11 Tree 1 DPW 2   12/08/2016 01:43:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9186 10962 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1431 Hudson Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/04/1998 12:00:00 AM 3 3X4   6016563.2925523 2096760.0557493 37.7382333059102 -122.385225528118 (37.7382333059102, -122.385225528118)
9209 122858 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3000X Alemany Blvd 5 Median : Cutout 11 Tree 1 DPW 2   12/08/2016 01:48:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9268 122855 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3000X Alemany Blvd 2 Median : Cutout 11 Tree 1 DPW 2   12/08/2016 01:30:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9272 122860 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3000X Alemany Blvd 7 Median : Cutout 11 Tree 1 DPW 2   12/08/2016 01:54:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9280 122859 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3000X Alemany Blvd 6 Median : Cutout 11 Tree 1 DPW 2   12/08/2016 01:46:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9291 122856 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3000X Alemany Blvd 3 Median : Cutout 11 Tree 1 DPW 2   12/08/2016 01:13:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9327 122854 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3000X Alemany Blvd 1 Median : Cutout 11 Tree 1 DPW 2   12/08/2016 01:40:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9354 122862 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3000X Alemany Blvd 9 Median : Cutout 11 Tree 1 DPW 2   12/08/2016 01:57:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9396 27585 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2295X Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/09/2000 12:00:00 AM 6 3X3   6009694.1199724 2103987.6509207003 37.7576962911825 -122.40948577896401 (37.7576962911825, -122.409485778964)
9406 122857 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3000X Alemany Blvd 4 Median : Cutout 11 Tree 1 DPW 2   12/08/2016 01:17:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9415 15943 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5810X MISSION ST 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 4X4   5997175.0 2086632.0 37.7093324147693 -122.451529986796 (37.7093324147693, -122.451529986796)
9493 29077 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2275 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/08/2006 12:00:00 AM 5 3x3   6009685.8295 2104144.07057 37.7581253197533 -122.40952549043001 (37.7581253197533, -122.40952549043)
9563 108596 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 36 Bronte St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   1 3x3 Permit Number 770949 6009339.44395 2097251.26276 37.7391797819084 -122.410236794344 (37.7391797819084, -122.410236794344)
9629 173614 Planning Code 138.1 required 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2955 20th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1   12/12/2016 12:00:00 AM 3 3x6 Permit Number 776469 5990236.78382 2095590.4495400002 37.7335303227244 -122.476163213901 (37.7335303227244, -122.476163213901)
9631 173613 Planning Code 138.1 required 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2955 20th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1   12/12/2016 12:00:00 AM 3 3x6 Permit Number 776469 5990236.78382 2095590.4495400002 37.7335303227244 -122.476163213901 (37.7335303227244, -122.476163213901)
9705 110500 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 900X JESSIE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6007667.0 2110717.0 37.7760597176113 -122.416973193872 (37.7760597176113, -122.416973193872)
9707 110499 Section 143 8 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 900X JESSIE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6007667.0 2110717.0 37.7760597176113 -122.416973193872 (37.7760597176113, -122.416973193872)
9708 110501 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 900X JESSIE ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6007667.0 2110717.0 37.7760597176113 -122.416973193872 (37.7760597176113, -122.416973193872)
9732 106018 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5285 DIAMOND HEIGHTS BLVD 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/22/2016 07:34:00 AM 3 3x3   6001339.5 2099171.1 37.7439995285584 -122.438034420154 (37.7439995285584, -122.438034420154)
9823 63407 Planning Code 138.1 required 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2125 Broderick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/2016 12:00:00 AM 3 3x3 Permit Number 770314 6000344.0086 2116075.3402400003 37.790357690994504 -122.442690122255 (37.7903576909945, -122.442690122255)
10028 161764 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 142 Newton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/23/2017 12:00:00 AM 3 3x3 Permit Number 779227 6000990.7389 2087787.91218 37.7127240669257 -122.43842496696001 (37.7127240669257, -122.43842496696)
10621 52188 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 76 Camona Av 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2005 12:00:00 AM     Permit Number 48379          
10663 110033 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 206 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/19/2015 12:00:00 AM 3 3x3 Permit Number 775206 6003103.36951 2092214.97197 37.724999739126794 -122.431438884895 (37.7249997391268, -122.431438884895)
10929 28307 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1818 San Jose Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/05/2003 12:00:00 AM 3     6000526.74804 2093584.98162 37.7286151010044 -122.440444169789 (37.7286151010044, -122.440444169789)
11064 25312 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 163 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/1996 12:00:00 AM 3 3X3   6000515.96101 2091667.5202400002 37.7233495775944 -122.440344004183 (37.7233495775944, -122.440344004183)
11259 25305 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 300 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/1996 12:00:00 AM 12 3X3   5999583.38871 2091602.23425 37.7231171747905 -122.443563033915 (37.7231171747905, -122.443563033915)
11646 27701 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1136 Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/26/2000 12:00:00 AM 6     6008329.0437900005 2093834.9235 37.729742566663106 -122.413488762206 (37.7297425666631, -122.413488762206)
11707 28306 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1818 San Jose Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/05/2003 12:00:00 AM 3     6000533.35164 2093598.6883900003 37.7286531126447 -122.440422323457 (37.7286531126447, -122.440422323457)
11724 25307 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 355 Ocean Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/07/1996 12:00:00 AM 6 3X3   5999438.14042 2091535.09661 37.7229245454182 -122.444060305044 (37.7229245454182, -122.444060305044)
12132 99909 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 210 Gaven St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/24/2014 12:00:00 AM 3 3x3 Permit Number 774553 6009399.78383 2095020.3189400001 37.7330574731105 -122.40987072487499 (37.7330574731105, -122.409870724875)
12240 44475 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 275 Harvard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/26/2001 12:00:00 AM 8 3x3 Permit Number 43789 6006290.74635 2092615.37122 37.726279281939895 -122.42044886282301 (37.7262792819399, -122.420448862823)
12406 27090 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 725 Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 2X3   6006149.91754 2093595.5123 37.7289625981285 -122.42100526258801 (37.7289625981285, -122.421005262588)
12419 981 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1604 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/15/2003 12:00:00 AM 6 3X3   6001745.7594099995 2092854.52102 37.7266787581039 -122.436177732017 (37.7266787581039, -122.436177732017)
12427 35723 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 80 Dartmouth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/24/2014 12:00:00 AM 3   Permit Number 772467 6008403.94814 2093755.2917799999 37.729528120608 -122.41322417987499 (37.729528120608, -122.413224179875)
12474 28305 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1818 San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/05/2003 12:00:00 AM 3     6000543.0489 2093613.5897099997 37.7286945803894 -122.440389867794 (37.7286945803894, -122.440389867794)
12988 904 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1179 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/22/2016 12:00:00 AM 3 2X2   6003419.3756099995 2094263.29224 37.7306418725253 -122.430492572378 (37.7306418725253, -122.430492572378)
13082 15846 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5256 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/11/2015 12:00:00 AM 6 3x3 Permit Number 775938 5999899.043409999 2088666.4410599999 37.7150741519211 -122.442261231071 (37.7150741519211, -122.442261231071)
13358 79034 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 10 Moss St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/09/2002 12:00:00 AM 1 2.5x4   6010138.62156 2111398.24518 37.7780689795412 -122.40847122506399 (37.7780689795412, -122.408471225064)
13359 99591 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1855X Evans Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2012 12:00:00 AM 10 3x3 Permit Number 769738 6014314.47679 2099474.93569 37.745563139741996 -122.39319079741301 (37.745563139742, -122.393190797413)
13559 106005 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 59 Reddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   3 3x3   6013632.51665 2093922.487 37.7302793593954 -122.395160068985 (37.7302793593954, -122.395160068985)
13583 100891 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 91 Welsh St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6013606.47382 2111993.91964 37.7798981618967 -122.396516359044 (37.7798981618967, -122.396516359044)
13779 101367 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 551 Minna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/17/2012 12:00:00 AM 1 3x5 Permit Number 769423 6009889.66847 2111940.62383 37.779544278688604 -122.409370733267 (37.7795442786886, -122.409370733267)
13984 21894 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2068 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/01/2003 12:00:00 AM 3 2X3   6015677.89854 2105976.47682 37.7634906462863 -122.388930084758 (37.7634906462863, -122.388930084758)
14003 100882 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 91 Welsh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6013366.225459999 2111763.75465 37.7792528084154 -122.397331345366 (37.7792528084154, -122.397331345366)
14019 95844 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 152 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/2011 12:00:00 AM 3 4x4 Permit Number 767916 6010308.44062 2112179.38157 37.7802233055096 -122.40793885609502 (37.7802233055096, -122.407938856095)
14258 100759 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 362 Brannan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3x3   6014440.04423 2112282.11717 37.780735840838396 -122.39365282322201 (37.7807358408384, -122.393652823222)
14268 12235 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1574 La Salle Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/27/1997 12:00:00 AM 6 3X3   6015715.635319999 2096065.54177 37.736279382483204 -122.38810787958201 (37.7362793824832, -122.388107879582)
14420 27150 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1735 Silver Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6011122.20395 2095139.1072200001 37.73348002049129 -122.403924187157 (37.7334800204913, -122.403924187157)
14587 100888 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 91 Welsh St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6013550.27415 2111938.66795 37.7797433256341 -122.396706905611 (37.7797433256341, -122.396706905611)
14663 28516 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 117 06th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 4x4   6010207.243969999 2112381.64795 37.7807730152091 -122.40830321374901 (37.7807730152091, -122.408303213749)
14801 22531 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 6619 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/2015 08:00:00 AM 3 3X3   6012836.07271 2089639.80613 37.7184756630977 -122.397613243265 (37.7184756630977, -122.397613243265)
14912 61587 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 835 Wisconsin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/31/2010 12:00:00 AM 12 6x4.5 Permit Number 53711 6012777.55952 2103581.4940400003 37.7567533616886 -122.39879340469999 (37.7567533616886, -122.3987934047)
15030 101775 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1700 Yosemite Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   10 3x3 Permit Number 19103 6014052.75296 2093112.8912 37.728079734566606 -122.393650601914 (37.7280797345666, -122.393650601914)

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 913.176ms · Data source: data.sfgov.org