142,615 rows where qLegalStatus_id = 1 sorted by XCoord

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)
2 262167 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 420 Alpha St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 11/16/2020 12:00:00 AM 3                        
6 262166 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 420 Alpha St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 11/16/2020 12:00:00 AM 3                        
13 264822 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2 Harkness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3 4x6                      
16 264823 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2 Harkness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3 4x6                      
19 262168 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 420 Alpha St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 11/16/2020 12:00:00 AM 3                        
79 121399 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 349X Cargo Way 1 Sidewalk: Curb side : Cutout Tree DPW 1                              
80 260998 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 600X Lake Merced Blvd 1 Sidewalk: Property side : Yard Tree SFUSD 4       10x10                      
82 251210 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1170 Ingalls St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/02/1992 12:00:00 AM                          
83 259099 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 600 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
85 259368 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 1646 Revere Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
87 259654 DPW Maintained 1 :: 45 101x Cora St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
88 259653 DPW Maintained 1 :: 45 99x Cora St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
89 259623 DPW Maintained 1 :: 45 1498x Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3                        
90 259864 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1398x Brussels St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
91 260225 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2201x 22nd Ave 21 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
92 260521 DPW Maintained 1 Leucodendron argenteum :: Silver Tree 46 3519x Kirkham St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 07/27/2019 12:00:00 AM 3                        
93 260525 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3437x Rivera St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 07/27/2019 12:00:00 AM 3                        
100 255131 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 9 Sidewalk: Property side : Yard Tree DPW 1                              
101 255229 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
102 258152 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 500X Bryant St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3                        
103 253831 DPW Maintained 1 :: 45 699X Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3                      
104 260590 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3099x Jennings St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/20/2020 12:00:00 AM 3                        
106 251438 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2501X Santiago St 1 Median : Yard Tree DPW 1                              
107 264818 DPW Maintained 1 Podocarpus gracilor :: Fern Pine 51 101x Olmstead St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/23/2020 12:00:00 AM 3                        
114 251458 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 651 Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/03/2017 12:00:00 AM 3 3x3                      
285 260625 DPW Maintained 1 Laurus x 'Saratoga' :: Hybrid Laurel 4 1601x Thomas Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3                        
449 252970 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101X Whipple Ave 2 Sidewalk: Curb side : Yard Tree Private 2   04/26/2019 12:00:00 AM 3                        
488 20353 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 60                      
509 19905 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY35 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 120ST                      
537 261951 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 5 Sidewalk: Property side : Yard Tree DPW 1                              
544 259763 DPW Maintained 1 Acer rubrum :: Red Maple 75 2701 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/12/2019 12:00:00 AM 3                        
550 19742 DPW Maintained 1 Melaleuca spp :: Melaleuca spp 117 100 STAIRWAY15 -9 Sidewalk: Curb side : Cutout Tree DPW 1     6 1OST                      
561 19835 DPW Maintained 1 Eriobotrya japonica :: Edible Loquat 119 100 STAIRWAY25 19 Sidewalk: Curb side : Cutout Tree DPW 1     12 60X                      
566 260237 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2201x 22nd Ave 33 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/20/2018 12:00:00 AM 3                        
582 20409 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 451X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 10                      
594 20063 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 100 STAIRWAY54 10 Sidewalk: Curb side : Cutout Tree DPW 1     6 15ST                      
595 261954 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1X Portola Dr To Clipper St Connetion 8 Sidewalk: Property side : Yard Tree DPW 1                              
604 20034 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
657 20296 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 20X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
663 259361 DPW Maintained 1 Acer rubrum 'October Glory' :: Red October Glory Maple 128 1699x Keith St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/25/2019 12:00:00 AM 3                        
668 19865 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 9 Sidewalk: Curb side : Cutout Tree DPW 1     24 100ST                      
689 119914 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 400X Brotherhood Way 1 Front Yard : Yard Tree DPW 1       100x100                      
690 19651 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 50 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
695 20360 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
720 19950 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY39 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
756 124716 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2195 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2                              
768 20385 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 262X Sunset Blvd 31 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
784 187688 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 399X Ash St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2017 12:00:00 AM 3                        
795 19570 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 STAIRWAY1 4 Sidewalk: Curb side : Cutout Tree DPW 1     48 100ST                      
798 19725 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY14 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 40ST                      
808 19837 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 100 STAIRWAY25 21 Sidewalk: Curb side : Cutout Tree DPW 1     6 60X                      
815 20416 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 453X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
819 20315 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
844 254210 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 300x Esmeralda Ave 20 Unaccepted Street : Yard Tree DPW 1                              
871 259735 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 100x Florida St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/09/2018 12:00:00 AM 3                        
874 19715 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY13 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
875 19954 DPW Maintained 1 Acacia longifolia :: Golden Wattle 150 100 STAIRWAY39 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
884 261406 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 779 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2                              
900 19637 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 36 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
954 20324 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 101X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
1062 20065 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 100 STAIRWAY54 12 Sidewalk: Curb side : Cutout Tree DPW 1     3 15ST                      
1090 260553 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 151x Palm Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD 09/21/2019 12:00:00 AM 3                        
1095 255202 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
1138 260594 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3090x Jennings St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3                        
1144 20400 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 262X Sunset Blvd 45 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
1160 122663 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401x Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3                      
1171 19952 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY39 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
1176 119263 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 495X Lakeshore Dr 1 Median : Yard Tree DPW 1       10x30                      
1179 251578 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 6 Median : Cutout Tree DPW 1                              
1215 253279 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 201X Laguna Honda Blvd 1 Sidewalk: Property side : Yard Tree DPW 1       10x10 ROW IS 10' tree is street tree                    
1216 20357 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
1295 19941 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY38 10 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
1310 173924 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 500X Gough St 4 Sidewalk: Curb side : Cutout Tree DPW 1   10/05/2010 12:00:00 AM   3x3                      
1350 19628 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY5 27 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
1363 19612 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY5 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
1393 255136 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X Brotherhood Way 14 Sidewalk: Property side : Yard Tree DPW 1                              
1398 20032 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 100 STAIRWAY51 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3ST                      
1404 19975 DPW Maintained 1 Acacia longifolia :: Golden Wattle 150 100 STAIRWAY45 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 30ST                      
1420 19991 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 100 STAIRWAY46 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
1422 259801 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 1180x Brussels St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
1476 20456 DPW Maintained 1 Sequoia sempervirens :: Coast Redwood 155 495X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
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                      
1504 19794 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 100 STAIRWAY19 16 Sidewalk: Curb side : Cutout Tree DPW 1     18 50ST                      
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                        
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                      
1577 19793 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 100 STAIRWAY19 15 Sidewalk: Curb side : Cutout Tree DPW 1     6 20ST                      
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                      
1623 20078 DPW Maintained 1 Fraxinus velutina 'Glabra' :: Arizona Ash 198 100 STAIRWAY56 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 5X5                      
1646 19899 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 100 STAIRWAY33 31 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
1654 19584 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 STAIRWAY4 7 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
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                            
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                      
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                      

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