Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 3490 | 3490 | 141187 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1802 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 25 | Width 0ft | 6002206.3563 | 2112987.8984 | 37.7819863518957 | -122.436025516484 | (37.7819863518957, -122.436025516484) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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 | ||||||||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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) | |||
| 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) | |||
| 9297 | 9297 | 5763 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 401 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6004052.45174 | 2108353.78487 | 37.7693669201086 | -122.429308319494 | (37.7693669201086, -122.429308319494) | |||
| 9301 | 9301 | 28308 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 244X CORTLAND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6006809.0 | 2097383.0 | 37.739399336612 | -122.418995288624 | (37.739399336612, -122.418995288624) | |||
| 9314 | 9314 | 12158 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016158.70701 | 2095735.6730099998 | 37.735398167686206 | -122.38655298897699 | (37.7353981676862, -122.386552988977) | |||
| 9353 | 9353 | 12157 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016176.76201 | 2095719.00601 | 37.73535340295211 | -122.386489403775 | (37.7353534029521, -122.386489403775) | |||
| 9420 | 9420 | 12628 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 840 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 5992820.04588 | 2114852.30881 | 37.786567801977796 | -122.46863326133999 | (37.7865678019778, -122.46863326134) | |||
| 9423 | 9423 | 17963 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2507 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6001946.9790368 | 2114981.8697349 | 37.7874465501899 | -122.437065644028 | (37.7874465501899, -122.437065644028) | |||
| 9450 | 9450 | 19167 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 95 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003517.6175946 | 2107764.5447227 | 37.767718716857 | -122.43111622226601 | (37.767718716857, -122.431116222266) | |||
| 9455 | 9455 | 17964 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2507 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6001946.9790368 | 2114981.8697349 | 37.7874465501899 | -122.437065644028 | (37.7874465501899, -122.437065644028) | |||
| 9472 | 9472 | 12156 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016192.73501 | 2095700.95101 | 37.7353047117642 | -122.386432920212 | (37.7353047117642, -122.386432920212) | |||
| 9958 | 9958 | 19162 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 85 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003517.76355 | 2107824.4837 | 37.7678833029889 | -122.431119996093 | (37.7678833029889, -122.431119996093) | |||
| 13443 | 13443 | 14968 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016667.040519999 | 2097697.80462 | 37.7408139135396 | -122.384932128834 | (37.7408139135396, -122.384932128834) | |||
| 13566 | 13566 | 48742 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 13725 | 13725 | 14972 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016621.68773 | 2097636.5481 | 37.740643206920204 | -122.385084676324 | (37.7406432069202, -122.385084676324) | |||
| 13861 | 13861 | 12127 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6016490.26403 | 2095091.74303 | 37.733648414028295 | -122.385361804207 | (37.7336484140283, -122.385361804207) | |||
| 13922 | 13922 | 14989 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6016436.5067300005 | 2097390.6567700002 | 37.7399577940171 | -122.38570783365101 | (37.7399577940171, -122.385707833651) | |||
| 14417 | 14417 | 48751 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 14800 | 14800 | 12153 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016182.90625 | 2095712.9210700002 | 37.7353370350581 | -122.386467736523 | (37.7353370350581, -122.386467736523) | |||
| 15637 | 15637 | 48745 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 15813 | 15813 | 14969 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3x3 | 6016654.44168 | 2097681.89431 | 37.7407695301847 | -122.38497458311501 | (37.7407695301847, -122.384974583115) | |||
| 15841 | 15841 | 12149 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016248.95724 | 2095649.3696400002 | 37.735166191751 | -122.38623494249399 | (37.735166191751, -122.386234942494) | |||
| 16140 | 16140 | 12129 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016454.923280001 | 2095170.51744 | 37.7338627575466 | -122.385489476485 | (37.7338627575466, -122.385489476485) | |||
| 16161 | 16161 | 14904 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 175 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6017055.387680001 | 2098389.95887 | 37.7427359014434 | -122.383637533158 | (37.7427359014434, -122.383637533158) | |||
| 16226 | 16226 | 14876 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 50 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6017126.2926199995 | 2098751.68022 | 37.7437330337612 | -122.383417536507 | (37.7437330337612, -122.383417536507) | |||
| 16652 | 16652 | 14973 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Mendell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016605.91834 | 2097618.21478 | 37.740591995028 | -122.385137924278 | (37.740591995028, -122.385137924278) | |||
| 16680 | 16680 | 14970 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 18 | 3x3 | 6016646.28629 | 2097669.62437 | 37.740735388316395 | -122.385001926999 | (37.7407353883164, -122.385001926999) | |||
| 16938 | 16938 | 16130 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 339 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 5999827.96036 | 2094635.2259799999 | 37.73145901361271 | -122.442935300848 | (37.7314590136127, -122.442935300848) | |||
| 17040 | 17040 | 12655 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1016 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 6x21 | 5992294.67406 | 2114836.34542 | 37.7864936077921 | -122.47044973930201 | (37.7864936077921, -122.470449739302) | |||
| 17061 | 17061 | 5075 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2518X Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002273.67466 | 2097186.93566 | 37.7386045571491 | -122.434662408564 | (37.7386045571491, -122.434662408564) | |||
| 17140 | 17140 | 19179 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 106 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6003475.35494 | 2107644.30442 | 37.767386171248 | -122.431253819727 | (37.767386171248, -122.431253819727) | |||
| 17406 | 17406 | 19187 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 125 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003528.70248 | 2107586.69801 | 37.7672310211182 | -122.43106518602501 | (37.7672310211182, -122.431065186025) | |||
| 17686 | 17686 | 14577 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1135 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 5999374.0888 | 2108906.7208 | 37.7706191740488 | -122.445530268097 | (37.7706191740488, -122.445530268097) | |||
| 17750 | 17750 | 2151 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1107 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001039.9865 | 2095675.11992 | 37.734383349014394 | -122.43881959664101 | (37.7343833490144, -122.438819596641) | |||
| 17961 | 17961 | 9357 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 244 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6000993.28256 | 2098353.57528 | 37.7417351034945 | -122.43917297625099 | (37.7417351034945, -122.439172976251) | |||
| 18094 | 18094 | 16230 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 567 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998330.20149 | 2094661.3287400003 | 37.7314451793547 | -122.44811519437799 | (37.7314451793547, -122.448115194378) | |||
| 18119 | 18119 | 4297 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4348 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001630.45884 | 2100316.0332 | 37.7471597870885 | -122.43711030921301 | (37.7471597870885, -122.437110309213) | |||
| 18275 | 18275 | 5786 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 545 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003176.40068 | 2108310.41756 | 37.769198208965896 | -122.432335439751 | (37.7691982089659, -122.432335439751) | |||
| 18367 | 18367 | 99991 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Clay Montgomery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44594 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | ||||
| 18545 | 18545 | 5094 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2608 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6002249.53771 | 2096620.3889799998 | 37.737047580668296 | -122.434705361078 | (37.7370475806683, -122.434705361078) | |||
| 18611 | 18611 | 4312 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002294.35545 | 2095730.49773 | 37.73460668843771 | -122.434486797948 | (37.7346066884377, -122.434486797948) | |||
| 18759 | 18759 | 12961 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 62 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6001945.75733 | 2095702.9994599998 | 37.7345113899755 | -122.435690050366 | (37.7345113899755, -122.435690050366) | |||
| 18946 | 18946 | 16174 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 431 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999199.03492 | 2094645.6030400002 | 37.731451629275796 | -122.445110353454 | (37.7314516292758, -122.445110353454) | |||
| 18960 | 18960 | 4321 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 20X Brompton Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002183.61558 | 2095631.29861 | 37.7343280236114 | -122.43486257064801 | (37.7343280236114, -122.434862570648) |
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");