Street_Tree_List

9 rows where qAddress = "1098 Esmeralda Ave", qSiteInfo = 17 and qSpecies = 103

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	XCoord	YCoord	Latitude	Longitude	Location
25982	25982	247919	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1098 Esmeralda Ave	4	Side Yard : Yard 17	Tree 1	Private 1	22	6010242.48982	2098715.3752200003	37.743250496220895	-122.40721763491001	(37.7432504962209, -122.40721763491)
30032	30032	247924	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1098 Esmeralda Ave	9	Side Yard : Yard 17	Tree 1	Private 1	23	6010297.695230001	2098727.78354	37.7432876562154	-122.40702762254499	(37.7432876562154, -122.407027622545)
46194	46194	247925	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1098 Esmeralda Ave	10	Side Yard : Yard 17	Tree 1	Private 1	25	6010304.27631	2098731.76841	37.743298966077795	-122.407005147582	(37.7432989660778, -122.407005147582)
59867	59867	247926	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1098 Esmeralda Ave	11	Side Yard : Yard 17	Tree 1	Private 1	27	6010312.05046	2098736.31721	37.743311891127604	-122.406978587005	(37.7433118911276, -122.406978587005)
62115	62115	247923	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1098 Esmeralda Ave	8	Side Yard : Yard 17	Tree 1	Private 1	17	6010288.87158	2098729.72842	37.7432925026595	-122.40705826963699	(37.7432925026595, -122.407058269637)
70884	70884	247927	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1098 Esmeralda Ave	12	Side Yard : Yard 17	Tree 1	Private 1	34	6010318.55961	2098736.7728	37.7433135063186	-122.40695611204501	(37.7433135063186, -122.406956112045)
147007	147007	247922	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1098 Esmeralda Ave	7	Side Yard : Yard 17	Tree 1	Private 1	24	6010270.948580001	2098720.09099	37.7432650373678	-122.40711956383001	(37.7432650373678, -122.40711956383)
150294	150294	247917	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1098 Esmeralda Ave	2	Side Yard : Yard 17	Tree 1	Private 1	32	6010231.88216	2098716.76824	37.7432537274832	-122.407254411775	(37.7432537274832, -122.407254411775)
169544	169544	247921	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1098 Esmeralda Ave	6	Side Yard : Yard 17	Tree 1	Private 1	38	6010260.8237	2098716.17835	37.7432537274883	-122.407154297447	(37.7432537274883, -122.407154297447)

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