Street_Tree_List

10 rows where PlotSize = "Width 1ft" and qSiteInfo = 2 sorted by qCareAssistant

Search:

descending

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
23910	23910	118018	Undocumented 2	Cordyline australis :: Dracena Palm 141	492 37th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	5	Width 1ft	5984413.88926	2112528.9426700003	37.779699331346	-122.49754445899099	(37.779699331346, -122.497544458991)
34790	34790	237110	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	380 Lexington St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	6	Width 1ft	6006531.04727	2103908.9188900003	37.7573023708184	-122.420419415431	(37.7573023708184, -122.420419415431)
41517	41517	218917	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	113 Edgehill Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	3	Width 1ft	5994873.89414	2098975.72105	37.7430932497504	-122.46037670942499	(37.7430932497504, -122.460376709425)
47019	47019	244022	Undocumented 2	:: 54	420 Dolores St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	0	Width 1ft	6004861.89835	2105875.95275	37.762609178502004	-122.42633203700599	(37.762609178502, -122.426332037006)
69004	69004	175219	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	100 Morse St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	1	Width 1ft	6000840.49126	2087951.89335	37.7131657752649	-122.43895601391199	(37.7131657752649, -122.438956013912)
134948	134948	178732	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	100 Morse St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	6	Width 1ft	6000912.22914	2087974.06631	37.713230738679705	-122.43870965184601	(37.7132307386797, -122.438709651846)
149450	149450	178733	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	100 Morse St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	5	Width 1ft	6000880.0864	2087963.6418299999	37.713200286736495	-122.438820001354	(37.7132002867365, -122.438820001354)
153235	153235	218920	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	113 Edgehill Way	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	3	Width 1ft	5994843.7095	2098965.85604	37.7430644264715	-122.460480364392	(37.7430644264715, -122.460480364392)
172071	172071	218918	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	113 Edgehill Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	3	Width 1ft	5994865.26411	2098972.62162	37.743084243041004	-122.46040632501001	(37.743084243041, -122.46040632501)
181226	181226	218919	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	113 Edgehill Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	3	Width 1ft	5994856.64782	2098970.17763	37.7430770367894	-122.46043594056101	(37.7430770367894, -122.460435940561)

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