Street_Tree_List

8 rows where PlotSize = "Width 10ft", SiteOrder = 2 and qSpecies = 27

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
31369	31369	207346	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	628 Edna St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1	4	Width 10ft	5998595.0741	2094889.9944099998	37.7320881793139	-122.44721593437201	(37.7320881793139, -122.447215934372)
63586	63586	207359	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	149 Staples Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1	5	Width 10ft	5999079.1567400005	2093759.91373	37.729012890930704	-122.445461131336	(37.7290128909307, -122.445461131336)
134996	134996	207348	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	359 Melrose Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1	4	Width 10ft	5997745.23089	2095505.757	37.733730320683605	-122.450198383048	(37.7337303206836, -122.450198383048)
136134	136134	207263	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	582 Ramsell St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1	5	Width 10ft	5993025.1293	2091125.2182900002	37.7214311932731	-122.46619880075899	(37.7214311932731, -122.466198800759)
150333	150333	207234	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	422 Orizaba Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1	1	Width 10ft	5994046.18721	2089200.86778	37.716206246401896	-122.462529797908	(37.7162062464019, -122.462529797908)
184301	184301	207208	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	101 Foerster St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1	6	Width 10ft	5998074.52147	2093832.4092700002	37.7291545431359	-122.44893943651199	(37.7291545431359, -122.448939436512)
186764	186764	207347	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	383 Melrose Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1	17	Width 10ft	5997585.73238	2095504.5869999998	37.73371797929771	-122.45074972953002	(37.7337179792977, -122.45074972953)
188039	188039	207335	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	114 Melrose Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1	3	Width 10ft	5999338.03809	2095537.4927400001	37.7339084817987	-122.444693877414	(37.7339084817987, -122.444693877414)

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