Street_Tree_List

9 rows where DBH = 2 and qSpecies = 126

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
35088	35088	221988	Undocumented 2	Albizia julibrissin :: Mimosa Silk Tree 126	90 Bartlett St	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	2	Width 3ft	6006638.42684	2103473.9657900003	37.7561141406682	-122.420017188263	(37.7561141406682, -122.420017188263)
44841	44841	187973	Undocumented 2	Albizia julibrissin :: Mimosa Silk Tree 126	1814 Illinois St	1	: 4	Tree 1	Private 1	2	Width 6ft	6016258.63636	2100595.19225	37.7487469466117	-122.386546230235	(37.7487469466117, -122.386546230235)
45501	45501	221986	Undocumented 2	Albizia julibrissin :: Mimosa Silk Tree 126	90 Bartlett St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	2	Width 3ft	6006634.40739	2103532.5435099998	37.7562747551033	-122.420035245751	(37.7562747551033, -122.420035245751)
62199	62199	221983	Undocumented 2	Albizia julibrissin :: Mimosa Silk Tree 126	90 Bartlett St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	2	Width 3ft	6006631.91711	2103614.748	37.75650032934	-122.420049691544	(37.75650032934, -122.420049691544)
149410	149410	221985	Undocumented 2	Albizia julibrissin :: Mimosa Silk Tree 126	90 Bartlett St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	2	Width 3ft	6006632.52814	2103555.46037	37.756337573629	-122.42004337111601	(37.756337573629, -122.420043371116)
151390	151390	221987	Undocumented 2	Albizia julibrissin :: Mimosa Silk Tree 126	90 Bartlett St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	2	Width 3ft	6006637.6448	2103499.45975	37.7561840971364	-122.42002170193999	(37.7561840971364, -122.42002170194)
156710	156710	221990	Undocumented 2	Albizia julibrissin :: Mimosa Silk Tree 126	90 Bartlett St	15	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	2	Width 3ft	6006641.795030001	2103432.2247	37.7559997190345	-122.420002577883	(37.7559997190345, -122.420002577883)
185763	185763	221981	Undocumented 2	Albizia julibrissin :: Mimosa Silk Tree 126	90 Bartlett St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	2	Width 3ft	6006627.76439	2103666.8286200003	37.756643096715706	-122.420067749029	(37.7566430967157, -122.420067749029)
188598	188598	221997	Undocumented 2	Albizia julibrissin :: Mimosa Silk Tree 126	3573 19th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	2	Width 4ft	6005789.27055	2104883.87542	37.7599375444968	-122.423054069317	(37.7599375444968, -122.423054069317)

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