Street_Tree_List

8 rows where PlotSize = "Width 10ft" and qSpecies = 72

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
23870	23870	214333	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	312 Hearst Ave	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1	4	Width 10ft	5999316.02125	2094400.93218	37.7307864969836	-122.44468833131901	(37.7307864969836, -122.444688331319)
28361	28361	214344	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	498 Vernon St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1	8	Width 10ft	5992505.71978	2091140.82125	37.7214440535804	-122.467995374584	(37.7214440535804, -122.467995374584)
57629	57629	214334	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	470 Hearst Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1	2	Width 10ft	5998312.15542	2094413.4318799998	37.7307634815435	-122.448159739578	(37.7307634815435, -122.448159739578)
62044	62044	214343	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	105 Beverly St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1	7	Width 10ft	5991402.99723	2089917.07257	37.7180201978552	-122.47171800938999	(37.7180201978552, -122.47171800939)
67614	67614	214345	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	498 Vernon St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1	4	Width 10ft	5992504.20594	2091177.71285	37.7215452614802	-122.46800328954599	(37.7215452614802, -122.468003289546)
130582	130582	214327	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	100 Vista Verde Ct	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	10	Width 10ft	5999204.10164	2096073.9362400002	37.7353737849692	-122.44519548960501	(37.7353737849692, -122.445195489605)
154466	154466	214328	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	100 Vista Verde Ct	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	7	Width 10ft	5999189.95231	2096066.10598	37.735351477276296	-122.44524384613001	(37.7353514772763, -122.44524384613)
175828	175828	237890	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	101 Bradford St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1	21	Width 10ft	6009586.52326	2097993.57219	37.741231849177396	-122.409434875633	(37.7412318491774, -122.409434875633)

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