Street_Tree_List

11 rows where qSiteInfo = 2 and qSpecies = 59

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
29051	29051	181932	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2378 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	18	Width 0ft	5985195.246	2099024.2764	37.74266505256279	-122.49384596323	(37.7426650525628, -122.49384596323)
38088	38088	142102	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	900 Fell St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	14	Width 0ft	6003042.617000001	2110331.1771	37.7747391304954	-122.43294257823798	(37.7747391304954, -122.432942578238)
39439	39439	181853	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2318 32nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	4	Width 0ft	5986420.3329	2099445.95	37.7438944556176	-122.48964102637699	(37.7438944556176, -122.489641026377)
39552	39552	141364	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	451 BRODERICK ST	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	13	Width 0ft	6001150.566000001	2110292.0606	37.7745242278003	-122.439484748915	(37.7745242278003, -122.439484748915)
41163	41163	181854	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2318 32nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	6	Width 0ft	5986419.9945	2099457.4563	37.7439260290789	-122.48964304245001	(37.7439260290789, -122.48964304245)
55308	55308	139484	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1216 FULTON ST	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	18	Width 0ft	6001778.449	2111192.2794	37.7770317168845	-122.437377258879	(37.7770317168845, -122.437377258879)
65375	65375	200196	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1124 Fitzgerald Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	20	Width 0ft	6015063.1024	2090263.455	37.720311838731	-122.38995879887301	(37.720311838731, -122.389958798873)
68579	68579	138831	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	745 BUCHANAN ST	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	15	Width 0ft	6004451.1778	2111098.9724	37.7769271009021	-122.428124806353	(37.7769271009021, -122.428124806353)
134981	134981	182109	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2443 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	5	Width 0ft	5987643.897000001	2098649.745	37.741779647708995	-122.48535186527599	(37.741779647709, -122.485351865276)
159251	159251	183822	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2235 27th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	4	Width 0ft	5987905.4957	2100075.9969	37.7457109948541	-122.484551945811	(37.7457109948541, -122.484551945811)
159508	159508	141351	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	457 BRODERICK ST	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	16	Width 0ft	6001146.5934	2110320.3656	37.774601720124295	-122.43950052034701	(37.7746017201243, -122.439500520347)

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