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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77803 | 77803 | 86893 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Mason St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2007 12:00:00 AM | 3x3 | Permit Number 49821 | 6008765.0 | 2122158.0 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | ||
| 106093 | 106093 | 86891 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Mason St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49821 | 6008765.0 | 2122158.0 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | |||
| 110750 | 110750 | 86890 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49821 | 6008765.0 | 2122158.0 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | |||
| 129146 | 129146 | 86892 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Mason St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49821 | 6008765.0 | 2122158.0 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | |||
| 47013 | 47013 | 126293 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009210.11859 | 2121881.78828 | 37.8068021921193 | -122.412424475734 | (37.8068021921193, -122.412424475734) | |||
| 162106 | 162106 | 126294 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009197.285540001 | 2121879.6992099998 | 37.8067957358898 | -122.41246873943899 | (37.8067957358898, -122.412468739439) | |||
| 56074 | 56074 | 126295 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6009138.258880001 | 2121870.32475 | 37.8067666832919 | -122.412672350444 | (37.8067666832919, -122.412672350444) | |||
| 155940 | 155940 | 126296 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 North Point St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6009109.48206 | 2121867.97371 | 37.806758612790205 | -122.412771772309 | (37.8067586127902, -122.412771772309) | |||
| 169421 | 169421 | 126297 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 North Point St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6009095.838409999 | 2121864.72541 | 37.806748927978 | -122.41281875919901 | (37.806748927978, -122.412818759199) | |||
| 163673 | 163673 | 126298 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 North Point St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 4ft | 6008998.98319 | 2121852.98911 | 37.8067112661735 | -122.413153116346 | (37.8067112661735, -122.413153116346) | |||
| 178576 | 178576 | 126299 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 North Point St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008955.34228 | 2121845.4556400003 | 37.806688131109 | -122.41330361159599 | (37.806688131109, -122.413303611596) | |||
| 28998 | 28998 | 126300 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 North Point St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008880.73692 | 2121834.44066 | 37.80665369786829 | -122.413561019128 | (37.8066536978683, -122.413561019128) | |||
| 46934 | 46934 | 126301 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 North Point St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008867.14931 | 2121833.93475 | 37.8066515458005 | -122.413608006 | (37.8066515458005, -122.413608006) | |||
| 97581 | 97581 | 88132 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1288 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 6007534.97421 | 2121589.88295 | 37.80590654683979 | -122.41820094914101 | (37.8059065468398, -122.418200949141) | ||||
| 81350 | 81350 | 27432 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1288 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 4X4 | 6007580.927490001 | 2121572.8975299997 | 37.805862495661394 | -122.41804071537099 | (37.8058624956614, -122.418040715371) | |||
| 177297 | 177297 | 126292 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1198 Columbus Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6007576.38379 | 2121572.1997700003 | 37.8058603240585 | -122.41805639008498 | (37.8058603240585, -122.418056390085) | |||
| 57417 | 57417 | 126291 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1198 Columbus Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6007589.25664 | 2121562.16822 | 37.805833504483104 | -122.418011129904 | (37.8058335044831, -122.418011129904) | |||
| 139265 | 139265 | 27431 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1288 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 4X4 | 6007595.97622 | 2121559.89845 | 37.8058276504572 | -122.41798771471001 | (37.8058276504572, -122.41798771471) | |||
| 165848 | 165848 | 126290 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1198 Columbus Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6007603.03986 | 2121549.62811 | 37.80579984825761 | -122.417962541334 | (37.8057998482576, -122.417962541334) | |||
| 123133 | 123133 | 27430 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1288 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6007606.86637 | 2121548.41017 | 37.8057967194592 | -122.417949212693 | (37.8057967194592, -122.417949212693) | |||
| 31933 | 31933 | 126272 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 743 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007155.354590001 | 2121542.9483 | 37.8057563012647 | -122.419511352869 | (37.8057563012647, -122.419511352869) | |||
| 133436 | 133436 | 126271 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 757 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007135.30447 | 2121541.57652 | 37.8057514053527 | -122.41958064205299 | (37.8057514053527, -122.419580642053) | |||
| 40768 | 40768 | 126270 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 757 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007122.07694 | 2121536.84547 | 37.805737670012604 | -122.419626082101 | (37.8057376700126, -122.419626082101) | |||
| 73449 | 73449 | 126269 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 757 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6007103.42585 | 2121534.93603 | 37.805731376564495 | -122.419690491528 | (37.8057313765645, -122.419690491528) | |||
| 165511 | 165511 | 126268 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 757 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007089.07712 | 2121533.77158 | 37.8057273709962 | -122.419740064856 | (37.8057273709962, -122.419740064856) | |||
| 131127 | 131127 | 126289 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1198 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007647.01376 | 2121508.69836 | 37.8056899403132 | -122.41780745956699 | (37.8056899403132, -122.417807459567) | |||
| 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) | ||||
| 159242 | 159242 | 126141 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3734 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5999645.87114 | 2121415.38382 | 37.804980205246004 | -122.44548976666401 | (37.804980205246, -122.445489766664) | |||
| 115845 | 115845 | 126142 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3734 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5999648.2874 | 2121389.48257 | 37.804909225352205 | -122.44547954134501 | (37.8049092253522, -122.445479541345) | |||
| 72582 | 72582 | 34885 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1539 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38493 | 6002855.27225509 | 2121286.11305956 | 37.804807956300394 | -122.43437403696699 | (37.8048079563004, -122.434374036967) | ||||
| 50282 | 50282 | 143223 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 291 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6009921.7346 | 2121237.0316 | 37.8050717594781 | -122.40991623366399 | (37.8050717594781, -122.409916233664) | |||
| 148291 | 148291 | 126145 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 138 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6001269.24495 | 2121199.42999 | 37.8044797945642 | -122.43985641873199 | (37.8044797945642, -122.439856418732) | |||
| 168933 | 168933 | 249774 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 102 Pfeiffer St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6010412.38512 | 2121159.3166 | 37.804885859146104 | -122.408212787783 | (37.8048858591461, -122.408212787783) | |||
| 76191 | 76191 | 126316 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 130 Chestnut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6011523.49407 | 2121154.08896 | 37.8049336581286 | -122.404367285814 | (37.8049336581286, -122.404367285814) | |||
| 183252 | 183252 | 249775 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 102 Pfeiffer St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | Width 0ft | 6010401.04426 | 2121152.2311400003 | 37.8048657692012 | -122.40825153418999 | (37.8048657692012, -122.40825153419) | |||
| 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) | |||||
| 75111 | 75111 | 126315 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 19 Chestnut St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6011706.66389 | 2121131.24206 | 37.804881160187705 | -122.40373179429301 | (37.8048811601877, -122.403731794293) | |||
| 70619 | 70619 | 126314 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 19 Chestnut St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6011690.09523 | 2121129.11088 | 37.804874382907904 | -122.403788982197 | (37.8048743829079, -122.403788982197) | |||
| 118384 | 118384 | 126313 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 19 Chestnut St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6011665.22297 | 2121124.95419 | 37.80486158015471 | -122.40387476312999 | (37.8048615801547, -122.40387476313) | |||
| 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) | |||
| 43481 | 43481 | 4741 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1120 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/29/1992 12:00:00 AM | 12 | 3X3 | 6008069.3023022 | 2121114.6784448 | 37.8046318166674 | -122.416318139035 | (37.8046318166674, -122.416318139035) | ||
| 53681 | 53681 | 126311 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 19 Chestnut St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6011596.42071 | 2121114.01244 | 37.804827692793005 | -122.40411209150801 | (37.804827692793, -122.404112091508) | |||
| 170040 | 170040 | 126310 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 19 Chestnut St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011567.7051800005 | 2121110.4826700003 | 37.804816396425 | -122.404211216594 | (37.804816396425, -122.404211216594) | |||
| 44653 | 44653 | 126309 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 19 Chestnut St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6011549.22604 | 2121109.2132099997 | 37.80481187822979 | -122.40427507654499 | (37.8048118782298, -122.404275076545) | |||
| 135015 | 135015 | 126308 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 19 Chestnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6011431.79108 | 2121090.48477 | 37.804753891742294 | -122.404680155458 | (37.8047538917423, -122.404680155458) | |||
| 181032 | 181032 | 126307 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 19 Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6011412.75588 | 2121088.95225 | 37.8047486199155 | -122.40474592110901 | (37.8047486199155, -122.404745921109) | |||
| 62125 | 62125 | 126306 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 19 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6011394.26023 | 2121086.86047 | 37.8047418426192 | -122.404809780174 | (37.8047418426192, -122.404809780174) | |||
| 150290 | 150290 | 126305 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 19 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6011380.98964 | 2121084.38787 | 37.804734311709105 | -122.404855530454 | (37.8047343117091, -122.404855530454) | |||
| 158640 | 158640 | 142977 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1909 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6010355.8809 | 2121023.9734 | 37.804511076187 | -122.408398775224 | (37.804511076187, -122.408398775224) | |||
| 170873 | 170873 | 142978 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1905 Grant Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010357.7464 | 2121006.2509 | 37.804462519057395 | -122.40839106863199 | (37.8044625190574, -122.408391068632) | |||
| 120186 | 120186 | 102605 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6010368.0 | 2120990.0 | 37.8044184722981 | -122.40835443803499 | (37.8044184722981, -122.408354438035) | ||||
| 129292 | 129292 | 102606 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6010368.0 | 2120990.0 | 37.8044184722981 | -122.40835443803499 | (37.8044184722981, -122.408354438035) | ||||
| 178673 | 178673 | 142979 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 302 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 34 | Width 0ft | 6010333.0283 | 2120985.7302 | 37.8044047900705 | -122.40847515981001 | (37.8044047900705, -122.40847515981) | |||
| 75661 | 75661 | 142980 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 302 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6010297.117000001 | 2120982.4656 | 37.804393815126794 | -122.40859920407401 | (37.8043938151268, -122.408599204074) | |||
| 179457 | 179457 | 126275 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2836 Larkin St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 6006511.2494 | 2120976.42855 | 37.8041644823576 | -122.421700114785 | (37.8041644823576, -122.421700114785) | ||||
| 132412 | 132412 | 142990 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1847 GRANT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6010376.3672 | 2120881.545 | 37.804121150252 | -122.408317828181 | (37.804121150252, -122.408317828181) | |||
| 184975 | 184975 | 108614 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1847 GRANT AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6010358.9 | 2120872.9 | 37.804096435092504 | -122.408377664827 | (37.8040964350925, -122.408377664827) | |||
| 180869 | 180869 | 126302 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 150 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6011734.76105 | 2120835.8555 | 37.8040716705345 | -122.40361376458799 | (37.8040716705345, -122.403613764588) | |||
| 182603 | 182603 | 126303 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 150 Lombard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6011649.709869999 | 2120828.01575 | 37.804045393249105 | -122.40390753979601 | (37.8040453932491, -122.403907539796) | |||
| 169516 | 169516 | 126304 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 150 Lombard St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6011511.53944 | 2120807.30084 | 37.803980794943705 | -122.40438423177 | (37.8039807949437, -122.40438423177) | |||
| 185173 | 185173 | 142612 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2424 JONES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6008004.2032 | 2120805.2808 | 37.8037786279563 | -122.41652149146799 | (37.8037786279563, -122.416521491468) | |||
| 61554 | 61554 | 142611 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2424 JONES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6008004.2032 | 2120795.1714 | 37.8037508700928 | -122.41652077492901 | (37.8037508700928, -122.416520774929) | |||
| 36150 | 36150 | 69365 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3536 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 15 | 4.5x6 | Permit Number 33459 | 6002661.12901 | 2120784.76321 | 37.803420359914796 | -122.435010010914 | (37.8034203599148, -122.435010010914) |
| 73732 | 73732 | 126182 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1451 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003762.67842 | 2120705.9449400003 | 37.8032664301726 | -122.43119242750299 | (37.8032664301726, -122.431192427503) | |||
| 180926 | 180926 | 126181 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1451 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6003742.08845 | 2120700.5958 | 37.8032505760096 | -122.431263297686 | (37.8032505760096, -122.431263297686) | |||
| 171291 | 171291 | 126184 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3235 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 5ft | 6004572.288 | 2120697.68117 | 37.8032895858962 | -122.428390157106 | (37.8032895858962, -122.428390157106) | |||
| 62650 | 62650 | 126176 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3529 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5999701.32515 | 2120694.15268 | 37.80300306460379 | -122.445245975747 | (37.8030030646038, -122.445245975747) | |||
| 178372 | 178372 | 126180 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1451 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003710.0609 | 2120692.3256599996 | 37.8032260532978 | -122.43137353928499 | (37.8032260532978, -122.431373539285) | |||
| 26490 | 26490 | 126177 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3529 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5999703.196719999 | 2120677.23394 | 37.802956717126996 | -122.445238282035 | (37.802956717127, -122.445238282035) | |||
| 184942 | 184942 | 126185 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3235 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 5ft | 6004573.695180001 | 2120676.94649 | 37.803232733462295 | -122.42838380878099 | (37.8032327334623, -122.428383808781) | |||
| 147777 | 147777 | 126186 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3223 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 6004579.06351 | 2120655.52096 | 37.80317420827579 | -122.428363703522 | (37.8031742082758, -122.428363703522) | |||
| 162599 | 162599 | 126187 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3201 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6004586.522340001 | 2120587.15972 | 37.8029869280666 | -122.428333016857 | (37.8029869280666, -122.428333016857) | |||
| 36588 | 36588 | 126188 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3201 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6004588.02388 | 2120570.99055 | 37.8029426166745 | -122.42832666765301 | (37.8029426166745, -122.428326667653) | |||
| 64393 | 64393 | 126189 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3201 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 6ft | 6004592.21968 | 2120552.02505 | 37.802890779734895 | -122.42831079551 | (37.8028907797349, -122.42831079551) | |||
| 183254 | 183254 | 126148 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1535 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6004474.30573 | 2120123.1658 | 37.8017065704734 | -122.428688249077 | (37.8017065704734, -122.428688249077) | |||
| 159668 | 159668 | 126147 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1535 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004454.3216699995 | 2120122.0972599997 | 37.801702505524396 | -122.42875732690901 | (37.8017025055244, -122.428757326909) | |||
| 146615 | 146615 | 126274 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1240 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 6ft | 6006421.51674 | 2120105.21307 | 37.80176728640121 | -122.421948716173 | (37.8017672864012, -122.421948716173) | |||
| 40847 | 40847 | 126273 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1239 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006424.6577 | 2120048.11066 | 37.8016106748465 | -122.421933788324 | (37.8016106748465, -122.421933788324) | |||
| 6777 | 6777 | 26162 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 220 Richardson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999090.095480001 | 2119848.96049 | 37.800647486559704 | -122.447300272802 | (37.8006474865597, -122.447300272802) | |||
| 80282 | 80282 | 121422 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2466 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999524.0 | 2119846.0 | 37.800664141980704 | -122.44579857739599 | (37.8006641419807, -122.445798577396) | ||||
| 151323 | 151323 | 126144 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2474 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 6ft | 5999504.137519999 | 2119828.56241 | 37.8006151289325 | -122.445866054678 | (37.8006151289325, -122.445866054678) | |||
| 151477 | 151477 | 126146 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 41 Magnolia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 1ft | 6003510.16046 | 2119826.75465 | 37.8008380897709 | -122.43200345500799 | (37.8008380897709, -122.432003455008) | |||
| 89145 | 89145 | 50979 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 201 Richardson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2004 12:00:00 AM | 3x3 | Permit Number 47465 | 5999116.7 | 2119758.3 | 37.8004000774175 | -122.447201682136 | (37.8004000774175, -122.447201682136) | ||
| 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) | ||
| 152398 | 152398 | 126140 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 6005564.97386 | 2119630.33359 | 37.8004150450641 | -122.42487894930201 | (37.8004150450641, -122.424878949302) | |||
| 53323 | 53323 | 142483 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 502 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010521.5126 | 2119626.8488 | 37.800684190034794 | -122.40772701614401 | (37.8006841900348, -122.407727016144) | |||
| 154387 | 154387 | 126285 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1819 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6009101.69173 | 2119559.34428 | 37.800419255712 | -122.412635425182 | (37.800419255712, -122.412635425182) | |||
| 184128 | 184128 | 126286 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1819 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009103.85324 | 2119545.7916900003 | 37.8003821649739 | -122.412626986872 | (37.8003821649739, -122.412626986872) | |||
| 155467 | 155467 | 126178 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2413 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6000282.738 | 2119543.98555 | 37.7998781830919 | -122.44315133689 | (37.7998781830919, -122.44315133689) | |||
| 179278 | 179278 | 126143 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3233 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6000856.10571 | 2119467.95657 | 37.7997021039237 | -122.44116181705799 | (37.7997021039237, -122.441161817058) | |||
| 34040 | 34040 | 142909 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 470 GREEN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6010691.0969 | 2119300.3155 | 37.7997971013368 | -122.40711715196699 | (37.7997971013368, -122.407117151967) | |||
| 25072 | 25072 | 126288 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500x Van Ness Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 8ft | 6005772.33142 | 2119211.18315 | 37.7992758747311 | -122.424131583019 | (37.7992758747311, -122.424131583019) | |||
| 105899 | 105899 | 30491 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1123 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1956 12:00:00 AM | Permit Number 150 | 6011534.42767209 | 2119133.27614211 | 37.7993856101137 | -122.404187135798 | (37.7993856101137, -122.404187135798) | |||
| 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) | |||
| 47307 | 47307 | 115343 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2265 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006749.63624 | 2119018.0682200002 | 37.7988007611158 | -122.420736046057 | (37.7988007611158, -122.420736046057) | |||
| 7149 | 7149 | 23486 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005800.3407 | 2119014.80575 | 37.7987382537111 | -122.424020688524 | (37.7987382537111, -122.424020688524) | |||
| 35632 | 35632 | 115344 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2265 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6006750.9527900005 | 2119001.45265 | 37.7987552131524 | -122.42073031016301 | (37.7987552131524, -122.420730310163) | |||
| 178449 | 178449 | 126267 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1454 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6006000.00875 | 2119001.3122 | 37.79871247465999 | -122.423328812183 | (37.79871247466, -122.423328812183) | |||
| 79094 | 79094 | 114460 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1462 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005986.0 | 2118991.0 | 37.7986833693446 | -122.423376553534 | (37.7986833693446, -122.423376553534) | ||||
| 187259 | 187259 | 92861 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2245 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2009 12:00:00 AM | 11 | 3x3 | 6006750.866719999 | 2118980.24307 | 37.7986969721415 | -122.42072910149099 | (37.7986969721415, -122.420729101491) |
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");