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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 3903 | 3903 | 220233 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Ashbury St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/23/1987 12:00:00 AM | 39 | Width 4ft | Permit Number 12054 | 5999170.85741 | 2106639.03394 | 37.764381073148705 | -122.44607010996201 | (37.7643810731487, -122.446070109962) | |
| 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) | ||||
| 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) | ||||
| 16111 | 16111 | 102843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 24548 | 24548 | 184805 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984688.1718 | 2105711.6678 | 37.7609971073609 | -122.496092516316 | (37.7609971073609, -122.496092516316) | |||
| 25539 | 25539 | 185720 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 0ft | 5984894.4324 | 2100359.2446 | 37.7463129086346 | -122.494984487249 | (37.7463129086346, -122.494984487249) | |||
| 25578 | 25578 | 123143 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 582 10th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 5ft | 5992871.73325 | 2111517.5992400004 | 37.7774145847454 | -122.468211760136 | (37.7774145847454, -122.468211760136) | |||
| 26399 | 26399 | 184774 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984678.2991 | 2105977.4713 | 37.7617263510589 | -122.496146272255 | (37.7617263510589, -122.496146272255) | |||
| 26568 | 26568 | 124644 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 20 Arguello Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 9ft | 5995537.35644 | 2115745.75128 | 37.7891775496077 | -122.459296819974 | (37.7891775496077, -122.459296819974) | |||
| 26833 | 26833 | 203845 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 535 Castenada Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 5992715.17465 | 2100010.79955 | 37.7458108948644 | -122.46791618659901 | (37.7458108948644, -122.467916186599) | |||
| 26973 | 26973 | 188567 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 500 24th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6016949.54535 | 2102644.83882 | 37.7544130748234 | -122.384299775913 | (37.7544130748234, -122.384299775913) | ||||
| 27415 | 27415 | 185199 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2500 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985167.8879 | 2097938.3372 | 37.739681755184705 | -122.49386054871201 | (37.7396817551847, -122.493860548712) | |||
| 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) | |||
| 27629 | 27629 | 123096 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 615 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 5992508.96289 | 2111250.82612 | 37.776661139698206 | -122.469447267036 | (37.7766611396982, -122.469447267036) | |||
| 27646 | 27646 | 123187 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 583 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 5993119.00687 | 2111524.26387 | 37.777447162121796 | -122.46735685145599 | (37.7774471621218, -122.467356851456) | |||
| 28388 | 28388 | 181560 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984861.3745 | 2106086.3243 | 37.7620359527601 | -122.49552112623002 | (37.7620359527601, -122.49552112623) | |||
| 28954 | 28954 | 186921 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985168.1725 | 2096748.5598 | 37.736414961632704 | -122.493771912003 | (37.7364149616327, -122.493771912003) | |||
| 29433 | 29433 | 186603 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 74 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984731.2077 | 2104430.2197 | 37.7574811288953 | -122.49584914444799 | (37.7574811288953, -122.495849144448) | |||
| 29694 | 29694 | 186789 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984864.8488 | 2106874.8662 | 37.7642012710686 | -122.495567273023 | (37.7642012710686, -122.495567273023) | |||
| 29742 | 29742 | 203269 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 61 Burnside Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6001195.67234 | 2095721.17604 | 37.7345186646045 | -122.438284639447 | (37.7345186646045, -122.438284639447) | ||||
| 29763 | 29763 | 186867 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985177.3409 | 2096363.4859 | 37.7353581877907 | -122.493711846576 | (37.7353581877907, -122.493711846576) | |||
| 30179 | 30179 | 184882 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 71 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984668.0467 | 2106784.9445 | 37.763942845201996 | -122.496241309763 | (37.763942845202, -122.496241309763) | |||
| 30490 | 30490 | 184072 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984928.5463 | 2103997.684 | 37.756305061112705 | -122.495134783659 | (37.7563050611127, -122.495134783659) | |||
| 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) | ||||
| 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) | ||||
| 31408 | 31408 | 203263 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 555 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5998982.59425 | 2097232.94199 | 37.7385434931839 | -122.44604465732999 | (37.7385434931839, -122.44604465733) | |||
| 31464 | 31464 | 123190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 575 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 9ft | 5993120.96689 | 2111576.90099 | 37.7775918025948 | -122.46735389958401 | (37.7775918025948, -122.467353899584) | |||
| 31867 | 31867 | 184860 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984687.0326 | 2106838.4849 | 37.7640909641996 | -122.496179594648 | (37.7640909641996, -122.496179594648) | |||
| 31937 | 31937 | 124973 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2815 Filbert St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5999464.00903 | 2118379.34034 | 37.796633661183 | -122.445900626411 | (37.796633661183, -122.445900626411) | |||
| 32216 | 32216 | 220257 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 600 Alvarado St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6002372.679819999 | 2102681.9405 | 37.7536981695386 | -122.434712926178 | (37.7536981695386, -122.434712926178) | |||
| 32317 | 32317 | 186821 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Sunset Blvd | 105 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984828.6477 | 2106722.4547 | 37.763780672010896 | -122.49568123753599 | (37.7637806720109, -122.495681237536) | |||
| 32442 | 32442 | 184851 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984650.5796 | 2106846.0793 | 37.7641096809697 | -122.496306233424 | (37.7641096809697, -122.496306233424) | |||
| 32524 | 32524 | 184847 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984668.0467 | 2106854.8129 | 37.764134684168404 | -122.49624646514401 | (37.7641346841684, -122.496246465144) | |||
| 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) | ||||
| 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) | |||
| 33671 | 33671 | 184350 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 0ft | 5984674.1222 | 2106470.7267 | 37.7630804473372 | -122.496197112117 | (37.7630804473372, -122.496197112117) | |||
| 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) | |||
| 34140 | 34140 | 106242 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Permit Number 770844 | 6012041.04445 | 2105749.16688 | 37.7626642466674 | -122.401492899679 | (37.7626642466674, -122.401492899679) | |||
| 34536 | 34536 | 185170 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2500 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985158.5914 | 2097729.8288 | 37.739108703159204 | -122.493877329625 | (37.7391087031592, -122.493877329625) | |||
| 35253 | 35253 | 186612 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 83 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984740.0009 | 2104413.4707 | 37.7574356557736 | -122.49581749901002 | (37.7574356557736, -122.49581749901) | |||
| 35284 | 35284 | 186795 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984860.9644 | 2106903.0931 | 37.764278546741295 | -122.49558278994301 | (37.7642785467413, -122.495582789943) | |||
| 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) | |||
| 35681 | 35681 | 184998 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985034.7824 | 2096514.6659 | 37.735764946565 | -122.494215856511 | (37.735764946565, -122.494215856511) | |||
| 35947 | 35947 | 184865 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984635.3908 | 2106835.0674 | 37.7640785556344 | -122.49635795369 | (37.7640785556344, -122.49635795369) | |||
| 36188 | 36188 | 201372 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 57 Hare St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6018490.42115 | 2095382.8253 | 37.734558123266204 | -122.378466804612 | (37.7345581232662, -122.378466804612) | ||||
| 36444 | 36444 | 203260 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 31 Sequoia Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5998240.18934 | 2097553.89046 | 37.7393823178446 | -122.448634634681 | (37.7393823178446, -122.448634634681) | |||
| 36642 | 36642 | 220139 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Vermont St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6011465.16522 | 2102024.89617 | 37.75240607489479 | -122.403222676406 | (37.7524060748948, -122.403222676406) | |||
| 36819 | 36819 | 220279 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Bemis St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6003936.6638400005 | 2097030.2765099998 | 37.738268675662 | -122.42890142078998 | (37.738268675662, -122.42890142079) | ||||
| 37409 | 37409 | 123163 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 515 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5992793.60446 | 2111925.06409 | 37.7785288602389 | -122.468511684261 | (37.7785288602389, -122.468511684261) | ||||
| 37450 | 37450 | 125128 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2545 Baker St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5999632.1533699995 | 2117620.57677 | 37.7945598973812 | -122.44526423016 | (37.7945598973812, -122.44526423016) | |||
| 38326 | 38326 | 184352 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Sunset Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984691.969 | 2106499.9651 | 37.7631617731469 | -122.496137544283 | (37.7631617731469, -122.496137544283) | |||
| 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) | |||
| 38719 | 38719 | 181561 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Sunset Blvd | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984871.9567 | 2106086.8812 | 37.7620381014978 | -122.49548456812 | (37.7620381014978, -122.49548456812) | |||
| 38739 | 38739 | 186794 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Sunset Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984862.0002 | 2106886.7785 | 37.7642338120894 | -122.495578004049 | (37.7642338120894, -122.495578004049) | |||
| 38748 | 38748 | 184777 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984706.0186 | 2105944.056 | 37.7616362256202 | -122.496047937787 | (37.7616362256202, -122.496047937787) | |||
| 38820 | 38820 | 186950 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985227.0199 | 2096064.0189 | 37.734538837365896 | -122.493518032223 | (37.7345388373659, -122.493518032223) | |||
| 39068 | 39068 | 203273 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 52 Burnside Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6001158.4895 | 2095751.0037900002 | 37.7345984497666 | -122.43841532891001 | (37.7345984497666, -122.43841532891) | ||||
| 39817 | 39817 | 186942 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985223.4885 | 2095964.6356 | 37.734265750670204 | -122.493522920975 | (37.7342657506702, -122.493522920975) | |||
| 40546 | 40546 | 185008 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Sunset Blvd | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985039.8071 | 2096490.3799 | 37.7356985577254 | -122.49419669494301 | (37.7356985577254, -122.494196694943) | |||
| 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) | |||
| 40974 | 40974 | 181393 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1500 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984912.5728 | 2104566.45 | 37.757865799574496 | -122.49523196663799 | (37.7578657995745, -122.495231966638) | |||
| 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) | |||
| 41157 | 41157 | 186953 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985200.1141 | 2096083.1893 | 37.73458990022429 | -122.49361246529 | (37.7345899002243, -122.49361246529) | |||
| 41246 | 41246 | 187776 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Lane St | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6017085.142530001 | 2097027.7274599997 | 37.7389971337102 | -122.383439839679 | (37.7389971337102, -122.383439839679) | |||
| 41402 | 41402 | 184854 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984632.7328 | 2106851.7751 | 37.764124274568 | -122.496368379685 | (37.764124274568, -122.496368379685) | |||
| 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) | |||
| 41724 | 41724 | 181562 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984861.0859 | 2106095.0617 | 37.7620599263149 | -122.495522768827 | (37.7620599263149, -122.495522768827) | |||
| 41974 | 41974 | 184884 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984688.9312 | 2106783.4256 | 37.7639398980625 | -122.49616896553101 | (37.7639398980625, -122.496168965531) | |||
| 42128 | 42128 | 186712 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984862.5222 | 2106113.9651 | 37.7621119138624 | -122.49551919557699 | (37.7621119138624, -122.495519195577) | |||
| 42429 | 42429 | 186912 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985181.9251 | 2096714.1782 | 37.736321363521796 | -122.493721831405 | (37.7363213635218, -122.493721831405) | |||
| 42463 | 42463 | 186945 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985218.4436 | 2095979.0975 | 37.7343051640866 | -122.49354142778799 | (37.7343051640866, -122.493541427788) | |||
| 42608 | 42608 | 184797 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984676.0208 | 2105815.7109 | 37.761282068862 | -122.496142217022 | (37.761282068862, -122.496142217022) | |||
| 42663 | 42663 | 184878 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 67 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984672.2236 | 2106800.5130000003 | 37.763985836593 | -122.496228012074 | (37.763985836593, -122.496228012074) | |||
| 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) | |||
| 43162 | 43162 | 123191 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 571 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 9ft | 5993121.2243 | 2111602.66813 | 37.777662567064205 | -122.467354883235 | (37.7776625670642, -122.467354883235) | |||
| 43663 | 43663 | 186949 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985222.3114 | 2096011.5526 | 37.7343945034212 | -122.49353044630399 | (37.7343945034212, -122.493530446304) | |||
| 43829 | 43829 | 186936 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5985232.9055 | 2095957.9092 | 37.7342478326321 | -122.49348986842199 | (37.7342478326321, -122.493489868422) | |||
| 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) | |||
| 44040 | 44040 | 185717 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984895.0862 | 2100394.2234 | 37.746408989169105 | -122.494984805259 | (37.7464089891691, -122.494984805259) | |||
| 44264 | 44264 | 186653 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1401 Sunset Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984685.2528 | 2105582.1287 | 37.76064125825761 | -122.49609305452199 | (37.7606412582576, -122.496093054522) | |||
| 44355 | 44355 | 184513 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5983187.3894 | 2101698.6547 | 37.7498904791156 | -122.50098618533801 | (37.7498904791156, -122.500986185338) | |||
| 44634 | 44634 | 186883 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985186.5093 | 2096482.6754 | 37.735685986771 | -122.493688928468 | (37.735685986771, -122.493688928468) | |||
| 44919 | 44919 | 203265 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 555 Teresita Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5998990.96313 | 2097286.0680400003 | 37.7386898425472 | -122.446019541966 | (37.7386898425472, -122.446019541966) | |||
| 44972 | 44972 | 185010 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 0ft | 5985035.2011 | 2096476.1433 | 37.735659198289 | -122.494211570428 | (37.735659198289, -122.494211570428) | |||
| 45936 | 45936 | 184776 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984696.9053 | 2105942.9168 | 37.7616325639121 | -122.49607937246901 | (37.7616325639121, -122.496079372469) | |||
| 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) | ||||
| 46510 | 46510 | 181396 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1500 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984914.2437 | 2104590.3992 | 37.757931655251 | -122.495227954147 | (37.757931655251, -122.495227954147) | |||
| 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) | |||
| 47210 | 47210 | 184881 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5984647.1621 | 2106788.3619999997 | 37.7639510053125 | -122.496313794444 | (37.7639510053125, -122.496313794444) | |||
| 47418 | 47418 | 125164 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2667 Vallejo St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 6000873.86204 | 2117537.36223 | 37.7944022120528 | -122.440961798859 | (37.7944022120528, -122.440961798859) | |||
| 48295 | 48295 | 184511 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983188.0663 | 2101701.7005 | 37.749898881781895 | -122.50098406985501 | (37.7498988817819, -122.500984069855) | |||
| 49203 | 49203 | 184512 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5983188.7431 | 2101700.3468 | 37.7498952046369 | -122.50098162938299 | (37.7498952046369, -122.500981629383) | |||
| 49403 | 49403 | 186616 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 87 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984717.3898 | 2104397.9779 | 37.75739179261161 | -122.495894553165 | (37.7573917926116, -122.495894553165) | |||
| 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) |
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");