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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 119097 | 119097 | 8435 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1730 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/1997 12:00:00 AM | 13 | 3X3 | 6003010.73492 | 2113853.74303 | 37.784409407274 | -122.433304626878 | (37.784409407274, -122.433304626878) | ||
| 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) | |||
| 126087 | 126087 | 16391 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 248X Myrtle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2003 12:00:00 AM | 3 | 3X3 | 6006237.34556 | 2114081.50477 | 37.785217303604796 | -122.422157838958 | (37.7852173036048, -122.422157838958) | ||
| 79867 | 79867 | 16399 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 12 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 122310 | 122310 | 16400 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2005 12:00:00 AM | 3 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 84998 | 84998 | 16401 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 145083 | 145083 | 16402 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 121736 | 121736 | 16403 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 90762 | 90762 | 16404 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 94567 | 94567 | 16912 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 474 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3X3 | 6004730.16481 | 2110223.37403 | 37.774538702608396 | -122.42709732349701 | (37.7745387026084, -122.427097323497) | |||
| 106158 | 106158 | 16913 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 477 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004718.6652 | 2110142.96999 | 37.774317282432705 | -122.42713137468999 | (37.7743172824327, -122.42713137469) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 140160 | 140160 | 17102 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1711 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998685.53291 | 2109300.56616 | 37.771661239802 | -122.44794034143601 | (37.771661239802, -122.447940341436) | |||
| 124922 | 124922 | 17121 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1931 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997743.8504099995 | 2109170.01524 | 37.7712489089965 | -122.45118824582701 | (37.7712489089965, -122.451188245827) | |||
| 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) | |||
| 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) | |||
| 102801 | 102801 | 18245 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1815X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003482.1216 | 2114150.20266 | 37.7852501414757 | -122.43169496628599 | (37.7852501414757, -122.431694966286) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 117237 | 117237 | 24504 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 360X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005526.31532 | 2114998.99681 | 37.787696378772296 | -122.424683078077 | (37.7876963787723, -122.424683078077) | |||
| 139087 | 139087 | 24505 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 360X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005509.85054 | 2114996.70292 | 37.787689150419 | -122.424739879851 | (37.787689150419, -122.424739879851) | |||
| 97534 | 97534 | 24506 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 360X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6005494.49314 | 2114994.9262200003 | 37.7876834046589 | -122.424792887097 | (37.7876834046589, -122.424792887097) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 124461 | 124461 | 30606 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 40 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.41969788695299 | (37.773818193258, -122.419697886953) | ||
| 142306 | 142306 | 30607 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 40 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 3x3 | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.41969788695299 | (37.773818193258, -122.419697886953) | |
| 92107 | 92107 | 30608 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 40 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.41969788695299 | (37.773818193258, -122.419697886953) | ||
| 93613 | 93613 | 30702 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 361 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34614 | 6005271.42565012 | 2110238.90565505 | 37.7746119412537 | -122.425226100731 | (37.7746119412537, -122.425226100731) | ||
| 167943 | 167943 | 31087 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 61 Pearl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 10 | Permit Number 34823 | 6005643.9795699995 | 2108712.30745 | 37.7704413103375 | -122.42382878848 | (37.7704413103375, -122.42382878848) | |
| 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) |
| 128603 | 128603 | 31948 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1677 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35359 | 6005487.56868066 | 2115128.64858681 | 37.7880501818667 | -122.424826361466 | (37.7880501818667, -122.424826361466) | ||
| 112653 | 112653 | 31949 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1677 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35359 | 6005487.56868066 | 2115128.64858681 | 37.7880501818667 | -122.424826361466 | (37.7880501818667, -122.424826361466) | ||
| 142122 | 142122 | 31950 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1677 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35359 | 6005487.56868066 | 2115128.64858681 | 37.7880501818667 | -122.424826361466 | (37.7880501818667, -122.424826361466) | ||
| 108878 | 108878 | 31957 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 935 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35362 | 6006823.22516911 | 2113923.34802193 | 37.7848160720716 | -122.42011964381001 | (37.7848160720716, -122.42011964381) | ||
| 80090 | 80090 | 32128 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 45 Ross Aly | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35490 | 6010568.1937078 | 2117713.19841403 | 37.7954323857446 | -122.407430491589 | (37.7954323857446, -122.407430491589) | ||
| 143941 | 143941 | 32129 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 35 Spofford Ln | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35491 | 6010554.96159279 | 2117351.45133924 | 37.7944383752725 | -122.407450761229 | (37.7944383752725, -122.407450761229) | ||
| 138919 | 138919 | 32133 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 842 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35494 | 6010631.11006318 | 2117599.53652258 | 37.795123819025704 | -122.407204773258 | (37.7951238190257, -122.407204773258) | ||
| 92731 | 92731 | 32134 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 842 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35494 | 6010631.11006318 | 2117599.53652258 | 37.795123819025704 | -122.407204773258 | (37.7951238190257, -122.407204773258) | ||
| 79612 | 79612 | 32135 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 858 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35495 | 6010580.68586277 | 2117592.53204935 | 37.7951017643418 | -122.40737875552 | (37.7951017643418, -122.40737875552) | ||
| 104718 | 104718 | 32136 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 858 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35495 | 6010580.68586277 | 2117592.53204935 | 37.7951017643418 | -122.40737875552 | (37.7951017643418, -122.40737875552) | ||
| 92319 | 92319 | 32141 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 163X Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35497 | 6006158.88889094 | 2110709.34290145 | 37.775953744351895 | -122.422189614353 | (37.7759537443519, -122.422189614353) | ||
| 96760 | 96760 | 32142 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 163X Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35497 | 6006158.88889094 | 2110709.34290145 | 37.775953744351895 | -122.422189614353 | (37.7759537443519, -122.422189614353) | ||
| 43148 | 43148 | 32487 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 257 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 5 | Permit Number 36994 | 6000562.081590001 | 2106647.6707099997 | 37.7644841354656 | -122.441258885382 | (37.7644841354656, -122.441258885382) | |
| 72861 | 72861 | 32513 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 777 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 12 | Permit Number 37015 | 6007618.09597 | 2095855.6295900003 | 37.735251041008794 | -122.416089643829 | (37.7352510410088, -122.416089643829) | |
| 159116 | 159116 | 32706 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 1 | Permit Number 37107 | 6007669.19829 | 2115867.15124 | 37.790200909505 | -122.417330642617 | (37.790200909505, -122.417330642617) | |
| 143853 | 143853 | 32707 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.41730640574801 | (37.7900973284958, -122.417306405748) | ||
| 92432 | 92432 | 32708 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.41730640574801 | (37.7900973284958, -122.417306405748) | ||
| 90795 | 90795 | 32709 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.41730640574801 | (37.7900973284958, -122.417306405748) | ||
| 144926 | 144926 | 33001 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 255 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | ||
| 93445 | 93445 | 33004 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 255 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | ||
| 89567 | 89567 | 33006 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 255 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | ||
| 156178 | 156178 | 33132 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2927 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | 4x5 | Permit Number 37362 | 6001472.71004 | 2118540.58919 | 37.7971908999849 | -122.438961648188 | (37.7971908999849, -122.438961648188) |
| 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) | |
| 175782 | 175782 | 33291 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 166 Sproule Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 9 | Permit Number 37451 | 6009219.70147 | 2117007.84258 | 37.7934200822178 | -122.412046646261 | (37.7934200822178, -122.412046646261) | |
| 112518 | 112518 | 33292 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 160 Sproule Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37451 | 6009246.88754349 | 2116916.88448981 | 37.7931718587847 | -122.411946149383 | (37.7931718587847, -122.411946149383) | ||
| 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) | |
| 114430 | 114430 | 33294 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 158 Sproule Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37451 | 6009246.88754349 | 2116916.88448981 | 37.7931718587847 | -122.411946149383 | (37.7931718587847, -122.411946149383) | ||
| 91561 | 91561 | 33364 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.46459211219299 | (37.7276286729381, -122.464592112193) | ||
| 145080 | 145080 | 33365 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.46459211219299 | (37.7276286729381, -122.464592112193) | ||
| 107258 | 107258 | 33366 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 89 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37498 | 5993623.03189123 | 2093524.69495183 | 37.728054050760896 | -122.464306151281 | (37.7280540507609, -122.464306151281) | ||
| 108145 | 108145 | 33367 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 89 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37498 | 5993623.03189123 | 2093524.69495183 | 37.728054050760896 | -122.464306151281 | (37.7280540507609, -122.464306151281) | ||
| 118540 | 118540 | 33368 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498002 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | ||
| 108997 | 108997 | 33369 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498002 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | ||
| 89745 | 89745 | 33370 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498002 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | ||
| 129084 | 129084 | 34184 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2010 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
| 112894 | 112894 | 34186 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
| 77169 | 77169 | 34187 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) |
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");