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
46601	84938	6	40	145 Guerrero St	1	7	1	1					Permit Number 49347	6005480.0	2108218.0	37.769074802262395	-122.42436083172	(37.7690748022624, -122.42436083172)
49634	112391	6	40	2201X LYON ST	2	5	1	1				3x12		5999307.0	2116423.0	37.7912531030346	-122.446303107227	(37.7912531030346, -122.446303107227)
80719	116576	6	40	2500x OCEAN AVE	1	9	1	6	4		30	10X10		5991377.0	2094742.0	37.7312667472315	-122.472159374256	(37.7312667472315, -122.472159374256)
81453	114249	6	40	499x 24TH AVE	1	5	1	1				3x3		5988415.0	2112957.0	37.78110836988721	-122.483734439284	(37.7811083698872, -122.483734439284)
85476	112374	6	40	1247 Bosworth St	1	7	1	1				20x20	Permit Number 775819	6000424.1100699995	2096055.79143	37.735393525896704	-122.44097617665199	(37.7353935258967, -122.440976176652)
107396	112485	6	40	1275 Columbus Ave	5	7	1	1		08/03/2015 12:00:00 AM				6007539.6	2121483.9	37.8056158049656	-122.418177422209	(37.8056158049656, -122.418177422209)
108486	107550	6	40	198X Jennings St	3	7	1	2						6018784.70414	2097136.12526	37.739388557233205	-122.377570991407	(37.7393885572332, -122.377570991407)
112521	98951	6	40	401 Grove St	11	7	1	1						6005778.2	2111279.0	37.7774964045324	-122.423547027313	(37.7774964045324, -122.423547027313)
117944	104432	6	40	1601X PORTOLA DR	1	7	1	1			14			5991823.0	2096240.0	37.73540567927029	-122.47072655808	(37.7354056792703, -122.47072655808)
122611	112487	6	40	1275 Columbus Ave	7	7	1	1						6007539.6	2121483.9	37.8056158049656	-122.418177422209	(37.8056158049656, -122.418177422209)
122658	112488	6	40	1275 Columbus Ave	8	7	1	1						6007539.6	2121483.9	37.8056158049656	-122.418177422209	(37.8056158049656, -122.418177422209)
124450	112484	6	40	1275 Columbus Ave	4	7	1	1		08/03/2015 12:00:00 AM				6007539.6	2121483.9	37.8056158049656	-122.418177422209	(37.8056158049656, -122.418177422209)
126530	98952	6	40	302 Ivy St	18	7	1	1						6005888.5	2111234.3	37.7773798943726	-122.42316228433	(37.7773798943726, -122.42316228433)
139051	112390	6	40	2201X LYON ST	1	5	1	1				3x12		5999307.0	2116423.0	37.7912531030346	-122.446303107227	(37.7912531030346, -122.446303107227)
140157	6099	6	40	500X 08th St	1	5	1	1			18	18		6010526.812454099	2109340.6023904	37.772440902057795	-122.406983260044	(37.7724409020578, -122.406983260044)
140881	107539	6	40	198X JENNINGS ST	1	7	1	2						6018784.0	2097136.0	37.739388174499	-122.377573417349	(37.739388174499, -122.377573417349)
109	9895	3	40	1800X Pine St	1	1	1	2			18	3X3		6005051.0377	2115464.4068	37.7889474242075	-122.426360597873	(37.7889474242075, -122.426360597873)
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
10110	17260	3	40	29 Osceola Ln	1	1	1	2		01/27/2017 12:00:00 AM	18	3X3		6017247.640204701	2094279.3298336002	37.73145956022589	-122.382686794637	(37.7314595602259, -122.382686794637)
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
13854	11422	3	40	803X Mendell St	1	1	1	2			24	3X3		6016040.90005	2096755.8649799998	37.738192886184	-122.38703142706001	(37.738192886184, -122.38703142706)
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
14354	17473	3	40	2050X Palou Ave	8	1	1	2		11/17/1992 12:00:00 AM	12	3X3		6012341.587169999	2097177.38743	37.73914476102	-122.39985148498	(37.73914476102, -122.39985148498)
14387	22148	3	40	3800 03rd St	3	1	1	2			6	3x3		6015737.9632	2098284.4406	37.7423732631069	-122.388185488874	(37.7423732631069, -122.388185488874)
14502	17475	3	40	2050X Palou Ave	10	1	1	2			12	3X3		6012301.79777	2097206.74854	37.7392231621197	-122.399991120917	(37.7392231621197, -122.399991120917)
14653	19921	3	40	100 STAIRWAY37	1	1	1	2			12	3X3
15242	22432	3	40	6000 03rd St	1	1	1	2			18	3X3		6013579.8961	2091555.5712	37.7237773618259	-122.39517625529	(37.7237773618259, -122.39517625529)
15445	19918	3	40	100 STAIRWAY35	14	1	1	2			6	120ST
15768	19884	3	40	100 STAIRWAY33	16	1	1	2			18	25ST
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
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)
24910	113499	3	40	200x Mansell St	5	11	1	2			19	3x3		6011193.56936	2090563.5306400002	37.7209204242214	-122.403355677147	(37.7209204242214, -122.403355677147)
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)
28724	199407	3	40	301x Cashmere St	7	3	1	2			18			6016184.136419999	2096191.07332	37.736650012889	-122.386496812495	(37.736650012889, -122.386496812495)
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)
30521	17266	3	40	40 Osceola Dr	1	1	1	2			18	3X3		6017197.543092299	2094354.669125	37.7316636592684	-122.382865232677	(37.7316636592684, -122.382865232677)
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)
36977	186970	3	40	1650x Sloat Blvd	1	11	1	2			10	Width 0ft		5986025.4295	2095869.2083	37.734050611594604	-122.49074337328301	(37.7340506115946, -122.490743373283)
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)
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)
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)
44683	176302	3	40	100x Mansell St	2	11	1	2			18	Width 0ft		6011513.54745	2090660.92357	37.721205711656204	-122.40225644658301	(37.7212057116562, -122.402256446583)
46745	176303	3	40	200x Mansell St	16	11	1	2			23	Width 0ft		6011115.33526	2090539.9745900002	37.7208513742667	-122.40362445389799	(37.7208513742667, -122.403624453898)
49638	25447	3	40	1261X La Salle Ave	15	1	1	2			18	3X3		6017141.6501925	2094501.7221284	37.732064349457005	-122.383068698568	(37.732064349457, -122.383068698568)
50131	199404	3	40	299x Cashmere St	24	3	1	2			31			6016629.65755	2096008.94769	37.7361745853726	-122.38494375437	(37.7361745853726, -122.38494375437)
53330	186974	3	40	1600x Sloat Blvd	1	11	1	2			9	Width 0ft		5986249.0864	2095869.2083	37.7340636742344	-122.489970132524	(37.7340636742344, -122.489970132524)
55441	199405	3	40	301x Cashmere St	4	3	1	2			25			6016273.90453	2096214.7321400002	37.736719944173004	-122.386188091409	(37.736719944173, -122.386188091409)
56266	9287	3	40	13X George Ct	4	1	1	2			18	3X3		6017208.549763201	2094048.0250586998	37.7308222832509	-122.38280584856301	(37.7308222832509, -122.382805848563)
58856	185127	3	40	700x Sloat Blvd	2	11	1	2			10	Width 0ft		5989015.4133	2095969.6432	37.734500589899504	-122.480413539116	(37.7345005898995, -122.480413539116)
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)
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)
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)
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)
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)

sf-trees

Custom SQL query returning 101 rows (hide)

Query parameters