trees

665 rows where qSpecies_id = 89 sorted by qLegalStatus_id descending

✎ 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)
155653 63535 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 343 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/10/1987 12:00:00 AM     Permit Number 24148 6006747.55377608 2104121.784718 37.7578990494792 -122.419685752558 (37.7578990494792, -122.419685752558) 2 4 7 28859 19
156119 24504 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 360X Fern St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6005526.31532 2114998.99681 37.7876963787723 -122.424683078077 (37.7876963787723, -122.424683078077) 13 9 1 28858 41
157818 53452 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 101 Montcalm St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2010 12:00:00 AM   3x3 Permit Number 53497 6010475.69688316 2099901.56098952 37.7465205531872 -122.406494829187 (37.7465205531872, -122.406494829187) 2 7 7 28859 2
158434 92783 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 527 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/15/2009 12:00:00 AM   3x3 Permit Number 52999 6013573 2112256 37.7806159117786 -122.396650538079 (37.7806159117786, -122.396650538079) 6 2 9 28856 34
159467 86884 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 2534 46th Ave   Sidewalk: Curb side : Cutout Tree Private 2   10/23/2007 12:00:00 AM   3x3 Permit Number 49809 5982151.4 2097835.7 37.7392229927812 -122.504282496051 (37.7392229927812, -122.504282496051) 1 8 3 29491 35
162633 94132 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 101 Montcalm St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2010 12:00:00 AM   3x3 Permit Number 53497 6010479 2099916 37.7465603843487 -122.406484424587 (37.7465603843487, -122.406484424587) 2 7 7 28859 2
163753 42785 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 269 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42753 6005259.26650222 2110063.08095744 37.7741284823912 -122.425255647592 (37.7741284823912, -122.425255647592) 7 9 11 28852 10
164516 45290 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 600 Gates St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2001 12:00:00 AM     Permit Number 44129 6008139.59757362 2096081.06824752 37.7358993545079 -122.414302561575 (37.7358993545079, -122.414302561575) 2 7 7 28859 2
165775 34188 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 2701 Lake St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38079 5987120.3446635 2114449.05125045 37.7851296693951 -122.488322923297 (37.7851296693951, -122.488322923297) 11 6 1 55 33
166235 16403 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 299X Myrtle St 9 Sidewalk: Curb side : Cutout Tree Private 2   01/15/1990 12:00:00 AM 6 3X3   6006028.76056 2113989.39072 37.7849526140265 -122.422872930887 (37.7849526140265, -122.422872930887) 13 9 11 28858 41
166460 16400 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 299X Myrtle St 6 Sidewalk: Curb side : Cutout Tree Private 2   04/13/2005 12:00:00 AM 3 3X3   6006028.76056 2113989.39072 37.7849526140265 -122.422872930887 (37.7849526140265, -122.422872930887) 13 9 11 28858 41
167430 37576 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 124 Danvers St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40009 5999906.30838792 2105075.4680497 37.7601298795068 -122.44341407918 (37.7601298795068, -122.44341407918) 2 4 5 28862 3
167613 33368 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 90 Manor Dr 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM     Permit Number 37499 5993674.94282707 2093510.9416498 37.7280192795988 -122.464125696941 (37.7280192795988, -122.464125696941) 9 8 4 59 40
168006 49034 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1190 Sanchez St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46211 6003822.41781324 2101344.45239948 37.7501079390792 -122.429604025448 (37.7501079390792, -122.429604025448) 2 4 5 28862 22
170131 45807 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1993 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/28/2001 12:00:00 AM     Permit Number 44435 5991886.15341897 2101900.86240585 37.7509526116716 -122.470920456526 (37.7509526116716, -122.470920456526) 1 8 4 29491 12
170746 38961 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 407 Holladay Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42707 6010377.89521168 2098716.86029543 37.7432621510095 -122.406749540855 (37.7432621510095, -122.406749540855) 10 7 7 28859 2
174368 32129 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 35 Spofford Ln 1 Sidewalk: Curb side : Pot Tree Private 2 FUF 08/15/1995 12:00:00 AM     Permit Number 35491 6010554.96159279 2117351.45133924 37.7944383752725 -122.407450761229 (37.7944383752725, -122.407450761229) 3 1 10 28857 4
174438 31950 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1677 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM     Permit Number 35359 6005487.56868066 2115128.64858681 37.7880501818667 -122.424826361466 (37.7880501818667, -122.424826361466) 13 9 1 28858 41
179660 49037 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1190 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM 10   Permit Number 46211 6003822.41781324 2101344.45239948 37.7501079390792 -122.429604025448 (37.7501079390792, -122.429604025448) 2 4 5 28862 22
180103 95587 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 821 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/2009 12:00:00 AM   3x3 Permit Number 767377 6012153 2112651 37.7816213577124 -122.401590796207 (37.7816213577124, -122.401590796207) 6 2 9 28856 34
180503 51460 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 816 Crescent Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/20/2004 12:00:00 AM     Permit Number 47775 6008159.08468648 2095638.69714743 37.7346857944121 -122.414203898561 (37.7346857944121, -122.414203898561) 2 7 7 28859 2
182643 96060 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 101 Montcalm St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2011 12:00:00 AM   3x3 Permit Number 767687 6010479 2099916 37.7465603843487 -122.406484424587 (37.7465603843487, -122.406484424587) 2 7 7 28859 2
182650 88208 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 607 Central Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51212 5999619 2110591.2 37.775258305073 -122.444804221322 (37.775258305073, -122.444804221322) 15 5 11 29492 16
184137 46752 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 375 Victoria St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/2002 12:00:00 AM     Permit Number 44854 5993218.00754376 2089670.83747573 37.7174489416695 -122.465426481993 (37.7174489416695, -122.465426481993) 9 8 6 64 24
184630 17102 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1711 Oak St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   5998685.53291 2109300.56616 37.771661239802 -122.447940341436 (37.771661239802, -122.447940341436) 15 5 11 29492 9
185576 69035 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1407 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1994 12:00:00 AM     Permit Number 33041 5984298.37219271 2105588.33319884 37.7606356257767 -122.497431537078 (37.7606356257767, -122.497431537078) 1 8 3 56 35
186226 32707 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1005 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM     Permit Number 37107 6007675.42771265 2115829.29953352 37.7900973284958 -122.417306405748 (37.7900973284958, -122.417306405748) 13 1 10 28858 21
186795 69515 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 443 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/1997 12:00:00 AM     Permit Number 33643 6008794.13528985 2096723.61704292 37.7377003998713 -122.412084952925 (37.7377003998713, -122.412084952925) 10 7 7 28859 2
187360 24505 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 360X Fern St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6005509.85054 2114996.70292 37.787689150419 -122.424739879851 (37.787689150419, -122.424739879851) 13 9 1 28858 41
187634 32133 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 842 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1995 12:00:00 AM     Permit Number 35494 6010631.11006318 2117599.53652258 37.7951238190257 -122.407204773258 (37.7951238190257, -122.407204773258) 3 1 10 28857 4
189014 49035 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1190 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46211 6003822.41781324 2101344.45239948 37.7501079390792 -122.429604025448 (37.7501079390792, -122.429604025448) 2 4 5 28862 22
189305 30607 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 40 12th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/1995 12:00:00 AM   3x3 Permit Number 34571 6006862.94085785 2109917.12606637 37.773818193258 -122.419697886953 (37.773818193258, -122.419697886953) 8 2 9 28853 19
189904 33365 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 65 Manor Dr 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM     Permit Number 37497 5993537.09779252 2093371.5770822 37.7276286729381 -122.464592112193 (37.7276286729381, -122.464592112193) 9 8 4 59 40
191382 33001 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 255 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM     Permit Number 45106 6012763.62735273 2113645.89457982 37.7843871619555 -122.399548173715 (37.7843871619555, -122.399548173715) 6 2 9 28853 6
193686 16402 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 299X Myrtle St 8 Sidewalk: Curb side : Cutout Tree Private 2   01/15/1990 12:00:00 AM 6 3X3   6006028.76056 2113989.39072 37.7849526140265 -122.422872930887 (37.7849526140265, -122.422872930887) 13 9 11 28858 41
78343 101466 Significant Tree 6 Afrocarpus gracilior :: Fern Pine 89 301 Hazelwood Ave 1 Front Yard : Yard Tree Private 2           5996219.7 2095283.8 37.7330334614805 -122.455456526637 (37.7330334614805, -122.455456526637) 9 7 4 59 40
122238 254735 Significant Tree 6 Afrocarpus gracilior :: Fern Pine 89 363 14th Ave 1 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 781538 5991507 2112990 37.781378479082 -122.473040175374 (37.781378479082, -122.473040175374) 11 6 2 54 26
155948 102478 Significant Tree 6 Afrocarpus gracilior :: Fern Pine 89 760 Victoria St 4 Front Yard : Yard Tree Private 2           5993664.7 2092172.3 37.7243431058269 -122.464063971167 (37.7243431058269, -122.464063971167) 9 8 4 59 40
43755 256846 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 1298x Post St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41
63826 256843 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 1298x Post St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41
84543 256847 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 1298x Post St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41
88708 256845 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 1298x Post St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41
94779 256849 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 1298x Post St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41
96258 256848 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 1298x Post St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41
97400 97940 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 491 Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2           6010516 2120277 37.8024690368502 -122.407791962119 (37.8024690368502, -122.407791962119) 3 1 10 308 23
98279 256844 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 1298x Post St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41
102881 220639 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 1202 Stanyan St 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   5997451.78012 2105807.14899 37.7619986098677 -122.451955868771 (37.7619986098677, -122.451955868771) 15 5 11 29492 9
104419 256840 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 1298x Post St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41
117100 256841 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 1298x Post St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41
128595 256842 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 1298x Post St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41
144868 97942 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 491 Greenwich St 4 Sidewalk: Curb side : Cutout Tree Private 2           6010516 2120277 37.8024690368502 -122.407791962119 (37.8024690368502, -122.407791962119) 3 1 10 308 23
175348 97941 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 491 Greenwich St 3 Sidewalk: Curb side : Cutout Tree Private 2           6010516 2120277 37.8024690368502 -122.407791962119 (37.8024690368502, -122.407791962119) 3 1 10 308 23
186373 96486 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 1202 Stanyan St 1 Sidewalk: Property side : Cutout Tree Private 2           5997433 2105848 37.7621097006999 -122.452023768999 (37.7621097006999, -122.452023768999) 15 5 11 29492 9
188461 97939 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 491 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2           6010516 2120277 37.8024690368502 -122.407791962119 (37.8024690368502, -122.407791962119) 3 1 10 308 23
317 189161 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 109 Kissling St 4 : Tree Private 2     2 Width 3ft   6008149.50016 2109391.65635 37.7724477670719 -122.415210253457 (37.7724477670719, -122.415210253457) 8 2 9 28853 19
420 35740 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 9 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/15/1998 12:00:00 AM 12   Permit Number 39014 6007525.01662 2093953.73286 37.7300236128799 -122.416276791867 (37.7300236128799, -122.416276791867) 9 3 7 309 28
823 33293 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 166 Sproule Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM 10   Permit Number 37451 6009221.08576 2116982.79677 37.7933513902069 -122.412040085683 (37.7933513902069, -122.412040085683) 3 1 10 28857 21
1264 125499 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 10 Hastings Ter 1 Sidewalk: Property side : Yard Tree Private 2     2     6007355.47144 2119286.08851 37.7995708047014 -122.418658671469 (37.7995708047014, -122.418658671469) 5 1 1 28858 32
1455 176735 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1245 Bacon St 3 Sidewalk: Property side : Yard Tree Private 2   08/17/2019 12:00:00 AM 3 Width 2ft   6007785.06482 2091940.88647 37.7245113883837 -122.415235340041 (37.7245113883837, -122.415235340041) 9 3 7 309 28
1616 249984 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 226 Filbert St 2 Front Yard : Yard Tree Private 2     10 Width 0ft   6011604.5053 2120111.99388 37.8020768465317 -122.404013554575 (37.8020768465317, -122.404013554575) 3 1 10 308 23
1720 221753 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 466 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003367.55908 2102748.60922 37.7539376572014 -122.431277170628 (37.7539376572014, -122.431277170628) 2 4 5 28862 22
1725 261074 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 545 Thornton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6012421 2094417 37.7315697407484 -122.399383175238 (37.7315697407484, -122.399383175238) 10 3 8 58 1
2235 16944 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 599X Oak St 7 Sidewalk: Property side : Cutout Tree DPW 1     20 3x3   6004143.7777346 2110082.9014722 37.774119822678 -122.429115732545 (37.774119822678, -122.429115732545) 7 9 11 28852 10
2382 255210 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1 Burrows St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
2997 220656 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 498X Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008322.74158 2096484.80156 37.737018204322 -122.41369790583 (37.737018204322, -122.41369790583) 2 7 7 28859 2
3711 125506 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 7 Fallon Pl 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 4ft   6008920.97468 2118571.47788 37.7976966751291 -122.413190886946 (37.7976966751291, -122.413190886946) 3 1 10 308 21
3907 66747 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 731 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM 4   Permit Number 32132 5983183.98032 2110807.82823 37.7749014841497 -122.501671811672 (37.7749014841497, -122.501671811672) 11 6 2 55 26
4217 220655 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 390X Ogden Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008083.69599 2096082.25636 37.7358994764657 -122.414495920166 (37.7358994764657, -122.414495920166) 2 7 7 28859 2
4345 248094 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 8 Brewster St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010447.33936 2099861.69566 37.7464095052133 -122.406590078085 (37.7464095052133, -122.406590078085) 2 7 7 28859 2
4866 220627 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 665 Elizabeth St 11 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   6002180.12335 2102046.50109 37.7519424707911 -122.435333378334 (37.7519424707911, -122.435333378334) 2 4 5 28862 22
4902 262165 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 725 Delta St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/07/2019 12:00:00 AM 3     6009246.1256 2087178.55003 37.7115170052904 -122.409848612702 (37.7115170052904, -122.409848612702) 9 7 8 309 39
6257 125500 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 12 Hastings Ter 6 Sidewalk: Property side : Yard Tree Private 2     2     6007269.76384 2119273.06582 37.7995302219096 -122.418954327193 (37.7995302219096, -122.418954327193) 5 1 1 28858 32
7190 120690 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 358 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/14/2018 12:00:00 AM 3 Width 4ft Permit Number 782203 5989057.83806 2112937.05315 37.7810910000946 -122.481509105367 (37.7810910000946, -122.481509105367) 11 6 2 55 26
8154 220632 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 18 Kronquist Ct 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 1ft   6002213.33941 2100174.25358 37.7468036087954 -122.435084618683 (37.7468036087954, -122.435084618683) 2 7 5 63 22
8425 175169 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 728 Burrows St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009133.75655 2092888.51191 37.7271890729929 -122.41063996266 (37.7271890729929, -122.41063996266) 9 3 7 309 28
9003 259743 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1300x Quesada Ave 1 Side Yard : Cutout Tree DPW 1 FUF 10/13/2018 12:00:00 AM 3                        
9079 220625 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 665 Elizabeth St 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   6002079.84367 2102040.673 37.7519207728238 -122.43567974235 (37.7519207728238, -122.43567974235) 2 4 5 28862 22
9227 249036 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 14 Carr St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2019 12:00:00 AM 3 4x6   6013092.81558 2091032.06192 37.7223128112827 -122.396823338154 (37.7223128112827, -122.396823338154) 10 3 8 58 1
10180 125521 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 900 Green St 33 Sidewalk: Property side : Yard Tree Private 2     2 Width 5ft   6008568.41134 2119026.06198 37.7989250510158 -122.414443039112 (37.7989250510158, -122.414443039112) 5 1 10 308 32
10211 249538 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 201 Myrtle St 7 : Tree Private 2     4 Width 3ft   6006360.10871 2114050.01147 37.7851377542393 -122.421730877876 (37.7851377542393, -122.421730877876) 13 9 11 28858 41
11971 220654 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 390X Ogden Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008103.73158 2096079.3451 37.735892608341 -122.414426443037 (37.735892608341, -122.414426443037) 2 7 7 28859 2
12247 16942 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 599X Oak St 5 Sidewalk: Property side : Cutout Tree DPW 1     6 3x3   6004143.7777346 2110082.9014722 37.774119822678 -122.429115732545 (37.774119822678, -122.429115732545) 7 9 11 28852 10
13613 261072 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1301 Egbert Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2020 04:47:00 PM 3 4x6   6014770 2090698 37.7214887539174 -122.391002321697 (37.7214887539174, -122.391002321697) 10 3 8 58 1
13876 189183 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 40 Bluxome St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6013471.29582 2110911.40867 37.7769183095594 -122.396908085761 (37.7769183095594, -122.396908085761) 6 2 9 28856 34
13926 176734 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1245 Bacon St 2 Sidewalk: Property side : Yard Tree Private 2   08/17/2019 12:00:00 AM 3 Width 2ft   6007778.84426 2091938.91597 37.7245056282085 -122.415256704327 (37.7245056282085, -122.415256704327) 9 3 7 309 28
14262 92752 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 3356 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2009 12:00:00 AM 4 3x3 Permit Number 52980 5999300.27951 2120375.08626 37.8021040941904 -122.446610827352 (37.8021040941904, -122.446610827352) 13 9 1 57 17
14396 220653 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 390X Ogden Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008119.35429 2096079.02548 37.7358926083592 -122.41437240636 (37.7358926083592, -122.41437240636) 2 7 7 28859 2
14680 259744 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1300x Quesada Ave 2 Side Yard : Cutout Tree DPW 1 FUF 10/13/2018 12:00:00 AM 3                        
14699 220657 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 498X Tompkins Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008343.07833 2096482.99595 37.737014388513 -122.413627464658 (37.737014388513, -122.413627464658) 2 7 7 28859 2
14704 255211 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 7 Burrows St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
14764 203487 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 828 Foerster St 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5998282.18197 2096469.86688 37.736408249925 -122.448411398672 (37.736408249925, -122.448411398672) 9 7 4 59 40
15364 259745 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1300x Quesada Ave 3 Side Yard : Cutout Tree DPW 1 FUF 10/13/2018 12:00:00 AM 3                        
15503 221757 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 2 Seward St 3 Sidewalk: Property side : Yard Tree Private 2     23 Width 3ft   6001069.49524 2104258.14697 37.7579519799282 -122.439332593347 (37.7579519799282, -122.439332593347) 2 4 5 28862 38
15512 203483 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 459 Colon Ave 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   5995499.06215 2095368.93495 37.7332258441801 -122.457954104018 (37.7332258441801, -122.457954104018) 9 7 4 59 40
16090 70151 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 846 Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6007647.41454 2114440.4952 37.786282435643 -122.417304870747 (37.786282435643, -122.417304870747) 13 1 9 28858 36
16888 171233 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 65 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 3ft   6003693 2093019 37.7272408214237 -122.42945790991 (37.7272408214237, -122.42945790991) 9 7 6 28861 5
18869 261135 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 401 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6003851 2092597 37.7260910477872 -122.428881632271 (37.7260910477872, -122.428881632271) 9 7 6 28861 5
19869 37653 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1707 Balboa St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM 4   Permit Number 40063 5990244.83767 2111259.26404 37.7765532018856 -122.477280073273 (37.7765532018856, -122.477280073273) 11 6 2 55 26
20069 249536 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 201 Myrtle St 5 : Tree Private 2     6 Width 3ft   6006331.73852 2114045.88325 37.7851248193023 -122.421828736708 (37.7851248193023, -122.421828736708) 13 9 11 28858 41
20279 7125 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 300X Fern St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/02/1990 12:00:00 AM 6 3X3   6005738.17658 2115026.96294 37.7877851299198 -122.423952067531 (37.7877851299198, -122.423952067531) 13 9 1 28858 41

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)
);