Street_Tree_List

Data source: data.sfgov.org

630 rows where qSiteInfo = 2 and qSpecies = 54 sorted by Latitude

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, PlantType, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude ▼	Longitude	Location
74439	74439	187452	Undocumented 2	:: 54	5098 Mission St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6000296.2838	2089278.8073	37.7167782039769	-122.440932105905	(37.7167782039769, -122.440932105905)
147303	147303	187451	Undocumented 2	:: 54	5098 Mission St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6000310.9137	2089292.2181	37.7168158602419	-122.440882499178	(37.7168158602419, -122.440882499178)
33211	33211	200211	Undocumented 2	:: 54	974 Jamestown Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6014078.3317	2089599.8969999999	37.7184351760665	-122.39331644356001	(37.7184351760665, -122.39331644356)
54871	54871	200168	Undocumented 2	:: 54	1101 Gilman Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6014990.039	2089901.3883	37.7193136223873	-122.390186075408	(37.7193136223873, -122.390186075408)
176452	176452	200497	Undocumented 2	:: 54	1110 Gilman Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6014977.2953	2089975.1673	37.7195154981888	-122.39023527774799	(37.7195154981888, -122.390235277748)
80892	80892	104890	Undocumented 2	:: 54	150 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1					empty	5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
178876	178876	200201	Undocumented 2	:: 54	1090 Ingerson Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6013694.5474	2090234.3998	37.7201560648851	-122.394687445541	(37.7201560648851, -122.394687445541)
177939	177939	200226	Undocumented 2	:: 54	1131 Fitzgerald Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6015013.4132	2090222.9153	37.720197768832605	-122.390127728915	(37.7201977688326, -122.390127728915)
183672	183672	200636	Undocumented 2	:: 54	1301 Quesada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6016782.3625	2093458.8747	37.729181036936396	-122.384238246013	(37.7291810369364, -122.384238246013)
36680	36680	200762	Undocumented 2	:: 54	1999 Lane St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6014632.1803	2093750.8421	37.7298635995705	-122.39169207228201	(37.7298635995705, -122.391692072282)
158995	158995	200766	Undocumented 2	:: 54	1901 Lane St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6014720.1223	2093871.3227	37.7301992962685	-122.39139646330901	(37.7301992962685, -122.391396463309)
154317	154317	200577	Undocumented 2	:: 54	1701 Keith St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6015592.5071	2093926.7262	37.7303998031535	-122.38838435336201	(37.7303998031535, -122.388384353362)
129662	129662	200808	Undocumented 2	:: 54	1401 Oakdale Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6016065.8568	2094678.3259	37.732489764259896	-122.386800296411	(37.7324897642599, -122.386800296411)
183233	183233	186926	Undocumented 2	:: 54	2800 Sunset Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985157.2666	2096011.7096	37.734391129301	-122.493755335707	(37.734391129301, -122.493755335707)
33122	33122	185071	Undocumented 2	:: 54	2800 37th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984981.8139	2096034.5991	37.7344437114318	-122.49436361071899	(37.7344437114318, -122.494363610719)
58562	58562	185072	Undocumented 2	:: 54	2801 Sunset Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985073.9331	2096042.9736	37.73447209618271	-122.494045746017	(37.7344720961827, -122.494045746017)
174948	174948	200699	Undocumented 2	:: 54	1501 Lane St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6015860.7307	2095472.4329	37.734658863200295	-122.38756485421699	(37.7346588632003, -122.387564854217)
151546	151546	182946	Undocumented 2	:: 54	3500 Wawona St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982068.7362	2096751.2664	37.7362405734928	-122.504487984804	(37.7362405734928, -122.504487984804)
154543	154543	182944	Undocumented 2	:: 54	2678 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981851.131	2096866.8374	37.7365450979685	-122.50524888568701	(37.7365450979685, -122.505248885687)
147162	147162	182943	Undocumented 2	:: 54	2674 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981850.1157	2096894.2496	37.7366203046104	-122.505254426993	(37.7366203046104, -122.505254426993)
137654	137654	182938	Undocumented 2	:: 54	2657 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981803.7519	2096965.6566	37.7368136403966	-122.505420015001	(37.7368136403966, -122.505420015001)
35754	35754	182933	Undocumented 2	:: 54	2646 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981845.0394	2097064.8142	37.7370883295038	-122.505284615423	(37.7370883295038, -122.505284615423)
48113	48113	185273	Undocumented 2	:: 54	2601 Sunset Blvd	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985037.6088	2097007.6084	37.7371186003252	-122.494242407159	(37.7371186003252, -122.494242407159)
181678	181678	182929	Undocumented 2	:: 54	2635 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981797.6603	2097141.2975	37.737295543609996	-122.50545409100799	(37.73729554361, -122.505454091008)
67752	67752	185275	Undocumented 2	:: 54	2600 37th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984941.5117	2097207.3396	37.7376613847371	-122.494589373511	(37.7376613847371, -122.494589373511)
40189	40189	183398	Undocumented 2	:: 54	2676 23rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989291.1458	2097146.7716	37.7377487006662	-122.479546347444	(37.7377487006662, -122.479546347444)
34204	34204	183601	Undocumented 2	:: 54	2647 22nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989550.5846	2097326.397	37.7382569723881	-122.47866248497401	(37.7382569723881, -122.478662484974)
41764	41764	183600	Undocumented 2	:: 54	2639 22nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989549.7171	2097348.9516	37.738318851123	-122.47866713334	(37.738318851123, -122.47866713334)
51779	51779	183592	Undocumented 2	:: 54	2626 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988353.2202	2097405.0036	37.738403211903204	-122.482808088928	(37.7384032119032, -122.482808088928)
171810	171810	183571	Undocumented 2	:: 54	1950 Vicente St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986841.6497	2097598.0157	37.7388451080573	-122.48804847269699	(37.7388451080573, -122.488048472697)
69546	69546	183561	Undocumented 2	:: 54	1842 Vicente St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987180.92	2097610.4334	37.7388989899745	-122.486876361154	(37.7388989899745, -122.486876361154)
176431	176431	183053	Undocumented 2	:: 54	2601 19th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5990456.6898	2097547.4037	37.738916368412106	-122.47554578609	(37.7389163684121, -122.47554578609)
151024	151024	185250	Undocumented 2	:: 54	2582 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986168.5104	2097675.5504	37.7390187057813	-122.49038154463301	(37.7390187057813, -122.490381544633)
181628	181628	183542	Undocumented 2	:: 54	2598 27th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988033.5951	2097670.443	37.7391134369583	-122.483932641735	(37.7391134369583, -122.483932641735)
167902	167902	185253	Undocumented 2	:: 54	2566 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985543.2782	2097747.3201	37.739179229362705	-122.4925485642	(37.7391792293627, -122.4925485642)
69138	69138	185252	Undocumented 2	:: 54	2567 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986119.691000001	2097773.7197	37.7392854011049	-122.49055755796302	(37.7392854011049, -122.490557557963)
157360	157360	185251	Undocumented 2	:: 54	2566 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986166.3878	2097773.7197	37.7392881285851	-122.490396103482	(37.7392881285851, -122.490396103482)
51477	51477	183544	Undocumented 2	:: 54	2575 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987672.5493	2097766.1311	37.739355145969206	-122.48518797755	(37.7393551459692, -122.48518797755)
67201	67201	185245	Undocumented 2	:: 54	2562 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986166.3878	2097803.4358	37.73936972108589	-122.49039828899599	(37.7393697210859, -122.490398288996)
72168	72168	182979	Undocumented 2	:: 54	800 Vicente St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5990295.2626	2097717.7991	37.739374871061294	-122.47611636270099	(37.7393748710613, -122.476116362701)
148201	148201	183536	Undocumented 2	:: 54	2576 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988338.1627	2097791.2913	37.7394629808799	-122.48288845238899	(37.7394629808799, -122.482888452389)
132675	132675	183534	Undocumented 2	:: 54	2575 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988292.8495	2097803.675	37.739494346597795	-122.483046031116	(37.7394943465978, -122.483046031116)
153506	153506	185241	Undocumented 2	:: 54	2551 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985807.672	2097858.4902	37.73949992809371	-122.49164260379601	(37.7394999280937, -122.491642603796)
131751	131751	185242	Undocumented 2	:: 54	2554 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986164.2652	2097852.2551	37.7395036419136	-122.490409218419	(37.7395036419136, -122.490409218419)
133418	133418	185243	Undocumented 2	:: 54	2555 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986116.5072	2097857.5616	37.7395154226653	-122.490574732795	(37.7395154226653, -122.490574732795)
76561	76561	183521	Undocumented 2	:: 54	2567 25th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988601.5425	2097854.7918	37.739652658082	-122.481982461654	(37.739652658082, -122.481982461654)
172095	172095	183010	Undocumented 2	:: 54	2500 37th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984919.7169	2097961.3416	37.7397303960744	-122.494720300824	(37.7397303960744, -122.494720300824)
155656	155656	183518	Undocumented 2	:: 54	2547 29th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987357.881	2097941.2897	37.73981774986029	-122.486288802943	(37.7398177498603, -122.486288802943)
171329	171329	185237	Undocumented 2	:: 54	2534 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986160.02	2097977.4873	37.7398472482312	-122.490433106843	(37.7398472482312, -122.490433106843)
55794	55794	183502	Undocumented 2	:: 54	2535 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987043.8814	2097999.1529	37.739958320304495	-122.48737871628	(37.7399583203045, -122.48737871628)
68931	68931	183511	Undocumented 2	:: 54	2546 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988332.8152	2097971.981	37.7399587963622	-122.482920180681	(37.7399587963622, -122.482920180681)
33310	33310	185231	Undocumented 2	:: 54	2526 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986157.8975	2098028.4291	37.7399869968702	-122.49044419216101	(37.7399869968702, -122.490444192161)
169031	169031	183501	Undocumented 2	:: 54	2534 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987089.5609	2098009.5749	37.739989600163	-122.48722154286001	(37.739989600163, -122.48722154286)
52308	52308	183503	Undocumented 2	:: 54	2542 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988332.5337	2097995.0598	37.7400221483249	-122.482922844986	(37.7400221483249, -122.482922844986)
149131	149131	183493	Undocumented 2	:: 54	2531 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987043.6597	2098023.3231	37.74002467234929	-122.48738125777099	(37.7400246723493, -122.487381257771)
151796	151796	183504	Undocumented 2	:: 54	2550 22nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989576.1036	2097983.595	37.7400629496831	-122.478622301865	(37.7400629496831, -122.478622301865)
115628	115628	185224	Undocumented 2	:: 54	2518 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986156.3055	2098078.3097	37.7401238627179	-122.490453365241	(37.7401238627179, -122.490453365241)
178952	178952	183207	Undocumented 2	:: 54	2487 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981762.9721	2098176.699	37.7401364295663	-122.505650753582	(37.7401364295663, -122.505650753582)
61251	61251	185223	Undocumented 2	:: 54	2515 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985800.5083	2098093.5658	37.7401449642117	-122.491684672602	(37.7401449642117, -122.491684672602)
41897	41897	183464	Undocumented 2	:: 54	2531 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988282.4359	2098065.1404	37.7402116561415	-122.48310119578899	(37.7402116561415, -122.483101195789)
31770	31770	183463	Undocumented 2	:: 54	2530 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988329.4378	2098069.925	37.740227528416796	-122.482939034698	(37.7402275284168, -122.482939034698)
181680	181680	183460	Undocumented 2	:: 54	2531 22nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989523.5075	2098113.9575	37.740417837399505	-122.478813687602	(37.7404178373995, -122.478813687602)
24723	24723	181788	Undocumented 2	:: 54	3131 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986265.505	2098198.358	37.740459860841	-122.49008463083	(37.740459860841, -122.49008463083)
155392	155392	183456	Undocumented 2	:: 54	2527 22nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989523.0923	2098140.5318	37.7404907794226	-122.47881706628999	(37.7404907794226, -122.47881706629)
158169	158169	183195	Undocumented 2	:: 54	2467 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981757.2189	2098306.9914	37.740493837912396	-122.505680301686	(37.7404938379124, -122.505680301686)
183851	183851	183451	Undocumented 2	:: 54	2515 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988280.1843	2098179.6898	37.7405260477437	-122.48311737481701	(37.7405260477437, -122.483117374817)
65156	65156	181787	Undocumented 2	:: 54	2915 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986983.636	2098224.4165	37.740573320949004	-122.487603561386	(37.740573320949, -122.487603561386)
59144	59144	183447	Undocumented 2	:: 54	2515 24th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988900.4073	2098186.5563	37.7405809740853	-122.480973412109	(37.7405809740853, -122.480973412109)
56203	56203	183446	Undocumented 2	:: 54	2511 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988279.6214	2098205.3016	37.7405963382743	-122.483121197886	(37.7405963382743, -122.483121197886)
51111	51111	181786	Undocumented 2	:: 54	2825 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987226.2844	2098233.5539	37.7406125590653	-122.486765258584	(37.7406125590653, -122.486765258584)
32375	32375	183437	Undocumented 2	:: 54	2509 24th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988899.1764	2098219.7887	37.7406721500335	-122.480980100642	(37.7406721500335, -122.480980100642)
151733	151733	181988	Undocumented 2	:: 54	2838 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987152.1701	2098289.7319	37.740762487887004	-122.487025638785	(37.740762487887, -122.487025638785)
27770	27770	181987	Undocumented 2	:: 54	2832 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987195.8265	2098292.1009	37.7407715379119	-122.486874867312	(37.7407715379119, -122.486874867312)
40078	40078	182086	Undocumented 2	:: 54	2425 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988468.6309	2098276.195	37.7408019901024	-122.482472876934	(37.7408019901024, -122.482472876934)
147904	147904	183186	Undocumented 2	:: 54	2446 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981797.1527	2098421.378	37.740810262110294	-122.505550705456	(37.7408102621103, -122.505550705456)
54106	54106	182574	Undocumented 2	:: 54	2243 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989005.4575	2098295.1152	37.740885154470504	-122.480618138278	(37.7408851544705, -122.480618138278)
150619	150619	182121	Undocumented 2	:: 54	2516 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988187.7408	2098326.2815	37.7409231701359	-122.48344774848302	(37.7409231701359, -122.483447748483)
33564	33564	182573	Undocumented 2	:: 54	2185 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989329.4471	2098306.2746	37.740934619914796	-122.479498731562	(37.7409346199148, -122.479498731562)
136488	136488	182995	Undocumented 2	:: 54	2115 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989428.2356	2098309.2017	37.740948394722096	-122.479157375315	(37.7409483947221, -122.479157375315)
179192	179192	182994	Undocumented 2	:: 54	2085 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989637.5208	2098316.5193	37.7409806392129	-122.478434287218	(37.7409806392129, -122.478434287218)
24206	24206	181982	Undocumented 2	:: 54	2479 31st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986720.0054	2098392.2737	37.7410188327151	-122.488527415956	(37.7410188327151, -122.488527415956)
26723	26723	183174	Undocumented 2	:: 54	2400 37th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984903.1916	2098438.8046	37.7410404135541	-122.494812631239	(37.7410404135541, -122.494812631239)
24053	24053	181971	Undocumented 2	:: 54	2467 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985787.1457	2098434.4072	37.7410800425161	-122.49175595946801	(37.7410800425161, -122.491755959468)
166639	166639	182565	Undocumented 2	:: 54	2150 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989287.7364	2098362.6206	37.7410869084631	-122.479647071884	(37.7410869084631, -122.479647071884)
50452	50452	182564	Undocumented 2	:: 54	2122 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989402.8067	2098365.7306	37.741102131537396	-122.479249432397	(37.7411021315374, -122.479249432397)
147090	147090	181972	Undocumented 2	:: 54	2474 31st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986764.6771	2098431.8691	37.7411301577029	-122.488375868808	(37.7411301577029, -122.488375868808)
152529	152529	181973	Undocumented 2	:: 54	2479 29th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987341.0094	2098425.1006	37.7411451833908	-122.486382648143	(37.7411451833908, -122.486382648143)
152865	152865	181963	Undocumented 2	:: 54	2463 31st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986716.6212	2098499.215	37.741312267621005	-122.48854697515101	(37.741312267621, -122.488546975151)
23417	23417	183167	Undocumented 2	:: 54	2422 45th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982411.0498	2098597.3573	37.741329561902596	-122.50344114283101	(37.7413295619026, -122.503441142831)
63109	63109	181952	Undocumented 2	:: 54	2451 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985784.0999	2098546.4248	37.7413874348207	-122.49177473498699	(37.7413874348207, -122.491774734987)
31188	31188	181929	Undocumented 2	:: 54	2427 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985466.1527	2098683.3165	37.7417447146597	-122.492884150676	(37.7417447146597, -122.492884150676)
62791	62791	181931	Undocumented 2	:: 54	2434 32nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986447.2375	2098665.0417	37.741751860864206	-122.48949058733601	(37.7417518608642, -122.489490587336)
133138	133138	183009	Undocumented 2	:: 54	2457 21st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989817.7183	2098630.996	37.741854570392604	-122.477834220439	(37.7418545703926, -122.477834220439)
66833	66833	182577	Undocumented 2	:: 54	2450 24th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988930.5766	2098660.9806	37.7418853730059	-122.480903825947	(37.7418853730059, -122.480903825947)
167644	167644	183008	Undocumented 2	:: 54	2450 21st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989860.5266	2098686.6102	37.7420097569425	-122.477690269186	(37.7420097569425, -122.477690269186)
32428	32428	182575	Undocumented 2	:: 54	2444 23rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989239.9887	2098703.075	37.742018933713105	-122.479837071242	(37.7420189337131, -122.479837071242)
183469	183469	181965	Undocumented 2	:: 54	2423 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987019.5087	2098756.0771	37.7420352120933	-122.48751857494499	(37.7420352120933, -122.487518574945)
154166	154166	182576	Undocumented 2	:: 54	2443 23rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989193.1556	2098714.7832	37.742048360443604	-122.47999985995001	(37.7420483604436, -122.47999985995)
62214	62214	183006	Undocumented 2	:: 54	2438 21st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989859.0631	2098748.8104	37.7421804576164	-122.477699875038	(37.7421804576164, -122.477699875038)
31404	31404	181902	Undocumented 2	:: 54	2370 31st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986740.6492	2099140.1859	37.7430736050662	-122.488510993633	(37.7430736050662, -122.488510993633)

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