Street_Tree_List

9 rows where DBH = 10 and qSpecies = 110

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
27575	27575	52011	Permitted Site 1	Pittosporum eugenioides :: Tarata 110	427 38th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	10		Permit Number 48229	5984051.86025	2112939.27176	37.7808047486161	-122.498827177749	(37.7808047486161, -122.498827177749)
30321	30321	132368	Undocumented 2	Pittosporum eugenioides :: Tarata 110	3100 Lyon St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1	10	Width 10ft		5999060.82328	2119520.3698400003	37.7997435923452	-122.44737790226999	(37.7997435923452, -122.44737790227)
41431	41431	132390	Undocumented 2	Pittosporum eugenioides :: Tarata 110	1468 Greenwich St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1	10	Width 2ft		6005781.1261599995	2119669.33652	37.8005343437344	-122.42413375038099	(37.8005343437344, -122.424133750381)
56246	56246	123354	Undocumented 2	Pittosporum eugenioides :: Tarata 110	706 04th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	10	Width 4ft		5994755.71822	2110691.45516	37.7752548415612	-122.46163457142099	(37.7752548415612, -122.461634571421)
74152	74152	211439	DPW Maintained 3	Pittosporum eugenioides :: Tarata 110	200x Terrace Dr	25	Median : Yard 3	Tree 1	DPW 2	10			5993818.11195	2096542.33136	37.7363509793232	-122.46385070234699	(37.7363509793232, -122.463850702347)
74625	74625	211440	DPW Maintained 3	Pittosporum eugenioides :: Tarata 110	200x Terrace Dr	26	Median : Yard 3	Tree 1	DPW 2	10			5993816.62133	2096536.73465	37.736335526247295	-122.463855449888	(37.7363355262473, -122.463855449888)
137876	137876	211442	DPW Maintained 3	Pittosporum eugenioides :: Tarata 110	200x Terrace Dr	28	Median : Yard 3	Tree 1	DPW 2	10			5993811.3668	2096539.9849900003	37.736344148068106	-122.463873852703	(37.7363441480681, -122.463873852703)
155644	155644	194584	Undocumented 2	Pittosporum eugenioides :: Tarata 110	1698 Galvez Ave	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1	10	Width 8ft		6015435.57046	2098024.5169599997	37.7416428069711	-122.389212935026	(37.7416428069711, -122.389212935026)
176305	176305	123898	Undocumented 2	Pittosporum eugenioides :: Tarata 110	107 11th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	10	Width 3ft		5992390.460969999	2114751.88478	37.786267240143204	-122.47011219103901	(37.7862672401432, -122.470112191039)

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