trees
3,965 rows where qSpecies_id = 70 sorted by PlantDate descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
162137 | 49013 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2450 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2002 12:00:00 AM | 12 | Permit Number 46199 | 5999595.37201 | 2119840.257 | 37.8006524480994 | -122.445551188556 | (37.8006524480994, -122.445551188556) | 13 | 9 | 1 | 57 | 17 | ||
169001 | 68873 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 161 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 10 | Permit Number 32844 | 5992095.21626 | 2114354.33724 | 37.7851586118271 | -122.471104678515 | (37.7851586118271, -122.471104678515) | 11 | 6 | 2 | 54 | 11 | |
78655 | 6794 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1375 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6016884.45833 | 2097207.36346 | 37.7394792845271 | -122.38414622657 | (37.7394792845271, -122.38414622657) | 10 | 3 | 8 | 58 | 1 | ||
158947 | 6731 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6017098.09908 | 2097131.47437 | 37.7392827179327 | -122.383402261517 | (37.7392827179327, -122.383402261517) | 10 | 3 | 8 | 58 | 1 | ||
82582 | 55547 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 90- 92 CASELLI AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1972 12:00:00 AM | Permit Number 11515 | 6000515.5 | 2104940.8 | 37.759794835822 | -122.441297518402 | (37.759794835822, -122.441297518402) | 2 | 4 | 5 | 28862 | 3 | |||
149470 | 18269 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1933 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 12 | 3X3 | 6002915.6118 | 2114073.452 | 37.7850072757126 | -122.433649427379 | (37.7850072757126, -122.433649427379) | 13 | 9 | 11 | 29490 | 13 | ||
189331 | 92957 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 9 | 7 | 6 | 28861 | 25 | |
190901 | 92956 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 9 | 7 | 6 | 28861 | 25 | |
97390 | 11544 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101X Jennings St | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018840.43674 | 2097157.24182 | 37.7394496095988 | -122.37737975539 | (37.7394496095988, -122.37737975539) | 10 | 3 | 8 | 58 | 1 | ||
6854 | 39379 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1354 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40920 | 6007143.93712268 | 2107602.08417603 | 37.7674774616365 | -122.418561678075 | (37.7674774616365, -122.418561678075) | 8 | 4 | 7 | 28853 | 19 | |||
13825 | 87087 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 20501 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 28 | Permit Number 50035 | 5999440.60645 | 2115900.3485 | 37.7898256691591 | -122.44580322984 | (37.7898256691591, -122.44580322984) | 13 | 6 | 1 | 29490 | 27 | ||
150425 | 89312 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1969 12:00:00 AM | 3x3 | Permit Number 6484 | 6002340 | 2108819 | 37.7705471897255 | -122.435264883718 | (37.7705471897255, -122.435264883718) | 15 | 5 | 11 | 29492 | 9 | ||
91503 | 62749 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3757 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1988 12:00:00 AM | 12 | Permit Number 25749 | 5996846.35998 | 2115630.83606 | 37.7889371947488 | -122.454759549329 | (37.7889371947488, -122.454759549329) | 11 | 6 | 1 | 54 | 31 | ||
79529 | 91061 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2475 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2008 12:00:00 AM | 15 | 3x3 | Permit Number 51968 | 6001778.15599 | 2117308.9761 | 37.7938265856891 | -122.437816473953 | (37.7938265856891, -122.437816473953) | 13 | 9 | 1 | 29490 | 27 | |
62812 | 39261 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 6 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/1998 12:00:00 AM | Permit Number 40878 | 5995333.92231656 | 2100243.53450835 | 37.7466008020426 | -122.458877837799 | (37.7466008020426, -122.458877837799) | 1 | 8 | 4 | 59 | 40 | |||
83292 | 39249 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3168 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/1998 12:00:00 AM | Permit Number 40877 | 6008614.08848489 | 2100618.91579037 | 37.7483859278404 | -122.412982801874 | (37.7483859278404, -122.412982801874) | 2 | 4 | 7 | 28859 | 19 | |||
122177 | 39257 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3168 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/1998 12:00:00 AM | Permit Number 40877 | 6008614.08848489 | 2100618.91579037 | 37.7483859278404 | -122.412982801874 | (37.7483859278404, -122.412982801874) | 2 | 4 | 7 | 28859 | 19 | |||
191606 | 39248 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3168 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/1998 12:00:00 AM | Permit Number 40877 | 6008614.08848489 | 2100618.91579037 | 37.7483859278404 | -122.412982801874 | (37.7483859278404, -122.412982801874) | 2 | 4 | 7 | 28859 | 19 | |||
29051 | 44174 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3898 Washington St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2000 12:00:00 AM | 3x3 | Permit Number 49758 | 5996140.20734213 | 2115579.73573661 | 37.7887563568945 | -122.457199029036 | (37.7887563568945, -122.457199029036) | 11 | 6 | 1 | 54 | 31 | ||
57659 | 44175 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3898 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2000 12:00:00 AM | 3x3 | Permit Number 49758 | 5996140.20734213 | 2115579.73573661 | 37.7887563568945 | -122.457199029036 | (37.7887563568945, -122.457199029036) | 11 | 6 | 1 | 54 | 31 | ||
46769 | 87049 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 139 Welsh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2007 12:00:00 AM | 13 | 3x3 | Permit Number 49986 | 6013117.93675 | 2111529.65612 | 37.7785962007824 | -122.398173856333 | (37.7785962007824, -122.398173856333) | 6 | 2 | 9 | 28856 | 34 | |
194294 | 111846 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785307 | 6000128.0406 | 2117924.83666 | 37.7954236080649 | -122.443570269862 | (37.7954236080649, -122.443570269862) | 13 | 9 | 1 | 57 | 17 | |
38725 | 97974 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 14 | 3x3 | Permit Number 767976 | 6008567.92648 | 2094152.82902 | 37.7306288773042 | -122.412685380727 | (37.7306288773042, -122.412685380727) | 9 | 3 | 7 | 309 | 28 | |
103927 | 97976 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767976 | 6008561.06273 | 2094180.50101 | 37.7307044734101 | -122.412711065359 | (37.7307044734101, -122.412711065359) | 9 | 3 | 7 | 309 | 28 | |
110893 | 97972 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767976 | 6008572.26524 | 2094125.62068 | 37.7305544125591 | -122.412668458206 | (37.7305544125591, -122.412668458206) | 9 | 3 | 7 | 309 | 28 | |
158637 | 97978 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767976 | 6008558.53631 | 2094188.79818 | 37.7307271138572 | -122.412720385963 | (37.7307271138572, -122.412720385963) | 9 | 3 | 7 | 309 | 28 | |
2063 | 87007 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
5419 | 87002 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | 3x3 | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | ||
25512 | 87006 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
50374 | 87004 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
81766 | 87010 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
164945 | 87003 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
174127 | 87005 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
134179 | 48976 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 304 Upper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2002 12:00:00 AM | 3x3 | Permit Number 46163 | 5999195.98170881 | 2105884.18320097 | 37.7623098764083 | -122.445928917549 | (37.7623098764083, -122.445928917549) | 15 | 5 | 5 | 29492 | 9 | ||
76291 | 48969 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 420 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/2002 12:00:00 AM | Permit Number 46156 | 5996812.82347571 | 2110321.29788885 | 37.7743566819763 | -122.454491869748 | (37.7743566819763, -122.454491869748) | 15 | 5 | 2 | 29492 | 16 | |||
107831 | 48968 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 420 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/2002 12:00:00 AM | Permit Number 46156 | 5996812.82347571 | 2110321.29788885 | 37.7743566819763 | -122.454491869748 | (37.7743566819763, -122.454491869748) | 15 | 5 | 2 | 29492 | 16 | |||
58804 | 6420 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/29/1990 12:00:00 AM | 12 | 3x3 | 6018302.7051 | 2096585.42337 | 37.7378498712671 | -122.379199309611 | (37.7378498712671, -122.379199309611) | 10 | 3 | 8 | 58 | 1 | ||
159877 | 6443 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/29/1990 12:00:00 AM | 12 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | ||
164322 | 6428 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/29/1990 12:00:00 AM | 6 | 3x3 | 6018145.74781 | 2096700.42192 | 37.7381569780515 | -122.379749980697 | (37.7381569780515, -122.379749980697) | 10 | 3 | 8 | 58 | 1 | ||
177454 | 6622 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/24/1998 12:00:00 AM | 17 | 3x3 | 6016518.67204 | 2097829.13318 | 37.7411663074672 | -122.385454286011 | (37.7411663074672, -122.385454286011) | 10 | 3 | 8 | 58 | 1 | ||
68601 | 40557 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1494 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2002 12:00:00 AM | Permit Number 46100 | 6003279.18698139 | 2099536.66435899 | 37.7451134017483 | -122.431353516201 | (37.7451134017483, -122.431353516201) | 2 | 7 | 5 | 63 | 22 | |||
30715 | 73286 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
52590 | 73289 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 10 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
95651 | 73287 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
176204 | 73285 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 13 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
183898 | 73288 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
166953 | 74710 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1988 12:00:00 AM | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | |||
175838 | 74557 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1988 12:00:00 AM | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | |||
107957 | 94851 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1107 Bowdoin St | 2 | Front Yard : Yard | Tree | Private 2 | 11/17/2010 12:00:00 AM | 12 | Permit Number 774691 | 6009593 | 2091048 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | 10 | 3 | 7 | 309 | 28 | ||
77181 | 95229 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1@Carl Irving St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | |||
122339 | 95231 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1@Carl Irving St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | ||||
127476 | 62408 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 479 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/1985 12:00:00 AM | 17 | 6x9 | Permit Number 22584 | 6011214.75353 | 2118984.34931 | 37.798958825936 | -122.405282833437 | (37.798958825936, -122.405282833437) | 3 | 1 | 10 | 308 | 23 | |
39452 | 38955 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1322 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1998 12:00:00 AM | Permit Number 40750 | 5999535.03970594 | 2108258.16543211 | 37.7688475919778 | -122.44492690983 | (37.7688475919778, -122.44492690983) | 15 | 5 | 11 | 29492 | 9 | |||
176515 | 58355 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1340 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1978 12:00:00 AM | 8 | Permit Number 17382 | 6008945.85978 | 2117518.13372 | 37.7948058484612 | -122.413030259943 | (37.7948058484612, -122.413030259943) | 3 | 1 | 10 | 28857 | 21 | ||
112557 | 14481 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 281 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/09/1990 12:00:00 AM | 40 | 3X3 | 5998935.5096 | 2112063.3301 | 37.7792613662311 | -122.447274536897 | (37.7792613662311, -122.447274536897) | 15 | 5 | 2 | 54 | 16 | ||
114544 | 94795 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 223 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | 12 | 2x2 | Permit Number 53893 | 5988023.34122 | 2114443.34668 | 37.7851666498848 | -122.485198457494 | (37.7851666498848, -122.485198457494) | 11 | 6 | 2 | 55 | 26 | |
71638 | 59887 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 21 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/07/1981 12:00:00 AM | 23 | Permit Number 19353 | 5998815.1407 | 2110971.0405 | 37.7762553421156 | -122.447612291383 | (37.7762553421156, -122.447612291383) | 15 | 6 | 2 | 29492 | 16 | |
114494 | 92815 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Cerritos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/06/2009 12:00:00 AM | 3x3 | Permit Number 53023 | 5992579.4 | 2093009.1 | 37.7265781434944 | -122.46787650278 | (37.7265781434944, -122.46787650278) | 9 | 8 | 4 | 59 | 40 | ||
19963 | 55630 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 836 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1985 12:00:00 AM | 17 | Permit Number 22564 | 6011707.80627 | 2118223.65482 | 37.7968976958139 | -122.403523149777 | (37.7968976958139, -122.403523149777) | 3 | 1 | 10 | 308 | 4 | ||
128620 | 58830 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 733 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1979 12:00:00 AM | 24 | Permit Number 18084 | 6007395.77559951 | 2095369.75005937 | 37.7339044195491 | -122.416823876683 | (37.7339044195491, -122.416823876683) | 2 | 7 | 7 | 28859 | 2 | ||
56173 | 53099 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 370@HILL WAY Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2006 12:00:00 AM | Permit Number 49061 | 5996124.75088045 | 2106531.46709728 | 37.7639113030063 | -122.456597900952 | (37.7639113030063, -122.456597900952) | 15 | 5 | 11 | 29492 | 12 | |||
98009 | 64087 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 474 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1987 12:00:00 AM | 19 | Permit Number 24849 | 6010630.0202 | 2119988.0407 | 37.8016820080225 | -122.407377010865 | (37.8016820080225, -122.407377010865) | 3 | 1 | 10 | 308 | 23 | ||
176729 | 15277 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1563X Mission St | 2 | Median : Cutout | Tree | DPW 1 | 10/28/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777705 | 6007250.56082 | 2109703.40074 | 37.7732531819334 | -122.418341887077 | (37.7732531819334, -122.418341887077) | 8 | 2 | 9 | 28853 | 19 | |
73770 | 110847 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2668 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778643 | 6000834.0024 | 2117585.61695 | 37.7945324365719 | -122.441103181276 | (37.7945324365719, -122.441103181276) | 13 | 9 | 1 | 57 | 27 | |
44508 | 53479 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3600 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1969 12:00:00 AM | 36 | 6x12 | Permit Number 6388 | 5997506.20792 | 2115767.61462 | 37.7893505789022 | -122.452486450792 | (37.7893505789022, -122.452486450792) | 11 | 6 | 1 | 54 | 31 | |
34056 | 64237 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 557 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779942 | 5987180.23832 | 2112140.30179 | 37.7787939955639 | -122.487946016766 | (37.7787939955639, -122.487946016766) | 11 | 6 | 2 | 55 | 26 | |
98183 | 125053 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2018 12:00:00 AM | 3 | Width 2ft | 6002522.90847 | 2120942.13769 | 37.8038446195968 | -122.435499592826 | (37.8038446195968, -122.435499592826) | 13 | 9 | 1 | 57 | 17 | ||
28763 | 30315 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1955 12:00:00 AM | Permit Number 12 | 6009097.70753924 | 2116729.99483623 | 37.7926503347532 | -122.412449106972 | (37.7926503347532, -122.412449106972) | 3 | 1 | 10 | 28857 | 21 | |||
58946 | 30316 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1955 12:00:00 AM | Permit Number 12 | 6009097.70753924 | 2116729.99483623 | 37.7926503347532 | -122.412449106972 | (37.7926503347532, -122.412449106972) | 3 | 1 | 10 | 28857 | 21 | |||
113678 | 246115 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1410 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 13 | Width 0ft | Permit Number 47096 | 5998952.8623 | 2108365.1171 | 37.7691080111861 | -122.446948309851 | (37.7691080111861, -122.446948309851) | 15 | 5 | 11 | 29492 | 9 | |
158004 | 246114 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1418 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 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) | 15 | 5 | 11 | 29492 | 9 | |
15068 | 59890 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1981 12:00:00 AM | 12 | Permit Number 19356 | 5998808.9736 | 2111008.0431 | 37.7763565892826 | -122.447636289265 | (37.7763565892826, -122.447636289265) | 15 | 6 | 2 | 29492 | 16 | |
114773 | 98600 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2195X Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1981 12:00:00 AM | 3x3 | Permit Number 768644 | 6002468 | 2118693 | 37.7976659583882 | -122.435528609991 | (37.7976659583882, -122.435528609991) | 13 | 9 | 1 | 57 | 17 | ||
154228 | 6041 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1830 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/1990 12:00:00 AM | 3 | 3X3 | 6001487.9166 | 2112537.6047 | 37.7807091188768 | -122.438478710972 | (37.7807091188768, -122.438478710972) | 15 | 5 | 11 | 29490 | 41 | ||
32695 | 38515 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2735 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40502 | 5999957.99990299 | 2117760.48412278 | 37.7949626403238 | -122.444146821557 | (37.7949626403238, -122.444146821557) | 13 | 9 | 1 | 57 | 27 | |||
83660 | 38514 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2735 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40502 | 5999957.99990299 | 2117760.48412278 | 37.7949626403238 | -122.444146821557 | (37.7949626403238, -122.444146821557) | 13 | 9 | 1 | 57 | 27 | |||
34218 | 32423 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2641 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | 12 | Permit Number 36950 | 6000352.62092 | 2118166.60357 | 37.7961002417749 | -122.442810555866 | (37.7961002417749, -122.442810555866) | 13 | 9 | 1 | 57 | 17 | ||
85214 | 32418 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | Permit Number 36947 | 5990009.30581449 | 2102467.22445118 | 37.752398967394 | -122.477452096473 | (37.752398967394, -122.477452096473) | 1 | 8 | 3 | 56 | 35 | |||
173334 | 32419 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | Permit Number 36947 | 5990009.30581449 | 2102467.22445118 | 37.752398967394 | -122.477452096473 | (37.752398967394, -122.477452096473) | 1 | 8 | 3 | 56 | 35 | |||
175371 | 94602 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2939 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 10/07/2010 12:00:00 AM | 9 | Permit Number 53770 | 5999468.94586 | 2117347.95354 | 37.7938020288031 | -122.445809330858 | (37.7938020288031, -122.445809330858) | 13 | 9 | 1 | 57 | 27 | ||
3359 | 250631 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 161 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/06/2020 12:00:00 AM | 3 | Width 4ft | 5987117.30977 | 2114718.25139 | 37.7858686386749 | -122.488353213533 | (37.7858686386749, -122.488353213533) | 11 | 6 | 1 | 55 | 33 | ||
5572 | 250632 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 161 28th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/06/2020 12:00:00 AM | 3 | Width 4ft | 5987122.25317 | 2114703.48842 | 37.7858283922212 | -122.488335025649 | (37.7858283922212, -122.488335025649) | 11 | 6 | 1 | 55 | 33 | ||
21042 | 67608 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 261 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/1992 12:00:00 AM | 10 | Permit Number 31186 | 5988028.8714 | 2114260.18154 | 37.7846640526933 | -122.485165880985 | (37.7846640526933, -122.485165880985) | 11 | 6 | 2 | 55 | 26 | ||
49173 | 94915 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1922 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2010 12:00:00 AM | 16 | 5993509.6 | 2102385.8 | 37.752377883346 | -122.465341688659 | (37.752377883346, -122.465341688659) | 1 | 8 | 4 | 29491 | 12 | |||
14423 | 114573 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3621 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x3 | 5997465.48926 | 2115720.33673 | 37.7892184334409 | -122.452623918478 | (37.7892184334409, -122.452623918478) | 11 | 6 | 1 | 54 | 31 | ||
110296 | 113585 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 536 BELVEDERE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2015 12:00:00 AM | 15x6 | 5998642 | 2106082 | 37.7628213832292 | -122.447859166975 | (37.7628213832292, -122.447859166975) | 15 | 5 | 11 | 29492 | 9 | |||
161391 | 58302 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3233 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1978 12:00:00 AM | 16 | Permit Number 17321 | 5998757.69678 | 2116224.86065 | 37.7906776778817 | -122.44818940014 | (37.7906776778817, -122.44818940014) | 13 | 6 | 1 | 54 | 31 | ||
118126 | 17839 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2019 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/01/1993 12:00:00 AM | 12 | 3X3 | 6004275.6276397 | 2115305.3712985 | 37.788466890956 | -122.4290320691 | (37.788466890956, -122.4290320691) | 13 | 9 | 11 | 29490 | 27 | ||
28712 | 97224 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 4 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 6 | 15x200 | 6016653.04222 | 2094950.9325 | 37.733270780627 | -122.384789221155 | (37.733270780627, -122.384789221155) | 10 | 3 | 8 | 58 | 1 | ||
39400 | 97226 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 6 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016643.51258 | 2094941.12769 | 37.7332433315076 | -122.384821485239 | (37.7332433315076, -122.384821485239) | 10 | 3 | 8 | 58 | 1 | ||
163065 | 97223 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 3 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016661.55982 | 2094959.63165 | 37.733295137843 | -122.384760378985 | (37.733295137843, -122.384760378985) | 10 | 3 | 8 | 58 | 1 | ||
129651 | 57519 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1360 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1976 12:00:00 AM | 20 | Permit Number 16376 | 6008935.45982 | 2117576.86679 | 37.7949665312373 | -122.413070400293 | (37.7949665312373, -122.413070400293) | 3 | 1 | 10 | 28857 | 21 | ||
96805 | 10274 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 218 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/29/2016 03:07:00 PM | 3 | 3x3 | 6004921.53459 | 2109545.14882 | 37.7726872808276 | -122.426387037745 | (37.7726872808276, -122.426387037745) | 7 | 9 | 11 | 28852 | 10 | ||
139348 | 52048 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2440 Pacific Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2005 12:00:00 AM | 32 | Permit Number 48253 | 6002224.00886 | 2117083.39027 | 37.7932325277104 | -122.436257632301 | (37.7932325277104, -122.436257632301) | 13 | 9 | 1 | 29490 | 27 | ||
78544 | 24934 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 09/28/1999 12:00:00 AM | 24 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | ||
179775 | 48496 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2002 12:00:00 AM | Permit Number 45837 | 6001939.6131076 | 2108727.84798346 | 37.7702741635264 | -122.436643297557 | (37.7702741635264, -122.436643297557) | 15 | 5 | 5 | 29492 | 9 | |||
70244 | 12734 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/2015 12:00:00 AM | 3 | 3X3 | 5990479.84568 | 2114768.877 | 37.7862032574553 | -122.476723596597 | (37.7862032574553, -122.476723596597) | 11 | 6 | 1 | 55 | 33 | ||
72380 | 24224 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 56 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2016 12:00:00 AM | 18 | 3x3 | 6016378.0406117 | 2096157.2731291 | 37.7365679365277 | -122.385824040568 | (37.7365679365277, -122.385824040568) | 10 | 3 | 8 | 58 | 1 | ||
136644 | 24132 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2016 12:00:00 AM | 18 | 3x3 | 6016408.932866 | 2096090.684567 | 37.7363868071997 | -122.385712592191 | (37.7363868071997, -122.385712592191) | 10 | 3 | 8 | 58 | 1 | ||
80669 | 38644 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2371 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/1998 12:00:00 AM | Permit Number 40569 | 5991667.78903268 | 2099298.30551377 | 37.7437940310181 | -122.471485954341 | (37.7437940310181, -122.471485954341) | 1 | 8 | 4 | 29491 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );