194,517 rows sorted by Supervisor Districts

View and edit SQL

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)
1492 20444 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
1498 44556 Permitted Site 7 Tree(s) :: 17   19 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1504 19794 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 100 STAIRWAY19 16 Sidewalk: Curb side : Cutout Tree DPW 1     18 50ST                      
1508 48345 Permitted Site 7 Tree(s) :: 17   162 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1511 260421 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200x Bacon St 5 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/17/2019 12:00:00 AM 3                        
1515 31846 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
1517 19783 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY19 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 50ST                      
1531 20287 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 20X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
1552 63329 Permitted Site 7 Tree(s) :: 17 225 Bessie St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/1987 12:00:00 AM     Permit Number 23902                    
1555 61775 Permitted Site 7 Tree(s) :: 17 157 Lacrosse Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/03/1984 12:00:00 AM     Permit Number 21796                    
1577 19793 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 100 STAIRWAY19 15 Sidewalk: Curb side : Cutout Tree DPW 1     6 20ST                      
1579 45978 Permitted Site 7 Tree(s) :: 17   129 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1581 19590 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 100 STAIRWAY4 13 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
1595 19920 DPW Maintained 1 Acacia longifolia :: Golden Wattle 150 100 STAIRWAY36 -2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3                      
1600 46288 Permitted Site 7 Robinia x ambigua :: Locust 196   15 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
1605 35819 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 980 Houston St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
1615 44603 Permitted Site 7 Tree(s) :: 17   121 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1619 95785 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 347 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2011 12:00:00 AM   3x3 Permit Number 767529                    
1623 20078 DPW Maintained 1 Fraxinus velutina 'Glabra' :: Arizona Ash 198 100 STAIRWAY56 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 5X5                      
1631 30310 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 228 Jordan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 8                    
1637 35981 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 83 Prospect Stairs Street 2 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1998 12:00:00 AM     Permit Number 39135                    
1643 44855 Permitted Site 7 Tree(s) :: 17   17 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1646 19899 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 100 STAIRWAY33 31 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
1648 35048 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 700 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
1654 19584 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 STAIRWAY4 7 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
1665 47611 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1201 Houston St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1994 12:00:00 AM     Permit Number 45444                    
1674 48081 Permitted Site 7 Tree(s) :: 17   245 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1694 100166 Property Tree 8 Salix spp :: Willow 203 2340 Twin Peaks Blvd   Front Yard : Yard Tree Private 2         Permit Number 769026                    
1695 19761 DPW Maintained 1 Acacia spp :: Acacia Spp 105 100 STAIRWAY15 19 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
1700 64639 Permitted Site 7 Tree(s) :: 17 465 Convention Way 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/1988 12:00:00 AM     Permit Number 25552                    
1703 48311 Permitted Site 7 Tree(s) :: 17   177 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1723 19755 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY15 13 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3                      
1736 255231 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 6 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
1743 55199 Permitted Site 7 Tree(s) :: 17 28 Dalmar St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/1972 12:00:00 AM     Permit Number 11112                    
1747 44960 Permitted Site 7 Tree(s) :: 17   61 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1751 121138 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1388x Minna St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2016 12:00:00 AM 3 3x3                      
1759 35455 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 790 Peninsula Ave 12 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1998 12:00:00 AM     Permit Number 38883                    
1760 44538 Permitted Site 7 Tree(s) :: 17   31 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1762 30595 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 265 Walter St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1995 12:00:00 AM     Permit Number 34562                    
1770 122656 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 12 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
1774 19805 DPW Maintained 1 Acacia spp :: Acacia Spp 105 100 STAIRWAY22 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 20                      
1784 44653 Permitted Site 7 Tree(s) :: 17   73 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1785 19984 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 40                      
1786 19661 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 60 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
1794 42923 Permitted Site 7 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42829                    
1795 44610 Permitted Site 7 Tree(s) :: 17   174 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1802 68847 Permitted Site 7 Tree(s) :: 17 2118 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1993 12:00:00 AM     Permit Number 32810                    
1815 44628 Permitted Site 7 Tree(s) :: 17   156 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1821 48173 Permitted Site 7 Tree(s) :: 17   66 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1829 55200 Permitted Site 7 Tree(s) :: 17 32 Dalmar St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/1972 12:00:00 AM     Permit Number 11113                    
1831 48269 Permitted Site 7 Tree(s) :: 17   120 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1837 19878 DPW Maintained 1 Acacia longifolia :: Golden Wattle 150 100 STAIRWAY33 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
1840 35278 Permitted Site 7 Tree(s) :: 17   5 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
1845 20002 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY46 22 Sidewalk: Curb side : Cutout Tree DPW 1     6 2                      
1847 57850 Permitted Site 7 Tree(s) :: 17 1700 S. Amaylett Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   04/14/1977 12:00:00 AM     Permit Number 16791                    
1886 20313 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 101X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
1904 48103 Permitted Site 7 Tree(s) :: 17   212 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1908 119794 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 2 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
1917 46148 Permitted Site 7 Tree(s) :: 17   2 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44491                    
1923 20027 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY48 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
1928 43486 Permitted Site 7 Melaleuca linariifolia :: Flaxleaf Paperbark 103   1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
1929 19668 DPW Maintained 1 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 100 STAIRWAY5 67 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
1934 44589 Permitted Site 7 Tree(s) :: 17   117 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1935 19720 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 STAIRWAY13 18 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
1940 43017 Permitted Site 7 Geijera parviflora :: Australian Willow 25   2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42880                    
1944 260235 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2201x 22nd Ave 31 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
1956 44540 Permitted Site 7 Tree(s) :: 17   29 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1959 19904 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY34 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 6X6                      
1964 48189 Permitted Site 7 Tree(s) :: 17   43 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1967 259348 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450x Burrows St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
1968 44918 Permitted Site 7 Tree(s) :: 17   183 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1975 48204 Permitted Site 7 Tree(s) :: 17   47 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1978 87100 Permitted Site 7 Pinus radiata :: Monterey Pine 15 700 Connecticut St 1 Front Yard : Yard Tree Rec/Park 5       3x3 Permit Number 50056                    
1982 20405 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 262X Sunset Blvd 50 Sidewalk: Curb side : Cutout Tree DPW 1     6 60                      
1984 48220 Permitted Site 7 Tree(s) :: 17   2 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1986 45957 Permitted Site 7 Tree(s) :: 17   166 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1987 44951 Permitted Site 7 Tree(s) :: 17   64 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2001 35044 Permitted Site 7 Tree(s) :: 17 700 Peninsula Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
2026 19643 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 42 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
2031 48316 Permitted Site 7 Tree(s) :: 17   182 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2033 35052 Permitted Site 7 Tree(s) :: 17 700 Peninsula Ave 12 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
2034 260230 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2201x 22nd Ave 26 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
2043 66343 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   12/10/1990 12:00:00 AM     Permit Number 29464                    
2047 20346 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 32 Sidewalk: Curb side : Cutout Tree DPW 1     18 40                      
2066 55924 Permitted Site 7 Tree(s) :: 17 524 Morgan Aly 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1973 12:00:00 AM     Permit Number 11988                    
2076 44958 Permitted Site 7 Tree(s) :: 17   82 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2083 46724 Permitted Site 7 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33   5 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
2087 261314 Permitted Site 7 :: 45 2601 Divisadero St 1 Sidewalk: Property side : Cutout Landscaping Private 2   12/31/2019 12:00:00 AM 3 6x106                      
2100 253677 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 199X Kissling St 1 Side Yard : Cutout Tree Private 2       5x10                      
2102 48160 Permitted Site 7 Tree(s) :: 17   270 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2108 35196 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   5 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2113 44856 Permitted Site 7 Tree(s) :: 17   33 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2140 46192 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19   6 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
2146 45914 Permitted Site 7 Tree(s) :: 17   33 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2163 48471 Permitted Site 7 Tree(s) :: 17   15 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 45832                    
2169 19944 DPW Maintained 1 Acacia longifolia :: Golden Wattle 150 100 STAIRWAY39 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
2170 44902 Permitted Site 7 Tree(s) :: 17   136 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2177 44598 Permitted Site 7 Tree(s) :: 17   126 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2187 46061 Permitted Site 7 Tree(s) :: 17   103 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2189 48278 Permitted Site 7 Tree(s) :: 17   88 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);