sf-trees

This data as json, CSV

rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
109	9895	3	40	1800X Pine St	1	1	1	2			18	3X3		6005051.0377	2115464.4068	37.7889474242075	-122.426360597873	(37.7889474242075, -122.426360597873)
1680	251668	2	40	301x Laguna Honda Blvd	1	9	1	1				3x3		5995349.0	2100852.0	37.7482723626065	-122.458869747183	(37.7482723626065, -122.458869747183)
1707	19767	3	40	100 STAIRWAY16	6	1	1	2			12	30ST
1811	19991	3	40	100 STAIRWAY46	11	1	1	2			12	40
1842	19990	3	40	100 STAIRWAY46	10	1	1	2			6	40
2751	19916	3	40	100 STAIRWAY35	12	1	1	2			6	120ST
2761	253204	2	40	2253 09th Ave	1	5	1	1				3x3		5993186.0	2100608.0	37.7474778324271	-122.466331547971	(37.7474778324271, -122.466331547971)
2763	253205	2	40	2253 09th Ave	2	5	1	1				3x3		5993186.0	2100608.0	37.7474778324271	-122.466331547971	(37.7474778324271, -122.466331547971)
5450	19643	3	40	100 STAIRWAY5	42	1	1	2			12	30
5580	19952	3	40	100 STAIRWAY39	9	1	1	2			12	25ST
5629	19629	3	40	100 STAIRWAY5	28	1	1	2			6	30
5638	19734	3	40	100 STAIRWAY14	12	1	1	2			12	40ST
6130	19637	3	40	100 STAIRWAY5	36	1	1	2			12	30
6465	20050	3	40	100 STAIRWAY52	6	1	1	2			12	10
6552	19622	3	40	100 STAIRWAY5	21	1	1	2			12	30
6727	20046	3	40	100 STAIRWAY52	2	1	1	2			3	10
6840	19703	3	40	100 STAIRWAY13	1	1	1	2			12	40ST
6859	19881	3	40	100 STAIRWAY33	13	1	1	2			12	25ST
7127	19877	3	40	100 STAIRWAY33	9	1	1	2			24	25ST
8000	19575	3	40	100 STAIRWAY1	10	1	1	2			36	100ST
8376	17629	3	40	150 Phelps St	2	1	1	2			12	10M
8874	19879	3	40	100 STAIRWAY33	11	1	1	2			12	25ST
8891	19873	3	40	100 STAIRWAY33	5	1	1	2			30	25ST
9101	19626	3	40	100 STAIRWAY5	25	1	1	2			12	30
9670	19824	3	40	100 STAIRWAY25	8	1	1	2			6	10ST
10110	17260	3	40	29 Osceola Ln	1	1	1	2		01/27/2017 12:00:00 AM	18	3X3		6017247.640204701	2094279.3298336002	37.73145956022589	-122.382686794637	(37.7314595602259, -122.382686794637)
10584	19572	3	40	100 STAIRWAY1	6	1	1	2			24	100ST
10624	19574	3	40	100 STAIRWAY1	8	1	1	2			12	100ST
10757	19823	3	40	100 STAIRWAY25	7	1	1	2			6	10ST
10946	19995	3	40	100 STAIRWAY46	15	1	1	2			12	40
11109	19996	3	40	100 STAIRWAY46	16	1	1	2			12	40
11188	19822	3	40	100 STAIRWAY25	6	1	1	2			6	10ST
11496	19573	3	40	100 STAIRWAY1	7	1	1	2			12	100ST
11523	19635	3	40	100 STAIRWAY5	34	1	1	2			12	30
11623	19765	3	40	100 STAIRWAY16	4	1	1	2			12	30ST
12152	19571	3	40	100 STAIRWAY1	5	1	1	2			24	100ST
12720	19640	3	40	100 STAIRWAY5	39	1	1	2			6	30
12830	19619	3	40	100 STAIRWAY5	18	1	1	2			12	30
12952	19628	3	40	100 STAIRWAY5	27	1	1	2			6	30
13122	19636	3	40	100 STAIRWAY5	35	1	1	2			12	30
13156	20391	3	40	262X Sunset Blvd	37	1	1	2			12	60
13294	187652	2	40	46 Cragmont Ave	1	1	1	1				3x3		5992908.0	2101735.0	37.750556241076204	-122.467374782979	(37.7505562410762, -122.467374782979)
13560	20028	3	40	100 STAIRWAY49	1	1	1	2			12	10
13632	19618	3	40	100 STAIRWAY5	17	1	1	2			6	30
13773	19987	3	40	100 STAIRWAY46	7	1	1	2			6	40
13854	11422	3	40	803X Mendell St	1	1	1	2			24	3X3		6016040.90005	2096755.8649799998	37.738192886184	-122.38703142706001	(37.738192886184, -122.38703142706)
13883	19639	3	40	100 STAIRWAY5	38	1	1	2			6	30
14157	17628	3	40	150 Phelps St	1	1	1	2			12	10M
14188	19617	3	40	100 STAIRWAY5	16	1	1	2			6	30
14354	17473	3	40	2050X Palou Ave	8	1	1	2		11/17/1992 12:00:00 AM	12	3X3		6012341.587169999	2097177.38743	37.73914476102	-122.39985148498	(37.73914476102, -122.39985148498)
14387	22148	3	40	3800 03rd St	3	1	1	2			6	3x3		6015737.9632	2098284.4406	37.7423732631069	-122.388185488874	(37.7423732631069, -122.388185488874)
14502	17475	3	40	2050X Palou Ave	10	1	1	2			12	3X3		6012301.79777	2097206.74854	37.7392231621197	-122.399991120917	(37.7392231621197, -122.399991120917)
14653	19921	3	40	100 STAIRWAY37	1	1	1	2			12	3X3
15123	116637	2	40	2100 20th St	2	1	1	1		06/13/2016 12:00:00 AM	3	3x3		6011768.89448	2104683.8431599997	37.759723915951206	-122.40235926517799	(37.7597239159512, -122.402359265178)
15242	22432	3	40	6000 03rd St	1	1	1	2			18	3X3		6013579.8961	2091555.5712	37.7237773618259	-122.39517625529	(37.7237773618259, -122.39517625529)
15445	19918	3	40	100 STAIRWAY35	14	1	1	2			6	120ST
15480	116639	2	40	2100 20th St	4	1	1	1		06/13/2016 12:00:00 AM	3	3x3		6011723.51737	2104681.2870400003	37.7597143642338	-122.402516023304	(37.7597143642338, -122.402516023304)
15768	19884	3	40	100 STAIRWAY33	16	1	1	2			18	25ST
15790	87061	1	40			19	1	1				3x3	Permit Number 50003
15852	19567	3	40	100 STAIRWAY1	1	1	1	2			24	100ST
15947	19630	3	40	100 STAIRWAY5	29	1	1	2			12	30
16203	19623	3	40	100 STAIRWAY5	22	1	1	2			12	30
16222	19870	3	40	100 STAIRWAY33	2	1	1	2			36	25ST
16278	19770	3	40	100 STAIRWAY16	9	1	1	2			6	30ST
16313	19876	3	40	100 STAIRWAY33	8	1	1	2			12	25ST
16376	19641	3	40	100 STAIRWAY5	40	1	1	2			12	30
16404	15023	1	40	835 Mendell St	1	1	1	1		03/23/2005 12:00:00 AM	3	3x3		6015961.32258	2096647.62103	37.7378912634786	-122.387299020359	(37.7378912634786, -122.387299020359)
16486	19701	3	40	100 STAIRWAY12	1	1	1	2			12	60
16694	104424	2	40	917 Rhode Island St	2	1	1	1			12	3x3		6011907.00978	2104135.17777	37.7582251112167	-122.401843021952	(37.7582251112167, -122.401843021952)
16837	116638	2	40	2100 20th St	3	1	1	1		06/13/2016 12:00:00 AM	3	3x3		6011745.2802099995	2104684.37435	37.75972405623921	-122.402440973074	(37.7597240562392, -122.402440973074)
16953	19917	3	40	100 STAIRWAY35	13	1	1	2			6	120ST
18187	40261	1	40	3543 24th St	1	1	1	1	1	03/16/2005 12:00:00 AM			Permit Number 47928	6005992.45992589	2101968.12777251	37.751943042038704	-122.422144186794	(37.7519430420387, -122.422144186794)
19129	12492	1	40	307 Lake Merced Blvd	37	1	1	13			36	90M		5985224.7663097	2094165.6248746999	37.7293262181041	-122.49338600271003	(37.7293262181041, -122.49338600271)
19504	52712	1	40	53@ FAIR AVE Coleridge St	1	1	1	1	1	03/31/2006 12:00:00 AM			Permit Number 48768	6006913.27477728	2099421.81000315	37.745003324352204	-122.418779304454	(37.7450033243522, -122.418779304454)
23642	176313	3	40	500x Mansell St	18	11	1	2			38	Width 0ft		6010259.13784	2090270.57035	37.7200637812891	-122.40656510840799	(37.7200637812891, -122.406565108408)
24910	113499	3	40	200x Mansell St	5	11	1	2			19	3x3		6011193.56936	2090563.5306400002	37.7209204242214	-122.403355677147	(37.7209204242214, -122.403355677147)
25099	224199	2	40	1001 San Jose Ave	35	7	1	1			16			6005272.32245	2097108.7115200001	37.738559550591795	-122.42428894459299	(37.7385595505918, -122.424288944593)
26478	63265	1	40	1760 Golden Gate Ave	1	1	1	1	1	04/13/1987 12:00:00 AM	25		Permit Number 24158	6001156.49330664	2111800.30825294	37.7786658324282	-122.439572390689	(37.7786658324282, -122.439572390689)
28478	176327	3	40	700x Mansell St	31	11	1	2			46	Width 0ft		6009212.31958	2089948.46975	37.7191207387124	-122.41016088932699	(37.7191207387124, -122.410160889327)
28658	187032	2	40	2501 Sunset Blvd	51	9	1	1			11	Width 0ft		5984967.607000001	2097835.0603	37.73938646460329	-122.494545412715	(37.7393864646033, -122.494545412715)
28724	199407	3	40	301x Cashmere St	7	3	1	2			18			6016184.136419999	2096191.07332	37.736650012889	-122.386496812495	(37.736650012889, -122.386496812495)
29001	137844	2	40	1957 WEBSTER ST	1	1	1	1			11	Width 0ft		6003342.7396	2115504.846	37.7889617474845	-122.43227396506398	(37.7889617474845, -122.432273965064)
30294	176308	3	40	300x Mansell St	12	11	1	2			23	Width 0ft		6010842.734619999	2090461.59096	37.7206209176161	-122.404561241708	(37.7206209176161, -122.404561241708)
30521	17266	3	40	40 Osceola Dr	1	1	1	2			18	3X3		6017197.543092299	2094354.669125	37.7316636592684	-122.382865232677	(37.7316636592684, -122.382865232677)
31769	224212	2	40	1000 San Jose Ave	2	7	1	1			9			6005187.142969999	2097371.8747799997	37.739277327390795	-122.42460216947501	(37.7392773273908, -122.424602169475)
32548	244479	2	40	124 Lily St	1	1	1	1			2	Width 0ft		6005906.1302	2110197.2252	37.7745333330343	-122.423027565946	(37.7745333330343, -122.423027565946)
34116	224214	2	40	1000 San Jose Ave	5	7	1	1			25			6005180.62218	2097351.71746	37.73922161167361	-122.424623281961	(37.7392216116736, -122.424623281961)
35856	142225	2	40	641 HAYES ST	1	1	1	1			14	Width 0ft		6004777.6628	2110866.818	37.7763081284007	-122.42697885578698	(37.7763081284007, -122.426978855787)
36490	176307	3	40	300x Mansell St	7	11	1	2			14	Width 0ft		6010889.97096	2090468.7148799999	37.7206431182563	-122.404398460825	(37.7206431182563, -122.404398460825)
36977	186970	3	40	1650x Sloat Blvd	1	11	1	2			10	Width 0ft		5986025.4295	2095869.2083	37.734050611594604	-122.49074337328301	(37.7340506115946, -122.490743373283)
37371	176317	3	40	600x Mansell St	5	11	1	2			20	Width 0ft		6009952.88344	2090194.2340000002	37.7198370388417	-122.40761835123199	(37.7198370388417, -122.407618351232)
37917	199398	2	40	1027 Jamestown Ave	1	2	1	1			5			6013845.577380001	2089711.9694400001	37.718729970701396	-122.394128826289	(37.7187299707014, -122.394128826289)
39778	122380	2	40	557 Grove St	1	1	1	1			18	3x3		6005149.0	2111246.0	37.777370259808	-122.42572129147301	(37.777370259808, -122.425721291473)
39821	224196	2	40	1001 San Jose Ave	16	7	1	1			15			6005192.428069999	2096936.6445	37.73808258165379	-122.424552945066	(37.7380825816538, -122.424552945066)
40004	34491	1	40	1723 Alabama St	1	1	1	1	1	07/15/1997 12:00:00 AM			Permit Number 38214	6009344.79247114	2099429.66611089	37.745161501342295	-122.410372074504	(37.7451615013423, -122.410372074504)
40506	176323	3	40	700x Mansell St	23	11	1	2			31	Width 0ft		6009342.20287	2090002.90208	37.719277477945	-122.40971577078399	(37.719277477945, -122.409715770784)
41295	187029	2	40	2501 Sunset Blvd	48	9	1	1			38	Width 0ft		5984947.4301	2097843.1311	37.7394074439231	-122.49461576933999	(37.7394074439231, -122.49461576934)
42868	176330	3	40	700x Mansell St	35	11	1	2			7	Width 0ft		6009184.10476	2089961.98667	37.7191562718235	-122.41025937136801	(37.7191562718235, -122.410259371368)
43878	187030	2	40	2501 Sunset Blvd	49	9	1	1			16	Width 0ft		5984957.5185	2097843.1311	37.7394080343891	-122.49458088860901	(37.7394080343891, -122.494580888609)
44361	247091	2	40	2301 Castro St	9	7	1	1			15			6002747.911280001	2098608.69961	37.7425353031757	-122.43312428277099	(37.7425353031757, -122.433124282771)
44683	176302	3	40	100x Mansell St	2	11	1	2			18	Width 0ft		6011513.54745	2090660.92357	37.721205711656204	-122.40225644658301	(37.7212057116562, -122.402256446583)

sf-trees

Custom SQL query returning 101 rows (hide)

Query parameters