Street_Tree_List

9 rows where PlotSize = "Width 4ft" and qSpecies = 91

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
40043	40043	228498	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	450 Church St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	1	Width 4ft	6004181.58169	2106402.65123	37.764016887284704	-122.42872255552	(37.7640168872847, -122.42872255552)
46854	46854	190660	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	1395 Fairfax Ave	2	: 4	Tree 1	Private 1	3	Width 4ft	6016617.23425	2097405.156	37.7400076047554	-122.385083956852	(37.7400076047554, -122.385083956852)
51149	51149	228500	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	1230 Castro St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	16	Width 4ft	6002502.463830001	2101939.70334	37.7516675300559	-122.434211046008	(37.7516675300559, -122.434211046008)
60791	60791	228485	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	4158 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	2	Width 4ft	6002879.00201	2100672.89334	37.7482105324925	-122.432818439532	(37.7482105324925, -122.432818439532)
70920	70920	219180	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	1785 07th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	9	Width 4ft	5994012.85069	2103371.98784	37.7551147123942	-122.463672948647	(37.7551147123942, -122.463672948647)
71808	71808	190649	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	1164 18th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	13	Width 4ft	6014097.05519	2105748.35032	37.7627765099393	-122.394381783993	(37.7627765099393, -122.394381783993)
136455	136455	228479	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	184 Downey St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	9	Width 4ft	5998955.25722	2107101.1921200003	37.7656377291263	-122.446849065839	(37.7656377291263, -122.446849065839)
157193	157193	228478	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	99 Parnassus Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	10	Width 4ft	5998158.0059	2106821.83124	37.7648250972209	-122.44958643847299	(37.7648250972209, -122.449586438473)
178475	178475	219179	Undocumented 2	Hymenosporum flavum :: Sweet Shade 91	1785 07th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	9	Width 4ft	5994014.03321	2103382.75983	37.7551443576498	-122.46366964095199	(37.7551443576498, -122.463669640952)

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