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)
7100	228281	5	22	2036X 15th St	4	Sidewalk: Curb side : Yard	Tree	2			3	Width 3ft		6003817	2107261	37.7663530653237	-122.430044770651	(37.7663530653237, -122.430044770651)	8	4	5	28862	3
10248	108452	5	140	696 Pennsylvania Ave	4	Sidewalk: Curb side : Cutout	Tree	2			8	3x3		6014381.40925	2103952.18314	37.757860427147	-122.393272599772	(37.757860427147, -122.393272599772)	10	3	8	28856	29
11965	221066	5	14	2 Page St	4	Sidewalk: Curb side : Cutout	Tree	2			2	Width 4ft		6006423.38991	2110105.498	37.7743106470621	-122.421231746062	(37.7743106470621, -122.421231746062)	7	9	11	28852	10
12645	264862	5	186	10X Selma Way	4	Unaccepted Street : Yard	Tree	2				10x100		5992494	2103402	37.7551094821546	-122.468927712716	(37.7551094821546, -122.468927712716)	1	8	4	56	12
194338	265025	5	11	99 Harlan Pl	4	Sidewalk: Curb side : Cutout	Tree	2				6x6		6011098	2115736	37.7900331129851	-122.405457946913	(37.7900331129851, -122.405457946913)	5	1	10	28857	6
2679	261736	5	14	540 De Haro St	4	Sidewalk: Property side : Yard	Tree	2		02/25/2020 12:00:00 AM	3		Permit Number 774839	6012051.5879	2105883.7172	37.7630342801454	-122.401465890035	(37.7630342801454, -122.401465890035)	8	3	8	28856	29
18706	103094	5	272	1540 Jones St	4	Sidewalk: Curb side : Cutout	Tree	2		03/20/2013 12:00:00 AM	3	3x3	Permit Number 768649	6008418.50881	2117836.67229	37.7956508595435	-122.414877528601	(37.7956508595435, -122.414877528601)	5	1	10	308	21
7398	13267	5	11	2460 Lombard St	4	Sidewalk: Curb side : Cutout	Tree	1		04/20/2020 12:00:00 AM	3	3X3	Permit Number 781193	6000572.6787	2119285.0637	37.7991837803388	-122.442129440006	(37.7991837803388, -122.442129440006)	13	9	1	57	17
14075	110744	5	215	2300x Mariposa St	4	Sidewalk: Curb side : Cutout	Tree	2		05/05/2015 12:00:00 AM	3	3x3		6010545.16814	2106015.79361	37.7633127639997	-122.406685416098	(37.7633127639997, -122.406685416098)	8	4	8	28859	19
9406	111316	5	17	3400x Wawona St	4	Sidewalk: Property side : Cutout	Tree	2		06/02/2015 12:00:00 AM	3	3x3		5982298.43845	2096733.62139	37.7362056333855	-122.503692516423	(37.7362056333855, -122.503692516423)	1	8	3	29491	35
10736	262270	5	1	10X Restani Stwy	4	Unaccepted Street : Yard	Tree	2		06/19/2020 12:00:00 AM	3	3x3	Permit Number 782248	5999595	2089918	37.7184933152793	-122.443401977243	(37.7184933152793, -122.443401977243)	9	7	6	28861	25
8512	117149	5	8	928 Toland St	4	Sidewalk: Curb side : Cutout	Tree	2		07/13/2016 12:00:00 AM	3	3x3	Permit Number 774325	6011929.15518	2097982.19203	37.7413315821976	-122.401334038935	(37.7413315821976, -122.401334038935)	10	3	8	58	1
4810	262420	5	19	101 Brighton Ave	4	Sidewalk: Curb side : Cutout	Tree	2		07/27/2020 12:00:00 AM	3	3x3	Permit Number 784737	5996197.23422	2090625.75995	37.7202423066045	-122.455197699909	(37.7202423066045, -122.455197699909)	9	8	6	28861	24
5386	262533	5	11	2401 17th Ave	4	Sidewalk: Curb side : Cutout	Tree	2		08/12/2020 12:00:00 AM	3	3x3	Permit Number 773215	5991046.77559	2098937.57906	37.7427676232348	-122.473606942703	(37.7427676232348, -122.473606942703)	1	8	4	29491	40
18330	97157	5	91	1079 Le Conte Ave	4	Sidewalk: Curb side : Cutout	Tree	2		08/25/2011 12:00:00 AM	2		Permit Number 768080	6012734.70575	2089832.2191	37.7189983454895	-122.397977119771	(37.7189983454895, -122.397977119771)	10	3	8	58	1
4868	256192	5	177	3600 Buchanan St	4	Sidewalk: Curb side : Cutout	Tree	2		09/21/2018 12:00:00 AM	3
18862	256188	5	177	1598 Bay St	4	Sidewalk: Curb side : Cutout	Tree	2		09/21/2018 12:00:00 AM	3			6003155.82812	2120664.19895	37.8031173987704	-122.433289466249	(37.8031173987704, -122.433289466249)	13	9	1	57	17
14057	107967	5	27	2405x Scott St	4	Sidewalk: Curb side : Cutout	Tree	2		11/10/2014 12:00:00 AM	3	3x3	Permit Number 770079	6001240.68928	2116684.58018	37.7920815807513	-122.439631370586	(37.7920815807513, -122.439631370586)	13	6	1	29490	27
194351	265046	5	13	1250 Eucalyptus Dr	4	Sidewalk: Property side : Yard	Tree	2		12/17/2020 12:00:00 AM	3	5x10	Permit Number 781946	5987698.06233	2094734.87015	37.7310335805158	-122.484877445397	(37.7310335805158, -122.484877445397)	1	8	4	64	35