Street_Tree_List

9 rows where SiteOrder = 10 and qSpecies = 59 sorted by PermitNotes

Search:

descending

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
188	188	138368	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2	13	Width 0ft	6002679.2262	2114443.3671	37.786009553218996	-122.434493703661	(37.786009553219, -122.434493703661)
27933	27933	143258	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	661 LOMBARD ST	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	21	Width 0ft	6009397.1671	2120467.3833	37.8029290843214	-122.41167715318599	(37.8029290843214, -122.411677153186)
39425	39425	142599	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	7	Width 0ft	6008384.0855	2120756.6777	37.8036665324855	-122.415203440632	(37.8036665324855, -122.415203440632)
46667	46667	141799	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1280 WEBSTER ST	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	15	Width 0ft	6003782.7951	2113127.1113	37.782458027558	-122.43058169950899	(37.782458027558, -122.430581699509)
47656	47656	140713	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	500 PIERCE ST	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	15	Width 0ft	6002640.192000001	2110470.3137	37.775098331299	-122.434344596397	(37.775098331299, -122.434344596397)
49750	49750	137532	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1300 Pierce St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	16	Width 0ft	6002250.4834	2113262.6052	37.7827431340216	-122.435892519009	(37.7827431340216, -122.435892519009)
155611	155611	140584	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	949 FILLMORE ST	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	19	Width 0ft	6003428.3587	2111466.6041	37.77787860365579	-122.431689302353	(37.7778786036558, -122.431689302353)
161629	161629	246091	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 Stanyan St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	16	Width 0ft	5997087.5866	2108354.0638	37.7689709202682	-122.45339935697099	(37.7689709202682, -122.453399356971)
164399	164399	141486	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2901 TURK BLVD	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	2	Width 0ft	5996862.6584	2111508.4097	37.77761903893	-122.454405252217	(37.77761903893, -122.454405252217)

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