Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, DBH, PlotSize
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3187 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
JSON shape: default, array, newline-delimited
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");