Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 85056 | 85056 | 99601 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2801X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 43709 | 6003513.0 | 2117956.0 | 37.7957016423098 | -122.43185997681299 | (37.7957016423098, -122.431859976813) | |||
| 85142 | 85142 | 104690 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1435X La Salle Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770699 | 6016460.43075 | 2095036.9864400001 | 37.733496412822205 | -122.385461132957 | (37.7334964128222, -122.385461132957) | ||||
| 85480 | 85480 | 112952 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 300X VICENTE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992030.0 | 2097800.0 | 37.73970101338521 | -122.470124446456 | (37.7397010133852, -122.470124446456) | ||||
| 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) | |||
| 85597 | 85597 | 122562 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3903 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996054.0 | 2115495.0 | 37.78851874399879 | -122.45749115913999 | (37.7885187439988, -122.45749115914) | ||||
| 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) | |||
| 85680 | 85680 | 99097 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Santa Monica Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5994003.8 | 2097131.6 | 37.7379796635799 | -122.463251452094 | (37.7379796635799, -122.463251452094) | |||||
| 85718 | 85718 | 120989 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 838 Pacific Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.40908331651899 | (37.7966924872417, -122.409083316519) | ||||
| 85843 | 85843 | 49501 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2003 12:00:00 AM | 3x3 | Permit Number 46414 | 5994271.00866961 | 2115572.53954866 | 37.7886290700296 | -122.463665616673 | (37.7886290700296, -122.463665616673) | ||
| 85969 | 85969 | 86887 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 56 Casa Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49816 | 6001536.6 | 2121651.4 | 37.8057359986938 | -122.43896362504499 | (37.8057359986938, -122.438963625045) | ||||
| 86002 | 86002 | 50101 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1520 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46828 | 5992463.83947388 | 2096912.47054003 | 37.7372891525979 | -122.46855986898599 | (37.7372891525979, -122.468559868986) | ||
| 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) | |||
| 86265 | 86265 | 41311 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Garcia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2002 12:00:00 AM | Permit Number 41984 | 5995254.05842615 | 2099498.8895679 | 37.7445516019752 | -122.459100086565 | (37.7445516019752, -122.459100086565) | ||
| 86340 | 86340 | 99198 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 726 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5986369.0 | 2114825.0 | 37.786118050599 | -122.490949979792 | (37.786118050599, -122.490949979792) | |||||
| 86484 | 86484 | 46614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Sola Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2002 12:00:00 AM | Permit Number 44737 | 5995007.33907927 | 2100649.9152063 | 37.7476978436736 | -122.46003655522199 | (37.7476978436736, -122.460036555222) | |||
| 86741 | 86741 | 87252 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 20 Burr Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50276 | 6007848.5 | 2086602.7 | 37.709857414252795 | -122.414638464087 | (37.7098574142528, -122.414638464087) | |||
| 87192 | 87192 | 51553 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3800 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2005 12:00:00 AM | Permit Number 47852 | 5996586.74903344 | 2115641.8686237 | 37.788952592538706 | -122.455658560713 | (37.7889525925387, -122.455658560713) | |||
| 87228 | 87228 | 87839 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 815 Buena Vista West Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50724 | 5999858.0 | 2108239.0 | 37.76881339508 | -122.44380843942301 | (37.76881339508, -122.443808439423) | ||
| 87235 | 87235 | 117162 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1383X VERMONT ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | DPW 4 | 6011571.0 | 2102081.0 | 37.752566033842896 | -122.40286062573799 | (37.7525660338429, -122.402860625738) | ||||
| 87506 | 87506 | 120986 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 838 Pacific Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.40908331651899 | (37.7966924872417, -122.409083316519) | ||||
| 87647 | 87647 | 110867 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 INDIANA ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 87663 | 87663 | 52883 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1801@ NORIEGA 08th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48888 | 5993719.57975271 | 2103223.93352011 | 37.7546912902093 | -122.464676406209 | (37.7546912902093, -122.464676406209) | ||||
| 87667 | 87667 | 120987 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 838 Pacific Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.40908331651899 | (37.7966924872417, -122.409083316519) | ||||
| 87701 | 87701 | 107823 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 398X 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5987151.97458 | 2113602.02096 | 37.7828058118879 | -122.488151230918 | (37.7828058118879, -122.488151230918) | |||||
| 87877 | 87877 | 113532 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2681 28TH AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6x6 | 5987701.0 | 2097026.0 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | ||||
| 88002 | 88002 | 109049 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2146 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 774033 | 6000515.3 | 2120331.0 | 37.802052372900896 | -122.442403120222 | (37.8020523729009, -122.442403120222) | ||||
| 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) | |||
| 88277 | 88277 | 98819 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 62 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768816 | 6000868.0 | 2109174.0 | 37.7714382288844 | -122.440381995657 | (37.7714382288844, -122.440381995657) | ||||
| 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) | ||
| 88576 | 88576 | 30420 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 599 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/1956 12:00:00 AM | Permit Number 74 | 6011244.65303661 | 2117958.27162773 | 37.7961431366669 | -122.40510708151699 | (37.7961431366669, -122.405107081517) | |||
| 88587 | 88587 | 51791 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 485 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2005 12:00:00 AM | Permit Number 48040 | 5995434.95012874 | 2095496.4695716 | 37.733572339482 | -122.458184982463 | (37.733572339482, -122.458184982463) | |||
| 88626 | 88626 | 89211 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1540 Pacheco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51845 | 5990117.7 | 2101817.3 | 37.7506207352004 | -122.47702976858 | (37.7506207352004, -122.47702976858) | |||
| 88695 | 88695 | 104451 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2490X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
| 88900 | 88900 | 100067 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 93 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | On property line with 99 Buena Vista Ter | 6001505.1 | 2107681.4 | 37.76737617437121 | -122.438071302911 | (37.7673761743712, -122.438071302911) | |||
| 89008 | 89008 | 111229 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1113 SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001842.0 | 2112262.0 | 37.779972512780105 | -122.4372340286 | (37.7799725127801, -122.4372340286) | ||||
| 89016 | 89016 | 99604 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2801X Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 43709 | 6003513.0 | 2117956.0 | 37.7957016423098 | -122.43185997681299 | (37.7957016423098, -122.431859976813) | |||
| 89117 | 89117 | 101006 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2801X Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003500.6 | 2117942.3 | 37.795663322696704 | -122.43190190430201 | (37.7956633226967, -122.431901904302) | ||||
| 89284 | 89284 | 96357 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3622 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5 x6 | 5999184.0 | 2121228.0 | 37.8044393220775 | -122.44707462406299 | (37.8044393220775, -122.447074624063) | ||||
| 89642 | 89642 | 34959 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 29 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 38552 | 5990777.0 | 2114840.0 | 37.7864157730855 | -122.475700726719 | (37.7864157730855, -122.475700726719) | |||
| 89685 | 89685 | 94648 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1811 Pierce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 53785 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | ||||
| 90127 | 90127 | 89023 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Hollywood Ct | 1 | unknown : Cutout 12 | Tree 1 | DPW 2 | 6000329.0 | 2088600.0 | 37.714916215224 | -122.440770357879 | (37.714916215224, -122.440770357879) | |||||
| 90217 | 90217 | 115147 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
| 90561 | 90561 | 48354 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 18 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45763 | 6001410.60770745 | 2108152.23015211 | 37.768663583108605 | -122.43843187465299 | (37.7686635831086, -122.438431874653) | |||
| 90624 | 90624 | 120992 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 838 Pacific Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.40908331651899 | (37.7966924872417, -122.409083316519) | ||||
| 90645 | 90645 | 52661 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1596 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | 7x6 | Permit Number 48740 | 5993413.6797412 | 2104632.19014775 | 37.7585403580185 | -122.465836598218 | (37.7585403580185, -122.465836598218) | ||
| 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) | |||
| 91139 | 91139 | 122406 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2050 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993518.0 | 2101564.0 | 37.75012191545 | -122.46525295276399 | (37.75012191545, -122.465252952764) | ||||
| 91291 | 91291 | 117528 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 638 MORAGA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992280.0 | 2103925.0 | 37.7565331373023 | -122.469705853198 | (37.7565331373023, -122.469705853198) | ||||
| 91353 | 91353 | 95374 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2270 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999358.0 | 2120844.0 | 37.8033949017064 | -122.446444841619 | (37.8033949017064, -122.446444841619) | |||||
| 91365 | 91365 | 46254 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2161 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44539 | 6000422.21933345 | 2120600.45809947 | 37.8027869270392 | -122.442744582339 | (37.8027869270392, -122.442744582339) | ||||
| 91930 | 91930 | 113799 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 695x SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4x4 | 6008062.0 | 2103972.0 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | ||||
| 92059 | 92059 | 114841 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2670 LEAVENWORTH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007398.0 | 2121652.0 | 37.8060693936166 | -122.41867937869499 | (37.8060693936166, -122.418679378695) | ||||
| 92226 | 92226 | 96356 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3622 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2011 12:00:00 AM | 2.5 x6 | 5999184.0 | 2121228.0 | 37.8044393220775 | -122.44707462406299 | (37.8044393220775, -122.447074624063) | |||
| 92300 | 92300 | 50099 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1510 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46827 | 5992486.72879777 | 2096933.93018279 | 37.7373493975579 | -122.468482291601 | (37.7373493975579, -122.468482291601) | ||
| 92380 | 92380 | 43901 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2940 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2000 12:00:00 AM | Permit Number 43503 | 6000066.19718413 | 2116781.74083104 | 37.7922814409941 | -122.44370209708401 | (37.7922814409941, -122.443702097084) | |||
| 92561 | 92561 | 104449 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2490X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
| 92588 | 92588 | 99559 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1142 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011567.0 | 2119203.0 | 37.799578874876794 | -122.40407933301701 | (37.7995788748768, -122.404079333017) | |||||
| 92597 | 92597 | 103410 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 Executive Park Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.711336259389206 | -122.392574697929 | (37.7113362593892, -122.392574697929) | ||||
| 92887 | 92887 | 121667 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 243 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992346.75268289 | 2097836.73381964 | 37.7398201819052 | -122.469031933295 | (37.7398201819052, -122.469031933295) | |||||
| 92902 | 92902 | 85305 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 365 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2007 12:00:00 AM | Permit Number 49591 | 5995968.6 | 2095545.0 | 37.733736241833704 | -122.456343520233 | (37.7337362418337, -122.456343520233) | |||
| 92936 | 92936 | 34180 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1997 12:00:00 AM | Permit Number 38006 | 5998990.33122805 | 2116224.12146592 | 37.7906889445626 | -122.447384447462 | (37.7906889445626, -122.447384447462) | |||
| 93038 | 93038 | 42562 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 San Benito Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51025 | 5992910.18577839 | 2095362.95085697 | 37.7330603317539 | -122.46690404336 | (37.7330603317539, -122.46690404336) | ||
| 93376 | 93376 | 112677 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 470 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2015 12:00:00 AM | 4x4 | 6010678.0 | 2119694.0 | 37.8008773296715 | -122.40719023879 | (37.8008773296715, -122.40719023879) | |||
| 93403 | 93403 | 103383 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3199X JACKSON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999158.0 | 2116301.0 | 37.7909096124749 | -122.446809858862 | (37.7909096124749, -122.446809858862) | |||||
| 93440 | 93440 | 50998 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2404 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | Permit Number 47480 | 6002104.70119173 | 2117406.84878453 | 37.7941138815303 | -122.43669360820499 | (37.7941138815303, -122.436693608205) | |||
| 93502 | 93502 | 97262 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1994@ Octavia Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004661.4 | 2117107.1 | 37.7934358122691 | -122.427825787413 | (37.7934358122691, -122.427825787413) | |||||
| 93554 | 93554 | 87293 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 763 45th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | |||
| 93574 | 93574 | 100394 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1800X Lincoln Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | ||||
| 93820 | 93820 | 50105 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1550 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672002 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | ||
| 93980 | 93980 | 110202 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1039 PAGE ST | Front Yard : Cutout 8 | Tree 1 | Private 1 | 4x5 | 6001572.7 | 2109358.5 | 37.771984919077 | -122.43795762529301 | (37.771984919077, -122.437957625293) | |||||
| 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) | |||
| 94268 | 94268 | 50109 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1562 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.736989442757505 | -122.468964178249 | (37.7369894427575, -122.468964178249) | ||
| 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) | |||
| 94339 | 94339 | 85503 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 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) | |||
| 94558 | 94558 | 105273 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 232 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5986553.3 | 2114252.8 | 37.784557719608 | -122.490270252434 | (37.784557719608, -122.490270252434) | |||||
| 94598 | 94598 | 50108 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1562 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.736989442757505 | -122.468964178249 | (37.7369894427575, -122.468964178249) | ||
| 95129 | 95129 | 114613 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2199x BAKER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999856.0 | 2116234.0 | 37.7907654976997 | -122.44438999986099 | (37.7907654976997, -122.444389999861) | ||||
| 95359 | 95359 | 32033 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3321 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | Permit Number 35417 | 6004720.37722217 | 2106583.67854581 | 37.7645444241082 | -122.42687191328999 | (37.7645444241082, -122.42687191329) | |||
| 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) | |||
| 95633 | 95633 | 114816 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 125 BRENTWOOD AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x10 | 5995779.0 | 2095603.0 | 37.7338846095715 | -122.45700321324699 | (37.7338846095715, -122.457003213247) | ||||
| 95899 | 95899 | 104723 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 133X Juan Bautista Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770293 | 5989605.82194 | 2089746.43988 | 37.71744753798011 | -122.47791752727699 | (37.7174475379801, -122.477917527277) | ||||
| 96476 | 96476 | 30421 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 530 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/1956 12:00:00 AM | Permit Number 75 | 6009285.11323863 | 2120849.80325768 | 37.803972827810995 | -122.412091961384 | (37.803972827811, -122.412091961384) | |||
| 96524 | 96524 | 99660 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1365 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.46532315146601 | (37.7394617231066, -122.465323151466) | |||||
| 96999 | 96999 | 115142 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013586.0 | 2086931.0 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | ||||
| 97219 | 97219 | 52877 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1801@ NORIEGA 08th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48888 | 5993719.57975271 | 2103223.93352011 | 37.7546912902093 | -122.464676406209 | (37.7546912902093, -122.464676406209) | ||||
| 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) | |||
| 97297 | 97297 | 115442 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
| 97300 | 97300 | 98544 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 555 Teresita Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 97566 | 97566 | 100655 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 590X Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992492.1 | 2104587.3 | 37.758363896854796 | -122.469020540261 | (37.7583638968548, -122.469020540261) | |||||
| 97670 | 97670 | 49320 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 595 Marina Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | Permit Number 46320 | 6000116.71946789 | 2121594.09727993 | 37.805497772658704 | -122.443873196152 | (37.8054977726587, -122.443873196152) | |||
| 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) | |||
| 97784 | 97784 | 120990 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 838 Pacific Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.40908331651899 | (37.7966924872417, -122.409083316519) | ||||
| 98074 | 98074 | 49016 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 San Marcos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46202 | 5993947.57587841 | 2100008.88350341 | 37.745876723459396 | -122.463654612612 | (37.7458767234594, -122.463654612612) | ||||
| 98077 | 98077 | 96646 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2350 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2011 12:00:00 AM | Permit Number 768028 | 5991735.4 | 2099423.9 | 37.7441427924065 | -122.471261322589 | (37.7441427924065, -122.471261322589) | |||
| 98214 | 98214 | 113797 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 695x SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4x4 | 6008062.0 | 2103972.0 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | ||||
| 98425 | 98425 | 103283 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3195X Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998987.7 | 2116257.6 | 37.790780717413 | -122.44739596204201 | (37.790780717413, -122.447395962042) | ||||
| 98432 | 98432 | 87964 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 393 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50997 | 6008895.0 | 2121449.0 | 37.8055961756376 | -122.413484381593 | (37.8055961756376, -122.413484381593) | ||
| 98508 | 98508 | 103408 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 Executive Park Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.711336259389206 | -122.392574697929 | (37.7113362593892, -122.392574697929) | ||||
| 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) |
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");