Street_Tree_List

13 rows where qSiteInfo = 2 and qSpecies = 110

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
26572	26572	132381	Undocumented 2	Pittosporum eugenioides :: Tarata 110	1713 Taylor St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	7	Width 4ft	6008727.871259999	2118754.69526	37.7981889019448	-122.413872046978	(37.7981889019448, -122.413872046978)
30813	30813	233972	Undocumented 2	Pittosporum eugenioides :: Tarata 110	242 Upper Ter	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	12	Width 4ft	5999499.278059999	2106191.4803400002	37.7631709516944	-122.444902023732	(37.7631709516944, -122.444902023732)
45134	45134	132383	Undocumented 2	Pittosporum eugenioides :: Tarata 110	1713 Taylor St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	8	Width 4ft	6008731.67478	2118716.1773200002	37.7980833548266	-122.41385615953301	(37.7980833548266, -122.413856159533)
55400	55400	247548	Undocumented 2	Pittosporum eugenioides :: Tarata 110	815 Buena Vista Ave West	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	14	Width 4ft	6000113.779519999	2108396.7627	37.7692611579062	-122.44293504992399	(37.7692611579062, -122.442935049924)
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)
115488	115488	233973	Undocumented 2	Pittosporum eugenioides :: Tarata 110	242 Upper Ter	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	11	Width 4ft	5999494.677630001	2106185.26835	37.7631536325665	-122.44491748844901	(37.7631536325665, -122.444917488449)
132382	132382	132365	Undocumented 2	Pittosporum eugenioides :: Tarata 110	1 Dicha Aly	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	11	Width 3ft	5998327.23711	2113735.99188	37.7838192833694	-122.449499349909	(37.7838192833694, -122.449499349909)
157645	157645	233961	Undocumented 2	Pittosporum eugenioides :: Tarata 110	107 Valley St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	4	Width 4ft	6005126.403519999	2099291.88165	37.744545799654006	-122.424948746605	(37.744545799654, -122.424948746605)
159996	159996	194590	Undocumented 2	Pittosporum eugenioides :: Tarata 110	13 Bridgeview Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	2	Width 6ft	6016094.38858	2108337.40723	37.7699963267064	-122.387654295729	(37.7699963267064, -122.387654295729)
162959	162959	132382	Undocumented 2	Pittosporum eugenioides :: Tarata 110	1713 Taylor St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	7	Width 4ft	6008728.03476	2118737.75818	37.798142406100396	-122.413870282493	(37.7981424061004, -122.413870282493)
172452	172452	132380	Undocumented 2	Pittosporum eugenioides :: Tarata 110	1680 Taylor St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	7	Width 3ft	6008764.121730001	2118820.69014	37.7983721433051	-122.4137512797	(37.7983721433051, -122.4137512797)
176993	176993	132379	Undocumented 2	Pittosporum eugenioides :: Tarata 110	1680 Taylor St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	8	Width 3ft	6008770.01559	2118776.57909	37.7982513562644	-122.41372776333401	(37.7982513562644, -122.413727763334)
184440	184440	247639	Undocumented 2	Pittosporum eugenioides :: Tarata 110	360 Bradford St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	8	Width 8ft	6009456.29127	2096556.43991	37.7372784977969	-122.409783755028	(37.7372784977969, -122.409783755028)

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