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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1371 | 1371 | 251505 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011658.68026 | 2112523.0235200003 | 37.781242368680296 | -122.403291911611 | (37.7812423686803, -122.403291911611) | ||||
| 1452 | 1452 | 251537 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 25 Essex St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.0 | 2114247.0 | 37.7861081097809 | -122.395212511502 | (37.7861081097809, -122.395212511502) | ||||
| 18035 | 18035 | 101991 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 25 Essex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | ||||
| 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) | |||
| 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) | |||
| 78293 | 78293 | 118379 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 78470 | 78470 | 121547 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 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) | |||
| 79061 | 79061 | 88150 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300X Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270.0 | 2112782.0 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | ||
| 79273 | 79273 | 121543 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 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) | |||
| 80390 | 80390 | 91046 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2574 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2008 12:00:00 AM | 3x3 | Permit Number 51958 | 6010972.0 | 2093540.2 | 37.7290813641679 | -122.404330986626 | (37.7290813641679, -122.404330986626) | ||
| 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) | |||
| 83002 | 83002 | 100776 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 83570 | 83570 | 118377 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 83994 | 83994 | 88168 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 366 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51186 | 6011675.0 | 2112537.0 | 37.7812816562818 | -122.40323643650801 | (37.7812816562818, -122.403236436508) | ||
| 84055 | 84055 | 100778 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 84171 | 84171 | 107155 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | ||||
| 86944 | 86944 | 118378 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 87096 | 87096 | 103269 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1175 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003540.3 | 2111739.0 | 37.7786328797101 | -122.431321507712 | (37.7786328797101, -122.431321507712) | ||||
| 87948 | 87948 | 114440 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2961 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011605.0 | 2091859.0 | 37.724500488626 | -122.402024501601 | (37.724500488626, -122.402024501601) | ||||
| 88825 | 88825 | 107152 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | In front of Gap Inc. | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | |||
| 89450 | 89450 | 118380 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 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) | |||
| 90872 | 90872 | 121545 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 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) | |||
| 96231 | 96231 | 100775 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 96505 | 96505 | 101990 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 25 Essex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | ||||
| 96690 | 96690 | 88153 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300X Clementina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270.0 | 2112782.0 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | ||
| 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) | |||
| 99469 | 99469 | 102507 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.43512657661199 | (37.782944132882, -122.435126576612) | ||
| 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) | |||
| 99988 | 99988 | 107153 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | ||||
| 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) | |||
| 100904 | 100904 | 88193 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 364 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51197 | 6011427.8 | 2112687.4 | 37.781680810769295 | -122.40410221959 | (37.7816808107693, -122.40410221959) | ||
| 101129 | 101129 | 100774 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 101153 | 101153 | 100779 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 102214 | 102214 | 88176 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 366 Clementina St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51186 | 6011675.0 | 2112537.0 | 37.7812816562818 | -122.40323643650801 | (37.7812816562818, -122.403236436508) | ||
| 103316 | 103316 | 87277 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2417 Bryant St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2008 12:00:00 AM | 3x3 | Permit Number 50297 | 6009714.0 | 2103272.0 | 37.7557323884753 | -122.409366521735 | (37.7557323884753, -122.409366521735) | |||
| 103382 | 103382 | 64005 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 443 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1987 12:00:00 AM | 5x9 | Permit Number 24752 | 6002309.37367781 | 2100887.25267027 | 37.7487667887863 | -122.434803521117 | (37.7487667887863, -122.434803521117) | |
| 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) | |||
| 103876 | 103876 | 94416 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 5800 03rd St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 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) | |||
| 104497 | 104497 | 102508 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.43512657661199 | (37.782944132882, -122.435126576612) | ||
| 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) | |||
| 106586 | 106586 | 121542 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 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) | ||||
| 107872 | 107872 | 107156 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | ||||
| 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) | |||
| 108943 | 108943 | 88154 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300X Clementina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270.0 | 2112782.0 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | ||
| 108969 | 108969 | 100773 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 109208 | 109208 | 118376 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 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) | |||
| 112179 | 112179 | 107154 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | ||||
| 114290 | 114290 | 114441 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2809 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011711.0 | 2091301.0 | 37.7229742506471 | -122.401618870695 | (37.7229742506471, -122.401618870695) | ||||
| 114525 | 114525 | 101994 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 25 Essex St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | ||||
| 115120 | 115120 | 121546 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 115363 | 115363 | 88192 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 364 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51197 | 6011427.8 | 2112687.4 | 37.781680810769295 | -122.40410221959 | (37.7816808107693, -122.40410221959) | ||
| 117985 | 117985 | 100777 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 4x3 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 119759 | 119759 | 94415 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 5800 03rd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 122108 | 122108 | 101992 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 25 Essex St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | ||||
| 123177 | 123177 | 6288 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | ||
| 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) | |||
| 126027 | 126027 | 121544 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 127194 | 127194 | 101993 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 25 Essex St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | ||||
| 127997 | 127997 | 88152 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300X Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270.0 | 2112782.0 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | ||
| 129011 | 129011 | 121540 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 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) | ||||
| 139129 | 139129 | 87445 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2413X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3x3 | 5999221.04782 | 2088973.5231299999 | 37.7158786645875 | -122.44462672412901 | (37.7158786645875, -122.444626724129) | |||
| 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) | ||||
| 143879 | 143879 | 88151 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300X Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270.0 | 2112782.0 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | ||
| 144636 | 144636 | 121541 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 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) | ||
| 101439 | 101439 | 14797 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1135 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1999 12:00:00 AM | 0 | 4X4 | 6003741.3117055 | 2111761.9657456 | 37.77870732769679 | -122.43062777021099 | (37.7787073276968, -122.430627770211) | ||
| 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) | ||
| 28198 | 28198 | 220487 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 416 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000636.08004 | 2101486.04738 | 37.7503157923525 | -122.44063269105499 | (37.7503157923525, -122.440632691055) | |||
| 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) | ||||
| 31410 | 31410 | 203402 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 20 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993459.6533 | 2097164.40162 | 37.738038365583 | -122.465135202222 | (37.738038365583, -122.465135202222) | |||
| 33913 | 33913 | 96284 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3237 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58767 | 6011926.62111 | 2090638.16357 | 37.7211662664813 | -122.400826962515 | (37.7211662664813, -122.400826962515) | |
| 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) | ||||
| 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) | |||
| 40227 | 40227 | 203406 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994466.0383 | 2096440.3744299999 | 37.736108347605295 | -122.461603176966 | (37.7361083476053, -122.461603176966) | |||
| 46689 | 46689 | 189084 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 350 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011667.549880001 | 2112806.97439 | 37.782022526948104 | -122.40328120787599 | (37.7820225269481, -122.403281207876) | |||
| 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) | |
| 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) | |||
| 56267 | 56267 | 104201 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3135 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/30/2015 12:00:00 AM | 1 | 3x3 | Permit Number 770708 | 6008143.9 | 2102068.3 | 37.7523392058798 | -122.41471126484 | (37.7523392058798, -122.41471126484) | |
| 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) | ||||
| 58878 | 58878 | 187907 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 167 Jessie St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012037.39416 | 2114599.46395 | 37.7869649329299 | -122.40212776620501 | (37.7869649329299, -122.402127766205) | |||
| 70521 | 70521 | 175131 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3219 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011901.5218 | 2090720.7857400002 | 37.7213917301239 | -122.400919526131 | (37.7213917301239, -122.400919526131) | |||
| 71761 | 71761 | 203405 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994431.87617 | 2096469.95405 | 37.736187599465204 | -122.46172343251101 | (37.7361875994652, -122.461723432511) | |||
| 72048 | 72048 | 96285 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3237 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58767 | 6011917.425009999 | 2090666.70864 | 37.721244132491606 | -122.40086075544501 | (37.7212441324916, -122.400860755445) | |
| 76376 | 76376 | 220427 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1501 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009439.69021 | 2107723.53455 | 37.76793991532671 | -122.410629521551 | (37.7679399153267, -122.410629521551) | |||
| 76923 | 76923 | 96282 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3219 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58765 | 6011894.72872 | 2090742.0865599997 | 37.7214498389136 | -122.400944503905 | (37.7214498389136, -122.400944503905) |
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");