Street_Tree_List

5 rows where qSiteInfo = 3 and qSpecies = 190

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	XCoord	YCoord	Latitude	Longitude	Location
50134	50134	191700	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	1700x Quesada Ave	39	Median : Yard 3	Tree 1	DPW 2	3	6014384.30677	2095263.8272900002	37.7340041867507	-122.39265480417801	(37.7340041867507, -122.392654804178)
64747	64747	191695	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	950x Kansas St	4	Median : Yard 3	Tree 1	DPW 2	4	6011603.94241	2103847.92507	37.7574194607598	-122.40287096412901	(37.7574194607598, -122.402870964129)
65580	65580	191710	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	1427x Innes Ave	28	Median : Yard 3	Tree 1	DPW 2	3	6016141.2133599995	2096757.17707	37.7382020430791	-122.386684681762	(37.7382020430791, -122.386684681762)
67780	67780	191690	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	900x Carolina St	22	Median : Yard 3	Tree 1	DPW 2	2	6012468.62754	2103498.74867	37.756508943061206	-122.39985600137399	(37.7565089430612, -122.399856001374)
172289	172289	207711	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	200x Terrace Dr	31	Median : Yard 3	Tree 1	DPW 2	12	5993844.07189	2096487.62875	37.7362022754996	-122.463756979508	(37.7362022754996, -122.463756979508)

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