Street_Tree_List

12 rows where PlotSize = "Width 6ft" and qSpecies = 27

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
31001	31001	176999	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	906 Edinburgh St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	1	Width 6ft	6001595.86635	2088796.01268	37.7155264893371	-122.436405562669	(37.7155264893371, -122.436405562669)
35498	35498	129498	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	855 Chestnut St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1	20	Width 6ft	6007778.02269	2120584.45961	37.803159586216395	-122.417288546245	(37.8031595862164, -122.417288546245)
54071	54071	207232	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	226 Thrift St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1	2	Width 6ft	5994766.53745	2089660.64097	37.7175101320775	-122.46007322780301	(37.7175101320775, -122.460073227803)
59888	59888	177028	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	164 Baltimore Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	7	Width 6ft	6002357.56159	2086195.5289200002	37.7084293823926	-122.433587065817	(37.7084293823926, -122.433587065817)
59995	59995	226605	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	276 Bemis St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1	6	Width 6ft	6002989.382569999	2096277.75645	37.7361487649474	-122.432122925433	(37.7361487649474, -122.432122925433)
70030	70030	177026	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	501 Sweeny St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1	3	Width 6ft	6008206.81715	2094351.9900900002	37.7311554564421	-122.41394787781601	(37.7311554564421, -122.413947877816)
116496	116496	177009	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	425 Cayuga Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1	7	Width 6ft	6002141.25462	2093891.34658	37.729548108055	-122.434884635528	(37.729548108055, -122.434884635528)
135933	135933	176997	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	131 Farragut Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1	3	Width 6ft	5997268.75573	2087384.8014900002	37.7114048037631	-122.451260209013	(37.7114048037631, -122.451260209013)
162033	162033	129497	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	855 Chestnut St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1	16	Width 6ft	6007750.73846	2120580.85704	37.803148159410604	-122.417382708871	(37.8031481594106, -122.417382708871)
166888	166888	207141	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	1832 17th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1	7	Width 6ft	5990964.44749	2102904.31775	37.7536544876696	-122.474180983561	(37.7536544876696, -122.474180983561)
168553	168553	191409	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	1201 20th St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1	1	Width 6ft	6014316.155809999	2104772.8809	37.760110260198495	-122.39355571261999	(37.7601102601985, -122.39355571262)
182658	182658	129487	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	3310 Baker St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1	9	Width 6ft	5999338.381580001	2120194.27566	37.8016098133151	-122.446465960942	(37.8016098133151, -122.446465960942)

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