Street_Tree_List

11 rows where DBH = 4 and qSpecies = 54

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
45274	45274	246179	Undocumented 2	:: 54	1588 Waller St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	4	Width 0ft	5997977.1471	2108227.9355	37.768675553750796	-122.45031334601101	(37.7686755537508, -122.450313346011)
51535	51535	183816	Undocumented 2	:: 54	2135 Rivera St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	4	Width 0ft	5986457.7853	2100251.173	37.746107568513104	-122.48957072678002	(37.7461075685131, -122.48957072678)
51976	51976	181517	Undocumented 2	:: 54	1400 Sunset Blvd	77	Sidewalk: Property side : Yard 9	Tree 1	Private 1	4	Width 0ft	5984871.9567	2105586.7319	37.7606648313705	-122.49544767930401	(37.7606648313705, -122.495447679304)
53766	53766	248316	Undocumented 2	:: 54	1415 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	4	Width 0ft	5998917.5828	2108317.7243	37.7689758669537	-122.44706692803001	(37.7689758669537, -122.44706692803)
63252	63252	183894	Undocumented 2	:: 54	1390 Quintara St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	4	Width 0ft	5989083.3554	2101019.0158	37.7483687977509	-122.480548145718	(37.7483687977509, -122.480548145718)
70132	70132	186781	Undocumented 2	:: 54	1200 Sunset Blvd	49	Sidewalk: Property side : Yard 9	Tree 1	Private 1	4	Width 0ft	5984857.4742	2106824.7830000003	37.764063324835796	-122.49558908498399	(37.7640633248358, -122.495589084984)
151138	151138	183895	Undocumented 2	:: 54	1390 Quintara St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	4	Width 0ft	5989106.2065	2101019.8038	37.74837228939921	-122.480469185732	(37.7483722893992, -122.480469185732)
166129	166129	183896	Undocumented 2	:: 54	1390 Quintara St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	4	Width 0ft	5989127.4817	2101020.5917	37.7483756891409	-122.48039567509501	(37.7483756891409, -122.480395675095)
169869	169869	186771	Undocumented 2	:: 54	1200 Sunset Blvd	39	Sidewalk: Property side : Yard 9	Tree 1	Private 1	4	Width 0ft	5984865.2362	2106774.8154	37.7639265823683	-122.495558553205	(37.7639265823683, -122.495558553205)
184322	184322	183815	Undocumented 2	:: 54	2137 Rivera St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	4	Width 0ft	5986412.1243	2100248.6126	37.746097872473506	-122.48972842623199	(37.7460978724735, -122.489728426232)
188195	188195	183817	Undocumented 2	:: 54	2133 Rivera St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	4	Width 0ft	5986490.2175	2100252.0265	37.74611180538629	-122.48945864467301	(37.7461118053863, -122.489458644673)

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