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
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
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
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
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
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
14653	19921	3	40	100 STAIRWAY37	1	1	1	2			12	3X3
15445	19918	3	40	100 STAIRWAY35	14	1	1	2			6	120ST
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
16486	19701	3	40	100 STAIRWAY12	1	1	1	2			12	60
16953	19917	3	40	100 STAIRWAY35	13	1	1	2			6	120ST
161444	176333	3	40	12x Canyon Dr	12	11	1	2			12	Width 0ft		6002752.1139	2086168.71447	37.708378134509296	-122.43222153339899	(37.7083781345093, -122.432221533399)
76630	54757	1	40	330 Lathrop Ave	1	1	1	1		08/08/1972 12:00:00 AM	14		Permit Number 10606	6012426.81669	2086731.5712700002	37.7104674323033	-122.39882388720801	(37.7104674323033, -122.398823887208)
156289	54758	1	40	324 Lathrop Ave	1	1	1	1		08/08/1972 12:00:00 AM	8		Permit Number 10607	6012398.45595	2086740.4083099999	37.710490116783	-122.39892252845699	(37.710490116783, -122.398922528457)
106367	1854	3	40	2500 Bay Shore Blvd	1	11	1	2			12	6		6010837.5147418	2086759.4488696998	37.7104552954566	-122.404318844881	(37.7104552954566, -122.404318844881)
138313	1855	3	40	2500 Bay Shore Blvd	2	11	1	2			3	6		6010837.5147418	2086759.4488696998	37.7104552954566	-122.404318844881	(37.7104552954566, -122.404318844881)
101382	108685	3	40	301X CHESTER AVE	1	5	1	2			18			5991720.0	2087146.0	37.7104298409998	-122.47042057923099	(37.7104298409998, -122.470420579231)
88629	117549	3	40	24X KEMPTON AVE	3	17	1	2				30x30		5992274.0	2087683.0	37.7119363308651	-122.46854490041599	(37.7119363308651, -122.468544900416)
112585	117548	3	40	24X KEMPTON AVE	2	17	1	2				30x30		5992274.0	2087683.0	37.7119363308651	-122.46854490041599	(37.7119363308651, -122.468544900416)
121639	117546	3	40	24X KEMPTON AVE	1	17	1	2				30x30		5992274.0	2087683.0	37.7119363308651	-122.46854490041599	(37.7119363308651, -122.468544900416)
126638	117550	3	40	24X KEMPTON AVE	4	17	1	2				30x30		5992274.0	2087683.0	37.7119363308651	-122.46854490041599	(37.7119363308651, -122.468544900416)
146070	121081	3	40	24X KEMPTON AVE	5	17	1	2				30x30		5992274.0	2087683.0	37.7119363308651	-122.46854490041599	(37.7119363308651, -122.468544900416)
95293	104649	2	40	200 Wheeler Ave	1	2	1	1						6012242.2	2087732.7	37.7132060446128	-122.399532207425	(37.7132060446128, -122.399532207425)
93072	65615	1	40	907 Madrid St	1	1	1	1	1	02/07/1990 12:00:00 AM			Permit Number 28522	6001416.70920324	2088928.18069936	37.71587921156971	-122.43703426598101	(37.7158792115697, -122.437034265981)
114250	65614	1	40	901 Madrid St	1	1	1	1	1	02/07/1990 12:00:00 AM		3x3	Permit Number 28521	6001429.80797007	2088950.28994853	37.715940663173704	-122.43699057256201	(37.7159406631737, -122.436990572562)
106325	69542	1	40	775 Edinburg St	1	1	1	1	1	01/28/1998 12:00:00 AM	8		Permit Number 38643	6001970.16460074	2089302.5400568	37.71693856245	-122.43514802944901	(37.71693856245, -122.435148029449)
37917	199398	2	40	1027 Jamestown Ave	1	2	1	1			5			6013845.577380001	2089711.9694400001	37.718729970701396	-122.394128826289	(37.7187299707014, -122.394128826289)
185034	176332	3	40	700x Mansell St	40	11	1	2			10	Width 0ft		6009122.37089	2089940.9339	37.7190950046208	-122.410471276831	(37.7190950046208, -122.410471276831)
166853	176331	3	40	700x Mansell St	36	11	1	2			27	Width 0ft		6009160.31915	2089943.1989099998	37.7191033512163	-122.410340263619	(37.7191033512163, -122.410340263619)
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)
158228	176328	3	40	700x Mansell St	32	11	1	2			11	Width 0ft		6009200.77281	2089956.05158	37.7191409096134	-122.41020133724899	(37.7191409096134, -122.410201337249)
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)
156596	176329	3	40	700x Mansell St	33	11	1	2			11	Width 0ft		6009197.90265	2089964.9760099999	37.719165253359	-122.41021188808399	(37.719165253359, -122.410211888084)
130335	176324	3	40	700x Mansell St	24	11	1	2			43	Width 0ft		6009336.81226	2089985.3560799998	37.719228998190204	-122.409733166348	(37.7192289981902, -122.409733166348)
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)
62801	176326	3	40	700x Mansell St	26	11	1	2			11	Width 0ft		6009300.414580001	2090007.1642099998	37.719286839006706	-122.40986051846701	(37.7192868390067, -122.409860518467)
75997	176325	3	40	700x Mansell St	25	11	1	2			7	Width 0ft		6009306.38792	2090008.2878700001	37.7192902591068	-122.40983995006701	(37.7192902591068, -122.409839950067)
72173	176321	3	40	700x Mansell St	10	11	1	2			20	Width 0ft		6009491.13352	2090035.22052	37.7193745624679	-122.409203250746	(37.7193745624679, -122.409203250746)
66989	176322	3	40	700x Mansell St	11	11	1	2			11	Width 0ft		6009482.932019999	2090051.6391099999	37.7194191850237	-122.40923275838699	(37.7194191850237, -122.409232758387)
178932	176320	3	40	700x Mansell St	5	11	1	2			15	Width 0ft		6009693.65645	2090109.67926	37.7195903547889	-122.408508450717	(37.7195903547889, -122.408508450717)
177490	176319	3	40	700x Mansell St	2	11	1	2			18	Width 0ft		6009753.29629	2090123.38013	37.7196313144016	-122.40830326229602	(37.7196313144016, -122.408303262296)
64735	176318	3	40	600x Mansell St	6	11	1	2			24	Width 0ft		6009900.75619	2090162.07565	37.71974582058	-122.40779627129	(37.71974582058, -122.40779627129)
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)
73620	176316	3	40	600x Mansell St	4	11	1	2			20	Width 0ft		6009975.17316	2090196.6271099998	37.7198448575227	-122.40754147176001	(37.7198448575227, -122.40754147176)
174476	176315	3	40	600x Mansell St	2	11	1	2			36	Width 0ft		6010056.94301	2090202.23729	37.7198648386596	-122.40725921596399	(37.7198648386596, -122.407259215964)
152213	176314	3	40	500x Mansell St	19	11	1	2			35	Width 0ft		6010185.666130001	2090251.18564	37.720006444117296	-122.406817710885	(37.7200064441173, -122.406817710885)
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)
152100	176311	3	40	500x Mansell St	16	11	1	2			15	Width 0ft		6010356.570719999	2090296.4274	37.7201402299675	-122.40623013522499	(37.7201402299675, -122.406230135225)
64522	176312	3	40	500x Mansell St	15	11	1	2			13	Width 0ft		6010340.9019	2090322.69069	37.720211467072296	-122.406286146812	(37.7202114670723, -122.406286146812)
153553	176310	3	40	500x Mansell St	8	11	1	2			29	Width 0ft		6010469.51848	2090335.25755	37.720253166839704	-122.40584244467199	(37.7202531668397, -122.405842444672)
108971	115772	1	40	1204 Egbert Ave	3	1	1	1		02/24/2016 12:00:00 AM	3		Permit Number 775363	6015358.9	2090410.1	37.7207308974409	-122.38894654781099	(37.7207308974409, -122.388946547811)
62350	176309	3	40	300x Mansell St	21	11	1	2			24	Width 0ft		6010760.4946	2090426.07331	37.720518796898	-122.404843021812	(37.720518796898, -122.404843021812)
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)
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)
70430	176306	3	40	300x Mansell St	5	11	1	2			17	Width 0ft		6010916.0273400005	2090472.38873	37.7206546619672	-122.40430865004299	(37.7206546619672, -122.404308650043)
158945	176305	3	40	300x Mansell St	3	11	1	2			28	Width 0ft		6010925.6651800005	2090483.18833	37.7206848540134	-122.404276094583	(37.7206848540134, -122.404276094583)
161257	176304	3	40	200x Mansell St	17	11	1	2			12	Width 0ft		6011109.46654	2090529.17456	37.7208213917675	-122.403643980895	(37.7208213917675, -122.403643980895)

sf-trees

Custom SQL query returning 101 rows (hide)

Query parameters