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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6538 | 6538 | 71898 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 455 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2015 12:00:00 AM | 3 | Permit Number 775644 | 6007926.40343 | 2114015.89838 | 37.7851322881578 | -122.416309554165 | (37.7851322881578, -122.416309554165) | |
| 14670 | 14670 | 108060 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014722.47105 | 2114748.4926400003 | 37.7875236349662 | -122.39284836525299 | (37.7875236349662, -122.392848365253) | ||
| 16307 | 16307 | 108061 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014711.31667 | 2114762.0418700003 | 37.7875602184789 | -122.392887905777 | (37.7875602184789, -122.392887905777) | ||
| 16382 | 16382 | 108062 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014690.02107 | 2114784.12371 | 37.787619667256706 | -122.392963130455 | (37.7876196672567, -122.392963130455) | ||
| 18687 | 18687 | 49144 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 206 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2003 12:00:00 AM | Permit Number 46269 | 5994953.84956095 | 2088734.37736924 | 37.714977603179705 | -122.45935873857901 | (37.7149776031797, -122.459358738579) | |||
| 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) | |||
| 23161 | 23161 | 2363 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2478 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 6009688.22905 | 2102936.69302 | 37.754810266704794 | -122.409431983418 | (37.7548102667048, -122.409431983418) | ||||
| 26254 | 26254 | 116994 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 600M Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6001630.0135 | 2110553.7073 | 37.775269918649705 | -122.43784499428999 | (37.7752699186497, -122.43784499429) | ||||
| 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) | |
| 30838 | 30838 | 187949 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6015269.3196 | 2115112.5908 | 37.7885537238177 | -122.390981820563 | (37.7885537238177, -122.390981820563) | ||||
| 32037 | 32037 | 187942 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015080.74918 | 2115307.92538 | 37.789079602378294 | -122.391647913344 | (37.7890796023783, -122.391647913344) | ||||
| 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) | |
| 37847 | 37847 | 187948 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6015252.9594 | 2115128.97629 | 37.788597806797796 | -122.391039570534 | (37.7885978067978, -122.391039570534) | ||||
| 39657 | 39657 | 187951 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6015307.966030001 | 2115072.7119299998 | 37.7884463699393 | -122.390845320574 | (37.7884463699393, -122.390845320574) | ||||
| 41167 | 41167 | 53357 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/1969 12:00:00 AM | 3 | Permit Number 6250 | 6014738.317419999 | 2114732.62752 | 37.7874809531407 | -122.392792429224 | (37.7874809531407, -122.392792429224) | ||
| 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) | |
| 43908 | 43908 | 62024 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 427 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1985 12:00:00 AM | 5 | Permit Number 22097 | 6014298.34567 | 2112925.54615 | 37.782494675542296 | -122.39418809073099 | (37.7824946755423, -122.394188090731) | ||
| 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) | ||
| 46513 | 46513 | 187943 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015093.730769999 | 2115293.30797 | 37.7890401869059 | -122.391601975949 | (37.7890401869059, -122.391601975949) | ||||
| 47402 | 47402 | 187941 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015065.49236 | 2115322.58848 | 37.7891190169896 | -122.391701726057 | (37.7891190169896, -122.391701726057) | ||||
| 48199 | 48199 | 73737 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 595 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 3 | 6013232.290519999 | 2111907.2745 | 37.7796394233505 | -122.397804754791 | (37.7796394233505, -122.397804754791) | ||
| 48244 | 48244 | 220434 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2x Coso Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6007135.32414 | 2099827.64271 | 37.746130149684 | -122.41804026077601 | (37.746130149684, -122.418040260776) | ||||
| 49996 | 49996 | 187944 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015109.7038 | 2115276.55289 | 37.7889950679055 | -122.391545539018 | (37.7889950679055, -122.391545539018) | ||||
| 50896 | 50896 | 68389 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 122 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 1 | Permit Number 32216 | 6002009.36321 | 2093483.54875 | 37.728420898703604 | -122.43531143848 | (37.7284208987036, -122.43531143848) | |
| 55050 | 55050 | 66327 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1231 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1991 12:00:00 AM | 4 | Permit Number 29446 | 5987052.1054 | 2106857.6987 | 37.7642819711606 | -122.48800101763901 | (37.7642819711606, -122.488001017639) | |
| 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) | ||||
| 58733 | 58733 | 187950 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6015285.41791 | 2115092.62187 | 37.788499786972295 | -122.390924726221 | (37.7884997869723, -122.390924726221) | ||||
| 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) | ||
| 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) | ||
| 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) | ||||
| 69713 | 69713 | 50679 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 320 Clementina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 2 | Permit Number 47253 | 6011906.20035 | 2112760.01525 | 37.781906913717705 | -122.40245227846 | (37.7819069137177, -122.40245227846) | ||
| 69920 | 69920 | 49378 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 522Walbridge Carter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 46344 | 6005189.74904 | 2086240.2488 | 37.7087124637721 | -122.423801855593 | (37.7087124637721, -122.423801855593) | |||
| 70138 | 70138 | 38959 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3186 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | 6 | Permit Number 40754 | 5999542.34025 | 2115724.95595 | 37.7893498954312 | -122.445438624911 | (37.7893498954312, -122.445438624911) | ||
| 71869 | 71869 | 49375 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 522Walbridge Carter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 46344 | 6005207.53082 | 2086275.43702 | 37.708810086982396 | -122.423742899628 | (37.7088100869824, -122.423742899628) | |||
| 72529 | 72529 | 56057 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2857 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/2012 12:00:00 AM | Permit Number 769384 | 6009126.12851397 | 2103311.62297626 | 37.7558082292146 | -122.41140237591999 | (37.7558082292146, -122.41140237592) | |||
| 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) | ||
| 75843 | 75843 | 50681 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 320 Clementina St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 2 | Permit Number 47253 | 6011867.27865 | 2112722.46624 | 37.7818016399861 | -122.402584289042 | (37.7818016399861, -122.402584289042) | ||
| 76766 | 76766 | 50680 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 320 Clementina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 2 | Permit Number 47253 | 6011881.28809 | 2112735.18958 | 37.7818373574415 | -122.40253671761002 | (37.7818373574415, -122.40253671761) | ||
| 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) | |||
| 79454 | 79454 | 49231 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 79775 | 79775 | 51960 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3953 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2005 12:00:00 AM | Permit Number 48181 | 6003479.49286747 | 2101832.63497006 | 37.7514289506507 | -122.43082471383002 | (37.7514289506507, -122.43082471383) | |||
| 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) | |||
| 81986 | 81986 | 49242 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 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) | ||
| 85039 | 85039 | 115729 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 776540 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | |||
| 86745 | 86745 | 115730 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776540 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 90357 | 90357 | 96783 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 219 Prentiss St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | |||
| 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) | ||
| 93788 | 93788 | 96781 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 219 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | |||
| 99081 | 99081 | 49229 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 99260 | 99260 | 60333 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 4051 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1982 12:00:00 AM | Permit Number 19906 | 6002674.88696195 | 2104708.78701715 | 37.7592805573459 | -122.433812685394 | (37.7592805573459, -122.433812685394) | |||
| 99509 | 99509 | 49215 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 100125 | 100125 | 94790 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1985 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | Permit Number 53888 | 5993755.4 | 2101986.9 | 37.751296778417 | -122.464462718314 | (37.751296778417, -122.464462718314) | |||
| 103313 | 103313 | 115731 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 15 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776556 | 5993468.8 | 2097225.0 | 37.7382052810266 | -122.465107977902 | (37.7382052810266, -122.465107977902) | ||
| 103670 | 103670 | 46480 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 425 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2002 12:00:00 AM | Permit Number 44673 | 6005932.49263568 | 2107829.56696454 | 37.7680337988036 | -122.42276807616501 | (37.7680337988036, -122.422768076165) | |||
| 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) | |||
| 105346 | 105346 | 115752 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | ||
| 105474 | 105474 | 87551 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3195 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6011859.438328 | 2090836.432048 | 37.7217069237885 | -122.401073119638 | (37.7217069237885, -122.401073119638) | ||||
| 106147 | 106147 | 96782 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 219 Prentiss St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | |||
| 106998 | 106998 | 92755 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 108123 | 108123 | 49228 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 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) | |||
| 112912 | 112912 | 115733 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 50 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776548 | 5993693.2 | 2096969.0 | 37.7375153061033 | -122.46431353926701 | (37.7375153061033, -122.464313539267) | ||
| 117245 | 117245 | 116958 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 777762 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 124823 | 124823 | 92756 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 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) | |||
| 131057 | 131057 | 53151 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1397@ JENNINGS Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 3 | Permit Number 49077 | 6016183.7166 | 2093547.2272 | 37.7293905172533 | -122.38631399173599 | (37.7293905172533, -122.386313991736) | ||
| 134691 | 134691 | 71335 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 277 Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 1 | 6011311.013780001 | 2111537.1063 | 37.7785158463684 | -122.404425254319 | (37.7785158463684, -122.404425254319) | ||
| 138380 | 138380 | 115753 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 135x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776552 | 5994185.89401 | 2096656.23912 | 37.7366849291808 | -122.46258739592 | (37.7366849291808, -122.46258739592) | ||
| 139076 | 139076 | 115734 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 776555 | 5993732.7 | 2097034.0 | 37.7376960566374 | -122.464181687663 | (37.7376960566374, -122.464181687663) | ||||
| 139175 | 139175 | 49216 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 500 Howard St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 140658 | 140658 | 92758 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 143813 | 143813 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | ||
| 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) | ||
| 144843 | 144843 | 92757 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 145230 | 145230 | 53153 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1397@ JENNINGS Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49077 | 6016165.18448304 | 2093562.93446239 | 37.729432620466596 | -122.386379154297 | (37.7294326204666, -122.386379154297) | ||
| 146206 | 146206 | 115735 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776554 | 5993777.6 | 2097002.8 | 37.737612976998896 | -122.464024183823 | (37.7376129769989, -122.464024183823) | ||
| 148100 | 148100 | 220433 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2x Coso Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6007106.26454 | 2099845.01478 | 37.74617621387571 | -122.41814197679399 | (37.7461762138757, -122.418141976794) | ||||
| 149466 | 149466 | 52126 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 482 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | 5 | Permit Number 48311 | 6005097.5281 | 2110773.3561 | 37.7760695863917 | -122.425865698035 | (37.7760695863917, -122.425865698035) | |
| 150446 | 150446 | 49391 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 522Walbridge Carter St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 46344 | 6005169.44863 | 2086179.03953 | 37.7085432500485 | -122.42386766708599 | (37.7085432500485, -122.423867667086) | |||
| 155503 | 155503 | 72302 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 595 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 5 | 6013261.50947 | 2111935.00833 | 37.779717201230504 | -122.397705618927 | (37.7797172012305, -122.397705618927) | ||
| 158483 | 158483 | 187947 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015161.72984 | 2115222.99296 | 37.7888508922136 | -122.391361788631 | (37.7888508922136, -122.391361788631) | ||||
| 160541 | 160541 | 84875 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1936 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2007 12:00:00 AM | 3 | Permit No. 49244 | 5998519.2047 | 2110389.3497 | 37.7746412516506 | -122.44859410709101 | (37.7746412516506, -122.448594107091) | ||
| 160744 | 160744 | 57791 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/1977 12:00:00 AM | 2 | Permit Number 16718 | 6011755.44922 | 2112615.88032 | 37.781502735900105 | -122.402963669841 | (37.7815027359001, -122.402963669841) | ||
| 163969 | 163969 | 187946 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015145.56326 | 2115239.56325 | 37.788895493169896 | -122.391418882079 | (37.7888954931699, -122.391418882079) | ||||
| 165256 | 165256 | 49372 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 522Walbridge Carter St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 46344 | 6005157.82583 | 2086153.99564 | 37.708473828664204 | -122.42390605733999 | (37.7084738286642, -122.42390605734) | |||
| 170239 | 170239 | 59325 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 345 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/1990 12:00:00 AM | 12 | Permit Number 29282 | 6006158.21098 | 2111403.55582 | 37.7778598467005 | -122.42224129259701 | (37.7778598467005, -122.422241292597) | ||
| 173013 | 173013 | 109047 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2146 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6000527.7493 | 2120317.86339 | 37.802017012842995 | -122.44235909620701 | (37.802017012843, -122.442359096207) | ||||
| 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) | ||
| 182424 | 182424 | 187945 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015129.7605099995 | 2115255.3706 | 37.7889380194338 | -122.391474663423 | (37.7889380194338, -122.391474663423) | ||||
| 182547 | 182547 | 30769 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1642 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 7 | Permit Number 34649 | 6014556.9626 | 2093085.2912 | 37.7280319553097 | -122.391905589486 | (37.7280319553097, -122.391905589486) | |
| 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) | ||
| 189078 | 189078 | 187940 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015048.62855 | 2115342.19505 | 37.7891719160015 | -122.39176144464899 | (37.7891719160015, -122.391761444649) | ||||
| 82990 | 82990 | 122582 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2500X Lyon St | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 6 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
| 35251 | 35251 | 121502 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | |||
| 38160 | 38160 | 121504 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014396.4001 | 2115093.29031 | 37.7884522533286 | -122.39400066032499 | (37.7884522533286, -122.394000660325) | |||
| 46572 | 46572 | 121505 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014377.50413 | 2115113.61118 | 37.7885069995398 | -122.394067461056 | (37.7885069995398, -122.394067461056) | |||
| 60824 | 60824 | 121501 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014441.60375 | 2115047.86993 | 37.7883300516388 | -122.39384108102101 | (37.7883300516388, -122.393841081021) | |||
| 151686 | 151686 | 121503 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014412.49464 | 2115075.87435 | 37.7884053276005 | -122.39394375569401 | (37.7884053276005, -122.393943755694) | |||
| 350 | 350 | 85805 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627.0 | 2111882.0 | 37.77948049775679 | -122.40335640121799 | (37.7794804977568, -122.403356401218) |
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");