Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16111 | 16111 | 102843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 183456 | 183456 | 187567 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 136 Alpha St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 10ft | 6010892.9605 | 2088110.22572 | 37.7141673547183 | -122.404222218893 | (37.7141673547183, -122.404222218893) | |||
| 68992 | 68992 | 203874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 200 Sargent St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 5993391.13026 | 2089210.0639099998 | 37.716193751229895 | -122.464794638879 | (37.7161937512299, -122.464794638879) | |||
| 51655 | 51655 | 203864 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 Capitol Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5995082.38491 | 2089680.1586900002 | 37.717581884482 | -122.458982907738 | (37.717581884482, -122.458982907738) | |||
| 105643 | 105643 | 104976 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 348 STRATFORD DR | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Permit Number 771068 | 5990941.2 | 2090341.4 | 37.7191585669518 | -122.473345157269 | (37.7191585669518, -122.473345157269) | |||
| 135616 | 135616 | 203898 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3804 19th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 5990605.806480001 | 2090479.00693 | 37.7195169745995 | -122.47451450973401 | (37.7195169745995, -122.474514509734) | |||
| 83097 | 83097 | 203899 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3804 19th Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5990601.43491 | 2090484.5627400002 | 37.719531976188705 | -122.474530025745 | (37.7195319761887, -122.474530025745) | |||
| 170825 | 170825 | 203900 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3804 19th Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 2ft | 5990599.120069999 | 2090493.0550400002 | 37.7195551598198 | -122.474538646659 | (37.7195551598198, -122.474538646659) | |||
| 186416 | 186416 | 203873 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 178 Tara St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 5997913.09605 | 2090617.6625599999 | 37.7203183685688 | -122.449265978542 | (37.7203183685688, -122.449265978542) | |||
| 182634 | 182634 | 174969 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 445 Wayland St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 4ft | 6010264.89767 | 2092223.3382299999 | 37.7254259988853 | -122.40668274244 | (37.7254259988853, -122.40668274244) | |||
| 61405 | 61405 | 203902 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 5002 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5990623.0724599995 | 2093226.54081 | 37.7270620185855 | -122.474655248248 | (37.7270620185855, -122.474655248248) | |||
| 53145 | 53145 | 203903 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 5002 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5990622.28371 | 2093237.1436299998 | 37.727091085566 | -122.474658748425 | (37.727091085566, -122.474658748425) | |||
| 24500 | 24500 | 203904 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 5000 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5990628.04185 | 2093305.0064 | 37.7272777533559 | -122.47464379357001 | (37.7272777533559, -122.47464379357) | |||
| 57053 | 57053 | 203905 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 5000 19th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 8ft | 5990628.4858099995 | 2093315.14661 | 37.7273056215527 | -122.474642998573 | (37.7273056215527, -122.474642998573) | |||
| 57772 | 57772 | 203779 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 788 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 10ft | 5994915.16771 | 2093240.5378299998 | 37.7273482188287 | -122.459818653129 | (37.7273482188287, -122.459818653129) | |||
| 177577 | 177577 | 203906 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 4996 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5990638.47075 | 2093500.4401599998 | 37.727814969685 | -122.47462199853001 | (37.727814969685, -122.47462199853) | |||
| 33152 | 33152 | 187750 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6018189.80767 | 2093163.42935 | 37.728447520437705 | -122.379352023493 | (37.7284475204377, -122.379352023493) | ||||
| 187072 | 187072 | 187751 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | 6018129.3732900005 | 2093209.5083299999 | 37.7285707113551 | -122.379564150189 | (37.7285707113551, -122.379564150189) | ||||
| 168868 | 168868 | 187752 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6018083.616719999 | 2093238.62842 | 37.7286481456935 | -122.379724357202 | (37.7286481456935, -122.379724357202) | ||||
| 182989 | 182989 | 187753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6018088.91826 | 2093246.2132 | 37.72866926445229 | -122.37970655600901 | (37.7286692644523, -122.379706556009) | ||||
| 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) | ||||
| 30738 | 30738 | 187755 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018042.26935 | 2093273.64193 | 37.7287420052256 | -122.379869730822 | (37.7287420052256, -122.379869730822) | ||||
| 156153 | 156153 | 187757 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1040 Palou Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6017577.45499 | 2093289.4287599998 | 37.7287597011768 | -122.38147773753 | (37.7287597011768, -122.38147773753) | ||||
| 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) | ||||
| 133165 | 133165 | 187758 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1040 Palou Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6017560.01516 | 2093300.23406 | 37.7287884075452 | -122.38153877989299 | (37.7287884075452, -122.381538779893) | ||||
| 165389 | 165389 | 187759 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1040 Palou Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 6017547.84189 | 2093311.88395 | 37.7288197237472 | -122.381581673978 | (37.7288197237472, -122.381581673978) | ||||
| 149025 | 149025 | 187760 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1040 Palou Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6017527.04391 | 2093321.80664 | 37.7288458211654 | -122.381654264546 | (37.7288458211654, -122.381654264546) | ||||
| 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) | ||||
| 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) | ||||
| 175159 | 175159 | 203852 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 366 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5997653.19535 | 2093836.4346200002 | 37.7291414912794 | -122.450396278864 | (37.7291414912794, -122.450396278864) | ||||
| 175520 | 175520 | 203853 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 366 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5997667.53367 | 2093836.2933 | 37.729141923854705 | -122.450346700167 | (37.7291419238547, -122.450346700167) | ||||
| 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) | ||||
| 164486 | 164486 | 175060 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 153 Gladstone Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 5ft | 6005789.97929 | 2093692.61819 | 37.729208933235796 | -122.42225649384899 | (37.7292089332358, -122.422256493849) | |||
| 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) | ||||
| 75816 | 75816 | 187763 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 135 Reardon Rd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6018954.68397 | 2093453.67115 | 37.7292866202724 | -122.376727902495 | (37.7292866202724, -122.376727902495) | ||||
| 106068 | 106068 | 100123 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 690 Miramar Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995444.4 | 2093941.6 | 37.729303587844704 | -122.45803982404199 | (37.7293035878447, -122.458039824042) | |||||
| 55430 | 55430 | 203781 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Northwood Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 8ft | 5995760.050530001 | 2094044.5460299999 | 37.729604384015296 | -122.45695604179701 | (37.7296043840153, -122.456956041797) | |||
| 137993 | 137993 | 187765 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 91 Kiska Rd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 6019429.17387 | 2093568.53818 | 37.7296281423191 | -122.375095487273 | (37.7296281423191, -122.375095487273) | ||||
| 46008 | 46008 | 187764 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 91 Kiska Rd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6019412.692980001 | 2093581.83976 | 37.729663759061 | -122.37515338563 | (37.729663759061, -122.37515338563) | ||||
| 150308 | 150308 | 203780 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Northwood Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 5995711.8389800005 | 2094094.29693 | 37.72973821932529 | -122.457126310455 | (37.7297382193253, -122.457126310455) | |||
| 54451 | 54451 | 203994 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 30 Northwood Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 3ft | 5995717.02889 | 2094139.1158599998 | 37.7298615793487 | -122.457111609219 | (37.7298615793487, -122.457111609219) | |||
| 54120 | 54120 | 201561 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 200 Jerrold Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 8ft | 6019745.83299 | 2093765.2966200002 | 37.730185821819795 | -122.374014373583 | (37.7301858218198, -122.374014373583) | |||
| 183085 | 183085 | 203851 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 451 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 5998148.5387 | 2094357.8892299999 | 37.7306016197611 | -122.448721386881 | (37.7306016197611, -122.448721386881) | |||
| 59517 | 59517 | 203894 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 167 Eucalyptus Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 5991199.65464 | 2094648.7466400003 | 37.731000432220895 | -122.472765686283 | (37.7310004322209, -122.472765686283) | |||
| 186354 | 186354 | 203892 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 173 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 5991062.18306 | 2094654.07331 | 37.731007098902104 | -122.47324133234501 | (37.7310070989021, -122.473241332345) | |||
| 170654 | 170654 | 203891 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 173 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 5991044.7899 | 2094655.1338099998 | 37.7310090036421 | -122.473301540158 | (37.7310090036421, -122.473301540158) | |||
| 156181 | 156181 | 203889 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 177 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 5990973.09851 | 2094658.03322 | 37.7310128131802 | -122.47354959834999 | (37.7310128131802, -122.47354959835) | |||
| 71240 | 71240 | 203888 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 177 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5990956.3868 | 2094658.3857 | 37.7310128131833 | -122.47360739868401 | (37.7310128131833, -122.473607398684) | |||
| 43833 | 43833 | 203890 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 175 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5991011.74416 | 2094657.21816 | 37.7310128131914 | -122.473415935702 | (37.7310128131914, -122.473415935702) | |||
| 77172 | 77172 | 203887 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 179 Eucalyptus Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5990924.31615 | 2094659.1181599998 | 37.7310129669604 | -122.47371832465001 | (37.7310129669604, -122.47371832465) | |||
| 59373 | 59373 | 203886 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 179 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 5990904.52602 | 2094659.81663 | 37.7310137385845 | -122.473786792727 | (37.7310137385845, -122.473786792727) | |||
| 156300 | 156300 | 203883 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 181 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5990856.8356099995 | 2094661.5261900001 | 37.7310156703238 | -122.47395178956499 | (37.7310156703238, -122.473951789565) | |||
| 146628 | 146628 | 203885 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 181 Eucalyptus Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 5990886.77711 | 2094660.89457 | 37.7310156703264 | -122.473848231707 | (37.7310156703264, -122.473848231707) | |||
| 55061 | 55061 | 203884 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 181 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 5990872.1544 | 2094661.20304 | 37.7310156703418 | -122.473898806879 | (37.7310156703418, -122.473898806879) | |||
| 94139 | 94139 | 203245 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1616 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5995624.1934 | 2094726.8398099998 | 37.7314699952415 | -122.45747505495599 | (37.7314699952415, -122.457475054956) | |||
| 137370 | 137370 | 203832 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1625 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 10ft | 5995572.09683 | 2094748.54485 | 37.731526599451 | -122.45765673147498 | (37.731526599451, -122.457656731475) | |||
| 62622 | 62622 | 203831 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1635 Plymouth Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 10ft | 5995566.12601 | 2094800.1567400002 | 37.731667970191204 | -122.45768110671699 | (37.7316679701912, -122.457681106717) | |||
| 119956 | 119956 | 111044 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1635 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6x10 | Permit Number 775721 | 5995557.0 | 2094802.0 | 37.731672507077896 | -122.457712790279 | (37.7316725070779, -122.457712790279) | |||
| 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) | ||||
| 153194 | 153194 | 203819 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 224 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5996114.34243 | 2094848.95185 | 37.731833427466505 | -122.455789350407 | (37.7318334274665, -122.455789350407) | ||||
| 60749 | 60749 | 203244 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1648 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5995594.77464 | 2094937.0957099998 | 37.7320456171101 | -122.457591967706 | (37.7320456171101, -122.457591967706) | |||
| 172340 | 172340 | 203243 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1648 Plymouth Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5995591.858580001 | 2094957.07718 | 37.7321003138704 | -122.45760349431002 | (37.7321003138704, -122.45760349431) | |||
| 166553 | 166553 | 203820 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 270 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5996086.90151 | 2095051.7062799998 | 37.7323885672656 | -122.455898870764 | (37.7323885672656, -122.455898870764) | ||||
| 167201 | 167201 | 203823 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 830 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5996652.151769999 | 2095040.8837700002 | 37.7323912769404 | -122.453943898404 | (37.7323912769404, -122.453943898404) | ||||
| 172574 | 172574 | 203242 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1660 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5995530.96911 | 2095074.5537299998 | 37.7324193780388 | -122.457822499013 | (37.7324193780388, -122.457822499013) | |||
| 64879 | 64879 | 203284 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 436 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 5999187.0289199995 | 2095000.6796 | 37.732425900820004 | -122.445177379037 | (37.73242590082, -122.445177379037) | |||
| 40838 | 40838 | 203283 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 436 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 7ft | 5999191.65926 | 2095001.09495 | 37.7324273055688 | -122.445161400772 | (37.7324273055688, -122.445161400772) | |||
| 162653 | 162653 | 203285 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 436 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 5999181.66056 | 2095001.81408 | 37.7324287094117 | -122.445196020186 | (37.7324287094117, -122.445196020186) | |||
| 150624 | 150624 | 203821 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 280 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5996076.68769 | 2095086.62042 | 37.732483846838704 | -122.455936705234 | (37.7324838468387, -122.455936705234) | ||||
| 167981 | 167981 | 203241 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1670 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5995502.95933 | 2095101.70032 | 37.7324923067699 | -122.45792129854999 | (37.7324923067699, -122.45792129855) | |||
| 35594 | 35594 | 203246 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 401 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5995758.26971 | 2095116.97612 | 37.73254891550229 | -122.45703973988998 | (37.7325489155023, -122.45703973989) | |||
| 30922 | 30922 | 203824 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 270 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5996325.39401 | 2095129.7454900001 | 37.732616529229 | -122.455079988546 | (37.732616529229, -122.455079988546) | ||||
| 54986 | 54986 | 203278 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 618 Detroit St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5999459.31749 | 2095070.52066 | 37.7326332062613 | -122.44424103370599 | (37.7326332062613, -122.444241033706) | |||
| 38353 | 38353 | 203250 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 0 | Width 3ft | 5996036.57677 | 2095207.69208 | 37.732813978082596 | -122.456084127481 | (37.7328139780826, -122.456084127481) | |||
| 177089 | 177089 | 203247 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 435 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5995610.12397 | 2095259.68006 | 37.732932237139 | -122.457562233408 | (37.732932237139, -122.457562233408) | |||
| 41085 | 41085 | 203835 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 5995906.667880001 | 2095303.7074 | 37.733070155351896 | -122.456540193489 | (37.7330701553519, -122.456540193489) | |||
| 42911 | 42911 | 203833 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 470 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 10ft | 5995548.29749 | 2095369.378 | 37.7332298893389 | -122.457783917193 | (37.7332298893389, -122.457783917193) | |||
| 167330 | 167330 | 203251 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5996145.80279 | 2095391.0534400002 | 37.7333237129166 | -122.45571975726101 | (37.7333237129166, -122.455719757261) | |||
| 71168 | 71168 | 203834 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 480 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 5995517.77051 | 2095412.33774 | 37.7333460925362 | -122.457892564287 | (37.7333460925362, -122.457892564287) | |||
| 119112 | 119112 | 203252 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 341 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5996075.27063 | 2095441.53755 | 37.733458282063495 | -122.455967253399 | (37.7334582820635, -122.455967253399) | |||
| 175550 | 175550 | 203249 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 380 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5995787.9894199995 | 2095468.33628 | 37.7335153719345 | -122.456962397309 | (37.7335153719345, -122.456962397309) | |||
| 187675 | 187675 | 203253 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 345 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5996049.39925 | 2095464.3554200002 | 37.7335194494626 | -122.45605834663401 | (37.7335194494626, -122.456058346634) | |||
| 65888 | 65888 | 203254 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 355 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5996025.0602 | 2095489.12153 | 37.7335860541429 | -122.45614428315399 | (37.7335860541429, -122.456144283154) | |||
| 152819 | 152819 | 203248 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 489 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 5995426.51291 | 2095536.7894 | 37.7336825630925 | -122.45821706938801 | (37.7336825630925, -122.458217069388) | |||
| 33947 | 33947 | 203279 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 59 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5999700.96572 | 2095477.61898 | 37.7337647863229 | -122.44343483107001 | (37.7337647863229, -122.44343483107) | |||
| 150888 | 150888 | 203280 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 59 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 5999721.17343 | 2095479.15955 | 37.7337701687542 | -122.44336507785499 | (37.7337701687542, -122.443365077855) | |||
| 182589 | 182589 | 203277 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 49 Nordhoff St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6000409.79101 | 2095470.0707200002 | 37.7337844580708 | -122.440983676666 | (37.7337844580708, -122.440983676666) | ||||
| 33643 | 33643 | 203257 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 160 Brentwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5995507.02716 | 2095606.7609400002 | 37.733879314068 | -122.45794377168801 | (37.733879314068, -122.457943771688) | |||
| 165938 | 165938 | 203256 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 166 Brentwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5995465.02335 | 2095623.45541 | 37.733922739644704 | -122.45809019842599 | (37.7339227396447, -122.458090198426) | |||
| 65584 | 65584 | 203255 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 174 Brentwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5995391.75074 | 2095632.23775 | 37.7339426434291 | -122.458344157955 | (37.7339426434291, -122.458344157955) | |||
| 182070 | 182070 | 203837 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 125 Brentwood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 5995775.0475699995 | 2095626.11327 | 37.7339478460191 | -122.457018549183 | (37.7339478460191, -122.457018549183) | |||
| 164954 | 164954 | 203259 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 76 Brentwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5996134.27449 | 2095680.6301099998 | 37.7341181587163 | -122.45578053885299 | (37.7341181587163, -122.455780538853) | |||
| 47185 | 47185 | 203258 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 80 Brentwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5996117.24825 | 2095689.22308 | 37.7341407757719 | -122.45584002452 | (37.7341407757719, -122.45584002452) | |||
| 161915 | 161915 | 186927 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985227.187999999 | 2095919.2321 | 37.7341413011385 | -122.49350678654801 | (37.7341413011385, -122.493506786548) | |||
| 170745 | 170745 | 186928 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985229.8786 | 2095924.6132 | 37.7341562336013 | -122.493497880781 | (37.7341562336013, -122.493497880781) | |||
| 41625 | 41625 | 203836 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 386 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5995958.60933 | 2095699.73792 | 37.7341605410715 | -122.456389245893 | (37.7341605410715, -122.456389245893) | |||
| 54433 | 54433 | 186929 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5985223.4885 | 2095932.3487 | 37.7341770994248 | -122.493520542824 | (37.7341770994248, -122.493520542824) | |||
| 170110 | 170110 | 186932 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985200.2822 | 2095936.7208 | 37.734187746508105 | -122.493601095228 | (37.7341877465081, -122.493601095228) | |||
| 27551 | 27551 | 186933 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985210.7082 | 2095939.4114 | 37.734195744096 | -122.493565247951 | (37.734195744096, -122.493565247951) | |||
| 177200 | 177200 | 186934 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985194.2284 | 2095945.4652 | 37.7342114021566 | -122.493622668946 | (37.7342114021566, -122.493622668946) |
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");