sf-trees

This data as json, CSV

rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
697	251362	2	105	1300X Stanyan St	1	14	1	1		3x3	5997565.0	2104877.0	37.7594511396077	-122.451497194349	(37.7594511396077, -122.451497194349)
812	19648	3	105	100 STAIRWAY5	47	1	1	2	12	60ST
1052	187279	3	105	2401 Sunset Blvd	62	3	1	2	4	Width 0ft	5984952.4466	2098301.7622	37.7406670151021	-122.494632227246	(37.7406670151021, -122.494632227246)
1221	19739	3	105	100 STAIRWAY14	17	1	1	2	6	40ST
1378	19687	3	105	100 STAIRWAY5	86	1	1	2	12	60ST
1393	19861	3	105	100 STAIRWAY30	5	1	1	2	24	30ST
2077	19994	3	105	100 STAIRWAY46	14	1	1	2	12	40
2510	19722	3	105	100 STAIRWAY13	20	1	1	2	12	40ST
3176	19993	3	105	100 STAIRWAY46	13	1	1	2	12	40
4353	20010	3	105	100 STAIRWAY47	19	1	1	2	12	100ST
4922	253717	6	105	4101 Balboa St	1	13	1	1			5982822.0	2110967.0	37.7753172554615	-122.50293574331002	(37.7753172554615, -122.50293574331)
5308	19644	3	105	100 STAIRWAY5	43	1	1	2	12	30
5387	19659	3	105	100 STAIRWAY5	58	1	1	2	18	60ST
5459	19727	3	105	100 STAIRWAY14	5	1	1	2	3	40ST
5491	19654	3	105	100 STAIRWAY5	53	1	1	2	12	60ST
5726	19857	3	105	100 STAIRWAY30	1	1	1	2	24	30ST
5788	19610	3	105	100 STAIRWAY5	9	1	1	2	12	30
5861	19728	3	105	100 STAIRWAY14	6	1	1	2	3	40ST
5905	19989	3	105	100 STAIRWAY46	9	1	1	2	6	40
5963	19716	3	105	100 STAIRWAY13	14	1	1	2	12	40ST
5975	19717	3	105	100 STAIRWAY13	15	1	1	2	12	40ST
6263	19679	3	105	100 STAIRWAY5	78	1	1	2	12	60ST
6288	19736	3	105	100 STAIRWAY14	14	1	1	2	12	40ST
6376	19732	3	105	100 STAIRWAY14	10	1	1	2	6	40ST
6511	19865	3	105	100 STAIRWAY30	9	1	1	2	24	100ST
6668	19738	3	105	100 STAIRWAY14	16	1	1	2	6	40ST
6687	20012	3	105	100 STAIRWAY47	21	1	1	2	6	100ST
6806	19743	3	105	100 STAIRWAY15	-8	1	1	2	6	1OST
6907	19603	3	105	100 STAIRWAY5	2	1	1	2	12	30
7097	19984	3	105	100 STAIRWAY46	4	1	1	2	18	40
7220	19937	3	105	100 STAIRWAY38	6	1	1	2	12	10ST
7321	19676	3	105	100 STAIRWAY5	75	1	1	2	12	60ST
7322	19681	3	105	100 STAIRWAY5	80	1	1	2	12	60ST
7622	19686	3	105	100 STAIRWAY5	85	1	1	2	12	60ST
7785	19757	3	105	100 STAIRWAY15	15	1	1	2	3	20ST
7790	19614	3	105	100 STAIRWAY5	13	1	1	2	12	30
7815	19733	3	105	100 STAIRWAY14	11	1	1	2	6	40ST
7954	19613	3	105	100 STAIRWAY5	12	1	1	2	12	30
7972	19791	3	105	100 STAIRWAY19	13	1	1	2	12	20ST
7996	19970	3	105	100 STAIRWAY44	1	1	1	2	12	15
8061	19756	3	105	100 STAIRWAY15	14	1	1	2	3	20ST
8420	19606	3	105	100 STAIRWAY5	5	1	1	2	6	30
8424	19999	3	105	100 STAIRWAY46	19	1	1	2	12	40
8525	19604	3	105	100 STAIRWAY5	3	1	1	2	12	30
8541	19645	3	105	100 STAIRWAY5	44	1	1	2	3	30
8666	19642	3	105	100 STAIRWAY5	41	1	1	2	12	30
8806	19624	3	105	100 STAIRWAY5	23	1	1	2	12	30
9020	19631	3	105	100 STAIRWAY5	30	1	1	2	12	30
9501	19981	3	105	100 STAIRWAY46	1	1	1	2	3	40
9507	20011	3	105	100 STAIRWAY47	20	1	1	2	6	100ST
9536	19616	3	105	100 STAIRWAY5	15	1	1	2	12	30
9543	19690	3	105	100 STAIRWAY5	89	1	1	2	12	60ST
9568	19704	3	105	100 STAIRWAY13	2	1	1	2	6	40ST
9612	19684	3	105	100 STAIRWAY5	83	1	1	2	12	60ST
9616	19685	3	105	100 STAIRWAY5	84	1	1	2	12	60ST
9690	19750	3	105	100 STAIRWAY15	6	1	1	2	6	10ST
9901	3761	3	105	1074 Carolina St	1	11	1	2	12	18	6012458.0	2102979.0	37.755081234351394	-122.39985625989401	(37.7550812343514, -122.399856259894)
10196	173897	2	105	90x Knollview Way	1	13	1	1		3x3	5997593.0	2101480.0	37.7501254274205	-122.451155378281	(37.7501254274205, -122.451155378281)
10253	19673	3	105	100 STAIRWAY5	72	1	1	2	12	60ST
10305	19688	3	105	100 STAIRWAY5	87	1	1	2	12	60ST
10342	19625	3	105	100 STAIRWAY5	24	1	1	2	6	30
10395	19621	3	105	100 STAIRWAY5	20	1	1	2	12	30
10477	20009	3	105	100 STAIRWAY47	18	1	1	2	12	100ST
10508	19634	3	105	100 STAIRWAY5	33	1	1	2	6	30
10617	19585	3	105	100 STAIRWAY4	8	1	1	2	3	60
10720	19638	3	105	100 STAIRWAY5	37	1	1	2	6	30
10871	19847	3	105	100 STAIRWAY26	5	1	1	2	3	30
11056	19730	3	105	100 STAIRWAY14	8	1	1	2	6	40ST
11187	19608	3	105	100 STAIRWAY5	7	1	1	2	12	30
11204	19669	3	105	100 STAIRWAY5	68	1	1	2	12	60ST
11361	19726	3	105	100 STAIRWAY14	4	1	1	2	3	40ST
11448	19992	3	105	100 STAIRWAY46	12	1	1	2	12	40
11615	19744	3	105	100 STAIRWAY15	-7	1	1	2	6	1OST
11781	19715	3	105	100 STAIRWAY13	13	1	1	2	12	40ST
11922	19647	3	105	100 STAIRWAY5	46	1	1	2	12	60ST
11985	19607	3	105	100 STAIRWAY5	6	1	1	2	6	30
12001	19689	3	105	100 STAIRWAY5	88	1	1	2	12	60ST
12046	19609	3	105	100 STAIRWAY5	8	1	1	2	6	30
12146	19652	3	105	100 STAIRWAY5	51	1	1	2	12	60ST
12302	19670	3	105	100 STAIRWAY5	69	1	1	2	12	60ST
12373	19737	3	105	100 STAIRWAY14	15	1	1	2	6	40ST
12436	19632	3	105	100 STAIRWAY5	31	1	1	2	12	30
12468	19723	3	105	100 STAIRWAY14	1	1	1	2	3	40ST
12572	19627	3	105	100 STAIRWAY5	26	1	1	2	12	30
12593	19725	3	105	100 STAIRWAY14	3	1	1	2	6	40ST
12736	19814	3	105	100 STAIRWAY24	5	1	1	2	12	100ST
13174	19731	3	105	100 STAIRWAY14	9	1	1	2	6	40ST
13582	19735	3	105	100 STAIRWAY14	13	1	1	2	12	40ST
13598	19611	3	105	100 STAIRWAY5	10	1	1	2	12	30
13868	19858	3	105	100 STAIRWAY30	2	1	1	2	24	30ST
13915	19633	3	105	100 STAIRWAY5	32	1	1	2	6	30
14263	19658	3	105	100 STAIRWAY5	57	1	1	2	12	60ST
14612	19719	3	105	100 STAIRWAY13	17	1	1	2	12	40ST
14712	19997	3	105	100 STAIRWAY46	17	1	1	2	12	40
14871	19860	3	105	100 STAIRWAY30	4	1	1	2	24	30ST
14976	19859	3	105	100 STAIRWAY30	3	1	1	2	24	30ST
15129	19763	3	105	100 STAIRWAY16	2	1	1	2	6	30ST
15183	19718	3	105	100 STAIRWAY13	16	1	1	2	12	40ST
15518	19867	3	105	100 STAIRWAY30	11	1	1	2	24	100ST
15579	19655	3	105	100 STAIRWAY5	54	1	1	2	12	60ST
15587	19702	3	105	100 STAIRWAY12	2	1	1	2	12	60

sf-trees

Custom SQL query returning 101 rows (hide)

Query parameters