trees
163,064 rows where qCaretaker_id = 2 sorted by Police 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1557 | 33639 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 440 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 5 | Permit Number 37734 | 6005272.3664 | 2110799.1387 | 37.7761502580876 | -122.425262720434 | (37.7761502580876, -122.425262720434) | 7 | 9 | 11 | 28852 | 10 | |
| 1590 | 130502 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1971 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999816.57477 | 2121214.69005 | 37.8044388979007 | -122.444884593948 | (37.8044388979007, -122.444884593948) | 13 | 9 | 1 | 57 | 17 | |||
| 1592 | 262226 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1970 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6002649 | 2114114 | 37.7851034789316 | -122.434574718683 | (37.7851034789316, -122.434574718683) | 13 | 9 | 11 | 29490 | 13 | ||||
| 1614 | 140208 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 708 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003569 | 2110758 | 37.7759409231905 | -122.431152184499 | (37.7759409231905, -122.431152184499) | 7 | 9 | 11 | 29492 | 10 | |||
| 1627 | 35149 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 11 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38681 | 6004664.75137838 | 2109286.2995173 | 37.7719620248453 | -122.427256837171 | (37.7719620248453, -122.427256837171) | 7 | 9 | 11 | 28852 | 10 | ||
| 1656 | 125137 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2645 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000115.81749 | 2117703.18818 | 37.7948143227728 | -122.443596633488 | (37.7948143227728, -122.443596633488) | 13 | 9 | 1 | 57 | 27 | |||
| 1667 | 101664 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
| 1690 | 52430 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2536 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 12 | Permit Number 48545 | 6002701.73302 | 2117006.28973 | 37.7930479607542 | -122.434599161948 | (37.7930479607542, -122.434599161948) | 13 | 9 | 1 | 29490 | 27 | |
| 1724 | 134353 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 826 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006643.13761 | 2113330.8233 | 37.7831789957579 | -122.420700610947 | (37.7831789957579, -122.420700610947) | 7 | 9 | 9 | 28858 | 36 | |||
| 1727 | 249457 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 2 | : | Tree | Private 2 | 11 | Width 4ft | 6006319.82833 | 2113698.46294 | 37.7841702168319 | -122.421845255461 | (37.7841702168319, -122.421845255461) | 7 | 9 | 11 | 28858 | 41 | |||
| 1730 | 121323 | Undocumented 4 | Tree(s) :: 17 | 3699X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003556 | 2121083 | 37.8042900105203 | -122.431934584375 | (37.8042900105203, -122.431934584375) | 13 | 9 | 1 | 28858 | 17 | ||||
| 1746 | 136062 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1776 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006341.69714 | 2116340.45076 | 37.7914256952996 | -122.421957338886 | (37.7914256952996, -122.421957338886) | 13 | 9 | 10 | 28858 | 21 | |||
| 1748 | 56640 | Permitted Site 7 | Tree(s) :: 17 | 2016 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004277.89575757 | 2115357.17634953 | 37.7886092629589 | -122.429027916831 | (37.7886092629589, -122.429027916831) | 13 | 9 | 11 | 29490 | 27 | |||||
| 1765 | 73918 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 740 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004497.3871 | 2111109.5855 | 37.776958856214 | -122.42796571067 | (37.776958856214, -122.42796571067) | 7 | 9 | 11 | 28852 | 10 | |||
| 1808 | 134289 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2416 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6004999.06299 | 2117994.49764 | 37.7958914767778 | -122.426720670937 | (37.7958914767778, -122.426720670937) | 13 | 9 | 1 | 28858 | 27 | |||
| 1811 | 258532 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1565 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 777683 | 6006695.00356 | 2117330.6469 | 37.7941644464503 | -122.420805231935 | (37.7941644464503, -122.420805231935) | 13 | 9 | 10 | 28858 | 32 | |
| 1828 | 98097 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 81 Frank Norris St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006875.6654 | 2115508.14993 | 37.7891705031567 | -122.420050723983 | (37.7891705031567, -122.420050723983) | 13 | 9 | 10 | 28858 | 21 | |||
| 1889 | 259158 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x | 6004817 | 2110376 | 37.7749626863145 | -122.426807815207 | (37.7749626863145, -122.426807815207) | 7 | 9 | 11 | 28852 | 10 | ||||
| 1913 | 140032 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 855 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005092.0233 | 2111947.5572 | 37.7792933441417 | -122.4259683453 | (37.7792933441417, -122.4259683453) | 7 | 9 | 11 | 28852 | 41 | |||
| 1925 | 250092 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1698 Gough St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6005353.59952 | 2115427.24795 | 37.7888624934521 | -122.425311128409 | (37.7888624934521, -122.425311128409) | 13 | 9 | 1 | 28858 | 41 | |||
| 1966 | 61296 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2360 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1986 12:00:00 AM | 9 | Permit Number 23055 | 6006748.00387 | 2119357.01746 | 37.7997313381808 | -122.420765770421 | (37.7997313381808, -122.420765770421) | 5 | 9 | 1 | 28858 | 32 | |
| 1990 | 132531 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2201 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000159.7629 | 2120220.59264 | 37.8017289527983 | -122.443625508009 | (37.8017289527983, -122.443625508009) | 13 | 9 | 1 | 57 | 17 | |||
| 2005 | 23894 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1581 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:37:00 AM | 3 | 3X3 | 6003529.5219 | 2114142.2135 | 37.7852308919409 | -122.431530405312 | (37.7852308919409, -122.431530405312) | 13 | 9 | 11 | 29490 | 13 | ||
| 2011 | 264734 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1364 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006427.83864 | 2119405.514 | 37.7998464469137 | -122.42187710854 | (37.7998464469137, -122.42187710854) | 13 | 9 | 1 | 28858 | 32 | |||||
| 2052 | 13108 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1557 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x3 | 6004929.5061 | 2119810.12 | 37.8008727786968 | -122.427090735634 | (37.8008727786968, -122.427090735634) | 13 | 9 | 1 | 57 | 17 | |||
| 2062 | 112894 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1x WEBSTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004219 | 2108568 | 37.7699645303419 | -122.428747509741 | (37.7699645303419, -122.428747509741) | 7 | 9 | 5 | 28862 | 10 | ||||
| 2098 | 113076 | DPW Maintained 1 | Howea forsteriana :: Kentia Palm 214 | 3456 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2015 12:00:00 AM | 6 | 3x3 | Permit Number 775955 | 5999268.84985 | 2120685.32695 | 37.8029541360916 | -122.446741924202 | (37.8029541360916, -122.446741924202) | 13 | 9 | 1 | 57 | 17 | |
| 2104 | 132472 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2901 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6001487.88028 | 2118402.43157 | 37.7968124185064 | -122.438899249622 | (37.7968124185064, -122.438899249622) | 13 | 9 | 1 | 57 | 17 | |||
| 2115 | 125373 | DPW Maintained 1 | Acer palmatum :: Japanese Maple 216 | 2820 Van Ness Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6005714.14628 | 2120095.1224 | 37.8016996609768 | -122.424395829926 | (37.8016996609768, -122.424395829926) | 5 | 9 | 1 | 28858 | 32 | |||
| 2121 | 110341 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 564 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6005076.8079 | 2111304.1554 | 37.7775258606118 | -122.425975168518 | (37.7775258606118, -122.425975168518) | 7 | 9 | 11 | 28852 | 10 | |||
| 2137 | 134250 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1851 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006058.4702 | 2116853.96653 | 37.7928197038277 | -122.422973813809 | (37.7928197038277, -122.422973813809) | 13 | 9 | 1 | 28858 | 27 | |||
| 2152 | 33675 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 469 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 13 | Permit Number 37757 | 6005116.23557125 | 2111084.96150687 | 37.7769262359606 | -122.425823168919 | (37.7769262359606, -122.425823168919) | 7 | 9 | 11 | 28852 | 10 | |
| 2172 | 53666 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1630 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/1969 12:00:00 AM | 17 | 3x3 | Permit Number 772472 | 6006654.5213 | 2116532.6022 | 37.7919709328888 | -122.420888619402 | (37.7919709328888, -122.420888619402) | 13 | 9 | 10 | 28858 | 21 |
| 2209 | 134782 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2222 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006396 | 2118554 | 37.7975066091486 | -122.421926761206 | (37.7975066091486, -122.421926761206) | 13 | 9 | 10 | 28858 | 32 | |||
| 2222 | 20236 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 1750X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/1992 12:00:00 AM | 6 | 4X4 | 6002603.6550052 | 2114233.7432168 | 37.7854296891778 | -122.434740163706 | (37.7854296891778, -122.434740163706) | 13 | 9 | 11 | 29490 | 13 | ||
| 2251 | 143510 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2026 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2006 12:00:00 AM | 14 | Width 0ft | Permit Number 48982 | 6003323.1573 | 2118630.9053 | 37.797543994409 | -122.432565097779 | (37.797543994409, -122.432565097779) | 13 | 9 | 1 | 57 | 17 | |
| 2257 | 134060 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2434 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6001939.59837 | 2117387.98791 | 37.7940527103301 | -122.43726352939 | (37.7940527103301, -122.43726352939) | 13 | 9 | 1 | 57 | 27 | |||
| 2280 | 116028 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1500 PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006937 | 2117734 | 37.7952855901943 | -122.419996533467 | (37.7952855901943, -122.419996533467) | 13 | 9 | 10 | 28858 | 32 | ||||
| 2288 | 50724 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3110 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2004 12:00:00 AM | 2 | Permit Number 47275 | 6001439.94101 | 2119110.04202 | 37.798752603299 | -122.439115871123 | (37.798752603299, -122.439115871123) | 13 | 9 | 1 | 57 | 17 | |
| 2294 | 84947 | Permitted Site 7 | Tree(s) :: 17 | 1812 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003475 | 2114918 | 37.7873579154126 | -122.431774444579 | (37.7873579154126, -122.431774444579) | 13 | 9 | 11 | 29490 | 27 | |||||
| 2317 | 129136 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2500 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 5999820.13203 | 2119534.7646 | 37.7998264765557 | -122.444751458338 | (37.7998264765557, -122.444751458338) | 13 | 9 | 1 | 57 | 17 | |||
| 2345 | 59877 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2125 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1981 12:00:00 AM | 11 | Permit Number 19342 | 6002756.67005 | 2118848.34018 | 37.7981088730742 | -122.434540847196 | (37.7981088730742, -122.434540847196) | 13 | 9 | 1 | 57 | 17 | |
| 2346 | 114557 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2775 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5999783.32875 | 2117736.28966 | 37.7948862424707 | -122.444749467237 | (37.7948862424707, -122.444749467237) | 13 | 9 | 1 | 57 | 27 | |||
| 2350 | 132920 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2311 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6002441.57111 | 2117401.95011 | 37.7941195695148 | -122.435527653476 | (37.7941195695148, -122.435527653476) | 13 | 9 | 1 | 29490 | 27 | |||
| 2353 | 229453 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004612.82375 | 2110259.96619 | 37.7746325395952 | -122.427505836641 | (37.7746325395952, -122.427505836641) | 7 | 9 | 11 | 28852 | 10 | |||
| 2376 | 57631 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 724 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1976 12:00:00 AM | 8 | Permit Number 16529 | 6004511.94268 | 2110995.61836 | 37.7766467538829 | -122.427907235555 | (37.7766467538829, -122.427907235555) | 7 | 9 | 11 | 28852 | 10 | |
| 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 | |||
| 2395 | 224762 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 301 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004982.47318 | 2110039.87008 | 37.7740491098102 | -122.426211472077 | (37.7740491098102, -122.426211472077) | 7 | 9 | 11 | 28852 | 10 | |||
| 2422 | 80046 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2325 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6001817.74148 | 2118715.85745 | 37.7976917657091 | -122.437780314931 | (37.7976917657091, -122.437780314931) | 13 | 9 | 1 | 57 | 17 | |||
| 2426 | 100409 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 201 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006409.6 | 2110870.2 | 37.7764095571607 | -122.421333763494 | (37.7764095571607, -122.421333763494) | 7 | 9 | 11 | 28852 | 10 | |||
| 2435 | 129307 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2363 Larkin St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6006689.73885 | 2119362.09742 | 37.7997420023389 | -122.420967750079 | (37.7997420023389, -122.420967750079) | 13 | 9 | 1 | 28858 | 32 | |||
| 2440 | 79187 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 45 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2019 12:00:00 AM | 3 | 3x3 | Permit Number 50829 | 6001057.44461 | 2119906.39281 | 37.8009174000823 | -122.440496575066 | (37.8009174000823, -122.440496575066) | 13 | 9 | 1 | 57 | 17 | |
| 2456 | 260910 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 241 Laussat St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6003564.7514 | 2109147.66361 | 37.7715190947724 | -122.431051921008 | (37.7715190947724, -122.431051921008) | 15 | 9 | 11 | 29492 | 10 | ||||
| 2465 | 133092 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1380 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | Width 3ft | 6006306.20218 | 2119734.15962 | 37.800741963924 | -122.422321379938 | (37.800741963924, -122.422321379938) | 13 | 9 | 1 | 28858 | 32 | ||
| 2484 | 20118 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 875X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1992 12:00:00 AM | 12 | 2X2 | 6003233.15229 | 2110304.12624 | 37.774675660821 | -122.432281545934 | (37.774675660821, -122.432281545934) | 15 | 9 | 11 | 29492 | 10 | ||
| 2485 | 59880 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2139 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1981 12:00:00 AM | 10 | Permit Number 19345 | 6002701.87127 | 2118840.74506 | 37.7980849079605 | -122.434729923369 | (37.7980849079605, -122.434729923369) | 13 | 9 | 1 | 57 | 17 | |
| 2527 | 127017 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2859 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999232.73482 | 2118356.53874 | 37.7965578456306 | -122.446699242399 | (37.7965578456306, -122.446699242399) | 13 | 9 | 1 | 57 | 17 | |||
| 2536 | 73723 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2243 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000588.661 | 2119935.00811 | 37.8009692657904 | -122.442120815418 | (37.8009692657904, -122.442120815418) | 13 | 9 | 1 | 57 | 17 | |||
| 2546 | 23472 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2356 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | Permit Number 782620 | 6005919.56056 | 2118542.30149 | 37.7974476069742 | -122.423574537547 | (37.7974476069742, -122.423574537547) | 13 | 9 | 10 | 28858 | 32 | |
| 2553 | 140071 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 601X Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005402 | 2111410 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 2584 | 249512 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1233 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006339.71107 | 2114788.40183 | 37.7871640419323 | -122.42185391595 | (37.7871640419323, -122.42185391595) | 13 | 9 | 1 | 28858 | 41 | |||
| 2593 | 19154 | Section 806 (d) 5 | Pittosporum undulatum :: Victorian Box 36 | 64 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774356 | 6003450.27402 | 2107953.58185 | 37.7682339504649 | -122.431362651168 | (37.7682339504649, -122.431362651168) | 15 | 9 | 5 | 28862 | 3 | |
| 2595 | 71280 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2046 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6x7 | 6003095.65483 | 2119286.01418 | 37.7993298493627 | -122.433399154261 | (37.7993298493627, -122.433399154261) | 13 | 9 | 1 | 57 | 17 | ||
| 2601 | 71109 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1280 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004811.8428 | 2113348.9801 | 37.7831254666613 | -122.427037449556 | (37.7831254666613, -122.427037449556) | 7 | 9 | 11 | 28858 | 41 | |||
| 2616 | 139137 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1750 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003531.4353 | 2113968.7391 | 37.7847546833549 | -122.431511396859 | (37.7847546833549, -122.431511396859) | 13 | 9 | 11 | 29490 | 13 | |||
| 2623 | 126453 | DPW Maintained 1 | Dicksonia antarctica :: Soft Tree Fern 239 | 1580 Beach St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6002632.74953 | 2121315.04955 | 37.8048747750075 | -122.435146170078 | (37.8048747750075, -122.435146170078) | 13 | 9 | 1 | 57 | 17 | |||
| 2630 | 47383 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1515 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | Permit Number 46367 | 6006307.07862293 | 2118296.63950756 | 37.7967949468883 | -122.422216159163 | (37.7967949468883, -122.422216159163) | 13 | 9 | 10 | 28858 | 32 | |||
| 2650 | 133366 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1800 Chestnut St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6003170.63079 | 2119991.74188 | 37.8012718471789 | -122.433190164415 | (37.8012718471789, -122.433190164415) | 13 | 9 | 1 | 57 | 17 | |||
| 2653 | 100053 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
| 2659 | 122325 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1310 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6006613.81531 | 2119776.94391 | 37.8008767857834 | -122.421259948789 | (37.8008767857834, -122.421259948789) | 13 | 9 | 1 | 28858 | 32 | |||
| 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 | |||
| 2681 | 225302 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 6 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003467 | 2108426 | 37.7695320434676 | -122.431338524707 | (37.7695320434676, -122.431338524707) | 15 | 9 | 5 | 29492 | 10 | |||
| 2701 | 246408 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 153 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003537.9846 | 2107412.8853 | 37.7667542995576 | -122.431020673856 | (37.7667542995576, -122.431020673856) | 7 | 9 | 5 | 28862 | 3 | |||
| 2709 | 140325 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1455 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004557.9993 | 2113847.3125 | 37.7844794061151 | -122.427951167196 | (37.7844794061151, -122.427951167196) | 13 | 9 | 11 | 29490 | 41 | |||
| 2714 | 113322 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004079.74050315 | 2108375.213269 | 37.7694273021614 | -122.42921545709 | (37.7694273021614, -122.42921545709) | 7 | 9 | 5 | 28862 | 3 | ||||
| 2723 | 140583 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 949 FILLMORE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6003424.6737 | 2111485.9504 | 37.7779315149131 | -122.431703431668 | (37.7779315149131, -122.431703431668) | 15 | 9 | 11 | 29492 | 41 | |||
| 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 | |
| 2751 | 32002 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2652 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1995 12:00:00 AM | 5x5 | Permit Number 35399 | 6000302.11365106 | 2118206.59769697 | 37.7962071755692 | -122.442988194102 | (37.7962071755692, -122.442988194102) | 13 | 9 | 1 | 57 | 17 | ||
| 2769 | 81793 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 435 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | 6005759.2342 | 2111006.7416 | 37.7767477786156 | -122.423593274768 | (37.7767477786156, -122.423593274768) | 7 | 9 | 11 | 28852 | 10 | ||
| 2813 | 33314 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1229 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 18 | Permit Number 37460 | 6005325.69823 | 2120590.66128 | 37.8030383405174 | -122.425775331487 | (37.8030383405174, -122.425775331487) | 13 | 9 | 1 | 28858 | 17 | |
| 2856 | 64671 | Permitted Site 7 | Tree(s) :: 17 | 825 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/1988 12:00:00 AM | Permit Number 25617 | 6006551.01917293 | 2113304.1780681 | 37.7831006421796 | -122.421017411704 | (37.7831006421796, -122.421017411704) | 7 | 9 | 11 | 28858 | 41 | |||
| 2874 | 261577 | DPW Maintained 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1101 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2014 12:00:00 AM | Width 0ft | 6003302 | 2112170 | 37.779802790384 | -122.432176666415 | (37.779802790384, -122.432176666415) | 15 | 9 | 11 | 29490 | 41 | |||
| 2878 | 124826 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 56 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6001759.52883 | 2120853.50314 | 37.8035578671766 | -122.438134955373 | (37.8035578671766, -122.438134955373) | 13 | 9 | 1 | 57 | 17 | |||
| 2880 | 133619 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 220 Richardson Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5999075.60684 | 2119862.33326 | 37.8006833766814 | -122.447351372295 | (37.8006833766814, -122.447351372295) | 13 | 9 | 1 | 57 | 17 | |||
| 2884 | 46077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 814 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2001 12:00:00 AM | Permit Number 44458 | 6003949.63841524 | 2110800.90118746 | 37.7760802817088 | -122.429838518249 | (37.7760802817088, -122.429838518249) | 7 | 9 | 11 | 29492 | 10 | |||
| 2928 | 261272 | DPW Maintained 1 | Photinia fraseri :: Photinia Tree 225 | 500 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1995 12:00:00 AM | Width 0ft | 6004944 | 2111107 | 37.7769770135596 | -122.426420554341 | (37.7769770135596, -122.426420554341) | 7 | 9 | 11 | 28852 | 10 | |||
| 2956 | 139431 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005398.6042 | 2111220.8061 | 37.7773151849796 | -122.424856035409 | (37.7773151849796, -122.424856035409) | 7 | 9 | 11 | 28852 | 10 | |||
| 2959 | 141420 | DPW Maintained 1 | :: 45 | 550 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004578.5445 | 2111046.5078 | 37.7767902513835 | -122.427680466931 | (37.7767902513835, -122.427680466931) | 7 | 9 | 11 | 28852 | 10 | |||
| 2969 | 47721 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2325 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | 8 | Permit Number 45805 | 6001839.98608 | 2118371.66878 | 37.7967479784971 | -122.437678679828 | (37.7967479784971, -122.437678679828) | 13 | 9 | 1 | 57 | 17 | |
| 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 | |||
| 2977 | 32167 | Permitted Site 7 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 434 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35509 | 6004474.73230352 | 2109832.86168631 | 37.773452003453 | -122.427953081401 | (37.773452003453, -122.427953081401) | 7 | 9 | 11 | 28852 | 10 | ||
| 3065 | 131818 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 245 Alhambra St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001145.96871 | 2120047.09018 | 37.8013087580395 | -122.440200340178 | (37.8013087580395, -122.440200340178) | 13 | 9 | 1 | 57 | 17 | |||
| 3077 | 142372 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1265 ELLIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6004876.9032 | 2113304.0357 | 37.7830057392094 | -122.426809165036 | (37.7830057392094, -122.426809165036) | 7 | 9 | 11 | 28858 | 41 | |||
| 3080 | 42712 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1451 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42724 | 6006618.85507529 | 2118340.07511889 | 37.7969317909654 | -122.4211404244 | (37.7969317909654, -122.4211404244) | 13 | 9 | 10 | 28858 | 32 | ||
| 3104 | 71279 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2922 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004338.76046 | 2119216.84729 | 37.7992103816196 | -122.429092640025 | (37.7992103816196, -122.429092640025) | 13 | 9 | 1 | 57 | 17 | |||
| 3137 | 66513 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1411 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/1991 12:00:00 AM | 4 | Permit Number 29678 | 6006713.5616 | 2115771.7123 | 37.7898850457115 | -122.420630301385 | (37.7898850457115, -122.420630301385) | 13 | 9 | 10 | 28858 | 21 | |
| 3139 | 130835 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2707 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6003954.12542 | 2118159.05361 | 37.7962841720447 | -122.430348098084 | (37.7962841720447, -122.430348098084) | 13 | 9 | 1 | 57 | 17 | |||
| 3207 | 111734 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2.5x3 | 6005865.3001 | 2111209.4164 | 37.777310260787 | -122.423240771205 | (37.777310260787, -122.423240771205) | 7 | 9 | 11 | 28852 | 10 | |||
| 3209 | 130852 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004581.36981 | 2117470.78611 | 37.7944298743033 | -122.42812862796 | (37.7944298743033, -122.42812862796) | 13 | 9 | 1 | 28858 | 27 |
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) );