Street_Tree_List

9 rows where SiteOrder = 2 and qSpecies = 92

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
35406	35406	231466	Undocumented 2	Magnolia x soulangiana :: Saucer Magnolia 92	37 Seward St	2	Front Yard : Yard 7	Tree 1	Private 1			8	Width 3ft		6000948.20429	2104259.35127	37.75794838352479	-122.439752154039	(37.7579483835248, -122.439752154039)
39698	39698	137639	Undocumented 2	Magnolia x soulangiana :: Saucer Magnolia 92	1492 MCALLISTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6002021.6701	2111571.8465	37.7780877369401	-122.436563057586	(37.7780877369401, -122.436563057586)
41697	41697	231464	Undocumented 2	Magnolia x soulangiana :: Saucer Magnolia 92	614 Banks St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			9	Width 3ft		6008499.04056	2095971.93589	37.7356198853381	-122.413052106275	(37.7356198853381, -122.413052106275)
53281	53281	208871	Undocumented 2	Magnolia x soulangiana :: Saucer Magnolia 92	148 Marston Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5			5998513.60656	2093229.6533400002	37.7275246181613	-122.447378122617	(37.7275246181613, -122.447378122617)
53808	53808	88032	Permitted Site 1	Magnolia x soulangiana :: Saucer Magnolia 92	2301X Lyon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/23/2008 12:00:00 AM	5	3x3	Permit Number 51052	5999270.68055	2116740.2820200003	37.7921222013229	-122.44645160686399	(37.7921222013229, -122.446451606864)
118649	118649	94724	Permitted Site 1	Magnolia x soulangiana :: Saucer Magnolia 92	12 Manzanita Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/28/2010 12:00:00 AM		3x3	Permit Number 53858	5997888.8	2114457.6	37.7857755383106	-122.451068225719	(37.7857755383106, -122.451068225719)
148242	148242	177464	Undocumented 2	Magnolia x soulangiana :: Saucer Magnolia 92	116 Vienna St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 4ft		6004715.70527	2092764.9343400002	37.7266010638798	-122.425904344615	(37.7266010638798, -122.425904344615)
170993	170993	208867	Undocumented 2	Magnolia x soulangiana :: Saucer Magnolia 92	109 Forest Side Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5992482.68446	2098361.94158	37.7412701225134	-122.46860014710501	(37.7412701225134, -122.468600147105)
181718	181718	249856	Undocumented 2	Magnolia x soulangiana :: Saucer Magnolia 92	241 Greenwich St	2	Front Yard : Yard 7	Tree 1	Private 1			6	Width 0ft		6011508.41601	2120409.27478	37.802887738231504	-122.404367007957	(37.8028877382315, -122.404367007957)

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