trees

This data as json, CSV

rowid	TreeID	qLegalStatus_id	qSpecies_id	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker_id	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes
2	262167	1	2	420 Alpha St	2	Sidewalk: Curb side : Cutout	Tree	1	FUF	11/16/2020 12:00:00 AM	3
6	262166	1	2	420 Alpha St	1	Sidewalk: Curb side : Cutout	Tree	1	FUF	11/16/2020 12:00:00 AM	3
13	264822	1	10	2 Harkness Ave	1	Sidewalk: Curb side : Cutout	Tree	1		11/01/2020 12:00:00 AM	3	4x6
16	264823	1	10	2 Harkness Ave	2	Sidewalk: Curb side : Cutout	Tree	1		11/01/2020 12:00:00 AM	3	4x6
19	262168	1	2	420 Alpha St	3	Sidewalk: Curb side : Cutout	Tree	1	FUF	11/16/2020 12:00:00 AM	3
79	121399	1	28	349X Cargo Way	1	Sidewalk: Curb side : Cutout	Tree	1
80	260998	1	41	600X Lake Merced Blvd	1	Sidewalk: Property side : Yard	Tree	4				10x10
82	251210	1	42	1170 Ingalls St	2	Sidewalk: Curb side : Cutout	Tree	1		11/02/1992 12:00:00 AM
83	259099	1	11	600 Visitacion Ave	1	Sidewalk: Curb side : Cutout	Tree	1	FUF	03/30/2019 12:00:00 AM	3
85	259368	1	3	1646 Revere Ave	1	Sidewalk: Curb side : Cutout	Tree	1	FUF
87	259654	1	45	101x Cora St		Sidewalk: Curb side : Cutout	Tree	1	FUF	06/01/2019 12:00:00 AM	3
88	259653	1	45	99x Cora St	2	Sidewalk: Curb side : Cutout	Tree	1	FUF	06/01/2019 12:00:00 AM	3
89	259623	1	45	1498x Visitacion Ave	2	Sidewalk: Curb side : Cutout	Tree	1	FUF	06/01/2019 12:00:00 AM	3
90	259864	1	1	1398x Brussels St		Sidewalk: Curb side : Cutout	Tree	1	FUF	03/30/2019 12:00:00 AM	3
91	260225	1	10	2201x 22nd Ave	21	Sidewalk: Curb side : Cutout	Tree	1	FUF	10/20/2018 12:00:00 AM	3
92	260521	1	46	3519x Kirkham St	3	Sidewalk: Curb side : Cutout	Tree	1	FUF	07/27/2019 12:00:00 AM	3
93	260525	1	47	3437x Rivera St	1	Sidewalk: Curb side : Cutout	Tree	1	FUF	07/27/2019 12:00:00 AM	3
100	255131	1	28	401X Brotherhood Way	9	Sidewalk: Property side : Yard	Tree	1
101	255229	1	11	300X Goettingen St	4	Sidewalk: Curb side : Cutout	Tree	1	FUF
102	258152	1	49	500X Bryant St	2	Sidewalk: Curb side : Cutout	Tree	1	FUF		3
103	253831	1	45	699X Polk St	5	Sidewalk: Curb side : Cutout	Tree	2	DPW			3x3
104	260590	1	50	3099x Jennings St	3	Sidewalk: Curb side : Cutout	Tree	1	FUF	08/20/2020 12:00:00 AM	3
106	251438	1	41	2501X Santiago St	1	Median : Yard	Tree	1
107	264818	1	51	101x Olmstead St	2	Sidewalk: Curb side : Cutout	Tree	1		10/23/2020 12:00:00 AM	3
114	251458	1	50	651 Texas St	1	Sidewalk: Curb side : Cutout	Tree	2		05/03/2017 12:00:00 AM	3	3x3
285	260625	1	4	1601x Thomas Ave	2	Sidewalk: Curb side : Cutout	Tree	1	FUF	08/24/2019 12:00:00 AM	3
449	252970	1	83	101X Whipple Ave	2	Sidewalk: Curb side : Yard	Tree	2		04/26/2019 12:00:00 AM	3
488	20353	1	111	262X Sunset Blvd	3	Sidewalk: Curb side : Cutout	Tree	1			6	60
509	19905	1	41	100 STAIRWAY35	1	Sidewalk: Curb side : Cutout	Tree	1			12	120ST
537	261951	1	41	1X Portola Dr To Clipper St Connetion	5	Sidewalk: Property side : Yard	Tree	1
544	259763	1	75	2701 24th St	1	Sidewalk: Curb side : Cutout	Tree	1		03/12/2019 12:00:00 AM	3
550	19742	1	117	100 STAIRWAY15	-9	Sidewalk: Curb side : Cutout	Tree	1			6	1OST
561	19835	1	119	100 STAIRWAY25	19	Sidewalk: Curb side : Cutout	Tree	1			12	60X
566	260237	1	10	2201x 22nd Ave	33	Sidewalk: Curb side : Cutout	Tree	1	FUF	10/20/2018 12:00:00 AM	3
582	20409	1	27	451X Sunset Blvd	1	Sidewalk: Curb side : Cutout	Tree	1			18	10
594	20063	1	122	100 STAIRWAY54	10	Sidewalk: Curb side : Cutout	Tree	1			6	15ST
595	261954	1	41	1X Portola Dr To Clipper St Connetion	8	Sidewalk: Property side : Yard	Tree	1
604	20034	1	7	100 STAIRWAY51	5	Sidewalk: Curb side : Cutout	Tree	1			3	ST
657	20296	1	41	20X Sunset Blvd	17	Sidewalk: Curb side : Cutout	Tree	1			42	60
663	259361	1	128	1699x Keith St	2	Sidewalk: Curb side : Cutout	Tree	1	FUF	05/25/2019 12:00:00 AM	3
668	19865	1	100	100 STAIRWAY30	9	Sidewalk: Curb side : Cutout	Tree	1			24	100ST
689	119914	1	15	400X Brotherhood Way	1	Front Yard : Yard	Tree	1				100x100
690	19651	1	127	100 STAIRWAY5	50	Sidewalk: Curb side : Cutout	Tree	1			12	60ST
695	20360	1	111	262X Sunset Blvd	10	Sidewalk: Curb side : Cutout	Tree	1			12	60
720	19950	1	41	100 STAIRWAY39	7	Sidewalk: Curb side : Cutout	Tree	1			12	25ST
756	124716	1	70	2195 Palou Ave	1	Sidewalk: Curb side : Cutout	Tree	2
768	20385	1	70	262X Sunset Blvd	31	Sidewalk: Curb side : Cutout	Tree	1			12	60
784	187688	1	33	399X Ash St	2	Sidewalk: Curb side : Cutout	Tree	2		02/27/2017 12:00:00 AM	3
795	19570	1	41	100 STAIRWAY1	4	Sidewalk: Curb side : Cutout	Tree	1			48	100ST
798	19725	1	100	100 STAIRWAY14	3	Sidewalk: Curb side : Cutout	Tree	1			6	40ST
808	19837	1	36	100 STAIRWAY25	21	Sidewalk: Curb side : Cutout	Tree	1			6	60X
815	20416	1	15	453X Sunset Blvd	5	Sidewalk: Curb side : Cutout	Tree	1			18	60
819	20315	1	56	101X Sunset Blvd	4	Sidewalk: Curb side : Cutout	Tree	1			42	60
844	254210	1	15	300x Esmeralda Ave	20	Unaccepted Street : Yard	Tree	1
871	259735	1	14	100x Florida St	1	Sidewalk: Curb side : Cutout	Tree	1	FUF	06/09/2018 12:00:00 AM	3
874	19715	1	100	100 STAIRWAY13	13	Sidewalk: Curb side : Cutout	Tree	1			12	40ST
875	19954	1	150	100 STAIRWAY39	11	Sidewalk: Curb side : Cutout	Tree	1			6	25ST
884	261406	1	84	779 Broadway	2	Sidewalk: Curb side : Cutout	Tree	2
900	19637	1	52	100 STAIRWAY5	36	Sidewalk: Curb side : Cutout	Tree	1			12	30
954	20324	1	63	101X Sunset Blvd	12	Sidewalk: Curb side : Cutout	Tree	1			12	60
1062	20065	1	160	100 STAIRWAY54	12	Sidewalk: Curb side : Cutout	Tree	1			3	15ST
1090	260553	1	36	151x Palm Ave	4	Sidewalk: Curb side : Cutout	Tree	1	SFUSD	09/21/2019 12:00:00 AM	3
1095	255202	1	1	301X Burrows St	3	Sidewalk: Curb side : Cutout	Tree	1	FUF
1138	260594	1	1	3090x Jennings St	4	Sidewalk: Curb side : Cutout	Tree	1	FUF	08/24/2019 12:00:00 AM	3
1144	20400	1	15	262X Sunset Blvd	45	Sidewalk: Curb side : Cutout	Tree	1			18	60
1160	122663	1	11	401x Laguna St	1	Sidewalk: Curb side : Cutout	Tree	2		11/10/2016 12:00:00 AM	3	3X3
1171	19952	1	52	100 STAIRWAY39	9	Sidewalk: Curb side : Cutout	Tree	1			12	25ST
1176	119263	1	15	495X Lakeshore Dr	1	Median : Yard	Tree	1				10x30
1179	251578	1	37	1000X Columbus Ave	6	Median : Cutout	Tree	1
1215	253279	1	44	201X Laguna Honda Blvd	1	Sidewalk: Property side : Yard	Tree	1				10x10	ROW IS 10' tree is street tree
1216	20357	1	111	262X Sunset Blvd	7	Sidewalk: Curb side : Cutout	Tree	1			12	60
1295	19941	1	56	100 STAIRWAY38	10	Sidewalk: Curb side : Cutout	Tree	1			18	10ST
1310	173924	1	11	500X Gough St	4	Sidewalk: Curb side : Cutout	Tree	1		10/05/2010 12:00:00 AM		3x3
1350	19628	1	52	100 STAIRWAY5	27	Sidewalk: Curb side : Cutout	Tree	1			6	30
1363	19612	1	100	100 STAIRWAY5	11	Sidewalk: Curb side : Cutout	Tree	1			6	30
1393	255136	1	11	401X Brotherhood Way	14	Sidewalk: Property side : Yard	Tree	1
1398	20032	1	19	100 STAIRWAY51	3	Sidewalk: Curb side : Cutout	Tree	1			3	3X3ST
1404	19975	1	150	100 STAIRWAY45	2	Sidewalk: Curb side : Cutout	Tree	1			3	30ST
1420	19991	1	52	100 STAIRWAY46	11	Sidewalk: Curb side : Cutout	Tree	1			12	40
1422	259801	1	18	1180x Brussels St	2	Sidewalk: Curb side : Cutout	Tree	1	FUF	03/30/2019 12:00:00 AM	3
1476	20456	1	155	495X Sunset Blvd	21	Sidewalk: Curb side : Cutout	Tree	1			36	60
1492	20444	1	16	495X Sunset Blvd	9	Sidewalk: Curb side : Cutout	Tree	1			12	15
1504	19794	1	160	100 STAIRWAY19	16	Sidewalk: Curb side : Cutout	Tree	1			18	50ST
1511	260421	1	8	200x Bacon St	5	Sidewalk: Curb side : Cutout	Tree	1	FUF	08/17/2019 12:00:00 AM	3
1517	19783	1	167	100 STAIRWAY19	5	Sidewalk: Curb side : Cutout	Tree	1			6	50ST
1531	20287	1	15	20X Sunset Blvd	8	Sidewalk: Curb side : Cutout	Tree	1			12	60
1577	19793	1	122	100 STAIRWAY19	15	Sidewalk: Curb side : Cutout	Tree	1			6	20ST
1581	19590	1	37	100 STAIRWAY4	13	Sidewalk: Curb side : Cutout	Tree	1			3	60
1595	19920	1	150	100 STAIRWAY36	-2	Sidewalk: Curb side : Cutout	Tree	1			6	3X3
1623	20078	1	198	100 STAIRWAY56	1	Sidewalk: Curb side : Cutout	Tree	1			24	5X5
1646	19899	1	64	100 STAIRWAY33	31	Sidewalk: Curb side : Cutout	Tree	1			12	25ST
1654	19584	1	109	100 STAIRWAY4	7	Sidewalk: Curb side : Cutout	Tree	1			3	60
1695	19761	1	105	100 STAIRWAY15	19	Sidewalk: Curb side : Cutout	Tree	1			3	20ST
1723	19755	1	28	100 STAIRWAY15	13	Sidewalk: Curb side : Cutout	Tree	1			6	3X3
1736	255231	1	11	300X Goettingen St	6	Sidewalk: Curb side : Cutout	Tree	1	FUF
1770	122656	1	75	300x Hickory St	12	Sidewalk: Curb side : Cutout	Tree	2		11/10/2016 12:00:00 AM	3	3x3
1774	19805	1	105	100 STAIRWAY22	4	Sidewalk: Curb side : Cutout	Tree	1			6	20
1785	19984	1	100	100 STAIRWAY46	4	Sidewalk: Curb side : Cutout	Tree	1			18	40
1786	19661	1	127	100 STAIRWAY5	60	Sidewalk: Curb side : Cutout	Tree	1			12	60ST
1837	19878	1	150	100 STAIRWAY33	10	Sidewalk: Curb side : Cutout	Tree	1			12	25ST
1845	20002	1	28	100 STAIRWAY46	22	Sidewalk: Curb side : Cutout	Tree	1			6	2

trees

Custom SQL query returning 101 rows (hide)

Query parameters