Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 111961 | 111961 | 1 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 10 10th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 16 | 5992719.40718 | 2114869.71245 | 37.7866097734767 | -122.46898271049601 | (37.7866097734767, -122.468982710496) | |||
| 9986 | 9986 | 1263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/1998 12:00:00 AM | 10 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |
| 88662 | 88662 | 2262 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 700X Brotherhood Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 14M | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |||
| 121438 | 121438 | 2276 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 750X Brotherhood Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 14M | 5991074.042616099 | 2088106.2478104 | 37.71302907778821 | -122.47272309171998 | (37.7130290777882, -122.47272309172) | |||
| 10721 | 10721 | 2286 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989102.32398 | 2088689.12288 | 37.714515172905294 | -122.4795805509 | (37.7145151729053, -122.4795805509) | |
| 10388 | 10388 | 2288 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989397.47374 | 2088680.9253 | 37.714509804868605 | -122.47855980688699 | (37.7145098048686, -122.478559806887) | |
| 12513 | 12513 | 2291 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 14M | 5989707.10535 | 2088681.30853 | 37.714528829127495 | -122.477489635265 | (37.7145288291275, -122.477489635265) | |||
| 11126 | 11126 | 2292 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5989842.77121 | 2088680.7511900002 | 37.7145351702246 | -122.477020683771 | (37.7145351702246, -122.477020683771) | |||
| 12984 | 12984 | 2293 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 14M | 5990043.7756199995 | 2088644.1713900003 | 37.71444639007029 | -122.476323268498 | (37.7144463900703, -122.476323268498) | |||
| 13213 | 13213 | 2294 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5990137.079530001 | 2088614.4864299998 | 37.714370293032204 | -122.475998609661 | (37.7143702930322, -122.475998609661) | |||
| 129091 | 129091 | 2295 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
| 127431 | 127431 | 2296 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
| 117781 | 117781 | 2299 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
| 100208 | 100208 | 2301 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
| 9890 | 9890 | 3755 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1050 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012450.5971046 | 2103074.0676917997 | 37.7553418567665 | -122.39988853682199 | (37.7553418567665, -122.399888536822) | |||
| 82797 | 82797 | 4965 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200X Diamond Heights Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
| 21647 | 21647 | 4966 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200X Diamond Heights Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | 12 | 6000791.48606 | 2099581.9209 | 37.745096364619705 | -122.439958774198 | (37.7450963646197, -122.439958774198) | |||
| 109168 | 109168 | 4969 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200X Diamond Heights Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
| 81314 | 81314 | 4970 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200X Diamond Heights Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
| 144487 | 144487 | 4971 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200X Diamond Heights Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
| 21840 | 21840 | 4972 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200X Diamond Heights Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 12 | 6000878.4738300005 | 2099482.1675 | 37.7448274169614 | -122.439650836444 | (37.7448274169614, -122.439650836444) | |||
| 19113 | 19113 | 4974 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200X Diamond Heights Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6000911.31432 | 2099444.9687099997 | 37.7447271470412 | -122.43953461434201 | (37.7447271470412, -122.439534614342) | |||
| 22163 | 22163 | 4978 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200X Diamond Heights Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 12 | 6001055.51411 | 2099325.5229599997 | 37.7444073831894 | -122.439027441656 | (37.7444073831894, -122.439027441656) | |||
| 44084 | 44084 | 4980 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200X Diamond Heights Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
| 120863 | 120863 | 4981 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200X Diamond Heights Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
| 3319 | 3319 | 4982 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/31/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780192 | 6001462.73007 | 2098944.10019 | 37.743383247851604 | -122.437592066128 | (37.7433832478516, -122.437592066128) | |
| 2268 | 2268 | 4983 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/10/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780192 | 6001475.6363 | 2098933.58975 | 37.7433551224547 | -122.43754668724199 | (37.7433551224547, -122.437546687242) | |
| 125765 | 125765 | 4984 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 118091 | 118091 | 4985 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 51522 | 51522 | 4986 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | ||||
| 138457 | 138457 | 4987 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 140668 | 140668 | 4988 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 102538 | 102538 | 4996 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | ||||
| 78019 | 78019 | 4997 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300X Diamond Heights Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | ||||
| 85419 | 85419 | 5000 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 140289 | 140289 | 5002 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 81362 | 81362 | 5003 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 95308 | 95308 | 5010 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 23115 | 23115 | 5045 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5399X Diamond Heights Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6002018.5391 | 2098420.87622 | 37.741978183035606 | -122.435632798636 | (37.7419781830356, -122.435632798636) | ||||
| 93006 | 93006 | 6387 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 40 Entrada Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60M | 5992282.41809 | 2092443.27672 | 37.725007378570105 | -122.468861992007 | (37.7250073785701, -122.468861992007) | |||
| 84722 | 84722 | 8291 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 95088 | 95088 | 8292 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 87594 | 87594 | 8293 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 117295 | 117295 | 8294 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 128632 | 128632 | 8295 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 110442 | 110442 | 9647 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 420X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5999128.38767 | 2111347.91542 | 37.77730804103229 | -122.446555809153 | (37.7773080410323, -122.446555809153) | |||
| 115010 | 115010 | 9648 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 420X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999128.38767 | 2111347.91542 | 37.77730804103229 | -122.446555809153 | (37.7773080410323, -122.446555809153) | |||
| 20371 | 20371 | 9649 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 420X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999128.38767 | 2111347.91542 | 37.77730804103229 | -122.446555809153 | (37.7773080410323, -122.446555809153) | |||
| 18375 | 18375 | 11190 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 140 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995683.115039401 | 2099368.7198886 | 37.7442188444672 | -122.457607088025 | (37.7442188444672, -122.457607088025) | |||
| 86588 | 86588 | 11195 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 180 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 5995389.3079719 | 2099438.2329619997 | 37.7443928282829 | -122.45862803372101 | (37.7443928282829, -122.458628033721) | |||
| 19374 | 19374 | 11663 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 700X Junipero Serra Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/03/2006 12:00:00 AM | 3 | 3X3 | 5991300.64199 | 2093008.2524599999 | 37.72650189113671 | -122.47229701721399 | (37.7265018911367, -122.472297017214) | ||
| 19444 | 19444 | 11669 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 700X Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991300.014719999 | 2092992.81009 | 37.7264594539326 | -122.472298060428 | (37.7264594539326, -122.472298060428) | ||
| 20549 | 20549 | 11671 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 700X Junipero Serra Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991299.29019 | 2092958.43644 | 37.726365030519794 | -122.472298060431 | (37.7263650305198, -122.472298060431) | ||
| 21883 | 21883 | 11674 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 700X Junipero Serra Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991293.10776 | 2092904.88683 | 37.726217638817204 | -122.47231553066099 | (37.7262176388172, -122.472315530661) | ||
| 106529 | 106529 | 11829 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1400X Junipero Serra Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 2X2 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 80325 | 80325 | 11833 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1400X Junipero Serra Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 2X2 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 109770 | 109770 | 11838 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1400X Junipero Serra Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 2X2 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 95647 | 95647 | 11842 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1400X Junipero Serra Blvd | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 2X2 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 108255 | 108255 | 11861 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1402X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 2X2 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.47166235770099 | (37.71376724375, -122.471662357701) | |||
| 121765 | 121765 | 11865 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1402X Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 2X2 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.47166235770099 | (37.71376724375, -122.471662357701) | |||
| 78763 | 78763 | 12819 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2160 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 14x5.5 | 5988722.6241 | 2114706.8097900003 | 37.78593075537871 | -122.48279849952401 | (37.7859307553787, -122.482798499524) | |||
| 19996 | 19996 | 12926 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1050 Lawton St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 5990949.62209 | 2104516.7462 | 37.7580809319175 | -122.47434990773199 | (37.7580809319175, -122.474349907732) | |||
| 80918 | 80918 | 12927 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1022 Lawton St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 5991076.4903594 | 2104558.9778183997 | 37.758204238053395 | -122.47391422833401 | (37.7582042380534, -122.473914228334) | |||
| 50095 | 50095 | 13416 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 442 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5 | 5999568.3476194 | 2097073.0677048 | 37.738137948158105 | -122.444007926391 | (37.7381379481581, -122.444007926391) | |||
| 17834 | 17834 | 16381 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1000 Moraga St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 12 | 5991038.119519999 | 2103837.44782 | 37.7562208847883 | -122.47399428791799 | (37.7562208847883, -122.473994287918) | |||
| 89998 | 89998 | 19457 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1700X Sloat Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 5985858.9484667 | 2095882.6709765 | 37.7340778499573 | -122.49131993236901 | (37.7340778499573, -122.491319932369) | |||
| 12711 | 12711 | 19749 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY15 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 13681 | 13681 | 19775 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY18 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 50ST | ||||||||
| 7092 | 7092 | 19853 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY29 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 4528 | 4528 | 19968 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY43 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 16297 | 16297 | 19969 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY43 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15 | ||||||||
| 7176 | 7176 | 19977 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY45 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 30ST | ||||||||
| 4260 | 4260 | 20045 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY52 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | ||||||||
| 15072 | 15072 | 20052 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY53 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 2700 | 2700 | 20053 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY53 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 13180 | 13180 | 20069 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY55 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 40ST | ||||||||
| 7096 | 7096 | 20070 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY55 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 14905 | 14905 | 20283 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 13202 | 13202 | 20284 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 14252 | 14252 | 20285 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 12855 | 12855 | 20286 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 13476 | 13476 | 20287 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 15347 | 15347 | 20288 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 7658 | 7658 | 20289 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 6219 | 6219 | 20290 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 437 | 437 | 20292 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 13426 | 13426 | 20293 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 7028 | 7028 | 20295 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | ||||||||
| 11130 | 11130 | 20306 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 16063 | 16063 | 20307 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 6407 | 6407 | 20308 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 5456 | 5456 | 20311 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 13388 | 13388 | 20313 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 10567 | 10567 | 20323 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 8078 | 8078 | 20329 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 14683 | 14683 | 20337 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 13746 | 13746 | 20338 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 15202 | 15202 | 20339 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 13748 | 13748 | 20343 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 5282 | 5282 | 20344 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 40 |
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");