Street_Tree_List

Data source: data.sfgov.org

189,144 rows sorted by Longitude

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
3 119263 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 495X Lakeshore Dr 1 Median : Yard 3 Tree 1 DPW 2       10x30            
8 122650 Permitted Site 1 Acer rubrum :: Red Maple 6 300x Hickory St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3x3            
10 122670 Permitted Site 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 301x Hickory St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3X3            
11 122658 Permitted Site 1 Acer rubrum :: Red Maple 6 300x Hickory St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3x3            
12 122660 Permitted Site 1 Acer rubrum :: Red Maple 6 300x Hickory St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3x3            
13 122648 Permitted Site 1 Acer rubrum :: Red Maple 6 300x Hickory St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3x3            
16 122649 Permitted Site 1 Acer rubrum :: Red Maple 6 300x Hickory St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3x3            
51 60867 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/1983 12:00:00 AM     Permit Number 20649          
54 121137 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1388x Minna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2016 12:00:00 AM 3 3x3            
57 44642 Permitted Site 1 Tree(s) :: 17   60 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
59 44994 Permitted Site 1 Tree(s) :: 17   106 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
60 121139 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1388x Minna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2016 12:00:00 AM 3 3x3            
70 121138 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1388x Minna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2016 12:00:00 AM 3 3x3            
84 36641 Permitted Site 1 Robinia x ambigua :: Locust 33   13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1998 12:00:00 AM     Permit Number 39461          
86 119601 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 34 4357x Mission St 3 Front Yard : Yard 7 Tree 1 Private 1         Permit Number 774415          
103 117428 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/14/2016 12:00:00 AM 3   Permit Number 776915          
104 251210 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1170 Ingalls St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/02/1992 12:00:00 AM                
124 20281 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 20X Sunset Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
125 119758 Undocumented 2 Maytenus boaria :: Mayten 22 151X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
129 20398 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 262X Sunset Blvd 43 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
151 36617 Permitted Site 1 Robinia x ambigua :: Locust 33   8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1998 12:00:00 AM     Permit Number 39461          
169 251221 Permitted Site 1 Tree(s) :: 17 2401X Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 12:00:00 AM 3 3x3 Permit Number 778039          
172 48332 Permitted Site 1 Tree(s) :: 17   142 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
204 61453 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/22/1984 12:00:00 AM     Permit Number 21392          
235 45975 Permitted Site 1 Tree(s) :: 17   132 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
255 19810 DPW Maintained 3 Araucaria heterophylla :: Norfolk Island Pine 24 100 STAIRWAY24 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 100ST            
272 251264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
277 251265 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
279 48153 Permitted Site 1 Tree(s) :: 17   263 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
293 251262 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
294 251266 Private 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 10x Paloma Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
300 251263 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
308 46059 Permitted Site 1 Tree(s) :: 17   101 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
316 67789 Permitted Site 1 Tree(s) :: 17 7 4384 St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/17/1992 12:00:00 AM     Permit Number 31429          
320 48259 Permitted Site 1 Tree(s) :: 17   123 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
321 65143 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/1989 12:00:00 AM     Permit Number 27118          
363 119608 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 34 299x Avalon Ave 4 Front Yard : Yard 7 Tree 1 Private 1                    
381 122664 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 401x Laguna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3X3            
424 122666 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 401x Laguna St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3X3            
437 20292 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 20X Sunset Blvd 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
444 44838 Permitted Site 1 Tree(s) :: 17   12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
467 85277 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 801 Holladay Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2007 12:00:00 AM     Permit Number 49566          
501 251171 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 201X Cargo Way 37 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 11:21:00 AM 3              
509 38234 Permitted Site 1 Geijera parviflora :: Australian Willow 68 0 16th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/1998 12:00:00 AM     Permit Number 40352          
515 48129 Permitted Site 1 Tree(s) :: 17   297 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
536 45913 Permitted Site 1 Tree(s) :: 17   59 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
549 251321 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 100X Monument Way 1 Unaccepted Street : Yard 14 Tree 1 Private 1                    
556 20399 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 262X Sunset Blvd 44 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
580 48268 Permitted Site 1 Tree(s) :: 17   132 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
595 119606 Significant Tree 6 Myoporum laetum :: Myoporum 1 299x Avalon Ave 2 Front Yard : Yard 7 Tree 1 Private 1                    
613 20019 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 100 STAIRWAY48 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 10ST            
617 57850 Permitted Site 1 Tree(s) :: 17 1700 S. Amaylett Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/14/1977 12:00:00 AM     Permit Number 16791          
618 20377 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 262X Sunset Blvd 25 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 60            
632 44905 Permitted Site 1 Tree(s) :: 17   139 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
633 48204 Permitted Site 1 Tree(s) :: 17   47 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
639 20004 DPW Maintained 3 Prunus blireiana :: Flowering Plum 102 100 STAIRWAY46 24 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 2            
675 47038 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 716 Walter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/02/2002 12:00:00 AM     Permit Number 45030          
682 251365 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1                    
689 48269 Permitted Site 1 Tree(s) :: 17   120 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
712 251366 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1                    
713 251364 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1                    
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          
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          
738 20446 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 495X Sunset Blvd 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15            
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          
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          
812 19648 DPW Maintained 3 Pinus Spp :: Pine Spp 105 100 STAIRWAY5 47 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60ST            
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          
838 19815 DPW Maintained 3 Sequoia sempervirens :: Coast Redwood 116 100 STAIRWAY24 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 100ST            
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          
870 117001 DPW Maintained 3 :: 54 1X Bernal Heights Blvd 1 Front Yard : Yard 7 Tree 1 DPW 2                    
874 19854 DPW Maintained 3 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 100 STAIRWAY29 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 100ST            
886 19568 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 STAIRWAY1 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 100ST            
921 30278 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 128          
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          
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 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          
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          
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          
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          
1050 19708 DPW Maintained 3 Melaleuca spp :: Melaleuca spp 130 100 STAIRWAY13 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 40ST            
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          
1070 19942 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100 STAIRWAY38 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10ST            
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          
1098 251438 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2501X Santiago St 1 Median : Yard 3 Tree 1 DPW 2                    
1109 20024 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 100 STAIRWAY48 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 10ST            
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          
1130 251459 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 651 Texas St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/03/2017 12:00:00 AM 3 3x3            
1131 251458 Permitted Site 1 Jacaranda mimosifolia :: Jacaranda 52 651 Texas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/03/2017 12:00:00 AM 3 3x3            
1177 251471 DPW Maintained 3 Brugmansia spp :: Angel trumpet 137 2423 Market St 1 Front Yard : Yard 7 Tree 1 DPW 2                    
1221 19739 DPW Maintained 3 Pinus Spp :: Pine Spp 105 100 STAIRWAY14 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 40ST            
1225 44628 Permitted Site 1 Tree(s) :: 17   156 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
1271 19821 DPW Maintained 3 Acacia longifolia :: Golden Wattle 140 100 STAIRWAY25 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 10ST            
1350 19971 DPW Maintained 3 Schinus molle :: California Pepper 138 100 STAIRWAY44 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 15            
1378 19687 DPW Maintained 3 Pinus Spp :: Pine Spp 105 100 STAIRWAY5 86 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60ST            
1389 251532 Permitted Site 1 :: 54 2100X 20th St 4 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   05/15/2017 12:00:00 AM 3 4x11            
1391 251531 Permitted Site 1 :: 54 2100X 20th St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   05/15/2017 12:00:00 AM 3 4x11            
1393 19861 DPW Maintained 3 Pinus Spp :: Pine Spp 105 100 STAIRWAY30 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 30ST            
1418 48339 Permitted Site 1 Tree(s) :: 17   156 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
1434 20063 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 2948.332ms · Data source: data.sfgov.org