Street_Tree_List

9 rows where DBH = 16 and qSpecies = 82

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	PlantDate	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
24603	24603	239251	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	3741 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		16	Width 3ft	6005376.329919999	2100765.1364700003	37.748605134322794	-122.42418930690901	(37.7486051343228, -122.424189306909)
44044	44044	197100	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	372 Pennsylvania Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		16	Width 4ft	6014303.71981	2105387.22588	37.7617964269902	-122.393641721993	(37.7617964269902, -122.393641721993)
55551	55551	197118	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	301 Texas St	1	: 4	Tree 1	Private 1		16	Width 4ft	6013784.73559	2105658.04133	37.7625111748734	-122.39545566804199	(37.7625111748734, -122.395455668042)
62773	62773	213916	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1221 07th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		16	Width 3ft	5993897.35256	2107155.07888	37.7654954419723	-122.46434702200199	(37.7654954419723, -122.464347022002)
144934	144934	24470	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	50X Gough St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2	01/07/1995 12:00:00 AM	16	3x3	6006161.54315	2109606.56692	37.7729259368552	-122.42210207116699	(37.7729259368552, -122.422102071167)
152686	152686	197117	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	315 Texas St	1	: 4	Tree 1	Private 1		16	Width 3ft	6013789.951309999	2105605.10268	37.762366107038105	-122.395433919764	(37.7623661070381, -122.395433919764)
169810	169810	239252	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	3735 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		16	Width 4ft	6005431.9472199995	2100770.05115	37.748621769087	-122.42399733221501	(37.748621769087, -122.423997332215)
179989	179989	136255	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	1422 Vallejo St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		16	Width 2ft	6006750.35587	2118407.27559	37.797123718848	-122.42069017253999	(37.797123718848, -122.42069017254)
185363	185363	136204	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	3898 Clay St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		16	Width 4ft	5996215.93738	2115261.69586	37.7878874538988	-122.45691400297399	(37.7878874538988, -122.456914002974)

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