Street_Tree_List

8 rows where qAddress = "100 Alemany Blvd", qSiteInfo = 2 and qSpecies = 48

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
33343	33343	227094	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Alemany Blvd	35	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	2		6009153.630890001	2095762.56962	37.7350817355269	-122.410774146024	(37.7350817355269, -122.410774146024)
33605	33605	227093	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Alemany Blvd	31	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	3	Width 9ft	6009184.481319999	2095791.0539799999	37.7351616771725	-122.41066949551201	(37.7351616771725, -122.410669495512)
41197	41197	227088	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Alemany Blvd	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	2	Width 5ft	6009533.30641	2096029.17809	37.7358350661275	-122.409480276115	(37.7358350661275, -122.409480276115)
59198	59198	227086	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Alemany Blvd	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	4	Width 5ft	6009619.77164	2096165.8193400002	37.7362150980513	-122.409190969587	(37.7362150980513, -122.409190969587)
134809	134809	227089	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Alemany Blvd	17	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	2	Width 4ft	6009456.29094	2095946.4902299999	37.735603707435395	-122.409740715285	(37.7356037074354, -122.409740715285)
170337	170337	227090	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Alemany Blvd	22	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	8	Width 3ft	6009411.625	2095915.20486	37.7355153013828	-122.40989293540702	(37.7355153013828, -122.409892935407)
171127	171127	227091	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Alemany Blvd	29	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	8	Width 5ft	6009293.034440001	2095834.7354700002	37.735287702767	-122.410297269721	(37.735287702767, -122.410297269721)
171469	171469	227092	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Alemany Blvd	30	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	3	Width 9ft	6009197.49082	2095788.0482299998	37.7351541534232	-122.410624304588	(37.7351541534232, -122.410624304588)

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