Street_Tree_List

Data source: data.sfgov.org

7 rows where qSiteInfo = 3 and qSpecies = 22

View and edit SQL

Suggested facets: qAddress, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
31857 231585 DPW Maintained 3 Maytenus boaria :: Mayten 22 431x Precita Ave 6 Median : Yard 3 Tree 1 DPW 2     11 Width 10ft   6009398.516009999 2100214.89152 37.747320568797896 -122.41024173659201 (37.7473205687979, -122.410241736592)
68157 231583 DPW Maintained 3 Maytenus boaria :: Mayten 22 431x Precita Ave 4 Median : Yard 3 Tree 1 DPW 2     6 Width 10ft   6009377.24569 2100204.6551900003 37.7472912697843 -122.410314565485 (37.7472912697843, -122.410314565485)
75281 231584 DPW Maintained 3 Maytenus boaria :: Mayten 22 431x Precita Ave 5 Median : Yard 3 Tree 1 DPW 2     11 Width 10ft   6009387.39069 2100212.91077 37.7473145064694 -122.410280067473 (37.7473145064694, -122.410280067473)
147922 131159 DPW Maintained 3 Maytenus boaria :: Mayten 22 1237x Robert C Levy Tunl 14 Median : Yard 3 Tree 1 DPW 2     15     6007700.78305 2118156.69801 37.7964892156499 -122.41738368460199 (37.7964892156499, -122.417383684602)
154063 131160 DPW Maintained 3 Maytenus boaria :: Mayten 22 1237x Robert C Levy Tunl 16 Median : Yard 3 Tree 1 DPW 2     22     6007730.43085 2118156.7577 37.7964910475791 -122.41728110074301 (37.7964910475791, -122.417281100743)
158482 131157 DPW Maintained 3 Maytenus boaria :: Mayten 22 1237x Robert C Levy Tunl 12 Median : Yard 3 Tree 1 DPW 2     15     6007693.00329 2118120.33005 37.7963889205679 -122.417408025681 (37.7963889205679, -122.417408025681)
184176 131158 DPW Maintained 3 Maytenus boaria :: Mayten 22 1237x Robert C Levy Tunl 13 Median : Yard 3 Tree 1 DPW 2     13     6007691.70139 2118146.70965 37.79646127913271 -122.417414400977 (37.7964612791327, -122.417414400977)

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