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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189113 | 189113 | 123119 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 574 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 3ft | 5992561.79357 | 2111542.7313099997 | 37.7774656852602 | -122.469285763443 | (37.7774656852602, -122.469285763443) | |||
| 188967 | 188967 | 186602 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984723.2519 | 2104439.4316 | 37.7575059562709 | -122.495877337913 | (37.7575059562709, -122.495877337913) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 186257 | 186257 | 185005 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985036.876 | 2096499.1731 | 37.735722529984706 | -122.49420747665701 | (37.7357225299847, -122.494207476657) | |||
| 186018 | 186018 | 184852 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984650.5796 | 2106852.1548 | 37.7641263625826 | -122.49630668173201 | (37.7641263625826, -122.496306681732) | |||
| 185892 | 185892 | 187116 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2600 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985139.0056 | 2097294.5581 | 37.7379124205271 | -122.493912978366 | (37.7379124205271, -122.493912978366) | |||
| 185085 | 185085 | 186871 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985209.8888 | 2096365.7780000002 | 37.7353663853906 | -122.493599486872 | (37.7353663853906, -122.493599486872) | |||
| 185060 | 185060 | 184887 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 75 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984636.53 | 2106768.6166 | 37.763896167173705 | -122.496349110122 | (37.7638961671737, -122.496349110122) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 182873 | 182873 | 203282 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 710 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 6000203.28211 | 2096042.4957700002 | 37.735344439181105 | -122.44173870518499 | (37.7353444391811, -122.441738705185) | |||
| 182786 | 182786 | 186957 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5985219.2845 | 2096104.7140000002 | 37.734650122781 | -122.49354777321501 | (37.734650122781, -122.493547773215) | |||
| 182639 | 182639 | 187196 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2301 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984952.6117 | 2099047.6172 | 37.7427149412723 | -122.49468663060101 | (37.7427149412723, -122.494686630601) | |||
| 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) | |||
| 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) | ||||
| 182475 | 182475 | 203274 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 52 Burnside Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6001172.3349 | 2095747.08466 | 37.7345884762734 | -122.43836718012501 | (37.7345884762734, -122.438367180125) | ||||
| 182446 | 182446 | 123112 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 542 11th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5992554.51535 | 2111751.4814400002 | 37.778038435904605 | -122.46932613911999 | (37.7780384359046, -122.46932613912) | |||
| 182232 | 182232 | 203262 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 512 Rockdale Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5997988.38195 | 2097644.1119 | 37.7396156424485 | -122.449511768663 | (37.7396156424485, -122.449511768663) | |||
| 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) | |||
| 181959 | 181959 | 201376 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Fairfax Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 9ft | 6018269.69343 | 2095669.23069 | 37.7353323666994 | -122.379249829039 | (37.7353323666994, -122.379249829039) | |||
| 181825 | 181825 | 185012 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985038.9697 | 2096467.7688 | 37.7356364246768 | -122.494197924056 | (37.7356364246768, -122.494197924056) | |||
| 181079 | 181079 | 220260 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 429 Grand View Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6000142.26026 | 2102104.10765 | 37.7519847029517 | -122.442384714309 | (37.7519847029517, -122.442384714309) | ||||
| 180036 | 180036 | 123121 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 586 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5992562.41321 | 2111484.60446 | 37.7773061204935 | -122.469279388077 | (37.7773061204935, -122.469279388077) | |||
| 179837 | 179837 | 184835 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984633.1125 | 2106875.3177 | 37.764188938163 | -122.496368803682 | (37.764188938163, -122.496368803682) | |||
| 179804 | 179804 | 120391 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 735 24th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 5988455.47289 | 2110915.29878 | 37.775504786578004 | -122.483444705322 | (37.775504786578, -122.483444705322) | ||||
| 179664 | 179664 | 184874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984695.3865 | 2106820.2584 | 37.7640414086876 | -122.496149356564 | (37.7640414086876, -122.496149356564) | |||
| 179644 | 179644 | 184877 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984676.4005 | 2106805.4493 | 37.763999634952505 | -122.49621392986201 | (37.7639996349525, -122.496213929862) | |||
| 179583 | 179583 | 184846 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984679.0585 | 2106853.294 | 37.764131158732 | -122.496208267019 | (37.764131158732, -122.496208267019) | |||
| 178871 | 178871 | 184858 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984642.9852 | 2106842.6618 | 37.7640998526008 | -122.49633224767 | (37.7640998526008, -122.49633224767) | |||
| 178036 | 178036 | 186862 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985163.1298 | 2096349.2748 | 37.735318336491204 | -122.493759932025 | (37.7353183364912, -122.493759932025) | |||
| 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) | |||
| 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) | |||
| 177194 | 177194 | 184883 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984691.969 | 2106787.6025 | 37.763951544593795 | -122.49615876703399 | (37.7639515445938, -122.496158767034) | |||
| 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) | |||
| 176912 | 176912 | 186896 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985175.5072 | 2096596.8223 | 37.735998760061605 | -122.493735375196 | (37.7359987600616, -122.493735375196) | |||
| 176885 | 176885 | 184861 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984691.2095 | 2106834.308 | 37.7640797402699 | -122.496164839998 | (37.7640797402699, -122.496164839998) | |||
| 176241 | 176241 | 184888 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984676.0208 | 2106738.9985 | 37.7638171575071 | -122.496210339991 | (37.7638171575071, -122.496210339991) | |||
| 176074 | 176074 | 188579 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1900 18th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6011941.53621 | 2105635.92971 | 37.7623477698519 | -122.401829104925 | (37.7623477698519, -122.401829104925) | |||
| 175771 | 175771 | 181565 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984872.5636 | 2106101.5491 | 37.7620784109817 | -122.495483550979 | (37.7620784109817, -122.495483550979) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 175049 | 175049 | 185006 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Sunset Blvd | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985037.2948 | 2096494.1484 | 37.73570875800689 | -122.49420565848601 | (37.7357087580069, -122.494205658486) | |||
| 174713 | 174713 | 203261 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 506 Rockdale Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5997991.23111 | 2097614.06115 | 37.7395332933219 | -122.44949975281 | (37.7395332933219, -122.44949975281) | |||
| 174588 | 174588 | 184857 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984627.4167 | 2106843.4213 | 37.7641010259615 | -122.496386149808 | (37.7641010259615, -122.496386149808) | |||
| 174232 | 174232 | 184514 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5983188.0663 | 2101693.9168 | 37.749877509903 | -122.500983494265 | (37.749877509903, -122.500983494265) | |||
| 173624 | 173624 | 185188 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2500 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5985136.0139999995 | 2097861.9726 | 37.7394702135829 | -122.493965126981 | (37.7394702135829, -122.493965126981) | |||
| 173228 | 173228 | 123116 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 562 11th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 3ft | 5992559.20376 | 2111633.72876 | 37.777715389925 | -122.469301347393 | (37.777715389925, -122.469301347393) | |||
| 172966 | 172966 | 184838 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984655.5159 | 2106866.5842 | 37.764166270816396 | -122.496290673488 | (37.7641662708164, -122.496290673488) | |||
| 172909 | 172909 | 186609 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 80 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984732.0451 | 2104419.3328 | 37.7574512855375 | -122.49584544534599 | (37.7574512855375, -122.495845445346) | |||
| 172621 | 172621 | 221412 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 45 Harry St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6003250.45835 | 2097675.29375 | 37.7400008805364 | -122.431320009807 | (37.7400008805364, -122.431320009807) | |||
| 172587 | 172587 | 184870 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984657.0348 | 2106822.5367 | 37.7640454177531 | -122.496282169928 | (37.7640454177531, -122.496282169928) | |||
| 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) | |||
| 172559 | 172559 | 184836 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984671.8439 | 2106872.6597 | 37.7641839088875 | -122.496234648785 | (37.7641839088875, -122.496234648785) | |||
| 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) | |||
| 172313 | 172313 | 123161 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 511 10th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5992793.37077 | 2111978.9319599997 | 37.7786767533022 | -122.46851641299 | (37.7786767533022, -122.46851641299) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 169555 | 169555 | 125268 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2960 Van Ness Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 9ft | 6005626.14224 | 2120703.55494 | 37.8033652908254 | -122.42474367328 | (37.8033652908254, -122.42474367328) | |||
| 168902 | 168902 | 221410 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Digby St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6002579.4110199995 | 2097685.7042400003 | 37.739991412466296 | -122.433640955874 | (37.7399914124663, -122.433640955874) | |||
| 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) | ||||
| 168404 | 168404 | 184829 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984677.5396 | 2106895.0631 | 37.7642457559536 | -122.496216602354 | (37.7642457559536, -122.496216602354) | |||
| 168149 | 168149 | 124823 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 250 Cervantes Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6000834.31444 | 2121522.83872 | 37.805343021434496 | -122.441384750901 | (37.8053430214345, -122.441384750901) | |||
| 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) | |||
| 167529 | 167529 | 186873 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985190.6351 | 2096373.5712 | 37.7353866570824 | -122.493666627175 | (37.7353866570824, -122.493666627175) | |||
| 167469 | 167469 | 186611 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 82 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984721.5770000005 | 2104411.7958 | 37.7574299779546 | -122.49588109168998 | (37.7574299779546, -122.49588109169) | |||
| 167394 | 167394 | 186872 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985206.6799 | 2096372.1959 | 37.735383819513395 | -122.49361105382201 | (37.7353838195134, -122.493611053822) | |||
| 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) | |||
| 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) | ||||
| 166871 | 166871 | 203846 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 535 Castenada Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 2ft | 5992716.669840001 | 2100005.43095 | 37.7457962404004 | -122.46791062607402 | (37.7457962404004, -122.467910626074) | |||
| 166684 | 166684 | 125282 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1151 Lombard St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6006775.37415 | 2120099.5583599997 | 37.8017717101681 | -122.420723801756 | (37.8017717101681, -122.420723801756) | ||||
| 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) | ||||
| 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) | |||
| 165781 | 165781 | 186788 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984852.1597 | 2106871.2408 | 37.7641905736904 | -122.495610892905 | (37.7641905736904, -122.495610892905) | |||
| 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) | ||||
| 165223 | 165223 | 221409 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 Thor Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6002231.18225 | 2096094.9989099998 | 37.735603938579004 | -122.434731265154 | (37.735603938579, -122.434731265154) | |||
| 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) | |||
| 164531 | 164531 | 186916 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985173.6735 | 2096745.3508 | 37.736406472409705 | -122.49375265661101 | (37.7364064724097, -122.493752656611) | |||
| 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) | |||
| 163857 | 163857 | 184864 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984647.1621 | 2106835.0674 | 37.7640792451971 | -122.496317240818 | (37.7640792451971, -122.496317240818) | |||
| 163786 | 163786 | 220281 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Bemis St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6003914.80845 | 2097011.8099099998 | 37.738216733511294 | -122.428975669715 | (37.7382167335113, -122.428975669715) | ||||
| 163668 | 163668 | 186606 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984755.9124 | 2104439.8503 | 37.757509018663505 | -122.495764417358 | (37.7575090186635, -122.495764417358) | |||
| 163470 | 163470 | 203271 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 52 Burnside Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6001161.58855 | 2095756.5528 | 37.7346138623368 | -122.438405011902 | (37.7346138623368, -122.438405011902) | ||||
| 163207 | 163207 | 187775 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Lane St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6017053.32881 | 2096987.9359900001 | 37.7388861160087 | -122.383547068563 | (37.7388861160087, -122.383547068563) | |||
| 163176 | 163176 | 188599 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1099 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012848.11967 | 2102532.63168 | 37.753877345082 | -122.398475784828 | (37.753877345082, -122.398475784828) | ||||
| 162904 | 162904 | 186870 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985184.6756 | 2096368.5285 | 37.73537246252779 | -122.493686859622 | (37.7353724625278, -122.493686859622) | |||
| 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) | |||
| 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) | |||
| 161523 | 161523 | 184853 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984637.6691 | 2106845.6996 | 37.7641078821268 | -122.496350858396 | (37.7641078821268, -122.496350858396) | |||
| 160280 | 160280 | 221383 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 709 Duboce Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6002125.301940001 | 2108240.7744299998 | 37.768947330488 | -122.435966144022 | (37.768947330488, -122.435966144022) | |||
| 159840 | 159840 | 186613 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 84 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984762.1933 | 2104405.0962 | 37.7574139613926 | -122.49574013227699 | (37.7574139613926, -122.495740132277) | |||
| 159541 | 159541 | 184871 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5984661.2117 | 2106828.9919 | 37.7640633865909 | -122.496268199792 | (37.7640633865909, -122.496268199792) | |||
| 159306 | 159306 | 186956 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985210.8764 | 2096098.6602 | 37.7346330087924 | -122.493576396522 | (37.7346330087924, -122.493576396522) | |||
| 159053 | 159053 | 201374 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Hare St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 6018319.37911 | 2095383.7784900002 | 37.7345513108793 | -122.37905822666 | (37.7345513108793, -122.37905822666) |
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");