trees

Custom SQL query returning 84 rows (hide)

select rowid, TreeID, qLegalStatus_id, qSpecies_id, qAddress, SiteOrder, qSiteInfo, PlantType, qCaretaker_id, qCareAssistant, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location, [Fire Prevention Districts], [Police Districts], [Supervisor Districts], [Zip Codes], [Neighborhoods (old)] from trees where "Zip Codes" = :p0 and "qSpecies_id" = :p1 and ([Supervisor Districts] > :p3 or ([Supervisor Districts] = :p3 and ((rowid > :p2)))) order by [Supervisor Districts], rowid limit 101

Query parameters

This data as json, CSV

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)
18675	101715	4	53	560 Wisconsin St	1	Sidewalk: Curb side : Cutout	Tree	2					6012536	2104936	37.760459075101	-122.399723915341	(37.760459075101, -122.399723915341)	10	3	8	28856	29
23663	85059	1	53	2435 03rd St	4	Sidewalk: Curb side : Cutout	Tree	1		6	4x9		6015831.18626	2104262.21936	37.7587921580004	-122.388280257816	(37.7587921580004, -122.388280257816)	10	3	8	28856	29
30509	109858	1	53	2455 03RD ST	4	Sidewalk: Curb side : Cutout	Tree	1		15	5x8		6015836.2	2104173	37.7585474584562	-122.388256691115	(37.7585474584562, -122.388256691115)	10	3	8	28856	29
34152	21980	1	53	2575 03rd St	2	Sidewalk: Curb side : Cutout	Tree	1		16	3x3		6015881.32806	2103602.42313	37.7569832760363	-122.388060799634	(37.7569832760363, -122.388060799634)	10	3	8	28856	29
35952	120884	4	53	2140x 18th St	1	Sidewalk: Curb side : Cutout	Tree	2			3x3		6011295	2105636	37.7623118602886	-122.404065249735	(37.7623118602886, -122.404065249735)	8	3	8	28856	29
43224	117205	7	53	1401 18th St	2	Sidewalk: Curb side : Cutout	Tree	2					6013468.70293325	2105662.80878203	37.762506682391	-122.396549051509	(37.762506682391, -122.396549051509)	10	3	8	28856	29
48959	112162	7	53	1324 18th St	4	Sidewalk: Curb side : Cutout	Tree	2			3x3		6013680.97327942	2105726.70860795	37.7626939483281	-122.39581935837	(37.7626939483281, -122.39581935837)	14	3	8	28856	29
49286	21956	1	53	2475 03rd St	1	Sidewalk: Curb side : Cutout	Tree	1		12	4x9		6015841.22266	2104083.69236	37.7583025169931	-122.388233087559	(37.7583025169931, -122.388233087559)	10	3	8	28856	29
50734	21952	1	53	2455 03RD ST	1	Sidewalk: Curb side : Cutout	Tree	1		14	4x9		6015836.2	2104173	37.7585474584562	-122.388256691115	(37.7585474584562, -122.388256691115)	10	3	8	28856	29
53748	110363	4	53	1899x MARIPOSA ST	2	Sidewalk: Curb side : Cutout	Tree	2			3x3		6011823	2106021	37.7633984709679	-122.402266155018	(37.7633984709679, -122.402266155018)	8	3	8	28856	29
54784	101716	4	53	560 Wisconsin St	2	Sidewalk: Curb side : Cutout	Tree	2					6012536	2104936	37.760459075101	-122.399723915341	(37.760459075101, -122.399723915341)	10	3	8	28856	29
63978	119667	4	53	699x Missouri St	8	Sidewalk: Property side : Yard	Tree	2					6013712	2104098	37.7582235960409	-122.395597929962	(37.7582235960409, -122.395597929962)	10	3	8	28856	29
77443	111583	7	53	1501-1555 Mariposa St	7	Sidewalk: Curb side : Cutout	Tree	2					6012875.34483574	2106095.24513094	37.7636610173266	-122.398631621456	(37.7636610173266, -122.398631621456)	14	3	8	28856	29
85621	21994	1	53	2585 03rd St	13	Sidewalk: Curb side : Cutout	Tree	1		12	4x6		6015909.89309	2103367.89889	37.7563409047326	-122.387945645479	(37.7563409047326, -122.387945645479)	10	3	8	28856	29
85979	120943	4	53	485 Carolina St	5	Sidewalk: Curb side : Cutout	Tree	2			3x3		6012395	2105853	37.7629690927527	-122.400275979648	(37.7629690927527, -122.400275979648)	14	3	8	28856	29
87085	101725	4	53	560 Wisconsin St	11	Sidewalk: Curb side : Cutout	Tree	2					6012536	2104936	37.760459075101	-122.399723915341	(37.760459075101, -122.399723915341)	10	3	8	28856	29
90466	21986	1	53	2585 03rd St	6	Sidewalk: Curb side : Cutout	Tree	1		12	4x9		6015885.54141	2103557.92781	37.7568613347581	-122.388043123198	(37.7568613347581, -122.388043123198)	10	3	8	28856	29
94460	101975	7	53	1230 19th St	2	Sidewalk: Curb side : Cutout	Tree	2			3x3	Permit Number 769454	6013882	2105282.2	37.7614846061652	-122.395092936828	(37.7614846061652, -122.395092936828)	10	3	8	28856	29
100042	40805	7	53	585 Connecticut St	2	Sidewalk: Curb side : Cutout	Tree	2				Permit Number 41753	6013296.02646982	2104345.28151099	37.758879430057	-122.397053895785	(37.758879430057, -122.397053895785)	10	3	8	28856	29
100521	111578	7	53	1501-1555 Mariposa St	2	Sidewalk: Curb side : Cutout	Tree	2					6012875.34483574	2106095.24513094	37.7636610173266	-122.398631621456	(37.7636610173266, -122.398631621456)	14	3	8	28856	29
101430	111584	7	53	1501-1555 Mariposa St	8	Sidewalk: Curb side : Cutout	Tree	2					6012875.34483574	2106095.24513094	37.7636610173266	-122.398631621456	(37.7636610173266, -122.398631621456)	14	3	8	28856	29
104299	21960	1	53	2525 03RD ST	2	Sidewalk: Curb side : Cutout	Tree	1		12	3x3		6015860.3	2103824.9	37.7575929852339	-122.388149048897	(37.7575929852339, -122.388149048897)	10	3	8	28856	29
105748	21991	1	53	2585 03rd St	2	Sidewalk: Curb side : Cutout	Tree	1		18	4x6		6015885.54141	2103557.92781	37.7568613347581	-122.388043123198	(37.7568613347581, -122.388043123198)	10	3	8	28856	29
105989	101717	4	53	560 Wisconsin St	3	Sidewalk: Curb side : Cutout	Tree	2					6012536	2104936	37.760459075101	-122.399723915341	(37.760459075101, -122.399723915341)	10	3	8	28856	29
109428	116772	4	53	376 MISSOURI ST	1	Sidewalk: Curb side : Cutout	Tree	2			7x9		6013450	2105342	37.7616247710574	-122.396591249035	(37.7616247710574, -122.396591249035)	10	3	8	28856	29
112959	21977	1	53	2573 03rd St	2	Sidewalk: Curb side : Cutout	Tree	1		12	3x3		6015880.48539	2103611.32219	37.7570076642803	-122.388064334928	(37.7570076642803, -122.388064334928)	10	3	8	28856	29
118179	21987	1	53	2585 03rd St	7	Sidewalk: Curb side : Cutout	Tree	1		12	4x9		6015885.54141	2103557.92781	37.7568613347581	-122.388043123198	(37.7568613347581, -122.388043123198)	10	3	8	28856	29
121552	117206	7	53	1401 18th St	3	Sidewalk: Curb side : Cutout	Tree	2					6013468.70293325	2105662.80878203	37.762506682391	-122.396549051509	(37.762506682391, -122.396549051509)	10	3	8	28856	29
123071	21969	1	53	2565 03rd St	1	Sidewalk: Curb side : Cutout	Tree	1		12	4x6		6015991.1899	2103495.51019	37.7566958018452	-122.38767339342	(37.7566958018452, -122.38767339342)	10	3	8	28856	29
127555	110364	4	53	1899x MARIPOSA ST	3	Sidewalk: Curb side : Cutout	Tree	2			3x3		6011823	2106021	37.7633984709679	-122.402266155018	(37.7633984709679, -122.402266155018)	8	3	8	28856	29
128956	21983	1	53	2585 03rd St	3	Sidewalk: Curb side : Cutout	Tree	1		12	4x9		6015885.54141	2103557.92781	37.7568613347581	-122.388043123198	(37.7568613347581, -122.388043123198)	10	3	8	28856	29
129331	21948	1	53	2435 03rd St	2	Sidewalk: Curb side : Cutout	Tree	1		12	4x9		6015831.18626	2104262.21936	37.7587921580004	-122.388280257816	(37.7587921580004, -122.388280257816)	10	3	8	28856	29
135125	45390	7	53	1501-1555 Mariposa St	9	Sidewalk: Curb side : Cutout	Tree	2	07/10/2001 12:00:00 AM			Permit Number 44202	6012875.34483574	2106095.24513094	37.7636610173266	-122.398631621456	(37.7636610173266, -122.398631621456)	14	3	8	28856	29
138070	101722	4	53	560 Wisconsin St	8	Sidewalk: Curb side : Cutout	Tree	2					6012536	2104936	37.760459075101	-122.399723915341	(37.760459075101, -122.399723915341)	10	3	8	28856	29
138111	111582	7	53	1501-1555 Mariposa St	6	Sidewalk: Curb side : Cutout	Tree	2					6012875.34483574	2106095.24513094	37.7636610173266	-122.398631621456	(37.7636610173266, -122.398631621456)	14	3	8	28856	29
138887	101721	4	53	560 Wisconsin St	7	Sidewalk: Curb side : Cutout	Tree	2					6012536	2104936	37.760459075101	-122.399723915341	(37.760459075101, -122.399723915341)	10	3	8	28856	29
143054	57622	7	53	1401 18th St	1	Sidewalk: Curb side : Cutout	Tree	2	11/15/1976 12:00:00 AM			Permit Number 16516	6013468.70293325	2105662.80878203	37.762506682391	-122.396549051509	(37.762506682391, -122.396549051509)	10	3	8	28856	29
143637	101724	4	53	560 Wisconsin St	10	Sidewalk: Curb side : Cutout	Tree	2					6012536	2104936	37.760459075101	-122.399723915341	(37.760459075101, -122.399723915341)	10	3	8	28856	29
146992	21975	1	53	2565 03rd St	7	Sidewalk: Curb side : Cutout	Tree	1		23	4x6		6015991.1899	2103495.51019	37.7566958018452	-122.38767339342	(37.7566958018452, -122.38767339342)	10	3	8	28856	29
151394	21984	1	53	2585 03rd St	4	Sidewalk: Curb side : Cutout	Tree	1		12	4x9		6015885.54141	2103557.92781	37.7568613347581	-122.388043123198	(37.7568613347581, -122.388043123198)	10	3	8	28856	29
158929	101720	4	53	560 Wisconsin St	6	Sidewalk: Curb side : Cutout	Tree	2					6012536	2104936	37.760459075101	-122.399723915341	(37.760459075101, -122.399723915341)	10	3	8	28856	29
161591	21959	1	53	2525 03RD ST	3	Sidewalk: Curb side : Cutout	Tree	1		12	4x6		6015860.3	2103824.9	37.7575929852339	-122.388149048897	(37.7575929852339, -122.388149048897)	10	3	8	28856	29
169319	101719	4	53	560 Wisconsin St	5	Sidewalk: Curb side : Cutout	Tree	2					6012536	2104936	37.760459075101	-122.399723915341	(37.760459075101, -122.399723915341)	10	3	8	28856	29
176915	101718	4	53	560 Wisconsin St	4	Sidewalk: Curb side : Cutout	Tree	2					6012536	2104936	37.760459075101	-122.399723915341	(37.760459075101, -122.399723915341)	10	3	8	28856	29
179093	21930	1	53	2347 03rd St	2	Sidewalk: Curb side : Cutout	Tree	1		12	3x5		6015939.39473	2104425.48438	37.7592464441674	-122.38791741203	(37.7592464441674, -122.38791741203)	10	3	8	28856	29
179159	101726	4	53	560 Wisconsin St	12	Sidewalk: Curb side : Cutout	Tree	2					6012536	2104936	37.760459075101	-122.399723915341	(37.760459075101, -122.399723915341)	10	3	8	28856	29
182806	112161	7	53	1324 18th St	3	Sidewalk: Curb side : Cutout	Tree	2			3x3		6013680.97327942	2105726.70860795	37.7626939483281	-122.39581935837	(37.7626939483281, -122.39581935837)	14	3	8	28856	29
188136	120939	4	53	485 Carolina St	1	Sidewalk: Curb side : Cutout	Tree	2			3x3		6012395	2105853	37.7629690927527	-122.400275979648	(37.7629690927527, -122.400275979648)	14	3	8	28856	29
3630	258965	1	53	398x Bryant St	5	Sidewalk: Curb side : Cutout	Tree	1			3x3		6014405	2113268	37.7834409032593	-122.393843088876	(37.7834409032593, -122.393843088876)	6	2	9	28856	6
5064	258966	1	53	398x Bryant St	6	Sidewalk: Curb side : Cutout	Tree	1			3x3		6014405	2113268	37.7834409032593	-122.393843088876	(37.7834409032593, -122.393843088876)	6	2	9	28856	6
6270	258961	1	53	398x Bryant St	1	Sidewalk: Curb side : Cutout	Tree	1			3x3		6014405	2113268	37.7834409032593	-122.393843088876	(37.7834409032593, -122.393843088876)	6	2	9	28856	6
9438	115058	4	53	499X BRANNAN ST	4	Sidewalk: Curb side : Cutout	Tree	2			3x3		6013762	2111312	37.7780344196247	-122.395930522096	(37.7780344196247, -122.395930522096)	6	2	9	28856	34
9626	258963	1	53	398x Bryant St	3	Sidewalk: Curb side : Cutout	Tree	1			3x3		6014405	2113268	37.7834409032593	-122.393843088876	(37.7834409032593, -122.393843088876)	6	2	9	28856	6
9664	258964	1	53	398x Bryant St	4	Sidewalk: Curb side : Cutout	Tree	1			3x3		6014405	2113268	37.7834409032593	-122.393843088876	(37.7834409032593, -122.393843088876)	6	2	9	28856	6
10154	258967	1	53	398x Bryant St	7	Sidewalk: Curb side : Cutout	Tree	1			3x3		6014405	2113268	37.7834409032593	-122.393843088876	(37.7834409032593, -122.393843088876)	6	2	9	28856	6
11514	258968	1	53	398x Bryant St	8	Sidewalk: Curb side : Cutout	Tree	1			3x3		6014405	2113268	37.7834409032593	-122.393843088876	(37.7834409032593, -122.393843088876)	6	2	9	28856	6
15941	85313	6	53	610 Brannan St	1	unknown : Cutout	Tree	2				Permit Number 49594	6012704.2	2110820.8	37.7766267904106	-122.399555358584	(37.7766267904106, -122.399555358584)	14	2	9	28856	34
17682	258962	1	53	398x Bryant St	2	Sidewalk: Curb side : Cutout	Tree	1			3x3		6014405	2113268	37.7834409032593	-122.393843088876	(37.7834409032593, -122.393843088876)	6	2	9	28856	6
18544	258969	1	53	398x Bryant St	9	Sidewalk: Curb side : Cutout	Tree	1			3x3		6014405	2113268	37.7834409032593	-122.393843088876	(37.7834409032593, -122.393843088876)	6	2	9	28856	6
18772	115057	4	53	499X BRANNAN ST	3	Sidewalk: Curb side : Cutout	Tree	2			3x3		6013762	2111312	37.7780344196247	-122.395930522096	(37.7780344196247, -122.395930522096)	6	2	9	28856	34
20820	111597	4	53	398X BRYANT ST	8	Sidewalk: Curb side : Cutout	Tree	2			3x3		6014483	2113360	37.7836978486164	-122.393579678281	(37.7836978486164, -122.393579678281)	6	2	9	28856	6
38859	115059	4	53	499X BRANNAN ST	5	Sidewalk: Curb side : Cutout	Tree	2			3x3		6013762	2111312	37.7780344196247	-122.395930522096	(37.7780344196247, -122.395930522096)	6	2	9	28856	34
43639	111595	4	53	398X BRYANT ST	6	Sidewalk: Curb side : Cutout	Tree	2			3x3		6014483	2113360	37.7836978486164	-122.393579678281	(37.7836978486164, -122.393579678281)	6	2	9	28856	6
50036	100262	4	53	40 Federal St	2	Sidewalk: Curb side : Cutout	Tree	2		24	3x3		6014922	2113400.9	37.7838345339316	-122.392063753471	(37.7838345339316, -122.392063753471)	6	2	9	28856	6
55811	115056	4	53	499X BRANNAN ST	2	Sidewalk: Curb side : Cutout	Tree	2			3x3		6013762	2111312	37.7780344196247	-122.395930522096	(37.7780344196247, -122.395930522096)	6	2	9	28856	34
65043	100265	4	53	40 Federal St	5	Sidewalk: Property side : Cutout	Tree	2		24	3x3		6014922	2113400.9	37.7838345339316	-122.392063753471	(37.7838345339316, -122.392063753471)	6	2	9	28856	6
97368	64484	7	53	436 Bryant St	1	Sidewalk: Curb side : Cutout	Tree	2	07/19/1988 12:00:00 AM			Permit Number 778749	6014198.52964849	2112913.46772182	37.782455962378	-122.39453256733	(37.782455962378, -122.39453256733)	6	2	9	28856	6
99255	111592	4	53	398X BRYANT ST	3	Sidewalk: Curb side : Cutout	Tree	2			3x3		6014483	2113360	37.7836978486164	-122.393579678281	(37.7836978486164, -122.393579678281)	6	2	9	28856	6
100811	111598	4	53	398X BRYANT ST	9	Sidewalk: Curb side : Cutout	Tree	2			3x3		6014483	2113360	37.7836978486164	-122.393579678281	(37.7836978486164, -122.393579678281)	6	2	9	28856	6
104676	100260	4	53	30X Federal St	2	Sidewalk: Curb side : Cutout	Tree	2		24	4x3		6015074.6	2113439.2	37.7839481682667	-122.391538488525	(37.7839481682667, -122.391538488525)	6	2	9	28856	6
107982	111590	4	53	398X BRYANT ST	1	Sidewalk: Curb side : Cutout	Tree	2		16	3x3		6014483	2113360	37.7836978486164	-122.393579678281	(37.7836978486164, -122.393579678281)	6	2	9	28856	6
109074	115054	4	53	499X BRANNAN ST	1	Sidewalk: Curb side : Cutout	Tree	2			3x3		6013762	2111312	37.7780344196247	-122.395930522096	(37.7780344196247, -122.395930522096)	6	2	9	28856	34
124317	91126	7	53	610 Brannan St	2	Sidewalk: Curb side : Cutout	Tree	2			3x3	Permit Number 49594	6012704.2	2110820.8	37.7766267904106	-122.399555358584	(37.7766267904106, -122.399555358584)	14	2	9	28856	34
131840	100259	4	53	30X Federal St	1	Sidewalk: Curb side : Cutout	Tree	2		24	4x3		6015074.6	2113439.2	37.7839481682667	-122.391538488525	(37.7839481682667, -122.391538488525)	6	2	9	28856	6
135772	100261	4	53	40 Federal St	1	Sidewalk: Curb side : Cutout	Tree	2		24	3x3		6014922	2113400.9	37.7838345339316	-122.392063753471	(37.7838345339316, -122.392063753471)	6	2	9	28856	6
144365	111593	4	53	398X BRYANT ST	4	Sidewalk: Curb side : Cutout	Tree	2			3x3		6014483	2113360	37.7836978486164	-122.393579678281	(37.7836978486164, -122.393579678281)	6	2	9	28856	6
147048	47565	7	53	920 Harrison St	3	Sidewalk: Curb side : Cutout	Tree	2	05/14/2002 12:00:00 AM			Permit Number 45425	6011901.71412119	2111593.71793264	37.7787042813354	-122.402385767126	(37.7787042813354, -122.402385767126)	14	2	9	28856	34
150162	111596	4	53	398X BRYANT ST	7	Sidewalk: Curb side : Cutout	Tree	2			3x3		6014483	2113360	37.7836978486164	-122.393579678281	(37.7836978486164, -122.393579678281)	6	2	9	28856	6
158317	111591	4	53	398X BRYANT ST	2	Sidewalk: Curb side : Cutout	Tree	2			3x3		6014483	2113360	37.7836978486164	-122.393579678281	(37.7836978486164, -122.393579678281)	6	2	9	28856	6
167657	100264	4	53	40 Federal St	4	Sidewalk: Curb side : Cutout	Tree	2		24	3x3		6014922	2113400.9	37.7838345339316	-122.392063753471	(37.7838345339316, -122.392063753471)	6	2	9	28856	6
173264	111594	4	53	398X BRYANT ST	5	Sidewalk: Curb side : Cutout	Tree	2			3x3		6014483	2113360	37.7836978486164	-122.393579678281	(37.7836978486164, -122.393579678281)	6	2	9	28856	6
174749	100263	4	53	40 Federal St	3	Sidewalk: Curb side : Cutout	Tree	2		24	3x3		6014922	2113400.9	37.7838345339316	-122.392063753471	(37.7838345339316, -122.392063753471)	6	2	9	28856	6
185458	91127	7	53	610 Brannan St	3	Sidewalk: Curb side : Cutout	Tree	2			3x3	Permit Number 49594	6012704.2	2110820.8	37.7766267904106	-122.399555358584	(37.7766267904106, -122.399555358584)	14	2	9	28856	34
189256	91128	7	53	610 Brannan St	4	Sidewalk: Curb side : Cutout	Tree	2			3x3	Permit Number 49594	6012704.2	2110820.8	37.7766267904106	-122.399555358584	(37.7766267904106, -122.399555358584)	14	2	9	28856	34