Street_Tree_List

9 rows where PlotSize = "Width 10ft" and qSpecies = 30

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
28130	28130	191253	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	654 Minnesota St	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1	3	Width 10ft	6015148.44265	2105367.15882	37.7617882296504	-122.39071873558599	(37.7617882296504, -122.390718735586)
36838	36838	191250	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	654 Minnesota St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1	5	Width 10ft	6015147.38841	2105382.23529	37.7618295678896	-122.390723435432	(37.7618295678896, -122.390723435432)
47731	47731	227663	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	6 Unnamed 011	1	Back Yard : Yard 13	Tree 1	Private 1	13	Width 10ft	6002739.4908	2096074.90228	37.735577602816896	-122.432972414242	(37.7355776028169, -122.432972414242)
56239	56239	191252	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	654 Minnesota St	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1	3	Width 10ft	6015147.22099	2105373.94992	37.761806808764796	-122.390723435452	(37.7618068087648, -122.390723435452)
57630	57630	191251	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	654 Minnesota St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1	5	Width 10ft	6015148.84129	2105378.48456	37.7618193498029	-122.39071814833599	(37.7618193498029, -122.390718148336)
160010	160010	176926	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	200 Morse St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1	23	Width 10ft	6000586.22066	2087873.8924099999	37.712937131606395	-122.439829268227	(37.7129371316064, -122.439829268227)
162520	162520	227662	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	32 Harry St	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1	4	Width 10ft	6003182.99622	2097643.55659	37.7399099141156	-122.43155100069099	(37.7399099141156, -122.431551000691)
168888	168888	176927	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	200 Morse St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1	30	Width 10ft	6000575.21017	2087869.90013	37.7129255429455	-122.43986703794201	(37.7129255429455, -122.439867037942)
173661	173661	191249	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2300 18th St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1	6	Width 10ft	6010915.57021	2105542.63703	37.7620342994705	-122.405370986778	(37.7620342994705, -122.405370986778)

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