trees

This data as json, CSV

rowid	TreeID	qLegalStatus_id	qSpecies_id	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker_id	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location	Fire Prevention Districts	Police Districts	Supervisor Districts	Zip Codes	Neighborhoods (old)
8065	255771	2	50	450 Toland St	2	Sidewalk: Curb side : Cutout	Tree	2		07/10/2018 12:00:00 AM	3		Permit Number 779472	6012768.71675	2099101.44192	37.7444516111373	-122.398509629682	(37.7444516111373, -122.398509629682)	10	3	8	58	1
9263	254120	2	27	150 Jennings St	2	Sidewalk: Property side : Yard	Tree	2		01/02/2018 12:00:00 AM	3		Permit Number 781123
17897	254369	2	120	590X Orizaba Ave	2	Back Yard : Yard	Tree	2		02/06/2018 12:00:00 AM	3		Permit Number 778929
34272	115532	2	171	100X Hayes St	2	Sidewalk: Curb side : Pot	Tree	2		02/08/2016 12:00:00 AM	3		Permit Number 770842	6007293.46404	2111265.83422	37.7775456658356	-122.418304279225	(37.7775456658356, -122.418304279225)	7	9	9	28852	36
48155	107646	2	11	1600X Franklin St	2	Sidewalk: Curb side : Cutout	Tree	2		08/01/2016 12:00:00 AM	3		Permit Number 773331	6005773.76538	2115716.99395	37.7896817924241	-122.423878022401	(37.7896817924241, -122.423878022401)	13	9	1	28858	41
60942	247939	2	172	29 Joy St	2	Unaccepted Street : Yard	Tree	1			12		Permit Number 775404	6010258.29977	2098917.51569	37.7438064148349	-122.40717721395	(37.7438064148349, -122.40717721395)	2	7	7	28859	2
74634	254115	2	27	1 Newhall St	2	Sidewalk: Property side : Yard	Tree	2		01/02/2018 12:00:00 AM	3		Permit Number 781123	6018720.08887	2097065.44422	37.739190920851	-122.377789500691	(37.739190920851, -122.377789500691)	10	3	8	58	1
95475	46434	2	6	2St. Ankeny St	2	Sidewalk: Curb side : Cutout	Tree	2	FUF	10/30/2003 12:00:00 AM	1		Permit Number 47151	6011096.25435	2089701.2859	37.7185474406786	-122.40363143174	(37.7185474406786, -122.40363143174)	10	7	8	309	28
120325	112085	2	75	99X Fremont St	2	Sidewalk: Curb side : Cutout	Tree	2		11/23/2015 12:00:00 AM			Permit Number 775592	6013631.8	2115864.7	37.7905278405438	-122.396700174955	(37.7905278405438, -122.396700174955)	12	2	9	28855	6
126777	254698	2	11	2051 03rd St	2	Sidewalk: Curb side : Cutout	Tree	2		03/20/2018 12:00:00 AM	3		Permit Number 778364	6015756.78552	2106043.12781	37.763678027819	-122.388661890454	(37.763678027819, -122.388661890454)	14	3	8	28856	29
131750	39246	2	14	3524 Jackson St	2	Sidewalk: Curb side : Cutout	Tree	2		08/22/2002 12:00:00 AM	1		Permit Number 772836	5997390.1418	2116079.35829	37.7901998932662	-122.452910535096	(37.7901998932662, -122.452910535096)	11	6	1	54	31
145856	254700	2	19	650 Illinois St	2	Sidewalk: Curb side : Cutout	Tree	2		03/20/2018 12:00:00 AM	3		Permit Number 778364	6015970.50894	2106056.61706	37.7637269088073	-122.387923622314	(37.7637269088073, -122.387923622314)	14	3	8	28856	29
158442	254367	2	13	79 Ashton Ave	2	Front Yard : Yard	Tree	2		02/06/2018 12:00:00 AM	3		Permit Number 778929	5994130.90698	2090445.22251	37.7196278254181	-122.462327167234	(37.7196278254181, -122.462327167234)	9	8	6	28861	24
160771	187941	2	75	300 Main St	2	Sidewalk: Curb side : Yard	Tree	2			3			6015065.49236	2115322.58848	37.7891190169896	-122.391701726057	(37.7891190169896, -122.391701726057)	6	2	9	28855	6
164459	116850	2	9	83 Panorama Dr	2	Front Yard : Yard	Tree	2		05/03/2016 12:00:00 AM	3			5997625.8	2100317.8	37.7469361901044	-122.450958160054	(37.7469361901044, -122.450958160054)	1	5	4	59	38
167671	256690	2	19	2825 Lake St	2	Sidewalk: Curb side : Cutout	Tree	2		11/21/2018 12:00:00 AM	3		Permit Number 772474	5986729.50015	2114421.37847	37.7850308764656	-122.489673069254	(37.7850308764656, -122.489673069254)	11	6	1	55	33
48760	255654	2	172	298X Coso Ave	2	Side Yard : Yard	Tree	2		06/27/2018 12:00:00 AM	3	10x10	Permit Number 776462	6007785	2099424	37.7450583812321	-122.415765181935	(37.7450583812321, -122.415765181935)	2	7	7	28859	2
16166	166316	2	32	2600 Harrison St	2	Sidewalk: Curb side : Cutout	Tree	2		07/29/2019 12:00:00 AM	3	10x4	Permit Number 779829	6008870.16891	2103155.64589	37.7553655917605	-122.412276546247	(37.7553655917605, -122.412276546247)	2	4	7	28859	19
37189	121502	2	75	299 Fremont St	2	Sidewalk: Property side : Cutout	Tree	2			4	10x4		6014428.99687	2115060.94265	37.7883652457059	-122.393885614549	(37.7883652457059, -122.393885614549)	6	2	9	28855	6
88090	85806	2	75	210X Shipley St	2	Sidewalk: Curb side : Cutout	Tree	2		04/05/2017 12:00:00 AM	3	2.5x6	Permit Number 778048	6011627	2111882	37.7794804977568	-122.403356401218	(37.7794804977568, -122.403356401218)	14	2	9	28856	34
190939	13063	2	177	590 Lombard St	2	Sidewalk: Curb side : Cutout	Tree	1		12/29/2017 12:00:00 AM	3	2X2	Permit Number 780933	6009554.3361	2120533.7978	37.803120257284	-122.411137959105	(37.803120257284, -122.411137959105)	3	1	10	308	23
28863	115887	2	421	134 Lunado Way	2	Sidewalk: Curb side : Cutout	Tree	2		03/01/2016 12:00:00 AM	3	2x4	Permit Number 772714	5991633.6	2092401.5	37.7248551637156	-122.471101821397	(37.7248551637156, -122.471101821397)	9	8	4	59	40
122740	115096	2	14	537 Natoma St	2	Sidewalk: Curb side : Cutout	Tree	2		01/12/2016 12:00:00 AM	2	2x4	Permit Number 769476	6010119.08101	2111896.4319	37.7794357889593	-122.408573975335	(37.7794357889593, -122.408573975335)	14	2	9	28853	34
639	261347	2	6	3300x Alemany Blvd	2	Sidewalk: Curb side : Cutout	Tree	1		01/13/2020 12:00:00 AM	3	3X3	Permit Number 780859	5994476	2087151	37.7106025369579	-122.460895688785	(37.7106025369579, -122.460895688785)	9	8	6	28861	24
61214	15236	2	11	1321 Mission St	2	Sidewalk: Curb side : Cutout	Tree	2		01/27/2015 12:00:00 AM	3	3X3	Permit Number 770747	6008261.49106	2110663.48431	37.7759461992201	-122.414912896556	(37.7759461992201, -122.414912896556)	8	2	9	28853	34
100024	258333	2	36	215X Raccoon Dr	2	Sidewalk: Property side : Yard	Tree	2		04/29/2019 12:00:00 AM	3	3X3	Permit Number 776074
158086	15247	2	11	1401X Mission St	2	Sidewalk: Curb side : Cutout	Tree	2		12/29/2016 12:00:00 AM	3	3X3	Permit Number 770901	6007902.55668	2110326.57547	37.7750009522643	-122.416130681693	(37.7750009522643, -122.416130681693)	8	2	9	28853	34
12720	115537	2	133	99X Lech Walesa St	2	Sidewalk: Curb side : Cutout	Tree	2		02/08/2016 12:00:00 AM	3	3x10	Permit Number 770842	6007116.50228	2111387.72892	37.7778703965252	-122.418925098047	(37.7778703965252, -122.418925098047)	7	9	9	28852	36
95904	256882	2	14	3075 25th Ave	2	Sidewalk: Property side : Yard	Tree	2		12/21/2018 12:00:00 AM	3	3x10	Permit Number 781920	5988824.60597	2094879.63635	37.7314966214822	-122.480993433312	(37.7314966214822, -122.480993433312)	1	8	4	64	35
186896	114793	2	17	10 Linares Ave	2	Sidewalk: Curb side : Cutout	Tree	2				3x10	Permit Number 777094	5993887.4	2102332.1	37.7522522176371	-122.464031307011	(37.7522522176371, -122.464031307011)	1	8	4	29491	40
26464	251519	2	11	173 Sanchez St	2	Sidewalk: Curb side : Cutout	Tree	2				3x15		6003549.6097	2107381.8851	37.7666698392386	-122.430978251884	(37.7666698392386, -122.430978251884)	7	9	5	28862	3
3	121463	2	3	415 Oxford St	2	Sidewalk: Curb side : Cutout	Tree	2		11/01/2020 12:00:00 AM	3	3x3	Permit Number 778984	6006773.54328	2092061.724	37.7247862819155	-122.418740608563	(37.7247862819155, -122.418740608563)	9	7	7	309	28
642	260182	2	9	66x McCoppin St	2	Sidewalk: Curb side : Cutout	Tree	2		08/13/2019 12:00:00 AM	3	3x3		6006141	2109130	37.7716162396968	-122.422139269172	(37.7716162396968, -122.422139269172)	8	2	9	28853	19
1560	258220	2	13	477 Eucalyptus Dr	2	Sidewalk: Property side : Cutout	Tree	2		07/03/2019 12:00:00 AM	3	3x3	Permit Number 774069	5989683	2094686	37.7310148065902	-122.478011682019	(37.7310148065902, -122.478011682019)	1	8	4	64	14
1675	225195	2	116	3160 21st St	2	Sidewalk: Curb side : Cutout	Tree	2			9	3x3	Permit Number 778605	6007206.11976	2103835.77909	37.7571395647689	-122.418079559351	(37.7571395647689, -122.418079559351)	2	4	7	28859	19
1751	121138	2	36	1388x Minna St	2	Sidewalk: Curb side : Cutout	Tree	2		09/08/2016 12:00:00 AM	3	3x3
6889	173762	2	1	1405 Van Dyke Ave	2	Sidewalk: Curb side : Cutout	Tree	2		01/17/2017 12:00:00 AM	3	3x3	Permit Number 773007	6015436.02818	2092717.71929	37.727071439337	-122.388840955894	(37.727071439337, -122.388840955894)	10	3	8	58	1
7182	262122	2	48	296x Day St	2	Sidewalk: Curb side : Cutout	Tree	2				3x3		6004047	2098716	37.7429035313116	-122.428640063872	(37.7429035313116, -122.428640063872)	2	7	5	63	22
8046	261018	2	22	79 Cragmont Ave	2	Sidewalk: Curb side : Cutout	Tree	2		11/15/2019 12:00:00 AM	3	3x3	Permit Number 774761	5992858	2101375	37.749564886931	-122.467521508976	(37.749564886931, -122.467521508976)	1	8	4	29491	12
8436	260432	2	17	181 Fremont St	2	Sidewalk: Curb side : Cutout	Tree	2		08/27/2019 12:00:00 AM	3	3x3		6013986	2115554	37.7896944377585	-122.395452879395	(37.7896944377585, -122.395452879395)	12	2	9	28855	6
8699	262221	2	1	240 Chattanooga St	2	Sidewalk: Curb side : Cutout	Tree	2		06/08/2020 12:00:00 AM	3	3x3	Permit Number 781435	6004728	2102256	37.7526620712812	-122.426537368454	(37.7526620712812, -122.426537368454)	2	4	5	28862	22
11471	260869	2	11	198x Eddy St	2	Sidewalk: Curb side : Cutout	Tree	2		10/16/2019 12:00:00 AM	3	3x3		6009475	2113668	37.7842640010762	-122.410927291409	(37.7842640010762, -122.410927291409)	14	10	9	28852	36
12606	261830	2	9	256 Casitas Ave	2	Sidewalk: Property side : Yard	Tree	2		03/05/2020 12:00:00 AM	3	3x3	Permit Number 781540	5994862.12068	2096567.59314	37.7364804498834	-122.460242983215	(37.7364804498834, -122.460242983215)	9	7	4	59	40
13037	152668	2	50	811 Treat Ave	2	Sidewalk: Curb side : Cutout	Tree	2		06/05/2018 12:00:00 AM	3	3x3	Permit Number 777381	6008574.99769	2103713.14234	37.7568797829862	-122.413336764205	(37.7568797829862, -122.413336764205)	2	4	7	28859	19
14010	261579	2	7	496 Urbano Dr	2	Sidewalk: Property side : Yard	Tree	2				3x3		5992575	2091875	37.7234639294961	-122.467809264789	(37.7234639294961, -122.467809264789)	9	8	4	59	40
14035	159355	2	10	417 Ellington Ave	2	Sidewalk: Curb side : Cutout	Tree	2		12/28/2016 12:00:00 AM	3	3x3	Permit Number 776198	5998509.88268	2087558.19074	37.7119518775514	-122.44698304145	(37.7119518775514, -122.44698304145)	9	7	6	28861	25
16696	195151	2	13	1912 18th St	2	Sidewalk: Curb side : Cutout	Tree	2			11	3x3		6012043	2105629	37.7623344042956	-122.401477690357	(37.7623344042956, -122.401477690357)	8	3	8	28856	29
17210	225188	2	116	580 Capp St	2	Sidewalk: Curb side : Cutout	Tree	2			10	3x3	Permit Number 778605	6007240	2103949	37.7574523501876	-122.417970414127	(37.7574523501876, -122.417970414127)	2	4	7	28859	19
18512	260829	2	60	165 Cerritos Ave	2	Sidewalk: Property side : Yard	Tree	2		10/10/2019 12:00:00 AM	3	3x3	Permit Number 781510	5991854	2092943	37.7263547341381	-122.470379348754	(37.7263547341381, -122.470379348754)	9	8	4	59	40
19183	261351	2	6	299 Sagamore St	2	Sidewalk: Curb side : Cutout	Tree	2		01/13/2020 12:00:00 AM	3	3x3	Permit Number 784323	5994169	2087374	37.7111971725927	-122.461972900974	(37.7111971725927, -122.461972900974)	9	8	6	28861	24
20111	1217	2	22	3501 Alemany Blvd	2	Sidewalk: Curb side : Cutout	Tree	2		06/17/2016 12:00:00 AM	3	3x3		5993695.72185	2087421.09824	37.7112992341463	-122.463612070865	(37.7112992341463, -122.463612070865)	9	8	4	64	24
20307	253871	2	19	1601 Larkin St	2	Sidewalk: Curb side : Cutout	Tree	2		11/27/2017 12:00:00 AM	3	3x3	Permit Number 56289	6007037	2116831	37.7928118105792	-122.419586418272	(37.7928118105792, -122.419586418272)	13	9	10	28858	32
27168	75842	2	44	42X Colin P Kelly Jr St	2	Sidewalk: Curb side : Cutout	Tree	2		12/12/2016 12:00:00 AM	3	3x3	Permit Number 779103	6015480	2112413	37.781152948088	-122.390064228941	(37.781152948088, -122.390064228941)	6	2	9	28856	6
27287	255049	2	49	925 Woolsey St	2	Sidewalk: Curb side : Cutout	Tree	2		04/10/2018 12:00:00 AM	3	3x3	Permit Number 779631	6009075.60356	2091383.60862	37.7230536656288	-122.410734764023	(37.7230536656288, -122.410734764023)	9	3	7	309	28
30240	243370	2	11	1 Hill St	2	Sidewalk: Curb side : Cutout	Tree	2		08/04/2016 12:00:00 AM	3	3x3	Permit Number 778691	6006249.22799	2103449.78821	37.7560258191488	-122.421361454386	(37.7560258191488, -122.421361454386)	2	4	5	28859	19
34077	256492	2	36	280 Diamond St	2	Sidewalk: Curb side : Cutout	Tree	2		10/17/2018 12:00:00 AM	3	3x3	Permit Number 780675	6001741.51076	2104267.16046	37.7580149486389	-122.437009129166	(37.7580149486389, -122.437009129166)	2	4	5	28862	3
36004	187698	2	9	2880 21st St	2	Sidewalk: Curb side : Cutout	Tree	2				3x3		6008980.17665	2103937.78959	37.7575193538388	-122.41195137385	(37.7575193538388, -122.41195137385)	2	4	7	28859	19
41357	255423	2	6	2398X 44th Ave	2	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3	Permit Number 780836	5982745	2098835	37.7420016902952	-122.502304062071	(37.7420016902952, -122.502304062071)	1	8	3	29491	35
46086	115494	2	72	1199X OCEAN AVE	2	Sidewalk: Curb side : Cutout	Tree	2		02/10/2016 12:00:00 AM	3	3x3	Permit Number 777362	5996259	2091739	37.7233025441304	-122.455064598389	(37.7233025441304, -122.455064598389)	9	8	4	28861	24
47024	120519	2	149	520 09th St	2	Sidewalk: Curb side : Cutout	Tree	2				3x3		6010156	2108818	37.7709851997146	-122.408229076629	(37.7709851997146, -122.408229076629)	8	2	9	28853	34
47537	18353	2	2	480 Potrero Ave	2	Sidewalk: Curb side : Cutout	Tree	2		04/02/2013 12:00:00 AM	3	3x3		6010310.70956	2106111.3358	37.7635619805233	-122.407503071611	(37.7635619805233, -122.407503071611)	8	4	8	28859	19
49019	113699	2	1	239 Minerva St	2	Sidewalk: Curb side : Cutout	Tree	2		04/15/2016 12:00:00 AM	3	3x3	Permit Number 778180	5994635.15348587	2088996.04011087	37.7156777383317	-122.460479228374	(37.7156777383317, -122.460479228374)	9	8	6	28861	24
49532	256566	2	110	2099X Steiner St	2	Sidewalk: Curb side : Cutout	Tree	2				3x3		6002352	2115365	37.7885215412843	-122.435691777518	(37.7885215412843, -122.435691777518)	13	6	1	29490	27
51709	173899	2	31	1762 12th Ave	2	Sidewalk: Property side : Cutout	Tree	2				3x3	Permit Number 779465	5992511.90241	2103608.89481	37.7556785957656	-122.468880856653	(37.7556785957656, -122.468880856653)	1	8	4	56	12
52945	117454	2	7	236 Shipley St	2	Sidewalk: Curb side : Cutout	Tree	2		06/15/2016 12:00:00 AM	3	3x3	Permit Number 776408	6011519	2111785	37.7792081256956	-122.403723194086	(37.7792081256956, -122.403723194086)	14	2	9	28856	34
55332	115079	2	218	1746 Great Hwy	2	Sidewalk: Curb side : Cutout	Tree	2				3x3		5981053.87958296	2103176.2415425	37.7538220108937	-122.508473505042	(37.7538220108937, -122.508473505042)	1	8	3	56	35
56397	251539	2	218	1746 Great Hwy	2	Sidewalk: Curb side : Cutout	Tree	2				3x3		5981086	2103156	37.753768326371	-122.508360924805	(37.753768326371, -122.508360924805)	1	8	3	56	35
57241	253248	2	72	570 Jessie St	2	Sidewalk: Curb side : Cutout	Tree	2		08/09/2017 12:00:00 AM	3	3x3	Permit Number 775513	6009730.1467	2112442.13768	37.7809123781536	-122.409958002933	(37.7809123781536, -122.409958002933)	14	2	9	28853	34
57409	256506	2	346	978 Guerrero St	2	Sidewalk: Curb side : Cutout	Tree	1		10/15/2018 12:00:00 AM	3	3x3		6005672.85931	2103292.97405	37.7555627312558	-122.423343584439	(37.7555627312558, -122.423343584439)	2	4	5	28859	19
60760	122593	2	44	72 Townsend St	2	Sidewalk: Curb side : Cutout	Tree	2		12/12/2016 12:00:00 AM	3	3x3	Permit Number 779103	6015480	2112413	37.781152948088	-122.390064228941	(37.781152948088, -122.390064228941)	6	2	9	28856	6
64240	112973	2	14	4099x ULLOA ST	2	Sidewalk: Property side : Cutout	Tree	2		10/20/2015 12:00:00 AM		3x3	Permit Number 773327	5983385	2098079	37.7399635032694	-122.500035309652	(37.7399635032694, -122.500035309652)	1	8	3	29491	35
64492	117113	2	1	1650 Broadway	2	Sidewalk: Curb side : Cutout	Tree	2		06/07/2016 12:00:00 AM	3	3x3	Permit Number 773961	6005663.57094	2117913.49378	37.7957066076266	-122.424415580821	(37.7957066076266, -122.424415580821)	13	9	1	28858	27
70032	253393	2	31	115 Steuart St	2	Sidewalk: Curb side : Cutout	Tree	2		08/30/2017 12:00:00 AM	3	3x3	Permit Number 771767	6014754.16338	2116767.09226	37.7930680031541	-122.392879995147	(37.7930680031541, -122.392879995147)	12	2	9	28855	6
70866	224462	2	18	2810 26th St	2	Sidewalk: Curb side : Cutout	Tree	2		08/15/2017 12:00:00 AM	3	3x3	Permit Number 775960	6010311.37562	2101086.64633	37.7497653433983	-122.407146558773	(37.7497653433983, -122.407146558773)	2	4	7	28859	19
72671	255301	2	1	1238 Sutter St	2	Sidewalk: Curb side : Cutout	Tree	2		05/07/2018 12:00:00 AM	3	3x3	Permit Number 777218	6006649	2115006	37.7877789501949	-122.420799295532	(37.7877789501949, -122.420799295532)	13	9	10	28858	21
81974	256777	2	9	2828 Webster St	2	Sidewalk: Curb side : Cutout	Tree	2		12/13/2018 12:00:00 AM	3	3x3	Permit Number 777329	6003004.23187	2118313.15271	37.7966534371422	-122.433645942426	(37.7966534371422, -122.433645942426)	13	9	1	57	17
82212	156914	2	17	2995 Harrison St	2	Sidewalk: Curb side : Cutout	Tree	2		12/21/2018 12:00:00 AM	3	3x3	Permit Number 782654	6009047.12311	2101072.92433	37.7496568330138	-122.411517443787	(37.7496568330138, -122.411517443787)	2	4	7	28859	19
87472	255403	2	75	150 Van Ness Ave	2	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
93272	256871	2	19	1025 Powhattan Ave	2	Sidewalk: Curb side : Cutout	Tree	2		12/20/2018 12:00:00 AM	3	3x3	Permit Number 776275	6009358.6182	2098062.94866	37.7414095695618	-122.410227790564	(37.7414095695618, -122.410227790564)	10	7	7	28859	2
96128	73589	2	230	468 Clementina St	2	Sidewalk: Curb side : Cutout	Tree	2		09/09/1995 12:00:00 AM	12	3x3	Permit Number 770905	6010928.13640467	2111848.51157587	37.7793494887795	-122.405771720076	(37.7793494887795, -122.405771720076)	14	2	9	28853	34
97662	117018	2	16	168 Hyde St	2	Sidewalk: Curb side : Cutout	Tree	2		05/17/2016 12:00:00 AM	3	3x3	Permit Number 777550	6008125.66458	2112987.05621	37.7823185388132	-122.415547303188	(37.7823185388132, -122.415547303188)	7	10	9	28852	36
100425	243144	2	14	98x Eugenia Ave	2	Sidewalk: Curb side : Cutout	Tree	2		06/16/2017 12:00:00 AM	3	3x3		6006195	2098242	37.7417233638646	-122.421179213365	(37.7417233638646, -122.421179213365)	2	7	7	28859	2
102847	256610	2	14	80 Terra Vista Ave	2	Sidewalk: Curb side : Cutout	Tree	2		11/07/2018 12:00:00 AM	3	3x3	Permit Number 780481	6000092	2112863	37.7815230689536	-122.443331223004	(37.7815230689536, -122.443331223004)	15	5	1	29490	16
109022	255406	2	75	199x Hayes St	2	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
113669	159358	2	51	49 Naglee Ave	2	Sidewalk: Curb side : Cutout	Tree	2		12/28/2016 12:00:00 AM	3	3x3	Permit Number 776198	5998584.62871	2087583.88571	37.712026700246	-122.446726546692	(37.712026700246, -122.446726546692)	9	7	6	28861	25
117515	119808	2	127	1634 Pine St	2	Sidewalk: Curb side : Cutout	Tree	2		08/01/2016 12:00:00 AM	3	3x3	Permit Number 773331	6006048	2115627	37.7894501691998	-122.422922798032	(37.7894501691998, -122.422922798032)	13	9	1	28858	41
121157	257909	2	17	199x Townsend St	2	Sidewalk: Curb side : Cutout	Tree	2		01/18/2019 12:00:00 AM	3	3x3		6014800	2111540	37.778718149686	-122.392355631341	(37.778718149686, -122.392355631341)	6	2	9	28856	20
123272	256677	2	26	330 Twin Peaks Blvd	2	Sidewalk: Curb side : Cutout	Tree	2		03/27/2019 12:00:00 AM	3	3x3		5998688	2103995	37.7570936308358	-122.447549834506	(37.7570936308358, -122.447549834506)	15	5	4	63	38
126056	255417	2	75	99x Polk St	2	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6007395	2111066	37.7770026839515	-122.417938862064	(37.7770026839515, -122.417938862064)	7	9	9	28852	36
126119	85804	2	159	923 Folsom St	2	Sidewalk: Curb side : Cutout	Tree	2		04/05/2017 12:00:00 AM	3	3x3	Permit Number 778048	6011441.4589	2111949.4191	37.7796552503769	-122.404003016031	(37.7796552503769, -122.404003016031)	14	2	9	28856	34
127597	103379	2	31	2712 Broadway	2	Sidewalk: Curb side : Cutout	Tree	2		05/21/2013 12:00:00 AM	4	3x3	Permit Number 770136	6000520	2117210	37.7934832007909	-122.44216269001	(37.7934832007909, -122.44216269001)	13	9	1	57	27
129348	251179	2	51	1043 Minna St	2	Sidewalk: Property side : Cutout	Tree	2				3x3		6007668	2109797	37.7735336727503	-122.41690453761	(37.7735336727503, -122.41690453761)	8	2	9	28853	19
130529	256674	2	385	330 Twin Peaks Blvd	2	Side Yard : Cutout	Tree	2		03/27/2019 12:00:00 AM	3	3x3		5998688	2103995	37.7570936308358	-122.447549834506	(37.7570936308358, -122.447549834506)	15	5	4	63	38
130781	255652	2	11	949 Fell St	2	Sidewalk: Curb side : Cutout	Tree	2				3x3		6002910	2110236	37.7744702748436	-122.433394524315	(37.7744702748436, -122.433394524315)	15	5	11	29492	10
135960	103695	2	11	1X Hill St	2	Sidewalk: Curb side : Cutout	Tree	2		08/04/2016 12:00:00 AM	3	3x3	Permit Number 778691	6006027.79546	2103458.18152	37.7560363783091	-122.422127839194	(37.7560363783091, -122.422127839194)	2	4	5	28859	19
135962	187674	2	9	2690 Harrison St	2	Sidewalk: Curb side : Cutout	Tree	2				3x3		6008898.65774693	2102801.94608421	37.7543960104367	-122.41215302657	(37.7543960104367, -122.41215302657)	2	4	7	28859	19
148641	253378	2	45	2 Alpine Ter	2	Sidewalk: Curb side : Cutout	Tree	2				3x3		6001556	2108661	37.7700688079313	-122.43796542225	(37.7700688079313, -122.43796542225)	15	5	5	29492	9
152864	124718	2	1	610 Cortland Ave	2	Sidewalk: Curb side : Cutout	Tree	2		10/22/2018 12:00:00 AM	3	3x3	Permit Number 775784	6007724.21349	2097196.46477	37.7389386461297	-122.415817669649	(37.7389386461297, -122.415817669649)	2	7	7	28859	2
155799	256869	2	19	985 Powhattan Ave	2	Sidewalk: Curb side : Cutout	Tree	2		12/20/2018 12:00:00 AM	3	3x3	Permit Number 776274	6009287.99434	2098069.06568	37.7414224065761	-122.410472416169	(37.7414224065761, -122.410472416169)	10	7	7	28859	2
161200	257940	2	17	65 Buena Vista Ave East	2	Sidewalk: Curb side : Cutout	Tree	2		02/01/2019 12:00:00 AM	3	3x3	Permit Number 779175	6001128.17111	2108817.40029	37.7704739053605	-122.439456486198	(37.7704739053605, -122.439456486198)	15	5	11	29492	9
161626	255692	2	11	510 Townsend St	2	Sidewalk: Curb side : Cutout	Tree	2		06/27/2018 12:00:00 AM	3	3x3		6012573	2109637	37.773369031352	-122.399926071367	(37.773369031352, -122.399926071367)	14	2	9	28853	34

trees

Custom SQL query returning 101 rows (hide)

Query parameters