trees
194,517 rows sorted by Neighborhoods (old) descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5700 | 247227 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 754 Duboce Ave | 3 | : | Tree | Private 2 | 13 | Width 4ft | 6002088.83354 | 2108298.92928 | 37.7691049375705 | -122.436096447702 | (37.7691049375705, -122.436096447702) | 15 | 5 | 5 | 29492 | 9 | |||
5777 | 236886 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 19 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999794.84017 | 2107740.78747 | 37.7674418258017 | -122.443991102207 | (37.7674418258017, -122.443991102207) | 15 | 5 | 5 | 29492 | 9 | |||
5821 | 232036 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 50 Scott St | 6 | : | Tree | Private 2 | 7 | Width 3ft | 6002425.62423 | 2108559.69988 | 37.7698400775965 | -122.434950161914 | (37.7698400775965, -122.434950161914) | 15 | 5 | 5 | 29492 | 9 | |||
5878 | 236882 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 150 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2016 12:00:00 AM | 5 | Width 3ft | Permit Number 772898 | 5999413.41178 | 2107340.88769 | 37.7663220358477 | -122.445281650937 | (37.7663220358477, -122.445281650937) | 15 | 5 | 5 | 29492 | 9 | |
5908 | 105725 | Undocumented 4 | Ficus laurel :: 247 | 895 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002505 | 2109533 | 37.7725170259656 | -122.434745213579 | (37.7725170259656, -122.434745213579) | 15 | 5 | 11 | 29492 | 9 | |||
5966 | 229069 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 134 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5997862.26563 | 2106825.97053 | 37.7648195394167 | -122.450609621445 | (37.7648195394167, -122.450609621445) | 15 | 5 | 11 | 29492 | 9 | |||
5985 | 247277 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 404 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2015 12:00:00 AM | 9 | Width 0ft | 5998904.2718 | 2109290.33 | 37.7716456345938 | -122.447182976567 | (37.7716456345938, -122.447182976567) | 15 | 5 | 11 | 29492 | 9 | ||
6068 | 244550 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1544 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 5999032 | 2109089 | 37.7711001308876 | -122.446726670211 | (37.7711001308876, -122.446726670211) | 15 | 5 | 11 | 29492 | 9 | |||
6122 | 221395 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 704 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 08:44:00 AM | 3 | Width 3ft | 6002236.87075 | 2108821.32754 | 37.7705477235228 | -122.435621774727 | (37.7705477235228, -122.435621774727) | 15 | 5 | 11 | 29492 | 9 | ||
6128 | 54602 | Permitted Site 7 | Tree(s) :: 17 | 9 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | Permit Number 10425 | 6001366.18346921 | 2108717.79509064 | 37.770213956935 | -122.438626063816 | (37.770213956935, -122.438626063816) | 15 | 5 | 11 | 29492 | 9 | |||
6155 | 247321 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 212 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002821 | 2109296 | 37.7718842175888 | -122.433635197846 | (37.7718842175888, -122.433635197846) | 15 | 5 | 11 | 29492 | 9 | |||
6189 | 260917 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1740 Page St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5998239.87383 | 2108958.8784 | 37.7706975687071 | -122.44945727244 | (37.7706975687071, -122.44945727244) | 15 | 5 | 11 | 29492 | 9 | |||
6191 | 244986 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1443 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999693.832 | 2109119.8472 | 37.7712226140057 | -122.44443959552 | (37.7712226140057, -122.44443959552) | 15 | 5 | 11 | 29492 | 9 | |||
6199 | 244531 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1504 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998919.2255 | 2108717.3892 | 37.7700733392593 | -122.44709001202 | (37.7700733392593, -122.44709001202) | 15 | 5 | 11 | 29492 | 9 | |||
6391 | 246158 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1652 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5997620.7172 | 2108179.7857 | 37.7685229419277 | -122.451542729467 | (37.7685229419277, -122.451542729467) | 15 | 5 | 11 | 29492 | 9 | |||
6425 | 102410 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000310.8 | 2109142 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | 15 | 5 | 11 | 29492 | 9 | |||||
6556 | 58570 | Permitted Site 7 | Tree(s) :: 17 | 21 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1979 12:00:00 AM | Permit Number 17762 | 5998605.35109058 | 2106881.40863757 | 37.7650142634589 | -122.448043483158 | (37.7650142634589, -122.448043483158) | 15 | 5 | 11 | 29492 | 9 | |||
6578 | 245102 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 250 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5999861.4659 | 2109378.2907 | 37.7719417978626 | -122.443878316418 | (37.7719417978626, -122.443878316418) | 15 | 5 | 11 | 29492 | 9 | |||
6645 | 226161 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 126 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/1993 12:00:00 AM | 9 | Width 4ft | Permit Number 32799 | 5997997.11826 | 2106529.02842 | 37.76401192934 | -122.450121798605 | (37.76401192934, -122.450121798605) | 15 | 5 | 11 | 29492 | 9 | |
6647 | 233181 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1088 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998975.05646 | 2106207.82472 | 37.7631858975236 | -122.446716299819 | (37.7631858975236, -122.446716299819) | 15 | 5 | 5 | 29492 | 9 | |||
6712 | 247499 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 348 Scott St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 0ft | 6002255.8916 | 2109762.6323 | 37.7731333935223 | -122.43562333462 | (37.7731333935223, -122.43562333462) | 15 | 5 | 11 | 29492 | 9 | |||
6803 | 58505 | Permitted Site 7 | Tree(s) :: 17 | 1356 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1979 12:00:00 AM | Permit Number 17679 | 5999211.20393328 | 2108405.73280016 | 37.7692342875299 | -122.446057646319 | (37.7692342875299, -122.446057646319) | 15 | 5 | 11 | 29492 | 9 | |||
6806 | 105051 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1244 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/2017 12:00:00 AM | 3 | Permit Number 779926 | 5999515.4 | 2108544.9 | 37.7696337718916 | -122.445015457708 | (37.7696337718916, -122.445015457708) | 15 | 5 | 11 | 29492 | 9 | ||
6859 | 246229 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5999439.8115 | 2107740.3807 | 37.7674204502126 | -122.44521906453 | (37.7674204502126, -122.44521906453) | 15 | 5 | 11 | 29492 | 9 | |||
7057 | 246148 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1504 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5998461.6736 | 2108298.4947 | 37.7688970087309 | -122.448642496615 | (37.7688970087309, -122.448642496615) | 15 | 5 | 11 | 29492 | 9 | |||
7091 | 88264 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1911 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51250 | 5997436 | 2108804 | 37.7702262944805 | -122.452226693379 | (37.7702262944805, -122.452226693379) | 15 | 5 | 11 | 29492 | 9 | |
7150 | 260618 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 637 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/18/2019 12:00:00 AM | 3 | 6003090.98743 | 2109246.85163 | 37.7717645837124 | -122.432697781433 | (37.7717645837124, -122.432697781433) | 15 | 5 | 11 | 29492 | 9 | |||
7238 | 17116 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1899 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997981.6278 | 2109222.6111 | 37.7714069348749 | -122.450369559944 | (37.7714069348749, -122.450369559944) | 15 | 5 | 11 | 29492 | 9 | |||
7358 | 108758 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1449 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999638.3 | 2109087.9 | 37.7711317264146 | -122.444629385712 | (37.7711317264146, -122.444629385712) | 15 | 5 | 11 | 29492 | 9 | |||||
7394 | 236442 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1098 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998931 | 2106271 | 37.7633568442315 | -122.446873221995 | (37.7633568442315, -122.446873221995) | 15 | 5 | 11 | 29492 | 9 | |||
7432 | 40564 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 223 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2004 12:00:00 AM | Permit Number 41608 | 6003273.4207217 | 2109055.89818285 | 37.7712506170222 | -122.432053094849 | (37.7712506170222, -122.432053094849) | 15 | 9 | 11 | 29492 | 9 | ||
7467 | 238440 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 701 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2020 04:27:00 PM | 2 | Width 3ft | 6002273.48193 | 2108783.68455 | 37.7704464445658 | -122.435492443229 | (37.7704464445658, -122.435492443229) | 15 | 5 | 5 | 29492 | 9 | ||
7468 | 244539 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 410 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998914.5258 | 2109210.0073 | 37.7714256747979 | -122.447141725905 | (37.7714256747979, -122.447141725905) | 15 | 5 | 11 | 29492 | 9 | |||
7475 | 260914 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1165 Oak St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 6001427.67727 | 2109710.45692 | 37.7729430567741 | -122.438484490103 | (37.7729430567741, -122.438484490103) | 15 | 5 | 11 | 29492 | 9 | |||
7542 | 247487 | DPW Maintained 1 | Tristania conferta :: 61 | 312 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002757.5424 | 2109611.6714 | 37.772747372498 | -122.433877269198 | (37.772747372498, -122.433877269198) | 15 | 5 | 11 | 29492 | 9 | |||
7577 | 248396 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1655 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | 7 | Width 0ft | Permit Number 41881 | 5997671.1383 | 2108143.749 | 37.7684268816356 | -122.451365728625 | (37.7684268816356, -122.451365728625) | 15 | 5 | 11 | 29492 | 9 | |
7621 | 239705 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4922 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 5997802.28625 | 2105653.55065 | 37.7615969375718 | -122.450732535394 | (37.7615969375718, -122.450732535394) | 15 | 5 | 11 | 29492 | 9 | |||
7624 | 246397 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1320 Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999315.6516 | 2108414.4782 | 37.769264264093 | -122.445696997639 | (37.769264264093, -122.445696997639) | 15 | 5 | 11 | 29492 | 9 | |||
7656 | 41147 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1571 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | Permit Number 41880 | 5998098.90766238 | 2108198.23177185 | 37.7686009624438 | -122.449890046711 | (37.7686009624438, -122.449890046711) | 15 | 5 | 11 | 29492 | 9 | ||
7672 | 248550 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 136 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5999176.8044 | 2107705.1011 | 37.767308565322 | -122.446126228732 | (37.767308565322, -122.446126228732) | 15 | 5 | 11 | 29492 | 9 | |||
7750 | 248443 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 721 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997578.9268 | 2108015.8037 | 37.768070296065 | -122.451675447809 | (37.768070296065, -122.451675447809) | 15 | 5 | 11 | 29492 | 9 | |||
7848 | 54566 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1312 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 3x3 | Permit Number 10364 | 6000274.16247872 | 2109249.10106233 | 37.7716106075543 | -122.44244149612 | (37.7716106075543, -122.44244149612) | 15 | 5 | 11 | 29492 | 9 | ||
7909 | 244126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1777 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 0ft | 5998100.8363 | 2108896.3044 | 37.7705178019644 | -122.449933692773 | (37.7705178019644, -122.449933692773) | 15 | 5 | 11 | 29492 | 9 | |||
7940 | 245907 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 205 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001841.0498 | 2108801.5549 | 37.7704709427473 | -122.436989504702 | (37.7704709427473, -122.436989504702) | 15 | 5 | 11 | 29492 | 9 | |||
7960 | 228004 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1039 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5998111.03938 | 2106633.51885 | 37.7643053520281 | -122.449735311348 | (37.7643053520281, -122.449735311348) | 15 | 5 | 11 | 29492 | 9 | |||
8064 | 240144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1207 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998176.37667 | 2106172.12741 | 37.7630422254456 | -122.449476081756 | (37.7630422254456, -122.449476081756) | 15 | 5 | 11 | 29492 | 9 | |||
8185 | 247646 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900 Duboce Ave | 2 | : | Tree | Private 2 | 13 | Width 5ft | 6001616.30949 | 2108303.20625 | 37.7690898244695 | -122.437731184045 | (37.7690898244695, -122.437731184045) | 15 | 5 | 5 | 29492 | 9 | |||
8379 | 114770 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | ||||
8396 | 225575 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Carmelita St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6002578.23632 | 2108754.51591 | 37.7703836584071 | -122.434436211974 | (37.7703836584071, -122.434436211974) | 15 | 5 | 5 | 29492 | 9 | |||
8428 | 228137 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 266 Rivoli St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997698.72333 | 2105921.93859 | 37.762327934407 | -122.451110070772 | (37.762327934407, -122.451110070772) | 15 | 5 | 11 | 29492 | 9 | |||
8462 | 56815 | Permitted Site 7 | Tree(s) :: 17 | 1025 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | Permit Number 14046 | 5999125.01104675 | 2106549.41228247 | 37.764132376363 | -122.446222231908 | (37.764132376363, -122.446222231908) | 15 | 5 | 11 | 29492 | 9 | |||
8470 | 14592 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1222 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3x3 | 5999472.8199 | 2108630.0925 | 37.7698652586639 | -122.445168866065 | (37.7698652586639, -122.445168866065) | 15 | 5 | 11 | 29492 | 9 | |||
8565 | 105233 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1508 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5998474.1 | 2108297 | 37.7688936152058 | -122.448599407064 | (37.7688936152058, -122.448599407064) | 15 | 5 | 11 | 29492 | 9 | |||
8623 | 56851 | Permitted Site 7 | Tree(s) :: 17 | 824 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | Permit Number 14085 | 5999153.34024967 | 2107522.86966015 | 37.7668068637023 | -122.446194277772 | (37.7668068637023, -122.446194277772) | 15 | 5 | 5 | 29492 | 9 | |||
8630 | 5179 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1071X Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6001831.363 | 2109760.4908 | 37.7731033917316 | -122.437091677951 | (37.7731033917316, -122.437091677951) | 15 | 5 | 11 | 29492 | 9 | |||
8692 | 247232 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 760 Duboce Ave | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6002013.60886 | 2108293.7767 | 37.7690865158689 | -122.436356276247 | (37.7690865158689, -122.436356276247) | 15 | 5 | 5 | 29492 | 9 | |||
8734 | 227141 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997670.57496 | 2105917.36363 | 37.7623137611024 | -122.451207095032 | (37.7623137611024, -122.451207095032) | 15 | 5 | 11 | 29492 | 9 | |||
8747 | 58667 | Permitted Site 7 | Tree(s) :: 17 | 160 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1979 12:00:00 AM | Permit Number 17891 | 5998309.60623397 | 2107835.13472194 | 37.7676160435774 | -122.449135099535 | (37.7676160435774, -122.449135099535) | 15 | 5 | 11 | 29492 | 9 | |||
8769 | 32194 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 40 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1995 12:00:00 AM | 2 | Permit Number 35521 | 6000876.834 | 2109176.6725 | 37.7714460698883 | -122.440351630177 | (37.7714460698883, -122.440351630177) | 15 | 5 | 11 | 29492 | 9 | |
8805 | 53790 | Permitted Site 7 | Tree(s) :: 17 | 169 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/1986 12:00:00 AM | Permit Number 23032 | 5998265.46795949 | 2107775.81864913 | 37.7674506521184 | -122.449283493491 | (37.7674506521184, -122.449283493491) | 15 | 5 | 11 | 29492 | 9 | |||
8846 | 97906 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 401 Upper Ter | 1 | Front Yard : Yard | Tree | Private 2 | 12/01/2011 12:00:00 AM | 60 | Permit Number 768366 | 5999222.6 | 2106240.8 | 37.7632905770055 | -122.44586250428 | (37.7632905770055, -122.44586250428) | 15 | 5 | 5 | 29492 | 9 | ||
8852 | 248572 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 196 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998334.1825 | 2107625.9113 | 37.7670429747654 | -122.449035020083 | (37.7670429747654, -122.449035020083) | 15 | 5 | 11 | 29492 | 9 | |||
8865 | 248498 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 156 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998302.5369 | 2107853.4873 | 37.7676660307619 | -122.449160873661 | (37.7676660307619, -122.449160873661) | 15 | 5 | 11 | 29492 | 9 | |||
9152 | 64088 | Permitted Site 7 | Tree(s) :: 17 | 715 Buena Vista West Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1987 12:00:00 AM | Permit Number 24850 | 5999882.54311766 | 2107850.29085779 | 37.7677474972086 | -122.443695618229 | (37.7677474972086, -122.443695618229) | 15 | 5 | 5 | 29492 | 9 | |||
9272 | 245113 | DPW Maintained 1 | Cinnamomum camphora :: Camphor Tree 90 | 265 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999808.2851 | 2109439.1163 | 37.7721057759535 | -122.444066643429 | (37.7721057759535, -122.444066643429) | 15 | 5 | 11 | 29492 | 9 | |||
9320 | 221746 | Permitted Site 7 | Pittosporum spp :: Pittosporum spp 170 | 200 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | 25 | Width 3ft | Permit Number 12382 | 5997646.78521 | 2106482.1718 | 37.7638632192392 | -122.451330111502 | (37.7638632192392, -122.451330111502) | 15 | 5 | 11 | 29492 | 9 | |
9337 | 244882 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1397 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999938.3807 | 2109154.2405 | 37.7713309995727 | -122.443596165541 | (37.7713309995727, -122.443596165541) | 15 | 5 | 11 | 29492 | 9 | |||
9365 | 247654 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900 Duboce Ave | 10 | : | Tree | Private 2 | 15 | Width 5ft | 6001517.12711 | 2108295.57391 | 37.7690632279012 | -122.438073702561 | (37.7690632279012, -122.438073702561) | 15 | 5 | 5 | 29492 | 9 | |||
9367 | 83358 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1160 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50875 | 5997390.75214654 | 2106213.86032098 | 37.7631118403797 | -122.452196286828 | (37.7631118403797, -122.452196286828) | 15 | 5 | 11 | 29492 | 9 | ||
9370 | 110531 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 1201X PAGE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000585 | 2109266 | 37.7716747202038 | -122.441367506705 | (37.7716747202038, -122.441367506705) | 15 | 5 | 11 | 29492 | 9 | ||||
9461 | 98346 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1943 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997281 | 2108783 | 37.7701597533774 | -122.452761318704 | (37.7701597533774, -122.452761318704) | 15 | 5 | 11 | 29492 | 9 | ||||
9466 | 49338 | Permitted Site 7 | Fraxinus angustifolia :: Narrow-leaved Ash 331 | 100 Clifford Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2003 12:00:00 AM | Permit Number 46332 | 5999646.98705896 | 2106515.41862964 | 37.7640688343052 | -122.444414431135 | (37.7640688343052, -122.444414431135) | 15 | 5 | 5 | 29492 | 9 | |||
9481 | 10434 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1457 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 5999128.9575 | 2108690.2041 | 37.7700106766776 | -122.44636259864 | (37.7700106766776, -122.44636259864) | 15 | 5 | 11 | 29492 | 9 | |||
9553 | 248603 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 404 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5997968.8193 | 2107535.8196 | 37.7667747031965 | -122.45029225419 | (37.7667747031965, -122.45029225419) | 15 | 5 | 11 | 29492 | 9 | |||
9653 | 247307 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 311 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003219.2087 | 2109482.81 | 37.7724197383315 | -122.432271110524 | (37.7724197383315, -122.432271110524) | 15 | 9 | 11 | 29492 | 9 | |||
9668 | 264919 | Property Tree 8 | Olea Majestic Beauty :: 183 | 1833 Page St | 1 | Sidewalk: Property side : Yard | Tree | Public Library 12 | 3x3 | 5997789 | 2108763 | 37.7701339345343 | -122.451002717521 | (37.7701339345343, -122.451002717521) | 15 | 5 | 11 | 29492 | 9 | ||||
9802 | 245988 | Undocumented 4 | :: 45 | 1250 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5999884.6674 | 2108495.9392 | 37.7695204065663 | -122.443734660449 | (37.7695204065663, -122.443734660449) | 15 | 5 | 11 | 29492 | 9 | |||
9849 | 245126 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1256 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6000553.8142 | 2109283.0637 | 37.771719796222 | -122.44147660467 | (37.771719796222, -122.44147660467) | 15 | 5 | 11 | 29492 | 9 | |||
10003 | 264730 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 748 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2020 12:00:00 AM | 3 | 6002983.4557 | 2109619.25261 | 37.7727810060219 | -122.433096352422 | (37.7727810060219, -122.433096352422) | 15 | 5 | 11 | 29492 | 9 | |||
10007 | 264696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1285 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2020 12:00:00 AM | 3 | Width 0ft | Permit Number 782245 | 5999562.003 | 2108407.0589 | 37.7692579547157 | -122.444844350278 | (37.7692579547157, -122.444844350278) | 15 | 5 | 11 | 29492 | 9 | |
10078 | 51848 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 813 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | Permit Number 48072 | 5998616.0895613 | 2107512.49914502 | 37.7667476925096 | -122.44805178449 | (37.7667476925096, -122.44805178449) | 15 | 5 | 11 | 29492 | 9 | |||
10111 | 233339 | DPW Maintained 1 | Pinus thunbergii :: Japanese Black Pine 207 | 4750 17th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 5998413.40576 | 2105689.21442 | 37.7617298240875 | -122.448621500105 | (37.7617298240875, -122.448621500105) | 15 | 5 | 11 | 29492 | 9 | |||
10122 | 52665 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1200 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774794 | 6000815 | 2109317 | 37.77182785317 | -122.440575583218 | (37.77182785317, -122.440575583218) | 15 | 5 | 11 | 29492 | 9 | |
10231 | 228002 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1033 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998104.33903 | 2106671.65488 | 37.764409680579 | -122.449761234305 | (37.764409680579, -122.449761234305) | 15 | 5 | 11 | 29492 | 9 | |||
10362 | 237919 | DPW Maintained 1 | Grevillea robusta :: Silk Oak Tree 76 | 1182 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5998950.43455 | 2105771.37241 | 37.7619861021088 | -122.446770052318 | (37.7619861021088, -122.446770052318) | 15 | 5 | 5 | 29492 | 9 | |||
10372 | 260929 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 925 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5998050.49977 | 2107087.50026 | 37.7655484062222 | -122.449977421621 | (37.7655484062222, -122.449977421621) | 15 | 5 | 11 | 29492 | 9 | ||
10386 | 34217 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 110 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1997 12:00:00 AM | Permit Number 38032 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | |||
10391 | 261268 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1544 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5999025.8241 | 2109069.656 | 37.771046664384 | -122.446746640696 | (37.771046664384, -122.446746640696) | 15 | 5 | 11 | 29492 | 9 | ||||
10400 | 57447 | Permitted Site 7 | Tree(s) :: 17 | 1062 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1976 12:00:00 AM | Permit Number 16293 | 6001478.15691041 | 2109417.28569642 | 37.7721409530901 | -122.438288868495 | (37.7721409530901, -122.438288868495) | 15 | 5 | 11 | 29492 | 9 | |||
10440 | 246120 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1285 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1979 12:00:00 AM | 17 | Width 0ft | Permit Number 17675 | 5999565 | 2108371 | 37.7691591171027 | -122.444831391499 | (37.7691591171027, -122.444831391499) | 15 | 5 | 11 | 29492 | 9 | |
10488 | 260919 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 630 Cole St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997903.7812 | 2108434.36371 | 37.7692381539002 | -122.450581995995 | (37.7692381539002, -122.450581995995) | 15 | 5 | 11 | 29492 | 9 | |||
10494 | 62550 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 851 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22746 | 6002504.62213879 | 2109507.36231307 | 37.7724466097716 | -122.43474468697 | (37.7724466097716, -122.43474468697) | 15 | 5 | 11 | 29492 | 9 | ||
10609 | 262014 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 1591 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2020 12:00:00 AM | 3 | 3x3 | 5998968.26858 | 2109018.36861 | 37.7709025542262 | -122.446942035054 | (37.7709025542262, -122.446942035054) | 15 | 5 | 11 | 29492 | 9 | ||
10622 | 58722 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 73 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1986 12:00:00 AM | Permit Number 22987 | 6002575.33914396 | 2108761.52820117 | 37.7704027479761 | -122.434446734741 | (37.7704027479761, -122.434446734741) | 15 | 5 | 5 | 29492 | 9 | ||
10641 | 232039 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 50 Scott St | 12 | : | Tree | Private 2 | 9 | Width 3ft | 6002403.60195 | 2108716.39098 | 37.7702690623006 | -122.435037544552 | (37.7702690623006, -122.435037544552) | 15 | 5 | 5 | 29492 | 9 | |||
10675 | 247554 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 815 Buena Vista Ave West | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 2ft | 6000050.05446 | 2108365.18828 | 37.769170829105 | -122.443153202975 | (37.769170829105, -122.443153202975) | 15 | 5 | 11 | 29492 | 9 | |||
10684 | 236904 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 251 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997463.02622 | 2106112.38029 | 37.7628373418849 | -122.451938994804 | (37.7628373418849, -122.451938994804) | 15 | 5 | 11 | 29492 | 9 | |||
10744 | 260918 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 469 Frederick St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997465.89984 | 2107424.38822 | 37.7664399466471 | -122.452023719463 | (37.7664399466471, -122.452023719463) | 15 | 5 | 11 | 29492 | 9 | |||
10798 | 246087 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1245 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999728.2562 | 2108429.1654 | 37.7693281401256 | -122.444270879733 | (37.7693281401256, -122.444270879733) | 15 | 5 | 11 | 29492 | 9 | |||
10822 | 227716 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 810 Clayton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998663.42523 | 2107521.35267 | 37.7667747077998 | -122.447888696528 | (37.7667747077998, -122.447888696528) | 15 | 5 | 11 | 29492 | 9 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );