trees
3,965 rows where qSpecies_id = 70 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
73188 | 255598 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
73336 | 256346 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000X Sunset Blvd | 25 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
73451 | 120986 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
73680 | 117162 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1383X VERMONT ST | 2 | Front Yard : Cutout | Tree | Private 2 | DPW | 6011571 | 2102081 | 37.7525660338429 | -122.402860625738 | (37.7525660338429, -122.402860625738) | 10 | 3 | 8 | 28856 | 29 | ||||
74264 | 89023 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2x Hollywood Ct | 1 | unknown : Cutout | Tree | DPW 1 | 6000329 | 2088600 | 37.714916215224 | -122.440770357879 | (37.714916215224, -122.440770357879) | 9 | 7 | 6 | 28861 | 5 | |||||
74577 | 49310 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 499@ Taylor Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2003 12:00:00 AM | Permit Number 46313 | 6008403.82866353 | 2121370.35158903 | 37.8053526360585 | -122.415178583983 | (37.8053526360585, -122.415178583983) | 5 | 1 | 10 | 308 | 23 | |||
74587 | 258628 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 95 Banks St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 6008696 | 2098147 | 37.7416031915622 | -122.412524842458 | (37.7416031915622, -122.412524842458) | 10 | 7 | 7 | 28859 | 2 | ||||
74766 | 49501 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 3x3 | Permit Number 46414 | 5994271.00866961 | 2115572.53954866 | 37.7886290700296 | -122.463665616673 | (37.7886290700296, -122.463665616673) | 11 | 6 | 1 | 54 | 11 | ||
74773 | 120987 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
75143 | 255642 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 220 Masonic Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999023 | 2112089 | 37.7793368479896 | -122.446973720271 | (37.7793368479896, -122.446973720271) | 15 | 5 | 1 | 54 | 16 | |||||
75352 | 120992 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
75638 | 52883 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801@ NORIEGA 08th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48888 | 5993719.57975271 | 2103223.93352011 | 37.7546912902093 | -122.464676406209 | (37.7546912902093, -122.464676406209) | 1 | 8 | 4 | 56 | 12 | ||||
75744 | 50101 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1520 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46828 | 5992463.83947388 | 2096912.47054003 | 37.7372891525979 | -122.468559868986 | (37.7372891525979, -122.468559868986) | 1 | 8 | 4 | 59 | 40 | ||
75888 | 122562 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3903 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996054 | 2115495 | 37.7885187439988 | -122.45749115914 | (37.7885187439988, -122.45749115914) | 11 | 6 | 1 | 54 | 31 | ||||
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 | |||
76614 | 43901 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2940 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2000 12:00:00 AM | Permit Number 43503 | 6000066.19718413 | 2116781.74083104 | 37.7922814409941 | -122.443702097084 | (37.7922814409941, -122.443702097084) | 13 | 6 | 1 | 29490 | 27 | |||
77073 | 85503 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Nebraska St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
77387 | 96356 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3622 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2011 12:00:00 AM | 2.5 x6 | 5999184 | 2121228 | 37.8044393220775 | -122.447074624063 | (37.8044393220775, -122.447074624063) | 13 | 9 | 1 | 57 | 17 | |||
79307 | 255595 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
79935 | 114613 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2199x BAKER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999856 | 2116234 | 37.7907654976997 | -122.444389999861 | (37.7907654976997, -122.444389999861) | 13 | 6 | 1 | 29490 | 27 | ||||
80056 | 98544 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 Teresita Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
80206 | 254650 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1330 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000277 | 2113549 | 37.7834171962779 | -122.442740486778 | (37.7834171962779, -122.442740486778) | 15 | 6 | 1 | 29490 | 13 | ||||
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 | |||
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 | |||
81795 | 46254 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2161 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44539 | 6000422.21933345 | 2120600.45809947 | 37.8027869270392 | -122.442744582339 | (37.8027869270392, -122.442744582339) | 13 | 9 | 1 | 57 | 17 | ||||
81891 | 110202 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1039 PAGE ST | Front Yard : Cutout | Tree | Private 2 | 4x5 | 6001572.7 | 2109358.5 | 37.771984919077 | -122.437957625293 | (37.771984919077, -122.437957625293) | 15 | 5 | 11 | 29492 | 9 | |||||
81939 | 255640 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 220 Masonic Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999023 | 2112089 | 37.7793368479896 | -122.446973720271 | (37.7793368479896, -122.446973720271) | 15 | 5 | 1 | 54 | 16 | |||||
82200 | 117528 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 638 MORAGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992280 | 2103925 | 37.7565331373023 | -122.469705853198 | (37.7565331373023, -122.469705853198) | 1 | 8 | 4 | 56 | 12 | ||||
82457 | 255992 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6000562.83378 | 2088278.17036 | 37.7140458572152 | -122.439939070053 | (37.7140458572152, -122.439939070053) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | |||
82653 | 50099 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1510 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46827 | 5992486.72879777 | 2096933.93018279 | 37.7373493975579 | -122.468482291601 | (37.7373493975579, -122.468482291601) | 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 | |||
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 | |||
83951 | 114090 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2835 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001183.08872 | 2115909.2328 | 37.7899493996846 | -122.439775055277 | (37.7899493996846, -122.439775055277) | 13 | 6 | 1 | 29490 | 27 | ||||
83959 | 255873 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990871 | 2092383 | 37.7247602290732 | -122.473736664855 | (37.7247602290732, -122.473736664855) | 9 | 8 | 4 | 64 | 40 | ||||
84675 | 42562 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 San Benito Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51025 | 5992910.18577839 | 2095362.95085697 | 37.7330603317539 | -122.46690404336 | (37.7330603317539, -122.46690404336) | 9 | 8 | 4 | 59 | 40 | ||
84707 | 105273 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 232 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986553.3 | 2114252.8 | 37.784557719608 | -122.490270252434 | (37.784557719608, -122.490270252434) | 11 | 6 | 1 | 55 | 33 | |||||
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 | |||
85457 | 32033 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3321 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | Permit Number 35417 | 6004720.37722217 | 2106583.67854581 | 37.7645444241082 | -122.42687191329 | (37.7645444241082, -122.42687191329) | 8 | 4 | 5 | 28862 | 3 | |||
86140 | 114841 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2670 LEAVENWORTH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007398 | 2121652 | 37.8060693936166 | -122.418679378695 | (37.8060693936166, -122.418679378695) | 5 | 1 | 1 | 308 | 23 | ||||
86322 | 173862 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 98 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999618 | 2107794 | 37.7675778447629 | -122.444606591258 | (37.7675778447629, -122.444606591258) | 15 | 5 | 11 | 29492 | 9 | ||||
87061 | 104723 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 133X Juan Bautista Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770293 | 5989605.82194 | 2089746.43988 | 37.7174475379801 | -122.477917527277 | (37.7174475379801, -122.477917527277) | 1 | 8 | 4 | 64 | 14 | ||||
87109 | 103410 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Executive Park Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.7113362593892 | -122.392574697929 | (37.7113362593892, -122.392574697929) | 10 | 3 | 8 | 58 | 1 | ||||
87168 | 97262 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1994@ Octavia Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004661.4 | 2117107.1 | 37.7934358122691 | -122.427825787413 | (37.7934358122691, -122.427825787413) | 13 | 9 | 1 | 28858 | 27 | |||||
88656 | 50105 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1550 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | 1 | 8 | 4 | 59 | 40 | ||
88938 | 87293 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 763 45th Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | 11 | 6 | 2 | 55 | 26 | |||
89490 | 85305 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 365 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2007 12:00:00 AM | Permit Number 49591 | 5995968.6 | 2095545 | 37.7337362418337 | -122.456343520233 | (37.7337362418337, -122.456343520233) | 9 | 7 | 4 | 59 | 40 | |||
89524 | 52877 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801@ NORIEGA 08th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48888 | 5993719.57975271 | 2103223.93352011 | 37.7546912902093 | -122.464676406209 | (37.7546912902093, -122.464676406209) | 1 | 8 | 4 | 56 | 12 | ||||
89801 | 99660 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1365 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.465323151466 | (37.7394617231066, -122.465323151466) | 1 | 8 | 4 | 59 | 40 | |||||
90007 | 113799 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 695x SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 4x4 | 6008062 | 2103972 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | 2 | 4 | 7 | 28859 | 19 | ||||
91337 | 49320 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 595 Marina Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2003 12:00:00 AM | Permit Number 46320 | 6000116.71946789 | 2121594.09727993 | 37.8054977726587 | -122.443873196152 | (37.8054977726587, -122.443873196152) | 13 | 9 | 1 | 57 | 17 | |||
91547 | 95374 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2270 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999358 | 2120844 | 37.8033949017064 | -122.446444841619 | (37.8033949017064, -122.446444841619) | 13 | 9 | 1 | 57 | 17 | |||||
91561 | 34180 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 104 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1997 12:00:00 AM | Permit Number 38006 | 5998990.33122805 | 2116224.12146592 | 37.7906889445626 | -122.447384447462 | (37.7906889445626, -122.447384447462) | 13 | 6 | 1 | 29490 | 31 | |||
91619 | 50998 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2404 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2004 12:00:00 AM | Permit Number 47480 | 6002104.70119173 | 2117406.84878453 | 37.7941138815303 | -122.436693608205 | (37.7941138815303, -122.436693608205) | 13 | 9 | 1 | 57 | 27 | |||
91676 | 104449 | Private 9 | Acacia melanoxylon :: Blackwood Acacia 70 | 2490X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
91712 | 100394 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1800X Lincoln Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | 11 | 8 | 2 | 29492 | 8 | ||||
91868 | 99559 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1142 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011567 | 2119203 | 37.7995788748768 | -122.404079333017 | (37.7995788748768, -122.404079333017) | 3 | 1 | 10 | 308 | 23 | |||||
92681 | 115442 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
92771 | 30421 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 530 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/1956 12:00:00 AM | Permit Number 75 | 6009285.11323863 | 2120849.80325768 | 37.803972827811 | -122.412091961384 | (37.803972827811, -122.412091961384) | 3 | 1 | 10 | 308 | 23 | |||
93001 | 115142 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
93359 | 50109 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1562 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.7369894427575 | -122.468964178249 | (37.7369894427575, -122.468964178249) | 1 | 8 | 4 | 59 | 40 | ||
93821 | 122406 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2050 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993518 | 2101564 | 37.75012191545 | -122.465252952764 | (37.75012191545, -122.465252952764) | 1 | 8 | 4 | 29491 | 40 | ||||
93884 | 50108 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1562 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.7369894427575 | -122.468964178249 | (37.7369894427575, -122.468964178249) | 1 | 8 | 4 | 59 | 40 | ||
94513 | 121667 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 243 Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992346.75268289 | 2097836.73381964 | 37.7398201819052 | -122.469031933295 | (37.7398201819052, -122.469031933295) | 1 | 8 | 4 | 59 | 40 | |||||
94629 | 120990 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
94772 | 114816 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 125 BRENTWOOD AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x10 | 5995779 | 2095603 | 37.7338846095715 | -122.457003213247 | (37.7338846095715, -122.457003213247) | 9 | 7 | 4 | 59 | 40 | ||||
95102 | 103383 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3199X JACKSON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999158 | 2116301 | 37.7909096124749 | -122.446809858862 | (37.7909096124749, -122.446809858862) | 13 | 6 | 1 | 29490 | 31 | |||||
95376 | 88602 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 370 Parnassus Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51547 | 5996151.9 | 2106560.1 | 37.7639914803102 | -122.45650607155 | (37.7639914803102, -122.45650607155) | 15 | 5 | 11 | 29492 | 12 | |||
95554 | 32029 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3321 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | Permit Number 35417 | 6004720.37722217 | 2106583.67854581 | 37.7645444241082 | -122.42687191329 | (37.7645444241082, -122.42687191329) | 8 | 4 | 5 | 28862 | 3 | |||
95648 | 115441 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
95949 | 258389 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1995 Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013601 | 2099985 | 37.74692400616 | -122.395693639953 | (37.74692400616, -122.395693639953) | 10 | 3 | 8 | 58 | 1 | ||||
96610 | 116088 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 98x WOODWARD ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006422 | 2107919 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | 8 | 4 | 7 | 28853 | 19 | ||||
97253 | 50102 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1530 Portola Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46829 | 5992435.00755539 | 2096888.46432184 | 37.7372215720402 | -122.468657807095 | (37.7372215720402, -122.468657807095) | 1 | 8 | 4 | 59 | 40 | ||
97463 | 99436 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1970 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x20 | 5993835.2 | 2102068.9 | 37.7515265292069 | -122.46419271546 | (37.7515265292069, -122.46419271546) | 1 | 8 | 4 | 29491 | 12 | ||||
98534 | 52660 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1596 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 5.5x6 | Permit Number 48740 | 5993413.6797412 | 2104632.19014775 | 37.7585403580185 | -122.465836598218 | (37.7585403580185, -122.465836598218) | 1 | 8 | 4 | 56 | 12 | ||
100305 | 99658 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1325 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | 1 | 8 | 4 | 59 | 40 | |||||
100329 | 51666 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 444 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2005 12:00:00 AM | Permit Number 47943 | 5998559.54409269 | 2106579.38545488 | 37.7641823653154 | -122.448180168308 | (37.7641823653154, -122.448180168308) | 15 | 5 | 11 | 29492 | 9 | |||
101150 | 99904 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
101546 | 96646 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2350 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2011 12:00:00 AM | Permit Number 768028 | 5991735.4 | 2099423.9 | 37.7441427924065 | -122.471261322589 | (37.7441427924065, -122.471261322589) | 1 | 8 | 4 | 29491 | 40 | |||
101568 | 113533 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2681 28TH AVE | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6x6 | 5987701 | 2097026 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | 1 | 8 | 3 | 29491 | 35 | ||||
101910 | 103408 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Executive Park Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.7113362593892 | -122.392574697929 | (37.7113362593892, -122.392574697929) | 10 | 3 | 8 | 58 | 1 | ||||
102160 | 117527 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1099x WALLER ST | 1 | Front Yard : Yard | Tree | Private 2 | 6000071 | 2108311 | 37.769023235971 | -122.44307686155 | (37.769023235971, -122.44307686155) | 15 | 5 | 5 | 29492 | 9 | |||||
102398 | 105415 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X McAllister St | 1 | Front Yard : Yard | Tree | Private 2 | 6002220.78829 | 2111575.67932 | 37.7781095739995 | -122.435874511445 | (37.7781095739995, -122.435874511445) | 15 | 5 | 11 | 29492 | 41 | |||||
102561 | 111074 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X KIRKHAM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991438 | 2105265 | 37.7601637210649 | -122.472715460505 | (37.7601637210649, -122.472715460505) | 1 | 8 | 4 | 56 | 12 | ||||
102639 | 38645 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2371 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 40569 | 5991667.78903268 | 2099298.30551377 | 37.7437940310181 | -122.471485954341 | (37.7437940310181, -122.471485954341) | 1 | 8 | 4 | 29491 | 40 | ||||
102741 | 98542 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 Teresita Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
103924 | 30856 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
104052 | 99855 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2900 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768992 | 5999541.6 | 2118827.3 | 37.7978680691774 | -122.445664375651 | (37.7978680691774, -122.445664375651) | 13 | 9 | 1 | 57 | 17 | ||||
104200 | 51634 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 77 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47924 | 6005437.59121376 | 2109217.8235753 | 37.7718176826133 | -122.424578652037 | (37.7718176826133, -122.424578652037) | 7 | 9 | 5 | 28852 | 10 | |||
104514 | 87964 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 393 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50997 | 6008895 | 2121449 | 37.8055961756376 | -122.413484381593 | (37.8055961756376, -122.413484381593) | 3 | 1 | 10 | 308 | 23 | ||
104618 | 92788 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53006 | 6001506.4 | 2107657.3 | 37.7673100756575 | -122.438065079874 | (37.7673100756575, -122.438065079874) | 15 | 5 | 5 | 29492 | 3 | |||
104922 | 49319 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 595 Marina Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2003 12:00:00 AM | Permit Number 46320 | 6000116.71946789 | 2121594.09727993 | 37.8054977726587 | -122.443873196152 | (37.8054977726587, -122.443873196152) | 13 | 9 | 1 | 57 | 17 | |||
104965 | 258052 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 856 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x6 | 5991236 | 2091663 | 37.7228044207006 | -122.472422451465 | (37.7228044207006, -122.472422451465) | 9 | 8 | 4 | 64 | 40 | ||||
105134 | 87963 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 393 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50997 | 6008895 | 2121449 | 37.8055961756376 | -122.413484381593 | (37.8055961756376, -122.413484381593) | 3 | 1 | 10 | 308 | 23 | ||
105829 | 113656 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 600x 28TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001710 | 2099417 | 37.744695775282 | -122.436770916391 | (37.744695775282, -122.436770916391) | 2 | 7 | 5 | 63 | 22 | ||||
106539 | 110882 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
106719 | 100655 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 590X Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992492.1 | 2104587.3 | 37.7583638968548 | -122.469020540261 | (37.7583638968548, -122.469020540261) | 1 | 8 | 4 | 56 | 12 | |||||
106748 | 114218 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 119 TALBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010311 | 2086793 | 37.7105179840213 | -122.406140963349 | (37.7105179840213, -122.406140963349) | 9 | 7 | 8 | 309 | 39 | ||||
107484 | 251574 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 191 Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 5999731 | 2100707 | 37.748125134697 | -122.443706547761 | (37.748125134697, -122.443706547761) | 2 | 4 | 5 | 63 | 22 | ||||
107746 | 103283 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3195X Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998987.7 | 2116257.6 | 37.790780717413 | -122.447395962042 | (37.790780717413, -122.447395962042) | 13 | 6 | 1 | 29490 | 31 |
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) );