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
1492	20444	1	16	495X Sunset Blvd	9	Sidewalk: Curb side : Cutout	Tree	1			12	15
1498	44556	7	17		19	Sidewalk: Curb side : Cutout	Tree	2		04/29/2001 12:00:00 AM			Permit Number 43835
1504	19794	1	160	100 STAIRWAY19	16	Sidewalk: Curb side : Cutout	Tree	1			18	50ST
1508	48345	7	17		162	Sidewalk: Curb side : Cutout	Tree	2		07/17/2002 12:00:00 AM			Permit Number 45761
1511	260421	1	8	200x Bacon St	5	Sidewalk: Curb side : Cutout	Tree	1	FUF	08/17/2019 12:00:00 AM	3
1515	31846	7	7		1	Sidewalk: Curb side : Cutout	Tree	2		06/19/1995 12:00:00 AM			Permit Number 35298
1517	19783	1	167	100 STAIRWAY19	5	Sidewalk: Curb side : Cutout	Tree	1			6	50ST
1531	20287	1	15	20X Sunset Blvd	8	Sidewalk: Curb side : Cutout	Tree	1			12	60
1552	63329	7	17	225 Bessie St	1	Sidewalk: Curb side : Cutout	Tree	2		02/02/1987 12:00:00 AM			Permit Number 23902
1555	61775	7	17	157 Lacrosse Ave	1	Sidewalk: Curb side : Cutout	Tree	2		01/03/1984 12:00:00 AM			Permit Number 21796
1577	19793	1	122	100 STAIRWAY19	15	Sidewalk: Curb side : Cutout	Tree	1			6	20ST
1579	45978	7	17		129	Sidewalk: Curb side : Cutout	Tree	2		12/06/2001 12:00:00 AM			Permit Number 44451
1581	19590	1	37	100 STAIRWAY4	13	Sidewalk: Curb side : Cutout	Tree	1			3	60
1595	19920	1	150	100 STAIRWAY36	-2	Sidewalk: Curb side : Cutout	Tree	1			6	3X3
1600	46288	7	196		15	Sidewalk: Curb side : Cutout	Tree	2		01/31/2002 12:00:00 AM			Permit Number 44564
1605	35819	7	27	980 Houston St	4	Sidewalk: Curb side : Cutout	Tree	2		04/22/1998 12:00:00 AM			Permit Number 39055
1615	44603	7	17		121	Sidewalk: Curb side : Cutout	Tree	2		04/29/2001 12:00:00 AM			Permit Number 43835
1619	95785	7	37	347 21st St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	08/19/2011 12:00:00 AM		3x3	Permit Number 767529
1623	20078	1	198	100 STAIRWAY56	1	Sidewalk: Curb side : Cutout	Tree	1			24	5X5
1631	30310	7	70	228 Jordan Ave	2	Sidewalk: Curb side : Cutout	Tree	2					Permit Number 8
1637	35981	7	135	83 Prospect Stairs Street	2	Sidewalk: Curb side : Cutout	Tree	2		04/27/1998 12:00:00 AM			Permit Number 39135
1643	44855	7	17		17	Sidewalk: Curb side : Cutout	Tree	2		04/25/2001 12:00:00 AM			Permit Number 43922
1646	19899	1	64	100 STAIRWAY33	31	Sidewalk: Curb side : Cutout	Tree	1			12	25ST
1648	35048	7	37	700 Peninsula Ave	1	Sidewalk: Curb side : Cutout	Tree	2		01/22/1998 12:00:00 AM			Permit Number 38613
1654	19584	1	109	100 STAIRWAY4	7	Sidewalk: Curb side : Cutout	Tree	1			3	60
1665	47611	7	11	1201 Houston St	3	Sidewalk: Curb side : Cutout	Tree	2		05/01/1994 12:00:00 AM			Permit Number 45444
1674	48081	7	17		245	Sidewalk: Curb side : Cutout	Tree	2		07/17/2002 12:00:00 AM			Permit Number 45761
1694	100166	8	203	2340 Twin Peaks Blvd		Front Yard : Yard	Tree	2					Permit Number 769026
1695	19761	1	105	100 STAIRWAY15	19	Sidewalk: Curb side : Cutout	Tree	1			3	20ST
1700	64639	7	17	465 Convention Way	1	Sidewalk: Curb side : Cutout	Tree	2		08/19/1988 12:00:00 AM			Permit Number 25552
1703	48311	7	17		177	Sidewalk: Curb side : Cutout	Tree	2		07/17/2002 12:00:00 AM			Permit Number 45761
1723	19755	1	28	100 STAIRWAY15	13	Sidewalk: Curb side : Cutout	Tree	1			6	3X3
1736	255231	1	11	300X Goettingen St	6	Sidewalk: Curb side : Cutout	Tree	1	FUF
1743	55199	7	17	28 Dalmar St	1	Sidewalk: Curb side : Cutout	Tree	2		09/12/1972 12:00:00 AM			Permit Number 11112
1747	44960	7	17		61	Sidewalk: Curb side : Cutout	Tree	2		04/25/2001 12:00:00 AM			Permit Number 43922
1751	121138	2	36	1388x Minna St	2	Sidewalk: Curb side : Cutout	Tree	2		09/08/2016 12:00:00 AM	3	3x3
1759	35455	7	37	790 Peninsula Ave	12	Sidewalk: Curb side : Cutout	Tree	2		03/16/1998 12:00:00 AM			Permit Number 38883
1760	44538	7	17		31	Sidewalk: Curb side : Cutout	Tree	2		04/29/2001 12:00:00 AM			Permit Number 43835
1762	30595	7	122	265 Walter St	2	Sidewalk: Curb side : Cutout	Tree	2		01/26/1995 12:00:00 AM			Permit Number 34562
1770	122656	1	75	300x Hickory St	12	Sidewalk: Curb side : Cutout	Tree	2		11/10/2016 12:00:00 AM	3	3x3
1774	19805	1	105	100 STAIRWAY22	4	Sidewalk: Curb side : Cutout	Tree	1			6	20
1784	44653	7	17		73	Sidewalk: Curb side : Cutout	Tree	2		04/29/2001 12:00:00 AM			Permit Number 43835
1785	19984	1	100	100 STAIRWAY46	4	Sidewalk: Curb side : Cutout	Tree	1			18	40
1786	19661	1	127	100 STAIRWAY5	60	Sidewalk: Curb side : Cutout	Tree	1			12	60ST
1794	42923	7	33		1	Sidewalk: Curb side : Cutout	Tree	2		07/05/2000 12:00:00 AM			Permit Number 42829
1795	44610	7	17		174	Sidewalk: Curb side : Cutout	Tree	2		04/29/2001 12:00:00 AM			Permit Number 43835
1802	68847	7	17	2118 Flood Ave	1	Sidewalk: Curb side : Cutout	Tree	2		12/28/1993 12:00:00 AM			Permit Number 32810
1815	44628	7	17		156	Sidewalk: Curb side : Cutout	Tree	2		04/29/2001 12:00:00 AM			Permit Number 43835
1821	48173	7	17		66	Sidewalk: Curb side : Cutout	Tree	2		07/17/2002 12:00:00 AM			Permit Number 45761
1829	55200	7	17	32 Dalmar St	1	Sidewalk: Curb side : Cutout	Tree	2		09/29/1972 12:00:00 AM			Permit Number 11113
1831	48269	7	17		120	Sidewalk: Curb side : Cutout	Tree	2		07/17/2002 12:00:00 AM			Permit Number 45761
1837	19878	1	150	100 STAIRWAY33	10	Sidewalk: Curb side : Cutout	Tree	1			12	25ST
1840	35278	7	17		5	Sidewalk: Curb side : Cutout	Tree	2		02/17/1998 12:00:00 AM			Permit Number 38758
1845	20002	1	28	100 STAIRWAY46	22	Sidewalk: Curb side : Cutout	Tree	1			6	2
1847	57850	7	17	1700 S. Amaylett Blvd	1	Sidewalk: Curb side : Cutout	Tree	2		04/14/1977 12:00:00 AM			Permit Number 16791
1886	20313	1	15	101X Sunset Blvd	2	Sidewalk: Curb side : Cutout	Tree	1			12	60
1904	48103	7	17		212	Sidewalk: Curb side : Cutout	Tree	2		07/17/2002 12:00:00 AM			Permit Number 45761
1908	119794	1	31	201x Octavia St	2	Median : Cutout	Tree	1						2110122	6005581	47.2699969117914	-138.280716869623	(47.2699969117914, -138.280716869623)
1917	46148	7	17		2	Sidewalk: Curb side : Cutout	Tree	2		12/27/2001 12:00:00 AM			Permit Number 44491
1923	20027	1	70	100 STAIRWAY48	11	Sidewalk: Curb side : Cutout	Tree	1			6	10ST
1928	43486	7	103		1	Sidewalk: Curb side : Cutout	Tree	2		07/19/2000 12:00:00 AM			Permit Number 43169
1929	19668	1	208	100 STAIRWAY5	67	Sidewalk: Curb side : Cutout	Tree	1			12	60ST
1934	44589	7	17		117	Sidewalk: Curb side : Cutout	Tree	2		04/29/2001 12:00:00 AM			Permit Number 43835
1935	19720	1	109	100 STAIRWAY13	18	Sidewalk: Curb side : Cutout	Tree	1			3	40ST
1940	43017	7	25		2	Sidewalk: Curb side : Cutout	Tree	2		07/05/2000 12:00:00 AM			Permit Number 42880
1944	260235	1	10	2201x 22nd Ave	31	Sidewalk: Curb side : Cutout	Tree	1	FUF	10/20/2018 12:00:00 AM	3
1956	44540	7	17		29	Sidewalk: Curb side : Cutout	Tree	2		04/29/2001 12:00:00 AM			Permit Number 43835
1959	19904	1	59	100 STAIRWAY34	2	Sidewalk: Curb side : Cutout	Tree	1			12	6X6
1964	48189	7	17		43	Sidewalk: Curb side : Cutout	Tree	2		07/17/2002 12:00:00 AM			Permit Number 45761
1967	259348	1	6	450x Burrows St	2	Sidewalk: Curb side : Cutout	Tree	1	FUF	04/27/2019 12:00:00 AM	3
1968	44918	7	17		183	Sidewalk: Curb side : Cutout	Tree	2		04/25/2001 12:00:00 AM			Permit Number 43922
1975	48204	7	17		47	Sidewalk: Curb side : Cutout	Tree	2		07/17/2002 12:00:00 AM			Permit Number 45761
1978	87100	7	15	700 Connecticut St	1	Front Yard : Yard	Tree	5				3x3	Permit Number 50056
1982	20405	1	15	262X Sunset Blvd	50	Sidewalk: Curb side : Cutout	Tree	1			6	60
1984	48220	7	17		2	Sidewalk: Curb side : Cutout	Tree	2		07/17/2002 12:00:00 AM			Permit Number 45761
1986	45957	7	17		166	Sidewalk: Curb side : Cutout	Tree	2		12/06/2001 12:00:00 AM			Permit Number 44451
1987	44951	7	17		64	Sidewalk: Curb side : Cutout	Tree	2		04/25/2001 12:00:00 AM			Permit Number 43922
2001	35044	7	17	700 Peninsula Ave	5	Sidewalk: Curb side : Cutout	Tree	2		01/22/1998 12:00:00 AM			Permit Number 38613
2026	19643	1	52	100 STAIRWAY5	42	Sidewalk: Curb side : Cutout	Tree	1			12	30
2031	48316	7	17		182	Sidewalk: Curb side : Cutout	Tree	2		07/17/2002 12:00:00 AM			Permit Number 45761
2033	35052	7	17	700 Peninsula Ave	12	Sidewalk: Curb side : Cutout	Tree	2		01/22/1998 12:00:00 AM			Permit Number 38613
2034	260230	1	10	2201x 22nd Ave	26	Sidewalk: Curb side : Cutout	Tree	1	FUF	10/20/2018 12:00:00 AM	3
2043	66343	7	17		1	Sidewalk: Curb side : Cutout	Tree	2		12/10/1990 12:00:00 AM			Permit Number 29464
2047	20346	1	63	101X Sunset Blvd	32	Sidewalk: Curb side : Cutout	Tree	1			18	40
2066	55924	7	17	524 Morgan Aly	1	Sidewalk: Curb side : Cutout	Tree	2		05/17/1973 12:00:00 AM			Permit Number 11988
2076	44958	7	17		82	Sidewalk: Curb side : Cutout	Tree	2		04/25/2001 12:00:00 AM			Permit Number 43922
2083	46724	7	33		5	Sidewalk: Curb side : Cutout	Tree	2		04/24/2002 12:00:00 AM			Permit Number 44843
2087	261314	7	45	2601 Divisadero St	1	Sidewalk: Property side : Cutout	Landscaping	2		12/31/2019 12:00:00 AM	3	6x106
2100	253677	6	35	199X Kissling St	1	Side Yard : Cutout	Tree	2				5x10
2102	48160	7	17		270	Sidewalk: Curb side : Cutout	Tree	2		07/17/2002 12:00:00 AM			Permit Number 45761
2108	35196	7	14		5	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
2113	44856	7	17		33	Sidewalk: Curb side : Cutout	Tree	2		04/25/2001 12:00:00 AM			Permit Number 43922
2140	46192	7	19		6	Sidewalk: Curb side : Cutout	Tree	2		12/31/2001 12:00:00 AM			Permit Number 44518
2146	45914	7	17		33	Sidewalk: Curb side : Cutout	Tree	2		12/06/2001 12:00:00 AM			Permit Number 44451
2163	48471	7	17		15	Sidewalk: Curb side : Cutout	Tree	2					Permit Number 45832
2169	19944	1	150	100 STAIRWAY39	1	Sidewalk: Curb side : Cutout	Tree	1			6	25ST
2170	44902	7	17		136	Sidewalk: Curb side : Cutout	Tree	2		04/25/2001 12:00:00 AM			Permit Number 43922
2177	44598	7	17		126	Sidewalk: Curb side : Cutout	Tree	2		04/29/2001 12:00:00 AM			Permit Number 43835
2187	46061	7	17		103	Sidewalk: Curb side : Cutout	Tree	2		12/06/2001 12:00:00 AM			Permit Number 44451
2189	48278	7	17		88	Sidewalk: Curb side : Cutout	Tree	2		07/17/2002 12:00:00 AM			Permit Number 45761
2196	48265	7	17		129	Sidewalk: Curb side : Cutout	Tree	2		07/17/2002 12:00:00 AM			Permit Number 45761

trees

Custom SQL query returning 101 rows (hide)

Query parameters