Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 724 | 724 | 25734 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013899.49111 | 2118360.1858599996 | 37.7973947538281 | -122.395948920127 | (37.7973947538281, -122.395948920127) | ||
| 726 | 726 | 44958 | Permitted Site 1 | Tree(s) :: 17 | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 728 | 728 | 2813 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009225.04881 | 2116342.3210299998 | 37.7915930222591 | -122.41198109107599 | (37.7915930222591, -122.411981091076) | |||
| 729 | 729 | 48266 | Permitted Site 1 | Tree(s) :: 17 | 130 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 730 | 730 | 195047 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 06th St | 2 | : 4 | Tree 1 | DPW 2 | 03/26/2005 12:00:00 AM | 3 | Width 3ft | Permit Number 42039 | 6011214.59355 | 2111232.18316 | 37.777673209496605 | -122.404737337955 | (37.7776732094966, -122.404737337955) | |
| 734 | 734 | 173936 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | |
| 736 | 736 | 231004 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 660 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 7 | Width 3ft | Permit Number 46247 | 6008974.97232 | 2105068.82517 | 37.7606246283465 | -122.412049301945 | (37.7606246283465, -122.412049301945) | |
| 739 | 739 | 13244 | Permitted Site 1 | Tristania conferta :: 79 | 2353 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2012 12:00:00 AM | 3 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.44006524578501 | (37.7992300540772, -122.440065245785) | ||
| 741 | 741 | 9506 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 935 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2002 12:00:00 AM | 3 | 3X3 | 6005056.2117 | 2112292.3227 | 37.7802379614696 | -122.426116783326 | (37.7802379614696, -122.426116783326) | ||
| 742 | 742 | 35926 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2660 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773492 | 6001423.81293 | 2116968.31873 | 37.7928710739952 | -122.43901810580799 | (37.7928710739952, -122.439018105808) | |
| 743 | 743 | 224663 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008964.71968 | 2105285.1997599998 | 37.761218168313704 | -122.412100053373 | (37.7612181683137, -122.412100053373) | |
| 744 | 744 | 231007 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 660 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 7 | Width 3ft | Permit Number 46247 | 6008969.23961 | 2105134.95103 | 37.7608058732193 | -122.412073802181 | (37.7608058732193, -122.412073802181) | |
| 751 | 751 | 224664 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008962.07625 | 2105304.40117 | 37.761270742678704 | -122.412110552966 | (37.7612707426787, -122.412110552966) | |
| 755 | 755 | 224665 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008961.65131 | 2105333.13094 | 37.7613496042185 | -122.412114053139 | (37.7613496042185, -122.412114053139) | |
| 756 | 756 | 231006 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 660 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 9 | Width 3ft | Permit Number 46247 | 6008972.79201 | 2105110.692 | 37.760739462776606 | -122.41205980151199 | (37.7607394627766, -122.412059801512) | |
| 758 | 758 | 231035 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3050 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 7 | Width 3ft | Permit Number 46247 | 6008913.51781 | 2104995.63577 | 37.7604202187369 | -122.41225667301799 | (37.7604202187369, -122.412256673018) | |
| 765 | 765 | 231003 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 660 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 9 | Width 3ft | Permit Number 46247 | 6008977.98805 | 2105043.06556 | 37.760554067537704 | -122.412037051387 | (37.7605540675377, -122.412037051387) | |
| 768 | 768 | 13057 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 566 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2014 12:00:00 AM | 3 | 2x2 | 6009630.8999 | 2120542.6321 | 37.8031488074681 | -122.410873631329 | (37.8031488074681, -122.410873631329) | ||
| 771 | 771 | 224662 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008966.3106 | 2105264.00424 | 37.7611600595223 | -122.412093053058 | (37.7611600595223, -122.412093053058) | |
| 774 | 774 | 231034 | Permitted Site 1 | Tree(s) :: 17 | 3050 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008943.01244 | 2104996.16235 | 37.760423319597294 | -122.412154701577 | (37.7604233195973, -122.412154701577) | |
| 775 | 775 | 231005 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 660 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 8 | Width 3ft | Permit Number 46247 | 6008971.29667 | 2105087.04019 | 37.7606744364044 | -122.41206330170401 | (37.7606744364044, -122.412063301704) | |
| 776 | 776 | 196857 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 487 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010733.79239 | 2111871.68352 | 37.7794022433647 | -122.406445673949 | (37.7794022433647, -122.406445673949) | |||
| 788 | 788 | 173935 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | |
| 793 | 793 | 65876 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/1990 12:00:00 AM | Permit Number 28874 | |||||||||
| 802 | 802 | 64866 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1989 12:00:00 AM | 13 | Permit Number 25884 | 5997401.9097 | 2109840.7512 | 37.773070992957 | -122.45241943675501 | (37.773070992957, -122.452419436755) | |
| 809 | 809 | 46145 | Permitted Site 1 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 814 | 814 | 44650 | Permitted Site 1 | Tree(s) :: 17 | 70 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 823 | 823 | 13156 | Permitted Site 1 | Tristania conferta :: 79 | 1875 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003411.9498 | 2119598.2407 | 37.800205081624604 | -122.432326975222 | (37.8002050816246, -122.432326975222) | |||
| 830 | 830 | 12894 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 255X Larch St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 3 | 3X3 | 6006443.29256 | 2113021.2667 | 37.7823177635948 | -122.421370005133 | (37.7823177635948, -122.421370005133) | ||
| 833 | 833 | 251388 | Permitted Site 1 | Brahea edulis :: Guadalupe Palm 115 | 1658 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2017 12:00:00 AM | 3 | 6014992.0461800005 | 2094842.7959900002 | 37.732881854221894 | -122.39052423440701 | (37.7328818542219, -122.390524234407) | |||
| 847 | 847 | 107475 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1099x Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5999355.4 | 2109104.7 | 37.77116170781979 | -122.445609151717 | (37.7711617078198, -122.445609151717) | |||
| 849 | 849 | 93578 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 401X Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53401 | 6009309.6837 | 2121148.6264 | 37.8047947000965 | -122.41202806393 | (37.8047947000965, -122.41202806393) | |
| 850 | 850 | 14550 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 834 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/1993 12:00:00 AM | 12 | 3X3 | 5999292.7589 | 2109954.5102 | 37.7734914941004 | -122.445886958088 | (37.7734914941004, -122.445886958088) | ||
| 862 | 862 | 141567 | Permitted Site 1 | Tree(s) :: 17 | 501X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779825 | 6000588.8239 | 2110706.7362 | 37.7756308363396 | -122.44145768074499 | (37.7756308363396, -122.441457680745) | |
| 864 | 864 | 37366 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 125 Street | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39871 | ||||||||
| 872 | 872 | 5299 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6001101.8528 | 2114070.3216 | 37.7848955998057 | -122.43992421757 | (37.7848955998057, -122.43992421757) | |||
| 876 | 876 | 192614 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2016 12:00:00 AM | 4 | Width 3ft | 6007548.67256 | 2110072.64933 | 37.774283827466896 | -122.417336847918 | (37.7742838274669, -122.417336847918) | ||
| 878 | 878 | 108700 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3024 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772805 | 6001479.41501 | 2118822.32035 | 37.7979648412708 | -122.438958648025 | (37.7979648412708, -122.438958648025) |
| 884 | 884 | 20233 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1724 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002600.0088 | 2114219.702 | 37.785390928556396 | -122.43475177403499 | (37.7853909285564, -122.434751774035) | |||
| 888 | 888 | 14525 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 638 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999197.0779 | 2110617.9064 | 37.7753075467631 | -122.44626566212901 | (37.7753075467631, -122.446265662129) | |||
| 897 | 897 | 22581 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006522.42636 | 2112846.04587 | 37.7818411112169 | -122.42108379139799 | (37.7818411112169, -122.421083791398) | |||
| 899 | 899 | 23949 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003202.444680001 | 2115904.93175 | 37.7900523252984 | -122.43278795880501 | (37.7900523252984, -122.432787958805) | |
| 906 | 906 | 238924 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1362 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2016 12:00:00 AM | 1 | Width 3ft | Permit Number 777634 | 6007680.96975 | 2101719.66165 | 37.751355903252 | -122.41628746589 | (37.751355903252, -122.41628746589) | |
| 910 | 910 | 7954 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1756 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6005736.45543 | 2116153.36588 | 37.7908778543671 | -122.424038156058 | (37.7908778543671, -122.424038156058) | |||
| 917 | 917 | 8555 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2141 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Mayor Office of Housing 7 | 18 | 3X3 | 6001312.669 | 2113446.883 | 37.7831957953331 | -122.43915016448999 | (37.7831957953331, -122.43915016449) | |||
| 921 | 921 | 30278 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 128 | ||||||||||
| 932 | 932 | 7693 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008532.7031 | 2121045.4305 | 37.804467726204 | -122.41470958714899 | (37.804467726204, -122.414709587149) | |||
| 937 | 937 | 45898 | Permitted Site 1 | Tree(s) :: 17 | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 940 | 940 | 51496 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1350 REVISED Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47808 | 6000958.86990754 | 2110035.78536621 | 37.773809648853 | -122.44012948036101 | (37.773809648853, -122.440129480361) | |||
| 943 | 943 | 17376 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1600 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Property owner contact Achmed 821-1594. | 6014810.6051199995 | 2095342.4042099998 | 37.7342436096391 | -122.391186437905 | (37.7342436096391, -122.391186437905) | ||
| 946 | 946 | 23565 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2958 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X2 | 6005634.29929 | 2120573.5209 | 37.8030087114389 | -122.424706189543 | (37.8030087114389, -122.424706189543) | |||
| 952 | 952 | 48321 | Permitted Site 1 | Tree(s) :: 17 | 187 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 953 | 953 | 46022 | Permitted Site 1 | Tree(s) :: 17 | 215 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 954 | 954 | 251405 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 540 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:08:00 PM | Width 0ft | 6009678.016 | 2120549.6995 | 37.8031708545804 | -122.410711083519 | (37.8031708545804, -122.410711083519) | |||
| 983 | 983 | 235091 | Permitted Site 1 | Tree(s) :: 17 | 100 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779715 | 6009129.80831 | 2096850.9527 | 37.7380688642945 | -122.410933356597 | (37.7380688642945, -122.410933356597) | |
| 992 | 992 | 7205 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 926 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2001 12:00:00 AM | 3 | 4X4 | 6003464.8493 | 2111545.8007 | 37.778098126187295 | -122.431568724094 | (37.7780981261873, -122.431568724094) | ||
| 993 | 993 | 235090 | Permitted Site 1 | Tree(s) :: 17 | 100 Putnam St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779715 | 6009124.9466 | 2096834.17608 | 37.7380225267172 | -122.410948981415 | (37.7380225267172, -122.410948981415) | |
| 997 | 997 | 95184 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001220.026000001 | 2113275.7262 | 37.7827205704951 | -122.439458398161 | (37.7827205704951, -122.439458398161) | |||
| 1001 | 1001 | 238568 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1300 Noe St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 04/27/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779731 | 6003218.5106 | 2100626.90187 | 37.7481035005842 | -122.431641146931 | (37.7481035005842, -122.431641146931) | |
| 1005 | 1005 | 131220 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 411 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1994 12:00:00 AM | 8 | Width 5ft | Permit Number 33166 | 6008433.24487 | 2113895.82908 | 37.7848310944226 | -122.414547535863 | (37.7848310944226, -122.414547535863) | |
| 1009 | 1009 | 223537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300 Noe St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 6003218.0959 | 2100594.3408 | 37.7480140720016 | -122.431640256605 | (37.7480140720016, -122.431640256605) | |||
| 1010 | 1010 | 45949 | Permitted Site 1 | Tree(s) :: 17 | 146 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1011 | 1011 | 232310 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1018 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2016 12:00:00 AM | 26 | Width 3ft | Permit Number 17854 | 5997696.0 | 2107004.0 | 37.7652988449505 | -122.451197528579 | (37.7652988449505, -122.451197528579) | |
| 1015 | 1015 | 48313 | Permitted Site 1 | Tree(s) :: 17 | 179 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1016 | 1016 | 225959 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 20 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2005 12:00:00 AM | 12 | Width 3ft | Permit Number 48238 | 6006979.14621 | 2096796.63822 | 37.7377988968125 | -122.41836543223101 | (37.7377988968125, -122.418365432231) | |
| 1017 | 1017 | 6253 | Permitted Site 1 | Tristania conferta :: 79 | 1315 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2004 12:00:00 AM | 9 | 3X3 | 6004522.7205 | 2113262.2432 | 37.782870955582794 | -122.428031512738 | (37.7828709555828, -122.428031512738) | ||
| 1019 | 1019 | 5195 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 625 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001591.0229 | 2110593.2492 | 37.7753762735578 | -122.437982704394 | (37.7753762735578, -122.437982704394) | ||
| 1024 | 1024 | 97943 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3003 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768278 | 5999754.4115699995 | 2116356.69568 | 37.791096591089 | -122.44475031260099 | (37.791096591089, -122.444750312601) | |
| 1031 | 1031 | 8753 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3330 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1993 12:00:00 AM | 6 | 3X3 | 5996823.9268 | 2112988.7445 | 37.7816814274235 | -122.45464621041799 | (37.7816814274235, -122.454646210418) | ||
| 1032 | 1032 | 164022 | Permitted Site 1 | Tree(s) :: 17 | 101X Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779959 | 5998844.0 | 2107514.0 | 37.7667648389525 | -122.447263591802 | (37.7667648389525, -122.447263591802) | |
| 1038 | 1038 | 57888 | Permitted Site 1 | Tree(s) :: 17 | 2382 Fost St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1977 12:00:00 AM | Permit Number 16841 | ||||||||
| 1040 | 1040 | 7083 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1790 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5998868.4415 | 2109744.0912 | 37.772889499766606 | -122.447339580133 | (37.7728894997666, -122.447339580133) | |||
| 1049 | 1049 | 110158 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1061 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 775265 | 6008518.81141 | 2118257.36351 | 37.7968116091339 | -122.41456024686501 | (37.7968116091339, -122.414560246865) | ||
| 1053 | 1053 | 21992 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2585 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2013 12:00:00 AM | 2 | 3x3 | 6015915.41358 | 2103336.7634099997 | 37.756255719130394 | -122.387924381009 | (37.7562557191304, -122.387924381009) | ||
| 1054 | 1054 | 125462 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 125 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 52121 | 6009895.29665 | 2113891.24599 | 37.7849005400769 | -122.40948896803499 | (37.7849005400769, -122.409488968035) | |
| 1058 | 1058 | 19026 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3173 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 5999643.72529 | 2115362.65802 | 37.78836090738071 | -122.44506178917 | (37.7883609073807, -122.44506178917) | |||
| 1061 | 1061 | 7724 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 211 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 767727 | 6006415.79653 | 2110907.1088900003 | 37.7765112494182 | -122.421314949539 | (37.7765112494182, -122.421314949539) | |
| 1064 | 1064 | 7177 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 827 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003463.7289 | 2111198.6401 | 37.7771448458144 | -122.431547809387 | (37.7771448458144, -122.431547809387) | |||
| 1067 | 1067 | 48140 | Permitted Site 1 | Tree(s) :: 17 | 250 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1076 | 1076 | 3599 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:11:00 PM | 3 | 3X3 | 6018236.38581 | 2098046.3275599997 | 37.7418575659771 | -122.37953006857799 | (37.7418575659771, -122.379530068578) | ||
| 1080 | 1080 | 9610 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1388X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/01/2017 01:42:00 PM | 3 | 3X3 | 6002958.1886 | 2112049.4711 | 37.7794523489738 | -122.433357444963 | (37.7794523489738, -122.433357444963) | ||
| 1082 | 1082 | 22639 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2005 12:00:00 AM | 3 | 3X3 | 6004184.7636 | 2112567.9201 | 37.780945391127 | -122.429151179613 | (37.780945391127, -122.429151179613) | ||
| 1083 | 1083 | 108357 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 250X Pixley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/17/2014 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002140.21513 | 2118970.4470599997 | 37.7984091333207 | -122.436682703142 | (37.7984091333207, -122.436682703142) | |
| 1085 | 1085 | 245467 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3286 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2004 12:00:00 AM | 6 | Width 0ft | 6006306.9956 | 2099162.9834 | 37.7442584900037 | -122.42085734017799 | (37.7442584900037, -122.420857340178) | ||
| 1086 | 1086 | 48227 | Permitted Site 1 | Tree(s) :: 17 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1089 | 1089 | 9603 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6003102.1679 | 2112019.7759 | 37.7793789805584 | -122.43285723801 | (37.7793789805584, -122.43285723801) | |||
| 1095 | 1095 | 54070 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1649 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 1 | Permit Number 9793 | 5981260.4052 | 2103836.5943 | 37.7556473215408 | -122.50780830550801 | (37.7556473215408, -122.507808305508) | ||
| 1107 | 1107 | 52527 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 123 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 5 | 2x3 | Permit Number 779986 | 6001343.89555 | 2092234.3638799998 | 37.7249531074958 | -122.437522568322 | (37.7249531074958, -122.437522568322) |
| 1112 | 1112 | 38268 | Permitted Site 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1300 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 42733 | 6014084.1716 | 2103880.9585 | 37.757648341819205 | -122.39429559298401 | (37.7576483418192, -122.394295592984) |
| 1113 | 1113 | 45845 | Permitted Site 1 | Tree(s) :: 17 | 81 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1115 | 1115 | 2987 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2266X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003539.7936 | 2115618.85396 | 37.7892859554236 | -122.431600327591 | (37.7892859554236, -122.431600327591) | |||
| 1117 | 1117 | 135672 | Permitted Site 1 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 2147 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1999 12:00:00 AM | 1 | Width 3ft | Permit Number 41893 | 6000516.72226 | 2120270.10752 | 37.80188525946561 | -122.44239382441299 | (37.8018852594656, -122.442393824413) | |
| 1118 | 1118 | 26811 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1850 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001133.0786 | 2112143.4834 | 37.7796067716282 | -122.43967800032301 | (37.7796067716282, -122.439678000323) | |||
| 1119 | 1119 | 38280 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 12 | Permit Number 40367 | 6013876.1493 | 2104054.9950099997 | 37.758114643000795 | -122.395027213942 | (37.7581146430008, -122.395027213942) | ||
| 1122 | 1122 | 38279 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6013875.32423 | 2104028.43016 | 37.7580416558018 | -122.39502820678801 | (37.7580416558018, -122.395028206788) | ||
| 1123 | 1123 | 28040 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011973.34792 | 2120976.9306 | 37.8044723526732 | -122.40279804081499 | (37.8044723526732, -122.402798040815) | ||
| 1125 | 1125 | 38267 | Permitted Site 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1300 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6014066.98761 | 2103880.20359 | 37.757645313792295 | -122.39435496983299 | (37.7576453137923, -122.394354969833) | ||
| 1126 | 1126 | 38276 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 3 | Permit Number 40367 | 6013924.79961 | 2103962.8321 | 37.757864288826795 | -122.394852504434 | (37.7578642888268, -122.394852504434) | ||
| 1128 | 1128 | 38275 | Permitted Site 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 651 Texas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6013943.54254 | 2103938.72902 | 37.7577991491248 | -122.394785995079 | (37.7577991491248, -122.394785995079) | ||
| 1129 | 1129 | 251457 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 758 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001327.0 | 2092594.0 | 37.7259396258956 | -122.437606717792 | (37.7259396258956, -122.437606717792) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");