Street_Tree_List

Data source: data.sfgov.org

485 rows where qLegalStatus = 3 and qSpecies = 100 sorted by qAddress

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, PlantDate, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
17252	17252	24963	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			90	20		6004800.736959999	2107633.50365	37.7674315357679	-122.42666873508999	(37.7674315357679, -122.42666873509)
19333	19333	24968	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 Dolores St	9	Median : Cutout 11	Tree 1	DPW 2			90	20		6004810.58196	2107534.1310400004	37.767159239034704	-122.426627605497	(37.7671592390347, -122.426627605497)
19334	19334	24962	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 Dolores St	3	Median : Cutout 11	Tree 1	DPW 2		04/21/2005 12:00:00 AM	30	20		6004805.8872	2107667.07109	37.76752399506629	-122.42665331171999	(37.7675239950663, -122.42665331172)
19826	19826	24965	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 Dolores St	6	Median : Cutout 11	Tree 1	DPW 2			90	20		6004804.04595	2107595.6918	37.767327900586	-122.42665459683799	(37.767327900586, -122.426654596838)
20452	20452	24966	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 Dolores St	7	Median : Cutout 11	Tree 1	DPW 2			90	20		6004812.73188	2107584.41194	37.76729741985871	-122.426623750096	(37.7672974198587, -122.426623750096)
22009	22009	24961	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 Dolores St	1	Median : Cutout 11	Tree 1	DPW 2		04/21/2005 12:00:00 AM	90	20		6004800.95891	2107734.51921	37.76770891277079	-122.42667516163999	(37.7677089127708, -122.42667516164)
15304	15304	19794	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 STAIRWAY19	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	50ST
11148	11148	20065	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 STAIRWAY54	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	15ST
81526	81526	103927	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	13	Median : Cutout 11	Tree 1	DPW 2		02/05/2001 12:00:00 AM		4x4		6014859.0	2117030.0	37.793795709183996	-122.392535650186	(37.793795709184, -122.392535650186)
17056	17056	25058	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000X Dolores St	1	Median : Cutout 11	Tree 1	DPW 2			90	20		6005092.48697	2102458.1018	37.753237594341996	-122.425291287561	(37.753237594342, -122.425291287561)
17722	17722	25061	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000X Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			90	20		6005097.79962	2102345.06954	37.7529275341834	-122.425264872687	(37.7529275341834, -122.425264872687)
21757	21757	25064	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000X Dolores St	7	Median : Cutout 11	Tree 1	DPW 2			40	20		6005102.4225699995	2102227.07793	37.7526038178156	-122.425240490271	(37.7526038178156, -122.425240490271)
22227	22227	25067	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000X Dolores St	10	Median : Cutout 11	Tree 1	DPW 2			40	20		6005110.57075	2102123.34784	37.7523194593995	-122.425204931964	(37.7523194593995, -122.425204931964)
47801	47801	234359	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x Dolores St	13	Median : Yard 3	Tree 1	DPW 2			31			6005116.63925	2102018.48994	37.752031886768705	-122.42517648553302	(37.7520318867687, -122.425176485533)
27286	27286	132113	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6013330.52243	2119204.92075	37.7996825238869	-122.39797700193701	(37.7996825238869, -122.397977001937)
58367	58367	132070	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	1	Median : Cutout 11	Tree 1	DPW 2			23	Width 5ft		6013297.802519999	2119184.84583	37.7996255806051	-122.39808881644501	(37.7996255806051, -122.398088816445)
62709	62709	132071	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6013261.919290001	2119233.02284	37.7997558644996	-122.39821636821199	(37.7997558644996, -122.398216368212)
66065	66065	132114	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6013298.81612	2119255.09608	37.799818527453105	-122.39809024008001	(37.7998185274531, -122.39809024008)
68393	68393	132116	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6013189.6161	2119421.22304	37.800268589579204	-122.39847977871901	(37.8002685895792, -122.398479778719)
115831	115831	132073	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6013155.58738	2119398.1180000002	37.800203252927105	-122.39859590999501	(37.8002032529271, -122.398595909995)
131771	131771	132074	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6013098.86351	2119482.52775	37.800431861502396	-122.39879812525601	(37.8004318615024, -122.398798125256)
133036	133036	132072	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6013209.184309999	2119314.66631	37.799977100409	-122.39840458371201	(37.799977100409, -122.398404583712)
137882	137882	132117	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			17	Width 10ft		6013132.776319999	2119506.7755299998	37.800500329583	-122.398682475136	(37.800500329583, -122.398682475136)
147998	147998	132115	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6013243.85901	2119336.7003900004	37.8000395322586	-122.398286142085	(37.8000395322586, -122.398286142085)
16962	16962	25071	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100X Dolores St	2	Median : Cutout 11	Tree 1	DPW 2			80	20		6005127.376540001	2101840.69033	37.751544296835206	-122.42512670443001	(37.7515442968352, -122.42512670443)
18230	18230	25073	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100X Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			90	20		6005132.2187	2101761.89405	37.7513282140435	-122.42510435359199	(37.7513282140435, -122.425104353592)
18432	18432	25070	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100X Dolores St	1	Median : Cutout 11	Tree 1	DPW 2			80	20		6005125.726319999	2101888.99536	37.751676838028395	-122.425135847862	(37.7516768380284, -122.425135847862)
20762	20762	25074	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100X Dolores St	5	Median : Cutout 11	Tree 1	DPW 2			70	20		6005132.37065	2101712.1567700002	37.751191655576	-122.425100289545	(37.751191655576, -122.425100289545)
21721	21721	25072	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100X Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			80	20		6005130.36391	2101800.2565200003	37.751433443721	-122.425113497011	(37.751433443721, -122.425113497011)
25390	25390	132077	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012714.4120000005	2120058.1365799997	37.8019909162964	-122.400168938451	(37.8019909162964, -122.400168938451)
32862	32862	132075	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012816.85763	2119903.53523	37.8015721299035	-122.399803563704	(37.8015721299035, -122.399803563704)
37174	37174	132080	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	13	Median : Yard 3	Tree 1	DPW 2			26	Width 10ft		6012562.54875	2120282.53748	37.802598598112	-122.40071023410101	(37.802598598112, -122.400710234101)
48115	48115	132100	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	15	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6012551.63717	2120363.68822	37.802820809805496	-122.400753698321	(37.8028208098055, -122.400753698321)
49479	49479	132094	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6012848.0944	2119927.2949200002	37.8016391096046	-122.39969713882601	(37.8016391096046, -122.399697138826)
56654	56654	132101	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	17	Median : Yard 3	Tree 1	DPW 2			18	Width 10ft		6012520.61539	2120407.16114	37.802938445615	-122.40086410632	(37.802938445615, -122.40086410632)
59618	59618	132097	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			22	Width 10ft		6012695.81427	2120154.0888900002	37.8022533411719	-122.400240038841	(37.8022533411719, -122.400240038841)
61544	61544	132098	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	12	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012646.4501	2120224.08688	37.802442786052396	-122.40041578348699	(37.8024427860524, -122.400415783487)
75574	75574	132078	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6012663.130340001	2120132.51785	37.8021922897941	-122.40035162582899	(37.8021922897941, -122.400351625829)
76777	76777	132095	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012798.77066	2120004.26494	37.801847701082394	-122.39987323058901	(37.8018477010824, -122.399873230589)
129992	129992	132099	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	14	Median : Yard 3	Tree 1	DPW 2			22	Width 10ft		6012592.45443	2120302.68635	37.8026555899447	-122.40060816104099	(37.8026555899447, -122.400608161041)
135157	135157	132081	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	16	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6012501.69351	2120366.8481099997	37.802826700352995	-122.400926752172	(37.802826700353, -122.400926752172)
150555	150555	132096	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6012742.85934	2120080.46122	37.8020538004962	-122.400072065282	(37.8020538004962, -122.400072065282)
164266	164266	132076	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6012766.891340001	2119978.53875	37.8017752858665	-122.399981740966	(37.8017752858665, -122.399981740966)
176286	176286	132079	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	11	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6012611.87531	2120208.19637	37.8023972264213	-122.40053431322399	(37.8023972264213, -122.400534313224)
186566	186566	132093	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6012902.31977	2119848.32419	37.8014252975988	-122.39950394556699	(37.8014252975988, -122.399503945567)
33156	33156	234362	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	4	Median : Yard 3	Tree 1	DPW 2			25			6005144.45634	2101528.47617	37.7506879938715	-122.425045428228	(37.7506879938715, -122.425045428228)
63890	63890	234360	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	2	Median : Yard 3	Tree 1	DPW 2			21			6005142.56045	2101579.1271	37.7508269625113	-122.425055587855	(37.7508269625113, -122.425055587855)
132937	132937	234364	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	6	Median : Yard 3	Tree 1	DPW 2			23			6005148.136969999	2101464.62312	37.7505128760752	-122.425028157637	(37.7505128760752, -122.425028157637)
151204	151204	234363	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	5	Median : Yard 3	Tree 1	DPW 2			25			6005145.85028	2101496.26634	37.7505996318694	-122.425038316369	(37.7505996318694, -122.425038316369)
154721	154721	234361	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	3	Median : Yard 3	Tree 1	DPW 2			27			6005142.97819	2101556.59196	37.75076510982829	-122.42505254004699	(37.7507651098283, -122.425052540047)
158301	158301	234365	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	7	Median : Yard 3	Tree 1	DPW 2			33			6005150.81264	2101423.31762	37.7503996118641	-122.425015966416	(37.7503996118641, -122.425015966416)
151971	151971	194274	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Tennessee St	17	Median : Yard 3	Tree 1	DPW 2			28			6015578.255919999	2103421.32087	37.756469211897	-122.389096301947	(37.756469211897, -122.389096301947)
152917	152917	194273	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Tennessee St	16	Median : Yard 3	Tree 1	DPW 2			20	Width 8ft		6015573.17514	2103426.7647700002	37.7564838780418	-122.38911425333	(37.7564838780418, -122.38911425333)
100172	100172	25080	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1156 DOLORES ST	1	Median : Cutout 11	Tree 1	DPW 2			90	20		6005077.9	2101580.2	37.7508262556468	-122.425279266089	(37.7508262556468, -122.425279266089)
85336	85336	25079	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1162 DOLORES ST	1	Median : Cutout 11	Tree 1	DPW 2			80	20		6005068.3	2101554.8	37.7507559707678	-122.42531065650499	(37.7507559707678, -122.425310656505)
121975	121975	25078	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1166 DOLORES ST	1	Median : Cutout 11	Tree 1	DPW 2			80	20		6005069.8	2101528.7	37.7506843909536	-122.42530361228901	(37.7506843909536, -122.425303612289)
93699	93699	25077	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1178 DOLORES ST	1	Median : Cutout 11	Tree 1	DPW 2			80	20		6005072.5	2101478.6	37.750546980486895	-122.42529071074	(37.7505469804869, -122.42529071074)
92759	92759	25076	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1184 DOLORES ST	1	Median : Cutout 11	Tree 1	DPW 2			80	20		6005073.9	2101453.9	37.750479239095604	-122.42528411198299	(37.7504792390956, -122.425284111983)
81675	81675	25075	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1198 DOLORES ST	1	Median : Cutout 11	Tree 1	DPW 2			80	20		6005087.7	2101404.7	37.7503449269028	-122.425232889951	(37.7503449269028, -122.425232889951)
17316	17316	25084	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200X Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			90	20		6005164.22411	2101175.53736	37.7497200220711	-122.42495196167499	(37.7497200220711, -122.424951961675)
17792	17792	25085	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200X Dolores St	5	Median : Cutout 11	Tree 1	DPW 2			70	20		6005165.443630001	2101134.8464599997	37.7496083631354	-122.424944849843	(37.7496083631354, -122.424944849843)
20716	20716	25082	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200X Dolores St	2	Median : Cutout 11	Tree 1	DPW 2			90	20		6005158.72228	2101250.83835	37.7499264704292	-122.424976344106	(37.7499264704292, -122.424976344106)
21959	21959	25083	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200X Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			90	20		6005162.35719	2101213.31575	37.74982364735521	-122.424961105075	(37.7498236473552, -122.424961105075)
47529	47529	132102	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			17	Width 10ft		6012409.883230001	2120572.1173400003	37.8033851982182	-122.401258897879	(37.8033851982182, -122.401258897879)
65398	65398	132082	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6012375.04896	2120549.1986599998	37.803320325622295	-122.40137783233999	(37.8033203256223, -122.40137783234)
70617	70617	132083	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012328.94165	2120621.527	37.8035163490725	-122.401542475719	(37.8035163490725, -122.401542475719)
176923	176923	132084	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6012274.61558	2120706.35336	37.8037462301721	-122.401736440606	(37.8037462301721, -122.401736440606)
17276	17276	25090	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1250X Dolores St	5	Median : Cutout 11	Tree 1	DPW 2			90	20		6005182.99372	2100845.43458	37.7488146961375	-122.424863573617	(37.7488146961375, -122.424863573617)
19587	19587	25088	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1250X Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			90	20		6005178.85274	2100929.77786	37.7490460494561	-122.424883892899	(37.7490460494561, -122.424883892899)
20929	20929	25087	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1250X Dolores St	2	Median : Cutout 11	Tree 1	DPW 2			90	20		6005179.035519999	2100967.22192	37.7491488725392	-122.42488592444401	(37.7491488725392, -122.424885924444)
21135	21135	25089	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1250X Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			90	20		6005180.26353	2100884.10883	37.748920732509	-122.424875765702	(37.748920732509, -122.424875765702)
20790	20790	25095	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1300 Dolores St	5	Median : Cutout 11	Tree 1	DPW 2			80	20		6005196.77931	2100544.39428	37.7479888873864	-122.424794489489	(37.7479888873864, -122.424794489489)
20879	20879	25092	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1300 Dolores St	2	Median : Cutout 11	Tree 1	DPW 2			80	20		6005189.02223	2100681.47449	37.7483648399821	-122.424831064022	(37.7483648399821, -122.424831064022)
21503	21503	25093	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1300 Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			80	20		6005193.32199	2100633.40551	37.7482330964805	-122.424812776293	(37.7482330964805, -122.424812776293)
17425	17425	25099	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1300X Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			70	20		6005195.84744	2100584.78774	37.7480997459068	-122.42480058509899	(37.7480997459068, -122.424800585099)
17620	17620	25096	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1300X Dolores St	1	Median : Cutout 11	Tree 1	DPW 2			90	20		6005188.030230001	2100718.94336	37.748467664846295	-122.42483715961001	(37.7484676648463, -122.42483715961)
153490	153490	132085	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1300x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012153.585109999	2120867.04559	37.8041806971541	-122.402166580042	(37.8041806971541, -122.402166580042)
148059	148059	248621	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	132x McCoppin St	1	Median : Cutout 11	Tree 1	DPW 2			29	Width 0ft		6005771.7237	2109102.262	37.7715192426118	-122.42341464686501	(37.7715192426118, -122.423414646865)
106112	106112	25094	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1348 Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			40	20		6005177.2486108	2100480.3758406	37.747812004334705	-122.424857472056	(37.7478120043347, -122.424857472056)
19687	19687	25091	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1350 Dolores St	1	Median : Cutout 11	Tree 1	DPW 2			80	20		6005204.68058	2100428.03656	37.7476698420965	-122.42475889070299	(37.7476698420965, -122.424758890703)
17487	17487	25100	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1350X Dolores St	5	Median : Cutout 11	Tree 1	DPW 2			60	20		6005208.528519999	2100314.21379	37.7473575282405	-122.424737488671	(37.7473575282405, -122.424737488671)
17756	17756	25098	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1350X Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			90	20		6005207.855169999	2100363.5353099997	37.7474929157794	-122.424743325238	(37.7474929157794, -122.424743325238)
71379	71379	234345	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1350x Dolores St	6	Median : Yard 3	Tree 1	DPW 2			34			6005211.50018	2100294.54181	37.7473036813364	-122.424725813644	(37.7473036813364, -122.424725813644)
133800	133800	234346	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1350x Dolores St	7	Median : Yard 3	Tree 1	DPW 2			33			6005214.83803	2100265.33674	37.74722367943539	-122.424712194312	(37.7472236794354, -122.424712194312)
19964	19964	703	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1375X Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			70	3X3		6005257.21277	2100319.77841	37.747375556949	-122.424569537574	(37.747375556949, -122.424569537574)
117928	117928	25097	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1388X Dolores St	2	Median : Cutout 11	Tree 1	DPW 2			90	20		6005167.2006822	2100254.8047856004	37.747192070496	-122.424876171578	(37.747192070496, -122.424876171578)
17004	17004	25108	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400 Dolores St	1	Median : Cutout 11	Tree 1	DPW 2			30	20		6005223.671490001	2100130.84124	37.7468548845426	-122.424672082757	(37.7468548845426, -122.424672082757)
17078	17078	25113	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400 Dolores St	6	Median : Cutout 11	Tree 1	DPW 2			30	20		6005228.94357	2100007.06865	37.7465153311328	-122.424645049125	(37.7465153311328, -122.424645049125)
17629	17629	25102	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400X Dolores St	2	Median : Cutout 11	Tree 1	DPW 2			90	20		6005226.05485	2100086.94121	37.7467344797311	-122.424660718923	(37.7467344797311, -122.424660718923)
21388	21388	25107	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400X Dolores St	7	Median : Cutout 11	Tree 1	DPW 2			70	20		6005229.6240300005	2099972.88313	37.7464215039571	-122.424640264758	(37.7464215039571, -122.424640264758)
25048	25048	132103	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			18	Width 10ft		6012095.78368	2120981.89347	37.8044928149639	-122.402374687645	(37.8044928149639, -122.402374687645)
136050	136050	132086	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6011972.21269	2121045.33445	37.8046601095467	-122.402806783124	(37.8046601095467, -122.402806783124)
168474	168474	132105	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6012001.46692	2121074.30881	37.8047412994387	-122.402707584299	(37.8047412994387, -122.402707584299)
177459	177459	132104	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			19	Width 10ft		6012041.8343	2121038.82925	37.8046461349625	-122.402565391602	(37.8046461349625, -122.402565391602)
171600	171600	248622	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	142x McCoppin St	2	Median : Cutout 11	Tree 1	DPW 2			26	Width 0ft		6005746.1935	2109104.2775	37.7715233357229	-122.423503100629	(37.7715233357229, -122.423503100629)
107507	107507	96673	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1449 Mendell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	4x4		6014955.39834	2095258.9558	37.7340225115191	-122.390680007822	(37.7340225115191, -122.390680007822)
20817	20817	25112	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1450 Dolores St	5	Median : Cutout 11	Tree 1	DPW 2			90	20		6005235.506709999	2099747.61613	37.7458033045753	-122.42460390154699	(37.7458033045753, -122.424603901547)
20892	20892	25110	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1450 Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			90	20		6005236.31225	2099800.23492	37.7459478292265	-122.42460485845301	(37.7459478292265, -122.424604858453)
21855	21855	25111	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1450 Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			90	20		6005242.59316	2099769.2409599996	37.745863081619895	-122.424580935573	(37.7458630816199, -122.424580935573)
22048	22048	25106	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1450X Dolores St	6	Median : Cutout 11	Tree 1	DPW 2			90	20		6005241.17775	2099713.8788799997	37.74571099007721	-122.424581892451	(37.7457109900772, -122.424581892451)

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