Street_Tree_List

Data source: data.sfgov.org

416 rows where qSpecies = 143

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PermitNotes

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
1320	1320	251503	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	800X Bosworth St	15	Side Yard : Yard 17	Tree 1	DPW 2						6001905.0	2095492.0	37.733929718905394	-122.435815869962	(37.7339297189054, -122.435815869962)
1324	1324	251501	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	800X Bosworth St	13	Side Yard : Yard 17	Tree 1	DPW 2						6001905.0	2095492.0	37.733929718905394	-122.435815869962	(37.7339297189054, -122.435815869962)
1326	1326	251502	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	800X Bosworth St	14	Side Yard : Yard 17	Tree 1	DPW 2						6001905.0	2095492.0	37.733929718905394	-122.435815869962	(37.7339297189054, -122.435815869962)
1335	1335	251499	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	800X Bosworth St	11	Side Yard : Yard 17	Tree 1	DPW 2						6001905.0	2095492.0	37.733929718905394	-122.435815869962	(37.7339297189054, -122.435815869962)
1341	1341	251498	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	800X Bosworth St	10	Side Yard : Yard 17	Tree 1	DPW 2						6001905.0	2095492.0	37.733929718905394	-122.435815869962	(37.7339297189054, -122.435815869962)
1348	1348	251500	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	800X Bosworth St	12	Side Yard : Yard 17	Tree 1	DPW 2						6001905.0	2095492.0	37.733929718905394	-122.435815869962	(37.7339297189054, -122.435815869962)
2734	2734	253182	Significant Tree 6	Pinus pinea :: Italian Stone Pine 143	5157 Diamond Heights Blvd	1	Front Yard : Yard 7	Tree 1	Private 1						6000788.0	2100195.0	37.7467795353698	-122.44001478039101	(37.7467795353698, -122.440014780391)
2736	2736	253183	Significant Tree 6	Pinus pinea :: Italian Stone Pine 143	5159 Diamond Heights Blvd	1	Front Yard : Yard 7	Tree 1	Private 1						6000808.0	2099903.0	37.745978911495	-122.439924689335	(37.745978911495, -122.439924689335)
3390	3390	253422	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	2X Miraloma Dr	1	Side Yard : Cutout 18	Tree 1	DPW 2				10x10		5994995.0	2097925.0	37.740215196600396	-122.459881864698	(37.7402151966004, -122.459881864698)
3445	3445	16362	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1306X Montgomery St	14	Median : Cutout 11	Tree 1	DPW 2			18	8		6011452.97865	2119928.00722	37.801563196957204	-122.40452495315901	(37.8015631969572, -122.404524953159)
3804	3804	253558	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1240 Wisconsin St	1	Front Yard : Yard 7	Tree 1	Private 1						6012830.0	2101639.0	37.7514226163546	-122.39847574638901	(37.7514226163546, -122.398475746389)
4283	4283	253621	Significant Tree 6	Pinus pinea :: Italian Stone Pine 143	200x Montcalm St	1	Back Yard : Yard 13	Tree 1	Private 1				3x3		6010036.0	2099760.0	37.7461072494139	-122.40800527847799	(37.7461072494139, -122.408005278478)
5922	5922	20397	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	262X Sunset Blvd	42	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
6436	6436	20340	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	27	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40
6592	6592	98837	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1101X Portola Dr	9	Sidewalk: Property side : Yard 9	Tree 1	DPW 2
6719	6719	20066	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	100 STAIRWAY54	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	15ST
6953	6953	23580	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	3100X Van Ness Ave	3	Median : Cutout 11	Tree 1	DPW 2			24	9		6005507.77084	2121129.71298	37.8045287248816	-122.42518364411501	(37.8045287248816, -122.425183644115)
7348	7348	20335	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
7555	7555	107448	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1111x Chestnut St	1	Unaccepted Street : Yard 14	Tree 1	Private 1			50			6006408.68895	2120404.8626200003	37.80258932431129	-122.42201440535801	(37.8025893243113, -122.422014405358)
7578	7578	20324	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
7603	7603	23579	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	3100X Van Ness Ave	2	Median : Cutout 11	Tree 1	DPW 2			42	3x3		6005511.92719	2121098.1181099997	37.804442208310206	-122.425167011149	(37.8044422083102, -122.425167011149)
7875	7875	20330	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
8668	8668	107450	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1140x Chestnut St	1	Unaccepted Street : Yard 14	Tree 1	Private 1			60			6006380.05181	2120425.48408	37.802644330436394	-122.42211497023399	(37.8026443304364, -122.422114970234)
8763	8763	20326	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
9550	9550	20300	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	50X Sunset Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
9561	9561	20346	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	32	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	40
9596	9596	102839	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1101X Portola Dr	2	Sidewalk: Property side : Yard 9	Tree 1	DPW 2
9893	9893	173727	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	958 Carolina St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			9	3x3		6012430.0	2103470.0	37.7564278519739	-122.39998757117701	(37.7564278519739, -122.399987571177)
10103	10103	173844	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	2X Crestline Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5999319.0	2101169.0	37.7493701671822	-122.445164434644	(37.7493701671822, -122.445164434644)
10180	10180	20460	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	495X Sunset Blvd	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
13143	13143	20345	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	31	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	40
14567	14567	98839	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1101X Portola Dr	4	Sidewalk: Property side : Yard 9	Tree 1	DPW 2
16804	16804	19778	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	100 STAIRWAY18	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	50ST
16994	16994	20336	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
21066	21066	30050	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	900X Junipero Serra Blvd	1	Median : Cutout 11	Tree 1	DPW 2			3	3X3		5991182.4145599995	2091161.54655	37.7214244519661	-122.472571141372	(37.7214244519661, -122.472571141372)
22325	22325	21131	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	2292X Sunset Blvd	4	Median : Cutout 11	Tree 1	DPW 2			0	60		5984947.8628076	2099601.6268993	37.7442358239277	-122.49474388696001	(37.7442358239277, -122.49474388696)
22922	22922	251160	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1126x Portola Dr	1	Median : Cutout 11	Tree 1	DPW 2	Private 3			3x3		5994964.0	2098019.0	37.7404715144277	-122.459995857341	(37.7404715144277, -122.459995857341)
23412	23412	194471	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	84 Whitney Young Cir	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14			6016756.75905	2095047.7627400002	37.733542392957794	-122.38443738208001	(37.7335423929578, -122.38443738208)
23763	23763	194461	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	2000 25th St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27			6012563.257130001	2101880.94422	37.7520720792617	-122.399415164477	(37.7520720792617, -122.399415164477)
23919	23919	194457	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	2001 25th St	32	Sidewalk: Property side : Yard 9	Tree 1	Private 1			30			6012708.71911	2101842.22219	37.7519738634013	-122.398909414543	(37.7519738634013, -122.398909414543)
24477	24477	201741	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	727 Jamestown Ave	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 8ft		6015551.73985	2087509.47398	37.7127770280164	-122.388077638997	(37.7127770280164, -122.388077638997)
24492	24492	184737	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1301 Sunset Blvd	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5984694.2473	2106265.1087	37.76251705685429	-122.49611233651699	(37.7625170568543, -122.496112336517)
24643	24643	184784	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1301 Sunset Blvd	45	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984713.613	2105863.1758	37.7614145960538	-122.496015705201	(37.7614145960538, -122.496015705201)
25391	25391	132190	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1306x Montgomery St	44	Median : Yard 3	Tree 1	DPW 2			15	Width 8ft		6011409.46246	2120250.86119	37.802447243101	-122.40469828132	(37.802447243101, -122.40469828132)
25773	25773	186433	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1601 Sunset Blvd	21	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 0ft		5984738.4307	2104031.9087	37.7563879005336	-122.495794783817	(37.7563879005336, -122.495794783817)
26646	26646	107449	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1130x CHESTNUT ST	1	Unaccepted Street : Yard 14	Tree 1	Private 1			60			6006351.9	2120450.9	37.802712528214705	-122.42221419659701	(37.8027125282147, -122.422214196597)
26883	26883	194468	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1901 Quint St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 6ft		6012422.70585	2095229.76642	37.7338015236278	-122.39943431646401	(37.7338015236278, -122.399434316464)
27015	27015	201772	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	724 Jamestown Ave	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 8ft		6015630.59439	2087639.5462599997	37.7131385500726	-122.38781416009199	(37.7131385500726, -122.387814160092)
27156	27156	194439	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	900x Carolina St	32	Median : Yard 3	Tree 1	DPW 2			12			6012481.17054	2103301.60211	37.755968320994704	-122.3997987802	(37.7559683209947, -122.3997987802)
27691	27691	201795	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	724 Jamestown Ave	43	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24	Width 8ft		6015420.28917	2088209.0342599999	37.7146906018698	-122.388580780005	(37.7146906018698, -122.388580780005)
27755	27755	211070	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	500x Miramar Ave	7	Median : Yard 3	Tree 1	DPW 2			24			5995378.929819999	2093188.4321700002	37.7272318087773	-122.45821166894699	(37.7272318087773, -122.458211668947)
27943	27943	201789	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	724 Jamestown Ave	37	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 8ft		6015483.8795300005	2088094.9602400002	37.7143809005356	-122.388353026664	(37.7143809005356, -122.388353026664)
28201	28201	234514	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	998 York St	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 7ft		6009944.54234	2103430.26244	37.7561798559202	-122.408580392894	(37.7561798559202, -122.408580392894)
28806	28806	217820	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1x Junipero Serra Blvd	7	Median : Yard 3	Tree 1	DPW 2			3			5991627.31768	2095659.9754599999	37.733801760145504	-122.471360849935	(37.7338017601455, -122.471360849935)
29087	29087	194467	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1901 Quint St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 6ft		6012416.6749	2095223.9720599998	37.7337852773717	-122.399454760738	(37.7337852773717, -122.399454760738)
29459	29459	187394	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	2100 Sunset Blvd	47	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 0ft		5985039.81	2100667.7899	37.7471685994587	-122.494504537591	(37.7471685994587, -122.494504537591)
29553	29553	211075	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	650x Miramar Ave	6	Median : Yard 3	Tree 1	DPW 2			34			5995390.83549	2093912.64173	37.7292209976493	-122.458222905073	(37.7292209976493, -122.458222905073)
29585	29585	201739	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	727 Jamestown Ave	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 8ft		6015537.38953	2087630.70495	37.713109109879206	-122.38813569381901	(37.7131091098792, -122.388135693819)
30213	30213	194449	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1300x De Haro St	23	Median : Yard 3	Tree 1	DPW 2			23			6012259.687999999	2102130.23115	37.752739642445505	-122.40048246731399	(37.7527396424455, -122.400482467314)
30720	30720	201784	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	724 Jamestown Ave	32	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 8ft		6015541.73553	2087974.1397799999	37.714052356604704	-122.38814462500099	(37.7140523566047, -122.388144625001)
31124	31124	184781	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1301 Sunset Blvd	42	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984718.1696	2105899.6288	37.761514952666396	-122.496002635394	(37.7615149526664, -122.496002635394)
31179	31179	186593	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1501 Sunset Blvd	64	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984773.0801	2104494.2844	37.7576594849516	-122.495709060541	(37.7576594849516, -122.495709060541)
32049	32049	211072	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	602x Miramar Ave	2	Median : Yard 3	Tree 1	DPW 2			35			5995382.34021	2093429.0746900002	37.7278927511259	-122.45821728880699	(37.7278927511259, -122.458217288807)
32079	32079	211081	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	90 Melrose Ave	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 8ft		5999513.42858	2095531.7988099998	37.73390285471879	-122.44408709224899	(37.7339028547188, -122.444087092249)
32213	32213	234524	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	671 Church St	22	Front Yard : Yard 7	Tree 1	Private 1			11	Width 3ft		6004318.84944	2105025.5422900002	37.7602434426069	-122.4281496397	(37.7602434426069, -122.4281496397)
32941	32941	119052	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	539 44th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 4ft		5982216.76848	2112075.96454	37.7783265569214	-122.50511154623399	(37.7783265569214, -122.505111546234)
33579	33579	185295	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	2601 Sunset Blvd	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5984962.8666	2097355.3585	37.7380690548117	-122.49452644909701	(37.7380690548117, -122.494526449097)
33959	33959	201774	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	724 Jamestown Ave	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 8ft		6015625.88693	2087662.37118	37.713200962139794	-122.38783202245001	(37.7132009621398, -122.38783202245)
34118	34118	185363	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	2601 Sunset Blvd	88	Sidewalk: Property side : Yard 9	Tree 1	Private 1			43	Width 0ft		5984980.3483	2096870.9998	37.7367401586853	-122.49443031260901	(37.7367401586853, -122.494430312609)
34133	34133	211073	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	602x Miramar Ave	5	Median : Yard 3	Tree 1	DPW 2			26			5995385.83715	2093544.41078	37.7282096371561	-122.458213544022	(37.7282096371561, -122.458213544022)
34310	34310	12969	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	99X Lippard Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	3X4		6001957.7757889	2095598.483465	37.734225095766796	-122.43564102376301	(37.7342250957668, -122.435641023763)
34339	34339	194442	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	900x Carolina St	51	Median : Yard 3	Tree 1	DPW 2			24			6012500.2858	2102979.92319	37.7550861265451	-122.39971008726499	(37.7550861265451, -122.399710087265)
34594	34594	211059	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	2088 15th Ave	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			16	Width 6ft		5991648.13538	2101268.0455099996	37.749201292209996	-122.47169742662201	(37.74920129221, -122.471697426622)
35494	35494	201763	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	724 Jamestown Ave	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 8ft		6015661.0546	2087420.2073	37.7125379747236	-122.38769358441601	(37.7125379747236, -122.387693584416)
35598	35598	187095	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	2600 Sunset Blvd	31	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5985178.0339	2097175.5923	37.7375880557056	-122.49376927619801	(37.7375880557056, -122.493769276198)
36339	36339	194446	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1501 25th St	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			6014162.91853	2101954.38506	37.7523627617528	-122.393888395238	(37.7523627617528, -122.393888395238)
37436	37436	107492	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1306x Montgomery St	21	Median : Cutout 11	Tree 1	DPW 2			26			6011443.89272	2119983.46704	37.80171496831821	-122.404560301033	(37.8017149683182, -122.404560301033)
37534	37534	201742	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	727 Jamestown Ave	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 8ft		6015557.23057	2087482.7730299998	37.712704016543796	-122.388056798998	(37.7127040165438, -122.388056798998)
37786	37786	201746	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	727 Jamestown Ave	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 8ft		6015580.416230001	2087372.51377	37.7124025503214	-122.387968972099	(37.7124025503214, -122.387968972099)
38312	38312	201756	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	724 Jamestown Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 8ft		6015765.334969999	2087252.1296299999	37.7120822414633	-122.38732143863899	(37.7120822414633, -122.387321438639)
38837	38837	201733	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	727 Jamestown Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 8ft		6015510.4184	2087766.77172	37.7134812286504	-122.388238406274	(37.7134812286504, -122.388238406274)
39509	39509	194455	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1501 22nd St	11	Front Yard : Yard 7	Tree 1	Private 1			8			6013406.26386	2103790.51305	37.757362292666	-122.396633751156	(37.757362292666, -122.396633751156)
39924	39924	247143	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	500 27th St	13	Front Yard : Yard 7	Tree 1	Private 1			26			6003160.527980001	2100099.92491	37.746653258353604	-122.43180402765499	(37.7466532583536, -122.431804027655)
40120	40120	201738	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	727 Jamestown Ave	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 8ft		6015533.66415	2087659.5142599999	37.7131880082953	-122.38815057938601	(37.7131880082953, -122.388150579386)
40179	40179	194448	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1300x De Haro St	32	Median : Yard 3	Tree 1	DPW 2			27			6012284.461	2102001.80848	37.752388403216294	-122.400387777686	(37.7523884032163, -122.400387777686)
40566	40566	141265	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	52 JORDAN AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 0ft		5996227.2891	2114192.1724	37.7849514808139	-122.45679734575899	(37.7849514808139, -122.456797345759)
41624	41624	185204	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	2500 Sunset Blvd	57	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 0ft		5985139.3342	2097991.4603	37.739825946299895	-122.49396318779199	(37.7398259462999, -122.493963187792)
41772	41772	194456	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1501 22nd St	12	Front Yard : Yard 7	Tree 1	Private 1			2			6013384.43791	2103815.09856	37.757428584386794	-122.396710957944	(37.7574285843868, -122.396710957944)
42302	42302	247896	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	351 Mayflower St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			29	Width 5ft		6010145.43386	2098385.46575	37.7423392041921	-122.407529975731	(37.7423392041921, -122.407529975731)
42475	42475	186097	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1901 Sunset Blvd	43	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 0ft		5984866.2826	2101735.8043	37.7500909175156	-122.495183318527	(37.7500909175156, -122.495183318527)
42770	42770	201783	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	724 Jamestown Ave	31	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 8ft		6015549.05195	2087952.54872	37.71399347708579	-122.388117830599	(37.7139934770858, -122.388117830599)
43003	43003	186702	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1401 Sunset Blvd	59	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 0ft		5984718.4366	2105146.0279	37.759445790880704	-122.49594611618099	(37.7594457908807, -122.495946116181)
43082	43082	201788	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	724 Jamestown Ave	36	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 8ft		6015494.63123	2088072.87111	37.7143208438162	-122.388314323455	(37.7143208438162, -122.388314323455)
43272	43272	234521	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	5200x Diamond Heights Blvd	32	Median : Yard 3	Tree 1	DPW 2			30			6001544.419530001	2098938.9857400004	37.7433738490244	-122.437309239227	(37.7433738490244, -122.437309239227)
43614	43614	201769	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	724 Jamestown Ave	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 8ft		6015636.77799	2087561.79601	37.712925405365894	-122.387787365691	(37.7129254053659, -122.387787365691)
44453	44453	201779	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	724 Jamestown Ave	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 8ft		6015589.3271	2087835.5136400003	37.7136743526627	-122.387970461377	(37.7136743526627, -122.387970461377)
46160	46160	178178	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	769 Cayuga Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 8ft		6001369.37887	2092541.7115	37.725798463024	-122.43745647446	(37.725798463024, -122.43745647446)
46377	46377	132179	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1302 Columbus Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			33			6007259.6989400005	2121860.7667900003	37.806634826503604	-122.419172811197	(37.8066348265036, -122.419172811197)
47337	47337	132178	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	2449 Mason St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			36			6008741.74811	2122071.6365799997	37.807297172691	-122.41405880917101	(37.807297172691, -122.414058809171)
47813	47813	194447	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	680 De Haro St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1			6012074.2081699995	2105270.47212	37.761351707727	-122.401344555627	(37.761351707727, -122.401344555627)

Next page

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");