Street_Tree_List

9 rows where SiteOrder = 13 and qSpecies = 109

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	PlantDate	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
4437	4437	221480	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	400x Guerrero St	13	Median : Cutout 11	Tree 1	DPW 2	04/29/2015 05:03:00 AM	1	Width 3ft	6005548.13055	2106148.7780400002	37.7633970583515	-122.423978006683	(37.7633970583515, -122.423978006683)
42902	42902	221440	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	100x Guerrero St	13	Median : Cutout 11	Tree 1	DPW 2		1	Width 3ft	6005447.60224	2108007.88033	37.7684960344855	-122.424457946087	(37.7684960344855, -122.424457946087)
93719	93719	110771	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	300X GUERRERO ST	13	Median : Cutout 11	Tree 1	DPW 2	06/19/2015 10:10:00 AM	3	3x3	6005492.0	2106949.0	37.7655911088206	-122.424229059984	(37.7655911088206, -122.424229059984)
100063	100063	110650	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	400X GUERRERO ST	13	Median : Cutout 11	Tree 1	DPW 2	04/29/2015 05:03:00 AM	3	3x3	6005439.0	2106552.0	37.7644980484366	-122.42438413571101	(37.7644980484366, -122.424384135711)
141015	141015	110784	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000X GUERRERO ST	13	Median : Cutout 11	Tree 1	DPW 2	05/26/2015 02:11:00 PM	3	3x3	6005663.0	2103080.0	37.7549773975701	-122.423362541701	(37.7549773975701, -122.423362541701)
150263	150263	221520	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1200x Guerrero St	13	Median : Cutout 11	Tree 1	DPW 2		6	Width 3ft	6005805.491090001	2101500.8171	37.7506493670819	-122.422757545722	(37.7506493670819, -122.422757545722)
159086	159086	221493	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	500x Guerrero St	13	Median : Cutout 11	Tree 1	DPW 2		2	Width 3ft	6005583.08285	2105563.4275	37.7617917972666	-122.42381549380801	(37.7617917972666, -122.423815493808)
178254	178254	221510	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1300x Guerrero St	13	Median : Cutout 11	Tree 1	DPW 2		7	Width 3ft	6005838.80296	2100921.0233299998	37.7490592658716	-122.422601154533	(37.7490592658716, -122.422601154533)
182798	182798	221555	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000x Guerrero St	13	Median : Cutout 11	Tree 1	DPW 2		2	Width 3ft	6005738.9106	2102712.57542	37.753972818908	-122.423073906548	(37.753972818908, -122.423073906548)

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