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	Fire Prevention Districts	Police Districts	Supervisor Districts	Zip Codes	Neighborhoods (old)
106	251438	1	41	2501X Santiago St	1	Median : Yard	Tree	1
172	176155	1	41	900X Brotherhood Way	9	Median : Cutout	Tree	1			25	10x10	5988860	2088745	37.7146545182747	-122.480422197946	(37.7146545182747, -122.480422197946)	1	8	4	64	14
190	21328	1	41	2501X Sunset Blvd	28	Sidewalk: Curb side : Cutout	Tree	1			70	60	5985074.8907349	2098188.1189419	37.740362147215	-122.494200494189	(37.740362147215, -122.494200494189)	1	8	3	29491	35
464	173918	1	41	2160X 09th Ave	6	Median : Cutout	Tree	1				6x10	5993671	2100995	37.7485684085064	-122.464682560698	(37.7485684085064, -122.464682560698)	1	8	4	29491	40
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
595	261954	1	41	1X Portola Dr To Clipper St Connetion	8	Sidewalk: Property side : Yard	Tree	1
657	20296	1	41	20X Sunset Blvd	17	Sidewalk: Curb side : Cutout	Tree	1			42	60
720	19950	1	41	100 STAIRWAY39	7	Sidewalk: Curb side : Cutout	Tree	1			12	25ST
795	19570	1	41	100 STAIRWAY1	4	Sidewalk: Curb side : Cutout	Tree	1			48	100ST
1728	262141	1	41	420X Portola Dr	2	Median : Yard	Tree	1	Private			3x3	5998701	2100185	37.7466330487878	-122.44723067426	(37.7466330487878, -122.44723067426)	2	7	5	63	22
1873	20545	1	41	1303X Sunset Blvd	23	Sidewalk: Curb side : Cutout	Tree	1			3	6O	5984802.8376111	2106327.3646052	37.7626943540195	-122.495741360313	(37.7626943540195, -122.495741360313)	1	8	3	56	35
2282	19424	1	41	1000X Sloat Blvd	1	Median : Cutout	Tree	1			24	20	5988569.2838063	2095968.4634055	37.7344714144349	-122.481955851921	(37.7344714144349, -122.481955851921)	1	8	3	64	35
2302	19935	1	41	100 STAIRWAY38	4	Sidewalk: Curb side : Cutout	Tree	1			12	10ST
2418	20917	1	41	1901X Sunset Blvd	26	Sidewalk: Curb side : Cutout	Tree	1			48	60	5984934.4009631	2102260.4913733	37.7515355521167	-122.494986448304	(37.7515355521167, -122.494986448304)	1	8	3	29491	35
2644	113698	1	41	80 LINARES AVE	1	Sidewalk: Curb side : Yard	Tree	1					5994154.8	2102090.7	37.7516048020548	-122.463089089164	(37.7516048020548, -122.463089089164)	1	8	4	29491	40
2744	261957	1	41	1X Portola Dr To Clipper St Connetion	11	Sidewalk: Property side : Yard	Tree	1
2858	261960	1	41	1X Portola Dr To Clipper St Connetion	14	Sidewalk: Property side : Yard	Tree	1
3011	19948	1	41	100 STAIRWAY39	5	Sidewalk: Curb side : Cutout	Tree	1			18	25ST
3028	19906	1	41	100 STAIRWAY35	2	Sidewalk: Curb side : Cutout	Tree	1			6	120ST
3052	19908	1	41	100 STAIRWAY35	4	Sidewalk: Curb side : Cutout	Tree	1			6	120ST
3078	19568	1	41	100 STAIRWAY1	2	Sidewalk: Curb side : Cutout	Tree	1			48	100ST
3098	20419	1	41	453X Sunset Blvd	8	Sidewalk: Curb side : Cutout	Tree	1			12	60
3191	19565	1	41	100 STAIRWAY1	-11	Sidewalk: Curb side : Cutout	Tree	1			36	100ST
3442	20392	1	41	262X Sunset Blvd	38	Sidewalk: Curb side : Cutout	Tree	1			12	60
3453	21247	1	41	2401X Sunset Blvd	11	Sidewalk: Curb side : Cutout	Tree	1			48	60	5985051.1945321	2098862.1753589	37.7422115377949	-122.494332098234	(37.7422115377949, -122.494332098234)	1	8	3	29491	35
3666	113065	1	41	2X Cranleigh Dr	6	Front Yard : Yard	Tree	1		08/18/2016 09:51:00 AM	3		5991370.3	2095943.7	37.7345659248964	-122.472270103664	(37.7345659248964, -122.472270103664)	1	8	4	64	40
3683	20906	1	41	1901X Sunset Blvd	15	Sidewalk: Curb side : Cutout	Tree	1			36	60	5984934.4009631	2102260.4913733	37.7515355521167	-122.494986448304	(37.7515355521167, -122.494986448304)	1	8	3	29491	35
4154	261966	1	41	1X Portola Dr To Clipper St Connetion	20	Sidewalk: Property side : Yard	Tree	1
4324	8533	1	41	2100 Geary Blvd	4	Median : Cutout	Tree	1			18	6	6001504.6387	2113566.4305	37.783534963845	-122.438494596028	(37.783534963845, -122.438494596028)	15	5	11	29490	41
4336	20312	1	41	101X Sunset Blvd	1	Sidewalk: Curb side : Cutout	Tree	1			24	60
4372	21160	1	41	2301 Sunset Blvd	1	Sidewalk: Curb side : Cutout	Tree	1			36	60	5985027.9083074	2099542.6271361	37.744078511576	-122.494462762583	(37.744078511576, -122.494462762583)	1	8	3	29491	35
4462	21326	1	41	2501X Sunset Blvd	26	Sidewalk: Curb side : Cutout	Tree	1			48	60	5985074.8907349	2098188.1189419	37.740362147215	-122.494200494189	(37.740362147215, -122.494200494189)	1	8	3	29491	35
4465	20303	1	41	50X Sunset Blvd	5	Sidewalk: Curb side : Cutout	Tree	1			12	60
4930	20365	1	41	262X Sunset Blvd	15	Sidewalk: Curb side : Cutout	Tree	1			48	60
5295	19947	1	41	100 STAIRWAY39	4	Sidewalk: Curb side : Cutout	Tree	1			18	25ST
5357	19933	1	41	100 STAIRWAY38	2	Sidewalk: Curb side : Cutout	Tree	1			12	10ST
5408	261480	1	41	1000 Portola Dr	9	Median : Yard	Tree	1				10x10	5995664	2098286	37.741244865522	-122.457594860017	(37.741244865522, -122.457594860017)	1	8	4	59	40
5438	20428	1	41	485X Sunset Blvd	1	Sidewalk: Curb side : Cutout	Tree	1			42	40
5522	185128	1	41	1200x Sloat Blvd	5	Median : Cutout	Tree	1			12	Width 0ft	5987683.0779	2095922.3154	37.7342931239465	-122.48501633511	(37.7342931239465, -122.48501633511)	1	8	4	64	35
5813	20297	1	41	20X Sunset Blvd	18	Sidewalk: Curb side : Cutout	Tree	1			36	60
5925	206820	1	41	335x Pacheco St	2	Median : Yard	Tree	1			28	Width 8ft	5994214.91647	2101031.13143	37.7486989587999	-122.462804340247	(37.7486989587999, -122.462804340247)	1	8	4	29491	40
6028	261967	1	41	299x Portola Dr	1	Median : Yard	Tree	1
6439	185119	1	41	1200x Sloat Blvd	6	Median : Cutout	Tree	1			25	Width 0ft	5987585.1902	2095924.1623	37.7342924927912	-122.485354895586	(37.7342924927912, -122.485354895586)	1	8	4	64	35
6583	20407	1	41	262X Sunset Blvd	52	Sidewalk: Curb side : Cutout	Tree	1			36	60
6706	255369	1	41	800X Brotherhood Way	4	Median : Cutout	Tree	1				14x10	5990271	2088582	37.7142888575797	-122.475533361779	(37.7142888575797, -122.475533361779)	1	8	4	64	14
6724	261948	1	41	1X Portola Dr To Clipper St Connetion	2	Sidewalk: Property side : Yard	Tree	1
6786	262148	1	41	420X Portola Dr	9	Median : Yard	Tree	1	Private			3x3	5998701	2100185	37.7466330487878	-122.44723067426	(37.7466330487878, -122.44723067426)	2	7	5	63	22
7317	20294	1	41	20X Sunset Blvd	15	Sidewalk: Curb side : Cutout	Tree	1			24	60
7540	21114	1	41	2201X Sunset Blvd	18	Sidewalk: Curb side : Cutout	Tree	1			36	60	5985004.6737667	2100227.1692458	37.7459567185928	-122.494593556276	(37.7459567185928, -122.494593556276)	1	8	3	29491	35
7644	19569	1	41	100 STAIRWAY1	3	Sidewalk: Curb side : Cutout	Tree	1			48	100ST
7787	19910	1	41	100 STAIRWAY35	6	Sidewalk: Curb side : Cutout	Tree	1			12	120ST
7813	206807	1	41	11x Saint Francis Blvd	1	Median : Yard	Tree	1			12		5991689.22153	2095992.93147	37.7347195542573	-122.471171081279	(37.7347195542573, -122.471171081279)	9	8	4	59	40
8274	2988	1	41	2266X California St	4	Sidewalk: Property side : Cutout	Tree	1			35	3X3	6003528.90719	2115622.95537	37.7892965998021	-122.431638286196	(37.7892965998021, -122.431638286196)	13	9	1	29490	27
8411	19699	1	41	100 STAIRWAY11	1	Sidewalk: Curb side : Cutout	Tree	1			24	40ST
8582	19955	1	41	100 STAIRWAY39	12	Sidewalk: Curb side : Cutout	Tree	1			12	2ST
8619	262142	1	41	420X Portola Dr	3	Median : Yard	Tree	1	Private			3x3	5998701	2100185	37.7466330487878	-122.44723067426	(37.7466330487878, -122.44723067426)	2	7	5	63	22
8755	5050	1	41	5399X Diamond Heights Blvd	11	Sidewalk: Curb side : Cutout	Tree	1			19		6001979.62541	2098516.88417	37.7422395880754	-122.43577421703	(37.7422395880754, -122.43577421703)	2	7	5	63	22
8830	21239	1	41	2401X Sunset Blvd	3	Sidewalk: Curb side : Cutout	Tree	1			36	60	5985051.1945321	2098862.1753589	37.7422115377949	-122.494332098234	(37.7422115377949, -122.494332098234)	1	8	3	29491	35
8866	20398	1	41	262X Sunset Blvd	43	Sidewalk: Curb side : Cutout	Tree	1			24	60
8932	254133	1	41	100X Lake Merced Blvd	7	Median : Yard	Tree	1				10x10	5983894	2095251	37.7322284370415	-122.498066633405	(37.7322284370415, -122.498066633405)	1	8	4	64	35
8937	19804	1	41	100 STAIRWAY22	3	Sidewalk: Curb side : Cutout	Tree	1			6	20
9183	261965	1	41	1X Portola Dr To Clipper St Connetion	19	Sidewalk: Property side : Yard	Tree	1
9387	19932	1	41	100 STAIRWAY38	1	Sidewalk: Curb side : Cutout	Tree	1			12	10ST
9448	251375	1	41	401 Portola Dr	3	Median : Yard	Tree	1					5998962	2100210	37.7467166026546	-122.446329965078	(37.7467166026546, -122.446329965078)	2	7	5	63	22
9662	113066	12	41	2X Cranleigh Dr	7	:	Tree	1		09/09/2015 01:08:00 PM	3		5991370.3	2095943.7	37.7345659248964	-122.472270103664	(37.7345659248964, -122.472270103664)	1	8	4	64	40
9705	261963	1	41	1X Portola Dr To Clipper St Connetion	17	Sidewalk: Property side : Yard	Tree	1
9757	261950	1	41	1X Portola Dr To Clipper St Connetion	4	Sidewalk: Property side : Yard	Tree	1
9922	261964	1	41	1X Portola Dr To Clipper St Connetion	18	Sidewalk: Property side : Yard	Tree	1
10140	106278	1	41	200X VIDAL DR	2	Median : Cutout	Tree	1			60		5987624	2090693	37.7199313280832	-122.484837086298	(37.7199313280832, -122.484837086298)	1	8	4	64	14
10395	260478	6	41	3333 California St	8	Sidewalk: Property side : Cutout	Tree	1				3X3	5998571	2114839	37.7868617958727	-122.448735497123	(37.7868617958727, -122.448735497123)	15	6	1	54	31
10413	20317	1	41	101X Sunset Blvd	6	Sidewalk: Curb side : Cutout	Tree	1			18	60
10605	260507	1	41	50X Carver St	1	Median : Cutout	Tree	1	Private			3x3	6009420	2098346	37.742190207281	-122.410035530349	(37.742190207281, -122.410035530349)	10	7	7	28859	2
11142	20455	1	41	495X Sunset Blvd	20	Sidewalk: Curb side : Cutout	Tree	1			42	60
11294	20417	1	41	453X Sunset Blvd	6	Sidewalk: Curb side : Cutout	Tree	1			42	60
11407	260477	6	41	3333 California St	7	Sidewalk: Property side : Cutout	Tree	1				3X3	5998571	2114839	37.7868617958727	-122.448735497123	(37.7868617958727, -122.448735497123)	15	6	1	54	31
12210	20839	1	41	1801X Sunset Blvd	17	Sidewalk: Curb side : Cutout	Tree	1			36	60	5984911.465596	2102939.293478	37.7533980132231	-122.495115810531	(37.7533980132231, -122.495115810531)	1	8	3	56	35
12224	19907	1	41	100 STAIRWAY35	3	Sidewalk: Curb side : Cutout	Tree	1			12	120ST
12236	20366	1	41	262X Sunset Blvd	16	Sidewalk: Curb side : Cutout	Tree	1			48	60
12293	20434	1	41	485X Sunset Blvd	7	Sidewalk: Curb side : Cutout	Tree	1			12	30
12390	20412	1	41	453X Sunset Blvd	1	Sidewalk: Curb side : Cutout	Tree	1			42	60
12448	261958	1	41	1X Portola Dr To Clipper St Connetion	12	Sidewalk: Property side : Yard	Tree	1
12674	19753	1	41	100 STAIRWAY15	11	Sidewalk: Curb side : Cutout	Tree	1			12	10ST
12679	19813	1	41	100 STAIRWAY24	4	Sidewalk: Curb side : Cutout	Tree	1			12	100ST
12689	22877	1	41	951X Mansell St	4	Median : Cutout	Tree	1			6	3X100	6009106.075934	2090003.4402519	37.7192657205166	-122.410532013931	(37.7192657205166, -122.410532013931)	9	3	7	309	28
12914	20429	1	41	485X Sunset Blvd	2	Sidewalk: Curb side : Cutout	Tree	1			42	30
12968	19943	1	41	100 STAIRWAY38	12	Sidewalk: Curb side : Cutout	Tree	1			12	10ST
13027	261955	1	41	1X Portola Dr To Clipper St Connetion	9	Sidewalk: Property side : Yard	Tree	1
13064	19694	1	41	100 STAIRWAY7	1	Sidewalk: Curb side : Cutout	Tree	1			24	12ST
13121	261953	1	41	1X Portola Dr To Clipper St Connetion	7	Sidewalk: Property side : Yard	Tree	1
13143	19776	1	41	100 STAIRWAY18	2	Sidewalk: Curb side : Cutout	Tree	1			18	50ST
13223	19700	1	41	100 STAIRWAY11	2	Sidewalk: Curb side : Cutout	Tree	1			36	40ST
13332	8534	1	41	2100 Geary Blvd	5	Median : Cutout	Tree	1		06/10/1994 12:00:00 AM	6	6	6001381.7916	2113512.283	37.7833793	-122.438915716928	(37.7833793, -122.438915716928)	15	5	11	29490	41
13417	19945	1	41	100 STAIRWAY39	2	Sidewalk: Curb side : Cutout	Tree	1			6	25ST
13755	11746	1	41	700X Junipero Serra Blvd	29	Median : Cutout	Tree	1		03/03/2006 12:00:00 AM	3	6X6	5991277.67104	2092671.80389	37.7255767576586	-122.472351910013	(37.7255767576586, -122.472351910013)	9	8	4	64	40
13759	190995	1	41	10x Cashmere St	3	Median : Yard	Tree	1			28		6017237.22965	2095860.87095	37.7358015834667	-122.382832806316	(37.7358015834667, -122.382832806316)	10	3	8	58	1
13890	21325	1	41	2501X Sunset Blvd	25	Sidewalk: Curb side : Cutout	Tree	1			48	60	5985074.8907349	2098188.1189419	37.740362147215	-122.494200494189	(37.740362147215, -122.494200494189)	1	8	3	29491	35
13902	115326	1	41	2601X Sunset Blvd	21	Median : Cutout	Tree	1				40	5985098.343425	2097506.3093477	37.7384914535226	-122.494069167367	(37.7384914535226, -122.494069167367)	1	8	3	29491	35
13915	20977	1	41	2002X Sunset Blvd	17	Sidewalk: Curb side : Cutout	Tree	1			36	40	5984887.6165706	2101567.3225095	37.7496295616808	-122.495097123245	(37.7496295616808, -122.495097123245)	1	8	3	29491	35
14026	19949	1	41	100 STAIRWAY39	6	Sidewalk: Curb side : Cutout	Tree	1			24	25ST
14194	261962	1	41	1X Portola Dr To Clipper St Connetion	16	Sidewalk: Property side : Yard	Tree	1

trees

Custom SQL query returning 101 rows (hide)

Query parameters