Street_Tree_List

17 rows where DBH = 11 and qSpecies = 75 sorted by PlantDate

Search:

descending

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	PlantDate ▼	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
334	334	246360	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	1932 Mission St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11	Width 0ft		6006755.8259	2107130.7038	37.76616130474321	-122.419870652653	(37.7661613047432, -122.419870652653)
25234	25234	244842	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	41 Bartlett St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11	Width 6ft		6006681.50629	2103383.71332	37.755868755243704	-122.419861800707	(37.7558687552437, -122.419861800707)
28387	28387	199462	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	1530 03rd St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11	Width 5ft		6015592.103080001	2107492.64638	37.7676489630463	-122.389332708559	(37.7676489630463, -122.389332708559)
36738	36738	181277	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	0 Gonzalez Dr	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		11			5988402.74919	2089827.8491900002	37.7176011677477	-122.482081905481	(37.7176011677477, -122.482081905481)
44790	44790	244846	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	90 Bartlett St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		11	Width 8ft		6006641.954969999	2103569.5656	37.75637683445171	-122.42001177073901	(37.7563768344517, -122.420011770739)
48660	48660	243926	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	41 Bartlett St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1		11	Width 6ft		6006689.91006	2103386.78803	37.7558776711221	-122.41983295584299	(37.7558776711221, -122.419832955843)
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)
59728	59728	244843	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	90 Bartlett St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		11	Width 9ft		6006632.98295	2103729.04135	37.7568142125173	-122.4200541162	(37.7568142125173, -122.4200541162)
60927	60927	243928	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	183 29th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11	Width 3ft		6005387.06281	2099017.63808	37.7438075093185	-122.424027939731	(37.7438075093185, -122.424027939731)
62394	62394	243927	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	183 29th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11	Width 3ft		6005367.86151	2099016.78698	37.7438040882932	-122.424094272857	(37.7438040882932, -122.424094272857)
129506	129506	246377	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	1984 Mission St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11	Width 0ft		6006769.0905	2106843.1456	37.7653724848572	-122.419804366614	(37.7653724848572, -122.419804366614)
130520	130520	181272	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	4061 19th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1		11	Width 4ft		5991602.94551	2088924.16966	37.7153054953149	-122.47095459108299	(37.7153054953149, -122.470954591083)
153721	153721	203181	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	1900 03rd St	24	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11	Width 5ft		6015653.76081	2106475.1848299997	37.7648586527362	-122.389048392363	(37.7648586527362, -122.389048392363)
156730	156730	181275	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	0 Gonzalez Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		11			5988424.04089	2089826.4329400002	37.7175985174299	-122.482008206935	(37.7175985174299, -122.482008206935)
168519	168519	181276	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	0 Gonzalez Dr	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		11			5988413.87941	2089827.13064	37.7175998421416	-122.482043381217	(37.7175998421416, -122.482043381217)
189056	189056	246366	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	1940 Mission St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11	Width 0ft		6006763.6807	2106952.0622	37.7656712394659	-122.419830807079	(37.7656712394659, -122.419830807079)
1518	1518	243948	Permitted Site 1	Washingtonia robusta :: Mexican Fan Palm 75	10 South Van Ness Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	07/14/2004 12:00:00 AM	11	Width 5ft	Permit Number 47529	6006987.09759	2110205.04369	37.774615739356705	-122.41928883630399	(37.7746157393567, -122.419288836304)

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