Street_Tree_List

10 rows where PlotSize = "Width 5ft" and qSpecies = 91

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
56231	56231	228455	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	2701 17th St	7	: 4	Tree 1	Private 1	1	Width 5ft	6009383.67351	2106374.02164	37.7642313225287	-122.410727961341	(37.7642313225287, -122.410727961341)
57920	57920	228456	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	2701 17th St	8	: 4	Tree 1	Private 1	1	Width 5ft	6009403.2734199995	2106375.12773	37.7642354585115	-122.410660248687	(37.7642354585115, -122.410660248687)
68876	68876	228449	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	2701 17th St	1	: 4	Tree 1	Private 1	1	Width 5ft	6009256.91005	2106366.76259	37.76420428262279	-122.411165888909	(37.7642042826228, -122.411165888909)
73664	73664	228453	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	2701 17th St	5	: 4	Tree 1	Private 1	1	Width 5ft	6009339.05918	2106371.48119	37.7642218454873	-122.41088209075899	(37.7642218454873, -122.410882090759)
74581	74581	228446	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	379 Haight St	1	: 4	Tree 1	Private 1	5	Width 5ft	6004344.901769999	2109415.2001400003	37.7722978608825	-122.428372409862	(37.7722978608825, -122.428372409862)
149630	149630	228454	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	2701 17th St	6	: 4	Tree 1	Private 1	1	Width 5ft	6009362.10361	2106372.48972	37.7642259068175	-122.410802457572	(37.7642259068175, -122.410802457572)
153175	153175	228452	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	2701 17th St	4	: 4	Tree 1	Private 1	1	Width 5ft	6009318.2366	2106370.18067	37.7642171069559	-122.41095401853799	(37.7642171069559, -122.410954018538)
160222	160222	228451	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	2701 17th St	3	: 4	Tree 1	Private 1	1	Width 5ft	6009297.41402	2106368.8801700003	37.7642123684355	-122.411025946309	(37.7642123684355, -122.411025946309)
166771	166771	228450	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	2701 17th St	2	: 4	Tree 1	Private 1	1	Width 5ft	6009278.09164	2106368.2886	37.764209660560205	-122.41109273536699	(37.7642096605602, -122.411092735367)
188130	188130	228457	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	2701 17th St	9	: 4	Tree 1	Private 1	1	Width 5ft	6009423.8763	2106376.9257400003	37.7642415505399	-122.410589115888	(37.7642415505399, -122.410589115888)

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