Street_Tree_List

Data source: data.sfgov.org

500 rows where qSiteInfo = 2 and qSpecies = 15

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: PlotSize

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
23600	23600	135193	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	35 Bay St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 8ft		6010885.4927900005	2121705.9799599997	37.806413341469	-122.40661408636801	(37.806413341469, -122.406614086368)
23769	23769	133285	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2800 Divisadero St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 6ft		6000622.64068	2117960.51369	37.7955497631676	-122.44186143746401	(37.7955497631676, -122.441861437464)
23886	23886	134083	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2500 Vallejo St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 4ft		6001536.65742	2117684.63588	37.7948443142773	-122.43867901012399	(37.7948443142773, -122.438679010124)
23915	23915	201200	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	700 Folsom St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		6012679.9726	2113219.2905	37.7832111428923	-122.399807626404	(37.7832111428923, -122.399807626404)
23941	23941	250276	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	43 United Nations Plz	17	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 0ft		6008392.62375	2112125.224	37.7799671560941	-122.414562734397	(37.7799671560941, -122.414562734397)
23953	23953	211938	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	49 Marcela Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		5994751.80445	2100714.33163	37.747860014539704	-122.46092484170201	(37.7478600145397, -122.460924841702)
24035	24035	178607	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	0 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			5990327.66617	2089955.55198	37.7180635775375	-122.47543773036101	(37.7180635775375, -122.475437730361)
24126	24126	138818	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	723 Grove St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		6004379.6433	2111160.4787	37.7770919345009	-122.428376650964	(37.7770919345009, -122.428376650964)
24464	24464	124319	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	125 Jordan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5996196.09521	2113578.46254	37.783264606053294	-122.456860862891	(37.7832646060533, -122.456860862891)
24473	24473	250486	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	220 El Camino Del Mar	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5987923.25995	2115358.25633	37.7876728999176	-122.485611871313	(37.7876728999176, -122.485611871313)
25623	25623	211941	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	49 Marcela Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 4ft		5994781.848230001	2100754.56205	37.7479722058507	-122.46082386764799	(37.7479722058507, -122.460823867648)
25709	25709	238712	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	45 Patton St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		6005630.08685	2096838.1497	37.737836843694794	-122.42303274008002	(37.7378368436948, -122.42303274008)
25890	25890	211894	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	42 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 8ft		5992633.05576	2096891.53005	37.73724142864779	-122.467973292645	(37.7372414286478, -122.467973292645)
25913	25913	133444	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	3725 Washington St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5996961.868419999	2115649.7867099997	37.78899585303321	-122.454361277366	(37.7889958530332, -122.454361277366)
25954	25954	201635	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	451 Galvez Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		6021853.58241	2093133.73067	37.7285673424948	-122.36668395282301	(37.7285673424948, -122.366683952823)
26388	26388	133541	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Locust St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 4ft		5997506.09464	2116288.41931	37.7907805630199	-122.45252444266599	(37.7907805630199, -122.452524442666)
26694	26694	124453	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	61 Edward St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 5ft		5995857.77274	2111686.71555	37.7780509386546	-122.457894375539	(37.7780509386546, -122.457894375539)
27238	27238	124451	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	61 Edward St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		5995921.71899	2111694.81562	37.7780768529354	-122.457673750202	(37.7780768529354, -122.457673750202)
27716	27716	250485	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	220 El Camino Del Mar	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5987961.74395	2115359.72592	37.7876791771886	-122.485478833689	(37.7876791771886, -122.485478833689)
28169	28169	133574	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Laurel St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 3ft		5998068.52941	2115738.87218	37.7893038609216	-122.45053881963699	(37.7893038609216, -122.450538819637)
28283	28283	250263	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	43 United Nations Plz	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 0ft		6008564.070780001	2112166.2785	37.780089512455895	-122.413972525522	(37.7800895124559, -122.413972525522)
28469	28469	133683	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	3301 Laguna St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 5ft		6003639.65716	2120421.26895	37.8024778119699	-122.431597810397	(37.8024778119699, -122.431597810397)
28618	28618	250962	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	6538 California St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		5986619.26657	2113951.14977	37.78373332707871	-122.490019838944	(37.7837333270787, -122.490019838944)
28733	28733	238716	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	196 Appleton Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		6006181.65648	2096744.36532	37.7376104420736	-122.42111903491801	(37.7376104420736, -122.421119034918)
28770	28770	120033	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	854 28th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 2ft		5987298.51459	2110108.4388099997	37.7732219709389	-122.48738756829799	(37.7732219709389, -122.487387568298)
29183	29183	135142	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1405 The Embarcadero	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 6ft		6009611.73281	2122475.6117	37.8084552117099	-122.411076576336	(37.8084552117099, -122.411076576336)
29455	29455	211935	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Pacheco St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 6ft		5994517.11867	2100302.62637	37.74671606878879	-122.461706521658	(37.7467160687888, -122.461706521658)
29517	29517	135087	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1401 The Embarcadero	45	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		6010278.59779	2122338.55223	37.8081162545339	-122.408759020708	(37.8081162545339, -122.408759020708)
29612	29612	119384	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	340 31st Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 3ft		5986242.52312	2113595.8501	37.78273576945529	-122.491297052566	(37.7827357694553, -122.491297052566)
29918	29918	238725	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	150 Appleton Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		6005917.1898300005	2096895.89012	37.7380115828774	-122.42204418460699	(37.7380115828774, -122.422044184607)
29977	29977	211945	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	230 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		5993614.12325	2095821.8351	37.7343609181201	-122.464503672234	(37.7343609181201, -122.464503672234)
30359	30359	250285	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	43 United Nations Plz	26	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 0ft		6008311.26384	2112132.45914	37.7799824508737	-122.41484470781401	(37.7799824508737, -122.414844707814)
30873	30873	211922	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	155 San Anselmo Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		5993428.13683	2096525.45183	37.736282151484296	-122.465197772566	(37.7362821514843, -122.465197772566)
30878	30878	211892	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	15 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 8ft		5992677.8722	2096919.75593	37.7373215177838	-122.46782039530399	(37.7373215177838, -122.467820395304)
31024	31024	119385	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	340 31st Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		5986245.2794	2113549.60335	37.7826089502225	-122.491284112348	(37.7826089502225, -122.491284112348)
31084	31084	134794	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1040 Lombard St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14			6007385.13093	2120235.26271	37.8021786677605	-122.418623384776	(37.8021786677605, -122.418623384776)
31366	31366	211962	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	251 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5993535.73552	2095560.6161	37.733639156417496	-122.46475571890801	(37.7336391564175, -122.464755718908)
31563	31563	124169	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	951 Anza St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 6ft		5996113.01293	2112199.70913	37.779474144226	-122.457048529936	(37.779474144226, -122.457048529936)
31603	31603	211912	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	160 San Anselmo Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		5993474.36419	2096435.15771	37.73603689198271	-122.465031390792	(37.7360368919827, -122.465031390792)
31655	31655	124443	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Edward St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 5ft		5996014.365230001	2111743.99955	37.778217220689	-122.457356814692	(37.778217220689, -122.457356814692)
31712	31712	133575	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Laurel St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5998068.71323	2115728.6745	37.7892758713204	-122.450537448164	(37.7892758713204, -122.450537448164)
31717	31717	135070	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1401 The Embarcadero	28	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		6010442.39712	2122245.83866	37.8078708592274	-122.4081856049	(37.8078708592274, -122.4081856049)
31994	31994	124164	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	951 Anza St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 6ft		5995840.67051	2112165.09055	37.7793634471791	-122.45798816595301	(37.7793634471791, -122.457988165953)
32053	32053	250261	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	43 United Nations Plz	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 0ft		6008586.13413	2112170.60163	37.7801026218644	-122.41389650404301	(37.7801026218644, -122.413896504043)
32260	32260	212779	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	191 San Anselmo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5993643.90362	2096193.01161	37.735381793433596	-122.46442765343399	(37.7353817934336, -122.464427653434)
32272	32272	195931	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	623 Mendell St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 10ft		6016388.5375	2097212.10904	37.7394648837006	-122.38586125081801	(37.7394648837006, -122.385861250818)
32647	32647	250269	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	43 United Nations Plz	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 0ft		6008517.979119999	2112159.2639599997	37.7800676634378	-122.41413148158199	(37.7800676634378, -122.414131481582)
32801	32801	201209	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	790 Folsom St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		6012419.7025	2112971.3045	37.7825157180222	-122.40069063515399	(37.7825157180222, -122.400690635154)
33098	33098	238708	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	129 Highland Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 3ft		6005632.730690001	2096682.87039	37.737410630691706	-122.423012565577	(37.7374106306917, -122.423012565577)
33177	33177	238729	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	110 Appleton Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		6005787.16509	2096964.1371900002	37.738191639728	-122.42249859313	(37.738191639728, -122.42249859313)
33263	33263	211957	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	285 San Anselmo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		5993368.76024	2095426.56277	37.7332614510564	-122.465323262185	(37.7332614510564, -122.465323262185)
33443	33443	133546	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	20 Locust St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 4ft		5997520.20768	2116197.44265	37.7905315740163	-122.452469044412	(37.7905315740163, -122.452469044412)
33675	33675	134800	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1070 Lombard St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			6007227.6114300005	2120220.91562	37.802130404749896	-122.419167461114	(37.8021304047499, -122.419167461114)
33678	33678	135076	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1401 The Embarcadero	34	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		6010384.52328	2122278.10501	37.807956213866	-122.408388169972	(37.807956213866, -122.408388169972)
33779	33779	135154	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1413 The Embarcadero	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 6ft		6009495.3394	2122500.7310200003	37.80851765524471	-122.41148116512	(37.8085176552447, -122.41148116512)
33854	33854	124441	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Edward St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 5ft		5996092.3035699995	2111750.82416	37.7782404354383	-122.45708769291402	(37.7782404354383, -122.457087692914)
33991	33991	211989	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	751 Junipero Serra Blvd	32	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		5991413.9184	2093039.12628	37.7265932181855	-122.47190767821002	(37.7265932181855, -122.47190767821)
34041	34041	250815	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	66 Sea View Ter	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5986156.52823	2114164.57331	37.784292294401	-122.491636432381	(37.784292294401, -122.491636432381)
34056	34056	124444	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Edward St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 5ft		5995959.12368	2111736.70034	37.778194005969	-122.45754738597401	(37.778194005969, -122.457547385974)
34341	34341	195927	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	623 Mendell St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 10ft		6016357.22552	2097177.34103	37.7393676849746	-122.385967092025	(37.7393676849746, -122.385967092025)
34365	34365	133316	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2800 Green St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 4ft		5999566.3761	2117753.4591	37.7949210021671	-122.445501386779	(37.7949210021671, -122.445501386779)
34450	34450	250300	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 United Nations Plz	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 0ft		6008420.57979	2112029.11153	37.779704824759996	-122.414459218831	(37.77970482476, -122.414459218831)
34693	34693	133280	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2601 Baker St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 6ft		5999616.79526	2117793.8298400003	37.795034727725	-122.44532983392901	(37.795034727725, -122.445329833929)
34855	34855	134971	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2100 The Embarcadero	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			6009844.1621199995	2122376.03453	37.8081948291999	-122.41026515223	(37.8081948291999, -122.41026515223)
34856	34856	250957	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	6534 California St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		5986936.54247	2113961.66352	37.7837807168614	-122.488922971817	(37.7837807168614, -122.488922971817)
34872	34872	211905	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 8ft		5993202.216519999	2096632.8865099999	37.7365641096345	-122.465986670445	(37.7365641096345, -122.465986670445)
34948	34948	143032	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	301 LOMBARD ST	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		6010840.9204	2120666.3163	37.8035561879378	-122.40669502317199	(37.8035561879378, -122.406695023172)
34960	34960	135084	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1401 The Embarcadero	42	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 5ft		6010314.2182599995	2122318.99449	37.8080645489009	-122.40863436569201	(37.8080645489009, -122.408634365692)
35307	35307	135015	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1077 Front St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			6012578.55568	2120142.36821	37.802214619965206	-122.40064498919399	(37.8022146199652, -122.400644989194)
35743	35743	133314	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2800 Green St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		5999601.25384	2117758.13139	37.7949358220814	-122.44538104132	(37.7949358220814, -122.44538104132)
35843	35843	201199	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	700 Folsom St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		6012695.3277	2113239.2522	37.783266809092495	-122.399755905675	(37.7832668090925, -122.399755905675)
35875	35875	211898	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	50 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 8ft		5992872.84504	2096808.4352799999	37.7370271156957	-122.46713819838001	(37.7370271156957, -122.46713819838)
36123	36123	238700	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	175 Highland Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		6005942.42533	2096655.34984	37.737352536278	-122.421939850649	(37.737352536278, -122.421939850649)
36515	36515	120042	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	855 27th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 2ft		5987562.19522	2110171.37929	37.7734101615057	-122.48648009559601	(37.7734101615057, -122.486480095596)
36916	36916	201206	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	790 Folsom St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		6012480.3554	2113028.1186	37.782675099007704	-122.400484793191	(37.7826750990077, -122.400484793191)
37027	37027	133598	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	3203 Pacific Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 4ft		5998791.8910300005	2116557.82252	37.79159385771379	-122.448095074739	(37.7915938577138, -122.448095074739)
37319	37319	124448	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Edward St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 5ft		5995755.70235	2111706.15448	37.778098448140895	-122.458248878605	(37.7780984481409, -122.458248878605)
37551	37551	238724	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	154 Appleton Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		6005949.57706	2096876.4099599998	37.737959921316296	-122.421930822364	(37.7379599213163, -122.421930822364)
37596	37596	211928	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1960 09th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5993496.8465599995	2102079.53468	37.7515362218261	-122.46536354639099	(37.7515362218261, -122.465363546391)
37684	37684	211970	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	191 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5993649.31716	2095976.62159	37.7347879521877	-122.46439323095899	(37.7347879521877, -122.464393230959)
37881	37881	133439	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	3701 Washington St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5997036.11786	2115659.5890099998	37.7890270253172	-122.454105093783	(37.7890270253172, -122.454105093783)
38047	38047	211920	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	155 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		5993463.1611	2096494.07268	37.7361980118237	-122.465074401756	(37.7361980118237, -122.465074401756)
38055	38055	134980	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2350 Stockton St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			6009736.585940001	2122356.6353700003	37.8081355332869	-122.410636078516	(37.8081355332869, -122.410636078516)
38176	38176	195928	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	623 Mendell St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 10ft		6016367.965340001	2097187.6132799997	37.7393964848479	-122.385930673971	(37.7393964848479, -122.385930673971)
38188	38188	238719	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	180 Appleton Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		6006070.19923	2096810.2934400002	37.7377851821265	-122.42150907719	(37.7377851821265, -122.42150907719)
38373	38373	182584	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2445 26th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 0ft		5988262.1936	2098677.2249	37.7418911015612	-122.483216039459	(37.7418911015612, -122.483216039459)
38801	38801	250306	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	4 United Nations Plz	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 0ft		6008573.7773400005	2112070.38194	37.7798267485347	-122.41393216035601	(37.7798267485347, -122.413932160356)
38879	38879	133686	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	3301 Laguna St	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 5ft		6003672.54238	2120178.33709	37.801812648208	-122.43146665866301	(37.801812648208, -122.431466658663)
39021	39021	211904	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	80 San Anselmo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 8ft		5993117.507999999	2096685.0409	37.7367024253714	-122.466283330728	(37.7367024253714, -122.466283330728)
39130	39130	134791	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Lombard St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			6007500.8396	2120253.7585299998	37.802235966276	-122.418224288116	(37.802235966276, -122.418224288116)
39515	39515	247242	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	901 Buena Vista Ave West	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 6ft		6000095.1365	2108566.27188	37.7697255246317	-122.44301170993099	(37.7697255246317, -122.443011709931)
39563	39563	250286	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	43 United Nations Plz	27	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 0ft		6008300.87263	2112112.7782	37.7799278278445	-122.414879262463	(37.7799278278445, -122.414879262463)
39735	39735	124168	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	951 Anza St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 6ft		5996053.61924	2112192.0186	37.7794496170788	-122.45725344014299	(37.7794496170788, -122.457253440143)
40359	40359	250297	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 United Nations Plz	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 0ft		6008380.5766	2112045.78874	37.7797483690312	-122.414598788204	(37.7797483690312, -122.414598788204)
40630	40630	124449	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Edward St	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 5ft		5995696.13098	2111699.5362400003	37.7780768529151	-122.45845447691299	(37.7780768529151, -122.458454476913)
41048	41048	250294	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 United Nations Plz	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		6008364.20368	2112023.92173	37.7796874075756	-122.414653881581	(37.7796874075756, -122.414653881581)
41220	41220	211958	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	285 San Anselmo Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 4ft		5993403.4688	2095447.0539400002	37.7333197163251	-122.46520475402201	(37.7333197163251, -122.465204754022)
41619	41619	133542	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Locust St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 4ft		5997508.27135	2116268.04514	37.7907247457095	-122.452515440443	(37.7907247457095, -122.452515440443)
41636	41636	134799	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1070 Lombard St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			6007233.50436	2120221.1606099997	37.802131409291796	-122.419147086091	(37.8021314092918, -122.419147086091)
41734	41734	211902	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	60 San Anselmo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 8ft		5993032.3976	2096733.05843	37.7368293583846	-122.466581080979	(37.7368293583846, -122.466581080979)

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