Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
810 | 810 | 212202 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 800 Bosworth St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6001677.26505 | 2095571.4535400001 | 37.734134940976 | -122.43660890297501 | (37.734134940976, -122.436608902975) | ||||
3494 | 3494 | 106527 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5999890.2062099995 | 2116153.78918 | 37.7905472114236 | -122.444265881958 | (37.7905472114236, -122.444265881958) | ||||
4330 | 4330 | 70503 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 193 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 7 | 6004252.47977 | 2092436.6780400001 | 37.725673555265395 | -122.42748232385901 | (37.7256735552654, -122.427482323859) | ||
15745 | 15745 | 106168 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1052 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6012164.747830001 | 2103476.70855 | 37.7564314799541 | -122.400905383382 | (37.7564314799541, -122.400905383382) | ||||
19247 | 19247 | 106705 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 199X BRIGHTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 5996224.0 | 2090880.0 | 37.7209419254054 | -122.455123542447 | (37.7209419254054, -122.455123542447) | ||||
23909 | 23909 | 249678 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2400 Baker St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5999727.06015 | 2117202.6736 | 37.7934178626924 | -122.444905786498 | (37.7934178626924, -122.444905786498) | ||||
26476 | 26476 | 212215 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1120 Bosworth St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6001146.22542 | 2095720.4454400002 | 37.73451384602821 | -122.438455541186 | (37.7345138460282, -122.438455541186) | ||||
28874 | 28874 | 218292 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Woodacre Dr | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 5991223.38049 | 2095418.74528 | 37.73311602796429 | -122.472739784911 | (37.7331160279643, -122.472739784911) | ||||
29344 | 29344 | 212243 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 160 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5998464.243 | 2093227.24787 | 37.7275151923546 | -122.447548599 | (37.7275151923546, -122.447548599) | ||||
30306 | 30306 | 248645 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 Church St | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6004348.66213 | 2104681.30747 | 37.7592999422487 | -122.428022000737 | (37.7592999422487, -122.428022000737) | ||||
33121 | 33121 | 212178 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 610 Bosworth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6002338.16376 | 2095402.39755 | 37.7337082872919 | -122.434311888799 | (37.7337082872919, -122.434311888799) | ||||
34298 | 34298 | 102410 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 55X Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000310.8 | 2109142.0 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | |||||
36645 | 36645 | 248794 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 5175 Diamond Heights Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6000769.8942 | 2099922.22188 | 37.7460295209503 | -122.440057831812 | (37.7460295209503, -122.440057831812) | ||||
36736 | 36736 | 205507 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1518 05th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | 5994641.653519999 | 2105137.30281 | 37.7599980266194 | -122.46162636506 | (37.7599980266194, -122.46162636506) | ||||
37614 | 37614 | 212222 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1120 Bosworth St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6000900.61271 | 2095850.79313 | 37.734857776454504 | -122.43931404390699 | (37.7348577764545, -122.439314043907) | ||||
38217 | 38217 | 176045 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990157.58815 | 2089581.85402 | 37.7170276349961 | -122.475998332672 | (37.7170276349961, -122.475998332672) | ||||
38559 | 38559 | 248795 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 5175 Diamond Heights Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6000777.48804 | 2099988.6184 | 37.746212262280395 | -122.440036333505 | (37.7462122622804, -122.440036333505) | ||||
38653 | 38653 | 176017 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6009623.1629099995 | 2089154.9429900001 | 37.7169648982982 | -122.408684805076 | (37.7169648982982, -122.408684805076) | ||||
39680 | 39680 | 212217 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1120 Bosworth St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6001121.36826 | 2095728.58105 | 37.734534770568 | -122.438542063178 | (37.734534770568, -122.438542063178) | ||||
40567 | 40567 | 176049 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989054.79394 | 2089564.29309 | 37.716915411303 | -122.479808833919 | (37.716915411303, -122.479808833919) | ||||
40789 | 40789 | 176052 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5989234.209980001 | 2089407.1197400002 | 37.716494274064495 | -122.47917719598 | (37.7164942740645, -122.47917719598) | ||||
43758 | 43758 | 212210 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6001335.34031 | 2095664.21523 | 37.734370206320705 | -122.437797683519 | (37.7343702063207, -122.437797683519) | ||||
44314 | 44314 | 126179 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 Marina Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6003111.16889 | 2121419.1431 | 37.8051877435806 | -122.43349799333201 | (37.8051877435806, -122.433497993332) | ||||
47032 | 47032 | 212197 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 820 Bosworth St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6001769.124890001 | 2095547.7255799999 | 37.7340750092381 | -122.436289617596 | (37.7340750092381, -122.436289617596) | ||||
47368 | 47368 | 248653 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1001 San Jose Ave | 48 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6005296.42687 | 2097177.8941099998 | 37.738750871460205 | -122.424210521903 | (37.7387508714602, -122.424210521903) | ||||
47950 | 47950 | 176025 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6009634.04356 | 2089276.3567700002 | 37.7172988849001 | -122.408655756084 | (37.7172988849001, -122.408655756084) | ||||
49572 | 49572 | 189393 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 24th St | 15 | : Yard 23 | Tree 1 | Private 1 | 10 | 6017282.75412 | 2102644.41979 | 37.7544303427117 | -122.38314741343201 | (37.7544303427117, -122.383147413432) | ||||
49696 | 49696 | 248657 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 111 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6005025.16759 | 2096929.69692 | 37.7380540578596 | -122.425130754104 | (37.7380540578596, -122.425130754104) | ||||
51327 | 51327 | 97306 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 47 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997949.8 | 2111441.7 | 37.777498158560796 | -122.450639669067 | (37.7774981585608, -122.450639669067) | |||||
52559 | 52559 | 212209 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001437.10561 | 2095636.3706200002 | 37.7342995375914 | -122.437443855175 | (37.7342995375914, -122.437443855175) | ||||
52706 | 52706 | 212226 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1120 Bosworth St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6000822.65215 | 2095879.57602 | 37.734932370740296 | -122.439585642776 | (37.7349323707403, -122.439585642776) | ||||
52835 | 52835 | 75161 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/25/1989 12:00:00 AM | 15 | 6005585.43876 | 2119632.07302 | 37.80042097699361 | -122.42480825631 | (37.8004209769936, -122.42480825631) | ||
54175 | 54175 | 248651 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1201 San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6004132.59499 | 2095830.66152 | 37.7349858929719 | -122.42813852050301 | (37.7349858929719, -122.428138520503) | ||||
54470 | 54470 | 248222 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 70 Fair Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6007138.69589 | 2099332.0409999997 | 37.7447695284905 | -122.41799347441601 | (37.7447695284905, -122.417993474416) | ||||
54591 | 54591 | 248654 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 81 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005089.97805 | 2097022.6793 | 37.7383130275105 | -122.42491328541901 | (37.7383130275105, -122.424913285419) | ||||
55194 | 55194 | 248652 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1001 San Jose Ave | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005286.42848 | 2097142.8356 | 37.7386540441353 | -122.42424259893801 | (37.7386540441353, -122.424242598938) | ||||
55378 | 55378 | 176054 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 5989245.31981 | 2089315.2477799999 | 37.7162426617475 | -122.47913207879101 | (37.7162426617475, -122.479132078791) | ||||
58398 | 58398 | 218290 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Woodacre Dr | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | 5991251.16534 | 2095467.63693 | 37.733251880466 | -122.472647289653 | (37.733251880466, -122.472647289653) | ||||
58549 | 58549 | 212240 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 298 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5998225.68329 | 2093821.9579599998 | 37.7291344900407 | -122.448416107518 | (37.7291344900407, -122.448416107518) | ||||
58976 | 58976 | 212182 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 620 Bosworth St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6002250.2087 | 2095427.67097 | 37.7337726895439 | -122.43461778151001 | (37.7337726895439, -122.43461778151) | ||||
59466 | 59466 | 212242 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 298 Staples Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5998209.43788 | 2093823.68596 | 37.729138305887496 | -122.44847239338002 | (37.7291383058875, -122.44847239338) | ||||
61517 | 61517 | 201542 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 Innes Ave | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 6020585.50312 | 2093400.1960900002 | 37.7292294638519 | -122.37108624845699 | (37.7292294638519, -122.371086248457) | ||||
62427 | 62427 | 176057 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989281.98257 | 2089351.5172299999 | 37.7163443777799 | -122.479008007435 | (37.7163443777799, -122.479008007435) | ||||
62845 | 62845 | 176023 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6009654.67743 | 2089334.9097900002 | 37.71746081504929 | -122.40858856232 | (37.7174608150493, -122.40858856232) | ||||
65336 | 65336 | 176043 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5989267.954919999 | 2090414.23117 | 37.7192615104927 | -122.47913418591499 | (37.7192615104927, -122.479134185915) | ||||
65725 | 65725 | 99970 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2270 Folsom St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||||
69208 | 69208 | 176048 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989010.93647 | 2089619.81285 | 37.7170653066825 | -122.479964486788 | (37.7170653066825, -122.479964486788) | ||||
71511 | 71511 | 104957 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 759 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
73344 | 73344 | 176058 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Crespi Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 5989854.78687 | 2090110.33741 | 37.7184611570226 | -122.47708355628599 | (37.7184611570226, -122.477083556286) | ||||
74105 | 74105 | 176021 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6009620.695040001 | 2089243.5370200002 | 37.7172080210075 | -122.40869958183701 | (37.7172080210075, -122.408699581837) | ||||
74942 | 74942 | 189463 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Newhall St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 22 | 6014124.78069 | 2095373.74732 | 37.7342915875929 | -122.393559763171 | (37.7342915875929, -122.393559763171) | ||||
78017 | 78017 | 99966 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2270 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||||
80267 | 80267 | 107218 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 WINSTON DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 42 | 5990934.3 | 2093194.2 | 37.7269912477326 | -122.47357699184799 | (37.7269912477326, -122.473576991848) | ||||
80750 | 80750 | 99968 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2270 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||||
80769 | 80769 | 107162 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 798X 07TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993812.0 | 2110401.0 | 37.7744029620428 | -122.464877983618 | (37.7744029620428, -122.464877983618) | |||||
85205 | 85205 | 104946 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 532 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
86917 | 86917 | 104944 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 532 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
88948 | 88948 | 104951 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
89582 | 89582 | 99611 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Entrada Ct | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992743.0 | 2092489.0 | 37.7251595224946 | -122.46727314778099 | (37.7251595224946, -122.467273147781) | |||||
89864 | 89864 | 106457 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1x CHESTNUT ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011546.0 | 2121132.0 | 37.8048742648975 | -122.40428784546499 | (37.8048742648975, -122.404287845465) | |||||
90092 | 90092 | 93735 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 201@ Page Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 2 on Page St. | 5999812.1 | 2109210.9 | 37.771479369328205 | -122.44403704657 | (37.7714793693282, -122.44403704657) | ||||
90415 | 90415 | 104958 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 759 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
90873 | 90873 | 102411 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 55X Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000310.8 | 2109142.0 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | |||||
92625 | 92625 | 105890 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999444.5 | 2109060.1 | 37.771044333973705 | -122.445297745357 | (37.7710443339737, -122.445297745357) | |||||
94825 | 94825 | 104959 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 759 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
95555 | 95555 | 104945 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 532 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
98987 | 98987 | 104915 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
102839 | 102839 | 102414 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1301 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6000345.0 | 2109213.0 | 37.77151552050871 | -122.44219387377399 | (37.7715155205087, -122.442193873774) | |||||
104933 | 104933 | 73957 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3100X 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1988 12:00:00 AM | 12 | 6008781.55607863 | 2105099.68545767 | 37.7606985097306 | -122.41272042520201 | (37.7606985097306, -122.412720425202) | |||
105850 | 105850 | 104948 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 535 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
107064 | 107064 | 99971 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2270 Folsom St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||||
109040 | 109040 | 106904 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 20X MAYFAIR DR | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 5997868.0 | 2114773.0 | 37.7866403525015 | -122.45116294110301 | (37.7866403525015, -122.451162941103) | ||||
109129 | 109129 | 106906 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 20X MAYFAIR DR | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5997868.0 | 2114773.0 | 37.7866403525015 | -122.45116294110301 | (37.7866403525015, -122.451162941103) | ||||
109251 | 109251 | 104950 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
112803 | 112803 | 104952 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
115186 | 115186 | 107220 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 WINSTON DR | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5990934.3 | 2093194.2 | 37.7269912477326 | -122.47357699184799 | (37.7269912477326, -122.473576991848) | |||||
119583 | 119583 | 107051 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998625.9783 | 2115075.11894 | 37.7875132600186 | -122.44856229739901 | (37.7875132600186, -122.448562297399) | |||||
122291 | 122291 | 104956 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 759 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
123672 | 123672 | 105892 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999444.5 | 2109060.1 | 37.771044333973705 | -122.445297745357 | (37.7710443339737, -122.445297745357) | |||||
126166 | 126166 | 247920 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1098 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6010252.902419999 | 2098733.4037 | 37.743300581252605 | -122.40718290126301 | (37.7433005812526, -122.407182901263) | ||||
128915 | 128915 | 99987 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 535@Clay Washington St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012018.0 | 2117734.0 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | |||||
129617 | 129617 | 212219 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1120 Bosworth St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6001099.22416 | 2095737.89591 | 37.7345590873286 | -122.43861928975299 | (37.7345590873286, -122.438619289753) | ||||
130570 | 130570 | 212199 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 820 Bosworth St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6001716.86925 | 2095561.16435 | 37.73410893977589 | -122.43647124285299 | (37.7341089397759, -122.436471242853) | ||||
134977 | 134977 | 189464 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Newhall St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6014119.82993 | 2095366.8489 | 37.7342723708559 | -122.39357639702699 | (37.7342723708559, -122.393576397027) | ||||
139359 | 139359 | 106907 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 20X MAYFAIR DR | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998146.0 | 2114573.0 | 37.7861071180483 | -122.450186711437 | (37.7861071180483, -122.450186711437) | |||||
141341 | 141341 | 106905 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 20X MAYFAIR DR | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5997868.0 | 2114773.0 | 37.7866403525015 | -122.45116294110301 | (37.7866403525015, -122.451162941103) | ||||
142855 | 142855 | 100463 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 197 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000813.5 | 2094900.3 | 37.732242985333 | -122.43954710648501 | (37.732242985333, -122.439547106485) | |||||
143898 | 143898 | 105893 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999444.5 | 2109060.1 | 37.771044333973705 | -122.445297745357 | (37.7710443339737, -122.445297745357) | |||||
144026 | 144026 | 104949 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 535 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
146250 | 146250 | 104914 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 614 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
147650 | 147650 | 189462 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Newhall St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 6014132.345380001 | 2095385.42746 | 37.7343240791916 | -122.393534426582 | (37.7343240791916, -122.393534426582) | ||||
147988 | 147988 | 189418 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1751 22nd St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6012789.58945 | 2103762.8095299997 | 37.757251884682205 | -122.39876452478701 | (37.7572518846822, -122.398764524787) | ||||
150323 | 150323 | 217785 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 124 Sloat Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 5991003.2864 | 2096055.6883900003 | 37.7348521691816 | -122.473547145886 | (37.7348521691816, -122.473547145886) | ||||
151782 | 151782 | 218282 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Woodacre Dr | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5991361.16684 | 2095634.8342900001 | 37.7337173290882 | -122.47227917194901 | (37.7337173290882, -122.472279171949) | ||||
151963 | 151963 | 248793 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 5175 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6000762.917 | 2099848.0736700003 | 37.7458255304211 | -122.440076642017 | (37.7458255304211, -122.440076642017) | ||||
153594 | 153594 | 218291 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Woodacre Dr | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5991233.57986 | 2095433.30624 | 37.7331565991011 | -122.472705584612 | (37.7331565991011, -122.472705584612) | ||||
153599 | 153599 | 176040 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 5989182.3515099995 | 2090508.47222 | 37.719515300969206 | -122.479436972335 | (37.7195153009692, -122.479436972335) | ||||
154485 | 154485 | 176056 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 5989277.7182599995 | 2089365.90518 | 37.7163836358725 | -122.47902379861401 | (37.7163836358725, -122.479023798614) | ||||
155641 | 155641 | 176020 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6009615.5207400005 | 2089232.9452 | 37.7171786482456 | -122.408716720218 | (37.7171786482456, -122.408716720218) | ||||
156791 | 156791 | 248646 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 Church St | 45 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6004337.8277 | 2104713.595 | 37.759387983176 | -122.42806177235501 | (37.759387983176, -122.428061772355) |
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");