sf-trees

This data as json, CSV

rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	PlantDate	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
15631	3715	3	36	401X Cargo Way	20	1	1	2	06/07/1996 12:00:00 AM	3	3X3	6016713.472019999	2099127.09165	37.744741012786896	-122.38487113321699	(37.7447410127869, -122.384871133217)
15648	3722	3	36	401X Cargo Way	27	1	1	2		18	3X3	6016920.12543	2098972.91356	37.7443290989992	-122.384145823682	(37.7443290989992, -122.384145823682)
15661	11532	3	36	101X Jennings St	22	1	1	2		18	3X3	6018674.73047	2096936.9392900001	37.738835572289794	-122.377937414197	(37.7388355722898, -122.377937414197)
15686	19660	3	36	100 STAIRWAY5	59	1	1	2		18	60ST
15740	11517	3	36	101X Jennings St	7	1	1	2		18	3X3	6018459.10272	2096646.1554299998	37.738025252555	-122.37866277678499	(37.738025252555, -122.378662776785)
15758	22102	3	36	3550 03rd St	2	1	1	2		12	3X3	6016009.792669999	2099202.98145	37.744910445068896	-122.387309635952	(37.7449104450689, -122.387309635952)
15806	11530	3	36	101X Jennings St	20	1	1	2		18	3X3	6018648.41512	2096905.05742	37.7387465808009	-122.37802618897	(37.7387465808009, -122.37802618897)
15917	11515	3	36	101X Jennings St	5	1	1	2		18	3X3	6018435.759869999	2096618.26492	37.7379473838671	-122.378741549297	(37.7379473838671, -122.378741549297)
15985	11549	3	36	101X Jennings St	39	1	1	2		18	3X3	6018893.31945	2097233.60379	37.7396621976446	-122.37720220492399	(37.7396621976446, -122.377202204924)
15997	3723	3	36	401X Cargo Way	28	1	1	2		18	3X3	6016936.70179	2098960.3168599997	37.744295427497704	-122.384087628549	(37.7442954274977, -122.384087628549)
16000	3730	3	36	401X Cargo Way	35	1	1	2		12	3X3	6017054.36564	2098871.4939599996	37.744058042453496	-122.383674585207	(37.7440580424535, -122.383674585207)
16120	19653	3	36	100 STAIRWAY5	52	1	1	2		12	60ST
16127	3731	3	36	401X Cargo Way	36	1	1	2		18	3X3	6017071.75465	2098858.47223	37.74402324858939	-122.383613550927	(37.7440232485894, -122.383613550927)
16170	3716	3	36	401X Cargo Way	21	1	1	2		18	3X3	6016802.38016	2099057.65052	37.744555258722	-122.38455886702299	(37.744555258722, -122.384558867023)
16379	11537	3	36	101X Jennings St	27	1	1	2		18	3X3	6018733.38325	2097012.4655799998	37.7390461845215	-122.37773985832399	(37.7390461845215, -122.377739858324)
16384	11539	3	36	101X Jennings St	29	1	1	2		18	3X3	6018768.44621	2097065.7782599998	37.739194502529294	-122.37762232410601	(37.7391945025293, -122.377622324106)
16435	3724	3	36	401X Cargo Way	29	1	1	2		18	3X3	6016958.14867	2098944.9648700003	37.7442544597685	-122.38401240026501	(37.7442544597685, -122.384012400265)
16471	22104	3	36	3550 03rd St	4	1	1	2		18	3X3	6015995.55908	2099134.0934900003	37.74472050464	-122.387354048955	(37.74472050464, -122.387354048955)
16472	11547	3	36	101X Jennings St	37	1	1	2		18	3X3	6018868.04549	2097199.54045	37.7395672742039	-122.377287229525	(37.7395672742039, -122.377287229525)
16519	3732	3	36	401X Cargo Way	37	1	1	2		18	3X3	6017092.791180001	2098843.12861	37.7439822808577	-122.383539742673	(37.7439822808577, -122.383539742673)
16584	3719	3	36	401X Cargo Way	24	1	1	2		12	3X3	6016852.7534	2099021.2782	37.744458173299996	-122.38438215201799	(37.7444581733, -122.384382152018)
16643	3702	3	36	401X Cargo Way	7	1	1	2	03/14/1990 12:00:00 AM	12	3X3	6016478.46508	2099300.03196	37.7452028704157	-122.385695800734	(37.7452028704157, -122.385695800734)
16658	22427	3	36	5919 03rd St	2	1	1	2		18	3X3	6013743.1817	2091759.1378	37.724345394142	-122.39462604842699	(37.724345394142, -122.394626048427)
16711	11513	3	36	101X Jennings St	3	1	1	2		12	3X3	6018414.43418	2096589.52395	37.7378672911411	-122.378813288221	(37.7378672911411, -122.378813288221)
16734	11519	3	36	101X Jennings St	9	1	1	2		18	3X3	6018482.73466	2096678.8993400002	37.7381164636019	-122.378583341463	(37.7381164636019, -122.378583341463)
16820	11511	3	36	101X Jennings St	1	1	1	2		18	5	6018385.91854	2096547.1526	37.7377493756286	-122.378908940096	(37.7377493756286, -122.378908940096)
16854	11488	3	36	100 Jennings St	2	1	1	2	01/05/1993 12:00:00 AM	6	4X4	6018872.157000001	2097296.32677	37.7398332567899	-122.377279727371	(37.7398332567899, -122.377279727371)
16927	24534	3	36	128 Cortland Ave	1	1	1	2	04/11/1996 12:00:00 AM	8	3X3	6006387.02802	2097608.2195099997	37.7399939683457	-122.420470266705	(37.7399939683457, -122.420470266705)
16934	4202	3	36	3902 Cesar Chavez St	1	1	1	2		18	3X3	6004480.6649	2100468.03712	37.7477387553393	-122.427265346224	(37.7477387553393, -122.427265346224)
17259	4834	3	36	108 Cortland Ave	1	1	1	2		30	5x5	6006318.50135	2097642.9115299997	37.7400853628581	-122.420709666225	(37.7400853628581, -122.420709666225)
17352	16120	3	36	303 Monterey Blvd	1	1	1	2		18	3x3	6000032.3049	2094633.40383	37.7314656586952	-122.44222871430401	(37.7314656586952, -122.442228714304)
17573	16029	3	36	146 Monterey Blvd	1	1	1	2		12	3X3	6001109.44487	2094693.26414	37.7316913516547	-122.43850913181002	(37.7316913516547, -122.43850913181)
17697	4413	3	36	1108 Church St	1	1	1	2		28	6x9	6004403.04195	2102416.52833	37.753084468576205	-122.427672567341	(37.7530844685762, -122.427672567341)
18215	4462	3	36	1454 Church St	1	1	1	2		18	4X4	6004517.68898	2100379.8296	37.7474986516535	-122.42713103697099	(37.7474986516535, -122.427131036971)
18226	4848	3	36	229 Cortland Ave	1	1	1	2		32	2x3	6006739.96805	2097466.29285	37.7396241527309	-122.419239878116	(37.7396241527309, -122.419239878116)
18235	4828	3	36	85 Cortland Ave	1	1	1	2		25	3X3	6006188.87424	2097766.1175	37.740416352027204	-122.421166610858	(37.7404163520272, -122.421166610858)
18348	16020	3	36	107 Monterey Blvd	1	1	1	2		18	3x3	6001336.16248	2094611.17288	37.731478841871706	-122.437719447913	(37.7314788418717, -122.437719447913)
18512	4810	3	36	20 Cortland Ave	1	1	1	2		40	3X3	6005841.28363	2097904.31782	37.7407762175496	-122.42237826114099	(37.7407762175496, -122.422378261141)
18582	4840	3	36	138 Cortland Ave	1	1	1	2		65	3X3	6006436.16175	2097581.71528	37.7399239624285	-122.42029850157499	(37.7399239624285, -122.420298501575)
18996	28137	3	36	418 Eugenia Ave	1	1	1	2		40	4X5	6006961.256569999	2097891.09385	37.740803021841295	-122.418504870321	(37.7408030218413, -122.418504870321)
19096	4431	3	36	1195 Church St	1	1	1	2		18	3X3	6004486.69317	2101949.49973	37.7518068485257	-122.427350018309	(37.7518068485257, -122.427350018309)
19295	5760	3	36	398 Duboce Ave	2	1	1	2		36	3x3	6003950.51884	2108401.53413	37.7694922566853	-122.42966430666999	(37.7694922566853, -122.42966430667)
19540	4835	3	36	115 Cortland Ave	1	1	1	2		24	3x3	6006362.63783	2097667.32197	37.7401548759573	-122.420558792379	(37.7401548759573, -122.420558792379)
19938	16038	3	36	163 Monterey Blvd	1	1	1	2		12	3X3	6000989.84379	2094618.6563099998	37.7314796917131	-122.43891727113301	(37.7314796917131, -122.438917271133)
20001	4839	3	36	135 Cortland Ave	1	1	1	2		18	3x3	6006426.94909	2097635.5595299997	37.7400712875725	-122.42033417588699	(37.7400712875725, -122.420334175887)
20112	29963	3	36	500X Junipero Serra Blvd	6	11	1	2	03/09/2013 12:00:00 AM	3	3x3	5991394.8537099995	2093447.95886	37.7277146673841	-122.47200336878099	(37.7277146673841, -122.472003368781)
20184	16030	3	36	147 Monterey Blvd	1	1	1	2		24	3X3	6001102.99289	2094615.6926099998	37.731477991115796	-122.438525881668	(37.7314779911158, -122.438525881668)
20202	5091	3	36	2600 Diamond St	1	1	1	2		18	3X3	6002242.42307	2096653.9998400002	37.7371394644141	-122.434732362321	(37.7371394644141, -122.434732362321)
20228	4824	3	36	73 Cortland Ave	1	1	1	2		18	3X3	6006137.31563	2097787.40171	37.740471886955	-122.42134639164301	(37.740471886955, -122.421346391643)
20730	4823	3	36	66 Cortland Ave	1	1	1	2		28	3X3	6006092.06915	2097770.47064	37.74042284693579	-122.421501634396	(37.7404228469358, -122.421501634396)
21184	4827	3	36	80 Cortland Ave	1	1	1	2		80	3X3	6006160.77573	2097729.74879	37.74031490761921	-122.421261182679	(37.7403149076192, -122.421261182679)
21191	4812	3	36	28 Cortland Ave	1	1	1	2		46	3X3	6005885.45019	2097879.1399	37.7407095759957	-122.422223761224	(37.7407095759957, -122.422223761224)
21443	4396	3	36	1005 Church St	1	1	1	2		12	3x3	6004431.4266800005	2103008.65854	37.754711924921295	-122.427616590837	(37.7547119249213, -122.427616590837)
21637	4817	3	36	51 Cortland Ave	1	1	1	2		12	3x3	6005995.99863	2097868.77885	37.7406873618291	-122.42184079032499	(37.7406873618291, -122.421840790325)
21650	1996	3	36	175 Bocana St	1	1	1	2		40	3x3	6007331.5108	2098053.7261799998	37.741270411207296	-122.41723618861201	(37.7412704112073, -122.417236188612)
21920	4841	3	36	142 Cortland Ave	1	1	1	2		18	6x9	6006480.033919999	2097559.50493	37.7398654498357	-122.420145233727	(37.7398654498357, -122.420145233727)
21993	16119	3	36	301 Monterey Blvd	1	1	1	2		18	3x3	6000050.07874	2094632.71852	37.7314647899581	-122.442167217764	(37.7314647899581, -122.442167217764)
22088	16025	3	36	131 Monterey Blvd	1	1	1	2		18	4X4	6001203.7257900005	2094613.91575	37.7314788418574	-122.438177502293	(37.7314788418574, -122.438177502293)
22196	4409	3	36	1097 Church St	1	1	1	2		24	4x4	6004456.37766	2102543.07479	37.753434952361495	-122.427497136583	(37.7534349523615, -122.427497136583)
22222	4815	3	36	36 Cortland Ave	1	1	1	2		80	3X3	6005920.0488599995	2097862.788	37.740666628859294	-122.42210297059799	(37.7406666288593, -122.422102970598)
22410	9892	3	36	1700 Gough St	4	1	1	2		18	3X3	6005332.72699	2115570.2247599997	37.7892538927886	-122.42539352339199	(37.7892538927886, -122.425393523392)
22450	17763	3	36	1700 Pine St	3	1	1	2		18	3X3	6005669.54525	2115550.54053	37.7892188686951	-122.42422677084998	(37.7892188686951, -122.42422677085)
22500	17776	3	36	1762 Pine St	2	1	1	2		18	3X3	6005516.07608	2115531.08967	37.7891567948058	-122.424756371721	(37.7891567948058, -122.424756371721)
22519	17782	3	36	1791 Pine St	3	1	1	2		24	3x3	6005428.2033400005	2115468.32597	37.788979497959296	-122.425055933202	(37.7889794979593, -122.425055933202)
22570	9891	3	36	1700 Gough St	3	1	1	2		24	3X3	6005334.61917	2115551.7772	37.7892033473078	-122.425385663344	(37.7892033473078, -122.425385663344)
22653	17778	3	36	1770 Pine St	2	1	1	2		18	3X3	6005458.75733	2115520.73995	37.7891251395545	-122.424953950985	(37.7891251395545, -122.424953950985)
22805	17745	3	36	1600X Pine St	2	1	1	2		18	3X3	6006152.6648	2115617.75127	37.7894306797229	-122.422560011429	(37.7894306797229, -122.422560011429)
23051	10656	3	36	940 Hayes St	1	1	1	2		17	3X3	6003283.9904	2110703.7361	37.7757757730917	-122.432134230107	(37.7757757730917, -122.432134230107)
23085	11553	3	36	101X Jennings St	43	1	1	2	12/23/1997 12:00:00 AM	29	3X3	6018940.8378099995	2097294.9489700003	37.7398332568108	-122.377042159778	(37.7398332568108, -122.377042159778)
23178	11964	3	36	1009X Mendell St	2	1	1	2		28	3X3	6015715.011390001	2096321.03931	37.7369808923559	-122.38812786163	(37.7369808923559, -122.38812786163)
23186	17762	3	36	1700 Pine St	2	1	1	2		23		6005688.226009999	2115553.43335	37.7892278664309	-122.424162343438	(37.7892278664309, -122.424162343438)
23241	11550	3	36	101X Jennings St	40	1	1	2		21	3X3	6018907.35155	2097248.08652	37.7397027373041	-122.37715469195601	(37.7397027373041, -122.377154691956)
23270	11971	3	36	1022X Mendell St	1	1	1	2		21	3X3	6015641.62594	2096289.89853	37.736891319872896	-122.388379417299	(37.7368913198729, -122.388379417299)
23295	9894	3	36	1700 Gough St	6	1	1	2	10/15/1997 12:00:00 AM	23	3X3	6005329.1496	2115601.42673	37.7893393634754	-122.425408122112	(37.7893393634754, -122.425408122112)
25039	199364	3	36	300x Division St	3	11	1	2		28	Width 6ft	6009993.3485	2108173.3882400002	37.7692061355694	-122.408746211675	(37.7692061355694, -122.408746211675)
27310	199370	3	36	3550 03rd St	1	1	1	2		27	Width 4ft	6016015.91083	2099228.15232	37.74497989792071	-122.38729023576799	(37.7449798979207, -122.387290235768)
33628	176389	3	36	700x Mansell St	16	11	1	2		38	Width 0ft	6009439.980830001	2090047.93275	37.719406601704	-122.40938096396499	(37.719406601704, -122.409380963965)
37403	11269	3	36	1176X Ingalls St	8	1	1	2	04/03/1990 12:00:00 AM	3	3x3	6017716.362196	2093961.1645628002	37.7306118245585	-122.381044204671	(37.7306118245585, -122.381044204671)
42536	176390	3	36	700x Mansell St	37	11	1	2		21	Width 0ft	6009150.9462	2089957.5754799999	37.7191423008581	-122.410373676998	(37.7191423008581, -122.410373676998)
45604	11962	3	36	945X Mendell St	4	1	1	2		18	3X3	6015820.0973	2096449.8462	37.7373403917231	-122.38777351408001	(37.7373403917231, -122.38777351408)
54771	176387	3	36	100x Mansell St	4	11	1	2		32	Width 0ft	6011480.82156	2090667.2216900003	37.7212211781905	-122.402370013862	(37.7212211781905, -122.402370013862)
56308	199365	3	36	300x Division St	4	3	1	2		36	Width 8ft	6009969.14716	2108168.58479	37.7691915908542	-122.408829584245	(37.7691915908542, -122.408829584245)
67100	176388	3	36	100x Mansell St	8	11	1	2		32	Width 0ft	6011438.192840001	2090648.2271599998	37.7211666433202	-122.40251603501001	(37.7211666433202, -122.40251603501)
70249	176386	3	36	10x Mansell St	10	11	1	2		8	Width 0ft	6011666.66331	2090722.9963200002	37.7213846965192	-122.40173152668501	(37.7213846965192, -122.401731526685)
77690	6329	3	36	1895X Ellis St	6	1	1	2		18	4X4	6001829.84497	2112881.90897	37.7816739348974	-122.437320479018	(37.7816739348974, -122.437320479018)
79043	4201	3	36	3902 Cesar Chavez St	1	1	1	2		18	3X3	6004475.85975	2100470.10248	37.7477441545905	-122.427282109286	(37.7477441545905, -122.427282109286)
79295	6333	3	36	1895X Ellis St	10	1	1	2		18	4X4	6001829.84497	2112881.90897	37.7816739348974	-122.437320479018	(37.7816739348974, -122.437320479018)
79767	6335	3	36	1895X Ellis St	12	1	1	2		18	4X4	6001829.84497	2112881.90897	37.7816739348974	-122.437320479018	(37.7816739348974, -122.437320479018)
80357	17764	3	36	1700 Pine St	4	1	1	2		18	3X3	6005780.4714382	2115564.9404688	37.789264670055	-122.423844003631	(37.789264670055, -122.423844003631)
80852	3738	3	36	401X Cargo Way	43	1	1	2		18	3X3	6017167.798756	2098792.720184	37.743848015002605	-122.383276872883	(37.7438480150026, -122.383276872883)
81124	11506	3	36	100 Jennings St	20	1	1	2		6	4X4	6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
81325	3739	3	36	401X Cargo Way	44	1	1	2		18	3X3	6017167.798756	2098792.720184	37.743848015002605	-122.383276872883	(37.7438480150026, -122.383276872883)
81336	26808	3	36	1485 McKinnon Ave	2	1	1	2		18	3X3	6015936.7189767	2095472.8520506	37.7346642227188	-122.387302163855	(37.7346642227188, -122.387302163855)
81339	6119	3	36	199X Elk St	3	1	1	2		18	3X3	6000815.0314327	2096222.3312360002	37.7358730629277	-122.439636554407	(37.7358730629277, -122.439636554407)
81374	6123	3	36	199X Elk St	7	1	1	2		12	3X3	6000815.0314327	2096222.3312360002	37.7358730629277	-122.439636554407	(37.7358730629277, -122.439636554407)
82431	6309	3	36	1807 Ellis St	2	1	1	2		18	4X4	6002200.5977300005	2112898.1085099997	37.7817394844201	-122.43603901136999	(37.7817394844201, -122.43603901137)
83509	11417	3	36	721X Mendell St	2	1	1	2		12	3X3	6016212.49704	2096975.20091	37.7388046385926	-122.386453413297	(37.7388046385926, -122.386453413297)
83724	26803	3	36	1470 McKinnon Ave	1	1	1	2		24	3X3	6016001.5116582	2095486.8668237	37.734706292549205	-122.387079128733	(37.7347062925492, -122.387079128733)
83866	11477	3	36	10X Jennings St	3	1	1	2		18	3X3	6012892.419875	2089345.335603	37.7176702433836	-122.397397833393	(37.7176702433836, -122.397397833393)
84321	6121	3	36	199X Elk St	5	1	1	2		12	3X3	6000815.0314327	2096222.3312360002	37.7358730629277	-122.439636554407	(37.7358730629277, -122.439636554407)
84520	3734	3	36	401X Cargo Way	39	1	1	2		18	3X3	6017167.798756	2098792.720184	37.743848015002605	-122.383276872883	(37.7438480150026, -122.383276872883)

sf-trees

Custom SQL query returning 101 rows (hide)

Query parameters