Street_Tree_List

9 rows where DBH = 5, qSiteInfo = 2 and qSpecies = 27

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
32289	32289	207308	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	40 Hazelwood Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	5	Width 3ft	5996630.86084	2093949.68597	37.7293938887121	-122.453938729108	(37.7293938887121, -122.453938729108)
42179	42179	207304	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	53 Hazelwood Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	5	Width 3ft	5996585.7495	2094006.0145	37.72954596675461	-122.454098749052	(37.7295459667546, -122.454098749052)
46244	46244	250337	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	21 25th Ave North	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	5	Width 5ft	5987995.71435	2115876.11718	37.7890990187437	-122.485399212222	(37.7890990187437, -122.485399212222)
74649	74649	207296	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	217 Colon Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	5	Width 3ft	5996041.08515	2094289.8634799998	37.7302941010767	-122.456002210028	(37.7302941010767, -122.456002210028)
138152	138152	226584	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	116 Franconia St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	5		6010066.87681	2099747.40872	37.746074405213704	-122.40789762220301	(37.7460744052137, -122.407897622203)
147662	147662	207305	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	45 Hazelwood Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	5	Width 3ft	5996586.90838	2093990.0061299999	37.7295020780524	-122.454093586973	(37.7295020780524, -122.454093586973)
149640	149640	207307	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	40 Hazelwood Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	5	Width 3ft	5996632.29133	2093946.6824400001	37.7293857237559	-122.453933566973	(37.7293857237559, -122.453933566973)
174436	174436	207180	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	451 Ulloa St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	5	Width 4ft	5995332.94317	2098244.11673	37.7411108417945	-122.458736498001	(37.7411108417945, -122.458736498001)
175637	175637	129490	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	2536 Baker St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	5	Width 4ft	5999691.42103	2117587.23687	37.794471737733105	-122.44505675927401	(37.7944717377331, -122.445056759274)

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