Street_Tree_List

8 rows where PlotSize = "Width 4ft" and qSpecies = 86

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
23421	23421	195972	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	18	Back Yard : Yard 13	Tree 1	Private 1	10	Width 4ft	6015355.8319	2100319.8042599997	37.7479407691514	-122.389648918288	(37.7479407691514, -122.389648918288)
42525	42525	195977	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	23	Back Yard : Yard 13	Tree 1	Private 1	5	Width 4ft	6015256.877230001	2100313.90806	37.7479190918917	-122.389990690329	(37.7479190918917, -122.389990690329)
49446	49446	195978	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	24	Back Yard : Yard 13	Tree 1	Private 1	9	Width 4ft	6015236.23042	2100312.22008	37.747913311958605	-122.390061968785	(37.7479133119586, -122.390061968785)
61234	61234	195975	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	21	Back Yard : Yard 13	Tree 1	Private 1	9	Width 4ft	6015294.9834	2100316.47199	37.747928245201	-122.389859098828	(37.747928245201, -122.389859098828)
147625	147625	195976	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	22	Back Yard : Yard 13	Tree 1	Private 1	5	Width 4ft	6015275.57642	2100315.1093900003	37.7479234275315	-122.38992611271401	(37.7479234275315, -122.389926112714)
171288	171288	195971	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	17	Back Yard : Yard 13	Tree 1	Private 1	10	Width 4ft	6015377.86647	2100320.4119700002	37.7479436595871	-122.389572765484	(37.7479436595871, -122.389572765484)
171805	171805	195974	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	20	Back Yard : Yard 13	Tree 1	Private 1	12	Width 4ft	6015315.44713	2100317.81293	37.7479330619596	-122.389788429193	(37.7479330619596, -122.389788429193)
173877	173877	195973	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	19	Back Yard : Yard 13	Tree 1	Private 1	10	Width 4ft	6015335.01264	2100318.2949099997	37.747935470342895	-122.38972080559601	(37.7479354703429, -122.389720805596)

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