Street_Tree_List

9 rows where PlotSize = "Width 5ft", qSiteInfo = 11 and qSpecies = 12

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
46169	46169	188192	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	860x Jamestown Ave	7	Median : Cutout 11	Tree 1	DPW 2	2	Width 5ft	6014712.4620199995	2089164.16636	37.7172739556962	-122.391094061367	(37.7172739556962, -122.391094061367)
58921	58921	188193	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	860x Jamestown Ave	8	Median : Cutout 11	Tree 1	DPW 2	2	Width 5ft	6014700.6925800005	2089174.7091700002	37.7173022510631	-122.391135479631	(37.7173022510631, -122.391135479631)
73694	73694	188195	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	920x Jamestown Ave	6	Median : Cutout 11	Tree 1	DPW 2	3	Width 5ft	6014470.00417	2089321.4715900002	37.717692427352	-122.391943124797	(37.717692427352, -122.391943124797)
134352	134352	188190	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	828x Jamestown Ave	5	Median : Cutout 11	Tree 1	DPW 2	4	Width 5ft	6014862.4902	2088981.3043400003	37.716780176644896	-122.390562709505	(37.7167801766449, -122.390562709505)
159414	159414	188194	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	920x Jamestown Ave	5	Median : Cutout 11	Tree 1	DPW 2	3	Width 5ft	6014479.07323	2089312.06804	37.717667110539395	-122.391911119697	(37.7176671105394, -122.391911119697)
161647	161647	188189	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	828x Jamestown Ave	3	Median : Cutout 11	Tree 1	DPW 2	2	Width 5ft	6014874.8718	2088959.3424900002	37.716720560580605	-122.390518378346	(37.7167205605806, -122.390518378346)
163682	163682	188196	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	920x Jamestown Ave	7	Median : Cutout 11	Tree 1	DPW 2	3	Width 5ft	6014458.158419999	2089328.2197	37.7177102986816	-122.39198454217698	(37.7177102986816, -122.391984542177)
183163	183163	188197	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	920x Jamestown Ave	8	Median : Cutout 11	Tree 1	DPW 2	2	Width 5ft	6014447.456130001	2089337.65595	37.717735614585294	-122.39202219499501	(37.7177356145853, -122.392022194995)
188458	188458	188191	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	860x Jamestown Ave	6	Median : Cutout 11	Tree 1	DPW 2	2	Width 5ft	6014720.49682	2089157.49571	37.7172560852665	-122.39106582262501	(37.7172560852665, -122.391065822625)

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