trees

194,517 rows sorted by XCoord

✎ View and edit SQL

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)
2304 19829 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY25 13 Sidewalk: Curb side : Cutout Tree DPW 1     6 60X                      
2306 19600 DPW Maintained 1 Cupressocyparis leylandii :: Leyland Cypress 185 100 STAIRWAY4 23 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
2318 61432 Permitted Site 7 Tree(s) :: 17 234 La Espiral St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/1984 12:00:00 AM     Permit Number 21363                    
2319 34069 Permitted Site 7 Geijera parviflora :: Australian Willow 25 955 Kennedy Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37965                    
2323 35205 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   16 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2339 44535 Permitted Site 7 Tree(s) :: 17   34 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2366 45917 Permitted Site 7 Tree(s) :: 17   63 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2371 57894 Permitted Site 7 Tree(s) :: 17 972 Terminal Way 1 Sidewalk: Curb side : Cutout Tree Private 2   05/25/1977 12:00:00 AM     Permit Number 16848                    
2382 255210 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1 Burrows St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
2386 19745 DPW Maintained 1 Schinus terebinthifolius :: Brazilian Pepper 93 100 STAIRWAY15 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3                      
2397 19696 DPW Maintained 1 Prunus spp :: Cherry 68 100 STAIRWAY9 -3 Sidewalk: Curb side : Cutout Tree DPW 1     12 15ST                      
2424 61752 Permitted Site 7 Tree(s) :: 17 3014 Rolison Road 1 Sidewalk: Curb side : Cutout Tree Private 2   12/18/1984 12:00:00 AM     Permit Number 21763                    
2427 19795 DPW Maintained 1 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 100 STAIRWAY20 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 15ST                      
2429 19676 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 75 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
2434 44999 Permitted Site 7 Tree(s) :: 17   103 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2445 48349 Permitted Site 7 Tree(s) :: 17   152 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2447 19649 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 48 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
2451 44962 Permitted Site 7 Tree(s) :: 17   75 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2475 259866 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 101x Desmond St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
2483 34134 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   5 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
2511 20282 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 20X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
2516 45863 Permitted Site 7 Tree(s) :: 17   85 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2524 30480 Permitted Site 7 Tree(s) :: 17   3 Sidewalk: Curb side : Cutout Tree Private 2   09/05/1956 12:00:00 AM     Permit Number 147                    
2534 48332 Permitted Site 7 Tree(s) :: 17   142 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2538 20304 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 50X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
2549 31437 Permitted Site 7 Tree(s) :: 17 4206 02nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1995 12:00:00 AM     Permit Number 35012                    
2551 256191 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 3600 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3                        
2554 48167 Permitted Site 7 Tree(s) :: 17   60 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2559 48211 Permitted Site 7 Tree(s) :: 17   54 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2564 20333 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 101X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
2566 35200 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   3 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2568 20451 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 495X Sunset Blvd 16 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
2572 20316 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
2573 60778 Permitted Site 7 Tree(s) :: 17 3933 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/1983 12:00:00 AM     Permit Number 20448                    
2582 19774 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY17 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 20ST                      
2583 34124 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37982                    
2602 42924 Permitted Site 7 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33   2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42829                    
2605 19985 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 100 STAIRWAY46 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 40                      
2610 31853 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 1263 Houston St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35300                    
2612 48088 Permitted Site 7 Tree(s) :: 17   198 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2624 19842 DPW Maintained 1 Sequoiadendron giganteum :: Sierra Redwood 240 100 STAIRWAY25 26 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
2632 48281 Permitted Site 7 Tree(s) :: 17   91 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2635 259636 DPW Maintained 1 :: 45 98x Arleta Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
2646 44909 Permitted Site 7 Tree(s) :: 17   132 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2649 20050 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY52 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 10                      
2656 44646 Permitted Site 7 Tree(s) :: 17   66 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2664 45874 Permitted Site 7 Tree(s) :: 17   28 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2666 48202 Permitted Site 7 Tree(s) :: 17   45 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2667 66672 Permitted Site 7 Tree(s) :: 17 4307 02nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/1991 12:00:00 AM     Permit Number 29892                    
2677 36640 Permitted Site 7 Robinia x ambigua :: Locust 196   14 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
2684 19830 DPW Maintained 1 Sequoiadendron giganteum :: Sierra Redwood 240 100 STAIRWAY25 14 Sidewalk: Curb side : Cutout Tree DPW 1     24 60X                      
2687 19642 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 41 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
2690 44593 Permitted Site 7 Tree(s) :: 17   133 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2691 58348 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   11/08/1978 12:00:00 AM     Permit Number 17373                    
2697 49874 Permitted Site 7 Tree(s) :: 17 0@ 14th ST Trainor St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2003 12:00:00 AM     Permit Number 46642                    
2702 48207 Permitted Site 7 Tree(s) :: 17   50 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2710 44606 Permitted Site 7 Tree(s) :: 17   170 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2715 57888 Permitted Site 7 Tree(s) :: 17 2382 Fost St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/04/1977 12:00:00 AM     Permit Number 16841                    
2716 48065 Permitted Site 7 Tree(s) :: 17   219 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2722 48074 Permitted Site 7 Tree(s) :: 17   240 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2725 118348 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100X Guerrero St 3 Median : Cutout Tree DPW 1   07/15/2016 06:19:00 AM 3                        
2726 260522 DPW Maintained 1 Griselinia lucida :: Griselinia 242 3440x Santiago St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 07/27/2019 12:00:00 AM 3                        
2744 261957 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 11 Sidewalk: Property side : Yard Tree DPW 1                              
2746 44553 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2762 46200 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83   2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
2763 48152 Permitted Site 7 Tree(s) :: 17   262 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2768 48107 Permitted Site 7 Tree(s) :: 17   202 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2775 45022 Permitted Site 7 Tree(s) :: 17   95 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2777 256912 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 26 Lily St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3 3x3 Permit Number 782765                    
2794 254529 Permitted Site 7 Rhamnus alaternus :: Italian Buckthorn 29 421 Terra Vista Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/2018 12:00:00 AM 3 3x3 Permit Number 769845                    
2795 48259 Permitted Site 7 Tree(s) :: 17   123 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2809 251459 DPW Maintained 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 651 Texas St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/03/2017 12:00:00 AM 3 3x3                      
2812 19775 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY18 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 50ST                      
2826 20064 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 100 STAIRWAY54 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 15ST                      
2832 45922 Permitted Site 7 Tree(s) :: 17   68 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2835 48321 Permitted Site 7 Tree(s) :: 17   187 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2849 44580 Permitted Site 7 Tree(s) :: 17   144 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
2851 45941 Permitted Site 7 Tree(s) :: 17   42 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2852 48188 Permitted Site 7 Tree(s) :: 17   69 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2858 261960 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 14 Sidewalk: Property side : Yard Tree DPW 1                              
2868 255125 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 3 Sidewalk: Property side : Yard Tree DPW 1                              
2871 45998 Permitted Site 7 Tree(s) :: 17   116 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2876 46030 Permitted Site 7 Tree(s) :: 17   207 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2883 19735 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
2887 255158 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3098 Turk St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3                        
2890 65297 Permitted Site 7 Tree(s) :: 17 328 Magnolia St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/1989 12:00:00 AM     Permit Number 28111                    
2893 43480 Permitted Site 7 Melaleuca linariifolia :: Flaxleaf Paperbark 103   2 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
2902 66145 Permitted Site 7 Tree(s) :: 17 2151 North Point 1 Sidewalk: Curb side : Cutout Tree Private 2   08/18/1990 12:00:00 AM     Permit Number 29211                    
2912 122668 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 301x Hickory St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3                      
2927 35280 Permitted Site 7 Olea europaea :: Olive Tree 9   1 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
2942 48171 Permitted Site 7 Tree(s) :: 17   64 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
2950 19885 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 100 STAIRWAY33 17 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
2954 45891 Permitted Site 7 Tree(s) :: 17   11 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
2961 35202 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   1 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2978 44849 Permitted Site 7 Tree(s) :: 17   41 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
2988 35689 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27   12 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
2996 38797 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   5 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1998 12:00:00 AM     Permit Number 40645                    
3000 20052 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY53 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
3005 109931 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2822 Moraga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/12/2015 12:00:00 AM 3 3x3 Permit Number 775171                    
3009 63503 Permitted Site 7 Tree(s) :: 17 664 Guardalupe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/1987 12:00:00 AM     Permit Number 24104                    

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