Street_Tree_List

Data source: data.sfgov.org

138 rows where PlotSize = "Width 3ft" and qSpecies = 30 sorted by Longitude descending

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: SiteOrder, qSiteInfo, DBH

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude ▲	Location
162297	162297	191270	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6014244.47605	2110787.29844	37.7766205377503	-122.39422470752899	(37.7766205377503, -122.394224707529)
37043	37043	191271	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6014227.23158	2110805.88928	37.776670625478395	-122.394285663563	(37.7766706254784, -122.394285663563)
62414	62414	191272	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6014208.1321	2110827.64494	37.776729299941394	-122.394353258399	(37.7767292999414, -122.394353258399)
168646	168646	191273	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6014193.41583	2110841.8415900003	37.7767674626879	-122.394405160994	(37.7767674626879, -122.394405160994)
64764	64764	191274	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6014170.53603	2110866.45323	37.7768337688053	-122.394486033405	(37.7768337688053, -122.394486033405)
178335	178335	191275	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6014152.76855	2110885.05471	37.7768838565355	-122.394548799799	(37.7768838565355, -122.394548799799)
71984	71984	191276	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6014137.59227	2110902.38763	37.776930605110394	-122.394602513603	(37.7769306051104, -122.394602513603)
72025	72025	191277	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6014120.49796	2110919.7593900003	37.7769773536703	-122.394662865301	(37.7769773536703, -122.394662865301)
169237	169237	191278	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6014098.280590001	2110942.62046	37.777038889768896	-122.39474132397801	(37.7770388897689, -122.394741323978)
131733	131733	191263	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	728 Wisconsin St	2	: 4	Tree 1	Private 1			13	Width 3ft		6012693.0382199995	2104091.70249	37.7581495726586	-122.399121524154	(37.7581495726586, -122.399121524154)
56561	56561	191262	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	690 Wisconsin St	5	: 4	Tree 1	Private 1			15	Width 3ft		6012676.19431	2104276.36771	37.7586556841436	-122.399192740559	(37.7586556841436, -122.399192740559)
177184	177184	191261	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	690 Wisconsin St	3	: 4	Tree 1	Private 1			18	Width 3ft		6012675.54577	2104288.99957	37.7586903323146	-122.399195870217	(37.7586903323146, -122.399195870217)
176903	176903	129458	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	731 Sansome St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6012131.08094	2118327.87745	37.7972074996935	-122.40206584156401	(37.7972074996935, -122.402065841564)
59034	59034	129459	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	458 Jackson St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6011895.81451	2118092.21584	37.7965472956624	-122.402863344166	(37.7965472956624, -122.402863344166)
148228	148228	129462	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	584 Washington St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6011873.80865	2117764.68671	37.7956467505394	-122.402916441935	(37.7956467505394, -122.402916441935)
148459	148459	129460	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	468 Jackson St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6011856.71365	2118087.11906	37.7965311177706	-122.402998283841	(37.7965311177706, -122.402998283841)
148356	148356	129461	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	468 Jackson St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6011829.8803199995	2118083.5136599997	37.796519719768895	-122.403090879839	(37.7965197197689, -122.403090879839)
148096	148096	176961	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	41 Teddy Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6011207.15899	2087778.71194	37.7132746363936	-122.403112916852	(37.7132746363936, -122.403112916852)
46075	46075	191248	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	611 San Bruno Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6010994.55519	2105384.5641	37.7616046825239	-122.405086676019	(37.7616046825239, -122.405086676019)
58227	58227	227613	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	210 Holladay Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6010812.412330001	2099853.77151	37.746408165199796	-122.405327133143	(37.7464081651998, -122.405327133143)
64332	64332	227614	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	210 Holladay Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6010810.25772	2099834.79777	37.746355946971605	-122.405333247626	(37.7463559469716, -122.405333247626)
170818	170818	227612	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1299 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6010076.057159999	2101688.5205599996	37.7514047850101	-122.40800274303601	(37.7514047850101, -122.408002743036)
46359	46359	129457	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	822 Pacific Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6010137.05679	2118184.23209	37.7967015887668	-122.408955554965	(37.7967015887668, -122.408955554965)
171684	171684	176974	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	15 Holyoke St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6009262.49228	2094178.39386	37.730738031628704	-122.410285956242	(37.7307380316287, -122.410285956242)
56287	56287	227611	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	66 Balmy St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		6008811.16325	2101739.4503099998	37.751473726132005	-122.412380510571	(37.751473726132, -122.412380510571)
66909	66909	129449	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	884 Union St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6008727.37725	2119383.41122	37.799915172210206	-122.41391825502899	(37.7999151722102, -122.413918255029)
174066	174066	176973	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	82 Colby St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6008143.29471	2093583.4510299999	37.729041645841896	-122.414113135409	(37.7290416458419, -122.414113135409)
137572	137572	129440	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	754 Post St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6008519.418319999	2114901.84945	37.7875982238142	-122.414320608106	(37.7875982238142, -122.414320608106)
152929	152929	227636	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3232 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6008200.59079	2100972.6589	37.749334006979396	-122.414437698959	(37.7493340069794, -122.414437698959)
158779	158779	227635	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3234 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6008177.73099	2100971.3435400003	37.7493291110692	-122.41451665582198	(37.7493291110692, -122.414516655822)
173580	173580	176972	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	161 University St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6008005.59306	2093164.83572	37.7278844827614	-122.41455957148399	(37.7278844827614, -122.414559571484)
43921	43921	227634	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3238 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6008149.92124	2100968.79152	37.7493205414166	-122.414612642259	(37.7493205414166, -122.414612642259)
167315	167315	227633	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3240 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6008124.7966	2100966.18492	37.749311972684396	-122.414699339617	(37.7493119726844, -122.414699339617)
189130	189130	227619	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1193 Shotwell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6008092.35309	2100991.6752	37.7493801403813	-122.414813334067	(37.7493801403813, -122.414813334067)
27806	27806	129444	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1338 Clay St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6008418.059880001	2116953.62618	37.793226207275794	-122.414816555443	(37.7932262072758, -122.414816555443)
74170	74170	129446	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1329 Washington St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6008344.2402	2117236.00141	37.7939973921104	-122.415091973713	(37.7939973921104, -122.415091973713)
150569	150569	129445	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	24 Priest St	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6008315.59279	2117230.60537	37.793980966003	-122.415190714801	(37.793980966003, -122.415190714801)
64750	64750	129447	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1190 Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6008246.65377	2115911.69756	37.7903556945065	-122.41533583927799	(37.7903556945065, -122.415335839278)
42869	42869	129448	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1190 Pine St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6008230.449580001	2115909.44994	37.79034861235171	-122.415391745646	(37.7903486123517, -122.415391745646)
162168	162168	176971	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	20 Tulane St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6007468.11752	2093808.15267	37.7296206815304	-122.416463191631	(37.7296206815304, -122.416463191631)
54446	54446	129451	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1147 Filbert St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			9	Width 3ft		6007395.89235	2119499.90916	37.80016017810029	-122.418533970572	(37.8001601781003, -122.418533970572)
162454	162454	227640	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1098 22nd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6006270.9018	2103197.69782	37.7553348592182	-122.421268598461	(37.7553348592182, -122.421268598461)
69926	69926	227665	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	46 Gough St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6006330.78292	2109566.87483	37.7728264958779	-122.421513830121	(37.7728264958779, -122.421513830121)
158100	158100	227666	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	46 Gough St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6006306.62249	2109592.20963	37.772894696857705	-122.421599203664	(37.7728946968577, -122.421599203664)
187479	187479	227589	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	23 27th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6006036.6609	2100222.07218	37.7471512660344	-122.42186731675	(37.7471512660344, -122.42186731675)
47927	47927	227620	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	55 Elizabeth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005907.97007	2102264.4901400004	37.752752018913796	-122.422457421298	(37.7527520189138, -122.422457421298)
182098	182098	227599	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3542 17th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6005268.27661	2106072.0060799997	37.7631704570704	-122.424940469222	(37.7631704570704, -122.424940469222)
45275	45275	227654	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	210 Liberty St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6004930.05045	2104005.07306	37.7574760371124	-122.42596313868201	(37.7574760371124, -122.425963138682)
174454	174454	227588	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	435 Oak St	1	: 4	Tree 1	Private 1			3	Width 3ft		6004887.16184	2110182.76224	37.77443606920671	-122.42655134748001	(37.7744360692067, -122.42655134748)
157316	157316	176970	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	146 Trumbull St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004341.61716	2094290.0126599998	37.7307674412459	-122.42730614487301	(37.7307674412459, -122.427306144873)
59805	59805	176969	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	134 Craut St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6004020.786	2094067.71187	37.7301389032718	-122.428399470475	(37.7301389032718, -122.428399470475)
28952	28952	176968	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	134 Craut St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004019.9865	2094083.3714700001	37.7301818557853	-122.428403350153	(37.7301818557853, -122.428403350153)
150746	150746	176967	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	134 Craut St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004019.42662	2094104.5358400003	37.7302399367234	-122.428406793639	(37.7302399367234, -122.428406793639)
55800	55800	227661	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	8 Addison St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6003680.16981	2096890.8857099998	37.7378714190205	-122.42977831104099	(37.7378714190205, -122.429778311041)
156333	156333	129391	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1851 Filbert St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004117.78483	2119036.12679	37.798701658520706	-122.42984439412399	(37.7987016585207, -122.429844394124)
157583	157583	227652	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3875 19th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6003788.823369999	2104769.57077	37.759510603063795	-122.42996449048799	(37.7595106030638, -122.429964490488)
57506	57506	227659	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	248 Fillmore St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6003786.3248	2109251.28052	37.771816154325	-122.430292880621	(37.771816154325, -122.430292880621)
72449	72449	227655	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2 Belcher St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6003762.03013	2108315.13286	37.769244345078704	-122.430310116133	(37.7692443450787, -122.430310116133)
23366	23366	227653	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3750 21st St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6003384.06107	2103624.93542	37.7563447763019	-122.43128265198901	(37.7563447763019, -122.431282651989)
71664	71664	227629	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	62 Natick St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6003056.07384	2095532.6693400003	37.7341067067448	-122.431839162348	(37.7341067067448, -122.431839162348)
62411	62411	176924	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	525 Edinburgh St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6002840.55904	2090695.62	37.720813038882206	-122.43223893347799	(37.7208130388822, -122.432238933478)
26349	26349	129413	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2111 Webster St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6003291.44456	2115944.18125	37.79016514166771	-122.43248283141399	(37.7901651416677, -122.432482831414)
56261	56261	227645	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3801 21st St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6003027.84051	2103561.52563	37.7561504741859	-122.432510056589	(37.7561504741859, -122.432510056589)
157755	157755	129412	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2111 Webster St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6003281.29754	2115999.00202	37.790315090121005	-122.432521856625	(37.790315090121, -122.432521856625)
40498	40498	129411	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2111 Webster St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6003275.408009999	2116033.9816799997	37.790410801365105	-122.43254473354901	(37.7904108013651, -122.432544733549)
183006	183006	129410	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2199 Webster St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6003271.2174	2116075.89812	37.7905256555748	-122.43256222807301	(37.7905256555748, -122.432562228073)
55145	55145	129409	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2199 Webster St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6003265.25593	2116107.39334	37.7906117953446	-122.43258510502399	(37.7906117953446, -122.432585105024)
179940	179940	227644	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3801 21st St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6003004.720380001	2103560.48994	37.756146319318496	-122.43258993978901	(37.7561463193185, -122.432589939789)
147603	147603	129408	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2199 Webster St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6003263.17406	2116138.42129	37.7906968721156	-122.432594525436	(37.7906968721156, -122.432594525436)
163312	163312	227643	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3801 21st St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6002989.53011	2103560.80368	37.7561463193257	-122.432642495251	(37.7561463193257, -122.432642495251)
129683	129683	227642	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3801 21st St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6002972.163319999	2103558.74094	37.756139670625295	-122.432702408096	(37.7561396706253, -122.432702408096)
154729	154729	176975	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	248 London St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6002517.77047	2092300.43042	37.7252011818667	-122.43346933824301	(37.7252011818667, -122.433469338243)
157251	157251	227646	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	4082 23rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6002634.29607	2102415.94957	37.7529826707309	-122.43378918933	(37.7529826707309, -122.43378918933)
151159	151159	227625	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	4283 25th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6002039.82763	2101169.8407900003	37.749527401673	-122.435755824069	(37.749527401673, -122.435755824069)
53384	53384	227624	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	4283 25th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6002006.21213	2101168.55205	37.749521953590396	-122.43587197511499	(37.7495219535904, -122.435871975115)
165161	165161	227641	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	582 Diamond St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6001827.41036	2102469.65818	37.753084321989	-122.436583393722	(37.753084321989, -122.436583393722)
49437	49437	227622	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	521 Clipper St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			62	Width 3ft		6001670.93131	2100857.28025	37.748648223551	-122.43700910221001	(37.748648223551, -122.43700910221)
152338	152338	227651	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	4118 21st St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6001694.86954	2103534.27623	37.75599997444	-122.43711796243	(37.75599997444, -122.43711796243)
186363	186363	129407	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2033 Pierce St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6001882.3909599995	2115581.31929	37.789088813243396	-122.437332045161	(37.7890888132434, -122.437332045161)
186507	186507	227658	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	111 States St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6001589.01566	2106181.9491	37.763263822894295	-122.437673651738	(37.7632638228943, -122.437673651738)
162971	162971	227657	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	117 States St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6001570.048769999	2106180.8326	37.7632596788053	-122.437739171852	(37.7632596788053, -122.437739171852)
37486	37486	227656	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	148 Buena Vista Ter	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6001371.492269999	2107387.94373	37.7665628167523	-122.43851240444799	(37.7665628167523, -122.438512404448)
55487	55487	129414	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2501 Jackson St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6001550.43955	2116611.49961	37.791898545338896	-122.438554394686	(37.7918985453389, -122.438554394686)
74708	74708	129392	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	31 Casa Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6001624.74168	2121508.73342	37.80534928880979	-122.438648369353	(37.8053492888098, -122.438648369353)
28468	28468	129406	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3545 Scott St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6000708.230719999	2120533.5731200003	37.8026195792908	-122.44175003663099	(37.8026195792908, -122.441750036631)
75243	75243	129405	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3545 Scott St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6000706.97602	2120551.39476	37.8026684412687	-122.44175565829399	(37.8026684412687, -122.441755658294)
74636	74636	227650	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	154 Danvers St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6000006.33119	2104908.8667200003	37.759678136855996	-122.443056184107	(37.759678136856, -122.443056184107)
76313	76313	227649	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	154 Danvers St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5999999.59495	2104920.93401	37.7597108865789	-122.44308034798901	(37.7597108865789, -122.443080347989)
70505	70505	227648	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	154 Danvers St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		5999992.54639	2104934.00184	37.7597463657249	-122.443105663906	(37.7597463657249, -122.443105663906)
186402	186402	227647	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	144 Danvers St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5999980.75729	2104959.09552	37.7598145945821	-122.44314823869499	(37.7598145945821, -122.443148238695)
152769	152769	129415	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1914 Lyon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5999481.122280001	2115602.98861	37.7890115102163	-122.44564165674	(37.7890115102163, -122.44564165674)
31281	31281	227616	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	246 Downey St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5999006.659659999	2106731.5709599997	37.764625778676	-122.44664468051	(37.764625778676, -122.44664468051)
65976	65976	129416	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	218 Presidio Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5999044.58564	2115840.24858	37.789638031029206	-122.44716909230301	(37.7896380310292, -122.447169092303)
27723	27723	129402	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3000 Lyon St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5999090.32735	2119096.86414	37.7985824452762	-122.44724531075	(37.7985824452762, -122.44724531075)
133580	133580	129395	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3383 Clay St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5998662.1100699995	2115556.58452	37.7888373034598	-122.44847197610399	(37.7888373034598, -122.448471976104)
56432	56432	227632	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	71 Clarendon Ave	1	: 4	Tree 1	Private 1			9	Width 3ft		5997905.871119999	2104612.50701	37.758744422044295	-122.450299233916	(37.7587444220443, -122.450299233916)
76698	76698	227631	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	75 Clarendon Ave	1	: 4	Tree 1	Private 1			9	Width 3ft		5997896.0946	2104612.71078	37.758744422037395	-122.450333060142	(37.7587444220374, -122.450333060142)
162702	162702	129396	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3570 Sacramento St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5997759.42615	2115150.05593	37.7876694312425	-122.451565786028	(37.7876694312425, -122.451565786028)
165795	165795	129398	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3729 Sacramento St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5997021.62902	2114999.75252	37.787214459718705	-122.454107547129	(37.7872144597187, -122.454107547129)
162331	162331	129397	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3729 Sacramento St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5997011.377730001	2114998.8497200003	37.7872113930486	-122.45414294896099	(37.7872113930486, -122.454142948961)

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