Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23512 | 23512 | 49013 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2450 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2002 12:00:00 AM | 12 | Permit Number 46199 | 5999595.37201 | 2119840.2569999998 | 37.8006524480994 | -122.44555118855601 | (37.8006524480994, -122.445551188556) | ||
| 156775 | 156775 | 68873 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 161 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 10 | Permit Number 32844 | 5992095.21626 | 2114354.3372400003 | 37.7851586118271 | -122.47110467851499 | (37.7851586118271, -122.471104678515) | |
| 15459 | 15459 | 6794 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1375 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6016884.458330001 | 2097207.3634599997 | 37.7394792845271 | -122.38414622657 | (37.7394792845271, -122.38414622657) | ||
| 16309 | 16309 | 6731 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6017098.09908 | 2097131.4743700002 | 37.7392827179327 | -122.38340226151699 | (37.7392827179327, -122.383402261517) | ||
| 97293 | 97293 | 55547 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 90- 92 CASELLI AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1972 12:00:00 AM | Permit Number 11515 | 6000515.5 | 2104940.8 | 37.759794835822 | -122.44129751840201 | (37.759794835822, -122.441297518402) | |||
| 7780 | 7780 | 18269 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1933 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 12 | 3X3 | 6002915.6118 | 2114073.452 | 37.7850072757126 | -122.433649427379 | (37.7850072757126, -122.433649427379) | ||
| 144074 | 144074 | 92957 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
| 145041 | 145041 | 92956 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
| 15245 | 15245 | 11544 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Jennings St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018840.43674 | 2097157.24182 | 37.7394496095988 | -122.37737975539 | (37.7394496095988, -122.37737975539) | ||
| 18193 | 18193 | 39379 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1354 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40920 | 6007143.93712268 | 2107602.08417603 | 37.7674774616365 | -122.41856167807501 | (37.7674774616365, -122.418561678075) | |||
| 36388 | 36388 | 87087 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 20501 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 28 | Permit Number 50035 | 5999440.60645 | 2115900.3485 | 37.7898256691591 | -122.44580322984 | (37.7898256691591, -122.44580322984) | ||
| 16744 | 16744 | 6812 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016477.270719999 | 2097595.73141 | 37.740523142935096 | -122.385581175844 | (37.7405231429351, -122.385581175844) | ||
| 116158 | 116158 | 89312 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1969 12:00:00 AM | 3x3 | Permit Number 6484 | 6002340.0 | 2108819.0 | 37.7705471897255 | -122.43526488371799 | (37.7705471897255, -122.435264883718) | ||
| 62537 | 62537 | 62749 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3757 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1988 12:00:00 AM | 12 | Permit Number 25749 | 5996846.35998 | 2115630.8360599997 | 37.7889371947488 | -122.454759549329 | (37.7889371947488, -122.454759549329) | ||
| 42619 | 42619 | 91061 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2475 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2008 12:00:00 AM | 15 | 3x3 | Permit Number 51968 | 6001778.15599 | 2117308.9761 | 37.793826585689104 | -122.43781647395299 | (37.7938265856891, -122.437816473953) | |
| 85602 | 85602 | 39261 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 6 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/1998 12:00:00 AM | Permit Number 40878 | 5995333.92231656 | 2100243.53450835 | 37.7466008020426 | -122.458877837799 | (37.7466008020426, -122.458877837799) | |||
| 94246 | 94246 | 39249 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3168 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/1998 12:00:00 AM | Permit Number 40877 | 6008614.08848489 | 2100618.91579037 | 37.7483859278404 | -122.41298280187401 | (37.7483859278404, -122.412982801874) | |||
| 107152 | 107152 | 39257 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3168 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/1998 12:00:00 AM | Permit Number 40877 | 6008614.08848489 | 2100618.91579037 | 37.7483859278404 | -122.41298280187401 | (37.7483859278404, -122.412982801874) | |||
| 144923 | 144923 | 39248 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3168 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/1998 12:00:00 AM | Permit Number 40877 | 6008614.08848489 | 2100618.91579037 | 37.7483859278404 | -122.41298280187401 | (37.7483859278404, -122.412982801874) | |||
| 88318 | 88318 | 44175 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3898 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2000 12:00:00 AM | 3x3 | Permit Number 49758 | 5996140.20734213 | 2115579.73573661 | 37.788756356894496 | -122.457199029036 | (37.7887563568945, -122.457199029036) | ||
| 125686 | 125686 | 44174 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3898 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2000 12:00:00 AM | 3x3 | Permit Number 49758 | 5996140.20734213 | 2115579.73573661 | 37.788756356894496 | -122.457199029036 | (37.7887563568945, -122.457199029036) | ||
| 36213 | 36213 | 87049 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 139 Welsh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 13 | 3x3 | Permit Number 49986 | 6013117.93675 | 2111529.65612 | 37.7785962007824 | -122.398173856333 | (37.7785962007824, -122.398173856333) | |
| 131037 | 131037 | 97978 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767976 | 6008558.536309999 | 2094188.79818 | 37.7307271138572 | -122.412720385963 | (37.7307271138572, -122.412720385963) | |
| 154807 | 154807 | 97976 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767976 | 6008561.06273 | 2094180.5010099998 | 37.7307044734101 | -122.412711065359 | (37.7307044734101, -122.412711065359) | |
| 177689 | 177689 | 97972 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767976 | 6008572.265240001 | 2094125.62068 | 37.7305544125591 | -122.412668458206 | (37.7305544125591, -122.412668458206) | |
| 185638 | 185638 | 97974 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 14 | 3x3 | Permit Number 767976 | 6008567.92648 | 2094152.82902 | 37.7306288773042 | -122.412685380727 | (37.7306288773042, -122.412685380727) | |
| 105 | 105 | 6251 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/06/2003 12:00:00 AM | 24 | 3X3 | 6004480.8051 | 2113256.6545 | 37.7828532389184 | -122.428176124144 | (37.7828532389184, -122.428176124144) | ||
| 20617 | 20617 | 87007 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 72223 | 72223 | 87002 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | 3x3 | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | ||
| 81600 | 81600 | 87004 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 95384 | 95384 | 87010 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 121870 | 121870 | 87003 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 125318 | 125318 | 87006 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 140596 | 140596 | 87005 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 116293 | 116293 | 48976 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 304 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2002 12:00:00 AM | 3x3 | Permit Number 46163 | 5999195.98170881 | 2105884.18320097 | 37.762309876408295 | -122.445928917549 | (37.7623098764083, -122.445928917549) | ||
| 86043 | 86043 | 48969 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 420 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2002 12:00:00 AM | Permit Number 46156 | 5996812.82347571 | 2110321.29788885 | 37.77435668197629 | -122.454491869748 | (37.7743566819763, -122.454491869748) | |||
| 99271 | 99271 | 48968 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 420 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2002 12:00:00 AM | Permit Number 46156 | 5996812.82347571 | 2110321.29788885 | 37.77435668197629 | -122.454491869748 | (37.7743566819763, -122.454491869748) | |||
| 14364 | 14364 | 6420 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100X Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/29/1990 12:00:00 AM | 12 | 3x3 | 6018302.7051 | 2096585.42337 | 37.7378498712671 | -122.379199309611 | (37.7378498712671, -122.379199309611) | ||
| 16182 | 16182 | 6428 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100X Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/29/1990 12:00:00 AM | 6 | 3x3 | 6018145.74781 | 2096700.42192 | 37.7381569780515 | -122.379749980697 | (37.7381569780515, -122.379749980697) | ||
| 123001 | 123001 | 6443 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100X Evans Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/29/1990 12:00:00 AM | 12 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | ||
| 23329 | 23329 | 6622 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1415 Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/1998 12:00:00 AM | 17 | 3x3 | 6016518.672040001 | 2097829.13318 | 37.7411663074672 | -122.38545428601101 | (37.7411663074672, -122.385454286011) | ||
| 85496 | 85496 | 40557 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1494 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | Permit Number 46100 | 6003279.18698139 | 2099536.66435899 | 37.74511340174829 | -122.431353516201 | (37.7451134017483, -122.431353516201) | |||
| 43203 | 43203 | 54713 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1972 12:00:00 AM | 14 | Permit Number 11467 | 6001165.76206 | 2116883.2589 | 37.7926228359235 | -122.43990487063999 | (37.7926228359235, -122.43990487064) | ||
| 79583 | 79583 | 73289 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1999 12:00:00 AM | 10 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 100783 | 100783 | 73287 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 124535 | 124535 | 73286 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 139596 | 139596 | 73288 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 140357 | 140357 | 73285 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1999 12:00:00 AM | 13 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 117990 | 117990 | 74710 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 838 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1988 12:00:00 AM | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.40908331651899 | (37.7966924872417, -122.409083316519) | |||
| 143066 | 143066 | 74557 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 838 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1988 12:00:00 AM | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.40908331651899 | (37.7966924872417, -122.409083316519) | |||
| 98300 | 98300 | 94851 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1107 Bowdoin St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/17/2010 12:00:00 AM | 12 | Permit Number 774691 | 6009593.0 | 2091048.0 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | ||
| 91700 | 91700 | 95229 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1@Carl Irving St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/16/2010 12:00:00 AM | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | |||
| 104669 | 104669 | 95231 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1@Carl Irving St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/16/2010 12:00:00 AM | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | ||||
| 65553 | 65553 | 62408 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 479 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1985 12:00:00 AM | 17 | 6x9 | Permit Number 22584 | 6011214.75353 | 2118984.34931 | 37.798958825936 | -122.405282833437 | (37.798958825936, -122.405282833437) | |
| 82012 | 82012 | 38955 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1322 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | Permit Number 40750 | 5999535.03970594 | 2108258.16543211 | 37.768847591977796 | -122.44492690983 | (37.7688475919778, -122.44492690983) | |||
| 56042 | 56042 | 58355 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1340 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1978 12:00:00 AM | 8 | Permit Number 17382 | 6008945.8597800005 | 2117518.1337200003 | 37.7948058484612 | -122.41303025994301 | (37.7948058484612, -122.413030259943) | ||
| 6522 | 6522 | 14481 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 281 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1990 12:00:00 AM | 40 | 3X3 | 5998935.5096 | 2112063.3301 | 37.779261366231104 | -122.447274536897 | (37.7792613662311, -122.447274536897) | ||
| 181375 | 181375 | 94795 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 223 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | 12 | 2x2 | Permit Number 53893 | 5988023.34122 | 2114443.34668 | 37.78516664988479 | -122.485198457494 | (37.7851666498848, -122.485198457494) | |
| 33086 | 33086 | 59887 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 21 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | 23 | Permit Number 19353 | 5998815.1407 | 2110971.0405 | 37.776255342115604 | -122.447612291383 | (37.7762553421156, -122.447612291383) | |
| 185884 | 185884 | 59890 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | 12 | Permit Number 19356 | 5998808.9736 | 2111008.0431 | 37.77635658928261 | -122.447636289265 | (37.7763565892826, -122.447636289265) | |
| 109255 | 109255 | 92815 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 54 Cerritos Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/06/2009 12:00:00 AM | 3x3 | Permit Number 53023 | 5992579.4 | 2093009.1 | 37.72657814349439 | -122.46787650278 | (37.7265781434944, -122.46787650278) | ||
| 52209 | 52209 | 55630 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 836 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1985 12:00:00 AM | 17 | Permit Number 22564 | 6011707.80627 | 2118223.6548200003 | 37.7968976958139 | -122.40352314977699 | (37.7968976958139, -122.403523149777) | ||
| 104318 | 104318 | 58830 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 733 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1979 12:00:00 AM | 24 | Permit Number 18084 | 6007395.77559951 | 2095369.75005937 | 37.733904419549106 | -122.41682387668301 | (37.7339044195491, -122.416823876683) | ||
| 81857 | 81857 | 53099 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 370@HILL WAY Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2006 12:00:00 AM | Permit Number 49061 | 5996124.75088045 | 2106531.46709728 | 37.763911303006296 | -122.45659790095199 | (37.7639113030063, -122.456597900952) | |||
| 73211 | 73211 | 64087 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 474 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1987 12:00:00 AM | 19 | Permit Number 24849 | 6010630.0202 | 2119988.0407 | 37.801682008022496 | -122.407377010865 | (37.8016820080225, -122.407377010865) | ||
| 16543 | 16543 | 15277 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1563X Mission St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777705 | 6007250.560819999 | 2109703.40074 | 37.7732531819334 | -122.418341887077 | (37.7732531819334, -122.418341887077) | |
| 7056 | 7056 | 110847 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2668 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778643 | 6000834.0024 | 2117585.61695 | 37.7945324365719 | -122.44110318127599 | (37.7945324365719, -122.441103181276) | |
| 6921 | 6921 | 53479 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3600 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1969 12:00:00 AM | 36 | 6x12 | Permit Number 6388 | 5997506.20792 | 2115767.61462 | 37.7893505789022 | -122.45248645079201 | (37.7893505789022, -122.452486450792) | |
| 4840 | 4840 | 64237 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 557 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779942 | 5987180.23832 | 2112140.30179 | 37.778793995563895 | -122.48794601676599 | (37.7787939955639, -122.487946016766) | |
| 88260 | 88260 | 30316 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1190 Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1955 12:00:00 AM | Permit Number 12 | 6009097.70753924 | 2116729.99483623 | 37.792650334753205 | -122.412449106972 | (37.7926503347532, -122.412449106972) | |||
| 127282 | 127282 | 30315 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1190 Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1955 12:00:00 AM | Permit Number 12 | 6009097.70753924 | 2116729.99483623 | 37.792650334753205 | -122.412449106972 | (37.7926503347532, -122.412449106972) | |||
| 2778 | 2778 | 246114 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1418 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 13 | Width 0ft | Permit Number 47096 | 5998969.2151 | 2108370.2652 | 37.769123080801 | -122.44689211719 | (37.769123080801, -122.44689211719) | |
| 2780 | 2780 | 246115 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1410 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 13 | Width 0ft | Permit Number 47096 | 5998952.8623 | 2108365.1171 | 37.769108011186106 | -122.446948309851 | (37.7691080111861, -122.446948309851) | |
| 105523 | 105523 | 98600 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2195X Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1981 12:00:00 AM | 3x3 | Permit Number 768644 | 6002468.0 | 2118693.0 | 37.7976659583882 | -122.435528609991 | (37.7976659583882, -122.435528609991) | ||
| 8111 | 8111 | 6041 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1830 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/1990 12:00:00 AM | 3 | 3X3 | 6001487.9166 | 2112537.6047 | 37.78070911887679 | -122.438478710972 | (37.7807091188768, -122.438478710972) | ||
| 94285 | 94285 | 38514 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2735 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1998 12:00:00 AM | Permit Number 40502 | 5999957.99990299 | 2117760.48412278 | 37.794962640323796 | -122.44414682155701 | (37.7949626403238, -122.444146821557) | |||
| 126775 | 126775 | 38515 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2735 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1998 12:00:00 AM | Permit Number 40502 | 5999957.99990299 | 2117760.48412278 | 37.794962640323796 | -122.44414682155701 | (37.7949626403238, -122.444146821557) | |||
| 64542 | 64542 | 32423 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2641 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | 12 | Permit Number 36950 | 6000352.62092 | 2118166.6035700003 | 37.796100241774894 | -122.44281055586599 | (37.7961002417749, -122.442810555866) | ||
| 91072 | 91072 | 32418 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | Permit Number 36947 | 5990009.30581449 | 2102467.22445118 | 37.752398967394 | -122.477452096473 | (37.752398967394, -122.477452096473) | |||
| 141176 | 141176 | 32419 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | Permit Number 36947 | 5990009.30581449 | 2102467.22445118 | 37.752398967394 | -122.477452096473 | (37.752398967394, -122.477452096473) | |||
| 178371 | 178371 | 94602 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2939 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/07/2010 12:00:00 AM | 9 | Permit Number 53770 | 5999468.945859999 | 2117347.95354 | 37.7938020288031 | -122.445809330858 | (37.7938020288031, -122.445809330858) | ||
| 120199 | 120199 | 67608 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 261 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/1992 12:00:00 AM | 10 | Permit Number 31186 | 5988028.8714 | 2114260.1815400003 | 37.784664052693294 | -122.485165880985 | (37.7846640526933, -122.485165880985) | ||
| 84881 | 84881 | 94915 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1922 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2010 12:00:00 AM | 16 | 5993509.6 | 2102385.8 | 37.752377883346 | -122.465341688659 | (37.752377883346, -122.465341688659) | |||
| 97760 | 97760 | 113585 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 536 BELVEDERE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2015 12:00:00 AM | 15x6 | 5998642.0 | 2106082.0 | 37.7628213832292 | -122.44785916697501 | (37.7628213832292, -122.447859166975) | |||
| 45398 | 45398 | 58302 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3233 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1978 12:00:00 AM | 16 | Permit Number 17321 | 5998757.69678 | 2116224.86065 | 37.7906776778817 | -122.44818940014 | (37.7906776778817, -122.44818940014) | ||
| 107986 | 107986 | 17839 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2019 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/01/1993 12:00:00 AM | 12 | 3X3 | 6004275.627639701 | 2115305.3712985 | 37.788466890956 | -122.4290320691 | (37.788466890956, -122.4290320691) | ||
| 13955 | 13955 | 97226 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016643.51258 | 2094941.1276900002 | 37.7332433315076 | -122.38482148523899 | (37.7332433315076, -122.384821485239) | ||
| 16107 | 16107 | 97223 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016661.55982 | 2094959.63165 | 37.733295137843 | -122.384760378985 | (37.733295137843, -122.384760378985) | ||
| 23028 | 23028 | 97224 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 6 | 15x200 | 6016653.042219999 | 2094950.9325 | 37.733270780626995 | -122.38478922115499 | (37.733270780627, -122.384789221155) | ||
| 54385 | 54385 | 57519 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1360 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1976 12:00:00 AM | 20 | Permit Number 16376 | 6008935.4598199995 | 2117576.8667900003 | 37.7949665312373 | -122.41307040029301 | (37.7949665312373, -122.413070400293) | ||
| 19829 | 19829 | 10274 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 218 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/29/2016 03:07:00 PM | 3 | 3x3 | 6004921.53459 | 2109545.1488200002 | 37.772687280827604 | -122.426387037745 | (37.7726872808276, -122.426387037745) | ||
| 180368 | 180368 | 52048 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2440 Pacific Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/2005 12:00:00 AM | 32 | Permit Number 48253 | 6002224.0088599995 | 2117083.39027 | 37.7932325277104 | -122.43625763230101 | (37.7932325277104, -122.436257632301) | ||
| 93328 | 93328 | 24934 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/28/1999 12:00:00 AM | 24 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 143326 | 143326 | 48496 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2002 12:00:00 AM | Permit Number 45837 | 6001939.613107599 | 2108727.84798346 | 37.770274163526395 | -122.436643297557 | (37.7702741635264, -122.436643297557) | |||
| 88164 | 88164 | 12734 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/2015 12:00:00 AM | 3 | 3X3 | 5990479.84568 | 2114768.877 | 37.7862032574553 | -122.476723596597 | (37.7862032574553, -122.476723596597) | ||
| 111899 | 111899 | 24132 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/21/2016 12:00:00 AM | 18 | 3x3 | 6016408.932866001 | 2096090.6845669998 | 37.7363868071997 | -122.38571259219101 | (37.7363868071997, -122.385712592191) | ||
| 144252 | 144252 | 24224 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 56 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/21/2016 12:00:00 AM | 18 | 3x3 | 6016378.0406117 | 2096157.2731291 | 37.736567936527706 | -122.38582404056801 | (37.7365679365277, -122.385824040568) | ||
| 94557 | 94557 | 38644 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2371 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/1998 12:00:00 AM | Permit Number 40569 | 5991667.78903268 | 2099298.30551377 | 37.7437940310181 | -122.47148595434099 | (37.7437940310181, -122.471485954341) | |||
| 142443 | 142443 | 53040 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3666@ GUERRERO 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/2006 12:00:00 AM | Permit Number 49018 | 6005866.70904359 | 2104351.76912463 | 37.758480874637 | -122.42274843163 | (37.758480874637, -122.42274843163) | ||
| 138494 | 138494 | 55211 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/1972 12:00:00 AM | Permit Number 775231 | 5999977.22784047 | 2112772.7148777 | 37.781268623734604 | -122.44372179014601 | (37.7812686237346, -122.443721790146) |
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");