Street_Tree_List

Data source: data.sfgov.org

222 rows where PlotSize = "Width 3ft" and qSpecies = 97 sorted by Location

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location ▼
26761	26761	175842	Undocumented 2	Ceratonia siliqua :: Carob 97	234 Vienna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6004274.97667	2092050.6197400002	37.724614796925	-122.427377064513	(37.724614796925, -122.427377064513)
176670	176670	175843	Undocumented 2	Ceratonia siliqua :: Carob 97	154 Vienna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6004555.98826	2092507.33419	37.7258847232758	-122.42643814711501	(37.7258847232758, -122.426438147115)
73260	73260	205990	Undocumented 2	Ceratonia siliqua :: Carob 97	452 Kenwood Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5993405.09676	2093676.5167599998	37.7284583518695	-122.46507057606001	(37.7284583518695, -122.46507057606)
45186	45186	205991	Undocumented 2	Ceratonia siliqua :: Carob 97	452 Kenwood Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5993388.91946	2093682.37508	37.72847350453279	-122.465126926677	(37.7284735045328, -122.465126926677)
65825	65825	205992	Undocumented 2	Ceratonia siliqua :: Carob 97	452 Kenwood Way	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5993371.398019999	2093686.3141400001	37.728483309840996	-122.46518778469299	(37.728483309841, -122.465187784693)
151522	151522	206017	Undocumented 2	Ceratonia siliqua :: Carob 97	59 Hazelwood Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5996580.0039099995	2094034.75678	37.72962455671671	-122.454120687124	(37.7296245567167, -122.454120687124)
67325	67325	206015	Undocumented 2	Ceratonia siliqua :: Carob 97	351 Montecito Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 3ft		5995922.8819	2094068.30815	37.7296789783055	-122.45639483786199	(37.7296789783055, -122.456394837862)
43464	43464	206016	Undocumented 2	Ceratonia siliqua :: Carob 97	1500 Plymouth Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5995893.6658	2094152.61505	37.7299087874515	-122.45650193453899	(37.7299087874515, -122.456501934539)
166137	166137	189911	Undocumented 2	Ceratonia siliqua :: Carob 97	1 Flora St	7	: 4	Tree 1	Private 1			5	Width 3ft		6013879.72064	2094387.8060700002	37.73157077506371	-122.394338012196	(37.7315707750637, -122.394338012196)
67550	67550	189912	Undocumented 2	Ceratonia siliqua :: Carob 97	1 Flora St	8	: 4	Tree 1	Private 1			4	Width 3ft		6013884.75868	2094408.4745200002	37.7316278064595	-122.394322041155	(37.7316278064595, -122.394322041155)
72242	72242	189913	Undocumented 2	Ceratonia siliqua :: Carob 97	1 Flora St	9	: 4	Tree 1	Private 1			6	Width 3ft		6013888.27035	2094422.90108	37.731667614051	-122.39431091023	(37.731667614051, -122.39431091023)
173975	173975	189914	Undocumented 2	Ceratonia siliqua :: Carob 97	1 Flora St	11	: 4	Tree 1	Private 1			5	Width 3ft		6013894.185819999	2094452.33408	37.7317487598799	-122.394292519091	(37.7317487598799, -122.394292519091)
74016	74016	189915	Undocumented 2	Ceratonia siliqua :: Carob 97	1 Flora St	13	: 4	Tree 1	Private 1			5	Width 3ft		6013899.07383	2094479.41823	37.7318233991302	-122.394277515688	(37.7318233991302, -122.394277515688)
54347	54347	206013	Undocumented 2	Ceratonia siliqua :: Carob 97	130 San Benito Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5992845.13508	2095810.8192900002	37.7342863121439	-122.467161490835	(37.7342863121439, -122.467161490835)
132092	132092	206014	Undocumented 2	Ceratonia siliqua :: Carob 97	120 San Benito Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5992843.12782	2095854.05613	37.7344049138512	-122.467171573123	(37.7344049138512, -122.467171573123)
42068	42068	205999	Undocumented 2	Ceratonia siliqua :: Carob 97	60 Chilton Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6001682.52176	2095686.8275900001	37.7344520302196	-122.436598984369	(37.7344520302196, -122.436598984369)
59009	59009	206021	Undocumented 2	Ceratonia siliqua :: Carob 97	42 Stanford Heights Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		5997867.55836	2095818.65061	37.7345964514605	-122.449798003996	(37.7345964514605, -122.449798003996)
154109	154109	225081	Undocumented 2	Ceratonia siliqua :: Carob 97	181 College Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6004907.37106	2095955.144	37.7353714997996	-122.42546869953199	(37.7353714997996, -122.425468699532)
32281	32281	225053	Undocumented 2	Ceratonia siliqua :: Carob 97	300 Sussex St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6001218.80684	2096592.16387	37.736911510559295	-122.438267032523	(37.7369115105593, -122.438267032523)
154480	154480	225052	Undocumented 2	Ceratonia siliqua :: Carob 97	375 Sussex St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6000953.83658	2096674.2134099999	37.737121725291296	-122.439189029173	(37.7371217252913, -122.439189029173)
65489	65489	225056	Undocumented 2	Ceratonia siliqua :: Carob 97	354 Sussex St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6001081.74278	2096696.02818	37.737188901044995	-122.43874836315399	(37.737188901045, -122.438748363154)
171108	171108	206012	Undocumented 2	Ceratonia siliqua :: Carob 97	650 Vicente St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5990870.16608	2097736.47672	37.739459475161794	-122.474129983014	(37.7394594751618, -122.474129983014)
45525	45525	206011	Undocumented 2	Ceratonia siliqua :: Carob 97	650 Vicente St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5990881.65673	2097736.82059	37.739461084972206	-122.47409027886299	(37.7394610849722, -122.474090278863)
172191	172191	206010	Undocumented 2	Ceratonia siliqua :: Carob 97	650 Vicente St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5990906.39798	2097737.17838	37.7394635005399	-122.47400476141199	(37.7394635005399, -122.474004761412)
164290	164290	206009	Undocumented 2	Ceratonia siliqua :: Carob 97	650 Vicente St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5990946.443519999	2097737.21302	37.7394659152092	-122.47386630538	(37.7394659152092, -122.47386630538)
44285	44285	206008	Undocumented 2	Ceratonia siliqua :: Carob 97	600 Vicente St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5990990.06403	2097739.22497	37.7394739659536	-122.47371563298701	(37.7394739659536, -122.473715632987)
74726	74726	206007	Undocumented 2	Ceratonia siliqua :: Carob 97	600 Vicente St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5991032.21326	2097741.2680200003	37.739482016692904	-122.473570049822	(37.7394820166929, -122.473570049822)
150091	150091	206006	Undocumented 2	Ceratonia siliqua :: Carob 97	600 Vicente St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5991049.3393	2097743.54574	37.7394892625221	-122.473511002145	(37.7394892625221, -122.473511002145)
157059	157059	206005	Undocumented 2	Ceratonia siliqua :: Carob 97	600 Vicente St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5991064.94409	2097743.51009	37.7394900683054	-122.47345704553001	(37.7394900683054, -122.47345704553)
75887	75887	225065	Undocumented 2	Ceratonia siliqua :: Carob 97	219 Bonview St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6006960.17815	2097772.4528099997	37.740477199257704	-122.418500188445	(37.7404771992577, -122.418500188445)
163194	163194	189875	Undocumented 2	Ceratonia siliqua :: Carob 97	400 Newhall St	15	: 4	Tree 1	Private 1			12	Width 3ft		6015903.72942	2097762.72481	37.740949921590904	-122.387575924289	(37.7409499215909, -122.387575924289)
46617	46617	189864	Undocumented 2	Ceratonia siliqua :: Carob 97	501 Newhall St	1	: 4	Tree 1	Private 1			16	Width 3ft		6015974.53489	2097767.4819400003	37.7409669053009	-122.387331434622	(37.7409669053009, -122.387331434622)
165750	165750	189871	Undocumented 2	Ceratonia siliqua :: Carob 97	400 Newhall St	9	: 4	Tree 1	Private 1			7	Width 3ft		6016028.58203	2097927.48174	37.741409225160396	-122.387155715173	(37.7414092251604, -122.387155715173)
182504	182504	189867	Undocumented 2	Ceratonia siliqua :: Carob 97	401 Newhall St	2	: 4	Tree 1	Private 1			16	Width 3ft		6016089.46635	2097928.7080599996	37.7414159637784	-122.38694528191999	(37.7414159637784, -122.38694528192)
130575	130575	189868	Undocumented 2	Ceratonia siliqua :: Carob 97	401 Newhall St	3	: 4	Tree 1	Private 1			7	Width 3ft		6016117.80915	2097961.55377	37.7415077207098	-122.38684957154899	(37.7415077207098, -122.386849571549)
69864	69864	189869	Undocumented 2	Ceratonia siliqua :: Carob 97	401 Newhall St	4	: 4	Tree 1	Private 1			13	Width 3ft		6016127.95859	2097976.0947	37.7415482090816	-122.38681549176	(37.7415482090816, -122.38681549176)
39389	39389	189870	Undocumented 2	Ceratonia siliqua :: Carob 97	401 Newhall St	5	: 4	Tree 1	Private 1			13	Width 3ft		6016138.74056	2097991.9117	37.741592236291396	-122.386779313807	(37.7415922362914, -122.386779313807)
137584	137584	189851	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	15	: 4	Tree 1	Private 1			12	Width 3ft		6017359.84801	2098072.09609	37.741879938402704	-122.38256267332198	(37.7418799384027, -122.382562673322)
131495	131495	189850	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	14	: 4	Tree 1	Private 1			9	Width 3ft		6017345.725190001	2098082.05897	37.7419065142755	-122.382612199015	(37.7419065142755, -122.382612199015)
33099	33099	189852	Undocumented 2	Ceratonia siliqua :: Carob 97	100 Newhall St	2	: 4	Tree 1	Private 1			8	Width 3ft		6017365.88907	2098130.81013	37.7420414890213	-122.38254586948999	(37.7420414890213, -122.38254586949)
179431	179431	189853	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	1	: 4	Tree 1	Private 1			8	Width 3ft		6017352.03209	2098141.27696	37.742069463331106	-122.382594511142	(37.7420694633311, -122.382594511142)
60830	60830	189847	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	9	: 4	Tree 1	Private 1			1	Width 3ft		6017231.39271	2098158.2223400003	37.7421093266962	-122.383012827183	(37.7421093266962, -122.383012827183)
131320	131320	189846	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	8	: 4	Tree 1	Private 1			1	Width 3ft		6017214.17115	2098166.7194	37.7421317063069	-122.383072965771	(37.7421317063069, -122.383072965771)
32657	32657	189845	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	7	: 4	Tree 1	Private 1			6	Width 3ft		6017192.34248	2098175.05438	37.7421533862633	-122.383149023221	(37.7421533862633, -122.383149023221)
184302	184302	189844	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6017173.06513	2098183.08322	37.742174366561606	-122.383216237654	(37.7421743665616, -122.383216237654)
173588	173588	189854	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	4	: 4	Tree 1	Private 1			10	Width 3ft		6017283.71117	2098187.47887	37.742192549946104	-122.38283396012599	(37.7421925499461, -122.382833960126)
157640	157640	189843	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	5	: 4	Tree 1	Private 1			1	Width 3ft		6017155.58292	2098191.33075	37.742196046505	-122.38327726024599	(37.742196046505, -122.383277260246)
147716	147716	189842	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	4	: 4	Tree 1	Private 1			7	Width 3ft		6017136.0861599995	2098201.14709	37.7422219227174	-122.383345357813	(37.7422219227174, -122.383345357813)
38544	38544	189841	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	3	: 4	Tree 1	Private 1			1	Width 3ft		6017113.188630001	2098207.21128	37.742237308295294	-122.38342495321899	(37.7422373082953, -122.383424953219)
26487	26487	189910	DPW Maintained 3	Ceratonia siliqua :: Carob 97	350 Newhall St	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14	Width 3ft		6016250.22154	2098227.10108	37.742244189916704	-122.386410241063	(37.7422441899167, -122.386410241063)
158918	158918	189855	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	5	: 4	Tree 1	Private 1			9	Width 3ft		6017245.40272	2098209.38961	37.7422505957884	-122.382967944715	(37.7422505957884, -122.382967944715)
160768	160768	189840	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	2	: 4	Tree 1	Private 1			3	Width 3ft		6017094.37686	2098212.93845	37.7422519942486	-122.383490397763	(37.7422519942486, -122.383490397763)
132013	132013	189839	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	1	: 4	Tree 1	Private 1			1	Width 3ft		6017074.26086	2098217.41845	37.7422631836031	-122.38356026519699	(37.7422631836031, -122.383560265197)
156617	156617	189856	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	6	: 4	Tree 1	Private 1			6	Width 3ft		6017223.11391	2098220.2806700002	37.742279268865104	-122.383045771154	(37.7422792688651, -122.383045771154)
163101	163101	189909	DPW Maintained 3	Ceratonia siliqua :: Carob 97	350 Newhall St	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			9	Width 3ft		6016264.27306	2098246.63974	37.7422986168968	-122.386363016745	(37.7422986168968, -122.386363016745)
162643	162643	189859	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	9	: 4	Tree 1	Private 1			7	Width 3ft		6017171.36242	2098242.65136	37.7423378345214	-122.38322627048001	(37.7423378345214, -122.38322627048)
170703	170703	189886	Undocumented 2	Ceratonia siliqua :: Carob 97	201 Newhall St	7	: 4	Tree 1	Private 1			6	Width 3ft		6016892.13311	2098254.09694	37.7423538271607	-122.384192566831	(37.7423538271607, -122.384192566831)
135439	135439	189860	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	10	: 4	Tree 1	Private 1			7	Width 3ft		6017146.31011	2098252.64566	37.74236389238379	-122.38331359014299	(37.7423638923838, -122.383313590143)
49848	49848	189861	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	11	: 4	Tree 1	Private 1			8	Width 3ft		6017125.66493	2098258.40905	37.742378576526	-122.38338537673799	(37.742378576526, -122.383385376738)
156493	156493	189885	Undocumented 2	Ceratonia siliqua :: Carob 97	201 Newhall St	6	: 4	Tree 1	Private 1			3	Width 3ft		6016834.26905	2098267.19561	37.7423865939792	-122.38439355723601	(37.7423865939792, -122.384393557236)
156633	156633	189862	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	12	: 4	Tree 1	Private 1			7	Width 3ft		6017103.28687	2098264.2675900003	37.7423934261135	-122.383463161819	(37.7423934261135, -122.383463161819)
67535	67535	189863	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	13	: 4	Tree 1	Private 1			9	Width 3ft		6017087.002669999	2098268.01639	37.742402819541795	-122.383519729148	(37.7424028195418, -122.383519729148)
168105	168105	189908	DPW Maintained 3	Ceratonia siliqua :: Carob 97	350 Newhall St	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			8	Width 3ft		6016294.30511	2098287.7036099997	37.7424130322313	-122.38626203636998	(37.7424130322313, -122.38626203637)
74900	74900	189884	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	12	: 4	Tree 1	Private 1			8	Width 3ft		6016685.38219	2098298.11667	37.7424632629752	-122.384910521712	(37.7424632629752, -122.384910521712)
132365	132365	189887	Undocumented 2	Ceratonia siliqua :: Carob 97	200 Newhall St	1	: 4	Tree 1	Private 1			10	Width 3ft		6016910.34518	2098303.24769	37.742489792067104	-122.384133016442	(37.7424897920671, -122.384133016442)
135669	135669	189883	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	9	: 4	Tree 1	Private 1			8	Width 3ft		6016619.88237	2098309.8227	37.7424917822737	-122.38513781816201	(37.7424917822737, -122.385137818162)
38692	38692	189888	Undocumented 2	Ceratonia siliqua :: Carob 97	200 Newhall St	2	: 4	Tree 1	Private 1			6	Width 3ft		6016891.26784	2098307.49665	37.7425004040788	-122.384199276697	(37.7425004040788, -122.384199276697)
62858	62858	189876	Undocumented 2	Ceratonia siliqua :: Carob 97	375 Newhall St	8	: 4	Tree 1	Private 1			8	Width 3ft		6016406.62692	2098319.91707	37.7425077002596	-122.385875902556	(37.7425077002596, -122.385875902556)
130083	130083	189882	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	7	: 4	Tree 1	Private 1			9	Width 3ft		6016580.99088	2098317.85278	37.742511679775205	-122.385272854085	(37.7425116797752, -122.385272854085)
65891	65891	189889	Undocumented 2	Ceratonia siliqua :: Carob 97	200 Newhall St	3	: 4	Tree 1	Private 1			7	Width 3ft		6016866.9099	2098314.50918	37.7425183122785	-122.38428398832501	(37.7425183122785, -122.384283988325)
135246	135246	189881	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	6	: 4	Tree 1	Private 1			10	Width 3ft		6016559.498980001	2098322.6337200003	37.7425236182725	-122.385347500499	(37.7425236182725, -122.385347500499)
74473	74473	189880	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	5	: 4	Tree 1	Private 1			7	Width 3ft		6016536.79452	2098327.4391099997	37.742535556771	-122.385426341355	(37.742535556771, -122.385426341355)
27659	27659	189891	Undocumented 2	Ceratonia siliqua :: Carob 97	200 Newhall St	5	: 4	Tree 1	Private 1			4	Width 3ft		6016826.79146	2098321.83879	37.7425362195639	-122.384423217764	(37.7425362195639, -122.384423217764)
167349	167349	189877	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	2	: 4	Tree 1	Private 1			7	Width 3ft		6016448.8562900005	2098333.07564	37.7425461678608	-122.38573080145099	(37.7425461678608, -122.385730801451)
166172	166172	189893	Undocumented 2	Ceratonia siliqua :: Carob 97	200 Newhall St	7	: 4	Tree 1	Private 1			10	Width 3ft		6016784.24817	2098329.2173099997	37.7425541268854	-122.384570835175	(37.7425541268854, -122.384570835175)
157879	157879	189879	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	4	: 4	Tree 1	Private 1			8	Width 3ft		6016498.145380001	2098335.4641	37.7425554533749	-122.385560539098	(37.7425554533749, -122.385560539098)
181190	181190	189878	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	3	: 4	Tree 1	Private 1			7	Width 3ft		6016474.87335	2098336.17477	37.742556117060104	-122.38564105721399	(37.7425561170601, -122.385641057214)
77182	77182	189905	Undocumented 2	Ceratonia siliqua :: Carob 97	350 Newhall St	6	: 4	Tree 1	Private 1			12	Width 3ft		6016340.3864	2098339.29531	37.7425572430226	-122.386106295385	(37.7425572430226, -122.386106295385)
54002	54002	189894	Undocumented 2	Ceratonia siliqua :: Carob 97	200 Newhall St	8	: 4	Tree 1	Private 1			10	Width 3ft		6016764.20599	2098333.7275	37.742565402576794	-122.384640449909	(37.7425654025768, -122.384640449909)
66110	66110	189895	Undocumented 2	Ceratonia siliqua :: Carob 97	220 Newhall St	2	: 4	Tree 1	Private 1			9	Width 3ft		6016704.91422	2098345.41637	37.7425942186412	-122.384846279543	(37.7425942186412, -122.384846279543)
165324	165324	189897	Undocumented 2	Ceratonia siliqua :: Carob 97	220 Newhall St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6016662.64586	2098353.63161	37.742614438102706	-122.384993004817	(37.7426144381027, -122.384993004817)
74466	74466	189898	Undocumented 2	Ceratonia siliqua :: Carob 97	220 Newhall St	5	: 4	Tree 1	Private 1			10	Width 3ft		6016641.64949	2098357.6793299997	37.7426243909147	-122.385065886799	(37.7426243909147, -122.385065886799)
168386	168386	189904	DPW Maintained 3	Ceratonia siliqua :: Carob 97	350 Newhall St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			11	Width 3ft		6016400.23461	2098374.6941	37.742657753052505	-122.38590182282499	(37.7426577530525, -122.385901822825)
155880	155880	189903	Undocumented 2	Ceratonia siliqua :: Carob 97	350 Newhall St	3	: 4	Tree 1	Private 1			11	Width 3ft		6016414.85135	2098379.02943	37.742670465863796	-122.38585158400801	(37.7426704658638, -122.385851584008)
55275	55275	189902	DPW Maintained 3	Ceratonia siliqua :: Carob 97	350 Newhall St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	Width 3ft		6016433.67399	2098382.99048	37.7426823836985	-122.385786776164	(37.7426823836985, -122.385786776164)
165480	165480	189901	DPW Maintained 3	Ceratonia siliqua :: Carob 97	350 Newhall St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			7	Width 3ft		6016452.46192	2098385.2163400003	37.742689535099395	-122.385721967406	(37.7426895350994, -122.385721967406)
130592	130592	189900	Undocumented 2	Ceratonia siliqua :: Carob 97	300 Newhall St	8	: 4	Tree 1	Private 1			10	Width 3ft		6016469.439569999	2098386.38148	37.7426936737758	-122.38566334421199	(37.7426936737758, -122.385663344212)
173621	173621	189899	Undocumented 2	Ceratonia siliqua :: Carob 97	300 Newhall St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6016506.94741	2098386.01279	37.7426947367801	-122.385533625971	(37.7426947367801, -122.385533625971)
60186	60186	248270	Undocumented 2	Ceratonia siliqua :: Carob 97	157 Lundy's Ln	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6006694.18006	2098651.40644	37.7428756308979	-122.419482249905	(37.7428756308979, -122.419482249905)
167049	167049	248271	Undocumented 2	Ceratonia siliqua :: Carob 97	157 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6006700.68835	2098666.52237	37.7429175024299	-122.419460818167	(37.7429175024299, -122.419460818167)
50402	50402	248264	Undocumented 2	Ceratonia siliqua :: Carob 97	140 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6006711.60121	2098736.3727599997	37.743109910586	-122.419428038785	(37.743109910586, -122.419428038785)
68659	68659	248263	Undocumented 2	Ceratonia siliqua :: Carob 97	140 Lundy's Ln	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6006717.3063	2098747.87418	37.743141812234505	-122.41940912783899	(37.7431418122345, -122.419409127839)
135232	135232	248274	Undocumented 2	Ceratonia siliqua :: Carob 97	137 Lundy's Ln	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6006747.61558	2098750.1570099997	37.743149787441	-122.419304488116	(37.743149787441, -122.419304488116)
45389	45389	248262	Undocumented 2	Ceratonia siliqua :: Carob 97	136 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 3ft		6006723.28629	2098755.01317	37.743161751109	-122.41938895693	(37.743161751109, -122.41938895693)
46452	46452	248275	Undocumented 2	Ceratonia siliqua :: Carob 97	137 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6006752.53211	2098758.7700799997	37.743173713897	-122.41928809889299	(37.743173713897, -122.419288098893)
183547	183547	248276	Undocumented 2	Ceratonia siliqua :: Carob 97	137 Lundy's Ln	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6006755.61156	2098766.6947	37.7431956465585	-122.41927801298401	(37.7431956465585, -122.419278012984)
104259	104259	248261	Undocumented 2	Ceratonia siliqua :: Carob 97	136 Lundy's Ln	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6006731.57977	2098768.277	37.7431986377163	-122.419361220966	(37.7431986377163, -122.419361220966)
165360	165360	248260	Undocumented 2	Ceratonia siliqua :: Carob 97	132 Lundy's Ln	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6006738.11061	2098784.48151	37.7432434994904	-122.419339788302	(37.7432434994904, -122.419339788302)
66722	66722	248258	Undocumented 2	Ceratonia siliqua :: Carob 97	120 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6006769.1868199995	2098841.93634	37.7434030077589	-122.41923640944201	(37.7434030077589, -122.419236409442)
179238	179238	248257	Undocumented 2	Ceratonia siliqua :: Carob 97	120 Lundy's Ln	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6006778.60351	2098856.6294	37.7434438819296	-122.41920489088899	(37.7434438819296, -122.419204890889)

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