Street_Tree_List

9 rows where DBH = 10 and qSpecies = 45

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
23996	23996	240380	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	87 14th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10	Width 3ft		6008113.4152	2107953.3802	37.768496570485794	-122.41523324373199	(37.7684965704858, -122.415233243732)
26795	26795	179378	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	2016 Bay Shore Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10	Width 2ft		6012163.289480001	2088075.41369	37.7141426692356	-122.39982900101299	(37.7141426692356, -122.399829001013)
47021	47021	179382	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	143 University St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10	Width 3ft		6007980.64963	2093237.8287400003	37.728083504546596	-122.414650965095	(37.7280835045466, -122.414650965095)
56127	56127	136318	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	2431 Jones St	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1		10	Width 4ft		6007955.59027	2120758.45752	37.803647329033105	-122.416686400679	(37.8036473290331, -122.416686400679)
74323	74323	240374	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	99 Ramona Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10	Width 3ft		6005228.2825	2107285.15785	37.7664992238917	-122.425165122599	(37.7664992238917, -122.425165122599)
97529	97529	42941	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	90 14TH ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	07/05/2000 12:00:00 AM	10		Permit Number 42835	6008035.0	2107992.0	37.768598204141995	-122.415507210488	(37.768598204142, -122.415507210488)
104373	104373	100234	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	701X 39th Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10	3x3		5983811.49615	2110876.46915	37.7751267903243	-122.499506209788	(37.7751267903243, -122.499506209788)
137254	137254	124092	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	601 Funston Ave	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1		10			5991890.07496	2111196.5227799998	37.776476251963295	-122.47158420369101	(37.7764762519633, -122.471584203691)
162943	162943	185411	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	2300 Sunset Blvd	26	unknown : Yard 19	Tree 1	Private 1		10	Width 0ft		5985100.1361	2099184.3909	37.7430991186582	-122.49418661978599	(37.7430991186582, -122.494186619786)

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