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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 492 | 492 | 173939 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 570 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2017 12:00:00 AM | 3 | 5xt | Permit Number 779890 | 6014341.0 | 2104455.0 | 37.7592388085315 | -122.39344754111201 | (37.7592388085315, -122.393447541112) | |
| 662 | 662 | 206411 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 241 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | Permit Number 779935 | 5993240.35303 | 2102520.36003 | 37.752731819221 | -122.466282559112 | (37.752731819221, -122.466282559112) | ||
| 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) | ||||
| 900 | 900 | 140947 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 902 | 902 | 140944 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 904 | 904 | 140946 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 907 | 907 | 140952 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 915 | 915 | 140945 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 922 | 922 | 140943 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 925 | 925 | 139814 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1652 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6002517.0 | 2112708.0 | 37.7812354643217 | -122.434930809638 | (37.7812354643217, -122.434930809638) | |||
| 927 | 927 | 140951 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 929 | 929 | 140950 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 1077 | 1077 | 98926 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3541 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x4 | 5997927.34517 | 2115124.9687799998 | 37.7876101632223 | -122.450983011859 | (37.7876101632223, -122.450983011859) | |||
| 1438 | 1438 | 251533 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1201X Pierce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6002292.0 | 2112799.0 | 37.7814725496882 | -122.43571571002899 | (37.7814725496882, -122.435715710029) | ||||
| 1543 | 1543 | 141557 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 524 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6000673.0 | 2110815.0 | 37.7759328964671 | -122.44117426506 | (37.7759328964671, -122.44117426506) | |||
| 2611 | 2611 | 248770 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 8ft | 5999726.1375 | 2101744.56242 | 37.7509737525388 | -122.44379789365499 | (37.7509737525388, -122.443797893655) | |||
| 2614 | 2614 | 248773 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5999776.82694 | 2101824.96428 | 37.751197407653706 | -122.44362838043999 | (37.7511974076537, -122.44362838044) | |||
| 2625 | 2625 | 248771 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 8ft | 5999742.36883 | 2101773.9828 | 37.751055459558394 | -122.4437438777 | (37.7510554595584, -122.4437438777) | |||
| 2626 | 2626 | 248769 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 8ft | 5999705.100819999 | 2101709.8291 | 37.7508771833507 | -122.443868145114 | (37.7508771833507, -122.443868145114) | |||
| 2628 | 2628 | 248767 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5999684.377780001 | 2101641.28638 | 37.750687799606105 | -122.443934882898 | (37.7506877996061, -122.443934882898) | |||
| 2629 | 2629 | 248772 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 8ft | 5999759.8487 | 2101799.49731 | 37.7511265131926 | -122.443685263491 | (37.7511265131926, -122.443685263491) | |||
| 2632 | 2632 | 248768 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999691.3486 | 2101670.41928 | 37.7507681891085 | -122.44391287020399 | (37.7507681891085, -122.443912870204) | |||
| 2693 | 2693 | 98923 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3527 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5997962.31773 | 2115134.58282 | 37.7876385629149 | -122.450862707746 | (37.7876385629149, -122.450862707746) | |||
| 3053 | 3053 | 126134 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2829 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | Permit Number 779774 | 6000559.90395 | 2118036.87537 | 37.7957558571972 | -122.44208400078101 | (37.7957558571972, -122.442084000781) | ||
| 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) | ||
| 5253 | 5253 | 222095 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 116 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 39 | 12x9 | 6004345.11847 | 2101047.98994 | 37.7493235046981 | -122.427775375138 | (37.7493235046981, -122.427775375138) | |||
| 5977 | 5977 | 98925 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3541 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | 5997905.152000001 | 2115121.83421 | 37.7876002859601 | -122.45105956936399 | (37.7876002859601, -122.451059569364) | |||
| 6446 | 6446 | 107232 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2265 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6006749.11596 | 2119031.04722 | 37.7988363688534 | -122.420738768293 | (37.7988363688534, -122.420738768293) | |||
| 7319 | 7319 | 98048 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2251 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003429.10066 | 2116873.98532 | 37.7927259513035 | -122.432072977999 | (37.7927259513035, -122.432072977999) | |||
| 7803 | 7803 | 98047 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2251 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003407.78151 | 2116869.84399 | 37.7927133715759 | -122.43214644721901 | (37.7927133715759, -122.432146447219) | |||
| 7920 | 7920 | 98924 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3527 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5997977.38318 | 2115131.5705 | 37.7876311543002 | -122.45081036719999 | (37.7876311543002, -122.4508103672) | |||
| 8791 | 8791 | 117119 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 447 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 5x9 | Permit Number 778563 | 5997182.09338 | 2114812.8648 | 37.78671051561479 | -122.45353887881001 | (37.7867105156148, -122.45353887881) | |
| 9022 | 9022 | 105217 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5999896.62594 | 2116125.07257 | 37.7904687293982 | -122.44424160568998 | (37.7904687293982, -122.44424160569) | |||
| 9497 | 9497 | 122159 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 547 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 4ft | 5991246.192840001 | 2111684.05416 | 37.7777776077222 | -122.473847129053 | (37.7777776077222, -122.473847129053) | |||
| 9558 | 9558 | 122158 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 515 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 6ft | 5991239.57046 | 2111867.63351 | 37.7782812827035 | -122.47388343446801 | (37.7782812827035, -122.473883434468) | |||
| 9609 | 9609 | 97058 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 506 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 5991284.01792 | 2111924.69862 | 37.7784405421859 | -122.473733839825 | (37.7784405421859, -122.473733839825) | |||
| 9864 | 9864 | 173715 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 4143 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 6002772.0 | 2104111.0 | 37.7576446879549 | -122.43343410325701 | (37.7576446879549, -122.433434103257) | ||||
| 10109 | 10109 | 114554 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1200x 43RD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5982778.0 | 2106905.0 | 37.764161588502795 | -122.50278719613199 | (37.7641615885028, -122.502787196132) | ||||
| 10914 | 10914 | 104429 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 390 Wilde Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010684.070780001 | 2089238.8941400002 | 37.7172547740586 | -122.405023648815 | (37.7172547740586, -122.405023648815) | |||
| 11180 | 11180 | 103669 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 20 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2016 12:00:00 AM | 3 | 3x3 | 6010632.36965 | 2089377.76421 | 37.717633192597205 | -122.40521212966298 | (37.7176331925972, -122.405212129663) | ||
| 12526 | 12526 | 104428 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 390 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 4x4 | 6010699.78768 | 2089233.16834 | 37.7172399307634 | -122.404968919684 | (37.7172399307634, -122.404968919684) | |||
| 13264 | 13264 | 187632 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 268 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994314.0 | 2087800.0 | 37.7123752149716 | -122.461502613047 | (37.7123752149716, -122.461502613047) | ||||
| 14055 | 14055 | 102316 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2325 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x6 | 6010512.04072 | 2105967.73717 | 37.763178958366396 | -122.406796606491 | (37.7631789583664, -122.406796606491) | |||
| 14289 | 14289 | 102315 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2325 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x6 | 6010497.0299 | 2105967.33167 | 37.7631770050447 | -122.40684849557199 | (37.7631770050447, -122.406848495572) | |||
| 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) | ||||
| 17835 | 17835 | 100094 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 11X Shotwell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007856.7 | 2107724.0 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | |||
| 17838 | 17838 | 110450 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 56 HANCOCK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003933.0 | 2105145.0 | 37.760549606286396 | -122.429492630385 | (37.7605496062864, -122.429492630385) | ||||
| 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) | ||||
| 20071 | 20071 | 99485 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Miramar Ave | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | |||
| 22991 | 22991 | 248811 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 204 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5997187.93599 | 2106731.52185 | 37.7645215868244 | -122.452935123452 | (37.7645215868244, -122.452935123452) | |||
| 23485 | 23485 | 206309 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 226 Sadowa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 5994744.569130001 | 2087779.6169999999 | 37.712344021541796 | -122.46001297051599 | (37.7123440215418, -122.460012970516) | |||
| 23531 | 23531 | 212068 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 65 San Pablo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 6ft | 5994349.34377 | 2097659.88165 | 37.7394500943456 | -122.46209504585501 | (37.7394500943456, -122.462095045855) | |||
| 23536 | 23536 | 124041 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 825 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 6ft | 5992887.39709 | 2114800.97407 | 37.7864307413426 | -122.468396508561 | (37.7864307413426, -122.468396508561) | |||
| 23549 | 23549 | 142248 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 603 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6004941.624 | 2110891.392 | 37.7763848724075 | -122.42641341835 | (37.7763848724075, -122.42641341835) | |||
| 23588 | 23588 | 142397 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 10 MAYFAIR DR | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5997908.5687 | 2114561.3906 | 37.7860616516624 | -122.45100731899299 | (37.7860616516624, -122.451007318993) | |||
| 23626 | 23626 | 206339 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 401 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5991723.99819 | 2097691.44738 | 37.7393852604321 | -122.471174553558 | (37.7393852604321, -122.471174553558) | |||
| 23683 | 23683 | 250745 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2850 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 4ft | 5986584.92122 | 2114476.3273400003 | 37.7851733080538 | -122.490177303062 | (37.7851733080538, -122.490177303062) | |||
| 23722 | 23722 | 206382 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 6 San Pablo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5994455.43125 | 2097793.85045 | 37.7398240468482 | -122.46173795563601 | (37.7398240468482, -122.461737955636) | |||
| 23774 | 23774 | 139544 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2231 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 6000683.1198 | 2113070.8118 | 37.7821273575936 | -122.44130115315399 | (37.7821273575936, -122.441301153154) | |||
| 23792 | 23792 | 206330 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 200 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5993399.93372 | 2102586.4706900003 | 37.752922548338205 | -122.465735507784 | (37.7529225483382, -122.465735507784) | |||
| 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) | ||||
| 23925 | 23925 | 126334 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 537 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6011902.4584 | 2117714.99047 | 37.795511896304 | -122.40281381130801 | (37.795511896304, -122.402813811308) | |||
| 24033 | 24033 | 189426 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 553 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 7ft | 6013011.23422 | 2104452.4501799997 | 37.759157834075204 | -122.398046364864 | (37.7591578340752, -122.398046364864) | |||
| 24125 | 24125 | 248891 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2250 Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008751.84514 | 2105355.74765 | 37.7613999302905 | -122.412841286317 | (37.7613999302905, -122.412841286317) | |||
| 24152 | 24152 | 139672 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2130 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6001050.5296 | 2113171.6663 | 37.7824252009505 | -122.44003731838 | (37.7824252009505, -122.44003731838) | |||
| 24156 | 24156 | 140741 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2001 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6001451.6757 | 2113177.4146 | 37.782463812590606 | -122.43864994354901 | (37.7824638125906, -122.438649943549) | |||
| 24222 | 24222 | 121484 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 381 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6010784.23761 | 2089159.3723400002 | 37.717042022358704 | -122.404671822369 | (37.7170420223587, -122.404671822369) | |||
| 24416 | 24416 | 212061 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 21 San Pablo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5994643.85383 | 2097859.63633 | 37.740015523303704 | -122.461091241468 | (37.7400155233037, -122.461091241468) | |||
| 24626 | 24626 | 126333 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 537 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6011888.21181 | 2117712.45326 | 37.79550413425461 | -122.402862928705 | (37.7955041342546, -122.402862928705) | |||
| 24717 | 24717 | 189454 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 110 Mendell St | 6 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6016981.3442400005 | 2098379.09321 | 37.742701973620704 | -122.38389280032801 | (37.7427019736207, -122.383892800328) | |||
| 24728 | 24728 | 126276 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1281 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007427.08243 | 2118463.17771 | 37.7973153292952 | -122.41835249187 | (37.7973153292952, -122.41835249187) | |||
| 24842 | 24842 | 126234 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2110 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6003833.18876 | 2115854.9515400003 | 37.7899508449138 | -122.430602069337 | (37.7899508449138, -122.430602069337) | |||
| 24862 | 24862 | 142424 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 10 MAYFAIR DR | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 0ft | 5997593.3287 | 2114514.5192 | 37.78591490273521 | -122.452094576108 | (37.7859149027352, -122.452094576108) | |||
| 24873 | 24873 | 175997 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 918 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6003927.76143 | 2090183.89548 | 37.719469539881004 | -122.428444351129 | (37.719469539881, -122.428444351129) | |||
| 24903 | 24903 | 201466 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 301 Catalina St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 6017699.909990001 | 2096021.8364 | 37.7362691149141 | -122.38124431128 | (37.7362691149141, -122.38124431128) | |||
| 24919 | 24919 | 205502 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1112 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 5990518.963819999 | 2103168.28108 | 37.754353444374104 | -122.475740823499 | (37.7543534443741, -122.475740823499) | |||
| 25033 | 25033 | 206346 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 110 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5992435.12688 | 2098339.05683 | 37.7412045394483 | -122.46876291808901 | (37.7412045394483, -122.468762918089) | |||
| 25063 | 25063 | 248826 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 187 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6007246.75289 | 2097900.1277 | 37.7408438951347 | -122.417518368874 | (37.7408438951347, -122.417518368874) | |||
| 25216 | 25216 | 142438 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 10 MAYFAIR DR | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 0ft | 5997453.3913 | 2114497.9365 | 37.7858613541886 | -122.452577521257 | (37.7858613541886, -122.452577521257) | |||
| 25308 | 25308 | 212247 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 721 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5994636.62754 | 2091219.17306 | 37.7217820160978 | -122.460635141294 | (37.7217820160978, -122.460635141294) | |||
| 25310 | 25310 | 140942 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2040 O'Farrell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 6001553.8791 | 2113243.0685 | 37.7826498950255 | -122.438301070072 | (37.7826498950255, -122.438301070072) | |||
| 25335 | 25335 | 248680 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 303 28th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003887.259219999 | 2099518.37438 | 37.7450976245676 | -122.429249604983 | (37.7450976245676, -122.429249604983) | |||
| 25435 | 25435 | 248664 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 Peralta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6010899.48081 | 2100534.51746 | 37.7482822129574 | -122.40507398387 | (37.7482822129574, -122.40507398387) | |||
| 25612 | 25612 | 189405 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1125 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6012240.53349 | 2103169.4400299997 | 37.755592014982604 | -122.40062170395001 | (37.7555920149826, -122.40062170395) | |||
| 25660 | 25660 | 222112 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 680 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003012.49781 | 2104256.7281400003 | 37.7580584641499 | -122.43261277357401 | (37.7580584641499, -122.432612773574) | |||
| 25707 | 25707 | 248873 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3160 19th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008240.90037 | 2105070.93341 | 37.760589203142096 | -122.414588281427 | (37.7605892031421, -122.414588281427) | |||
| 25739 | 25739 | 212063 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 39 San Pablo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5994526.15715 | 2097790.3563900003 | 37.7398185241173 | -122.461493163775 | (37.7398185241173, -122.461493163775) | |||
| 25819 | 25819 | 126312 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 19 Chestnut St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6011622.11904 | 2121118.1519299997 | 37.8048404946454 | -122.404023450725 | (37.8048404946454, -122.404023450725) | |||
| 25850 | 25850 | 248781 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 784 Duncan St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6001437.23624 | 2099723.01207 | 37.745520506460096 | -122.43773599094 | (37.7455205064601, -122.43773599094) | |||
| 25863 | 25863 | 126138 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2601 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6000495.78192 | 2118185.16591 | 37.796159369518 | -122.442316525005 | (37.796159369518, -122.442316525005) | |||
| 25866 | 25866 | 248778 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 172 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6006028.356980001 | 2096346.83132 | 37.736510259145604 | -122.42162083865401 | (37.7365102591456, -122.421620838654) | |||
| 25906 | 25906 | 249410 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 698 Polk St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6007114.554409999 | 2113257.76141 | 37.7830049436594 | -122.419064511231 | (37.7830049436594, -122.419064511231) | |||
| 25927 | 25927 | 189435 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 301 Mendell St | 4 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6016869.31993 | 2097857.6531700003 | 37.741264011617496 | -122.384243845296 | (37.7412640116175, -122.384243845296) | |||
| 25943 | 25943 | 142412 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 10 MAYFAIR DR | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5997733.6046 | 2114534.6553 | 37.7859782253852 | -122.45161071556002 | (37.7859782253852, -122.45161071556) | |||
| 25998 | 25998 | 245970 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 788 Clayton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5998635.6489 | 2107719.0312 | 37.767315895340296 | -122.44799900398701 | (37.7673158953403, -122.447999003987) | |||
| 26023 | 26023 | 189480 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 21 Commer Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6016438.6726 | 2094774.7446400002 | 37.7327751453509 | -122.385518088395 | (37.7327751453509, -122.385518088395) | |||
| 26081 | 26081 | 249738 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 22 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6000189.3449800005 | 2117178.8516 | 37.7933788258243 | -122.443304539972 | (37.7933788258243, -122.443304539972) | |||
| 26134 | 26134 | 222947 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 366 Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6003535.08021 | 2108659.73976 | 37.7701776938656 | -122.43111972360799 | (37.7701776938656, -122.431119723608) | |||
| 26203 | 26203 | 189492 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 822 Mendell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6015900.14922 | 2096633.8725400001 | 37.737850124878605 | -122.38750956961701 | (37.7378501248786, -122.387509569617) |
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");