Street_Tree_List

10 rows where qAddress = "401 Ocean Ave" and qCaretaker = 6

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
3799	3799	178336	Significant Tree 6	Pinus radiata :: Monterey Pine 3	401 Ocean Ave	2	Sidewalk: Property side : Yard 9	Tree 1	MTA 6	29	Width 8ft	5998664.9682	2091522.93582	37.722847017548204	-122.44673211618999	(37.7228470175482, -122.44673211619)
3801	3801	177109	Significant Tree 6	Ligustrum lucidum :: Glossy Privet 55	401 Ocean Ave	16	Sidewalk: Property side : Yard 9	Tree 1	MTA 6	6	Width 5ft	5998958.08532	2091518.52367	37.72285164275971	-122.445718558684	(37.7228516427597, -122.445718558684)
3803	3803	178335	Significant Tree 6	Pinus radiata :: Monterey Pine 3	401 Ocean Ave	1	Sidewalk: Property side : Yard 9	Tree 1	MTA 6	33	Width 8ft	5998656.04486	2091523.1214700001	37.72284701755029	-122.44676297552601	(37.7228470175503, -122.446762975526)
3805	3805	177105	Significant Tree 6	Ligustrum lucidum :: Glossy Privet 55	401 Ocean Ave	12	Sidewalk: Property side : Yard 9	Tree 1	MTA 6	4	Width 5ft	5998924.5969	2091518.7811599998	37.7228504376811	-122.445834339179	(37.7228504376811, -122.445834339179)
3806	3806	177110	Significant Tree 6	Ligustrum lucidum :: Glossy Privet 55	401 Ocean Ave	17	Sidewalk: Property side : Yard 9	Tree 1	MTA 6	6	Width 5ft	5998978.57855	2091518.5364400002	37.722852847868	-122.445647719081	(37.722852847868, -122.445647719081)
3808	3808	177108	Significant Tree 6	Ligustrum lucidum :: Glossy Privet 55	401 Ocean Ave	15	Sidewalk: Property side : Yard 9	Tree 1	MTA 6	5	Width 5ft	5998950.80755	2091518.23612	37.7228504376851	-122.44574369563999	(37.7228504376851, -122.44574369564)
3811	3811	177743	Significant Tree 6	Metrosideros excelsa :: New Zealand Xmas Tree 2	401 Ocean Ave	4	Sidewalk: Property side : Yard 9	Tree 1	MTA 6	37		5998700.41574	2091522.98281	37.722849171448395	-122.446609585371	(37.7228491714484, -122.446609585371)
3818	3818	178337	Significant Tree 6	Pinus radiata :: Monterey Pine 3	401 Ocean Ave	3	Sidewalk: Property side : Yard 9	Tree 1	MTA 6	29		5998676.28102	2091524.0079700002	37.7228506076618	-122.44669308741301	(37.7228506076618, -122.446693087413)
3826	3826	177104	Significant Tree 6	Ligustrum lucidum :: Glossy Privet 55	401 Ocean Ave	11	Sidewalk: Property side : Yard 9	Tree 1	MTA 6	4	Width 5ft	5998921.0818300005	2091519.29315	37.722851642780796	-122.44584652679501	(37.7228516427808, -122.445846526795)
3827	3827	177106	Significant Tree 6	Ligustrum lucidum :: Glossy Privet 55	401 Ocean Ave	13	Sidewalk: Property side : Yard 9	Tree 1	MTA 6	7	Width 5ft	5998933.177730001	2091518.16383	37.7228492325857	-122.44580463279199	(37.7228492325857, -122.445804632792)

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