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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45591 | 45591 | 115721 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3530 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x5 | 5999222.11492 | 2120952.1000200002 | 37.8036839530115 | -122.44692285883 | (37.8036839530115, -122.44692285883) | |||
| 45647 | 45647 | 95675 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2207 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6x6 | 6001981.9652 | 2114296.4072 | 37.785566433956795 | -122.43689550902398 | (37.7855664339568, -122.436895509024) | |||
| 47275 | 47275 | 30324 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 720 Montgomery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1956 12:00:00 AM | Permit Number 16 | 6011772.9424544005 | 2117800.56968196 | 37.7957396438077 | -122.403267984357 | (37.7957396438077, -122.403267984357) | |||
| 48064 | 48064 | 105092 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3150 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4X4 | 5999125.32302 | 2116324.31891 | 37.7909717732653 | -122.44692459810301 | (37.7909717732653, -122.446924598103) | |||
| 48911 | 48911 | 68331 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2338 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32146 | 5991366.81812 | 2112033.7901 | 37.778744872635606 | -122.473455364804 | (37.7787448726356, -122.473455364804) | ||
| 49151 | 49151 | 51005 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 674 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | 14 | Permit Number 47484 | 5995056.39173 | 2110967.50064 | 37.776030092024 | -122.460614488586 | (37.776030092024, -122.460614488586) | ||
| 49926 | 49926 | 30343 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3789 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 27 | 6001958.2216300005 | 2121669.55401 | 37.8058098244409 | -122.437505844543 | (37.8058098244409, -122.437505844543) | |||
| 51035 | 51035 | 68988 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3336 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 15 | Permit Number 32980 | 6000849.989680001 | 2119837.16995 | 37.8007155175595 | -122.441209485631 | (37.8007155175595, -122.441209485631) | |
| 51260 | 51260 | 40095 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2249 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/1999 12:00:00 AM | Permit Number 41318 | 6001849.57530622 | 2114273.14459713 | 37.7854950354219 | -122.437351872267 | (37.7854950354219, -122.437351872267) | |||
| 52209 | 52209 | 55630 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 836 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1985 12:00:00 AM | 17 | Permit Number 22564 | 6011707.80627 | 2118223.6548200003 | 37.7968976958139 | -122.40352314977699 | (37.7968976958139, -122.403523149777) | ||
| 52657 | 52657 | 56020 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2580 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1973 12:00:00 AM | 11 | Permit Number 12105 | 5996803.4076 | 2110776.9649 | 37.7756072847096 | -122.454557365701 | (37.7756072847096, -122.454557365701) | ||
| 53245 | 53245 | 93875 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 110 Beulah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997572.0 | 2107825.0 | 37.76754600118029 | -122.451685641377 | (37.7675460011803, -122.451685641377) | |||||
| 53801 | 53801 | 6629 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1415 Evans Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 05/16/2013 12:00:00 AM | 17 | 4x4 | 6016652.34226 | 2097729.17939 | 37.7408992492988 | -122.38498513575001 | (37.7408992492988, -122.38498513575) | ||
| 54385 | 54385 | 57519 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1360 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1976 12:00:00 AM | 20 | Permit Number 16376 | 6008935.4598199995 | 2117576.8667900003 | 37.7949665312373 | -122.41307040029301 | (37.7949665312373, -122.413070400293) | ||
| 56042 | 56042 | 58355 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1340 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1978 12:00:00 AM | 8 | Permit Number 17382 | 6008945.8597800005 | 2117518.1337200003 | 37.7948058484612 | -122.41303025994301 | (37.7948058484612, -122.413030259943) | ||
| 56575 | 56575 | 91400 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 222 Maple St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52096 | 5996639.65876 | 2115525.86158 | 37.7886371044596 | -122.455467113417 | (37.7886371044596, -122.455467113417) | |
| 58950 | 58950 | 121048 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2652 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006192.78395747 | 2119877.54417008 | 37.80112926306921 | -122.422724050002 | (37.8011292630692, -122.422724050002) | ||||
| 61856 | 61856 | 113086 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 494 36th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5984727.03316 | 2112580.82435 | 37.7798601334655 | -122.496465003816 | (37.7798601334655, -122.496465003816) | |||
| 61900 | 61900 | 113085 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 494 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5984727.7654 | 2112562.56652 | 37.7798100456413 | -122.496461123088 | (37.7798100456413, -122.496461123088) | |||
| 62537 | 62537 | 62749 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3757 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1988 12:00:00 AM | 12 | Permit Number 25749 | 5996846.35998 | 2115630.8360599997 | 37.7889371947488 | -122.454759549329 | (37.7889371947488, -122.454759549329) | ||
| 63499 | 63499 | 104422 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2362 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3x3 | 5999509.01294 | 2120174.0716 | 37.8015640827681 | -122.445874046945 | (37.8015640827681, -122.445874046945) | |||
| 63651 | 63651 | 109426 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 132 Locust St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2015 12:00:00 AM | 3 | 5997544.3 | 2115966.4 | 37.7898985728773 | -122.452369007612 | (37.7898985728773, -122.452369007612) | ||||
| 63870 | 63870 | 103489 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2601 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6001042.45399 | 2117566.1251 | 37.7944907880724 | -122.440380515743 | (37.7944907880724, -122.440380515743) | |||
| 64542 | 64542 | 32423 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2641 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | 12 | Permit Number 36950 | 6000352.62092 | 2118166.6035700003 | 37.796100241774894 | -122.44281055586599 | (37.7961002417749, -122.442810555866) | ||
| 65553 | 65553 | 62408 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 479 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1985 12:00:00 AM | 17 | 6x9 | Permit Number 22584 | 6011214.75353 | 2118984.34931 | 37.798958825936 | -122.405282833437 | (37.798958825936, -122.405282833437) | |
| 66181 | 66181 | 64574 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2872 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1988 12:00:00 AM | 25 | Permit Number 25468 | 5995849.04615 | 2111058.0388 | 37.776324256889296 | -122.45787905836 | (37.7763242568893, -122.45787905836) | ||
| 67457 | 67457 | 43163 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 222 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 8 | Permit Number 42973 | 6005640.84958 | 2092540.2669400002 | 37.7260364164322 | -122.42269019099301 | (37.7260364164322, -122.422690190993) | |
| 67679 | 67679 | 65983 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2147 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1990 12:00:00 AM | 10 | 3x4 | Permit Number 29011 | 5999343.04127 | 2116289.27507 | 37.7908879879486 | -122.44616878266001 | (37.7908879879486, -122.44616878266) | |
| 67804 | 67804 | 51571 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 494 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | Permit Number 47868 | 5984728.581040001 | 2112539.46721 | 37.779746669398 | -122.4964565965 | (37.779746669398, -122.4964565965) | ||
| 71789 | 71789 | 50877 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2601on STEINER Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2004 12:00:00 AM | 14 | Permit Number 47387 | 6002325.5669599995 | 2115734.74753 | 37.789535271782 | -122.43580969708599 | (37.789535271782, -122.435809697086) | ||
| 72087 | 72087 | 42958 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2243 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | 13 | Permit Number 42847 | 6002313.59628 | 2115979.02805 | 37.7902053233739 | -122.435868599962 | (37.7902053233739, -122.435868599962) | ||
| 72223 | 72223 | 87002 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | 3x3 | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | ||
| 72364 | 72364 | 50989 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3880 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Permit Number 47473 | 5996269.10887 | 2115596.09858 | 37.7888086870176 | -122.45675423481899 | (37.7888086870176, -122.456754234819) | |||
| 72373 | 72373 | 122576 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1910 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | Permit Number 779012 | 5986951.5849 | 2102234.0134 | 37.75158073125021 | -122.48800892313601 | (37.7515807312502, -122.488008923136) | ||
| 73211 | 73211 | 64087 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 474 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1987 12:00:00 AM | 19 | Permit Number 24849 | 6010630.0202 | 2119988.0407 | 37.801682008022496 | -122.407377010865 | (37.8016820080225, -122.407377010865) | ||
| 73295 | 73295 | 52034 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2960 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Permit Number 48246 | 6002027.71863 | 2118348.63065 | 37.7966953942316 | -122.437027433096 | (37.7966953942316, -122.437027433096) | |||
| 74119 | 74119 | 106241 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Permit Number 770844 | 6012039.11056 | 2105754.27928 | 37.7626781762725 | -122.401499947673 | (37.7626781762725, -122.401499947673) | |||
| 74534 | 74534 | 30341 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3789 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/1956 12:00:00 AM | 10 | Permit Number 27 | 6001954.75028 | 2121707.36831 | 37.8059134550954 | -122.437520567314 | (37.8059134550954, -122.437520567314) | ||
| 77600 | 77600 | 99908 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 77907 | 77907 | 97260 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1994@ Octavia Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004661.4 | 2117107.1 | 37.7934358122691 | -122.427825787413 | (37.7934358122691, -122.427825787413) | |||||
| 77928 | 77928 | 40094 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2249 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/1999 12:00:00 AM | Permit Number 41318 | 6001849.57530622 | 2114273.14459713 | 37.7854950354219 | -122.437351872267 | (37.7854950354219, -122.437351872267) | |||
| 77970 | 77970 | 12741 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1638 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 4X4 | 5990321.4540800005 | 2114762.4147099997 | 37.786176325151295 | -122.47727111168899 | (37.7861763251513, -122.477271111689) | |||
| 78040 | 78040 | 99901 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 79124 | 79124 | 11774 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 2x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
| 79616 | 79616 | 24935 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 79905 | 79905 | 6621 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1415 Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | |||
| 80213 | 80213 | 99606 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2801X Buchanan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43709 | 6003513.0 | 2117956.0 | 37.7957016423098 | -122.43185997681299 | (37.7957016423098, -122.431859976813) | ||||
| 80341 | 80341 | 99902 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2001X Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | ||||
| 80803 | 80803 | 47791 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 415 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45915 | 5995369.31891331 | 2098249.44976906 | 37.741127575703004 | -122.45861111062 | (37.741127575703, -122.45861111062) | ||
| 80818 | 80818 | 12743 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1641 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5990285.065780001 | 2114712.64103 | 37.7860375492525 | -122.477393365207 | (37.7860375492525, -122.477393365207) | |||
| 81179 | 81179 | 6632 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1415 Evans Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | |||
| 81571 | 81571 | 30419 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 599 Jackson St | 2 | 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) | |||
| 81600 | 81600 | 87004 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 81784 | 81784 | 7920 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1295X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6005919.56037 | 2114492.67616 | 37.786328349346 | -122.423286518029 | (37.786328349346, -122.423286518029) | |||
| 81857 | 81857 | 53099 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 370@HILL WAY Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2006 12:00:00 AM | Permit Number 49061 | 5996124.75088045 | 2106531.46709728 | 37.763911303006296 | -122.45659790095199 | (37.7639113030063, -122.456597900952) | |||
| 81922 | 81922 | 3865 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 220 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X4 | 6016069.3729239 | 2096169.6764515 | 37.7365849077155 | -122.386892111244 | (37.7365849077155, -122.386892111244) | |||
| 82012 | 82012 | 38955 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1322 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | Permit Number 40750 | 5999535.03970594 | 2108258.16543211 | 37.768847591977796 | -122.44492690983 | (37.7688475919778, -122.44492690983) | |||
| 82420 | 82420 | 87086 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2298 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50031 | 6002046.0 | 2118096.0 | 37.7960027754164 | -122.436946080345 | (37.7960027754164, -122.436946080345) | |||
| 82591 | 82591 | 24927 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 36 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 83248 | 83248 | 24932 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/22/1996 12:00:00 AM | 18 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 83315 | 83315 | 88823 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 110 Clayton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51710 | 5998275.0 | 2110294.0 | 37.7743654794888 | -122.44943198445 | (37.7743654794888, -122.44943198445) | ||||
| 84689 | 84689 | 49310 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 499@ Taylor Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | Permit Number 46313 | 6008403.82866353 | 2121370.35158903 | 37.8053526360585 | -122.415178583983 | (37.8053526360585, -122.415178583983) | |||
| 84840 | 84840 | 44378 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2914 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2001 12:00:00 AM | Permit Number 43741 | 6000185.55647701 | 2116798.34873064 | 37.7923338489092 | -122.443290306111 | (37.7923338489092, -122.443290306111) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | |||
| 88642 | 88642 | 51704 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 171 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2016 12:00:00 AM | 3 | Permit Number 777735 | 6001742.29918465 | 2107821.21142041 | 37.767773548810204 | -122.437260877297 | (37.7677735488102, -122.437260877297) | ||
| 88826 | 88826 | 22610 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 90193 | 90193 | 95330 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 771 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x4.5 | 6002023.0 | 2108753.0 | 37.7703479631409 | -122.436356663462 | (37.7703479631409, -122.436356663462) | |||
| 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) | |||
| 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) | |||
| 91193 | 91193 | 11791 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
| 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) | ||||
| 92042 | 92042 | 11788 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
| 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) | |||
| 92803 | 92803 | 12746 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1708 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5990140.905069999 | 2114757.41663 | 37.7861521246527 | -122.477895391404 | (37.7861521246527, -122.477895391404) |
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");