Street_Tree_List

Data source: data.sfgov.org

39 rows where qLegalStatus = 9

View and edit SQL

Suggested facets: qSpecies, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1573 251597 Landmark tree 9 Ficus macrophylla :: Morton Bay Fig 148 1650 Valencia St 1 Side Yard : Yard 17 Tree 1 Private 1           6006336.0 2100501.0 37.747934015176504 -122.42085202386299 (37.7479340151765, -122.420852023863)
2263 22364 Landmark tree 9 Schinus terebinthifolius :: Brazilian Pepper 25 5490X 03rd St 1 Median : Cutout 11 Tree 1 DPW 2     48 40TR   6014151.6099 2093070.9929 37.7279701830365 -122.393305916851 (37.7279701830365, -122.393305916851)
4546 7946 Landmark tree 9 Melaleuca ericifolia :: Heath Melaleuca 184 1701 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6005703.15328 2116043.32965 37.7905738421571 -122.424145551273 (37.7905738421571, -122.424145551273)
7798 1716 Landmark tree 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 555 Battery St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 5x15   6012528.51285 2117974.4106400004 37.796259138493205 -122.400665775228 (37.7962591384932, -122.400665775228)
13675 18550 Landmark tree 9 Acacia melanoxylon :: Blackwood Acacia 5 1700X Quesada Ave 5 Median : Cutout 11 Tree 1 DPW 2     30 19   6014656.2717 2095062.2920900001 37.733465912826 -122.391700443637 (37.733465912826, -122.391700443637)
16525 18547 Landmark tree 9 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1700X Quesada Ave 2 Median : Cutout 11 Tree 1 DPW 2     30 19   6014668.27449 2095058.7142299998 37.733456755021 -122.391658696189 (37.733456755021, -122.391658696189)
16768 18555 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 10 Median : Cutout 11 Tree 1 DPW 2     12 19   6014626.04256 2095092.9200799998 37.733548332979105 -122.39180709603201 (37.7335483329791, -122.391807096032)
16811 18551 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 6 Median : Cutout 11 Tree 1 DPW 2     30 19   6014649.71614 2095074.3239900002 37.733498586072294 -122.391723949223 (37.7334985860723, -122.391723949223)
18163 24539 Landmark tree 9 Celtis occidentalis :: Common Hackberry 292 500X Cortland Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     50 3X3   6007622.1254900005 2097206.54003 37.738960570878795 -122.41617135711999 (37.7389605708788, -122.41617135712)
20653 2618 Landmark tree 9 Eucalyptus globulus :: Blue Gum 103 1661X Octavia St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
21449 24540 Landmark tree 9 Celtis occidentalis :: Common Hackberry 292 500X Cortland Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     50 3X3   6007652.968230001 2097201.05938 37.7389472564055 -122.416064328819 (37.7389472564055, -122.416064328819)
22308 248932 Landmark tree 9 Araucaria heterophylla :: Norfolk Island Pine 24 46 Cook St 1 Front Yard : Yard 7 Tree 1 Private 1         Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 5997514.0 2113392.0 37.7828282170553 -122.452288002469 (37.7828282170553, -122.452288002469)
22823 251110 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 5 Median : Yard 3 Tree 1 DPW 2                    
22824 251112 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 14 Median : 22 Tree 1 DPW 2                    
22825 251109 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 3 Median : Yard 3 Tree 1 DPW 2                    
22828 251115 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 19 Median : Yard 3 Tree 1 DPW 2                    
22831 251116 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 20 Median : Yard 3 Tree 1 DPW 2                    
22832 251108 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 2 Median : Yard 3 Tree 1 DPW 2                    
22833 251113 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 15 Median : Yard 3 Tree 1 DPW 2                    
22838 251111 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 7 Median : Yard 3 Tree 1 DPW 2                    
22839 251114 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 16 Median : Yard 3 Tree 1 DPW 2                    
35608 194288 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700x Quesada Ave 37 Median : Yard 3 Tree 1 DPW 2     34     6014411.93404 2095259.01392 37.733992504551296 -122.392558950849 (37.7339925045513, -122.392558950849)
39870 194287 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700x Quesada Ave 32 Median : Yard 3 Tree 1 DPW 2     31     6014435.322380001 2095233.3766599998 37.733923408722795 -122.392476296866 (37.7339234087228, -122.392476296866)
54354 194291 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700x Quesada Ave 41 Median : Yard 3 Tree 1 DPW 2     38     6014364.32912 2095287.3135099998 37.7340675655682 -122.39272551607701 (37.7340675655682, -122.392725516077)
58702 194289 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700x Quesada Ave 38 Median : Yard 3 Tree 1 DPW 2     48     6014396.14271 2095264.76436 37.734007417094 -122.39261394888901 (37.734007417094, -122.392613948889)
65300 111749 Landmark tree 9 Quercus agrifolia :: Coast Live Oak 180 4124 23rd St 1 Back Yard : Yard 13 Tree 1 Private 1           6002319.4 2102413.2 37.752957247271 -122.434877962118 (37.752957247271, -122.434877962118)
78801 2617 Landmark tree 9 Eucalyptus globulus :: Blue Gum 103 1661X Octavia St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
80756 2614 Landmark tree 9 Eucalyptus globulus :: Blue Gum 103 1661X Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
90443 111748 Landmark tree 9 Aesculus californica :: California Buckeye 338 730 28th Ave 1 Back Yard : Yard 13 Tree 1 Private 1           5987294.2 2110946.4 37.7755225253955 -122.48746405921301 (37.7755225253955, -122.487464059213)
94802 18548 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 3 Median : Cutout 11 Tree 1 DPW 2     30 19   6014793.6967997 2095004.1424748 37.7333138733401 -122.39122125893199 (37.7333138733401, -122.391221258932)
97410 113742 Landmark tree 9 Ficus macrophylla :: Morton Bay Fig 148 1580 Valencia St 2 Front Yard : Yard 7 Tree 1 Private 1     80     6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
101071 111757 Landmark tree 9 Sambucus mexicana :: Blue Elderberry 480 3440X Folsom St 1 Front Yard : Yard 7 Tree 1 Rec/Park 3           6008633.6974599995 2098934.7859 37.743762781475 -122.41279594632401 (37.743762781475, -122.412795946324)
114869 111205 Landmark tree 9 Araucaria heterophylla :: Norfolk Island Pine 24 46 COOK ST   Back Yard : Yard 13 Tree 1 Private 1     36   Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 5997514.0 2113392.0 37.7828282170553 -122.452288002469 (37.7828282170553, -122.452288002469)
116419 2615 Landmark tree 9 Eucalyptus globulus :: Blue Gum 103 1661X Octavia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
121641 64380 Landmark tree 9 Metrosideros excelsa 'Aurea' :: 447 1221 Stanyan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/21/1988 12:00:00 AM     Permit Number 25220 5997415.00742592 2105661.0761541002 37.7615954244829 -122.452072511028 (37.7615954244829, -122.452072511028)
124625 111763 Landmark tree 9 Cupressus macrocarpa :: Monterey Cypress 47 2626 Vallejo St 1 Back Yard : Yard 13 Tree 1 Private 1           6001000.6 2117623.4 37.7946456667745 -122.440529445268 (37.7946456667745, -122.440529445268)
126137 105444 Landmark tree 9 Quercus agrifolia :: Coast Live Oak 180 20-28 ROSEMONT PL 1 Back Yard : Yard 13 Tree 1 Private 1           6005075.5 2108088.5 37.768696376708895 -122.425750755404 (37.7686963767089, -122.425750755404)
126390 2619 Landmark tree 9 Eucalyptus globulus :: Blue Gum 103 1661X Octavia St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 10X10   6004877.75733 2115027.26874 37.7877373561683 -122.42692897924101 (37.7877373561683, -122.426928979241)
138324 2616 Landmark tree 9 Eucalyptus globulus :: Blue Gum 103 1661X Octavia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)

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 53.641ms · Data source: data.sfgov.org