Street_Tree_List

8 rows where PlotSize = "Width 5ft" and qSpecies = 71

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
4769	4769	194422	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	199X Kissling St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	52	Width 5ft	6007901.53326	2109054.5781799997	37.771508291196	-122.41604412194401	(37.771508291196, -122.416044121944)
39232	39232	132164	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	150 Lombard St	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	16	Width 5ft	6011515.19186	2120799.8495099996	37.8039605395195	-122.404371067467	(37.8039605395195, -122.404371067467)
47480	47480	194424	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	132 Kissling St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	23	Width 5ft	6007931.050980001	2109095.29996	37.77162176316789	-122.41594490245599	(37.7716217631679, -122.415944902456)
65528	65528	132163	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	150 Lombard St	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	16	Width 5ft	6011528.08163	2120803.5748799997	37.8039714887622	-122.40432672370399	(37.8039714887622, -122.404326723704)
65779	65779	194426	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	132 Kissling St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	19	Width 5ft	6007946.83693	2109121.1094299997	37.77169351738029	-122.415892125715	(37.7716935173803, -122.415892125715)
155635	155635	194423	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	132 Kissling St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	17	Width 5ft	6007917.867000001	2109077.33792	37.771571702413	-122.41598923453002	(37.771571702413, -122.41598923453)
164388	164388	234478	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	398 Surrey St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1	30	Width 5ft	6001098.400769999	2096167.19905	37.7357378071451	-122.43865288754	(37.7357378071451, -122.43865288754)
175007	175007	194425	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	132 Kissling St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	16	Width 5ft	6007938.01013	2109107.31213	37.771655137004	-122.41592168104799	(37.771655137004, -122.415921681048)

Advanced export

JSON shape: default, array, newline-delimited

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