Street_Tree_List

10 rows where PlotSize = "Width 0ft", qSiteInfo = 11 and qSpecies = 75

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
27550	27550	217457	DPW Maintained 3	Washingtonia robusta :: Mexican Fan Palm 75	1x Minerva St	18	Median : Cutout 11	Tree 1	DPW 2	20	Width 0ft	5996170.11239	2089001.42717	37.7157807141869	-122.455174130483	(37.7157807141869, -122.455174130483)
32721	32721	217463	DPW Maintained 3	Washingtonia robusta :: Mexican Fan Palm 75	1x Minerva St	50	Median : Cutout 11	Tree 1	DPW 2	17	Width 0ft	5996525.6642	2088997.67416	37.7157908018682	-122.45394491554701	(37.7157908018682, -122.453944915547)
50630	50630	217460	DPW Maintained 3	Washingtonia robusta :: Mexican Fan Palm 75	1x Minerva St	40	Median : Cutout 11	Tree 1	DPW 2	18	Width 0ft	5996389.15784	2088998.26407	37.715784593857606	-122.454416784407	(37.7157845938576, -122.454416784407)
52430	52430	217461	DPW Maintained 3	Washingtonia robusta :: Mexican Fan Palm 75	1x Minerva St	41	Median : Cutout 11	Tree 1	DPW 2	11	Width 0ft	5996430.050430001	2088999.1612900002	37.7157894025409	-122.454275506331	(37.7157894025409, -122.454275506331)
160884	160884	217455	DPW Maintained 3	Washingtonia robusta :: Mexican Fan Palm 75	1x Minerva St	14	Median : Cutout 11	Tree 1	DPW 2	21	Width 0ft	5996102.296490001	2089002.27895	37.7157791619582	-122.455408593627	(37.7157791619582, -122.455408593627)
165812	165812	217459	DPW Maintained 3	Washingtonia robusta :: Mexican Fan Palm 75	1x Minerva St	29	Median : Cutout 11	Tree 1	DPW 2	16	Width 0ft	5996291.57105	2089000.5851900002	37.715785369974796	-122.45475425500099	(37.7157853699748, -122.454754255001)
170196	170196	217458	DPW Maintained 3	Washingtonia robusta :: Mexican Fan Palm 75	1x Minerva St	27	Median : Cutout 11	Tree 1	DPW 2	22	Width 0ft	5996270.87292	2089001.5829099999	37.7157869222056	-122.454825868913	(37.7157869222056, -122.454825868913)
174465	174465	217456	DPW Maintained 3	Washingtonia robusta :: Mexican Fan Palm 75	1x Minerva St	15	Median : Cutout 11	Tree 1	DPW 2	20	Width 0ft	5996127.26791	2089002.03978	37.715779938072295	-122.455322264126	(37.7157799380723, -122.455322264126)
179057	179057	217462	DPW Maintained 3	Washingtonia robusta :: Mexican Fan Palm 75	1x Minerva St	48	Median : Cutout 11	Tree 1	DPW 2	16	Width 0ft	5996487.36469	2088998.4739599999	37.7157908018916	-122.454077353311	(37.7157908018916, -122.454077353311)
180976	180976	217454	DPW Maintained 3	Washingtonia robusta :: Mexican Fan Palm 75	1x Minerva St	11	Median : Cutout 11	Tree 1	DPW 2	17	Width 0ft	5996047.542640001	2089003.42322	37.7157791619486	-122.45559792969601	(37.7157791619486, -122.455597929696)

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