trees

27,746 rows where qCaretaker_id = 1 sorted by Neighborhoods (old)

✎ 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) ▼
1695 19761 DPW Maintained 1 Acacia spp :: Acacia Spp 105 100 STAIRWAY15 19 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
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                            
1774 19805 DPW Maintained 1 Acacia spp :: Acacia Spp 105 100 STAIRWAY22 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 20                      
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                      
1837 19878 DPW Maintained 1 Acacia longifolia :: Golden Wattle 150 100 STAIRWAY33 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
1845 20002 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY46 22 Sidewalk: Curb side : Cutout Tree DPW 1     6 2                      
1886 20313 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 101X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
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)          
1923 20027 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY48 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
1929 19668 DPW Maintained 1 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 100 STAIRWAY5 67 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
1935 19720 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 STAIRWAY13 18 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
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                        
1959 19904 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY34 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 6X6                      
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                        
1982 20405 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 262X Sunset Blvd 50 Sidewalk: Curb side : Cutout Tree DPW 1     6 60                      
2026 19643 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 42 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
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                        
2047 20346 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 32 Sidewalk: Curb side : Cutout Tree DPW 1     18 40                      
2169 19944 DPW Maintained 1 Acacia longifolia :: Golden Wattle 150 100 STAIRWAY39 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
2214 20033 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 100 STAIRWAY51 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 ST                      
2217 20079 DPW Maintained 1 Fraxinus velutina 'Glabra' :: Arizona Ash 198 100 STAIRWAY56 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3                      
2286 20017 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY48 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
2290 259356 DPW Maintained 1 Cassia leptophylla :: Gold Medallion Tree 152 1700 Jennings St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/25/2019 12:00:00 AM 3                        
2302 19935 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY38 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
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                      
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                      
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                      
2447 19649 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 48 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
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                        
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                      
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                      
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                      
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                      
2582 19774 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 STAIRWAY17 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 20ST                      
2605 19985 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 100 STAIRWAY46 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 40                      
2624 19842 DPW Maintained 1 Sequoiadendron giganteum :: Sierra Redwood 240 100 STAIRWAY25 26 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
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                        
2649 20050 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY52 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 10                      
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                      
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                              
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                      
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                              
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                        
2950 19885 DPW Maintained 1 Syzygium paniculatum :: Brush Cherry 243 100 STAIRWAY33 17 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
3000 20052 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY53 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
3011 19948 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 25ST                      
3018 19802 DPW Maintained 1 Acacia spp :: Acacia Spp 105 100 STAIRWAY22 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 20                      
3028 19906 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY35 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
3035 259640 DPW Maintained 1 :: 45 198x Arleta Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
3041 19585 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY4 8 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
3052 19908 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY35 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
3055 20039 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 10 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
3078 19568 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY1 2 Sidewalk: Curb side : Cutout Tree DPW 1     48 100ST                      
3083 19706 DPW Maintained 1 Melaleuca spp :: Melaleuca spp 117 100 STAIRWAY13 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
3091 19871 DPW Maintained 1 Maytenus boaria :: Mayten 58 100 STAIRWAY33 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
3098 20419 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 453X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
3100 19586 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 STAIRWAY4 9 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
3106 20323 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 101X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
3117 260221 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 13 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
3125 20020 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY48 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
3129 20059 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 100 STAIRWAY54 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 15ST                      
3183 260224 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2201x 22nd Ave 20 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
3191 19565 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY1 -11 Sidewalk: Curb side : Cutout Tree DPW 1     36 100ST                      
3196 19917 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY35 13 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
3208 19988 DPW Maintained 1 Quercus spp :: Oak 254 100 STAIRWAY46 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 40                      
3211 19860 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 30ST                      
3222 20014 DPW Maintained 1 Sequoia sempervirens :: Coast Redwood 155 100 STAIRWAY47 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
3227 259338 DPW Maintained 1 Laurus x 'Saratoga' :: Hybrid Laurel 4 2x Silliman St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 04/27/2019 12:00:00 AM 3                        
3232 20054 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 100 STAIRWAY54 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 15ST                      
3265 255205 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 320 Bacon St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
3284 19710 DPW Maintained 1 Melaleuca spp :: Melaleuca spp 117 100 STAIRWAY13 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
3296 19833 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 STAIRWAY25 17 Sidewalk: Curb side : Cutout Tree DPW 1     18 60X                      
3319 255128 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 6 Sidewalk: Property side : Yard Tree DPW 1                              
3339 19580 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 STAIRWAY4 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 8                      
3352 20327 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 101X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
3373 119797 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 5 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
3379 258367 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 901 Silliman St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF     4x5                      
3417 119788 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 8 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
3442 20392 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 262X Sunset Blvd 38 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
3448 19730 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
3449 19754 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY15 12 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3                      
3457 20016 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY48 0 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
3460 20048 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 100 STAIRWAY52 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 10                      
3477 259101 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 600 Visitacion Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
3511 254247 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 100x Beale St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/13/2018 12:00:00 AM 3                        
3527 19876 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY33 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
3534 118354 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100X Guerrero St 9 Median : Cutout Tree DPW 1   07/15/2016 06:05:00 AM 3                        

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