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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 108720 | 108720 | 120968 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 79x Bradford St | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 30 | 3x3 | 6009615.0 | 2098188.0 | 37.7417673011584 | -122.409350130422 | (37.7417673011584, -122.409350130422) | |||
| 78803 | 78803 | 105667 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 301X DORADO TER | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 5994306.4 | 2092922.0 | 37.726438562961896 | -122.461900058607 | (37.7264385629619, -122.461900058607) | |||||
| 85276 | 85276 | 105668 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 301X DORADO TER | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | 5994306.4 | 2092922.0 | 37.726438562961896 | -122.461900058607 | (37.7264385629619, -122.461900058607) | ||||
| 137668 | 137668 | 200250 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 917 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 6014641.601 | 2089467.7692 | 37.7181036570096 | -122.391360208379 | (37.7181036570096, -122.391360208379) | |||
| 29793 | 29793 | 247852 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Bradford St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6009577.25002 | 2098193.0016099997 | 37.741778919360705 | -122.409481010838 | (37.7417789193607, -122.409481010838) | ||||
| 30472 | 30472 | 247853 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Bradford St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6009574.28658 | 2098178.5899099996 | 37.7417391819242 | -122.40949024059401 | (37.7417391819242, -122.409490240594) | ||||
| 47085 | 47085 | 218783 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998795.47023 | 2095343.3571900001 | 37.7333444548841 | -122.44655572948099 | (37.7333444548841, -122.446555729481) | ||||
| 60526 | 60526 | 224443 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 198 Corbin Pl | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6000083.78895 | 2105729.05454 | 37.76193458623221 | -122.442847194237 | (37.7619345862322, -122.442847194237) | |||
| 70451 | 70451 | 176394 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 148 Milton St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6003833.54644 | 2094691.18415 | 37.731840220943205 | -122.42909121820801 | (37.7318402209432, -122.429091218208) | ||||
| 133301 | 133301 | 218784 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5998790.64503 | 2095351.5410200001 | 37.733366650131295 | -122.446573000066 | (37.7333666501313, -122.446573000066) | ||||
| 133793 | 133793 | 206299 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 231 Edna St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 5998763.35609 | 2095379.2875599999 | 37.733441276780205 | -122.446669340837 | (37.7334412767802, -122.446669340837) | ||||
| 134530 | 134530 | 218787 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 5998781.19291 | 2095377.439 | 37.733437219949 | -122.44660754120702 | (37.733437219949, -122.446607541207) | ||||
| 152132 | 152132 | 218786 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 5998782.33461 | 2095362.2846400002 | 37.733395674875005 | -122.44660250410101 | (37.733395674875, -122.446602504101) | ||||
| 165042 | 165042 | 218785 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5998782.76063 | 2095352.74135 | 37.733369495591795 | -122.446600344857 | (37.7333694955918, -122.446600344857) | ||||
| 181489 | 181489 | 247933 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1099 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6010316.772530001 | 2098765.05298 | 37.7433910575536 | -122.40696428417601 | (37.7433910575536, -122.406964284176) | ||||
| 118995 | 118995 | 97217 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300X Claremont Blvd | 4 | Back Yard : Cutout 16 | Tree 1 | DPW for City Agency 10 | 18 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | ||||
| 143072 | 143072 | 97216 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300X Claremont Blvd | 3 | Back Yard : Cutout 16 | Tree 1 | DPW for City Agency 10 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | |||||
| 82185 | 82185 | 111319 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200x PENINSULA AVE | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6012569.0 | 2087626.0 | 37.71293127807179 | -122.398395185538 | (37.7129312780718, -122.398395185538) | |||||
| 87976 | 87976 | 111318 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200x PENINSULA AVE | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6012569.0 | 2087626.0 | 37.71293127807179 | -122.398395185538 | (37.7129312780718, -122.398395185538) | |||||
| 104633 | 104633 | 99112 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80X Bradford St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6009564.7 | 2098208.3 | 37.741820222197596 | -122.40952548431801 | (37.7418202221976, -122.409525484318) | |||||
| 106969 | 106969 | 99110 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 94 Bernal Heights Blvd | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6009548.4 | 2098143.7 | 37.741641931317396 | -122.409577286243 | (37.7416419313174, -122.409577286243) | |||||
| 110332 | 110332 | 109200 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 7 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
| 122748 | 122748 | 111320 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200x PENINSULA AVE | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6012569.0 | 2087626.0 | 37.71293127807179 | -122.398395185538 | (37.7129312780718, -122.398395185538) | |||||
| 433 | 433 | 251301 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 2 | Back Yard : Yard 13 | Tree 1 | Mayor Office of Housing 7 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 474 | 474 | 251300 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 7023 | 7023 | 23544 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2800X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005656.2038 | 2120054.10262 | 37.80158375904121 | -122.424593418169 | (37.8015837590412, -122.424593418169) | |||
| 7523 | 7523 | 87408 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2400X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 6005843.02152 | 2118712.53051 | 37.7979106921903 | -122.42385149366501 | (37.7979106921903, -122.423851493665) | ||
| 7761 | 7761 | 23444 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2100X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 9 | 6005977.75981 | 2117720.35574 | 37.795194036322705 | -122.423314692816 | (37.7951940363227, -122.423314692816) | |||
| 8547 | 8547 | 23445 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2100X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005972.56611 | 2117769.9625 | 37.7953299508697 | -122.423336192004 | (37.7953299508697, -122.423336192004) | |||
| 10605 | 10605 | 1293 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 4000X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 10 | 5991961.87152 | 2087160.6390900002 | 37.7104840184951 | -122.46958569253701 | (37.7104840184951, -122.469585692537) | |||
| 12006 | 12006 | 1294 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 4000X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991953.08243 | 2087152.92109 | 37.7104623187479 | -122.469615507754 | (37.7104623187479, -122.469615507754) | |||
| 20112 | 20112 | 29963 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 500X Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3x3 | 5991394.8537099995 | 2093447.95886 | 37.7277146673841 | -122.47200336878099 | (37.7277146673841, -122.472003368781) | ||
| 25039 | 25039 | 199364 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300x Division St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 6ft | 6009993.3485 | 2108173.3882400002 | 37.7692061355694 | -122.408746211675 | (37.7692061355694, -122.408746211675) | |||
| 33628 | 33628 | 176389 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 700x Mansell St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 38 | Width 0ft | 6009439.980830001 | 2090047.93275 | 37.719406601704 | -122.40938096396499 | (37.719406601704, -122.409380963965) | |||
| 42536 | 42536 | 176390 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 700x Mansell St | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 0ft | 6009150.9462 | 2089957.5754799999 | 37.7191423008581 | -122.410373676998 | (37.7191423008581, -122.410373676998) | |||
| 54771 | 54771 | 176387 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6011480.82156 | 2090667.2216900003 | 37.7212211781905 | -122.402370013862 | (37.7212211781905, -122.402370013862) | |||
| 67100 | 67100 | 176388 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100x Mansell St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6011438.192840001 | 2090648.2271599998 | 37.7211666433202 | -122.40251603501001 | (37.7211666433202, -122.40251603501) | |||
| 70249 | 70249 | 176386 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 10x Mansell St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6011666.66331 | 2090722.9963200002 | 37.7213846965192 | -122.40173152668501 | (37.7213846965192, -122.401731526685) | |||
| 162071 | 162071 | 176385 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 10x Mansell St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6011675.69162 | 2090725.79104 | 37.7213928740681 | -122.401700514484 | (37.7213928740681, -122.401700514484) | |||
| 181793 | 181793 | 206291 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 500x Junipero Serra Blvd | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991445.95006 | 2094262.4550299998 | 37.7299540269465 | -122.471886066612 | (37.7299540269465, -122.471886066612) | |||
| 25829 | 25829 | 218789 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 380 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5999445.613919999 | 2094740.51345 | 37.7317263020196 | -122.44426470386101 | (37.7317263020196, -122.444264703861) | ||||
| 28031 | 28031 | 199363 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2001 25th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 8ft | 6012400.8175099995 | 2101833.78107 | 37.7519335243359 | -122.39997359673 | (37.7519335243359, -122.39997359673) | |||
| 28059 | 28059 | 206279 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 201 Elk St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 6000804.900880001 | 2095895.32742 | 37.7349746100829 | -122.439648143869 | (37.7349746100829, -122.439648143869) | |||
| 39572 | 39572 | 247122 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6002767.913930001 | 2098805.6060200003 | 37.743077097036796 | -122.433069184902 | (37.7430770970368, -122.433069184902) | ||||
| 40661 | 40661 | 199343 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1801 03rd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 4ft | 6015732.2545300005 | 2106672.58002 | 37.7654050079639 | -122.388790681754 | (37.7654050079639, -122.388790681754) | |||
| 44352 | 44352 | 206286 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199 Elk St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6000787.19541 | 2095992.57825 | 37.735240630441396 | -122.439716327743 | (37.7352406304414, -122.439716327743) | |||
| 49495 | 49495 | 224027 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1350 Noe St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6003197.19524 | 2100390.33495 | 37.7474527349542 | -122.431697967013 | (37.7474527349542, -122.431697967013) | ||||
| 50774 | 50774 | 199342 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1801 03rd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 4ft | 6015732.89393 | 2106644.75831 | 37.7653286510121 | -122.38878652777201 | (37.7653286510121, -122.388786527772) | |||
| 61215 | 61215 | 206288 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199 Elk St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 6000799.22427 | 2096049.60807 | 37.735397905697205 | -122.439678826929 | (37.7353979056972, -122.439678826929) | |||
| 64809 | 64809 | 206287 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199 Elk St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 6000792.43269 | 2096023.23658 | 37.7353251091687 | -122.439700417862 | (37.7353251091687, -122.439700417862) | |||
| 72139 | 72139 | 206285 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 201 Elk St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6000787.804140001 | 2095958.5254 | 37.7351471639001 | -122.43971178258002 | (37.7351471639001, -122.43971178258) | |||
| 132361 | 132361 | 206283 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 201 Elk St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 6000785.48714 | 2095941.8805200001 | 37.7351013290572 | -122.439718600327 | (37.7351013290572, -122.439718600327) | |||
| 149237 | 149237 | 206281 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 201 Elk St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 2ft | 6000794.7331 | 2095912.2311 | 37.735020444925205 | -122.439684508859 | (37.7350204449252, -122.439684508859) | |||
| 153651 | 153651 | 199341 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400 Mariposa St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 6ft | 6015776.44164 | 2106315.00515 | 37.764425633653296 | -122.388612884902 | (37.7644256336533, -122.388612884902) | |||
| 154600 | 154600 | 224031 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 822 Clayton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 4ft | 5998688.13035 | 2107403.24761 | 37.766451833222604 | -122.447794742535 | (37.7664518332226, -122.447794742535) | |||
| 176451 | 176451 | 199344 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1801 03rd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 4ft | 6015727.94816 | 2106771.64308 | 37.7656767749832 | -122.38881249299801 | (37.7656767749832, -122.388812492998) | |||
| 181459 | 181459 | 206298 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 74 Vista Verde Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 3ft | 5999168.51536 | 2096155.83752 | 37.735596635183605 | -122.445324411018 | (37.7355966351836, -122.445324411018) | |||
| 182494 | 182494 | 206282 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 201 Elk St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6000786.60453 | 2095932.3655299998 | 37.7350752667125 | -122.43971405517901 | (37.7350752667125, -122.439714055179) | |||
| 188255 | 188255 | 224438 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 177 Powhattan Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 6008219.66372 | 2098116.4731099997 | 37.7414926273921 | -122.414169698278 | (37.7414926273921, -122.414169698278) | |||
| 5622 | 5622 | 87285 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1820 Webster St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 50302 | 6003460.507999999 | 2115059.4384 | 37.7877454479518 | -122.43183468665801 | (37.7877454479518, -122.431834686658) | ||
| 100592 | 100592 | 116998 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 102078 | 102078 | 117000 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 124001 | 124001 | 99698 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1750 Divisadero St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6001124.0 | 2114376.0 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | |||||
| 124370 | 124370 | 116999 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 140716 | 140716 | 99699 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1750 Divisadero St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6001124.0 | 2114376.0 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | |||||
| 2071 | 2071 | 252870 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 716 McAllister St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | ||||
| 4693 | 4693 | 253655 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1048 Ingalls St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6018024.0 | 2094000.0 | 37.7307354351655 | -122.379983340658 | (37.7307354351655, -122.379983340658) | ||||
| 27571 | 27571 | 224007 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005150.44635 | 2097206.47879 | 37.7388211148085 | -122.42471728718 | (37.7388211148085, -122.42471728718) | ||||
| 29174 | 29174 | 224014 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 87 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005008.4122 | 2096950.18798 | 37.7381093751439 | -122.425190143511 | (37.7381093751439, -122.425190143511) | ||||
| 38019 | 38019 | 224020 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003561.5892199995 | 2095667.7300200001 | 37.7345061963941 | -122.430101069605 | (37.7345061963941, -122.430101069605) | ||||
| 39216 | 39216 | 224006 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6005147.55847 | 2097214.3851400004 | 37.738842660756795 | -122.42472783442601 | (37.7388426607568, -122.424727834426) | ||||
| 41851 | 41851 | 224024 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6003500.27869 | 2095632.3533400001 | 37.7344055874315 | -122.43031051723801 | (37.7344055874315, -122.430310517238) | ||||
| 52746 | 52746 | 224009 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6005155.305240001 | 2097189.65421 | 37.738775192731296 | -122.42469929085199 | (37.7387751927313, -122.424699290852) | ||||
| 56034 | 56034 | 247100 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6002747.30855 | 2098672.19693 | 37.7427096178655 | -122.433130902689 | (37.7427096178655, -122.433130902689) | ||||
| 56985 | 56985 | 224016 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 90 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6005001.85234 | 2096930.1779200002 | 37.7380540614461 | -122.425211400785 | (37.7380540614461, -122.425211400785) | ||||
| 57543 | 57543 | 224011 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 84 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6005029.023080001 | 2096988.2407799999 | 37.738215023894 | -122.42512158818701 | (37.738215023894, -122.425121588187) | ||||
| 58467 | 58467 | 199371 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1600 Davidson Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 6ft | 6014641.960109999 | 2099662.49642 | 37.7460963297753 | -122.39207151560801 | (37.7460963297753, -122.392071515608) | |||
| 58504 | 58504 | 247099 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6002747.27026 | 2098651.7988 | 37.742653607170894 | -122.433129577966 | (37.7426536071709, -122.433129577966) | ||||
| 66115 | 66115 | 199350 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 580 De Haro St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 5ft | 6012038.02992 | 2105655.7284 | 37.7624075172137 | -122.401496758684 | (37.7624075172137, -122.401496758684) | |||
| 70104 | 70104 | 247076 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401 Castro St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6002768.97997 | 2098508.28835 | 37.742260792292704 | -122.43304426108 | (37.7422607922927, -122.43304426108) | ||||
| 74211 | 74211 | 247098 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6002743.01525 | 2098640.44771 | 37.7426221983472 | -122.433143479687 | (37.7426221983472, -122.433143479687) | ||||
| 84093 | 84093 | 247077 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401 Castro St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6002764.89351 | 2098516.6039400003 | 37.7422833931736 | -122.433058984778 | (37.7422833931736, -122.433058984778) | ||||
| 96793 | 96793 | 224018 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6003591.19163 | 2095672.05268 | 37.734519741983 | -122.42999903253299 | (37.734519741983, -122.429999032533) | ||||
| 100565 | 100565 | 176384 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199 Peninsula Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6012519.05604 | 2087598.31836 | 37.712852487431796 | -122.398565868123 | (37.7128524874318, -122.398565868123) | ||||
| 128360 | 128360 | 106364 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 155 BORICA ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992696.0 | 2092292.5 | 37.724617268406604 | -122.467421338179 | (37.7246172684066, -122.467421338179) | |||||
| 131355 | 131355 | 247086 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6002759.04691 | 2098591.69247 | 37.7424892371899 | -122.43308456422501 | (37.7424892371899, -122.433084564225) | ||||
| 134377 | 134377 | 224017 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 91 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6004994.74234 | 2096924.0742900001 | 37.7380369005842 | -122.425235549407 | (37.7380369005842, -122.425235549407) | ||||
| 152279 | 152279 | 224022 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6003540.82213 | 2095652.97051 | 37.7344644939234 | -122.43017181569999 | (37.7344644939234, -122.4301718157) | ||||
| 153777 | 153777 | 224008 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6005152.83634 | 2097199.08838 | 37.7388009573938 | -122.42470849810499 | (37.7388009573938, -122.424708498105) | ||||
| 158262 | 158262 | 176380 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 229 Hester Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6012521.81555 | 2087619.26728 | 37.7129101627473 | -122.398557799413 | (37.7129101627473, -122.398557799413) | ||||
| 162867 | 162867 | 224012 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 85 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6005023.67021 | 2096975.18783 | 37.738178881048704 | -122.425139167258 | (37.7381788810487, -122.425139167258) | ||||
| 168669 | 168669 | 247078 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401 Castro St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6002758.90176 | 2098529.69857 | 37.7423190081102 | -122.433080637766 | (37.7423190081102, -122.433080637766) | ||||
| 169441 | 169441 | 224010 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6005156.6976 | 2097181.32171 | 37.738752392204205 | -122.424693884126 | (37.7387523922042, -122.424693884126) | ||||
| 169526 | 169526 | 247073 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401 Castro St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6002776.09275 | 2098476.71227 | 37.742174495166395 | -122.433017411837 | (37.7421744951664, -122.433017411837) | ||||
| 175253 | 175253 | 224019 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003580.635530001 | 2095660.4174400002 | 37.7344871964146 | -122.430034698739 | (37.7344871964146, -122.430034698739) | ||||
| 176279 | 176279 | 224023 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003511.08148 | 2095643.96545 | 37.734438083547104 | -122.430273996654 | (37.7344380835471, -122.430273996654) | ||||
| 178257 | 178257 | 247074 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401 Castro St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6002773.69931 | 2098494.22235 | 37.7422224380182 | -122.43302693833799 | (37.7422224380182, -122.433026938338) | ||||
| 178569 | 178569 | 176383 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199 Peninsula Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6012515.53938 | 2087594.1826400002 | 37.7128409356448 | -122.39857773288799 | (37.7128409356448, -122.398577732888) | ||||
| 180081 | 180081 | 224015 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 89 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6005001.605909999 | 2096940.71634 | 37.7380829836485 | -122.42521300248801 | (37.7380829836485, -122.425213002488) | ||||
| 181295 | 181295 | 247092 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6002754.09625 | 2098614.08678 | 37.742550445936395 | -122.43310328180901 | (37.7425504459364, -122.433103281809) |
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");