Street_Tree_List

Data source: data.sfgov.org

6,952 rows where qSpecies = 26 sorted by SiteOrder descending

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, PlantType, qCaretaker, qCareAssistant

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder ▲	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
1096	1096	211742	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	700 Junipero Serra Blvd	88	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		5991230.19236	2092152.91218	37.724149261961706	-122.472478226094	(37.7241492619617, -122.472478226094)
167584	167584	211741	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	700 Junipero Serra Blvd	86	: 4	Tree 1	Private 1			8	Width 0ft		5991245.41265	2092162.56077	37.7241766355394	-122.47242631541701	(37.7241766355394, -122.472426315417)
39110	39110	187384	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2200 Sunset Blvd	70	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5985074.9529	2100108.0339	37.7456337184099	-122.494341764001	(37.7456337184099, -122.494341764001)
184697	184697	187051	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2501 Sunset Blvd	70	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5984993.8369	2097637.9998	37.738846924542706	-122.49444020007799	(37.7388469245427, -122.494440200078)
152972	152972	187050	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2501 Sunset Blvd	69	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 0ft		5984995.182	2097644.0528	37.7388636231768	-122.494435995495	(37.7388636231768, -122.494435995495)
38711	38711	181507	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1400 Sunset Blvd	67	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5984877.2478	2105497.3399	37.7604196957107	-122.495422787092	(37.7604196957107, -122.495422787092)
25171	25171	211740	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	700 Junipero Serra Blvd	63	: 4	Tree 1	Private 1			9	Width 0ft		5991241.75535	2092369.0008200002	37.72474325697279	-122.47245400105601	(37.7247432569728, -122.472454001056)
60406	60406	194760	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	1700x Quesada Ave	55	Median : Yard 3	Tree 1	DPW 2			6			6014240.46002	2095410.02862	37.734397635636796	-122.393162357259	(37.7343976356368, -122.393162357259)
188858	188858	234104	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1100 San Jose Ave	46	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2			6004777.73384	2096671.97117	37.7373324202616	-122.425967914987	(37.7373324202616, -122.425967914987)
169764	169764	234103	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1100 San Jose Ave	45	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			6004778.8861	2096675.0661900002	37.737340983608604	-122.42596415134199	(37.7373409836086, -122.425964151342)
26044	26044	236017	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	310 Liberty St	44	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		6003872.48103	2103927.0660200003	37.757202022681106	-122.429615073291	(37.7572020226811, -122.429615073291)
56843	56843	194686	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1 Jack Balestreri Way	44	Front Yard : Yard 7	Tree 1	Private 1			4			6012432.36762	2104808.71902	37.760103812064706	-122.40007339538799	(37.7601038120647, -122.400073395388)
49120	49120	186894	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2700 Sunset Blvd	43	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5985197.9699	2096565.1913	37.73591322390129	-122.493655383708	(37.7359132239013, -122.493655383708)
73120	73120	194685	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1 Jack Balestreri Way	43	Front Yard : Yard 7	Tree 1	Private 1			3			6012432.71198	2104802.44836	37.7600866134166	-122.40007176402099	(37.7600866134166, -122.400071764021)
161046	161046	194758	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	750 Phelps St	43	: 4	Tree 1	Private 1			1	Width 2ft		6015105.7888400005	2097790.25184	37.740981275570995	-122.39033685465799	(37.740981275571, -122.390336854658)
163359	163359	194757	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	750 Phelps St	42	: 4	Tree 1	Private 1			1	Width 4ft		6015113.59484	2097804.3252	37.741020351115	-122.390310847178	(37.741020351115, -122.390310847178)
36478	36478	133192	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	1306x Montgomery St	41	Median : Yard 3	Tree 1	DPW 2			2	Width 8ft		6011420.83782	2120184.50099	37.8022656699768	-122.404654242423	(37.8022656699768, -122.404654242423)
164196	164196	185484	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2400 Sunset Blvd	37	unknown : Yard 19	Tree 1	Private 1			2	Width 0ft		5985117.0889	2098499.1184	37.741218537266796	-122.494077507295	(37.7412185372668, -122.494077507295)
167602	167602	185011	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2701 Sunset Blvd	37	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5985034.3637	2096468.1875	37.7356373047826	-122.49421387938601	(37.7356373047826, -122.494213879386)
180177	180177	211656	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	200x Terrace Dr	37	Median : Yard 3	Tree 1	DPW 2			15			5993885.28493	2096476.0493	37.7361728559925	-122.463613650077	(37.7361728559925, -122.463613650077)
49760	49760	185704	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2101 Sunset Blvd	36	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984910.4508	2100497.5253	37.7466935274926	-122.49493929257099	(37.7466935274926, -122.494939292571)
72764	72764	185007	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2701 Sunset Blvd	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5985036.4573	2096492.0548	37.7357029605314	-122.49420839974199	(37.7357029605314, -122.494208399742)
52819	52819	187247	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2401 Sunset Blvd	30	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984940.8963	2098476.306	37.7411455892764	-122.494685028149	(37.7411455892764, -122.494685028149)
68908	68908	194663	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	900x Carolina St	29	Median : Yard 3	Tree 1	DPW 2			10			6012487.04658	2103373.70419	37.7561666251126	-122.39978352139099	(37.7561666251126, -122.399783521391)
1887	1887	20008	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	100 STAIRWAY46	28	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	2
31877	31877	194684	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1 Jack Balestreri Way	28	Front Yard : Yard 7	Tree 1	Private 1			9			6012406.88691	2104790.52602	37.7600524373766	-122.40016024382099	(37.7600524373766, -122.400160243821)
132791	132791	187166	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2301 Sunset Blvd	28	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5984954.0932	2099317.2472	37.7434553590095	-122.494701382193	(37.7434553590095, -122.494701382193)
170191	170191	249696	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2400 Baker St	28	Front Yard : Yard 7	Tree 1	Private 1			4			5999680.27614	2117316.2653799998	37.7937270855963	-122.44507583208599	(37.7937270855963, -122.445075832086)
8166	8166	20381	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	262X Sunset Blvd	27	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
14114	14114	20007	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	100 STAIRWAY46	27	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	2
148136	148136	194683	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1 Jack Balestreri Way	27	Front Yard : Yard 7	Tree 1	Private 1			12			6012398.62743	2104785.66422	37.7600386274099	-122.400188468119	(37.7600386274099, -122.400188468119)
158406	158406	187165	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2301 Sunset Blvd	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 0ft		5984939.6487	2099318.7286	37.7434585810539	-122.49475143609199	(37.7434585810539, -122.494751436092)
178798	178798	181394	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1500 Sunset Blvd	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984907.5602	2104576.4752	37.7578930325113	-122.495250041349	(37.7578930325113, -122.495250041349)
188577	188577	249695	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2400 Baker St	27	Front Yard : Yard 7	Tree 1	Private 1			9			5999678.04202	2117322.75965	37.7937447896309	-122.445084029412	(37.7937447896309, -122.445084029412)
2790	2790	20006	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	100 STAIRWAY46	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	2
55454	55454	185000	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2701 Sunset Blvd	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5985034.7824	2096510.0599	37.7357522997185	-122.494215517122	(37.7357522997185, -122.494215517122)
12819	12819	20005	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	100 STAIRWAY46	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	2
44339	44339	184999	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2701 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5985036.0386	2096516.3408	37.7357696189035	-122.494211636814	(37.7357696189035, -122.494211636814)
55731	55731	181392	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1500 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984896.9779	2104568.1208	37.7578694740705	-122.49528602274201	(37.7578694740705, -122.495286022742)
108032	108032	30389	Permitted Site 1	Pittosporum undulatum :: Victorian Box 26	2800 Turk St	25	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/09/1956 12:00:00 AM			Permit Number 66	5997681.665837	2111673.48633421	37.778119232070395	-122.451583952943	(37.7781192320704, -122.451583952943)
169373	169373	249693	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2400 Baker St	25	Front Yard : Yard 7	Tree 1	Private 1			7			5999669.5395599995	2117354.78581	37.7938322397096	-122.445115752098	(37.7938322397096, -122.445115752098)
171235	171235	249889	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	230 Greenwich St	25	Back Yard : Yard 13	Tree 1	Private 1			8	Width 0ft		6011472.47528	2120454.19881	37.8030090801563	-122.404494546207	(37.8030090801563, -122.404494546207)
173954	173954	132823	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2610 Clay St	25	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 5ft		6001425.50464	2115988.95485	37.790182091188704	-122.43894203486299	(37.7901820911887, -122.438942034863)
68032	68032	132822	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2610 Clay St	24	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 5ft		6001457.36982	2115991.89351	37.790191972931105	-122.438831994697	(37.7901919729311, -122.438831994697)
142444	142444	30387	Permitted Site 1	Pittosporum undulatum :: Victorian Box 26	2800 Turk St	24	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/09/1956 12:00:00 AM			Permit Number 66	5997681.665837	2111673.48633421	37.778119232070395	-122.451583952943	(37.7781192320704, -122.451583952943)
4453	4453	253083	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	2849X Alemany Blvd	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/13/2017 10:53:00 AM	3	3X3		5997618.33471	2088040.74004	37.7132258706419	-122.45009922742399	(37.7132258706419, -122.450099227424)
42193	42193	132753	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	3500 Fillmore St	23	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6002230.1298	2120424.54043	37.80240680148761	-122.43647570078699	(37.8024068014876, -122.436475700787)
86904	86904	30388	Permitted Site 1	Pittosporum undulatum :: Victorian Box 26	2800 Turk St	23	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/09/1956 12:00:00 AM			Permit Number 66	5997681.665837	2111673.48633421	37.778119232070395	-122.451583952943	(37.7781192320704, -122.451583952943)
110884	110884	24285	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	300X Winding Way	23	Median : Cutout 11	Tree 1	DPW 2			12	8		6001646.2933309	2086550.8578367	37.7093646550959	-122.436070699117	(37.7093646550959, -122.436070699117)
139113	139113	110889	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	800 INDIANA ST	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6014913.4	2104437.2	37.7592217202179	-122.391466645187	(37.7592217202179, -122.391466645187)
27043	27043	194682	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1 Jack Balestreri Way	22	Front Yard : Yard 7	Tree 1	Private 1			8			6012380.91774	2104784.0825900002	37.760033297111704	-122.400249606728	(37.7600332971117, -122.400249606728)
62237	62237	236016	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	310 Liberty St	22	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		6004056.71191	2103936.43848	37.757238187119704	-122.428978599706	(37.7572381871197, -122.428978599706)
82370	82370	30390	Permitted Site 1	Pittosporum undulatum :: Victorian Box 26	2800 Turk St	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/09/1956 12:00:00 AM			Permit Number 66	5997681.665837	2111673.48633421	37.778119232070395	-122.451583952943	(37.7781192320704, -122.451583952943)
114857	114857	110888	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	800 INDIANA ST	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6014913.4	2104437.2	37.7592217202179	-122.391466645187	(37.7592217202179, -122.391466645187)
153288	153288	132752	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	3500 Fillmore St	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6002231.24522	2120405.80468	37.802355421436204	-122.43647049913099	(37.8023554214362, -122.436470499131)
1845	1845	98642	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	3500X Fillmore St	21	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		10	3x3		6002233.86885	2120387.2869599997	37.8023047257379	-122.436460093962	(37.8023047257379, -122.436460093962)
7669	7669	19837	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	100 STAIRWAY25	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60X
66075	66075	185169	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2500 Sunset Blvd	21	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5985175.8564	2097713.8919	37.739065954832604	-122.493816461854	(37.7390659548326, -122.493816461854)
102092	102092	30391	Permitted Site 1	Pittosporum undulatum :: Victorian Box 26	2800 Turk St	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/09/1956 12:00:00 AM			Permit Number 66	5997681.665837	2111673.48633421	37.778119232070395	-122.451583952943	(37.7781192320704, -122.451583952943)
110451	110451	110887	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	800 INDIANA ST	21	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6014913.4	2104437.2	37.7592217202179	-122.391466645187	(37.7592217202179, -122.391466645187)
159100	159100	194639	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	500 Wisconsin St	21	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 5ft		6012635.61435	2104974.52119	37.7605703983333	-122.39938209731301	(37.7605703983333, -122.399382097313)
6303	6303	98641	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	3500X Fillmore St	20	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		10	3x3		6002235.030730001	2120370.79549	37.802259510526596	-122.436454892273	(37.8022595105266, -122.436454892273)
44574	44574	49689	Permitted Site 1	Pittosporum undulatum :: Victorian Box 26	2235 NOTES) Hayes St	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/21/2003 12:00:00 AM			Permit Number 46511	5997175.15188937	2109805.23760487	37.7729604879505	-122.453201252207	(37.7729604879505, -122.453201252207)
64286	64286	133037	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	24 Priest St	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 10ft		6008318.1553	2117218.21348	37.7939470849357	-122.415180970642	(37.7939470849357, -122.415180970642)
98969	98969	30406	Permitted Site 1	Pittosporum undulatum :: Victorian Box 26	2800 Turk St	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/09/1956 12:00:00 AM			Permit Number 66	5997681.665837	2111673.48633421	37.778119232070395	-122.451583952943	(37.7781192320704, -122.451583952943)
119645	119645	48509	Permitted Site 1	Pittosporum undulatum :: Victorian Box 26	1(REVISED) Church St	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/22/2002 12:00:00 AM			Permit Number 45844	6004110.55275805	2108703.1215343	37.7703294028669	-122.42913226260099	(37.7703294028669, -122.429132262601)
6270	6270	98640	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	3500X Fillmore St	19	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		5	3x3		6002237.13778	2120351.54005	37.8022067598879	-122.43644622191002	(37.8022067598879, -122.43644622191)
68822	68822	194638	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	500 Wisconsin St	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 5ft		6012635.62036	2104984.41211	37.760597556952796	-122.399382770909	(37.7605975569528, -122.399382770909)
76691	76691	194627	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	131 Shipley St	19	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 2ft		6011962.485719999	2112191.44343	37.7803488895184	-122.402217568898	(37.7803488895184, -122.402217568898)
80544	80544	30393	Permitted Site 1	Pittosporum undulatum :: Victorian Box 26	2800 Turk St	19	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/09/1956 12:00:00 AM			Permit Number 66	5997681.665837	2111673.48633421	37.778119232070395	-122.451583952943	(37.7781192320704, -122.451583952943)
159219	159219	194825	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	502 Beale St	19	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 6ft		6015880.685	2113956.19903	37.785412439566	-122.388785810138	(37.785412439566, -122.388785810138)
5958	5958	98639	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	3500X Fillmore St	18	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		6	3x3		6002240.752780001	2120332.50299	37.8021546945469	-122.436432348976	(37.8021546945469, -122.436432348976)
27163	27163	194824	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	502 Beale St	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 6ft		6015871.5156	2113965.50811	37.785437491981	-122.38881818391701	(37.785437491981, -122.388818183917)
79274	79274	30385	Permitted Site 1	Pittosporum undulatum :: Victorian Box 26	2800 Turk St	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/09/1956 12:00:00 AM			Permit Number 66	5997681.665837	2111673.48633421	37.778119232070395	-122.451583952943	(37.7781192320704, -122.451583952943)
81293	81293	97871	Permitted Site 1	Pittosporum undulatum :: Victorian Box 26	895 Indiana St	18	Sidewalk: Property side : Cutout 5	Tree 1	Private 1						6014975.4	2104402.3	37.7591293333254	-122.391249777978	(37.7591293333254, -122.391249777978)
108841	108841	48508	Permitted Site 1	Pittosporum undulatum :: Victorian Box 26	1(REVISED) Church St	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/22/2002 12:00:00 AM			Permit Number 45844	6004110.55275805	2108703.1215343	37.7703294028669	-122.42913226260099	(37.7703294028669, -122.429132262601)
131406	131406	246712	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1 Bonview St	18	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			6007754.64499	2099212.81872	37.7444768180465	-122.41585519326999	(37.7444768180465, -122.41585519327)
136214	136214	194626	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	131 Shipley St	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		6011979.997769999	2112201.07056	37.7803763008647	-122.402157663244	(37.7803763008647, -122.402157663244)
146562	146562	195003	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	11 Dedman Ct	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6016650.3646599995	2096329.60482	37.737056190782496	-122.38489449311301	(37.7370561907825, -122.384894493113)
4581	4581	142526	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	301 FRANCISCO ST	17	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4			10	Width 0ft		6009810.3798	2121222.957	37.8050268727325	-122.410300597206	(37.8050268727325, -122.410300597206)
29046	29046	194625	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	131 Shipley St	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 2ft		6011983.78945	2112208.25417	37.7803962370307	-122.402145051162	(37.7803962370307, -122.402145051162)
30157	30157	194823	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	502 Beale St	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 6ft		6015860.261580001	2113977.77101	37.7854705393653	-122.388857976238	(37.7854705393653, -122.388857976238)
62390	62390	133156	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	99 North Point St	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6010460.75882	2121992.28603	37.8071756949569	-122.408104165883	(37.8071756949569, -122.408104165883)
80335	80335	98579	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	301X Francisco St	17	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2			3x3		6009861.3	2121227.6	37.805042475469605	-122.410124709263	(37.8050424754696, -122.410124709263)
84267	84267	30392	Permitted Site 1	Pittosporum undulatum :: Victorian Box 26	2800 Turk St	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/09/1956 12:00:00 AM			Permit Number 66	5997681.665837	2111673.48633421	37.778119232070395	-122.451583952943	(37.7781192320704, -122.451583952943)
101750	101750	98638	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	3500X Fillmore St	17	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		10	3x3		6002513.0	2120207.2	37.8018261113234	-122.435481274987	(37.8018261113234, -122.435481274987)
101895	101895	97870	Permitted Site 1	Pittosporum undulatum :: Victorian Box 26	895 Indiana St	17	Sidewalk: Property side : Cutout 5	Tree 1	Private 1						6014975.4	2104402.3	37.7591293333254	-122.391249777978	(37.7591293333254, -122.391249777978)
105479	105479	113740	Significant Tree 6	Pittosporum undulatum :: Victorian Box 26	1580 Valencia St	17	Front Yard : Yard 7	Tree 1	Private 1						6006496.0	2100402.0	37.747671200831	-122.420291724307	(37.747671200831, -122.420291724307)
143636	143636	110883	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	800 INDIANA ST	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6014913.4	2104437.2	37.7592217202179	-122.391466645187	(37.7592217202179, -122.391466645187)
150800	150800	194681	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1 Jack Balestreri Way	17	Front Yard : Yard 7	Tree 1	Private 1			4			6012405.53198	2104761.19385	37.759971822165	-122.400162869837	(37.759971822165, -122.400162869837)
155023	155023	133036	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	24 Priest St	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 10ft		6008330.07907	2117167.86524	37.7938095111605	-122.415136147535	(37.7938095111605, -122.415136147535)
166223	166223	186868	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2700 Sunset Blvd	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5985166.3388	2096363.9443	37.73535880277029	-122.493749918136	(37.7353588027703, -122.493749918136)
179144	179144	195002	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	11 Dedman Ct	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6016680.46739	2096324.02955	37.737042547164	-122.384790025147	(37.737042547164, -122.384790025147)
181092	181092	98760	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1500X North Point St	17	Sidewalk: Property side : Cutout 5	Tree 1	Private 1			19	3x3		6003175.67956	2121043.58403	37.8041602168919	-122.433247894574	(37.8041602168919, -122.433247894574)
183690	183690	249685	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2400 Baker St	17	Front Yard : Yard 7	Tree 1	Private 1			12			5999728.9564	2117260.57889	37.793576963545796	-122.444903389791	(37.7935769635458, -122.444903389791)
4583	4583	142550	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	301 FRANCISCO ST	16	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4		03/26/2016 09:53:00 AM	22	Width 0ft		6009784.6811	2121219.3711	37.805015586162796	-122.41038927752199	(37.8050155861628, -122.410389277522)
5471	5471	98637	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	3500X Fillmore St	16	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		5	3x3		6002243.51572	2120296.51697	37.8020560434066	-122.43642021082898	(37.8020560434066, -122.436420210829)
18888	18888	451	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	740X 23rd Ave	16	Median : Cutout 11	Tree 1	DPW 2			12	8-HOA		5988823.24796	2110191.1107400004	37.7735377655293	-122.482119432452	(37.7735377655293, -122.482119432452)
33457	33457	194624	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	131 Shipley St	16	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		6011995.8908400005	2112220.7140599997	37.7804311244474	-122.402104062771	(37.7804311244474, -122.402104062771)
62557	62557	178451	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	300x Mansell St	16	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6010787.10356	2090456.90218	37.720604933939704	-122.404753211896	(37.7206049339397, -122.404753211896)

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");