trees: trees: 23 rows where where SiteOrder = 2, Supervisor Districts = 4 and qLegalStatus

23 rows where SiteOrder = 2, Supervisor Districts = 4 and qLegalStatus_id = 2 sorted by Supervisor Districts

Search:

descending

rowid	TreeID	qLegalStatus_id	qSpecies_id	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker_id	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location	Fire Prevention Districts	Police Districts	Supervisor Districts ▼	Zip Codes	Neighborhoods (old)
1560	258220	Planning Code 138.1 required 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13	477 Eucalyptus Dr	2	Sidewalk: Property side : Cutout	Tree	Private 2	07/03/2019 12:00:00 AM	3	3x3	Permit Number 774069	5989683	2094686	37.7310148065902	-122.478011682019	(37.7310148065902, -122.478011682019)	1	8	4	64	14
4912	261377	Planning Code 138.1 required 2	Olea Majestic Beauty :: 183	3015 25th Ave	2	Sidewalk: Property side : Yard	Tree	Private 2	01/08/2020 12:00:00 AM	3	4x10	Permit Number 784883	5988814.87181	2095155.07295	37.7322523337557	-122.481047245899	(37.7322523337557, -122.481047245899)	1	8	4	64	35
6656	258684	Planning Code 138.1 required 2	Magnolia spp :: Magnolia 224	222 Eucalyptus Dr	2	Sidewalk: Property side : Yard	Tree	Private 2	06/06/2019 12:00:00 AM	3	4x4	Permit Number 782190	5990522.43491	2094710.12159	37.7311297256611	-122.475111403646	(37.7311297256611, -122.475111403646)	1	8	4	64	35
8046	261018	Planning Code 138.1 required 2	Ginkgo biloba :: Maidenhair Tree 22	79 Cragmont Ave	2	Sidewalk: Curb side : Cutout	Tree	Private 2	11/15/2019 12:00:00 AM	3	3x3	Permit Number 774761	5992858	2101375	37.749564886931	-122.467521508976	(37.749564886931, -122.467521508976)	1	8	4	29491	12
12606	261830	Planning Code 138.1 required 2	Olea europaea :: Olive Tree 9	256 Casitas Ave	2	Sidewalk: Property side : Yard	Tree	Private 2	03/05/2020 12:00:00 AM	3	3x3	Permit Number 781540	5994862.12068	2096567.59314	37.7364804498834	-122.460242983215	(37.7364804498834, -122.460242983215)	9	7	4	59	40
14010	261579	Planning Code 138.1 required 2	Prunus cerasifera :: Cherry Plum 7	496 Urbano Dr	2	Sidewalk: Property side : Yard	Tree	Private 2			3x3		5992575	2091875	37.7234639294961	-122.467809264789	(37.7234639294961, -122.467809264789)	9	8	4	59	40
16662	260846	Planning Code 138.1 required 2	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146	6 Cragmont Ave	2	Sidewalk: Property side : Yard	Tree	Private 2	10/15/2019 12:00:00 AM	3	4x4	Permit Number 782122	5992584.1181	2101828.636	37.7507946382458	-122.468501593976	(37.7507946382458, -122.468501593976)	1	8	4	29491	12
18512	260829	Planning Code 138.1 required 2	Callistemon viminalis :: Weeping Bottlebrush 60	165 Cerritos Ave	2	Sidewalk: Property side : Yard	Tree	Private 2	10/10/2019 12:00:00 AM	3	3x3	Permit Number 781510	5991854	2092943	37.7263547341381	-122.470379348754	(37.7263547341381, -122.470379348754)	9	8	4	59	40
20111	1217	Planning Code 138.1 required 2	Ginkgo biloba :: Maidenhair Tree 22	3501 Alemany Blvd	2	Sidewalk: Curb side : Cutout	Tree	Private 2	06/17/2016 12:00:00 AM	3	3x3		5993695.72185	2087421.09824	37.7112992341463	-122.463612070865	(37.7112992341463, -122.463612070865)	9	8	4	64	24
22364	114870	Planning Code 138.1 required 2	Prunus serrulata :: Ornamental Cherry 84	2326 Cecelia Ave	2	Sidewalk: Curb side : Cutout	Tree	Private 2	12/16/2015 12:00:00 AM	3	3x4		5991484.88147917	2099641.61135178	37.744726077495	-122.472143418263	(37.744726077495, -122.472143418263)	1	8	4	29491	40
28863	115887	Planning Code 138.1 required 2	Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421	134 Lunado Way	2	Sidewalk: Curb side : Cutout	Tree	Private 2	03/01/2016 12:00:00 AM	3	2x4	Permit Number 772714	5991633.6	2092401.5	37.7248551637156	-122.471101821397	(37.7248551637156, -122.471101821397)	9	8	4	59	40
46086	115494	Planning Code 138.1 required 2	Washingtonia robusta :: Mexican Fan Palm 72	1199X OCEAN AVE	2	Sidewalk: Curb side : Cutout	Tree	Private 2	02/10/2016 12:00:00 AM	3	3x3	Permit Number 777362	5996259	2091739	37.7233025441304	-122.455064598389	(37.7233025441304, -122.455064598389)	9	8	4	28861	24
51709	173899	Planning Code 138.1 required 2	Ulmus parvifolia :: Chinese Elm 31	1762 12th Ave	2	Sidewalk: Property side : Cutout	Tree	Private 2			3x3	Permit Number 779465	5992511.90241	2103608.89481	37.7556785957656	-122.468880856653	(37.7556785957656, -122.468880856653)	1	8	4	56	12
71090	115491	Planning Code 138.1 required 2	Washingtonia robusta :: Mexican Fan Palm 72	280 BRIGHTON AVE	2	Sidewalk: Curb side : Cutout	Tree	Private 2	02/10/2016 12:00:00 AM	3	4x12	Permit Number 777362	5996259	2091739	37.7233025441304	-122.455064598389	(37.7233025441304, -122.455064598389)	9	8	4	28861	24
86852	154903	Planning Code 138.1 required 2	Eriobotrya deflexa :: Bronze Loquat 8	1101X Ortega St	2	Sidewalk: Curb side : Cutout	Tree	Private 2	02/06/2018 12:00:00 AM	3	4x4	Permit Number 778565	5990408	2102358	37.7521221923779	-122.476065384407	(37.7521221923779, -122.476065384407)	1	8	4	29491	12
95904	256882	Planning Code 138.1 required 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 14	3075 25th Ave	2	Sidewalk: Property side : Yard	Tree	Private 2	12/21/2018 12:00:00 AM	3	3x10	Permit Number 781920	5988824.60597	2094879.63635	37.7314966214822	-122.480993433312	(37.7314966214822, -122.480993433312)	1	8	4	64	35
120310	173614	Planning Code 138.1 required 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149	2955 20th Ave	2	Sidewalk: Property side : Yard	Tree	Private 2	12/12/2016 12:00:00 AM	3	3x6	Permit Number 776469	5990236.78382	2095590.44954	37.7335303227244	-122.476163213901	(37.7335303227244, -122.476163213901)	1	8	4	64	35
123272	256677	Planning Code 138.1 required 2	Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26	330 Twin Peaks Blvd	2	Sidewalk: Curb side : Cutout	Tree	Private 2	03/27/2019 12:00:00 AM	3	3x3		5998688	2103995	37.7570936308358	-122.447549834506	(37.7570936308358, -122.447549834506)	15	5	4	63	38
130529	256674	Planning Code 138.1 required 2	Cornus florida :: Eastern Dogwood 385	330 Twin Peaks Blvd	2	Side Yard : Cutout	Tree	Private 2	03/27/2019 12:00:00 AM	3	3x3		5998688	2103995	37.7570936308358	-122.447549834506	(37.7570936308358, -122.447549834506)	15	5	4	63	38
164459	116850	Planning Code 138.1 required 2	Olea europaea :: Olive Tree 9	83 Panorama Dr	2	Front Yard : Yard	Tree	Private 2	05/03/2016 12:00:00 AM	3			5997625.8	2100317.8	37.7469361901044	-122.450958160054	(37.7469361901044, -122.450958160054)	1	5	4	59	38
166329	117480	Planning Code 138.1 required 2	Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163	601 PACHECO ST	2	Sidewalk: Property side : Cutout	Tree	Private 2			3x9		5993107	2101833	37.7508368102529	-122.466693753982	(37.7508368102529, -122.466693753982)	1	8	4	29491	12
167666	173650	Planning Code 138.1 required 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 14	80 Entrada Ct	2	Sidewalk: Property side : Yard	Tree	Private 2	12/21/2016 12:00:00 AM	3	4x10		5992424.45657	2092194.59394	37.7243327619491	-122.468352901223	(37.7243327619491, -122.468352901223)	9	8	4	59	40
186896	114793	Planning Code 138.1 required 2	Tree(s) :: 17	10 Linares Ave	2	Sidewalk: Curb side : Cutout	Tree	Private 2			3x10	Permit Number 777094	5993887.4	2102332.1	37.7522522176371	-122.464031307011	(37.7522522176371, -122.464031307011)	1	8	4	29491	40

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);