Street_Tree_List

Data source: data.sfgov.org

171 rows where qSpecies = 4 sorted by qAddress

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, SiteOrder, qSiteInfo, PlantType, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
45848	45848	129548	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1 Saroyan Pl	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 4ft		6011012.0164	2118485.6729900003	37.7975782452004	-122.405949226574	(37.7975782452004, -122.405949226574)
170716	170716	218286	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1 Woodacre Dr	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4			5991335.90639	2095594.8050900002	37.7336059570417	-122.472363586812	(37.7336059570417, -122.472363586812)
188033	188033	226640	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	10 Crescent Ave	2	Side Yard : Yard 17	Tree 1	Private 1			4	Width 3ft		6005282.96903	2095902.7994400002	37.7352489878562	-122.42416639485799	(37.7352489878562, -122.424166394858)
63854	63854	129545	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	10 Miller Pl	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		6010092.54789	2116944.91924	37.7932962437837	-122.409022077819	(37.7932962437837, -122.409022077819)
48397	48397	35353	Permitted Site 1	Ligustrum japonicum :: Japanese Privet 4	1023 Kansas St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/25/2013 12:00:00 AM	1		Permit Number 770231	6011656.23225	2103580.2473299997	37.7566873964196	-122.40267130024999	(37.7566873964196, -122.40267130025)
66967	66967	129530	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1040 Greenwich St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 5ft		6007879.71026	2119961.12323	37.8014537818135	-122.416892463243	(37.8014537818135, -122.416892463243)
130118	130118	121971	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	106 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 2ft		5991185.189040001	2114684.00966	37.7860111230721	-122.474277122949	(37.7860111230721, -122.474277122949)
36005	36005	59609	Permitted Site 1	Ligustrum japonicum :: Japanese Privet 4	1063 Tennessee St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/26/1981 12:00:00 AM	5		Permit Number 19011	6015560.85054	2104166.3389	37.7585139078159	-122.389208516653	(37.7585139078159, -122.389208516653)
75729	75729	129524	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1109 Chestnut St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6006507.139280001	2120407.78108	37.802602889666794	-122.421673924708	(37.8026028896668, -122.421673924708)
134337	134337	129525	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1109 Chestnut St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6006520.95763	2120409.72682	37.8026090113668	-122.42162624447799	(37.8026090113668, -122.421626244478)
150809	150809	129523	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1109 Chestnut St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6006484.20699	2120406.53709	37.802598180831396	-122.42175319366001	(37.8025981808314, -122.42175319366)
49924	49924	226657	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	117 Laidley St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6003659.76941	2097669.44697	37.740008014859995	-122.42990436449	(37.74000801486, -122.42990436449)
166827	166827	226658	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	117 Laidley St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6003646.084869999	2097679.68219	37.7400353434466	-122.429952409889	(37.7400353434466, -122.429952409889)
37851	37851	226637	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1199 Capp St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 9ft		6007225.3101699995	2100622.72822	37.7483183396245	-122.417785447755	(37.7483183396245, -122.417785447755)
47963	47963	191430	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	12 Augusta St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 2ft		6011384.738480001	2095507.87401	37.7345072405216	-122.403042454946	(37.7345072405216, -122.403042454946)
45994	45994	226656	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	121 Moffitt St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 2ft		6002727.925340001	2096681.4535	37.737242397212704	-122.43305572295401	(37.7372423972127, -122.433055722954)
27158	27158	226650	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1210 Shrader St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5997776.79189	2106261.7686099997	37.7632654911199	-122.450864566663	(37.7632654911199, -122.450864566663)
134630	134630	226651	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1210 Shrader St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5997784.115230001	2106211.6118400004	37.7631281925414	-122.450835621062	(37.7631281925414, -122.450835621062)
150604	150604	177029	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	123 Seneca Ave	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 0ft		6000050.7624699995	2090072.63848	37.7189438978236	-122.441837691751	(37.7189438978236, -122.441837691751)
187883	187883	129522	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1240 Lombard St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 2ft		6006403.02216	2120103.20622	37.8017607330441	-122.422012573438	(37.8017607330441, -122.422012573438)
73133	73133	177037	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	125 Goettingen St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 2ft		6009971.552	2093934.84647	37.7301090233129	-122.407817447612	(37.7301090233129, -122.407817447612)
166596	166596	207366	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1263 17th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 2ft		5990777.74909	2106795.52344	37.7643278872345	-122.475110663153	(37.7643278872345, -122.475110663153)
48699	48699	129547	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	13 Miller Pl	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 1ft		6010075.14286	2116919.1763	37.7932245849005	-122.40908048339399	(37.7932245849005, -122.409080483394)
55659	55659	129546	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	13 Miller Pl	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 1ft		6010072.19276	2116933.78445	37.7932645300763	-122.40909172222099	(37.7932645300763, -122.409091722221)
6651	6651	16365	DPW Maintained 3	Ligustrum japonicum :: Japanese Privet 4	1306X Montgomery St	18	Median : Cutout 11	Tree 1	DPW 2			18	8		6011450.07983	2119965.49195	37.8016659588815	-122.40453762461901	(37.8016659588815, -122.404537624619)
164863	164863	129537	DPW Maintained 3	Ligustrum japonicum :: Japanese Privet 4	1306x Montgomery St	22	Median : Yard 3	Tree 1	DPW 2			1	Width 8ft		6011446.5417	2119990.51434	37.801734466528	-122.404551630663	(37.801734466528, -122.404551630663)
44640	44640	58940	Permitted Site 1	Ligustrum japonicum :: Japanese Privet 4	1360 Rhode Island St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	04/30/2005 12:00:00 AM	2		Permit Number 18218	6011963.90217	2102042.40825	37.7524820001659	-122.40149918233801	(37.7524820001659, -122.401499182338)
65210	65210	226642	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	14 Cumberland St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 2ft		6005484.04077	2104618.2918599998	37.759191085608	-122.42409082483101	(37.759191085608, -122.424090824831)
24975	24975	129535	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1420 Montgomery St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		6011436.62121	2120241.6491	37.802423466843294	-122.404603649235	(37.8024234668433, -122.404603649235)
18417	18417	10231	DPW Maintained 3	Ligustrum japonicum :: Japanese Privet 4	1440 Guerrero St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			26	2x2		6005821.60814	2100602.13393	37.748182698482296	-122.42263795659599	(37.7481826984823, -122.422637956596)
69137	69137	129536	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1440 Montgomery St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 4ft		6011432.08366	2120273.70789	37.8025112388511	-122.40462160961599	(37.8025112388511, -122.404621609616)
35358	35358	226639	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	145 Coso Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12			6007521.18601	2099614.94215	37.745567831493396	-122.416690930545	(37.7455678314934, -122.416690930545)
67745	67745	226648	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1488 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 6ft		6005200.770269999	2099715.54685	37.7457132878504	-122.42472173433701	(37.7457132878504, -122.424721734337)
31372	31372	177035	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	15 Merrill St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 2ft		6009505.01631	2094936.0613	37.732832016669605	-122.409500962316	(37.7328320166696, -122.409500962316)
178665	178665	177036	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	15 Merrill St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 2ft		6009502.62349	2094943.7258099997	37.7328529276995	-122.409509775682	(37.7328529276995, -122.409509775682)
17611	17611	5710	DPW Maintained 3	Ligustrum japonicum :: Japanese Privet 4	1609 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			60	3x3		6005330.55919	2098925.54374	37.743551448937396	-122.4242167677	(37.7435514489374, -122.4242167677)
58518	58518	42618	Permitted Site 1	Ligustrum japonicum :: Japanese Privet 4	1615 Greenwich St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/26/2000 12:00:00 AM	11		Permit Number 42680	6005139.94855	2119525.3007400003	37.800102635872506	-122.426342225416	(37.8001026358725, -122.426342225416)
93337	93337	15295	DPW Maintained 3	Ligustrum japonicum :: Japanese Privet 4	1625 Mission St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/02/1995 12:00:00 AM	3	3X3		6006990.727390001	2109176.21889	37.771791036290296	-122.41920328508002	(37.7717910362903, -122.41920328508)
174209	174209	191427	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1627 20th St	1	: 4	Tree 1	Private 1			4	Width 3ft		6013091.09687	2104712.62895	37.7598766756903	-122.39778840962099	(37.7598766756903, -122.397788409621)
170102	170102	207365	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1678 17th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5990916.62821	2103981.8612	37.756610367702706	-122.47442498042601	(37.7566103677027, -122.474424980426)
47627	47627	191426	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1700 22nd St	5	Front Yard : Yard 7	Tree 1	Private 1			6			6012934.525830001	2103813.36642	37.7573987772601	-122.39826682196001	(37.7573987772601, -122.39826682196)
25862	25862	129509	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1714 Filbert St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6004669.814259999	2119159.95033	37.7990728914709	-122.42794302317499	(37.7990728914709, -122.427943023175)
58879	58879	129507	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1714 Filbert St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6004691.67913	2119164.8681	37.7990876313419	-122.42786771393	(37.7990876313419, -122.42786771393)
130785	130785	129508	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1714 Filbert St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6004680.4249	2119161.32221	37.7990772585711	-122.427906404578	(37.7990772585711, -122.427906404578)
66325	66325	249500	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1765 California St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			1	Width 3ft		6005972.54693	2115883.04317	37.7901489421804	-122.42320206534401	(37.7901489421804, -122.423202065344)
133672	133672	249499	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1765 California St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			1	Width 3ft		6005919.33859	2115875.5653	37.7901254069127	-122.423385630445	(37.7901254069127, -122.423385630445)
159256	159256	249501	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	1765 California St	7	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			1	Width 3ft		6006000.97948	2115886.86804	37.790161048840794	-122.42310396280001	(37.7901610488408, -122.4231039628)
1872	1872	177039	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	178 Seville St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 2ft		6001177.23506	2087434.66895	37.711764745717	-122.437755094333	(37.711764745717, -122.437755094333)
64620	64620	207367	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2 Lurline St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5992094.1475599995	2104940.13578	37.7593096900047	-122.47042251889401	(37.7593096900047, -122.470422518894)
37818	37818	226638	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	201 Coso Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 2ft		6007716.3532	2099510.6976099997	37.74529257420679	-122.41600868956301	(37.7452925742068, -122.416008689563)
134626	134626	129532	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2135 Stockton St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6009758.75399	2121832.78165	37.8066984049805	-122.410522343935	(37.8066984049805, -122.410522343935)
134435	134435	226653	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	214 Corbett Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5999974.10738	2105629.30684	37.7616544501161	-122.443219374174	(37.7616544501161, -122.443219374174)
33785	33785	129500	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2144 Green St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6002804.8844800005	2118207.36125	37.7963516481611	-122.434328161126	(37.7963516481611, -122.434328161126)
37549	37549	129499	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2144 Green St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6002813.515269999	2118209.0658299997	37.7963568183789	-122.43429841873501	(37.7963568183789, -122.434298418735)
180697	180697	129556	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	216 Post St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			1	Width 3ft		6011025.30596	2115257.2463	37.7887145046082	-122.405675728365	(37.7887145046082, -122.405675728365)
182512	182512	129555	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	216 Post St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			1	Width 3ft		6011031.64459	2115258.30549	37.7887177673445	-122.40565387214599	(37.7887177673445, -122.405653872146)
64468	64468	191428	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	22 Robblee Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 5ft		6012599.814780001	2095974.63355	37.735856643564404	-122.39887425376001	(37.7358566435644, -122.39887425376)
45735	45735	226654	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	220 Corbett Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		5999922.0088	2105601.51229	37.761575162283705	-122.443397564951	(37.7615751622837, -122.443397564951)
47134	47134	129521	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2222 Bay St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6000122.02291	2120260.78291	37.8018371520253	-122.443758994388	(37.8018371520253, -122.443758994388)
2580	2580	27387	DPW Maintained 3	Ligustrum japonicum :: Japanese Privet 4	2222 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	3X3		6007153.30759	2119954.57165	37.8013949068162	-122.419405682544	(37.8013949068162, -122.419405682544)
7273	7273	27386	DPW Maintained 3	Ligustrum japonicum :: Japanese Privet 4	2222 Hyde St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	3X3		6007153.462830001	2119942.0708	37.8013605913839	-122.419404257997	(37.8013605913839, -122.419404257997)
5632	5632	27388	Permitted Site 1	Ligustrum japonicum :: Japanese Privet 4	2238 Hyde St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			35	3X3		6007145.97631	2119998.36118	37.8015147288815	-122.41943416045099	(37.8015147288815, -122.419434160451)
56461	56461	120189	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	224 26th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5987764.6245099995	2114428.11322	37.785109748738996	-122.486092406972	(37.785109748739, -122.486092406972)
165011	165011	120188	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	224 26th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5987762.7194300005	2114453.05727	37.785178126956396	-122.486100829584	(37.7851781269564, -122.486100829584)
147024	147024	226652	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	225 Corbett Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 2ft		5999964.01354	2105579.20426	37.7615163052595	-122.443250685888	(37.7615163052595, -122.443250685888)
5084	5084	27391	DPW Maintained 3	Ligustrum japonicum :: Japanese Privet 4	2250 Hyde St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6007137.4365300005	2120063.48315	37.8016930563562	-122.419468334714	(37.8016930563562, -122.419468334714)
5160	5160	27393	DPW Maintained 3	Ligustrum japonicum :: Japanese Privet 4	2256 Hyde St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3X3		6007130.3947	2120101.3253099998	37.8017965647292	-122.41949538901899	(37.8017965647292, -122.419495389019)
32499	32499	72076	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	229 19th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/14/1984 12:00:00 AM	14			5989910.70009	2113826.30511	37.7835821901674	-122.478623713066	(37.7835821901674, -122.478623713066)
52039	52039	226655	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	232 Corbett Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 2ft		5999888.11878	2105582.8714799997	37.761522046538204	-122.44351343721901	(37.7615220465382, -122.443513437219)
156654	156654	177030	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	235 Ottawa Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 4ft		5998356.41955	2089266.50528	37.7166337499183	-122.447636347658	(37.7166337499183, -122.447636347658)
133137	133137	191429	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2399 Lane St	7	Side Yard : Yard 17	Tree 1	Private 1			4			6013991.75526	2092879.9064599997	37.7274366158882	-122.393845172923	(37.7274366158882, -122.393845172923)
50062	50062	75146	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	240 07th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/10/1994 12:00:00 AM	5			6010085.43601	2111100.02376	37.7772471547732	-122.408634170555	(37.7772471547732, -122.408634170555)
60497	60497	75390	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	240 07th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/10/1994 12:00:00 AM	5			6010035.62368	2111155.67227	37.77739716259529	-122.40881041516501	(37.7773971625953, -122.408810415165)
75992	75992	75228	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	240 07th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/10/1994 12:00:00 AM	5			6010065.6483	2111120.54922	37.7773024046157	-122.408704071262	(37.7773024046157, -122.408704071262)
172460	172460	75304	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	240 07th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/10/1994 12:00:00 AM	2			6010043.764880001	2111144.47071	37.7773668617363	-122.408781461497	(37.7773668617363, -122.408781461497)
21862	21862	9988	DPW Maintained 3	Ligustrum japonicum :: Japanese Privet 4	25 Guerrero St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	2X2		6005434.589869999	2108720.51419	37.7704520212643	-122.424553652838	(37.7704520212643, -122.424553652838)
35462	35462	129513	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	25 Heather Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 2ft		5997331.52493	2114270.89109	37.785230964483105	-122.45298274796998	(37.7852309644831, -122.45298274797)
27531	27531	129510	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2500 Chestnut St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 2ft		5999790.44594	2119530.29467	37.799812509208	-122.444853861425	(37.799812509208, -122.444853861425)
48051	48051	177031	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	263 Maynard St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			12	Width 2ft		6005122.72167	2093818.5342400002	37.729517010390204	-122.42457221572901	(37.7295170103902, -122.424572215729)
158427	158427	129506	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2644 Filbert St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6000302.575	2118552.44748	37.7971568138825	-122.443011447325	(37.7971568138825, -122.443011447325)
182054	182054	129505	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2644 Filbert St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6000286.7796	2118548.8617700003	37.7971460678835	-122.44306584551501	(37.7971460678835, -122.443065845515)
70389	70389	129503	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2656 Filbert St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6000257.59997	2118546.4747099997	37.797137849879896	-122.44316664242099	(37.7971378498799, -122.443166642421)
167962	167962	129504	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2656 Filbert St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6000274.51269	2118548.1954799998	37.7971435390014	-122.44310824405399	(37.7971435390014, -122.443108244054)
59600	59600	129529	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2677 Larkin St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 2ft		6006561.352969999	2120334.1919299997	37.802403889494	-122.421481088503	(37.802403889494, -122.421481088503)
76500	76500	129528	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2677 Larkin St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 2ft		6006558.18826	2120353.46017	37.802456616741	-122.4214934092	(37.802456616741, -122.4214934092)
157440	157440	129527	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2677 Larkin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 2ft		6006554.47344	2120382.0459	37.802534896425	-122.421508295689	(37.802534896425, -122.421508295689)
186226	186226	129526	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2677 Larkin St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 2ft		6006553.85688	2120395.35345	37.8025714008062	-122.421511374958	(37.8025714008062, -122.421511374958)
92559	92559	92776	Permitted Site 1	Ligustrum japonicum :: Japanese Privet 4	2701 Pacific Ave		Sidewalk: Property side : Cutout 5	Landscaping 2	Private 1		10/15/2009 12:00:00 AM			Permit Number 52996	6001178.5	2116864.5	37.7925720539586	-122.43985945141	(37.7925720539586, -122.43985945141)
109480	109480	92778	Permitted Site 1	Ligustrum japonicum :: Japanese Privet 4	2701 Pacific Ave		Sidewalk: Property side : Cutout 5	Landscaping 2	Private 1		10/15/2009 12:00:00 AM			Permit Number 52996	6001178.5	2116864.5	37.7925720539586	-122.43985945141	(37.7925720539586, -122.43985945141)
42723	42723	129514	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2730 Lyon St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		5999183.84789	2118189.54872	37.796096542872206	-122.446856379121	(37.7960965428722, -122.446856379121)
131107	131107	129515	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2730 Lyon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		5999181.629430001	2118207.9413900003	37.7961469175038	-122.44686537955	(37.7961469175038, -122.44686537955)
17581	17581	9989	DPW Maintained 3	Ligustrum japonicum :: Japanese Privet 4	28 Guerrero St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	2X2		6005374.8666900005	2108638.02007	37.7702221392707	-122.424754366229	(37.7702221392707, -122.424754366229)
49684	49684	129501	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2857 Union St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 1ft		5999309.06977	2118008.46724	37.795606494203604	-122.446410054597	(37.7956064942036, -122.446410054597)
161992	161992	129502	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	2857 Union St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 1ft		5999324.2861	2118011.40576	37.7956154316639	-122.44635761511499	(37.7956154316639, -122.446357615115)
135694	135694	129558	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	300 California St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 3ft		6012591.8685800005	2116885.11843	37.793271734566005	-122.400370000791	(37.793271734566, -122.400370000791)
161411	161411	129557	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	300 California St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 3ft		6012628.75569	2116888.8810400004	37.7932841227067	-122.40024263249201	(37.7932841227067, -122.400242632492)
47655	47655	129519	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	3041 Divisadero St	3	: 4	Tree 1	Private 1			3	Width 2ft		6000446.25144	2118762.17983	37.79774087408789	-122.442529358545	(37.7977408740879, -122.442529358545)
160826	160826	129520	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	3041 Divisadero St	4	: 4	Tree 1	Private 1			2	Width 2ft		6000447.31564	2118755.2398900003	37.7977218795107	-122.442525177605	(37.7977218795107, -122.442525177605)
165862	165862	129518	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	3041 Divisadero St	2	: 4	Tree 1	Private 1			3	Width 2ft		6000446.00148	2118771.96061	37.797767715271796	-122.44253092607	(37.7977677152718, -122.44253092607)
34884	34884	129516	Undocumented 2	Ligustrum japonicum :: Japanese Privet 4	3047 Divisadero St	2	: 4	Tree 1	Private 1			3	Width 3ft		6000442.909	2118797.59081	37.797837912738295	-122.44254346802	(37.7978379127383, -122.44254346802)

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