Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92394 | 92394 | 115737 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 9x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776557 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 20380 | 20380 | 112084 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.790527840543795 | -122.396700174955 | (37.7905278405438, -122.396700174955) | |||
| 104211 | 104211 | 112085 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.790527840543795 | -122.396700174955 | (37.7905278405438, -122.396700174955) | |||
| 61836 | 61836 | 81719 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 4 | 6014948.610719999 | 2104053.54358 | 37.7581702363807 | -122.391318049186 | (37.7581702363807, -122.391318049186) | ||
| 73430 | 73430 | 81717 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 5 | 6014951.75745 | 2104011.46368 | 37.758054868645395 | -122.391304224825 | (37.7580548686454, -122.391304224825) | ||
| 179748 | 179748 | 81721 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 3 | 6014944.54926 | 2104094.31483 | 37.7582819600733 | -122.39133494567301 | (37.7582819600733, -122.391334945673) | ||
| 187818 | 187818 | 81723 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 4 | 6014945.424980001 | 2104137.64024 | 37.7584009709475 | -122.39133494566201 | (37.7584009709475, -122.391334945662) | ||
| 133287 | 133287 | 141982 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 961 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004375.3351 | 2111847.7501 | 37.7789787686216 | -122.42844055250099 | (37.7789787686216, -122.428440552501) | |||
| 171213 | 171213 | 141981 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 961 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004347.2458 | 2111841.6916 | 37.778960543925706 | -122.42853729271098 | (37.7789605439257, -122.428537292711) | |||
| 144044 | 144044 | 115738 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 95x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776553 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 115466 | 115466 | 14755 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 950X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2013 12:00:00 AM | 0 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | ||
| 38969 | 38969 | 203414 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 95 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993945.5640199995 | 2096868.34313 | 37.7372534705646 | -122.463433702031 | (37.7372534705646, -122.463433702031) | |||
| 162583 | 162583 | 203415 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 95 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993910.70196 | 2096889.9014700002 | 37.7373106557719 | -122.463555799377 | (37.7373106557719, -122.463555799377) | |||
| 16093 | 16093 | 86683 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 925 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011000.86666 | 2109774.4042 | 37.7736585378513 | -122.40537400761299 | (37.7736585378513, -122.405374007613) | ||
| 46232 | 46232 | 189059 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 925 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011015.17329 | 2109787.29138 | 37.7736947229667 | -122.405325426246 | (37.7736947229667, -122.405325426246) | |||
| 31263 | 31263 | 137681 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001487.0408 | 2111552.8208 | 37.7780051017696 | -122.438411165508 | (37.7780051017696, -122.438411165508) | |||
| 31984 | 31984 | 137765 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001461.6592 | 2111740.6449 | 37.7785193755481 | -122.438512430085 | (37.7785193755481, -122.438512430085) | |||
| 41056 | 41056 | 138174 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001486.0255 | 2111568.0498 | 37.778046859007894 | -122.438415769146 | (37.7780468590079, -122.438415769146) | |||
| 42445 | 42445 | 138175 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001483.6566 | 2111580.5714 | 37.778081105415396 | -122.438424861346 | (37.7780811054154, -122.438424861346) | |||
| 69865 | 69865 | 137769 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001467.7508 | 2111695.2964 | 37.7783952065367 | -122.43848810700199 | (37.7783952065367, -122.438488107002) | |||
| 160328 | 160328 | 137670 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001482.6413 | 2111596.1388 | 37.7781237918135 | -122.438429489247 | (37.7781237918135, -122.438429489247) | |||
| 165495 | 165495 | 137770 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001464.705 | 2111708.8332 | 37.778432201915 | -122.43849961368099 | (37.778432201915, -122.438499613681) | |||
| 2522 | 2522 | 141925 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900 MCALLISTER ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2013 12:00:00 AM | 2 | Width 0ft | 6004344.9249 | 2111897.598 | 37.7791139177501 | -122.42854930773399 | (37.7791139177501, -122.428549307734) | ||
| 2536 | 2536 | 141924 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 900 MCALLISTER ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004374.9759 | 2111902.445 | 37.7791289269844 | -122.428445694629 | (37.7791289269844, -122.428445694629) | |||
| 43633 | 43633 | 203422 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 9 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993354.866669999 | 2097295.22775 | 37.738391538344004 | -122.465506999949 | (37.738391538344, -122.465506999949) | |||
| 136169 | 136169 | 187963 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 887 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011307.83557 | 2110065.72968 | 37.7744756087874 | -122.404332658345 | (37.7744756087874, -122.404332658345) | |||
| 15073 | 15073 | 86684 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 855 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778066 | 6011500.82378 | 2110252.42097 | 37.7749990025284 | -122.403678209983 | (37.7749990025284, -122.403678209983) | |
| 187239 | 187239 | 220477 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 851 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998019.7394900005 | 2107271.17336 | 37.766050965816895 | -122.45009705375601 | (37.7660509658169, -122.450097053756) | |||
| 54946 | 54946 | 220476 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 849 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998017.46753 | 2107292.9322 | 37.7661105800595 | -122.45010648043501 | (37.7661105800595, -122.450106480435) | |||
| 236 | 236 | 8118 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 841 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6003718.373 | 2111409.0283 | 37.777736949412606 | -122.430681932079 | (37.7777369494126, -122.430681932079) | ||
| 13682 | 13682 | 86688 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 833 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011619.91608 | 2110365.80085 | 37.7753169695418 | -122.403274219231 | (37.7753169695418, -122.403274219231) | ||
| 15935 | 15935 | 86687 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 833 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011571.17232 | 2110322.10121 | 37.7751942579517 | -122.40343976104602 | (37.7751942579517, -122.403439761046) | ||
| 15954 | 15954 | 86690 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 833 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011662.16026 | 2110406.91689 | 37.7754322239569 | -122.40313097880801 | (37.7754322239569, -122.403130978808) | ||
| 16419 | 16419 | 86689 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 833 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011647.231000001 | 2110392.1587400003 | 37.775390867731794 | -122.40318158457701 | (37.7753908677318, -122.403181584577) | ||
| 182213 | 182213 | 125408 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 830 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006361.841019999 | 2113219.81406 | 37.7828583334858 | -122.42166589828001 | (37.7828583334858, -122.42166589828) | |||
| 182448 | 182448 | 140603 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 827 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003831.5032 | 2111426.0587 | 37.77779011925529 | -122.430291791287 | (37.7777901192553, -122.430291791287) | |||
| 2719 | 2719 | 141993 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 818 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2008 12:00:00 AM | 2 | Width 0ft | 6003993.152000001 | 2111582.4748 | 37.778228754000004 | -122.429743751351 | (37.778228754, -122.429743751351) | ||
| 44821 | 44821 | 189058 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 811 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011753.69364 | 2110494.1907 | 37.7756769690586 | -122.402820480686 | (37.7756769690586, -122.402820480686) | |||
| 1475 | 1475 | 187957 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 81 Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014291.0 | 2114089.0 | 37.78568884516871 | -122.39429498812099 | (37.7856888451687, -122.394294988121) | |||
| 117008 | 117008 | 102934 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 801X Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6004394.3 | 2104124.7 | 37.757774211767796 | -122.427824502367 | (37.7577742117678, -122.427824502367) | |||
| 57203 | 57203 | 187865 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 801 Arkansas St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6013076.18705 | 2103452.55665 | 37.7564159621389 | -122.397751590464 | (37.7564159621389, -122.397751590464) | ||||
| 67269 | 67269 | 187864 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 801 Arkansas St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013072.09173 | 2103413.5567099997 | 37.7563086487315 | -122.397763018152 | (37.7563086487315, -122.397763018152) | ||||
| 43311 | 43311 | 137723 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 800x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001529.3435 | 2111250.6101 | 37.7771777134961 | -122.438243170212 | (37.7771777134961, -122.438243170212) | |||
| 56668 | 56668 | 137724 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 800x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001530.3588 | 2111236.3964 | 37.7771387440026 | -122.438238639478 | (37.7771387440026, -122.438238639478) | |||
| 58018 | 58018 | 137714 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 800x DIVISADERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001518.8525 | 2111334.8771 | 37.777408492754 | -122.43828550021799 | (37.777408492754, -122.438285500218) | |||
| 92373 | 92373 | 137709 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 800x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001515.4682 | 2111357.213 | 37.7774696290159 | -122.43829880815399 | (37.7774696290159, -122.438298808154) | |||
| 156490 | 156490 | 137690 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 800x DIVISADERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001528.3283 | 2111273.6228 | 37.7772408428317 | -122.43824833111 | (37.7772408428317, -122.43824833111) | |||
| 168192 | 168192 | 137721 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 800x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001519.5293 | 2111318.2945 | 37.7773629996088 | -122.438281970677 | (37.7773629996088, -122.438281970677) | |||
| 173360 | 173360 | 137725 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 800x DIVISADERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001532.7277 | 2111225.9053 | 37.7771100728165 | -122.438229692976 | (37.7771100728165, -122.438229692976) | |||
| 165105 | 165105 | 220486 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 80 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005005.11226 | 2096160.1953200002 | 37.73594004669339 | -122.42514535727899 | (37.7359400466934, -122.425145357279) | |||
| 32027 | 32027 | 187962 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 787 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011933.30583 | 2110670.66458 | 37.7761715530167 | -122.402211564127 | (37.7761715530167, -122.402211564127) | |||
| 153298 | 153298 | 139872 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 780 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6005375.5264 | 2112045.3539 | 37.7795778880823 | -122.424994549274 | (37.7795778880823, -122.424994549274) | |||
| 1377 | 1377 | 8105 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 780 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 8 | 3X3 | 6004061.6732 | 2111513.0828 | 37.7780421005615 | -122.42950176141899 | (37.7780421005615, -122.429501761419) | ||
| 174214 | 174214 | 141990 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 780 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004028.4702 | 2111508.2869 | 37.778027052231394 | -122.42961628033301 | (37.7780270522314, -122.429616280333) | |||
| 29587 | 29587 | 139865 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 752 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005530.836 | 2112064.5728 | 37.7796394301742 | -122.42445863354601 | (37.7796394301742, -122.424458633546) | |||
| 68972 | 68972 | 203416 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 75 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993822.50089 | 2096951.1599400002 | 37.7374737738828 | -122.463865194036 | (37.7374737738828, -122.463865194036) | |||
| 177732 | 177732 | 123077 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 723 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992233.23043 | 2110491.18489 | 37.774559431962 | -122.47034576378599 | (37.774559431962, -122.470345763786) | |||
| 109241 | 109241 | 14667 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 716 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | 3 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | ||
| 131469 | 131469 | 139862 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 716 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005633.1637 | 2112080.6752 | 37.7796894214359 | -122.424105782878 | (37.7796894214359, -122.424105782878) | |||
| 161235 | 161235 | 139864 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 716 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005563.5601 | 2112069.7671 | 37.779655540357105 | -122.424345796171 | (37.7796555403571, -122.424345796171) | |||
| 176057 | 176057 | 139863 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 716 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005598.3619 | 2112075.4809 | 37.7796731941675 | -122.42422580803002 | (37.7796731941675, -122.42422580803) | |||
| 165831 | 165831 | 139861 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 710 McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005666.4072 | 2112084.3112 | 37.779701281894205 | -122.42399103767299 | (37.7797012818942, -122.423991037673) | |||
| 25058 | 25058 | 141590 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001558.8965 | 2111018.1096 | 37.776541006446706 | -122.438124278141 | (37.7765410064467, -122.438124278141) | |||
| 32188 | 32188 | 141618 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001576.0331 | 2110923.0014 | 37.77628083782329 | -122.438058183449 | (37.7762808378233, -122.438058183449) | |||
| 43028 | 43028 | 141617 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001580.3173 | 2110897.2965 | 37.776210502271105 | -122.43804152155 | (37.7762105022711, -122.43804152155) | |||
| 43821 | 43821 | 141616 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001582.0309 | 2110873.3052 | 37.7761447256429 | -122.43803387483601 | (37.7761447256429, -122.438033874836) | |||
| 118100 | 118100 | 141592 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001554.6124 | 2111065.2353 | 37.776670158115294 | -122.438142474688 | (37.7766701581153, -122.438142474688) | |||
| 132291 | 132291 | 141589 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001563.1807 | 2110994.9752 | 37.7764777288536 | -122.438107800298 | (37.7764777288536, -122.438107800298) | |||
| 166093 | 166093 | 141605 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001571.749 | 2110948.7063 | 37.776351173378 | -122.438074845035 | (37.776351173378, -122.438074845035) | |||
| 176178 | 176178 | 141591 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001556.326 | 2111042.9577 | 37.776609086888 | -122.438134950627 | (37.776609086888, -122.438134950627) | |||
| 152080 | 152080 | 189088 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 693 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009010.6716 | 2111090.1227700002 | 37.7771597163869 | -122.412351439063 | (37.7771597163869, -122.412351439063) | |||
| 78007 | 78007 | 121222 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 690 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6007452.0 | 2105652.0 | 37.7621403241605 | -122.417357915219 | (37.7621403241605, -122.417357915219) | |||
| 81914 | 81914 | 87428 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 688X McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6005853.5155 | 2112100.03893 | 37.7797550282384 | -122.423344866205 | (37.7797550282384, -122.423344866205) | |||
| 94226 | 94226 | 9751 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 688X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/25/2006 12:00:00 AM | 3 | 3x3 | 6005981.3683502 | 2112123.5425617 | 37.7798267784404 | -122.422904237561 | (37.7798267784404, -122.422904237561) | ||
| 139982 | 139982 | 9750 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 688X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/25/2006 12:00:00 AM | 3 | 3x3 | 6005981.3683502 | 2112123.5425617 | 37.7798267784404 | -122.422904237561 | (37.7798267784404, -122.422904237561) | ||
| 45122 | 45122 | 47957 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 681 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2002 12:00:00 AM | 7 | Permit Number 45687 | 6014451.3801 | 2103976.60292 | 37.757931365663204 | -122.393032317982 | (37.7579313656632, -122.393032317982) | ||
| 24181 | 24181 | 125409 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 680 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005915.1308699995 | 2112115.06535 | 37.7797997643918 | -122.42313277978 | (37.7797997643918, -122.42313277978) | |||
| 29247 | 29247 | 125411 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 680 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6005845.66481 | 2112104.7354 | 37.7797674805156 | -122.423372359172 | (37.7797674805156, -122.423372359172) | |||
| 134499 | 134499 | 125410 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 680 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005899.660080001 | 2112113.57436 | 37.77979479743679 | -122.423186194101 | (37.7797947974368, -122.423186194101) | |||
| 36136 | 36136 | 125413 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 677 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6005987.46942 | 2112075.6403900003 | 37.7796955950146 | -122.42287972583999 | (37.7796955950146, -122.42287972584) | |||
| 67525 | 67525 | 125412 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 677 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6005967.2010699995 | 2112072.2293700003 | 37.779685085531 | -122.42294960046999 | (37.779685085531, -122.42294960047) | |||
| 64479 | 64479 | 189063 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 670 08th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011103.55748 | 2108718.67114 | 37.7707654781809 | -122.40494443566001 | (37.7707654781809, -122.40494443566) | |||
| 74004 | 74004 | 189061 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 670 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011084.455490001 | 2108738.6767700003 | 37.770819341272 | -122.40501191898399 | (37.770819341272, -122.405011918984) | |||
| 76458 | 76458 | 189060 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 670 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011065.32352 | 2108759.62205 | 37.7708757827119 | -122.405079572281 | (37.7708757827119, -122.405079572281) | |||
| 177676 | 177676 | 189062 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 670 08th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011094.42559 | 2108729.00589 | 37.7707933445767 | -122.404976750984 | (37.7707933445767, -122.404976750984) | |||
| 40080 | 40080 | 175138 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 67 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6004374.522580001 | 2093135.8569099999 | 37.7276002475407 | -122.427110209575 | (37.7276002475407, -122.427110209575) | |||
| 83319 | 83319 | 115736 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 66 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776551 | 5993801.4 | 2096894.7 | 37.7373175329251 | -122.463934052027 | (37.7373175329251, -122.463934052027) | ||
| 33720 | 33720 | 42228 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 66 Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 2 | Permit Number 42484 | 6014289.84402 | 2114150.2532200003 | 37.7858569681792 | -122.394303277683 | (37.7858569681792, -122.394303277683) | |
| 84517 | 84517 | 14652 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 655X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2008 12:00:00 AM | 3 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.779703716761496 | -122.422781416289 | (37.7797037167615, -122.422781416289) | ||
| 116615 | 116615 | 14653 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 655X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2008 12:00:00 AM | 3 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.779703716761496 | -122.422781416289 | (37.7797037167615, -122.422781416289) | ||
| 29539 | 29539 | 38792 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 655 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/19/2001 12:00:00 AM | 3 | Permit Number 43810 | 6012704.44378 | 2111400.47389 | 37.778218455863296 | -122.399595224034 | (37.7782184558633, -122.399595224034) | |
| 64172 | 64172 | 38793 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 655 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | 6 | Permit Number 40642 | 6012718.22828 | 2111411.20954 | 37.7782487018563 | -122.39954829202499 | (37.7782487018563, -122.399548292025) | ||
| 42447 | 42447 | 42181 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 649 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 4 | Permit Number 42465 | 6012754.97243 | 2111452.86272 | 37.778365119997204 | -122.399424104664 | (37.7783651199972, -122.399424104664) | |
| 59465 | 59465 | 189069 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 639 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012927.18586 | 2111608.3632799997 | 37.778801685994 | -122.398839266512 | (37.778801685994, -122.398839266512) | |||
| 78501 | 78501 | 48548 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 630(REVISED) 08th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.40499689848801 | (37.7708540159333, -122.404996898488) | |||
| 80273 | 80273 | 48549 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 630(REVISED) 08th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.40499689848801 | (37.7708540159333, -122.404996898488) | |||
| 109224 | 109224 | 48551 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 630(REVISED) 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.40499689848801 | (37.7708540159333, -122.404996898488) | |||
| 125610 | 125610 | 48550 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 630(REVISED) 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.40499689848801 | (37.7708540159333, -122.404996898488) | |||
| 27237 | 27237 | 141321 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 600x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001606.879 | 2110711.3642 | 37.7757014893927 | -122.437936316665 | (37.7757014893927, -122.437936316665) | |||
| 50549 | 50549 | 141324 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 600x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001611.1632 | 2110665.9521 | 37.7755770427913 | -122.43791824313499 | (37.7755770427913, -122.437918243135) |
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");