Street_Tree_List

9 rows where DBH = 4 and qSpecies = 73

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
48188	48188	117156	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	701 Pennsylvania Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	4	3x3	6014458.776219999	2103767.54398	37.7573577456892	-122.392992112005	(37.7573577456892, -122.392992112005)
58655	58655	202021	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	1330 Fitzgerald Ave	3	: 4	Tree 1	Private 1	4	Width 3ft	6013834.37055	2091185.2446599999	37.722774667999	-122.39427065747101	(37.722774667999, -122.394270657471)
63152	63152	177453	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	1651 San Jose Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	4	Width 2ft	6001481.52618	2094146.78927	37.7302120154671	-122.437183661494	(37.7302120154671, -122.437183661494)
63489	63489	177454	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	1651 San Jose Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	4	Width 2ft	6001501.639719999	2094151.35591	37.730225697742796	-122.43711445328998	(37.7302256977428, -122.43711445329)
71026	71026	230404	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	995 Potrero Ave	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	4	Width 3ft	6010493.00859	2104414.71875	37.7589136546545	-122.406752977672	(37.7589136546545, -122.406752977672)
135447	135447	193437	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	420 Bay Shore Blvd	1	: 4	Tree 1	Private 1	4	Width 3ft	6010286.5563	2097785.62722	37.7407000755616	-122.40699974536501	(37.7407000755616, -122.406999745365)
154854	154854	177455	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	1651 San Jose Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	4	Width 2ft	6001518.96973	2094154.72477	37.7302359329302	-122.43705478235701	(37.7302359329302, -122.437054782357)
167491	167491	230403	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	995 Potrero Ave	10	: 4	Tree 1	Private 1	4	Width 2ft	6010508.06667	2104211.71419	37.758357092123106	-122.406686593337	(37.7583570921231, -122.406686593337)
183229	183229	230418	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	1301 San Jose Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	4	Width 3ft	6003572.46167	2095485.4349900002	37.7340062713591	-122.43005048006701	(37.7340062713591, -122.430050480067)

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