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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 570 | 570 | 22578 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006396.3025 | 2112828.5224900004 | 37.7817858856438 | -122.421518877095 | (37.7817858856438, -122.421518877095) | |||
| 598 | 598 | 22577 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006373.00538 | 2112825.1930299997 | 37.7817754301315 | -122.421599237822 | (37.7817754301315, -122.421599237822) | |||
| 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) | ||
| 718 | 718 | 99173 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003311.25259 | 2116120.54401 | 37.790650512059 | -122.432426898975 | (37.790650512059, -122.432426898975) | ||
| 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) | ||||
| 897 | 897 | 22581 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006522.42636 | 2112846.04587 | 37.7818411112169 | -122.42108379139799 | (37.7818411112169, -122.421083791398) | |||
| 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) | |||
| 1636 | 1636 | 139812 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1624 EDDY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1997 12:00:00 AM | 32 | Width 0ft | 6002737.4248 | 2112708.2774 | 37.7812487388446 | -122.434168269296 | (37.7812487388446, -122.434168269296) | ||
| 1832 | 1832 | 24314 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006601.99404 | 2112547.97273 | 37.781027160014204 | -122.420787355977 | (37.7810271600142, -122.420787355977) | |||
| 2401 | 2401 | 140740 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2057X O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6001431.032000001 | 2113174.7073 | 37.7824552046492 | -122.438721167537 | (37.7824552046492, -122.438721167537) | |||
| 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) | |||
| 2773 | 2773 | 114412 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1345 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6008898.23064 | 2117525.75314 | 37.794824095717395 | -122.413195602999 | (37.7948240957174, -122.413195602999) | ||||
| 2800 | 2800 | 248806 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1039 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1979 12:00:00 AM | 18 | Width 4ft | Permit Number 17875 | 5997248.91757 | 2106862.4287 | 37.7648845181415 | -122.45273365463001 | (37.7648845181415, -122.45273365463) | |
| 2898 | 2898 | 114413 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1345 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 6008903.22514 | 2117506.21986 | 37.7947707425189 | -122.413176939363 | (37.7947707425189, -122.413176939363) | ||||
| 2937 | 2937 | 142168 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1477 GROVE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000782.6842 | 2110659.1833 | 37.775511310355505 | -122.440783660256 | (37.7755113103555, -122.440783660256) | |||
| 3011 | 3011 | 142167 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1477 GROVE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6000740.7568 | 2110654.3455 | 37.775495639126795 | -122.440928349683 | (37.7754956391268, -122.440928349683) | |||
| 3045 | 3045 | 141431 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 501 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2005 12:00:00 AM | 17 | Width 0ft | Permit Number 48304 | 6005404.7905 | 2110954.8993 | 37.776585419130896 | -122.42481571306601 | (37.7765854191309, -122.424815713066) | |
| 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) | ||
| 3357 | 3357 | 32073 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3254 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Permit Number 35447 | 5999189.55674 | 2115674.61094 | 37.7891915158244 | -122.44665558658701 | (37.7891915158244, -122.446655586587) | |||
| 3447 | 3447 | 7810 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006241.41357 | 2112578.9156299997 | 37.781091791593205 | -122.422036983727 | (37.7810917915932, -122.422036983727) | |||
| 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) | ||||
| 3559 | 3559 | 24319 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6006449.33086 | 2112523.89037 | 37.7809524299494 | -122.42131378399901 | (37.7809524299494, -122.421313783999) | |||
| 3774 | 3774 | 99172 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003312.12208 | 2116110.60344 | 37.7906232670935 | -122.432423180296 | (37.7906232670935, -122.432423180296) | ||
| 3989 | 3989 | 22582 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006498.64773 | 2112839.17836 | 37.7818209142342 | -122.421165566743 | (37.7818209142342, -122.421165566743) | |||
| 4186 | 4186 | 9424 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/1994 12:00:00 AM | 12 | 3X3 | 6006118.832780001 | 2112436.92682 | 37.7806950106942 | -122.422450960554 | (37.7806950106942, -122.422450960554) | ||
| 4307 | 4307 | 22579 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006429.75961 | 2112830.68466 | 37.7817937088462 | -122.42140328454799 | (37.7817937088462, -122.421403284548) | |||
| 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) | ||
| 4673 | 4673 | 253651 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 131 Font Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 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) | |||
| 5515 | 5515 | 48743 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 5739 | 5739 | 99171 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003316.34975 | 2116092.5427599996 | 37.7905739167998 | -122.432407262311 | (37.7905739167998, -122.432407262311) | ||
| 5771 | 5771 | 99170 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003318.49866 | 2116076.63924 | 37.790530371641296 | -122.43239869085899 | (37.7905303716413, -122.432398690859) | ||
| 5793 | 5793 | 99169 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003320.5239 | 2116054.74736 | 37.790470376959796 | -122.432390119424 | (37.7904703769598, -122.432390119424) | ||
| 5879 | 5879 | 24320 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006433.20726 | 2112530.1062 | 37.7809685880643 | -122.421370005128 | (37.7809685880643, -122.421370005128) | |||
| 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) | |||
| 6053 | 6053 | 7809 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006235.14399 | 2112561.39045 | 37.7810433181208 | -122.422057428004 | (37.7810433181208, -122.422057428004) | |||
| 6135 | 6135 | 48746 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 6180 | 6180 | 113748 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 840X Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6009543.77791 | 2118449.1609099996 | 37.7973957673671 | -122.411027164876 | (37.7973957673671, -122.411027164876) | ||||
| 6223 | 6223 | 24318 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006459.0655 | 2112530.3105599997 | 37.7809706070487 | -122.421280563062 | (37.7809706070487, -122.421280563062) | |||
| 6363 | 6363 | 99168 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003328.674 | 2116003.83043 | 37.790331034186295 | -122.432358282529 | (37.7903310341863, -122.432358282529) | ||
| 6377 | 6377 | 7813 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Franklin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006213.15076 | 2112713.3724700003 | 37.7814593831787 | -122.422144314209 | (37.7814593831787, -122.422144314209) | |||
| 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) | |||
| 6477 | 6477 | 113747 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 840X Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2016 12:00:00 AM | 3 | 6009570.41641 | 2118454.8311400004 | 37.7974128301892 | -122.410935389082 | (37.7974128301892, -122.410935389082) | |||
| 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) | |||
| 6785 | 6785 | 24317 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006479.1525 | 2112537.25416 | 37.7809908049215 | -122.421211565287 | (37.7809908049215, -122.421211565287) | |||
| 6959 | 6959 | 48747 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 7016 | 7016 | 22573 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006249.787140001 | 2112806.77447 | 37.781717908586295 | -122.422024207046 | (37.7817179085863, -122.422024207046) | |||
| 7180 | 7180 | 48749 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 7248 | 7248 | 65393 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1345 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/1989 12:00:00 AM | 22 | Permit Number 28235 | 6008898.78625 | 2117545.17326 | 37.7948774497893 | -122.41319505442 | (37.7948774497893, -122.41319505442) | ||
| 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) | |||
| 7445 | 7445 | 99167 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003331.11107 | 2115984.74946 | 37.7902787808939 | -122.432348487091 | (37.7902787808939, -122.432348487091) | ||
| 7734 | 7734 | 24324 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006305.76929 | 2112511.39113 | 37.7809100152295 | -122.421809546989 | (37.7809100152295, -122.421809546989) | |||
| 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) | |||
| 7840 | 7840 | 19005 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3067 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000119.97054 | 2115432.29592 | 37.788579285248495 | -122.443419066834 | (37.7885792852485, -122.443419066834) | |||
| 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) | |||
| 7982 | 7982 | 99166 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | Permit Number 25928 | 6003335.0360900005 | 2115969.1620099996 | 37.7902362042855 | -122.43233379308701 | (37.7902362042855, -122.432333793087) | ||
| 8055 | 8055 | 113745 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 840X Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6009609.4912 | 2118458.30583 | 37.797424561837 | -122.410800425125 | (37.797424561837, -122.410800425125) | ||||
| 8095 | 8095 | 50823 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | Permit Number 47344 | |||||||||
| 8251 | 8251 | 22580 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006453.23929 | 2112834.51188 | 37.7818055412449 | -122.42132232756 | (37.7818055412449, -122.42132232756) | |||
| 8293 | 8293 | 24315 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006566.6125300005 | 2112551.64159 | 37.781035239531704 | -122.420910018978 | (37.7810352395317, -122.420910018978) | |||
| 8305 | 8305 | 24325 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | 3X3 | 6006278.38926 | 2112509.01094 | 37.7809019357225 | -122.42190409898998 | (37.7809019357225, -122.42190409899) | |||
| 8309 | 8309 | 22576 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006347.61377 | 2112822.4191900003 | 37.7817663820541 | -122.421686883966 | (37.7817663820541, -122.421686883966) | |||
| 8440 | 8440 | 19006 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3067 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000132.745080001 | 2115433.98205 | 37.7885846434091 | -122.443374990159 | (37.7885846434091, -122.443374990159) | |||
| 8642 | 8642 | 22574 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006283.90302 | 2112813.42944 | 37.7817381055674 | -122.421906654863 | (37.7817381055674, -122.421906654863) | |||
| 8650 | 8650 | 7811 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006219.73405 | 2112674.25147 | 37.7813523377843 | -122.422118759068 | (37.7813523377843, -122.422118759068) | |||
| 8773 | 8773 | 48750 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 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) | |
| 8925 | 8925 | 22575 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006314.95978 | 2112814.99848 | 37.7817441651975 | -122.42179932438499 | (37.7817441651975, -122.421799324385) | |||
| 8939 | 8939 | 48748 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 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) | |||
| 9025 | 9025 | 48744 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 9050 | 9050 | 1999 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 217 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 38 | 3X3 | 6007148.9837828 | 2097704.1672577998 | 37.7403003295941 | -122.417842531543 | (37.7403003295941, -122.417842531543) | |||
| 9075 | 9075 | 17962 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2507 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6001946.9790368 | 2114981.8697349 | 37.7874465501899 | -122.437065644028 | (37.7874465501899, -122.437065644028) | |||
| 9093 | 9093 | 12590 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 521 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 11 | 4x4 | 5993790.57771 | 2114837.48993 | 37.786583130222 | -122.465274409298 | (37.786583130222, -122.465274409298) | ||
| 9127 | 9127 | 12154 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016226.76201 | 2095667.61701 | 37.735215066832104 | -122.386312951947 | (37.7352150668321, -122.386312951947) | |||
| 9140 | 9140 | 12661 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1045 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 4X4 | 5992178.70595 | 2114775.57253 | 37.786320036254004 | -122.47084652786002 | (37.786320036254, -122.47084652786) | |||
| 9163 | 9163 | 17982 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2578 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6001610.4943389995 | 2114985.9919613 | 37.7874387369759 | -122.43823010545499 | (37.7874387369759, -122.438230105455) | |||
| 9177 | 9177 | 10667 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1021 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6002954.21433 | 2110590.33753 | 37.7754457061984 | -122.43326690297701 | (37.7754457061984, -122.433266902977) | |||
| 9233 | 9233 | 25445 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6016123.98501 | 2095766.22901 | 37.735480146065505 | -122.386675167071 | (37.7354801460655, -122.386675167071) | |||
| 9275 | 9275 | 9356 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 241 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 6000999.4900667 | 2098404.1035626 | 37.74187419547079 | -122.43915513344 | (37.7418741954708, -122.43915513344) | |||
| 9286 | 9286 | 4816 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 50X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 11x5 | 6005990.1672425 | 2097819.1039723 | 37.7405506369184 | -122.421857425384 | (37.7405506369184, -122.421857425384) |
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");