Street_Tree_List

Data source: data.sfgov.org

26 rows where qCaretaker = 2 and qLegalStatus = 9 sorted by qLegalStatus

✎ View and edit SQL

This data as json, CSV (advanced)

qLegalStatus ✖

  • Landmark tree · 26 ✖

qCaretaker ✖

  • DPW · 26 ✖
Link rowid TreeID qLegalStatus ▼ qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
2263 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)
7798 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 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 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 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 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)
20653 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)
22823 22823 251110 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 5 Median : Yard 3 Tree 1 DPW 2                    
22824 22824 251112 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 14 Median : 22 Tree 1 DPW 2                    
22825 22825 251109 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 3 Median : Yard 3 Tree 1 DPW 2                    
22828 22828 251115 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 19 Median : Yard 3 Tree 1 DPW 2                    
22831 22831 251116 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 20 Median : Yard 3 Tree 1 DPW 2                    
22832 22832 251108 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 2 Median : Yard 3 Tree 1 DPW 2                    
22833 22833 251113 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 15 Median : Yard 3 Tree 1 DPW 2                    
22838 22838 251111 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 7 Median : Yard 3 Tree 1 DPW 2                    
22839 22839 251114 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 16 Median : Yard 3 Tree 1 DPW 2                    
35608 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 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 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 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)
78801 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 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)
94802 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)
116419 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)
126390 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 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 2766.613ms · Data source: data.sfgov.org