Street_Tree_List

Data source: data.sfgov.org

155 rows where qSiteInfo = 9 and qSpecies = 41 sorted by Longitude

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

- 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, 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
151281	151281	117924	Undocumented 2	Olea europaea :: Olive Tree 41	611 41st Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 6ft		5983159.66185	2111615.2579900003	37.7771170231905	-122.501815685868	(37.7771170231905, -122.501815685868)
53554	53554	185769	Undocumented 2	Olea europaea :: Olive Tree 41	2162 42nd Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5983287.4484	2100417.9653	37.7463799348929	-122.500545498316	(37.7463799348929, -122.500545498316)
130267	130267	184018	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984912.6418	2103753.8138	37.7556345299307	-122.495171803184	(37.7556345299307, -122.495171803184)
133852	133852	184026	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984920.3345	2103785.5463	37.7557221089671	-122.495147539697	(37.7557221089671, -122.495147539697)
173503	173503	184034	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	34	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984925.6803	2103804.9468	37.7557756903402	-122.49513048303801	(37.7557756903402, -122.495130483038)
147099	147099	184031	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	31	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984927.2534	2103793.0767	37.755743190427204	-122.495124167563	(37.7557431904272, -122.495124167563)
167786	167786	184036	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	36	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984928.8265	2103810.0952	37.7557900106144	-122.49511998225799	(37.7557900106144, -122.495119982258)
39133	39133	184025	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984931.5337	2103784.5063	37.7557199090675	-122.495108733182	(37.7557199090675, -122.495108733182)
137954	137954	184027	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984931.8298	2103786.2121	37.7557246100571	-122.495107834969	(37.7557246100571, -122.495107834969)
59223	59223	184039	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	39	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984935.4051	2103815.5297	37.755805317385004	-122.4950976324	(37.755805317385, -122.4950976324)
76965	76965	184009	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984939.2377	2103728.7585	37.755567292052795	-122.495077980088	(37.7555672920528, -122.495077980088)
147236	147236	184010	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984951.0048	2103730.9648	37.755574038818104	-122.49503744907301	(37.7555740388181, -122.495037449073)
168303	168303	187200	Undocumented 2	Olea europaea :: Olive Tree 41	2301 Sunset Blvd	62	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5984910.7598	2099021.3208	37.7426402887161	-122.49482940193998	(37.7426402887161, -122.49482940194)
185004	185004	186299	Undocumented 2	Olea europaea :: Olive Tree 41	1800 Sunset Blvd	37	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5985021.1385	2102711.497	37.7527789669048	-122.49471975093701	(37.7527789669048, -122.494719750937)
76535	76535	187242	Undocumented 2	Olea europaea :: Olive Tree 41	2401 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984947.0235	2098562.0875	37.7413814807711	-122.494670165431	(37.7413814807711, -122.494670165431)
179104	179104	187244	Undocumented 2	Olea europaea :: Olive Tree 41	2401 Sunset Blvd	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984957.2356	2098537.5785	37.7413147833906	-122.494633049632	(37.7413147833906, -122.494633049632)
156868	156868	185356	Undocumented 2	Olea europaea :: Olive Tree 41	2601 Sunset Blvd	81	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5985014.265	2096945.9513	37.736947940348294	-122.49431857261001	(37.7369479403483, -122.49431857261)
45237	45237	185266	Undocumented 2	Olea europaea :: Olive Tree 41	2301 Vicente St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 0ft		5985748.3724	2097496.5905	37.7385027823228	-122.491820997516	(37.7385027823228, -122.491820997516)
187985	187985	177913	Undocumented 2	Olea europaea :: Olive Tree 41	2924 21st Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 8ft		5990007.1003	2095790.68963	37.7340668092368	-122.476971913545	(37.7340668092368, -122.476971913545)
67404	67404	177922	Undocumented 2	Olea europaea :: Olive Tree 41	0 Cambon Dr	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 5ft		5990625.846609999	2089245.25322	37.7161305522573	-122.474355255986	(37.7161305522573, -122.474355255986)
72659	72659	177921	Undocumented 2	Olea europaea :: Olive Tree 41	0 Cambon Dr	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 5ft		5990636.51581	2089256.00468	37.7161606912434	-122.47431916261499	(37.7161606912434, -122.474319162615)
60762	60762	210584	Undocumented 2	Olea europaea :: Olive Tree 41	2090 17th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 5ft		5991019.92015	2101200.62469	37.7489798053925	-122.47386486469101	(37.7489798053925, -122.473864864691)
133187	133187	210586	Undocumented 2	Olea europaea :: Olive Tree 41	1677 16th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 5ft		5991138.28819	2103959.4374700002	37.7565616379133	-122.47365677234	(37.7565616379133, -122.47365677234)
131401	131401	210585	Undocumented 2	Olea europaea :: Olive Tree 41	1677 16th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 5ft		5991143.28102	2103974.0449900003	37.756602035466706	-122.47364057105499	(37.7566020354667, -122.473640571055)
52452	52452	210730	Undocumented 2	Olea europaea :: Olive Tree 41	599 Arch St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 10ft		5992718.10768	2091174.58463	37.721549022462	-122.467263668211	(37.721549022462, -122.467263668211)
46191	46191	210732	Undocumented 2	Olea europaea :: Olive Tree 41	486 Arch St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 8ft		5992756.333330001	2090404.7555	37.719437465534	-122.46707559208201	(37.719437465534, -122.467075592082)
182313	182313	210832	Undocumented 2	Olea europaea :: Olive Tree 41	100 El Verano Way	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 3ft		5994491.87078	2094685.88565	37.731292439379395	-122.461386713728	(37.7312924393794, -122.461386713728)
66805	66805	210831	Undocumented 2	Olea europaea :: Olive Tree 41	100 El Verano Way	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		5994495.152530001	2094669.90963	37.7312487620154	-122.461374210478	(37.7312487620154, -122.461374210478)
64446	64446	210702	Undocumented 2	Olea europaea :: Olive Tree 41	495 Faxon Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 3ft		5994735.30528	2091846.72997	37.7235108134601	-122.46033948738199	(37.7235108134601, -122.460339487382)
84812	84812	96294	Permitted Site 1	Olea europaea :: Olive Tree 41	417 Dewey Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1		04/25/2011 12:00:00 AM		3x3	Permit Number 57003	5995136.0	2100316.9	37.7467908665237	-122.45956754031602	(37.7467908665237, -122.459567540316)
25936	25936	210838	Undocumented 2	Olea europaea :: Olive Tree 41	459 Hazelwood Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		5995438.73644	2095838.0782299999	37.7345105311276	-122.458196607982	(37.7345105311276, -122.458196607982)
169278	169278	124176	Undocumented 2	Olea europaea :: Olive Tree 41	11 Almaden Ct	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 9ft		5995826.0985199995	2112588.51087	37.7805252097548	-122.45806922812099	(37.7805252097548, -122.458069228121)
47979	47979	131824	Undocumented 2	Olea europaea :: Olive Tree 41	599 Spruce St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			5997098.15866	2113893.82945	37.784182276729204	-122.45376288107501	(37.7841822767292, -122.453762881075)
165406	165406	210867	Undocumented 2	Olea europaea :: Olive Tree 41	774 Joost Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 6ft		5996972.318969999	2095027.1901599998	37.7323720296365	-122.452836023577	(37.7323720296365, -122.452836023577)
160671	160671	210864	Undocumented 2	Olea europaea :: Olive Tree 41	585 Mangels Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			5997550.306419999	2095241.3957900002	37.732993291202796	-122.45085323608299	(37.7329932912028, -122.450853236083)
189009	189009	210872	Undocumented 2	Olea europaea :: Olive Tree 41	371 Staples Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 8ft		5997627.30354	2093781.8331900002	37.72899008680061	-122.450481853864	(37.7289900868006, -122.450481853864)
189127	189127	131863	Undocumented 2	Olea europaea :: Olive Tree 41	3640 Lyon St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 5ft		5998876.58216	2121318.22377	37.8046694831589	-122.448144966435	(37.8046694831589, -122.448144966435)
74510	74510	131861	Undocumented 2	Olea europaea :: Olive Tree 41	3640 Lyon St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 9ft		5998876.901959999	2121298.6839099997	37.8046158502946	-122.448142451919	(37.8046158502946, -122.448142451919)
30412	30412	131862	Undocumented 2	Olea europaea :: Olive Tree 41	3640 Lyon St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 7ft		5998877.1278	2121309.5311	37.8046456466411	-122.448142451907	(37.8046456466411, -122.448142451907)
76839	76839	210860	Undocumented 2	Olea europaea :: Olive Tree 41	458 Mangels Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 9ft		5998392.85645	2095276.6341799998	37.7331382439186	-122.447942868994	(37.7331382439186, -122.447942868994)
160376	160376	131864	Undocumented 2	Olea europaea :: Olive Tree 41	801 Marina Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5			5999091.87418	2121434.80116	37.80500187798479	-122.447408326338	(37.8050018779848, -122.447408326338)
68441	68441	131840	Undocumented 2	Olea europaea :: Olive Tree 41	3100 Lyon St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25	Width 10ft		5999063.8869199995	2119477.76228	37.79962677850121	-122.447364232598	(37.7996267785012, -122.447364232598)
34368	34368	131798	Undocumented 2	Olea europaea :: Olive Tree 41	3550 Baker St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 5ft		5999217.12066	2121060.49219	37.8039812832582	-122.446947946285	(37.8039812832582, -122.446947946285)
165957	165957	210839	Undocumented 2	Olea europaea :: Olive Tree 41	44 Molimo Dr	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		5998761.631469999	2096521.8618	37.7365784160531	-122.44675748696599	(37.7365784160531, -122.446757486966)
158328	158328	131846	Undocumented 2	Olea europaea :: Olive Tree 41	3265 Baker St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 8ft		5999287.02532	2120101.46569	37.801352048703706	-122.44663699491899	(37.8013520487037, -122.446636994919)
73130	73130	131832	Undocumented 2	Olea europaea :: Olive Tree 41	2325 Lyon St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21			5999253.705019999	2116932.2658599997	37.7926483685714	-122.446524160568	(37.7926483685714, -122.446524160568)
56677	56677	131833	Undocumented 2	Olea europaea :: Olive Tree 41	2325 Lyon St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24			5999254.62224	2116910.03669	37.7925873855434	-122.44651938697399	(37.7925873855434, -122.446519386974)
174406	174406	131834	Undocumented 2	Olea europaea :: Olive Tree 41	2325 Lyon St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24			5999256.96111	2116889.83912	37.79253206195229	-122.446509840679	(37.7925320619523, -122.446509840679)
176763	176763	131835	Undocumented 2	Olea europaea :: Olive Tree 41	2325 Lyon St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			30			5999258.4917	2116863.93405	37.7924610209078	-122.446502680257	(37.7924610209078, -122.446502680257)
179303	179303	131836	Undocumented 2	Olea europaea :: Olive Tree 41	2325 Lyon St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25			5999261.40107	2116837.9999700002	37.792389978960294	-122.446490747163	(37.7923899789603, -122.446490747163)
53000	53000	131837	Undocumented 2	Olea europaea :: Olive Tree 41	2325 Lyon St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25			5999265.5562	2116805.62915	37.792301334578795	-122.446474040467	(37.7923013345788, -122.446474040467)
166980	166980	131838	Undocumented 2	Olea europaea :: Olive Tree 41	2325 Lyon St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			26			5999266.73194	2116784.7686099997	37.7922441242069	-122.446468470962	(37.7922441242069, -122.446468470962)
39000	39000	131839	Undocumented 2	Olea europaea :: Olive Tree 41	2325 Lyon St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			22			5999268.60171	2116764.1225799997	37.7921875424622	-122.44646051556002	(37.7921875424622, -122.44646051556)
60366	60366	131908	Undocumented 2	Olea europaea :: Olive Tree 41	2300 Lyon St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 5ft		5999329.15646	2116759.94991	37.7921795438926	-122.446250695616	(37.7921795438926, -122.446250695616)
53099	53099	131907	Undocumented 2	Olea europaea :: Olive Tree 41	2300 Lyon St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 5ft		5999331.1857	2116735.12189	37.7921114886004	-122.446241887658	(37.7921114886004, -122.446241887658)
41116	41116	131906	Undocumented 2	Olea europaea :: Olive Tree 41	2300 Lyon St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 5ft		5999332.61261	2116722.13595	37.7920759141309	-122.446236016002	(37.7920759141309, -122.446236016002)
52217	52217	131905	Undocumented 2	Olea europaea :: Olive Tree 41	2300 Lyon St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 5ft		5999332.9847099995	2116712.83345	37.7920503931741	-122.446234059074	(37.7920503931741, -122.446234059074)
130315	130315	131904	Undocumented 2	Olea europaea :: Olive Tree 41	2300 Lyon St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 5ft		5999334.39992	2116699.28439	37.792013271856796	-122.446228187384	(37.7920132718568, -122.446228187384)
48342	48342	232992	Undocumented 2	Olea europaea :: Olive Tree 41	1001 Ashbury St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 4ft		5999171.207330001	2106627.37895	37.764349091448395	-122.446068061312	(37.7643490914484, -122.446068061312)
132478	132478	210873	Undocumented 2	Olea europaea :: Olive Tree 41	62 Marston Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 8ft		5998923.839269999	2093227.89544	37.7275432251404	-122.445959824297	(37.7275432251404, -122.445959824297)
40992	40992	131854	Undocumented 2	Olea europaea :: Olive Tree 41	2561 Chestnut St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 5ft		5999582.7736599995	2119421.9193599997	37.7995030857465	-122.44556468468299	(37.7995030857465, -122.445564684683)
46748	46748	131855	Undocumented 2	Olea europaea :: Olive Tree 41	2561 Chestnut St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 5ft		5999583.43559	2119428.0305	37.799519903091394	-122.445562833863	(37.7995199030914, -122.445562833863)
171012	171012	210859	Undocumented 2	Olea europaea :: Olive Tree 41	300 Mangels Ave	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			5999336.203480001	2095262.51223	37.7331533453405	-122.444680462235	(37.7331533453405, -122.444680462235)
44923	44923	210863	Undocumented 2	Olea europaea :: Olive Tree 41	412 Joost Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 6ft		5999336.30619	2094992.2158	37.7324111807223	-122.44466068613501	(37.7324111807223, -122.444660686135)
186177	186177	210858	Undocumented 2	Olea europaea :: Olive Tree 41	300 Mangels Ave	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2			5999351.90422	2095271.3522	37.7331785137649	-122.444626815895	(37.7331785137649, -122.444626815895)
35405	35405	210862	Undocumented 2	Olea europaea :: Olive Tree 41	412 Joost Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 6ft		5999352.48487	2094990.83835	37.7324083217769	-122.444604653878	(37.7324083217769, -122.444604653878)
185499	185499	210857	Undocumented 2	Olea europaea :: Olive Tree 41	300 Mangels Ave	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2			5999360.350819999	2095260.17688	37.7331483109495	-122.444596810892	(37.7331483109495, -122.444596810892)
116414	116414	98290	Significant Tree 6	Olea europaea :: Olive Tree 41	300 Mangels Ave	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1		01/24/2012 12:00:00 AM			Permit Number 768637	5999381.8	2095276.6	37.7331946288913	-122.444523835506	(37.7331946288913, -122.444523835506)
119061	119061	98288	Significant Tree 6	Olea europaea :: Olive Tree 41	300 Mangels Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1		01/24/2012 12:00:00 AM			Permit Number 768637	5999381.8	2095276.6	37.7331946288913	-122.444523835506	(37.7331946288913, -122.444523835506)
127682	127682	98289	Significant Tree 6	Olea europaea :: Olive Tree 41	300 Mangels Ave	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1		01/24/2012 12:00:00 AM			Permit Number 768637	5999381.8	2095276.6	37.7331946288913	-122.444523835506	(37.7331946288913, -122.444523835506)
65146	65146	210687	Undocumented 2	Olea europaea :: Olive Tree 41	270 Hearst Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 8ft		5999611.40538	2094395.78433	37.7307892138454	-122.443666775201	(37.7307892138454, -122.443666775201)
178262	178262	210869	Undocumented 2	Olea europaea :: Olive Tree 41	158 Flood Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1			5999679.41111	2094102.69585	37.7299883396845	-122.44341062492799	(37.7299883396845, -122.443410624928)
164265	164265	247239	Undocumented 2	Olea europaea :: Olive Tree 41	923 Buena Vista Ave West	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 1ft		6000025.84088	2108639.91315	37.7699237738831	-122.443256690652	(37.7699237738831, -122.443256690652)
135922	135922	233785	Undocumented 2	Olea europaea :: Olive Tree 41	54 Lower Ter	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 3ft		6000482.28178	2106206.41652	37.763268014640104	-122.441503224013	(37.7632680146401, -122.441503224013)
55633	55633	233784	Undocumented 2	Olea europaea :: Olive Tree 41	54 Lower Ter	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 3ft		6000491.33203	2106195.44998	37.7632384188315	-122.44147113529101	(37.7632384188315, -122.441471135291)
132103	132103	210868	Undocumented 2	Olea europaea :: Olive Tree 41	21 Flood Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 2ft		6000252.08808	2094037.4276299998	37.7298417699638	-122.441426135001	(37.7298417699638, -122.441426135001)
129801	129801	233780	Undocumented 2	Olea europaea :: Olive Tree 41	10 Saturn St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 3ft		6000618.75311	2106039.2097	37.7628166799724	-122.44101921967501	(37.7628166799724, -122.441019219675)
33801	33801	233782	Undocumented 2	Olea europaea :: Olive Tree 41	10 Saturn St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 3ft		6000620.83206	2106027.61812	37.762784970763896	-122.441011197703	(37.7627849707639, -122.441011197703)
30422	30422	233781	Undocumented 2	Olea europaea :: Olive Tree 41	10 Saturn St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 3ft		6000622.86001	2106032.19557	37.762797654817604	-122.44100451216299	(37.7627976548176, -122.441004512163)
51108	51108	233783	Undocumented 2	Olea europaea :: Olive Tree 41	10 Saturn St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 3ft		6000623.49703	2106025.6379400003	37.7627796854658	-122.441001838469	(37.7627796854658, -122.441001838469)
60421	60421	233779	Undocumented 2	Olea europaea :: Olive Tree 41	10 Saturn St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 3ft		6000624.58928	2106041.01354	37.762821965281	-122.44099916388001	(37.762821965281, -122.44099916388)
151730	151730	131873	Undocumented 2	Olea europaea :: Olive Tree 41	435 Marina Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2			6001088.519780001	2121715.49846	37.8058864916338	-122.44051886926901	(37.8058864916338, -122.440518869269)
25290	25290	233726	Undocumented 2	Olea europaea :: Olive Tree 41	84 Seward St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 3ft		6000741.8111	2104532.41656	37.7586864040831	-122.44048553140699	(37.7586864040831, -122.440485531407)
178519	178519	131813	Undocumented 2	Olea europaea :: Olive Tree 41	145 Capra Way	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 8ft		6001082.26232	2120520.90623	37.802606103860995	-122.440454793478	(37.802606103861, -122.440454793478)
28137	28137	131814	Undocumented 2	Olea europaea :: Olive Tree 41	145 Capra Way	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 8ft		6001091.88484	2120522.1645299997	37.802610106719996	-122.440421585107	(37.80261010672, -122.440421585107)
69915	69915	210852	Undocumented 2	Olea europaea :: Olive Tree 41	330 Baden St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 6ft		6000786.85539	2095109.56492	37.732816061802	-122.439654219669	(37.732816061802, -122.439654219669)
151109	151109	131816	Undocumented 2	Olea europaea :: Olive Tree 41	149 Alhambra St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 6ft		6001591.27048	2120267.97849	37.8019406010393	-122.43867523929801	(37.8019406010393, -122.438675239298)
150016	150016	233072	Undocumented 2	Olea europaea :: Olive Tree 41	4379 Cesar Chavez St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6001415.52367	2100255.5837	37.7469815873239	-122.43784920748399	(37.7469815873239, -122.437849207484)
64945	64945	233073	Undocumented 2	Olea europaea :: Olive Tree 41	4379 Cesar Chavez St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			6001415.66952	2100249.72902	37.746965520055795	-122.43784828388	(37.7469655200558, -122.43784828388)
70968	70968	233063	Undocumented 2	Olea europaea :: Olive Tree 41	1407 Douglass St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 10ft		6001406.76989	2099594.91194	37.745167041419	-122.437832165315	(37.745167041419, -122.437832165315)
166266	166266	233074	Undocumented 2	Olea europaea :: Olive Tree 41	4379 Cesar Chavez St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6001421.11934	2100254.93591	37.7469801268377	-122.437829811798	(37.7469801268377, -122.437829811798)
70603	70603	233075	Undocumented 2	Olea europaea :: Olive Tree 41	4379 Cesar Chavez St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5			6001421.5597	2100250.4049	37.7469677107999	-122.437827964602	(37.7469677107999, -122.437827964602)
29269	29269	233076	Undocumented 2	Olea europaea :: Olive Tree 41	4379 Cesar Chavez St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6001425.33603	2100252.18871	37.7469728234536	-122.437815034154	(37.7469728234536, -122.437815034154)
62762	62762	233077	Undocumented 2	Olea europaea :: Olive Tree 41	4379 Cesar Chavez St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			6001428.84563	2100253.97771	37.74697793518929	-122.437803026403	(37.7469779351893, -122.437803026403)
34890	34890	233078	Undocumented 2	Olea europaea :: Olive Tree 41	4379 Cesar Chavez St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6			6001429.57501	2100250.5048599998	37.7469684410418	-122.437800255583	(37.7469684410418, -122.437800255583)
157877	157877	210853	Undocumented 2	Olea europaea :: Olive Tree 41	179 Hamerton Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 5ft		6001331.13679	2095231.8134599999	37.733182692031896	-122.43778125741501	(37.7331826920319, -122.437781257415)
186754	186754	233079	Undocumented 2	Olea europaea :: Olive Tree 41	4379 Cesar Chavez St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6001435.52575	2100254.1053299997	37.7469786654515	-122.437779936321	(37.7469786654515, -122.437779936321)
66050	66050	210866	Undocumented 2	Olea europaea :: Olive Tree 41	110 Monterey Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 6ft		6001326.245569999	2094696.7194700001	37.7317131692257	-122.437759857137	(37.7317131692257, -122.437759857137)
149795	149795	131874	Undocumented 2	Olea europaea :: Olive Tree 41	295 Marina Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 7ft		6002038.91196	2121849.60525	37.806308784479796	-122.43723950400299	(37.8063087844798, -122.437239504003)
57370	57370	177965	Undocumented 2	Olea europaea :: Olive Tree 41	1703 San Jose Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8			6001599.27369	2094156.6391200002	37.7302457535263	-122.43677729835699	(37.7302457535263, -122.436777298357)

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