Street_Tree_List

Data source: data.sfgov.org

138 rows where PlotSize = "Width 3ft" and qSpecies = 30 sorted by rowid 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
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)
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)
187174	187174	122008	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2650 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990390.42893	2112003.07059	37.7786039357458	-122.476830795247	(37.7786039357458, -122.476830795247)
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)
186485	186485	207063	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	134 Taraval St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993031.18209	2099190.3171200003	37.7435763017135	-122.46676385469401	(37.7435763017135, -122.466763854694)
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)
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)
184598	184598	207080	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1648 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5992494.37113	2104224.8500200002	37.75736883521821	-122.46898630879299	(37.7573688352182, -122.468986308793)
183793	183793	207061	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	134 Taraval St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5993037.74509	2099188.24411	37.7435709885186	-122.466741010989	(37.7435709885186, -122.466741010989)
183467	183467	207095	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1565 Plymouth Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 3ft		5995634.15192	2094407.3594099998	37.730593351393296	-122.457417521726	(37.7305933513933, -122.457417521726)
183459	183459	207081	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1967 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5992237.024130001	2102091.85973	37.751497327037605	-122.46972102612601	(37.7514973270376, -122.469721026126)
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)
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)
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)
178480	178480	119541	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	823 30th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5986627.47166	2110288.5169900004	37.773677258601	-122.48972200943399	(37.773677258601, -122.489722009434)
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)
178142	178142	207065	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	134 Taraval St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5993024.9505900005	2099189.6741400003	37.743574176615894	-122.46678535477301	(37.7435741766159, -122.466785354773)
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)
175198	175198	207091	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	520 Wawona St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5991320.331130001	2097065.30066	37.7376426638631	-122.47252460501998	(37.7376426638631, -122.47252460502)
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)
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)
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)
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)
170832	170832	207092	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2655 16th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991411.795390001	2097355.25398	37.738444095618	-122.4722295024	(37.738444095618, -122.4722295024)
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)
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)
168777	168777	207093	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2469 14th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992014.45058	2098646.31177	37.742023871309	-122.47023982251801	(37.742023871309, -122.470239822518)
168739	168739	207051	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1264 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5992092.816880001	2106815.43538	37.764458690039	-122.47056370526899	(37.764458690039, -122.470563705269)
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)
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)
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)
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)
164375	164375	207088	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1400 Ulloa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991634.58199	2098444.51298	37.7414478141662	-122.47153857305	(37.7414478141662, -122.47153857305)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
156929	156929	217749	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	445 West Portal Ave	1	: 4	Tree 1	Private 1			2	Width 3ft		5991783.05973	2096405.3403	37.7358573522267	-122.470876685538	(37.7358573522267, -122.470876685538)
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)
155887	155887	207084	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2093 10th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5993169.3721900005	2101262.29203	37.7492733917544	-122.46643659227101	(37.7492733917544, -122.466436592271)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
147671	147671	207068	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	539 Vicente St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5991225.79939	2097692.69128	37.739359846476205	-122.472897178881	(37.7393598464762, -122.472897178881)
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)
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)
136118	136118	250773	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	259 32nd Ave	1	: 4	Tree 1	Private 1			14	Width 3ft		5985865.92055	2114194.89594	37.7843585636424	-122.492644052605	(37.7843585636424, -122.492644052605)
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)
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)
131020	131020	117942	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	6300 Fulton St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5983781.64788	2109717.73118	37.7719434782971	-122.499523806885	(37.7719434782971, -122.499523806885)
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)
109199	109199	122009	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2629 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990447.70869	2111948.34575	37.77845699894	-122.476628645569	(37.77845699894, -122.476628645569)
77081	77081	207086	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2167 18th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990677.28316	2100628.1103	37.747387978366106	-122.475007906598	(37.7473879783661, -122.475007906598)
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)
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)
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)
74868	74868	121865	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	574 18th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5990352.3789099995	2111462.4285	37.7771172745488	-122.476922909403	(37.7771172745488, -122.476922909403)
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)
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)
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)
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)
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)
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)
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)
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)
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)
69772	69772	207085	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2091 10th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5993168.90781	2101284.1521799997	37.749333387335895	-122.466439786693	(37.7493333873359, -122.466439786693)
67199	67199	207064	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	134 Taraval St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5993028.0499599995	2099189.22218	37.743573114522206	-122.466774605159	(37.7435731145222, -122.466774605159)
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)
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)
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)
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)
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)
62582	62582	207087	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1400 Ulloa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991668.56365	2098444.306	37.7414492117217	-122.471421062245	(37.7414492117217, -122.471421062245)
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)
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)
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)
59463	59463	207089	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1400 Ulloa St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991620.77866	2098444.2951599997	37.7414464175195	-122.471586283874	(37.7414464175195, -122.471586283874)
59171	59171	207090	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1400 Ulloa St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5991605.432	2098443.60055	37.741443622419894	-122.47163929621	(37.7414436224199, -122.47163929621)
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)
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)
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)

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