Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 143619 | 143619 | 78 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 97X Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002876.5924018 | 2107716.5314312 | 37.7675505386543 | -122.433330016252 | (37.7675505386543, -122.433330016252) | |||
| 58965 | 58965 | 331 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3402X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 50 | 2X3 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 78918 | 78918 | 332 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3402X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 80 | 2X3 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 119299 | 119299 | 353 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3590X 19th Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | |||
| 10725 | 10725 | 941 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1352 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 5x5 | 6002586.79672 | 2094029.0615 | 37.7299515286195 | -122.43335418993799 | (37.7299515286195, -122.433354189938) | |||
| 10466 | 10466 | 1196 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3080 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 28 | 3X3 | 5996438.01379 | 2087205.1874 | 37.7108640234246 | -122.45411848649799 | (37.7108640234246, -122.454118486498) | ||
| 13163 | 13163 | 1267 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5992203.06147 | 2087231.00688 | 37.710691168335096 | -122.468757212784 | (37.7106911683351, -122.468757212784) | |||
| 11884 | 11884 | 1270 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5992245.7583099995 | 2087252.3125599998 | 37.7107521351809 | -122.46861119345101 | (37.7107521351809, -122.468611193451) | |||
| 11364 | 11364 | 1271 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992356.50735 | 2087300.8185599998 | 37.7108917180496 | -122.468231949349 | (37.7108917180496, -122.468231949349) | |||
| 91843 | 91843 | 1272 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 13079 | 13079 | 1273 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | Permit Number 771193 | 5992398.03069 | 2087322.1494900002 | 37.710952685801104 | -122.46808998688499 | (37.7109526858011, -122.468089986885) | ||
| 12454 | 12454 | 1277 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992498.771269999 | 2087369.1133 | 37.7110874546035 | -122.46774522006099 | (37.7110874546035, -122.467745220061) | |||
| 123541 | 123541 | 1279 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10580 | 10580 | 1280 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5992520.10718 | 2087379.1823 | 37.71111633361279 | -122.467672210425 | (37.7111163336128, -122.467672210425) | |||
| 12581 | 12581 | 1281 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992683.69403 | 2087456.96265 | 37.7113393439098 | -122.46711247059099 | (37.7113393439098, -122.467112470591) | |||
| 188789 | 188789 | 1301 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 4000X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | 10 | 5991772.09471 | 2087046.42932 | 37.7101594558675 | -122.470233284447 | (37.7101594558675, -122.470233284447) | |||
| 120792 | 120792 | 1764 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2000X Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/1992 12:00:00 AM | 12 | 3X3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
| 10644 | 10644 | 1838 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2201X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6011226.77764 | 2087216.18178 | 37.71173113716571 | -122.403005565662 | (37.7117311371657, -122.403005565662) | |||
| 107109 | 107109 | 1851 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2401 Bay Shore Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/1991 12:00:00 AM | 12 | 3X3 | 6011063.3259362 | 2087019.7277799998 | 37.7111825850692 | -122.403556689346 | (37.7111825850692, -122.403556689346) | ||
| 115447 | 115447 | 1907 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 33 Beideman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001514.634986099 | 2112980.5998871997 | 37.7819269908671 | -122.438418027079 | (37.7819269908671, -122.438418027079) | |||
| 120947 | 120947 | 1911 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 51 Beideman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001506.865495 | 2113039.4741479 | 37.7820882026707 | -122.438449125298 | (37.7820882026707, -122.438449125298) | |||
| 21599 | 21599 | 1993 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 162 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6007301.508909999 | 2098085.20202 | 37.7413551489316 | -122.417342154839 | (37.7413551489316, -122.417342154839) | |||
| 104816 | 104816 | 1994 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 164 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6007305.0525987 | 2098100.7713839 | 37.7413980983192 | -122.41733100504601 | (37.7413980983192, -122.417331005046) | |||
| 19288 | 19288 | 1995 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 170 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6007282.5849 | 2098052.32823 | 37.7412638200836 | -122.41740525844801 | (37.7412638200836, -122.417405258448) | |||
| 9050 | 9050 | 1999 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 217 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 38 | 3X3 | 6007148.9837828 | 2097704.1672577998 | 37.7403003295941 | -122.417842531543 | (37.7403003295941, -122.417842531543) | |||
| 118812 | 118812 | 2018 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002398.10054 | 2095366.8333154998 | 37.733614037905205 | -122.43410212847401 | (37.7336140379052, -122.434102128474) | |||
| 139036 | 139036 | 2020 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002398.10054 | 2095366.8333154998 | 37.733614037905205 | -122.43410212847401 | (37.7336140379052, -122.434102128474) | |||
| 98184 | 98184 | 2021 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002398.10054 | 2095366.8333154998 | 37.733614037905205 | -122.43410212847401 | (37.7336140379052, -122.434102128474) | |||
| 93950 | 93950 | 2023 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Bosworth St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002398.10054 | 2095366.8333154998 | 37.733614037905205 | -122.43410212847401 | (37.7336140379052, -122.434102128474) | |||
| 101522 | 101522 | 2024 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Bosworth St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002398.10054 | 2095366.8333154998 | 37.733614037905205 | -122.43410212847401 | (37.7336140379052, -122.434102128474) | |||
| 142408 | 142408 | 2025 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Bosworth St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002398.10054 | 2095366.8333154998 | 37.733614037905205 | -122.43410212847401 | (37.7336140379052, -122.434102128474) | |||
| 86629 | 86629 | 2026 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Bosworth St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002398.10054 | 2095366.8333154998 | 37.733614037905205 | -122.43410212847401 | (37.7336140379052, -122.434102128474) | |||
| 103574 | 103574 | 2027 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Bosworth St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002398.10054 | 2095366.8333154998 | 37.733614037905205 | -122.43410212847401 | (37.7336140379052, -122.434102128474) | |||
| 47986 | 47986 | 2033 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002154.6210393 | 2095431.8532492002 | 37.733778746199796 | -122.43494855504801 | (37.7337787461998, -122.434948555048) | |||
| 122496 | 122496 | 2034 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002154.6210393 | 2095431.8532492002 | 37.733778746199796 | -122.43494855504801 | (37.7337787461998, -122.434948555048) | |||
| 122366 | 122366 | 2035 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002154.6210393 | 2095431.8532492002 | 37.733778746199796 | -122.43494855504801 | (37.7337787461998, -122.434948555048) | |||
| 107459 | 107459 | 2036 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002154.6210393 | 2095431.8532492002 | 37.733778746199796 | -122.43494855504801 | (37.7337787461998, -122.434948555048) | |||
| 92223 | 92223 | 2037 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002154.6210393 | 2095431.8532492002 | 37.733778746199796 | -122.43494855504801 | (37.7337787461998, -122.434948555048) | |||
| 79628 | 79628 | 2038 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Bosworth St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002154.6210393 | 2095431.8532492002 | 37.733778746199796 | -122.43494855504801 | (37.7337787461998, -122.434948555048) | |||
| 106446 | 106446 | 2039 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Bosworth St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002154.6210393 | 2095431.8532492002 | 37.733778746199796 | -122.43494855504801 | (37.7337787461998, -122.434948555048) | |||
| 80555 | 80555 | 2040 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Bosworth St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002154.6210393 | 2095431.8532492002 | 37.733778746199796 | -122.43494855504801 | (37.7337787461998, -122.434948555048) | |||
| 89175 | 89175 | 2042 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Bosworth St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002154.6210393 | 2095431.8532492002 | 37.733778746199796 | -122.43494855504801 | (37.7337787461998, -122.434948555048) | |||
| 20806 | 20806 | 2048 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/27/2000 12:00:00 AM | 3 | 3X3 | 6001958.681419999 | 2095417.21372 | 37.7337274221844 | -122.435624928664 | (37.7337274221844, -122.435624928664) | ||
| 18905 | 18905 | 2050 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001988.91143 | 2095411.22902 | 37.733712706561896 | -122.435519986756 | (37.7337127065619, -122.435519986756) | |||
| 20647 | 20647 | 2051 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Bosworth St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002019.51441 | 2095402.45002 | 37.733690339522205 | -122.435413555604 | (37.7336903395222, -122.435413555604) | |||
| 19664 | 19664 | 2052 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Bosworth St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002043.06025 | 2095397.14145 | 37.733677100614706 | -122.43533177123899 | (37.7336771006147, -122.435331771239) | |||
| 21498 | 21498 | 2053 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Bosworth St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/1992 12:00:00 AM | 12 | 3X3 | 6002061.47801 | 2095391.2920799998 | 37.7336620855229 | -122.43526767748001 | (37.7336620855229, -122.43526767748) | ||
| 19763 | 19763 | 2054 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Bosworth St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002076.85589 | 2095385.40046 | 37.7336467817625 | -122.435214090464 | (37.7336467817625, -122.435214090464) | |||
| 110384 | 110384 | 2057 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/1990 12:00:00 AM | 22 | 3X3 | 6001908.8431877 | 2095495.9697001998 | 37.7339408370986 | -122.43580286684099 | (37.7339408370986, -122.435802866841) | ||
| 79080 | 79080 | 2058 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Bosworth St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 06/08/1992 12:00:00 AM | 22 | 3X3 | 6001908.8431877 | 2095495.9697001998 | 37.7339408370986 | -122.43580286684099 | (37.7339408370986, -122.435802866841) | ||
| 125132 | 125132 | 2061 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Bosworth St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X3 | 6001908.8431877 | 2095495.9697001998 | 37.7339408370986 | -122.43580286684099 | (37.7339408370986, -122.435802866841) | |||
| 100546 | 100546 | 2062 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Bosworth St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 14 | 3X3 | 6001908.8431877 | 2095495.9697001998 | 37.7339408370986 | -122.43580286684099 | (37.7339408370986, -122.435802866841) | |||
| 120534 | 120534 | 2064 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Bosworth St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 14 | 3X3 | 6001908.8431877 | 2095495.9697001998 | 37.7339408370986 | -122.43580286684099 | (37.7339408370986, -122.435802866841) | |||
| 140195 | 140195 | 2065 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Bosworth St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001908.8431877 | 2095495.9697001998 | 37.7339408370986 | -122.43580286684099 | (37.7339408370986, -122.435802866841) | |||
| 96174 | 96174 | 2066 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Bosworth St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/1990 12:00:00 AM | 12 | 3X3 | 6001908.8431877 | 2095495.9697001998 | 37.7339408370986 | -122.43580286684099 | (37.7339408370986, -122.435802866841) | ||
| 19968 | 19968 | 2067 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 815 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6001798.14474 | 2095463.00063 | 37.7338440228646 | -122.436183226002 | (37.7338440228646, -122.436183226002) | |||
| 20917 | 20917 | 2068 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 825 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6001750.47291 | 2095477.80199 | 37.7338819553801 | -122.43634910053999 | (37.7338819553801, -122.43634910054) | |||
| 17365 | 17365 | 2069 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 843 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001701.031909999 | 2095490.9133099997 | 37.7339151466682 | -122.43652097087299 | (37.7339151466682, -122.436520970873) | |||
| 111836 | 111836 | 2071 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 20 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 122335 | 122335 | 2073 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/20/2000 12:00:00 AM | 34 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | ||
| 126542 | 126542 | 2074 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 21 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 120357 | 120357 | 2076 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 125479 | 125479 | 2077 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 124023 | 124023 | 2078 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 125618 | 125618 | 2079 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 85536 | 85536 | 2080 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 138810 | 138810 | 2081 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 907 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/1990 12:00:00 AM | 6 | 2X2 | 6001485.2451599995 | 2095489.86478 | 37.73390000314 | -122.437266934857 | (37.73390000314, -122.437266934857) | ||
| 104447 | 104447 | 2082 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 907 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6001485.2451599995 | 2095489.86478 | 37.73390000314 | -122.437266934857 | (37.73390000314, -122.437266934857) | |||
| 83071 | 83071 | 2083 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 907 Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6001485.2451599995 | 2095489.86478 | 37.73390000314 | -122.437266934857 | (37.73390000314, -122.437266934857) | |||
| 18857 | 18857 | 2085 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 921 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6001545.78168 | 2095530.67878 | 37.734015510104896 | -122.437060563206 | (37.7340155101049, -122.437060563206) | |||
| 118613 | 118613 | 2086 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 931 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1992 12:00:00 AM | 12 | 2X2 | 6001457.30881 | 2095546.90958 | 37.734055046836204 | -122.437367602498 | (37.7340550468362, -122.437367602498) | ||
| 122405 | 122405 | 2087 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 931 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6001485.2451599995 | 2095489.86478 | 37.73390000314 | -122.437266934857 | (37.73390000314, -122.437266934857) | |||
| 22111 | 22111 | 2089 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 943 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001413.27766 | 2095566.23245 | 37.7341055996942 | -122.43752121485399 | (37.7341055996942, -122.437521214854) | |||
| 21145 | 21145 | 2092 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 943 Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6001450.63808 | 2095555.96116 | 37.7340795211485 | -122.437391313181 | (37.7340795211485, -122.437391313181) | |||
| 138901 | 138901 | 2095 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 15 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 141161 | 141161 | 2097 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 146288 | 146288 | 2099 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 10 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 102520 | 102520 | 2100 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 127931 | 127931 | 2101 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 04/09/1990 12:00:00 AM | 14 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 121104 | 121104 | 2102 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 21923 | 21923 | 2107 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1019 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6001281.91782 | 2095601.18761 | 37.7341941091789 | -122.437977868977 | (37.7341941091789, -122.437977868977) | ||
| 19148 | 19148 | 2110 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1041 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/06/2005 12:00:00 AM | 3 | 3X3 | 6001168.361930001 | 2095632.80978 | 37.734274477972896 | -122.43837273163601 | (37.7342744779729, -122.438372731636) | ||
| 100446 | 100446 | 2113 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 109301 | 109301 | 2114 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 128760 | 128760 | 2115 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 128749 | 128749 | 2116 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 95857 | 95857 | 2117 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 82755 | 82755 | 2119 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 106968 | 106968 | 2121 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 06/01/2000 12:00:00 AM | 3 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 111789 | 111789 | 2122 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2000 12:00:00 AM | 14 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 125511 | 125511 | 2128 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 141483 | 141483 | 2129 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 103627 | 103627 | 2130 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 142290 | 142290 | 2131 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 125275 | 125275 | 2132 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 0 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 46604 | 46604 | 2135 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 24 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 124325 | 124325 | 2136 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 103736 | 103736 | 2138 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 140071 | 140071 | 2139 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 28 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 17750 | 17750 | 2151 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1107 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001039.9865 | 2095675.11992 | 37.734383349014394 | -122.43881959664101 | (37.7343833490144, -122.438819596641) |
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");