Street_Tree_List

Data source: data.sfgov.org

135 rows where SiteOrder = 2 and qSpecies = 42 sorted by PlantDate

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, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate ▼	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
5055	5055	253765	Significant Tree 6	Acacia baileyana :: Bailey's Acacia 42	1366 Guerrero St	2	Front Yard : Yard 7	Tree 1	Private 1				3X3		6005800.0848900005	2101007.6677599996	37.7492949871928	-122.422741198761	(37.7492949871928, -122.422741198761)
7598	7598	103885	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	1750 Fulton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5999418.3529	2110865.7399	37.7760006689038	-122.445518048679	(37.7760006689038, -122.445518048679)
8932	8932	19577	DPW Maintained 3	Acacia baileyana :: Bailey's Acacia 42	100 STAIRWAY3	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	15ST
15903	15903	20055	DPW Maintained 3	Acacia baileyana :: Bailey's Acacia 42	100 STAIRWAY54	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	15ST
22329	22329	248977	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	748 Central Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5999650.0	2111146.0	37.7767834132689	-122.444736872581	(37.7767834132689, -122.444736872581)
23746	23746	188514	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1 Mississippi St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6013990.927619999	2106981.7626099996	37.7661572890446	-122.394835230264	(37.7661572890446, -122.394835230264)
24822	24822	250192	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	11 Alta St	2	Back Yard : Yard 13	Tree 1	Private 1			9	Width 0ft		6011786.88966	2119947.0785	37.8016342173021	-122.403370805543	(37.8016342173021, -122.403370805543)
25732	25732	220090	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	101 Ord Ct	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		6000882.83826	2105748.10477	37.7620324153945	-122.44008496885401	(37.7620324153945, -122.440084968854)
26908	26908	219997	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	80 Stoneman St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 2ft		6007927.7529	2099409.5439400002	37.7450267121064	-122.41527054312	(37.7450267121064, -122.41527054312)
32463	32463	174965	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1645 Felton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		6006090.3331	2092391.29935	37.725652733270294	-122.42112577893101	(37.7256527332703, -122.421125778931)
32938	32938	203645	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	2450 17th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5991098.28096	2098726.3101	37.7421905156936	-122.473413447294	(37.7421905156936, -122.473413447294)
33357	33357	220021	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1334 Diamond St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6001964.613530001	2100084.23013	37.7465422991033	-122.435938247064	(37.7465422991033, -122.435938247064)
34990	34990	124760	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1055 Greenwich St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6007817.3795	2119902.3991900003	37.8012890341312	-122.417103992782	(37.8012890341312, -122.417103992782)
35471	35471	140101	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	771 Central Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5999584.517999999	2111094.1746	37.7766373769699	-122.44495966716002	(37.7766373769699, -122.44495966716)
40646	40646	219991	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	13 Bronte St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 2ft		6009385.52811	2097403.7869700002	37.739601163374	-122.41008822049601	(37.739601163374, -122.410088220496)
41593	41593	220031	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	541 Grand View Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 5ft		6000040.44223	2101732.89415	37.7509596367958	-122.44271016275101	(37.7509596367958, -122.442710162751)
41760	41760	203657	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	226 Joost Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 10ft		6000556.64604	2094979.3129099999	37.7324453144793	-122.440440771241	(37.7324453144793, -122.440440771241)
42577	42577	139655	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	848 BAKER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6000491.15	2111934.8144	37.7789972619427	-122.441883720544	(37.7789972619427, -122.441883720544)
45153	45153	140717	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	556 SCOTT ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6002162.097	2110427.6982	37.774954171002	-122.43599537996201	(37.774954171002, -122.435995379962)
49170	49170	220036	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1711 Castro St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6002636.29383	2100481.40221	37.747670974341396	-122.43364403244	(37.7476709743414, -122.43364403244)
52495	52495	220079	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	4021 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6003566.56829	2104171.42308	37.7578556427516	-122.43069047448799	(37.7578556427516, -122.430690474488)
53649	53649	219989	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	936 Clayton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5998793.85425	2106724.38466	37.7645938887298	-122.447380197361	(37.7645938887298, -122.447380197361)
53685	53685	220687	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	430 Hickory St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6004894.475319999	2110399.44382	37.775031437471704	-122.426541481018	(37.7750314374717, -122.426541481018)
54226	54226	137665	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1901 GOLDEN GATE AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6000382.7272	2111637.7254	37.778175352566	-122.44223746490101	(37.778175352566, -122.442237464901)
54361	54361	203635	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	418 Flood Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 2ft		5997950.41926	2094116.13567	37.7299264906077	-122.44938890058201	(37.7299264906077, -122.449388900582)
55462	55462	113717	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	1342 Cabrillo St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		12			5991400.52029	2110673.00421	37.775010478076794	-122.47323950591299	(37.7750104780768, -122.473239505913)
62900	62900	203646	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	45 Dorantes Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5994072.18954	2100047.28757	37.745989350944	-122.463226505408	(37.745989350944, -122.463226505408)
64167	64167	203628	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	133 Maywood Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		5994258.53071	2095683.80268	37.734019041749	-122.46226575516701	(37.734019041749, -122.462265755167)
65658	65658	183506	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	2542 27th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5988021.6131	2097993.9577	37.7400010259161	-122.483997786352	(37.7400010259161, -122.483997786352)
67963	67963	220015	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	70 Quartz Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5998973.5201	2099794.49518	37.745576384946	-122.44626024553601	(37.745576384946, -122.446260245536)
68064	68064	188520	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	495 Connecticut St	2	: 4	Tree 1	Private 1			9	Width 3ft		6013272.40757	2104812.59187	37.7601612472551	-122.397168349564	(37.7601612472551, -122.397168349564)
69465	69465	188516	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1506 25th St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6014137.77003	2102020.8067900003	37.7525437439982	-122.39398001279301	(37.7525437439982, -122.393980012793)
75611	75611	182146	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1690 21st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5989681.6149	2103872.2722	37.756237834999	-122.478688039412	(37.756237834999, -122.478688039412)
75622	75622	203667	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	100 Judson Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 4ft		5999360.3584	2093511.22392	37.7283460957947	-122.444471133337	(37.7283460957947, -122.444471133337)
77429	77429	23663	DPW Maintained 3	Acacia baileyana :: Bailey's Acacia 42	311 Virginia Ave	2	Median : Cutout 11	Tree 1	DPW 2			12	12		6006938.1768512	2098312.3803834	37.7419584813283	-122.41861453896999	(37.7419584813283, -122.41861453897)
77653	77653	109672	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	798x GRAFTON AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5994496.0	2090624.0	37.72013972186421	-122.461078132621	(37.7201397218642, -122.461078132621)
86900	86900	19282	DPW Maintained 3	Acacia baileyana :: Bailey's Acacia 42	1770 Scott St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			11	3X3		6001619.01622	2114490.46983	37.786078645055	-122.43816511087601	(37.786078645055, -122.438165110876)
88925	88925	50661	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	1 Santa Ynez Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 47244	6000978.87890111	2091807.60057831	37.723760552916296	-122.43875382021002	(37.7237605529163, -122.43875382021)
90165	90165	111781	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	399x EUGENIA AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	3x3		6006811.0	2098022.0	37.7411540008274	-122.419033684979	(37.7411540008274, -122.419033684979)
91582	91582	23671	DPW Maintained 3	Acacia baileyana :: Bailey's Acacia 42	317 Virginia Ave	2	Median : Cutout 11	Tree 1	DPW 2			6	12		6006937.941544901	2098264.8464559	37.7418279505329	-122.41861198258002	(37.7418279505329, -122.41861198258)
92933	92933	120549	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	4098 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	3x3		6002569.0	2102434.0	37.7530285274797	-122.434016285558	(37.7530285274797, -122.434016285558)
93809	93809	203623	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	15 Teresita Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5997330.81089	2099592.0734900003	37.744926631064	-122.45192585212	(37.744926631064, -122.45192585212)
98056	98056	111844	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	1550 York St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1					6010144.81466304	2100398.61683821	37.7478668430794	-122.407674029985	(37.7478668430794, -122.407674029985)
98067	98067	98339	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	3434 Fulton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5992637.0	2110058.2	37.77339390860929	-122.468917542393	(37.7733939086093, -122.468917542393)
98941	98941	117044	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	2297 Sutter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1			3x3		6001629.48989293	2114242.74964382	37.785399064529294	-122.438111123258	(37.7853990645293, -122.438111123258)
103976	103976	98341	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	790X 11th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	3x3		5992573.13535	2110349.8527	37.7741910183852	-122.469159688197	(37.7741910183852, -122.469159688197)
109113	109113	99760	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	4247 25th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3	Most likely planted/permitted with tree no. 1 on same day/permit.	6002269.0	2101186.0	37.7495847859814	-122.434964495609	(37.7495847859814, -122.434964495609)
124870	124870	98708	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	105X Ord St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2						6000883.6	2105740.8	37.7620124016568	-122.440081810476	(37.7620124016568, -122.440081810476)
125571	125571	220042	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	890 Alvarado St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		6000646.62015	2102597.34113	37.7533677370469	-122.440675944861	(37.7533677370469, -122.440675944861)
128008	128008	23660	DPW Maintained 3	Acacia baileyana :: Bailey's Acacia 42	305 Virginia Ave	2	Median : Cutout 11	Tree 1	DPW 2			12	12		6006899.0385805	2098362.9679323	37.742095179874795	-122.418753453583	(37.7420951798748, -122.418753453583)
129296	129296	117035	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	2220x SUTTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6001781.0	2114465.0	37.786017922595605	-122.437602866759	(37.7860179225956, -122.437602866759)
130349	130349	220027	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	685 Alvarado St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6001922.66093	2102622.7782400004	37.7535101653675	-122.43626495635701	(37.7535101653675, -122.436264956357)
132605	132605	142261	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	575 LINDEN ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6004683.1776	2110693.6136	37.775827208405104	-122.427293365492	(37.7758272084051, -122.427293365492)
133071	133071	203620	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	358 Pacheco St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5994207.97815	2101247.70705	37.7492932209146	-122.46284404261101	(37.7492932209146, -122.462844042611)
133605	133605	220082	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	780 Noe St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6003052.51993	2103630.15774	37.7563403210743	-122.43242960863701	(37.7563403210743, -122.432429608637)
135277	135277	220051	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	501 Eugenia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6006788.71567	2098008.71009	37.741116254798605	-122.419109793907	(37.7411162547986, -122.419109793907)
152034	152034	124751	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	566 Linden St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6004689.62752	2110692.77739	37.775825277144705	-122.427270993988	(37.7758252771447, -122.427270993988)
154005	154005	248396	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1655 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5997671.1383	2108143.749	37.768426881635605	-122.45136572862499	(37.7684268816356, -122.451365728625)
156262	156262	140103	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1720 FULTON ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5999438.9967	2110868.4473	37.776009281241	-122.44544683133002	(37.776009281241, -122.44544683133)
156503	156503	174960	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	103 De Long St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 10ft		5994409.5991400005	2086788.1181299998	37.709602327657706	-122.461098897396	(37.7096023276577, -122.461098897396)
157543	157543	139098	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	2600 POST ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		5999639.9141	2113670.3506	37.7837140544374	-122.44495327295601	(37.7837140544374, -122.444953272956)
157925	157925	203650	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1390 Monterey Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 3ft		5993848.38247	2094813.0241599998	37.7316044735649	-122.46362057664699	(37.7316044735649, -122.463620576647)
158134	158134	203631	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1400 Monterey Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 10ft		5993837.01835	2094842.09298	37.7316836345786	-122.46366197331801	(37.7316836345786, -122.463661973318)
159913	159913	138338	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	2250 Sutter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6001931.2408	2114335.4048	37.7856706283151	-122.437073793387	(37.7856706283151, -122.437073793387)
159982	159982	220096	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	5 Penny Ln	2	Back Yard : Yard 13	Tree 1	Private 1			4	Width 2ft		6002436.28409	2096397.8300700001	37.736447085360105	-122.43404379100402	(37.7364470853601, -122.434043791004)
162065	162065	220000	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	62 Santa Marina St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6006013.90538	2097631.08265	37.7400357112669	-122.421761996217	(37.7400357112669, -122.421761996217)
162378	162378	220679	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3607 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6006165.33609	2104321.13003	37.758413591125205	-122.421713467922	(37.7584135911252, -122.421713467922)
162565	162565	203221	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	2398 12th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		5992664.0139	2099193.92326	37.7435650062179	-122.468033683007	(37.7435650062179, -122.468033683007)
164961	164961	138533	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	2299 SUTTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6001645.5525	2114240.3384	37.7853933573613	-122.438055378776	(37.7853933573613, -122.438055378776)
167885	167885	220009	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3447 25th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6006820.56616	2101433.2332200003	37.750521016743896	-122.419242531131	(37.7505210167439, -122.419242531131)
168971	168971	220018	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1129 Douglass St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 6ft		6001364.34858	2100418.37342	37.7474256590636	-122.43803782498999	(37.7474256590636, -122.43803782499)
171409	171409	124759	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	2534 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 2ft		6006240.40404	2119512.60207	37.800129911416704	-122.42253331686199	(37.8001299114167, -122.422533316862)
171522	171522	220055	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	32 Elsie St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6007497.36019	2099175.1634299997	37.7443589574154	-122.416742166726	(37.7443589574154, -122.416742166726)
173115	173115	203638	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	750 Grafton Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5994537.11563	2090599.0913099998	37.720073694513104	-122.46093420637101	(37.7200736945131, -122.460934206371)
173572	173572	245839	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	423 Laguna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6005015.8911	2110507.8578	37.775335978986796	-122.4261291969	(37.7753359789868, -122.4261291969)
179662	179662	203222	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	120 Taraval St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5993081.79545	2099194.6713799997	37.7435911783029	-122.466589164064	(37.7435911783029, -122.466589164064)
183618	183618	220682	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1624 Florida St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6009643.101369999	2100250.00573	37.7474306916674	-122.40939845218	(37.7474306916674, -122.40939845218)
185093	185093	220033	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	502 28th St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			12			6002622.25428	2099488.24408	37.7449431983695	-122.433621612357	(37.7449431983695, -122.433621612357)
185200	185200	220017	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	78 Berkeley Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6001185.230140001	2097348.08527	37.7389851844145	-122.438437264296	(37.7389851844145, -122.438437264296)
185398	185398	220685	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	452 Hickory St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 2ft		6004772.24556	2110355.93232	37.774905054848396	-122.426961200922	(37.7749050548484, -122.426961200922)
187340	187340	220676	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3681 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6005782.66085	2104298.9799099998	37.7583311853523	-122.423035356192	(37.7583311853523, -122.423035356192)
69451	69451	38054	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	2779 Bush St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/01/1999 12:00:00 AM	7		Permit Number 40250	6000242.4339	2114393.9483	37.7857352353713	-122.442920768491	(37.7857352353713, -122.442920768491)
168067	168067	38049	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	2700 Bush St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/11/2005 12:00:00 AM	9		Permit Number 47797	6000509.1373	2114490.0048	37.78601418351771	-122.44200495026199	(37.7860141835177, -122.442004950262)
5340	5340	30595	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	265 Walter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/26/1995 12:00:00 AM			Permit Number 34562
135271	135271	35351	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	1274 De Haro St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/23/1998 12:00:00 AM	11	5x5	Permit Number 38813	6012220.8536	2102461.75759	37.7536477760478	-122.400640051912	(37.7536477760478, -122.400640051912)
144563	144563	35559	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	801 Guerrero St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/23/1998 12:00:00 AM			Permit Number 38931	6005679.14966284	2104317.39620731	37.7583759105796	-122.423394653078	(37.7583759105796, -122.423394653078)
186993	186993	44745	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	1520 Pacific Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/04/2001 12:00:00 AM	8		Permit Number 43862	6006829.6851	2117719.85237	37.7952406976494	-122.42036685635401	(37.7952406976494, -122.420366856354)
140403	140403	1378	DPW Maintained 3	Acacia baileyana :: Bailey's Acacia 42	65 Amethyst Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/10/1998 12:00:00 AM	7	1X1		5998886.878159099	2099985.9166978	37.746097033504896	-122.44657360851801	(37.7460970335049, -122.446573608518)
124624	124624	49479	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	560@ Pacific Davis St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/14/2003 12:00:00 AM			Permit Number 46402	6013205.44581331	2118473.26826983	37.7976666140298	-122.39835845145001	(37.7976666140298, -122.39835845145)
124166	124166	35786	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	580 Elizabeth St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/22/1998 12:00:00 AM			Permit Number 39038	6002648.18507624	2102127.11023082	37.752190374612205	-122.433720516444	(37.7521903746122, -122.433720516444)
98495	98495	67124	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	1616 Florida St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/1992 12:00:00 AM		3x3	Permit Number 50077	6009627.64848121	2100263.06396072	37.7474656808625	-122.409452808897	(37.7474656808625, -122.409452808897)
73601	73601	40189	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	600 Silliman St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/30/1999 12:00:00 AM	8		Permit Number 41375	6008978.52665	2093804.69628	37.7296960159571	-122.411241285381	(37.7296960159571, -122.411241285381)
119240	119240	31447	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	237 Collingwood St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/01/1995 12:00:00 AM			Permit Number 35021	6002092.35921293	2104483.01837557	37.7586275781293	-122.435811191936	(37.7586275781293, -122.435811191936)
125085	125085	39221	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	1143 Guerrero St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/13/1999 12:00:00 AM			Permit Number 41443	6005801.05573922	2102320.92573379	37.752900946135604	-122.422831161336	(37.7529009461356, -122.422831161336)
77394	77394	36576	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	2959 25th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/20/1998 12:00:00 AM			Permit Number 39438	6009743.48880831	2101591.28473575	37.7511191714417	-122.409145947985	(37.7511191714417, -122.409145947985)
144588	144588	36580	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	2970 26th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/20/1998 12:00:00 AM			Permit Number 39441	6009675.57743886	2101054.36494821	37.7496411039984	-122.40934290688699	(37.7496411039984, -122.409342906887)
96769	96769	36919	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	699 Alvarado St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/27/1998 12:00:00 AM			Permit Number 39565	6001900.0	2102596.0	37.7534353511669	-122.43634140628299	(37.7534353511669, -122.436341406283)
111771	111771	49580	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	400REVISED Alemany Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/29/2003 12:00:00 AM			Permit Number 46462	6008204.64175087	2095122.01632245	37.7332696598424	-122.414009852171	(37.7332696598424, -122.414009852171)
20126	20126	22809	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	19 Turquoise Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/01/1998 12:00:00 AM	3	3x3		5998930.058209999	2099793.7189700003	37.745571771416294	-122.446410473673	(37.7455717714163, -122.446410473673)
122534	122534	39505	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	216 Jersey St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/19/1999 12:00:00 AM			Permit Number 40959	6003716.05884842	2101601.85489178	37.7508086831914	-122.42999018002399	(37.7508086831914, -122.429990180024)

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