Street_Tree_List

9 rows where DBH = 1, SiteOrder = 2 and qSpecies = 58

Search:

descending

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
24848	24848	188408	Undocumented 2	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	2033 22nd St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1	1	Width 3ft	6011976.80987	2103707.86259	37.7570556930855	-122.40157158857299	(37.7570556930855, -122.401571588573)
38985	38985	123068	Undocumented 2	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	678 12th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	1	Width 3ft	5992266.69336	2110864.34538	37.7755859643914	-122.47025718989201	(37.7755859643914, -122.470257189892)
77059	77059	188411	Undocumented 2	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	398 Mississippi St	2	: 4	Tree 1	Private 1	1	Width 3ft	6014024.24871	2105357.36092	37.7616988910081	-122.394606216998	(37.7616988910081, -122.394606216998)
130324	130324	123045	Undocumented 2	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	568 Funston Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1	1	Width 3ft	5991929.81513	2111594.03006	37.777569997766705	-122.47147570428301	(37.7775699977667, -122.471475704283)
156475	156475	175816	Undocumented 2	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	616 Dwight St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	1	Width 3ft	6009781.28405	2091163.7033900002	37.7224893931511	-122.40827985473699	(37.7224893931511, -122.408279854737)
171203	171203	204735	Undocumented 2	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	40 Vasquez Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	1	Width 3ft	5995650.24765	2100035.09823	37.746046665624	-122.457768945275	(37.746046665624, -122.457768945275)
174132	174132	188415	Undocumented 2	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	2 Jennings St	2	: 4	Tree 1	Private 1	1	Width 3ft	6019090.329030001	2097590.47628	37.7406529492792	-122.37654576818998	(37.7406529492792, -122.37654576819)
178316	178316	202043	Undocumented 2	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	52 Exeter St	2	: 4	Tree 1	Private 1	1	Width 3ft	6012522.16713	2090984.69593	37.722150974681604	-122.398792625891	(37.7221509746816, -122.398792625891)
185050	185050	204744	Undocumented 2	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	545 Melrose Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1	1	Width 6ft	5996927.5801099995	2095415.2897	37.733435093958896	-122.453018700168	(37.7334350939589, -122.453018700168)

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