Street_Tree_List

Data source: data.sfgov.org

505 rows where qSpecies = 27 sorted by qLegalStatus

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
3187 207331 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 432 Congo St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1   07/05/2002 12:00:00 AM 8 Width 8ft Permit Number 45704 6000124.74065 2095150.49618 37.7328907415174 -122.441946248045 (37.7328907415174, -122.441946248045)
11989 26837 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 1100X Duncan St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 2x2            
17282 27708 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 720 Shields St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 2X3   5992097.16127 2089870.17428 37.717931565159795 -122.46931519623301 (37.7179315651598, -122.469315196233)
24450 45488 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 2934 21st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/19/2001 12:00:00 AM 4   Permit Number 44266 5990009.93985 2095708.66875 37.733841765574205 -122.476956105249 (37.7338417655742, -122.476956105249)
31691 37790 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 310 Hamilton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/06/1998 12:00:00 AM 6   Permit Number 40120 6009327.0324 2092792.3248 37.7269357978389 -122.40996501967899 (37.7269357978389, -122.409965019679)
33948 37792 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 310 Hamilton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/06/1998 12:00:00 AM 5   Permit Number 40120 6009317.62312 2092827.34387 37.727031425442 -122.410000018602 (37.727031425442, -122.410000018602)
34562 34814 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 485 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/10/1998 12:00:00 AM 5   Permit Number 38705 5983755.240019999 2112575.55408 37.779788683805705 -122.49982642326599 (37.7797886838057, -122.499826423266)
35186 45487 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 2934 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/19/2001 12:00:00 AM 3   Permit Number 44266 5990011.75655 2095686.43247 37.7337808158159 -122.476948200207 (37.7337808158159, -122.476948200207)
35444 31932 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 1210 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1995 12:00:00 AM 7   Permit Number 35348 5981508.8658 2106816.8909 37.763844998562206 -122.507170151225 (37.7638449985622, -122.507170151225)
36376 37433 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 1419 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/17/1998 12:00:00 AM 6   Permit Number 39907 5991189.91551 2110613.34906 37.7748344845766 -122.473963672883 (37.7748344845766, -122.473963672883)
43818 68271 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 432 Holyoke St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2014 12:00:00 AM 8   Permit Number 771022 6009763.0481199995 2092384.22175 37.7258396600504 -122.408428941659 (37.7258396600504, -122.408428941659)
47695 41753 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 1644 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2000 12:00:00 AM 4   Permit Number 42182 6006856.27196 2116746.53055 37.7925696967985 -122.42020574908899 (37.7925696967985, -122.420205749089)
47768 35124 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/1998 12:00:00 AM 6   Permit Number 38659 6001796.31519 2089542.9326900002 37.717588753495 -122.43576613121701 (37.717588753495, -122.435766131217)
47861 62489 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 25 Otsego Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/25/1986 12:00:00 AM 8   Permit Number 22660 6000933.610719999 2092903.74949 37.726767752305605 -122.43898882388399 (37.7267677523056, -122.438988823884)
48088 31195 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 260 Saint Charles Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/22/1995 12:00:00 AM 6   Permit Number 34888 5992024.42182 2086737.21442 37.7093250109181 -122.469338707216 (37.7093250109181, -122.469338707216)
52623 40627 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 1118 De Haro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/1999 12:00:00 AM 7   Permit Number 41628 6012181.11201 2103196.50544 37.755663016446 -122.40082910469 (37.755663016446, -122.40082910469)
52741 92437 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 1974 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/30/2009 12:00:00 AM 1 3x3 Permit Number 52827 5982618.164 2101679.0263 37.7498031456316 -122.502953108098 (37.7498031456316, -122.502953108098)
57515 67671 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 1780 Revere Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1992 12:00:00 AM 3   Permit Number 31274 6014163.98928 2095111.2366 37.733572965423896 -122.3934058406 (37.7335729654239, -122.3934058406)
57870 37592 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 639 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1998 12:00:00 AM 4   Permit Number 40020 5992524.028 2111081.26309 37.776196436129396 -122.46938280754699 (37.7761964361294, -122.469382807547)
58505 32742 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 27 Montana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/29/1996 12:00:00 AM 4 3x3 Permit Number 37125 5996375.5789 2089291.73885 37.7165896282782 -122.454484907162 (37.7165896282782, -122.454484907162)
59008 38198 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 885 Girard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/05/2000 12:00:00 AM 5   Permit Number 40325 6011564.90625 2090771.94385 37.721513417393496 -122.402086713936 (37.7215134173935, -122.402086713936)
59492 31354 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 2324 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/21/1995 12:00:00 AM 6   Permit Number 34964 5992033.25034 2099586.3658 37.7446061063992 -122.47024325973 (37.7446061063992, -122.47024325973)
60597 35146 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 936 Vienna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/1998 12:00:00 AM 8   Permit Number 38676 6002023.61816 2088453.4827599998 37.714610274410205 -122.434902580586 (37.7146102744102, -122.434902580586)
60961 43315 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 259 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/13/2000 12:00:00 AM 4   Permit Number 43078 6004448.9414 2091752.36291 37.72380568677679 -122.426754460261 (37.7238056867768, -122.426754460261)
61495 41940 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 642 05th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/2011 12:00:00 AM 3 3x3 Permit Number 767709 5994437.32362 2111135.33206 37.7764552768418 -122.46276817075301 (37.7764552768418, -122.462768170753)
62306 52667 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 226@ MARIPOSA Mississippi St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/29/2006 12:00:00 AM 4   Permit Number 48748 6013989.6640800005 2106012.3733900003 37.7634954891429 -122.39477170574301 (37.7634954891429, -122.394771705743)
62502 46769 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 54 Cotter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/25/2002 12:00:00 AM 6   Permit Number 44865 6002394.404709999 2093228.74941 37.7277431363295 -122.43396212714599 (37.7277431363295, -122.433962127146)
65074 67318 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 666 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/15/1992 12:00:00 AM 9   Permit Number 30800 5993501.91813 2110961.7349 37.7759247065994 -122.46599136010799 (37.7759247065994, -122.465991360108)
67505 50406 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 1361 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2003 12:00:00 AM 4   Permit Number 47058 5981810.1658 2105846.3225 37.761197837443596 -122.50605609679701 (37.7611978374436, -122.506056096797)
67611 43211 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 353 Sweeny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 5   Permit Number 43002 6008758.60086 2094527.34935 37.73166792973 -122.412052645639 (37.73166792973, -122.412052645639)
67927 41944 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 567 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 7   Permit Number 42302 5993743.34162 2111650.50193 37.7778298007164 -122.465206260397 (37.7778298007164, -122.465206260397)
70286 42982 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 469 Princeton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2000 12:00:00 AM 7   Permit Number 42866 6008125.46012 2091747.89633 37.724000603132 -122.414044988394 (37.724000603132, -122.414044988394)
73614 40348 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 501 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/17/1999 12:00:00 AM 6   Permit Number 41478 5984070.03891 2112340.8801599997 37.779162805435 -122.498720071631 (37.779162805435, -122.498720071631)
74277 67405 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 774 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/30/1992 12:00:00 AM 9   Permit Number 30904 5989782.793 2110097.20217 37.7733356814764 -122.478793391379 (37.7733356814764, -122.478793391379)
76063 43217 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 45 Princeton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 4   Permit Number 43007 6007564.041619999 2093733.91416 37.7294222326375 -122.416126315492 (37.7294222326375, -122.416126315492)
76937 42890 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 2249 Ulloa St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/03/2000 12:00:00 AM 3   Permit Number 42809 5988984.6022 2098295.481 37.7408849467502 -122.48069027409402 (37.7408849467502, -122.480690274094)
89568 87364 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 3401 Taraval St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
94485 87363 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 3401 Taraval St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
102463 87366 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 3401 Taraval St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
116109 115788 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 3628 16th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/09/2016 12:00:00 AM 3   Permit Number 777599 6002731.19846 2106518.35077 37.764252377203 -122.433747267607 (37.764252377203, -122.433747267607)
117257 108497 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 1339 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773641 5992378.78756 2106335.85187 37.7631584124216 -122.46953970622101 (37.7631584124216, -122.469539706221)
123975 57938 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 7 Byron Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/18/2010 12:00:00 AM 4   Permit Number 53686 5999410.13624 2086691.6630000002 37.7096239797406 -122.443809305177 (37.7096239797406, -122.443809305177)
130905 108372 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 575 Paris St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   1 3x3   6001633.30512 2090300.73335 37.7196602437916 -122.436383787393 (37.7196602437916, -122.436383787393)
133267 99298 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 50 Norton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/01/2012 12:00:00 AM 4 3x3 Permit Number 768888 6001844.0532599995 2092273.6485400002 37.7250893979513 -122.435796391592 (37.7250893979513, -122.435796391592)
138958 87365 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 3401 Taraval St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
140281 108494 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 734 11th Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773785 5992601.40555 2110422.43493 37.7743919431152 -122.469067180848 (37.7743919431152, -122.469067180848)
148538 42630 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 2634 Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM 6   Permit Number 42686 6004473.47116 2118249.9245 37.7965630841803 -122.428557534402 (37.7965630841803, -122.428557534402)
148774 68284 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 665 Bowdoin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/14/2012 12:00:00 AM 2   Permit Number 769020 6009000.66847 2092983.8736400001 37.727443453448 -122.411106781849 (37.727443453448, -122.411106781849)
152184 50302 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 59 Inverness Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/08/2004 12:00:00 AM 4   Permit Number 47012 5988294.3182 2095513.1698900003 37.7332053009864 -122.482873130798 (37.7332053009864, -122.482873130798)
154328 35122 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 723 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/1998 12:00:00 AM 7   Permit Number 38657 6001912.16427 2089726.3543900002 37.7180989685677 -122.435378807601 (37.7180989685677, -122.435378807601)
154723 43162 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 221 Madison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 5   Permit Number 42972 6005660.57006 2092632.04042 37.726289518943 -122.42262853710301 (37.726289518943, -122.422628537103)
158840 35127 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 775 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/1998 12:00:00 AM 5   Permit Number 38661 6001730.34361 2089436.21425 37.71729198082 -122.43598653257799 (37.71729198082, -122.435986532578)
161710 43171 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 369 Madison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 8   Permit Number 42980 6005855.02005 2091989.32837 37.7245357402195 -122.42191069731501 (37.7245357402195, -122.421910697315)
163271 32472 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 117 Lower Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/10/1996 12:00:00 AM 5   Permit Number 36980 6000335.64895 2106187.4701799997 37.7632076377424 -122.442009017113 (37.7632076377424, -122.442009017113)
168579 43185 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 62 Valmar Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 7   Permit Number 42987 6005330.72095 2092724.62519 37.7265251215375 -122.42377539032101 (37.7265251215375, -122.423775390321)
171196 31366 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 2475 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/21/1995 12:00:00 AM 6   Permit Number 34971 5991057.56391 2098576.78296 37.7417775946723 -122.473543328283 (37.7417775946723, -122.473543328283)
172268 51484 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 63 Bridgeview Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/11/2005 12:00:00 AM 3   Permit Number 47795 6013789.90035 2095538.1570700002 37.7347244096963 -122.394729070715 (37.7347244096963, -122.394729070715)
172685 95711 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 277 Athens St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM 6 3x3 Permit Number 767467 6004408.66119 2091673.84489 37.7235878160995 -122.426888112994 (37.7235878160995, -122.426888112994)
176985 34479 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 756 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/15/1997 12:00:00 AM 6 2x3 Permit Number 38206 6009344.310190001 2119468.83873 37.800184363566 -122.411789466237 (37.800184363566, -122.411789466237)
178747 47762 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 2462 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/05/2002 12:00:00 AM 4   Permit Number 45541 5988312.7876 2098561.9922 37.741577647038 -122.48303266006 (37.741577647038, -122.48303266006)
179554 42889 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 2249 Ulloa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/03/2000 12:00:00 AM 3   Permit Number 42809 5988969.9668 2098294.7493 37.7408820870559 -122.48074082372801 (37.7408820870559, -122.480740823728)
181185 66621 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 153 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/15/1991 12:00:00 AM 2   Permit Number 29825 5988002.0511 2114993.09117 37.7866748512276 -122.48531246716499 (37.7866748512276, -122.485312467165)
181540 43847 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 2828 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM 3   Permit Number 43469 5985600.1899 2096127.6598 37.734735400872204 -122.492232562099 (37.7347354008722, -122.492232562099)
183734 35133 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 805 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/1998 12:00:00 AM 6   Permit Number 38663 6001614.17085 2089254.80742 37.7167872776758 -122.43637511074101 (37.7167872776758, -122.436375110741)
186519 32589 Permitted Site 1 Leptospermum scoparium :: New Zealand Tea Tree 27 1286 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/1996 12:00:00 AM 4   Permit Number 37058 5985555.6068 2106469.8118 37.763129529589705 -122.493148331917 (37.7631295295897, -122.493148331917)
61 226596 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1 Newburg St 4 Sidewalk: Property side : Pot 6 Tree 1 Private 1     4 Width 4ft   6002583.45295 2099992.19698 37.746324733318 -122.433791792881 (37.746324733318, -122.433791792881)
1524 251544 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 863X Ocean Ave   Side Yard : Yard 17 Tree 1 Private 1       3x3   5997430.0 2091537.0 37.722815009603295 -122.451002133856 (37.7228150096033, -122.451002133856)
1773 251685 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 66 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5996558.0 2090330.0 37.719450911009005 -122.453929311088 (37.719450911009, -122.453929311088)
1779 251684 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 62 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5996557.0 2090306.0 37.719384955305294 -122.453931035382 (37.7193849553053, -122.453931035382)
2094 252881 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 3536 Jennings St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 3ft   6013049.3063900005 2089480.54762 37.718050242412296 -122.39686501810199 (37.7180502424123, -122.396865018102)
5541 81381 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 822 Geary St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/08/2003 12:00:00 AM   3x3   6007769.502 2114456.07002 37.7863320683098 -122.41688358241899 (37.7863320683098, -122.416883582419)
11700 109233 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 2570 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3x9   5986169.5717 2097728.0842 37.7391630116047 -122.490381738824 (37.7391630116047, -122.490381738824)
11855 112294 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 2606 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x2   5989896.9401 2097604.9354 37.7390418709124 -122.47748532406099 (37.7390418709124, -122.477485324061)
23484 226621 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 2498 Harrison St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6008827.83459 2103955.23814 37.7575587153899 -122.412479469249 (37.7575587153899, -122.412479469249)
23605 207223 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 137 Marston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   5998550.7404 2093191.23092 37.7274212410962 -122.447246987057 (37.7274212410962, -122.447246987057)
23659 207211 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 351 Judson Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   5997557.05916 2093521.06587 37.7282700608095 -122.450705899268 (37.7282700608095, -122.450705899268)
24701 226623 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 80 Vicksburg St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6004079.6139400005 2102598.16626 37.7535649035083 -122.428803992713 (37.7535649035083, -122.428803992713)
24738 207248 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 574 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992756.55156 2091026.1972 37.7211438059241 -122.46711999608401 (37.7211438059241, -122.467119996084)
24966 177004 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 746 Olmstead St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6009463.77429 2090581.8029200002 37.720873831251104 -122.40933637376999 (37.7208738312511, -122.40933637377)
25103 226578 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 124 Grattan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   5998059.2298099995 2106534.17954 37.76402962709221 -122.44990734536199 (37.7640296270922, -122.449907345362)
25168 118098 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 3619 Balboa St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5984331.597680001 2111046.0676700003 37.7756229611607 -122.497719616092 (37.7756229611607, -122.497719616092)
25493 207183 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5995337.35676 2098242.98475 37.7411079873364 -122.458721155571 (37.7411079873364, -122.458721155571)
25933 207216 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 351 Judson Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 1ft   5997629.9182 2093521.5482700001 37.7282755556595 -122.450454058505 (37.7282755556595, -122.450454058505)
26283 226595 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 880 Douglass St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8 Width 3ft   6001269.3073 2101283.04072 37.749794423884794 -122.438428410468 (37.7497944238848, -122.438428410468)
26310 139038 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1501 BRODERICK ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6000648.2136 2113864.1729 37.7843037348812 -122.441478860369 (37.7843037348812, -122.441478860369)
26934 227699 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 194 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6005300.17225 2100223.67209 37.7471140970563 -122.42441415180099 (37.7471140970563, -122.424414151801)
26959 176992 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 763 Morse St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5998628.254290001 2087146.50399 37.7108282412039 -122.446544317082 (37.7108282412039, -122.446544317082)
27028 207203 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 659 Joost Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   5997731.1976 2094979.2607200001 37.732283884374 -122.450208962681 (37.732283884374, -122.450208962681)
27070 118586 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 110 Point Lobos Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 4ft   5982415.39383 2112637.72046 37.779880658188794 -122.50446606808501 (37.7798806581888, -122.504466068085)
27445 207324 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 85 Sequoia Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5998176.702190001 2097175.31508 37.7383392103809 -122.44882688276199 (37.7383392103809, -122.448826882762)
27819 207168 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 520 Judson Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5996915.754480001 2093635.86285 37.728548535870104 -122.45293118715 (37.7285485358701, -122.45293118715)
27878 226609 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 4005 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008395.3202599995 2096426.5831400002 37.736862424666704 -122.413442851824 (37.7368624246667, -122.413442851824)
27919 207196 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 580 Hearst Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997574.55439 2094416.3667 37.7307293459771 -122.450709941708 (37.7307293459771, -122.450709941708)
28331 207313 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 101 Ridgewood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996777.96593 2094453.90027 37.730786773973605 -122.45346656615101 (37.7307867739736, -122.453466566151)
28926 207301 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 145 Hazelwood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5996452.48883 2094524.36789 37.7309615985977 -122.454596874545 (37.7309615985977, -122.454596874545)
29133 207198 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 580 Hearst Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5997541.97184 2094417.04598 37.7307293459865 -122.450822633076 (37.7307293459865, -122.450822633076)
29485 139037 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1501 BRODERICK ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6000646.8218 2113873.9159999997 37.7843304076342 -122.441484374883 (37.7843304076342, -122.441484374883)
29934 129496 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1101 Greenwich St 2 Front Yard : Yard 7 Tree 1 Private 1     7     6007491.98236 2119862.03748 37.8011599004699 -122.418227149773 (37.8011599004699, -122.418227149773)
30391 207358 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 171 Staples Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5998941.871780001 2093762.1788299999 37.7290112721346 -122.445935896945 (37.7290112721346, -122.445935896945)
30975 227700 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 276 Bemis St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 8ft   6002994.65302 2096282.17867 37.7361612061647 -122.432105019051 (37.7361612061647, -122.432105019051)

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