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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
769 | 769 | 110848 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2668 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 778643 | 6000804.34505 | 2117582.1485 | 37.7945212238167 | -122.441205550194 | (37.7945212238167, -122.441205550194) | ||
1261 | 1261 | 122608 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1214 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5987092.2626 | 2106978.1702 | 37.7646150951119 | -122.487870979055 | (37.7646150951119, -122.487870979055) | |||
1523 | 1523 | 142666 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2310 MASON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6008911.1908 | 2121214.7045 | 37.8049537680909 | -122.413411770849 | (37.8049537680909, -122.413411770849) | |||
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) | ||||
1814 | 1814 | 105384 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2853 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x3 | 5999429.08796 | 2117689.0147700002 | 37.794736216656794 | -122.445971784396 | (37.7947362166568, -122.445971784396) | |||
2037 | 2037 | 124755 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2040 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | Permit Number 779873 | 6003722.50351 | 2117641.05418 | 37.794848756005 | -122.431112566798 | (37.794848756005, -122.431112566798) | ||
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) | ||||
2107 | 2107 | 250672 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 726 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 5986349.68151 | 2114864.86182 | 37.786226371002705 | -122.491019750162 | (37.7862263710027, -122.491019750162) | |||
2120 | 2120 | 110253 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1322 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | 6000252.5201 | 2113528.9926 | 37.783360865552396 | -122.442823740221 | (37.7833608655524, -122.442823740221) | |||
2188 | 2188 | 124801 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2898 Union St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | Permit Number 780062 | 5999229.08983 | 2118053.40815 | 37.7957253216105 | -122.446690033314 | (37.7957253216105, -122.446690033314) | ||
2239 | 2239 | 203945 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2579 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991715.80084 | 2097896.7211700003 | 37.7399484158804 | -122.471217847832 | (37.7399484158804, -122.471217847832) | |||
2248 | 2248 | 125016 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3399X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6001832.0 | 2119600.0 | 37.800120199825 | -122.437794333712 | (37.800120199825, -122.437794333712) | |||
2394 | 2394 | 125087 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2498X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | Permit Number 779691 | 6001734.0 | 2116823.0 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | ||
2440 | 2440 | 125088 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2498X Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | Permit Number 779691 | 6001734.0 | 2116823.0 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | ||
2463 | 2463 | 106683 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 125 Maple St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6x300 | 5996555.44655 | 2115800.39633 | 37.789386070660704 | -122.45577832652201 | (37.7893860706607, -122.455778326522) | |||
2746 | 2746 | 181806 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5986469.7425 | 2099569.8124 | 37.7442374331929 | -122.489479287744 | (37.7442374331929, -122.489479287744) | |||
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) | ||||
2895 | 2895 | 114573 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3621 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5997465.48926 | 2115720.33673 | 37.7892184334409 | -122.452623918478 | (37.7892184334409, -122.452623918478) | |||
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) | ||||
4138 | 4138 | 203734 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2328 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | Permit Number 770921 | 5992653.8964 | 2099572.36715 | 37.7446035325326 | -122.468096189498 | (37.7446035325326, -122.468096189498) | ||
4264 | 4264 | 107589 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2760 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6000110.02976 | 2118059.62225 | 37.7957926664564 | -122.443642277677 | (37.7957926664564, -122.443642277677) | |||
4480 | 4480 | 220292 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3000X 21st St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6007965.909 | 2103878.5060799997 | 37.757299618008396 | -122.415454932923 | (37.7572996180084, -122.415454932923) | |||
4510 | 4510 | 220293 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3000X 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6008143.26275 | 2103888.31143 | 37.757336508186896 | -122.41484226615201 | (37.7573365081869, -122.414842266152) | |||
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) | |||||
5759 | 5759 | 114574 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3621 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5997452.80117 | 2115716.84337 | 37.7892081146058 | -122.45266756527201 | (37.7892081146058, -122.452667565272) | |||
5827 | 5827 | 120505 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3001X Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5999789.0039 | 2116358.84365 | 37.7911044628415 | -122.44463077918199 | (37.7911044628415, -122.444630779182) | |||
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) | ||||
6287 | 6287 | 102623 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 351 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010148.1574 | 2120916.7901 | 37.80420514282329 | -122.40911005673401 | (37.8042051428233, -122.409110056734) | |||
6478 | 6478 | 98738 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1150 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 3 | 4X4 | 6001885.6171 | 2112431.4484 | 37.780440254610205 | -122.43709527307301 | (37.7804402546102, -122.437095273073) | ||
6550 | 6550 | 114575 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3621 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5997436.353519999 | 2115714.9226900004 | 37.789201898491704 | -122.452724333156 | (37.7892018984917, -122.452724333156) | |||
6686 | 6686 | 114571 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3633 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777013 | 5997418.550890001 | 2115712.12008 | 37.7891931831629 | -122.452785725389 | (37.7891931831629, -122.452785725389) | ||
7235 | 7235 | 120506 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3001X Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5999798.014359999 | 2116362.9569200003 | 37.791116270957 | -122.444599899165 | (37.791116270957, -122.444599899165) | |||
7274 | 7274 | 112384 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3080 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 6x6 | 5999474.64167 | 2116368.74438 | 37.791113704275 | -122.445719170201 | (37.791113704275, -122.445719170201) | |||
7499 | 7499 | 104699 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6011357.95285 | 2118999.80647 | 37.7990092725121 | -122.40478840238801 | (37.7990092725121, -122.404788402388) | |||
7508 | 7508 | 100204 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2237 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 5x5 | 6001902.2596 | 2114280.466 | 37.7855181330415 | -122.437170124873 | (37.7855181330415, -122.437170124873) | |||
7705 | 7705 | 104698 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6011319.973040001 | 2118997.1094299997 | 37.7989997441925 | -122.40491963593901 | (37.7989997441925, -122.404919635939) | |||
7853 | 7853 | 114578 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3610 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x6 | 5997431.80475 | 2115758.42968 | 37.789321096433504 | -122.45274321263099 | (37.7893210964335, -122.452743212631) | |||
7973 | 7973 | 107590 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2760 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6000109.34681 | 2118076.29285 | 37.7958384005634 | -122.443645838983 | (37.7958384005634, -122.443645838983) | |||
8154 | 8154 | 104700 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6011383.62949 | 2119002.34589 | 37.7990176802704 | -122.40469973101801 | (37.7990176802704, -122.404699731018) | |||
8500 | 8500 | 104697 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6011289.75094 | 2118992.82516 | 37.798986291241796 | -122.40502391323099 | (37.7989862912418, -122.405023913231) | |||
8551 | 8551 | 112044 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2418 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6002377.10471 | 2117102.71936 | 37.793294297651 | -122.435729294977 | (37.793294297651, -122.435729294977) | |||
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) | |||||
9971 | 9971 | 121203 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3041 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | Permit Number 778902 | 5999408.34577 | 2119299.99025 | 37.7991583414361 | -122.446159489987 | (37.7991583414361, -122.446159489987) | ||
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) | ||||
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) | |||||
10259 | 10259 | 141190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1771 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9999 | Width 0ft | 6002407.0405 | 2112959.471 | 37.781919696317296 | -122.43532920805599 | (37.7819196963173, -122.435329208056) | |||
10422 | 10422 | 100386 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1630 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5989668.805 | 2104235.219 | 37.7572336462205 | -122.478758883384 | (37.7572336462205, -122.478758883384) | |||
10531 | 10531 | 120538 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002576.6751 | 2087720.0510900002 | 37.7126278178947 | -122.43293862581999 | (37.7126278178947, -122.43293862582) | |||
10808 | 10808 | 100387 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1630 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5989667.3817 | 2104248.5033 | 37.75727003871479 | -122.47876477719299 | (37.7572700387148, -122.478764777193) | |||
10853 | 10853 | 102802 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1245 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5987672.179 | 2106793.3292 | 37.764141382947706 | -122.485851660773 | (37.7641413829477, -122.485851660773) | |||
10888 | 10888 | 113348 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 36 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 15x6 | 6000512.8548 | 2088435.33913 | 37.7144745622345 | -122.440123079431 | (37.7144745622345, -122.440123079431) | |||
10984 | 10984 | 105220 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1443 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5987410.3461 | 2105455.8349 | 37.760453729777396 | -122.48665903725299 | (37.7604537297774, -122.486659037253) | |||
11006 | 11006 | 120949 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2750 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5985472.8534 | 2102314.8398 | 37.7517162845821 | -122.493128443109 | (37.7517162845821, -122.493128443109) | |||
11670 | 11670 | 102444 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 430X Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001528.5407 | 2088896.6516 | 37.715798995606704 | -122.436645469419 | (37.7157989956067, -122.436645469419) | |||
12564 | 12564 | 115359 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 345 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | 5x6 | 6001770.67381 | 2087944.68785 | 37.7131988712114 | -122.43574047716001 | (37.7131988712114, -122.43574047716) | |||
13509 | 13509 | 106317 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1133 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 4x4 | 6012240.80146 | 2103138.9754 | 37.7555083807236 | -122.400618637234 | (37.7555083807236, -122.400618637234) | |||
15924 | 15924 | 122795 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 241 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014055.37556 | 2105891.1297 | 37.7631662338691 | -122.39453593861 | (37.7631662338691, -122.39453593861) | |||
15970 | 15970 | 104641 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 112 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2.5x2.5 | 6009525.15876 | 2111682.0778200002 | 37.7788139428406 | -122.410613470452 | (37.7788139428406, -122.410613470452) | |||
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) | |||||
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) | ||||
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) | ||||
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) | ||||
22286 | 22286 | 188618 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 15 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015989.5781 | 2098825.23782 | 37.7438721192948 | -122.387353189223 | (37.7438721192948, -122.387353189223) | |||
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) | ||||
22364 | 22364 | 249565 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Franklin St | 3 | : 4 | Tree 1 | Private 1 | 25 | Width 4ft | 6005937.376069999 | 2114355.05187 | 37.785951472517 | -122.423215093814 | (37.785951472517, -122.423215093814) | |||
23402 | 23402 | 123384 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 735 03rd Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5995024.54572 | 2110548.53973 | 37.7748779041184 | -122.460694283234 | (37.7748779041184, -122.460694283234) | |||
23416 | 23416 | 247236 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Haight St | 1 | : 4 | Tree 1 | Private 1 | 26 | Width 6ft | 6000176.36555 | 2108836.62464 | 37.770472476353 | -122.442750157415 | (37.770472476353, -122.442750157415) | |||
23448 | 23448 | 121887 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 50 18th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5990232.62779 | 2114784.35142 | 37.78623140306821 | -122.47758002792801 | (37.7862314030682, -122.477580027928) | |||
23476 | 23476 | 187768 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1442 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6016135.99542 | 2097500.7582799997 | 37.740243477167 | -122.3867545627 | (37.740243477167, -122.3867545627) | |||
23489 | 23489 | 247849 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 152 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6009118.007540001 | 2098230.0964599997 | 37.74185503078979 | -122.41107154552401 | (37.7418550307898, -122.411071545524) | ||||
23506 | 23506 | 203697 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1612 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5993725.685740001 | 2104505.50158 | 37.7582104972207 | -122.464748349861 | (37.7582104972207, -122.464748349861) | |||
23509 | 23509 | 188616 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 13 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015976.85216 | 2098785.54996 | 37.7437624397877 | -122.38739442491999 | (37.7437624397877, -122.38739442492) | |||
23529 | 23529 | 185014 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985039.8071 | 2096458.9756 | 37.73561232989871 | -122.494194380975 | (37.7356123298987, -122.494194380975) | |||
23624 | 23624 | 221399 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 38 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6003390.07716 | 2108570.1218 | 37.769923406978705 | -122.431614888542 | (37.7699234069787, -122.431614888542) | |||
23674 | 23674 | 125034 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1467 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002193.9847099995 | 2121545.09547 | 37.8054814954333 | -122.436681037594 | (37.8054814954333, -122.436681037594) | |||
23761 | 23761 | 123510 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2714 Fulton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 8ft | 5994935.84099 | 2110268.0504400004 | 37.774102650784 | -122.460980795496 | (37.774102650784, -122.460980795496) | |||
23878 | 23878 | 106648 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1293 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 5987685.171 | 2106501.0088 | 37.763339508501396 | -122.48578526928301 | (37.7633395085014, -122.485785269283) | ||||
23882 | 23882 | 125253 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 20 Reed St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6008205.34429 | 2117069.05453 | 37.793531190756205 | -122.41556074355101 | (37.7935311907562, -122.415560743551) | ||||
23967 | 23967 | 184113 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2345 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5986890.7956 | 2104347.1916 | 37.7573793976552 | -122.4883744219 | (37.7573793976552, -122.4883744219) | |||
24149 | 24149 | 125090 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3075 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6000094.70412 | 2115753.61769 | 37.789460110053795 | -122.44352957555 | (37.7894601100538, -122.44352957555) | |||
24253 | 24253 | 123529 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2850 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5994479.78836 | 2110203.1842799997 | 37.7738982925338 | -122.462553643166 | (37.7738982925338, -122.462553643166) | |||
24278 | 24278 | 183048 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2600 20th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5990217.9332 | 2097368.8862 | 37.7384123615974 | -122.47635825040301 | (37.7384123615974, -122.476358250403) | |||
24305 | 24305 | 187754 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6018045.40924 | 2093280.41562 | 37.728760777668 | -122.37985934635799 | (37.728760777668, -122.379859346358) | ||||
24361 | 24361 | 124790 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1650 Green St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6005095.79493 | 2118523.91802 | 37.7973505989009 | -122.42642367433099 | (37.7973505989009, -122.426423674331) | |||
24378 | 24378 | 124854 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 55 Casa Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6001534.02589 | 2121572.74926 | 37.8055198982766 | -122.438966893034 | (37.8055198982766, -122.438966893034) | |||
24384 | 24384 | 203942 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1427 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5991551.86269 | 2098375.2612400004 | 37.7412528807104 | -122.47181953924299 | (37.7412528807104, -122.471819539243) |
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");