Street_Tree_List

Data source: data.sfgov.org

232 rows where DBH = 3 and qSpecies = 88 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, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate ▼	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
10860	10860	104506	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	631 France Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		3	3x3		6002582.75614	2089515.1433	37.7175570910528	-122.43304578096	(37.7175570910528, -122.43304578096)
25024	25024	208840	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1350 Plymouth Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		5995903.3540199995	2092975.62657	37.7266776159651	-122.456383367909	(37.7266776159651, -122.456383367909)
32597	32597	130988	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1000 Jones St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6008672.99088	2115994.19666	37.7906061691929	-122.41386657548	(37.7906061691929, -122.41386657548)
34906	34906	120793	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	559 21st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5989373.68445	2111524.6737	37.7772313596652	-122.48031303988998	(37.7772313596652, -122.48031303989)
36589	36589	177408	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	638 Edinburgh St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		6002397.88484	2090069.70643	37.71906931008821	-122.43372440936301	(37.7190693100882, -122.433724409363)
39423	39423	193355	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	60 Main St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		6013990.6766	2116456.52969	37.792172834057496	-122.39549995516701	(37.7921728340575, -122.395499955167)
39525	39525	208855	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	358 Mangels Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		5999047.687609999	2095262.2243	37.7331360864596	-122.445677914709	(37.7331360864596, -122.445677914709)
39564	39564	120406	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	619 23rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5988769.80583	2111094.18017	37.7760142347438	-122.48237047472901	(37.7760142347438, -122.482370474729)
43609	43609	177447	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	762 Prague St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6002442.748380001	2087164.23323	37.711094066412294	-122.433361825211	(37.7110940664123, -122.433361825211)
45146	45146	177401	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	263 Dublin St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6003956.36283	2088919.05641	37.7159981864394	-122.42825539008601	(37.7159981864394, -122.428255390086)
45725	45725	130982	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3601 Broderick St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		5999659.44076	2120919.3234599996	37.8036189320344	-122.44540711714701	(37.8036189320344, -122.445407117147)
49219	49219	247756	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	52 Alpine Ter	2	: 4	Tree 1	Private 1			3	Width 3ft		6001615.48849	2108494.65039	37.7696154359451	-122.437747736977	(37.7696154359451, -122.437747736977)
50385	50385	230282	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	175 Haight St	1	: 4	Tree 1	Private 1			3	Width 3ft		6005285.87309	2109545.94561	37.77271005706189	-122.425126806975	(37.7727100570619, -122.425126806975)
69069	69069	130976	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2801 Webster St	7	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 2ft		6002956.82977	2118266.12381	37.796521618235005	-122.433806601098	(37.796521618235, -122.433806601098)
71769	71769	177406	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	618 Edinburgh St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6002461.15734	2090172.80832	37.7193559950662	-122.433513065093	(37.7193559950662, -122.433513065093)
72311	72311	193321	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2111 18th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		6011418.14714	2105550.13938	37.7620829860523	-122.403633286154	(37.7620829860523, -122.403633286154)
73056	73056	123366	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	780 04th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5994765.69029	2110380.32738	37.774401141157796	-122.461577514019	(37.7744011411578, -122.461577514019)
75476	75476	208842	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	168 Dorantes Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5993717.6087	2099811.01881	37.7453201833801	-122.46443543703998	(37.7453201833801, -122.46443543704)
75481	75481	249813	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	260 Chestnut St	3	Front Yard : Yard 7	Tree 1	Private 1			3	Width 0ft		6010621.11973	2121031.8935700003	37.8045476726861	-122.407481446514	(37.8045476726861, -122.407481446514)
75641	75641	124612	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3931 Clay St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5995955.42177	2115180.15749	37.7876486084254	-122.457809430854	(37.7876486084254, -122.457809430854)
76787	76787	208846	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	36 De Montfort Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5995163.31564	2091909.32906	37.7237073072365	-122.45886447241999	(37.7237073072365, -122.45886447242)
82995	82995	99875	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1301X San Jose Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	3x3		6003616.3	2095455.7	37.733927108519204	-122.429896797189	(37.7339271085192, -122.429896797189)
84281	84281	26689	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1295X Pierce St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	4X4		6002245.89461	2112942.9215	37.7818651028046	-122.435885513106	(37.7818651028046, -122.435885513106)
115316	115316	109088	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	218 28th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		3	3x3		5987170.3	2114494.3	37.7852568239907	-122.488153421892	(37.7852568239907, -122.488153421892)
130952	130952	130996	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	48 Bonita St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		6006123.48756	2118486.00095	37.7973045284306	-122.422864892409	(37.7973045284306, -122.422864892409)
133119	133119	122152	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	263 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		5991173.60125	2113665.4764900003	37.783213842540796	-122.474242864812	(37.7832138425408, -122.474242864812)
134744	134744	230281	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	185 Haight St	1	: 4	Tree 1	Private 1			3	Width 3ft		6005261.48002	2109543.28647	37.772701377697004	-122.425210996096	(37.772701377697, -122.425210996096)
141933	141933	99876	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1295X San Jose Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	3x3		6003506.1	2095452.4	37.733911806121895	-122.43027755668899	(37.7339118061219, -122.430277556689)
147780	147780	193338	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1270 Minnesota St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6015308.81376	2102546.1179299997	37.754051150748	-122.389967001302	(37.754051150748, -122.389967001302)
148594	148594	130972	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2801 Webster St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 2ft		6002950.18497	2118317.4913	37.7966622830002	-122.433833266913	(37.7966622830002, -122.433833266913)
151066	151066	230349	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	222 Surrey St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		6001969.40377	2096197.83075	37.735871425709995	-122.43564368671801	(37.73587142571, -122.435643686718)
151893	151893	230300	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1225 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6010064.03861	2101924.1335400003	37.7520510531386	-122.408060919271	(37.7520510531386, -122.408060919271)
151949	151949	177427	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	145 Ney St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6004319.85704	2094053.89798	37.7301178924245	-122.427364559453	(37.7301178924245, -122.427364559453)
153469	153469	131001	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	937 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6007906.15602	2120261.72441	37.80228064460721	-122.416822257668	(37.8022806446072, -122.416822257668)
153491	153491	177399	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	908 Russia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		6003531.7567	2089652.07353	37.7179868563895	-122.429775281212	(37.7179868563895, -122.429775281212)
161888	161888	217796	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	21 Sloat Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 5ft		5991264.945169999	2095927.55542	37.7345154980788	-122.472633170284	(37.7345154980788, -122.472633170284)
165775	165775	249954	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	303 Filbert St	1	Side Yard : Yard 17	Tree 1	Private 1			3	Width 0ft		6011374.5207	2120037.6372700003	37.8018598293151	-122.404804177386	(37.8018598293151, -122.404804177386)
167906	167906	130986	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3147 Gough St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6004613.79741	2120397.19916	37.802466888808496	-122.42822508471599	(37.8024668888085, -122.428225084716)
171243	171243	177432	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	66 Gladstone Dr	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 2ft		6006350.82649	2094014.80407	37.730125204807	-122.420340452271	(37.730125204807, -122.420340452271)
171877	171877	130993	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1645 Washington St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6006795.77998	2117016.02483	37.793306252321294	-122.42043419129999	(37.7933062523213, -122.4204341913)
173077	173077	193354	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	75 Latona St	4	: 4	Tree 1	Private 1			3	Width 2ft		6014363.50892	2094164.90475	37.7309856140862	-122.392649861509	(37.7309856140862, -122.392649861509)
173626	173626	177407	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	626 Edinburgh St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		6002434.78266	2090132.2743	37.7192432011957	-122.433601337127	(37.7192432011957, -122.433601337127)
174376	174376	230291	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3623 18th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6005393.28111	2105446.83582	37.7614609474791	-122.424463649589	(37.7614609474791, -122.424463649589)
184007	184007	130975	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2801 Webster St	6	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 2ft		6002956.23707	2118277.75105	37.796553509993	-122.43380948344101	(37.796553509993, -122.433809483441)
184438	184438	119038	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	675 44th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5982249.27103	2111200.72651	37.7759253222044	-122.50493423498501	(37.7759253222044, -122.504934234985)
187466	187466	230302	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2908 25th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6009976.47339	2101651.34742	37.751297139764795	-122.408344495308	(37.7512971397648, -122.408344495308)
125818	125818	108706	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1683 Chattanooga St		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/02/2015 12:00:00 AM	3	3x3	Permit Number 774629	6004719.93732	2102694.114	37.7538645742471	-122.42659644528	(37.7538645742471, -122.42659644528)
9836	9836	6755	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1215 Fairfax Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/03/2017 06:41:00 AM	3	3x3		6017521.099066501	2096743.3718321999	37.7382404347673	-122.381912713319	(37.7382404347673, -122.381912713319)
13642	13642	33785	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013812.6799	2116223.3583	37.7915226979635	-122.39609948281701	(37.7915226979635, -122.396099482817)
13895	13895	33780	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013824.14126	2116210.79912	37.7914888510795	-122.39605894586	(37.7914888510795, -122.39605894586)
14233	14233	33800	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013865.37275	2116161.97621	37.7913570887062	-122.39591286179899	(37.7913570887062, -122.395912861799)
14247	14247	33783	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013842.9233800005	2116188.62598	37.7914290137913	-122.395992405042	(37.7914290137913, -122.395992405042)
14755	14755	33779	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013803.37475	2116233.23226	37.79154929181811	-122.396132371028	(37.7915492918181, -122.396132371028)
16231	16231	33782	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013852.02109	2116179.41654	37.7914042329729	-122.395960281264	(37.7914042329729, -122.395960281264)
16526	16526	33774	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013834.28126	2116198.48682	37.791455608540396	-122.396022998165	(37.7914556085404, -122.396022998165)
16533	16533	33792	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013856.54517	2116173.60161	37.7913885182281	-122.395944220262	(37.7913885182281, -122.395944220262)
10309	10309	108845	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	420 Woolsey St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3		Permit Number 772583	6010479.05335	2091857.99264	37.7244348155857	-122.405916697196	(37.7244348155857, -122.405916697196)
10963	10963	108843	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	420 Woolsey St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3		Permit Number 772583	6010519.109209999	2091869.71455	37.7244692416558	-122.40577905416201	(37.7244692416558, -122.405779054162)
41811	41811	108815	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	474 Munich St		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3	3x3	Permit Number 774652	6003779.44726	2089723.3814299998	37.7181966752665	-122.42892420414499	(37.7181966752665, -122.428924204145)
114640	114640	108839	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1112 Russia Ave		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3	3x3	Permit Number 770758	6003955.6442	2089384.8090099997	37.7172770009516	-122.42829104937599	(37.7172770009516, -122.428291049376)
144343	144343	108814	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	470 Munich St		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3	3x3	Permit Number 774651	6003792.96606	2089744.94608	37.7182566522639	-122.42887901198	(37.7182566522639, -122.42887901198)
145458	145458	108842	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	420 Woolsey St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3		Permit Number 772583	6010509.54502	2091864.19266	37.7244535448266	-122.405811727659	(37.7244535448266, -122.405811727659)
87298	87298	108921	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	33 Prospect Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/09/2015 12:00:00 AM	3	3x3	Permit Number 772690	6007205.6	2099297.0	37.7446770790021	-122.417759648925	(37.7446770790021, -122.417759648925)
84365	84365	108933	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	518 Banks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/12/2015 12:00:00 AM	3	3x3	Permit Number 773146	6008530.3	2096373.5	37.7367242478568	-122.41297241357	(37.7367242478568, -122.41297241357)
125226	125226	70167	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	831 45th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/12/2015 12:00:00 AM	3		Permit Number 773700	5981976.78091	2110066.45395	37.772794906459	-122.505792724366	(37.772794906459, -122.505792724366)
9960	9960	173748	Planning Code 138.1 required 4	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1259 21st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/13/2017 12:00:00 AM	3	3x3	Permit Number 773489	5989520.0	2106786.0	37.764228762563896	-122.47946011839899	(37.7642287625639, -122.479460118399)
143305	143305	13238	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2322 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/15/1998 12:00:00 AM	3	3X3		6001219.43305	2119376.81704	37.7994725475626	-122.439898035919	(37.7994725475626, -122.439898035919)
98825	98825	108994	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1819 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/20/2015 12:00:00 AM	3	3x3	Permit Number 773341	5993399.9	2103085.8	37.754293576097496	-122.465771900659	(37.7542935760975, -122.465771900659)
102366	102366	109037	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1306 29th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/22/2015 12:00:00 AM	3	3x3	Permit Number 772801	5987138.4	2106347.4	37.7628858653346	-122.487665061189	(37.7628858653346, -122.487665061189)
101450	101450	109486	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1314 POLK ST	1	Sidewalk: Curb side : Pot 10	Landscaping 2	DPW 2		01/23/2016 04:50:00 AM	3	3x3		6006825.7	2115468.8	37.7890596427133	-122.420220804515	(37.7890596427133, -122.420220804515)
112063	112063	109488	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1314 POLK ST	3	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		01/23/2016 04:53:00 AM	3	3x3		6006825.7	2115468.8	37.7890596427133	-122.420220804515	(37.7890596427133, -122.420220804515)
106292	106292	43751	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	255 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/24/2015 12:00:00 AM	3		Permit Number 773834	5991170.79793	2113718.28394	37.7833586747671	-122.474256417664	(37.7833586747671, -122.474256417664)
6628	6628	17981	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2583 Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/28/2014 12:00:00 AM	3	3x3		6001557.63	2114929.1565	37.7872796746141	-122.438408931359	(37.7872796746141, -122.438408931359)
10319	10319	109211	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	819 Brussels St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/04/2015 12:00:00 AM	3	3x3	Permit Number 773413	6011187.7232800005	2090968.5283099997	37.722032138266	-122.403404362845	(37.722032138266, -122.403404362845)
106309	106309	109276	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1558 45th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/05/2015 12:00:00 AM	3	3x3	Permit Number 773739	5982234.4	2104492.8	37.757506413032104	-122.504488595501	(37.7575064130321, -122.504488595501)
123584	123584	109253	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1355 46th Ave	1	Sidewalk: Curb side : Cutout 1	Landscaping 2	Private 1	FUF 1	02/05/2015 12:00:00 AM	3	3x3	Permit Number 773041	5981790.7	2105864.5	37.7612466017789	-122.50612476738199	(37.7612466017789, -122.506124767382)
14678	14678	59614	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1014 Tennessee St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/2011 12:00:00 AM	3	3x3	Permit Number 767137	6015492.62077	2104343.80938	37.7589974211239	-122.389456881532	(37.7589974211239, -122.389456881532)
118340	118340	52314	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	4284 23rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/12/2008 12:00:00 AM	3	3x3	Permit Number 50258	6001331.50265799	2102347.48483234	37.7527206699479	-122.438289584359	(37.7527206699479, -122.438289584359)
79964	79964	109389	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	174X Prospect Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/12/2015 12:00:00 AM	3	3x3	Permit Number 774921	6006834.59164	2098690.08898	37.74298975220871	-122.418999487845	(37.7429897522087, -122.418999487845)
84429	84429	5717	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1647 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/14/2008 12:00:00 AM	3	3X3		6005332.0180626	2098744.9227683996	37.7430555871926	-122.424198880257	(37.7430555871926, -122.424198880257)
155904	155904	93189	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	651 24th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/18/2010 12:00:00 AM	3	3x3	Permit Number 53197	5988441.61799	2111543.24899	37.77722815601879	-122.483538678985	(37.7772281560188, -122.483538678985)
88121	88121	71505	Private 5	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	328 San Carlos St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/18/2015 12:00:00 AM	3	3x3	Permit Number 774557	6006691.32680411	2104197.11487977	37.758102721165706	-122.41988555479601	(37.7581027211657, -122.419885554796)
84122	84122	115763	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	37 Crescent Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/24/2016 12:00:00 AM	3		Permit Number 771927	6005378.2	2095966.0	37.7354278990147	-122.42384163868799	(37.7354278990147, -122.423841638688)
51443	51443	105800	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	207 Raymond Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/27/2014 12:00:00 AM	3		Permit Number 769635	6010004.04754	2087785.0667299998	37.713224823850005	-122.407271751589	(37.71322482385, -122.407271751589)
11066	11066	109684	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	250 Maynard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/27/2015 12:00:00 AM	3	3x3	Permit Number 773450	6005044.41141	2093779.7607	37.729406123972296	-122.42484018495001	(37.7294061239723, -122.42484018495)
12772	12772	109685	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	266 Maynard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/27/2015 12:00:00 AM	3	3x3	Permit Number 775044	6005143.37702	2093783.4945099999	37.7294219655289	-122.424498316649	(37.7294219655289, -122.424498316649)
15812	15812	95581	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3881 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/01/2017 12:00:00 AM	3	3x3	Permit Number 779561	6003940.0	2101864.0	37.7515411523314	-122.429234461777	(37.7515411523314, -122.429234461777)
12835	12835	109714	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	250 Trumbull St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/02/2015 12:00:00 AM	3	3x3	Permit Number 772039	6005020.03097	2094315.2579700002	37.7308751035831	-122.424962554792	(37.7308751035831, -122.424962554792)
81558	81558	109735	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	4638 18th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/02/2015 12:00:00 AM	3	3x3	Permit Number 773846	6000314.1	2105235.6	37.760592809236	-122.442015220342	(37.760592809236, -122.442015220342)
90740	90740	18413	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	799X Potrero Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/05/2013 12:00:00 AM	3	4X4		6010481.346466599	2104567.7087473	37.759333078347105	-122.406804093165	(37.7593330783471, -122.406804093165)
86784	86784	105038	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	46 Atalaya Ter		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/05/2015 12:00:00 AM	3	3X4	Permit Number 771123	5998888.1	2110865.6	37.7759699989755	-122.44735231528401	(37.7759699989755, -122.447352315284)
101009	101009	12725	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1544 Lake St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/07/2003 12:00:00 AM	3	3X3		5990592.796680001	2114771.31925	37.7862165141869	-122.476332998319	(37.7862165141869, -122.476332998319)
40091	40091	95676	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	232 Goettingen St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/08/2011 12:00:00 AM	3	3x3	Permit Number 767428	6010063.65694	2093465.1071400002	37.7288243741431	-122.407465923318	(37.7288243741431, -122.407465923318)
22964	22964	109898	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1786 29th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/09/2015 12:00:00 AM	3	3x3	Permit Number 775112	5987249.9	2103123.1	37.754039320648495	-122.48704261510099	(37.7540393206485, -122.487042615101)
116356	116356	26561	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	430 Bay Shore Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/10/2007 12:00:00 AM	3	3X3		6010306.750370901	2097855.6706051	37.740893529599106	-122.406934857164	(37.7408935295991, -122.406934857164)
528	528	248942	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1500x Galvez Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2	Private 3	03/18/2017 12:56:00 PM	3	3x3		6016393.0	2097292.0	37.739684495027205	-122.385851388433	(37.7396844950272, -122.385851388433)
120650	120650	110031	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	92X Santa Ynez Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/19/2015 12:00:00 AM	3	3x3	Permit Number 774272	6000673.3536	2092054.19092	37.7244202473951	-122.439827638683	(37.7244202473951, -122.439827638683)
63085	63085	65128	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	184 20th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/31/2008 12:00:00 AM	3	3x3	Permit Number 50320	5989636.73328	2114131.59369	37.7844045165702	-122.47959386665	(37.7844045165702, -122.47959386665)
505	505	6741	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1300X Fairfax Ave	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/10/2017 01:50:00 PM	3	3x3		6016924.03316	2097256.8815900004	37.739617439282604	-122.38401284003099	(37.7396174392826, -122.384012840031)
500	500	6742	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1300X Fairfax Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/10/2017 01:53:00 PM	3	3x3		6016901.500630001	2097278.26947	37.7396749203573	-122.384092237585	(37.7396749203573, -122.384092237585)

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