Street_Tree_List

9 rows where PlotSize = "Width 8ft" and qSpecies = 27

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
3187	3187	207331	Permitted Site 1	Leptospermum scoparium :: New Zealand Tea Tree 27	432 Congo St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1	07/05/2002 12:00:00 AM	8	Width 8ft	Permit Number 45704	6000124.74065	2095150.49618	37.7328907415174	-122.441946248045	(37.7328907415174, -122.441946248045)
30975	30975	227700	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	276 Bemis St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1		7	Width 8ft		6002994.65302	2096282.17867	37.7361612061647	-122.432105019051	(37.7361612061647, -122.432105019051)
63970	63970	227703	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	200 Kingston St	10	Front Yard : Yard 7	Tree 1	Private 1		10	Width 8ft		6006269.2438199995	2098023.2428599996	37.7411268910989	-122.420906974789	(37.7411268910989, -122.420906974789)
67340	67340	246731	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	101 Ripley St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1		8	Width 8ft		6008584.453369999	2099107.91594	37.7442353941634	-122.41297845991001	(37.7442353941634, -122.41297845991)
68812	68812	207209	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	342 Edna St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1		5	Width 8ft		5998785.841580001	2094004.8345400002	37.7296686369961	-122.446492753553	(37.7296686369961, -122.446492753553)
73346	73346	226593	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	4301 26th St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1		4	Width 8ft		6001851.9880099995	2100572.11343	37.7478755125637	-122.43636260477301	(37.7478755125637, -122.436362604773)
147919	147919	226594	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	4301 26th St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1		7	Width 8ft		6001878.86211	2100572.13278	37.747877092657795	-122.43626967691799	(37.7478770926578, -122.436269676918)
159577	159577	226592	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	4301 26th St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1		1	Width 8ft		6001848.149780001	2100568.16422	37.7478644508775	-122.43637559457198	(37.7478644508775, -122.436375594572)
186793	186793	177018	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	401 Ocean Ave	21	Sidewalk: Property side : Yard 9	Tree 1	Private 1		7	Width 8ft		5999065.383280001	2091517.8288599998	37.722855860592105	-122.44534760363399	(37.7228558605921, -122.445347603634)

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