sf-trees

This data as json, CSV

rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	PlantDate	DBH	PlotSize	PermitNotes
3	119263	3	3	495X Lakeshore Dr	1	3	1	2			10x30
104	251210	3	39	1170 Ingalls St	2	1	1	2	11/02/1992 12:00:00 AM
124	20281	3	2	20X Sunset Blvd	2	1	1	2		12	60
129	20398	3	47	262X Sunset Blvd	43	1	1	2		24	60
255	19810	3	24	100 STAIRWAY24	1	1	1	2		12	100ST
437	20292	3	3	20X Sunset Blvd	13	1	1	2		36	60
501	251171	3	11	201X Cargo Way	37	1	1	2	04/10/2017 11:21:00 AM	3
556	20399	3	3	262X Sunset Blvd	44	1	1	2		42	60
613	20019	3	5	100 STAIRWAY48	3	1	1	2		6	10ST
618	20377	3	47	262X Sunset Blvd	25	1	1	2		48	60
639	20004	3	102	100 STAIRWAY46	24	1	1	2		3	2
738	20446	3	2	495X Sunset Blvd	11	1	1	2		6	15
812	19648	3	105	100 STAIRWAY5	47	1	1	2		12	60ST
838	19815	3	116	100 STAIRWAY24	6	1	1	2		6	100ST
870	117001	3	54	1X Bernal Heights Blvd	1	7	1	2
874	19854	3	114	100 STAIRWAY29	4	1	1	2		3	100ST
886	19568	3	47	100 STAIRWAY1	2	1	1	2		48	100ST
1050	19708	3	130	100 STAIRWAY13	6	1	1	2		6	40ST
1070	19942	3	103	100 STAIRWAY38	11	1	1	2		18	10ST
1098	251438	3	47	2501X Santiago St	1	3	1	2
1109	20024	3	5	100 STAIRWAY48	8	1	1	2		12	10ST
1177	251471	3	137	2423 Market St	1	7	1	2
1221	19739	3	105	100 STAIRWAY14	17	1	1	2		6	40ST
1271	19821	3	140	100 STAIRWAY25	5	1	1	2		24	10ST
1350	19971	3	138	100 STAIRWAY44	2	1	1	2		12	15
1378	19687	3	105	100 STAIRWAY5	86	1	1	2		12	60ST
1393	19861	3	105	100 STAIRWAY30	5	1	1	2		24	30ST
1434	20063	3	42	100 STAIRWAY54	10	1	1	2		6	15ST
1497	20382	3	2	262X Sunset Blvd	28	1	1	2		18	60
1529	251578	3	62	1000X Columbus Ave	6	11	1	2
1647	20023	3	5	100 STAIRWAY48	7	1	1	2		12	10ST
1665	251650	3	15	101X Vicente St	1	1	1	2			3x3
1707	19767	3	40	100 STAIRWAY16	6	1	1	2		12	30ST
1811	19991	3	40	100 STAIRWAY46	11	1	1	2		12	40
1841	20401	3	3	262X Sunset Blvd	46	1	1	2		12	60
1842	19990	3	40	100 STAIRWAY46	10	1	1	2		6	40
1867	19782	3	157	100 STAIRWAY19	4	1	1	2		6	50ST
1887	20008	3	26	100 STAIRWAY46	28	1	1	2		3	2
1898	20392	3	47	262X Sunset Blvd	38	1	1	2		12	60
1954	20331	3	15	101X Sunset Blvd	19	1	1	2		24	60
1982	118349	3	109	100X Guerrero St	4	11	1	2	07/15/2016 06:43:00 AM	3
2042	20405	3	3	262X Sunset Blvd	50	1	1	2		6	60
2077	19994	3	105	100 STAIRWAY46	14	1	1	2		12	40
2168	118346	3	109	100X Guerrero St	1	11	1	2	07/15/2016 05:47:00 AM	3
2439	19802	3	176	100 STAIRWAY22	1	1	1	2		12	20
2489	119760	3	35	101X Octavia St Frontage West	2	1	1	2			4x4
2490	119764	3	9	101X Octavia St Frontage West	6	1	1	2			4x4
2492	119762	3	35	101X Octavia St Frontage West	4	1	1	2			4x4
2496	119765	3	9	101X Octavia St Frontage West	7	1	1	2			4x4
2501	119761	3	35	101X Octavia St Frontage West	3	1	1	2			4x4
2508	119759	3	35	101X Octavia St Frontage West	1	1	1	2			4x4
2509	119763	3	9	101X Octavia St Frontage West	5	1	1	2			4x4
2510	19722	3	105	100 STAIRWAY13	20	1	1	2		12	40ST
2551	20356	3	181	262X Sunset Blvd	6	1	1	2		12	60
2559	19580	3	2	100 STAIRWAY4	3	1	1	2		3	8
2700	20053	3	3	100 STAIRWAY53	2	1	1	2		12	30
2751	19916	3	40	100 STAIRWAY35	12	1	1	2		6	120ST
2766	118353	3	109	100X Guerrero St	8	11	1	2	07/15/2016 05:58:00 AM	3
2790	20006	3	26	100 STAIRWAY46	26	1	1	2		6	2
3007	253279	2	9	201X Laguna Honda Blvd	1	9	1	2			10x10	ROW IS 10' tree is street tree
3019	20034	3	16	100 STAIRWAY51	5	1	1	2		3	ST
3026	19742	3	130	100 STAIRWAY15	-9	1	1	2		6	1OST
3087	19650	3	36	100 STAIRWAY5	49	1	1	2		12	60ST
3111	118355	3	109	100X Guerrero St	10	11	1	2	07/15/2016 06:48:00 AM	3
3176	19993	3	105	100 STAIRWAY46	13	1	1	2		12	40
3394	118348	3	109	100X Guerrero St	3	11	1	2	07/15/2016 06:19:00 AM	3
3403	19880	3	198	100 STAIRWAY33	12	1	1	2		6	25ST
3537	102838	2	3	1101X Portola Dr	1	9	1	2
3586	253468	3	213	801X Alemany Blvd	1	17	1	2
3716	20054	3	42	100 STAIRWAY54	1	1	1	2		6	15ST
3723	253167	3	12	1X Brotherhood Way	1	7	1	2
3819	19829	3	5	100 STAIRWAY25	13	1	1	2		6	60X
3857	19783	3	102	100 STAIRWAY19	5	1	1	2		6	50ST
3884	20320	3	103	101X Sunset Blvd	9	1	1	2		42	60
3951	20035	3	16	100 STAIRWAY51	6	1	1	2		3	ST
3979	19911	3	34	100 STAIRWAY35	7	1	1	2		12	120ST
4106	20001	3	198	100 STAIRWAY46	21	1	1	2		6	2
4187	20426	3	3	453X Sunset Blvd	15	1	1	2		12	60
4215	118354	3	109	100X Guerrero St	9	11	1	2	07/15/2016 06:05:00 AM	3
4260	20045	3	3	100 STAIRWAY52	1	1	1	2		12	10
4277	19665	3	203	100 STAIRWAY5	64	1	1	2		18	60ST
4353	20010	3	105	100 STAIRWAY47	19	1	1	2		12	100ST
4374	118351	3	109	100X Guerrero St	6	11	1	2	07/15/2016 06:32:00 AM	3
4452	19593	3	116	100 STAIRWAY4	16	1	1	2		3	60
4482	20388	3	3	262X Sunset Blvd	34	1	1	2		24	60
4528	19968	3	3	100 STAIRWAY43	1	1	1	2		12	15
4862	19656	3	36	100 STAIRWAY5	55	1	1	2		18	60ST
4995	20353	3	181	262X Sunset Blvd	3	1	1	2		6	60
5082	19803	3	176	100 STAIRWAY22	2	1	1	2		6	20
5282	20344	3	3	101X Sunset Blvd	30	1	1	2		24	40
5308	19644	3	105	100 STAIRWAY5	43	1	1	2		12	30
5341	19786	3	22	100 STAIRWAY19	8	1	1	2		6	50ST
5363	20357	3	181	262X Sunset Blvd	7	1	1	2		12	60
5366	19799	3	26	100 STAIRWAY21	4	1	1	2		3	40ST
5387	19659	3	105	100 STAIRWAY5	58	1	1	2		18	60ST
5429	118350	3	109	100X Guerrero St	5	11	1	2	07/15/2016 05:53:00 AM	3
5450	19643	3	40	100 STAIRWAY5	42	1	1	2		12	30
5456	20311	3	3	50X Sunset Blvd	12	1	1	2		36	60
5459	19727	3	105	100 STAIRWAY14	5	1	1	2		3	40ST
5490	20325	3	158	101X Sunset Blvd	13	1	1	2		18	60
5491	19654	3	105	100 STAIRWAY5	53	1	1	2		12	60ST

sf-trees

Custom SQL query returning 101 rows (hide)

Query parameters