Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189000 | 189000 | 123975 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 59 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993615.75025 | 2115111.34494 | 37.7873249775569 | -122.4658991705 | (37.7873249775569, -122.4658991705) | |||
| 188998 | 188998 | 183023 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2550 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983685.1086 | 2097771.6711 | 37.739137270019 | -122.49897497427901 | (37.739137270019, -122.498974974279) | |||
| 188997 | 188997 | 142210 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 419 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 5999721.1207 | 2110069.3739 | 37.7738313306649 | -122.444413453632 | (37.7738313306649, -122.444413453632) | |||
| 188995 | 188995 | 192310 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6011946.18566 | 2107352.67758 | 37.76706183436821 | -122.40193371137501 | (37.7670618343682, -122.401933711375) | |||
| 188994 | 188994 | 245076 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1387 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000344.2484 | 2109550.1314 | 37.7724411555945 | -122.442220678844 | (37.7724411555945, -122.442220678844) | |||
| 188993 | 188993 | 221754 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3879 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003935.10667 | 2102444.58543 | 37.753135026677604 | -122.42929277965099 | (37.7531350266776, -122.429292779651) | |||
| 188992 | 188992 | 224334 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005384.8818 | 2103641.26634 | 37.756502803379 | -122.42436427271099 | (37.756502803379, -122.424364272711) | |||
| 188990 | 188990 | 237330 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Montezuma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007590.604590001 | 2099741.7313 | 37.745919870209605 | -122.416459870422 | (37.7459198702096, -122.416459870422) | |||
| 188989 | 188989 | 110597 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 624 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 2x2 | 6009274.88021 | 2115156.652 | 37.7883402580439 | -122.411724859841 | (37.7883402580439, -122.411724859841) | |||
| 188988 | 188988 | 209466 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1878 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5991597.36257 | 2102597.82029 | 37.752849570170206 | -122.47196990591101 | (37.7528495701702, -122.471969905911) | |||
| 188986 | 188986 | 120093 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 655 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5987822.4003099995 | 2111507.4982 | 37.7770939337825 | -122.485678099475 | (37.7770939337825, -122.485678099475) | |||
| 188985 | 188985 | 34804 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 122 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | 4 | Permit Number 38440 | 5999160.28006 | 2089153.53909 | 37.716369479631204 | -122.444849697578 | (37.7163694796312, -122.444849697578) | |
| 188983 | 188983 | 141704 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 154 STANYAN BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5996607.8351 | 2111918.4266 | 37.778730220256 | -122.455316406199 | (37.778730220256, -122.455316406199) | |||
| 188982 | 188982 | 220022 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001965.3710900005 | 2100066.86744 | 37.746494668288996 | -122.435934385359 | (37.746494668289, -122.435934385359) | |||
| 188981 | 188981 | 131186 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 2501 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6001413.74236 | 2116589.85963 | 37.7918313506904 | -122.439025814797 | (37.7918313506904, -122.439025814797) | |||
| 188980 | 188980 | 220555 | Undocumented 2 | Aesculus hippocastanum :: White Horsechestnut 364 | 3145 23rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008162.12941 | 2102678.11582 | 37.7540146463708 | -122.41469137612101 | (37.7540146463708, -122.414691376121) | |||
| 188978 | 188978 | 245223 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 321 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005094.6874 | 2109989.2967 | 37.7739165895729 | -122.425819703011 | (37.7739165895729, -122.425819703011) | |||
| 188977 | 188977 | 233505 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 303 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004187.87714 | 2109045.00996 | 37.7712725222301 | -122.42888917559799 | (37.7712725222301, -122.428889175598) | |||
| 188975 | 188975 | 143021 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 685 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6008591.686000001 | 2120703.4993 | 37.8035321827214 | -122.414481260898 | (37.8035321827214, -122.414481260898) | |||
| 188971 | 188971 | 55570 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 81 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/1973 12:00:00 AM | 5 | Permit Number 49713 | 5996815.9739 | 2114044.1129 | 37.7845787332894 | -122.45474999571998 | (37.7845787332894, -122.45474999572) | ||
| 188970 | 188970 | 134111 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2716 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6001138.54268 | 2117794.6215 | 37.7951236499858 | -122.44006443013599 | (37.7951236499858, -122.440064430136) | |||
| 188969 | 188969 | 202343 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 230 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014615.41959 | 2115067.39464 | 37.7883933198478 | -122.393241068635 | (37.7883933198478, -122.393241068635) | |||
| 188968 | 188968 | 180471 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008133.97671 | 2092747.70208 | 37.7267463349569 | -122.414086246606 | (37.7267463349569, -122.414086246606) | |||
| 188966 | 188966 | 226346 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008464.57897 | 2101524.14473 | 37.7508630900604 | -122.41356381871599 | (37.7508630900604, -122.413563818716) | |||
| 188964 | 188964 | 132579 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 115 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998468.5423099995 | 2116022.0814 | 37.790104365469105 | -122.44917523966998 | (37.7901043654691, -122.44917523967) | |||
| 188963 | 188963 | 121868 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 382 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 6ft | 5990304.700669999 | 2112806.5202900004 | 37.7808050127417 | -122.477186088815 | (37.7808050127417, -122.477186088815) | |||
| 188960 | 188960 | 241552 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2825 Diamond St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002458.1519 | 2095543.34833 | 37.734102115717 | -122.43390712642599 | (37.734102115717, -122.433907126426) | |||
| 188956 | 188956 | 45565 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3561 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 6 | Permit Number 44309 | 5997197.65372 | 2116007.3067900003 | 37.789991026609705 | -122.45357132096001 | (37.7899910266097, -122.45357132096) | |
| 188955 | 188955 | 138211 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 41 Nido Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999227.06 | 2112067.7296 | 37.7792901011034 | -122.446266263591 | (37.7792901011034, -122.446266263591) | |||
| 188954 | 188954 | 138288 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2605 CALIFORNIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001853.9989 | 2115318.2614 | 37.7883649098379 | -122.43741143323999 | (37.7883649098379, -122.43741143324) | |||
| 188952 | 188952 | 192296 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010697.50187 | 2105678.84279 | 37.762396094938104 | -122.406134800806 | (37.7623960949381, -122.406134800806) | |||
| 188951 | 188951 | 177670 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 946 Olmstead St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008872.57604 | 2090401.61835 | 37.7203459408834 | -122.411367252501 | (37.7203459408834, -122.411367252501) | |||
| 188950 | 188950 | 240511 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 301 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009219.87224 | 2106727.2151200003 | 37.765191925295795 | -122.411319458036 | (37.7651919252958, -122.411319458036) | |||
| 188949 | 188949 | 141072 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 197 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996921.8999 | 2113055.5828 | 37.7818705666664 | -122.454312101068 | (37.7818705666664, -122.454312101068) | |||
| 188948 | 188948 | 84503 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 357 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50134 | 6011610.65584 | 2112713.99225 | 37.7817640420151 | -122.403471492712 | (37.7817640420151, -122.403471492712) | |
| 188947 | 188947 | 140139 | Undocumented 2 | Tristania conferta :: 79 | 1744 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999035.8387 | 2109765.9757 | 37.7729591530651 | -122.44676211071501 | (37.7729591530651, -122.446762110715) | |||
| 188946 | 188946 | 210372 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 195 Kensington Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994217.10914 | 2099094.32927 | 37.7433811146583 | -122.46265628039 | (37.7433811146583, -122.46265628039) | |||
| 188945 | 188945 | 69003 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2063 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 5 | Permit Number 33004 | 5982592.2747 | 2101083.7423 | 37.7481671399171 | -122.502998568536 | (37.7481671399171, -122.502998568536) | |
| 188943 | 188943 | 240914 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 85 Sycamore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006391.17124 | 2105833.44907 | 37.762578798502204 | -122.421039806442 | (37.7625787985022, -122.421039806442) | |||
| 188942 | 188942 | 227580 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 23 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003811.04552 | 2108200.21185 | 37.7689315761679 | -122.430132375016 | (37.7689315761679, -122.430132375016) | |||
| 188941 | 188941 | 196738 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 700 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6013717.49862 | 2109926.74166 | 37.7742283375105 | -122.395987369746 | (37.7742283375105, -122.395987369746) | |||
| 188940 | 188940 | 202612 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 560 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6011424.9228300005 | 2109694.3187 | 37.773462341755796 | -122.40390148738899 | (37.7734623417558, -122.403901487389) | |||
| 188938 | 188938 | 104756 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 50 Walnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5998478.129930001 | 2116269.10777 | 37.7907831827466 | -122.449159871157 | (37.7907831827466, -122.449159871157) | |||
| 188937 | 188937 | 234188 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 431 Day St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6003193.94569 | 2098602.90337 | 37.7425446794999 | -122.431581614504 | (37.7425446794999, -122.431581614504) | |||
| 188936 | 188936 | 241351 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2601 Mariposa St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6009671.132730001 | 2105926.35263 | 37.7630182387282 | -122.409702117253 | (37.7630182387282, -122.409702117253) | |||
| 188935 | 188935 | 133649 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3636 Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003131.50337 | 2120909.28227 | 37.8037889533516 | -122.433391166484 | (37.8037889533516, -122.433391166484) | |||
| 188934 | 188934 | 110474 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 745 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 6x9 | 6004444.60179 | 2111147.58704 | 37.77706021269321 | -122.42815102017799 | (37.7770602126932, -122.428151020178) | |||
| 188933 | 188933 | 219023 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1700 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993391.46248 | 2103845.40057 | 37.7563787563006 | -122.465856267847 | (37.7563787563006, -122.465856267847) | |||
| 188932 | 188932 | 246287 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2312 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002715.3396 | 2106368.9627 | 37.763841293949206 | -122.433791440708 | (37.7638412939492, -122.433791440708) | |||
| 188931 | 188931 | 195333 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 109 Steuart St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014551.003930001 | 2116991.43348 | 37.793672705393 | -122.393598652577 | (37.793672705393, -122.393598652577) | |||
| 188927 | 188927 | 114320 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 600 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007916.32551 | 2113778.66148 | 37.7844803264499 | -122.41632761162901 | (37.7844803264499, -122.416327611629) | |||
| 188926 | 188926 | 235831 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1960 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009499.060269999 | 2105650.63341 | 37.7622515325076 | -122.41027779129801 | (37.7622515325076, -122.410277791298) | |||
| 188925 | 188925 | 238649 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003254.383880001 | 2096371.53066 | 37.736421268524296 | -122.431213399685 | (37.7364212685243, -122.431213399685) | |||
| 188923 | 188923 | 179577 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 700 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001127.46159 | 2089574.9646 | 37.7176386901633 | -122.438080342229 | (37.7176386901633, -122.438080342229) | |||
| 188921 | 188921 | 138402 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1850 PIERCE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002032.4913 | 2114879.2037 | 37.7871695157566 | -122.43676243751001 | (37.7871695157566, -122.43676243751) | |||
| 188919 | 188919 | 128603 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 302 Clay St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012734.44977 | 2117571.80464 | 37.7951651617906 | -122.39992490023899 | (37.7951651617906, -122.399924900239) | |||
| 188918 | 188918 | 139460 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 822 Broderick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001026.3641 | 2111511.4487 | 37.777865290258 | -122.440001839118 | (37.777865290258, -122.440001839118) | |||
| 188917 | 188917 | 232553 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 665 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002074.013180001 | 2102049.1230599997 | 37.7519436434985 | -122.43570050948 | (37.7519436434985, -122.43570050948) | |||
| 188916 | 188916 | 235896 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 290 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006689.35782 | 2104440.3941099998 | 37.7587705986009 | -122.419909627549 | (37.7587705986009, -122.419909627549) | |||
| 188915 | 188915 | 138953 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 717 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004472.5713 | 2110950.3879 | 37.7765203347407 | -122.42804020876001 | (37.7765203347407, -122.42804020876) | |||
| 188914 | 188914 | 189521 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 131 Acacia Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6018061.54589 | 2096217.07965 | 37.7368251711525 | -122.380007535722 | (37.7368251711525, -122.380007535722) | |||
| 188913 | 188913 | 34598 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3200 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38292 | 5999298.828509999 | 2116018.40828 | 37.7901417341159 | -122.446302262734 | (37.7901417341159, -122.446302262734) | |
| 188912 | 188912 | 213530 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995845.09161 | 2092749.1474400002 | 37.7260524135838 | -122.456568407028 | (37.7260524135838, -122.456568407028) | |||
| 188910 | 188910 | 239118 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6005833.23887 | 2097623.0492 | 37.7400034633796 | -122.422386096966 | (37.7400034633796, -122.422386096966) | |||
| 188909 | 188909 | 141637 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1537 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000360.391 | 2110943.6425 | 37.7762683045045 | -122.44226489457701 | (37.7762683045045, -122.442264894577) | |||
| 188907 | 188907 | 220314 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 243 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999834.4826 | 2104724.5775099997 | 37.7591623243957 | -122.443637281941 | (37.7591623243957, -122.443637281941) | |||
| 188906 | 188906 | 220317 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 219 Diamond St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001761.83081 | 2104620.92645 | 37.758987459326896 | -122.43696418015399 | (37.7589874593269, -122.436964180154) | |||
| 188903 | 188903 | 240963 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 95 Eagle St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999830.95947 | 2104453.5747700003 | 37.758418016707395 | -122.44362999832501 | (37.7584180167074, -122.443629998325) | |||
| 188902 | 188902 | 182960 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1901 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5990064.3236 | 2098390.6107 | 37.741208843809794 | -122.47696398819299 | (37.7412088438098, -122.476963988193) | |||
| 188899 | 188899 | 226386 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 354 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006131.45892 | 2098074.37938 | 37.7412595329921 | -122.421387016722 | (37.7412595329921, -122.421387016722) | |||
| 188897 | 188897 | 84120 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 336 Campbell Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2006 12:00:00 AM | 6 | 6011186.92342 | 2088226.0732 | 37.7145018701492 | -122.403214308206 | (37.7145018701492, -122.403214308206) | ||
| 188896 | 188896 | 130104 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 366 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6007790.71445 | 2112722.51189 | 37.7815733308786 | -122.41668733866899 | (37.7815733308786, -122.416687338669) | |||
| 188894 | 188894 | 236811 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1236 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996773.9051 | 2107149.84009 | 37.765646446248496 | -122.454397355451 | (37.7656464462485, -122.454397355451) | |||
| 188893 | 188893 | 140656 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2250 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997220.8834 | 2109861.2154 | 37.7731168094428 | -122.453047103766 | (37.7731168094428, -122.453047103766) | |||
| 188892 | 188892 | 122076 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 363 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 5990564.43068 | 2112959.17169 | 37.7812392167443 | -122.47629871950399 | (37.7812392167443, -122.476298719504) | |||
| 188891 | 188891 | 224697 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3186 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6007787.21683 | 2102109.23167 | 37.752431548191296 | -122.415947634593 | (37.7524315481913, -122.415947634593) | |||
| 188890 | 188890 | 228688 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 15 Beaver St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002680.2972800005 | 2106779.00142 | 37.764965172032205 | -122.433941952662 | (37.7649651720322, -122.433941952662) | |||
| 188889 | 188889 | 210626 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1364 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992425.98915 | 2106184.83469 | 37.76274648698271 | -122.469365460244 | (37.7627464869827, -122.469365460244) | |||
| 188888 | 188888 | 97767 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 375 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2011 12:00:00 AM | 1 | 2x2 | Permit Number 768293 | 5997562.8708 | 2113817.3703 | 37.783998971375 | -122.452149632238 | (37.783998971375, -122.452149632238) | |
| 188887 | 188887 | 205063 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 951 Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991275.88315 | 2090803.5657400002 | 37.7204469347595 | -122.472221967882 | (37.7204469347595, -122.472221967882) | |||
| 188886 | 188886 | 133471 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3698 California St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5996792.4764 | 2114679.48373 | 37.7863219446349 | -122.45487721212601 | (37.7863219446349, -122.454877212126) | |||
| 188885 | 188885 | 230941 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 649 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007662.57175 | 2096318.6979900002 | 37.7365250260023 | -122.415968656243 | (37.7365250260023, -122.415968656243) | |||
| 188883 | 188883 | 228271 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 16 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003334.18679 | 2107439.7667900003 | 37.766816559572895 | -122.43172749535 | (37.7668165595729, -122.43172749535) | |||
| 188882 | 188882 | 132222 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 235 Moulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002168.34609 | 2119296.77795 | 37.7993067511504 | -122.43660873213001 | (37.7993067511504, -122.43660873213) | |||
| 188881 | 188881 | 248375 | Undocumented 2 | Tree(s) :: 17 | 1605 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997870.7026 | 2108171.6093 | 37.7685148040368 | -122.45067746589199 | (37.7685148040368, -122.450677465892) | |||
| 188880 | 188880 | 38814 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 286 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51147 | 5995268.26088 | 2113665.38834 | 37.7834499595789 | -122.460077076847 | (37.7834499595789, -122.460077076847) | |
| 188879 | 188879 | 142843 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1437 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6006701.0162 | 2115860.8988 | 37.79012922270321 | -122.420680041355 | (37.7901292227032, -122.420680041355) | |||
| 188878 | 188878 | 181847 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1315 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988762.7194 | 2099646.8033 | 37.744582424890204 | -122.481556399027 | (37.7445824248902, -122.481556399027) | |||
| 188877 | 188877 | 191318 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015134.48609 | 2108114.99928 | 37.7693324264746 | -122.39095906320499 | (37.7693324264746, -122.390959063205) | |||
| 188875 | 188875 | 30367 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 674 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1956 12:00:00 AM | 23 | Permit Number 55 | 6012983.3674 | 2103955.4994099997 | 37.7577917638944 | -122.398107878472 | (37.7577917638944, -122.398107878472) | ||
| 188873 | 188873 | 228603 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2128 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008707.82668 | 2106126.64949 | 37.7635141788588 | -122.41304803865 | (37.7635141788588, -122.41304803865) | |||
| 188872 | 188872 | 113547 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2017 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2015 12:00:00 AM | 1 | Permit Number 775016 | 6011715.20847 | 2105100.54779 | 37.7608650971692 | -122.40257424272 | (37.7608650971692, -122.40257424272) | ||
| 188871 | 188871 | 190172 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 91 Spear St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6014300.683019999 | 2116737.7398099997 | 37.792962209493496 | -122.39444701903 | (37.7929622094935, -122.39444701903) | |||
| 188870 | 188870 | 189960 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 562 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010412.08756 | 2108524.3089900003 | 37.7701931280454 | -122.407322550708 | (37.7701931280454, -122.407322550708) | |||
| 188869 | 188869 | 178549 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 42 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008341.68171 | 2086226.9900599997 | 37.7088534882771 | -122.412907384688 | (37.7088534882771, -122.412907384688) | |||
| 188868 | 188868 | 138392 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2445 PINE ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002231.3031 | 2115024.8123 | 37.7875806165804 | -122.43608501643499 | (37.7875806165804, -122.436085016435) | |||
| 188867 | 188867 | 204176 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 68 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001644.271930001 | 2094956.88038 | 37.732445589674896 | -122.43667899344901 | (37.7324455896749, -122.436678993449) | |||
| 188866 | 188866 | 238006 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 120 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002226.03876 | 2096243.0070099998 | 37.7360100427193 | -122.434759628851 | (37.7360100427193, -122.434759628851) | |||
| 188864 | 188864 | 178831 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 399 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003310.24269 | 2091435.5476900002 | 37.7228713361369 | -122.43066815423201 | (37.7228713361369, -122.430668154232) | |||
| 188862 | 188862 | 142199 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 300 LYON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6000263.9441 | 2109999.4219 | 37.7736702167976 | -122.44253072194599 | (37.7736702167976, -122.442530721946) |
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");