Street_Tree_List

9 rows where DBH = 7, PlotSize = "Width 2ft" and qSpecies = 27

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
51460	51460	226589	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	1100 Duncan St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	7	Width 2ft	5999827.96585	2100023.61803	37.7462542624189	-122.443322166684	(37.7462542624189, -122.443322166684)
71287	71287	207201	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	351 Flood Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	7	Width 2ft	5998416.44412	2094074.8160299999	37.7298396835571	-122.447774830644	(37.7298396835571, -122.447774830644)
76065	76065	207186	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	50 Hearst Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	7	Width 2ft	6000874.80167	2094365.21675	37.730777259156	-122.43929683358299	(37.730777259156, -122.439296833583)
130406	130406	207187	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	50 Hearst Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	7	Width 2ft	6000857.41139	2094366.50638	37.730779810542295	-122.439357046798	(37.7307798105423, -122.439357046798)
166031	166031	129493	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	660 Bay St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1	7	Width 2ft	6007573.98162	2121316.69576	37.8051586397294	-122.418046578505	(37.8051586397294, -122.418046578505)
168658	168658	207185	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	300 Gennessee St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	7	Width 2ft	5997471.20746	2094471.58174	37.7308750370476	-122.451071206592	(37.7308750370476, -122.451071206592)
176378	176378	207194	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	312 Hearst Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	7	Width 2ft	5999314.16696	2094391.4042099998	37.73076022959339	-122.44469405728901	(37.7307602295934, -122.444694057289)
183896	183896	226577	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	370 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	7	Width 2ft	6003494.445309999	2099538.93677	37.745131838370206	-122.43060935295601	(37.7451318383702, -122.430609352956)
186579	186579	207184	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	300 Gennessee St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	7	Width 2ft	5997470.84744	2094454.3152599998	37.7308276067915	-122.451071206573	(37.7308276067915, -122.451071206573)

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