Street_Tree_List

Data source: data.sfgov.org

1,742 rows where qSpecies = 51 sorted by Longitude

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
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          
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          
15164 51415 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 7121 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/14/2004 12:00:00 AM     Permit Number 47739          
58110 96111 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 458 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2011 12:00:00 AM 2 3x3 Permit Number 767766 5981315.73412 2112558.6605700003 37.7795988416807 -122.508264340954 (37.7795988416807, -122.508264340954)
88120 117006 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2131x 48TH AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/03/2016 12:00:00 AM 3 3x3 Permit Number 778271 5981288.0 2100567.0 37.7466715647644 -122.50747029290599 (37.7466715647644, -122.507470292906)
108687 117004 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2131x 48TH AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/03/2016 12:00:00 AM 3 3x3 Permit Number 778271 5981288.0 2100567.0 37.7466715647644 -122.50747029290599 (37.7466715647644, -122.507470292906)
122779 117005 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2131x 48TH AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/03/2016 12:00:00 AM 3 3x3 Permit Number 778271 5981288.0 2100567.0 37.7466715647644 -122.50747029290599 (37.7466715647644, -122.507470292906)
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)
140053 34715 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 827 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/08/2003 12:00:00 AM     Permit Number 46400 5981665.27623832 2110104.83266166 37.7728819439334 -122.506873082789 (37.7728819439334, -122.506873082789)
33462 68846 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 731 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/09/1993 12:00:00 AM 9   Permit Number 32807 5982263.55129 2110779.79011 37.774770393997706 -122.50485363813101 (37.7747703939977, -122.504853638131)
106958 111435 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3498x SANTIAGO ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/2016 12:00:00 AM 12 3x3 Permit Number 776176 5982094.0 2099503.0 37.7437975622932 -122.50460445512199 (37.7437975622932, -122.504604455122)
109320 111436 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3498x SANTIAGO ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/2016 12:00:00 AM   3x3 Permit Number 776176 5982094.0 2099503.0 37.7437975622932 -122.50460445512199 (37.7437975622932, -122.504604455122)
127503 111437 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3498x SANTIAGO ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/2016 12:00:00 AM   3x3 Permit Number 776176 5982094.0 2099503.0 37.7437975622932 -122.50460445512199 (37.7437975622932, -122.504604455122)
31927 117672 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 7751 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5982922.15587 2112497.69809 37.77952599164671 -122.502702614984 (37.7795259916467, -122.502702614984)
163820 117670 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 7751 Geary Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 2ft   5982957.689809999 2112492.79061 37.779514605287794 -122.502579326611 (37.7795146052878, -122.502579326611)
180856 72281 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 730 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/1996 12:00:00 AM 8     5982929.242880001 2110803.7534 37.7748753302021 -122.502552686167 (37.7748753302021, -122.502552686167)
67644 70573 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 862 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/1996 12:00:00 AM 11     5982961.78283 2109923.12422 37.772459289826 -122.502374937437 (37.772459289826, -122.502374937437)
124300 115233 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 839 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/20/2016 12:00:00 AM     Permit Number 775531 5983204.4 2110077.1 37.772896315318 -122.501547107446 (37.772896315318, -122.501547107446)
33703 117914 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 839 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5983220.24264 2110063.17362 37.7728590079713 -122.501491276363 (37.7728590079713, -122.501491276363)
24619 41597 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 552 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/07/2007 12:00:00 AM 5 3x3 Permit Number 49968 5983505.71138 2112036.0358 37.77829267778829 -122.500649732794 (37.7782926777883, -122.500649732794)
45764 117863 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 798 40th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5983563.66024 2110432.70706 37.7738938035198 -122.50033069971902 (37.7738938035198, -122.500330699719)
163695 117668 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4826 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5983640.52001 2111755.82857 37.7775312233534 -122.500162667158 (37.7775312233534, -122.500162667158)
101853 89576 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4825 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5983661.38159 2111702.27488 37.7773854048537 -122.500086541243 (37.7773854048537, -122.500086541243)
97981 89577 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4801X Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5983707.84723 2111706.4900599997 37.7773997054666 -122.49992611559901 (37.7773997054666, -122.499926115599)
109594 89582 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4701X Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5984008.478209999 2111715.2739 37.777441461332394 -122.498886799858 (37.7774414613324, -122.498886799858)
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)
141428 89585 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4645 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5984165.0432400005 2111720.8088599998 37.777465840754296 -122.498345607104 (37.7774658407543, -122.498345607104)
123217 89589 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4645 Anza St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5984245.3294400005 2111722.52512 37.777475260664794 -122.498068001639 (37.7774752606648, -122.498068001639)
113986 115182 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 315 Lakeshore Dr 1 Median : Cutout 11 Tree 1 Private 1   01/15/2016 12:00:00 AM     Permit Number 775158 5983956.6 2095109.9 37.7318446842931 -122.497839799214 (37.7318446842931, -122.497839799214)
78607 89592 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4617 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5984322.41803 2111726.32769 37.777490220874 -122.497801611618 (37.777490220874, -122.497801611618)
115076 89593 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4601 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5984340.25628 2111726.55221 37.7774918830532 -122.497739920719 (37.7774918830532, -122.497739920719)
83556 90922 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4601 Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/10/2008 12:00:00 AM 3 3x3   5984359.943030001 2111727.94801 37.777496869554206 -122.497671921843 (37.7774968695542, -122.497671921843)
115257 89596 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4433 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5984874.01368 2111746.5723599996 37.7775781275582 -122.495894981455 (37.7775781275582, -122.495894981455)
85908 89598 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4417 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5984943.344959999 2111748.4465099997 37.777587333707 -122.49565528309999 (37.777587333707, -122.4956552831)
113984 89599 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4411 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5984967.81227 2111748.98363 37.7775902412553 -122.495570683326 (37.7775902412553, -122.495570683326)
31345 54056 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 839 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/21/1972 12:00:00 AM 12   Permit Number 9778 5985079.18018 2110144.91058 37.7731924364746 -122.495067118327 (37.7731924364746, -122.495067118327)
164458 81965 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 838 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2007 12:00:00 AM 4 3x3 Permit Number 49958 5985125.36626 2110132.785 37.773161846833204 -122.494906462717 (37.7731618468332, -122.494906462717)
36732 54017 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 848 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2007 12:00:00 AM 7 3x3 Permit Number 49959 5985128.25093 2110100.49047 37.7730733441171 -122.494894102815 (37.7730733441171, -122.494894102815)
96304 89600 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4335 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5985191.65818 2111758.32829 37.777629004290205 -122.494797025483 (37.7776290042902, -122.494797025483)
145364 109041 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1638 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/22/2015 12:00:00 AM 3 3x3 Permit Number 773601 5985043.8 2104034.4 37.7564126199144 -122.49473890921699 (37.7564126199144, -122.494738909217)
149632 118249 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 735 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5985364.18401 2110859.1562900003 37.7751702324246 -122.49413391969101 (37.7751702324246, -122.494133919691)
116695 89605 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4249X Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5985413.92105 2111766.13498 37.7776634467966 -122.49402872965099 (37.7776634467966, -122.494028729651)
134090 65079 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3255 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/14/1989 12:00:00 AM 3   Permit Number 27043 5985440.9852599995 2111085.56905 37.7757963909815 -122.49388493990101 (37.7757963909815, -122.493884939901)
95005 90923 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4239 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/10/2008 12:00:00 AM 3 3x3   5985467.79642 2111768.32537 37.7776726131943 -122.493842520581 (37.7776726131943, -122.493842520581)
132731 118170 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3247 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5985457.87188 2111086.97623 37.77580124268229 -122.49382662937599 (37.7758012426823, -122.493826629376)
58219 118168 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3238 Balboa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5985471.03875 2111143.13059 37.775956196854 -122.493785221511 (37.775956196854, -122.493785221511)
59804 118171 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3239 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5985480.725380001 2111087.37265 37.7758036681834 -122.493747603691 (37.7758036681834, -122.493747603691)
45388 118167 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3238 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5985487.69599 2111143.2321 37.775957450089 -122.493727608092 (37.775957450089, -122.493727608092)
41342 118172 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3239 Balboa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5985496.239630001 2111086.82124 37.7758030618006 -122.493693896102 (37.7758030618006, -122.493693896102)
121920 89606 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4227 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5985517.60906 2111769.02888 37.777677459076 -122.493670256038 (37.777677459076, -122.493670256038)
100815 89607 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4225 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5985540.508119999 2111770.83497 37.777683757686894 -122.493591174643 (37.7776837576869, -122.493591174643)
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)
78696 89608 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4215 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5985569.57732 2111771.09823 37.7776861810077 -122.493490635217 (37.7776861810077, -122.493490635217)
141726 89609 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4201X Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5985583.60476 2111772.38766 37.7776905419571 -122.493442205243 (37.7776905419571, -122.493442205243)
102715 49568 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1219@ LINCOLN 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/06/2003 12:00:00 AM     Permit Number 46453 5985494.10343232 2106914.89929476 37.764348018167 -122.4933938427 (37.764348018167, -122.4933938427)
84204 89610 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4201X Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/05/2015 07:01:00 AM 3 3x3   5985601.86481 2111772.70436 37.7776924796275 -122.49337906174401 (37.7776924796275, -122.493379061744)
143779 90972 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3227 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 11/13/2008 12:00:00 AM 3 3x3   5985599.860262999 2111098.856457 37.7758421685745 -122.49333633811001 (37.7758421685745, -122.49333633811)
122916 51509 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 563 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/13/2005 12:00:00 AM     Permit Number 47817 5985629.08933557 2112062.08741907 37.7784886350537 -122.493306209382 (37.7784886350537, -122.493306209382)
95797 114729 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1930 35TH AVE 1 Front Yard : Cutout 8 Tree 1 Private 1   12/03/2015 12:00:00 AM   4x4   5985421.0 2102058.0 37.7510080399178 -122.493288836187 (37.7510080399178, -122.493288836187)
95940 52780 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1360@ JUDAH 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/24/2006 12:00:00 AM     Permit Number 48824 5985578.993883401 2105959.75073826 37.7617304118264 -122.493029870185 (37.7617304118264, -122.493029870185)
106496 109917 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1627 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/12/2015 12:00:00 AM 3 3x3 Permit Number 775114 5985575.9 2104128.7 37.7567026728441 -122.492905692842 (37.7567026728441, -122.492905692842)
109701 85066 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1811 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2007 12:00:00 AM     Permit Number 49432 5985617.8 2102880.2 37.753277085239894 -122.49266884038299 (37.7532770852399, -122.492668840383)
120341 89613 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4127 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5985830.11482 2111781.78124 37.777730750542 -122.49259014689 (37.777730750542, -122.49259014689)
155053 45593 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1774 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/2001 12:00:00 AM 0   Permit Number 44329 5985674.90223921 2103150.11186705 37.7540215279835 -122.492491247628 (37.7540215279835, -122.492491247628)
108571 95509 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4   02/19/2015 02:37:00 PM 3 3x3   5985988.58257 2112092.73248 37.7785937981587 -122.492064860632 (37.7785937981587, -122.492064860632)
112142 95511 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4   02/19/2015 02:32:00 PM 3 3x3   5985988.37339 2112068.78219 37.7785280252799 -122.492063820389 (37.7785280252799, -122.492063820389)
139550 95513 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     6 3x3   5985988.88946 2112008.2856099997 37.7783619491242 -122.49205757976002 (37.7783619491242, -122.49205757976)
120188 95514 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4   02/19/2015 02:29:00 PM 3 3x3   5985991.7561 2111987.56369 37.7783052202186 -122.492046137036 (37.7783052202186, -122.492046137036)
96578 95515 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     6 3x3   5985992.57608 2111969.58011 37.7782558903759 -122.492041976045 (37.7782558903759, -122.492041976045)
101527 95518 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     5 3x3   5985992.056890001 2111902.81718 37.778072548088495 -122.49203885528601 (37.7780725480885, -122.492038855286)
107004 95516 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     5 3x3   5985994.45155 2111944.6872400003 37.778187651292896 -122.492033654948 (37.7781876512929, -122.492033654948)
142332 95517 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     10 3x3   5985993.99278 2111923.13747 37.778128454962 -122.49203365493601 (37.778128454962, -122.492033654936)
79513 95519 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     5 3x3   5985993.74648 2111883.3180400003 37.7780191077803 -122.49203157445 (37.7780191077803, -122.49203157445)
96802 95494 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     3 3x3   5986000.13497 2111717.2940599998 37.7775636267397 -122.491997248036 (37.7775636267397, -122.491997248036)
93377 95497 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     6 3x3   5985999.2312900005 2111660.71954 37.777408236422296 -122.491996207782 (37.7774082364223, -122.491996207782)
124692 95484 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 15 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     6 3x3   5986002.98697 2111639.37953 37.777349862368496 -122.491981644298 (37.7773498623685, -122.491981644298)
88350 62378 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/14/1985 12:00:00 AM 24   Permit Number 22527 5986003.033530001 2111613.32749 37.7772783336166 -122.491979564694 (37.7772783336166, -122.491979564694)
123561 95485 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     10 3x3   5986006.6183 2111569.83262 37.777159118639496 -122.49196396094601 (37.7771591186395, -122.491963960946)
117880 95486 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     3 3x3   5986007.39345 2111549.75354 37.777104032517705 -122.49195980083701 (37.7771040325177, -122.491959800837)
91382 95488 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     6 3x3   5986007.7101 2111508.12486 37.776989750535 -122.491955639862 (37.776989750535, -122.491955639862)
111692 95487 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     3 3x3   5986008.46306 2111529.3689900003 37.777048124873296 -122.49195459962401 (37.7770481248733, -122.491954599624)
140987 95489 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     6 3x3   5986007.8525 2111486.5622099997 37.7769305539658 -122.49195355936199 (37.7769305539658, -122.491953559362)
141798 95490 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     3 3x3   5986007.65609 2111463.21002 37.7768664240251 -122.49195251911199 (37.7768664240251, -122.491952519112)
94030 95491 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 600X 32nd Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4     3 3x3   5986009.30138 2111441.61533 37.776807227327396 -122.491945237383 (37.7768072273274, -122.491945237383)
50296 68581 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1526 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/21/2016 12:00:00 AM 0   Permit Number 775949 5985927.704093 2104831.6030171 37.7586532178591 -122.491740786234 (37.7586532178591, -122.491740786234)
111058 117123 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2550 34TH AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/2016 12:00:00 AM 3 3x3   5985875.0 2097864.0 37.7395189911199 -122.491410221624 (37.7395189911199, -122.491410221624)
127315 117122 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2550 34TH AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/2016 12:00:00 AM 3 3x3   5985875.0 2097864.0 37.7395189911199 -122.491410221624 (37.7395189911199, -122.491410221624)
82941 109034 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2042 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772948 5986068.5 2101324.0 37.749030526651396 -122.490995740125 (37.7490305266514, -122.490995740125)
97698 9253 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 6500X Geary Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/12/2011 12:00:00 AM 2 2X3   5986722.32109 2112597.81428 37.7800234720171 -122.489563763122 (37.7800234720171, -122.489563763122)
46618 47195 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 371 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2002 12:00:00 AM 6   Permit Number 45155 5986820.372830001 2113443.94443 37.7823524278539 -122.489286791849 (37.7823524278539, -122.489286791849)
142087 24688 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 6509 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/12/2011 12:00:00 AM 3 3X3   5986810.4488699995 2112493.43144 37.7797420110575 -122.48925121679501 (37.7797420110575, -122.489251216795)
68356 47196 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 430 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2002 12:00:00 AM 7   Permit Number 45156 5986884.14198 2113014.7647599997 37.781177745194995 -122.48903462038 (37.781177745195, -122.48903462038)
46320 42868 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2649 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/03/2000 12:00:00 AM 0   Permit Number 42791 5986726.28385176 2097377.23824555 37.738232180805895 -122.48843112739999 (37.7382321808059, -122.4884311274)
144382 9239 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 6406 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/27/1996 12:00:00 AM 3 3X3   5987099.50219 2112606.70022 37.780069883306396 -122.488259594393 (37.7800698833064, -122.488259594393)
159217 47193 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 383 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2002 12:00:00 AM 8   Permit Number 45152 5987133.5813 2113398.4948 37.7822459140534 -122.488199902231 (37.7822459140534, -122.488199902231)
188081 47192 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 383 28th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2002 12:00:00 AM 8   Permit Number 45152 5987134.96931 2113380.92602 37.782197756171705 -122.488193808962 (37.7821977561717, -122.488193808962)
71898 119960 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 426 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5987190.151740001 2113069.49972 37.7813458874945 -122.487980015327 (37.7813458874945, -122.487980015327)
44344 67959 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 800 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/22/1993 12:00:00 AM 7   Permit Number 31679 5987285.58651 2110436.7954700002 37.774122792273204 -122.48745641247 (37.7741227922732, -122.48745641247)
98139 64711 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2609 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2015 12:00:00 AM     Permit Number 775401 5987378.59458857 2114604.15746818 37.7855706107791 -122.48744086841299 (37.7855706107791, -122.487440868413)
32706 120106 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2651 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5987317.09594 2110472.8163099997 37.7742235329464 -122.487350063639 (37.7742235329464, -122.487350063639)

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