Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCareAssistant
qCaretaker ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
940 | 940 | 51496 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1350 REVISED Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47808 | 6000958.86990754 | 2110035.78536621 | 37.773809648853 | -122.44012948036101 | (37.773809648853, -122.440129480361) | |||
1500 | 1500 | 251574 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 191 Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999731.0 | 2100707.0 | 37.748125134697 | -122.443706547761 | (37.748125134697, -122.443706547761) | ||||
1635 | 1635 | 251542 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 50 Vista Ln | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 780127 | 5999350.0 | 2102347.0 | 37.752606437592604 | -122.445141915929 | (37.7526064375926, -122.445141915929) | ||||
2081 | 2081 | 252873 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Broderick St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | ||||
2777 | 2777 | 253179 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201x Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001862.0 | 2086566.0 | 37.709418484595 | -122.43532626528601 | (37.709418484595, -122.435326265286) | ||||
2854 | 2854 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Lopez Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
3571 | 3571 | 39975 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
3689 | 3689 | 252876 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Baker St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | ||||
3694 | 3694 | 252874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Post St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000387.0 | 2114050.0 | 37.784799083264396 | -122.44239591065 | (37.7847990832644, -122.44239591065) | ||||
3756 | 3756 | 252875 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Post St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000387.0 | 2114050.0 | 37.784799083264396 | -122.44239591065 | (37.7847990832644, -122.44239591065) | ||||
3817 | 3817 | 253560 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 535 Castenada Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5992829.16774 | 2099990.2564 | 37.7457610706327 | -122.46752052447701 | (37.7457610706327, -122.467520524477) | ||||
3851 | 3851 | 252871 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2557 Sutter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5999847.0 | 2113975.0 | 37.7845623594454 | -122.444258736096 | (37.7845623594454, -122.444258736096) | |||||
4010 | 4010 | 253604 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 267 Teresita Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x10 | 5997729.0 | 2098564.0 | 37.7421265906625 | -122.450474893449 | (37.7421265906625, -122.450474893449) | ||||
4105 | 4105 | 253605 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 301 Teresita Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5997753.0 | 2098469.0 | 37.741867117319 | -122.45038506263799 | (37.741867117319, -122.450385062638) | ||||
4446 | 4446 | 253627 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 5991061.0 | 2093828.0 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | ||||
4534 | 4534 | 141427 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 306 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6005914.5406 | 2110724.5553 | 37.7759817285641 | -122.423035961371 | (37.7759817285641, -122.423035961371) | ||||
5181 | 5181 | 253819 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100x Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001057.0 | 2086858.0 | 37.71017450293179 | -122.43812937571998 | (37.7101745029318, -122.43812937572) | |||||
6067 | 6067 | 114090 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2835 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001183.088719999 | 2115909.2328 | 37.7899493996846 | -122.43977505527701 | (37.7899493996846, -122.439775055277) | ||||
9853 | 9853 | 173717 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 614 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004584.0 | 2110624.0 | 37.775630457098295 | -122.427631485331 | (37.7756304570983, -122.427631485331) | ||||
9962 | 9962 | 173753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1140 Lawton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990653.0 | 2104548.0 | 37.7581495573033 | -122.475378025252 | (37.7581495573033, -122.475378025252) | |||||
10116 | 10116 | 173859 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 118 Saint Mary's Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | ||||
10123 | 10123 | 173857 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 118 Saint Mary's Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | ||||
10124 | 10124 | 173862 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 98 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999618.0 | 2107794.0 | 37.7675778447629 | -122.444606591258 | (37.7675778447629, -122.444606591258) | ||||
10125 | 10125 | 173858 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 118 Saint Mary's Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | ||||
10162 | 10162 | 173888 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Vasquez Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995783.0 | 2100209.0 | 37.7465317821399 | -122.457322486502 | (37.7465317821399, -122.457322486502) | |||||
11073 | 11073 | 30310 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
13306 | 13306 | 187657 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2072 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5991666.0 | 2101424.0 | 37.7496305363998 | -122.47164701446 | (37.7496305363998, -122.47164701446) | ||||
13382 | 13382 | 39972 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
14068 | 14068 | 30309 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
16111 | 16111 | 102843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
17865 | 17865 | 99661 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1365 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.46532315146601 | (37.7394617231066, -122.465323151466) | |||||
18151 | 18151 | 124716 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2195 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
18154 | 18154 | 111228 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1113 SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001842.0 | 2112262.0 | 37.779972512780105 | -122.4372340286 | (37.7799725127801, -122.4372340286) | ||||
18193 | 18193 | 39379 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1354 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40920 | 6007143.93712268 | 2107602.08417603 | 37.7674774616365 | -122.41856167807501 | (37.7674774616365, -122.418561678075) | |||
18488 | 18488 | 98514 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1209 Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995023.6 | 2091955.9 | 37.7238271478872 | -122.45935081328001 | (37.7238271478872, -122.45935081328) | ||||
18892 | 18892 | 116488 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2149 LYON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999319.0 | 2116238.0 | 37.7907458271484 | -122.446248274058 | (37.7907458271484, -122.446248274058) | |||||
19122 | 19122 | 103382 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3199X JACKSON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999158.0 | 2116301.0 | 37.7909096124749 | -122.446809858862 | (37.7909096124749, -122.446809858862) | |||||
19616 | 19616 | 116162 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2569 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000631.0 | 2118874.0 | 37.7980584318084 | -122.44189810937901 | (37.7980584318084, -122.441898109379) | ||||
19654 | 19654 | 104292 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2245 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999485.4 | 2120797.2 | 37.8032736772553 | -122.446000602494 | (37.8032736772553, -122.446000602494) | |||||
19684 | 19684 | 50106 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1550 Portola Dr | 1 | 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) | ||
19698 | 19698 | 117036 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2220x SUTTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
19747 | 19747 | 118326 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3200 CLAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999426.0 | 2115708.0 | 37.7892966967134 | -122.44583992728799 | (37.7892966967134, -122.445839927288) | ||||
20386 | 20386 | 101023 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3024 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999465.0 | 2119192.0 | 37.7988650643156 | -122.445955676486 | (37.7988650643156, -122.445955676486) | ||||
20617 | 20617 | 87007 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 6 | 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) | |||
22309 | 22309 | 248978 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1801 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987396.0 | 2097538.0 | 37.738712644317204 | -122.486127408072 | (37.7387126443172, -122.486127408072) | ||||
30134 | 30134 | 34162 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1321 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1997 12:00:00 AM | Permit Number 37995 | 6002005.24557776 | 2100252.01136141 | 37.747005294912896 | -122.435809748575 | (37.7470052949129, -122.435809748575) | |||
42983 | 42983 | 30852 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
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) | |||
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) | |||
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) | |||||
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) | |||||
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) | |||||
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) | ||||
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) | ||
77569 | 77569 | 98569 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301X Francisco St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
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) | ||||
77868 | 77868 | 103929 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 191 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x10 | 5994248.3 | 2114379.9 | 37.7853530981444 | -122.46365759100401 | (37.7853530981444, -122.463657591004) | ||||
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) | |||
77934 | 77934 | 105417 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X McAllister St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002220.7882900005 | 2111575.67932 | 37.7781095739995 | -122.43587451144501 | (37.7781095739995, -122.435874511445) | |||||
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) | ||||
78331 | 78331 | 117161 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1383X VERMONT ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6011571.0 | 2102081.0 | 37.752566033842896 | -122.40286062573799 | (37.7525660338429, -122.402860625738) | |||||
78500 | 78500 | 111715 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2390x MASON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008938.0 | 2121373.0 | 37.8053899130211 | -122.41333019555799 | (37.8053899130211, -122.413330195558) | ||||
78929 | 78929 | 99659 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1325 Portola Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | |||||
79003 | 79003 | 106787 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 17TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5990900.3 | 2105751.3 | 37.7614678308385 | -122.47461058270099 | (37.7614678308385, -122.474610582701) | |||||
79292 | 79292 | 112950 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 300X VICENTE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992030.0 | 2097800.0 | 37.73970101338521 | -122.470124446456 | (37.7397010133852, -122.470124446456) | ||||
79402 | 79402 | 105345 | Acacia melanoxylon :: Blackwood Acacia 5 | 466 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5989603.4 | 2089229.6 | 37.7160282834266 | -122.477888136934 | (37.7160282834266, -122.477888136934) | ||||||
79463 | 79463 | 116977 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100x CARGO WAY | 117 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
79528 | 79528 | 110886 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 INDIANA ST | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
79584 | 79584 | 116089 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
79599 | 79599 | 117067 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 299X PRESIDIO AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998965.0 | 2115900.0 | 37.789797545049794 | -122.44744875198299 | (37.7897975450498, -122.447448751983) | ||||
79636 | 79636 | 103385 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 PRESIDIO AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999013.0 | 2116197.0 | 37.79061577152721 | -122.447304062173 | (37.7906157715272, -122.447304062173) | ||||
79770 | 79770 | 115929 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3990 SACRAMENTO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995601.0 | 2114876.0 | 37.7867931062819 | -122.45901362163099 | (37.7867931062819, -122.459013621631) | ||||
79771 | 79771 | 105872 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 595X San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006124.4715599995 | 2100100.1430599997 | 37.7468214281195 | -122.421555015777 | (37.7468214281195, -122.421555015777) | |||||
80060 | 80060 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 Hiliritas Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | ||||
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) | ||||
80478 | 80478 | 98830 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 333@Lopez Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994230.9 | 2100817.4 | 37.748113026994 | -122.46273356703699 | (37.748113026994, -122.462733567037) | |||||
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) | ||
81069 | 81069 | 113145 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 150 BROADMOOR DR | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990980.0 | 2092843.0 | 37.726029586770395 | -122.473393404688 | (37.7260295867704, -122.473393404688) | ||||
81189 | 81189 | 98546 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 555@Rio Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
81372 | 81372 | 116076 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 482X 28TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002704.0 | 2099559.0 | 37.7451421155129 | -122.43334400597 | (37.7451421155129, -122.43334400597) | ||||
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) | |||
81662 | 81662 | 115444 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
81809 | 81809 | 117551 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1696 09TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993456.0 | 2103978.0 | 37.7567465627 | -122.465642709543 | (37.7567465627, -122.465642709543) | ||||
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) | |||
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) | |||
82325 | 82325 | 112951 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 300X VICENTE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992030.0 | 2097800.0 | 37.73970101338521 | -122.470124446456 | (37.7397010133852, -122.470124446456) | ||||
82409 | 82409 | 112489 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2690x Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 3x3 | 6007377.71104 | 2121658.59908 | 37.8060863706979 | -122.418750060411 | (37.8060863706979, -122.418750060411) | |||
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) | |||
82458 | 82458 | 100653 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1594 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x4 | 5992503.0 | 2104630.0 | 37.7584817696578 | -122.46898595103599 | (37.7584817696578, -122.468985951036) | ||||
82505 | 82505 | 104272 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3675 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997210.1 | 2115656.5 | 37.7890285184352 | -122.453502918425 | (37.7890285184352, -122.453502918425) | ||||
83079 | 83079 | 100838 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 10X Tulane St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x9 | 6007491.7 | 2093814.7 | 37.7296399852574 | -122.416382127882 | (37.7296399852574, -122.416382127882) | ||||
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) | ||||
84623 | 84623 | 110884 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 INDIANA ST | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
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) | |||
84801 | 84801 | 113939 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3333 BUCHANAN ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003181.0 | 2119826.0 | 37.8008173514055 | -122.43314243340299 | (37.8008173514055, -122.433142433403) | |||||
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) | |||
85026 | 85026 | 99100 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 60 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993700.7 | 2097327.0 | 37.7384987171226 | -122.464313592449 | (37.7384987171226, -122.464313592449) |
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");