trees

400 rows where qSpecies_id = 43 sorted by Zip Codes

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes ▼ Neighborhoods (old)
82374 43745 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 253 Summit St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43378 5996396.86656602 2089502.57565196 37.7171697577055 -122.454426548253 (37.7171697577055, -122.454426548253) 9 8 6 28861 24
94076 31013 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1016 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM     Permit Number 34783 6002340.84086344 2087450.93520516 37.7118755052494 -122.433734519918 (37.7118755052494, -122.433734519918) 9 7 6 28861 5
96443 37870 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 135 Colon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM     Permit Number 40155 5996120.55604725 2093902.0241844 37.7292337486651 -122.455699446357 (37.7292337486651, -122.455699446357) 9 7 4 28861 40
97659 36491 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 6 Sidewalk: Curb side : Cutout Tree Private 2   05/18/1998 12:00:00 AM     Permit Number 39377 5995116.30141704 2093273.83949404 37.7274512220857 -122.459125749197 (37.7274512220857, -122.459125749197) 9 7 4 28861 40
100219 39676 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 520 Orizaba Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 41061 5994057.0703552 2090076.01512202 37.7186098185096 -122.462555624891 (37.7186098185096, -122.462555624891) 9 8 6 28861 24
106874 34110 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1398 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39363 5995892.17100072 2093289.41859175 37.7275385716585 -122.456444707829 (37.7275385716585, -122.456444707829) 9 7 4 28861 40
107910 51637 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 189 Margaret Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/2005 12:00:00 AM     Permit Number 47927 5996660.05636895 2089154.42395132 37.7162289049692 -122.453491707846 (37.7162289049692, -122.453491707846) 9 8 6 28861 24
111332 32293 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 160 Margaret Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1999 12:00:00 AM     Permit Number 41561 5996702.09015079 2089306.207139 37.7166480756618 -122.453357371649 (37.7166480756618, -122.453357371649) 9 8 6 28861 24
116835 43746 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 253 Summit St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43378 5996396.86656602 2089502.57565196 37.7171697577055 -122.454426548253 (37.7171697577055, -122.454426548253) 9 8 6 28861 24
119125 36493 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 3 Sidewalk: Curb side : Cutout Tree Private 2   05/18/1998 12:00:00 AM     Permit Number 39377 5995116.30141704 2093273.83949404 37.7274512220857 -122.459125749197 (37.7274512220857, -122.459125749197) 9 7 4 28861 40
136572 37871 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 135 Colon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM     Permit Number 40155 5996120.55604725 2093902.0241844 37.7292337486651 -122.455699446357 (37.7292337486651, -122.455699446357) 9 7 4 28861 40
137049 37869 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 135 Colon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/2002 12:00:00 AM     Permit Number 40155 5996120.55604725 2093902.0241844 37.7292337486651 -122.455699446357 (37.7292337486651, -122.455699446357) 9 7 4 28861 40
140321 36492 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   05/18/1998 12:00:00 AM     Permit Number 39377 5995116.30141704 2093273.83949404 37.7274512220857 -122.459125749197 (37.7274512220857, -122.459125749197) 9 7 4 28861 40
144944 36488 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 2 Sidewalk: Curb side : Cutout Tree Private 2   05/18/1998 12:00:00 AM     Permit Number 39377 5995116.30141704 2093273.83949404 37.7274512220857 -122.459125749197 (37.7274512220857, -122.459125749197) 9 7 4 28861 40
146965 31139 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 419 Hearst Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34852 5998635.87955939 2094356.6234018 37.7306259997996 -122.447036492148 (37.7306259997996, -122.447036492148) 9 7 4 28861 40
147242 43743 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 240 Summit St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43377 5996455.89048278 2089497.50907915 37.7171592309734 -122.454222165987 (37.7171592309734, -122.454222165987) 9 8 6 28861 24
169593 43744 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 240 Summit St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43377 5996455.89048278 2089497.50907915 37.7171592309734 -122.454222165987 (37.7171592309734, -122.454222165987) 9 8 6 28861 24
172042 36471 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 101 San Ramon Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39368 5995817.82622595 2092643.889646 37.7257618354228 -122.456655052435 (37.7257618354228, -122.456655052435) 9 7 4 28861 40
173394 64645 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 855 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1997 12:00:00 AM     Permit Number 25560 5994845.99503562 2093786.0882856 37.7288421898975 -122.460097287553 (37.7288421898975, -122.460097287553) 9 7 4 28861 40
173715 36487 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 4 Sidewalk: Curb side : Cutout Tree Private 2   05/18/1998 12:00:00 AM     Permit Number 39377 5995116.30141704 2093273.83949404 37.7274512220857 -122.459125749197 (37.7274512220857, -122.459125749197) 9 7 4 28861 40
176487 34803 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 722 Huron Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1997 12:00:00 AM     Permit Number 38439 5997690.29775308 2087581.0038805 37.7119676582592 -122.449817388593 (37.7119676582592, -122.449817388593) 9 7 6 28861 25
189493 36335 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 44 Eastwood Dr 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1998 12:00:00 AM     Permit Number 39301 5995656.19844855 2092807.02452797 37.7262004833581 -122.457225579924 (37.7262004833581, -122.457225579924) 9 7 4 28861 40
3588 37560 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 4645 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 39999 6000466.36495931 2104620.54811441 37.758912703603 -122.44144447135 (37.758912703603, -122.44144447135) 2 4 5 28862 38
19915 37424 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Noe St 6 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1998 12:00:00 AM     Permit Number 39902 6003190.5059195 2101131.09771587 37.7494863167503 -122.431773980118 (37.7494863167503, -122.431773980118) 2 4 5 28862 22
36835 37313 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 485 Hill St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39829 6003203.23907746 2103274.86360864 37.7553733132886 -122.431883001431 (37.7553733132886, -122.431883001431) 2 4 5 28862 22
37916 233997 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1027 Douglass St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6001336.17311 2100800.0445 37.7484720346532 -122.438162590655 (37.7484720346532, -122.438162590655) 2 4 5 28862 22
39432 37587 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2805 Market St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40018 6001080.41648379 2105487.69270452 37.7613286337784 -122.439382956636 (37.7613286337784, -122.439382956636) 15 4 5 28862 3
62613 37588 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2805 Market St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40018 6001080.41648379 2105487.69270452 37.7613286337784 -122.439382956636 (37.7613286337784, -122.439382956636) 15 4 5 28862 3
65609 37589 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2805 Market St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40018 6001080.41648379 2105487.69270452 37.7613286337784 -122.439382956636 (37.7613286337784, -122.439382956636) 15 4 5 28862 3
72751 37286 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 699 Castro St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2002 12:00:00 AM     Permit Number 39818 6002432.10165251 2104152.77929012 37.757740114019 -122.434612596377 (37.757740114019, -122.434612596377) 2 4 5 28862 3
79487 37590 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2805 Market St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40018 6001080.41648379 2105487.69270452 37.7613286337784 -122.439382956636 (37.7613286337784, -122.439382956636) 15 4 5 28862 3
80984 36908 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 394 Diamond St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/27/1998 12:00:00 AM     Permit Number 39556 6001774.84404362 2103557.93464621 37.7560694803843 -122.436843078117 (37.7560694803843, -122.436843078117) 2 4 5 28862 3
110816 37426 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Noe St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1998 12:00:00 AM     Permit Number 39902 6003190.5059195 2101131.09771587 37.7494863167503 -122.431773980118 (37.7494863167503, -122.431773980118) 2 4 5 28862 22
115816 67467 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 4078 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1999 12:00:00 AM     Permit Number 30982 6003350.50488606 2101289.69360575 37.7499308522406 -122.431232018452 (37.7499308522406, -122.431232018452) 2 4 5 28862 22
125708 37427 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1998 12:00:00 AM     Permit Number 39902 6003190.5059195 2101131.09771587 37.7494863167503 -122.431773980118 (37.7494863167503, -122.431773980118) 2 4 5 28862 22
126600 37423 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Noe St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1998 12:00:00 AM     Permit Number 39902 6003190.5059195 2101131.09771587 37.7494863167503 -122.431773980118 (37.7494863167503, -122.431773980118) 2 4 5 28862 22
151337 36907 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 884 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM     Permit Number 40695 6000695.68812692 2102606.86536781 37.7533966824522 -122.440506941015 (37.7533966824522, -122.440506941015) 2 4 5 28862 22
154775 37314 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 485 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39829 6003203.23907746 2103274.86360864 37.7553733132886 -122.431883001431 (37.7553733132886, -122.431883001431) 2 4 5 28862 22
172670 39490 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 4054 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM     Permit Number 40948 6002823.01095214 2101848.4791437 37.7514352381886 -122.433096036215 (37.7514352381886, -122.433096036215) 2 4 5 28862 22
173663 37275 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 3894 22nd St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1998 12:00:00 AM     Permit Number 39816 6002513.25180394 2102998.13185029 37.754574335137 -122.434249400487 (37.754574335137, -122.434249400487) 2 4 5 28862 22
31600 38082 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 15 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000645.66901 2113851.82701 37.7842696912791 -122.44148677751 (37.7842696912791, -122.44148677751) 15 6 11 29490 13
32857 47691 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2858 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2002 12:00:00 AM     Permit Number 45490 6001036.99468682 2116264.16139907 37.7909156246348 -122.440305990836 (37.7909156246348, -122.440305990836) 13 6 1 29490 27
33819 38088 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000614.67901 2114079.17001 37.7848921510189 -122.441610312074 (37.7848921510189, -122.441610312074) 15 6 11 29490 13
47019 39910 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
49210 114656 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Post St 10 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6001274.7016 2113900.9823 37.78444047533 -122.439314075739 (37.78444047533, -122.439314075739) 15 6 11 29490 13
49379 38081 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000619.36701 2114044.53501 37.7847973193303 -122.441591606798 (37.7847973193303, -122.441591606798) 15 6 11 29490 13
49579 114652 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Post St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6001448.056 2113923.3749 37.7845118231904 -122.438715935573 (37.7845118231904, -122.438715935573) 15 6 11 29490 13
64436 114654 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Post St 8 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6001378.1104 2113915.8269 37.7844871189173 -122.438957381866 (37.7844871189173, -122.438957381866) 15 6 11 29490 13
70486 38076 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000627.17901 2113992.97301 37.7846561884399 -122.441560878475 (37.7846561884399, -122.441560878475) 15 6 11 29490 13
73346 38079 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 12 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000639.41901 2113899.22301 37.7843994724246 -122.441511802515 (37.7843994724246, -122.441511802515) 15 6 11 29490 13
77186 39908 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
86961 39907 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
88322 38072 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000643.06501 2113866.93101 37.7843110146233 -122.441496870623 (37.7843110146233, -122.441496870623) 15 6 11 29490 13
89820 39905 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
109355 38078 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000636.81501 2113914.58701 37.7844415096587 -122.441521914323 (37.7844415096587, -122.441521914323) 15 6 11 29490 13
127672 38084 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 17 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000626.16659083 2114103.31583795 37.7849591037257 -122.441572302214 (37.7849591037257, -122.441572302214) 15 6 11 29490 13
136957 38083 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 16 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000626.16659083 2114103.31583795 37.7849591037257 -122.441572302214 (37.7849591037257, -122.441572302214) 15 6 11 29490 13
149752 38073 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000616.76201 2114062.24301 37.7848457925173 -122.441601890436 (37.7848457925173, -122.441601890436) 15 6 11 29490 13
150087 39909 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2001 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
161249 38075 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000624.05401 2114007.81601 37.7846967654532 -122.441572755427 (37.7846967654532, -122.441572755427) 15 6 11 29490 13
177223 38077 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000633.42901 2113935.94101 37.7844999493368 -122.441535161579 (37.7844999493368, -122.441535161579) 15 6 11 29490 13
180904 34527 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2856 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/22/1997 12:00:00 AM     Permit Number 38237 6001046.30881699 2116265.48327203 37.7909197844571 -122.440273859259 (37.7909197844571, -122.440273859259) 13 6 1 29490 27
181292 38074 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000621.45001 2114020.83701 37.7847323694056 -122.441582699114 (37.7847323694056, -122.441582699114) 15 6 11 29490 13
189659 34528 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2856 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1997 12:00:00 AM     Permit Number 38237 6001046.30881699 2116265.48327203 37.7909197844571 -122.440273859259 (37.7909197844571, -122.440273859259) 13 6 1 29490 27
190764 38080 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 13 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000641.24201 2113883.59801 37.7843566740562 -122.441504373964 (37.7843566740562, -122.441504373964) 15 6 11 29490 13
29364 183465 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2530 27th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 0ft   5988020.0365 2098057.021 37.7401740893942 -122.484007860756 (37.7401740893942, -122.484007860756) 1 8 3 29491 35
32117 183413 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2350 Wawona St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5985629.7915 2097026.6067 37.737205400625 -122.492196390733 (37.737205400625, -122.492196390733) 1 8 3 29491 35
67615 69146 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2479 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/18/1994 12:00:00 AM     Permit Number 33181 5983616.53937475 2098288.7238606 37.7405529339472 -122.499250248288 (37.7405529339472, -122.499250248288) 1 8 3 29491 35
68189 68517 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 146 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32397 5993053.91795071 2101210.30087773 37.7491239746497 -122.466832052807 (37.7491239746497, -122.466832052807) 1 8 4 29491 12
68850 187339 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Sunset Blvd 24 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5985079.354 2099690.9452 37.7444887635366 -122.494295807794 (37.7444887635366, -122.494295807794) 1 8 3 29491 35
93886 68599 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1939 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/21/1993 12:00:00 AM     Permit Number 32502 5991241.84953509 2102215.30732714 37.7517787113613 -122.473171429533 (37.7517787113613, -122.473171429533) 1 8 4 29491 12
110316 42870 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2554 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/03/2000 12:00:00 AM 5   Permit Number 42793 5986474.4308 2097869.1881 37.73956824618 -122.489338060188 (37.73956824618, -122.489338060188) 1 8 3 29491 35
183661 79350 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1946 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/2011 12:00:00 AM 3 3x3 Permit Number 767118 5983237.8759 2101878.6369 37.7503876245198 -122.500824911735 (37.7503876245198, -122.500824911735) 1 8 3 29491 35
190034 69279 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1935 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/1994 12:00:00 AM     Permit Number 33350 5991240.95366227 2102241.42925325 37.7518503834746 -122.473176432428 (37.7518503834746, -122.473176432428) 1 8 4 29491 12
7624 246397 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1320 Waller St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999315.6516 2108414.4782 37.769264264093 -122.445696997639 (37.769264264093, -122.445696997639) 15 5 11 29492 9
25595 247352 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 717 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6003091.9924 2109593.0641 37.7727152549133 -122.432719040926 (37.7727152549133, -122.432719040926) 15 5 11 29492 9
32393 246393 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1318 Waller St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999383.4853 2108424.4716 37.7692955761214 -122.445463083857 (37.7692955761214, -122.445463083857) 15 5 11 29492 9
58011 246391 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1302 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999418.9163 2108430.2253 37.7693133969257 -122.445340943975 (37.7693133969257, -122.445340943975) 15 5 11 29492 9
65565 246392 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1310 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999402.5635 2108427.4999 37.7693049801732 -122.445397311319 (37.7693049801732, -122.445397311319) 15 5 11 29492 9
68367 14603 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1265 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     0 3X3   5999439.61797 2108531.98026 37.7695939720606 -122.44527665521 (37.7695939720606, -122.44527665521) 15 5 11 29492 9
91821 246394 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1320 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999365.9212 2108422.0489 37.7692879212962 -122.445523662753 (37.7692879212962, -122.445523662753) 15 5 11 29492 9
106912 246396 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1320 Waller St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999332.61 2108417.5065 37.769273547251 -122.445638557414 (37.769273547251, -122.445638557414) 15 5 11 29492 9
124314 246395 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1320 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999349.2656 2108419.0206 37.7692786554823 -122.445581055639 (37.7692786554823, -122.445581055639) 15 5 11 29492 9
150043 246390 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1267 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     2 Width 0ft   5999435.2691 2108467.7761 37.7694174354079 -122.445287080875 (37.7694174354079, -122.445287080875) 15 5 11 29492 9
166774 141601 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1882 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5998863.8341 2110436.3604 37.77479003056 -122.447405354515 (37.77479003056, -122.447405354515) 15 5 11 29492 16
180644 248448 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 136 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5998284.3672 2107976.1331 37.768001745714 -122.449232557107 (37.768001745714, -122.449232557107) 15 5 11 29492 9
30149 34482 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 840 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38209 6008945.03028541 2119415.9766962 37.8000168102383 -122.413167394928 (37.8000168102383, -122.413167394928) 3 1 10 308 32
102213 99920 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1740 Jones St 7 Sidewalk: Property side : Cutout Tree Private 2           6008334 2118406 37.7972093435845 -122.415210266144 (37.7972093435845, -122.415210266144) 5 1 10 308 21
18513 38167 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 315 Bacon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40305 6010555.26362325 2092792.3936381 37.7270047480515 -122.405719032848 (37.7270047480515, -122.405719032848) 10 3 7 309 28
20022 35741 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 231 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/15/1998 12:00:00 AM     Permit Number 39015 6007788.68777846 2092857.60054619 37.7270286926321 -122.415287680245 (37.7270286926321, -122.415287680245) 9 3 7 309 28
23158 38196 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 730 Girard St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40323 6011305.3220934 2091453.71988413 37.7233709423274 -122.403031960796 (37.7233709423274, -122.403031960796) 10 3 7 309 28
43878 38172 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 433 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40308 6010665.04465284 2092691.20819375 37.7267330524509 -122.405332397121 (37.7267330524509, -122.405332397121) 10 3 7 309 28
44351 37782 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 289 Hamilton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/06/1998 12:00:00 AM     Permit Number 40117 6009320.94225991 2092982.60267054 37.7274579192917 -122.409999500097 (37.7274579192917, -122.409999500097) 10 3 7 309 28
72189 38209 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 830 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40332 6010874.68113014 2090828.02861629 37.7216288654759 -122.40447659257 (37.7216288654759, -122.40447659257) 10 3 7 309 28
86025 38199 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 455 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40326 6010407.74547618 2092510.58020697 37.7262226967111 -122.406209156508 (37.7262226967111, -122.406209156508) 10 3 7 309 28
86559 38511 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 64 Britton St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/1998 12:00:00 AM     Permit Number 40500 6008516.43042503 2087785.37039582 37.7131422875132 -122.412413505045 (37.7131422875132, -122.412413505045) 9 7 8 309 39
89187 251679 Undocumented 4 Dodonaea viscosa :: Hop Bush 43 5 Dwight St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011495 2091622 37.7238435952898 -122.402388102511 (37.7238435952898, -122.402388102511) 10 3 7 309 28
111237 38179 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 36 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40312 6011464.3100447 2091682.81198966 37.7240088592297 -122.402498467389 (37.7240088592297, -122.402498467389) 10 3 7 309 28
116815 35745 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1005 Silliman St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/15/1998 12:00:00 AM     Permit Number 39018 6007884.66062501 2093417.72691387 37.728572072766 -122.414995531053 (37.728572072766, -122.414995531053) 9 3 7 309 5
134688 43251 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 270 Holyoke St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/12/2000 12:00:00 AM     Permit Number 43039 6009534.75313896 2093131.57732831 37.727878953409 -122.409270860276 (37.727878953409, -122.409270860276) 10 3 7 309 28

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);