trees

This data as json, CSV

rowid	TreeID	qLegalStatus_id	qSpecies_id	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker_id	qCareAssistant	PlantDate	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
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
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
1886	20313	1	15	101X Sunset Blvd	2	Sidewalk: Curb side : Cutout	Tree	1			12	60
1908	119794	1	31	201x Octavia St	2	Median : Cutout	Tree	1					2110122	6005581	47.2699969117914	-138.280716869623	(47.2699969117914, -138.280716869623)
1923	20027	1	70	100 STAIRWAY48	11	Sidewalk: Curb side : Cutout	Tree	1			6	10ST
1929	19668	1	208	100 STAIRWAY5	67	Sidewalk: Curb side : Cutout	Tree	1			12	60ST
1935	19720	1	109	100 STAIRWAY13	18	Sidewalk: Curb side : Cutout	Tree	1			3	40ST
1944	260235	1	10	2201x 22nd Ave	31	Sidewalk: Curb side : Cutout	Tree	1	FUF	10/20/2018 12:00:00 AM	3
1959	19904	1	59	100 STAIRWAY34	2	Sidewalk: Curb side : Cutout	Tree	1			12	6X6
1967	259348	1	6	450x Burrows St	2	Sidewalk: Curb side : Cutout	Tree	1	FUF	04/27/2019 12:00:00 AM	3
1982	20405	1	15	262X Sunset Blvd	50	Sidewalk: Curb side : Cutout	Tree	1			6	60
2026	19643	1	52	100 STAIRWAY5	42	Sidewalk: Curb side : Cutout	Tree	1			12	30
2034	260230	1	10	2201x 22nd Ave	26	Sidewalk: Curb side : Cutout	Tree	1	FUF	10/20/2018 12:00:00 AM	3
2047	20346	1	63	101X Sunset Blvd	32	Sidewalk: Curb side : Cutout	Tree	1			18	40
2169	19944	1	150	100 STAIRWAY39	1	Sidewalk: Curb side : Cutout	Tree	1			6	25ST
2214	20033	1	36	100 STAIRWAY51	4	Sidewalk: Curb side : Cutout	Tree	1			6	ST
2217	20079	1	198	100 STAIRWAY56	2	Sidewalk: Curb side : Cutout	Tree	1			24	3X3
2286	20017	1	56	100 STAIRWAY48	1	Sidewalk: Curb side : Cutout	Tree	1			18	10ST
2290	259356	1	152	1700 Jennings St	1	Sidewalk: Curb side : Cutout	Tree	1	FUF	05/25/2019 12:00:00 AM	3
2302	19935	1	41	100 STAIRWAY38	4	Sidewalk: Curb side : Cutout	Tree	1			12	10ST
2304	19829	1	70	100 STAIRWAY25	13	Sidewalk: Curb side : Cutout	Tree	1			6	60X
2306	19600	1	185	100 STAIRWAY4	23	Sidewalk: Curb side : Cutout	Tree	1			12	60
2382	255210	1	89	1 Burrows St	1	Sidewalk: Curb side : Cutout	Tree	1	FUF
2386	19745	1	93	100 STAIRWAY15	1	Sidewalk: Curb side : Cutout	Tree	1			6	3X3
2397	19696	1	68	100 STAIRWAY9	-3	Sidewalk: Curb side : Cutout	Tree	1			12	15ST
2427	19795	1	230	100 STAIRWAY20	1	Sidewalk: Curb side : Cutout	Tree	1			12	15ST
2429	19676	1	100	100 STAIRWAY5	75	Sidewalk: Curb side : Cutout	Tree	1			12	60ST
2447	19649	1	127	100 STAIRWAY5	48	Sidewalk: Curb side : Cutout	Tree	1			12	60ST
2475	259866	1	1	101x Desmond St	2	Sidewalk: Curb side : Cutout	Tree	1	FUF	03/30/2019 12:00:00 AM	3
2511	20282	1	16	20X Sunset Blvd	3	Sidewalk: Curb side : Cutout	Tree	1			12	60
2538	20304	1	16	50X Sunset Blvd	6	Sidewalk: Curb side : Cutout	Tree	1			12	60
2564	20333	1	27	101X Sunset Blvd	21	Sidewalk: Curb side : Cutout	Tree	1			24	60
2568	20451	1	15	495X Sunset Blvd	16	Sidewalk: Curb side : Cutout	Tree	1			42	60
2572	20316	1	56	101X Sunset Blvd	5	Sidewalk: Curb side : Cutout	Tree	1			42	60
2582	19774	1	167	100 STAIRWAY17	4	Sidewalk: Curb side : Cutout	Tree	1			6	20ST
2605	19985	1	31	100 STAIRWAY46	5	Sidewalk: Curb side : Cutout	Tree	1			3	40
2624	19842	1	240	100 STAIRWAY25	26	Sidewalk: Curb side : Cutout	Tree	1			12	10ST
2635	259636	1	45	98x Arleta Ave	2	Sidewalk: Curb side : Cutout	Tree	1	FUF	06/01/2019 12:00:00 AM	3
2649	20050	1	52	100 STAIRWAY52	6	Sidewalk: Curb side : Cutout	Tree	1			12	10
2684	19830	1	240	100 STAIRWAY25	14	Sidewalk: Curb side : Cutout	Tree	1			24	60X
2687	19642	1	100	100 STAIRWAY5	41	Sidewalk: Curb side : Cutout	Tree	1			12	30
2725	118348	1	30	100X Guerrero St	3	Median : Cutout	Tree	1		07/15/2016 06:19:00 AM	3
2726	260522	1	242	3440x Santiago St	1	Sidewalk: Curb side : Cutout	Tree	1	FUF	07/27/2019 12:00:00 AM	3
2744	261957	1	41	1X Portola Dr To Clipper St Connetion	11	Sidewalk: Property side : Yard	Tree	1
2812	19775	1	15	100 STAIRWAY18	1	Sidewalk: Curb side : Cutout	Tree	1			12	50ST
2826	20064	1	122	100 STAIRWAY54	11	Sidewalk: Curb side : Cutout	Tree	1			6	15ST
2858	261960	1	41	1X Portola Dr To Clipper St Connetion	14	Sidewalk: Property side : Yard	Tree	1
2868	255125	1	28	401X Brotherhood Way	3	Sidewalk: Property side : Yard	Tree	1
2883	19735	1	100	100 STAIRWAY14	13	Sidewalk: Curb side : Cutout	Tree	1			12	40ST
2887	255158	1	11	3098 Turk St	3	Sidewalk: Curb side : Cutout	Tree	1		03/17/2018 12:00:00 AM	3
2950	19885	1	243	100 STAIRWAY33	17	Sidewalk: Curb side : Cutout	Tree	1			6	25ST
3000	20052	1	15	100 STAIRWAY53	1	Sidewalk: Curb side : Cutout	Tree	1			12	30
3011	19948	1	41	100 STAIRWAY39	5	Sidewalk: Curb side : Cutout	Tree	1			18	25ST
3018	19802	1	105	100 STAIRWAY22	1	Sidewalk: Curb side : Cutout	Tree	1			12	20
3028	19906	1	41	100 STAIRWAY35	2	Sidewalk: Curb side : Cutout	Tree	1			6	120ST
3035	259640	1	45	198x Arleta Ave	1	Sidewalk: Curb side : Cutout	Tree	1	FUF	06/01/2019 12:00:00 AM	3
3041	19585	1	100	100 STAIRWAY4	8	Sidewalk: Curb side : Cutout	Tree	1			3	60
3052	19908	1	41	100 STAIRWAY35	4	Sidewalk: Curb side : Cutout	Tree	1			6	120ST
3055	20039	1	7	100 STAIRWAY51	10	Sidewalk: Curb side : Cutout	Tree	1			3	ST
3078	19568	1	41	100 STAIRWAY1	2	Sidewalk: Curb side : Cutout	Tree	1			48	100ST
3083	19706	1	117	100 STAIRWAY13	4	Sidewalk: Curb side : Cutout	Tree	1			6	40ST
3091	19871	1	58	100 STAIRWAY33	3	Sidewalk: Curb side : Cutout	Tree	1			12	25ST
3098	20419	1	41	453X Sunset Blvd	8	Sidewalk: Curb side : Cutout	Tree	1			12	60
3100	19586	1	109	100 STAIRWAY4	9	Sidewalk: Curb side : Cutout	Tree	1			3	60
3106	20323	1	15	101X Sunset Blvd	11	Sidewalk: Curb side : Cutout	Tree	1			12	60
3117	260221	1	6	2201x 22nd Ave	13	Sidewalk: Curb side : Cutout	Tree	1	FUF	10/20/2018 12:00:00 AM	3
3125	20020	1	70	100 STAIRWAY48	4	Sidewalk: Curb side : Cutout	Tree	1			6	10ST
3129	20059	1	122	100 STAIRWAY54	6	Sidewalk: Curb side : Cutout	Tree	1			12	15ST
3183	260224	1	6	2201x 22nd Ave	20	Sidewalk: Curb side : Cutout	Tree	1	FUF	10/20/2018 12:00:00 AM	3
3191	19565	1	41	100 STAIRWAY1	-11	Sidewalk: Curb side : Cutout	Tree	1			36	100ST
3196	19917	1	52	100 STAIRWAY35	13	Sidewalk: Curb side : Cutout	Tree	1			6	120ST
3208	19988	1	254	100 STAIRWAY46	8	Sidewalk: Curb side : Cutout	Tree	1			6	40
3211	19860	1	100	100 STAIRWAY30	4	Sidewalk: Curb side : Cutout	Tree	1			24	30ST
3222	20014	1	155	100 STAIRWAY47	2	Sidewalk: Curb side : Cutout	Tree	1			12	100ST
3227	259338	1	4	2x Silliman St	2	Sidewalk: Curb side : Cutout	Tree	1	FUF	04/27/2019 12:00:00 AM	3
3232	20054	1	122	100 STAIRWAY54	1	Sidewalk: Curb side : Cutout	Tree	1			6	15ST
3265	255205	1	8	320 Bacon St	1	Sidewalk: Curb side : Cutout	Tree	1	FUF
3284	19710	1	117	100 STAIRWAY13	8	Sidewalk: Curb side : Cutout	Tree	1			6	40ST
3296	19833	1	109	100 STAIRWAY25	17	Sidewalk: Curb side : Cutout	Tree	1			18	60X
3319	255128	1	28	401X Brotherhood Way	6	Sidewalk: Property side : Yard	Tree	1
3339	19580	1	16	100 STAIRWAY4	3	Sidewalk: Curb side : Cutout	Tree	1			3	8
3352	20327	1	27	101X Sunset Blvd	15	Sidewalk: Curb side : Cutout	Tree	1			18	60
3373	119797	1	31	201x Octavia St	5	Median : Cutout	Tree	1					2110122	6005581	47.2699969117914	-138.280716869623	(47.2699969117914, -138.280716869623)
3379	258367	1	18	901 Silliman St		Sidewalk: Curb side : Cutout	Tree	1	FUF			4x5
3417	119788	1	31	202x Octavia St Frontage East	8	Median : Cutout	Tree	1					2110143	6005643	47.270172161735	-138.280681481725	(47.270172161735, -138.280681481725)
3442	20392	1	41	262X Sunset Blvd	38	Sidewalk: Curb side : Cutout	Tree	1			12	60
3448	19730	1	100	100 STAIRWAY14	8	Sidewalk: Curb side : Cutout	Tree	1			6	40ST
3449	19754	1	28	100 STAIRWAY15	12	Sidewalk: Curb side : Cutout	Tree	1			6	3X3
3457	20016	1	56	100 STAIRWAY48	0	Sidewalk: Curb side : Cutout	Tree	1			18	10ST
3460	20048	1	64	100 STAIRWAY52	4	Sidewalk: Curb side : Cutout	Tree	1			12	10
3477	259101	1	11	600 Visitacion Ave	3	Sidewalk: Curb side : Cutout	Tree	1	FUF	03/30/2019 12:00:00 AM	3
3511	254247	1	12	100x Beale St	3	Sidewalk: Curb side : Cutout	Tree	1		02/13/2018 12:00:00 AM	3
3527	19876	1	52	100 STAIRWAY33	8	Sidewalk: Curb side : Cutout	Tree	1			12	25ST
3534	118354	1	30	100X Guerrero St	9	Median : Cutout	Tree	1		07/15/2016 06:05:00 AM	3
3552	19877	1	52	100 STAIRWAY33	9	Sidewalk: Curb side : Cutout	Tree	1			24	25ST

trees

Custom SQL query returning 101 rows (hide)

Query parameters