Street_Tree_List

9 rows where PlotSize = "Width 1ft" and qSpecies = 4

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
4	4	207368	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	920 Kirkham St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	6	Width 1ft	5992009.48044	2105269.9271	37.760210314285004	-122.47073935813	(37.760210314285, -122.47073935813)
31087	31087	119029	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	767 44th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	6	Width 1ft	5982273.77271	2110527.62617	37.7740786267097	-122.504799591882	(37.7740786267097, -122.504799591882)
42762	42762	226645	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	3626 24th St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1	8	Width 1ft	6005580.70423	2101999.04422	37.752004698476206	-122.42357029633301	(37.7520046984762, -122.423570296333)
45441	45441	119030	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	767 44th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	10	Width 1ft	5982272.9223	2110539.10892	37.774110104964706	-122.50480338457301	(37.7741101049647, -122.504803384573)
48699	48699	129547	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	13 Miller Pl	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	4	Width 1ft	6010075.14286	2116919.1763	37.7932245849005	-122.40908048339399	(37.7932245849005, -122.409080483394)
49684	49684	129501	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2857 Union St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1	3	Width 1ft	5999309.06977	2118008.46724	37.795606494203604	-122.446410054597	(37.7956064942036, -122.446410054597)
52675	52675	191422	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	518 Rhode Island St	1	: 4	Tree 1	Private 1	6	Width 1ft	6011739.544919999	2105950.9895099998	37.763201579013796	-122.402549877375	(37.7632015790138, -122.402549877375)
55659	55659	129546	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	13 Miller Pl	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	3	Width 1ft	6010072.19276	2116933.78445	37.7932645300763	-122.40909172222099	(37.7932645300763, -122.409091722221)
161992	161992	129502	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2857 Union St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1	3	Width 1ft	5999324.2861	2118011.40576	37.7956154316639	-122.44635761511499	(37.7956154316639, -122.446357615115)

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