trees
194,517 rows sorted by Supervisor Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1775 | 196240 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 477 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010588.30864 | 2112340.27099 | 37.7806807348789 | -122.406982002622 | (37.7806807348789, -122.406982002622) | 14 | 2 | 9 | 28853 | 34 | |||
1778 | 262558 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
1791 | 202438 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 200 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015393.28137 | 2113192.42013 | 37.7832882498865 | -122.390418710082 | (37.7832882498865, -122.390418710082) | 6 | 2 | 9 | 28856 | 6 | |||
1800 | 189943 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 160 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014663.90287 | 2116268.03372 | 37.7916926905231 | -122.393157367813 | (37.7916926905231, -122.393157367813) | 12 | 2 | 9 | 28855 | 6 | |||
1830 | 85780 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009172.9261 | 2109780.9319 | 37.7735740897245 | -122.411697620327 | (37.7735740897245, -122.411697620327) | 8 | 2 | 9 | 28853 | 34 | ||
1880 | 261557 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 900 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011458 | 2112074 | 37.7799982447009 | -122.403954562266 | (37.7799982447009, -122.403954562266) | 14 | 2 | 9 | 28853 | 34 | ||||
1888 | 29108 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 765 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2018 12:59:00 PM | 3 | 3x3 | 6007194.65596 | 2113631.10211 | 37.7840345567841 | -122.418813878265 | (37.7840345567841, -122.418813878265) | 7 | 9 | 9 | 28858 | 36 | ||
1892 | 124739 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 | |||||
1893 | 202466 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6015364.08596 | 2113980.86874 | 37.7854515313193 | -122.390574827864 | (37.7854515313193, -122.390574827864) | 6 | 2 | 9 | 28856 | 6 | |||
1939 | 81851 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 234X Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009256.87157 | 2113623.19571 | 37.7841287454965 | -122.411678774977 | (37.7841287454965, -122.411678774977) | 14 | 10 | 9 | 28852 | 36 | |||
1943 | 262553 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
1962 | 122597 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
1970 | 260506 | DPW Maintained 1 | Tree(s) :: 17 | 289 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6009625.74334 | 2110365.68554 | 37.7752050776892 | -122.41017254363 | (37.7752050776892, -122.41017254363) | 8 | 2 | 9 | 28853 | 34 | ||||
1998 | 201212 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 698 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | Permit Number 770669 | 6012984.2928 | 2113511.8761 | 37.7840314756866 | -122.398775334072 | (37.7840314756866, -122.398775334072) | 6 | 2 | 9 | 28853 | 6 | ||
2007 | 188784 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015979.83831 | 2106803.95395 | 37.7657794514949 | -122.387943506912 | (37.7657794514949, -122.387943506912) | 14 | 3 | 9 | 310 | 20 | |||
2016 | 134492 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 199 Fulton St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6008187.17961 | 2111997.187 | 37.7796040530222 | -122.415264393538 | (37.7796040530222, -122.415264393538) | 7 | 10 | 9 | 28852 | 36 | |||
2027 | 32641 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/1999 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
2072 | 259693 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 30 Lafayette St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007347 | 2109367 | 37.7723349336637 | -122.417984438142 | (37.7723349336637, -122.417984438142) | 8 | 2 | 9 | 28853 | 19 | ||||
2079 | 263595 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
2082 | 195047 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 06th St | 2 | : | Tree | DPW 1 | 02/25/2002 12:00:00 AM | 3 | Width 3ft | Permit Number 42039 | 6011214.59355 | 2111232.18316 | 37.7776732094966 | -122.404737337955 | (37.7776732094966, -122.404737337955) | 14 | 2 | 9 | 28853 | 34 | |
2094 | 262557 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2106 | 193374 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 778 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008975.96564 | 2110229.86919 | 37.7747957152898 | -122.412410677425 | (37.7747957152898, -122.412410677425) | 8 | 2 | 9 | 28853 | 34 | |||
2135 | 187956 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014829.80215 | 2114536.31276 | 37.7869469986487 | -122.392462171218 | (37.7869469986487, -122.392462171218) | 6 | 2 | 9 | 28855 | 6 | |||
2143 | 35031 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 403 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/1998 12:00:00 AM | 16 | Permit Number 38603 | 6015552.5764 | 2114910.07467 | 37.7880133742625 | -122.389987634449 | (37.7880133742625, -122.389987634449) | 6 | 2 | 9 | 28855 | 6 | ||
2151 | 258135 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 988 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | 14 | 2 | 9 | 28853 | 34 | |||
2153 | 100644 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
2191 | 258156 | DPW Maintained 1 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1180 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6009302.702 | 2110851.89805 | 37.7765219905974 | -122.411324376274 | (37.7765219905974, -122.411324376274) | 8 | 2 | 9 | 28853 | 34 | |||
2207 | 26390 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1615X Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6007069.43005 | 2109322.62762 | 37.7721974718223 | -122.418941432593 | (37.7721974718223, -122.418941432593) | 8 | 2 | 9 | 28853 | 19 | |||
2213 | 261044 | Significant Tree 6 | Tilia cordata :: Littleleaf Linden 12 | 499x Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2019 12:00:00 AM | 3 | 3x3 | 6014038 | 2115260 | 37.7888900740934 | -122.39525236007 | (37.7888900740934, -122.39525236007) | 6 | 2 | 9 | 28855 | 6 | ||
2219 | 127642 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 30 Grove St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008019.48928 | 2111712.32042 | 37.7788124517715 | -122.41582433125 | (37.7788124517715, -122.41582433125) | 7 | 10 | 9 | 28852 | 36 | |||
2227 | 28919 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 230 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6009994.1526974 | 2111207.6693813 | 37.7775376115192 | -122.408957547154 | (37.7775376115192, -122.408957547154) | 8 | 2 | 9 | 28853 | 34 | ||
2240 | 131217 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 501 Jones St | 10 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6008903.544 | 2114366.06941 | 37.786148671371 | -122.412953707875 | (37.786148671371, -122.412953707875) | 5 | 10 | 9 | 28852 | 36 | |||
2258 | 264781 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 90x Guy Pl | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
2261 | 101055 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 760 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008077 | 2114493 | 37.7864507606031 | -122.415822330961 | (37.7864507606031, -122.415822330961) | 13 | 1 | 9 | 28858 | 36 | |||
2281 | 202367 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 399 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6015662.52454 | 2115317.40495 | 37.7891379072269 | -122.389635690147 | (37.7891379072269, -122.389635690147) | 6 | 2 | 9 | 28855 | 6 | |||
2305 | 251465 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 129 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008072 | 2112894 | 37.7820600122669 | -122.415726368353 | (37.7820600122669, -122.415726368353) | 7 | 10 | 9 | 28852 | 36 | ||||
2310 | 91800 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 530X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778971 | 6014458 | 2114030 | 37.785536126129 | -122.39371308036 | (37.785536126129, -122.39371308036) | 6 | 2 | 9 | 28855 | 6 | |
2327 | 108056 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 535X Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773596 | 6013160.27922 | 2115313.8399 | 37.7889890532579 | -122.398292953274 | (37.7889890532579, -122.398292953274) | 12 | 2 | 9 | 28855 | 6 | |
2341 | 50690 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015829.14658 | 2115263.74647 | 37.7889998109335 | -122.389055445747 | (37.7889998109335, -122.389055445747) | 6 | 2 | 9 | 28855 | 6 | |
2385 | 195415 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 214 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6014352.77069 | 2115553.8784 | 37.7897144967647 | -122.394183871097 | (37.7897144967647, -122.394183871097) | 6 | 2 | 9 | 28855 | 6 | |||
2390 | 143239 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 986 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6006984.4971 | 2114185.2189 | 37.7855441907656 | -122.41958028036 | (37.7855441907656, -122.41958028036) | 13 | 9 | 9 | 28858 | 36 | |||
2398 | 262570 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2413 | 201183 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 620 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6013416.1569 | 2113924.2034 | 37.7851876840649 | -122.397310155353 | (37.7851876840649, -122.397310155353) | 6 | 2 | 9 | 28855 | 6 | |||
2430 | 224109 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006481.46308 | 2109309.64111 | 37.7721286885111 | -122.420974342101 | (37.7721286885111, -122.420974342101) | 8 | 2 | 9 | 28853 | 19 | |||
2436 | 102404 | Undocumented 4 | Tree(s) :: 17 | 95X Harriet St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | 14 | 2 | 9 | 28853 | 34 | |||
2444 | 187616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/03/2013 12:00:00 AM | 3x3 | 6013035 | 2114021 | 37.78543223702 | -122.398635644163 | (37.78543223702, -122.398635644163) | 6 | 2 | 9 | 28855 | 6 | ||
2453 | 49617 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1626 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | 8 | 2 | 9 | 28853 | 19 | |||
2454 | 46118 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44476 | 6015543.8 | 2115940.8 | 37.7908430231508 | -122.390090033136 | (37.7908430231508, -122.390090033136) | 6 | 2 | 9 | 28855 | 6 | |||
2462 | 76446 | DPW Maintained 1 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 231 | 300 Spear St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015352.78819 | 2115567.57255 | 37.7898076305561 | -122.390724837491 | (37.7898076305561, -122.390724837491) | 6 | 2 | 9 | 28855 | 6 | |||
2468 | 14078 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1411 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007428.1196287 | 2110750.9276325 | 37.7761394345379 | -122.417801951992 | (37.7761394345379, -122.417801951992) | 8 | 2 | 9 | 28853 | 34 | |||
2469 | 260495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
2490 | 195264 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 771659 | 6011775.98455 | 2114888.82062 | 37.7877448438967 | -122.403052549837 | (37.7877448438967, -122.403052549837) | 12 | 2 | 9 | 28855 | 6 | |
2499 | 55575 | Permitted Site 7 | Tree(s) :: 17 | 622 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1972 12:00:00 AM | Permit Number 11546 | 6010538.99497753 | 2108399.45644768 | 37.7698574135988 | -122.40687477594 | (37.7698574135988, -122.40687477594) | 8 | 2 | 9 | 28853 | 19 | |||
2505 | 196318 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 323 11th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6008553.79261 | 2109149.29537 | 37.7718050135221 | -122.413794615322 | (37.7718050135221, -122.413794615322) | 8 | 2 | 9 | 28853 | 34 | |||
2514 | 130116 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008620.49903 | 2113131.73284 | 37.782743588087 | -122.413845626693 | (37.782743588087, -122.413845626693) | 7 | 10 | 9 | 28852 | 36 | |||
2552 | 42536 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 95 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42642 | 6006853.97359683 | 2109407.99798814 | 37.7724197439799 | -122.419692774816 | (37.7724197439799, -122.419692774816) | 8 | 2 | 9 | 28853 | 19 | ||
2558 | 134571 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 30 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007831.94374 | 2111562.01758 | 37.7783892110202 | -122.416462477559 | (37.7783892110202, -122.416462477559) | 7 | 9 | 9 | 28852 | 36 | |||
2589 | 262566 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2622 | 65282 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 445 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1989 12:00:00 AM | 1 | Permit Number 28089 | 6011007.15755 | 2112137.38618 | 37.7801470897487 | -122.405518702235 | (37.7801470897487, -122.405518702235) | 14 | 2 | 9 | 28853 | 34 | |
2628 | 190261 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 133 Stevenson St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 2ft | 6011936.19797 | 2114760.72734 | 37.7874020753891 | -122.402489228003 | (37.7874020753891, -122.402489228003) | 12 | 2 | 9 | 28855 | 6 | |||
2643 | 112356 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 333 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009373.44227 | 2114078.66133 | 37.7853858834919 | -122.411307667026 | (37.7853858834919, -122.411307667026) | 14 | 10 | 9 | 28852 | 36 | |||
2651 | 116177 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 94X Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 2x2 | 6013088.14132 | 2114773.98934 | 37.7875027311189 | -122.3985046459 | (37.7875027311189, -122.3985046459) | 12 | 2 | 9 | 28855 | 6 | |||
2662 | 51421 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 655 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2004 12:00:00 AM | 3 | Permit Number 47745 | 6013248.9695 | 2110513.26704 | 37.7758127253049 | -122.397649253932 | (37.7758127253049, -122.397649253932) | 6 | 2 | 9 | 28856 | 34 | |
2668 | 85700 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 918 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010976.81813 | 2112473.48761 | 37.7810682491478 | -122.405647340366 | (37.7810682491478, -122.405647340366) | 14 | 2 | 9 | 28853 | 34 | ||
2672 | 134477 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Larkin St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 6007817.15292 | 2111847.04957 | 37.7791710087729 | -122.416533840565 | (37.7791710087729, -122.416533840565) | 7 | 9 | 9 | 28852 | 36 | |||
2693 | 72299 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 790 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011682.79959 | 2109646.37516 | 37.7733451034182 | -122.403006076485 | (37.7733451034182, -122.403006076485) | 14 | 2 | 9 | 28853 | 34 | |||
2733 | 107738 | Undocumented 4 | Tree(s) :: 17 | 155x HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774227 | 6007127.8 | 2111172.9 | 37.7772811641179 | -122.41887077508 | (37.7772811641179, -122.41887077508) | 7 | 9 | 9 | 28852 | 36 | |
2747 | 129970 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 245 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009400.62978 | 2113906.25304 | 37.7849140164063 | -122.411201422913 | (37.7849140164063, -122.411201422913) | 14 | 10 | 9 | 28852 | 36 | |||
2754 | 198688 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 165 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008649.71032 | 2110465.86433 | 37.7754253882045 | -122.413555960437 | (37.7754253882045, -122.413555960437) | 8 | 2 | 9 | 28853 | 34 | |||
2803 | 39877 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
2804 | 115921 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777610 | 6013791.45387 | 2116146.74475 | 37.7913111540478 | -122.396167553395 | (37.7913111540478, -122.396167553395) | 12 | 2 | 9 | 28855 | 6 | |
2814 | 191330 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6014815.79386 | 2110104.24777 | 37.7747767728644 | -122.392200554832 | (37.7747767728644, -122.392200554832) | 14 | 3 | 9 | 310 | ||||
2841 | 9956 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 155 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 12 | 4X4 | 6007076.05273 | 2111529.8614 | 37.7782583803491 | -122.419075111548 | (37.7782583803491, -122.419075111548) | 7 | 9 | 9 | 28852 | 36 | |||
2844 | 45194 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 434 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/2001 12:00:00 AM | 6 | Permit Number 44039 | 6008463.06426 | 2114024.06162 | 37.7851848652278 | -122.414453446982 | (37.7851848652278, -122.414453446982) | 7 | 10 | 9 | 28852 | 36 | |
2857 | 99536 | DPW Maintained 1 | Tree(s) :: 17 | 188 Spear St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5x9 | 6014774.7 | 2116168.9 | 37.7914266467329 | -122.392767069159 | (37.7914266467329, -122.392767069159) | 12 | 2 | 9 | 28855 | 6 | ||||
2882 | 100182 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 230 Ritch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6013808.29227 | 2112170.33848 | 37.7803937971776 | -122.39583053966 | (37.7803937971776, -122.39583053966) | 6 | 2 | 9 | 28856 | 34 | ||||
2886 | 78623 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 440 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6008334.45492 | 2113493.19738 | 37.7837200144185 | -122.414860811987 | (37.7837200144185, -122.414860811987) | 7 | 10 | 9 | 28858 | 36 | |||
2888 | 13930 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1095 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/1994 12:00:00 AM | 12 | 4X4 | 6009061.9861 | 2112312.9703 | 37.7805202452284 | -122.412260375327 | (37.7805202452284, -122.412260375327) | 14 | 2 | 9 | 28853 | 34 | ||
2898 | 191530 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016138.64503 | 2107209.62915 | 37.7669021444474 | -122.387422526024 | (37.7669021444474, -122.387422526024) | 14 | 3 | 9 | 310 | 20 | |||
2900 | 34181 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 111 Gilbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1997 12:00:00 AM | 12 | Permit Number 38007 | 6011922.99653 | 2109561.23009 | 37.7731247245485 | -122.402169209655 | (37.7731247245485, -122.402169209655) | 14 | 2 | 9 | 28853 | 34 | |
2913 | 264905 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
2925 | 28992 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 447 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6009491 | 2108895 | 37.7711593648098 | -122.410534778589 | (37.7711593648098, -122.410534778589) | 8 | 2 | 9 | 28853 | 34 | ||
2938 | 193145 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 555 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013012.05406 | 2115204.53124 | 37.7886806595304 | -122.398798121635 | (37.7886806595304, -122.398798121635) | 12 | 2 | 9 | 28855 | 6 | |||
2955 | 13425 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 25 | 4x4 | 6014152.78687 | 2117194.52143 | 37.7942082021958 | -122.394990759026 | (37.7942082021958, -122.394990759026) | 12 | 2 | 9 | 28855 | 6 | ||
2968 | 108902 | Permitted Site 7 | Ficus laurel :: 247 | 33 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 4x6 | 6006450.1 | 2109317.2 | 37.7721476754667 | -122.421083366581 | (37.7721476754667, -122.421083366581) | 8 | 2 | 9 | 28853 | 19 | |||
2972 | 74792 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 749 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6007023.88187 | 2113548.27609 | 37.783797519769 | -122.419398818026 | (37.783797519769, -122.419398818026) | 7 | 9 | 9 | 28858 | 36 | |||
2982 | 100269 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Federal St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 1x1 | 6015149.19988 | 2113471.58342 | 37.7840412261692 | -122.391282662663 | (37.7840412261692, -122.391282662663) | 6 | 2 | 9 | 28856 | 6 | |||
2995 | 202498 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 85 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015682.27104 | 2112499.834 | 37.7814025909853 | -122.389370531319 | (37.7814025909853, -122.389370531319) | 6 | 2 | 9 | 28856 | 20 | |||
3004 | 202458 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6015309.25216 | 2113889.9179 | 37.7851987588479 | -122.390758179856 | (37.7851987588479, -122.390758179856) | 6 | 2 | 9 | 28856 | 6 | |||
3016 | 190529 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 21 Clarence Pl | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6014722.79424 | 2111890.37318 | 37.7796759079438 | -122.392647234607 | (37.7796759079438, -122.392647234607) | 6 | 2 | 9 | 28856 | 6 | |||
3022 | 264768 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
3063 | 192918 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009145.73706 | 2109144.68728 | 37.7718255855015 | -122.411746706156 | (37.7718255855015, -122.411746706156) | 8 | 2 | 9 | 28853 | 34 | |||
3134 | 190600 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015217.08572 | 2107526.40267 | 37.7677208521577 | -122.390632216307 | (37.7677208521577, -122.390632216307) | 14 | 3 | 9 | 310 | 20 | |||
3167 | 199344 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1801 03rd St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 4ft | 6015727.94816 | 2106771.64308 | 37.7656767749832 | -122.388812492998 | (37.7656767749832, -122.388812492998) | 14 | 3 | 9 | 310 | 29 | ||
3170 | 38792 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 655 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 3 | Permit Number 43810 | 6012704.44378 | 2111400.47389 | 37.7782184558633 | -122.399595224034 | (37.7782184558633, -122.399595224034) | 6 | 2 | 9 | 28856 | 34 | |
3180 | 191527 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016025.61335 | 2107205.30438 | 37.7668840087222 | -122.387813186138 | (37.7668840087222, -122.387813186138) | 14 | 3 | 9 | 310 | 20 | |||
3200 | 196841 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 385 Channel | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6014074.004 | 2109042.91847 | 37.7718213847826 | -122.39469223806 | (37.7718213847826, -122.39469223806) | 14 | 3 | 9 | 310 | 20 | |||
3205 | 259817 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850x Bryant St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6011306 | 2110409 | 37.7754180474052 | -122.404363174614 | (37.7754180474052, -122.404363174614) | 14 | 2 | 9 | 28853 | 34 | ||||
3248 | 85701 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 926 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010962.65697 | 2112458.52521 | 37.781026374014 | -122.405695276931 | (37.781026374014, -122.405695276931) | 14 | 2 | 9 | 28853 | 34 | ||
3270 | 30609 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 365 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 16 | Permit Number 34572 | 6008561.72189 | 2108643.78999 | 37.7704174594375 | -122.413731425365 | (37.7704174594375, -122.413731425365) | 8 | 2 | 9 | 28853 | 19 |
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) );