sf-trees

This data as json, CSV

rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
55286	186809	2	35	1200 Sunset Blvd	118	9	1	1	2	Width 0ft	5984810.136	2106955.7691	37.7644202036906	-122.495762474243	(37.7644202036906, -122.495762474243)
173050	186810	2	35	1200 Sunset Blvd	117	9	1	1	3	Width 0ft	5984819.4006	2106939.4198	37.7643758556702	-122.49572922497102	(37.7643758556702, -122.495729224971)
68183	186811	2	35	1200 Sunset Blvd	116	9	1	1	2	Width 0ft	5984818.3107	2106920.8907	37.7643249161453	-122.495731627712	(37.7643249161453, -122.495731627712)
75257	186812	2	35	1200 Sunset Blvd	115	9	1	1	5	Width 0ft	5984824.8504	2106905.6313	37.764283401100705	-122.495707883417	(37.7642834011007, -122.495707883417)
155382	186813	2	35	1200 Sunset Blvd	114	9	1	1	2	Width 0ft	5984818.8556	2106897.4567	37.7642606048812	-122.4957280144	(37.7642606048812, -122.4957280144)
71793	186814	2	17	1200 Sunset Blvd	113	9	1	1	4	Width 0ft	5984809.4922	2106874.2257	37.764196270742204	-122.495758685523	(37.7641962707422, -122.495758685523)
55485	186815	2	198	1200 Sunset Blvd	112	9	1	1	2	Width 0ft	5984815.7546	2106849.1761	37.7641278583257	-122.49573517813299	(37.7641278583257, -122.495735178133)
129504	186816	2	180	1200 Sunset Blvd	111	9	1	1	2	Width 0ft	5984817.9648	2106815.6539	37.7640359452212	-122.49572506094401	(37.7640359452212, -122.495725060944)
74356	186817	2	30	1200 Sunset Blvd	110	9	1	1	2	Width 0ft	5984826.8059	2106810.865	37.7640233139964	-122.49569412937599	(37.7640233139964, -122.495694129376)
38561	181583	2	3	1200 Sunset Blvd	109	9	1	1	54	Width 0ft	5984816.8597	2106789.1308	37.7639630555258	-122.495726926548	(37.7639630555258, -122.495726926548)
48784	186818	2	108	1200 Sunset Blvd	108	9	1	1	4	Width 0ft	5984817.9648	2106762.6077	37.7638902952632	-122.49572114784701	(37.7638902952632, -122.495721147847)
31887	186819	2	3	1200 Sunset Blvd	107	9	1	1	23	Width 0ft	5984817.9648	2106743.4521	37.7638376993678	-122.495719734787	(37.7638376993678, -122.495719734787)
155851	186820	2	108	1200 Sunset Blvd	106	9	1	1	3	Width 0ft	5984828.6477	2106734.2427	37.7638130385474	-122.49568210708901	(37.7638130385474, -122.495682107089)
32317	186821	2	5	1200 Sunset Blvd	105	9	1	1	3	Width 0ft	5984828.6477	2106722.4547	37.763780672010896	-122.49568123753599	(37.7637806720109, -122.495681237536)
65039	186822	2	108	1200 Sunset Blvd	104	9	1	1	3	Width 0ft	5984834.1734	2106701.8256	37.7637243538842	-122.495660604407	(37.7637243538842, -122.495660604407)
163102	186823	2	108	1200 Sunset Blvd	103	9	1	1	4	Width 0ft	5984834.1734	2106687.8273	37.763685918484	-122.49565957182101	(37.763685918484, -122.495659571821)
131707	181584	2	3	1200 Sunset Blvd	102	9	1	1	22	Width 0ft	5984836.752	2106666.0931	37.763626393477104	-122.495649050161	(37.7636263934771, -122.495649050161)
172544	186824	2	3	1200 Sunset Blvd	101	9	1	1	18	Width 0ft	5984835.6469	2106654.305	37.7635939619503	-122.495652002752	(37.7635939619503, -122.495652002752)
153690	186825	2	5	1200 Sunset Blvd	100	9	1	1	4	Width 0ft	5984841.1725	2106636.9913	37.763546746968295	-122.49563161459999	(37.7635467469683, -122.4956316146)
146996	186826	2	180	1200 Sunset Blvd	99	9	1	1	1	Width 0ft	5984816.4913	2106624.0982	37.763509900791895	-122.49571602668301	(37.7635099007919, -122.495716026683)
23749	181585	2	3	1200 Sunset Blvd	98	9	1	1	34	Width 0ft	5984843.0144	2106607.1528	37.7634649266844	-122.49562304315201	(37.7634649266844, -122.495623043152)
42516	184094	2	47	1600 Sunset Blvd	97	9	1	1	2	Width 0ft	5984942.4654	2104248.1437	37.756993568912705	-122.49510511552201	(37.7569935689127, -122.495105115522)
160096	186833	2	108	1200 Sunset Blvd	97	9	1	1	3	Width 0ft	5984849.2768	2106596.8383	37.7634369726808	-122.49560062301799	(37.7634369726808, -122.495600623018)
53983	186827	2	108	1200 Sunset Blvd	96	9	1	1	3	Width 0ft	5984832.3315	2106605.3109999998	37.7634592440326	-122.495659855463	(37.7634592440326, -122.495659855463)
149699	184093	2	141	1600 Sunset Blvd	96	9	1	1	3	Width 0ft	5984922.9495	2104229.3007	37.7569406887046	-122.49517121838801	(37.7569406887046, -122.495171218388)
45664	184092	2	47	1600 Sunset Blvd	95	9	1	1	25	Width 0ft	5984922.9495	2104224.59	37.756927754428894	-122.49517087102	(37.7569277544289, -122.49517087102)
52631	186828	2	141	1200 Sunset Blvd	95	9	1	1	2	Width 0ft	5984824.2272	2106601.6272	37.76344865476	-122.495687613477	(37.76344865476, -122.495687613477)
36960	186829	2	105	1200 Sunset Blvd	94	9	1	1	1	Width 0ft	5984823.8588	2106586.1554	37.763406151967004	-122.49568774634399	(37.763406151967, -122.495687746344)
162095	184091	2	116	1600 Sunset Blvd	94	9	1	1	2	Width 0ft	5984954.5787	2104192.9608	37.756842761121895	-122.495059154794	(37.7568427611219, -122.495059154794)
39101	181366	2	3	1600 Sunset Blvd	93	9	1	1	33	Width 0ft	5984930.8531	2104160.775	37.756752998853	-122.49513883215201	(37.756752998853, -122.495138832152)
129592	186830	2	1	1200 Sunset Blvd	93	9	1	1	6	Width 0ft	5984826.8059	2106580.9981	37.7633921640535	-122.49567717299999	(37.7633921640535, -122.495677173)
54912	186834	2	180	1200 Sunset Blvd	92	9	1	1	1	Width 0ft	5984853.6973	2106574.7357	37.763376544001105	-122.495583703829	(37.7633765440011, -122.495583703829)
66704	181365	2	105	1600 Sunset Blvd	92	9	1	1	2	Width 0ft	5984912.4611	2104151.8757	37.75672748706779	-122.495201781242	(37.7567274870678, -122.495201781242)
71028	184090	2	108	1600 Sunset Blvd	91	9	1	1	2	Width 0ft	5984905.3417	2104126.3643	37.7566570230164	-122.4952245211	(37.7566570230164, -122.4952245211)
177987	186620	2	71	1501 Sunset Blvd	91	9	1	1	1	Width 0ft	5984755.0749	2104355.2681	37.7572767304033	-122.495761074715	(37.7572767304033, -122.495761074715)
47108	186831	2	141	1200 Sunset Blvd	90	9	1	1	6	Width 0ft	5984823.4905	2106576.2092	37.763378820926	-122.495688286465	(37.763378820926, -122.495688286465)
72108	186619	2	3	1501 Sunset Blvd	90	9	1	1	28	Width 0ft	5984733.72	2104360.7115	37.7572904258336	-122.495835328738	(37.7572904258336, -122.495835328738)
134633	187307	2	116	2401 Sunset Blvd	90	9	1	1	3	Width 0ft	5984946.0227	2098230.3328	37.740470513218796	-122.49464917361601	(37.7404705132188, -122.494649173616)
186034	184089	2	108	1600 Sunset Blvd	90	9	1	1	3	Width 0ft	5984906.5283	2104110.9388	37.7566147383421	-122.495219279964	(37.7566147383421, -122.495219279964)
40017	186618	2	3	1501 Sunset Blvd	89	9	1	1	33	Width 0ft	5984770.9865	2104371.1796	37.7573213507818	-122.495707220643	(37.7573213507818, -122.495707220643)
71275	187306	2	116	2401 Sunset Blvd	89	9	1	1	4	Width 0ft	5984963.8587	2098228.7818	37.7404672985278	-122.494587390296	(37.7404672985278, -122.494587390296)
152873	184088	2	47	1600 Sunset Blvd	89	9	1	1	52	Width 0ft	5984924.9202	2104112.1254	37.756619073195	-122.49515576258999	(37.756619073195, -122.49515576259)
34118	185363	2	143	2601 Sunset Blvd	88	9	1	1	43	Width 0ft	5984980.3483	2096870.9998	37.7367401586853	-122.49443031260901	(37.7367401586853, -122.494430312609)
50410	186835	2	108	1200 Sunset Blvd	88	9	1	1	4	Width 0ft	5984844.4879	2106569.9468	37.7633628557386	-122.495615202431	(37.7633628557386, -122.495615202431)
75220	184087	2	143	1600 Sunset Blvd	88	9	1	1	12	Width 0ft	5984947.9817	2104096.3091	37.7565769961358	-122.495074842554	(37.7565769961358, -122.495074842554)
153678	187305	2	116	2401 Sunset Blvd	88	9	1	1	1	Width 0ft	5984977.8173	2098236.5366	37.740489408091605	-122.49453969916	(37.7404894080916, -122.49453969916)
173730	186617	2	168	1501 Sunset Blvd	88	9	1	1	1	Width 0ft	5984770.9865	2104379.1354	37.757343195198004	-122.495707807467	(37.757343195198, -122.495707807467)
47680	184086	2	123	1600 Sunset Blvd	87	9	1	1	2	Width 0ft	5984957.3486	2104087.5098	37.7565533840583	-122.495041800117	(37.7565533840583, -122.495041800117)
49403	186616	2	5	1501 Sunset Blvd	87	9	1	1	3	Width 0ft	5984717.3898	2104397.9779	37.75739179261161	-122.495894553165	(37.7573917926116, -122.495894553165)
52628	185362	2	143	2601 Sunset Blvd	87	9	1	1	3	Width 0ft	5984999.1909	2096870.1623	37.7367389618664	-122.494365104774	(37.7367389618664, -122.494365104774)
159647	186837	2	108	1200 Sunset Blvd	87	9	1	1	2	Width 0ft	5984854.0657	2106566.6314	37.7633543134405	-122.49558183188299	(37.7633543134405, -122.495581831883)
161925	187304	2	108	2401 Sunset Blvd	87	9	1	1	6	Width 0ft	5984974.7154	2098241.9649	37.7405041311946	-122.49455082423401	(37.7405041311946, -122.494550824234)
39632	187303	2	108	2401 Sunset Blvd	86	9	1	1	3	Width 0ft	5984970.4503	2098239.6385	37.7404974938989	-122.494565399613	(37.7404974938989, -122.494565399613)
51375	181586	2	3	1200 Sunset Blvd	86	9	1	1	31	Width 0ft	5984850.3819	2106547.1075	37.7633004905742	-122.495593132629	(37.7633004905742, -122.495593132629)
148491	186615	2	47	1501 Sunset Blvd	86	9	1	1	3	Width 0ft	5984738.326	2104396.7218	37.7573895698596	-122.495822055914	(37.7573895698596, -122.495822055914)
148559	184085	2	24	1600 Sunset Blvd	86	9	1	1	1	Width 0ft	5984928.3026	2104071.5069	37.756507744074604	-122.495141070042	(37.7565077440746, -122.495141070042)
151754	185361	2	47	2601 Sunset Blvd	86	9	1	1	72	Width 0ft	5985015.9398	2096870.9998	37.7367422415889	-122.49430725909599	(37.7367422415889, -122.494307259096)
72990	186838	2	108	1200 Sunset Blvd	85	9	1	1	2	Width 0ft	5984850.7503	2106534.5827	37.7632661225609	-122.495590934617	(37.7632661225609, -122.495590934617)
131350	186614	2	5	1501 Sunset Blvd	85	9	1	1	57	Width 0ft	5984775.1737	2104397.9779	37.7573951766754	-122.495694716519	(37.7573951766754, -122.495694716519)
150966	185360	2	143	2601 Sunset Blvd	85	9	1	1	3	Width 0ft	5985022.2207	2096895.7045	37.7368104416486	-122.49428736403799	(37.7368104416486, -122.494287364038)
165670	187302	2	108	2401 Sunset Blvd	85	9	1	1	5	Width 0ft	5984968.1238	2098238.0875	37.7404930991044	-122.494573329313	(37.7404930991044, -122.494573329313)
169498	184084	2	108	1600 Sunset Blvd	85	9	1	1	2	Width 0ft	5984920.5061	2104059.8122	37.7564751772205	-122.495167170345	(37.7564751772205, -122.495167170345)
29536	184083	2	141	1600 Sunset Blvd	84	9	1	1	1	Width 0ft	5984945.8447	2104060.7868	37.756479336636296	-122.49507961366301	(37.7564793366363, -122.495079613663)
99051	181587	2	3	1200 Sunset Blvd	84	9	1	1	56	Width 0ft	5984853.6973	2106515.0588	37.76321268798	-122.49557930195299	(37.76321268798, -122.495579301953)
159840	186613	2	5	1501 Sunset Blvd	84	9	1	1	6	Width 0ft	5984762.1933	2104405.0962	37.7574139613926	-122.49574013227699	(37.7574139613926, -122.495740132277)
161798	187301	2	108	2401 Sunset Blvd	84	9	1	1	5	Width 0ft	5984961.92	2098240.0262	37.740498059151705	-122.494594922206	(37.7404980591517, -122.494594922206)
162350	185359	2	47	2601 Sunset Blvd	84	9	1	1	26	Width 0ft	5984996.2598	2096910.7786	37.7368503118256	-122.49437823177	(37.7368503118256, -122.49437823177)
35253	186612	2	5	1501 Sunset Blvd	83	9	1	1	10	Width 0ft	5984740.0009	2104413.4707	37.7574356557736	-122.49581749901002	(37.7574356557736, -122.49581749901)
36628	186839	2	47	1200 Sunset Blvd	83	9	1	1	2	Width 0ft	5984830.1212	2106502.1656	37.7631759062792	-122.49565989156099	(37.7631759062792, -122.495659891561)
51819	184082	2	108	1600 Sunset Blvd	83	9	1	1	2	Width 0ft	5984913.6842	2104051.0412	37.756450695089704	-122.49519011576	(37.7564506950897, -122.49519011576)
62450	187300	2	108	2401 Sunset Blvd	83	9	1	1	4	Width 0ft	5984960.7568	2098243.9036	37.7405086373666	-122.49459922981501	(37.7405086373666, -122.494599229815)
44873	187299	2	108	2401 Sunset Blvd	82	9	1	1	3	Width 0ft	5984957.2671	2098247.0055	37.7405169500984	-122.49461152428199	(37.7405169500984, -122.494611524282)
66347	186804	2	193	1200 Sunset Blvd	82	9	1	1	8	Width 0ft	5984861.7413	2106944.0092	37.764390936343396	-122.495583120993	(37.7643909363434, -122.495583120993)
165792	184081	2	108	1600 Sunset Blvd	82	9	1	1	2	Width 0ft	5984942.4337	2104051.5284	37.7564537159438	-122.495090727248	(37.7564537159438, -122.495090727248)
167469	186611	2	5	1501 Sunset Blvd	82	9	1	1	7	Width 0ft	5984721.5770000005	2104411.7958	37.7574299779546	-122.49588109168998	(37.7574299779546, -122.49588109169)
171874	185357	2	168	2601 Sunset Blvd	82	9	1	1	1	Width 0ft	5985023.8956	2096938.833	37.736928958988706	-122.494284751295	(37.7369289589887, -122.494284751295)
39750	184080	2	108	1600 Sunset Blvd	81	9	1	1	3	Width 0ft	5984946.8193	2104049.0919999997	37.7564472830117	-122.49507538087	(37.7564472830117, -122.49507538087)
52907	187298	2	108	2401 Sunset Blvd	81	9	1	1	4	Width 0ft	5984949.5124	2098247.3933	37.7405175610104	-122.49463836520799	(37.7405175610104, -122.494638365208)
67433	186610	2	5	1501 Sunset Blvd	81	9	1	1	6	Width 0ft	5984720.7396	2104420.1703	37.7574529229595	-122.49588460547199	(37.7574529229595, -122.495884605472)
135520	186803	2	17	1200 Sunset Blvd	81	9	1	1	4	Width 0ft	5984854.4903	2106938.312	37.7643748688283	-122.495607779566	(37.7643748688283, -122.495607779566)
156868	185356	2	41	2601 Sunset Blvd	81	9	1	1	4	Width 0ft	5985014.265	2096945.9513	37.736947940348294	-122.49431857261001	(37.7369479403483, -122.49431857261)
70272	186802	2	5	1200 Sunset Blvd	80	9	1	1	10	Width 0ft	5984846.4625	2106932.8738	37.76435946696029	-122.495635143928	(37.7643594669603, -122.495635143928)
71896	184079	2	143	1600 Sunset Blvd	80	9	1	1	4	Width 0ft	5984934.15	2104045.1938	37.75643583792721	-122.49511890768	(37.7564358379272, -122.49511890768)
153696	181520	2	3	1400 Sunset Blvd	80	9	1	1	62	Width 0ft	5984870.8428	2105613.4659	37.7607381702444	-122.49545350347601	(37.7607381702444, -122.495453503476)
157552	187297	2	108	2401 Sunset Blvd	80	9	1	1	4	Width 0ft	5984942.9208	2098245.0668	37.7405107872571	-122.494660984587	(37.7405107872571, -122.494660984587)
172909	186609	2	5	1501 Sunset Blvd	80	9	1	1	7	Width 0ft	5984732.0451	2104419.3328	37.7574512855375	-122.49584544534599	(37.7574512855375, -122.495845445346)
45402	223688	2	34	1300 San Jose Ave	79	9	1	1	33		6003610.6352699995	2095763.96292	37.734773207799705	-122.42993836337901	(37.7347732077997, -122.429938363379)
136877	181519	2	71	1400 Sunset Blvd	79	9	1	1	2	Width 0ft	5984899.8047	2105606.7824	37.76072151501489	-122.49535284581002	(37.7607215150149, -122.49535284581)
152960	187296	2	108	2401 Sunset Blvd	79	9	1	1	7	Width 0ft	5984940.5944	2098249.7197	37.7405234267001	-122.494669371199	(37.7405234267001, -122.494669371199)
155155	186608	2	5	1501 Sunset Blvd	79	9	1	1	7	Width 0ft	5984734.9762	2104426.0324	37.757469852437794	-122.49583580278299	(37.7574698524378, -122.495835802783)
165013	186801	2	108	1200 Sunset Blvd	79	9	1	1	4	Width 0ft	5984854.2314	2106929.2483	37.7643499672955	-122.495608006442	(37.7643499672955, -122.495608006442)
175953	184078	2	108	1600 Sunset Blvd	79	9	1	1	1	Width 0ft	5984934.15	2104038.8591	37.7564184445961	-122.49511844057301	(37.7564184445961, -122.495118440573)
26088	184889	2	142	1201 Sunset Blvd	78	9	1	1	6	Width 0ft	5984679.4382	2106701.786	37.763715182625106	-122.49619577469801	(37.7637151826251, -122.496195774698)
50110	181518	2	168	1400 Sunset Blvd	78	9	1	1	1	Width 0ft	5984884.7668	2105589.5167	37.7606732277268	-122.495403580994	(37.7606732277268, -122.495403580994)
58217	233515	2	108	1001 San Jose Ave	78	9	1	1	4	Width 8ft	6005400.68613	2097518.02448	37.739690679175	-122.423874221345	(37.739690679175, -122.423874221345)
61223	223687	2	34	1300 San Jose Ave	78	9	1	1	30		6003595.322819999	2095749.76231	37.7347333489588	-122.429990291123	(37.7347333489588, -122.429990291123)
68751	184077	2	123	1600 Sunset Blvd	78	9	1	1	1	Width 0ft	5984949.117000001	2104038.1203	37.7564172922771	-122.495066625722	(37.7564172922771, -122.495066625722)
168416	186800	2	54	1200 Sunset Blvd	78	9	1	1	3	Width 0ft	5984846.2035	2106925.1049	37.7643381205783	-122.495635466651	(37.7643381205783, -122.495635466651)
171617	187295	2	116	2401 Sunset Blvd	78	9	1	1	1	Width 0ft	5984937.4924	2098259.4132	37.7405498608751	-122.49468081101999	(37.7405498608751, -122.49468081102)
174966	185935	2	47	2000 Sunset Blvd	78	9	1	1	2	Width 0ft	5985034.4441	2101527.1648	37.7495278943342	-122.494586435864	(37.7495278943342, -122.494586435864)
183983	186607	2	47	1501 Sunset Blvd	78	9	1	1	2	Width 0ft	5984762.1933	2104423.9388	37.757465697935096	-122.495741522143	(37.7574656979351, -122.495741522143)

sf-trees

Custom SQL query returning 101 rows (hide)

Query parameters