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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46233 | 46233 | 220163 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004924.61859 | 2096505.26609 | 37.736882985860795 | -122.42544820577 | (37.7368829858608, -122.42544820577) | ||||
46722 | 46722 | 247530 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6000087.40838 | 2108481.3833 | 37.7694920012902 | -122.44303234398501 | (37.7694920012902, -122.443032343985) | ||||
47130 | 47130 | 247535 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6000144.0267 | 2108489.25837 | 37.769516852242496 | -122.442837069672 | (37.7695168522425, -122.442837069672) | ||||
47212 | 47212 | 220136 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2501 25th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6011420.7800900005 | 2101810.83863 | 37.7518158408332 | -122.40336111083401 | (37.7518158408332, -122.403361110834) | ||||
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) | |||
47311 | 47311 | 220158 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 66 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6004531.65878 | 2096118.78837 | 37.735799595073104 | -122.426779327416 | (37.7357995950731, -122.426779327416) | ||||
47597 | 47597 | 188667 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Dorman Ave | 2 | : 4 | Tree 1 | Private 1 | 24 | 6011636.48706 | 2097465.68323 | 37.7398970259256 | -122.402309681047 | (37.7398970259256, -122.402309681047) | ||||
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) | ||
49102 | 49102 | 248109 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 138 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010416.26244 | 2099462.28287 | 37.7453110660681 | -122.406669396477 | (37.7453110660681, -122.406669396477) | ||||
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) | ||
49471 | 49471 | 201375 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Fairfax Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 6018327.36542 | 2095666.8943900003 | 37.7353291318294 | -122.379050271262 | (37.7353291318294, -122.379050271262) | ||||
49587 | 49587 | 188634 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 151 Helena St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6010981.22837 | 2096191.91786 | 37.736362938482706 | -122.404485665384 | (37.7363629384827, -122.404485665384) | ||||
49917 | 49917 | 220142 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2300 22nd St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6011259.06651 | 2103712.6119 | 37.757028657663795 | -122.40405416618 | (37.7570286576638, -122.40405416618) | ||||
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) | |||
50321 | 50321 | 74916 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2350 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 20 | 5991352.5470199995 | 2112035.32766 | 37.778748267925295 | -122.473504845805 | (37.7787482679253, -122.473504845805) | ||
50359 | 50359 | 220161 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004865.4895 | 2096506.1527200001 | 37.736882079352895 | -122.42565270441001 | (37.7368820793529, -122.42565270441) | ||||
50471 | 50471 | 220157 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 65 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004526.08475 | 2096117.80265 | 37.7357965733541 | -122.426798528853 | (37.7357965733541, -122.426798528853) | ||||
50601 | 50601 | 203272 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 52 Burnside Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6001156.85271 | 2095752.02814 | 37.7346011692919 | -122.43842106119699 | (37.7346011692919, -122.438421061197) | ||||
50657 | 50657 | 187735 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 299x Cashmere St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6016637.03713 | 2096003.6378799998 | 37.7361604138763 | -122.384917870088 | (37.7361604138763, -122.384917870088) | ||||
50866 | 50866 | 220141 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2300 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6011266.56485 | 2103710.7886 | 37.7570240702343 | -122.404028105623 | (37.7570240702343, -122.404028105623) | ||||
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) | |
51218 | 51218 | 203276 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 52 Burnside Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6001144.6572900005 | 2095723.5537599998 | 37.734522291555294 | -122.43846118534799 | (37.7345222915553, -122.438461185348) | ||||
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) | ||
52850 | 52850 | 220146 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 450 Bosworth St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6003150.7799 | 2095211.43274 | 37.7332300323227 | -122.431488808967 | (37.7332300323227, -122.431488808967) | ||||
53119 | 53119 | 175069 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Woolsey St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6011573.1556 | 2092162.2260200002 | 37.7253313074768 | -122.402155892479 | (37.7253313074768, -122.402155892479) | ||||
53208 | 53208 | 220190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 78 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004897.78998 | 2096535.50608 | 37.73696450219779 | -122.425543115723 | (37.7369645021978, -122.425543115723) | ||||
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) | |||||
53526 | 53526 | 188662 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6016659.34022 | 2099218.12626 | 37.7449879810223 | -122.38506465383101 | (37.7449879810223, -122.385064653831) | ||||
53970 | 53970 | 188566 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 901 Iowa St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6014791.61868 | 2102890.82424 | 37.7549689439879 | -122.391779701799 | (37.7549689439879, -122.391779701799) | ||||
54181 | 54181 | 187745 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Dukes Ct | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6016145.55201 | 2096259.4396400002 | 37.7368355969845 | -122.386634982516 | (37.7368355969845, -122.386634982516) | ||||
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) | ||
54444 | 54444 | 125278 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Greenwich St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6006716.82854 | 2119779.13638 | 37.800888612776106 | -122.420903634692 | (37.8008886127761, -122.420903634692) | ||||
54656 | 54656 | 103940 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2300 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | |||||
55386 | 55386 | 220155 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004171.837169999 | 2095877.8468099998 | 37.735117673337705 | -122.428006207723 | (37.7351176733377, -122.428006207723) | ||||
55494 | 55494 | 188725 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3311 Jennings St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6013382.39836 | 2089856.6205900002 | 37.7191013987931 | -122.395739991411 | (37.7191013987931, -122.395739991411) | ||||
55717 | 55717 | 98543 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 555 Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
55759 | 55759 | 188646 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6018092.675340001 | 2098102.14022 | 37.74200288923021 | -122.380030855133 | (37.7420028892302, -122.380030855133) | ||||
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) | ||
56158 | 56158 | 247931 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1099 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010377.81236 | 2098773.8118 | 37.7434185228518 | -122.406753840137 | (37.7434185228518, -122.406753840137) | ||||
56563 | 56563 | 188656 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Cargo Way | 122 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6016757.253769999 | 2099196.6677 | 37.7449344758533 | -122.384724588679 | (37.7449344758533, -122.384724588679) | ||||
56776 | 56776 | 187772 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1427x Innes Ave | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6016235.94312 | 2096682.30704 | 37.7380017092031 | -122.3863519317 | (37.7380017092031, -122.3863519317) | ||||
57106 | 57106 | 220148 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004123.55506 | 2095814.8430700002 | 37.7349419476051 | -122.428168647787 | (37.7349419476051, -122.428168647787) | ||||
57145 | 57145 | 220174 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004973.16585 | 2096557.19919 | 37.7370283252818 | -122.425284050737 | (37.7370283252818, -122.425284050737) | ||||
57233 | 57233 | 203270 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 52 Burnside Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6001166.17423 | 2095753.81627 | 37.7346066092953 | -122.438388961704 | (37.7346066092953, -122.438388961704) | ||||
57277 | 57277 | 119514 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 741 31st Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5986354.9828699995 | 2110811.50583 | 37.775097324761 | -122.49070306495399 | (37.775097324761, -122.490703064954) | ||||
58205 | 58205 | 188572 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Pennsylvania Ave | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014321.6155199995 | 2106524.04213 | 37.764918870439 | -122.39365939726801 | (37.764918870439, -122.393659397268) | ||||
58213 | 58213 | 120394 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 735 24th Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5988458.95627 | 2110817.6647900003 | 37.7752369136053 | -122.483425496649 | (37.7752369136053, -122.483425496649) | ||||
58370 | 58370 | 187738 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6016145.734540001 | 2096191.5007099998 | 37.7366490605065 | -122.38662961537399 | (37.7366490605065, -122.386629615374) | ||||
58643 | 58643 | 246871 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3090x Market St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 5999923.98222 | 2105342.76453 | 37.760864817484396 | -122.443372153705 | (37.7608648174844, -122.443372153705) | ||||
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) | ||||
59590 | 59590 | 220164 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004931.31387 | 2096515.53098 | 37.7369115492209 | -122.425425787491 | (37.7369115492209, -122.425425787491) | ||||
60005 | 60005 | 220150 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6005133.60427 | 2096768.5161400002 | 37.7376176168434 | -122.424744371178 | (37.7376176168434, -122.424744371178) | ||||
60424 | 60424 | 125285 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1015 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6008615.56594 | 2118630.81045 | 37.7978424372369 | -122.41425188820699 | (37.7978424372369, -122.414251888207) | ||||
60507 | 60507 | 188584 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012486.48206 | 2103413.8081 | 37.756276710205995 | -122.39978828959299 | (37.756276710206, -122.399788289593) | ||||
61454 | 61454 | 220280 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Bemis St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6003925.29799 | 2097019.8186 | 37.7382393172918 | -122.42893997290501 | (37.7382393172918, -122.428939972905) | ||||
61532 | 61532 | 220171 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004943.37646 | 2096556.00352 | 37.7370233592275 | -122.425386961047 | (37.7370233592275, -122.425386961047) | ||||
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) | ||
62878 | 62878 | 203275 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 52 Burnside Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001153.45245 | 2095743.21498 | 37.7345767769884 | -122.438432185797 | (37.7345767769884, -122.438432185797) | ||||
63033 | 63033 | 203822 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 210 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5996371.78556 | 2094806.57712 | 37.731731848127 | -122.454896260653 | (37.731731848127, -122.454896260653) | ||||
63150 | 63150 | 188587 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 55 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6012500.08207 | 2102956.31087 | 37.7550212809088 | -122.399709133985 | (37.7550212809088, -122.399709133985) | ||||
63293 | 63293 | 221406 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3975 22nd St | 1 | : 4 | Tree 1 | Private 1 | 11 | 6001983.388259999 | 2102912.1826400002 | 37.7543082507347 | -122.43607565629 | (37.7543082507347, -122.43607565629) | ||||
63519 | 63519 | 187749 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1020 Griffith St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | 6018386.6897599995 | 2093315.1959 | 37.7288750976933 | -122.378681918831 | (37.7288750976933, -122.378681918831) | ||||
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) | ||||
64021 | 64021 | 187756 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6018040.44211 | 2093268.12413 | 37.728726753622496 | -122.379875664545 | (37.7287267536225, -122.379875664545) | ||||
64508 | 64508 | 247542 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 24 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6000205.7463 | 2108507.1222099997 | 37.769569420322 | -122.442624867448 | (37.769569420322, -122.442624867448) | ||||
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) | ||
65523 | 65523 | 201544 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 601 Innes Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6020625.625519999 | 2093377.92947 | 37.7291705267859 | -122.370946000964 | (37.7291705267859, -122.370946000964) | ||||
65608 | 65608 | 73728 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1714 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/1988 12:00:00 AM | 20 | 6010056.6035 | 2120001.6041 | 37.8016871392069 | -122.409362262219 | (37.8016871392069, -122.409362262219) | ||
65626 | 65626 | 247850 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 152 Chapman St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 42 | 6009080.756440001 | 2098231.91815 | 37.7418579436943 | -122.41120047681801 | (37.7418579436943, -122.411200476818) | ||||
65971 | 65971 | 220202 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6003538.0871 | 2095667.4408599997 | 37.7345040713105 | -122.430182303581 | (37.7345040713105, -122.430182303581) | ||||
66072 | 66072 | 217842 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 32 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5991425.94511 | 2095892.37177 | 37.734428210798995 | -122.47207398173799 | (37.734428210799, -122.472073981738) | ||||
66114 | 66114 | 83328 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1653-1655 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 23 | 6008329.52279 | 2118179.08917 | 37.7965860510686 | -122.415209687771 | (37.7965860510686, -122.415209687771) | ||
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) | ||
66210 | 66210 | 188635 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 151 Helena St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6010991.600269999 | 2096196.82144 | 37.736376982304 | -122.40445015025499 | (37.736376982304, -122.404450150255) | ||||
66538 | 66538 | 220278 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3925 21st St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6002292.19971 | 2103528.34865 | 37.7560176344239 | -122.435051775442 | (37.7560176344239, -122.435051775442) | ||||
66596 | 66596 | 248070 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 20 Rutledge St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6010599.59932 | 2099402.0661 | 37.745155979779504 | -122.406031203374 | (37.7451559797795, -122.406031203374) | ||||
66689 | 66689 | 187761 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1040 Palou Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6017511.07328 | 2093334.4830599998 | 37.7288797462969 | -122.381710357951 | (37.7288797462969, -122.381710357951) | ||||
67096 | 67096 | 220180 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 45 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004956.4511400005 | 2096571.71335 | 37.7370672335752 | -122.425342873587 | (37.7370672335752, -122.425342873587) | ||||
67345 | 67345 | 220168 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 32 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6004945.7660300005 | 2096533.5746 | 37.7369619094711 | -122.42537710358499 | (37.7369619094711, -122.425377103585) | ||||
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) | |
67610 | 67610 | 220178 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004980.92808 | 2096566.55389 | 37.7370544497104 | -122.425257878673 | (37.7370544497104, -122.425257878673) | ||||
67675 | 67675 | 125287 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 945 Green St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6008576.87154 | 2118976.92053 | 37.798790596063206 | -122.414410284916 | (37.7987905960632, -122.414410284916) | ||||
67831 | 67831 | 188723 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 961 Le Conte Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6013346.445730001 | 2089388.2762799999 | 37.717813418545205 | -122.39583146685499 | (37.7178134185452, -122.395831466855) | ||||
68248 | 68248 | 188640 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 151 Helena St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011049.32488 | 2096197.75265 | 37.736382764940295 | -122.404250636558 | (37.7363827649403, -122.404250636558) | ||||
68265 | 68265 | 217845 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5991433.42379 | 2095847.21705 | 37.7343046601167 | -122.47204483559999 | (37.7343046601167, -122.4720448356) | ||||
69221 | 69221 | 247529 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000073.75314 | 2108487.72588 | 37.7695086378454 | -122.44308003233499 | (37.7695086378454, -122.443080032335) | ||||
69509 | 69509 | 220166 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6004931.1825 | 2096526.6539599998 | 37.7369420829968 | -122.425427033027 | (37.7369420829968, -122.425427033027) | ||||
70806 | 70806 | 220156 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 64 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004516.6061 | 2096115.66582 | 37.7357901701732 | -122.426831148142 | (37.7357901701732, -122.426831148142) | ||||
70829 | 70829 | 187762 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 135 Reardon Rd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6018971.39793 | 2093438.5075400001 | 37.72924590436129 | -122.37666906882099 | (37.7292459043613, -122.376669068821) | ||||
71608 | 71608 | 188660 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6017087.3290800005 | 2098898.6066400004 | 37.7441343103446 | -122.38356249103902 | (37.7441343103446, -122.383562491039) | ||||
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) | ||
71860 | 71860 | 188638 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 151 Helena St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6011031.7538 | 2096195.4025700002 | 37.736375330259 | -122.40431122211001 | (37.736375330259, -122.40431122211) | ||||
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) | ||
72358 | 72358 | 124133 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3500x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5996054.79965 | 2112880.00292 | 37.781338707390105 | -122.45729914105499 | (37.7813387073901, -122.457299141055) | ||||
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) | |||
72616 | 72616 | 188650 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700x Quesada Ave | 51 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6014234.97615 | 2095377.1002900002 | 37.734306916536 | -122.39317901359699 | (37.734306916536, -122.393179013597) | ||||
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) |
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");