Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▲ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
58238 | 58238 | 116047 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 650x Kansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 5x12 | 6011496.1211 | 2105415.8281900003 | 37.761718552879 | -122.403354153666 | (37.761718552879, -122.403354153666) | ||
1099 | 1099 | 250070 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 1 | : 4 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005393.47416 | 2115303.0126799997 | 37.788523627097 | -122.425164323999 | (37.788523627097, -122.425164323999) | |||
7458 | 7458 | 18926 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 2689 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001985.03027 | 2115691.49541 | 37.7893971628975 | -122.43698481780599 | (37.7893971628975, -122.436984817806) | |||
17640 | 17640 | 4490 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1602 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2002 12:00:00 AM | 3 | 3X3 | 6004561.8284 | 2099527.9975 | 37.7451622129677 | -122.426917747467 | (37.7451622129677, -122.426917747467) | ||
18805 | 18805 | 27714 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001610.45471 | 2097108.7336400002 | 37.7383521588292 | -122.436949905209 | (37.7383521588292, -122.436949905209) | |||
22608 | 22608 | 9889 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1700 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005347.08674 | 2115527.81747 | 37.78913826426621 | -122.425340821331 | (37.7891382642662, -122.425340821331) | |||
22656 | 22656 | 17785 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1798X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005398.04469 | 2115519.90556 | 37.7891194189645 | -122.42516394985701 | (37.7891194189645, -122.425163949857) | |||
22706 | 22706 | 7127 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005701.71486 | 2115022.2576200003 | 37.7877701517306 | -122.424077883603 | (37.7877701517306, -122.424077883603) | ||
30666 | 30666 | 189167 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1300x De Haro St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012264.80612 | 2102152.7525400002 | 37.7528017667079 | -122.40046634965 | (37.7528017667079, -122.40046634965) | ||||
44709 | 44709 | 125485 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6007640.9414 | 2118138.07584 | 37.796434716745 | -122.417589429708 | (37.796434716745, -122.417589429708) | ||||
60904 | 60904 | 16944 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 599X Oak St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 20 | 3x3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
80299 | 80299 | 28777 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
80980 | 80980 | 27672 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
81629 | 81629 | 27670 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
90024 | 90024 | 27668 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
90399 | 90399 | 27665 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.42375144816299 | (37.7888072668978, -122.423751448163) | |||
92549 | 92549 | 27666 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.42375144816299 | (37.7888072668978, -122.423751448163) | |||
94446 | 94446 | 27669 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
95583 | 95583 | 24521 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
100083 | 100083 | 8408 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1570 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1999 12:00:00 AM | 3 | 3X3 | 6004211.027185 | 2114032.026709 | 37.7849669496355 | -122.42916474711001 | (37.7849669496355, -122.42916474711) | ||
103041 | 103041 | 16943 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 599X Oak St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3x3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
104455 | 104455 | 24519 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
110335 | 110335 | 24520 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
111562 | 111562 | 27667 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300 Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.42375144816299 | (37.7888072668978, -122.423751448163) | |||
115405 | 115405 | 24518 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
118715 | 118715 | 27671 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
120146 | 120146 | 16406 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
121821 | 121821 | 17031 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1160X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001440.12949 | 2109757.61689 | 37.7730732545652 | -122.43844479592501 | (37.7730732545652, -122.438444795925) | |||
122812 | 122812 | 16907 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 452 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004778.478730001 | 2110233.49325 | 37.774569219476206 | -122.426930917012 | (37.7745692194762, -122.426930917012) | |||
123607 | 123607 | 16942 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 599X Oak St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6 | 3x3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
127147 | 127147 | 17018 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1048 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001982.80486 | 2109858.7796099996 | 37.7733818753695 | -122.436574858617 | (37.7733818753695, -122.436574858617) | ||
143787 | 143787 | 16405 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
164866 | 164866 | 125484 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6007648.69076 | 2118115.73393 | 37.796373807471 | -122.41756103092699 | (37.796373807471, -122.417561030927) | ||||
174163 | 174163 | 125486 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6007645.270330001 | 2118136.8198 | 37.7964315115565 | -122.417574361577 | (37.7964315115565, -122.417574361577) | ||||
183680 | 183680 | 189166 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1300x De Haro St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012257.93832 | 2102144.48011 | 37.752778669414 | -122.40048951886999 | (37.752778669414, -122.40048951887) | ||||
267 | 267 | 175151 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779495 | 6000727.04119 | 2093604.3094 | 37.728679573387495 | -122.43975313162399 | (37.7286795733875, -122.439753131624) | |
271 | 271 | 175152 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Santa Rosa Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779495 | 6000750.8705 | 2093589.3929700002 | 37.728639972642604 | -122.43966968351002 | (37.7286399726426, -122.43966968351) | |
1054 | 1054 | 125462 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 125 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 52121 | 6009895.29665 | 2113891.24599 | 37.7849005400769 | -122.40948896803499 | (37.7849005400769, -122.409488968035) | |
1850 | 1850 | 251747 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 706 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002959.0 | 2087321.0 | 37.7115537887528 | -122.431588720074 | (37.7115537887528, -122.431588720074) | ||||
2582 | 2582 | 253132 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 522 Avalon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6004047.94044 | 2092448.5749599999 | 37.7256946506667 | -122.428190247706 | (37.7256946506667, -122.428190247706) | ||||
5093 | 5093 | 18924 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2675 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2013 12:00:00 AM | 3 | 4x4 | Permit Number 770153 | 6002021.65815 | 2115693.95851 | 37.7894060077371 | -122.43685826610701 | (37.7894060077371, -122.436858266107) | |
7088 | 7088 | 107943 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 44x MacOndray Ln | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6008438.53642 | 2119159.8208 | 37.7992850226339 | -122.41490192268 | (37.7992850226339, -122.41490192268) | |||
7189 | 7189 | 111999 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2414 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2015 12:00:00 AM | 24 | 4x4 | Permit Number 776155 | 6003178.791259999 | 2117077.11494 | 37.793269498846705 | -122.432953577047 | (37.7932694988467, -122.432953577047) | |
8590 | 8590 | 102757 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2807 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002051.958459999 | 2117801.7316900003 | 37.795195129895895 | -122.436904386043 | (37.7951951298959, -122.436904386043) | |||
8942 | 8942 | 19287 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2810X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001358.59585 | 2115648.89401 | 37.7892445650455 | -122.439149150528 | (37.7892445650455, -122.439149150528) | |||
10269 | 10269 | 91500 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 125 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 52121 | 6009901.41754 | 2113830.53604 | 37.784734187987 | -122.40946350553999 | (37.784734187987, -122.40946350554) | |
11199 | 11199 | 79973 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 983 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 773711 | 6000743.92966 | 2091299.8612400002 | 37.722353046939 | -122.439529617696 | (37.722353046939, -122.439529617696) | |
11423 | 11423 | 110030 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 327 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774319 | 6003526.63098 | 2091782.5181900002 | 37.7238362969822 | -122.429944883475 | (37.7238362969822, -122.429944883475) |
12679 | 12679 | 17228 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1880X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000994.2729400005 | 2091122.49333 | 37.721880279621 | -122.43865153853201 | (37.721880279621, -122.438651538532) | |||
14649 | 14649 | 67492 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1119 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2015 12:00:00 AM | 3 | Permit Number 774343 | 6011679.29477 | 2103189.50582 | 37.7556157939465 | -122.40256406509701 | (37.7556157939465, -122.402564065097) | |
19541 | 19541 | 31130 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 127 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 2 | 3x3 | Permit Number 34845 | 5998083.60465 | 2093967.1558599998 | 37.729525044927705 | -122.448917737661 | (37.7295250449277, -122.448917737661) |
20258 | 20258 | 50073 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2622 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46804 | 5991453.86395603 | 2097563.96514649 | 37.739019597898505 | -122.472099259809 | (37.7390195978985, -122.472099259809) | ||
22388 | 22388 | 7124 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005782.02097 | 2115033.60586 | 37.787805844908796 | -122.42380084655301 | (37.7878058449088, -122.423800846553) | ||
22516 | 22516 | 7126 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005719.585390001 | 2115024.0954299998 | 37.7877762068484 | -122.42401618562201 | (37.7877762068484, -122.424016185622) | ||
22560 | 22560 | 7122 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 3 | 3x3 | 6005816.457909999 | 2115038.11546 | 37.787820171109 | -122.423682021812 | (37.787820171109, -122.423682021812) | ||
22574 | 22574 | 7125 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005738.176580001 | 2115026.96294 | 37.7877851299198 | -122.42395206753099 | (37.7877851299198, -122.423952067531) | ||
22588 | 22588 | 7129 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 4 | 3X3 | 6005508.68317 | 2114972.6560299997 | 37.787623057713496 | -122.424742207381 | (37.7876230577135, -122.424742207381) | ||
22606 | 22606 | 7130 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 5 | 3X3 | 6005539.58789 | 2114975.93468 | 37.7876338054953 | -122.42463551632 | (37.7876338054953, -122.42463551632) | ||
22660 | 22660 | 28058 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 7 | 3X3 | 6005467.0390099995 | 2114965.36006 | 37.7876006726807 | -122.424885768876 | (37.7876006726807, -122.424885768876) | ||
22690 | 22690 | 28059 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 3 | 3X3 | 6005443.48959 | 2114960.28563 | 37.7875854093804 | -122.42496688413 | (37.7875854093804, -122.42496688413) | ||
22731 | 22731 | 7128 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 12 | 3X3 | 6005491.12747 | 2114969.49683 | 37.787613391789705 | -122.424802721882 | (37.7876133917897, -122.424802721882) | ||
22801 | 22801 | 7123 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 9 | 3x3 | 6005797.9204 | 2115035.94869 | 37.7878131752727 | -122.42374600408701 | (37.7878131752727, -122.423746004087) | ||
22809 | 22809 | 125505 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 45 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6007613.99229 | 2119386.63886 | 37.799861442220895 | -122.41777122496 | (37.7998614422209, -122.41777122496) | ||||
23721 | 23721 | 220632 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 18 Kronquist Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 6002213.33941 | 2100174.25358 | 37.746803608795396 | -122.43508461868299 | (37.7468036087954, -122.435084618683) | |||
24123 | 24123 | 175160 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000093.42571 | 2092311.2225 | 37.7250929691415 | -122.44185080298 | (37.7250929691415, -122.44185080298) | |||
24159 | 24159 | 33290 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 166 Sproule Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 8 | Permit Number 37451 | 6009219.4283 | 2116994.47406 | 37.7933833601996 | -122.41204664625499 | (37.7933833601996, -122.412046646255) | |
24227 | 24227 | 203475 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2357 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991280.398630001 | 2099387.14513 | 37.7440155431828 | -122.472831922275 | (37.7440155431828, -122.472831922275) | |||
24295 | 24295 | 249534 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6006252.357009999 | 2114034.72493 | 37.785089704362704 | -122.422102579373 | (37.7850897043627, -122.422102579373) | |||
24395 | 24395 | 92752 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3356 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999300.27951 | 2120375.08626 | 37.8021040941904 | -122.446610827352 | (37.8021040941904, -122.446610827352) | |
24476 | 24476 | 189185 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6013378.5695400005 | 2110827.99397 | 37.7766841099114 | -122.397223005848 | (37.7766841099114, -122.397223005848) | |||
24633 | 24633 | 220637 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 79 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003700.73164 | 2096802.6587900002 | 37.7376303323698 | -122.429700927958 | (37.7376303323698, -122.429700927958) | |||
25088 | 25088 | 189157 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012230.29612 | 2112453.73281 | 37.78108402055079 | -122.40130951984501 | (37.7810840205508, -122.401309519845) | |||
25297 | 25297 | 203469 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 300 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998711.4385400005 | 2094111.50955 | 37.7299572914866 | -122.446757644361 | (37.7299572914866, -122.446757644361) | ||||
25528 | 25528 | 33293 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 166 Sproule Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 10 | Permit Number 37451 | 6009221.08576 | 2116982.79677 | 37.7933513902069 | -122.412040085683 | (37.7933513902069, -122.412040085683) | |
26278 | 26278 | 249950 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6011359.33086 | 2120056.95578 | 37.801912024192795 | -122.404858102512 | (37.8019120241928, -122.404858102512) | |||
26400 | 26400 | 203471 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 410 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5994790.95036 | 2091337.27547 | 37.7221151744519 | -122.460110243003 | (37.7221151744519, -122.460110243003) | |||
26515 | 26515 | 220605 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 51 Arnold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6006588.43416 | 2095556.2784900002 | 37.7343711416034 | -122.419628336682 | (37.7343711416034, -122.419628336682) | |||
26824 | 26824 | 125535 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010079.40223 | 2116881.04203 | 37.7931201160419 | -122.409063053629 | (37.7931201160419, -122.409063053629) | |||
27160 | 27160 | 203449 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1474 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992141.42239 | 2105406.9692 | 37.7605942249661 | -122.47029301742901 | (37.7605942249661, -122.470293017429) | |||
27258 | 27258 | 220664 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1192 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003819.11819 | 2101351.9934400003 | 37.7501284581809 | -122.429615973494 | (37.7501284581809, -122.429615973494) | |||
27386 | 27386 | 220596 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 452 Shotwell St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007814.59662 | 2105186.38117 | 37.7608822364448 | -122.416070852512 | (37.7608822364448, -122.416070852512) | |||
27524 | 27524 | 189155 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012260.87565 | 2112478.52323 | 37.7811537953404 | -122.40120547186899 | (37.7811537953404, -122.401205471869) | |||
27556 | 27556 | 220598 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Sycamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006787.43083 | 2105854.6831099996 | 37.7626594317184 | -122.41967079188801 | (37.7626594317184, -122.419670791888) | |||
28260 | 28260 | 92446 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1554 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52837 | 5981923.4 | 2104509.6 | 37.7575342433798 | -122.505565385243 | (37.7575342433798, -122.505565385243) |
28352 | 28352 | 125438 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 250 Euclid Ave | 0 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5998091.24108 | 2114006.2469099998 | 37.78454782955 | -122.45033529224199 | (37.78454782955, -122.450335292242) | ||||
28571 | 28571 | 203474 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 663 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5991409.42461 | 2097303.39162 | 37.7383015575699 | -122.472233919881 | (37.7383015575699, -122.472233919881) | |||
29119 | 29119 | 220589 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 653 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002332.20411 | 2099716.00641 | 37.7455521185496 | -122.43464083471301 | (37.7455521185496, -122.434640834713) | |||
30036 | 30036 | 92979 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 147 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2010 12:00:00 AM | 5 | Permit Number 53131 | 6009891.19153 | 2113906.4761 | 37.78494212831 | -122.40950424575001 | (37.78494212831, -122.40950424575) | ||
30635 | 30635 | 125520 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008570.50339 | 2119026.46396 | 37.798926272277704 | -122.414435828363 | (37.7989262722777, -122.414435828363) | |||
30740 | 30740 | 221771 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001803.9521 | 2096539.96195 | 37.7368014398277 | -122.436240194438 | (37.7368014398277, -122.436240194438) | |||
30833 | 30833 | 220633 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 18 Kronquist Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 6002213.10405 | 2100169.21088 | 37.7467897493647 | -122.435085071929 | (37.7467897493647, -122.435085071929) | |||
31097 | 31097 | 123452 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 735 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995332.97895 | 2110593.9249 | 37.7750202604257 | -122.459630642924 | (37.7750202604257, -122.459630642924) | |||
31567 | 31567 | 203453 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2658 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991457.8354 | 2097316.5348 | 37.738340446961104 | -122.47206749851001 | (37.7383404469611, -122.47206749851) | |||
31581 | 31581 | 70151 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 846 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1993 12:00:00 AM | 7 | 6007647.41454 | 2114440.4952 | 37.786282435643 | -122.41730487074699 | (37.786282435643, -122.417304870747) | ||
31786 | 31786 | 221763 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3816 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002948.3546400005 | 2103602.92928 | 37.7562596509731 | -122.432787903054 | (37.7562596509731, -122.432787903054) | |||
31793 | 31793 | 221773 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6001626.70915 | 2097120.97663 | 37.7383866990834 | -122.436894581628 | (37.7383866990834, -122.436894581628) | |||
31906 | 31906 | 220602 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 345 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003653.16044 | 2099206.97915 | 37.744229349819896 | -122.43003686791401 | (37.7442293498199, -122.430036867914) | |||
32542 | 32542 | 221762 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4407 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001705.956180001 | 2104074.38405 | 37.7574836102927 | -122.43711828977399 | (37.7574836102927, -122.437118289774) | |||
33240 | 33240 | 189153 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012332.534469999 | 2112551.48713 | 37.781358134807796 | -122.400962694499 | (37.7813581348078, -122.400962694499) | |||
33358 | 33358 | 220588 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1285 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010337.44954 | 2101779.52105 | 37.7516692837277 | -122.40710522684499 | (37.7516692837277, -122.407105226845) |
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");